ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-11-22" 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 |
---|---|---|---|---|---|---|---|
1941097 | 1941097 | 2021-11-22 | Adair | Kentucky | 21001 | 3598 | 83 |
1941098 | 1941098 | 2021-11-22 | Allen | Kentucky | 21003 | 3901 | 72 |
1941099 | 1941099 | 2021-11-22 | Anderson | Kentucky | 21005 | 3709 | 52 |
1941100 | 1941100 | 2021-11-22 | Ballard | Kentucky | 21007 | 727 | 21 |
1941101 | 1941101 | 2021-11-22 | Barren | Kentucky | 21009 | 8352 | 158 |
1941102 | 1941102 | 2021-11-22 | Bath | Kentucky | 21011 | 1732 | 32 |
1941103 | 1941103 | 2021-11-22 | Bell | Kentucky | 21013 | 5914 | 102 |
1941104 | 1941104 | 2021-11-22 | Boone | Kentucky | 21015 | 22358 | 216 |
1941105 | 1941105 | 2021-11-22 | Bourbon | Kentucky | 21017 | 3431 | 37 |
1941106 | 1941106 | 2021-11-22 | Boyd | Kentucky | 21019 | 8808 | 112 |
1941107 | 1941107 | 2021-11-22 | Boyle | Kentucky | 21021 | 5579 | 92 |
1941108 | 1941108 | 2021-11-22 | Bracken | Kentucky | 21023 | 1242 | 13 |
1941109 | 1941109 | 2021-11-22 | Breathitt | Kentucky | 21025 | 2088 | 40 |
1941110 | 1941110 | 2021-11-22 | Breckinridge | Kentucky | 21027 | 3053 | 37 |
1941111 | 1941111 | 2021-11-22 | Bullitt | Kentucky | 21029 | 12573 | 138 |
1941112 | 1941112 | 2021-11-22 | Butler | Kentucky | 21031 | 2449 | 40 |
1941113 | 1941113 | 2021-11-22 | Caldwell | Kentucky | 21033 | 2499 | 51 |
1941114 | 1941114 | 2021-11-22 | Calloway | Kentucky | 21035 | 5282 | 64 |
1941115 | 1941115 | 2021-11-22 | Campbell | Kentucky | 21037 | 13780 | 115 |
1941116 | 1941116 | 2021-11-22 | Carlisle | Kentucky | 21039 | 670 | 12 |
1941117 | 1941117 | 2021-11-22 | Carroll | Kentucky | 21041 | 2015 | 30 |
1941118 | 1941118 | 2021-11-22 | Carter | Kentucky | 21043 | 4772 | 67 |
1941119 | 1941119 | 2021-11-22 | Casey | Kentucky | 21045 | 2895 | 58 |
1941120 | 1941120 | 2021-11-22 | Christian | Kentucky | 21047 | 10498 | 145 |
1941121 | 1941121 | 2021-11-22 | Clark | Kentucky | 21049 | 5522 | 45 |
1941122 | 1941122 | 2021-11-22 | Clay | Kentucky | 21051 | 5168 | 62 |
1941123 | 1941123 | 2021-11-22 | Clinton | Kentucky | 21053 | 2354 | 35 |
1941124 | 1941124 | 2021-11-22 | Crittenden | Kentucky | 21055 | 1317 | 36 |
1941125 | 1941125 | 2021-11-22 | Cumberland | Kentucky | 21057 | 1332 | 21 |
1941126 | 1941126 | 2021-11-22 | Daviess | Kentucky | 21059 | 17891 | 278 |
1941127 | 1941127 | 2021-11-22 | Edmonson | Kentucky | 21061 | 1601 | 32 |
1941128 | 1941128 | 2021-11-22 | Elliott | Kentucky | 21063 | 1383 | 10 |
1941129 | 1941129 | 2021-11-22 | Estill | Kentucky | 21065 | 2333 | 18 |
1941130 | 1941130 | 2021-11-22 | Fayette | Kentucky | 21067 | 53134 | 439 |
1941131 | 1941131 | 2021-11-22 | Fleming | Kentucky | 21069 | 2259 | 37 |
1941132 | 1941132 | 2021-11-22 | Floyd | Kentucky | 21071 | 7402 | 120 |
1941133 | 1941133 | 2021-11-22 | Franklin | Kentucky | 21073 | 7461 | 95 |
1941134 | 1941134 | 2021-11-22 | Fulton | Kentucky | 21075 | 816 | 20 |
1941135 | 1941135 | 2021-11-22 | Gallatin | Kentucky | 21077 | 1309 | 41 |
1941136 | 1941136 | 2021-11-22 | Garrard | Kentucky | 21079 | 2917 | 51 |
1941137 | 1941137 | 2021-11-22 | Grant | Kentucky | 21081 | 4738 | 44 |
1941138 | 1941138 | 2021-11-22 | Graves | Kentucky | 21083 | 7389 | 130 |
1941139 | 1941139 | 2021-11-22 | Grayson | Kentucky | 21085 | 4946 | 99 |
1941140 | 1941140 | 2021-11-22 | Green | Kentucky | 21087 | 2545 | 36 |
1941141 | 1941141 | 2021-11-22 | Greenup | Kentucky | 21089 | 6757 | 91 |
1941142 | 1941142 | 2021-11-22 | Hancock | Kentucky | 21091 | 1454 | 18 |
1941143 | 1941143 | 2021-11-22 | Hardin | Kentucky | 21093 | 18765 | 300 |
1941144 | 1941144 | 2021-11-22 | Harlan | Kentucky | 21095 | 5648 | 136 |
1941145 | 1941145 | 2021-11-22 | Harrison | Kentucky | 21097 | 3544 | 47 |
1941146 | 1941146 | 2021-11-22 | Hart | Kentucky | 21099 | 3667 | 71 |
1941147 | 1941147 | 2021-11-22 | Henderson | Kentucky | 21101 | 8196 | 122 |
1941148 | 1941148 | 2021-11-22 | Henry | Kentucky | 21103 | 2755 | 33 |
1941149 | 1941149 | 2021-11-22 | Hickman | Kentucky | 21105 | 581 | 21 |
1941150 | 1941150 | 2021-11-22 | Hopkins | Kentucky | 21107 | 8790 | 209 |
1941151 | 1941151 | 2021-11-22 | Jackson | Kentucky | 21109 | 2796 | 51 |
1941152 | 1941152 | 2021-11-22 | Jefferson | Kentucky | 21111 | 124525 | 1690 |
1941153 | 1941153 | 2021-11-22 | Jessamine | Kentucky | 21113 | 8455 | 105 |
1941154 | 1941154 | 2021-11-22 | Johnson | Kentucky | 21115 | 3886 | 55 |
1941155 | 1941155 | 2021-11-22 | Kenton | Kentucky | 21117 | 26213 | 285 |
1941156 | 1941156 | 2021-11-22 | Knott | Kentucky | 21119 | 2493 | 43 |
1941157 | 1941157 | 2021-11-22 | Knox | Kentucky | 21121 | 7326 | 69 |
1941158 | 1941158 | 2021-11-22 | Larue | Kentucky | 21123 | 2437 | 53 |
1941159 | 1941159 | 2021-11-22 | Laurel | Kentucky | 21125 | 13078 | 151 |
1941160 | 1941160 | 2021-11-22 | Lawrence | Kentucky | 21127 | 2766 | 43 |
1941161 | 1941161 | 2021-11-22 | Lee | Kentucky | 21129 | 1791 | 35 |
1941162 | 1941162 | 2021-11-22 | Leslie | Kentucky | 21131 | 2267 | 30 |
1941163 | 1941163 | 2021-11-22 | Letcher | Kentucky | 21133 | 4081 | 73 |
1941164 | 1941164 | 2021-11-22 | Lewis | Kentucky | 21135 | 2682 | 60 |
1941165 | 1941165 | 2021-11-22 | Lincoln | Kentucky | 21137 | 4461 | 102 |
1941166 | 1941166 | 2021-11-22 | Livingston | Kentucky | 21139 | 1462 | 45 |
1941167 | 1941167 | 2021-11-22 | Logan | Kentucky | 21141 | 5202 | 90 |
1941168 | 1941168 | 2021-11-22 | Lyon | Kentucky | 21143 | 1995 | 26 |
1941169 | 1941169 | 2021-11-22 | Madison | Kentucky | 21151 | 16519 | 190 |
1941170 | 1941170 | 2021-11-22 | Magoffin | Kentucky | 21153 | 2386 | 26 |
1941171 | 1941171 | 2021-11-22 | Marion | Kentucky | 21155 | 4078 | 51 |
1941172 | 1941172 | 2021-11-22 | Marshall | Kentucky | 21157 | 5147 | 80 |
1941173 | 1941173 | 2021-11-22 | Martin | Kentucky | 21159 | 2016 | 36 |
1941174 | 1941174 | 2021-11-22 | Mason | Kentucky | 21161 | 2686 | 71 |
1941175 | 1941175 | 2021-11-22 | McCracken | Kentucky | 21145 | 10485 | 190 |
1941176 | 1941176 | 2021-11-22 | McCreary | Kentucky | 21147 | 3888 | 59 |
1941177 | 1941177 | 2021-11-22 | McLean | Kentucky | 21149 | 1539 | 40 |
1941178 | 1941178 | 2021-11-22 | Meade | Kentucky | 21163 | 3549 | 42 |
1941179 | 1941179 | 2021-11-22 | Menifee | Kentucky | 21165 | 880 | 23 |
1941180 | 1941180 | 2021-11-22 | Mercer | Kentucky | 21167 | 4651 | 79 |
1941181 | 1941181 | 2021-11-22 | Metcalfe | Kentucky | 21169 | 1975 | 44 |
1941182 | 1941182 | 2021-11-22 | Monroe | Kentucky | 21171 | 2391 | 64 |
1941183 | 1941183 | 2021-11-22 | Montgomery | Kentucky | 21173 | 4699 | 61 |
1941184 | 1941184 | 2021-11-22 | Morgan | Kentucky | 21175 | 2976 | 11 |
1941185 | 1941185 | 2021-11-22 | Muhlenberg | Kentucky | 21177 | 5831 | 97 |
1941186 | 1941186 | 2021-11-22 | Nelson | Kentucky | 21179 | 8674 | 101 |
1941187 | 1941187 | 2021-11-22 | Nicholas | Kentucky | 21181 | 1242 | 22 |
1941188 | 1941188 | 2021-11-22 | Ohio | Kentucky | 21183 | 4503 | 87 |
1941189 | 1941189 | 2021-11-22 | Oldham | Kentucky | 21185 | 10506 | 100 |
1941190 | 1941190 | 2021-11-22 | Owen | Kentucky | 21187 | 1445 | 28 |
1941191 | 1941191 | 2021-11-22 | Owsley | Kentucky | 21189 | 1030 | 19 |
1941192 | 1941192 | 2021-11-22 | Pendleton | Kentucky | 21191 | 2121 | 25 |
1941193 | 1941193 | 2021-11-22 | Perry | Kentucky | 21193 | 6368 | 114 |
1941194 | 1941194 | 2021-11-22 | Pike | Kentucky | 21195 | 11073 | 203 |
1941195 | 1941195 | 2021-11-22 | Powell | Kentucky | 21197 | 2733 | 24 |
1941196 | 1941196 | 2021-11-22 | Pulaski | Kentucky | 21199 | 11854 | 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);