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