ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,561 rows where deaths = 7 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Rawlins 349
- Clark 346
- Lane 192
- Barber 163
- Sherman 158
- Kiowa 155
- Doniphan 107
- Chase 84
- Smith 78
- Stanton 77
- Leavenworth 71
- Stevens 67
- Rooks 54
- Lincoln 53
- Barton 48
- Logan 45
- Elk 42
- Gray 38
- Hodgeman 38
- Chautauqua 37
- Lyon 31
- Linn 27
- Miami 23
- Thomas 22
- Seward 21
- Kingman 18
- Shawnee 15
- Brown 13
- Ness 12
- Wilson 11
- …
state 1
- Kansas · 2,561 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500481 | 2500481 | 2022-05-13 | Chase | Kansas | 20017 | 673 | 7 |
2500521 | 2500521 | 2022-05-13 | Kiowa | Kansas | 20097 | 667 | 7 |
2500564 | 2500564 | 2022-05-13 | Smith | Kansas | 20183 | 645 | 7 |
2497223 | 2497223 | 2022-05-12 | Chase | Kansas | 20017 | 673 | 7 |
2497263 | 2497263 | 2022-05-12 | Kiowa | Kansas | 20097 | 666 | 7 |
2497306 | 2497306 | 2022-05-12 | Smith | Kansas | 20183 | 645 | 7 |
2493965 | 2493965 | 2022-05-11 | Chase | Kansas | 20017 | 673 | 7 |
2494005 | 2494005 | 2022-05-11 | Kiowa | Kansas | 20097 | 666 | 7 |
2494048 | 2494048 | 2022-05-11 | Smith | Kansas | 20183 | 645 | 7 |
2490707 | 2490707 | 2022-05-10 | Chase | Kansas | 20017 | 673 | 7 |
2490747 | 2490747 | 2022-05-10 | Kiowa | Kansas | 20097 | 666 | 7 |
2490790 | 2490790 | 2022-05-10 | Smith | Kansas | 20183 | 645 | 7 |
2487450 | 2487450 | 2022-05-09 | Chase | Kansas | 20017 | 673 | 7 |
2487490 | 2487490 | 2022-05-09 | Kiowa | Kansas | 20097 | 666 | 7 |
2487533 | 2487533 | 2022-05-09 | Smith | Kansas | 20183 | 645 | 7 |
2484192 | 2484192 | 2022-05-08 | Chase | Kansas | 20017 | 673 | 7 |
2484232 | 2484232 | 2022-05-08 | Kiowa | Kansas | 20097 | 666 | 7 |
2484275 | 2484275 | 2022-05-08 | Smith | Kansas | 20183 | 645 | 7 |
2480934 | 2480934 | 2022-05-07 | Chase | Kansas | 20017 | 673 | 7 |
2480974 | 2480974 | 2022-05-07 | Kiowa | Kansas | 20097 | 666 | 7 |
2481017 | 2481017 | 2022-05-07 | Smith | Kansas | 20183 | 645 | 7 |
2477676 | 2477676 | 2022-05-06 | Chase | Kansas | 20017 | 673 | 7 |
2477716 | 2477716 | 2022-05-06 | Kiowa | Kansas | 20097 | 666 | 7 |
2477759 | 2477759 | 2022-05-06 | Smith | Kansas | 20183 | 645 | 7 |
2474418 | 2474418 | 2022-05-05 | Chase | Kansas | 20017 | 673 | 7 |
2474458 | 2474458 | 2022-05-05 | Kiowa | Kansas | 20097 | 666 | 7 |
2474501 | 2474501 | 2022-05-05 | Smith | Kansas | 20183 | 644 | 7 |
2471161 | 2471161 | 2022-05-04 | Chase | Kansas | 20017 | 673 | 7 |
2471201 | 2471201 | 2022-05-04 | Kiowa | Kansas | 20097 | 666 | 7 |
2471244 | 2471244 | 2022-05-04 | Smith | Kansas | 20183 | 644 | 7 |
2467905 | 2467905 | 2022-05-03 | Chase | Kansas | 20017 | 673 | 7 |
2467945 | 2467945 | 2022-05-03 | Kiowa | Kansas | 20097 | 666 | 7 |
2467988 | 2467988 | 2022-05-03 | Smith | Kansas | 20183 | 644 | 7 |
2464650 | 2464650 | 2022-05-02 | Chase | Kansas | 20017 | 673 | 7 |
2464690 | 2464690 | 2022-05-02 | Kiowa | Kansas | 20097 | 666 | 7 |
2464733 | 2464733 | 2022-05-02 | Smith | Kansas | 20183 | 644 | 7 |
2461394 | 2461394 | 2022-05-01 | Chase | Kansas | 20017 | 673 | 7 |
2461434 | 2461434 | 2022-05-01 | Kiowa | Kansas | 20097 | 666 | 7 |
2461477 | 2461477 | 2022-05-01 | Smith | Kansas | 20183 | 644 | 7 |
2458138 | 2458138 | 2022-04-30 | Chase | Kansas | 20017 | 673 | 7 |
2458178 | 2458178 | 2022-04-30 | Kiowa | Kansas | 20097 | 666 | 7 |
2458221 | 2458221 | 2022-04-30 | Smith | Kansas | 20183 | 644 | 7 |
2454882 | 2454882 | 2022-04-29 | Chase | Kansas | 20017 | 673 | 7 |
2454922 | 2454922 | 2022-04-29 | Kiowa | Kansas | 20097 | 666 | 7 |
2454965 | 2454965 | 2022-04-29 | Smith | Kansas | 20183 | 644 | 7 |
2451626 | 2451626 | 2022-04-28 | Chase | Kansas | 20017 | 675 | 7 |
2451666 | 2451666 | 2022-04-28 | Kiowa | Kansas | 20097 | 666 | 7 |
2451709 | 2451709 | 2022-04-28 | Smith | Kansas | 20183 | 644 | 7 |
2448370 | 2448370 | 2022-04-27 | Chase | Kansas | 20017 | 675 | 7 |
2448410 | 2448410 | 2022-04-27 | Kiowa | Kansas | 20097 | 666 | 7 |
2448453 | 2448453 | 2022-04-27 | Smith | Kansas | 20183 | 644 | 7 |
2445114 | 2445114 | 2022-04-26 | Chase | Kansas | 20017 | 675 | 7 |
2445154 | 2445154 | 2022-04-26 | Kiowa | Kansas | 20097 | 666 | 7 |
2445197 | 2445197 | 2022-04-26 | Smith | Kansas | 20183 | 644 | 7 |
2441858 | 2441858 | 2022-04-25 | Chase | Kansas | 20017 | 675 | 7 |
2441898 | 2441898 | 2022-04-25 | Kiowa | Kansas | 20097 | 666 | 7 |
2441941 | 2441941 | 2022-04-25 | Smith | Kansas | 20183 | 644 | 7 |
2438602 | 2438602 | 2022-04-24 | Chase | Kansas | 20017 | 675 | 7 |
2438642 | 2438642 | 2022-04-24 | Kiowa | Kansas | 20097 | 666 | 7 |
2438685 | 2438685 | 2022-04-24 | Smith | Kansas | 20183 | 644 | 7 |
2435346 | 2435346 | 2022-04-23 | Chase | Kansas | 20017 | 675 | 7 |
2435386 | 2435386 | 2022-04-23 | Kiowa | Kansas | 20097 | 666 | 7 |
2435429 | 2435429 | 2022-04-23 | Smith | Kansas | 20183 | 644 | 7 |
2432090 | 2432090 | 2022-04-22 | Chase | Kansas | 20017 | 675 | 7 |
2432130 | 2432130 | 2022-04-22 | Kiowa | Kansas | 20097 | 666 | 7 |
2432173 | 2432173 | 2022-04-22 | Smith | Kansas | 20183 | 644 | 7 |
2428834 | 2428834 | 2022-04-21 | Chase | Kansas | 20017 | 675 | 7 |
2428874 | 2428874 | 2022-04-21 | Kiowa | Kansas | 20097 | 666 | 7 |
2428917 | 2428917 | 2022-04-21 | Smith | Kansas | 20183 | 644 | 7 |
2425578 | 2425578 | 2022-04-20 | Chase | Kansas | 20017 | 675 | 7 |
2425618 | 2425618 | 2022-04-20 | Kiowa | Kansas | 20097 | 666 | 7 |
2425661 | 2425661 | 2022-04-20 | Smith | Kansas | 20183 | 644 | 7 |
2422322 | 2422322 | 2022-04-19 | Chase | Kansas | 20017 | 675 | 7 |
2422362 | 2422362 | 2022-04-19 | Kiowa | Kansas | 20097 | 666 | 7 |
2422405 | 2422405 | 2022-04-19 | Smith | Kansas | 20183 | 644 | 7 |
2419066 | 2419066 | 2022-04-18 | Chase | Kansas | 20017 | 675 | 7 |
2419106 | 2419106 | 2022-04-18 | Kiowa | Kansas | 20097 | 666 | 7 |
2419149 | 2419149 | 2022-04-18 | Smith | Kansas | 20183 | 644 | 7 |
2415810 | 2415810 | 2022-04-17 | Chase | Kansas | 20017 | 675 | 7 |
2415850 | 2415850 | 2022-04-17 | Kiowa | Kansas | 20097 | 666 | 7 |
2415893 | 2415893 | 2022-04-17 | Smith | Kansas | 20183 | 644 | 7 |
2412554 | 2412554 | 2022-04-16 | Chase | Kansas | 20017 | 675 | 7 |
2412594 | 2412594 | 2022-04-16 | Kiowa | Kansas | 20097 | 666 | 7 |
2412637 | 2412637 | 2022-04-16 | Smith | Kansas | 20183 | 644 | 7 |
2409298 | 2409298 | 2022-04-15 | Chase | Kansas | 20017 | 675 | 7 |
2409338 | 2409338 | 2022-04-15 | Kiowa | Kansas | 20097 | 666 | 7 |
2409381 | 2409381 | 2022-04-15 | Smith | Kansas | 20183 | 644 | 7 |
2406042 | 2406042 | 2022-04-14 | Chase | Kansas | 20017 | 676 | 7 |
2406082 | 2406082 | 2022-04-14 | Kiowa | Kansas | 20097 | 667 | 7 |
2406125 | 2406125 | 2022-04-14 | Smith | Kansas | 20183 | 643 | 7 |
2402786 | 2402786 | 2022-04-13 | Chase | Kansas | 20017 | 676 | 7 |
2402826 | 2402826 | 2022-04-13 | Kiowa | Kansas | 20097 | 667 | 7 |
2402869 | 2402869 | 2022-04-13 | Smith | Kansas | 20183 | 643 | 7 |
2399532 | 2399532 | 2022-04-12 | Chase | Kansas | 20017 | 676 | 7 |
2399572 | 2399572 | 2022-04-12 | Kiowa | Kansas | 20097 | 667 | 7 |
2399615 | 2399615 | 2022-04-12 | Smith | Kansas | 20183 | 643 | 7 |
2396276 | 2396276 | 2022-04-11 | Chase | Kansas | 20017 | 676 | 7 |
2396316 | 2396316 | 2022-04-11 | Kiowa | Kansas | 20097 | 667 | 7 |
2396359 | 2396359 | 2022-04-11 | Smith | Kansas | 20183 | 643 | 7 |
2393021 | 2393021 | 2022-04-10 | Chase | Kansas | 20017 | 676 | 7 |
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);