03-31-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,437 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
521 521   DeKalb Tennessee US 2020-03-31 23:43:56 35.97616272 -85.83689361 4 0 0 0 DeKalb,Tennessee,US
522 522   DeSoto Florida US 2020-03-31 23:43:56 27.18677893 -81.80941373 7 1 0 0 DeSoto,Florida,US
555 555   Dona Ana New Mexico US 2020-03-31 23:43:56 32.35275771 -106.8329387 18 0 0 0 Dona Ana,New Mexico,US
576 576   Dukes and Nantucket Massachusetts US 2020-03-31 23:43:56 41.40674725 -70.68763497 8 0 0 0 Dukes and Nantucket,Massachusetts,US
647 647   Fillmore Minnesota US 2020-03-31 23:43:56 43.67394126 -92.08980382 8 0 0 0 Fillmore,Minnesota,US
815 815   Harris Texas US 2020-03-31 23:43:56     680 6 0 0 Harris,Texas,US
992 992   Kansas City Missouri US 2020-03-31 23:43:56 39.0997 -94.5786 119 0 0 0 Kansas City,Missouri,US
999 999   Kenai Peninsula Alaska US 2020-03-31 23:43:56 60.24429722 -151.53888840000005 7 0 0 0 Kenai Peninsula,Alaska,US
1040 1040   LaSalle Illinois US 2020-03-31 23:43:56 41.34426129999999 -88.88633881 5 1 0 0 LaSalle,Illinois,US
1041 1041   LaSalle Louisiana US 2020-03-31 23:43:56 31.67884782 -92.15907765 2 0 0 0 LaSalle,Louisiana,US
1043 1043   Lac qui Parle Minnesota US 2020-03-31 23:43:56 44.9973857 -96.17488219 1 0 0 0 Lac qui Parle,Minnesota,US
1199 1199   Manassas Virginia US 2020-03-31 23:43:56 38.7464321 -77.48509905 8 0 0 0 Manassas,Virginia,US
1241 1241   Matanuska-Susitna Alaska US 2020-03-31 23:43:56 62.31305045 -149.5741743 3 0 0 0 Matanuska-Susitna,Alaska,US
1253 1253   McDuffie Georgia US 2020-03-31 23:43:56 33.47851918 -82.48252774 3 0 0 0 McDuffie,Georgia,US
1256 1256   McIntosh Georgia US 2020-03-31 23:43:56     1 0 0 0 McIntosh,Georgia,US
1258 1258   McKean Pennsylvania US 2020-03-31 23:43:56 41.80938602 -78.56478358 1 0 0 0 McKean,Pennsylvania,US
1480 1480   Out of MI Michigan US 2020-03-31 23:43:56 0.0 0.0 20 0 0 0 Out of MI,Michigan,US
1481 1481   Out of OK Oklahoma US 2020-03-31 23:43:56 0.0 0.0 2 0 0 0 Out of OK,Oklahoma,US
1482 1482   Out of TN Tennessee US 2020-03-31 23:43:56 0.0 0.0 190 0 0 0 Out of TN,Tennessee,US
1483 1483   Out of UT Utah US 2020-03-31 23:43:56 0.0 0.0 22 0 0 0 Out of UT,Utah,US
1927 1927   Unassigned Alabama US 2020-03-31 23:43:56 0.0 0.0 0 8 0 0 Unassigned, Alabama, US
1928 1928   Unassigned Alaska US 2020-03-31 23:43:56 0.0 0.0 0 2 0 0 Unassigned, Alaska, US
1929 1929   Unassigned Arizona US 2020-03-31 23:43:56 0.0 0.0 0 13 0 0 Unassigned, Arizona, US
1930 1930   Unassigned Arkansas US 2020-03-31 23:43:56 0.0 0.0 34 3 0 0 Unassigned, Arkansas, US
1931 1931   Unassigned California US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, California, US
1932 1932   Unassigned Colorado US 2020-03-31 23:43:56 0.0 0.0 129 1 0 0 Unassigned, Colorado, US
1933 1933   Unassigned Connecticut US 2020-03-31 23:43:56 0.0 0.0 77 2 0 0 Unassigned, Connecticut, US
1934 1934   Unassigned Delaware US 2020-03-31 23:43:56 0.0 0.0 0 3 0 0 Unassigned, Delaware, US
1935 1935   Unassigned Florida US 2020-03-31 23:43:56 0.0 0.0 2 0 0 0 Unassigned, Florida, US
1936 1936   Unassigned Georgia US 2020-03-31 23:43:56 0.0 0.0 165 1 0 0 Unassigned, Georgia, US
1937 1937   Unassigned Hawaii US 2020-03-31 23:43:56 0.0 0.0 13 0 0 0 Unassigned, Hawaii, US
1938 1938   Unassigned Illinois US 2020-03-31 23:43:56 0.0 0.0 18 0 0 0 Unassigned, Illinois, US
1939 1939   Unassigned Iowa US 2020-03-31 23:43:56 0.0 0.0 2 1 0 0 Unassigned, Iowa, US
1940 1940   Unassigned Kentucky US 2020-03-31 23:43:56 0.0 0.0 14 2 0 0 Unassigned, Kentucky, US
1941 1941   Unassigned Louisiana US 2020-03-31 23:43:56 0.0 0.0 22 4 0 0 Unassigned, Louisiana, US
1942 1942   Unassigned Maine US 2020-03-31 23:43:56 0.0 0.0 6 0 0 0 Unassigned, Maine, US
1943 1943   Unassigned Massachusetts US 2020-03-31 23:43:56 0.0 0.0 333 9 0 0 Unassigned, Massachusetts, US
1944 1944   Unassigned Michigan US 2020-03-31 23:43:56 0.0 0.0 93 0 0 0 Unassigned,Michigan,US
1945 1945   Unassigned Minnesota US 2020-03-31 23:43:56 0.0 0.0 0 3 0 0 Unassigned, Minnesota, US
1946 1946   Unassigned Missouri US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, Missouri, US
1947 1947   Unassigned Nebraska US 2020-03-31 23:43:56 0.0 0.0 3 0 0 0 Unassigned, Nebraska, US
1948 1948   Unassigned Nevada US 2020-03-31 23:43:56 0.0 0.0 102 0 0 0 Unassigned, Nevada, US
1949 1949   Unassigned New Hampshire US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, New Hampshire, US
1950 1950   Unassigned New Jersey US 2020-03-31 23:43:56 0.0 0.0 3686 247 0 0 Unassigned, New Jersey, US
1951 1951   Unassigned New York US 2020-03-31 23:43:56 0.0 0.0 0 468 0 0 Unassigned, New York, US
1952 1952   Unassigned Rhode Island US 2020-03-31 23:43:56 0.0 0.0 184 0 0 0 Unassigned, Rhode Island, US
1953 1953   Unassigned Tennessee US 2020-03-31 23:43:56 0.0 0.0 307 11 0 0 Unassigned, Tennessee, US
1954 1954   Unassigned Vermont US 2020-03-31 23:43:56 0.0 0.0 11 8 0 0 Unassigned, Vermont, US
1955 1955   Unassigned Virginia US 2020-03-31 23:43:56 0.0 0.0 0 12 0 0 Unassigned,Virginia,US
1956 1956   Unassigned Washington US 2020-03-31 23:43:56 0.0 0.0 274 0 0 0 Unassigned, Washington, US
1957 1957   Unassigned Wisconsin US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
2076 2076   Weber Utah US 2020-03-31 23:43:56 41.27116049 -111.9145117 41 1 0 0 Weber,Utah,US
2173 2173     Alberta Canada 2020-03-31 23:49:13 53.9333 -116.5765 690 8 0 0 Alberta, Canada
2174 2174     Anguilla United Kingdom 2020-03-31 23:43:43 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
2175 2175     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2176 2176     Aruba Netherlands 2020-03-31 23:43:43 12.5211 -69.9683 55 0 1 54 Aruba, Netherlands
2177 2177     Australian Capital Territory Australia 2020-03-31 23:49:27 -35.4735 149.0124 80 1 3 76 Australian Capital Territory, Australia
2178 2178     Beijing China 2020-03-31 05:46:54 40.1824 116.4142 580 8 418 154 Beijing, China
2179 2179     Bermuda United Kingdom 2020-03-31 23:43:43 32.3078 -64.7505 32 0 10 22 Bermuda, United Kingdom
2180 2180     British Columbia Canada 2020-03-31 23:49:13 53.7267 -127.6476 1013 24 0 0 British Columbia, Canada
2181 2181     British Virgin Islands United Kingdom 2020-03-31 23:43:43 18.4207 -64.64 3 0 0 3 British Virgin Islands, United Kingdom
2182 2182     Cayman Islands United Kingdom 2020-03-31 23:43:43 19.3133 -81.2546 14 1 0 13 Cayman Islands, United Kingdom
2183 2183     Channel Islands United Kingdom 2020-03-31 23:43:43 49.3723 -2.3644 141 3 0 138 Channel Islands, United Kingdom
2184 2184     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2185 2185     Curacao Netherlands 2020-03-31 23:43:43 12.1696 -68.99 11 1 2 8 Curacao, Netherlands
2186 2186     Diamond Princess Canada 2020-03-31 23:49:13 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2188 2188     Faroe Islands Denmark 2020-03-31 23:43:43 61.8926 -6.9118 169 0 74 95 Faroe Islands, Denmark
2189 2189     French Guiana France 2020-03-31 23:43:43 4.0 -53.0 43 0 6 37 French Guiana, France
2190 2190     French Polynesia France 2020-03-31 23:43:43 -17.6797 149.4068 36 0 0 36 French Polynesia, France
2191 2191     Fujian China 2020-03-31 02:10:31 26.0789 117.9874 343 1 295 47 Fujian, China
2192 2192     Gansu China 2020-03-29 14:25:46 37.8099 101.0583 138 2 125 11 Gansu, China
2193 2193     Gibraltar United Kingdom 2020-03-31 23:43:43 36.1408 -5.3536 69 0 34 35 Gibraltar, United Kingdom
2194 2194     Grand Princess Canada 2020-03-31 23:49:13 0.0 0.0 13 0 0 0 Grand Princess, Canada
2196 2196     Greenland Denmark 2020-03-31 23:43:43 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
2197 2197     Guadeloupe France 2020-03-31 23:43:43 16.265 -61.551 114 4 22 88 Guadeloupe, France
2199 2199     Guangdong China 2020-03-31 09:56:36 23.3417 113.4244 1494 8 1356 130 Guangdong, China
2200 2200     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
2201 2201     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2202 2202     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
2203 2203     Hebei China 2020-03-30 02:07:50 39.549 116.1306 321 6 310 5 Hebei, China
2204 2204     Heilongjiang China 2020-03-26 00:15:39 47.862 127.7615 484 13 469 2 Heilongjiang, China
2205 2205     Henan China 2020-03-29 01:44:01 33.882 113.614 1276 22 1251 3 Henan, China
2206 2206     Hong Kong China 2020-03-31 09:10:05 22.3 114.2 714 4 128 582 Hong Kong, China
2207 2207     Hubei China 2020-03-31 01:06:37 30.9756 112.2707 67801 3187 63153 1461 Hubei, China
2208 2208     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
2209 2209     Inner Mongolia China 2020-03-30 23:54:43 44.0935 113.9448 107 1 74 32 Inner Mongolia, China
2210 2210     Isle of Man United Kingdom 2020-03-31 23:43:43 54.2361 -4.5481 60 0 0 60 Isle of Man, United Kingdom
2211 2211     Jiangsu China 2020-03-31 01:10:41 32.9711 119.455 646 0 631 15 Jiangsu, China
2212 2212     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2213 2213     Jilin China 2020-03-29 00:28:20 43.6661 126.1923 98 1 92 5 Jilin, China
2214 2214     Liaoning China 2020-03-31 00:23:00 41.2956 122.6085 139 2 124 13 Liaoning, China
2215 2215     Macau China 2020-03-31 13:54:04 22.1667 113.55 41 0 10 31 Macau, China
2216 2216     Manitoba Canada 2020-03-31 23:49:13 53.7609 -98.8139 103 1 0 0 Manitoba, Canada
2217 2217     Martinique France 2020-03-31 23:43:43 14.6415 -61.0242 128 3 27 98 Martinique, France
2218 2218     Mayotte France 2020-03-31 23:43:43 -12.8275 45.166244 94 1 10 83 Mayotte, France
2219 2219     Montserrat United Kingdom 2020-03-31 23:43:43 16.742498 -62.187366000000004 5 0 0 5 Montserrat, United Kingdom
2220 2220     New Brunswick Canada 2020-03-31 23:49:13 46.5653 -66.4619 70 0 0 0 New Brunswick, Canada
2221 2221     New Caledonia France 2020-03-31 23:43:43 -20.904304999999997 165.618042 16 0 0 16 New Caledonia, France
2222 2222     New South Wales Australia 2020-03-31 23:49:27 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
2223 2223     Newfoundland and Labrador Canada 2020-03-31 23:49:13 53.1355 -57.6604 152 1 0 0 Newfoundland and Labrador, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-31-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
);