ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-11-27" 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 |
---|---|---|---|---|---|---|---|
772153 | 772153 | 2020-11-27 | Adair | Kentucky | 21001 | 957 | 30 |
772154 | 772154 | 2020-11-27 | Allen | Kentucky | 21003 | 715 | 15 |
772155 | 772155 | 2020-11-27 | Anderson | Kentucky | 21005 | 495 | 1 |
772156 | 772156 | 2020-11-27 | Ballard | Kentucky | 21007 | 140 | 2 |
772157 | 772157 | 2020-11-27 | Barren | Kentucky | 21009 | 1947 | 27 |
772158 | 772158 | 2020-11-27 | Bath | Kentucky | 21011 | 264 | 1 |
772159 | 772159 | 2020-11-27 | Bell | Kentucky | 21013 | 1223 | 19 |
772160 | 772160 | 2020-11-27 | Boone | Kentucky | 21015 | 4452 | 29 |
772161 | 772161 | 2020-11-27 | Bourbon | Kentucky | 21017 | 530 | 1 |
772162 | 772162 | 2020-11-27 | Boyd | Kentucky | 21019 | 1657 | 24 |
772163 | 772163 | 2020-11-27 | Boyle | Kentucky | 21021 | 910 | 0 |
772164 | 772164 | 2020-11-27 | Bracken | Kentucky | 21023 | 143 | 3 |
772165 | 772165 | 2020-11-27 | Breathitt | Kentucky | 21025 | 336 | 3 |
772166 | 772166 | 2020-11-27 | Breckinridge | Kentucky | 21027 | 429 | 4 |
772167 | 772167 | 2020-11-27 | Bullitt | Kentucky | 21029 | 2773 | 22 |
772168 | 772168 | 2020-11-27 | Butler | Kentucky | 21031 | 571 | 16 |
772169 | 772169 | 2020-11-27 | Caldwell | Kentucky | 21033 | 549 | 1 |
772170 | 772170 | 2020-11-27 | Calloway | Kentucky | 21035 | 1706 | 16 |
772171 | 772171 | 2020-11-27 | Campbell | Kentucky | 21037 | 2738 | 21 |
772172 | 772172 | 2020-11-27 | Carlisle | Kentucky | 21039 | 197 | 1 |
772173 | 772173 | 2020-11-27 | Carroll | Kentucky | 21041 | 338 | 6 |
772174 | 772174 | 2020-11-27 | Carter | Kentucky | 21043 | 720 | 5 |
772175 | 772175 | 2020-11-27 | Casey | Kentucky | 21045 | 609 | 19 |
772176 | 772176 | 2020-11-27 | Christian | Kentucky | 21047 | 2916 | 45 |
772177 | 772177 | 2020-11-27 | Clark | Kentucky | 21049 | 901 | 12 |
772178 | 772178 | 2020-11-27 | Clay | Kentucky | 21051 | 972 | 8 |
772179 | 772179 | 2020-11-27 | Clinton | Kentucky | 21053 | 481 | 14 |
772180 | 772180 | 2020-11-27 | Crittenden | Kentucky | 21055 | 242 | 1 |
772181 | 772181 | 2020-11-27 | Cumberland | Kentucky | 21057 | 296 | 2 |
772182 | 772182 | 2020-11-27 | Daviess | Kentucky | 21059 | 3326 | 48 |
772183 | 772183 | 2020-11-27 | Edmonson | Kentucky | 21061 | 374 | 13 |
772184 | 772184 | 2020-11-27 | Elliott | Kentucky | 21063 | 588 | 0 |
772185 | 772185 | 2020-11-27 | Estill | Kentucky | 21065 | 450 | 0 |
772186 | 772186 | 2020-11-27 | Fayette | Kentucky | 21067 | 16703 | 112 |
772187 | 772187 | 2020-11-27 | Fleming | Kentucky | 21069 | 342 | 0 |
772188 | 772188 | 2020-11-27 | Floyd | Kentucky | 21071 | 1188 | 7 |
772189 | 772189 | 2020-11-27 | Franklin | Kentucky | 21073 | 1375 | 14 |
772190 | 772190 | 2020-11-27 | Fulton | Kentucky | 21075 | 291 | 3 |
772191 | 772191 | 2020-11-27 | Gallatin | Kentucky | 21077 | 224 | 9 |
772192 | 772192 | 2020-11-27 | Garrard | Kentucky | 21079 | 566 | 4 |
772193 | 772193 | 2020-11-27 | Grant | Kentucky | 21081 | 620 | 6 |
772194 | 772194 | 2020-11-27 | Graves | Kentucky | 21083 | 1771 | 36 |
772195 | 772195 | 2020-11-27 | Grayson | Kentucky | 21085 | 915 | 19 |
772196 | 772196 | 2020-11-27 | Green | Kentucky | 21087 | 571 | 10 |
772197 | 772197 | 2020-11-27 | Greenup | Kentucky | 21089 | 1331 | 12 |
772198 | 772198 | 2020-11-27 | Hancock | Kentucky | 21091 | 298 | 11 |
772199 | 772199 | 2020-11-27 | Hardin | Kentucky | 21093 | 4078 | 36 |
772200 | 772200 | 2020-11-27 | Harlan | Kentucky | 21095 | 877 | 15 |
772201 | 772201 | 2020-11-27 | Harrison | Kentucky | 21097 | 460 | 1 |
772202 | 772202 | 2020-11-27 | Hart | Kentucky | 21099 | 753 | 3 |
772203 | 772203 | 2020-11-27 | Henderson | Kentucky | 21101 | 2006 | 39 |
772204 | 772204 | 2020-11-27 | Henry | Kentucky | 21103 | 488 | 3 |
772205 | 772205 | 2020-11-27 | Hickman | Kentucky | 21105 | 150 | 2 |
772206 | 772206 | 2020-11-27 | Hopkins | Kentucky | 21107 | 1786 | 51 |
772207 | 772207 | 2020-11-27 | Jackson | Kentucky | 21109 | 645 | 17 |
772208 | 772208 | 2020-11-27 | Jefferson | Kentucky | 21111 | 36666 | 499 |
772209 | 772209 | 2020-11-27 | Jessamine | Kentucky | 21113 | 1722 | 30 |
772210 | 772210 | 2020-11-27 | Johnson | Kentucky | 21115 | 733 | 4 |
772211 | 772211 | 2020-11-27 | Kenton | Kentucky | 21117 | 5213 | 63 |
772212 | 772212 | 2020-11-27 | Knott | Kentucky | 21119 | 554 | 9 |
772213 | 772213 | 2020-11-27 | Knox | Kentucky | 21121 | 1192 | 10 |
772214 | 772214 | 2020-11-27 | Larue | Kentucky | 21123 | 606 | 2 |
772215 | 772215 | 2020-11-27 | Laurel | Kentucky | 21125 | 2343 | 11 |
772216 | 772216 | 2020-11-27 | Lawrence | Kentucky | 21127 | 381 | 1 |
772217 | 772217 | 2020-11-27 | Lee | Kentucky | 21129 | 903 | 15 |
772218 | 772218 | 2020-11-27 | Leslie | Kentucky | 21131 | 256 | 1 |
772219 | 772219 | 2020-11-27 | Letcher | Kentucky | 21133 | 503 | 2 |
772220 | 772220 | 2020-11-27 | Lewis | Kentucky | 21135 | 465 | 20 |
772221 | 772221 | 2020-11-27 | Lincoln | Kentucky | 21137 | 641 | 20 |
772222 | 772222 | 2020-11-27 | Livingston | Kentucky | 21139 | 278 | 3 |
772223 | 772223 | 2020-11-27 | Logan | Kentucky | 21141 | 1208 | 33 |
772224 | 772224 | 2020-11-27 | Lyon | Kentucky | 21143 | 195 | 5 |
772225 | 772225 | 2020-11-27 | Madison | Kentucky | 21151 | 3789 | 18 |
772226 | 772226 | 2020-11-27 | Magoffin | Kentucky | 21153 | 458 | 1 |
772227 | 772227 | 2020-11-27 | Marion | Kentucky | 21155 | 947 | 12 |
772228 | 772228 | 2020-11-27 | Marshall | Kentucky | 21157 | 912 | 11 |
772229 | 772229 | 2020-11-27 | Martin | Kentucky | 21159 | 410 | 8 |
772230 | 772230 | 2020-11-27 | Mason | Kentucky | 21161 | 401 | 2 |
772231 | 772231 | 2020-11-27 | McCracken | Kentucky | 21145 | 2630 | 20 |
772232 | 772232 | 2020-11-27 | McCreary | Kentucky | 21147 | 499 | 1 |
772233 | 772233 | 2020-11-27 | McLean | Kentucky | 21149 | 371 | 16 |
772234 | 772234 | 2020-11-27 | Meade | Kentucky | 21163 | 743 | 4 |
772235 | 772235 | 2020-11-27 | Menifee | Kentucky | 21165 | 120 | 1 |
772236 | 772236 | 2020-11-27 | Mercer | Kentucky | 21167 | 685 | 6 |
772237 | 772237 | 2020-11-27 | Metcalfe | Kentucky | 21169 | 378 | 3 |
772238 | 772238 | 2020-11-27 | Monroe | Kentucky | 21171 | 691 | 13 |
772239 | 772239 | 2020-11-27 | Montgomery | Kentucky | 21173 | 880 | 9 |
772240 | 772240 | 2020-11-27 | Morgan | Kentucky | 21175 | 316 | 0 |
772241 | 772241 | 2020-11-27 | Muhlenberg | Kentucky | 21177 | 1399 | 20 |
772242 | 772242 | 2020-11-27 | Nelson | Kentucky | 21179 | 2078 | 9 |
772243 | 772243 | 2020-11-27 | Nicholas | Kentucky | 21181 | 169 | 3 |
772244 | 772244 | 2020-11-27 | Ohio | Kentucky | 21183 | 947 | 16 |
772245 | 772245 | 2020-11-27 | Oldham | Kentucky | 21185 | 2367 | 33 |
772246 | 772246 | 2020-11-27 | Owen | Kentucky | 21187 | 189 | 3 |
772247 | 772247 | 2020-11-27 | Owsley | Kentucky | 21189 | 223 | 1 |
772248 | 772248 | 2020-11-27 | Pendleton | Kentucky | 21191 | 359 | 1 |
772249 | 772249 | 2020-11-27 | Perry | Kentucky | 21193 | 938 | 11 |
772250 | 772250 | 2020-11-27 | Pike | Kentucky | 21195 | 1779 | 22 |
772251 | 772251 | 2020-11-27 | Powell | Kentucky | 21197 | 479 | 0 |
772252 | 772252 | 2020-11-27 | Pulaski | Kentucky | 21199 | 2107 | 17 |
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);