Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_in_prison_covid_19_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_covid_19_diagnosis_number_of_diagnoses" INTEGER -- In Prison Covid 19 Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_covid_19_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_covid_19_diagnosis_number_of_diagnoses" INTEGER -- In Prison Covid 19 Diagnosis, Number Of Diagnoses,
"in_prison_covid_19_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Covid 19 Diagnosis, Number Of Diagnoses Low,
"in_prison_covid_19_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Covid 19 Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_covid_19_mortality_rate_per_100_000_inc_51127c8a (
"year" INTEGER,
"country" VARCHAR,
"in_prison_covid_19_mortality_rate_per_100_000_incarcer_f0277c7d" FLOAT -- In Prison Covid 19 Mortality Rate, Per 100–000 Incarcerated Persons Per Year
);
CREATE TABLE owid_in_prison_covid_19_mortality_rate_per_100_000_inc_ad46a650 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_covid_19_mortality_rate_per_100_000_incarcer_f0277c7d" FLOAT -- In Prison Covid 19 Mortality Rate, Per 100–000 Incarcerated Persons Per Year,
"in_prison_covid_19_mortality_rate_per_100_000_incarcer_20138c45" VARCHAR -- In Prison Covid 19 Mortality Rate, Per 100–000 Incarcerated Persons Per Year Low,
"in_prison_covid_19_mortality_rate_per_100_000_incarcer_fe01af49" VARCHAR -- In Prison Covid 19 Mortality Rate, Per 100–000 Incarcerated Persons Per Year High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_diabetes_mellitus_diagnosis_number_of_d_142a45ca (
"year" INTEGER,
"country" VARCHAR,
"in_prison_diabetes_mellitus_diagnosis_number_of_diagnoses" INTEGER -- In Prison Diabetes Mellitus Diagnosis, Number Of Diagnoses,
"in_prison_diabetes_mellitus_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Diabetes Mellitus Diagnosis, Number Of Diagnoses Low,
"in_prison_diabetes_mellitus_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Diabetes Mellitus Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_diabetes_mellitus_diagnosis_number_of_d_c4bc218d (
"year" INTEGER,
"country" VARCHAR,
"in_prison_diabetes_mellitus_diagnosis_number_of_diagnoses" INTEGER -- In Prison Diabetes Mellitus Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_drug_overdose_mortality_rate_per_100_00_42eb1917 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_drug_overdose_mortality_rate_per_100_000_inc_913de8ff" FLOAT -- In Prison Drug Overdose Mortality Rate, Per 100–000 Incarcerated Persons Per Year,
"in_prison_drug_overdose_mortality_rate_per_100_000_inc_f78d1d32" VARCHAR -- In Prison Drug Overdose Mortality Rate, Per 100–000 Incarcerated Persons Per Year Low,
"in_prison_drug_overdose_mortality_rate_per_100_000_inc_09a8543d" VARCHAR -- In Prison Drug Overdose Mortality Rate, Per 100–000 Incarcerated Persons Per Year High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_drug_overdose_mortality_rate_per_100_00_e3d532b8 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_drug_overdose_mortality_rate_per_100_000_inc_913de8ff" FLOAT -- In Prison Drug Overdose Mortality Rate, Per 100–000 Incarcerated Persons Per Year
);
CREATE TABLE owid_in_prison_hepatitis_b_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_hepatitis_b_diagnosis_number_of_diagnoses" INTEGER -- In Prison Hepatitis B Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_hepatitis_b_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_hepatitis_b_diagnosis_number_of_diagnoses" INTEGER -- In Prison Hepatitis B Diagnosis, Number Of Diagnoses,
"in_prison_hepatitis_b_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Hepatitis B Diagnosis, Number Of Diagnoses Low,
"in_prison_hepatitis_b_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Hepatitis B Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_hepatitis_c_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_hepatitis_c_diagnosis_number_of_diagnoses" INTEGER -- In Prison Hepatitis C Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_hepatitis_c_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_hepatitis_c_diagnosis_number_of_diagnoses" INTEGER -- In Prison Hepatitis C Diagnosis, Number Of Diagnoses,
"in_prison_hepatitis_c_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Hepatitis C Diagnosis, Number Of Diagnoses Low,
"in_prison_hepatitis_c_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Hepatitis C Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_hiv_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_hiv_diagnosis_number_of_diagnoses" INTEGER -- In Prison Hiv Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_hiv_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_hiv_diagnosis_number_of_diagnoses" INTEGER -- In Prison Hiv Diagnosis, Number Of Diagnoses,
"in_prison_hiv_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Hiv Diagnosis, Number Of Diagnoses Low,
"in_prison_hiv_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Hiv Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_laboratory_tests_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_laboratory_tests" VARCHAR
);
CREATE TABLE owid_in_prison_laboratory_tests_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_laboratory_tests" VARCHAR,
"in_prison_laboratory_tests_low" VARCHAR,
"in_prison_laboratory_tests_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_mdr_tb_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_mdr_tb_diagnosis_number_of_diagnoses" INTEGER -- In Prison Mdr Tb Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_mdr_tb_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_mdr_tb_diagnosis_number_of_diagnoses" INTEGER -- In Prison Mdr Tb Diagnosis, Number Of Diagnoses,
"in_prison_mdr_tb_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Mdr Tb Diagnosis, Number Of Diagnoses Low,
"in_prison_mdr_tb_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Mdr Tb Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_mental_disorder_diagnosis_number_of_diagnoses_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_mental_disorder_diagnosis_number_of_diagnoses" INTEGER -- In Prison Mental Disorder Diagnosis, Number Of Diagnoses
);
CREATE TABLE owid_in_prison_mental_disorder_diagnosis_number_of_diagnoses_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_mental_disorder_diagnosis_number_of_diagnoses" INTEGER -- In Prison Mental Disorder Diagnosis, Number Of Diagnoses,
"in_prison_mental_disorder_diagnosis_number_of_diagnoses_low" VARCHAR -- In Prison Mental Disorder Diagnosis, Number Of Diagnoses Low,
"in_prison_mental_disorder_diagnosis_number_of_diagnoses_high" VARCHAR -- In Prison Mental Disorder Diagnosis, Number Of Diagnoses High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_needles_free_of_charge_1 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_needles_free_of_charge" VARCHAR
);
CREATE TABLE owid_in_prison_needles_free_of_charge_2 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_needles_free_of_charge" VARCHAR,
"in_prison_needles_free_of_charge_low" VARCHAR,
"in_prison_needles_free_of_charge_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_patient_involvement_in_healthcare_plann_56310c3c (
"year" INTEGER,
"country" VARCHAR,
"in_prison_patient_involvement_in_healthcare_planning_and_reform" VARCHAR,
"in_prison_patient_involvement_in_healthcare_planning_a_c7e48ab5" VARCHAR -- In Prison Patient Involvement In Healthcare Planning And Reform Low,
"in_prison_patient_involvement_in_healthcare_planning_a_e7912cef" VARCHAR -- In Prison Patient Involvement In Healthcare Planning And Reform High,
"comments" VARCHAR
);
CREATE TABLE owid_in_prison_patient_involvement_in_healthcare_plann_8413e173 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_patient_involvement_in_healthcare_planning_and_reform" VARCHAR
);
CREATE TABLE owid_in_prison_people_who_currently_use_tobacco_number_045fb173 (
"year" INTEGER,
"country" VARCHAR,
"in_prison_people_who_currently_use_tobacco_number_of_prisoners" INTEGER -- In Prison People Who Currently Use Tobacco, Number Of Prisoners
);
Anyone who has the link will be able to view this.