cases

173 rows where AreaCode = "W11000023"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date (date)

Link Date Country AreaCode Area TotalCases
2020-02-03,Wales,W11000023,Betsi Cadwaladr 2020-02-03 Wales W11000023 Betsi Cadwaladr 0
2020-02-04,Wales,W11000023,Betsi Cadwaladr 2020-02-04 Wales W11000023 Betsi Cadwaladr 0
2020-02-05,Wales,W11000023,Betsi Cadwaladr 2020-02-05 Wales W11000023 Betsi Cadwaladr 0
2020-02-06,Wales,W11000023,Betsi Cadwaladr 2020-02-06 Wales W11000023 Betsi Cadwaladr 0
2020-02-07,Wales,W11000023,Betsi Cadwaladr 2020-02-07 Wales W11000023 Betsi Cadwaladr 0
2020-02-08,Wales,W11000023,Betsi Cadwaladr 2020-02-08 Wales W11000023 Betsi Cadwaladr 0
2020-02-09,Wales,W11000023,Betsi Cadwaladr 2020-02-09 Wales W11000023 Betsi Cadwaladr 0
2020-02-10,Wales,W11000023,Betsi Cadwaladr 2020-02-10 Wales W11000023 Betsi Cadwaladr 0
2020-02-11,Wales,W11000023,Betsi Cadwaladr 2020-02-11 Wales W11000023 Betsi Cadwaladr 0
2020-02-12,Wales,W11000023,Betsi Cadwaladr 2020-02-12 Wales W11000023 Betsi Cadwaladr 0
2020-02-13,Wales,W11000023,Betsi Cadwaladr 2020-02-13 Wales W11000023 Betsi Cadwaladr 0
2020-02-14,Wales,W11000023,Betsi Cadwaladr 2020-02-14 Wales W11000023 Betsi Cadwaladr 0
2020-02-15,Wales,W11000023,Betsi Cadwaladr 2020-02-15 Wales W11000023 Betsi Cadwaladr 0
2020-02-16,Wales,W11000023,Betsi Cadwaladr 2020-02-16 Wales W11000023 Betsi Cadwaladr 0
2020-02-17,Wales,W11000023,Betsi Cadwaladr 2020-02-17 Wales W11000023 Betsi Cadwaladr 0
2020-02-18,Wales,W11000023,Betsi Cadwaladr 2020-02-18 Wales W11000023 Betsi Cadwaladr 0
2020-02-19,Wales,W11000023,Betsi Cadwaladr 2020-02-19 Wales W11000023 Betsi Cadwaladr 0
2020-02-20,Wales,W11000023,Betsi Cadwaladr 2020-02-20 Wales W11000023 Betsi Cadwaladr 0
2020-02-21,Wales,W11000023,Betsi Cadwaladr 2020-02-21 Wales W11000023 Betsi Cadwaladr 0
2020-02-22,Wales,W11000023,Betsi Cadwaladr 2020-02-22 Wales W11000023 Betsi Cadwaladr 0
2020-02-23,Wales,W11000023,Betsi Cadwaladr 2020-02-23 Wales W11000023 Betsi Cadwaladr 0
2020-02-24,Wales,W11000023,Betsi Cadwaladr 2020-02-24 Wales W11000023 Betsi Cadwaladr 0
2020-02-25,Wales,W11000023,Betsi Cadwaladr 2020-02-25 Wales W11000023 Betsi Cadwaladr 0
2020-02-26,Wales,W11000023,Betsi Cadwaladr 2020-02-26 Wales W11000023 Betsi Cadwaladr 0
2020-02-27,Wales,W11000023,Betsi Cadwaladr 2020-02-27 Wales W11000023 Betsi Cadwaladr 0
2020-02-28,Wales,W11000023,Betsi Cadwaladr 2020-02-28 Wales W11000023 Betsi Cadwaladr 0
2020-02-29,Wales,W11000023,Betsi Cadwaladr 2020-02-29 Wales W11000023 Betsi Cadwaladr 0
2020-03-01,Wales,W11000023,Betsi Cadwaladr 2020-03-01 Wales W11000023 Betsi Cadwaladr 0
2020-03-02,Wales,W11000023,Betsi Cadwaladr 2020-03-02 Wales W11000023 Betsi Cadwaladr 0
2020-03-03,Wales,W11000023,Betsi Cadwaladr 2020-03-03 Wales W11000023 Betsi Cadwaladr 0
2020-03-04,Wales,W11000023,Betsi Cadwaladr 2020-03-04 Wales W11000023 Betsi Cadwaladr 0
2020-03-05,Wales,W11000023,Betsi Cadwaladr 2020-03-05 Wales W11000023 Betsi Cadwaladr 0
2020-03-06,Wales,W11000023,Betsi Cadwaladr 2020-03-06 Wales W11000023 Betsi Cadwaladr 0
2020-03-07,Wales,W11000023,Betsi Cadwaladr 2020-03-07 Wales W11000023 Betsi Cadwaladr 0
2020-03-08,Wales,W11000023,Betsi Cadwaladr 2020-03-08 Wales W11000023 Betsi Cadwaladr 0
2020-03-09,Wales,W11000023,Betsi Cadwaladr 2020-03-09 Wales W11000023 Betsi Cadwaladr 0
2020-03-10,Wales,W11000023,Betsi Cadwaladr 2020-03-10 Wales W11000023 Betsi Cadwaladr 1
2020-03-11,Wales,W11000023,Betsi Cadwaladr 2020-03-11 Wales W11000023 Betsi Cadwaladr 3
2020-03-12,Wales,W11000023,Betsi Cadwaladr 2020-03-12 Wales W11000023 Betsi Cadwaladr 4
2020-03-13,Wales,W11000023,Betsi Cadwaladr 2020-03-13 Wales W11000023 Betsi Cadwaladr 4
2020-03-14,Wales,W11000023,Betsi Cadwaladr 2020-03-14 Wales W11000023 Betsi Cadwaladr 6
2020-03-15,Wales,W11000023,Betsi Cadwaladr 2020-03-15 Wales W11000023 Betsi Cadwaladr 6
2020-03-16,Wales,W11000023,Betsi Cadwaladr 2020-03-16 Wales W11000023 Betsi Cadwaladr 7
2020-03-17,Wales,W11000023,Betsi Cadwaladr 2020-03-17 Wales W11000023 Betsi Cadwaladr 7
2020-03-18,Wales,W11000023,Betsi Cadwaladr 2020-03-18 Wales W11000023 Betsi Cadwaladr 9
2020-03-19,Wales,W11000023,Betsi Cadwaladr 2020-03-19 Wales W11000023 Betsi Cadwaladr 11
2020-03-20,Wales,W11000023,Betsi Cadwaladr 2020-03-20 Wales W11000023 Betsi Cadwaladr 12
2020-03-21,Wales,W11000023,Betsi Cadwaladr 2020-03-21 Wales W11000023 Betsi Cadwaladr 16
2020-03-22,Wales,W11000023,Betsi Cadwaladr 2020-03-22 Wales W11000023 Betsi Cadwaladr 20
2020-03-23,Wales,W11000023,Betsi Cadwaladr 2020-03-23 Wales W11000023 Betsi Cadwaladr 22
2020-03-24,Wales,W11000023,Betsi Cadwaladr 2020-03-24 Wales W11000023 Betsi Cadwaladr 32
2020-03-25,Wales,W11000023,Betsi Cadwaladr 2020-03-25 Wales W11000023 Betsi Cadwaladr 50
2020-03-26,Wales,W11000023,Betsi Cadwaladr 2020-03-26 Wales W11000023 Betsi Cadwaladr 63
2020-03-27,Wales,W11000023,Betsi Cadwaladr 2020-03-27 Wales W11000023 Betsi Cadwaladr 71
2020-03-28,Wales,W11000023,Betsi Cadwaladr 2020-03-28 Wales W11000023 Betsi Cadwaladr 82
2020-03-29,Wales,W11000023,Betsi Cadwaladr 2020-03-29 Wales W11000023 Betsi Cadwaladr 88
2020-03-30,Wales,W11000023,Betsi Cadwaladr 2020-03-30 Wales W11000023 Betsi Cadwaladr 116
2020-03-31,Wales,W11000023,Betsi Cadwaladr 2020-03-31 Wales W11000023 Betsi Cadwaladr 138
2020-04-01,Wales,W11000023,Betsi Cadwaladr 2020-04-01 Wales W11000023 Betsi Cadwaladr 161
2020-04-02,Wales,W11000023,Betsi Cadwaladr 2020-04-02 Wales W11000023 Betsi Cadwaladr 188
2020-04-03,Wales,W11000023,Betsi Cadwaladr 2020-04-03 Wales W11000023 Betsi Cadwaladr 216
2020-04-04,Wales,W11000023,Betsi Cadwaladr 2020-04-04 Wales W11000023 Betsi Cadwaladr 237
2020-04-05,Wales,W11000023,Betsi Cadwaladr 2020-04-05 Wales W11000023 Betsi Cadwaladr 249
2020-04-06,Wales,W11000023,Betsi Cadwaladr 2020-04-06 Wales W11000023 Betsi Cadwaladr 289
2020-04-07,Wales,W11000023,Betsi Cadwaladr 2020-04-07 Wales W11000023 Betsi Cadwaladr 342
2020-04-08,Wales,W11000023,Betsi Cadwaladr 2020-04-08 Wales W11000023 Betsi Cadwaladr 383
2020-04-09,Wales,W11000023,Betsi Cadwaladr 2020-04-09 Wales W11000023 Betsi Cadwaladr 439
2020-04-10,Wales,W11000023,Betsi Cadwaladr 2020-04-10 Wales W11000023 Betsi Cadwaladr 478
2020-04-11,Wales,W11000023,Betsi Cadwaladr 2020-04-11 Wales W11000023 Betsi Cadwaladr 518
2020-04-12,Wales,W11000023,Betsi Cadwaladr 2020-04-12 Wales W11000023 Betsi Cadwaladr 561
2020-04-13,Wales,W11000023,Betsi Cadwaladr 2020-04-13 Wales W11000023 Betsi Cadwaladr 613
2020-04-14,Wales,W11000023,Betsi Cadwaladr 2020-04-14 Wales W11000023 Betsi Cadwaladr 676
2020-04-15,Wales,W11000023,Betsi Cadwaladr 2020-04-15 Wales W11000023 Betsi Cadwaladr 732
2020-04-16,Wales,W11000023,Betsi Cadwaladr 2020-04-16 Wales W11000023 Betsi Cadwaladr 788
2020-04-17,Wales,W11000023,Betsi Cadwaladr 2020-04-17 Wales W11000023 Betsi Cadwaladr 849
2020-04-18,Wales,W11000023,Betsi Cadwaladr 2020-04-18 Wales W11000023 Betsi Cadwaladr 901
2020-04-19,Wales,W11000023,Betsi Cadwaladr 2020-04-19 Wales W11000023 Betsi Cadwaladr 935
2020-04-20,Wales,W11000023,Betsi Cadwaladr 2020-04-20 Wales W11000023 Betsi Cadwaladr 1011
2020-04-21,Wales,W11000023,Betsi Cadwaladr 2020-04-21 Wales W11000023 Betsi Cadwaladr 1054
2020-04-22,Wales,W11000023,Betsi Cadwaladr 2020-04-22 Wales W11000023 Betsi Cadwaladr 1092
2020-04-23,Wales,W11000023,Betsi Cadwaladr 2020-04-23 Wales W11000023 Betsi Cadwaladr 1132
2020-04-24,Wales,W11000023,Betsi Cadwaladr 2020-04-24 Wales W11000023 Betsi Cadwaladr 1175
2020-04-25,Wales,W11000023,Betsi Cadwaladr 2020-04-25 Wales W11000023 Betsi Cadwaladr 1195
2020-04-26,Wales,W11000023,Betsi Cadwaladr 2020-04-26 Wales W11000023 Betsi Cadwaladr 1224
2020-04-27,Wales,W11000023,Betsi Cadwaladr 2020-04-27 Wales W11000023 Betsi Cadwaladr 1269
2020-04-28,Wales,W11000023,Betsi Cadwaladr 2020-04-28 Wales W11000023 Betsi Cadwaladr 1302
2020-04-29,Wales,W11000023,Betsi Cadwaladr 2020-04-29 Wales W11000023 Betsi Cadwaladr 1345
2020-04-30,Wales,W11000023,Betsi Cadwaladr 2020-04-30 Wales W11000023 Betsi Cadwaladr 1408
2020-05-01,Wales,W11000023,Betsi Cadwaladr 2020-05-01 Wales W11000023 Betsi Cadwaladr 1462
2020-05-02,Wales,W11000023,Betsi Cadwaladr 2020-05-02 Wales W11000023 Betsi Cadwaladr 1515
2020-05-03,Wales,W11000023,Betsi Cadwaladr 2020-05-03 Wales W11000023 Betsi Cadwaladr 1560
2020-05-04,Wales,W11000023,Betsi Cadwaladr 2020-05-04 Wales W11000023 Betsi Cadwaladr 1630
2020-05-05,Wales,W11000023,Betsi Cadwaladr 2020-05-05 Wales W11000023 Betsi Cadwaladr 1678
2020-05-06,Wales,W11000023,Betsi Cadwaladr 2020-05-06 Wales W11000023 Betsi Cadwaladr 1745
2020-05-07,Wales,W11000023,Betsi Cadwaladr 2020-05-07 Wales W11000023 Betsi Cadwaladr 1796
2020-05-08,Wales,W11000023,Betsi Cadwaladr 2020-05-08 Wales W11000023 Betsi Cadwaladr 1832
2020-05-09,Wales,W11000023,Betsi Cadwaladr 2020-05-09 Wales W11000023 Betsi Cadwaladr 1900
2020-05-10,Wales,W11000023,Betsi Cadwaladr 2020-05-10 Wales W11000023 Betsi Cadwaladr 1933
2020-05-11,Wales,W11000023,Betsi Cadwaladr 2020-05-11 Wales W11000023 Betsi Cadwaladr 2022
2020-05-12,Wales,W11000023,Betsi Cadwaladr 2020-05-12 Wales W11000023 Betsi Cadwaladr 2075

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);
Powered by Datasette · Query took 63.766ms · About: https://github.com/tomwhite/covid-19-uk-data