covid-19-uk

Custom SQL query returning 43 rows (hide)

Query parameters

This data as json, CSV

DateCountryAreaCodeAreaTotalCases
2020-07-21 England E10000011 East Sussex 1588
2020-07-21 England E10000012 Essex 5606
2020-07-21 England E10000013 Gloucestershire 1858
2020-07-21 England E10000014 Hampshire 5068
2020-07-21 England E10000015 Hertfordshire 4225
2020-07-21 England E10000016 Kent 8002
2020-07-21 England E10000017 Lancashire 6941
2020-07-21 England E10000018 Leicestershire 3221
2020-07-21 England E10000019 Lincolnshire 2491
2020-07-21 England E10000020 Norfolk 2883
2020-07-21 England E10000021 Northamptonshire 3426
2020-07-21 England E10000024 Nottinghamshire 3023
2020-07-21 England E10000025 Oxfordshire 3188
2020-07-21 England E10000027 Somerset 1299
2020-07-21 England E10000028 Staffordshire 3790
2020-07-21 England E10000029 Suffolk 2654
2020-07-21 England E10000030 Surrey 4666
2020-07-21 England E10000031 Warwickshire 2539
2020-07-21 England E10000032 West Sussex 2771
2020-07-21 England E10000034 Worcestershire 2394
2020-07-21 Scotland S08000015 Ayrshire and Arran 1269
2020-07-21 Scotland S08000016 Borders 346
2020-07-21 Scotland S08000017 Dumfries and Galloway 300
2020-07-21 Scotland S08000019 Forth Valley 1092
2020-07-21 Scotland S08000020 Grampian 1440
2020-07-21 Scotland S08000022 Highland 378
2020-07-21 Scotland S08000024 Lothian 3181
2020-07-21 Scotland S08000025 Orkney 9
2020-07-21 Scotland S08000026 Shetland 54
2020-07-21 Scotland S08000028 Western Isles 7
2020-07-21 Scotland S08000029 Fife 937
2020-07-21 Scotland S08000030 Tayside 1781
2020-07-21 Scotland S08000031 Greater Glasgow and Clyde 4918
2020-07-21 Scotland S08000032 Lanarkshire 2762
2020-07-21 Wales   Outside Wales 137
2020-07-21 Wales   Unknown 142
2020-07-21 Wales W11000023 Betsi Cadwaladr 4469
2020-07-21 Wales W11000024 Powys 345
2020-07-21 Wales W11000025 Hywel Dda 1169
2020-07-21 Wales W11000028 Aneurin Bevan 2728
2020-07-21 Wales W11000029 Cardiff and Vale 3087
2020-07-21 Wales W11000030 Cwm Taf 3011
2020-07-21 Wales W11000031 Swansea Bay 1984
Powered by Datasette · Query took 14.653ms · About: https://github.com/tomwhite/covid-19-uk-data