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
3164 3164 6115 Yuba California US 3/28/20 23:05 39.26255932 -121.3535644 3 0 0 0 Yuba, California, US
2491 2491 6067 Sacramento California US 3/28/20 23:05 38.45106826 -121.3425374 164 6 0 0 Sacramento, California, US
2511 2511 6077 San Joaquin California US 3/28/20 23:05 37.93433732 -121.2730061 93 4 0 0 San Joaquin, California, US
1976 1976 6053 Monterey California US 3/28/20 23:05 36.21862405 -121.2413397 32 1 0 0 Monterey, California, US
772 772 41017 Deschutes Oregon US 3/28/20 23:05 43.91570171 -121.2289121 20 0 0 0 Deschutes, Oregon, US
1419 1419 41031 Jefferson Oregon US 3/28/20 23:05 44.62806839 -121.17832 0 0 0 0 Jefferson, Oregon, US
2974 2974 41065 Wasco Oregon US 3/28/20 23:05 45.16292781 -121.1670954 2 0 0 0 Wasco, Oregon, US
2506 2506 6069 San Benito California US 3/28/20 23:05 36.60308176 -121.069975 14 1 0 0 San Benito, California, US
2681 2681 6099 Stanislaus California US 3/28/20 23:05 37.55862499 -120.9970722 23 0 0 0 Stanislaus, California, US
2294 2294 6063 Plumas California US 3/28/20 23:05 40.00355989 -120.8395236 0 0 0 0 Plumas, California, US
1525 1525 53039 Klickitat Washington US 3/28/20 23:05 45.87325839 -120.7913598 7 0 0 0 Klickitat, Washington, US
2060 2060 6057 Nevada California US 3/28/20 23:05 39.30394768 -120.7627281 12 0 0 0 Nevada, California, US
3144 3144 53077 Yakima Washington US 3/28/20 23:05 46.45738486 -120.7380126 82 2 0 0 Yakima, Washington, US
1949 1949 6049 Modoc California US 3/28/20 23:05 41.58965602 -120.7244817 0 0 0 0 Modoc, California, US
2288 2288 6061 Placer California US 3/28/20 23:05 39.06167234 -120.7240569 41 1 0 0 Placer, California, US
1897 1897 6047 Merced California US 3/28/20 23:05 37.18922369 -120.7209035 7 0 0 0 Merced, California, US
2610 2610 41055 Sherman Oregon US 3/28/20 23:05 45.41501554 -120.6827834 0 0 0 0 Sherman, Oregon, US
1521 1521 53037 Kittitas Washington US 3/28/20 23:05 47.12521214 -120.679439 8 0 0 0 Kittitas, Washington, US
55 55 6005 Amador California US 3/28/20 23:05 38.44583082 -120.65696 2 0 0 0 Amador, California, US
469 469 53007 Chelan Washington US 3/28/20 23:05 47.87046092 -120.6173956 13 1 0 0 Chelan, Washington, US
1597 1597 6035 Lassen California US 3/28/20 23:05 40.67311306 -120.5935099 0 0 0 0 Lassen, California, US
340 340 6009 Calaveras California US 3/28/20 23:05 38.20537103 -120.552913 3 0 0 0 Calaveras, California, US
859 859 6017 El Dorado California US 3/28/20 23:05 38.77965956 -120.5233166 12 0 0 0 El Dorado, California, US
2615 2615 6091 Sierra California US 3/28/20 23:05 39.57713498 -120.5200701 0 0 0 0 Sierra, California, US
2516 2516 6079 San Luis Obispo California US 3/28/20 23:05 35.38822029 -120.4039028 67 0 0 0 San Luis Obispo, California, US
1571 1571 41037 Lake Oregon US 3/28/20 23:05 42.79246693 -120.3850163 0 0 0 0 Lake, Oregon, US
674 674 41013 Crook Oregon US 3/28/20 23:05 44.14230227 -120.356297 0 0 0 0 Crook, Oregon, US
1043 1043 41021 Gilliam Oregon US 3/28/20 23:05 45.37160076 -120.2048869 0 0 0 0 Gilliam, Oregon, US
3062 3062 41069 Wheeler Oregon US 3/28/20 23:05 44.72698162 -120.0281427 0 0 0 0 Wheeler, Oregon, US
2529 2529 6083 Santa Barbara California US 3/28/20 23:05 34.65329488 -120.0188492 47 0 0 0 Santa Barbara, California, US
2841 2841 6109 Tuolumne California US 3/28/20 23:05 38.02644018 -119.9525093 0 0 0 0 Tuolumne, California, US
1809 1809 6043 Mariposa California US 3/28/20 23:05 37.57978556 -119.9073334 0 0 0 0 Mariposa, California, US
54 54 6003 Alpine California US 3/28/20 23:05 38.59678594 -119.8223594 0 0 0 0 Alpine, California, US
1512 1512 6031 Kings California US 3/28/20 23:05 36.07409056 -119.8159973 2 0 0 0 Kings, California, US
1754 1754 6039 Madera California US 3/28/20 23:05 37.21513971 -119.7665589 11 1 0 0 Madera, California, US
408 408 32510 Carson City Nevada US 3/28/20 23:05 39.15509045 -119.7480219 5 0 0 0 Carson City, Nevada, US
2126 2126 53047 Okanogan Washington US 3/28/20 23:05 48.54855019 -119.7387224 3 0 0 0 Okanogan, Washington, US
817 817 53017 Douglas Washington US 3/28/20 23:05 47.7361335 -119.692937 5 0 0 0 Douglas, Washington, US
3010 3010 32031 Washoe Nevada US 3/28/20 23:05 40.66562265 -119.6631594 75 0 0 0 Washoe, Nevada, US
991 991 6019 Fresno California US 3/28/20 23:05 36.75733899 -119.6466953 31 0 0 0 Fresno, California, US
814 814 32005 Douglas Nevada US 3/28/20 23:05 38.912862 -119.6171333 5 0 0 0 Douglas, Nevada, US
2022 2022 41049 Morrow Oregon US 3/28/20 23:05 45.41846568 -119.584546 1 0 0 0 Morrow, Oregon, US
2715 2715 32029 Storey Nevada US 3/28/20 23:05 39.44875482 -119.5250207 0 0 0 0 Storey, Nevada, US
189 189 53005 Benton Washington US 3/28/20 23:05 46.23946995 -119.5120834 42 5 0 0 Benton, Washington, US
1093 1093 53025 Grant Washington US 3/28/20 23:05 47.20753737 -119.4500749 44 1 0 0 Grant, Washington, US
1744 1744 32019 Lyon Nevada US 3/28/20 23:05 39.01777974 -119.1870479 1 0 0 0 Lyon, Nevada, US
2918 2918 6111 Ventura California US 3/28/20 23:05 34.44465746 -119.0910613 83 3 0 0 Ventura, California, US
1091 1091 41023 Grant Oregon US 3/28/20 23:05 44.49024544 -119.0068631 1 0 0 0 Grant, Oregon, US
1208 1208 41025 Harney Oregon US 3/28/20 23:05 43.06422669 -118.9666306 0 0 0 0 Harney, Oregon, US
980 980 53021 Franklin Washington US 3/28/20 23:05 46.53351425 -118.9018212 12 0 0 0 Franklin, Washington, US
1954 1954 6051 Mono California US 3/28/20 23:05 37.93899289 -118.8872409 8 0 0 0 Mono, California, US
2838 2838 6107 Tulare California US 3/28/20 23:05 36.22026558 -118.8020203 24 0 0 0 Tulare, California, US
2855 2855 41059 Umatilla Oregon US 3/28/20 23:05 45.59073056 -118.7353826 4 0 0 0 Umatilla, Oregon, US
1495 1495 6029 Kern California US 3/28/20 23:05 35.34329425 -118.7277796 47 1 0 0 Kern, California, US
19 19 53001 Adams Washington US 3/28/20 23:05 46.98299757 -118.5601734 5 0 0 0 Adams, Washington, US
927 927 53019 Ferry Washington US 3/28/20 23:05 48.4711431 -118.5154041 1 0 0 0 Ferry, Washington, US
2944 2944 53071 Walla Walla Washington US 3/28/20 23:05 46.23040051 -118.4775539 4 0 0 0 Walla Walla, Washington, US
1934 1934 32021 Mineral Nevada US 3/28/20 23:05 38.53841696 -118.4344506 0 0 0 0 Mineral, Nevada, US
1684 1684 53043 Lincoln Washington US 3/28/20 23:05 47.57705241 -118.4194388 1 0 0 0 Lincoln, Washington, US
2243 2243 32027 Pershing Nevada US 3/28/20 23:05 40.44003782 -118.4005641 0 0 0 0 Pershing, Nevada, US
509 509 32001 Churchill Nevada US 3/28/20 23:05 39.58105744 -118.3394607 0 0 0 0 Churchill, Nevada, US
1717 1717 6037 Los Angeles California US 3/28/20 23:05 34.30828379 -118.2282411 1465 26 0 0 Los Angeles, California, US
1320 1320 32013 Humboldt Nevada US 3/28/20 23:05 41.40692186 -118.1109427 1 0 0 0 Humboldt, Nevada, US
2892 2892 41061 Union Oregon US 3/28/20 23:05 45.30915495 -118.0068979 1 0 0 0 Union, Oregon, US
612 612 53013 Columbia Washington US 3/28/20 23:05 46.29442881 -117.9051983 1 0 0 0 Columbia, Washington, US
2705 2705 53065 Stevens Washington US 3/28/20 23:05 48.40035475 -117.8542701 3 0 0 0 Stevens, Washington, US
2143 2143 6059 Orange California US 3/28/20 23:05 33.70147516 -117.7645998 403 4 0 0 Orange, California, US
119 119 41001 Baker Oregon US 3/28/20 23:05 44.70915557 -117.6749883 0 0 0 0 Baker, Oregon, US
887 887 32009 Esmeralda Nevada US 3/28/20 23:05 37.78436681 -117.6319999 0 0 0 0 Esmeralda, Nevada, US
1780 1780 41045 Malheur Oregon US 3/28/20 23:05 43.1937027 -117.6227395 0 0 0 0 Malheur, Oregon, US
1018 1018 53023 Garfield Washington US 3/28/20 23:05 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
3074 3074 53075 Whitman Washington US 3/28/20 23:05 46.90022523 -117.5241763 6 0 0 0 Whitman, Washington, US
1342 1342 6027 Inyo California US 3/28/20 23:05 36.51112084 -117.4111978 5 0 0 0 Inyo, California, US
2651 2651 53063 Spokane Washington US 3/28/20 23:05 47.62113146 -117.4046494 108 2 0 0 Spokane, Washington, US
2221 2221 53051 Pend Oreille Washington US 3/28/20 23:05 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
95 95 53003 Asotin Washington US 3/28/20 23:05 46.18894415 -117.2022851 0 0 0 0 Asotin, Washington, US
2947 2947 41063 Wallowa Oregon US 3/28/20 23:05 45.57894064 -117.183538 0 0 0 0 Wallowa, Oregon, US
1587 1587 32015 Lander Nevada US 3/28/20 23:05 39.9332233 -117.0397075 0 0 0 0 Lander, Nevada, US
2983 2983 16087 Washington Idaho US 3/28/20 23:05 44.45275475 -116.7847688 0 0 0 0 Washington, Idaho, US
2214 2214 16075 Payette Idaho US 3/28/20 23:05 44.00545243 -116.7647695 1 0 0 0 Payette, Idaho, US
2078 2078 16069 Nez Perce Idaho US 3/28/20 23:05 46.32638236 -116.7500975 4 1 0 0 Nez Perce, Idaho, US
2508 2508 6073 San Diego California US 3/28/20 23:05 33.03484597 -116.7365326 413 6 0 0 San Diego, California, US
1598 1598 16057 Latah Idaho US 3/28/20 23:05 46.81587887 -116.7113698 0 0 0 0 Latah, Idaho, US
382 382 16027 Canyon Idaho US 3/28/20 23:05 43.61970148 -116.7095499 23 1 0 0 Canyon, Idaho, US
1538 1538 16055 Kootenai Idaho US 3/28/20 23:05 47.67282258 -116.7020872 11 0 0 0 Kootenai, Idaho, US
176 176 16009 Benewah Idaho US 3/28/20 23:05 47.21754179 -116.6586851 0 0 0 0 Benewah, Idaho, US
230 230 16017 Bonner Idaho US 3/28/20 23:05 48.29996017 -116.6017932 0 0 0 0 Bonner, Idaho, US
3171 3171     Alberta Canada 3/28/20 23:10 53.9333 -116.5765 542 2 0 0 Alberta, Canada
2108 2108 32023 Nye Nevada US 3/28/20 23:05 38.04264256 -116.4722702 1 0 0 0 Nye, Nevada, US
246 246 16021 Boundary Idaho US 3/28/20 23:05 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
10 10 16003 Adams Idaho US 3/28/20 23:05 44.89333571 -116.4545247 0 0 0 0 Adams, Idaho, US
1647 1647 16061 Lewis Idaho US 3/28/20 23:05 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1029 1029 16045 Gem Idaho US 3/28/20 23:05 44.06482372 -116.398376 1 0 0 0 Gem, Idaho, US
895 895 32011 Eureka Nevada US 3/28/20 23:05 39.98100864 -116.2683204 0 0 0 0 Eureka, Nevada, US
4 4 16001 Ada Idaho US 3/28/20 23:05 43.4526575 -116.2415516 76 0 0 0 Ada, Idaho, US
2507 2507 6071 San Bernardino California US 3/28/20 23:05 34.84060306 -116.1774685 76 3 0 0 San Bernardino, California, US
2186 2186 16073 Owyhee Idaho US 3/28/20 23:05 42.58016894 -116.1693871 0 0 0 0 Owyhee, Idaho, US
2440 2440 6065 Riverside California US 3/28/20 23:05 33.74314981 -115.9933578 183 8 0 0 Riverside, California, US
2613 2613 16079 Shoshone Idaho US 3/28/20 23:05 47.35364087 -115.8916749 0 0 0 0 Shoshone, Idaho, US
225 225 16015 Boise Idaho US 3/28/20 23:05 43.98829931 -115.7309284 0 0 0 0 Boise, Idaho, 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
);