ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 42089 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176507 | 2176507 | 2022-02-02 | Monroe | Pennsylvania | 42089 | 35779 | 474 |
2173253 | 2173253 | 2022-02-01 | Monroe | Pennsylvania | 42089 | 35692 | 471 |
2170001 | 2170001 | 2022-01-31 | Monroe | Pennsylvania | 42089 | 35643 | 468 |
2166747 | 2166747 | 2022-01-30 | Monroe | Pennsylvania | 42089 | 35583 | 468 |
2163492 | 2163492 | 2022-01-29 | Monroe | Pennsylvania | 42089 | 35503 | 468 |
2160237 | 2160237 | 2022-01-28 | Monroe | Pennsylvania | 42089 | 35428 | 467 |
2156981 | 2156981 | 2022-01-27 | Monroe | Pennsylvania | 42089 | 35226 | 467 |
2153728 | 2153728 | 2022-01-26 | Monroe | Pennsylvania | 42089 | 34951 | 461 |
2150476 | 2150476 | 2022-01-25 | Monroe | Pennsylvania | 42089 | 34804 | 456 |
2147224 | 2147224 | 2022-01-24 | Monroe | Pennsylvania | 42089 | 34714 | 456 |
2143970 | 2143970 | 2022-01-23 | Monroe | Pennsylvania | 42089 | 34643 | 456 |
2140715 | 2140715 | 2022-01-22 | Monroe | Pennsylvania | 42089 | 34504 | 456 |
2137459 | 2137459 | 2022-01-21 | Monroe | Pennsylvania | 42089 | 34266 | 453 |
2134205 | 2134205 | 2022-01-20 | Monroe | Pennsylvania | 42089 | 34098 | 448 |
2130953 | 2130953 | 2022-01-19 | Monroe | Pennsylvania | 42089 | 33929 | 446 |
2127699 | 2127699 | 2022-01-18 | Monroe | Pennsylvania | 42089 | 33831 | 446 |
2124447 | 2124447 | 2022-01-17 | Monroe | Pennsylvania | 42089 | 33712 | 445 |
2121195 | 2121195 | 2022-01-16 | Monroe | Pennsylvania | 42089 | 33540 | 445 |
2117943 | 2117943 | 2022-01-15 | Monroe | Pennsylvania | 42089 | 32835 | 445 |
2114692 | 2114692 | 2022-01-14 | Monroe | Pennsylvania | 42089 | 32536 | 442 |
2111440 | 2111440 | 2022-01-13 | Monroe | Pennsylvania | 42089 | 32165 | 437 |
2108188 | 2108188 | 2022-01-12 | Monroe | Pennsylvania | 42089 | 31747 | 436 |
2104937 | 2104937 | 2022-01-11 | Monroe | Pennsylvania | 42089 | 31247 | 431 |
2101686 | 2101686 | 2022-01-10 | Monroe | Pennsylvania | 42089 | 30697 | 428 |
2098435 | 2098435 | 2022-01-09 | Monroe | Pennsylvania | 42089 | 30060 | 428 |
2095183 | 2095183 | 2022-01-08 | Monroe | Pennsylvania | 42089 | 29517 | 428 |
2091931 | 2091931 | 2022-01-07 | Monroe | Pennsylvania | 42089 | 28899 | 427 |
2088679 | 2088679 | 2022-01-06 | Monroe | Pennsylvania | 42089 | 28355 | 425 |
2085428 | 2085428 | 2022-01-05 | Monroe | Pennsylvania | 42089 | 27954 | 420 |
2082176 | 2082176 | 2022-01-04 | Monroe | Pennsylvania | 42089 | 27601 | 419 |
2078924 | 2078924 | 2022-01-03 | Monroe | Pennsylvania | 42089 | 27328 | 417 |
2075673 | 2075673 | 2022-01-02 | Monroe | Pennsylvania | 42089 | 26825 | 417 |
2072422 | 2072422 | 2022-01-01 | Monroe | Pennsylvania | 42089 | 26409 | 417 |
2069171 | 2069171 | 2021-12-31 | Monroe | Pennsylvania | 42089 | 26142 | 417 |
2065920 | 2065920 | 2021-12-30 | Monroe | Pennsylvania | 42089 | 25739 | 416 |
2062670 | 2062670 | 2021-12-29 | Monroe | Pennsylvania | 42089 | 25537 | 415 |
2059420 | 2059420 | 2021-12-28 | Monroe | Pennsylvania | 42089 | 25322 | 410 |
2056171 | 2056171 | 2021-12-27 | Monroe | Pennsylvania | 42089 | 25125 | 407 |
2052922 | 2052922 | 2021-12-26 | Monroe | Pennsylvania | 42089 | 24992 | 405 |
2049672 | 2049672 | 2021-12-25 | Monroe | Pennsylvania | 42089 | 24774 | 405 |
2046422 | 2046422 | 2021-12-24 | Monroe | Pennsylvania | 42089 | 24624 | 405 |
2043172 | 2043172 | 2021-12-23 | Monroe | Pennsylvania | 42089 | 24456 | 404 |
2039923 | 2039923 | 2021-12-22 | Monroe | Pennsylvania | 42089 | 24287 | 401 |
2036673 | 2036673 | 2021-12-21 | Monroe | Pennsylvania | 42089 | 24198 | 401 |
2033423 | 2033423 | 2021-12-20 | Monroe | Pennsylvania | 42089 | 24055 | 400 |
2030173 | 2030173 | 2021-12-19 | Monroe | Pennsylvania | 42089 | 23979 | 400 |
2026922 | 2026922 | 2021-12-18 | Monroe | Pennsylvania | 42089 | 23877 | 400 |
2023671 | 2023671 | 2021-12-17 | Monroe | Pennsylvania | 42089 | 23733 | 397 |
2020420 | 2020420 | 2021-12-16 | Monroe | Pennsylvania | 42089 | 23658 | 397 |
2017169 | 2017169 | 2021-12-15 | Monroe | Pennsylvania | 42089 | 23511 | 397 |
2013919 | 2013919 | 2021-12-14 | Monroe | Pennsylvania | 42089 | 23447 | 396 |
2010668 | 2010668 | 2021-12-13 | Monroe | Pennsylvania | 42089 | 23312 | 396 |
2007417 | 2007417 | 2021-12-12 | Monroe | Pennsylvania | 42089 | 23219 | 396 |
2004166 | 2004166 | 2021-12-11 | Monroe | Pennsylvania | 42089 | 23091 | 396 |
2000915 | 2000915 | 2021-12-10 | Monroe | Pennsylvania | 42089 | 22888 | 394 |
1997665 | 1997665 | 2021-12-09 | Monroe | Pennsylvania | 42089 | 22719 | 393 |
1994414 | 1994414 | 2021-12-08 | Monroe | Pennsylvania | 42089 | 22624 | 392 |
1991163 | 1991163 | 2021-12-07 | Monroe | Pennsylvania | 42089 | 22567 | 390 |
1987912 | 1987912 | 2021-12-06 | Monroe | Pennsylvania | 42089 | 22449 | 388 |
1984662 | 1984662 | 2021-12-05 | Monroe | Pennsylvania | 42089 | 22388 | 386 |
1981412 | 1981412 | 2021-12-04 | Monroe | Pennsylvania | 42089 | 22295 | 386 |
1978162 | 1978162 | 2021-12-03 | Monroe | Pennsylvania | 42089 | 22111 | 383 |
1974912 | 1974912 | 2021-12-02 | Monroe | Pennsylvania | 42089 | 22023 | 383 |
1971663 | 1971663 | 2021-12-01 | Monroe | Pennsylvania | 42089 | 21879 | 381 |
1968413 | 1968413 | 2021-11-30 | Monroe | Pennsylvania | 42089 | 21810 | 380 |
1965162 | 1965162 | 2021-11-29 | Monroe | Pennsylvania | 42089 | 21735 | 379 |
1961910 | 1961910 | 2021-11-28 | Monroe | Pennsylvania | 42089 | 21660 | 378 |
1958659 | 1958659 | 2021-11-27 | Monroe | Pennsylvania | 42089 | 21586 | 378 |
1955408 | 1955408 | 2021-11-26 | Monroe | Pennsylvania | 42089 | 21514 | 378 |
1952157 | 1952157 | 2021-11-25 | Monroe | Pennsylvania | 42089 | 21430 | 378 |
1948906 | 1948906 | 2021-11-24 | Monroe | Pennsylvania | 42089 | 21361 | 378 |
1945655 | 1945655 | 2021-11-23 | Monroe | Pennsylvania | 42089 | 21286 | 377 |
1942404 | 1942404 | 2021-11-22 | Monroe | Pennsylvania | 42089 | 21161 | 376 |
1939154 | 1939154 | 2021-11-21 | Monroe | Pennsylvania | 42089 | 21106 | 376 |
1935904 | 1935904 | 2021-11-20 | Monroe | Pennsylvania | 42089 | 21052 | 376 |
1932654 | 1932654 | 2021-11-19 | Monroe | Pennsylvania | 42089 | 20968 | 376 |
1929403 | 1929403 | 2021-11-18 | Monroe | Pennsylvania | 42089 | 20889 | 375 |
1926153 | 1926153 | 2021-11-17 | Monroe | Pennsylvania | 42089 | 20787 | 374 |
1922903 | 1922903 | 2021-11-16 | Monroe | Pennsylvania | 42089 | 20708 | 374 |
1919654 | 1919654 | 2021-11-15 | Monroe | Pennsylvania | 42089 | 20623 | 374 |
1916404 | 1916404 | 2021-11-14 | Monroe | Pennsylvania | 42089 | 20594 | 373 |
1913154 | 1913154 | 2021-11-13 | Monroe | Pennsylvania | 42089 | 20537 | 373 |
1909904 | 1909904 | 2021-11-12 | Monroe | Pennsylvania | 42089 | 20317 | 373 |
1906655 | 1906655 | 2021-11-11 | Monroe | Pennsylvania | 42089 | 20256 | 373 |
1903406 | 1903406 | 2021-11-10 | Monroe | Pennsylvania | 42089 | 20178 | 371 |
1900156 | 1900156 | 2021-11-09 | Monroe | Pennsylvania | 42089 | 20131 | 369 |
1896906 | 1896906 | 2021-11-08 | Monroe | Pennsylvania | 42089 | 20073 | 369 |
1893656 | 1893656 | 2021-11-07 | Monroe | Pennsylvania | 42089 | 20039 | 369 |
1890406 | 1890406 | 2021-11-06 | Monroe | Pennsylvania | 42089 | 20009 | 369 |
1887156 | 1887156 | 2021-11-05 | Monroe | Pennsylvania | 42089 | 19960 | 369 |
1883906 | 1883906 | 2021-11-04 | Monroe | Pennsylvania | 42089 | 19896 | 368 |
1880657 | 1880657 | 2021-11-03 | Monroe | Pennsylvania | 42089 | 19836 | 368 |
1877408 | 1877408 | 2021-11-02 | Monroe | Pennsylvania | 42089 | 19796 | 366 |
1874159 | 1874159 | 2021-11-01 | Monroe | Pennsylvania | 42089 | 19709 | 366 |
1870910 | 1870910 | 2021-10-31 | Monroe | Pennsylvania | 42089 | 19709 | 366 |
1867661 | 1867661 | 2021-10-30 | Monroe | Pennsylvania | 42089 | 19680 | 363 |
1864412 | 1864412 | 2021-10-29 | Monroe | Pennsylvania | 42089 | 19644 | 363 |
1861163 | 1861163 | 2021-10-28 | Monroe | Pennsylvania | 42089 | 19602 | 363 |
1857914 | 1857914 | 2021-10-27 | Monroe | Pennsylvania | 42089 | 19556 | 363 |
1854665 | 1854665 | 2021-10-26 | Monroe | Pennsylvania | 42089 | 19525 | 362 |
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);