ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 26069 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194385 | 1194385 | 2021-04-06 | Iosco | Michigan | 26069 | 1500 | 67 |
1191136 | 1191136 | 2021-04-05 | Iosco | Michigan | 26069 | 1495 | 67 |
1187888 | 1187888 | 2021-04-04 | Iosco | Michigan | 26069 | 1467 | 67 |
1184641 | 1184641 | 2021-04-03 | Iosco | Michigan | 26069 | 1467 | 67 |
1181395 | 1181395 | 2021-04-02 | Iosco | Michigan | 26069 | 1437 | 67 |
1178148 | 1178148 | 2021-04-01 | Iosco | Michigan | 26069 | 1419 | 67 |
1174901 | 1174901 | 2021-03-31 | Iosco | Michigan | 26069 | 1404 | 67 |
1171654 | 1171654 | 2021-03-30 | Iosco | Michigan | 26069 | 1385 | 67 |
1168406 | 1168406 | 2021-03-29 | Iosco | Michigan | 26069 | 1374 | 67 |
1165158 | 1165158 | 2021-03-28 | Iosco | Michigan | 26069 | 1348 | 67 |
1161910 | 1161910 | 2021-03-27 | Iosco | Michigan | 26069 | 1348 | 67 |
1158662 | 1158662 | 2021-03-26 | Iosco | Michigan | 26069 | 1342 | 67 |
1155415 | 1155415 | 2021-03-25 | Iosco | Michigan | 26069 | 1334 | 67 |
1152168 | 1152168 | 2021-03-24 | Iosco | Michigan | 26069 | 1318 | 67 |
1148921 | 1148921 | 2021-03-23 | Iosco | Michigan | 26069 | 1316 | 67 |
1145674 | 1145674 | 2021-03-22 | Iosco | Michigan | 26069 | 1313 | 67 |
1142427 | 1142427 | 2021-03-21 | Iosco | Michigan | 26069 | 1308 | 67 |
1139180 | 1139180 | 2021-03-20 | Iosco | Michigan | 26069 | 1308 | 67 |
1135934 | 1135934 | 2021-03-19 | Iosco | Michigan | 26069 | 1306 | 67 |
1132688 | 1132688 | 2021-03-18 | Iosco | Michigan | 26069 | 1304 | 67 |
1129440 | 1129440 | 2021-03-17 | Iosco | Michigan | 26069 | 1303 | 67 |
1126193 | 1126193 | 2021-03-16 | Iosco | Michigan | 26069 | 1301 | 67 |
1122947 | 1122947 | 2021-03-15 | Iosco | Michigan | 26069 | 1294 | 67 |
1119700 | 1119700 | 2021-03-14 | Iosco | Michigan | 26069 | 1290 | 67 |
1116453 | 1116453 | 2021-03-13 | Iosco | Michigan | 26069 | 1290 | 67 |
1113207 | 1113207 | 2021-03-12 | Iosco | Michigan | 26069 | 1290 | 67 |
1109961 | 1109961 | 2021-03-11 | Iosco | Michigan | 26069 | 1289 | 67 |
1106715 | 1106715 | 2021-03-10 | Iosco | Michigan | 26069 | 1289 | 67 |
1103469 | 1103469 | 2021-03-09 | Iosco | Michigan | 26069 | 1285 | 67 |
1100223 | 1100223 | 2021-03-08 | Iosco | Michigan | 26069 | 1284 | 67 |
1096976 | 1096976 | 2021-03-07 | Iosco | Michigan | 26069 | 1281 | 67 |
1093729 | 1093729 | 2021-03-06 | Iosco | Michigan | 26069 | 1281 | 67 |
1090483 | 1090483 | 2021-03-05 | Iosco | Michigan | 26069 | 1282 | 67 |
1087238 | 1087238 | 2021-03-04 | Iosco | Michigan | 26069 | 1282 | 67 |
1083993 | 1083993 | 2021-03-03 | Iosco | Michigan | 26069 | 1281 | 67 |
1080747 | 1080747 | 2021-03-02 | Iosco | Michigan | 26069 | 1282 | 67 |
1077501 | 1077501 | 2021-03-01 | Iosco | Michigan | 26069 | 1281 | 67 |
1074255 | 1074255 | 2021-02-28 | Iosco | Michigan | 26069 | 1280 | 67 |
1071009 | 1071009 | 2021-02-27 | Iosco | Michigan | 26069 | 1280 | 67 |
1067764 | 1067764 | 2021-02-26 | Iosco | Michigan | 26069 | 1277 | 67 |
1064519 | 1064519 | 2021-02-25 | Iosco | Michigan | 26069 | 1276 | 67 |
1061275 | 1061275 | 2021-02-24 | Iosco | Michigan | 26069 | 1275 | 67 |
1058029 | 1058029 | 2021-02-23 | Iosco | Michigan | 26069 | 1275 | 67 |
1054783 | 1054783 | 2021-02-22 | Iosco | Michigan | 26069 | 1275 | 67 |
1051536 | 1051536 | 2021-02-21 | Iosco | Michigan | 26069 | 1274 | 67 |
1048289 | 1048289 | 2021-02-20 | Iosco | Michigan | 26069 | 1274 | 67 |
1045043 | 1045043 | 2021-02-19 | Iosco | Michigan | 26069 | 1274 | 67 |
1041798 | 1041798 | 2021-02-18 | Iosco | Michigan | 26069 | 1271 | 67 |
1038553 | 1038553 | 2021-02-17 | Iosco | Michigan | 26069 | 1270 | 66 |
1035308 | 1035308 | 2021-02-16 | Iosco | Michigan | 26069 | 1267 | 66 |
1032063 | 1032063 | 2021-02-15 | Iosco | Michigan | 26069 | 1265 | 66 |
1028816 | 1028816 | 2021-02-14 | Iosco | Michigan | 26069 | 1264 | 66 |
1025570 | 1025570 | 2021-02-13 | Iosco | Michigan | 26069 | 1264 | 66 |
1022325 | 1022325 | 2021-02-12 | Iosco | Michigan | 26069 | 1262 | 66 |
1019080 | 1019080 | 2021-02-11 | Iosco | Michigan | 26069 | 1263 | 66 |
1015835 | 1015835 | 2021-02-10 | Iosco | Michigan | 26069 | 1263 | 66 |
1012590 | 1012590 | 2021-02-09 | Iosco | Michigan | 26069 | 1262 | 65 |
1009345 | 1009345 | 2021-02-08 | Iosco | Michigan | 26069 | 1260 | 64 |
1006098 | 1006098 | 2021-02-07 | Iosco | Michigan | 26069 | 1257 | 64 |
1002852 | 1002852 | 2021-02-06 | Iosco | Michigan | 26069 | 1257 | 64 |
999607 | 999607 | 2021-02-05 | Iosco | Michigan | 26069 | 1257 | 62 |
996361 | 996361 | 2021-02-04 | Iosco | Michigan | 26069 | 1257 | 62 |
993115 | 993115 | 2021-02-03 | Iosco | Michigan | 26069 | 1256 | 62 |
989869 | 989869 | 2021-02-02 | Iosco | Michigan | 26069 | 1255 | 62 |
986622 | 986622 | 2021-02-01 | Iosco | Michigan | 26069 | 1251 | 62 |
983375 | 983375 | 2021-01-31 | Iosco | Michigan | 26069 | 1250 | 62 |
980129 | 980129 | 2021-01-30 | Iosco | Michigan | 26069 | 1250 | 62 |
976883 | 976883 | 2021-01-29 | Iosco | Michigan | 26069 | 1249 | 62 |
973638 | 973638 | 2021-01-28 | Iosco | Michigan | 26069 | 1244 | 62 |
970393 | 970393 | 2021-01-27 | Iosco | Michigan | 26069 | 1234 | 62 |
967148 | 967148 | 2021-01-26 | Iosco | Michigan | 26069 | 1231 | 63 |
963904 | 963904 | 2021-01-25 | Iosco | Michigan | 26069 | 1227 | 63 |
960659 | 960659 | 2021-01-24 | Iosco | Michigan | 26069 | 1222 | 63 |
957413 | 957413 | 2021-01-23 | Iosco | Michigan | 26069 | 1222 | 63 |
954168 | 954168 | 2021-01-22 | Iosco | Michigan | 26069 | 1222 | 62 |
950923 | 950923 | 2021-01-21 | Iosco | Michigan | 26069 | 1219 | 62 |
947677 | 947677 | 2021-01-20 | Iosco | Michigan | 26069 | 1215 | 60 |
944430 | 944430 | 2021-01-19 | Iosco | Michigan | 26069 | 1213 | 58 |
941185 | 941185 | 2021-01-18 | Iosco | Michigan | 26069 | 1208 | 58 |
937940 | 937940 | 2021-01-17 | Iosco | Michigan | 26069 | 1203 | 57 |
934695 | 934695 | 2021-01-16 | Iosco | Michigan | 26069 | 1203 | 57 |
931450 | 931450 | 2021-01-15 | Iosco | Michigan | 26069 | 1199 | 56 |
928205 | 928205 | 2021-01-14 | Iosco | Michigan | 26069 | 1192 | 56 |
924959 | 924959 | 2021-01-13 | Iosco | Michigan | 26069 | 1189 | 56 |
921714 | 921714 | 2021-01-12 | Iosco | Michigan | 26069 | 1185 | 56 |
918469 | 918469 | 2021-01-11 | Iosco | Michigan | 26069 | 1183 | 56 |
915224 | 915224 | 2021-01-10 | Iosco | Michigan | 26069 | 1170 | 56 |
911979 | 911979 | 2021-01-09 | Iosco | Michigan | 26069 | 1170 | 56 |
908734 | 908734 | 2021-01-08 | Iosco | Michigan | 26069 | 1164 | 55 |
905488 | 905488 | 2021-01-07 | Iosco | Michigan | 26069 | 1147 | 54 |
902243 | 902243 | 2021-01-06 | Iosco | Michigan | 26069 | 1144 | 53 |
898998 | 898998 | 2021-01-05 | Iosco | Michigan | 26069 | 1139 | 53 |
895753 | 895753 | 2021-01-04 | Iosco | Michigan | 26069 | 1135 | 48 |
892506 | 892506 | 2021-01-03 | Iosco | Michigan | 26069 | 1124 | 48 |
889260 | 889260 | 2021-01-02 | Iosco | Michigan | 26069 | 1124 | 48 |
886014 | 886014 | 2021-01-01 | Iosco | Michigan | 26069 | 1104 | 46 |
882769 | 882769 | 2020-12-31 | Iosco | Michigan | 26069 | 1104 | 46 |
879524 | 879524 | 2020-12-30 | Iosco | Michigan | 26069 | 1104 | 46 |
876279 | 876279 | 2020-12-29 | Iosco | Michigan | 26069 | 1100 | 46 |
873034 | 873034 | 2020-12-28 | Iosco | Michigan | 26069 | 1097 | 46 |
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);