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 |
---|---|---|---|---|---|---|---|
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 |
1461206 | 1461206 | 2021-06-27 | Rensselaer | New York | 36083 | 11247 | 143 |
1457961 | 1457961 | 2021-06-26 | Rensselaer | New York | 36083 | 11244 | 143 |
1454716 | 1454716 | 2021-06-25 | Rensselaer | New York | 36083 | 11244 | 143 |
1451471 | 1451471 | 2021-06-24 | Rensselaer | New York | 36083 | 11244 | 143 |
1448225 | 1448225 | 2021-06-23 | Rensselaer | New York | 36083 | 11242 | 143 |
1444980 | 1444980 | 2021-06-22 | Rensselaer | New York | 36083 | 11239 | 143 |
1441735 | 1441735 | 2021-06-21 | Rensselaer | New York | 36083 | 11239 | 143 |
1438490 | 1438490 | 2021-06-20 | Rensselaer | New York | 36083 | 11238 | 143 |
1435243 | 1435243 | 2021-06-19 | Rensselaer | New York | 36083 | 11235 | 143 |
1431996 | 1431996 | 2021-06-18 | Rensselaer | New York | 36083 | 11232 | 143 |
1428750 | 1428750 | 2021-06-17 | Rensselaer | New York | 36083 | 11229 | 142 |
1425505 | 1425505 | 2021-06-16 | Rensselaer | New York | 36083 | 11229 | 142 |
1422258 | 1422258 | 2021-06-15 | Rensselaer | New York | 36083 | 11229 | 142 |
1419012 | 1419012 | 2021-06-14 | Rensselaer | New York | 36083 | 11228 | 142 |
1415767 | 1415767 | 2021-06-13 | Rensselaer | New York | 36083 | 11225 | 142 |
1412521 | 1412521 | 2021-06-12 | Rensselaer | New York | 36083 | 11223 | 142 |
1409276 | 1409276 | 2021-06-11 | Rensselaer | New York | 36083 | 11222 | 142 |
1406031 | 1406031 | 2021-06-10 | Rensselaer | New York | 36083 | 11220 | 142 |
1402785 | 1402785 | 2021-06-09 | Rensselaer | New York | 36083 | 11217 | 142 |
1399540 | 1399540 | 2021-06-08 | Rensselaer | New York | 36083 | 11217 | 142 |
1396295 | 1396295 | 2021-06-07 | Rensselaer | New York | 36083 | 11215 | 142 |
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);