sources

Data license: CC-BY

1 row where datasetId = 852 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "https://www.drugabuse.gov/related-topics/trends-statistics/overdose-death-rates",
    "retrievedDate": "",
    "additionalInfo": "The National Center for Health Statistics (NCHS) at the Centers for Disease Control and Prevention collects information on deaths involving drugs commonly associated with fatal overdose. This information is available in a searchable database called <a href=\"https://wonder.cdc.gov/\">CDC Wonder</a>.",
    "dataPublishedBy": "US Centers for Disease Control and Prevention WONDER",
    "dataPublisherSource": ""
}

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