ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Erie" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176487 | 2176487 | 2022-02-02 | Erie | Pennsylvania | 42049 | 54788 | 688 |
2173233 | 2173233 | 2022-02-01 | Erie | Pennsylvania | 42049 | 54645 | 684 |
2169981 | 2169981 | 2022-01-31 | Erie | Pennsylvania | 42049 | 54571 | 681 |
2166727 | 2166727 | 2022-01-30 | Erie | Pennsylvania | 42049 | 54449 | 681 |
2163472 | 2163472 | 2022-01-29 | Erie | Pennsylvania | 42049 | 54282 | 681 |
2160217 | 2160217 | 2022-01-28 | Erie | Pennsylvania | 42049 | 54089 | 679 |
2156961 | 2156961 | 2022-01-27 | Erie | Pennsylvania | 42049 | 53752 | 678 |
2153708 | 2153708 | 2022-01-26 | Erie | Pennsylvania | 42049 | 53321 | 671 |
2150456 | 2150456 | 2022-01-25 | Erie | Pennsylvania | 42049 | 53037 | 670 |
2147204 | 2147204 | 2022-01-24 | Erie | Pennsylvania | 42049 | 52825 | 665 |
2143950 | 2143950 | 2022-01-23 | Erie | Pennsylvania | 42049 | 52604 | 665 |
2140695 | 2140695 | 2022-01-22 | Erie | Pennsylvania | 42049 | 52389 | 665 |
2137439 | 2137439 | 2022-01-21 | Erie | Pennsylvania | 42049 | 51957 | 664 |
2134185 | 2134185 | 2022-01-20 | Erie | Pennsylvania | 42049 | 51624 | 659 |
2130933 | 2130933 | 2022-01-19 | Erie | Pennsylvania | 42049 | 51351 | 654 |
2127679 | 2127679 | 2022-01-18 | Erie | Pennsylvania | 42049 | 51127 | 652 |
2124427 | 2124427 | 2022-01-17 | Erie | Pennsylvania | 42049 | 50903 | 652 |
2121175 | 2121175 | 2022-01-16 | Erie | Pennsylvania | 42049 | 50547 | 652 |
2117923 | 2117923 | 2022-01-15 | Erie | Pennsylvania | 42049 | 49897 | 652 |
2114672 | 2114672 | 2022-01-14 | Erie | Pennsylvania | 42049 | 49239 | 652 |
2111420 | 2111420 | 2022-01-13 | Erie | Pennsylvania | 42049 | 48534 | 651 |
2108168 | 2108168 | 2022-01-12 | Erie | Pennsylvania | 42049 | 47971 | 648 |
2104917 | 2104917 | 2022-01-11 | Erie | Pennsylvania | 42049 | 47501 | 646 |
2101666 | 2101666 | 2022-01-10 | Erie | Pennsylvania | 42049 | 47123 | 644 |
2098415 | 2098415 | 2022-01-09 | Erie | Pennsylvania | 42049 | 46560 | 644 |
2095163 | 2095163 | 2022-01-08 | Erie | Pennsylvania | 42049 | 45638 | 643 |
2091911 | 2091911 | 2022-01-07 | Erie | Pennsylvania | 42049 | 44798 | 643 |
2088659 | 2088659 | 2022-01-06 | Erie | Pennsylvania | 42049 | 44352 | 639 |
2085408 | 2085408 | 2022-01-05 | Erie | Pennsylvania | 42049 | 43747 | 637 |
2082156 | 2082156 | 2022-01-04 | Erie | Pennsylvania | 42049 | 43226 | 634 |
2078904 | 2078904 | 2022-01-03 | Erie | Pennsylvania | 42049 | 42857 | 631 |
2075653 | 2075653 | 2022-01-02 | Erie | Pennsylvania | 42049 | 42583 | 630 |
2072402 | 2072402 | 2022-01-01 | Erie | Pennsylvania | 42049 | 42106 | 630 |
2069151 | 2069151 | 2021-12-31 | Erie | Pennsylvania | 42049 | 41463 | 630 |
2065900 | 2065900 | 2021-12-30 | Erie | Pennsylvania | 42049 | 41026 | 627 |
2062650 | 2062650 | 2021-12-29 | Erie | Pennsylvania | 42049 | 40770 | 625 |
2059400 | 2059400 | 2021-12-28 | Erie | Pennsylvania | 42049 | 40603 | 621 |
2056151 | 2056151 | 2021-12-27 | Erie | Pennsylvania | 42049 | 40483 | 619 |
2052902 | 2052902 | 2021-12-26 | Erie | Pennsylvania | 42049 | 40401 | 618 |
2049652 | 2049652 | 2021-12-25 | Erie | Pennsylvania | 42049 | 40310 | 618 |
2046402 | 2046402 | 2021-12-24 | Erie | Pennsylvania | 42049 | 40103 | 618 |
2043152 | 2043152 | 2021-12-23 | Erie | Pennsylvania | 42049 | 39881 | 617 |
2039903 | 2039903 | 2021-12-22 | Erie | Pennsylvania | 42049 | 39678 | 613 |
2036653 | 2036653 | 2021-12-21 | Erie | Pennsylvania | 42049 | 39590 | 607 |
2033403 | 2033403 | 2021-12-20 | Erie | Pennsylvania | 42049 | 39480 | 599 |
2030153 | 2030153 | 2021-12-19 | Erie | Pennsylvania | 42049 | 39401 | 599 |
2026902 | 2026902 | 2021-12-18 | Erie | Pennsylvania | 42049 | 39306 | 599 |
2023651 | 2023651 | 2021-12-17 | Erie | Pennsylvania | 42049 | 39103 | 596 |
2020400 | 2020400 | 2021-12-16 | Erie | Pennsylvania | 42049 | 38955 | 596 |
2017149 | 2017149 | 2021-12-15 | Erie | Pennsylvania | 42049 | 38818 | 594 |
2013899 | 2013899 | 2021-12-14 | Erie | Pennsylvania | 42049 | 38694 | 584 |
2010648 | 2010648 | 2021-12-13 | Erie | Pennsylvania | 42049 | 38514 | 582 |
2007397 | 2007397 | 2021-12-12 | Erie | Pennsylvania | 42049 | 38396 | 582 |
2004146 | 2004146 | 2021-12-11 | Erie | Pennsylvania | 42049 | 38256 | 579 |
2000895 | 2000895 | 2021-12-10 | Erie | Pennsylvania | 42049 | 37963 | 575 |
1997645 | 1997645 | 2021-12-09 | Erie | Pennsylvania | 42049 | 37680 | 569 |
1994394 | 1994394 | 2021-12-08 | Erie | Pennsylvania | 42049 | 37491 | 566 |
1991143 | 1991143 | 2021-12-07 | Erie | Pennsylvania | 42049 | 37277 | 563 |
1987892 | 1987892 | 2021-12-06 | Erie | Pennsylvania | 42049 | 37138 | 561 |
1984642 | 1984642 | 2021-12-05 | Erie | Pennsylvania | 42049 | 36966 | 560 |
1981392 | 1981392 | 2021-12-04 | Erie | Pennsylvania | 42049 | 36788 | 559 |
1978142 | 1978142 | 2021-12-03 | Erie | Pennsylvania | 42049 | 36544 | 554 |
1974892 | 1974892 | 2021-12-02 | Erie | Pennsylvania | 42049 | 36275 | 550 |
1971643 | 1971643 | 2021-12-01 | Erie | Pennsylvania | 42049 | 35940 | 547 |
1968393 | 1968393 | 2021-11-30 | Erie | Pennsylvania | 42049 | 35780 | 543 |
1965142 | 1965142 | 2021-11-29 | Erie | Pennsylvania | 42049 | 35643 | 541 |
1961890 | 1961890 | 2021-11-28 | Erie | Pennsylvania | 42049 | 35493 | 540 |
1958639 | 1958639 | 2021-11-27 | Erie | Pennsylvania | 42049 | 35381 | 539 |
1955388 | 1955388 | 2021-11-26 | Erie | Pennsylvania | 42049 | 35205 | 539 |
1952137 | 1952137 | 2021-11-25 | Erie | Pennsylvania | 42049 | 34954 | 539 |
1948886 | 1948886 | 2021-11-24 | Erie | Pennsylvania | 42049 | 34725 | 539 |
1945635 | 1945635 | 2021-11-23 | Erie | Pennsylvania | 42049 | 34500 | 534 |
1942384 | 1942384 | 2021-11-22 | Erie | Pennsylvania | 42049 | 34348 | 531 |
1939134 | 1939134 | 2021-11-21 | Erie | Pennsylvania | 42049 | 34156 | 531 |
1935884 | 1935884 | 2021-11-20 | Erie | Pennsylvania | 42049 | 33947 | 530 |
1932634 | 1932634 | 2021-11-19 | Erie | Pennsylvania | 42049 | 33600 | 527 |
1929383 | 1929383 | 2021-11-18 | Erie | Pennsylvania | 42049 | 33276 | 522 |
1926133 | 1926133 | 2021-11-17 | Erie | Pennsylvania | 42049 | 33037 | 519 |
1922883 | 1922883 | 2021-11-16 | Erie | Pennsylvania | 42049 | 32850 | 516 |
1919634 | 1919634 | 2021-11-15 | Erie | Pennsylvania | 42049 | 32645 | 514 |
1916384 | 1916384 | 2021-11-14 | Erie | Pennsylvania | 42049 | 32481 | 514 |
1913134 | 1913134 | 2021-11-13 | Erie | Pennsylvania | 42049 | 32257 | 513 |
1909884 | 1909884 | 2021-11-12 | Erie | Pennsylvania | 42049 | 31736 | 508 |
1906635 | 1906635 | 2021-11-11 | Erie | Pennsylvania | 42049 | 31478 | 508 |
1903386 | 1903386 | 2021-11-10 | Erie | Pennsylvania | 42049 | 31329 | 507 |
1900136 | 1900136 | 2021-11-09 | Erie | Pennsylvania | 42049 | 31070 | 502 |
1896886 | 1896886 | 2021-11-08 | Erie | Pennsylvania | 42049 | 30938 | 500 |
1893636 | 1893636 | 2021-11-07 | Erie | Pennsylvania | 42049 | 30761 | 499 |
1890386 | 1890386 | 2021-11-06 | Erie | Pennsylvania | 42049 | 30638 | 499 |
1887136 | 1887136 | 2021-11-05 | Erie | Pennsylvania | 42049 | 30432 | 499 |
1883886 | 1883886 | 2021-11-04 | Erie | Pennsylvania | 42049 | 30259 | 498 |
1880637 | 1880637 | 2021-11-03 | Erie | Pennsylvania | 42049 | 30087 | 495 |
1877388 | 1877388 | 2021-11-02 | Erie | Pennsylvania | 42049 | 29979 | 492 |
1874139 | 1874139 | 2021-11-01 | Erie | Pennsylvania | 42049 | 29717 | 490 |
1870890 | 1870890 | 2021-10-31 | Erie | Pennsylvania | 42049 | 29717 | 490 |
1867641 | 1867641 | 2021-10-30 | Erie | Pennsylvania | 42049 | 29623 | 489 |
1864392 | 1864392 | 2021-10-29 | Erie | Pennsylvania | 42049 | 29432 | 488 |
1861143 | 1861143 | 2021-10-28 | Erie | Pennsylvania | 42049 | 29285 | 486 |
1857894 | 1857894 | 2021-10-27 | Erie | Pennsylvania | 42049 | 29166 | 484 |
1854645 | 1854645 | 2021-10-26 | Erie | Pennsylvania | 42049 | 29040 | 483 |
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);