owid: sources: 1 row where datasetId = 5442 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 = 5442 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
21277	Official data collated by Our World in Data	{ "additionalInfo": "By comparing the proportion of confirmed cases that result in hospital admissions, ICU admissions, and deaths, to previous waves \u2013 when the population was not vaccinated \u2013 we can learn something about the protection that vaccination has provided against severe outcomes.\n\nThis chart shows one way to do this. It visualizes the main COVID metrics relative to the peak of the last wave. The peak of the last wave happened before the population was widely vaccinated. In this representation of the data, if confirmed cases increase but hospitalizations and deaths increase to a lesser extent, it will mean that the many reported cases are leading to fewer severe forms of the disease, and fewer deaths.\n\nDifferences between countries and between waves may arise from factors such as: the number of vaccine doses administered per person; immunity from previous infections; the variants that are dominant within the population; the demographics of the population; and the demographics of people who have been vaccinated. For example, countries where the elderly and most vulnerable have been vaccinated at higher rates may have fewer severe outcomes.\n\nOur sources for these charts are:\n- Germany: <a href=\"https://github.com/robert-koch-institut/\">Robert Koch Institute</a>\n- Israel: <a href=\"https://datadashboard.health.gov.il/COVID-19/general\">Government of Israel</a>, automated via <a href=\"https://github.com/dancarmoz/israel_moh_covid_dashboard_data/\">dancarmoz on GitHub</a>\n- Spain: <a href=\"https://cnecovid.isciii.es/covid19/\">National Center for Epidemiology</a>\n- United States: <a href=\"https://covid.cdc.gov/covid-data-tracker/#trends_dailycases\">US CDC</a> and <a href=\"https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/g62h-syeh\">Department of Health & Human Services</a>", "dataPublishedBy": "Official data collated by Our World in Data" }	2022-01-10 11:40:57	2022-01-10 11:40:57	COVID-19 - Decoupling of metrics 5442	By comparing the proportion of confirmed cases that result in hospital admissions, ICU admissions, and deaths, to previous waves – when the population was not vaccinated – we can learn something about the protection that vaccination has provided against severe outcomes. This chart shows one way to do this. It visualizes the main COVID metrics relative to the peak of the last wave. The peak of the last wave happened before the population was widely vaccinated. In this representation of the data, if confirmed cases increase but hospitalizations and deaths increase to a lesser extent, it will mean that the many reported cases are leading to fewer severe forms of the disease, and fewer deaths. Differences between countries and between waves may arise from factors such as: the number of vaccine doses administered per person; immunity from previous infections; the variants that are dominant within the population; the demographics of the population; and the demographics of people who have been vaccinated. For example, countries where the elderly and most vulnerable have been vaccinated at higher rates may have fewer severe outcomes. Our sources for these charts are: - Germany: <a href="https://github.com/robert-koch-institut/">Robert Koch Institute</a> - Israel: <a href="https://datadashboard.health.gov.il/COVID-19/general">Government of Israel</a>, automated via <a href="https://github.com/dancarmoz/israel_moh_covid_dashboard_data/">dancarmoz on GitHub</a> - Spain: <a href="https://cnecovid.isciii.es/covid19/">National Center for Epidemiology</a> - United States: <a href="https://covid.cdc.gov/covid-data-tracker/#trends_dailycases">US CDC</a> and <a href="https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/g62h-syeh">Department of Health & Human Services</a>		Official data collated by Our World in Data

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