cases

22,757 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link Date Country AreaCode Area TotalCases
2020-02-13,Wales,W11000024,Powys 2020-02-13 Wales W11000024 Powys 0
2020-02-13,Wales,W11000025,Hywel Dda 2020-02-13 Wales W11000025 Hywel Dda 0
2020-02-13,Wales,W11000028,Aneurin Bevan 2020-02-13 Wales W11000028 Aneurin Bevan 0
2020-02-13,Wales,W11000029,Cardiff and Vale 2020-02-13 Wales W11000029 Cardiff and Vale 0
2020-02-13,Wales,W11000030,Cwm Taf 2020-02-13 Wales W11000030 Cwm Taf 0
2020-02-13,Wales,W11000031,Swansea Bay 2020-02-13 Wales W11000031 Swansea Bay 0
2020-02-14,Wales,,Outside Wales 2020-02-14 Wales   Outside Wales 0
2020-02-14,Wales,,Unknown 2020-02-14 Wales   Unknown 0
2020-02-14,Wales,W11000023,Betsi Cadwaladr 2020-02-14 Wales W11000023 Betsi Cadwaladr 0
2020-02-14,Wales,W11000024,Powys 2020-02-14 Wales W11000024 Powys 0
2020-02-14,Wales,W11000025,Hywel Dda 2020-02-14 Wales W11000025 Hywel Dda 0
2020-02-14,Wales,W11000028,Aneurin Bevan 2020-02-14 Wales W11000028 Aneurin Bevan 0
2020-02-14,Wales,W11000029,Cardiff and Vale 2020-02-14 Wales W11000029 Cardiff and Vale 0
2020-02-14,Wales,W11000030,Cwm Taf 2020-02-14 Wales W11000030 Cwm Taf 0
2020-02-14,Wales,W11000031,Swansea Bay 2020-02-14 Wales W11000031 Swansea Bay 0
2020-02-15,Wales,,Outside Wales 2020-02-15 Wales   Outside Wales 0
2020-02-15,Wales,,Unknown 2020-02-15 Wales   Unknown 0
2020-02-15,Wales,W11000023,Betsi Cadwaladr 2020-02-15 Wales W11000023 Betsi Cadwaladr 0
2020-02-15,Wales,W11000024,Powys 2020-02-15 Wales W11000024 Powys 0
2020-02-15,Wales,W11000025,Hywel Dda 2020-02-15 Wales W11000025 Hywel Dda 0
2020-02-15,Wales,W11000028,Aneurin Bevan 2020-02-15 Wales W11000028 Aneurin Bevan 0
2020-02-15,Wales,W11000029,Cardiff and Vale 2020-02-15 Wales W11000029 Cardiff and Vale 0
2020-02-15,Wales,W11000030,Cwm Taf 2020-02-15 Wales W11000030 Cwm Taf 0
2020-02-15,Wales,W11000031,Swansea Bay 2020-02-15 Wales W11000031 Swansea Bay 0
2020-02-16,Wales,,Outside Wales 2020-02-16 Wales   Outside Wales 0
2020-02-16,Wales,,Unknown 2020-02-16 Wales   Unknown 0
2020-02-16,Wales,W11000023,Betsi Cadwaladr 2020-02-16 Wales W11000023 Betsi Cadwaladr 0
2020-02-16,Wales,W11000024,Powys 2020-02-16 Wales W11000024 Powys 0
2020-02-16,Wales,W11000025,Hywel Dda 2020-02-16 Wales W11000025 Hywel Dda 0
2020-02-16,Wales,W11000028,Aneurin Bevan 2020-02-16 Wales W11000028 Aneurin Bevan 0
2020-02-16,Wales,W11000029,Cardiff and Vale 2020-02-16 Wales W11000029 Cardiff and Vale 0
2020-02-16,Wales,W11000030,Cwm Taf 2020-02-16 Wales W11000030 Cwm Taf 0
2020-02-16,Wales,W11000031,Swansea Bay 2020-02-16 Wales W11000031 Swansea Bay 0
2020-02-17,Wales,,Outside Wales 2020-02-17 Wales   Outside Wales 0
2020-02-17,Wales,,Unknown 2020-02-17 Wales   Unknown 0
2020-02-17,Wales,W11000023,Betsi Cadwaladr 2020-02-17 Wales W11000023 Betsi Cadwaladr 0
2020-02-17,Wales,W11000024,Powys 2020-02-17 Wales W11000024 Powys 0
2020-02-17,Wales,W11000025,Hywel Dda 2020-02-17 Wales W11000025 Hywel Dda 0
2020-02-17,Wales,W11000028,Aneurin Bevan 2020-02-17 Wales W11000028 Aneurin Bevan 0
2020-02-17,Wales,W11000029,Cardiff and Vale 2020-02-17 Wales W11000029 Cardiff and Vale 0
2020-02-17,Wales,W11000030,Cwm Taf 2020-02-17 Wales W11000030 Cwm Taf 0
2020-02-17,Wales,W11000031,Swansea Bay 2020-02-17 Wales W11000031 Swansea Bay 0
2020-02-18,Wales,,Outside Wales 2020-02-18 Wales   Outside Wales 0
2020-02-18,Wales,,Unknown 2020-02-18 Wales   Unknown 0
2020-02-18,Wales,W11000023,Betsi Cadwaladr 2020-02-18 Wales W11000023 Betsi Cadwaladr 0
2020-02-18,Wales,W11000024,Powys 2020-02-18 Wales W11000024 Powys 0
2020-02-18,Wales,W11000025,Hywel Dda 2020-02-18 Wales W11000025 Hywel Dda 0
2020-02-18,Wales,W11000028,Aneurin Bevan 2020-02-18 Wales W11000028 Aneurin Bevan 0
2020-02-18,Wales,W11000029,Cardiff and Vale 2020-02-18 Wales W11000029 Cardiff and Vale 0
2020-02-18,Wales,W11000030,Cwm Taf 2020-02-18 Wales W11000030 Cwm Taf 0
2020-02-18,Wales,W11000031,Swansea Bay 2020-02-18 Wales W11000031 Swansea Bay 0
2020-02-19,Wales,,Outside Wales 2020-02-19 Wales   Outside Wales 0
2020-02-19,Wales,,Unknown 2020-02-19 Wales   Unknown 0
2020-02-19,Wales,W11000023,Betsi Cadwaladr 2020-02-19 Wales W11000023 Betsi Cadwaladr 0
2020-02-19,Wales,W11000024,Powys 2020-02-19 Wales W11000024 Powys 0
2020-02-19,Wales,W11000025,Hywel Dda 2020-02-19 Wales W11000025 Hywel Dda 0
2020-02-19,Wales,W11000028,Aneurin Bevan 2020-02-19 Wales W11000028 Aneurin Bevan 0
2020-02-19,Wales,W11000029,Cardiff and Vale 2020-02-19 Wales W11000029 Cardiff and Vale 0
2020-02-19,Wales,W11000030,Cwm Taf 2020-02-19 Wales W11000030 Cwm Taf 0
2020-02-19,Wales,W11000031,Swansea Bay 2020-02-19 Wales W11000031 Swansea Bay 0
2020-02-20,Wales,,Outside Wales 2020-02-20 Wales   Outside Wales 0
2020-02-20,Wales,,Unknown 2020-02-20 Wales   Unknown 0
2020-02-20,Wales,W11000023,Betsi Cadwaladr 2020-02-20 Wales W11000023 Betsi Cadwaladr 0
2020-02-20,Wales,W11000024,Powys 2020-02-20 Wales W11000024 Powys 0
2020-02-20,Wales,W11000025,Hywel Dda 2020-02-20 Wales W11000025 Hywel Dda 0
2020-02-20,Wales,W11000028,Aneurin Bevan 2020-02-20 Wales W11000028 Aneurin Bevan 0
2020-02-20,Wales,W11000029,Cardiff and Vale 2020-02-20 Wales W11000029 Cardiff and Vale 0
2020-02-20,Wales,W11000030,Cwm Taf 2020-02-20 Wales W11000030 Cwm Taf 0
2020-02-20,Wales,W11000031,Swansea Bay 2020-02-20 Wales W11000031 Swansea Bay 0
2020-02-21,England,E10000024,Nottinghamshire 2020-02-21 England E10000024 Nottinghamshire 1
2020-02-21,Wales,,Outside Wales 2020-02-21 Wales   Outside Wales 0
2020-02-21,Wales,,Unknown 2020-02-21 Wales   Unknown 0
2020-02-21,Wales,W11000023,Betsi Cadwaladr 2020-02-21 Wales W11000023 Betsi Cadwaladr 0
2020-02-21,Wales,W11000024,Powys 2020-02-21 Wales W11000024 Powys 0
2020-02-21,Wales,W11000025,Hywel Dda 2020-02-21 Wales W11000025 Hywel Dda 0
2020-02-21,Wales,W11000028,Aneurin Bevan 2020-02-21 Wales W11000028 Aneurin Bevan 0
2020-02-21,Wales,W11000029,Cardiff and Vale 2020-02-21 Wales W11000029 Cardiff and Vale 0
2020-02-21,Wales,W11000030,Cwm Taf 2020-02-21 Wales W11000030 Cwm Taf 0
2020-02-21,Wales,W11000031,Swansea Bay 2020-02-21 Wales W11000031 Swansea Bay 0
2020-02-22,Wales,,Outside Wales 2020-02-22 Wales   Outside Wales 0
2020-02-22,Wales,,Unknown 2020-02-22 Wales   Unknown 0
2020-02-22,Wales,W11000023,Betsi Cadwaladr 2020-02-22 Wales W11000023 Betsi Cadwaladr 0
2020-02-22,Wales,W11000024,Powys 2020-02-22 Wales W11000024 Powys 0
2020-02-22,Wales,W11000025,Hywel Dda 2020-02-22 Wales W11000025 Hywel Dda 0
2020-02-22,Wales,W11000028,Aneurin Bevan 2020-02-22 Wales W11000028 Aneurin Bevan 0
2020-02-22,Wales,W11000029,Cardiff and Vale 2020-02-22 Wales W11000029 Cardiff and Vale 0
2020-02-22,Wales,W11000030,Cwm Taf 2020-02-22 Wales W11000030 Cwm Taf 0
2020-02-22,Wales,W11000031,Swansea Bay 2020-02-22 Wales W11000031 Swansea Bay 0
2020-02-23,Wales,,Outside Wales 2020-02-23 Wales   Outside Wales 0
2020-02-23,Wales,,Unknown 2020-02-23 Wales   Unknown 0
2020-02-23,Wales,W11000023,Betsi Cadwaladr 2020-02-23 Wales W11000023 Betsi Cadwaladr 0
2020-02-23,Wales,W11000024,Powys 2020-02-23 Wales W11000024 Powys 0
2020-02-23,Wales,W11000025,Hywel Dda 2020-02-23 Wales W11000025 Hywel Dda 0
2020-02-23,Wales,W11000028,Aneurin Bevan 2020-02-23 Wales W11000028 Aneurin Bevan 0
2020-02-23,Wales,W11000029,Cardiff and Vale 2020-02-23 Wales W11000029 Cardiff and Vale 0
2020-02-23,Wales,W11000030,Cwm Taf 2020-02-23 Wales W11000030 Cwm Taf 0
2020-02-23,Wales,W11000031,Swansea Bay 2020-02-23 Wales W11000031 Swansea Bay 0
2020-02-24,England,E09000022,Lambeth 2020-02-24 England E09000022 Lambeth 1
2020-02-24,England,E10000032,West Sussex 2020-02-24 England E10000032 West Sussex 1
2020-02-24,Wales,,Outside Wales 2020-02-24 Wales   Outside Wales 0

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