UK Coronavirus/COVID-19 Figures - tracking, statistics and breakdowns

	A	C	D	H	I
1	Notes on testing/results:
2	Figures are (usually) reported at/just after 2pm via either the DHSC twitter or GOV.UK website. These figures represent the test figures which were confirmed by 9am of that day and deaths by 5pm the prior day.
3	From reports, results take around 48 hours to process and the government delays figures by up to 24 hours for confirmation purposes. So figures released are likely representative of tests carried out 72 hours ago.
4
5	The government has confirmed they have 3 areas of testing:
6	- Intensive Care Units
7	- Hospitals
8	- GP surgeries
9
10	The results we receive will only be relative to the testing performed, so:
11	- If testing numbers are low, confirmed cases will be low (actual infection numbers in the UK are far, far higher than these confirmed figures)
12	- If testing is targeted towards specific people (e.g. higher risk ICU patients, patients with stronger symptoms) then the resulting positivity rate will be much higher than if non-selective testing were done
13
14	Originally we only got a single figure for testing numbers, which (due to improper/inconsisten wording by DHSC) we weren't sure if it represented number of people tested or total number of tests completed overall.
15	We now have confirmation that the previous totals provided were of all people tested. DHSC have since started releasing figures for both total/daily tests completed and number of people tested. Multiple tests are required for a number of reasons: multiple initial test types being used for diagnosis; rechecking status of infected patients, rechecking medical staff/at-risk people; retesting of potentially inaccurate results.
16
17	I spotted some discrepancies with DHSC announcement wording, as well as logging every time they're delayed. That can be found on the			DHSC Announcements tab
18
19	Regarding different 'Pillar' testing:
20	https://twitter.com/DHSCgovuk/status/1246466798557581312
21	https://twitter.com/DHSCgovuk/status/1247185093648699393
22
23	Regarding Fatality Rates:
24	On 26/03 the government announced a change to the timing of release for confirmed fatalities. From this day, the fatalities confirmed (at the 2pm-or-after announcement) represent the figure from 5pm of the previous day.
25	On 27/03 the wording of death announcements changed to "those hospitalised in the UK have sadly died", so we can assume they aren't including the numbers of people dying at home/outside a hospital.
26	The GOV.UK website states "The figures for test results and for deaths are compiled from different sources. This is why the figures for deaths are reported from an earlier point in time than the figures for test results."
27	ONS have now started releasing weekly death figures for England/Wales. Note that these figures won't match the DHSC UK death figures.
28
29	[Update 20/04] Note on testing figures on GOV.UK update:
30	As detailed on the 'Northern Ireland testing update' tab, this suggests that the UK total people tested figure includes the same people multiple times.
31	Jump to 'Northern Ireland testing update' tab
32
33
34	Data Sources:
35	DHSC on Twitter	UK confirmed and announced COVID-19 cases, tests and deaths
36	GOV.UK	UK confirmed and announced COVID-19 cases, tests and deaths
37	PHE datasets on ArcGIS	Historic datasets
38	GOV.UK	Stats from Daily Government Briefings (daily UK COVID-19 confirmed positive, England hospital admissions etc.)
39	ONS	Weekly death data for the UK. I track that information on a separate sheet, which can be found here:			https://docs.google.com/spreadsheets/d/1tZdV6aiOh6ZJGwEvbs-lo4uPptezKM4tl7L0F9ye7XE/
40	England/Wales Death data breakdown	ONS's weekly breakdown of death data (now including tracking of COVID-19 fatalities) in England/Wales
41	NHS England daily death figures	Breakdowns by age, gender, region etc.
42	PHE on Twitter	Testing figures for England (no longer provided)
43
44
45	I personally started compiling the figures in early March after noticing the DHSC twitter would put out total tests figures, but unless anybody was paying attention to the previous days' figures, they might not be aware of how few daily tests were being performed.
46	I initially tweeted highlighting this on March 4th		https://twitter.com/murtaman/status/1234861202905456643
47	Then began publishing my sheet/charts on March 7th		https://twitter.com/murtaman/status/1236329601384710152

	A	C
1	Date	Hospital admissions with COVID-19
2	20/03/2020	608
3	21/03/2020	720
4	22/03/2020	806
5	23/03/2020	893
6	24/03/2020	1137
7	25/03/2020	1582
8	26/03/2020	1741
9	27/03/2020	1643
10	28/03/2020	1913
11	29/03/2020	1847
12	30/03/2020	2137
13	31/03/2020	2,769
14	01/04/2020	2484
15	02/04/2020	3121
16	03/04/2020	2874
17	04/04/2020	2451
18	05/04/2020	2509
19	06/04/2020	2517
20	07/04/2020	2618
21	08/04/2020	2,678
22	09/04/2020	2463
23	10/04/2020	2206
24	11/04/2020	2039
25	12/04/2020	1848
26	13/04/2020	1687
27	14/04/2020	1798
28	15/04/2020	1749
29	16/04/2020	1,516
30	17/04/2020	1664
31	18/04/2020	1553
32	19/04/2020	1318
33	20/04/2020	1393
34	21/04/2020	1416
35	22/04/2020	1398
36	23/04/2020	1192
37	24/04/2020	1,219
38	25/04/2020	1171
39	26/04/2020	1002
40	27/04/2020	1155
41	28/04/2020	1274
42	29/04/2020	1191
43	30/04/2020	1190
44	01/05/2020	1152
45	02/05/2020	997
46	03/05/2020	906
47	04/05/2020	989
48	05/05/2020	994
49	06/05/2020	897
50	07/05/2020	971
51	08/05/2020	938
52	09/05/2020	701
53	10/05/2020	751
54	11/05/2020	711
55	12/05/2020	804
56	13/05/2020	788
57	14/05/2020	736
58	15/05/2020	718
59	16/05/2020	678
60	17/05/2020	639
61	18/05/2020	637
62	19/05/2020	697
63	20/05/2020	713
64	21/05/2020	675
65	22/05/2020	685
66	23/05/2020	595
67	24/05/2020	471
68	25/05/2020	472
69	26/05/2020	475
70	27/05/2020	552
71	28/05/2020	562
72	29/05/2020	545
73	30/05/2020	479
74	31/05/2020	436
75	01/06/2020	431
76	02/06/2020	505

	A	B	C	D	E
