ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,835 rows where deaths = 6 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Stanton 220
- Montgomery 207
- Wichita 197
- Jewell 156
- Logan 117
- Chautauqua 115
- Barber 113
- Elk 88
- Labette 53
- Osage 48
- Chase 47
- Stevens 44
- Sumner 42
- Hodgeman 34
- Lincoln 33
- Thomas 31
- Jefferson 27
- Lyon 18
- Kearny 17
- Brown 16
- Kiowa 16
- Leavenworth 14
- Morris 14
- Morton 14
- Sherman 14
- Ness 11
- Riley 11
- Coffey 9
- Crawford 9
- Pottawatomie 9
- …
state 1
- Kansas · 1,835 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2171847 | 2171847 | 2022-02-01 | Chase | Kansas | 20017 | 643 | 6 |
2168594 | 2168594 | 2022-01-31 | Chase | Kansas | 20017 | 643 | 6 |
2165339 | 2165339 | 2022-01-30 | Chase | Kansas | 20017 | 639 | 6 |
2162084 | 2162084 | 2022-01-29 | Chase | Kansas | 20017 | 639 | 6 |
2158829 | 2158829 | 2022-01-28 | Chase | Kansas | 20017 | 639 | 6 |
2155575 | 2155575 | 2022-01-27 | Chase | Kansas | 20017 | 625 | 6 |
2152322 | 2152322 | 2022-01-26 | Chase | Kansas | 20017 | 625 | 6 |
2149153 | 2149153 | 2022-01-25 | Smith | Kansas | 20183 | 595 | 6 |
2145901 | 2145901 | 2022-01-24 | Smith | Kansas | 20183 | 595 | 6 |
2142563 | 2142563 | 2022-01-23 | Chase | Kansas | 20017 | 590 | 6 |
2139308 | 2139308 | 2022-01-22 | Chase | Kansas | 20017 | 590 | 6 |
2136052 | 2136052 | 2022-01-21 | Chase | Kansas | 20017 | 590 | 6 |
2132800 | 2132800 | 2022-01-20 | Chase | Kansas | 20017 | 578 | 6 |
2129547 | 2129547 | 2022-01-19 | Chase | Kansas | 20017 | 578 | 6 |
2126293 | 2126293 | 2022-01-18 | Chase | Kansas | 20017 | 548 | 6 |
2123041 | 2123041 | 2022-01-17 | Chase | Kansas | 20017 | 548 | 6 |
2119789 | 2119789 | 2022-01-16 | Chase | Kansas | 20017 | 548 | 6 |
2116537 | 2116537 | 2022-01-15 | Chase | Kansas | 20017 | 548 | 6 |
2113286 | 2113286 | 2022-01-14 | Chase | Kansas | 20017 | 548 | 6 |
2110034 | 2110034 | 2022-01-13 | Chase | Kansas | 20017 | 525 | 6 |
2106783 | 2106783 | 2022-01-12 | Chase | Kansas | 20017 | 525 | 6 |
2103532 | 2103532 | 2022-01-11 | Chase | Kansas | 20017 | 500 | 6 |
2100281 | 2100281 | 2022-01-10 | Chase | Kansas | 20017 | 500 | 6 |
2097030 | 2097030 | 2022-01-09 | Chase | Kansas | 20017 | 493 | 6 |
2093778 | 2093778 | 2022-01-08 | Chase | Kansas | 20017 | 493 | 6 |
2090526 | 2090526 | 2022-01-07 | Chase | Kansas | 20017 | 493 | 6 |
2087275 | 2087275 | 2022-01-06 | Chase | Kansas | 20017 | 486 | 6 |
2084023 | 2084023 | 2022-01-05 | Chase | Kansas | 20017 | 486 | 6 |
2080771 | 2080771 | 2022-01-04 | Chase | Kansas | 20017 | 473 | 6 |
2077519 | 2077519 | 2022-01-03 | Chase | Kansas | 20017 | 473 | 6 |
2074268 | 2074268 | 2022-01-02 | Chase | Kansas | 20017 | 468 | 6 |
2071017 | 2071017 | 2022-01-01 | Chase | Kansas | 20017 | 468 | 6 |
2067766 | 2067766 | 2021-12-31 | Chase | Kansas | 20017 | 468 | 6 |
2064515 | 2064515 | 2021-12-30 | Chase | Kansas | 20017 | 468 | 6 |
2061265 | 2061265 | 2021-12-29 | Chase | Kansas | 20017 | 468 | 6 |
2058016 | 2058016 | 2021-12-28 | Chase | Kansas | 20017 | 463 | 6 |
2054767 | 2054767 | 2021-12-27 | Chase | Kansas | 20017 | 463 | 6 |
2051517 | 2051517 | 2021-12-26 | Chase | Kansas | 20017 | 454 | 6 |
2048267 | 2048267 | 2021-12-25 | Chase | Kansas | 20017 | 454 | 6 |
2045017 | 2045017 | 2021-12-24 | Chase | Kansas | 20017 | 454 | 6 |
2041768 | 2041768 | 2021-12-23 | Chase | Kansas | 20017 | 454 | 6 |
2038518 | 2038518 | 2021-12-22 | Chase | Kansas | 20017 | 454 | 6 |
2035268 | 2035268 | 2021-12-21 | Chase | Kansas | 20017 | 450 | 6 |
2032018 | 2032018 | 2021-12-20 | Chase | Kansas | 20017 | 450 | 6 |
2028767 | 2028767 | 2021-12-19 | Chase | Kansas | 20017 | 449 | 6 |
2025516 | 2025516 | 2021-12-18 | Chase | Kansas | 20017 | 449 | 6 |
2022265 | 2022265 | 2021-12-17 | Chase | Kansas | 20017 | 449 | 6 |
2019014 | 2019014 | 2021-12-16 | Chase | Kansas | 20017 | 447 | 6 |
2019030 | 2019030 | 2021-12-16 | Elk | Kansas | 20049 | 380 | 6 |
2015764 | 2015764 | 2021-12-15 | Chase | Kansas | 20017 | 447 | 6 |
2015780 | 2015780 | 2021-12-15 | Elk | Kansas | 20049 | 380 | 6 |
2012529 | 2012529 | 2021-12-14 | Elk | Kansas | 20049 | 378 | 6 |
2009278 | 2009278 | 2021-12-13 | Elk | Kansas | 20049 | 378 | 6 |
2006027 | 2006027 | 2021-12-12 | Elk | Kansas | 20049 | 378 | 6 |
2002776 | 2002776 | 2021-12-11 | Elk | Kansas | 20049 | 378 | 6 |
1999526 | 1999526 | 2021-12-10 | Elk | Kansas | 20049 | 378 | 6 |
1996275 | 1996275 | 2021-12-09 | Elk | Kansas | 20049 | 375 | 6 |
1996299 | 1996299 | 2021-12-09 | Kiowa | Kansas | 20097 | 437 | 6 |
1993024 | 1993024 | 2021-12-08 | Elk | Kansas | 20049 | 375 | 6 |
1993048 | 1993048 | 2021-12-08 | Kiowa | Kansas | 20097 | 437 | 6 |
1989773 | 1989773 | 2021-12-07 | Elk | Kansas | 20049 | 373 | 6 |
1989797 | 1989797 | 2021-12-07 | Kiowa | Kansas | 20097 | 432 | 6 |
1986523 | 1986523 | 2021-12-06 | Elk | Kansas | 20049 | 373 | 6 |
1986547 | 1986547 | 2021-12-06 | Kiowa | Kansas | 20097 | 432 | 6 |
1983273 | 1983273 | 2021-12-05 | Elk | Kansas | 20049 | 371 | 6 |
1983297 | 1983297 | 2021-12-05 | Kiowa | Kansas | 20097 | 428 | 6 |
1980023 | 1980023 | 2021-12-04 | Elk | Kansas | 20049 | 371 | 6 |
1980047 | 1980047 | 2021-12-04 | Kiowa | Kansas | 20097 | 428 | 6 |
1976773 | 1976773 | 2021-12-03 | Elk | Kansas | 20049 | 371 | 6 |
1976797 | 1976797 | 2021-12-03 | Kiowa | Kansas | 20097 | 428 | 6 |
1973524 | 1973524 | 2021-12-02 | Elk | Kansas | 20049 | 364 | 6 |
1973548 | 1973548 | 2021-12-02 | Kiowa | Kansas | 20097 | 426 | 6 |
1970274 | 1970274 | 2021-12-01 | Elk | Kansas | 20049 | 364 | 6 |
1970298 | 1970298 | 2021-12-01 | Kiowa | Kansas | 20097 | 426 | 6 |
1967024 | 1967024 | 2021-11-30 | Elk | Kansas | 20049 | 349 | 6 |
1967048 | 1967048 | 2021-11-30 | Kiowa | Kansas | 20097 | 420 | 6 |
1963772 | 1963772 | 2021-11-29 | Elk | Kansas | 20049 | 349 | 6 |
1963796 | 1963796 | 2021-11-29 | Kiowa | Kansas | 20097 | 420 | 6 |
1960521 | 1960521 | 2021-11-28 | Elk | Kansas | 20049 | 347 | 6 |
1960545 | 1960545 | 2021-11-28 | Kiowa | Kansas | 20097 | 417 | 6 |
1960549 | 1960549 | 2021-11-28 | Lincoln | Kansas | 20105 | 396 | 6 |
1957270 | 1957270 | 2021-11-27 | Elk | Kansas | 20049 | 347 | 6 |
1957294 | 1957294 | 2021-11-27 | Kiowa | Kansas | 20097 | 417 | 6 |
1957298 | 1957298 | 2021-11-27 | Lincoln | Kansas | 20105 | 396 | 6 |
1954019 | 1954019 | 2021-11-26 | Elk | Kansas | 20049 | 347 | 6 |
1954043 | 1954043 | 2021-11-26 | Kiowa | Kansas | 20097 | 417 | 6 |
1954047 | 1954047 | 2021-11-26 | Lincoln | Kansas | 20105 | 396 | 6 |
1950768 | 1950768 | 2021-11-25 | Elk | Kansas | 20049 | 347 | 6 |
1950792 | 1950792 | 2021-11-25 | Kiowa | Kansas | 20097 | 417 | 6 |
1950796 | 1950796 | 2021-11-25 | Lincoln | Kansas | 20105 | 396 | 6 |
1947517 | 1947517 | 2021-11-24 | Elk | Kansas | 20049 | 347 | 6 |
1947541 | 1947541 | 2021-11-24 | Kiowa | Kansas | 20097 | 417 | 6 |
1947545 | 1947545 | 2021-11-24 | Lincoln | Kansas | 20105 | 396 | 6 |
1944266 | 1944266 | 2021-11-23 | Elk | Kansas | 20049 | 342 | 6 |
1944294 | 1944294 | 2021-11-23 | Lincoln | Kansas | 20105 | 391 | 6 |
1944335 | 1944335 | 2021-11-23 | Stanton | Kansas | 20187 | 310 | 6 |
1941016 | 1941016 | 2021-11-22 | Elk | Kansas | 20049 | 342 | 6 |
1941044 | 1941044 | 2021-11-22 | Lincoln | Kansas | 20105 | 391 | 6 |
1941085 | 1941085 | 2021-11-22 | Stanton | Kansas | 20187 | 310 | 6 |
1937766 | 1937766 | 2021-11-21 | Elk | Kansas | 20049 | 341 | 6 |
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);