Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_national_health_and_climate_change_plan_or_strate_0f387e14 (
"year" INTEGER,
"country" VARCHAR,
"national_health_and_climate_change_plan_or_strategy_developed" VARCHAR,
"national_health_and_climate_change_plan_or_strategy_de_9ab7fee4" VARCHAR -- National Health And Climate Change Plan Or Strategy Developed Low,
"national_health_and_climate_change_plan_or_strategy_de_c17d1a54" VARCHAR -- National Health And Climate Change Plan Or Strategy Developed High,
"comments" VARCHAR
);
CREATE TABLE owid_national_health_and_climate_change_plan_or_strate_24563984 (
"year" INTEGER,
"country" VARCHAR,
"national_health_and_climate_change_plan_or_strategy_developed" VARCHAR
);
CREATE TABLE owid_national_health_emergency_framework (
"year" INTEGER,
"country" VARCHAR,
"ihr_spar_capacity_level" VARCHAR,
"national_health_emergency_framework" INTEGER
);
CREATE TABLE owid_national_health_information_system_his_policy_or__3c9c852b (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"national_health_information_system_his_policy_or_strategy" VARCHAR -- National Health Information System, His, Policy Or Strategy,
"national_health_information_system_his_policy_or_strategy_low" VARCHAR -- National Health Information System, His, Policy Or Strategy Low,
"national_health_information_system_his_policy_or_strategy_high" VARCHAR -- National Health Information System, His, Policy Or Strategy High,
"comments" VARCHAR
);
CREATE TABLE owid_national_health_information_system_his_policy_or__55a833ff (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"national_health_information_system_his_policy_or_strategy" VARCHAR -- National Health Information System, His, Policy Or Strategy
);
CREATE TABLE owid_national_health_technology_assessment_hta_unit_in_421aa0a5 (
"year" INTEGER,
"country" VARCHAR,
"national_health_technology_assessment_hta_unit_includi_15d1bea0" VARCHAR -- National Health Technology Assessment, Hta, Unit Including The Assessment Of Medical Devices, And Diagnostics,
"national_health_technology_assessment_hta_unit_includi_3a0d0a26" VARCHAR -- National Health Technology Assessment, Hta, Unit Including The Assessment Of Medical Devices, And Diagnostics Low,
"national_health_technology_assessment_hta_unit_includi_4ab3eec9" VARCHAR -- National Health Technology Assessment, Hta, Unit Including The Assessment Of Medical Devices, And Diagnostics High,
"comments" VARCHAR
);
CREATE TABLE owid_national_health_technology_assessment_hta_unit_in_e0adb004 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"national_health_technology_assessment_hta_unit_includi_15d1bea0" VARCHAR -- National Health Technology Assessment, Hta, Unit Including The Assessment Of Medical Devices, And Diagnostics
);
CREATE TABLE owid_national_legislation_to_prevent_illegal_alcohol_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol" VARCHAR
);
CREATE TABLE owid_national_legislation_to_prevent_illegal_alcohol_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol_low" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_legislation_to_prevent_illegal_alcohol_sales_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol_sales" VARCHAR
);
CREATE TABLE owid_national_legislation_to_prevent_illegal_alcohol_sales_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol_sales" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol_sales_low" VARCHAR,
"national_legislation_to_prevent_illegal_alcohol_sales_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_organization_for_monitoring_alcohol_1 (
"year" INTEGER,
"country" VARCHAR,
"national_organization_for_monitoring_alcohol" VARCHAR
);
CREATE TABLE owid_national_organization_for_monitoring_alcohol_2 (
"year" INTEGER,
"country" VARCHAR,
"national_organization_for_monitoring_alcohol" VARCHAR,
"national_organization_for_monitoring_alcohol_low" VARCHAR,
"national_organization_for_monitoring_alcohol_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_radon_concentration_levels_1 (
"year" INTEGER,
"country" VARCHAR,
"radon_subquestions" VARCHAR,
"national_radon_concentration_levels" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_national_radon_concentration_levels_2 (
"year" INTEGER,
"country" VARCHAR,
"radon_subquestions" VARCHAR,
"national_radon_concentration_levels" FLOAT,
"national_radon_concentration_levels_low" VARCHAR,
"national_radon_concentration_levels_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_regulator_approval_of_anti_dementia_medication_1 (
"year" INTEGER,
"country" VARCHAR,
"national_regulator_approval_of_anti_dementia_medication" VARCHAR
);
CREATE TABLE owid_national_regulator_approval_of_anti_dementia_medication_2 (
"year" INTEGER,
"country" VARCHAR,
"national_regulator_approval_of_anti_dementia_medication" VARCHAR,
"national_regulator_approval_of_anti_dementia_medication_low" VARCHAR,
"national_regulator_approval_of_anti_dementia_medication_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_strategy_does_not_promote_the_adoption_of_ehr_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"national_strategy_does_not_promote_the_adoption_of_ehr" VARCHAR
);
CREATE TABLE owid_national_strategy_does_not_promote_the_adoption_of_ehr_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"national_strategy_does_not_promote_the_adoption_of_ehr" VARCHAR,
"national_strategy_does_not_promote_the_adoption_of_ehr_low" VARCHAR,
"national_strategy_does_not_promote_the_adoption_of_ehr_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_survey_on_substance_use_among_children_a_512604d7 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"national_survey_on_substance_use_among_children_and_adolescents" VARCHAR,
"national_survey_on_substance_use_among_children_and_ad_1b0a1825" VARCHAR -- National Survey On Substance Use Among Children And Adolescents Low,
"national_survey_on_substance_use_among_children_and_ad_3defece5" VARCHAR -- National Survey On Substance Use Among Children And Adolescents High,
"comments" VARCHAR
);
CREATE TABLE owid_national_survey_on_substance_use_among_children_a_db755379 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"national_survey_on_substance_use_among_children_and_adolescents" VARCHAR
);
CREATE TABLE owid_national_surveys_on_adult_alcohol_consumption_1 (
"year" INTEGER,
"country" VARCHAR,
"national_surveys_on_adult_alcohol_consumption" VARCHAR
);
CREATE TABLE owid_national_surveys_on_adult_alcohol_consumption_2 (
"year" INTEGER,
"country" VARCHAR,
"national_surveys_on_adult_alcohol_consumption" VARCHAR,
"national_surveys_on_adult_alcohol_consumption_low" VARCHAR,
"national_surveys_on_adult_alcohol_consumption_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_national_surveys_on_drink_driving_1 (
"year" INTEGER,
"country" VARCHAR,
"national_surveys_on_drink_driving" VARCHAR
);
CREATE TABLE owid_national_surveys_on_drink_driving_2 (
"year" INTEGER,
"country" VARCHAR,
"national_surveys_on_drink_driving" VARCHAR,
"national_surveys_on_drink_driving_low" VARCHAR,
"national_surveys_on_drink_driving_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.