cases

173 rows where Area = "Outside Wales"

- remove filter - Date Country AreaCode Area TotalCases

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - Date Country AreaCode Area TotalCases

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by Date Sort by Country Sort by AreaCode Sort by Area Sort by TotalCases

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date (date)

Link	Date	Country	AreaCode	Area	TotalCases
2020-02-03,Wales,,Outside Wales	2020-02-03	Wales		Outside Wales	0
2020-02-04,Wales,,Outside Wales	2020-02-04	Wales		Outside Wales	0
2020-02-05,Wales,,Outside Wales	2020-02-05	Wales		Outside Wales	0
2020-02-06,Wales,,Outside Wales	2020-02-06	Wales		Outside Wales	0
2020-02-07,Wales,,Outside Wales	2020-02-07	Wales		Outside Wales	0
2020-02-08,Wales,,Outside Wales	2020-02-08	Wales		Outside Wales	0
2020-02-09,Wales,,Outside Wales	2020-02-09	Wales		Outside Wales	0
2020-02-10,Wales,,Outside Wales	2020-02-10	Wales		Outside Wales	0
2020-02-11,Wales,,Outside Wales	2020-02-11	Wales		Outside Wales	0
2020-02-12,Wales,,Outside Wales	2020-02-12	Wales		Outside Wales	0
2020-02-13,Wales,,Outside Wales	2020-02-13	Wales		Outside Wales	0
2020-02-14,Wales,,Outside Wales	2020-02-14	Wales		Outside Wales	0
2020-02-15,Wales,,Outside Wales	2020-02-15	Wales		Outside Wales	0
2020-02-16,Wales,,Outside Wales	2020-02-16	Wales		Outside Wales	0
2020-02-17,Wales,,Outside Wales	2020-02-17	Wales		Outside Wales	0
2020-02-18,Wales,,Outside Wales	2020-02-18	Wales		Outside Wales	0
2020-02-19,Wales,,Outside Wales	2020-02-19	Wales		Outside Wales	0
2020-02-20,Wales,,Outside Wales	2020-02-20	Wales		Outside Wales	0
2020-02-21,Wales,,Outside Wales	2020-02-21	Wales		Outside Wales	0
2020-02-22,Wales,,Outside Wales	2020-02-22	Wales		Outside Wales	0
2020-02-23,Wales,,Outside Wales	2020-02-23	Wales		Outside Wales	0
2020-02-24,Wales,,Outside Wales	2020-02-24	Wales		Outside Wales	0
2020-02-25,Wales,,Outside Wales	2020-02-25	Wales		Outside Wales	0
2020-02-26,Wales,,Outside Wales	2020-02-26	Wales		Outside Wales	0
2020-02-27,Wales,,Outside Wales	2020-02-27	Wales		Outside Wales	0
2020-02-28,Wales,,Outside Wales	2020-02-28	Wales		Outside Wales	0
2020-02-29,Wales,,Outside Wales	2020-02-29	Wales		Outside Wales	0
2020-03-01,Wales,,Outside Wales	2020-03-01	Wales		Outside Wales	0
2020-03-02,Wales,,Outside Wales	2020-03-02	Wales		Outside Wales	0
2020-03-03,Wales,,Outside Wales	2020-03-03	Wales		Outside Wales	0
2020-03-04,Wales,,Outside Wales	2020-03-04	Wales		Outside Wales	0
2020-03-05,Wales,,Outside Wales	2020-03-05	Wales		Outside Wales	0
2020-03-06,Wales,,Outside Wales	2020-03-06	Wales		Outside Wales	0
2020-03-07,Wales,,Outside Wales	2020-03-07	Wales		Outside Wales	0
2020-03-08,Wales,,Outside Wales	2020-03-08	Wales		Outside Wales	0
2020-03-09,Wales,,Outside Wales	2020-03-09	Wales		Outside Wales	0
2020-03-10,Wales,,Outside Wales	2020-03-10	Wales		Outside Wales	0
2020-03-11,Wales,,Outside Wales	2020-03-11	Wales		Outside Wales	0
2020-03-12,Wales,,Outside Wales	2020-03-12	Wales		Outside Wales	0
2020-03-13,Wales,,Outside Wales	2020-03-13	Wales		Outside Wales	0
2020-03-14,Wales,,Outside Wales	2020-03-14	Wales		Outside Wales	1
2020-03-15,Wales,,Outside Wales	2020-03-15	Wales		Outside Wales	2
2020-03-16,Wales,,Outside Wales	2020-03-16	Wales		Outside Wales	2
2020-03-17,Wales,,Outside Wales	2020-03-17	Wales		Outside Wales	2
2020-03-18,Wales,,Outside Wales	2020-03-18	Wales		Outside Wales	2
2020-03-19,Wales,,Outside Wales	2020-03-19	Wales		Outside Wales	2
2020-03-20,Wales,,Outside Wales	2020-03-20	Wales		Outside Wales	3
2020-03-21,Wales,,Outside Wales	2020-03-21	Wales		Outside Wales	3
2020-03-22,Wales,,Outside Wales	2020-03-22	Wales		Outside Wales	3
2020-03-23,Wales,,Outside Wales	2020-03-23	Wales		Outside Wales	5
2020-03-24,Wales,,Outside Wales	2020-03-24	Wales		Outside Wales	6
2020-03-25,Wales,,Outside Wales	2020-03-25	Wales		Outside Wales	8
2020-03-26,Wales,,Outside Wales	2020-03-26	Wales		Outside Wales	10
2020-03-27,Wales,,Outside Wales	2020-03-27	Wales		Outside Wales	13
2020-03-28,Wales,,Outside Wales	2020-03-28	Wales		Outside Wales	14
2020-03-29,Wales,,Outside Wales	2020-03-29	Wales		Outside Wales	16
2020-03-30,Wales,,Outside Wales	2020-03-30	Wales		Outside Wales	21
2020-03-31,Wales,,Outside Wales	2020-03-31	Wales		Outside Wales	25
2020-04-01,Wales,,Outside Wales	2020-04-01	Wales		Outside Wales	29
2020-04-02,Wales,,Outside Wales	2020-04-02	Wales		Outside Wales	31
2020-04-03,Wales,,Outside Wales	2020-04-03	Wales		Outside Wales	32
2020-04-04,Wales,,Outside Wales	2020-04-04	Wales		Outside Wales	32
2020-04-05,Wales,,Outside Wales	2020-04-05	Wales		Outside Wales	33
2020-04-06,Wales,,Outside Wales	2020-04-06	Wales		Outside Wales	36
2020-04-07,Wales,,Outside Wales	2020-04-07	Wales		Outside Wales	44
2020-04-08,Wales,,Outside Wales	2020-04-08	Wales		Outside Wales	46
2020-04-09,Wales,,Outside Wales	2020-04-09	Wales		Outside Wales	46
2020-04-10,Wales,,Outside Wales	2020-04-10	Wales		Outside Wales	49
2020-04-11,Wales,,Outside Wales	2020-04-11	Wales		Outside Wales	52
2020-04-12,Wales,,Outside Wales	2020-04-12	Wales		Outside Wales	53
2020-04-13,Wales,,Outside Wales	2020-04-13	Wales		Outside Wales	56
2020-04-14,Wales,,Outside Wales	2020-04-14	Wales		Outside Wales	58
2020-04-15,Wales,,Outside Wales	2020-04-15	Wales		Outside Wales	62
2020-04-16,Wales,,Outside Wales	2020-04-16	Wales		Outside Wales	66
2020-04-17,Wales,,Outside Wales	2020-04-17	Wales		Outside Wales	67
2020-04-18,Wales,,Outside Wales	2020-04-18	Wales		Outside Wales	69
2020-04-19,Wales,,Outside Wales	2020-04-19	Wales		Outside Wales	70
2020-04-20,Wales,,Outside Wales	2020-04-20	Wales		Outside Wales	75
2020-04-21,Wales,,Outside Wales	2020-04-21	Wales		Outside Wales	80
2020-04-22,Wales,,Outside Wales	2020-04-22	Wales		Outside Wales	81
2020-04-23,Wales,,Outside Wales	2020-04-23	Wales		Outside Wales	83
2020-04-24,Wales,,Outside Wales	2020-04-24	Wales		Outside Wales	86
2020-04-25,Wales,,Outside Wales	2020-04-25	Wales		Outside Wales	87
2020-04-26,Wales,,Outside Wales	2020-04-26	Wales		Outside Wales	87
2020-04-27,Wales,,Outside Wales	2020-04-27	Wales		Outside Wales	88
2020-04-28,Wales,,Outside Wales	2020-04-28	Wales		Outside Wales	89
2020-04-29,Wales,,Outside Wales	2020-04-29	Wales		Outside Wales	93
2020-04-30,Wales,,Outside Wales	2020-04-30	Wales		Outside Wales	94
2020-05-01,Wales,,Outside Wales	2020-05-01	Wales		Outside Wales	97
2020-05-02,Wales,,Outside Wales	2020-05-02	Wales		Outside Wales	99
2020-05-03,Wales,,Outside Wales	2020-05-03	Wales		Outside Wales	99
2020-05-04,Wales,,Outside Wales	2020-05-04	Wales		Outside Wales	100
2020-05-05,Wales,,Outside Wales	2020-05-05	Wales		Outside Wales	103
2020-05-06,Wales,,Outside Wales	2020-05-06	Wales		Outside Wales	103
2020-05-07,Wales,,Outside Wales	2020-05-07	Wales		Outside Wales	105
2020-05-08,Wales,,Outside Wales	2020-05-08	Wales		Outside Wales	107
2020-05-09,Wales,,Outside Wales	2020-05-09	Wales		Outside Wales	107
2020-05-10,Wales,,Outside Wales	2020-05-10	Wales		Outside Wales	109
2020-05-11,Wales,,Outside Wales	2020-05-11	Wales		Outside Wales	111
2020-05-12,Wales,,Outside Wales	2020-05-12	Wales		Outside Wales	111

Next page

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);