variables
Data license: CC-BY
4 rows where datasetId = 6581 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, description, timespan, display, descriptionShort, descriptionFromProducer, descriptionProcessing, type, sort, createdAt (date), updatedAt (date), sort (array)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 943086 | Reported cases of guinea worm disease in humans | cases | Reported cases of guinea worm disease (Dracunculiasis) as recorded by WHO. For Cameroon, Central African Republic, Cote d'Ivoire, Mauritania, Senegal and Yemen data is gathered from: 1986-2017: https://web.archive.org/web/20220208133814/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_i2.html 2018: Table 1a: https://web.archive.org/web/20230629130727/https://apps.who.int/iris/bitstream/handle/10665/324786/WER9420-233-251.pdf?sequence=1&isAllowed=y 2019: Table 1a: https://web.archive.org/web/20230629130619/https://apps.who.int/iris/bitstream/handle/10665/332086/WER9520-209-227-eng-fre.pdf?sequence=1&isAllowed=y 2020: Table 1a: https://web.archive.org/web/20230226162934/https://apps.who.int/iris/bitstream/handle/10665/341529/WER9621-173-194-eng-fre.pdf?sequence=1&isAllowed=y 2021: Table 1a: https://web.archive.org/web/20230226163027/https://apps.who.int/iris/bitstream/handle/10665/354576/WER9721-22-225-247-eng-fre.pdf?sequence=1&isAllowed=y 2022: Table 1a: https://web.archive.org/web/20230629124651/https://apps.who.int/iris/bitstream/handle/10665/367924/WER9820-205-224.pdf?sequence=1&isAllowed=y For all other countries data is gathered from the following sources: 1980-2020: https://www.who.int/teams/control-of-neglected-tropical-diseases/dracunculiasis/dracunculiasis-eradication-portal 2021: Table 1a: https://web.archive.org/web/20230226163027/https://apps.who.int/iris/bitstream/handle/10665/354576/WER9721-22-225-247-eng-fre.pdf?sequence=1&isAllowed=y 2022: Table 1a: https://web.archive.org/web/20230629124651/https://apps.who.int/iris/bitstream/handle/10665/367924/WER9820-205-224.pdf?sequence=1&isAllowed=y Global totals are calculated yearly as the sum of the number of reported cases in each country. | 2024-06-25 09:06:35 | 2024-07-08 16:38:18 | 1980-2023 | Guinea worm reported cases and certification (WHO) 6581 | World Health Organization 30791 | {
"unit": "cases",
"numDecimalPlaces": 0
} |
0 | guinea_worm_reported_cases | grapher/who/2024-06-17/guinea_worm/guinea_worm#guinea_worm_reported_cases | 2 | major | WHO | World Health Organization (2024) | Reported cases of guinea worm disease (Dracunculiasis) as recorded by the WHO. | A case of guinea-worm disease is a person exhibiting a skin lesion with emergence of a Guinea worm, and in which the worm is confirmed in laboratory tests to be D. medinensis. That person is counted as a case only once during the calendar year, i.e. when the first worm emerges from that person. | [] |
For Cameroon, Central African Republic, Cote d'Ivoire, Mauritania, Senegal and Yemen the data is from: 1986-2017: https://web.archive.org/web/20220208133814/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_i2.html 2018: Table 1a: https://web.archive.org/web/20230629130727/https://apps.who.int/iris/bitstream/handle/10665/324786/WER9420-233-251.pdf?sequence=1&isAllowed=y 2019: Table 1a: https://web.archive.org/web/20230629130619/https://apps.who.int/iris/bitstream/handle/10665/332086/WER9520-209-227-eng-fre.pdf?sequence=1&isAllowed=y 2020: Table 1a: https://web.archive.org/web/20230226162934/https://apps.who.int/iris/bitstream/handle/10665/341529/WER9621-173-194-eng-fre.pdf?sequence=1&isAllowed=y 2021: Table 1a: https://web.archive.org/web/20230226163027/https://apps.who.int/iris/bitstream/handle/10665/354576/WER9721-22-225-247-eng-fre.pdf?sequence=1&isAllowed=y 2022: Table 1a: https://web.archive.org/web/20230629124651/https://apps.who.int/iris/bitstream/handle/10665/367924/WER9820-205-224.pdf?sequence=1&isAllowed=y For all other countries we gathered data from the following sources: 1980-2020: https://www.who.int/teams/control-of-neglected-tropical-diseases/dracunculiasis/dracunculiasis-eradication-portal 2021: Table 1a: https://web.archive.org/web/20230226163027/https://apps.who.int/iris/bitstream/handle/10665/354576/WER9721-22-225-247-eng-fre.pdf?sequence=1&isAllowed=y 2022: Table 1a: https://web.archive.org/web/20230629124651/https://apps.who.int/iris/bitstream/handle/10665/367924/WER9820-205-224.pdf?sequence=1&isAllowed=y 2023: Table 1a: https://iris.who.int/bitstream/handle/10665/376790/WER9920-249-269.pdf?sequence=1 We calculate global totals as the sum of the number of reported cases in each country. | int | [] |
33f81dc1909985dbf5a9e72464d02ae2 | dd52bb7f403f34f11cb4eae4ad7db061 | ||||||||||||
| 943085 | Certification status over time | The current and historical values for the status of Guinea worm disease (Dracunculiasis) as certified by the WHO. To be certified as free of guinea worm disease, a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. Data regarding certification status is taken from: https://web.archive.org/web/20211024081702/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_t0.html This is supplmented with more recent changes to Guinea worm disease certification: - Angola has had endemic status since 2020: https://www.who.int/news/item/23-09-2020-eradicating-dracunculiasis-human-cases-and-animal-infections-decline-as-angola-becomes-endemic - Kenya was certified guinea worm free in 2018: https://www.who.int/news/item/21-03-2018-dracunculiasis-eradication-south-sudan-claims-interruption-of-transmission-in-humans - DRC was certified guinea worm free in 2022: https://www.who.int/news/item/15-12-2022-the-democratic-republic-of-the-congo-certified-free-of-dracunculiasis-transmission-by-who | 2024-06-25 09:06:35 | 2024-07-08 16:38:18 | 1996-2023 | Guinea worm reported cases and certification (WHO) 6581 | World Health Organization 30791 | {} |
0 | certification_status | grapher/who/2024-06-17/guinea_worm/guinea_worm#certification_status | 2 | major | WHO | World Health Organization (2024) | The current and historical values for the status of [Guinea worm disease (Dracunculiasis)](#dod:guinea-worm) as certified by the WHO. To be certified as free of guinea worm disease, a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. | Elimination of [dracunculiasis[(#dod:guinea-worm)] is the confirmed absence of the emergence of adult female worms (the interruption of transmission of Dracunculus medinensis) in humans and animals for three consecutive years or longer from a country with such a low risk of reintroduction of the parasite that preventive measures could be reduced to a strict minimum. | [] |
The current and historical values for the status of Guinea worm disease (Dracunculiasis) as certified by the WHO. To be certified as free of guinea worm disease, a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. Data regarding certification status is available at the WHO: https://web.archive.org/web/20211024081702/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_t0.html We have added the recent changes to Guinea worm disease certification: - Angola has had endemic statuss since 2020: https://www.who.int/news/item/23-09-2020-eradicating-dracunculiasis-human-cases-and-animal-infections-decline-as-angola-becomes-endemic - Kenya was certified guinea worm free in 2018: https://www.who.int/news/item/21-03-2018-dracunculiasis-eradication-south-sudan-claims-interruption-of-transmission-in-humans - DRC was certified guinea worm free in 2022: https://www.who.int/news/item/15-12-2022-the-democratic-republic-of-the-congo-certified-free-of-dracunculiasis-transmission-by-who | string | [] |
623905202ea703922c550aef6239d002 | 906c4c7b98a92b4fc7cc9377f7854d48 | |||||||||||||
| 943084 | Time country was certified free of guinea worm disease or status of certification | 2024-06-25 09:06:35 | 2024-07-08 16:38:18 | 2023-2023 | Guinea worm reported cases and certification (WHO) 6581 | World Health Organization 30791 | {} |
0 | time_frame_certified | grapher/who/2024-06-17/guinea_worm/guinea_worm#time_frame_certified | 2 | major | WHO | World Health Organization (2024) | To be certified as free of [Guinea worm disease (Dracunculiasis)](#dod:guinea-worm), a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. | Elimination of [dracunculiasis[(#dod:guinea-worm)] is the confirmed absence of the emergence of adult female worms (the interruption of transmission of Dracunculus medinensis) in humans and animals for three consecutive years or longer from a country with such a low risk of reintroduction of the parasite that preventive measures could be reduced to a strict minimum. | [] |
The current and historical values for the status of Guinea worm disease (Dracunculiasis) as certified by the WHO. To be certified as free of guinea worm disease, a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. Data regarding certification status is available at the WHO: https://web.archive.org/web/20211024081702/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_t0.html We have added the recent changes to Guinea worm disease certification: - Angola has had endemic statuss since 2020: https://www.who.int/news/item/23-09-2020-eradicating-dracunculiasis-human-cases-and-animal-infections-decline-as-angola-becomes-endemic - Kenya was certified guinea worm free in 2018: https://www.who.int/news/item/21-03-2018-dracunculiasis-eradication-south-sudan-claims-interruption-of-transmission-in-humans - DRC was certified guinea worm free in 2022: https://www.who.int/news/item/15-12-2022-the-democratic-republic-of-the-congo-certified-free-of-dracunculiasis-transmission-by-who | ordinal | [
"1997-1999",
"2000s",
"2010s",
"2020s",
"Pre-certification",
"Endemic"
] |
61cd10d6cbe0bc55bb4fa013e52405b1 | b0279e8a355bb66a5478582cadd500d9 | ||||||||||||||
| 943083 | Year country was certified free of guinea worm disease | The current and historical values for the status of Guinea worm disease (Dracunculiasis) as certified by the WHO. To be certified as free of guinea worm disease, a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. Data regarding certification status is taken from: https://web.archive.org/web/20211024081702/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_t0.html This is supplmented with more recent changes to Guinea worm disease certification: - Angola has had endemic status since 2020: https://www.who.int/news/item/23-09-2020-eradicating-dracunculiasis-human-cases-and-animal-infections-decline-as-angola-becomes-endemic - Kenya was certified guinea worm free in 2018: https://www.who.int/news/item/21-03-2018-dracunculiasis-eradication-south-sudan-claims-interruption-of-transmission-in-humans - DRC was certified guinea worm free in 2022: https://www.who.int/news/item/15-12-2022-the-democratic-republic-of-the-congo-certified-free-of-dracunculiasis-transmission-by-who | 2024-06-25 09:06:35 | 2024-07-08 16:38:18 | 2023-2023 | Guinea worm reported cases and certification (WHO) 6581 | World Health Organization 30791 | {
"numDecimalPlaces": 0
} |
0 | year_certified | grapher/who/2024-06-17/guinea_worm/guinea_worm#year_certified | 2 | major | WHO | World Health Organization (2024) | To be certified as free of [Guinea worm disease (Dracunculiasis)](#dod:guinea-worm), a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. | Elimination of dracunculiasis is the confirmed absence of the emergence of adult female worms (the interruption of transmission of Dracunculus medinensis) in humans and animals for three consecutive years or longer from a country with such a low risk of reintroduction of the parasite that preventive measures could be reduced to a strict minimum. | [] |
The current and historical values for the status of Guinea worm disease (Dracunculiasis) as certified by the WHO. To be certified as free of guinea worm disease, a country must have reported zero indigenous cases through active surveillance for at least three consecutive years. Data regarding certification status is available at the WHO: https://web.archive.org/web/20211024081702/https://apps.who.int/dracunculiasis/dradata/html/report_Countries_t0.html We have added the recent changes to Guinea worm disease certification: - Angola has had endemic statuss since 2020: https://www.who.int/news/item/23-09-2020-eradicating-dracunculiasis-human-cases-and-animal-infections-decline-as-angola-becomes-endemic - Kenya was certified guinea worm free in 2018: https://www.who.int/news/item/21-03-2018-dracunculiasis-eradication-south-sudan-claims-interruption-of-transmission-in-humans - DRC was certified guinea worm free in 2022: https://www.who.int/news/item/15-12-2022-the-democratic-republic-of-the-congo-certified-free-of-dracunculiasis-transmission-by-who | int | [] |
0e877022e63f0896e2e6aa5880fb0afc | 512311e4d20228a4ad095f0ac5faa6b4 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");