ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,039 rows where deaths = 14 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Cheyenne 240
- Gray 221
- Sheridan 166
- Wabaunsee 159
- Republic 144
- Washington 143
- Pawnee 133
- Rush 110
- Atchison 96
- Meade 84
- Ottawa 84
- Coffey 51
- Osborne 42
- Greenwood 38
- Grant 29
- Linn 28
- Wilson 23
- Thomas 21
- Stafford 19
- Riley 17
- Lyon 16
- Crawford 15
- Clay 14
- Comanche 14
- Dickinson 14
- Stevens 14
- Neosho 11
- Douglas 9
- Graham 9
- Woodson 9
- …
state 1
- Kansas · 2,039 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500484 | 2500484 | 2022-05-13 | Cheyenne | Kansas | 20023 | 652 | 14 |
2497226 | 2497226 | 2022-05-12 | Cheyenne | Kansas | 20023 | 652 | 14 |
2493968 | 2493968 | 2022-05-11 | Cheyenne | Kansas | 20023 | 652 | 14 |
2490710 | 2490710 | 2022-05-10 | Cheyenne | Kansas | 20023 | 652 | 14 |
2487453 | 2487453 | 2022-05-09 | Cheyenne | Kansas | 20023 | 652 | 14 |
2484195 | 2484195 | 2022-05-08 | Cheyenne | Kansas | 20023 | 652 | 14 |
2480937 | 2480937 | 2022-05-07 | Cheyenne | Kansas | 20023 | 652 | 14 |
2477679 | 2477679 | 2022-05-06 | Cheyenne | Kansas | 20023 | 652 | 14 |
2474421 | 2474421 | 2022-05-05 | Cheyenne | Kansas | 20023 | 652 | 14 |
2471164 | 2471164 | 2022-05-04 | Cheyenne | Kansas | 20023 | 652 | 14 |
2467908 | 2467908 | 2022-05-03 | Cheyenne | Kansas | 20023 | 652 | 14 |
2464653 | 2464653 | 2022-05-02 | Cheyenne | Kansas | 20023 | 652 | 14 |
2461397 | 2461397 | 2022-05-01 | Cheyenne | Kansas | 20023 | 652 | 14 |
2458141 | 2458141 | 2022-04-30 | Cheyenne | Kansas | 20023 | 652 | 14 |
2454885 | 2454885 | 2022-04-29 | Cheyenne | Kansas | 20023 | 652 | 14 |
2451629 | 2451629 | 2022-04-28 | Cheyenne | Kansas | 20023 | 652 | 14 |
2448373 | 2448373 | 2022-04-27 | Cheyenne | Kansas | 20023 | 652 | 14 |
2445117 | 2445117 | 2022-04-26 | Cheyenne | Kansas | 20023 | 652 | 14 |
2441861 | 2441861 | 2022-04-25 | Cheyenne | Kansas | 20023 | 652 | 14 |
2438605 | 2438605 | 2022-04-24 | Cheyenne | Kansas | 20023 | 652 | 14 |
2435349 | 2435349 | 2022-04-23 | Cheyenne | Kansas | 20023 | 652 | 14 |
2432093 | 2432093 | 2022-04-22 | Cheyenne | Kansas | 20023 | 652 | 14 |
2428837 | 2428837 | 2022-04-21 | Cheyenne | Kansas | 20023 | 652 | 14 |
2425581 | 2425581 | 2022-04-20 | Cheyenne | Kansas | 20023 | 652 | 14 |
2422325 | 2422325 | 2022-04-19 | Cheyenne | Kansas | 20023 | 652 | 14 |
2419069 | 2419069 | 2022-04-18 | Cheyenne | Kansas | 20023 | 652 | 14 |
2415813 | 2415813 | 2022-04-17 | Cheyenne | Kansas | 20023 | 652 | 14 |
2412557 | 2412557 | 2022-04-16 | Cheyenne | Kansas | 20023 | 652 | 14 |
2409301 | 2409301 | 2022-04-15 | Cheyenne | Kansas | 20023 | 652 | 14 |
2406045 | 2406045 | 2022-04-14 | Cheyenne | Kansas | 20023 | 656 | 14 |
2402789 | 2402789 | 2022-04-13 | Cheyenne | Kansas | 20023 | 656 | 14 |
2399535 | 2399535 | 2022-04-12 | Cheyenne | Kansas | 20023 | 656 | 14 |
2396279 | 2396279 | 2022-04-11 | Cheyenne | Kansas | 20023 | 656 | 14 |
2393024 | 2393024 | 2022-04-10 | Cheyenne | Kansas | 20023 | 656 | 14 |
2389768 | 2389768 | 2022-04-09 | Cheyenne | Kansas | 20023 | 656 | 14 |
2386512 | 2386512 | 2022-04-08 | Cheyenne | Kansas | 20023 | 656 | 14 |
2383258 | 2383258 | 2022-04-07 | Cheyenne | Kansas | 20023 | 656 | 14 |
2380003 | 2380003 | 2022-04-06 | Cheyenne | Kansas | 20023 | 656 | 14 |
2376748 | 2376748 | 2022-04-05 | Cheyenne | Kansas | 20023 | 656 | 14 |
2373496 | 2373496 | 2022-04-04 | Cheyenne | Kansas | 20023 | 656 | 14 |
2370243 | 2370243 | 2022-04-03 | Cheyenne | Kansas | 20023 | 656 | 14 |
2366990 | 2366990 | 2022-04-02 | Cheyenne | Kansas | 20023 | 656 | 14 |
2363737 | 2363737 | 2022-04-01 | Cheyenne | Kansas | 20023 | 656 | 14 |
2360483 | 2360483 | 2022-03-31 | Cheyenne | Kansas | 20023 | 656 | 14 |
2360504 | 2360504 | 2022-03-31 | Graham | Kansas | 20065 | 566 | 14 |
2357229 | 2357229 | 2022-03-30 | Cheyenne | Kansas | 20023 | 656 | 14 |
2357250 | 2357250 | 2022-03-30 | Graham | Kansas | 20065 | 566 | 14 |
2353976 | 2353976 | 2022-03-29 | Cheyenne | Kansas | 20023 | 656 | 14 |
2353997 | 2353997 | 2022-03-29 | Graham | Kansas | 20065 | 566 | 14 |
2350724 | 2350724 | 2022-03-28 | Cheyenne | Kansas | 20023 | 656 | 14 |
2350745 | 2350745 | 2022-03-28 | Graham | Kansas | 20065 | 566 | 14 |
2347471 | 2347471 | 2022-03-27 | Cheyenne | Kansas | 20023 | 656 | 14 |
2347492 | 2347492 | 2022-03-27 | Graham | Kansas | 20065 | 566 | 14 |
2344218 | 2344218 | 2022-03-26 | Cheyenne | Kansas | 20023 | 656 | 14 |
2344239 | 2344239 | 2022-03-26 | Graham | Kansas | 20065 | 566 | 14 |
2340965 | 2340965 | 2022-03-25 | Cheyenne | Kansas | 20023 | 656 | 14 |
2340986 | 2340986 | 2022-03-25 | Graham | Kansas | 20065 | 566 | 14 |
2337712 | 2337712 | 2022-03-24 | Cheyenne | Kansas | 20023 | 658 | 14 |
2337733 | 2337733 | 2022-03-24 | Graham | Kansas | 20065 | 565 | 14 |
2337804 | 2337804 | 2022-03-24 | Woodson | Kansas | 20207 | 794 | 14 |
2334458 | 2334458 | 2022-03-23 | Cheyenne | Kansas | 20023 | 658 | 14 |
2334479 | 2334479 | 2022-03-23 | Graham | Kansas | 20065 | 565 | 14 |
2334550 | 2334550 | 2022-03-23 | Woodson | Kansas | 20207 | 794 | 14 |
2331204 | 2331204 | 2022-03-22 | Cheyenne | Kansas | 20023 | 661 | 14 |
2331296 | 2331296 | 2022-03-22 | Woodson | Kansas | 20207 | 794 | 14 |
2327952 | 2327952 | 2022-03-21 | Cheyenne | Kansas | 20023 | 661 | 14 |
2328044 | 2328044 | 2022-03-21 | Woodson | Kansas | 20207 | 794 | 14 |
2324699 | 2324699 | 2022-03-20 | Cheyenne | Kansas | 20023 | 661 | 14 |
2324791 | 2324791 | 2022-03-20 | Woodson | Kansas | 20207 | 794 | 14 |
2321445 | 2321445 | 2022-03-19 | Cheyenne | Kansas | 20023 | 661 | 14 |
2321537 | 2321537 | 2022-03-19 | Woodson | Kansas | 20207 | 794 | 14 |
2318191 | 2318191 | 2022-03-18 | Cheyenne | Kansas | 20023 | 661 | 14 |
2318283 | 2318283 | 2022-03-18 | Woodson | Kansas | 20207 | 794 | 14 |
2314938 | 2314938 | 2022-03-17 | Cheyenne | Kansas | 20023 | 661 | 14 |
2315030 | 2315030 | 2022-03-17 | Woodson | Kansas | 20207 | 794 | 14 |
2311685 | 2311685 | 2022-03-16 | Cheyenne | Kansas | 20023 | 661 | 14 |
2311777 | 2311777 | 2022-03-16 | Woodson | Kansas | 20207 | 794 | 14 |
2308432 | 2308432 | 2022-03-15 | Cheyenne | Kansas | 20023 | 661 | 14 |
2305181 | 2305181 | 2022-03-14 | Cheyenne | Kansas | 20023 | 661 | 14 |
2301929 | 2301929 | 2022-03-13 | Cheyenne | Kansas | 20023 | 661 | 14 |
2298677 | 2298677 | 2022-03-12 | Cheyenne | Kansas | 20023 | 661 | 14 |
2295425 | 2295425 | 2022-03-11 | Cheyenne | Kansas | 20023 | 661 | 14 |
2292173 | 2292173 | 2022-03-10 | Cheyenne | Kansas | 20023 | 660 | 14 |
2292240 | 2292240 | 2022-03-10 | Republic | Kansas | 20157 | 1345 | 14 |
2288921 | 2288921 | 2022-03-09 | Cheyenne | Kansas | 20023 | 660 | 14 |
2288988 | 2288988 | 2022-03-09 | Republic | Kansas | 20157 | 1345 | 14 |
2285670 | 2285670 | 2022-03-08 | Cheyenne | Kansas | 20023 | 660 | 14 |
2285737 | 2285737 | 2022-03-08 | Republic | Kansas | 20157 | 1345 | 14 |
2282418 | 2282418 | 2022-03-07 | Cheyenne | Kansas | 20023 | 660 | 14 |
2282485 | 2282485 | 2022-03-07 | Republic | Kansas | 20157 | 1345 | 14 |
2279165 | 2279165 | 2022-03-06 | Cheyenne | Kansas | 20023 | 659 | 14 |
2279232 | 2279232 | 2022-03-06 | Republic | Kansas | 20157 | 1345 | 14 |
2275912 | 2275912 | 2022-03-05 | Cheyenne | Kansas | 20023 | 659 | 14 |
2275979 | 2275979 | 2022-03-05 | Republic | Kansas | 20157 | 1345 | 14 |
2272659 | 2272659 | 2022-03-04 | Cheyenne | Kansas | 20023 | 659 | 14 |
2272726 | 2272726 | 2022-03-04 | Republic | Kansas | 20157 | 1345 | 14 |
2269407 | 2269407 | 2022-03-03 | Cheyenne | Kansas | 20023 | 659 | 14 |
2269474 | 2269474 | 2022-03-03 | Republic | Kansas | 20157 | 1343 | 14 |
2266154 | 2266154 | 2022-03-02 | Cheyenne | Kansas | 20023 | 659 | 14 |
2266221 | 2266221 | 2022-03-02 | Republic | Kansas | 20157 | 1343 | 14 |
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);