ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where date = "2020-11-03" 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 |
---|---|---|---|---|---|---|---|
694177 | 694177 | 2020-11-03 | Allen | Kansas | 20001 | 128 | 1 |
694178 | 694178 | 2020-11-03 | Anderson | Kansas | 20003 | 231 | 0 |
694179 | 694179 | 2020-11-03 | Atchison | Kansas | 20005 | 537 | 6 |
694180 | 694180 | 2020-11-03 | Barber | Kansas | 20007 | 88 | 0 |
694181 | 694181 | 2020-11-03 | Barton | Kansas | 20009 | 821 | 7 |
694182 | 694182 | 2020-11-03 | Bourbon | Kansas | 20011 | 315 | 3 |
694183 | 694183 | 2020-11-03 | Brown | Kansas | 20013 | 280 | 6 |
694184 | 694184 | 2020-11-03 | Butler | Kansas | 20015 | 1658 | 3 |
694185 | 694185 | 2020-11-03 | Chase | Kansas | 20017 | 118 | 3 |
694186 | 694186 | 2020-11-03 | Chautauqua | Kansas | 20019 | 32 | 0 |
694187 | 694187 | 2020-11-03 | Cherokee | Kansas | 20021 | 744 | 8 |
694188 | 694188 | 2020-11-03 | Cheyenne | Kansas | 20023 | 141 | 6 |
694189 | 694189 | 2020-11-03 | Clark | Kansas | 20025 | 75 | 4 |
694190 | 694190 | 2020-11-03 | Clay | Kansas | 20027 | 131 | 3 |
694191 | 694191 | 2020-11-03 | Cloud | Kansas | 20029 | 201 | 1 |
694192 | 694192 | 2020-11-03 | Coffey | Kansas | 20031 | 184 | 9 |
694193 | 694193 | 2020-11-03 | Comanche | Kansas | 20033 | 23 | 0 |
694194 | 694194 | 2020-11-03 | Cowley | Kansas | 20035 | 608 | 1 |
694195 | 694195 | 2020-11-03 | Crawford | Kansas | 20037 | 1546 | 12 |
694196 | 694196 | 2020-11-03 | Decatur | Kansas | 20039 | 146 | 1 |
694197 | 694197 | 2020-11-03 | Dickinson | Kansas | 20041 | 380 | 5 |
694198 | 694198 | 2020-11-03 | Doniphan | Kansas | 20043 | 219 | 0 |
694199 | 694199 | 2020-11-03 | Douglas | Kansas | 20045 | 3051 | 19 |
694200 | 694200 | 2020-11-03 | Edwards | Kansas | 20047 | 84 | 0 |
694201 | 694201 | 2020-11-03 | Elk | Kansas | 20049 | 16 | 0 |
694202 | 694202 | 2020-11-03 | Ellis | Kansas | 20051 | 1479 | 18 |
694203 | 694203 | 2020-11-03 | Ellsworth | Kansas | 20053 | 409 | 1 |
694204 | 694204 | 2020-11-03 | Finney | Kansas | 20055 | 3228 | 20 |
694205 | 694205 | 2020-11-03 | Ford | Kansas | 20057 | 3548 | 10 |
694206 | 694206 | 2020-11-03 | Franklin | Kansas | 20059 | 621 | 5 |
694207 | 694207 | 2020-11-03 | Geary | Kansas | 20061 | 597 | 4 |
694208 | 694208 | 2020-11-03 | Gove | Kansas | 20063 | 211 | 16 |
694209 | 694209 | 2020-11-03 | Graham | Kansas | 20065 | 62 | 2 |
694210 | 694210 | 2020-11-03 | Grant | Kansas | 20067 | 486 | 8 |
694211 | 694211 | 2020-11-03 | Gray | Kansas | 20069 | 214 | 2 |
694212 | 694212 | 2020-11-03 | Greeley | Kansas | 20071 | 48 | 0 |
694213 | 694213 | 2020-11-03 | Greenwood | Kansas | 20073 | 130 | 0 |
694214 | 694214 | 2020-11-03 | Hamilton | Kansas | 20075 | 72 | 0 |
694215 | 694215 | 2020-11-03 | Harper | Kansas | 20077 | 172 | 3 |
694216 | 694216 | 2020-11-03 | Harvey | Kansas | 20079 | 744 | 9 |
694217 | 694217 | 2020-11-03 | Haskell | Kansas | 20081 | 181 | 1 |
694218 | 694218 | 2020-11-03 | Hodgeman | Kansas | 20083 | 50 | 0 |
694219 | 694219 | 2020-11-03 | Jackson | Kansas | 20085 | 360 | 4 |
694220 | 694220 | 2020-11-03 | Jefferson | Kansas | 20087 | 325 | 6 |
694221 | 694221 | 2020-11-03 | Jewell | Kansas | 20089 | 31 | 1 |
694222 | 694222 | 2020-11-03 | Johnson | Kansas | 20091 | 16522 | 219 |
694223 | 694223 | 2020-11-03 | Kearny | Kansas | 20093 | 164 | 6 |
694224 | 694224 | 2020-11-03 | Kingman | Kansas | 20095 | 162 | 3 |
694225 | 694225 | 2020-11-03 | Kiowa | Kansas | 20097 | 67 | 0 |
694226 | 694226 | 2020-11-03 | Labette | Kansas | 20099 | 432 | 6 |
694227 | 694227 | 2020-11-03 | Lane | Kansas | 20101 | 34 | 1 |
694228 | 694228 | 2020-11-03 | Leavenworth | Kansas | 20103 | 2736 | 20 |
694229 | 694229 | 2020-11-03 | Lincoln | Kansas | 20105 | 24 | 1 |
694230 | 694230 | 2020-11-03 | Linn | Kansas | 20107 | 148 | 1 |
694231 | 694231 | 2020-11-03 | Logan | Kansas | 20109 | 133 | 0 |
694232 | 694232 | 2020-11-03 | Lyon | Kansas | 20111 | 1381 | 41 |
694233 | 694233 | 2020-11-03 | Marion | Kansas | 20115 | 193 | 1 |
694234 | 694234 | 2020-11-03 | Marshall | Kansas | 20117 | 117 | 0 |
694235 | 694235 | 2020-11-03 | McPherson | Kansas | 20113 | 522 | 7 |
694236 | 694236 | 2020-11-03 | Meade | Kansas | 20119 | 177 | 2 |
694237 | 694237 | 2020-11-03 | Miami | Kansas | 20121 | 603 | 2 |
694238 | 694238 | 2020-11-03 | Mitchell | Kansas | 20123 | 62 | 0 |
694239 | 694239 | 2020-11-03 | Montgomery | Kansas | 20125 | 736 | 6 |
694240 | 694240 | 2020-11-03 | Morris | Kansas | 20127 | 81 | 0 |
694241 | 694241 | 2020-11-03 | Morton | Kansas | 20129 | 72 | 3 |
694242 | 694242 | 2020-11-03 | Nemaha | Kansas | 20131 | 418 | 4 |
694243 | 694243 | 2020-11-03 | Neosho | Kansas | 20133 | 319 | 0 |
694244 | 694244 | 2020-11-03 | Ness | Kansas | 20135 | 169 | 9 |
694245 | 694245 | 2020-11-03 | Norton | Kansas | 20137 | 778 | 18 |
694246 | 694246 | 2020-11-03 | Osage | Kansas | 20139 | 182 | 4 |
694247 | 694247 | 2020-11-03 | Osborne | Kansas | 20141 | 41 | 0 |
694248 | 694248 | 2020-11-03 | Ottawa | Kansas | 20143 | 129 | 0 |
694249 | 694249 | 2020-11-03 | Pawnee | Kansas | 20145 | 440 | 1 |
694250 | 694250 | 2020-11-03 | Phillips | Kansas | 20147 | 234 | 9 |
694251 | 694251 | 2020-11-03 | Pottawatomie | Kansas | 20149 | 420 | 0 |
694252 | 694252 | 2020-11-03 | Pratt | Kansas | 20151 | 205 | 0 |
694253 | 694253 | 2020-11-03 | Rawlins | Kansas | 20153 | 156 | 0 |
694254 | 694254 | 2020-11-03 | Reno | Kansas | 20155 | 2454 | 18 |
694255 | 694255 | 2020-11-03 | Republic | Kansas | 20157 | 91 | 1 |
694256 | 694256 | 2020-11-03 | Rice | Kansas | 20159 | 172 | 1 |
694257 | 694257 | 2020-11-03 | Riley | Kansas | 20161 | 2251 | 12 |
694258 | 694258 | 2020-11-03 | Rooks | Kansas | 20163 | 171 | 7 |
694259 | 694259 | 2020-11-03 | Rush | Kansas | 20165 | 110 | 0 |
694260 | 694260 | 2020-11-03 | Russell | Kansas | 20167 | 224 | 5 |
694261 | 694261 | 2020-11-03 | Saline | Kansas | 20169 | 1225 | 13 |
694262 | 694262 | 2020-11-03 | Scott | Kansas | 20171 | 234 | 1 |
694263 | 694263 | 2020-11-03 | Sedgwick | Kansas | 20173 | 14189 | 135 |
694264 | 694264 | 2020-11-03 | Seward | Kansas | 20175 | 2200 | 13 |
694265 | 694265 | 2020-11-03 | Shawnee | Kansas | 20177 | 3981 | 85 |
694266 | 694266 | 2020-11-03 | Sheridan | Kansas | 20179 | 215 | 0 |
694267 | 694267 | 2020-11-03 | Sherman | Kansas | 20181 | 257 | 6 |
694268 | 694268 | 2020-11-03 | Smith | Kansas | 20183 | 34 | 0 |
694269 | 694269 | 2020-11-03 | Stafford | Kansas | 20185 | 100 | 1 |
694270 | 694270 | 2020-11-03 | Stanton | Kansas | 20187 | 106 | 2 |
694271 | 694271 | 2020-11-03 | Stevens | Kansas | 20189 | 255 | 1 |
694272 | 694272 | 2020-11-03 | Sumner | Kansas | 20191 | 368 | 4 |
694273 | 694273 | 2020-11-03 | Thomas | Kansas | 20193 | 410 | 2 |
694274 | 694274 | 2020-11-03 | Trego | Kansas | 20195 | 117 | 3 |
694275 | 694275 | 2020-11-03 | Wabaunsee | Kansas | 20197 | 100 | 1 |
694276 | 694276 | 2020-11-03 | Wallace | Kansas | 20199 | 82 | 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);