03-26-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,424 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
3388 3388       Samoa 2020-03-26 23:53:11 -13.759 -172.1046 0 0 0 0 Samoa
3168 3168 60000   American Samoa US 2020-03-26 23:48:35 -14.270999999999999 -170.132 0 0 0 0 American Samoa, US
2090 2090 2180 Nome Alaska US 2020-03-26 23:48:35 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
1541 1541 2158 Kusilvak Alaska US 2020-03-26 23:48:35 62.15429159999999 -163.39678830000003 0 0 0 0 Kusilvak, Alaska, US
33 33 2013 Aleutians East Alaska US 2020-03-26 23:48:35 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
200 200 2050 Bethel Alaska US 2020-03-26 23:48:35 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
2100 2100 2188 Northwest Arctic Alaska US 2020-03-26 23:48:35 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
1475 1475 15007 Kauai Hawaii US 2020-03-26 23:48:35 22.03935037 -159.5966786 2 0 0 0 Kauai, Hawaii, US
785 785 2070 Dillingham Alaska US 2020-03-26 23:48:35 59.79603738 -158.23819419999995 0 0 0 0 Dillingham, Alaska, US
1287 1287 15003 Honolulu Hawaii US 2020-03-26 23:48:35 21.45803166 -157.97121819999995 68 0 0 0 Honolulu, Hawaii, US
1465 1465 15005 Kalawao Hawaii US 2020-03-26 23:48:35 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
275 275 2060 Bristol Bay Alaska US 2020-03-26 23:48:35 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1842 1842 15009 Maui Hawaii US 2020-03-26 23:48:35 20.86399628 -156.56890969999995 13 0 0 0 Maui, Hawaii, US
1574 1574 2164 Lake and Peninsula Alaska US 2020-03-26 23:48:35 58.62403337 -156.21405890000003 0 0 0 0 Lake and Peninsula, Alaska, US
1230 1230 15001 Hawaii Hawaii US 2020-03-26 23:48:35 19.60121157 -155.5210167 4 0 0 0 Hawaii, Hawaii, US
1536 1536 2150 Kodiak Island Alaska US 2020-03-26 23:48:35 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2094 2094 2185 North Slope Alaska US 2020-03-26 23:48:35 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
1482 1482 2122 Kenai Peninsula Alaska US 2020-03-26 23:48:35 60.24429722 -151.53888840000005 4 0 0 0 Kenai Peninsula,Alaska,US
3161 3161 2290 Yukon-Koyukuk Alaska US 2020-03-26 23:48:35 65.50815459 -151.39073869999999 0 0 0 0 Yukon-Koyukuk, Alaska, US
767 767 2068 Denali Alaska US 2020-03-26 23:48:35 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1840 1840 2170 Matanuska-Susitna Alaska US 2020-03-26 23:48:35 62.31305045 -149.5741743 0 0 0 0 Matanuska-Susitna, Alaska, US
3183 3183     French Polynesia France 2020-03-26 23:48:18 -17.6797 -149.4068 30 0 0 30 French Polynesia, France
59 59 2020 Anchorage Alaska US 2020-03-26 23:48:35 61.14998174 -149.14269860000005 28 0 0 0 Anchorage, Alaska, US
898 898 2090 Fairbanks North Star Alaska US 2020-03-26 23:48:35 64.80726247 -146.5692662 11 0 0 0 Fairbanks North Star, Alaska, US
2900 2900 2261 Valdez-Cordova Alaska US 2020-03-26 23:48:35 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
2645 2645 2240 Southeast Fairbanks Alaska US 2020-03-26 23:48:35 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
3141 3141 2282 Yakutat Alaska US 2020-03-26 23:48:35 59.890980799999994 -140.36014509999998 0 0 0 0 Yakutat, Alaska, US
1291 1291 2105 Hoonah-Angoon Alaska US 2020-03-26 23:48:35 58.29307365 -135.64244240000002 0 0 0 0 Hoonah-Angoon, Alaska, US
1151 1151 2100 Haines Alaska US 2020-03-26 23:48:35 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
2626 2626 2230 Skagway Alaska US 2020-03-26 23:48:35 59.56149996 -135.33377480000001 0 0 0 0 Skagway, Alaska, US
2624 2624 2220 Sitka Alaska US 2020-03-26 23:48:35 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
3250 3250     Yukon Canada 2020-03-26 23:53:11 64.2823 -135.0 3 0 0 0 ,Yukon,Canada
1461 1461 2110 Juneau Alaska US 2020-03-26 23:48:35 58.45031811 -134.200436 2 0 0 0 Juneau, Alaska, US
2350 2350 2198 Prince of Wales-Hyder Alaska US 2020-03-26 23:48:35 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
2245 2245 2195 Petersburg Alaska US 2020-03-26 23:48:35 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3129 3129 2275 Wrangell Alaska US 2020-03-26 23:48:35 56.3202004 -132.05837309999998 0 0 0 0 Wrangell, Alaska, US
1498 1498 2130 Ketchikan Gateway Alaska US 2020-03-26 23:48:35 55.57445008 -130.975561 11 0 0 0 Ketchikan Gateway, Alaska, US
3174 3174     British Columbia Canada 2020-03-26 23:53:11 53.7267 -127.6476 725 14 0 0 British Columbia, Canada
3220 3220     Northwest Territories Canada 2020-03-26 23:53:11 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
694 694 41015 Curry Oregon US 2020-03-26 23:48:35 42.45911325 -124.15728200000001 0 0 0 0 Curry, Oregon, US
634 634 41011 Coos Oregon US 2020-03-26 23:48:35 43.17406868 -124.0594514 0 0 0 0 Coos, Oregon, US
517 517 53009 Clallam Washington US 2020-03-26 23:48:35 48.04754642 -123.92263190000001 5 0 0 0 Clallam, Washington, US
757 757 6015 Del Norte California US 2020-03-26 23:48:35 41.74228275 -123.89740630000001 0 0 0 0 Del Norte, California, US
1318 1318 6023 Humboldt California US 2020-03-26 23:48:35 40.69923009 -123.876044 10 0 0 0 Humboldt, California, US
1681 1681 41041 Lincoln Oregon US 2020-03-26 23:48:35 44.64252874 -123.86991200000001 1 0 0 0 Lincoln, Oregon, US
1101 1101 53027 Grays Harbor Washington US 2020-03-26 23:48:35 47.14003705 -123.7820567 1 0 0 0 Grays Harbor, Washington, US
2190 2190 53049 Pacific Washington US 2020-03-26 23:48:35 46.55418369 -123.7285716 0 0 0 0 Pacific, Washington, US
2799 2799 41057 Tillamook Oregon US 2020-03-26 23:48:35 45.46248721 -123.712066 1 0 0 0 Tillamook, Oregon, US
538 538 41007 Clatsop Oregon US 2020-03-26 23:48:35 45.99712889 -123.660711 2 0 0 0 Clatsop, Oregon, US
1423 1423 53031 Jefferson Washington US 2020-03-26 23:48:35 47.75003077 -123.56097040000002 11 0 0 0 Jefferson, Washington, US
1458 1458 41033 Josephine Oregon US 2020-03-26 23:48:35 42.3665549 -123.5561938 4 0 0 0 Josephine, Oregon, US
187 187 41003 Benton Oregon US 2020-03-26 23:48:35 44.49167306 -123.4316987 6 0 0 0 Benton, Oregon, US
2933 2933 53069 Wahkiakum Washington US 2020-03-26 23:48:35 46.29180039999999 -123.4250831 0 0 0 0 Wahkiakum, Washington, US
2309 2309 41053 Polk Oregon US 2020-03-26 23:48:35 44.90322804 -123.4128888 6 0 0 0 Polk, Oregon, US
1893 1893 6045 Mendocino California US 2020-03-26 23:48:35 39.4381191 -123.39113130000001 2 0 0 0 Mendocino, California, US
3143 3143 41071 Yamhill Oregon US 2020-03-26 23:48:35 45.23330449 -123.3086963 7 0 0 0 Yamhill, Oregon, US
1836 1836 53045 Mason Washington US 2020-03-26 23:48:35 47.35007586 -123.1863685 2 0 0 0 Mason, Washington, US
815 815 41019 Douglas Oregon US 2020-03-26 23:48:35 43.27941273 -123.16729099999999 3 0 0 0 Douglas, Oregon, US
2831 2831 6105 Trinity California US 2020-03-26 23:48:35 40.64917670000001 -123.114713 0 0 0 0 Trinity, California, US
2996 2996 41067 Washington Oregon US 2020-03-26 23:48:35 45.55972701 -123.0955257 104 3 0 0 Washington, Oregon, US
610 610 41009 Columbia Oregon US 2020-03-26 23:48:35 45.94464254 -123.08908980000001 0 0 0 0 Columbia, Oregon, US
2515 2515 53055 San Juan Washington US 2020-03-26 23:48:35 48.60182783 -122.96745 2 0 0 0 San Juan, Washington, US
2643 2643 6097 Sonoma California US 2020-03-26 23:48:35 38.52746429 -122.88625060000001 37 1 0 0 Sonoma, California, US
1589 1589 41039 Lane Oregon US 2020-03-26 23:48:35 43.93727035 -122.847753 7 1 0 0 Lane, Oregon, US
2797 2797 53067 Thurston Washington US 2020-03-26 23:48:35 46.9291895 -122.82906559999999 24 0 0 0 Thurston, Washington, US
1562 1562 6033 Lake California US 2020-03-26 23:48:35 39.10124298 -122.75362439999999 0 0 0 0 Lake, California, US
1382 1382 41029 Jackson Oregon US 2020-03-26 23:48:35 42.43201126 -122.72893090000001 4 0 0 0 Jackson, Oregon, US
1790 1790 6041 Marin California US 2020-03-26 23:48:35 38.07122463 -122.72106310000001 60 0 0 0 Marin, California, US
650 650 53015 Cowlitz Washington US 2020-03-26 23:48:35 46.19074721 -122.6782231 7 0 0 0 Cowlitz, Washington, US
1520 1520 53035 Kitsap Washington US 2020-03-26 23:48:35 47.63479026 -122.6436061 33 0 0 0 Kitsap, Washington, US
1804 1804 41047 Marion Oregon US 2020-03-26 23:48:35 44.90287942 -122.58151170000001 57 2 0 0 Marion, Oregon, US
2623 2623 6093 Siskiyou California US 2020-03-26 23:48:35 41.59198861 -122.54074340000001 3 0 0 0 Siskiyou, California, US
1691 1691 41043 Linn Oregon US 2020-03-26 23:48:35 44.48899494 -122.53731540000001 26 1 0 0 Linn, Oregon, US
1357 1357 53029 Island Washington US 2020-03-26 23:48:35 48.14713305 -122.5216407 64 1 0 0 Island, Washington, US
531 531 53011 Clark Washington US 2020-03-26 23:48:35 45.77568046 -122.48292040000001 48 5 0 0 Clark, Washington, US
2509 2509 6075 San Francisco California US 2020-03-26 23:48:35 37.75215114 -122.43856720000001 223 2 0 0 San Francisco, California, US
2030 2030 41051 Multnomah Oregon US 2020-03-26 23:48:35 45.54747959 -122.4169351 45 2 0 0 Multnomah, Oregon, US
1052 1052 6021 Glenn California US 2020-03-26 23:48:35 39.59875897 -122.3938452 0 0 0 0 Glenn, California, US
1652 1652 53041 Lewis Washington US 2020-03-26 23:48:35 46.57756476 -122.39257690000001 5 0 0 0 Lewis, Washington, US
2043 2043 6055 Napa California US 2020-03-26 23:48:35 38.50735751 -122.33283899999999 6 0 0 0 Napa, California, US
2517 2517 6081 San Mateo California US 2020-03-26 23:48:35 37.422880799999994 -122.32755459999998 195 5 0 0 San Mateo, California, US
2778 2778 6103 Tehama California US 2020-03-26 23:48:35 40.12570935 -122.23701709999999 0 0 0 0 Tehama, California, US
616 616 6011 Colusa California US 2020-03-26 23:48:35 39.17881957 -122.2331726 0 0 0 0 Colusa, California, US
513 513 41005 Clackamas Oregon US 2020-03-26 23:48:35 45.18787398 -122.2179634 21 2 0 0 Clackamas, Oregon, US
2265 2265 53053 Pierce Washington US 2020-03-26 23:48:35 47.03892768 -122.14059579999999 186 4 0 0 Pierce, Washington, US
2588 2588 6089 Shasta California US 2020-03-26 23:48:35 40.76391419 -122.0396884 3 1 0 0 Shasta, California, US
2532 2532 6087 Santa Cruz California US 2020-03-26 23:48:35 37.05580291 -122.0066524 25 0 0 0 Santa Cruz, California, US
2637 2637 6095 Solano California US 2020-03-26 23:48:35 38.26827353 -121.9357113 31 0 0 0 Solano, California, US
625 625 6013 Contra Costa California US 2020-03-26 23:48:35 37.91923498 -121.9289527 131 1 0 0 Contra Costa, California, US
2627 2627 53059 Skamania Washington US 2020-03-26 23:48:35 46.02408726 -121.91644029999999 0 0 0 0 Skamania, Washington, US
3153 3153 6113 Yolo California US 2020-03-26 23:48:35 38.68278902 -121.90182879999999 11 1 0 0 Yolo, California, US
26 26 6001 Alameda California US 2020-03-26 23:48:35 37.64629437 -121.8929271 178 4 0 0 Alameda, California, US
1506 1506 53033 King Washington US 2020-03-26 23:48:35 47.49137892 -121.8346131 1577 109 0 0 King, Washington, US
2625 2625 53057 Skagit Washington US 2020-03-26 23:48:35 48.48171488 -121.766131 78 1 0 0 Skagit, Washington, US
3054 3054 53073 Whatcom Washington US 2020-03-26 23:48:35 48.82227976 -121.74900179999999 86 4 0 0 Whatcom, Washington, US
2634 2634 53061 Snohomish Washington US 2020-03-26 23:48:35 48.04615983 -121.7170703 778 18 0 0 Snohomish, Washington, US
2530 2530 6085 Santa Clara California US 2020-03-26 23:48:35 37.23104908 -121.6970462 542 19 0 0 Santa Clara, California, US
2747 2747 6101 Sutter California US 2020-03-26 23:48:35 39.03417539 -121.6945899 2 0 0 0 Sutter, California, US
1289 1289 41027 Hood River Oregon US 2020-03-26 23:48:35 45.51872811 -121.65520359999998 1 0 0 0 Hood River, Oregon, US
1523 1523 41035 Klamath Oregon US 2020-03-26 23:48:35 42.68762984 -121.64964609999998 1 0 0 0 Klamath, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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