Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_current_health_expenditure_che_as_percentage_of_g_446ab942 (
"year" INTEGER,
"country" VARCHAR,
"current_health_expenditure_che_as_percentage_of_gross__e3bd4106" FLOAT -- Current Health Expenditure, Che, As Percentage Of Gross Domestic Product, Gdp, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_current_health_expenditure_che_as_percentage_of_g_8bef1fbc (
"year" INTEGER,
"country" VARCHAR,
"current_health_expenditure_che_as_percentage_of_gross__e3bd4106" FLOAT -- Current Health Expenditure, Che, As Percentage Of Gross Domestic Product, Gdp, Pct,
"current_health_expenditure_che_as_percentage_of_gross__970a5908" VARCHAR -- Current Health Expenditure, Che, As Percentage Of Gross Domestic Product, Gdp, Pct Low,
"current_health_expenditure_che_as_percentage_of_gross__f839d3c8" VARCHAR -- Current Health Expenditure, Che, As Percentage Of Gross Domestic Product, Gdp, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_current_health_expenditure_che_per_capita_in_usd_1 (
"year" INTEGER,
"country" VARCHAR,
"current_health_expenditure_che_per_capita_in_usd" FLOAT -- Current Health Expenditure, Che, Per Capita In Usd,
"comments" VARCHAR
);
CREATE TABLE owid_current_health_expenditure_che_per_capita_in_usd_2 (
"year" INTEGER,
"country" VARCHAR,
"current_health_expenditure_che_per_capita_in_usd" FLOAT -- Current Health Expenditure, Che, Per Capita In Usd,
"current_health_expenditure_che_per_capita_in_usd_low" VARCHAR -- Current Health Expenditure, Che, Per Capita In Usd Low,
"current_health_expenditure_che_per_capita_in_usd_high" VARCHAR -- Current Health Expenditure, Che, Per Capita In Usd High,
"comments" VARCHAR
);
CREATE TABLE owid_cytisine_cost_covered_1 (
"year" INTEGER,
"country" VARCHAR,
"cytisine_cost_covered" VARCHAR -- Cytisine, Cost Covered
);
CREATE TABLE owid_cytisine_cost_covered_2 (
"year" INTEGER,
"country" VARCHAR,
"cytisine_cost_covered" VARCHAR -- Cytisine, Cost Covered,
"cytisine_cost_covered_low" VARCHAR -- Cytisine, Cost Covered Low,
"cytisine_cost_covered_high" VARCHAR -- Cytisine, Cost Covered High,
"comments" VARCHAR
);
CREATE TABLE owid_cytisine_legally_sold_1 (
"year" INTEGER,
"country" VARCHAR,
"cytisine_legally_sold" VARCHAR -- Cytisine, Legally Sold
);
CREATE TABLE owid_cytisine_legally_sold_2 (
"year" INTEGER,
"country" VARCHAR,
"cytisine_legally_sold" VARCHAR -- Cytisine, Legally Sold,
"cytisine_legally_sold_low" VARCHAR -- Cytisine, Legally Sold Low,
"cytisine_legally_sold_high" VARCHAR -- Cytisine, Legally Sold High,
"comments" VARCHAR
);
CREATE TABLE owid_cytisine_place_available_1 (
"year" INTEGER,
"country" VARCHAR,
"cytisine_place_available" VARCHAR -- Cytisine, Place Available
);
CREATE TABLE owid_cytisine_place_available_2 (
"year" INTEGER,
"country" VARCHAR,
"cytisine_place_available" VARCHAR -- Cytisine, Place Available,
"cytisine_place_available_low" VARCHAR -- Cytisine, Place Available Low,
"cytisine_place_available_high" VARCHAR -- Cytisine, Place Available High,
"comments" VARCHAR
);
CREATE TABLE owid_dalys_attributable_to_ambient_air_pollution_age_s_226c6f48 (
"year" INTEGER,
"country" VARCHAR,
"dalys_attributable_to_ambient_air_pollution_age_standardized" FLOAT -- Dalys Attributable To Ambient Air Pollution, Age Standardized
);
CREATE TABLE owid_dalys_attributable_to_ambient_air_pollution_age_s_2812f8d3 (
"year" INTEGER,
"country" VARCHAR,
"dalys_attributable_to_ambient_air_pollution_age_standardized" FLOAT -- Dalys Attributable To Ambient Air Pollution, Age Standardized,
"dalys_attributable_to_ambient_air_pollution_age_standa_f4ea6926" VARCHAR -- Dalys Attributable To Ambient Air Pollution, Age Standardized Low,
"dalys_attributable_to_ambient_air_pollution_age_standa_2a708c80" VARCHAR -- Dalys Attributable To Ambient Air Pollution, Age Standardized High,
"comments" VARCHAR
);
CREATE TABLE owid_dalys_attributable_to_the_environment_in_children_27fbcaa1 (
"year" INTEGER,
"country" VARCHAR,
"dalys_attributable_to_the_environment_in_children_unde_0a61a8c8" FLOAT -- Dalys Attributable To The Environment In Children Under 5 Years, Pct
);
CREATE TABLE owid_dalys_attributable_to_the_environment_in_children_81750497 (
"year" INTEGER,
"country" VARCHAR,
"dalys_attributable_to_the_environment_in_children_unde_0a61a8c8" FLOAT -- Dalys Attributable To The Environment In Children Under 5 Years, Pct,
"dalys_attributable_to_the_environment_in_children_unde_4dce6e0b" VARCHAR -- Dalys Attributable To The Environment In Children Under 5 Years, Pct Low,
"dalys_attributable_to_the_environment_in_children_unde_c1506485" VARCHAR -- Dalys Attributable To The Environment In Children Under 5 Years, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_data_collected_on_harm_from_alcohol_at_workplace_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"data_collected_on_harm_from_alcohol_at_workplace" VARCHAR
);
CREATE TABLE owid_data_collected_on_harm_from_alcohol_at_workplace_2 (
"year" INTEGER,
"country" VARCHAR,
"data_collected_on_harm_from_alcohol_at_workplace" VARCHAR,
"data_collected_on_harm_from_alcohol_at_workplace_low" VARCHAR,
"data_collected_on_harm_from_alcohol_at_workplace_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_data_collection_on_alcohol_related_health_indicators_1 (
"year" INTEGER,
"country" VARCHAR,
"data_collection_on_alcohol_related_health_indicators" VARCHAR
);
CREATE TABLE owid_data_collection_on_alcohol_related_health_indicators_2 (
"year" INTEGER,
"country" VARCHAR,
"data_collection_on_alcohol_related_health_indicators" VARCHAR,
"data_collection_on_alcohol_related_health_indicators_low" VARCHAR,
"data_collection_on_alcohol_related_health_indicators_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_data_collection_on_foetal_alcohol_syndome_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"data_collection_on_foetal_alcohol_syndome" VARCHAR
);
CREATE TABLE owid_data_collection_on_foetal_alcohol_syndome_2 (
"year" INTEGER,
"country" VARCHAR,
"data_collection_on_foetal_alcohol_syndome" VARCHAR,
"data_collection_on_foetal_alcohol_syndome_low" VARCHAR,
"data_collection_on_foetal_alcohol_syndome_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_data_in_national_radon_database_1 (
"year" INTEGER,
"country" VARCHAR,
"radon_subquestions" VARCHAR,
"comments" VARCHAR,
"data_in_national_radon_database" VARCHAR
);
CREATE TABLE owid_data_in_national_radon_database_2 (
"year" INTEGER,
"country" VARCHAR,
"radon_subquestions" VARCHAR,
"data_in_national_radon_database" VARCHAR,
"data_in_national_radon_database_low" VARCHAR,
"data_in_national_radon_database_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_data_on_substance_use_disorders_disseminated_in_n_45fa18a7 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"data_on_substance_use_disorders_disseminated_in_nation_2cb83ba4" VARCHAR -- Data On Substance Use Disorders Disseminated In National Annual Reports
);
CREATE TABLE owid_data_on_substance_use_disorders_disseminated_in_n_7d709c4a (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_types" VARCHAR,
"data_on_substance_use_disorders_disseminated_in_nation_2cb83ba4" VARCHAR -- Data On Substance Use Disorders Disseminated In National Annual Reports,
"data_on_substance_use_disorders_disseminated_in_nation_94f75085" VARCHAR -- Data On Substance Use Disorders Disseminated In National Annual Reports Low,
"data_on_substance_use_disorders_disseminated_in_nation_6ac21a95" VARCHAR -- Data On Substance Use Disorders Disseminated In National Annual Reports High,
"comments" VARCHAR
);
CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_09ca3fd8 (
"year" INTEGER,
"country" VARCHAR,
"data_sources_used_to_routinely_monitor_people_with_dem_35fb5212" VARCHAR -- Data Sources Used To Routinely Monitor People With Dementia, Administrative Data
);
Anyone who has the link will be able to view this.