ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Rensselaer" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1786010 | 1786010 | 2021-10-05 | Rensselaer | New York | 36083 | 13946 | 160 |
1782761 | 1782761 | 2021-10-04 | Rensselaer | New York | 36083 | 13903 | 160 |
1779512 | 1779512 | 2021-10-03 | Rensselaer | New York | 36083 | 13879 | 158 |
1776262 | 1776262 | 2021-10-02 | Rensselaer | New York | 36083 | 13823 | 157 |
1773012 | 1773012 | 2021-10-01 | Rensselaer | New York | 36083 | 13771 | 157 |
1769762 | 1769762 | 2021-09-30 | Rensselaer | New York | 36083 | 13708 | 156 |
1766513 | 1766513 | 2021-09-29 | Rensselaer | New York | 36083 | 13657 | 156 |
1763264 | 1763264 | 2021-09-28 | Rensselaer | New York | 36083 | 13604 | 156 |
1760015 | 1760015 | 2021-09-27 | Rensselaer | New York | 36083 | 13565 | 156 |
1756767 | 1756767 | 2021-09-26 | Rensselaer | New York | 36083 | 13522 | 155 |
1753519 | 1753519 | 2021-09-25 | Rensselaer | New York | 36083 | 13483 | 155 |
1750271 | 1750271 | 2021-09-24 | Rensselaer | New York | 36083 | 13442 | 155 |
1747021 | 1747021 | 2021-09-23 | Rensselaer | New York | 36083 | 13364 | 154 |
1743772 | 1743772 | 2021-09-22 | Rensselaer | New York | 36083 | 13319 | 154 |
1740523 | 1740523 | 2021-09-21 | Rensselaer | New York | 36083 | 13276 | 154 |
1737274 | 1737274 | 2021-09-20 | Rensselaer | New York | 36083 | 13209 | 154 |
1734024 | 1734024 | 2021-09-19 | Rensselaer | New York | 36083 | 13180 | 154 |
1730774 | 1730774 | 2021-09-18 | Rensselaer | New York | 36083 | 13126 | 154 |
1727524 | 1727524 | 2021-09-17 | Rensselaer | New York | 36083 | 13084 | 154 |
1724275 | 1724275 | 2021-09-16 | Rensselaer | New York | 36083 | 13038 | 154 |
1721026 | 1721026 | 2021-09-15 | Rensselaer | New York | 36083 | 12971 | 154 |
1717778 | 1717778 | 2021-09-14 | Rensselaer | New York | 36083 | 12944 | 154 |
1714530 | 1714530 | 2021-09-13 | Rensselaer | New York | 36083 | 12913 | 154 |
1711284 | 1711284 | 2021-09-12 | Rensselaer | New York | 36083 | 12874 | 154 |
1708037 | 1708037 | 2021-09-11 | Rensselaer | New York | 36083 | 12838 | 154 |
1704790 | 1704790 | 2021-09-10 | Rensselaer | New York | 36083 | 12780 | 154 |
1701540 | 1701540 | 2021-09-09 | Rensselaer | New York | 36083 | 12738 | 154 |
1698291 | 1698291 | 2021-09-08 | Rensselaer | New York | 36083 | 12694 | 154 |
1695043 | 1695043 | 2021-09-07 | Rensselaer | New York | 36083 | 12667 | 154 |
1691795 | 1691795 | 2021-09-06 | Rensselaer | New York | 36083 | 12642 | 153 |
1688545 | 1688545 | 2021-09-05 | Rensselaer | New York | 36083 | 12601 | 153 |
1685295 | 1685295 | 2021-09-04 | Rensselaer | New York | 36083 | 12570 | 153 |
1682044 | 1682044 | 2021-09-03 | Rensselaer | New York | 36083 | 12512 | 153 |
1678795 | 1678795 | 2021-09-02 | Rensselaer | New York | 36083 | 12458 | 153 |
1675547 | 1675547 | 2021-09-01 | Rensselaer | New York | 36083 | 12422 | 153 |
1672300 | 1672300 | 2021-08-31 | Rensselaer | New York | 36083 | 12386 | 153 |
1669052 | 1669052 | 2021-08-30 | Rensselaer | New York | 36083 | 12351 | 153 |
1665805 | 1665805 | 2021-08-29 | Rensselaer | New York | 36083 | 12315 | 152 |
1662557 | 1662557 | 2021-08-28 | Rensselaer | New York | 36083 | 12278 | 152 |
1659309 | 1659309 | 2021-08-27 | Rensselaer | New York | 36083 | 12237 | 152 |
1656060 | 1656060 | 2021-08-26 | Rensselaer | New York | 36083 | 12166 | 150 |
1652813 | 1652813 | 2021-08-25 | Rensselaer | New York | 36083 | 12143 | 150 |
1649565 | 1649565 | 2021-08-24 | Rensselaer | New York | 36083 | 12121 | 150 |
1646316 | 1646316 | 2021-08-23 | Rensselaer | New York | 36083 | 12099 | 149 |
1643067 | 1643067 | 2021-08-22 | Rensselaer | New York | 36083 | 12067 | 149 |
1639817 | 1639817 | 2021-08-21 | Rensselaer | New York | 36083 | 12039 | 148 |
1636567 | 1636567 | 2021-08-20 | Rensselaer | New York | 36083 | 11991 | 148 |
1633317 | 1633317 | 2021-08-19 | Rensselaer | New York | 36083 | 11955 | 148 |
1630070 | 1630070 | 2021-08-18 | Rensselaer | New York | 36083 | 11926 | 147 |
1626823 | 1626823 | 2021-08-17 | Rensselaer | New York | 36083 | 11888 | 147 |
1623576 | 1623576 | 2021-08-16 | Rensselaer | New York | 36083 | 11859 | 146 |
1620329 | 1620329 | 2021-08-15 | Rensselaer | New York | 36083 | 11828 | 146 |
1617081 | 1617081 | 2021-08-14 | Rensselaer | New York | 36083 | 11793 | 146 |
1613833 | 1613833 | 2021-08-13 | Rensselaer | New York | 36083 | 11755 | 145 |
1610584 | 1610584 | 2021-08-12 | Rensselaer | New York | 36083 | 11720 | 145 |
1607336 | 1607336 | 2021-08-11 | Rensselaer | New York | 36083 | 11687 | 145 |
1604087 | 1604087 | 2021-08-10 | Rensselaer | New York | 36083 | 11662 | 145 |
1600838 | 1600838 | 2021-08-09 | Rensselaer | New York | 36083 | 11639 | 145 |
1597590 | 1597590 | 2021-08-08 | Rensselaer | New York | 36083 | 11625 | 145 |
1594341 | 1594341 | 2021-08-07 | Rensselaer | New York | 36083 | 11604 | 145 |
1591092 | 1591092 | 2021-08-06 | Rensselaer | New York | 36083 | 11557 | 145 |
1587843 | 1587843 | 2021-08-05 | Rensselaer | New York | 36083 | 11530 | 145 |
1584593 | 1584593 | 2021-08-04 | Rensselaer | New York | 36083 | 11506 | 145 |
1581343 | 1581343 | 2021-08-03 | Rensselaer | New York | 36083 | 11494 | 145 |
1578094 | 1578094 | 2021-08-02 | Rensselaer | New York | 36083 | 11474 | 145 |
1574846 | 1574846 | 2021-08-01 | Rensselaer | New York | 36083 | 11463 | 145 |
1571598 | 1571598 | 2021-07-31 | Rensselaer | New York | 36083 | 11439 | 145 |
1568350 | 1568350 | 2021-07-30 | Rensselaer | New York | 36083 | 11422 | 145 |
1565102 | 1565102 | 2021-07-29 | Rensselaer | New York | 36083 | 11405 | 145 |
1561854 | 1561854 | 2021-07-28 | Rensselaer | New York | 36083 | 11390 | 145 |
1558606 | 1558606 | 2021-07-27 | Rensselaer | New York | 36083 | 11370 | 145 |
1555359 | 1555359 | 2021-07-26 | Rensselaer | New York | 36083 | 11355 | 145 |
1552112 | 1552112 | 2021-07-25 | Rensselaer | New York | 36083 | 11347 | 145 |
1548865 | 1548865 | 2021-07-24 | Rensselaer | New York | 36083 | 11333 | 144 |
1545618 | 1545618 | 2021-07-23 | Rensselaer | New York | 36083 | 11329 | 144 |
1542371 | 1542371 | 2021-07-22 | Rensselaer | New York | 36083 | 11320 | 144 |
1539123 | 1539123 | 2021-07-21 | Rensselaer | New York | 36083 | 11314 | 144 |
1535876 | 1535876 | 2021-07-20 | Rensselaer | New York | 36083 | 11311 | 144 |
1532628 | 1532628 | 2021-07-19 | Rensselaer | New York | 36083 | 11305 | 144 |
1529381 | 1529381 | 2021-07-18 | Rensselaer | New York | 36083 | 11302 | 144 |
1526134 | 1526134 | 2021-07-17 | Rensselaer | New York | 36083 | 11293 | 144 |
1522887 | 1522887 | 2021-07-16 | Rensselaer | New York | 36083 | 11288 | 144 |
1519639 | 1519639 | 2021-07-15 | Rensselaer | New York | 36083 | 11282 | 144 |
1516391 | 1516391 | 2021-07-14 | Rensselaer | New York | 36083 | 11277 | 144 |
1513144 | 1513144 | 2021-07-13 | Rensselaer | New York | 36083 | 11273 | 144 |
1509898 | 1509898 | 2021-07-12 | Rensselaer | New York | 36083 | 11271 | 144 |
1506651 | 1506651 | 2021-07-11 | Rensselaer | New York | 36083 | 11264 | 144 |
1503405 | 1503405 | 2021-07-10 | Rensselaer | New York | 36083 | 11262 | 144 |
1500159 | 1500159 | 2021-07-09 | Rensselaer | New York | 36083 | 11259 | 144 |
1496913 | 1496913 | 2021-07-08 | Rensselaer | New York | 36083 | 11254 | 144 |
1493666 | 1493666 | 2021-07-07 | Rensselaer | New York | 36083 | 11253 | 144 |
1490419 | 1490419 | 2021-07-06 | Rensselaer | New York | 36083 | 11253 | 144 |
1487172 | 1487172 | 2021-07-05 | Rensselaer | New York | 36083 | 11253 | 144 |
1483926 | 1483926 | 2021-07-04 | Rensselaer | New York | 36083 | 11252 | 144 |
1480680 | 1480680 | 2021-07-03 | Rensselaer | New York | 36083 | 11252 | 144 |
1477433 | 1477433 | 2021-07-02 | Rensselaer | New York | 36083 | 11252 | 144 |
1474187 | 1474187 | 2021-07-01 | Rensselaer | New York | 36083 | 11251 | 144 |
1470941 | 1470941 | 2021-06-30 | Rensselaer | New York | 36083 | 11249 | 144 |
1467696 | 1467696 | 2021-06-29 | Rensselaer | New York | 36083 | 11247 | 143 |
1464451 | 1464451 | 2021-06-28 | Rensselaer | New York | 36083 | 11247 | 143 |
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);