Global Health Observatory - World Health Organization

CREATE TABLE owid_implementation_of_a_recent_mass_participation_event_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "implementation_of_a_recent_mass_participation_event" VARCHAR,
  "implementation_of_a_recent_mass_participation_event_low" VARCHAR,
  "implementation_of_a_recent_mass_participation_event_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_implementation_of_diet_and_or_physical_activity_p_628d930d (
  "year" INTEGER,
  "country" VARCHAR,
  "implementation_of_diet_and_or_physical_activity_public_2f9a3a22" VARCHAR  -- Implementation Of Diet And Or Physical Activity Public Awareness Program,
  "implementation_of_diet_and_or_physical_activity_public_0fb0781d" VARCHAR  -- Implementation Of Diet And Or Physical Activity Public Awareness Program Low,
  "implementation_of_diet_and_or_physical_activity_public_4b68c09e" VARCHAR  -- Implementation Of Diet And Or Physical Activity Public Awareness Program High,
  "comments" VARCHAR
);

CREATE TABLE owid_implementation_of_diet_and_or_physical_activity_p_880d9117 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "implementation_of_diet_and_or_physical_activity_public_2f9a3a22" VARCHAR  -- Implementation Of Diet And Or Physical Activity Public Awareness Program
);

CREATE TABLE owid_implementation_of_physical_activity_public_awaren_3dd2ccb6 (
  "year" INTEGER,
  "country" VARCHAR,
  "implementation_of_physical_activity_public_awareness_program" VARCHAR,
  "implementation_of_physical_activity_public_awareness_p_e2bc580d" VARCHAR  -- Implementation Of Physical Activity Public Awareness Program Low,
  "implementation_of_physical_activity_public_awareness_p_c4c060b6" VARCHAR  -- Implementation Of Physical Activity Public Awareness Program High,
  "comments" VARCHAR
);

CREATE TABLE owid_implementation_of_physical_activity_public_awaren_f6bae5a1 (
  "year" INTEGER,
  "country" VARCHAR,
  "implementation_of_physical_activity_public_awareness_program" VARCHAR
);

CREATE TABLE owid_importance_of_measures_for_enhancing_compliance_w_23c534c4 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_measure_importance_type" VARCHAR,
  "importance_of_measures_for_enhancing_compliance_with_age_limits" VARCHAR,
  "importance_of_measures_for_enhancing_compliance_with_a_4241d20f" VARCHAR  -- Importance Of Measures For Enhancing Compliance With Age Limits Low,
  "importance_of_measures_for_enhancing_compliance_with_a_616252ca" VARCHAR  -- Importance Of Measures For Enhancing Compliance With Age Limits High,
  "comments" VARCHAR
);

CREATE TABLE owid_importance_of_measures_for_enhancing_compliance_w_6ee9e97b (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_measure_importance_type" VARCHAR,
  "comments" VARCHAR,
  "importance_of_measures_for_enhancing_compliance_with_age_limits" VARCHAR
);

CREATE TABLE owid_import_duties_on_beverages_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "import_duties_on_beverages_pct" FLOAT  -- Import Duties On Beverages, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_import_duties_on_beverages_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "import_duties_on_beverages_pct" FLOAT  -- Import Duties On Beverages, Pct,
  "import_duties_on_beverages_pct_low" VARCHAR  -- Import Duties On Beverages, Pct Low,
  "import_duties_on_beverages_pct_high" VARCHAR  -- Import Duties On Beverages, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_imports_in_1000s_hectolitres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "imports_in_1000s_hectolitres" FLOAT
);

CREATE TABLE owid_imports_in_1000s_hectolitres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "imports_in_1000s_hectolitres" FLOAT,
  "imports_in_1000s_hectolitres_low" VARCHAR,
  "imports_in_1000s_hectolitres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_improving_access_to_content_and_experts_in_service_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "improving_access_to_content_and_experts_in_service" VARCHAR  -- Improving Access To Content And Experts, In Service
);

CREATE TABLE owid_improving_access_to_content_and_experts_in_service_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "improving_access_to_content_and_experts_in_service" VARCHAR  -- Improving Access To Content And Experts, In Service,
  "improving_access_to_content_and_experts_in_service_low" VARCHAR  -- Improving Access To Content And Experts, In Service Low,
  "improving_access_to_content_and_experts_in_service_high" VARCHAR  -- Improving Access To Content And Experts, In Service High,
  "comments" VARCHAR
);

