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-07-21 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
354822 | 354822 | 2020-07-21 | Adair | Kentucky | 21001 | 180 | 19 |
354823 | 354823 | 2020-07-21 | Allen | Kentucky | 21003 | 204 | 7 |
354824 | 354824 | 2020-07-21 | Anderson | Kentucky | 21005 | 41 | 1 |
354825 | 354825 | 2020-07-21 | Ballard | Kentucky | 21007 | 25 | 0 |
354826 | 354826 | 2020-07-21 | Barren | Kentucky | 21009 | 194 | 2 |
354827 | 354827 | 2020-07-21 | Bath | Kentucky | 21011 | 23 | 1 |
354828 | 354828 | 2020-07-21 | Bell | Kentucky | 21013 | 166 | 1 |
354829 | 354829 | 2020-07-21 | Boone | Kentucky | 21015 | 851 | 23 |
354830 | 354830 | 2020-07-21 | Bourbon | Kentucky | 21017 | 60 | 1 |
354831 | 354831 | 2020-07-21 | Boyd | Kentucky | 21019 | 126 | 3 |
354832 | 354832 | 2020-07-21 | Boyle | Kentucky | 21021 | 62 | 0 |
354833 | 354833 | 2020-07-21 | Bracken | Kentucky | 21023 | 24 | 0 |
354834 | 354834 | 2020-07-21 | Breathitt | Kentucky | 21025 | 18 | 0 |
354835 | 354835 | 2020-07-21 | Breckinridge | Kentucky | 21027 | 38 | 2 |
354836 | 354836 | 2020-07-21 | Bullitt | Kentucky | 21029 | 211 | 4 |
354837 | 354837 | 2020-07-21 | Butler | Kentucky | 21031 | 281 | 15 |
354838 | 354838 | 2020-07-21 | Caldwell | Kentucky | 21033 | 41 | 0 |
354839 | 354839 | 2020-07-21 | Calloway | Kentucky | 21035 | 135 | 2 |
354840 | 354840 | 2020-07-21 | Campbell | Kentucky | 21037 | 409 | 13 |
354841 | 354841 | 2020-07-21 | Carlisle | Kentucky | 21039 | 15 | 1 |
354842 | 354842 | 2020-07-21 | Carroll | Kentucky | 21041 | 125 | 2 |
354843 | 354843 | 2020-07-21 | Carter | Kentucky | 21043 | 72 | 1 |
354844 | 354844 | 2020-07-21 | Casey | Kentucky | 21045 | 135 | 7 |
354845 | 354845 | 2020-07-21 | Christian | Kentucky | 21047 | 431 | 4 |
354846 | 354846 | 2020-07-21 | Clark | Kentucky | 21049 | 122 | 7 |
354847 | 354847 | 2020-07-21 | Clay | Kentucky | 21051 | 119 | 4 |
354848 | 354848 | 2020-07-21 | Clinton | Kentucky | 21053 | 16 | 0 |
354849 | 354849 | 2020-07-21 | Crittenden | Kentucky | 21055 | 21 | 1 |
354850 | 354850 | 2020-07-21 | Cumberland | Kentucky | 21057 | 20 | 0 |
354851 | 354851 | 2020-07-21 | Daviess | Kentucky | 21059 | 586 | 7 |
354852 | 354852 | 2020-07-21 | Edmonson | Kentucky | 21061 | 85 | 12 |
354853 | 354853 | 2020-07-21 | Elliott | Kentucky | 21063 | 7 | 0 |
354854 | 354854 | 2020-07-21 | Estill | Kentucky | 21065 | 8 | 0 |
354855 | 354855 | 2020-07-21 | Fayette | Kentucky | 21067 | 2521 | 41 |
354856 | 354856 | 2020-07-21 | Fleming | Kentucky | 21069 | 40 | 0 |
354857 | 354857 | 2020-07-21 | Floyd | Kentucky | 21071 | 61 | 1 |
354858 | 354858 | 2020-07-21 | Franklin | Kentucky | 21073 | 190 | 5 |
354859 | 354859 | 2020-07-21 | Fulton | Kentucky | 21075 | 35 | 1 |
354860 | 354860 | 2020-07-21 | Gallatin | Kentucky | 21077 | 73 | 8 |
354861 | 354861 | 2020-07-21 | Garrard | Kentucky | 21079 | 46 | 0 |
354862 | 354862 | 2020-07-21 | Grant | Kentucky | 21081 | 79 | 5 |
354863 | 354863 | 2020-07-21 | Graves | Kentucky | 21083 | 390 | 21 |
354864 | 354864 | 2020-07-21 | Grayson | Kentucky | 21085 | 162 | 11 |
354865 | 354865 | 2020-07-21 | Green | Kentucky | 21087 | 26 | 1 |
354866 | 354866 | 2020-07-21 | Greenup | Kentucky | 21089 | 59 | 0 |
354867 | 354867 | 2020-07-21 | Hancock | Kentucky | 21091 | 36 | 0 |
354868 | 354868 | 2020-07-21 | Hardin | Kentucky | 21093 | 379 | 7 |
354869 | 354869 | 2020-07-21 | Harlan | Kentucky | 21095 | 105 | 2 |
354870 | 354870 | 2020-07-21 | Harrison | Kentucky | 21097 | 99 | 0 |
354871 | 354871 | 2020-07-21 | Hart | Kentucky | 21099 | 64 | 0 |
354872 | 354872 | 2020-07-21 | Henderson | Kentucky | 21101 | 246 | 4 |
354873 | 354873 | 2020-07-21 | Henry | Kentucky | 21103 | 62 | 2 |
354874 | 354874 | 2020-07-21 | Hickman | Kentucky | 21105 | 16 | 0 |
354875 | 354875 | 2020-07-21 | Hopkins | Kentucky | 21107 | 358 | 35 |
354876 | 354876 | 2020-07-21 | Jackson | Kentucky | 21109 | 122 | 14 |
354877 | 354877 | 2020-07-21 | Jefferson | Kentucky | 21111 | 5441 | 231 |
354878 | 354878 | 2020-07-21 | Jessamine | Kentucky | 21113 | 192 | 0 |
354879 | 354879 | 2020-07-21 | Johnson | Kentucky | 21115 | 17 | 0 |
354880 | 354880 | 2020-07-21 | Kenton | Kentucky | 21117 | 1078 | 38 |
354881 | 354881 | 2020-07-21 | Knott | Kentucky | 21119 | 28 | 0 |
354882 | 354882 | 2020-07-21 | Knox | Kentucky | 21121 | 142 | 7 |
354883 | 354883 | 2020-07-21 | Larue | Kentucky | 21123 | 42 | 1 |
354884 | 354884 | 2020-07-21 | Laurel | Kentucky | 21125 | 263 | 4 |
354885 | 354885 | 2020-07-21 | Lawrence | Kentucky | 21127 | 20 | 0 |
354886 | 354886 | 2020-07-21 | Lee | Kentucky | 21129 | 3 | 0 |
354887 | 354887 | 2020-07-21 | Leslie | Kentucky | 21131 | 13 | 0 |
354888 | 354888 | 2020-07-21 | Letcher | Kentucky | 21133 | 26 | 0 |
354889 | 354889 | 2020-07-21 | Lewis | Kentucky | 21135 | 26 | 0 |
354890 | 354890 | 2020-07-21 | Lincoln | Kentucky | 21137 | 75 | 1 |
354891 | 354891 | 2020-07-21 | Livingston | Kentucky | 21139 | 27 | 0 |
354892 | 354892 | 2020-07-21 | Logan | Kentucky | 21141 | 280 | 21 |
354893 | 354893 | 2020-07-21 | Lyon | Kentucky | 21143 | 25 | 3 |
354894 | 354894 | 2020-07-21 | Madison | Kentucky | 21151 | 280 | 1 |
354895 | 354895 | 2020-07-21 | Magoffin | Kentucky | 21153 | 7 | 0 |
354896 | 354896 | 2020-07-21 | Marion | Kentucky | 21155 | 84 | 0 |
354897 | 354897 | 2020-07-21 | Marshall | Kentucky | 21157 | 94 | 2 |
354898 | 354898 | 2020-07-21 | Martin | Kentucky | 21159 | 18 | 0 |
354899 | 354899 | 2020-07-21 | Mason | Kentucky | 21161 | 44 | 1 |
354900 | 354900 | 2020-07-21 | McCracken | Kentucky | 21145 | 259 | 3 |
354901 | 354901 | 2020-07-21 | McCreary | Kentucky | 21147 | 21 | 0 |
354902 | 354902 | 2020-07-21 | McLean | Kentucky | 21149 | 36 | 0 |
354903 | 354903 | 2020-07-21 | Meade | Kentucky | 21163 | 56 | 2 |
354904 | 354904 | 2020-07-21 | Menifee | Kentucky | 21165 | 19 | 0 |
354905 | 354905 | 2020-07-21 | Mercer | Kentucky | 21167 | 33 | 0 |
354906 | 354906 | 2020-07-21 | Metcalfe | Kentucky | 21169 | 19 | 2 |
354907 | 354907 | 2020-07-21 | Monroe | Kentucky | 21171 | 63 | 2 |
354908 | 354908 | 2020-07-21 | Montgomery | Kentucky | 21173 | 89 | 0 |
354909 | 354909 | 2020-07-21 | Morgan | Kentucky | 21175 | 24 | 0 |
354910 | 354910 | 2020-07-21 | Muhlenberg | Kentucky | 21177 | 601 | 9 |
354911 | 354911 | 2020-07-21 | Nelson | Kentucky | 21179 | 151 | 2 |
354912 | 354912 | 2020-07-21 | Nicholas | Kentucky | 21181 | 16 | 0 |
354913 | 354913 | 2020-07-21 | Ohio | Kentucky | 21183 | 309 | 1 |
354914 | 354914 | 2020-07-21 | Oldham | Kentucky | 21185 | 409 | 8 |
354915 | 354915 | 2020-07-21 | Owen | Kentucky | 21187 | 23 | 0 |
354916 | 354916 | 2020-07-21 | Owsley | Kentucky | 21189 | 4 | 0 |
354917 | 354917 | 2020-07-21 | Pendleton | Kentucky | 21191 | 28 | 0 |
354918 | 354918 | 2020-07-21 | Perry | Kentucky | 21193 | 128 | 2 |
354919 | 354919 | 2020-07-21 | Pike | Kentucky | 21195 | 160 | 3 |
354920 | 354920 | 2020-07-21 | Powell | Kentucky | 21197 | 33 | 0 |
354921 | 354921 | 2020-07-21 | Pulaski | Kentucky | 21199 | 192 | 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);