Statistics questions

profilenancy2014
chpt_04-2.xls

DRG

ID Sex DRG DRG Categ
1 F 294 Endocrine and Nutritional
2 F 139 Heart and Circulatory
3 F 34 Nervous System
4 M 140 Heart and Circulatory
5 F 141 Heart and Circulatory
6 F 15 Nervous System
7 F 294 Endocrine and Nutritional
8 M 241 Musculoskeletal and Connective
9 M 335 Male Reproductive
10 F 148 Digestive Tract
11 F 89 Respiratory
12 M 127 Heart and Circulatory
13 M 89 Respiratory
14 F 122 Heart and Circulatory
15 M 336 Male Reproductive
16 F 321 Kidney and Urinary
17 F 174 Digestive Tract
18 F 143 Heart and Circulatory
19 F 358 Female Reproductive
20 F 140 Heart and Circulatory
21 F 143 Heart and Circulatory
22 F 159 Digestive Tract
23 M 89 Respiratory
24 F 294 Endocrine and Nutritional
25 F 473 Rehab and Aftercare
26 F 128 Heart and Circulatory
27 F 15 Nervous System
28 F 121 Heart and Circulatory
29 F 128 Heart and Circulatory
30 M 140 Heart and Circulatory
31 M 209 Musculoskeletal and Connective
32 F 143 Heart and Circulatory
33 F 209 Musculoskeletal and Connective
34 M 96 Respiratory
35 M 144 Heart and Circulatory
36 M 90 Respiratory
37 F 88 Respiratory
38 M 183 Digestive Tract
39 F 430 Mental Illness
40 F 138 Heart and Circulatory
41 F 88 Respiratory
42 F 447 Injuries and Poisoning
43 F 183 Digestive Tract
44 M 140 Heart and Circulatory
45 F 127 Heart and Circulatory
46 F 444 Injuries and Poisoning
47 F 493 Liver and Pancreas
48 F 324 Kidney and Urinary
49 F 140 Heart and Circulatory
50 F 140 Heart and Circulatory
51 M 140 Heart and Circulatory
52 F 138 Heart and Circulatory
53 M 269 Skin Disorders
54 F 140 Heart and Circulatory
55 M 208 Liver and Pancreas
56 F 15 Nervous System
57 M 434 Alcohol, Drugs
58 F 88 Respiratory
59 M 78 Respiratory
60 F 89 Respiratory
61 F 89 Respiratory
62 M 316 Kidney and Urinary
63 F 140 Heart and Circulatory
64 F 166 Digestive Tract
65 F 175 Digestive Tract
66 F 203 Liver and Pancreas
67 F 87 Respiratory
68 F 296 Endocrine and Nutritional
69 M 294 Endocrine and Nutritional
70 F 127 Heart and Circulatory
71 M 294 Endocrine and Nutritional
72 M 183 Digestive Tract
73 F 197 Liver and Pancreas
74 F 132 Heart and Circulatory
75 F 240 Musculoskeletal and Connective
76 M 182 Digestive Tract
77 M 436 Alcohol, Drugs
78 M 175 Digestive Tract
79 M 207 Liver and Pancreas
80 F 359 Female Reproductive
81 M 79 Respiratory
82 F 127 Heart and Circulatory
83 F 182 Digestive Tract
84 M 346 Male Reproductive
85 F 140 Heart and Circulatory
86 F 296 Endocrine and Nutritional
87 M 236 Musculoskeletal and Connective
88 F 122 Heart and Circulatory
89 F 90 Respiratory
90 M 89 Respiratory
91 F 296 Endocrine and Nutritional
92 F 248 Musculoskeletal and Connective
93 M 278 Skin Disorders
94 F 143 Heart and Circulatory
95 F 321 Kidney and Urinary
96 F 127 Heart and Circulatory
97 M 140 Heart and Circulatory
98 M 79 Respiratory
99 M 101 Respiratory
100 M 14 Nervous System

Late Delivery

