ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where date = "2020-10-29" 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 |
---|---|---|---|---|---|---|---|
677959 | 677959 | 2020-10-29 | Allen | Kansas | 20001 | 112 | 1 |
677960 | 677960 | 2020-10-29 | Anderson | Kansas | 20003 | 198 | 0 |
677961 | 677961 | 2020-10-29 | Atchison | Kansas | 20005 | 512 | 5 |
677962 | 677962 | 2020-10-29 | Barber | Kansas | 20007 | 64 | 0 |
677963 | 677963 | 2020-10-29 | Barton | Kansas | 20009 | 751 | 7 |
677964 | 677964 | 2020-10-29 | Bourbon | Kansas | 20011 | 303 | 3 |
677965 | 677965 | 2020-10-29 | Brown | Kansas | 20013 | 241 | 5 |
677966 | 677966 | 2020-10-29 | Butler | Kansas | 20015 | 1517 | 3 |
677967 | 677967 | 2020-10-29 | Chase | Kansas | 20017 | 107 | 3 |
677968 | 677968 | 2020-10-29 | Chautauqua | Kansas | 20019 | 32 | 0 |
677969 | 677969 | 2020-10-29 | Cherokee | Kansas | 20021 | 694 | 8 |
677970 | 677970 | 2020-10-29 | Cheyenne | Kansas | 20023 | 131 | 5 |
677971 | 677971 | 2020-10-29 | Clark | Kansas | 20025 | 70 | 4 |
677972 | 677972 | 2020-10-29 | Clay | Kansas | 20027 | 105 | 3 |
677973 | 677973 | 2020-10-29 | Cloud | Kansas | 20029 | 147 | 1 |
677974 | 677974 | 2020-10-29 | Coffey | Kansas | 20031 | 170 | 9 |
677975 | 677975 | 2020-10-29 | Comanche | Kansas | 20033 | 20 | 0 |
677976 | 677976 | 2020-10-29 | Cowley | Kansas | 20035 | 553 | 10 |
677977 | 677977 | 2020-10-29 | Crawford | Kansas | 20037 | 1475 | 12 |
677978 | 677978 | 2020-10-29 | Decatur | Kansas | 20039 | 99 | 1 |
677979 | 677979 | 2020-10-29 | Dickinson | Kansas | 20041 | 326 | 4 |
677980 | 677980 | 2020-10-29 | Doniphan | Kansas | 20043 | 207 | 0 |
677981 | 677981 | 2020-10-29 | Douglas | Kansas | 20045 | 2927 | 19 |
677982 | 677982 | 2020-10-29 | Edwards | Kansas | 20047 | 73 | 0 |
677983 | 677983 | 2020-10-29 | Elk | Kansas | 20049 | 15 | 0 |
677984 | 677984 | 2020-10-29 | Ellis | Kansas | 20051 | 1416 | 18 |
677985 | 677985 | 2020-10-29 | Ellsworth | Kansas | 20053 | 278 | 1 |
677986 | 677986 | 2020-10-29 | Finney | Kansas | 20055 | 3075 | 20 |
677987 | 677987 | 2020-10-29 | Ford | Kansas | 20057 | 3448 | 10 |
677988 | 677988 | 2020-10-29 | Franklin | Kansas | 20059 | 561 | 5 |
677989 | 677989 | 2020-10-29 | Geary | Kansas | 20061 | 562 | 4 |
677990 | 677990 | 2020-10-29 | Gove | Kansas | 20063 | 182 | 12 |
677991 | 677991 | 2020-10-29 | Graham | Kansas | 20065 | 52 | 1 |
677992 | 677992 | 2020-10-29 | Grant | Kansas | 20067 | 457 | 8 |
677993 | 677993 | 2020-10-29 | Gray | Kansas | 20069 | 208 | 2 |
677994 | 677994 | 2020-10-29 | Greeley | Kansas | 20071 | 40 | 0 |
677995 | 677995 | 2020-10-29 | Greenwood | Kansas | 20073 | 97 | 0 |
677996 | 677996 | 2020-10-29 | Hamilton | Kansas | 20075 | 69 | 0 |
677997 | 677997 | 2020-10-29 | Harper | Kansas | 20077 | 157 | 2 |
677998 | 677998 | 2020-10-29 | Harvey | Kansas | 20079 | 607 | 8 |
677999 | 677999 | 2020-10-29 | Haskell | Kansas | 20081 | 171 | 1 |
678000 | 678000 | 2020-10-29 | Hodgeman | Kansas | 20083 | 34 | 0 |
678001 | 678001 | 2020-10-29 | Jackson | Kansas | 20085 | 329 | 4 |
678002 | 678002 | 2020-10-29 | Jefferson | Kansas | 20087 | 286 | 6 |
678003 | 678003 | 2020-10-29 | Jewell | Kansas | 20089 | 29 | 1 |
678004 | 678004 | 2020-10-29 | Johnson | Kansas | 20091 | 15320 | 201 |
678005 | 678005 | 2020-10-29 | Kearny | Kansas | 20093 | 159 | 6 |
678006 | 678006 | 2020-10-29 | Kingman | Kansas | 20095 | 141 | 3 |
678007 | 678007 | 2020-10-29 | Kiowa | Kansas | 20097 | 64 | 0 |
678008 | 678008 | 2020-10-29 | Labette | Kansas | 20099 | 397 | 6 |
678009 | 678009 | 2020-10-29 | Lane | Kansas | 20101 | 24 | 1 |
678010 | 678010 | 2020-10-29 | Leavenworth | Kansas | 20103 | 2648 | 18 |
678011 | 678011 | 2020-10-29 | Lincoln | Kansas | 20105 | 23 | 1 |
678012 | 678012 | 2020-10-29 | Linn | Kansas | 20107 | 123 | 1 |
678013 | 678013 | 2020-10-29 | Logan | Kansas | 20109 | 112 | 0 |
678014 | 678014 | 2020-10-29 | Lyon | Kansas | 20111 | 1271 | 41 |
678015 | 678015 | 2020-10-29 | Marion | Kansas | 20115 | 172 | 1 |
678016 | 678016 | 2020-10-29 | Marshall | Kansas | 20117 | 79 | 0 |
678017 | 678017 | 2020-10-29 | McPherson | Kansas | 20113 | 428 | 7 |
678018 | 678018 | 2020-10-29 | Meade | Kansas | 20119 | 167 | 2 |
678019 | 678019 | 2020-10-29 | Miami | Kansas | 20121 | 563 | 2 |
678020 | 678020 | 2020-10-29 | Mitchell | Kansas | 20123 | 57 | 0 |
678021 | 678021 | 2020-10-29 | Montgomery | Kansas | 20125 | 703 | 6 |
678022 | 678022 | 2020-10-29 | Morris | Kansas | 20127 | 64 | 0 |
678023 | 678023 | 2020-10-29 | Morton | Kansas | 20129 | 55 | 2 |
678024 | 678024 | 2020-10-29 | Nemaha | Kansas | 20131 | 334 | 2 |
678025 | 678025 | 2020-10-29 | Neosho | Kansas | 20133 | 271 | 0 |
678026 | 678026 | 2020-10-29 | Ness | Kansas | 20135 | 154 | 9 |
678027 | 678027 | 2020-10-29 | Norton | Kansas | 20137 | 668 | 15 |
678028 | 678028 | 2020-10-29 | Osage | Kansas | 20139 | 167 | 2 |
678029 | 678029 | 2020-10-29 | Osborne | Kansas | 20141 | 27 | 0 |
678030 | 678030 | 2020-10-29 | Ottawa | Kansas | 20143 | 114 | 0 |
678031 | 678031 | 2020-10-29 | Pawnee | Kansas | 20145 | 435 | 1 |
678032 | 678032 | 2020-10-29 | Phillips | Kansas | 20147 | 203 | 9 |
678033 | 678033 | 2020-10-29 | Pottawatomie | Kansas | 20149 | 392 | 0 |
678034 | 678034 | 2020-10-29 | Pratt | Kansas | 20151 | 155 | 0 |
678035 | 678035 | 2020-10-29 | Rawlins | Kansas | 20153 | 144 | 0 |
678036 | 678036 | 2020-10-29 | Reno | Kansas | 20155 | 2270 | 16 |
678037 | 678037 | 2020-10-29 | Republic | Kansas | 20157 | 89 | 1 |
678038 | 678038 | 2020-10-29 | Rice | Kansas | 20159 | 156 | 1 |
678039 | 678039 | 2020-10-29 | Riley | Kansas | 20161 | 2177 | 11 |
678040 | 678040 | 2020-10-29 | Rooks | Kansas | 20163 | 155 | 7 |
678041 | 678041 | 2020-10-29 | Rush | Kansas | 20165 | 104 | 0 |
678042 | 678042 | 2020-10-29 | Russell | Kansas | 20167 | 185 | 4 |
678043 | 678043 | 2020-10-29 | Saline | Kansas | 20169 | 1122 | 13 |
678044 | 678044 | 2020-10-29 | Scott | Kansas | 20171 | 212 | 1 |
678045 | 678045 | 2020-10-29 | Sedgwick | Kansas | 20173 | 12515 | 129 |
678046 | 678046 | 2020-10-29 | Seward | Kansas | 20175 | 2142 | 13 |
678047 | 678047 | 2020-10-29 | Shawnee | Kansas | 20177 | 3653 | 82 |
678048 | 678048 | 2020-10-29 | Sheridan | Kansas | 20179 | 177 | 0 |
678049 | 678049 | 2020-10-29 | Sherman | Kansas | 20181 | 239 | 6 |
678050 | 678050 | 2020-10-29 | Smith | Kansas | 20183 | 24 | 0 |
678051 | 678051 | 2020-10-29 | Stafford | Kansas | 20185 | 85 | 1 |
678052 | 678052 | 2020-10-29 | Stanton | Kansas | 20187 | 102 | 2 |
678053 | 678053 | 2020-10-29 | Stevens | Kansas | 20189 | 237 | 1 |
678054 | 678054 | 2020-10-29 | Sumner | Kansas | 20191 | 319 | 4 |
678055 | 678055 | 2020-10-29 | Thomas | Kansas | 20193 | 353 | 2 |
678056 | 678056 | 2020-10-29 | Trego | Kansas | 20195 | 99 | 3 |
678057 | 678057 | 2020-10-29 | Wabaunsee | Kansas | 20197 | 89 | 1 |
678058 | 678058 | 2020-10-29 | Wallace | Kansas | 20199 | 59 | 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);