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 2022-04-03 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370337 | 2370337 | 2022-04-03 | Adair | Kentucky | 21001 | 5865 | 103 |
2370338 | 2370338 | 2022-04-03 | Allen | Kentucky | 21003 | 6577 | 97 |
2370339 | 2370339 | 2022-04-03 | Anderson | Kentucky | 21005 | 6478 | 68 |
2370340 | 2370340 | 2022-04-03 | Ballard | Kentucky | 21007 | 1308 | 28 |
2370341 | 2370341 | 2022-04-03 | Barren | Kentucky | 21009 | 12983 | 215 |
2370342 | 2370342 | 2022-04-03 | Bath | Kentucky | 21011 | 3055 | 42 |
2370343 | 2370343 | 2022-04-03 | Bell | Kentucky | 21013 | 8847 | 142 |
2370344 | 2370344 | 2022-04-03 | Boone | Kentucky | 21015 | 39559 | 277 |
2370345 | 2370345 | 2022-04-03 | Bourbon | Kentucky | 21017 | 5949 | 55 |
2370346 | 2370346 | 2022-04-03 | Boyd | Kentucky | 21019 | 16244 | 172 |
2370347 | 2370347 | 2022-04-03 | Boyle | Kentucky | 21021 | 8382 | 126 |
2370348 | 2370348 | 2022-04-03 | Bracken | Kentucky | 21023 | 2149 | 24 |
2370349 | 2370349 | 2022-04-03 | Breathitt | Kentucky | 21025 | 3711 | 51 |
2370350 | 2370350 | 2022-04-03 | Breckinridge | Kentucky | 21027 | 5010 | 76 |
2370351 | 2370351 | 2022-04-03 | Bullitt | Kentucky | 21029 | 21176 | 211 |
2370352 | 2370352 | 2022-04-03 | Butler | Kentucky | 21031 | 3859 | 50 |
2370353 | 2370353 | 2022-04-03 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2370354 | 2370354 | 2022-04-03 | Calloway | Kentucky | 21035 | 7953 | 90 |
2370355 | 2370355 | 2022-04-03 | Campbell | Kentucky | 21037 | 24621 | 164 |
2370356 | 2370356 | 2022-04-03 | Carlisle | Kentucky | 21039 | 1006 | 19 |
2370357 | 2370357 | 2022-04-03 | Carroll | Kentucky | 21041 | 3486 | 44 |
2370358 | 2370358 | 2022-04-03 | Carter | Kentucky | 21043 | 8591 | 104 |
2370359 | 2370359 | 2022-04-03 | Casey | Kentucky | 21045 | 4203 | 72 |
2370360 | 2370360 | 2022-04-03 | Christian | Kentucky | 21047 | 16353 | 203 |
2370361 | 2370361 | 2022-04-03 | Clark | Kentucky | 21049 | 10383 | 64 |
2370362 | 2370362 | 2022-04-03 | Clay | Kentucky | 21051 | 7857 | 86 |
2370363 | 2370363 | 2022-04-03 | Clinton | Kentucky | 21053 | 3603 | 49 |
2370364 | 2370364 | 2022-04-03 | Crittenden | Kentucky | 21055 | 2289 | 47 |
2370365 | 2370365 | 2022-04-03 | Cumberland | Kentucky | 21057 | 2218 | 30 |
2370366 | 2370366 | 2022-04-03 | Daviess | Kentucky | 21059 | 31004 | 377 |
2370367 | 2370367 | 2022-04-03 | Edmonson | Kentucky | 21061 | 2550 | 43 |
2370368 | 2370368 | 2022-04-03 | Elliott | Kentucky | 21063 | 2375 | 18 |
2370369 | 2370369 | 2022-04-03 | Estill | Kentucky | 21065 | 4108 | 45 |
2370370 | 2370370 | 2022-04-03 | Fayette | Kentucky | 21067 | 94442 | 580 |
2370371 | 2370371 | 2022-04-03 | Fleming | Kentucky | 21069 | 3759 | 54 |
2370372 | 2370372 | 2022-04-03 | Floyd | Kentucky | 21071 | 12500 | 176 |
2370373 | 2370373 | 2022-04-03 | Franklin | Kentucky | 21073 | 13584 | 143 |
2370374 | 2370374 | 2022-04-03 | Fulton | Kentucky | 21075 | 1167 | 28 |
2370375 | 2370375 | 2022-04-03 | Gallatin | Kentucky | 21077 | 2201 | 48 |
2370376 | 2370376 | 2022-04-03 | Garrard | Kentucky | 21079 | 4793 | 74 |
2370377 | 2370377 | 2022-04-03 | Grant | Kentucky | 21081 | 7762 | 58 |
2370378 | 2370378 | 2022-04-03 | Graves | Kentucky | 21083 | 11338 | 176 |
2370379 | 2370379 | 2022-04-03 | Grayson | Kentucky | 21085 | 8112 | 126 |
2370380 | 2370380 | 2022-04-03 | Green | Kentucky | 21087 | 3720 | 42 |
2370381 | 2370381 | 2022-04-03 | Greenup | Kentucky | 21089 | 12026 | 136 |
2370382 | 2370382 | 2022-04-03 | Hancock | Kentucky | 21091 | 2475 | 24 |
2370383 | 2370383 | 2022-04-03 | Hardin | Kentucky | 21093 | 32453 | 421 |
2370384 | 2370384 | 2022-04-03 | Harlan | Kentucky | 21095 | 9199 | 199 |
2370385 | 2370385 | 2022-04-03 | Harrison | Kentucky | 21097 | 6238 | 68 |
2370386 | 2370386 | 2022-04-03 | Hart | Kentucky | 21099 | 5404 | 97 |
2370387 | 2370387 | 2022-04-03 | Henderson | Kentucky | 21101 | 13792 | 157 |
2370388 | 2370388 | 2022-04-03 | Henry | Kentucky | 21103 | 4762 | 47 |
2370389 | 2370389 | 2022-04-03 | Hickman | Kentucky | 21105 | 848 | 25 |
2370390 | 2370390 | 2022-04-03 | Hopkins | Kentucky | 21107 | 14905 | 250 |
2370391 | 2370391 | 2022-04-03 | Jackson | Kentucky | 21109 | 4270 | 76 |
2370392 | 2370392 | 2022-04-03 | Jefferson | Kentucky | 21111 | 228549 | 2292 |
2370393 | 2370393 | 2022-04-03 | Jessamine | Kentucky | 21113 | 15119 | 135 |
2370394 | 2370394 | 2022-04-03 | Johnson | Kentucky | 21115 | 5986 | 104 |
2370395 | 2370395 | 2022-04-03 | Kenton | Kentucky | 21117 | 45539 | 387 |
2370396 | 2370396 | 2022-04-03 | Knott | Kentucky | 21119 | 4191 | 62 |
2370397 | 2370397 | 2022-04-03 | Knox | Kentucky | 21121 | 11481 | 129 |
2370398 | 2370398 | 2022-04-03 | Larue | Kentucky | 21123 | 3719 | 69 |
2370399 | 2370399 | 2022-04-03 | Laurel | Kentucky | 21125 | 19382 | 218 |
2370400 | 2370400 | 2022-04-03 | Lawrence | Kentucky | 21127 | 4544 | 67 |
2370401 | 2370401 | 2022-04-03 | Lee | Kentucky | 21129 | 2920 | 49 |
2370402 | 2370402 | 2022-04-03 | Leslie | Kentucky | 21131 | 3704 | 42 |
2370403 | 2370403 | 2022-04-03 | Letcher | Kentucky | 21133 | 7056 | 105 |
2370404 | 2370404 | 2022-04-03 | Lewis | Kentucky | 21135 | 4504 | 84 |
2370405 | 2370405 | 2022-04-03 | Lincoln | Kentucky | 21137 | 6351 | 127 |
2370406 | 2370406 | 2022-04-03 | Livingston | Kentucky | 21139 | 2471 | 59 |
2370407 | 2370407 | 2022-04-03 | Logan | Kentucky | 21141 | 8340 | 123 |
2370408 | 2370408 | 2022-04-03 | Lyon | Kentucky | 21143 | 2869 | 33 |
2370409 | 2370409 | 2022-04-03 | Madison | Kentucky | 21151 | 27626 | 267 |
2370410 | 2370410 | 2022-04-03 | Magoffin | Kentucky | 21153 | 3910 | 46 |
2370411 | 2370411 | 2022-04-03 | Marion | Kentucky | 21155 | 6387 | 81 |
2370412 | 2370412 | 2022-04-03 | Marshall | Kentucky | 21157 | 8392 | 101 |
2370413 | 2370413 | 2022-04-03 | Martin | Kentucky | 21159 | 3297 | 49 |
2370414 | 2370414 | 2022-04-03 | Mason | Kentucky | 21161 | 4756 | 103 |
2370415 | 2370415 | 2022-04-03 | McCracken | Kentucky | 21145 | 18251 | 241 |
2370416 | 2370416 | 2022-04-03 | McCreary | Kentucky | 21147 | 5695 | 75 |
2370417 | 2370417 | 2022-04-03 | McLean | Kentucky | 21149 | 2607 | 49 |
2370418 | 2370418 | 2022-04-03 | Meade | Kentucky | 21163 | 5794 | 64 |
2370419 | 2370419 | 2022-04-03 | Menifee | Kentucky | 21165 | 1600 | 31 |
2370420 | 2370420 | 2022-04-03 | Mercer | Kentucky | 21167 | 7329 | 102 |
2370421 | 2370421 | 2022-04-03 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2370422 | 2370422 | 2022-04-03 | Monroe | Kentucky | 21171 | 3616 | 76 |
2370423 | 2370423 | 2022-04-03 | Montgomery | Kentucky | 21173 | 7208 | 93 |
2370424 | 2370424 | 2022-04-03 | Morgan | Kentucky | 21175 | 4956 | 22 |
2370425 | 2370425 | 2022-04-03 | Muhlenberg | Kentucky | 21177 | 10131 | 120 |
2370426 | 2370426 | 2022-04-03 | Nelson | Kentucky | 21179 | 14396 | 149 |
2370427 | 2370427 | 2022-04-03 | Nicholas | Kentucky | 21181 | 1970 | 31 |
2370428 | 2370428 | 2022-04-03 | Ohio | Kentucky | 21183 | 7299 | 98 |
2370429 | 2370429 | 2022-04-03 | Oldham | Kentucky | 21185 | 18227 | 137 |
2370430 | 2370430 | 2022-04-03 | Owen | Kentucky | 21187 | 2359 | 33 |
2370431 | 2370431 | 2022-04-03 | Owsley | Kentucky | 21189 | 1573 | 24 |
2370432 | 2370432 | 2022-04-03 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2370433 | 2370433 | 2022-04-03 | Perry | Kentucky | 21193 | 10876 | 161 |
2370434 | 2370434 | 2022-04-03 | Pike | Kentucky | 21195 | 18873 | 282 |
2370435 | 2370435 | 2022-04-03 | Powell | Kentucky | 21197 | 4749 | 41 |
2370436 | 2370436 | 2022-04-03 | Pulaski | Kentucky | 21199 | 17848 | 274 |
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);