ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36105 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 |
---|---|---|---|---|---|---|---|
1717788 | 1717788 | 2021-09-14 | Sullivan | New York | 36105 | 7632 | 79 |
1714540 | 1714540 | 2021-09-13 | Sullivan | New York | 36105 | 7620 | 79 |
1711294 | 1711294 | 2021-09-12 | Sullivan | New York | 36105 | 7602 | 79 |
1708047 | 1708047 | 2021-09-11 | Sullivan | New York | 36105 | 7578 | 79 |
1704800 | 1704800 | 2021-09-10 | Sullivan | New York | 36105 | 7549 | 79 |
1701550 | 1701550 | 2021-09-09 | Sullivan | New York | 36105 | 7522 | 79 |
1698301 | 1698301 | 2021-09-08 | Sullivan | New York | 36105 | 7501 | 79 |
1695053 | 1695053 | 2021-09-07 | Sullivan | New York | 36105 | 7480 | 79 |
1691805 | 1691805 | 2021-09-06 | Sullivan | New York | 36105 | 7464 | 79 |
1688555 | 1688555 | 2021-09-05 | Sullivan | New York | 36105 | 7450 | 79 |
1685305 | 1685305 | 2021-09-04 | Sullivan | New York | 36105 | 7423 | 78 |
1682054 | 1682054 | 2021-09-03 | Sullivan | New York | 36105 | 7397 | 78 |
1678805 | 1678805 | 2021-09-02 | Sullivan | New York | 36105 | 7373 | 78 |
1675557 | 1675557 | 2021-09-01 | Sullivan | New York | 36105 | 7347 | 77 |
1672310 | 1672310 | 2021-08-31 | Sullivan | New York | 36105 | 7321 | 77 |
1669062 | 1669062 | 2021-08-30 | Sullivan | New York | 36105 | 7302 | 77 |
1665815 | 1665815 | 2021-08-29 | Sullivan | New York | 36105 | 7290 | 77 |
1662567 | 1662567 | 2021-08-28 | Sullivan | New York | 36105 | 7273 | 77 |
1659319 | 1659319 | 2021-08-27 | Sullivan | New York | 36105 | 7254 | 76 |
1656070 | 1656070 | 2021-08-26 | Sullivan | New York | 36105 | 7225 | 76 |
1652823 | 1652823 | 2021-08-25 | Sullivan | New York | 36105 | 7192 | 76 |
1649575 | 1649575 | 2021-08-24 | Sullivan | New York | 36105 | 7175 | 76 |
1646326 | 1646326 | 2021-08-23 | Sullivan | New York | 36105 | 7168 | 76 |
1643077 | 1643077 | 2021-08-22 | Sullivan | New York | 36105 | 7143 | 76 |
1639827 | 1639827 | 2021-08-21 | Sullivan | New York | 36105 | 7130 | 76 |
1636577 | 1636577 | 2021-08-20 | Sullivan | New York | 36105 | 7110 | 76 |
1633327 | 1633327 | 2021-08-19 | Sullivan | New York | 36105 | 7092 | 76 |
1630080 | 1630080 | 2021-08-18 | Sullivan | New York | 36105 | 7064 | 76 |
1626833 | 1626833 | 2021-08-17 | Sullivan | New York | 36105 | 7040 | 76 |
1623586 | 1623586 | 2021-08-16 | Sullivan | New York | 36105 | 7021 | 76 |
1620339 | 1620339 | 2021-08-15 | Sullivan | New York | 36105 | 7001 | 76 |
1617091 | 1617091 | 2021-08-14 | Sullivan | New York | 36105 | 6989 | 76 |
1613843 | 1613843 | 2021-08-13 | Sullivan | New York | 36105 | 6965 | 76 |
1610594 | 1610594 | 2021-08-12 | Sullivan | New York | 36105 | 6947 | 76 |
1607346 | 1607346 | 2021-08-11 | Sullivan | New York | 36105 | 6935 | 76 |
1604097 | 1604097 | 2021-08-10 | Sullivan | New York | 36105 | 6914 | 76 |
1600848 | 1600848 | 2021-08-09 | Sullivan | New York | 36105 | 6900 | 76 |
1597600 | 1597600 | 2021-08-08 | Sullivan | New York | 36105 | 6894 | 76 |
1594351 | 1594351 | 2021-08-07 | Sullivan | New York | 36105 | 6873 | 76 |
1591102 | 1591102 | 2021-08-06 | Sullivan | New York | 36105 | 6857 | 76 |
1587853 | 1587853 | 2021-08-05 | Sullivan | New York | 36105 | 6841 | 76 |
1584603 | 1584603 | 2021-08-04 | Sullivan | New York | 36105 | 6827 | 76 |
1581353 | 1581353 | 2021-08-03 | Sullivan | New York | 36105 | 6812 | 76 |
1578104 | 1578104 | 2021-08-02 | Sullivan | New York | 36105 | 6800 | 76 |
1574856 | 1574856 | 2021-08-01 | Sullivan | New York | 36105 | 6792 | 76 |
1571608 | 1571608 | 2021-07-31 | Sullivan | New York | 36105 | 6779 | 76 |
1568360 | 1568360 | 2021-07-30 | Sullivan | New York | 36105 | 6769 | 76 |
1565112 | 1565112 | 2021-07-29 | Sullivan | New York | 36105 | 6758 | 76 |
1561864 | 1561864 | 2021-07-28 | Sullivan | New York | 36105 | 6752 | 76 |
1558616 | 1558616 | 2021-07-27 | Sullivan | New York | 36105 | 6744 | 76 |
1555369 | 1555369 | 2021-07-26 | Sullivan | New York | 36105 | 6744 | 76 |
1552122 | 1552122 | 2021-07-25 | Sullivan | New York | 36105 | 6741 | 76 |
1548875 | 1548875 | 2021-07-24 | Sullivan | New York | 36105 | 6735 | 76 |
1545628 | 1545628 | 2021-07-23 | Sullivan | New York | 36105 | 6728 | 76 |
1542381 | 1542381 | 2021-07-22 | Sullivan | New York | 36105 | 6728 | 76 |
1539133 | 1539133 | 2021-07-21 | Sullivan | New York | 36105 | 6722 | 76 |
1535886 | 1535886 | 2021-07-20 | Sullivan | New York | 36105 | 6721 | 76 |
1532638 | 1532638 | 2021-07-19 | Sullivan | New York | 36105 | 6718 | 76 |
1529391 | 1529391 | 2021-07-18 | Sullivan | New York | 36105 | 6717 | 76 |
1526144 | 1526144 | 2021-07-17 | Sullivan | New York | 36105 | 6715 | 76 |
1522897 | 1522897 | 2021-07-16 | Sullivan | New York | 36105 | 6713 | 76 |
1519649 | 1519649 | 2021-07-15 | Sullivan | New York | 36105 | 6712 | 76 |
1516401 | 1516401 | 2021-07-14 | Sullivan | New York | 36105 | 6712 | 76 |
1513154 | 1513154 | 2021-07-13 | Sullivan | New York | 36105 | 6711 | 76 |
1509908 | 1509908 | 2021-07-12 | Sullivan | New York | 36105 | 6710 | 76 |
1506661 | 1506661 | 2021-07-11 | Sullivan | New York | 36105 | 6709 | 76 |
1503415 | 1503415 | 2021-07-10 | Sullivan | New York | 36105 | 6704 | 76 |
1500169 | 1500169 | 2021-07-09 | Sullivan | New York | 36105 | 6703 | 76 |
1496923 | 1496923 | 2021-07-08 | Sullivan | New York | 36105 | 6702 | 76 |
1493676 | 1493676 | 2021-07-07 | Sullivan | New York | 36105 | 6701 | 76 |
1490429 | 1490429 | 2021-07-06 | Sullivan | New York | 36105 | 6699 | 76 |
1487182 | 1487182 | 2021-07-05 | Sullivan | New York | 36105 | 6699 | 76 |
1483936 | 1483936 | 2021-07-04 | Sullivan | New York | 36105 | 6699 | 76 |
1480690 | 1480690 | 2021-07-03 | Sullivan | New York | 36105 | 6696 | 76 |
1477443 | 1477443 | 2021-07-02 | Sullivan | New York | 36105 | 6693 | 76 |
1474197 | 1474197 | 2021-07-01 | Sullivan | New York | 36105 | 6693 | 76 |
1470951 | 1470951 | 2021-06-30 | Sullivan | New York | 36105 | 6692 | 76 |
1467706 | 1467706 | 2021-06-29 | Sullivan | New York | 36105 | 6691 | 76 |
1464461 | 1464461 | 2021-06-28 | Sullivan | New York | 36105 | 6691 | 76 |
1461216 | 1461216 | 2021-06-27 | Sullivan | New York | 36105 | 6691 | 76 |
1457971 | 1457971 | 2021-06-26 | Sullivan | New York | 36105 | 6689 | 76 |
1454726 | 1454726 | 2021-06-25 | Sullivan | New York | 36105 | 6686 | 76 |
1451481 | 1451481 | 2021-06-24 | Sullivan | New York | 36105 | 6686 | 76 |
1448235 | 1448235 | 2021-06-23 | Sullivan | New York | 36105 | 6686 | 76 |
1444990 | 1444990 | 2021-06-22 | Sullivan | New York | 36105 | 6684 | 76 |
1441745 | 1441745 | 2021-06-21 | Sullivan | New York | 36105 | 6683 | 76 |
1438500 | 1438500 | 2021-06-20 | Sullivan | New York | 36105 | 6681 | 76 |
1435253 | 1435253 | 2021-06-19 | Sullivan | New York | 36105 | 6679 | 76 |
1432006 | 1432006 | 2021-06-18 | Sullivan | New York | 36105 | 6676 | 76 |
1428760 | 1428760 | 2021-06-17 | Sullivan | New York | 36105 | 6674 | 76 |
1425515 | 1425515 | 2021-06-16 | Sullivan | New York | 36105 | 6674 | 76 |
1422268 | 1422268 | 2021-06-15 | Sullivan | New York | 36105 | 6673 | 76 |
1419022 | 1419022 | 2021-06-14 | Sullivan | New York | 36105 | 6672 | 76 |
1415777 | 1415777 | 2021-06-13 | Sullivan | New York | 36105 | 6672 | 76 |
1412531 | 1412531 | 2021-06-12 | Sullivan | New York | 36105 | 6670 | 75 |
1409286 | 1409286 | 2021-06-11 | Sullivan | New York | 36105 | 6670 | 75 |
1406041 | 1406041 | 2021-06-10 | Sullivan | New York | 36105 | 6668 | 74 |
1402795 | 1402795 | 2021-06-09 | Sullivan | New York | 36105 | 6666 | 74 |
1399550 | 1399550 | 2021-06-08 | Sullivan | New York | 36105 | 6661 | 74 |
1396305 | 1396305 | 2021-06-07 | Sullivan | New York | 36105 | 6661 | 74 |
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);