ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where "date" is on date 2021-11-12 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1908492 | 1908492 | 2021-11-12 | Allen | Kansas | 20001 | 2028 | 27 |
1908493 | 1908493 | 2021-11-12 | Anderson | Kansas | 20003 | 1152 | 22 |
1908494 | 1908494 | 2021-11-12 | Atchison | Kansas | 20005 | 2472 | 27 |
1908495 | 1908495 | 2021-11-12 | Barber | Kansas | 20007 | 517 | 7 |
1908496 | 1908496 | 2021-11-12 | Barton | Kansas | 20009 | 4117 | 62 |
1908497 | 1908497 | 2021-11-12 | Bourbon | Kansas | 20011 | 2554 | 44 |
1908498 | 1908498 | 2021-11-12 | Brown | Kansas | 20013 | 1724 | 41 |
1908499 | 1908499 | 2021-11-12 | Butler | Kansas | 20015 | 11330 | 139 |
1908500 | 1908500 | 2021-11-12 | Chase | Kansas | 20017 | 381 | 4 |
1908501 | 1908501 | 2021-11-12 | Chautauqua | Kansas | 20019 | 532 | 11 |
1908502 | 1908502 | 2021-11-12 | Cherokee | Kansas | 20021 | 3736 | 79 |
1908503 | 1908503 | 2021-11-12 | Cheyenne | Kansas | 20023 | 457 | 14 |
1908504 | 1908504 | 2021-11-12 | Clark | Kansas | 20025 | 339 | 7 |
1908505 | 1908505 | 2021-11-12 | Clay | Kansas | 20027 | 1279 | 31 |
1908506 | 1908506 | 2021-11-12 | Cloud | Kansas | 20029 | 1501 | 32 |
1908507 | 1908507 | 2021-11-12 | Coffey | Kansas | 20031 | 1278 | 28 |
1908508 | 1908508 | 2021-11-12 | Comanche | Kansas | 20033 | 318 | 13 |
1908509 | 1908509 | 2021-11-12 | Cowley | Kansas | 20035 | 5885 | 127 |
1908510 | 1908510 | 2021-11-12 | Crawford | Kansas | 20037 | 6854 | 113 |
1908511 | 1908511 | 2021-11-12 | Decatur | Kansas | 20039 | 380 | 13 |
1908512 | 1908512 | 2021-11-12 | Dickinson | Kansas | 20041 | 3014 | 62 |
1908513 | 1908513 | 2021-11-12 | Doniphan | Kansas | 20043 | 1447 | 29 |
1908514 | 1908514 | 2021-11-12 | Douglas | Kansas | 20045 | 12800 | 105 |
1908515 | 1908515 | 2021-11-12 | Edwards | Kansas | 20047 | 422 | 13 |
1908516 | 1908516 | 2021-11-12 | Elk | Kansas | 20049 | 324 | 6 |
1908517 | 1908517 | 2021-11-12 | Ellis | Kansas | 20051 | 4692 | 76 |
1908518 | 1908518 | 2021-11-12 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1908519 | 1908519 | 2021-11-12 | Finney | Kansas | 20055 | 7723 | 91 |
1908520 | 1908520 | 2021-11-12 | Ford | Kansas | 20057 | 7297 | 96 |
1908521 | 1908521 | 2021-11-12 | Franklin | Kansas | 20059 | 3923 | 60 |
1908522 | 1908522 | 2021-11-12 | Geary | Kansas | 20061 | 4885 | 58 |
1908523 | 1908523 | 2021-11-12 | Gove | Kansas | 20063 | 504 | 22 |
1908524 | 1908524 | 2021-11-12 | Graham | Kansas | 20065 | 330 | 12 |
1908525 | 1908525 | 2021-11-12 | Grant | Kansas | 20067 | 1353 | 30 |
1908526 | 1908526 | 2021-11-12 | Gray | Kansas | 20069 | 913 | 20 |
1908527 | 1908527 | 2021-11-12 | Greeley | Kansas | 20071 | 170 | 3 |
1908528 | 1908528 | 2021-11-12 | Greenwood | Kansas | 20073 | 1008 | 15 |
1908529 | 1908529 | 2021-11-12 | Hamilton | Kansas | 20075 | 312 | 1 |
1908530 | 1908530 | 2021-11-12 | Harper | Kansas | 20077 | 943 | 24 |
1908531 | 1908531 | 2021-11-12 | Harvey | Kansas | 20079 | 5280 | 91 |
1908532 | 1908532 | 2021-11-12 | Haskell | Kansas | 20081 | 600 | 9 |
1908533 | 1908533 | 2021-11-12 | Hodgeman | Kansas | 20083 | 248 | 10 |
1908534 | 1908534 | 2021-11-12 | Jackson | Kansas | 20085 | 2198 | 20 |
1908535 | 1908535 | 2021-11-12 | Jefferson | Kansas | 20087 | 2675 | 50 |
1908536 | 1908536 | 2021-11-12 | Jewell | Kansas | 20089 | 514 | 11 |
1908537 | 1908537 | 2021-11-12 | Johnson | Kansas | 20091 | 79838 | 952 |
1908538 | 1908538 | 2021-11-12 | Kearny | Kansas | 20093 | 821 | 16 |
1908539 | 1908539 | 2021-11-12 | Kingman | Kansas | 20095 | 1238 | 23 |
1908540 | 1908540 | 2021-11-12 | Kiowa | Kansas | 20097 | 408 | 5 |
1908541 | 1908541 | 2021-11-12 | Labette | Kansas | 20099 | 3755 | 62 |
1908542 | 1908542 | 2021-11-12 | Lane | Kansas | 20101 | 179 | 8 |
1908543 | 1908543 | 2021-11-12 | Leavenworth | Kansas | 20103 | 10694 | 134 |
1908544 | 1908544 | 2021-11-12 | Lincoln | Kansas | 20105 | 380 | 6 |
1908545 | 1908545 | 2021-11-12 | Linn | Kansas | 20107 | 1627 | 21 |
1908546 | 1908546 | 2021-11-12 | Logan | Kansas | 20109 | 471 | 9 |
1908547 | 1908547 | 2021-11-12 | Lyon | Kansas | 20111 | 5647 | 93 |
1908548 | 1908548 | 2021-11-12 | Marion | Kansas | 20115 | 1802 | 35 |
1908549 | 1908549 | 2021-11-12 | Marshall | Kansas | 20117 | 1574 | 32 |
1908550 | 1908550 | 2021-11-12 | McPherson | Kansas | 20113 | 4738 | 98 |
1908551 | 1908551 | 2021-11-12 | Meade | Kansas | 20119 | 732 | 14 |
1908552 | 1908552 | 2021-11-12 | Miami | Kansas | 20121 | 4467 | 67 |
1908553 | 1908553 | 2021-11-12 | Mitchell | Kansas | 20123 | 845 | 17 |
1908554 | 1908554 | 2021-11-12 | Montgomery | Kansas | 20125 | 5452 | 120 |
1908555 | 1908555 | 2021-11-12 | Morris | Kansas | 20127 | 802 | 23 |
1908556 | 1908556 | 2021-11-12 | Morton | Kansas | 20129 | 425 | 9 |
1908557 | 1908557 | 2021-11-12 | Nemaha | Kansas | 20131 | 2040 | 56 |
1908558 | 1908558 | 2021-11-12 | Neosho | Kansas | 20133 | 2742 | 53 |
1908559 | 1908559 | 2021-11-12 | Ness | Kansas | 20135 | 505 | 17 |
1908560 | 1908560 | 2021-11-12 | Norton | Kansas | 20137 | 1516 | 32 |
1908561 | 1908561 | 2021-11-12 | Osage | Kansas | 20139 | 2106 | 39 |
1908562 | 1908562 | 2021-11-12 | Osborne | Kansas | 20141 | 463 | 15 |
1908563 | 1908563 | 2021-11-12 | Ottawa | Kansas | 20143 | 785 | 14 |
1908564 | 1908564 | 2021-11-12 | Pawnee | Kansas | 20145 | 1527 | 19 |
1908565 | 1908565 | 2021-11-12 | Phillips | Kansas | 20147 | 949 | 28 |
1908566 | 1908566 | 2021-11-12 | Pottawatomie | Kansas | 20149 | 2964 | 44 |
1908567 | 1908567 | 2021-11-12 | Pratt | Kansas | 20151 | 1312 | 27 |
1908568 | 1908568 | 2021-11-12 | Rawlins | Kansas | 20153 | 496 | 7 |
1908569 | 1908569 | 2021-11-12 | Reno | Kansas | 20155 | 11830 | 171 |
1908570 | 1908570 | 2021-11-12 | Republic | Kansas | 20157 | 913 | 15 |
1908571 | 1908571 | 2021-11-12 | Rice | Kansas | 20159 | 1504 | 15 |
1908572 | 1908572 | 2021-11-12 | Riley | Kansas | 20161 | 8258 | 62 |
1908573 | 1908573 | 2021-11-12 | Rooks | Kansas | 20163 | 814 | 13 |
1908574 | 1908574 | 2021-11-12 | Rush | Kansas | 20165 | 534 | 16 |
1908575 | 1908575 | 2021-11-12 | Russell | Kansas | 20167 | 1231 | 33 |
1908576 | 1908576 | 2021-11-12 | Saline | Kansas | 20169 | 8813 | 186 |
1908577 | 1908577 | 2021-11-12 | Scott | Kansas | 20171 | 838 | 29 |
1908578 | 1908578 | 2021-11-12 | Sedgwick | Kansas | 20173 | 83621 | 1063 |
1908579 | 1908579 | 2021-11-12 | Seward | Kansas | 20175 | 4881 | 53 |
1908580 | 1908580 | 2021-11-12 | Shawnee | Kansas | 20177 | 26305 | 473 |
1908581 | 1908581 | 2021-11-12 | Sheridan | Kansas | 20179 | 526 | 15 |
1908582 | 1908582 | 2021-11-12 | Sherman | Kansas | 20181 | 973 | 13 |
1908583 | 1908583 | 2021-11-12 | Smith | Kansas | 20183 | 418 | 3 |
1908584 | 1908584 | 2021-11-12 | Stafford | Kansas | 20185 | 659 | 17 |
1908585 | 1908585 | 2021-11-12 | Stanton | Kansas | 20187 | 300 | 6 |
1908586 | 1908586 | 2021-11-12 | Stevens | Kansas | 20189 | 924 | 14 |
1908587 | 1908587 | 2021-11-12 | Sumner | Kansas | 20191 | 3357 | 62 |
1908588 | 1908588 | 2021-11-12 | Thomas | Kansas | 20193 | 1486 | 22 |
1908589 | 1908589 | 2021-11-12 | Trego | Kansas | 20195 | 507 | 8 |
1908590 | 1908590 | 2021-11-12 | Wabaunsee | Kansas | 20197 | 951 | 18 |
1908591 | 1908591 | 2021-11-12 | Wallace | Kansas | 20199 | 278 | 4 |
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);