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