ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Analysis of LFD results in England from government api at https://coronavirus.data.gov.uk/
2
Making use of change on 2021-04-09 which reveals the number of PCR-negative retests of LFD tests: https://coronavirus.data.gov.uk/details/whats-new
3
Edited 2021-04-19 to slightly adjust the formula in column J (inferred number of PCR-negative retests). Now it is the old minus the new version of the metrics newCasesLFDConfirmedPCRBySpecimenDate+newCasesLFDOnlyBySpecimenDate
4
Observations: (i) the FPR has improved over the months, so recent FPR is lower than old FPR, (ii) the PPV has still decreased a bit (to 82.2%), presumably because prevalence has decreased more than FPR has improved
5
Note: Col D (old style) = PCR-retest-negatives + non-PCR-retest; Col H (new style) = non-PCR-retest only
6
Note: slight discrepancies (e.g. 2021-03-24) presumably due to slight retrospective increase of LFD test counts. The last few days are not reliable because test results are still being added.
7
Note: the number removed (8024, cell J11) doesn't exactly match the 8008 mentioned in the "what's new" note.
8
9
API query to obtain columns B-D
API query to obtain columns F-H
10
Cols B-D retrieved from api on 2021-04-08 (pre change)
Cols F-H retrieved from api on 2021-04-09 (post change)
11
datenewLFDTestsnewCasesLFDConfirmedPCRBySpecimenDatenewCasesLFDOnlyBySpecimenDatenewLFDTestsnewCasesLFDConfirmedPCRBySpecimenDatenewCasesLFDOnlyBySpecimenDateInferred number of PCR-negative retests (number removed on 2021-04-09)PPV (=TP/(TP+FP)) of those retested, assuming no PCR false negatives (percentage)FPR lower bound assuming no PCR false negatives (per 10,000)FPR estimate assuming PCR-retests are representative and no PCR false negatives (per 10,000)FPR upper bound assuming all non-PCR-retests would have been PCR-negative and no PCR false negatives (per 10,000)School status
12
TOTAL475652206637357570476762836669349226802489.31.72.812.1
13
4 weeks up to 4 April261438361390016999261442061393513937302782.21.22.16.5
14
2021-04-086077249504THU
15
2021-04-077377067624847738154527-50148.1-0.6-3.67.4WED
16
2021-04-064818651255104824492652868475.91.73.210.6TUE
17
2021-04-056925762773866926473112549876.01.42.35.6MONEaster BH
18
2021-04-047808103403607809013712646585.10.81.34.6SUNEaster
19
2021-04-032187272911992187372991484387.42.02.89.1SAT
20
2021-04-023055532722213055972751625683.11.82.77.2FRIGood Friday
21
2021-04-0171306238840671314939128711677.11.62.55.7THU
22
2021-03-311079806587540107986758841412582.51.21.85.0WEDSome schools open
23
2021-03-303004782892673004822902442292.90.71.38.9TUESome schools open
24
2021-03-293099652052503099682032292389.80.71.58.1MONSome schools open
25
2021-03-2821536221164135621536221162118217686.80.81.56.3SUN
26
2021-03-27205151442271205151441269399.30.10.213.2SAT
27
2021-03-264544244494574544244493916687.21.52.610.1FRISchools open
28
2021-03-259742465887159742475886932296.40.20.57.3THUSchools open
29
2021-03-241569547817104215695568151045-1100.10.00.06.6WEDSchools open
30
2021-03-235683655796085683665785397089.21.22.310.7TUESchools open
31
2021-03-221071856734940107191173368825374.32.44.08.8MONSchools open
32
2021-03-211808390104412161808390104495526180.01.42.56.7SUN
33
2021-03-202072774372872072774372335489.02.63.813.8SAT
34
2021-03-1964656948646064656948434811480.91.82.87.1FRISchools open
35
2021-03-181194141515700119414151554415676.81.32.45.9THUSchools open
36
2021-03-171381495643819138149564267214881.31.12.05.9WEDSchools open
37
2021-03-161081852480651108185248050314876.41.42.56.0TUESchools open
38
2021-03-151515597554915151559855471919673.91.32.56.0MONSchools open
39
2021-03-148374674985208374684984309084.71.11.96.2SUN
40
2021-03-131819242902421819242902132990.91.62.713.3SAT
41
2021-03-121195637344638119563734451612273.81.02.25.3FRISchools open
42
2021-03-111393730337661139373033750715468.61.12.24.7THUSchools open
43
2021-03-101294857361720129485736156715370.21.22.55.6WEDSchools open
44
2021-03-091197334347701119733434754915269.51.32.75.9TUESchools open
45
2021-03-081501954419837150195641962621166.51.42.85.6MONSchools open
46
2021-03-076605762723876605782723196880.01.02.05.9SUN
47
2021-03-061834431842481834431842054381.12.34.513.5SAT
48
2021-03-0570434119047570434119036311262.91.63.56.7FRI
49
2021-03-047500981855457500991854687770.61.02.97.3THU
50
2021-03-035685562434515685572433965581.51.02.37.9WED
51
2021-03-024029732224154029732223823387.10.82.010.3TUE
52
2021-03-015840992544795840992544097078.41.22.78.2MON
53
2021-02-283573371862573573371862233484.51.01.97.2SUN
54
2021-02-2711271397193112713971732082.91.84.417.1SAT
55
2021-02-263159051513583159051513184079.11.33.411.3FRI
56
2021-02-254279792074424279792073895379.61.23.110.3THU
57
2021-02-244285992364524285992364034982.81.12.810.5WED
58
2021-02-233152092374243152092373606478.72.04.513.5TUE
59
2021-02-2252110934066252110934056010276.92.04.412.7MON
60
2021-02-213710603003383710603002944487.21.22.29.1SUN
61
2021-02-201168001393191168001392893082.22.67.027.3SAT
62
2021-02-192251792304322251792303765680.42.55.819.2FRI
63
2021-02-182439502694592439502694174286.51.74.018.8THU
64
2021-02-172401963304522401963304054787.52.04.118.8WED
65
2021-02-162098452925042098452924584686.42.25.224.0TUE
66
2021-02-152874963905592874963904877284.42.55.119.4MON
67
2021-02-142084082962912084082962583390.01.62.814.0SUN
68
2021-02-131105811642841105811642552985.02.66.125.7SAT
69
2021-02-122937702834332937702833884586.31.53.314.7FRI
70
2021-02-114005013275044005013274535186.51.32.812.6THU
71
2021-02-104249854535534249854534906387.81.52.913.0WED
72
2021-02-092918083815262918083814666086.42.14.218.0TUE
73
2021-02-0846491651769146491651758210982.62.34.514.9MON
74
2021-02-073637815094113637815093436888.21.93.011.3SUN
75
2021-02-061213652493551213652493223388.32.75.829.3SAT
76
2021-02-053104803865833104803865176685.42.14.618.8FRI
77
2021-02-044182584617024182584616247885.51.94.016.8THU
78
2021-02-034544195967604544195966827888.41.73.516.7WED
79
2021-02-023075385436753075385436057088.62.34.521.9TUE
80
2021-02-014787357668314787357667369589.02.03.717.4MON
81
2021-01-313571925775363571925774627488.62.13.515.0SUN
82
2021-01-301142863294521142863294203291.12.86.139.5SAT
83
2021-01-292882164686622882164686045889.02.04.323.0FRI
84
2021-01-283663625958043663625957307488.92.04.221.9THU
85
2021-01-273794716327523794716326698388.42.24.219.8WED
86
2021-01-262843689124632843689123808391.72.94.016.3TUE
87
2021-01-25367632119355936763211934659492.72.63.515.2MON
88
2021-01-241675706692871675706692444394.02.63.417.1SUN
89
2021-01-231018526413431018526412974693.34.56.533.7SAT
90
2021-01-222370519224492370519223688191.93.44.718.9FRI
91
2021-01-212402929774722402929774116194.12.53.519.6THU
92
2021-01-20220808109851222080810984387493.73.44.623.2WED
93
2021-01-19234925130954223492513094657794.43.34.423.1TUE
94
2021-01-18311810161859331181016185167795.52.53.219.0MON
95
2021-01-171090699053511090699053123995.93.64.832.2SUN
96
2021-01-1687580878368875808783343496.33.95.342.0SAT
97
2021-01-15185123113453118512311344824995.92.63.728.7FRI
98
2021-01-14177612119954917761211994856494.93.65.030.9THU
99
2021-01-13164664132256616466413225056195.63.75.134.4WED
100
2021-01-12175299144260417529914425307495.14.25.734.5TUE