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-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 |
---|---|---|---|---|---|---|---|
403015 | 403015 | 2020-08-05 | Adair | Kentucky | 21001 | 218 | 19 |
403016 | 403016 | 2020-08-05 | Allen | Kentucky | 21003 | 221 | 8 |
403017 | 403017 | 2020-08-05 | Anderson | Kentucky | 21005 | 80 | 1 |
403018 | 403018 | 2020-08-05 | Ballard | Kentucky | 21007 | 31 | 0 |
403019 | 403019 | 2020-08-05 | Barren | Kentucky | 21009 | 352 | 2 |
403020 | 403020 | 2020-08-05 | Bath | Kentucky | 21011 | 36 | 1 |
403021 | 403021 | 2020-08-05 | Bell | Kentucky | 21013 | 287 | 2 |
403022 | 403022 | 2020-08-05 | Boone | Kentucky | 21015 | 1054 | 24 |
403023 | 403023 | 2020-08-05 | Bourbon | Kentucky | 21017 | 76 | 1 |
403024 | 403024 | 2020-08-05 | Boyd | Kentucky | 21019 | 182 | 3 |
403025 | 403025 | 2020-08-05 | Boyle | Kentucky | 21021 | 144 | 0 |
403026 | 403026 | 2020-08-05 | Bracken | Kentucky | 21023 | 30 | 0 |
403027 | 403027 | 2020-08-05 | Breathitt | Kentucky | 21025 | 28 | 0 |
403028 | 403028 | 2020-08-05 | Breckinridge | Kentucky | 21027 | 55 | 2 |
403029 | 403029 | 2020-08-05 | Bullitt | Kentucky | 21029 | 329 | 4 |
403030 | 403030 | 2020-08-05 | Butler | Kentucky | 21031 | 297 | 15 |
403031 | 403031 | 2020-08-05 | Caldwell | Kentucky | 21033 | 49 | 0 |
403032 | 403032 | 2020-08-05 | Calloway | Kentucky | 21035 | 202 | 4 |
403033 | 403033 | 2020-08-05 | Campbell | Kentucky | 21037 | 548 | 13 |
403034 | 403034 | 2020-08-05 | Carlisle | Kentucky | 21039 | 33 | 1 |
403035 | 403035 | 2020-08-05 | Carroll | Kentucky | 21041 | 148 | 2 |
403036 | 403036 | 2020-08-05 | Carter | Kentucky | 21043 | 99 | 1 |
403037 | 403037 | 2020-08-05 | Casey | Kentucky | 21045 | 201 | 10 |
403038 | 403038 | 2020-08-05 | Christian | Kentucky | 21047 | 607 | 6 |
403039 | 403039 | 2020-08-05 | Clark | Kentucky | 21049 | 168 | 7 |
403040 | 403040 | 2020-08-05 | Clay | Kentucky | 21051 | 145 | 5 |
403041 | 403041 | 2020-08-05 | Clinton | Kentucky | 21053 | 33 | 0 |
403042 | 403042 | 2020-08-05 | Crittenden | Kentucky | 21055 | 26 | 1 |
403043 | 403043 | 2020-08-05 | Cumberland | Kentucky | 21057 | 56 | 0 |
403044 | 403044 | 2020-08-05 | Daviess | Kentucky | 21059 | 735 | 8 |
403045 | 403045 | 2020-08-05 | Edmonson | Kentucky | 21061 | 106 | 12 |
403046 | 403046 | 2020-08-05 | Elliott | Kentucky | 21063 | 8 | 0 |
403047 | 403047 | 2020-08-05 | Estill | Kentucky | 21065 | 18 | 0 |
403048 | 403048 | 2020-08-05 | Fayette | Kentucky | 21067 | 3552 | 46 |
403049 | 403049 | 2020-08-05 | Fleming | Kentucky | 21069 | 57 | 0 |
403050 | 403050 | 2020-08-05 | Floyd | Kentucky | 21071 | 89 | 2 |
403051 | 403051 | 2020-08-05 | Franklin | Kentucky | 21073 | 269 | 5 |
403052 | 403052 | 2020-08-05 | Fulton | Kentucky | 21075 | 69 | 1 |
403053 | 403053 | 2020-08-05 | Gallatin | Kentucky | 21077 | 79 | 8 |
403054 | 403054 | 2020-08-05 | Garrard | Kentucky | 21079 | 71 | 0 |
403055 | 403055 | 2020-08-05 | Grant | Kentucky | 21081 | 107 | 5 |
403056 | 403056 | 2020-08-05 | Graves | Kentucky | 21083 | 525 | 22 |
403057 | 403057 | 2020-08-05 | Grayson | Kentucky | 21085 | 187 | 11 |
403058 | 403058 | 2020-08-05 | Green | Kentucky | 21087 | 39 | 2 |
403059 | 403059 | 2020-08-05 | Greenup | Kentucky | 21089 | 102 | 1 |
403060 | 403060 | 2020-08-05 | Hancock | Kentucky | 21091 | 49 | 0 |
403061 | 403061 | 2020-08-05 | Hardin | Kentucky | 21093 | 553 | 8 |
403062 | 403062 | 2020-08-05 | Harlan | Kentucky | 21095 | 214 | 3 |
403063 | 403063 | 2020-08-05 | Harrison | Kentucky | 21097 | 117 | 0 |
403064 | 403064 | 2020-08-05 | Hart | Kentucky | 21099 | 105 | 0 |
403065 | 403065 | 2020-08-05 | Henderson | Kentucky | 21101 | 330 | 4 |
403066 | 403066 | 2020-08-05 | Henry | Kentucky | 21103 | 105 | 2 |
403067 | 403067 | 2020-08-05 | Hickman | Kentucky | 21105 | 37 | 0 |
403068 | 403068 | 2020-08-05 | Hopkins | Kentucky | 21107 | 415 | 35 |
403069 | 403069 | 2020-08-05 | Jackson | Kentucky | 21109 | 143 | 14 |
403070 | 403070 | 2020-08-05 | Jefferson | Kentucky | 21111 | 7518 | 251 |
403071 | 403071 | 2020-08-05 | Jessamine | Kentucky | 21113 | 318 | 0 |
403072 | 403072 | 2020-08-05 | Johnson | Kentucky | 21115 | 43 | 0 |
403073 | 403073 | 2020-08-05 | Kenton | Kentucky | 21117 | 1362 | 40 |
403074 | 403074 | 2020-08-05 | Knott | Kentucky | 21119 | 48 | 1 |
403075 | 403075 | 2020-08-05 | Knox | Kentucky | 21121 | 222 | 8 |
403076 | 403076 | 2020-08-05 | Larue | Kentucky | 21123 | 65 | 1 |
403077 | 403077 | 2020-08-05 | Laurel | Kentucky | 21125 | 397 | 4 |
403078 | 403078 | 2020-08-05 | Lawrence | Kentucky | 21127 | 36 | 0 |
403079 | 403079 | 2020-08-05 | Lee | Kentucky | 21129 | 5 | 0 |
403080 | 403080 | 2020-08-05 | Leslie | Kentucky | 21131 | 28 | 0 |
403081 | 403081 | 2020-08-05 | Letcher | Kentucky | 21133 | 53 | 0 |
403082 | 403082 | 2020-08-05 | Lewis | Kentucky | 21135 | 37 | 0 |
403083 | 403083 | 2020-08-05 | Lincoln | Kentucky | 21137 | 99 | 1 |
403084 | 403084 | 2020-08-05 | Livingston | Kentucky | 21139 | 33 | 1 |
403085 | 403085 | 2020-08-05 | Logan | Kentucky | 21141 | 318 | 23 |
403086 | 403086 | 2020-08-05 | Lyon | Kentucky | 21143 | 32 | 4 |
403087 | 403087 | 2020-08-05 | Madison | Kentucky | 21151 | 426 | 1 |
403088 | 403088 | 2020-08-05 | Magoffin | Kentucky | 21153 | 31 | 0 |
403089 | 403089 | 2020-08-05 | Marion | Kentucky | 21155 | 117 | 0 |
403090 | 403090 | 2020-08-05 | Marshall | Kentucky | 21157 | 128 | 2 |
403091 | 403091 | 2020-08-05 | Martin | Kentucky | 21159 | 33 | 0 |
403092 | 403092 | 2020-08-05 | Mason | Kentucky | 21161 | 53 | 1 |
403093 | 403093 | 2020-08-05 | McCracken | Kentucky | 21145 | 348 | 4 |
403094 | 403094 | 2020-08-05 | McCreary | Kentucky | 21147 | 41 | 0 |
403095 | 403095 | 2020-08-05 | McLean | Kentucky | 21149 | 43 | 0 |
403096 | 403096 | 2020-08-05 | Meade | Kentucky | 21163 | 105 | 2 |
403097 | 403097 | 2020-08-05 | Menifee | Kentucky | 21165 | 29 | 0 |
403098 | 403098 | 2020-08-05 | Mercer | Kentucky | 21167 | 80 | 0 |
403099 | 403099 | 2020-08-05 | Metcalfe | Kentucky | 21169 | 59 | 2 |
403100 | 403100 | 2020-08-05 | Monroe | Kentucky | 21171 | 90 | 2 |
403101 | 403101 | 2020-08-05 | Montgomery | Kentucky | 21173 | 115 | 0 |
403102 | 403102 | 2020-08-05 | Morgan | Kentucky | 21175 | 30 | 0 |
403103 | 403103 | 2020-08-05 | Muhlenberg | Kentucky | 21177 | 638 | 10 |
403104 | 403104 | 2020-08-05 | Nelson | Kentucky | 21179 | 205 | 2 |
403105 | 403105 | 2020-08-05 | Nicholas | Kentucky | 21181 | 20 | 0 |
403106 | 403106 | 2020-08-05 | Ohio | Kentucky | 21183 | 357 | 8 |
403107 | 403107 | 2020-08-05 | Oldham | Kentucky | 21185 | 586 | 14 |
403108 | 403108 | 2020-08-05 | Owen | Kentucky | 21187 | 43 | 0 |
403109 | 403109 | 2020-08-05 | Owsley | Kentucky | 21189 | 12 | 0 |
403110 | 403110 | 2020-08-05 | Pendleton | Kentucky | 21191 | 41 | 0 |
403111 | 403111 | 2020-08-05 | Perry | Kentucky | 21193 | 200 | 3 |
403112 | 403112 | 2020-08-05 | Pike | Kentucky | 21195 | 233 | 3 |
403113 | 403113 | 2020-08-05 | Powell | Kentucky | 21197 | 50 | 0 |
403114 | 403114 | 2020-08-05 | Pulaski | Kentucky | 21199 | 328 | 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);