Global Health Observatory - World Health Organization

CREATE TABLE owid_tobacco_tax_structure_retail_price_used_as_base_o_3cf2c1db (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_retail_price_used_as_base_of_ad__0d9b855b" VARCHAR  -- Tobacco Tax Structure, Retail Price Used As Base Of Ad Valorem Component In Ad Valorem Or Mixed Excise Regime, Or Retail Price Exclusive Of Vat
);

CREATE TABLE owid_tobacco_tax_structure_retail_price_used_as_base_o_92c05295 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_retail_price_used_as_base_of_ad__0d9b855b" VARCHAR  -- Tobacco Tax Structure, Retail Price Used As Base Of Ad Valorem Component In Ad Valorem Or Mixed Excise Regime, Or Retail Price Exclusive Of Vat,
  "tobacco_tax_structure_retail_price_used_as_base_of_ad__1e9e4b68" VARCHAR  -- Tobacco Tax Structure, Retail Price Used As Base Of Ad Valorem Component In Ad Valorem Or Mixed Excise Regime, Or Retail Price Exclusive Of Vat Low,
  "tobacco_tax_structure_retail_price_used_as_base_of_ad__7d0af53d" VARCHAR  -- Tobacco Tax Structure, Retail Price Used As Base Of Ad Valorem Component In Ad Valorem Or Mixed Excise Regime, Or Retail Price Exclusive Of Vat High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_specific_tax_component_auto_0272f54a (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_specific_tax_component_automatic_2beef372" VARCHAR  -- Tobacco Tax Structure, Specific Tax Component Automatically Adjusted For Inflation, Or Other,
  "tobacco_tax_structure_specific_tax_component_automatic_04e3e60c" VARCHAR  -- Tobacco Tax Structure, Specific Tax Component Automatically Adjusted For Inflation, Or Other Low,
  "tobacco_tax_structure_specific_tax_component_automatic_3ac15572" VARCHAR  -- Tobacco Tax Structure, Specific Tax Component Automatically Adjusted For Inflation, Or Other High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_specific_tax_component_auto_a32d4459 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "tobacco_tax_structure_specific_tax_component_automatic_2beef372" VARCHAR  -- Tobacco Tax Structure, Specific Tax Component Automatically Adjusted For Inflation, Or Other
);

CREATE TABLE owid_tobacco_tax_structure_type_of_excise_tax_applied_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_type_of_excise_tax_applied" VARCHAR  -- Tobacco Tax Structure, Type Of Excise Tax Applied
);

CREATE TABLE owid_tobacco_tax_structure_type_of_excise_tax_applied_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_type_of_excise_tax_applied" VARCHAR  -- Tobacco Tax Structure, Type Of Excise Tax Applied,
  "tobacco_tax_structure_type_of_excise_tax_applied_low" VARCHAR  -- Tobacco Tax Structure, Type Of Excise Tax Applied Low,
  "tobacco_tax_structure_type_of_excise_tax_applied_high" VARCHAR  -- Tobacco Tax Structure, Type Of Excise Tax Applied High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_uniform_excise_tax_applied__9e8d11ed (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_uniform_excise_tax_applied_yes_u_275c89db" VARCHAR  -- Tobacco Tax Structure, Uniform Excise Tax Applied Yes, Uniform, No, Tiered Varying Rates,
  "tobacco_tax_structure_uniform_excise_tax_applied_yes_u_ec280996" VARCHAR  -- Tobacco Tax Structure, Uniform Excise Tax Applied Yes, Uniform, No, Tiered Varying Rates Low,
  "tobacco_tax_structure_uniform_excise_tax_applied_yes_u_82a08ad3" VARCHAR  -- Tobacco Tax Structure, Uniform Excise Tax Applied Yes, Uniform, No, Tiered Varying Rates High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_uniform_excise_tax_applied__c86d5390 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_uniform_excise_tax_applied_yes_u_275c89db" VARCHAR  -- Tobacco Tax Structure, Uniform Excise Tax Applied Yes, Uniform, No, Tiered Varying Rates
);

CREATE TABLE owid_to_define_medical_jurisdiction_liability_or_reimb_9dc765dd (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "to_define_medical_jurisdiction_liability_or_reimbursem_b13be6f2" VARCHAR  -- To Define Medical Jurisdiction, Liability Or Reimbursement Of Ehealth Services Such As Telehealth
);

CREATE TABLE owid_to_define_medical_jurisdiction_liability_or_reimb_f3b00166 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "to_define_medical_jurisdiction_liability_or_reimbursem_b13be6f2" VARCHAR  -- To Define Medical Jurisdiction, Liability Or Reimbursement Of Ehealth Services Such As Telehealth,
  "to_define_medical_jurisdiction_liability_or_reimbursem_fcab2cd6" VARCHAR  -- To Define Medical Jurisdiction, Liability Or Reimbursement Of Ehealth Services Such As Telehealth Low,
  "to_define_medical_jurisdiction_liability_or_reimbursem_6de6552b" VARCHAR  -- To Define Medical Jurisdiction, Liability Or Reimbursement Of Ehealth Services Such As Telehealth High,
  "comments" VARCHAR
);

