ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
429 rows where deaths = 50 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Dunklin 91
- Ray 25
- Lincoln 24
- Hickory 23
- Butler 22
- Callaway 21
- Platte 18
- Howell 15
- Warren 14
- Ripley 13
- Barry 10
- Vernon 10
- Audrain 9
- Marion 8
- Mississippi 8
- Andrew 7
- Barton 7
- Franklin 7
- Henry 7
- Madison 7
- New Madrid 7
- Pike 7
- Gasconade 6
- Johnson 6
- Moniteau 6
- Montgomery 6
- Pettis 5
- Clay 4
- Macon 4
- Pulaski 4
- …
state 1
- Missouri · 429 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305776 | 2305776 | 2022-03-14 | Barton | Missouri | 29011 | 2811 | 50 |
2302525 | 2302525 | 2022-03-13 | Barton | Missouri | 29011 | 2807 | 50 |
2299273 | 2299273 | 2022-03-12 | Barton | Missouri | 29011 | 2807 | 50 |
2296021 | 2296021 | 2022-03-11 | Barton | Missouri | 29011 | 2807 | 50 |
2292769 | 2292769 | 2022-03-10 | Barton | Missouri | 29011 | 2805 | 50 |
2289517 | 2289517 | 2022-03-09 | Barton | Missouri | 29011 | 2803 | 50 |
2286265 | 2286265 | 2022-03-08 | Barton | Missouri | 29011 | 2803 | 50 |
2283069 | 2283069 | 2022-03-07 | Macon | Missouri | 29121 | 3600 | 50 |
2283070 | 2283070 | 2022-03-07 | Madison | Missouri | 29123 | 3558 | 50 |
2279816 | 2279816 | 2022-03-06 | Macon | Missouri | 29121 | 3599 | 50 |
2279817 | 2279817 | 2022-03-06 | Madison | Missouri | 29123 | 3557 | 50 |
2276563 | 2276563 | 2022-03-05 | Macon | Missouri | 29121 | 3599 | 50 |
2276564 | 2276564 | 2022-03-05 | Madison | Missouri | 29123 | 3557 | 50 |
2273310 | 2273310 | 2022-03-04 | Macon | Missouri | 29121 | 3599 | 50 |
2273311 | 2273311 | 2022-03-04 | Madison | Missouri | 29123 | 3557 | 50 |
2270059 | 2270059 | 2022-03-03 | Madison | Missouri | 29123 | 3557 | 50 |
2266806 | 2266806 | 2022-03-02 | Madison | Missouri | 29123 | 3556 | 50 |
2263555 | 2263555 | 2022-03-01 | Madison | Missouri | 29123 | 3552 | 50 |
2243988 | 2243988 | 2022-02-23 | Andrew | Missouri | 29003 | 4672 | 50 |
2244029 | 2244029 | 2022-02-23 | Hickory | Missouri | 29085 | 1812 | 50 |
2240737 | 2240737 | 2022-02-22 | Andrew | Missouri | 29003 | 4669 | 50 |
2240778 | 2240778 | 2022-02-22 | Hickory | Missouri | 29085 | 1809 | 50 |
2237486 | 2237486 | 2022-02-21 | Andrew | Missouri | 29003 | 4658 | 50 |
2237527 | 2237527 | 2022-02-21 | Hickory | Missouri | 29085 | 1804 | 50 |
2234235 | 2234235 | 2022-02-20 | Andrew | Missouri | 29003 | 4658 | 50 |
2234276 | 2234276 | 2022-02-20 | Hickory | Missouri | 29085 | 1804 | 50 |
2230984 | 2230984 | 2022-02-19 | Andrew | Missouri | 29003 | 4658 | 50 |
2231025 | 2231025 | 2022-02-19 | Hickory | Missouri | 29085 | 1804 | 50 |
2227733 | 2227733 | 2022-02-18 | Andrew | Missouri | 29003 | 4658 | 50 |
2227774 | 2227774 | 2022-02-18 | Hickory | Missouri | 29085 | 1804 | 50 |
2224482 | 2224482 | 2022-02-17 | Andrew | Missouri | 29003 | 4656 | 50 |
2224523 | 2224523 | 2022-02-17 | Hickory | Missouri | 29085 | 1803 | 50 |
2221272 | 2221272 | 2022-02-16 | Hickory | Missouri | 29085 | 1801 | 50 |
2218021 | 2218021 | 2022-02-15 | Hickory | Missouri | 29085 | 1796 | 50 |
2214770 | 2214770 | 2022-02-14 | Hickory | Missouri | 29085 | 1794 | 50 |
2211518 | 2211518 | 2022-02-13 | Hickory | Missouri | 29085 | 1781 | 50 |
2211545 | 2211545 | 2022-02-13 | Moniteau | Missouri | 29135 | 3763 | 50 |
2208265 | 2208265 | 2022-02-12 | Hickory | Missouri | 29085 | 1781 | 50 |
2208292 | 2208292 | 2022-02-12 | Moniteau | Missouri | 29135 | 3763 | 50 |
2205012 | 2205012 | 2022-02-11 | Hickory | Missouri | 29085 | 1781 | 50 |
2205039 | 2205039 | 2022-02-11 | Moniteau | Missouri | 29135 | 3763 | 50 |
2201759 | 2201759 | 2022-02-10 | Hickory | Missouri | 29085 | 1781 | 50 |
2201786 | 2201786 | 2022-02-10 | Moniteau | Missouri | 29135 | 3763 | 50 |
2198505 | 2198505 | 2022-02-09 | Hickory | Missouri | 29085 | 1774 | 50 |
2198532 | 2198532 | 2022-02-09 | Moniteau | Missouri | 29135 | 3755 | 50 |
2195251 | 2195251 | 2022-02-08 | Hickory | Missouri | 29085 | 1765 | 50 |
2195278 | 2195278 | 2022-02-08 | Moniteau | Missouri | 29135 | 3732 | 50 |
2191997 | 2191997 | 2022-02-07 | Hickory | Missouri | 29085 | 1756 | 50 |
2192026 | 2192026 | 2022-02-07 | Montgomery | Missouri | 29139 | 2327 | 50 |
2188744 | 2188744 | 2022-02-06 | Hickory | Missouri | 29085 | 1753 | 50 |
2188773 | 2188773 | 2022-02-06 | Montgomery | Missouri | 29139 | 2324 | 50 |
2185491 | 2185491 | 2022-02-05 | Hickory | Missouri | 29085 | 1753 | 50 |
2185520 | 2185520 | 2022-02-05 | Montgomery | Missouri | 29139 | 2323 | 50 |
2182239 | 2182239 | 2022-02-04 | Hickory | Missouri | 29085 | 1738 | 50 |
2182268 | 2182268 | 2022-02-04 | Montgomery | Missouri | 29139 | 2309 | 50 |
2178987 | 2178987 | 2022-02-03 | Hickory | Missouri | 29085 | 1736 | 50 |
2179016 | 2179016 | 2022-02-03 | Montgomery | Missouri | 29139 | 2305 | 50 |
2175735 | 2175735 | 2022-02-02 | Hickory | Missouri | 29085 | 1729 | 50 |
2175764 | 2175764 | 2022-02-02 | Montgomery | Missouri | 29139 | 2294 | 50 |
2172482 | 2172482 | 2022-02-01 | Hickory | Missouri | 29085 | 1722 | 50 |
2100942 | 2100942 | 2022-01-10 | Mississippi | Missouri | 29133 | 2624 | 50 |
2097691 | 2097691 | 2022-01-09 | Mississippi | Missouri | 29133 | 2609 | 50 |
2094439 | 2094439 | 2022-01-08 | Mississippi | Missouri | 29133 | 2609 | 50 |
2091187 | 2091187 | 2022-01-07 | Mississippi | Missouri | 29133 | 2593 | 50 |
2087936 | 2087936 | 2022-01-06 | Mississippi | Missouri | 29133 | 2588 | 50 |
2084684 | 2084684 | 2022-01-05 | Mississippi | Missouri | 29133 | 2572 | 50 |
2081432 | 2081432 | 2022-01-04 | Mississippi | Missouri | 29133 | 2566 | 50 |
2058677 | 2058677 | 2021-12-28 | Mississippi | Missouri | 29133 | 2511 | 50 |
2039203 | 2039203 | 2021-12-22 | Ripley | Missouri | 29181 | 2139 | 50 |
2035953 | 2035953 | 2021-12-21 | Ripley | Missouri | 29181 | 2127 | 50 |
2032703 | 2032703 | 2021-12-20 | Ripley | Missouri | 29181 | 2123 | 50 |
2029452 | 2029452 | 2021-12-19 | Ripley | Missouri | 29181 | 2122 | 50 |
2026201 | 2026201 | 2021-12-18 | Ripley | Missouri | 29181 | 2121 | 50 |
2022950 | 2022950 | 2021-12-17 | Ripley | Missouri | 29181 | 2116 | 50 |
2019699 | 2019699 | 2021-12-16 | Ripley | Missouri | 29181 | 2116 | 50 |
1990442 | 1990442 | 2021-12-07 | Ripley | Missouri | 29181 | 2080 | 50 |
1987192 | 1987192 | 2021-12-06 | Ripley | Missouri | 29181 | 2076 | 50 |
1983942 | 1983942 | 2021-12-05 | Ripley | Missouri | 29181 | 2074 | 50 |
1980692 | 1980692 | 2021-12-04 | Ripley | Missouri | 29181 | 2074 | 50 |
1977442 | 1977442 | 2021-12-03 | Ripley | Missouri | 29181 | 2063 | 50 |
1974192 | 1974192 | 2021-12-02 | Ripley | Missouri | 29181 | 2063 | 50 |
1964432 | 1964432 | 2021-11-29 | Pike | Missouri | 29163 | 2815 | 50 |
1961181 | 1961181 | 2021-11-28 | Pike | Missouri | 29163 | 2784 | 50 |
1957930 | 1957930 | 2021-11-27 | Pike | Missouri | 29163 | 2784 | 50 |
1954679 | 1954679 | 2021-11-26 | Pike | Missouri | 29163 | 2784 | 50 |
1951428 | 1951428 | 2021-11-25 | Pike | Missouri | 29163 | 2784 | 50 |
1948177 | 1948177 | 2021-11-24 | Pike | Missouri | 29163 | 2784 | 50 |
1944926 | 1944926 | 2021-11-23 | Pike | Missouri | 29163 | 2766 | 50 |
1925380 | 1925380 | 2021-11-17 | Grundy | Missouri | 29079 | 1609 | 50 |
1925434 | 1925434 | 2021-11-17 | Saline | Missouri | 29195 | 4166 | 50 |
1922131 | 1922131 | 2021-11-16 | Grundy | Missouri | 29079 | 1609 | 50 |
1922185 | 1922185 | 2021-11-16 | Saline | Missouri | 29195 | 4159 | 50 |
1918953 | 1918953 | 2021-11-15 | Warren | Missouri | 29219 | 5171 | 50 |
1915703 | 1915703 | 2021-11-14 | Warren | Missouri | 29219 | 5165 | 50 |
1912453 | 1912453 | 2021-11-13 | Warren | Missouri | 29219 | 5158 | 50 |
1909203 | 1909203 | 2021-11-12 | Warren | Missouri | 29219 | 5151 | 50 |
1905954 | 1905954 | 2021-11-11 | Warren | Missouri | 29219 | 5123 | 50 |
1902705 | 1902705 | 2021-11-10 | Warren | Missouri | 29219 | 5123 | 50 |
1899455 | 1899455 | 2021-11-09 | Warren | Missouri | 29219 | 5101 | 50 |
1896184 | 1896184 | 2021-11-08 | Ray | Missouri | 29177 | 3016 | 50 |
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);