ID Ward Reason
1 General Patient out of room Count of ID Ward
2 Geriatric Cart unavailable Reason General Geriatric Pediatric Grand Total
3 Geriatric Nursing unavailable Cart unavailable 15 4 3 22
4 Geriatric Plate warmer broken Doctor making rounds 19 7 8 34
5 Geriatric Plate warmer broken Elevator malfunction 29 8 7 44
6 General Nursing unavailable Nursing unavailable 99 45 32 176
7 General Patient asleep Other 5 2 7
8 General Patient out of room Patient asleep 19 4 5 28
9 Geriatric Nursing unavailable Patient not hungry 5 5 3 13
10 General Patient asleep Patient out of room 70 28 22 120
11 General Nursing unavailable Plate warmer broken 12 8 10 30
12 General Elevator malfunction Grand Total 273 111 90 474
13 General Patient asleep
14 General Elevator malfunction
15 Pediatric Plate warmer broken
16 General Doctor making rounds
17 General Patient out of room
18 General Nursing unavailable
19 General Patient out of room
20 Pediatric Patient asleep
21 General Nursing unavailable
22 Geriatric Patient asleep
23 General Patient out of room
24 Pediatric Doctor making rounds
25 Pediatric Doctor making rounds
26 General Patient not hungry
27 Geriatric Elevator malfunction
28 General Cart unavailable
29 Geriatric Nursing unavailable
30 General Doctor making rounds
31 General Patient out of room
32 Geriatric Nursing unavailable
33 General Patient out of room
34 Pediatric Patient out of room
35 General Patient out of room
36 Geriatric Nursing unavailable
37 General Patient out of room
38 Geriatric Doctor making rounds
39 Pediatric Patient asleep
40 General Nursing unavailable
41 General Nursing unavailable
42 General Nursing unavailable
43 Pediatric Nursing unavailable
44 General Nursing unavailable
45 General Elevator malfunction
46 General Cart unavailable
47 General Nursing unavailable
48 General Cart unavailable
49 Geriatric Patient out of room
50 General Nursing unavailable
51 General Patient out of room
52 General Nursing unavailable
53 Geriatric Elevator malfunction
54 General Patient out of room
55 General Patient out of room
56 Geriatric Patient out of room
57 General Cart unavailable
58 Pediatric Nursing unavailable
59 General Patient out of room
60 General Patient out of room
61 General Nursing unavailable
62 General Nursing unavailable
63 General Nursing unavailable
64 General Cart unavailable
65 Geriatric Plate warmer broken
66 General Patient asleep
67 Geriatric Nursing unavailable
68 Geriatric Nursing unavailable
69 General Doctor making rounds
70 Geriatric Patient asleep
71 General Elevator malfunction
72 General Elevator malfunction
73 General Nursing unavailable
74 General Patient asleep
75 Pediatric Nursing unavailable
76 Pediatric Patient out of room
77 General Elevator malfunction
78 Pediatric Nursing unavailable
79 Geriatric Patient not hungry
80 Pediatric Plate warmer broken
81 General Patient out of room
82 General Patient out of room
83 Geriatric Patient out of room
84 General Nursing unavailable
85 Geriatric Patient out of room
86 General Other
87 General Patient out of room
88 Pediatric Nursing unavailable
89 Geriatric Plate warmer broken
90 Pediatric Cart unavailable
91 Pediatric Nursing unavailable
92 Geriatric Nursing unavailable
93 Pediatric Nursing unavailable
94 General Patient out of room
95 General Patient out of room
96 General Nursing unavailable
97 General Nursing unavailable
98 Pediatric Patient out of room
99 Geriatric Nursing unavailable
100 Geriatric Patient out of room
101 Geriatric Nursing unavailable
102 Pediatric Patient out of room
103 General Cart unavailable
104 General Elevator malfunction
105 General Elevator malfunction
106 General Patient asleep
107 General Nursing unavailable
108 General Elevator malfunction
109 General Nursing unavailable
110 General Patient out of room
111 General Nursing unavailable
112 Geriatric Elevator malfunction
113 Geriatric Patient out of room
114 General Nursing unavailable
115 General Patient out of room
116 Geriatric Cart unavailable
117 General Nursing unavailable
118 Geriatric Plate warmer broken
119 Geriatric Patient out of room
120 Geriatric Elevator malfunction
121 General Patient asleep
122 Pediatric Plate warmer broken
123 Pediatric Nursing unavailable
124 Pediatric Nursing unavailable
125 General Doctor making rounds
126 Pediatric Doctor making rounds
127 Pediatric Elevator malfunction
128 Pediatric Nursing unavailable
129 General Doctor making rounds
130 Geriatric Nursing unavailable
131 Geriatric Patient out of room
132 General Nursing unavailable
133 General Doctor making rounds
134 Pediatric Patient out of room
135 General Cart unavailable
136 General Nursing unavailable
137 Pediatric Nursing unavailable
138 General Doctor making rounds
139 General Patient asleep
140 General Patient out of room
141 General Nursing unavailable
142 Pediatric Nursing unavailable
143 General Patient out of room
144 General Nursing unavailable
145 Pediatric Doctor making rounds
146 Geriatric Nursing unavailable
147 Pediatric Doctor making rounds
148 General Nursing unavailable
149 General Elevator malfunction
150 Geriatric Nursing unavailable
151 General Patient out of room
152 General Other
153 Geriatric Patient out of room
154 Geriatric Patient out of room
155 General Nursing unavailable
156 Geriatric Elevator malfunction
157 Geriatric Patient out of room
158 General Nursing unavailable
159 General Doctor making rounds
160 General Patient out of room
161 General Elevator malfunction
162 General Plate warmer broken
163 General Patient out of room
164 General Doctor making rounds
165 Pediatric Elevator malfunction
166 Geriatric Doctor making rounds
167 Geriatric Nursing unavailable
168 Geriatric Doctor making rounds
169 General Nursing unavailable
170 General Patient out of room
171 Geriatric Patient out of room
172 Pediatric Doctor making rounds
173 General Patient asleep
174 General Nursing unavailable
175 Pediatric Patient out of room
176 Pediatric Nursing unavailable
177 General Nursing unavailable
178 General Patient out of room
179 General Nursing unavailable
180 General Nursing unavailable
181 General Elevator malfunction
182 General Plate warmer broken
183 General Patient not hungry
184 General Patient out of room
185 Geriatric Patient out of room
186 General Nursing unavailable
187 General Nursing unavailable
188 General Patient out of room
189 General Nursing unavailable
190 General Patient out of room
191 Pediatric Elevator malfunction
192 General Nursing unavailable
193 General Doctor making rounds
194 Geriatric Nursing unavailable
195 Pediatric Patient out of room
196 Geriatric Nursing unavailable
197 General Doctor making rounds
198 General Nursing unavailable
199 Pediatric Elevator malfunction
200 General Cart unavailable
201 Geriatric Nursing unavailable
202 Pediatric Patient asleep
203 Geriatric Patient out of room
204 General Nursing unavailable
205 General Nursing unavailable
206 General Nursing unavailable
207 General Patient out of room
208 General Elevator malfunction
209 Pediatric Nursing unavailable
210 General Plate warmer broken
211 Pediatric Nursing unavailable
212 General Patient out of room
213 General Patient out of room
214 General Nursing unavailable
215 General Patient out of room
216 General Cart unavailable
217 General Nursing unavailable
218 General Nursing unavailable
219 General Elevator malfunction
220 Pediatric Nursing unavailable
221 General Patient out of room
222 General Nursing unavailable
223 General Nursing unavailable
224 General Nursing unavailable
225 General Nursing unavailable
226 General Patient out of room
227 General Patient out of room
228 General Patient out of room
229 General Elevator malfunction
230 General Patient out of room
231 Geriatric Patient not hungry
232 Pediatric Patient out of room
233 Pediatric Plate warmer broken
234 Geriatric Nursing unavailable
235 General Doctor making rounds
236 Pediatric Doctor making rounds
237 General Elevator malfunction
238 General Patient out of room
239 Geriatric Nursing unavailable
240 General Nursing unavailable
241 Geriatric Nursing unavailable
242 General Patient asleep
243 Pediatric Patient out of room
244 General Doctor making rounds
245 Geriatric Nursing unavailable
246 Pediatric Nursing unavailable
247 Pediatric Plate warmer broken
248 Pediatric Patient out of room
249 Geriatric Patient out of room
250 Pediatric Nursing unavailable
251 General Nursing unavailable
252 General Nursing unavailable
253 General Cart unavailable
254 General Plate warmer broken
255 General Patient out of room
256 General Nursing unavailable
257 Pediatric Patient asleep
258 General Elevator malfunction
259 Geriatric Plate warmer broken
260 Geriatric Patient out of room
261 Geriatric Doctor making rounds
262 Geriatric Nursing unavailable
263 General Nursing unavailable
264 General Other
265 General Nursing unavailable
266 General Nursing unavailable
267 Geriatric Patient out of room
268 General Nursing unavailable
269 General Doctor making rounds
270 General Nursing unavailable
271 General Patient out of room
272 General Patient not hungry
273 Geriatric Patient out of room
274 General Elevator malfunction
275 General Nursing unavailable
276 General Other
277 General Patient out of room
278 General Nursing unavailable
279 Geriatric Plate warmer broken
280 General Nursing unavailable
281 Geriatric Nursing unavailable
282 General Patient out of room
283 General Nursing unavailable
284 General Nursing unavailable
285 Pediatric Plate warmer broken
286 Pediatric Nursing unavailable
287 Geriatric Nursing unavailable
288 General Patient out of room
289 Geriatric Nursing unavailable
290 Geriatric Patient out of room
291 General Patient out of room
292 Pediatric Cart unavailable
293 Pediatric Patient asleep
294 Geriatric Nursing unavailable
295 Geriatric Nursing unavailable
296 General Nursing unavailable
297 General Patient asleep
298 Geriatric Nursing unavailable
299 Geriatric Nursing unavailable
300 General Patient asleep
301 General Cart unavailable
302 Geriatric Patient not hungry
303 General Patient asleep
304 General Nursing unavailable
305 General Nursing unavailable
306 Geriatric Nursing unavailable
307 Geriatric Patient out of room
308 General Nursing unavailable
309 Pediatric Patient out of room
310 General Nursing unavailable
311 Geriatric Nursing unavailable
312 General Patient out of room
313 Geriatric Nursing unavailable
314 Geriatric Nursing unavailable
315 General Patient out of room
316 General Elevator malfunction
317 Geriatric Patient not hungry
318 General Patient out of room
319 General Patient out of room
320 Geriatric Patient out of room
321 General Nursing unavailable
322 General Patient asleep
323 General Patient out of room
324 Geriatric Patient out of room
325 General Nursing unavailable
326 General Patient out of room
327 General Patient out of room
328 Pediatric Plate warmer broken
329 Pediatric Patient out of room
330 General Nursing unavailable
331 Geriatric Patient out of room
332 Pediatric Nursing unavailable
333 General Elevator malfunction
334 Geriatric Patient out of room
335 Pediatric Patient out of room
336 General Patient asleep
337 General Patient not hungry
338 Pediatric Nursing unavailable
339 General Patient not hungry
340 Pediatric Nursing unavailable
341 Geriatric Patient out of room
342 General Nursing unavailable
343 General Cart unavailable
344 General Nursing unavailable
345 General Nursing unavailable
346 Geriatric Nursing unavailable
347 Pediatric Nursing unavailable
348 General Cart unavailable
349 Geriatric Elevator malfunction
350 General Nursing unavailable
351 Geriatric Patient out of room
352 General Patient out of room
353 Geriatric Plate warmer broken
354 Pediatric Nursing unavailable
355 Geriatric Other
356 Pediatric Patient out of room
357 General Doctor making rounds
358 Geriatric Patient asleep
359 General Nursing unavailable
360 Geriatric Nursing unavailable
361 Geriatric Nursing unavailable
362 Pediatric Elevator malfunction
363 General Elevator malfunction
364 Geriatric Nursing unavailable
365 General Patient out of room
366 Pediatric Patient out of room
367 Geriatric Patient out of room
368 Pediatric Cart unavailable
369 General Nursing unavailable
370 Geriatric Nursing unavailable
371 Pediatric Plate warmer broken
372 General Elevator malfunction
373 General Nursing unavailable
374 Geriatric Nursing unavailable
375 General Nursing unavailable
376 General Patient out of room
377 General Plate warmer broken
378 General Elevator malfunction
379 General Patient out of room
380 Geriatric Cart unavailable
381 General Patient asleep
382 Pediatric Elevator malfunction
383 General Nursing unavailable
384 Pediatric Nursing unavailable
385 Geriatric Nursing unavailable
386 Geriatric Nursing unavailable
387 General Patient out of room
388 General Plate warmer broken
389 General Cart unavailable
390 Pediatric Patient out of room
391 General Patient out of room
392 General Plate warmer broken
393 Pediatric Patient out of room
394 General Elevator malfunction
395 General Nursing unavailable
396 General Nursing unavailable
397 General Plate warmer broken
398 Pediatric Patient not hungry
399 General Plate warmer broken
400 General Patient asleep
401 Pediatric Patient not hungry
402 General Patient out of room
403 Geriatric Cart unavailable
404 General Other
405 General Nursing unavailable
406 General Plate warmer broken
407 General Nursing unavailable
408 General Nursing unavailable
409 General Nursing unavailable
410 Pediatric Nursing unavailable
411 Geriatric Patient asleep
412 Geriatric Nursing unavailable
413 General Patient out of room
414 General Nursing unavailable
415 General Nursing unavailable
416 Pediatric Nursing unavailable
417 General Patient out of room
418 Pediatric Patient not hungry
419 General Elevator malfunction
420 Geriatric Patient not hungry
421 General Patient asleep
422 General Patient out of room
423 Pediatric Nursing unavailable
424 Pediatric Doctor making rounds
425 General Nursing unavailable
426 Geriatric Elevator malfunction
427 Geriatric Doctor making rounds
428 General Plate warmer broken
429 General Nursing unavailable
430 General Nursing unavailable
431 General Patient out of room
432 General Nursing unavailable
433 Pediatric Nursing unavailable
434 General Elevator malfunction
435 General Doctor making rounds
436 Geriatric Elevator malfunction
437 General Elevator malfunction
438 General Doctor making rounds
439 General Patient out of room
440 General Doctor making rounds
441 Pediatric Elevator malfunction
442 Pediatric Nursing unavailable
443 Pediatric Patient out of room
444 Pediatric Patient out of room
445 Pediatric Patient out of room
446 General Nursing unavailable
447 Pediatric Nursing unavailable
448 General Patient out of room
449 General Elevator malfunction
450 General Patient asleep
451 General Doctor making rounds
452 General Nursing unavailable
453 Pediatric Plate warmer broken
454 General Plate warmer broken
455 Geriatric Nursing unavailable
456 Pediatric Nursing unavailable
457 General Patient out of room
458 Geriatric Patient out of room
459 General Elevator malfunction
460 Pediatric Patient out of room
461 General Nursing unavailable
462 Geriatric Doctor making rounds
463 General Nursing unavailable
464 General Patient out of room
465 Geriatric Nursing unavailable
466 Pediatric Plate warmer broken
467 General Cart unavailable
468 Geriatric Nursing unavailable
469 General Nursing unavailable
470 General Patient out of room
471 General Nursing unavailable
472 Geriatric Other
473 Geriatric Doctor making rounds
474 Pediatric Patient out of room