Global Health Observatory - World Health Organization

CREATE TABLE owid_raised_fasting_blood_glucose_gt_7_0_mmol_l_crude__eb51f39d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_crude_estimate" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Crude Estimate,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_crude_estimate_low" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Crude Estimate Low,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_crude_estimate_high" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Crude Estimate High,
  "comments" VARCHAR
);

CREATE TABLE owid_raise_taxes_on_tobacco_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "raise_taxes_on_tobacco" INTEGER
);

CREATE TABLE owid_raise_taxes_on_tobacco_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "raise_taxes_on_tobacco" INTEGER,
  "raise_taxes_on_tobacco_low" VARCHAR,
  "raise_taxes_on_tobacco_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_random_breath_testing_rbt_use_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "random_breath_testing_rbt_use" VARCHAR  -- Random Breath Testing, Rbt, Use
);

CREATE TABLE owid_random_breath_testing_rbt_use_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "random_breath_testing_rbt_use" VARCHAR  -- Random Breath Testing, Rbt, Use,
  "random_breath_testing_rbt_use_low" VARCHAR  -- Random Breath Testing, Rbt, Use Low,
  "random_breath_testing_rbt_use_high" VARCHAR  -- Random Breath Testing, Rbt, Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_recommendations_for_screening_and_brief_intervent_2e4a7db0 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "recommendations_for_screening_and_brief_interventions__94838514" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Antenatal Services,
  "recommendations_for_screening_and_brief_interventions__1af75dba" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Antenatal Services Low,
  "recommendations_for_screening_and_brief_interventions__afb88f7f" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Antenatal Services High,
  "comments" VARCHAR
);

CREATE TABLE owid_recommendations_for_screening_and_brief_intervent_9d2b6be0 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "recommendations_for_screening_and_brief_interventions__b3cf2dfd" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Primary Health Care
);

CREATE TABLE owid_recommendations_for_screening_and_brief_intervent_a2e133e4 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "recommendations_for_screening_and_brief_interventions__b3cf2dfd" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Primary Health Care,
  "recommendations_for_screening_and_brief_interventions__5699b91e" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Primary Health Care Low,
  "recommendations_for_screening_and_brief_interventions__c0ea2a2f" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Primary Health Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_recommendations_for_screening_and_brief_intervent_c347cde9 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "recommendations_for_screening_and_brief_interventions__94838514" VARCHAR  -- Recommendations For Screening And Brief Interventions For Substance Use In Antenatal Services
);

CREATE TABLE owid_reducing_cost_of_delivering_content_in_service_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "reducing_cost_of_delivering_content_in_service" VARCHAR  -- Reducing Cost Of Delivering Content, In Service
);

CREATE TABLE owid_reducing_cost_of_delivering_content_in_service_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "reducing_cost_of_delivering_content_in_service" VARCHAR  -- Reducing Cost Of Delivering Content, In Service,
  "reducing_cost_of_delivering_content_in_service_low" VARCHAR  -- Reducing Cost Of Delivering Content, In Service Low,
  "reducing_cost_of_delivering_content_in_service_high" VARCHAR  -- Reducing Cost Of Delivering Content, In Service High,
  "comments" VARCHAR
);

CREATE TABLE owid_reducing_cost_of_delivering_content_pre_service_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "reducing_cost_of_delivering_content_pre_service" VARCHAR  -- Reducing Cost Of Delivering Content, Pre Service
);

CREATE TABLE owid_reducing_cost_of_delivering_content_pre_service_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "reducing_cost_of_delivering_content_pre_service" VARCHAR  -- Reducing Cost Of Delivering Content, Pre Service,
  "reducing_cost_of_delivering_content_pre_service_low" VARCHAR  -- Reducing Cost Of Delivering Content, Pre Service Low,
  "reducing_cost_of_delivering_content_pre_service_high" VARCHAR  -- Reducing Cost Of Delivering Content, Pre Service High,
  "comments" VARCHAR
);

CREATE TABLE owid_reference_level_for_buildings_with_high_public_oc_3d3e4479 (
  "year" INTEGER,
  "country" VARCHAR,
  "reference_level_for_buildings_with_high_public_occupancy_bq_m3" INTEGER  -- Reference Level For Buildings With High Public Occupancy, Bq M3,
  "reference_level_for_buildings_with_high_public_occupan_5e94531c" VARCHAR  -- Reference Level For Buildings With High Public Occupancy, Bq M3 Low,
  "reference_level_for_buildings_with_high_public_occupan_9e1c96ec" VARCHAR  -- Reference Level For Buildings With High Public Occupancy, Bq M3 High,
  "comments" VARCHAR
);

