sources
Data license: CC-BY
1 row where datasetId = 2643 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 |
---|---|---|---|---|---|---|---|---|
14864 | OECD - Health - Health Care Resources | { "link": "https://stats.oecd.org/Index.aspx?DataSetCode=HEALTH_REAC", "retrievedDate": "16-March-18", "additionalInfo": "Contact person/organisation\n\[email protected]\nmailto:[email protected]\nData source(s) used\n\nDefinitions, Sources and Methods per country\nhttp://stats.oecd.org/wbos/fileview2.aspx?IDFile=80130ebd-5f8d-482f-9613-2891b0fc0fcf\nDate last input received\nLast updated on November 10, 2017.\n", "dataPublishedBy": "OECD.Stat", "dataPublisherSource": null } |
2018-03-16 17:19:23 | 2018-03-16 17:19:23 | Health - Health Care Resources 2643 | Contact person/organisation [email protected] mailto:[email protected] Data source(s) used Definitions, Sources and Methods per country http://stats.oecd.org/wbos/fileview2.aspx?IDFile=80130ebd-5f8d-482f-9613-2891b0fc0fcf Date last input received Last updated on November 10, 2017. | https://stats.oecd.org/Index.aspx?DataSetCode=HEALTH_REAC | 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");