ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Douglas" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1818852 | 1818852 | 2021-10-15 | Douglas | Oregon | 41019 | 11795 | 240 |
1815603 | 1815603 | 2021-10-14 | Douglas | Oregon | 41019 | 11751 | 240 |
1812355 | 1812355 | 2021-10-13 | Douglas | Oregon | 41019 | 11713 | 240 |
1809106 | 1809106 | 2021-10-12 | Douglas | Oregon | 41019 | 11664 | 238 |
1805856 | 1805856 | 2021-10-11 | Douglas | Oregon | 41019 | 11624 | 236 |
1802606 | 1802606 | 2021-10-10 | Douglas | Oregon | 41019 | 11562 | 233 |
1799357 | 1799357 | 2021-10-09 | Douglas | Oregon | 41019 | 11562 | 233 |
1796108 | 1796108 | 2021-10-08 | Douglas | Oregon | 41019 | 11562 | 233 |
1792859 | 1792859 | 2021-10-07 | Douglas | Oregon | 41019 | 11523 | 231 |
1789610 | 1789610 | 2021-10-06 | Douglas | Oregon | 41019 | 11463 | 229 |
1786362 | 1786362 | 2021-10-05 | Douglas | Oregon | 41019 | 11414 | 226 |
1783113 | 1783113 | 2021-10-04 | Douglas | Oregon | 41019 | 11347 | 220 |
1779864 | 1779864 | 2021-10-03 | Douglas | Oregon | 41019 | 11288 | 220 |
1776614 | 1776614 | 2021-10-02 | Douglas | Oregon | 41019 | 11288 | 220 |
1773364 | 1773364 | 2021-10-01 | Douglas | Oregon | 41019 | 11288 | 220 |
1770114 | 1770114 | 2021-09-30 | Douglas | Oregon | 41019 | 11252 | 215 |
1766865 | 1766865 | 2021-09-29 | Douglas | Oregon | 41019 | 11176 | 215 |
1763616 | 1763616 | 2021-09-28 | Douglas | Oregon | 41019 | 11123 | 210 |
1760367 | 1760367 | 2021-09-27 | Douglas | Oregon | 41019 | 11044 | 207 |
1757119 | 1757119 | 2021-09-26 | Douglas | Oregon | 41019 | 10969 | 202 |
1753871 | 1753871 | 2021-09-25 | Douglas | Oregon | 41019 | 10969 | 202 |
1750623 | 1750623 | 2021-09-24 | Douglas | Oregon | 41019 | 10969 | 202 |
1747373 | 1747373 | 2021-09-23 | Douglas | Oregon | 41019 | 10920 | 195 |
1744124 | 1744124 | 2021-09-22 | Douglas | Oregon | 41019 | 10853 | 195 |
1740875 | 1740875 | 2021-09-21 | Douglas | Oregon | 41019 | 10795 | 188 |
1737626 | 1737626 | 2021-09-20 | Douglas | Oregon | 41019 | 10712 | 188 |
1734376 | 1734376 | 2021-09-19 | Douglas | Oregon | 41019 | 10599 | 185 |
1731126 | 1731126 | 2021-09-18 | Douglas | Oregon | 41019 | 10599 | 185 |
1727876 | 1727876 | 2021-09-17 | Douglas | Oregon | 41019 | 10599 | 185 |
1724627 | 1724627 | 2021-09-16 | Douglas | Oregon | 41019 | 10539 | 184 |
1721378 | 1721378 | 2021-09-15 | Douglas | Oregon | 41019 | 10459 | 183 |
1718130 | 1718130 | 2021-09-14 | Douglas | Oregon | 41019 | 10341 | 176 |
1714882 | 1714882 | 2021-09-13 | Douglas | Oregon | 41019 | 10242 | 173 |
1711636 | 1711636 | 2021-09-12 | Douglas | Oregon | 41019 | 10039 | 162 |
1708389 | 1708389 | 2021-09-11 | Douglas | Oregon | 41019 | 10039 | 162 |
1705142 | 1705142 | 2021-09-10 | Douglas | Oregon | 41019 | 10039 | 162 |
1701892 | 1701892 | 2021-09-09 | Douglas | Oregon | 41019 | 9909 | 162 |
1698643 | 1698643 | 2021-09-08 | Douglas | Oregon | 41019 | 9744 | 161 |
1695395 | 1695395 | 2021-09-07 | Douglas | Oregon | 41019 | 9611 | 154 |
1692147 | 1692147 | 2021-09-06 | Douglas | Oregon | 41019 | 9192 | 145 |
1688898 | 1688898 | 2021-09-05 | Douglas | Oregon | 41019 | 9192 | 145 |
1685648 | 1685648 | 2021-09-04 | Douglas | Oregon | 41019 | 9192 | 145 |
1682397 | 1682397 | 2021-09-03 | Douglas | Oregon | 41019 | 9192 | 145 |
1679147 | 1679147 | 2021-09-02 | Douglas | Oregon | 41019 | 9043 | 142 |
1675899 | 1675899 | 2021-09-01 | Douglas | Oregon | 41019 | 8900 | 140 |
1672652 | 1672652 | 2021-08-31 | Douglas | Oregon | 41019 | 8746 | 136 |
1669404 | 1669404 | 2021-08-30 | Douglas | Oregon | 41019 | 8570 | 134 |
1666157 | 1666157 | 2021-08-29 | Douglas | Oregon | 41019 | 8132 | 122 |
1662909 | 1662909 | 2021-08-28 | Douglas | Oregon | 41019 | 8132 | 122 |
1659661 | 1659661 | 2021-08-27 | Douglas | Oregon | 41019 | 8132 | 122 |
1656412 | 1656412 | 2021-08-26 | Douglas | Oregon | 41019 | 7919 | 122 |
1653165 | 1653165 | 2021-08-25 | Douglas | Oregon | 41019 | 7854 | 121 |
1649918 | 1649918 | 2021-08-24 | Douglas | Oregon | 41019 | 7609 | 116 |
1646669 | 1646669 | 2021-08-23 | Douglas | Oregon | 41019 | 7373 | 114 |
1643420 | 1643420 | 2021-08-22 | Douglas | Oregon | 41019 | 6979 | 109 |
1640170 | 1640170 | 2021-08-21 | Douglas | Oregon | 41019 | 6979 | 109 |
1636920 | 1636920 | 2021-08-20 | Douglas | Oregon | 41019 | 6979 | 109 |
1633670 | 1633670 | 2021-08-19 | Douglas | Oregon | 41019 | 6812 | 108 |
1630423 | 1630423 | 2021-08-18 | Douglas | Oregon | 41019 | 6580 | 105 |
1627176 | 1627176 | 2021-08-17 | Douglas | Oregon | 41019 | 6415 | 104 |
1623929 | 1623929 | 2021-08-16 | Douglas | Oregon | 41019 | 6121 | 103 |
1620682 | 1620682 | 2021-08-15 | Douglas | Oregon | 41019 | 5772 | 100 |
1617434 | 1617434 | 2021-08-14 | Douglas | Oregon | 41019 | 5772 | 100 |
1614186 | 1614186 | 2021-08-13 | Douglas | Oregon | 41019 | 5772 | 100 |
1610937 | 1610937 | 2021-08-12 | Douglas | Oregon | 41019 | 5629 | 99 |
1607689 | 1607689 | 2021-08-11 | Douglas | Oregon | 41019 | 5543 | 99 |
1604440 | 1604440 | 2021-08-10 | Douglas | Oregon | 41019 | 5353 | 96 |
1601191 | 1601191 | 2021-08-09 | Douglas | Oregon | 41019 | 5212 | 95 |
1597943 | 1597943 | 2021-08-08 | Douglas | Oregon | 41019 | 4947 | 94 |
1594694 | 1594694 | 2021-08-07 | Douglas | Oregon | 41019 | 4947 | 94 |
1591445 | 1591445 | 2021-08-06 | Douglas | Oregon | 41019 | 4947 | 94 |
1588196 | 1588196 | 2021-08-05 | Douglas | Oregon | 41019 | 4872 | 94 |
1584946 | 1584946 | 2021-08-04 | Douglas | Oregon | 41019 | 4795 | 94 |
1581696 | 1581696 | 2021-08-03 | Douglas | Oregon | 41019 | 4718 | 93 |
1578447 | 1578447 | 2021-08-02 | Douglas | Oregon | 41019 | 4636 | 89 |
1575199 | 1575199 | 2021-08-01 | Douglas | Oregon | 41019 | 4518 | 88 |
1571951 | 1571951 | 2021-07-31 | Douglas | Oregon | 41019 | 4518 | 88 |
1568703 | 1568703 | 2021-07-30 | Douglas | Oregon | 41019 | 4518 | 88 |
1565455 | 1565455 | 2021-07-29 | Douglas | Oregon | 41019 | 4461 | 88 |
1562207 | 1562207 | 2021-07-28 | Douglas | Oregon | 41019 | 4407 | 87 |
1558959 | 1558959 | 2021-07-27 | Douglas | Oregon | 41019 | 4358 | 87 |
1555712 | 1555712 | 2021-07-26 | Douglas | Oregon | 41019 | 4295 | 87 |
1552465 | 1552465 | 2021-07-25 | Douglas | Oregon | 41019 | 4235 | 87 |
1549218 | 1549218 | 2021-07-24 | Douglas | Oregon | 41019 | 4235 | 87 |
1545971 | 1545971 | 2021-07-23 | Douglas | Oregon | 41019 | 4235 | 87 |
1542724 | 1542724 | 2021-07-22 | Douglas | Oregon | 41019 | 4207 | 87 |
1539476 | 1539476 | 2021-07-21 | Douglas | Oregon | 41019 | 4188 | 86 |
1536229 | 1536229 | 2021-07-20 | Douglas | Oregon | 41019 | 4165 | 86 |
1532981 | 1532981 | 2021-07-19 | Douglas | Oregon | 41019 | 4151 | 86 |
1529734 | 1529734 | 2021-07-18 | Douglas | Oregon | 41019 | 4118 | 85 |
1526487 | 1526487 | 2021-07-17 | Douglas | Oregon | 41019 | 4118 | 85 |
1523240 | 1523240 | 2021-07-16 | Douglas | Oregon | 41019 | 4118 | 85 |
1519992 | 1519992 | 2021-07-15 | Douglas | Oregon | 41019 | 4104 | 85 |
1516744 | 1516744 | 2021-07-14 | Douglas | Oregon | 41019 | 4089 | 85 |
1513497 | 1513497 | 2021-07-13 | Douglas | Oregon | 41019 | 4079 | 85 |
1510251 | 1510251 | 2021-07-12 | Douglas | Oregon | 41019 | 4069 | 85 |
1507004 | 1507004 | 2021-07-11 | Douglas | Oregon | 41019 | 4047 | 85 |
1503758 | 1503758 | 2021-07-10 | Douglas | Oregon | 41019 | 4047 | 85 |
1500512 | 1500512 | 2021-07-09 | Douglas | Oregon | 41019 | 4047 | 85 |
1497266 | 1497266 | 2021-07-08 | Douglas | Oregon | 41019 | 4030 | 84 |
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);