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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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