Global Health Observatory - World Health Organization

CREATE TABLE owid_overweight_numbers_among_children_under_5_years_o_c25cf6bf (
  "year" INTEGER,
  "country" VARCHAR,
  "overweight_numbers_among_children_under_5_years_of_age_ff67fb34" FLOAT  -- Overweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_overweight_prevalence_among_children_under_5_year_3adbed99 (
  "year" INTEGER,
  "country" VARCHAR,
  "overweight_prevalence_among_children_under_5_years_of__e1a58816" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_overweight_prevalence_among_children_under_5_year_49dc287f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_tercile" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "overweight_prevalence_among_children_under_5_years_of__f12c3295" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Survey Based Estimates,
  "overweight_prevalence_among_children_under_5_years_of__f17dafa4" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Survey Based Estimates Low,
  "overweight_prevalence_among_children_under_5_years_of__1d7e5ed0" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Survey Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_overweight_prevalence_among_children_under_5_year_6776e68e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "overweight_prevalence_among_children_under_5_years_of__e1a58816" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Model Based Estimates,
  "overweight_prevalence_among_children_under_5_years_of__402d68e2" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Model Based Estimates Low,
  "overweight_prevalence_among_children_under_5_years_of__192dfc5d" FLOAT  -- Overweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Gt Plus2 Sd, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_overweight_prevalence_in_children_aged_lt_5_years_ecdb9b90 (
  "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,
  "overweight_prevalence_in_children_aged_lt_5_years_pct__db98bebe" FLOAT  -- Overweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
  "comments" VARCHAR
);

CREATE TABLE owid_overweight_prevalence_in_children_aged_lt_5_years_f0367a78 (
  "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,
  "overweight_prevalence_in_children_aged_lt_5_years_pct__db98bebe" FLOAT  -- Overweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
  "overweight_prevalence_in_children_aged_lt_5_years_pct__5116f46f" FLOAT  -- Overweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor Low,
  "overweight_prevalence_in_children_aged_lt_5_years_pct__4ac1b842" FLOAT  -- Overweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor High,
  "comments" VARCHAR
);

CREATE TABLE owid_participation_rate_in_organized_learning_one_year_8e871c7e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "participation_rate_in_organized_learning_one_year_befo_f85786dc" FLOAT  -- Participation Rate In Organized Learning, One Year Before The Official Primary Entry Age, Pct
);

CREATE TABLE owid_participation_rate_in_organized_learning_one_year_de36d80c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "participation_rate_in_organized_learning_one_year_befo_f85786dc" FLOAT  -- Participation Rate In Organized Learning, One Year Before The Official Primary Entry Age, Pct,
  "participation_rate_in_organized_learning_one_year_befo_e35b0058" VARCHAR  -- Participation Rate In Organized Learning, One Year Before The Official Primary Entry Age, Pct Low,
  "participation_rate_in_organized_learning_one_year_befo_1f72c293" VARCHAR  -- Participation Rate In Organized Learning, One Year Before The Official Primary Entry Age, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_pattern_of_antibiotic_consumption_at_national_lev_3d60f361 (
  "year" INTEGER,
  "country" VARCHAR,
  "aware_antibiotics_group" VARCHAR,
  "pattern_of_antibiotic_consumption_at_national_level_re_03e2d471" FLOAT  -- Pattern Of Antibiotic Consumption At National Level, Relative Consumption By Aware Classification,
  "pattern_of_antibiotic_consumption_at_national_level_re_79aa9c9a" VARCHAR  -- Pattern Of Antibiotic Consumption At National Level, Relative Consumption By Aware Classification Low,
  "pattern_of_antibiotic_consumption_at_national_level_re_1aae4e80" VARCHAR  -- Pattern Of Antibiotic Consumption At National Level, Relative Consumption By Aware Classification High,
  "comments" VARCHAR
);

CREATE TABLE owid_pattern_of_antibiotic_consumption_at_national_lev_e94c2e9b (
  "year" INTEGER,
  "country" VARCHAR,
  "aware_antibiotics_group" VARCHAR,
  "pattern_of_antibiotic_consumption_at_national_level_re_03e2d471" FLOAT  -- Pattern Of Antibiotic Consumption At National Level, Relative Consumption By Aware Classification,
  "comments" VARCHAR
);

CREATE TABLE owid_penalties_for_drink_driving_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "penalty_type" VARCHAR,
  "penalties_for_drink_driving" VARCHAR
);

