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 2021-11-07 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1892348 | 1892348 | 2021-11-07 | Adair | Kentucky | 21001 | 3466 | 82 |
1892349 | 1892349 | 2021-11-07 | Allen | Kentucky | 21003 | 3836 | 70 |
1892350 | 1892350 | 2021-11-07 | Anderson | Kentucky | 21005 | 3584 | 48 |
1892351 | 1892351 | 2021-11-07 | Ballard | Kentucky | 21007 | 707 | 20 |
1892352 | 1892352 | 2021-11-07 | Barren | Kentucky | 21009 | 8049 | 147 |
1892353 | 1892353 | 2021-11-07 | Bath | Kentucky | 21011 | 1616 | 31 |
1892354 | 1892354 | 2021-11-07 | Bell | Kentucky | 21013 | 5854 | 96 |
1892355 | 1892355 | 2021-11-07 | Boone | Kentucky | 21015 | 21367 | 211 |
1892356 | 1892356 | 2021-11-07 | Bourbon | Kentucky | 21017 | 3216 | 35 |
1892357 | 1892357 | 2021-11-07 | Boyd | Kentucky | 21019 | 8530 | 105 |
1892358 | 1892358 | 2021-11-07 | Boyle | Kentucky | 21021 | 5421 | 81 |
1892359 | 1892359 | 2021-11-07 | Bracken | Kentucky | 21023 | 1150 | 10 |
1892360 | 1892360 | 2021-11-07 | Breathitt | Kentucky | 21025 | 2046 | 30 |
1892361 | 1892361 | 2021-11-07 | Breckinridge | Kentucky | 21027 | 2781 | 36 |
1892362 | 1892362 | 2021-11-07 | Bullitt | Kentucky | 21029 | 12237 | 128 |
1892363 | 1892363 | 2021-11-07 | Butler | Kentucky | 21031 | 2363 | 37 |
1892364 | 1892364 | 2021-11-07 | Caldwell | Kentucky | 21033 | 2450 | 49 |
1892365 | 1892365 | 2021-11-07 | Calloway | Kentucky | 21035 | 5194 | 60 |
1892366 | 1892366 | 2021-11-07 | Campbell | Kentucky | 21037 | 13254 | 106 |
1892367 | 1892367 | 2021-11-07 | Carlisle | Kentucky | 21039 | 647 | 12 |
1892368 | 1892368 | 2021-11-07 | Carroll | Kentucky | 21041 | 1934 | 28 |
1892369 | 1892369 | 2021-11-07 | Carter | Kentucky | 21043 | 4603 | 60 |
1892370 | 1892370 | 2021-11-07 | Casey | Kentucky | 21045 | 2846 | 57 |
1892371 | 1892371 | 2021-11-07 | Christian | Kentucky | 21047 | 10311 | 129 |
1892372 | 1892372 | 2021-11-07 | Clark | Kentucky | 21049 | 5356 | 40 |
1892373 | 1892373 | 2021-11-07 | Clay | Kentucky | 21051 | 5139 | 59 |
1892374 | 1892374 | 2021-11-07 | Clinton | Kentucky | 21053 | 2294 | 35 |
1892375 | 1892375 | 2021-11-07 | Crittenden | Kentucky | 21055 | 1265 | 35 |
1892376 | 1892376 | 2021-11-07 | Cumberland | Kentucky | 21057 | 1286 | 19 |
1892377 | 1892377 | 2021-11-07 | Daviess | Kentucky | 21059 | 17244 | 271 |
1892378 | 1892378 | 2021-11-07 | Edmonson | Kentucky | 21061 | 1569 | 30 |
1892379 | 1892379 | 2021-11-07 | Elliott | Kentucky | 21063 | 1350 | 8 |
1892380 | 1892380 | 2021-11-07 | Estill | Kentucky | 21065 | 2261 | 12 |
1892381 | 1892381 | 2021-11-07 | Fayette | Kentucky | 21067 | 52201 | 411 |
1892382 | 1892382 | 2021-11-07 | Fleming | Kentucky | 21069 | 2171 | 35 |
1892383 | 1892383 | 2021-11-07 | Floyd | Kentucky | 21071 | 7207 | 111 |
1892384 | 1892384 | 2021-11-07 | Franklin | Kentucky | 21073 | 7161 | 80 |
1892385 | 1892385 | 2021-11-07 | Fulton | Kentucky | 21075 | 774 | 16 |
1892386 | 1892386 | 2021-11-07 | Gallatin | Kentucky | 21077 | 1282 | 41 |
1892387 | 1892387 | 2021-11-07 | Garrard | Kentucky | 21079 | 2824 | 49 |
1892388 | 1892388 | 2021-11-07 | Grant | Kentucky | 21081 | 4457 | 40 |
1892389 | 1892389 | 2021-11-07 | Graves | Kentucky | 21083 | 7247 | 126 |
1892390 | 1892390 | 2021-11-07 | Grayson | Kentucky | 21085 | 4825 | 93 |
1892391 | 1892391 | 2021-11-07 | Green | Kentucky | 21087 | 2499 | 34 |
1892392 | 1892392 | 2021-11-07 | Greenup | Kentucky | 21089 | 6508 | 81 |
1892393 | 1892393 | 2021-11-07 | Hancock | Kentucky | 21091 | 1413 | 18 |
1892394 | 1892394 | 2021-11-07 | Hardin | Kentucky | 21093 | 18220 | 287 |
1892395 | 1892395 | 2021-11-07 | Harlan | Kentucky | 21095 | 5470 | 131 |
1892396 | 1892396 | 2021-11-07 | Harrison | Kentucky | 21097 | 3356 | 39 |
1892397 | 1892397 | 2021-11-07 | Hart | Kentucky | 21099 | 3580 | 63 |
1892398 | 1892398 | 2021-11-07 | Henderson | Kentucky | 21101 | 8037 | 101 |
1892399 | 1892399 | 2021-11-07 | Henry | Kentucky | 21103 | 2628 | 29 |
1892400 | 1892400 | 2021-11-07 | Hickman | Kentucky | 21105 | 569 | 19 |
1892401 | 1892401 | 2021-11-07 | Hopkins | Kentucky | 21107 | 8382 | 204 |
1892402 | 1892402 | 2021-11-07 | Jackson | Kentucky | 21109 | 2701 | 50 |
1892403 | 1892403 | 2021-11-07 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1892404 | 1892404 | 2021-11-07 | Jessamine | Kentucky | 21113 | 8171 | 95 |
1892405 | 1892405 | 2021-11-07 | Johnson | Kentucky | 21115 | 3784 | 48 |
1892406 | 1892406 | 2021-11-07 | Kenton | Kentucky | 21117 | 25086 | 276 |
1892407 | 1892407 | 2021-11-07 | Knott | Kentucky | 21119 | 2427 | 36 |
1892408 | 1892408 | 2021-11-07 | Knox | Kentucky | 21121 | 7227 | 53 |
1892409 | 1892409 | 2021-11-07 | Larue | Kentucky | 21123 | 2376 | 51 |
1892410 | 1892410 | 2021-11-07 | Laurel | Kentucky | 21125 | 12882 | 126 |
1892411 | 1892411 | 2021-11-07 | Lawrence | Kentucky | 21127 | 2689 | 40 |
1892412 | 1892412 | 2021-11-07 | Lee | Kentucky | 21129 | 1777 | 33 |
1892413 | 1892413 | 2021-11-07 | Leslie | Kentucky | 21131 | 2209 | 19 |
1892414 | 1892414 | 2021-11-07 | Letcher | Kentucky | 21133 | 3965 | 70 |
1892415 | 1892415 | 2021-11-07 | Lewis | Kentucky | 21135 | 2606 | 57 |
1892416 | 1892416 | 2021-11-07 | Lincoln | Kentucky | 21137 | 4393 | 93 |
1892417 | 1892417 | 2021-11-07 | Livingston | Kentucky | 21139 | 1439 | 43 |
1892418 | 1892418 | 2021-11-07 | Logan | Kentucky | 21141 | 5111 | 83 |
1892419 | 1892419 | 2021-11-07 | Lyon | Kentucky | 21143 | 1974 | 26 |
1892420 | 1892420 | 2021-11-07 | Madison | Kentucky | 21151 | 15992 | 167 |
1892421 | 1892421 | 2021-11-07 | Magoffin | Kentucky | 21153 | 2225 | 23 |
1892422 | 1892422 | 2021-11-07 | Marion | Kentucky | 21155 | 3958 | 48 |
1892423 | 1892423 | 2021-11-07 | Marshall | Kentucky | 21157 | 5049 | 79 |
1892424 | 1892424 | 2021-11-07 | Martin | Kentucky | 21159 | 1956 | 35 |
1892425 | 1892425 | 2021-11-07 | Mason | Kentucky | 21161 | 2600 | 68 |
1892426 | 1892426 | 2021-11-07 | McCracken | Kentucky | 21145 | 10255 | 178 |
1892427 | 1892427 | 2021-11-07 | McCreary | Kentucky | 21147 | 3787 | 56 |
1892428 | 1892428 | 2021-11-07 | McLean | Kentucky | 21149 | 1501 | 39 |
1892429 | 1892429 | 2021-11-07 | Meade | Kentucky | 21163 | 3486 | 37 |
1892430 | 1892430 | 2021-11-07 | Menifee | Kentucky | 21165 | 857 | 23 |
1892431 | 1892431 | 2021-11-07 | Mercer | Kentucky | 21167 | 4537 | 75 |
1892432 | 1892432 | 2021-11-07 | Metcalfe | Kentucky | 21169 | 1932 | 43 |
1892433 | 1892433 | 2021-11-07 | Monroe | Kentucky | 21171 | 2298 | 60 |
1892434 | 1892434 | 2021-11-07 | Montgomery | Kentucky | 21173 | 4546 | 58 |
1892435 | 1892435 | 2021-11-07 | Morgan | Kentucky | 21175 | 2914 | 10 |
1892436 | 1892436 | 2021-11-07 | Muhlenberg | Kentucky | 21177 | 5728 | 93 |
1892437 | 1892437 | 2021-11-07 | Nelson | Kentucky | 21179 | 8439 | 93 |
1892438 | 1892438 | 2021-11-07 | Nicholas | Kentucky | 21181 | 1205 | 19 |
1892439 | 1892439 | 2021-11-07 | Ohio | Kentucky | 21183 | 4409 | 82 |
1892440 | 1892440 | 2021-11-07 | Oldham | Kentucky | 21185 | 10245 | 95 |
1892441 | 1892441 | 2021-11-07 | Owen | Kentucky | 21187 | 1396 | 25 |
1892442 | 1892442 | 2021-11-07 | Owsley | Kentucky | 21189 | 1021 | 15 |
1892443 | 1892443 | 2021-11-07 | Pendleton | Kentucky | 21191 | 2060 | 20 |
1892444 | 1892444 | 2021-11-07 | Perry | Kentucky | 21193 | 6230 | 94 |
1892445 | 1892445 | 2021-11-07 | Pike | Kentucky | 21195 | 10835 | 188 |
1892446 | 1892446 | 2021-11-07 | Powell | Kentucky | 21197 | 2594 | 23 |
1892447 | 1892447 | 2021-11-07 | Pulaski | Kentucky | 21199 | 11545 | 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);