04-01-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

2,486 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
1289 1289   McIntosh Georgia US 2020-04-01 21:58:49     1 0 0 0 McIntosh,Georgia,US
2449 2449       Samoa 2020-04-01 22:04:44 -13.759 -172.1046 0 0 0 0 Samoa
1021 1021 15007 Kauai Hawaii US 2020-04-01 21:58:49 22.03935037 -159.5966786 12 0 0 0 Kauai, Hawaii, US
890 890 15003 Honolulu Hawaii US 2020-04-01 21:58:49 21.45803166 -157.97121819999995 157 0 0 0 Honolulu, Hawaii, US
1276 1276 15009 Maui Hawaii US 2020-04-01 21:58:49 20.86399628 -156.56890969999995 25 0 0 0 Maui, Hawaii, US
851 851 15001 Hawaii Hawaii US 2020-04-01 21:58:49 19.60121157 -155.5210167 15 0 0 0 Hawaii, Hawaii, US
1026 1026   Kenai Peninsula Alaska US 2020-04-01 21:58:49 60.24429722 -151.53888840000005 7 0 0 0 Kenai Peninsula,Alaska,US
1274 1274   Matanuska-Susitna Alaska US 2020-04-01 21:58:49 62.31305045 -149.5741743 3 0 0 0 Matanuska-Susitna,Alaska,US
2239 2239     French Polynesia France 2020-04-01 21:58:34 -17.6797 -149.4068 37 0 0 37 French Polynesia, France
43 43 2020 Anchorage Alaska US 2020-04-01 21:58:49 61.14998174 -149.14269860000005 65 1 0 0 Anchorage,Alaska,US
639 639 2090 Fairbanks North Star Alaska US 2020-04-01 21:58:49 64.80726247 -146.5692662 35 0 0 0 Fairbanks North Star,Alaska,US
2307 2307     Yukon Canada 2020-04-01 22:04:44 64.2823 -135.0 5 0 0 0 ,Yukon,Canada
1010 1010 2110 Juneau Alaska US 2020-04-01 21:58:49 58.45031811 -134.200436 9 0 0 0 Juneau, Alaska, US
1040 1040 2130 Ketchikan Gateway Alaska US 2020-04-01 21:58:49 55.57445008 -130.975561 13 0 0 0 Ketchikan Gateway, Alaska, US
2229 2229     British Columbia Canada 2020-04-01 22:04:44 53.7267 -127.6476 1013 24 0 0 British Columbia, Canada
2276 2276     Northwest Territories Canada 2020-04-01 22:04:44 64.8255 -124.8457 2 0 0 0 ,Northwest Territories,Canada
379 379 53009 Clallam Washington US 2020-04-01 21:58:49 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
908 908 6023 Humboldt California US 2020-04-01 21:58:49 40.69923009 -123.876044 27 0 0 0 Humboldt, California, US
1162 1162 41041 Lincoln Oregon US 2020-04-01 21:58:49 44.64252874 -123.86991200000001 3 0 0 0 Lincoln, Oregon, US
774 774 53027 Grays Harbor Washington US 2020-04-01 21:58:49 47.14003705 -123.7820567 2 0 0 0 Grays Harbor, Washington, US
1935 1935 41057 Tillamook Oregon US 2020-04-01 21:58:49 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
394 394 41007 Clatsop Oregon US 2020-04-01 21:58:49 45.99712889 -123.660711 3 0 0 0 Clatsop, Oregon, US
987 987 53031 Jefferson Washington US 2020-04-01 21:58:49 47.75003077 -123.56097040000002 17 0 0 0 Jefferson, Washington, US
1009 1009 41033 Josephine Oregon US 2020-04-01 21:58:49 42.3665549 -123.5561938 10 0 0 0 Josephine, Oregon, US
134 134 41003 Benton Oregon US 2020-04-01 21:58:49 44.49167306 -123.4316987 13 1 0 0 Benton, Oregon, US
1601 1601 41053 Polk Oregon US 2020-04-01 21:58:49 44.90322804 -123.4128888 18 0 0 0 Polk, Oregon, US
1311 1311 6045 Mendocino California US 2020-04-01 21:58:49 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2206 2206 41071 Yamhill Oregon US 2020-04-01 21:58:49 45.23330449 -123.3086963 17 3 0 0 Yamhill, Oregon, US
1271 1271 53045 Mason Washington US 2020-04-01 21:58:49 47.35007586 -123.1863685 6 0 0 0 Mason, Washington, US
587 587 41019 Douglas Oregon US 2020-04-01 21:58:49 43.27941273 -123.16729099999999 10 0 0 0 Douglas, Oregon, US
2098 2098 41067 Washington Oregon US 2020-04-01 21:58:49 45.55972701 -123.0955257 189 3 0 0 Washington, Oregon, US
447 447 41009 Columbia Oregon US 2020-04-01 21:58:49 45.94464254 -123.08908980000001 1 0 0 0 Columbia, Oregon, US
1733 1733 53055 San Juan Washington US 2020-04-01 21:58:49 48.60182783 -122.96745 4 0 0 0 San Juan, Washington, US
1820 1820 6097 Sonoma California US 2020-04-01 21:58:49 38.52746429 -122.88625060000001 78 2 0 0 Sonoma, California, US
1093 1093 41039 Lane Oregon US 2020-04-01 21:58:49 43.93727035 -122.847753 18 1 0 0 Lane, Oregon, US
1933 1933 53067 Thurston Washington US 2020-04-01 21:58:49 46.9291895 -122.82906559999999 48 0 0 0 Thurston, Washington, US
957 957 41029 Jackson Oregon US 2020-04-01 21:58:49 42.43201126 -122.72893090000001 22 0 0 0 Jackson, Oregon, US
1240 1240 6041 Marin California US 2020-04-01 21:58:49 38.07122463 -122.72106310000001 107 4 0 0 Marin, California, US
476 476 53015 Cowlitz Washington US 2020-04-01 21:58:49 46.19074721 -122.6782231 14 0 0 0 Cowlitz, Washington, US
1049 1049 53035 Kitsap Washington US 2020-04-01 21:58:49 47.63479026 -122.6436061 74 0 0 0 Kitsap, Washington, US
1249 1249 41047 Marion Oregon US 2020-04-01 21:58:49 44.90287942 -122.58151170000001 151 3 0 0 Marion, Oregon, US
1805 1805 6093 Siskiyou California US 2020-04-01 21:58:49 41.59198861 -122.54074340000001 3 0 0 0 Siskiyou, California, US
1168 1168 41043 Linn Oregon US 2020-04-01 21:58:49 44.48899494 -122.53731540000001 37 2 0 0 Linn, Oregon, US
939 939 53029 Island Washington US 2020-04-01 21:58:49 48.14713305 -122.5216407 109 4 0 0 Island, Washington, US
390 390 53011 Clark Washington US 2020-04-01 21:58:49 45.77568046 -122.48292040000001 130 7 0 0 Clark, Washington, US
1728 1728 6075 San Francisco California US 2020-04-01 21:58:49 37.75215114 -122.43856720000001 434 7 0 0 San Francisco, California, US
1406 1406 41051 Multnomah Oregon US 2020-04-01 21:58:49 45.54747959 -122.4169351 134 3 0 0 Multnomah, Oregon, US
743 743 6021 Glenn California US 2020-04-01 21:58:49 39.59875897 -122.3938452 2 0 0 0 Glenn, California, US
1140 1140 53041 Lewis Washington US 2020-04-01 21:58:49 46.57756476 -122.39257690000001 10 0 0 0 Lewis, Washington, US
1415 1415 6055 Napa California US 2020-04-01 21:58:49 38.50735751 -122.33283899999999 15 0 0 0 Napa, California, US
1735 1735 6081 San Mateo California US 2020-04-01 21:58:49 37.422880799999994 -122.32755459999998 388 10 0 0 San Mateo, California, US
453 453 6011 Colusa California US 2020-04-01 21:58:49 39.17881957 -122.2331726 1 0 0 0 Colusa, California, US
375 375 41005 Clackamas Oregon US 2020-04-01 21:58:49 45.18787398 -122.2179634 56 3 0 0 Clackamas, Oregon, US
1571 1571 53053 Pierce Washington US 2020-04-01 21:58:49 47.03892768 -122.14059579999999 377 8 0 0 Pierce, Washington, US
1784 1784 6089 Shasta California US 2020-04-01 21:58:49 40.76391419 -122.0396884 7 1 0 0 Shasta, California, US
1746 1746 6087 Santa Cruz California US 2020-04-01 21:58:49 37.05580291 -122.0066524 49 1 0 0 Santa Cruz, California, US
1815 1815 6095 Solano California US 2020-04-01 21:58:49 38.26827353 -121.9357113 49 0 0 0 Solano, California, US
458 458 6013 Contra Costa California US 2020-04-01 21:58:49 37.91923498 -121.9289527 249 3 0 0 Contra Costa, California, US
1807 1807 53059 Skamania Washington US 2020-04-01 21:58:49 46.02408726 -121.91644029999999 1 0 0 0 Skamania, Washington, US
2212 2212 6113 Yolo California US 2020-04-01 21:58:49 38.68278902 -121.90182879999999 25 1 0 0 Yolo, California, US
19 19 6001 Alameda California US 2020-04-01 21:58:49 37.64629437 -121.8929271 313 7 0 0 Alameda, California, US
1042 1042 53033 King Washington US 2020-04-01 21:58:49 47.49137892 -121.8346131 2330 193 0 0 King, Washington, US
1806 1806 53057 Skagit Washington US 2020-04-01 21:58:49 48.48171488 -121.766131 128 4 0 0 Skagit, Washington, US
2140 2140 53073 Whatcom Washington US 2020-04-01 21:58:49 48.82227976 -121.74900179999999 139 11 0 0 Whatcom, Washington, US
1812 1812 53061 Snohomish Washington US 2020-04-01 21:58:49 48.04615983 -121.7170703 1304 47 0 0 Snohomish, Washington, US
1744 1744 6085 Santa Clara California US 2020-04-01 21:58:49 37.23104908 -121.6970462 956 32 0 0 Santa Clara, California, US
1901 1901 6101 Sutter California US 2020-04-01 21:58:49 39.03417539 -121.6945899 10 0 0 0 Sutter, California, US
892 892 41027 Hood River Oregon US 2020-04-01 21:58:49 45.51872811 -121.65520359999998 2 0 0 0 Hood River, Oregon, US
1051 1051 41035 Klamath Oregon US 2020-04-01 21:58:49 42.68762984 -121.64964609999998 5 0 0 0 Klamath, Oregon, US
236 236 6007 Butte California US 2020-04-01 21:58:49 39.66727762 -121.6005252 8 0 0 0 Butte, California, US
2219 2219 6115 Yuba California US 2020-04-01 21:58:49 39.26255932 -121.35356440000001 7 0 0 0 Yuba, California, US
1713 1713 6067 Sacramento California US 2020-04-01 21:58:49 38.45106826 -121.34253740000001 224 7 0 0 Sacramento, California, US
1730 1730 6077 San Joaquin California US 2020-04-01 21:58:49 37.93433732 -121.2730061 151 8 0 0 San Joaquin, California, US
1366 1366 6053 Monterey California US 2020-04-01 21:58:49 36.21862405 -121.24133970000001 42 1 0 0 Monterey, California, US
559 559 41017 Deschutes Oregon US 2020-04-01 21:58:49 43.91570171 -121.2289121 27 0 0 0 Deschutes, Oregon, US
2077 2077 41065 Wasco Oregon US 2020-04-01 21:58:49 45.16292781 -121.16709540000001 7 0 0 0 Wasco, Oregon, US
1725 1725 6069 San Benito California US 2020-04-01 21:58:49 36.60308176 -121.069975 21 1 0 0 San Benito, California, US
1854 1854 6099 Stanislaus California US 2020-04-01 21:58:49 37.55862499 -120.9970722 44 0 0 0 Stanislaus, California, US
1592 1592 6063 Plumas California US 2020-04-01 21:58:49 40.00355989 -120.8395236 1 0 0 0 Plumas, California, US
1053 1053 53039 Klickitat Washington US 2020-04-01 21:58:49 45.87325839 -120.7913598 9 1 0 0 Klickitat, Washington, US
1429 1429 6057 Nevada California US 2020-04-01 21:58:49 39.30394768 -120.76272809999999 26 0 0 0 Nevada, California, US
2204 2204 53077 Yakima Washington US 2020-04-01 21:58:49 46.45738486 -120.73801259999999 161 10 0 0 Yakima, Washington, US
1587 1587 6061 Placer California US 2020-04-01 21:58:49 39.06167234 -120.72405690000001 78 2 0 0 Placer, California, US
1313 1313 6047 Merced California US 2020-04-01 21:58:49 37.18922369 -120.72090349999999 10 0 0 0 Merced, California, US
1050 1050 53037 Kittitas Washington US 2020-04-01 21:58:49 47.12521214 -120.67943899999999 9 0 0 0 Kittitas, Washington, US
39 39 6005 Amador California US 2020-04-01 21:58:49 38.44583082 -120.65696000000001 2 0 0 0 Amador, California, US
344 344 53007 Chelan Washington US 2020-04-01 21:58:49 47.87046092 -120.6173956 17 2 0 0 Chelan, Washington, US
244 244 6009 Calaveras California US 2020-04-01 21:58:49 38.20537103 -120.55291299999999 3 0 0 0 Calaveras, California, US
617 617 6017 El Dorado California US 2020-04-01 21:58:49 38.77965956 -120.5233166 18 0 0 0 El Dorado, California, US
1734 1734 6079 San Luis Obispo California US 2020-04-01 21:58:49 35.38822029 -120.4039028 80 0 0 0 San Luis Obispo, California, US
1743 1743 6083 Santa Barbara California US 2020-04-01 21:58:49 34.65329488 -120.0188492 99 0 0 0 Santa Barbara, California, US
1961 1961 6109 Tuolumne California US 2020-04-01 21:58:49 38.02644018 -119.95250929999999 2 0 0 0 Tuolumne, California, US
38 38 6003 Alpine California US 2020-04-01 21:58:49 38.59678594 -119.82235940000001 1 0 0 0 Alpine, California, US
1046 1046 6031 Kings California US 2020-04-01 21:58:49 36.07409056 -119.8159973 4 0 0 0 Kings, California, US
1212 1212 6039 Madera California US 2020-04-01 21:58:49 37.21513971 -119.76655890000002 23 1 0 0 Madera, California, US
294 294 32510 Carson City Nevada US 2020-04-01 21:58:49 39.15509045 -119.7480219 5 0 0 0 Carson City, Nevada, US
1477 1477 53047 Okanogan Washington US 2020-04-01 21:58:49 48.54855019 -119.73872240000001 3 0 0 0 Okanogan, Washington, US
588 588 53017 Douglas Washington US 2020-04-01 21:58:49 47.7361335 -119.69293700000001 5 0 0 0 Douglas, Washington, US
2107 2107 32031 Washoe Nevada US 2020-04-01 21:58:49 40.66562265 -119.6631594 143 3 0 0 Washoe, Nevada, US
710 710 6019 Fresno California US 2020-04-01 21:58:49 36.75733899 -119.6466953 68 0 0 0 Fresno, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-01-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
);