ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
979 rows where deaths = 15 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Hickory 105
- Macon 83
- Shelby 79
- Bollinger 58
- Ripley 55
- Caldwell 42
- Scotland 33
- Stoddard 32
- Holt 31
- Moniteau 28
- Adair 22
- Maries 22
- Barton 21
- Douglas 18
- Ste. Genevieve 17
- Sullivan 17
- Iron 16
- Shannon 15
- Marion 14
- Perry 14
- Wayne 14
- Dunklin 13
- Osage 12
- Randolph 12
- Andrew 10
- Gentry 9
- Madison 9
- McDonald 9
- Scott 9
- Cape Girardeau 8
- …
state 1
- Missouri · 979 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501174 | 2501174 | 2022-05-13 | Shelby | Missouri | 29205 | 1603 | 15 |
2497916 | 2497916 | 2022-05-12 | Shelby | Missouri | 29205 | 1598 | 15 |
2494658 | 2494658 | 2022-05-11 | Shelby | Missouri | 29205 | 1598 | 15 |
2491400 | 2491400 | 2022-05-10 | Shelby | Missouri | 29205 | 1598 | 15 |
2488142 | 2488142 | 2022-05-09 | Shelby | Missouri | 29205 | 1598 | 15 |
2484885 | 2484885 | 2022-05-08 | Shelby | Missouri | 29205 | 1598 | 15 |
2481627 | 2481627 | 2022-05-07 | Shelby | Missouri | 29205 | 1598 | 15 |
2478369 | 2478369 | 2022-05-06 | Shelby | Missouri | 29205 | 1598 | 15 |
2475111 | 2475111 | 2022-05-05 | Shelby | Missouri | 29205 | 1588 | 15 |
2471854 | 2471854 | 2022-05-04 | Shelby | Missouri | 29205 | 1555 | 15 |
2468598 | 2468598 | 2022-05-03 | Shelby | Missouri | 29205 | 1555 | 15 |
2465342 | 2465342 | 2022-05-02 | Shelby | Missouri | 29205 | 1555 | 15 |
2462087 | 2462087 | 2022-05-01 | Shelby | Missouri | 29205 | 1555 | 15 |
2458831 | 2458831 | 2022-04-30 | Shelby | Missouri | 29205 | 1555 | 15 |
2455575 | 2455575 | 2022-04-29 | Shelby | Missouri | 29205 | 1555 | 15 |
2452319 | 2452319 | 2022-04-28 | Shelby | Missouri | 29205 | 1555 | 15 |
2449063 | 2449063 | 2022-04-27 | Shelby | Missouri | 29205 | 1555 | 15 |
2445806 | 2445806 | 2022-04-26 | Shelby | Missouri | 29205 | 1555 | 15 |
2442551 | 2442551 | 2022-04-25 | Shelby | Missouri | 29205 | 1555 | 15 |
2439295 | 2439295 | 2022-04-24 | Shelby | Missouri | 29205 | 1555 | 15 |
2436039 | 2436039 | 2022-04-23 | Shelby | Missouri | 29205 | 1555 | 15 |
2432783 | 2432783 | 2022-04-22 | Shelby | Missouri | 29205 | 1555 | 15 |
2429527 | 2429527 | 2022-04-21 | Shelby | Missouri | 29205 | 1555 | 15 |
2426271 | 2426271 | 2022-04-20 | Shelby | Missouri | 29205 | 1555 | 15 |
2423015 | 2423015 | 2022-04-19 | Shelby | Missouri | 29205 | 1555 | 15 |
2419758 | 2419758 | 2022-04-18 | Shelby | Missouri | 29205 | 1555 | 15 |
2416503 | 2416503 | 2022-04-17 | Shelby | Missouri | 29205 | 1555 | 15 |
2413247 | 2413247 | 2022-04-16 | Shelby | Missouri | 29205 | 1555 | 15 |
2409991 | 2409991 | 2022-04-15 | Shelby | Missouri | 29205 | 1555 | 15 |
2406735 | 2406735 | 2022-04-14 | Shelby | Missouri | 29205 | 1555 | 15 |
2403479 | 2403479 | 2022-04-13 | Shelby | Missouri | 29205 | 1555 | 15 |
2400224 | 2400224 | 2022-04-12 | Shelby | Missouri | 29205 | 1555 | 15 |
2396969 | 2396969 | 2022-04-11 | Shelby | Missouri | 29205 | 1555 | 15 |
2393714 | 2393714 | 2022-04-10 | Shelby | Missouri | 29205 | 1555 | 15 |
2390458 | 2390458 | 2022-04-09 | Shelby | Missouri | 29205 | 1555 | 15 |
2387202 | 2387202 | 2022-04-08 | Shelby | Missouri | 29205 | 1555 | 15 |
2383947 | 2383947 | 2022-04-07 | Shelby | Missouri | 29205 | 1555 | 15 |
2380692 | 2380692 | 2022-04-06 | Shelby | Missouri | 29205 | 1555 | 15 |
2377437 | 2377437 | 2022-04-05 | Shelby | Missouri | 29205 | 1555 | 15 |
2374184 | 2374184 | 2022-04-04 | Shelby | Missouri | 29205 | 1555 | 15 |
2370932 | 2370932 | 2022-04-03 | Shelby | Missouri | 29205 | 1555 | 15 |
2367679 | 2367679 | 2022-04-02 | Shelby | Missouri | 29205 | 1555 | 15 |
2364426 | 2364426 | 2022-04-01 | Shelby | Missouri | 29205 | 1555 | 15 |
2361172 | 2361172 | 2022-03-31 | Shelby | Missouri | 29205 | 1555 | 15 |
2357918 | 2357918 | 2022-03-30 | Shelby | Missouri | 29205 | 1549 | 15 |
2354665 | 2354665 | 2022-03-29 | Shelby | Missouri | 29205 | 1541 | 15 |
2351412 | 2351412 | 2022-03-28 | Shelby | Missouri | 29205 | 1541 | 15 |
2348160 | 2348160 | 2022-03-27 | Shelby | Missouri | 29205 | 1540 | 15 |
2344907 | 2344907 | 2022-03-26 | Shelby | Missouri | 29205 | 1540 | 15 |
2341654 | 2341654 | 2022-03-25 | Shelby | Missouri | 29205 | 1540 | 15 |
2338401 | 2338401 | 2022-03-24 | Shelby | Missouri | 29205 | 1534 | 15 |
2335147 | 2335147 | 2022-03-23 | Shelby | Missouri | 29205 | 1526 | 15 |
2331893 | 2331893 | 2022-03-22 | Shelby | Missouri | 29205 | 1522 | 15 |
2328640 | 2328640 | 2022-03-21 | Shelby | Missouri | 29205 | 1522 | 15 |
2325388 | 2325388 | 2022-03-20 | Shelby | Missouri | 29205 | 1522 | 15 |
2322134 | 2322134 | 2022-03-19 | Shelby | Missouri | 29205 | 1522 | 15 |
2318880 | 2318880 | 2022-03-18 | Shelby | Missouri | 29205 | 1522 | 15 |
2315627 | 2315627 | 2022-03-17 | Shelby | Missouri | 29205 | 1521 | 15 |
2312374 | 2312374 | 2022-03-16 | Shelby | Missouri | 29205 | 1511 | 15 |
2309121 | 2309121 | 2022-03-15 | Shelby | Missouri | 29205 | 1509 | 15 |
2305869 | 2305869 | 2022-03-14 | Shelby | Missouri | 29205 | 1508 | 15 |
2302618 | 2302618 | 2022-03-13 | Shelby | Missouri | 29205 | 1508 | 15 |
2299366 | 2299366 | 2022-03-12 | Shelby | Missouri | 29205 | 1508 | 15 |
2296114 | 2296114 | 2022-03-11 | Shelby | Missouri | 29205 | 1508 | 15 |
2292862 | 2292862 | 2022-03-10 | Shelby | Missouri | 29205 | 1508 | 15 |
2289610 | 2289610 | 2022-03-09 | Shelby | Missouri | 29205 | 1505 | 15 |
2286358 | 2286358 | 2022-03-08 | Shelby | Missouri | 29205 | 1503 | 15 |
2283106 | 2283106 | 2022-03-07 | Shelby | Missouri | 29205 | 1503 | 15 |
2279853 | 2279853 | 2022-03-06 | Shelby | Missouri | 29205 | 1501 | 15 |
2276600 | 2276600 | 2022-03-05 | Shelby | Missouri | 29205 | 1501 | 15 |
2273347 | 2273347 | 2022-03-04 | Shelby | Missouri | 29205 | 1501 | 15 |
2270095 | 2270095 | 2022-03-03 | Shelby | Missouri | 29205 | 1501 | 15 |
2266842 | 2266842 | 2022-03-02 | Shelby | Missouri | 29205 | 1501 | 15 |
2263591 | 2263591 | 2022-03-01 | Shelby | Missouri | 29205 | 1501 | 15 |
2260340 | 2260340 | 2022-02-28 | Shelby | Missouri | 29205 | 1501 | 15 |
2257089 | 2257089 | 2022-02-27 | Shelby | Missouri | 29205 | 1493 | 15 |
2253838 | 2253838 | 2022-02-26 | Shelby | Missouri | 29205 | 1493 | 15 |
2250587 | 2250587 | 2022-02-25 | Shelby | Missouri | 29205 | 1493 | 15 |
2247336 | 2247336 | 2022-02-24 | Shelby | Missouri | 29205 | 1493 | 15 |
2032706 | 2032706 | 2021-12-20 | Scotland | Missouri | 29199 | 486 | 15 |
2029455 | 2029455 | 2021-12-19 | Scotland | Missouri | 29199 | 485 | 15 |
2026204 | 2026204 | 2021-12-18 | Scotland | Missouri | 29199 | 482 | 15 |
2022953 | 2022953 | 2021-12-17 | Scotland | Missouri | 29199 | 481 | 15 |
2019702 | 2019702 | 2021-12-16 | Scotland | Missouri | 29199 | 472 | 15 |
2016452 | 2016452 | 2021-12-15 | Scotland | Missouri | 29199 | 470 | 15 |
2013201 | 2013201 | 2021-12-14 | Scotland | Missouri | 29199 | 469 | 15 |
2009950 | 2009950 | 2021-12-13 | Scotland | Missouri | 29199 | 466 | 15 |
2006699 | 2006699 | 2021-12-12 | Scotland | Missouri | 29199 | 466 | 15 |
2003448 | 2003448 | 2021-12-11 | Scotland | Missouri | 29199 | 464 | 15 |
2000198 | 2000198 | 2021-12-10 | Scotland | Missouri | 29199 | 464 | 15 |
1996947 | 1996947 | 2021-12-09 | Scotland | Missouri | 29199 | 460 | 15 |
1993696 | 1993696 | 2021-12-08 | Scotland | Missouri | 29199 | 452 | 15 |
1990445 | 1990445 | 2021-12-07 | Scotland | Missouri | 29199 | 449 | 15 |
1987195 | 1987195 | 2021-12-06 | Scotland | Missouri | 29199 | 448 | 15 |
1983945 | 1983945 | 2021-12-05 | Scotland | Missouri | 29199 | 448 | 15 |
1980695 | 1980695 | 2021-12-04 | Scotland | Missouri | 29199 | 448 | 15 |
1977445 | 1977445 | 2021-12-03 | Scotland | Missouri | 29199 | 441 | 15 |
1974195 | 1974195 | 2021-12-02 | Scotland | Missouri | 29199 | 441 | 15 |
1970946 | 1970946 | 2021-12-01 | Scotland | Missouri | 29199 | 441 | 15 |
1967696 | 1967696 | 2021-11-30 | Scotland | Missouri | 29199 | 439 | 15 |
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);