cases

173 rows where Area = "Swansea Bay"

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-06-22,Wales,W11000031,Swansea Bay	2020-06-22	Wales	W11000031	Swansea Bay	1940
2020-06-23,Wales,W11000031,Swansea Bay	2020-06-23	Wales	W11000031	Swansea Bay	1941
2020-06-24,Wales,W11000031,Swansea Bay	2020-06-24	Wales	W11000031	Swansea Bay	1941
2020-06-25,Wales,W11000031,Swansea Bay	2020-06-25	Wales	W11000031	Swansea Bay	1942
2020-06-26,Wales,W11000031,Swansea Bay	2020-06-26	Wales	W11000031	Swansea Bay	1942
2020-06-27,Wales,W11000031,Swansea Bay	2020-06-27	Wales	W11000031	Swansea Bay	1942
2020-06-28,Wales,W11000031,Swansea Bay	2020-06-28	Wales	W11000031	Swansea Bay	1943
2020-06-29,Wales,W11000031,Swansea Bay	2020-06-29	Wales	W11000031	Swansea Bay	1943
2020-06-30,Wales,W11000031,Swansea Bay	2020-06-30	Wales	W11000031	Swansea Bay	1946
2020-07-01,Wales,W11000031,Swansea Bay	2020-07-01	Wales	W11000031	Swansea Bay	1947
2020-07-02,Wales,W11000031,Swansea Bay	2020-07-02	Wales	W11000031	Swansea Bay	1951
2020-07-03,Wales,W11000031,Swansea Bay	2020-07-03	Wales	W11000031	Swansea Bay	1953
2020-07-04,Wales,W11000031,Swansea Bay	2020-07-04	Wales	W11000031	Swansea Bay	1953
2020-07-05,Wales,W11000031,Swansea Bay	2020-07-05	Wales	W11000031	Swansea Bay	1954
2020-07-06,Wales,W11000031,Swansea Bay	2020-07-06	Wales	W11000031	Swansea Bay	1956
2020-07-07,Wales,W11000031,Swansea Bay	2020-07-07	Wales	W11000031	Swansea Bay	1959
2020-07-08,Wales,W11000031,Swansea Bay	2020-07-08	Wales	W11000031	Swansea Bay	1961
2020-07-09,Wales,W11000031,Swansea Bay	2020-07-09	Wales	W11000031	Swansea Bay	1961
2020-07-10,Wales,W11000031,Swansea Bay	2020-07-10	Wales	W11000031	Swansea Bay	1962
2020-07-11,Wales,W11000031,Swansea Bay	2020-07-11	Wales	W11000031	Swansea Bay	1963
2020-07-12,Wales,W11000031,Swansea Bay	2020-07-12	Wales	W11000031	Swansea Bay	1966
2020-07-13,Wales,W11000031,Swansea Bay	2020-07-13	Wales	W11000031	Swansea Bay	1969
2020-07-14,Wales,W11000031,Swansea Bay	2020-07-14	Wales	W11000031	Swansea Bay	1971
2020-07-15,Wales,W11000031,Swansea Bay	2020-07-15	Wales	W11000031	Swansea Bay	1973
2020-07-16,Wales,W11000031,Swansea Bay	2020-07-16	Wales	W11000031	Swansea Bay	1975
2020-07-17,Wales,W11000031,Swansea Bay	2020-07-17	Wales	W11000031	Swansea Bay	1975
2020-07-18,Wales,W11000031,Swansea Bay	2020-07-18	Wales	W11000031	Swansea Bay	1976
2020-07-19,Wales,W11000031,Swansea Bay	2020-07-19	Wales	W11000031	Swansea Bay	1977
2020-07-20,Wales,W11000031,Swansea Bay	2020-07-20	Wales	W11000031	Swansea Bay	1979
2020-07-21,Wales,W11000031,Swansea Bay	2020-07-21	Wales	W11000031	Swansea Bay	1984
2020-07-22,Wales,W11000031,Swansea Bay	2020-07-22	Wales	W11000031	Swansea Bay	1986
2020-07-23,Wales,W11000031,Swansea Bay	2020-07-23	Wales	W11000031	Swansea Bay	1986
2020-07-24,Wales,W11000031,Swansea Bay	2020-07-24	Wales	W11000031	Swansea Bay	1986

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