cases

15 rows where TotalCases = 374

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-25,England,E10000014,Hampshire	2020-03-25	England	E10000014	Hampshire	374
2020-04-01,England,E10000025,Oxfordshire	2020-04-01	England	E10000025	Oxfordshire	374
2020-04-08,England,E10000003,Cambridgeshire	2020-04-08	England	E10000003	Cambridgeshire	374
2020-04-10,England,E06000016,Leicester	2020-04-10	England	E06000016	Leicester	374
2020-04-18,England,E06000038,Reading	2020-04-18	England	E06000038	Reading	374
2020-04-27,England,E06000006,Halton	2020-04-27	England	E06000006	Halton	374
2020-05-03,Northern Ireland,N09000002,Armagh City, Banbridge and Craigavon	2020-05-03	Northern Ireland	N09000002	Armagh City, Banbridge and Craigavon	374
2020-05-05,Northern Ireland,N09000007,Lisburn and Castlereagh	2020-05-05	Northern Ireland	N09000007	Lisburn and Castlereagh	374
2020-05-24,England,E06000046,Isle of Wight	2020-05-24	England	E06000046	Isle of Wight	374
2020-06-23,Scotland,S08000022,Highland	2020-06-23	Scotland	S08000022	Highland	374
2020-06-24,Scotland,S08000022,Highland	2020-06-24	Scotland	S08000022	Highland	374
2020-06-25,Scotland,S08000022,Highland	2020-06-25	Scotland	S08000022	Highland	374
2020-06-26,Scotland,S08000022,Highland	2020-06-26	Scotland	S08000022	Highland	374
2020-06-27,England,E06000036,Bracknell Forest	2020-06-27	England	E06000036	Bracknell Forest	374
2020-06-27,Scotland,S08000022,Highland	2020-06-27	Scotland	S08000022	Highland	374

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])
);