Global Health Observatory - World Health Organization

CREATE TABLE owid_number_of_investigational_pharmaceutical_trials_f_342270cd (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_investigational_pharmaceutical_trials_for_dementia" INTEGER
);

CREATE TABLE owid_number_of_investigational_pharmaceutical_trials_f_6ee2a572 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_investigational_pharmaceutical_trials_for_dementia" INTEGER,
  "number_of_investigational_pharmaceutical_trials_for_de_952b9db7" VARCHAR  -- Number Of Investigational Pharmaceutical Trials For Dementia Low,
  "number_of_investigational_pharmaceutical_trials_for_de_f86c38b6" VARCHAR  -- Number Of Investigational Pharmaceutical Trials For Dementia High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_azithromycin_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_azithromycin" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_azithromycin_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_azithromycin" INTEGER,
  "number_of_isolates_tested_for_azithromycin_low" VARCHAR,
  "number_of_isolates_tested_for_azithromycin_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_cefixime_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_cefixime" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_cefixime_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_cefixime" INTEGER,
  "number_of_isolates_tested_for_cefixime_low" VARCHAR,
  "number_of_isolates_tested_for_cefixime_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_ceftriaxone_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_ceftriaxone" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_ceftriaxone_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_ceftriaxone" INTEGER,
  "number_of_isolates_tested_for_ceftriaxone_low" VARCHAR,
  "number_of_isolates_tested_for_ceftriaxone_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_ciprofloxacin_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_ciprofloxacin" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_ciprofloxacin_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_ciprofloxacin" INTEGER,
  "number_of_isolates_tested_for_ciprofloxacin_low" VARCHAR,
  "number_of_isolates_tested_for_ciprofloxacin_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_extended_spectrum_c_4502fd70 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_extended_spectrum_cephalosporins" INTEGER,
  "number_of_isolates_tested_for_extended_spectrum_cephal_6c1c2115" VARCHAR  -- Number Of Isolates Tested For Extended Spectrum Cephalosporins Low,
  "number_of_isolates_tested_for_extended_spectrum_cephal_fbcfcbe9" VARCHAR  -- Number Of Isolates Tested For Extended Spectrum Cephalosporins High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_isolates_tested_for_extended_spectrum_c_a7cc9bcc (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_isolates_tested_for_extended_spectrum_cephalosporins" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_labour_days_needed_to_buy_annual_supply_57706e48 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_labour_days_needed_to_buy_annual_supply_of_f_4ac79800" FLOAT  -- Number Of Labour Days Needed To Buy Annual Supply Of Fluoride Toothpaste Per Person
);

CREATE TABLE owid_number_of_labour_days_needed_to_buy_annual_supply_db5af331 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_labour_days_needed_to_buy_annual_supply_of_f_4ac79800" FLOAT  -- Number Of Labour Days Needed To Buy Annual Supply Of Fluoride Toothpaste Per Person,
  "number_of_labour_days_needed_to_buy_annual_supply_of_f_490245c7" VARCHAR  -- Number Of Labour Days Needed To Buy Annual Supply Of Fluoride Toothpaste Per Person Low,
  "number_of_labour_days_needed_to_buy_annual_supply_of_f_fed71f5b" VARCHAR  -- Number Of Labour Days Needed To Buy Annual Supply Of Fluoride Toothpaste Per Person High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_leprosy_cases_registered_for_treatment__468ad037 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_leprosy_cases_registered_for_treatment_prevalence" UINTEGER  -- Number Of Leprosy Cases Registered For Treatment, Prevalence
);

CREATE TABLE owid_number_of_leprosy_cases_registered_for_treatment__ffc55a68 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_leprosy_cases_registered_for_treatment_prevalence" UINTEGER  -- Number Of Leprosy Cases Registered For Treatment, Prevalence,
  "number_of_leprosy_cases_registered_for_treatment_prevalence_low" VARCHAR  -- Number Of Leprosy Cases Registered For Treatment, Prevalence Low,
  "number_of_leprosy_cases_registered_for_treatment_preva_6c107200" VARCHAR  -- Number Of Leprosy Cases Registered For Treatment, Prevalence High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_licensed_qualified_anaesthesiologists_a_0e3327ba (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_licensed_qualified_anaesthesiologists_active_8346c105" UINTEGER  -- Number Of Licensed Qualified Anaesthesiologists Actively Working,
  "number_of_licensed_qualified_anaesthesiologists_active_0c21a972" VARCHAR  -- Number Of Licensed Qualified Anaesthesiologists Actively Working Low,
  "number_of_licensed_qualified_anaesthesiologists_active_db30687a" VARCHAR  -- Number Of Licensed Qualified Anaesthesiologists Actively Working High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_licensed_qualified_anaesthesiologists_a_8be22c1a (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_licensed_qualified_anaesthesiologists_active_8346c105" UINTEGER  -- Number Of Licensed Qualified Anaesthesiologists Actively Working
);

CREATE TABLE owid_number_of_licensed_qualified_obstetricians_active_181462ad (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_licensed_qualified_obstetricians_actively_working" INTEGER
);

CREATE TABLE owid_number_of_licensed_qualified_obstetricians_active_8c147d3f (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_licensed_qualified_obstetricians_actively_working" INTEGER,
  "number_of_licensed_qualified_obstetricians_actively_working_low" VARCHAR,
  "number_of_licensed_qualified_obstetricians_actively_wo_2dd02732" VARCHAR  -- Number Of Licensed Qualified Obstetricians Actively Working High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_licensed_qualified_surgeons_actively_working_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_licensed_qualified_surgeons_actively_working" UINTEGER
);

CREATE TABLE owid_number_of_licensed_qualified_surgeons_actively_working_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_licensed_qualified_surgeons_actively_working" UINTEGER,
  "number_of_licensed_qualified_surgeons_actively_working_low" VARCHAR,
  "number_of_licensed_qualified_surgeons_actively_working_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_local_clinical_laboratories_supporting__c9218a89 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_local_clinical_laboratories_supporting_natio_eec449e6" INTEGER  -- Number Of Local Clinical Laboratories Supporting National Amr Surveillance Sites
);

CREATE TABLE owid_number_of_local_clinical_laboratories_supporting__e346b89f (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_local_clinical_laboratories_supporting_natio_eec449e6" INTEGER  -- Number Of Local Clinical Laboratories Supporting National Amr Surveillance Sites,
  "number_of_local_clinical_laboratories_supporting_natio_ca43e668" VARCHAR  -- Number Of Local Clinical Laboratories Supporting National Amr Surveillance Sites Low,
  "number_of_local_clinical_laboratories_supporting_natio_ae4de805" VARCHAR  -- Number Of Local Clinical Laboratories Supporting National Amr Surveillance Sites High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_malaria_cases_treated_with_any_first_li_2d151314 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_malaria_cases_treated_with_any_first_line_tx_088a9a17" UINTEGER  -- Number Of Malaria Cases Treated With Any First, Line Tx Courses, Including Artemisinin Based Combination Therapies, Acts
);