cases

17 rows where TotalCases = 102

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-22,England,E09000011,Greenwich	2020-03-22	England	E09000011	Greenwich	102
2020-03-22,Wales,W11000029,Cardiff and Vale	2020-03-22	Wales	W11000029	Cardiff and Vale	102
2020-03-24,England,E09000031,Waltham Forest	2020-03-24	England	E09000031	Waltham Forest	102
2020-03-29,England,E06000016,Leicester	2020-03-29	England	E06000016	Leicester	102
2020-03-29,Wales,W11000025,Hywel Dda	2020-03-29	Wales	W11000025	Hywel Dda	102
2020-03-30,England,E06000051,Shropshire	2020-03-30	England	E06000051	Shropshire	102
2020-03-31,England,E08000001,Bolton	2020-03-31	England	E08000001	Bolton	102
2020-03-31,England,E08000037,Gateshead	2020-03-31	England	E08000037	Gateshead	102
2020-04-01,England,E06000055,Bedford	2020-04-01	England	E06000055	Bedford	102
2020-04-03,England,E06000037,West Berkshire	2020-04-03	England	E06000037	West Berkshire	102
2020-04-04,England,E06000026,Plymouth	2020-04-04	England	E06000026	Plymouth	102
2020-04-06,Northern Ireland,N09000011,North Down and Ards	2020-04-06	Northern Ireland	N09000011	North Down and Ards	102
2020-04-06,Scotland,S08000022,Highland	2020-04-06	Scotland	S08000022	Highland	102
2020-04-10,England,E06000019,Herefordshire, County of	2020-04-10	England	E06000019	Herefordshire, County of	102
2020-04-10,Northern Ireland,N09000008,Mid and East Antrim	2020-04-10	Northern Ireland	N09000008	Mid and East Antrim	102
2020-04-10,Northern Ireland,N09000010,Newry, Mourne and Down	2020-04-10	Northern Ireland	N09000010	Newry, Mourne and Down	102
2020-04-18,England,E06000012,North East Lincolnshire	2020-04-18	England	E06000012	North East Lincolnshire	102

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