ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 26057 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921708 | 921708 | 2021-01-12 | Gratiot | Michigan | 26057 | 4263 | 88 |
918463 | 918463 | 2021-01-11 | Gratiot | Michigan | 26057 | 4251 | 87 |
915218 | 915218 | 2021-01-10 | Gratiot | Michigan | 26057 | 4233 | 84 |
911973 | 911973 | 2021-01-09 | Gratiot | Michigan | 26057 | 4233 | 84 |
908728 | 908728 | 2021-01-08 | Gratiot | Michigan | 26057 | 4211 | 84 |
905482 | 905482 | 2021-01-07 | Gratiot | Michigan | 26057 | 4198 | 84 |
902237 | 902237 | 2021-01-06 | Gratiot | Michigan | 26057 | 4176 | 82 |
898992 | 898992 | 2021-01-05 | Gratiot | Michigan | 26057 | 4162 | 82 |
895747 | 895747 | 2021-01-04 | Gratiot | Michigan | 26057 | 4143 | 81 |
892500 | 892500 | 2021-01-03 | Gratiot | Michigan | 26057 | 4120 | 81 |
889254 | 889254 | 2021-01-02 | Gratiot | Michigan | 26057 | 4120 | 81 |
886008 | 886008 | 2021-01-01 | Gratiot | Michigan | 26057 | 4148 | 71 |
882763 | 882763 | 2020-12-31 | Gratiot | Michigan | 26057 | 4148 | 71 |
879518 | 879518 | 2020-12-30 | Gratiot | Michigan | 26057 | 4148 | 71 |
876273 | 876273 | 2020-12-29 | Gratiot | Michigan | 26057 | 4087 | 69 |
873028 | 873028 | 2020-12-28 | Gratiot | Michigan | 26057 | 4073 | 66 |
869783 | 869783 | 2020-12-27 | Gratiot | Michigan | 26057 | 4070 | 66 |
866538 | 866538 | 2020-12-26 | Gratiot | Michigan | 26057 | 4070 | 66 |
863293 | 863293 | 2020-12-25 | Gratiot | Michigan | 26057 | 4050 | 62 |
860048 | 860048 | 2020-12-24 | Gratiot | Michigan | 26057 | 4050 | 62 |
856803 | 856803 | 2020-12-23 | Gratiot | Michigan | 26057 | 4050 | 62 |
853558 | 853558 | 2020-12-22 | Gratiot | Michigan | 26057 | 4036 | 62 |
850313 | 850313 | 2020-12-21 | Gratiot | Michigan | 26057 | 4028 | 60 |
847068 | 847068 | 2020-12-20 | Gratiot | Michigan | 26057 | 3981 | 60 |
843822 | 843822 | 2020-12-19 | Gratiot | Michigan | 26057 | 3981 | 60 |
840577 | 840577 | 2020-12-18 | Gratiot | Michigan | 26057 | 3952 | 57 |
837332 | 837332 | 2020-12-17 | Gratiot | Michigan | 26057 | 3914 | 55 |
834086 | 834086 | 2020-12-16 | Gratiot | Michigan | 26057 | 3893 | 54 |
830839 | 830839 | 2020-12-15 | Gratiot | Michigan | 26057 | 3853 | 52 |
827593 | 827593 | 2020-12-14 | Gratiot | Michigan | 26057 | 3824 | 50 |
824346 | 824346 | 2020-12-13 | Gratiot | Michigan | 26057 | 3763 | 50 |
821100 | 821100 | 2020-12-12 | Gratiot | Michigan | 26057 | 3763 | 50 |
817854 | 817854 | 2020-12-11 | Gratiot | Michigan | 26057 | 3758 | 47 |
814608 | 814608 | 2020-12-10 | Gratiot | Michigan | 26057 | 3702 | 46 |
811363 | 811363 | 2020-12-09 | Gratiot | Michigan | 26057 | 3658 | 44 |
808118 | 808118 | 2020-12-08 | Gratiot | Michigan | 26057 | 3630 | 44 |
804873 | 804873 | 2020-12-07 | Gratiot | Michigan | 26057 | 3598 | 44 |
801628 | 801628 | 2020-12-06 | Gratiot | Michigan | 26057 | 3545 | 42 |
798383 | 798383 | 2020-12-05 | Gratiot | Michigan | 26057 | 3545 | 42 |
795138 | 795138 | 2020-12-04 | Gratiot | Michigan | 26057 | 3526 | 39 |
791893 | 791893 | 2020-12-03 | Gratiot | Michigan | 26057 | 2116 | 36 |
788648 | 788648 | 2020-12-02 | Gratiot | Michigan | 26057 | 1782 | 31 |
785403 | 785403 | 2020-12-01 | Gratiot | Michigan | 26057 | 1681 | 31 |
782159 | 782159 | 2020-11-30 | Gratiot | Michigan | 26057 | 1643 | 31 |
778913 | 778913 | 2020-11-29 | Gratiot | Michigan | 26057 | 1574 | 29 |
775668 | 775668 | 2020-11-28 | Gratiot | Michigan | 26057 | 1574 | 29 |
772423 | 772423 | 2020-11-27 | Gratiot | Michigan | 26057 | 1595 | 29 |
769178 | 769178 | 2020-11-26 | Gratiot | Michigan | 26057 | 1463 | 29 |
765932 | 765932 | 2020-11-25 | Gratiot | Michigan | 26057 | 1463 | 29 |
762687 | 762687 | 2020-11-24 | Gratiot | Michigan | 26057 | 1428 | 29 |
759442 | 759442 | 2020-11-23 | Gratiot | Michigan | 26057 | 1377 | 28 |
756195 | 756195 | 2020-11-22 | Gratiot | Michigan | 26057 | 1351 | 27 |
752949 | 752949 | 2020-11-21 | Gratiot | Michigan | 26057 | 1351 | 27 |
749703 | 749703 | 2020-11-20 | Gratiot | Michigan | 26057 | 1602 | 25 |
746457 | 746457 | 2020-11-19 | Gratiot | Michigan | 26057 | 1248 | 24 |
743210 | 743210 | 2020-11-18 | Gratiot | Michigan | 26057 | 1203 | 23 |
739963 | 739963 | 2020-11-17 | Gratiot | Michigan | 26057 | 1182 | 21 |
736719 | 736719 | 2020-11-16 | Gratiot | Michigan | 26057 | 1135 | 21 |
733473 | 733473 | 2020-11-15 | Gratiot | Michigan | 26057 | 1065 | 21 |
730228 | 730228 | 2020-11-14 | Gratiot | Michigan | 26057 | 1065 | 21 |
726985 | 726985 | 2020-11-13 | Gratiot | Michigan | 26057 | 1087 | 21 |
723742 | 723742 | 2020-11-12 | Gratiot | Michigan | 26057 | 943 | 20 |
720499 | 720499 | 2020-11-11 | Gratiot | Michigan | 26057 | 886 | 20 |
717256 | 717256 | 2020-11-10 | Gratiot | Michigan | 26057 | 875 | 20 |
714012 | 714012 | 2020-11-09 | Gratiot | Michigan | 26057 | 865 | 20 |
710768 | 710768 | 2020-11-08 | Gratiot | Michigan | 26057 | 857 | 18 |
707524 | 707524 | 2020-11-07 | Gratiot | Michigan | 26057 | 857 | 18 |
704281 | 704281 | 2020-11-06 | Gratiot | Michigan | 26057 | 751 | 17 |
701039 | 701039 | 2020-11-05 | Gratiot | Michigan | 26057 | 730 | 17 |
697795 | 697795 | 2020-11-04 | Gratiot | Michigan | 26057 | 715 | 17 |
694552 | 694552 | 2020-11-03 | Gratiot | Michigan | 26057 | 667 | 17 |
691310 | 691310 | 2020-11-02 | Gratiot | Michigan | 26057 | 640 | 17 |
688065 | 688065 | 2020-11-01 | Gratiot | Michigan | 26057 | 600 | 17 |
684821 | 684821 | 2020-10-31 | Gratiot | Michigan | 26057 | 600 | 17 |
681578 | 681578 | 2020-10-30 | Gratiot | Michigan | 26057 | 591 | 17 |
678334 | 678334 | 2020-10-29 | Gratiot | Michigan | 26057 | 568 | 17 |
675092 | 675092 | 2020-10-28 | Gratiot | Michigan | 26057 | 539 | 17 |
671849 | 671849 | 2020-10-27 | Gratiot | Michigan | 26057 | 520 | 16 |
668607 | 668607 | 2020-10-26 | Gratiot | Michigan | 26057 | 505 | 16 |
665363 | 665363 | 2020-10-25 | Gratiot | Michigan | 26057 | 475 | 16 |
662118 | 662118 | 2020-10-24 | Gratiot | Michigan | 26057 | 475 | 16 |
658874 | 658874 | 2020-10-23 | Gratiot | Michigan | 26057 | 451 | 16 |
655629 | 655629 | 2020-10-22 | Gratiot | Michigan | 26057 | 440 | 16 |
652384 | 652384 | 2020-10-21 | Gratiot | Michigan | 26057 | 431 | 16 |
649139 | 649139 | 2020-10-20 | Gratiot | Michigan | 26057 | 423 | 16 |
645895 | 645895 | 2020-10-19 | Gratiot | Michigan | 26057 | 415 | 16 |
642648 | 642648 | 2020-10-18 | Gratiot | Michigan | 26057 | 395 | 16 |
639401 | 639401 | 2020-10-17 | Gratiot | Michigan | 26057 | 395 | 16 |
636155 | 636155 | 2020-10-16 | Gratiot | Michigan | 26057 | 395 | 16 |
632909 | 632909 | 2020-10-15 | Gratiot | Michigan | 26057 | 395 | 16 |
629664 | 629664 | 2020-10-14 | Gratiot | Michigan | 26057 | 383 | 16 |
626420 | 626420 | 2020-10-13 | Gratiot | Michigan | 26057 | 372 | 16 |
623178 | 623178 | 2020-10-12 | Gratiot | Michigan | 26057 | 359 | 16 |
619935 | 619935 | 2020-10-11 | Gratiot | Michigan | 26057 | 350 | 16 |
616693 | 616693 | 2020-10-10 | Gratiot | Michigan | 26057 | 350 | 16 |
613452 | 613452 | 2020-10-09 | Gratiot | Michigan | 26057 | 337 | 16 |
610210 | 610210 | 2020-10-08 | Gratiot | Michigan | 26057 | 327 | 16 |
606968 | 606968 | 2020-10-07 | Gratiot | Michigan | 26057 | 320 | 16 |
603725 | 603725 | 2020-10-06 | Gratiot | Michigan | 26057 | 318 | 16 |
600483 | 600483 | 2020-10-05 | Gratiot | Michigan | 26057 | 314 | 16 |
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);