ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Kent" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110413 | 2110413 | 2022-01-13 | Kent | Michigan | 26081 | 138186 | 1326 |
2107162 | 2107162 | 2022-01-12 | Kent | Michigan | 26081 | 138186 | 1326 |
2103911 | 2103911 | 2022-01-11 | Kent | Michigan | 26081 | 135687 | 1304 |
2100660 | 2100660 | 2022-01-10 | Kent | Michigan | 26081 | 135687 | 1304 |
2097409 | 2097409 | 2022-01-09 | Kent | Michigan | 26081 | 132568 | 1294 |
2094157 | 2094157 | 2022-01-08 | Kent | Michigan | 26081 | 132568 | 1294 |
2090905 | 2090905 | 2022-01-07 | Kent | Michigan | 26081 | 132568 | 1294 |
2087654 | 2087654 | 2022-01-06 | Kent | Michigan | 26081 | 129607 | 1281 |
2084402 | 2084402 | 2022-01-05 | Kent | Michigan | 26081 | 129607 | 1281 |
2081150 | 2081150 | 2022-01-04 | Kent | Michigan | 26081 | 127560 | 1270 |
2077898 | 2077898 | 2022-01-03 | Kent | Michigan | 26081 | 127560 | 1270 |
2074647 | 2074647 | 2022-01-02 | Kent | Michigan | 26081 | 122995 | 1246 |
2071396 | 2071396 | 2022-01-01 | Kent | Michigan | 26081 | 122995 | 1246 |
2068145 | 2068145 | 2021-12-31 | Kent | Michigan | 26081 | 122995 | 1246 |
2064894 | 2064894 | 2021-12-30 | Kent | Michigan | 26081 | 122995 | 1246 |
2061644 | 2061644 | 2021-12-29 | Kent | Michigan | 26081 | 122995 | 1246 |
2058395 | 2058395 | 2021-12-28 | Kent | Michigan | 26081 | 121287 | 1231 |
2055146 | 2055146 | 2021-12-27 | Kent | Michigan | 26081 | 121287 | 1231 |
2051896 | 2051896 | 2021-12-26 | Kent | Michigan | 26081 | 119292 | 1213 |
2048646 | 2048646 | 2021-12-25 | Kent | Michigan | 26081 | 119292 | 1213 |
2045396 | 2045396 | 2021-12-24 | Kent | Michigan | 26081 | 119292 | 1213 |
2042146 | 2042146 | 2021-12-23 | Kent | Michigan | 26081 | 119292 | 1213 |
2038897 | 2038897 | 2021-12-22 | Kent | Michigan | 26081 | 119292 | 1213 |
2035647 | 2035647 | 2021-12-21 | Kent | Michigan | 26081 | 118505 | 1203 |
2032397 | 2032397 | 2021-12-20 | Kent | Michigan | 26081 | 118505 | 1203 |
2029146 | 2029146 | 2021-12-19 | Kent | Michigan | 26081 | 117730 | 1190 |
2025895 | 2025895 | 2021-12-18 | Kent | Michigan | 26081 | 117730 | 1190 |
2022644 | 2022644 | 2021-12-17 | Kent | Michigan | 26081 | 117730 | 1190 |
2019393 | 2019393 | 2021-12-16 | Kent | Michigan | 26081 | 116958 | 1187 |
2016143 | 2016143 | 2021-12-15 | Kent | Michigan | 26081 | 116958 | 1187 |
2012892 | 2012892 | 2021-12-14 | Kent | Michigan | 26081 | 116170 | 1179 |
2009641 | 2009641 | 2021-12-13 | Kent | Michigan | 26081 | 116170 | 1179 |
2006390 | 2006390 | 2021-12-12 | Kent | Michigan | 26081 | 115124 | 1167 |
2003139 | 2003139 | 2021-12-11 | Kent | Michigan | 26081 | 115124 | 1167 |
1999889 | 1999889 | 2021-12-10 | Kent | Michigan | 26081 | 115124 | 1167 |
1996638 | 1996638 | 2021-12-09 | Kent | Michigan | 26081 | 114279 | 1162 |
1993387 | 1993387 | 2021-12-08 | Kent | Michigan | 26081 | 114279 | 1162 |
1990136 | 1990136 | 2021-12-07 | Kent | Michigan | 26081 | 113281 | 1143 |
1986886 | 1986886 | 2021-12-06 | Kent | Michigan | 26081 | 113281 | 1143 |
1983636 | 1983636 | 2021-12-05 | Kent | Michigan | 26081 | 112158 | 1130 |
1980386 | 1980386 | 2021-12-04 | Kent | Michigan | 26081 | 112158 | 1130 |
1977136 | 1977136 | 2021-12-03 | Kent | Michigan | 26081 | 112158 | 1130 |
1973886 | 1973886 | 2021-12-02 | Kent | Michigan | 26081 | 110662 | 1107 |
1970637 | 1970637 | 2021-12-01 | Kent | Michigan | 26081 | 110662 | 1107 |
1967387 | 1967387 | 2021-11-30 | Kent | Michigan | 26081 | 109356 | 1082 |
1964135 | 1964135 | 2021-11-29 | Kent | Michigan | 26081 | 109356 | 1082 |
1960884 | 1960884 | 2021-11-28 | Kent | Michigan | 26081 | 107423 | 1075 |
1957633 | 1957633 | 2021-11-27 | Kent | Michigan | 26081 | 107423 | 1075 |
1954382 | 1954382 | 2021-11-26 | Kent | Michigan | 26081 | 107423 | 1075 |
1951131 | 1951131 | 2021-11-25 | Kent | Michigan | 26081 | 107423 | 1075 |
1947880 | 1947880 | 2021-11-24 | Kent | Michigan | 26081 | 107423 | 1075 |
1944629 | 1944629 | 2021-11-23 | Kent | Michigan | 26081 | 105981 | 1052 |
1941378 | 1941378 | 2021-11-22 | Kent | Michigan | 26081 | 105981 | 1052 |
1938128 | 1938128 | 2021-11-21 | Kent | Michigan | 26081 | 104456 | 1050 |
1934878 | 1934878 | 2021-11-20 | Kent | Michigan | 26081 | 104456 | 1050 |
1931628 | 1931628 | 2021-11-19 | Kent | Michigan | 26081 | 104456 | 1050 |
1928377 | 1928377 | 2021-11-18 | Kent | Michigan | 26081 | 102675 | 1045 |
1925127 | 1925127 | 2021-11-17 | Kent | Michigan | 26081 | 102675 | 1045 |
1921878 | 1921878 | 2021-11-16 | Kent | Michigan | 26081 | 101346 | 1035 |
1918628 | 1918628 | 2021-11-15 | Kent | Michigan | 26081 | 101346 | 1035 |
1915378 | 1915378 | 2021-11-14 | Kent | Michigan | 26081 | 99495 | 1027 |
1912128 | 1912128 | 2021-11-13 | Kent | Michigan | 26081 | 99495 | 1027 |
1908878 | 1908878 | 2021-11-12 | Kent | Michigan | 26081 | 99495 | 1027 |
1905629 | 1905629 | 2021-11-11 | Kent | Michigan | 26081 | 97903 | 1024 |
1902380 | 1902380 | 2021-11-10 | Kent | Michigan | 26081 | 97903 | 1024 |
1899130 | 1899130 | 2021-11-09 | Kent | Michigan | 26081 | 97462 | 1015 |
1895880 | 1895880 | 2021-11-08 | Kent | Michigan | 26081 | 97462 | 1015 |
1892630 | 1892630 | 2021-11-07 | Kent | Michigan | 26081 | 96768 | 1010 |
1889380 | 1889380 | 2021-11-06 | Kent | Michigan | 26081 | 96768 | 1010 |
1886130 | 1886130 | 2021-11-05 | Kent | Michigan | 26081 | 96768 | 1010 |
1882881 | 1882881 | 2021-11-04 | Kent | Michigan | 26081 | 95904 | 1007 |
1879632 | 1879632 | 2021-11-03 | Kent | Michigan | 26081 | 95904 | 1007 |
1876383 | 1876383 | 2021-11-02 | Kent | Michigan | 26081 | 95067 | 1003 |
1873134 | 1873134 | 2021-11-01 | Kent | Michigan | 26081 | 95067 | 1003 |
1869885 | 1869885 | 2021-10-31 | Kent | Michigan | 26081 | 94331 | 999 |
1866636 | 1866636 | 2021-10-30 | Kent | Michigan | 26081 | 94331 | 999 |
1863387 | 1863387 | 2021-10-29 | Kent | Michigan | 26081 | 94331 | 999 |
1860138 | 1860138 | 2021-10-28 | Kent | Michigan | 26081 | 93566 | 997 |
1856889 | 1856889 | 2021-10-27 | Kent | Michigan | 26081 | 93566 | 997 |
1853640 | 1853640 | 2021-10-26 | Kent | Michigan | 26081 | 92919 | 985 |
1850391 | 1850391 | 2021-10-25 | Kent | Michigan | 26081 | 92919 | 985 |
1847141 | 1847141 | 2021-10-24 | Kent | Michigan | 26081 | 92233 | 983 |
1843891 | 1843891 | 2021-10-23 | Kent | Michigan | 26081 | 92233 | 983 |
1840641 | 1840641 | 2021-10-22 | Kent | Michigan | 26081 | 92233 | 983 |
1837392 | 1837392 | 2021-10-21 | Kent | Michigan | 26081 | 91506 | 974 |
1834143 | 1834143 | 2021-10-20 | Kent | Michigan | 26081 | 91506 | 974 |
1830894 | 1830894 | 2021-10-19 | Kent | Michigan | 26081 | 90794 | 962 |
1827645 | 1827645 | 2021-10-18 | Kent | Michigan | 26081 | 90794 | 962 |
1824396 | 1824396 | 2021-10-17 | Kent | Michigan | 26081 | 90019 | 961 |
1821147 | 1821147 | 2021-10-16 | Kent | Michigan | 26081 | 90019 | 961 |
1817898 | 1817898 | 2021-10-15 | Kent | Michigan | 26081 | 90019 | 961 |
1814649 | 1814649 | 2021-10-14 | Kent | Michigan | 26081 | 89258 | 959 |
1811401 | 1811401 | 2021-10-13 | Kent | Michigan | 26081 | 89258 | 959 |
1808152 | 1808152 | 2021-10-12 | Kent | Michigan | 26081 | 88468 | 955 |
1804901 | 1804901 | 2021-10-11 | Kent | Michigan | 26081 | 88468 | 955 |
1801652 | 1801652 | 2021-10-10 | Kent | Michigan | 26081 | 87793 | 956 |
1798403 | 1798403 | 2021-10-09 | Kent | Michigan | 26081 | 87793 | 956 |
1795154 | 1795154 | 2021-10-08 | Kent | Michigan | 26081 | 87793 | 956 |
1791905 | 1791905 | 2021-10-07 | Kent | Michigan | 26081 | 87060 | 949 |
1788656 | 1788656 | 2021-10-06 | Kent | Michigan | 26081 | 87060 | 949 |
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);