Global Health Observatory - World Health Organization

CREATE TABLE owid_in_prison_people_who_currently_use_tobacco_number_db516a20 (
  "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,
  "in_prison_people_who_currently_use_tobacco_number_of_p_88bc3310" VARCHAR  -- In Prison People Who Currently Use Tobacco, Number Of Prisoners Low,
  "in_prison_people_who_currently_use_tobacco_number_of_p_761e35f5" VARCHAR  -- In Prison People Who Currently Use Tobacco, Number Of Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_drink_drank_alcohol_number_o_f20513c7 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_drink_drank_alcohol_number_of_pri_85388f96" INTEGER  -- In Prison People Who Drink Drank Alcohol, Number Of Prisoners, In The Last 12 Months
);

CREATE TABLE owid_in_prison_people_who_drink_drank_alcohol_number_o_fdd3443d (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_drink_drank_alcohol_number_of_pri_85388f96" INTEGER  -- In Prison People Who Drink Drank Alcohol, Number Of Prisoners, In The Last 12 Months,
  "in_prison_people_who_drink_drank_alcohol_number_of_pri_5e3665eb" VARCHAR  -- In Prison People Who Drink Drank Alcohol, Number Of Prisoners, In The Last 12 Months Low,
  "in_prison_people_who_drink_drank_alcohol_number_of_pri_bcbf9e70" VARCHAR  -- In Prison People Who Drink Drank Alcohol, Number Of Prisoners, In The Last 12 Months High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_have_bmi_gt_25_number_of_pri_6f3cbac9 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_have_bmi_gt_25_number_of_prisoner_875ea3b9" INTEGER  -- In Prison People Who Have Bmi, Gt, 25, Number Of Prisoners Who Are Overweight,
  "in_prison_people_who_have_bmi_gt_25_number_of_prisoner_30be3419" VARCHAR  -- In Prison People Who Have Bmi, Gt, 25, Number Of Prisoners Who Are Overweight Low,
  "in_prison_people_who_have_bmi_gt_25_number_of_prisoner_84f55a48" VARCHAR  -- In Prison People Who Have Bmi, Gt, 25, Number Of Prisoners Who Are Overweight High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_have_bmi_gt_25_number_of_pri_992c137d (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_have_bmi_gt_25_number_of_prisoner_875ea3b9" INTEGER  -- In Prison People Who Have Bmi, Gt, 25, Number Of Prisoners Who Are Overweight
);

CREATE TABLE owid_in_prison_people_who_have_bmi_gt_30_number_of_pri_08b429e5 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_have_bmi_gt_30_number_of_prisoner_dd87c612" INTEGER  -- In Prison People Who Have Bmi, Gt, 30, Number Of Prisoners Who Are Obese
);

CREATE TABLE owid_in_prison_people_who_have_bmi_gt_30_number_of_pri_e46d61dd (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_have_bmi_gt_30_number_of_prisoner_dd87c612" INTEGER  -- In Prison People Who Have Bmi, Gt, 30, Number Of Prisoners Who Are Obese,
  "in_prison_people_who_have_bmi_gt_30_number_of_prisoner_8e466d35" VARCHAR  -- In Prison People Who Have Bmi, Gt, 30, Number Of Prisoners Who Are Obese Low,
  "in_prison_people_who_have_bmi_gt_30_number_of_prisoner_36bc16a4" VARCHAR  -- In Prison People Who Have Bmi, Gt, 30, Number Of Prisoners Who Are Obese High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_inject_have_injected_drugs_n_2d4bc687 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_inject_have_injected_drugs_number_ae60d838" INTEGER  -- In Prison People Who Inject Have Injected Drugs, Number Of Prisoners, Over The Last 12 Months
);

