sources
Data license: CC-BY
2 rows where datasetId = 6025 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
30135 | World Health Organization (2023) | { "link": null, "retrievedDate": "2023-05-31", "additionalInfo": "", "dataPublishedBy": "World Health Organization" } |
2024-02-26 22:53:09 | 2024-07-08 16:31:23 | Cholera reported cases, deaths and case fatality rate (WHO, 2023) 6025 | World Health Organization | ||
27652 | World Health Organization (2023) | { "link": null, "retrievedDate": "2023-05-31", "additionalInfo": "The data is created by combining multiple WHO Weekly Epidemiological Reports for cholera reported cases, deaths and case fatality rate.\n\nThe reports for the years 2017-2021 can be found at:\n\n2017: https://web.archive.org/web/20230328164426/https://apps.who.int/iris/bitstream/handle/10665/274655/WER9338-489-497.pdf?sequence=1&isAllowed=y\n\n2018: https://web.archive.org/web/20230601084841/https://apps.who.int/iris/bitstream/handle/10665/330005/WER9448-561-568-eng-fre.pdf?sequence=1&isAllowed=y\n\n2019: https://web.archive.org/web/20221007234707/http://apps.who.int/iris/bitstream/handle/10665/334242/WER9537-441-448-eng-fre.pdf?sequence=1&isAllowed=y\n\n2020: https://web.archive.org/web/20230326231135/http://apps.who.int/iris/bitstream/handle/10665/345271/WER9637-445-454-eng-fre.pdf?sequence=1&isAllowed=y\n\n2021: https://web.archive.org/web/20230526223955/https://apps.who.int/iris/bitstream/handle/10665/362858/WER9737-453-464-eng-fre.pdf?sequence=1&isAllowed=y", "dataPublishedBy": "World Health Organization" } |
2023-06-01 09:19:51 | 2024-07-08 16:31:23 | Cholera reported cases, deaths and case fatality rate (WHO, 2023) 6025 | The data is created by combining multiple WHO Weekly Epidemiological Reports for cholera reported cases, deaths and case fatality rate. The reports for the years 2017-2021 can be found at: 2017: https://web.archive.org/web/20230328164426/https://apps.who.int/iris/bitstream/handle/10665/274655/WER9338-489-497.pdf?sequence=1&isAllowed=y 2018: https://web.archive.org/web/20230601084841/https://apps.who.int/iris/bitstream/handle/10665/330005/WER9448-561-568-eng-fre.pdf?sequence=1&isAllowed=y 2019: https://web.archive.org/web/20221007234707/http://apps.who.int/iris/bitstream/handle/10665/334242/WER9537-441-448-eng-fre.pdf?sequence=1&isAllowed=y 2020: https://web.archive.org/web/20230326231135/http://apps.who.int/iris/bitstream/handle/10665/345271/WER9637-445-454-eng-fre.pdf?sequence=1&isAllowed=y 2021: https://web.archive.org/web/20230526223955/https://apps.who.int/iris/bitstream/handle/10665/362858/WER9737-453-464-eng-fre.pdf?sequence=1&isAllowed=y | World Health Organization |
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");