Global Health Observatory - World Health Organization

CREATE TABLE owid_regional_prevalence_aafs_all_cause_deaths_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "regional_prevalence_aafs_all_cause_deaths_pct" FLOAT  -- Regional Prevalence, Aafs, All Cause Deaths, Pct
);

CREATE TABLE owid_regional_prevalence_aafs_all_cause_deaths_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "regional_prevalence_aafs_all_cause_deaths_pct" FLOAT  -- Regional Prevalence, Aafs, All Cause Deaths, Pct,
  "regional_prevalence_aafs_all_cause_deaths_pct_low" FLOAT  -- Regional Prevalence, Aafs, All Cause Deaths, Pct Low,
  "regional_prevalence_aafs_all_cause_deaths_pct_high" FLOAT  -- Regional Prevalence, Aafs, All Cause Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_registration_of_medications_for_alcohol_dependenc_a094919b (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "registration_of_medications_for_alcohol_dependence_and_4f00adeb" VARCHAR  -- Registration Of Medications For Alcohol Dependence And Withdrawal,
  "registration_of_medications_for_alcohol_dependence_and_998b9065" VARCHAR  -- Registration Of Medications For Alcohol Dependence And Withdrawal Low,
  "registration_of_medications_for_alcohol_dependence_and_28ac7320" VARCHAR  -- Registration Of Medications For Alcohol Dependence And Withdrawal High,
  "comments" VARCHAR
);

CREATE TABLE owid_registration_of_medications_for_alcohol_dependenc_d5294505 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "registration_of_medications_for_alcohol_dependence_and_4f00adeb" VARCHAR  -- Registration Of Medications For Alcohol Dependence And Withdrawal
);

CREATE TABLE owid_registration_of_medications_for_opioid_dependence_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "registration_of_medications_for_opioid_dependence" VARCHAR
);

CREATE TABLE owid_registration_of_medications_for_opioid_dependence_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "registration_of_medications_for_opioid_dependence" VARCHAR,
  "registration_of_medications_for_opioid_dependence_low" VARCHAR,
  "registration_of_medications_for_opioid_dependence_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_registration_of_medications_for_opioid_withdrawal_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "registration_of_medications_for_opioid_withdrawal" VARCHAR
);

CREATE TABLE owid_registration_of_medications_for_opioid_withdrawal_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "registration_of_medications_for_opioid_withdrawal" VARCHAR,
  "registration_of_medications_for_opioid_withdrawal_low" VARCHAR,
  "registration_of_medications_for_opioid_withdrawal_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_registration_of_naloxone_for_injection_for_opioid_2a97f839 (
  "year" INTEGER,
  "country" VARCHAR,
  "registration_of_naloxone_for_injection_for_opioid_overdose" VARCHAR
);

CREATE TABLE owid_registration_of_naloxone_for_injection_for_opioid_7ddce5c0 (
  "year" INTEGER,
  "country" VARCHAR,
  "registration_of_naloxone_for_injection_for_opioid_overdose" VARCHAR,
  "registration_of_naloxone_for_injection_for_opioid_overdose_low" VARCHAR,
  "registration_of_naloxone_for_injection_for_opioid_overdose_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_regular_reports_from_national_monitoring_systems_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "regular_reports_from_national_monitoring_systems" VARCHAR
);

CREATE TABLE owid_regular_reports_from_national_monitoring_systems_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "regular_reports_from_national_monitoring_systems" VARCHAR,
  "regular_reports_from_national_monitoring_systems_low" VARCHAR,
  "regular_reports_from_national_monitoring_systems_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_regular_reports_on_epidemiological_and_service_de_c4a940c2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sources_of_reporting" VARCHAR,
  "regular_reports_on_epidemiological_and_service_deliver_ffa2c640" VARCHAR  -- Regular Reports On Epidemiological And Service Delivery Data For Substance Use
);

