sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 3029 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
15433 Schofield (1973) 
{
    "link": "https://goo.gl/ummXiK and https://catalog.hathitrust.org/Record/000046692",
    "retrievedDate": "26/03/2018",
    "additionalInfo": "Original data for 1840 and 1842 gives the proportion of persons who signed the marriage register with marks (i.e. who were illiterate). To arrive at current estimates: % who are literate = 100 - (% who are illiterate).",
    "dataPublishedBy": "Schofield, R.S., 1973. Dimensions of illiteracy, 1750\u20131850. Explorations in economic history, 10(4), pp.437-454.",
    "dataPublisherSource": "Annual report of the Registrar-General for England and Wales."
}
 2018-03-26 14:59:52 2018-03-26 14:59:52 Male literacy rate (Schofield (1973)) (split) 3029 Original data for 1840 and 1842 gives the proportion of persons who signed the marriage register with marks (i.e. who were illiterate). To arrive at current estimates: % who are literate = 100 - (% who are illiterate). https://goo.gl/ummXiK and https://catalog.hathitrust.org/Record/000046692 Schofield, R.S., 1973. Dimensions of illiteracy, 1750–1850. Explorations in economic history, 10(4), pp.437-454.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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