Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_percent_of_all_dalys_attributable_to_alcohol (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"percent_of_all_dalys_attributable_to_alcohol" FLOAT,
"percent_of_all_dalys_attributable_to_alcohol_low" FLOAT,
"percent_of_all_dalys_attributable_to_alcohol_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_persistence_to_last_grade_of_primary_pct_of_cohort_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"persistence_to_last_grade_of_primary_pct_of_cohort" FLOAT -- Persistence To Last Grade Of Primary, Pct Of Cohort
);
CREATE TABLE owid_persistence_to_last_grade_of_primary_pct_of_cohort_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"persistence_to_last_grade_of_primary_pct_of_cohort" FLOAT -- Persistence To Last Grade Of Primary, Pct Of Cohort,
"persistence_to_last_grade_of_primary_pct_of_cohort_low" VARCHAR -- Persistence To Last Grade Of Primary, Pct Of Cohort Low,
"persistence_to_last_grade_of_primary_pct_of_cohort_high" VARCHAR -- Persistence To Last Grade Of Primary, Pct Of Cohort High,
"comments" VARCHAR
);
CREATE TABLE owid_persons_with_alcohol_use_disorders_receiving_trea_2e612ea8 (
"year" INTEGER,
"country" VARCHAR,
"persons_with_alcohol_use_disorders_receiving_treatment_pct" FLOAT -- Persons With Alcohol Use Disorders Receiving Treatment, Pct
);
CREATE TABLE owid_persons_with_alcohol_use_disorders_receiving_trea_379eb4cd (
"year" INTEGER,
"country" VARCHAR,
"persons_with_alcohol_use_disorders_receiving_treatment_pct" FLOAT -- Persons With Alcohol Use Disorders Receiving Treatment, Pct,
"persons_with_alcohol_use_disorders_receiving_treatment_pct_low" VARCHAR -- Persons With Alcohol Use Disorders Receiving Treatment, Pct Low,
"persons_with_alcohol_use_disorders_receiving_treatment_pct_high" VARCHAR -- Persons With Alcohol Use Disorders Receiving Treatment, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_pertussis_number_of_reported_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"pertussis_number_of_reported_cases" UINTEGER -- Pertussis, Number Of Reported Cases
);
CREATE TABLE owid_pertussis_number_of_reported_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"pertussis_number_of_reported_cases" UINTEGER -- Pertussis, Number Of Reported Cases,
"pertussis_number_of_reported_cases_low" VARCHAR -- Pertussis, Number Of Reported Cases Low,
"pertussis_number_of_reported_cases_high" VARCHAR -- Pertussis, Number Of Reported Cases High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmaceutical_technicians_and_assistants_number_1 (
"year" INTEGER,
"country" VARCHAR,
"pharmaceutical_technicians_and_assistants_number" UINTEGER -- Pharmaceutical Technicians And Assistants, Number,
"comments" VARCHAR
);
CREATE TABLE owid_pharmaceutical_technicians_and_assistants_number_2 (
"year" INTEGER,
"country" VARCHAR,
"pharmaceutical_technicians_and_assistants_number" UINTEGER -- Pharmaceutical Technicians And Assistants, Number,
"pharmaceutical_technicians_and_assistants_number_low" VARCHAR -- Pharmaceutical Technicians And Assistants, Number Low,
"pharmaceutical_technicians_and_assistants_number_high" VARCHAR -- Pharmaceutical Technicians And Assistants, Number High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacists_number_1 (
"year" INTEGER,
"country" VARCHAR,
"pharmacists_number" UINTEGER -- Pharmacists, Number,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacists_number_2 (
"year" INTEGER,
"country" VARCHAR,
"pharmacists_number" UINTEGER -- Pharmacists, Number,
"pharmacists_number_low" VARCHAR -- Pharmacists, Number Low,
"pharmacists_number_high" VARCHAR -- Pharmacists, Number High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacists_per_10_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"pharmacists_per_10_000_population" FLOAT -- Pharmacists, Per 10–000 Population,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacists_per_10_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"pharmacists_per_10_000_population" FLOAT -- Pharmacists, Per 10–000 Population,
"pharmacists_per_10_000_population_low" VARCHAR -- Pharmacists, Per 10–000 Population Low,
"pharmacists_per_10_000_population_high" VARCHAR -- Pharmacists, Per 10–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_used_for_the_management_of_alcoho_0bdb81f2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"pharmacotherapy_used_for_the_management_of_alcohol_withdrawal" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_used_for_the_management_of_alcoho_8aa92811 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"pharmacotherapy_used_for_the_management_of_alcohol_withdrawal" VARCHAR,
"pharmacotherapy_used_for_the_management_of_alcohol_wit_2ab1b631" VARCHAR -- Pharmacotherapy Used For The Management Of Alcohol Withdrawal Low,
"pharmacotherapy_used_for_the_management_of_alcohol_wit_cf460a7b" VARCHAR -- Pharmacotherapy Used For The Management Of Alcohol Withdrawal High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_used_for_the_management_of_benzod_302d2010 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"pharmacotherapy_used_for_the_management_of_benzodiazep_2fb77583" VARCHAR -- Pharmacotherapy Used For The Management Of Benzodiazepine Withdrawal
);
CREATE TABLE owid_pharmacotherapy_used_for_the_management_of_benzod_3b0a4b06 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"pharmacotherapy_used_for_the_management_of_benzodiazep_2fb77583" VARCHAR -- Pharmacotherapy Used For The Management Of Benzodiazepine Withdrawal,
"pharmacotherapy_used_for_the_management_of_benzodiazep_f1e6c7de" VARCHAR -- Pharmacotherapy Used For The Management Of Benzodiazepine Withdrawal Low,
"pharmacotherapy_used_for_the_management_of_benzodiazep_6016c73b" VARCHAR -- Pharmacotherapy Used For The Management Of Benzodiazepine Withdrawal High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_used_for_the_management_of_cannab_c248e71a (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"pharmacotherapy_used_for_the_management_of_cannabis_withdrawal" VARCHAR,
"pharmacotherapy_used_for_the_management_of_cannabis_wi_cfaa0bd4" VARCHAR -- Pharmacotherapy Used For The Management Of Cannabis Withdrawal Low,
"pharmacotherapy_used_for_the_management_of_cannabis_wi_2ef1b572" VARCHAR -- Pharmacotherapy Used For The Management Of Cannabis Withdrawal High,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_used_for_the_management_of_cannab_dd871833 (
"year" INTEGER,
"country" VARCHAR,
"rsud_drugs" VARCHAR,
"pharmacotherapy_used_for_the_management_of_cannabis_withdrawal" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_with_buprenorphine_1 (
"year" INTEGER,
"country" VARCHAR,
"pharmacotherapy_options" VARCHAR,
"pharmacotherapy_with_buprenorphine" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_with_buprenorphine_2 (
"year" INTEGER,
"country" VARCHAR,
"pharmacotherapy_options" VARCHAR,
"pharmacotherapy_with_buprenorphine" VARCHAR,
"pharmacotherapy_with_buprenorphine_low" VARCHAR,
"pharmacotherapy_with_buprenorphine_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_with_buprenorphine_naloxone_1 (
"year" INTEGER,
"country" VARCHAR,
"pharmacotherapy_options" VARCHAR,
"pharmacotherapy_with_buprenorphine_naloxone" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_with_buprenorphine_naloxone_2 (
"year" INTEGER,
"country" VARCHAR,
"pharmacotherapy_options" VARCHAR,
"pharmacotherapy_with_buprenorphine_naloxone" VARCHAR,
"pharmacotherapy_with_buprenorphine_naloxone_low" VARCHAR,
"pharmacotherapy_with_buprenorphine_naloxone_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_with_methadone_1 (
"year" INTEGER,
"country" VARCHAR,
"pharmacotherapy_options" VARCHAR,
"pharmacotherapy_with_methadone" VARCHAR
);
CREATE TABLE owid_pharmacotherapy_with_methadone_2 (
"year" INTEGER,
"country" VARCHAR,
"pharmacotherapy_options" VARCHAR,
"pharmacotherapy_with_methadone" VARCHAR,
"pharmacotherapy_with_methadone_low" VARCHAR,
"pharmacotherapy_with_methadone_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.