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

✎ 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
101 101 6081 San Mateo California US 3/22/20 23:45 37.4228808 -122.3275546 117 1 0 0 San Mateo, California, 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
103 103 6059 Orange California US 3/22/20 23:45 33.70147516 -117.7645998 95 0 0 0 Orange, California, US
104 104 6001 Alameda California US 3/22/20 23:45 37.64629437 -121.8929271 71 0 0 0 Alameda, 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
106 106 6067 Sacramento California US 3/22/20 23:45 38.45106826 -121.3425374 53 3 0 0 Sacramento, California, US
107 107 6041 Marin California US 3/22/20 23:45 38.07122463 -122.7210631 38 0 0 0 Marin, California, US
108 108 6077 San Joaquin California US 3/22/20 23:45 37.93433732 -121.2730061 31 2 0 0 San Joaquin, California, US
109 109 6065 Riverside California US 3/22/20 23:45 33.74314981 -115.9933578 29 6 0 0 Riverside, California, US
110 110 6079 San Luis Obispo California US 3/22/20 23:45 35.38822029 -120.4039028 27 0 0 0 San Luis Obispo, California, US
111 111 6111 Ventura California US 3/22/20 23:45 34.44465746 -119.0910613 25 0 0 0 Ventura, California, US
112 112 6097 Sonoma California US 3/22/20 23:45 38.52746429 -122.8862506 22 1 0 0 Sonoma, California, US
113 113 6071 San Bernardino California US 3/22/20 23:45 34.84060306 -116.1774685 17 0 0 0 San Bernardino, 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
116 116 6083 Santa Barbara California US 3/22/20 23:45 34.65329488 -120.0188492 13 0 0 0 Santa Barbara, California, US
117 117 6061 Placer California US 3/22/20 23:45 39.06167234 -120.7240569 12 1 0 0 Placer, California, US
118 118 6107 Tulare California US 3/22/20 23:45 36.22026558 -118.8020203 12 0 0 0 Tulare, California, US
119 119 6053 Monterey California US 3/22/20 23:45 36.21862405 -121.2413397 11 1 0 0 Monterey, California, US
120 120 6113 Yolo California US 3/22/20 23:45 38.68278902 -121.9018288 6 0 0 0 Yolo, California, US
121 121 6019 Fresno California US 3/22/20 23:45 36.75733899 -119.6466953 6 0 0 0 Fresno, California, US
122 122 6025 Imperial California US 3/22/20 23:45 33.0393082 -115.3669042 6 0 0 0 Imperial, California, US
123 123 6069 San Benito California US 3/22/20 23:45 36.60308176 -121.069975 5 1 0 0 San Benito, California, US
124 124 6099 Stanislaus California US 3/22/20 23:45 37.55862499 -120.9970722 5 0 0 0 Stanislaus, California, US
125 125 6029 Kern California US 3/22/20 23:45 35.34329425 -118.7277796 5 0 0 0 Kern, California, US
126 126 6039 Madera California US 3/22/20 23:45 37.21513971 -119.7665589 3 0 0 0 Madera, California, US
127 127 6023 Humboldt California US 3/22/20 23:45 40.69923009 -123.876044 2 0 0 0 Humboldt, California, US
128 128 6009 Calaveras California US 3/22/20 23:45 38.20537103 -120.552913 2 0 0 0 Calaveras, California, US
129 129 6093 Siskiyou California US 3/22/20 23:45 41.59198861 -122.5407434 2 0 0 0 Siskiyou, California, US
130 130 6115 Yuba California US 3/22/20 23:45 39.26255932 -121.3535644 2 0 0 0 Yuba, California, US
131 131 6089 Shasta California US 3/22/20 23:45 40.76391419 -122.0396884 1 0 0 0 Shasta, California, US
132 132 6057 Nevada California US 3/22/20 23:45 39.30394768 -120.7627281 1 0 0 0 Nevada, California, US
133 133 6045 Mendocino California US 3/22/20 23:45 39.4381191 -123.3911313 1 0 0 0 Mendocino, California, US
134 134 6005 Amador California US 3/22/20 23:45 38.44583082 -120.65696 1 0 0 0 Amador, California, US
135 135 6051 Mono California US 3/22/20 23:45 37.93899289 -118.8872409 1 0 0 0 Mono, California, US
136 136 6007 Butte California US 3/22/20 23:45 39.66727762 -121.6005252 1 0 0 0 Butte, California, US
137 137 6055 Napa California US 3/22/20 23:45 38.50735751 -122.332839 1 0 0 0 Napa, California, US
138 138 17031 Cook Illinois US 3/22/20 23:45 41.84144849 -87.81658794 805 4 0 0 Cook, Illinois, US
139 139 17043 DuPage Illinois US 3/22/20 23:45 41.85116968 -88.08642662 79 0 0 0 DuPage, Illinois, US
140 140 17097 Lake Illinois US 3/22/20 23:45 42.3224907 -88.00367925 69 0 0 0 Lake, Illinois, US
141 141 17197 Will Illinois US 3/22/20 23:45 41.44619267 -87.97862712 21 1 0 0 Will, Illinois, US
142 142 17089 Kane Illinois US 3/22/20 23:45 41.93842729 -88.42861412 13 0 0 0 Kane, Illinois, US
143 143 17111 McHenry Illinois US 3/22/20 23:45 42.32451172 -88.45248227 12 0 0 0 McHenry, Illinois, US
144 144 17113 McLean Illinois US 3/22/20 23:45 40.48996987 -88.84621113 6 0 0 0 McLean, Illinois, US
145 145 17167 Sangamon Illinois US 3/22/20 23:45 39.75836914 -89.65872023 4 1 0 0 Sangamon, Illinois, US
146 146 17201 Winnebago Illinois US 3/22/20 23:45 42.33641854 -89.16085327 4 0 0 0 Winnebago, Illinois, US
147 147 17093 Kendall Illinois US 3/22/20 23:45 41.59081014 -88.42869583 4 0 0 0 Kendall, Illinois, US
148 148 17163 St. Clair Illinois US 3/22/20 23:45 38.46996033 -89.93063427 3 0 0 0 St. Clair, Illinois, US
149 149 17027 Clinton Illinois US 3/22/20 23:45 38.60704876 -89.42385254 3 0 0 0 Clinton, Illinois, US
150 150 17143 Peoria Illinois US 3/22/20 23:45 40.78702156 -89.76078901 3 0 0 0 Peoria, Illinois, US
151 151 17203 Woodford Illinois US 3/22/20 23:45 40.78579374 -89.20973757 2 0 0 0 Woodford, Illinois, US
152 152 17119 Madison Illinois US 3/22/20 23:45 38.83042506 -89.90422563 2 0 0 0 Madison, Illinois, US
153 153 17091 Kankakee Illinois US 3/22/20 23:45 41.13746989 -87.86205334 2 0 0 0 Kankakee, Illinois, US
154 154   Unassigned Illinois US 3/22/20 23:45 0.0 0.0 2 3 0 0 Unassigned, Illinois, US
155 155 17019 Champaign Illinois US 3/22/20 23:45 40.13919438 -88.20046615 2 0 0 0 Champaign, Illinois, US
156 156 17035 Cumberland Illinois US 3/22/20 23:45 39.27432424 -88.2401158 1 0 0 0 Cumberland, Illinois, US
157 157 17195 Whiteside Illinois US 3/22/20 23:45 41.75509713 -89.91556058 1 0 0 0 Whiteside, Illinois, US
158 158 17077 Jackson Illinois US 3/22/20 23:45 37.78595185 -89.38232563 1 0 0 0 Jackson, Illinois, US
159 159 17199 Williamson Illinois US 3/22/20 23:45 37.73033511 -88.92994027 1 0 0 0 Williamson, Illinois, US
160 160 17099 LaSalle Illinois US 3/22/20 23:45 41.3442613 -88.88633881 1 0 0 0 LaSalle, Illinois, US
161 161 17189 Washington Illinois US 3/22/20 23:45 38.35309213 -89.40982703 1 0 0 0 Washington, Illinois, US
162 162 17001 Adams Illinois US 3/22/20 23:45 39.98815591 -91.18786813 1 0 0 0 Adams, Illinois, US
163 163 17021 Christian Illinois US 3/22/20 23:45 39.54581621 -89.27780482 1 0 0 0 Christian, Illinois, US
164 164 17037 DeKalb Illinois US 3/22/20 23:45 41.89373302 -88.76958483 1 0 0 0 DeKalb, Illinois, US
165 165 17085 Jo Daviess Illinois US 3/22/20 23:45 42.36542373 -90.21094405 1 0 0 0 Jo Daviess, Illinois, US
166 166 17177 Stephenson Illinois US 3/22/20 23:45 42.35129217 -89.662598 1 0 0 0 Stephenson, Illinois, US
167 167 17105 Livingston Illinois US 3/22/20 23:45 40.89188292 -88.55784752 1 0 0 0 Livingston, Illinois, US
168 168 17161 Rock Island Illinois US 3/22/20 23:45 41.46613806 -90.57042164 1 0 0 0 Rock Island, Illinois, US
169 169 26163 Wayne Michigan US 3/22/20 23:45 42.28098405 -83.281255 477 5 0 0 Wayne, Michigan, US
170 170 26125 Oakland Michigan US 3/22/20 23:45 42.66090111 -83.38595416 277 2 0 0 Oakland, Michigan, US
171 171 26099 Macomb Michigan US 3/22/20 23:45 42.69158356 -82.92752801 140 1 0 0 Macomb, Michigan, US
172 172 26161 Washtenaw Michigan US 3/22/20 23:45 42.253105 -83.83853204 35 0 0 0 Washtenaw, Michigan, US
173 173 26081 Kent Michigan US 3/22/20 23:45 43.03197711 -85.54934642 22 1 0 0 Kent, Michigan, US
174 174 26049 Genesee Michigan US 3/22/20 23:45 43.02244215 -83.70589709 14 0 0 0 Genesee, Michigan, US
175 175 26065 Ingham Michigan US 3/22/20 23:45 42.59716886 -84.37472069 11 0 0 0 Ingham, Michigan, US
176 176 26093 Livingston Michigan US 3/22/20 23:45 42.60302282 -83.91297209 8 0 0 0 Livingston, Michigan, US
177 177 26147 St. Clair Michigan US 3/22/20 23:45 42.92655373 -82.67937954 7 0 0 0 St. Clair, Michigan, US
178 178 26115 Monroe Michigan US 3/22/20 23:45 41.92734151 -83.53749864 6 0 0 0 Monroe, Michigan, US
179 179 26139 Ottawa Michigan US 3/22/20 23:45 42.95996803 -85.9969107 6 0 0 0 Ottawa, Michigan, US
180 180 26111 Midland Michigan US 3/22/20 23:45 43.64330771 -84.38804374 5 0 0 0 Midland, Michigan, US
181 181 26021 Berrien Michigan US 3/22/20 23:45 41.95447397 -86.4131308 3 0 0 0 Berrien, Michigan, US
182 182 26029 Charlevoix Michigan US 3/22/20 23:45 45.37790017 -85.19614053 2 0 0 0 Charlevoix, Michigan, US
183 183 26037 Clinton Michigan US 3/22/20 23:45 42.94400871 -84.60145248 2 0 0 0 Clinton, Michigan, US
184 184 26045 Eaton Michigan US 3/22/20 23:45 42.59599185 -84.83740035 2 0 0 0 Eaton, Michigan, US
185 185 26025 Calhoun Michigan US 3/22/20 23:45 42.24633834 -85.00493569 2 0 0 0 Calhoun, Michigan, US
186 186 26145 Saginaw Michigan US 3/22/20 23:45 43.33433923 -84.0513121 2 0 0 0 Saginaw, Michigan, US
187 187 26117 Montcalm Michigan US 3/22/20 23:45 43.31082541 -85.15252824 1 0 0 0 Montcalm, Michigan, US
188 188 26017 Bay Michigan US 3/22/20 23:45 43.70639106 -83.98731479 1 0 0 0 Bay, Michigan, US
189 189 26089 Leelanau Michigan US 3/22/20 23:45 44.94430054 -85.80150326 1 0 0 0 Leelanau, Michigan, US
190 190 26137 Otsego Michigan US 3/22/20 23:45 45.02085831 -84.59898295 1 0 0 0 Otsego, Michigan, US
191 191 26075 Jackson Michigan US 3/22/20 23:45 42.24807035 -84.42258681 1 0 0 0 Jackson, Michigan, US
192 192 26015 Barry Michigan US 3/22/20 23:45 42.59513984 -85.30834519 1 0 0 0 Barry, Michigan, US
193 193 26165 Wexford Michigan US 3/22/20 23:45 44.33853602 -85.57712739 1 0 0 0 Wexford, Michigan, US
194 194 26035 Clare Michigan US 3/22/20 23:45 43.98794227 -84.8481986 1 0 0 0 Clare, Michigan, US
195 195 26005 Allegan Michigan US 3/22/20 23:45 42.59147037 -85.89102866 1 0 0 0 Allegan, Michigan, US
196 196 26157 Tuscola Michigan US 3/22/20 23:45 43.46606813 -83.41897025 1 0 0 0 Tuscola, Michigan, US
197 197 26051 Gladwin Michigan US 3/22/20 23:45 43.98901072 -84.38774817 1 0 0 0 Gladwin, Michigan, US
198 198 26047 Emmet Michigan US 3/22/20 23:45 45.52625509 -84.89083249 1 0 0 0 Emmet, Michigan, US
199 199 26055 Grand Traverse Michigan US 3/22/20 23:45 44.69565625 -85.55585247 1 0 0 0 Grand Traverse, Michigan, US
200 200 26143 Roscommon Michigan US 3/22/20 23:45 44.33473082 -84.61067651 1 0 0 0 Roscommon, Michigan, 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
);