Global Health Observatory - World Health Organization

CREATE TABLE owid_qualitative_information_on_emission_yields_must_b_20aa5d6a (
  "year" INTEGER,
  "country" VARCHAR,
  "qualitative_information_on_emission_yields_must_be_dis_b3243286" INTEGER  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Smokeless Tobacco Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_qualitative_information_on_emission_yields_must_b_a5c525ba (
  "year" INTEGER,
  "country" VARCHAR,
  "qualitative_information_on_emission_yields_must_be_dis_29475089" INTEGER  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Other Smoked Tobacco Packaging,
  "qualitative_information_on_emission_yields_must_be_dis_fbaf4ba4" VARCHAR  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Other Smoked Tobacco Packaging Low,
  "qualitative_information_on_emission_yields_must_be_dis_b55d2ca0" VARCHAR  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Other Smoked Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_qualitative_information_on_emission_yields_must_b_c579d2b5 (
  "year" INTEGER,
  "country" VARCHAR,
  "qualitative_information_on_emission_yields_must_be_dis_b3243286" INTEGER  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Smokeless Tobacco Packaging,
  "qualitative_information_on_emission_yields_must_be_dis_b14c2cc3" VARCHAR  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Smokeless Tobacco Packaging Low,
  "qualitative_information_on_emission_yields_must_be_dis_02340343" VARCHAR  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_qualitative_information_on_emission_yields_must_b_d892ee4b (
  "year" INTEGER,
  "country" VARCHAR,
  "qualitative_information_on_emission_yields_must_be_dis_6dc51b29" INTEGER  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Cigarette Packaging
);

CREATE TABLE owid_qualitative_information_on_emission_yields_must_b_f2ef1c7d (
  "year" INTEGER,
  "country" VARCHAR,
  "qualitative_information_on_emission_yields_must_be_dis_6dc51b29" INTEGER  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Cigarette Packaging,
  "qualitative_information_on_emission_yields_must_be_dis_5373419c" VARCHAR  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Cigarette Packaging Low,
  "qualitative_information_on_emission_yields_must_be_dis_372b2977" VARCHAR  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_radiation_emergencies (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "radiation_emergencies" INTEGER
);

CREATE TABLE owid_radionuclear (
  "year" INTEGER,
  "country" VARCHAR,
  "radionuclear" INTEGER
);

CREATE TABLE owid_radon_concentration_measurements_for_existing_buildings_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_subquestions" VARCHAR,
  "comments" VARCHAR,
  "radon_concentration_measurements_for_existing_buildings" VARCHAR
);

CREATE TABLE owid_radon_concentration_measurements_for_existing_buildings_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_subquestions" VARCHAR,
  "radon_concentration_measurements_for_existing_buildings" VARCHAR,
  "radon_concentration_measurements_for_existing_buildings_low" VARCHAR,
  "radon_concentration_measurements_for_existing_buildings_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_radon_concentration_measurements_for_new_buildings_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_subquestions" VARCHAR,
  "comments" VARCHAR,
  "radon_concentration_measurements_for_new_buildings" VARCHAR
);

CREATE TABLE owid_radon_concentration_measurements_for_new_buildings_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_subquestions" VARCHAR,
  "radon_concentration_measurements_for_new_buildings" VARCHAR,
  "radon_concentration_measurements_for_new_buildings_low" VARCHAR,
  "radon_concentration_measurements_for_new_buildings_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_radon_concentration_measurements_for_workplaces_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "radon_concentration_measurements_for_workplaces" VARCHAR
);

CREATE TABLE owid_radon_concentration_measurements_for_workplaces_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_concentration_measurements_for_workplaces" VARCHAR,
  "radon_concentration_measurements_for_workplaces_low" VARCHAR,
  "radon_concentration_measurements_for_workplaces_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_radon_in_building_regulations_for_existing_buildi_a38fea62 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "radon_in_building_regulations_for_existing_buildings_i_63388717" VARCHAR  -- Radon In Building Regulations For Existing Buildings I E, Renovation Remodeling Major Alteration
);

CREATE TABLE owid_radon_in_building_regulations_for_existing_buildi_bddc0319 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_in_building_regulations_for_existing_buildings_i_63388717" VARCHAR  -- Radon In Building Regulations For Existing Buildings I E, Renovation Remodeling Major Alteration,
  "radon_in_building_regulations_for_existing_buildings_i_7c3423da" VARCHAR  -- Radon In Building Regulations For Existing Buildings I E, Renovation Remodeling Major Alteration Low,
  "radon_in_building_regulations_for_existing_buildings_i_bc58a829" VARCHAR  -- Radon In Building Regulations For Existing Buildings I E, Renovation Remodeling Major Alteration High,
  "comments" VARCHAR
);

CREATE TABLE owid_radon_in_building_regulations_for_new_buildings_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "radon_in_building_regulations_for_new_buildings" VARCHAR
);

CREATE TABLE owid_radon_in_building_regulations_for_new_buildings_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_in_building_regulations_for_new_buildings" VARCHAR,
  "radon_in_building_regulations_for_new_buildings_low" VARCHAR,
  "radon_in_building_regulations_for_new_buildings_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_radon_in_national_drinking_water_regulations_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "radon_in_national_drinking_water_regulations" VARCHAR
);

CREATE TABLE owid_radon_in_national_drinking_water_regulations_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_in_national_drinking_water_regulations" VARCHAR,
  "radon_in_national_drinking_water_regulations_low" VARCHAR,
  "radon_in_national_drinking_water_regulations_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_age_0cb87ec0 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_age_stan_1ca2adaa" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Age Standardized Estimate,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_age_stan_00bc7cb8" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Age Standardized Estimate Low,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_age_stan_aa2e05fc" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Age Standardized Estimate High,
  "comments" VARCHAR
);

CREATE TABLE owid_raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_age_d3f20b57 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_age_stan_1ca2adaa" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Age Standardized Estimate,
  "comments" VARCHAR
);

CREATE TABLE owid_raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_cru_9c4fc52c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_crude_estimate" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Crude Estimate,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_crude_es_d6175d82" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Crude Estimate Low,
  "raised_blood_pressure_sbp_gt_140_or_dbp_gt_90_crude_es_d44ae6d0" FLOAT  -- Raised Blood Pressure, Sbp Gt, 140 Or Dbp Gt, 90, Crude Estimate High,
  "comments" VARCHAR
);

CREATE TABLE owid_raised_fasting_blood_glucose_gt_7_0_mmol_l_age_st_617d0219 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_age_standar_686203a1" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Age Standardized Estimate
);

CREATE TABLE owid_raised_fasting_blood_glucose_gt_7_0_mmol_l_age_st_9cd16f36 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_age_standar_686203a1" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Age Standardized Estimate,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_age_standar_5980b4bd" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Age Standardized Estimate Low,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_age_standar_d207f653" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Age Standardized Estimate High,
  "comments" VARCHAR
);

CREATE TABLE owid_raised_fasting_blood_glucose_gt_7_0_mmol_l_crude__525b73cc (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "raised_fasting_blood_glucose_gt_7_0_mmol_l_crude_estimate" FLOAT  -- Raised Fasting Blood Glucose, Gt, 7–0 Mmol L, Crude Estimate,
  "comments" VARCHAR
);