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 |
---|---|---|---|---|---|---|---|
1489836 | 1489836 | 2021-07-06 | Montcalm | Michigan | 26117 | 8211 | 120 |
1486589 | 1486589 | 2021-07-05 | Montcalm | Michigan | 26117 | 8211 | 120 |
1483343 | 1483343 | 2021-07-04 | Montcalm | Michigan | 26117 | 8211 | 120 |
1480097 | 1480097 | 2021-07-03 | Montcalm | Michigan | 26117 | 8211 | 120 |
1476850 | 1476850 | 2021-07-02 | Montcalm | Michigan | 26117 | 8211 | 120 |
1473604 | 1473604 | 2021-07-01 | Montcalm | Michigan | 26117 | 8211 | 120 |
1470358 | 1470358 | 2021-06-30 | Montcalm | Michigan | 26117 | 8211 | 119 |
1467113 | 1467113 | 2021-06-29 | Montcalm | Michigan | 26117 | 8212 | 119 |
1463868 | 1463868 | 2021-06-28 | Montcalm | Michigan | 26117 | 8211 | 119 |
1460623 | 1460623 | 2021-06-27 | Montcalm | Michigan | 26117 | 8211 | 119 |
1457378 | 1457378 | 2021-06-26 | Montcalm | Michigan | 26117 | 8211 | 119 |
1454133 | 1454133 | 2021-06-25 | Montcalm | Michigan | 26117 | 8211 | 119 |
1450888 | 1450888 | 2021-06-24 | Montcalm | Michigan | 26117 | 8211 | 119 |
1447642 | 1447642 | 2021-06-23 | Montcalm | Michigan | 26117 | 8210 | 119 |
1444397 | 1444397 | 2021-06-22 | Montcalm | Michigan | 26117 | 8199 | 119 |
1441152 | 1441152 | 2021-06-21 | Montcalm | Michigan | 26117 | 8198 | 119 |
1437906 | 1437906 | 2021-06-20 | Montcalm | Michigan | 26117 | 8197 | 119 |
1434659 | 1434659 | 2021-06-19 | Montcalm | Michigan | 26117 | 8197 | 119 |
1431412 | 1431412 | 2021-06-18 | Montcalm | Michigan | 26117 | 8197 | 119 |
1428167 | 1428167 | 2021-06-17 | Montcalm | Michigan | 26117 | 8196 | 119 |
1424922 | 1424922 | 2021-06-16 | Montcalm | Michigan | 26117 | 8196 | 119 |
1421674 | 1421674 | 2021-06-15 | Montcalm | Michigan | 26117 | 8195 | 119 |
1418429 | 1418429 | 2021-06-14 | Montcalm | Michigan | 26117 | 8194 | 119 |
1415184 | 1415184 | 2021-06-13 | Montcalm | Michigan | 26117 | 8189 | 119 |
1411938 | 1411938 | 2021-06-12 | Montcalm | Michigan | 26117 | 8189 | 119 |
1408693 | 1408693 | 2021-06-11 | Montcalm | Michigan | 26117 | 8187 | 118 |
1405448 | 1405448 | 2021-06-10 | Montcalm | Michigan | 26117 | 8188 | 118 |
1402202 | 1402202 | 2021-06-09 | Montcalm | Michigan | 26117 | 8186 | 118 |
1398957 | 1398957 | 2021-06-08 | Montcalm | Michigan | 26117 | 8180 | 118 |
1395711 | 1395711 | 2021-06-07 | Montcalm | Michigan | 26117 | 8175 | 118 |
1392465 | 1392465 | 2021-06-06 | Montcalm | Michigan | 26117 | 8168 | 117 |
1389220 | 1389220 | 2021-06-05 | Montcalm | Michigan | 26117 | 8168 | 117 |
1385975 | 1385975 | 2021-06-04 | Montcalm | Michigan | 26117 | 8163 | 117 |
1382730 | 1382730 | 2021-06-03 | Montcalm | Michigan | 26117 | 8152 | 117 |
1379484 | 1379484 | 2021-06-02 | Montcalm | Michigan | 26117 | 8148 | 118 |
1376239 | 1376239 | 2021-06-01 | Montcalm | Michigan | 26117 | 8137 | 118 |
1372993 | 1372993 | 2021-05-31 | Montcalm | Michigan | 26117 | 8124 | 118 |
1369748 | 1369748 | 2021-05-30 | Montcalm | Michigan | 26117 | 8124 | 118 |
1366502 | 1366502 | 2021-05-29 | Montcalm | Michigan | 26117 | 8124 | 118 |
1363256 | 1363256 | 2021-05-28 | Montcalm | Michigan | 26117 | 8115 | 117 |
1360009 | 1360009 | 2021-05-27 | Montcalm | Michigan | 26117 | 8102 | 117 |
1356763 | 1356763 | 2021-05-26 | Montcalm | Michigan | 26117 | 8088 | 116 |
1353517 | 1353517 | 2021-05-25 | Montcalm | Michigan | 26117 | 8076 | 116 |
1350271 | 1350271 | 2021-05-24 | Montcalm | Michigan | 26117 | 8067 | 116 |
1347025 | 1347025 | 2021-05-23 | Montcalm | Michigan | 26117 | 8053 | 115 |
1343777 | 1343777 | 2021-05-22 | Montcalm | Michigan | 26117 | 8053 | 115 |
1340528 | 1340528 | 2021-05-21 | Montcalm | Michigan | 26117 | 8044 | 114 |
1337281 | 1337281 | 2021-05-20 | Montcalm | Michigan | 26117 | 8027 | 114 |
1334034 | 1334034 | 2021-05-19 | Montcalm | Michigan | 26117 | 8004 | 113 |
1330787 | 1330787 | 2021-05-18 | Montcalm | Michigan | 26117 | 7984 | 113 |
1327540 | 1327540 | 2021-05-17 | Montcalm | Michigan | 26117 | 7964 | 113 |
1324294 | 1324294 | 2021-05-16 | Montcalm | Michigan | 26117 | 7925 | 113 |
1321048 | 1321048 | 2021-05-15 | Montcalm | Michigan | 26117 | 7925 | 113 |
1317802 | 1317802 | 2021-05-14 | Montcalm | Michigan | 26117 | 7911 | 112 |
1314554 | 1314554 | 2021-05-13 | Montcalm | Michigan | 26117 | 7875 | 112 |
1311308 | 1311308 | 2021-05-12 | Montcalm | Michigan | 26117 | 7854 | 112 |
1308061 | 1308061 | 2021-05-11 | Montcalm | Michigan | 26117 | 7815 | 112 |
1304815 | 1304815 | 2021-05-10 | Montcalm | Michigan | 26117 | 7798 | 112 |
1301569 | 1301569 | 2021-05-09 | Montcalm | Michigan | 26117 | 7760 | 112 |
1298321 | 1298321 | 2021-05-08 | Montcalm | Michigan | 26117 | 7760 | 112 |
1295075 | 1295075 | 2021-05-07 | Montcalm | Michigan | 26117 | 7740 | 110 |
1291829 | 1291829 | 2021-05-06 | Montcalm | Michigan | 26117 | 7711 | 110 |
1288583 | 1288583 | 2021-05-05 | Montcalm | Michigan | 26117 | 7665 | 110 |
1285337 | 1285337 | 2021-05-04 | Montcalm | Michigan | 26117 | 7619 | 110 |
1282091 | 1282091 | 2021-05-03 | Montcalm | Michigan | 26117 | 7597 | 109 |
1278844 | 1278844 | 2021-05-02 | Montcalm | Michigan | 26117 | 7559 | 108 |
1275597 | 1275597 | 2021-05-01 | Montcalm | Michigan | 26117 | 7559 | 108 |
1272350 | 1272350 | 2021-04-30 | Montcalm | Michigan | 26117 | 7534 | 106 |
1269103 | 1269103 | 2021-04-29 | Montcalm | Michigan | 26117 | 7500 | 106 |
1265856 | 1265856 | 2021-04-28 | Montcalm | Michigan | 26117 | 7461 | 105 |
1262609 | 1262609 | 2021-04-27 | Montcalm | Michigan | 26117 | 7414 | 105 |
1259362 | 1259362 | 2021-04-26 | Montcalm | Michigan | 26117 | 7379 | 103 |
1256115 | 1256115 | 2021-04-25 | Montcalm | Michigan | 26117 | 7310 | 103 |
1252868 | 1252868 | 2021-04-24 | Montcalm | Michigan | 26117 | 7310 | 103 |
1249621 | 1249621 | 2021-04-23 | Montcalm | Michigan | 26117 | 7275 | 101 |
1246374 | 1246374 | 2021-04-22 | Montcalm | Michigan | 26117 | 7224 | 101 |
1243127 | 1243127 | 2021-04-21 | Montcalm | Michigan | 26117 | 7171 | 100 |
1239880 | 1239880 | 2021-04-20 | Montcalm | Michigan | 26117 | 7119 | 100 |
1236633 | 1236633 | 2021-04-19 | Montcalm | Michigan | 26117 | 7088 | 100 |
1233386 | 1233386 | 2021-04-18 | Montcalm | Michigan | 26117 | 7023 | 99 |
1230138 | 1230138 | 2021-04-17 | Montcalm | Michigan | 26117 | 7023 | 99 |
1226890 | 1226890 | 2021-04-16 | Montcalm | Michigan | 26117 | 6970 | 99 |
1223642 | 1223642 | 2021-04-15 | Montcalm | Michigan | 26117 | 6895 | 99 |
1220395 | 1220395 | 2021-04-14 | Montcalm | Michigan | 26117 | 6846 | 99 |
1217147 | 1217147 | 2021-04-13 | Montcalm | Michigan | 26117 | 6765 | 99 |
1213900 | 1213900 | 2021-04-12 | Montcalm | Michigan | 26117 | 6707 | 99 |
1210652 | 1210652 | 2021-04-11 | Montcalm | Michigan | 26117 | 6626 | 99 |
1207403 | 1207403 | 2021-04-10 | Montcalm | Michigan | 26117 | 6626 | 99 |
1204155 | 1204155 | 2021-04-09 | Montcalm | Michigan | 26117 | 6547 | 99 |
1200907 | 1200907 | 2021-04-08 | Montcalm | Michigan | 26117 | 6478 | 98 |
1197658 | 1197658 | 2021-04-07 | Montcalm | Michigan | 26117 | 6398 | 97 |
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 |
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);