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 2021-01-01 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 |
---|---|---|---|---|---|---|---|
885738 | 885738 | 2021-01-01 | Adair | Kentucky | 21001 | 1294 | 45 |
885739 | 885739 | 2021-01-01 | Allen | Kentucky | 21003 | 1167 | 18 |
885740 | 885740 | 2021-01-01 | Anderson | Kentucky | 21005 | 971 | 2 |
885741 | 885741 | 2021-01-01 | Ballard | Kentucky | 21007 | 233 | 2 |
885742 | 885742 | 2021-01-01 | Barren | Kentucky | 21009 | 2563 | 35 |
885743 | 885743 | 2021-01-01 | Bath | Kentucky | 21011 | 505 | 8 |
885744 | 885744 | 2021-01-01 | Bell | Kentucky | 21013 | 1787 | 26 |
885745 | 885745 | 2021-01-01 | Boone | Kentucky | 21015 | 7800 | 43 |
885746 | 885746 | 2021-01-01 | Bourbon | Kentucky | 21017 | 1000 | 1 |
885747 | 885747 | 2021-01-01 | Boyd | Kentucky | 21019 | 3003 | 31 |
885748 | 885748 | 2021-01-01 | Boyle | Kentucky | 21021 | 2162 | 2 |
885749 | 885749 | 2021-01-01 | Bracken | Kentucky | 21023 | 275 | 3 |
885750 | 885750 | 2021-01-01 | Breathitt | Kentucky | 21025 | 597 | 3 |
885751 | 885751 | 2021-01-01 | Breckinridge | Kentucky | 21027 | 658 | 5 |
885752 | 885752 | 2021-01-01 | Bullitt | Kentucky | 21029 | 4134 | 30 |
885753 | 885753 | 2021-01-01 | Butler | Kentucky | 21031 | 814 | 16 |
885754 | 885754 | 2021-01-01 | Caldwell | Kentucky | 21033 | 869 | 15 |
885755 | 885755 | 2021-01-01 | Calloway | Kentucky | 21035 | 2344 | 25 |
885756 | 885756 | 2021-01-01 | Campbell | Kentucky | 21037 | 4650 | 35 |
885757 | 885757 | 2021-01-01 | Carlisle | Kentucky | 21039 | 328 | 1 |
885758 | 885758 | 2021-01-01 | Carroll | Kentucky | 21041 | 527 | 6 |
885759 | 885759 | 2021-01-01 | Carter | Kentucky | 21043 | 1363 | 6 |
885760 | 885760 | 2021-01-01 | Casey | Kentucky | 21045 | 884 | 27 |
885761 | 885761 | 2021-01-01 | Christian | Kentucky | 21047 | 4310 | 57 |
885762 | 885762 | 2021-01-01 | Clark | Kentucky | 21049 | 1452 | 15 |
885763 | 885763 | 2021-01-01 | Clay | Kentucky | 21051 | 1623 | 8 |
885764 | 885764 | 2021-01-01 | Clinton | Kentucky | 21053 | 923 | 20 |
885765 | 885765 | 2021-01-01 | Crittenden | Kentucky | 21055 | 336 | 3 |
885766 | 885766 | 2021-01-01 | Cumberland | Kentucky | 21057 | 427 | 6 |
885767 | 885767 | 2021-01-01 | Daviess | Kentucky | 21059 | 5737 | 92 |
885768 | 885768 | 2021-01-01 | Edmonson | Kentucky | 21061 | 559 | 13 |
885769 | 885769 | 2021-01-01 | Elliott | Kentucky | 21063 | 784 | 1 |
885770 | 885770 | 2021-01-01 | Estill | Kentucky | 21065 | 670 | 0 |
885771 | 885771 | 2021-01-01 | Fayette | Kentucky | 21067 | 23169 | 160 |
885772 | 885772 | 2021-01-01 | Fleming | Kentucky | 21069 | 711 | 2 |
885773 | 885773 | 2021-01-01 | Floyd | Kentucky | 21071 | 1805 | 15 |
885774 | 885774 | 2021-01-01 | Franklin | Kentucky | 21073 | 2132 | 19 |
885775 | 885775 | 2021-01-01 | Fulton | Kentucky | 21075 | 363 | 4 |
885776 | 885776 | 2021-01-01 | Gallatin | Kentucky | 21077 | 426 | 9 |
885777 | 885777 | 2021-01-01 | Garrard | Kentucky | 21079 | 940 | 4 |
885778 | 885778 | 2021-01-01 | Grant | Kentucky | 21081 | 1289 | 8 |
885779 | 885779 | 2021-01-01 | Graves | Kentucky | 21083 | 2632 | 47 |
885780 | 885780 | 2021-01-01 | Grayson | Kentucky | 21085 | 1295 | 32 |
885781 | 885781 | 2021-01-01 | Green | Kentucky | 21087 | 811 | 12 |
885782 | 885782 | 2021-01-01 | Greenup | Kentucky | 21089 | 2275 | 19 |
885783 | 885783 | 2021-01-01 | Hancock | Kentucky | 21091 | 447 | 12 |
885784 | 885784 | 2021-01-01 | Hardin | Kentucky | 21093 | 5949 | 42 |
885785 | 885785 | 2021-01-01 | Harlan | Kentucky | 21095 | 1538 | 18 |
885786 | 885786 | 2021-01-01 | Harrison | Kentucky | 21097 | 729 | 1 |
885787 | 885787 | 2021-01-01 | Hart | Kentucky | 21099 | 1238 | 9 |
885788 | 885788 | 2021-01-01 | Henderson | Kentucky | 21101 | 2939 | 49 |
885789 | 885789 | 2021-01-01 | Henry | Kentucky | 21103 | 814 | 4 |
885790 | 885790 | 2021-01-01 | Hickman | Kentucky | 21105 | 223 | 5 |
885791 | 885791 | 2021-01-01 | Hopkins | Kentucky | 21107 | 2670 | 103 |
885792 | 885792 | 2021-01-01 | Jackson | Kentucky | 21109 | 846 | 19 |
885793 | 885793 | 2021-01-01 | Jefferson | Kentucky | 21111 | 52883 | 658 |
885794 | 885794 | 2021-01-01 | Jessamine | Kentucky | 21113 | 2621 | 46 |
885795 | 885795 | 2021-01-01 | Johnson | Kentucky | 21115 | 1120 | 15 |
885796 | 885796 | 2021-01-01 | Kenton | Kentucky | 21117 | 8997 | 79 |
885797 | 885797 | 2021-01-01 | Knott | Kentucky | 21119 | 738 | 14 |
885798 | 885798 | 2021-01-01 | Knox | Kentucky | 21121 | 1763 | 10 |
885799 | 885799 | 2021-01-01 | Larue | Kentucky | 21123 | 816 | 4 |
885800 | 885800 | 2021-01-01 | Laurel | Kentucky | 21125 | 3645 | 14 |
885801 | 885801 | 2021-01-01 | Lawrence | Kentucky | 21127 | 758 | 5 |
885802 | 885802 | 2021-01-01 | Lee | Kentucky | 21129 | 1043 | 18 |
885803 | 885803 | 2021-01-01 | Leslie | Kentucky | 21131 | 471 | 1 |
885804 | 885804 | 2021-01-01 | Letcher | Kentucky | 21133 | 1027 | 3 |
885805 | 885805 | 2021-01-01 | Lewis | Kentucky | 21135 | 775 | 23 |
885806 | 885806 | 2021-01-01 | Lincoln | Kentucky | 21137 | 1443 | 23 |
885807 | 885807 | 2021-01-01 | Livingston | Kentucky | 21139 | 488 | 5 |
885808 | 885808 | 2021-01-01 | Logan | Kentucky | 21141 | 1697 | 39 |
885809 | 885809 | 2021-01-01 | Lyon | Kentucky | 21143 | 320 | 5 |
885810 | 885810 | 2021-01-01 | Madison | Kentucky | 21151 | 5706 | 35 |
885811 | 885811 | 2021-01-01 | Magoffin | Kentucky | 21153 | 701 | 1 |
885812 | 885812 | 2021-01-01 | Marion | Kentucky | 21155 | 1510 | 20 |
885813 | 885813 | 2021-01-01 | Marshall | Kentucky | 21157 | 1558 | 20 |
885814 | 885814 | 2021-01-01 | Martin | Kentucky | 21159 | 657 | 10 |
885815 | 885815 | 2021-01-01 | Mason | Kentucky | 21161 | 920 | 17 |
885816 | 885816 | 2021-01-01 | McCracken | Kentucky | 21145 | 4265 | 41 |
885817 | 885817 | 2021-01-01 | McCreary | Kentucky | 21147 | 1164 | 8 |
885818 | 885818 | 2021-01-01 | McLean | Kentucky | 21149 | 549 | 21 |
885819 | 885819 | 2021-01-01 | Meade | Kentucky | 21163 | 1133 | 4 |
885820 | 885820 | 2021-01-01 | Menifee | Kentucky | 21165 | 215 | 1 |
885821 | 885821 | 2021-01-01 | Mercer | Kentucky | 21167 | 1365 | 6 |
885822 | 885822 | 2021-01-01 | Metcalfe | Kentucky | 21169 | 601 | 9 |
885823 | 885823 | 2021-01-01 | Monroe | Kentucky | 21171 | 945 | 26 |
885824 | 885824 | 2021-01-01 | Montgomery | Kentucky | 21173 | 1378 | 12 |
885825 | 885825 | 2021-01-01 | Morgan | Kentucky | 21175 | 518 | 0 |
885826 | 885826 | 2021-01-01 | Muhlenberg | Kentucky | 21177 | 2027 | 38 |
885827 | 885827 | 2021-01-01 | Nelson | Kentucky | 21179 | 2855 | 17 |
885828 | 885828 | 2021-01-01 | Nicholas | Kentucky | 21181 | 255 | 3 |
885829 | 885829 | 2021-01-01 | Ohio | Kentucky | 21183 | 1505 | 30 |
885830 | 885830 | 2021-01-01 | Oldham | Kentucky | 21185 | 3737 | 48 |
885831 | 885831 | 2021-01-01 | Owen | Kentucky | 21187 | 428 | 6 |
885832 | 885832 | 2021-01-01 | Owsley | Kentucky | 21189 | 304 | 10 |
885833 | 885833 | 2021-01-01 | Pendleton | Kentucky | 21191 | 612 | 1 |
885834 | 885834 | 2021-01-01 | Perry | Kentucky | 21193 | 1552 | 15 |
885835 | 885835 | 2021-01-01 | Pike | Kentucky | 21195 | 2923 | 34 |
885836 | 885836 | 2021-01-01 | Powell | Kentucky | 21197 | 686 | 0 |
885837 | 885837 | 2021-01-01 | Pulaski | Kentucky | 21199 | 3875 | 62 |
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);