P
Peatness
Guest
CONFIDENTIAL: Analysis of ED Data
1 Data source & preparation
On 23rd June 2021 I was given access to a substantial TXT file (22MB) held on a shared Google drive
entitled XXXX_20210101_ToDate.txt1, this being a dump of electronic records of admissions for the
period 1st January 2021 – 13th June 2021 for an unknown NHS Trust. When imported into Excel this
consisted of 161,495 rows with the following headings ranging from columns A to L:
Arrival_Date, Age_at_CDS_Activity_Date, FirstJabDate, SecondJabDate, Within28d_FirstJab, Within28d_SecondJab, Chief_Complaint,
Diag1, Diag2, Diag3, Diag4, Discharge_Dest
All variables were extracted from the file for the purpose of recoding and analysis. A coding frame
may be found in the appendix.