ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2020-12-20" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
846692 | 846692 | 2020-12-20 | Allen | Kansas | 20001 | 542 | 1 |
846693 | 846693 | 2020-12-20 | Anderson | Kansas | 20003 | 469 | 0 |
846694 | 846694 | 2020-12-20 | Atchison | Kansas | 20005 | 1144 | 10 |
846695 | 846695 | 2020-12-20 | Barber | Kansas | 20007 | 253 | 2 |
846696 | 846696 | 2020-12-20 | Barton | Kansas | 20009 | 2037 | 19 |
846697 | 846697 | 2020-12-20 | Bourbon | Kansas | 20011 | 799 | 3 |
846698 | 846698 | 2020-12-20 | Brown | Kansas | 20013 | 955 | 18 |
846699 | 846699 | 2020-12-20 | Butler | Kansas | 20015 | 4646 | 18 |
846700 | 846700 | 2020-12-20 | Chase | Kansas | 20017 | 215 | 3 |
846701 | 846701 | 2020-12-20 | Chautauqua | Kansas | 20019 | 127 | 3 |
846702 | 846702 | 2020-12-20 | Cherokee | Kansas | 20021 | 1530 | 13 |
846703 | 846703 | 2020-12-20 | Cheyenne | Kansas | 20023 | 253 | 10 |
846704 | 846704 | 2020-12-20 | Clark | Kansas | 20025 | 180 | 4 |
846705 | 846705 | 2020-12-20 | Clay | Kansas | 20027 | 533 | 14 |
846706 | 846706 | 2020-12-20 | Cloud | Kansas | 20029 | 798 | 2 |
846707 | 846707 | 2020-12-20 | Coffey | Kansas | 20031 | 449 | 10 |
846708 | 846708 | 2020-12-20 | Comanche | Kansas | 20033 | 134 | 4 |
846709 | 846709 | 2020-12-20 | Cowley | Kansas | 20035 | 2202 | 9 |
846710 | 846710 | 2020-12-20 | Crawford | Kansas | 20037 | 3048 | 26 |
846711 | 846711 | 2020-12-20 | Decatur | Kansas | 20039 | 228 | 1 |
846712 | 846712 | 2020-12-20 | Dickinson | Kansas | 20041 | 1042 | 14 |
846713 | 846713 | 2020-12-20 | Doniphan | Kansas | 20043 | 632 | 5 |
846714 | 846714 | 2020-12-20 | Douglas | Kansas | 20045 | 5859 | 31 |
846715 | 846715 | 2020-12-20 | Edwards | Kansas | 20047 | 227 | 0 |
846716 | 846716 | 2020-12-20 | Elk | Kansas | 20049 | 87 | 0 |
846717 | 846717 | 2020-12-20 | Ellis | Kansas | 20051 | 3066 | 31 |
846718 | 846718 | 2020-12-20 | Ellsworth | Kansas | 20053 | 983 | 4 |
846719 | 846719 | 2020-12-20 | Finney | Kansas | 20055 | 5312 | 34 |
846720 | 846720 | 2020-12-20 | Ford | Kansas | 20057 | 4989 | 10 |
846721 | 846721 | 2020-12-20 | Franklin | Kansas | 20059 | 1486 | 17 |
846722 | 846722 | 2020-12-20 | Geary | Kansas | 20061 | 1528 | 9 |
846723 | 846723 | 2020-12-20 | Gove | Kansas | 20063 | 325 | 20 |
846724 | 846724 | 2020-12-20 | Graham | Kansas | 20065 | 196 | 2 |
846725 | 846725 | 2020-12-20 | Grant | Kansas | 20067 | 892 | 14 |
846726 | 846726 | 2020-12-20 | Gray | Kansas | 20069 | 508 | 7 |
846727 | 846727 | 2020-12-20 | Greeley | Kansas | 20071 | 90 | 0 |
846728 | 846728 | 2020-12-20 | Greenwood | Kansas | 20073 | 375 | 2 |
846729 | 846729 | 2020-12-20 | Hamilton | Kansas | 20075 | 177 | 0 |
846730 | 846730 | 2020-12-20 | Harper | Kansas | 20077 | 391 | 15 |
846731 | 846731 | 2020-12-20 | Harvey | Kansas | 20079 | 2316 | 23 |
846732 | 846732 | 2020-12-20 | Haskell | Kansas | 20081 | 345 | 1 |
846733 | 846733 | 2020-12-20 | Hodgeman | Kansas | 20083 | 157 | 4 |
846734 | 846734 | 2020-12-20 | Jackson | Kansas | 20085 | 962 | 10 |
846735 | 846735 | 2020-12-20 | Jefferson | Kansas | 20087 | 1017 | 9 |
846736 | 846736 | 2020-12-20 | Jewell | Kansas | 20089 | 178 | 2 |
846737 | 846737 | 2020-12-20 | Johnson | Kansas | 20091 | 35086 | 385 |
846738 | 846738 | 2020-12-20 | Kearny | Kansas | 20093 | 465 | 8 |
846739 | 846739 | 2020-12-20 | Kingman | Kansas | 20095 | 519 | 7 |
846740 | 846740 | 2020-12-20 | Kiowa | Kansas | 20097 | 178 | 0 |
846741 | 846741 | 2020-12-20 | Labette | Kansas | 20099 | 1501 | 7 |
846742 | 846742 | 2020-12-20 | Lane | Kansas | 20101 | 117 | 4 |
846743 | 846743 | 2020-12-20 | Leavenworth | Kansas | 20103 | 4698 | 36 |
846744 | 846744 | 2020-12-20 | Lincoln | Kansas | 20105 | 174 | 1 |
846745 | 846745 | 2020-12-20 | Linn | Kansas | 20107 | 438 | 4 |
846746 | 846746 | 2020-12-20 | Logan | Kansas | 20109 | 265 | 0 |
846747 | 846747 | 2020-12-20 | Lyon | Kansas | 20111 | 3168 | 55 |
846748 | 846748 | 2020-12-20 | Marion | Kansas | 20115 | 607 | 4 |
846749 | 846749 | 2020-12-20 | Marshall | Kansas | 20117 | 781 | 21 |
846750 | 846750 | 2020-12-20 | McPherson | Kansas | 20113 | 2187 | 22 |
846751 | 846751 | 2020-12-20 | Meade | Kansas | 20119 | 365 | 4 |
846752 | 846752 | 2020-12-20 | Miami | Kansas | 20121 | 1514 | 7 |
846753 | 846753 | 2020-12-20 | Mitchell | Kansas | 20123 | 337 | 0 |
846754 | 846754 | 2020-12-20 | Montgomery | Kansas | 20125 | 1782 | 6 |
846755 | 846755 | 2020-12-20 | Morris | Kansas | 20127 | 339 | 2 |
846756 | 846756 | 2020-12-20 | Morton | Kansas | 20129 | 195 | 8 |
846757 | 846757 | 2020-12-20 | Nemaha | Kansas | 20131 | 1285 | 43 |
846758 | 846758 | 2020-12-20 | Neosho | Kansas | 20133 | 997 | 8 |
846759 | 846759 | 2020-12-20 | Ness | Kansas | 20135 | 323 | 15 |
846760 | 846760 | 2020-12-20 | Norton | Kansas | 20137 | 1151 | 24 |
846761 | 846761 | 2020-12-20 | Osage | Kansas | 20139 | 729 | 6 |
846762 | 846762 | 2020-12-20 | Osborne | Kansas | 20141 | 135 | 0 |
846763 | 846763 | 2020-12-20 | Ottawa | Kansas | 20143 | 371 | 0 |
846764 | 846764 | 2020-12-20 | Pawnee | Kansas | 20145 | 888 | 1 |
846765 | 846765 | 2020-12-20 | Phillips | Kansas | 20147 | 549 | 12 |
846766 | 846766 | 2020-12-20 | Pottawatomie | Kansas | 20149 | 908 | 3 |
846767 | 846767 | 2020-12-20 | Pratt | Kansas | 20151 | 638 | 17 |
846768 | 846768 | 2020-12-20 | Rawlins | Kansas | 20153 | 306 | 3 |
846769 | 846769 | 2020-12-20 | Reno | Kansas | 20155 | 6538 | 87 |
846770 | 846770 | 2020-12-20 | Republic | Kansas | 20157 | 509 | 9 |
846771 | 846771 | 2020-12-20 | Rice | Kansas | 20159 | 685 | 1 |
846772 | 846772 | 2020-12-20 | Riley | Kansas | 20161 | 4494 | 19 |
846773 | 846773 | 2020-12-20 | Rooks | Kansas | 20163 | 446 | 9 |
846774 | 846774 | 2020-12-20 | Rush | Kansas | 20165 | 323 | 0 |
846775 | 846775 | 2020-12-20 | Russell | Kansas | 20167 | 696 | 17 |
846776 | 846776 | 2020-12-20 | Saline | Kansas | 20169 | 3718 | 46 |
846777 | 846777 | 2020-12-20 | Scott | Kansas | 20171 | 535 | 9 |
846778 | 846778 | 2020-12-20 | Sedgwick | Kansas | 20173 | 35106 | 236 |
846779 | 846779 | 2020-12-20 | Seward | Kansas | 20175 | 3417 | 16 |
846780 | 846780 | 2020-12-20 | Shawnee | Kansas | 20177 | 10393 | 190 |
846781 | 846781 | 2020-12-20 | Sheridan | Kansas | 20179 | 360 | 0 |
846782 | 846782 | 2020-12-20 | Sherman | Kansas | 20181 | 527 | 7 |
846783 | 846783 | 2020-12-20 | Smith | Kansas | 20183 | 196 | 1 |
846784 | 846784 | 2020-12-20 | Stafford | Kansas | 20185 | 256 | 7 |
846785 | 846785 | 2020-12-20 | Stanton | Kansas | 20187 | 157 | 2 |
846786 | 846786 | 2020-12-20 | Stevens | Kansas | 20189 | 489 | 5 |
846787 | 846787 | 2020-12-20 | Sumner | Kansas | 20191 | 1176 | 12 |
846788 | 846788 | 2020-12-20 | Thomas | Kansas | 20193 | 863 | 6 |
846789 | 846789 | 2020-12-20 | Trego | Kansas | 20195 | 275 | 3 |
846790 | 846790 | 2020-12-20 | Unknown | Kansas | 0 | 308 | |
846791 | 846791 | 2020-12-20 | Wabaunsee | Kansas | 20197 | 369 | 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);