cases

173 rows where Area = "Cardiff and Vale"

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-06-22,Wales,W11000029,Cardiff and Vale	2020-06-22	Wales	W11000029	Cardiff and Vale	3003
2020-06-23,Wales,W11000029,Cardiff and Vale	2020-06-23	Wales	W11000029	Cardiff and Vale	3006
2020-06-24,Wales,W11000029,Cardiff and Vale	2020-06-24	Wales	W11000029	Cardiff and Vale	3008
2020-06-25,Wales,W11000029,Cardiff and Vale	2020-06-25	Wales	W11000029	Cardiff and Vale	3012
2020-06-26,Wales,W11000029,Cardiff and Vale	2020-06-26	Wales	W11000029	Cardiff and Vale	3013
2020-06-27,Wales,W11000029,Cardiff and Vale	2020-06-27	Wales	W11000029	Cardiff and Vale	3024
2020-06-28,Wales,W11000029,Cardiff and Vale	2020-06-28	Wales	W11000029	Cardiff and Vale	3028
2020-06-29,Wales,W11000029,Cardiff and Vale	2020-06-29	Wales	W11000029	Cardiff and Vale	3032
2020-06-30,Wales,W11000029,Cardiff and Vale	2020-06-30	Wales	W11000029	Cardiff and Vale	3036
2020-07-01,Wales,W11000029,Cardiff and Vale	2020-07-01	Wales	W11000029	Cardiff and Vale	3039
2020-07-02,Wales,W11000029,Cardiff and Vale	2020-07-02	Wales	W11000029	Cardiff and Vale	3042
2020-07-03,Wales,W11000029,Cardiff and Vale	2020-07-03	Wales	W11000029	Cardiff and Vale	3045
2020-07-04,Wales,W11000029,Cardiff and Vale	2020-07-04	Wales	W11000029	Cardiff and Vale	3046
2020-07-05,Wales,W11000029,Cardiff and Vale	2020-07-05	Wales	W11000029	Cardiff and Vale	3050
2020-07-06,Wales,W11000029,Cardiff and Vale	2020-07-06	Wales	W11000029	Cardiff and Vale	3054
2020-07-07,Wales,W11000029,Cardiff and Vale	2020-07-07	Wales	W11000029	Cardiff and Vale	3057
2020-07-08,Wales,W11000029,Cardiff and Vale	2020-07-08	Wales	W11000029	Cardiff and Vale	3057
2020-07-09,Wales,W11000029,Cardiff and Vale	2020-07-09	Wales	W11000029	Cardiff and Vale	3057
2020-07-10,Wales,W11000029,Cardiff and Vale	2020-07-10	Wales	W11000029	Cardiff and Vale	3062
2020-07-11,Wales,W11000029,Cardiff and Vale	2020-07-11	Wales	W11000029	Cardiff and Vale	3062
2020-07-12,Wales,W11000029,Cardiff and Vale	2020-07-12	Wales	W11000029	Cardiff and Vale	3063
2020-07-13,Wales,W11000029,Cardiff and Vale	2020-07-13	Wales	W11000029	Cardiff and Vale	3064
2020-07-14,Wales,W11000029,Cardiff and Vale	2020-07-14	Wales	W11000029	Cardiff and Vale	3066
2020-07-15,Wales,W11000029,Cardiff and Vale	2020-07-15	Wales	W11000029	Cardiff and Vale	3070
2020-07-16,Wales,W11000029,Cardiff and Vale	2020-07-16	Wales	W11000029	Cardiff and Vale	3071
2020-07-17,Wales,W11000029,Cardiff and Vale	2020-07-17	Wales	W11000029	Cardiff and Vale	3073
2020-07-18,Wales,W11000029,Cardiff and Vale	2020-07-18	Wales	W11000029	Cardiff and Vale	3073
2020-07-19,Wales,W11000029,Cardiff and Vale	2020-07-19	Wales	W11000029	Cardiff and Vale	3073
2020-07-20,Wales,W11000029,Cardiff and Vale	2020-07-20	Wales	W11000029	Cardiff and Vale	3078
2020-07-21,Wales,W11000029,Cardiff and Vale	2020-07-21	Wales	W11000029	Cardiff and Vale	3087
2020-07-22,Wales,W11000029,Cardiff and Vale	2020-07-22	Wales	W11000029	Cardiff and Vale	3090
2020-07-23,Wales,W11000029,Cardiff and Vale	2020-07-23	Wales	W11000029	Cardiff and Vale	3091
2020-07-24,Wales,W11000029,Cardiff and Vale	2020-07-24	Wales	W11000029	Cardiff and Vale	3091

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