sources
Data license: CC-BY
1 row where datasetId = 3192 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 |
---|---|---|---|---|---|---|---|---|
16696 | Meat consumption in EU28 (OECD, 2018) | { "link": "https://data.oecd.org/agroutput/meat-consumption.htm", "retrievedDate": "25th January 2018", "additionalInfo": "Per capita meat availability, given as the average of the EU-28 countries. Meat availability is typically taken as an estimate of per capita consumption. Meat availability does not account for consumption (household and retail waste), so actual consumption will be slightly lower than these values.\n\nPer capita meat consumption is measured in kilograms per person per year.", "dataPublishedBy": "Organisation for Economic Co-operation and Development (OECD, 2018)" } |
2019-01-25 21:09:45 | 2019-01-25 21:09:45 | Meat consumption in EU28 (OECD, 2018) 3192 | Per capita meat availability, given as the average of the EU-28 countries. Meat availability is typically taken as an estimate of per capita consumption. Meat availability does not account for consumption (household and retail waste), so actual consumption will be slightly lower than these values. Per capita meat consumption is measured in kilograms per person per year. | https://data.oecd.org/agroutput/meat-consumption.htm | Organisation for Economic Co-operation and Development (OECD, 2018) |
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");