cases

27 rows where TotalCases = 45

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-12,England,E09000028,Southwark	2020-03-12	England	E09000028	Southwark	45
2020-03-13,England,E09000022,Lambeth	2020-03-13	England	E09000022	Lambeth	45
2020-03-15,England,E10000007,Derbyshire	2020-03-15	England	E10000007	Derbyshire	45
2020-03-16,England,E10000012,Essex	2020-03-16	England	E10000012	Essex	45
2020-03-19,England,E06000039,Slough	2020-03-19	England	E06000039	Slough	45
2020-03-20,England,E08000012,Liverpool	2020-03-20	England	E08000012	Liverpool	45
2020-03-20,England,E10000021,Northamptonshire	2020-03-20	England	E10000021	Northamptonshire	45
2020-03-21,England,E06000015,Derby	2020-03-21	England	E06000015	Derby	45
2020-03-22,England,E08000006,Salford	2020-03-22	England	E08000006	Salford	45
2020-03-22,England,E08000009,Trafford	2020-03-22	England	E08000009	Trafford	45
2020-03-23,England,E06000035,Medway	2020-03-23	England	E06000035	Medway	45
2020-03-23,England,E06000044,Portsmouth	2020-03-23	England	E06000044	Portsmouth	45
2020-03-24,England,E08000029,Solihull	2020-03-24	England	E08000029	Solihull	45
2020-03-27,England,E06000038,Reading	2020-03-27	England	E06000038	Reading	45
2020-03-27,England,E06000058,Bournemouth, Christchurch and Poole	2020-03-27	England	E06000058	Bournemouth, Christchurch and Poole	45
2020-03-27,Scotland,S08000020,Grampian	2020-03-27	Scotland	S08000020	Grampian	45
2020-03-28,England,E08000037,Gateshead	2020-03-28	England	E08000037	Gateshead	45
2020-04-01,Wales,W11000024,Powys	2020-04-01	Wales	W11000024	Powys	45
2020-04-02,England,E06000013,North Lincolnshire	2020-04-02	England	E06000013	North Lincolnshire	45
2020-04-10,Wales,,Unknown	2020-04-10	Wales		Unknown	45
2020-04-11,Wales,,Unknown	2020-04-11	Wales		Unknown	45
2020-04-13,Scotland,S08000026,Shetland	2020-04-13	Scotland	S08000026	Shetland	45
2020-04-14,Scotland,S08000026,Shetland	2020-04-14	Scotland	S08000026	Shetland	45
2020-04-15,Scotland,S08000026,Shetland	2020-04-15	Scotland	S08000026	Shetland	45
2020-04-16,Scotland,S08000026,Shetland	2020-04-16	Scotland	S08000026	Shetland	45
2020-04-17,Scotland,S08000026,Shetland	2020-04-17	Scotland	S08000026	Shetland	45
2020-04-18,Scotland,S08000026,Shetland	2020-04-18	Scotland	S08000026	Shetland	45

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