Global Health Observatory - World Health Organization

CREATE TABLE owid_physicians_in_prisons_ftes_per_1000_prisoners_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "physicians_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Physicians In Prisons, Ftes Per 1000 Prisoners
);

CREATE TABLE owid_physicians_in_prisons_ftes_per_1000_prisoners_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "physicians_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Physicians In Prisons, Ftes Per 1000 Prisoners,
  "physicians_in_prisons_ftes_per_1000_prisoners_low" VARCHAR  -- Physicians In Prisons, Ftes Per 1000 Prisoners Low,
  "physicians_in_prisons_ftes_per_1000_prisoners_high" VARCHAR  -- Physicians In Prisons, Ftes Per 1000 Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_physiotherapists_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "physiotherapists_number" UINTEGER  -- Physiotherapists, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_physiotherapists_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "physiotherapists_number" UINTEGER  -- Physiotherapists, Number,
  "physiotherapists_number_low" VARCHAR  -- Physiotherapists, Number Low,
  "physiotherapists_number_high" VARCHAR  -- Physiotherapists, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_physiotherapy_technicians_and_assistants_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "physiotherapy_technicians_and_assistants_number" UINTEGER  -- Physiotherapy Technicians And Assistants, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_physiotherapy_technicians_and_assistants_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "physiotherapy_technicians_and_assistants_number" UINTEGER  -- Physiotherapy Technicians And Assistants, Number,
  "physiotherapy_technicians_and_assistants_number_low" VARCHAR  -- Physiotherapy Technicians And Assistants, Number Low,
  "physiotherapy_technicians_and_assistants_number_high" VARCHAR  -- Physiotherapy Technicians And Assistants, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_plain_packaging_of_cigarettes_is_mandatory_ie_the_7d32e996 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "plain_packaging_of_cigarettes_is_mandatory_ie_the_use__8290edc5" VARCHAR  -- Plain Packaging Of Cigarettes Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited
);

CREATE TABLE owid_plain_packaging_of_cigarettes_is_mandatory_ie_the_a731476d (
  "year" INTEGER,
  "country" VARCHAR,
  "plain_packaging_of_cigarettes_is_mandatory_ie_the_use__8290edc5" VARCHAR  -- Plain Packaging Of Cigarettes Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited,
  "plain_packaging_of_cigarettes_is_mandatory_ie_the_use__0d9f5caa" VARCHAR  -- Plain Packaging Of Cigarettes Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited Low,
  "plain_packaging_of_cigarettes_is_mandatory_ie_the_use__bd2b516f" VARCHAR  -- Plain Packaging Of Cigarettes Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited High,
  "comments" VARCHAR
);

CREATE TABLE owid_plain_packaging_of_other_smoked_tobacco_products__53170048 (
  "year" INTEGER,
  "country" VARCHAR,
  "plain_packaging_of_other_smoked_tobacco_products_is_ma_54b410c5" VARCHAR  -- Plain Packaging Of Other Smoked Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited,
  "plain_packaging_of_other_smoked_tobacco_products_is_ma_c1a3da98" VARCHAR  -- Plain Packaging Of Other Smoked Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited Low,
  "plain_packaging_of_other_smoked_tobacco_products_is_ma_1317a3fc" VARCHAR  -- Plain Packaging Of Other Smoked Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited High,
  "comments" VARCHAR
);

CREATE TABLE owid_plain_packaging_of_other_smoked_tobacco_products__a3b6d24b (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "plain_packaging_of_other_smoked_tobacco_products_is_ma_54b410c5" VARCHAR  -- Plain Packaging Of Other Smoked Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited
);

CREATE TABLE owid_plain_packaging_of_smokeless_tobacco_products_is__1f529635 (
  "year" INTEGER,
  "country" VARCHAR,
  "plain_packaging_of_smokeless_tobacco_products_is_manda_a72505e7" VARCHAR  -- Plain Packaging Of Smokeless Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited,
  "plain_packaging_of_smokeless_tobacco_products_is_manda_73acd4a9" VARCHAR  -- Plain Packaging Of Smokeless Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited Low,
  "plain_packaging_of_smokeless_tobacco_products_is_manda_29623281" VARCHAR  -- Plain Packaging Of Smokeless Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited High,
  "comments" VARCHAR
);

CREATE TABLE owid_plain_packaging_of_smokeless_tobacco_products_is__c097b62d (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "plain_packaging_of_smokeless_tobacco_products_is_manda_a72505e7" VARCHAR  -- Plain Packaging Of Smokeless Tobacco Products Is Mandatory, Ie, The Use Of Logos Colours Brand Images Or Promotional Information On Packaging Other Than Brand Names And Product Names Displayed In A Standard Colour And Font Style Is Prohibited
);

