ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-05-20 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
161133 | 161133 | 2020-05-20 | Anderson | Kansas | 20003 | 1 | 0 |
161134 | 161134 | 2020-05-20 | Atchison | Kansas | 20005 | 15 | 0 |
161135 | 161135 | 2020-05-20 | Barber | Kansas | 20007 | 1 | 0 |
161136 | 161136 | 2020-05-20 | Barton | Kansas | 20009 | 32 | 1 |
161137 | 161137 | 2020-05-20 | Bourbon | Kansas | 20011 | 7 | 1 |
161138 | 161138 | 2020-05-20 | Brown | Kansas | 20013 | 5 | 0 |
161139 | 161139 | 2020-05-20 | Butler | Kansas | 20015 | 23 | 0 |
161140 | 161140 | 2020-05-20 | Chase | Kansas | 20017 | 3 | 0 |
161141 | 161141 | 2020-05-20 | Chautauqua | Kansas | 20019 | 4 | 0 |
161142 | 161142 | 2020-05-20 | Cherokee | Kansas | 20021 | 8 | 0 |
161143 | 161143 | 2020-05-20 | Cheyenne | Kansas | 20023 | 2 | 0 |
161144 | 161144 | 2020-05-20 | Clark | Kansas | 20025 | 21 | 0 |
161145 | 161145 | 2020-05-20 | Clay | Kansas | 20027 | 5 | 1 |
161146 | 161146 | 2020-05-20 | Cloud | Kansas | 20029 | 4 | 0 |
161147 | 161147 | 2020-05-20 | Coffey | Kansas | 20031 | 50 | 8 |
161148 | 161148 | 2020-05-20 | Cowley | Kansas | 20035 | 4 | 1 |
161149 | 161149 | 2020-05-20 | Crawford | Kansas | 20037 | 7 | 1 |
161150 | 161150 | 2020-05-20 | Dickinson | Kansas | 20041 | 2 | 0 |
161151 | 161151 | 2020-05-20 | Doniphan | Kansas | 20043 | 9 | 0 |
161152 | 161152 | 2020-05-20 | Douglas | Kansas | 20045 | 62 | 0 |
161153 | 161153 | 2020-05-20 | Edwards | Kansas | 20047 | 5 | 0 |
161154 | 161154 | 2020-05-20 | Ellis | Kansas | 20051 | 9 | 0 |
161155 | 161155 | 2020-05-20 | Ellsworth | Kansas | 20053 | 2 | 0 |
161156 | 161156 | 2020-05-20 | Finney | Kansas | 20055 | 1363 | 6 |
161157 | 161157 | 2020-05-20 | Ford | Kansas | 20057 | 1440 | 2 |
161158 | 161158 | 2020-05-20 | Franklin | Kansas | 20059 | 32 | 0 |
161159 | 161159 | 2020-05-20 | Geary | Kansas | 20061 | 16 | 0 |
161160 | 161160 | 2020-05-20 | Gove | Kansas | 20063 | 1 | 0 |
161161 | 161161 | 2020-05-20 | Grant | Kansas | 20067 | 17 | 0 |
161162 | 161162 | 2020-05-20 | Gray | Kansas | 20069 | 16 | 0 |
161163 | 161163 | 2020-05-20 | Greenwood | Kansas | 20073 | 3 | 0 |
161164 | 161164 | 2020-05-20 | Hamilton | Kansas | 20075 | 11 | 0 |
161165 | 161165 | 2020-05-20 | Harper | Kansas | 20077 | 1 | 0 |
161166 | 161166 | 2020-05-20 | Harvey | Kansas | 20079 | 15 | 2 |
161167 | 161167 | 2020-05-20 | Haskell | Kansas | 20081 | 16 | 0 |
161168 | 161168 | 2020-05-20 | Jackson | Kansas | 20085 | 33 | 0 |
161169 | 161169 | 2020-05-20 | Jefferson | Kansas | 20087 | 21 | 0 |
161170 | 161170 | 2020-05-20 | Jewell | Kansas | 20089 | 4 | 0 |
161171 | 161171 | 2020-05-20 | Johnson | Kansas | 20091 | 696 | 58 |
161172 | 161172 | 2020-05-20 | Kearny | Kansas | 20093 | 40 | 1 |
161173 | 161173 | 2020-05-20 | Kiowa | Kansas | 20097 | 2 | 0 |
161174 | 161174 | 2020-05-20 | Labette | Kansas | 20099 | 24 | 0 |
161175 | 161175 | 2020-05-20 | Leavenworth | Kansas | 20103 | 1058 | 7 |
161176 | 161176 | 2020-05-20 | Linn | Kansas | 20107 | 7 | 0 |
161177 | 161177 | 2020-05-20 | Lyon | Kansas | 20111 | 371 | 3 |
161178 | 161178 | 2020-05-20 | Marion | Kansas | 20115 | 8 | 1 |
161179 | 161179 | 2020-05-20 | McPherson | Kansas | 20113 | 27 | 0 |
161180 | 161180 | 2020-05-20 | Meade | Kansas | 20119 | 22 | 0 |
161181 | 161181 | 2020-05-20 | Miami | Kansas | 20121 | 6 | 0 |
161182 | 161182 | 2020-05-20 | Mitchell | Kansas | 20123 | 3 | 0 |
161183 | 161183 | 2020-05-20 | Montgomery | Kansas | 20125 | 20 | 2 |
161184 | 161184 | 2020-05-20 | Morris | Kansas | 20127 | 3 | 0 |
161185 | 161185 | 2020-05-20 | Morton | Kansas | 20129 | 4 | 0 |
161186 | 161186 | 2020-05-20 | Nemaha | Kansas | 20131 | 5 | 0 |
161187 | 161187 | 2020-05-20 | Neosho | Kansas | 20133 | 2 | 0 |
161188 | 161188 | 2020-05-20 | Ness | Kansas | 20135 | 1 | 0 |
161189 | 161189 | 2020-05-20 | Norton | Kansas | 20137 | 2 | 0 |
161190 | 161190 | 2020-05-20 | Osage | Kansas | 20139 | 7 | 0 |
161191 | 161191 | 2020-05-20 | Osborne | Kansas | 20141 | 2 | 0 |
161192 | 161192 | 2020-05-20 | Ottawa | Kansas | 20143 | 4 | 0 |
161193 | 161193 | 2020-05-20 | Phillips | Kansas | 20147 | 2 | 0 |
161194 | 161194 | 2020-05-20 | Pottawatomie | Kansas | 20149 | 24 | 0 |
161195 | 161195 | 2020-05-20 | Pratt | Kansas | 20151 | 1 | 0 |
161196 | 161196 | 2020-05-20 | Reno | Kansas | 20155 | 51 | 0 |
161197 | 161197 | 2020-05-20 | Republic | Kansas | 20157 | 4 | 0 |
161198 | 161198 | 2020-05-20 | Rice | Kansas | 20159 | 4 | 0 |
161199 | 161199 | 2020-05-20 | Riley | Kansas | 20161 | 60 | 1 |
161200 | 161200 | 2020-05-20 | Rooks | Kansas | 20163 | 7 | 0 |
161201 | 161201 | 2020-05-20 | Saline | Kansas | 20169 | 28 | 2 |
161202 | 161202 | 2020-05-20 | Scott | Kansas | 20171 | 12 | 0 |
161203 | 161203 | 2020-05-20 | Sedgwick | Kansas | 20173 | 539 | 20 |
161204 | 161204 | 2020-05-20 | Seward | Kansas | 20175 | 799 | 1 |
161205 | 161205 | 2020-05-20 | Shawnee | Kansas | 20177 | 217 | 6 |
161206 | 161206 | 2020-05-20 | Sheridan | Kansas | 20179 | 2 | 0 |
161207 | 161207 | 2020-05-20 | Sherman | Kansas | 20181 | 6 | 0 |
161208 | 161208 | 2020-05-20 | Smith | Kansas | 20183 | 2 | 0 |
161209 | 161209 | 2020-05-20 | Stafford | Kansas | 20185 | 1 | 0 |
161210 | 161210 | 2020-05-20 | Stanton | Kansas | 20187 | 8 | 0 |
161211 | 161211 | 2020-05-20 | Stevens | Kansas | 20189 | 26 | 0 |
161212 | 161212 | 2020-05-20 | Sumner | Kansas | 20191 | 6 | 1 |
161213 | 161213 | 2020-05-20 | Wabaunsee | Kansas | 20197 | 29 | 0 |
161214 | 161214 | 2020-05-20 | Wilson | Kansas | 20205 | 1 | 0 |
161215 | 161215 | 2020-05-20 | Woodson | Kansas | 20207 | 6 | 0 |
161216 | 161216 | 2020-05-20 | Wyandotte | Kansas | 20209 | 1242 | 71 |
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);