ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-07-16" 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 |
---|---|---|---|---|---|---|---|
338823 | 338823 | 2020-07-16 | Adair | Kentucky | 21001 | 170 | 19 |
338824 | 338824 | 2020-07-16 | Allen | Kentucky | 21003 | 196 | 7 |
338825 | 338825 | 2020-07-16 | Anderson | Kentucky | 21005 | 34 | 1 |
338826 | 338826 | 2020-07-16 | Ballard | Kentucky | 21007 | 22 | 0 |
338827 | 338827 | 2020-07-16 | Barren | Kentucky | 21009 | 145 | 2 |
338828 | 338828 | 2020-07-16 | Bath | Kentucky | 21011 | 23 | 1 |
338829 | 338829 | 2020-07-16 | Bell | Kentucky | 21013 | 132 | 0 |
338830 | 338830 | 2020-07-16 | Boone | Kentucky | 21015 | 785 | 23 |
338831 | 338831 | 2020-07-16 | Bourbon | Kentucky | 21017 | 51 | 1 |
338832 | 338832 | 2020-07-16 | Boyd | Kentucky | 21019 | 106 | 3 |
338833 | 338833 | 2020-07-16 | Boyle | Kentucky | 21021 | 52 | 0 |
338834 | 338834 | 2020-07-16 | Bracken | Kentucky | 21023 | 21 | 0 |
338835 | 338835 | 2020-07-16 | Breathitt | Kentucky | 21025 | 16 | 0 |
338836 | 338836 | 2020-07-16 | Breckinridge | Kentucky | 21027 | 33 | 2 |
338837 | 338837 | 2020-07-16 | Bullitt | Kentucky | 21029 | 186 | 4 |
338838 | 338838 | 2020-07-16 | Butler | Kentucky | 21031 | 270 | 14 |
338839 | 338839 | 2020-07-16 | Caldwell | Kentucky | 21033 | 38 | 0 |
338840 | 338840 | 2020-07-16 | Calloway | Kentucky | 21035 | 121 | 1 |
338841 | 338841 | 2020-07-16 | Campbell | Kentucky | 21037 | 351 | 13 |
338842 | 338842 | 2020-07-16 | Carlisle | Kentucky | 21039 | 13 | 1 |
338843 | 338843 | 2020-07-16 | Carroll | Kentucky | 21041 | 97 | 1 |
338844 | 338844 | 2020-07-16 | Carter | Kentucky | 21043 | 56 | 1 |
338845 | 338845 | 2020-07-16 | Casey | Kentucky | 21045 | 118 | 5 |
338846 | 338846 | 2020-07-16 | Christian | Kentucky | 21047 | 365 | 4 |
338847 | 338847 | 2020-07-16 | Clark | Kentucky | 21049 | 119 | 6 |
338848 | 338848 | 2020-07-16 | Clay | Kentucky | 21051 | 98 | 4 |
338849 | 338849 | 2020-07-16 | Clinton | Kentucky | 21053 | 12 | 0 |
338850 | 338850 | 2020-07-16 | Crittenden | Kentucky | 21055 | 14 | 1 |
338851 | 338851 | 2020-07-16 | Cumberland | Kentucky | 21057 | 16 | 0 |
338852 | 338852 | 2020-07-16 | Daviess | Kentucky | 21059 | 539 | 8 |
338853 | 338853 | 2020-07-16 | Edmonson | Kentucky | 21061 | 84 | 12 |
338854 | 338854 | 2020-07-16 | Elliott | Kentucky | 21063 | 5 | 0 |
338855 | 338855 | 2020-07-16 | Estill | Kentucky | 21065 | 7 | 0 |
338856 | 338856 | 2020-07-16 | Fayette | Kentucky | 21067 | 2248 | 40 |
338857 | 338857 | 2020-07-16 | Fleming | Kentucky | 21069 | 33 | 0 |
338858 | 338858 | 2020-07-16 | Floyd | Kentucky | 21071 | 49 | 1 |
338859 | 338859 | 2020-07-16 | Franklin | Kentucky | 21073 | 169 | 4 |
338860 | 338860 | 2020-07-16 | Fulton | Kentucky | 21075 | 30 | 1 |
338861 | 338861 | 2020-07-16 | Gallatin | Kentucky | 21077 | 71 | 8 |
338862 | 338862 | 2020-07-16 | Garrard | Kentucky | 21079 | 42 | 0 |
338863 | 338863 | 2020-07-16 | Grant | Kentucky | 21081 | 74 | 5 |
338864 | 338864 | 2020-07-16 | Graves | Kentucky | 21083 | 349 | 21 |
338865 | 338865 | 2020-07-16 | Grayson | Kentucky | 21085 | 156 | 11 |
338866 | 338866 | 2020-07-16 | Green | Kentucky | 21087 | 21 | 1 |
338867 | 338867 | 2020-07-16 | Greenup | Kentucky | 21089 | 47 | 0 |
338868 | 338868 | 2020-07-16 | Hancock | Kentucky | 21091 | 33 | 0 |
338869 | 338869 | 2020-07-16 | Hardin | Kentucky | 21093 | 333 | 7 |
338870 | 338870 | 2020-07-16 | Harlan | Kentucky | 21095 | 61 | 2 |
338871 | 338871 | 2020-07-16 | Harrison | Kentucky | 21097 | 86 | 0 |
338872 | 338872 | 2020-07-16 | Hart | Kentucky | 21099 | 54 | 0 |
338873 | 338873 | 2020-07-16 | Henderson | Kentucky | 21101 | 221 | 4 |
338874 | 338874 | 2020-07-16 | Henry | Kentucky | 21103 | 50 | 2 |
338875 | 338875 | 2020-07-16 | Hickman | Kentucky | 21105 | 10 | 0 |
338876 | 338876 | 2020-07-16 | Hopkins | Kentucky | 21107 | 328 | 35 |
338877 | 338877 | 2020-07-16 | Jackson | Kentucky | 21109 | 118 | 14 |
338878 | 338878 | 2020-07-16 | Jefferson | Kentucky | 21111 | 4778 | 229 |
338879 | 338879 | 2020-07-16 | Jessamine | Kentucky | 21113 | 164 | 0 |
338880 | 338880 | 2020-07-16 | Johnson | Kentucky | 21115 | 12 | 0 |
338881 | 338881 | 2020-07-16 | Kenton | Kentucky | 21117 | 944 | 38 |
338882 | 338882 | 2020-07-16 | Knott | Kentucky | 21119 | 23 | 0 |
338883 | 338883 | 2020-07-16 | Knox | Kentucky | 21121 | 117 | 7 |
338884 | 338884 | 2020-07-16 | Larue | Kentucky | 21123 | 26 | 1 |
338885 | 338885 | 2020-07-16 | Laurel | Kentucky | 21125 | 217 | 4 |
338886 | 338886 | 2020-07-16 | Lawrence | Kentucky | 21127 | 14 | 0 |
338887 | 338887 | 2020-07-16 | Lee | Kentucky | 21129 | 1 | 0 |
338888 | 338888 | 2020-07-16 | Leslie | Kentucky | 21131 | 13 | 0 |
338889 | 338889 | 2020-07-16 | Letcher | Kentucky | 21133 | 22 | 0 |
338890 | 338890 | 2020-07-16 | Lewis | Kentucky | 21135 | 24 | 0 |
338891 | 338891 | 2020-07-16 | Lincoln | Kentucky | 21137 | 65 | 1 |
338892 | 338892 | 2020-07-16 | Livingston | Kentucky | 21139 | 23 | 0 |
338893 | 338893 | 2020-07-16 | Logan | Kentucky | 21141 | 267 | 16 |
338894 | 338894 | 2020-07-16 | Lyon | Kentucky | 21143 | 25 | 3 |
338895 | 338895 | 2020-07-16 | Madison | Kentucky | 21151 | 232 | 1 |
338896 | 338896 | 2020-07-16 | Magoffin | Kentucky | 21153 | 7 | 0 |
338897 | 338897 | 2020-07-16 | Marion | Kentucky | 21155 | 76 | 0 |
338898 | 338898 | 2020-07-16 | Marshall | Kentucky | 21157 | 82 | 2 |
338899 | 338899 | 2020-07-16 | Martin | Kentucky | 21159 | 12 | 0 |
338900 | 338900 | 2020-07-16 | Mason | Kentucky | 21161 | 40 | 1 |
338901 | 338901 | 2020-07-16 | McCracken | Kentucky | 21145 | 222 | 3 |
338902 | 338902 | 2020-07-16 | McCreary | Kentucky | 21147 | 20 | 0 |
338903 | 338903 | 2020-07-16 | McLean | Kentucky | 21149 | 35 | 0 |
338904 | 338904 | 2020-07-16 | Meade | Kentucky | 21163 | 47 | 2 |
338905 | 338905 | 2020-07-16 | Menifee | Kentucky | 21165 | 18 | 0 |
338906 | 338906 | 2020-07-16 | Mercer | Kentucky | 21167 | 31 | 0 |
338907 | 338907 | 2020-07-16 | Metcalfe | Kentucky | 21169 | 17 | 2 |
338908 | 338908 | 2020-07-16 | Monroe | Kentucky | 21171 | 53 | 2 |
338909 | 338909 | 2020-07-16 | Montgomery | Kentucky | 21173 | 76 | 0 |
338910 | 338910 | 2020-07-16 | Morgan | Kentucky | 21175 | 20 | 0 |
338911 | 338911 | 2020-07-16 | Muhlenberg | Kentucky | 21177 | 584 | 9 |
338912 | 338912 | 2020-07-16 | Nelson | Kentucky | 21179 | 130 | 2 |
338913 | 338913 | 2020-07-16 | Nicholas | Kentucky | 21181 | 13 | 0 |
338914 | 338914 | 2020-07-16 | Ohio | Kentucky | 21183 | 287 | 1 |
338915 | 338915 | 2020-07-16 | Oldham | Kentucky | 21185 | 186 | 7 |
338916 | 338916 | 2020-07-16 | Owen | Kentucky | 21187 | 13 | 0 |
338917 | 338917 | 2020-07-16 | Owsley | Kentucky | 21189 | 3 | 0 |
338918 | 338918 | 2020-07-16 | Pendleton | Kentucky | 21191 | 24 | 0 |
338919 | 338919 | 2020-07-16 | Perry | Kentucky | 21193 | 111 | 2 |
338920 | 338920 | 2020-07-16 | Pike | Kentucky | 21195 | 131 | 3 |
338921 | 338921 | 2020-07-16 | Powell | Kentucky | 21197 | 17 | 0 |
338922 | 338922 | 2020-07-16 | Pulaski | Kentucky | 21199 | 155 | 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);