1	Critical care beds with COVID-19 patients (UK)
2
3	United Kingdom				Percentage
4		England	Wales	Scotland	Northern Ireland
5	21/3/2020	12%
6	22/3/2020	15%
7	23/3/2020	16%
8	24/3/2020	18%	11%	12%
9	25/3/2020	20%	11%	14%
10	26/3/2020	22%	12%	16%
11	27/3/2020	28%	13%	20%
12	28/3/2020	30%	17%	23%
13	29/3/2020	33%	23%	26%
14	30/3/2020	37%	22%	30%	31%
15	31/3/2020	41%	25%	38%	33%
16	1/4/2020	43%	30%	41%	48%
17	2/4/2020	44%	33%	28%	51%
18	3/4/2020	45%	32%	30%	42%
19	4/4/2020	48%	34%	33%	44%
20	5/4/2020	52%	37%	34%	40%
21	6/4/2020	51%	37%	34%	44%
22	7/4/2020	51%	36%	34%	46%
23	8/4/2020	52%	37%	36%	41%
24	9/4/2020	50%	38%	36%	41%
25	10/4/2020	54%	41%	35%	43%
26	11/4/2020	53%	39%	36%	45%
27	12/4/2020	53%	40%	38%	41%
28	13/4/2020	51%	41%	36%	38%
29	14/4/2020	50%	39%	34%	37%
30	15/4/2020	49%	38%	33%	38%
31	16/4/2020	48%	39%	34%	36%
32	17/4/2020	45%	40%	32%	35%
33	18/4/2020	46%	42%	31%	33%
34	19/4/2020	45%	39%	30%	30%
35	20/4/2020	46%	38%	29%	35%
36	21/4/2020	45%	33%	28%	33%
37	22/4/2020	44%	34%	26%	31%
38	23/4/2020	42%	31%	25%	29%
39	24/4/2020	40%	31%	24%	31%
40	25/4/2020	40%	33%	24%	36%
41	26/4/2020	39%	29%	23%	32%
42	27/4/2020	35%	27%	23%	31%
43	28/4/2020	33%	28%	22%	31%
44	29/4/2020	33%	26%	19%	27%
45	30/4/2020	32%	26%	19%	29%
46	1/5/2020	32%	24%	19%	31%
47	2/5/2020	30%	24%	18%	29%
48	3/5/2020	29%	24%	17%	30%
49	4/5/2020	28%	24%	17%	28%
50	5/5/2020	27%	22%	18%	25%
51	6/5/2020	27%	21%	15%	23%
52	7/5/2020	26%	22%	15%	25%
53	8/5/2020	25%	23%	14%	27%
54	9/5/2020	24%	20%	16%	27%
55	10/5/2020	23%	20%	14%	26%
56	11/5/2020	23%	21%	14%	20%
57	12/5/2020	22%	20%	14%	16%
58	13/5/2020	21%	18%	11%	21%
59	14/5/2020	20%	19%	12%	18%

	A	B	C	D	J	K	N	O	P	Q
1	A timeline of Boris Johnson's public appearances prior to his hospitalisation for COVID-19				Original tweet:	https://twitter.com/murtaman/status/1247496238859247616	(please share!)
2	Document version of this timeline, with photographs
3
4	Confirmed C-19 Cases by Date	Confirmed C-19 Deaths by Date	Date
5	15	0	27/02	Boris Johnson makes SURPRISE visit to Kettering hospital A&E for a photo op (attached) and puff piece in The Sun (ironically, about the importance of medical staff)			https://www.thesun.co.uk/news/11071475/bojo-confident-medical-resilience-nhs/
6			29/02	He & Carrie Symonds announce pregnancy. Most UK (especially right wing) press fill their front pages with this. Meanwhile the UK is at 23 confirmed cases and the first Brit has died (abroad) on 28/03.
7			01/03	Johnson visits Royal Free Hospital (the main treatment centre for UK C19 cases)
8			01/03	Johnson visits PHE National Infection Service lab in Colindale for photo op (attached)
9			03/03	Boris laughingly tells reporters he was shaking hands with everybody at a hospital treating #COVID19 patients (previous tweet)
10	163	1	06/03	He visits Mologic lab in Bedford for another photo op (attached)
11			07/03	UK now at over 200 confirmed cases, with 2 confirmed COVID-19 deaths
12	206	2	07/03	Johnson & Symonds attend rugby at Twickenham. Cheltenham Festival later claim that the PM's attendance at the rugby game convinced them to go ahead with their 250,000 attendance festival.				https://amp.theguardian.com/sport/2020/apr/08/cheltenham-cited-boris-johnson-twickenham-trip-to-support-festival-go-ahead-horse-racing
13			07/03	Johnson & Symonds host International Women’s Day at Downing Street - Students of Westminster Kingsway College served them food and drinks, while a group of 50 year-9 secondary school students were also in attenance. As well as women from across the UK globe.
14			08/03	BJ visits flood-hit Bewdley, Worcestershire - it's worth bearing in mind the trip only happened on this date as he was criticised for not visiting sooner (flooding started 26/02). The day before his surprise visit to Kettering hospital.
15			09/03	Johnson/Symonds attend Commonwealth Day service at Westminster Abbey. Meets with Royal Family & mingles w/ scores of children & elderly (inc people from across the CW, spreading it further/sooner).					Full Youtube:	https://www.youtube.com/watch?v=iksBZyRLfu8
16	14558	759	27/03	BJ tests positive following symptoms, starts isolation
17	34832	2921	02/04	Announces leaving isolation/returning to work in full the next day. Going against the UK advice, let alone that of the WHO. He should have been isolating for a further 2 weeks from 03/04
18			05/04	Boris Johnson hospitalised
19			06/04	Admitted to ICU
20			12/04	Boris discharged
21	88621	11329	13/04	He travels to Chequers with his pregnant girlfriend.
22
23	Additional info (suggested by Matt aka @rad_econ on Twitter)
24	-	Towards the end of February, PM has about 1- days off, having taken previously a 2 week holiday in the Carribbean over Xmas/January
25	03/03	First press conf with Whitty & Vallance ('up to 1% can die', 'sing Happy Birthday twice' announced)
26	05/03	Some people say to take it on the chin, that there's this idea it can burn through the population
27	12/03	Another press conference - Containment Phase is over, now into Delay Phase. 'Many more will die, but banning sports fixtures have little effect on spread & unless you're over 70, continue to go on cruises.' Also the idea of Herd Immunity is being touted to Peston at this time.
28	16/03	Imperial College say move from Delay to Containment/Suppression if UK doesn't want 100,000s dead.
29	23/03	Schools finally closed
30	24/03	First day of 'lockdown', unless people cannot work from home

	A	B	C	D	E	F	I
1	Current (before COVID-19 intervention measures) numbers of NHS beds available in England						Please note that this doesn't factor in bed occupancy before the C-19 crisis began.
2	Region	Overnight Beds	Day Only Beds	All Beds Available	Current COVID-19 admission numbers	% of all beds (numbers pre- intervention measures) occupied by COVID-19 patients	Also note that the number of available ventilators is also a key factor in this equation, available beds are only a part of the picture.
3	England	128,329	12,788	141,117	#REF!	#REF!
4	East of England	13,288	1,603	14,891	#REF!	#REF!
5	London	21,361	2,535	23,896	#REF!	#REF!
6	Midlands	24,346	1,997	26,343	#REF!	#REF!
7	North East & Yorkshire	21,652	2,470	24,122	#REF!	#REF!
8	North-West	18,540	1,666	20,206	#REF!	#REF!
9	South-East	16,943	1,170	18,113	#REF!	#REF!
10	South-West	12,199	1,347	13,546	#REF!	#REF!
11				Date:	#REF!
12	Historic bed availability
13	Period	Overnight Beds	Day Only Beds	All Beds Available
14	1987-88	297,364	2,000	299,364
15	1988-89	282,918	2,473	285,391
16	1989-90	270,301	2,861	273,162
17	1990-91	255,479	3,068	258,547
18	1991-92	242,677	3,399	246,076
19	1992-93	232,201	3,972	236,173
20	1993-94	219,476	4,908	224,384		Regarding historic bed reductions, advancements in medical science/living conditions/social programs etc. naturally lead to a reduced requirement for overall bed numbers.
21	1994-95	211,812	5,699	217,511		Though this by no means excuse NHS underfunding at the hands of various governments over the decades
22	1995-96	206,136	6,541	212,677
23	1996-97	198,848	6,766	205,614
24	1997-98	193,625	7,125	200,750
25	1998-99	190,006	7,568	197,574
26	1999-00	186,290	7,938	194,228
27	2000-01	186,091	8,155	194,246
28	2001-02	184,871	8,036	192,907
29	2002-03	183,826	8,544	192,370
30	2003-04	184,019	8,813	192,832
31	2004-05	180,966	9,160	190,126
32	2005-06	175,436	9,726	185,162
33	2006-07	167,019	10,342	177,361
34	2007-08	160,891	10,479	171,370
35	2008-09	160,254	10,959	171,213
36	2009-10	158,461	11,221	169,682
37	2010/11	142,319	11,328	153,647
38	2011/12	140,454	11,715	152,169
39	2012/13	138,178	11,918	150,096
40	2013/14	136,811	12,156	148,967
41	2014/15	136,946	12,572	149,518
42	2015/16	132,194	12,420	144,614
43	2016/17	131,994	12,769	144,763
44	2017/18	130,194	12,493	142,687
45	2018/19	129,992	12,767	142,759
46	2019/20	128,329	12,788	141,117
47
48
49
50
51
52
53
54
55
56
57
58
59

	A	B	C	D	E	F	G	H	I	L	M	N
