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 = 5623 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
22609 World Health Organization (2022) 
{
    "link": "https://www.who.int/data/sets/global-excess-deaths-associated-with-covid-19-modelled-estimates",
    "retrievedDate": "10 May 2022",
    "additionalInfo": "Data from the WHO estimating the number of excess deaths, from all causes, during the COVID-19 pandemic for 194 countries & regions.\n\nThe WHO defines excess mortality as \"the mortality above what would be expected based on the non-crisis mortality rate in the population of interest\".\n\nThe model generates estimates for countries for which adequate input data were available for reliable inference and to then predict estimates for countries with no data available.\n\nRead more about the methodology here: https://www.who.int/publications/m/item/methods-for-estimating-the-excess-mortality-associatedwith-the-covid-19-pandemic",
    "dataPublishedBy": "WHO Global excess deaths associated with COVID-19 (modelled estimates)"
}
 2022-05-10 13:31:43 2022-05-10 13:31:43 Excess Mortality Estimates – WHO (2022) 5623 Data from the WHO estimating the number of excess deaths, from all causes, during the COVID-19 pandemic for 194 countries & regions. The WHO defines excess mortality as "the mortality above what would be expected based on the non-crisis mortality rate in the population of interest". The model generates estimates for countries for which adequate input data were available for reliable inference and to then predict estimates for countries with no data available. Read more about the methodology here: https://www.who.int/publications/m/item/methods-for-estimating-the-excess-mortality-associatedwith-the-covid-19-pandemic https://www.who.int/data/sets/global-excess-deaths-associated-with-covid-19-modelled-estimates WHO Global excess deaths associated with COVID-19 (modelled estimates)

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