ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where county = "Clare" and deaths = 69 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1204114 | 1204114 | 2021-04-09 | Clare | Michigan | 26035 | 1895 | 69 |
1200866 | 1200866 | 2021-04-08 | Clare | Michigan | 26035 | 1868 | 69 |
1197617 | 1197617 | 2021-04-07 | Clare | Michigan | 26035 | 1832 | 69 |
1194368 | 1194368 | 2021-04-06 | Clare | Michigan | 26035 | 1819 | 69 |
1191119 | 1191119 | 2021-04-05 | Clare | Michigan | 26035 | 1803 | 69 |
1187871 | 1187871 | 2021-04-04 | Clare | Michigan | 26035 | 1782 | 69 |
1184624 | 1184624 | 2021-04-03 | Clare | Michigan | 26035 | 1782 | 69 |
1181378 | 1181378 | 2021-04-02 | Clare | Michigan | 26035 | 1764 | 69 |
1178131 | 1178131 | 2021-04-01 | Clare | Michigan | 26035 | 1753 | 69 |
1174884 | 1174884 | 2021-03-31 | Clare | Michigan | 26035 | 1740 | 69 |
1171637 | 1171637 | 2021-03-30 | Clare | Michigan | 26035 | 1719 | 69 |
1168389 | 1168389 | 2021-03-29 | Clare | Michigan | 26035 | 1705 | 69 |
1165141 | 1165141 | 2021-03-28 | Clare | Michigan | 26035 | 1698 | 69 |
1161893 | 1161893 | 2021-03-27 | Clare | Michigan | 26035 | 1698 | 69 |
1158645 | 1158645 | 2021-03-26 | Clare | Michigan | 26035 | 1688 | 69 |
1155398 | 1155398 | 2021-03-25 | Clare | Michigan | 26035 | 1679 | 69 |
1152151 | 1152151 | 2021-03-24 | Clare | Michigan | 26035 | 1671 | 69 |
1148904 | 1148904 | 2021-03-23 | Clare | Michigan | 26035 | 1663 | 69 |
1145657 | 1145657 | 2021-03-22 | Clare | Michigan | 26035 | 1652 | 69 |
1142410 | 1142410 | 2021-03-21 | Clare | Michigan | 26035 | 1646 | 69 |
1139163 | 1139163 | 2021-03-20 | Clare | Michigan | 26035 | 1646 | 69 |
1135917 | 1135917 | 2021-03-19 | Clare | Michigan | 26035 | 1645 | 69 |
1132671 | 1132671 | 2021-03-18 | Clare | Michigan | 26035 | 1642 | 69 |
1129423 | 1129423 | 2021-03-17 | Clare | Michigan | 26035 | 1641 | 69 |
1126176 | 1126176 | 2021-03-16 | Clare | Michigan | 26035 | 1639 | 69 |
1122930 | 1122930 | 2021-03-15 | Clare | Michigan | 26035 | 1637 | 69 |
1119683 | 1119683 | 2021-03-14 | Clare | Michigan | 26035 | 1633 | 69 |
1116436 | 1116436 | 2021-03-13 | Clare | Michigan | 26035 | 1633 | 69 |
1113190 | 1113190 | 2021-03-12 | Clare | Michigan | 26035 | 1631 | 69 |
1109944 | 1109944 | 2021-03-11 | Clare | Michigan | 26035 | 1633 | 69 |
1106698 | 1106698 | 2021-03-10 | Clare | Michigan | 26035 | 1630 | 69 |
1103452 | 1103452 | 2021-03-09 | Clare | Michigan | 26035 | 1628 | 69 |
1100206 | 1100206 | 2021-03-08 | Clare | Michigan | 26035 | 1625 | 69 |
1096959 | 1096959 | 2021-03-07 | Clare | Michigan | 26035 | 1626 | 69 |
1093712 | 1093712 | 2021-03-06 | Clare | Michigan | 26035 | 1626 | 69 |
1090466 | 1090466 | 2021-03-05 | Clare | Michigan | 26035 | 1625 | 69 |
1087221 | 1087221 | 2021-03-04 | Clare | Michigan | 26035 | 1625 | 69 |
1083976 | 1083976 | 2021-03-03 | Clare | Michigan | 26035 | 1620 | 69 |
1080730 | 1080730 | 2021-03-02 | Clare | Michigan | 26035 | 1617 | 69 |
1077484 | 1077484 | 2021-03-01 | Clare | Michigan | 26035 | 1615 | 69 |
1074238 | 1074238 | 2021-02-28 | Clare | Michigan | 26035 | 1607 | 69 |
1070992 | 1070992 | 2021-02-27 | Clare | Michigan | 26035 | 1607 | 69 |
1067747 | 1067747 | 2021-02-26 | Clare | Michigan | 26035 | 1606 | 69 |
1064502 | 1064502 | 2021-02-25 | Clare | Michigan | 26035 | 1605 | 69 |
1061258 | 1061258 | 2021-02-24 | Clare | Michigan | 26035 | 1602 | 69 |
1058012 | 1058012 | 2021-02-23 | Clare | Michigan | 26035 | 1598 | 69 |
1054766 | 1054766 | 2021-02-22 | Clare | Michigan | 26035 | 1595 | 69 |
1051519 | 1051519 | 2021-02-21 | Clare | Michigan | 26035 | 1593 | 69 |
1048272 | 1048272 | 2021-02-20 | Clare | Michigan | 26035 | 1593 | 69 |
1045026 | 1045026 | 2021-02-19 | Clare | Michigan | 26035 | 1591 | 69 |
1041781 | 1041781 | 2021-02-18 | Clare | Michigan | 26035 | 1592 | 69 |
1038536 | 1038536 | 2021-02-17 | Clare | Michigan | 26035 | 1590 | 69 |
1035291 | 1035291 | 2021-02-16 | Clare | Michigan | 26035 | 1587 | 69 |
1032046 | 1032046 | 2021-02-15 | Clare | Michigan | 26035 | 1584 | 69 |
1028799 | 1028799 | 2021-02-14 | Clare | Michigan | 26035 | 1582 | 69 |
1025553 | 1025553 | 2021-02-13 | Clare | Michigan | 26035 | 1582 | 69 |
1022308 | 1022308 | 2021-02-12 | Clare | Michigan | 26035 | 1582 | 69 |
1019063 | 1019063 | 2021-02-11 | Clare | Michigan | 26035 | 1576 | 69 |
1015818 | 1015818 | 2021-02-10 | Clare | Michigan | 26035 | 1573 | 69 |
1012573 | 1012573 | 2021-02-09 | Clare | Michigan | 26035 | 1569 | 69 |
1009328 | 1009328 | 2021-02-08 | Clare | Michigan | 26035 | 1565 | 69 |
1006081 | 1006081 | 2021-02-07 | Clare | Michigan | 26035 | 1558 | 69 |
1002835 | 1002835 | 2021-02-06 | Clare | Michigan | 26035 | 1558 | 69 |
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);