indicators

26 rows where Value = 2

descending

Link	Date	Country	Indicator	Value
2020-01-24,Scotland,Tests	2020-01-24	Scotland	Tests	2
2020-01-27,Northern Ireland,Tests	2020-01-27	Northern Ireland	Tests	2
2020-01-27,Wales,ConfirmedCases	2020-01-27	Wales	ConfirmedCases	2
2020-01-28,Wales,ConfirmedCases	2020-01-28	Wales	ConfirmedCases	2
2020-01-29,Wales,ConfirmedCases	2020-01-29	Wales	ConfirmedCases	2
2020-01-30,England,ConfirmedCases	2020-01-30	England	ConfirmedCases	2
2020-01-30,Wales,ConfirmedCases	2020-01-30	Wales	ConfirmedCases	2
2020-01-31,UK,ConfirmedCases	2020-01-31	UK	ConfirmedCases	2
2020-01-31,Wales,ConfirmedCases	2020-01-31	Wales	ConfirmedCases	2
2020-02-01,UK,ConfirmedCases	2020-02-01	UK	ConfirmedCases	2
2020-02-01,Wales,ConfirmedCases	2020-02-01	Wales	ConfirmedCases	2
2020-02-02,UK,ConfirmedCases	2020-02-02	UK	ConfirmedCases	2
2020-02-02,Wales,ConfirmedCases	2020-02-02	Wales	ConfirmedCases	2
2020-02-03,Northern Ireland,Tests	2020-02-03	Northern Ireland	Tests	2
2020-02-03,UK,ConfirmedCases	2020-02-03	UK	ConfirmedCases	2
2020-02-04,UK,ConfirmedCases	2020-02-04	UK	ConfirmedCases	2
2020-02-05,UK,ConfirmedCases	2020-02-05	UK	ConfirmedCases	2
2020-03-04,Wales,ConfirmedCases	2020-03-04	Wales	ConfirmedCases	2
2020-03-05,Wales,ConfirmedCases	2020-03-05	Wales	ConfirmedCases	2
2020-03-06,Wales,ConfirmedCases	2020-03-06	Wales	ConfirmedCases	2
2020-03-07,England,Deaths	2020-03-07	England	Deaths	2
2020-03-07,UK,Deaths	2020-03-07	UK	Deaths	2
2020-03-08,England,Deaths	2020-03-08	England	Deaths	2
2020-03-08,UK,Deaths	2020-03-08	UK	Deaths	2
2020-03-17,Scotland,Deaths	2020-03-17	Scotland	Deaths	2
2020-03-19,Northern Ireland,Deaths	2020-03-19	Northern Ireland	Deaths	2

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])
);