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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 106
- 20091 798
- 20209 793
- 20015 792
- 20059 791
- 20045 788
- 20057 788
- 20103 787
- 20021 786
- 20107 786
- 20127 786
- 20173 786
- 20155 785
- 20161 785
- 20085 783
- 20123 783
- 20011 782
- 20111 782
- 20043 781
- 20149 781
- 20207 781
- 20037 780
- 20133 780
- 20177 780
- 20087 779
- 20191 779
- 20027 778
- 20031 778
- 20063 778
- 20079 778
- 20113 778
- 20139 778
- 20143 778
- 20121 777
- 20055 776
- 20125 776
- 20185 776
- 20189 776
- 20005 775
- 20169 775
- 20009 774
- 20019 774
- 20099 774
- 20151 773
- 20029 772
- 20035 772
- 20115 771
- 20141 771
- 20073 770
- 20089 770
- 20061 769
- 20157 769
- 20197 769
- 20129 768
- 20007 767
- 20163 767
- 20171 767
- 20175 767
- 20051 763
- 20075 763
- 20147 763
- 20093 762
- 20187 762
- 20041 760
- 20183 759
- 20017 757
- 20181 757
- 20205 757
- 20179 755
- 20081 754
- 20047 752
- 20025 751
- 20069 751
- 20097 751
- 20159 751
- 20067 750
- 20119 750
- 20131 746
- 20023 745
- 20077 744
- 20137 743
- 20013 740
- 20053 740
- 20003 735
- 20135 726
- 20033 722
- 20083 722
- 20101 722
- 20195 722
- 20145 710
- 20201 703
- 20001 698
- 20193 691
- 20109 689
- 20117 689
- 20049 687
- 20165 684
- 20065 677
- 20095 677
- 20105 673
- 20167 673
- 20039 671
- 20071 671
- 20203 661
- 20153 628
- 20199 628
- - 246
county 106
- Johnson 798
- Wyandotte 793
- Butler 792
- Franklin 791
- Douglas 788
- Ford 788
- Leavenworth 787
- Cherokee 786
- Linn 786
- Morris 786
- Sedgwick 786
- Reno 785
- Riley 785
- Jackson 783
- Mitchell 783
- Bourbon 782
- Lyon 782
- Doniphan 781
- Pottawatomie 781
- Woodson 781
- Crawford 780
- Neosho 780
- Shawnee 780
- Jefferson 779
- Sumner 779
- Clay 778
- Coffey 778
- Gove 778
- Harvey 778
- McPherson 778
- Osage 778
- Ottawa 778
- Miami 777
- Finney 776
- Montgomery 776
- Stafford 776
- Stevens 776
- Atchison 775
- Saline 775
- Barton 774
- Chautauqua 774
- Labette 774
- Pratt 773
- Cloud 772
- Cowley 772
- Marion 771
- Osborne 771
- Greenwood 770
- Jewell 770
- Geary 769
- Republic 769
- Wabaunsee 769
- Morton 768
- Barber 767
- Rooks 767
- Scott 767
- Seward 767
- Ellis 763
- Hamilton 763
- Phillips 763
- Kearny 762
- Stanton 762
- Dickinson 760
- Smith 759
- Chase 757
- Sherman 757
- Wilson 757
- Sheridan 755
- Haskell 754
- Edwards 752
- Clark 751
- Gray 751
- Kiowa 751
- Rice 751
- Grant 750
- Meade 750
- Nemaha 746
- Cheyenne 745
- Harper 744
- Norton 743
- Brown 740
- Ellsworth 740
- Anderson 735
- Ness 726
- Comanche 722
- Hodgeman 722
- Lane 722
- Trego 722
- Pawnee 710
- Washington 703
- Allen 698
- Thomas 691
- Logan 689
- Marshall 689
- Elk 687
- Rush 684
- Graham 677
- Kingman 677
- Lincoln 673
- Russell 673
- Decatur 671
- Greeley 671
- Wichita 661
- Rawlins 628
- Wallace 628
- Unknown 246
state 1
- Kansas · 79,294 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
699 | 699 | 2020-03-07 | Johnson | Kansas | 20091 | 1 | 0 |
798 | 798 | 2020-03-08 | Johnson | Kansas | 20091 | 1 | 0 |
920 | 920 | 2020-03-09 | Johnson | Kansas | 20091 | 1 | 0 |
1065 | 1065 | 2020-03-10 | Johnson | Kansas | 20091 | 1 | 0 |
1243 | 1243 | 2020-03-11 | Johnson | Kansas | 20091 | 1 | 0 |
1458 | 1458 | 2020-03-12 | Johnson | Kansas | 20091 | 4 | 0 |
1730 | 1730 | 2020-03-13 | Butler | Kansas | 20015 | 1 | 0 |
1731 | 1731 | 2020-03-13 | Johnson | Kansas | 20091 | 4 | 0 |
2064 | 2064 | 2020-03-14 | Butler | Kansas | 20015 | 1 | 0 |
2065 | 2065 | 2020-03-14 | Franklin | Kansas | 20059 | 1 | 0 |
2066 | 2066 | 2020-03-14 | Johnson | Kansas | 20091 | 5 | 0 |
2460 | 2460 | 2020-03-15 | Butler | Kansas | 20015 | 1 | 0 |
2461 | 2461 | 2020-03-15 | Franklin | Kansas | 20059 | 1 | 0 |
2462 | 2462 | 2020-03-15 | Johnson | Kansas | 20091 | 6 | 0 |
2905 | 2905 | 2020-03-16 | Butler | Kansas | 20015 | 1 | 0 |
2906 | 2906 | 2020-03-16 | Franklin | Kansas | 20059 | 1 | 0 |
2907 | 2907 | 2020-03-16 | Johnson | Kansas | 20091 | 8 | 0 |
3398 | 3398 | 2020-03-17 | Butler | Kansas | 20015 | 1 | 0 |
3399 | 3399 | 2020-03-17 | Douglas | Kansas | 20045 | 1 | 0 |
3400 | 3400 | 2020-03-17 | Ford | Kansas | 20057 | 1 | 0 |
3401 | 3401 | 2020-03-17 | Franklin | Kansas | 20059 | 1 | 0 |
3402 | 3402 | 2020-03-17 | Johnson | Kansas | 20091 | 10 | 0 |
3974 | 3974 | 2020-03-18 | Butler | Kansas | 20015 | 1 | 0 |
3975 | 3975 | 2020-03-18 | Douglas | Kansas | 20045 | 1 | 0 |
3976 | 3976 | 2020-03-18 | Ford | Kansas | 20057 | 1 | 0 |
3977 | 3977 | 2020-03-18 | Franklin | Kansas | 20059 | 1 | 0 |
3978 | 3978 | 2020-03-18 | Johnson | Kansas | 20091 | 11 | 0 |
3979 | 3979 | 2020-03-18 | Leavenworth | Kansas | 20103 | 2 | 0 |
4655 | 4655 | 2020-03-19 | Butler | Kansas | 20015 | 1 | 0 |
4656 | 4656 | 2020-03-19 | Cherokee | Kansas | 20021 | 1 | 0 |
4657 | 4657 | 2020-03-19 | Douglas | Kansas | 20045 | 1 | 0 |
4658 | 4658 | 2020-03-19 | Ford | Kansas | 20057 | 1 | 0 |
4659 | 4659 | 2020-03-19 | Franklin | Kansas | 20059 | 1 | 0 |
4660 | 4660 | 2020-03-19 | Johnson | Kansas | 20091 | 16 | 0 |
4661 | 4661 | 2020-03-19 | Leavenworth | Kansas | 20103 | 2 | 0 |
4662 | 4662 | 2020-03-19 | Linn | Kansas | 20107 | 1 | 0 |
4663 | 4663 | 2020-03-19 | Morris | Kansas | 20127 | 2 | 0 |
4664 | 4664 | 2020-03-19 | Sedgwick | Kansas | 20173 | 1 | 0 |
5466 | 5466 | 2020-03-20 | Butler | Kansas | 20015 | 2 | 0 |
5467 | 5467 | 2020-03-20 | Cherokee | Kansas | 20021 | 1 | 0 |
5468 | 5468 | 2020-03-20 | Douglas | Kansas | 20045 | 1 | 0 |
5469 | 5469 | 2020-03-20 | Ford | Kansas | 20057 | 1 | 0 |
5470 | 5470 | 2020-03-20 | Franklin | Kansas | 20059 | 1 | 0 |
5471 | 5471 | 2020-03-20 | Johnson | Kansas | 20091 | 24 | 0 |
5472 | 5472 | 2020-03-20 | Leavenworth | Kansas | 20103 | 4 | 0 |
5473 | 5473 | 2020-03-20 | Linn | Kansas | 20107 | 1 | 0 |
5474 | 5474 | 2020-03-20 | Morris | Kansas | 20127 | 2 | 0 |
5475 | 5475 | 2020-03-20 | Reno | Kansas | 20155 | 1 | 0 |
5476 | 5476 | 2020-03-20 | Riley | Kansas | 20161 | 1 | 0 |
5477 | 5477 | 2020-03-20 | Sedgwick | Kansas | 20173 | 1 | 0 |
6411 | 6411 | 2020-03-21 | Butler | Kansas | 20015 | 2 | 0 |
6412 | 6412 | 2020-03-21 | Cherokee | Kansas | 20021 | 1 | 0 |
6413 | 6413 | 2020-03-21 | Douglas | Kansas | 20045 | 3 | 0 |
6414 | 6414 | 2020-03-21 | Ford | Kansas | 20057 | 1 | 0 |
6415 | 6415 | 2020-03-21 | Franklin | Kansas | 20059 | 1 | 0 |
6417 | 6417 | 2020-03-21 | Leavenworth | Kansas | 20103 | 4 | 0 |
6418 | 6418 | 2020-03-21 | Linn | Kansas | 20107 | 1 | 0 |
6419 | 6419 | 2020-03-21 | Morris | Kansas | 20127 | 2 | 0 |
6420 | 6420 | 2020-03-21 | Reno | Kansas | 20155 | 1 | 0 |
6421 | 6421 | 2020-03-21 | Riley | Kansas | 20161 | 1 | 0 |
6422 | 6422 | 2020-03-21 | Sedgwick | Kansas | 20173 | 2 | 0 |
7478 | 7478 | 2020-03-22 | Butler | Kansas | 20015 | 3 | 0 |
7479 | 7479 | 2020-03-22 | Cherokee | Kansas | 20021 | 1 | 0 |
7480 | 7480 | 2020-03-22 | Douglas | Kansas | 20045 | 4 | 0 |
7481 | 7481 | 2020-03-22 | Ford | Kansas | 20057 | 1 | 0 |
7482 | 7482 | 2020-03-22 | Franklin | Kansas | 20059 | 1 | 0 |
7483 | 7483 | 2020-03-22 | Jackson | Kansas | 20085 | 1 | 0 |
7485 | 7485 | 2020-03-22 | Leavenworth | Kansas | 20103 | 4 | 0 |
7486 | 7486 | 2020-03-22 | Linn | Kansas | 20107 | 1 | 0 |
7487 | 7487 | 2020-03-22 | Mitchell | Kansas | 20123 | 1 | 0 |
7488 | 7488 | 2020-03-22 | Morris | Kansas | 20127 | 2 | 0 |
7489 | 7489 | 2020-03-22 | Reno | Kansas | 20155 | 2 | 0 |
7490 | 7490 | 2020-03-22 | Riley | Kansas | 20161 | 1 | 0 |
7491 | 7491 | 2020-03-22 | Sedgwick | Kansas | 20173 | 2 | 0 |
8638 | 8638 | 2020-03-23 | Bourbon | Kansas | 20011 | 1 | 0 |
8639 | 8639 | 2020-03-23 | Butler | Kansas | 20015 | 3 | 0 |
8640 | 8640 | 2020-03-23 | Cherokee | Kansas | 20021 | 2 | 0 |
8641 | 8641 | 2020-03-23 | Douglas | Kansas | 20045 | 6 | 0 |
8642 | 8642 | 2020-03-23 | Ford | Kansas | 20057 | 1 | 0 |
8643 | 8643 | 2020-03-23 | Franklin | Kansas | 20059 | 1 | 0 |
8644 | 8644 | 2020-03-23 | Jackson | Kansas | 20085 | 1 | 0 |
8646 | 8646 | 2020-03-23 | Leavenworth | Kansas | 20103 | 5 | 0 |
8647 | 8647 | 2020-03-23 | Linn | Kansas | 20107 | 2 | 0 |
8648 | 8648 | 2020-03-23 | Lyon | Kansas | 20111 | 2 | 0 |
8649 | 8649 | 2020-03-23 | Mitchell | Kansas | 20123 | 3 | 0 |
8650 | 8650 | 2020-03-23 | Morris | Kansas | 20127 | 2 | 0 |
8651 | 8651 | 2020-03-23 | Reno | Kansas | 20155 | 2 | 0 |
8652 | 8652 | 2020-03-23 | Riley | Kansas | 20161 | 1 | 0 |
8653 | 8653 | 2020-03-23 | Sedgwick | Kansas | 20173 | 2 | 0 |
9918 | 9918 | 2020-03-24 | Bourbon | Kansas | 20011 | 1 | 0 |
9919 | 9919 | 2020-03-24 | Butler | Kansas | 20015 | 3 | 0 |
9920 | 9920 | 2020-03-24 | Cherokee | Kansas | 20021 | 2 | 0 |
9921 | 9921 | 2020-03-24 | Doniphan | Kansas | 20043 | 1 | 0 |
9922 | 9922 | 2020-03-24 | Douglas | Kansas | 20045 | 6 | 0 |
9923 | 9923 | 2020-03-24 | Ford | Kansas | 20057 | 1 | 0 |
9924 | 9924 | 2020-03-24 | Franklin | Kansas | 20059 | 1 | 0 |
9925 | 9925 | 2020-03-24 | Jackson | Kansas | 20085 | 1 | 0 |
9927 | 9927 | 2020-03-24 | Leavenworth | Kansas | 20103 | 7 | 0 |
9928 | 9928 | 2020-03-24 | Linn | Kansas | 20107 | 2 | 0 |
9929 | 9929 | 2020-03-24 | Lyon | Kansas | 20111 | 2 | 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);