1	DHSC Delays & Issues in announcing UK COVID-19 cases/deaths/testing figures						https://twitter.com/DHSCgovuk/status/1255852000497078275	On 02/04 I noticed that the DHSC has changed the wording of its announcements (after them being the same for every announcement for weeks) on 31/03
2	NOTE - DHSC stopped providing these twitter updates on 03/07
3								They went from announcing "x number of tests have been completed" to "x amount of people have been tested" - but the number didn't change.
4	Date	Delay Notification time	Delay Notification URL	Stat Release time	Stat Release URL	Missing Figures		This is another example of them poorly/misrepresenting data for weeks re: the test numbers. Though this wouldn't have necessarily been beneficial to them previously, assuming this wasn't intentional then it at least speaks to how incompetent these people are that they'd gotten it wrong/changed it for over a month.
5	Fri 03/07	-	None Made	16:28	https://twitter.com/DHSCgovuk/status/1279074484750876676	People Tested
6	Thu 02/07	-	None Made	21:22	https://twitter.com/DHSCgovuk/status/1278786212279566336	People Tested		I've been tweeting regarding this to see if DHSC can/will explain it. Feel free to share!				https://twitter.com/murtaman/status/1246020803675774977
7	Wed 01/07	-	None Made	15:04	https://twitter.com/DHSCgovuk/status/1278328667899416581	People Tested
8	Tue 30/06	-	None Made	16:28	https://twitter.com/DHSCgovuk/status/1277987414854848512	People Tested		[UPDATE]	As of Mon 06/04, DHSC has switched to reporting both people tested and number of overall tests. We now know that previous testing numbers definitely represented people tested and that 17-18% of all tests performed in the UK are duplicate/multi-sample/retests on the same respective individuals.
9	Mon 29/06	-	None Made	14:47	https://twitter.com/DHSCgovuk/status/1277599474047647745	People Tested			This is confirmation that the updates with wording "concluded tests" were incorrect/misleading.
10	Sun 28/06	-	None Made	15:08	https://twitter.com/DHSCgovuk/status/1277242432510406656	People Tested
11	Sat 27/06	-	None Made	15:49	https://twitter.com/DHSCgovuk/status/1276890497215332355	People Tested		Some examples:
12	Fri 26/06	-	None Made	15:27	https://twitter.com/DHSCgovuk/status/1276522531332280325	People Tested				25/01 - "concluded tests"		https://twitter.com/DHSCgovuk/status/1221076076224446465
13	Thu 25/06	-	None Made	14:50	https://twitter.com/DHSCgovuk/status/1276150709344501763	People Tested
14	Wed 24/06	-	None Made	15:55	https://twitter.com/DHSCgovuk/status/1275804709559902208	People Tested
15	Tue 23/06	-	None Made	16:01	https://twitter.com/DHSCgovuk/status/1275443993585741829	People Tested
16	Mon 22/06	-	None Made	14:39	https://twitter.com/DHSCgovuk/status/1275060863716585474	People Tested
17	Sun 21/06	-	None Made	14:41	https://twitter.com/DHSCgovuk/status/1274698986008559616	People Tested
18	Sat 20/06	-	None Made	14:28	https://twitter.com/DHSCgovuk/status/1274333292842622979	People Tested
19	Fri 19/06	-	None Made	14:47	https://twitter.com/DHSCgovuk/status/1273975785498566657	People Tested
20	Thu 18/06	-	None Made	15:15	https://twitter.com/DHSCgovuk/status/1273620446404059136	People Tested
21	Wed 17/06	-	None Made	15:54	https://twitter.com/DHSCgovuk/status/1273267733665374208	People Tested
22	Tue 16/06	-	None Made	16:27	https://twitter.com/DHSCgovuk/status/1272551297204527105	People Tested
23	Mon 15/06	-	None Made	16:35	https://twitter.com/DHSCgovuk/status/1270741413995610112	People Tested
24	Sun 14/06	-	None Made	15:34	https://twitter.com/DHSCgovuk/status/1272175482566594562	People Tested
25	Sat 13/06	-	None Made	16:16	https://twitter.com/DHSCgovuk/status/1271823736145133570	People Tested
26	Fri 12/06	-	None Made	14:27	https://twitter.com/DHSCgovuk/status/1271433989891543040	People Tested
27	Thu 11/06	-	None Made	14:00	https://twitter.com/DHSCgovuk/status/1271064694128816130	People Tested
28	Wed 10/06	-	None Made	16:35	https://twitter.com/DHSCgovuk/status/1270741413995610112	People Tested				18/02 - "concluded tests"
29	Tue 09/06	-	None Made	16:29	https://twitter.com/DHSCgovuk/status/1270377474359246855	People Tested
30	Mon 08/06	-	None Made	14:16	https://twitter.com/DHSCgovuk/status/1269981670737874946	People Tested
31	Sun 07/06	-	None Made	15:32	https://twitter.com/DHSCgovuk/status/1269638459209191425	People Tested
32	Sat 06/06	-	None Made	14:11	https://twitter.com/DHSCgovuk/status/1269255676020301824	People Tested
33	Fri 05/06	-	None Made	15:34	https://twitter.com/DHSCgovuk/status/1268914158436843520	People Tested
34	Thu 04/06	-	None Made	18:08	https://twitter.com/DHSCgovuk/status/1268590456536993793	People Tested
35	Wed 03/06	-	None Made	15:50	https://twitter.com/DHSCgovuk/status/1268193369689329664	People Tested
36	Tue 02/06	-	None Made	16:32	https://twitter.com/DHSCgovuk/status/1267841541370007554	People Tested
37	Mon 01/06	-	None Made	21:39	https://twitter.com/DHSCgovuk/status/1267556317088165890	People Tested
38	Sun 31/05	-	None Made	15:20	https://twitter.com/DHSCgovuk/status/1267098731528282115	People Tested
39	Sat 30/05	-	None Made	21:27	https://twitter.com/DHSCgovuk/status/1266828477438853120	People Tested
40	Fri 29/05	-	None Made	20:44	https://twitter.com/DHSCgovuk/status/1266455390440620036	People Tested
41	Thu 28/05	-	None Made	16:35	https://twitter.com/DHSCgovuk/status/1266030219993010180	People Tested
42	Wed 27/05	-	None Made	15:57	https://twitter.com/DHSCgovuk/status/1265658306850324480	People Tested
43	Tue 26/05	-	None Made	14:54	https://twitter.com/DHSCgovuk/status/1265280074053382148	People Tested
44	Mon 25/05	-	None Made	17:49	https://twitter.com/DHSCgovuk/status/1264961896224079873	People Tested				25/02 - Change to "people tested"		https://twitter.com/DHSCgovuk/status/1232338253564534791
45	Sun 24/05	-	None Made	17:41	https://twitter.com/DHSCgovuk/status/1264597372404973570	People Tested
46	Sat 23/05	-	None Made	16:52	https://twitter.com/DHSCgovuk/status/1264222607601217537	People Tested
47	Fri 22/05	-	None Made	14:24	https://twitter.com/DHSCgovuk/status/1263460601843548163
48	Wed 20/05	-	None Made	18:28	https://twitter.com/DHSCgovuk/status/1263159710892638208
49	Tue 19/05	-	None Made	18:00	https://twitter.com/DHSCgovuk/status/1262790315779543044	People Tested
50	Mon 18/05	-	None Made	16:48	https://twitter.com/DHSCgovuk/status/1262409742237958145
51	Sun 17/05	-	None Made	21:54	https://twitter.com/DHSCgovuk/status/1262124283817594882
52	Sat 16/05	-	None Made	14:47	https://twitter.com/DHSCgovuk/status/1261654598005272576
53	Fri 15/05	-	None Made	15:25	https://twitter.com/DHSCgovuk/status/1261301748943257606
54	Tue 12/05	-	None Made	15:30	https://twitter.com/DHSCgovuk/status/1260215899623227392
55	Sun 10/05	-	None Made	16:20	https://twitter.com/DHSCgovuk/status/1259503587299864578
56	Sat 09/05	-	None Made	16:52	https://twitter.com/DHSCgovuk/status/1259149268901822465
57	Fri 08/05	15:28	https://twitter.com/DHSCgovuk/status/1258765824787128320	17:56	https://twitter.com/DHSCgovuk/status/1258802999939514369
58	Thu 07/05	14:16	https://twitter.com/DHSCgovuk/status/1258385114326802434	19:11	https://twitter.com/DHSCgovuk/status/1258459531576836103
59	Wed 06/05	14:19	https://twitter.com/DHSCgovuk/status/1258023701020389376	18:14	https://twitter.com/DHSCgovuk/status/1258082721374633985
60	Tue 05/05	14:29	https://twitter.com/DHSCgovuk/status/1257663620286222337?s=19	20:10	https://twitter.com/DHSCgovuk/status/1257749418821980163					04/03 - mixture of "people have been tested" and "concluded tests"
61	Mon 04/05	14:17	https://twitter.com/DHSCgovuk/status/1257298311981211650	18:29	https://twitter.com/DHSCgovuk/status/1257361821784322058
62	Sun 03/05	14:20	https://twitter.com/DHSCgovuk/status/1256936696349892609	18:20	https://twitter.com/DHSCgovuk/status/1256997151638511620
63	Sat 02/05	14:19	https://twitter.com/DHSCgovuk/status/1256574125344280577	17:17	https://twitter.com/DHSCgovuk/status/1256618829746253824
64	Fri 01/05	14:30	https://twitter.com/DHSCgovuk/status/1256214486979133441	17:15	https://twitter.com/DHSCgovuk/status/1256255822025428992
65	Thu 30/04	14:30	https://twitter.com/DHSCgovuk/status/1255852000497078275	18:57	https://twitter.com/DHSCgovuk/status/1255919299555926016
66	Wed 29/04	14:28	https://twitter.com/DHSCgovuk/status/1255489183050797057	18:08	https://twitter.com/DHSCgovuk/status/1255544385082712066
67	Tue 28/04	14:30	https://twitter.com/DHSCgovuk/status/1255127196286373888	19:50	https://twitter.com/DHSCgovuk/status/1255207678760140801
68	Mon 27/04	14:59	https://twitter.com/DHSCgovuk/status/1254772141775392768	19:07	https://twitter.com/DHSCgovuk/status/1254834459846811651
69	Sun 26/04	14:54	https://twitter.com/DHSCgovuk/status/1254408454728548355	16:57	https://twitter.com/DHSCgovuk/status/1254439544507826179
70	Sat 25/04	-	None Made	15:19	https://twitter.com/DHSCgovuk/status/1254052435577970688
71	Fri 24/04	14:51	https://twitter.com/DHSCgovuk/status/1253682999964635138	15:13	https://twitter.com/DHSCgovuk/status/1253688601637986304
72	Wed 22/04	-	None Made	14:47	https://twitter.com/DHSCgovuk/status/1252957313524215809
73	Tue 21/04	14:38	https://twitter.com/DHSCgovuk/status/1252592542979325953	16:08	https://twitter.com/DHSCgovuk/status/1252615087304687618
74	Mon 20/04	14:14	https://twitter.com/DHSCgovuk/status/1252224195683135489	16:26	https://twitter.com/DHSCgovuk/status/1252257328205836288						16/03 - "concluded tests"
75	Thu 16/04	-	None Made	14:44	https://twitter.com/DHSCgovuk/status/1250782047095922690
76	Wed 15/04	-	None Made	14:31	https://twitter.com/DHSCgovuk/status/1250416371453669377
77	Tue 14/04	-	None Made	14:29	https://twitter.com/DHSCgovuk/status/1250053583803990016
78	Mon 13/04	-	None Made	14:38	https://twitter.com/DHSCgovuk/status/1249693469733421056
79	Sun 12/04	14:13	https://twitter.com/DHSCgovuk/status/1249324653853712386	15:36	https://twitter.com/DHSCgovuk/status/1249345659355922432
80	Fri 10/04	14:16	https://twitter.com/DHSCgovuk/status/1248600780543754245	18:09	https://twitter.com/DHSCgovuk/status/1248659493610758144
81	Tue 07/04	14:30	https://twitter.com/DHSCgovuk/status/1247517126287474689	16:18	https://twitter.com/DHSCgovuk/status/1247544237073166339
82	Mon 06/04	14:16	https://twitter.com/DHSCgovuk/status/1247151160324128773	16:31	https://twitter.com/DHSCgovuk/status/1247185091517911040
83	Sun 05/04	14:13	https://twitter.com/DHSCgovuk/status/1246787989075828741	14:26	https://twitter.com/DHSCgovuk/status/1246791324231176193
84	Tue 31/03	14:16	https://twitter.com/DHSCgovuk/status/1244976749940703233	15:41	https://twitter.com/DHSCgovuk/status/1244998310735331330
85	Mon 30/03	14:12	https://twitter.com/DHSCgovuk/status/1244613549646843910	16:42	https://twitter.com/DHSCgovuk/status/1244651132879806471
86	Thu 26/03	-	None Made	18:03	https://twitter.com/DHSCgovuk/status/1243237209039396872
87	Wed 25/03	14:16	https://twitter.com/DHSCgovuk/status/1242817554705342465	23:02	https://twitter.com/DHSCgovuk/status/1242950122981470208						30/03 - "concluded tests"
88	Tue 24/03	14:38	https://twitter.com/DHSCgovuk/status/1242460728780566534	15:51	https://twitter.com/DHSCgovuk/status/1242479152420225025						Still includes numbers confirmed as negative
89	Mon 23/03	14:16	https://twitter.com/DHSCgovuk/status/1242092779976691714	17:46	https://twitter.com/DHSCgovuk/status/1242145605604032512
90	Sun 22/03	14:13	https://twitter.com/DHSCgovuk/status/1241729639841697792	18:27	https://twitter.com/DHSCgovuk/status/1241793655737921537
91	Sat 21/03	16:44	https://twitter.com/DHSCgovuk/status/1241405397606584321	18:14	https://twitter.com/DHSCgovuk/status/1241428067081433088
92	Fri 20/03	14:15	https://twitter.com/DHSCgovuk/status/1241005488831180800	17:48	https://twitter.com/DHSCgovuk/status/1241058983336706050
93	Thu 19/03	14:17	https://twitter.com/DHSCgovuk/status/1240643482487848960	19:10	https://twitter.com/DHSCgovuk/status/1240717258013306880
94	Tue 17/03	-	None Made	14:42	https://twitter.com/DHSCgovuk/status/1239924970366648320	Deaths
95	Mon 16/03	14:16	https://twitter.com/DHSCgovuk/status/1239556117308542978	18:26	https://twitter.com/DHSCgovuk/status/1239618973391638532
96	Sun 15/03	14:53	https://twitter.com/DHSCgovuk/status/1239202990369705984	15:40	https://twitter.com/DHSCgovuk/status/1239214816860016640
97	Tue 10/03	14:00	https://twitter.com/DHSCgovuk/status/1237377690820382720	14:20	https://twitter.com/DHSCgovuk/status/1237382759812861952
98	Thu 05/03	15:15	https://twitter.com/DHSCgovuk/status/1235584826448769026	14:00	https://twitter.com/DHSCgovuk/status/1235595937529151488
99	Fri 28/02	14:05	https://twitter.com/DHSCgovuk/status/1233392851821744128	19:19	https://twitter.com/DHSCgovuk/status/1233471782147018753
100	Tue 25/02	14:03	https://twitter.com/DHSCgovuk/status/1232305187731144708	16:15	https://twitter.com/DHSCgovuk/status/1232338253564534791
101	Total No. of Delays:		93								31/03 - "people have been tested"
102	Delays without Notification:		57								No longer includes numbers confirmed negative
103		Latest release of figures:	23:02
104		Longest delay time:	09 hours 02 minutes
105		Previous delay time:	02 hours 28 minutes
106		Average delay time:	02 hours 40 minutes
107
108	Delays per day			Number of days DHSC/Downing Street haven't provided a 'People Tested' Figure (which they announced was 'paused' on 23/05/20)
109	Mon	14
110	Tue	18
111	Wed	12
112	Thu	11
113	Fri	14		1513							01/04 - "people have been tested"
114	Sat	10									No longer includes numbers confirmed negative
115	Sun	14
116
117
118
119
120
121
122
123											06/04 - DHSC start announcing total number of tests. With 3 weeks to go until the end of April/their target of 100,000 tests a day (which was understood to mean 100,000 people tested a day).
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145											13/04 - detailed breakdowns of both tests and people tested
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059

	A	B	G	H	I	K	L	M
