Global Health Observatory - World Health Organization

CREATE TABLE owid_inclusion_of_radon_in_different_national_strategies_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "radon_subquestions" VARCHAR,
  "inclusion_of_radon_in_different_national_strategies" VARCHAR,
  "inclusion_of_radon_in_different_national_strategies_low" VARCHAR,
  "inclusion_of_radon_in_different_national_strategies_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_radon_measurements_in_property_transactions_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "inclusion_of_radon_measurements_in_property_transactions" VARCHAR
);

CREATE TABLE owid_inclusion_of_radon_measurements_in_property_transactions_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_radon_measurements_in_property_transactions" VARCHAR,
  "inclusion_of_radon_measurements_in_property_transactions_low" VARCHAR,
  "inclusion_of_radon_measurements_in_property_transactions_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_research_and_innovation_as_a_specifi_41b3f698 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_research_and_innovation_as_a_specific_act_8ba1aa78" VARCHAR  -- Inclusion Of Research And Innovation As A Specific Action Of The Dementia Plan,
  "inclusion_of_research_and_innovation_as_a_specific_act_f0737a5b" VARCHAR  -- Inclusion Of Research And Innovation As A Specific Action Of The Dementia Plan Low,
  "inclusion_of_research_and_innovation_as_a_specific_act_172371b3" VARCHAR  -- Inclusion Of Research And Innovation As A Specific Action Of The Dementia Plan High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_research_and_innovation_as_a_specifi_d86ef16c (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_research_and_innovation_as_a_specific_act_8ba1aa78" VARCHAR  -- Inclusion Of Research And Innovation As A Specific Action Of The Dementia Plan
);

CREATE TABLE owid_inclusion_of_support_for_dementia_carers_and_fami_6a5be14e (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_support_for_dementia_carers_and_families__737007ca" VARCHAR  -- Inclusion Of Support For Dementia Carers And Families As A Specific Action Of The Dementia Plan
);

CREATE TABLE owid_inclusion_of_support_for_dementia_carers_and_fami_a3228263 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_support_for_dementia_carers_and_families__737007ca" VARCHAR  -- Inclusion Of Support For Dementia Carers And Families As A Specific Action Of The Dementia Plan,
  "inclusion_of_support_for_dementia_carers_and_families__45cac150" VARCHAR  -- Inclusion Of Support For Dementia Carers And Families As A Specific Action Of The Dementia Plan Low,
  "inclusion_of_support_for_dementia_carers_and_families__13a21af2" VARCHAR  -- Inclusion Of Support For Dementia Carers And Families As A Specific Action Of The Dementia Plan High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_universal_health_coverage_as_a_guidi_94ecc688 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_universal_health_coverage_as_a_guiding_pr_edc5b24a" VARCHAR  -- Inclusion Of Universal Health Coverage As A Guiding Principle Of The Dementia Plan
);

CREATE TABLE owid_inclusion_of_universal_health_coverage_as_a_guidi_f6f1d14b (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_universal_health_coverage_as_a_guiding_pr_edc5b24a" VARCHAR  -- Inclusion Of Universal Health Coverage As A Guiding Principle Of The Dementia Plan,
  "inclusion_of_universal_health_coverage_as_a_guiding_pr_77aa3952" VARCHAR  -- Inclusion Of Universal Health Coverage As A Guiding Principle Of The Dementia Plan Low,
  "inclusion_of_universal_health_coverage_as_a_guiding_pr_1e6c8f1b" VARCHAR  -- Inclusion Of Universal Health Coverage As A Guiding Principle Of The Dementia Plan High,
  "comments" VARCHAR
);

CREATE TABLE owid_income_level_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "income_level" VARCHAR
);

