ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 26125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175501 | 2175501 | 2022-02-02 | Oakland | Michigan | 26125 | 272769 | 3508 |
2172248 | 2172248 | 2022-02-01 | Oakland | Michigan | 26125 | 270830 | 3463 |
2168995 | 2168995 | 2022-01-31 | Oakland | Michigan | 26125 | 270830 | 3463 |
2165740 | 2165740 | 2022-01-30 | Oakland | Michigan | 26125 | 267558 | 3460 |
2162485 | 2162485 | 2022-01-29 | Oakland | Michigan | 26125 | 267558 | 3460 |
2159230 | 2159230 | 2022-01-28 | Oakland | Michigan | 26125 | 267558 | 3460 |
2155976 | 2155976 | 2022-01-27 | Oakland | Michigan | 26125 | 262953 | 3437 |
2152723 | 2152723 | 2022-01-26 | Oakland | Michigan | 26125 | 262953 | 3437 |
2149471 | 2149471 | 2022-01-25 | Oakland | Michigan | 26125 | 258982 | 3369 |
2146219 | 2146219 | 2022-01-24 | Oakland | Michigan | 26125 | 258982 | 3369 |
2142964 | 2142964 | 2022-01-23 | Oakland | Michigan | 26125 | 254045 | 3367 |
2139709 | 2139709 | 2022-01-22 | Oakland | Michigan | 26125 | 254045 | 3367 |
2136453 | 2136453 | 2022-01-21 | Oakland | Michigan | 26125 | 254045 | 3367 |
2133201 | 2133201 | 2022-01-20 | Oakland | Michigan | 26125 | 249397 | 3341 |
2129948 | 2129948 | 2022-01-19 | Oakland | Michigan | 26125 | 249397 | 3341 |
2126694 | 2126694 | 2022-01-18 | Oakland | Michigan | 26125 | 237946 | 3295 |
2123442 | 2123442 | 2022-01-17 | Oakland | Michigan | 26125 | 237946 | 3295 |
2120190 | 2120190 | 2022-01-16 | Oakland | Michigan | 26125 | 237946 | 3295 |
2116938 | 2116938 | 2022-01-15 | Oakland | Michigan | 26125 | 237946 | 3295 |
2113687 | 2113687 | 2022-01-14 | Oakland | Michigan | 26125 | 237946 | 3295 |
2110435 | 2110435 | 2022-01-13 | Oakland | Michigan | 26125 | 232417 | 3244 |
2107184 | 2107184 | 2022-01-12 | Oakland | Michigan | 26125 | 232417 | 3244 |
2103933 | 2103933 | 2022-01-11 | Oakland | Michigan | 26125 | 228069 | 3200 |
2100682 | 2100682 | 2022-01-10 | Oakland | Michigan | 26125 | 228069 | 3200 |
2097431 | 2097431 | 2022-01-09 | Oakland | Michigan | 26125 | 220919 | 3199 |
2094179 | 2094179 | 2022-01-08 | Oakland | Michigan | 26125 | 220919 | 3199 |
2090927 | 2090927 | 2022-01-07 | Oakland | Michigan | 26125 | 220919 | 3199 |
2087676 | 2087676 | 2022-01-06 | Oakland | Michigan | 26125 | 213730 | 3165 |
2084424 | 2084424 | 2022-01-05 | Oakland | Michigan | 26125 | 213730 | 3165 |
2081172 | 2081172 | 2022-01-04 | Oakland | Michigan | 26125 | 209648 | 3136 |
2077920 | 2077920 | 2022-01-03 | Oakland | Michigan | 26125 | 209648 | 3136 |
2074669 | 2074669 | 2022-01-02 | Oakland | Michigan | 26125 | 199302 | 3116 |
2071418 | 2071418 | 2022-01-01 | Oakland | Michigan | 26125 | 199302 | 3116 |
2068167 | 2068167 | 2021-12-31 | Oakland | Michigan | 26125 | 199302 | 3116 |
2064916 | 2064916 | 2021-12-30 | Oakland | Michigan | 26125 | 199302 | 3116 |
2061666 | 2061666 | 2021-12-29 | Oakland | Michigan | 26125 | 199302 | 3116 |
2058417 | 2058417 | 2021-12-28 | Oakland | Michigan | 26125 | 194971 | 3071 |
2055168 | 2055168 | 2021-12-27 | Oakland | Michigan | 26125 | 194971 | 3071 |
2051918 | 2051918 | 2021-12-26 | Oakland | Michigan | 26125 | 189146 | 3053 |
2048668 | 2048668 | 2021-12-25 | Oakland | Michigan | 26125 | 189146 | 3053 |
2045418 | 2045418 | 2021-12-24 | Oakland | Michigan | 26125 | 189146 | 3053 |
2042168 | 2042168 | 2021-12-23 | Oakland | Michigan | 26125 | 189146 | 3053 |
2038919 | 2038919 | 2021-12-22 | Oakland | Michigan | 26125 | 189146 | 3053 |
2035669 | 2035669 | 2021-12-21 | Oakland | Michigan | 26125 | 186800 | 3005 |
2032419 | 2032419 | 2021-12-20 | Oakland | Michigan | 26125 | 186800 | 3005 |
2029168 | 2029168 | 2021-12-19 | Oakland | Michigan | 26125 | 184721 | 2994 |
2025917 | 2025917 | 2021-12-18 | Oakland | Michigan | 26125 | 184721 | 2994 |
2022666 | 2022666 | 2021-12-17 | Oakland | Michigan | 26125 | 184721 | 2994 |
2019415 | 2019415 | 2021-12-16 | Oakland | Michigan | 26125 | 182789 | 2967 |
2016165 | 2016165 | 2021-12-15 | Oakland | Michigan | 26125 | 182789 | 2967 |
2012914 | 2012914 | 2021-12-14 | Oakland | Michigan | 26125 | 181037 | 2930 |
2009663 | 2009663 | 2021-12-13 | Oakland | Michigan | 26125 | 181037 | 2930 |
2006412 | 2006412 | 2021-12-12 | Oakland | Michigan | 26125 | 179078 | 2920 |
2003161 | 2003161 | 2021-12-11 | Oakland | Michigan | 26125 | 179078 | 2920 |
1999911 | 1999911 | 2021-12-10 | Oakland | Michigan | 26125 | 179078 | 2920 |
1996660 | 1996660 | 2021-12-09 | Oakland | Michigan | 26125 | 177385 | 2898 |
1993409 | 1993409 | 2021-12-08 | Oakland | Michigan | 26125 | 177385 | 2898 |
1990158 | 1990158 | 2021-12-07 | Oakland | Michigan | 26125 | 175182 | 2864 |
1986908 | 1986908 | 2021-12-06 | Oakland | Michigan | 26125 | 175182 | 2864 |
1983658 | 1983658 | 2021-12-05 | Oakland | Michigan | 26125 | 173149 | 2857 |
1980408 | 1980408 | 2021-12-04 | Oakland | Michigan | 26125 | 173149 | 2857 |
1977158 | 1977158 | 2021-12-03 | Oakland | Michigan | 26125 | 173149 | 2857 |
1973908 | 1973908 | 2021-12-02 | Oakland | Michigan | 26125 | 170525 | 2835 |
1970659 | 1970659 | 2021-12-01 | Oakland | Michigan | 26125 | 170525 | 2835 |
1967409 | 1967409 | 2021-11-30 | Oakland | Michigan | 26125 | 168182 | 2794 |
1964157 | 1964157 | 2021-11-29 | Oakland | Michigan | 26125 | 168182 | 2794 |
1960906 | 1960906 | 2021-11-28 | Oakland | Michigan | 26125 | 164814 | 2784 |
1957655 | 1957655 | 2021-11-27 | Oakland | Michigan | 26125 | 164814 | 2784 |
1954404 | 1954404 | 2021-11-26 | Oakland | Michigan | 26125 | 164814 | 2784 |
1951153 | 1951153 | 2021-11-25 | Oakland | Michigan | 26125 | 164814 | 2784 |
1947902 | 1947902 | 2021-11-24 | Oakland | Michigan | 26125 | 164814 | 2784 |
1944651 | 1944651 | 2021-11-23 | Oakland | Michigan | 26125 | 162425 | 2765 |
1941400 | 1941400 | 2021-11-22 | Oakland | Michigan | 26125 | 162425 | 2765 |
1938150 | 1938150 | 2021-11-21 | Oakland | Michigan | 26125 | 160301 | 2761 |
1934900 | 1934900 | 2021-11-20 | Oakland | Michigan | 26125 | 160301 | 2761 |
1931650 | 1931650 | 2021-11-19 | Oakland | Michigan | 26125 | 160301 | 2761 |
1928399 | 1928399 | 2021-11-18 | Oakland | Michigan | 26125 | 158285 | 2754 |
1925149 | 1925149 | 2021-11-17 | Oakland | Michigan | 26125 | 158285 | 2754 |
1921900 | 1921900 | 2021-11-16 | Oakland | Michigan | 26125 | 156443 | 2734 |
1918650 | 1918650 | 2021-11-15 | Oakland | Michigan | 26125 | 156443 | 2734 |
1915400 | 1915400 | 2021-11-14 | Oakland | Michigan | 26125 | 154178 | 2729 |
1912150 | 1912150 | 2021-11-13 | Oakland | Michigan | 26125 | 154178 | 2729 |
1908900 | 1908900 | 2021-11-12 | Oakland | Michigan | 26125 | 154178 | 2729 |
1905651 | 1905651 | 2021-11-11 | Oakland | Michigan | 26125 | 152363 | 2721 |
1902402 | 1902402 | 2021-11-10 | Oakland | Michigan | 26125 | 152363 | 2721 |
1899152 | 1899152 | 2021-11-09 | Oakland | Michigan | 26125 | 151251 | 2711 |
1895902 | 1895902 | 2021-11-08 | Oakland | Michigan | 26125 | 151251 | 2711 |
1892652 | 1892652 | 2021-11-07 | Oakland | Michigan | 26125 | 150362 | 2710 |
1889402 | 1889402 | 2021-11-06 | Oakland | Michigan | 26125 | 150362 | 2710 |
1886152 | 1886152 | 2021-11-05 | Oakland | Michigan | 26125 | 150362 | 2710 |
1882903 | 1882903 | 2021-11-04 | Oakland | Michigan | 26125 | 149080 | 2703 |
1879654 | 1879654 | 2021-11-03 | Oakland | Michigan | 26125 | 149080 | 2703 |
1876405 | 1876405 | 2021-11-02 | Oakland | Michigan | 26125 | 147952 | 2695 |
1873156 | 1873156 | 2021-11-01 | Oakland | Michigan | 26125 | 147952 | 2695 |
1869907 | 1869907 | 2021-10-31 | Oakland | Michigan | 26125 | 146943 | 2692 |
1866658 | 1866658 | 2021-10-30 | Oakland | Michigan | 26125 | 146943 | 2692 |
1863409 | 1863409 | 2021-10-29 | Oakland | Michigan | 26125 | 146943 | 2692 |
1860160 | 1860160 | 2021-10-28 | Oakland | Michigan | 26125 | 146046 | 2682 |
1856911 | 1856911 | 2021-10-27 | Oakland | Michigan | 26125 | 146046 | 2682 |
1853662 | 1853662 | 2021-10-26 | Oakland | Michigan | 26125 | 145119 | 2672 |
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);