ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-12-24" 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 |
---|---|---|---|---|---|---|---|
859778 | 859778 | 2020-12-24 | Adair | Kentucky | 21001 | 1241 | 41 |
859779 | 859779 | 2020-12-24 | Allen | Kentucky | 21003 | 1071 | 17 |
859780 | 859780 | 2020-12-24 | Anderson | Kentucky | 21005 | 874 | 1 |
859781 | 859781 | 2020-12-24 | Ballard | Kentucky | 21007 | 220 | 2 |
859782 | 859782 | 2020-12-24 | Barren | Kentucky | 21009 | 2488 | 34 |
859783 | 859783 | 2020-12-24 | Bath | Kentucky | 21011 | 482 | 4 |
859784 | 859784 | 2020-12-24 | Bell | Kentucky | 21013 | 1683 | 23 |
859785 | 859785 | 2020-12-24 | Boone | Kentucky | 21015 | 7350 | 42 |
859786 | 859786 | 2020-12-24 | Bourbon | Kentucky | 21017 | 838 | 1 |
859787 | 859787 | 2020-12-24 | Boyd | Kentucky | 21019 | 2795 | 31 |
859788 | 859788 | 2020-12-24 | Boyle | Kentucky | 21021 | 1820 | 0 |
859789 | 859789 | 2020-12-24 | Bracken | Kentucky | 21023 | 264 | 3 |
859790 | 859790 | 2020-12-24 | Breathitt | Kentucky | 21025 | 543 | 3 |
859791 | 859791 | 2020-12-24 | Breckinridge | Kentucky | 21027 | 609 | 4 |
859792 | 859792 | 2020-12-24 | Bullitt | Kentucky | 21029 | 3901 | 28 |
859793 | 859793 | 2020-12-24 | Butler | Kentucky | 21031 | 770 | 16 |
859794 | 859794 | 2020-12-24 | Caldwell | Kentucky | 21033 | 851 | 15 |
859795 | 859795 | 2020-12-24 | Calloway | Kentucky | 21035 | 2217 | 23 |
859796 | 859796 | 2020-12-24 | Campbell | Kentucky | 21037 | 4381 | 35 |
859797 | 859797 | 2020-12-24 | Carlisle | Kentucky | 21039 | 286 | 1 |
859798 | 859798 | 2020-12-24 | Carroll | Kentucky | 21041 | 499 | 6 |
859799 | 859799 | 2020-12-24 | Carter | Kentucky | 21043 | 1274 | 6 |
859800 | 859800 | 2020-12-24 | Casey | Kentucky | 21045 | 858 | 27 |
859801 | 859801 | 2020-12-24 | Christian | Kentucky | 21047 | 3999 | 56 |
859802 | 859802 | 2020-12-24 | Clark | Kentucky | 21049 | 1379 | 15 |
859803 | 859803 | 2020-12-24 | Clay | Kentucky | 21051 | 1466 | 8 |
859804 | 859804 | 2020-12-24 | Clinton | Kentucky | 21053 | 807 | 18 |
859805 | 859805 | 2020-12-24 | Crittenden | Kentucky | 21055 | 327 | 3 |
859806 | 859806 | 2020-12-24 | Cumberland | Kentucky | 21057 | 397 | 5 |
859807 | 859807 | 2020-12-24 | Daviess | Kentucky | 21059 | 5363 | 82 |
859808 | 859808 | 2020-12-24 | Edmonson | Kentucky | 21061 | 537 | 13 |
859809 | 859809 | 2020-12-24 | Elliott | Kentucky | 21063 | 749 | 1 |
859810 | 859810 | 2020-12-24 | Estill | Kentucky | 21065 | 630 | 0 |
859811 | 859811 | 2020-12-24 | Fayette | Kentucky | 21067 | 22165 | 153 |
859812 | 859812 | 2020-12-24 | Fleming | Kentucky | 21069 | 622 | 2 |
859813 | 859813 | 2020-12-24 | Floyd | Kentucky | 21071 | 1688 | 9 |
859814 | 859814 | 2020-12-24 | Franklin | Kentucky | 21073 | 2018 | 17 |
859815 | 859815 | 2020-12-24 | Fulton | Kentucky | 21075 | 346 | 4 |
859816 | 859816 | 2020-12-24 | Gallatin | Kentucky | 21077 | 408 | 9 |
859817 | 859817 | 2020-12-24 | Garrard | Kentucky | 21079 | 891 | 4 |
859818 | 859818 | 2020-12-24 | Grant | Kentucky | 21081 | 1222 | 8 |
859819 | 859819 | 2020-12-24 | Graves | Kentucky | 21083 | 2458 | 45 |
859820 | 859820 | 2020-12-24 | Grayson | Kentucky | 21085 | 1219 | 28 |
859821 | 859821 | 2020-12-24 | Green | Kentucky | 21087 | 773 | 12 |
859822 | 859822 | 2020-12-24 | Greenup | Kentucky | 21089 | 2086 | 19 |
859823 | 859823 | 2020-12-24 | Hancock | Kentucky | 21091 | 408 | 12 |
859824 | 859824 | 2020-12-24 | Hardin | Kentucky | 21093 | 5604 | 41 |
859825 | 859825 | 2020-12-24 | Harlan | Kentucky | 21095 | 1429 | 18 |
859826 | 859826 | 2020-12-24 | Harrison | Kentucky | 21097 | 689 | 1 |
859827 | 859827 | 2020-12-24 | Hart | Kentucky | 21099 | 1217 | 8 |
859828 | 859828 | 2020-12-24 | Henderson | Kentucky | 21101 | 2765 | 48 |
859829 | 859829 | 2020-12-24 | Henry | Kentucky | 21103 | 756 | 4 |
859830 | 859830 | 2020-12-24 | Hickman | Kentucky | 21105 | 222 | 3 |
859831 | 859831 | 2020-12-24 | Hopkins | Kentucky | 21107 | 2480 | 95 |
859832 | 859832 | 2020-12-24 | Jackson | Kentucky | 21109 | 802 | 19 |
859833 | 859833 | 2020-12-24 | Jefferson | Kentucky | 21111 | 49900 | 628 |
859834 | 859834 | 2020-12-24 | Jessamine | Kentucky | 21113 | 2492 | 42 |
859835 | 859835 | 2020-12-24 | Johnson | Kentucky | 21115 | 1084 | 14 |
859836 | 859836 | 2020-12-24 | Kenton | Kentucky | 21117 | 8406 | 79 |
859837 | 859837 | 2020-12-24 | Knott | Kentucky | 21119 | 706 | 13 |
859838 | 859838 | 2020-12-24 | Knox | Kentucky | 21121 | 1620 | 10 |
859839 | 859839 | 2020-12-24 | Larue | Kentucky | 21123 | 785 | 3 |
859840 | 859840 | 2020-12-24 | Laurel | Kentucky | 21125 | 3375 | 12 |
859841 | 859841 | 2020-12-24 | Lawrence | Kentucky | 21127 | 641 | 4 |
859842 | 859842 | 2020-12-24 | Lee | Kentucky | 21129 | 1023 | 18 |
859843 | 859843 | 2020-12-24 | Leslie | Kentucky | 21131 | 442 | 1 |
859844 | 859844 | 2020-12-24 | Letcher | Kentucky | 21133 | 924 | 4 |
859845 | 859845 | 2020-12-24 | Lewis | Kentucky | 21135 | 716 | 22 |
859846 | 859846 | 2020-12-24 | Lincoln | Kentucky | 21137 | 1335 | 23 |
859847 | 859847 | 2020-12-24 | Livingston | Kentucky | 21139 | 467 | 5 |
859848 | 859848 | 2020-12-24 | Logan | Kentucky | 21141 | 1613 | 37 |
859849 | 859849 | 2020-12-24 | Lyon | Kentucky | 21143 | 300 | 5 |
859850 | 859850 | 2020-12-24 | Madison | Kentucky | 21151 | 5505 | 27 |
859851 | 859851 | 2020-12-24 | Magoffin | Kentucky | 21153 | 689 | 1 |
859852 | 859852 | 2020-12-24 | Marion | Kentucky | 21155 | 1472 | 20 |
859853 | 859853 | 2020-12-24 | Marshall | Kentucky | 21157 | 1396 | 19 |
859854 | 859854 | 2020-12-24 | Martin | Kentucky | 21159 | 628 | 10 |
859855 | 859855 | 2020-12-24 | Mason | Kentucky | 21161 | 834 | 13 |
859856 | 859856 | 2020-12-24 | McCracken | Kentucky | 21145 | 4074 | 38 |
859857 | 859857 | 2020-12-24 | McCreary | Kentucky | 21147 | 1044 | 6 |
859858 | 859858 | 2020-12-24 | McLean | Kentucky | 21149 | 523 | 20 |
859859 | 859859 | 2020-12-24 | Meade | Kentucky | 21163 | 1063 | 4 |
859860 | 859860 | 2020-12-24 | Menifee | Kentucky | 21165 | 184 | 1 |
859861 | 859861 | 2020-12-24 | Mercer | Kentucky | 21167 | 1258 | 6 |
859862 | 859862 | 2020-12-24 | Metcalfe | Kentucky | 21169 | 572 | 7 |
859863 | 859863 | 2020-12-24 | Monroe | Kentucky | 21171 | 907 | 21 |
859864 | 859864 | 2020-12-24 | Montgomery | Kentucky | 21173 | 1303 | 12 |
859865 | 859865 | 2020-12-24 | Morgan | Kentucky | 21175 | 490 | 0 |
859866 | 859866 | 2020-12-24 | Muhlenberg | Kentucky | 21177 | 1865 | 34 |
859867 | 859867 | 2020-12-24 | Nelson | Kentucky | 21179 | 2700 | 17 |
859868 | 859868 | 2020-12-24 | Nicholas | Kentucky | 21181 | 236 | 3 |
859869 | 859869 | 2020-12-24 | Ohio | Kentucky | 21183 | 1433 | 30 |
859870 | 859870 | 2020-12-24 | Oldham | Kentucky | 21185 | 3483 | 48 |
859871 | 859871 | 2020-12-24 | Owen | Kentucky | 21187 | 401 | 4 |
859872 | 859872 | 2020-12-24 | Owsley | Kentucky | 21189 | 287 | 10 |
859873 | 859873 | 2020-12-24 | Pendleton | Kentucky | 21191 | 580 | 1 |
859874 | 859874 | 2020-12-24 | Perry | Kentucky | 21193 | 1470 | 12 |
859875 | 859875 | 2020-12-24 | Pike | Kentucky | 21195 | 2692 | 33 |
859876 | 859876 | 2020-12-24 | Powell | Kentucky | 21197 | 661 | 0 |
859877 | 859877 | 2020-12-24 | Pulaski | Kentucky | 21199 | 3616 | 55 |
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);