Global Health Observatory - World Health Organization

CREATE TABLE owid_compliance_with_smoke_free_pubs_and_bars_law_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_pubs_and_bars_law_score" INTEGER  -- Compliance With Smoke Free Pubs And Bars Law, Score,
  "compliance_with_smoke_free_pubs_and_bars_law_score_low" VARCHAR  -- Compliance With Smoke Free Pubs And Bars Law, Score Low,
  "compliance_with_smoke_free_pubs_and_bars_law_score_high" VARCHAR  -- Compliance With Smoke Free Pubs And Bars Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_restaurants_law_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_restaurants_law_score" INTEGER  -- Compliance With Smoke Free Restaurants Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_restaurants_law_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_restaurants_law_score" INTEGER  -- Compliance With Smoke Free Restaurants Law, Score,
  "compliance_with_smoke_free_restaurants_law_score_low" VARCHAR  -- Compliance With Smoke Free Restaurants Law, Score Low,
  "compliance_with_smoke_free_restaurants_law_score_high" VARCHAR  -- Compliance With Smoke Free Restaurants Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_universities_law_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_universities_law_score" INTEGER  -- Compliance With Smoke Free Universities Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_universities_law_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_universities_law_score" INTEGER  -- Compliance With Smoke Free Universities Law, Score,
  "compliance_with_smoke_free_universities_law_score_low" VARCHAR  -- Compliance With Smoke Free Universities Law, Score Low,
  "compliance_with_smoke_free_universities_law_score_high" VARCHAR  -- Compliance With Smoke Free Universities Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_composite_coverage_index_pct_1 (
  "year" INTEGER,
  "country" 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,
  "composite_coverage_index_pct" FLOAT  -- Composite Coverage Index, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_composite_coverage_index_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "composite_coverage_index_pct" FLOAT  -- Composite Coverage Index, Pct,
  "composite_coverage_index_pct_low" FLOAT  -- Composite Coverage Index, Pct Low,
  "composite_coverage_index_pct_high" FLOAT  -- Composite Coverage Index, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_comprehensive_and_regular_reporting_of_alcohol_situation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "comprehensive_and_regular_reporting_of_alcohol_situation" VARCHAR
);

CREATE TABLE owid_comprehensive_and_regular_reporting_of_alcohol_situation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "comprehensive_and_regular_reporting_of_alcohol_situation" VARCHAR,
  "comprehensive_and_regular_reporting_of_alcohol_situation_low" VARCHAR,
  "comprehensive_and_regular_reporting_of_alcohol_situation_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_comprehensive_bans_in_place_subnationally_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "comprehensive_bans_in_place_subnationally" VARCHAR
);

CREATE TABLE owid_comprehensive_bans_in_place_subnationally_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "comprehensive_bans_in_place_subnationally" VARCHAR,
  "comprehensive_bans_in_place_subnationally_low" VARCHAR,
  "comprehensive_bans_in_place_subnationally_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compulsory_treatment_for_people_with_alcohol_use__7039563d (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "compulsory_treatment_for_people_with_alcohol_use_disor_5db21443" VARCHAR  -- Compulsory Treatment For People With Alcohol Use Disorders In The Criminal Justice System
);

CREATE TABLE owid_compulsory_treatment_for_people_with_alcohol_use__8051890f (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "compulsory_treatment_for_people_with_alcohol_use_disor_5db21443" VARCHAR  -- Compulsory Treatment For People With Alcohol Use Disorders In The Criminal Justice System,
  "compulsory_treatment_for_people_with_alcohol_use_disor_df433751" VARCHAR  -- Compulsory Treatment For People With Alcohol Use Disorders In The Criminal Justice System Low,
  "compulsory_treatment_for_people_with_alcohol_use_disor_74e84a97" VARCHAR  -- Compulsory Treatment For People With Alcohol Use Disorders In The Criminal Justice System High,
  "comments" VARCHAR
);

CREATE TABLE owid_compulsory_treatment_for_people_with_drug_use_dis_5d78e1c4 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "compulsory_treatment_for_people_with_drug_use_disorder_0262e461" VARCHAR  -- Compulsory Treatment For People With Drug Use Disorders In The Criminal Justice System,
  "compulsory_treatment_for_people_with_drug_use_disorder_79757af8" VARCHAR  -- Compulsory Treatment For People With Drug Use Disorders In The Criminal Justice System Low,
  "compulsory_treatment_for_people_with_drug_use_disorder_368dbdae" VARCHAR  -- Compulsory Treatment For People With Drug Use Disorders In The Criminal Justice System High,
  "comments" VARCHAR
);

