Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_beds_for_mental_health_in_general_hospitals_per_1_471bd809 (
"year" INTEGER,
"country" VARCHAR,
"beds_for_mental_health_in_general_hospitals_per_100_00_ef1b86ef" FLOAT -- Beds For Mental Health In General Hospitals, Per 100–000 Population
);
CREATE TABLE owid_beds_for_the_treatment_of_substance_use_disorders_3ee7df32 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"beds_for_the_treatment_of_substance_use_disorders_per_100_000" FLOAT -- Beds For The Treatment Of Substance Use Disorders, Per 100–000
);
CREATE TABLE owid_beds_for_the_treatment_of_substance_use_disorders_ea84d8ca (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"beds_for_the_treatment_of_substance_use_disorders_per_100_000" FLOAT -- Beds For The Treatment Of Substance Use Disorders, Per 100–000,
"beds_for_the_treatment_of_substance_use_disorders_per__dd6963a7" VARCHAR -- Beds For The Treatment Of Substance Use Disorders, Per 100–000 Low,
"beds_for_the_treatment_of_substance_use_disorders_per__53227526" VARCHAR -- Beds For The Treatment Of Substance Use Disorders, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_beds_in_community_residential_facilities_per_100__62e7cc1e (
"year" INTEGER,
"country" VARCHAR,
"beds_in_community_residential_facilities_per_100_000_population" FLOAT -- Beds In Community Residential Facilities, Per 100–000 Population,
"beds_in_community_residential_facilities_per_100_000_p_3c4ab75e" VARCHAR -- Beds In Community Residential Facilities, Per 100–000 Population Low,
"beds_in_community_residential_facilities_per_100_000_p_454e9563" VARCHAR -- Beds In Community Residential Facilities, Per 100–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_beds_in_community_residential_facilities_per_100__689e18b8 (
"year" INTEGER,
"country" VARCHAR,
"beds_in_community_residential_facilities_per_100_000_population" FLOAT -- Beds In Community Residential Facilities, Per 100–000 Population
);
CREATE TABLE owid_beds_in_mental_hospitals_per_100_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"beds_in_mental_hospitals_per_100_000_population" FLOAT -- Beds In Mental Hospitals, Per 100–000 Population
);
CREATE TABLE owid_beds_in_mental_hospitals_per_100_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"beds_in_mental_hospitals_per_100_000_population" FLOAT -- Beds In Mental Hospitals, Per 100–000 Population,
"beds_in_mental_hospitals_per_100_000_population_low" VARCHAR -- Beds In Mental Hospitals, Per 100–000 Population Low,
"beds_in_mental_hospitals_per_100_000_population_high" VARCHAR -- Beds In Mental Hospitals, Per 100–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_best_practice_policy_implemented_for_industrially_919f1ddb (
"year" INTEGER,
"country" VARCHAR,
"best_practice_policy_implemented_for_industrially_prod_da502aca" VARCHAR -- Best Practice Policy Implemented For Industrially Produced Trans Fatty Acids, Tfa, Y N,
"best_practice_policy_implemented_for_industrially_prod_cb50e22f" VARCHAR -- Best Practice Policy Implemented For Industrially Produced Trans Fatty Acids, Tfa, Y N Low,
"best_practice_policy_implemented_for_industrially_prod_895053ed" VARCHAR -- Best Practice Policy Implemented For Industrially Produced Trans Fatty Acids, Tfa, Y N High,
"comments" VARCHAR
);
CREATE TABLE owid_best_practice_policy_implemented_for_industrially_faf24b08 (
"year" INTEGER,
"country" VARCHAR,
"best_practice_policy_implemented_for_industrially_prod_da502aca" INTEGER -- Best Practice Policy Implemented For Industrially Produced Trans Fatty Acids, Tfa, Y N,
"comments" VARCHAR
);
CREATE TABLE owid_beverage_price_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"price" VARCHAR,
"beverage" VARCHAR,
"beverage_price" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_beverage_price_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"price" VARCHAR,
"beverage_price" FLOAT,
"beverage_price_low" VARCHAR,
"beverage_price_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_biomedical_engineers_density_per_10_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"biomedical_engineers_density_per_10_000_population" FLOAT -- Biomedical Engineers Density, Per 10–000 Population,
"comments" VARCHAR
);
CREATE TABLE owid_biomedical_engineers_density_per_10_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"biomedical_engineers_density_per_10_000_population" FLOAT -- Biomedical Engineers Density, Per 10–000 Population,
"biomedical_engineers_density_per_10_000_population_low" VARCHAR -- Biomedical Engineers Density, Per 10–000 Population Low,
"biomedical_engineers_density_per_10_000_population_high" VARCHAR -- Biomedical Engineers Density, Per 10–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_biomedical_technicians_density_per_10_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"biomedical_technicians_density_per_10_000_population" FLOAT -- Biomedical Technicians Density, Per 10–000 Population,
"comments" VARCHAR
);
CREATE TABLE owid_biomedical_technicians_density_per_10_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"biomedical_technicians_density_per_10_000_population" FLOAT -- Biomedical Technicians Density, Per 10–000 Population,
"biomedical_technicians_density_per_10_000_population_low" VARCHAR -- Biomedical Technicians Density, Per 10–000 Population Low,
"biomedical_technicians_density_per_10_000_population_high" VARCHAR -- Biomedical Technicians Density, Per 10–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_births_attended_by_skilled_health_personnel_in_th_521b9f6a (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"residence_area_type" VARCHAR,
"education_level" VARCHAR,
"births_attended_by_skilled_health_personnel_in_the_two_7442c0f4" FLOAT -- Births Attended By Skilled Health Personnel, In The Two Or Three Years Preceding The Survey, Pct,
"births_attended_by_skilled_health_personnel_in_the_two_d3e58bfa" FLOAT -- Births Attended By Skilled Health Personnel, In The Two Or Three Years Preceding The Survey, Pct Low,
"births_attended_by_skilled_health_personnel_in_the_two_3c5f4805" FLOAT -- Births Attended By Skilled Health Personnel, In The Two Or Three Years Preceding The Survey, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_births_attended_by_skilled_health_personnel_in_th_7f8716db (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"births_attended_by_skilled_health_personnel_in_the_two_7442c0f4" FLOAT -- Births Attended By Skilled Health Personnel, In The Two Or Three Years Preceding The Survey, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_births_attended_by_skilled_health_personnel_in_th_86f9c2ee (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"education_level" VARCHAR,
"residence_area_type" VARCHAR,
"births_attended_by_skilled_health_personnel_in_the_fiv_ec0ff362" FLOAT -- Births Attended By Skilled Health Personnel, In The Five Years Preceding The Survey, Pct,
"births_attended_by_skilled_health_personnel_in_the_fiv_bef1a67a" FLOAT -- Births Attended By Skilled Health Personnel, In The Five Years Preceding The Survey, Pct Low,
"births_attended_by_skilled_health_personnel_in_the_fiv_dd839b23" FLOAT -- Births Attended By Skilled Health Personnel, In The Five Years Preceding The Survey, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_births_attended_by_skilled_health_personnel_in_th_9a77a62a (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"births_attended_by_skilled_health_personnel_in_the_fiv_ec0ff362" FLOAT -- Births Attended By Skilled Health Personnel, In The Five Years Preceding The Survey, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_births_attended_by_skilled_health_personnel_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"births_attended_by_skilled_health_personnel_pct" FLOAT -- Births Attended By Skilled Health Personnel, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_births_attended_by_skilled_health_personnel_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"births_attended_by_skilled_health_personnel_pct" INTEGER -- Births Attended By Skilled Health Personnel, Pct,
"births_attended_by_skilled_health_personnel_pct_low" VARCHAR -- Births Attended By Skilled Health Personnel, Pct Low,
"births_attended_by_skilled_health_personnel_pct_high" VARCHAR -- Births Attended By Skilled Health Personnel, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_births_by_caesarean_section_in_the_five_years_pre_0350cef9 (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"education_level" VARCHAR,
"births_by_caesarean_section_in_the_five_years_precedin_8221683a" FLOAT -- Births By Caesarean Section, In The Five Years Preceding The Survey, Pct,
"births_by_caesarean_section_in_the_five_years_precedin_9390f573" FLOAT -- Births By Caesarean Section, In The Five Years Preceding The Survey, Pct Low,
"births_by_caesarean_section_in_the_five_years_precedin_d3a88519" FLOAT -- Births By Caesarean Section, In The Five Years Preceding The Survey, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_births_by_caesarean_section_in_the_five_years_pre_b8d735aa (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"births_by_caesarean_section_in_the_five_years_precedin_8221683a" FLOAT -- Births By Caesarean Section, In The Five Years Preceding The Survey, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_births_by_caesarean_section_in_the_two_or_three_y_8ae4ae8e (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"education_level" VARCHAR,
"births_by_caesarean_section_in_the_two_or_three_years__f411cc1d" FLOAT -- Births By Caesarean Section, In The Two Or Three Years Preceding The Survey, Pct,
"births_by_caesarean_section_in_the_two_or_three_years__7522d52d" FLOAT -- Births By Caesarean Section, In The Two Or Three Years Preceding The Survey, Pct Low,
"births_by_caesarean_section_in_the_two_or_three_years__57d26837" FLOAT -- Births By Caesarean Section, In The Two Or Three Years Preceding The Survey, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_births_by_caesarean_section_in_the_two_or_three_y_e780780d (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"births_by_caesarean_section_in_the_two_or_three_years__f411cc1d" FLOAT -- Births By Caesarean Section, In The Two Or Three Years Preceding The Survey, Pct,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.