ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-09-30" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
584007 | 584007 | 2020-09-30 | Adair | Kentucky | 21001 | 325 | 19 |
584008 | 584008 | 2020-09-30 | Allen | Kentucky | 21003 | 371 | 9 |
584009 | 584009 | 2020-09-30 | Anderson | Kentucky | 21005 | 167 | 1 |
584010 | 584010 | 2020-09-30 | Ballard | Kentucky | 21007 | 57 | 1 |
584011 | 584011 | 2020-09-30 | Barren | Kentucky | 21009 | 796 | 13 |
584012 | 584012 | 2020-09-30 | Bath | Kentucky | 21011 | 90 | 1 |
584013 | 584013 | 2020-09-30 | Bell | Kentucky | 21013 | 507 | 15 |
584014 | 584014 | 2020-09-30 | Boone | Kentucky | 21015 | 1610 | 25 |
584015 | 584015 | 2020-09-30 | Bourbon | Kentucky | 21017 | 209 | 1 |
584016 | 584016 | 2020-09-30 | Boyd | Kentucky | 21019 | 470 | 8 |
584017 | 584017 | 2020-09-30 | Boyle | Kentucky | 21021 | 294 | 0 |
584018 | 584018 | 2020-09-30 | Bracken | Kentucky | 21023 | 41 | 0 |
584019 | 584019 | 2020-09-30 | Breathitt | Kentucky | 21025 | 91 | 0 |
584020 | 584020 | 2020-09-30 | Breckinridge | Kentucky | 21027 | 139 | 2 |
584021 | 584021 | 2020-09-30 | Bullitt | Kentucky | 21029 | 912 | 11 |
584022 | 584022 | 2020-09-30 | Butler | Kentucky | 21031 | 357 | 16 |
584023 | 584023 | 2020-09-30 | Caldwell | Kentucky | 21033 | 166 | 0 |
584024 | 584024 | 2020-09-30 | Calloway | Kentucky | 21035 | 614 | 8 |
584025 | 584025 | 2020-09-30 | Campbell | Kentucky | 21037 | 893 | 19 |
584026 | 584026 | 2020-09-30 | Carlisle | Kentucky | 21039 | 80 | 1 |
584027 | 584027 | 2020-09-30 | Carroll | Kentucky | 21041 | 202 | 5 |
584028 | 584028 | 2020-09-30 | Carter | Kentucky | 21043 | 200 | 3 |
584029 | 584029 | 2020-09-30 | Casey | Kentucky | 21045 | 276 | 16 |
584030 | 584030 | 2020-09-30 | Christian | Kentucky | 21047 | 1355 | 23 |
584031 | 584031 | 2020-09-30 | Clark | Kentucky | 21049 | 328 | 8 |
584032 | 584032 | 2020-09-30 | Clay | Kentucky | 21051 | 330 | 6 |
584033 | 584033 | 2020-09-30 | Clinton | Kentucky | 21053 | 128 | 2 |
584034 | 584034 | 2020-09-30 | Crittenden | Kentucky | 21055 | 121 | 1 |
584035 | 584035 | 2020-09-30 | Cumberland | Kentucky | 21057 | 107 | 0 |
584036 | 584036 | 2020-09-30 | Daviess | Kentucky | 21059 | 1431 | 16 |
584037 | 584037 | 2020-09-30 | Edmonson | Kentucky | 21061 | 156 | 12 |
584038 | 584038 | 2020-09-30 | Elliott | Kentucky | 21063 | 42 | 0 |
584039 | 584039 | 2020-09-30 | Estill | Kentucky | 21065 | 166 | 0 |
584040 | 584040 | 2020-09-30 | Fayette | Kentucky | 21067 | 8534 | 76 |
584041 | 584041 | 2020-09-30 | Fleming | Kentucky | 21069 | 85 | 0 |
584042 | 584042 | 2020-09-30 | Floyd | Kentucky | 21071 | 193 | 4 |
584043 | 584043 | 2020-09-30 | Franklin | Kentucky | 21073 | 672 | 11 |
584044 | 584044 | 2020-09-30 | Fulton | Kentucky | 21075 | 157 | 3 |
584045 | 584045 | 2020-09-30 | Gallatin | Kentucky | 21077 | 99 | 8 |
584046 | 584046 | 2020-09-30 | Garrard | Kentucky | 21079 | 165 | 3 |
584047 | 584047 | 2020-09-30 | Grant | Kentucky | 21081 | 173 | 6 |
584048 | 584048 | 2020-09-30 | Graves | Kentucky | 21083 | 743 | 29 |
584049 | 584049 | 2020-09-30 | Grayson | Kentucky | 21085 | 409 | 14 |
584050 | 584050 | 2020-09-30 | Green | Kentucky | 21087 | 282 | 9 |
584051 | 584051 | 2020-09-30 | Greenup | Kentucky | 21089 | 429 | 4 |
584052 | 584052 | 2020-09-30 | Hancock | Kentucky | 21091 | 89 | 0 |
584053 | 584053 | 2020-09-30 | Hardin | Kentucky | 21093 | 1346 | 13 |
584054 | 584054 | 2020-09-30 | Harlan | Kentucky | 21095 | 428 | 10 |
584055 | 584055 | 2020-09-30 | Harrison | Kentucky | 21097 | 183 | 0 |
584056 | 584056 | 2020-09-30 | Hart | Kentucky | 21099 | 197 | 1 |
584057 | 584057 | 2020-09-30 | Henderson | Kentucky | 21101 | 802 | 5 |
584058 | 584058 | 2020-09-30 | Henry | Kentucky | 21103 | 202 | 2 |
584059 | 584059 | 2020-09-30 | Hickman | Kentucky | 21105 | 78 | 1 |
584060 | 584060 | 2020-09-30 | Hopkins | Kentucky | 21107 | 653 | 40 |
584061 | 584061 | 2020-09-30 | Jackson | Kentucky | 21109 | 374 | 17 |
584062 | 584062 | 2020-09-30 | Jefferson | Kentucky | 21111 | 17516 | 326 |
584063 | 584063 | 2020-09-30 | Jessamine | Kentucky | 21113 | 628 | 0 |
584064 | 584064 | 2020-09-30 | Johnson | Kentucky | 21115 | 161 | 2 |
584065 | 584065 | 2020-09-30 | Kenton | Kentucky | 21117 | 2068 | 49 |
584066 | 584066 | 2020-09-30 | Knott | Kentucky | 21119 | 214 | 1 |
584067 | 584067 | 2020-09-30 | Knox | Kentucky | 21121 | 515 | 9 |
584068 | 584068 | 2020-09-30 | Larue | Kentucky | 21123 | 160 | 1 |
584069 | 584069 | 2020-09-30 | Laurel | Kentucky | 21125 | 947 | 6 |
584070 | 584070 | 2020-09-30 | Lawrence | Kentucky | 21127 | 57 | 0 |
584071 | 584071 | 2020-09-30 | Lee | Kentucky | 21129 | 17 | 0 |
584072 | 584072 | 2020-09-30 | Leslie | Kentucky | 21131 | 78 | 0 |
584073 | 584073 | 2020-09-30 | Letcher | Kentucky | 21133 | 167 | 2 |
584074 | 584074 | 2020-09-30 | Lewis | Kentucky | 21135 | 222 | 14 |
584075 | 584075 | 2020-09-30 | Lincoln | Kentucky | 21137 | 210 | 13 |
584076 | 584076 | 2020-09-30 | Livingston | Kentucky | 21139 | 87 | 1 |
584077 | 584077 | 2020-09-30 | Logan | Kentucky | 21141 | 589 | 28 |
584078 | 584078 | 2020-09-30 | Lyon | Kentucky | 21143 | 77 | 4 |
584079 | 584079 | 2020-09-30 | Madison | Kentucky | 21151 | 1809 | 7 |
584080 | 584080 | 2020-09-30 | Magoffin | Kentucky | 21153 | 96 | 0 |
584081 | 584081 | 2020-09-30 | Marion | Kentucky | 21155 | 237 | 10 |
584082 | 584082 | 2020-09-30 | Marshall | Kentucky | 21157 | 317 | 4 |
584083 | 584083 | 2020-09-30 | Martin | Kentucky | 21159 | 82 | 3 |
584084 | 584084 | 2020-09-30 | Mason | Kentucky | 21161 | 126 | 2 |
584085 | 584085 | 2020-09-30 | McCracken | Kentucky | 21145 | 755 | 10 |
584086 | 584086 | 2020-09-30 | McCreary | Kentucky | 21147 | 192 | 0 |
584087 | 584087 | 2020-09-30 | McLean | Kentucky | 21149 | 83 | 0 |
584088 | 584088 | 2020-09-30 | Meade | Kentucky | 21163 | 258 | 3 |
584089 | 584089 | 2020-09-30 | Menifee | Kentucky | 21165 | 51 | 0 |
584090 | 584090 | 2020-09-30 | Mercer | Kentucky | 21167 | 251 | 2 |
584091 | 584091 | 2020-09-30 | Metcalfe | Kentucky | 21169 | 128 | 2 |
584092 | 584092 | 2020-09-30 | Monroe | Kentucky | 21171 | 214 | 4 |
584093 | 584093 | 2020-09-30 | Montgomery | Kentucky | 21173 | 291 | 3 |
584094 | 584094 | 2020-09-30 | Morgan | Kentucky | 21175 | 64 | 0 |
584095 | 584095 | 2020-09-30 | Muhlenberg | Kentucky | 21177 | 807 | 13 |
584096 | 584096 | 2020-09-30 | Nelson | Kentucky | 21179 | 519 | 4 |
584097 | 584097 | 2020-09-30 | Nicholas | Kentucky | 21181 | 37 | 1 |
584098 | 584098 | 2020-09-30 | Ohio | Kentucky | 21183 | 479 | 9 |
584099 | 584099 | 2020-09-30 | Oldham | Kentucky | 21185 | 1147 | 25 |
584100 | 584100 | 2020-09-30 | Owen | Kentucky | 21187 | 102 | 2 |
584101 | 584101 | 2020-09-30 | Owsley | Kentucky | 21189 | 42 | 1 |
584102 | 584102 | 2020-09-30 | Pendleton | Kentucky | 21191 | 102 | 0 |
584103 | 584103 | 2020-09-30 | Perry | Kentucky | 21193 | 341 | 9 |
584104 | 584104 | 2020-09-30 | Pike | Kentucky | 21195 | 467 | 3 |
584105 | 584105 | 2020-09-30 | Powell | Kentucky | 21197 | 100 | 0 |
584106 | 584106 | 2020-09-30 | Pulaski | Kentucky | 21199 | 827 | 10 |
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);