Global Health Observatory - World Health Organization

CREATE TABLE owid_incident_cases_of_gonorrhoea_in_individuals_in_thousands_2 (
  "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,
  "incident_cases_of_gonorrhoea_in_individuals_in_thousands_low" INTEGER  -- Incident Cases Of Gonorrhoea In Individuals, In Thousands Low,
  "incident_cases_of_gonorrhoea_in_individuals_in_thousands_high" UINTEGER  -- Incident Cases Of Gonorrhoea In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_gonorrhoea_in_individuals_per_1000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_gonorrhoea_in_individuals_per_1000" INTEGER  -- Incident Cases Of Gonorrhoea In Individuals, Per 1000
);

CREATE TABLE owid_incident_cases_of_gonorrhoea_in_individuals_per_1000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_gonorrhoea_in_individuals_per_1000" INTEGER  -- Incident Cases Of Gonorrhoea In Individuals, Per 1000,
  "incident_cases_of_gonorrhoea_in_individuals_per_1000_low" INTEGER  -- Incident Cases Of Gonorrhoea In Individuals, Per 1000 Low,
  "incident_cases_of_gonorrhoea_in_individuals_per_1000_high" INTEGER  -- Incident Cases Of Gonorrhoea In Individuals, Per 1000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_syphilis_in_individuals_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_syphilis_in_individuals_in_thousands" INTEGER  -- Incident Cases Of Syphilis In Individuals, In Thousands
);

CREATE TABLE owid_incident_cases_of_syphilis_in_individuals_in_thousands_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_syphilis_in_individuals_in_thousands" FLOAT  -- Incident Cases Of Syphilis In Individuals, In Thousands,
  "incident_cases_of_syphilis_in_individuals_in_thousands_low" FLOAT  -- Incident Cases Of Syphilis In Individuals, In Thousands Low,
  "incident_cases_of_syphilis_in_individuals_in_thousands_high" FLOAT  -- Incident Cases Of Syphilis In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_trichomoniasis_in_individuals_i_9528e415 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_trichomoniasis_in_individuals_in_thousands" UINTEGER  -- Incident Cases Of Trichomoniasis In Individuals, In Thousands,
  "incident_cases_of_trichomoniasis_in_individuals_in_tho_27b61ee3" INTEGER  -- Incident Cases Of Trichomoniasis In Individuals, In Thousands Low,
  "incident_cases_of_trichomoniasis_in_individuals_in_tho_78f1c850" UINTEGER  -- Incident Cases Of Trichomoniasis In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_cases_of_trichomoniasis_in_individuals_i_d63aac8f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_trichomoniasis_in_individuals_in_thousands" UINTEGER  -- Incident Cases Of Trichomoniasis In Individuals, In Thousands
);

CREATE TABLE owid_incident_cases_of_trichomoniasis_in_individuals_per_1000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_trichomoniasis_in_individuals_per_1000" INTEGER  -- Incident Cases Of Trichomoniasis In Individuals, Per 1000
);

CREATE TABLE owid_incident_cases_of_trichomoniasis_in_individuals_per_1000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_cases_of_trichomoniasis_in_individuals_per_1000" INTEGER  -- Incident Cases Of Trichomoniasis In Individuals, Per 1000,
  "incident_cases_of_trichomoniasis_in_individuals_per_1000_low" INTEGER  -- Incident Cases Of Trichomoniasis In Individuals, Per 1000 Low,
  "incident_cases_of_trichomoniasis_in_individuals_per_1000_high" INTEGER  -- Incident Cases Of Trichomoniasis In Individuals, Per 1000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_incident_rate_of_active_syphilis_per_1000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_rate_of_active_syphilis_per_1000" FLOAT  -- Incident Rate Of Active Syphilis, Per 1000
);

CREATE TABLE owid_incident_rate_of_active_syphilis_per_1000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "incident_rate_of_active_syphilis_per_1000" FLOAT  -- Incident Rate Of Active Syphilis, Per 1000,
  "incident_rate_of_active_syphilis_per_1000_low" FLOAT  -- Incident Rate Of Active Syphilis, Per 1000 Low,
  "incident_rate_of_active_syphilis_per_1000_high" FLOAT  -- Incident Rate Of Active Syphilis, Per 1000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_12da53fa (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_71d1936e" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Specialists
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_29223ee3 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_4915f8b2" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Personal Support Workers
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_3e887608 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_a9568ef5" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Pharmaceutical Personnel,
  "inclusion_of_basic_dementia_competencies_in_training_o_4155f87d" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Pharmaceutical Personnel Low,
  "inclusion_of_basic_dementia_competencies_in_training_o_66d96f01" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Pharmaceutical Personnel High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_47848d66 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_873fa26f" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Social Workers
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_5498771e (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_0ce9c14a" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Physicians,
  "inclusion_of_basic_dementia_competencies_in_training_o_af82a360" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Physicians Low,
  "inclusion_of_basic_dementia_competencies_in_training_o_4b13ec23" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Physicians High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_653f0ffd (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_of_nurses" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_6e5224f4" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Nurses Low,
  "inclusion_of_basic_dementia_competencies_in_training_o_9ed2a50f" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Nurses High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_791f43f4 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_71d1936e" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Specialists,
  "inclusion_of_basic_dementia_competencies_in_training_o_40e01ed7" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Specialists Low,
  "inclusion_of_basic_dementia_competencies_in_training_o_d070e12f" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Specialists High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_99577240 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_4915f8b2" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Personal Support Workers,
  "inclusion_of_basic_dementia_competencies_in_training_o_fb50f1c5" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Personal Support Workers Low,
  "inclusion_of_basic_dementia_competencies_in_training_o_cd268a61" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Personal Support Workers High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_b1853f64 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_of_nurses" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_c82bbee8 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_873fa26f" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Social Workers,
  "inclusion_of_basic_dementia_competencies_in_training_o_390f5702" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Social Workers Low,
  "inclusion_of_basic_dementia_competencies_in_training_o_521a76d9" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Social Workers High,
  "comments" VARCHAR
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_e5e18916 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_a9568ef5" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Pharmaceutical Personnel
);

CREATE TABLE owid_inclusion_of_basic_dementia_competencies_in_train_eac52cab (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_basic_dementia_competencies_in_training_o_0ce9c14a" VARCHAR  -- Inclusion Of Basic Dementia Competencies In Training Of Physicians
);

CREATE TABLE owid_inclusion_of_dementia_diagnosis_care_and_support__4e5f77e8 (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_dementia_diagnosis_care_and_support_as_a__e0a95e25" VARCHAR  -- Inclusion Of Dementia Diagnosis, Care And Support As A Specific Action Of The Dementia Plan
);

CREATE TABLE owid_inclusion_of_dementia_diagnosis_care_and_support__dd03aecb (
  "year" INTEGER,
  "country" VARCHAR,
  "inclusion_of_dementia_diagnosis_care_and_support_as_a__e0a95e25" VARCHAR  -- Inclusion Of Dementia Diagnosis, Care And Support As A Specific Action Of The Dementia Plan,
  "inclusion_of_dementia_diagnosis_care_and_support_as_a__1604ecbd" VARCHAR  -- Inclusion Of Dementia Diagnosis, Care And Support As A Specific Action Of The Dementia Plan Low,
  "inclusion_of_dementia_diagnosis_care_and_support_as_a__702b1682" VARCHAR  -- Inclusion Of Dementia Diagnosis, Care And Support As A Specific Action Of The Dementia Plan High,
  "comments" VARCHAR
);