ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26093 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636173 | 636173 | 2020-10-16 | Livingston | Michigan | 26093 | 1764 | 33 |
632927 | 632927 | 2020-10-15 | Livingston | Michigan | 26093 | 1743 | 33 |
629682 | 629682 | 2020-10-14 | Livingston | Michigan | 26093 | 1698 | 33 |
626438 | 626438 | 2020-10-13 | Livingston | Michigan | 26093 | 1668 | 33 |
623196 | 623196 | 2020-10-12 | Livingston | Michigan | 26093 | 1619 | 33 |
619953 | 619953 | 2020-10-11 | Livingston | Michigan | 26093 | 1599 | 33 |
616711 | 616711 | 2020-10-10 | Livingston | Michigan | 26093 | 1599 | 33 |
613470 | 613470 | 2020-10-09 | Livingston | Michigan | 26093 | 1599 | 33 |
610228 | 610228 | 2020-10-08 | Livingston | Michigan | 26093 | 1584 | 33 |
606986 | 606986 | 2020-10-07 | Livingston | Michigan | 26093 | 1566 | 33 |
603743 | 603743 | 2020-10-06 | Livingston | Michigan | 26093 | 1549 | 33 |
600501 | 600501 | 2020-10-05 | Livingston | Michigan | 26093 | 1532 | 32 |
597258 | 597258 | 2020-10-04 | Livingston | Michigan | 26093 | 1486 | 32 |
594017 | 594017 | 2020-10-03 | Livingston | Michigan | 26093 | 1486 | 32 |
590776 | 590776 | 2020-10-02 | Livingston | Michigan | 26093 | 1485 | 33 |
587535 | 587535 | 2020-10-01 | Livingston | Michigan | 26093 | 1485 | 33 |
584295 | 584295 | 2020-09-30 | Livingston | Michigan | 26093 | 1471 | 33 |
581054 | 581054 | 2020-09-29 | Livingston | Michigan | 26093 | 1457 | 32 |
577813 | 577813 | 2020-09-28 | Livingston | Michigan | 26093 | 1447 | 31 |
574572 | 574572 | 2020-09-27 | Livingston | Michigan | 26093 | 1419 | 31 |
571329 | 571329 | 2020-09-26 | Livingston | Michigan | 26093 | 1419 | 31 |
568087 | 568087 | 2020-09-25 | Livingston | Michigan | 26093 | 1419 | 31 |
564847 | 564847 | 2020-09-24 | Livingston | Michigan | 26093 | 1402 | 31 |
561607 | 561607 | 2020-09-23 | Livingston | Michigan | 26093 | 1390 | 31 |
558370 | 558370 | 2020-09-22 | Livingston | Michigan | 26093 | 1382 | 31 |
555133 | 555133 | 2020-09-21 | Livingston | Michigan | 26093 | 1387 | 31 |
551895 | 551895 | 2020-09-20 | Livingston | Michigan | 26093 | 1355 | 31 |
548656 | 548656 | 2020-09-19 | Livingston | Michigan | 26093 | 1355 | 31 |
545418 | 545418 | 2020-09-18 | Livingston | Michigan | 26093 | 1355 | 31 |
542181 | 542181 | 2020-09-17 | Livingston | Michigan | 26093 | 1350 | 30 |
538945 | 538945 | 2020-09-16 | Livingston | Michigan | 26093 | 1338 | 30 |
535708 | 535708 | 2020-09-15 | Livingston | Michigan | 26093 | 1329 | 30 |
532473 | 532473 | 2020-09-14 | Livingston | Michigan | 26093 | 1321 | 30 |
529237 | 529237 | 2020-09-13 | Livingston | Michigan | 26093 | 1291 | 30 |
526001 | 526001 | 2020-09-12 | Livingston | Michigan | 26093 | 1291 | 30 |
522765 | 522765 | 2020-09-11 | Livingston | Michigan | 26093 | 1291 | 30 |
519528 | 519528 | 2020-09-10 | Livingston | Michigan | 26093 | 1269 | 30 |
516293 | 516293 | 2020-09-09 | Livingston | Michigan | 26093 | 1260 | 30 |
513059 | 513059 | 2020-09-08 | Livingston | Michigan | 26093 | 1249 | 30 |
509827 | 509827 | 2020-09-07 | Livingston | Michigan | 26093 | 1213 | 30 |
506594 | 506594 | 2020-09-06 | Livingston | Michigan | 26093 | 1213 | 30 |
503361 | 503361 | 2020-09-05 | Livingston | Michigan | 26093 | 1213 | 30 |
500127 | 500127 | 2020-09-04 | Livingston | Michigan | 26093 | 1213 | 30 |
496893 | 496893 | 2020-09-03 | Livingston | Michigan | 26093 | 1198 | 30 |
493660 | 493660 | 2020-09-02 | Livingston | Michigan | 26093 | 1184 | 30 |
490426 | 490426 | 2020-09-01 | Livingston | Michigan | 26093 | 1174 | 30 |
487193 | 487193 | 2020-08-31 | Livingston | Michigan | 26093 | 1158 | 30 |
483959 | 483959 | 2020-08-30 | Livingston | Michigan | 26093 | 1121 | 30 |
480724 | 480724 | 2020-08-29 | Livingston | Michigan | 26093 | 1121 | 30 |
477492 | 477492 | 2020-08-28 | Livingston | Michigan | 26093 | 1121 | 30 |
474259 | 474259 | 2020-08-27 | Livingston | Michigan | 26093 | 1112 | 30 |
471027 | 471027 | 2020-08-26 | Livingston | Michigan | 26093 | 1096 | 30 |
467797 | 467797 | 2020-08-25 | Livingston | Michigan | 26093 | 1078 | 30 |
464568 | 464568 | 2020-08-24 | Livingston | Michigan | 26093 | 1069 | 30 |
461337 | 461337 | 2020-08-23 | Livingston | Michigan | 26093 | 1025 | 30 |
458110 | 458110 | 2020-08-22 | Livingston | Michigan | 26093 | 1025 | 30 |
454882 | 454882 | 2020-08-21 | Livingston | Michigan | 26093 | 1025 | 30 |
451654 | 451654 | 2020-08-20 | Livingston | Michigan | 26093 | 1016 | 30 |
448426 | 448426 | 2020-08-19 | Livingston | Michigan | 26093 | 998 | 30 |
445200 | 445200 | 2020-08-18 | Livingston | Michigan | 26093 | 987 | 30 |
441974 | 441974 | 2020-08-17 | Livingston | Michigan | 26093 | 971 | 29 |
438747 | 438747 | 2020-08-16 | Livingston | Michigan | 26093 | 937 | 29 |
435522 | 435522 | 2020-08-15 | Livingston | Michigan | 26093 | 931 | 29 |
432296 | 432296 | 2020-08-14 | Livingston | Michigan | 26093 | 931 | 29 |
429069 | 429069 | 2020-08-13 | Livingston | Michigan | 26093 | 914 | 29 |
425845 | 425845 | 2020-08-12 | Livingston | Michigan | 26093 | 905 | 29 |
422623 | 422623 | 2020-08-11 | Livingston | Michigan | 26093 | 891 | 29 |
419401 | 419401 | 2020-08-10 | Livingston | Michigan | 26093 | 886 | 29 |
416180 | 416180 | 2020-08-09 | Livingston | Michigan | 26093 | 863 | 29 |
412960 | 412960 | 2020-08-08 | Livingston | Michigan | 26093 | 863 | 29 |
409740 | 409740 | 2020-08-07 | Livingston | Michigan | 26093 | 863 | 29 |
406520 | 406520 | 2020-08-06 | Livingston | Michigan | 26093 | 857 | 29 |
403302 | 403302 | 2020-08-05 | Livingston | Michigan | 26093 | 848 | 29 |
400085 | 400085 | 2020-08-04 | Livingston | Michigan | 26093 | 848 | 29 |
396871 | 396871 | 2020-08-03 | Livingston | Michigan | 26093 | 836 | 29 |
393655 | 393655 | 2020-08-02 | Livingston | Michigan | 26093 | 812 | 29 |
390438 | 390438 | 2020-08-01 | Livingston | Michigan | 26093 | 812 | 29 |
387221 | 387221 | 2020-07-31 | Livingston | Michigan | 26093 | 812 | 29 |
384003 | 384003 | 2020-07-30 | Livingston | Michigan | 26093 | 797 | 29 |
380786 | 380786 | 2020-07-29 | Livingston | Michigan | 26093 | 786 | 29 |
377569 | 377569 | 2020-07-28 | Livingston | Michigan | 26093 | 770 | 29 |
374354 | 374354 | 2020-07-27 | Livingston | Michigan | 26093 | 767 | 29 |
371142 | 371142 | 2020-07-26 | Livingston | Michigan | 26093 | 745 | 29 |
367932 | 367932 | 2020-07-25 | Livingston | Michigan | 26093 | 745 | 29 |
364725 | 364725 | 2020-07-24 | Livingston | Michigan | 26093 | 745 | 29 |
361518 | 361518 | 2020-07-23 | Livingston | Michigan | 26093 | 738 | 29 |
358313 | 358313 | 2020-07-22 | Livingston | Michigan | 26093 | 730 | 29 |
355110 | 355110 | 2020-07-21 | Livingston | Michigan | 26093 | 723 | 29 |
351908 | 351908 | 2020-07-20 | Livingston | Michigan | 26093 | 696 | 29 |
348708 | 348708 | 2020-07-19 | Livingston | Michigan | 26093 | 696 | 29 |
345507 | 345507 | 2020-07-18 | Livingston | Michigan | 26093 | 696 | 29 |
342307 | 342307 | 2020-07-17 | Livingston | Michigan | 26093 | 696 | 29 |
339111 | 339111 | 2020-07-16 | Livingston | Michigan | 26093 | 691 | 29 |
335915 | 335915 | 2020-07-15 | Livingston | Michigan | 26093 | 675 | 29 |
332722 | 332722 | 2020-07-14 | Livingston | Michigan | 26093 | 668 | 29 |
329535 | 329535 | 2020-07-13 | Livingston | Michigan | 26093 | 666 | 29 |
326349 | 326349 | 2020-07-12 | Livingston | Michigan | 26093 | 663 | 29 |
323166 | 323166 | 2020-07-11 | Livingston | Michigan | 26093 | 660 | 29 |
319987 | 319987 | 2020-07-10 | Livingston | Michigan | 26093 | 657 | 29 |
316812 | 316812 | 2020-07-09 | Livingston | Michigan | 26093 | 656 | 29 |
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);