sources

Data license: CC-BY

1 row where datasetId = 5643 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "http://www.passc.net/EarthImpactDatabase/New%20website_05-2018/Index.html",
    "retrievedDate": "13 June 2022",
    "additionalInfo": "The Earth Impact Database is a database of confirmed impact structures or craters on Earth. It was initiated in 1955 by the Dominion Observatory, Ottawa. Since 2001, it has been maintained as a not-for-profit source of information at the Planetary and Space Science Centre at the University of New Brunswick, Canada.\n\nSites are incorporated into UNB's Earth Impact Database only after confirmation and collection of enough information about the site to satisfy the database's entry criteria.",
    "dataPublishedBy": "Planetary and Space Science Centre, University of New Brunswick"
}

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