Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_in_prison_tb_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_tb_diagnosis_number_of_diagnoses" INTEGER -- In Prison Tb Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_tb_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_tb_diagnosis_number_of_diagnoses" INTEGER -- In Prison Tb Diagnosis, Number Of Diagnoses,
"in_prison_tb_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Tb Diagnosis, Number Of Diagnoses Low,
"in_prison_tb_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Tb Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_total_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_total_deaths" INTEGER
);
CREATE TABLE owid_in_prison_total_deaths_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_total_deaths" INTEGER,
"in_prison_total_deaths_low" VARCHAR,
"in_prison_total_deaths_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_dtp_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_dtp" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_dtp_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_dtp" VARCHAR,
"in_prison_vaccination_for_dtp_low" VARCHAR,
"in_prison_vaccination_for_dtp_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_hepatitis_a_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_hepatitis_a" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_hepatitis_a_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_hepatitis_a" VARCHAR,
"in_prison_vaccination_for_hepatitis_a_low" VARCHAR,
"in_prison_vaccination_for_hepatitis_a_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_hepatitis_b_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_hepatitis_b" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_hepatitis_b_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_hepatitis_b" VARCHAR,
"in_prison_vaccination_for_hepatitis_b_low" VARCHAR,
"in_prison_vaccination_for_hepatitis_b_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_hpv_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_hpv" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_hpv_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_hpv" VARCHAR,
"in_prison_vaccination_for_hpv_low" VARCHAR,
"in_prison_vaccination_for_hpv_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_mmr_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_mmr" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_mmr_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_mmr" VARCHAR,
"in_prison_vaccination_for_mmr_low" VARCHAR,
"in_prison_vaccination_for_mmr_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_seasonal_flu_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_seasonal_flu" VARCHAR
);
CREATE TABLE owid_in_prison_vaccination_for_seasonal_flu_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_vaccination_for_seasonal_flu" VARCHAR,
"in_prison_vaccination_for_seasonal_flu_low" VARCHAR,
"in_prison_vaccination_for_seasonal_flu_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_insitutional_educational_policy_does_not_include__8be8fe9f (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"insitutional_educational_policy_does_not_include_elear_76ffeca7" VARCHAR -- Insitutional Educational Policy Does Not Include Elearning As An Approach To Teaching Health Sciences,
"insitutional_educational_policy_does_not_include_elear_ae647d76" VARCHAR -- Insitutional Educational Policy Does Not Include Elearning As An Approach To Teaching Health Sciences Low,
"insitutional_educational_policy_does_not_include_elear_89c09e8c" VARCHAR -- Insitutional Educational Policy Does Not Include Elearning As An Approach To Teaching Health Sciences High,
"comments" VARCHAR
);
CREATE TABLE owid_insitutional_educational_policy_does_not_include__bbca459d (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"insitutional_educational_policy_does_not_include_elear_76ffeca7" VARCHAR -- Insitutional Educational Policy Does Not Include Elearning As An Approach To Teaching Health Sciences
);
CREATE TABLE owid_institutional_births_birth_taken_place_in_a_facility_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"institutional_births_birth_taken_place_in_a_facility_pct" FLOAT -- Institutional Births, Birth Taken Place In A Facility, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_institutional_births_birth_taken_place_in_a_facility_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"institutional_births_birth_taken_place_in_a_facility_pct" FLOAT -- Institutional Births, Birth Taken Place In A Facility, Pct,
"institutional_births_birth_taken_place_in_a_facility_pct_low" VARCHAR -- Institutional Births, Birth Taken Place In A Facility, Pct Low,
"institutional_births_birth_taken_place_in_a_facility_pct_high" VARCHAR -- Institutional Births, Birth Taken Place In A Facility, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_institutions_offer_in_service_training_to_health__a4303fbf (
"year" INTEGER,
"country" VARCHAR,
"institutions_offer_in_service_training_to_health_profe_e0a033be" VARCHAR -- Institutions Offer In Service Training To Health Professionals On Ict For Health,
"institutions_offer_in_service_training_to_health_profe_1886f99b" VARCHAR -- Institutions Offer In Service Training To Health Professionals On Ict For Health Low,
"institutions_offer_in_service_training_to_health_profe_ce9f27b4" VARCHAR -- Institutions Offer In Service Training To Health Professionals On Ict For Health High,
"comments" VARCHAR
);
CREATE TABLE owid_institutions_offer_in_service_training_to_health__e15fee41 (
"year" INTEGER,
"country" VARCHAR,
"institutions_offer_in_service_training_to_health_profe_e0a033be" VARCHAR -- Institutions Offer In Service Training To Health Professionals On Ict For Health
);
CREATE TABLE owid_insufficient_incentives_for_data_sharing_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"insufficient_incentives_for_data_sharing" VARCHAR
);
CREATE TABLE owid_insufficient_incentives_for_data_sharing_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"insufficient_incentives_for_data_sharing" VARCHAR,
"insufficient_incentives_for_data_sharing_low" VARCHAR,
"insufficient_incentives_for_data_sharing_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_international_code_on_marketing_of_breast_milk_su_e8cec4bd (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"comments" VARCHAR,
"international_code_on_marketing_of_breast_milk_substit_a5e15615" VARCHAR -- International Code On Marketing Of Breast Milk Substitutes, Legal Status Of The Code
);
Anyone who has the link will be able to view this.