ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where "date" is on date 2020-06-15 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 |
---|---|---|---|---|---|---|---|
241101 | 241101 | 2020-06-15 | Adair | Kentucky | 21001 | 102 | 19 |
241102 | 241102 | 2020-06-15 | Allen | Kentucky | 21003 | 136 | 4 |
241103 | 241103 | 2020-06-15 | Anderson | Kentucky | 21005 | 25 | 1 |
241104 | 241104 | 2020-06-15 | Ballard | Kentucky | 21007 | 15 | 0 |
241105 | 241105 | 2020-06-15 | Barren | Kentucky | 21009 | 66 | 2 |
241106 | 241106 | 2020-06-15 | Bath | Kentucky | 21011 | 10 | 1 |
241107 | 241107 | 2020-06-15 | Bell | Kentucky | 21013 | 4 | 0 |
241108 | 241108 | 2020-06-15 | Boone | Kentucky | 21015 | 541 | 21 |
241109 | 241109 | 2020-06-15 | Bourbon | Kentucky | 21017 | 25 | 1 |
241110 | 241110 | 2020-06-15 | Boyd | Kentucky | 21019 | 44 | 3 |
241111 | 241111 | 2020-06-15 | Boyle | Kentucky | 21021 | 30 | 0 |
241112 | 241112 | 2020-06-15 | Bracken | Kentucky | 21023 | 14 | 0 |
241113 | 241113 | 2020-06-15 | Breathitt | Kentucky | 21025 | 4 | 0 |
241114 | 241114 | 2020-06-15 | Breckinridge | Kentucky | 21027 | 23 | 2 |
241115 | 241115 | 2020-06-15 | Bullitt | Kentucky | 21029 | 135 | 4 |
241116 | 241116 | 2020-06-15 | Butler | Kentucky | 21031 | 244 | 13 |
241117 | 241117 | 2020-06-15 | Caldwell | Kentucky | 21033 | 12 | 0 |
241118 | 241118 | 2020-06-15 | Calloway | Kentucky | 21035 | 60 | 1 |
241119 | 241119 | 2020-06-15 | Campbell | Kentucky | 21037 | 207 | 12 |
241120 | 241120 | 2020-06-15 | Carlisle | Kentucky | 21039 | 5 | 1 |
241121 | 241121 | 2020-06-15 | Carroll | Kentucky | 21041 | 17 | 0 |
241122 | 241122 | 2020-06-15 | Carter | Kentucky | 21043 | 18 | 0 |
241123 | 241123 | 2020-06-15 | Casey | Kentucky | 21045 | 10 | 0 |
241124 | 241124 | 2020-06-15 | Christian | Kentucky | 21047 | 159 | 3 |
241125 | 241125 | 2020-06-15 | Clark | Kentucky | 21049 | 77 | 0 |
241126 | 241126 | 2020-06-15 | Clay | Kentucky | 21051 | 17 | 2 |
241127 | 241127 | 2020-06-15 | Clinton | Kentucky | 21053 | 5 | 0 |
241128 | 241128 | 2020-06-15 | Crittenden | Kentucky | 21055 | 7 | 1 |
241129 | 241129 | 2020-06-15 | Cumberland | Kentucky | 21057 | 5 | 0 |
241130 | 241130 | 2020-06-15 | Daviess | Kentucky | 21059 | 360 | 8 |
241131 | 241131 | 2020-06-15 | Edmonson | Kentucky | 21061 | 73 | 11 |
241132 | 241132 | 2020-06-15 | Elliott | Kentucky | 21063 | 2 | 0 |
241133 | 241133 | 2020-06-15 | Estill | Kentucky | 21065 | 5 | 0 |
241134 | 241134 | 2020-06-15 | Fayette | Kentucky | 21067 | 1129 | 20 |
241135 | 241135 | 2020-06-15 | Fleming | Kentucky | 21069 | 6 | 0 |
241136 | 241136 | 2020-06-15 | Floyd | Kentucky | 21071 | 19 | 0 |
241137 | 241137 | 2020-06-15 | Franklin | Kentucky | 21073 | 98 | 2 |
241138 | 241138 | 2020-06-15 | Fulton | Kentucky | 21075 | 12 | 0 |
241139 | 241139 | 2020-06-15 | Gallatin | Kentucky | 21077 | 57 | 7 |
241140 | 241140 | 2020-06-15 | Garrard | Kentucky | 21079 | 11 | 0 |
241141 | 241141 | 2020-06-15 | Grant | Kentucky | 21081 | 53 | 4 |
241142 | 241142 | 2020-06-15 | Graves | Kentucky | 21083 | 175 | 20 |
241143 | 241143 | 2020-06-15 | Grayson | Kentucky | 21085 | 137 | 11 |
241144 | 241144 | 2020-06-15 | Green | Kentucky | 21087 | 3 | 0 |
241145 | 241145 | 2020-06-15 | Greenup | Kentucky | 21089 | 16 | 0 |
241146 | 241146 | 2020-06-15 | Hancock | Kentucky | 21091 | 12 | 0 |
241147 | 241147 | 2020-06-15 | Hardin | Kentucky | 21093 | 133 | 5 |
241148 | 241148 | 2020-06-15 | Harlan | Kentucky | 21095 | 13 | 0 |
241149 | 241149 | 2020-06-15 | Harrison | Kentucky | 21097 | 56 | 0 |
241150 | 241150 | 2020-06-15 | Hart | Kentucky | 21099 | 36 | 0 |
241151 | 241151 | 2020-06-15 | Henderson | Kentucky | 21101 | 138 | 4 |
241152 | 241152 | 2020-06-15 | Henry | Kentucky | 21103 | 26 | 2 |
241153 | 241153 | 2020-06-15 | Hickman | Kentucky | 21105 | 5 | 0 |
241154 | 241154 | 2020-06-15 | Hopkins | Kentucky | 21107 | 230 | 32 |
241155 | 241155 | 2020-06-15 | Jackson | Kentucky | 21109 | 63 | 13 |
241156 | 241156 | 2020-06-15 | Jefferson | Kentucky | 21111 | 3363 | 188 |
241157 | 241157 | 2020-06-15 | Jessamine | Kentucky | 21113 | 83 | 0 |
241158 | 241158 | 2020-06-15 | Johnson | Kentucky | 21115 | 6 | 0 |
241159 | 241159 | 2020-06-15 | Kenton | Kentucky | 21117 | 690 | 37 |
241160 | 241160 | 2020-06-15 | Knott | Kentucky | 21119 | 4 | 0 |
241161 | 241161 | 2020-06-15 | Knox | Kentucky | 21121 | 11 | 0 |
241162 | 241162 | 2020-06-15 | Larue | Kentucky | 21123 | 15 | 1 |
241163 | 241163 | 2020-06-15 | Laurel | Kentucky | 21125 | 30 | 2 |
241164 | 241164 | 2020-06-15 | Lawrence | Kentucky | 21127 | 5 | 0 |
241165 | 241165 | 2020-06-15 | Lee | Kentucky | 21129 | 1 | 0 |
241166 | 241166 | 2020-06-15 | Leslie | Kentucky | 21131 | 6 | 0 |
241167 | 241167 | 2020-06-15 | Letcher | Kentucky | 21133 | 8 | 0 |
241168 | 241168 | 2020-06-15 | Lewis | Kentucky | 21135 | 14 | 0 |
241169 | 241169 | 2020-06-15 | Lincoln | Kentucky | 21137 | 15 | 1 |
241170 | 241170 | 2020-06-15 | Livingston | Kentucky | 21139 | 9 | 0 |
241171 | 241171 | 2020-06-15 | Logan | Kentucky | 21141 | 206 | 9 |
241172 | 241172 | 2020-06-15 | Lyon | Kentucky | 21143 | 18 | 3 |
241173 | 241173 | 2020-06-15 | Madison | Kentucky | 21151 | 88 | 1 |
241174 | 241174 | 2020-06-15 | Magoffin | Kentucky | 21153 | 4 | 0 |
241175 | 241175 | 2020-06-15 | Marion | Kentucky | 21155 | 42 | 0 |
241176 | 241176 | 2020-06-15 | Marshall | Kentucky | 21157 | 44 | 2 |
241177 | 241177 | 2020-06-15 | Martin | Kentucky | 21159 | 3 | 0 |
241178 | 241178 | 2020-06-15 | Mason | Kentucky | 21161 | 16 | 0 |
241179 | 241179 | 2020-06-15 | McCracken | Kentucky | 21145 | 123 | 3 |
241180 | 241180 | 2020-06-15 | McCreary | Kentucky | 21147 | 13 | 0 |
241181 | 241181 | 2020-06-15 | McLean | Kentucky | 21149 | 25 | 0 |
241182 | 241182 | 2020-06-15 | Meade | Kentucky | 21163 | 24 | 2 |
241183 | 241183 | 2020-06-15 | Menifee | Kentucky | 21165 | 11 | 0 |
241184 | 241184 | 2020-06-15 | Mercer | Kentucky | 21167 | 16 | 0 |
241185 | 241185 | 2020-06-15 | Metcalfe | Kentucky | 21169 | 8 | 2 |
241186 | 241186 | 2020-06-15 | Monroe | Kentucky | 21171 | 31 | 0 |
241187 | 241187 | 2020-06-15 | Montgomery | Kentucky | 21173 | 39 | 0 |
241188 | 241188 | 2020-06-15 | Morgan | Kentucky | 21175 | 6 | 0 |
241189 | 241189 | 2020-06-15 | Muhlenberg | Kentucky | 21177 | 503 | 8 |
241190 | 241190 | 2020-06-15 | Nelson | Kentucky | 21179 | 48 | 1 |
241191 | 241191 | 2020-06-15 | Nicholas | Kentucky | 21181 | 4 | 0 |
241192 | 241192 | 2020-06-15 | Ohio | Kentucky | 21183 | 185 | 0 |
241193 | 241193 | 2020-06-15 | Oldham | Kentucky | 21185 | 113 | 6 |
241194 | 241194 | 2020-06-15 | Owen | Kentucky | 21187 | 4 | 0 |
241195 | 241195 | 2020-06-15 | Owsley | Kentucky | 21189 | 2 | 0 |
241196 | 241196 | 2020-06-15 | Pendleton | Kentucky | 21191 | 14 | 0 |
241197 | 241197 | 2020-06-15 | Perry | Kentucky | 21193 | 28 | 0 |
241198 | 241198 | 2020-06-15 | Pike | Kentucky | 21195 | 48 | 2 |
241199 | 241199 | 2020-06-15 | Powell | Kentucky | 21197 | 5 | 0 |
241200 | 241200 | 2020-06-15 | Pulaski | Kentucky | 21199 | 72 | 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);