Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_adult_day_centres_1 (
"year" INTEGER,
"country" VARCHAR,
"adult_day_centres" VARCHAR
);
CREATE TABLE owid_adult_day_centres_2 (
"year" INTEGER,
"country" VARCHAR,
"adult_day_centres" VARCHAR,
"adult_day_centres_low" VARCHAR,
"adult_day_centres_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_adult_mortality_rate_probability_of_dying_between_57c7bd86 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"adult_mortality_rate_probability_of_dying_between_15_a_6ed0a740" FLOAT
);
CREATE TABLE owid_adult_mortality_rate_probability_of_dying_between_ba0444f8 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"adult_mortality_rate_probability_of_dying_between_15_a_6ed0a740" FLOAT,
"adult_mortality_rate_probability_of_dying_between_15_a_9ce83994" VARCHAR,
"adult_mortality_rate_probability_of_dying_between_15_a_2ff53164" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_at_cinemas_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_at_cinemas" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_at_cinemas_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_at_cinemas" VARCHAR,
"advertising_restrictions_at_cinemas_low" VARCHAR,
"advertising_restrictions_at_cinemas_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_at_point_of_sale_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_at_point_of_sale" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_at_point_of_sale_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_at_point_of_sale" VARCHAR,
"advertising_restrictions_at_point_of_sale_low" VARCHAR,
"advertising_restrictions_at_point_of_sale_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_in_print_media_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_in_print_media" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_in_print_media_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_in_print_media" VARCHAR,
"advertising_restrictions_in_print_media_low" VARCHAR,
"advertising_restrictions_in_print_media_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_billboards_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_billboards" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_billboards_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_billboards" VARCHAR,
"advertising_restrictions_on_billboards_low" VARCHAR,
"advertising_restrictions_on_billboards_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_cable_television_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_cable_television" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_cable_television_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_cable_television" VARCHAR,
"advertising_restrictions_on_cable_television_low" VARCHAR,
"advertising_restrictions_on_cable_television_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_local_radio_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_local_radio" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_local_radio_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_local_radio" VARCHAR,
"advertising_restrictions_on_local_radio_low" VARCHAR,
"advertising_restrictions_on_local_radio_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_national_radio_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_national_radio" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_national_radio_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_national_radio" VARCHAR,
"advertising_restrictions_on_national_radio_low" VARCHAR,
"advertising_restrictions_on_national_radio_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_national_television_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_national_television" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_national_television_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_national_television" VARCHAR,
"advertising_restrictions_on_national_television_low" VARCHAR,
"advertising_restrictions_on_national_television_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_social_media_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_social_media" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_social_media_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_social_media" VARCHAR,
"advertising_restrictions_on_social_media_low" VARCHAR,
"advertising_restrictions_on_social_media_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_the_internet_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_the_internet" VARCHAR
);
CREATE TABLE owid_advertising_restrictions_on_the_internet_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_advertising_types" VARCHAR,
"advertising_restrictions_on_the_internet" VARCHAR,
"advertising_restrictions_on_the_internet_low" VARCHAR,
"advertising_restrictions_on_the_internet_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_affordability_of_cigarettes_category_of_change_in_69d88a38 (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_cigarettes_category_of_change_in_the__abc67443" VARCHAR
);
Anyone who has the link will be able to view this.