ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where "date" is on date 2020-05-04 and state = "Kentucky" 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 |
---|---|---|---|---|---|---|---|
113404 | 113404 | 2020-05-04 | Adair | Kentucky | 21001 | 81 | 13 |
113405 | 113405 | 2020-05-04 | Allen | Kentucky | 21003 | 14 | 0 |
113406 | 113406 | 2020-05-04 | Anderson | Kentucky | 21005 | 9 | 1 |
113407 | 113407 | 2020-05-04 | Ballard | Kentucky | 21007 | 8 | 0 |
113408 | 113408 | 2020-05-04 | Barren | Kentucky | 21009 | 20 | 0 |
113409 | 113409 | 2020-05-04 | Bath | Kentucky | 21011 | 4 | 1 |
113410 | 113410 | 2020-05-04 | Boone | Kentucky | 21015 | 172 | 4 |
113411 | 113411 | 2020-05-04 | Bourbon | Kentucky | 21017 | 9 | 1 |
113412 | 113412 | 2020-05-04 | Boyd | Kentucky | 21019 | 31 | 3 |
113413 | 113413 | 2020-05-04 | Boyle | Kentucky | 21021 | 19 | 0 |
113414 | 113414 | 2020-05-04 | Bracken | Kentucky | 21023 | 9 | 0 |
113415 | 113415 | 2020-05-04 | Breathitt | Kentucky | 21025 | 3 | 0 |
113416 | 113416 | 2020-05-04 | Breckinridge | Kentucky | 21027 | 9 | 0 |
113417 | 113417 | 2020-05-04 | Bullitt | Kentucky | 21029 | 69 | 2 |
113418 | 113418 | 2020-05-04 | Butler | Kentucky | 21031 | 167 | 5 |
113419 | 113419 | 2020-05-04 | Caldwell | Kentucky | 21033 | 12 | 0 |
113420 | 113420 | 2020-05-04 | Calloway | Kentucky | 21035 | 35 | 1 |
113421 | 113421 | 2020-05-04 | Campbell | Kentucky | 21037 | 97 | 9 |
113422 | 113422 | 2020-05-04 | Carlisle | Kentucky | 21039 | 2 | 1 |
113423 | 113423 | 2020-05-04 | Carroll | Kentucky | 21041 | 2 | 0 |
113424 | 113424 | 2020-05-04 | Carter | Kentucky | 21043 | 6 | 0 |
113425 | 113425 | 2020-05-04 | Casey | Kentucky | 21045 | 1 | 0 |
113426 | 113426 | 2020-05-04 | Christian | Kentucky | 21047 | 90 | 3 |
113427 | 113427 | 2020-05-04 | Clark | Kentucky | 21049 | 20 | 0 |
113428 | 113428 | 2020-05-04 | Clay | Kentucky | 21051 | 1 | 0 |
113429 | 113429 | 2020-05-04 | Clinton | Kentucky | 21053 | 3 | 0 |
113430 | 113430 | 2020-05-04 | Crittenden | Kentucky | 21055 | 4 | 1 |
113431 | 113431 | 2020-05-04 | Cumberland | Kentucky | 21057 | 5 | 0 |
113432 | 113432 | 2020-05-04 | Daviess | Kentucky | 21059 | 228 | 4 |
113433 | 113433 | 2020-05-04 | Edmonson | Kentucky | 21061 | 32 | 0 |
113434 | 113434 | 2020-05-04 | Fayette | Kentucky | 21067 | 295 | 9 |
113435 | 113435 | 2020-05-04 | Fleming | Kentucky | 21069 | 2 | 0 |
113436 | 113436 | 2020-05-04 | Floyd | Kentucky | 21071 | 12 | 0 |
113437 | 113437 | 2020-05-04 | Franklin | Kentucky | 21073 | 17 | 0 |
113438 | 113438 | 2020-05-04 | Fulton | Kentucky | 21075 | 1 | 0 |
113439 | 113439 | 2020-05-04 | Gallatin | Kentucky | 21077 | 1 | 0 |
113440 | 113440 | 2020-05-04 | Garrard | Kentucky | 21079 | 2 | 0 |
113441 | 113441 | 2020-05-04 | Grant | Kentucky | 21081 | 25 | 3 |
113442 | 113442 | 2020-05-04 | Graves | Kentucky | 21083 | 141 | 14 |
113443 | 113443 | 2020-05-04 | Grayson | Kentucky | 21085 | 84 | 5 |
113444 | 113444 | 2020-05-04 | Green | Kentucky | 21087 | 1 | 0 |
113445 | 113445 | 2020-05-04 | Greenup | Kentucky | 21089 | 12 | 0 |
113446 | 113446 | 2020-05-04 | Hancock | Kentucky | 21091 | 6 | 0 |
113447 | 113447 | 2020-05-04 | Hardin | Kentucky | 21093 | 49 | 1 |
113448 | 113448 | 2020-05-04 | Harrison | Kentucky | 21097 | 18 | 0 |
113449 | 113449 | 2020-05-04 | Hart | Kentucky | 21099 | 8 | 0 |
113450 | 113450 | 2020-05-04 | Henderson | Kentucky | 21101 | 72 | 1 |
113451 | 113451 | 2020-05-04 | Henry | Kentucky | 21103 | 8 | 0 |
113452 | 113452 | 2020-05-04 | Hickman | Kentucky | 21105 | 4 | 0 |
113453 | 113453 | 2020-05-04 | Hopkins | Kentucky | 21107 | 207 | 23 |
113454 | 113454 | 2020-05-04 | Jackson | Kentucky | 21109 | 59 | 8 |
113455 | 113455 | 2020-05-04 | Jefferson | Kentucky | 21111 | 1419 | 101 |
113456 | 113456 | 2020-05-04 | Jessamine | Kentucky | 21113 | 40 | 0 |
113457 | 113457 | 2020-05-04 | Johnson | Kentucky | 21115 | 3 | 0 |
113458 | 113458 | 2020-05-04 | Kenton | Kentucky | 21117 | 317 | 24 |
113459 | 113459 | 2020-05-04 | Knott | Kentucky | 21119 | 4 | 0 |
113460 | 113460 | 2020-05-04 | Knox | Kentucky | 21121 | 6 | 0 |
113461 | 113461 | 2020-05-04 | Larue | Kentucky | 21123 | 5 | 0 |
113462 | 113462 | 2020-05-04 | Laurel | Kentucky | 21125 | 17 | 2 |
113463 | 113463 | 2020-05-04 | Lawrence | Kentucky | 21127 | 1 | 0 |
113464 | 113464 | 2020-05-04 | Leslie | Kentucky | 21131 | 4 | 0 |
113465 | 113465 | 2020-05-04 | Letcher | Kentucky | 21133 | 3 | 0 |
113466 | 113466 | 2020-05-04 | Lewis | Kentucky | 21135 | 3 | 0 |
113467 | 113467 | 2020-05-04 | Lincoln | Kentucky | 21137 | 5 | 1 |
113468 | 113468 | 2020-05-04 | Livingston | Kentucky | 21139 | 6 | 0 |
113469 | 113469 | 2020-05-04 | Logan | Kentucky | 21141 | 14 | 1 |
113470 | 113470 | 2020-05-04 | Lyon | Kentucky | 21143 | 13 | 3 |
113471 | 113471 | 2020-05-04 | Madison | Kentucky | 21151 | 30 | 1 |
113472 | 113472 | 2020-05-04 | Marion | Kentucky | 21155 | 17 | 0 |
113473 | 113473 | 2020-05-04 | Marshall | Kentucky | 21157 | 34 | 1 |
113474 | 113474 | 2020-05-04 | Martin | Kentucky | 21159 | 3 | 0 |
113475 | 113475 | 2020-05-04 | Mason | Kentucky | 21161 | 6 | 0 |
113476 | 113476 | 2020-05-04 | McCracken | Kentucky | 21145 | 62 | 2 |
113477 | 113477 | 2020-05-04 | McCreary | Kentucky | 21147 | 11 | 0 |
113478 | 113478 | 2020-05-04 | McLean | Kentucky | 21149 | 16 | 0 |
113479 | 113479 | 2020-05-04 | Meade | Kentucky | 21163 | 15 | 1 |
113480 | 113480 | 2020-05-04 | Menifee | Kentucky | 21165 | 3 | 0 |
113481 | 113481 | 2020-05-04 | Mercer | Kentucky | 21167 | 11 | 0 |
113482 | 113482 | 2020-05-04 | Metcalfe | Kentucky | 21169 | 1 | 0 |
113483 | 113483 | 2020-05-04 | Monroe | Kentucky | 21171 | 6 | 0 |
113484 | 113484 | 2020-05-04 | Montgomery | Kentucky | 21173 | 12 | 0 |
113485 | 113485 | 2020-05-04 | Morgan | Kentucky | 21175 | 1 | 0 |
113486 | 113486 | 2020-05-04 | Muhlenberg | Kentucky | 21177 | 241 | 4 |
113487 | 113487 | 2020-05-04 | Nelson | Kentucky | 21179 | 24 | 0 |
113488 | 113488 | 2020-05-04 | Nicholas | Kentucky | 21181 | 1 | 0 |
113489 | 113489 | 2020-05-04 | Ohio | Kentucky | 21183 | 67 | 0 |
113490 | 113490 | 2020-05-04 | Oldham | Kentucky | 21185 | 33 | 0 |
113491 | 113491 | 2020-05-04 | Owen | Kentucky | 21187 | 1 | 0 |
113492 | 113492 | 2020-05-04 | Owsley | Kentucky | 21189 | 2 | 0 |
113493 | 113493 | 2020-05-04 | Pendleton | Kentucky | 21191 | 6 | 0 |
113494 | 113494 | 2020-05-04 | Perry | Kentucky | 21193 | 14 | 0 |
113495 | 113495 | 2020-05-04 | Pike | Kentucky | 21195 | 13 | 2 |
113496 | 113496 | 2020-05-04 | Powell | Kentucky | 21197 | 1 | 0 |
113497 | 113497 | 2020-05-04 | Pulaski | Kentucky | 21199 | 43 | 2 |
113498 | 113498 | 2020-05-04 | Rockcastle | Kentucky | 21203 | 11 | 0 |
113499 | 113499 | 2020-05-04 | Rowan | Kentucky | 21205 | 2 | 0 |
113500 | 113500 | 2020-05-04 | Russell | Kentucky | 21207 | 16 | 3 |
113501 | 113501 | 2020-05-04 | Scott | Kentucky | 21209 | 31 | 0 |
113502 | 113502 | 2020-05-04 | Shelby | Kentucky | 21211 | 32 | 3 |
113503 | 113503 | 2020-05-04 | Simpson | Kentucky | 21213 | 28 | 2 |
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);