ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26037 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1489796 | 1489796 | 2021-07-06 | Clinton | Michigan | 26037 | 7663 | 93 |
1486549 | 1486549 | 2021-07-05 | Clinton | Michigan | 26037 | 7659 | 93 |
1483303 | 1483303 | 2021-07-04 | Clinton | Michigan | 26037 | 7659 | 93 |
1480057 | 1480057 | 2021-07-03 | Clinton | Michigan | 26037 | 7659 | 93 |
1476810 | 1476810 | 2021-07-02 | Clinton | Michigan | 26037 | 7659 | 93 |
1473564 | 1473564 | 2021-07-01 | Clinton | Michigan | 26037 | 7658 | 93 |
1470318 | 1470318 | 2021-06-30 | Clinton | Michigan | 26037 | 7656 | 92 |
1467073 | 1467073 | 2021-06-29 | Clinton | Michigan | 26037 | 7660 | 92 |
1463828 | 1463828 | 2021-06-28 | Clinton | Michigan | 26037 | 7659 | 92 |
1460583 | 1460583 | 2021-06-27 | Clinton | Michigan | 26037 | 7655 | 92 |
1457338 | 1457338 | 2021-06-26 | Clinton | Michigan | 26037 | 7655 | 92 |
1454093 | 1454093 | 2021-06-25 | Clinton | Michigan | 26037 | 7655 | 92 |
1450848 | 1450848 | 2021-06-24 | Clinton | Michigan | 26037 | 7654 | 92 |
1447602 | 1447602 | 2021-06-23 | Clinton | Michigan | 26037 | 7652 | 91 |
1444357 | 1444357 | 2021-06-22 | Clinton | Michigan | 26037 | 7643 | 91 |
1441112 | 1441112 | 2021-06-21 | Clinton | Michigan | 26037 | 7637 | 91 |
1437866 | 1437866 | 2021-06-20 | Clinton | Michigan | 26037 | 7634 | 91 |
1434619 | 1434619 | 2021-06-19 | Clinton | Michigan | 26037 | 7634 | 91 |
1431372 | 1431372 | 2021-06-18 | Clinton | Michigan | 26037 | 7634 | 91 |
1428127 | 1428127 | 2021-06-17 | Clinton | Michigan | 26037 | 7632 | 91 |
1424882 | 1424882 | 2021-06-16 | Clinton | Michigan | 26037 | 7629 | 91 |
1421634 | 1421634 | 2021-06-15 | Clinton | Michigan | 26037 | 7627 | 91 |
1418389 | 1418389 | 2021-06-14 | Clinton | Michigan | 26037 | 7621 | 90 |
1415144 | 1415144 | 2021-06-13 | Clinton | Michigan | 26037 | 7618 | 90 |
1411898 | 1411898 | 2021-06-12 | Clinton | Michigan | 26037 | 7618 | 90 |
1408653 | 1408653 | 2021-06-11 | Clinton | Michigan | 26037 | 7617 | 90 |
1405408 | 1405408 | 2021-06-10 | Clinton | Michigan | 26037 | 7611 | 90 |
1402162 | 1402162 | 2021-06-09 | Clinton | Michigan | 26037 | 7608 | 90 |
1398917 | 1398917 | 2021-06-08 | Clinton | Michigan | 26037 | 7603 | 90 |
1395671 | 1395671 | 2021-06-07 | Clinton | Michigan | 26037 | 7602 | 90 |
1392425 | 1392425 | 2021-06-06 | Clinton | Michigan | 26037 | 7600 | 90 |
1389180 | 1389180 | 2021-06-05 | Clinton | Michigan | 26037 | 7600 | 90 |
1385935 | 1385935 | 2021-06-04 | Clinton | Michigan | 26037 | 7598 | 90 |
1382690 | 1382690 | 2021-06-03 | Clinton | Michigan | 26037 | 7592 | 90 |
1379444 | 1379444 | 2021-06-02 | Clinton | Michigan | 26037 | 7589 | 90 |
1376199 | 1376199 | 2021-06-01 | Clinton | Michigan | 26037 | 7588 | 89 |
1372953 | 1372953 | 2021-05-31 | Clinton | Michigan | 26037 | 7578 | 89 |
1369708 | 1369708 | 2021-05-30 | Clinton | Michigan | 26037 | 7578 | 89 |
1366462 | 1366462 | 2021-05-29 | Clinton | Michigan | 26037 | 7578 | 89 |
1363216 | 1363216 | 2021-05-28 | Clinton | Michigan | 26037 | 7575 | 89 |
1359969 | 1359969 | 2021-05-27 | Clinton | Michigan | 26037 | 7567 | 89 |
1356723 | 1356723 | 2021-05-26 | Clinton | Michigan | 26037 | 7559 | 88 |
1353477 | 1353477 | 2021-05-25 | Clinton | Michigan | 26037 | 7545 | 88 |
1350231 | 1350231 | 2021-05-24 | Clinton | Michigan | 26037 | 7538 | 87 |
1346985 | 1346985 | 2021-05-23 | Clinton | Michigan | 26037 | 7524 | 87 |
1343737 | 1343737 | 2021-05-22 | Clinton | Michigan | 26037 | 7524 | 87 |
1340488 | 1340488 | 2021-05-21 | Clinton | Michigan | 26037 | 7521 | 86 |
1337241 | 1337241 | 2021-05-20 | Clinton | Michigan | 26037 | 7515 | 86 |
1333994 | 1333994 | 2021-05-19 | Clinton | Michigan | 26037 | 7507 | 85 |
1330747 | 1330747 | 2021-05-18 | Clinton | Michigan | 26037 | 7496 | 85 |
1327500 | 1327500 | 2021-05-17 | Clinton | Michigan | 26037 | 7480 | 85 |
1324254 | 1324254 | 2021-05-16 | Clinton | Michigan | 26037 | 7464 | 85 |
1321008 | 1321008 | 2021-05-15 | Clinton | Michigan | 26037 | 7464 | 85 |
1317762 | 1317762 | 2021-05-14 | Clinton | Michigan | 26037 | 7456 | 85 |
1314514 | 1314514 | 2021-05-13 | Clinton | Michigan | 26037 | 7442 | 85 |
1311268 | 1311268 | 2021-05-12 | Clinton | Michigan | 26037 | 7432 | 85 |
1308021 | 1308021 | 2021-05-11 | Clinton | Michigan | 26037 | 7420 | 85 |
1304775 | 1304775 | 2021-05-10 | Clinton | Michigan | 26037 | 7410 | 85 |
1301529 | 1301529 | 2021-05-09 | Clinton | Michigan | 26037 | 7392 | 85 |
1298281 | 1298281 | 2021-05-08 | Clinton | Michigan | 26037 | 7392 | 85 |
1295035 | 1295035 | 2021-05-07 | Clinton | Michigan | 26037 | 7372 | 84 |
1291789 | 1291789 | 2021-05-06 | Clinton | Michigan | 26037 | 7359 | 83 |
1288543 | 1288543 | 2021-05-05 | Clinton | Michigan | 26037 | 7342 | 83 |
1285297 | 1285297 | 2021-05-04 | Clinton | Michigan | 26037 | 7318 | 82 |
1282051 | 1282051 | 2021-05-03 | Clinton | Michigan | 26037 | 7305 | 82 |
1278804 | 1278804 | 2021-05-02 | Clinton | Michigan | 26037 | 7286 | 82 |
1275557 | 1275557 | 2021-05-01 | Clinton | Michigan | 26037 | 7286 | 82 |
1272310 | 1272310 | 2021-04-30 | Clinton | Michigan | 26037 | 7271 | 81 |
1269063 | 1269063 | 2021-04-29 | Clinton | Michigan | 26037 | 7250 | 81 |
1265816 | 1265816 | 2021-04-28 | Clinton | Michigan | 26037 | 7235 | 81 |
1262569 | 1262569 | 2021-04-27 | Clinton | Michigan | 26037 | 7209 | 81 |
1259322 | 1259322 | 2021-04-26 | Clinton | Michigan | 26037 | 7188 | 80 |
1256075 | 1256075 | 2021-04-25 | Clinton | Michigan | 26037 | 7131 | 80 |
1252828 | 1252828 | 2021-04-24 | Clinton | Michigan | 26037 | 7131 | 80 |
1249581 | 1249581 | 2021-04-23 | Clinton | Michigan | 26037 | 7080 | 80 |
1246334 | 1246334 | 2021-04-22 | Clinton | Michigan | 26037 | 7029 | 80 |
1243087 | 1243087 | 2021-04-21 | Clinton | Michigan | 26037 | 6990 | 80 |
1239840 | 1239840 | 2021-04-20 | Clinton | Michigan | 26037 | 6934 | 80 |
1236593 | 1236593 | 2021-04-19 | Clinton | Michigan | 26037 | 6904 | 79 |
1233346 | 1233346 | 2021-04-18 | Clinton | Michigan | 26037 | 6845 | 79 |
1230098 | 1230098 | 2021-04-17 | Clinton | Michigan | 26037 | 6845 | 79 |
1226850 | 1226850 | 2021-04-16 | Clinton | Michigan | 26037 | 6811 | 79 |
1223602 | 1223602 | 2021-04-15 | Clinton | Michigan | 26037 | 6738 | 78 |
1220355 | 1220355 | 2021-04-14 | Clinton | Michigan | 26037 | 6706 | 77 |
1217107 | 1217107 | 2021-04-13 | Clinton | Michigan | 26037 | 6635 | 77 |
1213860 | 1213860 | 2021-04-12 | Clinton | Michigan | 26037 | 6558 | 75 |
1210612 | 1210612 | 2021-04-11 | Clinton | Michigan | 26037 | 6502 | 75 |
1207363 | 1207363 | 2021-04-10 | Clinton | Michigan | 26037 | 6502 | 75 |
1204115 | 1204115 | 2021-04-09 | Clinton | Michigan | 26037 | 6436 | 75 |
1200867 | 1200867 | 2021-04-08 | Clinton | Michigan | 26037 | 6372 | 75 |
1197618 | 1197618 | 2021-04-07 | Clinton | Michigan | 26037 | 6329 | 75 |
1194369 | 1194369 | 2021-04-06 | Clinton | Michigan | 26037 | 6259 | 75 |
1191120 | 1191120 | 2021-04-05 | Clinton | Michigan | 26037 | 6221 | 75 |
1187872 | 1187872 | 2021-04-04 | Clinton | Michigan | 26037 | 6090 | 75 |
1184625 | 1184625 | 2021-04-03 | Clinton | Michigan | 26037 | 6090 | 75 |
1181379 | 1181379 | 2021-04-02 | Clinton | Michigan | 26037 | 6053 | 75 |
1178132 | 1178132 | 2021-04-01 | Clinton | Michigan | 26037 | 5999 | 75 |
1174885 | 1174885 | 2021-03-31 | Clinton | Michigan | 26037 | 5940 | 75 |
1171638 | 1171638 | 2021-03-30 | Clinton | Michigan | 26037 | 5885 | 75 |
1168390 | 1168390 | 2021-03-29 | Clinton | Michigan | 26037 | 5813 | 75 |
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);