ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36079 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 |
---|---|---|---|---|---|---|---|
1717777 | 1717777 | 2021-09-14 | Putnam | New York | 36079 | 11628 | 95 |
1714529 | 1714529 | 2021-09-13 | Putnam | New York | 36079 | 11604 | 95 |
1711283 | 1711283 | 2021-09-12 | Putnam | New York | 36079 | 11580 | 95 |
1708036 | 1708036 | 2021-09-11 | Putnam | New York | 36079 | 11566 | 95 |
1704789 | 1704789 | 2021-09-10 | Putnam | New York | 36079 | 11556 | 95 |
1701539 | 1701539 | 2021-09-09 | Putnam | New York | 36079 | 11531 | 95 |
1698290 | 1698290 | 2021-09-08 | Putnam | New York | 36079 | 11516 | 95 |
1695042 | 1695042 | 2021-09-07 | Putnam | New York | 36079 | 11497 | 95 |
1691794 | 1691794 | 2021-09-06 | Putnam | New York | 36079 | 11483 | 95 |
1688544 | 1688544 | 2021-09-05 | Putnam | New York | 36079 | 11460 | 95 |
1685294 | 1685294 | 2021-09-04 | Putnam | New York | 36079 | 11442 | 95 |
1682043 | 1682043 | 2021-09-03 | Putnam | New York | 36079 | 11415 | 94 |
1678794 | 1678794 | 2021-09-02 | Putnam | New York | 36079 | 11402 | 94 |
1675546 | 1675546 | 2021-09-01 | Putnam | New York | 36079 | 11385 | 94 |
1672299 | 1672299 | 2021-08-31 | Putnam | New York | 36079 | 11338 | 94 |
1669051 | 1669051 | 2021-08-30 | Putnam | New York | 36079 | 11319 | 94 |
1665804 | 1665804 | 2021-08-29 | Putnam | New York | 36079 | 11300 | 94 |
1662556 | 1662556 | 2021-08-28 | Putnam | New York | 36079 | 11283 | 94 |
1659308 | 1659308 | 2021-08-27 | Putnam | New York | 36079 | 11261 | 94 |
1656059 | 1656059 | 2021-08-26 | Putnam | New York | 36079 | 11232 | 94 |
1652812 | 1652812 | 2021-08-25 | Putnam | New York | 36079 | 11203 | 94 |
1649564 | 1649564 | 2021-08-24 | Putnam | New York | 36079 | 11185 | 94 |
1646315 | 1646315 | 2021-08-23 | Putnam | New York | 36079 | 11176 | 94 |
1643066 | 1643066 | 2021-08-22 | Putnam | New York | 36079 | 11162 | 94 |
1639816 | 1639816 | 2021-08-21 | Putnam | New York | 36079 | 11134 | 94 |
1636566 | 1636566 | 2021-08-20 | Putnam | New York | 36079 | 11105 | 94 |
1633316 | 1633316 | 2021-08-19 | Putnam | New York | 36079 | 11081 | 94 |
1630069 | 1630069 | 2021-08-18 | Putnam | New York | 36079 | 11055 | 94 |
1626822 | 1626822 | 2021-08-17 | Putnam | New York | 36079 | 11034 | 94 |
1623575 | 1623575 | 2021-08-16 | Putnam | New York | 36079 | 11003 | 94 |
1620328 | 1620328 | 2021-08-15 | Putnam | New York | 36079 | 10993 | 94 |
1617080 | 1617080 | 2021-08-14 | Putnam | New York | 36079 | 10975 | 93 |
1613832 | 1613832 | 2021-08-13 | Putnam | New York | 36079 | 10948 | 93 |
1610583 | 1610583 | 2021-08-12 | Putnam | New York | 36079 | 10920 | 93 |
1607335 | 1607335 | 2021-08-11 | Putnam | New York | 36079 | 10894 | 93 |
1604086 | 1604086 | 2021-08-10 | Putnam | New York | 36079 | 10879 | 93 |
1600837 | 1600837 | 2021-08-09 | Putnam | New York | 36079 | 10868 | 93 |
1597589 | 1597589 | 2021-08-08 | Putnam | New York | 36079 | 10858 | 93 |
1594340 | 1594340 | 2021-08-07 | Putnam | New York | 36079 | 10842 | 93 |
1591091 | 1591091 | 2021-08-06 | Putnam | New York | 36079 | 10827 | 93 |
1587842 | 1587842 | 2021-08-05 | Putnam | New York | 36079 | 10808 | 93 |
1584592 | 1584592 | 2021-08-04 | Putnam | New York | 36079 | 10792 | 93 |
1581342 | 1581342 | 2021-08-03 | Putnam | New York | 36079 | 10783 | 93 |
1578093 | 1578093 | 2021-08-02 | Putnam | New York | 36079 | 10777 | 93 |
1574845 | 1574845 | 2021-08-01 | Putnam | New York | 36079 | 10768 | 93 |
1571597 | 1571597 | 2021-07-31 | Putnam | New York | 36079 | 10751 | 93 |
1568349 | 1568349 | 2021-07-30 | Putnam | New York | 36079 | 10737 | 93 |
1565101 | 1565101 | 2021-07-29 | Putnam | New York | 36079 | 10725 | 93 |
1561853 | 1561853 | 2021-07-28 | Putnam | New York | 36079 | 10712 | 93 |
1558605 | 1558605 | 2021-07-27 | Putnam | New York | 36079 | 10705 | 93 |
1555358 | 1555358 | 2021-07-26 | Putnam | New York | 36079 | 10700 | 93 |
1552111 | 1552111 | 2021-07-25 | Putnam | New York | 36079 | 10693 | 93 |
1548864 | 1548864 | 2021-07-24 | Putnam | New York | 36079 | 10682 | 93 |
1545617 | 1545617 | 2021-07-23 | Putnam | New York | 36079 | 10677 | 93 |
1542370 | 1542370 | 2021-07-22 | Putnam | New York | 36079 | 10667 | 93 |
1539122 | 1539122 | 2021-07-21 | Putnam | New York | 36079 | 10662 | 93 |
1535875 | 1535875 | 2021-07-20 | Putnam | New York | 36079 | 10659 | 93 |
1532627 | 1532627 | 2021-07-19 | Putnam | New York | 36079 | 10657 | 93 |
1529380 | 1529380 | 2021-07-18 | Putnam | New York | 36079 | 10653 | 93 |
1526133 | 1526133 | 2021-07-17 | Putnam | New York | 36079 | 10650 | 93 |
1522886 | 1522886 | 2021-07-16 | Putnam | New York | 36079 | 10648 | 93 |
1519638 | 1519638 | 2021-07-15 | Putnam | New York | 36079 | 10645 | 93 |
1516390 | 1516390 | 2021-07-14 | Putnam | New York | 36079 | 10641 | 93 |
1513143 | 1513143 | 2021-07-13 | Putnam | New York | 36079 | 10640 | 93 |
1509897 | 1509897 | 2021-07-12 | Putnam | New York | 36079 | 10640 | 93 |
1506650 | 1506650 | 2021-07-11 | Putnam | New York | 36079 | 10638 | 93 |
1503404 | 1503404 | 2021-07-10 | Putnam | New York | 36079 | 10637 | 93 |
1500158 | 1500158 | 2021-07-09 | Putnam | New York | 36079 | 10637 | 93 |
1496912 | 1496912 | 2021-07-08 | Putnam | New York | 36079 | 10635 | 93 |
1493665 | 1493665 | 2021-07-07 | Putnam | New York | 36079 | 10635 | 93 |
1490418 | 1490418 | 2021-07-06 | Putnam | New York | 36079 | 10634 | 93 |
1487171 | 1487171 | 2021-07-05 | Putnam | New York | 36079 | 10634 | 93 |
1483925 | 1483925 | 2021-07-04 | Putnam | New York | 36079 | 10632 | 93 |
1480679 | 1480679 | 2021-07-03 | Putnam | New York | 36079 | 10632 | 93 |
1477432 | 1477432 | 2021-07-02 | Putnam | New York | 36079 | 10631 | 93 |
1474186 | 1474186 | 2021-07-01 | Putnam | New York | 36079 | 10631 | 93 |
1470940 | 1470940 | 2021-06-30 | Putnam | New York | 36079 | 10630 | 93 |
1467695 | 1467695 | 2021-06-29 | Putnam | New York | 36079 | 10629 | 93 |
1464450 | 1464450 | 2021-06-28 | Putnam | New York | 36079 | 10628 | 93 |
1461205 | 1461205 | 2021-06-27 | Putnam | New York | 36079 | 10626 | 93 |
1457960 | 1457960 | 2021-06-26 | Putnam | New York | 36079 | 10625 | 93 |
1454715 | 1454715 | 2021-06-25 | Putnam | New York | 36079 | 10625 | 93 |
1451470 | 1451470 | 2021-06-24 | Putnam | New York | 36079 | 10623 | 93 |
1448224 | 1448224 | 2021-06-23 | Putnam | New York | 36079 | 10623 | 93 |
1444979 | 1444979 | 2021-06-22 | Putnam | New York | 36079 | 10623 | 93 |
1441734 | 1441734 | 2021-06-21 | Putnam | New York | 36079 | 10622 | 93 |
1438489 | 1438489 | 2021-06-20 | Putnam | New York | 36079 | 10622 | 92 |
1435242 | 1435242 | 2021-06-19 | Putnam | New York | 36079 | 10622 | 92 |
1431995 | 1431995 | 2021-06-18 | Putnam | New York | 36079 | 10621 | 92 |
1428749 | 1428749 | 2021-06-17 | Putnam | New York | 36079 | 10616 | 92 |
1425504 | 1425504 | 2021-06-16 | Putnam | New York | 36079 | 10610 | 92 |
1422257 | 1422257 | 2021-06-15 | Putnam | New York | 36079 | 10606 | 92 |
1419011 | 1419011 | 2021-06-14 | Putnam | New York | 36079 | 10605 | 92 |
1415766 | 1415766 | 2021-06-13 | Putnam | New York | 36079 | 10605 | 92 |
1412520 | 1412520 | 2021-06-12 | Putnam | New York | 36079 | 10604 | 92 |
1409275 | 1409275 | 2021-06-11 | Putnam | New York | 36079 | 10604 | 92 |
1406030 | 1406030 | 2021-06-10 | Putnam | New York | 36079 | 10602 | 92 |
1402784 | 1402784 | 2021-06-09 | Putnam | New York | 36079 | 10600 | 92 |
1399539 | 1399539 | 2021-06-08 | Putnam | New York | 36079 | 10600 | 92 |
1396294 | 1396294 | 2021-06-07 | Putnam | New York | 36079 | 10599 | 92 |
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);