ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,294 rows where state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 20091 193
- 20209 188
- 20015 187
- 20059 186
- 20045 183
- 20057 183
- 20103 182
- 20021 181
- 20107 181
- 20127 181
- 20173 181
- 20155 180
- 20161 180
- 20085 178
- 20123 178
- 20011 177
- 20111 177
- 20043 176
- 20149 176
- 20207 176
- 20037 175
- 20133 175
- 20177 175
- 20087 174
- 20191 174
- 20027 173
- 20031 173
- 20063 173
- 20079 173
- 20113 173
- …
county >30
- Johnson 193
- Wyandotte 188
- Butler 187
- Franklin 186
- Douglas 183
- Ford 183
- Leavenworth 182
- Cherokee 181
- Linn 181
- Morris 181
- Sedgwick 181
- Reno 180
- Riley 180
- Jackson 178
- Mitchell 178
- Bourbon 177
- Lyon 177
- Doniphan 176
- Pottawatomie 176
- Woodson 176
- Crawford 175
- Neosho 175
- Shawnee 175
- Jefferson 174
- Sumner 174
- Clay 173
- Coffey 173
- Gove 173
- Harvey 173
- McPherson 173
- …
state 1
- Kansas · 15,542 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535316 | 535316 | 2020-09-15 | Allen | Kansas | 20001 | 39 | 0 |
535317 | 535317 | 2020-09-15 | Anderson | Kansas | 20003 | 56 | 0 |
535318 | 535318 | 2020-09-15 | Atchison | Kansas | 20005 | 281 | 1 |
535319 | 535319 | 2020-09-15 | Barber | Kansas | 20007 | 5 | 0 |
535320 | 535320 | 2020-09-15 | Barton | Kansas | 20009 | 365 | 5 |
535321 | 535321 | 2020-09-15 | Bourbon | Kansas | 20011 | 132 | 2 |
535322 | 535322 | 2020-09-15 | Brown | Kansas | 20013 | 88 | 3 |
535323 | 535323 | 2020-09-15 | Butler | Kansas | 20015 | 803 | 4 |
535324 | 535324 | 2020-09-15 | Chase | Kansas | 20017 | 81 | 1 |
535325 | 535325 | 2020-09-15 | Chautauqua | Kansas | 20019 | 15 | 0 |
535326 | 535326 | 2020-09-15 | Cherokee | Kansas | 20021 | 397 | 7 |
535327 | 535327 | 2020-09-15 | Cheyenne | Kansas | 20023 | 10 | 0 |
535328 | 535328 | 2020-09-15 | Clark | Kansas | 20025 | 50 | 1 |
535329 | 535329 | 2020-09-15 | Clay | Kansas | 20027 | 40 | 2 |
535330 | 535330 | 2020-09-15 | Cloud | Kansas | 20029 | 62 | 1 |
535331 | 535331 | 2020-09-15 | Coffey | Kansas | 20031 | 103 | 8 |
535332 | 535332 | 2020-09-15 | Comanche | Kansas | 20033 | 10 | 0 |
535333 | 535333 | 2020-09-15 | Cowley | Kansas | 20035 | 302 | 3 |
535334 | 535334 | 2020-09-15 | Crawford | Kansas | 20037 | 891 | 5 |
535335 | 535335 | 2020-09-15 | Decatur | Kansas | 20039 | 10 | 0 |
535336 | 535336 | 2020-09-15 | Dickinson | Kansas | 20041 | 87 | 1 |
535337 | 535337 | 2020-09-15 | Doniphan | Kansas | 20043 | 87 | 0 |
535338 | 535338 | 2020-09-15 | Douglas | Kansas | 20045 | 1935 | 10 |
535339 | 535339 | 2020-09-15 | Edwards | Kansas | 20047 | 33 | 0 |
535340 | 535340 | 2020-09-15 | Elk | Kansas | 20049 | 1 | 0 |
535341 | 535341 | 2020-09-15 | Ellis | Kansas | 20051 | 725 | 3 |
535342 | 535342 | 2020-09-15 | Ellsworth | Kansas | 20053 | 27 | 0 |
535343 | 535343 | 2020-09-15 | Finney | Kansas | 20055 | 1969 | 12 |
535344 | 535344 | 2020-09-15 | Ford | Kansas | 20057 | 2534 | 10 |
535345 | 535345 | 2020-09-15 | Franklin | Kansas | 20059 | 286 | 3 |
535346 | 535346 | 2020-09-15 | Geary | Kansas | 20061 | 372 | 2 |
535347 | 535347 | 2020-09-15 | Gove | Kansas | 20063 | 20 | 0 |
535348 | 535348 | 2020-09-15 | Graham | Kansas | 20065 | 32 | 1 |
535349 | 535349 | 2020-09-15 | Grant | Kansas | 20067 | 202 | 3 |
535350 | 535350 | 2020-09-15 | Gray | Kansas | 20069 | 103 | 0 |
535351 | 535351 | 2020-09-15 | Greeley | Kansas | 20071 | 6 | 0 |
535352 | 535352 | 2020-09-15 | Greenwood | Kansas | 20073 | 45 | 0 |
535353 | 535353 | 2020-09-15 | Hamilton | Kansas | 20075 | 44 | 0 |
535354 | 535354 | 2020-09-15 | Harper | Kansas | 20077 | 120 | 2 |
535355 | 535355 | 2020-09-15 | Harvey | Kansas | 20079 | 325 | 5 |
535356 | 535356 | 2020-09-15 | Haskell | Kansas | 20081 | 68 | 0 |
535357 | 535357 | 2020-09-15 | Hodgeman | Kansas | 20083 | 16 | 0 |
535358 | 535358 | 2020-09-15 | Jackson | Kansas | 20085 | 226 | 2 |
535359 | 535359 | 2020-09-15 | Jefferson | Kansas | 20087 | 167 | 1 |
535360 | 535360 | 2020-09-15 | Jewell | Kansas | 20089 | 15 | 1 |
535361 | 535361 | 2020-09-15 | Johnson | Kansas | 20091 | 9687 | 138 |
535362 | 535362 | 2020-09-15 | Kearny | Kansas | 20093 | 80 | 1 |
535363 | 535363 | 2020-09-15 | Kingman | Kansas | 20095 | 63 | 0 |
535364 | 535364 | 2020-09-15 | Kiowa | Kansas | 20097 | 17 | 0 |
535365 | 535365 | 2020-09-15 | Labette | Kansas | 20099 | 212 | 3 |
535366 | 535366 | 2020-09-15 | Lane | Kansas | 20101 | 11 | 0 |
535367 | 535367 | 2020-09-15 | Leavenworth | Kansas | 20103 | 1870 | 9 |
535368 | 535368 | 2020-09-15 | Lincoln | Kansas | 20105 | 11 | 0 |
535369 | 535369 | 2020-09-15 | Linn | Kansas | 20107 | 66 | 0 |
535370 | 535370 | 2020-09-15 | Logan | Kansas | 20109 | 6 | 0 |
535371 | 535371 | 2020-09-15 | Lyon | Kansas | 20111 | 988 | 20 |
535372 | 535372 | 2020-09-15 | Marion | Kansas | 20115 | 85 | 1 |
535373 | 535373 | 2020-09-15 | Marshall | Kansas | 20117 | 18 | 0 |
535374 | 535374 | 2020-09-15 | McPherson | Kansas | 20113 | 247 | 1 |
535375 | 535375 | 2020-09-15 | Meade | Kansas | 20119 | 93 | 1 |
535376 | 535376 | 2020-09-15 | Miami | Kansas | 20121 | 312 | 1 |
535377 | 535377 | 2020-09-15 | Mitchell | Kansas | 20123 | 40 | 0 |
535378 | 535378 | 2020-09-15 | Montgomery | Kansas | 20125 | 333 | 5 |
535379 | 535379 | 2020-09-15 | Morris | Kansas | 20127 | 26 | 0 |
535380 | 535380 | 2020-09-15 | Morton | Kansas | 20129 | 13 | 2 |
535381 | 535381 | 2020-09-15 | Nemaha | Kansas | 20131 | 75 | 1 |
535382 | 535382 | 2020-09-15 | Neosho | Kansas | 20133 | 135 | 0 |
535383 | 535383 | 2020-09-15 | Ness | Kansas | 20135 | 51 | 1 |
535384 | 535384 | 2020-09-15 | Norton | Kansas | 20137 | 26 | 0 |
535385 | 535385 | 2020-09-15 | Osage | Kansas | 20139 | 85 | 0 |
535386 | 535386 | 2020-09-15 | Osborne | Kansas | 20141 | 6 | 0 |
535387 | 535387 | 2020-09-15 | Ottawa | Kansas | 20143 | 48 | 0 |
535388 | 535388 | 2020-09-15 | Pawnee | Kansas | 20145 | 266 | 0 |
535389 | 535389 | 2020-09-15 | Phillips | Kansas | 20147 | 82 | 8 |
535390 | 535390 | 2020-09-15 | Pottawatomie | Kansas | 20149 | 187 | 0 |
535391 | 535391 | 2020-09-15 | Pratt | Kansas | 20151 | 59 | 0 |
535392 | 535392 | 2020-09-15 | Rawlins | Kansas | 20153 | 5 | 0 |
535393 | 535393 | 2020-09-15 | Reno | Kansas | 20155 | 911 | 3 |
535394 | 535394 | 2020-09-15 | Republic | Kansas | 20157 | 40 | 1 |
535395 | 535395 | 2020-09-15 | Rice | Kansas | 20159 | 61 | 1 |
535396 | 535396 | 2020-09-15 | Riley | Kansas | 20161 | 1411 | 8 |
535397 | 535397 | 2020-09-15 | Rooks | Kansas | 20163 | 44 | 0 |
535398 | 535398 | 2020-09-15 | Rush | Kansas | 20165 | 41 | 0 |
535399 | 535399 | 2020-09-15 | Russell | Kansas | 20167 | 68 | 0 |
535400 | 535400 | 2020-09-15 | Saline | Kansas | 20169 | 583 | 9 |
535401 | 535401 | 2020-09-15 | Scott | Kansas | 20171 | 113 | 1 |
535402 | 535402 | 2020-09-15 | Sedgwick | Kansas | 20173 | 8040 | 69 |
535403 | 535403 | 2020-09-15 | Seward | Kansas | 20175 | 1516 | 5 |
535404 | 535404 | 2020-09-15 | Shawnee | Kansas | 20177 | 2496 | 27 |
535405 | 535405 | 2020-09-15 | Sheridan | Kansas | 20179 | 12 | 0 |
535406 | 535406 | 2020-09-15 | Sherman | Kansas | 20181 | 19 | 0 |
535407 | 535407 | 2020-09-15 | Smith | Kansas | 20183 | 6 | 0 |
535408 | 535408 | 2020-09-15 | Stafford | Kansas | 20185 | 49 | 1 |
535409 | 535409 | 2020-09-15 | Stanton | Kansas | 20187 | 48 | 2 |
535410 | 535410 | 2020-09-15 | Stevens | Kansas | 20189 | 102 | 0 |
535411 | 535411 | 2020-09-15 | Sumner | Kansas | 20191 | 167 | 3 |
535412 | 535412 | 2020-09-15 | Thomas | Kansas | 20193 | 99 | 0 |
535413 | 535413 | 2020-09-15 | Trego | Kansas | 20195 | 42 | 3 |
535414 | 535414 | 2020-09-15 | Wabaunsee | Kansas | 20197 | 66 | 1 |
535415 | 535415 | 2020-09-15 | Wallace | Kansas | 20199 | 14 | 0 |
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);