Global Health Observatory - World Health Organization

CREATE TABLE owid_total_number_of_notified_tb_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_notified_tb_cases" UINTEGER,
  "total_number_of_notified_tb_cases_low" VARCHAR,
  "total_number_of_notified_tb_cases_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_total_number_of_published_dementia_research_output_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_published_dementia_research_output" INTEGER
);

CREATE TABLE owid_total_number_of_published_dementia_research_output_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_published_dementia_research_output" INTEGER,
  "total_number_of_published_dementia_research_output_low" VARCHAR,
  "total_number_of_published_dementia_research_output_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_total_number_of_surveillance_sites_reporting_to_glass_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_surveillance_sites_reporting_to_glass" INTEGER
);

CREATE TABLE owid_total_number_of_surveillance_sites_reporting_to_glass_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_surveillance_sites_reporting_to_glass" INTEGER,
  "total_number_of_surveillance_sites_reporting_to_glass_low" VARCHAR,
  "total_number_of_surveillance_sites_reporting_to_glass_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_in_thousands_oral_health_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_in_thousands_oral_health" FLOAT  -- Total Population In Thousands, Oral Health
);

CREATE TABLE owid_total_population_in_thousands_oral_health_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_in_thousands_oral_health" FLOAT  -- Total Population In Thousands, Oral Health,
  "total_population_in_thousands_oral_health_low" VARCHAR  -- Total Population In Thousands, Oral Health Low,
  "total_population_in_thousands_oral_health_high" VARCHAR  -- Total Population In Thousands, Oral Health High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_a_relative_poverty__25ef53db (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_a_relative_poverty_line__27bc3e2f" FLOAT  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Millions, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_a_relative_poverty__578e69c5 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_a_relative_poverty_line__40d95396" FLOAT  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_a_relative_poverty__b62f71f9 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_a_relative_poverty_line__40d95396" FLOAT  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, Regional, Global,
  "total_population_pushed_below_a_relative_poverty_line__99d2fdd2" VARCHAR  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, Regional, Global Low,
  "total_population_pushed_below_a_relative_poverty_line__647b6a2f" VARCHAR  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_a_relative_poverty__d4d02eaa (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_a_relative_poverty_line__27bc3e2f" FLOAT  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Millions, Regional, Global,
  "total_population_pushed_below_a_relative_poverty_line__03d51b6d" VARCHAR  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Millions, Regional, Global Low,
  "total_population_pushed_below_a_relative_poverty_line__e877ef55" VARCHAR  -- Total Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Millions, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar1_90_a_da_01dce6d1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_bf35de50" FLOAT  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_the_dollar1_90_a_da_21c5e2cf (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_493020d1" FLOAT  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_9ff02bcd" VARCHAR  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global Low,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_78e4e7ff" VARCHAR  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar1_90_a_da_2722b1ec (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_493020d1" FLOAT  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_the_dollar1_90_a_da_3b9dee88 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_bf35de50" FLOAT  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_d24de917" VARCHAR  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global Low,
  "total_population_pushed_below_the_dollar1_90_a_day_pov_5b103cc3" VARCHAR  -- Total Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar2_15_a_da_39d54ed5 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_669f63e8" FLOAT  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_the_dollar2_15_a_da_39da041c (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_64b6e4ff" FLOAT  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_3c0faa97" VARCHAR  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global Low,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_06a94e20" VARCHAR  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar2_15_a_da_3ec19985 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_669f63e8" FLOAT  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_f8d24277" VARCHAR  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global Low,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_4223a7e7" VARCHAR  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar2_15_a_da_895b9622 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar2_15_a_day_pov_64b6e4ff" FLOAT  -- Total Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_the_dollar3_20_a_da_0f1d7dfa (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_498a15f0" FLOAT  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_d5d1e73e" VARCHAR  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global Low,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_06c430ec" VARCHAR  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar3_20_a_da_1853a3e5 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_498a15f0" FLOAT  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global
);

CREATE TABLE owid_total_population_pushed_below_the_dollar3_20_a_da_25166ab3 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_bd819125" FLOAT  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Millions,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_92cf40ff" VARCHAR  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Millions Low,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_5811786a" VARCHAR  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Millions High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar3_20_a_da_97185c86 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar3_20_a_day_pov_bd819125" FLOAT  -- Total Population Pushed Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Millions
);

CREATE TABLE owid_total_population_pushed_below_the_dollar3_65_a_da_36dca085 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar3_65_a_day_pov_783ab782" FLOAT  -- Total Population Pushed Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global,
  "total_population_pushed_below_the_dollar3_65_a_day_pov_0836b5ee" VARCHAR  -- Total Population Pushed Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global Low,
  "total_population_pushed_below_the_dollar3_65_a_day_pov_dcec545f" VARCHAR  -- Total Population Pushed Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Pct, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_pushed_below_the_dollar3_65_a_da_5ff8a17e (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_pushed_below_the_dollar3_65_a_day_pov_461dbf9f" FLOAT  -- Total Population Pushed Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Millions, Regional, Global
);