ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-12-21" 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 |
---|---|---|---|---|---|---|---|
2035365 | 2035365 | 2021-12-21 | Adair | Kentucky | 21001 | 3890 | 88 |
2035366 | 2035366 | 2021-12-21 | Allen | Kentucky | 21003 | 4224 | 79 |
2035367 | 2035367 | 2021-12-21 | Anderson | Kentucky | 21005 | 4042 | 56 |
2035368 | 2035368 | 2021-12-21 | Ballard | Kentucky | 21007 | 819 | 25 |
2035369 | 2035369 | 2021-12-21 | Barren | Kentucky | 21009 | 9045 | 176 |
2035370 | 2035370 | 2021-12-21 | Bath | Kentucky | 21011 | 1981 | 34 |
2035371 | 2035371 | 2021-12-21 | Bell | Kentucky | 21013 | 6146 | 117 |
2035372 | 2035372 | 2021-12-21 | Boone | Kentucky | 21015 | 24480 | 229 |
2035373 | 2035373 | 2021-12-21 | Bourbon | Kentucky | 21017 | 3727 | 42 |
2035374 | 2035374 | 2021-12-21 | Boyd | Kentucky | 21019 | 9794 | 126 |
2035375 | 2035375 | 2021-12-21 | Boyle | Kentucky | 21021 | 5830 | 114 |
2035376 | 2035376 | 2021-12-21 | Bracken | Kentucky | 21023 | 1426 | 20 |
2035377 | 2035377 | 2021-12-21 | Breathitt | Kentucky | 21025 | 2225 | 46 |
2035378 | 2035378 | 2021-12-21 | Breckinridge | Kentucky | 21027 | 3379 | 49 |
2035379 | 2035379 | 2021-12-21 | Bullitt | Kentucky | 21029 | 13566 | 156 |
2035380 | 2035380 | 2021-12-21 | Butler | Kentucky | 21031 | 2606 | 43 |
2035381 | 2035381 | 2021-12-21 | Caldwell | Kentucky | 21033 | 2639 | 53 |
2035382 | 2035382 | 2021-12-21 | Calloway | Kentucky | 21035 | 5527 | 67 |
2035383 | 2035383 | 2021-12-21 | Campbell | Kentucky | 21037 | 15124 | 123 |
2035384 | 2035384 | 2021-12-21 | Carlisle | Kentucky | 21039 | 726 | 12 |
2035385 | 2035385 | 2021-12-21 | Carroll | Kentucky | 21041 | 2290 | 34 |
2035386 | 2035386 | 2021-12-21 | Carter | Kentucky | 21043 | 5289 | 74 |
2035387 | 2035387 | 2021-12-21 | Casey | Kentucky | 21045 | 3050 | 64 |
2035388 | 2035388 | 2021-12-21 | Christian | Kentucky | 21047 | 11099 | 173 |
2035389 | 2035389 | 2021-12-21 | Clark | Kentucky | 21049 | 6088 | 48 |
2035390 | 2035390 | 2021-12-21 | Clay | Kentucky | 21051 | 5303 | 65 |
2035391 | 2035391 | 2021-12-21 | Clinton | Kentucky | 21053 | 2524 | 41 |
2035392 | 2035392 | 2021-12-21 | Crittenden | Kentucky | 21055 | 1422 | 37 |
2035393 | 2035393 | 2021-12-21 | Cumberland | Kentucky | 21057 | 1488 | 22 |
2035394 | 2035394 | 2021-12-21 | Daviess | Kentucky | 21059 | 19595 | 304 |
2035395 | 2035395 | 2021-12-21 | Edmonson | Kentucky | 21061 | 1707 | 34 |
2035396 | 2035396 | 2021-12-21 | Elliott | Kentucky | 21063 | 1473 | 13 |
2035397 | 2035397 | 2021-12-21 | Estill | Kentucky | 21065 | 2611 | 37 |
2035398 | 2035398 | 2021-12-21 | Fayette | Kentucky | 21067 | 56340 | 467 |
2035399 | 2035399 | 2021-12-21 | Fleming | Kentucky | 21069 | 2529 | 41 |
2035400 | 2035400 | 2021-12-21 | Floyd | Kentucky | 21071 | 7931 | 144 |
2035401 | 2035401 | 2021-12-21 | Franklin | Kentucky | 21073 | 8174 | 110 |
2035402 | 2035402 | 2021-12-21 | Fulton | Kentucky | 21075 | 866 | 22 |
2035403 | 2035403 | 2021-12-21 | Gallatin | Kentucky | 21077 | 1439 | 44 |
2035404 | 2035404 | 2021-12-21 | Garrard | Kentucky | 21079 | 3119 | 56 |
2035405 | 2035405 | 2021-12-21 | Grant | Kentucky | 21081 | 5294 | 46 |
2035406 | 2035406 | 2021-12-21 | Graves | Kentucky | 21083 | 7813 | 135 |
2035407 | 2035407 | 2021-12-21 | Grayson | Kentucky | 21085 | 5280 | 101 |
2035408 | 2035408 | 2021-12-21 | Green | Kentucky | 21087 | 2629 | 39 |
2035409 | 2035409 | 2021-12-21 | Greenup | Kentucky | 21089 | 7414 | 105 |
2035410 | 2035410 | 2021-12-21 | Hancock | Kentucky | 21091 | 1632 | 19 |
2035411 | 2035411 | 2021-12-21 | Hardin | Kentucky | 21093 | 20405 | 337 |
2035412 | 2035412 | 2021-12-21 | Harlan | Kentucky | 21095 | 6208 | 152 |
2035413 | 2035413 | 2021-12-21 | Harrison | Kentucky | 21097 | 3892 | 56 |
2035414 | 2035414 | 2021-12-21 | Hart | Kentucky | 21099 | 3937 | 77 |
2035415 | 2035415 | 2021-12-21 | Henderson | Kentucky | 21101 | 8829 | 131 |
2035416 | 2035416 | 2021-12-21 | Henry | Kentucky | 21103 | 3047 | 36 |
2035417 | 2035417 | 2021-12-21 | Hickman | Kentucky | 21105 | 598 | 22 |
2035418 | 2035418 | 2021-12-21 | Hopkins | Kentucky | 21107 | 9342 | 219 |
2035419 | 2035419 | 2021-12-21 | Jackson | Kentucky | 21109 | 3015 | 58 |
2035420 | 2035420 | 2021-12-21 | Jefferson | Kentucky | 21111 | 132829 | 1797 |
2035421 | 2035421 | 2021-12-21 | Jessamine | Kentucky | 21113 | 9171 | 110 |
2035422 | 2035422 | 2021-12-21 | Johnson | Kentucky | 21115 | 4101 | 75 |
2035423 | 2035423 | 2021-12-21 | Kenton | Kentucky | 21117 | 28821 | 308 |
2035424 | 2035424 | 2021-12-21 | Knott | Kentucky | 21119 | 2618 | 46 |
2035425 | 2035425 | 2021-12-21 | Knox | Kentucky | 21121 | 7889 | 105 |
2035426 | 2035426 | 2021-12-21 | Larue | Kentucky | 21123 | 2573 | 56 |
2035427 | 2035427 | 2021-12-21 | Laurel | Kentucky | 21125 | 13822 | 175 |
2035428 | 2035428 | 2021-12-21 | Lawrence | Kentucky | 21127 | 3115 | 47 |
2035429 | 2035429 | 2021-12-21 | Lee | Kentucky | 21129 | 1867 | 40 |
2035430 | 2035430 | 2021-12-21 | Leslie | Kentucky | 21131 | 2407 | 35 |
2035431 | 2035431 | 2021-12-21 | Letcher | Kentucky | 21133 | 4414 | 83 |
2035432 | 2035432 | 2021-12-21 | Lewis | Kentucky | 21135 | 3015 | 66 |
2035433 | 2035433 | 2021-12-21 | Lincoln | Kentucky | 21137 | 4638 | 105 |
2035434 | 2035434 | 2021-12-21 | Livingston | Kentucky | 21139 | 1616 | 49 |
2035435 | 2035435 | 2021-12-21 | Logan | Kentucky | 21141 | 5501 | 97 |
2035436 | 2035436 | 2021-12-21 | Lyon | Kentucky | 21143 | 2088 | 29 |
2035437 | 2035437 | 2021-12-21 | Madison | Kentucky | 21151 | 18191 | 212 |
2035438 | 2035438 | 2021-12-21 | Magoffin | Kentucky | 21153 | 2583 | 34 |
2035439 | 2035439 | 2021-12-21 | Marion | Kentucky | 21155 | 4392 | 61 |
2035440 | 2035440 | 2021-12-21 | Marshall | Kentucky | 21157 | 5435 | 85 |
2035441 | 2035441 | 2021-12-21 | Martin | Kentucky | 21159 | 2182 | 39 |
2035442 | 2035442 | 2021-12-21 | Mason | Kentucky | 21161 | 2971 | 81 |
2035443 | 2035443 | 2021-12-21 | McCracken | Kentucky | 21145 | 11430 | 202 |
2035444 | 2035444 | 2021-12-21 | McCreary | Kentucky | 21147 | 4095 | 68 |
2035445 | 2035445 | 2021-12-21 | McLean | Kentucky | 21149 | 1722 | 40 |
2035446 | 2035446 | 2021-12-21 | Meade | Kentucky | 21163 | 3805 | 50 |
2035447 | 2035447 | 2021-12-21 | Menifee | Kentucky | 21165 | 1071 | 26 |
2035448 | 2035448 | 2021-12-21 | Mercer | Kentucky | 21167 | 4868 | 93 |
2035449 | 2035449 | 2021-12-21 | Metcalfe | Kentucky | 21169 | 2160 | 49 |
2035450 | 2035450 | 2021-12-21 | Monroe | Kentucky | 21171 | 2592 | 67 |
2035451 | 2035451 | 2021-12-21 | Montgomery | Kentucky | 21173 | 4960 | 71 |
2035452 | 2035452 | 2021-12-21 | Morgan | Kentucky | 21175 | 3177 | 17 |
2035453 | 2035453 | 2021-12-21 | Muhlenberg | Kentucky | 21177 | 6276 | 99 |
2035454 | 2035454 | 2021-12-21 | Nelson | Kentucky | 21179 | 9399 | 108 |
2035455 | 2035455 | 2021-12-21 | Nicholas | Kentucky | 21181 | 1323 | 27 |
2035456 | 2035456 | 2021-12-21 | Ohio | Kentucky | 21183 | 4909 | 89 |
2035457 | 2035457 | 2021-12-21 | Oldham | Kentucky | 21185 | 11395 | 112 |
2035458 | 2035458 | 2021-12-21 | Owen | Kentucky | 21187 | 1646 | 29 |
2035459 | 2035459 | 2021-12-21 | Owsley | Kentucky | 21189 | 1050 | 22 |
2035460 | 2035460 | 2021-12-21 | Pendleton | Kentucky | 21191 | 2309 | 29 |
2035461 | 2035461 | 2021-12-21 | Perry | Kentucky | 21193 | 6760 | 129 |
2035462 | 2035462 | 2021-12-21 | Pike | Kentucky | 21195 | 11837 | 222 |
2035463 | 2035463 | 2021-12-21 | Powell | Kentucky | 21197 | 3046 | 28 |
2035464 | 2035464 | 2021-12-21 | Pulaski | Kentucky | 21199 | 12451 | 222 |
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);