ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where "date" is on date 2020-05-12 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 |
---|---|---|---|---|---|---|---|
137158 | 137158 | 2020-05-12 | Adair | Kentucky | 21001 | 88 | 13 |
137159 | 137159 | 2020-05-12 | Allen | Kentucky | 21003 | 30 | 1 |
137160 | 137160 | 2020-05-12 | Anderson | Kentucky | 21005 | 10 | 1 |
137161 | 137161 | 2020-05-12 | Ballard | Kentucky | 21007 | 8 | 0 |
137162 | 137162 | 2020-05-12 | Barren | Kentucky | 21009 | 30 | 0 |
137163 | 137163 | 2020-05-12 | Bath | Kentucky | 21011 | 7 | 1 |
137164 | 137164 | 2020-05-12 | Boone | Kentucky | 21015 | 250 | 8 |
137165 | 137165 | 2020-05-12 | Bourbon | Kentucky | 21017 | 8 | 1 |
137166 | 137166 | 2020-05-12 | Boyd | Kentucky | 21019 | 37 | 3 |
137167 | 137167 | 2020-05-12 | Boyle | Kentucky | 21021 | 17 | 0 |
137168 | 137168 | 2020-05-12 | Bracken | Kentucky | 21023 | 9 | 0 |
137169 | 137169 | 2020-05-12 | Breathitt | Kentucky | 21025 | 2 | 0 |
137170 | 137170 | 2020-05-12 | Breckinridge | Kentucky | 21027 | 13 | 0 |
137171 | 137171 | 2020-05-12 | Bullitt | Kentucky | 21029 | 86 | 4 |
137172 | 137172 | 2020-05-12 | Butler | Kentucky | 21031 | 200 | 6 |
137173 | 137173 | 2020-05-12 | Caldwell | Kentucky | 21033 | 12 | 0 |
137174 | 137174 | 2020-05-12 | Calloway | Kentucky | 21035 | 43 | 1 |
137175 | 137175 | 2020-05-12 | Campbell | Kentucky | 21037 | 120 | 9 |
137176 | 137176 | 2020-05-12 | Carlisle | Kentucky | 21039 | 3 | 1 |
137177 | 137177 | 2020-05-12 | Carroll | Kentucky | 21041 | 2 | 0 |
137178 | 137178 | 2020-05-12 | Carter | Kentucky | 21043 | 7 | 0 |
137179 | 137179 | 2020-05-12 | Casey | Kentucky | 21045 | 1 | 0 |
137180 | 137180 | 2020-05-12 | Christian | Kentucky | 21047 | 95 | 3 |
137181 | 137181 | 2020-05-12 | Clark | Kentucky | 21049 | 20 | 0 |
137182 | 137182 | 2020-05-12 | Clay | Kentucky | 21051 | 2 | 0 |
137183 | 137183 | 2020-05-12 | Clinton | Kentucky | 21053 | 3 | 0 |
137184 | 137184 | 2020-05-12 | Crittenden | Kentucky | 21055 | 4 | 1 |
137185 | 137185 | 2020-05-12 | Cumberland | Kentucky | 21057 | 5 | 0 |
137186 | 137186 | 2020-05-12 | Daviess | Kentucky | 21059 | 274 | 4 |
137187 | 137187 | 2020-05-12 | Edmonson | Kentucky | 21061 | 45 | 6 |
137188 | 137188 | 2020-05-12 | Fayette | Kentucky | 21067 | 426 | 10 |
137189 | 137189 | 2020-05-12 | Fleming | Kentucky | 21069 | 1 | 0 |
137190 | 137190 | 2020-05-12 | Floyd | Kentucky | 21071 | 15 | 0 |
137191 | 137191 | 2020-05-12 | Franklin | Kentucky | 21073 | 18 | 0 |
137192 | 137192 | 2020-05-12 | Fulton | Kentucky | 21075 | 1 | 0 |
137193 | 137193 | 2020-05-12 | Gallatin | Kentucky | 21077 | 1 | 0 |
137194 | 137194 | 2020-05-12 | Garrard | Kentucky | 21079 | 4 | 0 |
137195 | 137195 | 2020-05-12 | Grant | Kentucky | 21081 | 31 | 3 |
137196 | 137196 | 2020-05-12 | Graves | Kentucky | 21083 | 149 | 18 |
137197 | 137197 | 2020-05-12 | Grayson | Kentucky | 21085 | 99 | 6 |
137198 | 137198 | 2020-05-12 | Green | Kentucky | 21087 | 1 | 0 |
137199 | 137199 | 2020-05-12 | Greenup | Kentucky | 21089 | 13 | 0 |
137200 | 137200 | 2020-05-12 | Hancock | Kentucky | 21091 | 6 | 0 |
137201 | 137201 | 2020-05-12 | Hardin | Kentucky | 21093 | 63 | 2 |
137202 | 137202 | 2020-05-12 | Harlan | Kentucky | 21095 | 1 | 0 |
137203 | 137203 | 2020-05-12 | Harrison | Kentucky | 21097 | 19 | 0 |
137204 | 137204 | 2020-05-12 | Hart | Kentucky | 21099 | 16 | 0 |
137205 | 137205 | 2020-05-12 | Henderson | Kentucky | 21101 | 86 | 3 |
137206 | 137206 | 2020-05-12 | Henry | Kentucky | 21103 | 10 | 0 |
137207 | 137207 | 2020-05-12 | Hickman | Kentucky | 21105 | 5 | 0 |
137208 | 137208 | 2020-05-12 | Hopkins | Kentucky | 21107 | 216 | 28 |
137209 | 137209 | 2020-05-12 | Jackson | Kentucky | 21109 | 56 | 12 |
137210 | 137210 | 2020-05-12 | Jefferson | Kentucky | 21111 | 1808 | 123 |
137211 | 137211 | 2020-05-12 | Jessamine | Kentucky | 21113 | 49 | 0 |
137212 | 137212 | 2020-05-12 | Johnson | Kentucky | 21115 | 5 | 0 |
137213 | 137213 | 2020-05-12 | Kenton | Kentucky | 21117 | 408 | 30 |
137214 | 137214 | 2020-05-12 | Knott | Kentucky | 21119 | 4 | 0 |
137215 | 137215 | 2020-05-12 | Knox | Kentucky | 21121 | 7 | 0 |
137216 | 137216 | 2020-05-12 | Larue | Kentucky | 21123 | 6 | 0 |
137217 | 137217 | 2020-05-12 | Laurel | Kentucky | 21125 | 21 | 2 |
137218 | 137218 | 2020-05-12 | Lawrence | Kentucky | 21127 | 1 | 0 |
137219 | 137219 | 2020-05-12 | Leslie | Kentucky | 21131 | 5 | 0 |
137220 | 137220 | 2020-05-12 | Letcher | Kentucky | 21133 | 3 | 0 |
137221 | 137221 | 2020-05-12 | Lewis | Kentucky | 21135 | 6 | 0 |
137222 | 137222 | 2020-05-12 | Lincoln | Kentucky | 21137 | 5 | 1 |
137223 | 137223 | 2020-05-12 | Livingston | Kentucky | 21139 | 7 | 0 |
137224 | 137224 | 2020-05-12 | Logan | Kentucky | 21141 | 72 | 2 |
137225 | 137225 | 2020-05-12 | Lyon | Kentucky | 21143 | 14 | 3 |
137226 | 137226 | 2020-05-12 | Madison | Kentucky | 21151 | 35 | 1 |
137227 | 137227 | 2020-05-12 | Marion | Kentucky | 21155 | 17 | 0 |
137228 | 137228 | 2020-05-12 | Marshall | Kentucky | 21157 | 34 | 1 |
137229 | 137229 | 2020-05-12 | Martin | Kentucky | 21159 | 3 | 0 |
137230 | 137230 | 2020-05-12 | Mason | Kentucky | 21161 | 7 | 0 |
137231 | 137231 | 2020-05-12 | McCracken | Kentucky | 21145 | 73 | 2 |
137232 | 137232 | 2020-05-12 | McCreary | Kentucky | 21147 | 13 | 0 |
137233 | 137233 | 2020-05-12 | McLean | Kentucky | 21149 | 18 | 0 |
137234 | 137234 | 2020-05-12 | Meade | Kentucky | 21163 | 18 | 2 |
137235 | 137235 | 2020-05-12 | Menifee | Kentucky | 21165 | 3 | 0 |
137236 | 137236 | 2020-05-12 | Mercer | Kentucky | 21167 | 12 | 0 |
137237 | 137237 | 2020-05-12 | Metcalfe | Kentucky | 21169 | 3 | 0 |
137238 | 137238 | 2020-05-12 | Monroe | Kentucky | 21171 | 6 | 0 |
137239 | 137239 | 2020-05-12 | Montgomery | Kentucky | 21173 | 13 | 0 |
137240 | 137240 | 2020-05-12 | Morgan | Kentucky | 21175 | 1 | 0 |
137241 | 137241 | 2020-05-12 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
137242 | 137242 | 2020-05-12 | Nelson | Kentucky | 21179 | 31 | 0 |
137243 | 137243 | 2020-05-12 | Nicholas | Kentucky | 21181 | 1 | 0 |
137244 | 137244 | 2020-05-12 | Ohio | Kentucky | 21183 | 109 | 0 |
137245 | 137245 | 2020-05-12 | Oldham | Kentucky | 21185 | 41 | 0 |
137246 | 137246 | 2020-05-12 | Owen | Kentucky | 21187 | 1 | 0 |
137247 | 137247 | 2020-05-12 | Owsley | Kentucky | 21189 | 2 | 0 |
137248 | 137248 | 2020-05-12 | Pendleton | Kentucky | 21191 | 6 | 0 |
137249 | 137249 | 2020-05-12 | Perry | Kentucky | 21193 | 16 | 0 |
137250 | 137250 | 2020-05-12 | Pike | Kentucky | 21195 | 18 | 2 |
137251 | 137251 | 2020-05-12 | Powell | Kentucky | 21197 | 1 | 0 |
137252 | 137252 | 2020-05-12 | Pulaski | Kentucky | 21199 | 45 | 2 |
137253 | 137253 | 2020-05-12 | Rockcastle | Kentucky | 21203 | 13 | 0 |
137254 | 137254 | 2020-05-12 | Rowan | Kentucky | 21205 | 6 | 0 |
137255 | 137255 | 2020-05-12 | Russell | Kentucky | 21207 | 18 | 4 |
137256 | 137256 | 2020-05-12 | Scott | Kentucky | 21209 | 33 | 0 |
137257 | 137257 | 2020-05-12 | Shelby | Kentucky | 21211 | 54 | 3 |
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);