ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where "date" is on date 2020-10-15 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
632533 | 632533 | 2020-10-15 | Allen | Kansas | 20001 | 104 | 1 |
632534 | 632534 | 2020-10-15 | Anderson | Kansas | 20003 | 113 | 0 |
632535 | 632535 | 2020-10-15 | Atchison | Kansas | 20005 | 437 | 4 |
632536 | 632536 | 2020-10-15 | Barber | Kansas | 20007 | 31 | 0 |
632537 | 632537 | 2020-10-15 | Barton | Kansas | 20009 | 670 | 7 |
632538 | 632538 | 2020-10-15 | Bourbon | Kansas | 20011 | 264 | 3 |
632539 | 632539 | 2020-10-15 | Brown | Kansas | 20013 | 182 | 5 |
632540 | 632540 | 2020-10-15 | Butler | Kansas | 20015 | 1227 | 4 |
632541 | 632541 | 2020-10-15 | Chase | Kansas | 20017 | 87 | 1 |
632542 | 632542 | 2020-10-15 | Chautauqua | Kansas | 20019 | 24 | 0 |
632543 | 632543 | 2020-10-15 | Cherokee | Kansas | 20021 | 601 | 8 |
632544 | 632544 | 2020-10-15 | Cheyenne | Kansas | 20023 | 90 | 5 |
632545 | 632545 | 2020-10-15 | Clark | Kansas | 20025 | 60 | 1 |
632546 | 632546 | 2020-10-15 | Clay | Kansas | 20027 | 68 | 2 |
632547 | 632547 | 2020-10-15 | Cloud | Kansas | 20029 | 96 | 1 |
632548 | 632548 | 2020-10-15 | Coffey | Kansas | 20031 | 139 | 9 |
632549 | 632549 | 2020-10-15 | Comanche | Kansas | 20033 | 19 | 0 |
632550 | 632550 | 2020-10-15 | Cowley | Kansas | 20035 | 464 | 9 |
632551 | 632551 | 2020-10-15 | Crawford | Kansas | 20037 | 1294 | 8 |
632552 | 632552 | 2020-10-15 | Decatur | Kansas | 20039 | 44 | 1 |
632553 | 632553 | 2020-10-15 | Dickinson | Kansas | 20041 | 261 | 3 |
632554 | 632554 | 2020-10-15 | Doniphan | Kansas | 20043 | 157 | 0 |
632555 | 632555 | 2020-10-15 | Douglas | Kansas | 20045 | 2681 | 14 |
632556 | 632556 | 2020-10-15 | Edwards | Kansas | 20047 | 60 | 0 |
632557 | 632557 | 2020-10-15 | Elk | Kansas | 20049 | 13 | 0 |
632558 | 632558 | 2020-10-15 | Ellis | Kansas | 20051 | 1235 | 14 |
632559 | 632559 | 2020-10-15 | Ellsworth | Kansas | 20053 | 133 | 0 |
632560 | 632560 | 2020-10-15 | Finney | Kansas | 20055 | 2562 | 16 |
632561 | 632561 | 2020-10-15 | Ford | Kansas | 20057 | 3203 | 10 |
632562 | 632562 | 2020-10-15 | Franklin | Kansas | 20059 | 473 | 3 |
632563 | 632563 | 2020-10-15 | Geary | Kansas | 20061 | 492 | 4 |
632564 | 632564 | 2020-10-15 | Gove | Kansas | 20063 | 136 | 2 |
632565 | 632565 | 2020-10-15 | Graham | Kansas | 20065 | 50 | 1 |
632566 | 632566 | 2020-10-15 | Grant | Kansas | 20067 | 379 | 8 |
632567 | 632567 | 2020-10-15 | Gray | Kansas | 20069 | 157 | 0 |
632568 | 632568 | 2020-10-15 | Greeley | Kansas | 20071 | 23 | 0 |
632569 | 632569 | 2020-10-15 | Greenwood | Kansas | 20073 | 67 | 0 |
632570 | 632570 | 2020-10-15 | Hamilton | Kansas | 20075 | 52 | 0 |
632571 | 632571 | 2020-10-15 | Harper | Kansas | 20077 | 126 | 2 |
632572 | 632572 | 2020-10-15 | Harvey | Kansas | 20079 | 465 | 8 |
632573 | 632573 | 2020-10-15 | Haskell | Kansas | 20081 | 154 | 1 |
632574 | 632574 | 2020-10-15 | Hodgeman | Kansas | 20083 | 30 | 0 |
632575 | 632575 | 2020-10-15 | Jackson | Kansas | 20085 | 279 | 3 |
632576 | 632576 | 2020-10-15 | Jefferson | Kansas | 20087 | 247 | 4 |
632577 | 632577 | 2020-10-15 | Jewell | Kansas | 20089 | 20 | 1 |
632578 | 632578 | 2020-10-15 | Johnson | Kansas | 20091 | 13167 | 171 |
632579 | 632579 | 2020-10-15 | Kearny | Kansas | 20093 | 123 | 3 |
632580 | 632580 | 2020-10-15 | Kingman | Kansas | 20095 | 114 | 3 |
632581 | 632581 | 2020-10-15 | Kiowa | Kansas | 20097 | 42 | 0 |
632582 | 632582 | 2020-10-15 | Labette | Kansas | 20099 | 316 | 5 |
632583 | 632583 | 2020-10-15 | Lane | Kansas | 20101 | 17 | 1 |
632584 | 632584 | 2020-10-15 | Leavenworth | Kansas | 20103 | 2449 | 17 |
632585 | 632585 | 2020-10-15 | Lincoln | Kansas | 20105 | 16 | 1 |
632586 | 632586 | 2020-10-15 | Linn | Kansas | 20107 | 125 | 1 |
632587 | 632587 | 2020-10-15 | Logan | Kansas | 20109 | 60 | 0 |
632588 | 632588 | 2020-10-15 | Lyon | Kansas | 20111 | 1171 | 37 |
632589 | 632589 | 2020-10-15 | Marion | Kansas | 20115 | 134 | 1 |
632590 | 632590 | 2020-10-15 | Marshall | Kansas | 20117 | 61 | 0 |
632591 | 632591 | 2020-10-15 | McPherson | Kansas | 20113 | 313 | 3 |
632592 | 632592 | 2020-10-15 | Meade | Kansas | 20119 | 156 | 1 |
632593 | 632593 | 2020-10-15 | Miami | Kansas | 20121 | 480 | 2 |
632594 | 632594 | 2020-10-15 | Mitchell | Kansas | 20123 | 55 | 0 |
632595 | 632595 | 2020-10-15 | Montgomery | Kansas | 20125 | 582 | 6 |
632596 | 632596 | 2020-10-15 | Morris | Kansas | 20127 | 50 | 0 |
632597 | 632597 | 2020-10-15 | Morton | Kansas | 20129 | 31 | 2 |
632598 | 632598 | 2020-10-15 | Nemaha | Kansas | 20131 | 217 | 1 |
632599 | 632599 | 2020-10-15 | Neosho | Kansas | 20133 | 201 | 0 |
632600 | 632600 | 2020-10-15 | Ness | Kansas | 20135 | 112 | 8 |
632601 | 632601 | 2020-10-15 | Norton | Kansas | 20137 | 188 | 0 |
632602 | 632602 | 2020-10-15 | Osage | Kansas | 20139 | 135 | 1 |
632603 | 632603 | 2020-10-15 | Osborne | Kansas | 20141 | 20 | 0 |
632604 | 632604 | 2020-10-15 | Ottawa | Kansas | 20143 | 97 | 0 |
632605 | 632605 | 2020-10-15 | Pawnee | Kansas | 20145 | 409 | 1 |
632606 | 632606 | 2020-10-15 | Phillips | Kansas | 20147 | 150 | 9 |
632607 | 632607 | 2020-10-15 | Pottawatomie | Kansas | 20149 | 335 | 0 |
632608 | 632608 | 2020-10-15 | Pratt | Kansas | 20151 | 96 | 0 |
632609 | 632609 | 2020-10-15 | Rawlins | Kansas | 20153 | 106 | 0 |
632610 | 632610 | 2020-10-15 | Reno | Kansas | 20155 | 1564 | 9 |
632611 | 632611 | 2020-10-15 | Republic | Kansas | 20157 | 63 | 1 |
632612 | 632612 | 2020-10-15 | Rice | Kansas | 20159 | 106 | 1 |
632613 | 632613 | 2020-10-15 | Riley | Kansas | 20161 | 2004 | 10 |
632614 | 632614 | 2020-10-15 | Rooks | Kansas | 20163 | 130 | 7 |
632615 | 632615 | 2020-10-15 | Rush | Kansas | 20165 | 90 | 0 |
632616 | 632616 | 2020-10-15 | Russell | Kansas | 20167 | 141 | 3 |
632617 | 632617 | 2020-10-15 | Saline | Kansas | 20169 | 929 | 12 |
632618 | 632618 | 2020-10-15 | Scott | Kansas | 20171 | 172 | 1 |
632619 | 632619 | 2020-10-15 | Sedgwick | Kansas | 20173 | 10298 | 114 |
632620 | 632620 | 2020-10-15 | Seward | Kansas | 20175 | 1909 | 7 |
632621 | 632621 | 2020-10-15 | Shawnee | Kansas | 20177 | 3185 | 65 |
632622 | 632622 | 2020-10-15 | Sheridan | Kansas | 20179 | 95 | 0 |
632623 | 632623 | 2020-10-15 | Sherman | Kansas | 20181 | 130 | 0 |
632624 | 632624 | 2020-10-15 | Smith | Kansas | 20183 | 19 | 0 |
632625 | 632625 | 2020-10-15 | Stafford | Kansas | 20185 | 69 | 1 |
632626 | 632626 | 2020-10-15 | Stanton | Kansas | 20187 | 79 | 2 |
632627 | 632627 | 2020-10-15 | Stevens | Kansas | 20189 | 194 | 1 |
632628 | 632628 | 2020-10-15 | Sumner | Kansas | 20191 | 234 | 3 |
632629 | 632629 | 2020-10-15 | Thomas | Kansas | 20193 | 227 | 2 |
632630 | 632630 | 2020-10-15 | Trego | Kansas | 20195 | 69 | 3 |
632631 | 632631 | 2020-10-15 | Unknown | Kansas | 0 | 11 | |
632632 | 632632 | 2020-10-15 | Wabaunsee | Kansas | 20197 | 77 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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);