cases

141 rows where AreaCode = "S08000024" 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,S08000024,Lothian	2020-03-07	Scotland	S08000024	Lothian	NaN
2020-03-08,Scotland,S08000024,Lothian	2020-03-08	Scotland	S08000024	Lothian	NaN
2020-03-09,Scotland,S08000024,Lothian	2020-03-09	Scotland	S08000024	Lothian	5
2020-03-10,Scotland,S08000024,Lothian	2020-03-10	Scotland	S08000024	Lothian	7
2020-03-11,Scotland,S08000024,Lothian	2020-03-11	Scotland	S08000024	Lothian	8
2020-03-12,Scotland,S08000024,Lothian	2020-03-12	Scotland	S08000024	Lothian	11
2020-03-13,Scotland,S08000024,Lothian	2020-03-13	Scotland	S08000024	Lothian	19
2020-03-14,Scotland,S08000024,Lothian	2020-03-14	Scotland	S08000024	Lothian	25
2020-03-15,Scotland,S08000024,Lothian	2020-03-15	Scotland	S08000024	Lothian	28
2020-03-16,Scotland,S08000024,Lothian	2020-03-16	Scotland	S08000024	Lothian	29
2020-03-17,Scotland,S08000024,Lothian	2020-03-17	Scotland	S08000024	Lothian	30
2020-03-18,Scotland,S08000024,Lothian	2020-03-18	Scotland	S08000024	Lothian	33
2020-03-19,Scotland,S08000024,Lothian	2020-03-19	Scotland	S08000024	Lothian	35
2020-03-20,Scotland,S08000024,Lothian	2020-03-20	Scotland	S08000024	Lothian	40
2020-03-21,Scotland,S08000024,Lothian	2020-03-21	Scotland	S08000024	Lothian	44
2020-03-22,Scotland,S08000024,Lothian	2020-03-22	Scotland	S08000024	Lothian	46
2020-03-23,Scotland,S08000024,Lothian	2020-03-23	Scotland	S08000024	Lothian	59
2020-03-24,Scotland,S08000024,Lothian	2020-03-24	Scotland	S08000024	Lothian	70
2020-03-25,Scotland,S08000024,Lothian	2020-03-25	Scotland	S08000024	Lothian	88
2020-03-26,Scotland,S08000024,Lothian	2020-03-26	Scotland	S08000024	Lothian	111
2020-03-27,Scotland,S08000024,Lothian	2020-03-27	Scotland	S08000024	Lothian	139
2020-03-28,Scotland,S08000024,Lothian	2020-03-28	Scotland	S08000024	Lothian	151
2020-03-29,Scotland,S08000024,Lothian	2020-03-29	Scotland	S08000024	Lothian	188
2020-03-30,Scotland,S08000024,Lothian	2020-03-30	Scotland	S08000024	Lothian	208
2020-03-31,Scotland,S08000024,Lothian	2020-03-31	Scotland	S08000024	Lothian	269
2020-04-01,Scotland,S08000024,Lothian	2020-04-01	Scotland	S08000024	Lothian	311
2020-04-02,Scotland,S08000024,Lothian	2020-04-02	Scotland	S08000024	Lothian	356
2020-04-03,Scotland,S08000024,Lothian	2020-04-03	Scotland	S08000024	Lothian	408
2020-04-04,Scotland,S08000024,Lothian	2020-04-04	Scotland	S08000024	Lothian	476
2020-04-05,Scotland,S08000024,Lothian	2020-04-05	Scotland	S08000024	Lothian	534
2020-04-06,Scotland,S08000024,Lothian	2020-04-06	Scotland	S08000024	Lothian	577
2020-04-07,Scotland,S08000024,Lothian	2020-04-07	Scotland	S08000024	Lothian	621
2020-04-08,Scotland,S08000024,Lothian	2020-04-08	Scotland	S08000024	Lothian	700
2020-04-09,Scotland,S08000024,Lothian	2020-04-09	Scotland	S08000024	Lothian	747
2020-04-10,Scotland,S08000024,Lothian	2020-04-10	Scotland	S08000024	Lothian	799
2020-04-11,Scotland,S08000024,Lothian	2020-04-11	Scotland	S08000024	Lothian	856
2020-04-12,Scotland,S08000024,Lothian	2020-04-12	Scotland	S08000024	Lothian	915
2020-04-13,Scotland,S08000024,Lothian	2020-04-13	Scotland	S08000024	Lothian	932
2020-04-14,Scotland,S08000024,Lothian	2020-04-14	Scotland	S08000024	Lothian	989
2020-04-15,Scotland,S08000024,Lothian	2020-04-15	Scotland	S08000024	Lothian	1040
2020-04-16,Scotland,S08000024,Lothian	2020-04-16	Scotland	S08000024	Lothian	1107
2020-04-17,Scotland,S08000024,Lothian	2020-04-17	Scotland	S08000024	Lothian	1172
2020-04-18,Scotland,S08000024,Lothian	2020-04-18	Scotland	S08000024	Lothian	1239
2020-04-19,Scotland,S08000024,Lothian	2020-04-19	Scotland	S08000024	Lothian	1344
2020-04-20,Scotland,S08000024,Lothian	2020-04-20	Scotland	S08000024	Lothian	1399
2020-04-21,Scotland,S08000024,Lothian	2020-04-21	Scotland	S08000024	Lothian	1426
2020-04-22,Scotland,S08000024,Lothian	2020-04-22	Scotland	S08000024	Lothian	1515
2020-04-23,Scotland,S08000024,Lothian	2020-04-23	Scotland	S08000024	Lothian	1604
2020-04-24,Scotland,S08000024,Lothian	2020-04-24	Scotland	S08000024	Lothian	1684
2020-04-25,Scotland,S08000024,Lothian	2020-04-25	Scotland	S08000024	Lothian	1730
2020-04-26,Scotland,S08000024,Lothian	2020-04-26	Scotland	S08000024	Lothian	1785
2020-04-27,Scotland,S08000024,Lothian	2020-04-27	Scotland	S08000024	Lothian	1804
2020-04-28,Scotland,S08000024,Lothian	2020-04-28	Scotland	S08000024	Lothian	1832
2020-04-29,Scotland,S08000024,Lothian	2020-04-29	Scotland	S08000024	Lothian	1907
2020-04-30,Scotland,S08000024,Lothian	2020-04-30	Scotland	S08000024	Lothian	1980
2020-05-01,Scotland,S08000024,Lothian	2020-05-01	Scotland	S08000024	Lothian	2014
2020-05-02,Scotland,S08000024,Lothian	2020-05-02	Scotland	S08000024	Lothian	2065
2020-05-03,Scotland,S08000024,Lothian	2020-05-03	Scotland	S08000024	Lothian	2089
2020-05-04,Scotland,S08000024,Lothian	2020-05-04	Scotland	S08000024	Lothian	2113
2020-05-05,Scotland,S08000024,Lothian	2020-05-05	Scotland	S08000024	Lothian	2149
2020-05-06,Scotland,S08000024,Lothian	2020-05-06	Scotland	S08000024	Lothian	2200
2020-05-07,Scotland,S08000024,Lothian	2020-05-07	Scotland	S08000024	Lothian	2241
2020-05-08,Scotland,S08000024,Lothian	2020-05-08	Scotland	S08000024	Lothian	2274
2020-05-09,Scotland,S08000024,Lothian	2020-05-09	Scotland	S08000024	Lothian	2324
2020-05-10,Scotland,S08000024,Lothian	2020-05-10	Scotland	S08000024	Lothian	2359
2020-05-11,Scotland,S08000024,Lothian	2020-05-11	Scotland	S08000024	Lothian	2380
2020-05-12,Scotland,S08000024,Lothian	2020-05-12	Scotland	S08000024	Lothian	2397
2020-05-13,Scotland,S08000024,Lothian	2020-05-13	Scotland	S08000024	Lothian	2428
2020-05-14,Scotland,S08000024,Lothian	2020-05-14	Scotland	S08000024	Lothian	2459
2020-05-15,Scotland,S08000024,Lothian	2020-05-15	Scotland	S08000024	Lothian	2497
2020-05-16,Scotland,S08000024,Lothian	2020-05-16	Scotland	S08000024	Lothian	2539
2020-05-17,Scotland,S08000024,Lothian	2020-05-17	Scotland	S08000024	Lothian	2561
2020-05-18,Scotland,S08000024,Lothian	2020-05-18	Scotland	S08000024	Lothian	2568
2020-05-19,Scotland,S08000024,Lothian	2020-05-19	Scotland	S08000024	Lothian	2575
2020-05-20,Scotland,S08000024,Lothian	2020-05-20	Scotland	S08000024	Lothian	2584
2020-05-21,Scotland,S08000024,Lothian	2020-05-21	Scotland	S08000024	Lothian	2611
2020-05-22,Scotland,S08000024,Lothian	2020-05-22	Scotland	S08000024	Lothian	2634
2020-05-23,Scotland,S08000024,Lothian	2020-05-23	Scotland	S08000024	Lothian	2649
2020-05-24,Scotland,S08000024,Lothian	2020-05-24	Scotland	S08000024	Lothian	2665
2020-05-25,Scotland,S08000024,Lothian	2020-05-25	Scotland	S08000024	Lothian	2669
2020-05-26,Scotland,S08000024,Lothian	2020-05-26	Scotland	S08000024	Lothian	2675
2020-05-27,Scotland,S08000024,Lothian	2020-05-27	Scotland	S08000024	Lothian	2685
2020-05-28,Scotland,S08000024,Lothian	2020-05-28	Scotland	S08000024	Lothian	2691
2020-05-29,Scotland,S08000024,Lothian	2020-05-29	Scotland	S08000024	Lothian	2698
2020-05-30,Scotland,S08000024,Lothian	2020-05-30	Scotland	S08000024	Lothian	2706
2020-05-31,Scotland,S08000024,Lothian	2020-05-31	Scotland	S08000024	Lothian	2709
2020-06-01,Scotland,S08000024,Lothian	2020-06-01	Scotland	S08000024	Lothian	2714
2020-06-02,Scotland,S08000024,Lothian	2020-06-02	Scotland	S08000024	Lothian	2716
2020-06-03,Scotland,S08000024,Lothian	2020-06-03	Scotland	S08000024	Lothian	2723
2020-06-04,Scotland,S08000024,Lothian	2020-06-04	Scotland	S08000024	Lothian	2752
2020-06-05,Scotland,S08000024,Lothian	2020-06-05	Scotland	S08000024	Lothian	2760
2020-06-06,Scotland,S08000024,Lothian	2020-06-06	Scotland	S08000024	Lothian	2769
2020-06-07,Scotland,S08000024,Lothian	2020-06-07	Scotland	S08000024	Lothian	2772
2020-06-08,Scotland,S08000024,Lothian	2020-06-08	Scotland	S08000024	Lothian	2774
2020-06-09,Scotland,S08000024,Lothian	2020-06-09	Scotland	S08000024	Lothian	2777
2020-06-10,Scotland,S08000024,Lothian	2020-06-10	Scotland	S08000024	Lothian	2778
2020-06-11,Scotland,S08000024,Lothian	2020-06-11	Scotland	S08000024	Lothian	2783
2020-06-12,Scotland,S08000024,Lothian	2020-06-12	Scotland	S08000024	Lothian	2794
2020-06-13,Scotland,S08000024,Lothian	2020-06-13	Scotland	S08000024	Lothian	2803
2020-06-14,Scotland,S08000024,Lothian	2020-06-14	Scotland	S08000024	Lothian	2807

Next page

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