04-01-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,486 rows sorted by FIPS

✎ 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
538 538   DeKalb Tennessee US 2020-04-01 21:58:49 35.97616272 -85.83689361 5 0 0 0 DeKalb,Tennessee,US
539 539   DeSoto Florida US 2020-04-01 21:58:49 27.18677893 -81.80941373 7 1 0 0 DeSoto,Florida,US
572 572   Dona Ana New Mexico US 2020-04-01 21:58:49 32.35275771 -106.8329387 18 0 0 0 Dona Ana,New Mexico,US
594 594   Dukes and Nantucket Massachusetts US 2020-04-01 21:58:49 41.40674725 -70.68763497 11 0 0 0 Dukes and Nantucket,Massachusetts,US
665 665   Fillmore Minnesota US 2020-04-01 21:58:49 43.67394126 -92.08980382 8 0 0 0 Fillmore,Minnesota,US
839 839   Harris Texas US 2020-04-01 21:58:49 29.86 -95.39 847 6 0 0 Harris,Texas,US
1019 1019   Kansas City Missouri US 2020-04-01 21:58:49 39.0997 -94.5786 128 0 0 0 Kansas City,Missouri,US
1026 1026   Kenai Peninsula Alaska US 2020-04-01 21:58:49 60.24429722 -151.53888840000005 7 0 0 0 Kenai Peninsula,Alaska,US
1068 1068   LaSalle Illinois US 2020-04-01 21:58:49 41.34426129999999 -88.88633881 6 1 0 0 LaSalle,Illinois,US
1069 1069   LaSalle Louisiana US 2020-04-01 21:58:49 31.67884782 -92.15907765 2 0 0 0 LaSalle,Louisiana,US
1071 1071   Lac qui Parle Minnesota US 2020-04-01 21:58:49 44.9973857 -96.17488219 1 0 0 0 Lac qui Parle,Minnesota,US
1232 1232   Manassas Virginia US 2020-04-01 21:58:49 38.7464321 -77.48509905 9 0 0 0 Manassas,Virginia,US
1274 1274   Matanuska-Susitna Alaska US 2020-04-01 21:58:49 62.31305045 -149.5741743 3 0 0 0 Matanuska-Susitna,Alaska,US
1286 1286   McDuffie Georgia US 2020-04-01 21:58:49 33.47851918 -82.48252774 3 0 0 0 McDuffie,Georgia,US
1289 1289   McIntosh Georgia US 2020-04-01 21:58:49     1 0 0 0 McIntosh,Georgia,US
1291 1291   McKean Pennsylvania US 2020-04-01 21:58:49 41.80938602 -78.56478358 1 0 0 0 McKean,Pennsylvania,US
1519 1519   Out of MI Michigan US 2020-04-01 21:58:49 0.0 0.0 42 1 0 0 Out of MI,Michigan,US
1520 1520   Out of OK Oklahoma US 2020-04-01 21:58:49 0.0 0.0 2 0 0 0 Out of OK,Oklahoma,US
1521 1521   Out of TN Tennessee US 2020-04-01 21:58:49 0.0 0.0 243 0 0 0 Out of TN,Tennessee,US
1522 1522   Out of UT Utah US 2020-04-01 21:58:49 0.0 0.0 22 0 0 0 Out of UT,Utah,US
1973 1973   Unassigned Alabama US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Alabama, US
1974 1974   Unassigned Alaska US 2020-04-01 21:58:49 0.0 0.0 0 2 0 0 Unassigned, Alaska, US
1975 1975   Unassigned Arizona US 2020-04-01 21:58:49 0.0 0.0 0 18 0 0 Unassigned, Arizona, US
1976 1976   Unassigned Arkansas US 2020-04-01 21:58:49 0.0 0.0 44 4 0 0 Unassigned, Arkansas, US
1977 1977   Unassigned California US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, California, US
1978 1978   Unassigned Colorado US 2020-04-01 21:58:49 0.0 0.0 129 1 0 0 Unassigned, Colorado, US
1979 1979   Unassigned Connecticut US 2020-04-01 21:58:49 0.0 0.0 185 2 0 0 Unassigned, Connecticut, US
1980 1980   Unassigned Florida US 2020-04-01 21:58:49 0.0 0.0 3 2 0 0 Unassigned, Florida, US
1981 1981   Unassigned Georgia US 2020-04-01 21:58:49 0.0 0.0 516 2 0 0 Unassigned, Georgia, US
1982 1982   Unassigned Hawaii US 2020-04-01 21:58:49 0.0 0.0 15 1 0 0 Unassigned, Hawaii, US
1983 1983   Unassigned Illinois US 2020-04-01 21:58:49 0.0 0.0 28 0 0 0 Unassigned, Illinois, US
1984 1984   Unassigned Iowa US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, Iowa, US
1985 1985   Unassigned Kentucky US 2020-04-01 21:58:49 0.0 0.0 18 3 0 0 Unassigned, Kentucky, US
1986 1986   Unassigned Louisiana US 2020-04-01 21:58:49 0.0 0.0 28 0 0 0 Unassigned, Louisiana, US
1987 1987   Unassigned Maine US 2020-04-01 21:58:49 0.0 0.0 6 0 0 0 Unassigned, Maine, US
1988 1988   Unassigned Maryland US 2020-04-01 21:58:49 0.0 0.0 0 12 0 0 Unassigned, Maryland, US
1989 1989   Unassigned Massachusetts US 2020-04-01 21:58:49 0.0 0.0 251 9 0 0 Unassigned, Massachusetts, US
1990 1990   Unassigned Michigan US 2020-04-01 21:58:49 0.0 0.0 142 0 0 0 Unassigned,Michigan,US
1991 1991   Unassigned Minnesota US 2020-04-01 21:58:49 0.0 0.0 0 8 0 0 Unassigned, Minnesota, US
1992 1992   Unassigned Missouri US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Missouri, US
1993 1993   Unassigned Nebraska US 2020-04-01 21:58:49 0.0 0.0 3 0 0 0 Unassigned, Nebraska, US
1994 1994   Unassigned Nevada US 2020-04-01 21:58:49 0.0 0.0 148 0 0 0 Unassigned, Nevada, US
1995 1995   Unassigned New Hampshire US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, New Hampshire, US
1996 1996   Unassigned New Jersey US 2020-04-01 21:58:49 0.0 0.0 4512 0 0 0 Unassigned, New Jersey, US
1997 1997   Unassigned New York US 2020-04-01 21:58:49 0.0 0.0 0 565 0 0 Unassigned, New York, US
1998 1998   Unassigned Oklahoma US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, Oklahoma, US
1999 1999   Unassigned Rhode Island US 2020-04-01 21:58:49 0.0 0.0 160 1 0 0 Unassigned, Rhode Island, US
2000 2000   Unassigned Tennessee US 2020-04-01 21:58:49 0.0 0.0 442 11 0 0 Unassigned, Tennessee, US
2001 2001   Unassigned Vermont US 2020-04-01 21:58:49 0.0 0.0 14 11 0 0 Unassigned, Vermont, US
2002 2002   Unassigned Virginia US 2020-04-01 21:58:49 0.0 0.0 0 19 0 0 Unassigned,Virginia,US
2003 2003   Unassigned Washington US 2020-04-01 21:58:49 0.0 0.0 303 0 0 0 Unassigned, Washington, US
2004 2004   Unassigned Wisconsin US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
2124 2124   Weber Utah US 2020-04-01 21:58:49 41.27116049 -111.9145117 41 1 0 0 Weber,Utah,US
2222 2222     Alberta Canada 2020-04-01 22:04:44 53.9333 -116.5765 754 9 0 0 Alberta, Canada
2223 2223     Anguilla United Kingdom 2020-04-01 21:58:34 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
2224 2224     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2225 2225     Aruba Netherlands 2020-04-01 21:58:34 12.5211 -69.9683 55 0 1 54 Aruba, Netherlands
2226 2226     Australian Capital Territory Australia 2020-04-01 22:04:58 -35.4735 149.0124 84 1 8 75 Australian Capital Territory, Australia
2227 2227     Beijing China 2020-04-01 00:55:49 40.1824 116.4142 580 8 418 154 Beijing, China
2228 2228     Bermuda United Kingdom 2020-04-01 21:58:34 32.3078 -64.7505 32 0 10 22 Bermuda, United Kingdom
2229 2229     British Columbia Canada 2020-04-01 22:04:44 53.7267 -127.6476 1013 24 0 0 British Columbia, Canada
2230 2230     British Virgin Islands United Kingdom 2020-04-01 21:58:34 18.4207 -64.64 3 0 0 3 British Virgin Islands, United Kingdom
2231 2231     Cayman Islands United Kingdom 2020-04-01 21:58:34 19.3133 -81.2546 22 1 0 21 Cayman Islands, United Kingdom
2232 2232     Channel Islands United Kingdom 2020-04-01 21:58:34 49.3723 -2.3644 172 3 0 169 Channel Islands, United Kingdom
2233 2233     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2234 2234     Curacao Netherlands 2020-04-01 21:58:34 12.1696 -68.99 11 1 3 7 Curacao, Netherlands
2235 2235     Diamond Princess Canada 2020-04-01 22:04:44 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2237 2237     Faroe Islands Denmark 2020-04-01 21:58:34 61.8926 -6.9118 173 0 75 98 Faroe Islands, Denmark
2238 2238     French Guiana France 2020-04-01 21:58:34 4.0 -53.0 51 0 15 36 French Guiana, France
2239 2239     French Polynesia France 2020-04-01 21:58:34 -17.6797 -149.4068 37 0 0 37 French Polynesia, France
2240 2240     Fujian China 2020-04-01 11:54:10 26.0789 117.9874 345 1 298 46 Fujian, China
2241 2241     Gansu China 2020-04-01 14:00:34 37.8099 101.0583 138 2 127 9 Gansu, China
2242 2242     Gibraltar United Kingdom 2020-04-01 21:58:34 36.1408 -5.3536 81 0 34 47 Gibraltar, United Kingdom
2243 2243     Grand Princess Canada 2020-04-01 22:04:44 0.0 0.0 13 0 0 0 Grand Princess, Canada
2245 2245     Greenland Denmark 2020-04-01 21:58:34 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
2246 2246     Guadeloupe France 2020-04-01 21:58:34 16.265 -61.551 125 6 24 95 Guadeloupe, France
2248 2248     Guangdong China 2020-04-01 05:36:53 23.3417 113.4244 1501 8 1357 136 Guangdong, China
2249 2249     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
2250 2250     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2251 2251     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
2252 2252     Hebei China 2020-04-01 00:13:24 39.549 116.1306 323 6 310 7 Hebei, China
2253 2253     Heilongjiang China 2020-03-26 00:15:39 47.861999999999995 127.7615 484 13 469 2 Heilongjiang, China
2254 2254     Henan China 2020-03-29 01:44:01 33.882 113.61399999999999 1276 22 1251 3 Henan, China
2255 2255     Hong Kong China 2020-04-01 11:07:39 22.3 114.2 765 4 147 614 Hong Kong, China
2256 2256     Hubei China 2020-04-01 06:20:26 30.9756 112.2707 67802 3193 63326 1283 Hubei, China
2257 2257     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
2258 2258     Inner Mongolia China 2020-04-01 06:20:26 44.0935 113.9448 111 1 74 36 Inner Mongolia, China
2259 2259     Isle of Man United Kingdom 2020-04-01 21:58:34 54.2361 -4.5481 68 1 0 67 Isle of Man, United Kingdom
2260 2260     Jiangsu China 2020-03-31 01:10:41 32.9711 119.455 646 0 631 15 Jiangsu, China
2261 2261     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2262 2262     Jilin China 2020-03-29 00:28:20 43.6661 126.1923 98 1 92 5 Jilin, China
2263 2263     Liaoning China 2020-04-01 00:18:27 41.2956 122.6085 140 2 124 14 Liaoning, China
2264 2264     Macau China 2020-03-31 13:54:04 22.1667 113.55 41 0 10 31 Macau, China
2265 2265     Manitoba Canada 2020-04-01 22:04:44 53.7609 -98.8139 127 1 0 0 Manitoba, Canada
2266 2266     Martinique France 2020-04-01 21:58:34 14.6415 -61.0242 135 3 27 105 Martinique, France
2267 2267     Mayotte France 2020-04-01 21:58:34 -12.8275 45.166244 94 1 10 83 Mayotte, France
2268 2268     Montserrat United Kingdom 2020-04-01 21:58:34 16.742498 -62.187366000000004 5 0 0 5 Montserrat, United Kingdom
2269 2269     New Brunswick Canada 2020-04-01 22:04:44 46.5653 -66.4619 81 0 0 0 New Brunswick, Canada
2270 2270     New Caledonia France 2020-04-01 21:58:34 -20.904304999999997 165.618042 16 0 0 16 New Caledonia, France
2271 2271     New South Wales Australia 2020-04-01 22:04:58 -33.8688 151.2093 2182 9 4 2169 New South Wales, Australia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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