Global Health Observatory - World Health Organization

CREATE TABLE owid_availability_of_naloxone_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_naloxone" VARCHAR
);

CREATE TABLE owid_availability_of_naloxone_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_naloxone" VARCHAR,
  "availability_of_naloxone_low" VARCHAR,
  "availability_of_naloxone_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_national_list_of_approved_medical_3478551c (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_national_list_of_approved_medical_devi_a1a706ad" INTEGER  -- Availability Of National List Of Approved Medical Devices For Procurement Or Reimbursement,
  "availability_of_national_list_of_approved_medical_devi_ab5f870b" VARCHAR  -- Availability Of National List Of Approved Medical Devices For Procurement Or Reimbursement Low,
  "availability_of_national_list_of_approved_medical_devi_37ae4044" VARCHAR  -- Availability Of National List Of Approved Medical Devices For Procurement Or Reimbursement High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_national_list_of_approved_medical_d1659b1b (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_national_list_of_approved_medical_devi_a1a706ad" INTEGER  -- Availability Of National List Of Approved Medical Devices For Procurement Or Reimbursement,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_national_standards_or_recommended_7ffa88f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_national_standards_or_recommended_list_a1e24c14" INTEGER  -- Availability Of National Standards Or Recommended Lists Of Medical Devices,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_national_standards_or_recommended_fde60662 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_national_standards_or_recommended_list_a1e24c14" INTEGER  -- Availability Of National Standards Or Recommended Lists Of Medical Devices,
  "availability_of_national_standards_or_recommended_list_79474d5f" VARCHAR  -- Availability Of National Standards Or Recommended Lists Of Medical Devices Low,
  "availability_of_national_standards_or_recommended_list_1f77bd20" VARCHAR  -- Availability Of National Standards Or Recommended Lists Of Medical Devices High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_palliative_and_end_of_life_care_s_aa6ede20 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_palliative_and_end_of_life_care_servic_42b5ba7d" VARCHAR  -- Availability Of Palliative And End Of Life Care Services In Community For Dementia
);

CREATE TABLE owid_availability_of_palliative_and_end_of_life_care_s_e876fba4 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_palliative_and_end_of_life_care_servic_42b5ba7d" VARCHAR  -- Availability Of Palliative And End Of Life Care Services In Community For Dementia,
  "availability_of_palliative_and_end_of_life_care_servic_60fb1095" VARCHAR  -- Availability Of Palliative And End Of Life Care Services In Community For Dementia Low,
  "availability_of_palliative_and_end_of_life_care_servic_8ee98569" VARCHAR  -- Availability Of Palliative And End Of Life Care Services In Community For Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_psychosocial_and_rehabilitation_s_6fda598d (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_psychosocial_and_rehabilitation_servic_ad090e4d" VARCHAR  -- Availability Of Psychosocial And Rehabilitation Services In Community For Dementia,
  "availability_of_psychosocial_and_rehabilitation_servic_7d3c9e30" VARCHAR  -- Availability Of Psychosocial And Rehabilitation Services In Community For Dementia Low,
  "availability_of_psychosocial_and_rehabilitation_servic_eab9c0fb" VARCHAR  -- Availability Of Psychosocial And Rehabilitation Services In Community For Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_psychosocial_and_rehabilitation_s_acbbc28f (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_psychosocial_and_rehabilitation_servic_ad090e4d" VARCHAR  -- Availability Of Psychosocial And Rehabilitation Services In Community For Dementia
);

CREATE TABLE owid_availability_of_public_funding_for_assistive_technology_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "comments" VARCHAR,
  "availability_of_public_funding_for_assistive_technology" VARCHAR
);

CREATE TABLE owid_availability_of_public_funding_for_assistive_technology_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "availability_of_public_funding_for_assistive_technology" VARCHAR,
  "availability_of_public_funding_for_assistive_technology_low" VARCHAR,
  "availability_of_public_funding_for_assistive_technology_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_routine_antipsychotic_prescriptio_0158901c (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_antipsychotic_prescription_rec_9372e907" VARCHAR  -- Availability Of Routine Antipsychotic Prescription Records For People With Dementia For Monitoring Purposes,
  "availability_of_routine_antipsychotic_prescription_rec_7e5288ce" VARCHAR  -- Availability Of Routine Antipsychotic Prescription Records For People With Dementia For Monitoring Purposes Low,
  "availability_of_routine_antipsychotic_prescription_rec_0fc01707" VARCHAR  -- Availability Of Routine Antipsychotic Prescription Records For People With Dementia For Monitoring Purposes High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_routine_antipsychotic_prescriptio_df8e1149 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_antipsychotic_prescription_rec_9372e907" VARCHAR  -- Availability Of Routine Antipsychotic Prescription Records For People With Dementia For Monitoring Purposes
);

