ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36003 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 |
---|---|---|---|---|---|---|---|
1717741 | 1717741 | 2021-09-14 | Allegany | New York | 36003 | 3889 | 91 |
1714493 | 1714493 | 2021-09-13 | Allegany | New York | 36003 | 3875 | 91 |
1711247 | 1711247 | 2021-09-12 | Allegany | New York | 36003 | 3862 | 91 |
1708000 | 1708000 | 2021-09-11 | Allegany | New York | 36003 | 3843 | 91 |
1704753 | 1704753 | 2021-09-10 | Allegany | New York | 36003 | 3830 | 91 |
1701503 | 1701503 | 2021-09-09 | Allegany | New York | 36003 | 3806 | 91 |
1698254 | 1698254 | 2021-09-08 | Allegany | New York | 36003 | 3798 | 90 |
1695006 | 1695006 | 2021-09-07 | Allegany | New York | 36003 | 3790 | 90 |
1691758 | 1691758 | 2021-09-06 | Allegany | New York | 36003 | 3784 | 90 |
1688508 | 1688508 | 2021-09-05 | Allegany | New York | 36003 | 3775 | 90 |
1685258 | 1685258 | 2021-09-04 | Allegany | New York | 36003 | 3768 | 90 |
1682007 | 1682007 | 2021-09-03 | Allegany | New York | 36003 | 3749 | 90 |
1678758 | 1678758 | 2021-09-02 | Allegany | New York | 36003 | 3732 | 90 |
1675510 | 1675510 | 2021-09-01 | Allegany | New York | 36003 | 3721 | 89 |
1672263 | 1672263 | 2021-08-31 | Allegany | New York | 36003 | 3715 | 89 |
1669015 | 1669015 | 2021-08-30 | Allegany | New York | 36003 | 3707 | 89 |
1665768 | 1665768 | 2021-08-29 | Allegany | New York | 36003 | 3703 | 89 |
1662520 | 1662520 | 2021-08-28 | Allegany | New York | 36003 | 3692 | 89 |
1659272 | 1659272 | 2021-08-27 | Allegany | New York | 36003 | 3688 | 88 |
1656023 | 1656023 | 2021-08-26 | Allegany | New York | 36003 | 3674 | 88 |
1652776 | 1652776 | 2021-08-25 | Allegany | New York | 36003 | 3667 | 88 |
1649528 | 1649528 | 2021-08-24 | Allegany | New York | 36003 | 3657 | 88 |
1646279 | 1646279 | 2021-08-23 | Allegany | New York | 36003 | 3651 | 88 |
1643030 | 1643030 | 2021-08-22 | Allegany | New York | 36003 | 3647 | 87 |
1639780 | 1639780 | 2021-08-21 | Allegany | New York | 36003 | 3641 | 87 |
1636530 | 1636530 | 2021-08-20 | Allegany | New York | 36003 | 3639 | 87 |
1633280 | 1633280 | 2021-08-19 | Allegany | New York | 36003 | 3635 | 87 |
1630033 | 1630033 | 2021-08-18 | Allegany | New York | 36003 | 3633 | 87 |
1626786 | 1626786 | 2021-08-17 | Allegany | New York | 36003 | 3630 | 87 |
1623539 | 1623539 | 2021-08-16 | Allegany | New York | 36003 | 3627 | 87 |
1620292 | 1620292 | 2021-08-15 | Allegany | New York | 36003 | 3622 | 87 |
1617044 | 1617044 | 2021-08-14 | Allegany | New York | 36003 | 3621 | 87 |
1613796 | 1613796 | 2021-08-13 | Allegany | New York | 36003 | 3620 | 87 |
1610547 | 1610547 | 2021-08-12 | Allegany | New York | 36003 | 3618 | 87 |
1607299 | 1607299 | 2021-08-11 | Allegany | New York | 36003 | 3611 | 87 |
1604050 | 1604050 | 2021-08-10 | Allegany | New York | 36003 | 3605 | 87 |
1600801 | 1600801 | 2021-08-09 | Allegany | New York | 36003 | 3598 | 87 |
1597553 | 1597553 | 2021-08-08 | Allegany | New York | 36003 | 3597 | 87 |
1594304 | 1594304 | 2021-08-07 | Allegany | New York | 36003 | 3596 | 87 |
1591055 | 1591055 | 2021-08-06 | Allegany | New York | 36003 | 3592 | 87 |
1587806 | 1587806 | 2021-08-05 | Allegany | New York | 36003 | 3587 | 87 |
1584556 | 1584556 | 2021-08-04 | Allegany | New York | 36003 | 3585 | 87 |
1581306 | 1581306 | 2021-08-03 | Allegany | New York | 36003 | 3582 | 87 |
1578057 | 1578057 | 2021-08-02 | Allegany | New York | 36003 | 3582 | 87 |
1574809 | 1574809 | 2021-08-01 | Allegany | New York | 36003 | 3582 | 87 |
1571561 | 1571561 | 2021-07-31 | Allegany | New York | 36003 | 3580 | 87 |
1568313 | 1568313 | 2021-07-30 | Allegany | New York | 36003 | 3579 | 87 |
1565065 | 1565065 | 2021-07-29 | Allegany | New York | 36003 | 3578 | 87 |
1561817 | 1561817 | 2021-07-28 | Allegany | New York | 36003 | 3576 | 87 |
1558569 | 1558569 | 2021-07-27 | Allegany | New York | 36003 | 3576 | 87 |
1555322 | 1555322 | 2021-07-26 | Allegany | New York | 36003 | 3576 | 87 |
1552075 | 1552075 | 2021-07-25 | Allegany | New York | 36003 | 3576 | 87 |
1548828 | 1548828 | 2021-07-24 | Allegany | New York | 36003 | 3576 | 87 |
1545581 | 1545581 | 2021-07-23 | Allegany | New York | 36003 | 3575 | 87 |
1542334 | 1542334 | 2021-07-22 | Allegany | New York | 36003 | 3574 | 87 |
1539086 | 1539086 | 2021-07-21 | Allegany | New York | 36003 | 3572 | 87 |
1535839 | 1535839 | 2021-07-20 | Allegany | New York | 36003 | 3571 | 87 |
1532591 | 1532591 | 2021-07-19 | Allegany | New York | 36003 | 3569 | 87 |
1529344 | 1529344 | 2021-07-18 | Allegany | New York | 36003 | 3569 | 87 |
1526097 | 1526097 | 2021-07-17 | Allegany | New York | 36003 | 3569 | 87 |
1522850 | 1522850 | 2021-07-16 | Allegany | New York | 36003 | 3567 | 87 |
1519602 | 1519602 | 2021-07-15 | Allegany | New York | 36003 | 3565 | 87 |
1516354 | 1516354 | 2021-07-14 | Allegany | New York | 36003 | 3564 | 87 |
1513107 | 1513107 | 2021-07-13 | Allegany | New York | 36003 | 3564 | 87 |
1509861 | 1509861 | 2021-07-12 | Allegany | New York | 36003 | 3563 | 87 |
1506614 | 1506614 | 2021-07-11 | Allegany | New York | 36003 | 3563 | 87 |
1503368 | 1503368 | 2021-07-10 | Allegany | New York | 36003 | 3563 | 87 |
1500122 | 1500122 | 2021-07-09 | Allegany | New York | 36003 | 3563 | 87 |
1496876 | 1496876 | 2021-07-08 | Allegany | New York | 36003 | 3562 | 87 |
1493629 | 1493629 | 2021-07-07 | Allegany | New York | 36003 | 3562 | 87 |
1490382 | 1490382 | 2021-07-06 | Allegany | New York | 36003 | 3562 | 87 |
1487135 | 1487135 | 2021-07-05 | Allegany | New York | 36003 | 3562 | 87 |
1483889 | 1483889 | 2021-07-04 | Allegany | New York | 36003 | 3562 | 87 |
1480643 | 1480643 | 2021-07-03 | Allegany | New York | 36003 | 3562 | 87 |
1477396 | 1477396 | 2021-07-02 | Allegany | New York | 36003 | 3562 | 87 |
1474150 | 1474150 | 2021-07-01 | Allegany | New York | 36003 | 3562 | 87 |
1470904 | 1470904 | 2021-06-30 | Allegany | New York | 36003 | 3562 | 87 |
1467659 | 1467659 | 2021-06-29 | Allegany | New York | 36003 | 3562 | 87 |
1464414 | 1464414 | 2021-06-28 | Allegany | New York | 36003 | 3562 | 87 |
1461169 | 1461169 | 2021-06-27 | Allegany | New York | 36003 | 3562 | 87 |
1457924 | 1457924 | 2021-06-26 | Allegany | New York | 36003 | 3561 | 87 |
1454679 | 1454679 | 2021-06-25 | Allegany | New York | 36003 | 3561 | 87 |
1451434 | 1451434 | 2021-06-24 | Allegany | New York | 36003 | 3561 | 87 |
1448188 | 1448188 | 2021-06-23 | Allegany | New York | 36003 | 3561 | 87 |
1444943 | 1444943 | 2021-06-22 | Allegany | New York | 36003 | 3561 | 87 |
1441698 | 1441698 | 2021-06-21 | Allegany | New York | 36003 | 3559 | 87 |
1438453 | 1438453 | 2021-06-20 | Allegany | New York | 36003 | 3559 | 87 |
1435206 | 1435206 | 2021-06-19 | Allegany | New York | 36003 | 3559 | 87 |
1431959 | 1431959 | 2021-06-18 | Allegany | New York | 36003 | 3558 | 87 |
1428713 | 1428713 | 2021-06-17 | Allegany | New York | 36003 | 3557 | 87 |
1425468 | 1425468 | 2021-06-16 | Allegany | New York | 36003 | 3556 | 87 |
1422221 | 1422221 | 2021-06-15 | Allegany | New York | 36003 | 3555 | 87 |
1418975 | 1418975 | 2021-06-14 | Allegany | New York | 36003 | 3555 | 87 |
1415730 | 1415730 | 2021-06-13 | Allegany | New York | 36003 | 3555 | 87 |
1412484 | 1412484 | 2021-06-12 | Allegany | New York | 36003 | 3555 | 87 |
1409239 | 1409239 | 2021-06-11 | Allegany | New York | 36003 | 3555 | 87 |
1405994 | 1405994 | 2021-06-10 | Allegany | New York | 36003 | 3555 | 87 |
1402748 | 1402748 | 2021-06-09 | Allegany | New York | 36003 | 3555 | 87 |
1399503 | 1399503 | 2021-06-08 | Allegany | New York | 36003 | 3551 | 87 |
1396258 | 1396258 | 2021-06-07 | Allegany | New York | 36003 | 3549 | 87 |
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);