03-28-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

3,433 rows sorted by Confirmed descending

✎ 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
3205 3205     Hong Kong China 3/28/20 12:50 22.3 114.2 561 4 112 445 Hong Kong, China
3245 3245     Sichuan China 3/27/20 2:27 30.6171 102.7103 548 3 536 9 Sichuan, China
3171 3171     Alberta Canada 3/28/20 23:10 53.9333 -116.5765 542 2 0 0 Alberta, Canada
1930 1930 55079 Milwaukee Wisconsin US 3/28/20 23:05 43.00486062 -87.96733172 541 9 0 0 Milwaukee, Wisconsin, US
1746 1746 26099 Macomb Michigan US 3/28/20 23:05 42.69158356 -82.92752801 534 17 0 0 Macomb, Michigan, US
3336 3336       Iraq 3/28/20 23:05 33.223191 43.679291 506 42 131 333 Iraq
2091 2091 25021 Norfolk Massachusetts US 3/28/20 23:05 42.16073095 -71.20530408 490 8 0 0 Norfolk, Massachusetts, US
3243 3243     Shanghai China 3/28/20 2:01 31.202 121.4491 485 5 334 146 Shanghai, China
3203 3203     Heilongjiang China 3/26/20 0:15 47.862 127.7615 484 13 469 2 Heilongjiang, China
3271 3271       Bahrain 3/28/20 23:05 26.0275 50.55 476 4 265 207 Bahrain
888 888 25009 Essex Massachusetts US 3/28/20 23:05 42.6687626 -70.94687179 472 3 0 0 Essex, Massachusetts, US
3425 3425       United Arab Emirates 3/28/20 23:05 23.424076 53.847818 468 2 52 414 United Arab Emirates
1788 1788 4013 Maricopa Arizona US 3/28/20 23:05 33.34835867 -112.4918154 454 5 0 0 Maricopa, Arizona, US
3262 3262       Algeria 3/28/20 23:05 28.0339 1.6596 454 29 31 394 Algeria
3375 3375       New Zealand 3/28/20 23:05 -40.9006 174.886 451 0 50 401 New Zealand
1212 1212 48201 Harris Texas US 3/28/20 23:05 29.85864939 -95.39339521 445 2 0 0 Harris, Texas, US
528 528 32003 Clark Nevada US 3/28/20 23:05 36.21458855 -115.0130241 443 10 0 0 Clark, Nevada, US
2018 2018 34027 Morris New Jersey US 3/28/20 23:05 40.86095313 -74.5455371 442 3 0 0 Morris, New Jersey, US
713 713 48113 Dallas Texas US 3/28/20 23:05 32.76670599 -96.7779605 439 9 0 0 Dallas, Texas, US
2508 2508 6073 San Diego California US 3/28/20 23:05 33.03484597 -116.7365326 413 6 0 0 San Diego, California, US
3351 3351       Lebanon 3/28/20 23:05 33.8547 35.8623 412 8 30 374 Lebanon
1992 1992 42091 Montgomery Pennsylvania US 3/28/20 23:05 40.21053671 -75.36652296 411 5 0 0 Montgomery, Pennsylvania, US
3267 3267       Armenia 3/28/20 23:05 40.0691 45.0382 407 1 30 376 Armenia
2143 2143 6059 Orange California US 3/28/20 23:05 33.70147516 -117.7645998 403 4 0 0 Orange, California, US
3370 3370       Morocco 3/28/20 23:05 31.7917 -7.0926 402 25 11 366 Morocco
722 722 47037 Davidson Tennessee US 3/28/20 23:05 36.17007426 -86.78646056 376 2 0 0 Davidson, Tennessee, US
995 995 13121 Fulton Georgia US 3/28/20 23:05 33.79216944 -84.46319413 373 12 0 0 Fulton, Georgia, US
701 701 39035 Cuyahoga Ohio US 3/28/20 23:05 41.424119 -81.65918339 370 3 0 0 Cuyahoga, Ohio, US
2868 2868   Unassigned Massachusetts US 3/28/20 23:05 0.0 0.0 356 9 0 0 Unassigned, Massachusetts, US
3424 3424       Ukraine 3/28/20 23:05 48.3794 31.1656 356 9 5 342 Ukraine
3331 3331       Hungary 3/28/20 23:05 47.1625 19.5033 343 11 34 298 Hungary
3355 3355       Lithuania 3/28/20 23:05 55.1694 23.8813 339 4 0 386 Lithuania
3190 3190     Fujian China 3/28/20 1:35 26.0789 117.9874 337 1 295 41 Fujian, China
3283 3283       Bulgaria 3/28/20 23:05 42.7339 25.4858 331 7 11 313 Bulgaria
3202 3202     Hebei China 3/23/20 1:53 39.549 116.1306 319 6 310 3 Hebei, China
882 882 36029 Erie New York US 3/28/20 23:05 42.76249024 -78.73063652 318 6 0 0 Erie, New York, US
2672 2672 29189 St. Louis Missouri US 3/28/20 23:05 38.6377004 -90.4458375 313 2 0 0 St. Louis, Missouri, US
770 770 8031 Denver Colorado US 3/28/20 23:05 39.76018276 -104.8725695 312 3 0 0 Denver, Colorado, US
2509 2509 6075 San Francisco California US 3/28/20 23:05 37.75215114 -122.4385672 308 4 0 0 San Francisco, California, US
3263 3263       Andorra 3/28/20 23:05 42.5063 1.5218 308 3 1 304 Andorra
3350 3350       Latvia 3/28/20 23:05 56.8796 24.6032 305 0 1 304 Latvia
789 789 11001 District of Columbia District of Columbia US 3/28/20 23:05 38.90417773 -77.01655992 304 4 0 0 District of Columbia,District of Columbia,US
1882 1882 37119 Mecklenburg North Carolina US 3/28/20 23:05 35.24469268 -80.8317671 299 0 0 0 Mecklenburg, North Carolina, US
3295 3295       Costa Rica 3/28/20 23:05 9.7489 -83.7534 295 2 3 290 Costa Rica
2193 2193 12099 Palm Beach Florida US 3/28/20 23:05 26.64676272 -80.46536002 292 5 0 0 Palm Beach, Florida, US
3404 3404       Slovakia 3/28/20 23:05 48.669 19.699 292 0 2 290 Slovakia
3129 3129 25027 Worcester Massachusetts US 3/28/20 23:05 42.35026951 -71.90493363 291 5 0 0 Worcester, Massachusetts, US
3247 3247     South Australia Australia 3/28/20 23:11 -34.9285 138.6007 287 0 6 281 South Australia, Australia
3415 3415       Taiwan* 3/28/20 6:58 23.7 121.0 283 2 30 251 Taiwan*
3255 3255     Western Australia Australia 3/28/20 23:11 -31.9505 115.8605 278 2 28 248 Western Australia, Australia
3421 3421       Tunisia 3/28/20 23:05 33.886917 9.537499 278 8 2 268 Tunisia
2502 2502 49035 Salt Lake Utah US 3/28/20 23:05 40.66616532 -111.9216011 276 0 0 0 Salt Lake, Utah, US
2599 2599 47157 Shelby Tennessee US 3/28/20 23:05 35.1864775 -89.89692423 275 0 0 0 Shelby, Tennessee, US
2517 2517 6081 San Mateo California US 3/28/20 23:05 37.4228808 -122.3275546 274 6 0 0 San Mateo, California, US
3427 3427       Uruguay 3/28/20 23:05 -32.5228 -55.7658 274 0 0 274 Uruguay
2296 2296 25023 Plymouth Massachusetts US 3/28/20 23:05 41.94070556 -70.80802823 272 0 0 0 Plymouth, Massachusetts, US
833 833 36027 Dutchess New York US 3/28/20 23:05 41.7648606 -73.74356679 262 2 0 0 Dutchess, New York, US
2640 2640 34035 Somerset New Jersey US 3/28/20 23:05 40.56465737 -74.61683016 258 4 0 0 Somerset, New Jersey, US
3280 3280       Bosnia and Herzegovina 3/28/20 23:05 43.9159 17.6791 258 5 5 248 Bosnia and Herzegovina
1986 1986 24031 Montgomery Maryland US 3/28/20 23:05 39.13676329 -77.20358245 255 1 0 0 Montgomery, Maryland, US
3199 3199     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3241 3241     Shaanxi China 3/26/20 2:14 35.1917 108.8701 253 3 242 8 Shaanxi, China
3342 3342       Jordan 3/28/20 23:05 31.24 36.51 246 1 18 227 Jordan
1565 1565 17097 Lake Illinois US 3/28/20 23:05 42.3224907 -88.00367925 241 1 0 0 Lake, Illinois, US
3379 3379       North Macedonia 3/28/20 23:05 41.6086 21.7453 241 4 3 234 North Macedonia
740 740 13089 DeKalb Georgia US 3/28/20 23:05 33.76944049 -84.22396017 240 2 0 0 DeKalb, Georgia, US
2063 2063 9009 New Haven Connecticut US 3/28/20 23:05 41.4080325 -72.93620426 236 6 0 0 New Haven, Connecticut, US
3347 3347       Kuwait 3/28/20 23:05 29.31166 47.481766 235 0 64 171 Kuwait
2265 2265 53053 Pierce Washington US 3/28/20 23:05 47.03892768 -122.1405958 231 5 0 0 Pierce, Washington, US
3366 3366       Moldova 3/28/20 23:05 47.4116 28.3699 231 2 2 227 Moldova
2861 2861   Unassigned Georgia US 3/28/20 23:05 0.0 0.0 230 2 0 0 Unassigned, Georgia, US
1224 1224 9003 Hartford Connecticut US 3/28/20 23:05 41.80283011 -72.73103891 228 2 0 0 Hartford, Connecticut, US
3343 3343       Kazakhstan 3/28/20 23:05 48.0196 66.9237 228 1 16 211 Kazakhstan
763 763 42045 Delaware Pennsylvania US 3/28/20 23:05 39.91680171 -75.40243663 226 4 0 0 Delaware, Pennsylvania, US
3398 3398       San Marino 3/28/20 23:05 43.9424 12.4578 224 22 6 196 San Marino
974 974 39049 Franklin Ohio US 3/28/20 23:05 39.96995815 -83.01115755 222 2 0 0 Franklin, Ohio, US
26 26 6001 Alameda California US 3/28/20 23:05 37.64629437 -121.8929271 220 4 0 0 Alameda, California, US
46 46 42003 Allegheny Pennsylvania US 3/28/20 23:05 40.46809875 -79.98167747 219 2 0 0 Allegheny, Pennsylvania, US
1400 1400 1073 Jefferson Alabama US 3/28/20 23:05 33.55554728 -86.895063 217 0 0 0 Jefferson, Alabama, US
2673 2673 29510 St. Louis City Missouri US 3/28/20 23:05 38.63555736 -90.24349225 215 1 0 0 St. Louis City, Missouri, US
3284 3284       Burkina Faso 3/28/20 23:05 12.2383 -1.5616 207 11 21 175 Burkina Faso
2144 2144 12095 Orange Florida US 3/28/20 23:05 28.51367621 -81.31799498 206 4 0 0 Orange, Florida, US
806 806 13095 Dougherty Georgia US 3/28/20 23:05 31.53328528 -84.21722377 205 13 0 0 Dougherty, Georgia, US
821 821 17043 DuPage Illinois US 3/28/20 23:05 41.85116968 -88.08642662 202 6 0 0 DuPage, Illinois, US
1968 1968 36055 Monroe New York US 3/28/20 23:05 43.14638895 -77.69322942 202 5 0 0 Monroe, New York, US
3261 3261       Albania 3/28/20 23:05 41.1533 20.1683 197 10 31 156 Albania
2348 2348 24033 Prince George's Maryland US 3/28/20 23:05 38.83070039 -76.8496441 196 2 0 0 Prince George's, Maryland, US
28 28 36001 Albany New York US 3/28/20 23:05 42.60060306 -73.97723916 195 0 0 0 Albany, New York, US
1272 1272 12057 Hillsborough Florida US 3/28/20 23:05 27.9276559 -82.32013172 195 2 0 0 Hillsborough, Florida, US
338 338 22017 Caddo Louisiana US 3/28/20 23:05 32.57991587 -93.88375652 189 2 0 0 Caddo, Louisiana, US
3011 3011 26161 Washtenaw Michigan US 3/28/20 23:05 42.253105 -83.83853204 185 3 0 0 Washtenaw, Michigan, US
1171 1171 25013 Hampden Massachusetts US 3/28/20 23:05 42.13440424 -72.63235561 183 4 0 0 Hampden, Massachusetts, US
2440 2440 6065 Riverside California US 3/28/20 23:05 33.74314981 -115.9933578 183 8 0 0 Riverside, California, US
3237 3237     Reunion France 3/28/20 23:05 -21.1151 55.5364 183 0 1 182 Reunion, France
3269 3269       Azerbaijan 3/28/20 23:05 40.1431 47.5769 182 4 15 163 Azerbaijan
582 582 13067 Cobb Georgia US 3/28/20 23:05 33.94243204 -84.5761255 181 8 0 0 Cobb, Georgia, US
3258 3258     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
272 272 25005 Bristol Massachusetts US 3/28/20 23:05 41.79228404 -71.10872211 179 1 0 0 Bristol, Massachusetts, US
2824 2824 48453 Travis Texas US 3/28/20 23:05 30.33432034 -97.7853562 179 1 0 0 Travis, Texas, US
3299 3299       Cyprus 3/28/20 23:05 35.1264 33.4299 179 5 15 159 Cyprus

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
);