ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where "date" is on date 2020-06-01 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 |
---|---|---|---|---|---|---|---|
197809 | 197809 | 2020-06-01 | Adair | Kentucky | 21001 | 97 | 19 |
197810 | 197810 | 2020-06-01 | Allen | Kentucky | 21003 | 93 | 3 |
197811 | 197811 | 2020-06-01 | Anderson | Kentucky | 21005 | 20 | 1 |
197812 | 197812 | 2020-06-01 | Ballard | Kentucky | 21007 | 12 | 0 |
197813 | 197813 | 2020-06-01 | Barren | Kentucky | 21009 | 47 | 1 |
197814 | 197814 | 2020-06-01 | Bath | Kentucky | 21011 | 9 | 1 |
197815 | 197815 | 2020-06-01 | Bell | Kentucky | 21013 | 1 | 0 |
197816 | 197816 | 2020-06-01 | Boone | Kentucky | 21015 | 466 | 17 |
197817 | 197817 | 2020-06-01 | Bourbon | Kentucky | 21017 | 11 | 1 |
197818 | 197818 | 2020-06-01 | Boyd | Kentucky | 21019 | 40 | 3 |
197819 | 197819 | 2020-06-01 | Boyle | Kentucky | 21021 | 25 | 0 |
197820 | 197820 | 2020-06-01 | Bracken | Kentucky | 21023 | 13 | 0 |
197821 | 197821 | 2020-06-01 | Breathitt | Kentucky | 21025 | 3 | 0 |
197822 | 197822 | 2020-06-01 | Breckinridge | Kentucky | 21027 | 17 | 2 |
197823 | 197823 | 2020-06-01 | Bullitt | Kentucky | 21029 | 115 | 4 |
197824 | 197824 | 2020-06-01 | Butler | Kentucky | 21031 | 232 | 13 |
197825 | 197825 | 2020-06-01 | Caldwell | Kentucky | 21033 | 12 | 0 |
197826 | 197826 | 2020-06-01 | Calloway | Kentucky | 21035 | 52 | 1 |
197827 | 197827 | 2020-06-01 | Campbell | Kentucky | 21037 | 182 | 12 |
197828 | 197828 | 2020-06-01 | Carlisle | Kentucky | 21039 | 5 | 1 |
197829 | 197829 | 2020-06-01 | Carroll | Kentucky | 21041 | 14 | 0 |
197830 | 197830 | 2020-06-01 | Carter | Kentucky | 21043 | 12 | 0 |
197831 | 197831 | 2020-06-01 | Casey | Kentucky | 21045 | 3 | 0 |
197832 | 197832 | 2020-06-01 | Christian | Kentucky | 21047 | 119 | 3 |
197833 | 197833 | 2020-06-01 | Clark | Kentucky | 21049 | 42 | 0 |
197834 | 197834 | 2020-06-01 | Clay | Kentucky | 21051 | 7 | 0 |
197835 | 197835 | 2020-06-01 | Clinton | Kentucky | 21053 | 4 | 0 |
197836 | 197836 | 2020-06-01 | Crittenden | Kentucky | 21055 | 6 | 1 |
197837 | 197837 | 2020-06-01 | Cumberland | Kentucky | 21057 | 5 | 0 |
197838 | 197838 | 2020-06-01 | Daviess | Kentucky | 21059 | 324 | 6 |
197839 | 197839 | 2020-06-01 | Edmonson | Kentucky | 21061 | 60 | 9 |
197840 | 197840 | 2020-06-01 | Elliott | Kentucky | 21063 | 1 | 0 |
197841 | 197841 | 2020-06-01 | Fayette | Kentucky | 21067 | 760 | 13 |
197842 | 197842 | 2020-06-01 | Fleming | Kentucky | 21069 | 3 | 0 |
197843 | 197843 | 2020-06-01 | Floyd | Kentucky | 21071 | 18 | 0 |
197844 | 197844 | 2020-06-01 | Franklin | Kentucky | 21073 | 38 | 0 |
197845 | 197845 | 2020-06-01 | Fulton | Kentucky | 21075 | 7 | 0 |
197846 | 197846 | 2020-06-01 | Gallatin | Kentucky | 21077 | 37 | 4 |
197847 | 197847 | 2020-06-01 | Garrard | Kentucky | 21079 | 5 | 0 |
197848 | 197848 | 2020-06-01 | Grant | Kentucky | 21081 | 44 | 4 |
197849 | 197849 | 2020-06-01 | Graves | Kentucky | 21083 | 166 | 19 |
197850 | 197850 | 2020-06-01 | Grayson | Kentucky | 21085 | 126 | 9 |
197851 | 197851 | 2020-06-01 | Green | Kentucky | 21087 | 1 | 0 |
197852 | 197852 | 2020-06-01 | Greenup | Kentucky | 21089 | 14 | 0 |
197853 | 197853 | 2020-06-01 | Hancock | Kentucky | 21091 | 8 | 0 |
197854 | 197854 | 2020-06-01 | Hardin | Kentucky | 21093 | 103 | 2 |
197855 | 197855 | 2020-06-01 | Harlan | Kentucky | 21095 | 4 | 0 |
197856 | 197856 | 2020-06-01 | Harrison | Kentucky | 21097 | 21 | 0 |
197857 | 197857 | 2020-06-01 | Hart | Kentucky | 21099 | 28 | 0 |
197858 | 197858 | 2020-06-01 | Henderson | Kentucky | 21101 | 118 | 4 |
197859 | 197859 | 2020-06-01 | Henry | Kentucky | 21103 | 22 | 0 |
197860 | 197860 | 2020-06-01 | Hickman | Kentucky | 21105 | 5 | 0 |
197861 | 197861 | 2020-06-01 | Hopkins | Kentucky | 21107 | 223 | 31 |
197862 | 197862 | 2020-06-01 | Jackson | Kentucky | 21109 | 61 | 13 |
197863 | 197863 | 2020-06-01 | Jefferson | Kentucky | 21111 | 2555 | 161 |
197864 | 197864 | 2020-06-01 | Jessamine | Kentucky | 21113 | 65 | 0 |
197865 | 197865 | 2020-06-01 | Johnson | Kentucky | 21115 | 5 | 0 |
197866 | 197866 | 2020-06-01 | Kenton | Kentucky | 21117 | 608 | 34 |
197867 | 197867 | 2020-06-01 | Knott | Kentucky | 21119 | 4 | 0 |
197868 | 197868 | 2020-06-01 | Knox | Kentucky | 21121 | 8 | 0 |
197869 | 197869 | 2020-06-01 | Larue | Kentucky | 21123 | 8 | 0 |
197870 | 197870 | 2020-06-01 | Laurel | Kentucky | 21125 | 21 | 2 |
197871 | 197871 | 2020-06-01 | Lawrence | Kentucky | 21127 | 3 | 0 |
197872 | 197872 | 2020-06-01 | Lee | Kentucky | 21129 | 1 | 0 |
197873 | 197873 | 2020-06-01 | Leslie | Kentucky | 21131 | 6 | 0 |
197874 | 197874 | 2020-06-01 | Letcher | Kentucky | 21133 | 5 | 0 |
197875 | 197875 | 2020-06-01 | Lewis | Kentucky | 21135 | 8 | 0 |
197876 | 197876 | 2020-06-01 | Lincoln | Kentucky | 21137 | 8 | 1 |
197877 | 197877 | 2020-06-01 | Livingston | Kentucky | 21139 | 9 | 0 |
197878 | 197878 | 2020-06-01 | Logan | Kentucky | 21141 | 150 | 4 |
197879 | 197879 | 2020-06-01 | Lyon | Kentucky | 21143 | 15 | 3 |
197880 | 197880 | 2020-06-01 | Madison | Kentucky | 21151 | 55 | 1 |
197881 | 197881 | 2020-06-01 | Magoffin | Kentucky | 21153 | 2 | 0 |
197882 | 197882 | 2020-06-01 | Marion | Kentucky | 21155 | 21 | 0 |
197883 | 197883 | 2020-06-01 | Marshall | Kentucky | 21157 | 38 | 2 |
197884 | 197884 | 2020-06-01 | Martin | Kentucky | 21159 | 3 | 0 |
197885 | 197885 | 2020-06-01 | Mason | Kentucky | 21161 | 9 | 0 |
197886 | 197886 | 2020-06-01 | McCracken | Kentucky | 21145 | 97 | 2 |
197887 | 197887 | 2020-06-01 | McCreary | Kentucky | 21147 | 13 | 0 |
197888 | 197888 | 2020-06-01 | McLean | Kentucky | 21149 | 23 | 0 |
197889 | 197889 | 2020-06-01 | Meade | Kentucky | 21163 | 22 | 2 |
197890 | 197890 | 2020-06-01 | Menifee | Kentucky | 21165 | 10 | 0 |
197891 | 197891 | 2020-06-01 | Mercer | Kentucky | 21167 | 13 | 0 |
197892 | 197892 | 2020-06-01 | Metcalfe | Kentucky | 21169 | 7 | 1 |
197893 | 197893 | 2020-06-01 | Monroe | Kentucky | 21171 | 20 | 0 |
197894 | 197894 | 2020-06-01 | Montgomery | Kentucky | 21173 | 25 | 0 |
197895 | 197895 | 2020-06-01 | Morgan | Kentucky | 21175 | 1 | 0 |
197896 | 197896 | 2020-06-01 | Muhlenberg | Kentucky | 21177 | 497 | 7 |
197897 | 197897 | 2020-06-01 | Nelson | Kentucky | 21179 | 41 | 1 |
197898 | 197898 | 2020-06-01 | Nicholas | Kentucky | 21181 | 3 | 0 |
197899 | 197899 | 2020-06-01 | Ohio | Kentucky | 21183 | 168 | 0 |
197900 | 197900 | 2020-06-01 | Oldham | Kentucky | 21185 | 99 | 5 |
197901 | 197901 | 2020-06-01 | Owen | Kentucky | 21187 | 3 | 0 |
197902 | 197902 | 2020-06-01 | Owsley | Kentucky | 21189 | 2 | 0 |
197903 | 197903 | 2020-06-01 | Pendleton | Kentucky | 21191 | 10 | 0 |
197904 | 197904 | 2020-06-01 | Perry | Kentucky | 21193 | 19 | 0 |
197905 | 197905 | 2020-06-01 | Pike | Kentucky | 21195 | 30 | 2 |
197906 | 197906 | 2020-06-01 | Powell | Kentucky | 21197 | 1 | 0 |
197907 | 197907 | 2020-06-01 | Pulaski | Kentucky | 21199 | 58 | 2 |
197908 | 197908 | 2020-06-01 | Rockcastle | Kentucky | 21203 | 13 | 0 |
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);