Errata

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

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

1,060 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
922 922 01/20/2021 time_series_covid19_confirmed_US.csv Adams, Washington, US 01/19/2021 1719 1721 Correct stale confirmed data
961 961 01/20/2021 time_series_covid19_deaths_US.csv Adams, Washington, US 01/19/2021 17 18 Correct stale deaths data
613 613 12/04/2020 time_series_covid19_global.csv Afghanistan 11/29/2020-12/03/2020     Update based on Afghanistan source
614 614 12/04/2020 time_series_covid19_deaths_global.csv Afghanistan 11/29/2020-12/03/2020     Update based on Afghanistan source
615 615 12/04/2020 time_series_covid19_recovered_global.csv Afghanistan 11/29/2020-12/03/2020     Update based on Afghanistan source
526 526 10/19/2020 time_series_covid19_confirmed_US.csv Alaska       Changed name from Lake and Peninsula to Bristol Bay plus Lake and Peninsula
527 527 10/19/2020 time_series_covid19_deaths_US.csv Alaska       Changed name from Lake and Peninsula to Bristol Bay to Bristol Bay plus Lake and Peninsula.
541 541 10/27/2020 time_series_covid19_confirmed_US.csv Alaska 3/13-10/26/2020     Add Alaska non-resident cases adjusted by the collection date
611 611 12/04/2020 time_series_covid19_confirmed_global.csv Alaska, US 12/02/2020-12/01/2020     Update based on AK total cases
612 612 12/04/2020 time_series_covid19_confirmed_US.csv Alaska, US 12/02/2020-12/01/2020     Update based on AK total cases
640 640 12/28/2020 time_series_covid19_confirmed_global.csv Alberta, Canada 12/24/2020-12/27/2020     Update from Government of Canada COVID-19 situation dashboard
641 641 12/29/2020 time_series_covid19_confirmed_global.csv Alberta, Canada 12/24/2020-12/27/2020     Update from Alberta Government COVID-19 records
642 642 12/29/2020 time_series_covid19_deaths_global.csv Alberta, Canada 12/24/2020-12/27/2020     Update from Alberta Government COVID-19 records
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
638 638 12/26/2020 time_series_covid19_confirmed_US.csv Arizona, US 12/24/2020     Update from Arizona state dashboard
923 923 01/20/2021 time_series_covid19_confirmed_US.csv Asotin, Washington, US 01/19/2021 1143 1147 Correct stale confirmed data
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/5/2020 time_series_covid19_confirmed_global.csv Bahamas 8/22/2020 1703 1765 Update from Bahamas press release
481 481 9/5/2020 time_series_covid19_confirmed_global.csv Bahamas 8/23/2020 1765 1784 Update from Bahamas press release
482 482 9/5/2020 time_series_covid19_confirmed_global.csv Bahamas 8/24/2020 1765 1798 Update from Bahamas press release
483 483 9/5/2020 time_series_covid19_confirmed_global.csv Bahamas 8/25/2020 1765 1813 Update from Bahamas press release
484 484 9/5/2020 time_series_covid19_confirmed_global.csv Bahamas 8/26/2020 1765 1923 Update from Bahamas press release
485 485 9/5/2020 time_series_covid19_confirmed_global.csv Bahamas 8/27/2020 1765 2020 Update from Bahamas press release
486 486 9/5/2020 time_series_covid19_deaths_global.csv Bahamas 8/23/2020 29 44 Update from Bahamas press release
487 487 9/5/2020 time_series_covid19_deaths_global.csv Bahamas 8/24/2020 29 46 Update from Bahamas press release
488 488 9/5/2020 time_series_covid19_deaths_global.csv Bahamas 8/25/2020 29 48 Update from Bahamas press release
489 489 9/5/2020 time_series_covid19_deaths_global.csv Bahamas 8/26/2020 29 48 Update from Bahamas press release
490 490 9/5/2020 time_series_covid19_recovered_global.csv Bahamas 8/22/2020 221 227 Update from Bahamas press release
491 491 9/5/2020 time_series_covid19_recovered_global.csv Bahamas 8/23/2020 227 634 Update from Bahamas press release
492 492 9/5/2020 time_series_covid19_recovered_global.csv Bahamas 8/24/2020 227 634 Update from Bahamas press release
493 493 9/5/2020 time_series_covid19_recovered_global.csv Bahamas 8/25/2020 227 634 Update from Bahamas press release
494 494 9/5/2020 time_series_covid19_recovered_global.csv Bahamas 8/26/2020 227 733 Update from Bahamas press release
495 495 9/5/2020 time_series_covid19_recovered_global.csv Bahamas 8/27/2020 227 742 Update from Bahamas press release
894 894 01/20/2021 time_series_covid19_confirmed_US.csv Baker, Oregon, US 01/19/2021 568 573 Correct stale confirmed data
712 712 01/12/2021 time_series_covid19_confirmed_global.csv Barnstable, Massachusetts, US 01/11/2021 6454 6569 Correct old confirmed data
737 737 01/12/2021 time_series_covid19_deaths_global.csv Barnstable, Massachusetts, US 01/11/2021 276 277 Correct old deaths data
1005 1005 02/16/2021 time_series_covid19_confirmed_US.csv Beadle, South Dakota, US 02/15/2021 2654 2655 Correct stale confirmed data
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)
895 895 01/20/2021 time_series_covid19_confirmed_US.csv Benton, Oregon, US 01/19/2021 1705 1720 Correct stale confirmed 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
98 98 4/23/2020 time_series_covid19_deaths_US.csv Benton, WA 4/22/2020 0 35 adjust for Benton and Franklin, WA
924 924 01/20/2021 time_series_covid19_confirmed_US.csv Benton, Washington, US 01/19/2021 13465 13529 Correct stale confirmed data
962 962 01/20/2021 time_series_covid19_deaths_US.csv Benton, Washington, US 01/19/2021 178 179 Correct stale deaths data
713 713 01/12/2021 time_series_covid19_confirmed_global.csv Berkshire, Massachusetts, US 01/11/2021 3543 3614 Correct old confirmed data
738 738 01/12/2021 time_series_covid19_deaths_global.csv Berkshire, Massachusetts, US 01/11/2021 163 164 Correct old deaths data
597 597 11/24/2020 time_series_covid19_confirmed_US.csv Bexar, Texas 11/23/2020 73882 74591 Daily update from county source
673 673 01/11/2021 time_series_covid19_confirmed_global.csv Bhutan 01/08/2021 767 771 Correct old confirmed data
676 676 01/11/2021 time_series_covid19_confirmed_global.csv Bhutan 01/09/2021 767 810 Correct old confirmed data
680 680 01/11/2021 time_series_covid19_confirmed_global.csv Bhutan 01/10/2021 767 813 Correct old confirmed data
700 700 01/11/2021 time_series_covid19_deaths_global.csv Bhutan 01/08/2021 0 1 Correct old deaths data
704 704 01/11/2021 time_series_covid19_deaths_global.csv Bhutan 01/09/2021 0 1 Correct old deaths data
708 708 01/11/2021 time_series_covid19_deaths_global.csv Bhutan 01/10/2021 0 1 Correct old deaths data
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
539 539 10/27/2020 time_series_covid19_deaths_global.csv Brazil 10/25/2020     Updated via https://github.com/wcota/covid19br/blob/e3b244d291c31e7ae5a9a0e7dd29b6ba5085bfce/cases-brazil-total.csv
540 540 10/27/2020 time_series_covid19_confirmed_global.csv Brazil 10/25/2020     Updated via https://github.com/wcota/covid19br/blob/e3b244d291c31e7ae5a9a0e7dd29b6ba5085bfce/cases-brazil-total.csv
714 714 01/12/2021 time_series_covid19_confirmed_global.csv Bristol, Massachusetts, US 01/11/2021 40820 41297 Correct old confirmed data
739 739 01/12/2021 time_series_covid19_deaths_global.csv Bristol, Massachusetts, US 01/11/2021 1164 1168 Correct old deaths data
1006 1006 02/16/2021 time_series_covid19_confirmed_US.csv Brown, South Dakota, US 02/15/2021 5062 5066 Correct stale confirmed data
982 982 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/24/2021 1570 1571 Correct Nova Scotia stale confirmed data
983 983 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/25/2021 1570 1571 Correct Nova Scotia stale confirmed data
984 984 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/26/2021 1570 1572 Correct Nova Scotia stale confirmed data
985 985 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/27/2021 1570 1576 Correct Nova Scotia stale confirmed data
986 986 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/28/2021 1570 1576 Correct Nova Scotia stale confirmed data
987 987 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/29/2021 1570 1577 Correct Nova Scotia stale confirmed data
988 988 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/30/2021 1570 1580 Correct Nova Scotia stale confirmed data
989 989 02/03/2021 time_series_covid19_confirmed_global.csv Canada 01/31/2021 1570 1580 Correct Nova Scotia stale confirmed data
990 990 02/03/2021 time_series_covid19_confirmed_global.csv Canada 02/01/2021 1570 1581 Correct Nova Scotia stale confirmed data
991 991 02/03/2021 time_series_covid19_confirmed_global.csv Canada 02/02/2021 1570 1582 Correct Nova Scotia stale confirmed data
992 992 02/08/2021 time_series_covid19_confirmed_global.csv Canada 01/27/2021 22646 22794 Correct Saskatchewan, Canada confirmed data
993 993 02/08/2021 time_series_covid19_confirmed_global.csv Canada 01/28/2021 22646 23038 Correct Saskatchewan, Canada confirmed data
994 994 02/08/2021 time_series_covid19_confirmed_global.csv Canada 01/29/2021 22646 23366 Correct Saskatchewan, Canada confirmed data
995 995 02/08/2021 time_series_covid19_confirmed_global.csv Canada 01/30/2021 22646 23626 Correct Saskatchewan, Canada confirmed data
996 996 02/08/2021 time_series_covid19_confirmed_global.csv Canada 01/31/2021 22646 23864 Correct Saskatchewan, Canada confirmed data
997 997 02/08/2021 time_series_covid19_deaths_global.csv Canada 01/27/2021 268 274 Correct Saskatchewan, Canada deaths data

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] INTEGER,
   [New] INTEGER,
   [Comments] TEXT
);