1	I noticed in early March that the government's COVID-19 posters/signs in NHS hospitals and health centres around the country (over recent weeks) seem to be outdated. By over A MONTH in some cases.
2	These posters are designed to tell people that if they've been to an affected region, they shouldn't enter the hospital (to protect staff and patients from infection) and head to the Coronavirus POD.
3	As these outdated posters appear to be in place at hospitals thoughout the country (and have been for weeks), it means that COVID-19 infected patients have been, unknowingly, entering NHS hospitals and health facilities for weeks now and no doubt infected vulnerable patients and staff.
4
5	Most strikingly, Italy and Iran were left off during the midst of their crises in early March ---------------------------------------------------------------------------------------->
6	The UK had particularly large numbers of tourists (including many schooltrips) returning from Italy around this time.
7
8	Please share this Tweet to help me find more photos (or send them my way @murtaman on Twitter if you have any):
9	https://twitter.com/murtaman/status/1237751378799464448
10
11	Notes:
12	11/03 - A friend who's a patient at St James Hospital, Leeds checked there and reported no lists of affected areas posted up at the hospital entrance, nor the entrance to his ward.
13
14	16/02	North Tees hospital (Stockon on Tees Hospital)
15	Source
16				<--- The oldest poster I've found so far. Note that many of the more recent posters (including until as recently as 11/03, possibly later) were still using this poster from mid-February
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59	05/03	Oxford
60	Meanwhile, for comparison, this is what SOME places were using by 05/03 (possibly earlier)		Note that these were taking in an affluent area - in this case, Oxford. Many of the below examples were posted in less affluent regions.
61	Source
62
63
64
65
66
67
68
69
70
71
72
73								(This is the only example I could find of these particular posters.)
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101	Wed 11/03	Lewisham
102	Taken by me
103
104	No signs outside of the main hospital doors.
105	The closest to the entrance is the pic on the right (which is the most up-to-date), but still wrong and was placed behind a large sign, so only visible if you entered /went past it from that side.
106
107	Handwritten additions to the left-hand sign are barely readable.
108
109	Lewisham hospital had the first confirmed COVID-19 case in London and its cleaners quit due to lack of pay and PPE on 11/03
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129	Tue 10/03	Doncaster
130	Source
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158	06/03	Wigan				Thu 05/03	Jhoots Pharmacy, Newark
159	Source					Source
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185	Wed 04/03	Nottingham University Hospitals				Thu 05/03	QMC Hospital (Nottingham)
186	Source					No Italy/Iran etc.
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211	Thu 05/03	Parson's Medical Centre (London)
212	Source
213
214
215	No Italy, Iran etc.
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238				March 5th	Dentists in Elephant & Castle
239				Source
240	Thu 05/03	Dalhousie Medical Practice (Scotland)
241	Source
242
243
244	No Iran/other countries. Northern Italy not expanded to entire country.
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278

	A	C	G
