COVID-19, Government Response Tracker (OxCGRT)
@owid.oxcgrt_policy
@owid.oxcgrt_policy
CREATE TABLE owid_country_counts (
"country" VARCHAR,
"date" TIMESTAMP,
"restriction_name" VARCHAR,
"restriction_degree" INTEGER,
"num_countries" INTEGER
);
CREATE TABLE owid_oxcgrt_policy (
"country" VARCHAR,
"date" TIMESTAMP,
"c1m_school_closing" INTEGER,
"c2m_workplace_closing" INTEGER,
"c3m_cancel_public_events" INTEGER,
"c4m_restrictions_on_gatherings" INTEGER,
"c5m_close_public_transport" INTEGER,
"c6m_stay_at_home_requirements" INTEGER,
"c7m_restrictions_on_internal_movement" INTEGER,
"c8ev_international_travel_controls" INTEGER,
"e1_income_support" INTEGER,
"e2_debt_contract_relief" INTEGER,
"e3_fiscal_measures" FLOAT,
"e4_international_support" FLOAT,
"h1_public_information_campaigns" INTEGER,
"h2_testing_policy" INTEGER,
"h3_contact_tracing" INTEGER,
"h4_emergency_investment_in_healthcare" FLOAT,
"h5_investment_in_vaccines" FLOAT,
"h6m_facial_coverings" INTEGER,
"h7_vaccination_policy" INTEGER,
"v2a_vaccine_availability_summary" INTEGER,
"v2b_vaccine_age_eligibility_availability_age_floor_gen_787eb10e" VARCHAR,
"v2c_vaccine_age_eligibility_availability_age_floor_at__887dbaa6" VARCHAR,
"stringency_index" FLOAT,
"containment_health_index" FLOAT,
"v2_vaccine_availability_summary" INTEGER,
"v2_pregnant_people" INTEGER,
"stringency_index_nonvax" FLOAT,
"stringency_index_vax" FLOAT,
"stringency_index_weighted_average" FLOAT
);
Anyone who has the link will be able to view this.