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