ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where date = "2020-06-10" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
225484 | 225484 | 2020-06-10 | Anderson | Kansas | 20003 | 1 | 0 |
225485 | 225485 | 2020-06-10 | Atchison | Kansas | 20005 | 24 | 0 |
225486 | 225486 | 2020-06-10 | Barber | Kansas | 20007 | 1 | 0 |
225487 | 225487 | 2020-06-10 | Barton | Kansas | 20009 | 47 | 2 |
225488 | 225488 | 2020-06-10 | Bourbon | Kansas | 20011 | 8 | 1 |
225489 | 225489 | 2020-06-10 | Brown | Kansas | 20013 | 9 | 0 |
225490 | 225490 | 2020-06-10 | Butler | Kansas | 20015 | 40 | 0 |
225491 | 225491 | 2020-06-10 | Chase | Kansas | 20017 | 4 | 0 |
225492 | 225492 | 2020-06-10 | Chautauqua | Kansas | 20019 | 4 | 0 |
225493 | 225493 | 2020-06-10 | Cherokee | Kansas | 20021 | 12 | 0 |
225494 | 225494 | 2020-06-10 | Cheyenne | Kansas | 20023 | 2 | 0 |
225495 | 225495 | 2020-06-10 | Clark | Kansas | 20025 | 33 | 0 |
225496 | 225496 | 2020-06-10 | Clay | Kansas | 20027 | 6 | 1 |
225497 | 225497 | 2020-06-10 | Cloud | Kansas | 20029 | 5 | 0 |
225498 | 225498 | 2020-06-10 | Coffey | Kansas | 20031 | 52 | 8 |
225499 | 225499 | 2020-06-10 | Comanche | Kansas | 20033 | 2 | 0 |
225500 | 225500 | 2020-06-10 | Cowley | Kansas | 20035 | 27 | 1 |
225501 | 225501 | 2020-06-10 | Crawford | Kansas | 20037 | 9 | 1 |
225502 | 225502 | 2020-06-10 | Dickinson | Kansas | 20041 | 6 | 0 |
225503 | 225503 | 2020-06-10 | Doniphan | Kansas | 20043 | 20 | 0 |
225504 | 225504 | 2020-06-10 | Douglas | Kansas | 20045 | 78 | 0 |
225505 | 225505 | 2020-06-10 | Edwards | Kansas | 20047 | 5 | 0 |
225506 | 225506 | 2020-06-10 | Ellis | Kansas | 20051 | 14 | 0 |
225507 | 225507 | 2020-06-10 | Ellsworth | Kansas | 20053 | 3 | 0 |
225508 | 225508 | 2020-06-10 | Finney | Kansas | 20055 | 1537 | 10 |
225509 | 225509 | 2020-06-10 | Ford | Kansas | 20057 | 1852 | 10 |
225510 | 225510 | 2020-06-10 | Franklin | Kansas | 20059 | 49 | 0 |
225511 | 225511 | 2020-06-10 | Geary | Kansas | 20061 | 26 | 1 |
225512 | 225512 | 2020-06-10 | Gove | Kansas | 20063 | 1 | 0 |
225513 | 225513 | 2020-06-10 | Grant | Kansas | 20067 | 18 | 1 |
225514 | 225514 | 2020-06-10 | Gray | Kansas | 20069 | 23 | 0 |
225515 | 225515 | 2020-06-10 | Greenwood | Kansas | 20073 | 10 | 0 |
225516 | 225516 | 2020-06-10 | Hamilton | Kansas | 20075 | 27 | 0 |
225517 | 225517 | 2020-06-10 | Harper | Kansas | 20077 | 2 | 0 |
225518 | 225518 | 2020-06-10 | Harvey | Kansas | 20079 | 15 | 2 |
225519 | 225519 | 2020-06-10 | Haskell | Kansas | 20081 | 22 | 0 |
225520 | 225520 | 2020-06-10 | Hodgeman | Kansas | 20083 | 5 | 0 |
225521 | 225521 | 2020-06-10 | Jackson | Kansas | 20085 | 102 | 1 |
225522 | 225522 | 2020-06-10 | Jefferson | Kansas | 20087 | 23 | 0 |
225523 | 225523 | 2020-06-10 | Jewell | Kansas | 20089 | 4 | 0 |
225524 | 225524 | 2020-06-10 | Johnson | Kansas | 20091 | 1003 | 71 |
225525 | 225525 | 2020-06-10 | Kearny | Kansas | 20093 | 46 | 1 |
225526 | 225526 | 2020-06-10 | Kiowa | Kansas | 20097 | 3 | 0 |
225527 | 225527 | 2020-06-10 | Labette | Kansas | 20099 | 26 | 0 |
225528 | 225528 | 2020-06-10 | Lane | Kansas | 20101 | 4 | 0 |
225529 | 225529 | 2020-06-10 | Leavenworth | Kansas | 20103 | 1103 | 7 |
225530 | 225530 | 2020-06-10 | Linn | Kansas | 20107 | 11 | 0 |
225531 | 225531 | 2020-06-10 | Lyon | Kansas | 20111 | 459 | 6 |
225532 | 225532 | 2020-06-10 | Marion | Kansas | 20115 | 7 | 1 |
225533 | 225533 | 2020-06-10 | McPherson | Kansas | 20113 | 39 | 0 |
225534 | 225534 | 2020-06-10 | Meade | Kansas | 20119 | 30 | 0 |
225535 | 225535 | 2020-06-10 | Miami | Kansas | 20121 | 7 | 0 |
225536 | 225536 | 2020-06-10 | Mitchell | Kansas | 20123 | 4 | 0 |
225537 | 225537 | 2020-06-10 | Montgomery | Kansas | 20125 | 20 | 2 |
225538 | 225538 | 2020-06-10 | Morris | Kansas | 20127 | 5 | 0 |
225539 | 225539 | 2020-06-10 | Morton | Kansas | 20129 | 6 | 0 |
225540 | 225540 | 2020-06-10 | Nemaha | Kansas | 20131 | 19 | 0 |
225541 | 225541 | 2020-06-10 | Neosho | Kansas | 20133 | 4 | 0 |
225542 | 225542 | 2020-06-10 | Ness | Kansas | 20135 | 4 | 0 |
225543 | 225543 | 2020-06-10 | Norton | Kansas | 20137 | 3 | 0 |
225544 | 225544 | 2020-06-10 | Osage | Kansas | 20139 | 10 | 0 |
225545 | 225545 | 2020-06-10 | Osborne | Kansas | 20141 | 2 | 0 |
225546 | 225546 | 2020-06-10 | Ottawa | Kansas | 20143 | 4 | 0 |
225547 | 225547 | 2020-06-10 | Pawnee | Kansas | 20145 | 3 | 0 |
225548 | 225548 | 2020-06-10 | Phillips | Kansas | 20147 | 2 | 0 |
225549 | 225549 | 2020-06-10 | Pottawatomie | Kansas | 20149 | 34 | 0 |
225550 | 225550 | 2020-06-10 | Pratt | Kansas | 20151 | 2 | 0 |
225551 | 225551 | 2020-06-10 | Reno | Kansas | 20155 | 55 | 0 |
225552 | 225552 | 2020-06-10 | Republic | Kansas | 20157 | 4 | 0 |
225553 | 225553 | 2020-06-10 | Rice | Kansas | 20159 | 4 | 0 |
225554 | 225554 | 2020-06-10 | Riley | Kansas | 20161 | 71 | 3 |
225555 | 225555 | 2020-06-10 | Rooks | Kansas | 20163 | 7 | 0 |
225556 | 225556 | 2020-06-10 | Saline | Kansas | 20169 | 32 | 2 |
225557 | 225557 | 2020-06-10 | Scott | Kansas | 20171 | 15 | 0 |
225558 | 225558 | 2020-06-10 | Sedgwick | Kansas | 20173 | 710 | 22 |
225559 | 225559 | 2020-06-10 | Seward | Kansas | 20175 | 917 | 2 |
225560 | 225560 | 2020-06-10 | Shawnee | Kansas | 20177 | 409 | 8 |
225561 | 225561 | 2020-06-10 | Sheridan | Kansas | 20179 | 2 | 0 |
225562 | 225562 | 2020-06-10 | Sherman | Kansas | 20181 | 7 | 0 |
225563 | 225563 | 2020-06-10 | Smith | Kansas | 20183 | 2 | 0 |
225564 | 225564 | 2020-06-10 | Stafford | Kansas | 20185 | 1 | 0 |
225565 | 225565 | 2020-06-10 | Stanton | Kansas | 20187 | 9 | 0 |
225566 | 225566 | 2020-06-10 | Stevens | Kansas | 20189 | 31 | 0 |
225567 | 225567 | 2020-06-10 | Sumner | Kansas | 20191 | 10 | 1 |
225568 | 225568 | 2020-06-10 | Trego | Kansas | 20195 | 1 | 0 |
225569 | 225569 | 2020-06-10 | Wabaunsee | Kansas | 20197 | 31 | 0 |
225570 | 225570 | 2020-06-10 | Washington | Kansas | 20201 | 1 | 0 |
225571 | 225571 | 2020-06-10 | Wilson | Kansas | 20205 | 1 | 0 |
225572 | 225572 | 2020-06-10 | Woodson | Kansas | 20207 | 6 | 0 |
225573 | 225573 | 2020-06-10 | Wyandotte | Kansas | 20209 | 1617 | 76 |
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);