ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26147 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947719 | 947719 | 2021-01-20 | St. Clair | Michigan | 26147 | 7980 | 208 |
944472 | 944472 | 2021-01-19 | St. Clair | Michigan | 26147 | 7931 | 206 |
941227 | 941227 | 2021-01-18 | St. Clair | Michigan | 26147 | 7909 | 205 |
937982 | 937982 | 2021-01-17 | St. Clair | Michigan | 26147 | 7886 | 204 |
934737 | 934737 | 2021-01-16 | St. Clair | Michigan | 26147 | 7879 | 204 |
931492 | 931492 | 2021-01-15 | St. Clair | Michigan | 26147 | 7855 | 205 |
928247 | 928247 | 2021-01-14 | St. Clair | Michigan | 26147 | 7805 | 204 |
925001 | 925001 | 2021-01-13 | St. Clair | Michigan | 26147 | 7763 | 198 |
921756 | 921756 | 2021-01-12 | St. Clair | Michigan | 26147 | 7724 | 198 |
918511 | 918511 | 2021-01-11 | St. Clair | Michigan | 26147 | 7672 | 193 |
915266 | 915266 | 2021-01-10 | St. Clair | Michigan | 26147 | 7615 | 192 |
912021 | 912021 | 2021-01-09 | St. Clair | Michigan | 26147 | 7585 | 192 |
908776 | 908776 | 2021-01-08 | St. Clair | Michigan | 26147 | 7521 | 184 |
905530 | 905530 | 2021-01-07 | St. Clair | Michigan | 26147 | 7457 | 181 |
902285 | 902285 | 2021-01-06 | St. Clair | Michigan | 26147 | 7406 | 176 |
899040 | 899040 | 2021-01-05 | St. Clair | Michigan | 26147 | 7327 | 175 |
895795 | 895795 | 2021-01-04 | St. Clair | Michigan | 26147 | 7262 | 173 |
892548 | 892548 | 2021-01-03 | St. Clair | Michigan | 26147 | 7205 | 171 |
889302 | 889302 | 2021-01-02 | St. Clair | Michigan | 26147 | 7170 | 171 |
886056 | 886056 | 2021-01-01 | St. Clair | Michigan | 26147 | 7133 | 161 |
882811 | 882811 | 2020-12-31 | St. Clair | Michigan | 26147 | 7088 | 160 |
879566 | 879566 | 2020-12-30 | St. Clair | Michigan | 26147 | 7026 | 158 |
876321 | 876321 | 2020-12-29 | St. Clair | Michigan | 26147 | 6918 | 155 |
873076 | 873076 | 2020-12-28 | St. Clair | Michigan | 26147 | 6841 | 151 |
869831 | 869831 | 2020-12-27 | St. Clair | Michigan | 26147 | 6821 | 151 |
866586 | 866586 | 2020-12-26 | St. Clair | Michigan | 26147 | 6798 | 151 |
863341 | 863341 | 2020-12-25 | St. Clair | Michigan | 26147 | 6755 | 146 |
860096 | 860096 | 2020-12-24 | St. Clair | Michigan | 26147 | 6725 | 146 |
856851 | 856851 | 2020-12-23 | St. Clair | Michigan | 26147 | 6677 | 146 |
853606 | 853606 | 2020-12-22 | St. Clair | Michigan | 26147 | 6605 | 142 |
850361 | 850361 | 2020-12-21 | St. Clair | Michigan | 26147 | 6536 | 134 |
847116 | 847116 | 2020-12-20 | St. Clair | Michigan | 26147 | 6467 | 134 |
843870 | 843870 | 2020-12-19 | St. Clair | Michigan | 26147 | 6443 | 134 |
840625 | 840625 | 2020-12-18 | St. Clair | Michigan | 26147 | 6397 | 134 |
837380 | 837380 | 2020-12-17 | St. Clair | Michigan | 26147 | 6326 | 132 |
834134 | 834134 | 2020-12-16 | St. Clair | Michigan | 26147 | 6259 | 127 |
830887 | 830887 | 2020-12-15 | St. Clair | Michigan | 26147 | 6153 | 126 |
827641 | 827641 | 2020-12-14 | St. Clair | Michigan | 26147 | 6085 | 119 |
824394 | 824394 | 2020-12-13 | St. Clair | Michigan | 26147 | 6028 | 117 |
821148 | 821148 | 2020-12-12 | St. Clair | Michigan | 26147 | 5988 | 117 |
817902 | 817902 | 2020-12-11 | St. Clair | Michigan | 26147 | 5910 | 116 |
814656 | 814656 | 2020-12-10 | St. Clair | Michigan | 26147 | 5821 | 113 |
811411 | 811411 | 2020-12-09 | St. Clair | Michigan | 26147 | 5692 | 109 |
808166 | 808166 | 2020-12-08 | St. Clair | Michigan | 26147 | 5589 | 107 |
804921 | 804921 | 2020-12-07 | St. Clair | Michigan | 26147 | 5480 | 106 |
801676 | 801676 | 2020-12-06 | St. Clair | Michigan | 26147 | 5324 | 106 |
798431 | 798431 | 2020-12-05 | St. Clair | Michigan | 26147 | 5260 | 106 |
795186 | 795186 | 2020-12-04 | St. Clair | Michigan | 26147 | 5129 | 104 |
791941 | 791941 | 2020-12-03 | St. Clair | Michigan | 26147 | 4979 | 103 |
788696 | 788696 | 2020-12-02 | St. Clair | Michigan | 26147 | 4864 | 102 |
785451 | 785451 | 2020-12-01 | St. Clair | Michigan | 26147 | 4732 | 100 |
782207 | 782207 | 2020-11-30 | St. Clair | Michigan | 26147 | 4535 | 83 |
778961 | 778961 | 2020-11-29 | St. Clair | Michigan | 26147 | 4438 | 83 |
775716 | 775716 | 2020-11-28 | St. Clair | Michigan | 26147 | 4373 | 83 |
772471 | 772471 | 2020-11-27 | St. Clair | Michigan | 26147 | 4274 | 82 |
769226 | 769226 | 2020-11-26 | St. Clair | Michigan | 26147 | 4117 | 79 |
765980 | 765980 | 2020-11-25 | St. Clair | Michigan | 26147 | 4007 | 78 |
762735 | 762735 | 2020-11-24 | St. Clair | Michigan | 26147 | 3916 | 78 |
759490 | 759490 | 2020-11-23 | St. Clair | Michigan | 26147 | 3842 | 78 |
756243 | 756243 | 2020-11-22 | St. Clair | Michigan | 26147 | 3707 | 78 |
752997 | 752997 | 2020-11-21 | St. Clair | Michigan | 26147 | 3620 | 78 |
749751 | 749751 | 2020-11-20 | St. Clair | Michigan | 26147 | 3527 | 76 |
746505 | 746505 | 2020-11-19 | St. Clair | Michigan | 26147 | 3364 | 76 |
743258 | 743258 | 2020-11-18 | St. Clair | Michigan | 26147 | 3223 | 74 |
740011 | 740011 | 2020-11-17 | St. Clair | Michigan | 26147 | 3140 | 74 |
736767 | 736767 | 2020-11-16 | St. Clair | Michigan | 26147 | 3008 | 71 |
733521 | 733521 | 2020-11-15 | St. Clair | Michigan | 26147 | 2897 | 71 |
730276 | 730276 | 2020-11-14 | St. Clair | Michigan | 26147 | 2822 | 71 |
727033 | 727033 | 2020-11-13 | St. Clair | Michigan | 26147 | 2687 | 70 |
723790 | 723790 | 2020-11-12 | St. Clair | Michigan | 26147 | 2567 | 68 |
720547 | 720547 | 2020-11-11 | St. Clair | Michigan | 26147 | 2459 | 68 |
717304 | 717304 | 2020-11-10 | St. Clair | Michigan | 26147 | 2331 | 68 |
714060 | 714060 | 2020-11-09 | St. Clair | Michigan | 26147 | 2229 | 68 |
710816 | 710816 | 2020-11-08 | St. Clair | Michigan | 26147 | 2174 | 68 |
707572 | 707572 | 2020-11-07 | St. Clair | Michigan | 26147 | 2121 | 68 |
704329 | 704329 | 2020-11-06 | St. Clair | Michigan | 26147 | 2046 | 68 |
701087 | 701087 | 2020-11-05 | St. Clair | Michigan | 26147 | 2006 | 66 |
697843 | 697843 | 2020-11-04 | St. Clair | Michigan | 26147 | 1894 | 66 |
694600 | 694600 | 2020-11-03 | St. Clair | Michigan | 26147 | 1853 | 66 |
691358 | 691358 | 2020-11-02 | St. Clair | Michigan | 26147 | 1801 | 65 |
688113 | 688113 | 2020-11-01 | St. Clair | Michigan | 26147 | 1764 | 65 |
684869 | 684869 | 2020-10-31 | St. Clair | Michigan | 26147 | 1727 | 65 |
681626 | 681626 | 2020-10-30 | St. Clair | Michigan | 26147 | 1686 | 65 |
678382 | 678382 | 2020-10-29 | St. Clair | Michigan | 26147 | 1658 | 65 |
675140 | 675140 | 2020-10-28 | St. Clair | Michigan | 26147 | 1594 | 65 |
671897 | 671897 | 2020-10-27 | St. Clair | Michigan | 26147 | 1545 | 64 |
668655 | 668655 | 2020-10-26 | St. Clair | Michigan | 26147 | 1525 | 64 |
665411 | 665411 | 2020-10-25 | St. Clair | Michigan | 26147 | 1506 | 64 |
662166 | 662166 | 2020-10-24 | St. Clair | Michigan | 26147 | 1474 | 64 |
658922 | 658922 | 2020-10-23 | St. Clair | Michigan | 26147 | 1435 | 64 |
655677 | 655677 | 2020-10-22 | St. Clair | Michigan | 26147 | 1408 | 64 |
652432 | 652432 | 2020-10-21 | St. Clair | Michigan | 26147 | 1375 | 64 |
649187 | 649187 | 2020-10-20 | St. Clair | Michigan | 26147 | 1341 | 63 |
645943 | 645943 | 2020-10-19 | St. Clair | Michigan | 26147 | 1311 | 63 |
642696 | 642696 | 2020-10-18 | St. Clair | Michigan | 26147 | 1296 | 63 |
639449 | 639449 | 2020-10-17 | St. Clair | Michigan | 26147 | 1276 | 63 |
636203 | 636203 | 2020-10-16 | St. Clair | Michigan | 26147 | 1256 | 62 |
632957 | 632957 | 2020-10-15 | St. Clair | Michigan | 26147 | 1223 | 62 |
629712 | 629712 | 2020-10-14 | St. Clair | Michigan | 26147 | 1205 | 61 |
626468 | 626468 | 2020-10-13 | St. Clair | Michigan | 26147 | 1190 | 60 |
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);