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 = 568 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
2205 National Human Genome Research Institute (2022) 
{
    "link": "https://www.genome.gov/about-genomics/fact-sheets/DNA-Sequencing-Costs-Data",
    "retrievedDate": "2022-06-22",
    "additionalInfo": "The NHGRI program describes genome sequencing costs relative to two metrics, quoted below:\n\n\"(1) \"Cost per Megabase of DNA Sequence\" - the cost of determining one megabase (Mb; a million bases) of DNA sequence of a specified quality;\n\n(2) \"Cost per Genome\" - the cost of sequencing a human-sized genome.\"\n\nCost data from the NHGRI is presented bi-annually or seasonally for each year. We have summarized this data annually by calculating the lowest yearly cost.",
    "dataPublishedBy": "Wetterstrand KA. DNA Sequencing Costs: Data from the NHGRI Genome Sequencing Program (GSP)",
    "dataPublisherSource": null
}
 2017-07-11 12:59:43 2023-03-03 10:28:30 NIH - DNA Sequencing Costs 568 The NHGRI program describes genome sequencing costs relative to two metrics, quoted below: "(1) "Cost per Megabase of DNA Sequence" - the cost of determining one megabase (Mb; a million bases) of DNA sequence of a specified quality; (2) "Cost per Genome" - the cost of sequencing a human-sized genome." Cost data from the NHGRI is presented bi-annually or seasonally for each year. We have summarized this data annually by calculating the lowest yearly cost. https://www.genome.gov/about-genomics/fact-sheets/DNA-Sequencing-Costs-Data Wetterstrand KA. DNA Sequencing Costs: Data from the NHGRI Genome Sequencing Program (GSP)

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