cases

47 rows where TotalCases = 13

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-09,England,E10000025,Oxfordshire	2020-03-09	England	E10000025	Oxfordshire	13
2020-03-10,England,E10000007,Derbyshire	2020-03-10	England	E10000007	Derbyshire	13
2020-03-11,England,E08000031,Wolverhampton	2020-03-11	England	E08000031	Wolverhampton	13
2020-03-11,England,E09000012,Hackney and City of London	2020-03-11	England	E09000012	Hackney and City of London	13
2020-03-12,England,E09000004,Bexley	2020-03-12	England	E09000004	Bexley	13
2020-03-12,England,E09000018,Hounslow	2020-03-12	England	E09000018	Hounslow	13
2020-03-13,England,E06000054,Wiltshire	2020-03-13	England	E06000054	Wiltshire	13
2020-03-14,England,E08000009,Trafford	2020-03-14	England	E08000009	Trafford	13
2020-03-14,England,E08000012,Liverpool	2020-03-14	England	E08000012	Liverpool	13
2020-03-14,Scotland,S08000026,Shetland	2020-03-14	Scotland	S08000026	Shetland	13
2020-03-15,England,E06000025,South Gloucestershire	2020-03-15	England	E06000025	South Gloucestershire	13
2020-03-15,England,E06000043,Brighton and Hove	2020-03-15	England	E06000043	Brighton and Hove	13
2020-03-15,England,E08000021,Newcastle upon Tyne	2020-03-15	England	E08000021	Newcastle upon Tyne	13
2020-03-15,Scotland,S08000026,Shetland	2020-03-15	Scotland	S08000026	Shetland	13
2020-03-16,England,E06000035,Medway	2020-03-16	England	E06000035	Medway	13
2020-03-16,England,E08000026,Coventry	2020-03-16	England	E08000026	Coventry	13
2020-03-16,England,E09000027,Richmond upon Thames	2020-03-16	England	E09000027	Richmond upon Thames	13
2020-03-17,England,E06000011,East Riding of Yorkshire	2020-03-17	England	E06000011	East Riding of Yorkshire	13
2020-03-17,England,E06000041,Wokingham	2020-03-17	England	E06000041	Wokingham	13
2020-03-17,England,E08000001,Bolton	2020-03-17	England	E08000001	Bolton	13
2020-03-17,England,E08000005,Rochdale	2020-03-17	England	E08000005	Rochdale	13
2020-03-18,England,E06000016,Leicester	2020-03-18	England	E06000016	Leicester	13
2020-03-18,England,E06000034,Thurrock	2020-03-18	England	E06000034	Thurrock	13
2020-03-18,England,E06000050,Cheshire West and Chester	2020-03-18	England	E06000050	Cheshire West and Chester	13
2020-03-18,England,E10000027,Somerset	2020-03-18	England	E10000027	Somerset	13
2020-03-18,Wales,W11000025,Hywel Dda	2020-03-18	Wales	W11000025	Hywel Dda	13
2020-03-19,England,E06000022,Bath and North East Somerset	2020-03-19	England	E06000022	Bath and North East Somerset	13
2020-03-19,England,E06000059,Dorset	2020-03-19	England	E06000059	Dorset	13
2020-03-19,England,E08000014,Sefton	2020-03-19	England	E08000014	Sefton	13
2020-03-20,England,E08000015,Wirral	2020-03-20	England	E08000015	Wirral	13
2020-03-21,England,E06000014,York	2020-03-21	England	E06000014	York	13
2020-03-21,England,E06000036,Bracknell Forest	2020-03-21	England	E06000036	Bracknell Forest	13
2020-03-21,Scotland,S08000017,Dumfries and Galloway	2020-03-21	Scotland	S08000017	Dumfries and Galloway	13
2020-03-21,Scotland,S08000029,Fife	2020-03-21	Scotland	S08000029	Fife	13
2020-03-22,England,E06000033,Southend-on-Sea	2020-03-22	England	E06000033	Southend-on-Sea	13
2020-03-22,England,E06000055,Bedford	2020-03-22	England	E06000055	Bedford	13
2020-03-22,England,E06000057,Northumberland	2020-03-22	England	E06000057	Northumberland	13
2020-03-23,England,E06000020,Telford and Wrekin	2020-03-23	England	E06000020	Telford and Wrekin	13
2020-03-23,Wales,W11000024,Powys	2020-03-23	Wales	W11000024	Powys	13
2020-03-24,England,E06000006,Halton	2020-03-24	England	E06000006	Halton	13
2020-03-24,Scotland,S08000022,Highland	2020-03-24	Scotland	S08000022	Highland	13
2020-03-26,England,E06000013,North Lincolnshire	2020-03-26	England	E06000013	North Lincolnshire	13
2020-03-26,Northern Ireland,N09000010,Newry, Mourne and Down	2020-03-26	Northern Ireland	N09000010	Newry, Mourne and Down	13
2020-03-27,England,E06000010,Kingston upon Hull, City of	2020-03-27	England	E06000010	Kingston upon Hull, City of	13
2020-03-27,England,E06000046,Isle of Wight	2020-03-27	England	E06000046	Isle of Wight	13
2020-03-27,Wales,,Outside Wales	2020-03-27	Wales		Outside Wales	13
2020-04-12,England,E06000017,Rutland	2020-04-12	England	E06000017	Rutland	13

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