Understanding the Global Impact of COVID-19
through Data Science

Data Structures for OxCOVID19 Database

Schemas for OxCOVID19

There are currenlty six Tables in Oxford Covid-19 (OxCOVID19) Database with the data structures (Schemas) shown below.

Note 1: We collect the data as they come from the indicated data sources. It is possible that different sources provide different statistics.

Note 2: The data structure might change in the future as more data becomes available or data sources change. We will do our best to maintain backward compatibility.

Schema for EPIDEMIOLOGY table

Name Data type Description
SOURCE VARCHAR Data source
DATE DATE Day of the statistics
GID ARRAY Unique geographical ID, for more details see GADM
COUNTRY VARCHAR English name for the country
COUNTRYCODE VARCHAR(3) ISO 3166-1 alpha-3 country codes
ADM_AREA_1 VARCHAR First-level administrative country subdivision
ADM_AREA_2 VARCHAR Second-level administrative country subdivision
ADM_AREA_3 VARCHAR Third-level administrative country subdivision
TESTED INT Number of people tested [cumulative]
CONFIRMED INT Number of confirmed cases [cumulative]
DEAD INT Number of deaths [cumulative]
RECOVERED INT Number of confirmed who recovered [cumulative]
HOSPITALISED INT Number of confirmed who are/have been hospitalised [cumulative]
HOSPITALISED_ICU INT Number of confirmed who are/have been in the intensive care [cumulative]
QUARANTINED INT Number of confirmed with home quarantine [cumulative]

Schema for GOVERNMENT_RESPONSE table

The government response data comes from the Coronavirus Government Response Tracker assembled by researchers from the Blavatnik School of Government, University of Oxford. The data are being collected from publicly available sources including news articles and government press releases and briefings.
Name Data type Description
SOURCE VARCHAR Data source
DATE DATE Day of the statistics
GID ARRAY Unique geographical ID, for more details see GADM
COUNTRY VARCHAR English name for the country
COUNTRYCODE VARCHAR(3) ISO 3166-1 alpha-3 country codes
ADM_AREA_1 VARCHAR First-level administrative country subdivision
ADM_AREA_2 VARCHAR Second-level administrative country subdivision
ADM_AREA_3 VARCHAR Third-level administrative country subdivision
ADM_AREA_3 VARCHAR Third-level administrative country subdivision
C1_SCHOOL_CLOSING INT Record closings of schools and universities
C1_FLAG INT Binary flag for geographic scope
C2_WORKPLACE_CLOSING INT Record closings of workplaces
C2_FLAG INT Binary flag for geographic scope
C3_CANCEL_PUBLIC_EVENTS INT Record cancelling public events
C3_FLAG INT Binary flag for geographic scope
C4_RESTRICTIONS_ON_GATHERINGS INT Record limits on private gatherings
C4_FLAG INT Binary flag for geographic scope
C5_CLOSE_PUBLIC_TRANSPORT INT Record closing of public transport
C5_FLAG INT Binary flag for geographic scope
C6_STAY_AT_HOME_REQUIREMENTS INT Record orders to "shelter-in-place" and otherwise confine to the home
C6_FLAG INT Binary flag for geographic scope
C7_RESTRICTIONS_ON_INTERNAL_MOVEMENT INT Record restrictions on internal movement between cities/regions
C7_FLAG INT Binary flag for geographic scope
C8_INTERNATIONAL_TRAVEL_CONTROLS INT Record restrictions on international travel. Note: this records policy for foreign travellers, not citizens
E1_INCOME_SUPPORT INT Record if the government is providing direct cash payments to people who lose their jobs or cannot work. Note: only includes payments to firms if explicitly linked to payroll/salaries
E1_FLAG INT Binary flag for geographic scope
E2_DEBTCONTRACT_RELIEF INT Record if the government is freezing financial obligations for households (eg stopping loan repayments, preventing services like water from stopping, or banning evictions)
E3_FISCAL_MEASURES FLOAT Announced economic stimulus spending. Note: only record amount additional to previously announced spendings
E4_INTERNATIONAL_SUPPORT FLOAT Announced offers of Covid-19 related aid spending to other countries. Note: only record amount additional to previously announced spending
H1_PUBLIC_INFORMATION_CAMPAIGNS INT Record presence of public info campaigns
H1_FLAG INT Binary flag for geographic scope
H2_TESTING_POLICY INT Record government policy on who has access to testing. Note: this records policies about testing for current infection (PCR tests) not testing for immunity (antibody test)
H3_CONTACT_TRACING INT Record government policy on contact tracing after a positive diagnosis
H4_EMERGENCY_INVESTMENT_IN_HEALTHCARE FLOAT Announced short term spending on healthcare system, e.g. hospitals, masks, etc. Note: only record amount additional to previously announced spending
H5_INVESTMENT_IN_VACCINES FLOAT Announced public spending on Covid-19 vaccine development. Note: only record amount additional to previously announced spending
M1_WILDCARD VARCHAR Record policy announcements that do not fit anywhere else
STRINGENCY_INDEX FLOAT Calculated as a function of the individual indicators
STRINGENCY_INDEXFORDISPLAY FLOAT Calculated as a function of the individual indicators
STRINGENCY_LEGACY_INDEX FLOAT Calculated as a function of the individual indicators
STRINGENCY_LEGACY_INDEXFORDISPLAY FLOAT Calculated as a function of the individual indicators
GOVERNMENT_RESPONSE_INDEX FLOAT Calculated as a function of the individual indicators
GOVERNMENT_RESPONSE_INDEX_FOR_DISPLAY FLOAT Calculated as a function of the individual indicators
CONTAINMENT_HEALTH_INDEX FLOAT Calculated as a function of the individual indicators
CONTAINMENT_HEALTH_INDEX_FOR_DISPLAY FLOAT Calculated as a function of the individual indicators
ECONOMIC_SUPPORT_INDEX FLOAT Calculated as a function of the individual indicators
ECONOMIC_SUPPORT_INDEX_FOR_DISPLAY FLOAT Calculated as a function of the individual indicators
ACTIONS JSONB Raw response from Covid Tracker API Covid Tracker API containing all above indicators with full description stored in JSON format

