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 Sophia	9	127,158	41-50	Female	Trauma	Moderate	Diabetes	2	Yes	4,489.376167	10
3	gynecology	F	Dr Sarah	6	84,964	11-20	Female	Emergency	Minor	Asthama	3	Yes	6,800.572148	8
4	gynecology	B	Dr Sarah	0	34,026	41-50	Female	Trauma	Moderate	High Blood Pressure	4	Yes	3,208.684297	8
2	anesthesia	E	Dr John	1	42,676	51-60	Female	Emergency	Moderate	Diabetes	2	Yes	6,057.198208	32
3	gynecology	F	Dr Sarah	6	82,709	31-40	Female	Trauma	Moderate	High Blood Pressure	2	Yes	4,811.153119	11
3	anesthesia	E	Dr John	5	8,269	51-60	Female	Trauma	Moderate	Asthama	2	Yes	6,642.57493	24
3	gynecology	F	Dr Nathan	10	4,060	31-40	Female	Emergency	Minor	Other	3	No	4,055.717335	6
3	gynecology	F	Dr Nathan	4	126,826	21-30	Female	Emergency	Minor	null	2	No	4,752.396749	9
3	gynecology	D	Dr Nathan	8	40,080	21-30	Female	Trauma	Extreme	Other	4	Yes	3,591.283866	10
4	gynecology	F	Dr Sophia	5	71,434	21-30	Female	Trauma	Moderate	Diabetes	3	No	3,754.353369	8
6	gynecology	B	Dr Nathan	1	37,143	21-30	Female	Emergency	Minor	Other	2	No	5,025.181634	9
3	radiotherapy	E	Dr John	9	52,971	21-30	Female	Trauma	Moderate	Other	3	Yes	3,593.205893	20
2	gynecology	B	Dr Nathan	5	125,835	21-30	Female	Urgent	Minor	Other	2	No	3,960.822281	9
3	gynecology	D	Dr Nathan	2	88,388	31-40	Female	Trauma	Extreme	Other	4	Yes	2,842.361654	10
3	anesthesia	E	Dr Mark	1	14,965	41-50	Male	Emergency	Minor	Asthama	2	No	7,369.968362	19
4	gynecology	D	Dr Sarah	6	111,104	41-50	Female	Trauma	Minor	Asthama	4	No	6,345.445173	8
4	gynecology	B	Dr Sarah	5	127,590	31-40	Female	Trauma	Moderate	High Blood Pressure	4	No	3,891.614349	9
2	gynecology	B	Dr Nathan	3	5,597	41-50	Female	Trauma	Minor	Other	6	Yes	3,752.921637	10
2	gynecology	B	Dr Olivia	8	64,611	21-30	Female	Trauma	Moderate	null	2	No	4,782.420938	10
4	gynecology	B	Dr Sarah	8	109,602	11-20	Female	Trauma	Moderate	High Blood Pressure	3	No	3,969.017591	9
3	gynecology	D	Dr Sarah	6	113,155	41-50	Female	Urgent	Minor	High Blood Pressure	4	Yes	4,188.252553	8
2	anesthesia	C	Dr Mark	10	88,506	21-30	Male	Urgent	Extreme	Other	4	Yes	4,461.195217	30
5	gynecology	D	Dr Sarah	4	72,888	41-50	Female	Emergency	Moderate	High Blood Pressure	5	No	4,764.550834	9
8	gynecology	D	Dr Sarah	3	36,655	41-50	Female	Trauma	Minor	High Blood Pressure	8	Yes	4,243.084414	9
3	gynecology	D	Dr Sarah	1	23,450	41-50	Female	Trauma	Minor	High Blood Pressure	4	Yes	3,561.383125	9
2	gynecology	D	Dr Sarah	10	112,977	31-40	Female	Trauma	Extreme	Asthama	6	Yes	2,362.690756	8
3	gynecology	D	Dr Sophia	5	14,134	31-40	Female	Trauma	Minor	Diabetes	2	Yes	3,843.808501	8
5	gynecology	F	Dr Sarah	7	43,337	41-50	Female	Emergency	Minor	Asthama	4	No	4,715.814426	9
3	gynecology	F	Dr Olivia	2	13,649	41-50	Female	Emergency	Moderate	Other	3	No	3,978.986596	8
3	anesthesia	A	Dr John	6	68,486	71-80	Female	Trauma	Minor	Other	2	Yes	5,614.699408	34
3	gynecology	F	Dr Olivia	7	107,586	41-50	Female	Trauma	Moderate	Other	2	Yes	5,149.241914	9
2	gynecology	D	Dr Nathan	9	108,592	41-50	Female	Trauma	Extreme	null	4	Yes	2,858.496366	8
3	gynecology	F	Dr Sarah	9	91,391	31-40	Female	Emergency	Minor	Asthama	3	No	3,941.95425	9
4	gynecology	D	Dr Sarah	8	29,327	11-20	Female	Emergency	Moderate	High Blood Pressure	2	Yes	5,405.221137	8
4	radiotherapy	E	Dr John	7	130,932	51-60	Female	Trauma	Moderate	Other	2	Yes	4,040.580816	22
4	gynecology	B	Dr Sophia	0	59,935	31-40	Female	Trauma	Extreme	Diabetes	4	No	3,705.070384	9
5	gynecology	D	Dr Nathan	5	56,799	41-50	Female	Emergency	Extreme	null	3	Yes	2,790.125803	10
4	anesthesia	E	Dr John	3	28,162	21-30	Female	Urgent	Minor	null	2	Yes	4,848.714991	33
5	TB & Chest disease	E	Dr John	6	20,108	41-50	Female	Trauma	Moderate	Other	4	Yes	3,946.232074	12
3	radiotherapy	E	Dr Sam	5	55,606	81-90	Male	Emergency	Moderate	High Blood Pressure	3	Yes	4,093.545055	19
4	gynecology	D	Dr Nathan	5	4,352	31-40	Female	Emergency	Extreme	null	6	Yes	4,647.547164	9
4	gynecology	F	Dr Sophia	8	33,151	21-30	Female	Trauma	Moderate	Diabetes	4	Yes	4,096.47697	8
2	anesthesia	A	Dr John	10	131,716	31-40	Female	Trauma	Moderate	null	2	No	5,442.666662	19
2	gynecology	F	Dr Sarah	8	72,816	11-20	Female	Trauma	Extreme	Asthama	2	Yes	5,525.605901	9
5	radiotherapy	A	Dr John	5	108,120	31-40	Female	Trauma	Minor	High Blood Pressure	2	No	4,106.066121	6
2	gynecology	F	Dr Sophia	8	28,079	21-30	Female	Trauma	Moderate	Diabetes	11	No	5,814.137627	9
3	radiotherapy	A	Dr Sam	8	3,566	51-60	Male	Trauma	Moderate	null	2	No	5,263.744106	24
2	gynecology	F	Dr Olivia	3	28,533	21-30	Female	Trauma	Moderate	null	2	Yes	4,335.50729	9
4	gynecology	F	Dr Olivia	6	25,213	21-30	Female	Trauma	Moderate	Other	4	No	7,361.700747	9
2	gynecology	D	Dr Sarah	5	101,486	11-20	Female	Trauma	Minor	High Blood Pressure	2	No	5,665.315456	9
2	gynecology	F	Dr Sarah	0	120,516	31-40	Female	Trauma	Minor	High Blood Pressure	6	Yes	4,594.860056	8
2	gynecology	B	Dr Nathan	2	54,783	21-30	Female	Trauma	Extreme	Other	2	No	5,040.712384	9
2	gynecology	D	Dr Sophia	3	112,984	21-30	Female	Urgent	Extreme	Diabetes	2	Yes	4,007.494727	8
2	gynecology	F	Dr Nathan	4	112,671	41-50	Female	Trauma	Minor	Other	3	No	3,964.465165	8
2	gynecology	B	Dr Olivia	3	72,137	21-30	Female	Trauma	Moderate	null	4	No	5,581.411672	9
4	gynecology	B	Dr Sarah	7	39,670	11-20	Female	Trauma	Moderate	High Blood Pressure	11	Yes	5,129.129934	8
2	gynecology	F	Dr Olivia	10	16,934	21-30	Female	Trauma	Moderate	Other	4	No	4,819.510718	7
5	gynecology	D	Dr Olivia	0	26,056	21-30	Female	Emergency	Moderate	null	4	Yes	4,590.759096	9
5	radiotherapy	E	Dr John	6	6,800	61-70	Female	Trauma	Minor	Other	2	No	6,733.500793	24
2	anesthesia	A	Dr John	5	40,557	41-50	Female	Trauma	Minor	Other	2	No	5,351.983383	19
2	radiotherapy	E	Dr John	9	66,628	61-70	Female	Trauma	Minor	Diabetes	4	No	4,345.30807	24
2	gynecology	F	Dr Sophia	7	3,918	21-30	Female	Trauma	Moderate	Diabetes	4	Yes	4,133.8506	9
2	radiotherapy	A	Dr John	10	25,995	71-80	Female	Trauma	Minor	High Blood Pressure	2	No	6,398.123394	21
2	radiotherapy	E	Dr Sam	6	97,914	21-30	Male	Trauma	Moderate	Diabetes	2	Yes	6,575.083068	23
2	gynecology	B	Dr Olivia	1	81,496	21-30	Female	Trauma	Moderate	Other	2	No	6,706.200977	6
3	gynecology	F	Dr Nathan	6	110,299	21-30	Female	Trauma	Minor	Other	3	Yes	4,207.378827	9
3	surgery	A	Dr Isaac	7	42,363	21-30	Male	Urgent	Moderate	Other	2	No	5,149.354924	42
4	gynecology	F	Dr Nathan	10	10,281	21-30	Female	Emergency	Minor	Other	3	No	5,915.934413	9
5	gynecology	F	Dr Nathan	6	29,344	21-30	Female	Trauma	Minor	Other	4	Yes	7,311.882494	9
3	radiotherapy	E	Dr Sam	9	89,549	41-50	Male	Trauma	Moderate	High Blood Pressure	16	Yes	4,733.174772	7
5	gynecology	D	Dr Olivia	8	66,627	21-30	Female	Emergency	Moderate	null	6	Yes	3,832.245372	8
3	gynecology	F	Dr Sophia	7	11,040	21-30	Female	Trauma	Moderate	Diabetes	4	Yes	4,066.842641	8
2	gynecology	F	Dr Olivia	1	125,212	41-50	Female	Trauma	Moderate	Other	4	Yes	3,398.142496	8
2	gynecology	D	Dr Nathan	2	124,174	21-30	Female	Emergency	Minor	Other	4	No	4,577.237704	8
4	gynecology	B	Dr Nathan	1	71,292	41-50	Female	Trauma	Minor	null	3	No	4,354.684454	9
4	gynecology	B	Dr Olivia	9	119,851	21-30	Female	Emergency	Moderate	Other	4	Yes	3,738.136226	9
5	radiotherapy	E	Dr Sam	10	100,780	61-70	Male	Trauma	Moderate	Other	4	No	4,657.469579	27
2	gynecology	F	Dr Nathan	1	118,419	21-30	Female	Emergency	Minor	Other	4	Yes	6,840.100999	8
3	gynecology	D	Dr Olivia	6	126,284	21-30	Female	Trauma	Moderate	Other	2	No	6,982.99866	7
2	anesthesia	A	Dr John	3	72,393	61-70	Female	Trauma	Moderate	Other	2	Yes	4,790.345489	34
3	gynecology	D	Dr Sarah	9	114,113	41-50	Female	Trauma	Minor	Asthama	3	Yes	5,126.492457	8
5	gynecology	F	Dr Sophia	5	85,946	31-40	Female	Trauma	Minor	Diabetes	4	No	7,043.170249	10
3	gynecology	D	Dr Sarah	4	26,325	41-50	Female	Trauma	Minor	High Blood Pressure	6	Yes	4,570.779395	7
4	gynecology	F	Dr Sarah	6	78,646	11-20	Female	Trauma	Moderate	Asthama	4	Yes	4,076.74204	11
2	radiotherapy	A	Dr John	10	19,894	21-30	Female	Trauma	Minor	null	4	Yes	4,294.733211	22
2	gynecology	B	Dr Sophia	3	51,628	41-50	Female	Trauma	Extreme	Diabetes	3	Yes	3,438.470772	9
2	radiotherapy	E	Dr Sam	5	127,497	41-50	Male	Urgent	Moderate	null	4	No	3,324.886336	7
4	gynecology	F	Dr Olivia	1	68,392	31-40	Female	Trauma	Moderate	Other	4	Yes	5,826.366901	10
3	gynecology	F	Dr Sophia	7	33,894	21-30	Female	Emergency	Moderate	Diabetes	3	Yes	7,258.259795	9
5	TB & Chest disease	E	Dr Mark	10	34,550	31-40	Male	Trauma	Moderate	Other	7	Yes	4,587.765113	8
2	radiotherapy	E	Dr Sam	2	99,399	51-60	Male	Trauma	Moderate	Asthama	2	Yes	4,845.33146	25
4	gynecology	B	Dr Sarah	9	27,690	31-40	Female	Trauma	Minor	High Blood Pressure	2	Yes	4,211.086772	10
2	gynecology	D	Dr Nathan	0	65,481	21-30	Female	Trauma	Extreme	Other	4	No	6,021.968834	7
2	anesthesia	E	Dr John	9	29,291	61-70	Female	Trauma	Moderate	Diabetes	2	No	5,982.226797	32
4	gynecology	D	Dr Olivia	8	125,694	31-40	Female	Trauma	Moderate	null	2	Yes	3,386.020046	8
3	radiotherapy	E	Dr John	1	18,063	41-50	Female	Emergency	Minor	null	6	Yes	4,174.479716	5
4	gynecology	F	Dr Nathan	1	40,951	21-30	Female	Emergency	Extreme	null	4	Yes	3,968.040124	9
3	radiotherapy	E	Dr John	1	10,790	31-40	Female	Emergency	Moderate	Other	3	Yes	6,441.992638	6
2	gynecology	D	Dr Nathan	10	10,868	31-40	Female	Trauma	Extreme	Other	2	Yes	4,826.991311	10
3	gynecology	B	Dr Sarah	9	128,980	31-40	Female	Trauma	Moderate	High Blood Pressure	10	Yes	5,470.305908	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.