ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840904 | 1840904 | 2021-10-22 | Jefferson | Missouri | 29099 | 32056 | 326 |
1837655 | 1837655 | 2021-10-21 | Jefferson | Missouri | 29099 | 31972 | 324 |
1834406 | 1834406 | 2021-10-20 | Jefferson | Missouri | 29099 | 31929 | 324 |
1831157 | 1831157 | 2021-10-19 | Jefferson | Missouri | 29099 | 31874 | 324 |
1827908 | 1827908 | 2021-10-18 | Jefferson | Missouri | 29099 | 31827 | 320 |
1824659 | 1824659 | 2021-10-17 | Jefferson | Missouri | 29099 | 31807 | 320 |
1821410 | 1821410 | 2021-10-16 | Jefferson | Missouri | 29099 | 31771 | 320 |
1818161 | 1818161 | 2021-10-15 | Jefferson | Missouri | 29099 | 31705 | 320 |
1814912 | 1814912 | 2021-10-14 | Jefferson | Missouri | 29099 | 31637 | 320 |
1811664 | 1811664 | 2021-10-13 | Jefferson | Missouri | 29099 | 31570 | 320 |
1808415 | 1808415 | 2021-10-12 | Jefferson | Missouri | 29099 | 31494 | 317 |
1805164 | 1805164 | 2021-10-11 | Jefferson | Missouri | 29099 | 31432 | 317 |
1801915 | 1801915 | 2021-10-10 | Jefferson | Missouri | 29099 | 31376 | 317 |
1798666 | 1798666 | 2021-10-09 | Jefferson | Missouri | 29099 | 31337 | 317 |
1795417 | 1795417 | 2021-10-08 | Jefferson | Missouri | 29099 | 31259 | 317 |
1792168 | 1792168 | 2021-10-07 | Jefferson | Missouri | 29099 | 31167 | 317 |
1788919 | 1788919 | 2021-10-06 | Jefferson | Missouri | 29099 | 31098 | 317 |
1785671 | 1785671 | 2021-10-05 | Jefferson | Missouri | 29099 | 30967 | 317 |
1782422 | 1782422 | 2021-10-04 | Jefferson | Missouri | 29099 | 30904 | 305 |
1779172 | 1779172 | 2021-10-03 | Jefferson | Missouri | 29099 | 30855 | 305 |
1775922 | 1775922 | 2021-10-02 | Jefferson | Missouri | 29099 | 30787 | 305 |
1772672 | 1772672 | 2021-10-01 | Jefferson | Missouri | 29099 | 30712 | 305 |
1769423 | 1769423 | 2021-09-30 | Jefferson | Missouri | 29099 | 30594 | 305 |
1766174 | 1766174 | 2021-09-29 | Jefferson | Missouri | 29099 | 30492 | 305 |
1762925 | 1762925 | 2021-09-28 | Jefferson | Missouri | 29099 | 30385 | 303 |
1759676 | 1759676 | 2021-09-27 | Jefferson | Missouri | 29099 | 30311 | 298 |
1756428 | 1756428 | 2021-09-26 | Jefferson | Missouri | 29099 | 30262 | 298 |
1753180 | 1753180 | 2021-09-25 | Jefferson | Missouri | 29099 | 30179 | 298 |
1749932 | 1749932 | 2021-09-24 | Jefferson | Missouri | 29099 | 30091 | 298 |
1746682 | 1746682 | 2021-09-23 | Jefferson | Missouri | 29099 | 29988 | 297 |
1743433 | 1743433 | 2021-09-22 | Jefferson | Missouri | 29099 | 29853 | 296 |
1740184 | 1740184 | 2021-09-21 | Jefferson | Missouri | 29099 | 29729 | 295 |
1736935 | 1736935 | 2021-09-20 | Jefferson | Missouri | 29099 | 29636 | 288 |
1733685 | 1733685 | 2021-09-19 | Jefferson | Missouri | 29099 | 29556 | 288 |
1730435 | 1730435 | 2021-09-18 | Jefferson | Missouri | 29099 | 29477 | 288 |
1727185 | 1727185 | 2021-09-17 | Jefferson | Missouri | 29099 | 29367 | 288 |
1723936 | 1723936 | 2021-09-16 | Jefferson | Missouri | 29099 | 29250 | 288 |
1720687 | 1720687 | 2021-09-15 | Jefferson | Missouri | 29099 | 29130 | 288 |
1717439 | 1717439 | 2021-09-14 | Jefferson | Missouri | 29099 | 28981 | 288 |
1714191 | 1714191 | 2021-09-13 | Jefferson | Missouri | 29099 | 28907 | 284 |
1710945 | 1710945 | 2021-09-12 | Jefferson | Missouri | 29099 | 28826 | 284 |
1707698 | 1707698 | 2021-09-11 | Jefferson | Missouri | 29099 | 28734 | 284 |
1704451 | 1704451 | 2021-09-10 | Jefferson | Missouri | 29099 | 28611 | 284 |
1701201 | 1701201 | 2021-09-09 | Jefferson | Missouri | 29099 | 28478 | 284 |
1697952 | 1697952 | 2021-09-08 | Jefferson | Missouri | 29099 | 28355 | 283 |
1694704 | 1694704 | 2021-09-07 | Jefferson | Missouri | 29099 | 28257 | 279 |
1691455 | 1691455 | 2021-09-06 | Jefferson | Missouri | 29099 | 28181 | 279 |
1688205 | 1688205 | 2021-09-05 | Jefferson | Missouri | 29099 | 28123 | 278 |
1684955 | 1684955 | 2021-09-04 | Jefferson | Missouri | 29099 | 28034 | 278 |
1681704 | 1681704 | 2021-09-03 | Jefferson | Missouri | 29099 | 27949 | 278 |
1678456 | 1678456 | 2021-09-02 | Jefferson | Missouri | 29099 | 27829 | 278 |
1675208 | 1675208 | 2021-09-01 | Jefferson | Missouri | 29099 | 27695 | 278 |
1671960 | 1671960 | 2021-08-31 | Jefferson | Missouri | 29099 | 27581 | 278 |
1668713 | 1668713 | 2021-08-30 | Jefferson | Missouri | 29099 | 27538 | 271 |
1665466 | 1665466 | 2021-08-29 | Jefferson | Missouri | 29099 | 27451 | 271 |
1662218 | 1662218 | 2021-08-28 | Jefferson | Missouri | 29099 | 27397 | 270 |
1658970 | 1658970 | 2021-08-27 | Jefferson | Missouri | 29099 | 27305 | 270 |
1655721 | 1655721 | 2021-08-26 | Jefferson | Missouri | 29099 | 27214 | 270 |
1652474 | 1652474 | 2021-08-25 | Jefferson | Missouri | 29099 | 27120 | 269 |
1649226 | 1649226 | 2021-08-24 | Jefferson | Missouri | 29099 | 27009 | 269 |
1645977 | 1645977 | 2021-08-23 | Jefferson | Missouri | 29099 | 26928 | 266 |
1642728 | 1642728 | 2021-08-22 | Jefferson | Missouri | 29099 | 26868 | 266 |
1639478 | 1639478 | 2021-08-21 | Jefferson | Missouri | 29099 | 26798 | 266 |
1636228 | 1636228 | 2021-08-20 | Jefferson | Missouri | 29099 | 26723 | 266 |
1632978 | 1632978 | 2021-08-19 | Jefferson | Missouri | 29099 | 26648 | 266 |
1629731 | 1629731 | 2021-08-18 | Jefferson | Missouri | 29099 | 26548 | 266 |
1626484 | 1626484 | 2021-08-17 | Jefferson | Missouri | 29099 | 26462 | 266 |
1623237 | 1623237 | 2021-08-16 | Jefferson | Missouri | 29099 | 26418 | 264 |
1619990 | 1619990 | 2021-08-15 | Jefferson | Missouri | 29099 | 26374 | 264 |
1616742 | 1616742 | 2021-08-14 | Jefferson | Missouri | 29099 | 26307 | 264 |
1613494 | 1613494 | 2021-08-13 | Jefferson | Missouri | 29099 | 26220 | 264 |
1610245 | 1610245 | 2021-08-12 | Jefferson | Missouri | 29099 | 26150 | 264 |
1606997 | 1606997 | 2021-08-11 | Jefferson | Missouri | 29099 | 26044 | 264 |
1603748 | 1603748 | 2021-08-10 | Jefferson | Missouri | 29099 | 25896 | 264 |
1600499 | 1600499 | 2021-08-09 | Jefferson | Missouri | 29099 | 25838 | 260 |
1597251 | 1597251 | 2021-08-08 | Jefferson | Missouri | 29099 | 25785 | 260 |
1594002 | 1594002 | 2021-08-07 | Jefferson | Missouri | 29099 | 25743 | 260 |
1590753 | 1590753 | 2021-08-06 | Jefferson | Missouri | 29099 | 25666 | 260 |
1587504 | 1587504 | 2021-08-05 | Jefferson | Missouri | 29099 | 25585 | 260 |
1584253 | 1584253 | 2021-08-04 | Jefferson | Missouri | 29099 | 25463 | 260 |
1581004 | 1581004 | 2021-08-03 | Jefferson | Missouri | 29099 | 25269 | 260 |
1577755 | 1577755 | 2021-08-02 | Jefferson | Missouri | 29099 | 25192 | 257 |
1574507 | 1574507 | 2021-08-01 | Jefferson | Missouri | 29099 | 25150 | 257 |
1571259 | 1571259 | 2021-07-31 | Jefferson | Missouri | 29099 | 25088 | 257 |
1568011 | 1568011 | 2021-07-30 | Jefferson | Missouri | 29099 | 25019 | 256 |
1564763 | 1564763 | 2021-07-29 | Jefferson | Missouri | 29099 | 24917 | 255 |
1561515 | 1561515 | 2021-07-28 | Jefferson | Missouri | 29099 | 24857 | 255 |
1558267 | 1558267 | 2021-07-27 | Jefferson | Missouri | 29099 | 24783 | 255 |
1555020 | 1555020 | 2021-07-26 | Jefferson | Missouri | 29099 | 24720 | 255 |
1551773 | 1551773 | 2021-07-25 | Jefferson | Missouri | 29099 | 24676 | 255 |
1548526 | 1548526 | 2021-07-24 | Jefferson | Missouri | 29099 | 24625 | 255 |
1545279 | 1545279 | 2021-07-23 | Jefferson | Missouri | 29099 | 24580 | 255 |
1542031 | 1542031 | 2021-07-22 | Jefferson | Missouri | 29099 | 24527 | 255 |
1538784 | 1538784 | 2021-07-21 | Jefferson | Missouri | 29099 | 24463 | 255 |
1535537 | 1535537 | 2021-07-20 | Jefferson | Missouri | 29099 | 24387 | 255 |
1532289 | 1532289 | 2021-07-19 | Jefferson | Missouri | 29099 | 24341 | 255 |
1529042 | 1529042 | 2021-07-18 | Jefferson | Missouri | 29099 | 24312 | 255 |
1525795 | 1525795 | 2021-07-17 | Jefferson | Missouri | 29099 | 24282 | 255 |
1522548 | 1522548 | 2021-07-16 | Jefferson | Missouri | 29099 | 24241 | 255 |
1519299 | 1519299 | 2021-07-15 | Jefferson | Missouri | 29099 | 24188 | 255 |
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);