Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_reported_number_of_children_receiving_antiretrovi_97641396 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_children_receiving_antiretroviral_t_58446bf1" INTEGER -- Reported Number Of Children Receiving Antiretroviral Therapy, Month And Year Of Report
);
CREATE TABLE owid_reported_number_of_human_rabies_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_human_rabies_deaths" INTEGER
);
CREATE TABLE owid_reported_number_of_human_rabies_deaths_2 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_human_rabies_deaths" INTEGER,
"reported_number_of_human_rabies_deaths_low" VARCHAR,
"reported_number_of_human_rabies_deaths_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_reported_number_of_individuals_treated_for_onchoc_33796102 (
"country" VARCHAR,
"year" INTEGER,
"reported_number_of_individuals_treated_for_onchocerciasis" UINTEGER
);
CREATE TABLE owid_reported_number_of_individuals_treated_for_onchoc_b2d29134 (
"country" VARCHAR,
"year" INTEGER,
"reported_number_of_individuals_treated_for_onchocerciasis" UINTEGER,
"reported_number_of_individuals_treated_for_onchocerciasis_low" VARCHAR,
"reported_number_of_individuals_treated_for_onchocerciasis_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_reported_number_of_people_receiving_antiretrovira_a67e31e9 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_people_receiving_antiretroviral_therapy" UINTEGER,
"reported_number_of_people_receiving_antiretroviral_therapy_low" VARCHAR,
"reported_number_of_people_receiving_antiretroviral_therapy_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_reported_number_of_people_receiving_antiretrovira_fc5646f9 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_people_receiving_antiretroviral_therapy" UINTEGER
);
CREATE TABLE owid_reported_number_of_people_requiring_interventions_8c189915 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_people_requiring_interventions_against_ntds" UINTEGER,
"reported_number_of_people_requiring_interventions_agai_30202261" VARCHAR -- Reported Number Of People Requiring Interventions Against Ntds Low,
"reported_number_of_people_requiring_interventions_agai_3536fbb7" VARCHAR -- Reported Number Of People Requiring Interventions Against Ntds High,
"comments" VARCHAR
);
CREATE TABLE owid_reported_number_of_people_requiring_interventions_bb467cbd (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_people_requiring_interventions_against_ntds" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_reported_number_of_tests_performed_where_results__00baa4c4 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"reported_number_of_tests_performed_where_results_were__030f6056" VARCHAR -- Reported Number Of Tests Performed Where Results Were Received By A Person, Testing Volume, Reporting Period
);
CREATE TABLE owid_reported_number_of_tests_performed_where_results__47dc4bb2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"reported_number_of_tests_performed_where_results_were__eb608391" UINTEGER -- Reported Number Of Tests Performed Where Results Were Received By A Person, Testing Volume,
"reported_number_of_tests_performed_where_results_were__ed543dbf" VARCHAR -- Reported Number Of Tests Performed Where Results Were Received By A Person, Testing Volume Low,
"reported_number_of_tests_performed_where_results_were__5c4c95a6" VARCHAR -- Reported Number Of Tests Performed Where Results Were Received By A Person, Testing Volume High,
"comments" VARCHAR
);
CREATE TABLE owid_reported_number_of_tests_performed_where_results__7065f240 (
"year" INTEGER,
"country" VARCHAR,
"reported_number_of_tests_performed_where_results_were__eb608391" UINTEGER -- Reported Number Of Tests Performed Where Results Were Received By A Person, Testing Volume,
"comments" VARCHAR
);
CREATE TABLE owid_reported_treatment_coverage_for_substance_dependence_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_dependence" VARCHAR,
"reported_treatment_coverage_for_substance_dependence" VARCHAR
);
CREATE TABLE owid_reported_treatment_coverage_for_substance_dependence_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_dependence" VARCHAR,
"reported_treatment_coverage_for_substance_dependence" VARCHAR,
"reported_treatment_coverage_for_substance_dependence_low" VARCHAR,
"reported_treatment_coverage_for_substance_dependence_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_reported_use_of_earmarked_tobacco_taxes_1 (
"year" INTEGER,
"country" VARCHAR,
"reported_use_of_earmarked_tobacco_taxes" VARCHAR
);
CREATE TABLE owid_reported_use_of_earmarked_tobacco_taxes_2 (
"year" INTEGER,
"country" VARCHAR,
"reported_use_of_earmarked_tobacco_taxes" VARCHAR,
"reported_use_of_earmarked_tobacco_taxes_low" VARCHAR,
"reported_use_of_earmarked_tobacco_taxes_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_reporting_countries_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"reporting_countries" VARCHAR
);
CREATE TABLE owid_reporting_countries_2 (
"year" INTEGER,
"country" VARCHAR,
"reporting_countries" VARCHAR,
"reporting_countries_low" VARCHAR,
"reporting_countries_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_report_with_data_from_health_services_on_alcohol__377f14cc (
"year" INTEGER,
"country" VARCHAR,
"report_with_data_from_health_services_on_alcohol_use_and_auds" VARCHAR
);
CREATE TABLE owid_report_with_data_from_health_services_on_alcohol__96d01e8d (
"year" INTEGER,
"country" VARCHAR,
"report_with_data_from_health_services_on_alcohol_use_and_auds" VARCHAR,
"report_with_data_from_health_services_on_alcohol_use_a_e6bcda16" VARCHAR -- Report With Data From Health Services On Alcohol Use And Auds Low,
"report_with_data_from_health_services_on_alcohol_use_a_7d778739" VARCHAR -- Report With Data From Health Services On Alcohol Use And Auds High,
"comments" VARCHAR
);
CREATE TABLE owid_report_with_epidemiological_data_on_lcohol_use_and_auds_1 (
"year" INTEGER,
"country" VARCHAR,
"report_with_epidemiological_data_on_lcohol_use_and_auds" VARCHAR
);
CREATE TABLE owid_report_with_epidemiological_data_on_lcohol_use_and_auds_2 (
"year" INTEGER,
"country" VARCHAR,
"report_with_epidemiological_data_on_lcohol_use_and_auds" VARCHAR,
"report_with_epidemiological_data_on_lcohol_use_and_auds_low" VARCHAR,
"report_with_epidemiological_data_on_lcohol_use_and_auds_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_representation_of_latest_adult_prevalence_survey__29b7666b (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"representation_of_latest_adult_prevalence_survey_nonsmoked" VARCHAR -- Representation Of Latest Adult Prevalence Survey, Nonsmoked
);
CREATE TABLE owid_representation_of_latest_adult_prevalence_survey__a4612f8f (
"year" INTEGER,
"country" VARCHAR,
"representation_of_latest_adult_prevalence_survey_nonsmoked" VARCHAR -- Representation Of Latest Adult Prevalence Survey, Nonsmoked,
"representation_of_latest_adult_prevalence_survey_nonsmoked_low" VARCHAR -- Representation Of Latest Adult Prevalence Survey, Nonsmoked Low,
"representation_of_latest_adult_prevalence_survey_nonsmoked_high" VARCHAR -- Representation Of Latest Adult Prevalence Survey, Nonsmoked High,
"comments" VARCHAR
);
CREATE TABLE owid_representation_of_latest_youth_prevalence_survey__98880cc6 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"representation_of_latest_youth_prevalence_survey_nonsmoked" VARCHAR -- Representation Of Latest Youth Prevalence Survey, Nonsmoked
);
Anyone who has the link will be able to view this.