ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26117 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194409 | 1194409 | 2021-04-06 | Montcalm | Michigan | 26117 | 6344 | 97 |
1191160 | 1191160 | 2021-04-05 | Montcalm | Michigan | 26117 | 6310 | 97 |
1187912 | 1187912 | 2021-04-04 | Montcalm | Michigan | 26117 | 6238 | 97 |
1184665 | 1184665 | 2021-04-03 | Montcalm | Michigan | 26117 | 6238 | 97 |
1181419 | 1181419 | 2021-04-02 | Montcalm | Michigan | 26117 | 6199 | 96 |
1178172 | 1178172 | 2021-04-01 | Montcalm | Michigan | 26117 | 6135 | 96 |
1174925 | 1174925 | 2021-03-31 | Montcalm | Michigan | 26117 | 6086 | 96 |
1171678 | 1171678 | 2021-03-30 | Montcalm | Michigan | 26117 | 6046 | 96 |
1168430 | 1168430 | 2021-03-29 | Montcalm | Michigan | 26117 | 6023 | 96 |
1165182 | 1165182 | 2021-03-28 | Montcalm | Michigan | 26117 | 5968 | 96 |
1161934 | 1161934 | 2021-03-27 | Montcalm | Michigan | 26117 | 5968 | 96 |
1158686 | 1158686 | 2021-03-26 | Montcalm | Michigan | 26117 | 5938 | 96 |
1155439 | 1155439 | 2021-03-25 | Montcalm | Michigan | 26117 | 5911 | 97 |
1152192 | 1152192 | 2021-03-24 | Montcalm | Michigan | 26117 | 5866 | 97 |
1148945 | 1148945 | 2021-03-23 | Montcalm | Michigan | 26117 | 5842 | 96 |
1145698 | 1145698 | 2021-03-22 | Montcalm | Michigan | 26117 | 5816 | 96 |
1142451 | 1142451 | 2021-03-21 | Montcalm | Michigan | 26117 | 5794 | 96 |
1139204 | 1139204 | 2021-03-20 | Montcalm | Michigan | 26117 | 5794 | 96 |
1135958 | 1135958 | 2021-03-19 | Montcalm | Michigan | 26117 | 5778 | 96 |
1132712 | 1132712 | 2021-03-18 | Montcalm | Michigan | 26117 | 5758 | 96 |
1129464 | 1129464 | 2021-03-17 | Montcalm | Michigan | 26117 | 5745 | 96 |
1126217 | 1126217 | 2021-03-16 | Montcalm | Michigan | 26117 | 5736 | 96 |
1122971 | 1122971 | 2021-03-15 | Montcalm | Michigan | 26117 | 5731 | 96 |
1119724 | 1119724 | 2021-03-14 | Montcalm | Michigan | 26117 | 5717 | 96 |
1116477 | 1116477 | 2021-03-13 | Montcalm | Michigan | 26117 | 5717 | 96 |
1113231 | 1113231 | 2021-03-12 | Montcalm | Michigan | 26117 | 5717 | 96 |
1109985 | 1109985 | 2021-03-11 | Montcalm | Michigan | 26117 | 5704 | 96 |
1106739 | 1106739 | 2021-03-10 | Montcalm | Michigan | 26117 | 5701 | 94 |
1103493 | 1103493 | 2021-03-09 | Montcalm | Michigan | 26117 | 5695 | 94 |
1100247 | 1100247 | 2021-03-08 | Montcalm | Michigan | 26117 | 5689 | 94 |
1097000 | 1097000 | 2021-03-07 | Montcalm | Michigan | 26117 | 5671 | 94 |
1093753 | 1093753 | 2021-03-06 | Montcalm | Michigan | 26117 | 5671 | 94 |
1090507 | 1090507 | 2021-03-05 | Montcalm | Michigan | 26117 | 5667 | 94 |
1087262 | 1087262 | 2021-03-04 | Montcalm | Michigan | 26117 | 5655 | 94 |
1084017 | 1084017 | 2021-03-03 | Montcalm | Michigan | 26117 | 5649 | 94 |
1080771 | 1080771 | 2021-03-02 | Montcalm | Michigan | 26117 | 5640 | 94 |
1077525 | 1077525 | 2021-03-01 | Montcalm | Michigan | 26117 | 5630 | 94 |
1074279 | 1074279 | 2021-02-28 | Montcalm | Michigan | 26117 | 5617 | 94 |
1071033 | 1071033 | 2021-02-27 | Montcalm | Michigan | 26117 | 5617 | 94 |
1067788 | 1067788 | 2021-02-26 | Montcalm | Michigan | 26117 | 5611 | 92 |
1064543 | 1064543 | 2021-02-25 | Montcalm | Michigan | 26117 | 5605 | 92 |
1061299 | 1061299 | 2021-02-24 | Montcalm | Michigan | 26117 | 5594 | 92 |
1058053 | 1058053 | 2021-02-23 | Montcalm | Michigan | 26117 | 5591 | 92 |
1054807 | 1054807 | 2021-02-22 | Montcalm | Michigan | 26117 | 5583 | 92 |
1051560 | 1051560 | 2021-02-21 | Montcalm | Michigan | 26117 | 5579 | 92 |
1048313 | 1048313 | 2021-02-20 | Montcalm | Michigan | 26117 | 5579 | 92 |
1045067 | 1045067 | 2021-02-19 | Montcalm | Michigan | 26117 | 5576 | 92 |
1041822 | 1041822 | 2021-02-18 | Montcalm | Michigan | 26117 | 5565 | 92 |
1038577 | 1038577 | 2021-02-17 | Montcalm | Michigan | 26117 | 5563 | 90 |
1035332 | 1035332 | 2021-02-16 | Montcalm | Michigan | 26117 | 5559 | 90 |
1032087 | 1032087 | 2021-02-15 | Montcalm | Michigan | 26117 | 5548 | 90 |
1028840 | 1028840 | 2021-02-14 | Montcalm | Michigan | 26117 | 5541 | 90 |
1025594 | 1025594 | 2021-02-13 | Montcalm | Michigan | 26117 | 5541 | 90 |
1022349 | 1022349 | 2021-02-12 | Montcalm | Michigan | 26117 | 5532 | 90 |
1019104 | 1019104 | 2021-02-11 | Montcalm | Michigan | 26117 | 5519 | 90 |
1015859 | 1015859 | 2021-02-10 | Montcalm | Michigan | 26117 | 5512 | 90 |
1012614 | 1012614 | 2021-02-09 | Montcalm | Michigan | 26117 | 5502 | 90 |
1009369 | 1009369 | 2021-02-08 | Montcalm | Michigan | 26117 | 5495 | 90 |
1006122 | 1006122 | 2021-02-07 | Montcalm | Michigan | 26117 | 5487 | 90 |
1002876 | 1002876 | 2021-02-06 | Montcalm | Michigan | 26117 | 5487 | 90 |
999631 | 999631 | 2021-02-05 | Montcalm | Michigan | 26117 | 5481 | 90 |
996385 | 996385 | 2021-02-04 | Montcalm | Michigan | 26117 | 5477 | 90 |
993139 | 993139 | 2021-02-03 | Montcalm | Michigan | 26117 | 5472 | 90 |
989893 | 989893 | 2021-02-02 | Montcalm | Michigan | 26117 | 5463 | 90 |
986646 | 986646 | 2021-02-01 | Montcalm | Michigan | 26117 | 5459 | 90 |
983399 | 983399 | 2021-01-31 | Montcalm | Michigan | 26117 | 5451 | 90 |
980153 | 980153 | 2021-01-30 | Montcalm | Michigan | 26117 | 5451 | 90 |
976907 | 976907 | 2021-01-29 | Montcalm | Michigan | 26117 | 5446 | 88 |
973662 | 973662 | 2021-01-28 | Montcalm | Michigan | 26117 | 5442 | 88 |
970417 | 970417 | 2021-01-27 | Montcalm | Michigan | 26117 | 5432 | 89 |
967172 | 967172 | 2021-01-26 | Montcalm | Michigan | 26117 | 5431 | 89 |
963928 | 963928 | 2021-01-25 | Montcalm | Michigan | 26117 | 5423 | 87 |
960683 | 960683 | 2021-01-24 | Montcalm | Michigan | 26117 | 5417 | 86 |
957437 | 957437 | 2021-01-23 | Montcalm | Michigan | 26117 | 5417 | 86 |
954192 | 954192 | 2021-01-22 | Montcalm | Michigan | 26117 | 5407 | 84 |
950947 | 950947 | 2021-01-21 | Montcalm | Michigan | 26117 | 5403 | 84 |
947701 | 947701 | 2021-01-20 | Montcalm | Michigan | 26117 | 5384 | 84 |
944454 | 944454 | 2021-01-19 | Montcalm | Michigan | 26117 | 5377 | 84 |
941209 | 941209 | 2021-01-18 | Montcalm | Michigan | 26117 | 5367 | 84 |
937964 | 937964 | 2021-01-17 | Montcalm | Michigan | 26117 | 5354 | 84 |
934719 | 934719 | 2021-01-16 | Montcalm | Michigan | 26117 | 5354 | 84 |
931474 | 931474 | 2021-01-15 | Montcalm | Michigan | 26117 | 5339 | 84 |
928229 | 928229 | 2021-01-14 | Montcalm | Michigan | 26117 | 5315 | 84 |
924983 | 924983 | 2021-01-13 | Montcalm | Michigan | 26117 | 3458 | 78 |
921738 | 921738 | 2021-01-12 | Montcalm | Michigan | 26117 | 3447 | 78 |
918493 | 918493 | 2021-01-11 | Montcalm | Michigan | 26117 | 3436 | 74 |
915248 | 915248 | 2021-01-10 | Montcalm | Michigan | 26117 | 3411 | 74 |
912003 | 912003 | 2021-01-09 | Montcalm | Michigan | 26117 | 3411 | 74 |
908758 | 908758 | 2021-01-08 | Montcalm | Michigan | 26117 | 3389 | 71 |
905512 | 905512 | 2021-01-07 | Montcalm | Michigan | 26117 | 3368 | 71 |
902267 | 902267 | 2021-01-06 | Montcalm | Michigan | 26117 | 3347 | 71 |
899022 | 899022 | 2021-01-05 | Montcalm | Michigan | 26117 | 3325 | 71 |
895777 | 895777 | 2021-01-04 | Montcalm | Michigan | 26117 | 3301 | 70 |
892530 | 892530 | 2021-01-03 | Montcalm | Michigan | 26117 | 3264 | 70 |
889284 | 889284 | 2021-01-02 | Montcalm | Michigan | 26117 | 3264 | 70 |
886038 | 886038 | 2021-01-01 | Montcalm | Michigan | 26117 | 3205 | 65 |
882793 | 882793 | 2020-12-31 | Montcalm | Michigan | 26117 | 3205 | 65 |
879548 | 879548 | 2020-12-30 | Montcalm | Michigan | 26117 | 3205 | 65 |
876303 | 876303 | 2020-12-29 | Montcalm | Michigan | 26117 | 3187 | 65 |
873058 | 873058 | 2020-12-28 | Montcalm | Michigan | 26117 | 3158 | 63 |
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);