ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where date = "2020-06-21" 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 |
---|---|---|---|---|---|---|---|
259707 | 259707 | 2020-06-21 | Allen | Kansas | 20001 | 1 | 0 |
259708 | 259708 | 2020-06-21 | Anderson | Kansas | 20003 | 3 | 0 |
259709 | 259709 | 2020-06-21 | Atchison | Kansas | 20005 | 26 | 0 |
259710 | 259710 | 2020-06-21 | Barber | Kansas | 20007 | 1 | 0 |
259711 | 259711 | 2020-06-21 | Barton | Kansas | 20009 | 54 | 2 |
259712 | 259712 | 2020-06-21 | Bourbon | Kansas | 20011 | 9 | 1 |
259713 | 259713 | 2020-06-21 | Brown | Kansas | 20013 | 11 | 0 |
259714 | 259714 | 2020-06-21 | Butler | Kansas | 20015 | 49 | 0 |
259715 | 259715 | 2020-06-21 | Chase | Kansas | 20017 | 4 | 0 |
259716 | 259716 | 2020-06-21 | Chautauqua | Kansas | 20019 | 4 | 0 |
259717 | 259717 | 2020-06-21 | Cherokee | Kansas | 20021 | 18 | 0 |
259718 | 259718 | 2020-06-21 | Cheyenne | Kansas | 20023 | 2 | 0 |
259719 | 259719 | 2020-06-21 | Clark | Kansas | 20025 | 34 | 0 |
259720 | 259720 | 2020-06-21 | Clay | Kansas | 20027 | 7 | 2 |
259721 | 259721 | 2020-06-21 | Cloud | Kansas | 20029 | 7 | 0 |
259722 | 259722 | 2020-06-21 | Coffey | Kansas | 20031 | 52 | 8 |
259723 | 259723 | 2020-06-21 | Comanche | Kansas | 20033 | 2 | 0 |
259724 | 259724 | 2020-06-21 | Cowley | Kansas | 20035 | 52 | 1 |
259725 | 259725 | 2020-06-21 | Crawford | Kansas | 20037 | 167 | 1 |
259726 | 259726 | 2020-06-21 | Dickinson | Kansas | 20041 | 8 | 0 |
259727 | 259727 | 2020-06-21 | Doniphan | Kansas | 20043 | 23 | 0 |
259728 | 259728 | 2020-06-21 | Douglas | Kansas | 20045 | 93 | 0 |
259729 | 259729 | 2020-06-21 | Edwards | Kansas | 20047 | 6 | 0 |
259730 | 259730 | 2020-06-21 | Ellis | Kansas | 20051 | 16 | 0 |
259731 | 259731 | 2020-06-21 | Ellsworth | Kansas | 20053 | 3 | 0 |
259732 | 259732 | 2020-06-21 | Finney | Kansas | 20055 | 1546 | 10 |
259733 | 259733 | 2020-06-21 | Ford | Kansas | 20057 | 1916 | 10 |
259734 | 259734 | 2020-06-21 | Franklin | Kansas | 20059 | 57 | 0 |
259735 | 259735 | 2020-06-21 | Geary | Kansas | 20061 | 31 | 1 |
259736 | 259736 | 2020-06-21 | Gove | Kansas | 20063 | 1 | 0 |
259737 | 259737 | 2020-06-21 | Grant | Kansas | 20067 | 23 | 1 |
259738 | 259738 | 2020-06-21 | Gray | Kansas | 20069 | 24 | 0 |
259739 | 259739 | 2020-06-21 | Greenwood | Kansas | 20073 | 11 | 0 |
259740 | 259740 | 2020-06-21 | Hamilton | Kansas | 20075 | 31 | 0 |
259741 | 259741 | 2020-06-21 | Harper | Kansas | 20077 | 2 | 0 |
259742 | 259742 | 2020-06-21 | Harvey | Kansas | 20079 | 15 | 2 |
259743 | 259743 | 2020-06-21 | Haskell | Kansas | 20081 | 23 | 0 |
259744 | 259744 | 2020-06-21 | Hodgeman | Kansas | 20083 | 8 | 0 |
259745 | 259745 | 2020-06-21 | Jackson | Kansas | 20085 | 104 | 1 |
259746 | 259746 | 2020-06-21 | Jefferson | Kansas | 20087 | 23 | 0 |
259747 | 259747 | 2020-06-21 | Jewell | Kansas | 20089 | 4 | 0 |
259748 | 259748 | 2020-06-21 | Johnson | Kansas | 20091 | 1257 | 80 |
259749 | 259749 | 2020-06-21 | Kearny | Kansas | 20093 | 46 | 1 |
259750 | 259750 | 2020-06-21 | Kiowa | Kansas | 20097 | 3 | 0 |
259751 | 259751 | 2020-06-21 | Labette | Kansas | 20099 | 28 | 0 |
259752 | 259752 | 2020-06-21 | Lane | Kansas | 20101 | 5 | 0 |
259753 | 259753 | 2020-06-21 | Leavenworth | Kansas | 20103 | 1122 | 7 |
259754 | 259754 | 2020-06-21 | Linn | Kansas | 20107 | 13 | 0 |
259755 | 259755 | 2020-06-21 | Lyon | Kansas | 20111 | 485 | 6 |
259756 | 259756 | 2020-06-21 | Marion | Kansas | 20115 | 7 | 1 |
259757 | 259757 | 2020-06-21 | McPherson | Kansas | 20113 | 42 | 0 |
259758 | 259758 | 2020-06-21 | Meade | Kansas | 20119 | 30 | 0 |
259759 | 259759 | 2020-06-21 | Miami | Kansas | 20121 | 16 | 0 |
259760 | 259760 | 2020-06-21 | Mitchell | Kansas | 20123 | 4 | 0 |
259761 | 259761 | 2020-06-21 | Montgomery | Kansas | 20125 | 25 | 3 |
259762 | 259762 | 2020-06-21 | Morris | Kansas | 20127 | 5 | 0 |
259763 | 259763 | 2020-06-21 | Morton | Kansas | 20129 | 6 | 0 |
259764 | 259764 | 2020-06-21 | Nemaha | Kansas | 20131 | 22 | 0 |
259765 | 259765 | 2020-06-21 | Neosho | Kansas | 20133 | 15 | 0 |
259766 | 259766 | 2020-06-21 | Ness | Kansas | 20135 | 4 | 0 |
259767 | 259767 | 2020-06-21 | Norton | Kansas | 20137 | 3 | 0 |
259768 | 259768 | 2020-06-21 | Osage | Kansas | 20139 | 10 | 0 |
259769 | 259769 | 2020-06-21 | Osborne | Kansas | 20141 | 2 | 0 |
259770 | 259770 | 2020-06-21 | Ottawa | Kansas | 20143 | 4 | 0 |
259771 | 259771 | 2020-06-21 | Pawnee | Kansas | 20145 | 3 | 0 |
259772 | 259772 | 2020-06-21 | Phillips | Kansas | 20147 | 2 | 0 |
259773 | 259773 | 2020-06-21 | Pottawatomie | Kansas | 20149 | 47 | 0 |
259774 | 259774 | 2020-06-21 | Pratt | Kansas | 20151 | 6 | 0 |
259775 | 259775 | 2020-06-21 | Reno | Kansas | 20155 | 58 | 0 |
259776 | 259776 | 2020-06-21 | Republic | Kansas | 20157 | 4 | 0 |
259777 | 259777 | 2020-06-21 | Rice | Kansas | 20159 | 4 | 0 |
259778 | 259778 | 2020-06-21 | Riley | Kansas | 20161 | 103 | 3 |
259779 | 259779 | 2020-06-21 | Rooks | Kansas | 20163 | 7 | 0 |
259780 | 259780 | 2020-06-21 | Saline | Kansas | 20169 | 45 | 2 |
259781 | 259781 | 2020-06-21 | Scott | Kansas | 20171 | 16 | 0 |
259782 | 259782 | 2020-06-21 | Sedgwick | Kansas | 20173 | 882 | 25 |
259783 | 259783 | 2020-06-21 | Seward | Kansas | 20175 | 955 | 2 |
259784 | 259784 | 2020-06-21 | Shawnee | Kansas | 20177 | 491 | 9 |
259785 | 259785 | 2020-06-21 | Sheridan | Kansas | 20179 | 3 | 0 |
259786 | 259786 | 2020-06-21 | Sherman | Kansas | 20181 | 7 | 0 |
259787 | 259787 | 2020-06-21 | Smith | Kansas | 20183 | 3 | 0 |
259788 | 259788 | 2020-06-21 | Stafford | Kansas | 20185 | 1 | 0 |
259789 | 259789 | 2020-06-21 | Stanton | Kansas | 20187 | 9 | 0 |
259790 | 259790 | 2020-06-21 | Stevens | Kansas | 20189 | 30 | 0 |
259791 | 259791 | 2020-06-21 | Sumner | Kansas | 20191 | 9 | 1 |
259792 | 259792 | 2020-06-21 | Trego | Kansas | 20195 | 1 | 0 |
259793 | 259793 | 2020-06-21 | Wabaunsee | Kansas | 20197 | 32 | 0 |
259794 | 259794 | 2020-06-21 | Washington | Kansas | 20201 | 1 | 0 |
259795 | 259795 | 2020-06-21 | Wilson | Kansas | 20205 | 1 | 0 |
259796 | 259796 | 2020-06-21 | Woodson | Kansas | 20207 | 6 | 0 |
259797 | 259797 | 2020-06-21 | Wyandotte | Kansas | 20209 | 1907 | 78 |
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);