cases

41 rows where TotalCases = 177

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country, AreaCode, Area, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-26,England,E10000031,Warwickshire 2020-03-26 England E10000031 Warwickshire 177
2020-03-29,England,E10000013,Gloucestershire 2020-03-29 England E10000013 Gloucestershire 177
2020-03-30,Scotland,S08000030,Tayside 2020-03-30 Scotland S08000030 Tayside 177
2020-03-31,England,E09000027,Richmond upon Thames 2020-03-31 England E09000027 Richmond upon Thames 177
2020-03-31,Scotland,S08000015,Ayrshire and Arran 2020-03-31 Scotland S08000015 Ayrshire and Arran 177
2020-04-01,England,E10000008,Devon 2020-04-01 England E10000008 Devon 177
2020-04-03,England,E08000036,Wakefield 2020-04-03 England E08000036 Wakefield 177
2020-04-03,England,E08000037,Gateshead 2020-04-03 England E08000037 Gateshead 177
2020-04-04,England,E08000008,Tameside 2020-04-04 England E08000008 Tameside 177
2020-04-04,England,E08000011,Knowsley 2020-04-04 England E08000011 Knowsley 177
2020-04-04,Scotland,S08000020,Grampian 2020-04-04 Scotland S08000020 Grampian 177
2020-04-10,Scotland,S08000016,Borders 2020-04-10 Scotland S08000016 Borders 177
2020-05-10,Northern Ireland,N09000004,Causeway Coast and Glens 2020-05-10 Northern Ireland N09000004 Causeway Coast and Glens 177
2020-05-31,England,E06000012,North East Lincolnshire 2020-05-31 England E06000012 North East Lincolnshire 177
2020-06-05,Northern Ireland,N09000005,Derry City and Strabane 2020-06-05 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-06,Northern Ireland,N09000005,Derry City and Strabane 2020-06-06 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-07,Northern Ireland,N09000005,Derry City and Strabane 2020-06-07 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-08,Northern Ireland,N09000005,Derry City and Strabane 2020-06-08 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-09,Northern Ireland,N09000005,Derry City and Strabane 2020-06-09 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-10,Northern Ireland,N09000005,Derry City and Strabane 2020-06-10 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-11,Northern Ireland,N09000005,Derry City and Strabane 2020-06-11 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-12,Northern Ireland,N09000005,Derry City and Strabane 2020-06-12 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-13,Northern Ireland,N09000005,Derry City and Strabane 2020-06-13 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-14,Northern Ireland,N09000005,Derry City and Strabane 2020-06-14 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-15,Northern Ireland,N09000005,Derry City and Strabane 2020-06-15 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-16,Northern Ireland,N09000005,Derry City and Strabane 2020-06-16 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-17,Northern Ireland,N09000005,Derry City and Strabane 2020-06-17 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-18,Northern Ireland,N09000005,Derry City and Strabane 2020-06-18 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-19,Northern Ireland,N09000005,Derry City and Strabane 2020-06-19 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-20,Northern Ireland,N09000005,Derry City and Strabane 2020-06-20 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-21,Northern Ireland,N09000005,Derry City and Strabane 2020-06-21 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-22,Northern Ireland,N09000005,Derry City and Strabane 2020-06-22 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-23,Northern Ireland,N09000005,Derry City and Strabane 2020-06-23 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-24,Northern Ireland,N09000005,Derry City and Strabane 2020-06-24 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-25,Northern Ireland,N09000005,Derry City and Strabane 2020-06-25 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-26,Northern Ireland,N09000005,Derry City and Strabane 2020-06-26 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-27,Northern Ireland,N09000005,Derry City and Strabane 2020-06-27 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-28,Northern Ireland,N09000005,Derry City and Strabane 2020-06-28 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-29,Northern Ireland,N09000005,Derry City and Strabane 2020-06-29 Northern Ireland N09000005 Derry City and Strabane 177
2020-06-30,Northern Ireland,N09000005,Derry City and Strabane 2020-06-30 Northern Ireland N09000005 Derry City and Strabane 177
2020-07-01,Northern Ireland,N09000005,Derry City and Strabane 2020-07-01 Northern Ireland N09000005 Derry City and Strabane 177

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 165.589ms · About: https://github.com/tomwhite/covid-19-uk-data