Global Health Observatory - World Health Organization

CREATE TABLE owid_provision_for_secondary_prevention_of_rheumatic_f_61e6785c (
  "year" INTEGER,
  "country" VARCHAR,
  "provision_for_secondary_prevention_of_rheumatic_fever__0f9cad1e" VARCHAR  -- Provision For Secondary Prevention Of Rheumatic Fever And Rheumatic Heart Disease In More Than 50pct Of Public Sector Health Facilities,
  "provision_for_secondary_prevention_of_rheumatic_fever__f69b1b84" VARCHAR  -- Provision For Secondary Prevention Of Rheumatic Fever And Rheumatic Heart Disease In More Than 50pct Of Public Sector Health Facilities Low,
  "provision_for_secondary_prevention_of_rheumatic_fever__a1e71bd3" VARCHAR  -- Provision For Secondary Prevention Of Rheumatic Fever And Rheumatic Heart Disease In More Than 50pct Of Public Sector Health Facilities High,
  "comments" VARCHAR
);

CREATE TABLE owid_provision_for_secondary_prevention_of_rheumatic_f_86792d9b (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "provision_for_secondary_prevention_of_rheumatic_fever__0f9cad1e" VARCHAR  -- Provision For Secondary Prevention Of Rheumatic Fever And Rheumatic Heart Disease In More Than 50pct Of Public Sector Health Facilities
);

CREATE TABLE owid_provision_of_governmental_funding_to_dementia_non_3928e50f (
  "year" INTEGER,
  "country" VARCHAR,
  "provision_of_governmental_funding_to_dementia_nongover_5abcf34e" VARCHAR  -- Provision Of Governmental Funding To Dementia Nongovernmental Organization For Activities Services
);

CREATE TABLE owid_provision_of_governmental_funding_to_dementia_non_657abc8a (
  "year" INTEGER,
  "country" VARCHAR,
  "provision_of_governmental_funding_to_dementia_nongover_5abcf34e" VARCHAR  -- Provision Of Governmental Funding To Dementia Nongovernmental Organization For Activities Services,
  "provision_of_governmental_funding_to_dementia_nongover_0806a4ba" VARCHAR  -- Provision Of Governmental Funding To Dementia Nongovernmental Organization For Activities Services Low,
  "provision_of_governmental_funding_to_dementia_nongover_0b7c6ef8" VARCHAR  -- Provision Of Governmental Funding To Dementia Nongovernmental Organization For Activities Services High,
  "comments" VARCHAR
);

CREATE TABLE owid_psychiatrists_in_prisons_ftes_per_1000_prisoners_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychiatrists_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Psychiatrists In Prisons, Ftes Per 1000 Prisoners
);

CREATE TABLE owid_psychiatrists_in_prisons_ftes_per_1000_prisoners_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychiatrists_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Psychiatrists In Prisons, Ftes Per 1000 Prisoners,
  "psychiatrists_in_prisons_ftes_per_1000_prisoners_low" VARCHAR  -- Psychiatrists In Prisons, Ftes Per 1000 Prisoners Low,
  "psychiatrists_in_prisons_ftes_per_1000_prisoners_high" VARCHAR  -- Psychiatrists In Prisons, Ftes Per 1000 Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_psychiatrists_working_in_mental_health_sector_per_3870bf7d (
  "year" INTEGER,
  "country" VARCHAR,
  "psychiatrists_working_in_mental_health_sector_per_100__81de62a1" FLOAT  -- Psychiatrists Working In Mental Health Sector, Per 100–000 Population,
  "psychiatrists_working_in_mental_health_sector_per_100__0fd61825" VARCHAR  -- Psychiatrists Working In Mental Health Sector, Per 100–000 Population Low,
  "psychiatrists_working_in_mental_health_sector_per_100__7e6b78f0" VARCHAR  -- Psychiatrists Working In Mental Health Sector, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_psychiatrists_working_in_mental_health_sector_per_7d010cb3 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychiatrists_working_in_mental_health_sector_per_100__81de62a1" FLOAT  -- Psychiatrists Working In Mental Health Sector, Per 100–000 Population
);

CREATE TABLE owid_psychoactive_substance_causing_entry_into_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychoactive_substance_causing_entry_into_treatment" VARCHAR
);

