Global Health Observatory - World Health Organization

CREATE TABLE owid_availability_of_technical_specifications_of_medic_d0ed934c (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_technical_specifications_of_medical_de_6e745a17" INTEGER  -- Availability Of Technical Specifications Of Medical Devices To Support Procurement Or Donations,
  "comments" VARCHAR
);

CREATE TABLE owid_average_death_rate_due_to_natural_disasters_per_1_51d10da1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "average_death_rate_due_to_natural_disasters_per_100_00_0f4d6a49" FLOAT  -- Average Death Rate Due To Natural Disasters, Per 100–000 Population
);

CREATE TABLE owid_average_death_rate_due_to_natural_disasters_per_1_c12b8d1a (
  "year" INTEGER,
  "country" VARCHAR,
  "average_death_rate_due_to_natural_disasters_per_100_00_0f4d6a49" FLOAT  -- Average Death Rate Due To Natural Disasters, Per 100–000 Population,
  "average_death_rate_due_to_natural_disasters_per_100_00_bfead2b7" VARCHAR  -- Average Death Rate Due To Natural Disasters, Per 100–000 Population Low,
  "average_death_rate_due_to_natural_disasters_per_100_00_b243f3dd" VARCHAR  -- Average Death Rate Due To Natural Disasters, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_of_13_international_health_regulations_co_20d8cb77 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_of_13_international_health_regulations_core_ca_fed6b4cf" FLOAT  -- Average Of 13 International Health Regulations Core Capacity Scores, Spar Version, 1st Edition,
  "average_of_13_international_health_regulations_core_ca_3f1bd263" VARCHAR  -- Average Of 13 International Health Regulations Core Capacity Scores, Spar Version, 1st Edition Low,
  "average_of_13_international_health_regulations_core_ca_87475db4" VARCHAR  -- Average Of 13 International Health Regulations Core Capacity Scores, Spar Version, 1st Edition High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_of_13_international_health_regulations_co_b10bfa6c (
  "year" INTEGER,
  "country" VARCHAR,
  "average_of_13_international_health_regulations_core_ca_2bf5dea6" FLOAT  -- Average Of 13 International Health Regulations Core Capacity Scores, 1st Version Of The Questionnaire,
  "average_of_13_international_health_regulations_core_ca_001590e8" VARCHAR  -- Average Of 13 International Health Regulations Core Capacity Scores, 1st Version Of The Questionnaire Low,
  "average_of_13_international_health_regulations_core_ca_77038e12" VARCHAR  -- Average Of 13 International Health Regulations Core Capacity Scores, 1st Version Of The Questionnaire High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_of_13_international_health_regulations_co_b44bde9c (
  "year" INTEGER,
  "country" VARCHAR,
  "average_of_13_international_health_regulations_core_ca_2bf5dea6" FLOAT  -- Average Of 13 International Health Regulations Core Capacity Scores, 1st Version Of The Questionnaire,
  "comments" VARCHAR
);

CREATE TABLE owid_average_of_13_international_health_regulations_co_e50b38b8 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_of_13_international_health_regulations_core_ca_fed6b4cf" INTEGER  -- Average Of 13 International Health Regulations Core Capacity Scores, Spar Version, 1st Edition,
  "comments" VARCHAR
);

CREATE TABLE owid_average_of_15_international_health_regulations_co_64489955 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_of_15_international_health_regulations_core_ca_3391c3a0" INTEGER  -- Average Of 15 International Health Regulations Core Capacity Scores, Spar Version, 2nd Edition,
  "comments" VARCHAR
);

CREATE TABLE owid_average_of_15_international_health_regulations_co_b7001c06 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_of_15_international_health_regulations_core_ca_3391c3a0" FLOAT  -- Average Of 15 International Health Regulations Core Capacity Scores, Spar Version, 2nd Edition,
  "average_of_15_international_health_regulations_core_ca_a23b1fe9" VARCHAR  -- Average Of 15 International Health Regulations Core Capacity Scores, Spar Version, 2nd Edition Low,
  "average_of_15_international_health_regulations_core_ca_b7cc516c" VARCHAR  -- Average Of 15 International Health Regulations Core Capacity Scores, Spar Version, 2nd Edition High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_price_500_mls_beer_in_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_price_500_mls_beer_in_usd" FLOAT
);

CREATE TABLE owid_average_price_500_mls_beer_in_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_price_500_mls_beer_in_usd" FLOAT,
  "average_price_500_mls_beer_in_usd_low" VARCHAR,
  "average_price_500_mls_beer_in_usd_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_average_price_500_mls_spirits_in_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_price_500_mls_spirits_in_usd" FLOAT
);

CREATE TABLE owid_average_price_500_mls_spirits_in_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_price_500_mls_spirits_in_usd" FLOAT,
  "average_price_500_mls_spirits_in_usd_low" VARCHAR,
  "average_price_500_mls_spirits_in_usd_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_average_price_750_mls_wine_in_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_price_750_mls_wine_in_usd" FLOAT
);

CREATE TABLE owid_average_price_750_mls_wine_in_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_price_750_mls_wine_in_usd" FLOAT,
  "average_price_750_mls_wine_in_usd_low" VARCHAR,
  "average_price_750_mls_wine_in_usd_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_ad_valo_1b09cedc (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_ad_valorem_excise" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Ad Valorem Excise,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_ad_valo_98b745c7 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_ad_valorem_excise" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Ad Valorem Excise,
  "average_taxes_as_a_pct_of_cigarette_price_ad_valorem_excise_low" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Ad Valorem Excise Low,
  "average_taxes_as_a_pct_of_cigarette_price_ad_valorem_e_1bf75f90" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Ad Valorem Excise High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_import_duties_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_import_duties" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Import Duties,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_import_duties_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_import_duties" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Import Duties,
  "average_taxes_as_a_pct_of_cigarette_price_import_duties_low" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Import Duties Low,
  "average_taxes_as_a_pct_of_cigarette_price_import_duties_high" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Import Duties High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_other_taxes_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_other_taxes" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Other Taxes,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_other_taxes_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_other_taxes" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Other Taxes,
  "average_taxes_as_a_pct_of_cigarette_price_other_taxes_low" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Other Taxes Low,
  "average_taxes_as_a_pct_of_cigarette_price_other_taxes_high" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Other Taxes High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_specifi_41947c6b (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_specific_excise" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Specific Excise,
  "average_taxes_as_a_pct_of_cigarette_price_specific_excise_low" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Specific Excise Low,
  "average_taxes_as_a_pct_of_cigarette_price_specific_excise_high" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Specific Excise High,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_specifi_4ea0e0a7 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_specific_excise" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Specific Excise,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_total_tax_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_total_tax" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Total Tax,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_total_tax_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_total_tax" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Total Tax,
  "average_taxes_as_a_pct_of_cigarette_price_total_tax_low" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Total Tax Low,
  "average_taxes_as_a_pct_of_cigarette_price_total_tax_high" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Total Tax High,
  "comments" VARCHAR
);