Global Health Observatory - World Health Organization

CREATE TABLE owid_perceived_trend_in_exports_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_exports" VARCHAR,
  "perceived_trend_in_exports_low" VARCHAR,
  "perceived_trend_in_exports_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_imports_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_imports" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_imports_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_imports" VARCHAR,
  "perceived_trend_in_imports_low" VARCHAR,
  "perceived_trend_in_imports_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_production_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_production" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_production_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_production" VARCHAR,
  "perceived_trend_in_production_low" VARCHAR,
  "perceived_trend_in_production_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_sales_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_sales" VARCHAR
);

CREATE TABLE owid_perceived_trend_in_sales_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "perceived_trend_in_sales" VARCHAR,
  "perceived_trend_in_sales_low" VARCHAR,
  "perceived_trend_in_sales_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_children_under_15_years_exposed_to__cb601765 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_children_under_15_years_exposed_to_secon_615197f8" FLOAT  -- Percentage Of Children Under 15 Years Exposed To Second Hand Smoke
);

CREATE TABLE owid_percentage_of_health_care_facilities_with_no_acce_5d764c81 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "percentage_of_health_care_facilities_with_no_access_to_975307a0" INTEGER  -- Percentage Of Health Care Facilities With No Access To Any Electricity Supply, Pct,
  "percentage_of_health_care_facilities_with_no_access_to_f9d90a15" VARCHAR  -- Percentage Of Health Care Facilities With No Access To Any Electricity Supply, Pct Low,
  "percentage_of_health_care_facilities_with_no_access_to_37e8b964" VARCHAR  -- Percentage Of Health Care Facilities With No Access To Any Electricity Supply, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_health_care_facilities_with_no_acce_5faa0524 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "health_care_facility_type" VARCHAR,
  "percentage_of_health_care_facilities_with_no_access_to_975307a0" INTEGER  -- Percentage Of Health Care Facilities With No Access To Any Electricity Supply, Pct
);

CREATE TABLE owid_percentage_of_health_care_facilities_with_reliabl_5ce3e1e7 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "health_care_facility_type" VARCHAR,
  "percentage_of_health_care_facilities_with_reliable_ele_7cf8d059" INTEGER  -- Percentage Of Health Care Facilities With Reliable Electricity Supply, Pct
);

CREATE TABLE owid_percentage_of_health_care_facilities_with_reliabl_97045ecd (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "percentage_of_health_care_facilities_with_reliable_ele_7cf8d059" INTEGER  -- Percentage Of Health Care Facilities With Reliable Electricity Supply, Pct,
  "percentage_of_health_care_facilities_with_reliable_ele_760a198d" VARCHAR  -- Percentage Of Health Care Facilities With Reliable Electricity Supply, Pct Low,
  "percentage_of_health_care_facilities_with_reliable_ele_e3cab1ac" VARCHAR  -- Percentage Of Health Care Facilities With Reliable Electricity Supply, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_health_care_facilities_with_unrelia_23eccf65 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "percentage_of_health_care_facilities_with_unreliable_e_14e02949" INTEGER  -- Percentage Of Health Care Facilities With Unreliable Electricity Supply, Pct,
  "percentage_of_health_care_facilities_with_unreliable_e_a108f1ec" VARCHAR  -- Percentage Of Health Care Facilities With Unreliable Electricity Supply, Pct Low,
  "percentage_of_health_care_facilities_with_unreliable_e_4d02f019" VARCHAR  -- Percentage Of Health Care Facilities With Unreliable Electricity Supply, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_health_care_facilities_with_unrelia_5c363cb3 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "health_care_facility_type" VARCHAR,
  "percentage_of_health_care_facilities_with_unreliable_e_14e02949" INTEGER  -- Percentage Of Health Care Facilities With Unreliable Electricity Supply, Pct
);

CREATE TABLE owid_percentage_of_individuals_using_the_internet_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_individuals_using_the_internet" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_individuals_using_the_internet_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_individuals_using_the_internet" FLOAT,
  "percentage_of_individuals_using_the_internet_low" VARCHAR,
  "percentage_of_individuals_using_the_internet_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_men_15plus_years_exposed_to_second__639f83c4 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_men_15plus_years_exposed_to_second_hand_smoke" FLOAT  -- Percentage Of Men, 15plus Years, Exposed To Second Hand Smoke
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__074a09b5 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_4fd4f05a" FLOAT  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Other Smoked Tobacco Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_26e2828a" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Other Smoked Tobacco Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_e86c39aa" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Other Smoked Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__14a286e7 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_be49c1c0" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Other Smoked Tobacco Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__2039c298 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_ef952f32" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Other Smoked Tobacco Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__42fb8517 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_eb3dede7" FLOAT  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Smokeless Tobacco Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__43d599a7 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_a1205500" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Smokeless Tobacco Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_1700e9b7" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Smokeless Tobacco Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_48833cf5" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__4ad62c49 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_74e81811" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Cigarette Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_73451f27" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Cigarette Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_7aefc7b9" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__4e252b33 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_eb3dede7" FLOAT  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Smokeless Tobacco Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_94896e58" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Smokeless Tobacco Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_e100cd12" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__54fd7bd8 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_a1205500" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Smokeless Tobacco Packaging,
  "comments" VARCHAR
);