Table 3 Schema for GOVERNMENT_RESPONSE table.
Name | Type | Description |
|---|---|---|
Source | Varchar | Specify data source |
Date | Date | Day of the statistics |
Gid | Array | Unique geographical ID, for more details see gadm.org |
Country | Varchar | English name for the country |
Countrycode | Varchar | ISO 3166-1 alpha-3 country codes |
Adm_area_1 | Varchar | Level-1 administrative country subdivision |
Adm_area_2 | Varchar | Level-2 administrative country subdivision |
Adm_area_3 | Varchar | Level-3 administrative country subdivision |
c1_school_closing | Integer | Record closings of schools and universities |
c1_flag | Integer | Binary flag for geographic scope |
c2_workplace_closing | Integer | Record closings of workplaces |
c2_flag | Integer | Binary flag for geographic scope |
c3_cancel_public_events | Integer | Record cancelling public events |
c3_flag | Integer | Binary flag for geographic scope |
c4_restrictions_on_gatherings | Integer | Record limits on private gatherings |
c4_flag | Integer | Binary flag for geographic scope |
c5_close_public_transport | Integer | Record closing of public transport |
c5_flag | Integer | Binary flag for geographic scope |
c6_stay_at_home_requirements | Integer | Record orders to “shelter-in-place” and otherwise confine to the home |
c6_flag | Integer | Binary flag for geographic scope |
c7_restrictions_on_internal_movement | Integer | Record restrictions on internal movement between cities/regions |
c7_flag | Integer | Binary flag for geographic scope |
c8_international_travel_controls | Integer | Record restrictions on international travel. Note: this records policy for foreign travellers, not citizens |
e1_income_support | Integer | 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 | integer | Binary flag for geographic scope |
e2_debtcontract_relief | Integer | 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 spending |
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 | Integer | Record presence of public info campaigns |
h1_flag | Integer | Binary flag for geographic scope |
h2_testing_policy | Integer | 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) |
Continued | ||
h3_contact_tracing | Integer | Record government policy on contact tracing after a positive diagnosis. Note: we are looking for policies that would identify all people potentially exposed to Covid-19; voluntary bluetooth apps are unlikely to achieve this |
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 component 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 containing all above indicators with full description stored in JSON format. |
