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 2020-10-24 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 |
---|---|---|---|---|---|---|---|
661848 | 661848 | 2020-10-24 | Adair | Kentucky | 21001 | 512 | 23 |
661849 | 661849 | 2020-10-24 | Allen | Kentucky | 21003 | 528 | 11 |
661850 | 661850 | 2020-10-24 | Anderson | Kentucky | 21005 | 242 | 1 |
661851 | 661851 | 2020-10-24 | Ballard | Kentucky | 21007 | 69 | 1 |
661852 | 661852 | 2020-10-24 | Barren | Kentucky | 21009 | 1100 | 13 |
661853 | 661853 | 2020-10-24 | Bath | Kentucky | 21011 | 114 | 1 |
661854 | 661854 | 2020-10-24 | Bell | Kentucky | 21013 | 667 | 17 |
661855 | 661855 | 2020-10-24 | Boone | Kentucky | 21015 | 2071 | 25 |
661856 | 661856 | 2020-10-24 | Bourbon | Kentucky | 21017 | 314 | 1 |
661857 | 661857 | 2020-10-24 | Boyd | Kentucky | 21019 | 634 | 21 |
661858 | 661858 | 2020-10-24 | Boyle | Kentucky | 21021 | 439 | 0 |
661859 | 661859 | 2020-10-24 | Bracken | Kentucky | 21023 | 68 | 1 |
661860 | 661860 | 2020-10-24 | Breathitt | Kentucky | 21025 | 121 | 0 |
661861 | 661861 | 2020-10-24 | Breckinridge | Kentucky | 21027 | 188 | 2 |
661862 | 661862 | 2020-10-24 | Bullitt | Kentucky | 21029 | 1340 | 14 |
661863 | 661863 | 2020-10-24 | Butler | Kentucky | 21031 | 417 | 16 |
661864 | 661864 | 2020-10-24 | Caldwell | Kentucky | 21033 | 254 | 0 |
661865 | 661865 | 2020-10-24 | Calloway | Kentucky | 21035 | 933 | 9 |
661866 | 661866 | 2020-10-24 | Campbell | Kentucky | 21037 | 1170 | 19 |
661867 | 661867 | 2020-10-24 | Carlisle | Kentucky | 21039 | 101 | 1 |
661868 | 661868 | 2020-10-24 | Carroll | Kentucky | 21041 | 217 | 5 |
661869 | 661869 | 2020-10-24 | Carter | Kentucky | 21043 | 325 | 4 |
661870 | 661870 | 2020-10-24 | Casey | Kentucky | 21045 | 316 | 16 |
661871 | 661871 | 2020-10-24 | Christian | Kentucky | 21047 | 1871 | 29 |
661872 | 661872 | 2020-10-24 | Clark | Kentucky | 21049 | 509 | 11 |
661873 | 661873 | 2020-10-24 | Clay | Kentucky | 21051 | 492 | 6 |
661874 | 661874 | 2020-10-24 | Clinton | Kentucky | 21053 | 241 | 4 |
661875 | 661875 | 2020-10-24 | Crittenden | Kentucky | 21055 | 162 | 1 |
661876 | 661876 | 2020-10-24 | Cumberland | Kentucky | 21057 | 148 | 0 |
661877 | 661877 | 2020-10-24 | Daviess | Kentucky | 21059 | 1926 | 29 |
661878 | 661878 | 2020-10-24 | Edmonson | Kentucky | 21061 | 199 | 12 |
661879 | 661879 | 2020-10-24 | Elliott | Kentucky | 21063 | 184 | 0 |
661880 | 661880 | 2020-10-24 | Estill | Kentucky | 21065 | 263 | 0 |
661881 | 661881 | 2020-10-24 | Fayette | Kentucky | 21067 | 10391 | 91 |
661882 | 661882 | 2020-10-24 | Fleming | Kentucky | 21069 | 175 | 0 |
661883 | 661883 | 2020-10-24 | Floyd | Kentucky | 21071 | 337 | 4 |
661884 | 661884 | 2020-10-24 | Franklin | Kentucky | 21073 | 841 | 14 |
661885 | 661885 | 2020-10-24 | Fulton | Kentucky | 21075 | 231 | 3 |
661886 | 661886 | 2020-10-24 | Gallatin | Kentucky | 21077 | 126 | 8 |
661887 | 661887 | 2020-10-24 | Garrard | Kentucky | 21079 | 296 | 3 |
661888 | 661888 | 2020-10-24 | Grant | Kentucky | 21081 | 234 | 6 |
661889 | 661889 | 2020-10-24 | Graves | Kentucky | 21083 | 871 | 29 |
661890 | 661890 | 2020-10-24 | Grayson | Kentucky | 21085 | 498 | 15 |
661891 | 661891 | 2020-10-24 | Green | Kentucky | 21087 | 344 | 9 |
661892 | 661892 | 2020-10-24 | Greenup | Kentucky | 21089 | 602 | 11 |
661893 | 661893 | 2020-10-24 | Hancock | Kentucky | 21091 | 130 | 2 |
661894 | 661894 | 2020-10-24 | Hardin | Kentucky | 21093 | 1916 | 16 |
661895 | 661895 | 2020-10-24 | Harlan | Kentucky | 21095 | 583 | 14 |
661896 | 661896 | 2020-10-24 | Harrison | Kentucky | 21097 | 259 | 1 |
661897 | 661897 | 2020-10-24 | Hart | Kentucky | 21099 | 371 | 1 |
661898 | 661898 | 2020-10-24 | Henderson | Kentucky | 21101 | 1280 | 30 |
661899 | 661899 | 2020-10-24 | Henry | Kentucky | 21103 | 257 | 2 |
661900 | 661900 | 2020-10-24 | Hickman | Kentucky | 21105 | 111 | 1 |
661901 | 661901 | 2020-10-24 | Hopkins | Kentucky | 21107 | 1009 | 43 |
661902 | 661902 | 2020-10-24 | Jackson | Kentucky | 21109 | 444 | 17 |
661903 | 661903 | 2020-10-24 | Jefferson | Kentucky | 21111 | 22652 | 384 |
661904 | 661904 | 2020-10-24 | Jessamine | Kentucky | 21113 | 925 | 9 |
661905 | 661905 | 2020-10-24 | Johnson | Kentucky | 21115 | 286 | 2 |
661906 | 661906 | 2020-10-24 | Kenton | Kentucky | 21117 | 2552 | 49 |
661907 | 661907 | 2020-10-24 | Knott | Kentucky | 21119 | 329 | 4 |
661908 | 661908 | 2020-10-24 | Knox | Kentucky | 21121 | 807 | 9 |
661909 | 661909 | 2020-10-24 | Larue | Kentucky | 21123 | 272 | 1 |
661910 | 661910 | 2020-10-24 | Laurel | Kentucky | 21125 | 1376 | 7 |
661911 | 661911 | 2020-10-24 | Lawrence | Kentucky | 21127 | 141 | 0 |
661912 | 661912 | 2020-10-24 | Lee | Kentucky | 21129 | 111 | 3 |
661913 | 661913 | 2020-10-24 | Leslie | Kentucky | 21131 | 125 | 1 |
661914 | 661914 | 2020-10-24 | Letcher | Kentucky | 21133 | 299 | 2 |
661915 | 661915 | 2020-10-24 | Lewis | Kentucky | 21135 | 277 | 15 |
661916 | 661916 | 2020-10-24 | Lincoln | Kentucky | 21137 | 313 | 19 |
661917 | 661917 | 2020-10-24 | Livingston | Kentucky | 21139 | 123 | 1 |
661918 | 661918 | 2020-10-24 | Logan | Kentucky | 21141 | 757 | 31 |
661919 | 661919 | 2020-10-24 | Lyon | Kentucky | 21143 | 106 | 4 |
661920 | 661920 | 2020-10-24 | Madison | Kentucky | 21151 | 2278 | 13 |
661921 | 661921 | 2020-10-24 | Magoffin | Kentucky | 21153 | 153 | 0 |
661922 | 661922 | 2020-10-24 | Marion | Kentucky | 21155 | 419 | 11 |
661923 | 661923 | 2020-10-24 | Marshall | Kentucky | 21157 | 452 | 7 |
661924 | 661924 | 2020-10-24 | Martin | Kentucky | 21159 | 173 | 3 |
661925 | 661925 | 2020-10-24 | Mason | Kentucky | 21161 | 163 | 2 |
661926 | 661926 | 2020-10-24 | McCracken | Kentucky | 21145 | 1070 | 12 |
661927 | 661927 | 2020-10-24 | McCreary | Kentucky | 21147 | 264 | 1 |
661928 | 661928 | 2020-10-24 | McLean | Kentucky | 21149 | 173 | 2 |
661929 | 661929 | 2020-10-24 | Meade | Kentucky | 21163 | 399 | 4 |
661930 | 661930 | 2020-10-24 | Menifee | Kentucky | 21165 | 80 | 1 |
661931 | 661931 | 2020-10-24 | Mercer | Kentucky | 21167 | 339 | 6 |
661932 | 661932 | 2020-10-24 | Metcalfe | Kentucky | 21169 | 194 | 2 |
661933 | 661933 | 2020-10-24 | Monroe | Kentucky | 21171 | 269 | 4 |
661934 | 661934 | 2020-10-24 | Montgomery | Kentucky | 21173 | 425 | 4 |
661935 | 661935 | 2020-10-24 | Morgan | Kentucky | 21175 | 118 | 0 |
661936 | 661936 | 2020-10-24 | Muhlenberg | Kentucky | 21177 | 983 | 15 |
661937 | 661937 | 2020-10-24 | Nelson | Kentucky | 21179 | 835 | 4 |
661938 | 661938 | 2020-10-24 | Nicholas | Kentucky | 21181 | 104 | 2 |
661939 | 661939 | 2020-10-24 | Ohio | Kentucky | 21183 | 601 | 9 |
661940 | 661940 | 2020-10-24 | Oldham | Kentucky | 21185 | 1403 | 26 |
661941 | 661941 | 2020-10-24 | Owen | Kentucky | 21187 | 117 | 3 |
661942 | 661942 | 2020-10-24 | Owsley | Kentucky | 21189 | 87 | 1 |
661943 | 661943 | 2020-10-24 | Pendleton | Kentucky | 21191 | 121 | 0 |
661944 | 661944 | 2020-10-24 | Perry | Kentucky | 21193 | 498 | 9 |
661945 | 661945 | 2020-10-24 | Pike | Kentucky | 21195 | 806 | 3 |
661946 | 661946 | 2020-10-24 | Powell | Kentucky | 21197 | 138 | 0 |
661947 | 661947 | 2020-10-24 | Pulaski | Kentucky | 21199 | 1002 | 13 |
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);