Errata

Table actions

Data source: Big Local News · About: big-local-datasette

511 rows sorted by File

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: File

Link rowid Update Date File ▼ Location Field Updated Old New Comments
290 290 6/28/2020 time_series_covi19_confirmed_global.csv France 06/1/20-06/27/20 185952;184980;188836;185986;186538;187067;187360;187458;187599;187996;188354;188918;189311;189602;189670;189595;189906;190107;190676;191112;191117;191442;191730;191543;191288;192624;192430 185952;185112;185440;186118;186670;187199;187492;187590;187925;188322;188680;189244;189637;189928;189996;190223;190534;190735;191304;191740;191745;192070;192452;192265;192010;193346;193152 issue with calculation of probable cases - see data modification records
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
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.
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.
262 262 6/19/2020 time_series_covid19_cases_global.csv Belarus 4/18/2020 4779 5297 Historic delay with Belarus reporting (https://news.tut.by/society/681391.html)
263 263 6/19/2020 time_series_covid19_cases_global.csv Belarus 4/19/2020 4779 5807 Historic delay with Belarus reporting (https://news.tut.by/society/681391.html)
333 333 7/15/2020 time_series_covid19_cases_global.csv Netherlands 7/1/2020 50273 50335 Stale data update
334 334 7/15/2020 time_series_covid19_cases_global.csv Netherlands 7/2/2020 50335 50412 Stale data update
335 335 7/15/2020 time_series_covid19_cases_global.csv Netherlands 7/3/2020 50335 50487 Stale data update
336 336 7/15/2020 time_series_covid19_cases_global.csv Netherlands 7/4/2020 50335 50548 Stale data update
1 1 4/7/2020 time_series_covid19_confirmed_US.csv Viginia Island 3/29/2020 0 23 New York Times
2 2 4/7/2020 time_series_covid19_confirmed_US.csv Viginia Island 3/30/2020 0 30 New York Times
3 3 4/7/2020 time_series_covid19_confirmed_US.csv DC, US 3/21/2020 0 98 New York Times
4 4 4/7/2020 time_series_covid19_confirmed_US.csv Miami-Dade, FL 3/19/2020 0 101 New York Times
5 5 4/7/2020 time_series_covid19_confirmed_US.csv Miami-Dade, FL 3/20/2020 0 124 New York Times
6 6 4/7/2020 time_series_covid19_confirmed_US.csv Hillsborough, NH 4/2/2020 0 163 New York Times
7 7 4/7/2020 time_series_covid19_confirmed_US.csv Harris, TX 3/20/2020 0 55 New York Times
8 8 4/7/2020 time_series_covid19_confirmed_US.csv Kansas City 3/21/2020 0 13 New York Times
9 9 4/9/2020 time_series_covid19_confirmed_US.csv Box Elder, UT 3/20/2020 13 7 New York Times
10 10 4/9/2020 time_series_covid19_confirmed_US.csv Union, FL 4/4/2020 10 2 New York Times
11 11 4/9/2020 time_series_covid19_confirmed_US.csv Daviess, KY 3/28/2020 33 20 New York Times
12 12 4/9/2020 time_series_covid19_confirmed_US.csv Washington, RI 4/2/2020 46 34 New York Times
13 13 4/9/2020 time_series_covid19_confirmed_US.csv West Feliciana, LA 4/2/2020 20 10 New York Times
14 14 4/9/2020 time_series_covid19_confirmed_US.csv Davidson, TN 4/2/2020 617 785 New York Times
16 16 4/13/2020 time_series_covid19_confirmed_US.csv Okaloosa, Florida 4/13/2020 102103 103 data source error
31 31 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/11/2020 3 2  
32 32 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/12/2020 3 2  
33 33 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/13/2020 3 2  
34 34 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/14/2020 3 2  
35 35 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/15/2020 3 2  
36 36 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/16/2020 3 2  
43 43 4/18/2020 time_series_covid19_confirmed_US.csv all Illinois counties 4/7/2020 12271 13553 changed at county level,
47 47 4/18/2020 time_series_covid19_confirmed_US.csv all Illinois counties 4/9/2020 15079 16422 changed at county level,
51 51 4/19/2020 time_series_covid19_confirmed_US.csv Davidson, Tennessee 4/16/2020 1492 1283  
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
88 88 4/22/2020 time_series_covid19_confirmed_US.csv Unassigned, WA 4/19/2020 436 159 remove spike
90 90 4/22/2020 time_series_covid19_confirmed_US.csv US 4/21/2020     correction for US federal data
94 94 4/23/2020 time_series_covid19_confirmed_US.csv Benton, WA 4/21/2020 423 326 remove 97 probable cases,
95 95 4/23/2020 time_series_covid19_confirmed_US.csv Benton, WA 4/22/2020 0 338 consistent with state report
96 96 4/23/2020 time_series_covid19_confirmed_US.csv Franklin, WA 4/21/2020 266 192 remove 74 probable cases,
97 97 4/23/2020 time_series_covid19_confirmed_US.csv Franklin, WA 4/22/2020 0 207 consistent with state report
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
164 164 5/9/2020 time_series_covid19_confirmed_US.csv Virginia, US 5/6/2020 20257 20985 All counties data updated
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
188 188 6/2/2020 time_series_covid19_confirmed_US.csv US 6/1/2020 383 43 Correction for Unassigned Oklahoma
193 193 6/6/2020 time_series_covid19_confirmed_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
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
227 227 6/12/2020 time_series_covid19_confirmed_US.csv St. Louis County 03/09/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
231 231 6/12/2020 time_series_covid19_confirmed_US.csv Massachusetts 4/15/20;04/17/20-06/11/2020     Change data source
234 234 6/13/2020 time_series_covid19_confirmed_US.csv Michigan 03/12/20-06/10/20     Revision for Michigan historical probables
241 241 6/16/2020 time_series_covid19_confirmed_US.csv Clackamas-Oregon 6/14/2020 455 482 Delayed update from Oregon Health Authority
242 242 6/16/2020 time_series_covid19_confirmed_US.csv Columbia-Oregon 6/14/2020 20 22 Delayed update from Oregon Health Authority
243 243 6/16/2020 time_series_covid19_confirmed_US.csv Hood River-Oregon 6/14/2020 71 81 Delayed update from Oregon Health Authority
244 244 6/16/2020 time_series_covid19_confirmed_US.csv Jackson-Oregon 6/14/2020 78 81 Delayed update from Oregon Health Authority
245 245 6/16/2020 time_series_covid19_confirmed_US.csv Jefferson-Oregon 6/14/2020 65 67 Delayed update from Oregon Health Authority
246 246 6/16/2020 time_series_covid19_confirmed_US.csv Klamath-Oregon 6/14/2020 48 51 Delayed update from Oregon Health Authority
247 247 6/16/2020 time_series_covid19_confirmed_US.csv Lane-Oregon 6/14/2020 85 89 Delayed update from Oregon Health Authority
248 248 6/16/2020 time_series_covid19_confirmed_US.csv Lincoln-Oregon 6/14/2020 184 206 Delayed update from Oregon Health Authority
249 249 6/16/2020 time_series_covid19_confirmed_US.csv Linn-Oregon 6/14/2020 124 126 Delayed update from Oregon Health Authority
250 250 6/16/2020 time_series_covid19_confirmed_US.csv Malheur-Oregon 6/14/2020 33 36 Delayed update from Oregon Health Authority
251 251 6/16/2020 time_series_covid19_confirmed_US.csv Marion-Oregon 6/14/2020 1134 1175 Delayed update from Oregon Health Authority
252 252 6/16/2020 time_series_covid19_confirmed_US.csv Morrow-Oregon 6/14/2020 13 15 Delayed update from Oregon Health Authority
253 253 6/16/2020 time_series_covid19_confirmed_US.csv Multnomah-Oregon 6/14/2020 1440 1519 Delayed update from Oregon Health Authority
254 254 6/16/2020 time_series_covid19_confirmed_US.csv Polk-Oregon 6/14/2020 117 124 Delayed update from Oregon Health Authority
255 255 6/16/2020 time_series_covid19_confirmed_US.csv Umatilla-Oregon 6/14/2020 157 171 Delayed update from Oregon Health Authority
256 256 6/16/2020 time_series_covid19_confirmed_US.csv Union-Oregon 6/14/2020 12 22 Delayed update from Oregon Health Authority
257 257 6/16/2020 time_series_covid19_confirmed_US.csv Wasco-Oregon 6/14/2020 38 39 Delayed update from Oregon Health Authority
258 258 6/16/2020 time_series_covid19_confirmed_US.csv Washington-Oregon 6/14/2020 849 876 Delayed update from Oregon Health Authority
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
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
278 278 6/24/2020 time_series_covid19_confirmed_US.csv Oregon 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
286 286 6/25/2020 time_series_covid19_confirmed_US.csv NV 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
293 293 6/30/2020 time_series_covid19_confirmed_US.csv Franklin, New York 6/29/2020     Update for revised Franklin reporting
297 297 7/1/2020 time_series_covid19_confirmed_US.csv NYC 6/29/2020     Update in accordance with NY State data
299 299 7/1/2020 time_series_covid19_confirmed_US.csv Greenville, South Carolina 06/02/20;06/03/20;06/04/20;06/05/20;06/06/20;06/07/20     Update in accordance with SC state press releases
301 301 7/1/2020 time_series_covid19_confirmed_US.csv Ventura, California 03/10/20-06/20/20     Updates to Ventura County
303 303 7/2/2020 time_series_covid19_confirmed_US.csv Missouri 06/27/20;06/28/20;06/29/20;06/30/20;06/31/20;07/1/20     Updates to Missouri
307 307 7/2/2020 time_series_covid19_confirmed_US.csv Massachusetts 7/1/2020     Updates to Massachusetts
314 314 7/3/2020 time_series_covid19_confirmed_US.csv Ohio 7/2/2020     Updates to Ohio to align with state total
319 319 7/6/2020 time_series_covid19_confirmed_US.csv Harris, Texas 7/3/2020-7/6/2020     Update reporting from county
327 327 7/14/2020 time_series_covid19_confirmed_US.csv Washington 7/13/2020     Update from Washington DOH reporting
341 341 7/15/2020 time_series_covid19_confirmed_US.csv Granville, NC 4/27/2020 240 133 Correction
343 343 7/15/2020 time_series_covid19_confirmed_US.csv Dent, MO 5/13/2020-6/22/2020     Update via Dent County Health Center data
344 344 7/15/2020 time_series_covid19_confirmed_US.csv Douglas, MO 5/30/2020-6/11/2020     Update via Douglas County Health Department data
349 349 7/16/2020 time_series_covid19_confirmed_US.csv Dallas, TX 4/21;4/27;4/29;5/12;5/20;5/30;6/28;7/10;7/15/2020     Update from Dallas County reporting
358 358 7/21/2020 time_series_covid19_confirmed_US.csv Philadelphia, PA 7/20/2020     Update from Philadelphia DOH

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [Errata] (
   [Update Date] TEXT,
   [File] TEXT,
   [Location] TEXT,
   [Field Updated] TEXT,
   [Old] TEXT,
   [New] TEXT,
   [Comments] TEXT
);