ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lackawanna" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176497 | 2176497 | 2022-02-02 | Lackawanna | Pennsylvania | 42069 | 40838 | 674 |
2173243 | 2173243 | 2022-02-01 | Lackawanna | Pennsylvania | 42069 | 40665 | 670 |
2169991 | 2169991 | 2022-01-31 | Lackawanna | Pennsylvania | 42069 | 40571 | 664 |
2166737 | 2166737 | 2022-01-30 | Lackawanna | Pennsylvania | 42069 | 40455 | 664 |
2163482 | 2163482 | 2022-01-29 | Lackawanna | Pennsylvania | 42069 | 40338 | 664 |
2160227 | 2160227 | 2022-01-28 | Lackawanna | Pennsylvania | 42069 | 40199 | 659 |
2156971 | 2156971 | 2022-01-27 | Lackawanna | Pennsylvania | 42069 | 39952 | 658 |
2153718 | 2153718 | 2022-01-26 | Lackawanna | Pennsylvania | 42069 | 39464 | 654 |
2150466 | 2150466 | 2022-01-25 | Lackawanna | Pennsylvania | 42069 | 39048 | 650 |
2147214 | 2147214 | 2022-01-24 | Lackawanna | Pennsylvania | 42069 | 38859 | 643 |
2143960 | 2143960 | 2022-01-23 | Lackawanna | Pennsylvania | 42069 | 38776 | 643 |
2140705 | 2140705 | 2022-01-22 | Lackawanna | Pennsylvania | 42069 | 38617 | 641 |
2137449 | 2137449 | 2022-01-21 | Lackawanna | Pennsylvania | 42069 | 38089 | 640 |
2134195 | 2134195 | 2022-01-20 | Lackawanna | Pennsylvania | 42069 | 37698 | 635 |
2130943 | 2130943 | 2022-01-19 | Lackawanna | Pennsylvania | 42069 | 37381 | 630 |
2127689 | 2127689 | 2022-01-18 | Lackawanna | Pennsylvania | 42069 | 37049 | 627 |
2124437 | 2124437 | 2022-01-17 | Lackawanna | Pennsylvania | 42069 | 36845 | 627 |
2121185 | 2121185 | 2022-01-16 | Lackawanna | Pennsylvania | 42069 | 36640 | 627 |
2117933 | 2117933 | 2022-01-15 | Lackawanna | Pennsylvania | 42069 | 36035 | 627 |
2114682 | 2114682 | 2022-01-14 | Lackawanna | Pennsylvania | 42069 | 35531 | 622 |
2111430 | 2111430 | 2022-01-13 | Lackawanna | Pennsylvania | 42069 | 35071 | 620 |
2108178 | 2108178 | 2022-01-12 | Lackawanna | Pennsylvania | 42069 | 34610 | 617 |
2104927 | 2104927 | 2022-01-11 | Lackawanna | Pennsylvania | 42069 | 34038 | 616 |
2101676 | 2101676 | 2022-01-10 | Lackawanna | Pennsylvania | 42069 | 33546 | 610 |
2098425 | 2098425 | 2022-01-09 | Lackawanna | Pennsylvania | 42069 | 33253 | 608 |
2095173 | 2095173 | 2022-01-08 | Lackawanna | Pennsylvania | 42069 | 32861 | 607 |
2091921 | 2091921 | 2022-01-07 | Lackawanna | Pennsylvania | 42069 | 32210 | 607 |
2088669 | 2088669 | 2022-01-06 | Lackawanna | Pennsylvania | 42069 | 31711 | 606 |
2085418 | 2085418 | 2022-01-05 | Lackawanna | Pennsylvania | 42069 | 31291 | 605 |
2082166 | 2082166 | 2022-01-04 | Lackawanna | Pennsylvania | 42069 | 30897 | 604 |
2078914 | 2078914 | 2022-01-03 | Lackawanna | Pennsylvania | 42069 | 30583 | 599 |
2075663 | 2075663 | 2022-01-02 | Lackawanna | Pennsylvania | 42069 | 30356 | 599 |
2072412 | 2072412 | 2022-01-01 | Lackawanna | Pennsylvania | 42069 | 30022 | 599 |
2069161 | 2069161 | 2021-12-31 | Lackawanna | Pennsylvania | 42069 | 29690 | 598 |
2065910 | 2065910 | 2021-12-30 | Lackawanna | Pennsylvania | 42069 | 29398 | 596 |
2062660 | 2062660 | 2021-12-29 | Lackawanna | Pennsylvania | 42069 | 29093 | 592 |
2059410 | 2059410 | 2021-12-28 | Lackawanna | Pennsylvania | 42069 | 28815 | 587 |
2056161 | 2056161 | 2021-12-27 | Lackawanna | Pennsylvania | 42069 | 28649 | 586 |
2052912 | 2052912 | 2021-12-26 | Lackawanna | Pennsylvania | 42069 | 28591 | 586 |
2049662 | 2049662 | 2021-12-25 | Lackawanna | Pennsylvania | 42069 | 28514 | 586 |
2046412 | 2046412 | 2021-12-24 | Lackawanna | Pennsylvania | 42069 | 28361 | 586 |
2043162 | 2043162 | 2021-12-23 | Lackawanna | Pennsylvania | 42069 | 28205 | 585 |
2039913 | 2039913 | 2021-12-22 | Lackawanna | Pennsylvania | 42069 | 28111 | 583 |
2036663 | 2036663 | 2021-12-21 | Lackawanna | Pennsylvania | 42069 | 27959 | 578 |
2033413 | 2033413 | 2021-12-20 | Lackawanna | Pennsylvania | 42069 | 27826 | 575 |
2030163 | 2030163 | 2021-12-19 | Lackawanna | Pennsylvania | 42069 | 27781 | 575 |
2026912 | 2026912 | 2021-12-18 | Lackawanna | Pennsylvania | 42069 | 27665 | 575 |
2023661 | 2023661 | 2021-12-17 | Lackawanna | Pennsylvania | 42069 | 27529 | 572 |
2020410 | 2020410 | 2021-12-16 | Lackawanna | Pennsylvania | 42069 | 27395 | 571 |
2017159 | 2017159 | 2021-12-15 | Lackawanna | Pennsylvania | 42069 | 27268 | 570 |
2013909 | 2013909 | 2021-12-14 | Lackawanna | Pennsylvania | 42069 | 27095 | 568 |
2010658 | 2010658 | 2021-12-13 | Lackawanna | Pennsylvania | 42069 | 26962 | 567 |
2007407 | 2007407 | 2021-12-12 | Lackawanna | Pennsylvania | 42069 | 26864 | 567 |
2004156 | 2004156 | 2021-12-11 | Lackawanna | Pennsylvania | 42069 | 26762 | 567 |
2000905 | 2000905 | 2021-12-10 | Lackawanna | Pennsylvania | 42069 | 26552 | 565 |
1997655 | 1997655 | 2021-12-09 | Lackawanna | Pennsylvania | 42069 | 26393 | 561 |
1994404 | 1994404 | 2021-12-08 | Lackawanna | Pennsylvania | 42069 | 26288 | 560 |
1991153 | 1991153 | 2021-12-07 | Lackawanna | Pennsylvania | 42069 | 26157 | 557 |
1987902 | 1987902 | 2021-12-06 | Lackawanna | Pennsylvania | 42069 | 26062 | 554 |
1984652 | 1984652 | 2021-12-05 | Lackawanna | Pennsylvania | 42069 | 26016 | 553 |
1981402 | 1981402 | 2021-12-04 | Lackawanna | Pennsylvania | 42069 | 25946 | 552 |
1978152 | 1978152 | 2021-12-03 | Lackawanna | Pennsylvania | 42069 | 25836 | 551 |
1974902 | 1974902 | 2021-12-02 | Lackawanna | Pennsylvania | 42069 | 25733 | 549 |
1971653 | 1971653 | 2021-12-01 | Lackawanna | Pennsylvania | 42069 | 25592 | 549 |
1968403 | 1968403 | 2021-11-30 | Lackawanna | Pennsylvania | 42069 | 25477 | 547 |
1965152 | 1965152 | 2021-11-29 | Lackawanna | Pennsylvania | 42069 | 25358 | 545 |
1961900 | 1961900 | 2021-11-28 | Lackawanna | Pennsylvania | 42069 | 25284 | 544 |
1958649 | 1958649 | 2021-11-27 | Lackawanna | Pennsylvania | 42069 | 25223 | 544 |
1955398 | 1955398 | 2021-11-26 | Lackawanna | Pennsylvania | 42069 | 25143 | 544 |
1952147 | 1952147 | 2021-11-25 | Lackawanna | Pennsylvania | 42069 | 25056 | 544 |
1948896 | 1948896 | 2021-11-24 | Lackawanna | Pennsylvania | 42069 | 24908 | 542 |
1945645 | 1945645 | 2021-11-23 | Lackawanna | Pennsylvania | 42069 | 24791 | 539 |
1942394 | 1942394 | 2021-11-22 | Lackawanna | Pennsylvania | 42069 | 24682 | 537 |
1939144 | 1939144 | 2021-11-21 | Lackawanna | Pennsylvania | 42069 | 24629 | 536 |
1935894 | 1935894 | 2021-11-20 | Lackawanna | Pennsylvania | 42069 | 24544 | 536 |
1932644 | 1932644 | 2021-11-19 | Lackawanna | Pennsylvania | 42069 | 24458 | 534 |
1929393 | 1929393 | 2021-11-18 | Lackawanna | Pennsylvania | 42069 | 24359 | 531 |
1926143 | 1926143 | 2021-11-17 | Lackawanna | Pennsylvania | 42069 | 24236 | 531 |
1922893 | 1922893 | 2021-11-16 | Lackawanna | Pennsylvania | 42069 | 24134 | 527 |
1919644 | 1919644 | 2021-11-15 | Lackawanna | Pennsylvania | 42069 | 24038 | 527 |
1916394 | 1916394 | 2021-11-14 | Lackawanna | Pennsylvania | 42069 | 23996 | 527 |
1913144 | 1913144 | 2021-11-13 | Lackawanna | Pennsylvania | 42069 | 23930 | 526 |
1909894 | 1909894 | 2021-11-12 | Lackawanna | Pennsylvania | 42069 | 23604 | 526 |
1906645 | 1906645 | 2021-11-11 | Lackawanna | Pennsylvania | 42069 | 23506 | 525 |
1903396 | 1903396 | 2021-11-10 | Lackawanna | Pennsylvania | 42069 | 23428 | 525 |
1900146 | 1900146 | 2021-11-09 | Lackawanna | Pennsylvania | 42069 | 23339 | 523 |
1896896 | 1896896 | 2021-11-08 | Lackawanna | Pennsylvania | 42069 | 23264 | 521 |
1893646 | 1893646 | 2021-11-07 | Lackawanna | Pennsylvania | 42069 | 23221 | 521 |
1890396 | 1890396 | 2021-11-06 | Lackawanna | Pennsylvania | 42069 | 23165 | 521 |
1887146 | 1887146 | 2021-11-05 | Lackawanna | Pennsylvania | 42069 | 23106 | 520 |
1883896 | 1883896 | 2021-11-04 | Lackawanna | Pennsylvania | 42069 | 23034 | 520 |
1880647 | 1880647 | 2021-11-03 | Lackawanna | Pennsylvania | 42069 | 22979 | 520 |
1877398 | 1877398 | 2021-11-02 | Lackawanna | Pennsylvania | 42069 | 22912 | 517 |
1874149 | 1874149 | 2021-11-01 | Lackawanna | Pennsylvania | 42069 | 22841 | 517 |
1870900 | 1870900 | 2021-10-31 | Lackawanna | Pennsylvania | 42069 | 22841 | 517 |
1867651 | 1867651 | 2021-10-30 | Lackawanna | Pennsylvania | 42069 | 22787 | 517 |
1864402 | 1864402 | 2021-10-29 | Lackawanna | Pennsylvania | 42069 | 22737 | 517 |
1861153 | 1861153 | 2021-10-28 | Lackawanna | Pennsylvania | 42069 | 22685 | 517 |
1857904 | 1857904 | 2021-10-27 | Lackawanna | Pennsylvania | 42069 | 22644 | 517 |
1854655 | 1854655 | 2021-10-26 | Lackawanna | Pennsylvania | 42069 | 22604 | 516 |
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);