cases

13 rows where TotalCases = 175

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-22,England,E09000003,Barnet	2020-03-22	England	E09000003	Barnet	175
2020-03-22,England,E10000015,Hertfordshire	2020-03-22	England	E10000015	Hertfordshire	175
2020-03-23,England,E10000007,Derbyshire	2020-03-23	England	E10000007	Derbyshire	175
2020-03-27,England,E10000018,Leicestershire	2020-03-27	England	E10000018	Leicestershire	175
2020-03-29,England,E09000019,Islington	2020-03-29	England	E09000019	Islington	175
2020-04-01,England,E08000009,Trafford	2020-04-01	England	E08000009	Trafford	175
2020-04-02,England,E06000042,Milton Keynes	2020-04-02	England	E06000042	Milton Keynes	175
2020-04-08,England,E06000004,Stockton-on-Tees	2020-04-08	England	E06000004	Stockton-on-Tees	175
2020-04-15,England,E06000005,Darlington	2020-04-15	England	E06000005	Darlington	175
2020-04-18,England,E06000022,Bath and North East Somerset	2020-04-18	England	E06000022	Bath and North East Somerset	175
2020-05-10,Northern Ireland,N09000009,Mid Ulster	2020-05-10	Northern Ireland	N09000009	Mid Ulster	175
2020-05-11,Northern Ireland,N09000009,Mid Ulster	2020-05-11	Northern Ireland	N09000009	Mid Ulster	175
2020-05-29,England,E06000012,North East Lincolnshire	2020-05-29	England	E06000012	North East Lincolnshire	175

Advanced export

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

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);