sources
Data license: CC-BY
2 rows where datasetId = 6151 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
30953 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 | { "link": "https://coronavirus.data.gov.uk/details/download", "retrievedDate": "2024-07-30", "additionalInfo": "", "dataPublishedBy": "Government of the United Kingdom" } |
2024-07-30 16:30:50 | 2024-07-31 15:42:18 | uk_covid_data 6151 | https://coronavirus.data.gov.uk/details/download | Government of the United Kingdom | |
30952 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 | { "link": "https://coronavirus.data.gov.uk/details/download", "retrievedDate": "2024-07-30", "additionalInfo": null, "dataPublishedBy": "Government of the United Kingdom" } |
2024-07-30 16:30:50 | 2024-07-31 15:42:06 | uk_covid_data 6151 | https://coronavirus.data.gov.uk/details/download | Government of the United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");