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 |
---|---|---|---|---|---|---|---|
1054825 | 1054825 | 2021-02-22 | St. Clair | Michigan | 26147 | 8578 | 253 |
1051578 | 1051578 | 2021-02-21 | St. Clair | Michigan | 26147 | 8572 | 253 |
1048331 | 1048331 | 2021-02-20 | St. Clair | Michigan | 26147 | 8570 | 253 |
1045085 | 1045085 | 2021-02-19 | St. Clair | Michigan | 26147 | 8529 | 252 |
1041840 | 1041840 | 2021-02-18 | St. Clair | Michigan | 26147 | 8510 | 252 |
1038595 | 1038595 | 2021-02-17 | St. Clair | Michigan | 26147 | 8501 | 250 |
1035350 | 1035350 | 2021-02-16 | St. Clair | Michigan | 26147 | 8481 | 250 |
1032105 | 1032105 | 2021-02-15 | St. Clair | Michigan | 26147 | 8470 | 250 |
1028858 | 1028858 | 2021-02-14 | St. Clair | Michigan | 26147 | 8458 | 250 |
1025612 | 1025612 | 2021-02-13 | St. Clair | Michigan | 26147 | 8454 | 250 |
1022367 | 1022367 | 2021-02-12 | St. Clair | Michigan | 26147 | 8436 | 244 |
1019122 | 1019122 | 2021-02-11 | St. Clair | Michigan | 26147 | 8424 | 243 |
1015877 | 1015877 | 2021-02-10 | St. Clair | Michigan | 26147 | 8407 | 243 |
1012632 | 1012632 | 2021-02-09 | St. Clair | Michigan | 26147 | 8393 | 243 |
1009387 | 1009387 | 2021-02-08 | St. Clair | Michigan | 26147 | 8375 | 240 |
1006140 | 1006140 | 2021-02-07 | St. Clair | Michigan | 26147 | 8364 | 240 |
1002894 | 1002894 | 2021-02-06 | St. Clair | Michigan | 26147 | 8361 | 240 |
999649 | 999649 | 2021-02-05 | St. Clair | Michigan | 26147 | 8340 | 238 |
996403 | 996403 | 2021-02-04 | St. Clair | Michigan | 26147 | 8323 | 238 |
993157 | 993157 | 2021-02-03 | St. Clair | Michigan | 26147 | 8302 | 237 |
989911 | 989911 | 2021-02-02 | St. Clair | Michigan | 26147 | 8288 | 236 |
986664 | 986664 | 2021-02-01 | St. Clair | Michigan | 26147 | 8269 | 231 |
983417 | 983417 | 2021-01-31 | St. Clair | Michigan | 26147 | 8251 | 231 |
980171 | 980171 | 2021-01-30 | St. Clair | Michigan | 26147 | 8236 | 231 |
976925 | 976925 | 2021-01-29 | St. Clair | Michigan | 26147 | 8215 | 227 |
973680 | 973680 | 2021-01-28 | St. Clair | Michigan | 26147 | 8186 | 226 |
970435 | 970435 | 2021-01-27 | St. Clair | Michigan | 26147 | 8168 | 226 |
967190 | 967190 | 2021-01-26 | St. Clair | Michigan | 26147 | 8145 | 226 |
963946 | 963946 | 2021-01-25 | St. Clair | Michigan | 26147 | 8107 | 224 |
960701 | 960701 | 2021-01-24 | St. Clair | Michigan | 26147 | 8095 | 224 |
957455 | 957455 | 2021-01-23 | St. Clair | Michigan | 26147 | 8088 | 224 |
954210 | 954210 | 2021-01-22 | St. Clair | Michigan | 26147 | 8041 | 211 |
950965 | 950965 | 2021-01-21 | St. Clair | Michigan | 26147 | 8011 | 211 |
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 |
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);