ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Jefferson" and fips = 41031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1831854 | 1831854 | 2021-10-19 | Jefferson | Oregon | 41031 | 3677 | 52 |
1828605 | 1828605 | 2021-10-18 | Jefferson | Oregon | 41031 | 3663 | 51 |
1825356 | 1825356 | 2021-10-17 | Jefferson | Oregon | 41031 | 3614 | 50 |
1822107 | 1822107 | 2021-10-16 | Jefferson | Oregon | 41031 | 3614 | 50 |
1818858 | 1818858 | 2021-10-15 | Jefferson | Oregon | 41031 | 3614 | 50 |
1815609 | 1815609 | 2021-10-14 | Jefferson | Oregon | 41031 | 3596 | 50 |
1812361 | 1812361 | 2021-10-13 | Jefferson | Oregon | 41031 | 3575 | 50 |
1809112 | 1809112 | 2021-10-12 | Jefferson | Oregon | 41031 | 3556 | 50 |
1805862 | 1805862 | 2021-10-11 | Jefferson | Oregon | 41031 | 3543 | 50 |
1802612 | 1802612 | 2021-10-10 | Jefferson | Oregon | 41031 | 3496 | 50 |
1799363 | 1799363 | 2021-10-09 | Jefferson | Oregon | 41031 | 3496 | 50 |
1796114 | 1796114 | 2021-10-08 | Jefferson | Oregon | 41031 | 3496 | 50 |
1792865 | 1792865 | 2021-10-07 | Jefferson | Oregon | 41031 | 3476 | 50 |
1789616 | 1789616 | 2021-10-06 | Jefferson | Oregon | 41031 | 3454 | 50 |
1786368 | 1786368 | 2021-10-05 | Jefferson | Oregon | 41031 | 3438 | 49 |
1783119 | 1783119 | 2021-10-04 | Jefferson | Oregon | 41031 | 3432 | 49 |
1779870 | 1779870 | 2021-10-03 | Jefferson | Oregon | 41031 | 3390 | 49 |
1776620 | 1776620 | 2021-10-02 | Jefferson | Oregon | 41031 | 3390 | 49 |
1773370 | 1773370 | 2021-10-01 | Jefferson | Oregon | 41031 | 3390 | 49 |
1770120 | 1770120 | 2021-09-30 | Jefferson | Oregon | 41031 | 3378 | 49 |
1766871 | 1766871 | 2021-09-29 | Jefferson | Oregon | 41031 | 3361 | 49 |
1763622 | 1763622 | 2021-09-28 | Jefferson | Oregon | 41031 | 3323 | 49 |
1760373 | 1760373 | 2021-09-27 | Jefferson | Oregon | 41031 | 3297 | 48 |
1757125 | 1757125 | 2021-09-26 | Jefferson | Oregon | 41031 | 3257 | 47 |
1753877 | 1753877 | 2021-09-25 | Jefferson | Oregon | 41031 | 3257 | 47 |
1750629 | 1750629 | 2021-09-24 | Jefferson | Oregon | 41031 | 3257 | 47 |
1747379 | 1747379 | 2021-09-23 | Jefferson | Oregon | 41031 | 3214 | 47 |
1744130 | 1744130 | 2021-09-22 | Jefferson | Oregon | 41031 | 3174 | 47 |
1740881 | 1740881 | 2021-09-21 | Jefferson | Oregon | 41031 | 3153 | 47 |
1737632 | 1737632 | 2021-09-20 | Jefferson | Oregon | 41031 | 3137 | 46 |
1734382 | 1734382 | 2021-09-19 | Jefferson | Oregon | 41031 | 3104 | 46 |
1731132 | 1731132 | 2021-09-18 | Jefferson | Oregon | 41031 | 3104 | 46 |
1727882 | 1727882 | 2021-09-17 | Jefferson | Oregon | 41031 | 3104 | 46 |
1724633 | 1724633 | 2021-09-16 | Jefferson | Oregon | 41031 | 3091 | 46 |
1721384 | 1721384 | 2021-09-15 | Jefferson | Oregon | 41031 | 3081 | 46 |
1718136 | 1718136 | 2021-09-14 | Jefferson | Oregon | 41031 | 3058 | 46 |
1714888 | 1714888 | 2021-09-13 | Jefferson | Oregon | 41031 | 3043 | 45 |
1711642 | 1711642 | 2021-09-12 | Jefferson | Oregon | 41031 | 3015 | 45 |
1708395 | 1708395 | 2021-09-11 | Jefferson | Oregon | 41031 | 3015 | 45 |
1705148 | 1705148 | 2021-09-10 | Jefferson | Oregon | 41031 | 3015 | 45 |
1701898 | 1701898 | 2021-09-09 | Jefferson | Oregon | 41031 | 2992 | 45 |
1698649 | 1698649 | 2021-09-08 | Jefferson | Oregon | 41031 | 2971 | 45 |
1695401 | 1695401 | 2021-09-07 | Jefferson | Oregon | 41031 | 2963 | 45 |
1692153 | 1692153 | 2021-09-06 | Jefferson | Oregon | 41031 | 2935 | 45 |
1688904 | 1688904 | 2021-09-05 | Jefferson | Oregon | 41031 | 2935 | 45 |
1685654 | 1685654 | 2021-09-04 | Jefferson | Oregon | 41031 | 2935 | 45 |
1682403 | 1682403 | 2021-09-03 | Jefferson | Oregon | 41031 | 2935 | 45 |
1679153 | 1679153 | 2021-09-02 | Jefferson | Oregon | 41031 | 2919 | 45 |
1675905 | 1675905 | 2021-09-01 | Jefferson | Oregon | 41031 | 2897 | 45 |
1672658 | 1672658 | 2021-08-31 | Jefferson | Oregon | 41031 | 2877 | 45 |
1669410 | 1669410 | 2021-08-30 | Jefferson | Oregon | 41031 | 2850 | 45 |
1666163 | 1666163 | 2021-08-29 | Jefferson | Oregon | 41031 | 2811 | 44 |
1662915 | 1662915 | 2021-08-28 | Jefferson | Oregon | 41031 | 2811 | 44 |
1659667 | 1659667 | 2021-08-27 | Jefferson | Oregon | 41031 | 2811 | 44 |
1656418 | 1656418 | 2021-08-26 | Jefferson | Oregon | 41031 | 2782 | 44 |
1653171 | 1653171 | 2021-08-25 | Jefferson | Oregon | 41031 | 2774 | 44 |
1649924 | 1649924 | 2021-08-24 | Jefferson | Oregon | 41031 | 2743 | 44 |
1646675 | 1646675 | 2021-08-23 | Jefferson | Oregon | 41031 | 2739 | 44 |
1643426 | 1643426 | 2021-08-22 | Jefferson | Oregon | 41031 | 2704 | 44 |
1640176 | 1640176 | 2021-08-21 | Jefferson | Oregon | 41031 | 2704 | 44 |
1636926 | 1636926 | 2021-08-20 | Jefferson | Oregon | 41031 | 2704 | 44 |
1633676 | 1633676 | 2021-08-19 | Jefferson | Oregon | 41031 | 2694 | 44 |
1630429 | 1630429 | 2021-08-18 | Jefferson | Oregon | 41031 | 2679 | 44 |
1627182 | 1627182 | 2021-08-17 | Jefferson | Oregon | 41031 | 2662 | 43 |
1623935 | 1623935 | 2021-08-16 | Jefferson | Oregon | 41031 | 2651 | 43 |
1620688 | 1620688 | 2021-08-15 | Jefferson | Oregon | 41031 | 2623 | 42 |
1617440 | 1617440 | 2021-08-14 | Jefferson | Oregon | 41031 | 2623 | 42 |
1614192 | 1614192 | 2021-08-13 | Jefferson | Oregon | 41031 | 2623 | 42 |
1610943 | 1610943 | 2021-08-12 | Jefferson | Oregon | 41031 | 2604 | 42 |
1607695 | 1607695 | 2021-08-11 | Jefferson | Oregon | 41031 | 2584 | 42 |
1604446 | 1604446 | 2021-08-10 | Jefferson | Oregon | 41031 | 2575 | 42 |
1601197 | 1601197 | 2021-08-09 | Jefferson | Oregon | 41031 | 2567 | 42 |
1597949 | 1597949 | 2021-08-08 | Jefferson | Oregon | 41031 | 2547 | 42 |
1594700 | 1594700 | 2021-08-07 | Jefferson | Oregon | 41031 | 2547 | 42 |
1591451 | 1591451 | 2021-08-06 | Jefferson | Oregon | 41031 | 2547 | 42 |
1588202 | 1588202 | 2021-08-05 | Jefferson | Oregon | 41031 | 2540 | 42 |
1584952 | 1584952 | 2021-08-04 | Jefferson | Oregon | 41031 | 2528 | 42 |
1581702 | 1581702 | 2021-08-03 | Jefferson | Oregon | 41031 | 2525 | 42 |
1578453 | 1578453 | 2021-08-02 | Jefferson | Oregon | 41031 | 2521 | 42 |
1575205 | 1575205 | 2021-08-01 | Jefferson | Oregon | 41031 | 2499 | 42 |
1571957 | 1571957 | 2021-07-31 | Jefferson | Oregon | 41031 | 2499 | 42 |
1568709 | 1568709 | 2021-07-30 | Jefferson | Oregon | 41031 | 2499 | 42 |
1565461 | 1565461 | 2021-07-29 | Jefferson | Oregon | 41031 | 2493 | 42 |
1562213 | 1562213 | 2021-07-28 | Jefferson | Oregon | 41031 | 2489 | 42 |
1558965 | 1558965 | 2021-07-27 | Jefferson | Oregon | 41031 | 2482 | 42 |
1555718 | 1555718 | 2021-07-26 | Jefferson | Oregon | 41031 | 2463 | 42 |
1552471 | 1552471 | 2021-07-25 | Jefferson | Oregon | 41031 | 2456 | 42 |
1549224 | 1549224 | 2021-07-24 | Jefferson | Oregon | 41031 | 2456 | 42 |
1545977 | 1545977 | 2021-07-23 | Jefferson | Oregon | 41031 | 2456 | 42 |
1542730 | 1542730 | 2021-07-22 | Jefferson | Oregon | 41031 | 2446 | 42 |
1539482 | 1539482 | 2021-07-21 | Jefferson | Oregon | 41031 | 2439 | 42 |
1536235 | 1536235 | 2021-07-20 | Jefferson | Oregon | 41031 | 2433 | 42 |
1532987 | 1532987 | 2021-07-19 | Jefferson | Oregon | 41031 | 2427 | 42 |
1529740 | 1529740 | 2021-07-18 | Jefferson | Oregon | 41031 | 2416 | 42 |
1526493 | 1526493 | 2021-07-17 | Jefferson | Oregon | 41031 | 2416 | 42 |
1523246 | 1523246 | 2021-07-16 | Jefferson | Oregon | 41031 | 2416 | 42 |
1519998 | 1519998 | 2021-07-15 | Jefferson | Oregon | 41031 | 2416 | 42 |
1516750 | 1516750 | 2021-07-14 | Jefferson | Oregon | 41031 | 2415 | 42 |
1513503 | 1513503 | 2021-07-13 | Jefferson | Oregon | 41031 | 2416 | 42 |
1510257 | 1510257 | 2021-07-12 | Jefferson | Oregon | 41031 | 2412 | 42 |
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);