ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26117 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
769208 | 769208 | 2020-11-26 | Montcalm | Michigan | 26117 | 1723 | 23 |
765962 | 765962 | 2020-11-25 | Montcalm | Michigan | 26117 | 1723 | 23 |
762717 | 762717 | 2020-11-24 | Montcalm | Michigan | 26117 | 1682 | 22 |
759472 | 759472 | 2020-11-23 | Montcalm | Michigan | 26117 | 1667 | 22 |
756225 | 756225 | 2020-11-22 | Montcalm | Michigan | 26117 | 1540 | 21 |
752979 | 752979 | 2020-11-21 | Montcalm | Michigan | 26117 | 1540 | 21 |
749733 | 749733 | 2020-11-20 | Montcalm | Michigan | 26117 | 1502 | 21 |
746487 | 746487 | 2020-11-19 | Montcalm | Michigan | 26117 | 1455 | 21 |
743240 | 743240 | 2020-11-18 | Montcalm | Michigan | 26117 | 1407 | 21 |
739993 | 739993 | 2020-11-17 | Montcalm | Michigan | 26117 | 1379 | 19 |
736749 | 736749 | 2020-11-16 | Montcalm | Michigan | 26117 | 1337 | 17 |
733503 | 733503 | 2020-11-15 | Montcalm | Michigan | 26117 | 1259 | 16 |
730258 | 730258 | 2020-11-14 | Montcalm | Michigan | 26117 | 1259 | 16 |
727015 | 727015 | 2020-11-13 | Montcalm | Michigan | 26117 | 1215 | 16 |
723772 | 723772 | 2020-11-12 | Montcalm | Michigan | 26117 | 1151 | 16 |
720529 | 720529 | 2020-11-11 | Montcalm | Michigan | 26117 | 1107 | 16 |
717286 | 717286 | 2020-11-10 | Montcalm | Michigan | 26117 | 1080 | 16 |
714042 | 714042 | 2020-11-09 | Montcalm | Michigan | 26117 | 1042 | 15 |
710798 | 710798 | 2020-11-08 | Montcalm | Michigan | 26117 | 978 | 15 |
707554 | 707554 | 2020-11-07 | Montcalm | Michigan | 26117 | 978 | 15 |
704311 | 704311 | 2020-11-06 | Montcalm | Michigan | 26117 | 938 | 14 |
701069 | 701069 | 2020-11-05 | Montcalm | Michigan | 26117 | 920 | 13 |
697825 | 697825 | 2020-11-04 | Montcalm | Michigan | 26117 | 888 | 13 |
694582 | 694582 | 2020-11-03 | Montcalm | Michigan | 26117 | 853 | 13 |
691340 | 691340 | 2020-11-02 | Montcalm | Michigan | 26117 | 840 | 12 |
688095 | 688095 | 2020-11-01 | Montcalm | Michigan | 26117 | 792 | 12 |
684851 | 684851 | 2020-10-31 | Montcalm | Michigan | 26117 | 792 | 12 |
681608 | 681608 | 2020-10-30 | Montcalm | Michigan | 26117 | 755 | 13 |
678364 | 678364 | 2020-10-29 | Montcalm | Michigan | 26117 | 719 | 13 |
675122 | 675122 | 2020-10-28 | Montcalm | Michigan | 26117 | 682 | 13 |
671879 | 671879 | 2020-10-27 | Montcalm | Michigan | 26117 | 647 | 13 |
668637 | 668637 | 2020-10-26 | Montcalm | Michigan | 26117 | 631 | 11 |
665393 | 665393 | 2020-10-25 | Montcalm | Michigan | 26117 | 604 | 10 |
662148 | 662148 | 2020-10-24 | Montcalm | Michigan | 26117 | 604 | 10 |
658904 | 658904 | 2020-10-23 | Montcalm | Michigan | 26117 | 566 | 10 |
655659 | 655659 | 2020-10-22 | Montcalm | Michigan | 26117 | 562 | 9 |
652414 | 652414 | 2020-10-21 | Montcalm | Michigan | 26117 | 551 | 8 |
649169 | 649169 | 2020-10-20 | Montcalm | Michigan | 26117 | 523 | 8 |
645925 | 645925 | 2020-10-19 | Montcalm | Michigan | 26117 | 519 | 8 |
642678 | 642678 | 2020-10-18 | Montcalm | Michigan | 26117 | 464 | 8 |
639431 | 639431 | 2020-10-17 | Montcalm | Michigan | 26117 | 464 | 8 |
636185 | 636185 | 2020-10-16 | Montcalm | Michigan | 26117 | 464 | 8 |
632939 | 632939 | 2020-10-15 | Montcalm | Michigan | 26117 | 456 | 7 |
629694 | 629694 | 2020-10-14 | Montcalm | Michigan | 26117 | 436 | 7 |
626450 | 626450 | 2020-10-13 | Montcalm | Michigan | 26117 | 430 | 7 |
623208 | 623208 | 2020-10-12 | Montcalm | Michigan | 26117 | 416 | 7 |
619965 | 619965 | 2020-10-11 | Montcalm | Michigan | 26117 | 394 | 7 |
616723 | 616723 | 2020-10-10 | Montcalm | Michigan | 26117 | 394 | 7 |
613482 | 613482 | 2020-10-09 | Montcalm | Michigan | 26117 | 391 | 7 |
610240 | 610240 | 2020-10-08 | Montcalm | Michigan | 26117 | 387 | 7 |
606998 | 606998 | 2020-10-07 | Montcalm | Michigan | 26117 | 382 | 7 |
603755 | 603755 | 2020-10-06 | Montcalm | Michigan | 26117 | 378 | 7 |
600513 | 600513 | 2020-10-05 | Montcalm | Michigan | 26117 | 374 | 7 |
597270 | 597270 | 2020-10-04 | Montcalm | Michigan | 26117 | 363 | 7 |
594029 | 594029 | 2020-10-03 | Montcalm | Michigan | 26117 | 363 | 7 |
590788 | 590788 | 2020-10-02 | Montcalm | Michigan | 26117 | 358 | 7 |
587547 | 587547 | 2020-10-01 | Montcalm | Michigan | 26117 | 349 | 7 |
584307 | 584307 | 2020-09-30 | Montcalm | Michigan | 26117 | 344 | 6 |
581066 | 581066 | 2020-09-29 | Montcalm | Michigan | 26117 | 340 | 6 |
577825 | 577825 | 2020-09-28 | Montcalm | Michigan | 26117 | 327 | 6 |
574584 | 574584 | 2020-09-27 | Montcalm | Michigan | 26117 | 317 | 6 |
571341 | 571341 | 2020-09-26 | Montcalm | Michigan | 26117 | 317 | 6 |
568099 | 568099 | 2020-09-25 | Montcalm | Michigan | 26117 | 314 | 5 |
564859 | 564859 | 2020-09-24 | Montcalm | Michigan | 26117 | 310 | 5 |
561619 | 561619 | 2020-09-23 | Montcalm | Michigan | 26117 | 306 | 5 |
558382 | 558382 | 2020-09-22 | Montcalm | Michigan | 26117 | 302 | 5 |
555145 | 555145 | 2020-09-21 | Montcalm | Michigan | 26117 | 296 | 5 |
551907 | 551907 | 2020-09-20 | Montcalm | Michigan | 26117 | 291 | 5 |
548668 | 548668 | 2020-09-19 | Montcalm | Michigan | 26117 | 291 | 5 |
545430 | 545430 | 2020-09-18 | Montcalm | Michigan | 26117 | 287 | 5 |
542193 | 542193 | 2020-09-17 | Montcalm | Michigan | 26117 | 280 | 5 |
538957 | 538957 | 2020-09-16 | Montcalm | Michigan | 26117 | 277 | 4 |
535720 | 535720 | 2020-09-15 | Montcalm | Michigan | 26117 | 275 | 4 |
532485 | 532485 | 2020-09-14 | Montcalm | Michigan | 26117 | 272 | 4 |
529249 | 529249 | 2020-09-13 | Montcalm | Michigan | 26117 | 259 | 4 |
526013 | 526013 | 2020-09-12 | Montcalm | Michigan | 26117 | 259 | 4 |
522777 | 522777 | 2020-09-11 | Montcalm | Michigan | 26117 | 260 | 4 |
519540 | 519540 | 2020-09-10 | Montcalm | Michigan | 26117 | 255 | 4 |
516305 | 516305 | 2020-09-09 | Montcalm | Michigan | 26117 | 252 | 4 |
513071 | 513071 | 2020-09-08 | Montcalm | Michigan | 26117 | 251 | 4 |
509839 | 509839 | 2020-09-07 | Montcalm | Michigan | 26117 | 248 | 4 |
506606 | 506606 | 2020-09-06 | Montcalm | Michigan | 26117 | 243 | 4 |
503373 | 503373 | 2020-09-05 | Montcalm | Michigan | 26117 | 243 | 4 |
500139 | 500139 | 2020-09-04 | Montcalm | Michigan | 26117 | 240 | 4 |
496905 | 496905 | 2020-09-03 | Montcalm | Michigan | 26117 | 237 | 4 |
493672 | 493672 | 2020-09-02 | Montcalm | Michigan | 26117 | 230 | 4 |
490438 | 490438 | 2020-09-01 | Montcalm | Michigan | 26117 | 232 | 4 |
487205 | 487205 | 2020-08-31 | Montcalm | Michigan | 26117 | 226 | 4 |
483971 | 483971 | 2020-08-30 | Montcalm | Michigan | 26117 | 227 | 4 |
480736 | 480736 | 2020-08-29 | Montcalm | Michigan | 26117 | 224 | 3 |
477504 | 477504 | 2020-08-28 | Montcalm | Michigan | 26117 | 222 | 3 |
474271 | 474271 | 2020-08-27 | Montcalm | Michigan | 26117 | 219 | 3 |
471039 | 471039 | 2020-08-26 | Montcalm | Michigan | 26117 | 217 | 3 |
467809 | 467809 | 2020-08-25 | Montcalm | Michigan | 26117 | 216 | 3 |
464580 | 464580 | 2020-08-24 | Montcalm | Michigan | 26117 | 213 | 3 |
461349 | 461349 | 2020-08-23 | Montcalm | Michigan | 26117 | 213 | 3 |
458122 | 458122 | 2020-08-22 | Montcalm | Michigan | 26117 | 212 | 3 |
454894 | 454894 | 2020-08-21 | Montcalm | Michigan | 26117 | 209 | 3 |
451666 | 451666 | 2020-08-20 | Montcalm | Michigan | 26117 | 209 | 3 |
448438 | 448438 | 2020-08-19 | Montcalm | Michigan | 26117 | 209 | 3 |
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);