CREATE TABLE owid_penalties_for_drink_driving_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "penalty_type" VARCHAR,
  "penalties_for_drink_driving" VARCHAR,
  "penalties_for_drink_driving_low" VARCHAR,
  "penalties_for_drink_driving_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_penalties_for_drink_driving_repeated_offense_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "penalty_type" VARCHAR,
  "penalties_for_drink_driving_repeated_offense" VARCHAR  -- Penalties For Drink Driving, Repeated Offense
);

CREATE TABLE owid_penalties_for_drink_driving_repeated_offense_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "penalty_type" VARCHAR,
  "penalties_for_drink_driving_repeated_offense" VARCHAR  -- Penalties For Drink Driving, Repeated Offense,
  "penalties_for_drink_driving_repeated_offense_low" VARCHAR  -- Penalties For Drink Driving, Repeated Offense Low,
  "penalties_for_drink_driving_repeated_offense_high" VARCHAR  -- Penalties For Drink Driving, Repeated Offense High,
  "comments" VARCHAR
);

CREATE TABLE owid_penalties_for_marketing_infringements_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "penalties_for_marketing_infringements" VARCHAR
);

CREATE TABLE owid_penalties_for_marketing_infringements_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "penalties_for_marketing_infringements" VARCHAR,
  "penalties_for_marketing_infringements_low" VARCHAR,
  "penalties_for_marketing_infringements_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_per_capita_availability_of_refined_sugar_g_day_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "per_capita_availability_of_refined_sugar_g_day" FLOAT  -- Per Capita Availability Of Refined Sugar, G Day
);

CREATE TABLE owid_per_capita_availability_of_refined_sugar_g_day_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "per_capita_availability_of_refined_sugar_g_day" FLOAT  -- Per Capita Availability Of Refined Sugar, G Day,
  "per_capita_availability_of_refined_sugar_g_day_low" VARCHAR  -- Per Capita Availability Of Refined Sugar, G Day Low,
  "per_capita_availability_of_refined_sugar_g_day_high" VARCHAR  -- Per Capita Availability Of Refined Sugar, G Day High,
  "comments" VARCHAR
);

CREATE TABLE owid_per_capita_current_health_expenditure_in_ppp_oral_health_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "per_capita_current_health_expenditure_in_ppp_oral_health" FLOAT  -- Per Capita Current Health Expenditure In Ppp, Oral Health
);

CREATE TABLE owid_per_capita_current_health_expenditure_in_ppp_oral_health_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "per_capita_current_health_expenditure_in_ppp_oral_health" FLOAT  -- Per Capita Current Health Expenditure In Ppp, Oral Health,
  "per_capita_current_health_expenditure_in_ppp_oral_health_low" VARCHAR  -- Per Capita Current Health Expenditure In Ppp, Oral Health Low,
  "per_capita_current_health_expenditure_in_ppp_oral_health_high" VARCHAR  -- Per Capita Current Health Expenditure In Ppp, Oral Health High,
  "comments" VARCHAR
);

CREATE TABLE owid_per_capita_expenditure_on_dental_healthcare_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "per_capita_expenditure_on_dental_healthcare_usd" FLOAT  -- Per Capita Expenditure On Dental Healthcare, Usd
);

CREATE TABLE owid_per_capita_expenditure_on_dental_healthcare_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "per_capita_expenditure_on_dental_healthcare_usd" FLOAT  -- Per Capita Expenditure On Dental Healthcare, Usd,
  "per_capita_expenditure_on_dental_healthcare_usd_low" VARCHAR  -- Per Capita Expenditure On Dental Healthcare, Usd Low,
  "per_capita_expenditure_on_dental_healthcare_usd_high" VARCHAR  -- Per Capita Expenditure On Dental Healthcare, Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_alcohol_related_harm_and_consequences_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_harm_and_consequences" VARCHAR,
  "perceived_trend_in_alcohol_related_harm_and_consequences" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_alcohol_related_harm_and_consequences_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_harm_and_consequences" VARCHAR,
  "perceived_trend_in_alcohol_related_harm_and_consequences" VARCHAR,
  "perceived_trend_in_alcohol_related_harm_and_consequences_low" VARCHAR,
  "perceived_trend_in_alcohol_related_harm_and_consequences_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_exports_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_exports" VARCHAR
);