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-12-12 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2006108 | 2006108 | 2021-12-12 | Adair | Kentucky | 21001 | 3788 | 88 |
2006109 | 2006109 | 2021-12-12 | Allen | Kentucky | 21003 | 4111 | 77 |
2006110 | 2006110 | 2021-12-12 | Anderson | Kentucky | 21005 | 3928 | 54 |
2006111 | 2006111 | 2021-12-12 | Ballard | Kentucky | 21007 | 782 | 25 |
2006112 | 2006112 | 2021-12-12 | Barren | Kentucky | 21009 | 8841 | 170 |
2006113 | 2006113 | 2021-12-12 | Bath | Kentucky | 21011 | 1894 | 33 |
2006114 | 2006114 | 2021-12-12 | Bell | Kentucky | 21013 | 6060 | 115 |
2006115 | 2006115 | 2021-12-12 | Boone | Kentucky | 21015 | 23625 | 218 |
2006116 | 2006116 | 2021-12-12 | Bourbon | Kentucky | 21017 | 3630 | 41 |
2006117 | 2006117 | 2021-12-12 | Boyd | Kentucky | 21019 | 9350 | 123 |
2006118 | 2006118 | 2021-12-12 | Boyle | Kentucky | 21021 | 5713 | 108 |
2006119 | 2006119 | 2021-12-12 | Bracken | Kentucky | 21023 | 1356 | 19 |
2006120 | 2006120 | 2021-12-12 | Breathitt | Kentucky | 21025 | 2157 | 42 |
2006121 | 2006121 | 2021-12-12 | Breckinridge | Kentucky | 21027 | 3244 | 46 |
2006122 | 2006122 | 2021-12-12 | Bullitt | Kentucky | 21029 | 13199 | 152 |
2006123 | 2006123 | 2021-12-12 | Butler | Kentucky | 21031 | 2561 | 43 |
2006124 | 2006124 | 2021-12-12 | Caldwell | Kentucky | 21033 | 2604 | 52 |
2006125 | 2006125 | 2021-12-12 | Calloway | Kentucky | 21035 | 5439 | 66 |
2006126 | 2006126 | 2021-12-12 | Campbell | Kentucky | 21037 | 14550 | 117 |
2006127 | 2006127 | 2021-12-12 | Carlisle | Kentucky | 21039 | 705 | 12 |
2006128 | 2006128 | 2021-12-12 | Carroll | Kentucky | 21041 | 2196 | 32 |
2006129 | 2006129 | 2021-12-12 | Carter | Kentucky | 21043 | 5042 | 73 |
2006130 | 2006130 | 2021-12-12 | Casey | Kentucky | 21045 | 3000 | 63 |
2006131 | 2006131 | 2021-12-12 | Christian | Kentucky | 21047 | 10912 | 164 |
2006132 | 2006132 | 2021-12-12 | Clark | Kentucky | 21049 | 5803 | 48 |
2006133 | 2006133 | 2021-12-12 | Clay | Kentucky | 21051 | 5246 | 65 |
2006134 | 2006134 | 2021-12-12 | Clinton | Kentucky | 21053 | 2495 | 40 |
2006135 | 2006135 | 2021-12-12 | Crittenden | Kentucky | 21055 | 1387 | 37 |
2006136 | 2006136 | 2021-12-12 | Cumberland | Kentucky | 21057 | 1455 | 22 |
2006137 | 2006137 | 2021-12-12 | Daviess | Kentucky | 21059 | 18974 | 291 |
2006138 | 2006138 | 2021-12-12 | Edmonson | Kentucky | 21061 | 1677 | 34 |
2006139 | 2006139 | 2021-12-12 | Elliott | Kentucky | 21063 | 1426 | 13 |
2006140 | 2006140 | 2021-12-12 | Estill | Kentucky | 21065 | 2503 | 35 |
2006141 | 2006141 | 2021-12-12 | Fayette | Kentucky | 21067 | 55040 | 458 |
2006142 | 2006142 | 2021-12-12 | Fleming | Kentucky | 21069 | 2408 | 40 |
2006143 | 2006143 | 2021-12-12 | Floyd | Kentucky | 21071 | 7748 | 140 |
2006144 | 2006144 | 2021-12-12 | Franklin | Kentucky | 21073 | 7877 | 106 |
2006145 | 2006145 | 2021-12-12 | Fulton | Kentucky | 21075 | 854 | 21 |
2006146 | 2006146 | 2021-12-12 | Gallatin | Kentucky | 21077 | 1401 | 44 |
2006147 | 2006147 | 2021-12-12 | Garrard | Kentucky | 21079 | 3025 | 55 |
2006148 | 2006148 | 2021-12-12 | Grant | Kentucky | 21081 | 5099 | 44 |
2006149 | 2006149 | 2021-12-12 | Graves | Kentucky | 21083 | 7669 | 135 |
2006150 | 2006150 | 2021-12-12 | Grayson | Kentucky | 21085 | 5170 | 100 |
2006151 | 2006151 | 2021-12-12 | Green | Kentucky | 21087 | 2596 | 38 |
2006152 | 2006152 | 2021-12-12 | Greenup | Kentucky | 21089 | 7156 | 102 |
2006153 | 2006153 | 2021-12-12 | Hancock | Kentucky | 21091 | 1554 | 18 |
2006154 | 2006154 | 2021-12-12 | Hardin | Kentucky | 21093 | 19842 | 325 |
2006155 | 2006155 | 2021-12-12 | Harlan | Kentucky | 21095 | 6048 | 147 |
2006156 | 2006156 | 2021-12-12 | Harrison | Kentucky | 21097 | 3792 | 52 |
2006157 | 2006157 | 2021-12-12 | Hart | Kentucky | 21099 | 3845 | 77 |
2006158 | 2006158 | 2021-12-12 | Henderson | Kentucky | 21101 | 8580 | 128 |
2006159 | 2006159 | 2021-12-12 | Henry | Kentucky | 21103 | 2929 | 35 |
2006160 | 2006160 | 2021-12-12 | Hickman | Kentucky | 21105 | 594 | 22 |
2006161 | 2006161 | 2021-12-12 | Hopkins | Kentucky | 21107 | 9162 | 219 |
2006162 | 2006162 | 2021-12-12 | Jackson | Kentucky | 21109 | 2936 | 55 |
2006163 | 2006163 | 2021-12-12 | Jefferson | Kentucky | 21111 | 129413 | 1780 |
2006164 | 2006164 | 2021-12-12 | Jessamine | Kentucky | 21113 | 8919 | 108 |
2006165 | 2006165 | 2021-12-12 | Johnson | Kentucky | 21115 | 4020 | 74 |
2006166 | 2006166 | 2021-12-12 | Kenton | Kentucky | 21117 | 27831 | 301 |
2006167 | 2006167 | 2021-12-12 | Knott | Kentucky | 21119 | 2563 | 43 |
2006168 | 2006168 | 2021-12-12 | Knox | Kentucky | 21121 | 7697 | 97 |
2006169 | 2006169 | 2021-12-12 | Larue | Kentucky | 21123 | 2536 | 53 |
2006170 | 2006170 | 2021-12-12 | Laurel | Kentucky | 21125 | 13515 | 168 |
2006171 | 2006171 | 2021-12-12 | Lawrence | Kentucky | 21127 | 3010 | 44 |
2006172 | 2006172 | 2021-12-12 | Lee | Kentucky | 21129 | 1825 | 39 |
2006173 | 2006173 | 2021-12-12 | Leslie | Kentucky | 21131 | 2343 | 33 |
2006174 | 2006174 | 2021-12-12 | Letcher | Kentucky | 21133 | 4282 | 80 |
2006175 | 2006175 | 2021-12-12 | Lewis | Kentucky | 21135 | 2869 | 64 |
2006176 | 2006176 | 2021-12-12 | Lincoln | Kentucky | 21137 | 4573 | 105 |
2006177 | 2006177 | 2021-12-12 | Livingston | Kentucky | 21139 | 1552 | 47 |
2006178 | 2006178 | 2021-12-12 | Logan | Kentucky | 21141 | 5377 | 93 |
2006179 | 2006179 | 2021-12-12 | Lyon | Kentucky | 21143 | 2061 | 28 |
2006180 | 2006180 | 2021-12-12 | Madison | Kentucky | 21151 | 17586 | 206 |
2006181 | 2006181 | 2021-12-12 | Magoffin | Kentucky | 21153 | 2541 | 31 |
2006182 | 2006182 | 2021-12-12 | Marion | Kentucky | 21155 | 4274 | 57 |
2006183 | 2006183 | 2021-12-12 | Marshall | Kentucky | 21157 | 5304 | 85 |
2006184 | 2006184 | 2021-12-12 | Martin | Kentucky | 21159 | 2104 | 37 |
2006185 | 2006185 | 2021-12-12 | Mason | Kentucky | 21161 | 2832 | 78 |
2006186 | 2006186 | 2021-12-12 | McCracken | Kentucky | 21145 | 11073 | 198 |
2006187 | 2006187 | 2021-12-12 | McCreary | Kentucky | 21147 | 4028 | 65 |
2006188 | 2006188 | 2021-12-12 | McLean | Kentucky | 21149 | 1679 | 40 |
2006189 | 2006189 | 2021-12-12 | Meade | Kentucky | 21163 | 3691 | 47 |
2006190 | 2006190 | 2021-12-12 | Menifee | Kentucky | 21165 | 992 | 25 |
2006191 | 2006191 | 2021-12-12 | Mercer | Kentucky | 21167 | 4786 | 90 |
2006192 | 2006192 | 2021-12-12 | Metcalfe | Kentucky | 21169 | 2097 | 48 |
2006193 | 2006193 | 2021-12-12 | Monroe | Kentucky | 21171 | 2513 | 66 |
2006194 | 2006194 | 2021-12-12 | Montgomery | Kentucky | 21173 | 4833 | 69 |
2006195 | 2006195 | 2021-12-12 | Morgan | Kentucky | 21175 | 3086 | 16 |
2006196 | 2006196 | 2021-12-12 | Muhlenberg | Kentucky | 21177 | 6108 | 97 |
2006197 | 2006197 | 2021-12-12 | Nelson | Kentucky | 21179 | 9111 | 107 |
2006198 | 2006198 | 2021-12-12 | Nicholas | Kentucky | 21181 | 1294 | 27 |
2006199 | 2006199 | 2021-12-12 | Ohio | Kentucky | 21183 | 4756 | 89 |
2006200 | 2006200 | 2021-12-12 | Oldham | Kentucky | 21185 | 11052 | 107 |
2006201 | 2006201 | 2021-12-12 | Owen | Kentucky | 21187 | 1581 | 28 |
2006202 | 2006202 | 2021-12-12 | Owsley | Kentucky | 21189 | 1045 | 22 |
2006203 | 2006203 | 2021-12-12 | Pendleton | Kentucky | 21191 | 2229 | 26 |
2006204 | 2006204 | 2021-12-12 | Perry | Kentucky | 21193 | 6566 | 125 |
2006205 | 2006205 | 2021-12-12 | Pike | Kentucky | 21195 | 11593 | 213 |
2006206 | 2006206 | 2021-12-12 | Powell | Kentucky | 21197 | 2967 | 25 |
2006207 | 2006207 | 2021-12-12 | Pulaski | Kentucky | 21199 | 12242 | 217 |
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);