Global Health Observatory - World Health Organization

CREATE TABLE owid_counselling_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "counselling" VARCHAR,
  "counselling_low" VARCHAR,
  "counselling_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_counselling_to_children_in_families_with_alcohol__4c23e5ff (
  "year" INTEGER,
  "country" VARCHAR,
  "counselling_to_children_in_families_with_alcohol_problems" VARCHAR
);

CREATE TABLE owid_counselling_to_children_in_families_with_alcohol__606ce1d2 (
  "year" INTEGER,
  "country" VARCHAR,
  "counselling_to_children_in_families_with_alcohol_problems" VARCHAR,
  "counselling_to_children_in_families_with_alcohol_problems_low" VARCHAR,
  "counselling_to_children_in_families_with_alcohol_problems_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_counselling_to_pregnant_women_with_alcohol_problems_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "counselling_to_pregnant_women_with_alcohol_problems" VARCHAR
);

CREATE TABLE owid_counselling_to_pregnant_women_with_alcohol_problems_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "counselling_to_pregnant_women_with_alcohol_problems" VARCHAR,
  "counselling_to_pregnant_women_with_alcohol_problems_low" VARCHAR,
  "counselling_to_pregnant_women_with_alcohol_problems_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_countries_that_have_passed_legislation_on_univers_59c315a9 (
  "year" INTEGER,
  "country" VARCHAR,
  "countries_that_have_passed_legislation_on_universal_he_fe90c3ec" VARCHAR  -- Countries That Have Passed Legislation On Universal Health Coverage, Uhc,
  "countries_that_have_passed_legislation_on_universal_he_be2cf3bd" VARCHAR  -- Countries That Have Passed Legislation On Universal Health Coverage, Uhc Low,
  "countries_that_have_passed_legislation_on_universal_he_32765269" VARCHAR  -- Countries That Have Passed Legislation On Universal Health Coverage, Uhc High,
  "comments" VARCHAR
);

CREATE TABLE owid_countries_that_have_passed_legislation_on_univers_93c6e71a (
  "year" INTEGER,
  "country" VARCHAR,
  "countries_that_have_passed_legislation_on_universal_he_fe90c3ec" VARCHAR  -- Countries That Have Passed Legislation On Universal Health Coverage, Uhc
);

CREATE TABLE owid_country_has_national_ehr_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_ehr" VARCHAR
);

CREATE TABLE owid_country_has_national_ehr_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_ehr" VARCHAR,
  "country_has_national_ehr_low" VARCHAR,
  "country_has_national_ehr_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_country_has_national_policy_or_strategy_on_the_us_554a4cd5 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_policy_or_strategy_on_the_use_of__2ad39051" VARCHAR  -- Country Has National Policy Or Strategy On The Use Of Social Media By Government Organizations,
  "country_has_national_policy_or_strategy_on_the_use_of__f1fbd6bf" VARCHAR  -- Country Has National Policy Or Strategy On The Use Of Social Media By Government Organizations Low,
  "country_has_national_policy_or_strategy_on_the_use_of__86cf0e1e" VARCHAR  -- Country Has National Policy Or Strategy On The Use Of Social Media By Government Organizations High,
  "comments" VARCHAR
);

CREATE TABLE owid_country_has_national_policy_or_strategy_on_the_us_d1651820 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_policy_or_strategy_on_the_use_of__2ad39051" VARCHAR  -- Country Has National Policy Or Strategy On The Use Of Social Media By Government Organizations
);

CREATE TABLE owid_country_has_national_policy_or_strategy_regulatin_3094f4e4 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_policy_or_strategy_regulating_the_852763fc" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data By Private Companies,
  "country_has_national_policy_or_strategy_regulating_the_531a5a13" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data By Private Companies Low,
  "country_has_national_policy_or_strategy_regulating_the_1425389f" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data By Private Companies High,
  "comments" VARCHAR
);

CREATE TABLE owid_country_has_national_policy_or_strategy_regulatin_4b12e9ab (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_policy_or_strategy_regulating_the_548534bb" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data In The Health Sector,
  "country_has_national_policy_or_strategy_regulating_the_376cb749" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data In The Health Sector Low,
  "country_has_national_policy_or_strategy_regulating_the_8b14ae7c" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data In The Health Sector High,
  "comments" VARCHAR
);

