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

511 rows sorted by Field Updated

View and edit SQL

Suggested facets: File

Link rowid Update Date File Location Field Updated ▼ Old New Comments
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
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
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
174 5/20/2020 time_series_covid19_confirmed_global.csv US 03/05/20-04/20/20     correction made due to CO data update
227 6/12/2020 time_series_covid19_confirmed_US.csv St. Louis County 03/09/20-06/11/2020     Change data source
301 7/1/2020 time_series_covid19_confirmed_US.csv Ventura, California 03/10/20-06/20/20     Updates to Ventura County
302 7/1/2020 time_series_covid19_confirmed_global.csv US 03/10/20-06/20/20     Updates to Ventura County
295 7/1/2020 time_series_covid19_deaths_US.csv NYC 03/11/20-06/28/20     Update according to nychealth
296 7/1/2020 time_series_covid19_deaths_global.csv US 03/11/20-06/28/20     Update according to nychealth
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
175 5/20/2020 time_series_covid19_deaths_global.csv US 03/12/20-04/20/20     correction made due to CO data update
234 6/13/2020 time_series_covid19_confirmed_US.csv Michigan 03/12/20-06/10/20     Revision for Michigan historical probables
235 6/13/2020 time_series_covid19_deaths_US.csv Michigan 03/12/20-06/10/20     Revision for Michigan historical probables
236 6/13/2020 time_series_covid19_confirmed_global.csv US 03/12/20-06/10/20     Revision for Michigan historical probables
237 6/13/2020 time_series_covid19_deaths_global.csv US 03/12/20-06/10/20     Revision for Michigan historical probables
170 5/10/2020 time_series_covid19_confirmed_global.csv Uruguay 03/13/20-04/23/20     Confirmed adjusted to match national statistics
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
229 6/12/2020 time_series_covid19_confirmed_US.csv St. Louis City 03/16/20-06/11/2020     Change data source
228 6/12/2020 time_series_covid19_deaths_US.csv St. Louis County 03/20/20-06/11/2020     Change data source
230 6/12/2020 time_series_covid19_deaths_US.csv St. Louis City 03/20/20-06/11/2020     Change data source
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
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
168 5/10/2020 time_series_covid19_recovered_global.csv Uruguay 04/01/20-04/22/20     Recovered adjusted to match national statistics
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 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 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 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 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 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 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 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
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
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 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 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.
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 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 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
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 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
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 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 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
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 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 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.
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 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
179 5/27/2020 time_series_covid19_confirmed_global.csv France 05/22/20;05/23/20 179306;179306 179645;179964 stale data over weekend
180 5/27/2020 time_series_covid19_deaths_global.csv France 05/22/20;05/23/20 28167;28167 28241;28284 stale data over weekend
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
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
300 7/1/2020 time_series_covid19_confirmed_global.csv US 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
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 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 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 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
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
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
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
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
304 7/2/2020 time_series_covid19_deaths_US.csv Missouri 06/13/20-07/01/20     Updates to Missouri
306 7/2/2020 time_series_covid19_deaths_global.csv Missouri 06/13/20-07/01/20     Updates to Missouri
308 7/2/2020 time_series_covid19_deaths_US.csv Massachusetts 06/16/20-07/01/20     Updates to Massachusetts
310 7/2/2020 time_series_covid19_deaths_global.csv Massachusetts 06/16/20-07/01/20     Updates to Massachusetts
264 6/20/2020 time_series_covid19_confirmed_US.csv North Carolina 06/18/20;06/19/20     Corrections for NC duplication
265 6/20/2020 time_series_covid19_confirmed_US.csv North Carolina 06/18/20;06/19/20     Corrections for NC duplication
266 6/20/2020 time_series_covid19_confirmed_global.csv US 06/18/20;06/19/20     Corrections for NC duplication
267 6/20/2020 time_series_covid19_deaths_global.csv US 06/18/20;06/19/20     Corrections for NC duplication
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 6/22/2020 time_series_covid19_deaths_global.csv Sweden 06/19/20;06/20/20;06/21/20     Corrections for Sweden duplication
275 6/23/2020 time_series_covid19_confirmed_global.csv Peru 06/19/20;06/21/20     Corrections for source update delay
276 6/23/2020 time_series_covid19_deaths_global.csv Peru 06/19/20;06/21/20     Corrections for source update delay
277 6/23/2020 time_series_covid19_recovered_global.csv Peru 06/19/20;06/21/20     Corrections for source update delay
305 7/2/2020 time_series_covid19_confirmed_global.csv Missouri 06/27/20-07/01/20     Updates to Missouri
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
508 09/25/2020 time_series_covid19_confirmed_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
509 09/25/2020 time_series_covid19_deaths_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
510 09/25/2020 time_series_covid19_confirmed_global.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
511 09/25/2020 time_series_covid19_deaths_global.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
324 7/8/2020 time_series_covid19_deaths_global.csv Japan 2/13-5/27/2020     Update according to covid19japan
313 7/3/2020 time_series_covid19_confirmed_global.csv United Kingdom 2/3-7/2/2020     Correction according to the official reports
323 7/8/2020 time_series_covid19_confirmed_global.csv Japan 2/5-5/27/2020     Update according to covid19japan
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 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
176 5/21/2020 time_series_covid19_confirmed_global.csv Italy 3/12/2020 12462 15113 remove spike
177 5/21/2020 time_series_covid19_deaths_global.csv Italy 3/12/2020 827 1016 remove spike
401 7/28/2020 time_series_covid19_confirmed_global.csv Kosovo 3/14-7/26/2020     Update Kosovo from IKSHPK and other sources
402 7/28/2020 time_series_covid19_deaths_global.csv Kosovo 3/14-7/26/2020     Update Kosovo from IKSHPK and other sources
403 7/28/2020 time_series_covid19_recovered_global.csv Kosovo 3/14-7/26/2020     Update Kosovo from IKSHPK and other sources
404 7/29/2020 time_series_covid19_confirmed_global.csv Peru 3/14-7/26/2020     Update Peru from MINSA
405 7/29/2020 time_series_covid19_deaths_global.csv Peru 3/14-7/26/2020     Update Peru from MINSA
442 8/5/2020 time_series_covid19_deaths_global.csv US 3/17-6/24/2020     Internal consistency for US
4 4/7/2020 time_series_covid19_confirmed_US.csv Miami-Dade, FL 3/19/2020 0 101 New York Times
5 4/7/2020 time_series_covid19_confirmed_US.csv Miami-Dade, FL 3/20/2020 0 124 New York Times
7 4/7/2020 time_series_covid19_confirmed_US.csv Harris, TX 3/20/2020 0 55 New York Times
9 4/9/2020 time_series_covid19_confirmed_US.csv Box Elder, UT 3/20/2020 13 7 New York Times
3 4/7/2020 time_series_covid19_confirmed_US.csv DC, US 3/21/2020 0 98 New York Times
8 4/7/2020 time_series_covid19_confirmed_US.csv Kansas City 3/21/2020 0 13 New York Times
11 4/9/2020 time_series_covid19_confirmed_US.csv Daviess, KY 3/28/2020 33 20 New York Times

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