Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_specialized_treatment_services_for_substance_use__380844ba (
"year" INTEGER,
"country" VARCHAR,
"specialized_treatment_services_for_substance_use_disor_47af928f" VARCHAR -- Specialized Treatment Services For Substance Use Disorders And Tb
);
CREATE TABLE owid_special_treatment_programmes_for_gambling_disorder_1 (
"year" INTEGER,
"country" VARCHAR,
"treatment_location" VARCHAR,
"special_treatment_programmes_for_gambling_disorder" VARCHAR
);
CREATE TABLE owid_special_treatment_programmes_for_gambling_disorder_2 (
"year" INTEGER,
"country" VARCHAR,
"treatment_location" VARCHAR,
"special_treatment_programmes_for_gambling_disorder" VARCHAR,
"special_treatment_programmes_for_gambling_disorder_low" VARCHAR,
"special_treatment_programmes_for_gambling_disorder_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_specific_absorption_rate_sar_w_kg_1 (
"year" INTEGER,
"country" VARCHAR,
"exposed" VARCHAR,
"frequency" VARCHAR,
"body_part" VARCHAR,
"comments" VARCHAR,
"specific_absorption_rate_sar_w_kg" VARCHAR -- Specific Absorption Rate, Sar, W Kg
);
CREATE TABLE owid_specific_absorption_rate_sar_w_kg_2 (
"year" INTEGER,
"country" VARCHAR,
"exposed" VARCHAR,
"frequency" VARCHAR,
"body_part" VARCHAR,
"specific_absorption_rate_sar_w_kg" VARCHAR -- Specific Absorption Rate, Sar, W Kg,
"specific_absorption_rate_sar_w_kg_low" VARCHAR -- Specific Absorption Rate, Sar, W Kg Low,
"specific_absorption_rate_sar_w_kg_high" VARCHAR -- Specific Absorption Rate, Sar, W Kg High,
"comments" VARCHAR
);
CREATE TABLE owid_specific_health_warnings_are_mandated_for_cigaret_13e97caa (
"year" INTEGER,
"country" VARCHAR,
"specific_health_warnings_are_mandated_for_cigarette_packaging" VARCHAR,
"specific_health_warnings_are_mandated_for_cigarette_pa_e389407b" VARCHAR -- Specific Health Warnings Are Mandated For Cigarette Packaging Low,
"specific_health_warnings_are_mandated_for_cigarette_pa_1d86dc7c" VARCHAR -- Specific Health Warnings Are Mandated For Cigarette Packaging High,
"comments" VARCHAR
);
CREATE TABLE owid_specific_health_warnings_are_mandated_for_cigaret_f5a056e3 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"specific_health_warnings_are_mandated_for_cigarette_packaging" VARCHAR
);
CREATE TABLE owid_specific_health_warnings_are_mandated_for_other_s_14d6167e (
"year" INTEGER,
"country" VARCHAR,
"specific_health_warnings_are_mandated_for_other_smoked_df6eb1c2" VARCHAR -- Specific Health Warnings Are Mandated For Other Smoked Tobacco Packaging,
"specific_health_warnings_are_mandated_for_other_smoked_f657a41d" VARCHAR -- Specific Health Warnings Are Mandated For Other Smoked Tobacco Packaging Low,
"specific_health_warnings_are_mandated_for_other_smoked_e2dc965d" VARCHAR -- Specific Health Warnings Are Mandated For Other Smoked Tobacco Packaging High,
"comments" VARCHAR
);
CREATE TABLE owid_specific_health_warnings_are_mandated_for_other_s_3853faae (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"specific_health_warnings_are_mandated_for_other_smoked_df6eb1c2" VARCHAR -- Specific Health Warnings Are Mandated For Other Smoked Tobacco Packaging
);
CREATE TABLE owid_specific_health_warnings_are_mandated_for_smokele_174e4af6 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"specific_health_warnings_are_mandated_for_smokeless_to_ab2b691b" VARCHAR -- Specific Health Warnings Are Mandated For Smokeless Tobacco Packaging
);
CREATE TABLE owid_specific_health_warnings_are_mandated_for_smokele_794b39da (
"year" INTEGER,
"country" VARCHAR,
"specific_health_warnings_are_mandated_for_smokeless_to_ab2b691b" VARCHAR -- Specific Health Warnings Are Mandated For Smokeless Tobacco Packaging,
"specific_health_warnings_are_mandated_for_smokeless_to_ee607d8b" VARCHAR -- Specific Health Warnings Are Mandated For Smokeless Tobacco Packaging Low,
"specific_health_warnings_are_mandated_for_smokeless_to_45ccd81e" VARCHAR -- Specific Health Warnings Are Mandated For Smokeless Tobacco Packaging High,
"comments" VARCHAR
);
CREATE TABLE owid_sponsored_events_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"sponsored_events" VARCHAR
);
CREATE TABLE owid_sponsored_events_2 (
"year" INTEGER,
"country" VARCHAR,
"sponsored_events" VARCHAR,
"sponsored_events_low" VARCHAR,
"sponsored_events_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_stand_alone_law_for_mental_health_1 (
"year" INTEGER,
"country" VARCHAR,
"stand_alone_law_for_mental_health" VARCHAR
);
CREATE TABLE owid_stand_alone_law_for_mental_health_2 (
"year" INTEGER,
"country" VARCHAR,
"stand_alone_law_for_mental_health" VARCHAR,
"stand_alone_law_for_mental_health_low" VARCHAR,
"stand_alone_law_for_mental_health_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_stand_alone_policy_or_plan_for_mental_health_1 (
"year" INTEGER,
"country" VARCHAR,
"stand_alone_policy_or_plan_for_mental_health" VARCHAR
);
CREATE TABLE owid_stand_alone_policy_or_plan_for_mental_health_2 (
"year" INTEGER,
"country" VARCHAR,
"stand_alone_policy_or_plan_for_mental_health" VARCHAR,
"stand_alone_policy_or_plan_for_mental_health_low" VARCHAR,
"stand_alone_policy_or_plan_for_mental_health_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_standard_drink_defined_1 (
"year" INTEGER,
"country" VARCHAR,
"standard_drink_defined" VARCHAR
);
CREATE TABLE owid_standard_drink_defined_2 (
"year" INTEGER,
"country" VARCHAR,
"standard_drink_defined" VARCHAR,
"standard_drink_defined_low" VARCHAR,
"standard_drink_defined_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_standard_drink_measures_in_grams_per_unit_1 (
"year" INTEGER,
"country" VARCHAR,
"standard_drink_measures_in_grams_per_unit" FLOAT -- Standard Drink Measures, In Grams Per Unit
);
CREATE TABLE owid_standard_drink_measures_in_grams_per_unit_2 (
"year" INTEGER,
"country" VARCHAR,
"standard_drink_measures_in_grams_per_unit" FLOAT -- Standard Drink Measures, In Grams Per Unit,
"standard_drink_measures_in_grams_per_unit_low" VARCHAR -- Standard Drink Measures, In Grams Per Unit Low,
"standard_drink_measures_in_grams_per_unit_high" VARCHAR -- Standard Drink Measures, In Grams Per Unit High,
"comments" VARCHAR
);
CREATE TABLE owid_standards_of_care_for_health_professionals_1 (
"year" INTEGER,
"country" VARCHAR,
"standards_of_care_for_health_professionals" VARCHAR
);
CREATE TABLE owid_standards_of_care_for_health_professionals_2 (
"year" INTEGER,
"country" VARCHAR,
"standards_of_care_for_health_professionals" VARCHAR,
"standards_of_care_for_health_professionals_low" VARCHAR,
"standards_of_care_for_health_professionals_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_standards_of_care_for_health_professionals_human_rights_1 (
"year" INTEGER,
"country" VARCHAR,
"standards_of_care_for_health_professionals_human_rights" VARCHAR -- Standards Of Care For Health Professionals, Human Rights
);
CREATE TABLE owid_standards_of_care_for_health_professionals_human_rights_2 (
"year" INTEGER,
"country" VARCHAR,
"standards_of_care_for_health_professionals_human_rights" VARCHAR -- Standards Of Care For Health Professionals, Human Rights,
"standards_of_care_for_health_professionals_human_rights_low" VARCHAR -- Standards Of Care For Health Professionals, Human Rights Low,
"standards_of_care_for_health_professionals_human_rights_high" VARCHAR -- Standards Of Care For Health Professionals, Human Rights High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.