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)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
331 331 6007 Butte California US 2020-03-27 22:14:55 39.66727762 -121.6005252 5 0 0 0 Butte, California, US
3167 3167 6115 Yuba California US 2020-03-27 22:14:55 39.26255932 -121.35356440000001 3 0 0 0 Yuba, California, US
2491 2491 6067 Sacramento California US 2020-03-27 22:14:55 38.45106826 -121.34253740000001 164 6 0 0 Sacramento, California, US
2511 2511 6077 San Joaquin California US 2020-03-27 22:14:55 37.93433732 -121.2730061 90 3 0 0 San Joaquin, California, US
1976 1976 6053 Monterey California US 2020-03-27 22:14:55 36.21862405 -121.24133970000001 24 1 0 0 Monterey, California, US
772 772 41017 Deschutes Oregon US 2020-03-27 22:14:55 43.91570171 -121.2289121 18 0 0 0 Deschutes, Oregon, US
1419 1419 41031 Jefferson Oregon US 2020-03-27 22:14:55 44.62806839 -121.17832 0 0 0 0 Jefferson, Oregon, US
2977 2977 41065 Wasco Oregon US 2020-03-27 22:14:55 45.16292781 -121.16709540000001 2 0 0 0 Wasco, Oregon, US
2506 2506 6069 San Benito California US 2020-03-27 22:14:55 36.60308176 -121.069975 13 1 0 0 San Benito, California, US
2681 2681 6099 Stanislaus California US 2020-03-27 22:14:55 37.55862499 -120.9970722 17 0 0 0 Stanislaus, California, US
2294 2294 6063 Plumas California US 2020-03-27 22:14:55 40.00355989 -120.8395236 0 0 0 0 Plumas, California, US
1525 1525 53039 Klickitat Washington US 2020-03-27 22:14:55 45.87325839 -120.7913598 7 0 0 0 Klickitat, Washington, US
2060 2060 6057 Nevada California US 2020-03-27 22:14:55 39.30394768 -120.76272809999999 8 0 0 0 Nevada, California, US
3147 3147 53077 Yakima Washington US 2020-03-27 22:14:55 46.45738486 -120.73801259999999 66 2 0 0 Yakima, Washington, US
1949 1949 6049 Modoc California US 2020-03-27 22:14:55 41.58965602 -120.7244817 0 0 0 0 Modoc, California, US
2288 2288 6061 Placer California US 2020-03-27 22:14:55 39.06167234 -120.72405690000001 30 1 0 0 Placer, California, US
1897 1897 6047 Merced California US 2020-03-27 22:14:55 37.18922369 -120.72090349999999 4 0 0 0 Merced, California, US
2610 2610 41055 Sherman Oregon US 2020-03-27 22:14:55 45.41501554 -120.6827834 0 0 0 0 Sherman, Oregon, US
1521 1521 53037 Kittitas Washington US 2020-03-27 22:14:55 47.12521214 -120.67943899999999 8 0 0 0 Kittitas, Washington, US
55 55 6005 Amador California US 2020-03-27 22:14:55 38.44583082 -120.65696000000001 2 0 0 0 Amador, California, US
469 469 53007 Chelan Washington US 2020-03-27 22:14:55 47.87046092 -120.6173956 12 1 0 0 Chelan, Washington, US
1597 1597 6035 Lassen California US 2020-03-27 22:14:55 40.67311306 -120.59350990000002 0 0 0 0 Lassen, California, US
340 340 6009 Calaveras California US 2020-03-27 22:14:55 38.20537103 -120.55291299999999 3 0 0 0 Calaveras, California, US
859 859 6017 El Dorado California US 2020-03-27 22:14:55 38.77965956 -120.5233166 9 0 0 0 El Dorado, California, US
2615 2615 6091 Sierra California US 2020-03-27 22:14:55 39.57713498 -120.52007009999998 0 0 0 0 Sierra, California, US
2516 2516 6079 San Luis Obispo California US 2020-03-27 22:14:55 35.38822029 -120.4039028 59 0 0 0 San Luis Obispo, California, US
1571 1571 41037 Lake Oregon US 2020-03-27 22:14:55 42.79246693 -120.38501629999999 0 0 0 0 Lake, Oregon, US
674 674 41013 Crook Oregon US 2020-03-27 22:14:55 44.14230227 -120.356297 0 0 0 0 Crook, Oregon, US
1043 1043 41021 Gilliam Oregon US 2020-03-27 22:14:55 45.37160076 -120.20488689999999 0 0 0 0 Gilliam, Oregon, US
3065 3065 41069 Wheeler Oregon US 2020-03-27 22:14:55 44.72698162 -120.02814270000002 0 0 0 0 Wheeler, Oregon, US
2529 2529 6083 Santa Barbara California US 2020-03-27 22:14:55 34.65329488 -120.0188492 32 0 0 0 Santa Barbara, California, US
2841 2841 6109 Tuolumne California US 2020-03-27 22:14:55 38.02644018 -119.95250929999999 0 0 0 0 Tuolumne, California, US
1809 1809 6043 Mariposa California US 2020-03-27 22:14:55 37.57978556 -119.9073334 0 0 0 0 Mariposa, California, US
54 54 6003 Alpine California US 2020-03-27 22:14:55 38.59678594 -119.82235940000001 0 0 0 0 Alpine, California, US
1512 1512 6031 Kings California US 2020-03-27 22:14:55 36.07409056 -119.8159973 0 0 0 0 Kings, California, US
1754 1754 6039 Madera California US 2020-03-27 22:14:55 37.21513971 -119.76655890000002 10 0 0 0 Madera, California, US
408 408 32510 Carson City Nevada US 2020-03-27 22:14:55 39.15509045 -119.7480219 2 0 0 0 Carson City, Nevada, US
2126 2126 53047 Okanogan Washington US 2020-03-27 22:14:55 48.54855019 -119.73872240000001 1 0 0 0 Okanogan, Washington, US
817 817 53017 Douglas Washington US 2020-03-27 22:14:55 47.7361335 -119.69293700000001 5 0 0 0 Douglas, Washington, US
3013 3013 32031 Washoe Nevada US 2020-03-27 22:14:55 40.66562265 -119.6631594 67 0 0 0 Washoe, Nevada, US
991 991 6019 Fresno California US 2020-03-27 22:14:55 36.75733899 -119.6466953 27 0 0 0 Fresno, California, US
814 814 32005 Douglas Nevada US 2020-03-27 22:14:55 38.912862 -119.61713329999999 3 0 0 0 Douglas, Nevada, US
2022 2022 41049 Morrow Oregon US 2020-03-27 22:14:55 45.41846568 -119.584546 1 0 0 0 Morrow, Oregon, US
2715 2715 32029 Storey Nevada US 2020-03-27 22:14:55 39.44875482 -119.5250207 0 0 0 0 Storey, Nevada, US
189 189 53005 Benton Washington US 2020-03-27 22:14:55 46.23946995 -119.51208340000001 42 4 0 0 Benton, Washington, US
1093 1093 53025 Grant Washington US 2020-03-27 22:14:55 47.20753737 -119.4500749 39 1 0 0 Grant, Washington, US
1744 1744 32019 Lyon Nevada US 2020-03-27 22:14:55 39.01777974 -119.18704790000001 1 0 0 0 Lyon, Nevada, US
2921 2921 6111 Ventura California US 2020-03-27 22:14:55 34.44465746 -119.09106129999999 61 1 0 0 Ventura, California, US
1091 1091 41023 Grant Oregon US 2020-03-27 22:14:55 44.49024544 -119.0068631 1 0 0 0 Grant, Oregon, US
1208 1208 41025 Harney Oregon US 2020-03-27 22:14:55 43.06422669 -118.96663059999999 0 0 0 0 Harney, Oregon, US
980 980 53021 Franklin Washington US 2020-03-27 22:14:55 46.53351425 -118.9018212 12 0 0 0 Franklin, Washington, US
1954 1954 6051 Mono California US 2020-03-27 22:14:55 37.93899289 -118.8872409 6 0 0 0 Mono, California, US
2838 2838 6107 Tulare California US 2020-03-27 22:14:55 36.22026558 -118.8020203 20 0 0 0 Tulare, California, US
2855 2855 41059 Umatilla Oregon US 2020-03-27 22:14:55 45.59073056 -118.7353826 3 0 0 0 Umatilla, Oregon, US
1495 1495 6029 Kern California US 2020-03-27 22:14:55 35.34329425 -118.72777959999999 33 1 0 0 Kern, California, US
19 19 53001 Adams Washington US 2020-03-27 22:14:55 46.98299757 -118.56017340000001 3 0 0 0 Adams, Washington, US
927 927 53019 Ferry Washington US 2020-03-27 22:14:55 48.471143100000006 -118.5154041 1 0 0 0 Ferry, Washington, US
2947 2947 53071 Walla Walla Washington US 2020-03-27 22:14:55 46.23040051 -118.4775539 2 0 0 0 Walla Walla, Washington, US
1934 1934 32021 Mineral Nevada US 2020-03-27 22:14:55 38.53841696 -118.4344506 0 0 0 0 Mineral, Nevada, US
1684 1684 53043 Lincoln Washington US 2020-03-27 22:14:55 47.57705241 -118.41943880000001 1 0 0 0 Lincoln, Washington, US
2243 2243 32027 Pershing Nevada US 2020-03-27 22:14:55 40.44003782 -118.40056409999998 0 0 0 0 Pershing, Nevada, US
509 509 32001 Churchill Nevada US 2020-03-27 22:14:55 39.58105744 -118.3394607 0 0 0 0 Churchill, Nevada, US
1717 1717 6037 Los Angeles California US 2020-03-27 22:14:55 34.30828379 -118.22824109999999 1465 26 0 0 Los Angeles, California, US
1320 1320 32013 Humboldt Nevada US 2020-03-27 22:14:55 41.40692186 -118.11094270000001 1 0 0 0 Humboldt, Nevada, US
2895 2895 41061 Union Oregon US 2020-03-27 22:14:55 45.30915495 -118.0068979 1 0 0 0 Union, Oregon, US
612 612 53013 Columbia Washington US 2020-03-27 22:14:55 46.29442881 -117.9051983 1 0 0 0 Columbia, Washington, US
2705 2705 53065 Stevens Washington US 2020-03-27 22:14:55 48.40035475 -117.8542701 2 0 0 0 Stevens, Washington, US
2143 2143 6059 Orange California US 2020-03-27 22:14:55 33.70147516 -117.76459979999998 321 3 0 0 Orange, California, US
119 119 41001 Baker Oregon US 2020-03-27 22:14:55 44.70915557 -117.6749883 0 0 0 0 Baker, Oregon, US
887 887 32009 Esmeralda Nevada US 2020-03-27 22:14:55 37.78436681 -117.63199990000001 0 0 0 0 Esmeralda, Nevada, US
1780 1780 41045 Malheur Oregon US 2020-03-27 22:14:55 43.1937027 -117.62273950000001 0 0 0 0 Malheur, Oregon, US
1018 1018 53023 Garfield Washington US 2020-03-27 22:14:55 46.43197502 -117.54540320000001 0 0 0 0 Garfield, Washington, US
3077 3077 53075 Whitman Washington US 2020-03-27 22:14:55 46.90022523 -117.52417630000001 5 0 0 0 Whitman, Washington, US
1342 1342 6027 Inyo California US 2020-03-27 22:14:55 36.51112084 -117.41119779999998 3 0 0 0 Inyo, California, US
2651 2651 53063 Spokane Washington US 2020-03-27 22:14:55 47.62113146 -117.4046494 83 0 0 0 Spokane, Washington, US
2221 2221 53051 Pend Oreille Washington US 2020-03-27 22:14:55 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
95 95 53003 Asotin Washington US 2020-03-27 22:14:55 46.18894415 -117.2022851 0 0 0 0 Asotin, Washington, US
2950 2950 41063 Wallowa Oregon US 2020-03-27 22:14:55 45.57894064 -117.18353799999998 0 0 0 0 Wallowa, Oregon, US
1587 1587 32015 Lander Nevada US 2020-03-27 22:14:55 39.933223299999995 -117.03970749999999 0 0 0 0 Lander, Nevada, US
2986 2986 16087 Washington Idaho US 2020-03-27 22:14:55 44.45275475 -116.78476880000001 0 0 0 0 Washington, Idaho, US
2214 2214 16075 Payette Idaho US 2020-03-27 22:14:55 44.00545243 -116.7647695 4 0 0 0 Payette, Idaho, US
2078 2078 16069 Nez Perce Idaho US 2020-03-27 22:14:55 46.32638236 -116.75009750000001 4 0 0 0 Nez Perce, Idaho, US
2508 2508 6073 San Diego California US 2020-03-27 22:14:55 33.03484597 -116.73653259999999 341 3 0 0 San Diego, California, US
1598 1598 16057 Latah Idaho US 2020-03-27 22:14:55 46.81587887 -116.71136979999999 0 0 0 0 Latah, Idaho, US
382 382 16027 Canyon Idaho US 2020-03-27 22:14:55 43.61970148 -116.70954990000001 23 1 0 0 Canyon, Idaho, US
1538 1538 16055 Kootenai Idaho US 2020-03-27 22:14:55 47.67282258 -116.7020872 10 0 0 0 Kootenai, Idaho, US
176 176 16009 Benewah Idaho US 2020-03-27 22:14:55 47.21754179 -116.6586851 0 0 0 0 Benewah, Idaho, US
230 230 16017 Bonner Idaho US 2020-03-27 22:14:55 48.29996017 -116.6017932 0 0 0 0 Bonner, Idaho, US
3174 3174     Alberta Canada 2020-03-27 23:27:32 53.9333 -116.5765 542 2 0 0 Alberta, Canada
2108 2108 32023 Nye Nevada US 2020-03-27 22:14:55 38.04264256 -116.47227020000001 1 0 0 0 Nye, Nevada, US
246 246 16021 Boundary Idaho US 2020-03-27 22:14:55 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
10 10 16003 Adams Idaho US 2020-03-27 22:14:55 44.89333571 -116.4545247 0 0 0 0 Adams, Idaho, US
1647 1647 16061 Lewis Idaho US 2020-03-27 22:14:55 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1029 1029 16045 Gem Idaho US 2020-03-27 22:14:55 44.06482372 -116.398376 0 0 0 0 Gem, Idaho, US
895 895 32011 Eureka Nevada US 2020-03-27 22:14:55 39.98100864 -116.26832040000001 0 0 0 0 Eureka, Nevada, US
4 4 16001 Ada Idaho US 2020-03-27 22:14:55 43.4526575 -116.24155159999998 54 0 0 0 Ada, Idaho, US
2507 2507 6071 San Bernardino California US 2020-03-27 22:14:55 34.84060306 -116.1774685 54 3 0 0 San Bernardino, California, US
2186 2186 16073 Owyhee Idaho US 2020-03-27 22:14:55 42.58016894 -116.16938710000001 0 0 0 0 Owyhee, Idaho, US
2440 2440 6065 Riverside California US 2020-03-27 22:14:55 33.74314981 -115.9933578 149 8 0 0 Riverside, California, US
2613 2613 16079 Shoshone Idaho US 2020-03-27 22:14:55 47.35364087 -115.89167490000001 0 0 0 0 Shoshone, Idaho, 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
);