cases

1,557 rows where Country = "Wales"

✎ View and edit SQL

This data as json, CSV (advanced)

Country ✖

  • Wales · 809 ✖
Link Date Country AreaCode Area TotalCases
2020-04-26,Wales,,Unknown 2020-04-26 Wales   Unknown 64
2020-04-26,Wales,W11000023,Betsi Cadwaladr 2020-04-26 Wales W11000023 Betsi Cadwaladr 1224
2020-04-26,Wales,W11000024,Powys 2020-04-26 Wales W11000024 Powys 166
2020-04-26,Wales,W11000025,Hywel Dda 2020-04-26 Wales W11000025 Hywel Dda 704
2020-04-26,Wales,W11000028,Aneurin Bevan 2020-04-26 Wales W11000028 Aneurin Bevan 2064
2020-04-26,Wales,W11000029,Cardiff and Vale 2020-04-26 Wales W11000029 Cardiff and Vale 2163
2020-04-26,Wales,W11000030,Cwm Taf 2020-04-26 Wales W11000030 Cwm Taf 1699
2020-04-26,Wales,W11000031,Swansea Bay 2020-04-26 Wales W11000031 Swansea Bay 1518
2020-04-27,Wales,,Outside Wales 2020-04-27 Wales   Outside Wales 88
2020-04-27,Wales,,Unknown 2020-04-27 Wales   Unknown 65
2020-04-27,Wales,W11000023,Betsi Cadwaladr 2020-04-27 Wales W11000023 Betsi Cadwaladr 1269
2020-04-27,Wales,W11000024,Powys 2020-04-27 Wales W11000024 Powys 171
2020-04-27,Wales,W11000025,Hywel Dda 2020-04-27 Wales W11000025 Hywel Dda 722
2020-04-27,Wales,W11000028,Aneurin Bevan 2020-04-27 Wales W11000028 Aneurin Bevan 2086
2020-04-27,Wales,W11000029,Cardiff and Vale 2020-04-27 Wales W11000029 Cardiff and Vale 2186
2020-04-27,Wales,W11000030,Cwm Taf 2020-04-27 Wales W11000030 Cwm Taf 1738
2020-04-27,Wales,W11000031,Swansea Bay 2020-04-27 Wales W11000031 Swansea Bay 1536
2020-04-28,Wales,,Outside Wales 2020-04-28 Wales   Outside Wales 89
2020-04-28,Wales,,Unknown 2020-04-28 Wales   Unknown 66
2020-04-28,Wales,W11000023,Betsi Cadwaladr 2020-04-28 Wales W11000023 Betsi Cadwaladr 1302
2020-04-28,Wales,W11000024,Powys 2020-04-28 Wales W11000024 Powys 172
2020-04-28,Wales,W11000025,Hywel Dda 2020-04-28 Wales W11000025 Hywel Dda 729
2020-04-28,Wales,W11000028,Aneurin Bevan 2020-04-28 Wales W11000028 Aneurin Bevan 2107
2020-04-28,Wales,W11000029,Cardiff and Vale 2020-04-28 Wales W11000029 Cardiff and Vale 2217
2020-04-28,Wales,W11000030,Cwm Taf 2020-04-28 Wales W11000030 Cwm Taf 1776
2020-04-28,Wales,W11000031,Swansea Bay 2020-04-28 Wales W11000031 Swansea Bay 1556
2020-04-29,Wales,,Outside Wales 2020-04-29 Wales   Outside Wales 93
2020-04-29,Wales,,Unknown 2020-04-29 Wales   Unknown 66
2020-04-29,Wales,W11000023,Betsi Cadwaladr 2020-04-29 Wales W11000023 Betsi Cadwaladr 1345
2020-04-29,Wales,W11000024,Powys 2020-04-29 Wales W11000024 Powys 180
2020-04-29,Wales,W11000025,Hywel Dda 2020-04-29 Wales W11000025 Hywel Dda 748
2020-04-29,Wales,W11000028,Aneurin Bevan 2020-04-29 Wales W11000028 Aneurin Bevan 2125
2020-04-29,Wales,W11000029,Cardiff and Vale 2020-04-29 Wales W11000029 Cardiff and Vale 2236
2020-04-29,Wales,W11000030,Cwm Taf 2020-04-29 Wales W11000030 Cwm Taf 1808
2020-04-29,Wales,W11000031,Swansea Bay 2020-04-29 Wales W11000031 Swansea Bay 1589
2020-04-30,Wales,,Outside Wales 2020-04-30 Wales   Outside Wales 94
2020-04-30,Wales,,Unknown 2020-04-30 Wales   Unknown 66
2020-04-30,Wales,W11000023,Betsi Cadwaladr 2020-04-30 Wales W11000023 Betsi Cadwaladr 1408
2020-04-30,Wales,W11000024,Powys 2020-04-30 Wales W11000024 Powys 186
2020-04-30,Wales,W11000025,Hywel Dda 2020-04-30 Wales W11000025 Hywel Dda 761
2020-04-30,Wales,W11000028,Aneurin Bevan 2020-04-30 Wales W11000028 Aneurin Bevan 2151
2020-04-30,Wales,W11000029,Cardiff and Vale 2020-04-30 Wales W11000029 Cardiff and Vale 2274
2020-04-30,Wales,W11000030,Cwm Taf 2020-04-30 Wales W11000030 Cwm Taf 1837
2020-04-30,Wales,W11000031,Swansea Bay 2020-04-30 Wales W11000031 Swansea Bay 1613
2020-05-01,Wales,,Outside Wales 2020-05-01 Wales   Outside Wales 97
2020-05-01,Wales,,Unknown 2020-05-01 Wales   Unknown 66
2020-05-01,Wales,W11000023,Betsi Cadwaladr 2020-05-01 Wales W11000023 Betsi Cadwaladr 1462
2020-05-01,Wales,W11000024,Powys 2020-05-01 Wales W11000024 Powys 190
2020-05-01,Wales,W11000025,Hywel Dda 2020-05-01 Wales W11000025 Hywel Dda 772
2020-05-01,Wales,W11000028,Aneurin Bevan 2020-05-01 Wales W11000028 Aneurin Bevan 2170
2020-05-01,Wales,W11000029,Cardiff and Vale 2020-05-01 Wales W11000029 Cardiff and Vale 2303
2020-05-01,Wales,W11000030,Cwm Taf 2020-05-01 Wales W11000030 Cwm Taf 1873
2020-05-01,Wales,W11000031,Swansea Bay 2020-05-01 Wales W11000031 Swansea Bay 1633
2020-05-02,Wales,,Outside Wales 2020-05-02 Wales   Outside Wales 99
2020-05-02,Wales,,Unknown 2020-05-02 Wales   Unknown 66
2020-05-02,Wales,W11000023,Betsi Cadwaladr 2020-05-02 Wales W11000023 Betsi Cadwaladr 1515
2020-05-02,Wales,W11000024,Powys 2020-05-02 Wales W11000024 Powys 200
2020-05-02,Wales,W11000025,Hywel Dda 2020-05-02 Wales W11000025 Hywel Dda 773
2020-05-02,Wales,W11000028,Aneurin Bevan 2020-05-02 Wales W11000028 Aneurin Bevan 2215
2020-05-02,Wales,W11000029,Cardiff and Vale 2020-05-02 Wales W11000029 Cardiff and Vale 2329
2020-05-02,Wales,W11000030,Cwm Taf 2020-05-02 Wales W11000030 Cwm Taf 1903
2020-05-02,Wales,W11000031,Swansea Bay 2020-05-02 Wales W11000031 Swansea Bay 1645
2020-05-03,Wales,,Outside Wales 2020-05-03 Wales   Outside Wales 99
2020-05-03,Wales,,Unknown 2020-05-03 Wales   Unknown 66
2020-05-03,Wales,W11000023,Betsi Cadwaladr 2020-05-03 Wales W11000023 Betsi Cadwaladr 1560
2020-05-03,Wales,W11000024,Powys 2020-05-03 Wales W11000024 Powys 200
2020-05-03,Wales,W11000025,Hywel Dda 2020-05-03 Wales W11000025 Hywel Dda 774
2020-05-03,Wales,W11000028,Aneurin Bevan 2020-05-03 Wales W11000028 Aneurin Bevan 2230
2020-05-03,Wales,W11000029,Cardiff and Vale 2020-05-03 Wales W11000029 Cardiff and Vale 2344
2020-05-03,Wales,W11000030,Cwm Taf 2020-05-03 Wales W11000030 Cwm Taf 1925
2020-05-03,Wales,W11000031,Swansea Bay 2020-05-03 Wales W11000031 Swansea Bay 1652
2020-05-04,Wales,,Outside Wales 2020-05-04 Wales   Outside Wales 100
2020-05-04,Wales,,Unknown 2020-05-04 Wales   Unknown 67
2020-05-04,Wales,W11000023,Betsi Cadwaladr 2020-05-04 Wales W11000023 Betsi Cadwaladr 1630
2020-05-04,Wales,W11000024,Powys 2020-05-04 Wales W11000024 Powys 201
2020-05-04,Wales,W11000025,Hywel Dda 2020-05-04 Wales W11000025 Hywel Dda 783
2020-05-04,Wales,W11000028,Aneurin Bevan 2020-05-04 Wales W11000028 Aneurin Bevan 2244
2020-05-04,Wales,W11000029,Cardiff and Vale 2020-05-04 Wales W11000029 Cardiff and Vale 2357
2020-05-04,Wales,W11000030,Cwm Taf 2020-05-04 Wales W11000030 Cwm Taf 1943
2020-05-04,Wales,W11000031,Swansea Bay 2020-05-04 Wales W11000031 Swansea Bay 1664
2020-05-05,Wales,,Outside Wales 2020-05-05 Wales   Outside Wales 103
2020-05-05,Wales,,Unknown 2020-05-05 Wales   Unknown 68
2020-05-05,Wales,W11000023,Betsi Cadwaladr 2020-05-05 Wales W11000023 Betsi Cadwaladr 1678
2020-05-05,Wales,W11000024,Powys 2020-05-05 Wales W11000024 Powys 206
2020-05-05,Wales,W11000025,Hywel Dda 2020-05-05 Wales W11000025 Hywel Dda 797
2020-05-05,Wales,W11000028,Aneurin Bevan 2020-05-05 Wales W11000028 Aneurin Bevan 2268
2020-05-05,Wales,W11000029,Cardiff and Vale 2020-05-05 Wales W11000029 Cardiff and Vale 2376
2020-05-05,Wales,W11000030,Cwm Taf 2020-05-05 Wales W11000030 Cwm Taf 1992
2020-05-05,Wales,W11000031,Swansea Bay 2020-05-05 Wales W11000031 Swansea Bay 1676
2020-05-06,Wales,,Outside Wales 2020-05-06 Wales   Outside Wales 103
2020-05-06,Wales,,Unknown 2020-05-06 Wales   Unknown 69
2020-05-06,Wales,W11000023,Betsi Cadwaladr 2020-05-06 Wales W11000023 Betsi Cadwaladr 1745
2020-05-06,Wales,W11000024,Powys 2020-05-06 Wales W11000024 Powys 209
2020-05-06,Wales,W11000025,Hywel Dda 2020-05-06 Wales W11000025 Hywel Dda 826
2020-05-06,Wales,W11000028,Aneurin Bevan 2020-05-06 Wales W11000028 Aneurin Bevan 2296
2020-05-06,Wales,W11000029,Cardiff and Vale 2020-05-06 Wales W11000029 Cardiff and Vale 2390
2020-05-06,Wales,W11000030,Cwm Taf 2020-05-06 Wales W11000030 Cwm Taf 2011
2020-05-06,Wales,W11000031,Swansea Bay 2020-05-06 Wales W11000031 Swansea Bay 1686
2020-05-07,Wales,,Outside Wales 2020-05-07 Wales   Outside Wales 105
2020-05-07,Wales,,Unknown 2020-05-07 Wales   Unknown 69

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 46.834ms · About: https://github.com/tomwhite/covid-19-uk-data