Global Health Observatory - World Health Organization

CREATE TABLE owid_measles_immunization_coverage_among_one_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" 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,
  "measles_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Measles Immunization Coverage Among One Year Olds, Pct,
  "measles_immunization_coverage_among_one_year_olds_pct_low" FLOAT  -- Measles Immunization Coverage Among One Year Olds, Pct Low,
  "measles_immunization_coverage_among_one_year_olds_pct_high" FLOAT  -- Measles Immunization Coverage Among One Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_measles_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "measles_number_of_reported_cases" UINTEGER  -- Measles, Number Of Reported Cases
);

CREATE TABLE owid_measles_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "measles_number_of_reported_cases" UINTEGER  -- Measles, Number Of Reported Cases,
  "measles_number_of_reported_cases_low" VARCHAR  -- Measles, Number Of Reported Cases Low,
  "measles_number_of_reported_cases_high" VARCHAR  -- Measles, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_median_availability_of_selected_generic_medicines_22227314 (
  "year" INTEGER,
  "country" VARCHAR,
  "median_availability_of_selected_generic_medicines_pct_public" FLOAT  -- Median Availability Of Selected Generic Medicines, Pct, Public,
  "median_availability_of_selected_generic_medicines_pct__4d7a2422" VARCHAR  -- Median Availability Of Selected Generic Medicines, Pct, Public Low,
  "median_availability_of_selected_generic_medicines_pct__89f3ed75" VARCHAR  -- Median Availability Of Selected Generic Medicines, Pct, Public High,
  "comments" VARCHAR
);

CREATE TABLE owid_median_availability_of_selected_generic_medicines_2ebb3871 (
  "year" INTEGER,
  "country" VARCHAR,
  "median_availability_of_selected_generic_medicines_pct_private" FLOAT  -- Median Availability Of Selected Generic Medicines, Pct, Private,
  "median_availability_of_selected_generic_medicines_pct__e621adca" VARCHAR  -- Median Availability Of Selected Generic Medicines, Pct, Private Low,
  "median_availability_of_selected_generic_medicines_pct__4df921bb" VARCHAR  -- Median Availability Of Selected Generic Medicines, Pct, Private High,
  "comments" VARCHAR
);

CREATE TABLE owid_median_availability_of_selected_generic_medicines_4b6c83be (
  "year" INTEGER,
  "country" VARCHAR,
  "median_availability_of_selected_generic_medicines_pct_private" FLOAT  -- Median Availability Of Selected Generic Medicines, Pct, Private,
  "comments" VARCHAR
);

CREATE TABLE owid_median_availability_of_selected_generic_medicines_bcbc9812 (
  "year" INTEGER,
  "country" VARCHAR,
  "median_availability_of_selected_generic_medicines_pct_public" FLOAT  -- Median Availability Of Selected Generic Medicines, Pct, Public,
  "comments" VARCHAR
);

CREATE TABLE owid_median_consumer_price_ratio_of_selected_generic_m_01bccf98 (
  "year" INTEGER,
  "country" VARCHAR,
  "median_consumer_price_ratio_of_selected_generic_medici_33f5c532" FLOAT  -- Median Consumer Price Ratio Of Selected Generic Medicines, Private,
  "median_consumer_price_ratio_of_selected_generic_medici_385207bc" VARCHAR  -- Median Consumer Price Ratio Of Selected Generic Medicines, Private Low,
  "median_consumer_price_ratio_of_selected_generic_medici_7c091ef2" VARCHAR  -- Median Consumer Price Ratio Of Selected Generic Medicines, Private High,
  "comments" VARCHAR
);

CREATE TABLE owid_median_consumer_price_ratio_of_selected_generic_m_35a50a0d (
  "year" INTEGER,
  "country" VARCHAR,
  "median_consumer_price_ratio_of_selected_generic_medici_236e64fd" FLOAT  -- Median Consumer Price Ratio Of Selected Generic Medicines, Public,
  "median_consumer_price_ratio_of_selected_generic_medici_be3869f5" VARCHAR  -- Median Consumer Price Ratio Of Selected Generic Medicines, Public Low,
  "median_consumer_price_ratio_of_selected_generic_medici_038c35fa" VARCHAR  -- Median Consumer Price Ratio Of Selected Generic Medicines, Public High,
  "comments" VARCHAR
);

