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 New

✎ 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
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
84 84 4/22/2020 time_series_covid19_deaths_US.csv Navajo, 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
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
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
90 90 4/22/2020 time_series_covid19_confirmed_US.csv US 4/21/2020     correction for US federal data
91 91 4/22/2020 time_series_covid19_deaths_US.csv US 4/21/2020     correction for US federal data
92 92 4/22/2020 time_series_covid19_confirmed_global.csv US 4/21/2020     correction for US federal data
93 93 4/22/2020 time_series_covid19_deaths_global.csv US 4/21/2020     correction for US federal data
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
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
107 107 4/26/2020 time_series_covid19_recovered_global.csv New South Wales - 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
109 109 4/26/2020 time_series_covid19_recovered_global.csv Northern Territory - Australia 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20     Replace recovered cases
110 110 4/26/2020 time_series_covid19_recovered_global.csv South Australia - Australia 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20     Replace recovered cases
111 111 4/26/2020 time_series_covid19_recovered_global.csv Tasmania - Australia 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20;04/26/20     Replace recovered cases
112 112 4/26/2020 time_series_covid19_recovered_global.csv Victoria - Australia 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20     Replace recovered cases
113 113 4/26/2020 time_series_covid19_recovered_global.csv Western Australia - Australia 04/20/20;04/21/20;04/22/20;04/23/20;04/24/20;04/25/20     Replace recovered cases
114 114 4/27/2020 time_series_covid19_confirmed_global.csv Mexico 03/13/20;04/22/20     Remove duplicate entry on 13/3/20; add 10544 cases on 22/4; adjust 11632 to 12872
115 115 4/27/2020 times_series_covid19_deaths_global.csv Mexico 03/20/20;04/22/20     Remove duplicate entry on 3/20/20; add 970 deaths on 22/4; adjust 1069 to 1221
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
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
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
119 119 4/30/2020 time_series_covid19_recovered_global.csv Spain 04/26/20;04/27/20;04/28/20;04/29/20     Recovered adjusted to match official 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.
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.
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.
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.
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.
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.
126 126 5/2/2020 time_series_covid19_deaths_global.csv France 4/14-5/01     Deaths updated to remove double counts of deaths in DROM. Logic = France, France entry for date - sum(deaths in DROM for date)
127 127 5/2/2020 time_series_covid19_recovered_global.csv France 4/14-5/01     Recovered updated to remove double counts of recoveries in DROM. Logic = France, France entry for date - sum(recoveries in DROM for date)
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
163 163 5/7/2020 time_series_covid19_deaths_US.csv Weber and Weber-Morgan, Utah before 4/19     transfer data from Weber to Weber-Morgan, Utah
168 168 5/10/2020 time_series_covid19_recovered_global.csv Uruguay 04/01/20-04/22/20     Recovered adjusted to match national statistics
170 170 5/10/2020 time_series_covid19_confirmed_global.csv Uruguay 03/13/20-04/23/20     Confirmed adjusted to match national statistics
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
174 174 5/20/2020 time_series_covid19_confirmed_global.csv US 03/05/20-04/20/20     correction made due to CO data update
175 175 5/20/2020 time_series_covid19_deaths_global.csv US 03/12/20-04/20/20     correction made due to CO data update
178 178 5/27/2020 time_series_covid19_recovered_global.csv Netherlands all     all recovered data removed
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
192 192 6/5/2020 time_series_covid19_recovered_global.csv Sweden 01/22/20-06/04/20     updated recovered case counts in line with data modification record
193 193 6/6/2020 time_series_covid19_confirmed_US.csv US 6/5/2020     Type change for daily data from float to int
194 194 6/6/2020 time_series_covid19_deaths_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
209 209 6/8/2020 time_series_covid19_deaths_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
213 213 6/10/2020 time_series_covid19_deaths_US.csv Michigan 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20     Updated all Michigan counties
214 214 6/10/2020 time_series_covid19_confirmed_global.csv US 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20     Updated for Michigan
215 215 6/10/2020 time_series_covid19_deaths_global.csv US 06/05/20;06/06/20;06/07/20;06/08/20;06/09/20     Updated for Michigan
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
232 232 6/12/2020 time_series_covid19_confirmed_global.csv US all days     county sum = country total
233 233 6/12/2020 time_series_covid19_deaths_global.csv US all days     county sum = country total
234 234 6/13/2020 time_series_covid19_confirmed_US.csv Michigan 03/12/20-06/10/20     Revision for Michigan historical probables
235 235 6/13/2020 time_series_covid19_deaths_US.csv Michigan 03/12/20-06/10/20     Revision for Michigan historical probables
236 236 6/13/2020 time_series_covid19_confirmed_global.csv US 03/12/20-06/10/20     Revision for Michigan historical probables
237 237 6/13/2020 time_series_covid19_deaths_global.csv US 03/12/20-06/10/20     Revision for Michigan historical probables
238 238 6/15/2020 time_series_covid19_confirmed_global.csv India 06/11/20;06/12/20;06/13/20;06/14/20     Remove time lag from data
239 239 6/15/2020 time_series_covid19_deaths_global.csv India 06/10/20;06/11/20;06/12/20;06/13/20;06/14/20     Remove time lag from data
240 240 6/15/2020 time_series_covid19_recovered_global.csv India 06/11/20;06/12/20;06/13/20;06/14/20     Remove time lag from data
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
266 266 6/20/2020 time_series_covid19_confirmed_global.csv US 06/18/20;06/19/20     Corrections for NC duplication
267 267 6/20/2020 time_series_covid19_deaths_global.csv US 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
270 270 6/22/2020 time_series_covid19_confirmed_global.csv US 6/21/2020     Corrections for NC duplication
271 271 6/22/2020 time_series_covid19_deaths_global.csv US 6/21/2020     Corrections for NC duplication
272 272 6/22/2020 time_series_covid19_confirmed_global.csv Sweden 06/19/20;06/20/20;06/21/20     Corrections for Sweden duplication
273 273 6/22/2020 time_series_covid19_deaths_global.csv Sweden 06/19/20;06/20/20;06/21/20     Corrections for Sweden duplication
275 275 6/23/2020 time_series_covid19_confirmed_global.csv Peru 06/19/20;06/21/20     Corrections for source update delay
276 276 6/23/2020 time_series_covid19_deaths_global.csv Peru 06/19/20;06/21/20     Corrections for source update delay
277 277 6/23/2020 time_series_covid19_recovered_global.csv Peru 06/19/20;06/21/20     Corrections for source update delay
278 278 6/24/2020 time_series_covid19_confirmed_US.csv Oregon 6/20/2020     Corrections for Oregon weekend update
279 279 6/24/2020 time_series_covid19_deaths_US.csv Oregon 6/20/2020     Corrections for Oregon weekend update
280 280 6/24/2020 time_series_covid19_confirmed_global.csv US 6/20/2020     Corrections for Oregon weekend update
281 281 6/24/2020 time_series_covid19_deaths_global.csv US 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
283 283 6/25/2020 time_series_covid19_deaths_US.csv Iowa 6/24/2020     Corrections for Iowa duplication
284 284 6/25/2020 time_series_covid19_confirmed_global.csv US 6/24/2020     Corrections for Iowa duplication
285 285 6/25/2020 time_series_covid19_deaths_global.csv US 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
287 287 6/25/2020 time_series_covid19_deaths_US.csv NV 6/23/2020     Corrections for Nevada duplication
288 288 6/25/2020 time_series_covid19_confirmed_global.csv US 6/23/2020     Corrections for Nevada duplication
289 289 6/25/2020 time_series_covid19_deaths_global.csv US 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
292 292 6/30/2020 time_series_covid19_confirmed_global.csv US 6/29/2020     Update for stale NYC 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
);