Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_bupropion_cost_covered_1 (
"year" INTEGER,
"country" VARCHAR,
"bupropion_cost_covered" VARCHAR -- Bupropion, Cost Covered
);
CREATE TABLE owid_bupropion_cost_covered_2 (
"year" INTEGER,
"country" VARCHAR,
"bupropion_cost_covered" VARCHAR -- Bupropion, Cost Covered,
"bupropion_cost_covered_low" VARCHAR -- Bupropion, Cost Covered Low,
"bupropion_cost_covered_high" VARCHAR -- Bupropion, Cost Covered High,
"comments" VARCHAR
);
CREATE TABLE owid_bupropion_legally_sold_1 (
"year" INTEGER,
"country" VARCHAR,
"bupropion_legally_sold" VARCHAR -- Bupropion, Legally Sold
);
CREATE TABLE owid_bupropion_legally_sold_2 (
"year" INTEGER,
"country" VARCHAR,
"bupropion_legally_sold" VARCHAR -- Bupropion, Legally Sold,
"bupropion_legally_sold_low" VARCHAR -- Bupropion, Legally Sold Low,
"bupropion_legally_sold_high" VARCHAR -- Bupropion, Legally Sold High,
"comments" VARCHAR
);
CREATE TABLE owid_bupropion_place_available_1 (
"year" INTEGER,
"country" VARCHAR,
"bupropion_place_available" VARCHAR -- Bupropion, Place Available
);
CREATE TABLE owid_bupropion_place_available_2 (
"year" INTEGER,
"country" VARCHAR,
"bupropion_place_available" VARCHAR -- Bupropion, Place Available,
"bupropion_place_available_low" VARCHAR -- Bupropion, Place Available Low,
"bupropion_place_available_high" VARCHAR -- Bupropion, Place Available High,
"comments" VARCHAR
);
CREATE TABLE owid_campaign_ran_on_both_national_television_and_radio_1 (
"year" INTEGER,
"country" VARCHAR,
"campaign_ran_on_both_national_television_and_radio" VARCHAR
);
CREATE TABLE owid_campaign_ran_on_both_national_television_and_radio_2 (
"year" INTEGER,
"country" VARCHAR,
"campaign_ran_on_both_national_television_and_radio" VARCHAR,
"campaign_ran_on_both_national_television_and_radio_low" VARCHAR,
"campaign_ran_on_both_national_television_and_radio_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_campaign_utilized_media_planning_1 (
"year" INTEGER,
"country" VARCHAR,
"campaign_utilized_media_planning" VARCHAR
);
CREATE TABLE owid_campaign_utilized_media_planning_2 (
"year" INTEGER,
"country" VARCHAR,
"campaign_utilized_media_planning" VARCHAR,
"campaign_utilized_media_planning_low" VARCHAR,
"campaign_utilized_media_planning_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_campaign_was_part_of_a_comprehensive_tobacco_cont_69fe74f4 (
"year" INTEGER,
"country" VARCHAR,
"campaign_was_part_of_a_comprehensive_tobacco_control_programme" VARCHAR
);
CREATE TABLE owid_campaign_was_part_of_a_comprehensive_tobacco_cont_c7e51de9 (
"year" INTEGER,
"country" VARCHAR,
"campaign_was_part_of_a_comprehensive_tobacco_control_programme" VARCHAR,
"campaign_was_part_of_a_comprehensive_tobacco_control_p_148aaa47" VARCHAR -- Campaign Was Part Of A Comprehensive Tobacco Control Programme Low,
"campaign_was_part_of_a_comprehensive_tobacco_control_p_341229d2" VARCHAR -- Campaign Was Part Of A Comprehensive Tobacco Control Programme High,
"comments" VARCHAR
);
CREATE TABLE owid_campaign_was_pre_tested_1 (
"year" INTEGER,
"country" VARCHAR,
"campaign_was_pre_tested" VARCHAR
);
CREATE TABLE owid_campaign_was_pre_tested_2 (
"year" INTEGER,
"country" VARCHAR,
"campaign_was_pre_tested" VARCHAR,
"campaign_was_pre_tested_low" VARCHAR,
"campaign_was_pre_tested_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_cancer_age_standardized_death_rates_15plus_per_10_41da409d (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"cancer_age_standardized_death_rates_15plus_per_100_000_70a6e9b6" FLOAT -- Cancer, Age Standardized Death Rates, 15plus, Per 100–000 Population
);
CREATE TABLE owid_cancer_age_standardized_death_rates_15plus_per_10_4efdad06 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"cancer_age_standardized_death_rates_15plus_per_100_000_70a6e9b6" FLOAT -- Cancer, Age Standardized Death Rates, 15plus, Per 100–000 Population,
"cancer_age_standardized_death_rates_15plus_per_100_000_3a7cc64c" VARCHAR -- Cancer, Age Standardized Death Rates, 15plus, Per 100–000 Population Low,
"cancer_age_standardized_death_rates_15plus_per_100_000_b8c410f5" VARCHAR -- Cancer, Age Standardized Death Rates, 15plus, Per 100–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_capacity_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"capacity" VARCHAR
);
CREATE TABLE owid_capacity_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"capacity" VARCHAR,
"capacity_low" VARCHAR,
"capacity_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_capacity_building_required_for_new_skills_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"capacity_building_required_for_new_skills" VARCHAR
);
CREATE TABLE owid_capacity_building_required_for_new_skills_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"capacity_building_required_for_new_skills" VARCHAR,
"capacity_building_required_for_new_skills_low" VARCHAR,
"capacity_building_required_for_new_skills_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_carbamate_resistance_reported_for_at_least_one_site_1 (
"year" INTEGER,
"country" VARCHAR,
"carbamate_resistance_reported_for_at_least_one_site" VARCHAR
);
CREATE TABLE owid_carbamate_resistance_reported_for_at_least_one_site_2 (
"year" INTEGER,
"country" VARCHAR,
"carbamate_resistance_reported_for_at_least_one_site" VARCHAR,
"carbamate_resistance_reported_for_at_least_one_site_low" VARCHAR,
"carbamate_resistance_reported_for_at_least_one_site_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_care_facilities_hospice_centres_1 (
"year" INTEGER,
"country" VARCHAR,
"care_facilities_hospice_centres" VARCHAR -- Care Facilities, Hospice Centres
);
CREATE TABLE owid_care_facilities_hospice_centres_2 (
"year" INTEGER,
"country" VARCHAR,
"care_facilities_hospice_centres" VARCHAR -- Care Facilities, Hospice Centres,
"care_facilities_hospice_centres_low" VARCHAR -- Care Facilities, Hospice Centres Low,
"care_facilities_hospice_centres_high" VARCHAR -- Care Facilities, Hospice Centres High,
"comments" VARCHAR
);
CREATE TABLE owid_care_facilities_long_term_care_1 (
"year" INTEGER,
"country" VARCHAR,
"care_facilities_long_term_care" VARCHAR -- Care Facilities, Long Term Care
);
Anyone who has the link will be able to view this.