ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where date = "2020-03-31" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22398 | 22398 | 2020-03-31 | Atchison | Kansas | 20005 | 1 | 0 |
22399 | 22399 | 2020-03-31 | Barton | Kansas | 20009 | 1 | 0 |
22400 | 22400 | 2020-03-31 | Bourbon | Kansas | 20011 | 3 | 0 |
22401 | 22401 | 2020-03-31 | Butler | Kansas | 20015 | 3 | 0 |
22402 | 22402 | 2020-03-31 | Chautauqua | Kansas | 20019 | 1 | 0 |
22403 | 22403 | 2020-03-31 | Cherokee | Kansas | 20021 | 3 | 0 |
22404 | 22404 | 2020-03-31 | Clay | Kansas | 20027 | 1 | 0 |
22405 | 22405 | 2020-03-31 | Coffey | Kansas | 20031 | 14 | 0 |
22406 | 22406 | 2020-03-31 | Crawford | Kansas | 20037 | 5 | 1 |
22407 | 22407 | 2020-03-31 | Doniphan | Kansas | 20043 | 1 | 0 |
22408 | 22408 | 2020-03-31 | Douglas | Kansas | 20045 | 24 | 0 |
22409 | 22409 | 2020-03-31 | Finney | Kansas | 20055 | 1 | 0 |
22410 | 22410 | 2020-03-31 | Ford | Kansas | 20057 | 1 | 0 |
22411 | 22411 | 2020-03-31 | Franklin | Kansas | 20059 | 7 | 0 |
22412 | 22412 | 2020-03-31 | Gove | Kansas | 20063 | 1 | 0 |
22413 | 22413 | 2020-03-31 | Harvey | Kansas | 20079 | 1 | 0 |
22414 | 22414 | 2020-03-31 | Jackson | Kansas | 20085 | 1 | 0 |
22415 | 22415 | 2020-03-31 | Jefferson | Kansas | 20087 | 1 | 0 |
22416 | 22416 | 2020-03-31 | Johnson | Kansas | 20091 | 134 | 3 |
22417 | 22417 | 2020-03-31 | Labette | Kansas | 20099 | 1 | 0 |
22418 | 22418 | 2020-03-31 | Leavenworth | Kansas | 20103 | 24 | 0 |
22419 | 22419 | 2020-03-31 | Linn | Kansas | 20107 | 5 | 0 |
22420 | 22420 | 2020-03-31 | Lyon | Kansas | 20111 | 10 | 0 |
22421 | 22421 | 2020-03-31 | McPherson | Kansas | 20113 | 3 | 0 |
22422 | 22422 | 2020-03-31 | Miami | Kansas | 20121 | 1 | 0 |
22423 | 22423 | 2020-03-31 | Mitchell | Kansas | 20123 | 3 | 0 |
22424 | 22424 | 2020-03-31 | Montgomery | Kansas | 20125 | 5 | 0 |
22425 | 22425 | 2020-03-31 | Morris | Kansas | 20127 | 2 | 0 |
22426 | 22426 | 2020-03-31 | Neosho | Kansas | 20133 | 1 | 0 |
22427 | 22427 | 2020-03-31 | Osage | Kansas | 20139 | 3 | 0 |
22428 | 22428 | 2020-03-31 | Ottawa | Kansas | 20143 | 1 | 0 |
22429 | 22429 | 2020-03-31 | Pottawatomie | Kansas | 20149 | 2 | 0 |
22430 | 22430 | 2020-03-31 | Reno | Kansas | 20155 | 7 | 0 |
22431 | 22431 | 2020-03-31 | Riley | Kansas | 20161 | 2 | 0 |
22432 | 22432 | 2020-03-31 | Saline | Kansas | 20169 | 1 | 0 |
22433 | 22433 | 2020-03-31 | Sedgwick | Kansas | 20173 | 58 | 1 |
22434 | 22434 | 2020-03-31 | Shawnee | Kansas | 20177 | 17 | 1 |
22435 | 22435 | 2020-03-31 | Stafford | Kansas | 20185 | 1 | 0 |
22436 | 22436 | 2020-03-31 | Stevens | Kansas | 20189 | 2 | 0 |
22437 | 22437 | 2020-03-31 | Sumner | Kansas | 20191 | 1 | 0 |
22438 | 22438 | 2020-03-31 | Woodson | Kansas | 20207 | 2 | 0 |
22439 | 22439 | 2020-03-31 | Wyandotte | Kansas | 20209 | 79 | 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);