ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 9011 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174509 | 2174509 | 2022-02-02 | New London | Connecticut | 9011 | 51447 | 591 |
2171256 | 2171256 | 2022-02-01 | New London | Connecticut | 9011 | 51271 | 591 |
2168003 | 2168003 | 2022-01-31 | New London | Connecticut | 9011 | 51160 | 587 |
2164748 | 2164748 | 2022-01-30 | New London | Connecticut | 9011 | 50879 | 587 |
2161493 | 2161493 | 2022-01-29 | New London | Connecticut | 9011 | 50879 | 587 |
2158237 | 2158237 | 2022-01-28 | New London | Connecticut | 9011 | 50879 | 587 |
2154984 | 2154984 | 2022-01-27 | New London | Connecticut | 9011 | 50633 | 582 |
2151731 | 2151731 | 2022-01-26 | New London | Connecticut | 9011 | 50278 | 582 |
2148479 | 2148479 | 2022-01-25 | New London | Connecticut | 9011 | 49922 | 567 |
2145227 | 2145227 | 2022-01-24 | New London | Connecticut | 9011 | 49451 | 567 |
2141972 | 2141972 | 2022-01-23 | New London | Connecticut | 9011 | 48476 | 567 |
2138717 | 2138717 | 2022-01-22 | New London | Connecticut | 9011 | 48476 | 567 |
2135461 | 2135461 | 2022-01-21 | New London | Connecticut | 9011 | 48476 | 567 |
2132209 | 2132209 | 2022-01-20 | New London | Connecticut | 9011 | 47913 | 564 |
2128956 | 2128956 | 2022-01-19 | New London | Connecticut | 9011 | 47461 | 564 |
2125702 | 2125702 | 2022-01-18 | New London | Connecticut | 9011 | 46934 | 555 |
2122450 | 2122450 | 2022-01-17 | New London | Connecticut | 9011 | 46635 | 555 |
2119198 | 2119198 | 2022-01-16 | New London | Connecticut | 9011 | 45088 | 555 |
2115946 | 2115946 | 2022-01-15 | New London | Connecticut | 9011 | 45088 | 555 |
2112695 | 2112695 | 2022-01-14 | New London | Connecticut | 9011 | 45088 | 555 |
2109443 | 2109443 | 2022-01-13 | New London | Connecticut | 9011 | 44355 | 543 |
2106192 | 2106192 | 2022-01-12 | New London | Connecticut | 9011 | 43531 | 543 |
2102941 | 2102941 | 2022-01-11 | New London | Connecticut | 9011 | 42826 | 541 |
2099690 | 2099690 | 2022-01-10 | New London | Connecticut | 9011 | 42381 | 539 |
2096439 | 2096439 | 2022-01-09 | New London | Connecticut | 9011 | 40016 | 539 |
2093187 | 2093187 | 2022-01-08 | New London | Connecticut | 9011 | 40016 | 539 |
2089935 | 2089935 | 2022-01-07 | New London | Connecticut | 9011 | 40016 | 539 |
2086684 | 2086684 | 2022-01-06 | New London | Connecticut | 9011 | 39336 | 532 |
2083432 | 2083432 | 2022-01-05 | New London | Connecticut | 9011 | 38819 | 532 |
2080180 | 2080180 | 2022-01-04 | New London | Connecticut | 9011 | 37997 | 532 |
2076928 | 2076928 | 2022-01-03 | New London | Connecticut | 9011 | 37396 | 529 |
2073677 | 2073677 | 2022-01-02 | New London | Connecticut | 9011 | 36134 | 522 |
2070426 | 2070426 | 2022-01-01 | New London | Connecticut | 9011 | 36134 | 522 |
2067175 | 2067175 | 2021-12-31 | New London | Connecticut | 9011 | 36134 | 522 |
2063924 | 2063924 | 2021-12-30 | New London | Connecticut | 9011 | 36134 | 522 |
2060674 | 2060674 | 2021-12-29 | New London | Connecticut | 9011 | 35683 | 522 |
2057425 | 2057425 | 2021-12-28 | New London | Connecticut | 9011 | 35329 | 522 |
2054176 | 2054176 | 2021-12-27 | New London | Connecticut | 9011 | 34949 | 521 |
2050926 | 2050926 | 2021-12-26 | New London | Connecticut | 9011 | 34077 | 520 |
2047676 | 2047676 | 2021-12-25 | New London | Connecticut | 9011 | 34077 | 520 |
2044426 | 2044426 | 2021-12-24 | New London | Connecticut | 9011 | 34077 | 520 |
2041177 | 2041177 | 2021-12-23 | New London | Connecticut | 9011 | 34077 | 520 |
2037927 | 2037927 | 2021-12-22 | New London | Connecticut | 9011 | 33949 | 520 |
2034677 | 2034677 | 2021-12-21 | New London | Connecticut | 9011 | 33796 | 520 |
2031427 | 2031427 | 2021-12-20 | New London | Connecticut | 9011 | 33369 | 518 |
2028176 | 2028176 | 2021-12-19 | New London | Connecticut | 9011 | 32875 | 513 |
2024925 | 2024925 | 2021-12-18 | New London | Connecticut | 9011 | 32875 | 513 |
2021674 | 2021674 | 2021-12-17 | New London | Connecticut | 9011 | 32875 | 513 |
2018423 | 2018423 | 2021-12-16 | New London | Connecticut | 9011 | 32724 | 513 |
2015173 | 2015173 | 2021-12-15 | New London | Connecticut | 9011 | 32578 | 513 |
2011922 | 2011922 | 2021-12-14 | New London | Connecticut | 9011 | 32421 | 513 |
2008671 | 2008671 | 2021-12-13 | New London | Connecticut | 9011 | 32214 | 512 |
2005420 | 2005420 | 2021-12-12 | New London | Connecticut | 9011 | 31520 | 512 |
2002169 | 2002169 | 2021-12-11 | New London | Connecticut | 9011 | 31520 | 512 |
1998919 | 1998919 | 2021-12-10 | New London | Connecticut | 9011 | 31520 | 512 |
1995668 | 1995668 | 2021-12-09 | New London | Connecticut | 9011 | 31159 | 510 |
1992417 | 1992417 | 2021-12-08 | New London | Connecticut | 9011 | 30904 | 510 |
1989166 | 1989166 | 2021-12-07 | New London | Connecticut | 9011 | 30862 | 510 |
1985916 | 1985916 | 2021-12-06 | New London | Connecticut | 9011 | 30694 | 510 |
1982666 | 1982666 | 2021-12-05 | New London | Connecticut | 9011 | 30126 | 510 |
1979416 | 1979416 | 2021-12-04 | New London | Connecticut | 9011 | 30126 | 510 |
1976166 | 1976166 | 2021-12-03 | New London | Connecticut | 9011 | 30126 | 510 |
1972917 | 1972917 | 2021-12-02 | New London | Connecticut | 9011 | 30052 | 508 |
1969667 | 1969667 | 2021-12-01 | New London | Connecticut | 9011 | 29881 | 508 |
1966417 | 1966417 | 2021-11-30 | New London | Connecticut | 9011 | 29782 | 507 |
1963165 | 1963165 | 2021-11-29 | New London | Connecticut | 9011 | 29689 | 500 |
1959914 | 1959914 | 2021-11-28 | New London | Connecticut | 9011 | 29473 | 500 |
1956663 | 1956663 | 2021-11-27 | New London | Connecticut | 9011 | 29473 | 500 |
1953412 | 1953412 | 2021-11-26 | New London | Connecticut | 9011 | 29473 | 500 |
1950161 | 1950161 | 2021-11-25 | New London | Connecticut | 9011 | 29221 | 500 |
1946910 | 1946910 | 2021-11-24 | New London | Connecticut | 9011 | 29221 | 500 |
1943659 | 1943659 | 2021-11-23 | New London | Connecticut | 9011 | 29135 | 499 |
1940409 | 1940409 | 2021-11-22 | New London | Connecticut | 9011 | 29050 | 499 |
1937159 | 1937159 | 2021-11-21 | New London | Connecticut | 9011 | 28789 | 499 |
1933909 | 1933909 | 2021-11-20 | New London | Connecticut | 9011 | 28789 | 499 |
1930657 | 1930657 | 2021-11-19 | New London | Connecticut | 9011 | 28789 | 499 |
1927407 | 1927407 | 2021-11-18 | New London | Connecticut | 9011 | 28682 | 496 |
1924157 | 1924157 | 2021-11-17 | New London | Connecticut | 9011 | 28564 | 496 |
1920908 | 1920908 | 2021-11-16 | New London | Connecticut | 9011 | 28462 | 496 |
1917658 | 1917658 | 2021-11-15 | New London | Connecticut | 9011 | 28410 | 496 |
1914408 | 1914408 | 2021-11-14 | New London | Connecticut | 9011 | 28097 | 496 |
1911158 | 1911158 | 2021-11-13 | New London | Connecticut | 9011 | 28097 | 496 |
1907909 | 1907909 | 2021-11-12 | New London | Connecticut | 9011 | 28097 | 496 |
1904660 | 1904660 | 2021-11-11 | New London | Connecticut | 9011 | 28061 | 496 |
1901410 | 1901410 | 2021-11-10 | New London | Connecticut | 9011 | 28006 | 496 |
1898160 | 1898160 | 2021-11-09 | New London | Connecticut | 9011 | 27923 | 496 |
1894910 | 1894910 | 2021-11-08 | New London | Connecticut | 9011 | 27896 | 495 |
1891660 | 1891660 | 2021-11-07 | New London | Connecticut | 9011 | 27786 | 495 |
1888410 | 1888410 | 2021-11-06 | New London | Connecticut | 9011 | 27786 | 495 |
1885160 | 1885160 | 2021-11-05 | New London | Connecticut | 9011 | 27786 | 495 |
1881911 | 1881911 | 2021-11-04 | New London | Connecticut | 9011 | 27760 | 494 |
1878662 | 1878662 | 2021-11-03 | New London | Connecticut | 9011 | 27728 | 494 |
1875413 | 1875413 | 2021-11-02 | New London | Connecticut | 9011 | 27685 | 494 |
1872164 | 1872164 | 2021-11-01 | New London | Connecticut | 9011 | 27645 | 494 |
1868915 | 1868915 | 2021-10-31 | New London | Connecticut | 9011 | 27543 | 494 |
1865666 | 1865666 | 2021-10-30 | New London | Connecticut | 9011 | 27543 | 494 |
1862417 | 1862417 | 2021-10-29 | New London | Connecticut | 9011 | 27543 | 494 |
1859168 | 1859168 | 2021-10-28 | New London | Connecticut | 9011 | 27494 | 493 |
1855919 | 1855919 | 2021-10-27 | New London | Connecticut | 9011 | 27451 | 493 |
1852670 | 1852670 | 2021-10-26 | New London | Connecticut | 9011 | 27428 | 493 |
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);