ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Carbon" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176475 | 2176475 | 2022-02-02 | Carbon | Pennsylvania | 42025 | 15364 | 263 |
2173221 | 2173221 | 2022-02-01 | Carbon | Pennsylvania | 42025 | 15316 | 262 |
2169969 | 2169969 | 2022-01-31 | Carbon | Pennsylvania | 42025 | 15304 | 259 |
2166715 | 2166715 | 2022-01-30 | Carbon | Pennsylvania | 42025 | 15278 | 259 |
2163460 | 2163460 | 2022-01-29 | Carbon | Pennsylvania | 42025 | 15236 | 259 |
2160205 | 2160205 | 2022-01-28 | Carbon | Pennsylvania | 42025 | 15210 | 258 |
2156949 | 2156949 | 2022-01-27 | Carbon | Pennsylvania | 42025 | 15113 | 258 |
2153696 | 2153696 | 2022-01-26 | Carbon | Pennsylvania | 42025 | 15018 | 257 |
2150444 | 2150444 | 2022-01-25 | Carbon | Pennsylvania | 42025 | 14944 | 257 |
2147192 | 2147192 | 2022-01-24 | Carbon | Pennsylvania | 42025 | 14899 | 254 |
2143938 | 2143938 | 2022-01-23 | Carbon | Pennsylvania | 42025 | 14868 | 254 |
2140683 | 2140683 | 2022-01-22 | Carbon | Pennsylvania | 42025 | 14806 | 254 |
2137427 | 2137427 | 2022-01-21 | Carbon | Pennsylvania | 42025 | 14681 | 252 |
2134173 | 2134173 | 2022-01-20 | Carbon | Pennsylvania | 42025 | 14608 | 250 |
2130921 | 2130921 | 2022-01-19 | Carbon | Pennsylvania | 42025 | 14527 | 248 |
2127667 | 2127667 | 2022-01-18 | Carbon | Pennsylvania | 42025 | 14455 | 245 |
2124415 | 2124415 | 2022-01-17 | Carbon | Pennsylvania | 42025 | 14408 | 245 |
2121163 | 2121163 | 2022-01-16 | Carbon | Pennsylvania | 42025 | 14326 | 245 |
2117911 | 2117911 | 2022-01-15 | Carbon | Pennsylvania | 42025 | 14024 | 245 |
2114660 | 2114660 | 2022-01-14 | Carbon | Pennsylvania | 42025 | 13937 | 243 |
2111408 | 2111408 | 2022-01-13 | Carbon | Pennsylvania | 42025 | 13752 | 243 |
2108156 | 2108156 | 2022-01-12 | Carbon | Pennsylvania | 42025 | 13601 | 243 |
2104905 | 2104905 | 2022-01-11 | Carbon | Pennsylvania | 42025 | 13391 | 242 |
2101654 | 2101654 | 2022-01-10 | Carbon | Pennsylvania | 42025 | 13127 | 238 |
2098403 | 2098403 | 2022-01-09 | Carbon | Pennsylvania | 42025 | 12969 | 238 |
2095151 | 2095151 | 2022-01-08 | Carbon | Pennsylvania | 42025 | 12805 | 238 |
2091899 | 2091899 | 2022-01-07 | Carbon | Pennsylvania | 42025 | 12618 | 236 |
2088647 | 2088647 | 2022-01-06 | Carbon | Pennsylvania | 42025 | 12492 | 235 |
2085396 | 2085396 | 2022-01-05 | Carbon | Pennsylvania | 42025 | 12334 | 235 |
2082144 | 2082144 | 2022-01-04 | Carbon | Pennsylvania | 42025 | 12254 | 234 |
2078892 | 2078892 | 2022-01-03 | Carbon | Pennsylvania | 42025 | 12156 | 233 |
2075641 | 2075641 | 2022-01-02 | Carbon | Pennsylvania | 42025 | 12045 | 232 |
2072390 | 2072390 | 2022-01-01 | Carbon | Pennsylvania | 42025 | 11953 | 232 |
2069139 | 2069139 | 2021-12-31 | Carbon | Pennsylvania | 42025 | 11890 | 232 |
2065888 | 2065888 | 2021-12-30 | Carbon | Pennsylvania | 42025 | 11733 | 231 |
2062638 | 2062638 | 2021-12-29 | Carbon | Pennsylvania | 42025 | 11661 | 230 |
2059388 | 2059388 | 2021-12-28 | Carbon | Pennsylvania | 42025 | 11603 | 228 |
2056139 | 2056139 | 2021-12-27 | Carbon | Pennsylvania | 42025 | 11527 | 228 |
2052890 | 2052890 | 2021-12-26 | Carbon | Pennsylvania | 42025 | 11481 | 228 |
2049640 | 2049640 | 2021-12-25 | Carbon | Pennsylvania | 42025 | 11399 | 228 |
2046390 | 2046390 | 2021-12-24 | Carbon | Pennsylvania | 42025 | 11343 | 228 |
2043140 | 2043140 | 2021-12-23 | Carbon | Pennsylvania | 42025 | 11271 | 227 |
2039891 | 2039891 | 2021-12-22 | Carbon | Pennsylvania | 42025 | 11227 | 225 |
2036641 | 2036641 | 2021-12-21 | Carbon | Pennsylvania | 42025 | 11198 | 225 |
2033391 | 2033391 | 2021-12-20 | Carbon | Pennsylvania | 42025 | 11139 | 225 |
2030141 | 2030141 | 2021-12-19 | Carbon | Pennsylvania | 42025 | 11095 | 225 |
2026890 | 2026890 | 2021-12-18 | Carbon | Pennsylvania | 42025 | 11044 | 225 |
2023639 | 2023639 | 2021-12-17 | Carbon | Pennsylvania | 42025 | 10965 | 223 |
2020388 | 2020388 | 2021-12-16 | Carbon | Pennsylvania | 42025 | 10931 | 223 |
2017137 | 2017137 | 2021-12-15 | Carbon | Pennsylvania | 42025 | 10850 | 223 |
2013887 | 2013887 | 2021-12-14 | Carbon | Pennsylvania | 42025 | 10816 | 222 |
2010636 | 2010636 | 2021-12-13 | Carbon | Pennsylvania | 42025 | 10758 | 220 |
2007385 | 2007385 | 2021-12-12 | Carbon | Pennsylvania | 42025 | 10723 | 220 |
2004134 | 2004134 | 2021-12-11 | Carbon | Pennsylvania | 42025 | 10658 | 220 |
2000883 | 2000883 | 2021-12-10 | Carbon | Pennsylvania | 42025 | 10580 | 219 |
1997633 | 1997633 | 2021-12-09 | Carbon | Pennsylvania | 42025 | 10472 | 218 |
1994382 | 1994382 | 2021-12-08 | Carbon | Pennsylvania | 42025 | 10433 | 217 |
1991131 | 1991131 | 2021-12-07 | Carbon | Pennsylvania | 42025 | 10402 | 217 |
1987880 | 1987880 | 2021-12-06 | Carbon | Pennsylvania | 42025 | 10362 | 217 |
1984630 | 1984630 | 2021-12-05 | Carbon | Pennsylvania | 42025 | 10320 | 217 |
1981380 | 1981380 | 2021-12-04 | Carbon | Pennsylvania | 42025 | 10267 | 217 |
1978130 | 1978130 | 2021-12-03 | Carbon | Pennsylvania | 42025 | 10206 | 216 |
1974880 | 1974880 | 2021-12-02 | Carbon | Pennsylvania | 42025 | 10146 | 215 |
1971631 | 1971631 | 2021-12-01 | Carbon | Pennsylvania | 42025 | 10068 | 214 |
1968381 | 1968381 | 2021-11-30 | Carbon | Pennsylvania | 42025 | 10022 | 213 |
1965130 | 1965130 | 2021-11-29 | Carbon | Pennsylvania | 42025 | 9990 | 211 |
1961878 | 1961878 | 2021-11-28 | Carbon | Pennsylvania | 42025 | 9928 | 211 |
1958627 | 1958627 | 2021-11-27 | Carbon | Pennsylvania | 42025 | 9877 | 211 |
1955376 | 1955376 | 2021-11-26 | Carbon | Pennsylvania | 42025 | 9851 | 211 |
1952125 | 1952125 | 2021-11-25 | Carbon | Pennsylvania | 42025 | 9804 | 211 |
1948874 | 1948874 | 2021-11-24 | Carbon | Pennsylvania | 42025 | 9785 | 209 |
1945623 | 1945623 | 2021-11-23 | Carbon | Pennsylvania | 42025 | 9747 | 209 |
1942372 | 1942372 | 2021-11-22 | Carbon | Pennsylvania | 42025 | 9679 | 209 |
1939122 | 1939122 | 2021-11-21 | Carbon | Pennsylvania | 42025 | 9659 | 209 |
1935872 | 1935872 | 2021-11-20 | Carbon | Pennsylvania | 42025 | 9644 | 209 |
1932622 | 1932622 | 2021-11-19 | Carbon | Pennsylvania | 42025 | 9616 | 208 |
1929371 | 1929371 | 2021-11-18 | Carbon | Pennsylvania | 42025 | 9579 | 208 |
1926121 | 1926121 | 2021-11-17 | Carbon | Pennsylvania | 42025 | 9537 | 208 |
1922871 | 1922871 | 2021-11-16 | Carbon | Pennsylvania | 42025 | 9497 | 207 |
1919622 | 1919622 | 2021-11-15 | Carbon | Pennsylvania | 42025 | 9452 | 206 |
1916372 | 1916372 | 2021-11-14 | Carbon | Pennsylvania | 42025 | 9428 | 206 |
1913122 | 1913122 | 2021-11-13 | Carbon | Pennsylvania | 42025 | 9403 | 205 |
1909872 | 1909872 | 2021-11-12 | Carbon | Pennsylvania | 42025 | 9295 | 205 |
1906623 | 1906623 | 2021-11-11 | Carbon | Pennsylvania | 42025 | 9264 | 205 |
1903374 | 1903374 | 2021-11-10 | Carbon | Pennsylvania | 42025 | 9229 | 205 |
1900124 | 1900124 | 2021-11-09 | Carbon | Pennsylvania | 42025 | 9214 | 204 |
1896874 | 1896874 | 2021-11-08 | Carbon | Pennsylvania | 42025 | 9161 | 204 |
1893624 | 1893624 | 2021-11-07 | Carbon | Pennsylvania | 42025 | 9144 | 204 |
1890374 | 1890374 | 2021-11-06 | Carbon | Pennsylvania | 42025 | 9123 | 204 |
1887124 | 1887124 | 2021-11-05 | Carbon | Pennsylvania | 42025 | 9084 | 203 |
1883874 | 1883874 | 2021-11-04 | Carbon | Pennsylvania | 42025 | 9055 | 202 |
1880625 | 1880625 | 2021-11-03 | Carbon | Pennsylvania | 42025 | 9021 | 202 |
1877376 | 1877376 | 2021-11-02 | Carbon | Pennsylvania | 42025 | 9008 | 202 |
1874127 | 1874127 | 2021-11-01 | Carbon | Pennsylvania | 42025 | 8947 | 202 |
1870878 | 1870878 | 2021-10-31 | Carbon | Pennsylvania | 42025 | 8947 | 202 |
1867629 | 1867629 | 2021-10-30 | Carbon | Pennsylvania | 42025 | 8936 | 202 |
1864380 | 1864380 | 2021-10-29 | Carbon | Pennsylvania | 42025 | 8914 | 202 |
1861131 | 1861131 | 2021-10-28 | Carbon | Pennsylvania | 42025 | 8887 | 202 |
1857882 | 1857882 | 2021-10-27 | Carbon | Pennsylvania | 42025 | 8848 | 202 |
1854633 | 1854633 | 2021-10-26 | Carbon | Pennsylvania | 42025 | 8831 | 200 |
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);