Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_mhealth_programmes_are_sponsored_by_government_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"mhealth_programmes_are_sponsored_by_government" VARCHAR
);
CREATE TABLE owid_mhealth_programmes_are_sponsored_by_government_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"mhealth_programmes_are_sponsored_by_government" VARCHAR,
"mhealth_programmes_are_sponsored_by_government_low" VARCHAR,
"mhealth_programmes_are_sponsored_by_government_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_midwifery_personnel_number_1 (
"year" INTEGER,
"country" VARCHAR,
"midwifery_personnel_number" UINTEGER -- Midwifery Personnel, Number,
"comments" VARCHAR
);
CREATE TABLE owid_midwifery_personnel_number_2 (
"year" INTEGER,
"country" VARCHAR,
"midwifery_personnel_number" UINTEGER -- Midwifery Personnel, Number,
"midwifery_personnel_number_low" VARCHAR -- Midwifery Personnel, Number Low,
"midwifery_personnel_number_high" VARCHAR -- Midwifery Personnel, Number High,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_acceptable_diet_6_23_months_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"household_wealth" VARCHAR,
"minimum_acceptable_diet_6_23_months" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_acceptable_diet_6_23_months_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"household_wealth" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"education_level" VARCHAR,
"minimum_acceptable_diet_6_23_months" FLOAT,
"minimum_acceptable_diet_6_23_months_low" FLOAT,
"minimum_acceptable_diet_6_23_months_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_dietary_diversity_6_23_months_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"household_wealth" VARCHAR,
"minimum_dietary_diversity_6_23_months" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_dietary_diversity_6_23_months_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"household_wealth" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"education_level" VARCHAR,
"minimum_dietary_diversity_6_23_months" FLOAT,
"minimum_dietary_diversity_6_23_months_low" FLOAT,
"minimum_dietary_diversity_6_23_months_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_legal_drinking_age_1 (
"year" INTEGER,
"country" VARCHAR,
"minimum_legal_drinking_age" INTEGER
);
CREATE TABLE owid_minimum_legal_drinking_age_2 (
"year" INTEGER,
"country" VARCHAR,
"minimum_legal_drinking_age" INTEGER,
"minimum_legal_drinking_age_low" VARCHAR,
"minimum_legal_drinking_age_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_meal_frequency_6_23_months_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"household_wealth" VARCHAR,
"minimum_meal_frequency_6_23_months" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_minimum_meal_frequency_6_23_months_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"household_wealth" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"education_level" VARCHAR,
"minimum_meal_frequency_6_23_months" FLOAT,
"minimum_meal_frequency_6_23_months_low" FLOAT,
"minimum_meal_frequency_6_23_months_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_ministry_office_that_takes_primary_responsibility_23ef95b4 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"ministry_office_that_takes_primary_responsibility_for__f7522b4e" VARCHAR -- Ministry Office That Takes Primary Responsibility For Treatment Of Substance Use Disorders
);
CREATE TABLE owid_ministry_office_that_takes_primary_responsibility_8c8f00c0 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"ministry_office_that_takes_primary_responsibility_for__40323404" VARCHAR -- Ministry Office That Takes Primary Responsibility For Prevention For Substance Use
);
CREATE TABLE owid_ministry_office_that_takes_primary_responsibility_b0480dd9 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"ministry_office_that_takes_primary_responsibility_for__f7522b4e" VARCHAR -- Ministry Office That Takes Primary Responsibility For Treatment Of Substance Use Disorders,
"ministry_office_that_takes_primary_responsibility_for__e11b9de9" VARCHAR -- Ministry Office That Takes Primary Responsibility For Treatment Of Substance Use Disorders Low,
"ministry_office_that_takes_primary_responsibility_for__712bc446" VARCHAR -- Ministry Office That Takes Primary Responsibility For Treatment Of Substance Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_ministry_office_that_takes_primary_responsibility_e113b588 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"ministry_office_that_takes_primary_responsibility_for__40323404" VARCHAR -- Ministry Office That Takes Primary Responsibility For Prevention For Substance Use,
"ministry_office_that_takes_primary_responsibility_for__f16061b4" VARCHAR -- Ministry Office That Takes Primary Responsibility For Prevention For Substance Use Low,
"ministry_office_that_takes_primary_responsibility_for__84f7f0a1" VARCHAR -- Ministry Office That Takes Primary Responsibility For Prevention For Substance Use High,
"comments" VARCHAR
);
CREATE TABLE owid_mobile_cellular_telephone_subscriptions_per_100_i_0a033413 (
"year" INTEGER,
"country" VARCHAR,
"mobile_cellular_telephone_subscriptions_per_100_inhabitants" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_mobile_cellular_telephone_subscriptions_per_100_i_69cf4f66 (
"year" INTEGER,
"country" VARCHAR,
"mobile_cellular_telephone_subscriptions_per_100_inhabitants" FLOAT,
"mobile_cellular_telephone_subscriptions_per_100_inhabitants_low" VARCHAR,
"mobile_cellular_telephone_subscriptions_per_100_inhabi_8b6c0dcd" VARCHAR -- Mobile Cellular Telephone Subscriptions Per 100 Inhabitants High,
"comments" VARCHAR
);
CREATE TABLE owid_monitor_1 (
"year" INTEGER,
"country" VARCHAR,
"monitor" INTEGER
);
CREATE TABLE owid_monitor_2 (
"year" INTEGER,
"country" VARCHAR,
"monitor" INTEGER,
"monitor_low" VARCHAR,
"monitor_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_monitoring_1 (
"year" INTEGER,
"country" VARCHAR,
"monitoring" VARCHAR
);
CREATE TABLE owid_monitoring_2 (
"year" INTEGER,
"country" VARCHAR,
"monitoring" VARCHAR,
"monitoring_low" VARCHAR,
"monitoring_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_monopoly_on_exports_of_alcoholic_beverages_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"monopoly_on_exports_of_alcoholic_beverages" VARCHAR
);
CREATE TABLE owid_monopoly_on_exports_of_alcoholic_beverages_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"monopoly_on_exports_of_alcoholic_beverages" VARCHAR,
"monopoly_on_exports_of_alcoholic_beverages_low" VARCHAR,
"monopoly_on_exports_of_alcoholic_beverages_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_monopoly_on_imports_of_alcoholic_beverages_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"monopoly_on_imports_of_alcoholic_beverages" VARCHAR
);
Anyone who has the link will be able to view this.