sources

Data license: CC-BY

1 row where datasetId = 269 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "link": "http://www.palgrave.com/us/book/9780230005150",
    "retrievedDate": null,
    "additionalInfo": "Edited by Palgrave Macmillan Ltd (April 2013). International Historical Statistics [Online] Available at: http://www.palgrave.com/us/book/9780230005150 \nThese statistics \u2013 originally published under the editorial leadership of Brian Mitchell (since 1983) \u2013 are a collection of data sets taken from many primary sources, including both official national and international abstracts dating back to 1750. The books are published in three volumes covering more than 5000 pages.",
    "dataPublishedBy": "Brian Mitchell \u2013 International Historical Statistics (Births per 1,000)",
    "dataPublisherSource": "Taken from many primary sources including official national statistics and international abstracts dating back to 1750."
}

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