Global Health Observatory - World Health Organization

CREATE TABLE owid_care_facilities_long_term_care_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "care_facilities_long_term_care" VARCHAR  -- Care Facilities, Long Term Care,
  "care_facilities_long_term_care_low" VARCHAR  -- Care Facilities, Long Term Care Low,
  "care_facilities_long_term_care_high" VARCHAR  -- Care Facilities, Long Term Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_care_seeking_by_type_of_patient_and_source_of_care_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "wealth_quintile" VARCHAR,
  "patient_type" VARCHAR,
  "care_sector" VARCHAR,
  "care_seeking_by_type_of_patient_and_source_of_care_pct" FLOAT  -- Care Seeking By Type Of Patient And Source Of Care, Pct
);

CREATE TABLE owid_care_seeking_by_type_of_patient_and_source_of_care_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "patient_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "care_sector" VARCHAR,
  "care_seeking_by_type_of_patient_and_source_of_care_pct" FLOAT  -- Care Seeking By Type Of Patient And Source Of Care, Pct,
  "care_seeking_by_type_of_patient_and_source_of_care_pct_low" VARCHAR  -- Care Seeking By Type Of Patient And Source Of Care, Pct Low,
  "care_seeking_by_type_of_patient_and_source_of_care_pct_high" VARCHAR  -- Care Seeking By Type Of Patient And Source Of Care, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_care_seeking_for_children_with_symptoms_of_acute__0f5c4795 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "education_level" VARCHAR,
  "care_seeking_for_children_with_symptoms_of_acute_respi_19c79684" FLOAT  -- Care Seeking For Children With Symptoms Of Acute Respiratory Infection, Pct,
  "care_seeking_for_children_with_symptoms_of_acute_respi_3cdf35f0" VARCHAR  -- Care Seeking For Children With Symptoms Of Acute Respiratory Infection, Pct Low,
  "care_seeking_for_children_with_symptoms_of_acute_respi_b7838a77" VARCHAR  -- Care Seeking For Children With Symptoms Of Acute Respiratory Infection, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_care_seeking_for_children_with_symptoms_of_acute__1d468713 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "care_seeking_for_children_with_symptoms_of_acute_respi_19c79684" FLOAT  -- Care Seeking For Children With Symptoms Of Acute Respiratory Infection, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_cases_started_on_mdr_tb_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "cases_started_on_mdr_tb_treatment" UINTEGER
);

CREATE TABLE owid_cases_started_on_mdr_tb_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cases_started_on_mdr_tb_treatment" UINTEGER,
  "cases_started_on_mdr_tb_treatment_low" VARCHAR,
  "cases_started_on_mdr_tb_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_cataract_surgical_coverage_of_adults_aged_50_and__0d8c22d2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cataract_surgical_coverage_of_adults_aged_50_and_over_pct" INTEGER  -- Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct,
  "cataract_surgical_coverage_of_adults_aged_50_and_over_pct_low" VARCHAR  -- Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct Low,
  "cataract_surgical_coverage_of_adults_aged_50_and_over_pct_high" VARCHAR  -- Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_cataract_surgical_coverage_of_adults_aged_50_and__fc40c6fb (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cataract_surgical_coverage_of_adults_aged_50_and_over_pct" INTEGER  -- Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_cautions_and_arrests_for_drink_driving_per_100_00_5a397401 (
  "year" INTEGER,
  "country" VARCHAR,
  "cautions_and_arrests_for_drink_driving_per_100_000_population" FLOAT  -- Cautions And Arrests For Drink Driving, Per 100–000 Population
);