CREATE TABLE owid_median_consumer_price_ratio_of_selected_generic_m_8c44577e (
  "year" INTEGER,
  "country" VARCHAR,
  "median_consumer_price_ratio_of_selected_generic_medici_236e64fd" FLOAT  -- Median Consumer Price Ratio Of Selected Generic Medicines, Public,
  "comments" VARCHAR
);

CREATE TABLE owid_median_consumer_price_ratio_of_selected_generic_m_bf75a424 (
  "year" INTEGER,
  "country" VARCHAR,
  "median_consumer_price_ratio_of_selected_generic_medici_33f5c532" FLOAT  -- Median Consumer Price Ratio Of Selected Generic Medicines, Private,
  "comments" VARCHAR
);

CREATE TABLE owid_median_urinary_iodine_concentration_in_children_6_522cb58f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "median_urinary_iodine_concentration_in_children_6_12_years_mg_l" FLOAT  -- Median Urinary Iodine Concentration In Children 6–12 Years, Mg L,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_and_pathology_laboratory_scientists_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_and_pathology_laboratory_scientists_number" UINTEGER  -- Medical And Pathology Laboratory Scientists, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_and_pathology_laboratory_scientists_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_and_pathology_laboratory_scientists_number" UINTEGER  -- Medical And Pathology Laboratory Scientists, Number,
  "medical_and_pathology_laboratory_scientists_number_low" VARCHAR  -- Medical And Pathology Laboratory Scientists, Number Low,
  "medical_and_pathology_laboratory_scientists_number_high" VARCHAR  -- Medical And Pathology Laboratory Scientists, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_and_pathology_laboratory_technicians_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_and_pathology_laboratory_technicians_number" UINTEGER  -- Medical And Pathology Laboratory Technicians, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_and_pathology_laboratory_technicians_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_and_pathology_laboratory_technicians_number" UINTEGER  -- Medical And Pathology Laboratory Technicians, Number,
  "medical_and_pathology_laboratory_technicians_number_low" VARCHAR  -- Medical And Pathology Laboratory Technicians, Number Low,
  "medical_and_pathology_laboratory_technicians_number_high" VARCHAR  -- Medical And Pathology Laboratory Technicians, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_not_further_defined_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_doctors_not_further_defined_number" UINTEGER  -- Medical Doctors Not Further Defined, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_not_further_defined_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_doctors_not_further_defined_number" UINTEGER  -- Medical Doctors Not Further Defined, Number,
  "medical_doctors_not_further_defined_number_low" VARCHAR  -- Medical Doctors Not Further Defined, Number Low,
  "medical_doctors_not_further_defined_number_high" VARCHAR  -- Medical Doctors Not Further Defined, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_doctors_number" UINTEGER  -- Medical Doctors, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_doctors_number" UINTEGER  -- Medical Doctors, Number,
  "medical_doctors_number_low" VARCHAR  -- Medical Doctors, Number Low,
  "medical_doctors_number_high" VARCHAR  -- Medical Doctors, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "medical_doctors_pct" FLOAT  -- Medical Doctors, Pct
);

CREATE TABLE owid_medical_doctors_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "medical_doctors_pct" FLOAT  -- Medical Doctors, Pct,
  "medical_doctors_pct_low" VARCHAR  -- Medical Doctors, Pct Low,
  "medical_doctors_pct_high" VARCHAR  -- Medical Doctors, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_doctors_per_10_000_population" FLOAT  -- Medical Doctors, Per 10–000 Population,
  "comments" VARCHAR
);

CREATE TABLE owid_medical_doctors_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "medical_doctors_per_10_000_population" FLOAT  -- Medical Doctors, Per 10–000 Population,
  "medical_doctors_per_10_000_population_low" VARCHAR  -- Medical Doctors, Per 10–000 Population Low,
  "medical_doctors_per_10_000_population_high" VARCHAR  -- Medical Doctors, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mental_health_day_treatment_facilities_per_100_00_17817730 (
  "year" INTEGER,
  "country" VARCHAR,
  "mental_health_day_treatment_facilities_per_100_000_population" FLOAT  -- Mental Health Day Treatment Facilities, Per 100–000 Population
);