ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
154 rows where cases = 24 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 |
---|---|---|---|---|---|---|---|
700715 | 700715 | 2020-11-05 | Lincoln | Kansas | 20105 | 24 | 1 |
697471 | 697471 | 2020-11-04 | Lincoln | Kansas | 20105 | 24 | 1 |
694229 | 694229 | 2020-11-03 | Lincoln | Kansas | 20105 | 24 | 1 |
690986 | 690986 | 2020-11-02 | Lincoln | Kansas | 20105 | 24 | 1 |
678009 | 678009 | 2020-10-29 | Lane | Kansas | 20101 | 24 | 1 |
678050 | 678050 | 2020-10-29 | Smith | Kansas | 20183 | 24 | 0 |
674766 | 674766 | 2020-10-28 | Lane | Kansas | 20101 | 24 | 1 |
674807 | 674807 | 2020-10-28 | Smith | Kansas | 20183 | 24 | 0 |
671524 | 671524 | 2020-10-27 | Lane | Kansas | 20101 | 24 | 1 |
668281 | 668281 | 2020-10-26 | Lane | Kansas | 20101 | 24 | 1 |
665057 | 665057 | 2020-10-25 | Osborne | Kansas | 20141 | 24 | 0 |
661812 | 661812 | 2020-10-24 | Osborne | Kansas | 20141 | 24 | 0 |
658568 | 658568 | 2020-10-23 | Osborne | Kansas | 20141 | 24 | 0 |
655323 | 655323 | 2020-10-22 | Osborne | Kansas | 20141 | 24 | 0 |
652078 | 652078 | 2020-10-21 | Osborne | Kansas | 20141 | 24 | 0 |
648773 | 648773 | 2020-10-20 | Chautauqua | Kansas | 20019 | 24 | 0 |
645528 | 645528 | 2020-10-19 | Chautauqua | Kansas | 20019 | 24 | 0 |
642281 | 642281 | 2020-10-18 | Chautauqua | Kansas | 20019 | 24 | 0 |
639034 | 639034 | 2020-10-17 | Chautauqua | Kansas | 20019 | 24 | 0 |
635788 | 635788 | 2020-10-16 | Chautauqua | Kansas | 20019 | 24 | 0 |
632542 | 632542 | 2020-10-15 | Chautauqua | Kansas | 20019 | 24 | 0 |
629298 | 629298 | 2020-10-14 | Chautauqua | Kansas | 20019 | 24 | 0 |
626055 | 626055 | 2020-10-13 | Chautauqua | Kansas | 20019 | 24 | 0 |
626081 | 626081 | 2020-10-13 | Greeley | Kansas | 20071 | 24 | 0 |
622813 | 622813 | 2020-10-12 | Chautauqua | Kansas | 20019 | 24 | 0 |
622839 | 622839 | 2020-10-12 | Greeley | Kansas | 20071 | 24 | 0 |
609844 | 609844 | 2020-10-08 | Chautauqua | Kansas | 20019 | 24 | 0 |
609938 | 609938 | 2020-10-08 | Woodson | Kansas | 20207 | 24 | 0 |
606601 | 606601 | 2020-10-07 | Chautauqua | Kansas | 20019 | 24 | 0 |
606696 | 606696 | 2020-10-07 | Woodson | Kansas | 20207 | 24 | 0 |
603451 | 603451 | 2020-10-06 | Washington | Kansas | 20201 | 24 | 0 |
603454 | 603454 | 2020-10-06 | Woodson | Kansas | 20207 | 24 | 0 |
600208 | 600208 | 2020-10-05 | Washington | Kansas | 20201 | 24 | 0 |
600211 | 600211 | 2020-10-05 | Woodson | Kansas | 20207 | 24 | 0 |
596969 | 596969 | 2020-10-04 | Woodson | Kansas | 20207 | 24 | 0 |
593727 | 593727 | 2020-10-03 | Woodson | Kansas | 20207 | 24 | 0 |
590486 | 590486 | 2020-10-02 | Woodson | Kansas | 20207 | 24 | 0 |
587182 | 587182 | 2020-10-01 | Hodgeman | Kansas | 20083 | 24 | 0 |
583942 | 583942 | 2020-09-30 | Hodgeman | Kansas | 20083 | 24 | 0 |
574198 | 574198 | 2020-09-27 | Decatur | Kansas | 20039 | 24 | 0 |
554817 | 554817 | 2020-09-21 | Rawlins | Kansas | 20153 | 24 | 0 |
551513 | 551513 | 2020-09-20 | Cheyenne | Kansas | 20023 | 24 | 0 |
551533 | 551533 | 2020-09-20 | Gove | Kansas | 20063 | 24 | 0 |
551578 | 551578 | 2020-09-20 | Rawlins | Kansas | 20153 | 24 | 0 |
548274 | 548274 | 2020-09-19 | Cheyenne | Kansas | 20023 | 24 | 0 |
548294 | 548294 | 2020-09-19 | Gove | Kansas | 20063 | 24 | 0 |
545036 | 545036 | 2020-09-18 | Cheyenne | Kansas | 20023 | 24 | 0 |
545056 | 545056 | 2020-09-18 | Gove | Kansas | 20063 | 24 | 0 |
545115 | 545115 | 2020-09-18 | Sherman | Kansas | 20181 | 24 | 0 |
519198 | 519198 | 2020-09-10 | Morris | Kansas | 20127 | 24 | 0 |
519203 | 519203 | 2020-09-10 | Norton | Kansas | 20137 | 24 | 0 |
515963 | 515963 | 2020-09-09 | Morris | Kansas | 20127 | 24 | 0 |
515968 | 515968 | 2020-09-09 | Norton | Kansas | 20137 | 24 | 0 |
512730 | 512730 | 2020-09-08 | Morris | Kansas | 20127 | 24 | 0 |
512735 | 512735 | 2020-09-08 | Norton | Kansas | 20137 | 24 | 0 |
509497 | 509497 | 2020-09-07 | Morris | Kansas | 20127 | 24 | 0 |
509502 | 509502 | 2020-09-07 | Norton | Kansas | 20137 | 24 | 0 |
506270 | 506270 | 2020-09-06 | Norton | Kansas | 20137 | 24 | 0 |
503036 | 503036 | 2020-09-05 | Norton | Kansas | 20137 | 24 | 0 |
499802 | 499802 | 2020-09-04 | Norton | Kansas | 20137 | 24 | 0 |
496569 | 496569 | 2020-09-03 | Norton | Kansas | 20137 | 24 | 0 |
493335 | 493335 | 2020-09-02 | Norton | Kansas | 20137 | 24 | 0 |
490057 | 490057 | 2020-09-01 | Edwards | Kansas | 20047 | 24 | 0 |
490131 | 490131 | 2020-09-01 | Trego | Kansas | 20195 | 24 | 1 |
486824 | 486824 | 2020-08-31 | Edwards | Kansas | 20047 | 24 | 0 |
486898 | 486898 | 2020-08-31 | Trego | Kansas | 20195 | 24 | 1 |
483566 | 483566 | 2020-08-30 | Allen | Kansas | 20001 | 24 | 0 |
483663 | 483663 | 2020-08-30 | Trego | Kansas | 20195 | 24 | 1 |
480332 | 480332 | 2020-08-29 | Allen | Kansas | 20001 | 24 | 0 |
480429 | 480429 | 2020-08-29 | Trego | Kansas | 20195 | 24 | 1 |
477099 | 477099 | 2020-08-28 | Allen | Kansas | 20001 | 24 | 0 |
477196 | 477196 | 2020-08-28 | Trego | Kansas | 20195 | 24 | 1 |
473949 | 473949 | 2020-08-27 | Russell | Kansas | 20167 | 24 | 0 |
470717 | 470717 | 2020-08-26 | Russell | Kansas | 20167 | 24 | 0 |
467441 | 467441 | 2020-08-25 | Greenwood | Kansas | 20073 | 24 | 0 |
464212 | 464212 | 2020-08-24 | Greenwood | Kansas | 20073 | 24 | 0 |
460960 | 460960 | 2020-08-23 | Clay | Kansas | 20027 | 24 | 2 |
460973 | 460973 | 2020-08-23 | Ellsworth | Kansas | 20053 | 24 | 0 |
460983 | 460983 | 2020-08-23 | Greenwood | Kansas | 20073 | 24 | 0 |
457733 | 457733 | 2020-08-22 | Clay | Kansas | 20027 | 24 | 2 |
457746 | 457746 | 2020-08-22 | Ellsworth | Kansas | 20053 | 24 | 0 |
457756 | 457756 | 2020-08-22 | Greenwood | Kansas | 20073 | 24 | 0 |
454505 | 454505 | 2020-08-21 | Clay | Kansas | 20027 | 24 | 2 |
454518 | 454518 | 2020-08-21 | Ellsworth | Kansas | 20053 | 24 | 0 |
454528 | 454528 | 2020-08-21 | Greenwood | Kansas | 20073 | 24 | 0 |
451290 | 451290 | 2020-08-20 | Ellsworth | Kansas | 20053 | 24 | 0 |
451300 | 451300 | 2020-08-20 | Greenwood | Kansas | 20073 | 24 | 0 |
448062 | 448062 | 2020-08-19 | Ellsworth | Kansas | 20053 | 24 | 0 |
448072 | 448072 | 2020-08-19 | Greenwood | Kansas | 20073 | 24 | 0 |
444835 | 444835 | 2020-08-18 | Ellsworth | Kansas | 20053 | 24 | 0 |
399787 | 399787 | 2020-08-04 | Stanton | Kansas | 20187 | 24 | 0 |
396572 | 396572 | 2020-08-03 | Stanton | Kansas | 20187 | 24 | 0 |
370835 | 370835 | 2020-07-26 | Scott | Kansas | 20171 | 24 | 0 |
354721 | 354721 | 2020-07-21 | Anderson | Kansas | 20003 | 24 | 0 |
354815 | 354815 | 2020-07-21 | Thomas | Kansas | 20193 | 24 | 0 |
351519 | 351519 | 2020-07-20 | Anderson | Kansas | 20003 | 24 | 0 |
351613 | 351613 | 2020-07-20 | Thomas | Kansas | 20193 | 24 | 0 |
348324 | 348324 | 2020-07-19 | Brown | Kansas | 20013 | 24 | 0 |
348393 | 348393 | 2020-07-19 | Pratt | Kansas | 20151 | 24 | 0 |
345123 | 345123 | 2020-07-18 | Brown | Kansas | 20013 | 24 | 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);