Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_second_hand_smoke_attributable_dalys_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"second_hand_smoke_attributable_dalys_per_100000_capita" FLOAT
);
CREATE TABLE owid_second_hand_smoke_attributable_deaths_000_in_chil_fb270808 (
"year" INTEGER,
"country" VARCHAR,
"second_hand_smoke_attributable_deaths_000_in_children__5c56ce92" FLOAT -- Second Hand Smoke Attributable Deaths, 000, In Children Under 5 Years
);
CREATE TABLE owid_second_hand_smoke_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"second_hand_smoke_attributable_deaths" FLOAT
);
CREATE TABLE owid_second_hand_smoke_attributable_deaths_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"second_hand_smoke_attributable_deaths_per_100000_capita" FLOAT
);
CREATE TABLE owid_second_hand_smoke_attributable_deaths_per_100000__cdcc472a (
"year" INTEGER,
"country" VARCHAR,
"second_hand_smoke_attributable_deaths_per_100000_child_23b05e81" FLOAT -- Second Hand Smoke Attributable Deaths Per 100000 Children Under 5 Years
);
CREATE TABLE owid_second_line_drug_susceptibility_testing_dst_available_1 (
"year" INTEGER,
"country" VARCHAR,
"second_line_drug_susceptibility_testing_dst_available" VARCHAR -- Second Line Drug Susceptibility Testing, Dst, Available
);
CREATE TABLE owid_second_line_drug_susceptibility_testing_dst_available_2 (
"year" INTEGER,
"country" VARCHAR,
"second_line_drug_susceptibility_testing_dst_available" VARCHAR -- Second Line Drug Susceptibility Testing, Dst, Available,
"second_line_drug_susceptibility_testing_dst_available_low" VARCHAR -- Second Line Drug Susceptibility Testing, Dst, Available Low,
"second_line_drug_susceptibility_testing_dst_available_high" VARCHAR -- Second Line Drug Susceptibility Testing, Dst, Available High,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_detoxification_of_alcohol_us_45495f20 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_detoxification_of_alcohol_use_disorders" VARCHAR,
"sector_for_inpatient_detoxification_of_alcohol_use_dis_b5e6280f" VARCHAR -- Sector For Inpatient Detoxification Of Alcohol Use Disorders Low,
"sector_for_inpatient_detoxification_of_alcohol_use_dis_df859388" VARCHAR -- Sector For Inpatient Detoxification Of Alcohol Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_detoxification_of_alcohol_us_94a682d2 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_detoxification_of_alcohol_use_disorders" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_detoxification_of_drug_use_d_49f38478 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_detoxification_of_drug_use_disorders" VARCHAR,
"sector_for_inpatient_detoxification_of_drug_use_disorders_low" VARCHAR,
"sector_for_inpatient_detoxification_of_drug_use_disorders_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_detoxification_of_drug_use_d_e978ffe4 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_detoxification_of_drug_use_disorders" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_treatment_of_alcohol_dependence_1 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_treatment_of_alcohol_dependence" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_treatment_of_alcohol_dependence_2 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_treatment_of_alcohol_dependence" VARCHAR,
"sector_for_inpatient_treatment_of_alcohol_dependence_low" VARCHAR,
"sector_for_inpatient_treatment_of_alcohol_dependence_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_treatment_of_drug_dependence_1 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_treatment_of_drug_dependence" VARCHAR
);
CREATE TABLE owid_sector_for_inpatient_treatment_of_drug_dependence_2 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_inpatient_treatment_of_drug_dependence" VARCHAR,
"sector_for_inpatient_treatment_of_drug_dependence_low" VARCHAR,
"sector_for_inpatient_treatment_of_drug_dependence_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_outpatient_treatment_of_alcohol_dependence_1 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_outpatient_treatment_of_alcohol_dependence" VARCHAR
);
CREATE TABLE owid_sector_for_outpatient_treatment_of_alcohol_dependence_2 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_outpatient_treatment_of_alcohol_dependence" VARCHAR,
"sector_for_outpatient_treatment_of_alcohol_dependence_low" VARCHAR,
"sector_for_outpatient_treatment_of_alcohol_dependence_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_outpatient_treatment_of_drug_dependence_1 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_outpatient_treatment_of_drug_dependence" VARCHAR
);
CREATE TABLE owid_sector_for_outpatient_treatment_of_drug_dependence_2 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_outpatient_treatment_of_drug_dependence" VARCHAR,
"sector_for_outpatient_treatment_of_drug_dependence_low" VARCHAR,
"sector_for_outpatient_treatment_of_drug_dependence_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_residential_long_term_rehabilitation_o_09bc0f32 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_residential_long_term_rehabilitation_of_dru_2d1a7908" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Drug Use Disorders
);
CREATE TABLE owid_sector_for_residential_long_term_rehabilitation_o_79159fa1 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_residential_long_term_rehabilitation_of_dru_2d1a7908" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Drug Use Disorders,
"sector_for_residential_long_term_rehabilitation_of_dru_f52e6d1c" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Drug Use Disorders Low,
"sector_for_residential_long_term_rehabilitation_of_dru_bab3bc95" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Drug Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_residential_long_term_rehabilitation_o_952acc9a (
"year" INTEGER,
"country" VARCHAR,
"sector_for_residential_long_term_rehabilitation_of_alc_288b123d" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Alcohol Use Disorders
);
CREATE TABLE owid_sector_for_residential_long_term_rehabilitation_o_d603cc20 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_residential_long_term_rehabilitation_of_alc_288b123d" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Alcohol Use Disorders,
"sector_for_residential_long_term_rehabilitation_of_alc_319d8280" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Alcohol Use Disorders Low,
"sector_for_residential_long_term_rehabilitation_of_alc_6c32729b" VARCHAR -- Sector For Residential Long Term Rehabilitation Of Alcohol Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_sector_for_substitution_maintenance_therapy_of_op_47d9cd41 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_substitution_maintenance_therapy_of_opioid__d258c58c" VARCHAR -- Sector For Substitution Maintenance Therapy Of Opioid Dependence
);
CREATE TABLE owid_sector_for_substitution_maintenance_therapy_of_op_cb8965f7 (
"year" INTEGER,
"country" VARCHAR,
"sector_for_substitution_maintenance_therapy_of_opioid__d258c58c" VARCHAR -- Sector For Substitution Maintenance Therapy Of Opioid Dependence,
"sector_for_substitution_maintenance_therapy_of_opioid__2c738c8c" VARCHAR -- Sector For Substitution Maintenance Therapy Of Opioid Dependence Low,
"sector_for_substitution_maintenance_therapy_of_opioid__525811ec" VARCHAR -- Sector For Substitution Maintenance Therapy Of Opioid Dependence High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.