Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_clinical_vitamin_a_deficiency_in_women_history_of_044596ae (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"clinical_vitamin_a_deficiency_in_women_history_of_nigh_ade5187a" FLOAT -- Clinical Vitamin A Deficiency In Women, History Of Night Blindness During Most Recent Pregnancy, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_commencement_of_treatment_with_opioid_agonists_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"commencement_of_treatment_with_opioid_agonists" VARCHAR
);
CREATE TABLE owid_commencement_of_treatment_with_opioid_agonists_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"commencement_of_treatment_with_opioid_agonists" VARCHAR,
"commencement_of_treatment_with_opioid_agonists_low" VARCHAR,
"commencement_of_treatment_with_opioid_agonists_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_commitments_to_recipient_countries_million_consta_6631cc89 (
"year" INTEGER,
"country" VARCHAR,
"commitments_to_recipient_countries_million_constant_2009_usd" FLOAT -- Commitments To Recipient Countries, Million, Constant 2009 Usd
);
CREATE TABLE owid_commitments_to_recipient_countries_million_consta_82db217f (
"year" INTEGER,
"country" VARCHAR,
"commitments_to_recipient_countries_million_constant_2009_usd" FLOAT -- Commitments To Recipient Countries, Million, Constant 2009 Usd,
"commitments_to_recipient_countries_million_constant_20_c378473f" VARCHAR -- Commitments To Recipient Countries, Million, Constant 2009 Usd Low,
"commitments_to_recipient_countries_million_constant_20_8d5d2fb0" VARCHAR -- Commitments To Recipient Countries, Million, Constant 2009 Usd High,
"comments" VARCHAR
);
CREATE TABLE owid_community_based_interventions_involving_stakeholders_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"community_based_interventions_involving_stakeholders" VARCHAR
);
CREATE TABLE owid_community_based_interventions_involving_stakeholders_2 (
"year" INTEGER,
"country" VARCHAR,
"community_based_interventions_involving_stakeholders" VARCHAR,
"community_based_interventions_involving_stakeholders_low" VARCHAR,
"community_based_interventions_involving_stakeholders_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_community_based_interventions_projects_involving__31fc5f74 (
"year" INTEGER,
"country" VARCHAR,
"community_based_interventions_projects_involving_stakeholders" VARCHAR
);
CREATE TABLE owid_community_based_interventions_projects_involving__e20bdb0e (
"year" INTEGER,
"country" VARCHAR,
"community_based_interventions_projects_involving_stakeholders" VARCHAR,
"community_based_interventions_projects_involving_stake_edadd965" VARCHAR -- Community Based Interventions Projects Involving Stakeholders Low,
"community_based_interventions_projects_involving_stake_0580eed2" VARCHAR -- Community Based Interventions Projects Involving Stakeholders High,
"comments" VARCHAR
);
CREATE TABLE owid_community_health_workers_number_1 (
"year" INTEGER,
"country" VARCHAR,
"community_health_workers_number" UINTEGER -- Community Health Workers, Number,
"comments" VARCHAR
);
CREATE TABLE owid_community_health_workers_number_2 (
"year" INTEGER,
"country" VARCHAR,
"community_health_workers_number" UINTEGER -- Community Health Workers, Number,
"community_health_workers_number_low" VARCHAR -- Community Health Workers, Number Low,
"community_health_workers_number_high" VARCHAR -- Community Health Workers, Number High,
"comments" VARCHAR
);
CREATE TABLE owid_community_residential_facilities_per_100_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"community_residential_facilities_per_100_000_population" FLOAT -- Community Residential Facilities, Per 100–000 Population
);
CREATE TABLE owid_community_residential_facilities_per_100_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"community_residential_facilities_per_100_000_population" FLOAT -- Community Residential Facilities, Per 100–000 Population,
"community_residential_facilities_per_100_000_population_low" VARCHAR -- Community Residential Facilities, Per 100–000 Population Low,
"community_residential_facilities_per_100_000_population_high" VARCHAR -- Community Residential Facilities, Per 100–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_competing_educational_priorities_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"competing_educational_priorities" VARCHAR
);
CREATE TABLE owid_competing_educational_priorities_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"competing_educational_priorities" VARCHAR,
"competing_educational_priorities_low" VARCHAR,
"competing_educational_priorities_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_competing_health_system_priorities_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"competing_health_system_priorities" VARCHAR
);
CREATE TABLE owid_competing_health_system_priorities_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"competing_health_system_priorities" VARCHAR,
"competing_health_system_priorities_low" VARCHAR,
"competing_health_system_priorities_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_complete_ban_on_tobacco_vending_machines_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"complete_ban_on_tobacco_vending_machines" VARCHAR
);
CREATE TABLE owid_complete_ban_on_tobacco_vending_machines_2 (
"year" INTEGER,
"country" VARCHAR,
"complete_ban_on_tobacco_vending_machines" VARCHAR,
"complete_ban_on_tobacco_vending_machines_low" VARCHAR,
"complete_ban_on_tobacco_vending_machines_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_completeness_of_cause_of_death_data_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"completeness_of_cause_of_death_data_pct" FLOAT -- Completeness Of Cause Of Death Data, Pct
);
CREATE TABLE owid_completeness_of_cause_of_death_data_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"completeness_of_cause_of_death_data_pct" FLOAT -- Completeness Of Cause Of Death Data, Pct,
"completeness_of_cause_of_death_data_pct_low" VARCHAR -- Completeness Of Cause Of Death Data, Pct Low,
"completeness_of_cause_of_death_data_pct_high" VARCHAR -- Completeness Of Cause Of Death Data, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_advertising_at_point_of_sale_1 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_advertising_at_point_of_sale" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_advertising_at_point_of_sale_2 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_advertising_at_point_of_sale" INTEGER,
"compliance_of_ban_on_advertising_at_point_of_sale_low" VARCHAR,
"compliance_of_ban_on_advertising_at_point_of_sale_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_advertising_on_billboards_an_6c31736f (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_advertising_on_billboards_and_out_7608b901" INTEGER -- Compliance Of Ban On Advertising On Billboards And Outdoor Advertising,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_advertising_on_billboards_an_c78dad67 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_advertising_on_billboards_and_out_7608b901" INTEGER -- Compliance Of Ban On Advertising On Billboards And Outdoor Advertising,
"compliance_of_ban_on_advertising_on_billboards_and_out_91e851e0" VARCHAR -- Compliance Of Ban On Advertising On Billboards And Outdoor Advertising Low,
"compliance_of_ban_on_advertising_on_billboards_and_out_492af9df" VARCHAR -- Compliance Of Ban On Advertising On Billboards And Outdoor Advertising High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.