ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Albany" 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 |
---|---|---|---|---|---|---|---|
1717740 | 1717740 | 2021-09-14 | Albany | New York | 36001 | 27817 | 368 |
1714492 | 1714492 | 2021-09-13 | Albany | New York | 36001 | 27769 | 367 |
1711246 | 1711246 | 2021-09-12 | Albany | New York | 36001 | 27705 | 366 |
1707999 | 1707999 | 2021-09-11 | Albany | New York | 36001 | 27638 | 366 |
1704752 | 1704752 | 2021-09-10 | Albany | New York | 36001 | 27571 | 366 |
1701502 | 1701502 | 2021-09-09 | Albany | New York | 36001 | 27481 | 366 |
1698253 | 1698253 | 2021-09-08 | Albany | New York | 36001 | 27400 | 366 |
1695005 | 1695005 | 2021-09-07 | Albany | New York | 36001 | 27355 | 366 |
1691757 | 1691757 | 2021-09-06 | Albany | New York | 36001 | 27306 | 366 |
1688507 | 1688507 | 2021-09-05 | Albany | New York | 36001 | 27252 | 365 |
1685257 | 1685257 | 2021-09-04 | Albany | New York | 36001 | 27200 | 365 |
1682006 | 1682006 | 2021-09-03 | Albany | New York | 36001 | 27109 | 365 |
1678757 | 1678757 | 2021-09-02 | Albany | New York | 36001 | 27020 | 364 |
1675509 | 1675509 | 2021-09-01 | Albany | New York | 36001 | 26925 | 364 |
1672262 | 1672262 | 2021-08-31 | Albany | New York | 36001 | 26861 | 363 |
1669014 | 1669014 | 2021-08-30 | Albany | New York | 36001 | 26799 | 363 |
1665767 | 1665767 | 2021-08-29 | Albany | New York | 36001 | 26732 | 363 |
1662519 | 1662519 | 2021-08-28 | Albany | New York | 36001 | 26659 | 360 |
1659271 | 1659271 | 2021-08-27 | Albany | New York | 36001 | 26569 | 360 |
1656022 | 1656022 | 2021-08-26 | Albany | New York | 36001 | 26448 | 360 |
1652775 | 1652775 | 2021-08-25 | Albany | New York | 36001 | 26382 | 360 |
1649527 | 1649527 | 2021-08-24 | Albany | New York | 36001 | 26319 | 359 |
1646278 | 1646278 | 2021-08-23 | Albany | New York | 36001 | 26273 | 359 |
1643029 | 1643029 | 2021-08-22 | Albany | New York | 36001 | 26231 | 359 |
1639779 | 1639779 | 2021-08-21 | Albany | New York | 36001 | 26171 | 359 |
1636529 | 1636529 | 2021-08-20 | Albany | New York | 36001 | 26089 | 359 |
1633279 | 1633279 | 2021-08-19 | Albany | New York | 36001 | 26017 | 358 |
1630032 | 1630032 | 2021-08-18 | Albany | New York | 36001 | 25965 | 358 |
1626785 | 1626785 | 2021-08-17 | Albany | New York | 36001 | 25903 | 358 |
1623538 | 1623538 | 2021-08-16 | Albany | New York | 36001 | 25847 | 358 |
1620291 | 1620291 | 2021-08-15 | Albany | New York | 36001 | 25808 | 358 |
1617043 | 1617043 | 2021-08-14 | Albany | New York | 36001 | 25741 | 358 |
1613795 | 1613795 | 2021-08-13 | Albany | New York | 36001 | 25670 | 358 |
1610546 | 1610546 | 2021-08-12 | Albany | New York | 36001 | 25607 | 358 |
1607298 | 1607298 | 2021-08-11 | Albany | New York | 36001 | 25565 | 358 |
1604049 | 1604049 | 2021-08-10 | Albany | New York | 36001 | 25510 | 358 |
1600800 | 1600800 | 2021-08-09 | Albany | New York | 36001 | 25468 | 358 |
1597552 | 1597552 | 2021-08-08 | Albany | New York | 36001 | 25410 | 358 |
1594303 | 1594303 | 2021-08-07 | Albany | New York | 36001 | 25376 | 358 |
1591054 | 1591054 | 2021-08-06 | Albany | New York | 36001 | 25297 | 358 |
1587805 | 1587805 | 2021-08-05 | Albany | New York | 36001 | 25237 | 358 |
1584555 | 1584555 | 2021-08-04 | Albany | New York | 36001 | 25200 | 358 |
1581305 | 1581305 | 2021-08-03 | Albany | New York | 36001 | 25156 | 358 |
1578056 | 1578056 | 2021-08-02 | Albany | New York | 36001 | 25107 | 358 |
1574808 | 1574808 | 2021-08-01 | Albany | New York | 36001 | 25085 | 358 |
1571560 | 1571560 | 2021-07-31 | Albany | New York | 36001 | 25059 | 358 |
1568312 | 1568312 | 2021-07-30 | Albany | New York | 36001 | 25027 | 358 |
1565064 | 1565064 | 2021-07-29 | Albany | New York | 36001 | 25001 | 358 |
1561816 | 1561816 | 2021-07-28 | Albany | New York | 36001 | 24965 | 358 |
1558568 | 1558568 | 2021-07-27 | Albany | New York | 36001 | 24943 | 358 |
1555321 | 1555321 | 2021-07-26 | Albany | New York | 36001 | 24924 | 358 |
1552074 | 1552074 | 2021-07-25 | Albany | New York | 36001 | 24917 | 358 |
1548827 | 1548827 | 2021-07-24 | Albany | New York | 36001 | 24893 | 358 |
1545580 | 1545580 | 2021-07-23 | Albany | New York | 36001 | 24881 | 358 |
1542333 | 1542333 | 2021-07-22 | Albany | New York | 36001 | 24859 | 358 |
1539085 | 1539085 | 2021-07-21 | Albany | New York | 36001 | 24842 | 358 |
1535838 | 1535838 | 2021-07-20 | Albany | New York | 36001 | 24831 | 358 |
1532590 | 1532590 | 2021-07-19 | Albany | New York | 36001 | 24823 | 358 |
1529343 | 1529343 | 2021-07-18 | Albany | New York | 36001 | 24810 | 358 |
1526096 | 1526096 | 2021-07-17 | Albany | New York | 36001 | 24800 | 357 |
1522849 | 1522849 | 2021-07-16 | Albany | New York | 36001 | 24795 | 357 |
1519601 | 1519601 | 2021-07-15 | Albany | New York | 36001 | 24786 | 357 |
1516353 | 1516353 | 2021-07-14 | Albany | New York | 36001 | 24778 | 357 |
1513106 | 1513106 | 2021-07-13 | Albany | New York | 36001 | 24770 | 357 |
1509860 | 1509860 | 2021-07-12 | Albany | New York | 36001 | 24767 | 357 |
1506613 | 1506613 | 2021-07-11 | Albany | New York | 36001 | 24758 | 357 |
1503367 | 1503367 | 2021-07-10 | Albany | New York | 36001 | 24753 | 357 |
1500121 | 1500121 | 2021-07-09 | Albany | New York | 36001 | 24748 | 357 |
1496875 | 1496875 | 2021-07-08 | Albany | New York | 36001 | 24746 | 357 |
1493628 | 1493628 | 2021-07-07 | Albany | New York | 36001 | 24740 | 357 |
1490381 | 1490381 | 2021-07-06 | Albany | New York | 36001 | 24740 | 357 |
1487134 | 1487134 | 2021-07-05 | Albany | New York | 36001 | 24739 | 357 |
1483888 | 1483888 | 2021-07-04 | Albany | New York | 36001 | 24739 | 357 |
1480642 | 1480642 | 2021-07-03 | Albany | New York | 36001 | 24737 | 357 |
1477395 | 1477395 | 2021-07-02 | Albany | New York | 36001 | 24736 | 357 |
1474149 | 1474149 | 2021-07-01 | Albany | New York | 36001 | 24735 | 357 |
1470903 | 1470903 | 2021-06-30 | Albany | New York | 36001 | 24734 | 357 |
1467658 | 1467658 | 2021-06-29 | Albany | New York | 36001 | 24733 | 357 |
1464413 | 1464413 | 2021-06-28 | Albany | New York | 36001 | 24733 | 357 |
1461168 | 1461168 | 2021-06-27 | Albany | New York | 36001 | 24729 | 357 |
1457923 | 1457923 | 2021-06-26 | Albany | New York | 36001 | 24728 | 357 |
1454678 | 1454678 | 2021-06-25 | Albany | New York | 36001 | 24726 | 357 |
1451433 | 1451433 | 2021-06-24 | Albany | New York | 36001 | 24723 | 357 |
1448187 | 1448187 | 2021-06-23 | Albany | New York | 36001 | 24722 | 357 |
1444942 | 1444942 | 2021-06-22 | Albany | New York | 36001 | 24719 | 357 |
1441697 | 1441697 | 2021-06-21 | Albany | New York | 36001 | 24718 | 357 |
1438452 | 1438452 | 2021-06-20 | Albany | New York | 36001 | 24716 | 357 |
1435205 | 1435205 | 2021-06-19 | Albany | New York | 36001 | 24712 | 357 |
1431958 | 1431958 | 2021-06-18 | Albany | New York | 36001 | 24708 | 356 |
1428712 | 1428712 | 2021-06-17 | Albany | New York | 36001 | 24703 | 356 |
1425467 | 1425467 | 2021-06-16 | Albany | New York | 36001 | 24700 | 356 |
1422220 | 1422220 | 2021-06-15 | Albany | New York | 36001 | 24699 | 356 |
1418974 | 1418974 | 2021-06-14 | Albany | New York | 36001 | 24696 | 356 |
1415729 | 1415729 | 2021-06-13 | Albany | New York | 36001 | 24694 | 356 |
1412483 | 1412483 | 2021-06-12 | Albany | New York | 36001 | 24689 | 356 |
1409238 | 1409238 | 2021-06-11 | Albany | New York | 36001 | 24687 | 355 |
1405993 | 1405993 | 2021-06-10 | Albany | New York | 36001 | 24685 | 355 |
1402747 | 1402747 | 2021-06-09 | Albany | New York | 36001 | 24682 | 355 |
1399502 | 1399502 | 2021-06-08 | Albany | New York | 36001 | 24678 | 355 |
1396257 | 1396257 | 2021-06-07 | Albany | New York | 36001 | 24675 | 355 |
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);