cases

32 rows where TotalCases = 33

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-10 England E09000020 Kensington and Chelsea 33
2020-03-14 England E09000008 Croydon 33
2020-03-14 England E09000015 Harrow 33
2020-03-14 England E09000024 Merton 33
2020-03-14 England E10000016 Kent 33
2020-03-15 England E09000006 Bromley 33
2020-03-18 England E09000031 Waltham Forest 33
2020-03-18 Scotland S08000024 Lothian 33
2020-03-19 England E09000002 Barking and Dagenham 33
2020-03-19 Scotland S08000032 Lanarkshire 33
2020-03-21 England E10000019 Lincolnshire 33
2020-03-22 England E06000016 Leicester 33
2020-03-22 England E10000011 East Sussex 33
2020-03-23 England E06000045 Southampton 33
2020-03-24 England E06000034 Thurrock 33
2020-03-24 England E06000037 West Berkshire 33
2020-03-24 England E06000050 Cheshire West and Chester 33
2020-03-24 England E08000036 Wakefield 33
2020-03-26 England E06000041 Wokingham 33
2020-03-26 England E08000011 Knowsley 33
2020-03-26 Northern Ireland N09000007 Lisburn and Castlereagh 33
2020-03-27 England E06000020 Telford and Wrekin 33
2020-03-27 England E06000021 Stoke-on-Trent 33
2020-03-27 England E06000027 Torbay 33
2020-03-27 Scotland S08000022 Highland 33
2020-03-31 England E06000013 North Lincolnshire 33
2020-04-01 England E06000005 Darlington 33
2020-04-02 Wales   Unknown 33
2020-04-05 England E06000046 Isle of Wight 33
2020-04-05 Wales   Outside Wales 33
2020-04-06 Northern Ireland N09000009 Mid Ulster 33
2020-05-04 England E06000017 Rutland 33

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