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 2020-10-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 |
---|---|---|---|---|---|---|---|
652114 | 652114 | 2020-10-21 | Adair | Kentucky | 21001 | 485 | 22 |
652115 | 652115 | 2020-10-21 | Allen | Kentucky | 21003 | 504 | 11 |
652116 | 652116 | 2020-10-21 | Anderson | Kentucky | 21005 | 231 | 1 |
652117 | 652117 | 2020-10-21 | Ballard | Kentucky | 21007 | 69 | 1 |
652118 | 652118 | 2020-10-21 | Barren | Kentucky | 21009 | 1015 | 13 |
652119 | 652119 | 2020-10-21 | Bath | Kentucky | 21011 | 106 | 1 |
652120 | 652120 | 2020-10-21 | Bell | Kentucky | 21013 | 631 | 17 |
652121 | 652121 | 2020-10-21 | Boone | Kentucky | 21015 | 1986 | 25 |
652122 | 652122 | 2020-10-21 | Bourbon | Kentucky | 21017 | 301 | 1 |
652123 | 652123 | 2020-10-21 | Boyd | Kentucky | 21019 | 612 | 20 |
652124 | 652124 | 2020-10-21 | Boyle | Kentucky | 21021 | 416 | 0 |
652125 | 652125 | 2020-10-21 | Bracken | Kentucky | 21023 | 59 | 1 |
652126 | 652126 | 2020-10-21 | Breathitt | Kentucky | 21025 | 114 | 0 |
652127 | 652127 | 2020-10-21 | Breckinridge | Kentucky | 21027 | 183 | 2 |
652128 | 652128 | 2020-10-21 | Bullitt | Kentucky | 21029 | 1286 | 14 |
652129 | 652129 | 2020-10-21 | Butler | Kentucky | 21031 | 410 | 16 |
652130 | 652130 | 2020-10-21 | Caldwell | Kentucky | 21033 | 240 | 0 |
652131 | 652131 | 2020-10-21 | Calloway | Kentucky | 21035 | 868 | 9 |
652132 | 652132 | 2020-10-21 | Campbell | Kentucky | 21037 | 1113 | 19 |
652133 | 652133 | 2020-10-21 | Carlisle | Kentucky | 21039 | 101 | 1 |
652134 | 652134 | 2020-10-21 | Carroll | Kentucky | 21041 | 214 | 5 |
652135 | 652135 | 2020-10-21 | Carter | Kentucky | 21043 | 312 | 4 |
652136 | 652136 | 2020-10-21 | Casey | Kentucky | 21045 | 311 | 16 |
652137 | 652137 | 2020-10-21 | Christian | Kentucky | 21047 | 1806 | 28 |
652138 | 652138 | 2020-10-21 | Clark | Kentucky | 21049 | 455 | 11 |
652139 | 652139 | 2020-10-21 | Clay | Kentucky | 21051 | 451 | 6 |
652140 | 652140 | 2020-10-21 | Clinton | Kentucky | 21053 | 225 | 4 |
652141 | 652141 | 2020-10-21 | Crittenden | Kentucky | 21055 | 154 | 1 |
652142 | 652142 | 2020-10-21 | Cumberland | Kentucky | 21057 | 133 | 0 |
652143 | 652143 | 2020-10-21 | Daviess | Kentucky | 21059 | 1837 | 28 |
652144 | 652144 | 2020-10-21 | Edmonson | Kentucky | 21061 | 188 | 12 |
652145 | 652145 | 2020-10-21 | Elliott | Kentucky | 21063 | 101 | 0 |
652146 | 652146 | 2020-10-21 | Estill | Kentucky | 21065 | 252 | 0 |
652147 | 652147 | 2020-10-21 | Fayette | Kentucky | 21067 | 10076 | 91 |
652148 | 652148 | 2020-10-21 | Fleming | Kentucky | 21069 | 147 | 0 |
652149 | 652149 | 2020-10-21 | Floyd | Kentucky | 21071 | 301 | 4 |
652150 | 652150 | 2020-10-21 | Franklin | Kentucky | 21073 | 809 | 14 |
652151 | 652151 | 2020-10-21 | Fulton | Kentucky | 21075 | 224 | 3 |
652152 | 652152 | 2020-10-21 | Gallatin | Kentucky | 21077 | 121 | 8 |
652153 | 652153 | 2020-10-21 | Garrard | Kentucky | 21079 | 269 | 3 |
652154 | 652154 | 2020-10-21 | Grant | Kentucky | 21081 | 222 | 6 |
652155 | 652155 | 2020-10-21 | Graves | Kentucky | 21083 | 854 | 29 |
652156 | 652156 | 2020-10-21 | Grayson | Kentucky | 21085 | 472 | 15 |
652157 | 652157 | 2020-10-21 | Green | Kentucky | 21087 | 334 | 9 |
652158 | 652158 | 2020-10-21 | Greenup | Kentucky | 21089 | 580 | 8 |
652159 | 652159 | 2020-10-21 | Hancock | Kentucky | 21091 | 124 | 1 |
652160 | 652160 | 2020-10-21 | Hardin | Kentucky | 21093 | 1788 | 15 |
652161 | 652161 | 2020-10-21 | Harlan | Kentucky | 21095 | 565 | 13 |
652162 | 652162 | 2020-10-21 | Harrison | Kentucky | 21097 | 249 | 1 |
652163 | 652163 | 2020-10-21 | Hart | Kentucky | 21099 | 309 | 1 |
652164 | 652164 | 2020-10-21 | Henderson | Kentucky | 21101 | 1229 | 28 |
652165 | 652165 | 2020-10-21 | Henry | Kentucky | 21103 | 245 | 2 |
652166 | 652166 | 2020-10-21 | Hickman | Kentucky | 21105 | 104 | 1 |
652167 | 652167 | 2020-10-21 | Hopkins | Kentucky | 21107 | 964 | 43 |
652168 | 652168 | 2020-10-21 | Jackson | Kentucky | 21109 | 424 | 17 |
652169 | 652169 | 2020-10-21 | Jefferson | Kentucky | 21111 | 21803 | 370 |
652170 | 652170 | 2020-10-21 | Jessamine | Kentucky | 21113 | 895 | 6 |
652171 | 652171 | 2020-10-21 | Johnson | Kentucky | 21115 | 269 | 2 |
652172 | 652172 | 2020-10-21 | Kenton | Kentucky | 21117 | 2455 | 49 |
652173 | 652173 | 2020-10-21 | Knott | Kentucky | 21119 | 303 | 2 |
652174 | 652174 | 2020-10-21 | Knox | Kentucky | 21121 | 766 | 9 |
652175 | 652175 | 2020-10-21 | Larue | Kentucky | 21123 | 266 | 1 |
652176 | 652176 | 2020-10-21 | Laurel | Kentucky | 21125 | 1307 | 7 |
652177 | 652177 | 2020-10-21 | Lawrence | Kentucky | 21127 | 131 | 0 |
652178 | 652178 | 2020-10-21 | Lee | Kentucky | 21129 | 48 | 0 |
652179 | 652179 | 2020-10-21 | Leslie | Kentucky | 21131 | 121 | 0 |
652180 | 652180 | 2020-10-21 | Letcher | Kentucky | 21133 | 286 | 2 |
652181 | 652181 | 2020-10-21 | Lewis | Kentucky | 21135 | 266 | 15 |
652182 | 652182 | 2020-10-21 | Lincoln | Kentucky | 21137 | 291 | 18 |
652183 | 652183 | 2020-10-21 | Livingston | Kentucky | 21139 | 121 | 1 |
652184 | 652184 | 2020-10-21 | Logan | Kentucky | 21141 | 728 | 30 |
652185 | 652185 | 2020-10-21 | Lyon | Kentucky | 21143 | 98 | 4 |
652186 | 652186 | 2020-10-21 | Madison | Kentucky | 21151 | 2217 | 13 |
652187 | 652187 | 2020-10-21 | Magoffin | Kentucky | 21153 | 148 | 0 |
652188 | 652188 | 2020-10-21 | Marion | Kentucky | 21155 | 370 | 10 |
652189 | 652189 | 2020-10-21 | Marshall | Kentucky | 21157 | 433 | 6 |
652190 | 652190 | 2020-10-21 | Martin | Kentucky | 21159 | 148 | 3 |
652191 | 652191 | 2020-10-21 | Mason | Kentucky | 21161 | 160 | 2 |
652192 | 652192 | 2020-10-21 | McCracken | Kentucky | 21145 | 994 | 11 |
652193 | 652193 | 2020-10-21 | McCreary | Kentucky | 21147 | 252 | 1 |
652194 | 652194 | 2020-10-21 | McLean | Kentucky | 21149 | 159 | 2 |
652195 | 652195 | 2020-10-21 | Meade | Kentucky | 21163 | 382 | 3 |
652196 | 652196 | 2020-10-21 | Menifee | Kentucky | 21165 | 76 | 1 |
652197 | 652197 | 2020-10-21 | Mercer | Kentucky | 21167 | 327 | 6 |
652198 | 652198 | 2020-10-21 | Metcalfe | Kentucky | 21169 | 182 | 2 |
652199 | 652199 | 2020-10-21 | Monroe | Kentucky | 21171 | 257 | 4 |
652200 | 652200 | 2020-10-21 | Montgomery | Kentucky | 21173 | 389 | 4 |
652201 | 652201 | 2020-10-21 | Morgan | Kentucky | 21175 | 107 | 0 |
652202 | 652202 | 2020-10-21 | Muhlenberg | Kentucky | 21177 | 957 | 15 |
652203 | 652203 | 2020-10-21 | Nelson | Kentucky | 21179 | 745 | 4 |
652204 | 652204 | 2020-10-21 | Nicholas | Kentucky | 21181 | 103 | 1 |
652205 | 652205 | 2020-10-21 | Ohio | Kentucky | 21183 | 587 | 9 |
652206 | 652206 | 2020-10-21 | Oldham | Kentucky | 21185 | 1370 | 26 |
652207 | 652207 | 2020-10-21 | Owen | Kentucky | 21187 | 115 | 3 |
652208 | 652208 | 2020-10-21 | Owsley | Kentucky | 21189 | 72 | 1 |
652209 | 652209 | 2020-10-21 | Pendleton | Kentucky | 21191 | 112 | 0 |
652210 | 652210 | 2020-10-21 | Perry | Kentucky | 21193 | 461 | 9 |
652211 | 652211 | 2020-10-21 | Pike | Kentucky | 21195 | 749 | 3 |
652212 | 652212 | 2020-10-21 | Powell | Kentucky | 21197 | 133 | 0 |
652213 | 652213 | 2020-10-21 | Pulaski | Kentucky | 21199 | 975 | 13 |
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);