ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Roscommon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175510 | 2175510 | 2022-02-02 | Roscommon | Michigan | 26143 | 4375 | 109 |
2172257 | 2172257 | 2022-02-01 | Roscommon | Michigan | 26143 | 4332 | 109 |
2169004 | 2169004 | 2022-01-31 | Roscommon | Michigan | 26143 | 4332 | 109 |
2165749 | 2165749 | 2022-01-30 | Roscommon | Michigan | 26143 | 4305 | 109 |
2162494 | 2162494 | 2022-01-29 | Roscommon | Michigan | 26143 | 4305 | 109 |
2159239 | 2159239 | 2022-01-28 | Roscommon | Michigan | 26143 | 4305 | 109 |
2155985 | 2155985 | 2022-01-27 | Roscommon | Michigan | 26143 | 4259 | 109 |
2152732 | 2152732 | 2022-01-26 | Roscommon | Michigan | 26143 | 4259 | 109 |
2149480 | 2149480 | 2022-01-25 | Roscommon | Michigan | 26143 | 4194 | 109 |
2146228 | 2146228 | 2022-01-24 | Roscommon | Michigan | 26143 | 4194 | 109 |
2142973 | 2142973 | 2022-01-23 | Roscommon | Michigan | 26143 | 4139 | 109 |
2139718 | 2139718 | 2022-01-22 | Roscommon | Michigan | 26143 | 4139 | 109 |
2136462 | 2136462 | 2022-01-21 | Roscommon | Michigan | 26143 | 4139 | 109 |
2133210 | 2133210 | 2022-01-20 | Roscommon | Michigan | 26143 | 4064 | 109 |
2129957 | 2129957 | 2022-01-19 | Roscommon | Michigan | 26143 | 4064 | 109 |
2126703 | 2126703 | 2022-01-18 | Roscommon | Michigan | 26143 | 3896 | 108 |
2123451 | 2123451 | 2022-01-17 | Roscommon | Michigan | 26143 | 3896 | 108 |
2120199 | 2120199 | 2022-01-16 | Roscommon | Michigan | 26143 | 3896 | 108 |
2116947 | 2116947 | 2022-01-15 | Roscommon | Michigan | 26143 | 3896 | 108 |
2113696 | 2113696 | 2022-01-14 | Roscommon | Michigan | 26143 | 3896 | 108 |
2110444 | 2110444 | 2022-01-13 | Roscommon | Michigan | 26143 | 3861 | 107 |
2107193 | 2107193 | 2022-01-12 | Roscommon | Michigan | 26143 | 3861 | 107 |
2103942 | 2103942 | 2022-01-11 | Roscommon | Michigan | 26143 | 3804 | 106 |
2100691 | 2100691 | 2022-01-10 | Roscommon | Michigan | 26143 | 3804 | 106 |
2097440 | 2097440 | 2022-01-09 | Roscommon | Michigan | 26143 | 3766 | 106 |
2094188 | 2094188 | 2022-01-08 | Roscommon | Michigan | 26143 | 3766 | 106 |
2090936 | 2090936 | 2022-01-07 | Roscommon | Michigan | 26143 | 3766 | 106 |
2087685 | 2087685 | 2022-01-06 | Roscommon | Michigan | 26143 | 3709 | 106 |
2084433 | 2084433 | 2022-01-05 | Roscommon | Michigan | 26143 | 3709 | 106 |
2081181 | 2081181 | 2022-01-04 | Roscommon | Michigan | 26143 | 3681 | 103 |
2077929 | 2077929 | 2022-01-03 | Roscommon | Michigan | 26143 | 3681 | 103 |
2074678 | 2074678 | 2022-01-02 | Roscommon | Michigan | 26143 | 3646 | 101 |
2071427 | 2071427 | 2022-01-01 | Roscommon | Michigan | 26143 | 3646 | 101 |
2068176 | 2068176 | 2021-12-31 | Roscommon | Michigan | 26143 | 3646 | 101 |
2064925 | 2064925 | 2021-12-30 | Roscommon | Michigan | 26143 | 3646 | 101 |
2061675 | 2061675 | 2021-12-29 | Roscommon | Michigan | 26143 | 3646 | 101 |
2058426 | 2058426 | 2021-12-28 | Roscommon | Michigan | 26143 | 3632 | 99 |
2055177 | 2055177 | 2021-12-27 | Roscommon | Michigan | 26143 | 3632 | 99 |
2051927 | 2051927 | 2021-12-26 | Roscommon | Michigan | 26143 | 3589 | 99 |
2048677 | 2048677 | 2021-12-25 | Roscommon | Michigan | 26143 | 3589 | 99 |
2045427 | 2045427 | 2021-12-24 | Roscommon | Michigan | 26143 | 3589 | 99 |
2042177 | 2042177 | 2021-12-23 | Roscommon | Michigan | 26143 | 3589 | 99 |
2038928 | 2038928 | 2021-12-22 | Roscommon | Michigan | 26143 | 3589 | 99 |
2035678 | 2035678 | 2021-12-21 | Roscommon | Michigan | 26143 | 3567 | 98 |
2032428 | 2032428 | 2021-12-20 | Roscommon | Michigan | 26143 | 3567 | 98 |
2029177 | 2029177 | 2021-12-19 | Roscommon | Michigan | 26143 | 3545 | 95 |
2025926 | 2025926 | 2021-12-18 | Roscommon | Michigan | 26143 | 3545 | 95 |
2022675 | 2022675 | 2021-12-17 | Roscommon | Michigan | 26143 | 3545 | 95 |
2019424 | 2019424 | 2021-12-16 | Roscommon | Michigan | 26143 | 3526 | 95 |
2016174 | 2016174 | 2021-12-15 | Roscommon | Michigan | 26143 | 3526 | 95 |
2012923 | 2012923 | 2021-12-14 | Roscommon | Michigan | 26143 | 3507 | 94 |
2009672 | 2009672 | 2021-12-13 | Roscommon | Michigan | 26143 | 3507 | 94 |
2006421 | 2006421 | 2021-12-12 | Roscommon | Michigan | 26143 | 3466 | 92 |
2003170 | 2003170 | 2021-12-11 | Roscommon | Michigan | 26143 | 3466 | 92 |
1999920 | 1999920 | 2021-12-10 | Roscommon | Michigan | 26143 | 3466 | 92 |
1996669 | 1996669 | 2021-12-09 | Roscommon | Michigan | 26143 | 3429 | 90 |
1993418 | 1993418 | 2021-12-08 | Roscommon | Michigan | 26143 | 3429 | 90 |
1990167 | 1990167 | 2021-12-07 | Roscommon | Michigan | 26143 | 3401 | 89 |
1986917 | 1986917 | 2021-12-06 | Roscommon | Michigan | 26143 | 3401 | 89 |
1983667 | 1983667 | 2021-12-05 | Roscommon | Michigan | 26143 | 3368 | 88 |
1980417 | 1980417 | 2021-12-04 | Roscommon | Michigan | 26143 | 3368 | 88 |
1977167 | 1977167 | 2021-12-03 | Roscommon | Michigan | 26143 | 3368 | 88 |
1973917 | 1973917 | 2021-12-02 | Roscommon | Michigan | 26143 | 3302 | 83 |
1970668 | 1970668 | 2021-12-01 | Roscommon | Michigan | 26143 | 3302 | 83 |
1967418 | 1967418 | 2021-11-30 | Roscommon | Michigan | 26143 | 3250 | 80 |
1964166 | 1964166 | 2021-11-29 | Roscommon | Michigan | 26143 | 3250 | 80 |
1960915 | 1960915 | 2021-11-28 | Roscommon | Michigan | 26143 | 3163 | 79 |
1957664 | 1957664 | 2021-11-27 | Roscommon | Michigan | 26143 | 3163 | 79 |
1954413 | 1954413 | 2021-11-26 | Roscommon | Michigan | 26143 | 3163 | 79 |
1951162 | 1951162 | 2021-11-25 | Roscommon | Michigan | 26143 | 3163 | 79 |
1947911 | 1947911 | 2021-11-24 | Roscommon | Michigan | 26143 | 3163 | 79 |
1944660 | 1944660 | 2021-11-23 | Roscommon | Michigan | 26143 | 3095 | 75 |
1941409 | 1941409 | 2021-11-22 | Roscommon | Michigan | 26143 | 3095 | 75 |
1938159 | 1938159 | 2021-11-21 | Roscommon | Michigan | 26143 | 3050 | 75 |
1934909 | 1934909 | 2021-11-20 | Roscommon | Michigan | 26143 | 3050 | 75 |
1931659 | 1931659 | 2021-11-19 | Roscommon | Michigan | 26143 | 3050 | 75 |
1928408 | 1928408 | 2021-11-18 | Roscommon | Michigan | 26143 | 2997 | 72 |
1925158 | 1925158 | 2021-11-17 | Roscommon | Michigan | 26143 | 2997 | 72 |
1921909 | 1921909 | 2021-11-16 | Roscommon | Michigan | 26143 | 2951 | 72 |
1918659 | 1918659 | 2021-11-15 | Roscommon | Michigan | 26143 | 2951 | 72 |
1915409 | 1915409 | 2021-11-14 | Roscommon | Michigan | 26143 | 2882 | 71 |
1912159 | 1912159 | 2021-11-13 | Roscommon | Michigan | 26143 | 2882 | 71 |
1908909 | 1908909 | 2021-11-12 | Roscommon | Michigan | 26143 | 2882 | 71 |
1905660 | 1905660 | 2021-11-11 | Roscommon | Michigan | 26143 | 2799 | 71 |
1902411 | 1902411 | 2021-11-10 | Roscommon | Michigan | 26143 | 2799 | 71 |
1899161 | 1899161 | 2021-11-09 | Roscommon | Michigan | 26143 | 2765 | 67 |
1895911 | 1895911 | 2021-11-08 | Roscommon | Michigan | 26143 | 2765 | 67 |
1892661 | 1892661 | 2021-11-07 | Roscommon | Michigan | 26143 | 2736 | 67 |
1889411 | 1889411 | 2021-11-06 | Roscommon | Michigan | 26143 | 2736 | 67 |
1886161 | 1886161 | 2021-11-05 | Roscommon | Michigan | 26143 | 2736 | 67 |
1882912 | 1882912 | 2021-11-04 | Roscommon | Michigan | 26143 | 2704 | 67 |
1879663 | 1879663 | 2021-11-03 | Roscommon | Michigan | 26143 | 2704 | 67 |
1876414 | 1876414 | 2021-11-02 | Roscommon | Michigan | 26143 | 2641 | 66 |
1873165 | 1873165 | 2021-11-01 | Roscommon | Michigan | 26143 | 2641 | 66 |
1869916 | 1869916 | 2021-10-31 | Roscommon | Michigan | 26143 | 2592 | 66 |
1866667 | 1866667 | 2021-10-30 | Roscommon | Michigan | 26143 | 2592 | 66 |
1863418 | 1863418 | 2021-10-29 | Roscommon | Michigan | 26143 | 2592 | 66 |
1860169 | 1860169 | 2021-10-28 | Roscommon | Michigan | 26143 | 2551 | 65 |
1856920 | 1856920 | 2021-10-27 | Roscommon | Michigan | 26143 | 2551 | 65 |
1853671 | 1853671 | 2021-10-26 | Roscommon | Michigan | 26143 | 2510 | 64 |
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);