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-10-05 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
600107 | 600107 | 2020-10-05 | Allen | Kansas | 20001 | 97 | 1 |
600108 | 600108 | 2020-10-05 | Anderson | Kansas | 20003 | 86 | 0 |
600109 | 600109 | 2020-10-05 | Atchison | Kansas | 20005 | 366 | 4 |
600110 | 600110 | 2020-10-05 | Barber | Kansas | 20007 | 13 | 0 |
600111 | 600111 | 2020-10-05 | Barton | Kansas | 20009 | 536 | 7 |
600112 | 600112 | 2020-10-05 | Bourbon | Kansas | 20011 | 212 | 3 |
600113 | 600113 | 2020-10-05 | Brown | Kansas | 20013 | 152 | 5 |
600114 | 600114 | 2020-10-05 | Butler | Kansas | 20015 | 1046 | 4 |
600115 | 600115 | 2020-10-05 | Chase | Kansas | 20017 | 87 | 1 |
600116 | 600116 | 2020-10-05 | Chautauqua | Kansas | 20019 | 22 | 0 |
600117 | 600117 | 2020-10-05 | Cherokee | Kansas | 20021 | 547 | 8 |
600118 | 600118 | 2020-10-05 | Cheyenne | Kansas | 20023 | 76 | 2 |
600119 | 600119 | 2020-10-05 | Clark | Kansas | 20025 | 55 | 1 |
600120 | 600120 | 2020-10-05 | Clay | Kansas | 20027 | 62 | 2 |
600121 | 600121 | 2020-10-05 | Cloud | Kansas | 20029 | 74 | 1 |
600122 | 600122 | 2020-10-05 | Coffey | Kansas | 20031 | 132 | 9 |
600123 | 600123 | 2020-10-05 | Comanche | Kansas | 20033 | 16 | 0 |
600124 | 600124 | 2020-10-05 | Cowley | Kansas | 20035 | 420 | 8 |
600125 | 600125 | 2020-10-05 | Crawford | Kansas | 20037 | 1163 | 8 |
600126 | 600126 | 2020-10-05 | Decatur | Kansas | 20039 | 31 | 1 |
600127 | 600127 | 2020-10-05 | Dickinson | Kansas | 20041 | 231 | 1 |
600128 | 600128 | 2020-10-05 | Doniphan | Kansas | 20043 | 120 | 0 |
600129 | 600129 | 2020-10-05 | Douglas | Kansas | 20045 | 2411 | 13 |
600130 | 600130 | 2020-10-05 | Edwards | Kansas | 20047 | 54 | 0 |
600131 | 600131 | 2020-10-05 | Elk | Kansas | 20049 | 9 | 0 |
600132 | 600132 | 2020-10-05 | Ellis | Kansas | 20051 | 1118 | 7 |
600133 | 600133 | 2020-10-05 | Ellsworth | Kansas | 20053 | 71 | 0 |
600134 | 600134 | 2020-10-05 | Finney | Kansas | 20055 | 2285 | 12 |
600135 | 600135 | 2020-10-05 | Ford | Kansas | 20057 | 2986 | 10 |
600136 | 600136 | 2020-10-05 | Franklin | Kansas | 20059 | 431 | 3 |
600137 | 600137 | 2020-10-05 | Geary | Kansas | 20061 | 453 | 3 |
600138 | 600138 | 2020-10-05 | Gove | Kansas | 20063 | 101 | 0 |
600139 | 600139 | 2020-10-05 | Graham | Kansas | 20065 | 44 | 1 |
600140 | 600140 | 2020-10-05 | Grant | Kansas | 20067 | 331 | 6 |
600141 | 600141 | 2020-10-05 | Gray | Kansas | 20069 | 133 | 0 |
600142 | 600142 | 2020-10-05 | Greeley | Kansas | 20071 | 16 | 0 |
600143 | 600143 | 2020-10-05 | Greenwood | Kansas | 20073 | 54 | 0 |
600144 | 600144 | 2020-10-05 | Hamilton | Kansas | 20075 | 48 | 0 |
600145 | 600145 | 2020-10-05 | Harper | Kansas | 20077 | 120 | 2 |
600146 | 600146 | 2020-10-05 | Harvey | Kansas | 20079 | 386 | 8 |
600147 | 600147 | 2020-10-05 | Haskell | Kansas | 20081 | 136 | 1 |
600148 | 600148 | 2020-10-05 | Hodgeman | Kansas | 20083 | 28 | 0 |
600149 | 600149 | 2020-10-05 | Jackson | Kansas | 20085 | 256 | 2 |
600150 | 600150 | 2020-10-05 | Jefferson | Kansas | 20087 | 216 | 4 |
600151 | 600151 | 2020-10-05 | Jewell | Kansas | 20089 | 17 | 1 |
600152 | 600152 | 2020-10-05 | Johnson | Kansas | 20091 | 12071 | 158 |
600153 | 600153 | 2020-10-05 | Kearny | Kansas | 20093 | 104 | 1 |
600154 | 600154 | 2020-10-05 | Kingman | Kansas | 20095 | 104 | 1 |
600155 | 600155 | 2020-10-05 | Kiowa | Kansas | 20097 | 29 | 0 |
600156 | 600156 | 2020-10-05 | Labette | Kansas | 20099 | 254 | 4 |
600157 | 600157 | 2020-10-05 | Lane | Kansas | 20101 | 16 | 0 |
600158 | 600158 | 2020-10-05 | Leavenworth | Kansas | 20103 | 2324 | 14 |
600159 | 600159 | 2020-10-05 | Lincoln | Kansas | 20105 | 15 | 0 |
600160 | 600160 | 2020-10-05 | Linn | Kansas | 20107 | 88 | 0 |
600161 | 600161 | 2020-10-05 | Logan | Kansas | 20109 | 40 | 0 |
600162 | 600162 | 2020-10-05 | Lyon | Kansas | 20111 | 1098 | 35 |
600163 | 600163 | 2020-10-05 | Marion | Kansas | 20115 | 110 | 1 |
600164 | 600164 | 2020-10-05 | Marshall | Kansas | 20117 | 40 | 0 |
600165 | 600165 | 2020-10-05 | McPherson | Kansas | 20113 | 273 | 1 |
600166 | 600166 | 2020-10-05 | Meade | Kansas | 20119 | 147 | 1 |
600167 | 600167 | 2020-10-05 | Miami | Kansas | 20121 | 428 | 1 |
600168 | 600168 | 2020-10-05 | Mitchell | Kansas | 20123 | 48 | 0 |
600169 | 600169 | 2020-10-05 | Montgomery | Kansas | 20125 | 486 | 6 |
600170 | 600170 | 2020-10-05 | Morris | Kansas | 20127 | 44 | 0 |
600171 | 600171 | 2020-10-05 | Morton | Kansas | 20129 | 20 | 2 |
600172 | 600172 | 2020-10-05 | Nemaha | Kansas | 20131 | 147 | 1 |
600173 | 600173 | 2020-10-05 | Neosho | Kansas | 20133 | 183 | 0 |
600174 | 600174 | 2020-10-05 | Ness | Kansas | 20135 | 101 | 7 |
600175 | 600175 | 2020-10-05 | Norton | Kansas | 20137 | 46 | 0 |
600176 | 600176 | 2020-10-05 | Osage | Kansas | 20139 | 117 | 0 |
600177 | 600177 | 2020-10-05 | Osborne | Kansas | 20141 | 12 | 0 |
600178 | 600178 | 2020-10-05 | Ottawa | Kansas | 20143 | 61 | 0 |
600179 | 600179 | 2020-10-05 | Pawnee | Kansas | 20145 | 397 | 1 |
600180 | 600180 | 2020-10-05 | Phillips | Kansas | 20147 | 134 | 8 |
600181 | 600181 | 2020-10-05 | Pottawatomie | Kansas | 20149 | 296 | 0 |
600182 | 600182 | 2020-10-05 | Pratt | Kansas | 20151 | 82 | 0 |
600183 | 600183 | 2020-10-05 | Rawlins | Kansas | 20153 | 83 | 0 |
600184 | 600184 | 2020-10-05 | Reno | Kansas | 20155 | 1245 | 4 |
600185 | 600185 | 2020-10-05 | Republic | Kansas | 20157 | 49 | 1 |
600186 | 600186 | 2020-10-05 | Rice | Kansas | 20159 | 88 | 1 |
600187 | 600187 | 2020-10-05 | Riley | Kansas | 20161 | 1857 | 8 |
600188 | 600188 | 2020-10-05 | Rooks | Kansas | 20163 | 117 | 4 |
600189 | 600189 | 2020-10-05 | Rush | Kansas | 20165 | 75 | 0 |
600190 | 600190 | 2020-10-05 | Russell | Kansas | 20167 | 129 | 1 |
600191 | 600191 | 2020-10-05 | Saline | Kansas | 20169 | 846 | 11 |
600192 | 600192 | 2020-10-05 | Scott | Kansas | 20171 | 136 | 1 |
600193 | 600193 | 2020-10-05 | Sedgwick | Kansas | 20173 | 9509 | 93 |
600194 | 600194 | 2020-10-05 | Seward | Kansas | 20175 | 1755 | 7 |
600195 | 600195 | 2020-10-05 | Shawnee | Kansas | 20177 | 2925 | 34 |
600196 | 600196 | 2020-10-05 | Sheridan | Kansas | 20179 | 40 | 0 |
600197 | 600197 | 2020-10-05 | Sherman | Kansas | 20181 | 48 | 0 |
600198 | 600198 | 2020-10-05 | Smith | Kansas | 20183 | 12 | 0 |
600199 | 600199 | 2020-10-05 | Stafford | Kansas | 20185 | 63 | 1 |
600200 | 600200 | 2020-10-05 | Stanton | Kansas | 20187 | 71 | 2 |
600201 | 600201 | 2020-10-05 | Stevens | Kansas | 20189 | 173 | 1 |
600202 | 600202 | 2020-10-05 | Sumner | Kansas | 20191 | 219 | 3 |
600203 | 600203 | 2020-10-05 | Thomas | Kansas | 20193 | 190 | 0 |
600204 | 600204 | 2020-10-05 | Trego | Kansas | 20195 | 58 | 3 |
600205 | 600205 | 2020-10-05 | Unknown | Kansas | 0 | 13 | |
600206 | 600206 | 2020-10-05 | Wabaunsee | Kansas | 20197 | 72 | 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);