sources
Data license: CC-BY
1 row where datasetId = 2426 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 |
|---|---|---|---|---|---|---|---|---|
| 14429 | Chapman (1972) | {
"link": "https://books.google.co.uk/books?id=WXSxCwAAQBAJ&pg=PA20&lpg=PA20&dq=chapman+indian+hand+spinners+OHP&source=bl&ots=mTMxRdxaVr&sig=VYSMfB8AJMMpGv6qz9XlCJrTp1Q&hl=en&sa=X&ved=0ahUKEwiIucSq2KrZAhWCsxQKHeQkDBcQ6AEIPTAH#v=onepage&q=chapman%20indian%20hand%20spinners%20OHP&f=false",
"retrievedDate": "15/02/2018",
"additionalInfo": "The easiest way to illustrate the improvements in labor productivity in cotton spinning over time is to reproduce data on labor productivity from Catling\u2019s study of The Spinning Mule, from which the measure of OHP - operative hours to process 100 lbs (45 kg) of cotton - is applied to other technologies, as shown. [Please see table 2 on page 20 for the original data.]\n\nCatling\u2019s study of The Spinning Mule provides a historical introduction of the invention of the spinning mule in the 18th century. The spinning mule was worked by hand with the spinner manually controlled all its operations. It was around 1825 that Richard Roberts invented the \u2018quadrant winding motion\u2019 that enabled the machine to operate automatically.\n\nFull reference: Chapman, S.D., 1987. The cotton industry in the industrial revolution. In The Industrial Revolution A Compendium (pp. 1-64). Palgrave, London.",
"dataPublishedBy": "Chapman, S.D., 1987. The cotton industry in the industrial revolution. In The Industrial Revolution A Compendium (pp. 1-64). Palgrave, London.",
"dataPublisherSource": "Historical data."
} |
2018-02-15 15:20:31 | 2018-02-20 09:54:26 | Labor productivity in cotton spinning (Chapman (1972)) 2426 | The easiest way to illustrate the improvements in labor productivity in cotton spinning over time is to reproduce data on labor productivity from Catling’s study of The Spinning Mule, from which the measure of OHP - operative hours to process 100 lbs (45 kg) of cotton - is applied to other technologies, as shown. [Please see table 2 on page 20 for the original data.] Catling’s study of The Spinning Mule provides a historical introduction of the invention of the spinning mule in the 18th century. The spinning mule was worked by hand with the spinner manually controlled all its operations. It was around 1825 that Richard Roberts invented the ‘quadrant winding motion’ that enabled the machine to operate automatically. Full reference: Chapman, S.D., 1987. The cotton industry in the industrial revolution. In The Industrial Revolution A Compendium (pp. 1-64). Palgrave, London. | https://books.google.co.uk/books?id=WXSxCwAAQBAJ&pg=PA20&lpg=PA20&dq=chapman+indian+hand+spinners+OHP&source=bl&ots=mTMxRdxaVr&sig=VYSMfB8AJMMpGv6qz9XlCJrTp1Q&hl=en&sa=X&ved=0ahUKEwiIucSq2KrZAhWCsxQKHeQkDBcQ6AEIPTAH#v=onepage&q=chapman%20indian%20hand%20spinners%20OHP&f=false | Chapman, S.D., 1987. The cotton industry in the industrial revolution. In The Industrial Revolution A Compendium (pp. 1-64). Palgrave, London. |
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");