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 2021-11-18 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1928095 | 1928095 | 2021-11-18 | Adair | Kentucky | 21001 | 3574 | 83 |
1928096 | 1928096 | 2021-11-18 | Allen | Kentucky | 21003 | 3881 | 70 |
1928097 | 1928097 | 2021-11-18 | Anderson | Kentucky | 21005 | 3681 | 50 |
1928098 | 1928098 | 2021-11-18 | Ballard | Kentucky | 21007 | 719 | 20 |
1928099 | 1928099 | 2021-11-18 | Barren | Kentucky | 21009 | 8289 | 155 |
1928100 | 1928100 | 2021-11-18 | Bath | Kentucky | 21011 | 1698 | 31 |
1928101 | 1928101 | 2021-11-18 | Bell | Kentucky | 21013 | 5911 | 99 |
1928102 | 1928102 | 2021-11-18 | Boone | Kentucky | 21015 | 22112 | 216 |
1928103 | 1928103 | 2021-11-18 | Bourbon | Kentucky | 21017 | 3375 | 36 |
1928104 | 1928104 | 2021-11-18 | Boyd | Kentucky | 21019 | 8769 | 109 |
1928105 | 1928105 | 2021-11-18 | Boyle | Kentucky | 21021 | 5556 | 84 |
1928106 | 1928106 | 2021-11-18 | Bracken | Kentucky | 21023 | 1218 | 12 |
1928107 | 1928107 | 2021-11-18 | Breathitt | Kentucky | 21025 | 2076 | 38 |
1928108 | 1928108 | 2021-11-18 | Breckinridge | Kentucky | 21027 | 3012 | 36 |
1928109 | 1928109 | 2021-11-18 | Bullitt | Kentucky | 21029 | 12532 | 134 |
1928110 | 1928110 | 2021-11-18 | Butler | Kentucky | 21031 | 2430 | 40 |
1928111 | 1928111 | 2021-11-18 | Caldwell | Kentucky | 21033 | 2483 | 50 |
1928112 | 1928112 | 2021-11-18 | Calloway | Kentucky | 21035 | 5264 | 62 |
1928113 | 1928113 | 2021-11-18 | Campbell | Kentucky | 21037 | 13643 | 114 |
1928114 | 1928114 | 2021-11-18 | Carlisle | Kentucky | 21039 | 667 | 12 |
1928115 | 1928115 | 2021-11-18 | Carroll | Kentucky | 21041 | 1997 | 29 |
1928116 | 1928116 | 2021-11-18 | Carter | Kentucky | 21043 | 4723 | 66 |
1928117 | 1928117 | 2021-11-18 | Casey | Kentucky | 21045 | 2887 | 58 |
1928118 | 1928118 | 2021-11-18 | Christian | Kentucky | 21047 | 10467 | 133 |
1928119 | 1928119 | 2021-11-18 | Clark | Kentucky | 21049 | 5489 | 43 |
1928120 | 1928120 | 2021-11-18 | Clay | Kentucky | 21051 | 5174 | 61 |
1928121 | 1928121 | 2021-11-18 | Clinton | Kentucky | 21053 | 2350 | 35 |
1928122 | 1928122 | 2021-11-18 | Crittenden | Kentucky | 21055 | 1294 | 35 |
1928123 | 1928123 | 2021-11-18 | Cumberland | Kentucky | 21057 | 1329 | 21 |
1928124 | 1928124 | 2021-11-18 | Daviess | Kentucky | 21059 | 17747 | 272 |
1928125 | 1928125 | 2021-11-18 | Edmonson | Kentucky | 21061 | 1597 | 32 |
1928126 | 1928126 | 2021-11-18 | Elliott | Kentucky | 21063 | 1374 | 9 |
1928127 | 1928127 | 2021-11-18 | Estill | Kentucky | 21065 | 2313 | 14 |
1928128 | 1928128 | 2021-11-18 | Fayette | Kentucky | 21067 | 53002 | 430 |
1928129 | 1928129 | 2021-11-18 | Fleming | Kentucky | 21069 | 2252 | 36 |
1928130 | 1928130 | 2021-11-18 | Floyd | Kentucky | 21071 | 7334 | 116 |
1928131 | 1928131 | 2021-11-18 | Franklin | Kentucky | 21073 | 7400 | 87 |
1928132 | 1928132 | 2021-11-18 | Fulton | Kentucky | 21075 | 798 | 18 |
1928133 | 1928133 | 2021-11-18 | Gallatin | Kentucky | 21077 | 1301 | 41 |
1928134 | 1928134 | 2021-11-18 | Garrard | Kentucky | 21079 | 2886 | 51 |
1928135 | 1928135 | 2021-11-18 | Grant | Kentucky | 21081 | 4672 | 41 |
1928136 | 1928136 | 2021-11-18 | Graves | Kentucky | 21083 | 7358 | 128 |
1928137 | 1928137 | 2021-11-18 | Grayson | Kentucky | 21085 | 4932 | 96 |
1928138 | 1928138 | 2021-11-18 | Green | Kentucky | 21087 | 2544 | 36 |
1928139 | 1928139 | 2021-11-18 | Greenup | Kentucky | 21089 | 6684 | 84 |
1928140 | 1928140 | 2021-11-18 | Hancock | Kentucky | 21091 | 1440 | 18 |
1928141 | 1928141 | 2021-11-18 | Hardin | Kentucky | 21093 | 18648 | 297 |
1928142 | 1928142 | 2021-11-18 | Harlan | Kentucky | 21095 | 5613 | 133 |
1928143 | 1928143 | 2021-11-18 | Harrison | Kentucky | 21097 | 3508 | 41 |
1928144 | 1928144 | 2021-11-18 | Hart | Kentucky | 21099 | 3652 | 69 |
1928145 | 1928145 | 2021-11-18 | Henderson | Kentucky | 21101 | 8171 | 108 |
1928146 | 1928146 | 2021-11-18 | Henry | Kentucky | 21103 | 2736 | 32 |
1928147 | 1928147 | 2021-11-18 | Hickman | Kentucky | 21105 | 580 | 20 |
1928148 | 1928148 | 2021-11-18 | Hopkins | Kentucky | 21107 | 8722 | 208 |
1928149 | 1928149 | 2021-11-18 | Jackson | Kentucky | 21109 | 2782 | 51 |
1928150 | 1928150 | 2021-11-18 | Jefferson | Kentucky | 21111 | 123769 | 1666 |
1928151 | 1928151 | 2021-11-18 | Jessamine | Kentucky | 21113 | 8372 | 102 |
1928152 | 1928152 | 2021-11-18 | Johnson | Kentucky | 21115 | 3864 | 50 |
1928153 | 1928153 | 2021-11-18 | Kenton | Kentucky | 21117 | 25927 | 285 |
1928154 | 1928154 | 2021-11-18 | Knott | Kentucky | 21119 | 2484 | 43 |
1928155 | 1928155 | 2021-11-18 | Knox | Kentucky | 21121 | 7309 | 60 |
1928156 | 1928156 | 2021-11-18 | Larue | Kentucky | 21123 | 2421 | 53 |
1928157 | 1928157 | 2021-11-18 | Laurel | Kentucky | 21125 | 13075 | 138 |
1928158 | 1928158 | 2021-11-18 | Lawrence | Kentucky | 21127 | 2746 | 42 |
1928159 | 1928159 | 2021-11-18 | Lee | Kentucky | 21129 | 1789 | 34 |
1928160 | 1928160 | 2021-11-18 | Leslie | Kentucky | 21131 | 2247 | 30 |
1928161 | 1928161 | 2021-11-18 | Letcher | Kentucky | 21133 | 4060 | 72 |
1928162 | 1928162 | 2021-11-18 | Lewis | Kentucky | 21135 | 2672 | 58 |
1928163 | 1928163 | 2021-11-18 | Lincoln | Kentucky | 21137 | 4441 | 100 |
1928164 | 1928164 | 2021-11-18 | Livingston | Kentucky | 21139 | 1456 | 45 |
1928165 | 1928165 | 2021-11-18 | Logan | Kentucky | 21141 | 5176 | 88 |
1928166 | 1928166 | 2021-11-18 | Lyon | Kentucky | 21143 | 1992 | 26 |
1928167 | 1928167 | 2021-11-18 | Madison | Kentucky | 21151 | 16421 | 189 |
1928168 | 1928168 | 2021-11-18 | Magoffin | Kentucky | 21153 | 2348 | 24 |
1928169 | 1928169 | 2021-11-18 | Marion | Kentucky | 21155 | 4038 | 50 |
1928170 | 1928170 | 2021-11-18 | Marshall | Kentucky | 21157 | 5128 | 80 |
1928171 | 1928171 | 2021-11-18 | Martin | Kentucky | 21159 | 2007 | 36 |
1928172 | 1928172 | 2021-11-18 | Mason | Kentucky | 21161 | 2661 | 71 |
1928173 | 1928173 | 2021-11-18 | McCracken | Kentucky | 21145 | 10430 | 183 |
1928174 | 1928174 | 2021-11-18 | McCreary | Kentucky | 21147 | 3872 | 59 |
1928175 | 1928175 | 2021-11-18 | McLean | Kentucky | 21149 | 1531 | 40 |
1928176 | 1928176 | 2021-11-18 | Meade | Kentucky | 21163 | 3544 | 40 |
1928177 | 1928177 | 2021-11-18 | Menifee | Kentucky | 21165 | 877 | 23 |
1928178 | 1928178 | 2021-11-18 | Mercer | Kentucky | 21167 | 4625 | 76 |
1928179 | 1928179 | 2021-11-18 | Metcalfe | Kentucky | 21169 | 1965 | 44 |
1928180 | 1928180 | 2021-11-18 | Monroe | Kentucky | 21171 | 2373 | 62 |
1928181 | 1928181 | 2021-11-18 | Montgomery | Kentucky | 21173 | 4667 | 60 |
1928182 | 1928182 | 2021-11-18 | Morgan | Kentucky | 21175 | 2965 | 10 |
1928183 | 1928183 | 2021-11-18 | Muhlenberg | Kentucky | 21177 | 5810 | 94 |
1928184 | 1928184 | 2021-11-18 | Nelson | Kentucky | 21179 | 8631 | 98 |
1928185 | 1928185 | 2021-11-18 | Nicholas | Kentucky | 21181 | 1233 | 21 |
1928186 | 1928186 | 2021-11-18 | Ohio | Kentucky | 21183 | 4489 | 84 |
1928187 | 1928187 | 2021-11-18 | Oldham | Kentucky | 21185 | 10421 | 95 |
1928188 | 1928188 | 2021-11-18 | Owen | Kentucky | 21187 | 1444 | 27 |
1928189 | 1928189 | 2021-11-18 | Owsley | Kentucky | 21189 | 1027 | 19 |
1928190 | 1928190 | 2021-11-18 | Pendleton | Kentucky | 21191 | 2115 | 21 |
1928191 | 1928191 | 2021-11-18 | Perry | Kentucky | 21193 | 6349 | 112 |
1928192 | 1928192 | 2021-11-18 | Pike | Kentucky | 21195 | 11041 | 198 |
1928193 | 1928193 | 2021-11-18 | Powell | Kentucky | 21197 | 2705 | 23 |
1928194 | 1928194 | 2021-11-18 | Pulaski | Kentucky | 21199 | 11817 | 194 |
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);