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,433 rows sorted by Confirmed

View and edit SQL

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed ▼ Deaths Recovered Active Combined_Key
240 48033 Borden Texas US 3/28/20 23:05 32.74363984 -101.4316509 0 0 0 0 Borden, Texas, US
241 48035 Bosque Texas US 3/28/20 23:05 31.89978581 -97.63613524 0 0 0 0 Bosque, Texas, US
244 38009 Bottineau North Dakota US 3/28/20 23:05 48.79106111 -100.8378166 0 0 0 0 Bottineau, North Dakota, US
246 16021 Boundary Idaho US 3/28/20 23:05 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
250 38011 Bowman North Dakota US 3/28/20 23:05 46.11285362 -103.5203343 0 0 0 0 Bowman, North Dakota, US
251 31013 Box Butte Nebraska US 3/28/20 23:05 42.22079243 -103.0878834 0 0 0 0 Box Butte, Nebraska, US
253 21019 Boyd Kentucky US 3/28/20 23:05 38.36176608 -82.68652187 0 0 0 0 Boyd, Kentucky, US
254 31015 Boyd Nebraska US 3/28/20 23:05 42.8997274 -98.76486568 0 0 0 0 Boyd, Nebraska, US
255 21021 Boyle Kentucky US 3/28/20 23:05 37.62680923 -84.8633779 0 0 0 0 Boyle, Kentucky, US
256 21023 Bracken Kentucky US 3/28/20 23:05 38.69158994 -84.08532444 0 0 0 0 Bracken, Kentucky, US
261 26023 Branch Michigan US 3/28/20 23:05 41.91600556 -85.05929476 0 0 0 0 Branch, Michigan, US
262 13025 Brantley Georgia US 3/28/20 23:05 31.19576557 -81.97743999 0 0 0 0 Brantley, Georgia, US
263 54007 Braxton West Virginia US 3/28/20 23:05 38.70036159 -80.72011184 0 0 0 0 Braxton, West Virginia, US
267 21027 Breckinridge Kentucky US 3/28/20 23:05 37.77377239 -86.42885017 0 0 0 0 Breckinridge, Kentucky, US
268 19017 Bremer Iowa US 3/28/20 23:05 42.77461496 -92.31795937 0 0 0 0 Bremer, Iowa, US
270 48043 Brewster Texas US 3/28/20 23:05 29.81008251 -103.2520326 0 0 0 0 Brewster, Texas, US
271 48045 Briscoe Texas US 3/28/20 23:05 34.53026962 -101.2084947 0 0 0 0 Briscoe, Texas, US
275 2060 Bristol Bay Alaska US 3/28/20 23:05 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
277 36005 Bronx New York US 3/28/20 23:05 40.85209301 -73.86282755 0 0 0 0 Bronx, New York, US
278 54009 Brooke West Virginia US 3/28/20 23:05 40.27367263 -80.57915332 0 0 0 0 Brooke, West Virginia, US
280 13027 Brooks Georgia US 3/28/20 23:05 30.83922642 -83.58303423 0 0 0 0 Brooks, Georgia, US
281 48047 Brooks Texas US 3/28/20 23:05 27.03103197 -98.21808402 0 0 0 0 Brooks, Texas, US
285 17009 Brown Illinois US 3/28/20 23:05 39.96209138 -90.75068024 0 0 0 0 Brown, Illinois, US
287 20013 Brown Kansas US 3/28/20 23:05 39.82652589 -95.56421698 0 0 0 0 Brown, Kansas, US
288 27015 Brown Minnesota US 3/28/20 23:05 44.24205652 -94.72562874 0 0 0 0 Brown, Minnesota, US
289 31017 Brown Nebraska US 3/28/20 23:05 42.43018907 -99.92904055 0 0 0 0 Brown, Nebraska, US
290 39015 Brown Ohio US 3/28/20 23:05 38.93416837 -83.86788395 0 0 0 0 Brown, Ohio, US
294 46015 Brule South Dakota US 3/28/20 23:05 43.71756379 -99.08118954 0 0 0 0 Brule, South Dakota, US
296 51025 Brunswick Virginia US 3/28/20 23:05 36.76366949 -77.8593436 0 0 0 0 Brunswick, Virginia, US
301 51027 Buchanan Virginia US 3/28/20 23:05 37.26818323 -82.03749726 0 0 0 0 Buchanan, Virginia, US
302 51029 Buckingham Virginia US 3/28/20 23:05 37.57242268 -78.52518834 0 0 0 0 Buckingham, Virginia, US
304 19021 Buena Vista Iowa US 3/28/20 23:05 42.73545875 -95.15100162 0 0 0 0 Buena Vista, Iowa, US
305 51530 Buena Vista Virginia US 3/28/20 23:05 37.73484642 -79.35296097 0 0 0 0 Buena Vista, Virginia, US
307 46017 Buffalo South Dakota US 3/28/20 23:05 44.07657829 -99.20814467 0 0 0 0 Buffalo, South Dakota, US
308 55011 Buffalo Wisconsin US 3/28/20 23:05 44.37835084 -91.75332578 0 0 0 0 Buffalo, Wisconsin, US
309 21029 Bullitt Kentucky US 3/28/20 23:05 37.97162523 -85.68955617 0 0 0 0 Bullitt, Kentucky, US
310 13031 Bulloch Georgia US 3/28/20 23:05 32.39577406 -81.74811421 0 0 0 0 Bulloch, Georgia, US
316 38013 Burke North Dakota US 3/28/20 23:05 48.79094471 -102.5182117 0 0 0 0 Burke, North Dakota, US
321 55013 Burnett Wisconsin US 3/28/20 23:05 45.86303537 -92.36711412 0 0 0 0 Burnett, Wisconsin, US
322 31021 Burt Nebraska US 3/28/20 23:05 41.85056773 -96.32605633 0 0 0 0 Burt, Nebraska, US
326 21031 Butler Kentucky US 3/28/20 23:05 37.20946153 -86.68748787 0 0 0 0 Butler, Kentucky, US
327 29023 Butler Missouri US 3/28/20 23:05 36.71462476 -90.40421163 0 0 0 0 Butler, Missouri, US
328 31023 Butler Nebraska US 3/28/20 23:05 41.22703692 -97.13106306 0 0 0 0 Butler, Nebraska, US
332 16023 Butte Idaho US 3/28/20 23:05 43.72592209 -113.1735463 0 0 0 0 Butte, Idaho, US
333 46019 Butte South Dakota US 3/28/20 23:05 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
336 54011 Cabell West Virginia US 3/28/20 23:05 38.42424062 -82.23855912 0 0 0 0 Cabell, West Virginia, US
342 21033 Caldwell Kentucky US 3/28/20 23:05 37.14749129 -87.86948214 0 0 0 0 Caldwell, Kentucky, US
343 22021 Caldwell Louisiana US 3/28/20 23:05 32.0902519 -92.11752148 0 0 0 0 Caldwell, Louisiana, US
344 29025 Caldwell Missouri US 3/28/20 23:05 39.65620858 -93.98308093 0 0 0 0 Caldwell, Missouri, US
349 5013 Calhoun Arkansas US 3/28/20 23:05 33.55598792 -92.49974403 0 0 0 0 Calhoun, Arkansas, US
350 12013 Calhoun Florida US 3/28/20 23:05 30.40666734 -85.19394153 0 0 0 0 Calhoun, Florida, US
352 17013 Calhoun Illinois US 3/28/20 23:05 39.16840183 -90.66330078 0 0 0 0 Calhoun, Illinois, US
353 19025 Calhoun Iowa US 3/28/20 23:05 42.38521079 -94.64046046 0 0 0 0 Calhoun, Iowa, US
358 54013 Calhoun West Virginia US 3/28/20 23:05 38.84315422 -81.11934872 0 0 0 0 Calhoun, West Virginia, US
359 48059 Callahan Texas US 3/28/20 23:05 32.29760619 -99.37326312 0 0 0 0 Callahan, Texas, US
364 16025 Camas Idaho US 3/28/20 23:05 43.46665742 -114.8065892 0 0 0 0 Camas, Idaho, US
369 37029 Camden North Carolina US 3/28/20 23:05 36.33804939 -76.15568396 0 0 0 0 Camden, North Carolina, US
370 22023 Cameron Louisiana US 3/28/20 23:05 29.87592238 -93.19310676 0 0 0 0 Cameron, Louisiana, US
373 48063 Camp Texas US 3/28/20 23:05 32.97195142 -94.97790104 0 0 0 0 Camp, Texas, US
375 46021 Campbell South Dakota US 3/28/20 23:05 45.77074915 -100.0510181 0 0 0 0 Campbell, South Dakota, US
377 51031 Campbell Virginia US 3/28/20 23:05 37.20553386 -79.09678609 0 0 0 0 Campbell, Virginia, US
380 13043 Candler Georgia US 3/28/20 23:05 32.40209349 -82.07702563 0 0 0 0 Candler, Georgia, US
385 30009 Carbon Montana US 3/28/20 23:05 45.22850116 -109.0274047 0 0 0 0 Carbon, Montana, US
387 49007 Carbon Utah US 3/28/20 23:05 39.64834818 -110.5872512 0 0 0 0 Carbon, Utah, US
389 16029 Caribou Idaho US 3/28/20 23:05 42.77149116 -111.5597683 0 0 0 0 Caribou, Idaho, US
390 21039 Carlisle Kentucky US 3/28/20 23:05 36.85372876 -88.9669222 0 0 0 0 Carlisle, Kentucky, US
391 27017 Carlton Minnesota US 3/28/20 23:05 46.59180601 -92.67601019 0 0 0 0 Carlton, Minnesota, US
393 51033 Caroline Virginia US 3/28/20 23:05 38.02679129 -77.34901405 0 0 0 0 Caroline, Virginia, US
394 5015 Carroll Arkansas US 3/28/20 23:05 36.3403856 -93.54270261 0 0 0 0 Carroll, Arkansas, US
399 21041 Carroll Kentucky US 3/28/20 23:05 38.66599534 -85.12601074 0 0 0 0 Carroll, Kentucky, US
401 28015 Carroll Mississippi US 3/28/20 23:05 33.44834567 -89.91994479 0 0 0 0 Carroll, Mississippi, US
402 29033 Carroll Missouri US 3/28/20 23:05 39.42762566 -93.50626255 0 0 0 0 Carroll, Missouri, US
406 51035 Carroll Virginia US 3/28/20 23:05 36.73066666 -80.73455942 0 0 0 0 Carroll, Virginia, US
407 48065 Carson Texas US 3/28/20 23:05 35.40365929 -101.3542669 0 0 0 0 Carson, Texas, US
409 21043 Carter Kentucky US 3/28/20 23:05 38.31690743 -83.05092385 0 0 0 0 Carter, Kentucky, US
411 30011 Carter Montana US 3/28/20 23:05 45.5197966 -104.5395536 0 0 0 0 Carter, Montana, US
417 21045 Casey Kentucky US 3/28/20 23:05 37.32533118 -84.92726209 0 0 0 0 Casey, Kentucky, US
418 17017 Cass Illinois US 3/28/20 23:05 39.96991073 -90.24734436 0 0 0 0 Cass, Illinois, US
419 18017 Cass Indiana US 3/28/20 23:05 40.76135835 -86.34830753 0 0 0 0 Cass, Indiana, US
420 19029 Cass Iowa US 3/28/20 23:05 41.33149454 -94.92792482 0 0 0 0 Cass, Iowa, US
433 35003 Catron New Mexico US 3/28/20 23:05 33.91514144 -108.4046587 0 0 0 0 Catron, New Mexico, US
435 38019 Cavalier North Dakota US 3/28/20 23:05 48.77286211 -98.46685243 0 0 0 0 Cavalier, North Dakota, US
439 29039 Cedar Missouri US 3/28/20 23:05 37.72391475 -93.85445441 0 0 0 0 Cedar, Missouri, US
440 31027 Cedar Nebraska US 3/28/20 23:05 42.5988851 -97.25311951 0 0 0 0 Cedar, Nebraska, US
455 51037 Charlotte Virginia US 3/28/20 23:05 37.01909701 -78.66314092 0 0 0 0 Charlotte, Virginia, US
458 20017 Chase Kansas US 3/28/20 23:05 38.30292938 -96.59563862 0 0 0 0 Chase, Kansas, US
459 31029 Chase Nebraska US 3/28/20 23:05 40.5237198 -101.6978026 0 0 0 0 Chase, Nebraska, US
464 20019 Chautauqua Kansas US 3/28/20 23:05 37.14994405 -96.2454192 0 0 0 0 Chautauqua, Kansas, US
468 26031 Cheboygan Michigan US 3/28/20 23:05 45.44787015 -84.50122149 0 0 0 0 Cheboygan, Michigan, US
474 19035 Cherokee Iowa US 3/28/20 23:05 42.73538914 -95.62389402 0 0 0 0 Cherokee, Iowa, US
478 45021 Cherokee South Carolina US 3/28/20 23:05 35.05122251 -81.61828622 0 0 0 0 Cherokee, South Carolina, US
480 31031 Cherry Nebraska US 3/28/20 23:05 42.54502621 -101.1244332 0 0 0 0 Cherry, Nebraska, US
488 8017 Cheyenne Colorado US 3/28/20 23:05 38.82777431 -102.6032558 0 0 0 0 Cheyenne, Colorado, US
489 20023 Cheyenne Kansas US 3/28/20 23:05 39.78580976 -101.7318201 0 0 0 0 Cheyenne, Kansas, US
490 31033 Cheyenne Nebraska US 3/28/20 23:05 41.21999357 -102.9941693 0 0 0 0 Cheyenne, Nebraska, US
491 19037 Chickasaw Iowa US 3/28/20 23:05 43.06001295 -92.31773347 0 0 0 0 Chickasaw, Iowa, US
494 48075 Childress Texas US 3/28/20 23:05 34.5293041 -100.2077916 0 0 0 0 Childress, Texas, US
496 26033 Chippewa Michigan US 3/28/20 23:05 46.29552653 -84.54353449 0 0 0 0 Chippewa, Michigan, US
497 27023 Chippewa Minnesota US 3/28/20 23:05 45.02343421 -95.56403693 0 0 0 0 Chippewa, Minnesota, US
504 30015 Chouteau Montana US 3/28/20 23:05 47.88084126 -110.4353362 0 0 0 0 Chouteau, Montana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [03-28-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
);