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 |
---|---|---|---|---|---|---|---|
2175464 | 2175464 | 2022-02-02 | Gladwin | Michigan | 26051 | 5329 | 105 |
2172211 | 2172211 | 2022-02-01 | Gladwin | Michigan | 26051 | 5263 | 105 |
2168958 | 2168958 | 2022-01-31 | Gladwin | Michigan | 26051 | 5263 | 105 |
2165703 | 2165703 | 2022-01-30 | Gladwin | Michigan | 26051 | 5210 | 103 |
2162448 | 2162448 | 2022-01-29 | Gladwin | Michigan | 26051 | 5210 | 103 |
2159193 | 2159193 | 2022-01-28 | Gladwin | Michigan | 26051 | 5210 | 103 |
2155939 | 2155939 | 2022-01-27 | Gladwin | Michigan | 26051 | 5174 | 102 |
2152686 | 2152686 | 2022-01-26 | Gladwin | Michigan | 26051 | 5174 | 102 |
2149434 | 2149434 | 2022-01-25 | Gladwin | Michigan | 26051 | 5113 | 102 |
2146182 | 2146182 | 2022-01-24 | Gladwin | Michigan | 26051 | 5113 | 102 |
2142927 | 2142927 | 2022-01-23 | Gladwin | Michigan | 26051 | 4994 | 102 |
2139672 | 2139672 | 2022-01-22 | Gladwin | Michigan | 26051 | 4994 | 102 |
2136416 | 2136416 | 2022-01-21 | Gladwin | Michigan | 26051 | 4994 | 102 |
2133164 | 2133164 | 2022-01-20 | Gladwin | Michigan | 26051 | 4899 | 102 |
2129911 | 2129911 | 2022-01-19 | Gladwin | Michigan | 26051 | 4899 | 102 |
2126657 | 2126657 | 2022-01-18 | Gladwin | Michigan | 26051 | 4619 | 102 |
2123405 | 2123405 | 2022-01-17 | Gladwin | Michigan | 26051 | 4619 | 102 |
2120153 | 2120153 | 2022-01-16 | Gladwin | Michigan | 26051 | 4619 | 102 |
2116901 | 2116901 | 2022-01-15 | Gladwin | Michigan | 26051 | 4619 | 102 |
2113650 | 2113650 | 2022-01-14 | Gladwin | Michigan | 26051 | 4619 | 102 |
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 |
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);