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 2022-02-17 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2223985 | 2223985 | 2022-02-17 | Adair | Kentucky | 21001 | 5266 | 96 |
2223986 | 2223986 | 2022-02-17 | Allen | Kentucky | 21003 | 6440 | 92 |
2223987 | 2223987 | 2022-02-17 | Anderson | Kentucky | 21005 | 5994 | 60 |
2223988 | 2223988 | 2022-02-17 | Ballard | Kentucky | 21007 | 1231 | 27 |
2223989 | 2223989 | 2022-02-17 | Barren | Kentucky | 21009 | 12435 | 198 |
2223990 | 2223990 | 2022-02-17 | Bath | Kentucky | 21011 | 2693 | 37 |
2223991 | 2223991 | 2022-02-17 | Bell | Kentucky | 21013 | 8609 | 127 |
2223992 | 2223992 | 2022-02-17 | Boone | Kentucky | 21015 | 38319 | 264 |
2223993 | 2223993 | 2022-02-17 | Bourbon | Kentucky | 21017 | 5779 | 49 |
2223994 | 2223994 | 2022-02-17 | Boyd | Kentucky | 21019 | 15627 | 156 |
2223995 | 2223995 | 2022-02-17 | Boyle | Kentucky | 21021 | 8189 | 120 |
2223996 | 2223996 | 2022-02-17 | Bracken | Kentucky | 21023 | 2066 | 23 |
2223997 | 2223997 | 2022-02-17 | Breathitt | Kentucky | 21025 | 3354 | 50 |
2223998 | 2223998 | 2022-02-17 | Breckinridge | Kentucky | 21027 | 4914 | 65 |
2223999 | 2223999 | 2022-02-17 | Bullitt | Kentucky | 21029 | 20659 | 181 |
2224000 | 2224000 | 2022-02-17 | Butler | Kentucky | 21031 | 3675 | 49 |
2224001 | 2224001 | 2022-02-17 | Caldwell | Kentucky | 21033 | 3876 | 58 |
2224002 | 2224002 | 2022-02-17 | Calloway | Kentucky | 21035 | 7838 | 80 |
2224003 | 2224003 | 2022-02-17 | Campbell | Kentucky | 21037 | 23930 | 148 |
2224004 | 2224004 | 2022-02-17 | Carlisle | Kentucky | 21039 | 947 | 18 |
2224005 | 2224005 | 2022-02-17 | Carroll | Kentucky | 21041 | 3391 | 40 |
2224006 | 2224006 | 2022-02-17 | Carter | Kentucky | 21043 | 8175 | 96 |
2224007 | 2224007 | 2022-02-17 | Casey | Kentucky | 21045 | 3802 | 66 |
2224008 | 2224008 | 2022-02-17 | Christian | Kentucky | 21047 | 15324 | 192 |
2224009 | 2224009 | 2022-02-17 | Clark | Kentucky | 21049 | 9547 | 51 |
2224010 | 2224010 | 2022-02-17 | Clay | Kentucky | 21051 | 7510 | 76 |
2224011 | 2224011 | 2022-02-17 | Clinton | Kentucky | 21053 | 3260 | 41 |
2224012 | 2224012 | 2022-02-17 | Crittenden | Kentucky | 21055 | 1974 | 42 |
2224013 | 2224013 | 2022-02-17 | Cumberland | Kentucky | 21057 | 2087 | 27 |
2224014 | 2224014 | 2022-02-17 | Daviess | Kentucky | 21059 | 30454 | 354 |
2224015 | 2224015 | 2022-02-17 | Edmonson | Kentucky | 21061 | 2492 | 38 |
2224016 | 2224016 | 2022-02-17 | Elliott | Kentucky | 21063 | 2079 | 16 |
2224017 | 2224017 | 2022-02-17 | Estill | Kentucky | 21065 | 3935 | 41 |
2224018 | 2224018 | 2022-02-17 | Fayette | Kentucky | 21067 | 91131 | 538 |
2224019 | 2224019 | 2022-02-17 | Fleming | Kentucky | 21069 | 3534 | 44 |
2224020 | 2224020 | 2022-02-17 | Floyd | Kentucky | 21071 | 11810 | 157 |
2224021 | 2224021 | 2022-02-17 | Franklin | Kentucky | 21073 | 12783 | 130 |
2224022 | 2224022 | 2022-02-17 | Fulton | Kentucky | 21075 | 1136 | 23 |
2224023 | 2224023 | 2022-02-17 | Gallatin | Kentucky | 21077 | 2146 | 45 |
2224024 | 2224024 | 2022-02-17 | Garrard | Kentucky | 21079 | 4616 | 67 |
2224025 | 2224025 | 2022-02-17 | Grant | Kentucky | 21081 | 7399 | 55 |
2224026 | 2224026 | 2022-02-17 | Graves | Kentucky | 21083 | 11242 | 154 |
2224027 | 2224027 | 2022-02-17 | Grayson | Kentucky | 21085 | 7778 | 117 |
2224028 | 2224028 | 2022-02-17 | Green | Kentucky | 21087 | 3404 | 40 |
2224029 | 2224029 | 2022-02-17 | Greenup | Kentucky | 21089 | 11554 | 118 |
2224030 | 2224030 | 2022-02-17 | Hancock | Kentucky | 21091 | 2414 | 20 |
2224031 | 2224031 | 2022-02-17 | Hardin | Kentucky | 21093 | 31847 | 394 |
2224032 | 2224032 | 2022-02-17 | Harlan | Kentucky | 21095 | 8813 | 174 |
2224033 | 2224033 | 2022-02-17 | Harrison | Kentucky | 21097 | 5996 | 62 |
2224034 | 2224034 | 2022-02-17 | Hart | Kentucky | 21099 | 5270 | 90 |
2224035 | 2224035 | 2022-02-17 | Henderson | Kentucky | 21101 | 13377 | 144 |
2224036 | 2224036 | 2022-02-17 | Henry | Kentucky | 21103 | 4691 | 46 |
2224037 | 2224037 | 2022-02-17 | Hickman | Kentucky | 21105 | 809 | 22 |
2224038 | 2224038 | 2022-02-17 | Hopkins | Kentucky | 21107 | 14332 | 239 |
2224039 | 2224039 | 2022-02-17 | Jackson | Kentucky | 21109 | 4078 | 71 |
2224040 | 2224040 | 2022-02-17 | Jefferson | Kentucky | 21111 | 219584 | 2026 |
2224041 | 2224041 | 2022-02-17 | Jessamine | Kentucky | 21113 | 14729 | 125 |
2224042 | 2224042 | 2022-02-17 | Johnson | Kentucky | 21115 | 5711 | 86 |
2224043 | 2224043 | 2022-02-17 | Kenton | Kentucky | 21117 | 44430 | 364 |
2224044 | 2224044 | 2022-02-17 | Knott | Kentucky | 21119 | 3818 | 55 |
2224045 | 2224045 | 2022-02-17 | Knox | Kentucky | 21121 | 11062 | 122 |
2224046 | 2224046 | 2022-02-17 | Larue | Kentucky | 21123 | 3639 | 65 |
2224047 | 2224047 | 2022-02-17 | Laurel | Kentucky | 21125 | 17750 | 198 |
2224048 | 2224048 | 2022-02-17 | Lawrence | Kentucky | 21127 | 4288 | 57 |
2224049 | 2224049 | 2022-02-17 | Lee | Kentucky | 21129 | 2662 | 46 |
2224050 | 2224050 | 2022-02-17 | Leslie | Kentucky | 21131 | 3420 | 39 |
2224051 | 2224051 | 2022-02-17 | Letcher | Kentucky | 21133 | 6484 | 90 |
2224052 | 2224052 | 2022-02-17 | Lewis | Kentucky | 21135 | 4331 | 78 |
2224053 | 2224053 | 2022-02-17 | Lincoln | Kentucky | 21137 | 6042 | 118 |
2224054 | 2224054 | 2022-02-17 | Livingston | Kentucky | 21139 | 2202 | 57 |
2224055 | 2224055 | 2022-02-17 | Logan | Kentucky | 21141 | 8166 | 110 |
2224056 | 2224056 | 2022-02-17 | Lyon | Kentucky | 21143 | 2735 | 33 |
2224057 | 2224057 | 2022-02-17 | Madison | Kentucky | 21151 | 26963 | 245 |
2224058 | 2224058 | 2022-02-17 | Magoffin | Kentucky | 21153 | 3655 | 38 |
2224059 | 2224059 | 2022-02-17 | Marion | Kentucky | 21155 | 6266 | 73 |
2224060 | 2224060 | 2022-02-17 | Marshall | Kentucky | 21157 | 8221 | 93 |
2224061 | 2224061 | 2022-02-17 | Martin | Kentucky | 21159 | 3076 | 44 |
2224062 | 2224062 | 2022-02-17 | Mason | Kentucky | 21161 | 4448 | 93 |
2224063 | 2224063 | 2022-02-17 | McCracken | Kentucky | 21145 | 17516 | 218 |
2224064 | 2224064 | 2022-02-17 | McCreary | Kentucky | 21147 | 4853 | 73 |
2224065 | 2224065 | 2022-02-17 | McLean | Kentucky | 21149 | 2580 | 45 |
2224066 | 2224066 | 2022-02-17 | Meade | Kentucky | 21163 | 5661 | 62 |
2224067 | 2224067 | 2022-02-17 | Menifee | Kentucky | 21165 | 1345 | 30 |
2224068 | 2224068 | 2022-02-17 | Mercer | Kentucky | 21167 | 7144 | 99 |
2224069 | 2224069 | 2022-02-17 | Metcalfe | Kentucky | 21169 | 2745 | 57 |
2224070 | 2224070 | 2022-02-17 | Monroe | Kentucky | 21171 | 3549 | 70 |
2224071 | 2224071 | 2022-02-17 | Montgomery | Kentucky | 21173 | 6346 | 87 |
2224072 | 2224072 | 2022-02-17 | Morgan | Kentucky | 21175 | 4324 | 17 |
2224073 | 2224073 | 2022-02-17 | Muhlenberg | Kentucky | 21177 | 9954 | 114 |
2224074 | 2224074 | 2022-02-17 | Nelson | Kentucky | 21179 | 14138 | 132 |
2224075 | 2224075 | 2022-02-17 | Nicholas | Kentucky | 21181 | 1824 | 29 |
2224076 | 2224076 | 2022-02-17 | Ohio | Kentucky | 21183 | 7183 | 95 |
2224077 | 2224077 | 2022-02-17 | Oldham | Kentucky | 21185 | 17711 | 124 |
2224078 | 2224078 | 2022-02-17 | Owen | Kentucky | 21187 | 2322 | 32 |
2224079 | 2224079 | 2022-02-17 | Owsley | Kentucky | 21189 | 1478 | 23 |
2224080 | 2224080 | 2022-02-17 | Pendleton | Kentucky | 21191 | 3374 | 33 |
2224081 | 2224081 | 2022-02-17 | Perry | Kentucky | 21193 | 9809 | 143 |
2224082 | 2224082 | 2022-02-17 | Pike | Kentucky | 21195 | 17047 | 242 |
2224083 | 2224083 | 2022-02-17 | Powell | Kentucky | 21197 | 4559 | 33 |
2224084 | 2224084 | 2022-02-17 | Pulaski | Kentucky | 21199 | 15194 | 252 |
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);