04-30-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,179 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
1281 1281 53031 Jefferson Washington US 2020-05-01 02:32:28 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1315 1315 41033 Josephine Oregon US 2020-05-01 02:32:28 42.3665549 -123.5561938 20 1 0 19 Josephine, Oregon, US
168 168 41003 Benton Oregon US 2020-05-01 02:32:28 44.49167306 -123.4316987 30 5 0 25 Benton, Oregon, US
2689 2689 53069 Wahkiakum Washington US 2020-05-01 02:32:28 46.29180039999999 -123.4250831 2 0 0 2 Wahkiakum, Washington, US
2099 2099 41053 Polk Oregon US 2020-05-01 02:32:28 44.90322804 -123.4128888 39 1 0 38 Polk, Oregon, US
1705 1705 6045 Mendocino California US 2020-05-01 02:32:28 39.4381191 -123.39113130000001 12 0 0 12 Mendocino, California, US
2884 2884 41071 Yamhill Oregon US 2020-05-01 02:32:28 45.23330449 -123.3086963 39 7 0 32 Yamhill, Oregon, US
1653 1653 53045 Mason Washington US 2020-05-01 02:32:28 47.35007586 -123.1863685 23 1 0 22 Mason, Washington, US
738 738 41019 Douglas Oregon US 2020-05-01 02:32:28 43.27941273 -123.16729099999999 23 0 0 23 Douglas, Oregon, US
2750 2750 41067 Washington Oregon US 2020-05-01 02:32:28 45.55972701 -123.0955257 491 11 0 480 Washington, Oregon, US
556 556 41009 Columbia Oregon US 2020-05-01 02:32:28 45.94464254 -123.08908980000001 14 0 0 14 Columbia, Oregon, US
2278 2278 53055 San Juan Washington US 2020-05-01 02:32:28 48.60182783 -122.96745 14 0 0 14 San Juan, Washington, US
2388 2388 6097 Sonoma California US 2020-05-01 02:32:28 38.52746429 -122.88625060000001 232 2 0 230 Sonoma, California, US
1420 1420 41039 Lane Oregon US 2020-05-01 02:32:28 43.93727035 -122.847753 50 2 0 48 Lane, Oregon, US
2530 2530 53067 Thurston Washington US 2020-05-01 02:32:28 46.9291895 -122.82906559999999 105 1 0 104 Thurston, Washington, US
1398 1398 6033 Lake California US 2020-05-01 02:32:28 39.10124298 -122.75362439999999 6 0 0 6 Lake, California, US
1242 1242 41029 Jackson Oregon US 2020-05-01 02:32:28 42.43201126 -122.72893090000001 49 0 0 49 Jackson, Oregon, US
1608 1608 6041 Marin California US 2020-05-01 02:32:28 38.07122463 -122.72106310000001 235 13 0 222 Marin, California, US
593 593 53015 Cowlitz Washington US 2020-05-01 02:32:28 46.19074721 -122.6782231 45 0 0 45 Cowlitz, Washington, US
1360 1360 53035 Kitsap Washington US 2020-05-01 02:32:28 47.63479026 -122.6436061 149 2 0 147 Kitsap, Washington, US
1622 1622 41047 Marion Oregon US 2020-05-01 02:32:28 44.90287942 -122.58151170000001 491 18 0 473 Marion, Oregon, US
2370 2370 6093 Siskiyou California US 2020-05-01 02:32:28 41.59198861 -122.54074340000001 5 0 0 5 Siskiyou, California, US
1516 1516 41043 Linn Oregon US 2020-05-01 02:32:28 44.48899494 -122.53731540000001 86 7 0 79 Linn, Oregon, US
1219 1219 53029 Island Washington US 2020-05-01 02:32:28 48.14713305 -122.5216407 168 8 0 159 Island, Washington, US
482 482 53011 Clark Washington US 2020-05-01 02:32:28 45.77568046 -122.48292040000001 321 21 0 302 Clark, Washington, US
2272 2272 6075 San Francisco California US 2020-05-01 02:32:28 37.75215114 -122.43856720000001 1499 25 0 1474 San Francisco, California, US
1834 1834 41051 Multnomah Oregon US 2020-05-01 02:32:28 45.54747959 -122.4169351 707 43 0 664 Multnomah, Oregon, US
949 949 6021 Glenn California US 2020-05-01 02:32:28 39.59875897 -122.3938452 5 0 0 5 Glenn, California, US
1479 1479 53041 Lewis Washington US 2020-05-01 02:32:28 46.57756476 -122.39257690000001 29 3 0 26 Lewis, Washington, US
1846 1846 6055 Napa California US 2020-05-01 02:32:28 38.50735751 -122.33283899999999 67 2 0 65 Napa, California, US
2280 2280 6081 San Mateo California US 2020-05-01 02:32:28 37.422880799999994 -122.32755459999998 1177 48 0 1129 San Mateo, California, US
2517 2517 6103 Tehama California US 2020-05-01 02:32:28 40.12570935 -122.23701709999999 1 1 0 0 Tehama, California, US
562 562 6011 Colusa California US 2020-05-01 02:32:28 39.17881957 -122.2331726 3 0 0 3 Colusa, California, US
465 465 41005 Clackamas Oregon US 2020-05-01 02:32:28 45.18787398 -122.2179634 214 7 0 207 Clackamas, Oregon, US
2056 2056 53053 Pierce Washington US 2020-05-01 02:32:28 47.03892768 -122.14059579999999 1322 53 0 1273 Pierce, Washington, US
2341 2341 6089 Shasta California US 2020-05-01 02:32:28 40.76391419 -122.0396884 31 4 0 27 Shasta, California, US
2292 2292 6087 Santa Cruz California US 2020-05-01 02:32:28 37.05580291 -122.0066524 131 2 0 129 Santa Cruz, California, US
2383 2383 6095 Solano California US 2020-05-01 02:32:28 38.26827353 -121.9357113 263 5 0 258 Solano, California, US
569 569 6013 Contra Costa California US 2020-05-01 02:32:28 37.91923498 -121.9289527 891 27 0 864 Contra Costa, California, US
2373 2373 53059 Skamania Washington US 2020-05-01 02:32:28 46.02408726 -121.91644029999999 3 0 0 3 Skamania, Washington, US
2893 2893 6113 Yolo California US 2020-05-01 02:32:28 38.68278902 -121.90182879999999 164 16 0 148 Yolo, California, US
24 24 6001 Alameda California US 2020-05-01 02:32:28 37.64629437 -121.8929271 1603 60 0 1543 Alameda, California, US
1350 1350 53033 King Washington US 2020-05-01 02:32:28 47.49137892 -121.8346131 6207 458 0 5760 King, Washington, US
2372 2372 53057 Skagit Washington US 2020-05-01 02:32:28 48.48171488 -121.766131 329 12 0 316 Skagit, Washington, US
2802 2802 53073 Whatcom Washington US 2020-05-01 02:32:28 48.82227976 -121.74900179999999 302 27 0 274 Whatcom, Washington, US
2380 2380 53061 Snohomish Washington US 2020-05-01 02:32:28 48.04615983 -121.7170703 2433 109 0 2325 Snohomish, Washington, US
2290 2290 6085 Santa Clara California US 2020-05-01 02:32:28 37.23104908 -121.6970462 2163 111 0 2052 Santa Clara, California, US
2490 2490 6101 Sutter California US 2020-05-01 02:32:28 39.03417539 -121.6945899 30 2 0 28 Sutter, California, US
1160 1160 41027 Hood River Oregon US 2020-05-01 02:32:28 45.51872811 -121.65520359999998 6 0 0 6 Hood River, Oregon, US
1363 1363 41035 Klamath Oregon US 2020-05-01 02:32:28 42.68762984 -121.64964609999998 38 0 0 38 Klamath, Oregon, US
294 294 6007 Butte California US 2020-05-01 02:32:28 39.66727762 -121.6005252 16 0 0 16 Butte, California, US
2900 2900 6115 Yuba California US 2020-05-01 02:32:28 39.26255932 -121.35356440000001 18 1 0 17 Yuba, California, US
2254 2254 6067 Sacramento California US 2020-05-01 02:32:28 38.45106826 -121.34253740000001 1077 43 0 1034 Sacramento, California, US
2274 2274 6077 San Joaquin California US 2020-05-01 02:32:28 37.93433732 -121.2730061 543 25 0 518 San Joaquin, California, US
1782 1782 6053 Monterey California US 2020-05-01 02:32:28 36.21862405 -121.24133970000001 206 5 0 201 Monterey, California, US
702 702 41017 Deschutes Oregon US 2020-05-01 02:32:28 43.91570171 -121.2289121 76 0 0 76 Deschutes, Oregon, US
1277 1277 41031 Jefferson Oregon US 2020-05-01 02:32:28 44.62806839 -121.17832 10 0 0 10 Jefferson, Oregon, US
2724 2724 41065 Wasco Oregon US 2020-05-01 02:32:28 45.16292781 -121.16709540000001 13 1 0 12 Wasco, Oregon, US
2269 2269 6069 San Benito California US 2020-05-01 02:32:28 36.60308176 -121.069975 50 2 0 48 San Benito, California, US
2429 2429 6099 Stanislaus California US 2020-05-01 02:32:28 37.55862499 -120.9970722 374 11 0 328 Stanislaus, California, US
2084 2084 6063 Plumas California US 2020-05-01 02:32:28 40.00355989 -120.8395236 4 0 0 4 Plumas, California, US
1365 1365 53039 Klickitat Washington US 2020-05-01 02:32:28 45.87325839 -120.7913598 17 2 0 14 Klickitat, Washington, US
1862 1862 6057 Nevada California US 2020-05-01 02:32:28 39.30394768 -120.76272809999999 41 1 0 40 Nevada, California, US
2882 2882 53077 Yakima Washington US 2020-05-01 02:32:28 46.45738486 -120.73801259999999 1128 48 0 1081 Yakima, Washington, US
2078 2078 6061 Placer California US 2020-05-01 02:32:28 39.06167234 -120.72405690000001 147 8 0 139 Placer, California, US
1709 1709 6047 Merced California US 2020-05-01 02:32:28 37.18922369 -120.72090349999999 125 3 0 122 Merced, California, US
2360 2360 41055 Sherman Oregon US 2020-05-01 02:32:28 45.41501554 -120.6827834 1 0 0 1 Sherman, Oregon, US
1361 1361 53037 Kittitas Washington US 2020-05-01 02:32:28 47.12521214 -120.67943899999999 14 0 0 14 Kittitas, Washington, US
49 49 6005 Amador California US 2020-05-01 02:32:28 38.44583082 -120.65696000000001 8 0 0 8 Amador, California, US
423 423 53007 Chelan Washington US 2020-05-01 02:32:28 47.87046092 -120.6173956 108 5 0 103 Chelan, Washington, US
301 301 6009 Calaveras California US 2020-05-01 02:32:28 38.20537103 -120.55291299999999 13 0 0 13 Calaveras, California, US
774 774 6017 El Dorado California US 2020-05-01 02:32:28 38.77965956 -120.5233166 44 0 0 44 El Dorado, California, US
2279 2279 6079 San Luis Obispo California US 2020-05-01 02:32:28 35.38822029 -120.4039028 184 1 0 183 San Luis Obispo, California, US
616 616 41013 Crook Oregon US 2020-05-01 02:32:28 44.14230227 -120.356297 1 0 0 1 Crook, Oregon, US
2289 2289 6083 Santa Barbara California US 2020-05-01 02:32:28 34.65329488 -120.0188492 485 8 0 477 Santa Barbara, California, US
2569 2569 6109 Tuolumne California US 2020-05-01 02:32:28 38.02644018 -119.95250929999999 4 0 0 4 Tuolumne, California, US
1627 1627 6043 Mariposa California US 2020-05-01 02:32:28 37.57978556 -119.9073334 3 0 0 3 Mariposa, California, US
48 48 6003 Alpine California US 2020-05-01 02:32:28 38.59678594 -119.82235940000001 2 0 0 2 Alpine, California, US
1355 1355 6031 Kings California US 2020-05-01 02:32:28 36.07409056 -119.8159973 96 1 0 95 Kings, California, US
1573 1573 6039 Madera California US 2020-05-01 02:32:28 37.21513971 -119.76655890000002 46 2 0 44 Madera, California, US
364 364 32510 Carson City Nevada US 2020-05-01 02:32:28 39.15509045 -119.7480219 45 1 0 44 Carson City, Nevada, US
1924 1924 53047 Okanogan Washington US 2020-05-01 02:32:28 48.54855019 -119.73872240000001 22 1 0 21 Okanogan, Washington, US
740 740 53017 Douglas Washington US 2020-05-01 02:32:28 47.7361335 -119.69293700000001 78 2 0 77 Douglas, Washington, US
2759 2759 32031 Washoe Nevada US 2020-05-01 02:32:28 40.66562265 -119.6631594 873 30 0 843 Washoe, Nevada, US
894 894 6019 Fresno California US 2020-05-01 02:32:28 36.75733899 -119.6466953 538 7 0 531 Fresno, California, US
737 737 32005 Douglas Nevada US 2020-05-01 02:32:28 38.912862 -119.61713329999999 19 0 0 19 Douglas, Nevada, US
1826 1826 41049 Morrow Oregon US 2020-05-01 02:32:28 45.41846568 -119.584546 6 0 0 6 Morrow, Oregon, US
2459 2459 32029 Storey Nevada US 2020-05-01 02:32:28 39.44875482 -119.5250207 0 0 0 0 Storey, Nevada, US
170 170 53005 Benton Washington US 2020-05-01 02:32:28 46.23946995 -119.51208340000001 430 44 0 389 Benton, Washington, US
983 983 53025 Grant Washington US 2020-05-01 02:32:28 47.20753737 -119.4500749 159 3 0 156 Grant, Washington, US
1563 1563 32019 Lyon Nevada US 2020-05-01 02:32:28 39.01777974 -119.18704790000001 28 0 0 28 Lyon, Nevada, US
2670 2670 6111 Ventura California US 2020-05-01 02:32:28 34.44465746 -119.09106129999999 535 18 0 517 Ventura, California, US
982 982 41023 Grant Oregon US 2020-05-01 02:32:28 44.49024544 -119.0068631 1 0 0 1 Grant, Oregon, US
1085 1085 41025 Harney Oregon US 2020-05-01 02:32:28 43.06422669 -118.96663059999999 1 0 0 1 Harney, Oregon, US
884 884 53021 Franklin Washington US 2020-05-01 02:32:28 46.53351425 -118.9018212 279 10 0 270 Franklin, Washington, US
1762 1762 6051 Mono California US 2020-05-01 02:32:28 37.93899289 -118.8872409 26 1 0 25 Mono, California, US
2566 2566 6107 Tulare California US 2020-05-01 02:32:28 36.22026558 -118.8020203 640 40 0 600 Tulare, California, US
2582 2582 41059 Umatilla Oregon US 2020-05-01 02:32:28 45.59073056 -118.7353826 50 0 0 50 Umatilla, Oregon, US
1344 1344 6029 Kern California US 2020-05-01 02:32:28 35.34329425 -118.72777959999999 893 7 0 886 Kern, California, US
17 17 53001 Adams Washington US 2020-05-01 02:32:28 46.98299757 -118.56017340000001 47 0 0 47 Adams, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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