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 = 5740 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
26738 WHO and UNICEF (2021) 
{
    "link": "https://immunizationdata.who.int/listing.html?topic=vaccine-schedule&location=",
    "retrievedDate": "2022-08-25",
    "additionalInfo": "This dataset shows vaccines that are administered through national immunization schedules: where countries provide and recommend vaccines through routine services. This does not mean all children are vaccinated \u2013\u00a0countries vary in their vaccination coverage. \n\nThe category 'Not routinely administered' does not necessarily mean the vaccines are unavailable \u2013\u00a0they may be optional or available commercially, but they are not included in the national immunization schedule.\n\nhttps://immunizationdata.who.int/pages/indicators-by-category/new_and_under_utilized_vaccines_introduction.html\n\nThis dataset should be next updated by the source by November 2022. We will update it on Our World in Data soon after the new version is published. At the link above you can directly access the source page and see the latest available data.",
    "dataPublishedBy": "WHO/UNICEF Joint Reporting Form on Immunization (JRF), WHO Regional and Country offices",
    "dataPublisherSource": "National immunization programme"
}
 2022-08-26 09:08:42 2022-08-26 09:08:42 WHO Vaccination Schedule (2021) 5740 This dataset shows vaccines that are administered through national immunization schedules: where countries provide and recommend vaccines through routine services. This does not mean all children are vaccinated – countries vary in their vaccination coverage. The category 'Not routinely administered' does not necessarily mean the vaccines are unavailable – they may be optional or available commercially, but they are not included in the national immunization schedule. https://immunizationdata.who.int/pages/indicators-by-category/new_and_under_utilized_vaccines_introduction.html This dataset should be next updated by the source by November 2022. We will update it on Our World in Data soon after the new version is published. At the link above you can directly access the source page and see the latest available data. https://immunizationdata.who.int/listing.html?topic=vaccine-schedule&location= WHO/UNICEF Joint Reporting Form on Immunization (JRF), WHO Regional and Country offices

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