ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 36091 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 |
---|---|---|---|---|---|---|---|
1717780 | 1717780 | 2021-09-14 | Saratoga | New York | 36091 | 18033 | 184 |
1714532 | 1714532 | 2021-09-13 | Saratoga | New York | 36091 | 17988 | 184 |
1711286 | 1711286 | 2021-09-12 | Saratoga | New York | 36091 | 17949 | 184 |
1708039 | 1708039 | 2021-09-11 | Saratoga | New York | 36091 | 17888 | 182 |
1704792 | 1704792 | 2021-09-10 | Saratoga | New York | 36091 | 17793 | 181 |
1701542 | 1701542 | 2021-09-09 | Saratoga | New York | 36091 | 17742 | 180 |
1698293 | 1698293 | 2021-09-08 | Saratoga | New York | 36091 | 17692 | 180 |
1695045 | 1695045 | 2021-09-07 | Saratoga | New York | 36091 | 17650 | 180 |
1691797 | 1691797 | 2021-09-06 | Saratoga | New York | 36091 | 17606 | 180 |
1688547 | 1688547 | 2021-09-05 | Saratoga | New York | 36091 | 17551 | 180 |
1685297 | 1685297 | 2021-09-04 | Saratoga | New York | 36091 | 17498 | 180 |
1682046 | 1682046 | 2021-09-03 | Saratoga | New York | 36091 | 17422 | 180 |
1678797 | 1678797 | 2021-09-02 | Saratoga | New York | 36091 | 17350 | 179 |
1675549 | 1675549 | 2021-09-01 | Saratoga | New York | 36091 | 17274 | 178 |
1672302 | 1672302 | 2021-08-31 | Saratoga | New York | 36091 | 17230 | 177 |
1669054 | 1669054 | 2021-08-30 | Saratoga | New York | 36091 | 17190 | 177 |
1665807 | 1665807 | 2021-08-29 | Saratoga | New York | 36091 | 17139 | 177 |
1662559 | 1662559 | 2021-08-28 | Saratoga | New York | 36091 | 17100 | 177 |
1659311 | 1659311 | 2021-08-27 | Saratoga | New York | 36091 | 17048 | 177 |
1656062 | 1656062 | 2021-08-26 | Saratoga | New York | 36091 | 16945 | 176 |
1652815 | 1652815 | 2021-08-25 | Saratoga | New York | 36091 | 16885 | 176 |
1649567 | 1649567 | 2021-08-24 | Saratoga | New York | 36091 | 16844 | 175 |
1646318 | 1646318 | 2021-08-23 | Saratoga | New York | 36091 | 16805 | 174 |
1643069 | 1643069 | 2021-08-22 | Saratoga | New York | 36091 | 16757 | 174 |
1639819 | 1639819 | 2021-08-21 | Saratoga | New York | 36091 | 16703 | 174 |
1636569 | 1636569 | 2021-08-20 | Saratoga | New York | 36091 | 16642 | 173 |
1633319 | 1633319 | 2021-08-19 | Saratoga | New York | 36091 | 16580 | 173 |
1630072 | 1630072 | 2021-08-18 | Saratoga | New York | 36091 | 16516 | 173 |
1626825 | 1626825 | 2021-08-17 | Saratoga | New York | 36091 | 16471 | 173 |
1623578 | 1623578 | 2021-08-16 | Saratoga | New York | 36091 | 16437 | 173 |
1620331 | 1620331 | 2021-08-15 | Saratoga | New York | 36091 | 16408 | 173 |
1617083 | 1617083 | 2021-08-14 | Saratoga | New York | 36091 | 16359 | 172 |
1613835 | 1613835 | 2021-08-13 | Saratoga | New York | 36091 | 16312 | 172 |
1610586 | 1610586 | 2021-08-12 | Saratoga | New York | 36091 | 16218 | 172 |
1607338 | 1607338 | 2021-08-11 | Saratoga | New York | 36091 | 16179 | 170 |
1604089 | 1604089 | 2021-08-10 | Saratoga | New York | 36091 | 16137 | 170 |
1600840 | 1600840 | 2021-08-09 | Saratoga | New York | 36091 | 16100 | 170 |
1597592 | 1597592 | 2021-08-08 | Saratoga | New York | 36091 | 16066 | 170 |
1594343 | 1594343 | 2021-08-07 | Saratoga | New York | 36091 | 16024 | 170 |
1591094 | 1591094 | 2021-08-06 | Saratoga | New York | 36091 | 15966 | 169 |
1587845 | 1587845 | 2021-08-05 | Saratoga | New York | 36091 | 15931 | 168 |
1584595 | 1584595 | 2021-08-04 | Saratoga | New York | 36091 | 15880 | 168 |
1581345 | 1581345 | 2021-08-03 | Saratoga | New York | 36091 | 15842 | 168 |
1578096 | 1578096 | 2021-08-02 | Saratoga | New York | 36091 | 15810 | 168 |
1574848 | 1574848 | 2021-08-01 | Saratoga | New York | 36091 | 15786 | 168 |
1571600 | 1571600 | 2021-07-31 | Saratoga | New York | 36091 | 15767 | 168 |
1568352 | 1568352 | 2021-07-30 | Saratoga | New York | 36091 | 15729 | 168 |
1565104 | 1565104 | 2021-07-29 | Saratoga | New York | 36091 | 15691 | 168 |
1561856 | 1561856 | 2021-07-28 | Saratoga | New York | 36091 | 15651 | 168 |
1558608 | 1558608 | 2021-07-27 | Saratoga | New York | 36091 | 15621 | 168 |
1555361 | 1555361 | 2021-07-26 | Saratoga | New York | 36091 | 15596 | 168 |
1552114 | 1552114 | 2021-07-25 | Saratoga | New York | 36091 | 15586 | 168 |
1548867 | 1548867 | 2021-07-24 | Saratoga | New York | 36091 | 15563 | 168 |
1545620 | 1545620 | 2021-07-23 | Saratoga | New York | 36091 | 15543 | 168 |
1542373 | 1542373 | 2021-07-22 | Saratoga | New York | 36091 | 15524 | 168 |
1539125 | 1539125 | 2021-07-21 | Saratoga | New York | 36091 | 15511 | 168 |
1535878 | 1535878 | 2021-07-20 | Saratoga | New York | 36091 | 15498 | 168 |
1532630 | 1532630 | 2021-07-19 | Saratoga | New York | 36091 | 15487 | 168 |
1529383 | 1529383 | 2021-07-18 | Saratoga | New York | 36091 | 15478 | 168 |
1526136 | 1526136 | 2021-07-17 | Saratoga | New York | 36091 | 15468 | 168 |
1522889 | 1522889 | 2021-07-16 | Saratoga | New York | 36091 | 15459 | 168 |
1519641 | 1519641 | 2021-07-15 | Saratoga | New York | 36091 | 15455 | 168 |
1516393 | 1516393 | 2021-07-14 | Saratoga | New York | 36091 | 15447 | 168 |
1513146 | 1513146 | 2021-07-13 | Saratoga | New York | 36091 | 15440 | 168 |
1509900 | 1509900 | 2021-07-12 | Saratoga | New York | 36091 | 15433 | 168 |
1506653 | 1506653 | 2021-07-11 | Saratoga | New York | 36091 | 15432 | 168 |
1503407 | 1503407 | 2021-07-10 | Saratoga | New York | 36091 | 15429 | 168 |
1500161 | 1500161 | 2021-07-09 | Saratoga | New York | 36091 | 15426 | 168 |
1496915 | 1496915 | 2021-07-08 | Saratoga | New York | 36091 | 15423 | 168 |
1493668 | 1493668 | 2021-07-07 | Saratoga | New York | 36091 | 15420 | 168 |
1490421 | 1490421 | 2021-07-06 | Saratoga | New York | 36091 | 15418 | 168 |
1487174 | 1487174 | 2021-07-05 | Saratoga | New York | 36091 | 15417 | 168 |
1483928 | 1483928 | 2021-07-04 | Saratoga | New York | 36091 | 15417 | 168 |
1480682 | 1480682 | 2021-07-03 | Saratoga | New York | 36091 | 15415 | 168 |
1477435 | 1477435 | 2021-07-02 | Saratoga | New York | 36091 | 15415 | 168 |
1474189 | 1474189 | 2021-07-01 | Saratoga | New York | 36091 | 15414 | 168 |
1470943 | 1470943 | 2021-06-30 | Saratoga | New York | 36091 | 15412 | 168 |
1467698 | 1467698 | 2021-06-29 | Saratoga | New York | 36091 | 15409 | 168 |
1464453 | 1464453 | 2021-06-28 | Saratoga | New York | 36091 | 15404 | 168 |
1461208 | 1461208 | 2021-06-27 | Saratoga | New York | 36091 | 15403 | 168 |
1457963 | 1457963 | 2021-06-26 | Saratoga | New York | 36091 | 15401 | 168 |
1454718 | 1454718 | 2021-06-25 | Saratoga | New York | 36091 | 15400 | 168 |
1451473 | 1451473 | 2021-06-24 | Saratoga | New York | 36091 | 15399 | 168 |
1448227 | 1448227 | 2021-06-23 | Saratoga | New York | 36091 | 15398 | 168 |
1444982 | 1444982 | 2021-06-22 | Saratoga | New York | 36091 | 15396 | 168 |
1441737 | 1441737 | 2021-06-21 | Saratoga | New York | 36091 | 15393 | 168 |
1438492 | 1438492 | 2021-06-20 | Saratoga | New York | 36091 | 15391 | 168 |
1435245 | 1435245 | 2021-06-19 | Saratoga | New York | 36091 | 15389 | 168 |
1431998 | 1431998 | 2021-06-18 | Saratoga | New York | 36091 | 15379 | 168 |
1428752 | 1428752 | 2021-06-17 | Saratoga | New York | 36091 | 15376 | 168 |
1425507 | 1425507 | 2021-06-16 | Saratoga | New York | 36091 | 15367 | 168 |
1422260 | 1422260 | 2021-06-15 | Saratoga | New York | 36091 | 15364 | 168 |
1419014 | 1419014 | 2021-06-14 | Saratoga | New York | 36091 | 15362 | 168 |
1415769 | 1415769 | 2021-06-13 | Saratoga | New York | 36091 | 15359 | 168 |
1412523 | 1412523 | 2021-06-12 | Saratoga | New York | 36091 | 15357 | 168 |
1409278 | 1409278 | 2021-06-11 | Saratoga | New York | 36091 | 15352 | 168 |
1406033 | 1406033 | 2021-06-10 | Saratoga | New York | 36091 | 15350 | 168 |
1402787 | 1402787 | 2021-06-09 | Saratoga | New York | 36091 | 15349 | 168 |
1399542 | 1399542 | 2021-06-08 | Saratoga | New York | 36091 | 15347 | 168 |
1396297 | 1396297 | 2021-06-07 | Saratoga | New York | 36091 | 15342 | 168 |
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);