ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26017 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921688 | 921688 | 2021-01-12 | Bay | Michigan | 26017 | 6726 | 223 |
918443 | 918443 | 2021-01-11 | Bay | Michigan | 26017 | 6711 | 218 |
915198 | 915198 | 2021-01-10 | Bay | Michigan | 26017 | 6654 | 218 |
911953 | 911953 | 2021-01-09 | Bay | Michigan | 26017 | 6654 | 218 |
908708 | 908708 | 2021-01-08 | Bay | Michigan | 26017 | 6619 | 208 |
905462 | 905462 | 2021-01-07 | Bay | Michigan | 26017 | 6577 | 207 |
902217 | 902217 | 2021-01-06 | Bay | Michigan | 26017 | 6503 | 201 |
898972 | 898972 | 2021-01-05 | Bay | Michigan | 26017 | 6426 | 199 |
895727 | 895727 | 2021-01-04 | Bay | Michigan | 26017 | 6411 | 193 |
892480 | 892480 | 2021-01-03 | Bay | Michigan | 26017 | 6358 | 193 |
889234 | 889234 | 2021-01-02 | Bay | Michigan | 26017 | 6358 | 193 |
885988 | 885988 | 2021-01-01 | Bay | Michigan | 26017 | 6219 | 187 |
882743 | 882743 | 2020-12-31 | Bay | Michigan | 26017 | 6219 | 187 |
879498 | 879498 | 2020-12-30 | Bay | Michigan | 26017 | 6219 | 187 |
876253 | 876253 | 2020-12-29 | Bay | Michigan | 26017 | 6163 | 186 |
873008 | 873008 | 2020-12-28 | Bay | Michigan | 26017 | 6122 | 180 |
869763 | 869763 | 2020-12-27 | Bay | Michigan | 26017 | 6075 | 180 |
866518 | 866518 | 2020-12-26 | Bay | Michigan | 26017 | 6075 | 180 |
863273 | 863273 | 2020-12-25 | Bay | Michigan | 26017 | 5962 | 173 |
860028 | 860028 | 2020-12-24 | Bay | Michigan | 26017 | 5962 | 173 |
856783 | 856783 | 2020-12-23 | Bay | Michigan | 26017 | 5962 | 173 |
853538 | 853538 | 2020-12-22 | Bay | Michigan | 26017 | 5904 | 173 |
850293 | 850293 | 2020-12-21 | Bay | Michigan | 26017 | 5888 | 164 |
847048 | 847048 | 2020-12-20 | Bay | Michigan | 26017 | 5818 | 164 |
843802 | 843802 | 2020-12-19 | Bay | Michigan | 26017 | 5818 | 164 |
840557 | 840557 | 2020-12-18 | Bay | Michigan | 26017 | 5744 | 159 |
837312 | 837312 | 2020-12-17 | Bay | Michigan | 26017 | 5676 | 157 |
834066 | 834066 | 2020-12-16 | Bay | Michigan | 26017 | 5613 | 154 |
830819 | 830819 | 2020-12-15 | Bay | Michigan | 26017 | 5556 | 150 |
827573 | 827573 | 2020-12-14 | Bay | Michigan | 26017 | 5494 | 146 |
824326 | 824326 | 2020-12-13 | Bay | Michigan | 26017 | 5409 | 141 |
821080 | 821080 | 2020-12-12 | Bay | Michigan | 26017 | 5409 | 141 |
817834 | 817834 | 2020-12-11 | Bay | Michigan | 26017 | 5377 | 133 |
814588 | 814588 | 2020-12-10 | Bay | Michigan | 26017 | 5325 | 133 |
811343 | 811343 | 2020-12-09 | Bay | Michigan | 26017 | 5241 | 128 |
808098 | 808098 | 2020-12-08 | Bay | Michigan | 26017 | 5175 | 127 |
804853 | 804853 | 2020-12-07 | Bay | Michigan | 26017 | 5129 | 120 |
801608 | 801608 | 2020-12-06 | Bay | Michigan | 26017 | 4969 | 119 |
798363 | 798363 | 2020-12-05 | Bay | Michigan | 26017 | 4969 | 119 |
795118 | 795118 | 2020-12-04 | Bay | Michigan | 26017 | 4898 | 111 |
791873 | 791873 | 2020-12-03 | Bay | Michigan | 26017 | 4773 | 111 |
788628 | 788628 | 2020-12-02 | Bay | Michigan | 26017 | 4643 | 107 |
785383 | 785383 | 2020-12-01 | Bay | Michigan | 26017 | 4599 | 98 |
782139 | 782139 | 2020-11-30 | Bay | Michigan | 26017 | 4535 | 92 |
778893 | 778893 | 2020-11-29 | Bay | Michigan | 26017 | 4378 | 91 |
775648 | 775648 | 2020-11-28 | Bay | Michigan | 26017 | 4378 | 91 |
772403 | 772403 | 2020-11-27 | Bay | Michigan | 26017 | 4277 | 89 |
769158 | 769158 | 2020-11-26 | Bay | Michigan | 26017 | 4029 | 89 |
765912 | 765912 | 2020-11-25 | Bay | Michigan | 26017 | 4029 | 89 |
762667 | 762667 | 2020-11-24 | Bay | Michigan | 26017 | 3935 | 88 |
759422 | 759422 | 2020-11-23 | Bay | Michigan | 26017 | 3852 | 83 |
756175 | 756175 | 2020-11-22 | Bay | Michigan | 26017 | 3634 | 81 |
752929 | 752929 | 2020-11-21 | Bay | Michigan | 26017 | 3634 | 81 |
749683 | 749683 | 2020-11-20 | Bay | Michigan | 26017 | 3500 | 80 |
746437 | 746437 | 2020-11-19 | Bay | Michigan | 26017 | 3390 | 80 |
743190 | 743190 | 2020-11-18 | Bay | Michigan | 26017 | 3315 | 79 |
739943 | 739943 | 2020-11-17 | Bay | Michigan | 26017 | 3186 | 79 |
736699 | 736699 | 2020-11-16 | Bay | Michigan | 26017 | 3048 | 78 |
733453 | 733453 | 2020-11-15 | Bay | Michigan | 26017 | 2846 | 80 |
730208 | 730208 | 2020-11-14 | Bay | Michigan | 26017 | 2846 | 80 |
726965 | 726965 | 2020-11-13 | Bay | Michigan | 26017 | 2697 | 79 |
723722 | 723722 | 2020-11-12 | Bay | Michigan | 26017 | 2584 | 76 |
720479 | 720479 | 2020-11-11 | Bay | Michigan | 26017 | 2453 | 73 |
717236 | 717236 | 2020-11-10 | Bay | Michigan | 26017 | 2352 | 72 |
713992 | 713992 | 2020-11-09 | Bay | Michigan | 26017 | 2216 | 71 |
710748 | 710748 | 2020-11-08 | Bay | Michigan | 26017 | 2084 | 68 |
707504 | 707504 | 2020-11-07 | Bay | Michigan | 26017 | 2084 | 68 |
704261 | 704261 | 2020-11-06 | Bay | Michigan | 26017 | 1938 | 68 |
701019 | 701019 | 2020-11-05 | Bay | Michigan | 26017 | 1892 | 68 |
697775 | 697775 | 2020-11-04 | Bay | Michigan | 26017 | 1825 | 66 |
694532 | 694532 | 2020-11-03 | Bay | Michigan | 26017 | 1762 | 66 |
691290 | 691290 | 2020-11-02 | Bay | Michigan | 26017 | 1706 | 66 |
688045 | 688045 | 2020-11-01 | Bay | Michigan | 26017 | 1602 | 65 |
684801 | 684801 | 2020-10-31 | Bay | Michigan | 26017 | 1602 | 65 |
681558 | 681558 | 2020-10-30 | Bay | Michigan | 26017 | 1525 | 63 |
678314 | 678314 | 2020-10-29 | Bay | Michigan | 26017 | 1480 | 62 |
675072 | 675072 | 2020-10-28 | Bay | Michigan | 26017 | 1433 | 62 |
671829 | 671829 | 2020-10-27 | Bay | Michigan | 26017 | 1404 | 62 |
668587 | 668587 | 2020-10-26 | Bay | Michigan | 26017 | 1390 | 62 |
665343 | 665343 | 2020-10-25 | Bay | Michigan | 26017 | 1347 | 62 |
662098 | 662098 | 2020-10-24 | Bay | Michigan | 26017 | 1347 | 62 |
658854 | 658854 | 2020-10-23 | Bay | Michigan | 26017 | 1312 | 60 |
655609 | 655609 | 2020-10-22 | Bay | Michigan | 26017 | 1288 | 59 |
652364 | 652364 | 2020-10-21 | Bay | Michigan | 26017 | 1260 | 57 |
649119 | 649119 | 2020-10-20 | Bay | Michigan | 26017 | 1254 | 55 |
645875 | 645875 | 2020-10-19 | Bay | Michigan | 26017 | 1246 | 55 |
642628 | 642628 | 2020-10-18 | Bay | Michigan | 26017 | 1199 | 55 |
639381 | 639381 | 2020-10-17 | Bay | Michigan | 26017 | 1199 | 55 |
636135 | 636135 | 2020-10-16 | Bay | Michigan | 26017 | 1199 | 55 |
632889 | 632889 | 2020-10-15 | Bay | Michigan | 26017 | 1187 | 55 |
629644 | 629644 | 2020-10-14 | Bay | Michigan | 26017 | 1158 | 55 |
626400 | 626400 | 2020-10-13 | Bay | Michigan | 26017 | 1151 | 55 |
623158 | 623158 | 2020-10-12 | Bay | Michigan | 26017 | 1138 | 54 |
619915 | 619915 | 2020-10-11 | Bay | Michigan | 26017 | 1103 | 54 |
616673 | 616673 | 2020-10-10 | Bay | Michigan | 26017 | 1103 | 54 |
613432 | 613432 | 2020-10-09 | Bay | Michigan | 26017 | 1099 | 54 |
610190 | 610190 | 2020-10-08 | Bay | Michigan | 26017 | 1091 | 54 |
606948 | 606948 | 2020-10-07 | Bay | Michigan | 26017 | 1075 | 53 |
603705 | 603705 | 2020-10-06 | Bay | Michigan | 26017 | 1065 | 53 |
600463 | 600463 | 2020-10-05 | Bay | Michigan | 26017 | 1062 | 52 |
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);