05-12-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,239 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
1312 1312 53031 Jefferson Washington US 2020-05-13 03:32:26 47.75003077 -123.56097040000002 29 0 0 29 Jefferson, Washington, US
1346 1346 41033 Josephine Oregon US 2020-05-13 03:32:26 42.3665549 -123.5561938 25 1 0 24 Josephine, Oregon, US
172 172 41003 Benton Oregon US 2020-05-13 03:32:26 44.49167306 -123.4316987 50 5 0 45 Benton, Oregon, US
2746 2746 53069 Wahkiakum Washington US 2020-05-13 03:32:26 46.29180039999999 -123.4250831 4 0 0 4 Wahkiakum, Washington, US
2144 2144 41053 Polk Oregon US 2020-05-13 03:32:26 44.90322804 -123.4128888 89 6 0 83 Polk, Oregon, US
1744 1744 6045 Mendocino California US 2020-05-13 03:32:26 39.4381191 -123.3911313 12 0 0 12 Mendocino, California, US
2942 2942 41071 Yamhill Oregon US 2020-05-13 03:32:26 45.23330449 -123.3086963 50 7 0 43 Yamhill, Oregon, US
1691 1691 53045 Mason Washington US 2020-05-13 03:32:26 47.35007586 -123.1863685 29 1 0 28 Mason, Washington, US
757 757 41019 Douglas Oregon US 2020-05-13 03:32:26 43.27941273 -123.167291 24 0 0 24 Douglas, Oregon, US
2617 2617 6105 Trinity California US 2020-05-13 03:32:26 40.64917670000001 -123.114713 2 0 0 2 Trinity, California, US
2807 2807 41067 Washington Oregon US 2020-05-13 03:32:26 45.55972701 -123.0955257 601 13 0 588 Washington, Oregon, US
571 571 41009 Columbia Oregon US 2020-05-13 03:32:26 45.94464254 -123.0890898 15 0 0 15 Columbia, Oregon, US
2329 2329 53055 San Juan Washington US 2020-05-13 03:32:26 48.60182783 -122.96745 15 0 0 15 San Juan, Washington, US
2440 2440 6097 Sonoma California US 2020-05-13 03:32:26 38.52746429 -122.8862506 312 4 0 308 Sonoma, California, US
1456 1456 41039 Lane Oregon US 2020-05-13 03:32:26 43.93727035 -122.847753 61 2 0 59 Lane, Oregon, US
2585 2585 53067 Thurston Washington US 2020-05-13 03:32:26 46.9291895 -122.8290656 122 1 0 121 Thurston, Washington, US
1433 1433 6033 Lake California US 2020-05-13 03:32:26 39.10124298 -122.7536244 8 0 0 8 Lake, California, US
1273 1273 41029 Jackson Oregon US 2020-05-13 03:32:26 42.43201126 -122.7289309 50 0 0 50 Jackson, Oregon, US
1646 1646 6041 Marin California US 2020-05-13 03:32:26 38.07122463 -122.7210631 271 14 0 257 Marin, California, US
609 609 53015 Cowlitz Washington US 2020-05-13 03:32:26 46.19074721 -122.6782231 66 0 0 66 Cowlitz, Washington, US
1394 1394 53035 Kitsap Washington US 2020-05-13 03:32:26 47.63479026 -122.6436061 156 2 0 154 Kitsap, Washington, US
1660 1660 41047 Marion Oregon US 2020-05-13 03:32:26 44.90287942 -122.5815117 723 23 0 700 Marion, Oregon, US
2422 2422 6093 Siskiyou California US 2020-05-13 03:32:26 41.59198861 -122.5407434 5 0 0 5 Siskiyou, California, US
1554 1554 41043 Linn Oregon US 2020-05-13 03:32:26 44.48899494 -122.5373154 104 8 0 96 Linn, Oregon, US
1250 1250 53029 Island Washington US 2020-05-13 03:32:26 48.14713305 -122.5216407 174 8 0 165 Island, Washington, US
494 494 53011 Clark Washington US 2020-05-13 03:32:26 45.77568046 -122.4829204 362 25 0 341 Clark, Washington, US
2323 2323 6075 San Francisco California US 2020-05-13 03:32:26 37.75215114 -122.4385672 1977 35 0 1942 San Francisco, California, US
1875 1875 41051 Multnomah Oregon US 2020-05-13 03:32:26 45.54747959 -122.4169351 908 53 0 855 Multnomah, Oregon, US
974 974 6021 Glenn California US 2020-05-13 03:32:26 39.59875897 -122.3938452 6 0 0 6 Glenn, California, US
1516 1516 53041 Lewis Washington US 2020-05-13 03:32:26 46.57756476 -122.3925769 32 3 0 29 Lewis, Washington, US
1887 1887 6055 Napa California US 2020-05-13 03:32:26 38.50735751 -122.332839 81 3 0 78 Napa, California, US
2331 2331 6081 San Mateo California US 2020-05-13 03:32:26 37.4228808 -122.32755459999998 1497 65 0 1432 San Mateo, California, US
2571 2571 6103 Tehama California US 2020-05-13 03:32:26 40.12570935 -122.2370171 1 1 0 0 Tehama, California, US
577 577 6011 Colusa California US 2020-05-13 03:32:26 39.17881957 -122.2331726 3 0 0 3 Colusa, California, US
477 477 41005 Clackamas Oregon US 2020-05-13 03:32:26 45.18787398 -122.2179634 274 9 0 265 Clackamas, Oregon, US
2101 2101 53053 Pierce Washington US 2020-05-13 03:32:26 47.03892768 -122.1405958 1593 66 0 1534 Pierce, Washington, US
2393 2393 6089 Shasta California US 2020-05-13 03:32:26 40.76391419 -122.0396884 32 4 0 28 Shasta, California, US
2343 2343 6087 Santa Cruz California US 2020-05-13 03:32:26 37.05580291 -122.0066524 146 2 0 144 Santa Cruz, California, US
2435 2435 6095 Solano California US 2020-05-13 03:32:26 38.26827353 -121.9357113 388 11 0 377 Solano, California, US
585 585 6013 Contra Costa California US 2020-05-13 03:32:26 37.91923498 -121.9289527 1066 32 0 1034 Contra Costa, California, US
2425 2425 53059 Skamania Washington US 2020-05-13 03:32:26 46.02408726 -121.9164403 3 0 0 3 Skamania, Washington, US
2952 2952 6113 Yolo California US 2020-05-13 03:32:26 38.68278902 -121.9018288 177 22 0 155 Yolo, California, US
24 24 6001 Alameda California US 2020-05-13 03:32:26 37.64629437 -121.8929271 2133 74 0 2059 Alameda, California, US
1384 1384 53033 King Washington US 2020-05-13 03:32:26 47.49137892 -121.8346131 7137 519 0 6624 King, Washington, US
2424 2424 53057 Skagit Washington US 2020-05-13 03:32:26 48.48171488 -121.766131 406 13 0 392 Skagit, Washington, US
2860 2860 53073 Whatcom Washington US 2020-05-13 03:32:26 48.82227976 -121.7490018 340 32 0 306 Whatcom, Washington, US
2432 2432 53061 Snohomish Washington US 2020-05-13 03:32:26 48.04615983 -121.7170703 2711 120 0 2590 Snohomish, Washington, US
2341 2341 6085 Santa Clara California US 2020-05-13 03:32:26 37.23104908 -121.6970462 2362 130 0 2232 Santa Clara, California, US
2543 2543 6101 Sutter California US 2020-05-13 03:32:26 39.03417539 -121.6945899 34 2 0 32 Sutter, California, US
1189 1189 41027 Hood River Oregon US 2020-05-13 03:32:26 45.51872811 -121.65520359999998 13 0 0 13 Hood River, Oregon, US
1397 1397 41035 Klamath Oregon US 2020-05-13 03:32:26 42.68762984 -121.64964609999998 41 0 0 41 Klamath, Oregon, US
304 304 6007 Butte California US 2020-05-13 03:32:26 39.66727762 -121.6005252 20 0 0 20 Butte, California, US
2959 2959 6115 Yuba California US 2020-05-13 03:32:26 39.26255932 -121.3535644 23 1 0 22 Yuba, California, US
2305 2305 6067 Sacramento California US 2020-05-13 03:32:26 38.45106826 -121.3425374 1181 50 0 1131 Sacramento, California, US
2325 2325 6077 San Joaquin California US 2020-05-13 03:32:26 37.93433732 -121.2730061 629 30 0 599 San Joaquin, California, US
1823 1823 6053 Monterey California US 2020-05-13 03:32:26 36.21862405 -121.2413397 299 6 0 293 Monterey, California, US
720 720 41017 Deschutes Oregon US 2020-05-13 03:32:26 43.91570171 -121.2289121 90 0 0 90 Deschutes, Oregon, US
1308 1308 41031 Jefferson Oregon US 2020-05-13 03:32:26 44.62806839 -121.17832 24 0 0 24 Jefferson, Oregon, US
2781 2781 41065 Wasco Oregon US 2020-05-13 03:32:26 45.16292781 -121.1670954 16 1 0 15 Wasco, Oregon, US
2320 2320 6069 San Benito California US 2020-05-13 03:32:26 36.60308176 -121.069975 58 2 0 56 San Benito, California, US
2480 2480 6099 Stanislaus California US 2020-05-13 03:32:26 37.55862499 -120.9970722 517 22 0 495 Stanislaus, California, US
2129 2129 6063 Plumas California US 2020-05-13 03:32:26 40.00355989 -120.8395236 4 0 0 4 Plumas, California, US
1399 1399 53039 Klickitat Washington US 2020-05-13 03:32:26 45.87325839 -120.7913598 21 2 0 18 Klickitat, Washington, US
1903 1903 6057 Nevada California US 2020-05-13 03:32:26 39.30394768 -120.7627281 41 1 0 40 Nevada, California, US
2940 2940 53077 Yakima Washington US 2020-05-13 03:32:26 46.45738486 -120.7380126 1916 73 0 1851 Yakima, Washington, US
2123 2123 6061 Placer California US 2020-05-13 03:32:26 39.06167234 -120.7240569 170 8 0 162 Placer, California, US
1748 1748 6047 Merced California US 2020-05-13 03:32:26 37.18922369 -120.7209035 177 4 0 173 Merced, California, US
2412 2412 41055 Sherman Oregon US 2020-05-13 03:32:26 45.41501554 -120.6827834 1 0 0 1 Sherman, Oregon, US
1395 1395 53037 Kittitas Washington US 2020-05-13 03:32:26 47.12521214 -120.679439 40 0 0 40 Kittitas, Washington, US
49 49 6005 Amador California US 2020-05-13 03:32:26 38.44583082 -120.65696 8 0 0 8 Amador, California, US
434 434 53007 Chelan Washington US 2020-05-13 03:32:26 47.87046092 -120.6173956 150 6 0 144 Chelan, Washington, US
311 311 6009 Calaveras California US 2020-05-13 03:32:26 38.20537103 -120.552913 13 0 0 13 Calaveras, California, US
793 793 6017 El Dorado California US 2020-05-13 03:32:26 38.77965956 -120.5233166 60 0 0 60 El Dorado, California, US
2330 2330 6079 San Luis Obispo California US 2020-05-13 03:32:26 35.38822029 -120.4039028 227 1 0 226 San Luis Obispo, California, US
632 632 41013 Crook Oregon US 2020-05-13 03:32:26 44.14230227 -120.356297 1 0 0 1 Crook, Oregon, US
2340 2340 6083 Santa Barbara California US 2020-05-13 03:32:26 34.65329488 -120.0188492 1371 11 0 1360 Santa Barbara, California, US
2626 2626 6109 Tuolumne California US 2020-05-13 03:32:26 38.02644018 -119.9525093 2 0 0 2 Tuolumne, California, US
1665 1665 6043 Mariposa California US 2020-05-13 03:32:26 37.57978556 -119.9073334 15 0 0 15 Mariposa, California, US
48 48 6003 Alpine California US 2020-05-13 03:32:26 38.59678594 -119.8223594 2 0 0 2 Alpine, California, US
1389 1389 6031 Kings California US 2020-05-13 03:32:26 36.07409056 -119.8159973 319 1 0 318 Kings, California, US
1611 1611 6039 Madera California US 2020-05-13 03:32:26 37.21513971 -119.76655890000002 69 2 0 67 Madera, California, US
375 375 32510 Carson City Nevada US 2020-05-13 03:32:26 39.15509045 -119.7480219 58 2 0 56 Carson City, Nevada, US
1966 1966 53047 Okanogan Washington US 2020-05-13 03:32:26 48.54855019 -119.7387224 30 2 0 29 Okanogan, Washington, US
759 759 53017 Douglas Washington US 2020-05-13 03:32:26 47.7361335 -119.692937 114 3 0 112 Douglas, Washington, US
2816 2816 32031 Washoe Nevada US 2020-05-13 03:32:26 40.66562265 -119.6631594 1116 40 0 1076 Washoe, Nevada, US
917 917 6019 Fresno California US 2020-05-13 03:32:26 36.75733899 -119.6466953 984 10 0 974 Fresno, California, US
756 756 32005 Douglas Nevada US 2020-05-13 03:32:26 38.912862 -119.6171333 24 0 0 24 Douglas, Nevada, US
1867 1867 41049 Morrow Oregon US 2020-05-13 03:32:26 45.41846568 -119.584546 12 0 0 12 Morrow, Oregon, US
2511 2511 32029 Storey Nevada US 2020-05-13 03:32:26 39.44875482 -119.5250207 0 0 0 0 Storey, Nevada, US
174 174 53005 Benton Washington US 2020-05-13 03:32:26 46.23946995 -119.5120834 588 58 0 535 Benton, Washington, US
1010 1010 53025 Grant Washington US 2020-05-13 03:32:26 47.20753737 -119.4500749 183 3 0 180 Grant, Washington, US
1601 1601 32019 Lyon Nevada US 2020-05-13 03:32:26 39.01777974 -119.1870479 45 0 0 45 Lyon, Nevada, US
2727 2727 6111 Ventura California US 2020-05-13 03:32:26 34.44465746 -119.0910613 698 19 0 679 Ventura, California, US
1008 1008 41023 Grant Oregon US 2020-05-13 03:32:26 44.49024544 -119.0068631 1 0 0 1 Grant, Oregon, US
1113 1113 41025 Harney Oregon US 2020-05-13 03:32:26 43.06422669 -118.9666306 1 0 0 1 Harney, Oregon, US
906 906 53021 Franklin Washington US 2020-05-13 03:32:26 46.53351425 -118.9018212 422 18 0 406 Franklin, Washington, US
1802 1802 6051 Mono California US 2020-05-13 03:32:26 37.93899289 -118.8872409 32 1 0 31 Mono, California, US
2623 2623 6107 Tulare California US 2020-05-13 03:32:26 36.22026558 -118.8020203 1241 52 0 1189 Tulare, California, US
2639 2639 41059 Umatilla Oregon US 2020-05-13 03:32:26 45.59073056 -118.7353826 85 2 0 83 Umatilla, Oregon, US
1377 1377 6029 Kern California US 2020-05-13 03:32:26 35.34329425 -118.7277796 1316 17 0 1299 Kern, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-12-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
);