ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,576 rows where county = "Bay" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281103 | 281103 | 2020-06-28 | Bay | Florida | 12005 | 322 | 4 |
282011 | 282011 | 2020-06-28 | Bay | Michigan | 26017 | 386 | 30 |
277956 | 277956 | 2020-06-27 | Bay | Florida | 12005 | 305 | 4 |
278863 | 278863 | 2020-06-27 | Bay | Michigan | 26017 | 386 | 30 |
274808 | 274808 | 2020-06-26 | Bay | Florida | 12005 | 287 | 4 |
275715 | 275715 | 2020-06-26 | Bay | Michigan | 26017 | 385 | 30 |
271668 | 271668 | 2020-06-25 | Bay | Florida | 12005 | 248 | 4 |
272572 | 272572 | 2020-06-25 | Bay | Michigan | 26017 | 383 | 30 |
268532 | 268532 | 2020-06-24 | Bay | Florida | 12005 | 240 | 4 |
269435 | 269435 | 2020-06-24 | Bay | Michigan | 26017 | 381 | 29 |
265402 | 265402 | 2020-06-23 | Bay | Florida | 12005 | 230 | 4 |
266302 | 266302 | 2020-06-23 | Bay | Michigan | 26017 | 379 | 29 |
262274 | 262274 | 2020-06-22 | Bay | Florida | 12005 | 205 | 4 |
263176 | 263176 | 2020-06-22 | Bay | Michigan | 26017 | 379 | 29 |
259147 | 259147 | 2020-06-21 | Bay | Florida | 12005 | 190 | 4 |
260047 | 260047 | 2020-06-21 | Bay | Michigan | 26017 | 378 | 29 |
256020 | 256020 | 2020-06-20 | Bay | Florida | 12005 | 188 | 4 |
256921 | 256921 | 2020-06-20 | Bay | Michigan | 26017 | 378 | 29 |
252901 | 252901 | 2020-06-19 | Bay | Florida | 12005 | 175 | 4 |
253801 | 253801 | 2020-06-19 | Bay | Michigan | 26017 | 379 | 29 |
249786 | 249786 | 2020-06-18 | Bay | Florida | 12005 | 167 | 4 |
250686 | 250686 | 2020-06-18 | Bay | Michigan | 26017 | 379 | 29 |
246674 | 246674 | 2020-06-17 | Bay | Florida | 12005 | 161 | 4 |
247574 | 247574 | 2020-06-17 | Bay | Michigan | 26017 | 378 | 29 |
243561 | 243561 | 2020-06-16 | Bay | Florida | 12005 | 157 | 4 |
244461 | 244461 | 2020-06-16 | Bay | Michigan | 26017 | 377 | 29 |
240450 | 240450 | 2020-06-15 | Bay | Florida | 12005 | 153 | 4 |
241350 | 241350 | 2020-06-15 | Bay | Michigan | 26017 | 378 | 29 |
237342 | 237342 | 2020-06-14 | Bay | Florida | 12005 | 145 | 4 |
238241 | 238241 | 2020-06-14 | Bay | Michigan | 26017 | 377 | 29 |
234235 | 234235 | 2020-06-13 | Bay | Florida | 12005 | 141 | 4 |
235134 | 235134 | 2020-06-13 | Bay | Michigan | 26017 | 376 | 28 |
231129 | 231129 | 2020-06-12 | Bay | Florida | 12005 | 139 | 4 |
232029 | 232029 | 2020-06-12 | Bay | Michigan | 26017 | 381 | 28 |
228026 | 228026 | 2020-06-11 | Bay | Florida | 12005 | 135 | 4 |
228925 | 228925 | 2020-06-11 | Bay | Michigan | 26017 | 385 | 28 |
224924 | 224924 | 2020-06-10 | Bay | Florida | 12005 | 135 | 4 |
225823 | 225823 | 2020-06-10 | Bay | Michigan | 26017 | 372 | 27 |
221829 | 221829 | 2020-06-09 | Bay | Florida | 12005 | 133 | 4 |
222726 | 222726 | 2020-06-09 | Bay | Michigan | 26017 | 385 | 27 |
218734 | 218734 | 2020-06-08 | Bay | Florida | 12005 | 132 | 4 |
219631 | 219631 | 2020-06-08 | Bay | Michigan | 26017 | 384 | 27 |
215643 | 215643 | 2020-06-07 | Bay | Florida | 12005 | 130 | 4 |
216539 | 216539 | 2020-06-07 | Bay | Michigan | 26017 | 380 | 27 |
212556 | 212556 | 2020-06-06 | Bay | Florida | 12005 | 123 | 4 |
213451 | 213451 | 2020-06-06 | Bay | Michigan | 26017 | 377 | 27 |
209471 | 209471 | 2020-06-05 | Bay | Florida | 12005 | 115 | 4 |
210367 | 210367 | 2020-06-05 | Bay | Michigan | 26017 | 370 | 26 |
206390 | 206390 | 2020-06-04 | Bay | Florida | 12005 | 111 | 4 |
207286 | 207286 | 2020-06-04 | Bay | Michigan | 26017 | 326 | 24 |
203310 | 203310 | 2020-06-03 | Bay | Florida | 12005 | 105 | 3 |
204205 | 204205 | 2020-06-03 | Bay | Michigan | 26017 | 322 | 24 |
200234 | 200234 | 2020-06-02 | Bay | Florida | 12005 | 99 | 3 |
201128 | 201128 | 2020-06-02 | Bay | Michigan | 26017 | 317 | 24 |
197161 | 197161 | 2020-06-01 | Bay | Florida | 12005 | 100 | 3 |
198056 | 198056 | 2020-06-01 | Bay | Michigan | 26017 | 312 | 24 |
194091 | 194091 | 2020-05-31 | Bay | Florida | 12005 | 98 | 3 |
194985 | 194985 | 2020-05-31 | Bay | Michigan | 26017 | 310 | 23 |
191024 | 191024 | 2020-05-30 | Bay | Florida | 12005 | 97 | 3 |
191917 | 191917 | 2020-05-30 | Bay | Michigan | 26017 | 303 | 23 |
187959 | 187959 | 2020-05-29 | Bay | Florida | 12005 | 98 | 3 |
188853 | 188853 | 2020-05-29 | Bay | Michigan | 26017 | 302 | 22 |
184903 | 184903 | 2020-05-28 | Bay | Florida | 12005 | 97 | 3 |
185795 | 185795 | 2020-05-28 | Bay | Michigan | 26017 | 296 | 22 |
181849 | 181849 | 2020-05-27 | Bay | Florida | 12005 | 97 | 3 |
182740 | 182740 | 2020-05-27 | Bay | Michigan | 26017 | 294 | 22 |
178805 | 178805 | 2020-05-26 | Bay | Florida | 12005 | 97 | 3 |
179694 | 179694 | 2020-05-26 | Bay | Michigan | 26017 | 287 | 19 |
175761 | 175761 | 2020-05-25 | Bay | Florida | 12005 | 97 | 3 |
176650 | 176650 | 2020-05-25 | Bay | Michigan | 26017 | 286 | 19 |
172718 | 172718 | 2020-05-24 | Bay | Florida | 12005 | 95 | 3 |
173607 | 173607 | 2020-05-24 | Bay | Michigan | 26017 | 282 | 19 |
169677 | 169677 | 2020-05-23 | Bay | Florida | 12005 | 94 | 3 |
170565 | 170565 | 2020-05-23 | Bay | Michigan | 26017 | 276 | 19 |
166640 | 166640 | 2020-05-22 | Bay | Florida | 12005 | 92 | 3 |
167528 | 167528 | 2020-05-22 | Bay | Michigan | 26017 | 269 | 16 |
163607 | 163607 | 2020-05-21 | Bay | Florida | 12005 | 87 | 3 |
164492 | 164492 | 2020-05-21 | Bay | Michigan | 26017 | 260 | 16 |
160579 | 160579 | 2020-05-20 | Bay | Florida | 12005 | 86 | 3 |
161463 | 161463 | 2020-05-20 | Bay | Michigan | 26017 | 255 | 16 |
157553 | 157553 | 2020-05-19 | Bay | Florida | 12005 | 86 | 3 |
158437 | 158437 | 2020-05-19 | Bay | Michigan | 26017 | 250 | 16 |
154537 | 154537 | 2020-05-18 | Bay | Florida | 12005 | 85 | 3 |
155419 | 155419 | 2020-05-18 | Bay | Michigan | 26017 | 248 | 16 |
151525 | 151525 | 2020-05-17 | Bay | Florida | 12005 | 84 | 3 |
152405 | 152405 | 2020-05-17 | Bay | Michigan | 26017 | 241 | 15 |
148516 | 148516 | 2020-05-16 | Bay | Florida | 12005 | 83 | 3 |
149394 | 149394 | 2020-05-16 | Bay | Michigan | 26017 | 234 | 15 |
145513 | 145513 | 2020-05-15 | Bay | Florida | 12005 | 80 | 3 |
146389 | 146389 | 2020-05-15 | Bay | Michigan | 26017 | 228 | 14 |
142513 | 142513 | 2020-05-14 | Bay | Florida | 12005 | 78 | 3 |
143389 | 143389 | 2020-05-14 | Bay | Michigan | 26017 | 226 | 12 |
139517 | 139517 | 2020-05-13 | Bay | Florida | 12005 | 77 | 3 |
140394 | 140394 | 2020-05-13 | Bay | Michigan | 26017 | 214 | 10 |
136526 | 136526 | 2020-05-12 | Bay | Florida | 12005 | 77 | 3 |
137400 | 137400 | 2020-05-12 | Bay | Michigan | 26017 | 214 | 10 |
133537 | 133537 | 2020-05-11 | Bay | Florida | 12005 | 76 | 3 |
134410 | 134410 | 2020-05-11 | Bay | Michigan | 26017 | 204 | 9 |
130546 | 130546 | 2020-05-10 | Bay | Florida | 12005 | 76 | 3 |
131419 | 131419 | 2020-05-10 | Bay | Michigan | 26017 | 192 | 9 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);