ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where "date" is on date 2020-11-16 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
736343 | 736343 | 2020-11-16 | Allen | Kansas | 20001 | 256 | 1 |
736344 | 736344 | 2020-11-16 | Anderson | Kansas | 20003 | 323 | 0 |
736345 | 736345 | 2020-11-16 | Atchison | Kansas | 20005 | 712 | 9 |
736346 | 736346 | 2020-11-16 | Barber | Kansas | 20007 | 158 | 0 |
736347 | 736347 | 2020-11-16 | Barton | Kansas | 20009 | 1285 | 12 |
736348 | 736348 | 2020-11-16 | Bourbon | Kansas | 20011 | 395 | 3 |
736349 | 736349 | 2020-11-16 | Brown | Kansas | 20013 | 506 | 6 |
736350 | 736350 | 2020-11-16 | Butler | Kansas | 20015 | 2535 | 5 |
736351 | 736351 | 2020-11-16 | Chase | Kansas | 20017 | 139 | 3 |
736352 | 736352 | 2020-11-16 | Chautauqua | Kansas | 20019 | 45 | 0 |
736353 | 736353 | 2020-11-16 | Cherokee | Kansas | 20021 | 931 | 9 |
736354 | 736354 | 2020-11-16 | Cheyenne | Kansas | 20023 | 183 | 7 |
736355 | 736355 | 2020-11-16 | Clark | Kansas | 20025 | 91 | 4 |
736356 | 736356 | 2020-11-16 | Clay | Kansas | 20027 | 298 | 8 |
736357 | 736357 | 2020-11-16 | Cloud | Kansas | 20029 | 439 | 1 |
736358 | 736358 | 2020-11-16 | Coffey | Kansas | 20031 | 251 | 9 |
736359 | 736359 | 2020-11-16 | Comanche | Kansas | 20033 | 31 | 0 |
736360 | 736360 | 2020-11-16 | Cowley | Kansas | 20035 | 1104 | 9 |
736361 | 736361 | 2020-11-16 | Crawford | Kansas | 20037 | 1944 | 14 |
736362 | 736362 | 2020-11-16 | Decatur | Kansas | 20039 | 188 | 1 |
736363 | 736363 | 2020-11-16 | Dickinson | Kansas | 20041 | 596 | 5 |
736364 | 736364 | 2020-11-16 | Doniphan | Kansas | 20043 | 344 | 2 |
736365 | 736365 | 2020-11-16 | Douglas | Kansas | 20045 | 3909 | 20 |
736366 | 736366 | 2020-11-16 | Edwards | Kansas | 20047 | 123 | 0 |
736367 | 736367 | 2020-11-16 | Elk | Kansas | 20049 | 33 | 0 |
736368 | 736368 | 2020-11-16 | Ellis | Kansas | 20051 | 1908 | 20 |
736369 | 736369 | 2020-11-16 | Ellsworth | Kansas | 20053 | 502 | 3 |
736370 | 736370 | 2020-11-16 | Finney | Kansas | 20055 | 3972 | 23 |
736371 | 736371 | 2020-11-16 | Ford | Kansas | 20057 | 4225 | 10 |
736372 | 736372 | 2020-11-16 | Franklin | Kansas | 20059 | 887 | 13 |
736373 | 736373 | 2020-11-16 | Geary | Kansas | 20061 | 726 | 4 |
736374 | 736374 | 2020-11-16 | Gove | Kansas | 20063 | 251 | 19 |
736375 | 736375 | 2020-11-16 | Graham | Kansas | 20065 | 118 | 2 |
736376 | 736376 | 2020-11-16 | Grant | Kansas | 20067 | 616 | 10 |
736377 | 736377 | 2020-11-16 | Gray | Kansas | 20069 | 313 | 4 |
736378 | 736378 | 2020-11-16 | Greeley | Kansas | 20071 | 69 | 0 |
736379 | 736379 | 2020-11-16 | Greenwood | Kansas | 20073 | 161 | 0 |
736380 | 736380 | 2020-11-16 | Hamilton | Kansas | 20075 | 101 | 0 |
736381 | 736381 | 2020-11-16 | Harper | Kansas | 20077 | 233 | 4 |
736382 | 736382 | 2020-11-16 | Harvey | Kansas | 20079 | 1373 | 9 |
736383 | 736383 | 2020-11-16 | Haskell | Kansas | 20081 | 223 | 1 |
736384 | 736384 | 2020-11-16 | Hodgeman | Kansas | 20083 | 112 | 0 |
736385 | 736385 | 2020-11-16 | Jackson | Kansas | 20085 | 515 | 4 |
736386 | 736386 | 2020-11-16 | Jefferson | Kansas | 20087 | 525 | 6 |
736387 | 736387 | 2020-11-16 | Jewell | Kansas | 20089 | 40 | 1 |
736388 | 736388 | 2020-11-16 | Johnson | Kansas | 20091 | 21981 | 248 |
736389 | 736389 | 2020-11-16 | Kearny | Kansas | 20093 | 244 | 8 |
736390 | 736390 | 2020-11-16 | Kingman | Kansas | 20095 | 254 | 3 |
736391 | 736391 | 2020-11-16 | Kiowa | Kansas | 20097 | 89 | 0 |
736392 | 736392 | 2020-11-16 | Labette | Kansas | 20099 | 672 | 6 |
736393 | 736393 | 2020-11-16 | Lane | Kansas | 20101 | 60 | 1 |
736394 | 736394 | 2020-11-16 | Leavenworth | Kansas | 20103 | 3208 | 25 |
736395 | 736395 | 2020-11-16 | Lincoln | Kansas | 20105 | 39 | 1 |
736396 | 736396 | 2020-11-16 | Linn | Kansas | 20107 | 217 | 1 |
736397 | 736397 | 2020-11-16 | Logan | Kansas | 20109 | 193 | 0 |
736398 | 736398 | 2020-11-16 | Lyon | Kansas | 20111 | 1977 | 41 |
736399 | 736399 | 2020-11-16 | Marion | Kansas | 20115 | 350 | 1 |
736400 | 736400 | 2020-11-16 | Marshall | Kansas | 20117 | 290 | 0 |
736401 | 736401 | 2020-11-16 | McPherson | Kansas | 20113 | 993 | 8 |
736402 | 736402 | 2020-11-16 | Meade | Kansas | 20119 | 229 | 2 |
736403 | 736403 | 2020-11-16 | Miami | Kansas | 20121 | 786 | 2 |
736404 | 736404 | 2020-11-16 | Mitchell | Kansas | 20123 | 108 | 0 |
736405 | 736405 | 2020-11-16 | Montgomery | Kansas | 20125 | 879 | 6 |
736406 | 736406 | 2020-11-16 | Morris | Kansas | 20127 | 140 | 1 |
736407 | 736407 | 2020-11-16 | Morton | Kansas | 20129 | 105 | 3 |
736408 | 736408 | 2020-11-16 | Nemaha | Kansas | 20131 | 767 | 5 |
736409 | 736409 | 2020-11-16 | Neosho | Kansas | 20133 | 521 | 0 |
736410 | 736410 | 2020-11-16 | Ness | Kansas | 20135 | 204 | 10 |
736411 | 736411 | 2020-11-16 | Norton | Kansas | 20137 | 995 | 21 |
736412 | 736412 | 2020-11-16 | Osage | Kansas | 20139 | 361 | 5 |
736413 | 736413 | 2020-11-16 | Osborne | Kansas | 20141 | 48 | 0 |
736414 | 736414 | 2020-11-16 | Ottawa | Kansas | 20143 | 169 | 0 |
736415 | 736415 | 2020-11-16 | Pawnee | Kansas | 20145 | 528 | 1 |
736416 | 736416 | 2020-11-16 | Phillips | Kansas | 20147 | 323 | 9 |
736417 | 736417 | 2020-11-16 | Pottawatomie | Kansas | 20149 | 574 | 0 |
736418 | 736418 | 2020-11-16 | Pratt | Kansas | 20151 | 390 | 1 |
736419 | 736419 | 2020-11-16 | Rawlins | Kansas | 20153 | 199 | 2 |
736420 | 736420 | 2020-11-16 | Reno | Kansas | 20155 | 3682 | 33 |
736421 | 736421 | 2020-11-16 | Republic | Kansas | 20157 | 191 | 1 |
736422 | 736422 | 2020-11-16 | Rice | Kansas | 20159 | 284 | 1 |
736423 | 736423 | 2020-11-16 | Riley | Kansas | 20161 | 2987 | 14 |
736424 | 736424 | 2020-11-16 | Rooks | Kansas | 20163 | 221 | 7 |
736425 | 736425 | 2020-11-16 | Rush | Kansas | 20165 | 156 | 0 |
736426 | 736426 | 2020-11-16 | Russell | Kansas | 20167 | 351 | 7 |
736427 | 736427 | 2020-11-16 | Saline | Kansas | 20169 | 1729 | 17 |
736428 | 736428 | 2020-11-16 | Scott | Kansas | 20171 | 323 | 1 |
736429 | 736429 | 2020-11-16 | Sedgwick | Kansas | 20173 | 21255 | 140 |
736430 | 736430 | 2020-11-16 | Seward | Kansas | 20175 | 2566 | 13 |
736431 | 736431 | 2020-11-16 | Shawnee | Kansas | 20177 | 5792 | 95 |
736432 | 736432 | 2020-11-16 | Sheridan | Kansas | 20179 | 274 | 0 |
736433 | 736433 | 2020-11-16 | Sherman | Kansas | 20181 | 356 | 7 |
736434 | 736434 | 2020-11-16 | Smith | Kansas | 20183 | 86 | 0 |
736435 | 736435 | 2020-11-16 | Stafford | Kansas | 20185 | 156 | 1 |
736436 | 736436 | 2020-11-16 | Stanton | Kansas | 20187 | 121 | 2 |
736437 | 736437 | 2020-11-16 | Stevens | Kansas | 20189 | 364 | 2 |
736438 | 736438 | 2020-11-16 | Sumner | Kansas | 20191 | 600 | 6 |
736439 | 736439 | 2020-11-16 | Thomas | Kansas | 20193 | 536 | 2 |
736440 | 736440 | 2020-11-16 | Trego | Kansas | 20195 | 164 | 3 |
736441 | 736441 | 2020-11-16 | Unknown | Kansas | 0 | 70 | |
736442 | 736442 | 2020-11-16 | Wabaunsee | Kansas | 20197 | 252 | 1 |
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);