CREATE TABLE owid_in_prison_people_who_inject_have_injected_drugs_n_f65394ce (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_inject_have_injected_drugs_number_ae60d838" INTEGER  -- In Prison People Who Inject Have Injected Drugs, Number Of Prisoners, Over The Last 12 Months,
  "in_prison_people_who_inject_have_injected_drugs_number_7ff7d23e" VARCHAR  -- In Prison People Who Inject Have Injected Drugs, Number Of Prisoners, Over The Last 12 Months Low,
  "in_prison_people_who_inject_have_injected_drugs_number_e5078189" VARCHAR  -- In Prison People Who Inject Have Injected Drugs, Number Of Prisoners, Over The Last 12 Months High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_regularly_exercise_for_a_min_086eee2d (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_regularly_exercise_for_a_minimum__b6496de6" INTEGER  -- In Prison People Who Regularly Exercise For A Minimum Of 150 Minutes Week, Number Of Prisoners
);

CREATE TABLE owid_in_prison_people_who_regularly_exercise_for_a_min_f78c9864 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_regularly_exercise_for_a_minimum__b6496de6" INTEGER  -- In Prison People Who Regularly Exercise For A Minimum Of 150 Minutes Week, Number Of Prisoners,
  "in_prison_people_who_regularly_exercise_for_a_minimum__eb970ae9" VARCHAR  -- In Prison People Who Regularly Exercise For A Minimum Of 150 Minutes Week, Number Of Prisoners Low,
  "in_prison_people_who_regularly_exercise_for_a_minimum__4e493d66" VARCHAR  -- In Prison People Who Regularly Exercise For A Minimum Of 150 Minutes Week, Number Of Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_use_have_used_drugs_number_o_60925e91 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_use_have_used_drugs_number_of_pri_6c5ad4f4" INTEGER  -- In Prison People Who Use Have Used Drugs, Number Of Prisoners, In The Last 12 Months,
  "in_prison_people_who_use_have_used_drugs_number_of_pri_c3401797" VARCHAR  -- In Prison People Who Use Have Used Drugs, Number Of Prisoners, In The Last 12 Months Low,
  "in_prison_people_who_use_have_used_drugs_number_of_pri_e53a05d0" VARCHAR  -- In Prison People Who Use Have Used Drugs, Number Of Prisoners, In The Last 12 Months High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_people_who_use_have_used_drugs_number_o_65e4b184 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_people_who_use_have_used_drugs_number_of_pri_6c5ad4f4" INTEGER  -- In Prison People Who Use Have Used Drugs, Number Of Prisoners, In The Last 12 Months
);

CREATE TABLE owid_in_prison_regular_assessments_of_essential_medicines_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_regular_assessments_of_essential_medicines" VARCHAR
);

CREATE TABLE owid_in_prison_regular_assessments_of_essential_medicines_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_regular_assessments_of_essential_medicines" VARCHAR,
  "in_prison_regular_assessments_of_essential_medicines_low" VARCHAR,
  "in_prison_regular_assessments_of_essential_medicines_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_standardized_process_for_adverse_drug_events_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_standardized_process_for_adverse_drug_events" VARCHAR
);

CREATE TABLE owid_in_prison_standardized_process_for_adverse_drug_events_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_standardized_process_for_adverse_drug_events" VARCHAR,
  "in_prison_standardized_process_for_adverse_drug_events_low" VARCHAR,
  "in_prison_standardized_process_for_adverse_drug_events_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_standardized_process_for_medication_errors_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_standardized_process_for_medication_errors" VARCHAR
);

CREATE TABLE owid_in_prison_standardized_process_for_medication_errors_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_standardized_process_for_medication_errors" VARCHAR,
  "in_prison_standardized_process_for_medication_errors_low" VARCHAR,
  "in_prison_standardized_process_for_medication_errors_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_standardized_protocol_for_suicide_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_standardized_protocol_for_suicide" VARCHAR
);

CREATE TABLE owid_in_prison_standardized_protocol_for_suicide_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_standardized_protocol_for_suicide" VARCHAR,
  "in_prison_standardized_protocol_for_suicide_low" VARCHAR,
  "in_prison_standardized_protocol_for_suicide_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_stis_diagnosis_number_of_diagnoses_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_stis_diagnosis_number_of_diagnoses" INTEGER  -- In Prison Stis Diagnosis, Number Of Diagnoses
);

CREATE TABLE owid_in_prison_stis_diagnosis_number_of_diagnoses_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_stis_diagnosis_number_of_diagnoses" INTEGER  -- In Prison Stis Diagnosis, Number Of Diagnoses,
  "in_prison_stis_diagnosis_number_of_diagnoses_low" VARCHAR  -- In Prison Stis Diagnosis, Number Of Diagnoses Low,
  "in_prison_stis_diagnosis_number_of_diagnoses_high" VARCHAR  -- In Prison Stis Diagnosis, Number Of Diagnoses High,
  "comments" VARCHAR
);

CREATE TABLE owid_in_prison_suicide_mortality_rate_per_100_000_inca_b25e0082 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_suicide_mortality_rate_per_100_000_incarcera_fbc1a7ff" FLOAT  -- In Prison Suicide Mortality Rate, Per 100–000 Incarcerated Persons Per Year
);

CREATE TABLE owid_in_prison_suicide_mortality_rate_per_100_000_inca_d7fb0446 (
  "year" INTEGER,
  "country" VARCHAR,
  "in_prison_suicide_mortality_rate_per_100_000_incarcera_fbc1a7ff" FLOAT  -- In Prison Suicide Mortality Rate, Per 100–000 Incarcerated Persons Per Year,
  "in_prison_suicide_mortality_rate_per_100_000_incarcera_e1d60f73" VARCHAR  -- In Prison Suicide Mortality Rate, Per 100–000 Incarcerated Persons Per Year Low,
  "in_prison_suicide_mortality_rate_per_100_000_incarcera_84779910" VARCHAR  -- In Prison Suicide Mortality Rate, Per 100–000 Incarcerated Persons Per Year High,
  "comments" VARCHAR
);