ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
464176 | 464176 | 2020-08-24 | Allen | Kansas | 20001 | 23 | 0 |
464177 | 464177 | 2020-08-24 | Anderson | Kansas | 20003 | 32 | 0 |
464178 | 464178 | 2020-08-24 | Atchison | Kansas | 20005 | 157 | 0 |
464179 | 464179 | 2020-08-24 | Barber | Kansas | 20007 | 5 | 0 |
464180 | 464180 | 2020-08-24 | Barton | Kansas | 20009 | 223 | 4 |
464181 | 464181 | 2020-08-24 | Bourbon | Kansas | 20011 | 92 | 2 |
464182 | 464182 | 2020-08-24 | Brown | Kansas | 20013 | 53 | 0 |
464183 | 464183 | 2020-08-24 | Butler | Kansas | 20015 | 386 | 2 |
464184 | 464184 | 2020-08-24 | Chase | Kansas | 20017 | 65 | 0 |
464185 | 464185 | 2020-08-24 | Chautauqua | Kansas | 20019 | 8 | 0 |
464186 | 464186 | 2020-08-24 | Cherokee | Kansas | 20021 | 210 | 2 |
464187 | 464187 | 2020-08-24 | Cheyenne | Kansas | 20023 | 6 | 0 |
464188 | 464188 | 2020-08-24 | Clark | Kansas | 20025 | 46 | 1 |
464189 | 464189 | 2020-08-24 | Clay | Kansas | 20027 | 30 | 2 |
464190 | 464190 | 2020-08-24 | Cloud | Kansas | 20029 | 45 | 1 |
464191 | 464191 | 2020-08-24 | Coffey | Kansas | 20031 | 76 | 8 |
464192 | 464192 | 2020-08-24 | Comanche | Kansas | 20033 | 9 | 0 |
464193 | 464193 | 2020-08-24 | Cowley | Kansas | 20035 | 240 | 3 |
464194 | 464194 | 2020-08-24 | Crawford | Kansas | 20037 | 443 | 1 |
464195 | 464195 | 2020-08-24 | Decatur | Kansas | 20039 | 6 | 0 |
464196 | 464196 | 2020-08-24 | Dickinson | Kansas | 20041 | 61 | 1 |
464197 | 464197 | 2020-08-24 | Doniphan | Kansas | 20043 | 58 | 0 |
464198 | 464198 | 2020-08-24 | Douglas | Kansas | 20045 | 1017 | 8 |
464199 | 464199 | 2020-08-24 | Edwards | Kansas | 20047 | 22 | 0 |
464200 | 464200 | 2020-08-24 | Elk | Kansas | 20049 | 1 | 0 |
464201 | 464201 | 2020-08-24 | Ellis | Kansas | 20051 | 256 | 1 |
464202 | 464202 | 2020-08-24 | Ellsworth | Kansas | 20053 | 23 | 0 |
464203 | 464203 | 2020-08-24 | Finney | Kansas | 20055 | 1846 | 12 |
464204 | 464204 | 2020-08-24 | Ford | Kansas | 20057 | 2257 | 10 |
464205 | 464205 | 2020-08-24 | Franklin | Kansas | 20059 | 250 | 2 |
464206 | 464206 | 2020-08-24 | Geary | Kansas | 20061 | 257 | 2 |
464207 | 464207 | 2020-08-24 | Gove | Kansas | 20063 | 7 | 0 |
464208 | 464208 | 2020-08-24 | Graham | Kansas | 20065 | 25 | 0 |
464209 | 464209 | 2020-08-24 | Grant | Kansas | 20067 | 143 | 3 |
464210 | 464210 | 2020-08-24 | Gray | Kansas | 20069 | 83 | 0 |
464211 | 464211 | 2020-08-24 | Greeley | Kansas | 20071 | 4 | 0 |
464212 | 464212 | 2020-08-24 | Greenwood | Kansas | 20073 | 24 | 0 |
464213 | 464213 | 2020-08-24 | Hamilton | Kansas | 20075 | 43 | 0 |
464214 | 464214 | 2020-08-24 | Harper | Kansas | 20077 | 95 | 0 |
464215 | 464215 | 2020-08-24 | Harvey | Kansas | 20079 | 277 | 5 |
464216 | 464216 | 2020-08-24 | Haskell | Kansas | 20081 | 53 | 0 |
464217 | 464217 | 2020-08-24 | Hodgeman | Kansas | 20083 | 13 | 0 |
464218 | 464218 | 2020-08-24 | Jackson | Kansas | 20085 | 185 | 1 |
464219 | 464219 | 2020-08-24 | Jefferson | Kansas | 20087 | 106 | 0 |
464220 | 464220 | 2020-08-24 | Jewell | Kansas | 20089 | 14 | 1 |
464221 | 464221 | 2020-08-24 | Johnson | Kansas | 20091 | 7418 | 111 |
464222 | 464222 | 2020-08-24 | Kearny | Kansas | 20093 | 70 | 1 |
464223 | 464223 | 2020-08-24 | Kingman | Kansas | 20095 | 38 | 0 |
464224 | 464224 | 2020-08-24 | Kiowa | Kansas | 20097 | 9 | 0 |
464225 | 464225 | 2020-08-24 | Labette | Kansas | 20099 | 167 | 1 |
464226 | 464226 | 2020-08-24 | Lane | Kansas | 20101 | 7 | 0 |
464227 | 464227 | 2020-08-24 | Leavenworth | Kansas | 20103 | 1634 | 9 |
464228 | 464228 | 2020-08-24 | Lincoln | Kansas | 20105 | 6 | 0 |
464229 | 464229 | 2020-08-24 | Linn | Kansas | 20107 | 53 | 0 |
464230 | 464230 | 2020-08-24 | Logan | Kansas | 20109 | 3 | 0 |
464231 | 464231 | 2020-08-24 | Lyon | Kansas | 20111 | 820 | 14 |
464232 | 464232 | 2020-08-24 | Marion | Kansas | 20115 | 61 | 1 |
464233 | 464233 | 2020-08-24 | Marshall | Kansas | 20117 | 14 | 0 |
464234 | 464234 | 2020-08-24 | McPherson | Kansas | 20113 | 182 | 1 |
464235 | 464235 | 2020-08-24 | Meade | Kansas | 20119 | 66 | 0 |
464236 | 464236 | 2020-08-24 | Miami | Kansas | 20121 | 187 | 0 |
464237 | 464237 | 2020-08-24 | Mitchell | Kansas | 20123 | 28 | 0 |
464238 | 464238 | 2020-08-24 | Montgomery | Kansas | 20125 | 208 | 5 |
464239 | 464239 | 2020-08-24 | Morris | Kansas | 20127 | 18 | 0 |
464240 | 464240 | 2020-08-24 | Morton | Kansas | 20129 | 10 | 2 |
464241 | 464241 | 2020-08-24 | Nemaha | Kansas | 20131 | 55 | 1 |
464242 | 464242 | 2020-08-24 | Neosho | Kansas | 20133 | 76 | 0 |
464243 | 464243 | 2020-08-24 | Ness | Kansas | 20135 | 19 | 0 |
464244 | 464244 | 2020-08-24 | Norton | Kansas | 20137 | 23 | 0 |
464245 | 464245 | 2020-08-24 | Osage | Kansas | 20139 | 59 | 0 |
464246 | 464246 | 2020-08-24 | Osborne | Kansas | 20141 | 4 | 0 |
464247 | 464247 | 2020-08-24 | Ottawa | Kansas | 20143 | 39 | 0 |
464248 | 464248 | 2020-08-24 | Pawnee | Kansas | 20145 | 151 | 0 |
464249 | 464249 | 2020-08-24 | Phillips | Kansas | 20147 | 51 | 8 |
464250 | 464250 | 2020-08-24 | Pottawatomie | Kansas | 20149 | 142 | 0 |
464251 | 464251 | 2020-08-24 | Pratt | Kansas | 20151 | 40 | 0 |
464252 | 464252 | 2020-08-24 | Rawlins | Kansas | 20153 | 1 | 0 |
464253 | 464253 | 2020-08-24 | Reno | Kansas | 20155 | 650 | 1 |
464254 | 464254 | 2020-08-24 | Republic | Kansas | 20157 | 36 | 0 |
464255 | 464255 | 2020-08-24 | Rice | Kansas | 20159 | 42 | 0 |
464256 | 464256 | 2020-08-24 | Riley | Kansas | 20161 | 618 | 5 |
464257 | 464257 | 2020-08-24 | Rooks | Kansas | 20163 | 23 | 0 |
464258 | 464258 | 2020-08-24 | Rush | Kansas | 20165 | 16 | 0 |
464259 | 464259 | 2020-08-24 | Russell | Kansas | 20167 | 23 | 0 |
464260 | 464260 | 2020-08-24 | Saline | Kansas | 20169 | 439 | 9 |
464261 | 464261 | 2020-08-24 | Scott | Kansas | 20171 | 88 | 0 |
464262 | 464262 | 2020-08-24 | Sedgwick | Kansas | 20173 | 6652 | 48 |
464263 | 464263 | 2020-08-24 | Seward | Kansas | 20175 | 1317 | 4 |
464264 | 464264 | 2020-08-24 | Shawnee | Kansas | 20177 | 1994 | 21 |
464265 | 464265 | 2020-08-24 | Sheridan | Kansas | 20179 | 7 | 0 |
464266 | 464266 | 2020-08-24 | Sherman | Kansas | 20181 | 17 | 0 |
464267 | 464267 | 2020-08-24 | Smith | Kansas | 20183 | 3 | 0 |
464268 | 464268 | 2020-08-24 | Stafford | Kansas | 20185 | 23 | 1 |
464269 | 464269 | 2020-08-24 | Stanton | Kansas | 20187 | 41 | 2 |
464270 | 464270 | 2020-08-24 | Stevens | Kansas | 20189 | 60 | 0 |
464271 | 464271 | 2020-08-24 | Sumner | Kansas | 20191 | 117 | 3 |
464272 | 464272 | 2020-08-24 | Thomas | Kansas | 20193 | 51 | 0 |
464273 | 464273 | 2020-08-24 | Trego | Kansas | 20195 | 9 | 1 |
464274 | 464274 | 2020-08-24 | Wabaunsee | Kansas | 20197 | 51 | 0 |
464275 | 464275 | 2020-08-24 | 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);