ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
722 rows where deaths = 42 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Cedar 54
- Monroe 51
- Morgan 41
- Howell 36
- Carroll 35
- Polk 35
- Livingston 33
- Marion 27
- Texas 25
- Dallas 24
- Barton 21
- Adair 17
- Andrew 17
- Dent 16
- Butler 15
- Douglas 15
- DeKalb 14
- Gasconade 14
- Miller 14
- Nodaway 14
- Ozark 14
- Stoddard 14
- Vernon 14
- Platte 13
- Benton 10
- Dade 9
- Washington 9
- Wayne 8
- Crawford 7
- Iron 7
- …
state 1
- Missouri · 722 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501104 | 2501104 | 2022-05-13 | Dade | Missouri | 29057 | 1447 | 42 |
2497846 | 2497846 | 2022-05-12 | Dade | Missouri | 29057 | 1447 | 42 |
2494588 | 2494588 | 2022-05-11 | Dade | Missouri | 29057 | 1447 | 42 |
2491330 | 2491330 | 2022-05-10 | Dade | Missouri | 29057 | 1447 | 42 |
2488072 | 2488072 | 2022-05-09 | Dade | Missouri | 29057 | 1447 | 42 |
2484815 | 2484815 | 2022-05-08 | Dade | Missouri | 29057 | 1447 | 42 |
2481557 | 2481557 | 2022-05-07 | Dade | Missouri | 29057 | 1447 | 42 |
2478299 | 2478299 | 2022-05-06 | Dade | Missouri | 29057 | 1447 | 42 |
2475041 | 2475041 | 2022-05-05 | Dade | Missouri | 29057 | 1443 | 42 |
2471826 | 2471826 | 2022-05-04 | Monroe | Missouri | 29137 | 2173 | 42 |
2468570 | 2468570 | 2022-05-03 | Monroe | Missouri | 29137 | 2173 | 42 |
2465314 | 2465314 | 2022-05-02 | Monroe | Missouri | 29137 | 2173 | 42 |
2462059 | 2462059 | 2022-05-01 | Monroe | Missouri | 29137 | 2173 | 42 |
2458803 | 2458803 | 2022-04-30 | Monroe | Missouri | 29137 | 2173 | 42 |
2455547 | 2455547 | 2022-04-29 | Monroe | Missouri | 29137 | 2173 | 42 |
2452291 | 2452291 | 2022-04-28 | Monroe | Missouri | 29137 | 2173 | 42 |
2449035 | 2449035 | 2022-04-27 | Monroe | Missouri | 29137 | 2173 | 42 |
2445778 | 2445778 | 2022-04-26 | Monroe | Missouri | 29137 | 2173 | 42 |
2442523 | 2442523 | 2022-04-25 | Monroe | Missouri | 29137 | 2173 | 42 |
2439267 | 2439267 | 2022-04-24 | Monroe | Missouri | 29137 | 2173 | 42 |
2436011 | 2436011 | 2022-04-23 | Monroe | Missouri | 29137 | 2173 | 42 |
2432755 | 2432755 | 2022-04-22 | Monroe | Missouri | 29137 | 2173 | 42 |
2429499 | 2429499 | 2022-04-21 | Monroe | Missouri | 29137 | 2173 | 42 |
2426243 | 2426243 | 2022-04-20 | Monroe | Missouri | 29137 | 2173 | 42 |
2422987 | 2422987 | 2022-04-19 | Monroe | Missouri | 29137 | 2173 | 42 |
2419730 | 2419730 | 2022-04-18 | Monroe | Missouri | 29137 | 2173 | 42 |
2416475 | 2416475 | 2022-04-17 | Monroe | Missouri | 29137 | 2173 | 42 |
2413219 | 2413219 | 2022-04-16 | Monroe | Missouri | 29137 | 2173 | 42 |
2409963 | 2409963 | 2022-04-15 | Monroe | Missouri | 29137 | 2173 | 42 |
2406707 | 2406707 | 2022-04-14 | Monroe | Missouri | 29137 | 2173 | 42 |
2403451 | 2403451 | 2022-04-13 | Monroe | Missouri | 29137 | 2173 | 42 |
2400196 | 2400196 | 2022-04-12 | Monroe | Missouri | 29137 | 2173 | 42 |
2396941 | 2396941 | 2022-04-11 | Monroe | Missouri | 29137 | 2173 | 42 |
2393686 | 2393686 | 2022-04-10 | Monroe | Missouri | 29137 | 2173 | 42 |
2390430 | 2390430 | 2022-04-09 | Monroe | Missouri | 29137 | 2173 | 42 |
2387174 | 2387174 | 2022-04-08 | Monroe | Missouri | 29137 | 2173 | 42 |
2383919 | 2383919 | 2022-04-07 | Monroe | Missouri | 29137 | 2173 | 42 |
2380664 | 2380664 | 2022-04-06 | Monroe | Missouri | 29137 | 2173 | 42 |
2377409 | 2377409 | 2022-04-05 | Monroe | Missouri | 29137 | 2173 | 42 |
2374156 | 2374156 | 2022-04-04 | Monroe | Missouri | 29137 | 2173 | 42 |
2370904 | 2370904 | 2022-04-03 | Monroe | Missouri | 29137 | 2173 | 42 |
2367651 | 2367651 | 2022-04-02 | Monroe | Missouri | 29137 | 2173 | 42 |
2364398 | 2364398 | 2022-04-01 | Monroe | Missouri | 29137 | 2173 | 42 |
2361144 | 2361144 | 2022-03-31 | Monroe | Missouri | 29137 | 2173 | 42 |
2357890 | 2357890 | 2022-03-30 | Monroe | Missouri | 29137 | 2171 | 42 |
2354637 | 2354637 | 2022-03-29 | Monroe | Missouri | 29137 | 2170 | 42 |
2351384 | 2351384 | 2022-03-28 | Monroe | Missouri | 29137 | 2170 | 42 |
2348132 | 2348132 | 2022-03-27 | Monroe | Missouri | 29137 | 2170 | 42 |
2344879 | 2344879 | 2022-03-26 | Monroe | Missouri | 29137 | 2170 | 42 |
2341626 | 2341626 | 2022-03-25 | Monroe | Missouri | 29137 | 2170 | 42 |
2338373 | 2338373 | 2022-03-24 | Monroe | Missouri | 29137 | 2169 | 42 |
2335119 | 2335119 | 2022-03-23 | Monroe | Missouri | 29137 | 2167 | 42 |
2331865 | 2331865 | 2022-03-22 | Monroe | Missouri | 29137 | 2166 | 42 |
2328588 | 2328588 | 2022-03-21 | Iron | Missouri | 29093 | 2187 | 42 |
2328612 | 2328612 | 2022-03-21 | Monroe | Missouri | 29137 | 2165 | 42 |
2325336 | 2325336 | 2022-03-20 | Iron | Missouri | 29093 | 2183 | 42 |
2325360 | 2325360 | 2022-03-20 | Monroe | Missouri | 29137 | 2165 | 42 |
2322082 | 2322082 | 2022-03-19 | Iron | Missouri | 29093 | 2183 | 42 |
2322106 | 2322106 | 2022-03-19 | Monroe | Missouri | 29137 | 2165 | 42 |
2318828 | 2318828 | 2022-03-18 | Iron | Missouri | 29093 | 2183 | 42 |
2318852 | 2318852 | 2022-03-18 | Monroe | Missouri | 29137 | 2165 | 42 |
2315575 | 2315575 | 2022-03-17 | Iron | Missouri | 29093 | 2182 | 42 |
2315599 | 2315599 | 2022-03-17 | Monroe | Missouri | 29137 | 2165 | 42 |
2312322 | 2312322 | 2022-03-16 | Iron | Missouri | 29093 | 2182 | 42 |
2312346 | 2312346 | 2022-03-16 | Monroe | Missouri | 29137 | 2165 | 42 |
2309069 | 2309069 | 2022-03-15 | Iron | Missouri | 29093 | 2179 | 42 |
2309093 | 2309093 | 2022-03-15 | Monroe | Missouri | 29137 | 2165 | 42 |
2305848 | 2305848 | 2022-03-14 | Osage | Missouri | 29151 | 3203 | 42 |
2302597 | 2302597 | 2022-03-13 | Osage | Missouri | 29151 | 3203 | 42 |
2299345 | 2299345 | 2022-03-12 | Osage | Missouri | 29151 | 3203 | 42 |
2296093 | 2296093 | 2022-03-11 | Osage | Missouri | 29151 | 3203 | 42 |
2292841 | 2292841 | 2022-03-10 | Osage | Missouri | 29151 | 3202 | 42 |
2289589 | 2289589 | 2022-03-09 | Osage | Missouri | 29151 | 3201 | 42 |
2286337 | 2286337 | 2022-03-08 | Osage | Missouri | 29151 | 3200 | 42 |
2283024 | 2283024 | 2022-03-07 | Carroll | Missouri | 29033 | 2219 | 42 |
2279771 | 2279771 | 2022-03-06 | Carroll | Missouri | 29033 | 2219 | 42 |
2276518 | 2276518 | 2022-03-05 | Carroll | Missouri | 29033 | 2219 | 42 |
2273265 | 2273265 | 2022-03-04 | Carroll | Missouri | 29033 | 2219 | 42 |
2270013 | 2270013 | 2022-03-03 | Carroll | Missouri | 29033 | 2219 | 42 |
2266760 | 2266760 | 2022-03-02 | Carroll | Missouri | 29033 | 2219 | 42 |
2263509 | 2263509 | 2022-03-01 | Carroll | Missouri | 29033 | 2219 | 42 |
2260258 | 2260258 | 2022-02-28 | Carroll | Missouri | 29033 | 2215 | 42 |
2260317 | 2260317 | 2022-02-28 | Nodaway | Missouri | 29147 | 5972 | 42 |
2257007 | 2257007 | 2022-02-27 | Carroll | Missouri | 29033 | 2212 | 42 |
2257066 | 2257066 | 2022-02-27 | Nodaway | Missouri | 29147 | 5965 | 42 |
2253756 | 2253756 | 2022-02-26 | Carroll | Missouri | 29033 | 2212 | 42 |
2253815 | 2253815 | 2022-02-26 | Nodaway | Missouri | 29147 | 5965 | 42 |
2250505 | 2250505 | 2022-02-25 | Carroll | Missouri | 29033 | 2212 | 42 |
2250564 | 2250564 | 2022-02-25 | Nodaway | Missouri | 29147 | 5965 | 42 |
2247254 | 2247254 | 2022-02-24 | Carroll | Missouri | 29033 | 2209 | 42 |
2247313 | 2247313 | 2022-02-24 | Nodaway | Missouri | 29147 | 5959 | 42 |
2244003 | 2244003 | 2022-02-23 | Carroll | Missouri | 29033 | 2206 | 42 |
2244062 | 2244062 | 2022-02-23 | Nodaway | Missouri | 29147 | 5953 | 42 |
2240752 | 2240752 | 2022-02-22 | Carroll | Missouri | 29033 | 2203 | 42 |
2240811 | 2240811 | 2022-02-22 | Nodaway | Missouri | 29147 | 5948 | 42 |
2237501 | 2237501 | 2022-02-21 | Carroll | Missouri | 29033 | 2197 | 42 |
2237560 | 2237560 | 2022-02-21 | Nodaway | Missouri | 29147 | 5928 | 42 |
2234250 | 2234250 | 2022-02-20 | Carroll | Missouri | 29033 | 2197 | 42 |
2234309 | 2234309 | 2022-02-20 | Nodaway | Missouri | 29147 | 5928 | 42 |
2230999 | 2230999 | 2022-02-19 | Carroll | Missouri | 29033 | 2197 | 42 |
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);