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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ Update Date File Location Field Updated Old New Comments
101 101 4/23/2020 time_series_covid19_confirmed_global.csv US 4/22/2020 839675 840351 adjust for Benton and Franklin, WA
102 102 4/23/2020 time_series_covid19_deaths_global.csv US 4/22/2020 46583 46622 adjust for Benton and Franklin, WA
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
105 105 4/25/2020 time_series_covid19_confirmed_global.csv Ukraine 4/24/2020 8125 7647 adjust 5 min ahead
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)
128 128 5/6/2020 time_series_covid19_deaths_us.csv 84029113, Lincoln, Missouri 4/27/2020 41 1 correction
129 129 5/6/2020 times_series_covid19_deaths_global.csv US 4/27/2020 56259 56219  
130 130 5/7/2020 time_series_covid19_confirmed_global.csv Bolivia 4/28/2020 1014 1053 Shift datat 3-4 hours later to remove the spikes
131 131 5/7/2020 time_series_covid19_confirmed_global.csv Bolivia 4/30/2020 1110 1167 Shift datat 3-4 hours later to remove the spikes
132 132 5/7/2020 time_series_covid19_confirmed_global.csv Bolivia 5/2/2020 1229 1470 Shift datat 3-4 hours later to remove the spikes
133 133 5/7/2020 time_series_covid19_deaths_global.csv Bolivia 4/28/2020 53 55 Shift datat 3-4 hours later to remove the spikes
134 134 5/7/2020 time_series_covid19_deaths_global.csv Bolivia 4/30/2020 59 62 Shift datat 3-4 hours later to remove the spikes
135 135 5/7/2020 time_series_covid19_deaths_global.csv Bolivia 5/2/2020 66 71 Shift datat 3-4 hours later to remove the spikes
136 136 5/7/2020 time_series_covid19_recovered_global.csv Bolivia 4/28/2020 98 110 Shift datat 3-4 hours later to remove the spikes
137 137 5/7/2020 time_series_covid19_recovered_global.csv Bolivia 4/30/2020 117 132 Shift datat 3-4 hours later to remove the spikes
138 138 5/7/2020 time_series_covid19_recovered_global.csv Bolivia 5/2/2020 134 159 Shift datat 3-4 hours later to remove the spikes
139 139 5/7/2020 time_series_covid19_confirmed_global.csv West Bank and Gaza 4/12/2020 290 271 Update historical numbers to match the official report
140 140 5/7/2020 time_series_covid19_confirmed_global.csv West Bank and Gaza 4/13/2020 308 273 without cases from occupied Jerusalem or East Jerusalem
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  
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
164 164 5/9/2020 time_series_covid19_confirmed_US.csv Virginia, US 5/6/2020 20257 20985 All counties data updated
165 165 5/9/2020 time_series_covid19_deaths_US.csv Virginia, US 5/6/2020 713 737 according to https://www.vdh.virginia.gov/coronavirus/
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  
168 168 5/10/2020 time_series_covid19_recovered_global.csv Uruguay 04/01/20-04/22/20     Recovered adjusted to match national statistics
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
170 170 5/10/2020 time_series_covid19_confirmed_global.csv Uruguay 03/13/20-04/23/20     Confirmed adjusted to match national statistics
171 171 5/11/2020 time_series_covid19_confirmed_global.csv Spain 5/1/2020 213435 215216  
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
176 176 5/21/2020 time_series_covid19_confirmed_global.csv Italy 3/12/2020 12462 15113 remove spike
177 177 5/21/2020 time_series_covid19_deaths_global.csv Italy 3/12/2020 827 1016 remove spike
178 178 5/27/2020 time_series_covid19_recovered_global.csv Netherlands all     all recovered data removed
179 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 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
181 181 5/27/2020 time_series_covid19_recovered_global.csv France 5/22/20;05/23/20 62216;62216 62557;62893 stale data over weekend
182 182 5/28/2020 time_series_covid19_deaths_US.csv Siskiyou County, CA 5/22/20;05/23/20;05/24/20;05/25/20;05/26/20;05/27/20 1 0 miscount
183 183 5/28/2020 time_series_covid19_deaths_global.csv   5/22/20;05/23/20;05/24/20;05/25/20;05/26/20;05/27/20   -1 correction for Siskiyou, CA
184 184 6/1/2020 time_series_covid19_confirmed_global.csv Peru 4/28/2020 141779 148285 Stale overnight update
185 185 6/1/2020 time_series_covid19_deaths_global.csv Peru 4/28/2020 4099 4230 Stale overnight update
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
190 190 6/4/2020 time_series_covid19_confirmed_global.csv France 6/3/2020 110906 188836 probable case update
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
195 195 6/6/2020 time_series_covid19_recovered_global.csv Brazil 6/5/2020 0 266940 update per returned data
196 196 6/6/2020 time_series_covid19_deaths_global.csv Brazil 6/5/2020 34021 35026 update per returned data
197 197 6/6/2020 time_series_covid19_confirmed_global.csv Brazil 6/5/2020 614941 645771 update per returned data
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

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