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 2020-08-26 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 |
---|---|---|---|---|---|---|---|
470634 | 470634 | 2020-08-26 | Allen | Kansas | 20001 | 23 | 0 |
470635 | 470635 | 2020-08-26 | Anderson | Kansas | 20003 | 32 | 0 |
470636 | 470636 | 2020-08-26 | Atchison | Kansas | 20005 | 157 | 0 |
470637 | 470637 | 2020-08-26 | Barber | Kansas | 20007 | 5 | 0 |
470638 | 470638 | 2020-08-26 | Barton | Kansas | 20009 | 251 | 4 |
470639 | 470639 | 2020-08-26 | Bourbon | Kansas | 20011 | 92 | 2 |
470640 | 470640 | 2020-08-26 | Brown | Kansas | 20013 | 64 | 0 |
470641 | 470641 | 2020-08-26 | Butler | Kansas | 20015 | 404 | 2 |
470642 | 470642 | 2020-08-26 | Chase | Kansas | 20017 | 65 | 0 |
470643 | 470643 | 2020-08-26 | Chautauqua | Kansas | 20019 | 8 | 0 |
470644 | 470644 | 2020-08-26 | Cherokee | Kansas | 20021 | 220 | 2 |
470645 | 470645 | 2020-08-26 | Cheyenne | Kansas | 20023 | 6 | 0 |
470646 | 470646 | 2020-08-26 | Clark | Kansas | 20025 | 47 | 1 |
470647 | 470647 | 2020-08-26 | Clay | Kansas | 20027 | 31 | 2 |
470648 | 470648 | 2020-08-26 | Cloud | Kansas | 20029 | 48 | 1 |
470649 | 470649 | 2020-08-26 | Coffey | Kansas | 20031 | 77 | 8 |
470650 | 470650 | 2020-08-26 | Comanche | Kansas | 20033 | 9 | 0 |
470651 | 470651 | 2020-08-26 | Cowley | Kansas | 20035 | 247 | 3 |
470652 | 470652 | 2020-08-26 | Crawford | Kansas | 20037 | 478 | 1 |
470653 | 470653 | 2020-08-26 | Decatur | Kansas | 20039 | 6 | 0 |
470654 | 470654 | 2020-08-26 | Dickinson | Kansas | 20041 | 65 | 1 |
470655 | 470655 | 2020-08-26 | Doniphan | Kansas | 20043 | 59 | 0 |
470656 | 470656 | 2020-08-26 | Douglas | Kansas | 20045 | 1196 | 8 |
470657 | 470657 | 2020-08-26 | Edwards | Kansas | 20047 | 23 | 0 |
470658 | 470658 | 2020-08-26 | Elk | Kansas | 20049 | 1 | 0 |
470659 | 470659 | 2020-08-26 | Ellis | Kansas | 20051 | 295 | 1 |
470660 | 470660 | 2020-08-26 | Ellsworth | Kansas | 20053 | 25 | 0 |
470661 | 470661 | 2020-08-26 | Finney | Kansas | 20055 | 1856 | 12 |
470662 | 470662 | 2020-08-26 | Ford | Kansas | 20057 | 2282 | 10 |
470663 | 470663 | 2020-08-26 | Franklin | Kansas | 20059 | 255 | 2 |
470664 | 470664 | 2020-08-26 | Geary | Kansas | 20061 | 259 | 2 |
470665 | 470665 | 2020-08-26 | Gove | Kansas | 20063 | 9 | 0 |
470666 | 470666 | 2020-08-26 | Graham | Kansas | 20065 | 25 | 0 |
470667 | 470667 | 2020-08-26 | Grant | Kansas | 20067 | 149 | 3 |
470668 | 470668 | 2020-08-26 | Gray | Kansas | 20069 | 85 | 0 |
470669 | 470669 | 2020-08-26 | Greeley | Kansas | 20071 | 4 | 0 |
470670 | 470670 | 2020-08-26 | Greenwood | Kansas | 20073 | 25 | 0 |
470671 | 470671 | 2020-08-26 | Hamilton | Kansas | 20075 | 44 | 0 |
470672 | 470672 | 2020-08-26 | Harper | Kansas | 20077 | 105 | 0 |
470673 | 470673 | 2020-08-26 | Harvey | Kansas | 20079 | 286 | 5 |
470674 | 470674 | 2020-08-26 | Haskell | Kansas | 20081 | 56 | 0 |
470675 | 470675 | 2020-08-26 | Hodgeman | Kansas | 20083 | 14 | 0 |
470676 | 470676 | 2020-08-26 | Jackson | Kansas | 20085 | 189 | 1 |
470677 | 470677 | 2020-08-26 | Jefferson | Kansas | 20087 | 112 | 0 |
470678 | 470678 | 2020-08-26 | Jewell | Kansas | 20089 | 14 | 1 |
470679 | 470679 | 2020-08-26 | Johnson | Kansas | 20091 | 7682 | 116 |
470680 | 470680 | 2020-08-26 | Kearny | Kansas | 20093 | 71 | 1 |
470681 | 470681 | 2020-08-26 | Kingman | Kansas | 20095 | 39 | 0 |
470682 | 470682 | 2020-08-26 | Kiowa | Kansas | 20097 | 9 | 0 |
470683 | 470683 | 2020-08-26 | Labette | Kansas | 20099 | 172 | 1 |
470684 | 470684 | 2020-08-26 | Lane | Kansas | 20101 | 8 | 0 |
470685 | 470685 | 2020-08-26 | Leavenworth | Kansas | 20103 | 1658 | 9 |
470686 | 470686 | 2020-08-26 | Lincoln | Kansas | 20105 | 7 | 0 |
470687 | 470687 | 2020-08-26 | Linn | Kansas | 20107 | 56 | 0 |
470688 | 470688 | 2020-08-26 | Logan | Kansas | 20109 | 3 | 0 |
470689 | 470689 | 2020-08-26 | Lyon | Kansas | 20111 | 836 | 17 |
470690 | 470690 | 2020-08-26 | Marion | Kansas | 20115 | 63 | 1 |
470691 | 470691 | 2020-08-26 | Marshall | Kansas | 20117 | 14 | 0 |
470692 | 470692 | 2020-08-26 | McPherson | Kansas | 20113 | 190 | 1 |
470693 | 470693 | 2020-08-26 | Meade | Kansas | 20119 | 69 | 0 |
470694 | 470694 | 2020-08-26 | Miami | Kansas | 20121 | 190 | 0 |
470695 | 470695 | 2020-08-26 | Mitchell | Kansas | 20123 | 30 | 0 |
470696 | 470696 | 2020-08-26 | Montgomery | Kansas | 20125 | 217 | 5 |
470697 | 470697 | 2020-08-26 | Morris | Kansas | 20127 | 19 | 0 |
470698 | 470698 | 2020-08-26 | Morton | Kansas | 20129 | 10 | 2 |
470699 | 470699 | 2020-08-26 | Nemaha | Kansas | 20131 | 55 | 1 |
470700 | 470700 | 2020-08-26 | Neosho | Kansas | 20133 | 81 | 0 |
470701 | 470701 | 2020-08-26 | Ness | Kansas | 20135 | 22 | 0 |
470702 | 470702 | 2020-08-26 | Norton | Kansas | 20137 | 23 | 0 |
470703 | 470703 | 2020-08-26 | Osage | Kansas | 20139 | 61 | 0 |
470704 | 470704 | 2020-08-26 | Osborne | Kansas | 20141 | 4 | 0 |
470705 | 470705 | 2020-08-26 | Ottawa | Kansas | 20143 | 40 | 0 |
470706 | 470706 | 2020-08-26 | Pawnee | Kansas | 20145 | 180 | 0 |
470707 | 470707 | 2020-08-26 | Phillips | Kansas | 20147 | 51 | 8 |
470708 | 470708 | 2020-08-26 | Pottawatomie | Kansas | 20149 | 144 | 0 |
470709 | 470709 | 2020-08-26 | Pratt | Kansas | 20151 | 40 | 0 |
470710 | 470710 | 2020-08-26 | Rawlins | Kansas | 20153 | 1 | 0 |
470711 | 470711 | 2020-08-26 | Reno | Kansas | 20155 | 699 | 1 |
470712 | 470712 | 2020-08-26 | Republic | Kansas | 20157 | 38 | 0 |
470713 | 470713 | 2020-08-26 | Rice | Kansas | 20159 | 43 | 0 |
470714 | 470714 | 2020-08-26 | Riley | Kansas | 20161 | 686 | 5 |
470715 | 470715 | 2020-08-26 | Rooks | Kansas | 20163 | 25 | 0 |
470716 | 470716 | 2020-08-26 | Rush | Kansas | 20165 | 17 | 0 |
470717 | 470717 | 2020-08-26 | Russell | Kansas | 20167 | 24 | 0 |
470718 | 470718 | 2020-08-26 | Saline | Kansas | 20169 | 450 | 9 |
470719 | 470719 | 2020-08-26 | Scott | Kansas | 20171 | 91 | 1 |
470720 | 470720 | 2020-08-26 | Sedgwick | Kansas | 20173 | 6992 | 50 |
470721 | 470721 | 2020-08-26 | Seward | Kansas | 20175 | 1334 | 4 |
470722 | 470722 | 2020-08-26 | Shawnee | Kansas | 20177 | 2058 | 21 |
470723 | 470723 | 2020-08-26 | Sheridan | Kansas | 20179 | 7 | 0 |
470724 | 470724 | 2020-08-26 | Sherman | Kansas | 20181 | 17 | 0 |
470725 | 470725 | 2020-08-26 | Smith | Kansas | 20183 | 3 | 0 |
470726 | 470726 | 2020-08-26 | Stafford | Kansas | 20185 | 31 | 1 |
470727 | 470727 | 2020-08-26 | Stanton | Kansas | 20187 | 43 | 2 |
470728 | 470728 | 2020-08-26 | Stevens | Kansas | 20189 | 65 | 0 |
470729 | 470729 | 2020-08-26 | Sumner | Kansas | 20191 | 119 | 3 |
470730 | 470730 | 2020-08-26 | Thomas | Kansas | 20193 | 51 | 0 |
470731 | 470731 | 2020-08-26 | Trego | Kansas | 20195 | 11 | 1 |
470732 | 470732 | 2020-08-26 | Wabaunsee | Kansas | 20197 | 52 | 0 |
470733 | 470733 | 2020-08-26 | Wallace | Kansas | 20199 | 1 | 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);