CREATE TABLE owid_cautions_and_arrests_for_drink_driving_per_100_00_7d303f7b (
  "year" INTEGER,
  "country" VARCHAR,
  "cautions_and_arrests_for_drink_driving_per_100_000_population" FLOAT  -- Cautions And Arrests For Drink Driving, Per 100–000 Population,
  "cautions_and_arrests_for_drink_driving_per_100_000_pop_81ee29e3" VARCHAR  -- Cautions And Arrests For Drink Driving, Per 100–000 Population Low,
  "cautions_and_arrests_for_drink_driving_per_100_000_pop_63c68bfd" VARCHAR  -- Cautions And Arrests For Drink Driving, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_cautions_and_arrests_for_public_drunkenness_per_1_090603a0 (
  "year" INTEGER,
  "country" VARCHAR,
  "cautions_and_arrests_for_public_drunkenness_per_100_00_97715a63" FLOAT  -- Cautions And Arrests For Public Drunkenness, Per 100–000 Population
);

CREATE TABLE owid_cautions_and_arrests_for_public_drunkenness_per_1_21cfa8d9 (
  "year" INTEGER,
  "country" VARCHAR,
  "cautions_and_arrests_for_public_drunkenness_per_100_00_97715a63" FLOAT  -- Cautions And Arrests For Public Drunkenness, Per 100–000 Population,
  "cautions_and_arrests_for_public_drunkenness_per_100_00_5c623ea7" VARCHAR  -- Cautions And Arrests For Public Drunkenness, Per 100–000 Population Low,
  "cautions_and_arrests_for_public_drunkenness_per_100_00_cf047b98" VARCHAR  -- Cautions And Arrests For Public Drunkenness, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_central_coordinating_entity_for_alcohol_policy_im_2badc77c (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_coordinating_entities" VARCHAR,
  "central_coordinating_entity_for_alcohol_policy_implementation" VARCHAR
);

CREATE TABLE owid_central_coordinating_entity_for_alcohol_policy_im_daee3b9b (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_coordinating_entities" VARCHAR,
  "central_coordinating_entity_for_alcohol_policy_implementation" VARCHAR,
  "central_coordinating_entity_for_alcohol_policy_impleme_5219db36" VARCHAR  -- Central Coordinating Entity For Alcohol Policy Implementation Low,
  "central_coordinating_entity_for_alcohol_policy_impleme_61fcd682" VARCHAR  -- Central Coordinating Entity For Alcohol Policy Implementation High,
  "comments" VARCHAR
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_currency_reported" VARCHAR  -- Cheapest Brand Of Cigarettes, Currency Reported
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_currency_reported" VARCHAR  -- Cheapest Brand Of Cigarettes, Currency Reported,
  "cheapest_brand_of_cigarettes_currency_reported_low" VARCHAR  -- Cheapest Brand Of Cigarettes, Currency Reported Low,
  "cheapest_brand_of_cigarettes_currency_reported_high" VARCHAR  -- Cheapest Brand Of Cigarettes, Currency Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_price_in_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_price_in_currency_reported" FLOAT  -- Cheapest Brand Of Cigarettes, Price In Currency Reported
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_price_in_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_price_in_currency_reported" FLOAT  -- Cheapest Brand Of Cigarettes, Price In Currency Reported,
  "cheapest_brand_of_cigarettes_price_in_currency_reported_low" VARCHAR  -- Cheapest Brand Of Cigarettes, Price In Currency Reported Low,
  "cheapest_brand_of_cigarettes_price_in_currency_reported_high" VARCHAR  -- Cheapest Brand Of Cigarettes, Price In Currency Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_price_in_pppdollar_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_price_in_pppdollar" FLOAT  -- Cheapest Brand Of Cigarettes, Price In Pppdollar
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_price_in_pppdollar_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_price_in_pppdollar" FLOAT  -- Cheapest Brand Of Cigarettes, Price In Pppdollar,
  "cheapest_brand_of_cigarettes_price_in_pppdollar_low" VARCHAR  -- Cheapest Brand Of Cigarettes, Price In Pppdollar Low,
  "cheapest_brand_of_cigarettes_price_in_pppdollar_high" VARCHAR  -- Cheapest Brand Of Cigarettes, Price In Pppdollar High,
  "comments" VARCHAR
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_price_in_usd_at_offi_40364cc9 (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_price_in_usd_at_official__46bf74d8" FLOAT  -- Cheapest Brand Of Cigarettes, Price In Usd At Official Exchange Rates
);

CREATE TABLE owid_cheapest_brand_of_cigarettes_price_in_usd_at_offi_5fe9d8ae (
  "year" INTEGER,
  "country" VARCHAR,
  "cheapest_brand_of_cigarettes_price_in_usd_at_official__46bf74d8" FLOAT  -- Cheapest Brand Of Cigarettes, Price In Usd At Official Exchange Rates,
  "cheapest_brand_of_cigarettes_price_in_usd_at_official__e4dd340d" VARCHAR  -- Cheapest Brand Of Cigarettes, Price In Usd At Official Exchange Rates Low,
  "cheapest_brand_of_cigarettes_price_in_usd_at_official__a50a5669" VARCHAR  -- Cheapest Brand Of Cigarettes, Price In Usd At Official Exchange Rates High,
  "comments" VARCHAR
);

CREATE TABLE owid_cheapest_breand_of_e_liquid_contains_nicotine_or_not_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "comments" VARCHAR,
  "cheapest_breand_of_e_liquid_contains_nicotine_or_not" VARCHAR
);

CREATE TABLE owid_cheapest_breand_of_e_liquid_contains_nicotine_or_not_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "cheapest_breand_of_e_liquid_contains_nicotine_or_not" VARCHAR,
  "cheapest_breand_of_e_liquid_contains_nicotine_or_not_low" VARCHAR,
  "cheapest_breand_of_e_liquid_contains_nicotine_or_not_high" VARCHAR,
  "comments" VARCHAR
);