ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where "date" is on date 2020-09-02 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 |
---|---|---|---|---|---|---|---|
493373 | 493373 | 2020-09-02 | Adair | Kentucky | 21001 | 277 | 19 |
493374 | 493374 | 2020-09-02 | Allen | Kentucky | 21003 | 255 | 9 |
493375 | 493375 | 2020-09-02 | Anderson | Kentucky | 21005 | 119 | 1 |
493376 | 493376 | 2020-09-02 | Ballard | Kentucky | 21007 | 43 | 1 |
493377 | 493377 | 2020-09-02 | Barren | Kentucky | 21009 | 514 | 10 |
493378 | 493378 | 2020-09-02 | Bath | Kentucky | 21011 | 68 | 1 |
493379 | 493379 | 2020-09-02 | Bell | Kentucky | 21013 | 409 | 8 |
493380 | 493380 | 2020-09-02 | Boone | Kentucky | 21015 | 1321 | 25 |
493381 | 493381 | 2020-09-02 | Bourbon | Kentucky | 21017 | 129 | 1 |
493382 | 493382 | 2020-09-02 | Boyd | Kentucky | 21019 | 254 | 4 |
493383 | 493383 | 2020-09-02 | Boyle | Kentucky | 21021 | 216 | 0 |
493384 | 493384 | 2020-09-02 | Bracken | Kentucky | 21023 | 37 | 0 |
493385 | 493385 | 2020-09-02 | Breathitt | Kentucky | 21025 | 56 | 0 |
493386 | 493386 | 2020-09-02 | Breckinridge | Kentucky | 21027 | 100 | 2 |
493387 | 493387 | 2020-09-02 | Bullitt | Kentucky | 21029 | 643 | 5 |
493388 | 493388 | 2020-09-02 | Butler | Kentucky | 21031 | 326 | 16 |
493389 | 493389 | 2020-09-02 | Caldwell | Kentucky | 21033 | 84 | 0 |
493390 | 493390 | 2020-09-02 | Calloway | Kentucky | 21035 | 423 | 7 |
493391 | 493391 | 2020-09-02 | Campbell | Kentucky | 21037 | 711 | 17 |
493392 | 493392 | 2020-09-02 | Carlisle | Kentucky | 21039 | 61 | 1 |
493393 | 493393 | 2020-09-02 | Carroll | Kentucky | 21041 | 191 | 4 |
493394 | 493394 | 2020-09-02 | Carter | Kentucky | 21043 | 127 | 3 |
493395 | 493395 | 2020-09-02 | Casey | Kentucky | 21045 | 255 | 16 |
493396 | 493396 | 2020-09-02 | Christian | Kentucky | 21047 | 902 | 14 |
493397 | 493397 | 2020-09-02 | Clark | Kentucky | 21049 | 259 | 8 |
493398 | 493398 | 2020-09-02 | Clay | Kentucky | 21051 | 221 | 6 |
493399 | 493399 | 2020-09-02 | Clinton | Kentucky | 21053 | 71 | 2 |
493400 | 493400 | 2020-09-02 | Crittenden | Kentucky | 21055 | 67 | 1 |
493401 | 493401 | 2020-09-02 | Cumberland | Kentucky | 21057 | 91 | 0 |
493402 | 493402 | 2020-09-02 | Daviess | Kentucky | 21059 | 1007 | 13 |
493403 | 493403 | 2020-09-02 | Edmonson | Kentucky | 21061 | 133 | 12 |
493404 | 493404 | 2020-09-02 | Elliott | Kentucky | 21063 | 28 | 0 |
493405 | 493405 | 2020-09-02 | Estill | Kentucky | 21065 | 53 | 0 |
493406 | 493406 | 2020-09-02 | Fayette | Kentucky | 21067 | 5915 | 58 |
493407 | 493407 | 2020-09-02 | Fleming | Kentucky | 21069 | 72 | 0 |
493408 | 493408 | 2020-09-02 | Floyd | Kentucky | 21071 | 150 | 2 |
493409 | 493409 | 2020-09-02 | Franklin | Kentucky | 21073 | 483 | 11 |
493410 | 493410 | 2020-09-02 | Fulton | Kentucky | 21075 | 122 | 2 |
493411 | 493411 | 2020-09-02 | Gallatin | Kentucky | 21077 | 93 | 8 |
493412 | 493412 | 2020-09-02 | Garrard | Kentucky | 21079 | 131 | 2 |
493413 | 493413 | 2020-09-02 | Grant | Kentucky | 21081 | 140 | 6 |
493414 | 493414 | 2020-09-02 | Graves | Kentucky | 21083 | 656 | 29 |
493415 | 493415 | 2020-09-02 | Grayson | Kentucky | 21085 | 268 | 12 |
493416 | 493416 | 2020-09-02 | Green | Kentucky | 21087 | 198 | 8 |
493417 | 493417 | 2020-09-02 | Greenup | Kentucky | 21089 | 225 | 2 |
493418 | 493418 | 2020-09-02 | Hancock | Kentucky | 21091 | 59 | 0 |
493419 | 493419 | 2020-09-02 | Hardin | Kentucky | 21093 | 948 | 9 |
493420 | 493420 | 2020-09-02 | Harlan | Kentucky | 21095 | 315 | 8 |
493421 | 493421 | 2020-09-02 | Harrison | Kentucky | 21097 | 158 | 0 |
493422 | 493422 | 2020-09-02 | Hart | Kentucky | 21099 | 151 | 1 |
493423 | 493423 | 2020-09-02 | Henderson | Kentucky | 21101 | 472 | 4 |
493424 | 493424 | 2020-09-02 | Henry | Kentucky | 21103 | 164 | 2 |
493425 | 493425 | 2020-09-02 | Hickman | Kentucky | 21105 | 68 | 0 |
493426 | 493426 | 2020-09-02 | Hopkins | Kentucky | 21107 | 524 | 37 |
493427 | 493427 | 2020-09-02 | Jackson | Kentucky | 21109 | 255 | 15 |
493428 | 493428 | 2020-09-02 | Jefferson | Kentucky | 21111 | 12847 | 292 |
493429 | 493429 | 2020-09-02 | Jessamine | Kentucky | 21113 | 471 | 0 |
493430 | 493430 | 2020-09-02 | Johnson | Kentucky | 21115 | 127 | 1 |
493431 | 493431 | 2020-09-02 | Kenton | Kentucky | 21117 | 1756 | 43 |
493432 | 493432 | 2020-09-02 | Knott | Kentucky | 21119 | 92 | 1 |
493433 | 493433 | 2020-09-02 | Knox | Kentucky | 21121 | 367 | 9 |
493434 | 493434 | 2020-09-02 | Larue | Kentucky | 21123 | 105 | 1 |
493435 | 493435 | 2020-09-02 | Laurel | Kentucky | 21125 | 588 | 5 |
493436 | 493436 | 2020-09-02 | Lawrence | Kentucky | 21127 | 46 | 0 |
493437 | 493437 | 2020-09-02 | Lee | Kentucky | 21129 | 13 | 0 |
493438 | 493438 | 2020-09-02 | Leslie | Kentucky | 21131 | 41 | 0 |
493439 | 493439 | 2020-09-02 | Letcher | Kentucky | 21133 | 75 | 2 |
493440 | 493440 | 2020-09-02 | Lewis | Kentucky | 21135 | 176 | 10 |
493441 | 493441 | 2020-09-02 | Lincoln | Kentucky | 21137 | 141 | 10 |
493442 | 493442 | 2020-09-02 | Livingston | Kentucky | 21139 | 52 | 1 |
493443 | 493443 | 2020-09-02 | Logan | Kentucky | 21141 | 451 | 26 |
493444 | 493444 | 2020-09-02 | Lyon | Kentucky | 21143 | 41 | 4 |
493445 | 493445 | 2020-09-02 | Madison | Kentucky | 21151 | 1107 | 3 |
493446 | 493446 | 2020-09-02 | Magoffin | Kentucky | 21153 | 68 | 0 |
493447 | 493447 | 2020-09-02 | Marion | Kentucky | 21155 | 179 | 5 |
493448 | 493448 | 2020-09-02 | Marshall | Kentucky | 21157 | 199 | 2 |
493449 | 493449 | 2020-09-02 | Martin | Kentucky | 21159 | 59 | 2 |
493450 | 493450 | 2020-09-02 | Mason | Kentucky | 21161 | 99 | 2 |
493451 | 493451 | 2020-09-02 | McCracken | Kentucky | 21145 | 525 | 6 |
493452 | 493452 | 2020-09-02 | McCreary | Kentucky | 21147 | 106 | 0 |
493453 | 493453 | 2020-09-02 | McLean | Kentucky | 21149 | 58 | 0 |
493454 | 493454 | 2020-09-02 | Meade | Kentucky | 21163 | 152 | 3 |
493455 | 493455 | 2020-09-02 | Menifee | Kentucky | 21165 | 34 | 0 |
493456 | 493456 | 2020-09-02 | Mercer | Kentucky | 21167 | 124 | 1 |
493457 | 493457 | 2020-09-02 | Metcalfe | Kentucky | 21169 | 87 | 2 |
493458 | 493458 | 2020-09-02 | Monroe | Kentucky | 21171 | 150 | 3 |
493459 | 493459 | 2020-09-02 | Montgomery | Kentucky | 21173 | 201 | 1 |
493460 | 493460 | 2020-09-02 | Morgan | Kentucky | 21175 | 49 | 0 |
493461 | 493461 | 2020-09-02 | Muhlenberg | Kentucky | 21177 | 685 | 11 |
493462 | 493462 | 2020-09-02 | Nelson | Kentucky | 21179 | 390 | 2 |
493463 | 493463 | 2020-09-02 | Nicholas | Kentucky | 21181 | 25 | 1 |
493464 | 493464 | 2020-09-02 | Ohio | Kentucky | 21183 | 421 | 9 |
493465 | 493465 | 2020-09-02 | Oldham | Kentucky | 21185 | 842 | 24 |
493466 | 493466 | 2020-09-02 | Owen | Kentucky | 21187 | 83 | 1 |
493467 | 493467 | 2020-09-02 | Owsley | Kentucky | 21189 | 34 | 0 |
493468 | 493468 | 2020-09-02 | Pendleton | Kentucky | 21191 | 65 | 0 |
493469 | 493469 | 2020-09-02 | Perry | Kentucky | 21193 | 291 | 8 |
493470 | 493470 | 2020-09-02 | Pike | Kentucky | 21195 | 324 | 3 |
493471 | 493471 | 2020-09-02 | Powell | Kentucky | 21197 | 76 | 0 |
493472 | 493472 | 2020-09-02 | Pulaski | Kentucky | 21199 | 592 | 7 |
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);