ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where fips = 26003 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418372 | 1418372 | 2021-06-14 | Alger | Michigan | 26003 | 667 | 7 |
1415127 | 1415127 | 2021-06-13 | Alger | Michigan | 26003 | 667 | 7 |
1411881 | 1411881 | 2021-06-12 | Alger | Michigan | 26003 | 667 | 7 |
1408636 | 1408636 | 2021-06-11 | Alger | Michigan | 26003 | 667 | 7 |
1405391 | 1405391 | 2021-06-10 | Alger | Michigan | 26003 | 667 | 7 |
1402145 | 1402145 | 2021-06-09 | Alger | Michigan | 26003 | 667 | 7 |
1398900 | 1398900 | 2021-06-08 | Alger | Michigan | 26003 | 667 | 7 |
1395654 | 1395654 | 2021-06-07 | Alger | Michigan | 26003 | 667 | 7 |
1392408 | 1392408 | 2021-06-06 | Alger | Michigan | 26003 | 666 | 7 |
1389163 | 1389163 | 2021-06-05 | Alger | Michigan | 26003 | 666 | 7 |
1385918 | 1385918 | 2021-06-04 | Alger | Michigan | 26003 | 666 | 7 |
1382673 | 1382673 | 2021-06-03 | Alger | Michigan | 26003 | 666 | 7 |
1379427 | 1379427 | 2021-06-02 | Alger | Michigan | 26003 | 666 | 6 |
1376182 | 1376182 | 2021-06-01 | Alger | Michigan | 26003 | 666 | 6 |
1372936 | 1372936 | 2021-05-31 | Alger | Michigan | 26003 | 666 | 6 |
1369691 | 1369691 | 2021-05-30 | Alger | Michigan | 26003 | 666 | 6 |
1366445 | 1366445 | 2021-05-29 | Alger | Michigan | 26003 | 666 | 6 |
1363199 | 1363199 | 2021-05-28 | Alger | Michigan | 26003 | 666 | 6 |
1359952 | 1359952 | 2021-05-27 | Alger | Michigan | 26003 | 666 | 6 |
1356706 | 1356706 | 2021-05-26 | Alger | Michigan | 26003 | 666 | 6 |
1353460 | 1353460 | 2021-05-25 | Alger | Michigan | 26003 | 666 | 6 |
1350214 | 1350214 | 2021-05-24 | Alger | Michigan | 26003 | 665 | 6 |
1346968 | 1346968 | 2021-05-23 | Alger | Michigan | 26003 | 665 | 6 |
1343720 | 1343720 | 2021-05-22 | Alger | Michigan | 26003 | 665 | 6 |
1340471 | 1340471 | 2021-05-21 | Alger | Michigan | 26003 | 664 | 6 |
1337224 | 1337224 | 2021-05-20 | Alger | Michigan | 26003 | 664 | 6 |
1333977 | 1333977 | 2021-05-19 | Alger | Michigan | 26003 | 664 | 6 |
1330730 | 1330730 | 2021-05-18 | Alger | Michigan | 26003 | 664 | 6 |
1327483 | 1327483 | 2021-05-17 | Alger | Michigan | 26003 | 663 | 6 |
1324237 | 1324237 | 2021-05-16 | Alger | Michigan | 26003 | 663 | 6 |
1320991 | 1320991 | 2021-05-15 | Alger | Michigan | 26003 | 663 | 6 |
1317745 | 1317745 | 2021-05-14 | Alger | Michigan | 26003 | 663 | 6 |
1314497 | 1314497 | 2021-05-13 | Alger | Michigan | 26003 | 662 | 6 |
1311251 | 1311251 | 2021-05-12 | Alger | Michigan | 26003 | 661 | 6 |
1308004 | 1308004 | 2021-05-11 | Alger | Michigan | 26003 | 660 | 6 |
1304758 | 1304758 | 2021-05-10 | Alger | Michigan | 26003 | 659 | 6 |
1301512 | 1301512 | 2021-05-09 | Alger | Michigan | 26003 | 658 | 6 |
1298264 | 1298264 | 2021-05-08 | Alger | Michigan | 26003 | 658 | 6 |
1295018 | 1295018 | 2021-05-07 | Alger | Michigan | 26003 | 658 | 6 |
1291772 | 1291772 | 2021-05-06 | Alger | Michigan | 26003 | 658 | 6 |
1288526 | 1288526 | 2021-05-05 | Alger | Michigan | 26003 | 656 | 6 |
1285280 | 1285280 | 2021-05-04 | Alger | Michigan | 26003 | 656 | 6 |
1282034 | 1282034 | 2021-05-03 | Alger | Michigan | 26003 | 649 | 6 |
1278787 | 1278787 | 2021-05-02 | Alger | Michigan | 26003 | 647 | 6 |
1275540 | 1275540 | 2021-05-01 | Alger | Michigan | 26003 | 647 | 6 |
1272293 | 1272293 | 2021-04-30 | Alger | Michigan | 26003 | 647 | 6 |
1269046 | 1269046 | 2021-04-29 | Alger | Michigan | 26003 | 645 | 6 |
1265799 | 1265799 | 2021-04-28 | Alger | Michigan | 26003 | 645 | 6 |
1262552 | 1262552 | 2021-04-27 | Alger | Michigan | 26003 | 644 | 6 |
1259305 | 1259305 | 2021-04-26 | Alger | Michigan | 26003 | 643 | 6 |
1256058 | 1256058 | 2021-04-25 | Alger | Michigan | 26003 | 642 | 6 |
1252811 | 1252811 | 2021-04-24 | Alger | Michigan | 26003 | 642 | 6 |
1249564 | 1249564 | 2021-04-23 | Alger | Michigan | 26003 | 641 | 6 |
1246317 | 1246317 | 2021-04-22 | Alger | Michigan | 26003 | 641 | 6 |
1243070 | 1243070 | 2021-04-21 | Alger | Michigan | 26003 | 637 | 6 |
1239823 | 1239823 | 2021-04-20 | Alger | Michigan | 26003 | 636 | 6 |
1236576 | 1236576 | 2021-04-19 | Alger | Michigan | 26003 | 633 | 6 |
1233329 | 1233329 | 2021-04-18 | Alger | Michigan | 26003 | 632 | 5 |
1230081 | 1230081 | 2021-04-17 | Alger | Michigan | 26003 | 632 | 5 |
1226833 | 1226833 | 2021-04-16 | Alger | Michigan | 26003 | 632 | 5 |
1223585 | 1223585 | 2021-04-15 | Alger | Michigan | 26003 | 630 | 5 |
1220338 | 1220338 | 2021-04-14 | Alger | Michigan | 26003 | 630 | 5 |
1217090 | 1217090 | 2021-04-13 | Alger | Michigan | 26003 | 626 | 5 |
1213843 | 1213843 | 2021-04-12 | Alger | Michigan | 26003 | 623 | 5 |
1210595 | 1210595 | 2021-04-11 | Alger | Michigan | 26003 | 620 | 5 |
1207346 | 1207346 | 2021-04-10 | Alger | Michigan | 26003 | 620 | 5 |
1204098 | 1204098 | 2021-04-09 | Alger | Michigan | 26003 | 618 | 5 |
1200850 | 1200850 | 2021-04-08 | Alger | Michigan | 26003 | 618 | 5 |
1197601 | 1197601 | 2021-04-07 | Alger | Michigan | 26003 | 613 | 5 |
1194352 | 1194352 | 2021-04-06 | Alger | Michigan | 26003 | 610 | 5 |
1191103 | 1191103 | 2021-04-05 | Alger | Michigan | 26003 | 609 | 5 |
1187855 | 1187855 | 2021-04-04 | Alger | Michigan | 26003 | 606 | 5 |
1184608 | 1184608 | 2021-04-03 | Alger | Michigan | 26003 | 606 | 5 |
1181362 | 1181362 | 2021-04-02 | Alger | Michigan | 26003 | 605 | 5 |
1178115 | 1178115 | 2021-04-01 | Alger | Michigan | 26003 | 603 | 5 |
1174868 | 1174868 | 2021-03-31 | Alger | Michigan | 26003 | 601 | 5 |
1171621 | 1171621 | 2021-03-30 | Alger | Michigan | 26003 | 598 | 5 |
1168373 | 1168373 | 2021-03-29 | Alger | Michigan | 26003 | 595 | 5 |
1165125 | 1165125 | 2021-03-28 | Alger | Michigan | 26003 | 594 | 5 |
1161877 | 1161877 | 2021-03-27 | Alger | Michigan | 26003 | 594 | 5 |
1158629 | 1158629 | 2021-03-26 | Alger | Michigan | 26003 | 593 | 5 |
1155382 | 1155382 | 2021-03-25 | Alger | Michigan | 26003 | 593 | 5 |
1152135 | 1152135 | 2021-03-24 | Alger | Michigan | 26003 | 593 | 5 |
1148888 | 1148888 | 2021-03-23 | Alger | Michigan | 26003 | 593 | 5 |
1145641 | 1145641 | 2021-03-22 | Alger | Michigan | 26003 | 592 | 5 |
1142394 | 1142394 | 2021-03-21 | Alger | Michigan | 26003 | 590 | 5 |
1139147 | 1139147 | 2021-03-20 | Alger | Michigan | 26003 | 590 | 5 |
1135901 | 1135901 | 2021-03-19 | Alger | Michigan | 26003 | 589 | 5 |
1132655 | 1132655 | 2021-03-18 | Alger | Michigan | 26003 | 587 | 5 |
1129407 | 1129407 | 2021-03-17 | Alger | Michigan | 26003 | 587 | 5 |
1126160 | 1126160 | 2021-03-16 | Alger | Michigan | 26003 | 586 | 5 |
1122914 | 1122914 | 2021-03-15 | Alger | Michigan | 26003 | 584 | 5 |
1119667 | 1119667 | 2021-03-14 | Alger | Michigan | 26003 | 584 | 5 |
1116420 | 1116420 | 2021-03-13 | Alger | Michigan | 26003 | 584 | 5 |
1113174 | 1113174 | 2021-03-12 | Alger | Michigan | 26003 | 584 | 5 |
1109928 | 1109928 | 2021-03-11 | Alger | Michigan | 26003 | 584 | 5 |
1106682 | 1106682 | 2021-03-10 | Alger | Michigan | 26003 | 584 | 5 |
1103436 | 1103436 | 2021-03-09 | Alger | Michigan | 26003 | 584 | 5 |
1100190 | 1100190 | 2021-03-08 | Alger | Michigan | 26003 | 584 | 5 |
1096943 | 1096943 | 2021-03-07 | Alger | Michigan | 26003 | 584 | 5 |
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);