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-10-26 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668231 | 668231 | 2020-10-26 | Allen | Kansas | 20001 | 112 | 1 |
668232 | 668232 | 2020-10-26 | Anderson | Kansas | 20003 | 188 | 0 |
668233 | 668233 | 2020-10-26 | Atchison | Kansas | 20005 | 512 | 5 |
668234 | 668234 | 2020-10-26 | Barber | Kansas | 20007 | 51 | 0 |
668235 | 668235 | 2020-10-26 | Barton | Kansas | 20009 | 723 | 7 |
668236 | 668236 | 2020-10-26 | Bourbon | Kansas | 20011 | 303 | 3 |
668237 | 668237 | 2020-10-26 | Brown | Kansas | 20013 | 220 | 5 |
668238 | 668238 | 2020-10-26 | Butler | Kansas | 20015 | 1470 | 4 |
668239 | 668239 | 2020-10-26 | Chase | Kansas | 20017 | 107 | 3 |
668240 | 668240 | 2020-10-26 | Chautauqua | Kansas | 20019 | 27 | 0 |
668241 | 668241 | 2020-10-26 | Cherokee | Kansas | 20021 | 676 | 8 |
668242 | 668242 | 2020-10-26 | Cheyenne | Kansas | 20023 | 120 | 5 |
668243 | 668243 | 2020-10-26 | Clark | Kansas | 20025 | 68 | 1 |
668244 | 668244 | 2020-10-26 | Clay | Kansas | 20027 | 101 | 3 |
668245 | 668245 | 2020-10-26 | Cloud | Kansas | 20029 | 133 | 1 |
668246 | 668246 | 2020-10-26 | Coffey | Kansas | 20031 | 161 | 9 |
668247 | 668247 | 2020-10-26 | Comanche | Kansas | 20033 | 20 | 0 |
668248 | 668248 | 2020-10-26 | Cowley | Kansas | 20035 | 527 | 10 |
668249 | 668249 | 2020-10-26 | Crawford | Kansas | 20037 | 1446 | 10 |
668250 | 668250 | 2020-10-26 | Decatur | Kansas | 20039 | 97 | 1 |
668251 | 668251 | 2020-10-26 | Dickinson | Kansas | 20041 | 304 | 3 |
668252 | 668252 | 2020-10-26 | Doniphan | Kansas | 20043 | 200 | 0 |
668253 | 668253 | 2020-10-26 | Douglas | Kansas | 20045 | 2839 | 18 |
668254 | 668254 | 2020-10-26 | Edwards | Kansas | 20047 | 69 | 0 |
668255 | 668255 | 2020-10-26 | Elk | Kansas | 20049 | 15 | 0 |
668256 | 668256 | 2020-10-26 | Ellis | Kansas | 20051 | 1372 | 18 |
668257 | 668257 | 2020-10-26 | Ellsworth | Kansas | 20053 | 231 | 0 |
668258 | 668258 | 2020-10-26 | Finney | Kansas | 20055 | 2948 | 18 |
668259 | 668259 | 2020-10-26 | Ford | Kansas | 20057 | 3371 | 10 |
668260 | 668260 | 2020-10-26 | Franklin | Kansas | 20059 | 526 | 3 |
668261 | 668261 | 2020-10-26 | Geary | Kansas | 20061 | 554 | 4 |
668262 | 668262 | 2020-10-26 | Gove | Kansas | 20063 | 171 | 11 |
668263 | 668263 | 2020-10-26 | Graham | Kansas | 20065 | 51 | 1 |
668264 | 668264 | 2020-10-26 | Grant | Kansas | 20067 | 429 | 8 |
668265 | 668265 | 2020-10-26 | Gray | Kansas | 20069 | 180 | 0 |
668266 | 668266 | 2020-10-26 | Greeley | Kansas | 20071 | 34 | 0 |
668267 | 668267 | 2020-10-26 | Greenwood | Kansas | 20073 | 89 | 0 |
668268 | 668268 | 2020-10-26 | Hamilton | Kansas | 20075 | 69 | 0 |
668269 | 668269 | 2020-10-26 | Harper | Kansas | 20077 | 152 | 2 |
668270 | 668270 | 2020-10-26 | Harvey | Kansas | 20079 | 572 | 8 |
668271 | 668271 | 2020-10-26 | Haskell | Kansas | 20081 | 162 | 1 |
668272 | 668272 | 2020-10-26 | Hodgeman | Kansas | 20083 | 33 | 0 |
668273 | 668273 | 2020-10-26 | Jackson | Kansas | 20085 | 319 | 4 |
668274 | 668274 | 2020-10-26 | Jefferson | Kansas | 20087 | 271 | 4 |
668275 | 668275 | 2020-10-26 | Jewell | Kansas | 20089 | 29 | 1 |
668276 | 668276 | 2020-10-26 | Johnson | Kansas | 20091 | 14581 | 192 |
668277 | 668277 | 2020-10-26 | Kearny | Kansas | 20093 | 159 | 6 |
668278 | 668278 | 2020-10-26 | Kingman | Kansas | 20095 | 137 | 3 |
668279 | 668279 | 2020-10-26 | Kiowa | Kansas | 20097 | 62 | 0 |
668280 | 668280 | 2020-10-26 | Labette | Kansas | 20099 | 384 | 6 |
668281 | 668281 | 2020-10-26 | Lane | Kansas | 20101 | 24 | 1 |
668282 | 668282 | 2020-10-26 | Leavenworth | Kansas | 20103 | 2613 | 18 |
668283 | 668283 | 2020-10-26 | Lincoln | Kansas | 20105 | 22 | 1 |
668284 | 668284 | 2020-10-26 | Linn | Kansas | 20107 | 123 | 1 |
668285 | 668285 | 2020-10-26 | Logan | Kansas | 20109 | 93 | 0 |
668286 | 668286 | 2020-10-26 | Lyon | Kansas | 20111 | 1243 | 40 |
668287 | 668287 | 2020-10-26 | Marion | Kansas | 20115 | 164 | 1 |
668288 | 668288 | 2020-10-26 | Marshall | Kansas | 20117 | 73 | 0 |
668289 | 668289 | 2020-10-26 | McPherson | Kansas | 20113 | 373 | 6 |
668290 | 668290 | 2020-10-26 | Meade | Kansas | 20119 | 162 | 2 |
668291 | 668291 | 2020-10-26 | Miami | Kansas | 20121 | 539 | 2 |
668292 | 668292 | 2020-10-26 | Mitchell | Kansas | 20123 | 57 | 0 |
668293 | 668293 | 2020-10-26 | Montgomery | Kansas | 20125 | 689 | 6 |
668294 | 668294 | 2020-10-26 | Morris | Kansas | 20127 | 60 | 0 |
668295 | 668295 | 2020-10-26 | Morton | Kansas | 20129 | 55 | 2 |
668296 | 668296 | 2020-10-26 | Nemaha | Kansas | 20131 | 307 | 1 |
668297 | 668297 | 2020-10-26 | Neosho | Kansas | 20133 | 239 | 0 |
668298 | 668298 | 2020-10-26 | Ness | Kansas | 20135 | 148 | 9 |
668299 | 668299 | 2020-10-26 | Norton | Kansas | 20137 | 576 | 14 |
668300 | 668300 | 2020-10-26 | Osage | Kansas | 20139 | 163 | 2 |
668301 | 668301 | 2020-10-26 | Osborne | Kansas | 20141 | 26 | 0 |
668302 | 668302 | 2020-10-26 | Ottawa | Kansas | 20143 | 113 | 0 |
668303 | 668303 | 2020-10-26 | Pawnee | Kansas | 20145 | 431 | 1 |
668304 | 668304 | 2020-10-26 | Phillips | Kansas | 20147 | 193 | 9 |
668305 | 668305 | 2020-10-26 | Pottawatomie | Kansas | 20149 | 381 | 0 |
668306 | 668306 | 2020-10-26 | Pratt | Kansas | 20151 | 123 | 0 |
668307 | 668307 | 2020-10-26 | Rawlins | Kansas | 20153 | 144 | 0 |
668308 | 668308 | 2020-10-26 | Reno | Kansas | 20155 | 2095 | 15 |
668309 | 668309 | 2020-10-26 | Republic | Kansas | 20157 | 79 | 1 |
668310 | 668310 | 2020-10-26 | Rice | Kansas | 20159 | 141 | 1 |
668311 | 668311 | 2020-10-26 | Riley | Kansas | 20161 | 2084 | 11 |
668312 | 668312 | 2020-10-26 | Rooks | Kansas | 20163 | 151 | 7 |
668313 | 668313 | 2020-10-26 | Rush | Kansas | 20165 | 101 | 0 |
668314 | 668314 | 2020-10-26 | Russell | Kansas | 20167 | 179 | 4 |
668315 | 668315 | 2020-10-26 | Saline | Kansas | 20169 | 1087 | 13 |
668316 | 668316 | 2020-10-26 | Scott | Kansas | 20171 | 203 | 1 |
668317 | 668317 | 2020-10-26 | Sedgwick | Kansas | 20173 | 12004 | 127 |
668318 | 668318 | 2020-10-26 | Seward | Kansas | 20175 | 2081 | 13 |
668319 | 668319 | 2020-10-26 | Shawnee | Kansas | 20177 | 3495 | 82 |
668320 | 668320 | 2020-10-26 | Sheridan | Kansas | 20179 | 162 | 0 |
668321 | 668321 | 2020-10-26 | Sherman | Kansas | 20181 | 218 | 4 |
668322 | 668322 | 2020-10-26 | Smith | Kansas | 20183 | 22 | 0 |
668323 | 668323 | 2020-10-26 | Stafford | Kansas | 20185 | 81 | 1 |
668324 | 668324 | 2020-10-26 | Stanton | Kansas | 20187 | 97 | 2 |
668325 | 668325 | 2020-10-26 | Stevens | Kansas | 20189 | 227 | 1 |
668326 | 668326 | 2020-10-26 | Sumner | Kansas | 20191 | 306 | 4 |
668327 | 668327 | 2020-10-26 | Thomas | Kansas | 20193 | 331 | 2 |
668328 | 668328 | 2020-10-26 | Trego | Kansas | 20195 | 99 | 3 |
668329 | 668329 | 2020-10-26 | Unknown | Kansas | 0 | 4 | |
668330 | 668330 | 2020-10-26 | Wabaunsee | Kansas | 20197 | 87 | 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);