Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_laboratories_providing_tuberculosis_diagnostic_se_dd747a49 (
"year" INTEGER,
"country" VARCHAR,
"laboratories_providing_tuberculosis_diagnostic_service_dde4e51a" FLOAT -- Laboratories Providing Tuberculosis Diagnostic Services Using Sputum Smear Microscopy, Per 100–000 Population
);
CREATE TABLE owid_laboratory (
"year" INTEGER,
"country" VARCHAR,
"laboratory" INTEGER
);
CREATE TABLE owid_laboratory_spar (
"year" INTEGER,
"country" VARCHAR,
"ihr_spar_capacity_level" VARCHAR,
"laboratory_spar" INTEGER -- Laboratory, Spar
);
CREATE TABLE owid_lack_of_capacity_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_capacity" VARCHAR
);
CREATE TABLE owid_lack_of_capacity_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_capacity" VARCHAR,
"lack_of_capacity_low" VARCHAR,
"lack_of_capacity_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_capacity_for_ehr_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_capacity_for_ehr" VARCHAR -- Lack Of Capacity, For Ehr
);
CREATE TABLE owid_lack_of_capacity_for_ehr_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_capacity_for_ehr" VARCHAR -- Lack Of Capacity, For Ehr,
"lack_of_capacity_for_ehr_low" VARCHAR -- Lack Of Capacity, For Ehr Low,
"lack_of_capacity_for_ehr_high" VARCHAR -- Lack Of Capacity, For Ehr High,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_demand_by_health_professionals_and_patients_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_demand_by_health_professionals_and_patients" VARCHAR
);
CREATE TABLE owid_lack_of_demand_by_health_professionals_and_patients_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_demand_by_health_professionals_and_patients" VARCHAR,
"lack_of_demand_by_health_professionals_and_patients_low" VARCHAR,
"lack_of_demand_by_health_professionals_and_patients_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_demand_for_elearning_programmes_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_demand_for_elearning_programmes" VARCHAR
);
CREATE TABLE owid_lack_of_demand_for_elearning_programmes_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_demand_for_elearning_programmes" VARCHAR,
"lack_of_demand_for_elearning_programmes_low" VARCHAR,
"lack_of_demand_for_elearning_programmes_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_over_cost_effectiveness_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_over_cost_effectiveness" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_over_cost_effectiveness_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_over_cost_effectiveness" VARCHAR,
"lack_of_evidence_over_cost_effectiveness_low" VARCHAR,
"lack_of_evidence_over_cost_effectiveness_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_showing_cost_effectiveness_or_ehr_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_showing_cost_effectiveness_or_ehr" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_showing_cost_effectiveness_or_ehr_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_showing_cost_effectiveness_or_ehr" VARCHAR,
"lack_of_evidence_showing_cost_effectiveness_or_ehr_low" VARCHAR,
"lack_of_evidence_showing_cost_effectiveness_or_ehr_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_showing_effectiveness_of_ehr_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_showing_effectiveness_of_ehr" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_showing_effectiveness_of_ehr_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_showing_effectiveness_of_ehr" VARCHAR,
"lack_of_evidence_showing_effectiveness_of_ehr_low" VARCHAR,
"lack_of_evidence_showing_effectiveness_of_ehr_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_that_elearning_is_effective_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_that_elearning_is_effective" VARCHAR
);
CREATE TABLE owid_lack_of_evidence_that_elearning_is_effective_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_evidence_that_elearning_is_effective" VARCHAR,
"lack_of_evidence_that_elearning_is_effective_low" VARCHAR,
"lack_of_evidence_that_elearning_is_effective_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_funding_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_funding" VARCHAR
);
CREATE TABLE owid_lack_of_funding_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_funding" VARCHAR,
"lack_of_funding_low" VARCHAR,
"lack_of_funding_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_funding_for_ehr_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_funding_for_ehr" VARCHAR -- Lack Of Funding, For Ehr
);
CREATE TABLE owid_lack_of_funding_for_ehr_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_funding_for_ehr" VARCHAR -- Lack Of Funding, For Ehr,
"lack_of_funding_for_ehr_low" VARCHAR -- Lack Of Funding, For Ehr Low,
"lack_of_funding_for_ehr_high" VARCHAR -- Lack Of Funding, For Ehr High,
"comments" VARCHAR
);
CREATE TABLE owid_lack_of_infrastructure_1 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_infrastructure" VARCHAR
);
CREATE TABLE owid_lack_of_infrastructure_2 (
"year" INTEGER,
"country" VARCHAR,
"goe_question" VARCHAR,
"lack_of_infrastructure" VARCHAR,
"lack_of_infrastructure_low" VARCHAR,
"lack_of_infrastructure_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.