ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-10-05" 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 |
---|---|---|---|---|---|---|---|
1785126 | 1785126 | 2021-10-05 | Adair | Kentucky | 21001 | 3231 | 74 |
1785127 | 1785127 | 2021-10-05 | Allen | Kentucky | 21003 | 3628 | 62 |
1785128 | 1785128 | 2021-10-05 | Anderson | Kentucky | 21005 | 3069 | 39 |
1785129 | 1785129 | 2021-10-05 | Ballard | Kentucky | 21007 | 623 | 17 |
1785130 | 1785130 | 2021-10-05 | Barren | Kentucky | 21009 | 7685 | 120 |
1785131 | 1785131 | 2021-10-05 | Bath | Kentucky | 21011 | 1511 | 28 |
1785132 | 1785132 | 2021-10-05 | Bell | Kentucky | 21013 | 5589 | 88 |
1785133 | 1785133 | 2021-10-05 | Boone | Kentucky | 21015 | 19829 | 194 |
1785134 | 1785134 | 2021-10-05 | Bourbon | Kentucky | 21017 | 2990 | 29 |
1785135 | 1785135 | 2021-10-05 | Boyd | Kentucky | 21019 | 7929 | 97 |
1785136 | 1785136 | 2021-10-05 | Boyle | Kentucky | 21021 | 5148 | 80 |
1785137 | 1785137 | 2021-10-05 | Bracken | Kentucky | 21023 | 1031 | 8 |
1785138 | 1785138 | 2021-10-05 | Breathitt | Kentucky | 21025 | 1897 | 24 |
1785139 | 1785139 | 2021-10-05 | Breckinridge | Kentucky | 21027 | 2570 | 26 |
1785140 | 1785140 | 2021-10-05 | Bullitt | Kentucky | 21029 | 11507 | 112 |
1785141 | 1785141 | 2021-10-05 | Butler | Kentucky | 21031 | 2243 | 29 |
1785142 | 1785142 | 2021-10-05 | Caldwell | Kentucky | 21033 | 2143 | 45 |
1785143 | 1785143 | 2021-10-05 | Calloway | Kentucky | 21035 | 5009 | 60 |
1785144 | 1785144 | 2021-10-05 | Campbell | Kentucky | 21037 | 12450 | 95 |
1785145 | 1785145 | 2021-10-05 | Carlisle | Kentucky | 21039 | 597 | 11 |
1785146 | 1785146 | 2021-10-05 | Carroll | Kentucky | 21041 | 1761 | 23 |
1785147 | 1785147 | 2021-10-05 | Carter | Kentucky | 21043 | 4329 | 53 |
1785148 | 1785148 | 2021-10-05 | Casey | Kentucky | 21045 | 2690 | 52 |
1785149 | 1785149 | 2021-10-05 | Christian | Kentucky | 21047 | 9881 | 121 |
1785150 | 1785150 | 2021-10-05 | Clark | Kentucky | 21049 | 4913 | 32 |
1785151 | 1785151 | 2021-10-05 | Clay | Kentucky | 21051 | 5002 | 55 |
1785152 | 1785152 | 2021-10-05 | Clinton | Kentucky | 21053 | 2066 | 33 |
1785153 | 1785153 | 2021-10-05 | Crittenden | Kentucky | 21055 | 1074 | 33 |
1785154 | 1785154 | 2021-10-05 | Cumberland | Kentucky | 21057 | 1132 | 19 |
1785155 | 1785155 | 2021-10-05 | Daviess | Kentucky | 21059 | 16137 | 245 |
1785156 | 1785156 | 2021-10-05 | Edmonson | Kentucky | 21061 | 1479 | 28 |
1785157 | 1785157 | 2021-10-05 | Elliott | Kentucky | 21063 | 1276 | 4 |
1785158 | 1785158 | 2021-10-05 | Estill | Kentucky | 21065 | 2083 | 12 |
1785159 | 1785159 | 2021-10-05 | Fayette | Kentucky | 21067 | 49847 | 366 |
1785160 | 1785160 | 2021-10-05 | Fleming | Kentucky | 21069 | 2021 | 29 |
1785161 | 1785161 | 2021-10-05 | Floyd | Kentucky | 21071 | 6644 | 100 |
1785162 | 1785162 | 2021-10-05 | Franklin | Kentucky | 21073 | 6558 | 74 |
1785163 | 1785163 | 2021-10-05 | Fulton | Kentucky | 21075 | 709 | 16 |
1785164 | 1785164 | 2021-10-05 | Gallatin | Kentucky | 21077 | 1160 | 37 |
1785165 | 1785165 | 2021-10-05 | Garrard | Kentucky | 21079 | 2638 | 42 |
1785166 | 1785166 | 2021-10-05 | Grant | Kentucky | 21081 | 4029 | 33 |
1785167 | 1785167 | 2021-10-05 | Graves | Kentucky | 21083 | 7020 | 118 |
1785168 | 1785168 | 2021-10-05 | Grayson | Kentucky | 21085 | 4403 | 76 |
1785169 | 1785169 | 2021-10-05 | Green | Kentucky | 21087 | 2323 | 29 |
1785170 | 1785170 | 2021-10-05 | Greenup | Kentucky | 21089 | 5993 | 75 |
1785171 | 1785171 | 2021-10-05 | Hancock | Kentucky | 21091 | 1329 | 16 |
1785172 | 1785172 | 2021-10-05 | Hardin | Kentucky | 21093 | 17146 | 235 |
1785173 | 1785173 | 2021-10-05 | Harlan | Kentucky | 21095 | 5051 | 119 |
1785174 | 1785174 | 2021-10-05 | Harrison | Kentucky | 21097 | 3051 | 30 |
1785175 | 1785175 | 2021-10-05 | Hart | Kentucky | 21099 | 3370 | 60 |
1785176 | 1785176 | 2021-10-05 | Henderson | Kentucky | 21101 | 7664 | 95 |
1785177 | 1785177 | 2021-10-05 | Henry | Kentucky | 21103 | 2420 | 23 |
1785178 | 1785178 | 2021-10-05 | Hickman | Kentucky | 21105 | 530 | 18 |
1785179 | 1785179 | 2021-10-05 | Hopkins | Kentucky | 21107 | 7595 | 188 |
1785180 | 1785180 | 2021-10-05 | Jackson | Kentucky | 21109 | 2450 | 47 |
1785181 | 1785181 | 2021-10-05 | Jefferson | Kentucky | 21111 | 114214 | 1524 |
1785182 | 1785182 | 2021-10-05 | Jessamine | Kentucky | 21113 | 7731 | 87 |
1785183 | 1785183 | 2021-10-05 | Johnson | Kentucky | 21115 | 3568 | 45 |
1785184 | 1785184 | 2021-10-05 | Kenton | Kentucky | 21117 | 23380 | 255 |
1785185 | 1785185 | 2021-10-05 | Knott | Kentucky | 21119 | 2269 | 34 |
1785186 | 1785186 | 2021-10-05 | Knox | Kentucky | 21121 | 6934 | 49 |
1785187 | 1785187 | 2021-10-05 | Larue | Kentucky | 21123 | 2318 | 39 |
1785188 | 1785188 | 2021-10-05 | Laurel | Kentucky | 21125 | 12632 | 111 |
1785189 | 1785189 | 2021-10-05 | Lawrence | Kentucky | 21127 | 2442 | 37 |
1785190 | 1785190 | 2021-10-05 | Lee | Kentucky | 21129 | 1683 | 29 |
1785191 | 1785191 | 2021-10-05 | Leslie | Kentucky | 21131 | 2061 | 15 |
1785192 | 1785192 | 2021-10-05 | Letcher | Kentucky | 21133 | 3664 | 58 |
1785193 | 1785193 | 2021-10-05 | Lewis | Kentucky | 21135 | 2259 | 54 |
1785194 | 1785194 | 2021-10-05 | Lincoln | Kentucky | 21137 | 4060 | 74 |
1785195 | 1785195 | 2021-10-05 | Livingston | Kentucky | 21139 | 1310 | 40 |
1785196 | 1785196 | 2021-10-05 | Logan | Kentucky | 21141 | 4900 | 77 |
1785197 | 1785197 | 2021-10-05 | Lyon | Kentucky | 21143 | 1877 | 25 |
1785198 | 1785198 | 2021-10-05 | Madison | Kentucky | 21151 | 15042 | 144 |
1785199 | 1785199 | 2021-10-05 | Magoffin | Kentucky | 21153 | 2090 | 18 |
1785200 | 1785200 | 2021-10-05 | Marion | Kentucky | 21155 | 3745 | 40 |
1785201 | 1785201 | 2021-10-05 | Marshall | Kentucky | 21157 | 4848 | 75 |
1785202 | 1785202 | 2021-10-05 | Martin | Kentucky | 21159 | 1777 | 33 |
1785203 | 1785203 | 2021-10-05 | Mason | Kentucky | 21161 | 2431 | 57 |
1785204 | 1785204 | 2021-10-05 | McCracken | Kentucky | 21145 | 9659 | 160 |
1785205 | 1785205 | 2021-10-05 | McCreary | Kentucky | 21147 | 3479 | 48 |
1785206 | 1785206 | 2021-10-05 | McLean | Kentucky | 21149 | 1384 | 35 |
1785207 | 1785207 | 2021-10-05 | Meade | Kentucky | 21163 | 3241 | 34 |
1785208 | 1785208 | 2021-10-05 | Menifee | Kentucky | 21165 | 799 | 20 |
1785209 | 1785209 | 2021-10-05 | Mercer | Kentucky | 21167 | 4175 | 67 |
1785210 | 1785210 | 2021-10-05 | Metcalfe | Kentucky | 21169 | 1824 | 37 |
1785211 | 1785211 | 2021-10-05 | Monroe | Kentucky | 21171 | 2172 | 57 |
1785212 | 1785212 | 2021-10-05 | Montgomery | Kentucky | 21173 | 4272 | 47 |
1785213 | 1785213 | 2021-10-05 | Morgan | Kentucky | 21175 | 2788 | 6 |
1785214 | 1785214 | 2021-10-05 | Muhlenberg | Kentucky | 21177 | 5288 | 85 |
1785215 | 1785215 | 2021-10-05 | Nelson | Kentucky | 21179 | 7944 | 74 |
1785216 | 1785216 | 2021-10-05 | Nicholas | Kentucky | 21181 | 1063 | 15 |
1785217 | 1785217 | 2021-10-05 | Ohio | Kentucky | 21183 | 4149 | 74 |
1785218 | 1785218 | 2021-10-05 | Oldham | Kentucky | 21185 | 9764 | 90 |
1785219 | 1785219 | 2021-10-05 | Owen | Kentucky | 21187 | 1299 | 21 |
1785220 | 1785220 | 2021-10-05 | Owsley | Kentucky | 21189 | 929 | 16 |
1785221 | 1785221 | 2021-10-05 | Pendleton | Kentucky | 21191 | 1857 | 14 |
1785222 | 1785222 | 2021-10-05 | Perry | Kentucky | 21193 | 5755 | 84 |
1785223 | 1785223 | 2021-10-05 | Pike | Kentucky | 21195 | 10039 | 159 |
1785224 | 1785224 | 2021-10-05 | Powell | Kentucky | 21197 | 2341 | 20 |
1785225 | 1785225 | 2021-10-05 | Pulaski | Kentucky | 21199 | 10658 | 176 |
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);