Split (1)

train · 500k rows

Available Extra Rooms in Hospital int64 0 24	Department stringclasses 5 values	Ward_Facility_Code stringclasses 6 values	doctor_name stringclasses 9 values	staff_available int64 0 10	patientid int64 -3,269 134k	Age stringclasses 10 values	gender stringclasses 3 values	Type of Admission stringclasses 3 values	Severity of Illness stringclasses 3 values	health_conditions stringclasses 5 values	Visitors with Patient int64 0 32	Insurance stringclasses 2 values	Admission_Deposit float64 1.65k 10.1k	Stay (in days) int64 3 51
4	gynecology	F	Dr Olivia	0	48,912	21-30	Female	Trauma	Moderate	null	4	No	4,634.749041	9
2	gynecology	D	Dr Sarah	10	82,878	41-50	Female	Urgent	Moderate	High Blood Pressure	2	Yes	4,846.419957	9
3	gynecology	B	Dr Olivia	4	79,809	41-50	Female	Trauma	Moderate	null	6	No	4,597.523927	7
21	gynecology	D	Dr Nathan	7	50,564	31-40	Female	Trauma	Minor	null	2	No	4,817.679529	10
3	gynecology	D	Dr Sophia	10	83,439	31-40	Female	Trauma	Extreme	Diabetes	4	Yes	6,075.534401	9
3	radiotherapy	E	Dr John	7	50,785	61-70	Female	Trauma	Moderate	High Blood Pressure	4	No	4,827.59316	26
2	gynecology	F	Dr Olivia	0	11,062	21-30	Female	Trauma	Moderate	Other	4	No	4,666.850203	10
2	gynecology	D	Dr Nathan	5	76,472	31-40	Female	Trauma	Extreme	Other	2	Yes	3,628.461287	9
2	radiotherapy	E	Dr John	9	97,565	71-80	Other	Trauma	Moderate	null	2	Yes	4,646.963861	23
8	TB & Chest disease	E	Dr Mark	2	129,313	21-30	Male	Trauma	Extreme	Asthama	2	No	4,841.541282	33
3	gynecology	D	Dr Sarah	10	2,331	41-50	Female	Emergency	Moderate	High Blood Pressure	4	Yes	3,228.819375	8
2	gynecology	F	Dr Olivia	2	15,266	31-40	Female	Trauma	Moderate	null	4	Yes	3,875.516635	9
2	gynecology	B	Dr Olivia	1	4,288	21-30	Female	Trauma	Moderate	Other	4	Yes	4,591.735232	9
3	radiotherapy	E	Dr Sam	4	127,971	61-70	Male	Emergency	Moderate	null	1	No	4,694.490568	24
2	gynecology	D	Dr Olivia	5	28,972	21-30	Female	Emergency	Moderate	null	4	No	4,863.803705	8
4	gynecology	F	Dr Olivia	6	107,106	21-30	Female	Trauma	Moderate	null	4	No	4,917.227799	10
4	gynecology	B	Dr Olivia	6	125,240	41-50	Female	Urgent	Moderate	Other	4	No	3,807.736806	9
2	gynecology	D	Dr Olivia	8	30,348	21-30	Female	Emergency	Moderate	null	2	Yes	5,133.670345	9
2	gynecology	F	Dr Sarah	8	45,155	11-20	Female	Trauma	Moderate	High Blood Pressure	3	No	3,730.690476	9
3	gynecology	F	Dr Sarah	8	43,693	11-20	Female	Trauma	Moderate	Asthama	3	Yes	4,974.721438	9
4	gynecology	D	Dr Nathan	4	41,319	31-40	Female	Trauma	Extreme	null	4	Yes	3,909.162218	8
3	gynecology	F	Dr Sophia	9	4,495	21-30	Female	Trauma	Minor	Diabetes	6	Yes	4,824.243773	8
2	gynecology	D	Dr Sarah	7	43,439	31-40	Female	Urgent	Minor	Asthama	2	Yes	4,136.615279	9
4	radiotherapy	E	Dr John	7	103,849	31-40	Other	Trauma	Minor	null	4	No	4,065.0283	6
6	gynecology	D	Dr Sarah	9	42,611	11-20	Female	Emergency	Moderate	High Blood Pressure	4	Yes	5,084.354988	8
3	gynecology	B	Dr Sarah	0	28,971	31-40	Female	Trauma	Extreme	Asthama	2	No	5,309.97018	7
3	gynecology	F	Dr Sarah	4	29,717	11-20	Female	Trauma	Minor	Asthama	2	No	6,647.214251	7
3	gynecology	D	Dr Sarah	0	87,199	21-30	Female	Emergency	Minor	Asthama	2	Yes	5,791.681562	9
3	gynecology	F	Dr Nathan	0	72,329	21-30	Female	Urgent	Minor	Other	3	Yes	4,718.07743	8
5	gynecology	F	Dr Nathan	6	74,233	21-30	Female	Trauma	Minor	Other	4	No	3,815.256755	9
2	TB & Chest disease	E	Dr John	2	129,964	61-70	Other	Trauma	Moderate	Other	2	No	4,685.666847	19
2	gynecology	B	Dr Sarah	1	27,208	11-20	Female	Trauma	Extreme	Asthama	2	Yes	5,562.346829	9
3	anesthesia	E	Dr John	1	29,577	31-40	Female	Trauma	Minor	null	3	Yes	4,779.630205	19
11	gynecology	F	Dr Nathan	2	42,896	21-30	Female	Emergency	Minor	null	5	Yes	5,341.803592	8
3	gynecology	D	Dr Nathan	8	28,340	21-30	Female	Emergency	Minor	Other	4	No	3,800.198	9
3	gynecology	B	Dr Sarah	8	89,376	31-40	Female	Trauma	Moderate	Asthama	14	Yes	5,034.689462	9
6	gynecology	B	Dr Sarah	5	68,306	11-20	Female	Emergency	Extreme	Asthama	6	Yes	4,271.894954	9
2	anesthesia	A	Dr Mark	0	99,238	61-70	Male	Trauma	Moderate	null	2	Yes	5,705.953801	38
2	gynecology	D	Dr Sarah	0	9,855	11-20	Female	Emergency	Moderate	Asthama	2	Yes	3,893.260375	8
2	gynecology	B	Dr Sophia	2	88,164	21-30	Female	Trauma	Extreme	Diabetes	6	Yes	6,939.663575	7
2	gynecology	F	Dr Olivia	3	111,724	21-30	Female	Trauma	Moderate	null	4	Yes	7,064.144192	8
2	gynecology	F	Dr Olivia	8	46,429	21-30	Female	Trauma	Moderate	null	4	Yes	4,713.752887	9
21	anesthesia	E	Dr John	0	104,672	31-40	Female	Emergency	Minor	Other	3	Yes	4,477.801067	13
3	gynecology	D	Dr Sarah	4	35,122	11-20	Female	Urgent	Moderate	Asthama	2	Yes	5,046.235748	9
4	gynecology	B	Dr Sarah	9	2,900	11-20	Female	Emergency	Moderate	High Blood Pressure	2	Yes	4,742.764687	8
2	anesthesia	E	Dr John	4	86,570	51-60	Female	Trauma	Moderate	null	4	Yes	4,961.9182	36
2	gynecology	F	Dr Olivia	2	43,714	21-30	Female	Trauma	Moderate	null	4	Yes	2,489.557042	9
2	anesthesia	C	Dr Mark	1	126,221	71-80	Male	Emergency	Moderate	null	2	Yes	4,672.975045	31
4	gynecology	D	Dr Sarah	1	41,108	41-50	Female	Trauma	Extreme	High Blood Pressure	4	Yes	4,588.296314	7
3	gynecology	B	Dr Sarah	5	74,875	11-20	Female	Trauma	Minor	High Blood Pressure	2	Yes	4,600.865182	10
4	gynecology	D	Dr Nathan	4	127,001	21-30	Female	Emergency	Extreme	null	4	Yes	3,577.398237	7
13	gynecology	F	Dr Nathan	5	79,546	31-40	Female	Trauma	Minor	null	7	Yes	3,850.891545	11
4	gynecology	B	Dr Sarah	3	87,976	11-20	Female	Urgent	Moderate	High Blood Pressure	2	Yes	6,778.33401	8
4	gynecology	F	Dr Sarah	2	105,615	41-50	Female	Trauma	Minor	Asthama	4	Yes	4,719.450214	9
2	gynecology	F	Dr Olivia	6	97,032	31-40	Female	Emergency	Moderate	null	2	Yes	4,609.8213	8
4	gynecology	F	Dr Olivia	2	10,645	21-30	Female	Trauma	Moderate	null	3	Yes	3,497.666831	10
2	gynecology	F	Dr Sarah	4	14,087	11-20	Female	Trauma	Moderate	High Blood Pressure	2	Yes	6,765.336973	8
2	gynecology	B	Dr Olivia	3	124,227	31-40	Female	Emergency	Moderate	null	2	Yes	3,544.851744	8
10	gynecology	D	Dr Nathan	0	118,588	31-40	Female	Trauma	Minor	null	4	Yes	5,072.320831	10
2	gynecology	D	Dr Olivia	9	49,471	31-40	Female	Emergency	Moderate	Other	12	Yes	3,744.412695	10
4	radiotherapy	E	Dr John	4	97,720	71-80	Other	Trauma	Extreme	Asthama	4	Yes	3,612.183546	20
3	gynecology	F	Dr Olivia	5	6,248	21-30	Female	Urgent	Moderate	null	3	Yes	4,915.654189	8
4	gynecology	B	Dr Nathan	5	89,731	31-40	Female	Trauma	Extreme	null	4	Yes	4,696.810607	8
2	gynecology	D	Dr Olivia	5	89,856	21-30	Female	Trauma	Moderate	null	4	Yes	6,817.120115	7
3	gynecology	F	Dr Sarah	2	68,706	11-20	Female	Trauma	Moderate	High Blood Pressure	2	Yes	4,801.029017	11
2	gynecology	B	Dr Olivia	7	47,583	21-30	Female	Trauma	Moderate	Other	2	Yes	5,888.818033	8
3	gynecology	B	Dr Nathan	10	79,775	21-30	Female	Trauma	Minor	Other	6	Yes	4,631.401115	8
3	gynecology	D	Dr Sophia	4	110,701	21-30	Female	Trauma	Extreme	Heart disease	2	Yes	3,725.815868	7
3	gynecology	F	Dr Sophia	7	60,101	21-30	Female	Urgent	Moderate	Heart disease	2	Yes	5,130.566143	9
4	surgery	A	Dr Isaac	6	42,733	61-70	Male	Trauma	Moderate	null	2	Yes	5,377.743314	40
4	gynecology	D	Dr Nathan	4	80,885	21-30	Female	Trauma	Minor	null	4	Yes	6,559.09036	7
4	gynecology	F	Dr Nathan	5	34,309	21-30	Female	Trauma	Extreme	null	4	Yes	4,811.405804	7
3	gynecology	D	Dr Sophia	9	14,703	31-40	Female	Urgent	Minor	Heart disease	2	Yes	3,996.147718	8
7	radiotherapy	A	Dr John	2	86,020	41-50	Female	Trauma	Moderate	null	4	Yes	4,227.398675	5
2	gynecology	B	Dr Nathan	2	80,606	21-30	Female	Emergency	Minor	Other	2	Yes	6,535.364931	9
2	gynecology	B	Dr Sophia	3	46,394	31-40	Female	Trauma	Moderate	Heart disease	4	Yes	5,288.871589	9
3	gynecology	F	Dr Sarah	4	24,815	11-20	Female	Emergency	Moderate	High Blood Pressure	4	Yes	3,910.427698	8
3	radiotherapy	E	Dr John	0	38,286	41-50	Other	Trauma	Moderate	High Blood Pressure	4	Yes	3,272.835245	7
4	radiotherapy	E	Dr John	10	2,081	41-50	Other	Urgent	Moderate	Heart disease	2	Yes	3,367.021709	7
4	gynecology	B	Dr Sophia	7	128,805	31-40	Female	Trauma	Moderate	Heart disease	2	Yes	5,607.629457	10
2	anesthesia	A	Dr Mark	7	3,570	41-50	Male	Trauma	Minor	null	2	Yes	3,887.056471	15
4	gynecology	F	Dr Sophia	9	50,736	31-40	Female	Trauma	Moderate	Heart disease	3	Yes	6,823.28062	8
5	gynecology	D	Dr Sarah	4	46,458	41-50	Female	Emergency	Minor	High Blood Pressure	4	Yes	5,674.30181	9
3	gynecology	F	Dr Olivia	0	6,504	21-30	Female	Urgent	Moderate	Other	2	Yes	4,004.28696	9
3	radiotherapy	A	Dr John	10	15,970	41-50	Female	Trauma	Moderate	Other	3	Yes	5,454.742374	5
4	gynecology	B	Dr Nathan	9	93,129	21-30	Female	Trauma	Minor	null	2	Yes	4,099.605241	9
2	radiotherapy	A	Dr John	7	13,038	51-60	Female	Trauma	Minor	High Blood Pressure	3	Yes	6,278.117867	21
4	TB & Chest disease	A	Dr John	10	14,311	41-50	Other	Trauma	Moderate	null	2	Yes	4,090.374389	13
3	gynecology	B	Dr Sarah	7	21,601	31-40	Female	Trauma	Extreme	High Blood Pressure	2	Yes	4,948.917023	8
3	radiotherapy	E	Dr Sam	6	57,015	71-80	Male	Trauma	Moderate	null	6	Yes	6,392.877343	20
3	gynecology	F	Dr Olivia	1	4,086	21-30	Female	Trauma	Moderate	null	6	Yes	4,169.393378	10
2	radiotherapy	E	Dr John	5	22,077	41-50	Other	Trauma	Moderate	null	2	Yes	6,999.088479	6
2	radiotherapy	A	Dr Sam	7	20,473	21-30	Male	Trauma	Moderate	Heart disease	2	Yes	5,747.780541	23
3	gynecology	F	Dr Olivia	5	65,130	21-30	Female	Urgent	Moderate	Other	2	Yes	4,864.160328	8
4	gynecology	F	Dr Sarah	2	124,134	31-40	Female	Trauma	Minor	High Blood Pressure	4	Yes	3,546.853687	9
4	gynecology	B	Dr Olivia	5	3,697	31-40	Female	Emergency	Moderate	null	4	Yes	3,779.076088	9
4	gynecology	D	Dr Sophia	5	120,082	31-40	Female	Trauma	Moderate	Heart disease	2	Yes	3,497.252514	9
3	gynecology	F	Dr Sarah	2	2,451	31-40	Female	Trauma	Minor	High Blood Pressure	3	Yes	4,103.792852	7
3	gynecology	F	Dr Olivia	10	110,765	21-30	Female	Trauma	Moderate	null	4	Yes	3,938.979822	8
3	anesthesia	A	Dr John	6	112,745	41-50	Other	Trauma	Moderate	Heart disease	2	Yes	4,325.049081	17

Subsets and Splits

Diabetes Patients Aged 31-4

Retrieves specific records of individuals aged 31-40 with diabetes, providing limited analytical value without further aggregation or context.

Extreme Heart Disease Cases

The query retrieves all records of patients with extreme severity of illness and heart disease, providing limited analytical value beyond basic filtering.