ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,152 rows where deaths = 11 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Rooks 201
- Greenwood 159
- Haskell 106
- Morton 80
- Osage 80
- Kingman 68
- Comanche 61
- Jewell 54
- Stevens 49
- Jackson 29
- Meade 24
- Republic 24
- Lane 23
- Riley 17
- Saline 16
- Graham 14
- Leavenworth 11
- Coffey 10
- Pottawatomie 10
- Butler 9
- Chautauqua 9
- Woodson 9
- McPherson 8
- Clay 7
- Finney 7
- Geary 7
- Kearny 7
- Neosho 7
- Pawnee 7
- Stafford 7
- …
state 1
- Kansas · 1,152 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500513 | 2500513 | 2022-05-13 | Haskell | Kansas | 20081 | 964 | 11 |
2500537 | 2500537 | 2022-05-13 | Morton | Kansas | 20129 | 621 | 11 |
2497255 | 2497255 | 2022-05-12 | Haskell | Kansas | 20081 | 963 | 11 |
2497279 | 2497279 | 2022-05-12 | Morton | Kansas | 20129 | 621 | 11 |
2493997 | 2493997 | 2022-05-11 | Haskell | Kansas | 20081 | 963 | 11 |
2494021 | 2494021 | 2022-05-11 | Morton | Kansas | 20129 | 621 | 11 |
2490739 | 2490739 | 2022-05-10 | Haskell | Kansas | 20081 | 963 | 11 |
2490763 | 2490763 | 2022-05-10 | Morton | Kansas | 20129 | 621 | 11 |
2487482 | 2487482 | 2022-05-09 | Haskell | Kansas | 20081 | 963 | 11 |
2487506 | 2487506 | 2022-05-09 | Morton | Kansas | 20129 | 621 | 11 |
2484224 | 2484224 | 2022-05-08 | Haskell | Kansas | 20081 | 963 | 11 |
2484248 | 2484248 | 2022-05-08 | Morton | Kansas | 20129 | 621 | 11 |
2480966 | 2480966 | 2022-05-07 | Haskell | Kansas | 20081 | 963 | 11 |
2480990 | 2480990 | 2022-05-07 | Morton | Kansas | 20129 | 621 | 11 |
2477708 | 2477708 | 2022-05-06 | Haskell | Kansas | 20081 | 963 | 11 |
2477732 | 2477732 | 2022-05-06 | Morton | Kansas | 20129 | 621 | 11 |
2474450 | 2474450 | 2022-05-05 | Haskell | Kansas | 20081 | 962 | 11 |
2474474 | 2474474 | 2022-05-05 | Morton | Kansas | 20129 | 620 | 11 |
2471193 | 2471193 | 2022-05-04 | Haskell | Kansas | 20081 | 962 | 11 |
2471217 | 2471217 | 2022-05-04 | Morton | Kansas | 20129 | 620 | 11 |
2467937 | 2467937 | 2022-05-03 | Haskell | Kansas | 20081 | 962 | 11 |
2467961 | 2467961 | 2022-05-03 | Morton | Kansas | 20129 | 620 | 11 |
2464682 | 2464682 | 2022-05-02 | Haskell | Kansas | 20081 | 962 | 11 |
2464706 | 2464706 | 2022-05-02 | Morton | Kansas | 20129 | 620 | 11 |
2461426 | 2461426 | 2022-05-01 | Haskell | Kansas | 20081 | 962 | 11 |
2461450 | 2461450 | 2022-05-01 | Morton | Kansas | 20129 | 620 | 11 |
2458170 | 2458170 | 2022-04-30 | Haskell | Kansas | 20081 | 962 | 11 |
2458194 | 2458194 | 2022-04-30 | Morton | Kansas | 20129 | 620 | 11 |
2454914 | 2454914 | 2022-04-29 | Haskell | Kansas | 20081 | 962 | 11 |
2454938 | 2454938 | 2022-04-29 | Morton | Kansas | 20129 | 620 | 11 |
2451658 | 2451658 | 2022-04-28 | Haskell | Kansas | 20081 | 962 | 11 |
2451682 | 2451682 | 2022-04-28 | Morton | Kansas | 20129 | 620 | 11 |
2448402 | 2448402 | 2022-04-27 | Haskell | Kansas | 20081 | 962 | 11 |
2448426 | 2448426 | 2022-04-27 | Morton | Kansas | 20129 | 620 | 11 |
2445146 | 2445146 | 2022-04-26 | Haskell | Kansas | 20081 | 962 | 11 |
2445170 | 2445170 | 2022-04-26 | Morton | Kansas | 20129 | 620 | 11 |
2441890 | 2441890 | 2022-04-25 | Haskell | Kansas | 20081 | 962 | 11 |
2441914 | 2441914 | 2022-04-25 | Morton | Kansas | 20129 | 620 | 11 |
2438634 | 2438634 | 2022-04-24 | Haskell | Kansas | 20081 | 962 | 11 |
2438658 | 2438658 | 2022-04-24 | Morton | Kansas | 20129 | 620 | 11 |
2435378 | 2435378 | 2022-04-23 | Haskell | Kansas | 20081 | 962 | 11 |
2435402 | 2435402 | 2022-04-23 | Morton | Kansas | 20129 | 620 | 11 |
2432122 | 2432122 | 2022-04-22 | Haskell | Kansas | 20081 | 962 | 11 |
2432146 | 2432146 | 2022-04-22 | Morton | Kansas | 20129 | 620 | 11 |
2428866 | 2428866 | 2022-04-21 | Haskell | Kansas | 20081 | 962 | 11 |
2428890 | 2428890 | 2022-04-21 | Morton | Kansas | 20129 | 620 | 11 |
2425610 | 2425610 | 2022-04-20 | Haskell | Kansas | 20081 | 962 | 11 |
2425634 | 2425634 | 2022-04-20 | Morton | Kansas | 20129 | 620 | 11 |
2422354 | 2422354 | 2022-04-19 | Haskell | Kansas | 20081 | 962 | 11 |
2422378 | 2422378 | 2022-04-19 | Morton | Kansas | 20129 | 620 | 11 |
2419098 | 2419098 | 2022-04-18 | Haskell | Kansas | 20081 | 962 | 11 |
2419122 | 2419122 | 2022-04-18 | Morton | Kansas | 20129 | 620 | 11 |
2415842 | 2415842 | 2022-04-17 | Haskell | Kansas | 20081 | 962 | 11 |
2415866 | 2415866 | 2022-04-17 | Morton | Kansas | 20129 | 620 | 11 |
2412586 | 2412586 | 2022-04-16 | Haskell | Kansas | 20081 | 962 | 11 |
2412610 | 2412610 | 2022-04-16 | Morton | Kansas | 20129 | 620 | 11 |
2409330 | 2409330 | 2022-04-15 | Haskell | Kansas | 20081 | 962 | 11 |
2409354 | 2409354 | 2022-04-15 | Morton | Kansas | 20129 | 620 | 11 |
2406074 | 2406074 | 2022-04-14 | Haskell | Kansas | 20081 | 961 | 11 |
2406098 | 2406098 | 2022-04-14 | Morton | Kansas | 20129 | 620 | 11 |
2402818 | 2402818 | 2022-04-13 | Haskell | Kansas | 20081 | 961 | 11 |
2402842 | 2402842 | 2022-04-13 | Morton | Kansas | 20129 | 620 | 11 |
2399564 | 2399564 | 2022-04-12 | Haskell | Kansas | 20081 | 961 | 11 |
2399588 | 2399588 | 2022-04-12 | Morton | Kansas | 20129 | 620 | 11 |
2396308 | 2396308 | 2022-04-11 | Haskell | Kansas | 20081 | 961 | 11 |
2396332 | 2396332 | 2022-04-11 | Morton | Kansas | 20129 | 620 | 11 |
2393053 | 2393053 | 2022-04-10 | Haskell | Kansas | 20081 | 961 | 11 |
2393077 | 2393077 | 2022-04-10 | Morton | Kansas | 20129 | 620 | 11 |
2389797 | 2389797 | 2022-04-09 | Haskell | Kansas | 20081 | 961 | 11 |
2389821 | 2389821 | 2022-04-09 | Morton | Kansas | 20129 | 620 | 11 |
2386541 | 2386541 | 2022-04-08 | Haskell | Kansas | 20081 | 961 | 11 |
2386565 | 2386565 | 2022-04-08 | Morton | Kansas | 20129 | 620 | 11 |
2383287 | 2383287 | 2022-04-07 | Haskell | Kansas | 20081 | 961 | 11 |
2383311 | 2383311 | 2022-04-07 | Morton | Kansas | 20129 | 620 | 11 |
2380032 | 2380032 | 2022-04-06 | Haskell | Kansas | 20081 | 961 | 11 |
2380056 | 2380056 | 2022-04-06 | Morton | Kansas | 20129 | 620 | 11 |
2376777 | 2376777 | 2022-04-05 | Haskell | Kansas | 20081 | 961 | 11 |
2376801 | 2376801 | 2022-04-05 | Morton | Kansas | 20129 | 620 | 11 |
2373525 | 2373525 | 2022-04-04 | Haskell | Kansas | 20081 | 961 | 11 |
2373549 | 2373549 | 2022-04-04 | Morton | Kansas | 20129 | 620 | 11 |
2370272 | 2370272 | 2022-04-03 | Haskell | Kansas | 20081 | 961 | 11 |
2370296 | 2370296 | 2022-04-03 | Morton | Kansas | 20129 | 620 | 11 |
2367019 | 2367019 | 2022-04-02 | Haskell | Kansas | 20081 | 961 | 11 |
2367043 | 2367043 | 2022-04-02 | Morton | Kansas | 20129 | 620 | 11 |
2363766 | 2363766 | 2022-04-01 | Haskell | Kansas | 20081 | 961 | 11 |
2363790 | 2363790 | 2022-04-01 | Morton | Kansas | 20129 | 620 | 11 |
2360512 | 2360512 | 2022-03-31 | Haskell | Kansas | 20081 | 961 | 11 |
2360536 | 2360536 | 2022-03-31 | Morton | Kansas | 20129 | 620 | 11 |
2357258 | 2357258 | 2022-03-30 | Haskell | Kansas | 20081 | 961 | 11 |
2357282 | 2357282 | 2022-03-30 | Morton | Kansas | 20129 | 620 | 11 |
2354005 | 2354005 | 2022-03-29 | Haskell | Kansas | 20081 | 961 | 11 |
2354029 | 2354029 | 2022-03-29 | Morton | Kansas | 20129 | 620 | 11 |
2350753 | 2350753 | 2022-03-28 | Haskell | Kansas | 20081 | 961 | 11 |
2350777 | 2350777 | 2022-03-28 | Morton | Kansas | 20129 | 620 | 11 |
2347500 | 2347500 | 2022-03-27 | Haskell | Kansas | 20081 | 961 | 11 |
2347524 | 2347524 | 2022-03-27 | Morton | Kansas | 20129 | 620 | 11 |
2344247 | 2344247 | 2022-03-26 | Haskell | Kansas | 20081 | 961 | 11 |
2344271 | 2344271 | 2022-03-26 | Morton | Kansas | 20129 | 620 | 11 |
2340994 | 2340994 | 2022-03-25 | Haskell | Kansas | 20081 | 961 | 11 |
2341018 | 2341018 | 2022-03-25 | Morton | Kansas | 20129 | 620 | 11 |
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);