ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 26075 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194388 | 1194388 | 2021-04-06 | Jackson | Michigan | 26075 | 17512 | 266 |
1191139 | 1191139 | 2021-04-05 | Jackson | Michigan | 26075 | 17350 | 266 |
1187891 | 1187891 | 2021-04-04 | Jackson | Michigan | 26075 | 17180 | 266 |
1184644 | 1184644 | 2021-04-03 | Jackson | Michigan | 26075 | 17180 | 266 |
1181398 | 1181398 | 2021-04-02 | Jackson | Michigan | 26075 | 17049 | 264 |
1178151 | 1178151 | 2021-04-01 | Jackson | Michigan | 26075 | 16781 | 264 |
1174904 | 1174904 | 2021-03-31 | Jackson | Michigan | 26075 | 16671 | 263 |
1171657 | 1171657 | 2021-03-30 | Jackson | Michigan | 26075 | 16530 | 263 |
1168409 | 1168409 | 2021-03-29 | Jackson | Michigan | 26075 | 16352 | 263 |
1165161 | 1165161 | 2021-03-28 | Jackson | Michigan | 26075 | 16200 | 263 |
1161913 | 1161913 | 2021-03-27 | Jackson | Michigan | 26075 | 16200 | 263 |
1158665 | 1158665 | 2021-03-26 | Jackson | Michigan | 26075 | 16087 | 263 |
1155418 | 1155418 | 2021-03-25 | Jackson | Michigan | 26075 | 15974 | 262 |
1152171 | 1152171 | 2021-03-24 | Jackson | Michigan | 26075 | 15842 | 258 |
1148924 | 1148924 | 2021-03-23 | Jackson | Michigan | 26075 | 15724 | 258 |
1145677 | 1145677 | 2021-03-22 | Jackson | Michigan | 26075 | 15572 | 258 |
1142430 | 1142430 | 2021-03-21 | Jackson | Michigan | 26075 | 15456 | 258 |
1139183 | 1139183 | 2021-03-20 | Jackson | Michigan | 26075 | 15456 | 258 |
1135937 | 1135937 | 2021-03-19 | Jackson | Michigan | 26075 | 15211 | 258 |
1132691 | 1132691 | 2021-03-18 | Jackson | Michigan | 26075 | 15124 | 258 |
1129443 | 1129443 | 2021-03-17 | Jackson | Michigan | 26075 | 15046 | 258 |
1126196 | 1126196 | 2021-03-16 | Jackson | Michigan | 26075 | 14978 | 258 |
1122950 | 1122950 | 2021-03-15 | Jackson | Michigan | 26075 | 14736 | 257 |
1119703 | 1119703 | 2021-03-14 | Jackson | Michigan | 26075 | 14684 | 256 |
1116456 | 1116456 | 2021-03-13 | Jackson | Michigan | 26075 | 14684 | 256 |
1113210 | 1113210 | 2021-03-12 | Jackson | Michigan | 26075 | 14651 | 255 |
1109964 | 1109964 | 2021-03-11 | Jackson | Michigan | 26075 | 14617 | 255 |
1106718 | 1106718 | 2021-03-10 | Jackson | Michigan | 26075 | 14547 | 255 |
1103472 | 1103472 | 2021-03-09 | Jackson | Michigan | 26075 | 14500 | 255 |
1100226 | 1100226 | 2021-03-08 | Jackson | Michigan | 26075 | 14401 | 255 |
1096979 | 1096979 | 2021-03-07 | Jackson | Michigan | 26075 | 14361 | 255 |
1093732 | 1093732 | 2021-03-06 | Jackson | Michigan | 26075 | 14361 | 255 |
1090486 | 1090486 | 2021-03-05 | Jackson | Michigan | 26075 | 14341 | 253 |
1087241 | 1087241 | 2021-03-04 | Jackson | Michigan | 26075 | 14312 | 253 |
1083996 | 1083996 | 2021-03-03 | Jackson | Michigan | 26075 | 14286 | 252 |
1080750 | 1080750 | 2021-03-02 | Jackson | Michigan | 26075 | 14247 | 253 |
1077504 | 1077504 | 2021-03-01 | Jackson | Michigan | 26075 | 14208 | 253 |
1074258 | 1074258 | 2021-02-28 | Jackson | Michigan | 26075 | 14172 | 253 |
1071012 | 1071012 | 2021-02-27 | Jackson | Michigan | 26075 | 14172 | 253 |
1067767 | 1067767 | 2021-02-26 | Jackson | Michigan | 26075 | 14142 | 250 |
1064522 | 1064522 | 2021-02-25 | Jackson | Michigan | 26075 | 14122 | 250 |
1061278 | 1061278 | 2021-02-24 | Jackson | Michigan | 26075 | 14090 | 247 |
1058032 | 1058032 | 2021-02-23 | Jackson | Michigan | 26075 | 14050 | 246 |
1054786 | 1054786 | 2021-02-22 | Jackson | Michigan | 26075 | 13996 | 245 |
1051539 | 1051539 | 2021-02-21 | Jackson | Michigan | 26075 | 13962 | 246 |
1048292 | 1048292 | 2021-02-20 | Jackson | Michigan | 26075 | 13962 | 246 |
1045046 | 1045046 | 2021-02-19 | Jackson | Michigan | 26075 | 13946 | 240 |
1041801 | 1041801 | 2021-02-18 | Jackson | Michigan | 26075 | 13926 | 239 |
1038556 | 1038556 | 2021-02-17 | Jackson | Michigan | 26075 | 13914 | 237 |
1035311 | 1035311 | 2021-02-16 | Jackson | Michigan | 26075 | 13895 | 237 |
1032066 | 1032066 | 2021-02-15 | Jackson | Michigan | 26075 | 13876 | 237 |
1028819 | 1028819 | 2021-02-14 | Jackson | Michigan | 26075 | 13848 | 237 |
1025573 | 1025573 | 2021-02-13 | Jackson | Michigan | 26075 | 13848 | 237 |
1022328 | 1022328 | 2021-02-12 | Jackson | Michigan | 26075 | 13805 | 234 |
1019083 | 1019083 | 2021-02-11 | Jackson | Michigan | 26075 | 13790 | 234 |
1015838 | 1015838 | 2021-02-10 | Jackson | Michigan | 26075 | 13777 | 233 |
1012593 | 1012593 | 2021-02-09 | Jackson | Michigan | 26075 | 13758 | 233 |
1009348 | 1009348 | 2021-02-08 | Jackson | Michigan | 26075 | 13740 | 233 |
1006101 | 1006101 | 2021-02-07 | Jackson | Michigan | 26075 | 13734 | 233 |
1002855 | 1002855 | 2021-02-06 | Jackson | Michigan | 26075 | 13734 | 233 |
999610 | 999610 | 2021-02-05 | Jackson | Michigan | 26075 | 13708 | 231 |
996364 | 996364 | 2021-02-04 | Jackson | Michigan | 26075 | 13669 | 231 |
993118 | 993118 | 2021-02-03 | Jackson | Michigan | 26075 | 13446 | 230 |
989872 | 989872 | 2021-02-02 | Jackson | Michigan | 26075 | 13405 | 230 |
986625 | 986625 | 2021-02-01 | Jackson | Michigan | 26075 | 13372 | 230 |
983378 | 983378 | 2021-01-31 | Jackson | Michigan | 26075 | 13332 | 230 |
980132 | 980132 | 2021-01-30 | Jackson | Michigan | 26075 | 13332 | 230 |
976886 | 976886 | 2021-01-29 | Jackson | Michigan | 26075 | 13299 | 229 |
973641 | 973641 | 2021-01-28 | Jackson | Michigan | 26075 | 13269 | 229 |
970396 | 970396 | 2021-01-27 | Jackson | Michigan | 26075 | 13206 | 228 |
967151 | 967151 | 2021-01-26 | Jackson | Michigan | 26075 | 13176 | 228 |
963907 | 963907 | 2021-01-25 | Jackson | Michigan | 26075 | 13146 | 229 |
960662 | 960662 | 2021-01-24 | Jackson | Michigan | 26075 | 13105 | 228 |
957416 | 957416 | 2021-01-23 | Jackson | Michigan | 26075 | 13105 | 228 |
954171 | 954171 | 2021-01-22 | Jackson | Michigan | 26075 | 13066 | 223 |
950926 | 950926 | 2021-01-21 | Jackson | Michigan | 26075 | 13036 | 223 |
947680 | 947680 | 2021-01-20 | Jackson | Michigan | 26075 | 12985 | 222 |
944433 | 944433 | 2021-01-19 | Jackson | Michigan | 26075 | 12950 | 222 |
941188 | 941188 | 2021-01-18 | Jackson | Michigan | 26075 | 12909 | 222 |
937943 | 937943 | 2021-01-17 | Jackson | Michigan | 26075 | 12863 | 222 |
934698 | 934698 | 2021-01-16 | Jackson | Michigan | 26075 | 12863 | 222 |
931453 | 931453 | 2021-01-15 | Jackson | Michigan | 26075 | 12833 | 218 |
928208 | 928208 | 2021-01-14 | Jackson | Michigan | 26075 | 12782 | 218 |
924962 | 924962 | 2021-01-13 | Jackson | Michigan | 26075 | 11071 | 209 |
921717 | 921717 | 2021-01-12 | Jackson | Michigan | 26075 | 11026 | 209 |
918472 | 918472 | 2021-01-11 | Jackson | Michigan | 26075 | 10977 | 208 |
915227 | 915227 | 2021-01-10 | Jackson | Michigan | 26075 | 10946 | 208 |
911982 | 911982 | 2021-01-09 | Jackson | Michigan | 26075 | 10946 | 208 |
908737 | 908737 | 2021-01-08 | Jackson | Michigan | 26075 | 10906 | 200 |
905491 | 905491 | 2021-01-07 | Jackson | Michigan | 26075 | 10857 | 199 |
902246 | 902246 | 2021-01-06 | Jackson | Michigan | 26075 | 10769 | 190 |
899001 | 899001 | 2021-01-05 | Jackson | Michigan | 26075 | 10685 | 190 |
895756 | 895756 | 2021-01-04 | Jackson | Michigan | 26075 | 10637 | 188 |
892509 | 892509 | 2021-01-03 | Jackson | Michigan | 26075 | 10555 | 189 |
889263 | 889263 | 2021-01-02 | Jackson | Michigan | 26075 | 10555 | 189 |
886017 | 886017 | 2021-01-01 | Jackson | Michigan | 26075 | 10366 | 176 |
882772 | 882772 | 2020-12-31 | Jackson | Michigan | 26075 | 10366 | 176 |
879527 | 879527 | 2020-12-30 | Jackson | Michigan | 26075 | 10366 | 176 |
876282 | 876282 | 2020-12-29 | Jackson | Michigan | 26075 | 10287 | 176 |
873037 | 873037 | 2020-12-28 | Jackson | Michigan | 26075 | 10204 | 175 |
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);