Global Health Observatory - World Health Organization

CREATE TABLE owid_safety_requirements_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sunbed_facility_safety_requirements" VARCHAR,
  "comments" VARCHAR,
  "safety_requirements" VARCHAR
);

CREATE TABLE owid_safety_requirements_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sunbed_facility_safety_requirements" VARCHAR,
  "safety_requirements" VARCHAR,
  "safety_requirements_low" VARCHAR,
  "safety_requirements_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_sales_of_beer_in_1000s_hectolitres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sales_of_beer_in_1000s_hectolitres" FLOAT
);

CREATE TABLE owid_sales_of_beer_in_1000s_hectolitres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sales_of_beer_in_1000s_hectolitres" FLOAT,
  "sales_of_beer_in_1000s_hectolitres_low" VARCHAR,
  "sales_of_beer_in_1000s_hectolitres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_sales_of_spirits_in_1000s_hectolitres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sales_of_spirits_in_1000s_hectolitres" FLOAT
);

CREATE TABLE owid_sales_of_spirits_in_1000s_hectolitres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sales_of_spirits_in_1000s_hectolitres" FLOAT,
  "sales_of_spirits_in_1000s_hectolitres_low" VARCHAR,
  "sales_of_spirits_in_1000s_hectolitres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_sales_of_wine_in_1000s_hectolitres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sales_of_wine_in_1000s_hectolitres" FLOAT
);

CREATE TABLE owid_sales_of_wine_in_1000s_hectolitres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sales_of_wine_in_1000s_hectolitres" FLOAT,
  "sales_of_wine_in_1000s_hectolitres_low" VARCHAR,
  "sales_of_wine_in_1000s_hectolitres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_satisfaction_with_assistive_products_and_related__1a7459dc (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "satisfaction_with_assistive_products_and_related_services" VARCHAR,
  "satisfaction_with_assistive_products_and_related_services_pct" FLOAT  -- Satisfaction With Assistive Products And Related Services, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_satisfaction_with_assistive_products_and_related__94516e8c (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "satisfaction_with_assistive_products_and_related_services" VARCHAR,
  "satisfaction_with_assistive_products_and_related_services_pct" FLOAT  -- Satisfaction With Assistive Products And Related Services, Pct,
  "satisfaction_with_assistive_products_and_related_servi_83e620f4" VARCHAR  -- Satisfaction With Assistive Products And Related Services, Pct Low,
  "satisfaction_with_assistive_products_and_related_servi_8175a55b" VARCHAR  -- Satisfaction With Assistive Products And Related Services, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_satisfaction_with_assistive_products_for_differen_0176e848 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "satisfaction_with_assistive_products_for_different_env_f73f452e" VARCHAR  -- Satisfaction With Assistive Products For Different Environments And Activities,
  "satisfaction_with_assistive_products_for_different_env_7fe16bbc" FLOAT  -- Satisfaction With Assistive Products For Different Environments And Activities, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_satisfaction_with_assistive_products_for_differen_aab690ef (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "satisfaction_with_assistive_products_for_different_env_f73f452e" VARCHAR  -- Satisfaction With Assistive Products For Different Environments And Activities,
  "satisfaction_with_assistive_products_for_different_env_7fe16bbc" FLOAT  -- Satisfaction With Assistive Products For Different Environments And Activities, Pct,
  "satisfaction_with_assistive_products_for_different_env_60e914fd" VARCHAR  -- Satisfaction With Assistive Products For Different Environments And Activities, Pct Low,
  "satisfaction_with_assistive_products_for_different_env_e1701f6a" VARCHAR  -- Satisfaction With Assistive Products For Different Environments And Activities, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_screening_and_brief_intervention_for_substance_us_24d678b2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "screening_and_brief_intervention_for_substance_use_in__a71fe8e1" VARCHAR  -- Screening And Brief Intervention For Substance Use In Primary Health Care,
  "screening_and_brief_intervention_for_substance_use_in__a552ce1d" VARCHAR  -- Screening And Brief Intervention For Substance Use In Primary Health Care Low,
  "screening_and_brief_intervention_for_substance_use_in__cf067338" VARCHAR  -- Screening And Brief Intervention For Substance Use In Primary Health Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_screening_and_brief_intervention_for_substance_us_4773b697 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "screening_and_brief_intervention_for_substance_use_in__b76fe129" VARCHAR  -- Screening And Brief Intervention For Substance Use In Antenatal Services,
  "screening_and_brief_intervention_for_substance_use_in__708d7c26" VARCHAR  -- Screening And Brief Intervention For Substance Use In Antenatal Services Low,
  "screening_and_brief_intervention_for_substance_use_in__385e474a" VARCHAR  -- Screening And Brief Intervention For Substance Use In Antenatal Services High,
  "comments" VARCHAR
);

CREATE TABLE owid_screening_and_brief_intervention_for_substance_us_4b9c62b9 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "screening_and_brief_intervention_for_substance_use_in__a71fe8e1" VARCHAR  -- Screening And Brief Intervention For Substance Use In Primary Health Care
);