CREATE TABLE owid_to_protect_privacy_of_personally_identifiable_dat_05cb7213 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "to_protect_privacy_of_personally_identifiable_data_of__7489cb86" VARCHAR  -- To Protect Privacy Of Personally Identifiable Data Of Individuals Irrespective Of Whether It Is Paper Or Digital Format,
  "to_protect_privacy_of_personally_identifiable_data_of__295e8910" VARCHAR  -- To Protect Privacy Of Personally Identifiable Data Of Individuals Irrespective Of Whether It Is Paper Or Digital Format Low,
  "to_protect_privacy_of_personally_identifiable_data_of__3eefb4a7" VARCHAR  -- To Protect Privacy Of Personally Identifiable Data Of Individuals Irrespective Of Whether It Is Paper Or Digital Format High,
  "comments" VARCHAR
);

CREATE TABLE owid_to_protect_privacy_of_personally_identifiable_dat_be63c0fd (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "to_protect_privacy_of_personally_identifiable_data_of__7489cb86" VARCHAR  -- To Protect Privacy Of Personally Identifiable Data Of Individuals Irrespective Of Whether It Is Paper Or Digital Format
);

CREATE TABLE owid_to_protect_the_privacy_of_individuals_health_rela_17d9d2bc (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "to_protect_the_privacy_of_individuals_health_related_d_4de05365" VARCHAR  -- To Protect The Privacy Of Individuals Health Related Data Held In Electronic Format As An Ehr,
  "to_protect_the_privacy_of_individuals_health_related_d_66586edd" VARCHAR  -- To Protect The Privacy Of Individuals Health Related Data Held In Electronic Format As An Ehr Low,
  "to_protect_the_privacy_of_individuals_health_related_d_b1faab98" VARCHAR  -- To Protect The Privacy Of Individuals Health Related Data Held In Electronic Format As An Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_to_protect_the_privacy_of_individuals_health_rela_b154e159 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "to_protect_the_privacy_of_individuals_health_related_d_4de05365" VARCHAR  -- To Protect The Privacy Of Individuals Health Related Data Held In Electronic Format As An Ehr
);

CREATE TABLE owid_total_consumption_of_antibacterials_expressed_as__7e04da94 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_consumption_of_antibacterials_expressed_as_ddd_p_19f28b80" FLOAT  -- Total Consumption Of Antibacterials Expressed As Ddd Per 1000 Inhabitants Per Day,
  "total_consumption_of_antibacterials_expressed_as_ddd_p_cb09c53f" VARCHAR  -- Total Consumption Of Antibacterials Expressed As Ddd Per 1000 Inhabitants Per Day Low,
  "total_consumption_of_antibacterials_expressed_as_ddd_p_db83f9ac" VARCHAR  -- Total Consumption Of Antibacterials Expressed As Ddd Per 1000 Inhabitants Per Day High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_consumption_of_antibacterials_expressed_as__c24675f4 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_consumption_of_antibacterials_expressed_as_ddd_p_19f28b80" FLOAT  -- Total Consumption Of Antibacterials Expressed As Ddd Per 1000 Inhabitants Per Day,
  "comments" VARCHAR
);

CREATE TABLE owid_total_dementia_hospital_admissions_per_100_000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_dementia_hospital_admissions_per_100_000" UINTEGER  -- Total Dementia Hospital Admissions, Per 100–000
);

CREATE TABLE owid_total_dementia_hospital_admissions_per_100_000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_dementia_hospital_admissions_per_100_000" UINTEGER  -- Total Dementia Hospital Admissions, Per 100–000,
  "total_dementia_hospital_admissions_per_100_000_low" VARCHAR  -- Total Dementia Hospital Admissions, Per 100–000 Low,
  "total_dementia_hospital_admissions_per_100_000_high" VARCHAR  -- Total Dementia Hospital Admissions, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_district_rur_7893ea94 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_district_rural_hospitals" FLOAT  -- Total Density Per 100–000 Population, District Rural Hospitals,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_district_rur_c7845ab4 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_district_rural_hospitals" FLOAT  -- Total Density Per 100–000 Population, District Rural Hospitals,
  "total_density_per_100_000_population_district_rural_ho_36f80273" VARCHAR  -- Total Density Per 100–000 Population, District Rural Hospitals Low,
  "total_density_per_100_000_population_district_rural_ho_d2405936" VARCHAR  -- Total Density Per 100–000 Population, District Rural Hospitals High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_health_centres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_health_centres" FLOAT  -- Total Density Per 100–000 Population, Health Centres,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_health_centres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_health_centres" FLOAT  -- Total Density Per 100–000 Population, Health Centres,
  "total_density_per_100_000_population_health_centres_low" VARCHAR  -- Total Density Per 100–000 Population, Health Centres Low,
  "total_density_per_100_000_population_health_centres_high" VARCHAR  -- Total Density Per 100–000 Population, Health Centres High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_health_posts_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_health_posts" FLOAT  -- Total Density Per 100–000 Population, Health Posts,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_health_posts_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_health_posts" FLOAT  -- Total Density Per 100–000 Population, Health Posts,
  "total_density_per_100_000_population_health_posts_low" VARCHAR  -- Total Density Per 100–000 Population, Health Posts Low,
  "total_density_per_100_000_population_health_posts_high" VARCHAR  -- Total Density Per 100–000 Population, Health Posts High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_density_per_100_000_population_hospitals_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_density_per_100_000_population_hospitals" FLOAT  -- Total Density Per 100–000 Population, Hospitals,
  "comments" VARCHAR
);