sources

Data license: CC-BY

1 row where datasetId = 5430 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "link": "https://opendata.swiss/en/dataset/covid-19-schweiz",
    "additionalInfo": "The Federal Office of Public Health publishes data on mortality by vaccination status for Switzerland and Liechtenstein, broken down by age groups.\n\nThe information on incidence is per 100,000 population, with the corresponding vaccination status of \"fully vaccinated\" and \"not vaccinated\".\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": "Federal Office of Public Health"
}

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