Spreadsheet: 181038d1347902212-exclude-values-from-vlookup-test-first-focus
Sheet: Source

 |  | Facility Involved | Event Report Number | Event Date | Time Event Occurred (Military Time: e.g., 0900) If Unknown enter 0000 | Date of Birth (MM/DD/YYYY) | Nature of the Event | FINAL EVENT Severity | Narrative Description (500 Characters Maximum) | Follow up comments by all managers involved | Risk Manager Comments | Record ID | Age |  |  |  | Nature of the Event
1 |  | Hospital | _0136614 | 2012-07-20 00:00:00 | 1550 | 1961-03-18 00:00:00 | Equipment / Device / Catheter | E - Treatment/intervention - (3) Significant | Something | stuff happened | person | 106206 |  |  |  | ADR | Adverse Drug Reaction
2 |  | Hospital | _0136799 | 2012-07-24 00:00:00 | 650 | 1943-02-09 00:00:00 | Fall | 3 - Tests, injury ruled out - Minor | Something else | something else happened |  | 106370 |  |  |  | Equip/Device | Equipment / Device / Catheter
3 |  | Hospital | _0136651 | 2012-07-21 00:00:00 | 1945 | 1959-07-12 00:00:00 | Fall | 2 - Minor injury, no tests - Minor | more | stuff happened |  | 106241 |  |  |  | Fall | Fall
4 |  | Hospital | _0136662 | 2012-07-22 00:00:00 | 715 | 1936-12-12 00:00:00 | IV Access / Blood Transfusion | 4+ Infiltration of any amount of vesicant - Significant | a bunch | something else happened |  | 106252 |  |  |  | IV/Blood | IV Access / Blood Transfusion
5 |  | Hospital | _0136727 | 2012-07-23 00:00:00 | 1100 | 1931-06-21 00:00:00 | IV Access / Blood Transfusion | 4+ Infiltration of any amount of irritant - Significant | stuff | stuff happened |  | 106306 |  |  |  | Med Event | Medication Event
6 |  | Hospital | _0136728 | 2012-07-23 00:00:00 | 1630 | 1947-03-31 00:00:00 | IV Access / Blood Transfusion | 4+ Infiltration of any amount of irritant - Significant | had med | something else happened |  | 106307 |  |  |  | Misc | Misc / Delivery of Care / Testing Related
7 |  | Hospital | _0136837 | 2012-07-24 00:00:00 | 1430 | 1937-10-07 00:00:00 | IV Access / Blood Transfusion | 4+ Infiltration of any amount of irritant - Significant | had IV | stuff happened |  | 106409 |  |  |  | OB/Newborn | OB/Newborn
8 |  | Hospital | _0136904 | 2012-07-26 00:00:00 | 1530 | 1963-09-10 00:00:00 | IV Access / Blood Transfusion | 4+ Infiltration of any amount of irritant - Significant | something hurt | something else happened | person | 106468 |  |  |  | [NAME] | Outpatient Fall
9 |  | Hospital | _0136895 | 2012-07-26 00:00:00 | 1405 | 1955-11-18 00:00:00 | IV Access / Blood Transfusion | 2+ Skin blanched; edema 1-6 inches | had IV |  |  | 106459 |  |  |  | Security | Security / Personal Property
10 |  | Hospital | _0136808 | 2012-07-25 00:00:00 | 309 | 1942-01-10 00:00:00 | IV Access / Blood Transfusion | 2- Minor | Something else | something else happened |  | 106380 |  |  |  | NPU/[NAME] | [NAME] / Pressure Ulcer
11 |  | Hospital | _0136863 | 2012-07-25 00:00:00 | 1700 | 1962-10-13 00:00:00 | IV Access / Blood Transfusion | 2- Minor | more | stuff happened |  | 106434 |  |  |  | Surgery/Prc | Surgery / Invasive Procedure
12 |  | Hospital | _0136935 | 2012-07-26 00:00:00 | 332 | 1929-04-17 00:00:00 | IV Access / Blood Transfusion | 2- Minor | a bunch | something else happened |  | 106497 |  |  |  | Visitor Fall | [NAME]
13 |  | Hospital | _0136583 | 2012-07-20 00:00:00 | 1415 | 1947-07-12 00:00:00 | Medication Event | C - Did not cause harm - (2) Minor | stuff | stuff happened |  | 106174
14 |  | Hospital | _0136589 | 2012-07-20 00:00:00 | 1130 | 1994-10-16 00:00:00 | Medication Event | C - Did not cause harm - (2) Minor | had med |  |  | 106181
15 |  | Hospital | _0136825 | 2012-07-24 00:00:00 | 1200 | 1944-07-24 00:00:00 | Medication Event | C - Did not cause harm - (2) Minor | had IV | something else happened |  | 106397
16 |  | Hospital | _0136841 | 2012-07-25 00:00:00 | 1410 | 1994-08-18 00:00:00 | Medication Event | C - Did not cause harm - (2) Minor | something hurt |  | somebody else | 106413
17 |  | Hospital | _0136611 | 2012-07-20 00:00:00 | 0 | 1966-07-10 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | had IV | something else happened |  | 106203
18 |  | Hospital | _0136617 | 2012-07-20 00:00:00 | 2000 | 1957-11-03 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | Something else | something else happened |  | 106209
19 |  | Hospital | _0136620 | 2012-07-20 00:00:00 | 2000 | 1957-11-03 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | more | stuff happened |  | 106212
20 |  | Hospital | _0136623 | 2012-07-20 00:00:00 | 2000 | 1952-04-29 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | a bunch | something else happened |  | 106214
21 |  | Hospital | _0136625 | 2012-07-21 00:00:00 | 300 | 1936-06-26 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | stuff | stuff happened |  | 106217
22 |  | Hospital | _0136705 | 2012-07-20 00:00:00 | 1300 | 1920-11-21 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | had med | something else happened |  | 106286
23 |  | Hospital | _0136725 | 2012-07-23 00:00:00 | 1550 | 1931-05-14 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | had IV | stuff happened | somebody else | 106305
24 |  | Hospital | _0136844 | 2012-07-25 00:00:00 | 1620 | 1950-03-24 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | something hurt | something else happened |  | 106416
25 |  | Hospital | _0136862 | 2012-07-25 00:00:00 | 0 | 1943-02-21 00:00:00 | Medication Event | B - Identified before reached patient - (1) No Known Injury | had IV | stuff happened |  | 106433
26 |  | Hospital | _0136618 | 2012-07-20 00:00:00 | 2000 | 1957-11-03 00:00:00 | Medication Event | A - Potential event - (1) No Known Injury | Something else | something else happened |  | 106210
27 |  | Hospital | _0136744 | 2012-07-23 00:00:00 | 1500 | 1937-09-17 00:00:00 | Medication Event | A - Potential event - (1) No Known Injury | more | stuff happened |  | 106324
28 |  | Hospital | _0136745 | 2012-07-23 00:00:00 | 2000 | 1937-03-17 00:00:00 | Medication Event | A - Potential event - (1) No Known Injury | a bunch | something else happened |  | 106325
29 |  | Hospital | _0136746 | 2012-07-23 00:00:00 | 0 | 1957-02-16 00:00:00 | Medication Event | A - Potential event - (1) No Known Injury | stuff | stuff happened |  | 106326
30 |  | Hospital | _0136791 | 2012-07-24 00:00:00 | 1100 | 1937-03-17 00:00:00 | Medication Event | A - Potential event - (1) No Known Injury | had med | something else happened |  | 106365
31 |  | Hospital | _0136839 | 2012-07-25 00:00:00 | 1110 | 1965-03-20 00:00:00 | Misc / Delivery of Care / Testing Related | 3- Significant | had IV | stuff happened | person | 106411
32 |  | Hospital | _0136842 | 2012-07-25 00:00:00 | 1610 | 1988-10-18 00:00:00 | Misc / Delivery of Care / Testing Related | 2- Minor | something hurt |  |  | 106414
33 |  | Hospital | _0136631 | 2012-07-21 00:00:00 | 1000 | 1936-01-17 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | had IV | something else happened | somebody else | 106223
34 |  | Hospital | _0136646 | 2012-07-21 00:00:00 | 1800 | 1985-08-25 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | Something else | stuff happened |  | 106236
35 |  | Hospital | _0136658 | 2012-07-22 00:00:00 | 545 | 1955-11-02 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | more | something else happened | person | 106249
36 |  | Hospital | _0136756 | 2012-07-24 00:00:00 | 330 | 1931-02-10 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | a bunch | stuff happened | somebody else | 106334
37 |  | Hospital | _0136826 | 2012-07-20 00:00:00 | 835 | 1995-02-21 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | stuff | something else happened |  | 106398
38 |  | Hospital | _0136831 | 2012-07-24 00:00:00 | 1155 | 1938-04-11 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | had med | stuff happened |  | 106403
39 |  | Hospital | _0136835 | 2012-07-25 00:00:00 | 1400 | 1941-05-09 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | had IV | something else happened |  | 106407
40 |  | Hospital | _0136883 | 2012-07-25 00:00:00 | 0 | 1961-07-08 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | something hurt | stuff happened |  | 106450
41 |  | Hospital | _0136896 | 2012-07-26 00:00:00 | 1415 | 1928-02-08 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | had IV | something else happened |  | 106460
42 |  | Hospital | _0136934 | 2012-07-24 00:00:00 | 0 | 1939-01-08 00:00:00 | Misc / Delivery of Care / Testing Related | 1- No injury | had IV | stuff happened |  | 106496
43 |  | Hospital | _0136641 | 2012-07-21 00:00:00 | 1535 | 2012-07-19 00:00:00 | OB/Newborn | 1- No injury | something hurt | something else happened |  | 106232
44 |  | Hospital | _0136659 | 2012-07-22 00:00:00 | 547 | 1983-05-30 00:00:00 | OB/Newborn | 1- No injury | had IV | stuff happened |  | 106248
45 |  | Hospital | _0136687 | 2012-07-22 00:00:00 | 1740 | 1954-04-15 00:00:00 | Security / Personal Property | A - Potential event - (1) No Known Injury | had to call security | something else happened |  | 106270
46 |  | Hospital | _0136698 | 2012-07-23 00:00:00 | 204 | 1974-02-23 00:00:00 | Security / Personal Property | A - Potential event - (1) No Known Injury | bad person stuff | stuff happened |  | 106280
47 |  | Hospital | _0136743 | 2012-07-23 00:00:00 | 2330 | 1965-03-20 00:00:00 | Security / Personal Property | A - Potential event - (1) No Known Injury | helped issue |  |  | 106323
48 |  | Hospital | _0136753 | 2012-07-24 00:00:00 | 320 | 1974-02-23 00:00:00 | Security / Personal Property | A - Potential event - (1) No Known Injury | had a nasty person issue | stuff happened |  | 106330
49 |  | Hospital | _0136781 | 2012-07-24 00:00:00 | 1236 | 1992-12-17 00:00:00 | Security / Personal Property | A - Potential event - (1) No Known Injury | bad person stuff |  |  | 106356
50 |  | Hospital | _0136889 | 2012-07-25 00:00:00 | 1515 | 1964-04-22 00:00:00 | Surgery / Invasive Procedure | 1- No injury | ouch |  |  | 106455
51 |  | Hospital | _0136911 | 2012-07-26 00:00:00 | 1830 | 1932-03-19 00:00:00 | Surgery / Invasive Procedure | 1- No injury | something bad happened |  |  | 106475
52 |  | Hospital | _0136859 | 2012-07-25 00:00:00 | 1850 |  | [NAME] | 5 - Fracture/serious injury - Significant | person fell |  |  | 106430
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250