Schema for COUNTRY_STATISTICS table

Name Data type Description
SOURCE VARCHAR Data source
YEAR INT Day of the statistics
GID ARRAY Unique geographical ID, for more details see GADM
COUNTRY VARCHAR English name for the country
COUNTRYCODE VARCHAR(3) ISO 3166-1 alpha-3 country codes
ADM_LEVEL VARCHAR Aggregation level, 0 for World Bank and Integrated Value Survey by country, 1 for Integrated Value Survey by region
SAMPLESIZE VARCHAR Number of questions for Integrated Value Survey, -1 for World Bank
PROPERTIES VARCHAR Dictionary containing the region/country statistics. For the full details on included variables consider the hyperlink above

Schema for MOBILITY table

Name Data type Description
SOURCE VARCHAR Data source
DATE DATE Day of the statistics
GID ARRAY Unique geographical ID, for more details see GADM
COUNTRY VARCHAR English name for the country
COUNTRYCODE VARCHAR(3) ISO 3166-1 alpha-3 country codes
ADM_AREA_1 VARCHAR First-level administrative country subdivision
ADM_AREA_2 VARCHAR Second-level administrative country subdivision
ADM_AREA_3 VARCHAR Third-level administrative country subdivision
TRANSIT_STATIONS FLOAT Mobility trends reported by Google for places like public transport hubs such as subway, bus, and train stations
RESIDENTIAL FLOAT Mobility trends reported by Google for places of residence
WORKPLACE FLOAT Mobility trends reported by Google for places of work
PARKS FLOAT Mobility trends reported by Google for places like local parks, national parks, public beaches, marinas, dog parks, plazas, and public gardens
RETAIL_RECREATION FLOAT Mobility trends reported Google for places like restaurants, cafes, shopping centers, theme parks, museums, libraries, and movie theaters
GROCERY_FARMACY FLOAT Mobility trends reported by Google for places like grocery markets, food warehouses, farmers markets, specialty food shops, drug stores, and pharmacies
TRANSIT FLOAT The change in volume reported by Apple of people taking public transit in their communities
WALKING FLOAT The change in volume reported by Apple of people walking in their communitie
DRIVING FLOAT The change in volume reported by Apple of people driving taking public transit in their communities

Schema for WEATHER table