CREATE TABLE owid_regular_reports_on_epidemiological_and_service_de_fea133fd (
  "year" INTEGER,
  "country" VARCHAR,
  "sources_of_reporting" VARCHAR,
  "regular_reports_on_epidemiological_and_service_deliver_ffa2c640" VARCHAR  -- Regular Reports On Epidemiological And Service Delivery Data For Substance Use,
  "regular_reports_on_epidemiological_and_service_deliver_85c6fb22" VARCHAR  -- Regular Reports On Epidemiological And Service Delivery Data For Substance Use Low,
  "regular_reports_on_epidemiological_and_service_deliver_10bec85e" VARCHAR  -- Regular Reports On Epidemiological And Service Delivery Data For Substance Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_regulating_mobile_devices_and_software_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "regulating_mobile_devices_and_software" VARCHAR
);

CREATE TABLE owid_regulating_mobile_devices_and_software_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "regulating_mobile_devices_and_software" VARCHAR,
  "regulating_mobile_devices_and_software_low" VARCHAR,
  "regulating_mobile_devices_and_software_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_regulatory_oversight_of_mobile_apps_for_quality_s_0801af5a (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "regulatory_oversight_of_mobile_apps_for_quality_safety_c3cf5832" VARCHAR  -- Regulatory Oversight Of Mobile Apps For Quality, Safety And Reliability,
  "regulatory_oversight_of_mobile_apps_for_quality_safety_8ee6e5ad" VARCHAR  -- Regulatory Oversight Of Mobile Apps For Quality, Safety And Reliability Low,
  "regulatory_oversight_of_mobile_apps_for_quality_safety_0c9db891" VARCHAR  -- Regulatory Oversight Of Mobile Apps For Quality, Safety And Reliability High,
  "comments" VARCHAR
);

CREATE TABLE owid_regulatory_oversight_of_mobile_apps_for_quality_s_d06254e3 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "regulatory_oversight_of_mobile_apps_for_quality_safety_c3cf5832" VARCHAR  -- Regulatory Oversight Of Mobile Apps For Quality, Safety And Reliability
);

CREATE TABLE owid_relapse_cases_extrapulmonary (
  "year" INTEGER,
  "country" VARCHAR,
  "relapse_cases_extrapulmonary" INTEGER  -- Relapse Cases, Extrapulmonary
);

CREATE TABLE owid_relapse_cases_pre_2013_definition (
  "year" INTEGER,
  "country" VARCHAR,
  "relapse_cases_pre_2013_definition" UINTEGER  -- Relapse Cases, Pre 2013 Definition
);

CREATE TABLE owid_relapse_cases_pulmonary_bacteriologically_confirmed (
  "year" INTEGER,
  "country" VARCHAR,
  "relapse_cases_pulmonary_bacteriologically_confirmed" UINTEGER  -- Relapse Cases, Pulmonary, Bacteriologically Confirmed
);

CREATE TABLE owid_relapse_cases_pulmonary_clinically_diagnosed (
  "year" INTEGER,
  "country" VARCHAR,
  "relapse_cases_pulmonary_clinically_diagnosed" UINTEGER  -- Relapse Cases, Pulmonary, Clinically Diagnosed
);

CREATE TABLE owid_reported_number_of_children_receiving_antiretrovi_3509742d (
  "year" INTEGER,
  "country" VARCHAR,
  "reported_number_of_children_receiving_antiretroviral_therapy" UINTEGER
);

CREATE TABLE owid_reported_number_of_children_receiving_antiretrovi_3c56f4a2 (
  "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,
  "reported_number_of_children_receiving_antiretroviral_t_13e05d9e" VARCHAR  -- Reported Number Of Children Receiving Antiretroviral Therapy, Month And Year Of Report Low,
  "reported_number_of_children_receiving_antiretroviral_t_37c4aa54" VARCHAR  -- Reported Number Of Children Receiving Antiretroviral Therapy, Month And Year Of Report High,
  "comments" VARCHAR
);

CREATE TABLE owid_reported_number_of_children_receiving_antiretrovi_6138d074 (
  "year" INTEGER,
  "country" VARCHAR,
  "reported_number_of_children_receiving_antiretroviral_therapy" UINTEGER,
  "reported_number_of_children_receiving_antiretroviral_t_83629f10" VARCHAR  -- Reported Number Of Children Receiving Antiretroviral Therapy Low,
  "reported_number_of_children_receiving_antiretroviral_t_5d412d8e" VARCHAR  -- Reported Number Of Children Receiving Antiretroviral Therapy High,
  "comments" VARCHAR
);