cases

22,757 rows

View and edit SQL

Country

Link Date Country AreaCode Area TotalCases
2020-03-16 England E08000033 Calderdale 5
2020-03-16 England E08000034 Kirklees 6
2020-03-16 England E08000035 Leeds 15
2020-03-16 England E09000002 Barking and Dagenham 19
2020-03-16 England E09000003 Barnet 63
2020-03-16 England E09000004 Bexley 25
2020-03-16 England E09000005 Brent 56
2020-03-16 England E09000006 Bromley 39
2020-03-16 England E09000007 Camden 37
2020-03-16 England E09000008 Croydon 53
2020-03-16 England E09000009 Ealing 52
2020-03-16 England E09000010 Enfield 31
2020-03-16 England E09000011 Greenwich 32
2020-03-16 England E09000012 Hackney and City of London 36
2020-03-16 England E09000013 Hammersmith and Fulham 32
2020-03-16 England E09000014 Haringey 34
2020-03-16 England E09000015 Harrow 51
2020-03-16 England E09000016 Havering 16
2020-03-16 England E09000017 Hillingdon 32
2020-03-16 England E09000018 Hounslow 36
2020-03-16 England E09000019 Islington 37
2020-03-16 England E09000020 Kensington and Chelsea 62
2020-03-16 England E09000021 Kingston upon Thames 15
2020-03-16 England E09000022 Lambeth 84
2020-03-16 England E09000023 Lewisham 40
2020-03-16 England E09000024 Merton 40
2020-03-16 England E09000025 Newham 30
2020-03-16 England E09000026 Redbridge 18
2020-03-16 England E09000027 Richmond upon Thames 13
2020-03-16 England E09000028 Southwark 91
2020-03-16 England E09000029 Sutton 17
2020-03-16 England E09000030 Tower Hamlets 28
2020-03-16 England E09000031 Waltham Forest 17
2020-03-16 England E09000032 Wandsworth 78
2020-03-16 England E09000033 Westminster 89
2020-03-16 England E10000002 Buckinghamshire 52
2020-03-16 England E10000003 Cambridgeshire 18
2020-03-16 England E10000006 Cumbria 44
2020-03-16 England E10000007 Derbyshire 62
2020-03-16 England E10000008 Devon 39
2020-03-16 England E10000011 East Sussex 8
2020-03-16 England E10000012 Essex 45
2020-03-16 England E10000013 Gloucestershire 19
2020-03-16 England E10000014 Hampshire 103
2020-03-16 England E10000015 Hertfordshire 68
2020-03-16 England E10000016 Kent 46
2020-03-16 England E10000017 Lancashire 24
2020-03-16 England E10000018 Leicestershire 19
2020-03-16 England E10000020 Norfolk 17
2020-03-16 England E10000021 Northamptonshire 21
2020-03-16 England E10000023 North Yorkshire 14
2020-03-16 England E10000024 Nottinghamshire 41
2020-03-16 England E10000025 Oxfordshire 37
2020-03-16 England E10000028 Staffordshire 35
2020-03-16 England E10000029 Suffolk 17
2020-03-16 England E10000030 Surrey 75
2020-03-16 England E10000031 Warwickshire 31
2020-03-16 England E10000032 West Sussex 21
2020-03-16 England E10000034 Worcestershire 22
2020-03-16 Scotland S08000015 Ayrshire and Arran 6
2020-03-16 Scotland S08000016 Borders 7
2020-03-16 Scotland S08000017 Dumfries and Galloway NaN
2020-03-16 Scotland S08000019 Forth Valley 10
2020-03-16 Scotland S08000020 Grampian 12
2020-03-16 Scotland S08000022 Highland NaN
2020-03-16 Scotland S08000024 Lothian 29
2020-03-16 Scotland S08000025 Orkney NaN
2020-03-16 Scotland S08000026 Shetland 15
2020-03-16 Scotland S08000028 Western Isles NaN
2020-03-16 Scotland S08000029 Fife 7
2020-03-16 Scotland S08000030 Tayside 17
2020-03-16 Scotland S08000031 Greater Glasgow and Clyde 44
2020-03-16 Scotland S08000032 Lanarkshire 20
2020-03-16 Wales   Outside Wales 2
2020-03-16 Wales   Unknown 3
2020-03-16 Wales W11000023 Betsi Cadwaladr 7
2020-03-16 Wales W11000024 Powys 9
2020-03-16 Wales W11000025 Hywel Dda 11
2020-03-16 Wales W11000028 Aneurin Bevan 82
2020-03-16 Wales W11000029 Cardiff and Vale 23
2020-03-16 Wales W11000030 Cwm Taf 7
2020-03-16 Wales W11000031 Swansea Bay 32
2020-03-17 England E06000003 Redcar and Cleveland 2
2020-03-17 England E06000004 Stockton-on-Tees 9
2020-03-17 England E06000006 Halton 7
2020-03-17 England E06000009 Blackpool 6
2020-03-17 England E06000011 East Riding of Yorkshire 13
2020-03-17 England E06000014 York 7
2020-03-17 England E06000015 Derby 20
2020-03-17 England E06000016 Leicester 8
2020-03-17 England E06000018 Nottingham 23
2020-03-17 England E06000019 Herefordshire, County of 7
2020-03-17 England E06000021 Stoke-on-Trent 4
2020-03-17 England E06000023 Bristol, City of 15
2020-03-17 England E06000024 North Somerset 5
2020-03-17 England E06000025 South Gloucestershire 14
2020-03-17 England E06000027 Torbay 9
2020-03-17 England E06000030 Swindon 6
2020-03-17 England E06000032 Luton 8
2020-03-17 England E06000033 Southend-on-Sea 8

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);
Powered by Datasette · Query took 44.713ms · About: https://github.com/tomwhite/covid-19-uk-data