ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Litchfield" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174506 | 2174506 | 2022-02-02 | Litchfield | Connecticut | 9005 | 30126 | 420 |
2171253 | 2171253 | 2022-02-01 | Litchfield | Connecticut | 9005 | 30035 | 420 |
2168000 | 2168000 | 2022-01-31 | Litchfield | Connecticut | 9005 | 29959 | 413 |
2164745 | 2164745 | 2022-01-30 | Litchfield | Connecticut | 9005 | 29753 | 412 |
2161490 | 2161490 | 2022-01-29 | Litchfield | Connecticut | 9005 | 29753 | 412 |
2158234 | 2158234 | 2022-01-28 | Litchfield | Connecticut | 9005 | 29753 | 412 |
2154981 | 2154981 | 2022-01-27 | Litchfield | Connecticut | 9005 | 29614 | 411 |
2151728 | 2151728 | 2022-01-26 | Litchfield | Connecticut | 9005 | 29439 | 410 |
2148476 | 2148476 | 2022-01-25 | Litchfield | Connecticut | 9005 | 29328 | 402 |
2145224 | 2145224 | 2022-01-24 | Litchfield | Connecticut | 9005 | 29166 | 402 |
2141969 | 2141969 | 2022-01-23 | Litchfield | Connecticut | 9005 | 28726 | 401 |
2138714 | 2138714 | 2022-01-22 | Litchfield | Connecticut | 9005 | 28726 | 401 |
2135458 | 2135458 | 2022-01-21 | Litchfield | Connecticut | 9005 | 28726 | 401 |
2132206 | 2132206 | 2022-01-20 | Litchfield | Connecticut | 9005 | 28545 | 395 |
2128953 | 2128953 | 2022-01-19 | Litchfield | Connecticut | 9005 | 28341 | 395 |
2125699 | 2125699 | 2022-01-18 | Litchfield | Connecticut | 9005 | 28139 | 388 |
2122447 | 2122447 | 2022-01-17 | Litchfield | Connecticut | 9005 | 27986 | 388 |
2119195 | 2119195 | 2022-01-16 | Litchfield | Connecticut | 9005 | 27303 | 388 |
2115943 | 2115943 | 2022-01-15 | Litchfield | Connecticut | 9005 | 27303 | 388 |
2112692 | 2112692 | 2022-01-14 | Litchfield | Connecticut | 9005 | 27303 | 388 |
2109440 | 2109440 | 2022-01-13 | Litchfield | Connecticut | 9005 | 26998 | 381 |
2106189 | 2106189 | 2022-01-12 | Litchfield | Connecticut | 9005 | 26620 | 381 |
2102938 | 2102938 | 2022-01-11 | Litchfield | Connecticut | 9005 | 26290 | 381 |
2099687 | 2099687 | 2022-01-10 | Litchfield | Connecticut | 9005 | 26013 | 379 |
2096436 | 2096436 | 2022-01-09 | Litchfield | Connecticut | 9005 | 25012 | 379 |
2093184 | 2093184 | 2022-01-08 | Litchfield | Connecticut | 9005 | 25012 | 379 |
2089932 | 2089932 | 2022-01-07 | Litchfield | Connecticut | 9005 | 25012 | 379 |
2086681 | 2086681 | 2022-01-06 | Litchfield | Connecticut | 9005 | 24566 | 378 |
2083429 | 2083429 | 2022-01-05 | Litchfield | Connecticut | 9005 | 24121 | 378 |
2080177 | 2080177 | 2022-01-04 | Litchfield | Connecticut | 9005 | 23634 | 378 |
2076925 | 2076925 | 2022-01-03 | Litchfield | Connecticut | 9005 | 23232 | 375 |
2073674 | 2073674 | 2022-01-02 | Litchfield | Connecticut | 9005 | 22448 | 371 |
2070423 | 2070423 | 2022-01-01 | Litchfield | Connecticut | 9005 | 22448 | 371 |
2067172 | 2067172 | 2021-12-31 | Litchfield | Connecticut | 9005 | 22448 | 371 |
2063921 | 2063921 | 2021-12-30 | Litchfield | Connecticut | 9005 | 22448 | 371 |
2060671 | 2060671 | 2021-12-29 | Litchfield | Connecticut | 9005 | 22188 | 371 |
2057422 | 2057422 | 2021-12-28 | Litchfield | Connecticut | 9005 | 21929 | 371 |
2054173 | 2054173 | 2021-12-27 | Litchfield | Connecticut | 9005 | 21719 | 366 |
2050923 | 2050923 | 2021-12-26 | Litchfield | Connecticut | 9005 | 21230 | 363 |
2047673 | 2047673 | 2021-12-25 | Litchfield | Connecticut | 9005 | 21230 | 363 |
2044423 | 2044423 | 2021-12-24 | Litchfield | Connecticut | 9005 | 21230 | 363 |
2041174 | 2041174 | 2021-12-23 | Litchfield | Connecticut | 9005 | 21230 | 363 |
2037924 | 2037924 | 2021-12-22 | Litchfield | Connecticut | 9005 | 21082 | 363 |
2034674 | 2034674 | 2021-12-21 | Litchfield | Connecticut | 9005 | 20956 | 363 |
2031424 | 2031424 | 2021-12-20 | Litchfield | Connecticut | 9005 | 20710 | 359 |
2028173 | 2028173 | 2021-12-19 | Litchfield | Connecticut | 9005 | 20434 | 354 |
2024922 | 2024922 | 2021-12-18 | Litchfield | Connecticut | 9005 | 20434 | 354 |
2021671 | 2021671 | 2021-12-17 | Litchfield | Connecticut | 9005 | 20434 | 354 |
2018420 | 2018420 | 2021-12-16 | Litchfield | Connecticut | 9005 | 20315 | 354 |
2015170 | 2015170 | 2021-12-15 | Litchfield | Connecticut | 9005 | 20198 | 354 |
2011919 | 2011919 | 2021-12-14 | Litchfield | Connecticut | 9005 | 20089 | 354 |
2008668 | 2008668 | 2021-12-13 | Litchfield | Connecticut | 9005 | 19924 | 349 |
2005417 | 2005417 | 2021-12-12 | Litchfield | Connecticut | 9005 | 19445 | 349 |
2002166 | 2002166 | 2021-12-11 | Litchfield | Connecticut | 9005 | 19445 | 349 |
1998916 | 1998916 | 2021-12-10 | Litchfield | Connecticut | 9005 | 19445 | 349 |
1995665 | 1995665 | 2021-12-09 | Litchfield | Connecticut | 9005 | 19253 | 347 |
1992414 | 1992414 | 2021-12-08 | Litchfield | Connecticut | 9005 | 19132 | 347 |
1989163 | 1989163 | 2021-12-07 | Litchfield | Connecticut | 9005 | 19086 | 347 |
1985913 | 1985913 | 2021-12-06 | Litchfield | Connecticut | 9005 | 18993 | 344 |
1982663 | 1982663 | 2021-12-05 | Litchfield | Connecticut | 9005 | 18747 | 344 |
1979413 | 1979413 | 2021-12-04 | Litchfield | Connecticut | 9005 | 18747 | 344 |
1976163 | 1976163 | 2021-12-03 | Litchfield | Connecticut | 9005 | 18747 | 344 |
1972914 | 1972914 | 2021-12-02 | Litchfield | Connecticut | 9005 | 18712 | 339 |
1969664 | 1969664 | 2021-12-01 | Litchfield | Connecticut | 9005 | 18590 | 339 |
1966414 | 1966414 | 2021-11-30 | Litchfield | Connecticut | 9005 | 18524 | 339 |
1963162 | 1963162 | 2021-11-29 | Litchfield | Connecticut | 9005 | 18467 | 334 |
1959911 | 1959911 | 2021-11-28 | Litchfield | Connecticut | 9005 | 18271 | 335 |
1956660 | 1956660 | 2021-11-27 | Litchfield | Connecticut | 9005 | 18271 | 335 |
1953409 | 1953409 | 2021-11-26 | Litchfield | Connecticut | 9005 | 18271 | 335 |
1950158 | 1950158 | 2021-11-25 | Litchfield | Connecticut | 9005 | 18124 | 335 |
1946907 | 1946907 | 2021-11-24 | Litchfield | Connecticut | 9005 | 18124 | 335 |
1943656 | 1943656 | 2021-11-23 | Litchfield | Connecticut | 9005 | 18067 | 334 |
1940406 | 1940406 | 2021-11-22 | Litchfield | Connecticut | 9005 | 18032 | 334 |
1937156 | 1937156 | 2021-11-21 | Litchfield | Connecticut | 9005 | 17901 | 334 |
1933906 | 1933906 | 2021-11-20 | Litchfield | Connecticut | 9005 | 17901 | 334 |
1930654 | 1930654 | 2021-11-19 | Litchfield | Connecticut | 9005 | 17901 | 334 |
1927404 | 1927404 | 2021-11-18 | Litchfield | Connecticut | 9005 | 17846 | 332 |
1924154 | 1924154 | 2021-11-17 | Litchfield | Connecticut | 9005 | 17799 | 332 |
1920905 | 1920905 | 2021-11-16 | Litchfield | Connecticut | 9005 | 17738 | 332 |
1917655 | 1917655 | 2021-11-15 | Litchfield | Connecticut | 9005 | 17708 | 332 |
1914405 | 1914405 | 2021-11-14 | Litchfield | Connecticut | 9005 | 17543 | 331 |
1911155 | 1911155 | 2021-11-13 | Litchfield | Connecticut | 9005 | 17543 | 331 |
1907906 | 1907906 | 2021-11-12 | Litchfield | Connecticut | 9005 | 17543 | 331 |
1904657 | 1904657 | 2021-11-11 | Litchfield | Connecticut | 9005 | 17504 | 331 |
1901407 | 1901407 | 2021-11-10 | Litchfield | Connecticut | 9005 | 17446 | 331 |
1898157 | 1898157 | 2021-11-09 | Litchfield | Connecticut | 9005 | 17413 | 331 |
1894907 | 1894907 | 2021-11-08 | Litchfield | Connecticut | 9005 | 17392 | 329 |
1891657 | 1891657 | 2021-11-07 | Litchfield | Connecticut | 9005 | 17316 | 329 |
1888407 | 1888407 | 2021-11-06 | Litchfield | Connecticut | 9005 | 17316 | 329 |
1885157 | 1885157 | 2021-11-05 | Litchfield | Connecticut | 9005 | 17316 | 329 |
1881908 | 1881908 | 2021-11-04 | Litchfield | Connecticut | 9005 | 17289 | 328 |
1878659 | 1878659 | 2021-11-03 | Litchfield | Connecticut | 9005 | 17267 | 328 |
1875410 | 1875410 | 2021-11-02 | Litchfield | Connecticut | 9005 | 17240 | 328 |
1872161 | 1872161 | 2021-11-01 | Litchfield | Connecticut | 9005 | 17216 | 327 |
1868912 | 1868912 | 2021-10-31 | Litchfield | Connecticut | 9005 | 17159 | 327 |
1865663 | 1865663 | 2021-10-30 | Litchfield | Connecticut | 9005 | 17159 | 327 |
1862414 | 1862414 | 2021-10-29 | Litchfield | Connecticut | 9005 | 17159 | 327 |
1859165 | 1859165 | 2021-10-28 | Litchfield | Connecticut | 9005 | 17132 | 326 |
1855916 | 1855916 | 2021-10-27 | Litchfield | Connecticut | 9005 | 17103 | 326 |
1852667 | 1852667 | 2021-10-26 | Litchfield | Connecticut | 9005 | 17087 | 326 |
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);