ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
316 rows where cases = 8 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Cherokee 23
- Bourbon 21
- Dickinson 15
- Ellis 15
- Pawnee 15
- Stanton 14
- Rooks 13
- Sumner 12
- Harper 10
- Butler 9
- Greeley 9
- Kiowa 9
- Chautauqua 7
- Decatur 7
- Edwards 7
- Lincoln 7
- Sheridan 7
- Lane 6
- Cheyenne 5
- Greenwood 5
- Jefferson 5
- Logan 5
- Allen 4
- Harvey 4
- Jewell 4
- Russell 4
- Smith 4
- Woodson 4
- Anderson 3
- Atchison 3
- …
state 1
- Kansas · 316 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
619661 | 619661 | 2020-10-11 | Wichita | Kansas | 20203 | 8 | 0 |
616419 | 616419 | 2020-10-10 | Wichita | Kansas | 20203 | 8 | 0 |
613178 | 613178 | 2020-10-09 | Wichita | Kansas | 20203 | 8 | 0 |
587232 | 587232 | 2020-10-01 | Smith | Kansas | 20183 | 8 | 0 |
583992 | 583992 | 2020-09-30 | Smith | Kansas | 20183 | 8 | 0 |
580697 | 580697 | 2020-09-29 | Greeley | Kansas | 20071 | 8 | 0 |
580753 | 580753 | 2020-09-29 | Smith | Kansas | 20183 | 8 | 0 |
577456 | 577456 | 2020-09-28 | Greeley | Kansas | 20071 | 8 | 0 |
577512 | 577512 | 2020-09-28 | Smith | Kansas | 20183 | 8 | 0 |
574214 | 574214 | 2020-09-27 | Greeley | Kansas | 20071 | 8 | 0 |
570971 | 570971 | 2020-09-26 | Greeley | Kansas | 20071 | 8 | 0 |
567729 | 567729 | 2020-09-25 | Greeley | Kansas | 20071 | 8 | 0 |
564489 | 564489 | 2020-09-24 | Greeley | Kansas | 20071 | 8 | 0 |
561249 | 561249 | 2020-09-23 | Greeley | Kansas | 20071 | 8 | 0 |
558013 | 558013 | 2020-09-22 | Greeley | Kansas | 20071 | 8 | 0 |
554776 | 554776 | 2020-09-21 | Greeley | Kansas | 20071 | 8 | 0 |
551556 | 551556 | 2020-09-20 | Logan | Kansas | 20109 | 8 | 0 |
548317 | 548317 | 2020-09-19 | Logan | Kansas | 20109 | 8 | 0 |
545079 | 545079 | 2020-09-18 | Logan | Kansas | 20109 | 8 | 0 |
541843 | 541843 | 2020-09-17 | Logan | Kansas | 20109 | 8 | 0 |
538606 | 538606 | 2020-09-16 | Logan | Kansas | 20109 | 8 | 0 |
532100 | 532100 | 2020-09-14 | Decatur | Kansas | 20039 | 8 | 0 |
528863 | 528863 | 2020-09-13 | Decatur | Kansas | 20039 | 8 | 0 |
525627 | 525627 | 2020-09-12 | Decatur | Kansas | 20039 | 8 | 0 |
522391 | 522391 | 2020-09-11 | Decatur | Kansas | 20039 | 8 | 0 |
519154 | 519154 | 2020-09-10 | Decatur | Kansas | 20039 | 8 | 0 |
519185 | 519185 | 2020-09-10 | Lane | Kansas | 20101 | 8 | 0 |
515919 | 515919 | 2020-09-09 | Decatur | Kansas | 20039 | 8 | 0 |
515950 | 515950 | 2020-09-09 | Lane | Kansas | 20101 | 8 | 0 |
512686 | 512686 | 2020-09-08 | Decatur | Kansas | 20039 | 8 | 0 |
512717 | 512717 | 2020-09-08 | Lane | Kansas | 20101 | 8 | 0 |
509484 | 509484 | 2020-09-07 | Lane | Kansas | 20101 | 8 | 0 |
506213 | 506213 | 2020-09-06 | Cheyenne | Kansas | 20023 | 8 | 0 |
502979 | 502979 | 2020-09-05 | Cheyenne | Kansas | 20023 | 8 | 0 |
499745 | 499745 | 2020-09-04 | Cheyenne | Kansas | 20023 | 8 | 0 |
496512 | 496512 | 2020-09-03 | Cheyenne | Kansas | 20023 | 8 | 0 |
496553 | 496553 | 2020-09-03 | Lincoln | Kansas | 20105 | 8 | 0 |
496590 | 496590 | 2020-09-03 | Sheridan | Kansas | 20179 | 8 | 0 |
493278 | 493278 | 2020-09-02 | Cheyenne | Kansas | 20023 | 8 | 0 |
493319 | 493319 | 2020-09-02 | Lincoln | Kansas | 20105 | 8 | 0 |
493356 | 493356 | 2020-09-02 | Sheridan | Kansas | 20179 | 8 | 0 |
490086 | 490086 | 2020-09-01 | Lincoln | Kansas | 20105 | 8 | 0 |
490123 | 490123 | 2020-09-01 | Sheridan | Kansas | 20179 | 8 | 0 |
486853 | 486853 | 2020-08-31 | Lincoln | Kansas | 20105 | 8 | 0 |
486890 | 486890 | 2020-08-31 | Sheridan | Kansas | 20179 | 8 | 0 |
483575 | 483575 | 2020-08-30 | Chautauqua | Kansas | 20019 | 8 | 0 |
483618 | 483618 | 2020-08-30 | Lincoln | Kansas | 20105 | 8 | 0 |
483655 | 483655 | 2020-08-30 | Sheridan | Kansas | 20179 | 8 | 0 |
480341 | 480341 | 2020-08-29 | Chautauqua | Kansas | 20019 | 8 | 0 |
480384 | 480384 | 2020-08-29 | Lincoln | Kansas | 20105 | 8 | 0 |
480421 | 480421 | 2020-08-29 | Sheridan | Kansas | 20179 | 8 | 0 |
477108 | 477108 | 2020-08-28 | Chautauqua | Kansas | 20019 | 8 | 0 |
477151 | 477151 | 2020-08-28 | Lincoln | Kansas | 20105 | 8 | 0 |
477188 | 477188 | 2020-08-28 | Sheridan | Kansas | 20179 | 8 | 0 |
473875 | 473875 | 2020-08-27 | Chautauqua | Kansas | 20019 | 8 | 0 |
473916 | 473916 | 2020-08-27 | Lane | Kansas | 20101 | 8 | 0 |
470643 | 470643 | 2020-08-26 | Chautauqua | Kansas | 20019 | 8 | 0 |
470684 | 470684 | 2020-08-26 | Lane | Kansas | 20101 | 8 | 0 |
467414 | 467414 | 2020-08-25 | Chautauqua | Kansas | 20019 | 8 | 0 |
464185 | 464185 | 2020-08-24 | Chautauqua | Kansas | 20019 | 8 | 0 |
444857 | 444857 | 2020-08-18 | Kiowa | Kansas | 20097 | 8 | 0 |
444876 | 444876 | 2020-08-18 | Ness | Kansas | 20135 | 8 | 0 |
441631 | 441631 | 2020-08-17 | Kiowa | Kansas | 20097 | 8 | 0 |
441650 | 441650 | 2020-08-17 | Ness | Kansas | 20135 | 8 | 0 |
438404 | 438404 | 2020-08-16 | Kiowa | Kansas | 20097 | 8 | 0 |
435179 | 435179 | 2020-08-15 | Kiowa | Kansas | 20097 | 8 | 0 |
431954 | 431954 | 2020-08-14 | Kiowa | Kansas | 20097 | 8 | 0 |
428726 | 428726 | 2020-08-13 | Kiowa | Kansas | 20097 | 8 | 0 |
425502 | 425502 | 2020-08-12 | Kiowa | Kansas | 20097 | 8 | 0 |
422281 | 422281 | 2020-08-11 | Kiowa | Kansas | 20097 | 8 | 0 |
419058 | 419058 | 2020-08-10 | Kiowa | Kansas | 20097 | 8 | 0 |
415861 | 415861 | 2020-08-09 | Pawnee | Kansas | 20145 | 8 | 0 |
412641 | 412641 | 2020-08-08 | Pawnee | Kansas | 20145 | 8 | 0 |
409421 | 409421 | 2020-08-07 | Pawnee | Kansas | 20145 | 8 | 0 |
406202 | 406202 | 2020-08-06 | Pawnee | Kansas | 20145 | 8 | 0 |
402984 | 402984 | 2020-08-05 | Pawnee | Kansas | 20145 | 8 | 0 |
399767 | 399767 | 2020-08-04 | Pawnee | Kansas | 20145 | 8 | 0 |
396552 | 396552 | 2020-08-03 | Pawnee | Kansas | 20145 | 8 | 0 |
393302 | 393302 | 2020-08-02 | Harper | Kansas | 20077 | 8 | 0 |
390085 | 390085 | 2020-08-01 | Harper | Kansas | 20077 | 8 | 0 |
386868 | 386868 | 2020-07-31 | Harper | Kansas | 20077 | 8 | 0 |
383650 | 383650 | 2020-07-30 | Harper | Kansas | 20077 | 8 | 0 |
383656 | 383656 | 2020-07-30 | Jewell | Kansas | 20089 | 8 | 0 |
383659 | 383659 | 2020-07-30 | Kingman | Kansas | 20095 | 8 | 0 |
383712 | 383712 | 2020-07-30 | Wilson | Kansas | 20205 | 8 | 0 |
380433 | 380433 | 2020-07-29 | Harper | Kansas | 20077 | 8 | 0 |
380439 | 380439 | 2020-07-29 | Jewell | Kansas | 20089 | 8 | 0 |
380442 | 380442 | 2020-07-29 | Kingman | Kansas | 20095 | 8 | 0 |
380495 | 380495 | 2020-07-29 | Wilson | Kansas | 20205 | 8 | 0 |
377216 | 377216 | 2020-07-28 | Harper | Kansas | 20077 | 8 | 0 |
377222 | 377222 | 2020-07-28 | Jewell | Kansas | 20089 | 8 | 0 |
377235 | 377235 | 2020-07-28 | Marshall | Kansas | 20117 | 8 | 0 |
374001 | 374001 | 2020-07-27 | Harper | Kansas | 20077 | 8 | 0 |
374007 | 374007 | 2020-07-27 | Jewell | Kansas | 20089 | 8 | 0 |
374020 | 374020 | 2020-07-27 | Marshall | Kansas | 20117 | 8 | 0 |
374045 | 374045 | 2020-07-27 | Russell | Kansas | 20167 | 8 | 0 |
370789 | 370789 | 2020-07-26 | Harper | Kansas | 20077 | 8 | 0 |
370823 | 370823 | 2020-07-26 | Pawnee | Kansas | 20145 | 8 | 0 |
370833 | 370833 | 2020-07-26 | Russell | Kansas | 20167 | 8 | 0 |
367579 | 367579 | 2020-07-25 | Harper | Kansas | 20077 | 8 | 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);