ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where cases = 27 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Mitchell 21
- Cloud 15
- McPherson 12
- Doniphan 11
- Wabaunsee 9
- Atchison 7
- Labette 7
- Russell 6
- Gray 5
- Greeley 5
- Pottawatomie 5
- Ellsworth 4
- Phillips 4
- Anderson 3
- Ellis 3
- Kiowa 3
- Marion 3
- Nemaha 3
- Riley 3
- Saline 3
- Wallace 3
- Woodson 3
- Bourbon 2
- Brown 2
- Chautauqua 2
- Cowley 2
- Edwards 2
- Hamilton 2
- Kingman 2
- Osborne 2
- …
state 1
- Kansas · 169 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
726625 | 726625 | 2020-11-13 | Comanche | Kansas | 20033 | 27 | 0 |
678029 | 678029 | 2020-10-29 | Osborne | Kansas | 20141 | 27 | 0 |
674786 | 674786 | 2020-10-28 | Osborne | Kansas | 20141 | 27 | 0 |
671483 | 671483 | 2020-10-27 | Chautauqua | Kansas | 20019 | 27 | 0 |
668240 | 668240 | 2020-10-26 | Chautauqua | Kansas | 20019 | 27 | 0 |
655357 | 655357 | 2020-10-22 | Woodson | Kansas | 20207 | 27 | 0 |
652112 | 652112 | 2020-10-21 | Woodson | Kansas | 20207 | 27 | 0 |
648799 | 648799 | 2020-10-20 | Greeley | Kansas | 20071 | 27 | 0 |
648867 | 648867 | 2020-10-20 | Woodson | Kansas | 20207 | 27 | 0 |
645554 | 645554 | 2020-10-19 | Greeley | Kansas | 20071 | 27 | 0 |
642307 | 642307 | 2020-10-18 | Greeley | Kansas | 20071 | 27 | 0 |
642372 | 642372 | 2020-10-18 | Wallace | Kansas | 20199 | 27 | 0 |
639060 | 639060 | 2020-10-17 | Greeley | Kansas | 20071 | 27 | 0 |
639125 | 639125 | 2020-10-17 | Wallace | Kansas | 20199 | 27 | 0 |
635814 | 635814 | 2020-10-16 | Greeley | Kansas | 20071 | 27 | 0 |
635879 | 635879 | 2020-10-16 | Wallace | Kansas | 20199 | 27 | 0 |
626146 | 626146 | 2020-10-13 | Washington | Kansas | 20201 | 27 | 0 |
622904 | 622904 | 2020-10-12 | Washington | Kansas | 20201 | 27 | 0 |
613141 | 613141 | 2020-10-09 | Morton | Kansas | 20129 | 27 | 2 |
596913 | 596913 | 2020-10-04 | Kiowa | Kansas | 20097 | 27 | 0 |
593671 | 593671 | 2020-10-03 | Kiowa | Kansas | 20097 | 27 | 0 |
590430 | 590430 | 2020-10-02 | Kiowa | Kansas | 20097 | 27 | 0 |
554831 | 554831 | 2020-09-21 | Sherman | Kansas | 20181 | 27 | 0 |
541815 | 541815 | 2020-09-17 | Ellsworth | Kansas | 20053 | 27 | 0 |
538578 | 538578 | 2020-09-16 | Ellsworth | Kansas | 20053 | 27 | 0 |
535342 | 535342 | 2020-09-15 | Ellsworth | Kansas | 20053 | 27 | 0 |
532107 | 532107 | 2020-09-14 | Ellsworth | Kansas | 20053 | 27 | 0 |
496524 | 496524 | 2020-09-03 | Edwards | Kansas | 20047 | 27 | 0 |
496583 | 496583 | 2020-09-03 | Rush | Kansas | 20165 | 27 | 0 |
496584 | 496584 | 2020-09-03 | Russell | Kansas | 20167 | 27 | 0 |
493290 | 493290 | 2020-09-02 | Edwards | Kansas | 20047 | 27 | 0 |
493349 | 493349 | 2020-09-02 | Rush | Kansas | 20165 | 27 | 0 |
493350 | 493350 | 2020-09-02 | Russell | Kansas | 20167 | 27 | 0 |
490117 | 490117 | 2020-09-01 | Russell | Kansas | 20167 | 27 | 0 |
486884 | 486884 | 2020-08-31 | Russell | Kansas | 20167 | 27 | 0 |
483649 | 483649 | 2020-08-30 | Russell | Kansas | 20167 | 27 | 0 |
480415 | 480415 | 2020-08-29 | Russell | Kansas | 20167 | 27 | 0 |
461008 | 461008 | 2020-08-23 | Mitchell | Kansas | 20123 | 27 | 0 |
457781 | 457781 | 2020-08-22 | Mitchell | Kansas | 20123 | 27 | 0 |
454553 | 454553 | 2020-08-21 | Mitchell | Kansas | 20123 | 27 | 0 |
451325 | 451325 | 2020-08-20 | Mitchell | Kansas | 20123 | 27 | 0 |
448097 | 448097 | 2020-08-19 | Mitchell | Kansas | 20123 | 27 | 0 |
444856 | 444856 | 2020-08-18 | Kingman | Kansas | 20095 | 27 | 0 |
441630 | 441630 | 2020-08-17 | Kingman | Kansas | 20095 | 27 | 0 |
428739 | 428739 | 2020-08-13 | Mitchell | Kansas | 20123 | 27 | 0 |
425515 | 425515 | 2020-08-12 | Mitchell | Kansas | 20123 | 27 | 0 |
422294 | 422294 | 2020-08-11 | Mitchell | Kansas | 20123 | 27 | 0 |
419071 | 419071 | 2020-08-10 | Mitchell | Kansas | 20123 | 27 | 0 |
415850 | 415850 | 2020-08-09 | Mitchell | Kansas | 20123 | 27 | 0 |
412630 | 412630 | 2020-08-08 | Mitchell | Kansas | 20123 | 27 | 0 |
409410 | 409410 | 2020-08-07 | Mitchell | Kansas | 20123 | 27 | 0 |
406191 | 406191 | 2020-08-06 | Mitchell | Kansas | 20123 | 27 | 0 |
402973 | 402973 | 2020-08-05 | Mitchell | Kansas | 20123 | 27 | 0 |
399756 | 399756 | 2020-08-04 | Mitchell | Kansas | 20123 | 27 | 0 |
396541 | 396541 | 2020-08-03 | Mitchell | Kansas | 20123 | 27 | 0 |
393265 | 393265 | 2020-08-02 | Anderson | Kansas | 20003 | 27 | 0 |
393325 | 393325 | 2020-08-02 | Mitchell | Kansas | 20123 | 27 | 0 |
390048 | 390048 | 2020-08-01 | Anderson | Kansas | 20003 | 27 | 0 |
390108 | 390108 | 2020-08-01 | Mitchell | Kansas | 20123 | 27 | 0 |
386831 | 386831 | 2020-07-31 | Anderson | Kansas | 20003 | 27 | 0 |
386891 | 386891 | 2020-07-31 | Mitchell | Kansas | 20123 | 27 | 0 |
383673 | 383673 | 2020-07-30 | Mitchell | Kansas | 20123 | 27 | 0 |
380456 | 380456 | 2020-07-29 | Mitchell | Kansas | 20123 | 27 | 0 |
377184 | 377184 | 2020-07-28 | Brown | Kansas | 20013 | 27 | 0 |
373969 | 373969 | 2020-07-27 | Brown | Kansas | 20013 | 27 | 0 |
370765 | 370765 | 2020-07-26 | Cloud | Kansas | 20029 | 27 | 0 |
367555 | 367555 | 2020-07-25 | Cloud | Kansas | 20029 | 27 | 0 |
364348 | 364348 | 2020-07-24 | Cloud | Kansas | 20029 | 27 | 0 |
361141 | 361141 | 2020-07-23 | Cloud | Kansas | 20029 | 27 | 0 |
357936 | 357936 | 2020-07-22 | Cloud | Kansas | 20029 | 27 | 0 |
354734 | 354734 | 2020-07-21 | Cloud | Kansas | 20029 | 27 | 0 |
351532 | 351532 | 2020-07-20 | Cloud | Kansas | 20029 | 27 | 0 |
348332 | 348332 | 2020-07-19 | Cloud | Kansas | 20029 | 27 | 0 |
348374 | 348374 | 2020-07-19 | Marion | Kansas | 20115 | 27 | 1 |
345131 | 345131 | 2020-07-18 | Cloud | Kansas | 20029 | 27 | 0 |
345173 | 345173 | 2020-07-18 | Marion | Kansas | 20115 | 27 | 1 |
341931 | 341931 | 2020-07-17 | Cloud | Kansas | 20029 | 27 | 0 |
341973 | 341973 | 2020-07-17 | Marion | Kansas | 20115 | 27 | 1 |
338735 | 338735 | 2020-07-16 | Cloud | Kansas | 20029 | 27 | 0 |
338742 | 338742 | 2020-07-16 | Doniphan | Kansas | 20043 | 27 | 0 |
335539 | 335539 | 2020-07-15 | Cloud | Kansas | 20029 | 27 | 0 |
335546 | 335546 | 2020-07-15 | Doniphan | Kansas | 20043 | 27 | 0 |
332346 | 332346 | 2020-07-14 | Cloud | Kansas | 20029 | 27 | 0 |
332353 | 332353 | 2020-07-14 | Doniphan | Kansas | 20043 | 27 | 0 |
329159 | 329159 | 2020-07-13 | Cloud | Kansas | 20029 | 27 | 0 |
329166 | 329166 | 2020-07-13 | Doniphan | Kansas | 20043 | 27 | 0 |
325973 | 325973 | 2020-07-12 | Cloud | Kansas | 20029 | 27 | 0 |
325980 | 325980 | 2020-07-12 | Doniphan | Kansas | 20043 | 27 | 0 |
322798 | 322798 | 2020-07-11 | Doniphan | Kansas | 20043 | 27 | 0 |
319619 | 319619 | 2020-07-10 | Doniphan | Kansas | 20043 | 27 | 0 |
316446 | 316446 | 2020-07-09 | Doniphan | Kansas | 20043 | 27 | 0 |
316496 | 316496 | 2020-07-09 | Phillips | Kansas | 20147 | 27 | 0 |
313272 | 313272 | 2020-07-08 | Doniphan | Kansas | 20043 | 27 | 0 |
313322 | 313322 | 2020-07-08 | Phillips | Kansas | 20147 | 27 | 0 |
310102 | 310102 | 2020-07-07 | Doniphan | Kansas | 20043 | 27 | 0 |
310115 | 310115 | 2020-07-07 | Gray | Kansas | 20069 | 27 | 0 |
310152 | 310152 | 2020-07-07 | Phillips | Kansas | 20147 | 27 | 0 |
306934 | 306934 | 2020-07-06 | Doniphan | Kansas | 20043 | 27 | 0 |
306947 | 306947 | 2020-07-06 | Gray | Kansas | 20069 | 27 | 0 |
306984 | 306984 | 2020-07-06 | Phillips | Kansas | 20147 | 27 | 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);