ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-11-03" 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 |
---|---|---|---|---|---|---|---|
1879350 | 1879350 | 2021-11-03 | Adair | Kentucky | 21001 | 3435 | 81 |
1879351 | 1879351 | 2021-11-03 | Allen | Kentucky | 21003 | 3825 | 70 |
1879352 | 1879352 | 2021-11-03 | Anderson | Kentucky | 21005 | 3571 | 48 |
1879353 | 1879353 | 2021-11-03 | Ballard | Kentucky | 21007 | 703 | 20 |
1879354 | 1879354 | 2021-11-03 | Barren | Kentucky | 21009 | 8022 | 147 |
1879355 | 1879355 | 2021-11-03 | Bath | Kentucky | 21011 | 1608 | 31 |
1879356 | 1879356 | 2021-11-03 | Bell | Kentucky | 21013 | 5841 | 96 |
1879357 | 1879357 | 2021-11-03 | Boone | Kentucky | 21015 | 21333 | 211 |
1879358 | 1879358 | 2021-11-03 | Bourbon | Kentucky | 21017 | 3202 | 35 |
1879359 | 1879359 | 2021-11-03 | Boyd | Kentucky | 21019 | 8480 | 104 |
1879360 | 1879360 | 2021-11-03 | Boyle | Kentucky | 21021 | 5407 | 81 |
1879361 | 1879361 | 2021-11-03 | Bracken | Kentucky | 21023 | 1137 | 10 |
1879362 | 1879362 | 2021-11-03 | Breathitt | Kentucky | 21025 | 2031 | 29 |
1879363 | 1879363 | 2021-11-03 | Breckinridge | Kentucky | 21027 | 2769 | 36 |
1879364 | 1879364 | 2021-11-03 | Bullitt | Kentucky | 21029 | 12207 | 128 |
1879365 | 1879365 | 2021-11-03 | Butler | Kentucky | 21031 | 2359 | 37 |
1879366 | 1879366 | 2021-11-03 | Caldwell | Kentucky | 21033 | 2440 | 49 |
1879367 | 1879367 | 2021-11-03 | Calloway | Kentucky | 21035 | 5183 | 60 |
1879368 | 1879368 | 2021-11-03 | Campbell | Kentucky | 21037 | 13234 | 106 |
1879369 | 1879369 | 2021-11-03 | Carlisle | Kentucky | 21039 | 643 | 12 |
1879370 | 1879370 | 2021-11-03 | Carroll | Kentucky | 21041 | 1917 | 27 |
1879371 | 1879371 | 2021-11-03 | Carter | Kentucky | 21043 | 4595 | 60 |
1879372 | 1879372 | 2021-11-03 | Casey | Kentucky | 21045 | 2845 | 57 |
1879373 | 1879373 | 2021-11-03 | Christian | Kentucky | 21047 | 10288 | 128 |
1879374 | 1879374 | 2021-11-03 | Clark | Kentucky | 21049 | 5334 | 40 |
1879375 | 1879375 | 2021-11-03 | Clay | Kentucky | 21051 | 5129 | 59 |
1879376 | 1879376 | 2021-11-03 | Clinton | Kentucky | 21053 | 2267 | 35 |
1879377 | 1879377 | 2021-11-03 | Crittenden | Kentucky | 21055 | 1256 | 35 |
1879378 | 1879378 | 2021-11-03 | Cumberland | Kentucky | 21057 | 1269 | 19 |
1879379 | 1879379 | 2021-11-03 | Daviess | Kentucky | 21059 | 17168 | 267 |
1879380 | 1879380 | 2021-11-03 | Edmonson | Kentucky | 21061 | 1560 | 29 |
1879381 | 1879381 | 2021-11-03 | Elliott | Kentucky | 21063 | 1347 | 8 |
1879382 | 1879382 | 2021-11-03 | Estill | Kentucky | 21065 | 2258 | 12 |
1879383 | 1879383 | 2021-11-03 | Fayette | Kentucky | 21067 | 52093 | 409 |
1879384 | 1879384 | 2021-11-03 | Fleming | Kentucky | 21069 | 2161 | 34 |
1879385 | 1879385 | 2021-11-03 | Floyd | Kentucky | 21071 | 7178 | 111 |
1879386 | 1879386 | 2021-11-03 | Franklin | Kentucky | 21073 | 7136 | 80 |
1879387 | 1879387 | 2021-11-03 | Fulton | Kentucky | 21075 | 774 | 16 |
1879388 | 1879388 | 2021-11-03 | Gallatin | Kentucky | 21077 | 1271 | 40 |
1879389 | 1879389 | 2021-11-03 | Garrard | Kentucky | 21079 | 2811 | 49 |
1879390 | 1879390 | 2021-11-03 | Grant | Kentucky | 21081 | 4441 | 40 |
1879391 | 1879391 | 2021-11-03 | Graves | Kentucky | 21083 | 7217 | 125 |
1879392 | 1879392 | 2021-11-03 | Grayson | Kentucky | 21085 | 4813 | 92 |
1879393 | 1879393 | 2021-11-03 | Green | Kentucky | 21087 | 2484 | 34 |
1879394 | 1879394 | 2021-11-03 | Greenup | Kentucky | 21089 | 6462 | 81 |
1879395 | 1879395 | 2021-11-03 | Hancock | Kentucky | 21091 | 1407 | 17 |
1879396 | 1879396 | 2021-11-03 | Hardin | Kentucky | 21093 | 18159 | 286 |
1879397 | 1879397 | 2021-11-03 | Harlan | Kentucky | 21095 | 5439 | 131 |
1879398 | 1879398 | 2021-11-03 | Harrison | Kentucky | 21097 | 3341 | 39 |
1879399 | 1879399 | 2021-11-03 | Hart | Kentucky | 21099 | 3567 | 63 |
1879400 | 1879400 | 2021-11-03 | Henderson | Kentucky | 21101 | 8012 | 100 |
1879401 | 1879401 | 2021-11-03 | Henry | Kentucky | 21103 | 2626 | 29 |
1879402 | 1879402 | 2021-11-03 | Hickman | Kentucky | 21105 | 568 | 19 |
1879403 | 1879403 | 2021-11-03 | Hopkins | Kentucky | 21107 | 8305 | 204 |
1879404 | 1879404 | 2021-11-03 | Jackson | Kentucky | 21109 | 2684 | 50 |
1879405 | 1879405 | 2021-11-03 | Jefferson | Kentucky | 21111 | 121016 | 1583 |
1879406 | 1879406 | 2021-11-03 | Jessamine | Kentucky | 21113 | 8148 | 95 |
1879407 | 1879407 | 2021-11-03 | Johnson | Kentucky | 21115 | 3762 | 48 |
1879408 | 1879408 | 2021-11-03 | Kenton | Kentucky | 21117 | 25039 | 276 |
1879409 | 1879409 | 2021-11-03 | Knott | Kentucky | 21119 | 2423 | 36 |
1879410 | 1879410 | 2021-11-03 | Knox | Kentucky | 21121 | 7205 | 53 |
1879411 | 1879411 | 2021-11-03 | Larue | Kentucky | 21123 | 2369 | 49 |
1879412 | 1879412 | 2021-11-03 | Laurel | Kentucky | 21125 | 12835 | 126 |
1879413 | 1879413 | 2021-11-03 | Lawrence | Kentucky | 21127 | 2678 | 39 |
1879414 | 1879414 | 2021-11-03 | Lee | Kentucky | 21129 | 1765 | 31 |
1879415 | 1879415 | 2021-11-03 | Leslie | Kentucky | 21131 | 2196 | 19 |
1879416 | 1879416 | 2021-11-03 | Letcher | Kentucky | 21133 | 3948 | 66 |
1879417 | 1879417 | 2021-11-03 | Lewis | Kentucky | 21135 | 2591 | 57 |
1879418 | 1879418 | 2021-11-03 | Lincoln | Kentucky | 21137 | 4384 | 89 |
1879419 | 1879419 | 2021-11-03 | Livingston | Kentucky | 21139 | 1432 | 43 |
1879420 | 1879420 | 2021-11-03 | Logan | Kentucky | 21141 | 5108 | 81 |
1879421 | 1879421 | 2021-11-03 | Lyon | Kentucky | 21143 | 1969 | 26 |
1879422 | 1879422 | 2021-11-03 | Madison | Kentucky | 21151 | 15945 | 162 |
1879423 | 1879423 | 2021-11-03 | Magoffin | Kentucky | 21153 | 2207 | 22 |
1879424 | 1879424 | 2021-11-03 | Marion | Kentucky | 21155 | 3946 | 47 |
1879425 | 1879425 | 2021-11-03 | Marshall | Kentucky | 21157 | 5046 | 78 |
1879426 | 1879426 | 2021-11-03 | Martin | Kentucky | 21159 | 1936 | 35 |
1879427 | 1879427 | 2021-11-03 | Mason | Kentucky | 21161 | 2588 | 68 |
1879428 | 1879428 | 2021-11-03 | McCracken | Kentucky | 21145 | 10206 | 178 |
1879429 | 1879429 | 2021-11-03 | McCreary | Kentucky | 21147 | 3766 | 56 |
1879430 | 1879430 | 2021-11-03 | McLean | Kentucky | 21149 | 1496 | 39 |
1879431 | 1879431 | 2021-11-03 | Meade | Kentucky | 21163 | 3480 | 37 |
1879432 | 1879432 | 2021-11-03 | Menifee | Kentucky | 21165 | 845 | 23 |
1879433 | 1879433 | 2021-11-03 | Mercer | Kentucky | 21167 | 4529 | 75 |
1879434 | 1879434 | 2021-11-03 | Metcalfe | Kentucky | 21169 | 1932 | 43 |
1879435 | 1879435 | 2021-11-03 | Monroe | Kentucky | 21171 | 2297 | 59 |
1879436 | 1879436 | 2021-11-03 | Montgomery | Kentucky | 21173 | 4522 | 57 |
1879437 | 1879437 | 2021-11-03 | Morgan | Kentucky | 21175 | 2908 | 10 |
1879438 | 1879438 | 2021-11-03 | Muhlenberg | Kentucky | 21177 | 5716 | 92 |
1879439 | 1879439 | 2021-11-03 | Nelson | Kentucky | 21179 | 8400 | 90 |
1879440 | 1879440 | 2021-11-03 | Nicholas | Kentucky | 21181 | 1196 | 18 |
1879441 | 1879441 | 2021-11-03 | Ohio | Kentucky | 21183 | 4398 | 81 |
1879442 | 1879442 | 2021-11-03 | Oldham | Kentucky | 21185 | 10209 | 93 |
1879443 | 1879443 | 2021-11-03 | Owen | Kentucky | 21187 | 1392 | 25 |
1879444 | 1879444 | 2021-11-03 | Owsley | Kentucky | 21189 | 1018 | 15 |
1879445 | 1879445 | 2021-11-03 | Pendleton | Kentucky | 21191 | 2056 | 19 |
1879446 | 1879446 | 2021-11-03 | Perry | Kentucky | 21193 | 6187 | 89 |
1879447 | 1879447 | 2021-11-03 | Pike | Kentucky | 21195 | 10802 | 181 |
1879448 | 1879448 | 2021-11-03 | Powell | Kentucky | 21197 | 2571 | 22 |
1879449 | 1879449 | 2021-11-03 | Pulaski | Kentucky | 21199 | 11495 | 186 |
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);