cases

19 rows where TotalCases = 300

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-27,Wales,W11000029,Cardiff and Vale	2020-03-27	Wales	W11000029	Cardiff and Vale	300
2020-04-04,England,E06000015,Derby	2020-04-04	England	E06000015	Derby	300
2020-04-06,Wales,W11000025,Hywel Dda	2020-04-06	Wales	W11000025	Hywel Dda	300
2020-04-07,England,E09000002,Barking and Dagenham	2020-04-07	England	E09000002	Barking and Dagenham	300
2020-04-11,England,E06000052,Cornwall and Isles of Scilly	2020-04-11	England	E06000052	Cornwall and Isles of Scilly	300
2020-04-12,England,E09000027,Richmond upon Thames	2020-04-12	England	E09000027	Richmond upon Thames	300
2020-04-15,England,E06000055,Bedford	2020-04-15	England	E06000055	Bedford	300
2020-04-20,England,E06000025,South Gloucestershire	2020-04-20	England	E06000025	South Gloucestershire	300
2020-04-28,England,E06000024,North Somerset	2020-04-28	England	E06000024	North Somerset	300
2020-05-03,England,E06000040,Windsor and Maidenhead	2020-05-03	England	E06000040	Windsor and Maidenhead	300
2020-06-01,Wales,W11000024,Powys	2020-06-01	Wales	W11000024	Powys	300
2020-07-18,Scotland,S08000017,Dumfries and Galloway	2020-07-18	Scotland	S08000017	Dumfries and Galloway	300
2020-07-19,Scotland,S08000017,Dumfries and Galloway	2020-07-19	Scotland	S08000017	Dumfries and Galloway	300
2020-07-20,Scotland,S08000017,Dumfries and Galloway	2020-07-20	Scotland	S08000017	Dumfries and Galloway	300
2020-07-21,Scotland,S08000017,Dumfries and Galloway	2020-07-21	Scotland	S08000017	Dumfries and Galloway	300
2020-07-22,Scotland,S08000017,Dumfries and Galloway	2020-07-22	Scotland	S08000017	Dumfries and Galloway	300
2020-07-23,Scotland,S08000017,Dumfries and Galloway	2020-07-23	Scotland	S08000017	Dumfries and Galloway	300
2020-07-24,Scotland,S08000017,Dumfries and Galloway	2020-07-24	Scotland	S08000017	Dumfries and Galloway	300
2020-07-25,Scotland,S08000017,Dumfries and Galloway	2020-07-25	Scotland	S08000017	Dumfries and Galloway	300

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