CREATE TABLE owid_pneumococcal_conjugate_vaccines_pcv3_immunization_9f12318d (
  "year" INTEGER,
  "country" VARCHAR,
  "pneumococcal_conjugate_vaccines_pcv3_immunization_cove_0c35726a" INTEGER  -- Pneumococcal Conjugate Vaccines, Pcv3, Immunization Coverage Among 1 Year Olds, Pct,
  "pneumococcal_conjugate_vaccines_pcv3_immunization_cove_d32a06de" VARCHAR  -- Pneumococcal Conjugate Vaccines, Pcv3, Immunization Coverage Among 1 Year Olds, Pct Low,
  "pneumococcal_conjugate_vaccines_pcv3_immunization_cove_cf7143d6" VARCHAR  -- Pneumococcal Conjugate Vaccines, Pcv3, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_pneumococcal_conjugate_vaccines_pcv3_immunization_d18c369b (
  "year" INTEGER,
  "country" VARCHAR,
  "pneumococcal_conjugate_vaccines_pcv3_immunization_cove_0c35726a" INTEGER  -- Pneumococcal Conjugate Vaccines, Pcv3, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_point_prevalence_pct_alcohol_use_disorders_15plus_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "point_prevalence_pct_alcohol_use_disorders_15plus_years" FLOAT  -- Point Prevalence, Pct, Alcohol Use Disorders, 15plus Years
);

CREATE TABLE owid_point_prevalence_pct_alcohol_use_disorders_15plus_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "point_prevalence_pct_alcohol_use_disorders_15plus_years" FLOAT  -- Point Prevalence, Pct, Alcohol Use Disorders, 15plus Years,
  "point_prevalence_pct_alcohol_use_disorders_15plus_years_low" VARCHAR  -- Point Prevalence, Pct, Alcohol Use Disorders, 15plus Years Low,
  "point_prevalence_pct_alcohol_use_disorders_15plus_years_high" VARCHAR  -- Point Prevalence, Pct, Alcohol Use Disorders, 15plus Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_point_prevalence_pct_drug_use_disorders_15plus_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "point_prevalence_pct_drug_use_disorders_15plus_years" FLOAT  -- Point Prevalence, Pct, Drug Use Disorders, 15plus Years
);

CREATE TABLE owid_point_prevalence_pct_drug_use_disorders_15plus_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "point_prevalence_pct_drug_use_disorders_15plus_years" FLOAT  -- Point Prevalence, Pct, Drug Use Disorders, 15plus Years,
  "point_prevalence_pct_drug_use_disorders_15plus_years_low" VARCHAR  -- Point Prevalence, Pct, Drug Use Disorders, 15plus Years Low,
  "point_prevalence_pct_drug_use_disorders_15plus_years_high" VARCHAR  -- Point Prevalence, Pct, Drug Use Disorders, 15plus Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_points_of_entry (
  "year" INTEGER,
  "country" VARCHAR,
  "points_of_entry" INTEGER
);

CREATE TABLE owid_points_of_entry_spar (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "points_of_entry_spar" INTEGER  -- Points Of Entry, Spar
);

CREATE TABLE owid_policy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "policy" VARCHAR
);

CREATE TABLE owid_policy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "policy" VARCHAR,
  "policy_low" VARCHAR,
  "policy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_policy_documents_on_the_pharmacological_treatment_2ff2cb90 (
  "year" INTEGER,
  "country" VARCHAR,
  "policy_documents_on_the_pharmacological_treatment_of_s_2e7f1319" VARCHAR  -- Policy Documents On The Pharmacological Treatment Of Substance Use Disorders,
  "policy_documents_on_the_pharmacological_treatment_of_s_6b1fe0a1" VARCHAR  -- Policy Documents On The Pharmacological Treatment Of Substance Use Disorders Low,
  "policy_documents_on_the_pharmacological_treatment_of_s_88f7f115" VARCHAR  -- Policy Documents On The Pharmacological Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_policy_documents_on_the_pharmacological_treatment_bc0fbd9f (
  "year" INTEGER,
  "country" VARCHAR,
  "policy_documents_on_the_pharmacological_treatment_of_s_2e7f1319" VARCHAR  -- Policy Documents On The Pharmacological Treatment Of Substance Use Disorders
);

CREATE TABLE owid_policy_or_strategy_makes_specific_reference_tothe_510a92b8 (
  "year" INTEGER,
  "country" VARCHAR,
  "policy_or_strategy_makes_specific_reference_tothe_use__b1d06c03" VARCHAR  -- Policy Or Strategy Makes Specific Reference Tothe Use Of Social Media In The Health Domain
);