ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Douglas", fips = 8035 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810380 | 1810380 | 2021-10-13 | Douglas | Colorado | 8035 | 39406 | 308 |
1807131 | 1807131 | 2021-10-12 | Douglas | Colorado | 8035 | 39223 | 308 |
1803880 | 1803880 | 2021-10-11 | Douglas | Colorado | 8035 | 39223 | 308 |
1800631 | 1800631 | 2021-10-10 | Douglas | Colorado | 8035 | 39018 | 306 |
1797382 | 1797382 | 2021-10-09 | Douglas | Colorado | 8035 | 38911 | 305 |
1794133 | 1794133 | 2021-10-08 | Douglas | Colorado | 8035 | 38911 | 305 |
1790885 | 1790885 | 2021-10-07 | Douglas | Colorado | 8035 | 38740 | 302 |
1787636 | 1787636 | 2021-10-06 | Douglas | Colorado | 8035 | 38521 | 301 |
1784387 | 1784387 | 2021-10-05 | Douglas | Colorado | 8035 | 38387 | 299 |
1781138 | 1781138 | 2021-10-04 | Douglas | Colorado | 8035 | 38299 | 296 |
1777888 | 1777888 | 2021-10-03 | Douglas | Colorado | 8035 | 38299 | 296 |
1774638 | 1774638 | 2021-10-02 | Douglas | Colorado | 8035 | 38167 | 294 |
1771388 | 1771388 | 2021-10-01 | Douglas | Colorado | 8035 | 38062 | 292 |
1768139 | 1768139 | 2021-09-30 | Douglas | Colorado | 8035 | 37908 | 289 |
1764890 | 1764890 | 2021-09-29 | Douglas | Colorado | 8035 | 37769 | 287 |
1761641 | 1761641 | 2021-09-28 | Douglas | Colorado | 8035 | 37769 | 287 |
1758393 | 1758393 | 2021-09-27 | Douglas | Colorado | 8035 | 37553 | 287 |
1755145 | 1755145 | 2021-09-26 | Douglas | Colorado | 8035 | 37481 | 286 |
1751897 | 1751897 | 2021-09-25 | Douglas | Colorado | 8035 | 37396 | 285 |
1748648 | 1748648 | 2021-09-24 | Douglas | Colorado | 8035 | 37271 | 285 |
1745398 | 1745398 | 2021-09-23 | Douglas | Colorado | 8035 | 37271 | 285 |
1742149 | 1742149 | 2021-09-22 | Douglas | Colorado | 8035 | 37110 | 284 |
1738900 | 1738900 | 2021-09-21 | Douglas | Colorado | 8035 | 37110 | 284 |
1735651 | 1735651 | 2021-09-20 | Douglas | Colorado | 8035 | 37008 | 284 |
1732401 | 1732401 | 2021-09-19 | Douglas | Colorado | 8035 | 36934 | 284 |
1729151 | 1729151 | 2021-09-18 | Douglas | Colorado | 8035 | 36612 | 282 |
1725901 | 1725901 | 2021-09-17 | Douglas | Colorado | 8035 | 36612 | 282 |
1722652 | 1722652 | 2021-09-16 | Douglas | Colorado | 8035 | 36474 | 281 |
1719403 | 1719403 | 2021-09-15 | Douglas | Colorado | 8035 | 36358 | 280 |
1716155 | 1716155 | 2021-09-14 | Douglas | Colorado | 8035 | 36357 | 280 |
1712909 | 1712909 | 2021-09-13 | Douglas | Colorado | 8035 | 36110 | 279 |
1709662 | 1709662 | 2021-09-12 | Douglas | Colorado | 8035 | 36078 | 279 |
1706415 | 1706415 | 2021-09-11 | Douglas | Colorado | 8035 | 35784 | 279 |
1703167 | 1703167 | 2021-09-10 | Douglas | Colorado | 8035 | 35784 | 279 |
1699917 | 1699917 | 2021-09-09 | Douglas | Colorado | 8035 | 35783 | 279 |
1696668 | 1696668 | 2021-09-08 | Douglas | Colorado | 8035 | 35685 | 279 |
1693420 | 1693420 | 2021-09-07 | Douglas | Colorado | 8035 | 35466 | 279 |
1690171 | 1690171 | 2021-09-06 | Douglas | Colorado | 8035 | 35342 | 278 |
1686921 | 1686921 | 2021-09-05 | Douglas | Colorado | 8035 | 35342 | 278 |
1683671 | 1683671 | 2021-09-04 | Douglas | Colorado | 8035 | 35110 | 278 |
1680420 | 1680420 | 2021-09-03 | Douglas | Colorado | 8035 | 35110 | 278 |
1677172 | 1677172 | 2021-09-02 | Douglas | Colorado | 8035 | 34978 | 278 |
1673925 | 1673925 | 2021-09-01 | Douglas | Colorado | 8035 | 34675 | 278 |
1670677 | 1670677 | 2021-08-31 | Douglas | Colorado | 8035 | 34675 | 278 |
1667430 | 1667430 | 2021-08-30 | Douglas | Colorado | 8035 | 34545 | 278 |
1664183 | 1664183 | 2021-08-29 | Douglas | Colorado | 8035 | 34426 | 278 |
1660935 | 1660935 | 2021-08-28 | Douglas | Colorado | 8035 | 34426 | 278 |
1657687 | 1657687 | 2021-08-27 | Douglas | Colorado | 8035 | 34181 | 278 |
1654439 | 1654439 | 2021-08-26 | Douglas | Colorado | 8035 | 34181 | 278 |
1651192 | 1651192 | 2021-08-25 | Douglas | Colorado | 8035 | 33947 | 277 |
1647943 | 1647943 | 2021-08-24 | Douglas | Colorado | 8035 | 33854 | 276 |
1644695 | 1644695 | 2021-08-23 | Douglas | Colorado | 8035 | 33854 | 276 |
1641445 | 1641445 | 2021-08-22 | Douglas | Colorado | 8035 | 33780 | 276 |
1638195 | 1638195 | 2021-08-21 | Douglas | Colorado | 8035 | 33549 | 276 |
1634945 | 1634945 | 2021-08-20 | Douglas | Colorado | 8035 | 33441 | 276 |
1631696 | 1631696 | 2021-08-19 | Douglas | Colorado | 8035 | 33304 | 276 |
1628449 | 1628449 | 2021-08-18 | Douglas | Colorado | 8035 | 33304 | 276 |
1625202 | 1625202 | 2021-08-17 | Douglas | Colorado | 8035 | 33172 | 276 |
1621955 | 1621955 | 2021-08-16 | Douglas | Colorado | 8035 | 33081 | 276 |
1618708 | 1618708 | 2021-08-15 | Douglas | Colorado | 8035 | 33081 | 276 |
1615460 | 1615460 | 2021-08-14 | Douglas | Colorado | 8035 | 32948 | 276 |
1612211 | 1612211 | 2021-08-13 | Douglas | Colorado | 8035 | 32948 | 276 |
1608963 | 1608963 | 2021-08-12 | Douglas | Colorado | 8035 | 32720 | 276 |
1605714 | 1605714 | 2021-08-11 | Douglas | Colorado | 8035 | 32721 | 276 |
1602465 | 1602465 | 2021-08-10 | Douglas | Colorado | 8035 | 32680 | 276 |
1599216 | 1599216 | 2021-08-09 | Douglas | Colorado | 8035 | 32617 | 276 |
1595967 | 1595967 | 2021-08-08 | Douglas | Colorado | 8035 | 32567 | 276 |
1592718 | 1592718 | 2021-08-07 | Douglas | Colorado | 8035 | 32496 | 275 |
1589469 | 1589469 | 2021-08-06 | Douglas | Colorado | 8035 | 32276 | 273 |
1586220 | 1586220 | 2021-08-05 | Douglas | Colorado | 8035 | 32276 | 273 |
1582970 | 1582970 | 2021-08-04 | Douglas | Colorado | 8035 | 32227 | 273 |
1579720 | 1579720 | 2021-08-03 | Douglas | Colorado | 8035 | 32227 | 273 |
1576472 | 1576472 | 2021-08-02 | Douglas | Colorado | 8035 | 32172 | 273 |
1573224 | 1573224 | 2021-08-01 | Douglas | Colorado | 8035 | 32135 | 273 |
1569976 | 1569976 | 2021-07-31 | Douglas | Colorado | 8035 | 32079 | 273 |
1566728 | 1566728 | 2021-07-30 | Douglas | Colorado | 8035 | 31969 | 273 |
1563480 | 1563480 | 2021-07-29 | Douglas | Colorado | 8035 | 31969 | 273 |
1560232 | 1560232 | 2021-07-28 | Douglas | Colorado | 8035 | 31876 | 273 |
1556985 | 1556985 | 2021-07-27 | Douglas | Colorado | 8035 | 31876 | 273 |
1553738 | 1553738 | 2021-07-26 | Douglas | Colorado | 8035 | 31824 | 273 |
1550491 | 1550491 | 2021-07-25 | Douglas | Colorado | 8035 | 31798 | 273 |
1547244 | 1547244 | 2021-07-24 | Douglas | Colorado | 8035 | 31726 | 272 |
1543997 | 1543997 | 2021-07-23 | Douglas | Colorado | 8035 | 31688 | 272 |
1540749 | 1540749 | 2021-07-22 | Douglas | Colorado | 8035 | 31688 | 272 |
1537502 | 1537502 | 2021-07-21 | Douglas | Colorado | 8035 | 31637 | 272 |
1534254 | 1534254 | 2021-07-20 | Douglas | Colorado | 8035 | 31637 | 272 |
1531007 | 1531007 | 2021-07-19 | Douglas | Colorado | 8035 | 31603 | 272 |
1527760 | 1527760 | 2021-07-18 | Douglas | Colorado | 8035 | 31588 | 272 |
1524513 | 1524513 | 2021-07-17 | Douglas | Colorado | 8035 | 31555 | 271 |
1521265 | 1521265 | 2021-07-16 | Douglas | Colorado | 8035 | 31555 | 271 |
1518017 | 1518017 | 2021-07-15 | Douglas | Colorado | 8035 | 31536 | 270 |
1514770 | 1514770 | 2021-07-14 | Douglas | Colorado | 8035 | 31503 | 268 |
1511524 | 1511524 | 2021-07-13 | Douglas | Colorado | 8035 | 31467 | 268 |
1508277 | 1508277 | 2021-07-12 | Douglas | Colorado | 8035 | 31444 | 268 |
1505031 | 1505031 | 2021-07-11 | Douglas | Colorado | 8035 | 31428 | 268 |
1501785 | 1501785 | 2021-07-10 | Douglas | Colorado | 8035 | 31403 | 267 |
1498539 | 1498539 | 2021-07-09 | Douglas | Colorado | 8035 | 31319 | 266 |
1495292 | 1495292 | 2021-07-08 | Douglas | Colorado | 8035 | 31293 | 266 |
1492046 | 1492046 | 2021-07-07 | Douglas | Colorado | 8035 | 31281 | 266 |
1488799 | 1488799 | 2021-07-06 | Douglas | Colorado | 8035 | 31257 | 266 |
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);