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 |
---|---|---|---|---|---|---|---|
1194427 | 1194427 | 2021-04-06 | St. Clair | Michigan | 26147 | 13566 | 295 |
1191178 | 1191178 | 2021-04-05 | St. Clair | Michigan | 26147 | 13282 | 285 |
1187930 | 1187930 | 2021-04-04 | St. Clair | Michigan | 26147 | 12983 | 284 |
1184683 | 1184683 | 2021-04-03 | St. Clair | Michigan | 26147 | 12983 | 284 |
1181437 | 1181437 | 2021-04-02 | St. Clair | Michigan | 26147 | 12554 | 281 |
1178190 | 1178190 | 2021-04-01 | St. Clair | Michigan | 26147 | 12297 | 281 |
1174943 | 1174943 | 2021-03-31 | St. Clair | Michigan | 26147 | 12103 | 278 |
1171696 | 1171696 | 2021-03-30 | St. Clair | Michigan | 26147 | 11866 | 278 |
1168448 | 1168448 | 2021-03-29 | St. Clair | Michigan | 26147 | 11613 | 273 |
1165200 | 1165200 | 2021-03-28 | St. Clair | Michigan | 26147 | 11384 | 273 |
1161952 | 1161952 | 2021-03-27 | St. Clair | Michigan | 26147 | 11268 | 273 |
1158704 | 1158704 | 2021-03-26 | St. Clair | Michigan | 26147 | 11111 | 271 |
1155457 | 1155457 | 2021-03-25 | St. Clair | Michigan | 26147 | 10878 | 270 |
1152210 | 1152210 | 2021-03-24 | St. Clair | Michigan | 26147 | 10720 | 267 |
1148963 | 1148963 | 2021-03-23 | St. Clair | Michigan | 26147 | 10517 | 267 |
1145716 | 1145716 | 2021-03-22 | St. Clair | Michigan | 26147 | 10325 | 264 |
1142469 | 1142469 | 2021-03-21 | St. Clair | Michigan | 26147 | 10199 | 264 |
1139222 | 1139222 | 2021-03-20 | St. Clair | Michigan | 26147 | 10125 | 264 |
1135976 | 1135976 | 2021-03-19 | St. Clair | Michigan | 26147 | 9979 | 263 |
1132730 | 1132730 | 2021-03-18 | St. Clair | Michigan | 26147 | 9822 | 263 |
1129482 | 1129482 | 2021-03-17 | St. Clair | Michigan | 26147 | 9718 | 263 |
1126235 | 1126235 | 2021-03-16 | St. Clair | Michigan | 26147 | 9536 | 263 |
1122989 | 1122989 | 2021-03-15 | St. Clair | Michigan | 26147 | 9452 | 262 |
1119742 | 1119742 | 2021-03-14 | St. Clair | Michigan | 26147 | 9384 | 262 |
1116495 | 1116495 | 2021-03-13 | St. Clair | Michigan | 26147 | 9320 | 262 |
1113249 | 1113249 | 2021-03-12 | St. Clair | Michigan | 26147 | 9222 | 262 |
1110003 | 1110003 | 2021-03-11 | St. Clair | Michigan | 26147 | 9114 | 261 |
1106757 | 1106757 | 2021-03-10 | St. Clair | Michigan | 26147 | 9044 | 261 |
1103511 | 1103511 | 2021-03-09 | St. Clair | Michigan | 26147 | 8986 | 261 |
1100265 | 1100265 | 2021-03-08 | St. Clair | Michigan | 26147 | 8929 | 261 |
1097018 | 1097018 | 2021-03-07 | St. Clair | Michigan | 26147 | 8904 | 261 |
1093771 | 1093771 | 2021-03-06 | St. Clair | Michigan | 26147 | 8879 | 261 |
1090525 | 1090525 | 2021-03-05 | St. Clair | Michigan | 26147 | 8842 | 260 |
1087280 | 1087280 | 2021-03-04 | St. Clair | Michigan | 26147 | 8805 | 260 |
1084035 | 1084035 | 2021-03-03 | St. Clair | Michigan | 26147 | 8762 | 259 |
1080789 | 1080789 | 2021-03-02 | St. Clair | Michigan | 26147 | 8734 | 258 |
1077543 | 1077543 | 2021-03-01 | St. Clair | Michigan | 26147 | 8706 | 257 |
1074297 | 1074297 | 2021-02-28 | St. Clair | Michigan | 26147 | 8705 | 257 |
1071051 | 1071051 | 2021-02-27 | St. Clair | Michigan | 26147 | 8681 | 257 |
1067806 | 1067806 | 2021-02-26 | St. Clair | Michigan | 26147 | 8669 | 256 |
1064561 | 1064561 | 2021-02-25 | St. Clair | Michigan | 26147 | 8647 | 256 |
1061317 | 1061317 | 2021-02-24 | St. Clair | Michigan | 26147 | 8623 | 256 |
1058071 | 1058071 | 2021-02-23 | St. Clair | Michigan | 26147 | 8609 | 254 |
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 |
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);