Errata

Table actions

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

511 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 09/25/2020 time_series_covid19_confirmed_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
509 509 09/25/2020 time_series_covid19_deaths_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
510 510 09/25/2020 time_series_covid19_confirmed_global.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
511 511 09/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
218 218 6/10/2020 time_series_covid19_confirmed_global.csv Pakistan 6/7/2020 N/A 103671 Added data for date
219 219 6/10/2020 time_series_covid19_deaths_global.csv Pakistan 6/7/2020 N/A 2067 Added data for date
220 220 6/10/2020 time_series_covid19_recovered_global.csv Pakistan 6/7/2020 N/A 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
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
170 170 5/10/2020 time_series_covid19_confirmed_global.csv Uruguay 03/13/20-04/23/20     Confirmed adjusted to match national statistics
341 341 7/15/2020 time_series_covid19_confirmed_US.csv Granville, NC 4/27/2020 240 133 Correction
342 342 7/15/2020 time_series_covid19_confirmed_global.csv US 4/27/2020 990999 990892 Correction
313 313 7/3/2020 time_series_covid19_confirmed_global.csv United Kingdom 2/3-7/2/2020     Correction according to the official reports
274 274 6/22/2020 time_series_covid19_confirmed_global.csv Brazil 6/20/2020 1032913 1067579 Correction for Brazil duplication
198 198 6/8/2020 time_series_covid19_deaths_US.csv Northern Mariana Islands, US 6/3/2020 16 14 Correction for Northern Mariana Islands, US
199 199 6/8/2020 time_series_covid19_deaths_US.csv Northern Mariana Islands, US 6/4/2020 16 14 Correction for Northern Mariana Islands, US
200 200 6/8/2020 time_series_covid19_deaths_US.csv Northern Mariana Islands, US 6/5/2020 16 14 Correction for Northern Mariana Islands, US
201 201 6/8/2020 time_series_covid19_deaths_US.csv Northern Mariana Islands, US 6/6/2020 17 15 Correction for Northern Mariana Islands, US
202 202 6/8/2020 time_series_covid19_deaths_US.csv Northern Mariana Islands, US 6/7/2020 19 17 Correction for Northern Mariana Islands, US
203 203 6/8/2020 time_series_covid19_deaths_global.csv US 6/3/2020 107175 107161 Correction for Northern Mariana Islands, US
204 204 6/8/2020 time_series_covid19_deaths_global.csv US 6/4/2020 108211 108197 Correction for Northern Mariana Islands, US
205 205 6/8/2020 time_series_covid19_deaths_global.csv US 6/5/2020 109132 109118 Correction for Northern Mariana Islands, US
206 206 6/8/2020 time_series_covid19_deaths_global.csv US 6/6/2020 109802 109787 Correction for Northern Mariana Islands, US
207 207 6/8/2020 time_series_covid19_deaths_global.csv US 6/7/2020 110514 110497 Correction for Northern Mariana Islands, US
186 186 6/2/2020 time_series_covid19_confirmed_global.csv US 6/1/2020 1811360 1811020 Correction for Unassigned Oklahoma
187 187 6/2/2020 time_series_covid19_deaths_global.csv US 6/1/2020 105165 105149 Correction for Unassigned Oklahoma
188 188 6/2/2020 time_series_covid19_confirmed_US.csv US 6/1/2020 383 43 Correction for Unassigned Oklahoma
189 189 6/2/2020 time_series_covid19_deaths_US.csv US 6/1/2020 16 0 Correction for Unassigned Oklahoma

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