ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Calhoun" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
954146 | 954146 | 2021-01-22 | Calhoun | Michigan | 26025 | 8657 | 209 |
950901 | 950901 | 2021-01-21 | Calhoun | Michigan | 26025 | 8609 | 208 |
947655 | 947655 | 2021-01-20 | Calhoun | Michigan | 26025 | 8579 | 207 |
944408 | 944408 | 2021-01-19 | Calhoun | Michigan | 26025 | 8532 | 206 |
941163 | 941163 | 2021-01-18 | Calhoun | Michigan | 26025 | 8501 | 205 |
937918 | 937918 | 2021-01-17 | Calhoun | Michigan | 26025 | 8464 | 207 |
934673 | 934673 | 2021-01-16 | Calhoun | Michigan | 26025 | 8464 | 207 |
931428 | 931428 | 2021-01-15 | Calhoun | Michigan | 26025 | 8435 | 207 |
928183 | 928183 | 2021-01-14 | Calhoun | Michigan | 26025 | 8378 | 207 |
924937 | 924937 | 2021-01-13 | Calhoun | Michigan | 26025 | 8327 | 204 |
921692 | 921692 | 2021-01-12 | Calhoun | Michigan | 26025 | 8273 | 203 |
918447 | 918447 | 2021-01-11 | Calhoun | Michigan | 26025 | 8230 | 206 |
915202 | 915202 | 2021-01-10 | Calhoun | Michigan | 26025 | 8159 | 206 |
911957 | 911957 | 2021-01-09 | Calhoun | Michigan | 26025 | 8159 | 206 |
908712 | 908712 | 2021-01-08 | Calhoun | Michigan | 26025 | 8117 | 204 |
905466 | 905466 | 2021-01-07 | Calhoun | Michigan | 26025 | 8061 | 203 |
902221 | 902221 | 2021-01-06 | Calhoun | Michigan | 26025 | 8016 | 202 |
898976 | 898976 | 2021-01-05 | Calhoun | Michigan | 26025 | 7962 | 198 |
895731 | 895731 | 2021-01-04 | Calhoun | Michigan | 26025 | 7920 | 195 |
892484 | 892484 | 2021-01-03 | Calhoun | Michigan | 26025 | 7873 | 194 |
889238 | 889238 | 2021-01-02 | Calhoun | Michigan | 26025 | 7873 | 194 |
885992 | 885992 | 2021-01-01 | Calhoun | Michigan | 26025 | 7802 | 189 |
882747 | 882747 | 2020-12-31 | Calhoun | Michigan | 26025 | 7802 | 189 |
879502 | 879502 | 2020-12-30 | Calhoun | Michigan | 26025 | 7802 | 189 |
876257 | 876257 | 2020-12-29 | Calhoun | Michigan | 26025 | 7750 | 189 |
873012 | 873012 | 2020-12-28 | Calhoun | Michigan | 26025 | 7736 | 184 |
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);