covid-19-uk

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

DateCountryAreaCodeAreaTotalCases
2020-04-16 England E06000014 York 170
2020-04-16 England E10000034 Worcestershire 905
2020-04-16 England E08000031 Wolverhampton 557
2020-04-16 England E06000041 Wokingham 263
2020-04-16 England E08000015 Wirral 766
2020-04-16 England E06000040 Windsor and Maidenhead 208
2020-04-16 England E06000054 Wiltshire 316
2020-04-16 England E08000010 Wigan 562
2020-04-16 England E09000033 Westminster 570
2020-04-16 Scotland S08000028 Western Isles 6
2020-04-16 England E10000032 West Sussex 895
2020-04-16 England E06000037 West Berkshire 224
2020-04-16 England E10000031 Warwickshire 855
2020-04-16 England E06000007 Warrington 464
2020-04-16 England E09000032 Wandsworth 858
2020-04-16 England E09000031 Waltham Forest 671
2020-04-16 England E08000030 Walsall 672
2020-04-16 England E08000036 Wakefield 428
2020-04-16 Northern Ireland   Unknown 26
2020-04-16 Wales   Unknown 53
2020-04-16 England E08000009 Trafford 479
2020-04-16 England E09000030 Tower Hamlets 578
2020-04-16 England E06000027 Torbay 111
2020-04-16 England E06000034 Thurrock 247
2020-04-16 England E06000020 Telford and Wrekin 152
2020-04-16 Scotland S08000030 Tayside 937
2020-04-16 England E08000008 Tameside 379
2020-04-16 England E06000030 Swindon 257
2020-04-16 Wales W11000031 Swansea Bay 1130
2020-04-16 England E09000029 Sutton 609
2020-04-16 England E10000030 Surrey 2149
2020-04-16 England E08000024 Sunderland 858
2020-04-16 England E10000029 Suffolk 659
2020-04-16 England E06000021 Stoke-on-Trent 275
2020-04-16 England E06000004 Stockton-on-Tees 265
2020-04-16 England E08000007 Stockport 642
2020-04-16 England E10000028 Staffordshire 1222
2020-04-16 England E08000013 St. Helens 483
2020-04-16 England E09000028 Southwark 1116
2020-04-16 England E06000033 Southend-on-Sea 256
2020-04-16 England E06000045 Southampton 326
2020-04-16 England E08000023 South Tyneside 339
2020-04-16 England E06000025 South Gloucestershire 256
2020-04-16 England E10000027 Somerset 314
2020-04-16 England E08000029 Solihull 434
2020-04-16 England E06000039 Slough 309
2020-04-16 England E06000051 Shropshire 301
2020-04-16 Scotland S08000026 Shetland 45
2020-04-16 England E08000019 Sheffield 1643
2020-04-16 England E08000014 Sefton 654
2020-04-16 England E08000028 Sandwell 691
2020-04-16 England E08000006 Salford 563
2020-04-16 England E06000017 Rutland 15
2020-04-16 England E08000018 Rotherham 494
2020-04-16 England E08000005 Rochdale 436
2020-04-16 England E09000027 Richmond upon Thames 337
2020-04-16 England E06000003 Redcar and Cleveland 215
2020-04-16 England E09000026 Redbridge 634
2020-04-16 England E06000038 Reading 348
2020-04-16 Wales W11000024 Powys 123
2020-04-16 England E06000044 Portsmouth 224
2020-04-16 England E06000026 Plymouth 199
2020-04-16 England E06000031 Peterborough 153
2020-04-16 England E10000025 Oxfordshire 1179
2020-04-16 Wales   Outside Wales 66
2020-04-16 Scotland S08000025 Orkney 5
2020-04-16 England E08000004 Oldham 583
2020-04-16 England E10000024 Nottinghamshire 933
2020-04-16 England E06000018 Nottingham 394
2020-04-16 England E06000057 Northumberland 600
2020-04-16 England E10000021 Northamptonshire 877
2020-04-16 England E10000023 North Yorkshire 629
2020-04-16 England E08000022 North Tyneside 387
2020-04-16 England E06000024 North Somerset 135
2020-04-16 England E06000013 North Lincolnshire 179
2020-04-16 England E06000012 North East Lincolnshire 91
2020-04-16 Northern Ireland N09000011 North Down and Ards 157
2020-04-16 England E10000020 Norfolk 950
2020-04-16 Northern Ireland N09000010 Newry, Mourne and Down 132
2020-04-16 England E09000025 Newham 885
2020-04-16 England E08000021 Newcastle upon Tyne 715
2020-04-16 England E06000042 Milton Keynes 378
2020-04-16 England E06000002 Middlesbrough 370
2020-04-16 Northern Ireland N09000008 Mid and East Antrim 144
2020-04-16 Northern Ireland N09000009 Mid Ulster 111
2020-04-16 England E09000024 Merton 588
2020-04-16 England E06000035 Medway 480
2020-04-16 England E08000003 Manchester 926
2020-04-16 England E06000032 Luton 471
2020-04-16 Scotland S08000024 Lothian 1107
2020-04-16 England E08000012 Liverpool 1138
2020-04-16 Northern Ireland N09000007 Lisburn and Castlereagh 232
2020-04-16 England E10000019 Lincolnshire 642
2020-04-16 England E09000023 Lewisham 838
2020-04-16 England E10000018 Leicestershire 702
2020-04-16 England E06000016 Leicester 464
2020-04-16 England E08000035 Leeds 959
2020-04-16 England E10000017 Lancashire 2066
2020-04-16 Scotland S08000032 Lanarkshire 911
2020-04-16 England E09000022 Lambeth 1034
2020-04-16 England E08000011 Knowsley 402
Powered by Datasette · Query took 11.374ms · About: https://github.com/tomwhite/covid-19-uk-data