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 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
585 585 11/13/2020 time_series_covi19_confirmed_global India       Updated from India MOHW
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
557 557 11/03/2020 time_series_covid19_cases_global.csv Colombia 11/02/2020 1004308 1093256 Update using official data
558 558 11/04/2020 time_series_covid19_cases_global.csv Germany 10/23/24/28 and 11/1     Adjust update time
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

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