ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where date = "2020-06-05" 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 |
---|---|---|---|---|---|---|---|
210119 | 210119 | 2020-06-05 | Adair | Kentucky | 21001 | 98 | 19 |
210120 | 210120 | 2020-06-05 | Allen | Kentucky | 21003 | 102 | 3 |
210121 | 210121 | 2020-06-05 | Anderson | Kentucky | 21005 | 22 | 1 |
210122 | 210122 | 2020-06-05 | Ballard | Kentucky | 21007 | 12 | 0 |
210123 | 210123 | 2020-06-05 | Barren | Kentucky | 21009 | 53 | 1 |
210124 | 210124 | 2020-06-05 | Bath | Kentucky | 21011 | 9 | 1 |
210125 | 210125 | 2020-06-05 | Bell | Kentucky | 21013 | 2 | 0 |
210126 | 210126 | 2020-06-05 | Boone | Kentucky | 21015 | 508 | 18 |
210127 | 210127 | 2020-06-05 | Bourbon | Kentucky | 21017 | 12 | 1 |
210128 | 210128 | 2020-06-05 | Boyd | Kentucky | 21019 | 42 | 3 |
210129 | 210129 | 2020-06-05 | Boyle | Kentucky | 21021 | 28 | 0 |
210130 | 210130 | 2020-06-05 | Bracken | Kentucky | 21023 | 14 | 0 |
210131 | 210131 | 2020-06-05 | Breathitt | Kentucky | 21025 | 3 | 0 |
210132 | 210132 | 2020-06-05 | Breckinridge | Kentucky | 21027 | 19 | 2 |
210133 | 210133 | 2020-06-05 | Bullitt | Kentucky | 21029 | 119 | 4 |
210134 | 210134 | 2020-06-05 | Butler | Kentucky | 21031 | 236 | 13 |
210135 | 210135 | 2020-06-05 | Caldwell | Kentucky | 21033 | 12 | 0 |
210136 | 210136 | 2020-06-05 | Calloway | Kentucky | 21035 | 54 | 1 |
210137 | 210137 | 2020-06-05 | Campbell | Kentucky | 21037 | 194 | 12 |
210138 | 210138 | 2020-06-05 | Carlisle | Kentucky | 21039 | 5 | 1 |
210139 | 210139 | 2020-06-05 | Carroll | Kentucky | 21041 | 15 | 0 |
210140 | 210140 | 2020-06-05 | Carter | Kentucky | 21043 | 14 | 0 |
210141 | 210141 | 2020-06-05 | Casey | Kentucky | 21045 | 8 | 0 |
210142 | 210142 | 2020-06-05 | Christian | Kentucky | 21047 | 123 | 3 |
210143 | 210143 | 2020-06-05 | Clark | Kentucky | 21049 | 58 | 0 |
210144 | 210144 | 2020-06-05 | Clay | Kentucky | 21051 | 8 | 1 |
210145 | 210145 | 2020-06-05 | Clinton | Kentucky | 21053 | 5 | 0 |
210146 | 210146 | 2020-06-05 | Crittenden | Kentucky | 21055 | 7 | 1 |
210147 | 210147 | 2020-06-05 | Cumberland | Kentucky | 21057 | 5 | 0 |
210148 | 210148 | 2020-06-05 | Daviess | Kentucky | 21059 | 339 | 7 |
210149 | 210149 | 2020-06-05 | Edmonson | Kentucky | 21061 | 60 | 11 |
210150 | 210150 | 2020-06-05 | Elliott | Kentucky | 21063 | 1 | 0 |
210151 | 210151 | 2020-06-05 | Estill | Kentucky | 21065 | 1 | 0 |
210152 | 210152 | 2020-06-05 | Fayette | Kentucky | 21067 | 847 | 14 |
210153 | 210153 | 2020-06-05 | Fleming | Kentucky | 21069 | 2 | 0 |
210154 | 210154 | 2020-06-05 | Floyd | Kentucky | 21071 | 18 | 0 |
210155 | 210155 | 2020-06-05 | Franklin | Kentucky | 21073 | 73 | 2 |
210156 | 210156 | 2020-06-05 | Fulton | Kentucky | 21075 | 10 | 0 |
210157 | 210157 | 2020-06-05 | Gallatin | Kentucky | 21077 | 46 | 5 |
210158 | 210158 | 2020-06-05 | Garrard | Kentucky | 21079 | 5 | 0 |
210159 | 210159 | 2020-06-05 | Grant | Kentucky | 21081 | 47 | 4 |
210160 | 210160 | 2020-06-05 | Graves | Kentucky | 21083 | 166 | 20 |
210161 | 210161 | 2020-06-05 | Grayson | Kentucky | 21085 | 134 | 10 |
210162 | 210162 | 2020-06-05 | Green | Kentucky | 21087 | 2 | 0 |
210163 | 210163 | 2020-06-05 | Greenup | Kentucky | 21089 | 14 | 0 |
210164 | 210164 | 2020-06-05 | Hancock | Kentucky | 21091 | 9 | 0 |
210165 | 210165 | 2020-06-05 | Hardin | Kentucky | 21093 | 119 | 2 |
210166 | 210166 | 2020-06-05 | Harlan | Kentucky | 21095 | 4 | 0 |
210167 | 210167 | 2020-06-05 | Harrison | Kentucky | 21097 | 28 | 0 |
210168 | 210168 | 2020-06-05 | Hart | Kentucky | 21099 | 31 | 0 |
210169 | 210169 | 2020-06-05 | Henderson | Kentucky | 21101 | 121 | 4 |
210170 | 210170 | 2020-06-05 | Henry | Kentucky | 21103 | 23 | 0 |
210171 | 210171 | 2020-06-05 | Hickman | Kentucky | 21105 | 5 | 0 |
210172 | 210172 | 2020-06-05 | Hopkins | Kentucky | 21107 | 225 | 32 |
210173 | 210173 | 2020-06-05 | Jackson | Kentucky | 21109 | 61 | 13 |
210174 | 210174 | 2020-06-05 | Jefferson | Kentucky | 21111 | 2843 | 174 |
210175 | 210175 | 2020-06-05 | Jessamine | Kentucky | 21113 | 69 | 0 |
210176 | 210176 | 2020-06-05 | Johnson | Kentucky | 21115 | 5 | 0 |
210177 | 210177 | 2020-06-05 | Kenton | Kentucky | 21117 | 663 | 35 |
210178 | 210178 | 2020-06-05 | Knott | Kentucky | 21119 | 4 | 0 |
210179 | 210179 | 2020-06-05 | Knox | Kentucky | 21121 | 10 | 0 |
210180 | 210180 | 2020-06-05 | Larue | Kentucky | 21123 | 9 | 0 |
210181 | 210181 | 2020-06-05 | Laurel | Kentucky | 21125 | 21 | 2 |
210182 | 210182 | 2020-06-05 | Lawrence | Kentucky | 21127 | 5 | 0 |
210183 | 210183 | 2020-06-05 | Lee | Kentucky | 21129 | 1 | 0 |
210184 | 210184 | 2020-06-05 | Leslie | Kentucky | 21131 | 6 | 0 |
210185 | 210185 | 2020-06-05 | Letcher | Kentucky | 21133 | 5 | 0 |
210186 | 210186 | 2020-06-05 | Lewis | Kentucky | 21135 | 8 | 0 |
210187 | 210187 | 2020-06-05 | Lincoln | Kentucky | 21137 | 11 | 1 |
210188 | 210188 | 2020-06-05 | Livingston | Kentucky | 21139 | 9 | 0 |
210189 | 210189 | 2020-06-05 | Logan | Kentucky | 21141 | 170 | 5 |
210190 | 210190 | 2020-06-05 | Lyon | Kentucky | 21143 | 15 | 3 |
210191 | 210191 | 2020-06-05 | Madison | Kentucky | 21151 | 57 | 1 |
210192 | 210192 | 2020-06-05 | Magoffin | Kentucky | 21153 | 2 | 0 |
210193 | 210193 | 2020-06-05 | Marion | Kentucky | 21155 | 31 | 0 |
210194 | 210194 | 2020-06-05 | Marshall | Kentucky | 21157 | 37 | 2 |
210195 | 210195 | 2020-06-05 | Martin | Kentucky | 21159 | 3 | 0 |
210196 | 210196 | 2020-06-05 | Mason | Kentucky | 21161 | 12 | 0 |
210197 | 210197 | 2020-06-05 | McCracken | Kentucky | 21145 | 111 | 2 |
210198 | 210198 | 2020-06-05 | McCreary | Kentucky | 21147 | 13 | 0 |
210199 | 210199 | 2020-06-05 | McLean | Kentucky | 21149 | 24 | 0 |
210200 | 210200 | 2020-06-05 | Meade | Kentucky | 21163 | 23 | 2 |
210201 | 210201 | 2020-06-05 | Menifee | Kentucky | 21165 | 10 | 0 |
210202 | 210202 | 2020-06-05 | Mercer | Kentucky | 21167 | 15 | 0 |
210203 | 210203 | 2020-06-05 | Metcalfe | Kentucky | 21169 | 7 | 2 |
210204 | 210204 | 2020-06-05 | Monroe | Kentucky | 21171 | 25 | 0 |
210205 | 210205 | 2020-06-05 | Montgomery | Kentucky | 21173 | 25 | 0 |
210206 | 210206 | 2020-06-05 | Morgan | Kentucky | 21175 | 3 | 0 |
210207 | 210207 | 2020-06-05 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
210208 | 210208 | 2020-06-05 | Nelson | Kentucky | 21179 | 44 | 1 |
210209 | 210209 | 2020-06-05 | Nicholas | Kentucky | 21181 | 4 | 0 |
210210 | 210210 | 2020-06-05 | Ohio | Kentucky | 21183 | 176 | 0 |
210211 | 210211 | 2020-06-05 | Oldham | Kentucky | 21185 | 109 | 5 |
210212 | 210212 | 2020-06-05 | Owen | Kentucky | 21187 | 3 | 0 |
210213 | 210213 | 2020-06-05 | Owsley | Kentucky | 21189 | 2 | 0 |
210214 | 210214 | 2020-06-05 | Pendleton | Kentucky | 21191 | 14 | 0 |
210215 | 210215 | 2020-06-05 | Perry | Kentucky | 21193 | 22 | 0 |
210216 | 210216 | 2020-06-05 | Pike | Kentucky | 21195 | 34 | 2 |
210217 | 210217 | 2020-06-05 | Powell | Kentucky | 21197 | 1 | 0 |
210218 | 210218 | 2020-06-05 | Pulaski | Kentucky | 21199 | 64 | 2 |
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);