ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36121 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 |
---|---|---|---|---|---|---|---|
1717796 | 1717796 | 2021-09-14 | Wyoming | New York | 36121 | 3824 | 54 |
1714548 | 1714548 | 2021-09-13 | Wyoming | New York | 36121 | 3818 | 54 |
1711302 | 1711302 | 2021-09-12 | Wyoming | New York | 36121 | 3814 | 54 |
1708055 | 1708055 | 2021-09-11 | Wyoming | New York | 36121 | 3804 | 54 |
1704808 | 1704808 | 2021-09-10 | Wyoming | New York | 36121 | 3788 | 54 |
1701558 | 1701558 | 2021-09-09 | Wyoming | New York | 36121 | 3770 | 54 |
1698309 | 1698309 | 2021-09-08 | Wyoming | New York | 36121 | 3757 | 54 |
1695061 | 1695061 | 2021-09-07 | Wyoming | New York | 36121 | 3750 | 54 |
1691813 | 1691813 | 2021-09-06 | Wyoming | New York | 36121 | 3747 | 54 |
1688563 | 1688563 | 2021-09-05 | Wyoming | New York | 36121 | 3742 | 54 |
1685313 | 1685313 | 2021-09-04 | Wyoming | New York | 36121 | 3741 | 54 |
1682062 | 1682062 | 2021-09-03 | Wyoming | New York | 36121 | 3725 | 54 |
1678813 | 1678813 | 2021-09-02 | Wyoming | New York | 36121 | 3719 | 54 |
1675565 | 1675565 | 2021-09-01 | Wyoming | New York | 36121 | 3709 | 54 |
1672318 | 1672318 | 2021-08-31 | Wyoming | New York | 36121 | 3699 | 54 |
1669070 | 1669070 | 2021-08-30 | Wyoming | New York | 36121 | 3697 | 53 |
1665823 | 1665823 | 2021-08-29 | Wyoming | New York | 36121 | 3696 | 53 |
1662575 | 1662575 | 2021-08-28 | Wyoming | New York | 36121 | 3693 | 53 |
1659327 | 1659327 | 2021-08-27 | Wyoming | New York | 36121 | 3690 | 53 |
1656078 | 1656078 | 2021-08-26 | Wyoming | New York | 36121 | 3686 | 53 |
1652831 | 1652831 | 2021-08-25 | Wyoming | New York | 36121 | 3681 | 53 |
1649583 | 1649583 | 2021-08-24 | Wyoming | New York | 36121 | 3676 | 53 |
1646334 | 1646334 | 2021-08-23 | Wyoming | New York | 36121 | 3673 | 53 |
1643085 | 1643085 | 2021-08-22 | Wyoming | New York | 36121 | 3672 | 53 |
1639835 | 1639835 | 2021-08-21 | Wyoming | New York | 36121 | 3669 | 53 |
1636585 | 1636585 | 2021-08-20 | Wyoming | New York | 36121 | 3667 | 53 |
1633335 | 1633335 | 2021-08-19 | Wyoming | New York | 36121 | 3664 | 53 |
1630088 | 1630088 | 2021-08-18 | Wyoming | New York | 36121 | 3660 | 53 |
1626841 | 1626841 | 2021-08-17 | Wyoming | New York | 36121 | 3655 | 53 |
1623594 | 1623594 | 2021-08-16 | Wyoming | New York | 36121 | 3652 | 53 |
1620347 | 1620347 | 2021-08-15 | Wyoming | New York | 36121 | 3651 | 53 |
1617099 | 1617099 | 2021-08-14 | Wyoming | New York | 36121 | 3649 | 53 |
1613851 | 1613851 | 2021-08-13 | Wyoming | New York | 36121 | 3648 | 53 |
1610602 | 1610602 | 2021-08-12 | Wyoming | New York | 36121 | 3644 | 53 |
1607354 | 1607354 | 2021-08-11 | Wyoming | New York | 36121 | 3641 | 53 |
1604105 | 1604105 | 2021-08-10 | Wyoming | New York | 36121 | 3639 | 53 |
1600856 | 1600856 | 2021-08-09 | Wyoming | New York | 36121 | 3638 | 53 |
1597608 | 1597608 | 2021-08-08 | Wyoming | New York | 36121 | 3637 | 53 |
1594359 | 1594359 | 2021-08-07 | Wyoming | New York | 36121 | 3635 | 53 |
1591110 | 1591110 | 2021-08-06 | Wyoming | New York | 36121 | 3633 | 53 |
1587861 | 1587861 | 2021-08-05 | Wyoming | New York | 36121 | 3632 | 53 |
1584611 | 1584611 | 2021-08-04 | Wyoming | New York | 36121 | 3632 | 53 |
1581361 | 1581361 | 2021-08-03 | Wyoming | New York | 36121 | 3631 | 53 |
1578112 | 1578112 | 2021-08-02 | Wyoming | New York | 36121 | 3631 | 53 |
1574864 | 1574864 | 2021-08-01 | Wyoming | New York | 36121 | 3628 | 53 |
1571616 | 1571616 | 2021-07-31 | Wyoming | New York | 36121 | 3628 | 53 |
1568368 | 1568368 | 2021-07-30 | Wyoming | New York | 36121 | 3622 | 53 |
1565120 | 1565120 | 2021-07-29 | Wyoming | New York | 36121 | 3620 | 53 |
1561872 | 1561872 | 2021-07-28 | Wyoming | New York | 36121 | 3620 | 53 |
1558624 | 1558624 | 2021-07-27 | Wyoming | New York | 36121 | 3618 | 53 |
1555377 | 1555377 | 2021-07-26 | Wyoming | New York | 36121 | 3616 | 53 |
1552130 | 1552130 | 2021-07-25 | Wyoming | New York | 36121 | 3616 | 53 |
1548883 | 1548883 | 2021-07-24 | Wyoming | New York | 36121 | 3614 | 53 |
1545636 | 1545636 | 2021-07-23 | Wyoming | New York | 36121 | 3614 | 53 |
1542389 | 1542389 | 2021-07-22 | Wyoming | New York | 36121 | 3612 | 53 |
1539141 | 1539141 | 2021-07-21 | Wyoming | New York | 36121 | 3608 | 53 |
1535894 | 1535894 | 2021-07-20 | Wyoming | New York | 36121 | 3608 | 53 |
1532646 | 1532646 | 2021-07-19 | Wyoming | New York | 36121 | 3608 | 53 |
1529399 | 1529399 | 2021-07-18 | Wyoming | New York | 36121 | 3608 | 53 |
1526152 | 1526152 | 2021-07-17 | Wyoming | New York | 36121 | 3607 | 53 |
1522905 | 1522905 | 2021-07-16 | Wyoming | New York | 36121 | 3607 | 53 |
1519657 | 1519657 | 2021-07-15 | Wyoming | New York | 36121 | 3607 | 53 |
1516409 | 1516409 | 2021-07-14 | Wyoming | New York | 36121 | 3605 | 53 |
1513162 | 1513162 | 2021-07-13 | Wyoming | New York | 36121 | 3603 | 53 |
1509916 | 1509916 | 2021-07-12 | Wyoming | New York | 36121 | 3603 | 53 |
1506669 | 1506669 | 2021-07-11 | Wyoming | New York | 36121 | 3603 | 53 |
1503423 | 1503423 | 2021-07-10 | Wyoming | New York | 36121 | 3603 | 53 |
1500177 | 1500177 | 2021-07-09 | Wyoming | New York | 36121 | 3601 | 53 |
1496931 | 1496931 | 2021-07-08 | Wyoming | New York | 36121 | 3599 | 53 |
1493684 | 1493684 | 2021-07-07 | Wyoming | New York | 36121 | 3597 | 53 |
1490437 | 1490437 | 2021-07-06 | Wyoming | New York | 36121 | 3597 | 53 |
1487190 | 1487190 | 2021-07-05 | Wyoming | New York | 36121 | 3596 | 53 |
1483944 | 1483944 | 2021-07-04 | Wyoming | New York | 36121 | 3594 | 53 |
1480698 | 1480698 | 2021-07-03 | Wyoming | New York | 36121 | 3593 | 53 |
1477451 | 1477451 | 2021-07-02 | Wyoming | New York | 36121 | 3589 | 53 |
1474205 | 1474205 | 2021-07-01 | Wyoming | New York | 36121 | 3589 | 53 |
1470959 | 1470959 | 2021-06-30 | Wyoming | New York | 36121 | 3588 | 53 |
1467714 | 1467714 | 2021-06-29 | Wyoming | New York | 36121 | 3588 | 53 |
1464469 | 1464469 | 2021-06-28 | Wyoming | New York | 36121 | 3585 | 53 |
1461224 | 1461224 | 2021-06-27 | Wyoming | New York | 36121 | 3585 | 53 |
1457979 | 1457979 | 2021-06-26 | Wyoming | New York | 36121 | 3585 | 53 |
1454734 | 1454734 | 2021-06-25 | Wyoming | New York | 36121 | 3585 | 53 |
1451489 | 1451489 | 2021-06-24 | Wyoming | New York | 36121 | 3585 | 53 |
1448243 | 1448243 | 2021-06-23 | Wyoming | New York | 36121 | 3585 | 53 |
1444998 | 1444998 | 2021-06-22 | Wyoming | New York | 36121 | 3585 | 53 |
1441753 | 1441753 | 2021-06-21 | Wyoming | New York | 36121 | 3584 | 53 |
1438508 | 1438508 | 2021-06-20 | Wyoming | New York | 36121 | 3584 | 53 |
1435261 | 1435261 | 2021-06-19 | Wyoming | New York | 36121 | 3584 | 53 |
1432014 | 1432014 | 2021-06-18 | Wyoming | New York | 36121 | 3583 | 53 |
1428768 | 1428768 | 2021-06-17 | Wyoming | New York | 36121 | 3583 | 53 |
1425523 | 1425523 | 2021-06-16 | Wyoming | New York | 36121 | 3582 | 53 |
1422276 | 1422276 | 2021-06-15 | Wyoming | New York | 36121 | 3582 | 53 |
1419030 | 1419030 | 2021-06-14 | Wyoming | New York | 36121 | 3581 | 53 |
1415785 | 1415785 | 2021-06-13 | Wyoming | New York | 36121 | 3581 | 53 |
1412539 | 1412539 | 2021-06-12 | Wyoming | New York | 36121 | 3581 | 53 |
1409294 | 1409294 | 2021-06-11 | Wyoming | New York | 36121 | 3580 | 53 |
1406049 | 1406049 | 2021-06-10 | Wyoming | New York | 36121 | 3578 | 53 |
1402803 | 1402803 | 2021-06-09 | Wyoming | New York | 36121 | 3578 | 52 |
1399558 | 1399558 | 2021-06-08 | Wyoming | New York | 36121 | 3577 | 52 |
1396313 | 1396313 | 2021-06-07 | Wyoming | New York | 36121 | 3576 | 52 |
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);