cases

141 rows where Area = "Tayside" and Country = "Scotland"

- 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

- 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-03-07,Scotland,S08000030,Tayside	2020-03-07	Scotland	S08000030	Tayside	NaN
2020-03-08,Scotland,S08000030,Tayside	2020-03-08	Scotland	S08000030	Tayside	NaN
2020-03-09,Scotland,S08000030,Tayside	2020-03-09	Scotland	S08000030	Tayside	NaN
2020-03-10,Scotland,S08000030,Tayside	2020-03-10	Scotland	S08000030	Tayside	NaN
2020-03-11,Scotland,S08000030,Tayside	2020-03-11	Scotland	S08000030	Tayside	NaN
2020-03-12,Scotland,S08000030,Tayside	2020-03-12	Scotland	S08000030	Tayside	NaN
2020-03-13,Scotland,S08000030,Tayside	2020-03-13	Scotland	S08000030	Tayside	NaN
2020-03-14,Scotland,S08000030,Tayside	2020-03-14	Scotland	S08000030	Tayside	11
2020-03-15,Scotland,S08000030,Tayside	2020-03-15	Scotland	S08000030	Tayside	15
2020-03-16,Scotland,S08000030,Tayside	2020-03-16	Scotland	S08000030	Tayside	17
2020-03-17,Scotland,S08000030,Tayside	2020-03-17	Scotland	S08000030	Tayside	20
2020-03-18,Scotland,S08000030,Tayside	2020-03-18	Scotland	S08000030	Tayside	24
2020-03-19,Scotland,S08000030,Tayside	2020-03-19	Scotland	S08000030	Tayside	27
2020-03-20,Scotland,S08000030,Tayside	2020-03-20	Scotland	S08000030	Tayside	31
2020-03-21,Scotland,S08000030,Tayside	2020-03-21	Scotland	S08000030	Tayside	34
2020-03-22,Scotland,S08000030,Tayside	2020-03-22	Scotland	S08000030	Tayside	38
2020-03-23,Scotland,S08000030,Tayside	2020-03-23	Scotland	S08000030	Tayside	47
2020-03-24,Scotland,S08000030,Tayside	2020-03-24	Scotland	S08000030	Tayside	48
2020-03-25,Scotland,S08000030,Tayside	2020-03-25	Scotland	S08000030	Tayside	57
2020-03-26,Scotland,S08000030,Tayside	2020-03-26	Scotland	S08000030	Tayside	76
2020-03-27,Scotland,S08000030,Tayside	2020-03-27	Scotland	S08000030	Tayside	107
2020-03-28,Scotland,S08000030,Tayside	2020-03-28	Scotland	S08000030	Tayside	127
2020-03-29,Scotland,S08000030,Tayside	2020-03-29	Scotland	S08000030	Tayside	141
2020-03-30,Scotland,S08000030,Tayside	2020-03-30	Scotland	S08000030	Tayside	177
2020-03-31,Scotland,S08000030,Tayside	2020-03-31	Scotland	S08000030	Tayside	214
2020-04-01,Scotland,S08000030,Tayside	2020-04-01	Scotland	S08000030	Tayside	254
2020-04-02,Scotland,S08000030,Tayside	2020-04-02	Scotland	S08000030	Tayside	307
2020-04-03,Scotland,S08000030,Tayside	2020-04-03	Scotland	S08000030	Tayside	353
2020-04-04,Scotland,S08000030,Tayside	2020-04-04	Scotland	S08000030	Tayside	410
2020-04-05,Scotland,S08000030,Tayside	2020-04-05	Scotland	S08000030	Tayside	457
2020-04-06,Scotland,S08000030,Tayside	2020-04-06	Scotland	S08000030	Tayside	499
2020-04-07,Scotland,S08000030,Tayside	2020-04-07	Scotland	S08000030	Tayside	516
2020-04-08,Scotland,S08000030,Tayside	2020-04-08	Scotland	S08000030	Tayside	586
2020-04-09,Scotland,S08000030,Tayside	2020-04-09	Scotland	S08000030	Tayside	667
2020-04-10,Scotland,S08000030,Tayside	2020-04-10	Scotland	S08000030	Tayside	712
2020-04-11,Scotland,S08000030,Tayside	2020-04-11	Scotland	S08000030	Tayside	753
2020-04-12,Scotland,S08000030,Tayside	2020-04-12	Scotland	S08000030	Tayside	803
2020-04-13,Scotland,S08000030,Tayside	2020-04-13	Scotland	S08000030	Tayside	812
2020-04-14,Scotland,S08000030,Tayside	2020-04-14	Scotland	S08000030	Tayside	826
2020-04-15,Scotland,S08000030,Tayside	2020-04-15	Scotland	S08000030	Tayside	898
2020-04-16,Scotland,S08000030,Tayside	2020-04-16	Scotland	S08000030	Tayside	937
2020-04-17,Scotland,S08000030,Tayside	2020-04-17	Scotland	S08000030	Tayside	979
2020-04-18,Scotland,S08000030,Tayside	2020-04-18	Scotland	S08000030	Tayside	1022
2020-04-19,Scotland,S08000030,Tayside	2020-04-19	Scotland	S08000030	Tayside	1056
2020-04-20,Scotland,S08000030,Tayside	2020-04-20	Scotland	S08000030	Tayside	1071
2020-04-21,Scotland,S08000030,Tayside	2020-04-21	Scotland	S08000030	Tayside	1084
2020-04-22,Scotland,S08000030,Tayside	2020-04-22	Scotland	S08000030	Tayside	1124
2020-04-23,Scotland,S08000030,Tayside	2020-04-23	Scotland	S08000030	Tayside	1159
2020-04-24,Scotland,S08000030,Tayside	2020-04-24	Scotland	S08000030	Tayside	1199
2020-04-25,Scotland,S08000030,Tayside	2020-04-25	Scotland	S08000030	Tayside	1224
2020-04-26,Scotland,S08000030,Tayside	2020-04-26	Scotland	S08000030	Tayside	1251
2020-04-27,Scotland,S08000030,Tayside	2020-04-27	Scotland	S08000030	Tayside	1261
2020-04-28,Scotland,S08000030,Tayside	2020-04-28	Scotland	S08000030	Tayside	1273
2020-04-29,Scotland,S08000030,Tayside	2020-04-29	Scotland	S08000030	Tayside	1313
2020-04-30,Scotland,S08000030,Tayside	2020-04-30	Scotland	S08000030	Tayside	1349
2020-05-01,Scotland,S08000030,Tayside	2020-05-01	Scotland	S08000030	Tayside	1379
2020-05-02,Scotland,S08000030,Tayside	2020-05-02	Scotland	S08000030	Tayside	1392
2020-05-03,Scotland,S08000030,Tayside	2020-05-03	Scotland	S08000030	Tayside	1410
2020-05-04,Scotland,S08000030,Tayside	2020-05-04	Scotland	S08000030	Tayside	1411
2020-05-05,Scotland,S08000030,Tayside	2020-05-05	Scotland	S08000030	Tayside	1429
2020-05-06,Scotland,S08000030,Tayside	2020-05-06	Scotland	S08000030	Tayside	1445
2020-05-07,Scotland,S08000030,Tayside	2020-05-07	Scotland	S08000030	Tayside	1465
2020-05-08,Scotland,S08000030,Tayside	2020-05-08	Scotland	S08000030	Tayside	1471
2020-05-09,Scotland,S08000030,Tayside	2020-05-09	Scotland	S08000030	Tayside	1486
2020-05-10,Scotland,S08000030,Tayside	2020-05-10	Scotland	S08000030	Tayside	1497
2020-05-11,Scotland,S08000030,Tayside	2020-05-11	Scotland	S08000030	Tayside	1497
2020-05-12,Scotland,S08000030,Tayside	2020-05-12	Scotland	S08000030	Tayside	1505
2020-05-13,Scotland,S08000030,Tayside	2020-05-13	Scotland	S08000030	Tayside	1515
2020-05-14,Scotland,S08000030,Tayside	2020-05-14	Scotland	S08000030	Tayside	1540
2020-05-15,Scotland,S08000030,Tayside	2020-05-15	Scotland	S08000030	Tayside	1555
2020-05-16,Scotland,S08000030,Tayside	2020-05-16	Scotland	S08000030	Tayside	1582
2020-05-17,Scotland,S08000030,Tayside	2020-05-17	Scotland	S08000030	Tayside	1589
2020-05-18,Scotland,S08000030,Tayside	2020-05-18	Scotland	S08000030	Tayside	1593
2020-05-19,Scotland,S08000030,Tayside	2020-05-19	Scotland	S08000030	Tayside	1599
2020-05-20,Scotland,S08000030,Tayside	2020-05-20	Scotland	S08000030	Tayside	1617
2020-05-21,Scotland,S08000030,Tayside	2020-05-21	Scotland	S08000030	Tayside	1632
2020-05-22,Scotland,S08000030,Tayside	2020-05-22	Scotland	S08000030	Tayside	1641
2020-05-23,Scotland,S08000030,Tayside	2020-05-23	Scotland	S08000030	Tayside	1645
2020-05-24,Scotland,S08000030,Tayside	2020-05-24	Scotland	S08000030	Tayside	1658
2020-05-25,Scotland,S08000030,Tayside	2020-05-25	Scotland	S08000030	Tayside	1659
2020-05-26,Scotland,S08000030,Tayside	2020-05-26	Scotland	S08000030	Tayside	1659
2020-05-27,Scotland,S08000030,Tayside	2020-05-27	Scotland	S08000030	Tayside	1661
2020-05-28,Scotland,S08000030,Tayside	2020-05-28	Scotland	S08000030	Tayside	1665
2020-05-29,Scotland,S08000030,Tayside	2020-05-29	Scotland	S08000030	Tayside	1668
2020-05-30,Scotland,S08000030,Tayside	2020-05-30	Scotland	S08000030	Tayside	1670
2020-05-31,Scotland,S08000030,Tayside	2020-05-31	Scotland	S08000030	Tayside	1671
2020-06-01,Scotland,S08000030,Tayside	2020-06-01	Scotland	S08000030	Tayside	1671
2020-06-02,Scotland,S08000030,Tayside	2020-06-02	Scotland	S08000030	Tayside	1671
2020-06-03,Scotland,S08000030,Tayside	2020-06-03	Scotland	S08000030	Tayside	1671
2020-06-04,Scotland,S08000030,Tayside	2020-06-04	Scotland	S08000030	Tayside	1671
2020-06-05,Scotland,S08000030,Tayside	2020-06-05	Scotland	S08000030	Tayside	1673
2020-06-06,Scotland,S08000030,Tayside	2020-06-06	Scotland	S08000030	Tayside	1676
2020-06-07,Scotland,S08000030,Tayside	2020-06-07	Scotland	S08000030	Tayside	1676
2020-06-08,Scotland,S08000030,Tayside	2020-06-08	Scotland	S08000030	Tayside	1677
2020-06-09,Scotland,S08000030,Tayside	2020-06-09	Scotland	S08000030	Tayside	1678
2020-06-10,Scotland,S08000030,Tayside	2020-06-10	Scotland	S08000030	Tayside	1684
2020-06-11,Scotland,S08000030,Tayside	2020-06-11	Scotland	S08000030	Tayside	1685
2020-06-12,Scotland,S08000030,Tayside	2020-06-12	Scotland	S08000030	Tayside	1685
2020-06-13,Scotland,S08000030,Tayside	2020-06-13	Scotland	S08000030	Tayside	1686
2020-06-14,Scotland,S08000030,Tayside	2020-06-14	Scotland	S08000030	Tayside	1687

Next page

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