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 = 915 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
6725 World Health Organization (WHO) 
{
    "link": "http://www.who.int/immunization/monitoring_surveillance/data/en/",
    "retrievedDate": "15th July 2020",
    "additionalInfo": "The WHO link above has the dataset saved under point \"3.1 Reported incidence time series\". The WHO last updated this dataset on 15 July 2020 which comprises the data shown here.",
    "dataPublishedBy": "World Health Organization (2020)",
    "dataPublisherSource": "UNICEF and WHO's Joint Reporting Form (JRP) on Immunization, Vaccines and Biologicals (further explanations here: http://www.who.int/immunization/monitoring_surveillance/routine/reporting/en/)"
}
 2017-09-10 16:10:43 2017-11-15 17:09:28 Total cases of poliomyelitis virus by country and year from 1980 onwards - WHO (2020) 915 The WHO link above has the dataset saved under point "3.1 Reported incidence time series". The WHO last updated this dataset on 15 July 2020 which comprises the data shown here. http://www.who.int/immunization/monitoring_surveillance/data/en/ World Health Organization (2020)

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