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,423 rows sorted by Long_

View and edit SQL

Suggested facets: Last_Update, Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
3388       Samoa 2020-03-25 23:37:36 -13.759 -172.1046 0 0 0 0 Samoa
3171 60000   American Samoa US 2020-03-25 23:33:19 -14.270999999999999 -170.132 0 0 0 0 American Samoa, US
2091 2180 Nome Alaska US 2020-03-25 23:33:19 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
1542 2158 Kusilvak Alaska US 2020-03-25 23:33:19 62.15429159999999 -163.39678830000003 0 0 0 0 Kusilvak, Alaska, US
33 2013 Aleutians East Alaska US 2020-03-25 23:33:19 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
200 2050 Bethel Alaska US 2020-03-25 23:33:19 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
2101 2188 Northwest Arctic Alaska US 2020-03-25 23:33:19 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
1476 15007 Kauai Hawaii US 2020-03-25 23:33:19 22.03935037 -159.5966786 1 0 0 0 Kauai, Hawaii, US
785 2070 Dillingham Alaska US 2020-03-25 23:33:19 59.79603738 -158.23819419999995 0 0 0 0 Dillingham, Alaska, US
1288 15003 Honolulu Hawaii US 2020-03-25 23:33:19 21.45803166 -157.97121819999995 58 0 0 0 Honolulu, Hawaii, US
1466 15005 Kalawao Hawaii US 2020-03-25 23:33:19 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
275 2060 Bristol Bay Alaska US 2020-03-25 23:33:19 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1843 15009 Maui Hawaii US 2020-03-25 23:33:19 20.86399628 -156.56890969999995 9 0 0 0 Maui, Hawaii, US
1575 2164 Lake and Peninsula Alaska US 2020-03-25 23:33:19 58.62403337 -156.21405890000003 0 0 0 0 Lake and Peninsula, Alaska, US
1231 15001 Hawaii Hawaii US 2020-03-25 23:33:19 19.60121157 -155.5210167 2 0 0 0 Hawaii, Hawaii, US
1537 2150 Kodiak Island Alaska US 2020-03-25 23:33:19 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2095 2185 North Slope Alaska US 2020-03-25 23:33:19 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
1483 2122 Kenai Peninsula Alaska US 2020-03-25 23:33:19 60.24429722 -151.53888840000005 4 0 0 0 Kenai Peninsula,Alaska,US
3164 2290 Yukon-Koyukuk Alaska US 2020-03-25 23:33:19 65.50815459 -151.39073869999999 0 0 0 0 Yukon-Koyukuk, Alaska, US
767 2068 Denali Alaska US 2020-03-25 23:33:19 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1841 2170 Matanuska-Susitna Alaska US 2020-03-25 23:33:19 62.31305045 -149.5741743 0 0 0 0 Matanuska-Susitna, Alaska, US
3186     French Polynesia France 2020-03-25 23:33:04 -17.6797 -149.4068 25 0 0 25 French Polynesia, France
59 2020 Anchorage Alaska US 2020-03-25 23:33:19 61.14998174 -149.14269860000005 17 0 0 0 Anchorage, Alaska, US
899 2090 Fairbanks North Star Alaska US 2020-03-25 23:33:19 64.80726247 -146.5692662 10 0 0 0 Fairbanks North Star, Alaska, US
2903 2261 Valdez-Cordova Alaska US 2020-03-25 23:33:19 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
2646 2240 Southeast Fairbanks Alaska US 2020-03-25 23:33:19 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
3144 2282 Yakutat Alaska US 2020-03-25 23:33:19 59.890980799999994 -140.36014509999998 0 0 0 0 Yakutat, Alaska, US
1292 2105 Hoonah-Angoon Alaska US 2020-03-25 23:33:19 58.29307365 -135.64244240000002 0 0 0 0 Hoonah-Angoon, Alaska, US
1152 2100 Haines Alaska US 2020-03-25 23:33:19 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
2627 2230 Skagway Alaska US 2020-03-25 23:33:19 59.56149996 -135.33377480000001 0 0 0 0 Skagway, Alaska, US
2625 2220 Sitka Alaska US 2020-03-25 23:33:19 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
1462 2110 Juneau Alaska US 2020-03-25 23:33:19 58.45031811 -134.200436 2 0 0 0 Juneau, Alaska, US
2351 2198 Prince of Wales-Hyder Alaska US 2020-03-25 23:33:19 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
2246 2195 Petersburg Alaska US 2020-03-25 23:33:19 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3132 2275 Wrangell Alaska US 2020-03-25 23:33:19 56.3202004 -132.05837309999998 0 0 0 0 Wrangell, Alaska, US
1499 2130 Ketchikan Gateway Alaska US 2020-03-25 23:33:19 55.57445008 -130.975561 8 0 0 0 Ketchikan Gateway, Alaska, US
3177     British Columbia Canada 2020-03-25 23:37:36 53.7267 -127.6476 617 13 0 0 British Columbia, Canada
694 41015 Curry Oregon US 2020-03-25 23:33:19 42.45911325 -124.15728200000001 0 0 0 0 Curry, Oregon, US
634 41011 Coos Oregon US 2020-03-25 23:33:19 43.17406868 -124.0594514 0 0 0 0 Coos, Oregon, US
517 53009 Clallam Washington US 2020-03-25 23:33:19 48.04754642 -123.92263190000001 4 0 0 0 Clallam, Washington, US
757 6015 Del Norte California US 2020-03-25 23:33:19 41.74228275 -123.89740630000001 0 0 0 0 Del Norte, California, US
1319 6023 Humboldt California US 2020-03-25 23:33:19 40.69923009 -123.876044 5 0 0 0 Humboldt, California, US
1682 41041 Lincoln Oregon US 2020-03-25 23:33:19 44.64252874 -123.86991200000001 1 0 0 0 Lincoln, Oregon, US
1102 53027 Grays Harbor Washington US 2020-03-25 23:33:19 47.14003705 -123.7820567 1 0 0 0 Grays Harbor, Washington, US
2191 53049 Pacific Washington US 2020-03-25 23:33:19 46.55418369 -123.7285716 0 0 0 0 Pacific, Washington, US
2800 41057 Tillamook Oregon US 2020-03-25 23:33:19 45.46248721 -123.712066 0 0 0 0 Tillamook, Oregon, US
538 41007 Clatsop Oregon US 2020-03-25 23:33:19 45.99712889 -123.660711 1 0 0 0 Clatsop, Oregon, US
1424 53031 Jefferson Washington US 2020-03-25 23:33:19 47.75003077 -123.56097040000002 9 0 0 0 Jefferson, Washington, US
1459 41033 Josephine Oregon US 2020-03-25 23:33:19 42.3665549 -123.5561938 2 0 0 0 Josephine, Oregon, US
187 41003 Benton Oregon US 2020-03-25 23:33:19 44.49167306 -123.4316987 6 0 0 0 Benton, Oregon, US
2936 53069 Wahkiakum Washington US 2020-03-25 23:33:19 46.29180039999999 -123.4250831 0 0 0 0 Wahkiakum, Washington, US
2310 41053 Polk Oregon US 2020-03-25 23:33:19 44.90322804 -123.4128888 3 0 0 0 Polk, Oregon, US
1894 6045 Mendocino California US 2020-03-25 23:33:19 39.4381191 -123.39113130000001 2 0 0 0 Mendocino, California, US
3146 41071 Yamhill Oregon US 2020-03-25 23:33:19 45.23330449 -123.3086963 7 0 0 0 Yamhill, Oregon, US
1837 53045 Mason Washington US 2020-03-25 23:33:19 47.35007586 -123.1863685 2 0 0 0 Mason, Washington, US
815 41019 Douglas Oregon US 2020-03-25 23:33:19 43.27941273 -123.16729099999999 3 0 0 0 Douglas, Oregon, US
2832 6105 Trinity California US 2020-03-25 23:33:19 40.64917670000001 -123.114713 0 0 0 0 Trinity, California, US
2999 41067 Washington Oregon US 2020-03-25 23:33:19 45.55972701 -123.0955257 96 2 0 0 Washington, Oregon, US
610 41009 Columbia Oregon US 2020-03-25 23:33:19 45.94464254 -123.08908980000001 0 0 0 0 Columbia, Oregon, US
2516 53055 San Juan Washington US 2020-03-25 23:33:19 48.60182783 -122.96745 1 0 0 0 San Juan, Washington, US
2644 6097 Sonoma California US 2020-03-25 23:33:19 38.52746429 -122.88625060000001 34 1 0 0 Sonoma, California, US
1590 41039 Lane Oregon US 2020-03-25 23:33:19 43.93727035 -122.847753 5 1 0 0 Lane, Oregon, US
2798 53067 Thurston Washington US 2020-03-25 23:33:19 46.9291895 -122.82906559999999 14 0 0 0 Thurston, Washington, US
1563 6033 Lake California US 2020-03-25 23:33:19 39.10124298 -122.75362439999999 0 0 0 0 Lake, California, US
1383 41029 Jackson Oregon US 2020-03-25 23:33:19 42.43201126 -122.72893090000001 4 0 0 0 Jackson, Oregon, US
1791 6041 Marin California US 2020-03-25 23:33:19 38.07122463 -122.72106310000001 53 0 0 0 Marin, California, US
650 53015 Cowlitz Washington US 2020-03-25 23:33:19 46.19074721 -122.6782231 3 0 0 0 Cowlitz, Washington, US
1521 53035 Kitsap Washington US 2020-03-25 23:33:19 47.63479026 -122.6436061 20 0 0 0 Kitsap, Washington, US
1805 41047 Marion Oregon US 2020-03-25 23:33:19 44.90287942 -122.58151170000001 43 2 0 0 Marion, Oregon, US
2624 6093 Siskiyou California US 2020-03-25 23:33:19 41.59198861 -122.54074340000001 3 0 0 0 Siskiyou, California, US
1692 41043 Linn Oregon US 2020-03-25 23:33:19 44.48899494 -122.53731540000001 25 1 0 0 Linn, Oregon, US
1358 53029 Island Washington US 2020-03-25 23:33:19 48.14713305 -122.5216407 38 1 0 0 Island, Washington, US
531 53011 Clark Washington US 2020-03-25 23:33:19 45.77568046 -122.48292040000001 16 4 0 0 Clark, Washington, US
2510 6075 San Francisco California US 2020-03-25 23:33:19 37.75215114 -122.43856720000001 178 1 0 0 San Francisco, California, US
2031 41051 Multnomah Oregon US 2020-03-25 23:33:19 45.54747959 -122.4169351 33 2 0 0 Multnomah, Oregon, US
1053 6021 Glenn California US 2020-03-25 23:33:19 39.59875897 -122.3938452 0 0 0 0 Glenn, California, US
1653 53041 Lewis Washington US 2020-03-25 23:33:19 46.57756476 -122.39257690000001 2 0 0 0 Lewis, Washington, US
2044 6055 Napa California US 2020-03-25 23:33:19 38.50735751 -122.33283899999999 2 0 0 0 Napa, California, US
2518 6081 San Mateo California US 2020-03-25 23:33:19 37.422880799999994 -122.32755459999998 165 5 0 0 San Mateo, California, US
2779 6103 Tehama California US 2020-03-25 23:33:19 40.12570935 -122.23701709999999 0 0 0 0 Tehama, California, US
616 6011 Colusa California US 2020-03-25 23:33:19 39.17881957 -122.2331726 0 0 0 0 Colusa, California, US
513 41005 Clackamas Oregon US 2020-03-25 23:33:19 45.18787398 -122.2179634 21 2 0 0 Clackamas, Oregon, US
2266 53053 Pierce Washington US 2020-03-25 23:33:19 47.03892768 -122.14059579999999 155 2 0 0 Pierce, Washington, US
2589 6089 Shasta California US 2020-03-25 23:33:19 40.76391419 -122.0396884 3 1 0 0 Shasta, California, US
2533 6087 Santa Cruz California US 2020-03-25 23:33:19 37.05580291 -122.0066524 24 0 0 0 Santa Cruz, California, US
2638 6095 Solano California US 2020-03-25 23:33:19 38.26827353 -121.9357113 24 0 0 0 Solano, California, US
625 6013 Contra Costa California US 2020-03-25 23:33:19 37.91923498 -121.9289527 108 1 0 0 Contra Costa, California, US
2628 53059 Skamania Washington US 2020-03-25 23:33:19 46.02408726 -121.91644029999999 0 0 0 0 Skamania, Washington, US
3156 6113 Yolo California US 2020-03-25 23:33:19 38.68278902 -121.90182879999999 10 1 0 0 Yolo, California, US
26 6001 Alameda California US 2020-03-25 23:33:19 37.64629437 -121.8929271 135 2 0 0 Alameda, California, US
1507 53033 King Washington US 2020-03-25 23:33:19 47.49137892 -121.8346131 1359 101 0 0 King, Washington, US
2626 53057 Skagit Washington US 2020-03-25 23:33:19 48.48171488 -121.766131 48 1 0 0 Skagit, Washington, US
3057 53073 Whatcom Washington US 2020-03-25 23:33:19 48.82227976 -121.74900179999999 64 2 0 0 Whatcom, Washington, US
2635 53061 Snohomish Washington US 2020-03-25 23:33:19 48.04615983 -121.7170703 634 16 0 0 Snohomish, Washington, US
2531 6085 Santa Clara California US 2020-03-25 23:33:19 37.23104908 -121.6970462 459 17 0 0 Santa Clara, California, US
2748 6101 Sutter California US 2020-03-25 23:33:19 39.03417539 -121.6945899 0 0 0 0 Sutter, California, US
1290 41027 Hood River Oregon US 2020-03-25 23:33:19 45.51872811 -121.65520359999998 1 0 0 0 Hood River, Oregon, US
1524 41035 Klamath Oregon US 2020-03-25 23:33:19 42.68762984 -121.64964609999998 1 0 0 0 Klamath, Oregon, US
331 6007 Butte California US 2020-03-25 23:33:19 39.66727762 -121.6005252 4 0 0 0 Butte, California, US
3163 6115 Yuba California US 2020-03-25 23:33:19 39.26255932 -121.35356440000001 0 0 0 0 Yuba, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [03-25-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
);