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-08-02 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1577210 | 1577210 | 2021-08-02 | Adair | Kentucky | 21001 | 2092 | 55 |
1577211 | 1577211 | 2021-08-02 | Allen | Kentucky | 21003 | 2237 | 46 |
1577212 | 1577212 | 2021-08-02 | Anderson | Kentucky | 21005 | 1906 | 24 |
1577213 | 1577213 | 2021-08-02 | Ballard | Kentucky | 21007 | 431 | 10 |
1577214 | 1577214 | 2021-08-02 | Barren | Kentucky | 21009 | 4804 | 105 |
1577215 | 1577215 | 2021-08-02 | Bath | Kentucky | 21011 | 1083 | 24 |
1577216 | 1577216 | 2021-08-02 | Bell | Kentucky | 21013 | 3303 | 58 |
1577217 | 1577217 | 2021-08-02 | Boone | Kentucky | 21015 | 15175 | 157 |
1577218 | 1577218 | 2021-08-02 | Bourbon | Kentucky | 21017 | 1860 | 20 |
1577219 | 1577219 | 2021-08-02 | Boyd | Kentucky | 21019 | 5358 | 77 |
1577220 | 1577220 | 2021-08-02 | Boyle | Kentucky | 21021 | 3643 | 78 |
1577221 | 1577221 | 2021-08-02 | Bracken | Kentucky | 21023 | 694 | 8 |
1577222 | 1577222 | 2021-08-02 | Breathitt | Kentucky | 21025 | 1087 | 11 |
1577223 | 1577223 | 2021-08-02 | Breckinridge | Kentucky | 21027 | 1423 | 18 |
1577224 | 1577224 | 2021-08-02 | Bullitt | Kentucky | 21029 | 7822 | 83 |
1577225 | 1577225 | 2021-08-02 | Butler | Kentucky | 21031 | 1517 | 28 |
1577226 | 1577226 | 2021-08-02 | Caldwell | Kentucky | 21033 | 1529 | 32 |
1577227 | 1577227 | 2021-08-02 | Calloway | Kentucky | 21035 | 3807 | 50 |
1577228 | 1577228 | 2021-08-02 | Campbell | Kentucky | 21037 | 9184 | 84 |
1577229 | 1577229 | 2021-08-02 | Carlisle | Kentucky | 21039 | 498 | 10 |
1577230 | 1577230 | 2021-08-02 | Carroll | Kentucky | 21041 | 1074 | 21 |
1577231 | 1577231 | 2021-08-02 | Carter | Kentucky | 21043 | 2616 | 37 |
1577232 | 1577232 | 2021-08-02 | Casey | Kentucky | 21045 | 1586 | 41 |
1577233 | 1577233 | 2021-08-02 | Christian | Kentucky | 21047 | 7318 | 108 |
1577234 | 1577234 | 2021-08-02 | Clark | Kentucky | 21049 | 3256 | 32 |
1577235 | 1577235 | 2021-08-02 | Clay | Kentucky | 21051 | 3032 | 46 |
1577236 | 1577236 | 2021-08-02 | Clinton | Kentucky | 21053 | 1480 | 32 |
1577237 | 1577237 | 2021-08-02 | Crittenden | Kentucky | 21055 | 724 | 24 |
1577238 | 1577238 | 2021-08-02 | Cumberland | Kentucky | 21057 | 706 | 14 |
1577239 | 1577239 | 2021-08-02 | Daviess | Kentucky | 21059 | 11656 | 196 |
1577240 | 1577240 | 2021-08-02 | Edmonson | Kentucky | 21061 | 949 | 25 |
1577241 | 1577241 | 2021-08-02 | Elliott | Kentucky | 21063 | 1002 | 2 |
1577242 | 1577242 | 2021-08-02 | Estill | Kentucky | 21065 | 1221 | 12 |
1577243 | 1577243 | 2021-08-02 | Fayette | Kentucky | 21067 | 37892 | 323 |
1577244 | 1577244 | 2021-08-02 | Fleming | Kentucky | 21069 | 1307 | 25 |
1577245 | 1577245 | 2021-08-02 | Floyd | Kentucky | 21071 | 3843 | 74 |
1577246 | 1577246 | 2021-08-02 | Franklin | Kentucky | 21073 | 4400 | 60 |
1577247 | 1577247 | 2021-08-02 | Fulton | Kentucky | 21075 | 557 | 16 |
1577248 | 1577248 | 2021-08-02 | Gallatin | Kentucky | 21077 | 775 | 33 |
1577249 | 1577249 | 2021-08-02 | Garrard | Kentucky | 21079 | 1619 | 37 |
1577250 | 1577250 | 2021-08-02 | Grant | Kentucky | 21081 | 2715 | 24 |
1577251 | 1577251 | 2021-08-02 | Graves | Kentucky | 21083 | 4598 | 99 |
1577252 | 1577252 | 2021-08-02 | Grayson | Kentucky | 21085 | 2373 | 58 |
1577253 | 1577253 | 2021-08-02 | Green | Kentucky | 21087 | 1308 | 18 |
1577254 | 1577254 | 2021-08-02 | Greenup | Kentucky | 21089 | 3937 | 63 |
1577255 | 1577255 | 2021-08-02 | Hancock | Kentucky | 21091 | 941 | 16 |
1577256 | 1577256 | 2021-08-02 | Hardin | Kentucky | 21093 | 10629 | 172 |
1577257 | 1577257 | 2021-08-02 | Harlan | Kentucky | 21095 | 3065 | 93 |
1577258 | 1577258 | 2021-08-02 | Harrison | Kentucky | 21097 | 1879 | 27 |
1577259 | 1577259 | 2021-08-02 | Hart | Kentucky | 21099 | 2218 | 55 |
1577260 | 1577260 | 2021-08-02 | Henderson | Kentucky | 21101 | 5322 | 79 |
1577261 | 1577261 | 2021-08-02 | Henry | Kentucky | 21103 | 1473 | 20 |
1577262 | 1577262 | 2021-08-02 | Hickman | Kentucky | 21105 | 407 | 16 |
1577263 | 1577263 | 2021-08-02 | Hopkins | Kentucky | 21107 | 5197 | 154 |
1577264 | 1577264 | 2021-08-02 | Jackson | Kentucky | 21109 | 1482 | 32 |
1577265 | 1577265 | 2021-08-02 | Jefferson | Kentucky | 21111 | 85706 | 1347 |
1577266 | 1577266 | 2021-08-02 | Jessamine | Kentucky | 21113 | 4946 | 75 |
1577267 | 1577267 | 2021-08-02 | Johnson | Kentucky | 21115 | 2215 | 37 |
1577268 | 1577268 | 2021-08-02 | Kenton | Kentucky | 21117 | 17697 | 216 |
1577269 | 1577269 | 2021-08-02 | Knott | Kentucky | 21119 | 1268 | 25 |
1577270 | 1577270 | 2021-08-02 | Knox | Kentucky | 21121 | 4098 | 47 |
1577271 | 1577271 | 2021-08-02 | Larue | Kentucky | 21123 | 1427 | 29 |
1577272 | 1577272 | 2021-08-02 | Laurel | Kentucky | 21125 | 8228 | 82 |
1577273 | 1577273 | 2021-08-02 | Lawrence | Kentucky | 21127 | 1543 | 29 |
1577274 | 1577274 | 2021-08-02 | Lee | Kentucky | 21129 | 1318 | 26 |
1577275 | 1577275 | 2021-08-02 | Leslie | Kentucky | 21131 | 1018 | 9 |
1577276 | 1577276 | 2021-08-02 | Letcher | Kentucky | 21133 | 2185 | 47 |
1577277 | 1577277 | 2021-08-02 | Lewis | Kentucky | 21135 | 1466 | 41 |
1577278 | 1577278 | 2021-08-02 | Lincoln | Kentucky | 21137 | 2532 | 61 |
1577279 | 1577279 | 2021-08-02 | Livingston | Kentucky | 21139 | 942 | 25 |
1577280 | 1577280 | 2021-08-02 | Logan | Kentucky | 21141 | 3133 | 74 |
1577281 | 1577281 | 2021-08-02 | Lyon | Kentucky | 21143 | 1575 | 22 |
1577282 | 1577282 | 2021-08-02 | Madison | Kentucky | 21151 | 9999 | 113 |
1577283 | 1577283 | 2021-08-02 | Magoffin | Kentucky | 21153 | 1063 | 18 |
1577284 | 1577284 | 2021-08-02 | Marion | Kentucky | 21155 | 2468 | 39 |
1577285 | 1577285 | 2021-08-02 | Marshall | Kentucky | 21157 | 3106 | 63 |
1577286 | 1577286 | 2021-08-02 | Martin | Kentucky | 21159 | 1120 | 20 |
1577287 | 1577287 | 2021-08-02 | Mason | Kentucky | 21161 | 1811 | 40 |
1577288 | 1577288 | 2021-08-02 | McCracken | Kentucky | 21145 | 7212 | 135 |
1577289 | 1577289 | 2021-08-02 | McCreary | Kentucky | 21147 | 2062 | 34 |
1577290 | 1577290 | 2021-08-02 | McLean | Kentucky | 21149 | 942 | 28 |
1577291 | 1577291 | 2021-08-02 | Meade | Kentucky | 21163 | 2200 | 27 |
1577292 | 1577292 | 2021-08-02 | Menifee | Kentucky | 21165 | 497 | 17 |
1577293 | 1577293 | 2021-08-02 | Mercer | Kentucky | 21167 | 2739 | 54 |
1577294 | 1577294 | 2021-08-02 | Metcalfe | Kentucky | 21169 | 1140 | 31 |
1577295 | 1577295 | 2021-08-02 | Monroe | Kentucky | 21171 | 1378 | 44 |
1577296 | 1577296 | 2021-08-02 | Montgomery | Kentucky | 21173 | 2951 | 30 |
1577297 | 1577297 | 2021-08-02 | Morgan | Kentucky | 21175 | 2344 | 5 |
1577298 | 1577298 | 2021-08-02 | Muhlenberg | Kentucky | 21177 | 3451 | 70 |
1577299 | 1577299 | 2021-08-02 | Nelson | Kentucky | 21179 | 5258 | 63 |
1577300 | 1577300 | 2021-08-02 | Nicholas | Kentucky | 21181 | 619 | 9 |
1577301 | 1577301 | 2021-08-02 | Ohio | Kentucky | 21183 | 2680 | 55 |
1577302 | 1577302 | 2021-08-02 | Oldham | Kentucky | 21185 | 7932 | 85 |
1577303 | 1577303 | 2021-08-02 | Owen | Kentucky | 21187 | 779 | 13 |
1577304 | 1577304 | 2021-08-02 | Owsley | Kentucky | 21189 | 523 | 16 |
1577305 | 1577305 | 2021-08-02 | Pendleton | Kentucky | 21191 | 1101 | 4 |
1577306 | 1577306 | 2021-08-02 | Perry | Kentucky | 21193 | 2963 | 66 |
1577307 | 1577307 | 2021-08-02 | Pike | Kentucky | 21195 | 6214 | 113 |
1577308 | 1577308 | 2021-08-02 | Powell | Kentucky | 21197 | 1380 | 13 |
1577309 | 1577309 | 2021-08-02 | Pulaski | Kentucky | 21199 | 7082 | 124 |
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);