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-04-19 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1236333 | 1236333 | 2021-04-19 | Adair | Kentucky | 21001 | 1820 | 53 |
1236334 | 1236334 | 2021-04-19 | Allen | Kentucky | 21003 | 2020 | 38 |
1236335 | 1236335 | 2021-04-19 | Anderson | Kentucky | 21005 | 1702 | 20 |
1236336 | 1236336 | 2021-04-19 | Ballard | Kentucky | 21007 | 387 | 8 |
1236337 | 1236337 | 2021-04-19 | Barren | Kentucky | 21009 | 4354 | 90 |
1236338 | 1236338 | 2021-04-19 | Bath | Kentucky | 21011 | 900 | 20 |
1236339 | 1236339 | 2021-04-19 | Bell | Kentucky | 21013 | 3044 | 52 |
1236340 | 1236340 | 2021-04-19 | Boone | Kentucky | 21015 | 13980 | 138 |
1236341 | 1236341 | 2021-04-19 | Bourbon | Kentucky | 21017 | 1654 | 18 |
1236342 | 1236342 | 2021-04-19 | Boyd | Kentucky | 21019 | 4849 | 72 |
1236343 | 1236343 | 2021-04-19 | Boyle | Kentucky | 21021 | 3364 | 69 |
1236344 | 1236344 | 2021-04-19 | Bracken | Kentucky | 21023 | 607 | 7 |
1236345 | 1236345 | 2021-04-19 | Breathitt | Kentucky | 21025 | 991 | 8 |
1236346 | 1236346 | 2021-04-19 | Breckinridge | Kentucky | 21027 | 1200 | 14 |
1236347 | 1236347 | 2021-04-19 | Bullitt | Kentucky | 21029 | 6922 | 70 |
1236348 | 1236348 | 2021-04-19 | Butler | Kentucky | 21031 | 1422 | 24 |
1236349 | 1236349 | 2021-04-19 | Caldwell | Kentucky | 21033 | 1438 | 30 |
1236350 | 1236350 | 2021-04-19 | Calloway | Kentucky | 21035 | 3478 | 49 |
1236351 | 1236351 | 2021-04-19 | Campbell | Kentucky | 21037 | 8635 | 80 |
1236352 | 1236352 | 2021-04-19 | Carlisle | Kentucky | 21039 | 464 | 8 |
1236353 | 1236353 | 2021-04-19 | Carroll | Kentucky | 21041 | 982 | 19 |
1236354 | 1236354 | 2021-04-19 | Carter | Kentucky | 21043 | 2233 | 32 |
1236355 | 1236355 | 2021-04-19 | Casey | Kentucky | 21045 | 1385 | 34 |
1236356 | 1236356 | 2021-04-19 | Christian | Kentucky | 21047 | 6853 | 102 |
1236357 | 1236357 | 2021-04-19 | Clark | Kentucky | 21049 | 2738 | 28 |
1236358 | 1236358 | 2021-04-19 | Clay | Kentucky | 21051 | 2624 | 40 |
1236359 | 1236359 | 2021-04-19 | Clinton | Kentucky | 21053 | 1447 | 31 |
1236360 | 1236360 | 2021-04-19 | Crittenden | Kentucky | 21055 | 636 | 20 |
1236361 | 1236361 | 2021-04-19 | Cumberland | Kentucky | 21057 | 695 | 10 |
1236362 | 1236362 | 2021-04-19 | Daviess | Kentucky | 21059 | 10430 | 178 |
1236363 | 1236363 | 2021-04-19 | Edmonson | Kentucky | 21061 | 885 | 21 |
1236364 | 1236364 | 2021-04-19 | Elliott | Kentucky | 21063 | 953 | 2 |
1236365 | 1236365 | 2021-04-19 | Estill | Kentucky | 21065 | 1059 | 11 |
1236366 | 1236366 | 2021-04-19 | Fayette | Kentucky | 21067 | 34833 | 297 |
1236367 | 1236367 | 2021-04-19 | Fleming | Kentucky | 21069 | 1145 | 21 |
1236368 | 1236368 | 2021-04-19 | Floyd | Kentucky | 21071 | 3303 | 63 |
1236369 | 1236369 | 2021-04-19 | Franklin | Kentucky | 21073 | 3959 | 46 |
1236370 | 1236370 | 2021-04-19 | Fulton | Kentucky | 21075 | 505 | 14 |
1236371 | 1236371 | 2021-04-19 | Gallatin | Kentucky | 21077 | 691 | 27 |
1236372 | 1236372 | 2021-04-19 | Garrard | Kentucky | 21079 | 1493 | 33 |
1236373 | 1236373 | 2021-04-19 | Grant | Kentucky | 21081 | 2390 | 20 |
1236374 | 1236374 | 2021-04-19 | Graves | Kentucky | 21083 | 4114 | 90 |
1236375 | 1236375 | 2021-04-19 | Grayson | Kentucky | 21085 | 2122 | 52 |
1236376 | 1236376 | 2021-04-19 | Green | Kentucky | 21087 | 1195 | 15 |
1236377 | 1236377 | 2021-04-19 | Greenup | Kentucky | 21089 | 3524 | 57 |
1236378 | 1236378 | 2021-04-19 | Hancock | Kentucky | 21091 | 862 | 16 |
1236379 | 1236379 | 2021-04-19 | Hardin | Kentucky | 21093 | 9452 | 150 |
1236380 | 1236380 | 2021-04-19 | Harlan | Kentucky | 21095 | 2725 | 83 |
1236381 | 1236381 | 2021-04-19 | Harrison | Kentucky | 21097 | 1641 | 22 |
1236382 | 1236382 | 2021-04-19 | Hart | Kentucky | 21099 | 1940 | 45 |
1236383 | 1236383 | 2021-04-19 | Henderson | Kentucky | 21101 | 4623 | 75 |
1236384 | 1236384 | 2021-04-19 | Henry | Kentucky | 21103 | 1315 | 11 |
1236385 | 1236385 | 2021-04-19 | Hickman | Kentucky | 21105 | 357 | 10 |
1236386 | 1236386 | 2021-04-19 | Hopkins | Kentucky | 21107 | 4326 | 144 |
1236387 | 1236387 | 2021-04-19 | Jackson | Kentucky | 21109 | 1291 | 32 |
1236388 | 1236388 | 2021-04-19 | Jefferson | Kentucky | 21111 | 79723 | 1142 |
1236389 | 1236389 | 2021-04-19 | Jessamine | Kentucky | 21113 | 4476 | 61 |
1236390 | 1236390 | 2021-04-19 | Johnson | Kentucky | 21115 | 1891 | 32 |
1236391 | 1236391 | 2021-04-19 | Kenton | Kentucky | 21117 | 16558 | 195 |
1236392 | 1236392 | 2021-04-19 | Knott | Kentucky | 21119 | 1127 | 23 |
1236393 | 1236393 | 2021-04-19 | Knox | Kentucky | 21121 | 3329 | 34 |
1236394 | 1236394 | 2021-04-19 | Larue | Kentucky | 21123 | 1291 | 25 |
1236395 | 1236395 | 2021-04-19 | Laurel | Kentucky | 21125 | 6509 | 67 |
1236396 | 1236396 | 2021-04-19 | Lawrence | Kentucky | 21127 | 1390 | 20 |
1236397 | 1236397 | 2021-04-19 | Lee | Kentucky | 21129 | 1265 | 25 |
1236398 | 1236398 | 2021-04-19 | Leslie | Kentucky | 21131 | 891 | 6 |
1236399 | 1236399 | 2021-04-19 | Letcher | Kentucky | 21133 | 1866 | 42 |
1236400 | 1236400 | 2021-04-19 | Lewis | Kentucky | 21135 | 1209 | 32 |
1236401 | 1236401 | 2021-04-19 | Lincoln | Kentucky | 21137 | 2257 | 46 |
1236402 | 1236402 | 2021-04-19 | Livingston | Kentucky | 21139 | 826 | 20 |
1236403 | 1236403 | 2021-04-19 | Logan | Kentucky | 21141 | 2781 | 64 |
1236404 | 1236404 | 2021-04-19 | Lyon | Kentucky | 21143 | 1503 | 19 |
1236405 | 1236405 | 2021-04-19 | Madison | Kentucky | 21151 | 9148 | 109 |
1236406 | 1236406 | 2021-04-19 | Magoffin | Kentucky | 21153 | 930 | 14 |
1236407 | 1236407 | 2021-04-19 | Marion | Kentucky | 21155 | 2243 | 37 |
1236408 | 1236408 | 2021-04-19 | Marshall | Kentucky | 21157 | 2710 | 55 |
1236409 | 1236409 | 2021-04-19 | Martin | Kentucky | 21159 | 1012 | 20 |
1236410 | 1236410 | 2021-04-19 | Mason | Kentucky | 21161 | 1597 | 34 |
1236411 | 1236411 | 2021-04-19 | McCracken | Kentucky | 21145 | 6352 | 119 |
1236412 | 1236412 | 2021-04-19 | McCreary | Kentucky | 21147 | 1967 | 30 |
1236413 | 1236413 | 2021-04-19 | McLean | Kentucky | 21149 | 868 | 27 |
1236414 | 1236414 | 2021-04-19 | Meade | Kentucky | 21163 | 1990 | 23 |
1236415 | 1236415 | 2021-04-19 | Menifee | Kentucky | 21165 | 450 | 16 |
1236416 | 1236416 | 2021-04-19 | Mercer | Kentucky | 21167 | 2506 | 49 |
1236417 | 1236417 | 2021-04-19 | Metcalfe | Kentucky | 21169 | 1025 | 26 |
1236418 | 1236418 | 2021-04-19 | Monroe | Kentucky | 21171 | 1300 | 40 |
1236419 | 1236419 | 2021-04-19 | Montgomery | Kentucky | 21173 | 2527 | 30 |
1236420 | 1236420 | 2021-04-19 | Morgan | Kentucky | 21175 | 2186 | 3 |
1236421 | 1236421 | 2021-04-19 | Muhlenberg | Kentucky | 21177 | 2880 | 60 |
1236422 | 1236422 | 2021-04-19 | Nelson | Kentucky | 21179 | 4825 | 51 |
1236423 | 1236423 | 2021-04-19 | Nicholas | Kentucky | 21181 | 521 | 8 |
1236424 | 1236424 | 2021-04-19 | Ohio | Kentucky | 21183 | 2467 | 55 |
1236425 | 1236425 | 2021-04-19 | Oldham | Kentucky | 21185 | 7422 | 82 |
1236426 | 1236426 | 2021-04-19 | Owen | Kentucky | 21187 | 648 | 12 |
1236427 | 1236427 | 2021-04-19 | Owsley | Kentucky | 21189 | 487 | 12 |
1236428 | 1236428 | 2021-04-19 | Pendleton | Kentucky | 21191 | 1003 | 4 |
1236429 | 1236429 | 2021-04-19 | Perry | Kentucky | 21193 | 2604 | 63 |
1236430 | 1236430 | 2021-04-19 | Pike | Kentucky | 21195 | 5437 | 91 |
1236431 | 1236431 | 2021-04-19 | Powell | Kentucky | 21197 | 1158 | 11 |
1236432 | 1236432 | 2021-04-19 | Pulaski | Kentucky | 21199 | 6221 | 96 |
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);