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 = 5414 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
21249 Department of Epidemiology, Ministry of Health, via Ministry of Science GitHub repository 
{
    "link": "https://github.com/MinCiencia/Datos-COVID19/tree/master/output/producto89",
    "additionalInfo": "Incidence of deaths according to vaccination status, age group, and epidemiological week.\n\nVaccination status is classified as \"Fully vaccinated\" for those people who have received two doses and more than 14 days have passed since their second dose, or have received a vaccine from a vaccination protocol that includes only a single dose and more than 28 days have elapsed since inoculation. This variable takes the value \"Unvaccinated or not fully vaccinated\" if people do not have a complete vaccination schedule.\n\nThe mortality rate corresponds to the incidence rate of deaths per 100,000 inhabitants for the age group, corresponding vaccination status and corresponding epidemiological week.\n\nThe mortality rate for the \"All ages\" group is age-standardized by Our World in Data, using single-year age estimates from the 2022 revision of the United Nations World Population Prospects for Chile. Rates for specific age groups are calculated as crude incidence rates.",
    "dataPublishedBy": "Ministry of Science GitHub repository"
}
 2021-11-22 14:42:24 2021-11-22 14:42:24 COVID-19 - Deaths by vaccination status - Chile 5414 Incidence of deaths according to vaccination status, age group, and epidemiological week. Vaccination status is classified as "Fully vaccinated" for those people who have received two doses and more than 14 days have passed since their second dose, or have received a vaccine from a vaccination protocol that includes only a single dose and more than 28 days have elapsed since inoculation. This variable takes the value "Unvaccinated or not fully vaccinated" if people do not have a complete vaccination schedule. The mortality rate corresponds to the incidence rate of deaths per 100,000 inhabitants for the age group, corresponding vaccination status and corresponding epidemiological week. The mortality rate for the "All ages" group is age-standardized by Our World in Data, using single-year age estimates from the 2022 revision of the United Nations World Population Prospects for Chile. Rates for specific age groups are calculated as crude incidence rates. https://github.com/MinCiencia/Datos-COVID19/tree/master/output/producto89 Ministry of Science GitHub repository

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