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

105 rows where date = "2020-10-27" and state = "Kansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Kansas · 105 ✖
Link rowid date ▲ county state fips cases deaths
671474 671474 2020-10-27 Allen Kansas 20001 112 1
671475 671475 2020-10-27 Anderson Kansas 20003 188 0
671476 671476 2020-10-27 Atchison Kansas 20005 512 5
671477 671477 2020-10-27 Barber Kansas 20007 51 0
671478 671478 2020-10-27 Barton Kansas 20009 751 7
671479 671479 2020-10-27 Bourbon Kansas 20011 303 3
671480 671480 2020-10-27 Brown Kansas 20013 220 5
671481 671481 2020-10-27 Butler Kansas 20015 1470 4
671482 671482 2020-10-27 Chase Kansas 20017 107 3
671483 671483 2020-10-27 Chautauqua Kansas 20019 27 0
671484 671484 2020-10-27 Cherokee Kansas 20021 676 8
671485 671485 2020-10-27 Cheyenne Kansas 20023 120 5
671486 671486 2020-10-27 Clark Kansas 20025 68 1
671487 671487 2020-10-27 Clay Kansas 20027 101 3
671488 671488 2020-10-27 Cloud Kansas 20029 133 1
671489 671489 2020-10-27 Coffey Kansas 20031 161 9
671490 671490 2020-10-27 Comanche Kansas 20033 20 0
671491 671491 2020-10-27 Cowley Kansas 20035 527 10
671492 671492 2020-10-27 Crawford Kansas 20037 1446 10
671493 671493 2020-10-27 Decatur Kansas 20039 97 1
671494 671494 2020-10-27 Dickinson Kansas 20041 304 3
671495 671495 2020-10-27 Doniphan Kansas 20043 200 0
671496 671496 2020-10-27 Douglas Kansas 20045 2877 18
671497 671497 2020-10-27 Edwards Kansas 20047 69 0
671498 671498 2020-10-27 Elk Kansas 20049 15 0
671499 671499 2020-10-27 Ellis Kansas 20051 1372 18
671500 671500 2020-10-27 Ellsworth Kansas 20053 231 0
671501 671501 2020-10-27 Finney Kansas 20055 2976 18
671502 671502 2020-10-27 Ford Kansas 20057 3371 10
671503 671503 2020-10-27 Franklin Kansas 20059 533 3
671504 671504 2020-10-27 Geary Kansas 20061 554 4
671505 671505 2020-10-27 Gove Kansas 20063 171 11
671506 671506 2020-10-27 Graham Kansas 20065 51 1
671507 671507 2020-10-27 Grant Kansas 20067 434 8
671508 671508 2020-10-27 Gray Kansas 20069 180 0
671509 671509 2020-10-27 Greeley Kansas 20071 34 0
671510 671510 2020-10-27 Greenwood Kansas 20073 89 0
671511 671511 2020-10-27 Hamilton Kansas 20075 69 0
671512 671512 2020-10-27 Harper Kansas 20077 152 2
671513 671513 2020-10-27 Harvey Kansas 20079 572 8
671514 671514 2020-10-27 Haskell Kansas 20081 162 1
671515 671515 2020-10-27 Hodgeman Kansas 20083 33 0
671516 671516 2020-10-27 Jackson Kansas 20085 320 4
671517 671517 2020-10-27 Jefferson Kansas 20087 281 6
671518 671518 2020-10-27 Jewell Kansas 20089 29 1
671519 671519 2020-10-27 Johnson Kansas 20091 14581 196
671520 671520 2020-10-27 Kearny Kansas 20093 159 6
671521 671521 2020-10-27 Kingman Kansas 20095 137 3
671522 671522 2020-10-27 Kiowa Kansas 20097 62 0
671523 671523 2020-10-27 Labette Kansas 20099 384 6
671524 671524 2020-10-27 Lane Kansas 20101 24 1
671525 671525 2020-10-27 Leavenworth Kansas 20103 2613 18
671526 671526 2020-10-27 Lincoln Kansas 20105 22 1
671527 671527 2020-10-27 Linn Kansas 20107 123 1
671528 671528 2020-10-27 Logan Kansas 20109 93 0
671529 671529 2020-10-27 Lyon Kansas 20111 1253 40
671530 671530 2020-10-27 Marion Kansas 20115 172 1
671531 671531 2020-10-27 Marshall Kansas 20117 73 0
671532 671532 2020-10-27 McPherson Kansas 20113 395 6
671533 671533 2020-10-27 Meade Kansas 20119 165 2
671534 671534 2020-10-27 Miami Kansas 20121 539 2
671535 671535 2020-10-27 Mitchell Kansas 20123 57 0
671536 671536 2020-10-27 Montgomery Kansas 20125 689 6
671537 671537 2020-10-27 Morris Kansas 20127 60 0
671538 671538 2020-10-27 Morton Kansas 20129 55 2
671539 671539 2020-10-27 Nemaha Kansas 20131 315 2
671540 671540 2020-10-27 Neosho Kansas 20133 239 0
671541 671541 2020-10-27 Ness Kansas 20135 148 9
671542 671542 2020-10-27 Norton Kansas 20137 576 14
671543 671543 2020-10-27 Osage Kansas 20139 163 2
671544 671544 2020-10-27 Osborne Kansas 20141 26 0
671545 671545 2020-10-27 Ottawa Kansas 20143 113 0
671546 671546 2020-10-27 Pawnee Kansas 20145 431 1
671547 671547 2020-10-27 Phillips Kansas 20147 193 9
671548 671548 2020-10-27 Pottawatomie Kansas 20149 381 0
671549 671549 2020-10-27 Pratt Kansas 20151 123 0
671550 671550 2020-10-27 Rawlins Kansas 20153 144 0
671551 671551 2020-10-27 Reno Kansas 20155 2143 16
671552 671552 2020-10-27 Republic Kansas 20157 79 1
671553 671553 2020-10-27 Rice Kansas 20159 141 1
671554 671554 2020-10-27 Riley Kansas 20161 2084 11
671555 671555 2020-10-27 Rooks Kansas 20163 151 7
671556 671556 2020-10-27 Rush Kansas 20165 101 0
671557 671557 2020-10-27 Russell Kansas 20167 179 4
671558 671558 2020-10-27 Saline Kansas 20169 1087 13
671559 671559 2020-10-27 Scott Kansas 20171 206 1
671560 671560 2020-10-27 Sedgwick Kansas 20173 12004 127
671561 671561 2020-10-27 Seward Kansas 20175 2081 13
671562 671562 2020-10-27 Shawnee Kansas 20177 3528 81
671563 671563 2020-10-27 Sheridan Kansas 20179 162 0
671564 671564 2020-10-27 Sherman Kansas 20181 230 4
671565 671565 2020-10-27 Smith Kansas 20183 22 0
671566 671566 2020-10-27 Stafford Kansas 20185 81 1
671567 671567 2020-10-27 Stanton Kansas 20187 97 2
671568 671568 2020-10-27 Stevens Kansas 20189 227 1
671569 671569 2020-10-27 Sumner Kansas 20191 306 4
671570 671570 2020-10-27 Thomas Kansas 20193 338 2
671571 671571 2020-10-27 Trego Kansas 20195 99 3
671572 671572 2020-10-27 Wabaunsee Kansas 20197 87 1
671573 671573 2020-10-27 Wallace Kansas 20199 52 0

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