Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_off_premise_sales_restrictions_on_places_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_places" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_places_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_places" VARCHAR,
"off_premise_sales_restrictions_on_places_low" VARCHAR,
"off_premise_sales_restrictions_on_places_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_one_year_old_children_who_have_not_received_any_d_7c8a9c1c (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"residence_area_type" VARCHAR,
"education_level" VARCHAR,
"one_year_old_children_who_have_not_received_any_doses__d1b4b189" FLOAT -- One Year Old Children Who Have Not Received Any Doses Of The Dtp Vaccine, Pct,
"one_year_old_children_who_have_not_received_any_doses__b4893ea8" FLOAT -- One Year Old Children Who Have Not Received Any Doses Of The Dtp Vaccine, Pct Low,
"one_year_old_children_who_have_not_received_any_doses__a2754766" FLOAT -- One Year Old Children Who Have Not Received Any Doses Of The Dtp Vaccine, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_one_year_old_children_who_have_not_received_any_d_ef108c2f (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"one_year_old_children_who_have_not_received_any_doses__d1b4b189" FLOAT -- One Year Old Children Who Have Not Received Any Doses Of The Dtp Vaccine, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_at_specific_events_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_at_specific_events" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_at_specific_events_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_at_specific_events" VARCHAR,
"on_premise_sales_restrictions_at_specific_events_low" VARCHAR,
"on_premise_sales_restrictions_at_specific_events_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_days_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_days" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_days_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_days" VARCHAR,
"on_premise_sales_restrictions_on_days_low" VARCHAR,
"on_premise_sales_restrictions_on_days_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_hours_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_hours" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_hours_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_hours" VARCHAR,
"on_premise_sales_restrictions_on_hours_low" VARCHAR,
"on_premise_sales_restrictions_on_hours_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_outlet_density_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_outlet_density" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_outlet_density_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_outlet_density" VARCHAR,
"on_premise_sales_restrictions_on_outlet_density_low" VARCHAR,
"on_premise_sales_restrictions_on_outlet_density_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_places_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_places" VARCHAR
);
CREATE TABLE owid_on_premise_sales_restrictions_on_places_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"on_premise_sales_restrictions_on_places" VARCHAR,
"on_premise_sales_restrictions_on_places_low" VARCHAR,
"on_premise_sales_restrictions_on_places_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_open_access_interventions_for_alcohol_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_open_access_services" VARCHAR,
"open_access_interventions_for_alcohol" VARCHAR
);
CREATE TABLE owid_open_access_interventions_for_alcohol_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_open_access_services" VARCHAR,
"open_access_interventions_for_alcohol" VARCHAR,
"open_access_interventions_for_alcohol_low" VARCHAR,
"open_access_interventions_for_alcohol_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_open_access_interventions_for_drugs_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_open_access_services" VARCHAR,
"open_access_interventions_for_drugs" VARCHAR
);
CREATE TABLE owid_open_access_interventions_for_drugs_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_open_access_services" VARCHAR,
"open_access_interventions_for_drugs" VARCHAR,
"open_access_interventions_for_drugs_low" VARCHAR,
"open_access_interventions_for_drugs_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_open_access_services_for_substance_use_disorders_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_open_access_services" VARCHAR,
"open_access_services_for_substance_use_disorders" VARCHAR
);
CREATE TABLE owid_open_access_services_for_substance_use_disorders_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_open_access_services" VARCHAR,
"open_access_services_for_substance_use_disorders" VARCHAR,
"open_access_services_for_substance_use_disorders_low" VARCHAR,
"open_access_services_for_substance_use_disorders_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_opioid_agonist_pharmacotherapy_for_the_treatment__1c99b108 (
"year" INTEGER,
"country" VARCHAR,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_0bada4e7" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Detoxification Or Maintenance
);
CREATE TABLE owid_opioid_agonist_pharmacotherapy_for_the_treatment__6296d46d (
"year" INTEGER,
"country" VARCHAR,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_b80de188" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Maintenance
);
CREATE TABLE owid_opioid_agonist_pharmacotherapy_for_the_treatment__9dc9cbb9 (
"year" INTEGER,
"country" VARCHAR,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_b80de188" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Maintenance,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_7b38a035" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Maintenance Low,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_146d9f9d" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Maintenance High,
"comments" VARCHAR
);
CREATE TABLE owid_opioid_agonist_pharmacotherapy_for_the_treatment__e70915aa (
"year" INTEGER,
"country" VARCHAR,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_0bada4e7" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Detoxification Or Maintenance,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_c9af6b80" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Detoxification Or Maintenance Low,
"opioid_agonist_pharmacotherapy_for_the_treatment_of_op_c24610a8" VARCHAR -- Opioid Agonist Pharmacotherapy For The Treatment Of Opioid Dependence, Detoxification Or Maintenance High,
"comments" VARCHAR
);
CREATE TABLE owid_oral_health_basic_restorative_dental_procedures_t_066637cc (
"year" INTEGER,
"country" VARCHAR,
"oral_health_basic_restorative_dental_procedures_to_tre_da9b0a74" VARCHAR -- Oral Health, Basic Restorative Dental Procedures To Treat Existing Dental Decay
);
Anyone who has the link will be able to view this.