ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,145 rows where deaths = 11 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Daviess 182
- Carter 105
- Linn 84
- Wayne 62
- Montgomery 52
- Monroe 49
- Caldwell 40
- Platte 37
- Oregon 35
- Nodaway 32
- Howard 24
- Audrain 21
- Gentry 21
- McDonald 21
- Holt 20
- Scott 18
- Madison 15
- Mercer 15
- Bollinger 14
- Grundy 14
- Pike 14
- Pulaski 14
- Saline 14
- Washington 13
- Benton 11
- Johnson 11
- Ste. Genevieve 11
- Ozark 10
- Wright 10
- Greene 9
- …
state 1
- Missouri · 1,145 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126952 | 2126952 | 2022-01-18 | Mercer | Missouri | 29129 | 576 | 11 |
2123700 | 2123700 | 2022-01-17 | Mercer | Missouri | 29129 | 572 | 11 |
2120448 | 2120448 | 2022-01-16 | Mercer | Missouri | 29129 | 572 | 11 |
2117196 | 2117196 | 2022-01-15 | Mercer | Missouri | 29129 | 572 | 11 |
2113945 | 2113945 | 2022-01-14 | Mercer | Missouri | 29129 | 568 | 11 |
2110693 | 2110693 | 2022-01-13 | Mercer | Missouri | 29129 | 565 | 11 |
2107442 | 2107442 | 2022-01-12 | Mercer | Missouri | 29129 | 562 | 11 |
2104191 | 2104191 | 2022-01-11 | Mercer | Missouri | 29129 | 557 | 11 |
2100940 | 2100940 | 2022-01-10 | Mercer | Missouri | 29129 | 555 | 11 |
2097689 | 2097689 | 2022-01-09 | Mercer | Missouri | 29129 | 553 | 11 |
2094437 | 2094437 | 2022-01-08 | Mercer | Missouri | 29129 | 553 | 11 |
2091185 | 2091185 | 2022-01-07 | Mercer | Missouri | 29129 | 551 | 11 |
2087934 | 2087934 | 2022-01-06 | Mercer | Missouri | 29129 | 548 | 11 |
2084682 | 2084682 | 2022-01-05 | Mercer | Missouri | 29129 | 548 | 11 |
2081430 | 2081430 | 2022-01-04 | Mercer | Missouri | 29129 | 542 | 11 |
1925428 | 1925428 | 2021-11-17 | Putnam | Missouri | 29171 | 659 | 11 |
1922168 | 1922168 | 2021-11-16 | Oregon | Missouri | 29149 | 1392 | 11 |
1922179 | 1922179 | 2021-11-16 | Putnam | Missouri | 29171 | 655 | 11 |
1918918 | 1918918 | 2021-11-15 | Oregon | Missouri | 29149 | 1381 | 11 |
1915668 | 1915668 | 2021-11-14 | Oregon | Missouri | 29149 | 1380 | 11 |
1912418 | 1912418 | 2021-11-13 | Oregon | Missouri | 29149 | 1377 | 11 |
1909168 | 1909168 | 2021-11-12 | Oregon | Missouri | 29149 | 1369 | 11 |
1905919 | 1905919 | 2021-11-11 | Oregon | Missouri | 29149 | 1365 | 11 |
1902670 | 1902670 | 2021-11-10 | Oregon | Missouri | 29149 | 1365 | 11 |
1899420 | 1899420 | 2021-11-09 | Oregon | Missouri | 29149 | 1359 | 11 |
1896170 | 1896170 | 2021-11-08 | Oregon | Missouri | 29149 | 1352 | 11 |
1892920 | 1892920 | 2021-11-07 | Oregon | Missouri | 29149 | 1350 | 11 |
1889670 | 1889670 | 2021-11-06 | Oregon | Missouri | 29149 | 1350 | 11 |
1886420 | 1886420 | 2021-11-05 | Oregon | Missouri | 29149 | 1345 | 11 |
1883171 | 1883171 | 2021-11-04 | Oregon | Missouri | 29149 | 1340 | 11 |
1879922 | 1879922 | 2021-11-03 | Oregon | Missouri | 29149 | 1338 | 11 |
1876673 | 1876673 | 2021-11-02 | Oregon | Missouri | 29149 | 1337 | 11 |
1873424 | 1873424 | 2021-11-01 | Oregon | Missouri | 29149 | 1335 | 11 |
1870175 | 1870175 | 2021-10-31 | Oregon | Missouri | 29149 | 1335 | 11 |
1866926 | 1866926 | 2021-10-30 | Oregon | Missouri | 29149 | 1334 | 11 |
1863677 | 1863677 | 2021-10-29 | Oregon | Missouri | 29149 | 1333 | 11 |
1860428 | 1860428 | 2021-10-28 | Oregon | Missouri | 29149 | 1333 | 11 |
1857179 | 1857179 | 2021-10-27 | Oregon | Missouri | 29149 | 1332 | 11 |
1853930 | 1853930 | 2021-10-26 | Oregon | Missouri | 29149 | 1331 | 11 |
1850681 | 1850681 | 2021-10-25 | Oregon | Missouri | 29149 | 1331 | 11 |
1847431 | 1847431 | 2021-10-24 | Oregon | Missouri | 29149 | 1331 | 11 |
1844181 | 1844181 | 2021-10-23 | Oregon | Missouri | 29149 | 1331 | 11 |
1840931 | 1840931 | 2021-10-22 | Oregon | Missouri | 29149 | 1330 | 11 |
1837682 | 1837682 | 2021-10-21 | Oregon | Missouri | 29149 | 1328 | 11 |
1834433 | 1834433 | 2021-10-20 | Oregon | Missouri | 29149 | 1328 | 11 |
1831184 | 1831184 | 2021-10-19 | Oregon | Missouri | 29149 | 1327 | 11 |
1827935 | 1827935 | 2021-10-18 | Oregon | Missouri | 29149 | 1325 | 11 |
1824686 | 1824686 | 2021-10-17 | Oregon | Missouri | 29149 | 1325 | 11 |
1821437 | 1821437 | 2021-10-16 | Oregon | Missouri | 29149 | 1323 | 11 |
1818188 | 1818188 | 2021-10-15 | Oregon | Missouri | 29149 | 1322 | 11 |
1814939 | 1814939 | 2021-10-14 | Oregon | Missouri | 29149 | 1320 | 11 |
1811691 | 1811691 | 2021-10-13 | Oregon | Missouri | 29149 | 1316 | 11 |
1772667 | 1772667 | 2021-10-01 | Howard | Missouri | 29089 | 1348 | 11 |
1769418 | 1769418 | 2021-09-30 | Howard | Missouri | 29089 | 1345 | 11 |
1766169 | 1766169 | 2021-09-29 | Howard | Missouri | 29089 | 1342 | 11 |
1762920 | 1762920 | 2021-09-28 | Howard | Missouri | 29089 | 1340 | 11 |
1759671 | 1759671 | 2021-09-27 | Howard | Missouri | 29089 | 1338 | 11 |
1756423 | 1756423 | 2021-09-26 | Howard | Missouri | 29089 | 1337 | 11 |
1753175 | 1753175 | 2021-09-25 | Howard | Missouri | 29089 | 1337 | 11 |
1749927 | 1749927 | 2021-09-24 | Howard | Missouri | 29089 | 1335 | 11 |
1746677 | 1746677 | 2021-09-23 | Howard | Missouri | 29089 | 1335 | 11 |
1743428 | 1743428 | 2021-09-22 | Howard | Missouri | 29089 | 1331 | 11 |
1740179 | 1740179 | 2021-09-21 | Howard | Missouri | 29089 | 1326 | 11 |
1736930 | 1736930 | 2021-09-20 | Howard | Missouri | 29089 | 1324 | 11 |
1733680 | 1733680 | 2021-09-19 | Howard | Missouri | 29089 | 1324 | 11 |
1730430 | 1730430 | 2021-09-18 | Howard | Missouri | 29089 | 1324 | 11 |
1727180 | 1727180 | 2021-09-17 | Howard | Missouri | 29089 | 1318 | 11 |
1723931 | 1723931 | 2021-09-16 | Howard | Missouri | 29089 | 1307 | 11 |
1720682 | 1720682 | 2021-09-15 | Howard | Missouri | 29089 | 1299 | 11 |
1717434 | 1717434 | 2021-09-14 | Howard | Missouri | 29089 | 1297 | 11 |
1714186 | 1714186 | 2021-09-13 | Howard | Missouri | 29089 | 1293 | 11 |
1710940 | 1710940 | 2021-09-12 | Howard | Missouri | 29089 | 1292 | 11 |
1707693 | 1707693 | 2021-09-11 | Howard | Missouri | 29089 | 1289 | 11 |
1704446 | 1704446 | 2021-09-10 | Howard | Missouri | 29089 | 1286 | 11 |
1701196 | 1701196 | 2021-09-09 | Howard | Missouri | 29089 | 1282 | 11 |
1697947 | 1697947 | 2021-09-08 | Howard | Missouri | 29089 | 1279 | 11 |
1668681 | 1668681 | 2021-08-30 | Carter | Missouri | 29035 | 827 | 11 |
1665434 | 1665434 | 2021-08-29 | Carter | Missouri | 29035 | 827 | 11 |
1662186 | 1662186 | 2021-08-28 | Carter | Missouri | 29035 | 827 | 11 |
1658938 | 1658938 | 2021-08-27 | Carter | Missouri | 29035 | 821 | 11 |
1655689 | 1655689 | 2021-08-26 | Carter | Missouri | 29035 | 802 | 11 |
1652442 | 1652442 | 2021-08-25 | Carter | Missouri | 29035 | 778 | 11 |
1649194 | 1649194 | 2021-08-24 | Carter | Missouri | 29035 | 773 | 11 |
1645945 | 1645945 | 2021-08-23 | Carter | Missouri | 29035 | 764 | 11 |
1642696 | 1642696 | 2021-08-22 | Carter | Missouri | 29035 | 763 | 11 |
1639446 | 1639446 | 2021-08-21 | Carter | Missouri | 29035 | 759 | 11 |
1636196 | 1636196 | 2021-08-20 | Carter | Missouri | 29035 | 754 | 11 |
1632946 | 1632946 | 2021-08-19 | Carter | Missouri | 29035 | 723 | 11 |
1629699 | 1629699 | 2021-08-18 | Carter | Missouri | 29035 | 714 | 11 |
1626452 | 1626452 | 2021-08-17 | Carter | Missouri | 29035 | 708 | 11 |
1623205 | 1623205 | 2021-08-16 | Carter | Missouri | 29035 | 706 | 11 |
1619958 | 1619958 | 2021-08-15 | Carter | Missouri | 29035 | 701 | 11 |
1616710 | 1616710 | 2021-08-14 | Carter | Missouri | 29035 | 700 | 11 |
1613462 | 1613462 | 2021-08-13 | Carter | Missouri | 29035 | 687 | 11 |
1610213 | 1610213 | 2021-08-12 | Carter | Missouri | 29035 | 678 | 11 |
1606965 | 1606965 | 2021-08-11 | Carter | Missouri | 29035 | 673 | 11 |
1603716 | 1603716 | 2021-08-10 | Carter | Missouri | 29035 | 663 | 11 |
1600467 | 1600467 | 2021-08-09 | Carter | Missouri | 29035 | 661 | 11 |
1597219 | 1597219 | 2021-08-08 | Carter | Missouri | 29035 | 659 | 11 |
1593970 | 1593970 | 2021-08-07 | Carter | Missouri | 29035 | 658 | 11 |
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);