ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Adams" and fips = 42001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1792886 | 1792886 | 2021-10-07 | Adams | Pennsylvania | 42001 | 12356 | 206 |
1789637 | 1789637 | 2021-10-06 | Adams | Pennsylvania | 42001 | 12302 | 205 |
1786389 | 1786389 | 2021-10-05 | Adams | Pennsylvania | 42001 | 12252 | 200 |
1783140 | 1783140 | 2021-10-04 | Adams | Pennsylvania | 42001 | 12225 | 199 |
1779891 | 1779891 | 2021-10-03 | Adams | Pennsylvania | 42001 | 12162 | 199 |
1776641 | 1776641 | 2021-10-02 | Adams | Pennsylvania | 42001 | 12082 | 199 |
1773391 | 1773391 | 2021-10-01 | Adams | Pennsylvania | 42001 | 12056 | 199 |
1770141 | 1770141 | 2021-09-30 | Adams | Pennsylvania | 42001 | 12012 | 199 |
1766892 | 1766892 | 2021-09-29 | Adams | Pennsylvania | 42001 | 11953 | 197 |
1763643 | 1763643 | 2021-09-28 | Adams | Pennsylvania | 42001 | 11894 | 197 |
1760394 | 1760394 | 2021-09-27 | Adams | Pennsylvania | 42001 | 11850 | 197 |
1757146 | 1757146 | 2021-09-26 | Adams | Pennsylvania | 42001 | 11803 | 197 |
1753898 | 1753898 | 2021-09-25 | Adams | Pennsylvania | 42001 | 11752 | 196 |
1750650 | 1750650 | 2021-09-24 | Adams | Pennsylvania | 42001 | 11713 | 196 |
1747401 | 1747401 | 2021-09-23 | Adams | Pennsylvania | 42001 | 11666 | 196 |
1744151 | 1744151 | 2021-09-22 | Adams | Pennsylvania | 42001 | 11629 | 196 |
1740902 | 1740902 | 2021-09-21 | Adams | Pennsylvania | 42001 | 11571 | 196 |
1737653 | 1737653 | 2021-09-20 | Adams | Pennsylvania | 42001 | 11528 | 194 |
1734403 | 1734403 | 2021-09-19 | Adams | Pennsylvania | 42001 | 11500 | 194 |
1731153 | 1731153 | 2021-09-18 | Adams | Pennsylvania | 42001 | 11446 | 194 |
1727903 | 1727903 | 2021-09-17 | Adams | Pennsylvania | 42001 | 11387 | 194 |
1724654 | 1724654 | 2021-09-16 | Adams | Pennsylvania | 42001 | 11348 | 194 |
1721405 | 1721405 | 2021-09-15 | Adams | Pennsylvania | 42001 | 11288 | 193 |
1718157 | 1718157 | 2021-09-14 | Adams | Pennsylvania | 42001 | 11203 | 193 |
1714909 | 1714909 | 2021-09-13 | Adams | Pennsylvania | 42001 | 11166 | 192 |
1711663 | 1711663 | 2021-09-12 | Adams | Pennsylvania | 42001 | 11123 | 192 |
1708416 | 1708416 | 2021-09-11 | Adams | Pennsylvania | 42001 | 11050 | 192 |
1705169 | 1705169 | 2021-09-10 | Adams | Pennsylvania | 42001 | 11009 | 192 |
1701919 | 1701919 | 2021-09-09 | Adams | Pennsylvania | 42001 | 10953 | 192 |
1698670 | 1698670 | 2021-09-08 | Adams | Pennsylvania | 42001 | 10875 | 192 |
1695422 | 1695422 | 2021-09-07 | Adams | Pennsylvania | 42001 | 10834 | 192 |
1692174 | 1692174 | 2021-09-06 | Adams | Pennsylvania | 42001 | 10799 | 192 |
1688925 | 1688925 | 2021-09-05 | Adams | Pennsylvania | 42001 | 10762 | 192 |
1685675 | 1685675 | 2021-09-04 | Adams | Pennsylvania | 42001 | 10725 | 192 |
1682424 | 1682424 | 2021-09-03 | Adams | Pennsylvania | 42001 | 10682 | 192 |
1679174 | 1679174 | 2021-09-02 | Adams | Pennsylvania | 42001 | 10645 | 191 |
1675926 | 1675926 | 2021-09-01 | Adams | Pennsylvania | 42001 | 10591 | 191 |
1672679 | 1672679 | 2021-08-31 | Adams | Pennsylvania | 42001 | 10556 | 191 |
1669431 | 1669431 | 2021-08-30 | Adams | Pennsylvania | 42001 | 10529 | 191 |
1666184 | 1666184 | 2021-08-29 | Adams | Pennsylvania | 42001 | 10504 | 191 |
1662936 | 1662936 | 2021-08-28 | Adams | Pennsylvania | 42001 | 10473 | 191 |
1659688 | 1659688 | 2021-08-27 | Adams | Pennsylvania | 42001 | 10423 | 191 |
1656439 | 1656439 | 2021-08-26 | Adams | Pennsylvania | 42001 | 10391 | 191 |
1653192 | 1653192 | 2021-08-25 | Adams | Pennsylvania | 42001 | 10358 | 191 |
1649945 | 1649945 | 2021-08-24 | Adams | Pennsylvania | 42001 | 10328 | 191 |
1646696 | 1646696 | 2021-08-23 | Adams | Pennsylvania | 42001 | 10301 | 190 |
1643447 | 1643447 | 2021-08-22 | Adams | Pennsylvania | 42001 | 10273 | 190 |
1640197 | 1640197 | 2021-08-21 | Adams | Pennsylvania | 42001 | 10240 | 190 |
1636947 | 1636947 | 2021-08-20 | Adams | Pennsylvania | 42001 | 10223 | 190 |
1633697 | 1633697 | 2021-08-19 | Adams | Pennsylvania | 42001 | 10195 | 190 |
1630450 | 1630450 | 2021-08-18 | Adams | Pennsylvania | 42001 | 10165 | 190 |
1627203 | 1627203 | 2021-08-17 | Adams | Pennsylvania | 42001 | 10149 | 190 |
1623956 | 1623956 | 2021-08-16 | Adams | Pennsylvania | 42001 | 10118 | 190 |
1620709 | 1620709 | 2021-08-15 | Adams | Pennsylvania | 42001 | 10106 | 190 |
1617461 | 1617461 | 2021-08-14 | Adams | Pennsylvania | 42001 | 10082 | 190 |
1614213 | 1614213 | 2021-08-13 | Adams | Pennsylvania | 42001 | 10062 | 190 |
1610964 | 1610964 | 2021-08-12 | Adams | Pennsylvania | 42001 | 10035 | 190 |
1607716 | 1607716 | 2021-08-11 | Adams | Pennsylvania | 42001 | 10021 | 190 |
1604467 | 1604467 | 2021-08-10 | Adams | Pennsylvania | 42001 | 9994 | 190 |
1601218 | 1601218 | 2021-08-09 | Adams | Pennsylvania | 42001 | 9981 | 190 |
1597970 | 1597970 | 2021-08-08 | Adams | Pennsylvania | 42001 | 9956 | 190 |
1594721 | 1594721 | 2021-08-07 | Adams | Pennsylvania | 42001 | 9956 | 190 |
1591472 | 1591472 | 2021-08-06 | Adams | Pennsylvania | 42001 | 9932 | 190 |
1588223 | 1588223 | 2021-08-05 | Adams | Pennsylvania | 42001 | 9911 | 190 |
1584973 | 1584973 | 2021-08-04 | Adams | Pennsylvania | 42001 | 9893 | 190 |
1581723 | 1581723 | 2021-08-03 | Adams | Pennsylvania | 42001 | 9880 | 190 |
1578474 | 1578474 | 2021-08-02 | Adams | Pennsylvania | 42001 | 9867 | 190 |
1575226 | 1575226 | 2021-08-01 | Adams | Pennsylvania | 42001 | 9854 | 190 |
1571978 | 1571978 | 2021-07-31 | Adams | Pennsylvania | 42001 | 9833 | 190 |
1568730 | 1568730 | 2021-07-30 | Adams | Pennsylvania | 42001 | 9833 | 190 |
1565482 | 1565482 | 2021-07-29 | Adams | Pennsylvania | 42001 | 9821 | 190 |
1562234 | 1562234 | 2021-07-28 | Adams | Pennsylvania | 42001 | 9807 | 190 |
1558986 | 1558986 | 2021-07-27 | Adams | Pennsylvania | 42001 | 9794 | 190 |
1555739 | 1555739 | 2021-07-26 | Adams | Pennsylvania | 42001 | 9784 | 190 |
1552492 | 1552492 | 2021-07-25 | Adams | Pennsylvania | 42001 | 9779 | 190 |
1549245 | 1549245 | 2021-07-24 | Adams | Pennsylvania | 42001 | 9777 | 190 |
1545998 | 1545998 | 2021-07-23 | Adams | Pennsylvania | 42001 | 9769 | 190 |
1542751 | 1542751 | 2021-07-22 | Adams | Pennsylvania | 42001 | 9764 | 190 |
1539503 | 1539503 | 2021-07-21 | Adams | Pennsylvania | 42001 | 9754 | 189 |
1536256 | 1536256 | 2021-07-20 | Adams | Pennsylvania | 42001 | 9740 | 189 |
1533008 | 1533008 | 2021-07-19 | Adams | Pennsylvania | 42001 | 9732 | 189 |
1529761 | 1529761 | 2021-07-18 | Adams | Pennsylvania | 42001 | 9727 | 189 |
1526514 | 1526514 | 2021-07-17 | Adams | Pennsylvania | 42001 | 9722 | 189 |
1523267 | 1523267 | 2021-07-16 | Adams | Pennsylvania | 42001 | 9720 | 189 |
1520019 | 1520019 | 2021-07-15 | Adams | Pennsylvania | 42001 | 9715 | 189 |
1516771 | 1516771 | 2021-07-14 | Adams | Pennsylvania | 42001 | 9713 | 189 |
1513524 | 1513524 | 2021-07-13 | Adams | Pennsylvania | 42001 | 9709 | 189 |
1510278 | 1510278 | 2021-07-12 | Adams | Pennsylvania | 42001 | 9705 | 189 |
1507031 | 1507031 | 2021-07-11 | Adams | Pennsylvania | 42001 | 9705 | 189 |
1503785 | 1503785 | 2021-07-10 | Adams | Pennsylvania | 42001 | 9702 | 189 |
1500539 | 1500539 | 2021-07-09 | Adams | Pennsylvania | 42001 | 9702 | 189 |
1497293 | 1497293 | 2021-07-08 | Adams | Pennsylvania | 42001 | 9697 | 189 |
1494046 | 1494046 | 2021-07-07 | Adams | Pennsylvania | 42001 | 9696 | 189 |
1490799 | 1490799 | 2021-07-06 | Adams | Pennsylvania | 42001 | 9694 | 189 |
1487552 | 1487552 | 2021-07-05 | Adams | Pennsylvania | 42001 | 9690 | 189 |
1484305 | 1484305 | 2021-07-04 | Adams | Pennsylvania | 42001 | 9689 | 189 |
1481059 | 1481059 | 2021-07-03 | Adams | Pennsylvania | 42001 | 9688 | 189 |
1477812 | 1477812 | 2021-07-02 | Adams | Pennsylvania | 42001 | 9685 | 189 |
1474566 | 1474566 | 2021-07-01 | Adams | Pennsylvania | 42001 | 9683 | 189 |
1471320 | 1471320 | 2021-06-30 | Adams | Pennsylvania | 42001 | 9682 | 189 |
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);