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 |
---|---|---|---|---|---|---|---|
1838397 | 1838397 | 2021-10-21 | Erie | Pennsylvania | 42049 | 28428 | 475 |
1835148 | 1835148 | 2021-10-20 | Erie | Pennsylvania | 42049 | 28288 | 474 |
1831899 | 1831899 | 2021-10-19 | Erie | Pennsylvania | 42049 | 28208 | 474 |
1828650 | 1828650 | 2021-10-18 | Erie | Pennsylvania | 42049 | 28113 | 472 |
1825401 | 1825401 | 2021-10-17 | Erie | Pennsylvania | 42049 | 27971 | 466 |
1822152 | 1822152 | 2021-10-16 | Erie | Pennsylvania | 42049 | 27855 | 466 |
1818903 | 1818903 | 2021-10-15 | Erie | Pennsylvania | 42049 | 27699 | 466 |
1815654 | 1815654 | 2021-10-14 | Erie | Pennsylvania | 42049 | 27508 | 465 |
1812406 | 1812406 | 2021-10-13 | Erie | Pennsylvania | 42049 | 27409 | 465 |
1809157 | 1809157 | 2021-10-12 | Erie | Pennsylvania | 42049 | 27282 | 460 |
1805907 | 1805907 | 2021-10-11 | Erie | Pennsylvania | 42049 | 27158 | 459 |
1802657 | 1802657 | 2021-10-10 | Erie | Pennsylvania | 42049 | 27084 | 459 |
1799408 | 1799408 | 2021-10-09 | Erie | Pennsylvania | 42049 | 26925 | 459 |
1796159 | 1796159 | 2021-10-08 | Erie | Pennsylvania | 42049 | 26778 | 459 |
1792910 | 1792910 | 2021-10-07 | Erie | Pennsylvania | 42049 | 26600 | 457 |
1789661 | 1789661 | 2021-10-06 | Erie | Pennsylvania | 42049 | 26436 | 455 |
1786413 | 1786413 | 2021-10-05 | Erie | Pennsylvania | 42049 | 26323 | 454 |
1783164 | 1783164 | 2021-10-04 | Erie | Pennsylvania | 42049 | 26195 | 453 |
1779915 | 1779915 | 2021-10-03 | Erie | Pennsylvania | 42049 | 26070 | 453 |
1776665 | 1776665 | 2021-10-02 | Erie | Pennsylvania | 42049 | 25867 | 453 |
1773415 | 1773415 | 2021-10-01 | Erie | Pennsylvania | 42049 | 25738 | 453 |
1770165 | 1770165 | 2021-09-30 | Erie | Pennsylvania | 42049 | 25588 | 453 |
1766916 | 1766916 | 2021-09-29 | Erie | Pennsylvania | 42049 | 25419 | 452 |
1763667 | 1763667 | 2021-09-28 | Erie | Pennsylvania | 42049 | 25330 | 452 |
1760418 | 1760418 | 2021-09-27 | Erie | Pennsylvania | 42049 | 25229 | 451 |
1757170 | 1757170 | 2021-09-26 | Erie | Pennsylvania | 42049 | 25143 | 451 |
1753922 | 1753922 | 2021-09-25 | Erie | Pennsylvania | 42049 | 24994 | 451 |
1750674 | 1750674 | 2021-09-24 | Erie | Pennsylvania | 42049 | 24887 | 450 |
1747425 | 1747425 | 2021-09-23 | Erie | Pennsylvania | 42049 | 24751 | 449 |
1744175 | 1744175 | 2021-09-22 | Erie | Pennsylvania | 42049 | 24618 | 449 |
1740926 | 1740926 | 2021-09-21 | Erie | Pennsylvania | 42049 | 24500 | 448 |
1737677 | 1737677 | 2021-09-20 | Erie | Pennsylvania | 42049 | 24417 | 444 |
1734427 | 1734427 | 2021-09-19 | Erie | Pennsylvania | 42049 | 24328 | 444 |
1731177 | 1731177 | 2021-09-18 | Erie | Pennsylvania | 42049 | 24225 | 444 |
1727927 | 1727927 | 2021-09-17 | Erie | Pennsylvania | 42049 | 24091 | 444 |
1724678 | 1724678 | 2021-09-16 | Erie | Pennsylvania | 42049 | 23998 | 443 |
1721429 | 1721429 | 2021-09-15 | Erie | Pennsylvania | 42049 | 23864 | 442 |
1718181 | 1718181 | 2021-09-14 | Erie | Pennsylvania | 42049 | 23753 | 442 |
1714933 | 1714933 | 2021-09-13 | Erie | Pennsylvania | 42049 | 23671 | 440 |
1711687 | 1711687 | 2021-09-12 | Erie | Pennsylvania | 42049 | 23620 | 440 |
1708440 | 1708440 | 2021-09-11 | Erie | Pennsylvania | 42049 | 23504 | 440 |
1705193 | 1705193 | 2021-09-10 | Erie | Pennsylvania | 42049 | 23421 | 439 |
1701943 | 1701943 | 2021-09-09 | Erie | Pennsylvania | 42049 | 23318 | 435 |
1698694 | 1698694 | 2021-09-08 | Erie | Pennsylvania | 42049 | 23246 | 434 |
1695446 | 1695446 | 2021-09-07 | Erie | Pennsylvania | 42049 | 23142 | 434 |
1692198 | 1692198 | 2021-09-06 | Erie | Pennsylvania | 42049 | 23087 | 434 |
1688949 | 1688949 | 2021-09-05 | Erie | Pennsylvania | 42049 | 23018 | 434 |
1685699 | 1685699 | 2021-09-04 | Erie | Pennsylvania | 42049 | 22964 | 434 |
1682448 | 1682448 | 2021-09-03 | Erie | Pennsylvania | 42049 | 22883 | 433 |
1679198 | 1679198 | 2021-09-02 | Erie | Pennsylvania | 42049 | 22790 | 433 |
1675950 | 1675950 | 2021-09-01 | Erie | Pennsylvania | 42049 | 22706 | 429 |
1672703 | 1672703 | 2021-08-31 | Erie | Pennsylvania | 42049 | 22667 | 429 |
1669455 | 1669455 | 2021-08-30 | Erie | Pennsylvania | 42049 | 22592 | 427 |
1666208 | 1666208 | 2021-08-29 | Erie | Pennsylvania | 42049 | 22538 | 427 |
1662960 | 1662960 | 2021-08-28 | Erie | Pennsylvania | 42049 | 22477 | 427 |
1659712 | 1659712 | 2021-08-27 | Erie | Pennsylvania | 42049 | 22413 | 427 |
1656463 | 1656463 | 2021-08-26 | Erie | Pennsylvania | 42049 | 22358 | 426 |
1653216 | 1653216 | 2021-08-25 | Erie | Pennsylvania | 42049 | 22276 | 426 |
1649969 | 1649969 | 2021-08-24 | Erie | Pennsylvania | 42049 | 22190 | 426 |
1646720 | 1646720 | 2021-08-23 | Erie | Pennsylvania | 42049 | 22147 | 426 |
1643471 | 1643471 | 2021-08-22 | Erie | Pennsylvania | 42049 | 22112 | 426 |
1640221 | 1640221 | 2021-08-21 | Erie | Pennsylvania | 42049 | 22075 | 426 |
1636971 | 1636971 | 2021-08-20 | Erie | Pennsylvania | 42049 | 22022 | 425 |
1633721 | 1633721 | 2021-08-19 | Erie | Pennsylvania | 42049 | 21978 | 423 |
1630474 | 1630474 | 2021-08-18 | Erie | Pennsylvania | 42049 | 21920 | 423 |
1627227 | 1627227 | 2021-08-17 | Erie | Pennsylvania | 42049 | 21889 | 422 |
1623980 | 1623980 | 2021-08-16 | Erie | Pennsylvania | 42049 | 21855 | 422 |
1620733 | 1620733 | 2021-08-15 | Erie | Pennsylvania | 42049 | 21821 | 422 |
1617485 | 1617485 | 2021-08-14 | Erie | Pennsylvania | 42049 | 21773 | 422 |
1614237 | 1614237 | 2021-08-13 | Erie | Pennsylvania | 42049 | 21739 | 422 |
1610988 | 1610988 | 2021-08-12 | Erie | Pennsylvania | 42049 | 21709 | 422 |
1607740 | 1607740 | 2021-08-11 | Erie | Pennsylvania | 42049 | 21651 | 421 |
1604491 | 1604491 | 2021-08-10 | Erie | Pennsylvania | 42049 | 21624 | 421 |
1601242 | 1601242 | 2021-08-09 | Erie | Pennsylvania | 42049 | 21596 | 420 |
1597994 | 1597994 | 2021-08-08 | Erie | Pennsylvania | 42049 | 21550 | 420 |
1594745 | 1594745 | 2021-08-07 | Erie | Pennsylvania | 42049 | 21550 | 420 |
1591496 | 1591496 | 2021-08-06 | Erie | Pennsylvania | 42049 | 21531 | 420 |
1588247 | 1588247 | 2021-08-05 | Erie | Pennsylvania | 42049 | 21502 | 420 |
1584997 | 1584997 | 2021-08-04 | Erie | Pennsylvania | 42049 | 21476 | 419 |
1581747 | 1581747 | 2021-08-03 | Erie | Pennsylvania | 42049 | 21451 | 419 |
1578498 | 1578498 | 2021-08-02 | Erie | Pennsylvania | 42049 | 21430 | 419 |
1575250 | 1575250 | 2021-08-01 | Erie | Pennsylvania | 42049 | 21407 | 419 |
1572002 | 1572002 | 2021-07-31 | Erie | Pennsylvania | 42049 | 21370 | 419 |
1568754 | 1568754 | 2021-07-30 | Erie | Pennsylvania | 42049 | 21370 | 419 |
1565506 | 1565506 | 2021-07-29 | Erie | Pennsylvania | 42049 | 21354 | 419 |
1562258 | 1562258 | 2021-07-28 | Erie | Pennsylvania | 42049 | 21342 | 419 |
1559010 | 1559010 | 2021-07-27 | Erie | Pennsylvania | 42049 | 21336 | 419 |
1555763 | 1555763 | 2021-07-26 | Erie | Pennsylvania | 42049 | 21320 | 419 |
1552516 | 1552516 | 2021-07-25 | Erie | Pennsylvania | 42049 | 21313 | 419 |
1549269 | 1549269 | 2021-07-24 | Erie | Pennsylvania | 42049 | 21308 | 419 |
1546022 | 1546022 | 2021-07-23 | Erie | Pennsylvania | 42049 | 21298 | 419 |
1542775 | 1542775 | 2021-07-22 | Erie | Pennsylvania | 42049 | 21292 | 419 |
1539527 | 1539527 | 2021-07-21 | Erie | Pennsylvania | 42049 | 21289 | 419 |
1536280 | 1536280 | 2021-07-20 | Erie | Pennsylvania | 42049 | 21284 | 419 |
1533032 | 1533032 | 2021-07-19 | Erie | Pennsylvania | 42049 | 21279 | 419 |
1529785 | 1529785 | 2021-07-18 | Erie | Pennsylvania | 42049 | 21273 | 419 |
1526538 | 1526538 | 2021-07-17 | Erie | Pennsylvania | 42049 | 21270 | 419 |
1523291 | 1523291 | 2021-07-16 | Erie | Pennsylvania | 42049 | 21267 | 419 |
1520043 | 1520043 | 2021-07-15 | Erie | Pennsylvania | 42049 | 21257 | 419 |
1516795 | 1516795 | 2021-07-14 | Erie | Pennsylvania | 42049 | 21255 | 419 |
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);