04-10-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

2,943 rows sorted by Confirmed

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed ▼ Deaths Recovered Active Combined_Key
49 49 20003 Anderson Kansas US 2020-04-10 22:54:07 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US
127 127 51017 Bath Virginia US 2020-04-10 22:54:07 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
151 151 18007 Benton Indiana US 2020-04-10 22:54:07 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
159 159 26019 Benzie Michigan US 2020-04-10 22:54:07 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
183 183 51021 Bland Virginia US 2020-04-10 22:54:07 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
276 276 46019 Butte South Dakota US 2020-04-10 22:54:07 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
574 574 47033 Crockett Tennessee US 2020-04-10 22:54:07 35.81830662 -89.14916269 0 0 0 0 Crockett, Tennessee, US
661 661 51051 Dickenson Virginia US 2020-04-10 22:54:07 37.12560977 -82.35124171 0 0 0 0 Dickenson, Virginia, US
750 750 51057 Essex Virginia US 2020-04-10 22:54:07 37.93357639 -76.94230311 0 0 0 0 Essex, Virginia, US
761 761 51610 Falls Church Virginia US 2020-04-10 22:54:07 38.88485255 -77.17560759 0 0 0 0 Falls Church, Virginia, US
790 790 51063 Floyd Virginia US 2020-04-10 22:54:07 36.9302126 -80.36738849 0 0 0 0 Floyd, Virginia, US
919 919 51077 Grayson Virginia US 2020-04-10 22:54:07 36.65677234 -81.23215889 0 0 0 0 Grayson, Virginia, US
987 987 47067 Hancock Tennessee US 2020-04-10 22:54:07 36.52692871 -83.22375847 0 0 0 0 Hancock, Tennessee, US
1048 1048 51091 Highland Virginia US 2020-04-10 22:54:07 38.35799465 -79.56124594 0 0 0 0 Highland, Virginia, US
1248 1248 46077 Kingsbury South Dakota US 2020-04-10 22:54:07 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1292 1292 47095 Lake Tennessee US 2020-04-10 22:54:07 36.34180170000001 -89.48921915 0 0 0 0 Lake, Tennessee, US
1357 1357 16061 Lewis Idaho US 2020-04-10 22:54:07 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1408 1408 31113 Logan Nebraska US 2020-04-10 22:54:07 41.56650314 -100.4817851 0 0 0 0 Logan, Nebraska, US
1518 1518 51690 Martinsville Virginia US 2020-04-10 22:54:07 36.68212094 -79.86352771 0 0 0 0 Martinsville, Virginia, US
1580 1580 38057 Mercer North Dakota US 2020-04-10 22:54:07 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1663 1663 47127 Moore Tennessee US 2020-04-10 22:54:07 35.27724699 -86.36230578 0 0 0 0 Moore, Tennessee, US
1746 1746 51720 Norton Virginia US 2020-04-10 22:54:07 36.93357076 -82.62750411 0 0 0 0 Norton, Virginia, US
1783 1783 26131 Ontonagon Michigan US 2020-04-10 22:54:07 46.665226200000006 -89.31390481 0 0 0 0 Ontonagon, Michigan, US
1819 1819 80008 Out of CO Colorado US 2020-04-10 22:54:07     0 1 0 0 Out of CO,Colorado,US
1822 1822 80040 Out of OK Oklahoma US 2020-04-10 22:54:07     0 0 0 0 Out of OK,Oklahoma,US
1845 1845 51141 Patrick Virginia US 2020-04-10 22:54:07 36.680163799999995 -80.2865648 0 0 0 0 Patrick, Virginia, US
1862 1862 55091 Pepin Wisconsin US 2020-04-10 22:54:07 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1913 1913 56031 Platte Wyoming US 2020-04-10 22:54:07 42.13299116 -104.96633100000001 0 0 0 0 Platte, Wyoming, US
1974 1974 39137 Putnam Ohio US 2020-04-10 22:54:07 41.02094889 -84.1336111 0 0 0 0 Putnam, Ohio, US
2010 2010 47143 Rhea Tennessee US 2020-04-10 22:54:07 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
2049 2049 38079 Rolette North Dakota US 2020-04-10 22:54:07 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
2135 2135 48415 Scurry Texas US 2020-04-10 22:54:07 32.74613808 -100.91626640000001 0 0 0 0 Scurry, Texas, US
2321 2321 29215 Texas Missouri US 2020-04-10 22:54:07 37.31728859 -91.96564727 0 0 0 0 Texas, Missouri, US
2373 2373 90002 Unassigned Alaska US 2020-04-10 22:54:07     0 2 0 0 Unassigned, Alaska, US
2374 2374 90004 Unassigned Arizona US 2020-04-10 22:54:07     0 26 0 0 Unassigned, Arizona, US
2383 2383 90016 Unassigned Idaho US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Idaho, US
2385 2385 90018 Unassigned Indiana US 2020-04-10 22:54:07     0 99 0 0 Unassigned, Indiana, US
2386 2386 90019 Unassigned Iowa US 2020-04-10 22:54:07     0 3 0 0 Unassigned, Iowa, US
2387 2387 90020 Unassigned Kansas US 2020-04-10 22:54:07     0 16 0 0 Unassigned, Kansas, US
2391 2391 90024 Unassigned Maryland US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Maryland, US
2395 2395 90028 Unassigned Mississippi US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Mississippi, US
2396 2396 90029 Unassigned Missouri US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Missouri, US
2397 2397 90030 Unassigned Montana US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Montana, US
2398 2398 90031 Unassigned Nebraska US 2020-04-10 22:54:07     0 2 0 0 Unassigned, Nebraska, US
2402 2402 90035 Unassigned New Mexico US 2020-04-10 22:54:07     0 0 0 0 Unassigned, New Mexico, US
2403 2403 90036 Unassigned New York US 2020-04-10 22:54:07     0 0 0 0 Unassigned, New York, US
2404 2404 90038 Unassigned North Dakota US 2020-04-10 22:54:07     0 0 0 0 Unassigned, North Dakota, US
2405 2405 90039 Unassigned Ohio US 2020-04-10 22:54:07     0 18 0 0 Unassigned, Ohio, US
2406 2406 90040 Unassigned Oklahoma US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Oklahoma, US
2407 2407 90041 Unassigned Oregon US 2020-04-10 22:54:07     0 1 0 0 Unassigned, Oregon, US
2408 2408 90042 Unassigned Pennsylvania US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Pennsylvania, US
2410 2410 90046 Unassigned South Dakota US 2020-04-10 22:54:07     0 0 0 0 Unassigned, South Dakota, US
2412 2412 90049 Unassigned Utah US 2020-04-10 22:54:07     0 0 0 0 Unassigned,Utah,US
2414 2414 90051 Unassigned Virginia US 2020-04-10 22:54:07     0 83 0 0 Unassigned, Virginia, US
2416 2416 90054 Unassigned West Virginia US 2020-04-10 22:54:07     0 1 0 0 Unassigned, West Virginia, US
2417 2417 90055 Unassigned Wisconsin US 2020-04-10 22:54:07     0 0 0 0 Unassigned, Wisconsin, US
2418 2418   Unassigned Wyoming US 2020-04-10 22:54:07     0 0 0 0 Unassigned,Wyoming,US
2447 2447 47175 Van Buren Tennessee US 2020-04-10 22:54:07 35.69864497 -85.45221699 0 0 0 0 Van Buren, Tennessee, US
2685 2685     Diamond Princess Canada 2020-04-10 23:01:26     0 1 0 0 Diamond Princess, Canada
2729 2729     Nunavut Canada 2020-04-10 23:01:26 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2736 2736     Recovered Canada 2020-04-10 23:01:26     0 0 5855 0 Recovered, Canada
2737 2737     Recovered US 2020-04-10 22:54:07     0 0 28790 0 Recovered, US
2740 2740     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-10 22:53:48 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2902 2902       Samoa 2020-04-10 23:01:26 -13.759 -172.1046 0 0 0 0 Samoa
2943 2943   unassigned Utah US 2020-04-10 22:54:07     0 4 0 0 unassigned, Utah, US
5 5 19001 Adair Iowa US 2020-04-10 22:54:07 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 16003 Adams Idaho US 2020-04-10 22:54:07 44.89333571 -116.4545247 1 0 0 0 Adams, Idaho, US
43 43 6003 Alpine California US 2020-04-10 22:54:07 38.59678594 -119.82235940000001 1 0 0 0 Alpine, California, US
60 60 31003 Antelope Nebraska US 2020-04-10 22:54:07 42.17695516 -98.06662829999999 1 0 0 0 Antelope, Nebraska, US
63 63 19007 Appanoose Iowa US 2020-04-10 22:54:07 40.74324454 -92.86865906 1 1 0 0 Appanoose, Iowa, US
77 77 55003 Ashland Wisconsin US 2020-04-10 22:54:07 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
84 84 29005 Atchison Missouri US 2020-04-10 22:54:07 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
88 88 40005 Atoka Oklahoma US 2020-04-10 22:54:07 34.37366573 -96.03802487 1 0 0 0 Atoka, Oklahoma, US
90 90 19009 Audubon Iowa US 2020-04-10 22:54:07 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
93 93 46003 Aurora South Dakota US 2020-04-10 22:54:07 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
103 103 21007 Ballard Kentucky US 2020-04-10 22:54:07 37.05842757 -88.99427697 1 0 0 0 Ballard, Kentucky, US
110 110 20007 Barber Kansas US 2020-04-10 22:54:07 37.2288586 -98.68460053 1 0 0 0 Barber, Kansas, US
116 116 21009 Barren Kentucky US 2020-04-10 22:54:07 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
126 126 21011 Bath Kentucky US 2020-04-10 22:54:07 38.14735938 -83.74588932 1 0 0 0 Bath, Kentucky, US
136 136 40007 Beaver Oklahoma US 2020-04-10 22:54:07 36.7496847 -100.4758872 1 0 0 0 Beaver, Oklahoma, US
138 138 30001 Beaverhead Montana US 2020-04-10 22:54:07 45.13434354 -112.89846940000001 1 0 0 0 Beaverhead, Montana, US
139 139 40009 Beckham Oklahoma US 2020-04-10 22:54:07 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
153 153 27009 Benton Minnesota US 2020-04-10 22:54:07 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
169 169 2050 Bethel Alaska US 2020-04-10 22:54:07 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
174 174 30003 Big Horn Montana US 2020-04-10 22:54:07 45.42335905 -107.492347 1 0 0 0 Big Horn, Montana, US
175 175 27011 Big Stone Minnesota US 2020-04-10 22:54:07 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
179 179 37017 Bladen North Carolina US 2020-04-10 22:54:07 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
184 184 13023 Bleckley Georgia US 2020-04-10 22:54:07 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
201 201 54005 Boone West Virginia US 2020-04-10 22:54:07 38.01974191 -81.69888019 1 0 0 0 Boone, West Virginia, US
208 208 38011 Bowman North Dakota US 2020-04-10 22:54:07 46.11285362 -103.5203343 1 0 0 0 Bowman, North Dakota, US
212 212 21023 Bracken Kentucky US 2020-04-10 22:54:07 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
219 219 54007 Braxton West Virginia US 2020-04-10 22:54:07 38.70036159 -80.72011184 1 0 0 0 Braxton, West Virginia, US
222 222 21025 Breathitt Kentucky US 2020-04-10 22:54:07 37.52333168 -83.31959161 1 0 0 0 Breathitt, Kentucky, US
228 228 51520 Bristol Virginia US 2020-04-10 22:54:07 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
248 248 51027 Buchanan Virginia US 2020-04-10 22:54:07 37.26818323 -82.03749726 1 0 0 0 Buchanan, Virginia, US
251 251 19021 Buena Vista Iowa US 2020-04-10 22:54:07 42.73545875 -95.15100162 1 0 0 0 Buena Vista, Iowa, US
267 267 31021 Burt Nebraska US 2020-04-10 22:54:07 41.85056773 -96.32605633 1 0 0 0 Burt, Nebraska, US
269 269 19023 Butler Iowa US 2020-04-10 22:54:07 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
287 287 29025 Caldwell Missouri US 2020-04-10 22:54:07 39.65620858 -93.98308093 1 0 0 0 Caldwell, Missouri, US
294 294 17013 Calhoun Illinois US 2020-04-10 22:54:07 39.16840183 -90.66330078 1 0 0 0 Calhoun, Illinois, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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