04-18-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,055 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
2635 2635 41067 Washington Oregon US 2020-04-18 22:32:47 45.55972701 -123.0955257 387 7 0 380 Washington, Oregon, US
537 537 41009 Columbia Oregon US 2020-04-18 22:32:47 45.94464254 -123.0890898 14 0 0 14 Columbia, Oregon, US
2186 2186 53055 San Juan Washington US 2020-04-18 22:32:47 48.60182783 -122.96745 15 0 0 15 San Juan, Washington, US
2292 2292 6097 Sonoma California US 2020-04-18 22:32:47 38.52746429 -122.8862506 180 2 0 178 Sonoma, California, US
1361 1361 41039 Lane Oregon US 2020-04-18 22:32:47 43.93727035 -122.847753 46 1 0 45 Lane, Oregon, US
2427 2427 53067 Thurston Washington US 2020-04-18 22:32:47 46.9291895 -122.8290656 89 1 0 88 Thurston, Washington, US
1340 1340 6033 Lake California US 2020-04-18 22:32:47 39.10124298 -122.7536244 6 0 0 6 Lake, California, US
1187 1187 41029 Jackson Oregon US 2020-04-18 22:32:47 42.43201126 -122.7289309 49 0 0 49 Jackson, Oregon, US
1545 1545 6041 Marin California US 2020-04-18 22:32:47 38.07122463 -122.7210631 187 10 0 177 Marin, California, US
573 573 53015 Cowlitz Washington US 2020-04-18 22:32:47 46.19074721 -122.6782231 29 0 0 29 Cowlitz, Washington, US
1302 1302 53035 Kitsap Washington US 2020-04-18 22:32:47 47.63479026 -122.6436061 135 1 0 134 Kitsap, Washington, US
1558 1558 41047 Marion Oregon US 2020-04-18 22:32:47 44.90287942 -122.5815117 335 13 0 322 Marion, Oregon, US
2275 2275 6093 Siskiyou California US 2020-04-18 22:32:47 41.59198861 -122.5407434 5 0 0 5 Siskiyou, California, US
1455 1455 41043 Linn Oregon US 2020-04-18 22:32:47 44.48899494 -122.5373154 59 6 0 53 Linn, Oregon, US
1164 1164 53029 Island Washington US 2020-04-18 22:32:47 48.14713305 -122.5216407 165 8 0 157 Island, Washington, US
466 466 53011 Clark Washington US 2020-04-18 22:32:47 45.77568046 -122.4829204 277 16 0 261 Clark, Washington, US
2181 2181 6075 San Francisco California US 2020-04-18 22:32:47 37.75215114 -122.4385672 1137 20 0 1117 San Francisco, California, US
1761 1761 41051 Multnomah Oregon US 2020-04-18 22:32:47 45.54747959 -122.4169351 493 28 0 465 Multnomah, Oregon, US
911 911 6021 Glenn California US 2020-04-18 22:32:47 39.59875897 -122.3938452 4 0 0 4 Glenn, California, US
1418 1418 53041 Lewis Washington US 2020-04-18 22:32:47 46.57756476 -122.3925769 19 3 0 17 Lewis, Washington, US
1772 1772 6055 Napa California US 2020-04-18 22:32:47 38.50735751 -122.332839 47 2 0 45 Napa, California, US
2188 2188 6081 San Mateo California US 2020-04-18 22:32:47 37.4228808 -122.3275546 838 28 0 810 San Mateo, California, US
2415 2415 6103 Tehama California US 2020-04-18 22:32:47 40.12570935 -122.2370171 1 1 0 0 Tehama, California, US
543 543 6011 Colusa California US 2020-04-18 22:32:47 39.17881957 -122.2331726 3 0 0 3 Colusa, California, US
450 450 41005 Clackamas Oregon US 2020-04-18 22:32:47 45.18787398 -122.2179634 154 5 0 149 Clackamas, Oregon, US
1972 1972 53053 Pierce Washington US 2020-04-18 22:32:47 47.03892768 -122.1405958 1086 36 0 1056 Pierce, Washington, US
2249 2249 6089 Shasta California US 2020-04-18 22:32:47 40.76391419 -122.0396884 26 3 0 23 Shasta, California, US
2200 2200 6087 Santa Cruz California US 2020-04-18 22:32:47 37.05580291 -122.0066524 101 2 0 99 Santa Cruz, California, US
2287 2287 6095 Solano California US 2020-04-18 22:32:47 38.26827353 -121.9357113 169 2 0 167 Solano, California, US
550 550 6013 Contra Costa California US 2020-04-18 22:32:47 37.91923498 -121.9289527 685 19 0 666 Contra Costa, California, US
2277 2277 53059 Skamania Washington US 2020-04-18 22:32:47 46.02408726 -121.9164403 3 0 0 3 Skamania, Washington, US
2772 2772 6113 Yolo California US 2020-04-18 22:32:47 38.68278902 -121.9018288 126 8 0 118 Yolo, California, US
24 24 6001 Alameda California US 2020-04-18 22:32:47 37.64629437 -121.8929271 1114 41 0 1073 Alameda, California, US
1293 1293 53033 King Washington US 2020-04-18 22:32:47 47.49137892 -121.8346131 4902 367 0 4571 King, Washington, US
2276 2276 53057 Skagit Washington US 2020-04-18 22:32:47 48.48171488 -121.766131 226 8 0 220 Skagit, Washington, US
2686 2686 53073 Whatcom Washington US 2020-04-18 22:32:47 48.82227976 -121.7490018 276 25 0 251 Whatcom, Washington, US
2284 2284 53061 Snohomish Washington US 2020-04-18 22:32:47 48.04615983 -121.7170703 2093 94 0 2002 Snohomish, Washington, US
2198 2198 6085 Santa Clara California US 2020-04-18 22:32:47 37.23104908 -121.6970462 1870 73 0 1797 Santa Clara, California, US
2389 2389 6101 Sutter California US 2020-04-18 22:32:47 39.03417539 -121.6945899 25 2 0 23 Sutter, California, US
1107 1107 41027 Hood River Oregon US 2020-04-18 22:32:47 45.51872811 -121.6552036 4 0 0 4 Hood River, Oregon, US
1305 1305 41035 Klamath Oregon US 2020-04-18 22:32:47 42.68762984 -121.6496461 31 0 0 31 Klamath, Oregon, US
290 290 6007 Butte California US 2020-04-18 22:32:47 39.66727762 -121.6005252 16 0 0 16 Butte, California, US
2779 2779 6115 Yuba California US 2020-04-18 22:32:47 39.26255932 -121.3535644 15 1 0 14 Yuba, California, US
2163 2163 6067 Sacramento California US 2020-04-18 22:32:47 38.45106826 -121.3425374 914 33 0 881 Sacramento, California, US
2183 2183 6077 San Joaquin California US 2020-04-18 22:32:47 37.93433732 -121.2730061 400 17 0 383 San Joaquin, California, US
1711 1711 6053 Monterey California US 2020-04-18 22:32:47 36.21862405 -121.2413397 119 3 0 116 Monterey, California, US
680 680 41017 Deschutes Oregon US 2020-04-18 22:32:47 43.91570171 -121.2289121 63 0 0 63 Deschutes, Oregon, US
1221 1221 41031 Jefferson Oregon US 2020-04-18 22:32:47 44.62806839 -121.17832 1 0 0 1 Jefferson, Oregon, US
2610 2610 41065 Wasco Oregon US 2020-04-18 22:32:47 45.16292781 -121.1670954 10 0 0 10 Wasco, Oregon, US
2178 2178 6069 San Benito California US 2020-04-18 22:32:47 36.60308176 -121.069975 44 2 0 42 San Benito, California, US
2330 2330 6099 Stanislaus California US 2020-04-18 22:32:47 37.55862499 -120.9970722 221 4 0 202 Stanislaus, California, US
1999 1999 6063 Plumas California US 2020-04-18 22:32:47 40.00355989 -120.8395236 4 0 0 4 Plumas, California, US
1307 1307 53039 Klickitat Washington US 2020-04-18 22:32:47 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1786 1786 6057 Nevada California US 2020-04-18 22:32:47 39.30394768 -120.7627281 36 1 0 35 Nevada, California, US
2762 2762 53077 Yakima Washington US 2020-04-18 22:32:47 46.45738486 -120.7380126 759 37 0 725 Yakima, Washington, US
1993 1993 6061 Placer California US 2020-04-18 22:32:47 39.06167234 -120.7240569 131 8 0 123 Placer, California, US
1641 1641 6047 Merced California US 2020-04-18 22:32:47 37.18922369 -120.7209035 86 3 0 83 Merced, California, US
2266 2266 41055 Sherman Oregon US 2020-04-18 22:32:47 45.41501554 -120.6827834 1 0 0 1 Sherman, Oregon, US
1303 1303 53037 Kittitas Washington US 2020-04-18 22:32:47 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
49 49 6005 Amador California US 2020-04-18 22:32:47 38.44583082 -120.65696 7 0 0 7 Amador, California, US
413 413 53007 Chelan Washington US 2020-04-18 22:32:47 47.87046092 -120.6173956 67 5 0 61 Chelan, Washington, US
297 297 6009 Calaveras California US 2020-04-18 22:32:47 38.20537103 -120.552913 12 0 0 12 Calaveras, California, US
749 749 6017 El Dorado California US 2020-04-18 22:32:47 38.77965956 -120.5233166 36 0 0 36 El Dorado, California, US
2187 2187 6079 San Luis Obispo California US 2020-04-18 22:32:47 35.38822029 -120.4039028 131 1 0 130 San Luis Obispo, California, US
596 596 41013 Crook Oregon US 2020-04-18 22:32:47 44.14230227 -120.356297 1 0 0 1 Crook, Oregon, US
2197 2197 6083 Santa Barbara California US 2020-04-18 22:32:47 34.65329488 -120.0188492 373 3 0 370 Santa Barbara, California, US
2465 2465 6109 Tuolumne California US 2020-04-18 22:32:47 38.02644018 -119.9525093 2 0 0 2 Tuolumne, California, US
48 48 6003 Alpine California US 2020-04-18 22:32:47 38.59678594 -119.8223594 2 0 0 2 Alpine, California, US
1298 1298 6031 Kings California US 2020-04-18 22:32:47 36.07409056 -119.8159973 20 1 0 19 Kings, California, US
1511 1511 6039 Madera California US 2020-04-18 22:32:47 37.21513971 -119.7665589 33 2 0 31 Madera, California, US
356 356 32510 Carson City Nevada US 2020-04-18 22:32:47 39.15509045 -119.7480219 28 0 0 28 Carson City, Nevada, US
1846 1846 53047 Okanogan Washington US 2020-04-18 22:32:47 48.54855019 -119.7387224 15 1 0 15 Okanogan, Washington, US
716 716 53017 Douglas Washington US 2020-04-18 22:32:47 47.7361335 -119.692937 34 1 0 33 Douglas, Washington, US
2644 2644 32031 Washoe Nevada US 2020-04-18 22:32:47 40.66562265 -119.6631594 588 16 0 572 Washoe, Nevada, US
864 864 6019 Fresno California US 2020-04-18 22:32:47 36.75733899 -119.6466953 311 7 0 304 Fresno, California, US
714 714 32005 Douglas Nevada US 2020-04-18 22:32:47 38.912862 -119.6171333 14 0 0 14 Douglas, Nevada, US
1753 1753 41049 Morrow Oregon US 2020-04-18 22:32:47 45.41846568 -119.584546 5 0 0 5 Morrow, Oregon, US
167 167 53005 Benton Washington US 2020-04-18 22:32:47 46.23946995 -119.5120834 306 36 0 272 Benton, Washington, US
943 943 53025 Grant Washington US 2020-04-18 22:32:47 47.20753737 -119.4500749 140 2 0 138 Grant, Washington, US
1501 1501 32019 Lyon Nevada US 2020-04-18 22:32:47 39.01777974 -119.1870479 15 0 0 15 Lyon, Nevada, US
2559 2559 6111 Ventura California US 2020-04-18 22:32:47 34.44465746 -119.0910613 396 13 0 383 Ventura, California, US
942 942 41023 Grant Oregon US 2020-04-18 22:32:47 44.49024544 -119.0068631 1 0 0 1 Grant, Oregon, US
854 854 53021 Franklin Washington US 2020-04-18 22:32:47 46.53351425 -118.9018212 177 4 0 173 Franklin, Washington, US
1691 1691 6051 Mono California US 2020-04-18 22:32:47 37.93899289 -118.8872409 23 1 0 22 Mono, California, US
2462 2462 6107 Tulare California US 2020-04-18 22:32:47 36.22026558 -118.8020203 397 17 0 380 Tulare, California, US
2478 2478 41059 Umatilla Oregon US 2020-04-18 22:32:47 45.59073056 -118.7353826 25 0 0 25 Umatilla, Oregon, US
1287 1287 6029 Kern California US 2020-04-18 22:32:47 35.34329425 -118.7277796 610 3 0 607 Kern, California, US
17 17 53001 Adams Washington US 2020-04-18 22:32:47 46.98299757 -118.5601734 40 0 0 40 Adams, Washington, US
807 807 53019 Ferry Washington US 2020-04-18 22:32:47 48.4711431 -118.5154041 1 0 0 1 Ferry, Washington, US
2582 2582 53071 Walla Walla Washington US 2020-04-18 22:32:47 46.23040051 -118.4775539 27 0 0 27 Walla Walla, Washington, US
1449 1449 53043 Lincoln Washington US 2020-04-18 22:32:47 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US
447 447 32001 Churchill Nevada US 2020-04-18 22:32:47 39.58105744 -118.3394607 3 0 0 3 Churchill, Nevada, US
1477 1477 6037 Los Angeles California US 2020-04-18 22:32:47 34.30828379 -118.2282411 12021 576 0 11445 Los Angeles, California, US
1132 1132 32013 Humboldt Nevada US 2020-04-18 22:32:47 41.40692186 -118.1109427 26 1 0 25 Humboldt, Nevada, US
2537 2537 41061 Union Oregon US 2020-04-18 22:32:47 45.30915495 -118.0068979 4 0 0 4 Union, Oregon, US
539 539 53013 Columbia Washington US 2020-04-18 22:32:47 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
2350 2350 53065 Stevens Washington US 2020-04-18 22:32:47 48.40035475 -117.8542701 8 1 0 7 Stevens, Washington, US
1862 1862 6059 Orange California US 2020-04-18 22:32:47 33.70147516 -117.7645998 1835 32 0 1524 Orange, California, US
1535 1535 41045 Malheur Oregon US 2020-04-18 22:32:47 43.1937027 -117.6227395 5 0 0 5 Malheur, Oregon, US
2697 2697 53075 Whitman Washington US 2020-04-18 22:32:47 46.90022523 -117.5241763 15 0 0 15 Whitman, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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