Global Health Statistics

Global Health Statistics: Disease Prevalence, Treatments & Outcomes by Country

@kaggle.malaiarasugraj_global_health_statistics

Table List

1 table(29.91 MB)

Global Health Statistics

@kaggle.malaiarasugraj_global_health_statistics.global_health_statistics

29.91 MB
1000000 rows
22 columns

country Country	year Year	disease_name Disease Name	disease_category Disease Category	prevalence_rate Prevalence Rate (%)	incidence_rate Incidence Rate (%)	mortality_rate Mortality Rate (%)	age_group Age Group	gender Gender	population_affected Population Affected	healthcare_access Healthcare Access (%)	doctors_per_1000 Doctors Per 1000	hospital_beds_per_1000 Hospital Beds Per 1000	treatment_type Treatment Type	average_treatment_cost_usd Average Treatment Cost (USD)	availability_of_vaccines_treatment Availability Of Vaccines/Treatment	recovery_rate Recovery Rate (%)	dalys DALYs	improvement_in_5_years Improvement In 5 Years (%)	per_capita_income_usd Per Capita Income (USD)	education_index Education Index	urbanization_rate Urbanization Rate (%)
Italy	2013	Malaria	Respiratory	0.95	1.55	8.42	0-18	Male	471007	57.74	3.34	7.58	Medication	21064	No	91.82	4493	2.16	16886	0.79	86.02
France	2002	Ebola	Parasitic	12.46	8.63	8.75	61+	Male	634318	89.21	1.33	5.11	Surgery	47851	Yes	76.65	2366	4.82	80639	0.74	45.52
Turkey	2015	COVID-19	Genetic	0.91	2.35	6.22	36-60	Male	154878	56.41	4.07	3.49	Vaccination	27834	Yes	98.55	41	5.81	12245	0.41	40.2
Indonesia	2011	Parkinson's Disease	Autoimmune	4.68	6.29	3.99	0-18	Other	446224	85.2	3.18	8.44	Surgery	144	Yes	67.35	3201	2.22	49336	0.49	58.47
Italy	2013	Tuberculosis	Genetic	0.83	13.59	7.01	61+	Male	472908	67	4.61	5.9	Medication	8908	Yes	50.06	2832	6.93	47701	0.5	48.14
Saudi Arabia	2011	Dengue	Bacterial	10.99	6.49	4.64	61+	Female	479234	98.41	3.5	0.62	Therapy	42671	Yes	93.17	416	9.83	29597	0.46	56.5
USA	2013	Malaria	Cardiovascular	18.42	6.33	9.33	61+	Female	289931	90.03	3.16	3.31	Surgery	15579	No	92.8	4535	0.89	60027	0.7	20.48
Nigeria	2007	Tuberculosis	Neurological	3.48	5.71	1.21	0-18	Female	393296	75.6	0.54	3.54	Medication	15744	Yes	65.45	4584	9.81	23222	0.46	66.49
Italy	2000	Rabies	Chronic	15.59	4.74	6.38	19-35	Female	253110	87.87	4.56	5.84	Therapy	7669	Yes	59.23	2253	9.92	30849	0.55	41.27
Australia	2006	Cholera	Chronic	10.12	2.08	6	61+	Male	174143	95.9	4.63	6.01	Medication	9468	Yes	93.21	4694	2.96	68856	0.9	83.3


CREATE TABLE global_health_statistics (
  "country" VARCHAR,
  "year" BIGINT,
  "disease_name" VARCHAR,
  "disease_category" VARCHAR,
  "prevalence_rate" DOUBLE,
  "incidence_rate" DOUBLE,
  "mortality_rate" DOUBLE,
  "age_group" VARCHAR,
  "gender" VARCHAR,
  "population_affected" BIGINT,
  "healthcare_access" DOUBLE,
  "doctors_per_1000" DOUBLE,
  "hospital_beds_per_1000" DOUBLE,
  "treatment_type" VARCHAR,
  "average_treatment_cost_usd" BIGINT,
  "availability_of_vaccines_treatment" VARCHAR,
  "recovery_rate" DOUBLE,
  "dalys" BIGINT,
  "improvement_in_5_years" DOUBLE,
  "per_capita_income_usd" BIGINT,
  "education_index" DOUBLE,
  "urbanization_rate" DOUBLE
);