Spreadsheet: 845152d1696675410-creating-a-report-to-display-missing-data-raw-data-copy
Sheet: Tracker

Ref | First Name(s) | Last Name | Date of event | NameA | NameA Report received | NameB | NameB Report received | [NAME] | [NAME] | ReportF Received |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File type | File status | Option | Pathologist | Toxicologist | Police | Ambulance | Clinicians | Additional
1 | FirstName1 | LastName1 | 2023-06-08 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inquest | Pending | Yes | Dr [NAME] | Dr Armitage | DC 281 | 3294 | CTMUHB | EMRTS
2 | FirstName2 | [NAME] | 2022-12-08 00:00:00 | [NAME] |  | Suzie | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Investigation | Suspended | No | Dr Barlow | Dr [NAME] | DC 627 | 6087 | CTUHB | Fire
3 | FirstName3 | LastName3 | 2022-07-12 00:00:00 | [NAME] | 2023-05-03 00:00:00 | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fast track inquest | Discontinued | NA | Dr [NAME] | Dr [NAME] | DC 771/ DC 627 | 6350 | PTUHB | HSE
4 | FirstName4 | LastName4 | 2023-03-29 00:00:00 | Wayne | 2023-06-02 00:00:00 | Julie | NA | 2023-04-25 00:00:00 | 2023-05-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr [NAME] | Dr [NAME] | DC 857 | 6578 | RSH | P Phillips
5 | FirstName5 | LastName5 | 2023-06-06 00:00:00 | Wayne |  | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Dallman | [NAME] | DS 527 | 6671 | SATH | [NAME]
6 | FirstName6 | LastName6 | 2023-01-17 00:00:00 | [NAME] |  | NA | NA | 2012-01-25 00:00:00 | 2023-02-28 00:00:00 | 2023-01-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr DeVries | Dr Reed | PC 1002 | 11749 | [NAME] | PC 5763
7 | FirstName7 | LastName7 | 2022-10-19 00:00:00 | [NAME] | 2022-10-20 00:00:00 | NA | NA | 2022-10-28 00:00:00 | 2022-11-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Hopkins | J Duffy | PC 1026 | 15712 | UHNM | S Dugay
8 | FirstName8 | [NAME] | 2022-10-19 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Jones | J Winfield | PC 1041 | 5833369 | UHW | NA
9 | FirstName9 | LastName9 | 2023-04-12 00:00:00 | [NAME] | 2023-04-25 00:00:00 | Julie | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr [NAME] | N Seaward | PC 1082 | Fire | UWH
10 | FirstName10 | LastName10 | NA | NA | NA | NA | NA | 2023-01-20 00:00:00 | 2023-02-20 00:00:00 | 2023-01-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Lord | NA | PC 1126 | PA45099 | NA
11 | FirstName11 | [NAME] | NA | NA | NA | NA | NA | 2023-01-27 00:00:00 | 2023-03-15 00:00:00 | 2023-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr [NAME] |  | PC 1216 | NA
12 | FirstName12 | LastName12 | 2023-05-09 00:00:00 | [NAME] |  | [NAME] | 2023-06-08 00:00:00 | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Morgan |  | PC 1217
13 | FirstName13 | LastName13 | 2023-04-05 00:00:00 | [NAME] |  | Julie | 2023-04-24 00:00:00 | 2023-04-20 00:00:00 | 2023-05-20 00:00:00 | 2023-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Muzaffer |  | PC 1222
14 | FirstName14 | LastName14 | NA | NA | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Potter |  | PC 1235
15 | FirstName15 | LastName15 | 2022-10-24 00:00:00 | [NAME] | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Shannon |  | PC 1255
16 | FirstName16 | [NAME] | 2023-01-25 00:00:00 | [NAME] | NA | NA | NA | 2023-02-22 00:00:00 | 2023-03-31 00:00:00 | 2023-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr [NAME] |  | PC 1274
17 | FirstName17 | LastName17 | 2023-05-25 00:00:00 | [NAME] | NA | NA | NA | 2023-06-04 00:00:00 | 2023-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr Sundaresan |  | PC 1308
18 | FirstName18 | LastName18 | 2022-09-27 00:00:00 | [NAME] | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr [NAME] |  | PC 149
19 | FirstName19 | LastName19 | 2023-05-02 00:00:00 | [NAME] | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA |  | PC 302
20 | FirstName20 | LastName20 | 2022-07-21 00:00:00 | [NAME] | NA | NA | NA | 2022-07-28 00:00:00 | 2022-08-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 304
21 | FirstName21 | LastName21 | 2023-05-24 00:00:00 | Rachel | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 34
22 | FirstName22 | LastName22 | 2023-02-17 00:00:00 | [NAME] |  | Julie | 2023-03-07 00:00:00 | 2023-02-10 00:00:00 | 2023-04-10 00:00:00 | 2023-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 382
23 | FirstName23 | [NAME] | 2022-08-15 00:00:00 | [NAME] | 2022-08-02 00:00:00 | [NAME] | 2022-05-23 00:00:00 | 2022-01-11 00:00:00 | 2022-02-11 00:00:00 | 2022-01-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 421
24 | FirstName24 | LastName24 | 2022-06-17 00:00:00 | [NAME] | 2023-03-23 00:00:00 | Julie | 2023-07-04 00:00:00 | 2022-09-23 00:00:00 | 2022-10-16 00:00:00 | 2022-10-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 474
25 | FirstName25 | LastName25 | 2023-03-16 00:00:00 | Wayne | 2023-04-19 00:00:00 | Julie | 2023-04-03 00:00:00 | 2023-05-05 00:00:00 | 2023-06-05 00:00:00 | 2023-05-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 520
26 | FirstName26 | LastName26 | 2022-08-15 00:00:00 | Doug | 2023-04-11 00:00:00 | NA | NA | 2022-08-25 00:00:00 | 2022-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 523
27 | FirstName27 | LastName27 | 2023-02-17 00:00:00 | [NAME] |  | Julie | 2023-03-15 00:00:00 | 2023-02-22 00:00:00 | 2023-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 540
28 | FirstName28 | LastName28 | NA | NA | NA | NA | NA | 2023-02-08 00:00:00 | 2023-03-31 00:00:00 | 2023-02-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 613
29 | FirstName29 | LastName29 | 2023-02-24 00:00:00 | [NAME] | 2023-03-07 00:00:00 | NA | NA | 2023-03-13 00:00:00 | 2023-04-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 715
30 | FirstName30 | LastName30 | 2022-11-30 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 852
31 | FirstName31 | LastName31 | 2023-05-17 00:00:00 | Wayne |  | Nicola | 2023-06-08 00:00:00 | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 901
32 | FirstName32 | [NAME] | NA | NA | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 914
33 | FirstName33 | LastName33 | NA | NA | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 916
34 | FirstName34 | LastName34 | 2022-02-03 00:00:00 | [NAME] |  | Julie | 2022-03-09 00:00:00 | 2022-02-09 00:00:00 | 2022-03-09 00:00:00 | 2022-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC 972
35 | FirstName35 | LastName35 | NA | NA | NA | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PS 453
36 | FirstName36 | LastName36 | 2023-03-02 00:00:00 | [NAME] | 2023-03-07 00:00:00 | NA | NA | 2023-03-14 00:00:00 | 2023-04-20 00:00:00 | 2023-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PS 729
37 | FirstName37 | LastName37 | 2023-06-08 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA
38 | FirstName38 | LastName38 | 2022-12-08 00:00:00 | Lyn | 2023-02-03 00:00:00 | Julie | 2023-01-06 00:00:00 | 2023-02-22 00:00:00 | 2023-03-31 00:00:00 | 2023-01-26 00:00:00
39 | FirstName39 | LastName39 | 2022-02-24 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA
40 | FirstName40 | LastName40 | 2022-01-31 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA
41 | FirstName41 | LastName41 | 2023-04-21 00:00:00 | Rachel |  | Justin | 2023-05-11 00:00:00 | NA | NA | NA
42 | FirstName42 | LastName42 | NA | NA | NA | NA | NA | NA | NA | NA
43 | FirstName43 | LastName43 | 2023-01-18 00:00:00 | [NAME] | 2023-04-19 00:00:00 | NA | NA | 2023-06-15 00:00:00 | 2023-07-27 00:00:00
44 | FirstName44 | LastName44 | 2022-11-24 00:00:00 | [NAME] |  | Julie | 2022-12-02 00:00:00 | 2022-12-13 00:00:00 | 2023-01-15 00:00:00
45 | FirstName45 | [NAME] | NA | NA | NA | NA | NA | 2022-12-14 00:00:00 | 2023-01-30 00:00:00 | 2023-01-18 00:00:00
46 | FirstName46 | LastName46 | 2022-06-28 00:00:00 | [NAME] | 2023-02-25 00:00:00 | Nicola | 2022-07-15 00:00:00 | NA | NA | NA
47 | FirstName47 | [NAME] | 2022-09-14 00:00:00 | [NAME] |  | Julie | 2022-09-29 00:00:00 | 2022-09-16 00:00:00 | 2022-10-22 00:00:00
48 | FirstName48 | LastName48 | 2023-07-18 00:00:00 | [NAME] | 2023-05-04 00:00:00 | Julie | 2022-08-12 00:00:00 | 2023-05-22 00:00:00 | 2002-07-03 00:00:00
49 | FirstName49 | LastName49 | 2022-06-10 00:00:00 | [NAME] | 2022-12-02 00:00:00 | Justin | 2022-07-19 00:00:00 | 2022-06-14 00:00:00 | 2022-07-30 00:00:00 | 2022-06-16 00:00:00
50 | FirstName50 | LastName50 | NA | NA | NA | NA | NA | 2023-02-27 00:00:00 | 2023-03-31 00:00:00
51 | FirstName51 | LastName51 | 2023-02-22 00:00:00 | [NAME] | 2023-03-13 00:00:00 | Julie | 2023-03-07 00:00:00 | 2023-02-27 00:00:00 | 2023-03-31 00:00:00
52 | FirstName52 | LastName52 | 2023-03-30 00:00:00 | Lyn | 2023-05-11 00:00:00 | Julie | 2023-04-19 00:00:00 | 2023-04-25 00:00:00 | 2023-05-25 00:00:00 | 2023-05-09 00:00:00
53 | FirstName53 | LastName53 | 2022-08-12 00:00:00 | [NAME] | 2023-05-16 00:00:00 | Justin | 2022-09-12 00:00:00 | 2022-08-24 00:00:00 | 2022-09-30 00:00:00 | 2022-09-07 00:00:00
54 | [NAME] | LastName54 | NA | NA | NA | NA | NA | NA | NA | NA
55 | FirstName55 | LastName55 | 2023-01-16 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA
56 | FirstName56 | LastName56 | 2023-05-18 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA
57 | FirstName57 | LastName57 | 2023-02-02 00:00:00 | Wayne | 2023-05-06 00:00:00 | Julie | 2023-02-20 00:00:00 | 2023-02-08 00:00:00 | 2023-03-08 00:00:00 | 2023-02-16 00:00:00
58 | FirstName58 | [NAME] | NA | NA | NA | NA | NA | NA | NA | NA
59 | FirstName59 | LastName59 | 2023-03-22 00:00:00 | [NAME] |  | NA | NA | 2023-04-26 00:00:00 | 2023-05-26 00:00:00 | 2023-05-02 00:00:00
60 | FirstName60 | LastName60 | 2022-10-13 00:00:00 | [NAME] |  | Julie | 2022-10-31 00:00:00 | NA | NA | NA
61 | FirstName61 | LastName61 | 2021-07-13 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA
62 | FirstName62 | LastName62 | 2023-06-08 00:00:00 | [NAME] | 2023-06-13 00:00:00 | N/A | N/A | 2023-06-15 00:00:00 | 2023-07-27 00:00:00
63 | FirstName63 | LastName63 | 2023-03-31 00:00:00 | [NAME] |  | Nicola | 2023-04-19 00:00:00 | NA | NA | NA
64 | FirstName64 | LastName64 | NA | NA | NA | NA | NA | NA | NA | NA
65 | [NAME] | [NAME] | 2023-04-21 00:00:00 | Rachel |  | Julie | 2023-05-17 00:00:00 | 2023-05-04 00:00:00 | 2023-06-04 00:00:00 | 2023-05-26 00:00:00
66 | FirstName66 | LastName66 | 2022-09-14 00:00:00 | [NAME] | 2023-05-16 00:00:00 | NA | NA | NA | NA | NA
67 | FirstName67 | LastName67 | NA | NA | NA | NA | NA | NA | NA | NA
68 | FirstName68 | LastName68 | 2023-03-14 00:00:00 | [NAME] |  | NA | NA | 2023-04-27 00:00:00 | 2023-05-27 00:00:00
69 | FirstName69 | LastName69 | 2023-01-31 00:00:00 | [NAME] |  | Julie | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-04-04 00:00:00
70 | FirstName70 | LastName70 | 2023-01-27 00:00:00 | [NAME] |  | [NAME] | 2023-02-22 00:00:00 | 2023-02-22 00:00:00 | 2023-03-31 00:00:00 | 2023-03-07 00:00:00
71 | FirstName71 | LastName71 | 2023-01-27 00:00:00 | [NAME] |  | [NAME] | 2023-02-23 00:00:00 | 2023-02-22 00:00:00 | 2023-03-31 00:00:00 | 2023-03-07 00:00:00
72 | FirstName72 | LastName72 | 2023-04-19 00:00:00 | [NAME] |  | [NAME] | 2023-05-11 00:00:00 | NA | NA | NA
73 | FirstName73 | LastName73 | 2022-04-29 00:00:00 | [NAME] | 2022-05-05 00:00:00 | Julie | 2022-05-12 00:00:00 | 2022-05-11 00:00:00 | 2022-06-11 00:00:00 | 2022-05-12 00:00:00
74 | FirstName74 | LastName74 | 2023-05-11 00:00:00 | [NAME] |  | NA | NA | 2023-05-22 00:00:00 | 2023-07-03 00:00:00
75 | FirstName75 | LastName75 | NA | NA | NA | NA | NA | 2023-05-18 00:00:00 | 2023-06-18 00:00:00
76 | FirstName76 | LastName76 | 2022-11-02 00:00:00 | [NAME] |  | NA | NA | NA | NA | NA
77 | FirstName77 | LastName77 | 2022-08-02 00:00:00 | [NAME] | 2023-04-24 00:00:00 | Julie | 2022-08-25 00:00:00 | 2023-06-01 00:00:00 | 2023-06-15 00:00:00 | 2023-06-15 00:00:00
78 | FirstName78 | LastName78 | 2023-05-04 00:00:00 | [NAME] |  | Justin | 2023-05-25 00:00:00 | NA | NA | NA
79 | FirstName79 | LastName79 | NA | NA | NA | NA | NA | NA | NA | NA
80 | FirstName80 | LastName80 | 2023-03-01 00:00:00 | [NAME] | 2023-04-19 00:00:00 | NA | NA | NA | NA | NA
81 | FirstName81 | LastName81 | 2022-10-07 00:00:00 | [NAME] |  | Julie | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-11-28 00:00:00
82 | FirstName82 | LastName82 | 2023-04-04 00:00:00 | [NAME] | 2023-04-04 00:00:00 | Julie | 2023-04-27 00:00:00 | 2023-04-20 00:00:00 | 2023-05-31 00:00:00 | 2023-05-28 00:00:00
83 | FirstName83 | LastName83 | NA | NA | NA | NA | NA | NA | NA | NA
84 | FirstName84 | LastName84 | 2023-05-04 00:00:00 | Lyn |  | NA | NA | NA | NA | NA
85 | FirstName85 | [NAME] | 2022-12-06 00:00:00 | [NAME] | 2022-12-13 00:00:00 | NA | NA | NA | NA | NA
86 | FirstName86 | LastName86 | 2023-03-29 00:00:00 | [NAME] | 2023-03-31 00:00:00 | Julie | 2023-04-27 00:00:00 | 2023-04-25 00:00:00 | 2023-05-25 00:00:00 | 2023-05-02 00:00:00
87 | FirstName87 | LastName87 | 2023-04-21 00:00:00 | [NAME] |  | [NAME] | 2023-05-11 00:00:00 | NA | NA | NA
88 | FirstName88 | LastName88 | NA | NA | NA | NA | NA | NA | NA | NA
89 | FirstName89 | LastName89 | 2023-03-06 00:00:00 | [NAME] |  | Justin | 2023-03-22 00:00:00 | 2023-03-10 00:00:00 | 2023-04-10 00:00:00 | 2023-03-22 00:00:00
90 | FirstName90 | [NAME] | NA | NA | NA | NA | NA | 2023-04-25 00:00:00 | 2023-05-25 00:00:00 | 2023-05-05 00:00:00