Errata

Table actions

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

511 rows sorted by Location

✎ 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
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
128 128 5/6/2020 time_series_covid19_deaths_us.csv 84029113, Lincoln, Missouri 4/27/2020 41 1 correction
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
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
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
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
480 480 9/05/2020 time_series_covid19_confirmed_global.csv Bahamas 8/22/2020 1703 1765 Update from Bahamas press release
481 481 9/05/2020 time_series_covid19_confirmed_global.csv Bahamas 8/23/2020 1765 1784 Update from Bahamas press release
482 482 9/05/2020 time_series_covid19_confirmed_global.csv Bahamas 8/24/2020 1765 1798 Update from Bahamas press release
483 483 9/05/2020 time_series_covid19_confirmed_global.csv Bahamas 8/25/2020 1765 1813 Update from Bahamas press release
484 484 9/05/2020 time_series_covid19_confirmed_global.csv Bahamas 8/26/2020 1765 1923 Update from Bahamas press release
485 485 9/05/2020 time_series_covid19_confirmed_global.csv Bahamas 8/27/2020 1765 2020 Update from Bahamas press release
486 486 9/05/2020 time_series_covid19_deaths_global.csv Bahamas 8/23/2020 29 44 Update from Bahamas press release
487 487 9/05/2020 time_series_covid19_deaths_global.csv Bahamas 8/24/2020 29 46 Update from Bahamas press release
488 488 9/05/2020 time_series_covid19_deaths_global.csv Bahamas 8/25/2020 29 48 Update from Bahamas press release
489 489 9/05/2020 time_series_covid19_deaths_global.csv Bahamas 8/26/2020 29 48 Update from Bahamas press release
490 490 9/05/2020 time_series_covid19_recovered_global.csv Bahamas 8/22/2020 221 227 Update from Bahamas press release
491 491 9/05/2020 time_series_covid19_recovered_global.csv Bahamas 8/23/2020 227 634 Update from Bahamas press release
492 492 9/05/2020 time_series_covid19_recovered_global.csv Bahamas 8/24/2020 227 634 Update from Bahamas press release
493 493 9/05/2020 time_series_covid19_recovered_global.csv Bahamas 8/25/2020 227 634 Update from Bahamas press release
494 494 9/05/2020 time_series_covid19_recovered_global.csv Bahamas 8/26/2020 227 733 Update from Bahamas press release
495 495 9/05/2020 time_series_covid19_recovered_global.csv Bahamas 8/27/2020 227 742 Update from Bahamas press release
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)
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
98 98 4/23/2020 time_series_covid19_deaths_US.csv Benton, WA 4/22/2020 0 35 adjust for Benton and Franklin, WA
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
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
9 9 4/9/2020 time_series_covid19_confirmed_US.csv Box Elder, UT 3/20/2020 13 7 New York Times
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
274 274 6/22/2020 time_series_covid19_confirmed_global.csv Brazil 6/20/2020 1032913 1067579 Correction for Brazil duplication
318 318 7/4/2020 time_series_covid19_deaths_global.csv Brazil 7/3/2020     Updates Brazil deaths to align with official report
382 382 7/25/2020 time_series_covid19_confirmed_global.csv Brazil 7/24/2020     Correction for stale data
460 460 8/12/2020 time_series_covid19_confirmed_global.csv Brazil 8/11/2020     Update from Secretarias Estaduais de Saude
461 461 8/12/2020 time_series_covid19_deaths_global.csv Brazil 8/11/2020     Update from Secretarias Estaduais de Saude
476 476 8/17/2020 time_series_covid19_confirmed_global.csv Brazil 8/14/2020 3226443 3275520 Match up with the official report
477 477 8/17/2020 time_series_covid19_deaths_global.csv Brazil 8/14/2020 105490 106523 Match up with the official report
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
367 367 7/22/2020 time_series_covid19_confirmed_global.csv Chile 7/20/2020     Update from Ministerio de Ciencia
368 368 7/22/2020 time_series_covid19_deaths_global.csv Chile 7/20/2020     Update from Ministerio de Ciencia
369 369 7/22/2020 time_series_covid19_recovered_global.csv Chile 7/20/2020     Update from Ministerio de Ciencia
375 375 7/23/2020 time_series_covid19_confirmed_global.csv Chile 7/22/2020     Update from Ministerio de Ciencia
376 376 7/23/2020 time_series_covid19_deaths_global.csv Chile 7/22/2020     Update from Ministerio de Ciencia
377 377 7/23/2020 time_series_covid19_recovered_global.csv Chile 7/22/2020     Update from Ministerio de Ciencia
364 364 7/22/2020 time_series_covid19_confirmed_global.csv China 7/16-7/21/2020     Update from DXY
365 365 7/22/2020 time_series_covid19_deaths_global.csv China 7/16-7/21/2020     Update from DXY
366 366 7/22/2020 time_series_covid19_recovered_global.csv China 7/16-7/21/2020     Update from DXY
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
241 241 6/16/2020 time_series_covid19_confirmed_US.csv Clackamas-Oregon 6/14/2020 455 482 Delayed update from Oregon Health Authority
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
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
353 353 7/17/2020 time_series_covid19_confirmed_global.csv Colombia 3-16-3/20;4/18;5/28-7/16/2020     Update from contemporaneous reporting of Instituto Nacional De Salud
354 354 7/17/2020 time_series_covid19_deaths_global.csv Colombia 3-16-3/20;4/18;5/28-7/16/2020     Update from contemporaneous reporting of Instituto Nacional De Salud
418 418 7/31/2020 time_series_covid19_confirmed_global.csv Colombia 7/30/2020     Update Colombia from INDS
419 419 7/31/2020 time_series_covid19_deaths_global.csv Colombia 7/30/2020     Update Colombia from INDS
420 420 7/31/2020 time_series_covid19_recovered_global.csv Colombia 7/30/2020     Update Colombia from INDS
429 429 8/3/2020 time_series_covid19_confirmed_global.csv Colombia 7/26/2020     Update Colombia from MS
430 430 8/3/2020 time_series_covid19_deaths_global.csv Colombia 7/26/2020     Update Colombia from DOH
431 431 8/3/2020 time_series_covid19_recovered_global.csv Colombia 7/26/2020     Update Colombia from DOH
496 496 9/08/2020 time_series_covid19_confirmed_global.csv Colombia 8/22/2020 522138 533103 Update from Colombia news source
497 497 9/08/2020 time_series_covid19_confirmed_global.csv Colombia 9/04/2020 641574 650063 Update from Colombia news source
498 498 9/08/2020 time_series_covid19_confirmed_global.csv Colombia 9/05/2020 650055 658456 Update from Colombia news source
499 499 9/08/2020 time_series_covid19_confirmed_global.csv Colombia 9/07/2020 666521 671848 Update from Colombia news source
500 500 9/08/2020 time_series_covid19_deaths_global.csv Colombia 8/22/2020 16568 16968 Update from Colombia news source
501 501 9/08/2020 time_series_covid19_deaths_global.csv Colombia 9/04/2020 20618 20888 Update from Colombia news source
502 502 9/08/2020 time_series_covid19_deaths_global.csv Colombia 9/05/2020 20886 21156 Update from Colombia news source
503 503 9/08/2020 time_series_covid19_deaths_global.csv Colombia 9/07/2020 21412 21615 Update from Colombia news source
504 504 9/08/2020 time_series_covid19_recovered_global.csv Colombia 8/22/2020 348940 359792 Update from Colombia news source
505 505 9/08/2020 time_series_covid19_recovered_global.csv Colombia 9/04/2020 489151 498221 Update from Colombia news source
506 506 9/08/2020 time_series_covid19_recovered_global.csv Colombia 9/05/2020 498219 507770 Update from Colombia news source
507 507 9/08/2020 time_series_covid19_recovered_global.csv Colombia 9/07/2020 518229 529279 Update from Colombia news source
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
478 478 8/22/2020 time_series_covid19_deaths_US.csv Colorado 8/21/2020     Update from CO DPH
242 242 6/16/2020 time_series_covid19_confirmed_US.csv Columbia-Oregon 6/14/2020 20 22 Delayed update from Oregon Health Authority
3 3 4/7/2020 time_series_covid19_confirmed_US.csv DC, US 3/21/2020 0 98 New York Times
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
351 351 7/16/2020 time_series_covid19_deaths_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
14 14 4/9/2020 time_series_covid19_confirmed_US.csv Davidson, TN 4/2/2020 617 785 New York Times
51 51 4/19/2020 time_series_covid19_confirmed_US.csv Davidson, Tennessee 4/16/2020 1492 1283  
11 11 4/9/2020 time_series_covid19_confirmed_US.csv Daviess, KY 3/28/2020 33 20 New York Times
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
397 397 7/28/2020 time_series_covid19_confirmed_US.csv District of Columbia 7/27/2020     Update DC from DC gov
398 398 7/28/2020 time_series_covid19_deaths_US.csv District of Columbia 7/27/2020     Update DC from DC gov
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
15 15 4/13/2020 time_series_covid19_confirmed_global.csv Florida 4/13/2020 682619 580619 data source error
20 20 4/16/2020 time_series_covid19_deaths_global.csv France 4/1/2020 4032 4403 add 371 decesEhpad
21 21 4/16/2020 time_series_covid19_confirmed_global.csv France 4/4/2020 89953 68605 only report casConfirmes
22 22 4/16/2020 time_series_covid19_confirmed_global.csv France 4/5/2020 92839 70478  

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
);