Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_majority_provider_of_respite_care_for_dementia_ca_82b58675 (
"year" INTEGER,
"country" VARCHAR,
"majority_provider_of_respite_care_for_dementia_carers_ngo" VARCHAR -- Majority Provider Of Respite Care For Dementia Carers, Ngo
);
CREATE TABLE owid_majority_provider_of_respite_care_for_dementia_ca_d370a244 (
"year" INTEGER,
"country" VARCHAR,
"majority_provider_of_respite_care_for_dementia_carers__ee8b4324" VARCHAR -- Majority Provider Of Respite Care For Dementia Carers, Public Sector
);
CREATE TABLE owid_majority_provider_of_social_and_financial_protect_6da58e3a (
"year" INTEGER,
"country" VARCHAR,
"majority_provider_of_social_and_financial_protection_f_fc6e6832" VARCHAR -- Majority Provider Of Social And Financial Protection For Dementia, Public, Private,
"majority_provider_of_social_and_financial_protection_f_e4c6beb2" VARCHAR -- Majority Provider Of Social And Financial Protection For Dementia, Public, Private Low,
"majority_provider_of_social_and_financial_protection_f_178eee22" VARCHAR -- Majority Provider Of Social And Financial Protection For Dementia, Public, Private High,
"comments" VARCHAR
);
CREATE TABLE owid_majority_provider_of_social_and_financial_protect_c29cc7ce (
"year" INTEGER,
"country" VARCHAR,
"majority_provider_of_social_and_financial_protection_f_fc6e6832" VARCHAR -- Majority Provider Of Social And Financial Protection For Dementia, Public, Private
);
CREATE TABLE owid_mandatory_mitigation_measures_if_legal_value_is_e_b5f8ed1b (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"mandatory_mitigation_measures_if_legal_value_is_exceed_b0e72269" VARCHAR -- Mandatory Mitigation Measures If Legal Value Is Exceeded, Existing Buildings
);
CREATE TABLE owid_mandatory_mitigation_measures_if_legal_value_is_e_e3c545bf (
"year" INTEGER,
"country" VARCHAR,
"mandatory_mitigation_measures_if_legal_value_is_exceed_b0e72269" VARCHAR -- Mandatory Mitigation Measures If Legal Value Is Exceeded, Existing Buildings,
"mandatory_mitigation_measures_if_legal_value_is_exceed_3071ffa0" VARCHAR -- Mandatory Mitigation Measures If Legal Value Is Exceeded, Existing Buildings Low,
"mandatory_mitigation_measures_if_legal_value_is_exceed_7cbf60b2" VARCHAR -- Mandatory Mitigation Measures If Legal Value Is Exceeded, Existing Buildings High,
"comments" VARCHAR
);
CREATE TABLE owid_mandatory_preventive_measures_new_buildings_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"mandatory_preventive_measures_new_buildings" VARCHAR -- Mandatory Preventive Measures, New Buildings
);
CREATE TABLE owid_mandatory_preventive_measures_new_buildings_2 (
"year" INTEGER,
"country" VARCHAR,
"mandatory_preventive_measures_new_buildings" VARCHAR -- Mandatory Preventive Measures, New Buildings,
"mandatory_preventive_measures_new_buildings_low" VARCHAR -- Mandatory Preventive Measures, New Buildings Low,
"mandatory_preventive_measures_new_buildings_high" VARCHAR -- Mandatory Preventive Measures, New Buildings High,
"comments" VARCHAR
);
CREATE TABLE owid_maternal_mortality_ratio_per_100_000_live_births_1 (
"year" INTEGER,
"country" VARCHAR,
"maternal_mortality_ratio_per_100_000_live_births" FLOAT -- Maternal Mortality Ratio, Per 100–000 Live Births
);
CREATE TABLE owid_maternal_mortality_ratio_per_100_000_live_births_2 (
"year" INTEGER,
"country" VARCHAR,
"maternal_mortality_ratio_per_100_000_live_births" FLOAT -- Maternal Mortality Ratio, Per 100–000 Live Births,
"maternal_mortality_ratio_per_100_000_live_births_low" FLOAT -- Maternal Mortality Ratio, Per 100–000 Live Births Low,
"maternal_mortality_ratio_per_100_000_live_births_high" FLOAT -- Maternal Mortality Ratio, Per 100–000 Live Births High,
"comments" VARCHAR
);
CREATE TABLE owid_maternal_mortality_ratio_per_100_000_live_births__a1bb3be6 (
"year" INTEGER,
"country" VARCHAR,
"maternal_mortality_ratio_per_100_000_live_births_count_b5eea320" FLOAT -- Maternal Mortality Ratio, Per 100–000 Live Births, Country Reported Estimates,
"maternal_mortality_ratio_per_100_000_live_births_count_bd1f7c43" VARCHAR -- Maternal Mortality Ratio, Per 100–000 Live Births, Country Reported Estimates Low,
"maternal_mortality_ratio_per_100_000_live_births_count_62f52ccf" VARCHAR -- Maternal Mortality Ratio, Per 100–000 Live Births, Country Reported Estimates High,
"comments" VARCHAR
);
CREATE TABLE owid_maternal_mortality_ratio_per_100_000_live_births__bb24c393 (
"year" INTEGER,
"country" VARCHAR,
"maternal_mortality_ratio_per_100_000_live_births_count_b5eea320" FLOAT -- Maternal Mortality Ratio, Per 100–000 Live Births, Country Reported Estimates,
"comments" VARCHAR
);
CREATE TABLE owid_maternity_protection_compliance_with_internationa_bc7f517e (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"comments" VARCHAR,
"maternity_protection_compliance_with_international_lab_87a32f0a" VARCHAR -- Maternity Protection, Compliance With International Labour Standards
);
CREATE TABLE owid_maximum_speed_limits_1 (
"year" INTEGER,
"country" VARCHAR,
"residence_area_type" VARCHAR,
"comments" VARCHAR,
"maximum_speed_limits" VARCHAR
);
CREATE TABLE owid_maximum_speed_limits_2 (
"year" INTEGER,
"country" VARCHAR,
"residence_area_type" VARCHAR,
"maximum_speed_limits" VARCHAR,
"maximum_speed_limits_low" VARCHAR,
"maximum_speed_limits_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_mean_bmi_kg_m2_age_standardized_estimate (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mean_bmi_kg_m2_age_standardized_estimate" FLOAT -- Mean Bmi, Kg M2, Age Standardized Estimate,
"mean_bmi_kg_m2_age_standardized_estimate_low" FLOAT -- Mean Bmi, Kg M2, Age Standardized Estimate Low,
"mean_bmi_kg_m2_age_standardized_estimate_high" FLOAT -- Mean Bmi, Kg M2, Age Standardized Estimate High,
"comments" VARCHAR
);
CREATE TABLE owid_mean_bmi_kg_m2_crude_estimate_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mean_bmi_kg_m2_crude_estimate" FLOAT -- Mean Bmi, Kg M2, Crude Estimate,
"comments" VARCHAR
);
CREATE TABLE owid_mean_bmi_kg_m2_crude_estimate_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mean_bmi_kg_m2_crude_estimate" FLOAT -- Mean Bmi, Kg M2, Crude Estimate,
"mean_bmi_kg_m2_crude_estimate_low" FLOAT -- Mean Bmi, Kg M2, Crude Estimate Low,
"mean_bmi_kg_m2_crude_estimate_high" FLOAT -- Mean Bmi, Kg M2, Crude Estimate High,
"comments" VARCHAR
);
CREATE TABLE owid_mean_fasting_blood_glucose_mmol_l_age_standardize_3027c0fe (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"mean_fasting_blood_glucose_mmol_l_age_standardized_estimate" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Age Standardized Estimate
);
CREATE TABLE owid_mean_fasting_blood_glucose_mmol_l_age_standardize_644d5c6b (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"mean_fasting_blood_glucose_mmol_l_age_standardized_estimate" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Age Standardized Estimate,
"mean_fasting_blood_glucose_mmol_l_age_standardized_estimate_low" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Age Standardized Estimate Low,
"mean_fasting_blood_glucose_mmol_l_age_standardized_est_e8ae25d7" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Age Standardized Estimate High,
"comments" VARCHAR
);
CREATE TABLE owid_mean_fasting_blood_glucose_mmol_l_crude_estimate_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mean_fasting_blood_glucose_mmol_l_crude_estimate" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Crude Estimate,
"comments" VARCHAR
);
CREATE TABLE owid_mean_fasting_blood_glucose_mmol_l_crude_estimate_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mean_fasting_blood_glucose_mmol_l_crude_estimate" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Crude Estimate,
"mean_fasting_blood_glucose_mmol_l_crude_estimate_low" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Crude Estimate Low,
"mean_fasting_blood_glucose_mmol_l_crude_estimate_high" FLOAT -- Mean Fasting Blood Glucose, Mmol L, Crude Estimate High,
"comments" VARCHAR
);
CREATE TABLE owid_mean_hdl_cholesterol_age_standardized_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"mean_hdl_cholesterol_age_standardized" FLOAT -- Mean Hdl Cholesterol, Age Standardized
);
CREATE TABLE owid_mean_hdl_cholesterol_age_standardized_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"mean_hdl_cholesterol_age_standardized" FLOAT -- Mean Hdl Cholesterol, Age Standardized,
"mean_hdl_cholesterol_age_standardized_low" FLOAT -- Mean Hdl Cholesterol, Age Standardized Low,
"mean_hdl_cholesterol_age_standardized_high" FLOAT -- Mean Hdl Cholesterol, Age Standardized High,
"comments" VARCHAR
);
CREATE TABLE owid_mean_hdl_cholesterol_crude_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"mean_hdl_cholesterol_crude" FLOAT -- Mean Hdl Cholesterol, Crude
);
Anyone who has the link will be able to view this.