ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Douglas" and fips = 32005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1818382 | 1818382 | 2021-10-15 | Douglas | Nevada | 32005 | 4589 | 53 |
1815133 | 1815133 | 2021-10-14 | Douglas | Nevada | 32005 | 4579 | 53 |
1811885 | 1811885 | 2021-10-13 | Douglas | Nevada | 32005 | 4571 | 53 |
1808636 | 1808636 | 2021-10-12 | Douglas | Nevada | 32005 | 4562 | 53 |
1805385 | 1805385 | 2021-10-11 | Douglas | Nevada | 32005 | 4527 | 52 |
1802136 | 1802136 | 2021-10-10 | Douglas | Nevada | 32005 | 4521 | 52 |
1798887 | 1798887 | 2021-10-09 | Douglas | Nevada | 32005 | 4521 | 52 |
1795638 | 1795638 | 2021-10-08 | Douglas | Nevada | 32005 | 4521 | 52 |
1792389 | 1792389 | 2021-10-07 | Douglas | Nevada | 32005 | 4509 | 52 |
1789140 | 1789140 | 2021-10-06 | Douglas | Nevada | 32005 | 4502 | 51 |
1785892 | 1785892 | 2021-10-05 | Douglas | Nevada | 32005 | 4424 | 50 |
1782643 | 1782643 | 2021-10-04 | Douglas | Nevada | 32005 | 4403 | 50 |
1779393 | 1779393 | 2021-10-03 | Douglas | Nevada | 32005 | 4396 | 50 |
1776143 | 1776143 | 2021-10-02 | Douglas | Nevada | 32005 | 4396 | 50 |
1772893 | 1772893 | 2021-10-01 | Douglas | Nevada | 32005 | 4396 | 50 |
1769644 | 1769644 | 2021-09-30 | Douglas | Nevada | 32005 | 4385 | 49 |
1766395 | 1766395 | 2021-09-29 | Douglas | Nevada | 32005 | 4372 | 49 |
1763146 | 1763146 | 2021-09-28 | Douglas | Nevada | 32005 | 4366 | 49 |
1759897 | 1759897 | 2021-09-27 | Douglas | Nevada | 32005 | 4345 | 48 |
1756649 | 1756649 | 2021-09-26 | Douglas | Nevada | 32005 | 4328 | 47 |
1753401 | 1753401 | 2021-09-25 | Douglas | Nevada | 32005 | 4328 | 47 |
1750153 | 1750153 | 2021-09-24 | Douglas | Nevada | 32005 | 4328 | 47 |
1746903 | 1746903 | 2021-09-23 | Douglas | Nevada | 32005 | 4315 | 47 |
1743654 | 1743654 | 2021-09-22 | Douglas | Nevada | 32005 | 4318 | 47 |
1740405 | 1740405 | 2021-09-21 | Douglas | Nevada | 32005 | 4302 | 46 |
1737156 | 1737156 | 2021-09-20 | Douglas | Nevada | 32005 | 4250 | 46 |
1733906 | 1733906 | 2021-09-19 | Douglas | Nevada | 32005 | 4222 | 45 |
1730656 | 1730656 | 2021-09-18 | Douglas | Nevada | 32005 | 4222 | 45 |
1727406 | 1727406 | 2021-09-17 | Douglas | Nevada | 32005 | 4222 | 45 |
1724157 | 1724157 | 2021-09-16 | Douglas | Nevada | 32005 | 4197 | 44 |
1720908 | 1720908 | 2021-09-15 | Douglas | Nevada | 32005 | 4174 | 44 |
1717660 | 1717660 | 2021-09-14 | Douglas | Nevada | 32005 | 4151 | 44 |
1714412 | 1714412 | 2021-09-13 | Douglas | Nevada | 32005 | 4093 | 44 |
1711166 | 1711166 | 2021-09-12 | Douglas | Nevada | 32005 | 4066 | 44 |
1707919 | 1707919 | 2021-09-11 | Douglas | Nevada | 32005 | 4066 | 44 |
1704672 | 1704672 | 2021-09-10 | Douglas | Nevada | 32005 | 4066 | 44 |
1701422 | 1701422 | 2021-09-09 | Douglas | Nevada | 32005 | 4030 | 43 |
1698173 | 1698173 | 2021-09-08 | Douglas | Nevada | 32005 | 4001 | 42 |
1694925 | 1694925 | 2021-09-07 | Douglas | Nevada | 32005 | 3913 | 42 |
1691676 | 1691676 | 2021-09-06 | Douglas | Nevada | 32005 | 3885 | 42 |
1688426 | 1688426 | 2021-09-05 | Douglas | Nevada | 32005 | 3885 | 42 |
1685176 | 1685176 | 2021-09-04 | Douglas | Nevada | 32005 | 3885 | 42 |
1681925 | 1681925 | 2021-09-03 | Douglas | Nevada | 32005 | 3885 | 42 |
1678677 | 1678677 | 2021-09-02 | Douglas | Nevada | 32005 | 3821 | 42 |
1675429 | 1675429 | 2021-09-01 | Douglas | Nevada | 32005 | 3794 | 42 |
1672181 | 1672181 | 2021-08-31 | Douglas | Nevada | 32005 | 3751 | 42 |
1668934 | 1668934 | 2021-08-30 | Douglas | Nevada | 32005 | 3659 | 42 |
1665687 | 1665687 | 2021-08-29 | Douglas | Nevada | 32005 | 3618 | 40 |
1662439 | 1662439 | 2021-08-28 | Douglas | Nevada | 32005 | 3618 | 40 |
1659191 | 1659191 | 2021-08-27 | Douglas | Nevada | 32005 | 3618 | 40 |
1655942 | 1655942 | 2021-08-26 | Douglas | Nevada | 32005 | 3586 | 40 |
1652695 | 1652695 | 2021-08-25 | Douglas | Nevada | 32005 | 3564 | 40 |
1649447 | 1649447 | 2021-08-24 | Douglas | Nevada | 32005 | 3539 | 40 |
1646198 | 1646198 | 2021-08-23 | Douglas | Nevada | 32005 | 3472 | 38 |
1642949 | 1642949 | 2021-08-22 | Douglas | Nevada | 32005 | 3441 | 38 |
1639699 | 1639699 | 2021-08-21 | Douglas | Nevada | 32005 | 3441 | 38 |
1636449 | 1636449 | 2021-08-20 | Douglas | Nevada | 32005 | 3441 | 38 |
1633199 | 1633199 | 2021-08-19 | Douglas | Nevada | 32005 | 3424 | 38 |
1629952 | 1629952 | 2021-08-18 | Douglas | Nevada | 32005 | 3401 | 38 |
1626705 | 1626705 | 2021-08-17 | Douglas | Nevada | 32005 | 3379 | 38 |
1623458 | 1623458 | 2021-08-16 | Douglas | Nevada | 32005 | 3328 | 38 |
1620211 | 1620211 | 2021-08-15 | Douglas | Nevada | 32005 | 3308 | 38 |
1616963 | 1616963 | 2021-08-14 | Douglas | Nevada | 32005 | 3308 | 38 |
1613715 | 1613715 | 2021-08-13 | Douglas | Nevada | 32005 | 3308 | 38 |
1610466 | 1610466 | 2021-08-12 | Douglas | Nevada | 32005 | 3291 | 38 |
1607218 | 1607218 | 2021-08-11 | Douglas | Nevada | 32005 | 3278 | 38 |
1603969 | 1603969 | 2021-08-10 | Douglas | Nevada | 32005 | 3262 | 38 |
1600720 | 1600720 | 2021-08-09 | Douglas | Nevada | 32005 | 3231 | 37 |
1597472 | 1597472 | 2021-08-08 | Douglas | Nevada | 32005 | 3190 | 37 |
1594223 | 1594223 | 2021-08-07 | Douglas | Nevada | 32005 | 3190 | 37 |
1590974 | 1590974 | 2021-08-06 | Douglas | Nevada | 32005 | 3190 | 37 |
1587725 | 1587725 | 2021-08-05 | Douglas | Nevada | 32005 | 3177 | 37 |
1584474 | 1584474 | 2021-08-04 | Douglas | Nevada | 32005 | 3169 | 37 |
1581225 | 1581225 | 2021-08-03 | Douglas | Nevada | 32005 | 3169 | 37 |
1577976 | 1577976 | 2021-08-02 | Douglas | Nevada | 32005 | 3144 | 37 |
1574728 | 1574728 | 2021-08-01 | Douglas | Nevada | 32005 | 3132 | 37 |
1571480 | 1571480 | 2021-07-31 | Douglas | Nevada | 32005 | 3132 | 37 |
1568232 | 1568232 | 2021-07-30 | Douglas | Nevada | 32005 | 3132 | 37 |
1564984 | 1564984 | 2021-07-29 | Douglas | Nevada | 32005 | 3114 | 37 |
1561736 | 1561736 | 2021-07-28 | Douglas | Nevada | 32005 | 3108 | 37 |
1558488 | 1558488 | 2021-07-27 | Douglas | Nevada | 32005 | 3098 | 37 |
1555241 | 1555241 | 2021-07-26 | Douglas | Nevada | 32005 | 3083 | 37 |
1551994 | 1551994 | 2021-07-25 | Douglas | Nevada | 32005 | 3078 | 37 |
1548747 | 1548747 | 2021-07-24 | Douglas | Nevada | 32005 | 3078 | 37 |
1545500 | 1545500 | 2021-07-23 | Douglas | Nevada | 32005 | 3078 | 37 |
1542252 | 1542252 | 2021-07-22 | Douglas | Nevada | 32005 | 3066 | 37 |
1539005 | 1539005 | 2021-07-21 | Douglas | Nevada | 32005 | 3060 | 37 |
1535758 | 1535758 | 2021-07-20 | Douglas | Nevada | 32005 | 3057 | 37 |
1532510 | 1532510 | 2021-07-19 | Douglas | Nevada | 32005 | 3043 | 37 |
1529263 | 1529263 | 2021-07-18 | Douglas | Nevada | 32005 | 3040 | 37 |
1526016 | 1526016 | 2021-07-17 | Douglas | Nevada | 32005 | 3040 | 37 |
1522769 | 1522769 | 2021-07-16 | Douglas | Nevada | 32005 | 3040 | 37 |
1519520 | 1519520 | 2021-07-15 | Douglas | Nevada | 32005 | 3039 | 37 |
1516273 | 1516273 | 2021-07-14 | Douglas | Nevada | 32005 | 3037 | 37 |
1513026 | 1513026 | 2021-07-13 | Douglas | Nevada | 32005 | 3032 | 37 |
1509779 | 1509779 | 2021-07-12 | Douglas | Nevada | 32005 | 3030 | 37 |
1506533 | 1506533 | 2021-07-11 | Douglas | Nevada | 32005 | 3028 | 37 |
1503287 | 1503287 | 2021-07-10 | Douglas | Nevada | 32005 | 3028 | 37 |
1500041 | 1500041 | 2021-07-09 | Douglas | Nevada | 32005 | 3028 | 37 |
1496795 | 1496795 | 2021-07-08 | Douglas | Nevada | 32005 | 3028 | 37 |
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);