03-28-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,433 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
3397 3397       Samoa 3/28/20 23:10 -13.759 -172.1046 0 0 0 0 Samoa
3172 3172 60000   American Samoa US 3/28/20 23:05 -14.271 -170.132 0 0 0 0 American Samoa, US
2090 2090 2180 Nome Alaska US 3/28/20 23:05 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
1541 1541 2158 Kusilvak Alaska US 3/28/20 23:05 62.1542916 -163.3967883 0 0 0 0 Kusilvak, Alaska, US
33 33 2013 Aleutians East Alaska US 3/28/20 23:05 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
200 200 2050 Bethel Alaska US 3/28/20 23:05 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
2100 2100 2188 Northwest Arctic Alaska US 3/28/20 23:05 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
1475 1475 15007 Kauai Hawaii US 3/28/20 23:05 22.03935037 -159.5966786 11 0 0 0 Kauai, Hawaii, US
785 785 2070 Dillingham Alaska US 3/28/20 23:05 59.79603738 -158.2381942 0 0 0 0 Dillingham, Alaska, US
1287 1287 15003 Honolulu Hawaii US 3/28/20 23:05 21.45803166 -157.9712182 108 0 0 0 Honolulu, Hawaii, US
1465 1465 15005 Kalawao Hawaii US 3/28/20 23:05 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
275 275 2060 Bristol Bay Alaska US 3/28/20 23:05 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1842 1842 15009 Maui Hawaii US 3/28/20 23:05 20.86399628 -156.5689097 16 0 0 0 Maui, Hawaii, US
1574 1574 2164 Lake and Peninsula Alaska US 3/28/20 23:05 58.62403337 -156.2140589 0 0 0 0 Lake and Peninsula, Alaska, US
1230 1230 15001 Hawaii Hawaii US 3/28/20 23:05 19.60121157 -155.5210167 10 0 0 0 Hawaii, Hawaii, US
1536 1536 2150 Kodiak Island Alaska US 3/28/20 23:05 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2094 2094 2185 North Slope Alaska US 3/28/20 23:05 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
1482 1482 2122 Kenai Peninsula Alaska US 3/28/20 23:05 60.24429722 -151.5388884 5 0 0 0 Kenai Peninsula,Alaska,US
3165 3165 2290 Yukon-Koyukuk Alaska US 3/28/20 23:05 65.50815459 -151.3907387 0 0 0 0 Yukon-Koyukuk, Alaska, US
767 767 2068 Denali Alaska US 3/28/20 23:05 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1840 1840 2170 Matanuska-Susitna Alaska US 3/28/20 23:05 62.31305045 -149.5741743 2 0 0 0 Matanuska-Susitna,Alaska,US
59 59 2020 Anchorage Alaska US 3/28/20 23:05 61.14998174 -149.1426986 43 1 0 0 Anchorage,Alaska,US
898 898 2090 Fairbanks North Star Alaska US 3/28/20 23:05 64.80726247 -146.5692662 19 0 0 0 Fairbanks North Star,Alaska,US
2904 2904 2261 Valdez-Cordova Alaska US 3/28/20 23:05 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
2645 2645 2240 Southeast Fairbanks Alaska US 3/28/20 23:05 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
3145 3145 2282 Yakutat Alaska US 3/28/20 23:05 59.8909808 -140.3601451 0 0 0 0 Yakutat, Alaska, US
1291 1291 2105 Hoonah-Angoon Alaska US 3/28/20 23:05 58.29307365 -135.6424424 0 0 0 0 Hoonah-Angoon, Alaska, US
1151 1151 2100 Haines Alaska US 3/28/20 23:05 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
2626 2626 2230 Skagway Alaska US 3/28/20 23:05 59.56149996 -135.3337748 0 0 0 0 Skagway, Alaska, US
2624 2624 2220 Sitka Alaska US 3/28/20 23:05 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
3257 3257     Yukon Canada 3/28/20 23:10 64.2823 -135.0 4 0 0 0 ,Yukon,Canada
1461 1461 2110 Juneau Alaska US 3/28/20 23:05 58.45031811 -134.200436 4 0 0 0 Juneau, Alaska, US
2350 2350 2198 Prince of Wales-Hyder Alaska US 3/28/20 23:05 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
2245 2245 2195 Petersburg Alaska US 3/28/20 23:05 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3133 3133 2275 Wrangell Alaska US 3/28/20 23:05 56.3202004 -132.0583731 0 0 0 0 Wrangell, Alaska, US
1498 1498 2130 Ketchikan Gateway Alaska US 3/28/20 23:05 55.57445008 -130.975561 12 0 0 0 Ketchikan Gateway, Alaska, US
3179 3179     British Columbia Canada 3/28/20 23:10 53.7267 -127.6476 884 17 0 0 British Columbia, Canada
3226 3226     Northwest Territories Canada 3/28/20 23:10 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
694 694 41015 Curry Oregon US 3/28/20 23:05 42.45911325 -124.157282 0 0 0 0 Curry, Oregon, US
634 634 41011 Coos Oregon US 3/28/20 23:05 43.17406868 -124.0594514 0 0 0 0 Coos, Oregon, US
517 517 53009 Clallam Washington US 3/28/20 23:05 48.04754642 -123.9226319 5 0 0 0 Clallam, Washington, US
757 757 6015 Del Norte California US 3/28/20 23:05 41.74228275 -123.8974063 0 0 0 0 Del Norte, California, US
1318 1318 6023 Humboldt California US 3/28/20 23:05 40.69923009 -123.876044 14 0 0 0 Humboldt, California, US
1681 1681 41041 Lincoln Oregon US 3/28/20 23:05 44.64252874 -123.869912 1 0 0 0 Lincoln, Oregon, US
1101 1101 53027 Grays Harbor Washington US 3/28/20 23:05 47.14003705 -123.7820567 1 0 0 0 Grays Harbor, Washington, US
2190 2190 53049 Pacific Washington US 3/28/20 23:05 46.55418369 -123.7285716 0 0 0 0 Pacific, Washington, US
2799 2799 41057 Tillamook Oregon US 3/28/20 23:05 45.46248721 -123.712066 1 0 0 0 Tillamook, Oregon, US
538 538 41007 Clatsop Oregon US 3/28/20 23:05 45.99712889 -123.660711 3 0 0 0 Clatsop, Oregon, US
1423 1423 53031 Jefferson Washington US 3/28/20 23:05 47.75003077 -123.5609704 11 0 0 0 Jefferson, Washington, US
1458 1458 41033 Josephine Oregon US 3/28/20 23:05 42.3665549 -123.5561938 5 0 0 0 Josephine, Oregon, US
187 187 41003 Benton Oregon US 3/28/20 23:05 44.49167306 -123.4316987 8 0 0 0 Benton, Oregon, US
2937 2937 53069 Wahkiakum Washington US 3/28/20 23:05 46.2918004 -123.4250831 0 0 0 0 Wahkiakum, Washington, US
2309 2309 41053 Polk Oregon US 3/28/20 23:05 44.90322804 -123.4128888 11 0 0 0 Polk, Oregon, US
1893 1893 6045 Mendocino California US 3/28/20 23:05 39.4381191 -123.3911313 2 0 0 0 Mendocino, California, US
3147 3147 41071 Yamhill Oregon US 3/28/20 23:05 45.23330449 -123.3086963 13 1 0 0 Yamhill, Oregon, US
1836 1836 53045 Mason Washington US 3/28/20 23:05 47.35007586 -123.1863685 2 0 0 0 Mason, Washington, US
815 815 41019 Douglas Oregon US 3/28/20 23:05 43.27941273 -123.167291 4 0 0 0 Douglas, Oregon, US
2831 2831 6105 Trinity California US 3/28/20 23:05 40.6491767 -123.114713 0 0 0 0 Trinity, California, US
3000 3000 41067 Washington Oregon US 3/28/20 23:05 45.55972701 -123.0955257 140 3 0 0 Washington, Oregon, US
610 610 41009 Columbia Oregon US 3/28/20 23:05 45.94464254 -123.0890898 1 0 0 0 Columbia, Oregon, US
2515 2515 53055 San Juan Washington US 3/28/20 23:05 48.60182783 -122.96745 3 0 0 0 San Juan, Washington, US
2643 2643 6097 Sonoma California US 3/28/20 23:05 38.52746429 -122.8862506 50 1 0 0 Sonoma, California, US
1589 1589 41039 Lane Oregon US 3/28/20 23:05 43.93727035 -122.847753 9 1 0 0 Lane, Oregon, US
2797 2797 53067 Thurston Washington US 3/28/20 23:05 46.9291895 -122.8290656 27 0 0 0 Thurston, Washington, US
1562 1562 6033 Lake California US 3/28/20 23:05 39.10124298 -122.7536244 0 0 0 0 Lake, California, US
1382 1382 41029 Jackson Oregon US 3/28/20 23:05 42.43201126 -122.7289309 8 0 0 0 Jackson, Oregon, US
1790 1790 6041 Marin California US 3/28/20 23:05 38.07122463 -122.7210631 68 1 0 0 Marin, California, US
650 650 53015 Cowlitz Washington US 3/28/20 23:05 46.19074721 -122.6782231 10 0 0 0 Cowlitz, Washington, US
1520 1520 53035 Kitsap Washington US 3/28/20 23:05 47.63479026 -122.6436061 42 1 0 0 Kitsap, Washington, US
1804 1804 41047 Marion Oregon US 3/28/20 23:05 44.90287942 -122.5815117 94 3 0 0 Marion, Oregon, US
2623 2623 6093 Siskiyou California US 3/28/20 23:05 41.59198861 -122.5407434 3 0 0 0 Siskiyou, California, US
1691 1691 41043 Linn Oregon US 3/28/20 23:05 44.48899494 -122.5373154 32 1 0 0 Linn, Oregon, US
1357 1357 53029 Island Washington US 3/28/20 23:05 48.14713305 -122.5216407 80 1 0 0 Island, Washington, US
531 531 53011 Clark Washington US 3/28/20 23:05 45.77568046 -122.4829204 82 6 0 0 Clark, Washington, US
2509 2509 6075 San Francisco California US 3/28/20 23:05 37.75215114 -122.4385672 308 4 0 0 San Francisco, California, US
2030 2030 41051 Multnomah Oregon US 3/28/20 23:05 45.54747959 -122.4169351 81 2 0 0 Multnomah, Oregon, US
1052 1052 6021 Glenn California US 3/28/20 23:05 39.59875897 -122.3938452 0 0 0 0 Glenn, California, US
1652 1652 53041 Lewis Washington US 3/28/20 23:05 46.57756476 -122.3925769 7 0 0 0 Lewis, Washington, US
2043 2043 6055 Napa California US 3/28/20 23:05 38.50735751 -122.332839 9 0 0 0 Napa, California, US
2517 2517 6081 San Mateo California US 3/28/20 23:05 37.4228808 -122.3275546 274 6 0 0 San Mateo, California, US
2778 2778 6103 Tehama California US 3/28/20 23:05 40.12570935 -122.2370171 0 0 0 0 Tehama, California, US
616 616 6011 Colusa California US 3/28/20 23:05 39.17881957 -122.2331726 1 0 0 0 Colusa, California, US
513 513 41005 Clackamas Oregon US 3/28/20 23:05 45.18787398 -122.2179634 36 2 0 0 Clackamas, Oregon, US
2265 2265 53053 Pierce Washington US 3/28/20 23:05 47.03892768 -122.1405958 231 5 0 0 Pierce, Washington, US
2588 2588 6089 Shasta California US 3/28/20 23:05 40.76391419 -122.0396884 3 1 0 0 Shasta, California, US
2532 2532 6087 Santa Cruz California US 3/28/20 23:05 37.05580291 -122.0066524 34 0 0 0 Santa Cruz, California, US
2637 2637 6095 Solano California US 3/28/20 23:05 38.26827353 -121.9357113 34 0 0 0 Solano, California, US
625 625 6013 Contra Costa California US 3/28/20 23:05 37.91923498 -121.9289527 168 2 0 0 Contra Costa, California, US
2627 2627 53059 Skamania Washington US 3/28/20 23:05 46.02408726 -121.9164403 1 0 0 0 Skamania, Washington, US
3157 3157 6113 Yolo California US 3/28/20 23:05 38.68278902 -121.9018288 16 1 0 0 Yolo, California, US
26 26 6001 Alameda California US 3/28/20 23:05 37.64629437 -121.8929271 220 4 0 0 Alameda, California, US
1506 1506 53033 King Washington US 3/28/20 23:05 47.49137892 -121.8346131 2077 136 0 0 King, Washington, US
2625 2625 53057 Skagit Washington US 3/28/20 23:05 48.48171488 -121.766131 91 1 0 0 Skagit, Washington, US
3058 3058 53073 Whatcom Washington US 3/28/20 23:05 48.82227976 -121.7490018 102 4 0 0 Whatcom, Washington, US
2634 2634 53061 Snohomish Washington US 3/28/20 23:05 48.04615983 -121.7170703 913 23 0 0 Snohomish, Washington, US
2530 2530 6085 Santa Clara California US 3/28/20 23:05 37.23104908 -121.6970462 591 25 0 0 Santa Clara, California, US
2747 2747 6101 Sutter California US 3/28/20 23:05 39.03417539 -121.6945899 3 0 0 0 Sutter, California, US
1289 1289 41027 Hood River Oregon US 3/28/20 23:05 45.51872811 -121.6552036 1 0 0 0 Hood River, Oregon, US
1523 1523 41035 Klamath Oregon US 3/28/20 23:05 42.68762984 -121.6496461 2 0 0 0 Klamath, Oregon, US
331 331 6007 Butte California US 3/28/20 23:05 39.66727762 -121.6005252 5 0 0 0 Butte, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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