Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_total_density_per_100_000_population_hospitals_2 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_100_000_population_hospitals" FLOAT -- Total Density Per 100–000 Population, Hospitals,
"total_density_per_100_000_population_hospitals_low" VARCHAR -- Total Density Per 100–000 Population, Hospitals Low,
"total_density_per_100_000_population_hospitals_high" VARCHAR -- Total Density Per 100–000 Population, Hospitals High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_100_000_population_provincial_h_58128d20 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_100_000_population_provincial_hospitals" FLOAT -- Total Density Per 100–000 Population, Provincial Hospitals,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_100_000_population_provincial_h_c1adbc6b (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_100_000_population_provincial_hospitals" FLOAT -- Total Density Per 100–000 Population, Provincial Hospitals,
"total_density_per_100_000_population_provincial_hospitals_low" VARCHAR -- Total Density Per 100–000 Population, Provincial Hospitals Low,
"total_density_per_100_000_population_provincial_hospitals_high" VARCHAR -- Total Density Per 100–000 Population, Provincial Hospitals High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_100_000_population_specialized__31bcccab (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_100_000_population_specialized_hospitals" FLOAT -- Total Density Per 100–000 Population, Specialized Hospitals,
"total_density_per_100_000_population_specialized_hospitals_low" VARCHAR -- Total Density Per 100–000 Population, Specialized Hospitals Low,
"total_density_per_100_000_population_specialized_hospitals_high" VARCHAR -- Total Density Per 100–000 Population, Specialized Hospitals High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_100_000_population_specialized__af2fb37e (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_100_000_population_specialized_hospitals" FLOAT -- Total Density Per 100–000 Population, Specialized Hospitals,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_females_aged_from_50_to_b792979d (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_females_aged_from_50_to_69_y_1026df5d" FLOAT -- Total Density Per Million Females Aged From 50 To 69 Years Old, Mammography Units,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_females_aged_from_50_to_e69d99bd (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_females_aged_from_50_to_69_y_1026df5d" FLOAT -- Total Density Per Million Females Aged From 50 To 69 Years Old, Mammography Units,
"total_density_per_million_females_aged_from_50_to_69_y_8fd50309" VARCHAR -- Total Density Per Million Females Aged From 50 To 69 Years Old, Mammography Units Low,
"total_density_per_million_females_aged_from_50_to_69_y_98cfb05e" VARCHAR -- Total Density Per Million Females Aged From 50 To 69 Years Old, Mammography Units High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_computed_tom_36744536 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_computed_tomography_units" FLOAT -- Total Density Per Million Population, Computed Tomography Units,
"total_density_per_million_population_computed_tomograp_36e0ee43" VARCHAR -- Total Density Per Million Population, Computed Tomography Units Low,
"total_density_per_million_population_computed_tomograp_3d208441" VARCHAR -- Total Density Per Million Population, Computed Tomography Units High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_computed_tom_c7218574 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_computed_tomography_units" FLOAT -- Total Density Per Million Population, Computed Tomography Units,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_gamma_camera_4c9cf121 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_gamma_camera_or_n_5b83f318" FLOAT -- Total Density Per Million Population, Gamma Camera Or Nuclear Medicine,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_gamma_camera_a40019b9 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_gamma_camera_or_n_5b83f318" FLOAT -- Total Density Per Million Population, Gamma Camera Or Nuclear Medicine,
"total_density_per_million_population_gamma_camera_or_n_44017132" VARCHAR -- Total Density Per Million Population, Gamma Camera Or Nuclear Medicine Low,
"total_density_per_million_population_gamma_camera_or_n_2aa3cff7" VARCHAR -- Total Density Per Million Population, Gamma Camera Or Nuclear Medicine High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_linear_accelerator_1 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_linear_accelerator" FLOAT -- Total Density Per Million Population, Linear Accelerator,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_linear_accelerator_2 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_linear_accelerator" FLOAT -- Total Density Per Million Population, Linear Accelerator,
"total_density_per_million_population_linear_accelerator_low" VARCHAR -- Total Density Per Million Population, Linear Accelerator Low,
"total_density_per_million_population_linear_accelerator_high" VARCHAR -- Total Density Per Million Population, Linear Accelerator High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_magnetic_res_2f1759f3 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_magnetic_resonance_imaging" FLOAT -- Total Density Per Million Population, Magnetic Resonance Imaging,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_magnetic_res_869f008d (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_magnetic_resonance_imaging" FLOAT -- Total Density Per Million Population, Magnetic Resonance Imaging,
"total_density_per_million_population_magnetic_resonanc_953e1c4c" VARCHAR -- Total Density Per Million Population, Magnetic Resonance Imaging Low,
"total_density_per_million_population_magnetic_resonanc_be1e5340" VARCHAR -- Total Density Per Million Population, Magnetic Resonance Imaging High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_positron_emi_3fce5d44 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_positron_emission_09f2dd0c" FLOAT -- Total Density Per Million Population, Positron Emission Tomography,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_positron_emi_5bc5042d (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_positron_emission_09f2dd0c" FLOAT -- Total Density Per Million Population, Positron Emission Tomography,
"total_density_per_million_population_positron_emission_7879edaa" VARCHAR -- Total Density Per Million Population, Positron Emission Tomography Low,
"total_density_per_million_population_positron_emission_5cf3a961" VARCHAR -- Total Density Per Million Population, Positron Emission Tomography High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_radiotherapy_units_1 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_radiotherapy_units" FLOAT -- Total Density Per Million Population, Radiotherapy Units,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_radiotherapy_units_2 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_radiotherapy_units" FLOAT -- Total Density Per Million Population, Radiotherapy Units,
"total_density_per_million_population_radiotherapy_units_low" VARCHAR -- Total Density Per Million Population, Radiotherapy Units Low,
"total_density_per_million_population_radiotherapy_units_high" VARCHAR -- Total Density Per Million Population, Radiotherapy Units High,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_telecobalt_unit_1 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_telecobalt_unit" FLOAT -- Total Density Per Million Population, Telecobalt Unit,
"comments" VARCHAR
);
CREATE TABLE owid_total_density_per_million_population_telecobalt_unit_2 (
"year" INTEGER,
"country" VARCHAR,
"total_density_per_million_population_telecobalt_unit" FLOAT -- Total Density Per Million Population, Telecobalt Unit,
"total_density_per_million_population_telecobalt_unit_low" VARCHAR -- Total Density Per Million Population, Telecobalt Unit Low,
"total_density_per_million_population_telecobalt_unit_high" VARCHAR -- Total Density Per Million Population, Telecobalt Unit High,
"comments" VARCHAR
);
CREATE TABLE owid_total_environment_attributable_dalys_000_in_child_62a57fb7 (
"year" INTEGER,
"country" VARCHAR,
"total_environment_attributable_dalys_000_in_children_u_c82266ca" UINTEGER -- Total Environment Attributable Dalys, 000, In Children Under 5 Years,
"total_environment_attributable_dalys_000_in_children_u_438f9eb1" VARCHAR -- Total Environment Attributable Dalys, 000, In Children Under 5 Years Low,
"total_environment_attributable_dalys_000_in_children_u_c4dc0878" VARCHAR -- Total Environment Attributable Dalys, 000, In Children Under 5 Years High,
"comments" VARCHAR
);
CREATE TABLE owid_total_environment_attributable_dalys_000_in_child_b09d421f (
"year" INTEGER,
"country" VARCHAR,
"total_environment_attributable_dalys_000_in_children_u_c82266ca" UINTEGER -- Total Environment Attributable Dalys, 000, In Children Under 5 Years
);
CREATE TABLE owid_total_environment_attributable_dalys_per_100000_c_4135241a (
"year" INTEGER,
"country" VARCHAR,
"total_environment_attributable_dalys_per_100000_childr_54bdd40a" INTEGER -- Total Environment Attributable Dalys Per 100000 Children Under 5 Years,
"total_environment_attributable_dalys_per_100000_childr_9ecb7f97" VARCHAR -- Total Environment Attributable Dalys Per 100000 Children Under 5 Years Low,
"total_environment_attributable_dalys_per_100000_childr_ee3c106f" VARCHAR -- Total Environment Attributable Dalys Per 100000 Children Under 5 Years High,
"comments" VARCHAR
);
CREATE TABLE owid_total_environment_attributable_dalys_per_100000_c_ad290ec1 (
"year" INTEGER,
"country" VARCHAR,
"total_environment_attributable_dalys_per_100000_childr_54bdd40a" INTEGER -- Total Environment Attributable Dalys Per 100000 Children Under 5 Years
);
Anyone who has the link will be able to view this.