ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Beaver" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176466 | 2176466 | 2022-02-02 | Beaver | Pennsylvania | 42007 | 38054 | 676 |
2173212 | 2173212 | 2022-02-01 | Beaver | Pennsylvania | 42007 | 37991 | 673 |
2169960 | 2169960 | 2022-01-31 | Beaver | Pennsylvania | 42007 | 37867 | 673 |
2166706 | 2166706 | 2022-01-30 | Beaver | Pennsylvania | 42007 | 37777 | 673 |
2163451 | 2163451 | 2022-01-29 | Beaver | Pennsylvania | 42007 | 37680 | 673 |
2160196 | 2160196 | 2022-01-28 | Beaver | Pennsylvania | 42007 | 37438 | 668 |
2156940 | 2156940 | 2022-01-27 | Beaver | Pennsylvania | 42007 | 37069 | 667 |
2153687 | 2153687 | 2022-01-26 | Beaver | Pennsylvania | 42007 | 36741 | 663 |
2150435 | 2150435 | 2022-01-25 | Beaver | Pennsylvania | 42007 | 36506 | 660 |
2147183 | 2147183 | 2022-01-24 | Beaver | Pennsylvania | 42007 | 36223 | 653 |
2143929 | 2143929 | 2022-01-23 | Beaver | Pennsylvania | 42007 | 36006 | 653 |
2140674 | 2140674 | 2022-01-22 | Beaver | Pennsylvania | 42007 | 35864 | 653 |
2137418 | 2137418 | 2022-01-21 | Beaver | Pennsylvania | 42007 | 35529 | 648 |
2134164 | 2134164 | 2022-01-20 | Beaver | Pennsylvania | 42007 | 35171 | 648 |
2130912 | 2130912 | 2022-01-19 | Beaver | Pennsylvania | 42007 | 35004 | 645 |
2127658 | 2127658 | 2022-01-18 | Beaver | Pennsylvania | 42007 | 34731 | 643 |
2124406 | 2124406 | 2022-01-17 | Beaver | Pennsylvania | 42007 | 34507 | 643 |
2121154 | 2121154 | 2022-01-16 | Beaver | Pennsylvania | 42007 | 34321 | 643 |
2117902 | 2117902 | 2022-01-15 | Beaver | Pennsylvania | 42007 | 33870 | 642 |
2114651 | 2114651 | 2022-01-14 | Beaver | Pennsylvania | 42007 | 33427 | 637 |
2111399 | 2111399 | 2022-01-13 | Beaver | Pennsylvania | 42007 | 33093 | 630 |
2108147 | 2108147 | 2022-01-12 | Beaver | Pennsylvania | 42007 | 32699 | 629 |
2104896 | 2104896 | 2022-01-11 | Beaver | Pennsylvania | 42007 | 32289 | 626 |
2101645 | 2101645 | 2022-01-10 | Beaver | Pennsylvania | 42007 | 32049 | 624 |
2098394 | 2098394 | 2022-01-09 | Beaver | Pennsylvania | 42007 | 31822 | 624 |
2095142 | 2095142 | 2022-01-08 | Beaver | Pennsylvania | 42007 | 31616 | 624 |
2091890 | 2091890 | 2022-01-07 | Beaver | Pennsylvania | 42007 | 31355 | 622 |
2088638 | 2088638 | 2022-01-06 | Beaver | Pennsylvania | 42007 | 31030 | 617 |
2085387 | 2085387 | 2022-01-05 | Beaver | Pennsylvania | 42007 | 30740 | 612 |
2082135 | 2082135 | 2022-01-04 | Beaver | Pennsylvania | 42007 | 30410 | 609 |
2078883 | 2078883 | 2022-01-03 | Beaver | Pennsylvania | 42007 | 30165 | 606 |
2075632 | 2075632 | 2022-01-02 | Beaver | Pennsylvania | 42007 | 30017 | 604 |
2072381 | 2072381 | 2022-01-01 | Beaver | Pennsylvania | 42007 | 29879 | 604 |
2069130 | 2069130 | 2021-12-31 | Beaver | Pennsylvania | 42007 | 29633 | 604 |
2065879 | 2065879 | 2021-12-30 | Beaver | Pennsylvania | 42007 | 29515 | 602 |
2062629 | 2062629 | 2021-12-29 | Beaver | Pennsylvania | 42007 | 29358 | 598 |
2059379 | 2059379 | 2021-12-28 | Beaver | Pennsylvania | 42007 | 29215 | 593 |
2056130 | 2056130 | 2021-12-27 | Beaver | Pennsylvania | 42007 | 29135 | 589 |
2052881 | 2052881 | 2021-12-26 | Beaver | Pennsylvania | 42007 | 29110 | 588 |
2049631 | 2049631 | 2021-12-25 | Beaver | Pennsylvania | 42007 | 29078 | 588 |
2046381 | 2046381 | 2021-12-24 | Beaver | Pennsylvania | 42007 | 28977 | 588 |
2043131 | 2043131 | 2021-12-23 | Beaver | Pennsylvania | 42007 | 28847 | 585 |
2039882 | 2039882 | 2021-12-22 | Beaver | Pennsylvania | 42007 | 28751 | 582 |
2036632 | 2036632 | 2021-12-21 | Beaver | Pennsylvania | 42007 | 28691 | 580 |
2033382 | 2033382 | 2021-12-20 | Beaver | Pennsylvania | 42007 | 28558 | 572 |
2030132 | 2030132 | 2021-12-19 | Beaver | Pennsylvania | 42007 | 28516 | 572 |
2026881 | 2026881 | 2021-12-18 | Beaver | Pennsylvania | 42007 | 28450 | 571 |
2023630 | 2023630 | 2021-12-17 | Beaver | Pennsylvania | 42007 | 28327 | 568 |
2020379 | 2020379 | 2021-12-16 | Beaver | Pennsylvania | 42007 | 28199 | 566 |
2017128 | 2017128 | 2021-12-15 | Beaver | Pennsylvania | 42007 | 28073 | 564 |
2013878 | 2013878 | 2021-12-14 | Beaver | Pennsylvania | 42007 | 27995 | 555 |
2010627 | 2010627 | 2021-12-13 | Beaver | Pennsylvania | 42007 | 27860 | 554 |
2007376 | 2007376 | 2021-12-12 | Beaver | Pennsylvania | 42007 | 27776 | 554 |
2004125 | 2004125 | 2021-12-11 | Beaver | Pennsylvania | 42007 | 27699 | 553 |
2000874 | 2000874 | 2021-12-10 | Beaver | Pennsylvania | 42007 | 27516 | 553 |
1997624 | 1997624 | 2021-12-09 | Beaver | Pennsylvania | 42007 | 27285 | 547 |
1994373 | 1994373 | 2021-12-08 | Beaver | Pennsylvania | 42007 | 27092 | 546 |
1991122 | 1991122 | 2021-12-07 | Beaver | Pennsylvania | 42007 | 26932 | 545 |
1987871 | 1987871 | 2021-12-06 | Beaver | Pennsylvania | 42007 | 26775 | 539 |
1984621 | 1984621 | 2021-12-05 | Beaver | Pennsylvania | 42007 | 26739 | 537 |
1981371 | 1981371 | 2021-12-04 | Beaver | Pennsylvania | 42007 | 26679 | 535 |
1978121 | 1978121 | 2021-12-03 | Beaver | Pennsylvania | 42007 | 26582 | 530 |
1974871 | 1974871 | 2021-12-02 | Beaver | Pennsylvania | 42007 | 26350 | 526 |
1971622 | 1971622 | 2021-12-01 | Beaver | Pennsylvania | 42007 | 26172 | 523 |
1968372 | 1968372 | 2021-11-30 | Beaver | Pennsylvania | 42007 | 25860 | 521 |
1965121 | 1965121 | 2021-11-29 | Beaver | Pennsylvania | 42007 | 25798 | 519 |
1961869 | 1961869 | 2021-11-28 | Beaver | Pennsylvania | 42007 | 25631 | 519 |
1958618 | 1958618 | 2021-11-27 | Beaver | Pennsylvania | 42007 | 25599 | 519 |
1955367 | 1955367 | 2021-11-26 | Beaver | Pennsylvania | 42007 | 25486 | 519 |
1952116 | 1952116 | 2021-11-25 | Beaver | Pennsylvania | 42007 | 25348 | 519 |
1948865 | 1948865 | 2021-11-24 | Beaver | Pennsylvania | 42007 | 25234 | 519 |
1945614 | 1945614 | 2021-11-23 | Beaver | Pennsylvania | 42007 | 25068 | 513 |
1942363 | 1942363 | 2021-11-22 | Beaver | Pennsylvania | 42007 | 24941 | 513 |
1939113 | 1939113 | 2021-11-21 | Beaver | Pennsylvania | 42007 | 24844 | 513 |
1935863 | 1935863 | 2021-11-20 | Beaver | Pennsylvania | 42007 | 24788 | 512 |
1932613 | 1932613 | 2021-11-19 | Beaver | Pennsylvania | 42007 | 24628 | 508 |
1929362 | 1929362 | 2021-11-18 | Beaver | Pennsylvania | 42007 | 24413 | 504 |
1926112 | 1926112 | 2021-11-17 | Beaver | Pennsylvania | 42007 | 24289 | 504 |
1922862 | 1922862 | 2021-11-16 | Beaver | Pennsylvania | 42007 | 24187 | 498 |
1919613 | 1919613 | 2021-11-15 | Beaver | Pennsylvania | 42007 | 24074 | 497 |
1916363 | 1916363 | 2021-11-14 | Beaver | Pennsylvania | 42007 | 24011 | 497 |
1913113 | 1913113 | 2021-11-13 | Beaver | Pennsylvania | 42007 | 23963 | 496 |
1909863 | 1909863 | 2021-11-12 | Beaver | Pennsylvania | 42007 | 23659 | 493 |
1906614 | 1906614 | 2021-11-11 | Beaver | Pennsylvania | 42007 | 23454 | 492 |
1903365 | 1903365 | 2021-11-10 | Beaver | Pennsylvania | 42007 | 23332 | 492 |
1900115 | 1900115 | 2021-11-09 | Beaver | Pennsylvania | 42007 | 23231 | 483 |
1896865 | 1896865 | 2021-11-08 | Beaver | Pennsylvania | 42007 | 23147 | 481 |
1893615 | 1893615 | 2021-11-07 | Beaver | Pennsylvania | 42007 | 23070 | 481 |
1890365 | 1890365 | 2021-11-06 | Beaver | Pennsylvania | 42007 | 23014 | 481 |
1887115 | 1887115 | 2021-11-05 | Beaver | Pennsylvania | 42007 | 22921 | 481 |
1883865 | 1883865 | 2021-11-04 | Beaver | Pennsylvania | 42007 | 22817 | 481 |
1880616 | 1880616 | 2021-11-03 | Beaver | Pennsylvania | 42007 | 22710 | 481 |
1877367 | 1877367 | 2021-11-02 | Beaver | Pennsylvania | 42007 | 22606 | 478 |
1874118 | 1874118 | 2021-11-01 | Beaver | Pennsylvania | 42007 | 22440 | 475 |
1870869 | 1870869 | 2021-10-31 | Beaver | Pennsylvania | 42007 | 22440 | 475 |
1867620 | 1867620 | 2021-10-30 | Beaver | Pennsylvania | 42007 | 22381 | 474 |
1864371 | 1864371 | 2021-10-29 | Beaver | Pennsylvania | 42007 | 22294 | 474 |
1861122 | 1861122 | 2021-10-28 | Beaver | Pennsylvania | 42007 | 22181 | 472 |
1857873 | 1857873 | 2021-10-27 | Beaver | Pennsylvania | 42007 | 22133 | 472 |
1854624 | 1854624 | 2021-10-26 | Beaver | Pennsylvania | 42007 | 21991 | 469 |
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);