ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,174 rows where deaths = 6 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Atchison 266
- Iron 59
- Chariton 54
- Clark 54
- Pemiscot 50
- Carter 42
- Mississippi 35
- Oregon 35
- Platte 30
- Hickory 28
- Schuyler 28
- Reynolds 27
- Barry 23
- Maries 21
- Montgomery 21
- Shelby 21
- Cass 19
- Dunklin 18
- Newton 18
- Sullivan 17
- Stone 16
- Cooper 14
- Osage 14
- Ray 14
- Wayne 14
- Christian 13
- St. Clair 13
- Carroll 10
- Saline 10
- Butler 9
- …
state 1
- Missouri · 1,174 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1808457 | 1808457 | 2021-10-12 | Reynolds | Missouri | 29179 | 763 | 6 |
1805206 | 1805206 | 2021-10-11 | Reynolds | Missouri | 29179 | 763 | 6 |
1801957 | 1801957 | 2021-10-10 | Reynolds | Missouri | 29179 | 763 | 6 |
1798708 | 1798708 | 2021-10-09 | Reynolds | Missouri | 29179 | 763 | 6 |
1795459 | 1795459 | 2021-10-08 | Reynolds | Missouri | 29179 | 763 | 6 |
1792210 | 1792210 | 2021-10-07 | Reynolds | Missouri | 29179 | 763 | 6 |
1788961 | 1788961 | 2021-10-06 | Reynolds | Missouri | 29179 | 761 | 6 |
1785713 | 1785713 | 2021-10-05 | Reynolds | Missouri | 29179 | 761 | 6 |
1782375 | 1782375 | 2021-10-04 | Atchison | Missouri | 29005 | 631 | 6 |
1782464 | 1782464 | 2021-10-04 | Reynolds | Missouri | 29179 | 758 | 6 |
1779125 | 1779125 | 2021-10-03 | Atchison | Missouri | 29005 | 631 | 6 |
1779214 | 1779214 | 2021-10-03 | Reynolds | Missouri | 29179 | 758 | 6 |
1775875 | 1775875 | 2021-10-02 | Atchison | Missouri | 29005 | 631 | 6 |
1775964 | 1775964 | 2021-10-02 | Reynolds | Missouri | 29179 | 758 | 6 |
1772625 | 1772625 | 2021-10-01 | Atchison | Missouri | 29005 | 631 | 6 |
1772714 | 1772714 | 2021-10-01 | Reynolds | Missouri | 29179 | 758 | 6 |
1769376 | 1769376 | 2021-09-30 | Atchison | Missouri | 29005 | 628 | 6 |
1769465 | 1769465 | 2021-09-30 | Reynolds | Missouri | 29179 | 758 | 6 |
1766127 | 1766127 | 2021-09-29 | Atchison | Missouri | 29005 | 626 | 6 |
1766216 | 1766216 | 2021-09-29 | Reynolds | Missouri | 29179 | 753 | 6 |
1762878 | 1762878 | 2021-09-28 | Atchison | Missouri | 29005 | 621 | 6 |
1762967 | 1762967 | 2021-09-28 | Reynolds | Missouri | 29179 | 753 | 6 |
1759629 | 1759629 | 2021-09-27 | Atchison | Missouri | 29005 | 622 | 6 |
1759718 | 1759718 | 2021-09-27 | Reynolds | Missouri | 29179 | 753 | 6 |
1756381 | 1756381 | 2021-09-26 | Atchison | Missouri | 29005 | 622 | 6 |
1756470 | 1756470 | 2021-09-26 | Reynolds | Missouri | 29179 | 747 | 6 |
1753133 | 1753133 | 2021-09-25 | Atchison | Missouri | 29005 | 622 | 6 |
1753222 | 1753222 | 2021-09-25 | Reynolds | Missouri | 29179 | 747 | 6 |
1749885 | 1749885 | 2021-09-24 | Atchison | Missouri | 29005 | 620 | 6 |
1749974 | 1749974 | 2021-09-24 | Reynolds | Missouri | 29179 | 747 | 6 |
1746635 | 1746635 | 2021-09-23 | Atchison | Missouri | 29005 | 619 | 6 |
1746724 | 1746724 | 2021-09-23 | Reynolds | Missouri | 29179 | 747 | 6 |
1743386 | 1743386 | 2021-09-22 | Atchison | Missouri | 29005 | 617 | 6 |
1743475 | 1743475 | 2021-09-22 | Reynolds | Missouri | 29179 | 739 | 6 |
1740137 | 1740137 | 2021-09-21 | Atchison | Missouri | 29005 | 612 | 6 |
1740226 | 1740226 | 2021-09-21 | Reynolds | Missouri | 29179 | 739 | 6 |
1736888 | 1736888 | 2021-09-20 | Atchison | Missouri | 29005 | 612 | 6 |
1736977 | 1736977 | 2021-09-20 | Reynolds | Missouri | 29179 | 739 | 6 |
1733638 | 1733638 | 2021-09-19 | Atchison | Missouri | 29005 | 612 | 6 |
1733727 | 1733727 | 2021-09-19 | Reynolds | Missouri | 29179 | 736 | 6 |
1730388 | 1730388 | 2021-09-18 | Atchison | Missouri | 29005 | 612 | 6 |
1730477 | 1730477 | 2021-09-18 | Reynolds | Missouri | 29179 | 736 | 6 |
1727138 | 1727138 | 2021-09-17 | Atchison | Missouri | 29005 | 608 | 6 |
1727227 | 1727227 | 2021-09-17 | Reynolds | Missouri | 29179 | 736 | 6 |
1723889 | 1723889 | 2021-09-16 | Atchison | Missouri | 29005 | 604 | 6 |
1723978 | 1723978 | 2021-09-16 | Reynolds | Missouri | 29179 | 736 | 6 |
1720640 | 1720640 | 2021-09-15 | Atchison | Missouri | 29005 | 599 | 6 |
1717392 | 1717392 | 2021-09-14 | Atchison | Missouri | 29005 | 590 | 6 |
1714144 | 1714144 | 2021-09-13 | Atchison | Missouri | 29005 | 589 | 6 |
1710898 | 1710898 | 2021-09-12 | Atchison | Missouri | 29005 | 589 | 6 |
1707651 | 1707651 | 2021-09-11 | Atchison | Missouri | 29005 | 588 | 6 |
1704404 | 1704404 | 2021-09-10 | Atchison | Missouri | 29005 | 584 | 6 |
1701154 | 1701154 | 2021-09-09 | Atchison | Missouri | 29005 | 581 | 6 |
1697905 | 1697905 | 2021-09-08 | Atchison | Missouri | 29005 | 581 | 6 |
1694657 | 1694657 | 2021-09-07 | Atchison | Missouri | 29005 | 578 | 6 |
1694742 | 1694742 | 2021-09-07 | Putnam | Missouri | 29171 | 555 | 6 |
1691408 | 1691408 | 2021-09-06 | Atchison | Missouri | 29005 | 578 | 6 |
1691493 | 1691493 | 2021-09-06 | Putnam | Missouri | 29171 | 551 | 6 |
1688158 | 1688158 | 2021-09-05 | Atchison | Missouri | 29005 | 578 | 6 |
1688243 | 1688243 | 2021-09-05 | Putnam | Missouri | 29171 | 550 | 6 |
1684908 | 1684908 | 2021-09-04 | Atchison | Missouri | 29005 | 578 | 6 |
1684993 | 1684993 | 2021-09-04 | Putnam | Missouri | 29171 | 550 | 6 |
1681657 | 1681657 | 2021-09-03 | Atchison | Missouri | 29005 | 578 | 6 |
1681742 | 1681742 | 2021-09-03 | Putnam | Missouri | 29171 | 550 | 6 |
1678409 | 1678409 | 2021-09-02 | Atchison | Missouri | 29005 | 576 | 6 |
1678494 | 1678494 | 2021-09-02 | Putnam | Missouri | 29171 | 547 | 6 |
1675161 | 1675161 | 2021-09-01 | Atchison | Missouri | 29005 | 570 | 6 |
1675246 | 1675246 | 2021-09-01 | Putnam | Missouri | 29171 | 545 | 6 |
1671913 | 1671913 | 2021-08-31 | Atchison | Missouri | 29005 | 565 | 6 |
1671998 | 1671998 | 2021-08-31 | Putnam | Missouri | 29171 | 545 | 6 |
1668666 | 1668666 | 2021-08-30 | Atchison | Missouri | 29005 | 565 | 6 |
1665419 | 1665419 | 2021-08-29 | Atchison | Missouri | 29005 | 564 | 6 |
1662171 | 1662171 | 2021-08-28 | Atchison | Missouri | 29005 | 564 | 6 |
1658923 | 1658923 | 2021-08-27 | Atchison | Missouri | 29005 | 564 | 6 |
1655674 | 1655674 | 2021-08-26 | Atchison | Missouri | 29005 | 558 | 6 |
1652427 | 1652427 | 2021-08-25 | Atchison | Missouri | 29005 | 552 | 6 |
1649179 | 1649179 | 2021-08-24 | Atchison | Missouri | 29005 | 554 | 6 |
1645930 | 1645930 | 2021-08-23 | Atchison | Missouri | 29005 | 548 | 6 |
1646004 | 1646004 | 2021-08-23 | Oregon | Missouri | 29149 | 1133 | 6 |
1642681 | 1642681 | 2021-08-22 | Atchison | Missouri | 29005 | 546 | 6 |
1642755 | 1642755 | 2021-08-22 | Oregon | Missouri | 29149 | 1126 | 6 |
1639431 | 1639431 | 2021-08-21 | Atchison | Missouri | 29005 | 544 | 6 |
1639505 | 1639505 | 2021-08-21 | Oregon | Missouri | 29149 | 1124 | 6 |
1636181 | 1636181 | 2021-08-20 | Atchison | Missouri | 29005 | 542 | 6 |
1636255 | 1636255 | 2021-08-20 | Oregon | Missouri | 29149 | 1121 | 6 |
1632931 | 1632931 | 2021-08-19 | Atchison | Missouri | 29005 | 532 | 6 |
1633005 | 1633005 | 2021-08-19 | Oregon | Missouri | 29149 | 1115 | 6 |
1629684 | 1629684 | 2021-08-18 | Atchison | Missouri | 29005 | 524 | 6 |
1629758 | 1629758 | 2021-08-18 | Oregon | Missouri | 29149 | 1106 | 6 |
1626437 | 1626437 | 2021-08-17 | Atchison | Missouri | 29005 | 520 | 6 |
1626511 | 1626511 | 2021-08-17 | Oregon | Missouri | 29149 | 1103 | 6 |
1623190 | 1623190 | 2021-08-16 | Atchison | Missouri | 29005 | 515 | 6 |
1623264 | 1623264 | 2021-08-16 | Oregon | Missouri | 29149 | 1095 | 6 |
1619943 | 1619943 | 2021-08-15 | Atchison | Missouri | 29005 | 513 | 6 |
1620017 | 1620017 | 2021-08-15 | Oregon | Missouri | 29149 | 1092 | 6 |
1616695 | 1616695 | 2021-08-14 | Atchison | Missouri | 29005 | 513 | 6 |
1616769 | 1616769 | 2021-08-14 | Oregon | Missouri | 29149 | 1091 | 6 |
1613447 | 1613447 | 2021-08-13 | Atchison | Missouri | 29005 | 504 | 6 |
1613521 | 1613521 | 2021-08-13 | Oregon | Missouri | 29149 | 1085 | 6 |
1610198 | 1610198 | 2021-08-12 | Atchison | Missouri | 29005 | 503 | 6 |
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);