ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
823970 | 823970 | 2020-12-13 | Allen | Kansas | 20001 | 478 | 1 |
823971 | 823971 | 2020-12-13 | Anderson | Kansas | 20003 | 443 | 0 |
823972 | 823972 | 2020-12-13 | Atchison | Kansas | 20005 | 1040 | 10 |
823973 | 823973 | 2020-12-13 | Barber | Kansas | 20007 | 233 | 2 |
823974 | 823974 | 2020-12-13 | Barton | Kansas | 20009 | 1900 | 19 |
823975 | 823975 | 2020-12-13 | Bourbon | Kansas | 20011 | 722 | 3 |
823976 | 823976 | 2020-12-13 | Brown | Kansas | 20013 | 901 | 13 |
823977 | 823977 | 2020-12-13 | Butler | Kansas | 20015 | 4213 | 16 |
823978 | 823978 | 2020-12-13 | Chase | Kansas | 20017 | 204 | 3 |
823979 | 823979 | 2020-12-13 | Chautauqua | Kansas | 20019 | 115 | 3 |
823980 | 823980 | 2020-12-13 | Cherokee | Kansas | 20021 | 1409 | 12 |
823981 | 823981 | 2020-12-13 | Cheyenne | Kansas | 20023 | 231 | 9 |
823982 | 823982 | 2020-12-13 | Clark | Kansas | 20025 | 167 | 4 |
823983 | 823983 | 2020-12-13 | Clay | Kansas | 20027 | 500 | 14 |
823984 | 823984 | 2020-12-13 | Cloud | Kansas | 20029 | 746 | 2 |
823985 | 823985 | 2020-12-13 | Coffey | Kansas | 20031 | 383 | 10 |
823986 | 823986 | 2020-12-13 | Comanche | Kansas | 20033 | 124 | 2 |
823987 | 823987 | 2020-12-13 | Cowley | Kansas | 20035 | 2009 | 9 |
823988 | 823988 | 2020-12-13 | Crawford | Kansas | 20037 | 2815 | 23 |
823989 | 823989 | 2020-12-13 | Decatur | Kansas | 20039 | 219 | 1 |
823990 | 823990 | 2020-12-13 | Dickinson | Kansas | 20041 | 929 | 13 |
823991 | 823991 | 2020-12-13 | Doniphan | Kansas | 20043 | 607 | 5 |
823992 | 823992 | 2020-12-13 | Douglas | Kansas | 20045 | 5512 | 29 |
823993 | 823993 | 2020-12-13 | Edwards | Kansas | 20047 | 217 | 0 |
823994 | 823994 | 2020-12-13 | Elk | Kansas | 20049 | 71 | 0 |
823995 | 823995 | 2020-12-13 | Ellis | Kansas | 20051 | 2845 | 28 |
823996 | 823996 | 2020-12-13 | Ellsworth | Kansas | 20053 | 916 | 4 |
823997 | 823997 | 2020-12-13 | Finney | Kansas | 20055 | 5159 | 32 |
823998 | 823998 | 2020-12-13 | Ford | Kansas | 20057 | 4894 | 10 |
823999 | 823999 | 2020-12-13 | Franklin | Kansas | 20059 | 1363 | 17 |
824000 | 824000 | 2020-12-13 | Geary | Kansas | 20061 | 1365 | 6 |
824001 | 824001 | 2020-12-13 | Gove | Kansas | 20063 | 314 | 20 |
824002 | 824002 | 2020-12-13 | Graham | Kansas | 20065 | 189 | 2 |
824003 | 824003 | 2020-12-13 | Grant | Kansas | 20067 | 863 | 12 |
824004 | 824004 | 2020-12-13 | Gray | Kansas | 20069 | 483 | 4 |
824005 | 824005 | 2020-12-13 | Greeley | Kansas | 20071 | 89 | 0 |
824006 | 824006 | 2020-12-13 | Greenwood | Kansas | 20073 | 350 | 2 |
824007 | 824007 | 2020-12-13 | Hamilton | Kansas | 20075 | 172 | 0 |
824008 | 824008 | 2020-12-13 | Harper | Kansas | 20077 | 363 | 15 |
824009 | 824009 | 2020-12-13 | Harvey | Kansas | 20079 | 2161 | 19 |
824010 | 824010 | 2020-12-13 | Haskell | Kansas | 20081 | 317 | 1 |
824011 | 824011 | 2020-12-13 | Hodgeman | Kansas | 20083 | 151 | 4 |
824012 | 824012 | 2020-12-13 | Jackson | Kansas | 20085 | 853 | 10 |
824013 | 824013 | 2020-12-13 | Jefferson | Kansas | 20087 | 906 | 9 |
824014 | 824014 | 2020-12-13 | Jewell | Kansas | 20089 | 161 | 1 |
824015 | 824015 | 2020-12-13 | Johnson | Kansas | 20091 | 32163 | 339 |
824016 | 824016 | 2020-12-13 | Kearny | Kansas | 20093 | 444 | 8 |
824017 | 824017 | 2020-12-13 | Kingman | Kansas | 20095 | 473 | 5 |
824018 | 824018 | 2020-12-13 | Kiowa | Kansas | 20097 | 147 | 0 |
824019 | 824019 | 2020-12-13 | Labette | Kansas | 20099 | 1246 | 6 |
824020 | 824020 | 2020-12-13 | Lane | Kansas | 20101 | 112 | 3 |
824021 | 824021 | 2020-12-13 | Leavenworth | Kansas | 20103 | 4347 | 35 |
824022 | 824022 | 2020-12-13 | Lincoln | Kansas | 20105 | 146 | 1 |
824023 | 824023 | 2020-12-13 | Linn | Kansas | 20107 | 391 | 3 |
824024 | 824024 | 2020-12-13 | Logan | Kansas | 20109 | 258 | 0 |
824025 | 824025 | 2020-12-13 | Lyon | Kansas | 20111 | 3012 | 51 |
824026 | 824026 | 2020-12-13 | Marion | Kansas | 20115 | 541 | 1 |
824027 | 824027 | 2020-12-13 | Marshall | Kansas | 20117 | 724 | 17 |
824028 | 824028 | 2020-12-13 | McPherson | Kansas | 20113 | 1949 | 14 |
824029 | 824029 | 2020-12-13 | Meade | Kansas | 20119 | 351 | 4 |
824030 | 824030 | 2020-12-13 | Miami | Kansas | 20121 | 1339 | 7 |
824031 | 824031 | 2020-12-13 | Mitchell | Kansas | 20123 | 297 | 0 |
824032 | 824032 | 2020-12-13 | Montgomery | Kansas | 20125 | 1480 | 6 |
824033 | 824033 | 2020-12-13 | Morris | Kansas | 20127 | 299 | 1 |
824034 | 824034 | 2020-12-13 | Morton | Kansas | 20129 | 195 | 8 |
824035 | 824035 | 2020-12-13 | Nemaha | Kansas | 20131 | 1219 | 34 |
824036 | 824036 | 2020-12-13 | Neosho | Kansas | 20133 | 877 | 3 |
824037 | 824037 | 2020-12-13 | Ness | Kansas | 20135 | 321 | 15 |
824038 | 824038 | 2020-12-13 | Norton | Kansas | 20137 | 1132 | 24 |
824039 | 824039 | 2020-12-13 | Osage | Kansas | 20139 | 657 | 6 |
824040 | 824040 | 2020-12-13 | Osborne | Kansas | 20141 | 121 | 0 |
824041 | 824041 | 2020-12-13 | Ottawa | Kansas | 20143 | 329 | 0 |
824042 | 824042 | 2020-12-13 | Pawnee | Kansas | 20145 | 847 | 1 |
824043 | 824043 | 2020-12-13 | Phillips | Kansas | 20147 | 519 | 12 |
824044 | 824044 | 2020-12-13 | Pottawatomie | Kansas | 20149 | 799 | 3 |
824045 | 824045 | 2020-12-13 | Pratt | Kansas | 20151 | 600 | 15 |
824046 | 824046 | 2020-12-13 | Rawlins | Kansas | 20153 | 268 | 3 |
824047 | 824047 | 2020-12-13 | Reno | Kansas | 20155 | 6138 | 76 |
824048 | 824048 | 2020-12-13 | Republic | Kansas | 20157 | 475 | 9 |
824049 | 824049 | 2020-12-13 | Rice | Kansas | 20159 | 608 | 1 |
824050 | 824050 | 2020-12-13 | Riley | Kansas | 20161 | 4176 | 16 |
824051 | 824051 | 2020-12-13 | Rooks | Kansas | 20163 | 410 | 8 |
824052 | 824052 | 2020-12-13 | Rush | Kansas | 20165 | 301 | 0 |
824053 | 824053 | 2020-12-13 | Russell | Kansas | 20167 | 659 | 17 |
824054 | 824054 | 2020-12-13 | Saline | Kansas | 20169 | 3259 | 43 |
824055 | 824055 | 2020-12-13 | Scott | Kansas | 20171 | 512 | 8 |
824056 | 824056 | 2020-12-13 | Sedgwick | Kansas | 20173 | 32709 | 199 |
824057 | 824057 | 2020-12-13 | Seward | Kansas | 20175 | 3253 | 13 |
824058 | 824058 | 2020-12-13 | Shawnee | Kansas | 20177 | 9623 | 171 |
824059 | 824059 | 2020-12-13 | Sheridan | Kansas | 20179 | 349 | 0 |
824060 | 824060 | 2020-12-13 | Sherman | Kansas | 20181 | 503 | 7 |
824061 | 824061 | 2020-12-13 | Smith | Kansas | 20183 | 195 | 1 |
824062 | 824062 | 2020-12-13 | Stafford | Kansas | 20185 | 242 | 5 |
824063 | 824063 | 2020-12-13 | Stanton | Kansas | 20187 | 154 | 2 |
824064 | 824064 | 2020-12-13 | Stevens | Kansas | 20189 | 481 | 5 |
824065 | 824065 | 2020-12-13 | Sumner | Kansas | 20191 | 1060 | 6 |
824066 | 824066 | 2020-12-13 | Thomas | Kansas | 20193 | 824 | 6 |
824067 | 824067 | 2020-12-13 | Trego | Kansas | 20195 | 260 | 3 |
824068 | 824068 | 2020-12-13 | Unknown | Kansas | 0 | 255 | |
824069 | 824069 | 2020-12-13 | Wabaunsee | Kansas | 20197 | 348 | 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);