ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Indiana" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176494 | 2176494 | 2022-02-02 | Indiana | Pennsylvania | 42063 | 16318 | 326 |
2173240 | 2173240 | 2022-02-01 | Indiana | Pennsylvania | 42063 | 16233 | 325 |
2169988 | 2169988 | 2022-01-31 | Indiana | Pennsylvania | 42063 | 16216 | 324 |
2166734 | 2166734 | 2022-01-30 | Indiana | Pennsylvania | 42063 | 16158 | 324 |
2163479 | 2163479 | 2022-01-29 | Indiana | Pennsylvania | 42063 | 16088 | 324 |
2160224 | 2160224 | 2022-01-28 | Indiana | Pennsylvania | 42063 | 15967 | 324 |
2156968 | 2156968 | 2022-01-27 | Indiana | Pennsylvania | 42063 | 15805 | 323 |
2153715 | 2153715 | 2022-01-26 | Indiana | Pennsylvania | 42063 | 15637 | 322 |
2150463 | 2150463 | 2022-01-25 | Indiana | Pennsylvania | 42063 | 15569 | 322 |
2147211 | 2147211 | 2022-01-24 | Indiana | Pennsylvania | 42063 | 15468 | 321 |
2143957 | 2143957 | 2022-01-23 | Indiana | Pennsylvania | 42063 | 15361 | 321 |
2140702 | 2140702 | 2022-01-22 | Indiana | Pennsylvania | 42063 | 15260 | 321 |
2137446 | 2137446 | 2022-01-21 | Indiana | Pennsylvania | 42063 | 15118 | 319 |
2134192 | 2134192 | 2022-01-20 | Indiana | Pennsylvania | 42063 | 14941 | 318 |
2130940 | 2130940 | 2022-01-19 | Indiana | Pennsylvania | 42063 | 14807 | 316 |
2127686 | 2127686 | 2022-01-18 | Indiana | Pennsylvania | 42063 | 14698 | 316 |
2124434 | 2124434 | 2022-01-17 | Indiana | Pennsylvania | 42063 | 14589 | 316 |
2121182 | 2121182 | 2022-01-16 | Indiana | Pennsylvania | 42063 | 14487 | 316 |
2117930 | 2117930 | 2022-01-15 | Indiana | Pennsylvania | 42063 | 14255 | 316 |
2114679 | 2114679 | 2022-01-14 | Indiana | Pennsylvania | 42063 | 14045 | 313 |
2111427 | 2111427 | 2022-01-13 | Indiana | Pennsylvania | 42063 | 13908 | 312 |
2108175 | 2108175 | 2022-01-12 | Indiana | Pennsylvania | 42063 | 13728 | 312 |
2104924 | 2104924 | 2022-01-11 | Indiana | Pennsylvania | 42063 | 13583 | 311 |
2101673 | 2101673 | 2022-01-10 | Indiana | Pennsylvania | 42063 | 13528 | 306 |
2098422 | 2098422 | 2022-01-09 | Indiana | Pennsylvania | 42063 | 13429 | 306 |
2095170 | 2095170 | 2022-01-08 | Indiana | Pennsylvania | 42063 | 13346 | 306 |
2091918 | 2091918 | 2022-01-07 | Indiana | Pennsylvania | 42063 | 13192 | 304 |
2088666 | 2088666 | 2022-01-06 | Indiana | Pennsylvania | 42063 | 13050 | 304 |
2085415 | 2085415 | 2022-01-05 | Indiana | Pennsylvania | 42063 | 12948 | 303 |
2082163 | 2082163 | 2022-01-04 | Indiana | Pennsylvania | 42063 | 12811 | 302 |
2078911 | 2078911 | 2022-01-03 | Indiana | Pennsylvania | 42063 | 12697 | 298 |
2075660 | 2075660 | 2022-01-02 | Indiana | Pennsylvania | 42063 | 12654 | 298 |
2072409 | 2072409 | 2022-01-01 | Indiana | Pennsylvania | 42063 | 12592 | 298 |
2069158 | 2069158 | 2021-12-31 | Indiana | Pennsylvania | 42063 | 12529 | 297 |
2065907 | 2065907 | 2021-12-30 | Indiana | Pennsylvania | 42063 | 12441 | 297 |
2062657 | 2062657 | 2021-12-29 | Indiana | Pennsylvania | 42063 | 12368 | 297 |
2059407 | 2059407 | 2021-12-28 | Indiana | Pennsylvania | 42063 | 12276 | 293 |
2056158 | 2056158 | 2021-12-27 | Indiana | Pennsylvania | 42063 | 12233 | 292 |
2052909 | 2052909 | 2021-12-26 | Indiana | Pennsylvania | 42063 | 12218 | 292 |
2049659 | 2049659 | 2021-12-25 | Indiana | Pennsylvania | 42063 | 12190 | 292 |
2046409 | 2046409 | 2021-12-24 | Indiana | Pennsylvania | 42063 | 12151 | 292 |
2043159 | 2043159 | 2021-12-23 | Indiana | Pennsylvania | 42063 | 12082 | 289 |
2039910 | 2039910 | 2021-12-22 | Indiana | Pennsylvania | 42063 | 12043 | 288 |
2036660 | 2036660 | 2021-12-21 | Indiana | Pennsylvania | 42063 | 12017 | 287 |
2033410 | 2033410 | 2021-12-20 | Indiana | Pennsylvania | 42063 | 11955 | 286 |
2030160 | 2030160 | 2021-12-19 | Indiana | Pennsylvania | 42063 | 11936 | 286 |
2026909 | 2026909 | 2021-12-18 | Indiana | Pennsylvania | 42063 | 11901 | 286 |
2023658 | 2023658 | 2021-12-17 | Indiana | Pennsylvania | 42063 | 11863 | 285 |
2020407 | 2020407 | 2021-12-16 | Indiana | Pennsylvania | 42063 | 11818 | 284 |
2017156 | 2017156 | 2021-12-15 | Indiana | Pennsylvania | 42063 | 11785 | 283 |
2013906 | 2013906 | 2021-12-14 | Indiana | Pennsylvania | 42063 | 11743 | 277 |
2010655 | 2010655 | 2021-12-13 | Indiana | Pennsylvania | 42063 | 11681 | 277 |
2007404 | 2007404 | 2021-12-12 | Indiana | Pennsylvania | 42063 | 11659 | 277 |
2004153 | 2004153 | 2021-12-11 | Indiana | Pennsylvania | 42063 | 11602 | 277 |
2000902 | 2000902 | 2021-12-10 | Indiana | Pennsylvania | 42063 | 11527 | 276 |
1997652 | 1997652 | 2021-12-09 | Indiana | Pennsylvania | 42063 | 11407 | 275 |
1994401 | 1994401 | 2021-12-08 | Indiana | Pennsylvania | 42063 | 11318 | 273 |
1991150 | 1991150 | 2021-12-07 | Indiana | Pennsylvania | 42063 | 11268 | 271 |
1987899 | 1987899 | 2021-12-06 | Indiana | Pennsylvania | 42063 | 11212 | 270 |
1984649 | 1984649 | 2021-12-05 | Indiana | Pennsylvania | 42063 | 11196 | 270 |
1981399 | 1981399 | 2021-12-04 | Indiana | Pennsylvania | 42063 | 11186 | 270 |
1978149 | 1978149 | 2021-12-03 | Indiana | Pennsylvania | 42063 | 11120 | 269 |
1974899 | 1974899 | 2021-12-02 | Indiana | Pennsylvania | 42063 | 11024 | 269 |
1971650 | 1971650 | 2021-12-01 | Indiana | Pennsylvania | 42063 | 10952 | 268 |
1968400 | 1968400 | 2021-11-30 | Indiana | Pennsylvania | 42063 | 10867 | 265 |
1965149 | 1965149 | 2021-11-29 | Indiana | Pennsylvania | 42063 | 10810 | 263 |
1961897 | 1961897 | 2021-11-28 | Indiana | Pennsylvania | 42063 | 10750 | 263 |
1958646 | 1958646 | 2021-11-27 | Indiana | Pennsylvania | 42063 | 10707 | 263 |
1955395 | 1955395 | 2021-11-26 | Indiana | Pennsylvania | 42063 | 10653 | 263 |
1952144 | 1952144 | 2021-11-25 | Indiana | Pennsylvania | 42063 | 10580 | 263 |
1948893 | 1948893 | 2021-11-24 | Indiana | Pennsylvania | 42063 | 10527 | 261 |
1945642 | 1945642 | 2021-11-23 | Indiana | Pennsylvania | 42063 | 10437 | 258 |
1942391 | 1942391 | 2021-11-22 | Indiana | Pennsylvania | 42063 | 10383 | 257 |
1939141 | 1939141 | 2021-11-21 | Indiana | Pennsylvania | 42063 | 10303 | 257 |
1935891 | 1935891 | 2021-11-20 | Indiana | Pennsylvania | 42063 | 10239 | 257 |
1932641 | 1932641 | 2021-11-19 | Indiana | Pennsylvania | 42063 | 10171 | 256 |
1929390 | 1929390 | 2021-11-18 | Indiana | Pennsylvania | 42063 | 10108 | 253 |
1926140 | 1926140 | 2021-11-17 | Indiana | Pennsylvania | 42063 | 10048 | 251 |
1922890 | 1922890 | 2021-11-16 | Indiana | Pennsylvania | 42063 | 9984 | 250 |
1919641 | 1919641 | 2021-11-15 | Indiana | Pennsylvania | 42063 | 9914 | 248 |
1916391 | 1916391 | 2021-11-14 | Indiana | Pennsylvania | 42063 | 9883 | 248 |
1913141 | 1913141 | 2021-11-13 | Indiana | Pennsylvania | 42063 | 9815 | 246 |
1909891 | 1909891 | 2021-11-12 | Indiana | Pennsylvania | 42063 | 9600 | 243 |
1906642 | 1906642 | 2021-11-11 | Indiana | Pennsylvania | 42063 | 9569 | 243 |
1903393 | 1903393 | 2021-11-10 | Indiana | Pennsylvania | 42063 | 9517 | 242 |
1900143 | 1900143 | 2021-11-09 | Indiana | Pennsylvania | 42063 | 9467 | 240 |
1896893 | 1896893 | 2021-11-08 | Indiana | Pennsylvania | 42063 | 9439 | 238 |
1893643 | 1893643 | 2021-11-07 | Indiana | Pennsylvania | 42063 | 9401 | 238 |
1890393 | 1890393 | 2021-11-06 | Indiana | Pennsylvania | 42063 | 9357 | 238 |
1887143 | 1887143 | 2021-11-05 | Indiana | Pennsylvania | 42063 | 9316 | 236 |
1883893 | 1883893 | 2021-11-04 | Indiana | Pennsylvania | 42063 | 9281 | 234 |
1880644 | 1880644 | 2021-11-03 | Indiana | Pennsylvania | 42063 | 9222 | 234 |
1877395 | 1877395 | 2021-11-02 | Indiana | Pennsylvania | 42063 | 9183 | 231 |
1874146 | 1874146 | 2021-11-01 | Indiana | Pennsylvania | 42063 | 9135 | 228 |
1870897 | 1870897 | 2021-10-31 | Indiana | Pennsylvania | 42063 | 9135 | 228 |
1867648 | 1867648 | 2021-10-30 | Indiana | Pennsylvania | 42063 | 9104 | 228 |
1864399 | 1864399 | 2021-10-29 | Indiana | Pennsylvania | 42063 | 9053 | 226 |
1861150 | 1861150 | 2021-10-28 | Indiana | Pennsylvania | 42063 | 9024 | 224 |
1857901 | 1857901 | 2021-10-27 | Indiana | Pennsylvania | 42063 | 8973 | 224 |
1854652 | 1854652 | 2021-10-26 | Indiana | Pennsylvania | 42063 | 8916 | 224 |
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);