ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where "date" is on date 2020-11-15 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 |
---|---|---|---|---|---|---|---|
733097 | 733097 | 2020-11-15 | Allen | Kansas | 20001 | 240 | 1 |
733098 | 733098 | 2020-11-15 | Anderson | Kansas | 20003 | 308 | 0 |
733099 | 733099 | 2020-11-15 | Atchison | Kansas | 20005 | 708 | 9 |
733100 | 733100 | 2020-11-15 | Barber | Kansas | 20007 | 147 | 0 |
733101 | 733101 | 2020-11-15 | Barton | Kansas | 20009 | 1205 | 12 |
733102 | 733102 | 2020-11-15 | Bourbon | Kansas | 20011 | 382 | 3 |
733103 | 733103 | 2020-11-15 | Brown | Kansas | 20013 | 450 | 6 |
733104 | 733104 | 2020-11-15 | Butler | Kansas | 20015 | 2325 | 4 |
733105 | 733105 | 2020-11-15 | Chase | Kansas | 20017 | 139 | 3 |
733106 | 733106 | 2020-11-15 | Chautauqua | Kansas | 20019 | 40 | 0 |
733107 | 733107 | 2020-11-15 | Cherokee | Kansas | 20021 | 928 | 9 |
733108 | 733108 | 2020-11-15 | Cheyenne | Kansas | 20023 | 176 | 7 |
733109 | 733109 | 2020-11-15 | Clark | Kansas | 20025 | 88 | 4 |
733110 | 733110 | 2020-11-15 | Clay | Kansas | 20027 | 282 | 8 |
733111 | 733111 | 2020-11-15 | Cloud | Kansas | 20029 | 392 | 1 |
733112 | 733112 | 2020-11-15 | Coffey | Kansas | 20031 | 243 | 9 |
733113 | 733113 | 2020-11-15 | Comanche | Kansas | 20033 | 29 | 0 |
733114 | 733114 | 2020-11-15 | Cowley | Kansas | 20035 | 989 | 9 |
733115 | 733115 | 2020-11-15 | Crawford | Kansas | 20037 | 1882 | 14 |
733116 | 733116 | 2020-11-15 | Decatur | Kansas | 20039 | 180 | 1 |
733117 | 733117 | 2020-11-15 | Dickinson | Kansas | 20041 | 570 | 5 |
733118 | 733118 | 2020-11-15 | Doniphan | Kansas | 20043 | 322 | 2 |
733119 | 733119 | 2020-11-15 | Douglas | Kansas | 20045 | 3724 | 19 |
733120 | 733120 | 2020-11-15 | Edwards | Kansas | 20047 | 115 | 0 |
733121 | 733121 | 2020-11-15 | Elk | Kansas | 20049 | 29 | 0 |
733122 | 733122 | 2020-11-15 | Ellis | Kansas | 20051 | 1820 | 18 |
733123 | 733123 | 2020-11-15 | Ellsworth | Kansas | 20053 | 478 | 3 |
733124 | 733124 | 2020-11-15 | Finney | Kansas | 20055 | 3874 | 23 |
733125 | 733125 | 2020-11-15 | Ford | Kansas | 20057 | 4128 | 10 |
733126 | 733126 | 2020-11-15 | Franklin | Kansas | 20059 | 824 | 8 |
733127 | 733127 | 2020-11-15 | Geary | Kansas | 20061 | 703 | 4 |
733128 | 733128 | 2020-11-15 | Gove | Kansas | 20063 | 247 | 19 |
733129 | 733129 | 2020-11-15 | Graham | Kansas | 20065 | 118 | 2 |
733130 | 733130 | 2020-11-15 | Grant | Kansas | 20067 | 611 | 10 |
733131 | 733131 | 2020-11-15 | Gray | Kansas | 20069 | 301 | 4 |
733132 | 733132 | 2020-11-15 | Greeley | Kansas | 20071 | 67 | 0 |
733133 | 733133 | 2020-11-15 | Greenwood | Kansas | 20073 | 161 | 0 |
733134 | 733134 | 2020-11-15 | Hamilton | Kansas | 20075 | 85 | 0 |
733135 | 733135 | 2020-11-15 | Harper | Kansas | 20077 | 225 | 4 |
733136 | 733136 | 2020-11-15 | Harvey | Kansas | 20079 | 1274 | 9 |
733137 | 733137 | 2020-11-15 | Haskell | Kansas | 20081 | 210 | 1 |
733138 | 733138 | 2020-11-15 | Hodgeman | Kansas | 20083 | 105 | 0 |
733139 | 733139 | 2020-11-15 | Jackson | Kansas | 20085 | 487 | 4 |
733140 | 733140 | 2020-11-15 | Jefferson | Kansas | 20087 | 476 | 6 |
733141 | 733141 | 2020-11-15 | Jewell | Kansas | 20089 | 40 | 1 |
733142 | 733142 | 2020-11-15 | Johnson | Kansas | 20091 | 20946 | 244 |
733143 | 733143 | 2020-11-15 | Kearny | Kansas | 20093 | 220 | 8 |
733144 | 733144 | 2020-11-15 | Kingman | Kansas | 20095 | 230 | 3 |
733145 | 733145 | 2020-11-15 | Kiowa | Kansas | 20097 | 86 | 0 |
733146 | 733146 | 2020-11-15 | Labette | Kansas | 20099 | 615 | 6 |
733147 | 733147 | 2020-11-15 | Lane | Kansas | 20101 | 60 | 1 |
733148 | 733148 | 2020-11-15 | Leavenworth | Kansas | 20103 | 3095 | 25 |
733149 | 733149 | 2020-11-15 | Lincoln | Kansas | 20105 | 31 | 1 |
733150 | 733150 | 2020-11-15 | Linn | Kansas | 20107 | 200 | 1 |
733151 | 733151 | 2020-11-15 | Logan | Kansas | 20109 | 181 | 0 |
733152 | 733152 | 2020-11-15 | Lyon | Kansas | 20111 | 1823 | 41 |
733153 | 733153 | 2020-11-15 | Marion | Kansas | 20115 | 350 | 1 |
733154 | 733154 | 2020-11-15 | Marshall | Kansas | 20117 | 258 | 0 |
733155 | 733155 | 2020-11-15 | McPherson | Kansas | 20113 | 874 | 8 |
733156 | 733156 | 2020-11-15 | Meade | Kansas | 20119 | 223 | 2 |
733157 | 733157 | 2020-11-15 | Miami | Kansas | 20121 | 747 | 2 |
733158 | 733158 | 2020-11-15 | Mitchell | Kansas | 20123 | 91 | 0 |
733159 | 733159 | 2020-11-15 | Montgomery | Kansas | 20125 | 862 | 6 |
733160 | 733160 | 2020-11-15 | Morris | Kansas | 20127 | 140 | 1 |
733161 | 733161 | 2020-11-15 | Morton | Kansas | 20129 | 105 | 3 |
733162 | 733162 | 2020-11-15 | Nemaha | Kansas | 20131 | 704 | 5 |
733163 | 733163 | 2020-11-15 | Neosho | Kansas | 20133 | 484 | 0 |
733164 | 733164 | 2020-11-15 | Ness | Kansas | 20135 | 204 | 10 |
733165 | 733165 | 2020-11-15 | Norton | Kansas | 20137 | 995 | 21 |
733166 | 733166 | 2020-11-15 | Osage | Kansas | 20139 | 306 | 5 |
733167 | 733167 | 2020-11-15 | Osborne | Kansas | 20141 | 47 | 0 |
733168 | 733168 | 2020-11-15 | Ottawa | Kansas | 20143 | 158 | 0 |
733169 | 733169 | 2020-11-15 | Pawnee | Kansas | 20145 | 495 | 1 |
733170 | 733170 | 2020-11-15 | Phillips | Kansas | 20147 | 320 | 9 |
733171 | 733171 | 2020-11-15 | Pottawatomie | Kansas | 20149 | 534 | 0 |
733172 | 733172 | 2020-11-15 | Pratt | Kansas | 20151 | 366 | 0 |
733173 | 733173 | 2020-11-15 | Rawlins | Kansas | 20153 | 199 | 2 |
733174 | 733174 | 2020-11-15 | Reno | Kansas | 20155 | 3441 | 30 |
733175 | 733175 | 2020-11-15 | Republic | Kansas | 20157 | 191 | 1 |
733176 | 733176 | 2020-11-15 | Rice | Kansas | 20159 | 246 | 1 |
733177 | 733177 | 2020-11-15 | Riley | Kansas | 20161 | 2807 | 14 |
733178 | 733178 | 2020-11-15 | Rooks | Kansas | 20163 | 221 | 7 |
733179 | 733179 | 2020-11-15 | Rush | Kansas | 20165 | 140 | 0 |
733180 | 733180 | 2020-11-15 | Russell | Kansas | 20167 | 337 | 7 |
733181 | 733181 | 2020-11-15 | Saline | Kansas | 20169 | 1603 | 17 |
733182 | 733182 | 2020-11-15 | Scott | Kansas | 20171 | 323 | 1 |
733183 | 733183 | 2020-11-15 | Sedgwick | Kansas | 20173 | 19504 | 140 |
733184 | 733184 | 2020-11-15 | Seward | Kansas | 20175 | 2467 | 13 |
733185 | 733185 | 2020-11-15 | Shawnee | Kansas | 20177 | 5335 | 97 |
733186 | 733186 | 2020-11-15 | Sheridan | Kansas | 20179 | 268 | 0 |
733187 | 733187 | 2020-11-15 | Sherman | Kansas | 20181 | 345 | 7 |
733188 | 733188 | 2020-11-15 | Smith | Kansas | 20183 | 80 | 0 |
733189 | 733189 | 2020-11-15 | Stafford | Kansas | 20185 | 149 | 1 |
733190 | 733190 | 2020-11-15 | Stanton | Kansas | 20187 | 119 | 2 |
733191 | 733191 | 2020-11-15 | Stevens | Kansas | 20189 | 338 | 1 |
733192 | 733192 | 2020-11-15 | Sumner | Kansas | 20191 | 536 | 6 |
733193 | 733193 | 2020-11-15 | Thomas | Kansas | 20193 | 536 | 2 |
733194 | 733194 | 2020-11-15 | Trego | Kansas | 20195 | 152 | 3 |
733195 | 733195 | 2020-11-15 | Unknown | Kansas | 0 | 76 | |
733196 | 733196 | 2020-11-15 | Wabaunsee | Kansas | 20197 | 205 | 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);