ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Montour" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1841668 | 1841668 | 2021-10-22 | Montour | Pennsylvania | 42093 | 2476 | 71 |
1838419 | 1838419 | 2021-10-21 | Montour | Pennsylvania | 42093 | 2467 | 71 |
1835170 | 1835170 | 2021-10-20 | Montour | Pennsylvania | 42093 | 2457 | 71 |
1831921 | 1831921 | 2021-10-19 | Montour | Pennsylvania | 42093 | 2449 | 70 |
1828672 | 1828672 | 2021-10-18 | Montour | Pennsylvania | 42093 | 2444 | 70 |
1825423 | 1825423 | 2021-10-17 | Montour | Pennsylvania | 42093 | 2435 | 70 |
1822174 | 1822174 | 2021-10-16 | Montour | Pennsylvania | 42093 | 2426 | 70 |
1818925 | 1818925 | 2021-10-15 | Montour | Pennsylvania | 42093 | 2413 | 70 |
1815676 | 1815676 | 2021-10-14 | Montour | Pennsylvania | 42093 | 2400 | 70 |
1812428 | 1812428 | 2021-10-13 | Montour | Pennsylvania | 42093 | 2386 | 70 |
1809179 | 1809179 | 2021-10-12 | Montour | Pennsylvania | 42093 | 2366 | 70 |
1805929 | 1805929 | 2021-10-11 | Montour | Pennsylvania | 42093 | 2362 | 69 |
1802679 | 1802679 | 2021-10-10 | Montour | Pennsylvania | 42093 | 2358 | 69 |
1799430 | 1799430 | 2021-10-09 | Montour | Pennsylvania | 42093 | 2346 | 69 |
1796181 | 1796181 | 2021-10-08 | Montour | Pennsylvania | 42093 | 2339 | 69 |
1792932 | 1792932 | 2021-10-07 | Montour | Pennsylvania | 42093 | 2325 | 69 |
1789683 | 1789683 | 2021-10-06 | Montour | Pennsylvania | 42093 | 2313 | 69 |
1786435 | 1786435 | 2021-10-05 | Montour | Pennsylvania | 42093 | 2301 | 68 |
1783186 | 1783186 | 2021-10-04 | Montour | Pennsylvania | 42093 | 2295 | 68 |
1779937 | 1779937 | 2021-10-03 | Montour | Pennsylvania | 42093 | 2281 | 68 |
1776687 | 1776687 | 2021-10-02 | Montour | Pennsylvania | 42093 | 2278 | 68 |
1773437 | 1773437 | 2021-10-01 | Montour | Pennsylvania | 42093 | 2274 | 68 |
1770187 | 1770187 | 2021-09-30 | Montour | Pennsylvania | 42093 | 2264 | 68 |
1766938 | 1766938 | 2021-09-29 | Montour | Pennsylvania | 42093 | 2258 | 68 |
1763689 | 1763689 | 2021-09-28 | Montour | Pennsylvania | 42093 | 2249 | 68 |
1760440 | 1760440 | 2021-09-27 | Montour | Pennsylvania | 42093 | 2242 | 68 |
1757192 | 1757192 | 2021-09-26 | Montour | Pennsylvania | 42093 | 2239 | 68 |
1753944 | 1753944 | 2021-09-25 | Montour | Pennsylvania | 42093 | 2231 | 68 |
1750696 | 1750696 | 2021-09-24 | Montour | Pennsylvania | 42093 | 2228 | 68 |
1747447 | 1747447 | 2021-09-23 | Montour | Pennsylvania | 42093 | 2220 | 68 |
1744197 | 1744197 | 2021-09-22 | Montour | Pennsylvania | 42093 | 2217 | 68 |
1740948 | 1740948 | 2021-09-21 | Montour | Pennsylvania | 42093 | 2208 | 68 |
1737699 | 1737699 | 2021-09-20 | Montour | Pennsylvania | 42093 | 2204 | 68 |
1734449 | 1734449 | 2021-09-19 | Montour | Pennsylvania | 42093 | 2200 | 68 |
1731199 | 1731199 | 2021-09-18 | Montour | Pennsylvania | 42093 | 2193 | 68 |
1727949 | 1727949 | 2021-09-17 | Montour | Pennsylvania | 42093 | 2188 | 67 |
1724700 | 1724700 | 2021-09-16 | Montour | Pennsylvania | 42093 | 2183 | 67 |
1721451 | 1721451 | 2021-09-15 | Montour | Pennsylvania | 42093 | 2171 | 67 |
1718203 | 1718203 | 2021-09-14 | Montour | Pennsylvania | 42093 | 2162 | 67 |
1714955 | 1714955 | 2021-09-13 | Montour | Pennsylvania | 42093 | 2157 | 67 |
1711709 | 1711709 | 2021-09-12 | Montour | Pennsylvania | 42093 | 2151 | 67 |
1708462 | 1708462 | 2021-09-11 | Montour | Pennsylvania | 42093 | 2143 | 67 |
1705215 | 1705215 | 2021-09-10 | Montour | Pennsylvania | 42093 | 2136 | 67 |
1701965 | 1701965 | 2021-09-09 | Montour | Pennsylvania | 42093 | 2128 | 67 |
1698716 | 1698716 | 2021-09-08 | Montour | Pennsylvania | 42093 | 2124 | 67 |
1695468 | 1695468 | 2021-09-07 | Montour | Pennsylvania | 42093 | 2121 | 67 |
1692220 | 1692220 | 2021-09-06 | Montour | Pennsylvania | 42093 | 2120 | 67 |
1688971 | 1688971 | 2021-09-05 | Montour | Pennsylvania | 42093 | 2116 | 67 |
1685721 | 1685721 | 2021-09-04 | Montour | Pennsylvania | 42093 | 2110 | 67 |
1682470 | 1682470 | 2021-09-03 | Montour | Pennsylvania | 42093 | 2100 | 67 |
1679220 | 1679220 | 2021-09-02 | Montour | Pennsylvania | 42093 | 2096 | 67 |
1675972 | 1675972 | 2021-09-01 | Montour | Pennsylvania | 42093 | 2093 | 67 |
1672725 | 1672725 | 2021-08-31 | Montour | Pennsylvania | 42093 | 2088 | 67 |
1669477 | 1669477 | 2021-08-30 | Montour | Pennsylvania | 42093 | 2082 | 67 |
1666230 | 1666230 | 2021-08-29 | Montour | Pennsylvania | 42093 | 2080 | 67 |
1662982 | 1662982 | 2021-08-28 | Montour | Pennsylvania | 42093 | 2079 | 67 |
1659734 | 1659734 | 2021-08-27 | Montour | Pennsylvania | 42093 | 2073 | 67 |
1656485 | 1656485 | 2021-08-26 | Montour | Pennsylvania | 42093 | 2067 | 67 |
1653238 | 1653238 | 2021-08-25 | Montour | Pennsylvania | 42093 | 2066 | 67 |
1649991 | 1649991 | 2021-08-24 | Montour | Pennsylvania | 42093 | 2060 | 67 |
1646742 | 1646742 | 2021-08-23 | Montour | Pennsylvania | 42093 | 2055 | 67 |
1643493 | 1643493 | 2021-08-22 | Montour | Pennsylvania | 42093 | 2054 | 67 |
1640243 | 1640243 | 2021-08-21 | Montour | Pennsylvania | 42093 | 2054 | 67 |
1636993 | 1636993 | 2021-08-20 | Montour | Pennsylvania | 42093 | 2049 | 67 |
1633743 | 1633743 | 2021-08-19 | Montour | Pennsylvania | 42093 | 2048 | 67 |
1630496 | 1630496 | 2021-08-18 | Montour | Pennsylvania | 42093 | 2046 | 67 |
1627249 | 1627249 | 2021-08-17 | Montour | Pennsylvania | 42093 | 2044 | 67 |
1624002 | 1624002 | 2021-08-16 | Montour | Pennsylvania | 42093 | 2044 | 67 |
1620755 | 1620755 | 2021-08-15 | Montour | Pennsylvania | 42093 | 2044 | 67 |
1617507 | 1617507 | 2021-08-14 | Montour | Pennsylvania | 42093 | 2044 | 67 |
1614259 | 1614259 | 2021-08-13 | Montour | Pennsylvania | 42093 | 2041 | 67 |
1611010 | 1611010 | 2021-08-12 | Montour | Pennsylvania | 42093 | 2039 | 67 |
1607762 | 1607762 | 2021-08-11 | Montour | Pennsylvania | 42093 | 2036 | 67 |
1604513 | 1604513 | 2021-08-10 | Montour | Pennsylvania | 42093 | 2036 | 67 |
1601264 | 1601264 | 2021-08-09 | Montour | Pennsylvania | 42093 | 2034 | 67 |
1598016 | 1598016 | 2021-08-08 | Montour | Pennsylvania | 42093 | 2031 | 67 |
1594767 | 1594767 | 2021-08-07 | Montour | Pennsylvania | 42093 | 2031 | 67 |
1591518 | 1591518 | 2021-08-06 | Montour | Pennsylvania | 42093 | 2030 | 67 |
1588269 | 1588269 | 2021-08-05 | Montour | Pennsylvania | 42093 | 2028 | 67 |
1585019 | 1585019 | 2021-08-04 | Montour | Pennsylvania | 42093 | 2027 | 67 |
1581769 | 1581769 | 2021-08-03 | Montour | Pennsylvania | 42093 | 2027 | 67 |
1578520 | 1578520 | 2021-08-02 | Montour | Pennsylvania | 42093 | 2017 | 67 |
1575272 | 1575272 | 2021-08-01 | Montour | Pennsylvania | 42093 | 2017 | 67 |
1572024 | 1572024 | 2021-07-31 | Montour | Pennsylvania | 42093 | 2013 | 67 |
1568776 | 1568776 | 2021-07-30 | Montour | Pennsylvania | 42093 | 2013 | 67 |
1565528 | 1565528 | 2021-07-29 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1562280 | 1562280 | 2021-07-28 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1559032 | 1559032 | 2021-07-27 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1555785 | 1555785 | 2021-07-26 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1552538 | 1552538 | 2021-07-25 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1549291 | 1549291 | 2021-07-24 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1546044 | 1546044 | 2021-07-23 | Montour | Pennsylvania | 42093 | 2011 | 67 |
1542797 | 1542797 | 2021-07-22 | Montour | Pennsylvania | 42093 | 2011 | 67 |
1539549 | 1539549 | 2021-07-21 | Montour | Pennsylvania | 42093 | 2011 | 67 |
1536302 | 1536302 | 2021-07-20 | Montour | Pennsylvania | 42093 | 2011 | 67 |
1533054 | 1533054 | 2021-07-19 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1529807 | 1529807 | 2021-07-18 | Montour | Pennsylvania | 42093 | 2012 | 67 |
1526560 | 1526560 | 2021-07-17 | Montour | Pennsylvania | 42093 | 2011 | 67 |
1523313 | 1523313 | 2021-07-16 | Montour | Pennsylvania | 42093 | 2011 | 67 |
1520065 | 1520065 | 2021-07-15 | Montour | Pennsylvania | 42093 | 2011 | 67 |
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);