ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42055 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176490 | 2176490 | 2022-02-02 | Franklin | Pennsylvania | 42055 | 38837 | 627 |
2173236 | 2173236 | 2022-02-01 | Franklin | Pennsylvania | 42055 | 38730 | 620 |
2169984 | 2169984 | 2022-01-31 | Franklin | Pennsylvania | 42055 | 38474 | 617 |
2166730 | 2166730 | 2022-01-30 | Franklin | Pennsylvania | 42055 | 38400 | 617 |
2163475 | 2163475 | 2022-01-29 | Franklin | Pennsylvania | 42055 | 38227 | 617 |
2160220 | 2160220 | 2022-01-28 | Franklin | Pennsylvania | 42055 | 38051 | 612 |
2156964 | 2156964 | 2022-01-27 | Franklin | Pennsylvania | 42055 | 37826 | 610 |
2153711 | 2153711 | 2022-01-26 | Franklin | Pennsylvania | 42055 | 37572 | 608 |
2150459 | 2150459 | 2022-01-25 | Franklin | Pennsylvania | 42055 | 37407 | 603 |
2147207 | 2147207 | 2022-01-24 | Franklin | Pennsylvania | 42055 | 37020 | 602 |
2143953 | 2143953 | 2022-01-23 | Franklin | Pennsylvania | 42055 | 36871 | 602 |
2140698 | 2140698 | 2022-01-22 | Franklin | Pennsylvania | 42055 | 36692 | 602 |
2137442 | 2137442 | 2022-01-21 | Franklin | Pennsylvania | 42055 | 36493 | 601 |
2134188 | 2134188 | 2022-01-20 | Franklin | Pennsylvania | 42055 | 36137 | 599 |
2130936 | 2130936 | 2022-01-19 | Franklin | Pennsylvania | 42055 | 35907 | 592 |
2127682 | 2127682 | 2022-01-18 | Franklin | Pennsylvania | 42055 | 35535 | 590 |
2124430 | 2124430 | 2022-01-17 | Franklin | Pennsylvania | 42055 | 35232 | 589 |
2121178 | 2121178 | 2022-01-16 | Franklin | Pennsylvania | 42055 | 34980 | 589 |
2117926 | 2117926 | 2022-01-15 | Franklin | Pennsylvania | 42055 | 34399 | 589 |
2114675 | 2114675 | 2022-01-14 | Franklin | Pennsylvania | 42055 | 34095 | 588 |
2111423 | 2111423 | 2022-01-13 | Franklin | Pennsylvania | 42055 | 33806 | 585 |
2108171 | 2108171 | 2022-01-12 | Franklin | Pennsylvania | 42055 | 33432 | 582 |
2104920 | 2104920 | 2022-01-11 | Franklin | Pennsylvania | 42055 | 33151 | 577 |
2101669 | 2101669 | 2022-01-10 | Franklin | Pennsylvania | 42055 | 32689 | 572 |
2098418 | 2098418 | 2022-01-09 | Franklin | Pennsylvania | 42055 | 32207 | 571 |
2095166 | 2095166 | 2022-01-08 | Franklin | Pennsylvania | 42055 | 31987 | 571 |
2091914 | 2091914 | 2022-01-07 | Franklin | Pennsylvania | 42055 | 31535 | 568 |
2088662 | 2088662 | 2022-01-06 | Franklin | Pennsylvania | 42055 | 31259 | 567 |
2085411 | 2085411 | 2022-01-05 | Franklin | Pennsylvania | 42055 | 31041 | 554 |
2082159 | 2082159 | 2022-01-04 | Franklin | Pennsylvania | 42055 | 30667 | 552 |
2078907 | 2078907 | 2022-01-03 | Franklin | Pennsylvania | 42055 | 30240 | 550 |
2075656 | 2075656 | 2022-01-02 | Franklin | Pennsylvania | 42055 | 30133 | 550 |
2072405 | 2072405 | 2022-01-01 | Franklin | Pennsylvania | 42055 | 29845 | 550 |
2069154 | 2069154 | 2021-12-31 | Franklin | Pennsylvania | 42055 | 29682 | 550 |
2065903 | 2065903 | 2021-12-30 | Franklin | Pennsylvania | 42055 | 29444 | 549 |
2062653 | 2062653 | 2021-12-29 | Franklin | Pennsylvania | 42055 | 29246 | 543 |
2059403 | 2059403 | 2021-12-28 | Franklin | Pennsylvania | 42055 | 29085 | 539 |
2056154 | 2056154 | 2021-12-27 | Franklin | Pennsylvania | 42055 | 28865 | 535 |
2052905 | 2052905 | 2021-12-26 | Franklin | Pennsylvania | 42055 | 28762 | 535 |
2049655 | 2049655 | 2021-12-25 | Franklin | Pennsylvania | 42055 | 28674 | 535 |
2046405 | 2046405 | 2021-12-24 | Franklin | Pennsylvania | 42055 | 28513 | 535 |
2043155 | 2043155 | 2021-12-23 | Franklin | Pennsylvania | 42055 | 28053 | 535 |
2039906 | 2039906 | 2021-12-22 | Franklin | Pennsylvania | 42055 | 27620 | 528 |
2036656 | 2036656 | 2021-12-21 | Franklin | Pennsylvania | 42055 | 26854 | 526 |
2033406 | 2033406 | 2021-12-20 | Franklin | Pennsylvania | 42055 | 26441 | 523 |
2030156 | 2030156 | 2021-12-19 | Franklin | Pennsylvania | 42055 | 26349 | 522 |
2026905 | 2026905 | 2021-12-18 | Franklin | Pennsylvania | 42055 | 26239 | 521 |
2023654 | 2023654 | 2021-12-17 | Franklin | Pennsylvania | 42055 | 26087 | 516 |
2020403 | 2020403 | 2021-12-16 | Franklin | Pennsylvania | 42055 | 25897 | 516 |
2017152 | 2017152 | 2021-12-15 | Franklin | Pennsylvania | 42055 | 25769 | 515 |
2013902 | 2013902 | 2021-12-14 | Franklin | Pennsylvania | 42055 | 25691 | 511 |
2010651 | 2010651 | 2021-12-13 | Franklin | Pennsylvania | 42055 | 25486 | 511 |
2007400 | 2007400 | 2021-12-12 | Franklin | Pennsylvania | 42055 | 25441 | 511 |
2004149 | 2004149 | 2021-12-11 | Franklin | Pennsylvania | 42055 | 25342 | 510 |
2000898 | 2000898 | 2021-12-10 | Franklin | Pennsylvania | 42055 | 25226 | 509 |
1997648 | 1997648 | 2021-12-09 | Franklin | Pennsylvania | 42055 | 25139 | 506 |
1994397 | 1994397 | 2021-12-08 | Franklin | Pennsylvania | 42055 | 25035 | 503 |
1991146 | 1991146 | 2021-12-07 | Franklin | Pennsylvania | 42055 | 24908 | 503 |
1987895 | 1987895 | 2021-12-06 | Franklin | Pennsylvania | 42055 | 24666 | 503 |
1984645 | 1984645 | 2021-12-05 | Franklin | Pennsylvania | 42055 | 24609 | 502 |
1981395 | 1981395 | 2021-12-04 | Franklin | Pennsylvania | 42055 | 24536 | 501 |
1978145 | 1978145 | 2021-12-03 | Franklin | Pennsylvania | 42055 | 24425 | 498 |
1974895 | 1974895 | 2021-12-02 | Franklin | Pennsylvania | 42055 | 24318 | 497 |
1971646 | 1971646 | 2021-12-01 | Franklin | Pennsylvania | 42055 | 24197 | 496 |
1968396 | 1968396 | 2021-11-30 | Franklin | Pennsylvania | 42055 | 24077 | 493 |
1965145 | 1965145 | 2021-11-29 | Franklin | Pennsylvania | 42055 | 23901 | 491 |
1961893 | 1961893 | 2021-11-28 | Franklin | Pennsylvania | 42055 | 23844 | 491 |
1958642 | 1958642 | 2021-11-27 | Franklin | Pennsylvania | 42055 | 23806 | 490 |
1955391 | 1955391 | 2021-11-26 | Franklin | Pennsylvania | 42055 | 23757 | 490 |
1952140 | 1952140 | 2021-11-25 | Franklin | Pennsylvania | 42055 | 23702 | 490 |
1948889 | 1948889 | 2021-11-24 | Franklin | Pennsylvania | 42055 | 23626 | 485 |
1945638 | 1945638 | 2021-11-23 | Franklin | Pennsylvania | 42055 | 23537 | 483 |
1942387 | 1942387 | 2021-11-22 | Franklin | Pennsylvania | 42055 | 23411 | 482 |
1939137 | 1939137 | 2021-11-21 | Franklin | Pennsylvania | 42055 | 23362 | 482 |
1935887 | 1935887 | 2021-11-20 | Franklin | Pennsylvania | 42055 | 23327 | 482 |
1932637 | 1932637 | 2021-11-19 | Franklin | Pennsylvania | 42055 | 23244 | 481 |
1929386 | 1929386 | 2021-11-18 | Franklin | Pennsylvania | 42055 | 23168 | 480 |
1926136 | 1926136 | 2021-11-17 | Franklin | Pennsylvania | 42055 | 23110 | 480 |
1922886 | 1922886 | 2021-11-16 | Franklin | Pennsylvania | 42055 | 23049 | 477 |
1919637 | 1919637 | 2021-11-15 | Franklin | Pennsylvania | 42055 | 22916 | 476 |
1916387 | 1916387 | 2021-11-14 | Franklin | Pennsylvania | 42055 | 22884 | 476 |
1913137 | 1913137 | 2021-11-13 | Franklin | Pennsylvania | 42055 | 22831 | 476 |
1909887 | 1909887 | 2021-11-12 | Franklin | Pennsylvania | 42055 | 22532 | 475 |
1906638 | 1906638 | 2021-11-11 | Franklin | Pennsylvania | 42055 | 22463 | 475 |
1903389 | 1903389 | 2021-11-10 | Franklin | Pennsylvania | 42055 | 22412 | 474 |
1900139 | 1900139 | 2021-11-09 | Franklin | Pennsylvania | 42055 | 22367 | 468 |
1896889 | 1896889 | 2021-11-08 | Franklin | Pennsylvania | 42055 | 22263 | 467 |
1893639 | 1893639 | 2021-11-07 | Franklin | Pennsylvania | 42055 | 22236 | 467 |
1890389 | 1890389 | 2021-11-06 | Franklin | Pennsylvania | 42055 | 22207 | 467 |
1887139 | 1887139 | 2021-11-05 | Franklin | Pennsylvania | 42055 | 22170 | 467 |
1883889 | 1883889 | 2021-11-04 | Franklin | Pennsylvania | 42055 | 22117 | 465 |
1880640 | 1880640 | 2021-11-03 | Franklin | Pennsylvania | 42055 | 22054 | 465 |
1877391 | 1877391 | 2021-11-02 | Franklin | Pennsylvania | 42055 | 21998 | 461 |
1874142 | 1874142 | 2021-11-01 | Franklin | Pennsylvania | 42055 | 21904 | 460 |
1870893 | 1870893 | 2021-10-31 | Franklin | Pennsylvania | 42055 | 21904 | 460 |
1867644 | 1867644 | 2021-10-30 | Franklin | Pennsylvania | 42055 | 21873 | 460 |
1864395 | 1864395 | 2021-10-29 | Franklin | Pennsylvania | 42055 | 21816 | 459 |
1861146 | 1861146 | 2021-10-28 | Franklin | Pennsylvania | 42055 | 21755 | 457 |
1857897 | 1857897 | 2021-10-27 | Franklin | Pennsylvania | 42055 | 21689 | 455 |
1854648 | 1854648 | 2021-10-26 | Franklin | Pennsylvania | 42055 | 21623 | 451 |
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);