sources
Data license: CC-BY
1 row where datasetId = 131 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 |
---|---|---|---|---|---|---|---|---|
62 | U.S. Bureau of Labor Statistics (2013) | { "link": "http://www.bls.gov/opub/uscs/2002-03.pdf", "retrievedDate": "01/01/2013", "additionalInfo": "Wages in the Manufacturing Sector vs. Several Food Prices USA \u00a0\u2013 BLS Data", "dataPublishedBy": "U.S. Bureau of Labor Statistics, Consumer Expenditure Survey", "dataPublisherSource": null } |
2015-09-20 18:27:07 | 2017-11-02 13:04:39 | Wages in the manufacturing sector vs. several food prices in the US – U.S. Bureau of Labor Statistics (2013) 131 | Wages in the Manufacturing Sector vs. Several Food Prices USA – BLS Data | http://www.bls.gov/opub/uscs/2002-03.pdf | U.S. Bureau of Labor Statistics, Consumer Expenditure Survey |
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");