ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26005 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535664 | 535664 | 2020-09-15 | Allegan | Michigan | 26005 | 711 | 7 |
532429 | 532429 | 2020-09-14 | Allegan | Michigan | 26005 | 702 | 7 |
529193 | 529193 | 2020-09-13 | Allegan | Michigan | 26005 | 694 | 7 |
525957 | 525957 | 2020-09-12 | Allegan | Michigan | 26005 | 694 | 7 |
522721 | 522721 | 2020-09-11 | Allegan | Michigan | 26005 | 690 | 7 |
519484 | 519484 | 2020-09-10 | Allegan | Michigan | 26005 | 684 | 7 |
516249 | 516249 | 2020-09-09 | Allegan | Michigan | 26005 | 680 | 8 |
513015 | 513015 | 2020-09-08 | Allegan | Michigan | 26005 | 672 | 6 |
509783 | 509783 | 2020-09-07 | Allegan | Michigan | 26005 | 669 | 6 |
506550 | 506550 | 2020-09-06 | Allegan | Michigan | 26005 | 663 | 6 |
503317 | 503317 | 2020-09-05 | Allegan | Michigan | 26005 | 663 | 6 |
500083 | 500083 | 2020-09-04 | Allegan | Michigan | 26005 | 658 | 6 |
496849 | 496849 | 2020-09-03 | Allegan | Michigan | 26005 | 650 | 6 |
493616 | 493616 | 2020-09-02 | Allegan | Michigan | 26005 | 648 | 6 |
490382 | 490382 | 2020-09-01 | Allegan | Michigan | 26005 | 644 | 6 |
487149 | 487149 | 2020-08-31 | Allegan | Michigan | 26005 | 643 | 6 |
483915 | 483915 | 2020-08-30 | Allegan | Michigan | 26005 | 637 | 6 |
480680 | 480680 | 2020-08-29 | Allegan | Michigan | 26005 | 630 | 6 |
477448 | 477448 | 2020-08-28 | Allegan | Michigan | 26005 | 620 | 6 |
474215 | 474215 | 2020-08-27 | Allegan | Michigan | 26005 | 616 | 6 |
470983 | 470983 | 2020-08-26 | Allegan | Michigan | 26005 | 613 | 6 |
467753 | 467753 | 2020-08-25 | Allegan | Michigan | 26005 | 606 | 6 |
464524 | 464524 | 2020-08-24 | Allegan | Michigan | 26005 | 600 | 6 |
461293 | 461293 | 2020-08-23 | Allegan | Michigan | 26005 | 597 | 6 |
458066 | 458066 | 2020-08-22 | Allegan | Michigan | 26005 | 583 | 6 |
454838 | 454838 | 2020-08-21 | Allegan | Michigan | 26005 | 573 | 6 |
451610 | 451610 | 2020-08-20 | Allegan | Michigan | 26005 | 573 | 6 |
448382 | 448382 | 2020-08-19 | Allegan | Michigan | 26005 | 573 | 6 |
445156 | 445156 | 2020-08-18 | Allegan | Michigan | 26005 | 573 | 6 |
441930 | 441930 | 2020-08-17 | Allegan | Michigan | 26005 | 572 | 6 |
438703 | 438703 | 2020-08-16 | Allegan | Michigan | 26005 | 571 | 6 |
435478 | 435478 | 2020-08-15 | Allegan | Michigan | 26005 | 564 | 6 |
432252 | 432252 | 2020-08-14 | Allegan | Michigan | 26005 | 549 | 6 |
429025 | 429025 | 2020-08-13 | Allegan | Michigan | 26005 | 548 | 6 |
425801 | 425801 | 2020-08-12 | Allegan | Michigan | 26005 | 542 | 6 |
422579 | 422579 | 2020-08-11 | Allegan | Michigan | 26005 | 532 | 6 |
419357 | 419357 | 2020-08-10 | Allegan | Michigan | 26005 | 529 | 6 |
416136 | 416136 | 2020-08-09 | Allegan | Michigan | 26005 | 529 | 6 |
412916 | 412916 | 2020-08-08 | Allegan | Michigan | 26005 | 522 | 7 |
409696 | 409696 | 2020-08-07 | Allegan | Michigan | 26005 | 510 | 7 |
406476 | 406476 | 2020-08-06 | Allegan | Michigan | 26005 | 507 | 7 |
403258 | 403258 | 2020-08-05 | Allegan | Michigan | 26005 | 504 | 7 |
400041 | 400041 | 2020-08-04 | Allegan | Michigan | 26005 | 505 | 7 |
396827 | 396827 | 2020-08-03 | Allegan | Michigan | 26005 | 507 | 7 |
393611 | 393611 | 2020-08-02 | Allegan | Michigan | 26005 | 507 | 7 |
390394 | 390394 | 2020-08-01 | Allegan | Michigan | 26005 | 498 | 7 |
387177 | 387177 | 2020-07-31 | Allegan | Michigan | 26005 | 495 | 7 |
383959 | 383959 | 2020-07-30 | Allegan | Michigan | 26005 | 485 | 7 |
380742 | 380742 | 2020-07-29 | Allegan | Michigan | 26005 | 482 | 7 |
377525 | 377525 | 2020-07-28 | Allegan | Michigan | 26005 | 477 | 7 |
374310 | 374310 | 2020-07-27 | Allegan | Michigan | 26005 | 472 | 7 |
371098 | 371098 | 2020-07-26 | Allegan | Michigan | 26005 | 470 | 7 |
367888 | 367888 | 2020-07-25 | Allegan | Michigan | 26005 | 465 | 7 |
364681 | 364681 | 2020-07-24 | Allegan | Michigan | 26005 | 458 | 7 |
361474 | 361474 | 2020-07-23 | Allegan | Michigan | 26005 | 449 | 7 |
358269 | 358269 | 2020-07-22 | Allegan | Michigan | 26005 | 443 | 8 |
355066 | 355066 | 2020-07-21 | Allegan | Michigan | 26005 | 440 | 7 |
351864 | 351864 | 2020-07-20 | Allegan | Michigan | 26005 | 435 | 7 |
348664 | 348664 | 2020-07-19 | Allegan | Michigan | 26005 | 424 | 7 |
345463 | 345463 | 2020-07-18 | Allegan | Michigan | 26005 | 415 | 7 |
342263 | 342263 | 2020-07-17 | Allegan | Michigan | 26005 | 408 | 7 |
339067 | 339067 | 2020-07-16 | Allegan | Michigan | 26005 | 404 | 7 |
335871 | 335871 | 2020-07-15 | Allegan | Michigan | 26005 | 400 | 7 |
332678 | 332678 | 2020-07-14 | Allegan | Michigan | 26005 | 388 | 7 |
329491 | 329491 | 2020-07-13 | Allegan | Michigan | 26005 | 378 | 7 |
326305 | 326305 | 2020-07-12 | Allegan | Michigan | 26005 | 373 | 7 |
323122 | 323122 | 2020-07-11 | Allegan | Michigan | 26005 | 371 | 7 |
319943 | 319943 | 2020-07-10 | Allegan | Michigan | 26005 | 362 | 7 |
316768 | 316768 | 2020-07-09 | Allegan | Michigan | 26005 | 358 | 7 |
313594 | 313594 | 2020-07-08 | Allegan | Michigan | 26005 | 353 | 7 |
310424 | 310424 | 2020-07-07 | Allegan | Michigan | 26005 | 346 | 7 |
307256 | 307256 | 2020-07-06 | Allegan | Michigan | 26005 | 338 | 7 |
304089 | 304089 | 2020-07-05 | Allegan | Michigan | 26005 | 333 | 7 |
300925 | 300925 | 2020-07-04 | Allegan | Michigan | 26005 | 331 | 7 |
297763 | 297763 | 2020-07-03 | Allegan | Michigan | 26005 | 328 | 7 |
294605 | 294605 | 2020-07-02 | Allegan | Michigan | 26005 | 325 | 7 |
291451 | 291451 | 2020-07-01 | Allegan | Michigan | 26005 | 317 | 7 |
288300 | 288300 | 2020-06-30 | Allegan | Michigan | 26005 | 312 | 7 |
285150 | 285150 | 2020-06-29 | Allegan | Michigan | 26005 | 308 | 6 |
282005 | 282005 | 2020-06-28 | Allegan | Michigan | 26005 | 306 | 6 |
278857 | 278857 | 2020-06-27 | Allegan | Michigan | 26005 | 303 | 6 |
275709 | 275709 | 2020-06-26 | Allegan | Michigan | 26005 | 302 | 6 |
272566 | 272566 | 2020-06-25 | Allegan | Michigan | 26005 | 301 | 6 |
269429 | 269429 | 2020-06-24 | Allegan | Michigan | 26005 | 303 | 6 |
266296 | 266296 | 2020-06-23 | Allegan | Michigan | 26005 | 301 | 6 |
263170 | 263170 | 2020-06-22 | Allegan | Michigan | 26005 | 301 | 6 |
260041 | 260041 | 2020-06-21 | Allegan | Michigan | 26005 | 299 | 6 |
256915 | 256915 | 2020-06-20 | Allegan | Michigan | 26005 | 297 | 6 |
253795 | 253795 | 2020-06-19 | Allegan | Michigan | 26005 | 292 | 6 |
250680 | 250680 | 2020-06-18 | Allegan | Michigan | 26005 | 291 | 6 |
247568 | 247568 | 2020-06-17 | Allegan | Michigan | 26005 | 288 | 6 |
244455 | 244455 | 2020-06-16 | Allegan | Michigan | 26005 | 288 | 6 |
241344 | 241344 | 2020-06-15 | Allegan | Michigan | 26005 | 287 | 6 |
238235 | 238235 | 2020-06-14 | Allegan | Michigan | 26005 | 286 | 6 |
235128 | 235128 | 2020-06-13 | Allegan | Michigan | 26005 | 283 | 6 |
232023 | 232023 | 2020-06-12 | Allegan | Michigan | 26005 | 280 | 6 |
228919 | 228919 | 2020-06-11 | Allegan | Michigan | 26005 | 277 | 6 |
225817 | 225817 | 2020-06-10 | Allegan | Michigan | 26005 | 274 | 6 |
222720 | 222720 | 2020-06-09 | Allegan | Michigan | 26005 | 273 | 6 |
219625 | 219625 | 2020-06-08 | Allegan | Michigan | 26005 | 268 | 6 |
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);