Errata
Data source: Big Local News · About: big-local-datasette
511 rows
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | Update Date | File | Location | Field Updated | Old | New | Comments |
|---|---|---|---|---|---|---|---|---|
| 101 | 101 | 4/23/2020 | time_series_covid19_confirmed_global.csv | US | 4/22/2020 | 839675 | 840351 | adjust for Benton and Franklin, WA |
| 102 | 102 | 4/23/2020 | time_series_covid19_deaths_global.csv | US | 4/22/2020 | 46583 | 46622 | adjust for Benton and Franklin, WA |
| 103 | 103 | 4/24/2020 | time_series_covid19_deaths_us.csv | New York City, NY | 03/12/20-04/24/20 | Adjust to back-distribute probable deaths | ||
| 104 | 104 | 4/24/2020 | time_series_covid19_confirmed_us.csv | New York City, NY | 04/18/20;04/19/20;04/20/20;04/21/20;04/22/20 | Adjust to remove probable deaths from case count | ||
| 105 | 105 | 4/25/2020 | time_series_covid19_confirmed_global.csv | Ukraine | 4/24/2020 | 8125 | 7647 | adjust 5 min ahead |
| 106 | 106 | 4/26/2020 | time_series_covid19_recovered_global.csv | Australian Capital Territory - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20 | Replace recovered cases | ||
| 107 | 107 | 4/26/2020 | time_series_covid19_recovered_global.csv | New South Wales - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20 | Replace recovered cases | ||
| 108 | 108 | 4/26/2020 | time_series_covid19_recovered_global.csv | Australian Capital Territory - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20 | Replace recovered cases | ||
| 109 | 109 | 4/26/2020 | time_series_covid19_recovered_global.csv | Northern Territory - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20 | Replace recovered cases | ||
| 110 | 110 | 4/26/2020 | time_series_covid19_recovered_global.csv | South Australia - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20 | Replace recovered cases | ||
| 111 | 111 | 4/26/2020 | time_series_covid19_recovered_global.csv | Tasmania - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20 | Replace recovered cases | ||
| 112 | 112 | 4/26/2020 | time_series_covid19_recovered_global.csv | Victoria - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20 | Replace recovered cases | ||
| 113 | 113 | 4/26/2020 | time_series_covid19_recovered_global.csv | Western Australia - Australia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20 | Replace recovered cases | ||
| 114 | 114 | 4/27/2020 | time_series_covid19_confirmed_global.csv | Mexico | 03/13/20;04/22/20 | Remove duplicate entry on 13/3/20; add 10544 cases on 22/4; adjust 11632 to 12872 | ||
| 115 | 115 | 4/27/2020 | times_series_covid19_deaths_global.csv | Mexico | 03/20/20;04/22/20 | Remove duplicate entry on 3/20/20; add 970 deaths on 22/4; adjust 1069 to 1221 | ||
| 116 | 116 | 4/28/2020 | time_series_covid19_deaths_global.csv | US | All | Adjust deaths to reflect changes from 4/24 adjustment of NYC probable deaths | ||
| 117 | 117 | 4/30/2020 | time_series_covid19_deaths_global.csv | United Kingdom | All columns | Adjusted all deaths to match newly released data from the United Kingdom identifying deaths in care homes | ||
| 118 | 118 | 4/30/2020 | time_series_covid19_cases_global.csv | Spain | 04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases adjusted to match official case count | ||
| 119 | 119 | 4/30/2020 | time_series_covid19_recovered_global.csv | Spain | 04/26/20;04/27/20;04/28/20;04/29/20 | Recovered adjusted to match official count | ||
| 120 | 120 | 5/1/2020 | time_series_covid19_cases_global.csv | Kosovo | 04/19/20;04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases updated due to stale data source. Prior were stuck at 510. | ||
| 121 | 121 | 5/1/2020 | time_series_covid19_deaths_global.csv | Kosovo | 04/19/20;04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases updated due to stale data source. Prior were stuck at 12. | ||
| 122 | 122 | 5/1/2020 | time_series_covid19_recovered_global.csv | Kosovo | 04/19/20;04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases updated due to stale data source. Prior were stuck at 93. | ||
| 123 | 123 | 5/1/2020 | time_series_covid19_cases_global.csv | Serbia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases updated due to stale data source. Prior were stuck at 6630. | ||
| 124 | 124 | 5/1/2020 | time_series_covid19_deaths_global.csv | Serbia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases updated due to stale data source. Prior were stuck at 125. | ||
| 125 | 125 | 5/1/2020 | time_series_covid19_recovered_global.csv | Serbia | 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20;04/27/20;04/28/20;04/29/20 | Cases updated due to stale data source. Prior were stuck at 870. | ||
| 126 | 126 | 5/2/2020 | time_series_covid19_deaths_global.csv | France | 4/14-5/01 | Deaths updated to remove double counts of deaths in DROM. Logic = France, France entry for date - sum(deaths in DROM for date) | ||
| 127 | 127 | 5/2/2020 | time_series_covid19_recovered_global.csv | France | 4/14-5/01 | Recovered updated to remove double counts of recoveries in DROM. Logic = France, France entry for date - sum(recoveries in DROM for date) | ||
| 128 | 128 | 5/6/2020 | time_series_covid19_deaths_us.csv | 84029113, Lincoln, Missouri | 4/27/2020 | 41 | 1 | correction |
| 129 | 129 | 5/6/2020 | times_series_covid19_deaths_global.csv | US | 4/27/2020 | 56259 | 56219 | |
| 130 | 130 | 5/7/2020 | time_series_covid19_confirmed_global.csv | Bolivia | 4/28/2020 | 1014 | 1053 | Shift datat 3-4 hours later to remove the spikes |
| 131 | 131 | 5/7/2020 | time_series_covid19_confirmed_global.csv | Bolivia | 4/30/2020 | 1110 | 1167 | Shift datat 3-4 hours later to remove the spikes |
| 132 | 132 | 5/7/2020 | time_series_covid19_confirmed_global.csv | Bolivia | 5/2/2020 | 1229 | 1470 | Shift datat 3-4 hours later to remove the spikes |
| 133 | 133 | 5/7/2020 | time_series_covid19_deaths_global.csv | Bolivia | 4/28/2020 | 53 | 55 | Shift datat 3-4 hours later to remove the spikes |
| 134 | 134 | 5/7/2020 | time_series_covid19_deaths_global.csv | Bolivia | 4/30/2020 | 59 | 62 | Shift datat 3-4 hours later to remove the spikes |
| 135 | 135 | 5/7/2020 | time_series_covid19_deaths_global.csv | Bolivia | 5/2/2020 | 66 | 71 | Shift datat 3-4 hours later to remove the spikes |
| 136 | 136 | 5/7/2020 | time_series_covid19_recovered_global.csv | Bolivia | 4/28/2020 | 98 | 110 | Shift datat 3-4 hours later to remove the spikes |
| 137 | 137 | 5/7/2020 | time_series_covid19_recovered_global.csv | Bolivia | 4/30/2020 | 117 | 132 | Shift datat 3-4 hours later to remove the spikes |
| 138 | 138 | 5/7/2020 | time_series_covid19_recovered_global.csv | Bolivia | 5/2/2020 | 134 | 159 | Shift datat 3-4 hours later to remove the spikes |
| 139 | 139 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/12/2020 | 290 | 271 | Update historical numbers to match the official report |
| 140 | 140 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/13/2020 | 308 | 273 | without cases from occupied Jerusalem or East Jerusalem |
| 141 | 141 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/14/2020 | 308 | 284 | |
| 142 | 142 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/15/2020 | 374 | 291 | |
| 143 | 143 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/16/2020 | 374 | 294 | |
| 144 | 144 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/17/2020 | 402 | 307 | |
| 145 | 145 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/18/2020 | 418 | 313 | |
| 146 | 146 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/19/2020 | 437 | 319 | |
| 147 | 147 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/20/2020 | 449 | 329 | |
| 148 | 148 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/21/2020 | 466 | 329 | |
| 149 | 149 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/22/2020 | 474 | 335 | |
| 150 | 150 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/23/2020 | 480 | 336 | |
| 151 | 151 | 5/7/2020 | time_series_covid19_confirmed_global.csv | West Bank and Gaza | 4/24/2020 | 484 | 340 | |
| 152 | 152 | 5/7/2020 | time_series_covid19_deaths_global.csv | West Bank and Gaza | 4/19/2020 | 3 | 2 | |
| 153 | 153 | 5/7/2020 | time_series_covid19_deaths_global.csv | West Bank and Gaza | 4/20/2020 | 3 | 2 | |
| 154 | 154 | 5/7/2020 | time_series_covid19_deaths_global.csv | West Bank and Gaza | 4/21/2020 | 4 | 2 | |
| 155 | 155 | 5/7/2020 | time_series_covid19_deaths_global.csv | West Bank and Gaza | 4/22/2020 | 4 | 2 | |
| 156 | 156 | 5/7/2020 | time_series_covid19_deaths_global.csv | West Bank and Gaza | 4/23/2020 | 4 | 2 | |
| 157 | 157 | 5/7/2020 | time_series_covid19_deaths_global.csv | West Bank and Gaza | 4/24/2020 | 4 | 2 | |
| 158 | 158 | 5/7/2020 | time_series_covid19_recovered_global.csv | West Bank and Gaza | 4/23/2020 | 92 | 74 | |
| 159 | 159 | 5/7/2020 | time_series_covid19_recovered_global.csv | West Bank and Gaza | 4/24/2020 | 92 | 81 | |
| 160 | 160 | 5/7/2020 | time_series_covid19_recovered_global.csv | West Bank and Gaza | 4/25/2020 | 92 | 83 | |
| 161 | 161 | 5/7/2020 | time_series_covid19_confirmed_US.csv | Box Elder and Bear River, Utah | before 4/19 | transfer data from Box Elder to Bear River, Utah | ||
| 162 | 162 | 5/7/2020 | time_series_covid19_confirmed_US.csv | Weber and Weber-Morgan, Utah | before 4/19 | transfer data from Weber to Weber-Morgan, Utah | ||
| 163 | 163 | 5/7/2020 | time_series_covid19_deaths_US.csv | Weber and Weber-Morgan, Utah | before 4/19 | transfer data from Weber to Weber-Morgan, Utah | ||
| 164 | 164 | 5/9/2020 | time_series_covid19_confirmed_US.csv | Virginia, US | 5/6/2020 | 20257 | 20985 | All counties data updated |
| 165 | 165 | 5/9/2020 | time_series_covid19_deaths_US.csv | Virginia, US | 5/6/2020 | 713 | 737 | according to https://www.vdh.virginia.gov/coronavirus/ |
| 166 | 166 | 5/9/2020 | time_series_covid19_confirmed_global.csv | US | 5/6/2020 | 1228603 | 1229331 | |
| 167 | 167 | 5/9/2020 | time_series_covid19_deaths_global.csv | US | 5/6/2020 | 73431 | 73455 | |
| 168 | 168 | 5/10/2020 | time_series_covid19_recovered_global.csv | Uruguay | 04/01/20-04/22/20 | Recovered adjusted to match national statistics | ||
| 169 | 169 | 5/10/2020 | time_series_covid19_deaths_global.csv | Uruguay | 03/28/20;4/5/20;4/15/20;4/21/20 | 0;5;8;11 | 1;6;9;12 | Adjusted to match national statistics |
| 170 | 170 | 5/10/2020 | time_series_covid19_confirmed_global.csv | Uruguay | 03/13/20-04/23/20 | Confirmed adjusted to match national statistics | ||
| 171 | 171 | 5/11/2020 | time_series_covid19_confirmed_global.csv | Spain | 5/1/2020 | 213435 | 215216 | |
| 172 | 172 | 5/20/2020 | time_series_covid19_confirmed_US.csv | Colorado | 03/05/20-04/20/20 | update all counties with the last cases.csv for each day | ||
| 173 | 173 | 5/20/2020 | time_series_covid19_deaths_US.csv | Colorado | 03/12/20-04/20/20 | update all counties with the last cases.csv for each day | ||
| 174 | 174 | 5/20/2020 | time_series_covid19_confirmed_global.csv | US | 03/05/20-04/20/20 | correction made due to CO data update | ||
| 175 | 175 | 5/20/2020 | time_series_covid19_deaths_global.csv | US | 03/12/20-04/20/20 | correction made due to CO data update | ||
| 176 | 176 | 5/21/2020 | time_series_covid19_confirmed_global.csv | Italy | 3/12/2020 | 12462 | 15113 | remove spike |
| 177 | 177 | 5/21/2020 | time_series_covid19_deaths_global.csv | Italy | 3/12/2020 | 827 | 1016 | remove spike |
| 178 | 178 | 5/27/2020 | time_series_covid19_recovered_global.csv | Netherlands | all | all recovered data removed | ||
| 179 | 179 | 5/27/2020 | time_series_covid19_confirmed_global.csv | France | 05/22/20;05/23/20 | 179306;179306 | 179645;179964 | stale data over weekend |
| 180 | 180 | 5/27/2020 | time_series_covid19_deaths_global.csv | France | 05/22/20;05/23/20 | 28167;28167 | 28241;28284 | stale data over weekend |
| 181 | 181 | 5/27/2020 | time_series_covid19_recovered_global.csv | France | 5/22/20;05/23/20 | 62216;62216 | 62557;62893 | stale data over weekend |
| 182 | 182 | 5/28/2020 | time_series_covid19_deaths_US.csv | Siskiyou County, CA | 5/22/20;05/23/20;05/24/20;05/25/20;05/26/20;05/27/20 | 1 | 0 | miscount |
| 183 | 183 | 5/28/2020 | time_series_covid19_deaths_global.csv | 5/22/20;05/23/20;05/24/20;05/25/20;05/26/20;05/27/20 | -1 | correction for Siskiyou, CA | ||
| 184 | 184 | 6/1/2020 | time_series_covid19_confirmed_global.csv | Peru | 4/28/2020 | 141779 | 148285 | Stale overnight update |
| 185 | 185 | 6/1/2020 | time_series_covid19_deaths_global.csv | Peru | 4/28/2020 | 4099 | 4230 | Stale overnight update |
| 186 | 186 | 6/2/2020 | time_series_covid19_confirmed_global.csv | US | 6/1/2020 | 1811360 | 1811020 | Correction for Unassigned Oklahoma |
| 187 | 187 | 6/2/2020 | time_series_covid19_deaths_global.csv | US | 6/1/2020 | 105165 | 105149 | Correction for Unassigned Oklahoma |
| 188 | 188 | 6/2/2020 | time_series_covid19_confirmed_US.csv | US | 6/1/2020 | 383 | 43 | Correction for Unassigned Oklahoma |
| 189 | 189 | 6/2/2020 | time_series_covid19_deaths_US.csv | US | 6/1/2020 | 16 | 0 | Correction for Unassigned Oklahoma |
| 190 | 190 | 6/4/2020 | time_series_covid19_confirmed_global.csv | France | 6/3/2020 | 110906 | 188836 | probable case update |
| 191 | 191 | 6/5/2020 | time_series_covid19_recovered_global.csv | Chile | 06/02/20;06/03/20;06/04/20 | updated recovered case counts in line with new reporting | ||
| 192 | 192 | 6/5/2020 | time_series_covid19_recovered_global.csv | Sweden | 01/22/20-06/04/20 | updated recovered case counts in line with data modification record | ||
| 193 | 193 | 6/6/2020 | time_series_covid19_confirmed_US.csv | US | 6/5/2020 | Type change for daily data from float to int | ||
| 194 | 194 | 6/6/2020 | time_series_covid19_deaths_US.csv | US | 6/5/2020 | Type change for daily data from float to int | ||
| 195 | 195 | 6/6/2020 | time_series_covid19_recovered_global.csv | Brazil | 6/5/2020 | 0 | 266940 | update per returned data |
| 196 | 196 | 6/6/2020 | time_series_covid19_deaths_global.csv | Brazil | 6/5/2020 | 34021 | 35026 | update per returned data |
| 197 | 197 | 6/6/2020 | time_series_covid19_confirmed_global.csv | Brazil | 6/5/2020 | 614941 | 645771 | update per returned data |
| 198 | 198 | 6/8/2020 | time_series_covid19_deaths_US.csv | Northern Mariana Islands, US | 6/3/2020 | 16 | 14 | Correction for Northern Mariana Islands, US |
| 199 | 199 | 6/8/2020 | time_series_covid19_deaths_US.csv | Northern Mariana Islands, US | 6/4/2020 | 16 | 14 | Correction for Northern Mariana Islands, US |
| 200 | 200 | 6/8/2020 | time_series_covid19_deaths_US.csv | Northern Mariana Islands, US | 6/5/2020 | 16 | 14 | Correction for Northern Mariana Islands, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [Errata] ( [Update Date] TEXT, [File] TEXT, [Location] TEXT, [Field Updated] TEXT, [Old] TEXT, [New] TEXT, [Comments] TEXT );