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 Comments

✎ 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 ▼
17 17 4/14/2020 time_series_covid19_deaths_US.csv Unassigned, NY 4/3/2020 955 623  
18 18 4/14/2020 time_series_covid19_deaths_US.csv Unassigned, NY 4/4/2020 1173 427  
19 19 4/14/2020 time_series_covid19_deaths_US.csv Unassigned, NY 4/5/2020 1260 338  
22 22 4/16/2020 time_series_covid19_confirmed_global.csv France 4/5/2020 92839 70478  
23 23 4/16/2020 time_series_covid19_confirmed_global.csv France 4/6/2020 98010 74390  
24 24 4/16/2020 time_series_covid19_confirmed_global.csv France 4/7/2020 109069 78167  
25 25 4/16/2020 time_series_covid19_confirmed_global.csv France 4/8/2020 112950 82048  
26 26 4/16/2020 time_series_covid19_confirmed_global.csv France 4/9/2020 117749 86334  
27 27 4/16/2020 time_series_covid19_confirmed_global.csv France 4/10/2020 124869 90676  
28 28 4/16/2020 time_series_covid19_confirmed_global.csv France 4/11/2020 129654 93790  
30 30 4/16/2020 time_series_covid19_confirmed_global.csv France 4/13/2020 136779 124298  
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  
37 37 4/16/2020 time_series_covid19_confirmed_global.csv US 4/11/2020 20463 20462  
38 38 4/16/2020 time_series_covid19_confirmed_global.csv US 4/12/2020 22020 22019  
39 39 4/16/2020 time_series_covid19_confirmed_global.csv US 4/13/2020 23529 23528  
40 40 4/16/2020 time_series_covid19_confirmed_global.csv US 4/14/2020 25832 25831  
41 41 4/16/2020 time_series_covid19_confirmed_global.csv US 4/15/2020 28326 28325  
42 42 4/16/2020 time_series_covid19_confirmed_global.csv US 4/16/2020 32917 32916  
45 45 4/18/2020 time_series_covid19_confirmed_global.csv US 4/7/2020 396223 397505  
46 46 4/18/2020 time_series_covid19_deaths_global.csv US 4/7/2020 12722 12794  
49 49 4/18/2020 time_series_covid19_confirmed_global.csv US 4/9/2020 461437 462780  
50 50 4/18/2020 time_series_covid19_deaths_global.csv US 4/9/2020 16478 16544  
51 51 4/19/2020 time_series_covid19_confirmed_US.csv Davidson, Tennessee 4/16/2020 1492 1283  
52 52 4/19/2020 time_series_covid19_confirmed_global.csv US 4/16/2020 667801 667592  
129 129 5/6/2020 times_series_covid19_deaths_global.csv US 4/27/2020 56259 56219  
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  
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  
171 171 5/11/2020 time_series_covid19_confirmed_global.csv Spain 5/1/2020 213435 215216  
508 508 9/25/2020 time_series_covid19_confirmed_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
509 509 9/25/2020 time_series_covid19_deaths_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
510 510 9/25/2020 time_series_covid19_confirmed_global.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
511 511 9/25/2020 time_series_covid19_deaths_global.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
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
542 542 10/27/2020 time_series_covid19_confirmed_global.csv US 3/13-10/26/2020     Add Alaska non-resident cases
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
218 218 6/10/2020 time_series_covid19_confirmed_global.csv Pakistan 6/7/2020   103671 Added data for date
219 219 6/10/2020 time_series_covid19_deaths_global.csv Pakistan 6/7/2020   2067 Added data for date
220 220 6/10/2020 time_series_covid19_recovered_global.csv Pakistan 6/7/2020   34355 Added data for date
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
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
558 558 11/04/2020 time_series_covid19_cases_global.csv Germany 10/23/24/28 and 11/1     Adjust update time
559 559 11/04/2020 time_series_covid19_deaths_global.csv Germany 10/23/28 and 11/1     Adjust update time
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
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
446 446 8/6/2020 time_series_covid19_deaths_global.csv US 3/7-8/5/2020     Alignment of Harris County to state
445 445 8/6/2020 time_series_covid19_deaths_US.csv Harris, Texas 3/7-8/5/2020     Alignment of Harris County to state
164 164 5/9/2020 time_series_covid19_confirmed_US.csv Virginia, US 5/6/2020 20257 20985 All counties data updated
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
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.
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.
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.
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.
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.
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
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.
170 170 5/10/2020 time_series_covid19_confirmed_global.csv Uruguay 03/13/20-04/23/20     Confirmed adjusted to match national statistics
1004 1004 02/15/2021 time_series_covid19_confirmed_global.csv Ireland 01/28/2021 193645 192645 Correct Ireland data based on national reporting
1027 1027 02/22/2021 time_series_covid19_confirmed_global.csv Israel 01/25/2021 613340 601069 Correct Israel confirmed data
1028 1028 02/22/2021 time_series_covid19_confirmed_global.csv Israel 01/26/2021 617168 609656 Correct Israel confirmed data
1029 1029 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/01/2021 3342 3540 Correct Japan deaths data
1030 1030 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/02/2021 3369 3571 Correct Japan deaths data
1031 1031 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/03/2021 3429 3631 Correct Japan deaths data
1032 1032 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/04/2021 3472 3679 Correct Japan deaths data
1033 1033 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/05/2021 3548 3755 Correct Japan deaths data
1034 1034 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/06/2021 3609 3820 Correct Japan deaths data
1035 1035 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/07/2021 3674 3884 Correct Japan deaths data
1036 1036 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/08/2021 3746 3962 Correct Japan deaths data
1037 1037 02/25/2021 time_series_covid19_deaths_global.csv Japan 01/09/2021 3805 4021 Correct Japan 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
);