cases

173 rows where Area = "Betsi Cadwaladr"

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-06-22,Wales,W11000023,Betsi Cadwaladr	2020-06-22	Wales	W11000023	Betsi Cadwaladr	3991
2020-06-23,Wales,W11000023,Betsi Cadwaladr	2020-06-23	Wales	W11000023	Betsi Cadwaladr	4087
2020-06-24,Wales,W11000023,Betsi Cadwaladr	2020-06-24	Wales	W11000023	Betsi Cadwaladr	4111
2020-06-25,Wales,W11000023,Betsi Cadwaladr	2020-06-25	Wales	W11000023	Betsi Cadwaladr	4155
2020-06-26,Wales,W11000023,Betsi Cadwaladr	2020-06-26	Wales	W11000023	Betsi Cadwaladr	4165
2020-06-27,Wales,W11000023,Betsi Cadwaladr	2020-06-27	Wales	W11000023	Betsi Cadwaladr	4178
2020-06-28,Wales,W11000023,Betsi Cadwaladr	2020-06-28	Wales	W11000023	Betsi Cadwaladr	4191
2020-06-29,Wales,W11000023,Betsi Cadwaladr	2020-06-29	Wales	W11000023	Betsi Cadwaladr	4213
2020-06-30,Wales,W11000023,Betsi Cadwaladr	2020-06-30	Wales	W11000023	Betsi Cadwaladr	4232
2020-07-01,Wales,W11000023,Betsi Cadwaladr	2020-07-01	Wales	W11000023	Betsi Cadwaladr	4248
2020-07-02,Wales,W11000023,Betsi Cadwaladr	2020-07-02	Wales	W11000023	Betsi Cadwaladr	4264
2020-07-03,Wales,W11000023,Betsi Cadwaladr	2020-07-03	Wales	W11000023	Betsi Cadwaladr	4271
2020-07-04,Wales,W11000023,Betsi Cadwaladr	2020-07-04	Wales	W11000023	Betsi Cadwaladr	4274
2020-07-05,Wales,W11000023,Betsi Cadwaladr	2020-07-05	Wales	W11000023	Betsi Cadwaladr	4277
2020-07-06,Wales,W11000023,Betsi Cadwaladr	2020-07-06	Wales	W11000023	Betsi Cadwaladr	4291
2020-07-07,Wales,W11000023,Betsi Cadwaladr	2020-07-07	Wales	W11000023	Betsi Cadwaladr	4302
2020-07-08,Wales,W11000023,Betsi Cadwaladr	2020-07-08	Wales	W11000023	Betsi Cadwaladr	4310
2020-07-09,Wales,W11000023,Betsi Cadwaladr	2020-07-09	Wales	W11000023	Betsi Cadwaladr	4326
2020-07-10,Wales,W11000023,Betsi Cadwaladr	2020-07-10	Wales	W11000023	Betsi Cadwaladr	4341
2020-07-11,Wales,W11000023,Betsi Cadwaladr	2020-07-11	Wales	W11000023	Betsi Cadwaladr	4350
2020-07-12,Wales,W11000023,Betsi Cadwaladr	2020-07-12	Wales	W11000023	Betsi Cadwaladr	4355
2020-07-13,Wales,W11000023,Betsi Cadwaladr	2020-07-13	Wales	W11000023	Betsi Cadwaladr	4369
2020-07-14,Wales,W11000023,Betsi Cadwaladr	2020-07-14	Wales	W11000023	Betsi Cadwaladr	4383
2020-07-15,Wales,W11000023,Betsi Cadwaladr	2020-07-15	Wales	W11000023	Betsi Cadwaladr	4391
2020-07-16,Wales,W11000023,Betsi Cadwaladr	2020-07-16	Wales	W11000023	Betsi Cadwaladr	4403
2020-07-17,Wales,W11000023,Betsi Cadwaladr	2020-07-17	Wales	W11000023	Betsi Cadwaladr	4412
2020-07-18,Wales,W11000023,Betsi Cadwaladr	2020-07-18	Wales	W11000023	Betsi Cadwaladr	4419
2020-07-19,Wales,W11000023,Betsi Cadwaladr	2020-07-19	Wales	W11000023	Betsi Cadwaladr	4426
2020-07-20,Wales,W11000023,Betsi Cadwaladr	2020-07-20	Wales	W11000023	Betsi Cadwaladr	4450
2020-07-21,Wales,W11000023,Betsi Cadwaladr	2020-07-21	Wales	W11000023	Betsi Cadwaladr	4469
2020-07-22,Wales,W11000023,Betsi Cadwaladr	2020-07-22	Wales	W11000023	Betsi Cadwaladr	4476
2020-07-23,Wales,W11000023,Betsi Cadwaladr	2020-07-23	Wales	W11000023	Betsi Cadwaladr	4487
2020-07-24,Wales,W11000023,Betsi Cadwaladr	2020-07-24	Wales	W11000023	Betsi Cadwaladr	4487

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