ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Adams" and fips = 42001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176463 | 2176463 | 2022-02-02 | Adams | Pennsylvania | 42001 | 23816 | 329 |
2173209 | 2173209 | 2022-02-01 | Adams | Pennsylvania | 42001 | 23750 | 326 |
2169957 | 2169957 | 2022-01-31 | Adams | Pennsylvania | 42001 | 23678 | 323 |
2166703 | 2166703 | 2022-01-30 | Adams | Pennsylvania | 42001 | 23605 | 323 |
2163448 | 2163448 | 2022-01-29 | Adams | Pennsylvania | 42001 | 23471 | 323 |
2160193 | 2160193 | 2022-01-28 | Adams | Pennsylvania | 42001 | 23387 | 321 |
2156937 | 2156937 | 2022-01-27 | Adams | Pennsylvania | 42001 | 23260 | 321 |
2153684 | 2153684 | 2022-01-26 | Adams | Pennsylvania | 42001 | 23111 | 314 |
2150432 | 2150432 | 2022-01-25 | Adams | Pennsylvania | 42001 | 22985 | 314 |
2147180 | 2147180 | 2022-01-24 | Adams | Pennsylvania | 42001 | 22865 | 310 |
2143926 | 2143926 | 2022-01-23 | Adams | Pennsylvania | 42001 | 22775 | 310 |
2140671 | 2140671 | 2022-01-22 | Adams | Pennsylvania | 42001 | 22583 | 310 |
2137415 | 2137415 | 2022-01-21 | Adams | Pennsylvania | 42001 | 22448 | 309 |
2134161 | 2134161 | 2022-01-20 | Adams | Pennsylvania | 42001 | 22277 | 304 |
2130909 | 2130909 | 2022-01-19 | Adams | Pennsylvania | 42001 | 22126 | 301 |
2127655 | 2127655 | 2022-01-18 | Adams | Pennsylvania | 42001 | 22010 | 300 |
2124403 | 2124403 | 2022-01-17 | Adams | Pennsylvania | 42001 | 21842 | 300 |
2121151 | 2121151 | 2022-01-16 | Adams | Pennsylvania | 42001 | 21615 | 300 |
2117899 | 2117899 | 2022-01-15 | Adams | Pennsylvania | 42001 | 21276 | 300 |
2114648 | 2114648 | 2022-01-14 | Adams | Pennsylvania | 42001 | 21047 | 298 |
2111396 | 2111396 | 2022-01-13 | Adams | Pennsylvania | 42001 | 20856 | 294 |
2108144 | 2108144 | 2022-01-12 | Adams | Pennsylvania | 42001 | 20686 | 293 |
2104893 | 2104893 | 2022-01-11 | Adams | Pennsylvania | 42001 | 20464 | 290 |
2101642 | 2101642 | 2022-01-10 | Adams | Pennsylvania | 42001 | 20366 | 289 |
2098391 | 2098391 | 2022-01-09 | Adams | Pennsylvania | 42001 | 19943 | 289 |
2095139 | 2095139 | 2022-01-08 | Adams | Pennsylvania | 42001 | 19762 | 289 |
2091887 | 2091887 | 2022-01-07 | Adams | Pennsylvania | 42001 | 19555 | 288 |
2088635 | 2088635 | 2022-01-06 | Adams | Pennsylvania | 42001 | 19385 | 286 |
2085384 | 2085384 | 2022-01-05 | Adams | Pennsylvania | 42001 | 19223 | 284 |
2082132 | 2082132 | 2022-01-04 | Adams | Pennsylvania | 42001 | 18993 | 282 |
2078880 | 2078880 | 2022-01-03 | Adams | Pennsylvania | 42001 | 18795 | 274 |
2075629 | 2075629 | 2022-01-02 | Adams | Pennsylvania | 42001 | 18658 | 274 |
2072378 | 2072378 | 2022-01-01 | Adams | Pennsylvania | 42001 | 18458 | 274 |
2069127 | 2069127 | 2021-12-31 | Adams | Pennsylvania | 42001 | 18341 | 274 |
2065876 | 2065876 | 2021-12-30 | Adams | Pennsylvania | 42001 | 18097 | 274 |
2062626 | 2062626 | 2021-12-29 | Adams | Pennsylvania | 42001 | 17935 | 273 |
2059376 | 2059376 | 2021-12-28 | Adams | Pennsylvania | 42001 | 17786 | 268 |
2056127 | 2056127 | 2021-12-27 | Adams | Pennsylvania | 42001 | 17673 | 266 |
2052878 | 2052878 | 2021-12-26 | Adams | Pennsylvania | 42001 | 17559 | 266 |
2049628 | 2049628 | 2021-12-25 | Adams | Pennsylvania | 42001 | 17482 | 266 |
2046378 | 2046378 | 2021-12-24 | Adams | Pennsylvania | 42001 | 17335 | 266 |
2043128 | 2043128 | 2021-12-23 | Adams | Pennsylvania | 42001 | 17099 | 265 |
2039879 | 2039879 | 2021-12-22 | Adams | Pennsylvania | 42001 | 16826 | 264 |
2036629 | 2036629 | 2021-12-21 | Adams | Pennsylvania | 42001 | 16284 | 262 |
2033379 | 2033379 | 2021-12-20 | Adams | Pennsylvania | 42001 | 16156 | 261 |
2030129 | 2030129 | 2021-12-19 | Adams | Pennsylvania | 42001 | 16087 | 261 |
2026878 | 2026878 | 2021-12-18 | Adams | Pennsylvania | 42001 | 16003 | 260 |
2023627 | 2023627 | 2021-12-17 | Adams | Pennsylvania | 42001 | 15905 | 258 |
2020376 | 2020376 | 2021-12-16 | Adams | Pennsylvania | 42001 | 15816 | 256 |
2017125 | 2017125 | 2021-12-15 | Adams | Pennsylvania | 42001 | 15727 | 256 |
2013875 | 2013875 | 2021-12-14 | Adams | Pennsylvania | 42001 | 15642 | 254 |
2010624 | 2010624 | 2021-12-13 | Adams | Pennsylvania | 42001 | 15587 | 254 |
2007373 | 2007373 | 2021-12-12 | Adams | Pennsylvania | 42001 | 15520 | 254 |
2004122 | 2004122 | 2021-12-11 | Adams | Pennsylvania | 42001 | 15443 | 254 |
2000871 | 2000871 | 2021-12-10 | Adams | Pennsylvania | 42001 | 15359 | 253 |
1997621 | 1997621 | 2021-12-09 | Adams | Pennsylvania | 42001 | 15276 | 252 |
1994370 | 1994370 | 2021-12-08 | Adams | Pennsylvania | 42001 | 15210 | 251 |
1991119 | 1991119 | 2021-12-07 | Adams | Pennsylvania | 42001 | 15144 | 248 |
1987868 | 1987868 | 2021-12-06 | Adams | Pennsylvania | 42001 | 15074 | 248 |
1984618 | 1984618 | 2021-12-05 | Adams | Pennsylvania | 42001 | 15031 | 248 |
1981368 | 1981368 | 2021-12-04 | Adams | Pennsylvania | 42001 | 14978 | 248 |
1978118 | 1978118 | 2021-12-03 | Adams | Pennsylvania | 42001 | 14887 | 248 |
1974868 | 1974868 | 2021-12-02 | Adams | Pennsylvania | 42001 | 14842 | 248 |
1971619 | 1971619 | 2021-12-01 | Adams | Pennsylvania | 42001 | 14762 | 247 |
1968369 | 1968369 | 2021-11-30 | Adams | Pennsylvania | 42001 | 14695 | 246 |
1965118 | 1965118 | 2021-11-29 | Adams | Pennsylvania | 42001 | 14640 | 243 |
1961866 | 1961866 | 2021-11-28 | Adams | Pennsylvania | 42001 | 14617 | 243 |
1958615 | 1958615 | 2021-11-27 | Adams | Pennsylvania | 42001 | 14565 | 242 |
1955364 | 1955364 | 2021-11-26 | Adams | Pennsylvania | 42001 | 14535 | 242 |
1952113 | 1952113 | 2021-11-25 | Adams | Pennsylvania | 42001 | 14503 | 242 |
1948862 | 1948862 | 2021-11-24 | Adams | Pennsylvania | 42001 | 14461 | 241 |
1945611 | 1945611 | 2021-11-23 | Adams | Pennsylvania | 42001 | 14405 | 241 |
1942360 | 1942360 | 2021-11-22 | Adams | Pennsylvania | 42001 | 14365 | 241 |
1939110 | 1939110 | 2021-11-21 | Adams | Pennsylvania | 42001 | 14337 | 241 |
1935860 | 1935860 | 2021-11-20 | Adams | Pennsylvania | 42001 | 14288 | 241 |
1932610 | 1932610 | 2021-11-19 | Adams | Pennsylvania | 42001 | 14258 | 241 |
1929359 | 1929359 | 2021-11-18 | Adams | Pennsylvania | 42001 | 14218 | 241 |
1926109 | 1926109 | 2021-11-17 | Adams | Pennsylvania | 42001 | 14186 | 240 |
1922859 | 1922859 | 2021-11-16 | Adams | Pennsylvania | 42001 | 14127 | 238 |
1919610 | 1919610 | 2021-11-15 | Adams | Pennsylvania | 42001 | 14080 | 235 |
1916360 | 1916360 | 2021-11-14 | Adams | Pennsylvania | 42001 | 14052 | 235 |
1913110 | 1913110 | 2021-11-13 | Adams | Pennsylvania | 42001 | 14012 | 235 |
1909860 | 1909860 | 2021-11-12 | Adams | Pennsylvania | 42001 | 13846 | 233 |
1906611 | 1906611 | 2021-11-11 | Adams | Pennsylvania | 42001 | 13802 | 233 |
1903362 | 1903362 | 2021-11-10 | Adams | Pennsylvania | 42001 | 13746 | 233 |
1900112 | 1900112 | 2021-11-09 | Adams | Pennsylvania | 42001 | 13706 | 231 |
1896862 | 1896862 | 2021-11-08 | Adams | Pennsylvania | 42001 | 13679 | 231 |
1893612 | 1893612 | 2021-11-07 | Adams | Pennsylvania | 42001 | 13648 | 231 |
1890362 | 1890362 | 2021-11-06 | Adams | Pennsylvania | 42001 | 13624 | 231 |
1887112 | 1887112 | 2021-11-05 | Adams | Pennsylvania | 42001 | 13580 | 230 |
1883862 | 1883862 | 2021-11-04 | Adams | Pennsylvania | 42001 | 13526 | 230 |
1880613 | 1880613 | 2021-11-03 | Adams | Pennsylvania | 42001 | 13482 | 229 |
1877364 | 1877364 | 2021-11-02 | Adams | Pennsylvania | 42001 | 13442 | 225 |
1874115 | 1874115 | 2021-11-01 | Adams | Pennsylvania | 42001 | 13377 | 225 |
1870866 | 1870866 | 2021-10-31 | Adams | Pennsylvania | 42001 | 13377 | 225 |
1867617 | 1867617 | 2021-10-30 | Adams | Pennsylvania | 42001 | 13346 | 224 |
1864368 | 1864368 | 2021-10-29 | Adams | Pennsylvania | 42001 | 13301 | 224 |
1861119 | 1861119 | 2021-10-28 | Adams | Pennsylvania | 42001 | 13252 | 221 |
1857870 | 1857870 | 2021-10-27 | Adams | Pennsylvania | 42001 | 13213 | 220 |
1854621 | 1854621 | 2021-10-26 | Adams | Pennsylvania | 42001 | 13165 | 219 |
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);