Global Health Observatory - World Health Organization

CREATE TABLE owid_general_availability_of_urine_strips_for_glucose__43129c4a (
  "year" INTEGER,
  "country" VARCHAR,
  "general_availability_of_urine_strips_for_glucose_and_k_f478ee6f" VARCHAR  -- General Availability Of Urine Strips For Glucose And Ketone Measurement At The Primary Health Care Level
);

CREATE TABLE owid_general_availability_of_urine_strips_for_glucose__5f7dc4e7 (
  "year" INTEGER,
  "country" VARCHAR,
  "general_availability_of_urine_strips_for_glucose_and_k_f478ee6f" VARCHAR  -- General Availability Of Urine Strips For Glucose And Ketone Measurement At The Primary Health Care Level,
  "general_availability_of_urine_strips_for_glucose_and_k_ee50f101" VARCHAR  -- General Availability Of Urine Strips For Glucose And Ketone Measurement At The Primary Health Care Level Low,
  "general_availability_of_urine_strips_for_glucose_and_k_48cd7be1" VARCHAR  -- General Availability Of Urine Strips For Glucose And Ketone Measurement At The Primary Health Care Level High,
  "comments" VARCHAR
);

CREATE TABLE owid_general_availability_of_urine_testing_for_albumin_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "general_availability_of_urine_testing_for_albumin" VARCHAR
);

CREATE TABLE owid_general_availability_of_urine_testing_for_albumin_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "general_availability_of_urine_testing_for_albumin" VARCHAR,
  "general_availability_of_urine_testing_for_albumin_low" VARCHAR,
  "general_availability_of_urine_testing_for_albumin_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_generalist_medical_practitioners_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "generalist_medical_practitioners_number" UINTEGER  -- Generalist Medical Practitioners, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_generalist_medical_practitioners_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "generalist_medical_practitioners_number" UINTEGER  -- Generalist Medical Practitioners, Number,
  "generalist_medical_practitioners_number_low" VARCHAR  -- Generalist Medical Practitioners, Number Low,
  "generalist_medical_practitioners_number_high" VARCHAR  -- Generalist Medical Practitioners, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_geriatric_specific_hospital_beds_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "geriatric_specific_hospital_beds_per_10_000_population" UINTEGER  -- Geriatric Specific Hospital Beds, Per 10–000 Population
);

CREATE TABLE owid_geriatric_specific_hospital_beds_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "geriatric_specific_hospital_beds_per_10_000_population" UINTEGER  -- Geriatric Specific Hospital Beds, Per 10–000 Population,
  "geriatric_specific_hospital_beds_per_10_000_population_low" VARCHAR  -- Geriatric Specific Hospital Beds, Per 10–000 Population Low,
  "geriatric_specific_hospital_beds_per_10_000_population_high" VARCHAR  -- Geriatric Specific Hospital Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_glass_pathogens_testing_covered_by_external_quali_321fa9e0 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "glass_pathogens_testing_covered_by_external_quality_as_bae13e1f" INTEGER  -- Glass Pathogens Testing Covered By External Quality Assessment, Eqa,
  "glass_pathogens_testing_covered_by_external_quality_as_64dccc53" VARCHAR  -- Glass Pathogens Testing Covered By External Quality Assessment, Eqa Low,
  "glass_pathogens_testing_covered_by_external_quality_as_77af6987" VARCHAR  -- Glass Pathogens Testing Covered By External Quality Assessment, Eqa High,
  "comments" VARCHAR
);

CREATE TABLE owid_glass_pathogens_testing_covered_by_external_quali_4588474f (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "glass_pathogens_testing_covered_by_external_quality_as_bae13e1f" INTEGER  -- Glass Pathogens Testing Covered By External Quality Assessment, Eqa
);

CREATE TABLE owid_governement_benefits_for_persons_with_substance_u_99a9cde2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "governement_benefits_for_persons_with_substance_use_disorders" VARCHAR
);

CREATE TABLE owid_governement_benefits_for_persons_with_substance_u_ecfebbd1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "governement_benefits_for_persons_with_substance_use_disorders" VARCHAR,
  "governement_benefits_for_persons_with_substance_use_di_7af93192" VARCHAR  -- Governement Benefits For Persons With Substance Use Disorders Low,
  "governement_benefits_for_persons_with_substance_use_di_50382ed7" VARCHAR  -- Governement Benefits For Persons With Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_government_benefits_for_alcohol_use_disorders_sub_3d97b225 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_alcohol_use_disorders_subsidy__7e63c36b" VARCHAR  -- Government Benefits For Alcohol Use Disorders, Subsidy Or Disability Pension
);

