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)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
815 815   Harris Texas US 2020-03-31 23:43:56     680 6 0 0 Harris,Texas,US
1256 1256   McIntosh Georgia US 2020-03-31 23:43:56     1 0 0 0 McIntosh,Georgia,US
2400 2400       Samoa 2020-03-31 23:49:13 -13.759 -172.1046 0 0 0 0 Samoa
994 994 15007 Kauai Hawaii US 2020-03-31 23:43:56 22.03935037 -159.5966786 12 0 0 0 Kauai, Hawaii, US
865 865 15003 Honolulu Hawaii US 2020-03-31 23:43:56 21.45803166 -157.97121819999995 139 0 0 0 Honolulu, Hawaii, US
1243 1243 15009 Maui Hawaii US 2020-03-31 23:43:56 20.86399628 -156.56890969999995 25 0 0 0 Maui, Hawaii, US
827 827 15001 Hawaii Hawaii US 2020-03-31 23:43:56 19.60121157 -155.5210167 15 0 0 0 Hawaii, Hawaii, 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
1241 1241   Matanuska-Susitna Alaska US 2020-03-31 23:43:56 62.31305045 -149.5741743 3 0 0 0 Matanuska-Susitna,Alaska,US
41 41 2020 Anchorage Alaska US 2020-03-31 23:43:56 61.14998174 -149.14269860000005 61 1 0 0 Anchorage,Alaska,US
621 621 2090 Fairbanks North Star Alaska US 2020-03-31 23:43:56 64.80726247 -146.5692662 30 0 0 0 Fairbanks North Star,Alaska,US
2258 2258     Yukon Canada 2020-03-31 23:49:13 64.2823 -135.0 5 0 0 0 ,Yukon,Canada
983 983 2110 Juneau Alaska US 2020-03-31 23:43:56 58.45031811 -134.200436 5 0 0 0 Juneau, Alaska, US
1013 1013 2130 Ketchikan Gateway Alaska US 2020-03-31 23:43:56 55.57445008 -130.975561 13 0 0 0 Ketchikan Gateway, Alaska, US
2180 2180     British Columbia Canada 2020-03-31 23:49:13 53.7267 -127.6476 1013 24 0 0 British Columbia, Canada
2227 2227     Northwest Territories Canada 2020-03-31 23:49:13 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
370 370 53009 Clallam Washington US 2020-03-31 23:43:56 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
883 883 6023 Humboldt California US 2020-03-31 23:43:56 40.69923009 -123.876044 21 0 0 0 Humboldt, California, US
1131 1131 41041 Lincoln Oregon US 2020-03-31 23:43:56 44.64252874 -123.86991200000001 2 0 0 0 Lincoln, Oregon, US
752 752 53027 Grays Harbor Washington US 2020-03-31 23:43:56 47.14003705 -123.7820567 2 0 0 0 Grays Harbor, Washington, US
1889 1889 41057 Tillamook Oregon US 2020-03-31 23:43:56 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
385 385 41007 Clatsop Oregon US 2020-03-31 23:43:56 45.99712889 -123.660711 3 0 0 0 Clatsop, Oregon, US
960 960 53031 Jefferson Washington US 2020-03-31 23:43:56 47.75003077 -123.56097040000002 16 0 0 0 Jefferson, Washington, US
982 982 41033 Josephine Oregon US 2020-03-31 23:43:56 42.3665549 -123.5561938 10 0 0 0 Josephine, Oregon, US
129 129 41003 Benton Oregon US 2020-03-31 23:43:56 44.49167306 -123.4316987 12 1 0 0 Benton, Oregon, US
1561 1561 41053 Polk Oregon US 2020-03-31 23:43:56 44.90322804 -123.4128888 18 0 0 0 Polk, Oregon, US
1277 1277 6045 Mendocino California US 2020-03-31 23:43:56 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2158 2158 41071 Yamhill Oregon US 2020-03-31 23:43:56 45.23330449 -123.3086963 16 3 0 0 Yamhill, Oregon, US
1238 1238 53045 Mason Washington US 2020-03-31 23:43:56 47.35007586 -123.1863685 5 0 0 0 Mason, Washington, US
569 569 41019 Douglas Oregon US 2020-03-31 23:43:56 43.27941273 -123.16729099999999 9 0 0 0 Douglas, Oregon, US
2050 2050 41067 Washington Oregon US 2020-03-31 23:43:56 45.55972701 -123.0955257 186 3 0 0 Washington, Oregon, US
435 435 41009 Columbia Oregon US 2020-03-31 23:43:56 45.94464254 -123.08908980000001 1 0 0 0 Columbia, Oregon, US
1691 1691 53055 San Juan Washington US 2020-03-31 23:43:56 48.60182783 -122.96745 4 0 0 0 San Juan, Washington, US
1776 1776 6097 Sonoma California US 2020-03-31 23:43:56 38.52746429 -122.88625060000001 73 1 0 0 Sonoma, California, US
1065 1065 41039 Lane Oregon US 2020-03-31 23:43:56 43.93727035 -122.847753 16 1 0 0 Lane, Oregon, US
1887 1887 53067 Thurston Washington US 2020-03-31 23:43:56 46.9291895 -122.82906559999999 48 0 0 0 Thurston, Washington, US
932 932 41029 Jackson Oregon US 2020-03-31 23:43:56 42.43201126 -122.72893090000001 21 0 0 0 Jackson, Oregon, US
1207 1207 6041 Marin California US 2020-03-31 23:43:56 38.07122463 -122.72106310000001 99 4 0 0 Marin, California, US
463 463 53015 Cowlitz Washington US 2020-03-31 23:43:56 46.19074721 -122.6782231 14 0 0 0 Cowlitz, Washington, US
1021 1021 53035 Kitsap Washington US 2020-03-31 23:43:56 47.63479026 -122.6436061 74 0 0 0 Kitsap, Washington, US
1216 1216 41047 Marion Oregon US 2020-03-31 23:43:56 44.90287942 -122.58151170000001 141 3 0 0 Marion, Oregon, US
1761 1761 6093 Siskiyou California US 2020-03-31 23:43:56 41.59198861 -122.54074340000001 3 0 0 0 Siskiyou, California, US
1137 1137 41043 Linn Oregon US 2020-03-31 23:43:56 44.48899494 -122.53731540000001 37 2 0 0 Linn, Oregon, US
914 914 53029 Island Washington US 2020-03-31 23:43:56 48.14713305 -122.5216407 106 3 0 0 Island, Washington, US
381 381 53011 Clark Washington US 2020-03-31 23:43:56 45.77568046 -122.48292040000001 116 6 0 0 Clark, Washington, US
1686 1686 6075 San Francisco California US 2020-03-31 23:43:56 37.75215114 -122.43856720000001 397 6 0 0 San Francisco, California, US
1369 1369 41051 Multnomah Oregon US 2020-03-31 23:43:56 45.54747959 -122.4169351 116 2 0 0 Multnomah, Oregon, US
723 723 6021 Glenn California US 2020-03-31 23:43:56 39.59875897 -122.3938452 2 0 0 0 Glenn, California, US
1110 1110 53041 Lewis Washington US 2020-03-31 23:43:56 46.57756476 -122.39257690000001 10 0 0 0 Lewis, Washington, US
1378 1378 6055 Napa California US 2020-03-31 23:43:56 38.50735751 -122.33283899999999 14 0 0 0 Napa, California, US
1693 1693 6081 San Mateo California US 2020-03-31 23:43:56 37.422880799999994 -122.32755459999998 309 10 0 0 San Mateo, California, US
441 441 6011 Colusa California US 2020-03-31 23:43:56 39.17881957 -122.2331726 1 0 0 0 Colusa, California, US
366 366 41005 Clackamas Oregon US 2020-03-31 23:43:56 45.18787398 -122.2179634 50 3 0 0 Clackamas, Oregon, US
1532 1532 53053 Pierce Washington US 2020-03-31 23:43:56 47.03892768 -122.14059579999999 377 6 0 0 Pierce, Washington, US
1740 1740 6089 Shasta California US 2020-03-31 23:43:56 40.76391419 -122.0396884 6 1 0 0 Shasta, California, US
1704 1704 6087 Santa Cruz California US 2020-03-31 23:43:56 37.05580291 -122.0066524 45 1 0 0 Santa Cruz, California, US
1771 1771 6095 Solano California US 2020-03-31 23:43:56 38.26827353 -121.9357113 43 0 0 0 Solano, California, US
446 446 6013 Contra Costa California US 2020-03-31 23:43:56 37.91923498 -121.9289527 212 3 0 0 Contra Costa, California, US
1763 1763 53059 Skamania Washington US 2020-03-31 23:43:56 46.02408726 -121.91644029999999 1 0 0 0 Skamania, Washington, US
2163 2163 6113 Yolo California US 2020-03-31 23:43:56 38.68278902 -121.90182879999999 24 1 0 0 Yolo, California, US
19 19 6001 Alameda California US 2020-03-31 23:43:56 37.64629437 -121.8929271 313 7 0 0 Alameda, California, US
1014 1014 53033 King Washington US 2020-03-31 23:43:56 47.49137892 -121.8346131 2330 150 0 0 King, Washington, US
1762 1762 53057 Skagit Washington US 2020-03-31 23:43:56 48.48171488 -121.766131 121 3 0 0 Skagit, Washington, US
2092 2092 53073 Whatcom Washington US 2020-03-31 23:43:56 48.82227976 -121.74900179999999 139 7 0 0 Whatcom, Washington, US
1768 1768 53061 Snohomish Washington US 2020-03-31 23:43:56 48.04615983 -121.7170703 1229 33 0 0 Snohomish, Washington, US
1702 1702 6085 Santa Clara California US 2020-03-31 23:43:56 37.23104908 -121.6970462 890 30 0 0 Santa Clara, California, US
1855 1855 6101 Sutter California US 2020-03-31 23:43:56 39.03417539 -121.6945899 9 0 0 0 Sutter, California, US
867 867 41027 Hood River Oregon US 2020-03-31 23:43:56 45.51872811 -121.65520359999998 3 0 0 0 Hood River, Oregon, US
1023 1023 41035 Klamath Oregon US 2020-03-31 23:43:56 42.68762984 -121.64964609999998 5 0 0 0 Klamath, Oregon, US
229 229 6007 Butte California US 2020-03-31 23:43:56 39.66727762 -121.6005252 8 0 0 0 Butte, California, US
2170 2170 6115 Yuba California US 2020-03-31 23:43:56 39.26255932 -121.35356440000001 6 0 0 0 Yuba, California, US
1671 1671 6067 Sacramento California US 2020-03-31 23:43:56 38.45106826 -121.34253740000001 224 7 0 0 Sacramento, California, US
1688 1688 6077 San Joaquin California US 2020-03-31 23:43:56 37.93433732 -121.2730061 136 6 0 0 San Joaquin, California, US
1330 1330 6053 Monterey California US 2020-03-31 23:43:56 36.21862405 -121.24133970000001 40 1 0 0 Monterey, California, US
542 542 41017 Deschutes Oregon US 2020-03-31 23:43:56 43.91570171 -121.2289121 24 0 0 0 Deschutes, Oregon, US
2029 2029 41065 Wasco Oregon US 2020-03-31 23:43:56 45.16292781 -121.16709540000001 7 0 0 0 Wasco, Oregon, US
1683 1683 6069 San Benito California US 2020-03-31 23:43:56 36.60308176 -121.069975 17 1 0 0 San Benito, California, US
1810 1810 6099 Stanislaus California US 2020-03-31 23:43:56 37.55862499 -120.9970722 33 0 0 0 Stanislaus, California, US
1025 1025 53039 Klickitat Washington US 2020-03-31 23:43:56 45.87325839 -120.7913598 9 1 0 0 Klickitat, Washington, US
1392 1392 6057 Nevada California US 2020-03-31 23:43:56 39.30394768 -120.76272809999999 21 0 0 0 Nevada, California, US
2156 2156 53077 Yakima Washington US 2020-03-31 23:43:56 46.45738486 -120.73801259999999 161 3 0 0 Yakima, Washington, US
1548 1548 6061 Placer California US 2020-03-31 23:43:56 39.06167234 -120.72405690000001 57 2 0 0 Placer, California, US
1279 1279 6047 Merced California US 2020-03-31 23:43:56 37.18922369 -120.72090349999999 10 0 0 0 Merced, California, US
1022 1022 53037 Kittitas Washington US 2020-03-31 23:43:56 47.12521214 -120.67943899999999 9 0 0 0 Kittitas, Washington, US
37 37 6005 Amador California US 2020-03-31 23:43:56 38.44583082 -120.65696000000001 2 0 0 0 Amador, California, US
335 335 53007 Chelan Washington US 2020-03-31 23:43:56 47.87046092 -120.6173956 16 2 0 0 Chelan, Washington, US
237 237 6009 Calaveras California US 2020-03-31 23:43:56 38.20537103 -120.55291299999999 3 0 0 0 Calaveras, California, US
599 599 6017 El Dorado California US 2020-03-31 23:43:56 38.77965956 -120.5233166 15 0 0 0 El Dorado, California, US
1692 1692 6079 San Luis Obispo California US 2020-03-31 23:43:56 35.38822029 -120.4039028 80 0 0 0 San Luis Obispo, California, US
1701 1701 6083 Santa Barbara California US 2020-03-31 23:43:56 34.65329488 -120.0188492 88 0 0 0 Santa Barbara, California, US
1915 1915 6109 Tuolumne California US 2020-03-31 23:43:56 38.02644018 -119.95250929999999 2 0 0 0 Tuolumne, California, US
1018 1018 6031 Kings California US 2020-03-31 23:43:56 36.07409056 -119.8159973 3 0 0 0 Kings, California, US
1180 1180 6039 Madera California US 2020-03-31 23:43:56 37.21513971 -119.76655890000002 21 1 0 0 Madera, California, US
285 285 32510 Carson City Nevada US 2020-03-31 23:43:56 39.15509045 -119.7480219 5 0 0 0 Carson City, Nevada, US
1439 1439 53047 Okanogan Washington US 2020-03-31 23:43:56 48.54855019 -119.73872240000001 3 0 0 0 Okanogan, Washington, US
570 570 53017 Douglas Washington US 2020-03-31 23:43:56 47.7361335 -119.69293700000001 5 0 0 0 Douglas, Washington, US
2059 2059 32031 Washoe Nevada US 2020-03-31 23:43:56 40.66562265 -119.6631594 121 3 0 0 Washoe, Nevada, US
691 691 6019 Fresno California US 2020-03-31 23:43:56 36.75733899 -119.6466953 53 0 0 0 Fresno, California, US
568 568 32005 Douglas Nevada US 2020-03-31 23:43:56 38.912862 -119.61713329999999 6 0 0 0 Douglas, Nevada, US
1364 1364 41049 Morrow Oregon US 2020-03-31 23:43:56 45.41846568 -119.584546 1 0 0 0 Morrow, Oregon, 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
);