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 = 5373 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
20617 Gephart et al. (2021). Environmental performance of blue foods. Nature. 
{
    "link": "https://www.nature.com/articles/s41586-021-03889-2",
    "additionalInfo": "This meta-study brings together life cycle inventory data (i.e., material and energy input and farm-level performance data) from studies of the environmental footprint of wild-caught and farmed seafood products. It draws on data from over 1690 farms and 1000 unique fishery records.\n\nThese impacts include those on-farm and off-farm, but stops at the farmgate (or landing of fish). This means it does not include impacts such as transport to retail, packaging, processing or cooking.\n\nImpacts are normalised by the fish or seafood's edible weight (rather than their live weight).",
    "dataPublishedBy": "Gephart, J. A., Henriksson, P. J., Parker, R. W., Shepon, A., Gorospe, K. D., Bergman, K., ... & Tyedmers, P. (2021). Environmental performance of blue foods. Nature."
}
 2021-09-16 09:14:24 2021-09-16 09:14:24 Environmental impacts of seafood (Gephart et al. 2021) 5373 This meta-study brings together life cycle inventory data (i.e., material and energy input and farm-level performance data) from studies of the environmental footprint of wild-caught and farmed seafood products. It draws on data from over 1690 farms and 1000 unique fishery records. These impacts include those on-farm and off-farm, but stops at the farmgate (or landing of fish). This means it does not include impacts such as transport to retail, packaging, processing or cooking. Impacts are normalised by the fish or seafood's edible weight (rather than their live weight). https://www.nature.com/articles/s41586-021-03889-2 Gephart, J. A., Henriksson, P. J., Parker, R. W., Shepon, A., Gorospe, K. D., Bergman, K., ... & Tyedmers, P. (2021). Environmental performance of blue foods. Nature.

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