Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_law_requires_helmet_to_be_fastened_2 (
"year" INTEGER,
"country" VARCHAR,
"law_requires_helmet_to_be_fastened" VARCHAR,
"law_requires_helmet_to_be_fastened_low" VARCHAR,
"law_requires_helmet_to_be_fastened_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lead_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"lead_attributable_dalys_000" FLOAT -- Lead Attributable Dalys, 000
);
CREATE TABLE owid_lead_attributable_dalys_000_in_children_under_5_years_1 (
"year" INTEGER,
"country" VARCHAR,
"lead_attributable_dalys_000_in_children_under_5_years" FLOAT -- Lead Attributable Dalys, 000, In Children Under 5 Years
);
CREATE TABLE owid_lead_attributable_dalys_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"lead_attributable_dalys_per_100000_capita" FLOAT
);
CREATE TABLE owid_lead_attributable_dalys_per_100000_children_under_b4853ee3 (
"year" INTEGER,
"country" VARCHAR,
"lead_attributable_dalys_per_100000_children_under_5_years" FLOAT
);
CREATE TABLE owid_lead_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"lead_attributable_deaths" FLOAT
);
CREATE TABLE owid_lead_attributable_deaths_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"lead_attributable_deaths_per_100000_capita" FLOAT
);
CREATE TABLE owid_legal_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"legal" VARCHAR
);
CREATE TABLE owid_legal_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"legal" VARCHAR,
"legal_low" VARCHAR,
"legal_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_legal_blood_alcohol_concentration_bac_limits_1 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_bac_groups" VARCHAR,
"legal_blood_alcohol_concentration_bac_limits" VARCHAR -- Legal Blood Alcohol Concentration, Bac, Limits
);
CREATE TABLE owid_legal_blood_alcohol_concentration_bac_limits_2 (
"year" INTEGER,
"country" VARCHAR,
"substance_abuse_bac_groups" VARCHAR,
"legal_blood_alcohol_concentration_bac_limits" VARCHAR -- Legal Blood Alcohol Concentration, Bac, Limits,
"legal_blood_alcohol_concentration_bac_limits_low" VARCHAR -- Legal Blood Alcohol Concentration, Bac, Limits Low,
"legal_blood_alcohol_concentration_bac_limits_high" VARCHAR -- Legal Blood Alcohol Concentration, Bac, Limits High,
"comments" VARCHAR
);
CREATE TABLE owid_legally_binding_controls_on_lead_paint_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"legally_binding_controls_on_lead_paint" VARCHAR
);
CREATE TABLE owid_legally_binding_controls_on_lead_paint_2 (
"year" INTEGER,
"country" VARCHAR,
"legally_binding_controls_on_lead_paint" VARCHAR,
"legally_binding_controls_on_lead_paint_low" VARCHAR,
"legally_binding_controls_on_lead_paint_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_legal_obligation_for_schools_to_include_alcohol_u_6e73b1d0 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"legal_obligation_for_schools_to_include_alcohol_use_prevention" VARCHAR
);
CREATE TABLE owid_legal_obligation_for_schools_to_include_alcohol_u_f97a75d3 (
"year" INTEGER,
"country" VARCHAR,
"legal_obligation_for_schools_to_include_alcohol_use_prevention" VARCHAR,
"legal_obligation_for_schools_to_include_alcohol_use_pr_f2c09593" VARCHAR -- Legal Obligation For Schools To Include Alcohol Use Prevention Low,
"legal_obligation_for_schools_to_include_alcohol_use_pr_0cb716a8" VARCHAR -- Legal Obligation For Schools To Include Alcohol Use Prevention High,
"comments" VARCHAR
);
CREATE TABLE owid_legal_obligation_for_schools_to_interact_with_par_5ba61881 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"legal_obligation_for_schools_to_interact_with_parents__e741b15c" VARCHAR -- Legal Obligation For Schools To Interact With Parents Regarding Education And Well Being
);
CREATE TABLE owid_legal_obligation_for_schools_to_interact_with_par_f6aa075b (
"year" INTEGER,
"country" VARCHAR,
"legal_obligation_for_schools_to_interact_with_parents__e741b15c" VARCHAR -- Legal Obligation For Schools To Interact With Parents Regarding Education And Well Being,
"legal_obligation_for_schools_to_interact_with_parents__721ae619" VARCHAR -- Legal Obligation For Schools To Interact With Parents Regarding Education And Well Being Low,
"legal_obligation_for_schools_to_interact_with_parents__204c1be6" VARCHAR -- Legal Obligation For Schools To Interact With Parents Regarding Education And Well Being High,
"comments" VARCHAR
);
CREATE TABLE owid_legal_requirement_for_size_of_health_warning_labels_1 (
"year" INTEGER,
"country" VARCHAR,
"legal_requirement_for_size_of_health_warning_labels" VARCHAR
);
CREATE TABLE owid_legal_requirement_for_size_of_health_warning_labels_2 (
"year" INTEGER,
"country" VARCHAR,
"legal_requirement_for_size_of_health_warning_labels" VARCHAR,
"legal_requirement_for_size_of_health_warning_labels_low" VARCHAR,
"legal_requirement_for_size_of_health_warning_labels_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_legislation (
"year" INTEGER,
"country" VARCHAR,
"legislation" INTEGER
);
CREATE TABLE owid_legislation_and_financing (
"year" INTEGER,
"country" VARCHAR,
"ihr_spar_capacity_level" VARCHAR,
"legislation_and_financing" INTEGER
);
CREATE TABLE owid_legislation_on_alcohol_testing_at_workplaces_1 (
"year" INTEGER,
"country" VARCHAR,
"legislation_on_alcohol_testing_at_workplaces" VARCHAR
);
CREATE TABLE owid_legislation_on_alcohol_testing_at_workplaces_2 (
"year" INTEGER,
"country" VARCHAR,
"legislation_on_alcohol_testing_at_workplaces" VARCHAR,
"legislation_on_alcohol_testing_at_workplaces_low" VARCHAR,
"legislation_on_alcohol_testing_at_workplaces_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_legislative_provision_for_compulsory_treatment_1 (
"year" INTEGER,
"country" VARCHAR,
"legislative_provision_for_compulsory_treatment" VARCHAR
);
CREATE TABLE owid_legislative_provision_for_compulsory_treatment_2 (
"year" INTEGER,
"country" VARCHAR,
"legislative_provision_for_compulsory_treatment" VARCHAR,
"legislative_provision_for_compulsory_treatment_low" VARCHAR,
"legislative_provision_for_compulsory_treatment_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.