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

33,751 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 · 33,751 ✖
Link rowid date ▲ county state fips cases deaths
1093348 1093348 2021-03-06 Allen Kansas 20001 1146 1
1093349 1093349 2021-03-06 Anderson Kansas 20003 816 0
1093350 1093350 2021-03-06 Atchison Kansas 20005 1531 13
1093351 1093351 2021-03-06 Barber Kansas 20007 367 2
1093352 1093352 2021-03-06 Barton Kansas 20009 2574 21
1093353 1093353 2021-03-06 Bourbon Kansas 20011 1288 3
1093354 1093354 2021-03-06 Brown Kansas 20013 1217 32
1093355 1093355 2021-03-06 Butler Kansas 20015 7235 76
1093356 1093356 2021-03-06 Chase Kansas 20017 285 3
1093357 1093357 2021-03-06 Chautauqua Kansas 20019 260 3
1093358 1093358 2021-03-06 Cherokee Kansas 20021 2369 16
1093359 1093359 2021-03-06 Cheyenne Kansas 20023 354 10
1093360 1093360 2021-03-06 Clark Kansas 20025 244 4
1093361 1093361 2021-03-06 Clay Kansas 20027 824 27
1093362 1093362 2021-03-06 Cloud Kansas 20029 969 2
1093363 1093363 2021-03-06 Coffey Kansas 20031 712 14
1093364 1093364 2021-03-06 Comanche Kansas 20033 159 9
1093365 1093365 2021-03-06 Cowley Kansas 20035 3824 9
1093366 1093366 2021-03-06 Crawford Kansas 20037 4537 80
1093367 1093367 2021-03-06 Decatur Kansas 20039 259 1
1093368 1093368 2021-03-06 Dickinson Kansas 20041 1691 36
1093369 1093369 2021-03-06 Doniphan Kansas 20043 945 7
1093370 1093370 2021-03-06 Douglas Kansas 20045 8679 79
1093371 1093371 2021-03-06 Edwards Kansas 20047 262 0
1093372 1093372 2021-03-06 Elk Kansas 20049 176 0
1093373 1093373 2021-03-06 Ellis Kansas 20051 3692 61
1093374 1093374 2021-03-06 Ellsworth Kansas 20053 1211 4
1093375 1093375 2021-03-06 Finney Kansas 20055 5989 108
1093376 1093376 2021-03-06 Ford Kansas 20057 5592 10
1093377 1093377 2021-03-06 Franklin Kansas 20059 2456 39
1093378 1093378 2021-03-06 Geary Kansas 20061 3063 25
1093379 1093379 2021-03-06 Gove Kansas 20063 385 22
1093380 1093380 2021-03-06 Graham Kansas 20065 250 2
1093381 1093381 2021-03-06 Grant Kansas 20067 966 17
1093382 1093382 2021-03-06 Gray Kansas 20069 602 14
1093383 1093383 2021-03-06 Greeley Kansas 20071 101 0
1093384 1093384 2021-03-06 Greenwood Kansas 20073 589 8
1093385 1093385 2021-03-06 Hamilton Kansas 20075 201 0
1093386 1093386 2021-03-06 Harper Kansas 20077 605 17
1093387 1093387 2021-03-06 Harvey Kansas 20079 3436 59
1093388 1093388 2021-03-06 Haskell Kansas 20081 408 1
1093389 1093389 2021-03-06 Hodgeman Kansas 20083 206 6
1093390 1093390 2021-03-06 Jackson Kansas 20085 1339 15
1093391 1093391 2021-03-06 Jefferson Kansas 20087 1623 32
1093392 1093392 2021-03-06 Jewell Kansas 20089 202 3
1093393 1093393 2021-03-06 Johnson Kansas 20091 54730 640
1093394 1093394 2021-03-06 Kearny Kansas 20093 561 9
1093395 1093395 2021-03-06 Kingman Kansas 20095 729 11
1093396 1093396 2021-03-06 Kiowa Kansas 20097 266 5
1093397 1093397 2021-03-06 Labette Kansas 20099 2621 48
1093398 1093398 2021-03-06 Lane Kansas 20101 142 5
1093399 1093399 2021-03-06 Leavenworth Kansas 20103 6833 50
1093400 1093400 2021-03-06 Lincoln Kansas 20105 256 4
1093401 1093401 2021-03-06 Linn Kansas 20107 767 12
1093402 1093402 2021-03-06 Logan Kansas 20109 292 0
1093403 1093403 2021-03-06 Lyon Kansas 20111 4115 81
1093404 1093404 2021-03-06 Marion Kansas 20115 1029 24
1093405 1093405 2021-03-06 Marshall Kansas 20117 1074 23
1093406 1093406 2021-03-06 McPherson Kansas 20113 3166 81
1093407 1093407 2021-03-06 Meade Kansas 20119 495 9
1093408 1093408 2021-03-06 Miami Kansas 20121 2650 25
1093409 1093409 2021-03-06 Mitchell Kansas 20123 559 0
1093410 1093410 2021-03-06 Montgomery Kansas 20125 3310 6
1093411 1093411 2021-03-06 Morris Kansas 20127 598 20
1093412 1093412 2021-03-06 Morton Kansas 20129 254 9
1093413 1093413 2021-03-06 Nemaha Kansas 20131 1486 50
1093414 1093414 2021-03-06 Neosho Kansas 20133 1761 22
1093415 1093415 2021-03-06 Ness Kansas 20135 365 15
1093416 1093416 2021-03-06 Norton Kansas 20137 1217 27
1093417 1093417 2021-03-06 Osage Kansas 20139 1194 11
1093418 1093418 2021-03-06 Osborne Kansas 20141 287 0
1093419 1093419 2021-03-06 Ottawa Kansas 20143 548 0
1093420 1093420 2021-03-06 Pawnee Kansas 20145 1137 14
1093421 1093421 2021-03-06 Phillips Kansas 20147 705 19
1093422 1093422 2021-03-06 Pottawatomie Kansas 20149 1772 27
1093423 1093423 2021-03-06 Pratt Kansas 20151 807 23
1093424 1093424 2021-03-06 Rawlins Kansas 20153 355 7
1093425 1093425 2021-03-06 Reno Kansas 20155 8308 126
1093426 1093426 2021-03-06 Republic Kansas 20157 679 14
1093427 1093427 2021-03-06 Rice Kansas 20159 1059 1
1093428 1093428 2021-03-06 Riley Kansas 20161 6216 33
1093429 1093429 2021-03-06 Rooks Kansas 20163 639 10
1093430 1093430 2021-03-06 Rush Kansas 20165 425 0
1093431 1093431 2021-03-06 Russell Kansas 20167 845 23
1093432 1093432 2021-03-06 Saline Kansas 20169 5993 106
1093433 1093433 2021-03-06 Scott Kansas 20171 605 21
1093434 1093434 2021-03-06 Sedgwick Kansas 20173 53962 532
1093435 1093435 2021-03-06 Seward Kansas 20175 3893 33
1093436 1093436 2021-03-06 Shawnee Kansas 20177 16478 344
1093437 1093437 2021-03-06 Sheridan Kansas 20179 428 0
1093438 1093438 2021-03-06 Sherman Kansas 20181 610 7
1093439 1093439 2021-03-06 Smith Kansas 20183 271 2
1093440 1093440 2021-03-06 Stafford Kansas 20185 346 9
1093441 1093441 2021-03-06 Stanton Kansas 20187 184 2
1093442 1093442 2021-03-06 Stevens Kansas 20189 580 7
1093443 1093443 2021-03-06 Sumner Kansas 20191 2077 27
1093444 1093444 2021-03-06 Thomas Kansas 20193 1123 14
1093445 1093445 2021-03-06 Trego Kansas 20195 406 3
1093446 1093446 2021-03-06 Unknown Kansas   0 1022
1093447 1093447 2021-03-06 Wabaunsee Kansas 20197 665 14

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