ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,294 rows where state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 20091 364
- 20209 360
- 20015 358
- 20059 357
- 20045 354
- 20057 354
- 20103 353
- 20021 352
- 20107 352
- 20127 352
- 20173 352
- 20155 351
- 20161 351
- 20085 349
- 20123 349
- 20011 348
- 20111 348
- 20207 348
- 20043 347
- 20149 347
- 20037 346
- 20133 346
- 20177 346
- 20087 345
- 20191 345
- 20027 344
- 20031 344
- 20063 344
- 20079 344
- 20113 344
- …
county >30
- Johnson 364
- Wyandotte 360
- Butler 358
- Franklin 357
- Douglas 354
- Ford 354
- Leavenworth 353
- Cherokee 352
- Linn 352
- Morris 352
- Sedgwick 352
- Reno 351
- Riley 351
- Jackson 349
- Mitchell 349
- Bourbon 348
- Lyon 348
- Woodson 348
- Doniphan 347
- Pottawatomie 347
- Crawford 346
- Neosho 346
- Shawnee 346
- Jefferson 345
- Sumner 345
- Clay 344
- Coffey 344
- Gove 344
- Harvey 344
- McPherson 344
- …
state 1
- Kansas · 33,651 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093448 | 1093448 | 2021-03-06 | Wallace | Kansas | 20199 | 177 | 0 |
1093449 | 1093449 | 2021-03-06 | Washington | Kansas | 20201 | 528 | 9 |
1093450 | 1093450 | 2021-03-06 | Wichita | Kansas | 20203 | 215 | 0 |
1093451 | 1093451 | 2021-03-06 | Wilson | Kansas | 20205 | 956 | 12 |
1093452 | 1093452 | 2021-03-06 | Woodson | Kansas | 20207 | 205 | 0 |
1093453 | 1093453 | 2021-03-06 | Wyandotte | Kansas | 20209 | 19307 | 273 |
1090102 | 1090102 | 2021-03-05 | Allen | Kansas | 20001 | 1146 | 1 |
1090103 | 1090103 | 2021-03-05 | Anderson | Kansas | 20003 | 816 | 0 |
1090104 | 1090104 | 2021-03-05 | Atchison | Kansas | 20005 | 1531 | 13 |
1090105 | 1090105 | 2021-03-05 | Barber | Kansas | 20007 | 367 | 2 |
1090106 | 1090106 | 2021-03-05 | Barton | Kansas | 20009 | 2574 | 21 |
1090107 | 1090107 | 2021-03-05 | Bourbon | Kansas | 20011 | 1288 | 3 |
1090108 | 1090108 | 2021-03-05 | Brown | Kansas | 20013 | 1217 | 32 |
1090109 | 1090109 | 2021-03-05 | Butler | Kansas | 20015 | 7235 | 76 |
1090110 | 1090110 | 2021-03-05 | Chase | Kansas | 20017 | 285 | 3 |
1090111 | 1090111 | 2021-03-05 | Chautauqua | Kansas | 20019 | 260 | 3 |
1090112 | 1090112 | 2021-03-05 | Cherokee | Kansas | 20021 | 2369 | 16 |
1090113 | 1090113 | 2021-03-05 | Cheyenne | Kansas | 20023 | 354 | 10 |
1090114 | 1090114 | 2021-03-05 | Clark | Kansas | 20025 | 244 | 4 |
1090115 | 1090115 | 2021-03-05 | Clay | Kansas | 20027 | 824 | 27 |
1090116 | 1090116 | 2021-03-05 | Cloud | Kansas | 20029 | 969 | 2 |
1090117 | 1090117 | 2021-03-05 | Coffey | Kansas | 20031 | 712 | 14 |
1090118 | 1090118 | 2021-03-05 | Comanche | Kansas | 20033 | 159 | 9 |
1090119 | 1090119 | 2021-03-05 | Cowley | Kansas | 20035 | 3824 | 9 |
1090120 | 1090120 | 2021-03-05 | Crawford | Kansas | 20037 | 4537 | 80 |
1090121 | 1090121 | 2021-03-05 | Decatur | Kansas | 20039 | 259 | 1 |
1090122 | 1090122 | 2021-03-05 | Dickinson | Kansas | 20041 | 1691 | 36 |
1090123 | 1090123 | 2021-03-05 | Doniphan | Kansas | 20043 | 945 | 7 |
1090124 | 1090124 | 2021-03-05 | Douglas | Kansas | 20045 | 8679 | 79 |
1090125 | 1090125 | 2021-03-05 | Edwards | Kansas | 20047 | 262 | 0 |
1090126 | 1090126 | 2021-03-05 | Elk | Kansas | 20049 | 176 | 0 |
1090127 | 1090127 | 2021-03-05 | Ellis | Kansas | 20051 | 3692 | 61 |
1090128 | 1090128 | 2021-03-05 | Ellsworth | Kansas | 20053 | 1211 | 4 |
1090129 | 1090129 | 2021-03-05 | Finney | Kansas | 20055 | 5989 | 49 |
1090130 | 1090130 | 2021-03-05 | Ford | Kansas | 20057 | 5592 | 10 |
1090131 | 1090131 | 2021-03-05 | Franklin | Kansas | 20059 | 2456 | 39 |
1090132 | 1090132 | 2021-03-05 | Geary | Kansas | 20061 | 3063 | 25 |
1090133 | 1090133 | 2021-03-05 | Gove | Kansas | 20063 | 385 | 22 |
1090134 | 1090134 | 2021-03-05 | Graham | Kansas | 20065 | 250 | 2 |
1090135 | 1090135 | 2021-03-05 | Grant | Kansas | 20067 | 966 | 17 |
1090136 | 1090136 | 2021-03-05 | Gray | Kansas | 20069 | 602 | 14 |
1090137 | 1090137 | 2021-03-05 | Greeley | Kansas | 20071 | 101 | 0 |
1090138 | 1090138 | 2021-03-05 | Greenwood | Kansas | 20073 | 587 | 7 |
1090139 | 1090139 | 2021-03-05 | Hamilton | Kansas | 20075 | 201 | 0 |
1090140 | 1090140 | 2021-03-05 | Harper | Kansas | 20077 | 605 | 17 |
1090141 | 1090141 | 2021-03-05 | Harvey | Kansas | 20079 | 3436 | 59 |
1090142 | 1090142 | 2021-03-05 | Haskell | Kansas | 20081 | 408 | 1 |
1090143 | 1090143 | 2021-03-05 | Hodgeman | Kansas | 20083 | 206 | 6 |
1090144 | 1090144 | 2021-03-05 | Jackson | Kansas | 20085 | 1339 | 15 |
1090145 | 1090145 | 2021-03-05 | Jefferson | Kansas | 20087 | 1623 | 32 |
1090146 | 1090146 | 2021-03-05 | Jewell | Kansas | 20089 | 202 | 3 |
1090147 | 1090147 | 2021-03-05 | Johnson | Kansas | 20091 | 54730 | 640 |
1090148 | 1090148 | 2021-03-05 | Kearny | Kansas | 20093 | 561 | 9 |
1090149 | 1090149 | 2021-03-05 | Kingman | Kansas | 20095 | 729 | 11 |
1090150 | 1090150 | 2021-03-05 | Kiowa | Kansas | 20097 | 266 | 5 |
1090151 | 1090151 | 2021-03-05 | Labette | Kansas | 20099 | 2621 | 48 |
1090152 | 1090152 | 2021-03-05 | Lane | Kansas | 20101 | 142 | 5 |
1090153 | 1090153 | 2021-03-05 | Leavenworth | Kansas | 20103 | 6833 | 50 |
1090154 | 1090154 | 2021-03-05 | Lincoln | Kansas | 20105 | 256 | 4 |
1090155 | 1090155 | 2021-03-05 | Linn | Kansas | 20107 | 767 | 12 |
1090156 | 1090156 | 2021-03-05 | Logan | Kansas | 20109 | 292 | 0 |
1090157 | 1090157 | 2021-03-05 | Lyon | Kansas | 20111 | 4115 | 81 |
1090158 | 1090158 | 2021-03-05 | Marion | Kansas | 20115 | 1029 | 24 |
1090159 | 1090159 | 2021-03-05 | Marshall | Kansas | 20117 | 1074 | 23 |
1090160 | 1090160 | 2021-03-05 | McPherson | Kansas | 20113 | 3166 | 81 |
1090161 | 1090161 | 2021-03-05 | Meade | Kansas | 20119 | 495 | 9 |
1090162 | 1090162 | 2021-03-05 | Miami | Kansas | 20121 | 2650 | 25 |
1090163 | 1090163 | 2021-03-05 | Mitchell | Kansas | 20123 | 559 | 0 |
1090164 | 1090164 | 2021-03-05 | Montgomery | Kansas | 20125 | 3310 | 6 |
1090165 | 1090165 | 2021-03-05 | Morris | Kansas | 20127 | 598 | 20 |
1090166 | 1090166 | 2021-03-05 | Morton | Kansas | 20129 | 254 | 9 |
1090167 | 1090167 | 2021-03-05 | Nemaha | Kansas | 20131 | 1486 | 50 |
1090168 | 1090168 | 2021-03-05 | Neosho | Kansas | 20133 | 1761 | 22 |
1090169 | 1090169 | 2021-03-05 | Ness | Kansas | 20135 | 365 | 15 |
1090170 | 1090170 | 2021-03-05 | Norton | Kansas | 20137 | 1217 | 27 |
1090171 | 1090171 | 2021-03-05 | Osage | Kansas | 20139 | 1194 | 11 |
1090172 | 1090172 | 2021-03-05 | Osborne | Kansas | 20141 | 287 | 0 |
1090173 | 1090173 | 2021-03-05 | Ottawa | Kansas | 20143 | 548 | 0 |
1090174 | 1090174 | 2021-03-05 | Pawnee | Kansas | 20145 | 1137 | 14 |
1090175 | 1090175 | 2021-03-05 | Phillips | Kansas | 20147 | 705 | 19 |
1090176 | 1090176 | 2021-03-05 | Pottawatomie | Kansas | 20149 | 1772 | 27 |
1090177 | 1090177 | 2021-03-05 | Pratt | Kansas | 20151 | 807 | 23 |
1090178 | 1090178 | 2021-03-05 | Rawlins | Kansas | 20153 | 355 | 7 |
1090179 | 1090179 | 2021-03-05 | Reno | Kansas | 20155 | 8308 | 126 |
1090180 | 1090180 | 2021-03-05 | Republic | Kansas | 20157 | 679 | 14 |
1090181 | 1090181 | 2021-03-05 | Rice | Kansas | 20159 | 1059 | 1 |
1090182 | 1090182 | 2021-03-05 | Riley | Kansas | 20161 | 6216 | 33 |
1090183 | 1090183 | 2021-03-05 | Rooks | Kansas | 20163 | 639 | 10 |
1090184 | 1090184 | 2021-03-05 | Rush | Kansas | 20165 | 425 | 0 |
1090185 | 1090185 | 2021-03-05 | Russell | Kansas | 20167 | 845 | 23 |
1090186 | 1090186 | 2021-03-05 | Saline | Kansas | 20169 | 5993 | 106 |
1090187 | 1090187 | 2021-03-05 | Scott | Kansas | 20171 | 604 | 21 |
1090188 | 1090188 | 2021-03-05 | Sedgwick | Kansas | 20173 | 53962 | 532 |
1090189 | 1090189 | 2021-03-05 | Seward | Kansas | 20175 | 3893 | 33 |
1090190 | 1090190 | 2021-03-05 | Shawnee | Kansas | 20177 | 16478 | 344 |
1090191 | 1090191 | 2021-03-05 | Sheridan | Kansas | 20179 | 428 | 0 |
1090192 | 1090192 | 2021-03-05 | Sherman | Kansas | 20181 | 610 | 7 |
1090193 | 1090193 | 2021-03-05 | Smith | Kansas | 20183 | 271 | 2 |
1090194 | 1090194 | 2021-03-05 | Stafford | Kansas | 20185 | 346 | 9 |
1090195 | 1090195 | 2021-03-05 | Stanton | Kansas | 20187 | 184 | 2 |
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);