ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where date = "2020-08-07" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
409349 | 409349 | 2020-08-07 | Allen | Kansas | 20001 | 17 | 0 |
409350 | 409350 | 2020-08-07 | Anderson | Kansas | 20003 | 29 | 0 |
409351 | 409351 | 2020-08-07 | Atchison | Kansas | 20005 | 62 | 0 |
409352 | 409352 | 2020-08-07 | Barber | Kansas | 20007 | 4 | 0 |
409353 | 409353 | 2020-08-07 | Barton | Kansas | 20009 | 133 | 3 |
409354 | 409354 | 2020-08-07 | Bourbon | Kansas | 20011 | 77 | 2 |
409355 | 409355 | 2020-08-07 | Brown | Kansas | 20013 | 42 | 0 |
409356 | 409356 | 2020-08-07 | Butler | Kansas | 20015 | 278 | 1 |
409357 | 409357 | 2020-08-07 | Chase | Kansas | 20017 | 41 | 0 |
409358 | 409358 | 2020-08-07 | Chautauqua | Kansas | 20019 | 5 | 0 |
409359 | 409359 | 2020-08-07 | Cherokee | Kansas | 20021 | 109 | 1 |
409360 | 409360 | 2020-08-07 | Cheyenne | Kansas | 20023 | 3 | 0 |
409361 | 409361 | 2020-08-07 | Clark | Kansas | 20025 | 45 | 1 |
409362 | 409362 | 2020-08-07 | Clay | Kansas | 20027 | 21 | 2 |
409363 | 409363 | 2020-08-07 | Cloud | Kansas | 20029 | 32 | 0 |
409364 | 409364 | 2020-08-07 | Coffey | Kansas | 20031 | 69 | 8 |
409365 | 409365 | 2020-08-07 | Comanche | Kansas | 20033 | 5 | 0 |
409366 | 409366 | 2020-08-07 | Cowley | Kansas | 20035 | 165 | 2 |
409367 | 409367 | 2020-08-07 | Crawford | Kansas | 20037 | 395 | 1 |
409368 | 409368 | 2020-08-07 | Decatur | Kansas | 20039 | 6 | 0 |
409369 | 409369 | 2020-08-07 | Dickinson | Kansas | 20041 | 42 | 1 |
409370 | 409370 | 2020-08-07 | Doniphan | Kansas | 20043 | 45 | 0 |
409371 | 409371 | 2020-08-07 | Douglas | Kansas | 20045 | 717 | 5 |
409372 | 409372 | 2020-08-07 | Edwards | Kansas | 20047 | 11 | 0 |
409373 | 409373 | 2020-08-07 | Elk | Kansas | 20049 | 1 | 0 |
409374 | 409374 | 2020-08-07 | Ellis | Kansas | 20051 | 144 | 1 |
409375 | 409375 | 2020-08-07 | Ellsworth | Kansas | 20053 | 21 | 0 |
409376 | 409376 | 2020-08-07 | Finney | Kansas | 20055 | 1783 | 10 |
409377 | 409377 | 2020-08-07 | Ford | Kansas | 20057 | 2161 | 10 |
409378 | 409378 | 2020-08-07 | Franklin | Kansas | 20059 | 183 | 1 |
409379 | 409379 | 2020-08-07 | Geary | Kansas | 20061 | 193 | 1 |
409380 | 409380 | 2020-08-07 | Gove | Kansas | 20063 | 3 | 0 |
409381 | 409381 | 2020-08-07 | Graham | Kansas | 20065 | 17 | 0 |
409382 | 409382 | 2020-08-07 | Grant | Kansas | 20067 | 110 | 2 |
409383 | 409383 | 2020-08-07 | Gray | Kansas | 20069 | 73 | 0 |
409384 | 409384 | 2020-08-07 | Greeley | Kansas | 20071 | 4 | 0 |
409385 | 409385 | 2020-08-07 | Greenwood | Kansas | 20073 | 20 | 0 |
409386 | 409386 | 2020-08-07 | Hamilton | Kansas | 20075 | 41 | 0 |
409387 | 409387 | 2020-08-07 | Harper | Kansas | 20077 | 11 | 0 |
409388 | 409388 | 2020-08-07 | Harvey | Kansas | 20079 | 200 | 3 |
409389 | 409389 | 2020-08-07 | Haskell | Kansas | 20081 | 44 | 0 |
409390 | 409390 | 2020-08-07 | Hodgeman | Kansas | 20083 | 11 | 0 |
409391 | 409391 | 2020-08-07 | Jackson | Kansas | 20085 | 146 | 1 |
409392 | 409392 | 2020-08-07 | Jefferson | Kansas | 20087 | 80 | 0 |
409393 | 409393 | 2020-08-07 | Jewell | Kansas | 20089 | 11 | 0 |
409394 | 409394 | 2020-08-07 | Johnson | Kansas | 20091 | 5637 | 102 |
409395 | 409395 | 2020-08-07 | Kearny | Kansas | 20093 | 59 | 1 |
409396 | 409396 | 2020-08-07 | Kingman | Kansas | 20095 | 17 | 0 |
409397 | 409397 | 2020-08-07 | Kiowa | Kansas | 20097 | 7 | 0 |
409398 | 409398 | 2020-08-07 | Labette | Kansas | 20099 | 133 | 0 |
409399 | 409399 | 2020-08-07 | Lane | Kansas | 20101 | 5 | 0 |
409400 | 409400 | 2020-08-07 | Leavenworth | Kansas | 20103 | 1487 | 8 |
409401 | 409401 | 2020-08-07 | Lincoln | Kansas | 20105 | 6 | 0 |
409402 | 409402 | 2020-08-07 | Linn | Kansas | 20107 | 39 | 0 |
409403 | 409403 | 2020-08-07 | Logan | Kansas | 20109 | 2 | 0 |
409404 | 409404 | 2020-08-07 | Lyon | Kansas | 20111 | 697 | 13 |
409405 | 409405 | 2020-08-07 | Marion | Kansas | 20115 | 58 | 1 |
409406 | 409406 | 2020-08-07 | Marshall | Kansas | 20117 | 9 | 0 |
409407 | 409407 | 2020-08-07 | McPherson | Kansas | 20113 | 154 | 1 |
409408 | 409408 | 2020-08-07 | Meade | Kansas | 20119 | 57 | 0 |
409409 | 409409 | 2020-08-07 | Miami | Kansas | 20121 | 136 | 0 |
409410 | 409410 | 2020-08-07 | Mitchell | Kansas | 20123 | 27 | 0 |
409411 | 409411 | 2020-08-07 | Montgomery | Kansas | 20125 | 166 | 5 |
409412 | 409412 | 2020-08-07 | Morris | Kansas | 20127 | 11 | 0 |
409413 | 409413 | 2020-08-07 | Morton | Kansas | 20129 | 9 | 2 |
409414 | 409414 | 2020-08-07 | Nemaha | Kansas | 20131 | 48 | 0 |
409415 | 409415 | 2020-08-07 | Neosho | Kansas | 20133 | 62 | 0 |
409416 | 409416 | 2020-08-07 | Ness | Kansas | 20135 | 7 | 0 |
409417 | 409417 | 2020-08-07 | Norton | Kansas | 20137 | 22 | 0 |
409418 | 409418 | 2020-08-07 | Osage | Kansas | 20139 | 41 | 0 |
409419 | 409419 | 2020-08-07 | Osborne | Kansas | 20141 | 4 | 0 |
409420 | 409420 | 2020-08-07 | Ottawa | Kansas | 20143 | 34 | 0 |
409421 | 409421 | 2020-08-07 | Pawnee | Kansas | 20145 | 8 | 0 |
409422 | 409422 | 2020-08-07 | Phillips | Kansas | 20147 | 48 | 8 |
409423 | 409423 | 2020-08-07 | Pottawatomie | Kansas | 20149 | 114 | 0 |
409424 | 409424 | 2020-08-07 | Pratt | Kansas | 20151 | 33 | 0 |
409425 | 409425 | 2020-08-07 | Reno | Kansas | 20155 | 269 | 1 |
409426 | 409426 | 2020-08-07 | Republic | Kansas | 20157 | 31 | 0 |
409427 | 409427 | 2020-08-07 | Rice | Kansas | 20159 | 35 | 0 |
409428 | 409428 | 2020-08-07 | Riley | Kansas | 20161 | 477 | 5 |
409429 | 409429 | 2020-08-07 | Rooks | Kansas | 20163 | 18 | 0 |
409430 | 409430 | 2020-08-07 | Rush | Kansas | 20165 | 9 | 0 |
409431 | 409431 | 2020-08-07 | Russell | Kansas | 20167 | 16 | 0 |
409432 | 409432 | 2020-08-07 | Saline | Kansas | 20169 | 377 | 5 |
409433 | 409433 | 2020-08-07 | Scott | Kansas | 20171 | 32 | 0 |
409434 | 409434 | 2020-08-07 | Sedgwick | Kansas | 20173 | 4935 | 44 |
409435 | 409435 | 2020-08-07 | Seward | Kansas | 20175 | 1220 | 4 |
409436 | 409436 | 2020-08-07 | Shawnee | Kansas | 20177 | 1522 | 19 |
409437 | 409437 | 2020-08-07 | Sheridan | Kansas | 20179 | 7 | 0 |
409438 | 409438 | 2020-08-07 | Sherman | Kansas | 20181 | 15 | 0 |
409439 | 409439 | 2020-08-07 | Smith | Kansas | 20183 | 3 | 0 |
409440 | 409440 | 2020-08-07 | Stafford | Kansas | 20185 | 3 | 0 |
409441 | 409441 | 2020-08-07 | Stanton | Kansas | 20187 | 35 | 0 |
409442 | 409442 | 2020-08-07 | Stevens | Kansas | 20189 | 46 | 0 |
409443 | 409443 | 2020-08-07 | Sumner | Kansas | 20191 | 99 | 3 |
409444 | 409444 | 2020-08-07 | Thomas | Kansas | 20193 | 35 | 0 |
409445 | 409445 | 2020-08-07 | Trego | Kansas | 20195 | 6 | 0 |
409446 | 409446 | 2020-08-07 | Unknown | Kansas | 0 | 3 | |
409447 | 409447 | 2020-08-07 | Wabaunsee | Kansas | 20197 | 42 | 0 |
409448 | 409448 | 2020-08-07 | Washington | Kansas | 20201 | 2 | 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);