owid: sources: 1 row where datasetId = 5338 sorted by id descending

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 = 5338 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
18058	GISAID, via CoVariants.org – Last updated 9 August 2023	{ "link": "https://www.gisaid.org/", "additionalInfo": "Enabled by data from <a href=\"https://gisaid.org\"><img src=\"https://www.gisaid.org/fileadmin/gisaid/img/schild.png\" width=\"50\"/></a>\n\nOur data on SARS-CoV-2 sequencing and variants is sourced from <a href=\"https://gisaid.org\">GISAID</a>, a global science initiative that provides open-access to genomic data of SARS-CoV-2. We recognize the work of the authors and laboratories responsible for producing this data and sharing it via the GISAID initiative.\n\nKhare, S., et al (2021) GISAID\u2019s Role in Pandemic Response. China CDC Weekly, 3(49): 1049-1051. doi: 10.46234/ccdcw2021.255 PMCID: 8668406\n\nElbe, S. and Buckland-Merrett, G. (2017) Data, disease and diplomacy: GISAID\u2019s innovative contribution to global health. Global Challenges, 1:33-46. doi:10.1002/gch2.1018 PMCID: 31565258\n\nShu, Y. and McCauley, J. (2017) GISAID: from vision to reality. EuroSurveillance, 22(13) doi:10.2807/1560-7917.ES.2017.22.13.30494 PMCID: PMC5388101\n\nWe download aggregate-level data via <a href=\"https://covariants.org\">CoVariants.org</a>.", "dataPublishedBy": "GISAID, via CoVariants.org \u2013 Last updated 2 November 2022" }	2021-07-01 00:30:06	2023-08-09 13:11:11	COVID-19 - Variants 5338	Enabled by data from <a href="https://gisaid.org"><img src="https://www.gisaid.org/fileadmin/gisaid/img/schild.png" width="50"/></a> Our data on SARS-CoV-2 sequencing and variants is sourced from <a href="https://gisaid.org">GISAID</a>, a global science initiative that provides open-access to genomic data of SARS-CoV-2. We recognize the work of the authors and laboratories responsible for producing this data and sharing it via the GISAID initiative. Khare, S., et al (2021) GISAID’s Role in Pandemic Response. China CDC Weekly, 3(49): 1049-1051. doi: 10.46234/ccdcw2021.255 PMCID: 8668406 Elbe, S. and Buckland-Merrett, G. (2017) Data, disease and diplomacy: GISAID’s innovative contribution to global health. Global Challenges, 1:33-46. doi:10.1002/gch2.1018 PMCID: 31565258 Shu, Y. and McCauley, J. (2017) GISAID: from vision to reality. EuroSurveillance, 22(13) doi:10.2807/1560-7917.ES.2017.22.13.30494 PMCID: PMC5388101 We download aggregate-level data via <a href="https://covariants.org">CoVariants.org</a>.	https://www.gisaid.org/	GISAID, via CoVariants.org – Last updated 2 November 2022

Advanced export

JSON shape: default, array, newline-delimited, object

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