ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 26027 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717149 | 1717149 | 2021-09-14 | Cass | Michigan | 26027 | 6080 | 81 |
1713901 | 1713901 | 2021-09-13 | Cass | Michigan | 26027 | 6080 | 81 |
1710655 | 1710655 | 2021-09-12 | Cass | Michigan | 26027 | 6041 | 81 |
1707408 | 1707408 | 2021-09-11 | Cass | Michigan | 26027 | 6041 | 81 |
1704161 | 1704161 | 2021-09-10 | Cass | Michigan | 26027 | 6041 | 81 |
1700911 | 1700911 | 2021-09-09 | Cass | Michigan | 26027 | 5992 | 80 |
1697662 | 1697662 | 2021-09-08 | Cass | Michigan | 26027 | 5992 | 80 |
1694414 | 1694414 | 2021-09-07 | Cass | Michigan | 26027 | 5976 | 80 |
1691165 | 1691165 | 2021-09-06 | Cass | Michigan | 26027 | 5930 | 80 |
1687915 | 1687915 | 2021-09-05 | Cass | Michigan | 26027 | 5930 | 80 |
1684665 | 1684665 | 2021-09-04 | Cass | Michigan | 26027 | 5930 | 80 |
1681414 | 1681414 | 2021-09-03 | Cass | Michigan | 26027 | 5930 | 80 |
1678166 | 1678166 | 2021-09-02 | Cass | Michigan | 26027 | 5899 | 80 |
1674918 | 1674918 | 2021-09-01 | Cass | Michigan | 26027 | 5899 | 80 |
1671670 | 1671670 | 2021-08-31 | Cass | Michigan | 26027 | 5863 | 79 |
1668423 | 1668423 | 2021-08-30 | Cass | Michigan | 26027 | 5863 | 79 |
1665176 | 1665176 | 2021-08-29 | Cass | Michigan | 26027 | 5844 | 79 |
1661928 | 1661928 | 2021-08-28 | Cass | Michigan | 26027 | 5844 | 79 |
1658680 | 1658680 | 2021-08-27 | Cass | Michigan | 26027 | 5844 | 79 |
1655431 | 1655431 | 2021-08-26 | Cass | Michigan | 26027 | 5817 | 79 |
1652184 | 1652184 | 2021-08-25 | Cass | Michigan | 26027 | 5817 | 79 |
1648936 | 1648936 | 2021-08-24 | Cass | Michigan | 26027 | 5782 | 78 |
1645687 | 1645687 | 2021-08-23 | Cass | Michigan | 26027 | 5782 | 78 |
1642438 | 1642438 | 2021-08-22 | Cass | Michigan | 26027 | 5743 | 78 |
1639188 | 1639188 | 2021-08-21 | Cass | Michigan | 26027 | 5743 | 78 |
1635938 | 1635938 | 2021-08-20 | Cass | Michigan | 26027 | 5743 | 78 |
1632688 | 1632688 | 2021-08-19 | Cass | Michigan | 26027 | 5712 | 78 |
1629441 | 1629441 | 2021-08-18 | Cass | Michigan | 26027 | 5712 | 78 |
1626194 | 1626194 | 2021-08-17 | Cass | Michigan | 26027 | 5697 | 78 |
1622947 | 1622947 | 2021-08-16 | Cass | Michigan | 26027 | 5697 | 78 |
1619700 | 1619700 | 2021-08-15 | Cass | Michigan | 26027 | 5678 | 78 |
1616452 | 1616452 | 2021-08-14 | Cass | Michigan | 26027 | 5678 | 78 |
1613204 | 1613204 | 2021-08-13 | Cass | Michigan | 26027 | 5678 | 78 |
1609955 | 1609955 | 2021-08-12 | Cass | Michigan | 26027 | 5655 | 78 |
1606707 | 1606707 | 2021-08-11 | Cass | Michigan | 26027 | 5655 | 78 |
1603458 | 1603458 | 2021-08-10 | Cass | Michigan | 26027 | 5641 | 78 |
1600209 | 1600209 | 2021-08-09 | Cass | Michigan | 26027 | 5641 | 78 |
1596961 | 1596961 | 2021-08-08 | Cass | Michigan | 26027 | 5621 | 78 |
1593712 | 1593712 | 2021-08-07 | Cass | Michigan | 26027 | 5621 | 78 |
1590463 | 1590463 | 2021-08-06 | Cass | Michigan | 26027 | 5621 | 78 |
1587214 | 1587214 | 2021-08-05 | Cass | Michigan | 26027 | 5594 | 78 |
1583963 | 1583963 | 2021-08-04 | Cass | Michigan | 26027 | 5594 | 78 |
1580714 | 1580714 | 2021-08-03 | Cass | Michigan | 26027 | 5594 | 78 |
1577465 | 1577465 | 2021-08-02 | Cass | Michigan | 26027 | 5577 | 78 |
1574217 | 1574217 | 2021-08-01 | Cass | Michigan | 26027 | 5577 | 78 |
1570969 | 1570969 | 2021-07-31 | Cass | Michigan | 26027 | 5577 | 78 |
1567721 | 1567721 | 2021-07-30 | Cass | Michigan | 26027 | 5577 | 78 |
1564473 | 1564473 | 2021-07-29 | Cass | Michigan | 26027 | 5557 | 78 |
1561225 | 1561225 | 2021-07-28 | Cass | Michigan | 26027 | 5557 | 78 |
1557977 | 1557977 | 2021-07-27 | Cass | Michigan | 26027 | 5557 | 78 |
1554730 | 1554730 | 2021-07-26 | Cass | Michigan | 26027 | 5544 | 78 |
1551483 | 1551483 | 2021-07-25 | Cass | Michigan | 26027 | 5544 | 78 |
1548236 | 1548236 | 2021-07-24 | Cass | Michigan | 26027 | 5544 | 78 |
1544989 | 1544989 | 2021-07-23 | Cass | Michigan | 26027 | 5544 | 78 |
1541741 | 1541741 | 2021-07-22 | Cass | Michigan | 26027 | 5522 | 78 |
1538494 | 1538494 | 2021-07-21 | Cass | Michigan | 26027 | 5522 | 78 |
1535247 | 1535247 | 2021-07-20 | Cass | Michigan | 26027 | 5522 | 78 |
1531999 | 1531999 | 2021-07-19 | Cass | Michigan | 26027 | 5516 | 78 |
1528752 | 1528752 | 2021-07-18 | Cass | Michigan | 26027 | 5516 | 78 |
1525505 | 1525505 | 2021-07-17 | Cass | Michigan | 26027 | 5516 | 78 |
1522258 | 1522258 | 2021-07-16 | Cass | Michigan | 26027 | 5516 | 78 |
1519009 | 1519009 | 2021-07-15 | Cass | Michigan | 26027 | 5513 | 78 |
1515762 | 1515762 | 2021-07-14 | Cass | Michigan | 26027 | 5513 | 78 |
1512516 | 1512516 | 2021-07-13 | Cass | Michigan | 26027 | 5513 | 78 |
1509269 | 1509269 | 2021-07-12 | Cass | Michigan | 26027 | 5508 | 78 |
1506023 | 1506023 | 2021-07-11 | Cass | Michigan | 26027 | 5508 | 78 |
1502777 | 1502777 | 2021-07-10 | Cass | Michigan | 26027 | 5508 | 78 |
1499531 | 1499531 | 2021-07-09 | Cass | Michigan | 26027 | 5508 | 78 |
1496285 | 1496285 | 2021-07-08 | Cass | Michigan | 26027 | 5507 | 77 |
1493038 | 1493038 | 2021-07-07 | Cass | Michigan | 26027 | 5507 | 77 |
1489791 | 1489791 | 2021-07-06 | Cass | Michigan | 26027 | 5507 | 77 |
1486544 | 1486544 | 2021-07-05 | Cass | Michigan | 26027 | 5504 | 77 |
1483298 | 1483298 | 2021-07-04 | Cass | Michigan | 26027 | 5504 | 77 |
1480052 | 1480052 | 2021-07-03 | Cass | Michigan | 26027 | 5504 | 77 |
1476805 | 1476805 | 2021-07-02 | Cass | Michigan | 26027 | 5504 | 77 |
1473559 | 1473559 | 2021-07-01 | Cass | Michigan | 26027 | 5503 | 77 |
1470313 | 1470313 | 2021-06-30 | Cass | Michigan | 26027 | 5501 | 77 |
1467068 | 1467068 | 2021-06-29 | Cass | Michigan | 26027 | 5499 | 77 |
1463823 | 1463823 | 2021-06-28 | Cass | Michigan | 26027 | 5496 | 77 |
1460578 | 1460578 | 2021-06-27 | Cass | Michigan | 26027 | 5495 | 77 |
1457333 | 1457333 | 2021-06-26 | Cass | Michigan | 26027 | 5495 | 77 |
1454088 | 1454088 | 2021-06-25 | Cass | Michigan | 26027 | 5495 | 77 |
1450843 | 1450843 | 2021-06-24 | Cass | Michigan | 26027 | 5493 | 77 |
1447597 | 1447597 | 2021-06-23 | Cass | Michigan | 26027 | 5494 | 77 |
1444352 | 1444352 | 2021-06-22 | Cass | Michigan | 26027 | 5493 | 77 |
1441107 | 1441107 | 2021-06-21 | Cass | Michigan | 26027 | 5490 | 77 |
1437861 | 1437861 | 2021-06-20 | Cass | Michigan | 26027 | 5489 | 77 |
1434614 | 1434614 | 2021-06-19 | Cass | Michigan | 26027 | 5489 | 77 |
1431367 | 1431367 | 2021-06-18 | Cass | Michigan | 26027 | 5489 | 77 |
1428122 | 1428122 | 2021-06-17 | Cass | Michigan | 26027 | 5489 | 77 |
1424877 | 1424877 | 2021-06-16 | Cass | Michigan | 26027 | 5487 | 77 |
1421629 | 1421629 | 2021-06-15 | Cass | Michigan | 26027 | 5486 | 77 |
1418384 | 1418384 | 2021-06-14 | Cass | Michigan | 26027 | 5484 | 77 |
1415139 | 1415139 | 2021-06-13 | Cass | Michigan | 26027 | 5482 | 76 |
1411893 | 1411893 | 2021-06-12 | Cass | Michigan | 26027 | 5482 | 76 |
1408648 | 1408648 | 2021-06-11 | Cass | Michigan | 26027 | 5480 | 76 |
1405403 | 1405403 | 2021-06-10 | Cass | Michigan | 26027 | 5472 | 76 |
1402157 | 1402157 | 2021-06-09 | Cass | Michigan | 26027 | 5470 | 76 |
1398912 | 1398912 | 2021-06-08 | Cass | Michigan | 26027 | 5464 | 76 |
1395666 | 1395666 | 2021-06-07 | Cass | Michigan | 26027 | 5460 | 76 |
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);