ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2021-02-17" 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 |
---|---|---|---|---|---|---|---|
1038172 | 1038172 | 2021-02-17 | Allen | Kansas | 20001 | 1077 | 1 |
1038173 | 1038173 | 2021-02-17 | Anderson | Kansas | 20003 | 801 | 0 |
1038174 | 1038174 | 2021-02-17 | Atchison | Kansas | 20005 | 1507 | 13 |
1038175 | 1038175 | 2021-02-17 | Barber | Kansas | 20007 | 365 | 2 |
1038176 | 1038176 | 2021-02-17 | Barton | Kansas | 20009 | 2553 | 21 |
1038177 | 1038177 | 2021-02-17 | Bourbon | Kansas | 20011 | 1267 | 3 |
1038178 | 1038178 | 2021-02-17 | Brown | Kansas | 20013 | 1193 | 32 |
1038179 | 1038179 | 2021-02-17 | Butler | Kansas | 20015 | 7071 | 60 |
1038180 | 1038180 | 2021-02-17 | Chase | Kansas | 20017 | 273 | 3 |
1038181 | 1038181 | 2021-02-17 | Chautauqua | Kansas | 20019 | 250 | 3 |
1038182 | 1038182 | 2021-02-17 | Cherokee | Kansas | 20021 | 2330 | 16 |
1038183 | 1038183 | 2021-02-17 | Cheyenne | Kansas | 20023 | 344 | 10 |
1038184 | 1038184 | 2021-02-17 | Clark | Kansas | 20025 | 233 | 4 |
1038185 | 1038185 | 2021-02-17 | Clay | Kansas | 20027 | 816 | 24 |
1038186 | 1038186 | 2021-02-17 | Cloud | Kansas | 20029 | 959 | 2 |
1038187 | 1038187 | 2021-02-17 | Coffey | Kansas | 20031 | 700 | 13 |
1038188 | 1038188 | 2021-02-17 | Comanche | Kansas | 20033 | 155 | 9 |
1038189 | 1038189 | 2021-02-17 | Cowley | Kansas | 20035 | 3745 | 9 |
1038190 | 1038190 | 2021-02-17 | Crawford | Kansas | 20037 | 4453 | 75 |
1038191 | 1038191 | 2021-02-17 | Decatur | Kansas | 20039 | 258 | 1 |
1038192 | 1038192 | 2021-02-17 | Dickinson | Kansas | 20041 | 1675 | 35 |
1038193 | 1038193 | 2021-02-17 | Doniphan | Kansas | 20043 | 926 | 7 |
1038194 | 1038194 | 2021-02-17 | Douglas | Kansas | 20045 | 8505 | 71 |
1038195 | 1038195 | 2021-02-17 | Edwards | Kansas | 20047 | 262 | 0 |
1038196 | 1038196 | 2021-02-17 | Elk | Kansas | 20049 | 167 | 0 |
1038197 | 1038197 | 2021-02-17 | Ellis | Kansas | 20051 | 3629 | 61 |
1038198 | 1038198 | 2021-02-17 | Ellsworth | Kansas | 20053 | 1202 | 4 |
1038199 | 1038199 | 2021-02-17 | Finney | Kansas | 20055 | 5958 | 48 |
1038200 | 1038200 | 2021-02-17 | Ford | Kansas | 20057 | 5533 | 10 |
1038201 | 1038201 | 2021-02-17 | Franklin | Kansas | 20059 | 2409 | 20 |
1038202 | 1038202 | 2021-02-17 | Geary | Kansas | 20061 | 2942 | 24 |
1038203 | 1038203 | 2021-02-17 | Gove | Kansas | 20063 | 375 | 22 |
1038204 | 1038204 | 2021-02-17 | Graham | Kansas | 20065 | 247 | 2 |
1038205 | 1038205 | 2021-02-17 | Grant | Kansas | 20067 | 963 | 17 |
1038206 | 1038206 | 2021-02-17 | Gray | Kansas | 20069 | 600 | 12 |
1038207 | 1038207 | 2021-02-17 | Greeley | Kansas | 20071 | 101 | 0 |
1038208 | 1038208 | 2021-02-17 | Greenwood | Kansas | 20073 | 570 | 2 |
1038209 | 1038209 | 2021-02-17 | Hamilton | Kansas | 20075 | 199 | 0 |
1038210 | 1038210 | 2021-02-17 | Harper | Kansas | 20077 | 599 | 17 |
1038211 | 1038211 | 2021-02-17 | Harvey | Kansas | 20079 | 3346 | 55 |
1038212 | 1038212 | 2021-02-17 | Haskell | Kansas | 20081 | 407 | 1 |
1038213 | 1038213 | 2021-02-17 | Hodgeman | Kansas | 20083 | 191 | 6 |
1038214 | 1038214 | 2021-02-17 | Jackson | Kansas | 20085 | 1324 | 11 |
1038215 | 1038215 | 2021-02-17 | Jefferson | Kansas | 20087 | 1596 | 28 |
1038216 | 1038216 | 2021-02-17 | Jewell | Kansas | 20089 | 194 | 3 |
1038217 | 1038217 | 2021-02-17 | Johnson | Kansas | 20091 | 52582 | 619 |
1038218 | 1038218 | 2021-02-17 | Kearny | Kansas | 20093 | 552 | 9 |
1038219 | 1038219 | 2021-02-17 | Kingman | Kansas | 20095 | 717 | 11 |
1038220 | 1038220 | 2021-02-17 | Kiowa | Kansas | 20097 | 266 | 5 |
1038221 | 1038221 | 2021-02-17 | Labette | Kansas | 20099 | 2562 | 44 |
1038222 | 1038222 | 2021-02-17 | Lane | Kansas | 20101 | 141 | 5 |
1038223 | 1038223 | 2021-02-17 | Leavenworth | Kansas | 20103 | 6632 | 48 |
1038224 | 1038224 | 2021-02-17 | Lincoln | Kansas | 20105 | 254 | 4 |
1038225 | 1038225 | 2021-02-17 | Linn | Kansas | 20107 | 745 | 7 |
1038226 | 1038226 | 2021-02-17 | Logan | Kansas | 20109 | 291 | 0 |
1038227 | 1038227 | 2021-02-17 | Lyon | Kansas | 20111 | 4017 | 75 |
1038228 | 1038228 | 2021-02-17 | Marion | Kansas | 20115 | 1006 | 16 |
1038229 | 1038229 | 2021-02-17 | Marshall | Kansas | 20117 | 1070 | 23 |
1038230 | 1038230 | 2021-02-17 | McPherson | Kansas | 20113 | 3090 | 71 |
1038231 | 1038231 | 2021-02-17 | Meade | Kansas | 20119 | 484 | 7 |
1038232 | 1038232 | 2021-02-17 | Miami | Kansas | 20121 | 2581 | 25 |
1038233 | 1038233 | 2021-02-17 | Mitchell | Kansas | 20123 | 555 | 0 |
1038234 | 1038234 | 2021-02-17 | Montgomery | Kansas | 20125 | 3197 | 6 |
1038235 | 1038235 | 2021-02-17 | Morris | Kansas | 20127 | 581 | 17 |
1038236 | 1038236 | 2021-02-17 | Morton | Kansas | 20129 | 249 | 9 |
1038237 | 1038237 | 2021-02-17 | Nemaha | Kansas | 20131 | 1460 | 50 |
1038238 | 1038238 | 2021-02-17 | Neosho | Kansas | 20133 | 1696 | 18 |
1038239 | 1038239 | 2021-02-17 | Ness | Kansas | 20135 | 361 | 15 |
1038240 | 1038240 | 2021-02-17 | Norton | Kansas | 20137 | 1214 | 27 |
1038241 | 1038241 | 2021-02-17 | Osage | Kansas | 20139 | 1170 | 11 |
1038242 | 1038242 | 2021-02-17 | Osborne | Kansas | 20141 | 284 | 0 |
1038243 | 1038243 | 2021-02-17 | Ottawa | Kansas | 20143 | 548 | 0 |
1038244 | 1038244 | 2021-02-17 | Pawnee | Kansas | 20145 | 1130 | 14 |
1038245 | 1038245 | 2021-02-17 | Phillips | Kansas | 20147 | 685 | 18 |
1038246 | 1038246 | 2021-02-17 | Pottawatomie | Kansas | 20149 | 1713 | 23 |
1038247 | 1038247 | 2021-02-17 | Pratt | Kansas | 20151 | 799 | 23 |
1038248 | 1038248 | 2021-02-17 | Rawlins | Kansas | 20153 | 348 | 7 |
1038249 | 1038249 | 2021-02-17 | Reno | Kansas | 20155 | 8231 | 126 |
1038250 | 1038250 | 2021-02-17 | Republic | Kansas | 20157 | 676 | 14 |
1038251 | 1038251 | 2021-02-17 | Rice | Kansas | 20159 | 1038 | 1 |
1038252 | 1038252 | 2021-02-17 | Riley | Kansas | 20161 | 6148 | 32 |
1038253 | 1038253 | 2021-02-17 | Rooks | Kansas | 20163 | 620 | 10 |
1038254 | 1038254 | 2021-02-17 | Rush | Kansas | 20165 | 423 | 0 |
1038255 | 1038255 | 2021-02-17 | Russell | Kansas | 20167 | 832 | 23 |
1038256 | 1038256 | 2021-02-17 | Saline | Kansas | 20169 | 5883 | 104 |
1038257 | 1038257 | 2021-02-17 | Scott | Kansas | 20171 | 599 | 16 |
1038258 | 1038258 | 2021-02-17 | Sedgwick | Kansas | 20173 | 52832 | 454 |
1038259 | 1038259 | 2021-02-17 | Seward | Kansas | 20175 | 3859 | 29 |
1038260 | 1038260 | 2021-02-17 | Shawnee | Kansas | 20177 | 16066 | 320 |
1038261 | 1038261 | 2021-02-17 | Sheridan | Kansas | 20179 | 426 | 0 |
1038262 | 1038262 | 2021-02-17 | Sherman | Kansas | 20181 | 602 | 7 |
1038263 | 1038263 | 2021-02-17 | Smith | Kansas | 20183 | 271 | 2 |
1038264 | 1038264 | 2021-02-17 | Stafford | Kansas | 20185 | 341 | 9 |
1038265 | 1038265 | 2021-02-17 | Stanton | Kansas | 20187 | 181 | 2 |
1038266 | 1038266 | 2021-02-17 | Stevens | Kansas | 20189 | 580 | 7 |
1038267 | 1038267 | 2021-02-17 | Sumner | Kansas | 20191 | 2056 | 27 |
1038268 | 1038268 | 2021-02-17 | Thomas | Kansas | 20193 | 1094 | 13 |
1038269 | 1038269 | 2021-02-17 | Trego | Kansas | 20195 | 403 | 3 |
1038270 | 1038270 | 2021-02-17 | Unknown | Kansas | 0 | 1077 | |
1038271 | 1038271 | 2021-02-17 | Wabaunsee | Kansas | 20197 | 641 | 13 |
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);