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-14 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
143147 | 143147 | 2020-05-14 | Adair | Kentucky | 21001 | 91 | 14 |
143148 | 143148 | 2020-05-14 | Allen | Kentucky | 21003 | 33 | 1 |
143149 | 143149 | 2020-05-14 | Anderson | Kentucky | 21005 | 10 | 1 |
143150 | 143150 | 2020-05-14 | Ballard | Kentucky | 21007 | 10 | 0 |
143151 | 143151 | 2020-05-14 | Barren | Kentucky | 21009 | 34 | 0 |
143152 | 143152 | 2020-05-14 | Bath | Kentucky | 21011 | 7 | 1 |
143153 | 143153 | 2020-05-14 | Boone | Kentucky | 21015 | 283 | 8 |
143154 | 143154 | 2020-05-14 | Bourbon | Kentucky | 21017 | 8 | 1 |
143155 | 143155 | 2020-05-14 | Boyd | Kentucky | 21019 | 38 | 3 |
143156 | 143156 | 2020-05-14 | Boyle | Kentucky | 21021 | 18 | 0 |
143157 | 143157 | 2020-05-14 | Bracken | Kentucky | 21023 | 9 | 0 |
143158 | 143158 | 2020-05-14 | Breathitt | Kentucky | 21025 | 2 | 0 |
143159 | 143159 | 2020-05-14 | Breckinridge | Kentucky | 21027 | 14 | 0 |
143160 | 143160 | 2020-05-14 | Bullitt | Kentucky | 21029 | 89 | 4 |
143161 | 143161 | 2020-05-14 | Butler | Kentucky | 21031 | 205 | 6 |
143162 | 143162 | 2020-05-14 | Caldwell | Kentucky | 21033 | 12 | 0 |
143163 | 143163 | 2020-05-14 | Calloway | Kentucky | 21035 | 44 | 1 |
143164 | 143164 | 2020-05-14 | Campbell | Kentucky | 21037 | 128 | 10 |
143165 | 143165 | 2020-05-14 | Carlisle | Kentucky | 21039 | 3 | 1 |
143166 | 143166 | 2020-05-14 | Carroll | Kentucky | 21041 | 2 | 0 |
143167 | 143167 | 2020-05-14 | Carter | Kentucky | 21043 | 7 | 0 |
143168 | 143168 | 2020-05-14 | Casey | Kentucky | 21045 | 2 | 0 |
143169 | 143169 | 2020-05-14 | Christian | Kentucky | 21047 | 95 | 3 |
143170 | 143170 | 2020-05-14 | Clark | Kentucky | 21049 | 20 | 0 |
143171 | 143171 | 2020-05-14 | Clay | Kentucky | 21051 | 2 | 0 |
143172 | 143172 | 2020-05-14 | Clinton | Kentucky | 21053 | 3 | 0 |
143173 | 143173 | 2020-05-14 | Crittenden | Kentucky | 21055 | 4 | 1 |
143174 | 143174 | 2020-05-14 | Cumberland | Kentucky | 21057 | 5 | 0 |
143175 | 143175 | 2020-05-14 | Daviess | Kentucky | 21059 | 277 | 4 |
143176 | 143176 | 2020-05-14 | Edmonson | Kentucky | 21061 | 46 | 6 |
143177 | 143177 | 2020-05-14 | Fayette | Kentucky | 21067 | 529 | 10 |
143178 | 143178 | 2020-05-14 | Fleming | Kentucky | 21069 | 2 | 0 |
143179 | 143179 | 2020-05-14 | Floyd | Kentucky | 21071 | 18 | 0 |
143180 | 143180 | 2020-05-14 | Franklin | Kentucky | 21073 | 18 | 0 |
143181 | 143181 | 2020-05-14 | Fulton | Kentucky | 21075 | 1 | 0 |
143182 | 143182 | 2020-05-14 | Gallatin | Kentucky | 21077 | 2 | 0 |
143183 | 143183 | 2020-05-14 | Garrard | Kentucky | 21079 | 4 | 0 |
143184 | 143184 | 2020-05-14 | Grant | Kentucky | 21081 | 31 | 3 |
143185 | 143185 | 2020-05-14 | Graves | Kentucky | 21083 | 152 | 18 |
143186 | 143186 | 2020-05-14 | Grayson | Kentucky | 21085 | 101 | 8 |
143187 | 143187 | 2020-05-14 | Green | Kentucky | 21087 | 1 | 0 |
143188 | 143188 | 2020-05-14 | Greenup | Kentucky | 21089 | 13 | 0 |
143189 | 143189 | 2020-05-14 | Hancock | Kentucky | 21091 | 7 | 0 |
143190 | 143190 | 2020-05-14 | Hardin | Kentucky | 21093 | 72 | 2 |
143191 | 143191 | 2020-05-14 | Harlan | Kentucky | 21095 | 1 | 0 |
143192 | 143192 | 2020-05-14 | Harrison | Kentucky | 21097 | 19 | 0 |
143193 | 143193 | 2020-05-14 | Hart | Kentucky | 21099 | 19 | 0 |
143194 | 143194 | 2020-05-14 | Henderson | Kentucky | 21101 | 89 | 3 |
143195 | 143195 | 2020-05-14 | Henry | Kentucky | 21103 | 11 | 0 |
143196 | 143196 | 2020-05-14 | Hickman | Kentucky | 21105 | 5 | 0 |
143197 | 143197 | 2020-05-14 | Hopkins | Kentucky | 21107 | 218 | 28 |
143198 | 143198 | 2020-05-14 | Jackson | Kentucky | 21109 | 57 | 12 |
143199 | 143199 | 2020-05-14 | Jefferson | Kentucky | 21111 | 1822 | 126 |
143200 | 143200 | 2020-05-14 | Jessamine | Kentucky | 21113 | 50 | 0 |
143201 | 143201 | 2020-05-14 | Johnson | Kentucky | 21115 | 5 | 0 |
143202 | 143202 | 2020-05-14 | Kenton | Kentucky | 21117 | 432 | 30 |
143203 | 143203 | 2020-05-14 | Knott | Kentucky | 21119 | 4 | 0 |
143204 | 143204 | 2020-05-14 | Knox | Kentucky | 21121 | 7 | 0 |
143205 | 143205 | 2020-05-14 | Larue | Kentucky | 21123 | 6 | 0 |
143206 | 143206 | 2020-05-14 | Laurel | Kentucky | 21125 | 21 | 2 |
143207 | 143207 | 2020-05-14 | Lawrence | Kentucky | 21127 | 2 | 0 |
143208 | 143208 | 2020-05-14 | Leslie | Kentucky | 21131 | 6 | 0 |
143209 | 143209 | 2020-05-14 | Letcher | Kentucky | 21133 | 5 | 0 |
143210 | 143210 | 2020-05-14 | Lewis | Kentucky | 21135 | 8 | 0 |
143211 | 143211 | 2020-05-14 | Lincoln | Kentucky | 21137 | 5 | 1 |
143212 | 143212 | 2020-05-14 | Livingston | Kentucky | 21139 | 7 | 0 |
143213 | 143213 | 2020-05-14 | Logan | Kentucky | 21141 | 77 | 2 |
143214 | 143214 | 2020-05-14 | Lyon | Kentucky | 21143 | 14 | 3 |
143215 | 143215 | 2020-05-14 | Madison | Kentucky | 21151 | 41 | 1 |
143216 | 143216 | 2020-05-14 | Marion | Kentucky | 21155 | 17 | 0 |
143217 | 143217 | 2020-05-14 | Marshall | Kentucky | 21157 | 34 | 2 |
143218 | 143218 | 2020-05-14 | Martin | Kentucky | 21159 | 3 | 0 |
143219 | 143219 | 2020-05-14 | Mason | Kentucky | 21161 | 8 | 0 |
143220 | 143220 | 2020-05-14 | McCracken | Kentucky | 21145 | 76 | 2 |
143221 | 143221 | 2020-05-14 | McCreary | Kentucky | 21147 | 13 | 0 |
143222 | 143222 | 2020-05-14 | McLean | Kentucky | 21149 | 19 | 0 |
143223 | 143223 | 2020-05-14 | Meade | Kentucky | 21163 | 18 | 2 |
143224 | 143224 | 2020-05-14 | Menifee | Kentucky | 21165 | 3 | 0 |
143225 | 143225 | 2020-05-14 | Mercer | Kentucky | 21167 | 12 | 0 |
143226 | 143226 | 2020-05-14 | Metcalfe | Kentucky | 21169 | 3 | 0 |
143227 | 143227 | 2020-05-14 | Monroe | Kentucky | 21171 | 6 | 0 |
143228 | 143228 | 2020-05-14 | Montgomery | Kentucky | 21173 | 16 | 0 |
143229 | 143229 | 2020-05-14 | Morgan | Kentucky | 21175 | 1 | 0 |
143230 | 143230 | 2020-05-14 | Muhlenberg | Kentucky | 21177 | 459 | 6 |
143231 | 143231 | 2020-05-14 | Nelson | Kentucky | 21179 | 32 | 0 |
143232 | 143232 | 2020-05-14 | Nicholas | Kentucky | 21181 | 1 | 0 |
143233 | 143233 | 2020-05-14 | Ohio | Kentucky | 21183 | 118 | 0 |
143234 | 143234 | 2020-05-14 | Oldham | Kentucky | 21185 | 50 | 0 |
143235 | 143235 | 2020-05-14 | Owen | Kentucky | 21187 | 1 | 0 |
143236 | 143236 | 2020-05-14 | Owsley | Kentucky | 21189 | 2 | 0 |
143237 | 143237 | 2020-05-14 | Pendleton | Kentucky | 21191 | 6 | 0 |
143238 | 143238 | 2020-05-14 | Perry | Kentucky | 21193 | 18 | 0 |
143239 | 143239 | 2020-05-14 | Pike | Kentucky | 21195 | 22 | 2 |
143240 | 143240 | 2020-05-14 | Powell | Kentucky | 21197 | 1 | 0 |
143241 | 143241 | 2020-05-14 | Pulaski | Kentucky | 21199 | 47 | 2 |
143242 | 143242 | 2020-05-14 | Rockcastle | Kentucky | 21203 | 13 | 0 |
143243 | 143243 | 2020-05-14 | Rowan | Kentucky | 21205 | 6 | 0 |
143244 | 143244 | 2020-05-14 | Russell | Kentucky | 21207 | 19 | 4 |
143245 | 143245 | 2020-05-14 | Scott | Kentucky | 21209 | 33 | 0 |
143246 | 143246 | 2020-05-14 | 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);