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-08-04 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
399798 | 399798 | 2020-08-04 | Adair | Kentucky | 21001 | 217 | 19 |
399799 | 399799 | 2020-08-04 | Allen | Kentucky | 21003 | 217 | 8 |
399800 | 399800 | 2020-08-04 | Anderson | Kentucky | 21005 | 77 | 1 |
399801 | 399801 | 2020-08-04 | Ballard | Kentucky | 21007 | 31 | 0 |
399802 | 399802 | 2020-08-04 | Barren | Kentucky | 21009 | 342 | 2 |
399803 | 399803 | 2020-08-04 | Bath | Kentucky | 21011 | 36 | 1 |
399804 | 399804 | 2020-08-04 | Bell | Kentucky | 21013 | 285 | 2 |
399805 | 399805 | 2020-08-04 | Boone | Kentucky | 21015 | 1048 | 24 |
399806 | 399806 | 2020-08-04 | Bourbon | Kentucky | 21017 | 75 | 1 |
399807 | 399807 | 2020-08-04 | Boyd | Kentucky | 21019 | 179 | 3 |
399808 | 399808 | 2020-08-04 | Boyle | Kentucky | 21021 | 142 | 0 |
399809 | 399809 | 2020-08-04 | Bracken | Kentucky | 21023 | 29 | 0 |
399810 | 399810 | 2020-08-04 | Breathitt | Kentucky | 21025 | 26 | 0 |
399811 | 399811 | 2020-08-04 | Breckinridge | Kentucky | 21027 | 52 | 2 |
399812 | 399812 | 2020-08-04 | Bullitt | Kentucky | 21029 | 318 | 4 |
399813 | 399813 | 2020-08-04 | Butler | Kentucky | 21031 | 296 | 15 |
399814 | 399814 | 2020-08-04 | Caldwell | Kentucky | 21033 | 49 | 0 |
399815 | 399815 | 2020-08-04 | Calloway | Kentucky | 21035 | 198 | 4 |
399816 | 399816 | 2020-08-04 | Campbell | Kentucky | 21037 | 542 | 13 |
399817 | 399817 | 2020-08-04 | Carlisle | Kentucky | 21039 | 32 | 1 |
399818 | 399818 | 2020-08-04 | Carroll | Kentucky | 21041 | 145 | 2 |
399819 | 399819 | 2020-08-04 | Carter | Kentucky | 21043 | 98 | 1 |
399820 | 399820 | 2020-08-04 | Casey | Kentucky | 21045 | 200 | 10 |
399821 | 399821 | 2020-08-04 | Christian | Kentucky | 21047 | 597 | 6 |
399822 | 399822 | 2020-08-04 | Clark | Kentucky | 21049 | 162 | 7 |
399823 | 399823 | 2020-08-04 | Clay | Kentucky | 21051 | 144 | 5 |
399824 | 399824 | 2020-08-04 | Clinton | Kentucky | 21053 | 30 | 0 |
399825 | 399825 | 2020-08-04 | Crittenden | Kentucky | 21055 | 26 | 1 |
399826 | 399826 | 2020-08-04 | Cumberland | Kentucky | 21057 | 55 | 0 |
399827 | 399827 | 2020-08-04 | Daviess | Kentucky | 21059 | 723 | 8 |
399828 | 399828 | 2020-08-04 | Edmonson | Kentucky | 21061 | 102 | 12 |
399829 | 399829 | 2020-08-04 | Elliott | Kentucky | 21063 | 8 | 0 |
399830 | 399830 | 2020-08-04 | Estill | Kentucky | 21065 | 17 | 0 |
399831 | 399831 | 2020-08-04 | Fayette | Kentucky | 21067 | 3447 | 46 |
399832 | 399832 | 2020-08-04 | Fleming | Kentucky | 21069 | 57 | 0 |
399833 | 399833 | 2020-08-04 | Floyd | Kentucky | 21071 | 84 | 2 |
399834 | 399834 | 2020-08-04 | Franklin | Kentucky | 21073 | 260 | 5 |
399835 | 399835 | 2020-08-04 | Fulton | Kentucky | 21075 | 62 | 1 |
399836 | 399836 | 2020-08-04 | Gallatin | Kentucky | 21077 | 79 | 8 |
399837 | 399837 | 2020-08-04 | Garrard | Kentucky | 21079 | 69 | 0 |
399838 | 399838 | 2020-08-04 | Grant | Kentucky | 21081 | 106 | 5 |
399839 | 399839 | 2020-08-04 | Graves | Kentucky | 21083 | 522 | 22 |
399840 | 399840 | 2020-08-04 | Grayson | Kentucky | 21085 | 186 | 11 |
399841 | 399841 | 2020-08-04 | Green | Kentucky | 21087 | 39 | 2 |
399842 | 399842 | 2020-08-04 | Greenup | Kentucky | 21089 | 94 | 1 |
399843 | 399843 | 2020-08-04 | Hancock | Kentucky | 21091 | 49 | 0 |
399844 | 399844 | 2020-08-04 | Hardin | Kentucky | 21093 | 533 | 8 |
399845 | 399845 | 2020-08-04 | Harlan | Kentucky | 21095 | 212 | 3 |
399846 | 399846 | 2020-08-04 | Harrison | Kentucky | 21097 | 117 | 0 |
399847 | 399847 | 2020-08-04 | Hart | Kentucky | 21099 | 105 | 0 |
399848 | 399848 | 2020-08-04 | Henderson | Kentucky | 21101 | 328 | 4 |
399849 | 399849 | 2020-08-04 | Henry | Kentucky | 21103 | 100 | 2 |
399850 | 399850 | 2020-08-04 | Hickman | Kentucky | 21105 | 35 | 0 |
399851 | 399851 | 2020-08-04 | Hopkins | Kentucky | 21107 | 413 | 35 |
399852 | 399852 | 2020-08-04 | Jackson | Kentucky | 21109 | 143 | 14 |
399853 | 399853 | 2020-08-04 | Jefferson | Kentucky | 21111 | 7414 | 251 |
399854 | 399854 | 2020-08-04 | Jessamine | Kentucky | 21113 | 308 | 0 |
399855 | 399855 | 2020-08-04 | Johnson | Kentucky | 21115 | 40 | 0 |
399856 | 399856 | 2020-08-04 | Kenton | Kentucky | 21117 | 1351 | 39 |
399857 | 399857 | 2020-08-04 | Knott | Kentucky | 21119 | 47 | 1 |
399858 | 399858 | 2020-08-04 | Knox | Kentucky | 21121 | 216 | 8 |
399859 | 399859 | 2020-08-04 | Larue | Kentucky | 21123 | 65 | 1 |
399860 | 399860 | 2020-08-04 | Laurel | Kentucky | 21125 | 392 | 4 |
399861 | 399861 | 2020-08-04 | Lawrence | Kentucky | 21127 | 34 | 0 |
399862 | 399862 | 2020-08-04 | Lee | Kentucky | 21129 | 4 | 0 |
399863 | 399863 | 2020-08-04 | Leslie | Kentucky | 21131 | 27 | 0 |
399864 | 399864 | 2020-08-04 | Letcher | Kentucky | 21133 | 52 | 0 |
399865 | 399865 | 2020-08-04 | Lewis | Kentucky | 21135 | 37 | 0 |
399866 | 399866 | 2020-08-04 | Lincoln | Kentucky | 21137 | 99 | 1 |
399867 | 399867 | 2020-08-04 | Livingston | Kentucky | 21139 | 33 | 1 |
399868 | 399868 | 2020-08-04 | Logan | Kentucky | 21141 | 314 | 23 |
399869 | 399869 | 2020-08-04 | Lyon | Kentucky | 21143 | 30 | 4 |
399870 | 399870 | 2020-08-04 | Madison | Kentucky | 21151 | 411 | 1 |
399871 | 399871 | 2020-08-04 | Magoffin | Kentucky | 21153 | 30 | 0 |
399872 | 399872 | 2020-08-04 | Marion | Kentucky | 21155 | 113 | 0 |
399873 | 399873 | 2020-08-04 | Marshall | Kentucky | 21157 | 128 | 2 |
399874 | 399874 | 2020-08-04 | Martin | Kentucky | 21159 | 32 | 0 |
399875 | 399875 | 2020-08-04 | Mason | Kentucky | 21161 | 53 | 1 |
399876 | 399876 | 2020-08-04 | McCracken | Kentucky | 21145 | 344 | 4 |
399877 | 399877 | 2020-08-04 | McCreary | Kentucky | 21147 | 38 | 0 |
399878 | 399878 | 2020-08-04 | McLean | Kentucky | 21149 | 43 | 0 |
399879 | 399879 | 2020-08-04 | Meade | Kentucky | 21163 | 99 | 2 |
399880 | 399880 | 2020-08-04 | Menifee | Kentucky | 21165 | 29 | 0 |
399881 | 399881 | 2020-08-04 | Mercer | Kentucky | 21167 | 77 | 0 |
399882 | 399882 | 2020-08-04 | Metcalfe | Kentucky | 21169 | 57 | 2 |
399883 | 399883 | 2020-08-04 | Monroe | Kentucky | 21171 | 89 | 2 |
399884 | 399884 | 2020-08-04 | Montgomery | Kentucky | 21173 | 114 | 0 |
399885 | 399885 | 2020-08-04 | Morgan | Kentucky | 21175 | 30 | 0 |
399886 | 399886 | 2020-08-04 | Muhlenberg | Kentucky | 21177 | 638 | 10 |
399887 | 399887 | 2020-08-04 | Nelson | Kentucky | 21179 | 197 | 2 |
399888 | 399888 | 2020-08-04 | Nicholas | Kentucky | 21181 | 20 | 0 |
399889 | 399889 | 2020-08-04 | Ohio | Kentucky | 21183 | 355 | 7 |
399890 | 399890 | 2020-08-04 | Oldham | Kentucky | 21185 | 582 | 14 |
399891 | 399891 | 2020-08-04 | Owen | Kentucky | 21187 | 43 | 0 |
399892 | 399892 | 2020-08-04 | Owsley | Kentucky | 21189 | 10 | 0 |
399893 | 399893 | 2020-08-04 | Pendleton | Kentucky | 21191 | 36 | 0 |
399894 | 399894 | 2020-08-04 | Perry | Kentucky | 21193 | 193 | 3 |
399895 | 399895 | 2020-08-04 | Pike | Kentucky | 21195 | 224 | 3 |
399896 | 399896 | 2020-08-04 | Powell | Kentucky | 21197 | 49 | 0 |
399897 | 399897 | 2020-08-04 | Pulaski | Kentucky | 21199 | 319 | 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);