ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where date = "2020-09-26" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
570936 | 570936 | 2020-09-26 | Allen | Kansas | 20001 | 57 | 0 |
570937 | 570937 | 2020-09-26 | Anderson | Kansas | 20003 | 74 | 0 |
570938 | 570938 | 2020-09-26 | Atchison | Kansas | 20005 | 307 | 2 |
570939 | 570939 | 2020-09-26 | Barber | Kansas | 20007 | 5 | 0 |
570940 | 570940 | 2020-09-26 | Barton | Kansas | 20009 | 492 | 7 |
570941 | 570941 | 2020-09-26 | Bourbon | Kansas | 20011 | 175 | 3 |
570942 | 570942 | 2020-09-26 | Brown | Kansas | 20013 | 114 | 3 |
570943 | 570943 | 2020-09-26 | Butler | Kansas | 20015 | 922 | 4 |
570944 | 570944 | 2020-09-26 | Chase | Kansas | 20017 | 81 | 1 |
570945 | 570945 | 2020-09-26 | Chautauqua | Kansas | 20019 | 16 | 0 |
570946 | 570946 | 2020-09-26 | Cherokee | Kansas | 20021 | 489 | 8 |
570947 | 570947 | 2020-09-26 | Cheyenne | Kansas | 20023 | 56 | 0 |
570948 | 570948 | 2020-09-26 | Clark | Kansas | 20025 | 50 | 1 |
570949 | 570949 | 2020-09-26 | Clay | Kansas | 20027 | 50 | 2 |
570950 | 570950 | 2020-09-26 | Cloud | Kansas | 20029 | 68 | 1 |
570951 | 570951 | 2020-09-26 | Coffey | Kansas | 20031 | 118 | 8 |
570952 | 570952 | 2020-09-26 | Comanche | Kansas | 20033 | 11 | 0 |
570953 | 570953 | 2020-09-26 | Cowley | Kansas | 20035 | 373 | 5 |
570954 | 570954 | 2020-09-26 | Crawford | Kansas | 20037 | 1038 | 6 |
570955 | 570955 | 2020-09-26 | Decatur | Kansas | 20039 | 22 | 0 |
570956 | 570956 | 2020-09-26 | Dickinson | Kansas | 20041 | 171 | 1 |
570957 | 570957 | 2020-09-26 | Doniphan | Kansas | 20043 | 100 | 0 |
570958 | 570958 | 2020-09-26 | Douglas | Kansas | 20045 | 2174 | 10 |
570959 | 570959 | 2020-09-26 | Edwards | Kansas | 20047 | 46 | 0 |
570960 | 570960 | 2020-09-26 | Elk | Kansas | 20049 | 4 | 0 |
570961 | 570961 | 2020-09-26 | Ellis | Kansas | 20051 | 970 | 3 |
570962 | 570962 | 2020-09-26 | Ellsworth | Kansas | 20053 | 32 | 0 |
570963 | 570963 | 2020-09-26 | Finney | Kansas | 20055 | 2129 | 12 |
570964 | 570964 | 2020-09-26 | Ford | Kansas | 20057 | 2800 | 10 |
570965 | 570965 | 2020-09-26 | Franklin | Kansas | 20059 | 349 | 3 |
570966 | 570966 | 2020-09-26 | Geary | Kansas | 20061 | 416 | 2 |
570967 | 570967 | 2020-09-26 | Gove | Kansas | 20063 | 42 | 0 |
570968 | 570968 | 2020-09-26 | Graham | Kansas | 20065 | 36 | 1 |
570969 | 570969 | 2020-09-26 | Grant | Kansas | 20067 | 272 | 5 |
570970 | 570970 | 2020-09-26 | Gray | Kansas | 20069 | 121 | 0 |
570971 | 570971 | 2020-09-26 | Greeley | Kansas | 20071 | 8 | 0 |
570972 | 570972 | 2020-09-26 | Greenwood | Kansas | 20073 | 49 | 0 |
570973 | 570973 | 2020-09-26 | Hamilton | Kansas | 20075 | 46 | 0 |
570974 | 570974 | 2020-09-26 | Harper | Kansas | 20077 | 120 | 2 |
570975 | 570975 | 2020-09-26 | Harvey | Kansas | 20079 | 352 | 8 |
570976 | 570976 | 2020-09-26 | Haskell | Kansas | 20081 | 116 | 1 |
570977 | 570977 | 2020-09-26 | Hodgeman | Kansas | 20083 | 19 | 0 |
570978 | 570978 | 2020-09-26 | Jackson | Kansas | 20085 | 239 | 2 |
570979 | 570979 | 2020-09-26 | Jefferson | Kansas | 20087 | 186 | 4 |
570980 | 570980 | 2020-09-26 | Jewell | Kansas | 20089 | 17 | 1 |
570981 | 570981 | 2020-09-26 | Johnson | Kansas | 20091 | 10997 | 146 |
570982 | 570982 | 2020-09-26 | Kearny | Kansas | 20093 | 92 | 1 |
570983 | 570983 | 2020-09-26 | Kingman | Kansas | 20095 | 90 | 1 |
570984 | 570984 | 2020-09-26 | Kiowa | Kansas | 20097 | 23 | 0 |
570985 | 570985 | 2020-09-26 | Labette | Kansas | 20099 | 240 | 4 |
570986 | 570986 | 2020-09-26 | Lane | Kansas | 20101 | 13 | 0 |
570987 | 570987 | 2020-09-26 | Leavenworth | Kansas | 20103 | 2080 | 11 |
570988 | 570988 | 2020-09-26 | Lincoln | Kansas | 20105 | 12 | 0 |
570989 | 570989 | 2020-09-26 | Linn | Kansas | 20107 | 75 | 0 |
570990 | 570990 | 2020-09-26 | Logan | Kansas | 20109 | 14 | 0 |
570991 | 570991 | 2020-09-26 | Lyon | Kansas | 20111 | 1051 | 33 |
570992 | 570992 | 2020-09-26 | Marion | Kansas | 20115 | 90 | 1 |
570993 | 570993 | 2020-09-26 | Marshall | Kansas | 20117 | 23 | 0 |
570994 | 570994 | 2020-09-26 | McPherson | Kansas | 20113 | 265 | 1 |
570995 | 570995 | 2020-09-26 | Meade | Kansas | 20119 | 125 | 1 |
570996 | 570996 | 2020-09-26 | Miami | Kansas | 20121 | 375 | 1 |
570997 | 570997 | 2020-09-26 | Mitchell | Kansas | 20123 | 44 | 0 |
570998 | 570998 | 2020-09-26 | Montgomery | Kansas | 20125 | 404 | 6 |
570999 | 570999 | 2020-09-26 | Morris | Kansas | 20127 | 35 | 0 |
571000 | 571000 | 2020-09-26 | Morton | Kansas | 20129 | 14 | 2 |
571001 | 571001 | 2020-09-26 | Nemaha | Kansas | 20131 | 101 | 1 |
571002 | 571002 | 2020-09-26 | Neosho | Kansas | 20133 | 166 | 0 |
571003 | 571003 | 2020-09-26 | Ness | Kansas | 20135 | 75 | 6 |
571004 | 571004 | 2020-09-26 | Norton | Kansas | 20137 | 31 | 0 |
571005 | 571005 | 2020-09-26 | Osage | Kansas | 20139 | 107 | 0 |
571006 | 571006 | 2020-09-26 | Osborne | Kansas | 20141 | 7 | 0 |
571007 | 571007 | 2020-09-26 | Ottawa | Kansas | 20143 | 53 | 0 |
571008 | 571008 | 2020-09-26 | Pawnee | Kansas | 20145 | 374 | 0 |
571009 | 571009 | 2020-09-26 | Phillips | Kansas | 20147 | 116 | 8 |
571010 | 571010 | 2020-09-26 | Pottawatomie | Kansas | 20149 | 249 | 0 |
571011 | 571011 | 2020-09-26 | Pratt | Kansas | 20151 | 72 | 0 |
571012 | 571012 | 2020-09-26 | Rawlins | Kansas | 20153 | 49 | 0 |
571013 | 571013 | 2020-09-26 | Reno | Kansas | 20155 | 1094 | 3 |
571014 | 571014 | 2020-09-26 | Republic | Kansas | 20157 | 49 | 1 |
571015 | 571015 | 2020-09-26 | Rice | Kansas | 20159 | 73 | 1 |
571016 | 571016 | 2020-09-26 | Riley | Kansas | 20161 | 1795 | 8 |
571017 | 571017 | 2020-09-26 | Rooks | Kansas | 20163 | 70 | 0 |
571018 | 571018 | 2020-09-26 | Rush | Kansas | 20165 | 53 | 0 |
571019 | 571019 | 2020-09-26 | Russell | Kansas | 20167 | 84 | 0 |
571020 | 571020 | 2020-09-26 | Saline | Kansas | 20169 | 719 | 11 |
571021 | 571021 | 2020-09-26 | Scott | Kansas | 20171 | 121 | 1 |
571022 | 571022 | 2020-09-26 | Sedgwick | Kansas | 20173 | 8757 | 86 |
571023 | 571023 | 2020-09-26 | Seward | Kansas | 20175 | 1669 | 5 |
571024 | 571024 | 2020-09-26 | Shawnee | Kansas | 20177 | 2710 | 32 |
571025 | 571025 | 2020-09-26 | Sheridan | Kansas | 20179 | 16 | 0 |
571026 | 571026 | 2020-09-26 | Sherman | Kansas | 20181 | 31 | 0 |
571027 | 571027 | 2020-09-26 | Smith | Kansas | 20183 | 7 | 0 |
571028 | 571028 | 2020-09-26 | Stafford | Kansas | 20185 | 56 | 1 |
571029 | 571029 | 2020-09-26 | Stanton | Kansas | 20187 | 59 | 2 |
571030 | 571030 | 2020-09-26 | Stevens | Kansas | 20189 | 144 | 1 |
571031 | 571031 | 2020-09-26 | Sumner | Kansas | 20191 | 198 | 3 |
571032 | 571032 | 2020-09-26 | Thomas | Kansas | 20193 | 131 | 0 |
571033 | 571033 | 2020-09-26 | Trego | Kansas | 20195 | 46 | 3 |
571034 | 571034 | 2020-09-26 | Wabaunsee | Kansas | 20197 | 68 | 1 |
571035 | 571035 | 2020-09-26 | Wallace | Kansas | 20199 | 17 | 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);