04-12-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,990 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
165 165 54003 Berkeley West Virginia US 2020-04-12 23:18:00 39.46704621 -78.02414609 92 0 0 92 Berkeley, West Virginia, US
169 169 13019 Berrien Georgia US 2020-04-12 23:18:00 31.27590016 -83.2252992 6 0 0 6 Berrien, Georgia, US
172 172 2050 Bethel Alaska US 2020-04-12 23:18:00 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
174 174 1007 Bibb Alabama US 2020-04-12 23:18:00 32.99642064 -87.1251146 16 0 0 16 Bibb, Alabama, US
177 177 30003 Big Horn Montana US 2020-04-12 23:18:00 45.42335905 -107.492347 1 0 0 1 Big Horn, Montana, US
178 178 56003 Big Horn Wyoming US 2020-04-12 23:18:00 44.52405055 -107.9960365 1 0 0 1 Big Horn, Wyoming, US
179 179 27011 Big Stone Minnesota US 2020-04-12 23:18:00 45.42712824 -96.41403739 1 0 0 1 Big Stone, Minnesota, US
180 180 16011 Bingham Idaho US 2020-04-12 23:18:00 43.2167288 -112.3978437 2 0 0 2 Bingham, Idaho, US
181 181 19013 Black Hawk Iowa US 2020-04-12 23:18:00 42.4704581 -92.30524729 47 0 0 47 Black Hawk, Iowa, US
182 182 18009 Blackford Indiana US 2020-04-12 23:18:00 40.47388153 -85.32499702 5 0 0 5 Blackford, Indiana, US
183 183 37017 Bladen North Carolina US 2020-04-12 23:18:00 34.61296243 -78.56180059 1 0 0 1 Bladen, North Carolina, US
185 185 42013 Blair Pennsylvania US 2020-04-12 23:18:00 40.47961444 -78.34917412 10 0 0 10 Blair, Pennsylvania, US
186 186 48031 Blanco Texas US 2020-04-12 23:18:00 30.26640707 -98.3999852 4 0 0 4 Blanco, Texas, US
187 187 51021 Bland Virginia US 2020-04-12 23:18:00 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
188 188 13023 Bleckley Georgia US 2020-04-12 23:18:00 32.43829035 -83.33035166 1 0 0 1 Bleckley, Georgia, US
189 189 47007 Bledsoe Tennessee US 2020-04-12 23:18:00 35.59942968 -85.20611967 3 0 0 3 Bledsoe, Tennessee, US
190 190 1009 Blount Alabama US 2020-04-12 23:18:00 33.98210918 -86.56790593 17 0 0 13 Blount, Alabama, US
192 192 27013 Blue Earth Minnesota US 2020-04-12 23:18:00 44.03554215 -94.06699781 22 0 0 22 Blue Earth, Minnesota, US
194 194 29017 Bollinger Missouri US 2020-04-12 23:18:00 37.32449052 -90.02725304 3 0 0 3 Bollinger, Missouri, US
195 195 46009 Bon Homme South Dakota US 2020-04-12 23:18:00 42.98914167 -97.88592746 4 0 0 4 Bon Homme, South Dakota, US
196 196 17005 Bond Illinois US 2020-04-12 23:18:00 38.88829622 -89.43534887 4 0 0 4 Bond, Illinois, US
197 197 16017 Bonner Idaho US 2020-04-12 23:18:00 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
198 198 16019 Bonneville Idaho US 2020-04-12 23:18:00 43.38713372 -111.6161537 12 0 0 12 Bonneville, Idaho, US
199 199 5009 Boone Arkansas US 2020-04-12 23:18:00 36.3084504 -93.09374925 3 0 0 3 Boone, Arkansas, US
202 202 19015 Boone Iowa US 2020-04-12 23:18:00 42.03657094 -93.9313999 4 0 0 4 Boone, Iowa, US
205 205 54005 Boone West Virginia US 2020-04-12 23:18:00 38.01974191 -81.69888019 1 0 0 1 Boone, West Virginia, US
207 207 51023 Botetourt Virginia US 2020-04-12 23:18:00 37.55531756 -79.80982182 23 0 0 23 Botetourt, Virginia, US
212 212 38011 Bowman North Dakota US 2020-04-12 23:18:00 46.11285362 -103.5203343 1 0 0 1 Bowman, North Dakota, US
213 213 31013 Box Butte Nebraska US 2020-04-12 23:18:00 42.22079243 -103.0878834 1 0 0 1 Box Butte, Nebraska, US
214 214 49003 Box Elder Utah US 2020-04-12 23:18:00 41.52106798 -113.0832816 13 0 0 13 Box Elder, Utah, US
216 216 21021 Boyle Kentucky US 2020-04-12 23:18:00 37.62680923 -84.8633779 13 0 0 13 Boyle, Kentucky, US
217 217 21023 Bracken Kentucky US 2020-04-12 23:18:00 38.69158994 -84.08532444 6 0 0 6 Bracken, Kentucky, US
219 219 42015 Bradford Pennsylvania US 2020-04-12 23:18:00 41.78869215 -76.51570822 18 0 0 18 Bradford, Pennsylvania, US
220 220 5011 Bradley Arkansas US 2020-04-12 23:18:00 33.46755808 -92.15980837 7 0 0 7 Bradley, Arkansas, US
221 221 47011 Bradley Tennessee US 2020-04-12 23:18:00 35.15739424 -84.857186 31 0 0 31 Bradley, Tennessee, US
224 224 54007 Braxton West Virginia US 2020-04-12 23:18:00 38.70036159 -80.72011184 1 0 0 1 Braxton, West Virginia, US
227 227 21025 Breathitt Kentucky US 2020-04-12 23:18:00 37.52333168 -83.31959161 2 0 0 2 Breathitt, Kentucky, US
228 228 21027 Breckinridge Kentucky US 2020-04-12 23:18:00 37.77377239 -86.42885017 3 0 0 3 Breckinridge, Kentucky, US
229 229 19017 Bremer Iowa US 2020-04-12 23:18:00 42.77461496 -92.31795937 3 0 0 3 Bremer, Iowa, US
232 232 44001 Bristol Rhode Island US 2020-04-12 23:18:00 41.71018079 -71.28652315 39 0 0 39 Bristol, Rhode Island, US
233 233 51520 Bristol Virginia US 2020-04-12 23:18:00 36.6163024 -82.16359122 1 0 0 1 Bristol, Virginia, US
234 234 30007 Broadwater Montana US 2020-04-12 23:18:00 46.33277565 -111.4955813 4 0 0 4 Broadwater, Montana, US
235 235 54009 Brooke West Virginia US 2020-04-12 23:18:00 40.27367263 -80.57915332 3 0 0 3 Brooke, West Virginia, US
236 236 46011 Brookings South Dakota US 2020-04-12 23:18:00 44.36974375 -96.79079945 8 0 0 8 Brookings, South Dakota, US
244 244 46013 Brown South Dakota US 2020-04-12 23:18:00 45.58994323 -98.35165355 14 0 0 14 Brown, South Dakota, US
245 245 48049 Brown Texas US 2020-04-12 23:18:00 31.77430356 -98.99907113 10 0 0 10 Brown, Texas, US
247 247 46015 Brule South Dakota US 2020-04-12 23:18:00 43.71756379 -99.08118954 1 0 0 1 Brule, South Dakota, US
249 249 51025 Brunswick Virginia US 2020-04-12 23:18:00 36.76366949 -77.8593436 3 0 0 3 Brunswick, Virginia, US
251 251 40013 Bryan Oklahoma US 2020-04-12 23:18:00 33.96472458 -96.25903472 3 0 0 3 Bryan, Oklahoma, US
252 252 19019 Buchanan Iowa US 2020-04-12 23:18:00 42.4709188 -91.83510825 7 0 0 7 Buchanan, Iowa, US
254 254 51027 Buchanan Virginia US 2020-04-12 23:18:00 37.26818323 -82.03749726 2 0 0 2 Buchanan, Virginia, US
255 255 51029 Buckingham Virginia US 2020-04-12 23:18:00 37.57242268 -78.52518834 14 0 0 14 Buckingham, Virginia, US
257 257 19021 Buena Vista Iowa US 2020-04-12 23:18:00 42.73545875 -95.15100162 2 0 0 2 Buena Vista, Iowa, US
258 258 51530 Buena Vista Virginia US 2020-04-12 23:18:00 37.73484642 -79.35296097 4 0 0 4 Buena Vista, Virginia, US
263 263 1011 Bullock Alabama US 2020-04-12 23:18:00 32.10030533 -85.71265535 4 0 0 4 Bullock, Alabama, US
265 265 17011 Bureau Illinois US 2020-04-12 23:18:00 41.40385234 -89.5283051 5 0 0 5 Bureau, Illinois, US
268 268 38013 Burke North Dakota US 2020-04-12 23:18:00 48.79094471 -102.5182117 2 0 0 2 Burke, North Dakota, US
269 269 38015 Burleigh North Dakota US 2020-04-12 23:18:00 46.97847375 -100.4645214 50 0 0 50 Burleigh, North Dakota, US
270 270 48051 Burleson Texas US 2020-04-12 23:18:00 30.49273808 -96.62158484 6 0 0 6 Burleson, Texas, US
272 272 48053 Burnet Texas US 2020-04-12 23:18:00 30.78801353 -98.181887 6 0 0 6 Burnet, Texas, US
273 273 31021 Burt Nebraska US 2020-04-12 23:18:00 41.85056773 -96.32605633 1 0 0 1 Burt, Nebraska, US
274 274 1013 Butler Alabama US 2020-04-12 23:18:00 31.75300095 -86.68057478 7 0 0 7 Butler, Alabama, US
275 275 19023 Butler Iowa US 2020-04-12 23:18:00 42.73172833 -92.79015971 1 0 0 1 Butler, Iowa, US
276 276 20015 Butler Kansas US 2020-04-12 23:18:00 37.78134351 -96.83878537 8 0 0 8 Butler, Kansas, US
277 277 21031 Butler Kentucky US 2020-04-12 23:18:00 37.20946153 -86.68748787 11 0 0 11 Butler, Kentucky, US
278 278 29023 Butler Missouri US 2020-04-12 23:18:00 36.71462476 -90.40421163 13 0 0 13 Butler, Missouri, US
281 281 6007 Butte California US 2020-04-12 23:18:00 39.66727762 -121.6005252 14 0 0 14 Butte, California, US
282 282 46019 Butte South Dakota US 2020-04-12 23:18:00 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
283 283 13035 Butts Georgia US 2020-04-12 23:18:00 33.2830945 -83.9543504 28 0 0 28 Butts, Georgia, US
285 285 54011 Cabell West Virginia US 2020-04-12 23:18:00 38.42424062 -82.23855912 22 0 0 22 Cabell, West Virginia, US
286 286 49005 Cache Utah US 2020-04-12 23:18:00 41.72330587 -111.7443667 33 0 0 33 Cache, Utah, US
288 288 40015 Caddo Oklahoma US 2020-04-12 23:18:00 35.17364557 -98.37534464 9 0 0 9 Caddo, Oklahoma, US
289 289 6009 Calaveras California US 2020-04-12 23:18:00 38.20537103 -120.552913 8 0 0 8 Calaveras, California, US
291 291 21033 Caldwell Kentucky US 2020-04-12 23:18:00 37.14749129 -87.86948214 10 0 0 10 Caldwell, Kentucky, US
292 292 22021 Caldwell Louisiana US 2020-04-12 23:18:00 32.0902519 -92.11752148 18 0 0 18 Caldwell, Louisiana, US
293 293 29025 Caldwell Missouri US 2020-04-12 23:18:00 39.65620858 -93.98308093 1 0 0 1 Caldwell, Missouri, US
294 294 37027 Caldwell North Carolina US 2020-04-12 23:18:00 35.95204977 -81.54799522 17 0 0 17 Caldwell, North Carolina, US
295 295 48055 Caldwell Texas US 2020-04-12 23:18:00 29.83668859 -97.61814775 6 0 0 6 Caldwell, Texas, US
296 296 50005 Caledonia Vermont US 2020-04-12 23:18:00 44.46548598 -72.10314651 8 0 0 8 Caledonia, Vermont, US
297 297 1015 Calhoun Alabama US 2020-04-12 23:18:00 33.77483727 -85.82630386 63 0 0 59 Calhoun, Alabama, US
298 298 12013 Calhoun Florida US 2020-04-12 23:18:00 30.40666734 -85.19394153 5 0 0 5 Calhoun, Florida, US
300 300 17013 Calhoun Illinois US 2020-04-12 23:18:00 39.16840183 -90.66330078 1 0 0 1 Calhoun, Illinois, US
302 302 28013 Calhoun Mississippi US 2020-04-12 23:18:00 33.93683395 -89.33686647 18 0 0 18 Calhoun, Mississippi, US
304 304 48057 Calhoun Texas US 2020-04-12 23:18:00 28.47048236 -96.61633945 15 0 0 15 Calhoun, Texas, US
305 305 48059 Callahan Texas US 2020-04-12 23:18:00 32.29760619 -99.37326312 1 0 0 1 Callahan, Texas, US
308 308 55015 Calumet Wisconsin US 2020-04-12 23:18:00 44.0816316 -88.21780273 4 0 0 4 Calumet, Wisconsin, US
310 310 16025 Camas Idaho US 2020-04-12 23:18:00 43.46665742 -114.8065892 1 0 0 1 Camas, Idaho, US
312 312 13039 Camden Georgia US 2020-04-12 23:18:00 30.92951916 -81.66601818 20 0 0 20 Camden, Georgia, US
315 315 22023 Cameron Louisiana US 2020-04-12 23:18:00 29.87592238 -93.19310676 2 0 0 2 Cameron, Louisiana, US
316 316 42023 Cameron Pennsylvania US 2020-04-12 23:18:00 41.43625568 -78.20376845 1 0 0 1 Cameron, Pennsylvania, US
318 318 48063 Camp Texas US 2020-04-12 23:18:00 32.97195142 -94.97790104 3 0 0 3 Camp, Texas, US
320 320 47013 Campbell Tennessee US 2020-04-12 23:18:00 36.40355516 -84.1510856 10 0 0 10 Campbell, Tennessee, US
321 321 51031 Campbell Virginia US 2020-04-12 23:18:00 37.20553386 -79.09678609 9 0 0 9 Campbell, Virginia, US
322 322 56005 Campbell Wyoming US 2020-04-12 23:18:00 44.24886082 -105.5474404 11 0 0 11 Campbell, Wyoming, US
324 324 13043 Candler Georgia US 2020-04-12 23:18:00 32.40209349 -82.07702563 4 0 0 4 Candler, Georgia, US
325 325 47015 Cannon Tennessee US 2020-04-12 23:18:00 35.80990797 -86.05738983 7 0 0 7 Cannon, Tennessee, US
329 329 30009 Carbon Montana US 2020-04-12 23:18:00 45.22850116 -109.0274047 6 0 0 6 Carbon, Montana, US
331 331 49007 Carbon Utah US 2020-04-12 23:18:00 39.64834818 -110.5872512 2 0 0 2 Carbon, Utah, US
332 332 56007 Carbon Wyoming US 2020-04-12 23:18:00 41.69357844 -106.9326084 4 0 0 4 Carbon, Wyoming, US
333 333 16029 Caribou Idaho US 2020-04-12 23:18:00 42.77149116 -111.5597683 1 0 0 1 Caribou, Idaho, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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