Global Health Observatory - World Health Organization

CREATE TABLE owid_employment_services_for_alcohol_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "employment_services_for_alcohol_use_disorders" VARCHAR,
  "employment_services_for_alcohol_use_disorders_low" VARCHAR,
  "employment_services_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_employment_services_for_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "employment_services_for_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_employment_services_for_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_location" VARCHAR,
  "employment_services_for_drug_use_disorders" VARCHAR,
  "employment_services_for_drug_use_disorders_low" VARCHAR,
  "employment_services_for_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_enabling_access_to_education_where_learning_facil_20a03f3f (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "enabling_access_to_education_where_learning_facilities_18f0748f" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, In Service
);

CREATE TABLE owid_enabling_access_to_education_where_learning_facil_21ab68c2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "enabling_access_to_education_where_learning_facilities_cf477c38" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, Pre Service,
  "enabling_access_to_education_where_learning_facilities_5f086e3a" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, Pre Service Low,
  "enabling_access_to_education_where_learning_facilities_ba52e672" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, Pre Service High,
  "comments" VARCHAR
);

CREATE TABLE owid_enabling_access_to_education_where_learning_facil_5a2a2fbf (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "enabling_access_to_education_where_learning_facilities_18f0748f" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, In Service,
  "enabling_access_to_education_where_learning_facilities_0e7698d0" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, In Service Low,
  "enabling_access_to_education_where_learning_facilities_e303971e" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, In Service High,
  "comments" VARCHAR
);

CREATE TABLE owid_enabling_access_to_education_where_learning_facil_f37f0368 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "enabling_access_to_education_where_learning_facilities_cf477c38" VARCHAR  -- Enabling Access To Education Where Learning Facilities Are Limited, Pre Service
);

CREATE TABLE owid_enforce_bans_on_tobacco_advertising_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "enforce_bans_on_tobacco_advertising" INTEGER
);

CREATE TABLE owid_enforce_bans_on_tobacco_advertising_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "enforce_bans_on_tobacco_advertising" INTEGER,
  "enforce_bans_on_tobacco_advertising_low" VARCHAR,
  "enforce_bans_on_tobacco_advertising_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_environmental_and_occupational_health_and_hygiene_4a7cd5b6 (
  "year" INTEGER,
  "country" VARCHAR,
  "environmental_and_occupational_health_and_hygiene_prof_abe01ad0" UINTEGER  -- Environmental And Occupational Health And Hygiene Professionals, Number,
  "environmental_and_occupational_health_and_hygiene_prof_7733065c" VARCHAR  -- Environmental And Occupational Health And Hygiene Professionals, Number Low,
  "environmental_and_occupational_health_and_hygiene_prof_04b9af14" VARCHAR  -- Environmental And Occupational Health And Hygiene Professionals, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_environmental_and_occupational_health_and_hygiene_a94e0ee2 (
  "year" INTEGER,
  "country" VARCHAR,
  "environmental_and_occupational_health_and_hygiene_prof_abe01ad0" UINTEGER  -- Environmental And Occupational Health And Hygiene Professionals, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_environmental_and_occupational_health_inspectors__4e45ddaa (
  "year" INTEGER,
  "country" VARCHAR,
  "environmental_and_occupational_health_inspectors_and_a_260b6842" UINTEGER  -- Environmental And Occupational Health Inspectors And Associates, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_environmental_and_occupational_health_inspectors__b46ce837 (
  "year" INTEGER,
  "country" VARCHAR,
  "environmental_and_occupational_health_inspectors_and_a_260b6842" UINTEGER  -- Environmental And Occupational Health Inspectors And Associates, Number,
  "environmental_and_occupational_health_inspectors_and_a_b1d81c69" VARCHAR  -- Environmental And Occupational Health Inspectors And Associates, Number Low,
  "environmental_and_occupational_health_inspectors_and_a_5a8a3a05" VARCHAR  -- Environmental And Occupational Health Inspectors And Associates, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_epidemiological_data_collection_for_substance_use_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "epidemiological_data_collection_for_substance_use" VARCHAR
);

CREATE TABLE owid_epidemiological_data_collection_for_substance_use_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "epidemiological_data_collection_for_substance_use" VARCHAR,
  "epidemiological_data_collection_for_substance_use_low" VARCHAR,
  "epidemiological_data_collection_for_substance_use_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_epidemiological_data_collection_system_for_substa_19758feb (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "epidemiological_data_collection_system_for_substance_u_643f3d37" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents,
  "epidemiological_data_collection_system_for_substance_u_7fad7b12" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents Low,
  "epidemiological_data_collection_system_for_substance_u_b94c0624" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents High,
  "comments" VARCHAR
);

CREATE TABLE owid_epidemiological_data_collection_system_for_substa_2084d429 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "epidemiological_data_collection_system_for_substance_u_d0960faf" VARCHAR  -- Epidemiological Data Collection System For Substance Use Disorders,
  "epidemiological_data_collection_system_for_substance_u_a67a2dbf" VARCHAR  -- Epidemiological Data Collection System For Substance Use Disorders Low,
  "epidemiological_data_collection_system_for_substance_u_665e1dee" VARCHAR  -- Epidemiological Data Collection System For Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_epidemiological_data_collection_system_for_substa_752c3bc4 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "epidemiological_data_collection_system_for_substance_u_643f3d37" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents
);

CREATE TABLE owid_epidemiological_data_collection_system_for_substa_86606f68 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "epidemiological_data_collection_system_for_substance_u_f3caa37c" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents, See Rsud 880,
  "epidemiological_data_collection_system_for_substance_u_236bb187" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents, See Rsud 880 Low,
  "epidemiological_data_collection_system_for_substance_u_3b670c9a" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents, See Rsud 880 High,
  "comments" VARCHAR
);

CREATE TABLE owid_epidemiological_data_collection_system_for_substa_9d910a06 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "epidemiological_data_collection_system_for_substance_u_d0960faf" VARCHAR  -- Epidemiological Data Collection System For Substance Use Disorders
);

CREATE TABLE owid_epidemiological_data_collection_system_for_substa_ae95cd94 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "epidemiological_data_collection_system_for_substance_u_f3caa37c" VARCHAR  -- Epidemiological Data Collection System For Substance Use Among Children And Adolescents, See Rsud 880
);

CREATE TABLE owid_essential_list_of_medicines_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "essential_list_of_medicines" VARCHAR
);

CREATE TABLE owid_essential_list_of_medicines_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "essential_list_of_medicines" VARCHAR,
  "essential_list_of_medicines_low" VARCHAR,
  "essential_list_of_medicines_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_essential_list_of_medicines_pharmacotherapy_for_s_527e250e (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "essential_list_of_medicines_pharmacotherapy_for_substa_9bd02738" VARCHAR  -- Essential List Of Medicines, Pharmacotherapy For Substance Use Disorders
);

CREATE TABLE owid_essential_list_of_medicines_pharmacotherapy_for_s_93d75594 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drugs" VARCHAR,
  "essential_list_of_medicines_pharmacotherapy_for_substa_9bd02738" VARCHAR  -- Essential List Of Medicines, Pharmacotherapy For Substance Use Disorders,
  "essential_list_of_medicines_pharmacotherapy_for_substa_f1e00b17" VARCHAR  -- Essential List Of Medicines, Pharmacotherapy For Substance Use Disorders Low,
  "essential_list_of_medicines_pharmacotherapy_for_substa_05799310" VARCHAR  -- Essential List Of Medicines, Pharmacotherapy For Substance Use Disorders High,
  "comments" VARCHAR
);