ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
857 rows where deaths = 34 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Grundy 118
- Wright 54
- Montgomery 48
- Nodaway 43
- St. Clair 41
- Ste. Genevieve 37
- Benton 35
- Chariton 35
- Adair 34
- Macon 27
- Lewis 26
- Johnson 21
- Monroe 20
- Stoddard 19
- McDonald 18
- Cooper 16
- DeKalb 16
- Wayne 16
- Polk 15
- Randolph 15
- Crawford 14
- Bollinger 13
- Bates 10
- Clay 9
- Shannon 9
- Mississippi 8
- Morgan 8
- Butler 7
- Callaway 7
- Dallas 7
- …
state 1
- Missouri · 857 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471856 | 2471856 | 2022-05-04 | St. Clair | Missouri | 29185 | 2102 | 34 |
2468600 | 2468600 | 2022-05-03 | St. Clair | Missouri | 29185 | 2102 | 34 |
2465344 | 2465344 | 2022-05-02 | St. Clair | Missouri | 29185 | 2102 | 34 |
2462089 | 2462089 | 2022-05-01 | St. Clair | Missouri | 29185 | 2102 | 34 |
2458833 | 2458833 | 2022-04-30 | St. Clair | Missouri | 29185 | 2102 | 34 |
2455577 | 2455577 | 2022-04-29 | St. Clair | Missouri | 29185 | 2102 | 34 |
2452321 | 2452321 | 2022-04-28 | St. Clair | Missouri | 29185 | 2102 | 34 |
2449065 | 2449065 | 2022-04-27 | St. Clair | Missouri | 29185 | 2102 | 34 |
2445808 | 2445808 | 2022-04-26 | St. Clair | Missouri | 29185 | 2102 | 34 |
2442553 | 2442553 | 2022-04-25 | St. Clair | Missouri | 29185 | 2102 | 34 |
2439297 | 2439297 | 2022-04-24 | St. Clair | Missouri | 29185 | 2102 | 34 |
2436041 | 2436041 | 2022-04-23 | St. Clair | Missouri | 29185 | 2102 | 34 |
2432785 | 2432785 | 2022-04-22 | St. Clair | Missouri | 29185 | 2102 | 34 |
2429529 | 2429529 | 2022-04-21 | St. Clair | Missouri | 29185 | 2102 | 34 |
2426273 | 2426273 | 2022-04-20 | St. Clair | Missouri | 29185 | 2102 | 34 |
2423017 | 2423017 | 2022-04-19 | St. Clair | Missouri | 29185 | 2102 | 34 |
2419760 | 2419760 | 2022-04-18 | St. Clair | Missouri | 29185 | 2102 | 34 |
2416505 | 2416505 | 2022-04-17 | St. Clair | Missouri | 29185 | 2102 | 34 |
2413249 | 2413249 | 2022-04-16 | St. Clair | Missouri | 29185 | 2102 | 34 |
2409993 | 2409993 | 2022-04-15 | St. Clair | Missouri | 29185 | 2102 | 34 |
2406737 | 2406737 | 2022-04-14 | St. Clair | Missouri | 29185 | 2102 | 34 |
2403481 | 2403481 | 2022-04-13 | St. Clair | Missouri | 29185 | 2102 | 34 |
2400226 | 2400226 | 2022-04-12 | St. Clair | Missouri | 29185 | 2102 | 34 |
2396971 | 2396971 | 2022-04-11 | St. Clair | Missouri | 29185 | 2102 | 34 |
2393716 | 2393716 | 2022-04-10 | St. Clair | Missouri | 29185 | 2102 | 34 |
2390460 | 2390460 | 2022-04-09 | St. Clair | Missouri | 29185 | 2102 | 34 |
2387204 | 2387204 | 2022-04-08 | St. Clair | Missouri | 29185 | 2102 | 34 |
2383949 | 2383949 | 2022-04-07 | St. Clair | Missouri | 29185 | 2102 | 34 |
2380694 | 2380694 | 2022-04-06 | St. Clair | Missouri | 29185 | 2102 | 34 |
2377439 | 2377439 | 2022-04-05 | St. Clair | Missouri | 29185 | 2102 | 34 |
2374186 | 2374186 | 2022-04-04 | St. Clair | Missouri | 29185 | 2102 | 34 |
2370934 | 2370934 | 2022-04-03 | St. Clair | Missouri | 29185 | 2102 | 34 |
2367681 | 2367681 | 2022-04-02 | St. Clair | Missouri | 29185 | 2102 | 34 |
2364428 | 2364428 | 2022-04-01 | St. Clair | Missouri | 29185 | 2102 | 34 |
2361174 | 2361174 | 2022-03-31 | St. Clair | Missouri | 29185 | 2102 | 34 |
2357920 | 2357920 | 2022-03-30 | St. Clair | Missouri | 29185 | 2102 | 34 |
2354667 | 2354667 | 2022-03-29 | St. Clair | Missouri | 29185 | 2102 | 34 |
2351414 | 2351414 | 2022-03-28 | St. Clair | Missouri | 29185 | 2102 | 34 |
2348162 | 2348162 | 2022-03-27 | St. Clair | Missouri | 29185 | 2101 | 34 |
2344909 | 2344909 | 2022-03-26 | St. Clair | Missouri | 29185 | 2101 | 34 |
2341656 | 2341656 | 2022-03-25 | St. Clair | Missouri | 29185 | 2101 | 34 |
2328599 | 2328599 | 2022-03-21 | Lewis | Missouri | 29111 | 2743 | 34 |
2325347 | 2325347 | 2022-03-20 | Lewis | Missouri | 29111 | 2740 | 34 |
2322093 | 2322093 | 2022-03-19 | Lewis | Missouri | 29111 | 2740 | 34 |
2318839 | 2318839 | 2022-03-18 | Lewis | Missouri | 29111 | 2740 | 34 |
2315586 | 2315586 | 2022-03-17 | Lewis | Missouri | 29111 | 2737 | 34 |
2312333 | 2312333 | 2022-03-16 | Lewis | Missouri | 29111 | 2736 | 34 |
2309080 | 2309080 | 2022-03-15 | Lewis | Missouri | 29111 | 2735 | 34 |
2305791 | 2305791 | 2022-03-14 | Chariton | Missouri | 29041 | 1693 | 34 |
2305828 | 2305828 | 2022-03-14 | Lewis | Missouri | 29111 | 2728 | 34 |
2305834 | 2305834 | 2022-03-14 | Maries | Missouri | 29125 | 1595 | 34 |
2302540 | 2302540 | 2022-03-13 | Chariton | Missouri | 29041 | 1692 | 34 |
2302577 | 2302577 | 2022-03-13 | Lewis | Missouri | 29111 | 2728 | 34 |
2302583 | 2302583 | 2022-03-13 | Maries | Missouri | 29125 | 1595 | 34 |
2299288 | 2299288 | 2022-03-12 | Chariton | Missouri | 29041 | 1692 | 34 |
2299325 | 2299325 | 2022-03-12 | Lewis | Missouri | 29111 | 2728 | 34 |
2299331 | 2299331 | 2022-03-12 | Maries | Missouri | 29125 | 1595 | 34 |
2296036 | 2296036 | 2022-03-11 | Chariton | Missouri | 29041 | 1692 | 34 |
2296073 | 2296073 | 2022-03-11 | Lewis | Missouri | 29111 | 2728 | 34 |
2296079 | 2296079 | 2022-03-11 | Maries | Missouri | 29125 | 1595 | 34 |
2292784 | 2292784 | 2022-03-10 | Chariton | Missouri | 29041 | 1691 | 34 |
2292821 | 2292821 | 2022-03-10 | Lewis | Missouri | 29111 | 2726 | 34 |
2292827 | 2292827 | 2022-03-10 | Maries | Missouri | 29125 | 1591 | 34 |
2289532 | 2289532 | 2022-03-09 | Chariton | Missouri | 29041 | 1689 | 34 |
2289569 | 2289569 | 2022-03-09 | Lewis | Missouri | 29111 | 2723 | 34 |
2289575 | 2289575 | 2022-03-09 | Maries | Missouri | 29125 | 1591 | 34 |
2286280 | 2286280 | 2022-03-08 | Chariton | Missouri | 29041 | 1689 | 34 |
2286317 | 2286317 | 2022-03-08 | Lewis | Missouri | 29111 | 2716 | 34 |
2286323 | 2286323 | 2022-03-08 | Maries | Missouri | 29125 | 1590 | 34 |
2283028 | 2283028 | 2022-03-07 | Chariton | Missouri | 29041 | 1688 | 34 |
2283065 | 2283065 | 2022-03-07 | Lewis | Missouri | 29111 | 2710 | 34 |
2279775 | 2279775 | 2022-03-06 | Chariton | Missouri | 29041 | 1687 | 34 |
2279812 | 2279812 | 2022-03-06 | Lewis | Missouri | 29111 | 2710 | 34 |
2276522 | 2276522 | 2022-03-05 | Chariton | Missouri | 29041 | 1687 | 34 |
2276559 | 2276559 | 2022-03-05 | Lewis | Missouri | 29111 | 2710 | 34 |
2273269 | 2273269 | 2022-03-04 | Chariton | Missouri | 29041 | 1687 | 34 |
2273306 | 2273306 | 2022-03-04 | Lewis | Missouri | 29111 | 2710 | 34 |
2270017 | 2270017 | 2022-03-03 | Chariton | Missouri | 29041 | 1686 | 34 |
2270054 | 2270054 | 2022-03-03 | Lewis | Missouri | 29111 | 2698 | 34 |
2266764 | 2266764 | 2022-03-02 | Chariton | Missouri | 29041 | 1685 | 34 |
2266801 | 2266801 | 2022-03-02 | Lewis | Missouri | 29111 | 2695 | 34 |
2263513 | 2263513 | 2022-03-01 | Chariton | Missouri | 29041 | 1685 | 34 |
2263550 | 2263550 | 2022-03-01 | Lewis | Missouri | 29111 | 2693 | 34 |
2260254 | 2260254 | 2022-02-28 | Caldwell | Missouri | 29025 | 1669 | 34 |
2260262 | 2260262 | 2022-02-28 | Chariton | Missouri | 29041 | 1683 | 34 |
2260299 | 2260299 | 2022-02-28 | Lewis | Missouri | 29111 | 2687 | 34 |
2257003 | 2257003 | 2022-02-27 | Caldwell | Missouri | 29025 | 1669 | 34 |
2257011 | 2257011 | 2022-02-27 | Chariton | Missouri | 29041 | 1682 | 34 |
2257048 | 2257048 | 2022-02-27 | Lewis | Missouri | 29111 | 2679 | 34 |
2253752 | 2253752 | 2022-02-26 | Caldwell | Missouri | 29025 | 1669 | 34 |
2253760 | 2253760 | 2022-02-26 | Chariton | Missouri | 29041 | 1682 | 34 |
2253797 | 2253797 | 2022-02-26 | Lewis | Missouri | 29111 | 2679 | 34 |
2250501 | 2250501 | 2022-02-25 | Caldwell | Missouri | 29025 | 1669 | 34 |
2250509 | 2250509 | 2022-02-25 | Chariton | Missouri | 29041 | 1682 | 34 |
2250546 | 2250546 | 2022-02-25 | Lewis | Missouri | 29111 | 2679 | 34 |
2247250 | 2247250 | 2022-02-24 | Caldwell | Missouri | 29025 | 1661 | 34 |
2247258 | 2247258 | 2022-02-24 | Chariton | Missouri | 29041 | 1676 | 34 |
2247295 | 2247295 | 2022-02-24 | Lewis | Missouri | 29111 | 2663 | 34 |
2244007 | 2244007 | 2022-02-23 | Chariton | Missouri | 29041 | 1669 | 34 |
2244084 | 2244084 | 2022-02-23 | Shannon | Missouri | 29203 | 1581 | 34 |
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);