ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
443 rows where deaths = 48 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Ozark 49
- New Madrid 39
- Gasconade 29
- Butler 21
- Livingston 21
- Washington 21
- Polk 20
- Cedar 19
- Saline 18
- Lafayette 15
- Miller 15
- Barton 14
- Grundy 14
- Johnson 14
- Moniteau 12
- Ripley 12
- Platte 10
- Macon 9
- Barry 8
- Vernon 8
- Adair 7
- Clinton 7
- Henry 7
- Stoddard 7
- Webster 7
- Ray 6
- Jefferson 5
- Montgomery 5
- Cass 4
- Howell 4
- …
state 1
- Missouri · 443 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305790 | 2305790 | 2022-03-14 | Cedar | Missouri | 29039 | 2907 | 48 |
2302539 | 2302539 | 2022-03-13 | Cedar | Missouri | 29039 | 2906 | 48 |
2299287 | 2299287 | 2022-03-12 | Cedar | Missouri | 29039 | 2906 | 48 |
2296035 | 2296035 | 2022-03-11 | Cedar | Missouri | 29039 | 2906 | 48 |
2292783 | 2292783 | 2022-03-10 | Cedar | Missouri | 29039 | 2905 | 48 |
2289531 | 2289531 | 2022-03-09 | Cedar | Missouri | 29039 | 2904 | 48 |
2286279 | 2286279 | 2022-03-08 | Cedar | Missouri | 29039 | 2904 | 48 |
2283027 | 2283027 | 2022-03-07 | Cedar | Missouri | 29039 | 2903 | 48 |
2279774 | 2279774 | 2022-03-06 | Cedar | Missouri | 29039 | 2902 | 48 |
2276521 | 2276521 | 2022-03-05 | Cedar | Missouri | 29039 | 2902 | 48 |
2273268 | 2273268 | 2022-03-04 | Cedar | Missouri | 29039 | 2902 | 48 |
2270016 | 2270016 | 2022-03-03 | Cedar | Missouri | 29039 | 2902 | 48 |
2266763 | 2266763 | 2022-03-02 | Cedar | Missouri | 29039 | 2900 | 48 |
2263512 | 2263512 | 2022-03-01 | Cedar | Missouri | 29039 | 2900 | 48 |
2260247 | 2260247 | 2022-02-28 | Barton | Missouri | 29011 | 2799 | 48 |
2260261 | 2260261 | 2022-02-28 | Cedar | Missouri | 29039 | 2898 | 48 |
2256996 | 2256996 | 2022-02-27 | Barton | Missouri | 29011 | 2795 | 48 |
2257010 | 2257010 | 2022-02-27 | Cedar | Missouri | 29039 | 2896 | 48 |
2253745 | 2253745 | 2022-02-26 | Barton | Missouri | 29011 | 2795 | 48 |
2253759 | 2253759 | 2022-02-26 | Cedar | Missouri | 29039 | 2896 | 48 |
2250494 | 2250494 | 2022-02-25 | Barton | Missouri | 29011 | 2795 | 48 |
2250508 | 2250508 | 2022-02-25 | Cedar | Missouri | 29039 | 2896 | 48 |
2247243 | 2247243 | 2022-02-24 | Barton | Missouri | 29011 | 2788 | 48 |
2247257 | 2247257 | 2022-02-24 | Cedar | Missouri | 29039 | 2895 | 48 |
2243992 | 2243992 | 2022-02-23 | Barton | Missouri | 29011 | 2787 | 48 |
2244048 | 2244048 | 2022-02-23 | Macon | Missouri | 29121 | 3589 | 48 |
2244065 | 2244065 | 2022-02-23 | Ozark | Missouri | 29153 | 1675 | 48 |
2240741 | 2240741 | 2022-02-22 | Barton | Missouri | 29011 | 2784 | 48 |
2240797 | 2240797 | 2022-02-22 | Macon | Missouri | 29121 | 3588 | 48 |
2240814 | 2240814 | 2022-02-22 | Ozark | Missouri | 29153 | 1671 | 48 |
2237490 | 2237490 | 2022-02-21 | Barton | Missouri | 29011 | 2774 | 48 |
2237546 | 2237546 | 2022-02-21 | Macon | Missouri | 29121 | 3575 | 48 |
2237563 | 2237563 | 2022-02-21 | Ozark | Missouri | 29153 | 1664 | 48 |
2234239 | 2234239 | 2022-02-20 | Barton | Missouri | 29011 | 2774 | 48 |
2234295 | 2234295 | 2022-02-20 | Macon | Missouri | 29121 | 3575 | 48 |
2234312 | 2234312 | 2022-02-20 | Ozark | Missouri | 29153 | 1664 | 48 |
2230988 | 2230988 | 2022-02-19 | Barton | Missouri | 29011 | 2774 | 48 |
2231044 | 2231044 | 2022-02-19 | Macon | Missouri | 29121 | 3575 | 48 |
2231061 | 2231061 | 2022-02-19 | Ozark | Missouri | 29153 | 1664 | 48 |
2227737 | 2227737 | 2022-02-18 | Barton | Missouri | 29011 | 2774 | 48 |
2227793 | 2227793 | 2022-02-18 | Macon | Missouri | 29121 | 3575 | 48 |
2227810 | 2227810 | 2022-02-18 | Ozark | Missouri | 29153 | 1664 | 48 |
2224486 | 2224486 | 2022-02-17 | Barton | Missouri | 29011 | 2774 | 48 |
2224542 | 2224542 | 2022-02-17 | Macon | Missouri | 29121 | 3573 | 48 |
2224559 | 2224559 | 2022-02-17 | Ozark | Missouri | 29153 | 1663 | 48 |
2221235 | 2221235 | 2022-02-16 | Barton | Missouri | 29011 | 2762 | 48 |
2221291 | 2221291 | 2022-02-16 | Macon | Missouri | 29121 | 3570 | 48 |
2221308 | 2221308 | 2022-02-16 | Ozark | Missouri | 29153 | 1652 | 48 |
2217984 | 2217984 | 2022-02-15 | Barton | Missouri | 29011 | 2748 | 48 |
2218040 | 2218040 | 2022-02-15 | Macon | Missouri | 29121 | 3563 | 48 |
2218057 | 2218057 | 2022-02-15 | Ozark | Missouri | 29153 | 1649 | 48 |
2214806 | 2214806 | 2022-02-14 | Ozark | Missouri | 29153 | 1648 | 48 |
2211554 | 2211554 | 2022-02-13 | Ozark | Missouri | 29153 | 1643 | 48 |
2208301 | 2208301 | 2022-02-12 | Ozark | Missouri | 29153 | 1643 | 48 |
2205048 | 2205048 | 2022-02-11 | Ozark | Missouri | 29153 | 1643 | 48 |
2201795 | 2201795 | 2022-02-10 | Ozark | Missouri | 29153 | 1643 | 48 |
2198541 | 2198541 | 2022-02-09 | Ozark | Missouri | 29153 | 1637 | 48 |
2195287 | 2195287 | 2022-02-08 | Ozark | Missouri | 29153 | 1635 | 48 |
2192033 | 2192033 | 2022-02-07 | Ozark | Missouri | 29153 | 1631 | 48 |
2188780 | 2188780 | 2022-02-06 | Ozark | Missouri | 29153 | 1628 | 48 |
2185527 | 2185527 | 2022-02-05 | Ozark | Missouri | 29153 | 1626 | 48 |
2182275 | 2182275 | 2022-02-04 | Ozark | Missouri | 29153 | 1625 | 48 |
2179023 | 2179023 | 2022-02-03 | Ozark | Missouri | 29153 | 1617 | 48 |
2175771 | 2175771 | 2022-02-02 | Ozark | Missouri | 29153 | 1612 | 48 |
2172518 | 2172518 | 2022-02-01 | Ozark | Missouri | 29153 | 1593 | 48 |
2169256 | 2169256 | 2022-01-31 | Moniteau | Missouri | 29135 | 3660 | 48 |
2169265 | 2169265 | 2022-01-31 | Ozark | Missouri | 29153 | 1586 | 48 |
2166001 | 2166001 | 2022-01-30 | Moniteau | Missouri | 29135 | 3656 | 48 |
2166003 | 2166003 | 2022-01-30 | Montgomery | Missouri | 29139 | 2252 | 48 |
2166010 | 2166010 | 2022-01-30 | Ozark | Missouri | 29153 | 1586 | 48 |
2162746 | 2162746 | 2022-01-29 | Moniteau | Missouri | 29135 | 3652 | 48 |
2162748 | 2162748 | 2022-01-29 | Montgomery | Missouri | 29139 | 2246 | 48 |
2162755 | 2162755 | 2022-01-29 | Ozark | Missouri | 29153 | 1581 | 48 |
2159491 | 2159491 | 2022-01-28 | Moniteau | Missouri | 29135 | 3625 | 48 |
2159493 | 2159493 | 2022-01-28 | Montgomery | Missouri | 29139 | 2229 | 48 |
2159500 | 2159500 | 2022-01-28 | Ozark | Missouri | 29153 | 1574 | 48 |
2156237 | 2156237 | 2022-01-27 | Moniteau | Missouri | 29135 | 3609 | 48 |
2156239 | 2156239 | 2022-01-27 | Montgomery | Missouri | 29139 | 2215 | 48 |
2156246 | 2156246 | 2022-01-27 | Ozark | Missouri | 29153 | 1553 | 48 |
2152984 | 2152984 | 2022-01-26 | Moniteau | Missouri | 29135 | 3588 | 48 |
2152986 | 2152986 | 2022-01-26 | Montgomery | Missouri | 29139 | 2192 | 48 |
2152993 | 2152993 | 2022-01-26 | Ozark | Missouri | 29153 | 1542 | 48 |
2149732 | 2149732 | 2022-01-25 | Moniteau | Missouri | 29135 | 3551 | 48 |
2149741 | 2149741 | 2022-01-25 | Ozark | Missouri | 29153 | 1530 | 48 |
2146480 | 2146480 | 2022-01-24 | Moniteau | Missouri | 29135 | 3496 | 48 |
2146489 | 2146489 | 2022-01-24 | Ozark | Missouri | 29153 | 1521 | 48 |
2143225 | 2143225 | 2022-01-23 | Moniteau | Missouri | 29135 | 3493 | 48 |
2143234 | 2143234 | 2022-01-23 | Ozark | Missouri | 29153 | 1512 | 48 |
2139970 | 2139970 | 2022-01-22 | Moniteau | Missouri | 29135 | 3486 | 48 |
2139979 | 2139979 | 2022-01-22 | Ozark | Missouri | 29153 | 1509 | 48 |
2136714 | 2136714 | 2022-01-21 | Moniteau | Missouri | 29135 | 3461 | 48 |
2136723 | 2136723 | 2022-01-21 | Ozark | Missouri | 29153 | 1494 | 48 |
2133462 | 2133462 | 2022-01-20 | Moniteau | Missouri | 29135 | 3416 | 48 |
2133471 | 2133471 | 2022-01-20 | Ozark | Missouri | 29153 | 1491 | 48 |
2130218 | 2130218 | 2022-01-19 | Ozark | Missouri | 29153 | 1468 | 48 |
2126964 | 2126964 | 2022-01-18 | Ozark | Missouri | 29153 | 1448 | 48 |
2123712 | 2123712 | 2022-01-17 | Ozark | Missouri | 29153 | 1438 | 48 |
2120460 | 2120460 | 2022-01-16 | Ozark | Missouri | 29153 | 1438 | 48 |
2117208 | 2117208 | 2022-01-15 | Ozark | Missouri | 29153 | 1438 | 48 |
2113957 | 2113957 | 2022-01-14 | Ozark | Missouri | 29153 | 1423 | 48 |
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);