ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where "date" is on date 2021-11-10 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1901993 | 1901993 | 2021-11-10 | Allen | Kansas | 20001 | 2018 | 27 |
1901994 | 1901994 | 2021-11-10 | Anderson | Kansas | 20003 | 1148 | 22 |
1901995 | 1901995 | 2021-11-10 | Atchison | Kansas | 20005 | 2464 | 27 |
1901996 | 1901996 | 2021-11-10 | Barber | Kansas | 20007 | 514 | 7 |
1901997 | 1901997 | 2021-11-10 | Barton | Kansas | 20009 | 4077 | 62 |
1901998 | 1901998 | 2021-11-10 | Bourbon | Kansas | 20011 | 2539 | 44 |
1901999 | 1901999 | 2021-11-10 | Brown | Kansas | 20013 | 1707 | 41 |
1902000 | 1902000 | 2021-11-10 | Butler | Kansas | 20015 | 11253 | 139 |
1902001 | 1902001 | 2021-11-10 | Chase | Kansas | 20017 | 378 | 4 |
1902002 | 1902002 | 2021-11-10 | Chautauqua | Kansas | 20019 | 528 | 11 |
1902003 | 1902003 | 2021-11-10 | Cherokee | Kansas | 20021 | 3723 | 79 |
1902004 | 1902004 | 2021-11-10 | Cheyenne | Kansas | 20023 | 451 | 14 |
1902005 | 1902005 | 2021-11-10 | Clark | Kansas | 20025 | 338 | 7 |
1902006 | 1902006 | 2021-11-10 | Clay | Kansas | 20027 | 1277 | 31 |
1902007 | 1902007 | 2021-11-10 | Cloud | Kansas | 20029 | 1485 | 32 |
1902008 | 1902008 | 2021-11-10 | Coffey | Kansas | 20031 | 1267 | 28 |
1902009 | 1902009 | 2021-11-10 | Comanche | Kansas | 20033 | 315 | 13 |
1902010 | 1902010 | 2021-11-10 | Cowley | Kansas | 20035 | 5808 | 127 |
1902011 | 1902011 | 2021-11-10 | Crawford | Kansas | 20037 | 6830 | 113 |
1902012 | 1902012 | 2021-11-10 | Decatur | Kansas | 20039 | 375 | 13 |
1902013 | 1902013 | 2021-11-10 | Dickinson | Kansas | 20041 | 3004 | 62 |
1902014 | 1902014 | 2021-11-10 | Doniphan | Kansas | 20043 | 1437 | 29 |
1902015 | 1902015 | 2021-11-10 | Douglas | Kansas | 20045 | 12750 | 105 |
1902016 | 1902016 | 2021-11-10 | Edwards | Kansas | 20047 | 415 | 13 |
1902017 | 1902017 | 2021-11-10 | Elk | Kansas | 20049 | 317 | 6 |
1902018 | 1902018 | 2021-11-10 | Ellis | Kansas | 20051 | 4672 | 76 |
1902019 | 1902019 | 2021-11-10 | Ellsworth | Kansas | 20053 | 1427 | 30 |
1902020 | 1902020 | 2021-11-10 | Finney | Kansas | 20055 | 7703 | 91 |
1902021 | 1902021 | 2021-11-10 | Ford | Kansas | 20057 | 7278 | 96 |
1902022 | 1902022 | 2021-11-10 | Franklin | Kansas | 20059 | 3909 | 60 |
1902023 | 1902023 | 2021-11-10 | Geary | Kansas | 20061 | 4864 | 58 |
1902024 | 1902024 | 2021-11-10 | Gove | Kansas | 20063 | 498 | 22 |
1902025 | 1902025 | 2021-11-10 | Graham | Kansas | 20065 | 325 | 12 |
1902026 | 1902026 | 2021-11-10 | Grant | Kansas | 20067 | 1345 | 30 |
1902027 | 1902027 | 2021-11-10 | Gray | Kansas | 20069 | 908 | 20 |
1902028 | 1902028 | 2021-11-10 | Greeley | Kansas | 20071 | 168 | 3 |
1902029 | 1902029 | 2021-11-10 | Greenwood | Kansas | 20073 | 996 | 15 |
1902030 | 1902030 | 2021-11-10 | Hamilton | Kansas | 20075 | 309 | 1 |
1902031 | 1902031 | 2021-11-10 | Harper | Kansas | 20077 | 940 | 24 |
1902032 | 1902032 | 2021-11-10 | Harvey | Kansas | 20079 | 5255 | 91 |
1902033 | 1902033 | 2021-11-10 | Haskell | Kansas | 20081 | 591 | 9 |
1902034 | 1902034 | 2021-11-10 | Hodgeman | Kansas | 20083 | 244 | 10 |
1902035 | 1902035 | 2021-11-10 | Jackson | Kansas | 20085 | 2181 | 20 |
1902036 | 1902036 | 2021-11-10 | Jefferson | Kansas | 20087 | 2662 | 50 |
1902037 | 1902037 | 2021-11-10 | Jewell | Kansas | 20089 | 501 | 11 |
1902038 | 1902038 | 2021-11-10 | Johnson | Kansas | 20091 | 79476 | 952 |
1902039 | 1902039 | 2021-11-10 | Kearny | Kansas | 20093 | 818 | 16 |
1902040 | 1902040 | 2021-11-10 | Kingman | Kansas | 20095 | 1233 | 23 |
1902041 | 1902041 | 2021-11-10 | Kiowa | Kansas | 20097 | 407 | 5 |
1902042 | 1902042 | 2021-11-10 | Labette | Kansas | 20099 | 3701 | 62 |
1902043 | 1902043 | 2021-11-10 | Lane | Kansas | 20101 | 174 | 8 |
1902044 | 1902044 | 2021-11-10 | Leavenworth | Kansas | 20103 | 10625 | 134 |
1902045 | 1902045 | 2021-11-10 | Lincoln | Kansas | 20105 | 380 | 6 |
1902046 | 1902046 | 2021-11-10 | Linn | Kansas | 20107 | 1626 | 21 |
1902047 | 1902047 | 2021-11-10 | Logan | Kansas | 20109 | 462 | 9 |
1902048 | 1902048 | 2021-11-10 | Lyon | Kansas | 20111 | 5624 | 93 |
1902049 | 1902049 | 2021-11-10 | Marion | Kansas | 20115 | 1766 | 35 |
1902050 | 1902050 | 2021-11-10 | Marshall | Kansas | 20117 | 1557 | 32 |
1902051 | 1902051 | 2021-11-10 | McPherson | Kansas | 20113 | 4738 | 98 |
1902052 | 1902052 | 2021-11-10 | Meade | Kansas | 20119 | 728 | 14 |
1902053 | 1902053 | 2021-11-10 | Miami | Kansas | 20121 | 4447 | 67 |
1902054 | 1902054 | 2021-11-10 | Mitchell | Kansas | 20123 | 832 | 17 |
1902055 | 1902055 | 2021-11-10 | Montgomery | Kansas | 20125 | 5436 | 119 |
1902056 | 1902056 | 2021-11-10 | Morris | Kansas | 20127 | 796 | 23 |
1902057 | 1902057 | 2021-11-10 | Morton | Kansas | 20129 | 419 | 9 |
1902058 | 1902058 | 2021-11-10 | Nemaha | Kansas | 20131 | 2012 | 56 |
1902059 | 1902059 | 2021-11-10 | Neosho | Kansas | 20133 | 2730 | 53 |
1902060 | 1902060 | 2021-11-10 | Ness | Kansas | 20135 | 503 | 17 |
1902061 | 1902061 | 2021-11-10 | Norton | Kansas | 20137 | 1510 | 32 |
1902062 | 1902062 | 2021-11-10 | Osage | Kansas | 20139 | 2081 | 39 |
1902063 | 1902063 | 2021-11-10 | Osborne | Kansas | 20141 | 454 | 15 |
1902064 | 1902064 | 2021-11-10 | Ottawa | Kansas | 20143 | 776 | 14 |
1902065 | 1902065 | 2021-11-10 | Pawnee | Kansas | 20145 | 1517 | 19 |
1902066 | 1902066 | 2021-11-10 | Phillips | Kansas | 20147 | 945 | 28 |
1902067 | 1902067 | 2021-11-10 | Pottawatomie | Kansas | 20149 | 2935 | 44 |
1902068 | 1902068 | 2021-11-10 | Pratt | Kansas | 20151 | 1302 | 27 |
1902069 | 1902069 | 2021-11-10 | Rawlins | Kansas | 20153 | 490 | 7 |
1902070 | 1902070 | 2021-11-10 | Reno | Kansas | 20155 | 11735 | 171 |
1902071 | 1902071 | 2021-11-10 | Republic | Kansas | 20157 | 910 | 15 |
1902072 | 1902072 | 2021-11-10 | Rice | Kansas | 20159 | 1490 | 15 |
1902073 | 1902073 | 2021-11-10 | Riley | Kansas | 20161 | 8138 | 60 |
1902074 | 1902074 | 2021-11-10 | Rooks | Kansas | 20163 | 811 | 13 |
1902075 | 1902075 | 2021-11-10 | Rush | Kansas | 20165 | 527 | 16 |
1902076 | 1902076 | 2021-11-10 | Russell | Kansas | 20167 | 1219 | 33 |
1902077 | 1902077 | 2021-11-10 | Saline | Kansas | 20169 | 8753 | 186 |
1902078 | 1902078 | 2021-11-10 | Scott | Kansas | 20171 | 831 | 29 |
1902079 | 1902079 | 2021-11-10 | Sedgwick | Kansas | 20173 | 83089 | 1063 |
1902080 | 1902080 | 2021-11-10 | Seward | Kansas | 20175 | 4881 | 53 |
1902081 | 1902081 | 2021-11-10 | Shawnee | Kansas | 20177 | 26177 | 472 |
1902082 | 1902082 | 2021-11-10 | Sheridan | Kansas | 20179 | 516 | 15 |
1902083 | 1902083 | 2021-11-10 | Sherman | Kansas | 20181 | 946 | 13 |
1902084 | 1902084 | 2021-11-10 | Smith | Kansas | 20183 | 415 | 3 |
1902085 | 1902085 | 2021-11-10 | Stafford | Kansas | 20185 | 644 | 17 |
1902086 | 1902086 | 2021-11-10 | Stanton | Kansas | 20187 | 298 | 6 |
1902087 | 1902087 | 2021-11-10 | Stevens | Kansas | 20189 | 909 | 14 |
1902088 | 1902088 | 2021-11-10 | Sumner | Kansas | 20191 | 3317 | 62 |
1902089 | 1902089 | 2021-11-10 | Thomas | Kansas | 20193 | 1445 | 22 |
1902090 | 1902090 | 2021-11-10 | Trego | Kansas | 20195 | 507 | 8 |
1902091 | 1902091 | 2021-11-10 | Wabaunsee | Kansas | 20197 | 944 | 18 |
1902092 | 1902092 | 2021-11-10 | Wallace | Kansas | 20199 | 270 | 4 |
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);