sources

Data license: CC-BY

1 row where datasetId = 5619 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "link": "https://www.itopf.org/knowledge-resources/data-statistics/statistics/",
    "retrievedDate": "4th May 2022",
    "additionalInfo": "The International Tanker Owners Pollution Federation (ITOPF) publishes annual data on the number and quantities of oil spilled from tankers globally.\n\nThe latest report from the ITOPF is published here: https://www.itopf.org/fileadmin/uploads/itopf/data/Documents/Company_Lit/Oil_Spill_Stats_2021.pdf\n\nWe have extracted the data from the published tables of annual statistics.\n\nDecadal figures are given as the total, or annual average over the ten years starting at the decadal base year: for example, the figures for the 1990s is the 10 years from 1990 (inclusive) to 1999.",
    "dataPublishedBy": "International Tanker Owners Pollution Federation (ITOPF)"
}

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