CREATE TABLE owid_country_has_national_policy_or_strategy_regulatin_5deeeeb7 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_policy_or_strategy_regulating_the_548534bb" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data In The Health Sector
);

CREATE TABLE owid_country_has_national_policy_or_strategy_regulatin_e7185e4a (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_national_policy_or_strategy_regulating_the_852763fc" VARCHAR  -- Country Has National Policy Or Strategy Regulating The Use Of Big Data By Private Companies
);

CREATE TABLE owid_country_has_specific_legislation_governing_the_us_69b2aa81 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_specific_legislation_governing_the_use_of__c68d6283" VARCHAR  -- Country Has Specific Legislation Governing The Use Of National Ehr System
);

CREATE TABLE owid_country_has_specific_legislation_governing_the_us_b0142b1d (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_specific_legislation_governing_the_use_of__c68d6283" VARCHAR  -- Country Has Specific Legislation Governing The Use Of National Ehr System,
  "country_has_specific_legislation_governing_the_use_of__64ecd270" VARCHAR  -- Country Has Specific Legislation Governing The Use Of National Ehr System Low,
  "country_has_specific_legislation_governing_the_use_of__aad48dac" VARCHAR  -- Country Has Specific Legislation Governing The Use Of National Ehr System High,
  "comments" VARCHAR
);

CREATE TABLE owid_country_has_telehealth_policy_or_strategy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_telehealth_policy_or_strategy" VARCHAR
);

CREATE TABLE owid_country_has_telehealth_policy_or_strategy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "country_has_telehealth_policy_or_strategy" VARCHAR,
  "country_has_telehealth_policy_or_strategy_low" VARCHAR,
  "country_has_telehealth_policy_or_strategy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_coverage_of_national_cervical_cancer_screening_pr_17f7e622 (
  "year" INTEGER,
  "country" VARCHAR,
  "coverage_of_national_cervical_cancer_screening_program_pct" VARCHAR  -- Coverage Of National Cervical Cancer Screening Program, Pct,
  "coverage_of_national_cervical_cancer_screening_program_pct_low" VARCHAR  -- Coverage Of National Cervical Cancer Screening Program, Pct Low,
  "coverage_of_national_cervical_cancer_screening_program_pct_high" VARCHAR  -- Coverage Of National Cervical Cancer Screening Program, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_coverage_of_national_cervical_cancer_screening_pr_4cb3dbf1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "coverage_of_national_cervical_cancer_screening_program_pct" VARCHAR  -- Coverage Of National Cervical Cancer Screening Program, Pct
);

CREATE TABLE owid_coverage_of_people_in_need_of_assistive_technolog_1b34bb57 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "coverage_of_people_in_need_of_assistive_technology_by__f4d28f93" VARCHAR  -- Coverage Of People In Need Of Assistive Technology By Legislation,
  "coverage_of_people_in_need_of_assistive_technology_by__011e466d" VARCHAR  -- Coverage Of People In Need Of Assistive Technology By Legislation Low,
  "coverage_of_people_in_need_of_assistive_technology_by__691567f8" VARCHAR  -- Coverage Of People In Need Of Assistive Technology By Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_coverage_of_people_in_need_of_assistive_technolog_4349f3cb (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_subquestion" VARCHAR,
  "coverage_of_people_in_need_of_assistive_technology_by__f4d28f93" VARCHAR  -- Coverage Of People In Need Of Assistive Technology By Legislation
);

CREATE TABLE owid_crude_suicide_rates_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "crude_suicide_rates_per_100_000_population" FLOAT  -- Crude Suicide Rates, Per 100–000 Population
);

CREATE TABLE owid_crude_suicide_rates_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "crude_suicide_rates_per_100_000_population" FLOAT  -- Crude Suicide Rates, Per 100–000 Population,
  "crude_suicide_rates_per_100_000_population_low" FLOAT  -- Crude Suicide Rates, Per 100–000 Population Low,
  "crude_suicide_rates_per_100_000_population_high" FLOAT  -- Crude Suicide Rates, Per 100–000 Population High,
  "comments" VARCHAR
);