Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_occupational_injuries_attributable_dalys_per_1000_c7adcf68 (
"year" INTEGER,
"country" VARCHAR,
"occupational_injuries_attributable_dalys_per_100000_capita" FLOAT
);
CREATE TABLE owid_occupational_injuries_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_injuries_attributable_deaths" FLOAT
);
CREATE TABLE owid_occupational_injuries_attributable_deaths_per_100_b32dcf45 (
"year" INTEGER,
"country" VARCHAR,
"occupational_injuries_attributable_deaths_per_100000_capita" FLOAT
);
CREATE TABLE owid_occupational_noise_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_noise_attributable_dalys_000" FLOAT -- Occupational Noise Attributable Dalys, 000
);
CREATE TABLE owid_occupational_noise_attributable_dalys_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_noise_attributable_dalys_per_100000_capita" FLOAT
);
CREATE TABLE owid_occupational_risk_factors_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_risk_factors_attributable_dalys_000" FLOAT -- Occupational Risk Factors Attributable Dalys, 000
);
CREATE TABLE owid_occupational_risk_factors_attributable_dalys_per__4f5eccfa (
"year" INTEGER,
"country" VARCHAR,
"occupational_risk_factors_attributable_dalys_per_100000_capita" FLOAT
);
CREATE TABLE owid_occupational_risk_factors_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_risk_factors_attributable_deaths" FLOAT
);
CREATE TABLE owid_occupational_risk_factors_attributable_deaths_per_0eea3f85 (
"year" INTEGER,
"country" VARCHAR,
"occupational_risk_factors_attributable_deaths_per_100000_capita" FLOAT
);
CREATE TABLE owid_offer_help_to_quit_tobacco_use_1 (
"year" INTEGER,
"country" VARCHAR,
"offer_help_to_quit_tobacco_use" INTEGER
);
CREATE TABLE owid_offer_help_to_quit_tobacco_use_2 (
"year" INTEGER,
"country" VARCHAR,
"offer_help_to_quit_tobacco_use" INTEGER,
"offer_help_to_quit_tobacco_use_low" VARCHAR,
"offer_help_to_quit_tobacco_use_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_official_prison_capacity_count_1 (
"year" INTEGER,
"country" VARCHAR,
"official_prison_capacity_count" UINTEGER -- Official Prison Capacity, Count
);
CREATE TABLE owid_official_prison_capacity_count_2 (
"year" INTEGER,
"country" VARCHAR,
"official_prison_capacity_count" UINTEGER -- Official Prison Capacity, Count,
"official_prison_capacity_count_low" VARCHAR -- Official Prison Capacity, Count Low,
"official_prison_capacity_count_high" VARCHAR -- Official Prison Capacity, Count High,
"comments" VARCHAR
);
CREATE TABLE owid_official_standards_guidelines_for_prevention_mitigation_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"official_standards_guidelines_for_prevention_mitigation" VARCHAR
);
CREATE TABLE owid_official_standards_guidelines_for_prevention_mitigation_2 (
"year" INTEGER,
"country" VARCHAR,
"official_standards_guidelines_for_prevention_mitigation" VARCHAR,
"official_standards_guidelines_for_prevention_mitigation_low" VARCHAR,
"official_standards_guidelines_for_prevention_mitigation_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_at_petrol_stations_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_at_petrol_stations" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_at_petrol_stations_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_at_petrol_stations" VARCHAR,
"off_premise_sales_restrictions_at_petrol_stations_low" VARCHAR,
"off_premise_sales_restrictions_at_petrol_stations_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_at_specific_events_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_at_specific_events" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_at_specific_events_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_at_specific_events" VARCHAR,
"off_premise_sales_restrictions_at_specific_events_low" VARCHAR,
"off_premise_sales_restrictions_at_specific_events_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_days_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_days" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_days_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_days" VARCHAR,
"off_premise_sales_restrictions_on_days_low" VARCHAR,
"off_premise_sales_restrictions_on_days_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_hours_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_hours" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_hours_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_hours" VARCHAR,
"off_premise_sales_restrictions_on_hours_low" VARCHAR,
"off_premise_sales_restrictions_on_hours_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_outlet_density_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_outlet_density" VARCHAR
);
CREATE TABLE owid_off_premise_sales_restrictions_on_outlet_density_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"off_premise_sales_restrictions_on_outlet_density" VARCHAR,
"off_premise_sales_restrictions_on_outlet_density_low" VARCHAR,
"off_premise_sales_restrictions_on_outlet_density_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.