CREATE TABLE owid_screening_and_brief_intervention_for_substance_us_89ae6f17 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "screening_and_brief_intervention_for_substance_use_in__b76fe129" VARCHAR  -- Screening And Brief Intervention For Substance Use In Antenatal Services
);

CREATE TABLE owid_screening_and_brief_interventions_for_substance_u_b8df8e7c (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "screening_and_brief_interventions_for_substance_use_an_0a133db5" VARCHAR  -- Screening And Brief Interventions For Substance Use And Substance Use Disorders
);

CREATE TABLE owid_screening_and_brief_interventions_for_substance_u_f3ddd361 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "screening_and_brief_interventions_for_substance_use_an_0a133db5" VARCHAR  -- Screening And Brief Interventions For Substance Use And Substance Use Disorders,
  "screening_and_brief_interventions_for_substance_use_an_7d32f663" VARCHAR  -- Screening And Brief Interventions For Substance Use And Substance Use Disorders Low,
  "screening_and_brief_interventions_for_substance_use_an_2545085d" VARCHAR  -- Screening And Brief Interventions For Substance Use And Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_sdg_6_3_1_proportion_of_safely_treated_domestic_w_0bbd60f2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sdg_6_3_1_proportion_of_safely_treated_domestic_wastew_f643e090" FLOAT  -- Sdg 6–3 1 Proportion Of Safely Treated Domestic Wastewater Flows, Pct,
  "sdg_6_3_1_proportion_of_safely_treated_domestic_wastew_861ba2a4" VARCHAR  -- Sdg 6–3 1 Proportion Of Safely Treated Domestic Wastewater Flows, Pct Low,
  "sdg_6_3_1_proportion_of_safely_treated_domestic_wastew_d8b84b30" VARCHAR  -- Sdg 6–3 1 Proportion Of Safely Treated Domestic Wastewater Flows, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_sdg_6_3_1_proportion_of_safely_treated_domestic_w_f05148b4 (
  "year" INTEGER,
  "country" VARCHAR,
  "sdg_6_3_1_proportion_of_safely_treated_domestic_wastew_f643e090" FLOAT  -- Sdg 6–3 1 Proportion Of Safely Treated Domestic Wastewater Flows, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_seat_belt_wearing_rate_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "seat_type" VARCHAR,
  "comments" VARCHAR,
  "seat_belt_wearing_rate_pct" VARCHAR  -- Seat Belt Wearing Rate, Pct
);

CREATE TABLE owid_seat_belt_wearing_rate_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "seat_type" VARCHAR,
  "seat_belt_wearing_rate_pct" VARCHAR  -- Seat Belt Wearing Rate, Pct,
  "seat_belt_wearing_rate_pct_low" VARCHAR  -- Seat Belt Wearing Rate, Pct Low,
  "seat_belt_wearing_rate_pct_high" VARCHAR  -- Seat Belt Wearing Rate, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_second_hand_smoke_attributable_dalys_000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "second_hand_smoke_attributable_dalys_000" FLOAT  -- Second Hand Smoke Attributable Dalys, 000
);

CREATE TABLE owid_second_hand_smoke_attributable_dalys_000_in_child_195333d8 (
  "year" INTEGER,
  "country" VARCHAR,
  "second_hand_smoke_attributable_dalys_000_in_children_u_bbbb81a7" FLOAT  -- Second Hand Smoke Attributable Dalys, 000, In Children Under 5 Years
);

CREATE TABLE owid_second_hand_smoke_attributable_dalys_per_100000_c_0618927b (
  "year" INTEGER,
  "country" VARCHAR,
  "second_hand_smoke_attributable_dalys_per_100000_childr_1f8c79e7" FLOAT  -- Second Hand Smoke Attributable Dalys Per 100000 Children Under 5 Years
);