1	On 20/04, the GOV.UK site was updated and then shortly corrected. However I have a record of the original update.
2	This update suggests that individual people who've been retested at later dates are being added to the cumulative total of UK people tested.
3	I've just tweeted about this here:	https://twitter.com/murtaman/status/1252270751023071240	Please feel free to share! :)
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

	A	B	C	D	E	F	G	H	I	J	K	M
1	Day No.	Day	Date	Announced Total Cases (DHSC) - without Pillar 2 cases	Adjusted Running Total with cumulative Pillar 2 new cases to date.	Calculated Daily Increase In Cases - Today's Total minus Yesterday's Total	Announced Total Cases (from PHE/ArcGIS dataset)	Announced Daily Increase (from PHE/ArcGIS dataset)	Announced Daily Increase In Cases - Pillar 1 (From Daily Briefing Data)	Announced Daily Increase In Cases - Pillar 2 (From Daily Briefing Data)	Announced Daily Increase In Cases - Pillar 2 (From GOV.UK) Static	This sheet is here for minor discrepancies I've noticed between my dataset and original figures. Rather than clutter up the main sheet I'll put anything on here

2	71	Fri	10/04	70272	73,758	5195	5,195	5195	5195	-		Red/Green - highlighted differences
3	70	Thu	09/04	65077	68563	4855	65,077	4344	4344	511	331	Light - Blue - my original totals (without Pillar 2 cases worked in)
4	69	Wed	08/04	60733	63708	5822	60733	5491	5491	331	374	Blue - adjusted totals (including Pillar 2 cases to date)
5	68	Tue	07/04	55242	57886	4008	55242	3634	3634	374	254
6	67	Mon	06/04	51608	53878	4056	51608	3802	3802	254	341
7	66	Sun	05/04	47806	49822	6244	47806	5914	5914	341	296
8	65	Sat	04/04	41903	43578	4031	41903	3735	3735	296	265
9	64	Fri	03/04	38168	39547	4715	38168	4450	4450	265	222
10	63	Thu	02/04	33718	34832	4466	33718	4244	4244	222	278
11	62	Wed	01/04	29474	30366	4602	29474	4324	4324	278	243
12	61	Tue	31/03	25150	25764	3252	25150	3009	3009	243	241
13	60	Mon	30/03	22141	22512	2860	22141	2619	2619	241	46
14	59	Sun	29/03	19522	19652	2479	19522	2433	2433	46	69
15	58	Sat	28/03	17089	17173	2615	17089	2546	2546	69	10
16	57	Fri	27/03	14543	14558	2895	14543	2885	2885	10	5
17	56	Thu	26/03	11658	11663	2129	11658	2129	2129	5
18	55	Wed	25/03	9529		1452	9529	1452	1452
19	54	Tue	24/03	8077		1427	8077	1427	1427
20	53	Mon	23/03	6650		967	6650	967	787
21	52	Sun	22/03	5683		665	5683	665	851
22	51	Sat	21/03	5018		1035	5018	1035	1029
23	50	Fri	20/03	3983		714	3983	714	714
24	49	Thu	19/03	3269		643	3269	643	643
25	48	Wed	18/03	2626		676	2626	676	676
26	47	Tue	17/03	1950		407	1950	407	407
27	46	Mon	16/03	1543		171	1543	152	171
28	45	Sun	15/03	1372		232	1391	330
29	44	Sat	14/03	1140		342	1061	264
30	43	Fri	13/03	798		208	797	207
31	42	Thu	12/03	590		134	590	139
32	41	Wed	11/03	456		83	456	83
33	40	Tue	10/03	373		54	373	52
34	39	Mon	09/03	319		46	321	50
35	38	Sun	08/03	273		67	271	65
36	37	Sat	07/03	206		43	206	46
37	36	Fri	06/03	163		48	160	46
38	35	Thu	05/03	115		30	114	29
39	34	Wed	04/03	85		34	85	34
40	33	Tue	03/03	51		11	51	11
41	32	Mon	02/03	40		5	40	5
42	31	Sun	01/03	35		12	35	12
43	30	Sat	29/02	23		3	23	4
44	29	Fri	28/02	20		5	19	6
45	28	Thu	27/02	15		2	13	-
46	27	Wed	26/02	13		0	13	-
47	26	Tue	25/02	13		4	13	-
48	25	Mon	24/02	9		0	13	4
49	24	Sun	23/02	9		0	9	-
50	23	Sat	22/02	9		0	9	-
51	22	Fri	21/02	9		0	9	-
52	21	Thu	20/02	9		0	9	-
53	20	Wed	19/02	9		0	9	-
54	19	Tue	18/02	9		0	9	-
55	18	Mon	17/02	9		0	9	-
56	17	Sun	16/02	9		0	9	-
57	16	Sat	15/02	9		0	9	-
58	15	Fri	14/02	9		0	9	-
59	14	Thu	13/02	9		1	9	1
60	13	Wed	12/02	8		0	8	-
61	12	Tue	11/02	8		0	8	-
62	11	Mon	10/02	8		4	8	4
63	10	Sun	09/02	4		1	4	1
64	9	Sat	08/02	3		0	3	-
65	8	Fri	07/02	3		0	3	-
66	7	Thu	06/02	3		1	3	1
67	6	Wed	05/02	2		0	2	-
68	5	Tue	04/02	2		0	2	-
69	4	Mon	03/02	2		0	2	-
70	3	Sun	02/02	2		0	2	-
71	2	Sat	01/02	2		0	2	-
72	1	Fri	31/01	2		2	2	2
73	0	Thu	30/01	0		0
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000

	A	B	C	D	E	F	G	H	J
