ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2021-01-12" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921332 | 921332 | 2021-01-12 | Allen | Kansas | 20001 | 767 | 1 |
921333 | 921333 | 2021-01-12 | Anderson | Kansas | 20003 | 674 | 0 |
921334 | 921334 | 2021-01-12 | Atchison | Kansas | 20005 | 1332 | 10 |
921335 | 921335 | 2021-01-12 | Barber | Kansas | 20007 | 321 | 2 |
921336 | 921336 | 2021-01-12 | Barton | Kansas | 20009 | 2359 | 21 |
921337 | 921337 | 2021-01-12 | Bourbon | Kansas | 20011 | 1081 | 3 |
921338 | 921338 | 2021-01-12 | Brown | Kansas | 20013 | 1117 | 29 |
921339 | 921339 | 2021-01-12 | Butler | Kansas | 20015 | 6077 | 42 |
921340 | 921340 | 2021-01-12 | Chase | Kansas | 20017 | 253 | 3 |
921341 | 921341 | 2021-01-12 | Chautauqua | Kansas | 20019 | 211 | 3 |
921342 | 921342 | 2021-01-12 | Cherokee | Kansas | 20021 | 1959 | 16 |
921343 | 921343 | 2021-01-12 | Cheyenne | Kansas | 20023 | 321 | 10 |
921344 | 921344 | 2021-01-12 | Clark | Kansas | 20025 | 207 | 4 |
921345 | 921345 | 2021-01-12 | Clay | Kansas | 20027 | 680 | 17 |
921346 | 921346 | 2021-01-12 | Cloud | Kansas | 20029 | 893 | 2 |
921347 | 921347 | 2021-01-12 | Coffey | Kansas | 20031 | 558 | 11 |
921348 | 921348 | 2021-01-12 | Comanche | Kansas | 20033 | 153 | 8 |
921349 | 921349 | 2021-01-12 | Cowley | Kansas | 20035 | 2962 | 9 |
921350 | 921350 | 2021-01-12 | Crawford | Kansas | 20037 | 3797 | 35 |
921351 | 921351 | 2021-01-12 | Decatur | Kansas | 20039 | 237 | 1 |
921352 | 921352 | 2021-01-12 | Dickinson | Kansas | 20041 | 1393 | 26 |
921353 | 921353 | 2021-01-12 | Doniphan | Kansas | 20043 | 810 | 7 |
921354 | 921354 | 2021-01-12 | Douglas | Kansas | 20045 | 7287 | 36 |
921355 | 921355 | 2021-01-12 | Edwards | Kansas | 20047 | 255 | 0 |
921356 | 921356 | 2021-01-12 | Elk | Kansas | 20049 | 136 | 0 |
921357 | 921357 | 2021-01-12 | Ellis | Kansas | 20051 | 3323 | 44 |
921358 | 921358 | 2021-01-12 | Ellsworth | Kansas | 20053 | 1115 | 4 |
921359 | 921359 | 2021-01-12 | Finney | Kansas | 20055 | 5714 | 42 |
921360 | 921360 | 2021-01-12 | Ford | Kansas | 20057 | 5337 | 10 |
921361 | 921361 | 2021-01-12 | Franklin | Kansas | 20059 | 2038 | 19 |
921362 | 921362 | 2021-01-12 | Geary | Kansas | 20061 | 2099 | 17 |
921363 | 921363 | 2021-01-12 | Gove | Kansas | 20063 | 342 | 22 |
921364 | 921364 | 2021-01-12 | Graham | Kansas | 20065 | 219 | 2 |
921365 | 921365 | 2021-01-12 | Grant | Kansas | 20067 | 933 | 15 |
921366 | 921366 | 2021-01-12 | Gray | Kansas | 20069 | 553 | 7 |
921367 | 921367 | 2021-01-12 | Greeley | Kansas | 20071 | 98 | 0 |
921368 | 921368 | 2021-01-12 | Greenwood | Kansas | 20073 | 526 | 2 |
921369 | 921369 | 2021-01-12 | Hamilton | Kansas | 20075 | 194 | 0 |
921370 | 921370 | 2021-01-12 | Harper | Kansas | 20077 | 490 | 16 |
921371 | 921371 | 2021-01-12 | Harvey | Kansas | 20079 | 3041 | 30 |
921372 | 921372 | 2021-01-12 | Haskell | Kansas | 20081 | 383 | 1 |
921373 | 921373 | 2021-01-12 | Hodgeman | Kansas | 20083 | 167 | 4 |
921374 | 921374 | 2021-01-12 | Jackson | Kansas | 20085 | 1160 | 10 |
921375 | 921375 | 2021-01-12 | Jefferson | Kansas | 20087 | 1345 | 22 |
921376 | 921376 | 2021-01-12 | Jewell | Kansas | 20089 | 180 | 3 |
921377 | 921377 | 2021-01-12 | Johnson | Kansas | 20091 | 43450 | 509 |
921378 | 921378 | 2021-01-12 | Kearny | Kansas | 20093 | 520 | 9 |
921379 | 921379 | 2021-01-12 | Kingman | Kansas | 20095 | 600 | 9 |
921380 | 921380 | 2021-01-12 | Kiowa | Kansas | 20097 | 222 | 3 |
921381 | 921381 | 2021-01-12 | Labette | Kansas | 20099 | 2212 | 17 |
921382 | 921382 | 2021-01-12 | Lane | Kansas | 20101 | 133 | 5 |
921383 | 921383 | 2021-01-12 | Leavenworth | Kansas | 20103 | 5512 | 42 |
921384 | 921384 | 2021-01-12 | Lincoln | Kansas | 20105 | 235 | 2 |
921385 | 921385 | 2021-01-12 | Linn | Kansas | 20107 | 648 | 4 |
921386 | 921386 | 2021-01-12 | Logan | Kansas | 20109 | 279 | 0 |
921387 | 921387 | 2021-01-12 | Lyon | Kansas | 20111 | 3610 | 66 |
921388 | 921388 | 2021-01-12 | Marion | Kansas | 20115 | 795 | 5 |
921389 | 921389 | 2021-01-12 | Marshall | Kansas | 20117 | 930 | 22 |
921390 | 921390 | 2021-01-12 | McPherson | Kansas | 20113 | 2617 | 31 |
921391 | 921391 | 2021-01-12 | Meade | Kansas | 20119 | 425 | 4 |
921392 | 921392 | 2021-01-12 | Miami | Kansas | 20121 | 2133 | 15 |
921393 | 921393 | 2021-01-12 | Mitchell | Kansas | 20123 | 491 | 0 |
921394 | 921394 | 2021-01-12 | Montgomery | Kansas | 20125 | 2607 | 6 |
921395 | 921395 | 2021-01-12 | Morris | Kansas | 20127 | 439 | 6 |
921396 | 921396 | 2021-01-12 | Morton | Kansas | 20129 | 212 | 8 |
921397 | 921397 | 2021-01-12 | Nemaha | Kansas | 20131 | 1388 | 50 |
921398 | 921398 | 2021-01-12 | Neosho | Kansas | 20133 | 1436 | 16 |
921399 | 921399 | 2021-01-12 | Ness | Kansas | 20135 | 327 | 15 |
921400 | 921400 | 2021-01-12 | Norton | Kansas | 20137 | 1192 | 25 |
921401 | 921401 | 2021-01-12 | Osage | Kansas | 20139 | 969 | 8 |
921402 | 921402 | 2021-01-12 | Osborne | Kansas | 20141 | 240 | 0 |
921403 | 921403 | 2021-01-12 | Ottawa | Kansas | 20143 | 458 | 0 |
921404 | 921404 | 2021-01-12 | Pawnee | Kansas | 20145 | 1045 | 8 |
921405 | 921405 | 2021-01-12 | Phillips | Kansas | 20147 | 613 | 15 |
921406 | 921406 | 2021-01-12 | Pottawatomie | Kansas | 20149 | 1279 | 6 |
921407 | 921407 | 2021-01-12 | Pratt | Kansas | 20151 | 735 | 21 |
921408 | 921408 | 2021-01-12 | Rawlins | Kansas | 20153 | 329 | 7 |
921409 | 921409 | 2021-01-12 | Reno | Kansas | 20155 | 7442 | 110 |
921410 | 921410 | 2021-01-12 | Republic | Kansas | 20157 | 627 | 11 |
921411 | 921411 | 2021-01-12 | Rice | Kansas | 20159 | 901 | 1 |
921412 | 921412 | 2021-01-12 | Riley | Kansas | 20161 | 5384 | 22 |
921413 | 921413 | 2021-01-12 | Rooks | Kansas | 20163 | 569 | 9 |
921414 | 921414 | 2021-01-12 | Rush | Kansas | 20165 | 370 | 0 |
921415 | 921415 | 2021-01-12 | Russell | Kansas | 20167 | 776 | 21 |
921416 | 921416 | 2021-01-12 | Saline | Kansas | 20169 | 4998 | 78 |
921417 | 921417 | 2021-01-12 | Scott | Kansas | 20171 | 565 | 16 |
921418 | 921418 | 2021-01-12 | Sedgwick | Kansas | 20173 | 44604 | 329 |
921419 | 921419 | 2021-01-12 | Seward | Kansas | 20175 | 3661 | 28 |
921420 | 921420 | 2021-01-12 | Shawnee | Kansas | 20177 | 13410 | 248 |
921421 | 921421 | 2021-01-12 | Sheridan | Kansas | 20179 | 399 | 0 |
921422 | 921422 | 2021-01-12 | Sherman | Kansas | 20181 | 555 | 7 |
921423 | 921423 | 2021-01-12 | Smith | Kansas | 20183 | 243 | 1 |
921424 | 921424 | 2021-01-12 | Stafford | Kansas | 20185 | 308 | 9 |
921425 | 921425 | 2021-01-12 | Stanton | Kansas | 20187 | 165 | 2 |
921426 | 921426 | 2021-01-12 | Stevens | Kansas | 20189 | 548 | 6 |
921427 | 921427 | 2021-01-12 | Sumner | Kansas | 20191 | 1572 | 27 |
921428 | 921428 | 2021-01-12 | Thomas | Kansas | 20193 | 990 | 8 |
921429 | 921429 | 2021-01-12 | Trego | Kansas | 20195 | 346 | 3 |
921430 | 921430 | 2021-01-12 | Unknown | Kansas | 0 | 584 | |
921431 | 921431 | 2021-01-12 | Wabaunsee | Kansas | 20197 | 517 | 10 |
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);