ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
339 rows where deaths = 63 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Pike 60
- Marion 27
- McDonald 24
- Dent 21
- Douglas 21
- Livingston 19
- Texas 12
- Wright 12
- Adair 9
- Grundy 9
- Lafayette 8
- Audrain 7
- Barry 7
- Bates 7
- Henry 7
- Linn 7
- Miller 7
- Newton 7
- Pemiscot 7
- Vernon 7
- Washington 7
- Camden 6
- Cape Girardeau 6
- Christian 6
- Cooper 6
- Howell 4
- St. Charles 4
- Boone 2
- Dunklin 2
- Platte 2
- …
state 1
- Missouri · 339 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501076 | 2501076 | 2022-05-13 | Adair | Missouri | 29001 | 6095 | 63 |
2501159 | 2501159 | 2022-05-13 | Pike | Missouri | 29163 | 4264 | 63 |
2497818 | 2497818 | 2022-05-12 | Adair | Missouri | 29001 | 6095 | 63 |
2497901 | 2497901 | 2022-05-12 | Pike | Missouri | 29163 | 4263 | 63 |
2494560 | 2494560 | 2022-05-11 | Adair | Missouri | 29001 | 6095 | 63 |
2494643 | 2494643 | 2022-05-11 | Pike | Missouri | 29163 | 4263 | 63 |
2491302 | 2491302 | 2022-05-10 | Adair | Missouri | 29001 | 6095 | 63 |
2491385 | 2491385 | 2022-05-10 | Pike | Missouri | 29163 | 4263 | 63 |
2488044 | 2488044 | 2022-05-09 | Adair | Missouri | 29001 | 6095 | 63 |
2488127 | 2488127 | 2022-05-09 | Pike | Missouri | 29163 | 4263 | 63 |
2484787 | 2484787 | 2022-05-08 | Adair | Missouri | 29001 | 6095 | 63 |
2484870 | 2484870 | 2022-05-08 | Pike | Missouri | 29163 | 4263 | 63 |
2481529 | 2481529 | 2022-05-07 | Adair | Missouri | 29001 | 6095 | 63 |
2481612 | 2481612 | 2022-05-07 | Pike | Missouri | 29163 | 4263 | 63 |
2478271 | 2478271 | 2022-05-06 | Adair | Missouri | 29001 | 6095 | 63 |
2478354 | 2478354 | 2022-05-06 | Pike | Missouri | 29163 | 4263 | 63 |
2475013 | 2475013 | 2022-05-05 | Adair | Missouri | 29001 | 6095 | 63 |
2475096 | 2475096 | 2022-05-05 | Pike | Missouri | 29163 | 4252 | 63 |
2471839 | 2471839 | 2022-05-04 | Pike | Missouri | 29163 | 4238 | 63 |
2468583 | 2468583 | 2022-05-03 | Pike | Missouri | 29163 | 4238 | 63 |
2465327 | 2465327 | 2022-05-02 | Pike | Missouri | 29163 | 4238 | 63 |
2462072 | 2462072 | 2022-05-01 | Pike | Missouri | 29163 | 4238 | 63 |
2458816 | 2458816 | 2022-04-30 | Pike | Missouri | 29163 | 4238 | 63 |
2455560 | 2455560 | 2022-04-29 | Pike | Missouri | 29163 | 4238 | 63 |
2452304 | 2452304 | 2022-04-28 | Pike | Missouri | 29163 | 4238 | 63 |
2449048 | 2449048 | 2022-04-27 | Pike | Missouri | 29163 | 4238 | 63 |
2445791 | 2445791 | 2022-04-26 | Pike | Missouri | 29163 | 4238 | 63 |
2442536 | 2442536 | 2022-04-25 | Pike | Missouri | 29163 | 4238 | 63 |
2439280 | 2439280 | 2022-04-24 | Pike | Missouri | 29163 | 4238 | 63 |
2436024 | 2436024 | 2022-04-23 | Pike | Missouri | 29163 | 4238 | 63 |
2432768 | 2432768 | 2022-04-22 | Pike | Missouri | 29163 | 4238 | 63 |
2429512 | 2429512 | 2022-04-21 | Pike | Missouri | 29163 | 4238 | 63 |
2426256 | 2426256 | 2022-04-20 | Pike | Missouri | 29163 | 4238 | 63 |
2423000 | 2423000 | 2022-04-19 | Pike | Missouri | 29163 | 4238 | 63 |
2419743 | 2419743 | 2022-04-18 | Pike | Missouri | 29163 | 4238 | 63 |
2416488 | 2416488 | 2022-04-17 | Pike | Missouri | 29163 | 4238 | 63 |
2413232 | 2413232 | 2022-04-16 | Pike | Missouri | 29163 | 4238 | 63 |
2409976 | 2409976 | 2022-04-15 | Pike | Missouri | 29163 | 4238 | 63 |
2406720 | 2406720 | 2022-04-14 | Pike | Missouri | 29163 | 4238 | 63 |
2403464 | 2403464 | 2022-04-13 | Pike | Missouri | 29163 | 4238 | 63 |
2400209 | 2400209 | 2022-04-12 | Pike | Missouri | 29163 | 4238 | 63 |
2396954 | 2396954 | 2022-04-11 | Pike | Missouri | 29163 | 4238 | 63 |
2393699 | 2393699 | 2022-04-10 | Pike | Missouri | 29163 | 4238 | 63 |
2390443 | 2390443 | 2022-04-09 | Pike | Missouri | 29163 | 4238 | 63 |
2387187 | 2387187 | 2022-04-08 | Pike | Missouri | 29163 | 4238 | 63 |
2383932 | 2383932 | 2022-04-07 | Pike | Missouri | 29163 | 4238 | 63 |
2380677 | 2380677 | 2022-04-06 | Pike | Missouri | 29163 | 4238 | 63 |
2377422 | 2377422 | 2022-04-05 | Pike | Missouri | 29163 | 4238 | 63 |
2374169 | 2374169 | 2022-04-04 | Pike | Missouri | 29163 | 4238 | 63 |
2370917 | 2370917 | 2022-04-03 | Pike | Missouri | 29163 | 4238 | 63 |
2367664 | 2367664 | 2022-04-02 | Pike | Missouri | 29163 | 4238 | 63 |
2364411 | 2364411 | 2022-04-01 | Pike | Missouri | 29163 | 4238 | 63 |
2361157 | 2361157 | 2022-03-31 | Pike | Missouri | 29163 | 4238 | 63 |
2357903 | 2357903 | 2022-03-30 | Pike | Missouri | 29163 | 4237 | 63 |
2354650 | 2354650 | 2022-03-29 | Pike | Missouri | 29163 | 4237 | 63 |
2351397 | 2351397 | 2022-03-28 | Pike | Missouri | 29163 | 4237 | 63 |
2348145 | 2348145 | 2022-03-27 | Pike | Missouri | 29163 | 4237 | 63 |
2344892 | 2344892 | 2022-03-26 | Pike | Missouri | 29163 | 4237 | 63 |
2341639 | 2341639 | 2022-03-25 | Pike | Missouri | 29163 | 4237 | 63 |
2338386 | 2338386 | 2022-03-24 | Pike | Missouri | 29163 | 4238 | 63 |
2335132 | 2335132 | 2022-03-23 | Pike | Missouri | 29163 | 4237 | 63 |
2331878 | 2331878 | 2022-03-22 | Pike | Missouri | 29163 | 4237 | 63 |
2328601 | 2328601 | 2022-03-21 | Linn | Missouri | 29115 | 2540 | 63 |
2328625 | 2328625 | 2022-03-21 | Pike | Missouri | 29163 | 4236 | 63 |
2325349 | 2325349 | 2022-03-20 | Linn | Missouri | 29115 | 2540 | 63 |
2325373 | 2325373 | 2022-03-20 | Pike | Missouri | 29163 | 4236 | 63 |
2322095 | 2322095 | 2022-03-19 | Linn | Missouri | 29115 | 2540 | 63 |
2322119 | 2322119 | 2022-03-19 | Pike | Missouri | 29163 | 4236 | 63 |
2318841 | 2318841 | 2022-03-18 | Linn | Missouri | 29115 | 2540 | 63 |
2318865 | 2318865 | 2022-03-18 | Pike | Missouri | 29163 | 4236 | 63 |
2315588 | 2315588 | 2022-03-17 | Linn | Missouri | 29115 | 2540 | 63 |
2315612 | 2315612 | 2022-03-17 | Pike | Missouri | 29163 | 4236 | 63 |
2312335 | 2312335 | 2022-03-16 | Linn | Missouri | 29115 | 2540 | 63 |
2312359 | 2312359 | 2022-03-16 | Pike | Missouri | 29163 | 4236 | 63 |
2309082 | 2309082 | 2022-03-15 | Linn | Missouri | 29115 | 2538 | 63 |
2309106 | 2309106 | 2022-03-15 | Pike | Missouri | 29163 | 4236 | 63 |
2244026 | 2244026 | 2022-02-23 | Grundy | Missouri | 29079 | 2367 | 63 |
2240775 | 2240775 | 2022-02-22 | Grundy | Missouri | 29079 | 2364 | 63 |
2237524 | 2237524 | 2022-02-21 | Grundy | Missouri | 29079 | 2355 | 63 |
2234273 | 2234273 | 2022-02-20 | Grundy | Missouri | 29079 | 2355 | 63 |
2231022 | 2231022 | 2022-02-19 | Grundy | Missouri | 29079 | 2355 | 63 |
2227771 | 2227771 | 2022-02-18 | Grundy | Missouri | 29079 | 2355 | 63 |
2224520 | 2224520 | 2022-02-17 | Grundy | Missouri | 29079 | 2345 | 63 |
2221269 | 2221269 | 2022-02-16 | Grundy | Missouri | 29079 | 2337 | 63 |
2218018 | 2218018 | 2022-02-15 | Grundy | Missouri | 29079 | 2316 | 63 |
2192034 | 2192034 | 2022-02-07 | Pemiscot | Missouri | 29155 | 2877 | 63 |
2188781 | 2188781 | 2022-02-06 | Pemiscot | Missouri | 29155 | 2878 | 63 |
2185528 | 2185528 | 2022-02-05 | Pemiscot | Missouri | 29155 | 2878 | 63 |
2182276 | 2182276 | 2022-02-04 | Pemiscot | Missouri | 29155 | 2865 | 63 |
2179024 | 2179024 | 2022-02-03 | Pemiscot | Missouri | 29155 | 2855 | 63 |
2175772 | 2175772 | 2022-02-02 | Pemiscot | Missouri | 29155 | 2847 | 63 |
2172519 | 2172519 | 2022-02-01 | Pemiscot | Missouri | 29155 | 2832 | 63 |
2100900 | 2100900 | 2022-01-10 | Cooper | Missouri | 29053 | 3389 | 63 |
2097649 | 2097649 | 2022-01-09 | Cooper | Missouri | 29053 | 3373 | 63 |
2094397 | 2094397 | 2022-01-08 | Cooper | Missouri | 29053 | 3366 | 63 |
2091145 | 2091145 | 2022-01-07 | Cooper | Missouri | 29053 | 3341 | 63 |
2087894 | 2087894 | 2022-01-06 | Cooper | Missouri | 29053 | 3325 | 63 |
2084642 | 2084642 | 2022-01-05 | Cooper | Missouri | 29053 | 3309 | 63 |
2078118 | 2078118 | 2022-01-03 | Bates | Missouri | 29013 | 2805 | 63 |
2078144 | 2078144 | 2022-01-03 | Dent | Missouri | 29065 | 2380 | 63 |
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);