CREATE TABLE owid_availability_of_routine_hospital_admissions_recor_4b87fac2 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_hospital_admissions_records_fo_cd031128" VARCHAR  -- Availability Of Routine Hospital Admissions Records For People With Dementia For Monitoring Purposes,
  "availability_of_routine_hospital_admissions_records_fo_9e12624a" VARCHAR  -- Availability Of Routine Hospital Admissions Records For People With Dementia For Monitoring Purposes Low,
  "availability_of_routine_hospital_admissions_records_fo_6eafd18b" VARCHAR  -- Availability Of Routine Hospital Admissions Records For People With Dementia For Monitoring Purposes High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_routine_hospital_admissions_recor_dd2e48b7 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_hospital_admissions_records_fo_cd031128" VARCHAR  -- Availability Of Routine Hospital Admissions Records For People With Dementia For Monitoring Purposes
);

CREATE TABLE owid_availability_of_routine_outpatient_intervention_a_11fa9180 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_outpatient_intervention_and_tr_647c4eb8" VARCHAR  -- Availability Of Routine Outpatient Intervention And Treatment Records For People With Dementia For Monitoring Purposes,
  "availability_of_routine_outpatient_intervention_and_tr_19b9cf9f" VARCHAR  -- Availability Of Routine Outpatient Intervention And Treatment Records For People With Dementia For Monitoring Purposes Low,
  "availability_of_routine_outpatient_intervention_and_tr_f92d38bc" VARCHAR  -- Availability Of Routine Outpatient Intervention And Treatment Records For People With Dementia For Monitoring Purposes High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_routine_outpatient_intervention_a_3c545615 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_outpatient_intervention_and_tr_647c4eb8" VARCHAR  -- Availability Of Routine Outpatient Intervention And Treatment Records For People With Dementia For Monitoring Purposes
);

CREATE TABLE owid_availability_of_routine_outpatient_visit_records__4ff05c30 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_outpatient_visit_records_for_p_a4b795d4" VARCHAR  -- Availability Of Routine Outpatient Visit Records For People With Dementia For Monitoring Purposes
);

CREATE TABLE owid_availability_of_routine_outpatient_visit_records__fd778f17 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_outpatient_visit_records_for_p_a4b795d4" VARCHAR  -- Availability Of Routine Outpatient Visit Records For People With Dementia For Monitoring Purposes,
  "availability_of_routine_outpatient_visit_records_for_p_aac23906" VARCHAR  -- Availability Of Routine Outpatient Visit Records For People With Dementia For Monitoring Purposes Low,
  "availability_of_routine_outpatient_visit_records_for_p_67c96255" VARCHAR  -- Availability Of Routine Outpatient Visit Records For People With Dementia For Monitoring Purposes High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_routine_pharmaceutical_records_fo_d59c1ce7 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_pharmaceutical_records_for_peo_10d44d25" VARCHAR  -- Availability Of Routine Pharmaceutical Records For People With Dementia For Monitoring Purposes
);

CREATE TABLE owid_availability_of_routine_pharmaceutical_records_fo_ecb5f620 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_routine_pharmaceutical_records_for_peo_10d44d25" VARCHAR  -- Availability Of Routine Pharmaceutical Records For People With Dementia For Monitoring Purposes,
  "availability_of_routine_pharmaceutical_records_for_peo_4c942325" VARCHAR  -- Availability Of Routine Pharmaceutical Records For People With Dementia For Monitoring Purposes Low,
  "availability_of_routine_pharmaceutical_records_for_peo_e82f8ac3" VARCHAR  -- Availability Of Routine Pharmaceutical Records For People With Dementia For Monitoring Purposes High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_social_and_financial_protection_f_29a39900 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_social_and_financial_protection_for_dementia" VARCHAR,
  "availability_of_social_and_financial_protection_for_de_1756fff9" VARCHAR  -- Availability Of Social And Financial Protection For Dementia Low,
  "availability_of_social_and_financial_protection_for_de_131c0480" VARCHAR  -- Availability Of Social And Financial Protection For Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_availability_of_social_and_financial_protection_f_a66e70a7 (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_social_and_financial_protection_for_dementia" VARCHAR
);

CREATE TABLE owid_availability_of_technical_specifications_of_medic_261e73cf (
  "year" INTEGER,
  "country" VARCHAR,
  "availability_of_technical_specifications_of_medical_de_6e745a17" INTEGER  -- Availability Of Technical Specifications Of Medical Devices To Support Procurement Or Donations,
  "availability_of_technical_specifications_of_medical_de_abe0a91d" VARCHAR  -- Availability Of Technical Specifications Of Medical Devices To Support Procurement Or Donations Low,
  "availability_of_technical_specifications_of_medical_de_a40b0963" VARCHAR  -- Availability Of Technical Specifications Of Medical Devices To Support Procurement Or Donations High,
  "comments" VARCHAR
);