cases

188 rows where Area = "Unknown"

- 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: Country, Date (date)

Link	Date	Country	AreaCode	Area	TotalCases
2020-02-03,Wales,,Unknown	2020-02-03	Wales		Unknown	0
2020-02-04,Wales,,Unknown	2020-02-04	Wales		Unknown	0
2020-02-05,Wales,,Unknown	2020-02-05	Wales		Unknown	0
2020-02-06,Wales,,Unknown	2020-02-06	Wales		Unknown	0
2020-02-07,Wales,,Unknown	2020-02-07	Wales		Unknown	0
2020-02-08,Wales,,Unknown	2020-02-08	Wales		Unknown	0
2020-02-09,Wales,,Unknown	2020-02-09	Wales		Unknown	0
2020-02-10,Wales,,Unknown	2020-02-10	Wales		Unknown	0
2020-02-11,Wales,,Unknown	2020-02-11	Wales		Unknown	0
2020-02-12,Wales,,Unknown	2020-02-12	Wales		Unknown	0
2020-02-13,Wales,,Unknown	2020-02-13	Wales		Unknown	0
2020-02-14,Wales,,Unknown	2020-02-14	Wales		Unknown	0
2020-02-15,Wales,,Unknown	2020-02-15	Wales		Unknown	0
2020-02-16,Wales,,Unknown	2020-02-16	Wales		Unknown	0
2020-02-17,Wales,,Unknown	2020-02-17	Wales		Unknown	0
2020-02-18,Wales,,Unknown	2020-02-18	Wales		Unknown	0
2020-02-19,Wales,,Unknown	2020-02-19	Wales		Unknown	0
2020-02-20,Wales,,Unknown	2020-02-20	Wales		Unknown	0
2020-02-21,Wales,,Unknown	2020-02-21	Wales		Unknown	0
2020-02-22,Wales,,Unknown	2020-02-22	Wales		Unknown	0
2020-02-23,Wales,,Unknown	2020-02-23	Wales		Unknown	0
2020-02-24,Wales,,Unknown	2020-02-24	Wales		Unknown	0
2020-02-25,Wales,,Unknown	2020-02-25	Wales		Unknown	0
2020-02-26,Wales,,Unknown	2020-02-26	Wales		Unknown	0
2020-02-27,Wales,,Unknown	2020-02-27	Wales		Unknown	0
2020-02-28,Wales,,Unknown	2020-02-28	Wales		Unknown	0
2020-02-29,Wales,,Unknown	2020-02-29	Wales		Unknown	0
2020-03-01,Wales,,Unknown	2020-03-01	Wales		Unknown	0
2020-03-02,Wales,,Unknown	2020-03-02	Wales		Unknown	0
2020-03-03,Wales,,Unknown	2020-03-03	Wales		Unknown	0
2020-03-04,Wales,,Unknown	2020-03-04	Wales		Unknown	0
2020-03-05,Wales,,Unknown	2020-03-05	Wales		Unknown	0
2020-03-06,Wales,,Unknown	2020-03-06	Wales		Unknown	0
2020-03-07,Wales,,Unknown	2020-03-07	Wales		Unknown	1
2020-03-08,Wales,,Unknown	2020-03-08	Wales		Unknown	1
2020-03-09,Wales,,Unknown	2020-03-09	Wales		Unknown	1
2020-03-10,Wales,,Unknown	2020-03-10	Wales		Unknown	1
2020-03-11,Wales,,Unknown	2020-03-11	Wales		Unknown	1
2020-03-12,Wales,,Unknown	2020-03-12	Wales		Unknown	1
2020-03-13,Wales,,Unknown	2020-03-13	Wales		Unknown	1
2020-03-14,Wales,,Unknown	2020-03-14	Wales		Unknown	3
2020-03-15,Wales,,Unknown	2020-03-15	Wales		Unknown	3
2020-03-16,Wales,,Unknown	2020-03-16	Wales		Unknown	3
2020-03-17,Wales,,Unknown	2020-03-17	Wales		Unknown	3
2020-03-18,Wales,,Unknown	2020-03-18	Wales		Unknown	4
2020-03-19,Wales,,Unknown	2020-03-19	Wales		Unknown	4
2020-03-20,Wales,,Unknown	2020-03-20	Wales		Unknown	4
2020-03-21,Wales,,Unknown	2020-03-21	Wales		Unknown	4
2020-03-22,Wales,,Unknown	2020-03-22	Wales		Unknown	4
2020-03-23,Wales,,Unknown	2020-03-23	Wales		Unknown	5
2020-03-24,Wales,,Unknown	2020-03-24	Wales		Unknown	10
2020-03-25,Wales,,Unknown	2020-03-25	Wales		Unknown	15
2020-03-26,Northern Ireland,None,Unknown	2020-03-26	Northern Ireland		Unknown	7
2020-03-26,Northern Ireland,None,Unknown	2020-03-26	Northern Ireland		Unknown	7
2020-03-26,Wales,,Unknown	2020-03-26	Wales		Unknown	17
2020-03-27,Northern Ireland,None,Unknown	2020-03-27	Northern Ireland		Unknown	7
2020-03-27,Wales,,Unknown	2020-03-27	Wales		Unknown	22
2020-03-28,Wales,,Unknown	2020-03-28	Wales		Unknown	22
2020-03-29,Wales,,Unknown	2020-03-29	Wales		Unknown	23
2020-03-30,Northern Ireland,None,Unknown	2020-03-30	Northern Ireland		Unknown	22
2020-03-30,Wales,,Unknown	2020-03-30	Wales		Unknown	27
2020-03-31,Northern Ireland,None,Unknown	2020-03-31	Northern Ireland		Unknown	29
2020-03-31,Wales,,Unknown	2020-03-31	Wales		Unknown	29
2020-04-01,Northern Ireland,None,Unknown	2020-04-01	Northern Ireland		Unknown	39
2020-04-01,Wales,,Unknown	2020-04-01	Wales		Unknown	32
2020-04-02,Northern Ireland,None,Unknown	2020-04-02	Northern Ireland		Unknown	47
2020-04-02,Wales,,Unknown	2020-04-02	Wales		Unknown	33
2020-04-03,Northern Ireland,None,Unknown	2020-04-03	Northern Ireland		Unknown	66
2020-04-03,Wales,,Unknown	2020-04-03	Wales		Unknown	38
2020-04-04,Wales,,Unknown	2020-04-04	Wales		Unknown	39
2020-04-05,Wales,,Unknown	2020-04-05	Wales		Unknown	40
2020-04-06,Northern Ireland,None,Unknown	2020-04-06	Northern Ireland		Unknown	83
2020-04-06,Wales,,Unknown	2020-04-06	Wales		Unknown	41
2020-04-07,Northern Ireland,None,Unknown	2020-04-07	Northern Ireland		Unknown	95
2020-04-07,Wales,,Unknown	2020-04-07	Wales		Unknown	43
2020-04-08,Northern Ireland,None,Unknown	2020-04-08	Northern Ireland		Unknown	105
2020-04-08,Wales,,Unknown	2020-04-08	Wales		Unknown	44
2020-04-09,Northern Ireland,None,Unknown	2020-04-09	Northern Ireland		Unknown	117
2020-04-09,Wales,,Unknown	2020-04-09	Wales		Unknown	44
2020-04-10,Northern Ireland,None,Unknown	2020-04-10	Northern Ireland		Unknown	22
2020-04-10,Wales,,Unknown	2020-04-10	Wales		Unknown	45
2020-04-11,Wales,,Unknown	2020-04-11	Wales		Unknown	45
2020-04-12,Wales,,Unknown	2020-04-12	Wales		Unknown	47
2020-04-13,Wales,,Unknown	2020-04-13	Wales		Unknown	49
2020-04-14,Wales,,Unknown	2020-04-14	Wales		Unknown	52
2020-04-15,Northern Ireland,None,Unknown	2020-04-15	Northern Ireland		Unknown	34
2020-04-15,Wales,,Unknown	2020-04-15	Wales		Unknown	53
2020-04-16,Northern Ireland,None,Unknown	2020-04-16	Northern Ireland		Unknown	26
2020-04-16,Wales,,Unknown	2020-04-16	Wales		Unknown	53
2020-04-17,Wales,,Unknown	2020-04-17	Wales		Unknown	54
2020-04-18,Wales,,Unknown	2020-04-18	Wales		Unknown	55
2020-04-19,Wales,,Unknown	2020-04-19	Wales		Unknown	57
2020-04-20,Wales,,Unknown	2020-04-20	Wales		Unknown	58
2020-04-21,Wales,,Unknown	2020-04-21	Wales		Unknown	59
2020-04-22,Wales,,Unknown	2020-04-22	Wales		Unknown	60
2020-04-23,Wales,,Unknown	2020-04-23	Wales		Unknown	60
2020-04-24,Wales,,Unknown	2020-04-24	Wales		Unknown	63
2020-04-25,Wales,,Unknown	2020-04-25	Wales		Unknown	63
2020-04-26,Wales,,Unknown	2020-04-26	Wales		Unknown	64
2020-04-27,Wales,,Unknown	2020-04-27	Wales		Unknown	65

Next page

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