sources
Data license: CC-BY
1 row where datasetId = 2658 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 |
---|---|---|---|---|---|---|---|---|
14879 | OECD - Social Protection and Well-being - Children Well Being | { "link": "https://stats.oecd.org/Index.aspx?DataSetCode=CWB", "retrievedDate": "16-March-18", "additionalInfo": "", "dataPublishedBy": "OECD.Stat", "dataPublisherSource": null } |
2018-03-16 17:19:40 | 2018-03-16 17:19:40 | Social Protection and Well-being - Children Well Being 2658 | https://stats.oecd.org/Index.aspx?DataSetCode=CWB | OECD.Stat |
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");