Changes
On March 3, 2021, 11:49:44 (SAST), wasim:
-
Updated description of resource ft_excess_deaths.csv in Financial Times - Excess mortality during COVID-19 pandemic from
## Data Dictionary ## + country + region + period + year + month + week + date + deaths + expected_deaths + excess_deaths + excess_deaths_pct
to## Data Dictionary ## ## Data Dictionary ## + country - the country to which the data applies + region - where applicable, the subnational or administrative region. This duplicated country for national-level data + period - the period for which the data is collected. This can be “week” or “month” data reported daily has been aggregated into weeks + year - the year within which the period ends. The is the same as the year element of the date field. + month - the month within which the period ends. This is the same as the month element of the date field. + week - week number is either taken exactly from countries’ own data, or is calculated using the following method for countries reporting daily data, we take the most recent run of seven days in the data to be the most recent week, and then aggregate each prior seven-day run into a new week, with any trailing period fewer than seven days at the start of January clipped off + date - the date at which the week ends + deaths - historical daily, weekly or monthly numbers of all-cause deaths for as far back as we have been able to obtain this data + expected_deaths - the median value of this data for the equivalent period in years from 2015 to 2019 + excess_deaths - the difference between deaths and expected deaths (negative values indicate fewer deaths than the recent historical average) + excess_deaths_pct - excess_deaths as a percentage of expected_deaths
f | 1 | { | f | 1 | { |
2 | "author": "HERA - Humanitarian Emergency Response Africa", | 2 | "author": "HERA - Humanitarian Emergency Response Africa", | ||
3 | "author_email": "", | 3 | "author_email": "", | ||
4 | "creator_user_id": "34f7a594-935e-4ac6-b13c-8bb3b861b487", | 4 | "creator_user_id": "34f7a594-935e-4ac6-b13c-8bb3b861b487", | ||
5 | "extras": [], | 5 | "extras": [], | ||
6 | "groups": [], | 6 | "groups": [], | ||
7 | "id": "08816e77-a136-42bd-a2cd-b36b072139e4", | 7 | "id": "08816e77-a136-42bd-a2cd-b36b072139e4", | ||
8 | "isopen": true, | 8 | "isopen": true, | ||
9 | "license_id": "cc-by", | 9 | "license_id": "cc-by", | ||
10 | "license_title": "Creative Commons Attribution", | 10 | "license_title": "Creative Commons Attribution", | ||
11 | "license_url": "http://www.opendefinition.org/licenses/cc-by", | 11 | "license_url": "http://www.opendefinition.org/licenses/cc-by", | ||
12 | "maintainer": "HERA - Humanitarian Emergency Response Africa", | 12 | "maintainer": "HERA - Humanitarian Emergency Response Africa", | ||
13 | "maintainer_email": "", | 13 | "maintainer_email": "", | ||
14 | "metadata_created": "2021-03-03T09:17:32.521256", | 14 | "metadata_created": "2021-03-03T09:17:32.521256", | ||
n | 15 | "metadata_modified": "2021-03-03T09:26:20.578619", | n | 15 | "metadata_modified": "2021-03-03T09:49:44.271349", |
16 | "name": "financial-times-excess-mortality-during-covid-19-pandemic", | 16 | "name": "financial-times-excess-mortality-during-covid-19-pandemic", | ||
17 | "notes": "This dataset contains excess mortality data for the period | 17 | "notes": "This dataset contains excess mortality data for the period | ||
18 | covering the 2020 Covid-19 pandemic.\r\n\r\nThe data contains the | 18 | covering the 2020 Covid-19 pandemic.\r\n\r\nThe data contains the | ||
19 | excess mortality data for all known jurisdictions which publish | 19 | excess mortality data for all known jurisdictions which publish | ||
20 | all-cause mortality data meeting the following criteria:\r\n\r\n+ | 20 | all-cause mortality data meeting the following criteria:\r\n\r\n+ | ||
21 | daily, weekly or monthly level of granularity\r\n+ includes equivalent | 21 | daily, weekly or monthly level of granularity\r\n+ includes equivalent | ||
22 | historical data for at least one full year before 2020, and preferably | 22 | historical data for at least one full year before 2020, and preferably | ||
23 | at least five years (2015-2019)\r\n+ includes data up to at least | 23 | at least five years (2015-2019)\r\n+ includes data up to at least | ||
24 | April 1, 2020\r\n\r\nMost countries publish mortality data with a | 24 | April 1, 2020\r\n\r\nMost countries publish mortality data with a | ||
25 | longer periodicity (typically quarterly or even annually), a longer | 25 | longer periodicity (typically quarterly or even annually), a longer | ||
26 | publication lag time, or both. This sort of data is not suitable for | 26 | publication lag time, or both. This sort of data is not suitable for | ||
27 | ongoing analysis during an epidemic and is therefore not included | 27 | ongoing analysis during an epidemic and is therefore not included | ||
28 | here.\r\n\r\n\"Excess mortality\" refers to the difference between | 28 | here.\r\n\r\n\"Excess mortality\" refers to the difference between | ||
29 | deaths from all causes during the pandemic and the historic seasonal | 29 | deaths from all causes during the pandemic and the historic seasonal | ||
30 | average. For many of the jurisdictions shown here, this figure is | 30 | average. For many of the jurisdictions shown here, this figure is | ||
31 | higher than the official Covid-19 fatalities that are published by | 31 | higher than the official Covid-19 fatalities that are published by | ||
32 | national governments each day. While not all of these deaths are | 32 | national governments each day. While not all of these deaths are | ||
33 | necessarily attributable to the disease, it does leave a number of | 33 | necessarily attributable to the disease, it does leave a number of | ||
34 | unexplained deaths that suggests that the official figures of deaths | 34 | unexplained deaths that suggests that the official figures of deaths | ||
35 | attributed may significantly undercount the pandemic's | 35 | attributed may significantly undercount the pandemic's | ||
36 | impact.\r\n\r\nThe data has been gathered from national, regional or | 36 | impact.\r\n\r\nThe data has been gathered from national, regional or | ||
37 | municipal agencies that collect death registrations and publish | 37 | municipal agencies that collect death registrations and publish | ||
38 | official mortality statistics. These original data were reshaped into | 38 | official mortality statistics. These original data were reshaped into | ||
39 | a standardised format by Financial Times journalists to allow | 39 | a standardised format by Financial Times journalists to allow | ||
40 | cross-national comparisons, and have been used to inform the FT\u2019s | 40 | cross-national comparisons, and have been used to inform the FT\u2019s | ||
41 | reporting on the pandemic. ", | 41 | reporting on the pandemic. ", | ||
42 | "num_resources": 2, | 42 | "num_resources": 2, | ||
43 | "num_tags": 3, | 43 | "num_tags": 3, | ||
44 | "organization": { | 44 | "organization": { | ||
45 | "approval_status": "approved", | 45 | "approval_status": "approved", | ||
46 | "created": "2021-02-15T10:09:07.942828", | 46 | "created": "2021-02-15T10:09:07.942828", | ||
47 | "description": "Humanitarian Emergency Response Africa Datasets", | 47 | "description": "Humanitarian Emergency Response Africa Datasets", | ||
48 | "id": "4607d385-0a0b-4fd9-a553-cc650210c096", | 48 | "id": "4607d385-0a0b-4fd9-a553-cc650210c096", | ||
49 | "image_url": | 49 | "image_url": | ||
50 | "2021-02-15-100907.924510Humanitarian-Emergency-Response-Africa.png", | 50 | "2021-02-15-100907.924510Humanitarian-Emergency-Response-Africa.png", | ||
51 | "is_organization": true, | 51 | "is_organization": true, | ||
52 | "name": "humanitarian-emergency-response-africa", | 52 | "name": "humanitarian-emergency-response-africa", | ||
53 | "revision_id": "64885bd9-e97a-4fb7-b0c1-e8753cf2b2ac", | 53 | "revision_id": "64885bd9-e97a-4fb7-b0c1-e8753cf2b2ac", | ||
54 | "state": "active", | 54 | "state": "active", | ||
55 | "title": "Humanitarian Emergency Response Africa", | 55 | "title": "Humanitarian Emergency Response Africa", | ||
56 | "type": "organization" | 56 | "type": "organization" | ||
57 | }, | 57 | }, | ||
58 | "owner_org": "4607d385-0a0b-4fd9-a553-cc650210c096", | 58 | "owner_org": "4607d385-0a0b-4fd9-a553-cc650210c096", | ||
59 | "private": false, | 59 | "private": false, | ||
60 | "relationships_as_object": [], | 60 | "relationships_as_object": [], | ||
61 | "relationships_as_subject": [], | 61 | "relationships_as_subject": [], | ||
62 | "resources": [ | 62 | "resources": [ | ||
63 | { | 63 | { | ||
64 | "cache_last_updated": null, | 64 | "cache_last_updated": null, | ||
65 | "cache_url": null, | 65 | "cache_url": null, | ||
66 | "created": "2021-03-03T09:20:24.149682", | 66 | "created": "2021-03-03T09:20:24.149682", | ||
67 | "datastore_active": false, | 67 | "datastore_active": false, | ||
n | 68 | "description": "## Data Dictionary ##\r\n\r\n+ country\r\n+ | n | 68 | "description": "## Data Dictionary ##\r\n\r\n## Data Dictionary |
69 | region \r\n+ period\r\n+ year \r\n+ month \r\n+ week\r\n+ date \r\n+ | 69 | ##\r\n\r\n+ country\t- the country to which the data applies\r\n+ | ||
70 | deaths\r\n+ expected_deaths\r\n+ excess_deaths\r\n+ | 70 | region - where applicable, the subnational or administrative region. | ||
71 | excess_deaths_pct", | 71 | This duplicated\u00a0country\u00a0for national-level data\r\n+ period | ||
72 | - the period for which the data is collected. This can be | ||||
73 | \u201cweek\u201d or \u201cmonth\u201d data reported daily has been | ||||
74 | aggregated into weeks\r\n+ year - the year within which the period | ||||
75 | ends. The is the same as the year element of | ||||
76 | the\u00a0date\u00a0field.\r\n+ month - the month within which the | ||||
77 | period ends. This is the same as the month element of | ||||
78 | the\u00a0date\u00a0field.\r\n+ week - week number is either taken | ||||
79 | exactly from countries\u2019 own data, or is calculated using the | ||||
80 | following method for countries reporting daily data, we take the most | ||||
81 | recent run of seven days in the data to be the most recent week, and | ||||
82 | then aggregate each prior seven-day run into a new week, with any | ||||
83 | trailing period fewer than seven days at the start of January clipped | ||||
84 | off\r\n+ date - the date at which the week ends\r\n+ deaths - | ||||
85 | historical daily, weekly or monthly numbers of all-cause deaths for as | ||||
86 | far back as we have been able to obtain this data\r\n+ expected_deaths | ||||
87 | - the median value of this data for the equivalent period in years | ||||
88 | from 2015 to 2019\r\n+ excess_deaths - the difference | ||||
89 | between\u00a0deaths\u00a0and\u00a0expected deaths\u00a0(negative | ||||
90 | values indicate fewer deaths than the recent historical average)\r\n+ | ||||
91 | excess_deaths_pct - excess_deaths\u00a0as a percentage | ||||
92 | of\u00a0expected_deaths\r\n\r\n", | ||||
72 | "format": "CSV", | 93 | "format": "CSV", | ||
73 | "hash": "", | 94 | "hash": "", | ||
74 | "id": "18a91e0b-da35-495f-bc34-47f16eea087a", | 95 | "id": "18a91e0b-da35-495f-bc34-47f16eea087a", | ||
75 | "last_modified": "2021-03-03T09:20:24.124134", | 96 | "last_modified": "2021-03-03T09:20:24.124134", | ||
76 | "mimetype": null, | 97 | "mimetype": null, | ||
77 | "mimetype_inner": null, | 98 | "mimetype_inner": null, | ||
78 | "name": "ft_excess_deaths.csv", | 99 | "name": "ft_excess_deaths.csv", | ||
79 | "package_id": "08816e77-a136-42bd-a2cd-b36b072139e4", | 100 | "package_id": "08816e77-a136-42bd-a2cd-b36b072139e4", | ||
80 | "position": 0, | 101 | "position": 0, | ||
81 | "resource_type": null, | 102 | "resource_type": null, | ||
t | 82 | "revision_id": "c5de18d2-508d-49ab-b9ed-923f51df4e03", | t | 103 | "revision_id": "e67f9607-5d30-4357-8d60-63be4a218159", |
83 | "size": null, | 104 | "size": null, | ||
84 | "state": "active", | 105 | "state": "active", | ||
85 | "url": | 106 | "url": | ||
86 | e/18a91e0b-da35-495f-bc34-47f16eea087a/download/ft_excess_deaths.csv", | 107 | e/18a91e0b-da35-495f-bc34-47f16eea087a/download/ft_excess_deaths.csv", | ||
87 | "url_type": "upload" | 108 | "url_type": "upload" | ||
88 | }, | 109 | }, | ||
89 | { | 110 | { | ||
90 | "cache_last_updated": null, | 111 | "cache_last_updated": null, | ||
91 | "cache_url": null, | 112 | "cache_url": null, | ||
92 | "created": "2021-03-03T09:26:19.675251", | 113 | "created": "2021-03-03T09:26:19.675251", | ||
93 | "datastore_active": false, | 114 | "datastore_active": false, | ||
94 | "description": "## Data Dictionary ##\r\n\r\n+ country\t- the | 115 | "description": "## Data Dictionary ##\r\n\r\n+ country\t- the | ||
95 | country to which the data applies\r\n+ region - where applicable, the | 116 | country to which the data applies\r\n+ region - where applicable, the | ||
96 | subnational or administrative region. This | 117 | subnational or administrative region. This | ||
97 | duplicated\u00a0country\u00a0for national-level data\r\n+ period - the | 118 | duplicated\u00a0country\u00a0for national-level data\r\n+ period - the | ||
98 | period for which the data is collected. This can be \u201cweek\u201d | 119 | period for which the data is collected. This can be \u201cweek\u201d | ||
99 | or \u201cmonth\u201d data reported daily has been aggregated into | 120 | or \u201cmonth\u201d data reported daily has been aggregated into | ||
100 | weeks\r\n+ year - the year within which the period ends. The is the | 121 | weeks\r\n+ year - the year within which the period ends. The is the | ||
101 | same as the year element of the\u00a0date\u00a0field.\r\n+ month - the | 122 | same as the year element of the\u00a0date\u00a0field.\r\n+ month - the | ||
102 | month within which the period ends. This is the same as the month | 123 | month within which the period ends. This is the same as the month | ||
103 | element of the\u00a0date\u00a0field.\r\n+ week - week number is either | 124 | element of the\u00a0date\u00a0field.\r\n+ week - week number is either | ||
104 | taken exactly from countries\u2019 own data, or is calculated using | 125 | taken exactly from countries\u2019 own data, or is calculated using | ||
105 | the following method for countries reporting daily data, we take the | 126 | the following method for countries reporting daily data, we take the | ||
106 | most recent run of seven days in the data to be the most recent week, | 127 | most recent run of seven days in the data to be the most recent week, | ||
107 | and then aggregate each prior seven-day run into a new week, with any | 128 | and then aggregate each prior seven-day run into a new week, with any | ||
108 | trailing period fewer than seven days at the start of January clipped | 129 | trailing period fewer than seven days at the start of January clipped | ||
109 | off\r\n+ date - the date at which the week ends\r\n+ deaths - | 130 | off\r\n+ date - the date at which the week ends\r\n+ deaths - | ||
110 | historical daily, weekly or monthly numbers of all-cause deaths for as | 131 | historical daily, weekly or monthly numbers of all-cause deaths for as | ||
111 | far back as we have been able to obtain this data\r\n+ expected_deaths | 132 | far back as we have been able to obtain this data\r\n+ expected_deaths | ||
112 | - the median value of this data for the equivalent period in years | 133 | - the median value of this data for the equivalent period in years | ||
113 | from 2015 to 2019\r\n+ excess_deaths - the difference | 134 | from 2015 to 2019\r\n+ excess_deaths - the difference | ||
114 | between\u00a0deaths\u00a0and\u00a0expected deaths\u00a0(negative | 135 | between\u00a0deaths\u00a0and\u00a0expected deaths\u00a0(negative | ||
115 | values indicate fewer deaths than the recent historical average)\r\n+ | 136 | values indicate fewer deaths than the recent historical average)\r\n+ | ||
116 | excess_deaths_pct - excess_deaths\u00a0as a percentage | 137 | excess_deaths_pct - excess_deaths\u00a0as a percentage | ||
117 | of\u00a0expected_deaths", | 138 | of\u00a0expected_deaths", | ||
118 | "format": "XLS", | 139 | "format": "XLS", | ||
119 | "hash": "", | 140 | "hash": "", | ||
120 | "id": "e5b2d88c-1c4b-4d3e-95f4-bad138ec6626", | 141 | "id": "e5b2d88c-1c4b-4d3e-95f4-bad138ec6626", | ||
121 | "last_modified": "2021-03-03T09:26:19.646906", | 142 | "last_modified": "2021-03-03T09:26:19.646906", | ||
122 | "mimetype": null, | 143 | "mimetype": null, | ||
123 | "mimetype_inner": null, | 144 | "mimetype_inner": null, | ||
124 | "name": "ft-excess-mortality-covid-19.xls", | 145 | "name": "ft-excess-mortality-covid-19.xls", | ||
125 | "package_id": "08816e77-a136-42bd-a2cd-b36b072139e4", | 146 | "package_id": "08816e77-a136-42bd-a2cd-b36b072139e4", | ||
126 | "position": 1, | 147 | "position": 1, | ||
127 | "resource_type": null, | 148 | "resource_type": null, | ||
128 | "revision_id": "d4f2bbd7-3d71-446a-97e8-0f1540cf9663", | 149 | "revision_id": "d4f2bbd7-3d71-446a-97e8-0f1540cf9663", | ||
129 | "size": null, | 150 | "size": null, | ||
130 | "state": "active", | 151 | "state": "active", | ||
131 | "url": | 152 | "url": | ||
132 | c4b-4d3e-95f4-bad138ec6626/download/ft-excess-mortality-covid-19.xls", | 153 | c4b-4d3e-95f4-bad138ec6626/download/ft-excess-mortality-covid-19.xls", | ||
133 | "url_type": "upload" | 154 | "url_type": "upload" | ||
134 | } | 155 | } | ||
135 | ], | 156 | ], | ||
136 | "revision_id": "d4f2bbd7-3d71-446a-97e8-0f1540cf9663", | 157 | "revision_id": "d4f2bbd7-3d71-446a-97e8-0f1540cf9663", | ||
137 | "state": "active", | 158 | "state": "active", | ||
138 | "tags": [ | 159 | "tags": [ | ||
139 | { | 160 | { | ||
140 | "display_name": "covid-19", | 161 | "display_name": "covid-19", | ||
141 | "id": "7942a32e-1f4f-415f-a00b-27a926325c2d", | 162 | "id": "7942a32e-1f4f-415f-a00b-27a926325c2d", | ||
142 | "name": "covid-19", | 163 | "name": "covid-19", | ||
143 | "state": "active", | 164 | "state": "active", | ||
144 | "vocabulary_id": null | 165 | "vocabulary_id": null | ||
145 | }, | 166 | }, | ||
146 | { | 167 | { | ||
147 | "display_name": "deaths", | 168 | "display_name": "deaths", | ||
148 | "id": "f40484f3-4675-4d61-89ca-dcbddaf68a58", | 169 | "id": "f40484f3-4675-4d61-89ca-dcbddaf68a58", | ||
149 | "name": "deaths", | 170 | "name": "deaths", | ||
150 | "state": "active", | 171 | "state": "active", | ||
151 | "vocabulary_id": null | 172 | "vocabulary_id": null | ||
152 | }, | 173 | }, | ||
153 | { | 174 | { | ||
154 | "display_name": "mortalilty", | 175 | "display_name": "mortalilty", | ||
155 | "id": "efc3cb40-0048-4b00-80de-18a5ce6b1b9e", | 176 | "id": "efc3cb40-0048-4b00-80de-18a5ce6b1b9e", | ||
156 | "name": "mortalilty", | 177 | "name": "mortalilty", | ||
157 | "state": "active", | 178 | "state": "active", | ||
158 | "vocabulary_id": null | 179 | "vocabulary_id": null | ||
159 | } | 180 | } | ||
160 | ], | 181 | ], | ||
161 | "title": "Financial Times - Excess mortality during COVID-19 | 182 | "title": "Financial Times - Excess mortality during COVID-19 | ||
162 | pandemic", | 183 | pandemic", | ||
163 | "type": "dataset", | 184 | "type": "dataset", | ||
164 | "url": | 185 | "url": | ||
165 | taset/financial-times-excess-mortality-during-covid-19-pandemic-data", | 186 | taset/financial-times-excess-mortality-during-covid-19-pandemic-data", | ||
166 | "version": "" | 187 | "version": "" | ||
167 | } | 188 | } |