Global Health Observatory - World Health Organization

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_displa_78e81f16 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_display_qua_1cb2e6eb" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark, See W21 Emissions Quant A
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_displa_8cda7275 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_display_qua_84ff0343" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_displa_b7acff88 (
  "year" INTEGER,
  "country" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_display_qua_1cb2e6eb" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark, See W21 Emissions Quant A,
  "cigarette_packaging_and_labelling_must_not_display_qua_ff8aaaca" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark, See W21 Emissions Quant A Low,
  "cigarette_packaging_and_labelling_must_not_display_qua_48329646" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark, See W21 Emissions Quant A High,
  "comments" VARCHAR
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_use_de_1262874d (
  "year" INTEGER,
  "country" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_use_descrip_6d50c0e7" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Descriptors Depicting Flavours,
  "cigarette_packaging_and_labelling_must_not_use_descrip_c6343c91" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Descriptors Depicting Flavours Low,
  "cigarette_packaging_and_labelling_must_not_use_descrip_9aabc51a" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Descriptors Depicting Flavours High,
  "comments" VARCHAR
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_use_de_a59c5e1a (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_use_descrip_6d50c0e7" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Descriptors Depicting Flavours
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_use_fi_0f1d159d (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_use_figurat_427308f1" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_use_fi_b1779aeb (
  "year" INTEGER,
  "country" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_use_figurat_427308f1" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors,
  "cigarette_packaging_and_labelling_must_not_use_figurat_78733c35" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors Low,
  "cigarette_packaging_and_labelling_must_not_use_figurat_2646056e" VARCHAR  -- Cigarette Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors High,
  "comments" VARCHAR
);

CREATE TABLE owid_citizen_complaints_and_investigations_of_violatio_4b19daf0 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "citizen_complaints_and_investigations_of_violations_of_5b4d226e" VARCHAR  -- Citizen Complaints And Investigations Of Violations Of Smoke Free Laws
);

CREATE TABLE owid_citizen_complaints_and_investigations_of_violatio_8a3e79ab (
  "year" INTEGER,
  "country" VARCHAR,
  "citizen_complaints_and_investigations_of_violations_of_5b4d226e" VARCHAR  -- Citizen Complaints And Investigations Of Violations Of Smoke Free Laws,
  "citizen_complaints_and_investigations_of_violations_of_f4acf309" VARCHAR  -- Citizen Complaints And Investigations Of Violations Of Smoke Free Laws Low,
  "citizen_complaints_and_investigations_of_violations_of_022f865e" VARCHAR  -- Citizen Complaints And Investigations Of Violations Of Smoke Free Laws High,
  "comments" VARCHAR
);

CREATE TABLE owid_civil_registration_coverage_of_cause_of_death_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "civil_registration_coverage_of_cause_of_death_pct" FLOAT  -- Civil Registration Coverage Of Cause Of Death, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_civil_registration_coverage_of_cause_of_death_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "civil_registration_coverage_of_cause_of_death_pct" FLOAT  -- Civil Registration Coverage Of Cause Of Death, Pct,
  "civil_registration_coverage_of_cause_of_death_pct_low" VARCHAR  -- Civil Registration Coverage Of Cause Of Death, Pct Low,
  "civil_registration_coverage_of_cause_of_death_pct_high" VARCHAR  -- Civil Registration Coverage Of Cause Of Death, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_climate_change_and_health_vulnerability_and_adapt_a45ffb05 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_and_health_vulnerability_and_adaptation_acfe1390" VARCHAR  -- Climate Change And Health Vulnerability And Adaptation Assessment Conducted,
  "climate_change_and_health_vulnerability_and_adaptation_19ee9ced" VARCHAR  -- Climate Change And Health Vulnerability And Adaptation Assessment Conducted Low,
  "climate_change_and_health_vulnerability_and_adaptation_1cc67feb" VARCHAR  -- Climate Change And Health Vulnerability And Adaptation Assessment Conducted High,
  "comments" VARCHAR
);

CREATE TABLE owid_climate_change_and_health_vulnerability_and_adapt_f52a11a4 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_and_health_vulnerability_and_adaptation_acfe1390" VARCHAR  -- Climate Change And Health Vulnerability And Adaptation Assessment Conducted
);

CREATE TABLE owid_climate_change_attributable_dalys_000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_dalys_000" FLOAT  -- Climate Change Attributable Dalys, 000
);

CREATE TABLE owid_climate_change_attributable_dalys_000_in_children_40daa823 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_dalys_000_in_children_under_5_years" FLOAT  -- Climate Change Attributable Dalys, 000, In Children Under 5 Years
);

CREATE TABLE owid_climate_change_attributable_dalys_per_100000_capita_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_dalys_per_100000_capita" FLOAT
);

CREATE TABLE owid_climate_change_attributable_dalys_per_100000_chil_6795a84f (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_dalys_per_100000_children__768ff1ce" FLOAT  -- Climate Change Attributable Dalys Per 100000 Children Under 5 Years
);

CREATE TABLE owid_climate_change_attributable_deaths_000_in_childre_d9ff9fab (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_deaths_000_in_children_und_de699a51" FLOAT  -- Climate Change Attributable Deaths, 000, In Children Under 5 Years
);

CREATE TABLE owid_climate_change_attributable_deaths_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_deaths" FLOAT
);

CREATE TABLE owid_climate_change_attributable_deaths_per_100000_capita_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_deaths_per_100000_capita" FLOAT
);

CREATE TABLE owid_climate_change_attributable_deaths_per_100000_chi_cea17796 (
  "year" INTEGER,
  "country" VARCHAR,
  "climate_change_attributable_deaths_per_100000_children_2e20d789" FLOAT  -- Climate Change Attributable Deaths Per 100000 Children Under 5 Years
);

CREATE TABLE owid_clinical_guidelines_for_brief_interventions_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "clinical_guidelines_for_brief_interventions" VARCHAR
);

CREATE TABLE owid_clinical_guidelines_for_brief_interventions_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "clinical_guidelines_for_brief_interventions" VARCHAR,
  "clinical_guidelines_for_brief_interventions_low" VARCHAR,
  "clinical_guidelines_for_brief_interventions_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_clinical_supervision_of_health_care_staff_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_clinical_supervision" VARCHAR,
  "clinical_supervision_of_health_care_staff" VARCHAR
);

CREATE TABLE owid_clinical_supervision_of_health_care_staff_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_clinical_supervision" VARCHAR,
  "clinical_supervision_of_health_care_staff" VARCHAR,
  "clinical_supervision_of_health_care_staff_low" VARCHAR,
  "clinical_supervision_of_health_care_staff_high" VARCHAR,
  "comments" VARCHAR
);