variables
Data license: CC-BY
13 rows where sourceId = 30201 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, updatedAt, timespan, display, type, createdAt (date), updatedAt (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
541223 | cum_excess_per_million_proj_all_ages | The cumulative number of excess deaths per million people in the population; cumulated starting 1 January 2020 | 2023-01-30 22:11:39 | 2024-07-31 06:33:58 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | { "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | cum_excess_per_million_proj_all_ages | grapher/excess_mortality/latest/excess_mortality/excess_mortality#cum_excess_per_million_proj_all_ages | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
12307c9371365c5ceec774654026af5d | 93b7fa655c628fb1df7b3d967f120cb0 | |||||||||||||||||||
541222 | excess_per_million_proj_all_ages | The number of excess deaths per million people in the population; calculated as reported deaths minus projected deaths | 2023-01-30 22:11:37 | 2024-07-31 06:33:58 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | { "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | excess_per_million_proj_all_ages | grapher/excess_mortality/latest/excess_mortality/excess_mortality#excess_per_million_proj_all_ages | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
be89472bd09a6537d0dfaf1c78e1ec10 | 69315145366a48a57afc383c07a0d923 | |||||||||||||||||||
541221 | cum_p_proj_all_ages | % | Cumulative P-scores using projected baseline for all ages | 2023-01-30 22:11:37 | 2024-07-31 06:33:58 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Excess mortality cumulative P-scores, projected baseline, all ages", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | cum_p_proj_all_ages | grapher/excess_mortality/latest/excess_mortality/excess_mortality#cum_p_proj_all_ages | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
4943cae12573814f768ed7da29031a2b | 28a39b54bec95a3b1a83219924327f43 | |||||||||||||||||
541219 | cum_excess_proj_all_ages | The cumulative number of excess deaths; cumulated starting 1 January 2020 | 2023-01-30 22:11:37 | 2024-07-31 06:33:58 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | { "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | cum_excess_proj_all_ages | grapher/excess_mortality/latest/excess_mortality/excess_mortality#cum_excess_proj_all_ages | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
b27f5f5b9e6f07a93e64444174936feb | 8dce47ddeb8a6e43ca27ad598f80cf7a | |||||||||||||||||||
541209 | excess_proj_all_ages | The number of excess deaths; calculated as reported deaths minus projected deaths. | 2023-01-30 22:11:33 | 2024-07-31 06:33:56 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | { "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | excess_proj_all_ages | grapher/excess_mortality/latest/excess_mortality/excess_mortality#excess_proj_all_ages | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
8db673fc40d327cc9008a1b025b09f8b | 4c0a9a6180d29bfe6716c74be54ef513 | |||||||||||||||||||
541208 | p_proj_all_ages | % | P-scores using projected baseline for all ages | 2023-01-30 22:11:33 | 2024-07-31 06:33:56 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Excess mortality P-scores, projected baseline, all ages.", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | p_proj_all_ages | grapher/excess_mortality/latest/excess_mortality/excess_mortality#p_proj_all_ages | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
720ff64ec60c5b252c6a612472b6a48a | 7fb457d0cbc7fde1ea3f97d8e8f4f38e | |||||||||||||||||
541207 | p_proj_85p | % | P-scores using projected baseline for ages 85 and above. | 2023-01-30 22:11:33 | 2024-07-31 06:33:55 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Ages 85+", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | p_proj_85p | grapher/excess_mortality/latest/excess_mortality/excess_mortality#p_proj_85p | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
25b67894b9fa85f7f48cfe47dc5204fe | a241333eb685a26c3bc9fbe8f2923cb9 | |||||||||||||||||
541206 | p_proj_75_84 | % | P-scores using projected baseline for ages 75–84. | 2023-01-30 22:11:33 | 2024-07-31 06:33:55 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Ages 75\u201384", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | p_proj_75_84 | grapher/excess_mortality/latest/excess_mortality/excess_mortality#p_proj_75_84 | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
f18414a57ed59359c8b1db8d32a50101 | 588fd3e4bace7f9c852b101ba8af51ff | |||||||||||||||||
541205 | p_proj_65_74 | % | P-scores using projected baseline for ages 65–74. | 2023-01-30 22:11:33 | 2024-07-31 06:33:55 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Ages 65\u201374", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | p_proj_65_74 | grapher/excess_mortality/latest/excess_mortality/excess_mortality#p_proj_65_74 | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
6938a5f996c8f36c97d0fc63514eafd3 | 458c36b8905fd5845d1d5bae6d929a7f | |||||||||||||||||
541204 | p_proj_15_64 | % | P-scores using projected baseline for ages 15–64. | 2023-01-30 22:11:33 | 2024-07-31 06:33:55 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Ages 15\u201364", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | p_proj_15_64 | grapher/excess_mortality/latest/excess_mortality/excess_mortality#p_proj_15_64 | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
24b03463d0b2f457309e8b4dc6328512 | 668f674348aed8427cca9028382b0722 | |||||||||||||||||
541203 | p_proj_0_14 | % | P-scores using projected baseline for ages 0–14. | 2023-01-30 22:11:33 | 2024-07-31 06:33:55 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | % | { "name": "Ages 0\u201314", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | p_proj_0_14 | grapher/excess_mortality/latest/excess_mortality/excess_mortality#p_proj_0_14 | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
float | [] |
44e8e120151a9846a022a33f2c6cd682 | 9aa2e5dff0c7f85a496ce92ae2630dd0 | |||||||||||||||||
541195 | Time unit | Denotes whether the “time” column values are weekly or monthly | 2023-01-30 22:11:28 | 2024-07-31 06:33:53 | 4-1826 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | { "includeInTable": true } |
0 | time_unit | grapher/excess_mortality/latest/excess_mortality/excess_mortality#time_unit | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
string | [] |
7bd1ee9dc91475d046daac8a2f5aba46 | 908bc831f7ad8bf112320a6e0b19ae28 | ||||||||||||||||||
541193 | Time | The week or month number in the year | 2023-01-30 22:11:28 | 2024-07-31 06:33:53 | 4-1826 | Excess Mortality (various sources) 5874 | Human Mortality Database (2024); World Mortality Dataset (2024); Karlinsky and Kobak (2021) 30201 | { "includeInTable": true } |
0 | time | grapher/excess_mortality/latest/excess_mortality/excess_mortality#time | 1 | [] |
[ { "url": "https://www.mortality.org/Data/UserAgreement", "name": "Creative Commons BY 4.0" }, { "url": "https://github.com/akarlinsky/world_mortality/blob/main/LICENSE", "name": "MIT License" }, { "url": "https://github.com/dkobak/excess-mortality/blob/main/LICENSE", "name": "GPL-3.0" } ] |
int | [] |
9c0266c116523dce0768f3552e762a1a | 69a266773f5ca2972079ceaa80c3f837 |
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");