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 2022-03-20 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324793 | 2324793 | 2022-03-20 | Adair | Kentucky | 21001 | 5673 | 101 |
2324794 | 2324794 | 2022-03-20 | Allen | Kentucky | 21003 | 6560 | 96 |
2324795 | 2324795 | 2022-03-20 | Anderson | Kentucky | 21005 | 6355 | 66 |
2324796 | 2324796 | 2022-03-20 | Ballard | Kentucky | 21007 | 1266 | 28 |
2324797 | 2324797 | 2022-03-20 | Barren | Kentucky | 21009 | 12856 | 208 |
2324798 | 2324798 | 2022-03-20 | Bath | Kentucky | 21011 | 2955 | 39 |
2324799 | 2324799 | 2022-03-20 | Bell | Kentucky | 21013 | 8821 | 136 |
2324800 | 2324800 | 2022-03-20 | Boone | Kentucky | 21015 | 39314 | 272 |
2324801 | 2324801 | 2022-03-20 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2324802 | 2324802 | 2022-03-20 | Boyd | Kentucky | 21019 | 16153 | 167 |
2324803 | 2324803 | 2022-03-20 | Boyle | Kentucky | 21021 | 8355 | 124 |
2324804 | 2324804 | 2022-03-20 | Bracken | Kentucky | 21023 | 2106 | 24 |
2324805 | 2324805 | 2022-03-20 | Breathitt | Kentucky | 21025 | 3636 | 51 |
2324806 | 2324806 | 2022-03-20 | Breckinridge | Kentucky | 21027 | 5015 | 75 |
2324807 | 2324807 | 2022-03-20 | Bullitt | Kentucky | 21029 | 21026 | 196 |
2324808 | 2324808 | 2022-03-20 | Butler | Kentucky | 21031 | 3854 | 49 |
2324809 | 2324809 | 2022-03-20 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2324810 | 2324810 | 2022-03-20 | Calloway | Kentucky | 21035 | 7932 | 89 |
2324811 | 2324811 | 2022-03-20 | Campbell | Kentucky | 21037 | 24472 | 157 |
2324812 | 2324812 | 2022-03-20 | Carlisle | Kentucky | 21039 | 977 | 19 |
2324813 | 2324813 | 2022-03-20 | Carroll | Kentucky | 21041 | 3450 | 43 |
2324814 | 2324814 | 2022-03-20 | Carter | Kentucky | 21043 | 8536 | 99 |
2324815 | 2324815 | 2022-03-20 | Casey | Kentucky | 21045 | 4015 | 69 |
2324816 | 2324816 | 2022-03-20 | Christian | Kentucky | 21047 | 16206 | 199 |
2324817 | 2324817 | 2022-03-20 | Clark | Kentucky | 21049 | 10129 | 56 |
2324818 | 2324818 | 2022-03-20 | Clay | Kentucky | 21051 | 7811 | 85 |
2324819 | 2324819 | 2022-03-20 | Clinton | Kentucky | 21053 | 3443 | 44 |
2324820 | 2324820 | 2022-03-20 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2324821 | 2324821 | 2022-03-20 | Cumberland | Kentucky | 21057 | 2169 | 28 |
2324822 | 2324822 | 2022-03-20 | Daviess | Kentucky | 21059 | 30918 | 367 |
2324823 | 2324823 | 2022-03-20 | Edmonson | Kentucky | 21061 | 2537 | 39 |
2324824 | 2324824 | 2022-03-20 | Elliott | Kentucky | 21063 | 2322 | 17 |
2324825 | 2324825 | 2022-03-20 | Estill | Kentucky | 21065 | 4099 | 44 |
2324826 | 2324826 | 2022-03-20 | Fayette | Kentucky | 21067 | 93846 | 569 |
2324827 | 2324827 | 2022-03-20 | Fleming | Kentucky | 21069 | 3691 | 50 |
2324828 | 2324828 | 2022-03-20 | Floyd | Kentucky | 21071 | 12414 | 161 |
2324829 | 2324829 | 2022-03-20 | Franklin | Kentucky | 21073 | 13351 | 138 |
2324830 | 2324830 | 2022-03-20 | Fulton | Kentucky | 21075 | 1157 | 25 |
2324831 | 2324831 | 2022-03-20 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2324832 | 2324832 | 2022-03-20 | Garrard | Kentucky | 21079 | 4756 | 71 |
2324833 | 2324833 | 2022-03-20 | Grant | Kentucky | 21081 | 7685 | 58 |
2324834 | 2324834 | 2022-03-20 | Graves | Kentucky | 21083 | 11328 | 168 |
2324835 | 2324835 | 2022-03-20 | Grayson | Kentucky | 21085 | 8066 | 122 |
2324836 | 2324836 | 2022-03-20 | Green | Kentucky | 21087 | 3602 | 40 |
2324837 | 2324837 | 2022-03-20 | Greenup | Kentucky | 21089 | 11965 | 128 |
2324838 | 2324838 | 2022-03-20 | Hancock | Kentucky | 21091 | 2463 | 23 |
2324839 | 2324839 | 2022-03-20 | Hardin | Kentucky | 21093 | 32341 | 414 |
2324840 | 2324840 | 2022-03-20 | Harlan | Kentucky | 21095 | 9159 | 189 |
2324841 | 2324841 | 2022-03-20 | Harrison | Kentucky | 21097 | 6166 | 64 |
2324842 | 2324842 | 2022-03-20 | Hart | Kentucky | 21099 | 5373 | 94 |
2324843 | 2324843 | 2022-03-20 | Henderson | Kentucky | 21101 | 13743 | 152 |
2324844 | 2324844 | 2022-03-20 | Henry | Kentucky | 21103 | 4750 | 46 |
2324845 | 2324845 | 2022-03-20 | Hickman | Kentucky | 21105 | 825 | 24 |
2324846 | 2324846 | 2022-03-20 | Hopkins | Kentucky | 21107 | 14846 | 248 |
2324847 | 2324847 | 2022-03-20 | Jackson | Kentucky | 21109 | 4231 | 72 |
2324848 | 2324848 | 2022-03-20 | Jefferson | Kentucky | 21111 | 227776 | 2242 |
2324849 | 2324849 | 2022-03-20 | Jessamine | Kentucky | 21113 | 15061 | 132 |
2324850 | 2324850 | 2022-03-20 | Johnson | Kentucky | 21115 | 5950 | 98 |
2324851 | 2324851 | 2022-03-20 | Kenton | Kentucky | 21117 | 45306 | 379 |
2324852 | 2324852 | 2022-03-20 | Knott | Kentucky | 21119 | 4114 | 59 |
2324853 | 2324853 | 2022-03-20 | Knox | Kentucky | 21121 | 11429 | 125 |
2324854 | 2324854 | 2022-03-20 | Larue | Kentucky | 21123 | 3708 | 69 |
2324855 | 2324855 | 2022-03-20 | Laurel | Kentucky | 21125 | 18767 | 209 |
2324856 | 2324856 | 2022-03-20 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2324857 | 2324857 | 2022-03-20 | Lee | Kentucky | 21129 | 2910 | 46 |
2324858 | 2324858 | 2022-03-20 | Leslie | Kentucky | 21131 | 3680 | 39 |
2324859 | 2324859 | 2022-03-20 | Letcher | Kentucky | 21133 | 6901 | 99 |
2324860 | 2324860 | 2022-03-20 | Lewis | Kentucky | 21135 | 4472 | 80 |
2324861 | 2324861 | 2022-03-20 | Lincoln | Kentucky | 21137 | 6270 | 125 |
2324862 | 2324862 | 2022-03-20 | Livingston | Kentucky | 21139 | 2385 | 59 |
2324863 | 2324863 | 2022-03-20 | Logan | Kentucky | 21141 | 8324 | 117 |
2324864 | 2324864 | 2022-03-20 | Lyon | Kentucky | 21143 | 2845 | 33 |
2324865 | 2324865 | 2022-03-20 | Madison | Kentucky | 21151 | 27568 | 254 |
2324866 | 2324866 | 2022-03-20 | Magoffin | Kentucky | 21153 | 3875 | 42 |
2324867 | 2324867 | 2022-03-20 | Marion | Kentucky | 21155 | 6360 | 77 |
2324868 | 2324868 | 2022-03-20 | Marshall | Kentucky | 21157 | 8371 | 99 |
2324869 | 2324869 | 2022-03-20 | Martin | Kentucky | 21159 | 3272 | 49 |
2324870 | 2324870 | 2022-03-20 | Mason | Kentucky | 21161 | 4624 | 100 |
2324871 | 2324871 | 2022-03-20 | McCracken | Kentucky | 21145 | 17950 | 238 |
2324872 | 2324872 | 2022-03-20 | McCreary | Kentucky | 21147 | 5422 | 75 |
2324873 | 2324873 | 2022-03-20 | McLean | Kentucky | 21149 | 2603 | 47 |
2324874 | 2324874 | 2022-03-20 | Meade | Kentucky | 21163 | 5761 | 64 |
2324875 | 2324875 | 2022-03-20 | Menifee | Kentucky | 21165 | 1556 | 31 |
2324876 | 2324876 | 2022-03-20 | Mercer | Kentucky | 21167 | 7310 | 100 |
2324877 | 2324877 | 2022-03-20 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2324878 | 2324878 | 2022-03-20 | Monroe | Kentucky | 21171 | 3611 | 75 |
2324879 | 2324879 | 2022-03-20 | Montgomery | Kentucky | 21173 | 6840 | 89 |
2324880 | 2324880 | 2022-03-20 | Morgan | Kentucky | 21175 | 4834 | 21 |
2324881 | 2324881 | 2022-03-20 | Muhlenberg | Kentucky | 21177 | 10103 | 119 |
2324882 | 2324882 | 2022-03-20 | Nelson | Kentucky | 21179 | 14343 | 147 |
2324883 | 2324883 | 2022-03-20 | Nicholas | Kentucky | 21181 | 1909 | 31 |
2324884 | 2324884 | 2022-03-20 | Ohio | Kentucky | 21183 | 7285 | 96 |
2324885 | 2324885 | 2022-03-20 | Oldham | Kentucky | 21185 | 18137 | 129 |
2324886 | 2324886 | 2022-03-20 | Owen | Kentucky | 21187 | 2353 | 32 |
2324887 | 2324887 | 2022-03-20 | Owsley | Kentucky | 21189 | 1564 | 23 |
2324888 | 2324888 | 2022-03-20 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2324889 | 2324889 | 2022-03-20 | Perry | Kentucky | 21193 | 10721 | 150 |
2324890 | 2324890 | 2022-03-20 | Pike | Kentucky | 21195 | 18706 | 264 |
2324891 | 2324891 | 2022-03-20 | Powell | Kentucky | 21197 | 4718 | 40 |
2324892 | 2324892 | 2022-03-20 | Pulaski | Kentucky | 21199 | 16907 | 264 |
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);