ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 26115 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194408 | 1194408 | 2021-04-06 | Monroe | Michigan | 26115 | 12272 | 214 |
1191159 | 1191159 | 2021-04-05 | Monroe | Michigan | 26115 | 12180 | 214 |
1187911 | 1187911 | 2021-04-04 | Monroe | Michigan | 26115 | 12013 | 214 |
1184664 | 1184664 | 2021-04-03 | Monroe | Michigan | 26115 | 12013 | 214 |
1181418 | 1181418 | 2021-04-02 | Monroe | Michigan | 26115 | 11879 | 213 |
1178171 | 1178171 | 2021-04-01 | Monroe | Michigan | 26115 | 11675 | 212 |
1174924 | 1174924 | 2021-03-31 | Monroe | Michigan | 26115 | 11584 | 212 |
1171677 | 1171677 | 2021-03-30 | Monroe | Michigan | 26115 | 11441 | 212 |
1168429 | 1168429 | 2021-03-29 | Monroe | Michigan | 26115 | 11304 | 212 |
1165181 | 1165181 | 2021-03-28 | Monroe | Michigan | 26115 | 11197 | 212 |
1161933 | 1161933 | 2021-03-27 | Monroe | Michigan | 26115 | 11197 | 212 |
1158685 | 1158685 | 2021-03-26 | Monroe | Michigan | 26115 | 11144 | 211 |
1155438 | 1155438 | 2021-03-25 | Monroe | Michigan | 26115 | 10977 | 210 |
1152191 | 1152191 | 2021-03-24 | Monroe | Michigan | 26115 | 10923 | 209 |
1148944 | 1148944 | 2021-03-23 | Monroe | Michigan | 26115 | 10864 | 209 |
1145697 | 1145697 | 2021-03-22 | Monroe | Michigan | 26115 | 10790 | 209 |
1142450 | 1142450 | 2021-03-21 | Monroe | Michigan | 26115 | 10716 | 209 |
1139203 | 1139203 | 2021-03-20 | Monroe | Michigan | 26115 | 10716 | 209 |
1135957 | 1135957 | 2021-03-19 | Monroe | Michigan | 26115 | 10651 | 209 |
1132711 | 1132711 | 2021-03-18 | Monroe | Michigan | 26115 | 10595 | 209 |
1129463 | 1129463 | 2021-03-17 | Monroe | Michigan | 26115 | 10539 | 209 |
1126216 | 1126216 | 2021-03-16 | Monroe | Michigan | 26115 | 10440 | 209 |
1122970 | 1122970 | 2021-03-15 | Monroe | Michigan | 26115 | 10379 | 207 |
1119723 | 1119723 | 2021-03-14 | Monroe | Michigan | 26115 | 10329 | 207 |
1116476 | 1116476 | 2021-03-13 | Monroe | Michigan | 26115 | 10329 | 207 |
1113230 | 1113230 | 2021-03-12 | Monroe | Michigan | 26115 | 10289 | 205 |
1109984 | 1109984 | 2021-03-11 | Monroe | Michigan | 26115 | 10234 | 205 |
1106738 | 1106738 | 2021-03-10 | Monroe | Michigan | 26115 | 10182 | 205 |
1103492 | 1103492 | 2021-03-09 | Monroe | Michigan | 26115 | 10125 | 205 |
1100246 | 1100246 | 2021-03-08 | Monroe | Michigan | 26115 | 10067 | 204 |
1096999 | 1096999 | 2021-03-07 | Monroe | Michigan | 26115 | 10008 | 204 |
1093752 | 1093752 | 2021-03-06 | Monroe | Michigan | 26115 | 10008 | 204 |
1090506 | 1090506 | 2021-03-05 | Monroe | Michigan | 26115 | 9969 | 204 |
1087261 | 1087261 | 2021-03-04 | Monroe | Michigan | 26115 | 9928 | 204 |
1084016 | 1084016 | 2021-03-03 | Monroe | Michigan | 26115 | 9901 | 203 |
1080770 | 1080770 | 2021-03-02 | Monroe | Michigan | 26115 | 9854 | 203 |
1077524 | 1077524 | 2021-03-01 | Monroe | Michigan | 26115 | 9806 | 203 |
1074278 | 1074278 | 2021-02-28 | Monroe | Michigan | 26115 | 9772 | 203 |
1071032 | 1071032 | 2021-02-27 | Monroe | Michigan | 26115 | 9772 | 203 |
1067787 | 1067787 | 2021-02-26 | Monroe | Michigan | 26115 | 9733 | 202 |
1064542 | 1064542 | 2021-02-25 | Monroe | Michigan | 26115 | 9705 | 202 |
1061298 | 1061298 | 2021-02-24 | Monroe | Michigan | 26115 | 9691 | 200 |
1058052 | 1058052 | 2021-02-23 | Monroe | Michigan | 26115 | 9664 | 200 |
1054806 | 1054806 | 2021-02-22 | Monroe | Michigan | 26115 | 9639 | 198 |
1051559 | 1051559 | 2021-02-21 | Monroe | Michigan | 26115 | 9614 | 198 |
1048312 | 1048312 | 2021-02-20 | Monroe | Michigan | 26115 | 9614 | 198 |
1045066 | 1045066 | 2021-02-19 | Monroe | Michigan | 26115 | 9600 | 198 |
1041821 | 1041821 | 2021-02-18 | Monroe | Michigan | 26115 | 9567 | 198 |
1038576 | 1038576 | 2021-02-17 | Monroe | Michigan | 26115 | 9561 | 197 |
1035331 | 1035331 | 2021-02-16 | Monroe | Michigan | 26115 | 9533 | 197 |
1032086 | 1032086 | 2021-02-15 | Monroe | Michigan | 26115 | 9516 | 195 |
1028839 | 1028839 | 2021-02-14 | Monroe | Michigan | 26115 | 9490 | 195 |
1025593 | 1025593 | 2021-02-13 | Monroe | Michigan | 26115 | 9490 | 195 |
1022348 | 1022348 | 2021-02-12 | Monroe | Michigan | 26115 | 9479 | 192 |
1019103 | 1019103 | 2021-02-11 | Monroe | Michigan | 26115 | 9464 | 192 |
1015858 | 1015858 | 2021-02-10 | Monroe | Michigan | 26115 | 9423 | 187 |
1012613 | 1012613 | 2021-02-09 | Monroe | Michigan | 26115 | 9405 | 187 |
1009368 | 1009368 | 2021-02-08 | Monroe | Michigan | 26115 | 9384 | 187 |
1006121 | 1006121 | 2021-02-07 | Monroe | Michigan | 26115 | 9345 | 187 |
1002875 | 1002875 | 2021-02-06 | Monroe | Michigan | 26115 | 9345 | 187 |
999630 | 999630 | 2021-02-05 | Monroe | Michigan | 26115 | 9328 | 185 |
996384 | 996384 | 2021-02-04 | Monroe | Michigan | 26115 | 9305 | 185 |
993138 | 993138 | 2021-02-03 | Monroe | Michigan | 26115 | 9279 | 184 |
989892 | 989892 | 2021-02-02 | Monroe | Michigan | 26115 | 9249 | 183 |
986645 | 986645 | 2021-02-01 | Monroe | Michigan | 26115 | 9220 | 182 |
983398 | 983398 | 2021-01-31 | Monroe | Michigan | 26115 | 9168 | 181 |
980152 | 980152 | 2021-01-30 | Monroe | Michigan | 26115 | 9168 | 181 |
976906 | 976906 | 2021-01-29 | Monroe | Michigan | 26115 | 9135 | 181 |
973661 | 973661 | 2021-01-28 | Monroe | Michigan | 26115 | 9097 | 181 |
970416 | 970416 | 2021-01-27 | Monroe | Michigan | 26115 | 9044 | 180 |
967171 | 967171 | 2021-01-26 | Monroe | Michigan | 26115 | 9004 | 179 |
963927 | 963927 | 2021-01-25 | Monroe | Michigan | 26115 | 8959 | 176 |
960682 | 960682 | 2021-01-24 | Monroe | Michigan | 26115 | 8909 | 176 |
957436 | 957436 | 2021-01-23 | Monroe | Michigan | 26115 | 8909 | 176 |
954191 | 954191 | 2021-01-22 | Monroe | Michigan | 26115 | 8876 | 173 |
950946 | 950946 | 2021-01-21 | Monroe | Michigan | 26115 | 8825 | 171 |
947700 | 947700 | 2021-01-20 | Monroe | Michigan | 26115 | 8774 | 172 |
944453 | 944453 | 2021-01-19 | Monroe | Michigan | 26115 | 8722 | 173 |
941208 | 941208 | 2021-01-18 | Monroe | Michigan | 26115 | 8690 | 173 |
937963 | 937963 | 2021-01-17 | Monroe | Michigan | 26115 | 8603 | 174 |
934718 | 934718 | 2021-01-16 | Monroe | Michigan | 26115 | 8603 | 174 |
931473 | 931473 | 2021-01-15 | Monroe | Michigan | 26115 | 8570 | 173 |
928228 | 928228 | 2021-01-14 | Monroe | Michigan | 26115 | 8522 | 173 |
924982 | 924982 | 2021-01-13 | Monroe | Michigan | 26115 | 8456 | 172 |
921737 | 921737 | 2021-01-12 | Monroe | Michigan | 26115 | 8384 | 172 |
918492 | 918492 | 2021-01-11 | Monroe | Michigan | 26115 | 8325 | 170 |
915247 | 915247 | 2021-01-10 | Monroe | Michigan | 26115 | 8249 | 167 |
912002 | 912002 | 2021-01-09 | Monroe | Michigan | 26115 | 8249 | 167 |
908757 | 908757 | 2021-01-08 | Monroe | Michigan | 26115 | 8195 | 165 |
905511 | 905511 | 2021-01-07 | Monroe | Michigan | 26115 | 8147 | 164 |
902266 | 902266 | 2021-01-06 | Monroe | Michigan | 26115 | 8099 | 159 |
899021 | 899021 | 2021-01-05 | Monroe | Michigan | 26115 | 7992 | 160 |
895776 | 895776 | 2021-01-04 | Monroe | Michigan | 26115 | 7912 | 156 |
892529 | 892529 | 2021-01-03 | Monroe | Michigan | 26115 | 7808 | 154 |
889283 | 889283 | 2021-01-02 | Monroe | Michigan | 26115 | 7808 | 154 |
886037 | 886037 | 2021-01-01 | Monroe | Michigan | 26115 | 7595 | 149 |
882792 | 882792 | 2020-12-31 | Monroe | Michigan | 26115 | 7595 | 149 |
879547 | 879547 | 2020-12-30 | Monroe | Michigan | 26115 | 7595 | 149 |
876302 | 876302 | 2020-12-29 | Monroe | Michigan | 26115 | 7535 | 147 |
873057 | 873057 | 2020-12-28 | Monroe | Michigan | 26115 | 7471 | 139 |
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);