Chapter 9 Standardized Vocabulary
While many of the columns (e.g., location, standardized_location) are variable in their output, the types that are used to describe them are drawn from a standardized vocabulary. Here are the data standards for option 2 - long, with explanation for each.
- date: YYYY-MM-DD
- location_type: Continent, Country, State, Province
- location_code_type: fips_code, iso_a3
- data_type: For temporally dynamic data types, use *_new, *_total, or *_current to represent new values for the current day versus cummulative values versus current values of things that can increase or decrease.
9.1 Adding To the Standardized Vocabularies
Below, we list many of the current entries in our standardized vocabulary. If you do not see what you need here, file an issue in the covid19R repo using one of the premade templates, and we will work on adding it.
9.2 Current Location Types
| location_type | description |
|---|---|
| continent | continental scale |
| country | a country with soverign borders |
| state | a spatial area inside that country such as a state, province, canton, etc. |
| county | a spatial area demarcated within a state |
| city | a single municipality - the smallest spatial grain of government in a country |
| canton | the cantons of Switzerland and Principality of Liechtenstein (FL) |
9.3 Current Location Code Types
| location_code_type | description | URL |
|---|---|---|
| fips_code | The federal code in US designating regions of governance | https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt |
| iso_3166 | ISO 3166 is a standard published by the International Organization for Standardization (ISO) that defines codes for the names of countries, dependent territories, special areas of geographical interest, and their principal subdivisions (e.g., provinces or states). | https://en.wikipedia.org/wiki/ISO_3166 |
| iso_3166_2 | ISO 3166-2 is part of the ISO 3166 standard published by the International Organization for Standardization (ISO), and defines codes for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1. | https://en.wikipedia.org/wiki/ISO_3166-2 |
| un_locode | The United Nations Code for Trade and Transport Locations. Covers cities, airports, train stations and other smaller areas of transportation significance. | https://www.unece.org/cefact/locode/welcome.html |
9.4 Current Data Types
| data_type | description |
|---|---|
| cases_new | new confirmed Covid-19 cases during on the current date |
| cases_total | cumulative confirmed Covid-19 cases as of the current date |
| recovered_total | cumulative number of patients recovered as of the current date |
| recovered_new | new number of patients recovered on the current date |
| deaths_new | new deaths on the current date |
| deaths_total | cumulative deaths due to Covid-19 as of the current date |
| tested_total | cumulative number of tests performed as of the date |
| hosp_new | new hospitalizations on the current date |
| hosp_current | current number of hospitalized patients as of the current date |
| icu_current | number of hospitalized patients in ICUs as of the current date |
| vent_current | number of hospitalized patients requiring ventilation as of the current date |
| driving_req_rel_volume | relative volume of driving direction requests from a platform such as Apple Maps |
| walking_req_rel_volume | relative volume of walking direction requests from a platform such as Apple Maps |
| transit_req_rel_volume | relative volume of transit direction requests from a platform such as Apple Maps |
| retail_and_recreation_perc_ch | percent change in visits to retail and recreation within a given area from a geotracking source such as Google |
| grocery_and_pharmacy_perc_ch | percent change in visits to groceries and pharmacies within a given area from a geotracking source such as Google |
| parks_perc_ch | percent change in visits to parks within a given area from a geotracking source such as Google |
| transit_stations_perc_ch | percent change in visits to transit stations within a given area from a geotracking source such as Google |
| workplaces_perc_ch | percent change in visits to places of work within a given area from a geotracking source such as Google |
| residential_perc_ch | percent change in visits to residental locations within a given area from a geotracking source such as Google |