ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 9009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174508 | 2174508 | 2022-02-02 | New Haven | Connecticut | 9009 | 183922 | 2618 |
2171255 | 2171255 | 2022-02-01 | New Haven | Connecticut | 9009 | 183400 | 2615 |
2168002 | 2168002 | 2022-01-31 | New Haven | Connecticut | 9009 | 183151 | 2595 |
2164747 | 2164747 | 2022-01-30 | New Haven | Connecticut | 9009 | 182543 | 2590 |
2161492 | 2161492 | 2022-01-29 | New Haven | Connecticut | 9009 | 182543 | 2590 |
2158236 | 2158236 | 2022-01-28 | New Haven | Connecticut | 9009 | 182543 | 2590 |
2154983 | 2154983 | 2022-01-27 | New Haven | Connecticut | 9009 | 181836 | 2571 |
2151730 | 2151730 | 2022-01-26 | New Haven | Connecticut | 9009 | 181108 | 2567 |
2148478 | 2148478 | 2022-01-25 | New Haven | Connecticut | 9009 | 180457 | 2538 |
2145226 | 2145226 | 2022-01-24 | New Haven | Connecticut | 9009 | 179656 | 2537 |
2141971 | 2141971 | 2022-01-23 | New Haven | Connecticut | 9009 | 176971 | 2534 |
2138716 | 2138716 | 2022-01-22 | New Haven | Connecticut | 9009 | 176971 | 2534 |
2135460 | 2135460 | 2022-01-21 | New Haven | Connecticut | 9009 | 176971 | 2534 |
2132208 | 2132208 | 2022-01-20 | New Haven | Connecticut | 9009 | 175756 | 2509 |
2128955 | 2128955 | 2022-01-19 | New Haven | Connecticut | 9009 | 174385 | 2506 |
2125701 | 2125701 | 2022-01-18 | New Haven | Connecticut | 9009 | 173127 | 2472 |
2122449 | 2122449 | 2022-01-17 | New Haven | Connecticut | 9009 | 171881 | 2469 |
2119197 | 2119197 | 2022-01-16 | New Haven | Connecticut | 9009 | 167580 | 2470 |
2115945 | 2115945 | 2022-01-15 | New Haven | Connecticut | 9009 | 167580 | 2470 |
2112694 | 2112694 | 2022-01-14 | New Haven | Connecticut | 9009 | 167580 | 2470 |
2109442 | 2109442 | 2022-01-13 | New Haven | Connecticut | 9009 | 165359 | 2434 |
2106191 | 2106191 | 2022-01-12 | New Haven | Connecticut | 9009 | 163214 | 2434 |
2102940 | 2102940 | 2022-01-11 | New Haven | Connecticut | 9009 | 161272 | 2429 |
2099689 | 2099689 | 2022-01-10 | New Haven | Connecticut | 9009 | 159375 | 2403 |
2096438 | 2096438 | 2022-01-09 | New Haven | Connecticut | 9009 | 149587 | 2403 |
2093186 | 2093186 | 2022-01-08 | New Haven | Connecticut | 9009 | 149587 | 2403 |
2089934 | 2089934 | 2022-01-07 | New Haven | Connecticut | 9009 | 149587 | 2403 |
2086683 | 2086683 | 2022-01-06 | New Haven | Connecticut | 9009 | 147192 | 2371 |
2083431 | 2083431 | 2022-01-05 | New Haven | Connecticut | 9009 | 145539 | 2371 |
2080179 | 2080179 | 2022-01-04 | New Haven | Connecticut | 9009 | 143548 | 2371 |
2076927 | 2076927 | 2022-01-03 | New Haven | Connecticut | 9009 | 140745 | 2349 |
2073676 | 2073676 | 2022-01-02 | New Haven | Connecticut | 9009 | 133669 | 2342 |
2070425 | 2070425 | 2022-01-01 | New Haven | Connecticut | 9009 | 133669 | 2342 |
2067174 | 2067174 | 2021-12-31 | New Haven | Connecticut | 9009 | 133669 | 2342 |
2063923 | 2063923 | 2021-12-30 | New Haven | Connecticut | 9009 | 133669 | 2342 |
2060673 | 2060673 | 2021-12-29 | New Haven | Connecticut | 9009 | 131526 | 2342 |
2057424 | 2057424 | 2021-12-28 | New Haven | Connecticut | 9009 | 129536 | 2341 |
2054175 | 2054175 | 2021-12-27 | New Haven | Connecticut | 9009 | 127993 | 2327 |
2050925 | 2050925 | 2021-12-26 | New Haven | Connecticut | 9009 | 124326 | 2325 |
2047675 | 2047675 | 2021-12-25 | New Haven | Connecticut | 9009 | 124326 | 2325 |
2044425 | 2044425 | 2021-12-24 | New Haven | Connecticut | 9009 | 124326 | 2325 |
2041176 | 2041176 | 2021-12-23 | New Haven | Connecticut | 9009 | 124326 | 2325 |
2037926 | 2037926 | 2021-12-22 | New Haven | Connecticut | 9009 | 123300 | 2325 |
2034676 | 2034676 | 2021-12-21 | New Haven | Connecticut | 9009 | 122290 | 2325 |
2031426 | 2031426 | 2021-12-20 | New Haven | Connecticut | 9009 | 120403 | 2318 |
2028175 | 2028175 | 2021-12-19 | New Haven | Connecticut | 9009 | 118666 | 2310 |
2024924 | 2024924 | 2021-12-18 | New Haven | Connecticut | 9009 | 118666 | 2310 |
2021673 | 2021673 | 2021-12-17 | New Haven | Connecticut | 9009 | 118666 | 2310 |
2018422 | 2018422 | 2021-12-16 | New Haven | Connecticut | 9009 | 118367 | 2310 |
2015172 | 2015172 | 2021-12-15 | New Haven | Connecticut | 9009 | 117870 | 2310 |
2011921 | 2011921 | 2021-12-14 | New Haven | Connecticut | 9009 | 117516 | 2308 |
2008670 | 2008670 | 2021-12-13 | New Haven | Connecticut | 9009 | 116779 | 2297 |
2005419 | 2005419 | 2021-12-12 | New Haven | Connecticut | 9009 | 114705 | 2297 |
2002168 | 2002168 | 2021-12-11 | New Haven | Connecticut | 9009 | 114705 | 2297 |
1998918 | 1998918 | 2021-12-10 | New Haven | Connecticut | 9009 | 114705 | 2297 |
1995667 | 1995667 | 2021-12-09 | New Haven | Connecticut | 9009 | 113940 | 2288 |
1992416 | 1992416 | 2021-12-08 | New Haven | Connecticut | 9009 | 113208 | 2288 |
1989165 | 1989165 | 2021-12-07 | New Haven | Connecticut | 9009 | 112969 | 2288 |
1985915 | 1985915 | 2021-12-06 | New Haven | Connecticut | 9009 | 112425 | 2280 |
1982665 | 1982665 | 2021-12-05 | New Haven | Connecticut | 9009 | 110848 | 2280 |
1979415 | 1979415 | 2021-12-04 | New Haven | Connecticut | 9009 | 110848 | 2280 |
1976165 | 1976165 | 2021-12-03 | New Haven | Connecticut | 9009 | 110848 | 2280 |
1972916 | 1972916 | 2021-12-02 | New Haven | Connecticut | 9009 | 110703 | 2274 |
1969666 | 1969666 | 2021-12-01 | New Haven | Connecticut | 9009 | 110417 | 2274 |
1966416 | 1966416 | 2021-11-30 | New Haven | Connecticut | 9009 | 110214 | 2272 |
1963164 | 1963164 | 2021-11-29 | New Haven | Connecticut | 9009 | 109979 | 2266 |
1959913 | 1959913 | 2021-11-28 | New Haven | Connecticut | 9009 | 109448 | 2266 |
1956662 | 1956662 | 2021-11-27 | New Haven | Connecticut | 9009 | 109448 | 2266 |
1953411 | 1953411 | 2021-11-26 | New Haven | Connecticut | 9009 | 109448 | 2266 |
1950160 | 1950160 | 2021-11-25 | New Haven | Connecticut | 9009 | 108996 | 2266 |
1946909 | 1946909 | 2021-11-24 | New Haven | Connecticut | 9009 | 108996 | 2266 |
1943658 | 1943658 | 2021-11-23 | New Haven | Connecticut | 9009 | 108762 | 2264 |
1940408 | 1940408 | 2021-11-22 | New Haven | Connecticut | 9009 | 108507 | 2264 |
1937158 | 1937158 | 2021-11-21 | New Haven | Connecticut | 9009 | 107964 | 2262 |
1933908 | 1933908 | 2021-11-20 | New Haven | Connecticut | 9009 | 107964 | 2262 |
1930656 | 1930656 | 2021-11-19 | New Haven | Connecticut | 9009 | 107964 | 2262 |
1927406 | 1927406 | 2021-11-18 | New Haven | Connecticut | 9009 | 107768 | 2258 |
1924156 | 1924156 | 2021-11-17 | New Haven | Connecticut | 9009 | 107605 | 2258 |
1920907 | 1920907 | 2021-11-16 | New Haven | Connecticut | 9009 | 107382 | 2256 |
1917657 | 1917657 | 2021-11-15 | New Haven | Connecticut | 9009 | 107237 | 2256 |
1914407 | 1914407 | 2021-11-14 | New Haven | Connecticut | 9009 | 106748 | 2250 |
1911157 | 1911157 | 2021-11-13 | New Haven | Connecticut | 9009 | 106748 | 2250 |
1907908 | 1907908 | 2021-11-12 | New Haven | Connecticut | 9009 | 106748 | 2250 |
1904659 | 1904659 | 2021-11-11 | New Haven | Connecticut | 9009 | 106641 | 2250 |
1901409 | 1901409 | 2021-11-10 | New Haven | Connecticut | 9009 | 106526 | 2250 |
1898159 | 1898159 | 2021-11-09 | New Haven | Connecticut | 9009 | 106385 | 2249 |
1894909 | 1894909 | 2021-11-08 | New Haven | Connecticut | 9009 | 106330 | 2241 |
1891659 | 1891659 | 2021-11-07 | New Haven | Connecticut | 9009 | 106133 | 2241 |
1888409 | 1888409 | 2021-11-06 | New Haven | Connecticut | 9009 | 106133 | 2241 |
1885159 | 1885159 | 2021-11-05 | New Haven | Connecticut | 9009 | 106133 | 2241 |
1881910 | 1881910 | 2021-11-04 | New Haven | Connecticut | 9009 | 106056 | 2236 |
1878661 | 1878661 | 2021-11-03 | New Haven | Connecticut | 9009 | 105929 | 2236 |
1875412 | 1875412 | 2021-11-02 | New Haven | Connecticut | 9009 | 105840 | 2236 |
1872163 | 1872163 | 2021-11-01 | New Haven | Connecticut | 9009 | 105766 | 2234 |
1868914 | 1868914 | 2021-10-31 | New Haven | Connecticut | 9009 | 105535 | 2233 |
1865665 | 1865665 | 2021-10-30 | New Haven | Connecticut | 9009 | 105535 | 2233 |
1862416 | 1862416 | 2021-10-29 | New Haven | Connecticut | 9009 | 105535 | 2233 |
1859167 | 1859167 | 2021-10-28 | New Haven | Connecticut | 9009 | 105441 | 2231 |
1855918 | 1855918 | 2021-10-27 | New Haven | Connecticut | 9009 | 105357 | 2231 |
1852669 | 1852669 | 2021-10-26 | New Haven | Connecticut | 9009 | 105271 | 2231 |
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);