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-21 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2236989 | 2236989 | 2022-02-21 | Adair | Kentucky | 21001 | 5330 | 98 |
2236990 | 2236990 | 2022-02-21 | Allen | Kentucky | 21003 | 6480 | 92 |
2236991 | 2236991 | 2022-02-21 | Anderson | Kentucky | 21005 | 6040 | 62 |
2236992 | 2236992 | 2022-02-21 | Ballard | Kentucky | 21007 | 1238 | 27 |
2236993 | 2236993 | 2022-02-21 | Barren | Kentucky | 21009 | 12526 | 201 |
2236994 | 2236994 | 2022-02-21 | Bath | Kentucky | 21011 | 2744 | 37 |
2236995 | 2236995 | 2022-02-21 | Bell | Kentucky | 21013 | 8685 | 128 |
2236996 | 2236996 | 2022-02-21 | Boone | Kentucky | 21015 | 38539 | 264 |
2236997 | 2236997 | 2022-02-21 | Bourbon | Kentucky | 21017 | 5817 | 48 |
2236998 | 2236998 | 2022-02-21 | Boyd | Kentucky | 21019 | 15706 | 159 |
2236999 | 2236999 | 2022-02-21 | Boyle | Kentucky | 21021 | 8235 | 121 |
2237000 | 2237000 | 2022-02-21 | Bracken | Kentucky | 21023 | 2078 | 23 |
2237001 | 2237001 | 2022-02-21 | Breathitt | Kentucky | 21025 | 3401 | 50 |
2237002 | 2237002 | 2022-02-21 | Breckinridge | Kentucky | 21027 | 4936 | 67 |
2237003 | 2237003 | 2022-02-21 | Bullitt | Kentucky | 21029 | 20760 | 185 |
2237004 | 2237004 | 2022-02-21 | Butler | Kentucky | 21031 | 3724 | 49 |
2237005 | 2237005 | 2022-02-21 | Caldwell | Kentucky | 21033 | 3892 | 58 |
2237006 | 2237006 | 2022-02-21 | Calloway | Kentucky | 21035 | 7864 | 81 |
2237007 | 2237007 | 2022-02-21 | Campbell | Kentucky | 21037 | 24061 | 149 |
2237008 | 2237008 | 2022-02-21 | Carlisle | Kentucky | 21039 | 951 | 18 |
2237009 | 2237009 | 2022-02-21 | Carroll | Kentucky | 21041 | 3403 | 41 |
2237010 | 2237010 | 2022-02-21 | Carter | Kentucky | 21043 | 8283 | 96 |
2237011 | 2237011 | 2022-02-21 | Casey | Kentucky | 21045 | 3852 | 66 |
2237012 | 2237012 | 2022-02-21 | Christian | Kentucky | 21047 | 15477 | 192 |
2237013 | 2237013 | 2022-02-21 | Clark | Kentucky | 21049 | 9646 | 51 |
2237014 | 2237014 | 2022-02-21 | Clay | Kentucky | 21051 | 7596 | 77 |
2237015 | 2237015 | 2022-02-21 | Clinton | Kentucky | 21053 | 3295 | 42 |
2237016 | 2237016 | 2022-02-21 | Crittenden | Kentucky | 21055 | 1988 | 42 |
2237017 | 2237017 | 2022-02-21 | Cumberland | Kentucky | 21057 | 2103 | 28 |
2237018 | 2237018 | 2022-02-21 | Daviess | Kentucky | 21059 | 30581 | 355 |
2237019 | 2237019 | 2022-02-21 | Edmonson | Kentucky | 21061 | 2503 | 38 |
2237020 | 2237020 | 2022-02-21 | Elliott | Kentucky | 21063 | 2150 | 16 |
2237021 | 2237021 | 2022-02-21 | Estill | Kentucky | 21065 | 3989 | 41 |
2237022 | 2237022 | 2022-02-21 | Fayette | Kentucky | 21067 | 91997 | 547 |
2237023 | 2237023 | 2022-02-21 | Fleming | Kentucky | 21069 | 3579 | 44 |
2237024 | 2237024 | 2022-02-21 | Floyd | Kentucky | 21071 | 11982 | 157 |
2237025 | 2237025 | 2022-02-21 | Franklin | Kentucky | 21073 | 12908 | 133 |
2237026 | 2237026 | 2022-02-21 | Fulton | Kentucky | 21075 | 1141 | 23 |
2237027 | 2237027 | 2022-02-21 | Gallatin | Kentucky | 21077 | 2152 | 45 |
2237028 | 2237028 | 2022-02-21 | Garrard | Kentucky | 21079 | 4655 | 69 |
2237029 | 2237029 | 2022-02-21 | Grant | Kentucky | 21081 | 7476 | 55 |
2237030 | 2237030 | 2022-02-21 | Graves | Kentucky | 21083 | 11276 | 155 |
2237031 | 2237031 | 2022-02-21 | Grayson | Kentucky | 21085 | 7926 | 117 |
2237032 | 2237032 | 2022-02-21 | Green | Kentucky | 21087 | 3437 | 40 |
2237033 | 2237033 | 2022-02-21 | Greenup | Kentucky | 21089 | 11673 | 122 |
2237034 | 2237034 | 2022-02-21 | Hancock | Kentucky | 21091 | 2423 | 20 |
2237035 | 2237035 | 2022-02-21 | Hardin | Kentucky | 21093 | 31999 | 398 |
2237036 | 2237036 | 2022-02-21 | Harlan | Kentucky | 21095 | 8889 | 178 |
2237037 | 2237037 | 2022-02-21 | Harrison | Kentucky | 21097 | 6029 | 62 |
2237038 | 2237038 | 2022-02-21 | Hart | Kentucky | 21099 | 5300 | 92 |
2237039 | 2237039 | 2022-02-21 | Henderson | Kentucky | 21101 | 13523 | 145 |
2237040 | 2237040 | 2022-02-21 | Henry | Kentucky | 21103 | 4709 | 45 |
2237041 | 2237041 | 2022-02-21 | Hickman | Kentucky | 21105 | 811 | 22 |
2237042 | 2237042 | 2022-02-21 | Hopkins | Kentucky | 21107 | 14402 | 241 |
2237043 | 2237043 | 2022-02-21 | Jackson | Kentucky | 21109 | 4116 | 71 |
2237044 | 2237044 | 2022-02-21 | Jefferson | Kentucky | 21111 | 222243 | 2031 |
2237045 | 2237045 | 2022-02-21 | Jessamine | Kentucky | 21113 | 14803 | 128 |
2237046 | 2237046 | 2022-02-21 | Johnson | Kentucky | 21115 | 5750 | 88 |
2237047 | 2237047 | 2022-02-21 | Kenton | Kentucky | 21117 | 44641 | 366 |
2237048 | 2237048 | 2022-02-21 | Knott | Kentucky | 21119 | 3893 | 55 |
2237049 | 2237049 | 2022-02-21 | Knox | Kentucky | 21121 | 11156 | 123 |
2237050 | 2237050 | 2022-02-21 | Larue | Kentucky | 21123 | 3667 | 67 |
2237051 | 2237051 | 2022-02-21 | Laurel | Kentucky | 21125 | 17952 | 199 |
2237052 | 2237052 | 2022-02-21 | Lawrence | Kentucky | 21127 | 4337 | 59 |
2237053 | 2237053 | 2022-02-21 | Lee | Kentucky | 21129 | 2767 | 46 |
2237054 | 2237054 | 2022-02-21 | Leslie | Kentucky | 21131 | 3480 | 39 |
2237055 | 2237055 | 2022-02-21 | Letcher | Kentucky | 21133 | 6564 | 90 |
2237056 | 2237056 | 2022-02-21 | Lewis | Kentucky | 21135 | 4354 | 78 |
2237057 | 2237057 | 2022-02-21 | Lincoln | Kentucky | 21137 | 6096 | 120 |
2237058 | 2237058 | 2022-02-21 | Livingston | Kentucky | 21139 | 2256 | 57 |
2237059 | 2237059 | 2022-02-21 | Logan | Kentucky | 21141 | 8228 | 112 |
2237060 | 2237060 | 2022-02-21 | Lyon | Kentucky | 21143 | 2751 | 33 |
2237061 | 2237061 | 2022-02-21 | Madison | Kentucky | 21151 | 27096 | 247 |
2237062 | 2237062 | 2022-02-21 | Magoffin | Kentucky | 21153 | 3689 | 39 |
2237063 | 2237063 | 2022-02-21 | Marion | Kentucky | 21155 | 6290 | 74 |
2237064 | 2237064 | 2022-02-21 | Marshall | Kentucky | 21157 | 8249 | 93 |
2237065 | 2237065 | 2022-02-21 | Martin | Kentucky | 21159 | 3126 | 44 |
2237066 | 2237066 | 2022-02-21 | Mason | Kentucky | 21161 | 4480 | 96 |
2237067 | 2237067 | 2022-02-21 | McCracken | Kentucky | 21145 | 17597 | 218 |
2237068 | 2237068 | 2022-02-21 | McCreary | Kentucky | 21147 | 4922 | 73 |
2237069 | 2237069 | 2022-02-21 | McLean | Kentucky | 21149 | 2586 | 45 |
2237070 | 2237070 | 2022-02-21 | Meade | Kentucky | 21163 | 5696 | 64 |
2237071 | 2237071 | 2022-02-21 | Menifee | Kentucky | 21165 | 1397 | 30 |
2237072 | 2237072 | 2022-02-21 | Mercer | Kentucky | 21167 | 7199 | 99 |
2237073 | 2237073 | 2022-02-21 | Metcalfe | Kentucky | 21169 | 2775 | 58 |
2237074 | 2237074 | 2022-02-21 | Monroe | Kentucky | 21171 | 3561 | 72 |
2237075 | 2237075 | 2022-02-21 | Montgomery | Kentucky | 21173 | 6435 | 87 |
2237076 | 2237076 | 2022-02-21 | Morgan | Kentucky | 21175 | 4407 | 17 |
2237077 | 2237077 | 2022-02-21 | Muhlenberg | Kentucky | 21177 | 9986 | 114 |
2237078 | 2237078 | 2022-02-21 | Nelson | Kentucky | 21179 | 14182 | 134 |
2237079 | 2237079 | 2022-02-21 | Nicholas | Kentucky | 21181 | 1835 | 30 |
2237080 | 2237080 | 2022-02-21 | Ohio | Kentucky | 21183 | 7225 | 95 |
2237081 | 2237081 | 2022-02-21 | Oldham | Kentucky | 21185 | 17808 | 125 |
2237082 | 2237082 | 2022-02-21 | Owen | Kentucky | 21187 | 2330 | 32 |
2237083 | 2237083 | 2022-02-21 | Owsley | Kentucky | 21189 | 1495 | 23 |
2237084 | 2237084 | 2022-02-21 | Pendleton | Kentucky | 21191 | 3388 | 33 |
2237085 | 2237085 | 2022-02-21 | Perry | Kentucky | 21193 | 10006 | 144 |
2237086 | 2237086 | 2022-02-21 | Pike | Kentucky | 21195 | 17205 | 243 |
2237087 | 2237087 | 2022-02-21 | Powell | Kentucky | 21197 | 4625 | 33 |
2237088 | 2237088 | 2022-02-21 | Pulaski | Kentucky | 21199 | 15382 | 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);