03-22-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,420 rows sorted by Long_

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
246 246   Desoto Florida US 3/22/20 23:45     1 0 0 0 Desoto, Florida, US
297 297   Brockton Massachusetts US 3/22/20 23:45     6 0 0 0 Brockton, Massachusetts, US
299 299   Dukes and Nantucket Massachusetts US 3/22/20 23:45     1 0 0 0 Dukes and Nantucket, Massachusetts, US
484 484   Out-of-state Tennessee US 3/22/20 23:45     82 0 0 0 Out-of-state, Tennessee, US
487 487   Unknown Tennessee US 3/22/20 23:45     30 0 0 0 Unknown, Tennessee, US
873 873   LeSeur Minnesota US 3/22/20 23:45     1 0 0 0 LeSeur, Minnesota, US
1034 1034   Nashua New Hampshire US 3/22/20 23:45     1 0 0 0 Nashua, New Hampshire, US
1072 1072   Dona Ana New Mexico US 3/22/20 23:45     2 0 0 0 Dona Ana, New Mexico, US
1149 1149   Soldotna Alaska US 3/22/20 23:45     1 0 0 0 Soldotna, Alaska, US
1150 1150   Sterling Alaska US 3/22/20 23:45     1 0 0 0 Sterling, Alaska, US
3189 3189     Northwest Territories Canada 3/22/20 23:48     1 0 0 0 Northwest Territories, Canada
3199 3199     External territories Australia 3/22/20 23:48     0 0 0 0 External territories, Australia
3200 3200     Jervis Bay Territory Australia 3/22/20 23:48     0 0 0 0 Jervis Bay Territory, Australia
3413 3413       Samoa 3/22/20 23:48 -13.759 -172.1046 0 0 0 0 Samoa
3175 3175 60000   American Samoa US 3/22/20 23:45 -14.271 -170.132 0 0 0 0 American Samoa, US
1221 1221 2180 Nome Alaska US 3/22/20 23:45 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
1218 1218 2158 Kusilvak Alaska US 3/22/20 23:45 62.1542916 -163.3967883 0 0 0 0 Kusilvak, Alaska, US
1207 1207 2013 Aleutians East Alaska US 3/22/20 23:45 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
1209 1209 2050 Bethel Alaska US 3/22/20 23:45 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
1223 1223 2188 Northwest Arctic Alaska US 3/22/20 23:45 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
1078 1078 15007 Kauai Hawaii US 3/22/20 23:45 22.03935037 -159.5966786 3 0 0 0 Kauai, Hawaii, US
1212 1212 2070 Dillingham Alaska US 3/22/20 23:45 59.79603738 -158.2381942 0 0 0 0 Dillingham, Alaska, US
1076 1076 15003 Honolulu Hawaii US 3/22/20 23:45 21.45803166 -157.9712182 41 0 0 0 Honolulu, Hawaii, US
1461 1461 15005 Kalawao Hawaii US 3/22/20 23:45 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
1210 1210 2060 Bristol Bay Alaska US 3/22/20 23:45 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1077 1077 15009 Maui Hawaii US 3/22/20 23:45 20.86399628 -156.5689097 9 0 0 0 Maui, Hawaii, US
1219 1219 2164 Lake and Peninsula Alaska US 3/22/20 23:45 58.62403337 -156.2140589 0 0 0 0 Lake and Peninsula, Alaska, US
1460 1460 15001 Hawaii Hawaii US 3/22/20 23:45 19.60121157 -155.5210167 0 0 0 0 Hawaii, Hawaii, US
1217 1217 2150 Kodiak Island Alaska US 3/22/20 23:45 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
1222 1222 2185 North Slope Alaska US 3/22/20 23:45 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
1216 1216 2122 Kenai Peninsula Alaska US 3/22/20 23:45 60.24429722 -151.5388884 0 0 0 0 Kenai Peninsula, Alaska, US
1232 1232 2290 Yukon-Koyukuk Alaska US 3/22/20 23:45 65.50815459 -151.3907387 0 0 0 0 Yukon-Koyukuk, Alaska, US
1211 1211 2068 Denali Alaska US 3/22/20 23:45 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1220 1220 2170 Matanuska-Susitna Alaska US 3/22/20 23:45 62.31305045 -149.5741743 0 0 0 0 Matanuska-Susitna, Alaska, US
1148 1148 2020 Anchorage Alaska US 3/22/20 23:45 61.14998174 -149.1426986 5 0 0 0 Anchorage, Alaska, US
1146 1146 2090 Fairbanks North Star Alaska US 3/22/20 23:45 64.80726247 -146.5692662 7 0 0 0 Fairbanks North Star, Alaska, US
1229 1229 2261 Valdez-Cordova Alaska US 3/22/20 23:45 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
1228 1228 2240 Southeast Fairbanks Alaska US 3/22/20 23:45 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
1231 1231 2282 Yakutat Alaska US 3/22/20 23:45 59.8909808 -140.3601451 0 0 0 0 Yakutat, Alaska, US
1214 1214 2105 Hoonah-Angoon Alaska US 3/22/20 23:45 58.29307365 -135.6424424 0 0 0 0 Hoonah-Angoon, Alaska, US
1213 1213 2100 Haines Alaska US 3/22/20 23:45 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
1227 1227 2230 Skagway Alaska US 3/22/20 23:45 59.56149996 -135.3337748 0 0 0 0 Skagway, Alaska, US
1226 1226 2220 Sitka Alaska US 3/22/20 23:45 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
1215 1215 2110 Juneau Alaska US 3/22/20 23:45 58.45031811 -134.200436 0 0 0 0 Juneau, Alaska, US
1225 1225 2198 Prince of Wales-Hyder Alaska US 3/22/20 23:45 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
1224 1224 2195 Petersburg Alaska US 3/22/20 23:45 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
1230 1230 2275 Wrangell Alaska US 3/22/20 23:45 56.3202004 -132.0583731 0 0 0 0 Wrangell, Alaska, US
1147 1147 2130 Ketchikan Gateway Alaska US 3/22/20 23:45 55.57445008 -130.975561 6 0 0 0 Ketchikan Gateway, Alaska, US
3178 3178     British Columbia Canada 3/22/20 23:48 53.7267 -127.6476 424 10 0 0 British Columbia, Canada
2572 2572 41015 Curry Oregon US 3/22/20 23:45 42.45911325 -124.157282 0 0 0 0 Curry, Oregon, US
2570 2570 41011 Coos Oregon US 3/22/20 23:45 43.17406868 -124.0594514 0 0 0 0 Coos, Oregon, US
63 63 53009 Clallam Washington US 3/22/20 23:45 48.04754642 -123.9226319 4 0 0 0 Clallam, Washington, US
1287 1287 6015 Del Norte California US 3/22/20 23:45 41.74228275 -123.8974063 0 0 0 0 Del Norte, California, US
127 127 6023 Humboldt California US 3/22/20 23:45 40.69923009 -123.876044 2 0 0 0 Humboldt, California, US
2578 2578 41041 Lincoln Oregon US 3/22/20 23:45 44.64252874 -123.869912 0 0 0 0 Lincoln, Oregon, US
68 68 53027 Grays Harbor Washington US 3/22/20 23:45 47.14003705 -123.7820567 1 0 0 0 Grays Harbor, Washington, US
3065 3065 53049 Pacific Washington US 3/22/20 23:45 46.55418369 -123.7285716 0 0 0 0 Pacific, Washington, US
2582 2582 41057 Tillamook Oregon US 3/22/20 23:45 45.46248721 -123.712066 0 0 0 0 Tillamook, Oregon, US
2568 2568 41007 Clatsop Oregon US 3/22/20 23:45 45.99712889 -123.660711 0 0 0 0 Clatsop, Oregon, US
60 60 53031 Jefferson Washington US 3/22/20 23:45 47.75003077 -123.5609704 6 0 0 0 Jefferson, Washington, US
918 918 41033 Josephine Oregon US 3/22/20 23:45 42.3665549 -123.5561938 1 0 0 0 Josephine, Oregon, US
909 909 41003 Benton Oregon US 3/22/20 23:45 44.49167306 -123.4316987 4 0 0 0 Benton, Oregon, US
3068 3068 53069 Wahkiakum Washington US 3/22/20 23:45 46.2918004 -123.4250831 0 0 0 0 Wahkiakum, Washington, US
915 915 41053 Polk Oregon US 3/22/20 23:45 44.90322804 -123.4128888 1 0 0 0 Polk, Oregon, US
133 133 6045 Mendocino California US 3/22/20 23:45 39.4381191 -123.3911313 1 0 0 0 Mendocino, California, US
908 908 41071 Yamhill Oregon US 3/22/20 23:45 45.23330449 -123.3086963 6 0 0 0 Yamhill, Oregon, US
71 71 53045 Mason Washington US 3/22/20 23:45 47.35007586 -123.1863685 1 0 0 0 Mason, Washington, US
914 914 41019 Douglas Oregon US 3/22/20 23:45 43.27941273 -123.167291 1 0 0 0 Douglas, Oregon, US
1301 1301 6105 Trinity California US 3/22/20 23:45 40.6491767 -123.114713 0 0 0 0 Trinity, California, US
902 902 41067 Washington Oregon US 3/22/20 23:45 45.55972701 -123.0955257 55 1 0 0 Washington, Oregon, US
2569 2569 41009 Columbia Oregon US 3/22/20 23:45 45.94464254 -123.0890898 0 0 0 0 Columbia, Oregon, US
74 74 53055 San Juan Washington US 3/22/20 23:45 48.60182783 -122.96745 1 0 0 0 San Juan, Washington, US
112 112 6097 Sonoma California US 3/22/20 23:45 38.52746429 -122.8862506 22 1 0 0 Sonoma, California, US
910 910 41039 Lane Oregon US 3/22/20 23:45 43.93727035 -122.847753 4 1 0 0 Lane, Oregon, US
57 57 53067 Thurston Washington US 3/22/20 23:45 46.9291895 -122.8290656 11 0 0 0 Thurston, Washington, US
1292 1292 6033 Lake California US 3/22/20 23:45 39.10124298 -122.7536244 0 0 0 0 Lake, California, US
911 911 41029 Jackson Oregon US 3/22/20 23:45 42.43201126 -122.7289309 2 0 0 0 Jackson, Oregon, US
107 107 6041 Marin California US 3/22/20 23:45 38.07122463 -122.7210631 38 0 0 0 Marin, California, US
64 64 53015 Cowlitz Washington US 3/22/20 23:45 46.19074721 -122.6782231 3 0 0 0 Cowlitz, Washington, US
54 54 53035 Kitsap Washington US 3/22/20 23:45 47.63479026 -122.6436061 18 0 0 0 Kitsap, Washington, US
903 903 41047 Marion Oregon US 3/22/20 23:45 44.90287942 -122.5815117 22 1 0 0 Marion, Oregon, US
129 129 6093 Siskiyou California US 3/22/20 23:45 41.59198861 -122.5407434 2 0 0 0 Siskiyou, California, US
905 905 41043 Linn Oregon US 3/22/20 23:45 44.48899494 -122.5373154 19 1 0 0 Linn, Oregon, US
51 51 53029 Island Washington US 3/22/20 23:45 48.14713305 -122.5216407 21 1 0 0 Island, Washington, US
58 58 53011 Clark Washington US 3/22/20 23:45 45.77568046 -122.4829204 10 3 0 0 Clark, Washington, US
102 102 6075 San Francisco California US 3/22/20 23:45 37.75215114 -122.4385672 108 0 0 0 San Francisco, California, US
904 904 41051 Multnomah Oregon US 3/22/20 23:45 45.54747959 -122.4169351 19 1 0 0 Multnomah, Oregon, US
1289 1289 6021 Glenn California US 3/22/20 23:45 39.59875897 -122.3938452 0 0 0 0 Glenn, California, US
67 67 53041 Lewis Washington US 3/22/20 23:45 46.57756476 -122.3925769 2 0 0 0 Lewis, Washington, US
137 137 6055 Napa California US 3/22/20 23:45 38.50735751 -122.332839 1 0 0 0 Napa, California, US
101 101 6081 San Mateo California US 3/22/20 23:45 37.4228808 -122.3275546 117 1 0 0 San Mateo, California, US
1300 1300 6103 Tehama California US 3/22/20 23:45 40.12570935 -122.2370171 0 0 0 0 Tehama, California, US
1286 1286 6011 Colusa California US 3/22/20 23:45 39.17881957 -122.2331726 0 0 0 0 Colusa, California, US
906 906 41005 Clackamas Oregon US 3/22/20 23:45 45.18787398 -122.2179634 12 0 0 0 Clackamas, Oregon, US
49 49 53053 Pierce Washington US 3/22/20 23:45 47.03892768 -122.1405958 107 1 0 0 Pierce, Washington, US
131 131 6089 Shasta California US 3/22/20 23:45 40.76391419 -122.0396884 1 0 0 0 Shasta, California, US
114 114 6087 Santa Cruz California US 3/22/20 23:45 37.05580291 -122.0066524 15 0 0 0 Santa Cruz, California, US
115 115 6095 Solano California US 3/22/20 23:45 38.26827353 -121.9357113 13 0 0 0 Solano, California, US
105 105 6013 Contra Costa California US 3/22/20 23:45 37.91923498 -121.9289527 61 1 0 0 Contra Costa, California, US
3067 3067 53059 Skamania Washington US 3/22/20 23:45 46.02408726 -121.9164403 0 0 0 0 Skamania, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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