ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,006 rows where deaths = 20 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adair 162
- Gentry 159
- Andrew 63
- Macon 43
- Sullivan 37
- Caldwell 36
- Cedar 28
- Lewis 28
- Putnam 28
- Bollinger 24
- Reynolds 23
- Linn 22
- Cooper 21
- Lincoln 19
- Atchison 14
- Douglas 14
- Pemiscot 14
- Texas 14
- Dallas 13
- Jefferson 13
- Clay 12
- Washington 12
- Christian 10
- Mississippi 10
- Randolph 10
- Montgomery 8
- Ralls 8
- Ste. Genevieve 8
- Bates 7
- Benton 7
- …
state 1
- Missouri · 1,006 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328544 | 2328544 | 2022-03-21 | Atchison | Missouri | 29005 | 1389 | 20 |
2325292 | 2325292 | 2022-03-20 | Atchison | Missouri | 29005 | 1389 | 20 |
2322038 | 2322038 | 2022-03-19 | Atchison | Missouri | 29005 | 1389 | 20 |
2318784 | 2318784 | 2022-03-18 | Atchison | Missouri | 29005 | 1389 | 20 |
2315531 | 2315531 | 2022-03-17 | Atchison | Missouri | 29005 | 1389 | 20 |
2312278 | 2312278 | 2022-03-16 | Atchison | Missouri | 29005 | 1388 | 20 |
2309025 | 2309025 | 2022-03-15 | Atchison | Missouri | 29005 | 1386 | 20 |
2305773 | 2305773 | 2022-03-14 | Atchison | Missouri | 29005 | 1385 | 20 |
2302522 | 2302522 | 2022-03-13 | Atchison | Missouri | 29005 | 1382 | 20 |
2299270 | 2299270 | 2022-03-12 | Atchison | Missouri | 29005 | 1382 | 20 |
2296018 | 2296018 | 2022-03-11 | Atchison | Missouri | 29005 | 1382 | 20 |
2292766 | 2292766 | 2022-03-10 | Atchison | Missouri | 29005 | 1382 | 20 |
2289514 | 2289514 | 2022-03-09 | Atchison | Missouri | 29005 | 1380 | 20 |
2286262 | 2286262 | 2022-03-08 | Atchison | Missouri | 29005 | 1381 | 20 |
2283115 | 2283115 | 2022-03-07 | Sullivan | Missouri | 29211 | 1702 | 20 |
2279862 | 2279862 | 2022-03-06 | Sullivan | Missouri | 29211 | 1701 | 20 |
2276609 | 2276609 | 2022-03-05 | Sullivan | Missouri | 29211 | 1701 | 20 |
2273356 | 2273356 | 2022-03-04 | Sullivan | Missouri | 29211 | 1701 | 20 |
2270104 | 2270104 | 2022-03-03 | Sullivan | Missouri | 29211 | 1701 | 20 |
2266851 | 2266851 | 2022-03-02 | Sullivan | Missouri | 29211 | 1701 | 20 |
2263600 | 2263600 | 2022-03-01 | Sullivan | Missouri | 29211 | 1701 | 20 |
2260259 | 2260259 | 2022-02-28 | Carter | Missouri | 29035 | 1486 | 20 |
2260349 | 2260349 | 2022-02-28 | Sullivan | Missouri | 29211 | 1700 | 20 |
2257008 | 2257008 | 2022-02-27 | Carter | Missouri | 29035 | 1487 | 20 |
2257098 | 2257098 | 2022-02-27 | Sullivan | Missouri | 29211 | 1700 | 20 |
2253757 | 2253757 | 2022-02-26 | Carter | Missouri | 29035 | 1487 | 20 |
2253847 | 2253847 | 2022-02-26 | Sullivan | Missouri | 29211 | 1700 | 20 |
2250506 | 2250506 | 2022-02-25 | Carter | Missouri | 29035 | 1487 | 20 |
2250596 | 2250596 | 2022-02-25 | Sullivan | Missouri | 29211 | 1700 | 20 |
2247255 | 2247255 | 2022-02-24 | Carter | Missouri | 29035 | 1487 | 20 |
2247345 | 2247345 | 2022-02-24 | Sullivan | Missouri | 29211 | 1700 | 20 |
2244078 | 2244078 | 2022-02-23 | Reynolds | Missouri | 29179 | 1137 | 20 |
2244094 | 2244094 | 2022-02-23 | Sullivan | Missouri | 29211 | 1699 | 20 |
2240827 | 2240827 | 2022-02-22 | Reynolds | Missouri | 29179 | 1134 | 20 |
2240843 | 2240843 | 2022-02-22 | Sullivan | Missouri | 29211 | 1698 | 20 |
2237576 | 2237576 | 2022-02-21 | Reynolds | Missouri | 29179 | 1133 | 20 |
2237592 | 2237592 | 2022-02-21 | Sullivan | Missouri | 29211 | 1692 | 20 |
2234325 | 2234325 | 2022-02-20 | Reynolds | Missouri | 29179 | 1133 | 20 |
2234341 | 2234341 | 2022-02-20 | Sullivan | Missouri | 29211 | 1692 | 20 |
2231074 | 2231074 | 2022-02-19 | Reynolds | Missouri | 29179 | 1133 | 20 |
2231090 | 2231090 | 2022-02-19 | Sullivan | Missouri | 29211 | 1692 | 20 |
2227823 | 2227823 | 2022-02-18 | Reynolds | Missouri | 29179 | 1133 | 20 |
2227839 | 2227839 | 2022-02-18 | Sullivan | Missouri | 29211 | 1692 | 20 |
2224572 | 2224572 | 2022-02-17 | Reynolds | Missouri | 29179 | 1131 | 20 |
2224588 | 2224588 | 2022-02-17 | Sullivan | Missouri | 29211 | 1692 | 20 |
2221321 | 2221321 | 2022-02-16 | Reynolds | Missouri | 29179 | 1127 | 20 |
2221337 | 2221337 | 2022-02-16 | Sullivan | Missouri | 29211 | 1689 | 20 |
2218070 | 2218070 | 2022-02-15 | Reynolds | Missouri | 29179 | 1124 | 20 |
2218086 | 2218086 | 2022-02-15 | Sullivan | Missouri | 29211 | 1687 | 20 |
2214816 | 2214816 | 2022-02-14 | Ralls | Missouri | 29173 | 2389 | 20 |
2214819 | 2214819 | 2022-02-14 | Reynolds | Missouri | 29179 | 1121 | 20 |
2211564 | 2211564 | 2022-02-13 | Ralls | Missouri | 29173 | 2383 | 20 |
2211567 | 2211567 | 2022-02-13 | Reynolds | Missouri | 29179 | 1114 | 20 |
2208311 | 2208311 | 2022-02-12 | Ralls | Missouri | 29173 | 2383 | 20 |
2208314 | 2208314 | 2022-02-12 | Reynolds | Missouri | 29179 | 1114 | 20 |
2205058 | 2205058 | 2022-02-11 | Ralls | Missouri | 29173 | 2383 | 20 |
2205061 | 2205061 | 2022-02-11 | Reynolds | Missouri | 29179 | 1114 | 20 |
2201805 | 2201805 | 2022-02-10 | Ralls | Missouri | 29173 | 2383 | 20 |
2201808 | 2201808 | 2022-02-10 | Reynolds | Missouri | 29179 | 1114 | 20 |
2198551 | 2198551 | 2022-02-09 | Ralls | Missouri | 29173 | 2379 | 20 |
2198554 | 2198554 | 2022-02-09 | Reynolds | Missouri | 29179 | 1107 | 20 |
2195297 | 2195297 | 2022-02-08 | Ralls | Missouri | 29173 | 2375 | 20 |
2195300 | 2195300 | 2022-02-08 | Reynolds | Missouri | 29179 | 1096 | 20 |
2192046 | 2192046 | 2022-02-07 | Reynolds | Missouri | 29179 | 1091 | 20 |
2188793 | 2188793 | 2022-02-06 | Reynolds | Missouri | 29179 | 1091 | 20 |
2185540 | 2185540 | 2022-02-05 | Reynolds | Missouri | 29179 | 1090 | 20 |
2182288 | 2182288 | 2022-02-04 | Reynolds | Missouri | 29179 | 1086 | 20 |
2179036 | 2179036 | 2022-02-03 | Reynolds | Missouri | 29179 | 1084 | 20 |
2175784 | 2175784 | 2022-02-02 | Reynolds | Missouri | 29179 | 1080 | 20 |
2172531 | 2172531 | 2022-02-01 | Reynolds | Missouri | 29179 | 1073 | 20 |
2169274 | 2169274 | 2022-01-31 | Putnam | Missouri | 29171 | 905 | 20 |
2166019 | 2166019 | 2022-01-30 | Putnam | Missouri | 29171 | 905 | 20 |
2162764 | 2162764 | 2022-01-29 | Putnam | Missouri | 29171 | 905 | 20 |
2159509 | 2159509 | 2022-01-28 | Putnam | Missouri | 29171 | 899 | 20 |
2156255 | 2156255 | 2022-01-27 | Putnam | Missouri | 29171 | 896 | 20 |
2153002 | 2153002 | 2022-01-26 | Putnam | Missouri | 29171 | 892 | 20 |
2149750 | 2149750 | 2022-01-25 | Putnam | Missouri | 29171 | 879 | 20 |
2146498 | 2146498 | 2022-01-24 | Putnam | Missouri | 29171 | 865 | 20 |
2143243 | 2143243 | 2022-01-23 | Putnam | Missouri | 29171 | 862 | 20 |
2139988 | 2139988 | 2022-01-22 | Putnam | Missouri | 29171 | 861 | 20 |
2136732 | 2136732 | 2022-01-21 | Putnam | Missouri | 29171 | 857 | 20 |
2133480 | 2133480 | 2022-01-20 | Putnam | Missouri | 29171 | 854 | 20 |
2133500 | 2133500 | 2022-01-20 | Sullivan | Missouri | 29211 | 1482 | 20 |
2130227 | 2130227 | 2022-01-19 | Putnam | Missouri | 29171 | 843 | 20 |
2130247 | 2130247 | 2022-01-19 | Sullivan | Missouri | 29211 | 1454 | 20 |
2126973 | 2126973 | 2022-01-18 | Putnam | Missouri | 29171 | 830 | 20 |
2126993 | 2126993 | 2022-01-18 | Sullivan | Missouri | 29211 | 1441 | 20 |
2123721 | 2123721 | 2022-01-17 | Putnam | Missouri | 29171 | 824 | 20 |
2123741 | 2123741 | 2022-01-17 | Sullivan | Missouri | 29211 | 1416 | 20 |
2120469 | 2120469 | 2022-01-16 | Putnam | Missouri | 29171 | 824 | 20 |
2120489 | 2120489 | 2022-01-16 | Sullivan | Missouri | 29211 | 1416 | 20 |
2117217 | 2117217 | 2022-01-15 | Putnam | Missouri | 29171 | 824 | 20 |
2117237 | 2117237 | 2022-01-15 | Sullivan | Missouri | 29211 | 1416 | 20 |
2113966 | 2113966 | 2022-01-14 | Putnam | Missouri | 29171 | 810 | 20 |
2113986 | 2113986 | 2022-01-14 | Sullivan | Missouri | 29211 | 1407 | 20 |
2110714 | 2110714 | 2022-01-13 | Putnam | Missouri | 29171 | 804 | 20 |
2110734 | 2110734 | 2022-01-13 | Sullivan | Missouri | 29211 | 1401 | 20 |
2107463 | 2107463 | 2022-01-12 | Putnam | Missouri | 29171 | 799 | 20 |
2107483 | 2107483 | 2022-01-12 | Sullivan | Missouri | 29211 | 1381 | 20 |
2104212 | 2104212 | 2022-01-11 | Putnam | Missouri | 29171 | 799 | 20 |
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);