Global Health Observatory - World Health Organization

CREATE TABLE owid_surveys_research_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "surveys_research" VARCHAR  -- Surveys, Research,
  "surveys_research_low" VARCHAR  -- Surveys, Research Low,
  "surveys_research_high" VARCHAR  -- Surveys, Research High,
  "comments" VARCHAR
);

CREATE TABLE owid_system_for_monitoring_alcohol_related_harm_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "system_for_monitoring_alcohol_related_harm" VARCHAR
);

CREATE TABLE owid_system_for_monitoring_alcohol_related_harm_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "system_for_monitoring_alcohol_related_harm" VARCHAR,
  "system_for_monitoring_alcohol_related_harm_low" VARCHAR,
  "system_for_monitoring_alcohol_related_harm_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_system_of_monitoring_alcohol_involvement_in_foren_56bbfe1b (
  "year" INTEGER,
  "country" VARCHAR,
  "monitoring_system" VARCHAR,
  "system_of_monitoring_alcohol_involvement_in_forensic_pathology" VARCHAR,
  "system_of_monitoring_alcohol_involvement_in_forensic_p_b4c262be" VARCHAR  -- System Of Monitoring Alcohol Involvement In Forensic Pathology Low,
  "system_of_monitoring_alcohol_involvement_in_forensic_p_e1250451" VARCHAR  -- System Of Monitoring Alcohol Involvement In Forensic Pathology High,
  "comments" VARCHAR
);

CREATE TABLE owid_system_of_monitoring_alcohol_involvement_in_foren_9a18d3cd (
  "year" INTEGER,
  "country" VARCHAR,
  "monitoring_system" VARCHAR,
  "system_of_monitoring_alcohol_involvement_in_forensic_pathology" VARCHAR
);

CREATE TABLE owid_system_of_monitoring_drugs_involvement_in_forensi_0389b321 (
  "year" INTEGER,
  "country" VARCHAR,
  "monitoring_system" VARCHAR,
  "system_of_monitoring_drugs_involvement_in_forensic_pathology" VARCHAR
);

CREATE TABLE owid_system_of_monitoring_drugs_involvement_in_forensi_99340bd6 (
  "year" INTEGER,
  "country" VARCHAR,
  "monitoring_system" VARCHAR,
  "system_of_monitoring_drugs_involvement_in_forensic_pathology" VARCHAR,
  "system_of_monitoring_drugs_involvement_in_forensic_pat_5ed4c246" VARCHAR  -- System Of Monitoring Drugs Involvement In Forensic Pathology Low,
  "system_of_monitoring_drugs_involvement_in_forensic_pat_fd1d4187" VARCHAR  -- System Of Monitoring Drugs Involvement In Forensic Pathology High,
  "comments" VARCHAR
);

CREATE TABLE owid_target_gt_60pct_of_total_antibiotic_consumption_b_ccd7591f (
  "year" INTEGER,
  "country" VARCHAR,
  "target_gt_60pct_of_total_antibiotic_consumption_being__e55475a9" VARCHAR  -- Target, Gt, 60pct Of Total Antibiotic Consumption Being Access Group Antibiotics, Gpw13 Target 4b,
  "target_gt_60pct_of_total_antibiotic_consumption_being__c1062058" VARCHAR  -- Target, Gt, 60pct Of Total Antibiotic Consumption Being Access Group Antibiotics, Gpw13 Target 4b Low,
  "target_gt_60pct_of_total_antibiotic_consumption_being__0ca57b0b" VARCHAR  -- Target, Gt, 60pct Of Total Antibiotic Consumption Being Access Group Antibiotics, Gpw13 Target 4b High,
  "comments" VARCHAR
);

CREATE TABLE owid_target_gt_60pct_of_total_antibiotic_consumption_b_f329319d (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "target_gt_60pct_of_total_antibiotic_consumption_being__e55475a9" VARCHAR  -- Target, Gt, 60pct Of Total Antibiotic Consumption Being Access Group Antibiotics, Gpw13 Target 4b
);

