indicators

648 rows where Indicator = "Tests"

descending

Link	Date	Country	Indicator	Value
2020-01-08,Wales,Tests	2020-01-08	Wales	Tests	1
2020-01-09,Wales,Tests	2020-01-09	Wales	Tests	1
2020-01-10,Wales,Tests	2020-01-10	Wales	Tests	1
2020-01-11,Wales,Tests	2020-01-11	Wales	Tests	1
2020-01-12,Wales,Tests	2020-01-12	Wales	Tests	1
2020-01-13,Wales,Tests	2020-01-13	Wales	Tests	1
2020-01-14,Wales,Tests	2020-01-14	Wales	Tests	1
2020-01-15,Wales,Tests	2020-01-15	Wales	Tests	1
2020-01-16,Northern Ireland,Tests	2020-01-16	Northern Ireland	Tests	1
2020-01-16,Wales,Tests	2020-01-16	Wales	Tests	1
2020-01-17,Wales,Tests	2020-01-17	Wales	Tests	3
2020-01-18,Wales,Tests	2020-01-18	Wales	Tests	3
2020-01-19,Wales,Tests	2020-01-19	Wales	Tests	3
2020-01-20,Wales,Tests	2020-01-20	Wales	Tests	4
2020-01-21,Wales,Tests	2020-01-21	Wales	Tests	4
2020-01-22,Wales,Tests	2020-01-22	Wales	Tests	5
2020-01-23,Wales,Tests	2020-01-23	Wales	Tests	5
2020-01-24,Scotland,Tests	2020-01-24	Scotland	Tests	2
2020-01-24,Wales,Tests	2020-01-24	Wales	Tests	5
2020-01-25,Scotland,Tests	2020-01-25	Scotland	Tests	5
2020-01-25,UK,Tests	2020-01-25	UK	Tests	31
2020-01-25,Wales,Tests	2020-01-25	Wales	Tests	5
2020-01-26,Scotland,Tests	2020-01-26	Scotland	Tests	6
2020-01-26,UK,Tests	2020-01-26	UK	Tests	52
2020-01-26,Wales,Tests	2020-01-26	Wales	Tests	5
2020-01-27,Northern Ireland,Tests	2020-01-27	Northern Ireland	Tests	2
2020-01-27,Scotland,Tests	2020-01-27	Scotland	Tests	7
2020-01-27,UK,Tests	2020-01-27	UK	Tests	73
2020-01-27,Wales,Tests	2020-01-27	Wales	Tests	6
2020-01-28,Scotland,Tests	2020-01-28	Scotland	Tests	11
2020-01-28,UK,Tests	2020-01-28	UK	Tests	97
2020-01-28,Wales,Tests	2020-01-28	Wales	Tests	6
2020-01-29,Scotland,Tests	2020-01-29	Scotland	Tests	11
2020-01-29,UK,Tests	2020-01-29	UK	Tests	130
2020-01-29,Wales,Tests	2020-01-29	Wales	Tests	6
2020-01-30,Scotland,Tests	2020-01-30	Scotland	Tests	16
2020-01-30,UK,Tests	2020-01-30	UK	Tests	161
2020-01-30,Wales,Tests	2020-01-30	Wales	Tests	7
2020-01-31,Scotland,Tests	2020-01-31	Scotland	Tests	16
2020-01-31,UK,Tests	2020-01-31	UK	Tests	177
2020-01-31,Wales,Tests	2020-01-31	Wales	Tests	7
2020-02-01,Scotland,Tests	2020-02-01	Scotland	Tests	16
2020-02-01,UK,Tests	2020-02-01	UK	Tests	203
2020-02-01,Wales,Tests	2020-02-01	Wales	Tests	8
2020-02-02,Scotland,Tests	2020-02-02	Scotland	Tests	16
2020-02-02,UK,Tests	2020-02-02	UK	Tests	266
2020-02-02,Wales,Tests	2020-02-02	Wales	Tests	8
2020-02-03,Northern Ireland,Tests	2020-02-03	Northern Ireland	Tests	2
2020-02-03,Scotland,Tests	2020-02-03	Scotland	Tests	26
2020-02-03,UK,Tests	2020-02-03	UK	Tests	326
2020-02-03,Wales,Tests	2020-02-03	Wales	Tests	3
2020-02-04,Scotland,Tests	2020-02-04	Scotland	Tests	26
2020-02-04,UK,Tests	2020-02-04	UK	Tests	416
2020-02-04,Wales,Tests	2020-02-04	Wales	Tests	5
2020-02-05,Scotland,Tests	2020-02-05	Scotland	Tests	31
2020-02-05,UK,Tests	2020-02-05	UK	Tests	468
2020-02-05,Wales,Tests	2020-02-05	Wales	Tests	5
2020-02-06,Northern Ireland,Tests	2020-02-06	Northern Ireland	Tests	3
2020-02-06,Scotland,Tests	2020-02-06	Scotland	Tests	34
2020-02-06,UK,Tests	2020-02-06	UK	Tests	566
2020-02-06,Wales,Tests	2020-02-06	Wales	Tests	10
2020-02-07,Northern Ireland,Tests	2020-02-07	Northern Ireland	Tests	9
2020-02-07,Scotland,Tests	2020-02-07	Scotland	Tests	38
2020-02-07,UK,Tests	2020-02-07	UK	Tests	620
2020-02-07,Wales,Tests	2020-02-07	Wales	Tests	21
2020-02-08,Northern Ireland,Tests	2020-02-08	Northern Ireland	Tests	13
2020-02-08,Scotland,Tests	2020-02-08	Scotland	Tests	38
2020-02-08,UK,Tests	2020-02-08	UK	Tests	686
2020-02-08,Wales,Tests	2020-02-08	Wales	Tests	44
2020-02-09,Northern Ireland,Tests	2020-02-09	Northern Ireland	Tests	16
2020-02-09,Scotland,Tests	2020-02-09	Scotland	Tests	41
2020-02-09,UK,Tests	2020-02-09	UK	Tests	795
2020-02-09,Wales,Tests	2020-02-09	Wales	Tests	61
2020-02-10,Northern Ireland,Tests	2020-02-10	Northern Ireland	Tests	19
2020-02-10,Scotland,Tests	2020-02-10	Scotland	Tests	57
2020-02-10,UK,Tests	2020-02-10	UK	Tests	1114
2020-02-10,Wales,Tests	2020-02-10	Wales	Tests	61
2020-02-11,Northern Ireland,Tests	2020-02-11	Northern Ireland	Tests	21
2020-02-11,Scotland,Tests	2020-02-11	Scotland	Tests	82
2020-02-11,UK,Tests	2020-02-11	UK	Tests	1358
2020-02-11,Wales,Tests	2020-02-11	Wales	Tests	62
2020-02-12,Northern Ireland,Tests	2020-02-12	Northern Ireland	Tests	21
2020-02-12,Scotland,Tests	2020-02-12	Scotland	Tests	106
2020-02-12,UK,Tests	2020-02-12	UK	Tests	1758
2020-02-12,Wales,Tests	2020-02-12	Wales	Tests	63
2020-02-13,Northern Ireland,Tests	2020-02-13	Northern Ireland	Tests	24
2020-02-13,Scotland,Tests	2020-02-13	Scotland	Tests	148
2020-02-13,UK,Tests	2020-02-13	UK	Tests	2521
2020-02-13,Wales,Tests	2020-02-13	Wales	Tests	64
2020-02-14,Northern Ireland,Tests	2020-02-14	Northern Ireland	Tests	27
2020-02-14,Scotland,Tests	2020-02-14	Scotland	Tests	200
2020-02-14,UK,Tests	2020-02-14	UK	Tests	2964
2020-02-14,Wales,Tests	2020-02-14	Wales	Tests	71
2020-02-15,Northern Ireland,Tests	2020-02-15	Northern Ireland	Tests	28
2020-02-15,Scotland,Tests	2020-02-15	Scotland	Tests	224
2020-02-15,UK,Tests	2020-02-15	UK	Tests	2992
2020-02-15,Wales,Tests	2020-02-15	Wales	Tests	80
2020-02-16,Scotland,Tests	2020-02-16	Scotland	Tests	252
2020-02-16,UK,Tests	2020-02-16	UK	Tests	3109
2020-02-16,Wales,Tests	2020-02-16	Wales	Tests	87

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE "indicators" (
"Date" TEXT,
  "Country" TEXT,
  "Indicator" TEXT,
  "Value" INTEGER
  ,PRIMARY KEY ([Date], [Country], [Indicator])
);