ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
742 rows where deaths = 31 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Dade 137
- Gentry 60
- Lewis 51
- Moniteau 43
- Randolph 42
- DeKalb 35
- Warren 35
- Cooper 34
- McDonald 31
- Nodaway 28
- Pike 28
- St. Clair 16
- Oregon 14
- Adair 13
- Bollinger 10
- Morgan 10
- Cedar 9
- Mississippi 8
- Texas 8
- Bates 7
- Caldwell 7
- Chariton 7
- Dallas 7
- Douglas 7
- Gasconade 7
- Iron 7
- New Madrid 7
- Taney 7
- Wright 7
- Vernon 6
- …
state 1
- Missouri · 742 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501113 | 2501113 | 2022-05-13 | Gentry | Missouri | 29075 | 2172 | 31 |
2497855 | 2497855 | 2022-05-12 | Gentry | Missouri | 29075 | 2168 | 31 |
2494597 | 2494597 | 2022-05-11 | Gentry | Missouri | 29075 | 2168 | 31 |
2491339 | 2491339 | 2022-05-10 | Gentry | Missouri | 29075 | 2168 | 31 |
2488081 | 2488081 | 2022-05-09 | Gentry | Missouri | 29075 | 2168 | 31 |
2484824 | 2484824 | 2022-05-08 | Gentry | Missouri | 29075 | 2168 | 31 |
2481566 | 2481566 | 2022-05-07 | Gentry | Missouri | 29075 | 2168 | 31 |
2478308 | 2478308 | 2022-05-06 | Gentry | Missouri | 29075 | 2168 | 31 |
2475050 | 2475050 | 2022-05-05 | Gentry | Missouri | 29075 | 2161 | 31 |
2471793 | 2471793 | 2022-05-04 | Gentry | Missouri | 29075 | 2158 | 31 |
2468537 | 2468537 | 2022-05-03 | Gentry | Missouri | 29075 | 2158 | 31 |
2465281 | 2465281 | 2022-05-02 | Gentry | Missouri | 29075 | 2158 | 31 |
2462026 | 2462026 | 2022-05-01 | Gentry | Missouri | 29075 | 2158 | 31 |
2458770 | 2458770 | 2022-04-30 | Gentry | Missouri | 29075 | 2158 | 31 |
2455514 | 2455514 | 2022-04-29 | Gentry | Missouri | 29075 | 2158 | 31 |
2452258 | 2452258 | 2022-04-28 | Gentry | Missouri | 29075 | 2158 | 31 |
2449002 | 2449002 | 2022-04-27 | Gentry | Missouri | 29075 | 2158 | 31 |
2445745 | 2445745 | 2022-04-26 | Gentry | Missouri | 29075 | 2158 | 31 |
2442490 | 2442490 | 2022-04-25 | Gentry | Missouri | 29075 | 2158 | 31 |
2439234 | 2439234 | 2022-04-24 | Gentry | Missouri | 29075 | 2158 | 31 |
2435978 | 2435978 | 2022-04-23 | Gentry | Missouri | 29075 | 2158 | 31 |
2432722 | 2432722 | 2022-04-22 | Gentry | Missouri | 29075 | 2158 | 31 |
2429466 | 2429466 | 2022-04-21 | Gentry | Missouri | 29075 | 2158 | 31 |
2426210 | 2426210 | 2022-04-20 | Gentry | Missouri | 29075 | 2158 | 31 |
2422954 | 2422954 | 2022-04-19 | Gentry | Missouri | 29075 | 2158 | 31 |
2419697 | 2419697 | 2022-04-18 | Gentry | Missouri | 29075 | 2158 | 31 |
2416442 | 2416442 | 2022-04-17 | Gentry | Missouri | 29075 | 2158 | 31 |
2413186 | 2413186 | 2022-04-16 | Gentry | Missouri | 29075 | 2158 | 31 |
2409930 | 2409930 | 2022-04-15 | Gentry | Missouri | 29075 | 2158 | 31 |
2406674 | 2406674 | 2022-04-14 | Gentry | Missouri | 29075 | 2158 | 31 |
2403418 | 2403418 | 2022-04-13 | Gentry | Missouri | 29075 | 2158 | 31 |
2400163 | 2400163 | 2022-04-12 | Gentry | Missouri | 29075 | 2158 | 31 |
2396908 | 2396908 | 2022-04-11 | Gentry | Missouri | 29075 | 2158 | 31 |
2393653 | 2393653 | 2022-04-10 | Gentry | Missouri | 29075 | 2158 | 31 |
2390397 | 2390397 | 2022-04-09 | Gentry | Missouri | 29075 | 2158 | 31 |
2387141 | 2387141 | 2022-04-08 | Gentry | Missouri | 29075 | 2158 | 31 |
2383886 | 2383886 | 2022-04-07 | Gentry | Missouri | 29075 | 2158 | 31 |
2380631 | 2380631 | 2022-04-06 | Gentry | Missouri | 29075 | 2158 | 31 |
2377376 | 2377376 | 2022-04-05 | Gentry | Missouri | 29075 | 2158 | 31 |
2374123 | 2374123 | 2022-04-04 | Gentry | Missouri | 29075 | 2158 | 31 |
2370871 | 2370871 | 2022-04-03 | Gentry | Missouri | 29075 | 2158 | 31 |
2367618 | 2367618 | 2022-04-02 | Gentry | Missouri | 29075 | 2158 | 31 |
2364365 | 2364365 | 2022-04-01 | Gentry | Missouri | 29075 | 2158 | 31 |
2361111 | 2361111 | 2022-03-31 | Gentry | Missouri | 29075 | 2158 | 31 |
2357857 | 2357857 | 2022-03-30 | Gentry | Missouri | 29075 | 2157 | 31 |
2354604 | 2354604 | 2022-03-29 | Gentry | Missouri | 29075 | 2157 | 31 |
2351351 | 2351351 | 2022-03-28 | Gentry | Missouri | 29075 | 2157 | 31 |
2348099 | 2348099 | 2022-03-27 | Gentry | Missouri | 29075 | 2155 | 31 |
2344846 | 2344846 | 2022-03-26 | Gentry | Missouri | 29075 | 2155 | 31 |
2341593 | 2341593 | 2022-03-25 | Gentry | Missouri | 29075 | 2155 | 31 |
2338340 | 2338340 | 2022-03-24 | Gentry | Missouri | 29075 | 2155 | 31 |
2335086 | 2335086 | 2022-03-23 | Gentry | Missouri | 29075 | 2155 | 31 |
2331832 | 2331832 | 2022-03-22 | Gentry | Missouri | 29075 | 2155 | 31 |
2328579 | 2328579 | 2022-03-21 | Gentry | Missouri | 29075 | 2156 | 31 |
2325327 | 2325327 | 2022-03-20 | Gentry | Missouri | 29075 | 2153 | 31 |
2322073 | 2322073 | 2022-03-19 | Gentry | Missouri | 29075 | 2153 | 31 |
2318819 | 2318819 | 2022-03-18 | Gentry | Missouri | 29075 | 2153 | 31 |
2315566 | 2315566 | 2022-03-17 | Gentry | Missouri | 29075 | 2152 | 31 |
2312313 | 2312313 | 2022-03-16 | Gentry | Missouri | 29075 | 2152 | 31 |
2309060 | 2309060 | 2022-03-15 | Gentry | Missouri | 29075 | 2147 | 31 |
2260318 | 2260318 | 2022-02-28 | Oregon | Missouri | 29149 | 2009 | 31 |
2257067 | 2257067 | 2022-02-27 | Oregon | Missouri | 29149 | 2006 | 31 |
2253816 | 2253816 | 2022-02-26 | Oregon | Missouri | 29149 | 2006 | 31 |
2250565 | 2250565 | 2022-02-25 | Oregon | Missouri | 29149 | 2006 | 31 |
2247314 | 2247314 | 2022-02-24 | Oregon | Missouri | 29149 | 2005 | 31 |
2244044 | 2244044 | 2022-02-23 | Lewis | Missouri | 29111 | 2658 | 31 |
2244063 | 2244063 | 2022-02-23 | Oregon | Missouri | 29149 | 2002 | 31 |
2244087 | 2244087 | 2022-02-23 | St. Clair | Missouri | 29185 | 2084 | 31 |
2240793 | 2240793 | 2022-02-22 | Lewis | Missouri | 29111 | 2655 | 31 |
2240812 | 2240812 | 2022-02-22 | Oregon | Missouri | 29149 | 2002 | 31 |
2240836 | 2240836 | 2022-02-22 | St. Clair | Missouri | 29185 | 2082 | 31 |
2237542 | 2237542 | 2022-02-21 | Lewis | Missouri | 29111 | 2653 | 31 |
2237561 | 2237561 | 2022-02-21 | Oregon | Missouri | 29149 | 1995 | 31 |
2237585 | 2237585 | 2022-02-21 | St. Clair | Missouri | 29185 | 2078 | 31 |
2234291 | 2234291 | 2022-02-20 | Lewis | Missouri | 29111 | 2653 | 31 |
2234310 | 2234310 | 2022-02-20 | Oregon | Missouri | 29149 | 1995 | 31 |
2234334 | 2234334 | 2022-02-20 | St. Clair | Missouri | 29185 | 2078 | 31 |
2231040 | 2231040 | 2022-02-19 | Lewis | Missouri | 29111 | 2653 | 31 |
2231059 | 2231059 | 2022-02-19 | Oregon | Missouri | 29149 | 1995 | 31 |
2231083 | 2231083 | 2022-02-19 | St. Clair | Missouri | 29185 | 2078 | 31 |
2227789 | 2227789 | 2022-02-18 | Lewis | Missouri | 29111 | 2653 | 31 |
2227808 | 2227808 | 2022-02-18 | Oregon | Missouri | 29149 | 1995 | 31 |
2227832 | 2227832 | 2022-02-18 | St. Clair | Missouri | 29185 | 2078 | 31 |
2224538 | 2224538 | 2022-02-17 | Lewis | Missouri | 29111 | 2650 | 31 |
2224557 | 2224557 | 2022-02-17 | Oregon | Missouri | 29149 | 1993 | 31 |
2224581 | 2224581 | 2022-02-17 | St. Clair | Missouri | 29185 | 2078 | 31 |
2221287 | 2221287 | 2022-02-16 | Lewis | Missouri | 29111 | 2639 | 31 |
2221293 | 2221293 | 2022-02-16 | Maries | Missouri | 29125 | 1563 | 31 |
2221306 | 2221306 | 2022-02-16 | Oregon | Missouri | 29149 | 1991 | 31 |
2221330 | 2221330 | 2022-02-16 | St. Clair | Missouri | 29185 | 2072 | 31 |
2218036 | 2218036 | 2022-02-15 | Lewis | Missouri | 29111 | 2635 | 31 |
2218042 | 2218042 | 2022-02-15 | Maries | Missouri | 29125 | 1557 | 31 |
2218055 | 2218055 | 2022-02-15 | Oregon | Missouri | 29149 | 1987 | 31 |
2218079 | 2218079 | 2022-02-15 | St. Clair | Missouri | 29185 | 2070 | 31 |
2214740 | 2214740 | 2022-02-14 | Caldwell | Missouri | 29025 | 1623 | 31 |
2214785 | 2214785 | 2022-02-14 | Lewis | Missouri | 29111 | 2632 | 31 |
2214828 | 2214828 | 2022-02-14 | St. Clair | Missouri | 29185 | 2066 | 31 |
2211488 | 2211488 | 2022-02-13 | Caldwell | Missouri | 29025 | 1610 | 31 |
2211533 | 2211533 | 2022-02-13 | Lewis | Missouri | 29111 | 2612 | 31 |
2211576 | 2211576 | 2022-02-13 | St. Clair | Missouri | 29185 | 2056 | 31 |
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);