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-11-13 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
726609 | 726609 | 2020-11-13 | Allen | Kansas | 20001 | 240 | 1 |
726610 | 726610 | 2020-11-13 | Anderson | Kansas | 20003 | 308 | 0 |
726611 | 726611 | 2020-11-13 | Atchison | Kansas | 20005 | 686 | 7 |
726612 | 726612 | 2020-11-13 | Barber | Kansas | 20007 | 147 | 0 |
726613 | 726613 | 2020-11-13 | Barton | Kansas | 20009 | 1205 | 12 |
726614 | 726614 | 2020-11-13 | Bourbon | Kansas | 20011 | 382 | 3 |
726615 | 726615 | 2020-11-13 | Brown | Kansas | 20013 | 450 | 6 |
726616 | 726616 | 2020-11-13 | Butler | Kansas | 20015 | 2325 | 4 |
726617 | 726617 | 2020-11-13 | Chase | Kansas | 20017 | 139 | 3 |
726618 | 726618 | 2020-11-13 | Chautauqua | Kansas | 20019 | 40 | 0 |
726619 | 726619 | 2020-11-13 | Cherokee | Kansas | 20021 | 928 | 9 |
726620 | 726620 | 2020-11-13 | Cheyenne | Kansas | 20023 | 176 | 7 |
726621 | 726621 | 2020-11-13 | Clark | Kansas | 20025 | 88 | 4 |
726622 | 726622 | 2020-11-13 | Clay | Kansas | 20027 | 274 | 8 |
726623 | 726623 | 2020-11-13 | Cloud | Kansas | 20029 | 392 | 1 |
726624 | 726624 | 2020-11-13 | Coffey | Kansas | 20031 | 243 | 9 |
726625 | 726625 | 2020-11-13 | Comanche | Kansas | 20033 | 27 | 0 |
726626 | 726626 | 2020-11-13 | Cowley | Kansas | 20035 | 989 | 9 |
726627 | 726627 | 2020-11-13 | Crawford | Kansas | 20037 | 1882 | 14 |
726628 | 726628 | 2020-11-13 | Decatur | Kansas | 20039 | 180 | 1 |
726629 | 726629 | 2020-11-13 | Dickinson | Kansas | 20041 | 570 | 5 |
726630 | 726630 | 2020-11-13 | Doniphan | Kansas | 20043 | 322 | 2 |
726631 | 726631 | 2020-11-13 | Douglas | Kansas | 20045 | 3724 | 19 |
726632 | 726632 | 2020-11-13 | Edwards | Kansas | 20047 | 108 | 0 |
726633 | 726633 | 2020-11-13 | Elk | Kansas | 20049 | 29 | 0 |
726634 | 726634 | 2020-11-13 | Ellis | Kansas | 20051 | 1820 | 18 |
726635 | 726635 | 2020-11-13 | Ellsworth | Kansas | 20053 | 478 | 3 |
726636 | 726636 | 2020-11-13 | Finney | Kansas | 20055 | 3874 | 23 |
726637 | 726637 | 2020-11-13 | Ford | Kansas | 20057 | 4128 | 10 |
726638 | 726638 | 2020-11-13 | Franklin | Kansas | 20059 | 824 | 8 |
726639 | 726639 | 2020-11-13 | Geary | Kansas | 20061 | 703 | 4 |
726640 | 726640 | 2020-11-13 | Gove | Kansas | 20063 | 247 | 19 |
726641 | 726641 | 2020-11-13 | Graham | Kansas | 20065 | 99 | 2 |
726642 | 726642 | 2020-11-13 | Grant | Kansas | 20067 | 588 | 10 |
726643 | 726643 | 2020-11-13 | Gray | Kansas | 20069 | 301 | 4 |
726644 | 726644 | 2020-11-13 | Greeley | Kansas | 20071 | 67 | 0 |
726645 | 726645 | 2020-11-13 | Greenwood | Kansas | 20073 | 157 | 0 |
726646 | 726646 | 2020-11-13 | Hamilton | Kansas | 20075 | 85 | 0 |
726647 | 726647 | 2020-11-13 | Harper | Kansas | 20077 | 213 | 4 |
726648 | 726648 | 2020-11-13 | Harvey | Kansas | 20079 | 1274 | 9 |
726649 | 726649 | 2020-11-13 | Haskell | Kansas | 20081 | 210 | 1 |
726650 | 726650 | 2020-11-13 | Hodgeman | Kansas | 20083 | 105 | 0 |
726651 | 726651 | 2020-11-13 | Jackson | Kansas | 20085 | 487 | 4 |
726652 | 726652 | 2020-11-13 | Jefferson | Kansas | 20087 | 476 | 6 |
726653 | 726653 | 2020-11-13 | Jewell | Kansas | 20089 | 37 | 1 |
726654 | 726654 | 2020-11-13 | Johnson | Kansas | 20091 | 20946 | 243 |
726655 | 726655 | 2020-11-13 | Kearny | Kansas | 20093 | 220 | 8 |
726656 | 726656 | 2020-11-13 | Kingman | Kansas | 20095 | 230 | 3 |
726657 | 726657 | 2020-11-13 | Kiowa | Kansas | 20097 | 86 | 0 |
726658 | 726658 | 2020-11-13 | Labette | Kansas | 20099 | 615 | 6 |
726659 | 726659 | 2020-11-13 | Lane | Kansas | 20101 | 51 | 1 |
726660 | 726660 | 2020-11-13 | Leavenworth | Kansas | 20103 | 3095 | 25 |
726661 | 726661 | 2020-11-13 | Lincoln | Kansas | 20105 | 31 | 1 |
726662 | 726662 | 2020-11-13 | Linn | Kansas | 20107 | 200 | 1 |
726663 | 726663 | 2020-11-13 | Logan | Kansas | 20109 | 181 | 0 |
726664 | 726664 | 2020-11-13 | Lyon | Kansas | 20111 | 1823 | 41 |
726665 | 726665 | 2020-11-13 | Marion | Kansas | 20115 | 340 | 1 |
726666 | 726666 | 2020-11-13 | Marshall | Kansas | 20117 | 258 | 0 |
726667 | 726667 | 2020-11-13 | McPherson | Kansas | 20113 | 874 | 8 |
726668 | 726668 | 2020-11-13 | Meade | Kansas | 20119 | 223 | 2 |
726669 | 726669 | 2020-11-13 | Miami | Kansas | 20121 | 747 | 2 |
726670 | 726670 | 2020-11-13 | Mitchell | Kansas | 20123 | 91 | 0 |
726671 | 726671 | 2020-11-13 | Montgomery | Kansas | 20125 | 862 | 6 |
726672 | 726672 | 2020-11-13 | Morris | Kansas | 20127 | 123 | 1 |
726673 | 726673 | 2020-11-13 | Morton | Kansas | 20129 | 86 | 3 |
726674 | 726674 | 2020-11-13 | Nemaha | Kansas | 20131 | 704 | 5 |
726675 | 726675 | 2020-11-13 | Neosho | Kansas | 20133 | 484 | 0 |
726676 | 726676 | 2020-11-13 | Ness | Kansas | 20135 | 189 | 9 |
726677 | 726677 | 2020-11-13 | Norton | Kansas | 20137 | 963 | 21 |
726678 | 726678 | 2020-11-13 | Osage | Kansas | 20139 | 306 | 5 |
726679 | 726679 | 2020-11-13 | Osborne | Kansas | 20141 | 47 | 0 |
726680 | 726680 | 2020-11-13 | Ottawa | Kansas | 20143 | 158 | 0 |
726681 | 726681 | 2020-11-13 | Pawnee | Kansas | 20145 | 495 | 1 |
726682 | 726682 | 2020-11-13 | Phillips | Kansas | 20147 | 309 | 9 |
726683 | 726683 | 2020-11-13 | Pottawatomie | Kansas | 20149 | 534 | 0 |
726684 | 726684 | 2020-11-13 | Pratt | Kansas | 20151 | 366 | 0 |
726685 | 726685 | 2020-11-13 | Rawlins | Kansas | 20153 | 173 | 1 |
726686 | 726686 | 2020-11-13 | Reno | Kansas | 20155 | 3410 | 28 |
726687 | 726687 | 2020-11-13 | Republic | Kansas | 20157 | 160 | 1 |
726688 | 726688 | 2020-11-13 | Rice | Kansas | 20159 | 246 | 1 |
726689 | 726689 | 2020-11-13 | Riley | Kansas | 20161 | 2807 | 14 |
726690 | 726690 | 2020-11-13 | Rooks | Kansas | 20163 | 205 | 7 |
726691 | 726691 | 2020-11-13 | Rush | Kansas | 20165 | 140 | 0 |
726692 | 726692 | 2020-11-13 | Russell | Kansas | 20167 | 326 | 7 |
726693 | 726693 | 2020-11-13 | Saline | Kansas | 20169 | 1603 | 17 |
726694 | 726694 | 2020-11-13 | Scott | Kansas | 20171 | 288 | 1 |
726695 | 726695 | 2020-11-13 | Sedgwick | Kansas | 20173 | 19504 | 137 |
726696 | 726696 | 2020-11-13 | Seward | Kansas | 20175 | 2396 | 13 |
726697 | 726697 | 2020-11-13 | Shawnee | Kansas | 20177 | 5335 | 97 |
726698 | 726698 | 2020-11-13 | Sheridan | Kansas | 20179 | 268 | 0 |
726699 | 726699 | 2020-11-13 | Sherman | Kansas | 20181 | 345 | 7 |
726700 | 726700 | 2020-11-13 | Smith | Kansas | 20183 | 72 | 0 |
726701 | 726701 | 2020-11-13 | Stafford | Kansas | 20185 | 149 | 1 |
726702 | 726702 | 2020-11-13 | Stanton | Kansas | 20187 | 119 | 2 |
726703 | 726703 | 2020-11-13 | Stevens | Kansas | 20189 | 338 | 1 |
726704 | 726704 | 2020-11-13 | Sumner | Kansas | 20191 | 536 | 6 |
726705 | 726705 | 2020-11-13 | Thomas | Kansas | 20193 | 500 | 2 |
726706 | 726706 | 2020-11-13 | Trego | Kansas | 20195 | 147 | 3 |
726707 | 726707 | 2020-11-13 | Unknown | Kansas | 0 | 86 | |
726708 | 726708 | 2020-11-13 | Wabaunsee | Kansas | 20197 | 205 | 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);