ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-07-26" 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 |
---|---|---|---|---|---|---|---|
370751 | 370751 | 2020-07-26 | Allen | Kansas | 20001 | 14 | 0 |
370752 | 370752 | 2020-07-26 | Anderson | Kansas | 20003 | 25 | 0 |
370753 | 370753 | 2020-07-26 | Atchison | Kansas | 20005 | 56 | 0 |
370754 | 370754 | 2020-07-26 | Barber | Kansas | 20007 | 4 | 0 |
370755 | 370755 | 2020-07-26 | Barton | Kansas | 20009 | 95 | 3 |
370756 | 370756 | 2020-07-26 | Bourbon | Kansas | 20011 | 66 | 1 |
370757 | 370757 | 2020-07-26 | Brown | Kansas | 20013 | 25 | 0 |
370758 | 370758 | 2020-07-26 | Butler | Kansas | 20015 | 172 | 0 |
370759 | 370759 | 2020-07-26 | Chase | Kansas | 20017 | 6 | 0 |
370760 | 370760 | 2020-07-26 | Chautauqua | Kansas | 20019 | 5 | 0 |
370761 | 370761 | 2020-07-26 | Cherokee | Kansas | 20021 | 67 | 1 |
370762 | 370762 | 2020-07-26 | Cheyenne | Kansas | 20023 | 2 | 0 |
370763 | 370763 | 2020-07-26 | Clark | Kansas | 20025 | 40 | 1 |
370764 | 370764 | 2020-07-26 | Clay | Kansas | 20027 | 15 | 2 |
370765 | 370765 | 2020-07-26 | Cloud | Kansas | 20029 | 27 | 0 |
370766 | 370766 | 2020-07-26 | Coffey | Kansas | 20031 | 63 | 8 |
370767 | 370767 | 2020-07-26 | Comanche | Kansas | 20033 | 3 | 0 |
370768 | 370768 | 2020-07-26 | Cowley | Kansas | 20035 | 128 | 2 |
370769 | 370769 | 2020-07-26 | Crawford | Kansas | 20037 | 367 | 1 |
370770 | 370770 | 2020-07-26 | Decatur | Kansas | 20039 | 6 | 0 |
370771 | 370771 | 2020-07-26 | Dickinson | Kansas | 20041 | 35 | 1 |
370772 | 370772 | 2020-07-26 | Doniphan | Kansas | 20043 | 39 | 0 |
370773 | 370773 | 2020-07-26 | Douglas | Kansas | 20045 | 597 | 2 |
370774 | 370774 | 2020-07-26 | Edwards | Kansas | 20047 | 9 | 0 |
370775 | 370775 | 2020-07-26 | Elk | Kansas | 20049 | 1 | 0 |
370776 | 370776 | 2020-07-26 | Ellis | Kansas | 20051 | 107 | 1 |
370777 | 370777 | 2020-07-26 | Ellsworth | Kansas | 20053 | 15 | 0 |
370778 | 370778 | 2020-07-26 | Finney | Kansas | 20055 | 1672 | 10 |
370779 | 370779 | 2020-07-26 | Ford | Kansas | 20057 | 2069 | 10 |
370780 | 370780 | 2020-07-26 | Franklin | Kansas | 20059 | 135 | 1 |
370781 | 370781 | 2020-07-26 | Geary | Kansas | 20061 | 173 | 1 |
370782 | 370782 | 2020-07-26 | Gove | Kansas | 20063 | 3 | 0 |
370783 | 370783 | 2020-07-26 | Graham | Kansas | 20065 | 16 | 0 |
370784 | 370784 | 2020-07-26 | Grant | Kansas | 20067 | 88 | 2 |
370785 | 370785 | 2020-07-26 | Gray | Kansas | 20069 | 47 | 0 |
370786 | 370786 | 2020-07-26 | Greeley | Kansas | 20071 | 3 | 0 |
370787 | 370787 | 2020-07-26 | Greenwood | Kansas | 20073 | 14 | 0 |
370788 | 370788 | 2020-07-26 | Hamilton | Kansas | 20075 | 38 | 0 |
370789 | 370789 | 2020-07-26 | Harper | Kansas | 20077 | 8 | 0 |
370790 | 370790 | 2020-07-26 | Harvey | Kansas | 20079 | 140 | 3 |
370791 | 370791 | 2020-07-26 | Haskell | Kansas | 20081 | 38 | 0 |
370792 | 370792 | 2020-07-26 | Hodgeman | Kansas | 20083 | 10 | 0 |
370793 | 370793 | 2020-07-26 | Jackson | Kansas | 20085 | 131 | 1 |
370794 | 370794 | 2020-07-26 | Jefferson | Kansas | 20087 | 48 | 0 |
370795 | 370795 | 2020-07-26 | Jewell | Kansas | 20089 | 7 | 0 |
370796 | 370796 | 2020-07-26 | Johnson | Kansas | 20091 | 4455 | 94 |
370797 | 370797 | 2020-07-26 | Kearny | Kansas | 20093 | 53 | 1 |
370798 | 370798 | 2020-07-26 | Kingman | Kansas | 20095 | 6 | 0 |
370799 | 370799 | 2020-07-26 | Kiowa | Kansas | 20097 | 6 | 0 |
370800 | 370800 | 2020-07-26 | Labette | Kansas | 20099 | 106 | 0 |
370801 | 370801 | 2020-07-26 | Lane | Kansas | 20101 | 5 | 0 |
370802 | 370802 | 2020-07-26 | Leavenworth | Kansas | 20103 | 1372 | 7 |
370803 | 370803 | 2020-07-26 | Lincoln | Kansas | 20105 | 6 | 0 |
370804 | 370804 | 2020-07-26 | Linn | Kansas | 20107 | 26 | 0 |
370805 | 370805 | 2020-07-26 | Logan | Kansas | 20109 | 2 | 0 |
370806 | 370806 | 2020-07-26 | Lyon | Kansas | 20111 | 600 | 8 |
370807 | 370807 | 2020-07-26 | Marion | Kansas | 20115 | 42 | 1 |
370808 | 370808 | 2020-07-26 | Marshall | Kansas | 20117 | 7 | 0 |
370809 | 370809 | 2020-07-26 | McPherson | Kansas | 20113 | 123 | 0 |
370810 | 370810 | 2020-07-26 | Meade | Kansas | 20119 | 43 | 0 |
370811 | 370811 | 2020-07-26 | Miami | Kansas | 20121 | 96 | 0 |
370812 | 370812 | 2020-07-26 | Mitchell | Kansas | 20123 | 22 | 0 |
370813 | 370813 | 2020-07-26 | Montgomery | Kansas | 20125 | 120 | 4 |
370814 | 370814 | 2020-07-26 | Morris | Kansas | 20127 | 7 | 0 |
370815 | 370815 | 2020-07-26 | Morton | Kansas | 20129 | 9 | 2 |
370816 | 370816 | 2020-07-26 | Nemaha | Kansas | 20131 | 41 | 0 |
370817 | 370817 | 2020-07-26 | Neosho | Kansas | 20133 | 49 | 0 |
370818 | 370818 | 2020-07-26 | Ness | Kansas | 20135 | 5 | 0 |
370819 | 370819 | 2020-07-26 | Norton | Kansas | 20137 | 21 | 0 |
370820 | 370820 | 2020-07-26 | Osage | Kansas | 20139 | 33 | 0 |
370821 | 370821 | 2020-07-26 | Osborne | Kansas | 20141 | 3 | 0 |
370822 | 370822 | 2020-07-26 | Ottawa | Kansas | 20143 | 28 | 0 |
370823 | 370823 | 2020-07-26 | Pawnee | Kansas | 20145 | 8 | 0 |
370824 | 370824 | 2020-07-26 | Phillips | Kansas | 20147 | 41 | 7 |
370825 | 370825 | 2020-07-26 | Pottawatomie | Kansas | 20149 | 105 | 0 |
370826 | 370826 | 2020-07-26 | Pratt | Kansas | 20151 | 32 | 0 |
370827 | 370827 | 2020-07-26 | Reno | Kansas | 20155 | 201 | 1 |
370828 | 370828 | 2020-07-26 | Republic | Kansas | 20157 | 26 | 0 |
370829 | 370829 | 2020-07-26 | Rice | Kansas | 20159 | 22 | 0 |
370830 | 370830 | 2020-07-26 | Riley | Kansas | 20161 | 419 | 4 |
370831 | 370831 | 2020-07-26 | Rooks | Kansas | 20163 | 14 | 0 |
370832 | 370832 | 2020-07-26 | Rush | Kansas | 20165 | 5 | 0 |
370833 | 370833 | 2020-07-26 | Russell | Kansas | 20167 | 8 | 0 |
370834 | 370834 | 2020-07-26 | Saline | Kansas | 20169 | 318 | 3 |
370835 | 370835 | 2020-07-26 | Scott | Kansas | 20171 | 24 | 0 |
370836 | 370836 | 2020-07-26 | Sedgwick | Kansas | 20173 | 3646 | 36 |
370837 | 370837 | 2020-07-26 | Seward | Kansas | 20175 | 1154 | 4 |
370838 | 370838 | 2020-07-26 | Shawnee | Kansas | 20177 | 1295 | 19 |
370839 | 370839 | 2020-07-26 | Sheridan | Kansas | 20179 | 7 | 0 |
370840 | 370840 | 2020-07-26 | Sherman | Kansas | 20181 | 10 | 0 |
370841 | 370841 | 2020-07-26 | Smith | Kansas | 20183 | 3 | 0 |
370842 | 370842 | 2020-07-26 | Stafford | Kansas | 20185 | 2 | 0 |
370843 | 370843 | 2020-07-26 | Stanton | Kansas | 20187 | 18 | 0 |
370844 | 370844 | 2020-07-26 | Stevens | Kansas | 20189 | 40 | 0 |
370845 | 370845 | 2020-07-26 | Sumner | Kansas | 20191 | 85 | 2 |
370846 | 370846 | 2020-07-26 | Thomas | Kansas | 20193 | 25 | 0 |
370847 | 370847 | 2020-07-26 | Trego | Kansas | 20195 | 3 | 0 |
370848 | 370848 | 2020-07-26 | Wabaunsee | Kansas | 20197 | 39 | 0 |
370849 | 370849 | 2020-07-26 | Washington | Kansas | 20201 | 2 | 0 |
370850 | 370850 | 2020-07-26 | Wichita | Kansas | 20203 | 2 | 0 |
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);