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-12-14 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2012505 | 2012505 | 2021-12-14 | Allen | Kansas | 20001 | 2448 | 26 |
2012506 | 2012506 | 2021-12-14 | Anderson | Kansas | 20003 | 1280 | 23 |
2012507 | 2012507 | 2021-12-14 | Atchison | Kansas | 20005 | 2770 | 26 |
2012508 | 2012508 | 2021-12-14 | Barber | Kansas | 20007 | 648 | 7 |
2012509 | 2012509 | 2021-12-14 | Barton | Kansas | 20009 | 4534 | 71 |
2012510 | 2012510 | 2021-12-14 | Bourbon | Kansas | 20011 | 2769 | 44 |
2012511 | 2012511 | 2021-12-14 | Brown | Kansas | 20013 | 1924 | 41 |
2012512 | 2012512 | 2021-12-14 | Butler | Kansas | 20015 | 12262 | 143 |
2012513 | 2012513 | 2021-12-14 | Chase | Kansas | 20017 | 443 | 5 |
2012514 | 2012514 | 2021-12-14 | Chautauqua | Kansas | 20019 | 589 | 14 |
2012515 | 2012515 | 2021-12-14 | Cherokee | Kansas | 20021 | 3932 | 78 |
2012516 | 2012516 | 2021-12-14 | Cheyenne | Kansas | 20023 | 491 | 14 |
2012517 | 2012517 | 2021-12-14 | Clark | Kansas | 20025 | 363 | 7 |
2012518 | 2012518 | 2021-12-14 | Clay | Kansas | 20027 | 1362 | 31 |
2012519 | 2012519 | 2021-12-14 | Cloud | Kansas | 20029 | 1750 | 32 |
2012520 | 2012520 | 2021-12-14 | Coffey | Kansas | 20031 | 1469 | 31 |
2012521 | 2012521 | 2021-12-14 | Comanche | Kansas | 20033 | 346 | 13 |
2012522 | 2012522 | 2021-12-14 | Cowley | Kansas | 20035 | 6601 | 132 |
2012523 | 2012523 | 2021-12-14 | Crawford | Kansas | 20037 | 7418 | 117 |
2012524 | 2012524 | 2021-12-14 | Decatur | Kansas | 20039 | 496 | 16 |
2012525 | 2012525 | 2021-12-14 | Dickinson | Kansas | 20041 | 3350 | 61 |
2012526 | 2012526 | 2021-12-14 | Doniphan | Kansas | 20043 | 1643 | 29 |
2012527 | 2012527 | 2021-12-14 | Douglas | Kansas | 20045 | 13757 | 107 |
2012528 | 2012528 | 2021-12-14 | Edwards | Kansas | 20047 | 463 | 13 |
2012529 | 2012529 | 2021-12-14 | Elk | Kansas | 20049 | 378 | 6 |
2012530 | 2012530 | 2021-12-14 | Ellis | Kansas | 20051 | 5031 | 77 |
2012531 | 2012531 | 2021-12-14 | Ellsworth | Kansas | 20053 | 1551 | 31 |
2012532 | 2012532 | 2021-12-14 | Finney | Kansas | 20055 | 8398 | 98 |
2012533 | 2012533 | 2021-12-14 | Ford | Kansas | 20057 | 7624 | 98 |
2012534 | 2012534 | 2021-12-14 | Franklin | Kansas | 20059 | 4325 | 67 |
2012535 | 2012535 | 2021-12-14 | Geary | Kansas | 20061 | 5137 | 61 |
2012536 | 2012536 | 2021-12-14 | Gove | Kansas | 20063 | 595 | 23 |
2012537 | 2012537 | 2021-12-14 | Graham | Kansas | 20065 | 365 | 12 |
2012538 | 2012538 | 2021-12-14 | Grant | Kansas | 20067 | 1531 | 32 |
2012539 | 2012539 | 2021-12-14 | Gray | Kansas | 20069 | 954 | 23 |
2012540 | 2012540 | 2021-12-14 | Greeley | Kansas | 20071 | 226 | 3 |
2012541 | 2012541 | 2021-12-14 | Greenwood | Kansas | 20073 | 1105 | 17 |
2012542 | 2012542 | 2021-12-14 | Hamilton | Kansas | 20075 | 341 | 3 |
2012543 | 2012543 | 2021-12-14 | Harper | Kansas | 20077 | 1170 | 25 |
2012544 | 2012544 | 2021-12-14 | Harvey | Kansas | 20079 | 5908 | 100 |
2012545 | 2012545 | 2021-12-14 | Haskell | Kansas | 20081 | 693 | 9 |
2012546 | 2012546 | 2021-12-14 | Hodgeman | Kansas | 20083 | 270 | 10 |
2012547 | 2012547 | 2021-12-14 | Jackson | Kansas | 20085 | 2508 | 20 |
2012548 | 2012548 | 2021-12-14 | Jefferson | Kansas | 20087 | 3017 | 52 |
2012549 | 2012549 | 2021-12-14 | Jewell | Kansas | 20089 | 613 | 11 |
2012550 | 2012550 | 2021-12-14 | Johnson | Kansas | 20091 | 86681 | 983 |
2012551 | 2012551 | 2021-12-14 | Kearny | Kansas | 20093 | 966 | 17 |
2012552 | 2012552 | 2021-12-14 | Kingman | Kansas | 20095 | 1384 | 24 |
2012553 | 2012553 | 2021-12-14 | Kiowa | Kansas | 20097 | 446 | 7 |
2012554 | 2012554 | 2021-12-14 | Labette | Kansas | 20099 | 4170 | 65 |
2012555 | 2012555 | 2021-12-14 | Lane | Kansas | 20101 | 217 | 9 |
2012556 | 2012556 | 2021-12-14 | Leavenworth | Kansas | 20103 | 11637 | 143 |
2012557 | 2012557 | 2021-12-14 | Lincoln | Kansas | 20105 | 422 | 7 |
2012558 | 2012558 | 2021-12-14 | Linn | Kansas | 20107 | 1804 | 21 |
2012559 | 2012559 | 2021-12-14 | Logan | Kansas | 20109 | 560 | 9 |
2012560 | 2012560 | 2021-12-14 | Lyon | Kansas | 20111 | 6162 | 98 |
2012561 | 2012561 | 2021-12-14 | Marion | Kansas | 20115 | 2048 | 35 |
2012562 | 2012562 | 2021-12-14 | Marshall | Kansas | 20117 | 1898 | 34 |
2012563 | 2012563 | 2021-12-14 | McPherson | Kansas | 20113 | 5240 | 99 |
2012564 | 2012564 | 2021-12-14 | Meade | Kansas | 20119 | 782 | 14 |
2012565 | 2012565 | 2021-12-14 | Miami | Kansas | 20121 | 4925 | 72 |
2012566 | 2012566 | 2021-12-14 | Mitchell | Kansas | 20123 | 909 | 17 |
2012567 | 2012567 | 2021-12-14 | Montgomery | Kansas | 20125 | 5801 | 123 |
2012568 | 2012568 | 2021-12-14 | Morris | Kansas | 20127 | 926 | 23 |
2012569 | 2012569 | 2021-12-14 | Morton | Kansas | 20129 | 464 | 10 |
2012570 | 2012570 | 2021-12-14 | Nemaha | Kansas | 20131 | 2326 | 56 |
2012571 | 2012571 | 2021-12-14 | Neosho | Kansas | 20133 | 3195 | 54 |
2012572 | 2012572 | 2021-12-14 | Ness | Kansas | 20135 | 557 | 17 |
2012573 | 2012573 | 2021-12-14 | Norton | Kansas | 20137 | 1628 | 35 |
2012574 | 2012574 | 2021-12-14 | Osage | Kansas | 20139 | 2394 | 39 |
2012575 | 2012575 | 2021-12-14 | Osborne | Kansas | 20141 | 547 | 15 |
2012576 | 2012576 | 2021-12-14 | Ottawa | Kansas | 20143 | 880 | 15 |
2012577 | 2012577 | 2021-12-14 | Pawnee | Kansas | 20145 | 1606 | 21 |
2012578 | 2012578 | 2021-12-14 | Phillips | Kansas | 20147 | 1041 | 28 |
2012579 | 2012579 | 2021-12-14 | Pottawatomie | Kansas | 20149 | 3375 | 47 |
2012580 | 2012580 | 2021-12-14 | Pratt | Kansas | 20151 | 1417 | 29 |
2012581 | 2012581 | 2021-12-14 | Rawlins | Kansas | 20153 | 574 | 8 |
2012582 | 2012582 | 2021-12-14 | Reno | Kansas | 20155 | 13286 | 179 |
2012583 | 2012583 | 2021-12-14 | Republic | Kansas | 20157 | 966 | 14 |
2012584 | 2012584 | 2021-12-14 | Rice | Kansas | 20159 | 1691 | 16 |
2012585 | 2012585 | 2021-12-14 | Riley | Kansas | 20161 | 8591 | 65 |
2012586 | 2012586 | 2021-12-14 | Rooks | Kansas | 20163 | 935 | 15 |
2012587 | 2012587 | 2021-12-14 | Rush | Kansas | 20165 | 577 | 16 |
2012588 | 2012588 | 2021-12-14 | Russell | Kansas | 20167 | 1405 | 34 |
2012589 | 2012589 | 2021-12-14 | Saline | Kansas | 20169 | 9598 | 198 |
2012590 | 2012590 | 2021-12-14 | Scott | Kansas | 20171 | 916 | 32 |
2012591 | 2012591 | 2021-12-14 | Sedgwick | Kansas | 20173 | 90651 | 1094 |
2012592 | 2012592 | 2021-12-14 | Seward | Kansas | 20175 | 5327 | 55 |
2012593 | 2012593 | 2021-12-14 | Shawnee | Kansas | 20177 | 28969 | 486 |
2012594 | 2012594 | 2021-12-14 | Sheridan | Kansas | 20179 | 588 | 16 |
2012595 | 2012595 | 2021-12-14 | Sherman | Kansas | 20181 | 1146 | 16 |
2012596 | 2012596 | 2021-12-14 | Smith | Kansas | 20183 | 486 | 3 |
2012597 | 2012597 | 2021-12-14 | Stafford | Kansas | 20185 | 813 | 23 |
2012598 | 2012598 | 2021-12-14 | Stanton | Kansas | 20187 | 331 | 7 |
2012599 | 2012599 | 2021-12-14 | Stevens | Kansas | 20189 | 1031 | 16 |
2012600 | 2012600 | 2021-12-14 | Sumner | Kansas | 20191 | 3765 | 63 |
2012601 | 2012601 | 2021-12-14 | Thomas | Kansas | 20193 | 1767 | 23 |
2012602 | 2012602 | 2021-12-14 | Trego | Kansas | 20195 | 543 | 9 |
2012603 | 2012603 | 2021-12-14 | Wabaunsee | Kansas | 20197 | 1097 | 19 |
2012604 | 2012604 | 2021-12-14 | Wallace | Kansas | 20199 | 333 | 5 |
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);