ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15,139 rows where deaths = 0 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 20123 392
- 20207 390
- 20143 387
- 20141 380
- 20075 372
- 20179 364
- 20047 361
- 20003 344
- 20109 298
- 20049 296
- 20165 293
- 20071 280
- 20203 270
- 20097 253
- 20133 251
- 20019 239
- 20149 239
- 20127 237
- 20199 237
- 20043 232
- 20007 229
- 20073 229
- 20151 229
- 20183 217
- 20107 209
- 20139 201
- 20033 196
- 20063 194
- 20083 193
- 20069 189
- …
county >30
- Mitchell 392
- Woodson 390
- Ottawa 387
- Osborne 380
- Hamilton 372
- Sheridan 364
- Edwards 361
- Anderson 344
- Logan 298
- Elk 296
- Rush 293
- Greeley 280
- Wichita 270
- Kiowa 253
- Neosho 251
- Chautauqua 239
- Pottawatomie 239
- Morris 237
- Wallace 237
- Doniphan 232
- Barber 229
- Greenwood 229
- Pratt 229
- Smith 217
- Linn 209
- Osage 201
- Comanche 196
- Gove 194
- Hodgeman 193
- Gray 189
- …
state 1
- Kansas · 15,139 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1229733 | 1229733 | 2021-04-17 | Anderson | Kansas | 20003 | 831 | 0 |
1229755 | 1229755 | 2021-04-17 | Edwards | Kansas | 20047 | 262 | 0 |
1229756 | 1229756 | 2021-04-17 | Elk | Kansas | 20049 | 179 | 0 |
1229767 | 1229767 | 2021-04-17 | Greeley | Kansas | 20071 | 104 | 0 |
1229769 | 1229769 | 2021-04-17 | Hamilton | Kansas | 20075 | 202 | 0 |
1229786 | 1229786 | 2021-04-17 | Logan | Kansas | 20109 | 292 | 0 |
1229793 | 1229793 | 2021-04-17 | Mitchell | Kansas | 20123 | 561 | 0 |
1229802 | 1229802 | 2021-04-17 | Osborne | Kansas | 20141 | 289 | 0 |
1229803 | 1229803 | 2021-04-17 | Ottawa | Kansas | 20143 | 550 | 0 |
1229814 | 1229814 | 2021-04-17 | Rush | Kansas | 20165 | 430 | 0 |
1229821 | 1229821 | 2021-04-17 | Sheridan | Kansas | 20179 | 432 | 0 |
1229832 | 1229832 | 2021-04-17 | Wallace | Kansas | 20199 | 178 | 0 |
1229834 | 1229834 | 2021-04-17 | Wichita | Kansas | 20203 | 216 | 0 |
1229836 | 1229836 | 2021-04-17 | Woodson | Kansas | 20207 | 216 | 0 |
1226485 | 1226485 | 2021-04-16 | Anderson | Kansas | 20003 | 831 | 0 |
1226507 | 1226507 | 2021-04-16 | Edwards | Kansas | 20047 | 262 | 0 |
1226508 | 1226508 | 2021-04-16 | Elk | Kansas | 20049 | 179 | 0 |
1226519 | 1226519 | 2021-04-16 | Greeley | Kansas | 20071 | 104 | 0 |
1226521 | 1226521 | 2021-04-16 | Hamilton | Kansas | 20075 | 202 | 0 |
1226538 | 1226538 | 2021-04-16 | Logan | Kansas | 20109 | 292 | 0 |
1226545 | 1226545 | 2021-04-16 | Mitchell | Kansas | 20123 | 561 | 0 |
1226554 | 1226554 | 2021-04-16 | Osborne | Kansas | 20141 | 289 | 0 |
1226555 | 1226555 | 2021-04-16 | Ottawa | Kansas | 20143 | 550 | 0 |
1226566 | 1226566 | 2021-04-16 | Rush | Kansas | 20165 | 430 | 0 |
1226573 | 1226573 | 2021-04-16 | Sheridan | Kansas | 20179 | 432 | 0 |
1226584 | 1226584 | 2021-04-16 | Wallace | Kansas | 20199 | 177 | 0 |
1226586 | 1226586 | 2021-04-16 | Wichita | Kansas | 20203 | 216 | 0 |
1226588 | 1226588 | 2021-04-16 | Woodson | Kansas | 20207 | 216 | 0 |
1223238 | 1223238 | 2021-04-15 | Anderson | Kansas | 20003 | 831 | 0 |
1223260 | 1223260 | 2021-04-15 | Edwards | Kansas | 20047 | 262 | 0 |
1223261 | 1223261 | 2021-04-15 | Elk | Kansas | 20049 | 178 | 0 |
1223272 | 1223272 | 2021-04-15 | Greeley | Kansas | 20071 | 104 | 0 |
1223274 | 1223274 | 2021-04-15 | Hamilton | Kansas | 20075 | 202 | 0 |
1223291 | 1223291 | 2021-04-15 | Logan | Kansas | 20109 | 292 | 0 |
1223298 | 1223298 | 2021-04-15 | Mitchell | Kansas | 20123 | 561 | 0 |
1223307 | 1223307 | 2021-04-15 | Osborne | Kansas | 20141 | 289 | 0 |
1223308 | 1223308 | 2021-04-15 | Ottawa | Kansas | 20143 | 549 | 0 |
1223319 | 1223319 | 2021-04-15 | Rush | Kansas | 20165 | 430 | 0 |
1223326 | 1223326 | 2021-04-15 | Sheridan | Kansas | 20179 | 432 | 0 |
1223337 | 1223337 | 2021-04-15 | Wallace | Kansas | 20199 | 177 | 0 |
1223339 | 1223339 | 2021-04-15 | Wichita | Kansas | 20203 | 216 | 0 |
1223341 | 1223341 | 2021-04-15 | Woodson | Kansas | 20207 | 216 | 0 |
1219990 | 1219990 | 2021-04-14 | Anderson | Kansas | 20003 | 831 | 0 |
1220012 | 1220012 | 2021-04-14 | Edwards | Kansas | 20047 | 262 | 0 |
1220013 | 1220013 | 2021-04-14 | Elk | Kansas | 20049 | 178 | 0 |
1220024 | 1220024 | 2021-04-14 | Greeley | Kansas | 20071 | 104 | 0 |
1220026 | 1220026 | 2021-04-14 | Hamilton | Kansas | 20075 | 202 | 0 |
1220043 | 1220043 | 2021-04-14 | Logan | Kansas | 20109 | 292 | 0 |
1220050 | 1220050 | 2021-04-14 | Mitchell | Kansas | 20123 | 561 | 0 |
1220059 | 1220059 | 2021-04-14 | Osborne | Kansas | 20141 | 289 | 0 |
1220060 | 1220060 | 2021-04-14 | Ottawa | Kansas | 20143 | 549 | 0 |
1220071 | 1220071 | 2021-04-14 | Rush | Kansas | 20165 | 430 | 0 |
1220078 | 1220078 | 2021-04-14 | Sheridan | Kansas | 20179 | 432 | 0 |
1220089 | 1220089 | 2021-04-14 | Wallace | Kansas | 20199 | 177 | 0 |
1220091 | 1220091 | 2021-04-14 | Wichita | Kansas | 20203 | 216 | 0 |
1220093 | 1220093 | 2021-04-14 | Woodson | Kansas | 20207 | 216 | 0 |
1216742 | 1216742 | 2021-04-13 | Anderson | Kansas | 20003 | 831 | 0 |
1216764 | 1216764 | 2021-04-13 | Edwards | Kansas | 20047 | 262 | 0 |
1216765 | 1216765 | 2021-04-13 | Elk | Kansas | 20049 | 178 | 0 |
1216776 | 1216776 | 2021-04-13 | Greeley | Kansas | 20071 | 104 | 0 |
1216778 | 1216778 | 2021-04-13 | Hamilton | Kansas | 20075 | 202 | 0 |
1216795 | 1216795 | 2021-04-13 | Logan | Kansas | 20109 | 292 | 0 |
1216802 | 1216802 | 2021-04-13 | Mitchell | Kansas | 20123 | 561 | 0 |
1216811 | 1216811 | 2021-04-13 | Osborne | Kansas | 20141 | 289 | 0 |
1216812 | 1216812 | 2021-04-13 | Ottawa | Kansas | 20143 | 549 | 0 |
1216823 | 1216823 | 2021-04-13 | Rush | Kansas | 20165 | 431 | 0 |
1216830 | 1216830 | 2021-04-13 | Sheridan | Kansas | 20179 | 432 | 0 |
1216841 | 1216841 | 2021-04-13 | Wallace | Kansas | 20199 | 177 | 0 |
1216843 | 1216843 | 2021-04-13 | Wichita | Kansas | 20203 | 216 | 0 |
1216845 | 1216845 | 2021-04-13 | Woodson | Kansas | 20207 | 216 | 0 |
1213495 | 1213495 | 2021-04-12 | Anderson | Kansas | 20003 | 831 | 0 |
1213517 | 1213517 | 2021-04-12 | Edwards | Kansas | 20047 | 262 | 0 |
1213518 | 1213518 | 2021-04-12 | Elk | Kansas | 20049 | 178 | 0 |
1213529 | 1213529 | 2021-04-12 | Greeley | Kansas | 20071 | 104 | 0 |
1213531 | 1213531 | 2021-04-12 | Hamilton | Kansas | 20075 | 202 | 0 |
1213548 | 1213548 | 2021-04-12 | Logan | Kansas | 20109 | 292 | 0 |
1213555 | 1213555 | 2021-04-12 | Mitchell | Kansas | 20123 | 561 | 0 |
1213564 | 1213564 | 2021-04-12 | Osborne | Kansas | 20141 | 289 | 0 |
1213565 | 1213565 | 2021-04-12 | Ottawa | Kansas | 20143 | 549 | 0 |
1213576 | 1213576 | 2021-04-12 | Rush | Kansas | 20165 | 431 | 0 |
1213583 | 1213583 | 2021-04-12 | Sheridan | Kansas | 20179 | 432 | 0 |
1213594 | 1213594 | 2021-04-12 | Wallace | Kansas | 20199 | 177 | 0 |
1213596 | 1213596 | 2021-04-12 | Wichita | Kansas | 20203 | 216 | 0 |
1213598 | 1213598 | 2021-04-12 | Woodson | Kansas | 20207 | 216 | 0 |
1210247 | 1210247 | 2021-04-11 | Anderson | Kansas | 20003 | 830 | 0 |
1210269 | 1210269 | 2021-04-11 | Edwards | Kansas | 20047 | 262 | 0 |
1210270 | 1210270 | 2021-04-11 | Elk | Kansas | 20049 | 178 | 0 |
1210281 | 1210281 | 2021-04-11 | Greeley | Kansas | 20071 | 104 | 0 |
1210283 | 1210283 | 2021-04-11 | Hamilton | Kansas | 20075 | 202 | 0 |
1210300 | 1210300 | 2021-04-11 | Logan | Kansas | 20109 | 292 | 0 |
1210307 | 1210307 | 2021-04-11 | Mitchell | Kansas | 20123 | 561 | 0 |
1210316 | 1210316 | 2021-04-11 | Osborne | Kansas | 20141 | 289 | 0 |
1210317 | 1210317 | 2021-04-11 | Ottawa | Kansas | 20143 | 549 | 0 |
1210328 | 1210328 | 2021-04-11 | Rush | Kansas | 20165 | 431 | 0 |
1210335 | 1210335 | 2021-04-11 | Sheridan | Kansas | 20179 | 432 | 0 |
1210346 | 1210346 | 2021-04-11 | Wallace | Kansas | 20199 | 177 | 0 |
1210348 | 1210348 | 2021-04-11 | Wichita | Kansas | 20203 | 216 | 0 |
1210350 | 1210350 | 2021-04-11 | Woodson | Kansas | 20207 | 215 | 0 |
1206998 | 1206998 | 2021-04-10 | Anderson | Kansas | 20003 | 830 | 0 |
1207020 | 1207020 | 2021-04-10 | Edwards | Kansas | 20047 | 262 | 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);