04-09-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,912 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-09 23:02:37 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US
127 127 51017 Bath Virginia US 2020-04-09 23:02:37 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
151 151 18007 Benton Indiana US 2020-04-09 23:02:37 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
159 159 26019 Benzie Michigan US 2020-04-09 23:02:37 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
182 182 51021 Bland Virginia US 2020-04-09 23:02:37 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
275 275 46019 Butte South Dakota US 2020-04-09 23:02:37 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
570 570 47033 Crockett Tennessee US 2020-04-09 23:02:37 35.81830662 -89.14916269 0 0 0 0 Crockett, Tennessee, US
657 657 51051 Dickenson Virginia US 2020-04-09 23:02:37 37.12560977 -82.35124171 0 0 0 0 Dickenson, Virginia, US
745 745 51057 Essex Virginia US 2020-04-09 23:02:37 37.93357639 -76.94230311 0 0 0 0 Essex, Virginia, US
750 750 51600 Fairfax City Virginia US 2020-04-09 23:02:37 38.85157547 -77.29779640000002 0 0 0 0 Fairfax City, Virginia, US
756 756 51610 Falls Church Virginia US 2020-04-09 23:02:37 38.88485255 -77.17560759 0 0 0 0 Falls Church, Virginia, US
857 857 1061 Geneva Alabama US 2020-04-09 23:02:37 31.09389027 -85.83572839 0 0 0 0 Geneva, Alabama, US
913 913 51077 Grayson Virginia US 2020-04-09 23:02:37 36.65677234 -81.23215889 0 0 0 0 Grayson, Virginia, US
980 980 47067 Hancock Tennessee US 2020-04-09 23:02:37 36.52692871 -83.22375847 0 0 0 0 Hancock, Tennessee, US
1041 1041 51091 Highland Virginia US 2020-04-09 23:02:37 38.35799465 -79.56124594 0 0 0 0 Highland, Virginia, US
1241 1241 46077 Kingsbury South Dakota US 2020-04-09 23:02:37 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1285 1285 47095 Lake Tennessee US 2020-04-09 23:02:37 36.34180170000001 -89.48921915 0 0 0 0 Lake, Tennessee, US
1350 1350 16061 Lewis Idaho US 2020-04-09 23:02:37 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1401 1401 31113 Logan Nebraska US 2020-04-09 23:02:37 41.56650314 -100.4817851 0 0 0 0 Logan, Nebraska, US
1511 1511 51690 Martinsville Virginia US 2020-04-09 23:02:37 36.68212094 -79.86352771 0 0 0 0 Martinsville, Virginia, US
1572 1572 38057 Mercer North Dakota US 2020-04-09 23:02:37 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1653 1653 47127 Moore Tennessee US 2020-04-09 23:02:37 35.27724699 -86.36230578 0 0 0 0 Moore, Tennessee, US
1734 1734 51720 Norton Virginia US 2020-04-09 23:02:37 36.93357076 -82.62750411 0 0 0 0 Norton, Virginia, US
1770 1770 26131 Ontonagon Michigan US 2020-04-09 23:02:37 46.665226200000006 -89.31390481 0 0 0 0 Ontonagon, Michigan, US
1805 1805 80008 Out of CO Colorado US 2020-04-09 23:02:37     0 1 0 0 Out of CO,Colorado,US
1831 1831 51141 Patrick Virginia US 2020-04-09 23:02:37 36.680163799999995 -80.2865648 0 0 0 0 Patrick, Virginia, US
1848 1848 55091 Pepin Wisconsin US 2020-04-09 23:02:37 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1897 1897 56031 Platte Wyoming US 2020-04-09 23:02:37 42.13299116 -104.96633100000001 0 0 0 0 Platte, Wyoming, US
1955 1955 39137 Putnam Ohio US 2020-04-09 23:02:37 41.02094889 -84.1336111 0 0 0 0 Putnam, Ohio, US
1991 1991 47143 Rhea Tennessee US 2020-04-09 23:02:37 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
2030 2030 38079 Rolette North Dakota US 2020-04-09 23:02:37 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
2111 2111 51169 Scott Virginia US 2020-04-09 23:02:37 36.71466456 -82.60171704 0 0 0 0 Scott, Virginia, US
2297 2297 29215 Texas Missouri US 2020-04-09 23:02:37 37.31728859 -91.96564727 0 0 0 0 Texas, Missouri, US
2349 2349 90002 Unassigned Alaska US 2020-04-09 23:02:37     0 2 0 0 Unassigned, Alaska, US
2350 2350 90004 Unassigned Arizona US 2020-04-09 23:02:37     0 18 0 0 Unassigned, Arizona, US
2355 2355 90010 Unassigned Delaware US 2020-04-09 23:02:37     0 3 0 0 Unassigned, Delaware, US
2359 2359 90016 Unassigned Idaho US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Idaho, US
2361 2361 90018 Unassigned Indiana US 2020-04-09 23:02:37     0 129 0 0 Unassigned, Indiana, US
2362 2362 90019 Unassigned Iowa US 2020-04-09 23:02:37     0 3 0 0 Unassigned, Iowa, US
2363 2363 90020 Unassigned Kansas US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Kansas, US
2367 2367 90024 Unassigned Maryland US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Maryland, US
2371 2371 90028 Unassigned Mississippi US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Mississippi, US
2372 2372 90029 Unassigned Missouri US 2020-04-09 23:02:37     0 1 0 0 Unassigned, Missouri, US
2373 2373 90030 Unassigned Montana US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Montana, US
2374 2374 90031 Unassigned Nebraska US 2020-04-09 23:02:37     0 2 0 0 Unassigned, Nebraska, US
2378 2378 90035 Unassigned New Mexico US 2020-04-09 23:02:37     0 0 0 0 Unassigned, New Mexico, US
2379 2379 90036 Unassigned New York US 2020-04-09 23:02:37     0 73 0 0 Unassigned, New York, US
2380 2380 90038 Unassigned North Dakota US 2020-04-09 23:02:37     0 0 0 0 Unassigned, North Dakota, US
2381 2381 90039 Unassigned Ohio US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Ohio, US
2382 2382 90040 Unassigned Oklahoma US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Oklahoma, US
2383 2383 90041 Unassigned Oregon US 2020-04-09 23:02:37     0 1 0 0 Unassigned, Oregon, US
2384 2384 90042 Unassigned Pennsylvania US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Pennsylvania, US
2386 2386 90046 Unassigned South Dakota US 2020-04-09 23:02:37     0 0 0 0 Unassigned, South Dakota, US
2388 2388 90049 Unassigned Utah US 2020-04-09 23:02:37     0 0 0 0 Unassigned,Utah,US
2390 2390 90051 Unassigned Virginia US 2020-04-09 23:02:37     0 78 0 0 Unassigned, Virginia, US
2392 2392 90054 Unassigned West Virginia US 2020-04-09 23:02:37     0 1 0 0 Unassigned, West Virginia, US
2393 2393 90055 Unassigned Wisconsin US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Wisconsin, US
2394 2394   Unassigned Wyoming US 2020-04-09 23:02:37     0 0 0 0 Unassigned,Wyoming,US
2422 2422 47175 Van Buren Tennessee US 2020-04-09 23:02:37 35.69864497 -85.45221699 0 0 0 0 Van Buren, Tennessee, US
2656 2656     Diamond Princess Canada 2020-04-09 23:09:01     0 1 0 0 Diamond Princess, Canada
2700 2700     Nunavut Canada 2020-04-09 23:09:01 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2707 2707     Recovered Canada 2020-04-09 23:09:01     0 0 5162 0 Recovered, Canada
2708 2708     Recovered US 2020-04-09 23:02:37     0 0 25410 0 Recovered, US
2711 2711     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-09 23:02:19 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2873 2873       Samoa 2020-04-09 23:09:01 -13.759 -172.1046 0 0 0 0 Samoa
5 5 19001 Adair Iowa US 2020-04-09 23:02:37 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 16003 Adams Idaho US 2020-04-09 23:02:37 44.89333571 -116.4545247 1 0 0 0 Adams, Idaho, US
11 11 17001 Adams Illinois US 2020-04-09 23:02:37 39.98815591 -91.18786813 1 0 0 0 Adams, Illinois, US
43 43 6003 Alpine California US 2020-04-09 23:02:37 38.59678594 -119.82235940000001 1 0 0 0 Alpine, California, US
60 60 31003 Antelope Nebraska US 2020-04-09 23:02:37 42.17695516 -98.06662829999999 1 0 0 0 Antelope, Nebraska, US
63 63 19007 Appanoose Iowa US 2020-04-09 23:02:37 40.74324454 -92.86865906 1 1 0 0 Appanoose, Iowa, US
77 77 55003 Ashland Wisconsin US 2020-04-09 23:02:37 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
84 84 29005 Atchison Missouri US 2020-04-09 23:02:37 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
88 88 40005 Atoka Oklahoma US 2020-04-09 23:02:37 34.37366573 -96.03802487 1 0 0 0 Atoka, Oklahoma, US
90 90 19009 Audubon Iowa US 2020-04-09 23:02:37 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
93 93 46003 Aurora South Dakota US 2020-04-09 23:02:37 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
103 103 21007 Ballard Kentucky US 2020-04-09 23:02:37 37.05842757 -88.99427697 1 0 0 0 Ballard, Kentucky, US
107 107 48019 Bandera Texas US 2020-04-09 23:02:37 29.74619598 -99.24598147 1 0 0 0 Bandera, Texas, US
110 110 20007 Barber Kansas US 2020-04-09 23:02:37 37.2288586 -98.68460053 1 0 0 0 Barber, Kansas, US
116 116 21009 Barren Kentucky US 2020-04-09 23:02:37 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
126 126 21011 Bath Kentucky US 2020-04-09 23:02:37 38.14735938 -83.74588932 1 0 0 0 Bath, Kentucky, US
136 136 40007 Beaver Oklahoma US 2020-04-09 23:02:37 36.7496847 -100.4758872 1 0 0 0 Beaver, Oklahoma, US
138 138 30001 Beaverhead Montana US 2020-04-09 23:02:37 45.13434354 -112.89846940000001 1 0 0 0 Beaverhead, Montana, US
139 139 40009 Beckham Oklahoma US 2020-04-09 23:02:37 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
143 143 48025 Bee Texas US 2020-04-09 23:02:37 28.41761668 -97.74215593 1 0 0 0 Bee, Texas, US
153 153 27009 Benton Minnesota US 2020-04-09 23:02:37 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
169 169 2050 Bethel Alaska US 2020-04-09 23:02:37 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
174 174 27011 Big Stone Minnesota US 2020-04-09 23:02:37 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
178 178 37017 Bladen North Carolina US 2020-04-09 23:02:37 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
183 183 13023 Bleckley Georgia US 2020-04-09 23:02:37 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
200 200 54005 Boone West Virginia US 2020-04-09 23:02:37 38.01974191 -81.69888019 1 0 0 0 Boone, West Virginia, US
207 207 38011 Bowman North Dakota US 2020-04-09 23:02:37 46.11285362 -103.5203343 1 0 0 0 Bowman, North Dakota, US
211 211 21023 Bracken Kentucky US 2020-04-09 23:02:37 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
218 218 54007 Braxton West Virginia US 2020-04-09 23:02:37 38.70036159 -80.72011184 1 0 0 0 Braxton, West Virginia, US
221 221 21025 Breathitt Kentucky US 2020-04-09 23:02:37 37.52333168 -83.31959161 1 0 0 0 Breathitt, Kentucky, US
227 227 51520 Bristol Virginia US 2020-04-09 23:02:37 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
242 242 51025 Brunswick Virginia US 2020-04-09 23:02:37 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
247 247 51027 Buchanan Virginia US 2020-04-09 23:02:37 37.26818323 -82.03749726 1 0 0 0 Buchanan, Virginia, US
250 250 19021 Buena Vista Iowa US 2020-04-09 23:02:37 42.73545875 -95.15100162 1 0 0 0 Buena Vista, Iowa, US
266 266 31021 Burt Nebraska US 2020-04-09 23:02:37 41.85056773 -96.32605633 1 0 0 0 Burt, Nebraska, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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