CREATE TABLE owid_psychoactive_substance_causing_entry_into_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychoactive_substance_causing_entry_into_treatment" VARCHAR,
  "psychoactive_substance_causing_entry_into_treatment_low" VARCHAR,
  "psychoactive_substance_causing_entry_into_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_psychologists_working_in_mental_health_sector_per_26ec7ab5 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychologists_working_in_mental_health_sector_per_100__227049e1" FLOAT  -- Psychologists Working In Mental Health Sector, Per 100–000 Population,
  "psychologists_working_in_mental_health_sector_per_100__c3063e62" VARCHAR  -- Psychologists Working In Mental Health Sector, Per 100–000 Population Low,
  "psychologists_working_in_mental_health_sector_per_100__6424fbea" VARCHAR  -- Psychologists Working In Mental Health Sector, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_psychologists_working_in_mental_health_sector_per_86a08699 (
  "year" INTEGER,
  "country" VARCHAR,
  "psychologists_working_in_mental_health_sector_per_100__227049e1" FLOAT  -- Psychologists Working In Mental Health Sector, Per 100–000 Population
);

CREATE TABLE owid_publication_year_of_the_policy_or_plan_latest_revision_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "publication_year_of_the_policy_or_plan_latest_revision" INTEGER  -- Publication Year Of The Policy Or Plan, Latest Revision
);

CREATE TABLE owid_publication_year_of_the_policy_or_plan_latest_revision_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "publication_year_of_the_policy_or_plan_latest_revision" INTEGER  -- Publication Year Of The Policy Or Plan, Latest Revision,
  "publication_year_of_the_policy_or_plan_latest_revision_low" VARCHAR  -- Publication Year Of The Policy Or Plan, Latest Revision Low,
  "publication_year_of_the_policy_or_plan_latest_revision_high" VARCHAR  -- Publication Year Of The Policy Or Plan, Latest Revision High,
  "comments" VARCHAR
);

CREATE TABLE owid_public_funded_alcohol_research_monitoring_programmes_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "public_funded_alcohol_research_monitoring_programmes" VARCHAR
);

CREATE TABLE owid_public_funded_alcohol_research_monitoring_programmes_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "public_funded_alcohol_research_monitoring_programmes" VARCHAR,
  "public_funded_alcohol_research_monitoring_programmes_low" VARCHAR,
  "public_funded_alcohol_research_monitoring_programmes_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_public_funding_for_ehealth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "public_funding_for_ehealth" VARCHAR
);

CREATE TABLE owid_public_funding_for_ehealth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "public_funding_for_ehealth" VARCHAR,
  "public_funding_for_ehealth_low" VARCHAR,
  "public_funding_for_ehealth_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_public_funds_designated_for_alcohol_research_moni_008bc9f8 (
  "year" INTEGER,
  "country" VARCHAR,
  "public_funds_designated_for_alcohol_research_monitorin_b3b496c1" UINTEGER  -- Public Funds Designated For Alcohol Research Monitoring Programmes, In Euros,
  "public_funds_designated_for_alcohol_research_monitorin_99fa3a60" VARCHAR  -- Public Funds Designated For Alcohol Research Monitoring Programmes, In Euros Low,
  "public_funds_designated_for_alcohol_research_monitorin_54d39043" VARCHAR  -- Public Funds Designated For Alcohol Research Monitoring Programmes, In Euros High,
  "comments" VARCHAR
);

CREATE TABLE owid_public_funds_designated_for_alcohol_research_moni_1680f926 (
  "year" INTEGER,
  "country" VARCHAR,
  "public_funds_designated_for_alcohol_research_monitorin_b3b496c1" UINTEGER  -- Public Funds Designated For Alcohol Research Monitoring Programmes, In Euros
);

CREATE TABLE owid_public_private_partnerships_for_ehealth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "public_private_partnerships_for_ehealth" VARCHAR
);

CREATE TABLE owid_public_private_partnerships_for_ehealth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "public_private_partnerships_for_ehealth" VARCHAR,
  "public_private_partnerships_for_ehealth_low" VARCHAR,
  "public_private_partnerships_for_ehealth_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_pyrethroid_resistance_reported_for_at_least_one_site_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "pyrethroid_resistance_reported_for_at_least_one_site" VARCHAR
);

CREATE TABLE owid_pyrethroid_resistance_reported_for_at_least_one_site_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "pyrethroid_resistance_reported_for_at_least_one_site" VARCHAR,
  "pyrethroid_resistance_reported_for_at_least_one_site_low" VARCHAR,
  "pyrethroid_resistance_reported_for_at_least_one_site_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_qualitative_information_on_emission_yields_must_b_0b463d6e (
  "year" INTEGER,
  "country" VARCHAR,
  "qualitative_information_on_emission_yields_must_be_dis_29475089" INTEGER  -- Qualitative Information On Emission Yields Must Be Displayed On One Or More Principle Display Areas Of Other Smoked Tobacco Packaging,
  "comments" VARCHAR
);