sources
Data license: CC-BY
1 row where datasetId = 2791 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 |
|---|---|---|---|---|---|---|---|---|
| 15528 | World Health Organization (1969-1988) | {
"link": "http://apps.who.int/iris/bitstream/10665/39485/1/9241561106.pdf",
"retrievedDate": "12 May 2018",
"additionalInfo": "Data until 1966 was compiled from relevant tables in Fenner et al. (1988)'s Chapter 8 (link above): Fenner, F., Henderson, D. A., Arita, I., Jezek, Z., Ladnyi, I. D., & World Health Organization. (1988). Smallpox and its eradication.\n\n1967 data retrieved from World Health Organization. (\u200e1969)\u200e. Weekly Epidemiological Record, 1969, vol. 44, 4 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 44 (\u200e4)\u200e, 69-88. http://apps.who.int/iris/bitstream/handle/10665/217012/WER4404.PDF?sequence=1&isAllowed=y\n1968 and 1969 data retrieved from World Health Organization. (\u200e1970)\u200e. Weekly Epidemiological Record, 1970, vol. 45, 3 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 45 (\u200e3)\u200e, 17-36. http://apps.who.int/iris/bitstream/handle/10665/217559/WER4503.PDF?sequence=1&isAllowed=y\n1970 data retrieved from World Health Organization. (\u200e1971)\u200e. Weekly Epidemiological Record, 1971, vol. 46, 51 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 46 (\u200e51)\u200e, 521-532. http://apps.who.int/iris/bitstream/handle/10665/218642/WER4651.PDF?sequence=1&isAllowed=y\n1971 data retrieved from World Health Organization. (\u200e1972)\u200e. Weekly Epidemiological Record, 1972, vol. 47, 26 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 47 (\u200e26)\u200e, 249-256. http://apps.who.int/iris/bitstream/handle/10665/218953/WER4726.PDF?sequence=1&isAllowed=y\n1972 data retrieved from World Health Organization. (\u200e1974)\u200e. Weekly Epidemiological Record, 1974, vol. 49, 2 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 49 (\u200e2)\u200e, 9-24. http://apps.who.int/iris/bitstream/handle/10665/219695/WER4902.PDF?sequence=1&isAllowed=y\n1973 and 1974 data retrieved from World Health Organization. (\u200e1975)\u200e. Table 5 Smallpox Surveillance. http://apps.who.int/iris/bitstream/handle/10665/220183/WER5003_21-22.PDF?sequence=1&isAllowed=y\n1975 data retrieved from World Health Organization. (\u200e1976)\u200e. Smallpox surveillance End of Year 1975 summary. http://apps.who.int/iris/bitstream/handle/10665/220670/WER5103_9-18.PDF?sequence=1&isAllowed=y\n1976 data retrieved from World Health Organization. (\u200e1977)\u200e. Weekly Epidemiological Record, 1977, vol. 52, 2 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 52 (\u200e2)\u200e, 9-20. http://apps.who.int/iris/bitstream/handle/10665/221189/WER5202.PDF?sequence=1&isAllowed=y\n1977 data retrieved from World Health Organization. (\u200e1978)\u200e. Weekly Epidemiological Record, 1978, vol. 53, 2 [\u200efull issue]\u200e. Weekly Epidemiological Record = Relev\u00e9 \u00e9pid\u00e9miologique hebdomadaire, 52 (\u200e2)\u200e, 9-20. http://apps.who.int/iris/bitstream/handle/10665/221687/WER5302.PDF?sequence=1&isAllowed=y\n\nSome data cleaning was performed: \nEast Pakistan was changed into Bangladesh and West Pakistan was changed into Pakistan. \nUpper Volta was changed into Burkina Faso, Southern Rhodesia to Zimbabwe, Ceylon to Sri Lanka but Dahomey (a region in today's Nigeria) was left as it is. \nFor all countries that approached zero cases and then were not included in the Weekly Epidemiological Record (WER) anymore subsequently were assumed to have zero cases. This was done for 1967-1977. ",
"dataPublishedBy": "Fenner et al. (1988) and various Weekly Epidemiological Records",
"dataPublisherSource": "World Health Organization"
} |
2018-05-12 12:25:35 | 2018-06-08 08:00:13 | Smallpox cases by country 1920-1977 2791 | Data until 1966 was compiled from relevant tables in Fenner et al. (1988)'s Chapter 8 (link above): Fenner, F., Henderson, D. A., Arita, I., Jezek, Z., Ladnyi, I. D., & World Health Organization. (1988). Smallpox and its eradication. 1967 data retrieved from World Health Organization. (1969). Weekly Epidemiological Record, 1969, vol. 44, 4 [full issue]. Weekly Epidemiological Record = Relevé épidémiologique hebdomadaire, 44 (4), 69-88. http://apps.who.int/iris/bitstream/handle/10665/217012/WER4404.PDF?sequence=1&isAllowed=y 1968 and 1969 data retrieved from World Health Organization. (1970). Weekly Epidemiological Record, 1970, vol. 45, 3 [full issue]. Weekly Epidemiological Record = Relevé épidémiologique hebdomadaire, 45 (3), 17-36. http://apps.who.int/iris/bitstream/handle/10665/217559/WER4503.PDF?sequence=1&isAllowed=y 1970 data retrieved from World Health Organization. (1971). Weekly Epidemiological Record, 1971, vol. 46, 51 [full issue]. Weekly Epidemiological Record = Relevé épidémiologique hebdomadaire, 46 (51), 521-532. http://apps.who.int/iris/bitstream/handle/10665/218642/WER4651.PDF?sequence=1&isAllowed=y 1971 data retrieved from World Health Organization. (1972). Weekly Epidemiological Record, 1972, vol. 47, 26 [full issue]. Weekly Epidemiological Record = Relevé épidémiologique hebdomadaire, 47 (26), 249-256. http://apps.who.int/iris/bitstream/handle/10665/218953/WER4726.PDF?sequence=1&isAllowed=y 1972 data retrieved from World Health Organization. (1974). Weekly Epidemiological Record, 1974, vol. 49, 2 [full issue]. Weekly Epidemiological Record = Relevé épidémiologique hebdomadaire, 49 (2), 9-24. http://apps.who.int/iris/bitstream/handle/10665/219695/WER4902.PDF?sequence=1&isAllowed=y 1973 and 1974 data retrieved from World Health Organization. (1975). Table 5 Smallpox Surveillance. http://apps.who.int/iris/bitstream/handle/10665/220183/WER5003_21-22.PDF?sequence=1&isAllowed=y 1975 data retrieved from World Health Organization. (1976). Smallpox surveillance End o… | http://apps.who.int/iris/bitstream/10665/39485/1/9241561106.pdf | Fenner et al. (1988) and various Weekly Epidemiological Records |
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");