Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_legislative_provision_for_treatment_and_rehabilit_0986b09d (
"year" INTEGER,
"country" VARCHAR,
"legislative_provision_for_treatment_and_rehabilitation_0de61359" VARCHAR -- Legislative Provision For Treatment And Rehabilitation Of Substance Use Disorders,
"legislative_provision_for_treatment_and_rehabilitation_7ee899de" VARCHAR -- Legislative Provision For Treatment And Rehabilitation Of Substance Use Disorders Low,
"legislative_provision_for_treatment_and_rehabilitation_87b31645" VARCHAR -- Legislative Provision For Treatment And Rehabilitation Of Substance Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_legislative_provision_for_treatment_and_rehabilit_974aafbf (
"year" INTEGER,
"country" VARCHAR,
"legislative_provision_for_treatment_and_rehabilitation_0de61359" VARCHAR -- Legislative Provision For Treatment And Rehabilitation Of Substance Use Disorders
);
CREATE TABLE owid_legislative_status_1 (
"year" INTEGER,
"country" VARCHAR,
"exposed" VARCHAR,
"frequency" VARCHAR,
"comments" VARCHAR,
"legislative_status" VARCHAR
);
CREATE TABLE owid_legislative_status_2 (
"year" INTEGER,
"country" VARCHAR,
"exposed" VARCHAR,
"frequency" VARCHAR,
"legislative_status" VARCHAR,
"legislative_status_low" VARCHAR,
"legislative_status_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_length_of_stay_for_inpatient_detoxification_days_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"length_of_stay_for_inpatient_detoxification_days" INTEGER -- Length Of Stay For Inpatient Detoxification, Days
);
CREATE TABLE owid_length_of_stay_for_inpatient_detoxification_days_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"length_of_stay_for_inpatient_detoxification_days" INTEGER -- Length Of Stay For Inpatient Detoxification, Days,
"length_of_stay_for_inpatient_detoxification_days_low" VARCHAR -- Length Of Stay For Inpatient Detoxification, Days Low,
"length_of_stay_for_inpatient_detoxification_days_high" VARCHAR -- Length Of Stay For Inpatient Detoxification, Days High,
"comments" VARCHAR
);
CREATE TABLE owid_length_of_stay_for_inpatient_long_term_residentia_353cc57f (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"length_of_stay_for_inpatient_long_term_residential_tre_01d79f91" INTEGER -- Length Of Stay For Inpatient Long Term Residential Treatment, Days,
"length_of_stay_for_inpatient_long_term_residential_tre_fd54bfab" VARCHAR -- Length Of Stay For Inpatient Long Term Residential Treatment, Days Low,
"length_of_stay_for_inpatient_long_term_residential_tre_72d70c0b" VARCHAR -- Length Of Stay For Inpatient Long Term Residential Treatment, Days High,
"comments" VARCHAR
);
CREATE TABLE owid_length_of_stay_for_inpatient_long_term_residentia_b11d92c8 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"length_of_stay_for_inpatient_long_term_residential_tre_01d79f91" INTEGER -- Length Of Stay For Inpatient Long Term Residential Treatment, Days
);
CREATE TABLE owid_length_of_stay_for_inpatient_short_term_treatment_days_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"length_of_stay_for_inpatient_short_term_treatment_days" INTEGER -- Length Of Stay For Inpatient Short Term Treatment, Days
);
CREATE TABLE owid_length_of_stay_for_inpatient_short_term_treatment_days_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"length_of_stay_for_inpatient_short_term_treatment_days" INTEGER -- Length Of Stay For Inpatient Short Term Treatment, Days,
"length_of_stay_for_inpatient_short_term_treatment_days_low" VARCHAR -- Length Of Stay For Inpatient Short Term Treatment, Days Low,
"length_of_stay_for_inpatient_short_term_treatment_days_high" VARCHAR -- Length Of Stay For Inpatient Short Term Treatment, Days High,
"comments" VARCHAR
);
CREATE TABLE owid_leprosy_registered_prevalence_rate_per_1_000_000__9b05a0f1 (
"year" INTEGER,
"country" VARCHAR,
"leprosy_registered_prevalence_rate_per_1_000_000_population" FLOAT
);
CREATE TABLE owid_leprosy_registered_prevalence_rate_per_1_000_000__a0ca33dc (
"year" INTEGER,
"country" VARCHAR,
"leprosy_registered_prevalence_rate_per_1_000_000_population" FLOAT,
"leprosy_registered_prevalence_rate_per_1_000_000_population_low" VARCHAR,
"leprosy_registered_prevalence_rate_per_1_000_000_popul_fa528b5c" VARCHAR -- Leprosy Registered Prevalence Rate Per 1–000 000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_level_of_adoption_of_national_alcohol_policy_1 (
"year" INTEGER,
"country" VARCHAR,
"level_of_adoption_of_national_alcohol_policy" VARCHAR
);
CREATE TABLE owid_level_of_adoption_of_national_alcohol_policy_2 (
"year" INTEGER,
"country" VARCHAR,
"level_of_adoption_of_national_alcohol_policy" VARCHAR,
"level_of_adoption_of_national_alcohol_policy_low" VARCHAR,
"level_of_adoption_of_national_alcohol_policy_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_level_of_enforcement_of_bac_limits_1 (
"year" INTEGER,
"country" VARCHAR,
"level_of_enforcement_of_bac_limits" VARCHAR
);
CREATE TABLE owid_level_of_enforcement_of_bac_limits_2 (
"year" INTEGER,
"country" VARCHAR,
"level_of_enforcement_of_bac_limits" VARCHAR,
"level_of_enforcement_of_bac_limits_low" VARCHAR,
"level_of_enforcement_of_bac_limits_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_level_of_taxation_adjusted_for_inflation_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"level_of_taxation_adjusted_for_inflation" VARCHAR
);
CREATE TABLE owid_level_of_taxation_adjusted_for_inflation_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"level_of_taxation_adjusted_for_inflation" VARCHAR,
"level_of_taxation_adjusted_for_inflation_low" VARCHAR,
"level_of_taxation_adjusted_for_inflation_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_licence_required_for_production_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licence_required_for_production" VARCHAR
);
CREATE TABLE owid_licence_required_for_production_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licence_required_for_production" VARCHAR,
"licence_required_for_production_low" VARCHAR,
"licence_required_for_production_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_licence_required_for_retail_sales_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licence_required_for_retail_sales" VARCHAR
);
CREATE TABLE owid_licence_required_for_retail_sales_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licence_required_for_retail_sales" VARCHAR,
"licence_required_for_retail_sales_low" VARCHAR,
"licence_required_for_retail_sales_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_licenses_issued_for_production_change_since_2010_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licenses_issued_for_production_change_since_2010" VARCHAR -- Licenses Issued For Production, Change Since 2010
);
CREATE TABLE owid_licenses_issued_for_production_change_since_2010_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licenses_issued_for_production_change_since_2010" VARCHAR -- Licenses Issued For Production, Change Since 2010,
"licenses_issued_for_production_change_since_2010_low" VARCHAR -- Licenses Issued For Production, Change Since 2010 Low,
"licenses_issued_for_production_change_since_2010_high" VARCHAR -- Licenses Issued For Production, Change Since 2010 High,
"comments" VARCHAR
);
CREATE TABLE owid_licenses_issued_for_retail_sale_change_since_2010_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"licenses_issued_for_retail_sale_change_since_2010" VARCHAR -- Licenses Issued For Retail Sale, Change Since 2010
);
Anyone who has the link will be able to view this.