ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Gladwin" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110398 | 2110398 | 2022-01-13 | Gladwin | Michigan | 26051 | 4538 | 101 |
2107147 | 2107147 | 2022-01-12 | Gladwin | Michigan | 26051 | 4538 | 101 |
2103896 | 2103896 | 2022-01-11 | Gladwin | Michigan | 26051 | 4461 | 101 |
2100645 | 2100645 | 2022-01-10 | Gladwin | Michigan | 26051 | 4461 | 101 |
2097394 | 2097394 | 2022-01-09 | Gladwin | Michigan | 26051 | 4384 | 101 |
2094142 | 2094142 | 2022-01-08 | Gladwin | Michigan | 26051 | 4384 | 101 |
2090890 | 2090890 | 2022-01-07 | Gladwin | Michigan | 26051 | 4384 | 101 |
2087639 | 2087639 | 2022-01-06 | Gladwin | Michigan | 26051 | 4292 | 97 |
2084387 | 2084387 | 2022-01-05 | Gladwin | Michigan | 26051 | 4292 | 97 |
2081135 | 2081135 | 2022-01-04 | Gladwin | Michigan | 26051 | 4239 | 95 |
2077883 | 2077883 | 2022-01-03 | Gladwin | Michigan | 26051 | 4239 | 95 |
2074632 | 2074632 | 2022-01-02 | Gladwin | Michigan | 26051 | 4148 | 95 |
2071381 | 2071381 | 2022-01-01 | Gladwin | Michigan | 26051 | 4148 | 95 |
2068130 | 2068130 | 2021-12-31 | Gladwin | Michigan | 26051 | 4148 | 95 |
2064879 | 2064879 | 2021-12-30 | Gladwin | Michigan | 26051 | 4148 | 95 |
2061629 | 2061629 | 2021-12-29 | Gladwin | Michigan | 26051 | 4148 | 95 |
2058380 | 2058380 | 2021-12-28 | Gladwin | Michigan | 26051 | 4110 | 94 |
2055131 | 2055131 | 2021-12-27 | Gladwin | Michigan | 26051 | 4110 | 94 |
2051881 | 2051881 | 2021-12-26 | Gladwin | Michigan | 26051 | 4036 | 93 |
2048631 | 2048631 | 2021-12-25 | Gladwin | Michigan | 26051 | 4036 | 93 |
2045381 | 2045381 | 2021-12-24 | Gladwin | Michigan | 26051 | 4036 | 93 |
2042131 | 2042131 | 2021-12-23 | Gladwin | Michigan | 26051 | 4036 | 93 |
2038882 | 2038882 | 2021-12-22 | Gladwin | Michigan | 26051 | 4036 | 93 |
2035632 | 2035632 | 2021-12-21 | Gladwin | Michigan | 26051 | 4013 | 91 |
2032382 | 2032382 | 2021-12-20 | Gladwin | Michigan | 26051 | 4013 | 91 |
2029131 | 2029131 | 2021-12-19 | Gladwin | Michigan | 26051 | 3980 | 90 |
2025880 | 2025880 | 2021-12-18 | Gladwin | Michigan | 26051 | 3980 | 90 |
2022629 | 2022629 | 2021-12-17 | Gladwin | Michigan | 26051 | 3980 | 90 |
2019378 | 2019378 | 2021-12-16 | Gladwin | Michigan | 26051 | 3952 | 88 |
2016128 | 2016128 | 2021-12-15 | Gladwin | Michigan | 26051 | 3952 | 88 |
2012877 | 2012877 | 2021-12-14 | Gladwin | Michigan | 26051 | 3935 | 87 |
2009626 | 2009626 | 2021-12-13 | Gladwin | Michigan | 26051 | 3935 | 87 |
2006375 | 2006375 | 2021-12-12 | Gladwin | Michigan | 26051 | 3886 | 87 |
2003124 | 2003124 | 2021-12-11 | Gladwin | Michigan | 26051 | 3886 | 87 |
1999874 | 1999874 | 2021-12-10 | Gladwin | Michigan | 26051 | 3886 | 87 |
1996623 | 1996623 | 2021-12-09 | Gladwin | Michigan | 26051 | 3865 | 85 |
1993372 | 1993372 | 2021-12-08 | Gladwin | Michigan | 26051 | 3865 | 85 |
1990121 | 1990121 | 2021-12-07 | Gladwin | Michigan | 26051 | 3836 | 85 |
1986871 | 1986871 | 2021-12-06 | Gladwin | Michigan | 26051 | 3836 | 85 |
1983621 | 1983621 | 2021-12-05 | Gladwin | Michigan | 26051 | 3786 | 85 |
1980371 | 1980371 | 2021-12-04 | Gladwin | Michigan | 26051 | 3786 | 85 |
1977121 | 1977121 | 2021-12-03 | Gladwin | Michigan | 26051 | 3786 | 85 |
1973871 | 1973871 | 2021-12-02 | Gladwin | Michigan | 26051 | 3753 | 86 |
1970622 | 1970622 | 2021-12-01 | Gladwin | Michigan | 26051 | 3753 | 86 |
1967372 | 1967372 | 2021-11-30 | Gladwin | Michigan | 26051 | 3724 | 83 |
1964120 | 1964120 | 2021-11-29 | Gladwin | Michigan | 26051 | 3724 | 83 |
1960869 | 1960869 | 2021-11-28 | Gladwin | Michigan | 26051 | 3674 | 83 |
1957618 | 1957618 | 2021-11-27 | Gladwin | Michigan | 26051 | 3674 | 83 |
1954367 | 1954367 | 2021-11-26 | Gladwin | Michigan | 26051 | 3674 | 83 |
1951116 | 1951116 | 2021-11-25 | Gladwin | Michigan | 26051 | 3674 | 83 |
1947865 | 1947865 | 2021-11-24 | Gladwin | Michigan | 26051 | 3674 | 83 |
1944614 | 1944614 | 2021-11-23 | Gladwin | Michigan | 26051 | 3643 | 81 |
1941363 | 1941363 | 2021-11-22 | Gladwin | Michigan | 26051 | 3643 | 81 |
1938113 | 1938113 | 2021-11-21 | Gladwin | Michigan | 26051 | 3612 | 80 |
1934863 | 1934863 | 2021-11-20 | Gladwin | Michigan | 26051 | 3612 | 80 |
1931613 | 1931613 | 2021-11-19 | Gladwin | Michigan | 26051 | 3612 | 80 |
1928362 | 1928362 | 2021-11-18 | Gladwin | Michigan | 26051 | 3579 | 79 |
1925112 | 1925112 | 2021-11-17 | Gladwin | Michigan | 26051 | 3579 | 79 |
1921863 | 1921863 | 2021-11-16 | Gladwin | Michigan | 26051 | 3556 | 79 |
1918613 | 1918613 | 2021-11-15 | Gladwin | Michigan | 26051 | 3556 | 79 |
1915363 | 1915363 | 2021-11-14 | Gladwin | Michigan | 26051 | 3510 | 79 |
1912113 | 1912113 | 2021-11-13 | Gladwin | Michigan | 26051 | 3510 | 79 |
1908863 | 1908863 | 2021-11-12 | Gladwin | Michigan | 26051 | 3510 | 79 |
1905614 | 1905614 | 2021-11-11 | Gladwin | Michigan | 26051 | 3479 | 78 |
1902365 | 1902365 | 2021-11-10 | Gladwin | Michigan | 26051 | 3479 | 78 |
1899115 | 1899115 | 2021-11-09 | Gladwin | Michigan | 26051 | 3462 | 77 |
1895865 | 1895865 | 2021-11-08 | Gladwin | Michigan | 26051 | 3462 | 77 |
1892615 | 1892615 | 2021-11-07 | Gladwin | Michigan | 26051 | 3426 | 77 |
1889365 | 1889365 | 2021-11-06 | Gladwin | Michigan | 26051 | 3426 | 77 |
1886115 | 1886115 | 2021-11-05 | Gladwin | Michigan | 26051 | 3426 | 77 |
1882866 | 1882866 | 2021-11-04 | Gladwin | Michigan | 26051 | 3391 | 77 |
1879617 | 1879617 | 2021-11-03 | Gladwin | Michigan | 26051 | 3391 | 77 |
1876368 | 1876368 | 2021-11-02 | Gladwin | Michigan | 26051 | 3344 | 73 |
1873119 | 1873119 | 2021-11-01 | Gladwin | Michigan | 26051 | 3344 | 73 |
1869870 | 1869870 | 2021-10-31 | Gladwin | Michigan | 26051 | 3312 | 73 |
1866621 | 1866621 | 2021-10-30 | Gladwin | Michigan | 26051 | 3312 | 73 |
1863372 | 1863372 | 2021-10-29 | Gladwin | Michigan | 26051 | 3312 | 73 |
1860123 | 1860123 | 2021-10-28 | Gladwin | Michigan | 26051 | 3290 | 71 |
1856874 | 1856874 | 2021-10-27 | Gladwin | Michigan | 26051 | 3290 | 71 |
1853625 | 1853625 | 2021-10-26 | Gladwin | Michigan | 26051 | 3251 | 71 |
1850376 | 1850376 | 2021-10-25 | Gladwin | Michigan | 26051 | 3251 | 71 |
1847126 | 1847126 | 2021-10-24 | Gladwin | Michigan | 26051 | 3232 | 69 |
1843876 | 1843876 | 2021-10-23 | Gladwin | Michigan | 26051 | 3232 | 69 |
1840626 | 1840626 | 2021-10-22 | Gladwin | Michigan | 26051 | 3232 | 69 |
1837377 | 1837377 | 2021-10-21 | Gladwin | Michigan | 26051 | 3195 | 70 |
1834128 | 1834128 | 2021-10-20 | Gladwin | Michigan | 26051 | 3195 | 70 |
1830879 | 1830879 | 2021-10-19 | Gladwin | Michigan | 26051 | 3159 | 69 |
1827630 | 1827630 | 2021-10-18 | Gladwin | Michigan | 26051 | 3159 | 69 |
1824381 | 1824381 | 2021-10-17 | Gladwin | Michigan | 26051 | 3116 | 68 |
1821132 | 1821132 | 2021-10-16 | Gladwin | Michigan | 26051 | 3116 | 68 |
1817883 | 1817883 | 2021-10-15 | Gladwin | Michigan | 26051 | 3116 | 68 |
1814634 | 1814634 | 2021-10-14 | Gladwin | Michigan | 26051 | 3085 | 68 |
1811386 | 1811386 | 2021-10-13 | Gladwin | Michigan | 26051 | 3085 | 68 |
1808137 | 1808137 | 2021-10-12 | Gladwin | Michigan | 26051 | 3043 | 67 |
1804886 | 1804886 | 2021-10-11 | Gladwin | Michigan | 26051 | 3043 | 67 |
1801637 | 1801637 | 2021-10-10 | Gladwin | Michigan | 26051 | 3005 | 67 |
1798388 | 1798388 | 2021-10-09 | Gladwin | Michigan | 26051 | 3005 | 67 |
1795139 | 1795139 | 2021-10-08 | Gladwin | Michigan | 26051 | 3005 | 67 |
1791890 | 1791890 | 2021-10-07 | Gladwin | Michigan | 26051 | 2963 | 66 |
1788641 | 1788641 | 2021-10-06 | Gladwin | Michigan | 26051 | 2963 | 66 |
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);