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-08-23 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 |
---|---|---|---|---|---|---|---|
461050 | 461050 | 2020-08-23 | Adair | Kentucky | 21001 | 257 | 19 |
461051 | 461051 | 2020-08-23 | Allen | Kentucky | 21003 | 241 | 8 |
461052 | 461052 | 2020-08-23 | Anderson | Kentucky | 21005 | 103 | 1 |
461053 | 461053 | 2020-08-23 | Ballard | Kentucky | 21007 | 39 | 0 |
461054 | 461054 | 2020-08-23 | Barren | Kentucky | 21009 | 471 | 6 |
461055 | 461055 | 2020-08-23 | Bath | Kentucky | 21011 | 52 | 1 |
461056 | 461056 | 2020-08-23 | Bell | Kentucky | 21013 | 367 | 6 |
461057 | 461057 | 2020-08-23 | Boone | Kentucky | 21015 | 1218 | 25 |
461058 | 461058 | 2020-08-23 | Bourbon | Kentucky | 21017 | 110 | 1 |
461059 | 461059 | 2020-08-23 | Boyd | Kentucky | 21019 | 214 | 4 |
461060 | 461060 | 2020-08-23 | Boyle | Kentucky | 21021 | 186 | 0 |
461061 | 461061 | 2020-08-23 | Bracken | Kentucky | 21023 | 37 | 0 |
461062 | 461062 | 2020-08-23 | Breathitt | Kentucky | 21025 | 39 | 0 |
461063 | 461063 | 2020-08-23 | Breckinridge | Kentucky | 21027 | 91 | 2 |
461064 | 461064 | 2020-08-23 | Bullitt | Kentucky | 21029 | 537 | 5 |
461065 | 461065 | 2020-08-23 | Butler | Kentucky | 21031 | 314 | 16 |
461066 | 461066 | 2020-08-23 | Caldwell | Kentucky | 21033 | 62 | 0 |
461067 | 461067 | 2020-08-23 | Calloway | Kentucky | 21035 | 345 | 5 |
461068 | 461068 | 2020-08-23 | Campbell | Kentucky | 21037 | 650 | 13 |
461069 | 461069 | 2020-08-23 | Carlisle | Kentucky | 21039 | 55 | 1 |
461070 | 461070 | 2020-08-23 | Carroll | Kentucky | 21041 | 184 | 2 |
461071 | 461071 | 2020-08-23 | Carter | Kentucky | 21043 | 110 | 3 |
461072 | 461072 | 2020-08-23 | Casey | Kentucky | 21045 | 232 | 13 |
461073 | 461073 | 2020-08-23 | Christian | Kentucky | 21047 | 818 | 11 |
461074 | 461074 | 2020-08-23 | Clark | Kentucky | 21049 | 220 | 8 |
461075 | 461075 | 2020-08-23 | Clay | Kentucky | 21051 | 196 | 6 |
461076 | 461076 | 2020-08-23 | Clinton | Kentucky | 21053 | 61 | 1 |
461077 | 461077 | 2020-08-23 | Crittenden | Kentucky | 21055 | 38 | 1 |
461078 | 461078 | 2020-08-23 | Cumberland | Kentucky | 21057 | 80 | 0 |
461079 | 461079 | 2020-08-23 | Daviess | Kentucky | 21059 | 912 | 10 |
461080 | 461080 | 2020-08-23 | Edmonson | Kentucky | 21061 | 127 | 12 |
461081 | 461081 | 2020-08-23 | Elliott | Kentucky | 21063 | 19 | 0 |
461082 | 461082 | 2020-08-23 | Estill | Kentucky | 21065 | 28 | 0 |
461083 | 461083 | 2020-08-23 | Fayette | Kentucky | 21067 | 4911 | 53 |
461084 | 461084 | 2020-08-23 | Fleming | Kentucky | 21069 | 65 | 0 |
461085 | 461085 | 2020-08-23 | Floyd | Kentucky | 21071 | 132 | 2 |
461086 | 461086 | 2020-08-23 | Franklin | Kentucky | 21073 | 428 | 11 |
461087 | 461087 | 2020-08-23 | Fulton | Kentucky | 21075 | 109 | 2 |
461088 | 461088 | 2020-08-23 | Gallatin | Kentucky | 21077 | 87 | 8 |
461089 | 461089 | 2020-08-23 | Garrard | Kentucky | 21079 | 99 | 2 |
461090 | 461090 | 2020-08-23 | Grant | Kentucky | 21081 | 133 | 6 |
461091 | 461091 | 2020-08-23 | Graves | Kentucky | 21083 | 614 | 28 |
461092 | 461092 | 2020-08-23 | Grayson | Kentucky | 21085 | 237 | 11 |
461093 | 461093 | 2020-08-23 | Green | Kentucky | 21087 | 106 | 5 |
461094 | 461094 | 2020-08-23 | Greenup | Kentucky | 21089 | 166 | 1 |
461095 | 461095 | 2020-08-23 | Hancock | Kentucky | 21091 | 55 | 0 |
461096 | 461096 | 2020-08-23 | Hardin | Kentucky | 21093 | 833 | 8 |
461097 | 461097 | 2020-08-23 | Harlan | Kentucky | 21095 | 264 | 5 |
461098 | 461098 | 2020-08-23 | Harrison | Kentucky | 21097 | 139 | 0 |
461099 | 461099 | 2020-08-23 | Hart | Kentucky | 21099 | 129 | 1 |
461100 | 461100 | 2020-08-23 | Henderson | Kentucky | 21101 | 406 | 4 |
461101 | 461101 | 2020-08-23 | Henry | Kentucky | 21103 | 155 | 2 |
461102 | 461102 | 2020-08-23 | Hickman | Kentucky | 21105 | 63 | 0 |
461103 | 461103 | 2020-08-23 | Hopkins | Kentucky | 21107 | 473 | 37 |
461104 | 461104 | 2020-08-23 | Jackson | Kentucky | 21109 | 172 | 15 |
461105 | 461105 | 2020-08-23 | Jefferson | Kentucky | 21111 | 11196 | 277 |
461106 | 461106 | 2020-08-23 | Jessamine | Kentucky | 21113 | 411 | 0 |
461107 | 461107 | 2020-08-23 | Johnson | Kentucky | 21115 | 101 | 0 |
461108 | 461108 | 2020-08-23 | Kenton | Kentucky | 21117 | 1623 | 41 |
461109 | 461109 | 2020-08-23 | Knott | Kentucky | 21119 | 87 | 1 |
461110 | 461110 | 2020-08-23 | Knox | Kentucky | 21121 | 306 | 8 |
461111 | 461111 | 2020-08-23 | Larue | Kentucky | 21123 | 91 | 1 |
461112 | 461112 | 2020-08-23 | Laurel | Kentucky | 21125 | 511 | 5 |
461113 | 461113 | 2020-08-23 | Lawrence | Kentucky | 21127 | 40 | 0 |
461114 | 461114 | 2020-08-23 | Lee | Kentucky | 21129 | 11 | 0 |
461115 | 461115 | 2020-08-23 | Leslie | Kentucky | 21131 | 38 | 0 |
461116 | 461116 | 2020-08-23 | Letcher | Kentucky | 21133 | 66 | 2 |
461117 | 461117 | 2020-08-23 | Lewis | Kentucky | 21135 | 116 | 4 |
461118 | 461118 | 2020-08-23 | Lincoln | Kentucky | 21137 | 130 | 2 |
461119 | 461119 | 2020-08-23 | Livingston | Kentucky | 21139 | 39 | 1 |
461120 | 461120 | 2020-08-23 | Logan | Kentucky | 21141 | 385 | 26 |
461121 | 461121 | 2020-08-23 | Lyon | Kentucky | 21143 | 34 | 4 |
461122 | 461122 | 2020-08-23 | Madison | Kentucky | 21151 | 757 | 2 |
461123 | 461123 | 2020-08-23 | Magoffin | Kentucky | 21153 | 60 | 0 |
461124 | 461124 | 2020-08-23 | Marion | Kentucky | 21155 | 155 | 1 |
461125 | 461125 | 2020-08-23 | Marshall | Kentucky | 21157 | 174 | 2 |
461126 | 461126 | 2020-08-23 | Martin | Kentucky | 21159 | 49 | 0 |
461127 | 461127 | 2020-08-23 | Mason | Kentucky | 21161 | 71 | 2 |
461128 | 461128 | 2020-08-23 | McCracken | Kentucky | 21145 | 453 | 5 |
461129 | 461129 | 2020-08-23 | McCreary | Kentucky | 21147 | 59 | 0 |
461130 | 461130 | 2020-08-23 | McLean | Kentucky | 21149 | 52 | 0 |
461131 | 461131 | 2020-08-23 | Meade | Kentucky | 21163 | 136 | 3 |
461132 | 461132 | 2020-08-23 | Menifee | Kentucky | 21165 | 28 | 0 |
461133 | 461133 | 2020-08-23 | Mercer | Kentucky | 21167 | 105 | 1 |
461134 | 461134 | 2020-08-23 | Metcalfe | Kentucky | 21169 | 81 | 2 |
461135 | 461135 | 2020-08-23 | Monroe | Kentucky | 21171 | 111 | 2 |
461136 | 461136 | 2020-08-23 | Montgomery | Kentucky | 21173 | 170 | 1 |
461137 | 461137 | 2020-08-23 | Morgan | Kentucky | 21175 | 40 | 0 |
461138 | 461138 | 2020-08-23 | Muhlenberg | Kentucky | 21177 | 668 | 11 |
461139 | 461139 | 2020-08-23 | Nelson | Kentucky | 21179 | 312 | 2 |
461140 | 461140 | 2020-08-23 | Nicholas | Kentucky | 21181 | 22 | 1 |
461141 | 461141 | 2020-08-23 | Ohio | Kentucky | 21183 | 392 | 9 |
461142 | 461142 | 2020-08-23 | Oldham | Kentucky | 21185 | 743 | 21 |
461143 | 461143 | 2020-08-23 | Owen | Kentucky | 21187 | 74 | 0 |
461144 | 461144 | 2020-08-23 | Owsley | Kentucky | 21189 | 25 | 0 |
461145 | 461145 | 2020-08-23 | Pendleton | Kentucky | 21191 | 58 | 0 |
461146 | 461146 | 2020-08-23 | Perry | Kentucky | 21193 | 268 | 7 |
461147 | 461147 | 2020-08-23 | Pike | Kentucky | 21195 | 298 | 3 |
461148 | 461148 | 2020-08-23 | Powell | Kentucky | 21197 | 70 | 0 |
461149 | 461149 | 2020-08-23 | Pulaski | Kentucky | 21199 | 468 | 6 |
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);