CREATE TABLE owid_targets_for_monitoring_implementation_of_dementia_b76c24ec (
  "year" INTEGER,
  "country" VARCHAR,
  "targets_for_monitoring_implementation_of_dementia_national_plan" VARCHAR,
  "targets_for_monitoring_implementation_of_dementia_nati_102978df" VARCHAR  -- Targets For Monitoring Implementation Of Dementia National Plan Low,
  "targets_for_monitoring_implementation_of_dementia_nati_365ee133" VARCHAR  -- Targets For Monitoring Implementation Of Dementia National Plan High,
  "comments" VARCHAR
);

CREATE TABLE owid_targets_for_monitoring_implementation_of_dementia_ec7ddc03 (
  "year" INTEGER,
  "country" VARCHAR,
  "targets_for_monitoring_implementation_of_dementia_national_plan" VARCHAR
);

CREATE TABLE owid_taxation_of_ethanol_production_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "taxation_of_ethanol_production" VARCHAR
);

CREATE TABLE owid_taxation_of_ethanol_production_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "taxation_of_ethanol_production" VARCHAR,
  "taxation_of_ethanol_production_low" VARCHAR,
  "taxation_of_ethanol_production_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_ad_valorem_excise_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_ad_valorem_excise" FLOAT  -- Taxes As A Pct Of Price, Ad Valorem Excise,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_ad_valorem_excise_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_ad_valorem_excise" FLOAT  -- Taxes As A Pct Of Price, Ad Valorem Excise,
  "taxes_as_a_pct_of_price_ad_valorem_excise_low" VARCHAR  -- Taxes As A Pct Of Price, Ad Valorem Excise Low,
  "taxes_as_a_pct_of_price_ad_valorem_excise_high" VARCHAR  -- Taxes As A Pct Of Price, Ad Valorem Excise High,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_import_duties_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_import_duties" FLOAT  -- Taxes As A Pct Of Price, Import Duties,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_import_duties_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_import_duties" FLOAT  -- Taxes As A Pct Of Price, Import Duties,
  "taxes_as_a_pct_of_price_import_duties_low" VARCHAR  -- Taxes As A Pct Of Price, Import Duties Low,
  "taxes_as_a_pct_of_price_import_duties_high" VARCHAR  -- Taxes As A Pct Of Price, Import Duties High,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_other_taxes_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_other_taxes" FLOAT  -- Taxes As A Pct Of Price, Other Taxes,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_other_taxes_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_other_taxes" FLOAT  -- Taxes As A Pct Of Price, Other Taxes,
  "taxes_as_a_pct_of_price_other_taxes_low" VARCHAR  -- Taxes As A Pct Of Price, Other Taxes Low,
  "taxes_as_a_pct_of_price_other_taxes_high" VARCHAR  -- Taxes As A Pct Of Price, Other Taxes High,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_specific_excise_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_specific_excise" FLOAT  -- Taxes As A Pct Of Price, Specific Excise,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_specific_excise_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_specific_excise" FLOAT  -- Taxes As A Pct Of Price, Specific Excise,
  "taxes_as_a_pct_of_price_specific_excise_low" VARCHAR  -- Taxes As A Pct Of Price, Specific Excise Low,
  "taxes_as_a_pct_of_price_specific_excise_high" VARCHAR  -- Taxes As A Pct Of Price, Specific Excise High,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_total_tax_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_total_tax" FLOAT  -- Taxes As A Pct Of Price, Total Tax,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_total_tax_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_total_tax" FLOAT  -- Taxes As A Pct Of Price, Total Tax,
  "taxes_as_a_pct_of_price_total_tax_low" VARCHAR  -- Taxes As A Pct Of Price, Total Tax Low,
  "taxes_as_a_pct_of_price_total_tax_high" VARCHAR  -- Taxes As A Pct Of Price, Total Tax High,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_value_added_tax_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_value_added_tax" FLOAT  -- Taxes As A Pct Of Price, Value Added Tax,
  "comments" VARCHAR
);

CREATE TABLE owid_taxes_as_a_pct_of_price_value_added_tax_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "taxes_as_a_pct_of_price_value_added_tax" FLOAT  -- Taxes As A Pct Of Price, Value Added Tax,
  "taxes_as_a_pct_of_price_value_added_tax_low" VARCHAR  -- Taxes As A Pct Of Price, Value Added Tax Low,
  "taxes_as_a_pct_of_price_value_added_tax_high" VARCHAR  -- Taxes As A Pct Of Price, Value Added Tax High,
  "comments" VARCHAR
);