home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

79,294 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 >30

  • 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
  • …

county >30

  • 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
  • …

state 1

  • Kansas · 79,294 ✖
Link rowid date ▲ county state fips cases deaths
2500473 2500473 2022-05-13 Allen Kansas 20001 3989 53
2500474 2500474 2022-05-13 Anderson Kansas 20003 2133 29
2500475 2500475 2022-05-13 Atchison Kansas 20005 4323 34
2500476 2500476 2022-05-13 Barber Kansas 20007 1043 8
2500477 2500477 2022-05-13 Barton Kansas 20009 6508 96
2500478 2500478 2022-05-13 Bourbon Kansas 20011 4391 52
2500479 2500479 2022-05-13 Brown Kansas 20013 2735 46
2500480 2500480 2022-05-13 Butler Kansas 20015 19104 192
2500481 2500481 2022-05-13 Chase Kansas 20017 673 7
2500482 2500482 2022-05-13 Chautauqua Kansas 20019 844 17
2500483 2500483 2022-05-13 Cherokee Kansas 20021 6158 84
2500484 2500484 2022-05-13 Cheyenne Kansas 20023 652 14
2500485 2500485 2022-05-13 Clark Kansas 20025 504 8
2500486 2500486 2022-05-13 Clay Kansas 20027 1985 35
2500487 2500487 2022-05-13 Cloud Kansas 20029 2219 36
2500488 2500488 2022-05-13 Coffey Kansas 20031 2435 42
2500489 2500489 2022-05-13 Comanche Kansas 20033 441 16
2500490 2500490 2022-05-13 Cowley Kansas 20035 10194 152
2500491 2500491 2022-05-13 Crawford Kansas 20037 11966 130
2500492 2500492 2022-05-13 Decatur Kansas 20039 620 20
2500493 2500493 2022-05-13 Dickinson Kansas 20041 4815 78
2500494 2500494 2022-05-13 Doniphan Kansas 20043 2456 34
2500495 2500495 2022-05-13 Douglas Kansas 20045 27394 139
2500496 2500496 2022-05-13 Edwards Kansas 20047 556 13
2500497 2500497 2022-05-13 Elk Kansas 20049 571 10
2500498 2500498 2022-05-13 Ellis Kansas 20051 7165 84
2500499 2500499 2022-05-13 Ellsworth Kansas 20053 2016 32
2500500 2500500 2022-05-13 Finney Kansas 20055 11545 115
2500501 2500501 2022-05-13 Ford Kansas 20057 10629 113
2500502 2500502 2022-05-13 Franklin Kansas 20059 7018 81
2500503 2500503 2022-05-13 Geary Kansas 20061 9262 75
2500504 2500504 2022-05-13 Gove Kansas 20063 790 23
2500505 2500505 2022-05-13 Graham Kansas 20065 572 15
2500506 2500506 2022-05-13 Grant Kansas 20067 2265 36
2500507 2500507 2022-05-13 Gray Kansas 20069 1236 23
2500508 2500508 2022-05-13 Greeley Kansas 20071 331 3
2500509 2500509 2022-05-13 Greenwood Kansas 20073 1807 23
2500510 2500510 2022-05-13 Hamilton Kansas 20075 464 3
2500511 2500511 2022-05-13 Harper Kansas 20077 1654 27
2500512 2500512 2022-05-13 Harvey Kansas 20079 9636 124
2500513 2500513 2022-05-13 Haskell Kansas 20081 964 11
2500514 2500514 2022-05-13 Hodgeman Kansas 20083 411 10
2500515 2500515 2022-05-13 Jackson Kansas 20085 3908 29
2500516 2500516 2022-05-13 Jefferson Kansas 20087 4832 63
2500517 2500517 2022-05-13 Jewell Kansas 20089 788 13
2500518 2500518 2022-05-13 Johnson Kansas 20091 148890 1219
2500519 2500519 2022-05-13 Kearny Kansas 20093 1236 20
2500520 2500520 2022-05-13 Kingman Kansas 20095 1967 28
2500521 2500521 2022-05-13 Kiowa Kansas 20097 667 7
2500522 2500522 2022-05-13 Labette Kansas 20099 6636 74
2500523 2500523 2022-05-13 Lane Kansas 20101 296 12
2500524 2500524 2022-05-13 Leavenworth Kansas 20103 19619 183
2500525 2500525 2022-05-13 Lincoln Kansas 20105 623 10
2500526 2500526 2022-05-13 Linn Kansas 20107 2827 28
2500527 2500527 2022-05-13 Logan Kansas 20109 844 13
2500528 2500528 2022-05-13 Lyon Kansas 20111 10084 122
2500529 2500529 2022-05-13 Marion Kansas 20115 3337 43
2500530 2500530 2022-05-13 Marshall Kansas 20117 2559 42
2500531 2500531 2022-05-13 McPherson Kansas 20113 7944 126
2500532 2500532 2022-05-13 Meade Kansas 20119 1221 20
2500533 2500533 2022-05-13 Miami Kansas 20121 7865 93
2500534 2500534 2022-05-13 Mitchell Kansas 20123 1428 22
2500535 2500535 2022-05-13 Montgomery Kansas 20125 9448 154
2500536 2500536 2022-05-13 Morris Kansas 20127 1513 28
2500537 2500537 2022-05-13 Morton Kansas 20129 621 11
2500538 2500538 2022-05-13 Nemaha Kansas 20131 3243 60
2500539 2500539 2022-05-13 Neosho Kansas 20133 5168 66
2500540 2500540 2022-05-13 Ness Kansas 20135 780 18
2500541 2500541 2022-05-13 Norton Kansas 20137 2153 37
2500542 2500542 2022-05-13 Osage Kansas 20139 3946 49
2500543 2500543 2022-05-13 Osborne Kansas 20141 803 17
2500544 2500544 2022-05-13 Ottawa Kansas 20143 1210 17
2500545 2500545 2022-05-13 Pawnee Kansas 20145 2138 24
2500546 2500546 2022-05-13 Phillips Kansas 20147 1358 30
2500547 2500547 2022-05-13 Pottawatomie Kansas 20149 5785 58
2500548 2500548 2022-05-13 Pratt Kansas 20151 1931 30
2500549 2500549 2022-05-13 Rawlins Kansas 20153 683 9
2500550 2500550 2022-05-13 Reno Kansas 20155 18632 238
2500551 2500551 2022-05-13 Republic Kansas 20157 1354 16
2500552 2500552 2022-05-13 Rice Kansas 20159 2614 23
2500553 2500553 2022-05-13 Riley Kansas 20161 13711 85
2500554 2500554 2022-05-13 Rooks Kansas 20163 1377 20
2500555 2500555 2022-05-13 Rush Kansas 20165 808 18
2500556 2500556 2022-05-13 Russell Kansas 20167 1883 37
2500557 2500557 2022-05-13 Saline Kansas 20169 14159 246
2500558 2500558 2022-05-13 Scott Kansas 20171 1277 34
2500559 2500559 2022-05-13 Sedgwick Kansas 20173 145517 1424
2500560 2500560 2022-05-13 Seward Kansas 20175 6916 61
2500561 2500561 2022-05-13 Shawnee Kansas 20177 48858 633
2500562 2500562 2022-05-13 Sheridan Kansas 20179 786 18
2500563 2500563 2022-05-13 Sherman Kansas 20181 1514 20
2500564 2500564 2022-05-13 Smith Kansas 20183 645 7
2500565 2500565 2022-05-13 Stafford Kansas 20185 1139 26
2500566 2500566 2022-05-13 Stanton Kansas 20187 427 8
2500567 2500567 2022-05-13 Stevens Kansas 20189 1465 20
2500568 2500568 2022-05-13 Sumner Kansas 20191 5724 70
2500569 2500569 2022-05-13 Thomas Kansas 20193 2394 28
2500570 2500570 2022-05-13 Trego Kansas 20195 756 10
2500571 2500571 2022-05-13 Unknown Kansas   0 137
2500572 2500572 2022-05-13 Wabaunsee Kansas 20197 1642 22

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);
Powered by Datasette · Queries took 754.453ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette