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
2	gynecology	D	Dr Sarah	10	44,756	11-20	Female	Emergency	Moderate	Asthama	2	Yes	4,911.387503	9
4	gynecology	F	Dr Olivia	1	5,147	21-30	Female	Emergency	Moderate	Other	4	Yes	4,363.620559	8
3	anesthesia	E	Dr John	1	5,933	41-50	Female	Trauma	Minor	High Blood Pressure	2	No	3,946.470364	19
5	gynecology	B	Dr Sophia	2	89,107	21-30	Female	Trauma	Extreme	Diabetes	2	No	4,915.402007	8
2	gynecology	F	Dr Sophia	1	18,288	21-30	Female	Emergency	Moderate	Diabetes	2	No	6,223.190028	7
3	gynecology	F	Dr Sarah	10	57,496	41-50	Female	Emergency	Minor	Asthama	2	Yes	5,413.011184	10
3	gynecology	B	Dr Sophia	0	43,345	41-50	Female	Trauma	Moderate	Diabetes	2	Yes	4,853.617835	10
4	anesthesia	E	Dr John	3	129,940	61-70	Female	Trauma	Moderate	null	4	Yes	4,362.509509	31
1	gynecology	F	Dr Sophia	1	39,971	21-30	Female	Urgent	Minor	Diabetes	3	No	3,771.42826	9
3	gynecology	F	Dr Nathan	0	3,229	41-50	Female	Trauma	Minor	Other	2	Yes	4,966.380651	8
6	gynecology	D	Dr Nathan	3	109,486	41-50	Female	Trauma	Extreme	Other	2	Yes	3,725.381664	10
6	gynecology	B	Dr Sophia	8	30,648	31-40	Female	Trauma	Extreme	Diabetes	4	No	4,710.37817	9
4	gynecology	F	Dr Olivia	1	128,782	21-30	Female	Trauma	Moderate	null	8	No	4,087.199109	8
5	anesthesia	E	Dr Mark	0	127,289	31-40	Male	Trauma	Moderate	High Blood Pressure	4	Yes	4,271.471729	21
2	gynecology	B	Dr Olivia	3	56,324	41-50	Female	Trauma	Moderate	null	4	Yes	4,235.610659	7
20	gynecology	F	Dr Nathan	5	19,700	31-40	Female	Emergency	Minor	Other	4	No	4,612.946136	11
2	gynecology	B	Dr Olivia	7	55,367	21-30	Female	Trauma	Moderate	Other	2	Yes	4,642.125731	6
2	gynecology	F	Dr Nathan	9	48,274	41-50	Female	Emergency	Minor	Other	4	No	4,928.343658	9
3	anesthesia	C	Dr Mark	9	19,456	81-90	Male	Emergency	Moderate	Other	4	Yes	4,249.687413	38
5	gynecology	D	Dr Sarah	10	68,641	11-20	Female	Trauma	Extreme	High Blood Pressure	4	No	3,811.367333	8
4	gynecology	B	Dr Olivia	2	113,046	31-40	Female	Trauma	Moderate	Other	2	No	5,016.900718	9
2	radiotherapy	A	Dr John	6	126,766	21-30	Female	Trauma	Extreme	Diabetes	2	No	6,717.27717	19
3	TB & Chest disease	E	Dr Mark	3	50,413	41-50	Male	Urgent	Minor	Other	2	Yes	5,317.703458	11
2	gynecology	F	Dr Olivia	3	110,796	21-30	Female	Trauma	Moderate	Other	2	No	5,036.462246	10
3	gynecology	F	Dr Nathan	0	86,057	21-30	Female	Trauma	Minor	Other	2	Yes	6,176.284001	8
3	radiotherapy	E	Dr John	4	120,596	21-30	Female	Trauma	Moderate	High Blood Pressure	2	No	5,539.386162	21
7	anesthesia	C	Dr John	8	15,259	61-70	Female	Emergency	Moderate	Other	10	No	4,642.724455	30
4	gynecology	B	Dr Sarah	10	124,417	31-40	Female	Emergency	Moderate	Asthama	4	No	3,881.212433	8
3	gynecology	F	Dr Sarah	6	11,540	11-20	Female	Urgent	Minor	Asthama	2	No	5,239.313621	9
3	gynecology	B	Dr Olivia	6	67,742	21-30	Female	Trauma	Moderate	Other	2	No	2,855.071912	9
2	gynecology	B	Dr Sophia	7	81,002	21-30	Female	Trauma	Extreme	Diabetes	2	Yes	4,658.560473	8
3	gynecology	D	Dr Olivia	10	116,399	31-40	Female	Trauma	Moderate	Other	2	Yes	4,463.408754	7
3	gynecology	F	Dr Sarah	5	12,412	11-20	Female	Trauma	Moderate	Asthama	4	Yes	4,562.843292	9
2	gynecology	B	Dr Sophia	10	33,112	41-50	Female	Emergency	Extreme	Diabetes	4	Yes	6,710.832934	8
3	radiotherapy	E	Dr John	8	49,976	61-70	Female	Emergency	Moderate	null	2	No	3,946.378397	22
5	gynecology	F	Dr Sarah	4	72,451	11-20	Female	Trauma	Moderate	High Blood Pressure	14	Yes	4,829.432433	6
2	gynecology	F	Dr Sarah	0	23,540	31-40	Female	Trauma	Moderate	High Blood Pressure	2	No	5,007.946435	10
2	TB & Chest disease	A	Dr John	8	46,375	41-50	Female	Trauma	Extreme	Diabetes	2	Yes	4,783.528992	11
4	gynecology	D	Dr Nathan	4	19,591	21-30	Female	Trauma	Extreme	Other	4	Yes	4,129.371347	9
2	gynecology	D	Dr Sophia	9	89,778	21-30	Female	Emergency	Extreme	Diabetes	3	No	4,864.764489	8
2	gynecology	B	Dr Olivia	5	77,421	31-40	Female	Trauma	Moderate	Other	2	No	4,510.427302	9
2	anesthesia	E	Dr John	1	98,000	81-90	Female	Trauma	Moderate	High Blood Pressure	2	No	5,342.950573	29
4	gynecology	F	Dr Olivia	5	40,020	21-30	Female	Trauma	Moderate	Other	4	No	4,539.274362	9
2	anesthesia	A	Dr John	7	23,457	71-80	Female	Trauma	Moderate	Other	3	Yes	4,917.650133	36
3	gynecology	B	Dr Olivia	1	18,319	31-40	Female	Trauma	Moderate	Other	3	No	4,566.834117	10
4	gynecology	F	Dr Nathan	8	39,688	21-30	Female	Trauma	Minor	Other	4	Yes	4,008.69954	7
4	gynecology	F	Dr Nathan	1	20,657	31-40	Female	Trauma	Minor	Other	4	Yes	6,609.327399	9
4	gynecology	F	Dr Olivia	8	122,040	41-50	Female	Emergency	Moderate	Other	7	Yes	4,979.252916	9
5	gynecology	D	Dr Sarah	3	12,306	41-50	Female	Emergency	Moderate	Asthama	4	No	3,778.070855	10
4	gynecology	B	Dr Sophia	7	84,747	21-30	Female	Trauma	Extreme	Diabetes	3	Yes	4,449.581763	8
3	radiotherapy	C	Dr John	9	32,223	41-50	Female	Emergency	Moderate	Other	6	No	4,909.736037	6
2	gynecology	B	Dr Sophia	8	66,586	21-30	Female	Trauma	Extreme	Diabetes	4	Yes	6,119.060166	8
2	gynecology	D	Dr Sophia	6	112,477	21-30	Female	Trauma	Moderate	Diabetes	2	Yes	3,722.677488	8
4	gynecology	F	Dr Sarah	8	115,823	31-40	Female	Emergency	Moderate	Asthama	4	Yes	4,205.111578	8
3	gynecology	B	Dr Olivia	6	86,212	21-30	Female	Trauma	Moderate	Other	2	No	6,403.809624	9
3	gynecology	D	Dr Nathan	2	18,033	21-30	Female	Emergency	Minor	Other	4	No	4,774.215321	8
3	gynecology	B	Dr Sarah	3	11,304	31-40	Female	Trauma	Moderate	Asthama	4	No	4,319.955308	10
3	gynecology	F	Dr Sophia	9	82,162	31-40	Female	Emergency	Minor	Diabetes	4	No	4,804.519123	8
2	gynecology	F	Dr Olivia	2	13,054	31-40	Female	Emergency	Moderate	Other	4	No	4,748.655367	8
2	anesthesia	A	Dr John	7	31,783	71-80	Female	Trauma	Minor	Other	4	No	6,611.758445	36
3	gynecology	B	Dr Nathan	0	109,469	21-30	Female	Trauma	Minor	Other	4	No	4,467.363244	11
21	radiotherapy	E	Dr John	10	58,198	21-30	Female	Trauma	Moderate	Other	2	No	3,548.379385	20
3	gynecology	D	Dr Sarah	0	126,692	41-50	Female	Urgent	Moderate	High Blood Pressure	4	Yes	3,504.808675	9
6	TB & Chest disease	E	Dr John	6	72,848	51-60	Female	Emergency	Minor	null	4	No	4,967.923657	26
5	surgery	A	Dr Isaac	6	116,354	51-60	Male	Trauma	Moderate	High Blood Pressure	4	No	4,634.173474	41
3	gynecology	D	Dr Nathan	3	12,311	21-30	Female	Urgent	Extreme	null	6	Yes	5,374.735899	8
3	gynecology	D	Dr Nathan	2	16,934	31-40	Female	Urgent	Minor	null	6	No	4,918.346298	9
2	anesthesia	A	Dr Mark	7	113,862	51-60	Male	Trauma	Extreme	Asthama	4	No	3,821.033237	33
5	radiotherapy	E	Dr Sam	9	118,051	91-100	Male	Emergency	Moderate	High Blood Pressure	2	No	4,446.384817	26
2	anesthesia	A	Dr John	5	114,866	81-90	Female	Trauma	Extreme	Asthama	6	No	3,360.256618	36
5	gynecology	F	Dr Sophia	8	27,924	31-40	Female	Emergency	Minor	Diabetes	3	Yes	5,225.389322	12
5	surgery	A	Dr Simon	6	47,034	31-40	Female	Urgent	Extreme	Asthama	32	No	3,333.915668	15
3	gynecology	B	Dr Olivia	9	70,572	41-50	Female	Trauma	Moderate	Other	2	Yes	6,269.667111	8
2	radiotherapy	E	Dr John	9	118,879	71-80	Female	Emergency	Moderate	Diabetes	6	Yes	6,866.949025	21
2	gynecology	D	Dr Sarah	1	12,662	11-20	Female	Emergency	Minor	High Blood Pressure	4	No	4,936.2656	7
4	gynecology	B	Dr Sophia	4	107,471	21-30	Female	Trauma	Moderate	Diabetes	4	No	4,086.547124	8
6	gynecology	F	Dr Sarah	1	82,538	41-50	Female	Trauma	Moderate	Asthama	2	Yes	6,465.598315	7
5	radiotherapy	E	Dr John	9	128,712	71-80	Female	Emergency	Moderate	Other	2	Yes	7,100.868738	17
4	gynecology	F	Dr Olivia	8	19,701	31-40	Female	Trauma	Moderate	Other	2	Yes	6,806.244415	8
3	gynecology	F	Dr Olivia	10	33,253	41-50	Female	Emergency	Moderate	null	3	Yes	5,922.729425	8
2	gynecology	F	Dr Nathan	10	91,107	21-30	Female	Trauma	Minor	Other	2	Yes	7,418.972718	9
2	gynecology	B	Dr Olivia	1	45,887	21-30	Female	Trauma	Moderate	null	4	Yes	4,138.661398	8
4	gynecology	D	Dr Sarah	6	12,270	11-20	Female	Trauma	Minor	Asthama	2	No	4,666.294287	8
3	gynecology	D	Dr Sophia	2	41,659	31-40	Female	Trauma	Extreme	Diabetes	3	Yes	6,995.394903	8
2	gynecology	F	Dr Sarah	4	126,390	41-50	Female	Urgent	Minor	Asthama	2	Yes	4,602.525269	9
4	gynecology	D	Dr Sophia	3	622	31-40	Female	Trauma	Minor	Diabetes	2	No	4,123.328631	8
4	gynecology	F	Dr Sarah	3	31,441	31-40	Female	Emergency	Minor	High Blood Pressure	4	Yes	6,908.623909	6
6	anesthesia	E	Dr John	2	123,689	51-60	Female	Trauma	Moderate	Other	4	No	3,672.466977	29
2	radiotherapy	E	Dr John	2	17,407	81-90	Female	Trauma	Moderate	High Blood Pressure	2	No	4,509.857067	24
3	radiotherapy	E	Dr John	10	110,338	31-40	Female	Trauma	Moderate	Other	2	No	5,160.911013	5
1	gynecology	D	Dr Sarah	7	75,318	31-40	Female	Trauma	Minor	High Blood Pressure	6	Yes	4,473.257416	9
3	TB & Chest disease	E	Dr John	1	35,521	31-40	Female	Trauma	Minor	Asthama	2	Yes	4,851.954934	12
5	TB & Chest disease	E	Dr John	9	123,384	31-40	Female	Emergency	Extreme	Asthama	4	No	3,986.706823	11
4	gynecology	D	Dr Olivia	3	5,690	31-40	Female	Trauma	Moderate	Other	2	No	4,418.482795	7
2	anesthesia	E	Dr Mark	4	9,516	61-70	Male	Trauma	Moderate	Other	2	Yes	4,829.041291	39
3	radiotherapy	E	Dr John	2	62,952	21-30	Female	Emergency	Minor	Asthama	6	No	3,955.875186	20
4	radiotherapy	E	Dr Sam	0	111,650	31-40	Male	Emergency	Moderate	Other	3	No	5,370.1986	5
4	TB & Chest disease	C	Dr John	7	106,164	71-80	Female	Emergency	Moderate	Other	2	No	5,548.889067	29
2	gynecology	B	Dr Sarah	9	4,741	11-20	Female	Trauma	Extreme	Asthama	4	No	4,555.489019	9
2	gynecology	D	Dr Nathan	3	113,997	21-30	Female	Emergency	Minor	Other	3	Yes	3,959.113172	8

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.