04-07-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,858 rows sorted by Deaths

✎ 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
141 141 33001 Belknap New Hampshire US 2020-04-07 23:04:49 43.51637314 -71.41684235 18 0 0 0 Belknap, New Hampshire, US
144 144 27007 Beltrami Minnesota US 2020-04-07 23:04:49 47.97373527 -94.93732139 6 0 0 0 Beltrami, Minnesota, US
145 145 13017 Ben Hill Georgia US 2020-04-07 23:04:49 31.76095874 -83.22145359 6 0 0 0 Ben Hill, Georgia, US
146 146 50003 Bennington Vermont US 2020-04-07 23:04:49 43.03519828 -73.09048868 27 0 0 0 Bennington, Vermont, US
147 147 5007 Benton Arkansas US 2020-04-07 23:04:49 36.33644656 -94.25680817 42 0 0 0 Benton, Arkansas, US
148 148 18007 Benton Indiana US 2020-04-07 23:04:49 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
149 149 19011 Benton Iowa US 2020-04-07 23:04:49 42.08011739 -92.06463573 11 0 0 0 Benton, Iowa, US
150 150 27009 Benton Minnesota US 2020-04-07 23:04:49 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
151 151 28009 Benton Mississippi US 2020-04-07 23:04:49 34.81681228 -89.18945516 5 0 0 0 Benton, Mississippi, US
152 152 29015 Benton Missouri US 2020-04-07 23:04:49 38.29503305 -93.28756116 3 0 0 0 Benton, Missouri, US
154 154 47005 Benton Tennessee US 2020-04-07 23:04:49 36.07110411 -88.06849355 4 0 0 0 Benton, Tennessee, US
156 156 26019 Benzie Michigan US 2020-04-07 23:04:49 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
158 158 45015 Berkeley South Carolina US 2020-04-07 23:04:49 33.20222596 -79.94654523 55 0 0 0 Berkeley, South Carolina, US
159 159 54003 Berkeley West Virginia US 2020-04-07 23:04:49 39.46704621 -78.02414609 57 0 0 0 Berkeley, West Virginia, US
163 163 13019 Berrien Georgia US 2020-04-07 23:04:49 31.27590016 -83.22529920000002 4 0 0 0 Berrien, Georgia, US
166 166 2050 Bethel Alaska US 2020-04-07 23:04:49 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
168 168 1007 Bibb Alabama US 2020-04-07 23:04:49 32.99642064 -87.12511459999996 8 0 0 0 Bibb, Alabama, US
171 171 27011 Big Stone Minnesota US 2020-04-07 23:04:49 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
172 172 16011 Bingham Idaho US 2020-04-07 23:04:49 43.21672879999999 -112.3978437 2 0 0 0 Bingham, Idaho, US
173 173 19013 Black Hawk Iowa US 2020-04-07 23:04:49 42.4704581 -92.30524729 15 0 0 0 Black Hawk, Iowa, US
174 174 18009 Blackford Indiana US 2020-04-07 23:04:49 40.47388153 -85.32499702 4 0 0 0 Blackford, Indiana, US
175 175 37017 Bladen North Carolina US 2020-04-07 23:04:49 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
177 177 42013 Blair Pennsylvania US 2020-04-07 23:04:49 40.47961444 -78.34917412 6 0 0 0 Blair, Pennsylvania, US
178 178 48031 Blanco Texas US 2020-04-07 23:04:49 30.26640707 -98.3999852 4 0 0 0 Blanco, Texas, US
179 179 51021 Bland Virginia US 2020-04-07 23:04:49 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
180 180 13023 Bleckley Georgia US 2020-04-07 23:04:49 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
181 181 47007 Bledsoe Tennessee US 2020-04-07 23:04:49 35.59942968 -85.20611967 3 0 0 0 Bledsoe, Tennessee, US
182 182 1009 Blount Alabama US 2020-04-07 23:04:49 33.98210918 -86.56790593 13 0 0 0 Blount, Alabama, US
184 184 27013 Blue Earth Minnesota US 2020-04-07 23:04:49 44.03554215 -94.06699781 22 0 0 0 Blue Earth, Minnesota, US
186 186 29017 Bollinger Missouri US 2020-04-07 23:04:49 37.32449052 -90.02725304 2 0 0 0 Bollinger, Missouri, US
187 187 46009 Bon Homme South Dakota US 2020-04-07 23:04:49 42.98914167 -97.88592746 2 0 0 0 Bon Homme, South Dakota, US
188 188 17005 Bond Illinois US 2020-04-07 23:04:49 38.88829622 -89.43534887 3 0 0 0 Bond, Illinois, US
189 189 16017 Bonner Idaho US 2020-04-07 23:04:49 48.29996017 -116.6017932 3 0 0 0 Bonner, Idaho, US
190 190 16019 Bonneville Idaho US 2020-04-07 23:04:49 43.38713372 -111.6161537 6 0 0 0 Bonneville, Idaho, US
191 191 5009 Boone Arkansas US 2020-04-07 23:04:49 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
192 192 17007 Boone Illinois US 2020-04-07 23:04:49 42.32359279 -88.82345779 4 0 0 0 Boone, Illinois, US
194 194 19015 Boone Iowa US 2020-04-07 23:04:49 42.03657094 -93.9313999 3 0 0 0 Boone, Iowa, US
198 198 51023 Botetourt Virginia US 2020-04-07 23:04:49 37.55531756 -79.80982182 18 0 0 0 Botetourt, Virginia, US
203 203 38011 Bowman North Dakota US 2020-04-07 23:04:49 46.11285362 -103.5203343 1 0 0 0 Bowman, North Dakota, US
204 204 49003 Box Elder Utah US 2020-04-07 23:04:49 41.52106798 -113.08328159999999 13 0 0 0 Box Elder, Utah, US
206 206 21021 Boyle Kentucky US 2020-04-07 23:04:49 37.62680923 -84.8633779 7 0 0 0 Boyle, Kentucky, US
207 207 21023 Bracken Kentucky US 2020-04-07 23:04:49 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
208 208 12007 Bradford Florida US 2020-04-07 23:04:49 29.95079741 -82.16611613 11 0 0 0 Bradford, Florida, US
209 209 42015 Bradford Pennsylvania US 2020-04-07 23:04:49 41.78869215 -76.51570822 14 0 0 0 Bradford, Pennsylvania, US
210 210 5011 Bradley Arkansas US 2020-04-07 23:04:49 33.46755808 -92.15980837 5 0 0 0 Bradley, Arkansas, US
211 211 47011 Bradley Tennessee US 2020-04-07 23:04:49 35.15739424 -84.857186 25 0 0 0 Bradley, Tennessee, US
216 216 21025 Breathitt Kentucky US 2020-04-07 23:04:49 37.52333168 -83.31959161 1 0 0 0 Breathitt, Kentucky, US
217 217 21027 Breckinridge Kentucky US 2020-04-07 23:04:49 37.77377239 -86.42885017 2 0 0 0 Breckinridge, Kentucky, US
218 218 19017 Bremer Iowa US 2020-04-07 23:04:49 42.77461496 -92.31795937 2 0 0 0 Bremer, Iowa, US
219 219 12009 Brevard Florida US 2020-04-07 23:04:49 28.29409504 -80.73091022 98 0 0 0 Brevard, Florida, US
221 221 44001 Bristol Rhode Island US 2020-04-07 23:04:49 41.71018079 -71.28652315 27 0 0 0 Bristol, Rhode Island, US
222 222 51520 Bristol Virginia US 2020-04-07 23:04:49 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
223 223 30007 Broadwater Montana US 2020-04-07 23:04:49 46.33277565 -111.49558130000001 4 0 0 0 Broadwater, Montana, US
224 224 54009 Brooke West Virginia US 2020-04-07 23:04:49 40.27367263 -80.57915332 1 0 0 0 Brooke, West Virginia, US
225 225 46011 Brookings South Dakota US 2020-04-07 23:04:49 44.36974375 -96.79079945 6 0 0 0 Brookings, South Dakota, US
226 226 13027 Brooks Georgia US 2020-04-07 23:04:49 30.83922642 -83.58303423 6 0 0 0 Brooks, Georgia, US
231 231 27015 Brown Minnesota US 2020-04-07 23:04:49 44.24205652 -94.72562874 7 0 0 0 Brown, Minnesota, US
233 233 46013 Brown South Dakota US 2020-04-07 23:04:49 45.58994323 -98.35165355 13 0 0 0 Brown, South Dakota, US
234 234 48049 Brown Texas US 2020-04-07 23:04:49 31.77430356 -98.99907113 6 0 0 0 Brown, Texas, US
235 235 55009 Brown Wisconsin US 2020-04-07 23:04:49 44.452655299999996 -88.00411844 41 0 0 0 Brown, Wisconsin, US
237 237 51025 Brunswick Virginia US 2020-04-07 23:04:49 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
239 239 40013 Bryan Oklahoma US 2020-04-07 23:04:49 33.96472458 -96.25903472 3 0 0 0 Bryan, Oklahoma, US
240 240 19019 Buchanan Iowa US 2020-04-07 23:04:49 42.4709188 -91.83510825 5 0 0 0 Buchanan, Iowa, US
241 241 29021 Buchanan Missouri US 2020-04-07 23:04:49 39.65816401 -94.80138942 14 0 0 0 Buchanan, Missouri, US
242 242 51027 Buchanan Virginia US 2020-04-07 23:04:49 37.26818323 -82.03749726 1 0 0 0 Buchanan, Virginia, US
243 243 51029 Buckingham Virginia US 2020-04-07 23:04:49 37.57242268 -78.52518834 6 0 0 0 Buckingham, Virginia, US
245 245 51530 Buena Vista Virginia US 2020-04-07 23:04:49 37.73484642 -79.35296097 4 0 0 0 Buena Vista,Virginia,US
249 249 13031 Bulloch Georgia US 2020-04-07 23:04:49 32.39577406 -81.74811421 10 0 0 0 Bulloch, Georgia, US
250 250 1011 Bullock Alabama US 2020-04-07 23:04:49 32.10030533 -85.71265535 2 0 0 0 Bullock, Alabama, US
252 252 17011 Bureau Illinois US 2020-04-07 23:04:49 41.40385234 -89.5283051 3 0 0 0 Bureau, Illinois, US
253 253 13033 Burke Georgia US 2020-04-07 23:04:49 33.05917989 -81.99928721 14 0 0 0 Burke, Georgia, US
255 255 38013 Burke North Dakota US 2020-04-07 23:04:49 48.79094471 -102.51821170000001 2 0 0 0 Burke, North Dakota, US
256 256 38015 Burleigh North Dakota US 2020-04-07 23:04:49 46.97847375 -100.46452140000001 39 0 0 0 Burleigh, North Dakota, US
257 257 48051 Burleson Texas US 2020-04-07 23:04:49 30.49273808 -96.62158484 5 0 0 0 Burleson, Texas, US
259 259 48053 Burnet Texas US 2020-04-07 23:04:49 30.78801353 -98.181887 5 0 0 0 Burnet, Texas, US
260 260 1013 Butler Alabama US 2020-04-07 23:04:49 31.75300095 -86.68057478 2 0 0 0 Butler, Alabama, US
261 261 19023 Butler Iowa US 2020-04-07 23:04:49 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
262 262 20015 Butler Kansas US 2020-04-07 23:04:49 37.78134351 -96.83878537 8 0 0 0 Butler, Kansas, US
263 263 21031 Butler Kentucky US 2020-04-07 23:04:49 37.20946153 -86.68748787 1 0 0 0 Butler, Kentucky, US
264 264 29023 Butler Missouri US 2020-04-07 23:04:49 36.71462476 -90.40421163 5 0 0 0 Butler, Missouri, US
267 267 6007 Butte California US 2020-04-07 23:04:49 39.66727762 -121.6005252 12 0 0 0 Butte, California, US
268 268 46019 Butte South Dakota US 2020-04-07 23:04:49 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
269 269 13035 Butts Georgia US 2020-04-07 23:04:49 33.283094500000004 -83.95435040000002 17 0 0 0 Butts, Georgia, US
271 271 54011 Cabell West Virginia US 2020-04-07 23:04:49 38.42424062 -82.23855912 11 0 0 0 Cabell, West Virginia, US
272 272 49005 Cache Utah US 2020-04-07 23:04:49 41.72330587 -111.74436670000001 24 0 0 0 Cache, Utah, US
274 274 40015 Caddo Oklahoma US 2020-04-07 23:04:49 35.17364557 -98.37534464 6 0 0 0 Caddo, Oklahoma, US
275 275 6009 Calaveras California US 2020-04-07 23:04:49 38.20537103 -120.55291299999999 5 0 0 0 Calaveras, California, US
277 277 21033 Caldwell Kentucky US 2020-04-07 23:04:49 37.14749129 -87.86948214 2 0 0 0 Caldwell, Kentucky, US
278 278 22021 Caldwell Louisiana US 2020-04-07 23:04:49 32.0902519 -92.11752148 13 0 0 0 Caldwell, Louisiana, US
279 279 29025 Caldwell Missouri US 2020-04-07 23:04:49 39.65620858 -93.98308093 1 0 0 0 Caldwell, Missouri, US
280 280 37027 Caldwell North Carolina US 2020-04-07 23:04:49 35.95204977 -81.54799522 11 0 0 0 Caldwell, North Carolina, US
281 281 48055 Caldwell Texas US 2020-04-07 23:04:49 29.83668859 -97.61814775 5 0 0 0 Caldwell, Texas, US
282 282 50005 Caledonia Vermont US 2020-04-07 23:04:49 44.46548598 -72.10314651 8 0 0 0 Caledonia, Vermont, US
283 283 1015 Calhoun Alabama US 2020-04-07 23:04:49 33.77483727 -85.82630386 51 0 0 0 Calhoun, Alabama, US
284 284 12013 Calhoun Florida US 2020-04-07 23:04:49 30.40666734 -85.19394153 3 0 0 0 Calhoun, Florida, US
286 286 17013 Calhoun Illinois US 2020-04-07 23:04:49 39.16840183 -90.66330078 1 0 0 0 Calhoun, Illinois, US
288 288 28013 Calhoun Mississippi US 2020-04-07 23:04:49 33.93683395 -89.33686647 10 0 0 0 Calhoun, Mississippi, US
290 290 48057 Calhoun Texas US 2020-04-07 23:04:49 28.47048236 -96.61633945 12 0 0 0 Calhoun, Texas, US
291 291 48059 Callahan Texas US 2020-04-07 23:04:49 32.29760619 -99.37326312 1 0 0 0 Callahan, Texas, US
293 293 21035 Calloway Kentucky US 2020-04-07 23:04:49 36.62093411 -88.2731593 5 0 0 0 Calloway, Kentucky, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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