CREATE TABLE owid_improving_access_to_content_and_experts_pre_service_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "improving_access_to_content_and_experts_pre_service" VARCHAR  -- Improving Access To Content And Experts, Pre Service
);

CREATE TABLE owid_improving_access_to_content_and_experts_pre_service_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "improving_access_to_content_and_experts_pre_service" VARCHAR  -- Improving Access To Content And Experts, Pre Service,
  "improving_access_to_content_and_experts_pre_service_low" VARCHAR  -- Improving Access To Content And Experts, Pre Service Low,
  "improving_access_to_content_and_experts_pre_service_high" VARCHAR  -- Improving Access To Content And Experts, Pre Service High,
  "comments" VARCHAR
);

CREATE TABLE owid_incidence_of_tuberculosis_per_100_000_population__0ae735f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "incidence_of_tuberculosis_per_100_000_population_per_year" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population Per Year,
  "incidence_of_tuberculosis_per_100_000_population_per_year_low" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population Per Year Low,
  "incidence_of_tuberculosis_per_100_000_population_per_year_high" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population Per Year High,
  "comments" VARCHAR
);

CREATE TABLE owid_incidence_of_tuberculosis_per_100_000_population__19c04585 (
  "year" INTEGER,
  "country" VARCHAR,
  "incidence_of_tuberculosis_per_100_000_population_hiv_p_0507b3e6" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population, Hiv Positive Cases,
  "incidence_of_tuberculosis_per_100_000_population_hiv_p_6facab1e" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population, Hiv Positive Cases Low,
  "incidence_of_tuberculosis_per_100_000_population_hiv_p_d00c66b3" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population, Hiv Positive Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_incidence_of_tuberculosis_per_100_000_population__73ce2064 (
  "year" INTEGER,
  "country" VARCHAR,
  "incidence_of_tuberculosis_per_100_000_population_hiv_p_0507b3e6" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population, Hiv Positive Cases
);

CREATE TABLE owid_incidence_of_tuberculosis_per_100_000_population__b8181bb8 (
  "year" INTEGER,
  "country" VARCHAR,
  "incidence_of_tuberculosis_per_100_000_population_per_year" FLOAT  -- Incidence Of Tuberculosis, Per 100–000 Population Per Year
);

CREATE TABLE owid_incidence_rate_of_lip_and_oral_cavity_cancer_per__54d4c705 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "incidence_rate_of_lip_and_oral_cavity_cancer_per_100_0_dda3dcab" FLOAT  -- Incidence Rate Of Lip And Oral Cavity Cancer, Per 100–000 Population,
  "incidence_rate_of_lip_and_oral_cavity_cancer_per_100_0_e4d577aa" VARCHAR  -- Incidence Rate Of Lip And Oral Cavity Cancer, Per 100–000 Population Low,
  "incidence_rate_of_lip_and_oral_cavity_cancer_per_100_0_c5c71909" VARCHAR  -- Incidence Rate Of Lip And Oral Cavity Cancer, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_chlamydia_in_individuals_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_chlamydia_in_individuals_in_thousands" UINTEGER  -- Incident Cases Of Chlamydia In Individuals, In Thousands
);

CREATE TABLE owid_incident_cases_of_chlamydia_in_individuals_in_thousands_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_chlamydia_in_individuals_in_thousands" UINTEGER  -- Incident Cases Of Chlamydia In Individuals, In Thousands,
  "incident_cases_of_chlamydia_in_individuals_in_thousands_low" INTEGER  -- Incident Cases Of Chlamydia In Individuals, In Thousands Low,
  "incident_cases_of_chlamydia_in_individuals_in_thousands_high" UINTEGER  -- Incident Cases Of Chlamydia In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_chlamydia_in_individuals_per_1000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_chlamydia_in_individuals_per_1000" INTEGER  -- Incident Cases Of Chlamydia In Individuals, Per 1000
);

CREATE TABLE owid_incident_cases_of_chlamydia_in_individuals_per_1000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_chlamydia_in_individuals_per_1000" INTEGER  -- Incident Cases Of Chlamydia In Individuals, Per 1000,
  "incident_cases_of_chlamydia_in_individuals_per_1000_low" INTEGER  -- Incident Cases Of Chlamydia In Individuals, Per 1000 Low,
  "incident_cases_of_chlamydia_in_individuals_per_1000_high" INTEGER  -- Incident Cases Of Chlamydia In Individuals, Per 1000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_gonorrhoea_in_individuals_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_gonorrhoea_in_individuals_in_thousands" INTEGER  -- Incident Cases Of Gonorrhoea In Individuals, In Thousands
);