ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26015 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110380 | 2110380 | 2022-01-13 | Barry | Michigan | 26015 | 11645 | 137 |
2107129 | 2107129 | 2022-01-12 | Barry | Michigan | 26015 | 11645 | 137 |
2103878 | 2103878 | 2022-01-11 | Barry | Michigan | 26015 | 11487 | 135 |
2100627 | 2100627 | 2022-01-10 | Barry | Michigan | 26015 | 11487 | 135 |
2097376 | 2097376 | 2022-01-09 | Barry | Michigan | 26015 | 11276 | 134 |
2094124 | 2094124 | 2022-01-08 | Barry | Michigan | 26015 | 11276 | 134 |
2090872 | 2090872 | 2022-01-07 | Barry | Michigan | 26015 | 11276 | 134 |
2087621 | 2087621 | 2022-01-06 | Barry | Michigan | 26015 | 11099 | 133 |
2084369 | 2084369 | 2022-01-05 | Barry | Michigan | 26015 | 11099 | 133 |
2081117 | 2081117 | 2022-01-04 | Barry | Michigan | 26015 | 10979 | 133 |
2077865 | 2077865 | 2022-01-03 | Barry | Michigan | 26015 | 10979 | 133 |
2074614 | 2074614 | 2022-01-02 | Barry | Michigan | 26015 | 10746 | 131 |
2071363 | 2071363 | 2022-01-01 | Barry | Michigan | 26015 | 10746 | 131 |
2068112 | 2068112 | 2021-12-31 | Barry | Michigan | 26015 | 10746 | 131 |
2064861 | 2064861 | 2021-12-30 | Barry | Michigan | 26015 | 10746 | 131 |
2061611 | 2061611 | 2021-12-29 | Barry | Michigan | 26015 | 10746 | 131 |
2058362 | 2058362 | 2021-12-28 | Barry | Michigan | 26015 | 10662 | 131 |
2055113 | 2055113 | 2021-12-27 | Barry | Michigan | 26015 | 10662 | 131 |
2051863 | 2051863 | 2021-12-26 | Barry | Michigan | 26015 | 10518 | 125 |
2048613 | 2048613 | 2021-12-25 | Barry | Michigan | 26015 | 10518 | 125 |
2045363 | 2045363 | 2021-12-24 | Barry | Michigan | 26015 | 10518 | 125 |
2042113 | 2042113 | 2021-12-23 | Barry | Michigan | 26015 | 10518 | 125 |
2038864 | 2038864 | 2021-12-22 | Barry | Michigan | 26015 | 10518 | 125 |
2035614 | 2035614 | 2021-12-21 | Barry | Michigan | 26015 | 10452 | 124 |
2032364 | 2032364 | 2021-12-20 | Barry | Michigan | 26015 | 10452 | 124 |
2029113 | 2029113 | 2021-12-19 | Barry | Michigan | 26015 | 10403 | 123 |
2025862 | 2025862 | 2021-12-18 | Barry | Michigan | 26015 | 10403 | 123 |
2022611 | 2022611 | 2021-12-17 | Barry | Michigan | 26015 | 10403 | 123 |
2019360 | 2019360 | 2021-12-16 | Barry | Michigan | 26015 | 10318 | 121 |
2016110 | 2016110 | 2021-12-15 | Barry | Michigan | 26015 | 10318 | 121 |
2012859 | 2012859 | 2021-12-14 | Barry | Michigan | 26015 | 10266 | 119 |
2009608 | 2009608 | 2021-12-13 | Barry | Michigan | 26015 | 10266 | 119 |
2006357 | 2006357 | 2021-12-12 | Barry | Michigan | 26015 | 10169 | 116 |
2003106 | 2003106 | 2021-12-11 | Barry | Michigan | 26015 | 10169 | 116 |
1999856 | 1999856 | 2021-12-10 | Barry | Michigan | 26015 | 10169 | 116 |
1996605 | 1996605 | 2021-12-09 | Barry | Michigan | 26015 | 10092 | 113 |
1993354 | 1993354 | 2021-12-08 | Barry | Michigan | 26015 | 10092 | 113 |
1990103 | 1990103 | 2021-12-07 | Barry | Michigan | 26015 | 9993 | 110 |
1986853 | 1986853 | 2021-12-06 | Barry | Michigan | 26015 | 9993 | 110 |
1983603 | 1983603 | 2021-12-05 | Barry | Michigan | 26015 | 9885 | 109 |
1980353 | 1980353 | 2021-12-04 | Barry | Michigan | 26015 | 9885 | 109 |
1977103 | 1977103 | 2021-12-03 | Barry | Michigan | 26015 | 9885 | 109 |
1973853 | 1973853 | 2021-12-02 | Barry | Michigan | 26015 | 9704 | 106 |
1970604 | 1970604 | 2021-12-01 | Barry | Michigan | 26015 | 9704 | 106 |
1967354 | 1967354 | 2021-11-30 | Barry | Michigan | 26015 | 9554 | 102 |
1964102 | 1964102 | 2021-11-29 | Barry | Michigan | 26015 | 9554 | 102 |
1960851 | 1960851 | 2021-11-28 | Barry | Michigan | 26015 | 9384 | 100 |
1957600 | 1957600 | 2021-11-27 | Barry | Michigan | 26015 | 9384 | 100 |
1954349 | 1954349 | 2021-11-26 | Barry | Michigan | 26015 | 9384 | 100 |
1951098 | 1951098 | 2021-11-25 | Barry | Michigan | 26015 | 9384 | 100 |
1947847 | 1947847 | 2021-11-24 | Barry | Michigan | 26015 | 9384 | 100 |
1944596 | 1944596 | 2021-11-23 | Barry | Michigan | 26015 | 9206 | 99 |
1941345 | 1941345 | 2021-11-22 | Barry | Michigan | 26015 | 9206 | 99 |
1938095 | 1938095 | 2021-11-21 | Barry | Michigan | 26015 | 9113 | 99 |
1934845 | 1934845 | 2021-11-20 | Barry | Michigan | 26015 | 9113 | 99 |
1931595 | 1931595 | 2021-11-19 | Barry | Michigan | 26015 | 9113 | 99 |
1928344 | 1928344 | 2021-11-18 | Barry | Michigan | 26015 | 8892 | 95 |
1925094 | 1925094 | 2021-11-17 | Barry | Michigan | 26015 | 8892 | 95 |
1921845 | 1921845 | 2021-11-16 | Barry | Michigan | 26015 | 8756 | 94 |
1918595 | 1918595 | 2021-11-15 | Barry | Michigan | 26015 | 8756 | 94 |
1915345 | 1915345 | 2021-11-14 | Barry | Michigan | 26015 | 8591 | 92 |
1912095 | 1912095 | 2021-11-13 | Barry | Michigan | 26015 | 8591 | 92 |
1908845 | 1908845 | 2021-11-12 | Barry | Michigan | 26015 | 8591 | 92 |
1905596 | 1905596 | 2021-11-11 | Barry | Michigan | 26015 | 8436 | 92 |
1902347 | 1902347 | 2021-11-10 | Barry | Michigan | 26015 | 8436 | 92 |
1899097 | 1899097 | 2021-11-09 | Barry | Michigan | 26015 | 8325 | 92 |
1895847 | 1895847 | 2021-11-08 | Barry | Michigan | 26015 | 8325 | 92 |
1892597 | 1892597 | 2021-11-07 | Barry | Michigan | 26015 | 8250 | 91 |
1889347 | 1889347 | 2021-11-06 | Barry | Michigan | 26015 | 8250 | 91 |
1886097 | 1886097 | 2021-11-05 | Barry | Michigan | 26015 | 8250 | 91 |
1882848 | 1882848 | 2021-11-04 | Barry | Michigan | 26015 | 8110 | 90 |
1879599 | 1879599 | 2021-11-03 | Barry | Michigan | 26015 | 8110 | 90 |
1876350 | 1876350 | 2021-11-02 | Barry | Michigan | 26015 | 7988 | 88 |
1873101 | 1873101 | 2021-11-01 | Barry | Michigan | 26015 | 7988 | 88 |
1869852 | 1869852 | 2021-10-31 | Barry | Michigan | 26015 | 7927 | 85 |
1866603 | 1866603 | 2021-10-30 | Barry | Michigan | 26015 | 7927 | 85 |
1863354 | 1863354 | 2021-10-29 | Barry | Michigan | 26015 | 7927 | 85 |
1860105 | 1860105 | 2021-10-28 | Barry | Michigan | 26015 | 7812 | 84 |
1856856 | 1856856 | 2021-10-27 | Barry | Michigan | 26015 | 7812 | 84 |
1853607 | 1853607 | 2021-10-26 | Barry | Michigan | 26015 | 7747 | 84 |
1850358 | 1850358 | 2021-10-25 | Barry | Michigan | 26015 | 7747 | 84 |
1847108 | 1847108 | 2021-10-24 | Barry | Michigan | 26015 | 7701 | 83 |
1843858 | 1843858 | 2021-10-23 | Barry | Michigan | 26015 | 7701 | 83 |
1840608 | 1840608 | 2021-10-22 | Barry | Michigan | 26015 | 7701 | 83 |
1837359 | 1837359 | 2021-10-21 | Barry | Michigan | 26015 | 7612 | 81 |
1834110 | 1834110 | 2021-10-20 | Barry | Michigan | 26015 | 7612 | 81 |
1830861 | 1830861 | 2021-10-19 | Barry | Michigan | 26015 | 7547 | 81 |
1827612 | 1827612 | 2021-10-18 | Barry | Michigan | 26015 | 7547 | 81 |
1824363 | 1824363 | 2021-10-17 | Barry | Michigan | 26015 | 7489 | 81 |
1821114 | 1821114 | 2021-10-16 | Barry | Michigan | 26015 | 7489 | 81 |
1817865 | 1817865 | 2021-10-15 | Barry | Michigan | 26015 | 7489 | 81 |
1814616 | 1814616 | 2021-10-14 | Barry | Michigan | 26015 | 7417 | 79 |
1811368 | 1811368 | 2021-10-13 | Barry | Michigan | 26015 | 7417 | 79 |
1808119 | 1808119 | 2021-10-12 | Barry | Michigan | 26015 | 7322 | 78 |
1804868 | 1804868 | 2021-10-11 | Barry | Michigan | 26015 | 7322 | 78 |
1801619 | 1801619 | 2021-10-10 | Barry | Michigan | 26015 | 7263 | 78 |
1798370 | 1798370 | 2021-10-09 | Barry | Michigan | 26015 | 7263 | 78 |
1795121 | 1795121 | 2021-10-08 | Barry | Michigan | 26015 | 7263 | 78 |
1791872 | 1791872 | 2021-10-07 | Barry | Michigan | 26015 | 7207 | 77 |
1788623 | 1788623 | 2021-10-06 | Barry | Michigan | 26015 | 7207 | 77 |
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);