Testing Data
PCR
About
- Extracts from the CDW
- deduped (cleaned by removing identical/repeated entries)
- Provides dates and results of COVID-19 PCR testing data
CDW_deduped.md
|
value |
size |
145458644 |
mtime |
2022-08-15 05:50:41 |
ctime |
2022-08-15 05:50:41 |
file |
CDW_deduped.rds |
nrows |
3953858 |
Columns
name |
type |
label |
examples |
description |
EAVE_LINKNO |
chr |
EAVE Study Identifier |
|
EAVE-II Identifier, pseudoynmised CHI numbers are used to create randomly assigned study index numbers. |
test_id |
chr |
|
|
|
age |
dbl |
Age |
38, 34, 32, 35, 28 |
Age in years |
sex |
chr |
Sex (number) |
Female, Male |
Sex at birth |
HB_residence |
chr |
|
NHS GREATER GLASGOW & CLYDE, NHS LOTHIAN, NHS LANARKSHIRE, NHS GRAMPIAN, NHS TAYSIDE |
|
SpecimenDate |
dttm |
Specimen Date |
|
Date sample taken |
reporting_health_board |
chr |
|
NHS GREATER GLASGOW & CLYDE, NHS LOTHIAN, NHS LANARKSHIRE, NHS GRAMPIAN, NHS TAYSIDE |
|
submitting_lab |
chr |
|
NON-ECOSS, GLA:REV, EDI:RVL, ABD:GHB, LAN:LAW |
|
lab_code |
chr |
|
GLS, AYR:ARL, FIF:ARL, NC |
|
lab_name |
chr |
|
Glasgow, Crosshouse Hospital, Kilmarnock, Fife Area Laboratory, Newcastle |
|
test_result_record_source |
chr |
|
NHS DIGITAL, ECOSS, SGSS, SCOT, ONS |
|
flag_lighthouse_labs_testing |
dbl |
|
1, 0 |
|
flag_deduplicated_cases |
dbl |
|
1 |
|
NCOV_RESULT |
chr |
COVID-19 result |
NEGATIVE, POSITIVE |
Novel Coronavirus result |
NRS.Date.Death |
date |
Date of NRS death record |
|
Date of death |
NRS.Reg.Date |
date |
Date of death registered |
|
Date of death registered |
death28 |
dbl |
Death within 28 days |
0, 1 |
Death within 28 days of positive covid test |
pc8 |
chr |
|
|
|
simd2020v2_sc_quintile |
int |
|
5, 1, 2, 4, 3 |
|
datazone2011 |
chr |
|
S01008144, S01012030, S01012820 |
|
ur6_2016 |
int |
Urban/Rural classification |
1, 2, 5, 3, 6 |
Urban/Rural 6-fold classification (2016 classification) |
result |
dbl |
Result |
0, 1 |
Result |
LFT
About
- Provides dates and results of positive COVID-19 LFT Testing Data
lft_positives.md
|
value |
size |
3970235 |
mtime |
2022-08-15 09:47:36 |
ctime |
2022-08-15 09:48:05 |
file |
/conf/EAVE/GPanalysis/data//lft_positives.rds |
nrows |
901332 |
Columns
name |
type |
label |
examples |
description |
EAVE_LINKNO |
chr |
EAVE Link Number |
|
Randomly assigned study index number |
date_ecoss_specimen |
date |
|
2022-03-14, 2022-03-21, 2022-03-16, 2022-03-09, 2022-03-15 |
|
test_result |
chr |
|
POSITIVE |
|
test_type |
chr |
|
ANTIGEN |
|
S-Gene
About
omicron_ctvals.md
|
value |
size |
42301758 |
mtime |
2022-08-15 06:23:36 |
ctime |
2022-08-15 06:23:36 |
file |
/conf/EAVE/GPanalysis/data//omicron_ctvals.rds |
nrows |
845431 |
Columns
name |
type |
label |
examples |
description |
EAVE_LINKNO |
chr |
EAVE Link Number |
|
Randomly assigned study index number |
test_id |
chr |
|
|
|
date_ecoss_specimen |
date |
|
2021-12-29, 2021-12-30, 2022-01-04, 2022-01-03, 2022-01-05 |
|
ct_value_ORF1AB |
chr |
|
|
|
ct_value_NGENE |
chr |
|
|
|
ct_value_SGENE |
chr |
|
-1.00, 0.00 |
|
ct_value_MS2 |
chr |
|
|
|
gene_result_ORF1AB |
chr |
|
POSITIVE, INCONCLUSIVE, NEGATIVE |
|
gene_result_NGENE |
chr |
|
POSITIVE, INCONCLUSIVE, NEGATIVE |
|
gene_result_SGENE |
chr |
|
NEGATIVE, POSITIVE, INCONCLUSIVE |
|
gene_result_MS2 |
chr |
|
POSITIVE |
|
sgene_classification |
chr |
|
True S Gene Dropout, Positive S Gene, Weak Positive, other |
|
Last update:
August 25, 2022
Created:
August 25, 2022