cases

1,557 rows where Country = "Wales"

✎ View and edit SQL

This data as json, CSV (advanced)

Country ✖

  • Wales · 576 ✖
Link Date Country AreaCode Area TotalCases
2020-05-22,Wales,,Outside Wales 2020-05-22 Wales   Outside Wales 120
2020-05-22,Wales,,Unknown 2020-05-22 Wales   Unknown 79
2020-05-22,Wales,W11000023,Betsi Cadwaladr 2020-05-22 Wales W11000023 Betsi Cadwaladr 2728
2020-05-22,Wales,W11000024,Powys 2020-05-22 Wales W11000024 Powys 276
2020-05-22,Wales,W11000025,Hywel Dda 2020-05-22 Wales W11000025 Hywel Dda 1050
2020-05-22,Wales,W11000028,Aneurin Bevan 2020-05-22 Wales W11000028 Aneurin Bevan 2532
2020-05-22,Wales,W11000029,Cardiff and Vale 2020-05-22 Wales W11000029 Cardiff and Vale 2646
2020-05-22,Wales,W11000030,Cwm Taf 2020-05-22 Wales W11000030 Cwm Taf 2466
2020-05-22,Wales,W11000031,Swansea Bay 2020-05-22 Wales W11000031 Swansea Bay 1864
2020-05-23,Wales,,Outside Wales 2020-05-23 Wales   Outside Wales 120
2020-05-23,Wales,,Unknown 2020-05-23 Wales   Unknown 79
2020-05-23,Wales,W11000023,Betsi Cadwaladr 2020-05-23 Wales W11000023 Betsi Cadwaladr 2776
2020-05-23,Wales,W11000024,Powys 2020-05-23 Wales W11000024 Powys 281
2020-05-23,Wales,W11000025,Hywel Dda 2020-05-23 Wales W11000025 Hywel Dda 1052
2020-05-23,Wales,W11000028,Aneurin Bevan 2020-05-23 Wales W11000028 Aneurin Bevan 2545
2020-05-23,Wales,W11000029,Cardiff and Vale 2020-05-23 Wales W11000029 Cardiff and Vale 2668
2020-05-23,Wales,W11000030,Cwm Taf 2020-05-23 Wales W11000030 Cwm Taf 2486
2020-05-23,Wales,W11000031,Swansea Bay 2020-05-23 Wales W11000031 Swansea Bay 1877
2020-05-24,Wales,,Outside Wales 2020-05-24 Wales   Outside Wales 120
2020-05-24,Wales,,Unknown 2020-05-24 Wales   Unknown 80
2020-05-24,Wales,W11000023,Betsi Cadwaladr 2020-05-24 Wales W11000023 Betsi Cadwaladr 2812
2020-05-24,Wales,W11000024,Powys 2020-05-24 Wales W11000024 Powys 284
2020-05-24,Wales,W11000025,Hywel Dda 2020-05-24 Wales W11000025 Hywel Dda 1053
2020-05-24,Wales,W11000028,Aneurin Bevan 2020-05-24 Wales W11000028 Aneurin Bevan 2550
2020-05-24,Wales,W11000029,Cardiff and Vale 2020-05-24 Wales W11000029 Cardiff and Vale 2685
2020-05-24,Wales,W11000030,Cwm Taf 2020-05-24 Wales W11000030 Cwm Taf 2501
2020-05-24,Wales,W11000031,Swansea Bay 2020-05-24 Wales W11000031 Swansea Bay 1881
2020-05-25,Wales,,Outside Wales 2020-05-25 Wales   Outside Wales 120
2020-05-25,Wales,,Unknown 2020-05-25 Wales   Unknown 81
2020-05-25,Wales,W11000023,Betsi Cadwaladr 2020-05-25 Wales W11000023 Betsi Cadwaladr 2851
2020-05-25,Wales,W11000024,Powys 2020-05-25 Wales W11000024 Powys 288
2020-05-25,Wales,W11000025,Hywel Dda 2020-05-25 Wales W11000025 Hywel Dda 1055
2020-05-25,Wales,W11000028,Aneurin Bevan 2020-05-25 Wales W11000028 Aneurin Bevan 2561
2020-05-25,Wales,W11000029,Cardiff and Vale 2020-05-25 Wales W11000029 Cardiff and Vale 2704
2020-05-25,Wales,W11000030,Cwm Taf 2020-05-25 Wales W11000030 Cwm Taf 2527
2020-05-25,Wales,W11000031,Swansea Bay 2020-05-25 Wales W11000031 Swansea Bay 1885
2020-05-26,Wales,,Outside Wales 2020-05-26 Wales   Outside Wales 120
2020-05-26,Wales,,Unknown 2020-05-26 Wales   Unknown 81
2020-05-26,Wales,W11000023,Betsi Cadwaladr 2020-05-26 Wales W11000023 Betsi Cadwaladr 2906
2020-05-26,Wales,W11000024,Powys 2020-05-26 Wales W11000024 Powys 290
2020-05-26,Wales,W11000025,Hywel Dda 2020-05-26 Wales W11000025 Hywel Dda 1056
2020-05-26,Wales,W11000028,Aneurin Bevan 2020-05-26 Wales W11000028 Aneurin Bevan 2565
2020-05-26,Wales,W11000029,Cardiff and Vale 2020-05-26 Wales W11000029 Cardiff and Vale 2716
2020-05-26,Wales,W11000030,Cwm Taf 2020-05-26 Wales W11000030 Cwm Taf 2549
2020-05-26,Wales,W11000031,Swansea Bay 2020-05-26 Wales W11000031 Swansea Bay 1891
2020-05-27,Wales,,Outside Wales 2020-05-27 Wales   Outside Wales 120
2020-05-27,Wales,,Unknown 2020-05-27 Wales   Unknown 81
2020-05-27,Wales,W11000023,Betsi Cadwaladr 2020-05-27 Wales W11000023 Betsi Cadwaladr 2956
2020-05-27,Wales,W11000024,Powys 2020-05-27 Wales W11000024 Powys 295
2020-05-27,Wales,W11000025,Hywel Dda 2020-05-27 Wales W11000025 Hywel Dda 1057
2020-05-27,Wales,W11000028,Aneurin Bevan 2020-05-27 Wales W11000028 Aneurin Bevan 2583
2020-05-27,Wales,W11000029,Cardiff and Vale 2020-05-27 Wales W11000029 Cardiff and Vale 2735
2020-05-27,Wales,W11000030,Cwm Taf 2020-05-27 Wales W11000030 Cwm Taf 2573
2020-05-27,Wales,W11000031,Swansea Bay 2020-05-27 Wales W11000031 Swansea Bay 1892
2020-05-28,Wales,,Outside Wales 2020-05-28 Wales   Outside Wales 120
2020-05-28,Wales,,Unknown 2020-05-28 Wales   Unknown 81
2020-05-28,Wales,W11000023,Betsi Cadwaladr 2020-05-28 Wales W11000023 Betsi Cadwaladr 3005
2020-05-28,Wales,W11000024,Powys 2020-05-28 Wales W11000024 Powys 297
2020-05-28,Wales,W11000025,Hywel Dda 2020-05-28 Wales W11000025 Hywel Dda 1064
2020-05-28,Wales,W11000028,Aneurin Bevan 2020-05-28 Wales W11000028 Aneurin Bevan 2590
2020-05-28,Wales,W11000029,Cardiff and Vale 2020-05-28 Wales W11000029 Cardiff and Vale 2757
2020-05-28,Wales,W11000030,Cwm Taf 2020-05-28 Wales W11000030 Cwm Taf 2587
2020-05-28,Wales,W11000031,Swansea Bay 2020-05-28 Wales W11000031 Swansea Bay 1893
2020-05-29,Wales,,Outside Wales 2020-05-29 Wales   Outside Wales 120
2020-05-29,Wales,,Unknown 2020-05-29 Wales   Unknown 81
2020-05-29,Wales,W11000023,Betsi Cadwaladr 2020-05-29 Wales W11000023 Betsi Cadwaladr 3070
2020-05-29,Wales,W11000024,Powys 2020-05-29 Wales W11000024 Powys 297
2020-05-29,Wales,W11000025,Hywel Dda 2020-05-29 Wales W11000025 Hywel Dda 1065
2020-05-29,Wales,W11000028,Aneurin Bevan 2020-05-29 Wales W11000028 Aneurin Bevan 2598
2020-05-29,Wales,W11000029,Cardiff and Vale 2020-05-29 Wales W11000029 Cardiff and Vale 2771
2020-05-29,Wales,W11000030,Cwm Taf 2020-05-29 Wales W11000030 Cwm Taf 2602
2020-05-29,Wales,W11000031,Swansea Bay 2020-05-29 Wales W11000031 Swansea Bay 1897
2020-05-30,Wales,,Outside Wales 2020-05-30 Wales   Outside Wales 120
2020-05-30,Wales,,Unknown 2020-05-30 Wales   Unknown 82
2020-05-30,Wales,W11000023,Betsi Cadwaladr 2020-05-30 Wales W11000023 Betsi Cadwaladr 3113
2020-05-30,Wales,W11000024,Powys 2020-05-30 Wales W11000024 Powys 297
2020-05-30,Wales,W11000025,Hywel Dda 2020-05-30 Wales W11000025 Hywel Dda 1066
2020-05-30,Wales,W11000028,Aneurin Bevan 2020-05-30 Wales W11000028 Aneurin Bevan 2601
2020-05-30,Wales,W11000029,Cardiff and Vale 2020-05-30 Wales W11000029 Cardiff and Vale 2782
2020-05-30,Wales,W11000030,Cwm Taf 2020-05-30 Wales W11000030 Cwm Taf 2612
2020-05-30,Wales,W11000031,Swansea Bay 2020-05-30 Wales W11000031 Swansea Bay 1898
2020-05-31,Wales,,Outside Wales 2020-05-31 Wales   Outside Wales 120
2020-05-31,Wales,,Unknown 2020-05-31 Wales   Unknown 82
2020-05-31,Wales,W11000023,Betsi Cadwaladr 2020-05-31 Wales W11000023 Betsi Cadwaladr 3130
2020-05-31,Wales,W11000024,Powys 2020-05-31 Wales W11000024 Powys 297
2020-05-31,Wales,W11000025,Hywel Dda 2020-05-31 Wales W11000025 Hywel Dda 1067
2020-05-31,Wales,W11000028,Aneurin Bevan 2020-05-31 Wales W11000028 Aneurin Bevan 2608
2020-05-31,Wales,W11000029,Cardiff and Vale 2020-05-31 Wales W11000029 Cardiff and Vale 2792
2020-05-31,Wales,W11000030,Cwm Taf 2020-05-31 Wales W11000030 Cwm Taf 2623
2020-05-31,Wales,W11000031,Swansea Bay 2020-05-31 Wales W11000031 Swansea Bay 1898
2020-06-01,Wales,,Outside Wales 2020-06-01 Wales   Outside Wales 120
2020-06-01,Wales,,Unknown 2020-06-01 Wales   Unknown 82
2020-06-01,Wales,W11000023,Betsi Cadwaladr 2020-06-01 Wales W11000023 Betsi Cadwaladr 3165
2020-06-01,Wales,W11000024,Powys 2020-06-01 Wales W11000024 Powys 300
2020-06-01,Wales,W11000025,Hywel Dda 2020-06-01 Wales W11000025 Hywel Dda 1068
2020-06-01,Wales,W11000028,Aneurin Bevan 2020-06-01 Wales W11000028 Aneurin Bevan 2610
2020-06-01,Wales,W11000029,Cardiff and Vale 2020-06-01 Wales W11000029 Cardiff and Vale 2803
2020-06-01,Wales,W11000030,Cwm Taf 2020-06-01 Wales W11000030 Cwm Taf 2632
2020-06-01,Wales,W11000031,Swansea Bay 2020-06-01 Wales W11000031 Swansea Bay 1901
2020-06-02,Wales,,Outside Wales 2020-06-02 Wales   Outside Wales 121

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