ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2020-12-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 |
---|---|---|---|---|---|---|---|
866162 | 866162 | 2020-12-26 | Allen | Kansas | 20001 | 593 | 1 |
866163 | 866163 | 2020-12-26 | Anderson | Kansas | 20003 | 493 | 0 |
866164 | 866164 | 2020-12-26 | Atchison | Kansas | 20005 | 1178 | 10 |
866165 | 866165 | 2020-12-26 | Barber | Kansas | 20007 | 259 | 2 |
866166 | 866166 | 2020-12-26 | Barton | Kansas | 20009 | 2106 | 19 |
866167 | 866167 | 2020-12-26 | Bourbon | Kansas | 20011 | 834 | 3 |
866168 | 866168 | 2020-12-26 | Brown | Kansas | 20013 | 977 | 18 |
866169 | 866169 | 2020-12-26 | Butler | Kansas | 20015 | 4897 | 18 |
866170 | 866170 | 2020-12-26 | Chase | Kansas | 20017 | 226 | 3 |
866171 | 866171 | 2020-12-26 | Chautauqua | Kansas | 20019 | 143 | 3 |
866172 | 866172 | 2020-12-26 | Cherokee | Kansas | 20021 | 1604 | 15 |
866173 | 866173 | 2020-12-26 | Cheyenne | Kansas | 20023 | 266 | 10 |
866174 | 866174 | 2020-12-26 | Clark | Kansas | 20025 | 183 | 4 |
866175 | 866175 | 2020-12-26 | Clay | Kansas | 20027 | 582 | 17 |
866176 | 866176 | 2020-12-26 | Cloud | Kansas | 20029 | 822 | 2 |
866177 | 866177 | 2020-12-26 | Coffey | Kansas | 20031 | 473 | 10 |
866178 | 866178 | 2020-12-26 | Comanche | Kansas | 20033 | 138 | 4 |
866179 | 866179 | 2020-12-26 | Cowley | Kansas | 20035 | 2328 | 9 |
866180 | 866180 | 2020-12-26 | Crawford | Kansas | 20037 | 3159 | 27 |
866181 | 866181 | 2020-12-26 | Decatur | Kansas | 20039 | 228 | 1 |
866182 | 866182 | 2020-12-26 | Dickinson | Kansas | 20041 | 1129 | 14 |
866183 | 866183 | 2020-12-26 | Doniphan | Kansas | 20043 | 673 | 5 |
866184 | 866184 | 2020-12-26 | Douglas | Kansas | 20045 | 6146 | 31 |
866185 | 866185 | 2020-12-26 | Edwards | Kansas | 20047 | 229 | 0 |
866186 | 866186 | 2020-12-26 | Elk | Kansas | 20049 | 96 | 0 |
866187 | 866187 | 2020-12-26 | Ellis | Kansas | 20051 | 3132 | 34 |
866188 | 866188 | 2020-12-26 | Ellsworth | Kansas | 20053 | 1012 | 4 |
866189 | 866189 | 2020-12-26 | Finney | Kansas | 20055 | 5378 | 35 |
866190 | 866190 | 2020-12-26 | Ford | Kansas | 20057 | 5039 | 10 |
866191 | 866191 | 2020-12-26 | Franklin | Kansas | 20059 | 1594 | 18 |
866192 | 866192 | 2020-12-26 | Geary | Kansas | 20061 | 1622 | 11 |
866193 | 866193 | 2020-12-26 | Gove | Kansas | 20063 | 329 | 20 |
866194 | 866194 | 2020-12-26 | Graham | Kansas | 20065 | 202 | 2 |
866195 | 866195 | 2020-12-26 | Grant | Kansas | 20067 | 907 | 14 |
866196 | 866196 | 2020-12-26 | Gray | Kansas | 20069 | 523 | 7 |
866197 | 866197 | 2020-12-26 | Greeley | Kansas | 20071 | 89 | 0 |
866198 | 866198 | 2020-12-26 | Greenwood | Kansas | 20073 | 435 | 2 |
866199 | 866199 | 2020-12-26 | Hamilton | Kansas | 20075 | 182 | 0 |
866200 | 866200 | 2020-12-26 | Harper | Kansas | 20077 | 404 | 15 |
866201 | 866201 | 2020-12-26 | Harvey | Kansas | 20079 | 2444 | 26 |
866202 | 866202 | 2020-12-26 | Haskell | Kansas | 20081 | 356 | 1 |
866203 | 866203 | 2020-12-26 | Hodgeman | Kansas | 20083 | 157 | 4 |
866204 | 866204 | 2020-12-26 | Jackson | Kansas | 20085 | 991 | 10 |
866205 | 866205 | 2020-12-26 | Jefferson | Kansas | 20087 | 1087 | 10 |
866206 | 866206 | 2020-12-26 | Jewell | Kansas | 20089 | 193 | 2 |
866207 | 866207 | 2020-12-26 | Johnson | Kansas | 20091 | 36727 | 413 |
866208 | 866208 | 2020-12-26 | Kearny | Kansas | 20093 | 485 | 8 |
866209 | 866209 | 2020-12-26 | Kingman | Kansas | 20095 | 535 | 7 |
866210 | 866210 | 2020-12-26 | Kiowa | Kansas | 20097 | 178 | 0 |
866211 | 866211 | 2020-12-26 | Labette | Kansas | 20099 | 1679 | 10 |
866212 | 866212 | 2020-12-26 | Lane | Kansas | 20101 | 118 | 5 |
866213 | 866213 | 2020-12-26 | Leavenworth | Kansas | 20103 | 4823 | 38 |
866214 | 866214 | 2020-12-26 | Lincoln | Kansas | 20105 | 184 | 1 |
866215 | 866215 | 2020-12-26 | Linn | Kansas | 20107 | 498 | 4 |
866216 | 866216 | 2020-12-26 | Logan | Kansas | 20109 | 267 | 0 |
866217 | 866217 | 2020-12-26 | Lyon | Kansas | 20111 | 3255 | 57 |
866218 | 866218 | 2020-12-26 | Marion | Kansas | 20115 | 636 | 4 |
866219 | 866219 | 2020-12-26 | Marshall | Kansas | 20117 | 810 | 21 |
866220 | 866220 | 2020-12-26 | McPherson | Kansas | 20113 | 2239 | 22 |
866221 | 866221 | 2020-12-26 | Meade | Kansas | 20119 | 380 | 4 |
866222 | 866222 | 2020-12-26 | Miami | Kansas | 20121 | 1618 | 7 |
866223 | 866223 | 2020-12-26 | Mitchell | Kansas | 20123 | 361 | 0 |
866224 | 866224 | 2020-12-26 | Montgomery | Kansas | 20125 | 1985 | 6 |
866225 | 866225 | 2020-12-26 | Morris | Kansas | 20127 | 373 | 2 |
866226 | 866226 | 2020-12-26 | Morton | Kansas | 20129 | 201 | 8 |
866227 | 866227 | 2020-12-26 | Nemaha | Kansas | 20131 | 1309 | 45 |
866228 | 866228 | 2020-12-26 | Neosho | Kansas | 20133 | 1077 | 11 |
866229 | 866229 | 2020-12-26 | Ness | Kansas | 20135 | 323 | 15 |
866230 | 866230 | 2020-12-26 | Norton | Kansas | 20137 | 1171 | 24 |
866231 | 866231 | 2020-12-26 | Osage | Kansas | 20139 | 764 | 6 |
866232 | 866232 | 2020-12-26 | Osborne | Kansas | 20141 | 148 | 0 |
866233 | 866233 | 2020-12-26 | Ottawa | Kansas | 20143 | 390 | 0 |
866234 | 866234 | 2020-12-26 | Pawnee | Kansas | 20145 | 954 | 1 |
866235 | 866235 | 2020-12-26 | Phillips | Kansas | 20147 | 561 | 12 |
866236 | 866236 | 2020-12-26 | Pottawatomie | Kansas | 20149 | 990 | 3 |
866237 | 866237 | 2020-12-26 | Pratt | Kansas | 20151 | 666 | 17 |
866238 | 866238 | 2020-12-26 | Rawlins | Kansas | 20153 | 306 | 3 |
866239 | 866239 | 2020-12-26 | Reno | Kansas | 20155 | 6724 | 91 |
866240 | 866240 | 2020-12-26 | Republic | Kansas | 20157 | 537 | 11 |
866241 | 866241 | 2020-12-26 | Rice | Kansas | 20159 | 733 | 1 |
866242 | 866242 | 2020-12-26 | Riley | Kansas | 20161 | 4673 | 20 |
866243 | 866243 | 2020-12-26 | Rooks | Kansas | 20163 | 446 | 9 |
866244 | 866244 | 2020-12-26 | Rush | Kansas | 20165 | 333 | 0 |
866245 | 866245 | 2020-12-26 | Russell | Kansas | 20167 | 705 | 17 |
866246 | 866246 | 2020-12-26 | Saline | Kansas | 20169 | 4032 | 48 |
866247 | 866247 | 2020-12-26 | Scott | Kansas | 20171 | 537 | 13 |
866248 | 866248 | 2020-12-26 | Sedgwick | Kansas | 20173 | 36975 | 256 |
866249 | 866249 | 2020-12-26 | Seward | Kansas | 20175 | 3491 | 20 |
866250 | 866250 | 2020-12-26 | Shawnee | Kansas | 20177 | 10896 | 195 |
866251 | 866251 | 2020-12-26 | Sheridan | Kansas | 20179 | 370 | 0 |
866252 | 866252 | 2020-12-26 | Sherman | Kansas | 20181 | 537 | 7 |
866253 | 866253 | 2020-12-26 | Smith | Kansas | 20183 | 199 | 1 |
866254 | 866254 | 2020-12-26 | Stafford | Kansas | 20185 | 265 | 7 |
866255 | 866255 | 2020-12-26 | Stanton | Kansas | 20187 | 159 | 2 |
866256 | 866256 | 2020-12-26 | Stevens | Kansas | 20189 | 505 | 5 |
866257 | 866257 | 2020-12-26 | Sumner | Kansas | 20191 | 1259 | 13 |
866258 | 866258 | 2020-12-26 | Thomas | Kansas | 20193 | 890 | 7 |
866259 | 866259 | 2020-12-26 | Trego | Kansas | 20195 | 282 | 3 |
866260 | 866260 | 2020-12-26 | Unknown | Kansas | 0 | 369 | |
866261 | 866261 | 2020-12-26 | Wabaunsee | Kansas | 20197 | 387 | 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);