CREATE TABLE owid_reference_level_for_buildings_with_high_public_oc_9c23db24 (
  "year" INTEGER,
  "country" VARCHAR,
  "reference_level_for_buildings_with_high_public_occupancy_bq_m3" INTEGER  -- Reference Level For Buildings With High Public Occupancy, Bq M3
);

CREATE TABLE owid_reference_level_for_dwellings_bq_m3_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "reference_level_for_dwellings_bq_m3" FLOAT  -- Reference Level For Dwellings, Bq M3
);

CREATE TABLE owid_reference_level_for_dwellings_bq_m3_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "reference_level_for_dwellings_bq_m3" FLOAT  -- Reference Level For Dwellings, Bq M3,
  "reference_level_for_dwellings_bq_m3_low" VARCHAR  -- Reference Level For Dwellings, Bq M3 Low,
  "reference_level_for_dwellings_bq_m3_high" VARCHAR  -- Reference Level For Dwellings, Bq M3 High,
  "comments" VARCHAR
);

CREATE TABLE owid_reference_level_for_workplaces_bq_m3_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "reference_level_for_workplaces_bq_m3" INTEGER  -- Reference Level For Workplaces, Bq M3
);

CREATE TABLE owid_reference_level_for_workplaces_bq_m3_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "reference_level_for_workplaces_bq_m3" INTEGER  -- Reference Level For Workplaces, Bq M3,
  "reference_level_for_workplaces_bq_m3_low" VARCHAR  -- Reference Level For Workplaces, Bq M3 Low,
  "reference_level_for_workplaces_bq_m3_high" VARCHAR  -- Reference Level For Workplaces, Bq M3 High,
  "comments" VARCHAR
);

CREATE TABLE owid_regional_prevalence_aafs_15plus_cancer_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "regional_prevalence_aafs_15plus_cancer" FLOAT  -- Regional Prevalence, Aafs, 15plus, Cancer
);

CREATE TABLE owid_regional_prevalence_aafs_15plus_cancer_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "regional_prevalence_aafs_15plus_cancer" FLOAT  -- Regional Prevalence, Aafs, 15plus, Cancer,
  "regional_prevalence_aafs_15plus_cancer_low" FLOAT  -- Regional Prevalence, Aafs, 15plus, Cancer Low,
  "regional_prevalence_aafs_15plus_cancer_high" FLOAT  -- Regional Prevalence, Aafs, 15plus, Cancer High,
  "comments" VARCHAR
);

CREATE TABLE owid_regional_prevalence_aafs_15plus_liver_cirrhosis_d_b0bf55a3 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "regional_prevalence_aafs_15plus_liver_cirrhosis_deaths_pct" FLOAT  -- Regional Prevalence, Aafs, 15plus, Liver Cirrhosis Deaths, Pct,
  "regional_prevalence_aafs_15plus_liver_cirrhosis_deaths_pct_low" FLOAT  -- Regional Prevalence, Aafs, 15plus, Liver Cirrhosis Deaths, Pct Low,
  "regional_prevalence_aafs_15plus_liver_cirrhosis_deaths_pct_high" FLOAT  -- Regional Prevalence, Aafs, 15plus, Liver Cirrhosis Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_regional_prevalence_aafs_15plus_liver_cirrhosis_d_de536b1e (
  "year" INTEGER,
  "country" VARCHAR,
  "regional_prevalence_aafs_15plus_liver_cirrhosis_deaths_pct" FLOAT  -- Regional Prevalence, Aafs, 15plus, Liver Cirrhosis Deaths, Pct
);

CREATE TABLE owid_regional_prevalence_aafs_15plus_road_traffic_cras_7bcd1009 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "regional_prevalence_aafs_15plus_road_traffic_crash_deaths_pct" FLOAT  -- Regional Prevalence, Aafs, 15plus, Road Traffic Crash Deaths, Pct,
  "regional_prevalence_aafs_15plus_road_traffic_crash_dea_8942bc66" FLOAT  -- Regional Prevalence, Aafs, 15plus, Road Traffic Crash Deaths, Pct Low,
  "regional_prevalence_aafs_15plus_road_traffic_crash_dea_17e233b4" FLOAT  -- Regional Prevalence, Aafs, 15plus, Road Traffic Crash Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_regional_prevalence_aafs_15plus_road_traffic_cras_c808ea1a (
  "year" INTEGER,
  "country" VARCHAR,
  "regional_prevalence_aafs_15plus_road_traffic_crash_deaths_pct" FLOAT  -- Regional Prevalence, Aafs, 15plus, Road Traffic Crash Deaths, Pct
);