1	Day No.	Day	Date	England - Daily Tests (per PHE)	England - Individual People Tested (per PHE)	England - % of daily tests which were individual people	Testing Capacity on this date (per PHE)	Daily % of people tested who confirmed positive	PHE seem to have stopped putting this data out via Twitter announcement/the DHSC figure gives a breakdown of people tested vs number of tests, so I'll likely focus on that for now. If expanded testing stats for England/Northern Ireland/Scotland/Wales become available on a regular basis and I have time, I might look to work them back in. But for now, I think it helps the clarity of the main sheet to not have this on there. Particularly as the new DHSC breakdown of stats is likely to increase the number of other columns/charts needed to track everything going on there.
2		Fri	10/04					39.40%
3		Thu	09/04					45.32%	Re: Daily Positivity Rate - We can see with the recent 90%+ spike that this is massively influenced by the way data is released. As such, it may be best to look to the overall positivity rate.
4	69	Wed	08/04				-	29.82%
5	68	Tue	07/04				-	92.27%	Formula for daily percentage:
6	67	Mon	06/04				-	30.47%	#DIV/0!
7	66	Sun	05/04	-	-	-	-	50.62%
8	65	Sat	04/04	11085	8651	78.04%	12799	42.86%
9	64	Fri	03/04	10984	6570	59.81%	12799	44.52%
10	63	Thu	02/04	11764	7651	65.04%	12799	43.72%
11	62	Wed	01/04	10657	7771	72.92%	12799	46.99%
12	61	Tue	31/03	10412	7511	72.14%	12799	39.47%
13	60	Mon	30/03	-	-	-	-	39.67%
14	59	Sun	29/03	8278	4908	59.29%	10949	35.61%
15	58	Sat	28/03	9114			10949	37.36%
16	57	Fri	27/03					32.49%
17	56	Thu	26/03					27.20%
18	55	Wed	25/03					22.06%
19	54	Tue	24/03					21.98%
20	53	Mon	23/03					17.25%
21	52	Sun	22/03					12.04%
22	51	Sat	21/03					17.72%
23	50	Fri	20/03					30.32%
24	49	Thu	19/03					7.65%
25	48	Wed	18/03					11.70%
26	47	Tue	17/03					6.42%
27	46	Mon	16/03					4.47%
28	45	Sun	15/03					9.16%
29	44	Sat	14/03					6.87%
30	43	Fri	13/03					6.92%
31	42	Thu	12/03					5.86%
32	41	Wed	11/03					6.83%
33	40	Tue	10/03					4.15%
34	39	Mon	09/03					3.18%
35	38	Sun	08/03					3.26%
36	37	Sat	07/03					3.83%
37	36	Fri	06/03					2.13%
38	35	Thu	05/03					2.11%
39	34	Wed	04/03					1.24%
40	33	Tue	03/03					2.85%
41	32	Mon	02/03					0.28%
42	31	Sun	01/03					0.93%
43	30	Sat	29/02					0.20%
44	29	Fri	28/02					0.39%
45	28	Thu	27/02					0.36%
46	27	Wed	26/02					0.00%
47	26	Tue	25/02					1.54%
48	25	Mon	24/02					0.00%
49	24	Sun	23/02					0.00%
50	23	Sat	22/02					0.00%
51	22	Fri	21/02					0.00%
52	21	Thu	20/02					0.00%
53	20	Wed	19/02					0.00%
54	19	Tue	18/02					0.00%
55	18	Mon	17/02					0.00%
56	17	Sun	16/02					0.00%
57	16	Sat	15/02					0.00%
58	15	Fri	14/02					0.00%
59	14	Thu	13/02					0.13%
60	13	Wed	12/02					0.00%
61	12	Tue	11/02					0.00%
62	11	Mon	10/02					1.25%
63	10	Sun	09/02					0.92%
64	9	Sat	08/02					0.00%
65	8	Fri	07/02					0.00%
66	7	Thu	06/02					1.02%
67	6	Wed	05/02					0.00%
68	5	Tue	04/02					0.00%
69	4	Mon	03/02					0.00%
70	3	Sun	02/02					0.00%
71	2	Sat	01/02					0.00%
72	1	Fri	31/01					12.50%
73	0	Thu	30/01					-%
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AI	AJ	AK	AL	AM	AN	AO	AR	AS	AU	AV	AW	AX	AY	BA
1	Days Since Reporting Began	Day	Date	Total Announced C-19 UK cases - as of 9am	Daily Increase In Cases	% change in New Cases (compared to prior day's New Cases)	% increase to prior day's Total Cases	New Measure - Total Tests Performed	Announced Total Number of Tests Performed	Announced Total People Tested	People Confirmed negative for COVID-19	% of Overall People Tested who confirmed positive	New Measure - Daily Tests Performed	Old Measure - Daily Tests (Which were reported to the media)	Difference in No. of Daily Tests (between Old and New reporting measure)	Announced No. of People Tested On Prior Day	Calculated No. of People Tested On Prior Day	Daily positivity rate	New Measure - Total C-19 deaths	Announced Total C-19 Deaths for all settings - by 5pm of prior day	Announced Total confirmed UK Hospital C-19 Deaths - by 5pm of prior day	New Measure - Daily C-19 deaths	Old Measure - Daily C-19 deaths	Calculated Daily confirmed deaths - hospital	% daily increase in Total Deaths (compared to prior day's Total Deaths)	% change in New Deaths (compared to prior day's Daily Deaths)	New Measure - 7-day rolling average for daily deaths - all settings	% of people tested positive for COVID-19 who have passed away	UK C-19 Hospital inpatients on date	Testing Capacity	% of testing capacity being used	% change in testing amount (compared to prior day's New People Tested)	14-day rolling average of daily case numbers	Most Tests Performed In One Day	Most People Tested In One Day	@murtaman on Twitter	I'm currently in debt and facing financial issues. If you appreciate the work I've been doing since the start of March, please consider donating at: http://gofundme.com/f/uk-coronavirus-case-tracking Huge thanks to all who've supported and shared kind words so far <3			GoFundMe Link	PLEASE TAKE A MOMENT TO CHECK OUT THE OTHER TABS - THEY INCLUDE NOTES ON UNDERSTANDING THE DATA, SOURCES AND SOME EXTRA DATA/CHARTS AS WELL AS VARIOUS ISSUES I'VE PICKED UP ON SINCE EARLY MARCH

2	207	Tue	18/08			#DIV/0!	#DIV/0!			-	-	-						-							-	-	11	-			?	-	1,016	252084	80297					My LinkedIn	My other work:
3	206	Mon	17/08							-	-	-						-							-	-	12	-			?	-	989	Largest single-day jump in confirmed cases		Cases to go until 'herd immunity' (60%)		Leave a comment with any requests or errors!			My tracking of Covid-19/Respiratory Death data	A comparison of all sets of UK death data I can find. Initially was just my breakdown of ONS's current/historical data on deaths by respiratory disease (now including COVID-19). Going back to 2015.
4	205	Sun	16/08	318484	1040	-3.4%	0.33%	14503645		-	-	-	182987					-	41366			5			-	-	13	0.00%			?	-	986	6244		39,840,000		Updated daily around 2pm. All figures sourced from:			My personal tips for preparation/quarantine	Advice and tips I've gathered/fact-checked which might not be obvious to everyone.
5	204	Sat	15/08	317444	1077	-25.2%	0.34%	14320621		-	-	-	177957					-	41361			3			-	-	13	0.00%			?	-	964	Peak mortality	1172	0.000000%	- % of UK population confirmed infected	@DHSCgovuk	GOV.UK website	(or additional sources listed on "Notes" tab)	Timeline of Boris Johnson's spreading in March	Please share the Tweet - I've spent a lot of time putting this together and feel it's very important for accountability.
6	203	Fri	14/08	316367	1440	27.5%	0.46%	14142736		-	-	-	169857					-	41358			11			-	-	13	0.00%			?	-	942	Test results/figures relevant up until 9am day of posting /// Death figures relevant up til 5pm the day before (from 25/03)
7	202	Thu	13/08	314927	1129	11.9%	0.36%	13971512		-	-	-	184444					-	41347			18			-	-	13	0.00%			?	-	902								Updates/Notes/Theories:
8	201	Wed	12/08	313798	1009	-12.1%	0.32%	13785297		-	-	-	166311					-	41329			20			-	-	13	0.00%			?	-	882								22/06 - As you may have noticed, the "people tested" figure has been lacking for some time now, due to the government not providing this figure for several weeks. As such, some of the other calculations (and associated figures/charts) also haven't been updated. Sadly, there's nothing I can do about this but hopefully we'll be provided the figures again in future (with the missing numbers backdated)
9	200	Tue	11/08	312789	1148	40.7%	0.37%	13618470		-	-	-	164061					-	41309			13			-	-	12	0.00%			?	-	864								20/05 - An update on GOV.UK states that cumulative totals (for confirmed/positive cases) on previous days may chance. This means each day's total cases may be lower than expected. As such, the total cases figure/charts going forward may give an uneven picture (unless the government start providing which prior days' totals have retroactively changed)
10	199	Mon	10/08	311641	816	-23.2%	0.26%	13453361		-	-	-	166207					-	41296			18			-	-	13	0.00%		337089	49.31%	-	824								10/04 - The official figures today included a two week total of "Pillar 2" tests/cases. Daily breakdowns of these can be viewed in the "Figures - Prelim & Comparisons" tab. I've now adjusted the daily totals on this main sheet to include the Pillar 2 cases. This marks the first major retroactive adjustment of my data here, but I felt it best for transparency. Going forward, the running total should include these Pillar 2 cases.
11	198	Sun	09/08	310825	1062	40.1%	0.34%	13286362		-	-	-	165176					-	41278			5			-	-	10	0.00%		335327	49.26%	-	814								02/04 - Matt Hancock/the government pledged 100,000 daily tests by the end of April.
12	197	Sat	08/08	309763	758	-13.0%	0.25%	13121091		-	-	-	181864					-	41273			3			-	-	10	0.00%		338042	53.80%	-	792								31/03 - I've started tracking current/historical data for deaths by respiratory disease in England Wales, that can be found in the list of below resources or at: https://docs.google.com/spreadsheets/d/1tZdV6aiOh6ZJGwEvbs-lo4uPptezKM4tl7L0F9ye7XE
13	196	Fri	07/08	309005	871	-8.3%	0.28%	12938980		-	-	-	185980					-	41270			12			-	-	12	0.00%		343231	54.19%	-	792								22/03 - Thank you for all the well wishers following quarantine of our household. Pleased to report my partner is getting better, but almost certainly (still can't get tested) had Coronavirus. Updated to our quarantine situation/personal situation can be viewed at https://www.gofundme.com/f/uk-coronavirus-case-tracking
14	195	Thu	06/08	308134	950	6.6%	0.31%	12748043		-	-	-	174519					-	41258			18			-	-	13	0.00%		341231	51.14%	-	785								19/03 - The government has (accidentally, Boris slipped up) pledged to increase testing capacity to 250,000. It's also now being reported by UK press what many of us have been saying for weeks now - they could and SHOULD have been testing far higher numbers - https://twitter.com/Peston/status/1240727555151482884
15	194	Wed	05/08	307184	891	33.0%	0.29%	12571991		-	-	-	163422					-	41240			14			-	-	10	0.00%		338731	48.25%	-	772								19/03 - A general note regarding chart errors when today's figures are blank - this will occur occasionally, as I need to manually update formulas and charts each day ahead of the new figures. It will usually only be for a short while (as the numbers usually get entered at/shortly after 2pm) but today we're still waiting on the announcement.
16	193	Tue	04/08	306293	670	-28.6%	0.22%	12407146		-	-	-	158666					-	41226			18			-	-	13	0.00%		338597	46.86%	-	748								18/03 - The government has pledged to increase testing to 25,000 a day
17	192	Mon	03/08	305623	938	26.2%	0.31%	12250937		-	-	-	163786					-	41208			1			-	-	13	0.00%		338413	48.40%	-	732								16/03 - As I'm now on the 4th day of quarantine, I've realised a few bits and bobs I felt worth writing down, so have added these to my list of personal tips. Link below or copy & paste: https://docs.google.com/document/d/1bpPJ0X7rFM56yvJQFz96x8aq42BjgLjMl08CO67IVN4
18	191	Sun	02/08	304685	743	-2.4%	0.24%	12075267		-	-	-	162088					-	41207			5			-	-	14	0.00%		336312	48.20%	-	707								16/03 - The government is currently (via press conference) announcing a change in policy. Part of this includes a mandatory 14 day isolation, which means our house is now (4 days into) a 14 day quarantine. And on top of that, we're potentially facing a 4-month lockdown for my partner's mother. Crazy times.
19	190	Sat	01/08	303942	761	-13.5%	0.25%	11912950		-	-	-	190220					-	41202			13			-	-	14	0.00%		345157	55.11%	-	705								15/03 - Due to the unfortunate sharp increase in fatalities, we'll likely have enough data (minimum of 65 cases) on those by tomorrow/Tuesday to start getting a somewhat accurate mortality rate. As such I'll start plotting the fatalities on a new chart when this point is reached. - [UPDATE] 19/03, will likely be charting fatalities by tomorrow
20	189	Fri	31/07	303181	880	4.0%	0.29%	11722733		-	-	-	206656					-	41189			20			-	-	14	0.00%		344403	60.00%	-	710								14/03 - After a hectic day yesterday, we've got our household (of 3) split into self-quarantines. My symptoms are mild, so I should be ok to spend a fair bit of time on this. My partner's unfortunately a little worse for wear but improving by the day and we're staying positive (though no idea if we're actually positive because we can't get tested due to not being in hospital. Which is great, eh?) We both live with her mid-70s mother, who's in better shape than many 35 year olds and is, thankfully, showing no signs :)
21	188	Thu	30/07	302301	846	10.9%	0.28%	11515652		-	-	-	165480					-	41169			0			-	-	16	0.00%		344403	48.05%	-	696								13/03 - Myself and my partner are showing signs of Coronavirus, as such I may not be able to update this every day/as quickly from now on. Will update you if our situation changes.
22	187	Wed	29/07	301455	763	31.3%	0.25%	11349983		-	-	-	154946					-	41169			34			-	-	17	0.00%		341903	45.32%	-	682								11/03 - I've added a tab/sheet called "Hospital Signage Issue" to keep track of a massive problem I noticed where COVID-19 infected people have been entering NHS hospitals and health centres for weeks, due to massively outdated posters in use. Please help to highlight/share this on social media so I can find more photos/highlight it to the press.
23	186	Tue	28/07	300692	581	-15.2%	0.19%	11195038		-	-	-	99090					-	41135			21			-	-	15	0.00%		339809	29.16%	-	666								11/03 - Government has announced plans to increase tests to 10,000 a day. States previous capacity was 2000, but obviously this begs the question - why weren't testing numbers increased last week/even sooner?
24	185	Mon	27/07	300111	685	-8.1%	0.23%	11095717		-	-	-	113424					-	41114			3			-	-	16	0.00%		338585	33.50%	-	713
25	184	Sun	26/07	299426	745	-2.9%	0.25%	10975936		-	-	-	142954					-	41111			8			-	-	17	0.00%		336802	42.44%	-	702								Other resources:
26	183	Sat	25/07	298681	767	-0.1%	0.26%	10832984		-	-	-	157229					-	41103			15			-	-	17	0.00%		330647	47.55%	-	695								14days.me	A place for anybody to share their experiences with COVID-19. Be it lockdown, quarantine, frontline work or helping a loved on. If you need a place to voice your story, head to 14days.me
27	182	Fri	24/07	297914	768	-0.1%	0.26%	10675176		-	-	-	152133					-	41088			32			-	-	16	0.00%		330026	46.10%	-	699								UK Coronavirus case tracker	Official government tracker (interactive map, plus data) for regional COVID-19 cases
28	181	Thu	23/07	297146	769	37.3%	0.26%	10523054		-	-	-	147595					-	41056			9			-	-	15	0.00%		330026	44.72%	-	680								http://coviduk.ga/	Real-time charts/analytics on UK cases	Made by:	@coviduktrack on Twitter
29	180	Wed	22/07	296377	560	25.8%	0.19%	10375459		-	-	-	142559					-	41047			17			-	-	17	0.00%		327526	43.53%	-	671								https://covid19cct.shinyapps.io/covid19cct/	Tracking of UK C-19 cases at the county-level, by Alex Bowring			No longer updated -	http://whereisitin.london	An interactive map of London COVID-19 infected locations. Made by:	Brandon Jackson on Twitter
30	179	Tue	21/07	295817	445	-23.3%	0.15%	10232901		-	-	-	101741					-	41030			25			-	-	19	0.00%		327432	31.07%	-	676								Misc:
31	178	Mon	20/07	295372	580	-20.1%	0.20%	10130116		-	-	-	125050					-	41005			10			-	-	21	0.00%		318829	39.22%	-	686								My 14days.me Diary	My personal diary on the 14days.me website, I'll be adding to this over coming days/weeks as I get more time.
32	177	Sun	19/07	294792	726	-12.2%	0.25%	10009148		-	-	-	140393					-	40995			11			-	-	21	0.00%		317451	44.23%	-	670								https://sourceful.co.uk/doc/1	Sourceful link for this spreadsheet - please give it an upvote (click the little ^up^ arrow above the title) to raise awareness!
33	176	Sat	18/07	294066	827	20.4%	0.28%	9868579		-	-	-	177625					-	40984			9			-	-	21	0.00%		319706	55.56%	-	655								GoFundMe Link	Just in case you missed it up there :P
34	175	Fri	17/07	293239	687	7.2%	0.23%	9690514		-	-	-	165966					-	40975			26			-	-	22	0.00%		326877	50.77%	-	640
35	174	Thu	16/07	292552	641	19.1%	0.22%	9524251		-	-	-	152063					-	40949			24			-	-	23	0.00%		349870	43.46%	-	628
36	173	Wed	15/07	291911	538	-56.6%	0.18%	9368703		-	-	-	132121					-	40925			26			-	-	24	0.00%		345870	38.20%	-	624
37	172	Tue	14/07	291373	1240	134.0%	0.43%	9235686		-	-	-	97403					-	40899			44		?	-	-	29	0.00%		339755	28.67%	-	644
38	171	Mon	13/07	290133	530	-18.5%	0.18%	9139226		-	-	-	101927					-	40855			10			-	-	30	0.00%		337626	30.19%	-	605
39	170	Sun	12/07	289603	650	-20.7%	0.22%	9036673		-	-	-	134890					-	40845			9		0	-	-	30	0.00%		336521	40.08%	-	625