ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

29,087 rows where state = "Kansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Kansas · 29,087 ✖
Link rowid date ▲ county state fips cases deaths
950621 950621 2021-01-21 Allen Kansas 20001 872 1
950622 950622 2021-01-21 Anderson Kansas 20003 731 0
950623 950623 2021-01-21 Atchison Kansas 20005 1387 10
950624 950624 2021-01-21 Barber Kansas 20007 347 2
950625 950625 2021-01-21 Barton Kansas 20009 2445 21
950626 950626 2021-01-21 Bourbon Kansas 20011 1181 3
950627 950627 2021-01-21 Brown Kansas 20013 1154 29
950628 950628 2021-01-21 Butler Kansas 20015 6516 43
950629 950629 2021-01-21 Chase Kansas 20017 258 3
950630 950630 2021-01-21 Chautauqua Kansas 20019 220 3
950631 950631 2021-01-21 Cherokee Kansas 20021 2073 16
950632 950632 2021-01-21 Cheyenne Kansas 20023 332 10
950633 950633 2021-01-21 Clark Kansas 20025 222 4
950634 950634 2021-01-21 Clay Kansas 20027 746 21
950635 950635 2021-01-21 Cloud Kansas 20029 932 2
950636 950636 2021-01-21 Coffey Kansas 20031 591 12
950637 950637 2021-01-21 Comanche Kansas 20033 153 9
950638 950638 2021-01-21 Cowley Kansas 20035 3204 9
950639 950639 2021-01-21 Crawford Kansas 20037 4026 35
950640 950640 2021-01-21 Decatur Kansas 20039 245 1
950641 950641 2021-01-21 Dickinson Kansas 20041 1517 31
950642 950642 2021-01-21 Doniphan Kansas 20043 849 7
950643 950643 2021-01-21 Douglas Kansas 20045 7791 36
950644 950644 2021-01-21 Edwards Kansas 20047 258 0
950645 950645 2021-01-21 Elk Kansas 20049 151 0
950646 950646 2021-01-21 Ellis Kansas 20051 3406 49
950647 950647 2021-01-21 Ellsworth Kansas 20053 1149 4
950648 950648 2021-01-21 Finney Kansas 20055 5828 66
950649 950649 2021-01-21 Ford Kansas 20057 5413 10
950650 950650 2021-01-21 Franklin Kansas 20059 2162 19
950651 950651 2021-01-21 Geary Kansas 20061 2558 21
950652 950652 2021-01-21 Gove Kansas 20063 357 22
950653 950653 2021-01-21 Graham Kansas 20065 238 2
950654 950654 2021-01-21 Grant Kansas 20067 938 15
950655 950655 2021-01-21 Gray Kansas 20069 570 7
950656 950656 2021-01-21 Greeley Kansas 20071 102 0
950657 950657 2021-01-21 Greenwood Kansas 20073 553 2
950658 950658 2021-01-21 Hamilton Kansas 20075 197 0
950659 950659 2021-01-21 Harper Kansas 20077 553 16
950660 950660 2021-01-21 Harvey Kansas 20079 3269 37
950661 950661 2021-01-21 Haskell Kansas 20081 396 1
950662 950662 2021-01-21 Hodgeman Kansas 20083 171 4
950663 950663 2021-01-21 Jackson Kansas 20085 1219 10
950664 950664 2021-01-21 Jefferson Kansas 20087 1458 24
950665 950665 2021-01-21 Jewell Kansas 20089 185 3
950666 950666 2021-01-21 Johnson Kansas 20091 47051 542
950667 950667 2021-01-21 Kearny Kansas 20093 538 9
950668 950668 2021-01-21 Kingman Kansas 20095 630 10
950669 950669 2021-01-21 Kiowa Kansas 20097 232 4
950670 950670 2021-01-21 Labette Kansas 20099 2357 25
950671 950671 2021-01-21 Lane Kansas 20101 135 5
950672 950672 2021-01-21 Leavenworth Kansas 20103 5866 43
950673 950673 2021-01-21 Lincoln Kansas 20105 243 3
950674 950674 2021-01-21 Linn Kansas 20107 676 4
950675 950675 2021-01-21 Logan Kansas 20109 285 0
950676 950676 2021-01-21 Lyon Kansas 20111 3743 68
950677 950677 2021-01-21 Marion Kansas 20115 892 1
950678 950678 2021-01-21 Marshall Kansas 20117 972 22
950679 950679 2021-01-21 McPherson Kansas 20113 2889 50
950680 950680 2021-01-21 Meade Kansas 20119 456 4
950681 950681 2021-01-21 Miami Kansas 20121 2343 25
950682 950682 2021-01-21 Mitchell Kansas 20123 531 0
950683 950683 2021-01-21 Montgomery Kansas 20125 2855 6
950684 950684 2021-01-21 Morris Kansas 20127 502 16
950685 950685 2021-01-21 Morton Kansas 20129 220 9
950686 950686 2021-01-21 Nemaha Kansas 20131 1408 50
950687 950687 2021-01-21 Neosho Kansas 20133 1536 17
950688 950688 2021-01-21 Ness Kansas 20135 332 15
950689 950689 2021-01-21 Norton Kansas 20137 1198 27
950690 950690 2021-01-21 Osage Kansas 20139 1028 10
950691 950691 2021-01-21 Osborne Kansas 20141 261 0
950692 950692 2021-01-21 Ottawa Kansas 20143 496 0
950693 950693 2021-01-21 Pawnee Kansas 20145 1085 8
950694 950694 2021-01-21 Phillips Kansas 20147 640 18
950695 950695 2021-01-21 Pottawatomie Kansas 20149 1391 9
950696 950696 2021-01-21 Pratt Kansas 20151 768 22
950697 950697 2021-01-21 Rawlins Kansas 20153 336 7
950698 950698 2021-01-21 Reno Kansas 20155 7765 111
950699 950699 2021-01-21 Republic Kansas 20157 653 12
950700 950700 2021-01-21 Rice Kansas 20159 949 1
950701 950701 2021-01-21 Riley Kansas 20161 5724 28
950702 950702 2021-01-21 Rooks Kansas 20163 597 9
950703 950703 2021-01-21 Rush Kansas 20165 402 0
950704 950704 2021-01-21 Russell Kansas 20167 791 21
950705 950705 2021-01-21 Saline Kansas 20169 5285 86
950706 950706 2021-01-21 Scott Kansas 20171 576 16
950707 950707 2021-01-21 Sedgwick Kansas 20173 47532 352
950708 950708 2021-01-21 Seward Kansas 20175 3722 28
950709 950709 2021-01-21 Shawnee Kansas 20177 14410 265
950710 950710 2021-01-21 Sheridan Kansas 20179 415 0
950711 950711 2021-01-21 Sherman Kansas 20181 567 7
950712 950712 2021-01-21 Smith Kansas 20183 245 2
950713 950713 2021-01-21 Stafford Kansas 20185 324 9
950714 950714 2021-01-21 Stanton Kansas 20187 170 2
950715 950715 2021-01-21 Stevens Kansas 20189 553 6
950716 950716 2021-01-21 Sumner Kansas 20191 1726 27
950717 950717 2021-01-21 Thomas Kansas 20193 1006 9
950718 950718 2021-01-21 Trego Kansas 20195 362 3
950719 950719 2021-01-21 Unknown Kansas   0 682
950720 950720 2021-01-21 Wabaunsee Kansas 20197 570 13

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);