ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where date = "2020-05-03" 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 |
---|---|---|---|---|---|---|---|
110447 | 110447 | 2020-05-03 | Atchison | Kansas | 20005 | 11 | 0 |
110448 | 110448 | 2020-05-03 | Barber | Kansas | 20007 | 1 | 0 |
110449 | 110449 | 2020-05-03 | Barton | Kansas | 20009 | 9 | 0 |
110450 | 110450 | 2020-05-03 | Bourbon | Kansas | 20011 | 6 | 1 |
110451 | 110451 | 2020-05-03 | Butler | Kansas | 20015 | 16 | 0 |
110452 | 110452 | 2020-05-03 | Chase | Kansas | 20017 | 1 | 0 |
110453 | 110453 | 2020-05-03 | Chautauqua | Kansas | 20019 | 4 | 0 |
110454 | 110454 | 2020-05-03 | Cherokee | Kansas | 20021 | 8 | 0 |
110455 | 110455 | 2020-05-03 | Cheyenne | Kansas | 20023 | 2 | 0 |
110456 | 110456 | 2020-05-03 | Clark | Kansas | 20025 | 1 | 0 |
110457 | 110457 | 2020-05-03 | Clay | Kansas | 20027 | 4 | 1 |
110458 | 110458 | 2020-05-03 | Cloud | Kansas | 20029 | 4 | 0 |
110459 | 110459 | 2020-05-03 | Coffey | Kansas | 20031 | 49 | 8 |
110460 | 110460 | 2020-05-03 | Cowley | Kansas | 20035 | 3 | 1 |
110461 | 110461 | 2020-05-03 | Crawford | Kansas | 20037 | 6 | 1 |
110462 | 110462 | 2020-05-03 | Dickinson | Kansas | 20041 | 2 | 0 |
110463 | 110463 | 2020-05-03 | Doniphan | Kansas | 20043 | 4 | 0 |
110464 | 110464 | 2020-05-03 | Douglas | Kansas | 20045 | 51 | 0 |
110465 | 110465 | 2020-05-03 | Edwards | Kansas | 20047 | 4 | 0 |
110466 | 110466 | 2020-05-03 | Ellis | Kansas | 20051 | 8 | 0 |
110467 | 110467 | 2020-05-03 | Finney | Kansas | 20055 | 550 | 3 |
110468 | 110468 | 2020-05-03 | Ford | Kansas | 20057 | 815 | 0 |
110469 | 110469 | 2020-05-03 | Franklin | Kansas | 20059 | 17 | 0 |
110470 | 110470 | 2020-05-03 | Geary | Kansas | 20061 | 13 | 0 |
110471 | 110471 | 2020-05-03 | Gove | Kansas | 20063 | 1 | 0 |
110472 | 110472 | 2020-05-03 | Grant | Kansas | 20067 | 7 | 0 |
110473 | 110473 | 2020-05-03 | Gray | Kansas | 20069 | 5 | 0 |
110474 | 110474 | 2020-05-03 | Greenwood | Kansas | 20073 | 3 | 0 |
110475 | 110475 | 2020-05-03 | Hamilton | Kansas | 20075 | 4 | 0 |
110476 | 110476 | 2020-05-03 | Harper | Kansas | 20077 | 1 | 0 |
110477 | 110477 | 2020-05-03 | Harvey | Kansas | 20079 | 8 | 0 |
110478 | 110478 | 2020-05-03 | Haskell | Kansas | 20081 | 7 | 0 |
110479 | 110479 | 2020-05-03 | Jackson | Kansas | 20085 | 2 | 0 |
110480 | 110480 | 2020-05-03 | Jefferson | Kansas | 20087 | 10 | 0 |
110481 | 110481 | 2020-05-03 | Jewell | Kansas | 20089 | 4 | 0 |
110482 | 110482 | 2020-05-03 | Johnson | Kansas | 20091 | 498 | 42 |
110483 | 110483 | 2020-05-03 | Kearny | Kansas | 20093 | 19 | 0 |
110484 | 110484 | 2020-05-03 | Kiowa | Kansas | 20097 | 2 | 0 |
110485 | 110485 | 2020-05-03 | Labette | Kansas | 20099 | 22 | 0 |
110486 | 110486 | 2020-05-03 | Leavenworth | Kansas | 20103 | 498 | 5 |
110487 | 110487 | 2020-05-03 | Linn | Kansas | 20107 | 6 | 0 |
110488 | 110488 | 2020-05-03 | Lyon | Kansas | 20111 | 248 | 1 |
110489 | 110489 | 2020-05-03 | Marion | Kansas | 20115 | 5 | 1 |
110490 | 110490 | 2020-05-03 | McPherson | Kansas | 20113 | 23 | 0 |
110491 | 110491 | 2020-05-03 | Meade | Kansas | 20119 | 10 | 0 |
110492 | 110492 | 2020-05-03 | Miami | Kansas | 20121 | 5 | 0 |
110493 | 110493 | 2020-05-03 | Mitchell | Kansas | 20123 | 3 | 0 |
110494 | 110494 | 2020-05-03 | Montgomery | Kansas | 20125 | 18 | 2 |
110495 | 110495 | 2020-05-03 | Morris | Kansas | 20127 | 3 | 0 |
110496 | 110496 | 2020-05-03 | Morton | Kansas | 20129 | 3 | 0 |
110497 | 110497 | 2020-05-03 | Nemaha | Kansas | 20131 | 1 | 0 |
110498 | 110498 | 2020-05-03 | Neosho | Kansas | 20133 | 3 | 0 |
110499 | 110499 | 2020-05-03 | Norton | Kansas | 20137 | 2 | 0 |
110500 | 110500 | 2020-05-03 | Osage | Kansas | 20139 | 5 | 0 |
110501 | 110501 | 2020-05-03 | Osborne | Kansas | 20141 | 2 | 0 |
110502 | 110502 | 2020-05-03 | Ottawa | Kansas | 20143 | 4 | 0 |
110503 | 110503 | 2020-05-03 | Phillips | Kansas | 20147 | 1 | 0 |
110504 | 110504 | 2020-05-03 | Pottawatomie | Kansas | 20149 | 15 | 0 |
110505 | 110505 | 2020-05-03 | Pratt | Kansas | 20151 | 1 | 0 |
110506 | 110506 | 2020-05-03 | Reno | Kansas | 20155 | 40 | 0 |
110507 | 110507 | 2020-05-03 | Republic | Kansas | 20157 | 4 | 0 |
110508 | 110508 | 2020-05-03 | Rice | Kansas | 20159 | 3 | 0 |
110509 | 110509 | 2020-05-03 | Riley | Kansas | 20161 | 54 | 0 |
110510 | 110510 | 2020-05-03 | Rooks | Kansas | 20163 | 6 | 0 |
110511 | 110511 | 2020-05-03 | Saline | Kansas | 20169 | 21 | 2 |
110512 | 110512 | 2020-05-03 | Scott | Kansas | 20171 | 1 | 0 |
110513 | 110513 | 2020-05-03 | Sedgwick | Kansas | 20173 | 426 | 13 |
110514 | 110514 | 2020-05-03 | Seward | Kansas | 20175 | 547 | 0 |
110515 | 110515 | 2020-05-03 | Shawnee | Kansas | 20177 | 127 | 5 |
110516 | 110516 | 2020-05-03 | Sheridan | Kansas | 20179 | 2 | 0 |
110517 | 110517 | 2020-05-03 | Sherman | Kansas | 20181 | 5 | 0 |
110518 | 110518 | 2020-05-03 | Smith | Kansas | 20183 | 2 | 0 |
110519 | 110519 | 2020-05-03 | Stafford | Kansas | 20185 | 1 | 0 |
110520 | 110520 | 2020-05-03 | Stanton | Kansas | 20187 | 5 | 0 |
110521 | 110521 | 2020-05-03 | Stevens | Kansas | 20189 | 11 | 0 |
110522 | 110522 | 2020-05-03 | Sumner | Kansas | 20191 | 4 | 1 |
110523 | 110523 | 2020-05-03 | Wabaunsee | Kansas | 20197 | 24 | 0 |
110524 | 110524 | 2020-05-03 | Wilson | Kansas | 20205 | 1 | 0 |
110525 | 110525 | 2020-05-03 | Woodson | Kansas | 20207 | 6 | 0 |
110526 | 110526 | 2020-05-03 | Wyandotte | Kansas | 20209 | 849 | 55 |
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);