Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_infant_mortality_rate_between_birth_and_11_months_d62362fc (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"infant_mortality_rate_between_birth_and_11_months_per__bd8aefe3" FLOAT -- Infant Mortality Rate, Between Birth And 11 Months Per 1000 Live Births
);
CREATE TABLE owid_infant_mortality_rate_deaths_per_1000_live_births_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" 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,
"infant_mortality_rate_deaths_per_1000_live_births" FLOAT -- Infant Mortality Rate, Deaths Per 1000 Live Births,
"comments" VARCHAR
);
CREATE TABLE owid_infant_mortality_rate_deaths_per_1000_live_births_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" 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,
"infant_mortality_rate_deaths_per_1000_live_births" FLOAT -- Infant Mortality Rate, Deaths Per 1000 Live Births,
"infant_mortality_rate_deaths_per_1000_live_births_low" FLOAT -- Infant Mortality Rate, Deaths Per 1000 Live Births Low,
"infant_mortality_rate_deaths_per_1000_live_births_high" FLOAT -- Infant Mortality Rate, Deaths Per 1000 Live Births High,
"comments" VARCHAR
);
CREATE TABLE owid_infants_exclusively_breastfed_for_the_first_six_m_abe5d316 (
"year" INTEGER,
"country" VARCHAR,
"infants_exclusively_breastfed_for_the_first_six_months_e7bf3c52" FLOAT -- Infants Exclusively Breastfed For The First Six Months Of Life, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_infants_exclusively_breastfed_for_the_first_six_m_c70daf12 (
"year" INTEGER,
"country" VARCHAR,
"infants_exclusively_breastfed_for_the_first_six_months_e7bf3c52" FLOAT -- Infants Exclusively Breastfed For The First Six Months Of Life, Pct,
"infants_exclusively_breastfed_for_the_first_six_months_9952ce5e" FLOAT -- Infants Exclusively Breastfed For The First Six Months Of Life, Pct Low,
"infants_exclusively_breastfed_for_the_first_six_months_90cdea41" FLOAT -- Infants Exclusively Breastfed For The First Six Months Of Life, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_inflation_adjusted_prices_for_most_sold_brand_of__5168b288 (
"year" INTEGER,
"country" VARCHAR,
"price" VARCHAR,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_a32852a4" FLOAT -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Prices In Purchasing Power Parity Adjusted By Year On Year Changes In Average Consumer Prices In The United States Of America,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_3e5afc05" VARCHAR -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Prices In Purchasing Power Parity Adjusted By Year On Year Changes In Average Consumer Prices In The United States Of America Low,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_8067c5e4" VARCHAR -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Prices In Purchasing Power Parity Adjusted By Year On Year Changes In Average Consumer Prices In The United States Of America High,
"comments" VARCHAR
);
CREATE TABLE owid_inflation_adjusted_prices_for_most_sold_brand_of__9919c6c2 (
"year" INTEGER,
"country" VARCHAR,
"price" VARCHAR,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_a32852a4" FLOAT -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Prices In Purchasing Power Parity Adjusted By Year On Year Changes In Average Consumer Prices In The United States Of America
);
CREATE TABLE owid_inflation_adjusted_prices_for_most_sold_brand_of__d4c7f3d6 (
"year" INTEGER,
"country" VARCHAR,
"price" VARCHAR,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_509c9eca" FLOAT -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Price In Local Currency Adjusted By Year On Year Changes In Average Consumer Prices In Each Country
);
CREATE TABLE owid_inflation_adjusted_prices_for_most_sold_brand_of__d8fbba77 (
"year" INTEGER,
"country" VARCHAR,
"price" VARCHAR,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_509c9eca" FLOAT -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Price In Local Currency Adjusted By Year On Year Changes In Average Consumer Prices In Each Country,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_c2fe5bf6" VARCHAR -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Price In Local Currency Adjusted By Year On Year Changes In Average Consumer Prices In Each Country Low,
"inflation_adjusted_prices_for_most_sold_brand_of_cigar_d3f28d8f" VARCHAR -- Inflation Adjusted Prices For Most Sold Brand Of Cigarettes, Price In Local Currency Adjusted By Year On Year Changes In Average Consumer Prices In Each Country High,
"comments" VARCHAR
);
CREATE TABLE owid_information_education_prevention_1 (
"year" INTEGER,
"country" VARCHAR,
"information_education_prevention" VARCHAR -- Information, Education, Prevention
);
CREATE TABLE owid_information_education_prevention_2 (
"year" INTEGER,
"country" VARCHAR,
"information_education_prevention" VARCHAR -- Information, Education, Prevention,
"information_education_prevention_low" VARCHAR -- Information, Education, Prevention Low,
"information_education_prevention_high" VARCHAR -- Information, Education, Prevention High,
"comments" VARCHAR
);
CREATE TABLE owid_information_requirements_1 (
"year" INTEGER,
"country" VARCHAR,
"sunbed_public_information_requirements" VARCHAR,
"comments" VARCHAR,
"information_requirements" VARCHAR
);
CREATE TABLE owid_information_requirements_2 (
"year" INTEGER,
"country" VARCHAR,
"sunbed_public_information_requirements" VARCHAR,
"information_requirements" VARCHAR,
"information_requirements_low" VARCHAR,
"information_requirements_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_infrastructure_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"infrastructure" VARCHAR
);
CREATE TABLE owid_infrastructure_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"infrastructure" VARCHAR,
"infrastructure_low" VARCHAR,
"infrastructure_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_active_drug_use_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_active_drug_use_diagnosis_number_of_diagnoses" INTEGER -- In Prison Active Drug Use Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_active_drug_use_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_active_drug_use_diagnosis_number_of_diagnoses" INTEGER -- In Prison Active Drug Use Diagnosis, Number Of Diagnoses,
"in_prison_active_drug_use_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Active Drug Use Diagnosis, Number Of Diagnoses Low,
"in_prison_active_drug_use_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Active Drug Use Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_cancer_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_cancer_diagnosis_number_of_diagnoses" INTEGER -- In Prison Cancer Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_cancer_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_cancer_diagnosis_number_of_diagnoses" INTEGER -- In Prison Cancer Diagnosis, Number Of Diagnoses,
"in_prison_cancer_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Cancer Diagnosis, Number Of Diagnoses Low,
"in_prison_cancer_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Cancer Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_cardiovascular_disease_diagnosis_number_589b21b7 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_cardiovascular_disease_diagnosis_number_of_diagnoses" INTEGER -- In Prison Cardiovascular Disease Diagnosis, Number Of Diagnoses,
"in_prison_cardiovascular_disease_diagnosis_number_of_d_4a5d9d8e" VARCHAR -- In Prison Cardiovascular Disease Diagnosis, Number Of Diagnoses Low,
"in_prison_cardiovascular_disease_diagnosis_number_of_d_2fd1a726" VARCHAR -- In Prison Cardiovascular Disease Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_cardiovascular_disease_diagnosis_number_bbdbfa78 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_cardiovascular_disease_diagnosis_number_of_diagnoses" INTEGER -- In Prison Cardiovascular Disease Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_clinical_health_records_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_clinical_health_records" VARCHAR
);
CREATE TABLE owid_in_prison_clinical_health_records_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_clinical_health_records" VARCHAR,
"in_prison_clinical_health_records_low" VARCHAR,
"in_prison_clinical_health_records_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_condoms_free_of_charge_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_condoms_free_of_charge" VARCHAR
);
CREATE TABLE owid_in_prison_condoms_free_of_charge_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_condoms_free_of_charge" VARCHAR,
"in_prison_condoms_free_of_charge_low" VARCHAR,
"in_prison_condoms_free_of_charge_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.