ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where "date" is on date 2020-06-03 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 |
---|---|---|---|---|---|---|---|
203957 | 203957 | 2020-06-03 | Adair | Kentucky | 21001 | 97 | 19 |
203958 | 203958 | 2020-06-03 | Allen | Kentucky | 21003 | 96 | 3 |
203959 | 203959 | 2020-06-03 | Anderson | Kentucky | 21005 | 21 | 1 |
203960 | 203960 | 2020-06-03 | Ballard | Kentucky | 21007 | 12 | 0 |
203961 | 203961 | 2020-06-03 | Barren | Kentucky | 21009 | 49 | 1 |
203962 | 203962 | 2020-06-03 | Bath | Kentucky | 21011 | 9 | 1 |
203963 | 203963 | 2020-06-03 | Bell | Kentucky | 21013 | 1 | 0 |
203964 | 203964 | 2020-06-03 | Boone | Kentucky | 21015 | 492 | 18 |
203965 | 203965 | 2020-06-03 | Bourbon | Kentucky | 21017 | 11 | 1 |
203966 | 203966 | 2020-06-03 | Boyd | Kentucky | 21019 | 40 | 3 |
203967 | 203967 | 2020-06-03 | Boyle | Kentucky | 21021 | 26 | 0 |
203968 | 203968 | 2020-06-03 | Bracken | Kentucky | 21023 | 13 | 0 |
203969 | 203969 | 2020-06-03 | Breathitt | Kentucky | 21025 | 3 | 0 |
203970 | 203970 | 2020-06-03 | Breckinridge | Kentucky | 21027 | 17 | 2 |
203971 | 203971 | 2020-06-03 | Bullitt | Kentucky | 21029 | 119 | 4 |
203972 | 203972 | 2020-06-03 | Butler | Kentucky | 21031 | 235 | 13 |
203973 | 203973 | 2020-06-03 | Caldwell | Kentucky | 21033 | 12 | 0 |
203974 | 203974 | 2020-06-03 | Calloway | Kentucky | 21035 | 53 | 1 |
203975 | 203975 | 2020-06-03 | Campbell | Kentucky | 21037 | 191 | 12 |
203976 | 203976 | 2020-06-03 | Carlisle | Kentucky | 21039 | 5 | 1 |
203977 | 203977 | 2020-06-03 | Carroll | Kentucky | 21041 | 14 | 0 |
203978 | 203978 | 2020-06-03 | Carter | Kentucky | 21043 | 14 | 0 |
203979 | 203979 | 2020-06-03 | Casey | Kentucky | 21045 | 5 | 0 |
203980 | 203980 | 2020-06-03 | Christian | Kentucky | 21047 | 119 | 3 |
203981 | 203981 | 2020-06-03 | Clark | Kentucky | 21049 | 43 | 0 |
203982 | 203982 | 2020-06-03 | Clay | Kentucky | 21051 | 7 | 1 |
203983 | 203983 | 2020-06-03 | Clinton | Kentucky | 21053 | 4 | 0 |
203984 | 203984 | 2020-06-03 | Crittenden | Kentucky | 21055 | 7 | 1 |
203985 | 203985 | 2020-06-03 | Cumberland | Kentucky | 21057 | 5 | 0 |
203986 | 203986 | 2020-06-03 | Daviess | Kentucky | 21059 | 330 | 6 |
203987 | 203987 | 2020-06-03 | Edmonson | Kentucky | 21061 | 60 | 11 |
203988 | 203988 | 2020-06-03 | Elliott | Kentucky | 21063 | 1 | 0 |
203989 | 203989 | 2020-06-03 | Estill | Kentucky | 21065 | 1 | 0 |
203990 | 203990 | 2020-06-03 | Fayette | Kentucky | 21067 | 803 | 13 |
203991 | 203991 | 2020-06-03 | Fleming | Kentucky | 21069 | 2 | 0 |
203992 | 203992 | 2020-06-03 | Floyd | Kentucky | 21071 | 18 | 0 |
203993 | 203993 | 2020-06-03 | Franklin | Kentucky | 21073 | 63 | 0 |
203994 | 203994 | 2020-06-03 | Fulton | Kentucky | 21075 | 8 | 0 |
203995 | 203995 | 2020-06-03 | Gallatin | Kentucky | 21077 | 46 | 5 |
203996 | 203996 | 2020-06-03 | Garrard | Kentucky | 21079 | 5 | 0 |
203997 | 203997 | 2020-06-03 | Grant | Kentucky | 21081 | 46 | 4 |
203998 | 203998 | 2020-06-03 | Graves | Kentucky | 21083 | 166 | 19 |
203999 | 203999 | 2020-06-03 | Grayson | Kentucky | 21085 | 127 | 9 |
204000 | 204000 | 2020-06-03 | Green | Kentucky | 21087 | 1 | 0 |
204001 | 204001 | 2020-06-03 | Greenup | Kentucky | 21089 | 14 | 0 |
204002 | 204002 | 2020-06-03 | Hancock | Kentucky | 21091 | 8 | 0 |
204003 | 204003 | 2020-06-03 | Hardin | Kentucky | 21093 | 109 | 2 |
204004 | 204004 | 2020-06-03 | Harlan | Kentucky | 21095 | 4 | 0 |
204005 | 204005 | 2020-06-03 | Harrison | Kentucky | 21097 | 23 | 0 |
204006 | 204006 | 2020-06-03 | Hart | Kentucky | 21099 | 28 | 0 |
204007 | 204007 | 2020-06-03 | Henderson | Kentucky | 21101 | 120 | 4 |
204008 | 204008 | 2020-06-03 | Henry | Kentucky | 21103 | 22 | 0 |
204009 | 204009 | 2020-06-03 | Hickman | Kentucky | 21105 | 5 | 0 |
204010 | 204010 | 2020-06-03 | Hopkins | Kentucky | 21107 | 225 | 32 |
204011 | 204011 | 2020-06-03 | Jackson | Kentucky | 21109 | 61 | 13 |
204012 | 204012 | 2020-06-03 | Jefferson | Kentucky | 21111 | 2612 | 164 |
204013 | 204013 | 2020-06-03 | Jessamine | Kentucky | 21113 | 67 | 0 |
204014 | 204014 | 2020-06-03 | Johnson | Kentucky | 21115 | 5 | 0 |
204015 | 204015 | 2020-06-03 | Kenton | Kentucky | 21117 | 638 | 35 |
204016 | 204016 | 2020-06-03 | Knott | Kentucky | 21119 | 4 | 0 |
204017 | 204017 | 2020-06-03 | Knox | Kentucky | 21121 | 10 | 0 |
204018 | 204018 | 2020-06-03 | Larue | Kentucky | 21123 | 8 | 0 |
204019 | 204019 | 2020-06-03 | Laurel | Kentucky | 21125 | 21 | 2 |
204020 | 204020 | 2020-06-03 | Lawrence | Kentucky | 21127 | 4 | 0 |
204021 | 204021 | 2020-06-03 | Lee | Kentucky | 21129 | 1 | 0 |
204022 | 204022 | 2020-06-03 | Leslie | Kentucky | 21131 | 6 | 0 |
204023 | 204023 | 2020-06-03 | Letcher | Kentucky | 21133 | 5 | 0 |
204024 | 204024 | 2020-06-03 | Lewis | Kentucky | 21135 | 8 | 0 |
204025 | 204025 | 2020-06-03 | Lincoln | Kentucky | 21137 | 8 | 1 |
204026 | 204026 | 2020-06-03 | Livingston | Kentucky | 21139 | 9 | 0 |
204027 | 204027 | 2020-06-03 | Logan | Kentucky | 21141 | 156 | 4 |
204028 | 204028 | 2020-06-03 | Lyon | Kentucky | 21143 | 15 | 3 |
204029 | 204029 | 2020-06-03 | Madison | Kentucky | 21151 | 54 | 1 |
204030 | 204030 | 2020-06-03 | Magoffin | Kentucky | 21153 | 2 | 0 |
204031 | 204031 | 2020-06-03 | Marion | Kentucky | 21155 | 25 | 0 |
204032 | 204032 | 2020-06-03 | Marshall | Kentucky | 21157 | 37 | 2 |
204033 | 204033 | 2020-06-03 | Martin | Kentucky | 21159 | 3 | 0 |
204034 | 204034 | 2020-06-03 | Mason | Kentucky | 21161 | 10 | 0 |
204035 | 204035 | 2020-06-03 | McCracken | Kentucky | 21145 | 99 | 2 |
204036 | 204036 | 2020-06-03 | McCreary | Kentucky | 21147 | 13 | 0 |
204037 | 204037 | 2020-06-03 | McLean | Kentucky | 21149 | 23 | 0 |
204038 | 204038 | 2020-06-03 | Meade | Kentucky | 21163 | 22 | 2 |
204039 | 204039 | 2020-06-03 | Menifee | Kentucky | 21165 | 10 | 0 |
204040 | 204040 | 2020-06-03 | Mercer | Kentucky | 21167 | 14 | 0 |
204041 | 204041 | 2020-06-03 | Metcalfe | Kentucky | 21169 | 7 | 1 |
204042 | 204042 | 2020-06-03 | Monroe | Kentucky | 21171 | 21 | 0 |
204043 | 204043 | 2020-06-03 | Montgomery | Kentucky | 21173 | 25 | 0 |
204044 | 204044 | 2020-06-03 | Morgan | Kentucky | 21175 | 3 | 0 |
204045 | 204045 | 2020-06-03 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
204046 | 204046 | 2020-06-03 | Nelson | Kentucky | 21179 | 44 | 1 |
204047 | 204047 | 2020-06-03 | Nicholas | Kentucky | 21181 | 3 | 0 |
204048 | 204048 | 2020-06-03 | Ohio | Kentucky | 21183 | 171 | 0 |
204049 | 204049 | 2020-06-03 | Oldham | Kentucky | 21185 | 103 | 5 |
204050 | 204050 | 2020-06-03 | Owen | Kentucky | 21187 | 3 | 0 |
204051 | 204051 | 2020-06-03 | Owsley | Kentucky | 21189 | 2 | 0 |
204052 | 204052 | 2020-06-03 | Pendleton | Kentucky | 21191 | 11 | 0 |
204053 | 204053 | 2020-06-03 | Perry | Kentucky | 21193 | 22 | 0 |
204054 | 204054 | 2020-06-03 | Pike | Kentucky | 21195 | 30 | 2 |
204055 | 204055 | 2020-06-03 | Powell | Kentucky | 21197 | 1 | 0 |
204056 | 204056 | 2020-06-03 | Pulaski | Kentucky | 21199 | 61 | 2 |
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);