ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lebanon" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812419 | 1812419 | 2021-10-13 | Lebanon | Pennsylvania | 42075 | 19846 | 320 |
1809170 | 1809170 | 2021-10-12 | Lebanon | Pennsylvania | 42075 | 19786 | 318 |
1805920 | 1805920 | 2021-10-11 | Lebanon | Pennsylvania | 42075 | 19737 | 317 |
1802670 | 1802670 | 2021-10-10 | Lebanon | Pennsylvania | 42075 | 19697 | 317 |
1799421 | 1799421 | 2021-10-09 | Lebanon | Pennsylvania | 42075 | 19640 | 317 |
1796172 | 1796172 | 2021-10-08 | Lebanon | Pennsylvania | 42075 | 19534 | 317 |
1792923 | 1792923 | 2021-10-07 | Lebanon | Pennsylvania | 42075 | 19469 | 317 |
1789674 | 1789674 | 2021-10-06 | Lebanon | Pennsylvania | 42075 | 19383 | 315 |
1786426 | 1786426 | 2021-10-05 | Lebanon | Pennsylvania | 42075 | 19329 | 314 |
1783177 | 1783177 | 2021-10-04 | Lebanon | Pennsylvania | 42075 | 19279 | 313 |
1779928 | 1779928 | 2021-10-03 | Lebanon | Pennsylvania | 42075 | 19216 | 313 |
1776678 | 1776678 | 2021-10-02 | Lebanon | Pennsylvania | 42075 | 19095 | 313 |
1773428 | 1773428 | 2021-10-01 | Lebanon | Pennsylvania | 42075 | 19057 | 313 |
1770178 | 1770178 | 2021-09-30 | Lebanon | Pennsylvania | 42075 | 18968 | 313 |
1766929 | 1766929 | 2021-09-29 | Lebanon | Pennsylvania | 42075 | 18923 | 312 |
1763680 | 1763680 | 2021-09-28 | Lebanon | Pennsylvania | 42075 | 18887 | 311 |
1760431 | 1760431 | 2021-09-27 | Lebanon | Pennsylvania | 42075 | 18797 | 311 |
1757183 | 1757183 | 2021-09-26 | Lebanon | Pennsylvania | 42075 | 18763 | 311 |
1753935 | 1753935 | 2021-09-25 | Lebanon | Pennsylvania | 42075 | 18732 | 311 |
1750687 | 1750687 | 2021-09-24 | Lebanon | Pennsylvania | 42075 | 18684 | 310 |
1747438 | 1747438 | 2021-09-23 | Lebanon | Pennsylvania | 42075 | 18628 | 310 |
1744188 | 1744188 | 2021-09-22 | Lebanon | Pennsylvania | 42075 | 18560 | 309 |
1740939 | 1740939 | 2021-09-21 | Lebanon | Pennsylvania | 42075 | 18507 | 309 |
1737690 | 1737690 | 2021-09-20 | Lebanon | Pennsylvania | 42075 | 18449 | 309 |
1734440 | 1734440 | 2021-09-19 | Lebanon | Pennsylvania | 42075 | 18417 | 309 |
1731190 | 1731190 | 2021-09-18 | Lebanon | Pennsylvania | 42075 | 18365 | 309 |
1727940 | 1727940 | 2021-09-17 | Lebanon | Pennsylvania | 42075 | 18265 | 309 |
1724691 | 1724691 | 2021-09-16 | Lebanon | Pennsylvania | 42075 | 18199 | 309 |
1721442 | 1721442 | 2021-09-15 | Lebanon | Pennsylvania | 42075 | 18102 | 309 |
1718194 | 1718194 | 2021-09-14 | Lebanon | Pennsylvania | 42075 | 18031 | 309 |
1714946 | 1714946 | 2021-09-13 | Lebanon | Pennsylvania | 42075 | 17960 | 308 |
1711700 | 1711700 | 2021-09-12 | Lebanon | Pennsylvania | 42075 | 17889 | 308 |
1708453 | 1708453 | 2021-09-11 | Lebanon | Pennsylvania | 42075 | 17834 | 308 |
1705206 | 1705206 | 2021-09-10 | Lebanon | Pennsylvania | 42075 | 17751 | 307 |
1701956 | 1701956 | 2021-09-09 | Lebanon | Pennsylvania | 42075 | 17676 | 307 |
1698707 | 1698707 | 2021-09-08 | Lebanon | Pennsylvania | 42075 | 17599 | 305 |
1695459 | 1695459 | 2021-09-07 | Lebanon | Pennsylvania | 42075 | 17528 | 305 |
1692211 | 1692211 | 2021-09-06 | Lebanon | Pennsylvania | 42075 | 17483 | 305 |
1688962 | 1688962 | 2021-09-05 | Lebanon | Pennsylvania | 42075 | 17442 | 305 |
1685712 | 1685712 | 2021-09-04 | Lebanon | Pennsylvania | 42075 | 17402 | 305 |
1682461 | 1682461 | 2021-09-03 | Lebanon | Pennsylvania | 42075 | 17323 | 305 |
1679211 | 1679211 | 2021-09-02 | Lebanon | Pennsylvania | 42075 | 17261 | 305 |
1675963 | 1675963 | 2021-09-01 | Lebanon | Pennsylvania | 42075 | 17213 | 304 |
1672716 | 1672716 | 2021-08-31 | Lebanon | Pennsylvania | 42075 | 17181 | 304 |
1669468 | 1669468 | 2021-08-30 | Lebanon | Pennsylvania | 42075 | 17133 | 303 |
1666221 | 1666221 | 2021-08-29 | Lebanon | Pennsylvania | 42075 | 17101 | 302 |
1662973 | 1662973 | 2021-08-28 | Lebanon | Pennsylvania | 42075 | 17060 | 302 |
1659725 | 1659725 | 2021-08-27 | Lebanon | Pennsylvania | 42075 | 17009 | 301 |
1656476 | 1656476 | 2021-08-26 | Lebanon | Pennsylvania | 42075 | 16964 | 301 |
1653229 | 1653229 | 2021-08-25 | Lebanon | Pennsylvania | 42075 | 16924 | 301 |
1649982 | 1649982 | 2021-08-24 | Lebanon | Pennsylvania | 42075 | 16883 | 301 |
1646733 | 1646733 | 2021-08-23 | Lebanon | Pennsylvania | 42075 | 16846 | 301 |
1643484 | 1643484 | 2021-08-22 | Lebanon | Pennsylvania | 42075 | 16820 | 301 |
1640234 | 1640234 | 2021-08-21 | Lebanon | Pennsylvania | 42075 | 16793 | 301 |
1636984 | 1636984 | 2021-08-20 | Lebanon | Pennsylvania | 42075 | 16766 | 301 |
1633734 | 1633734 | 2021-08-19 | Lebanon | Pennsylvania | 42075 | 16733 | 301 |
1630487 | 1630487 | 2021-08-18 | Lebanon | Pennsylvania | 42075 | 16689 | 301 |
1627240 | 1627240 | 2021-08-17 | Lebanon | Pennsylvania | 42075 | 16648 | 300 |
1623993 | 1623993 | 2021-08-16 | Lebanon | Pennsylvania | 42075 | 16621 | 299 |
1620746 | 1620746 | 2021-08-15 | Lebanon | Pennsylvania | 42075 | 16599 | 299 |
1617498 | 1617498 | 2021-08-14 | Lebanon | Pennsylvania | 42075 | 16579 | 299 |
1614250 | 1614250 | 2021-08-13 | Lebanon | Pennsylvania | 42075 | 16562 | 299 |
1611001 | 1611001 | 2021-08-12 | Lebanon | Pennsylvania | 42075 | 16530 | 299 |
1607753 | 1607753 | 2021-08-11 | Lebanon | Pennsylvania | 42075 | 16501 | 298 |
1604504 | 1604504 | 2021-08-10 | Lebanon | Pennsylvania | 42075 | 16481 | 296 |
1601255 | 1601255 | 2021-08-09 | Lebanon | Pennsylvania | 42075 | 16462 | 296 |
1598007 | 1598007 | 2021-08-08 | Lebanon | Pennsylvania | 42075 | 16431 | 296 |
1594758 | 1594758 | 2021-08-07 | Lebanon | Pennsylvania | 42075 | 16431 | 296 |
1591509 | 1591509 | 2021-08-06 | Lebanon | Pennsylvania | 42075 | 16410 | 296 |
1588260 | 1588260 | 2021-08-05 | Lebanon | Pennsylvania | 42075 | 16393 | 295 |
1585010 | 1585010 | 2021-08-04 | Lebanon | Pennsylvania | 42075 | 16380 | 295 |
1581760 | 1581760 | 2021-08-03 | Lebanon | Pennsylvania | 42075 | 16360 | 295 |
1578511 | 1578511 | 2021-08-02 | Lebanon | Pennsylvania | 42075 | 16348 | 295 |
1575263 | 1575263 | 2021-08-01 | Lebanon | Pennsylvania | 42075 | 16335 | 295 |
1572015 | 1572015 | 2021-07-31 | Lebanon | Pennsylvania | 42075 | 16310 | 295 |
1568767 | 1568767 | 2021-07-30 | Lebanon | Pennsylvania | 42075 | 16310 | 295 |
1565519 | 1565519 | 2021-07-29 | Lebanon | Pennsylvania | 42075 | 16299 | 295 |
1562271 | 1562271 | 2021-07-28 | Lebanon | Pennsylvania | 42075 | 16286 | 295 |
1559023 | 1559023 | 2021-07-27 | Lebanon | Pennsylvania | 42075 | 16281 | 295 |
1555776 | 1555776 | 2021-07-26 | Lebanon | Pennsylvania | 42075 | 16271 | 295 |
1552529 | 1552529 | 2021-07-25 | Lebanon | Pennsylvania | 42075 | 16264 | 295 |
1549282 | 1549282 | 2021-07-24 | Lebanon | Pennsylvania | 42075 | 16260 | 295 |
1546035 | 1546035 | 2021-07-23 | Lebanon | Pennsylvania | 42075 | 16247 | 295 |
1542788 | 1542788 | 2021-07-22 | Lebanon | Pennsylvania | 42075 | 16246 | 295 |
1539540 | 1539540 | 2021-07-21 | Lebanon | Pennsylvania | 42075 | 16242 | 295 |
1536293 | 1536293 | 2021-07-20 | Lebanon | Pennsylvania | 42075 | 16238 | 295 |
1533045 | 1533045 | 2021-07-19 | Lebanon | Pennsylvania | 42075 | 16234 | 295 |
1529798 | 1529798 | 2021-07-18 | Lebanon | Pennsylvania | 42075 | 16233 | 295 |
1526551 | 1526551 | 2021-07-17 | Lebanon | Pennsylvania | 42075 | 16228 | 295 |
1523304 | 1523304 | 2021-07-16 | Lebanon | Pennsylvania | 42075 | 16223 | 295 |
1520056 | 1520056 | 2021-07-15 | Lebanon | Pennsylvania | 42075 | 16219 | 295 |
1516808 | 1516808 | 2021-07-14 | Lebanon | Pennsylvania | 42075 | 16216 | 295 |
1513561 | 1513561 | 2021-07-13 | Lebanon | Pennsylvania | 42075 | 16213 | 295 |
1510315 | 1510315 | 2021-07-12 | Lebanon | Pennsylvania | 42075 | 16211 | 295 |
1507068 | 1507068 | 2021-07-11 | Lebanon | Pennsylvania | 42075 | 16211 | 295 |
1503822 | 1503822 | 2021-07-10 | Lebanon | Pennsylvania | 42075 | 16210 | 295 |
1500576 | 1500576 | 2021-07-09 | Lebanon | Pennsylvania | 42075 | 16210 | 295 |
1497330 | 1497330 | 2021-07-08 | Lebanon | Pennsylvania | 42075 | 16209 | 295 |
1494083 | 1494083 | 2021-07-07 | Lebanon | Pennsylvania | 42075 | 16207 | 295 |
1490836 | 1490836 | 2021-07-06 | Lebanon | Pennsylvania | 42075 | 16206 | 295 |
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);