ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-01-31" 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 |
---|---|---|---|---|---|---|---|
983099 | 983099 | 2021-01-31 | Adair | Kentucky | 21001 | 1535 | 49 |
983100 | 983100 | 2021-01-31 | Allen | Kentucky | 21003 | 1547 | 21 |
983101 | 983101 | 2021-01-31 | Anderson | Kentucky | 21005 | 1447 | 12 |
983102 | 983102 | 2021-01-31 | Ballard | Kentucky | 21007 | 308 | 3 |
983103 | 983103 | 2021-01-31 | Barren | Kentucky | 21009 | 3497 | 39 |
983104 | 983104 | 2021-01-31 | Bath | Kentucky | 21011 | 701 | 14 |
983105 | 983105 | 2021-01-31 | Bell | Kentucky | 21013 | 2433 | 32 |
983106 | 983106 | 2021-01-31 | Boone | Kentucky | 21015 | 11352 | 60 |
983107 | 983107 | 2021-01-31 | Bourbon | Kentucky | 21017 | 1406 | 11 |
983108 | 983108 | 2021-01-31 | Boyd | Kentucky | 21019 | 4257 | 35 |
983109 | 983109 | 2021-01-31 | Boyle | Kentucky | 21021 | 2962 | 25 |
983110 | 983110 | 2021-01-31 | Bracken | Kentucky | 21023 | 446 | 3 |
983111 | 983111 | 2021-01-31 | Breathitt | Kentucky | 21025 | 830 | 3 |
983112 | 983112 | 2021-01-31 | Breckinridge | Kentucky | 21027 | 995 | 5 |
983113 | 983113 | 2021-01-31 | Bullitt | Kentucky | 21029 | 5715 | 33 |
983114 | 983114 | 2021-01-31 | Butler | Kentucky | 21031 | 1159 | 18 |
983115 | 983115 | 2021-01-31 | Caldwell | Kentucky | 21033 | 1155 | 21 |
983116 | 983116 | 2021-01-31 | Calloway | Kentucky | 21035 | 3220 | 33 |
983117 | 983117 | 2021-01-31 | Campbell | Kentucky | 21037 | 7075 | 44 |
983118 | 983118 | 2021-01-31 | Carlisle | Kentucky | 21039 | 404 | 1 |
983119 | 983119 | 2021-01-31 | Carroll | Kentucky | 21041 | 806 | 10 |
983120 | 983120 | 2021-01-31 | Carter | Kentucky | 21043 | 1833 | 20 |
983121 | 983121 | 2021-01-31 | Casey | Kentucky | 21045 | 1157 | 32 |
983122 | 983122 | 2021-01-31 | Christian | Kentucky | 21047 | 5741 | 74 |
983123 | 983123 | 2021-01-31 | Clark | Kentucky | 21049 | 2152 | 16 |
983124 | 983124 | 2021-01-31 | Clay | Kentucky | 21051 | 2197 | 22 |
983125 | 983125 | 2021-01-31 | Clinton | Kentucky | 21053 | 1271 | 26 |
983126 | 983126 | 2021-01-31 | Crittenden | Kentucky | 21055 | 506 | 14 |
983127 | 983127 | 2021-01-31 | Cumberland | Kentucky | 21057 | 607 | 8 |
983128 | 983128 | 2021-01-31 | Daviess | Kentucky | 21059 | 8571 | 141 |
983129 | 983129 | 2021-01-31 | Edmonson | Kentucky | 21061 | 744 | 15 |
983130 | 983130 | 2021-01-31 | Elliott | Kentucky | 21063 | 902 | 1 |
983131 | 983131 | 2021-01-31 | Estill | Kentucky | 21065 | 891 | 0 |
983132 | 983132 | 2021-01-31 | Fayette | Kentucky | 21067 | 29758 | 195 |
983133 | 983133 | 2021-01-31 | Fleming | Kentucky | 21069 | 996 | 12 |
983134 | 983134 | 2021-01-31 | Floyd | Kentucky | 21071 | 2719 | 20 |
983135 | 983135 | 2021-01-31 | Franklin | Kentucky | 21073 | 3191 | 24 |
983136 | 983136 | 2021-01-31 | Fulton | Kentucky | 21075 | 438 | 4 |
983137 | 983137 | 2021-01-31 | Gallatin | Kentucky | 21077 | 572 | 16 |
983138 | 983138 | 2021-01-31 | Garrard | Kentucky | 21079 | 1274 | 4 |
983139 | 983139 | 2021-01-31 | Grant | Kentucky | 21081 | 1831 | 12 |
983140 | 983140 | 2021-01-31 | Graves | Kentucky | 21083 | 3680 | 63 |
983141 | 983141 | 2021-01-31 | Grayson | Kentucky | 21085 | 1734 | 42 |
983142 | 983142 | 2021-01-31 | Green | Kentucky | 21087 | 990 | 13 |
983143 | 983143 | 2021-01-31 | Greenup | Kentucky | 21089 | 3088 | 23 |
983144 | 983144 | 2021-01-31 | Hancock | Kentucky | 21091 | 733 | 14 |
983145 | 983145 | 2021-01-31 | Hardin | Kentucky | 21093 | 7977 | 68 |
983146 | 983146 | 2021-01-31 | Harlan | Kentucky | 21095 | 2223 | 53 |
983147 | 983147 | 2021-01-31 | Harrison | Kentucky | 21097 | 1355 | 5 |
983148 | 983148 | 2021-01-31 | Hart | Kentucky | 21099 | 1644 | 22 |
983149 | 983149 | 2021-01-31 | Henderson | Kentucky | 21101 | 3997 | 57 |
983150 | 983150 | 2021-01-31 | Henry | Kentucky | 21103 | 1079 | 6 |
983151 | 983151 | 2021-01-31 | Hickman | Kentucky | 21105 | 279 | 7 |
983152 | 983152 | 2021-01-31 | Hopkins | Kentucky | 21107 | 3560 | 119 |
983153 | 983153 | 2021-01-31 | Jackson | Kentucky | 21109 | 1107 | 27 |
983154 | 983154 | 2021-01-31 | Jefferson | Kentucky | 21111 | 67578 | 808 |
983155 | 983155 | 2021-01-31 | Jessamine | Kentucky | 21113 | 3655 | 48 |
983156 | 983156 | 2021-01-31 | Johnson | Kentucky | 21115 | 1559 | 17 |
983157 | 983157 | 2021-01-31 | Kenton | Kentucky | 21117 | 13454 | 107 |
983158 | 983158 | 2021-01-31 | Knott | Kentucky | 21119 | 892 | 14 |
983159 | 983159 | 2021-01-31 | Knox | Kentucky | 21121 | 2584 | 11 |
983160 | 983160 | 2021-01-31 | Larue | Kentucky | 21123 | 1062 | 7 |
983161 | 983161 | 2021-01-31 | Laurel | Kentucky | 21125 | 5140 | 18 |
983162 | 983162 | 2021-01-31 | Lawrence | Kentucky | 21127 | 1080 | 10 |
983163 | 983163 | 2021-01-31 | Lee | Kentucky | 21129 | 1127 | 18 |
983164 | 983164 | 2021-01-31 | Leslie | Kentucky | 21131 | 695 | 2 |
983165 | 983165 | 2021-01-31 | Letcher | Kentucky | 21133 | 1494 | 6 |
983166 | 983166 | 2021-01-31 | Lewis | Kentucky | 21135 | 1015 | 30 |
983167 | 983167 | 2021-01-31 | Lincoln | Kentucky | 21137 | 1908 | 30 |
983168 | 983168 | 2021-01-31 | Livingston | Kentucky | 21139 | 646 | 16 |
983169 | 983169 | 2021-01-31 | Logan | Kentucky | 21141 | 2207 | 46 |
983170 | 983170 | 2021-01-31 | Lyon | Kentucky | 21143 | 422 | 12 |
983171 | 983171 | 2021-01-31 | Madison | Kentucky | 21151 | 7585 | 56 |
983172 | 983172 | 2021-01-31 | Magoffin | Kentucky | 21153 | 807 | 1 |
983173 | 983173 | 2021-01-31 | Marion | Kentucky | 21155 | 1917 | 20 |
983174 | 983174 | 2021-01-31 | Marshall | Kentucky | 21157 | 2244 | 35 |
983175 | 983175 | 2021-01-31 | Martin | Kentucky | 21159 | 857 | 11 |
983176 | 983176 | 2021-01-31 | Mason | Kentucky | 21161 | 1244 | 26 |
983177 | 983177 | 2021-01-31 | McCracken | Kentucky | 21145 | 5221 | 56 |
983178 | 983178 | 2021-01-31 | McCreary | Kentucky | 21147 | 1543 | 19 |
983179 | 983179 | 2021-01-31 | McLean | Kentucky | 21149 | 774 | 24 |
983180 | 983180 | 2021-01-31 | Meade | Kentucky | 21163 | 1673 | 7 |
983181 | 983181 | 2021-01-31 | Menifee | Kentucky | 21165 | 333 | 10 |
983182 | 983182 | 2021-01-31 | Mercer | Kentucky | 21167 | 2158 | 14 |
983183 | 983183 | 2021-01-31 | Metcalfe | Kentucky | 21169 | 813 | 13 |
983184 | 983184 | 2021-01-31 | Monroe | Kentucky | 21171 | 1160 | 35 |
983185 | 983185 | 2021-01-31 | Montgomery | Kentucky | 21173 | 1967 | 21 |
983186 | 983186 | 2021-01-31 | Morgan | Kentucky | 21175 | 1910 | 0 |
983187 | 983187 | 2021-01-31 | Muhlenberg | Kentucky | 21177 | 2566 | 50 |
983188 | 983188 | 2021-01-31 | Nelson | Kentucky | 21179 | 4103 | 25 |
983189 | 983189 | 2021-01-31 | Nicholas | Kentucky | 21181 | 420 | 5 |
983190 | 983190 | 2021-01-31 | Ohio | Kentucky | 21183 | 2122 | 45 |
983191 | 983191 | 2021-01-31 | Oldham | Kentucky | 21185 | 6430 | 66 |
983192 | 983192 | 2021-01-31 | Owen | Kentucky | 21187 | 563 | 7 |
983193 | 983193 | 2021-01-31 | Owsley | Kentucky | 21189 | 364 | 10 |
983194 | 983194 | 2021-01-31 | Pendleton | Kentucky | 21191 | 826 | 1 |
983195 | 983195 | 2021-01-31 | Perry | Kentucky | 21193 | 2003 | 25 |
983196 | 983196 | 2021-01-31 | Pike | Kentucky | 21195 | 4549 | 46 |
983197 | 983197 | 2021-01-31 | Powell | Kentucky | 21197 | 884 | 0 |
983198 | 983198 | 2021-01-31 | Pulaski | Kentucky | 21199 | 5191 | 76 |
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);