We aggregated the daily weather data from Met Office Informatics LAB (for more details see Data Sources) at the second GADM level for every country in the World. For each Level-2 GID region all the points in the grid that are contained in the region have been located. Then for a fixed Level-2 GID region and given variable (e.g. maximum daily precipitation, minimum daily temperature etc.) the average and standard deviation of the considered variable in those grid points is reported.
Name Data type Description
DATE DATE Day of the statistics
GID VARCHAR Unique geographical ID, for more details see GADM
COUNTRY VARCHAR English name for the country
COUNTRYCODE VARCHAR(3) ISO 3166-1 alpha-3 country codes
PRECIP_MAX_AVG FLOAT Average of the daily maximum precipitation
PRECIP_MAX_STD FLOAT Standard deviation of the daily maximum precipitation
PRECIP_MEAN_AVG FLOAT Average of the daily mean precipitation
PRECIP_MEAN_STD FLOAT Standard deviation of the daily mean precipitation
SPECIFIC_HUMIDITY_MAX_AVG FLOAT Average of the daily maximum specific humidity
SPECIFIC_HUMIDITY_MAX_STD FLOAT Standard deviation of the daily maximum specific humidity
SPECIFIC_HUMIDITY_MEAN_AVG FLOAT Average of the daily mean specific humidity
SPECIFIC_HUMIDITY_MEAN_STD FLOAT Standard deviation of the daily mean specific humidity
SPECIFIC_HUMIDITY_MIN_AVG FLOAT Average of the daily minimum specific humidity
SPECIFIC_HUMIDITY_MIN_STD FLOAT Standard deviation of the daily minimum specific humidity
SHORT_WAVE_RADIATION_MAX_AVG FLOAT Average of the daily maximum short wave radiation
SHORT_WAVE_RADIATION_MAX_STD FLOAT Standard deviation of the daily maximum short wave radiation
SHORT_WAVE_RADIATION_MEAN_AVG FLOAT Average of the daily minimum short wave radiation
SHORT_WAVE_RADIATION_MEAN_STD FLOAT Standard deviation of the daily minimum short wave radiation
TEMPERATURE_MAX_AVG FLOAT Average of the daily maximum temperature
TEMPERATURE_MAX_STD FLOAT Standard deviation of the daily maximum temperature
TEMPERATURE_MEAN_AVG FLOAT Average of the daily mean temperature
TEMPERATURE_MEAN_STD FLOAT Standard deviation of the daily mean temperature
TEMPERATURE_MIN_AVG FLOAT Average of the daily minimum temperature
TEMPERATURE_MIN_STD FLOAT Standard deviation of the daily minimum temperature
WINDGUST_MAX_AVG FLOAT Average of the daily maximum wind gust
WINDGUST_MAX_STD FLOAT Standard deviation of the daily maximum wind gust
WINDGUST_MEAN_AVG FLOAT Average of the daily mean wind gust
WINDGUST_MEAN_STD FLOAT Standard deviation of the daily mean wind gust
WINDGUST_MIN_AVG FLOAT Average of the daily minimum wind gust
WINDGUST_MIN_STD FLOAT Standard deviation of the daily minimum wind gust
WINDSPEED_MAX_AVG FLOAT Average of the daily maximum wind speed
WINDSPEED_MAX_STD FLOAT Standard deviation of the daily maximum wind speed
WINDSPEED_MEAN_AVG FLOAT Average of the daily mean wind speed
WINDSPEED_MEAN_STD FLOAT Standard deviation of the daily mean wind speed
WINDSPEED_MIN_AVG FLOAT Average of the daily minimum wind speed
WINDSPEED_MIN_STD FLOAT Standard deviation of the daily minimum wind speed

Schema for ADMINISTRATIVE_DIVISION table

Name Data type Description
GID VARCHAR Unique geographical ID, for more details see GADM
COUNTRY VARCHAR English name for the country
COUNTRYCODE VARCHAR(3) ISO 3166-1 alpha-3 country codes
COUNTRYCODE_ALPHA2 VARCHAR ISO 3166-1 alpha-2 country codes
ADM_AREA_1 VARCHAR First-level administrative country subdivision
ADM_AREA_1_CODE VARCHAR First-level administrative country code subdivision
ADM_AREA_2 VARCHAR Second-level administrative country subdivision
ADM_AREA_2_CODE VARCHAR Second-level administrative country code subdivision
ADM_AREA_3 VARCHAR Third-level administrative country subdivision
ADM_AREA_3_CODE VARCHAR Third-level administrative country code subdivision
ADM_LEVEL INTEGER 0 - for countries level, 1 - for regions etc.
LATITUDE FLOAT Geographic coordinate of region's centroid
LONGTITUDE FLOAT Geographic coordinate of region's centroid
PROPERTIES JSON Additional attributes describing region
GEOMETRY GEOMETRY Polygon describing geographical area