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

57,208 rows where state = "Kansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Kansas · 57,208 ✖
Link rowid date ▲ county state fips cases deaths
1817511 1817511 2021-10-15 Allen Kansas 20001 1851 27
1817512 1817512 2021-10-15 Anderson Kansas 20003 1089 21
1817513 1817513 2021-10-15 Atchison Kansas 20005 2336 24
1817514 1817514 2021-10-15 Barber Kansas 20007 489 7
1817515 1817515 2021-10-15 Barton Kansas 20009 3771 56
1817516 1817516 2021-10-15 Bourbon Kansas 20011 2407 41
1817517 1817517 2021-10-15 Brown Kansas 20013 1515 40
1817518 1817518 2021-10-15 Butler Kansas 20015 10680 121
1817519 1817519 2021-10-15 Chase Kansas 20017 342 4
1817520 1817520 2021-10-15 Chautauqua Kansas 20019 490 8
1817521 1817521 2021-10-15 Cherokee Kansas 20021 3586 77
1817522 1817522 2021-10-15 Cheyenne Kansas 20023 424 13
1817523 1817523 2021-10-15 Clark Kansas 20025 318 7
1817524 1817524 2021-10-15 Clay Kansas 20027 1204 31
1817525 1817525 2021-10-15 Cloud Kansas 20029 1280 27
1817526 1817526 2021-10-15 Coffey Kansas 20031 1154 26
1817527 1817527 2021-10-15 Comanche Kansas 20033 247 11
1817528 1817528 2021-10-15 Cowley Kansas 20035 5521 124
1817529 1817529 2021-10-15 Crawford Kansas 20037 6656 113
1817530 1817530 2021-10-15 Decatur Kansas 20039 332 13
1817531 1817531 2021-10-15 Dickinson Kansas 20041 2808 60
1817532 1817532 2021-10-15 Doniphan Kansas 20043 1351 27
1817533 1817533 2021-10-15 Douglas Kansas 20045 12244 101
1817534 1817534 2021-10-15 Edwards Kansas 20047 336 13
1817535 1817535 2021-10-15 Elk Kansas 20049 275 6
1817536 1817536 2021-10-15 Ellis Kansas 20051 4467 76
1817537 1817537 2021-10-15 Ellsworth Kansas 20053 1362 28
1817538 1817538 2021-10-15 Finney Kansas 20055 7249 81
1817539 1817539 2021-10-15 Ford Kansas 20057 7020 90
1817540 1817540 2021-10-15 Franklin Kansas 20059 3724 55
1817541 1817541 2021-10-15 Geary Kansas 20061 4681 54
1817542 1817542 2021-10-15 Gove Kansas 20063 461 22
1817543 1817543 2021-10-15 Graham Kansas 20065 319 10
1817544 1817544 2021-10-15 Grant Kansas 20067 1202 27
1817545 1817545 2021-10-15 Gray Kansas 20069 825 16
1817546 1817546 2021-10-15 Greeley Kansas 20071 150 2
1817547 1817547 2021-10-15 Greenwood Kansas 20073 958 14
1817548 1817548 2021-10-15 Hamilton Kansas 20075 269 1
1817549 1817549 2021-10-15 Harper Kansas 20077 895 19
1817550 1817550 2021-10-15 Harvey Kansas 20079 4863 80
1817551 1817551 2021-10-15 Haskell Kansas 20081 530 8
1817552 1817552 2021-10-15 Hodgeman Kansas 20083 228 10
1817553 1817553 2021-10-15 Jackson Kansas 20085 1936 19
1817554 1817554 2021-10-15 Jefferson Kansas 20087 2544 47
1817555 1817555 2021-10-15 Jewell Kansas 20089 391 8
1817556 1817556 2021-10-15 Johnson Kansas 20091 76717 912
1817557 1817557 2021-10-15 Kearny Kansas 20093 722 12
1817558 1817558 2021-10-15 Kingman Kansas 20095 1106 20
1817559 1817559 2021-10-15 Kiowa Kansas 20097 345 5
1817560 1817560 2021-10-15 Labette Kansas 20099 3467 59
1817561 1817561 2021-10-15 Lane Kansas 20101 164 7
1817562 1817562 2021-10-15 Leavenworth Kansas 20103 10181 121
1817563 1817563 2021-10-15 Lincoln Kansas 20105 339 5
1817564 1817564 2021-10-15 Linn Kansas 20107 1569 15
1817565 1817565 2021-10-15 Logan Kansas 20109 401 8
1817566 1817566 2021-10-15 Lyon Kansas 20111 5365 91
1817567 1817567 2021-10-15 Marion Kansas 20115 1549 27
1817568 1817568 2021-10-15 Marshall Kansas 20117 1425 28
1817569 1817569 2021-10-15 McPherson Kansas 20113 4327 93
1817570 1817570 2021-10-15 Meade Kansas 20119 661 14
1817571 1817571 2021-10-15 Miami Kansas 20121 4262 59
1817572 1817572 2021-10-15 Mitchell Kansas 20123 752 17
1817573 1817573 2021-10-15 Montgomery Kansas 20125 5307 107
1817574 1817574 2021-10-15 Morris Kansas 20127 755 23
1817575 1817575 2021-10-15 Morton Kansas 20129 337 9
1817576 1817576 2021-10-15 Nemaha Kansas 20131 1874 56
1817577 1817577 2021-10-15 Neosho Kansas 20133 2501 49
1817578 1817578 2021-10-15 Ness Kansas 20135 484 17
1817579 1817579 2021-10-15 Norton Kansas 20137 1382 30
1817580 1817580 2021-10-15 Osage Kansas 20139 1944 34
1817581 1817581 2021-10-15 Osborne Kansas 20141 399 14
1817582 1817582 2021-10-15 Ottawa Kansas 20143 700 14
1817583 1817583 2021-10-15 Pawnee Kansas 20145 1430 15
1817584 1817584 2021-10-15 Phillips Kansas 20147 836 26
1817585 1817585 2021-10-15 Pottawatomie Kansas 20149 2746 42
1817586 1817586 2021-10-15 Pratt Kansas 20151 1183 26
1817587 1817587 2021-10-15 Rawlins Kansas 20153 405 7
1817588 1817588 2021-10-15 Reno Kansas 20155 11025 163
1817589 1817589 2021-10-15 Republic Kansas 20157 868 15
1817590 1817590 2021-10-15 Rice Kansas 20159 1423 15
1817591 1817591 2021-10-15 Riley Kansas 20161 7920 59
1817592 1817592 2021-10-15 Rooks Kansas 20163 772 11
1817593 1817593 2021-10-15 Rush Kansas 20165 498 15
1817594 1817594 2021-10-15 Russell Kansas 20167 1074 33
1817595 1817595 2021-10-15 Saline Kansas 20169 8189 174
1817596 1817596 2021-10-15 Scott Kansas 20171 737 27
1817597 1817597 2021-10-15 Sedgwick Kansas 20173 79517 957
1817598 1817598 2021-10-15 Seward Kansas 20175 4611 46
1817599 1817599 2021-10-15 Shawnee Kansas 20177 25162 445
1817600 1817600 2021-10-15 Sheridan Kansas 20179 487 14
1817601 1817601 2021-10-15 Sherman Kansas 20181 771 13
1817602 1817602 2021-10-15 Smith Kansas 20183 381 3
1817603 1817603 2021-10-15 Stafford Kansas 20185 559 16
1817604 1817604 2021-10-15 Stanton Kansas 20187 271 6
1817605 1817605 2021-10-15 Stevens Kansas 20189 729 12
1817606 1817606 2021-10-15 Sumner Kansas 20191 3156 60
1817607 1817607 2021-10-15 Thomas Kansas 20193 1340 22
1817608 1817608 2021-10-15 Trego Kansas 20195 478 8
1817609 1817609 2021-10-15 Wabaunsee Kansas 20197 892 18
1817610 1817610 2021-10-15 Wallace Kansas 20199 229 4

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);