CREATE TABLE owid_compulsory_treatment_for_people_with_drug_use_dis_e8f37be0 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "compulsory_treatment_for_people_with_drug_use_disorder_0262e461" VARCHAR  -- Compulsory Treatment For People With Drug Use Disorders In The Criminal Justice System
);

CREATE TABLE owid_concentrations_of_fine_particulate_matter_pm2_5_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "concentrations_of_fine_particulate_matter_pm2_5" FLOAT  -- Concentrations Of Fine Particulate Matter, Pm2–5
);

CREATE TABLE owid_concentrations_of_fine_particulate_matter_pm2_5_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "concentrations_of_fine_particulate_matter_pm2_5" FLOAT  -- Concentrations Of Fine Particulate Matter, Pm2–5,
  "concentrations_of_fine_particulate_matter_pm2_5_low" FLOAT  -- Concentrations Of Fine Particulate Matter, Pm2–5 Low,
  "concentrations_of_fine_particulate_matter_pm2_5_high" FLOAT  -- Concentrations Of Fine Particulate Matter, Pm2–5 High,
  "comments" VARCHAR
);

CREATE TABLE owid_confidentiality_of_health_records_on_substance_us_23e06589 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "confidentiality_of_health_records_on_substance_use_dis_c9dda41d" VARCHAR  -- Confidentiality Of Health Records On Substance Use Disorders Protected By Law
);

CREATE TABLE owid_confidentiality_of_health_records_on_substance_us_74e02c33 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "confidentiality_of_health_records_on_substance_use_dis_c9dda41d" VARCHAR  -- Confidentiality Of Health Records On Substance Use Disorders Protected By Law,
  "confidentiality_of_health_records_on_substance_use_dis_9adf93e3" VARCHAR  -- Confidentiality Of Health Records On Substance Use Disorders Protected By Law Low,
  "confidentiality_of_health_records_on_substance_use_dis_dbf69a4d" VARCHAR  -- Confidentiality Of Health Records On Substance Use Disorders Protected By Law High,
  "comments" VARCHAR
);

CREATE TABLE owid_confidentiality_of_people_in_treatment_for_substa_0fd8308c (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "confidentiality_of_people_in_treatment_for_substance_u_f26fcfcc" VARCHAR  -- Confidentiality Of People In Treatment For Substance Use Disorders
);

CREATE TABLE owid_confidentiality_of_people_in_treatment_for_substa_8eb95987 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "confidentiality_of_people_in_treatment_for_substance_u_f26fcfcc" VARCHAR  -- Confidentiality Of People In Treatment For Substance Use Disorders,
  "confidentiality_of_people_in_treatment_for_substance_u_d09a8262" VARCHAR  -- Confidentiality Of People In Treatment For Substance Use Disorders Low,
  "confidentiality_of_people_in_treatment_for_substance_u_9ee695dc" VARCHAR  -- Confidentiality Of People In Treatment For Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_confirmed_cases_of_mdr_tb_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "confirmed_cases_of_mdr_tb" UINTEGER
);

CREATE TABLE owid_confirmed_cases_of_mdr_tb_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "confirmed_cases_of_mdr_tb" UINTEGER,
  "confirmed_cases_of_mdr_tb_low" VARCHAR,
  "confirmed_cases_of_mdr_tb_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_confirmed_cases_of_mdr_tb_started_treatment_for_m_580729e5 (
  "year" INTEGER,
  "country" VARCHAR,
  "confirmed_cases_of_mdr_tb_started_treatment_for_mdr_tb_pct" FLOAT  -- Confirmed Cases Of Mdr Tb Started Treatment For Mdr Tb, Pct,
  "confirmed_cases_of_mdr_tb_started_treatment_for_mdr_tb_pct_low" VARCHAR  -- Confirmed Cases Of Mdr Tb Started Treatment For Mdr Tb, Pct Low,
  "confirmed_cases_of_mdr_tb_started_treatment_for_mdr_tb_pct_high" VARCHAR  -- Confirmed Cases Of Mdr Tb Started Treatment For Mdr Tb, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_confirmed_cases_of_mdr_tb_started_treatment_for_m_c6637770 (
  "year" INTEGER,
  "country" VARCHAR,
  "confirmed_cases_of_mdr_tb_started_treatment_for_mdr_tb_pct" FLOAT  -- Confirmed Cases Of Mdr Tb Started Treatment For Mdr Tb, Pct
);