04-30-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,179 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 27013 Blue Earth Minnesota US 2020-05-01 02:32:28 44.03554215 -94.06699781 38 0 0 38 Blue Earth, Minnesota, US
202 202 28011 Bolivar Mississippi US 2020-05-01 02:32:28 33.79696941 -90.87372121 102 7 0 95 Bolivar, Mississippi, US
203 203 29017 Bollinger Missouri US 2020-05-01 02:32:28 37.32449052 -90.02725304 4 0 0 4 Bollinger, Missouri, US
204 204 46009 Bon Homme South Dakota US 2020-05-01 02:32:28 42.98914167 -97.88592746 4 0 0 4 Bon Homme, South Dakota, US
205 205 17005 Bond Illinois US 2020-05-01 02:32:28 38.88829622 -89.43534887 6 1 0 5 Bond, Illinois, US
206 206 16017 Bonner Idaho US 2020-05-01 02:32:28 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
207 207 16019 Bonneville Idaho US 2020-05-01 02:32:28 43.38713372 -111.6161537 28 0 0 28 Bonneville, Idaho, US
208 208 5009 Boone Arkansas US 2020-05-01 02:32:28 36.3084504 -93.09374925 5 0 0 5 Boone, Arkansas, US
209 209 17007 Boone Illinois US 2020-05-01 02:32:28 42.32359279 -88.82345779 98 9 0 89 Boone, Illinois, US
210 210 18011 Boone Indiana US 2020-05-01 02:32:28 40.0509304 -86.46841646 190 20 0 170 Boone, Indiana, US
211 211 19015 Boone Iowa US 2020-05-01 02:32:28 42.03657094 -93.9313999 12 0 0 12 Boone, Iowa, US
212 212 21015 Boone Kentucky US 2020-05-01 02:32:28 38.97065142 -84.72615357 138 2 0 136 Boone, Kentucky, US
213 213 29019 Boone Missouri US 2020-05-01 02:32:28 38.99186229 -92.30723575 100 1 0 99 Boone, Missouri, US
214 214 54005 Boone West Virginia US 2020-05-01 02:32:28 38.01974191 -81.69888019 3 0 0 3 Boone, West Virginia, US
215 215 48035 Bosque Texas US 2020-05-01 02:32:28 31.89978581 -97.63613524 4 0 0 4 Bosque, Texas, US
216 216 22015 Bossier Louisiana US 2020-05-01 02:32:28 32.67932307 -93.60460152 286 17 0 269 Bossier, Louisiana, US
217 217 51023 Botetourt Virginia US 2020-05-01 02:32:28 37.55531756 -79.80982182 28 3 0 25 Botetourt, Virginia, US
218 218 8013 Boulder Colorado US 2020-05-01 02:32:28 40.09313619 -105.3546767 580 40 0 540 Boulder, Colorado, US
219 219 16021 Boundary Idaho US 2020-05-01 02:32:28 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
220 220 20011 Bourbon Kansas US 2020-05-01 02:32:28 37.85508555 -94.84865997 6 1 0 5 Bourbon, Kansas, US
221 221 21017 Bourbon Kentucky US 2020-05-01 02:32:28 38.2054607 -84.21827874 8 1 0 7 Bourbon, Kentucky, US
222 222 48037 Bowie Texas US 2020-05-01 02:32:28 33.44626922 -94.41834132 70 2 0 68 Bowie, Texas, US
223 223 38011 Bowman North Dakota US 2020-05-01 02:32:28 46.11285362 -103.5203343 1 0 0 1 Bowman, North Dakota, US
224 224 31013 Box Butte Nebraska US 2020-05-01 02:32:28 42.22079243 -103.08788340000001 1 0 0 1 Box Butte, Nebraska, US
225 225 21019 Boyd Kentucky US 2020-05-01 02:32:28 38.36176608 -82.68652187 31 3 0 28 Boyd, Kentucky, US
226 226 21021 Boyle Kentucky US 2020-05-01 02:32:28 37.62680923 -84.8633779 17 0 0 17 Boyle, Kentucky, US
227 227 21023 Bracken Kentucky US 2020-05-01 02:32:28 38.69158994 -84.08532444 7 0 0 7 Bracken, Kentucky, US
228 228 12007 Bradford Florida US 2020-05-01 02:32:28 29.95079741 -82.16611613 46 2 0 44 Bradford, Florida, US
229 229 42015 Bradford Pennsylvania US 2020-05-01 02:32:28 41.78869215 -76.51570822 31 2 0 29 Bradford, Pennsylvania, US
230 230 5011 Bradley Arkansas US 2020-05-01 02:32:28 33.46755808 -92.15980837 12 1 0 11 Bradley, Arkansas, US
231 231 47011 Bradley Tennessee US 2020-05-01 02:32:28 35.15739424 -84.857186 49 1 0 48 Bradley, Tennessee, US
232 232 26023 Branch Michigan US 2020-05-01 02:32:28 41.91600556 -85.05929476 63 2 0 61 Branch, Michigan, US
233 233 13025 Brantley Georgia US 2020-05-01 02:32:28 31.19576557 -81.97743999 23 2 0 21 Brantley, Georgia, US
234 234 54007 Braxton West Virginia US 2020-05-01 02:32:28 38.70036159 -80.72011184 2 0 0 2 Braxton, West Virginia, US
235 235 48039 Brazoria Texas US 2020-05-01 02:32:28 29.18757369 -95.44563172 485 6 0 479 Brazoria, Texas, US
236 236 48041 Brazos Texas US 2020-05-01 02:32:28 30.663644800000004 -96.30205577 197 16 0 177 Brazos, Texas, US
237 237 21025 Breathitt Kentucky US 2020-05-01 02:32:28 37.52333168 -83.31959161 2 0 0 2 Breathitt, Kentucky, US
238 238 21027 Breckinridge Kentucky US 2020-05-01 02:32:28 37.77377239 -86.42885017 9 0 0 9 Breckinridge, Kentucky, US
239 239 19017 Bremer Iowa US 2020-05-01 02:32:28 42.77461496 -92.31795937 51 3 0 48 Bremer, Iowa, US
240 240 12009 Brevard Florida US 2020-05-01 02:32:28 28.29409504 -80.73091022 285 8 0 277 Brevard, Florida, US
241 241 25005 Bristol Massachusetts US 2020-05-01 02:32:28 41.79228404 -71.10872211 3580 172 0 3408 Bristol, Massachusetts, US
242 242 44001 Bristol Rhode Island US 2020-05-01 02:32:28 41.71018079 -71.28652315 143 0 0 143 Bristol, Rhode Island, US
243 243 51520 Bristol Virginia US 2020-05-01 02:32:28 36.616302399999995 -82.16359122 1 0 0 1 Bristol, Virginia, US
244 244 30007 Broadwater Montana US 2020-05-01 02:32:28 46.33277565 -111.49558130000001 4 0 0 4 Broadwater, Montana, US
245 245 54009 Brooke West Virginia US 2020-05-01 02:32:28 40.27367263 -80.57915332 3 0 0 3 Brooke, West Virginia, US
246 246 46011 Brookings South Dakota US 2020-05-01 02:32:28 44.36974375 -96.79079945 13 0 0 13 Brookings, South Dakota, US
247 247 13027 Brooks Georgia US 2020-05-01 02:32:28 30.83922642 -83.58303423 58 6 0 52 Brooks, Georgia, US
248 248 48047 Brooks Texas US 2020-05-01 02:32:28 27.03103197 -98.21808402 1 0 0 1 Brooks, Texas, US
249 249 36007 Broome New York US 2020-05-01 02:32:28 42.15903158 -75.81326086 284 22 0 262 Broome, New York, US
250 250 8014 Broomfield Colorado US 2020-05-01 02:32:28 39.95998787 -105.0566324 150 9 0 141 Broomfield, Colorado, US
251 251 12011 Broward Florida US 2020-05-01 02:32:28 26.15184651 -80.48725556 4953 185 0 4768 Broward, Florida, US
252 252 18013 Brown Indiana US 2020-05-01 02:32:28 39.19605589 -86.22868909 15 1 0 14 Brown, Indiana, US
253 253 27015 Brown Minnesota US 2020-05-01 02:32:28 44.24205652 -94.72562874 8 1 0 7 Brown, Minnesota, US
254 254 39015 Brown Ohio US 2020-05-01 02:32:28 38.93416837 -83.86788395 11 1 0 10 Brown, Ohio, US
255 255 46013 Brown South Dakota US 2020-05-01 02:32:28 45.58994323 -98.35165355 39 0 0 39 Brown, South Dakota, US
256 256 48049 Brown Texas US 2020-05-01 02:32:28 31.77430356 -98.99907113 36 4 0 32 Brown, Texas, US
257 257 55009 Brown Wisconsin US 2020-05-01 02:32:28 44.452655299999996 -88.00411844 1057 3 0 1054 Brown, Wisconsin, US
258 258 46015 Brule South Dakota US 2020-05-01 02:32:28 43.71756379 -99.08118954 0 0 0 0 Brule, South Dakota, US
259 259 37019 Brunswick North Carolina US 2020-05-01 02:32:28 34.070565 -78.22814204 43 2 0 41 Brunswick, North Carolina, US
260 260 51025 Brunswick Virginia US 2020-05-01 02:32:28 36.76366949 -77.8593436 14 0 0 14 Brunswick, Virginia, US
261 261 13029 Bryan Georgia US 2020-05-01 02:32:28 32.00979311 -81.44002948 52 2 0 50 Bryan, Georgia, US
262 262 40013 Bryan Oklahoma US 2020-05-01 02:32:28 33.96472458 -96.25903472 8 1 0 7 Bryan, Oklahoma, US
263 263 19019 Buchanan Iowa US 2020-05-01 02:32:28 42.4709188 -91.83510825 17 0 0 17 Buchanan, Iowa, US
264 264 29021 Buchanan Missouri US 2020-05-01 02:32:28 39.65816401 -94.80138942 87 1 0 86 Buchanan, Missouri, US
265 265 51027 Buchanan Virginia US 2020-05-01 02:32:28 37.26818323 -82.03749726 16 0 0 16 Buchanan, Virginia, US
266 266 51029 Buckingham Virginia US 2020-05-01 02:32:28 37.57242268 -78.52518834 58 0 0 58 Buckingham, Virginia, US
267 267 42017 Bucks Pennsylvania US 2020-05-01 02:32:28 40.33682119 -75.10836643 2907 205 0 2702 Bucks, Pennsylvania, US
268 268 19021 Buena Vista Iowa US 2020-05-01 02:32:28 42.73545875 -95.15100162 4 0 0 4 Buena Vista, Iowa, US
269 269 51530 Buena Vista Virginia US 2020-05-01 02:32:28 37.73484642 -79.35296097 6 0 0 6 Buena Vista, Virginia, US
270 270 31019 Buffalo Nebraska US 2020-05-01 02:32:28 40.85486962 -99.07500296 101 1 0 100 Buffalo, Nebraska, US
271 271 46017 Buffalo South Dakota US 2020-05-01 02:32:28 44.07657829 -99.20814467 1 0 0 1 Buffalo, South Dakota, US
272 272 55011 Buffalo Wisconsin US 2020-05-01 02:32:28 44.37835084 -91.75332578 4 1 0 3 Buffalo, Wisconsin, US
273 273 21029 Bullitt Kentucky US 2020-05-01 02:32:28 37.97162523 -85.68955617 53 2 0 51 Bullitt, Kentucky, US
274 274 13031 Bulloch Georgia US 2020-05-01 02:32:28 32.39577406 -81.74811421 37 2 0 35 Bulloch, Georgia, US
275 275 1011 Bullock Alabama US 2020-05-01 02:32:28 32.10030533 -85.71265535 13 0 0 13 Bullock, Alabama, US
276 276 37021 Buncombe North Carolina US 2020-05-01 02:32:28 35.61113393 -82.53305 68 5 0 63 Buncombe, North Carolina, US
277 277 17011 Bureau Illinois US 2020-05-01 02:32:28 41.40385234 -89.5283051 10 0 0 10 Bureau, Illinois, US
278 278 13033 Burke Georgia US 2020-05-01 02:32:28 33.05917989 -81.99928721 85 3 0 82 Burke, Georgia, US
279 279 37023 Burke North Carolina US 2020-05-01 02:32:28 35.74989637 -81.70755735 102 8 0 94 Burke, North Carolina, US
280 280 38013 Burke North Dakota US 2020-05-01 02:32:28 48.79094471 -102.51821170000001 3 0 0 3 Burke, North Dakota, US
281 281 38015 Burleigh North Dakota US 2020-05-01 02:32:28 46.97847375 -100.46452140000001 77 0 0 77 Burleigh, North Dakota, US
282 282 48051 Burleson Texas US 2020-05-01 02:32:28 30.49273808 -96.62158484 12 0 0 12 Burleson, Texas, US
283 283 34005 Burlington New Jersey US 2020-05-01 02:32:28 39.87681124 -74.66927768 2690 130 0 2560 Burlington, New Jersey, US
284 284 48053 Burnet Texas US 2020-05-01 02:32:28 30.78801353 -98.181887 19 0 0 19 Burnet, Texas, US
285 285 31021 Burt Nebraska US 2020-05-01 02:32:28 41.85056773 -96.32605633 3 0 0 3 Burt, Nebraska, US
286 286 1013 Butler Alabama US 2020-05-01 02:32:28 31.75300095 -86.68057478 55 1 0 52 Butler, Alabama, US
287 287 19023 Butler Iowa US 2020-05-01 02:32:28 42.73172833 -92.79015971 9 0 0 9 Butler, Iowa, US
288 288 20015 Butler Kansas US 2020-05-01 02:32:28 37.78134351 -96.83878537 16 0 0 16 Butler, Kansas, US
289 289 21031 Butler Kentucky US 2020-05-01 02:32:28 37.20946153 -86.68748787 116 3 0 113 Butler, Kentucky, US
290 290 29023 Butler Missouri US 2020-05-01 02:32:28 36.71462476 -90.40421163 26 0 0 26 Butler, Missouri, US
291 291 31023 Butler Nebraska US 2020-05-01 02:32:28 41.22703692 -97.13106306 4 0 0 4 Butler, Nebraska, US
292 292 39017 Butler Ohio US 2020-05-01 02:32:28 39.44012838 -84.57388716 281 8 0 274 Butler, Ohio, US
293 293 42019 Butler Pennsylvania US 2020-05-01 02:32:28 40.91152759 -79.91351055 178 6 0 172 Butler, Pennsylvania, US
294 294 6007 Butte California US 2020-05-01 02:32:28 39.66727762 -121.6005252 16 0 0 16 Butte, California, US
295 295 46019 Butte South Dakota US 2020-05-01 02:32:28 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
296 296 13035 Butts Georgia US 2020-05-01 02:32:28 33.283094500000004 -83.95435040000002 141 11 0 130 Butts, Georgia, US
297 297 37025 Cabarrus North Carolina US 2020-05-01 02:32:28 35.3877799 -80.55267168 303 11 0 292 Cabarrus, North Carolina, US
298 298 54011 Cabell West Virginia US 2020-05-01 02:32:28 38.42424062 -82.23855912 42 0 0 42 Cabell, West Virginia, US
299 299 22017 Caddo Louisiana US 2020-05-01 02:32:28 32.57991587 -93.88375652 1540 107 0 1433 Caddo, Louisiana, US
300 300 40015 Caddo Oklahoma US 2020-05-01 02:32:28 35.17364557 -98.37534464 62 7 0 55 Caddo, Oklahoma, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-30-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
);