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 Long_

✎ 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
131 131 53005 Benton Washington US 2020-03-31 23:43:56 46.23946995 -119.51208340000001 89 6 0 0 Benton, Washington, US
748 748 53025 Grant Washington US 2020-03-31 23:43:56 47.20753737 -119.4500749 63 1 0 0 Grant, Washington, US
1173 1173 32019 Lyon Nevada US 2020-03-31 23:43:56 39.01777974 -119.18704790000001 1 0 0 0 Lyon, Nevada, US
1988 1988 6111 Ventura California US 2020-03-31 23:43:56 34.44465746 -119.09106129999999 126 4 0 0 Ventura, California, US
747 747 41023 Grant Oregon US 2020-03-31 23:43:56 44.49024544 -119.0068631 1 0 0 0 Grant, Oregon, US
683 683 53021 Franklin Washington US 2020-03-31 23:43:56 46.53351425 -118.9018212 33 0 0 0 Franklin, Washington, US
1314 1314 6051 Mono California US 2020-03-31 23:43:56 37.93899289 -118.8872409 13 0 0 0 Mono, California, US
1912 1912 6107 Tulare California US 2020-03-31 23:43:56 36.22026558 -118.8020203 43 1 0 0 Tulare, California, US
1926 1926 41059 Umatilla Oregon US 2020-03-31 23:43:56 45.59073056 -118.7353826 5 0 0 0 Umatilla, Oregon, US
1010 1010 6029 Kern California US 2020-03-31 23:43:56 35.34329425 -118.72777959999999 83 1 0 0 Kern, California, US
14 14 53001 Adams Washington US 2020-03-31 23:43:56 46.98299757 -118.56017340000001 13 0 0 0 Adams, Washington, US
646 646 53019 Ferry Washington US 2020-03-31 23:43:56 48.471143100000006 -118.5154041 1 0 0 0 Ferry, Washington, US
2004 2004 53071 Walla Walla Washington US 2020-03-31 23:43:56 46.23040051 -118.4775539 6 0 0 0 Walla Walla, Washington, US
1134 1134 53043 Lincoln Washington US 2020-03-31 23:43:56 47.57705241 -118.41943880000001 1 0 0 0 Lincoln, Washington, US
1154 1154 6037 Los Angeles California US 2020-03-31 23:43:56 34.30828379 -118.22824109999999 3019 54 0 0 Los Angeles, California, US
884 884 32013 Humboldt Nevada US 2020-03-31 23:43:56 41.40692186 -118.11094270000001 3 0 0 0 Humboldt, Nevada, US
1967 1967 41061 Union Oregon US 2020-03-31 23:43:56 45.30915495 -118.0068979 1 0 0 0 Union, Oregon, US
437 437 53013 Columbia Washington US 2020-03-31 23:43:56 46.29442881 -117.9051983 1 0 0 0 Columbia, Washington, US
1825 1825 53065 Stevens Washington US 2020-03-31 23:43:56 48.40035475 -117.8542701 4 0 0 0 Stevens, Washington, US
1452 1452 6059 Orange California US 2020-03-31 23:43:56 33.70147516 -117.76459979999998 502 7 0 0 Orange, California, US
1198 1198 41045 Malheur Oregon US 2020-03-31 23:43:56 43.1937027 -117.62273950000001 1 0 0 0 Malheur, Oregon, US
2102 2102 53075 Whitman Washington US 2020-03-31 23:43:56 46.90022523 -117.52417630000001 8 0 0 0 Whitman, Washington, US
902 902 6027 Inyo California US 2020-03-31 23:43:56 36.51112084 -117.41119779999998 8 0 0 0 Inyo, California, US
1781 1781 53063 Spokane Washington US 2020-03-31 23:43:56 47.62113146 -117.4046494 136 4 0 0 Spokane, Washington, US
2006 2006 41063 Wallowa Oregon US 2020-03-31 23:43:56 45.57894064 -117.18353799999998 1 0 0 0 Wallowa, Oregon, US
1505 1505 16075 Payette Idaho US 2020-03-31 23:43:56 44.00545243 -116.7647695 1 0 0 0 Payette, Idaho, US
1409 1409 16069 Nez Perce Idaho US 2020-03-31 23:43:56 46.32638236 -116.75009750000001 9 2 0 0 Nez Perce, Idaho, US
1685 1685 6073 San Diego California US 2020-03-31 23:43:56 33.03484597 -116.73653259999999 603 7 0 0 San Diego, California, US
267 267 16027 Canyon Idaho US 2020-03-31 23:43:56 43.61970148 -116.70954990000001 48 1 0 0 Canyon, Idaho, US
1032 1032 16055 Kootenai Idaho US 2020-03-31 23:43:56 47.67282258 -116.7020872 29 0 0 0 Kootenai, Idaho, US
160 160 16017 Bonner Idaho US 2020-03-31 23:43:56 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
2173 2173     Alberta Canada 2020-03-31 23:49:13 53.9333 -116.5765 690 8 0 0 Alberta, Canada
1426 1426 32023 Nye Nevada US 2020-03-31 23:43:56 38.04264256 -116.47227020000001 1 0 0 0 Nye, Nevada, US
710 710 16045 Gem Idaho US 2020-03-31 23:43:56 44.06482372 -116.398376 4 0 0 0 Gem, Idaho, US
4 4 16001 Ada Idaho US 2020-03-31 23:43:56 43.4526575 -116.24155159999998 195 3 0 0 Ada, Idaho, US
1684 1684 6071 San Bernardino California US 2020-03-31 23:43:56 34.84060306 -116.1774685 125 4 0 0 San Bernardino, California, US
1487 1487 16073 Owyhee Idaho US 2020-03-31 23:43:56 42.58016894 -116.16938710000001 1 0 0 0 Owyhee, Idaho, US
1638 1638 6065 Riverside California US 2020-03-31 23:43:56 33.74314981 -115.9933578 371 13 0 0 Riverside, California, US
1979 1979 16085 Valley Idaho US 2020-03-31 23:43:56 44.76728382 -115.5676773 2 0 0 0 Valley, Idaho, US
607 607 16039 Elmore Idaho US 2020-03-31 23:43:56 43.3507101 -115.4701578 1 0 0 0 Elmore, Idaho, US
896 896 16049 Idaho Idaho US 2020-03-31 23:43:56 45.84721541 -115.4634436 1 0 0 0 Idaho, Idaho, US
1127 1127 30053 Lincoln Montana US 2020-03-31 23:43:56 48.54265777 -115.4046155 5 1 0 0 Lincoln, Montana, US
897 897 6025 Imperial California US 2020-03-31 23:43:56 33.0393082 -115.36690420000001 33 0 0 0 Imperial, California, US
604 604 32007 Elko Nevada US 2020-03-31 23:43:56 41.14531606 -115.3577619 5 0 0 0 Elko, Nevada, US
378 378 32003 Clark Nevada US 2020-03-31 23:43:56 36.21458855 -115.0130241 869 23 0 0 Clark, Nevada, US
2098 2098 32033 White Pine Nevada US 2020-03-31 23:43:56 39.44157041 -114.89996599999999 1 0 0 0 White Pine, Nevada, US
253 253 16025 Camas Idaho US 2020-03-31 23:43:56 43.46665742 -114.8065892 1 0 0 0 Camas, Idaho, US
1922 1922 16083 Twin Falls Idaho US 2020-03-31 23:43:56 42.35440512 -114.6685381 5 0 0 0 Twin Falls, Idaho, US
493 493 16037 Custer Idaho US 2020-03-31 23:43:56 44.24186819 -114.2855494 1 0 0 0 Custer, Idaho, US
966 966 16053 Jerome Idaho US 2020-03-31 23:43:56 42.68891267 -114.2655033 2 0 0 0 Jerome, Idaho, US
1121 1121 16063 Lincoln Idaho US 2020-03-31 23:43:56 43.0012336 -114.1358773 2 0 0 0 Lincoln, Idaho, US
1618 1618 30081 Ravalli Montana US 2020-03-31 23:43:56 46.08520862 -114.11891640000002 1 0 0 0 Ravalli, Montana, US
1053 1053 30047 Lake Montana US 2020-03-31 23:43:56 47.64514965 -114.0898013 3 0 0 0 Lake, Montana, US
650 650 30029 Flathead Montana US 2020-03-31 23:43:56 48.29575866 -114.05205690000001 11 0 0 0 Flathead, Montana, US
1036 1036 4012 La Paz Arizona US 2020-03-31 23:43:56 33.72854224 -113.98100290000001 2 0 0 0 La Paz, Arizona, US
148 148 16013 Blaine Idaho US 2020-03-31 23:43:56 43.4085812 -113.9752658 192 2 0 0 Blaine, Idaho, US
1305 1305 30063 Missoula Montana US 2020-03-31 23:43:56 47.03728583 -113.92135079999998 14 0 0 0 Missoula, Montana, US
2171 2171 4027 Yuma Arizona US 2020-03-31 23:43:56 32.76895712 -113.90666740000002 9 0 0 0 Yuma, Arizona, US
1311 1311 4015 Mohave Arizona US 2020-03-31 23:43:56 35.70471703 -113.7577902 7 0 0 0 Mohave, Arizona, US
1302 1302 16067 Minidoka Idaho US 2020-03-31 23:43:56 42.85518524 -113.6357257 1 0 0 0 Minidoka, Idaho, US
299 299 16031 Cassia Idaho US 2020-03-31 23:43:56 42.28347888 -113.6012409 1 0 0 0 Cassia, Idaho, US
2055 2055 49053 Washington Utah US 2020-03-31 23:43:56 37.28003525 -113.504698 14 1 0 0 Washington, Utah, US
908 908 49021 Iron Utah US 2020-03-31 23:43:56 37.85903620000001 -113.28973810000001 6 0 0 0 Iron, Utah, US
1901 1901 49045 Tooele Utah US 2020-03-31 23:43:56 40.44862644 -113.12957150000001 12 0 0 0 Tooele, Utah, US
173 173 49003 Box Elder Utah US 2020-03-31 23:43:56 41.52106798 -113.08328159999999 7 0 0 0 Box Elder, Utah, US
530 530 30023 Deer Lodge Montana US 2020-03-31 23:43:56 46.05953325 -113.073353 3 0 0 0 Deer Lodge, Montana, US
1756 1756 30093 Silver Bow Montana US 2020-03-31 23:43:56 45.90018933 -112.6620092 10 0 0 0 Silver Bow, Montana, US
2160 2160 4025 Yavapai Arizona US 2020-03-31 23:43:56 34.59933926 -112.5538588 21 0 0 0 Yavapai, Arizona, US
1205 1205 4013 Maricopa Arizona US 2020-03-31 23:43:56 33.34835867 -112.49181540000001 788 5 0 0 Maricopa, Arizona, US
146 146 16011 Bingham Idaho US 2020-03-31 23:43:56 43.21672879999999 -112.3978437 2 0 0 0 Bingham, Idaho, US
1111 1111 30049 Lewis and Clark Montana US 2020-03-31 23:43:56 47.12610041 -112.39469799999999 12 0 0 0 Lewis and Clark, Montana, US
948 948 16051 Jefferson Idaho US 2020-03-31 23:43:56 43.82078483 -112.3131749 2 0 0 0 Jefferson, Idaho, US
92 92 16005 Bannock Idaho US 2020-03-31 23:43:56 42.67002716 -112.2233311 4 0 0 0 Bannock, Idaho, US
511 511 49011 Davis Utah US 2020-03-31 23:43:56 40.99001837 -112.1139997 84 1 0 0 Davis, Utah, US
955 955 30043 Jefferson Montana US 2020-03-31 23:43:56 46.14907081 -112.094396 2 0 0 0 Jefferson, Montana, US
1679 1679 49035 Salt Lake Utah US 2020-03-31 23:43:56 40.66616532 -111.92160109999999 396 2 0 0 Salt Lake, Utah, US
1189 1189 30057 Madison Montana US 2020-03-31 23:43:56 45.30080065 -111.9173017 6 2 0 0 Madison, Montana, US
2076 2076   Weber Utah US 2020-03-31 23:43:56 41.27116049 -111.9145117 41 1 0 0 Weber,Utah,US
1541 1541 4019 Pima Arizona US 2020-03-31 23:43:56 32.0971334 -111.7890033 202 4 0 0 Pima, Arizona, US
419 419 4005 Coconino Arizona US 2020-03-31 23:43:56 35.83883429 -111.77071780000001 81 2 0 0 Coconino, Arizona, US
234 234 49005 Cache Utah US 2020-03-31 23:43:56 41.72330587 -111.74436670000001 7 0 0 0 Cache, Utah, US
1902 1902 30101 Toole Montana US 2020-03-31 23:43:56 48.65577551 -111.69424140000001 7 2 0 0 Toole, Montana, US
1975 1975 49049 Utah Utah US 2020-03-31 23:43:56 40.116672200000004 -111.66576620000001 70 0 0 0 Utah, Utah, US
1183 1183 16065 Madison Idaho US 2020-03-31 23:43:56 43.78141028 -111.65384740000002 5 0 0 0 Madison, Idaho, US
161 161 16019 Bonneville Idaho US 2020-03-31 23:43:56 43.38713372 -111.6161537 2 0 0 0 Bonneville, Idaho, US
190 190 30007 Broadwater Montana US 2020-03-31 23:43:56 46.33277565 -111.49558130000001 3 0 0 0 Broadwater, Montana, US
689 689 16043 Fremont Idaho US 2020-03-31 23:43:56 44.22800938 -111.48099429999999 1 0 0 0 Fremont, Idaho, US
704 704 49017 Garfield Utah US 2020-03-31 23:43:56 37.85447192 -111.4418764 1 0 0 0 Garfield, Utah, US
291 291 30013 Cascade Montana US 2020-03-31 23:43:56 47.30797024 -111.3467922 9 0 0 0 Cascade, Montana, US
1542 1542 4021 Pinal Arizona US 2020-03-31 23:43:56 32.90525627 -111.3449483 62 0 0 0 Pinal, Arizona, US
1882 1882 16081 Teton Idaho US 2020-03-31 23:43:56 43.75303583 -111.2056773 2 0 0 0 Teton, Idaho, US
699 699 30031 Gallatin Montana US 2020-03-31 23:43:56 45.54486106 -111.1692571 74 0 0 0 Gallatin, Montana, US
2028 2028 49051 Wasatch Utah US 2020-03-31 23:43:56 40.33110236 -111.1691419 50 0 0 0 Wasatch, Utah, US
1842 1842 49043 Summit Utah US 2020-03-31 23:43:56 40.86688146 -110.9535882 172 0 0 0 Summit, Utah, US
1268 1268 30059 Meagher Montana US 2020-03-31 23:43:56 46.59907074 -110.8898557 1 0 0 0 Meagher, Montana, US
1703 1703 4023 Santa Cruz Arizona US 2020-03-31 23:43:56 31.52508998 -110.8479088 2 0 0 0 Santa Cruz, Arizona, US
717 717 4007 Gila Arizona US 2020-03-31 23:43:56 33.80190085 -110.8132779 1 0 0 0 Gila, Arizona, US
1883 1883 56039 Teton Wyoming US 2020-03-31 23:43:56 43.93522482 -110.5890801 20 0 0 0 Teton, Wyoming, US
1497 1497 30067 Park Montana US 2020-03-31 23:43:56 45.48965095 -110.52643940000002 3 0 0 0 Park, Montana, US
1384 1384 4017 Navajo Arizona US 2020-03-31 23:43:56 35.3997715 -110.3218983 91 0 0 0 Navajo, Arizona, US

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