Errata
Data source: Big Local News · About: big-local-datasette
511 rows sorted by Old
This data as json, copyable, CSV (advanced)
Suggested facets: File
| Link | rowid | Update Date | File | Location | Field Updated | Old ▼ | New | Comments |
|---|---|---|---|---|---|---|---|---|
| 76 | 76 | 4/22/2020 | time_series_covid19_confirmed_US.csv | Navajo, AZ | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 77 | 77 | 4/22/2020 | time_series_covid19_confirmed_US.csv | Coconino, AZ | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 78 | 78 | 4/22/2020 | time_series_covid19_confirmed_US.csv | Apache, AZ | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 79 | 79 | 4/22/2020 | time_series_covid19_confirmed_US.csv | San Juan, NM | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 80 | 80 | 4/22/2020 | time_series_covid19_confirmed_US.csv | McKinley, NM | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 81 | 81 | 4/22/2020 | time_series_covid19_confirmed_US.csv | Cibola, NM | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 82 | 82 | 4/22/2020 | time_series_covid19_confirmed_US.csv | Socorro, NM | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 83 | 83 | 4/22/2020 | time_series_covid19_confirmed_US.csv | San Juan, UT | 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20 | remove duplicates | ||
| 84 | 84 | 4/22/2020 | time_series_covid19_deaths_US.csv | Navajo, AZ | 3/31/20;04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20;04/09/20;04/10/20;04/11/20;04/12/20;04/13/20;04/14/20;04/15/20;04/16/20;04/17/20 | remove duplicates | ||
| 85 | 85 | 4/22/2020 | time_series_covid19_deaths_US.csv | Coconino, AZ | 3/31/20;04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20;04/09/20;04/10/20;04/11/20;04/12/20;04/13/20;04/14/20;04/15/20;04/16/20;04/17/20 | remove duplicates | ||
| 86 | 86 | 4/22/2020 | time_series_covid19_deaths_US.csv | Apache, AZ | 3/31/20;04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20;04/09/20;04/10/20;04/11/20;04/12/20;04/13/20;04/14/20;04/15/20;04/16/20;04/17/20 | remove duplicates | ||
| 90 | 90 | 4/22/2020 | time_series_covid19_confirmed_US.csv | US | 4/21/2020 | correction for US federal data | ||
| 91 | 91 | 4/22/2020 | time_series_covid19_deaths_US.csv | US | 4/21/2020 | correction for US federal data | ||
| 92 | 92 | 4/22/2020 | time_series_covid19_confirmed_global.csv | US | 4/21/2020 | correction for US federal data | ||
| 93 | 93 | 4/22/2020 | time_series_covid19_deaths_global.csv | US | 4/21/2020 | correction for US federal data | ||
| 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 | ||
| 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) | ||
| 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 | ||
| 168 | 168 | 5/10/2020 | time_series_covid19_recovered_global.csv | Uruguay | 04/01/20-04/22/20 | Recovered 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 | ||
| 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 | ||
| 178 | 178 | 5/27/2020 | time_series_covid19_recovered_global.csv | Netherlands | all | all recovered data removed | ||
| 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 | ||
| 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 | ||
| 208 | 208 | 6/8/2020 | time_series_covid19_confirmed_US.csv | Virginia | 6/7/2020 | Updated all Virginia counties for 6/7 | ||
| 209 | 209 | 6/8/2020 | time_series_covid19_deaths_US.csv | Virginia | 6/7/2020 | Updated all Virginia counties for 6/7 | ||
| 212 | 212 | 6/10/2020 | time_series_covid19_confirmed_US.csv | Michigan | 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20 | Updated all Michigan counties | ||
| 213 | 213 | 6/10/2020 | time_series_covid19_deaths_US.csv | Michigan | 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20 | Updated all Michigan counties | ||
| 214 | 214 | 6/10/2020 | time_series_covid19_confirmed_global.csv | US | 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20 | Updated for Michigan | ||
| 215 | 215 | 6/10/2020 | time_series_covid19_deaths_global.csv | US | 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20 | Updated for Michigan | ||
| 227 | 227 | 6/12/2020 | time_series_covid19_confirmed_US.csv | St. Louis County | 03/09/20-06/11/2020 | Change data source | ||
| 228 | 228 | 6/12/2020 | time_series_covid19_deaths_US.csv | St. Louis County | 03/20/20-06/11/2020 | Change data source | ||
| 229 | 229 | 6/12/2020 | time_series_covid19_confirmed_US.csv | St. Louis City | 03/16/20-06/11/2020 | Change data source | ||
| 230 | 230 | 6/12/2020 | time_series_covid19_deaths_US.csv | St. Louis City | 03/20/20-06/11/2020 | Change data source | ||
| 231 | 231 | 6/12/2020 | time_series_covid19_confirmed_US.csv | Massachusetts | 4/15/20;04/17/20-06/11/2020 | Change data source | ||
| 232 | 232 | 6/12/2020 | time_series_covid19_confirmed_global.csv | US | all days | county sum = country total | ||
| 233 | 233 | 6/12/2020 | time_series_covid19_deaths_global.csv | US | all days | county sum = country total | ||
| 234 | 234 | 6/13/2020 | time_series_covid19_confirmed_US.csv | Michigan | 03/12/20-06/10/20 | Revision for Michigan historical probables | ||
| 235 | 235 | 6/13/2020 | time_series_covid19_deaths_US.csv | Michigan | 03/12/20-06/10/20 | Revision for Michigan historical probables | ||
| 236 | 236 | 6/13/2020 | time_series_covid19_confirmed_global.csv | US | 03/12/20-06/10/20 | Revision for Michigan historical probables | ||
| 237 | 237 | 6/13/2020 | time_series_covid19_deaths_global.csv | US | 03/12/20-06/10/20 | Revision for Michigan historical probables | ||
| 238 | 238 | 6/15/2020 | time_series_covid19_confirmed_global.csv | India | 06/11/20;06/12/20;06/13/20;06/14/20 | Remove time lag from data | ||
| 239 | 239 | 6/15/2020 | time_series_covid19_deaths_global.csv | India | 06/10/20;06/11/20;06/12/20;06/13/20;06/14/20 | Remove time lag from data | ||
| 240 | 240 | 6/15/2020 | time_series_covid19_recovered_global.csv | India | 06/11/20;06/12/20;06/13/20;06/14/20 | Remove time lag from data | ||
| 264 | 264 | 6/20/2020 | time_series_covid19_confirmed_US.csv | North Carolina | 06/18/20;06/19/20 | Corrections for NC duplication | ||
| 265 | 265 | 6/20/2020 | time_series_covid19_confirmed_US.csv | North Carolina | 06/18/20;06/19/20 | Corrections for NC duplication | ||
| 266 | 266 | 6/20/2020 | time_series_covid19_confirmed_global.csv | US | 06/18/20;06/19/20 | Corrections for NC duplication | ||
| 267 | 267 | 6/20/2020 | time_series_covid19_deaths_global.csv | US | 06/18/20;06/19/20 | Corrections for NC duplication | ||
| 268 | 268 | 6/22/2020 | time_series_covid19_confirmed_US.csv | North Carolina | 6/21/2020 | Corrections for NC duplication | ||
| 269 | 269 | 6/22/2020 | time_series_covid19_confirmed_US.csv | North Carolina | 6/21/2020 | Corrections for NC duplication | ||
| 270 | 270 | 6/22/2020 | time_series_covid19_confirmed_global.csv | US | 6/21/2020 | Corrections for NC duplication | ||
| 271 | 271 | 6/22/2020 | time_series_covid19_deaths_global.csv | US | 6/21/2020 | Corrections for NC duplication | ||
| 272 | 272 | 6/22/2020 | time_series_covid19_confirmed_global.csv | Sweden | 06/19/20;06/20/20;06/21/20 | Corrections for Sweden duplication | ||
| 273 | 273 | 6/22/2020 | time_series_covid19_deaths_global.csv | Sweden | 06/19/20;06/20/20;06/21/20 | Corrections for Sweden duplication | ||
| 275 | 275 | 6/23/2020 | time_series_covid19_confirmed_global.csv | Peru | 06/19/20;06/21/20 | Corrections for source update delay | ||
| 276 | 276 | 6/23/2020 | time_series_covid19_deaths_global.csv | Peru | 06/19/20;06/21/20 | Corrections for source update delay | ||
| 277 | 277 | 6/23/2020 | time_series_covid19_recovered_global.csv | Peru | 06/19/20;06/21/20 | Corrections for source update delay | ||
| 278 | 278 | 6/24/2020 | time_series_covid19_confirmed_US.csv | Oregon | 6/20/2020 | Corrections for Oregon weekend update | ||
| 279 | 279 | 6/24/2020 | time_series_covid19_deaths_US.csv | Oregon | 6/20/2020 | Corrections for Oregon weekend update | ||
| 280 | 280 | 6/24/2020 | time_series_covid19_confirmed_global.csv | US | 6/20/2020 | Corrections for Oregon weekend update | ||
| 281 | 281 | 6/24/2020 | time_series_covid19_deaths_global.csv | US | 6/20/2020 | Corrections for Oregon weekend update | ||
| 282 | 282 | 6/25/2020 | time_series_covid19_confirmed_US.csv | Iowa | 6/24/2020 | Corrections for Iowa duplication | ||
| 283 | 283 | 6/25/2020 | time_series_covid19_deaths_US.csv | Iowa | 6/24/2020 | Corrections for Iowa duplication | ||
| 284 | 284 | 6/25/2020 | time_series_covid19_confirmed_global.csv | US | 6/24/2020 | Corrections for Iowa duplication | ||
| 285 | 285 | 6/25/2020 | time_series_covid19_deaths_global.csv | US | 6/24/2020 | Corrections for Iowa duplication | ||
| 286 | 286 | 6/25/2020 | time_series_covid19_confirmed_US.csv | NV | 6/23/2020 | Corrections for Nevada duplication | ||
| 287 | 287 | 6/25/2020 | time_series_covid19_deaths_US.csv | NV | 6/23/2020 | Corrections for Nevada duplication | ||
| 288 | 288 | 6/25/2020 | time_series_covid19_confirmed_global.csv | US | 6/23/2020 | Corrections for Nevada duplication | ||
| 289 | 289 | 6/25/2020 | time_series_covid19_deaths_global.csv | US | 6/23/2020 | Corrections for Nevada duplication | ||
| 291 | 291 | 6/30/2020 | time_series_covid19_confirmed_US.csv | New York City, New York | 6/29/2020 | Update for stale NYC data |
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 );