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-12-19 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 |
---|---|---|---|---|---|---|---|
843446 | 843446 | 2020-12-19 | Allen | Kansas | 20001 | 542 | 1 |
843447 | 843447 | 2020-12-19 | Anderson | Kansas | 20003 | 469 | 0 |
843448 | 843448 | 2020-12-19 | Atchison | Kansas | 20005 | 1144 | 10 |
843449 | 843449 | 2020-12-19 | Barber | Kansas | 20007 | 253 | 2 |
843450 | 843450 | 2020-12-19 | Barton | Kansas | 20009 | 2037 | 19 |
843451 | 843451 | 2020-12-19 | Bourbon | Kansas | 20011 | 799 | 3 |
843452 | 843452 | 2020-12-19 | Brown | Kansas | 20013 | 955 | 18 |
843453 | 843453 | 2020-12-19 | Butler | Kansas | 20015 | 4646 | 18 |
843454 | 843454 | 2020-12-19 | Chase | Kansas | 20017 | 215 | 3 |
843455 | 843455 | 2020-12-19 | Chautauqua | Kansas | 20019 | 127 | 3 |
843456 | 843456 | 2020-12-19 | Cherokee | Kansas | 20021 | 1530 | 13 |
843457 | 843457 | 2020-12-19 | Cheyenne | Kansas | 20023 | 253 | 10 |
843458 | 843458 | 2020-12-19 | Clark | Kansas | 20025 | 180 | 4 |
843459 | 843459 | 2020-12-19 | Clay | Kansas | 20027 | 533 | 14 |
843460 | 843460 | 2020-12-19 | Cloud | Kansas | 20029 | 798 | 2 |
843461 | 843461 | 2020-12-19 | Coffey | Kansas | 20031 | 449 | 10 |
843462 | 843462 | 2020-12-19 | Comanche | Kansas | 20033 | 134 | 4 |
843463 | 843463 | 2020-12-19 | Cowley | Kansas | 20035 | 2202 | 9 |
843464 | 843464 | 2020-12-19 | Crawford | Kansas | 20037 | 3048 | 26 |
843465 | 843465 | 2020-12-19 | Decatur | Kansas | 20039 | 228 | 1 |
843466 | 843466 | 2020-12-19 | Dickinson | Kansas | 20041 | 1042 | 14 |
843467 | 843467 | 2020-12-19 | Doniphan | Kansas | 20043 | 632 | 5 |
843468 | 843468 | 2020-12-19 | Douglas | Kansas | 20045 | 5859 | 31 |
843469 | 843469 | 2020-12-19 | Edwards | Kansas | 20047 | 227 | 0 |
843470 | 843470 | 2020-12-19 | Elk | Kansas | 20049 | 87 | 0 |
843471 | 843471 | 2020-12-19 | Ellis | Kansas | 20051 | 3066 | 31 |
843472 | 843472 | 2020-12-19 | Ellsworth | Kansas | 20053 | 983 | 4 |
843473 | 843473 | 2020-12-19 | Finney | Kansas | 20055 | 5312 | 34 |
843474 | 843474 | 2020-12-19 | Ford | Kansas | 20057 | 4989 | 10 |
843475 | 843475 | 2020-12-19 | Franklin | Kansas | 20059 | 1486 | 17 |
843476 | 843476 | 2020-12-19 | Geary | Kansas | 20061 | 1528 | 9 |
843477 | 843477 | 2020-12-19 | Gove | Kansas | 20063 | 325 | 20 |
843478 | 843478 | 2020-12-19 | Graham | Kansas | 20065 | 196 | 2 |
843479 | 843479 | 2020-12-19 | Grant | Kansas | 20067 | 892 | 14 |
843480 | 843480 | 2020-12-19 | Gray | Kansas | 20069 | 508 | 7 |
843481 | 843481 | 2020-12-19 | Greeley | Kansas | 20071 | 90 | 0 |
843482 | 843482 | 2020-12-19 | Greenwood | Kansas | 20073 | 375 | 2 |
843483 | 843483 | 2020-12-19 | Hamilton | Kansas | 20075 | 177 | 0 |
843484 | 843484 | 2020-12-19 | Harper | Kansas | 20077 | 391 | 15 |
843485 | 843485 | 2020-12-19 | Harvey | Kansas | 20079 | 2316 | 23 |
843486 | 843486 | 2020-12-19 | Haskell | Kansas | 20081 | 345 | 1 |
843487 | 843487 | 2020-12-19 | Hodgeman | Kansas | 20083 | 157 | 4 |
843488 | 843488 | 2020-12-19 | Jackson | Kansas | 20085 | 962 | 10 |
843489 | 843489 | 2020-12-19 | Jefferson | Kansas | 20087 | 1017 | 9 |
843490 | 843490 | 2020-12-19 | Jewell | Kansas | 20089 | 178 | 2 |
843491 | 843491 | 2020-12-19 | Johnson | Kansas | 20091 | 35086 | 385 |
843492 | 843492 | 2020-12-19 | Kearny | Kansas | 20093 | 465 | 8 |
843493 | 843493 | 2020-12-19 | Kingman | Kansas | 20095 | 519 | 7 |
843494 | 843494 | 2020-12-19 | Kiowa | Kansas | 20097 | 178 | 0 |
843495 | 843495 | 2020-12-19 | Labette | Kansas | 20099 | 1501 | 7 |
843496 | 843496 | 2020-12-19 | Lane | Kansas | 20101 | 117 | 4 |
843497 | 843497 | 2020-12-19 | Leavenworth | Kansas | 20103 | 4698 | 36 |
843498 | 843498 | 2020-12-19 | Lincoln | Kansas | 20105 | 174 | 1 |
843499 | 843499 | 2020-12-19 | Linn | Kansas | 20107 | 438 | 4 |
843500 | 843500 | 2020-12-19 | Logan | Kansas | 20109 | 265 | 0 |
843501 | 843501 | 2020-12-19 | Lyon | Kansas | 20111 | 3168 | 55 |
843502 | 843502 | 2020-12-19 | Marion | Kansas | 20115 | 607 | 4 |
843503 | 843503 | 2020-12-19 | Marshall | Kansas | 20117 | 781 | 21 |
843504 | 843504 | 2020-12-19 | McPherson | Kansas | 20113 | 2187 | 22 |
843505 | 843505 | 2020-12-19 | Meade | Kansas | 20119 | 365 | 4 |
843506 | 843506 | 2020-12-19 | Miami | Kansas | 20121 | 1514 | 7 |
843507 | 843507 | 2020-12-19 | Mitchell | Kansas | 20123 | 337 | 0 |
843508 | 843508 | 2020-12-19 | Montgomery | Kansas | 20125 | 1782 | 6 |
843509 | 843509 | 2020-12-19 | Morris | Kansas | 20127 | 339 | 2 |
843510 | 843510 | 2020-12-19 | Morton | Kansas | 20129 | 195 | 8 |
843511 | 843511 | 2020-12-19 | Nemaha | Kansas | 20131 | 1285 | 43 |
843512 | 843512 | 2020-12-19 | Neosho | Kansas | 20133 | 997 | 8 |
843513 | 843513 | 2020-12-19 | Ness | Kansas | 20135 | 323 | 15 |
843514 | 843514 | 2020-12-19 | Norton | Kansas | 20137 | 1151 | 24 |
843515 | 843515 | 2020-12-19 | Osage | Kansas | 20139 | 729 | 6 |
843516 | 843516 | 2020-12-19 | Osborne | Kansas | 20141 | 135 | 0 |
843517 | 843517 | 2020-12-19 | Ottawa | Kansas | 20143 | 371 | 0 |
843518 | 843518 | 2020-12-19 | Pawnee | Kansas | 20145 | 888 | 1 |
843519 | 843519 | 2020-12-19 | Phillips | Kansas | 20147 | 549 | 12 |
843520 | 843520 | 2020-12-19 | Pottawatomie | Kansas | 20149 | 908 | 3 |
843521 | 843521 | 2020-12-19 | Pratt | Kansas | 20151 | 638 | 17 |
843522 | 843522 | 2020-12-19 | Rawlins | Kansas | 20153 | 285 | 3 |
843523 | 843523 | 2020-12-19 | Reno | Kansas | 20155 | 6538 | 86 |
843524 | 843524 | 2020-12-19 | Republic | Kansas | 20157 | 509 | 9 |
843525 | 843525 | 2020-12-19 | Rice | Kansas | 20159 | 685 | 1 |
843526 | 843526 | 2020-12-19 | Riley | Kansas | 20161 | 4494 | 19 |
843527 | 843527 | 2020-12-19 | Rooks | Kansas | 20163 | 446 | 9 |
843528 | 843528 | 2020-12-19 | Rush | Kansas | 20165 | 323 | 0 |
843529 | 843529 | 2020-12-19 | Russell | Kansas | 20167 | 696 | 17 |
843530 | 843530 | 2020-12-19 | Saline | Kansas | 20169 | 3718 | 46 |
843531 | 843531 | 2020-12-19 | Scott | Kansas | 20171 | 535 | 9 |
843532 | 843532 | 2020-12-19 | Sedgwick | Kansas | 20173 | 35106 | 236 |
843533 | 843533 | 2020-12-19 | Seward | Kansas | 20175 | 3417 | 16 |
843534 | 843534 | 2020-12-19 | Shawnee | Kansas | 20177 | 10393 | 190 |
843535 | 843535 | 2020-12-19 | Sheridan | Kansas | 20179 | 360 | 0 |
843536 | 843536 | 2020-12-19 | Sherman | Kansas | 20181 | 527 | 7 |
843537 | 843537 | 2020-12-19 | Smith | Kansas | 20183 | 193 | 1 |
843538 | 843538 | 2020-12-19 | Stafford | Kansas | 20185 | 256 | 7 |
843539 | 843539 | 2020-12-19 | Stanton | Kansas | 20187 | 157 | 2 |
843540 | 843540 | 2020-12-19 | Stevens | Kansas | 20189 | 489 | 5 |
843541 | 843541 | 2020-12-19 | Sumner | Kansas | 20191 | 1176 | 12 |
843542 | 843542 | 2020-12-19 | Thomas | Kansas | 20193 | 863 | 6 |
843543 | 843543 | 2020-12-19 | Trego | Kansas | 20195 | 275 | 3 |
843544 | 843544 | 2020-12-19 | Unknown | Kansas | 0 | 309 | |
843545 | 843545 | 2020-12-19 | Wabaunsee | Kansas | 20197 | 369 | 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);