CREATE TABLE owid_government_benefits_for_alcohol_use_disorders_sub_a57305ec (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_alcohol_use_disorders_subsidy__7e63c36b" VARCHAR  -- Government Benefits For Alcohol Use Disorders, Subsidy Or Disability Pension,
  "government_benefits_for_alcohol_use_disorders_subsidy__5215a1a5" VARCHAR  -- Government Benefits For Alcohol Use Disorders, Subsidy Or Disability Pension Low,
  "government_benefits_for_alcohol_use_disorders_subsidy__ed2fe5a4" VARCHAR  -- Government Benefits For Alcohol Use Disorders, Subsidy Or Disability Pension High,
  "comments" VARCHAR
);

CREATE TABLE owid_government_benefits_for_drug_use_disorders_subsid_2129d43c (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_drug_use_disorders_subsidy_or__8b3e0f0c" VARCHAR  -- Government Benefits For Drug Use Disorders, Subsidy Or Disability Pension,
  "government_benefits_for_drug_use_disorders_subsidy_or__162b949a" VARCHAR  -- Government Benefits For Drug Use Disorders, Subsidy Or Disability Pension Low,
  "government_benefits_for_drug_use_disorders_subsidy_or__febeae32" VARCHAR  -- Government Benefits For Drug Use Disorders, Subsidy Or Disability Pension High,
  "comments" VARCHAR
);

CREATE TABLE owid_government_benefits_for_drug_use_disorders_subsid_86f52c85 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_drug_use_disorders_subsidy_or__8b3e0f0c" VARCHAR  -- Government Benefits For Drug Use Disorders, Subsidy Or Disability Pension
);

CREATE TABLE owid_government_benefits_for_people_with_alcohol_use_d_6d8cdd9d (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_people_with_alcohol_use_disorders" VARCHAR,
  "government_benefits_for_people_with_alcohol_use_disorders_low" VARCHAR,
  "government_benefits_for_people_with_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_government_benefits_for_people_with_alcohol_use_d_83bc9dcf (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_people_with_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_government_benefits_for_people_with_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_people_with_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_government_benefits_for_people_with_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_government_benefits" VARCHAR,
  "government_benefits_for_people_with_drug_use_disorders" VARCHAR,
  "government_benefits_for_people_with_drug_use_disorders_low" VARCHAR,
  "government_benefits_for_people_with_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_government_expenditures_on_mental_health_as_a_per_4a6bda90 (
  "year" INTEGER,
  "country" VARCHAR,
  "government_expenditures_on_mental_health_as_a_percenta_86d56118" FLOAT  -- Government Expenditures On Mental Health As A Percentage Of Total Government Expenditures On Health, Pct,
  "government_expenditures_on_mental_health_as_a_percenta_0f84e267" VARCHAR  -- Government Expenditures On Mental Health As A Percentage Of Total Government Expenditures On Health, Pct Low,
  "government_expenditures_on_mental_health_as_a_percenta_96efdec7" VARCHAR  -- Government Expenditures On Mental Health As A Percentage Of Total Government Expenditures On Health, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_government_expenditures_on_mental_health_as_a_per_ba1ccdba (
  "year" INTEGER,
  "country" VARCHAR,
  "government_expenditures_on_mental_health_as_a_percenta_86d56118" FLOAT  -- Government Expenditures On Mental Health As A Percentage Of Total Government Expenditures On Health, Pct
);

CREATE TABLE owid_government_expenditures_on_mental_hospitals_as_a__e2863259 (
  "year" INTEGER,
  "country" VARCHAR,
  "government_expenditures_on_mental_hospitals_as_a_perce_b3835a1c" FLOAT  -- Government Expenditures On Mental Hospitals As A Percentage Of Total Government Expenditures On Mental Health, Pct
);

CREATE TABLE owid_government_expenditures_on_mental_hospitals_as_a__e39d07bd (
  "year" INTEGER,
  "country" VARCHAR,
  "government_expenditures_on_mental_hospitals_as_a_perce_b3835a1c" FLOAT  -- Government Expenditures On Mental Hospitals As A Percentage Of Total Government Expenditures On Mental Health, Pct,
  "government_expenditures_on_mental_hospitals_as_a_perce_e169010e" VARCHAR  -- Government Expenditures On Mental Hospitals As A Percentage Of Total Government Expenditures On Mental Health, Pct Low,
  "government_expenditures_on_mental_hospitals_as_a_perce_46933ada" VARCHAR  -- Government Expenditures On Mental Hospitals As A Percentage Of Total Government Expenditures On Mental Health, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_government_monopoly_on_production_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "government_monopoly_on_production" VARCHAR
);