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-03-06 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2279259 | 2279259 | 2022-03-06 | Adair | Kentucky | 21001 | 5549 | 99 |
2279260 | 2279260 | 2022-03-06 | Allen | Kentucky | 21003 | 6530 | 94 |
2279261 | 2279261 | 2022-03-06 | Anderson | Kentucky | 21005 | 6225 | 65 |
2279262 | 2279262 | 2022-03-06 | Ballard | Kentucky | 21007 | 1257 | 27 |
2279263 | 2279263 | 2022-03-06 | Barren | Kentucky | 21009 | 12759 | 207 |
2279264 | 2279264 | 2022-03-06 | Bath | Kentucky | 21011 | 2916 | 38 |
2279265 | 2279265 | 2022-03-06 | Bell | Kentucky | 21013 | 8774 | 132 |
2279266 | 2279266 | 2022-03-06 | Boone | Kentucky | 21015 | 38877 | 268 |
2279267 | 2279267 | 2022-03-06 | Bourbon | Kentucky | 21017 | 5914 | 51 |
2279268 | 2279268 | 2022-03-06 | Boyd | Kentucky | 21019 | 16052 | 165 |
2279269 | 2279269 | 2022-03-06 | Boyle | Kentucky | 21021 | 8324 | 122 |
2279270 | 2279270 | 2022-03-06 | Bracken | Kentucky | 21023 | 2099 | 24 |
2279271 | 2279271 | 2022-03-06 | Breathitt | Kentucky | 21025 | 3560 | 50 |
2279272 | 2279272 | 2022-03-06 | Breckinridge | Kentucky | 21027 | 4986 | 72 |
2279273 | 2279273 | 2022-03-06 | Bullitt | Kentucky | 21029 | 20927 | 195 |
2279274 | 2279274 | 2022-03-06 | Butler | Kentucky | 21031 | 3837 | 49 |
2279275 | 2279275 | 2022-03-06 | Caldwell | Kentucky | 21033 | 4013 | 58 |
2279276 | 2279276 | 2022-03-06 | Calloway | Kentucky | 21035 | 7908 | 85 |
2279277 | 2279277 | 2022-03-06 | Campbell | Kentucky | 21037 | 24248 | 153 |
2279278 | 2279278 | 2022-03-06 | Carlisle | Kentucky | 21039 | 969 | 19 |
2279279 | 2279279 | 2022-03-06 | Carroll | Kentucky | 21041 | 3437 | 42 |
2279280 | 2279280 | 2022-03-06 | Carter | Kentucky | 21043 | 8457 | 97 |
2279281 | 2279281 | 2022-03-06 | Casey | Kentucky | 21045 | 3955 | 66 |
2279282 | 2279282 | 2022-03-06 | Christian | Kentucky | 21047 | 16048 | 196 |
2279283 | 2279283 | 2022-03-06 | Clark | Kentucky | 21049 | 9932 | 53 |
2279284 | 2279284 | 2022-03-06 | Clay | Kentucky | 21051 | 7746 | 82 |
2279285 | 2279285 | 2022-03-06 | Clinton | Kentucky | 21053 | 3393 | 43 |
2279286 | 2279286 | 2022-03-06 | Crittenden | Kentucky | 21055 | 2145 | 45 |
2279287 | 2279287 | 2022-03-06 | Cumberland | Kentucky | 21057 | 2153 | 28 |
2279288 | 2279288 | 2022-03-06 | Daviess | Kentucky | 21059 | 30831 | 359 |
2279289 | 2279289 | 2022-03-06 | Edmonson | Kentucky | 21061 | 2528 | 38 |
2279290 | 2279290 | 2022-03-06 | Elliott | Kentucky | 21063 | 2249 | 16 |
2279291 | 2279291 | 2022-03-06 | Estill | Kentucky | 21065 | 4063 | 42 |
2279292 | 2279292 | 2022-03-06 | Fayette | Kentucky | 21067 | 93315 | 555 |
2279293 | 2279293 | 2022-03-06 | Fleming | Kentucky | 21069 | 3648 | 48 |
2279294 | 2279294 | 2022-03-06 | Floyd | Kentucky | 21071 | 12296 | 159 |
2279295 | 2279295 | 2022-03-06 | Franklin | Kentucky | 21073 | 13192 | 135 |
2279296 | 2279296 | 2022-03-06 | Fulton | Kentucky | 21075 | 1151 | 24 |
2279297 | 2279297 | 2022-03-06 | Gallatin | Kentucky | 21077 | 2162 | 45 |
2279298 | 2279298 | 2022-03-06 | Garrard | Kentucky | 21079 | 4733 | 71 |
2279299 | 2279299 | 2022-03-06 | Grant | Kentucky | 21081 | 7566 | 57 |
2279300 | 2279300 | 2022-03-06 | Graves | Kentucky | 21083 | 11322 | 160 |
2279301 | 2279301 | 2022-03-06 | Grayson | Kentucky | 21085 | 8034 | 122 |
2279302 | 2279302 | 2022-03-06 | Green | Kentucky | 21087 | 3526 | 40 |
2279303 | 2279303 | 2022-03-06 | Greenup | Kentucky | 21089 | 11883 | 126 |
2279304 | 2279304 | 2022-03-06 | Hancock | Kentucky | 21091 | 2446 | 21 |
2279305 | 2279305 | 2022-03-06 | Hardin | Kentucky | 21093 | 32241 | 403 |
2279306 | 2279306 | 2022-03-06 | Harlan | Kentucky | 21095 | 9085 | 184 |
2279307 | 2279307 | 2022-03-06 | Harrison | Kentucky | 21097 | 6111 | 62 |
2279308 | 2279308 | 2022-03-06 | Hart | Kentucky | 21099 | 5341 | 94 |
2279309 | 2279309 | 2022-03-06 | Henderson | Kentucky | 21101 | 13688 | 147 |
2279310 | 2279310 | 2022-03-06 | Henry | Kentucky | 21103 | 4735 | 46 |
2279311 | 2279311 | 2022-03-06 | Hickman | Kentucky | 21105 | 818 | 23 |
2279312 | 2279312 | 2022-03-06 | Hopkins | Kentucky | 21107 | 14693 | 245 |
2279313 | 2279313 | 2022-03-06 | Jackson | Kentucky | 21109 | 4203 | 71 |
2279314 | 2279314 | 2022-03-06 | Jefferson | Kentucky | 21111 | 224863 | 2140 |
2279315 | 2279315 | 2022-03-06 | Jessamine | Kentucky | 21113 | 14976 | 130 |
2279316 | 2279316 | 2022-03-06 | Johnson | Kentucky | 21115 | 5913 | 97 |
2279317 | 2279317 | 2022-03-06 | Kenton | Kentucky | 21117 | 44872 | 370 |
2279318 | 2279318 | 2022-03-06 | Knott | Kentucky | 21119 | 4045 | 57 |
2279319 | 2279319 | 2022-03-06 | Knox | Kentucky | 21121 | 11378 | 125 |
2279320 | 2279320 | 2022-03-06 | Larue | Kentucky | 21123 | 3709 | 68 |
2279321 | 2279321 | 2022-03-06 | Laurel | Kentucky | 21125 | 18393 | 203 |
2279322 | 2279322 | 2022-03-06 | Lawrence | Kentucky | 21127 | 4475 | 59 |
2279323 | 2279323 | 2022-03-06 | Lee | Kentucky | 21129 | 2891 | 46 |
2279324 | 2279324 | 2022-03-06 | Leslie | Kentucky | 21131 | 3638 | 39 |
2279325 | 2279325 | 2022-03-06 | Letcher | Kentucky | 21133 | 6761 | 96 |
2279326 | 2279326 | 2022-03-06 | Lewis | Kentucky | 21135 | 4445 | 79 |
2279327 | 2279327 | 2022-03-06 | Lincoln | Kentucky | 21137 | 6209 | 121 |
2279328 | 2279328 | 2022-03-06 | Livingston | Kentucky | 21139 | 2328 | 58 |
2279329 | 2279329 | 2022-03-06 | Logan | Kentucky | 21141 | 8285 | 113 |
2279330 | 2279330 | 2022-03-06 | Lyon | Kentucky | 21143 | 2819 | 33 |
2279331 | 2279331 | 2022-03-06 | Madison | Kentucky | 21151 | 27461 | 251 |
2279332 | 2279332 | 2022-03-06 | Magoffin | Kentucky | 21153 | 3813 | 41 |
2279333 | 2279333 | 2022-03-06 | Marion | Kentucky | 21155 | 6342 | 75 |
2279334 | 2279334 | 2022-03-06 | Marshall | Kentucky | 21157 | 8347 | 97 |
2279335 | 2279335 | 2022-03-06 | Martin | Kentucky | 21159 | 3229 | 45 |
2279336 | 2279336 | 2022-03-06 | Mason | Kentucky | 21161 | 4558 | 97 |
2279337 | 2279337 | 2022-03-06 | McCracken | Kentucky | 21145 | 17817 | 229 |
2279338 | 2279338 | 2022-03-06 | McCreary | Kentucky | 21147 | 5145 | 74 |
2279339 | 2279339 | 2022-03-06 | McLean | Kentucky | 21149 | 2598 | 46 |
2279340 | 2279340 | 2022-03-06 | Meade | Kentucky | 21163 | 5743 | 64 |
2279341 | 2279341 | 2022-03-06 | Menifee | Kentucky | 21165 | 1509 | 30 |
2279342 | 2279342 | 2022-03-06 | Mercer | Kentucky | 21167 | 7271 | 99 |
2279343 | 2279343 | 2022-03-06 | Metcalfe | Kentucky | 21169 | 2829 | 59 |
2279344 | 2279344 | 2022-03-06 | Monroe | Kentucky | 21171 | 3603 | 74 |
2279345 | 2279345 | 2022-03-06 | Montgomery | Kentucky | 21173 | 6690 | 87 |
2279346 | 2279346 | 2022-03-06 | Morgan | Kentucky | 21175 | 4659 | 18 |
2279347 | 2279347 | 2022-03-06 | Muhlenberg | Kentucky | 21177 | 10071 | 118 |
2279348 | 2279348 | 2022-03-06 | Nelson | Kentucky | 21179 | 14286 | 140 |
2279349 | 2279349 | 2022-03-06 | Nicholas | Kentucky | 21181 | 1878 | 30 |
2279350 | 2279350 | 2022-03-06 | Ohio | Kentucky | 21183 | 7254 | 95 |
2279351 | 2279351 | 2022-03-06 | Oldham | Kentucky | 21185 | 18035 | 127 |
2279352 | 2279352 | 2022-03-06 | Owen | Kentucky | 21187 | 2350 | 32 |
2279353 | 2279353 | 2022-03-06 | Owsley | Kentucky | 21189 | 1550 | 23 |
2279354 | 2279354 | 2022-03-06 | Pendleton | Kentucky | 21191 | 3415 | 34 |
2279355 | 2279355 | 2022-03-06 | Perry | Kentucky | 21193 | 10553 | 149 |
2279356 | 2279356 | 2022-03-06 | Pike | Kentucky | 21195 | 18403 | 258 |
2279357 | 2279357 | 2022-03-06 | Powell | Kentucky | 21197 | 4693 | 38 |
2279358 | 2279358 | 2022-03-06 | Pulaski | Kentucky | 21199 | 15991 | 254 |
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);