Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_government_monopoly_on_production_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"government_monopoly_on_production" VARCHAR,
"government_monopoly_on_production_low" VARCHAR,
"government_monopoly_on_production_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_government_monopoly_on_retail_sales_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"government_monopoly_on_retail_sales" VARCHAR
);
CREATE TABLE owid_government_monopoly_on_retail_sales_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"government_monopoly_on_retail_sales" VARCHAR,
"government_monopoly_on_retail_sales_low" VARCHAR,
"government_monopoly_on_retail_sales_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_government_objectives_on_tobacco_control_exist_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"government_objectives_on_tobacco_control_exist" VARCHAR
);
CREATE TABLE owid_government_objectives_on_tobacco_control_exist_2 (
"year" INTEGER,
"country" VARCHAR,
"government_objectives_on_tobacco_control_exist" VARCHAR,
"government_objectives_on_tobacco_control_exist_low" VARCHAR,
"government_objectives_on_tobacco_control_exist_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_government_sponsored_mhealth_programmes_are_being_2a500a84 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"government_sponsored_mhealth_programmes_are_being_evaluated" VARCHAR,
"government_sponsored_mhealth_programmes_are_being_evaluated_low" VARCHAR,
"government_sponsored_mhealth_programmes_are_being_eval_a69fffff" VARCHAR -- Government Sponsored Mhealth Programmes Are Being Evaluated High,
"comments" VARCHAR
);
CREATE TABLE owid_government_sponsored_mhealth_programmes_are_being_d3241464 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"government_sponsored_mhealth_programmes_are_being_evaluated" VARCHAR
);
CREATE TABLE owid_government_supported_health_internet_sites_provid_1e29ca55 (
"year" INTEGER,
"country" VARCHAR,
"government_supported_health_internet_sites_provide_inf_b6babb16" VARCHAR -- Government Supported Health Internet Sites Provide Information In Multiple Languages
);
CREATE TABLE owid_government_supported_health_internet_sites_provid_76818dad (
"year" INTEGER,
"country" VARCHAR,
"government_supported_health_internet_sites_provide_inf_b6babb16" VARCHAR -- Government Supported Health Internet Sites Provide Information In Multiple Languages,
"government_supported_health_internet_sites_provide_inf_b5e9d003" VARCHAR -- Government Supported Health Internet Sites Provide Information In Multiple Languages Low,
"government_supported_health_internet_sites_provide_inf_16d42e2b" VARCHAR -- Government Supported Health Internet Sites Provide Information In Multiple Languages High,
"comments" VARCHAR
);
CREATE TABLE owid_government_support_for_community_action_1 (
"year" INTEGER,
"country" VARCHAR,
"community_action" VARCHAR,
"government_support_for_community_action" VARCHAR
);
CREATE TABLE owid_government_support_for_community_action_2 (
"year" INTEGER,
"country" VARCHAR,
"community_action" VARCHAR,
"government_support_for_community_action" VARCHAR,
"government_support_for_community_action_low" VARCHAR,
"government_support_for_community_action_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_government_unit_for_substance_use_disorder_prevention_1 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_for_substance_use_disorder_prevention" VARCHAR
);
CREATE TABLE owid_government_unit_for_substance_use_disorder_prevention_2 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_for_substance_use_disorder_prevention" VARCHAR,
"government_unit_for_substance_use_disorder_prevention_low" VARCHAR,
"government_unit_for_substance_use_disorder_prevention_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_government_unit_for_substance_use_disorder_treatment_1 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_for_substance_use_disorder_treatment" VARCHAR
);
CREATE TABLE owid_government_unit_for_substance_use_disorder_treatment_2 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_for_substance_use_disorder_treatment" VARCHAR,
"government_unit_for_substance_use_disorder_treatment_low" VARCHAR,
"government_unit_for_substance_use_disorder_treatment_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_government_unit_official_responsible_for_preventi_1227ca4d (
"year" INTEGER,
"country" VARCHAR,
"government_unit_official_responsible_for_prevention_fo_8ca4ede5" VARCHAR -- Government Unit Official Responsible For Prevention For Substance Use,
"government_unit_official_responsible_for_prevention_fo_c30507b4" VARCHAR -- Government Unit Official Responsible For Prevention For Substance Use Low,
"government_unit_official_responsible_for_prevention_fo_fe1a9c35" VARCHAR -- Government Unit Official Responsible For Prevention For Substance Use High,
"comments" VARCHAR
);
CREATE TABLE owid_government_unit_official_responsible_for_preventi_8d8f2144 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_official_responsible_for_prevention_fo_8ca4ede5" VARCHAR -- Government Unit Official Responsible For Prevention For Substance Use
);
CREATE TABLE owid_government_unit_official_responsible_for_treatmen_8c1cb915 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_official_responsible_for_treatment_of__3cc081a2" VARCHAR -- Government Unit Official Responsible For Treatment Of Substance Use Disorders
);
CREATE TABLE owid_government_unit_official_responsible_for_treatmen_d280b912 (
"year" INTEGER,
"country" VARCHAR,
"government_unit_official_responsible_for_treatment_of__3cc081a2" VARCHAR -- Government Unit Official Responsible For Treatment Of Substance Use Disorders,
"government_unit_official_responsible_for_treatment_of__f4230cc8" VARCHAR -- Government Unit Official Responsible For Treatment Of Substance Use Disorders Low,
"government_unit_official_responsible_for_treatment_of__8fc002a5" VARCHAR -- Government Unit Official Responsible For Treatment Of Substance Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_graduated_licensing_1 (
"year" INTEGER,
"country" VARCHAR,
"graduated_licensing" VARCHAR
);
CREATE TABLE owid_graduated_licensing_2 (
"year" INTEGER,
"country" VARCHAR,
"graduated_licensing" VARCHAR,
"graduated_licensing_low" VARCHAR,
"graduated_licensing_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_gross_national_income_per_capita_atlas_method_1 (
"year" INTEGER,
"country" VARCHAR,
"gross_national_income_per_capita_atlas_method" UINTEGER -- Gross National Income Per Capita, Atlas Method,
"comments" VARCHAR
);
CREATE TABLE owid_gross_national_income_per_capita_atlas_method_2 (
"year" INTEGER,
"country" VARCHAR,
"gross_national_income_per_capita_atlas_method" UINTEGER -- Gross National Income Per Capita, Atlas Method,
"gross_national_income_per_capita_atlas_method_low" VARCHAR -- Gross National Income Per Capita, Atlas Method Low,
"gross_national_income_per_capita_atlas_method_high" VARCHAR -- Gross National Income Per Capita, Atlas Method High,
"comments" VARCHAR
);
CREATE TABLE owid_groups_and_agencies_for_the_prevention_of_substan_17af3cf0 (
"year" INTEGER,
"country" VARCHAR,
"rsud_groups" VARCHAR,
"groups_and_agencies_for_the_prevention_of_substance_us_27e7e780" VARCHAR -- Groups And Agencies For The Prevention Of Substance Use Disorders
);
CREATE TABLE owid_groups_and_agencies_for_the_prevention_of_substan_e94eabde (
"year" INTEGER,
"country" VARCHAR,
"rsud_groups" VARCHAR,
"groups_and_agencies_for_the_prevention_of_substance_us_27e7e780" VARCHAR -- Groups And Agencies For The Prevention Of Substance Use Disorders,
"groups_and_agencies_for_the_prevention_of_substance_us_3759422f" VARCHAR -- Groups And Agencies For The Prevention Of Substance Use Disorders Low,
"groups_and_agencies_for_the_prevention_of_substance_us_f203dafb" VARCHAR -- Groups And Agencies For The Prevention Of Substance Use Disorders High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.