ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26025 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278798 | 1278798 | 2021-05-02 | Calhoun | Michigan | 26025 | 13465 | 271 |
1275551 | 1275551 | 2021-05-01 | Calhoun | Michigan | 26025 | 13465 | 271 |
1272304 | 1272304 | 2021-04-30 | Calhoun | Michigan | 26025 | 13439 | 269 |
1269057 | 1269057 | 2021-04-29 | Calhoun | Michigan | 26025 | 13369 | 269 |
1265810 | 1265810 | 2021-04-28 | Calhoun | Michigan | 26025 | 13333 | 269 |
1262563 | 1262563 | 2021-04-27 | Calhoun | Michigan | 26025 | 13257 | 269 |
1259316 | 1259316 | 2021-04-26 | Calhoun | Michigan | 26025 | 13187 | 267 |
1256069 | 1256069 | 2021-04-25 | Calhoun | Michigan | 26025 | 13088 | 267 |
1252822 | 1252822 | 2021-04-24 | Calhoun | Michigan | 26025 | 13088 | 267 |
1249575 | 1249575 | 2021-04-23 | Calhoun | Michigan | 26025 | 13019 | 266 |
1246328 | 1246328 | 2021-04-22 | Calhoun | Michigan | 26025 | 12982 | 266 |
1243081 | 1243081 | 2021-04-21 | Calhoun | Michigan | 26025 | 12885 | 264 |
1239834 | 1239834 | 2021-04-20 | Calhoun | Michigan | 26025 | 12801 | 263 |
1236587 | 1236587 | 2021-04-19 | Calhoun | Michigan | 26025 | 12709 | 262 |
1233340 | 1233340 | 2021-04-18 | Calhoun | Michigan | 26025 | 12624 | 260 |
1230092 | 1230092 | 2021-04-17 | Calhoun | Michigan | 26025 | 12624 | 260 |
1226844 | 1226844 | 2021-04-16 | Calhoun | Michigan | 26025 | 12549 | 258 |
1223596 | 1223596 | 2021-04-15 | Calhoun | Michigan | 26025 | 12412 | 255 |
1220349 | 1220349 | 2021-04-14 | Calhoun | Michigan | 26025 | 12313 | 252 |
1217101 | 1217101 | 2021-04-13 | Calhoun | Michigan | 26025 | 12187 | 252 |
1213854 | 1213854 | 2021-04-12 | Calhoun | Michigan | 26025 | 12069 | 252 |
1210606 | 1210606 | 2021-04-11 | Calhoun | Michigan | 26025 | 11952 | 252 |
1207357 | 1207357 | 2021-04-10 | Calhoun | Michigan | 26025 | 11952 | 252 |
1204109 | 1204109 | 2021-04-09 | Calhoun | Michigan | 26025 | 11888 | 252 |
1200861 | 1200861 | 2021-04-08 | Calhoun | Michigan | 26025 | 11802 | 251 |
1197612 | 1197612 | 2021-04-07 | Calhoun | Michigan | 26025 | 11727 | 250 |
1194363 | 1194363 | 2021-04-06 | Calhoun | Michigan | 26025 | 11633 | 249 |
1191114 | 1191114 | 2021-04-05 | Calhoun | Michigan | 26025 | 11554 | 247 |
1187866 | 1187866 | 2021-04-04 | Calhoun | Michigan | 26025 | 11443 | 247 |
1184619 | 1184619 | 2021-04-03 | Calhoun | Michigan | 26025 | 11443 | 247 |
1181373 | 1181373 | 2021-04-02 | Calhoun | Michigan | 26025 | 11348 | 246 |
1178126 | 1178126 | 2021-04-01 | Calhoun | Michigan | 26025 | 11264 | 246 |
1174879 | 1174879 | 2021-03-31 | Calhoun | Michigan | 26025 | 11166 | 246 |
1171632 | 1171632 | 2021-03-30 | Calhoun | Michigan | 26025 | 11096 | 246 |
1168384 | 1168384 | 2021-03-29 | Calhoun | Michigan | 26025 | 10985 | 246 |
1165136 | 1165136 | 2021-03-28 | Calhoun | Michigan | 26025 | 10896 | 246 |
1161888 | 1161888 | 2021-03-27 | Calhoun | Michigan | 26025 | 10896 | 246 |
1158640 | 1158640 | 2021-03-26 | Calhoun | Michigan | 26025 | 10842 | 245 |
1155393 | 1155393 | 2021-03-25 | Calhoun | Michigan | 26025 | 10768 | 245 |
1152146 | 1152146 | 2021-03-24 | Calhoun | Michigan | 26025 | 10703 | 242 |
1148899 | 1148899 | 2021-03-23 | Calhoun | Michigan | 26025 | 10646 | 241 |
1145652 | 1145652 | 2021-03-22 | Calhoun | Michigan | 26025 | 10555 | 241 |
1142405 | 1142405 | 2021-03-21 | Calhoun | Michigan | 26025 | 10490 | 241 |
1139158 | 1139158 | 2021-03-20 | Calhoun | Michigan | 26025 | 10490 | 241 |
1135912 | 1135912 | 2021-03-19 | Calhoun | Michigan | 26025 | 10445 | 240 |
1132666 | 1132666 | 2021-03-18 | Calhoun | Michigan | 26025 | 10373 | 240 |
1129418 | 1129418 | 2021-03-17 | Calhoun | Michigan | 26025 | 10337 | 240 |
1126171 | 1126171 | 2021-03-16 | Calhoun | Michigan | 26025 | 10253 | 240 |
1122925 | 1122925 | 2021-03-15 | Calhoun | Michigan | 26025 | 10213 | 239 |
1119678 | 1119678 | 2021-03-14 | Calhoun | Michigan | 26025 | 10155 | 237 |
1116431 | 1116431 | 2021-03-13 | Calhoun | Michigan | 26025 | 10155 | 237 |
1113185 | 1113185 | 2021-03-12 | Calhoun | Michigan | 26025 | 10089 | 237 |
1109939 | 1109939 | 2021-03-11 | Calhoun | Michigan | 26025 | 10036 | 237 |
1106693 | 1106693 | 2021-03-10 | Calhoun | Michigan | 26025 | 9973 | 237 |
1103447 | 1103447 | 2021-03-09 | Calhoun | Michigan | 26025 | 9908 | 237 |
1100201 | 1100201 | 2021-03-08 | Calhoun | Michigan | 26025 | 9872 | 236 |
1096954 | 1096954 | 2021-03-07 | Calhoun | Michigan | 26025 | 9822 | 235 |
1093707 | 1093707 | 2021-03-06 | Calhoun | Michigan | 26025 | 9822 | 235 |
1090461 | 1090461 | 2021-03-05 | Calhoun | Michigan | 26025 | 9784 | 235 |
1087216 | 1087216 | 2021-03-04 | Calhoun | Michigan | 26025 | 9753 | 235 |
1083971 | 1083971 | 2021-03-03 | Calhoun | Michigan | 26025 | 9705 | 234 |
1080725 | 1080725 | 2021-03-02 | Calhoun | Michigan | 26025 | 9672 | 234 |
1077479 | 1077479 | 2021-03-01 | Calhoun | Michigan | 26025 | 9633 | 234 |
1074233 | 1074233 | 2021-02-28 | Calhoun | Michigan | 26025 | 9601 | 234 |
1070987 | 1070987 | 2021-02-27 | Calhoun | Michigan | 26025 | 9601 | 234 |
1067742 | 1067742 | 2021-02-26 | Calhoun | Michigan | 26025 | 9585 | 234 |
1064497 | 1064497 | 2021-02-25 | Calhoun | Michigan | 26025 | 9545 | 234 |
1061253 | 1061253 | 2021-02-24 | Calhoun | Michigan | 26025 | 9518 | 234 |
1058007 | 1058007 | 2021-02-23 | Calhoun | Michigan | 26025 | 9473 | 234 |
1054761 | 1054761 | 2021-02-22 | Calhoun | Michigan | 26025 | 9451 | 232 |
1051514 | 1051514 | 2021-02-21 | Calhoun | Michigan | 26025 | 9423 | 232 |
1048267 | 1048267 | 2021-02-20 | Calhoun | Michigan | 26025 | 9423 | 232 |
1045021 | 1045021 | 2021-02-19 | Calhoun | Michigan | 26025 | 9404 | 232 |
1041776 | 1041776 | 2021-02-18 | Calhoun | Michigan | 26025 | 9376 | 232 |
1038531 | 1038531 | 2021-02-17 | Calhoun | Michigan | 26025 | 9348 | 231 |
1035286 | 1035286 | 2021-02-16 | Calhoun | Michigan | 26025 | 9326 | 229 |
1032041 | 1032041 | 2021-02-15 | Calhoun | Michigan | 26025 | 9300 | 228 |
1028794 | 1028794 | 2021-02-14 | Calhoun | Michigan | 26025 | 9286 | 227 |
1025548 | 1025548 | 2021-02-13 | Calhoun | Michigan | 26025 | 9286 | 227 |
1022303 | 1022303 | 2021-02-12 | Calhoun | Michigan | 26025 | 9275 | 227 |
1019058 | 1019058 | 2021-02-11 | Calhoun | Michigan | 26025 | 9246 | 227 |
1015813 | 1015813 | 2021-02-10 | Calhoun | Michigan | 26025 | 9201 | 225 |
1012568 | 1012568 | 2021-02-09 | Calhoun | Michigan | 26025 | 9172 | 225 |
1009323 | 1009323 | 2021-02-08 | Calhoun | Michigan | 26025 | 9141 | 225 |
1006076 | 1006076 | 2021-02-07 | Calhoun | Michigan | 26025 | 9114 | 225 |
1002830 | 1002830 | 2021-02-06 | Calhoun | Michigan | 26025 | 9114 | 225 |
999585 | 999585 | 2021-02-05 | Calhoun | Michigan | 26025 | 9092 | 222 |
996339 | 996339 | 2021-02-04 | Calhoun | Michigan | 26025 | 9060 | 222 |
993093 | 993093 | 2021-02-03 | Calhoun | Michigan | 26025 | 9021 | 221 |
989847 | 989847 | 2021-02-02 | Calhoun | Michigan | 26025 | 8990 | 220 |
986600 | 986600 | 2021-02-01 | Calhoun | Michigan | 26025 | 8967 | 218 |
983353 | 983353 | 2021-01-31 | Calhoun | Michigan | 26025 | 8913 | 217 |
980107 | 980107 | 2021-01-30 | Calhoun | Michigan | 26025 | 8913 | 217 |
976861 | 976861 | 2021-01-29 | Calhoun | Michigan | 26025 | 8894 | 217 |
973616 | 973616 | 2021-01-28 | Calhoun | Michigan | 26025 | 8857 | 216 |
970371 | 970371 | 2021-01-27 | Calhoun | Michigan | 26025 | 8822 | 214 |
967126 | 967126 | 2021-01-26 | Calhoun | Michigan | 26025 | 8763 | 215 |
963882 | 963882 | 2021-01-25 | Calhoun | Michigan | 26025 | 8720 | 213 |
960637 | 960637 | 2021-01-24 | Calhoun | Michigan | 26025 | 8669 | 213 |
957391 | 957391 | 2021-01-23 | Calhoun | Michigan | 26025 | 8669 | 213 |
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);