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 = 4194 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
17022 Whale populations (Pershing et al. 2010) 
{
    "link": "https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0012444",
    "retrievedDate": "28th August 2019",
    "additionalInfo": "Estimates of whale populations pre-whaling and in 2001 were published by Pershing et al. (2010), and originally sourced from Christensen (2006). See full references below.\n\nThe dates of pre-whaling differs depending on the whale species and oceanic region. This ranges from as far back as 1530 for Right whales. The most common 'pre-whaling' date in the original source was in the late 19th and early 20th century. Here we have coded all pre-whaling dates as 1890 for consistency, but it should be noted that this date varies by species. The latest date \u2013 2001 \u2013 is consistent across species.\n\nAll estimates are of the global total.",
    "dataPublishedBy": "Pershing, A. J., Christensen, L. B., Record, N. R., Sherwood, G. D., & Stetson, P. B. (2010). The impact of whaling on the ocean carbon cycle: why bigger was better. PloS One, 5(8), e12444.",
    "dataPublisherSource": "Christensen, L. B. (2006). Marine mammal populations: reconstructing historical abundances at the global scale."
}
 2019-08-28 12:05:00 2019-08-28 12:05:00 Whale populations (Pershing et al. 2010) 4194 Estimates of whale populations pre-whaling and in 2001 were published by Pershing et al. (2010), and originally sourced from Christensen (2006). See full references below. The dates of pre-whaling differs depending on the whale species and oceanic region. This ranges from as far back as 1530 for Right whales. The most common 'pre-whaling' date in the original source was in the late 19th and early 20th century. Here we have coded all pre-whaling dates as 1890 for consistency, but it should be noted that this date varies by species. The latest date – 2001 – is consistent across species. All estimates are of the global total. https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0012444 Pershing, A. J., Christensen, L. B., Record, N. R., Sherwood, G. D., & Stetson, P. B. (2010). The impact of whaling on the ocean carbon cycle: why bigger was better. PloS One, 5(8), e12444.

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