ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Adams" and fips = 39001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1792683 | 1792683 | 2021-10-07 | Adams | Ohio | 39001 | 3965 | 81 |
1789434 | 1789434 | 2021-10-06 | Adams | Ohio | 39001 | 3948 | 81 |
1786186 | 1786186 | 2021-10-05 | Adams | Ohio | 39001 | 3925 | 81 |
1782937 | 1782937 | 2021-10-04 | Adams | Ohio | 39001 | 3904 | 80 |
1779688 | 1779688 | 2021-10-03 | Adams | Ohio | 39001 | 3894 | 80 |
1776438 | 1776438 | 2021-10-02 | Adams | Ohio | 39001 | 3869 | 80 |
1773188 | 1773188 | 2021-10-01 | Adams | Ohio | 39001 | 3850 | 80 |
1769938 | 1769938 | 2021-09-30 | Adams | Ohio | 39001 | 3831 | 76 |
1766689 | 1766689 | 2021-09-29 | Adams | Ohio | 39001 | 3805 | 76 |
1763440 | 1763440 | 2021-09-28 | Adams | Ohio | 39001 | 3781 | 76 |
1760191 | 1760191 | 2021-09-27 | Adams | Ohio | 39001 | 3736 | 75 |
1756943 | 1756943 | 2021-09-26 | Adams | Ohio | 39001 | 3715 | 75 |
1753695 | 1753695 | 2021-09-25 | Adams | Ohio | 39001 | 3692 | 75 |
1750447 | 1750447 | 2021-09-24 | Adams | Ohio | 39001 | 3668 | 75 |
1747197 | 1747197 | 2021-09-23 | Adams | Ohio | 39001 | 3635 | 75 |
1743948 | 1743948 | 2021-09-22 | Adams | Ohio | 39001 | 3606 | 75 |
1740699 | 1740699 | 2021-09-21 | Adams | Ohio | 39001 | 3537 | 75 |
1737450 | 1737450 | 2021-09-20 | Adams | Ohio | 39001 | 3519 | 69 |
1734200 | 1734200 | 2021-09-19 | Adams | Ohio | 39001 | 3496 | 69 |
1730950 | 1730950 | 2021-09-18 | Adams | Ohio | 39001 | 3480 | 69 |
1727700 | 1727700 | 2021-09-17 | Adams | Ohio | 39001 | 3448 | 69 |
1724451 | 1724451 | 2021-09-16 | Adams | Ohio | 39001 | 3430 | 64 |
1721202 | 1721202 | 2021-09-15 | Adams | Ohio | 39001 | 3388 | 64 |
1717954 | 1717954 | 2021-09-14 | Adams | Ohio | 39001 | 3357 | 64 |
1714706 | 1714706 | 2021-09-13 | Adams | Ohio | 39001 | 3309 | 63 |
1711460 | 1711460 | 2021-09-12 | Adams | Ohio | 39001 | 3284 | 63 |
1708213 | 1708213 | 2021-09-11 | Adams | Ohio | 39001 | 3266 | 63 |
1704966 | 1704966 | 2021-09-10 | Adams | Ohio | 39001 | 3228 | 63 |
1701716 | 1701716 | 2021-09-09 | Adams | Ohio | 39001 | 3186 | 62 |
1698467 | 1698467 | 2021-09-08 | Adams | Ohio | 39001 | 3168 | 62 |
1695219 | 1695219 | 2021-09-07 | Adams | Ohio | 39001 | 3120 | 62 |
1691971 | 1691971 | 2021-09-06 | Adams | Ohio | 39001 | 3094 | 61 |
1688722 | 1688722 | 2021-09-05 | Adams | Ohio | 39001 | 3080 | 61 |
1685472 | 1685472 | 2021-09-04 | Adams | Ohio | 39001 | 3061 | 61 |
1682221 | 1682221 | 2021-09-03 | Adams | Ohio | 39001 | 3034 | 61 |
1678971 | 1678971 | 2021-09-02 | Adams | Ohio | 39001 | 3005 | 61 |
1675723 | 1675723 | 2021-09-01 | Adams | Ohio | 39001 | 2972 | 61 |
1672476 | 1672476 | 2021-08-31 | Adams | Ohio | 39001 | 2937 | 61 |
1669228 | 1669228 | 2021-08-30 | Adams | Ohio | 39001 | 2914 | 60 |
1665981 | 1665981 | 2021-08-29 | Adams | Ohio | 39001 | 2906 | 60 |
1662733 | 1662733 | 2021-08-28 | Adams | Ohio | 39001 | 2883 | 60 |
1659485 | 1659485 | 2021-08-27 | Adams | Ohio | 39001 | 2845 | 60 |
1656236 | 1656236 | 2021-08-26 | Adams | Ohio | 39001 | 2824 | 60 |
1652989 | 1652989 | 2021-08-25 | Adams | Ohio | 39001 | 2793 | 60 |
1649742 | 1649742 | 2021-08-24 | Adams | Ohio | 39001 | 2748 | 60 |
1646493 | 1646493 | 2021-08-23 | Adams | Ohio | 39001 | 2719 | 59 |
1643244 | 1643244 | 2021-08-22 | Adams | Ohio | 39001 | 2707 | 59 |
1639994 | 1639994 | 2021-08-21 | Adams | Ohio | 39001 | 2699 | 59 |
1636744 | 1636744 | 2021-08-20 | Adams | Ohio | 39001 | 2680 | 59 |
1633494 | 1633494 | 2021-08-19 | Adams | Ohio | 39001 | 2668 | 59 |
1630247 | 1630247 | 2021-08-18 | Adams | Ohio | 39001 | 2650 | 59 |
1627000 | 1627000 | 2021-08-17 | Adams | Ohio | 39001 | 2638 | 59 |
1623753 | 1623753 | 2021-08-16 | Adams | Ohio | 39001 | 2625 | 59 |
1620506 | 1620506 | 2021-08-15 | Adams | Ohio | 39001 | 2616 | 59 |
1617258 | 1617258 | 2021-08-14 | Adams | Ohio | 39001 | 2613 | 59 |
1614010 | 1614010 | 2021-08-13 | Adams | Ohio | 39001 | 2604 | 59 |
1610761 | 1610761 | 2021-08-12 | Adams | Ohio | 39001 | 2594 | 58 |
1607513 | 1607513 | 2021-08-11 | Adams | Ohio | 39001 | 2583 | 58 |
1604264 | 1604264 | 2021-08-10 | Adams | Ohio | 39001 | 2574 | 58 |
1601015 | 1601015 | 2021-08-09 | Adams | Ohio | 39001 | 2569 | 58 |
1597767 | 1597767 | 2021-08-08 | Adams | Ohio | 39001 | 2565 | 58 |
1594518 | 1594518 | 2021-08-07 | Adams | Ohio | 39001 | 2560 | 58 |
1591269 | 1591269 | 2021-08-06 | Adams | Ohio | 39001 | 2556 | 58 |
1588020 | 1588020 | 2021-08-05 | Adams | Ohio | 39001 | 2549 | 58 |
1584770 | 1584770 | 2021-08-04 | Adams | Ohio | 39001 | 2543 | 58 |
1581520 | 1581520 | 2021-08-03 | Adams | Ohio | 39001 | 2536 | 58 |
1578271 | 1578271 | 2021-08-02 | Adams | Ohio | 39001 | 2532 | 58 |
1575023 | 1575023 | 2021-08-01 | Adams | Ohio | 39001 | 2531 | 58 |
1571775 | 1571775 | 2021-07-31 | Adams | Ohio | 39001 | 2526 | 58 |
1568527 | 1568527 | 2021-07-30 | Adams | Ohio | 39001 | 2523 | 58 |
1565279 | 1565279 | 2021-07-29 | Adams | Ohio | 39001 | 2516 | 58 |
1562031 | 1562031 | 2021-07-28 | Adams | Ohio | 39001 | 2509 | 58 |
1558783 | 1558783 | 2021-07-27 | Adams | Ohio | 39001 | 2498 | 58 |
1555536 | 1555536 | 2021-07-26 | Adams | Ohio | 39001 | 2492 | 58 |
1552289 | 1552289 | 2021-07-25 | Adams | Ohio | 39001 | 2491 | 58 |
1549042 | 1549042 | 2021-07-24 | Adams | Ohio | 39001 | 2488 | 58 |
1545795 | 1545795 | 2021-07-23 | Adams | Ohio | 39001 | 2477 | 58 |
1542548 | 1542548 | 2021-07-22 | Adams | Ohio | 39001 | 2474 | 57 |
1539300 | 1539300 | 2021-07-21 | Adams | Ohio | 39001 | 2468 | 57 |
1536053 | 1536053 | 2021-07-20 | Adams | Ohio | 39001 | 2463 | 57 |
1532805 | 1532805 | 2021-07-19 | Adams | Ohio | 39001 | 2456 | 57 |
1529558 | 1529558 | 2021-07-18 | Adams | Ohio | 39001 | 2456 | 57 |
1526311 | 1526311 | 2021-07-17 | Adams | Ohio | 39001 | 2455 | 57 |
1523064 | 1523064 | 2021-07-16 | Adams | Ohio | 39001 | 2453 | 57 |
1519816 | 1519816 | 2021-07-15 | Adams | Ohio | 39001 | 2449 | 57 |
1516568 | 1516568 | 2021-07-14 | Adams | Ohio | 39001 | 2447 | 57 |
1513321 | 1513321 | 2021-07-13 | Adams | Ohio | 39001 | 2447 | 57 |
1510075 | 1510075 | 2021-07-12 | Adams | Ohio | 39001 | 2446 | 56 |
1506828 | 1506828 | 2021-07-11 | Adams | Ohio | 39001 | 2445 | 56 |
1503582 | 1503582 | 2021-07-10 | Adams | Ohio | 39001 | 2445 | 56 |
1500336 | 1500336 | 2021-07-09 | Adams | Ohio | 39001 | 2443 | 56 |
1497090 | 1497090 | 2021-07-08 | Adams | Ohio | 39001 | 2441 | 56 |
1493843 | 1493843 | 2021-07-07 | Adams | Ohio | 39001 | 2441 | 56 |
1490596 | 1490596 | 2021-07-06 | Adams | Ohio | 39001 | 2441 | 56 |
1487349 | 1487349 | 2021-07-05 | Adams | Ohio | 39001 | 2441 | 56 |
1484102 | 1484102 | 2021-07-04 | Adams | Ohio | 39001 | 2441 | 56 |
1480856 | 1480856 | 2021-07-03 | Adams | Ohio | 39001 | 2441 | 56 |
1477609 | 1477609 | 2021-07-02 | Adams | Ohio | 39001 | 2440 | 56 |
1474363 | 1474363 | 2021-07-01 | Adams | Ohio | 39001 | 2437 | 56 |
1471117 | 1471117 | 2021-06-30 | Adams | Ohio | 39001 | 2436 | 56 |
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);