CREATE TABLE owid_income_level_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "income_level" VARCHAR,
  "income_level_low" VARCHAR,
  "income_level_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_0f504ccd (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_947b0e05" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of A Relative Poverty Line, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_1c32df0e (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_f0b65c8d" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–65 A Day Poverty Line, Pct, National, Rural, Urban
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_22e82923 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_be97e590" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar2–15 A Day Poverty Line, Pct, National, Rural, Urban,
  "increase_in_poverty_gap_due_to_household_health_expend_7bd2175b" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar2–15 A Day Poverty Line, Pct, National, Rural, Urban Low,
  "increase_in_poverty_gap_due_to_household_health_expend_61fda9fe" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar2–15 A Day Poverty Line, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_23796d76 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_aadd5008" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–20 A Day Poverty Line, Pct, National, Rural, Urban
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_30c49dfa (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_947b0e05" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of A Relative Poverty Line, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban,
  "increase_in_poverty_gap_due_to_household_health_expend_cf2017f3" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of A Relative Poverty Line, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban Low,
  "increase_in_poverty_gap_due_to_household_health_expend_7d2c38d8" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of A Relative Poverty Line, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_3cbd7294 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_aadd5008" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–20 A Day Poverty Line, Pct, National, Rural, Urban,
  "increase_in_poverty_gap_due_to_household_health_expend_1dd1041c" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–20 A Day Poverty Line, Pct, National, Rural, Urban Low,
  "increase_in_poverty_gap_due_to_household_health_expend_b0f98437" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–20 A Day Poverty Line, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_6c5d1754 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_ee4f078a" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar1–90 A Day Poverty Line, Pct, National, Rural, Urban
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_aaea058c (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_ee4f078a" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar1–90 A Day Poverty Line, Pct, National, Rural, Urban,
  "increase_in_poverty_gap_due_to_household_health_expend_cffbd950" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar1–90 A Day Poverty Line, Pct, National, Rural, Urban Low,
  "increase_in_poverty_gap_due_to_household_health_expend_7bd4bd58" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar1–90 A Day Poverty Line, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_increase_in_poverty_gap_due_to_household_health_e_e2764448 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "increase_in_poverty_gap_due_to_household_health_expend_f0b65c8d" FLOAT  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–65 A Day Poverty Line, Pct, National, Rural, Urban,
  "increase_in_poverty_gap_due_to_household_health_expend_dd84f546" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–65 A Day Poverty Line, Pct, National, Rural, Urban Low,
  "increase_in_poverty_gap_due_to_household_health_expend_396abd1c" VARCHAR  -- Increase In Poverty Gap Due To Household Health Expenditures, Expressed As A Proportion Of The Dollar3–65 A Day Poverty Line, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_indicator_16_2_1_proportion_of_children_aged_1_17_026d3532 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "indicator_16_2_1_proportion_of_children_aged_1_17_year_7fead67a" FLOAT  -- Indicator 16–2 1, Proportion Of Children Aged 1–17 Years Who Experienced Any Physical Punishment And Or Psychological Aggression By Caregivers In The Past Month,
  "comments" VARCHAR
);

CREATE TABLE owid_indicator_16_2_1_proportion_of_children_aged_1_17_0b5d93ad (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "indicator_16_2_1_proportion_of_children_aged_1_17_year_7fead67a" FLOAT  -- Indicator 16–2 1, Proportion Of Children Aged 1–17 Years Who Experienced Any Physical Punishment And Or Psychological Aggression By Caregivers In The Past Month,
  "indicator_16_2_1_proportion_of_children_aged_1_17_year_ea53c1c3" VARCHAR  -- Indicator 16–2 1, Proportion Of Children Aged 1–17 Years Who Experienced Any Physical Punishment And Or Psychological Aggression By Caregivers In The Past Month Low,
  "indicator_16_2_1_proportion_of_children_aged_1_17_year_c40a1f2b" VARCHAR  -- Indicator 16–2 1, Proportion Of Children Aged 1–17 Years Who Experienced Any Physical Punishment And Or Psychological Aggression By Caregivers In The Past Month High,
  "comments" VARCHAR
);

CREATE TABLE owid_individuals_have_the_legal_right_to_specify_which_08ffb576 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "individuals_have_the_legal_right_to_specify_which_heal_3a52b425" VARCHAR  -- Individuals Have The Legal Right To Specify Which Health Related Data From Their Ehr Can Be Shared With Health Professionals Of Their Choice,
  "individuals_have_the_legal_right_to_specify_which_heal_dcb43831" VARCHAR  -- Individuals Have The Legal Right To Specify Which Health Related Data From Their Ehr Can Be Shared With Health Professionals Of Their Choice Low,
  "individuals_have_the_legal_right_to_specify_which_heal_f02df37b" VARCHAR  -- Individuals Have The Legal Right To Specify Which Health Related Data From Their Ehr Can Be Shared With Health Professionals Of Their Choice High,
  "comments" VARCHAR
);

CREATE TABLE owid_individuals_have_the_legal_right_to_specify_which_b6ac6766 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "individuals_have_the_legal_right_to_specify_which_heal_3a52b425" VARCHAR  -- Individuals Have The Legal Right To Specify Which Health Related Data From Their Ehr Can Be Shared With Health Professionals Of Their Choice
);

CREATE TABLE owid_infant_mortality_rate_between_birth_and_11_months_001de9e6 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "infant_mortality_rate_between_birth_and_11_months_per__bd8aefe3" FLOAT  -- Infant Mortality Rate, Between Birth And 11 Months Per 1000 Live Births,
  "infant_mortality_rate_between_birth_and_11_months_per__6b653c35" FLOAT  -- Infant Mortality Rate, Between Birth And 11 Months Per 1000 Live Births Low,
  "infant_mortality_rate_between_birth_and_11_months_per__1b16e221" FLOAT  -- Infant Mortality Rate, Between Birth And 11 Months Per 1000 Live Births High,
  "comments" VARCHAR
);