05-08-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily 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: README

3,232 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
201 201 13023 Bleckley Georgia US 2020-05-09 02:32:35 32.43829035 -83.33035166 26 0 0 26 Bleckley, Georgia, US
202 202 47007 Bledsoe Tennessee US 2020-05-09 02:32:35 35.59942968 -85.20611967 604 0 0 604 Bledsoe, Tennessee, US
203 203 1009 Blount Alabama US 2020-05-09 02:32:35 33.98210918 -86.56790593 47 0 0 44 Blount, Alabama, US
204 204 47009 Blount Tennessee US 2020-05-09 02:32:35 35.68938198 -83.92847788 69 3 0 66 Blount, Tennessee, US
205 205 27013 Blue Earth Minnesota US 2020-05-09 02:32:35 44.03554215 -94.06699781 55 0 0 55 Blue Earth, Minnesota, US
206 206 28011 Bolivar Mississippi US 2020-05-09 02:32:35 33.79696941 -90.87372121 118 8 0 110 Bolivar, Mississippi, US
207 207 29017 Bollinger Missouri US 2020-05-09 02:32:35 37.32449052 -90.02725304 4 0 0 4 Bollinger, Missouri, US
208 208 46009 Bon Homme South Dakota US 2020-05-09 02:32:35 42.98914167 -97.88592746 4 0 0 4 Bon Homme, South Dakota, US
209 209 17005 Bond Illinois US 2020-05-09 02:32:35 38.88829622 -89.43534887 8 1 0 7 Bond, Illinois, US
210 210 16017 Bonner Idaho US 2020-05-09 02:32:35 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
211 211 16019 Bonneville Idaho US 2020-05-09 02:32:35 43.38713372 -111.6161537 28 0 0 28 Bonneville, Idaho, US
212 212 5009 Boone Arkansas US 2020-05-09 02:32:35 36.3084504 -93.09374925 4 0 0 4 Boone, Arkansas, US
213 213 17007 Boone Illinois US 2020-05-09 02:32:35 42.32359279 -88.82345779 177 12 0 165 Boone, Illinois, US
214 214 18011 Boone Indiana US 2020-05-09 02:32:35 40.0509304 -86.46841646 214 27 0 187 Boone, Indiana, US
215 215 19015 Boone Iowa US 2020-05-09 02:32:35 42.03657094 -93.9313999 33 0 0 33 Boone, Iowa, US
216 216 21015 Boone Kentucky US 2020-05-09 02:32:35 38.97065142 -84.72615357 203 4 0 199 Boone, Kentucky, US
217 217 29019 Boone Missouri US 2020-05-09 02:32:35 38.99186229 -92.30723575 98 1 0 97 Boone, Missouri, US
218 218 31011 Boone Nebraska US 2020-05-09 02:32:35 41.70759415 -98.06737183 2 0 0 2 Boone, Nebraska, US
219 219 54005 Boone West Virginia US 2020-05-09 02:32:35 38.01974191 -81.69888019 8 0 0 8 Boone, West Virginia, US
220 220 48035 Bosque Texas US 2020-05-09 02:32:35 31.89978581 -97.63613524 5 0 0 5 Bosque, Texas, US
221 221 22015 Bossier Louisiana US 2020-05-09 02:32:35 32.67932307 -93.60460152 308 19 0 289 Bossier, Louisiana, US
222 222 51023 Botetourt Virginia US 2020-05-09 02:32:35 37.55531756 -79.80982182 30 3 0 27 Botetourt, Virginia, US
223 223 8013 Boulder Colorado US 2020-05-09 02:32:35 40.09313619 -105.3546767 743 50 0 693 Boulder, Colorado, US
224 224 16021 Boundary Idaho US 2020-05-09 02:32:35 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
225 225 20011 Bourbon Kansas US 2020-05-09 02:32:35 37.85508555 -94.84865997 6 1 0 5 Bourbon, Kansas, US
226 226 21017 Bourbon Kentucky US 2020-05-09 02:32:35 38.2054607 -84.21827874 8 1 0 7 Bourbon, Kentucky, US
227 227 48037 Bowie Texas US 2020-05-09 02:32:35 33.44626922 -94.41834132 76 2 0 74 Bowie, Texas, US
228 228 38011 Bowman North Dakota US 2020-05-09 02:32:35 46.11285362 -103.5203343 1 0 0 1 Bowman, North Dakota, US
229 229 31013 Box Butte Nebraska US 2020-05-09 02:32:35 42.22079243 -103.0878834 1 0 0 1 Box Butte, Nebraska, US
230 230 21019 Boyd Kentucky US 2020-05-09 02:32:35 38.36176608 -82.68652187 32 3 0 29 Boyd, Kentucky, US
231 231 21021 Boyle Kentucky US 2020-05-09 02:32:35 37.62680923 -84.8633779 16 0 0 16 Boyle, Kentucky, US
232 232 21023 Bracken Kentucky US 2020-05-09 02:32:35 38.69158994 -84.08532444 10 0 0 10 Bracken, Kentucky, US
233 233 12007 Bradford Florida US 2020-05-09 02:32:35 29.95079741 -82.16611613 48 2 0 46 Bradford, Florida, US
234 234 42015 Bradford Pennsylvania US 2020-05-09 02:32:35 41.78869215 -76.51570822 37 2 0 35 Bradford, Pennsylvania, US
235 235 5011 Bradley Arkansas US 2020-05-09 02:32:35 33.46755808 -92.15980837 11 1 0 10 Bradley, Arkansas, US
236 236 47011 Bradley Tennessee US 2020-05-09 02:32:35 35.15739424 -84.857186 68 1 0 67 Bradley, Tennessee, US
237 237 26023 Branch Michigan US 2020-05-09 02:32:35 41.91600556 -85.05929476 76 2 0 74 Branch, Michigan, US
238 238 13025 Brantley Georgia US 2020-05-09 02:32:35 31.19576557 -81.97743999 23 2 0 21 Brantley, Georgia, US
239 239 54007 Braxton West Virginia US 2020-05-09 02:32:35 38.70036159 -80.72011184 2 0 0 2 Braxton, West Virginia, US
240 240 48039 Brazoria Texas US 2020-05-09 02:32:35 29.18757369 -95.44563172 613 8 0 605 Brazoria, Texas, US
241 241 48041 Brazos Texas US 2020-05-09 02:32:35 30.663644800000004 -96.30205577 256 18 0 238 Brazos, Texas, US
242 242 21025 Breathitt Kentucky US 2020-05-09 02:32:35 37.52333168 -83.31959161 2 0 0 2 Breathitt, Kentucky, US
243 243 21027 Breckinridge Kentucky US 2020-05-09 02:32:35 37.77377239 -86.42885017 13 0 0 13 Breckinridge, Kentucky, US
244 244 19017 Bremer Iowa US 2020-05-09 02:32:35 42.77461496 -92.31795937 57 5 0 52 Bremer, Iowa, US
245 245 12009 Brevard Florida US 2020-05-09 02:32:35 28.29409504 -80.73091022 326 9 0 317 Brevard, Florida, US
246 246 48043 Brewster Texas US 2020-05-09 02:32:35 29.81008251 -103.2520326 1 0 0 1 Brewster, Texas, US
247 247 48045 Briscoe Texas US 2020-05-09 02:32:35 34.53026962 -101.2084947 1 0 0 1 Briscoe, Texas, US
248 248 25005 Bristol Massachusetts US 2020-05-09 02:32:35 41.79228404 -71.10872211 4670 252 0 4418 Bristol, Massachusetts, US
249 249 44001 Bristol Rhode Island US 2020-05-09 02:32:35 41.71018079 -71.28652315 154 0 0 154 Bristol, Rhode Island, US
250 250 51520 Bristol Virginia US 2020-05-09 02:32:35 36.6163024 -82.16359122 2 0 0 2 Bristol, Virginia, US
251 251 30007 Broadwater Montana US 2020-05-09 02:32:35 46.33277565 -111.4955813 4 0 0 4 Broadwater, Montana, US
252 252 54009 Brooke West Virginia US 2020-05-09 02:32:35 40.27367263 -80.57915332 3 0 0 3 Brooke, West Virginia, US
253 253 46011 Brookings South Dakota US 2020-05-09 02:32:35 44.36974375 -96.79079945 14 0 0 14 Brookings, South Dakota, US
254 254 13027 Brooks Georgia US 2020-05-09 02:32:35 30.83922642 -83.58303423 64 7 0 57 Brooks, Georgia, US
255 255 48047 Brooks Texas US 2020-05-09 02:32:35 27.03103197 -98.21808402 1 0 0 1 Brooks, Texas, US
256 256 36007 Broome New York US 2020-05-09 02:32:35 42.15903158 -75.81326086 364 23 0 341 Broome, New York, US
257 257 8014 Broomfield Colorado US 2020-05-09 02:32:35 39.95998787 -105.0566324 191 16 0 175 Broomfield, Colorado, US
258 258 12011 Broward Florida US 2020-05-09 02:32:35 26.15184651 -80.48725556 5688 248 0 5440 Broward, Florida, US
259 259 17009 Brown Illinois US 2020-05-09 02:32:35 39.96209138 -90.75068024 6 0 0 6 Brown, Illinois, US
260 260 18013 Brown Indiana US 2020-05-09 02:32:35 39.19605589 -86.22868909 25 1 0 24 Brown, Indiana, US
261 261 20013 Brown Kansas US 2020-05-09 02:32:35 39.82652589 -95.56421698 1 0 0 1 Brown, Kansas, US
262 262 27015 Brown Minnesota US 2020-05-09 02:32:35 44.24205652 -94.72562874 9 1 0 8 Brown, Minnesota, US
263 263 39015 Brown Ohio US 2020-05-09 02:32:35 38.93416837 -83.86788395 16 1 0 15 Brown, Ohio, US
264 264 46013 Brown South Dakota US 2020-05-09 02:32:35 45.58994323 -98.35165355 107 0 0 107 Brown, South Dakota, US
265 265 48049 Brown Texas US 2020-05-09 02:32:35 31.77430356 -98.99907113 38 6 0 32 Brown, Texas, US
266 266 55009 Brown Wisconsin US 2020-05-09 02:32:35 44.4526553 -88.00411844 1777 13 0 1764 Brown, Wisconsin, US
267 267 46015 Brule South Dakota US 2020-05-09 02:32:35 43.71756379 -99.08118954 0 0 0 0 Brule, South Dakota, US
268 268 37019 Brunswick North Carolina US 2020-05-09 02:32:35 34.070565 -78.22814204 50 2 0 48 Brunswick, North Carolina, US
269 269 51025 Brunswick Virginia US 2020-05-09 02:32:35 36.76366949 -77.8593436 17 0 0 17 Brunswick, Virginia, US
270 270 13029 Bryan Georgia US 2020-05-09 02:32:35 32.00979311 -81.44002948 59 4 0 55 Bryan, Georgia, US
271 271 40013 Bryan Oklahoma US 2020-05-09 02:32:35 33.96472458 -96.25903472 12 1 0 11 Bryan, Oklahoma, US
272 272 19019 Buchanan Iowa US 2020-05-09 02:32:35 42.4709188 -91.83510825 23 0 0 23 Buchanan, Iowa, US
273 273 29021 Buchanan Missouri US 2020-05-09 02:32:35 39.65816401 -94.80138942 409 3 0 406 Buchanan, Missouri, US
274 274 51027 Buchanan Virginia US 2020-05-09 02:32:35 37.26818323 -82.03749726 16 0 0 16 Buchanan, Virginia, US
275 275 51029 Buckingham Virginia US 2020-05-09 02:32:35 37.57242268 -78.52518834 225 1 0 224 Buckingham, Virginia, US
276 276 42017 Bucks Pennsylvania US 2020-05-09 02:32:35 40.33682119 -75.10836643 3750 331 0 3419 Bucks, Pennsylvania, US
277 277 19021 Buena Vista Iowa US 2020-05-09 02:32:35 42.73545875 -95.15100162 32 0 0 32 Buena Vista, Iowa, US
278 278 51530 Buena Vista Virginia US 2020-05-09 02:32:35 37.73484642 -79.35296097 8 0 0 8 Buena Vista, Virginia, US
279 279 31019 Buffalo Nebraska US 2020-05-09 02:32:35 40.85486962 -99.07500296 119 1 0 118 Buffalo, Nebraska, US
280 280 46017 Buffalo South Dakota US 2020-05-09 02:32:35 44.07657829 -99.20814467 1 0 0 1 Buffalo, South Dakota, US
281 281 55011 Buffalo Wisconsin US 2020-05-09 02:32:35 44.37835084 -91.75332578 5 1 0 4 Buffalo, Wisconsin, US
282 282 21029 Bullitt Kentucky US 2020-05-09 02:32:35 37.97162523 -85.68955617 79 3 0 76 Bullitt, Kentucky, US
283 283 13031 Bulloch Georgia US 2020-05-09 02:32:35 32.39577406 -81.74811421 42 2 0 40 Bulloch, Georgia, US
284 284 1011 Bullock Alabama US 2020-05-09 02:32:35 32.10030533 -85.71265535 20 1 0 20 Bullock, Alabama, US
285 285 37021 Buncombe North Carolina US 2020-05-09 02:32:35 35.61113393 -82.53305 88 5 0 83 Buncombe, North Carolina, US
286 286 17011 Bureau Illinois US 2020-05-09 02:32:35 41.40385234 -89.5283051 13 1 0 12 Bureau, Illinois, US
287 287 13033 Burke Georgia US 2020-05-09 02:32:35 33.05917989 -81.99928721 101 4 0 97 Burke, Georgia, US
288 288 37023 Burke North Carolina US 2020-05-09 02:32:35 35.74989637 -81.70755735 128 11 0 117 Burke, North Carolina, US
289 289 38013 Burke North Dakota US 2020-05-09 02:32:35 48.79094471 -102.5182117 5 0 0 5 Burke, North Dakota, US
290 290 38015 Burleigh North Dakota US 2020-05-09 02:32:35 46.97847375 -100.4645214 103 0 0 103 Burleigh, North Dakota, US
291 291 48051 Burleson Texas US 2020-05-09 02:32:35 30.49273808 -96.62158484 15 0 0 15 Burleson, Texas, US
292 292 34005 Burlington New Jersey US 2020-05-09 02:32:35 39.87681124 -74.66927768 3434 190 0 3241 Burlington, New Jersey, US
293 293 48053 Burnet Texas US 2020-05-09 02:32:35 30.78801353 -98.181887 25 0 0 25 Burnet, Texas, US
294 294 31021 Burt Nebraska US 2020-05-09 02:32:35 41.85056773 -96.32605633 5 0 0 5 Burt, Nebraska, US
295 295 1013 Butler Alabama US 2020-05-09 02:32:35 31.75300095 -86.68057478 159 3 0 159 Butler, Alabama, US
296 296 19023 Butler Iowa US 2020-05-09 02:32:35 42.73172833 -92.79015971 12 0 0 12 Butler, Iowa, US
297 297 20015 Butler Kansas US 2020-05-09 02:32:35 37.78134351 -96.83878537 14 0 0 14 Butler, Kansas, US
298 298 21031 Butler Kentucky US 2020-05-09 02:32:35 37.20946153 -86.68748787 192 6 0 186 Butler, Kentucky, US
299 299 29023 Butler Missouri US 2020-05-09 02:32:35 36.71462476 -90.40421163 26 0 0 26 Butler, Missouri, US
300 300 31023 Butler Nebraska US 2020-05-09 02:32:35 41.22703692 -97.13106306 15 0 0 15 Butler, Nebraska, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-08-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);