Record Table 1053
Title: COVID-19 test results (England)
Access field: 40100 (Records of COVID-19 test results)
Table name covid19_result_england Table group COVID19 results Debut Apr 2021 Row count 759,000+ Parent table n/a Version Jun 2023 Size 22MB Stability Accruing Cost Tier d1 o1 s1
Not all features of this website will be available to you.
WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.
Covid-19 test results (England)
# Column Type Notes
1 eid integer Encoded participant identifier.
2 specdate date Date the specimen was taken.
3 spectype integer, coding 1853 Specimen type. "Specimen type as recorded on the laboratory request form (e.g. nasal, nose and throat, sputum)"
4 laboratory integer, coding 1856 The laboratory that processed the sample.
5 origin integer, coding 1855 Field (possibly) indicating whether the patient was an inpatient when the sample was taken. This is based on information provided on the specimen request form and may not be reliable. See the COVID-19 test page on Showcase Essential Information for information about how this field is constructed by the data provider.
6 result integer, coding 1854 Whether the sample was reported as positive or negative for SARS-CoV-2.
7 acute integer, coding 12 Whether the requesting organisation is from an organisation known to provide acute (emergency) care. Used in the construction of the 'origin' field.
8 hosaq integer, coding 21 Whether the sample is recorded as being hospital acquired. Used in the construction of the 'origin' field. 9 reqorg integer, coding 3311 Requesting organisation description. Used in the construction of the 'origin' field.
2 Related COVID19 results Record Tables
Enabling scientific discoveries that improve human health