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-03-03 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 |
---|---|---|---|---|---|---|---|
1083717 | 1083717 | 2021-03-03 | Adair | Kentucky | 21001 | 1695 | 50 |
1083718 | 1083718 | 2021-03-03 | Allen | Kentucky | 21003 | 1808 | 22 |
1083719 | 1083719 | 2021-03-03 | Anderson | Kentucky | 21005 | 1627 | 16 |
1083720 | 1083720 | 2021-03-03 | Ballard | Kentucky | 21007 | 350 | 5 |
1083721 | 1083721 | 2021-03-03 | Barren | Kentucky | 21009 | 4072 | 71 |
1083722 | 1083722 | 2021-03-03 | Bath | Kentucky | 21011 | 774 | 16 |
1083723 | 1083723 | 2021-03-03 | Bell | Kentucky | 21013 | 2764 | 35 |
1083724 | 1083724 | 2021-03-03 | Boone | Kentucky | 21015 | 13091 | 79 |
1083725 | 1083725 | 2021-03-03 | Bourbon | Kentucky | 21017 | 1555 | 12 |
1083726 | 1083726 | 2021-03-03 | Boyd | Kentucky | 21019 | 4653 | 44 |
1083727 | 1083727 | 2021-03-03 | Boyle | Kentucky | 21021 | 3162 | 37 |
1083728 | 1083728 | 2021-03-03 | Bracken | Kentucky | 21023 | 523 | 4 |
1083729 | 1083729 | 2021-03-03 | Breathitt | Kentucky | 21025 | 921 | 6 |
1083730 | 1083730 | 2021-03-03 | Breckinridge | Kentucky | 21027 | 1106 | 9 |
1083731 | 1083731 | 2021-03-03 | Bullitt | Kentucky | 21029 | 6475 | 49 |
1083732 | 1083732 | 2021-03-03 | Butler | Kentucky | 21031 | 1358 | 23 |
1083733 | 1083733 | 2021-03-03 | Caldwell | Kentucky | 21033 | 1360 | 23 |
1083734 | 1083734 | 2021-03-03 | Calloway | Kentucky | 21035 | 3397 | 38 |
1083735 | 1083735 | 2021-03-03 | Campbell | Kentucky | 21037 | 8139 | 49 |
1083736 | 1083736 | 2021-03-03 | Carlisle | Kentucky | 21039 | 434 | 3 |
1083737 | 1083737 | 2021-03-03 | Carroll | Kentucky | 21041 | 891 | 10 |
1083738 | 1083738 | 2021-03-03 | Carter | Kentucky | 21043 | 2020 | 23 |
1083739 | 1083739 | 2021-03-03 | Casey | Kentucky | 21045 | 1282 | 34 |
1083740 | 1083740 | 2021-03-03 | Christian | Kentucky | 21047 | 6242 | 79 |
1083741 | 1083741 | 2021-03-03 | Clark | Kentucky | 21049 | 2429 | 23 |
1083742 | 1083742 | 2021-03-03 | Clay | Kentucky | 21051 | 2439 | 26 |
1083743 | 1083743 | 2021-03-03 | Clinton | Kentucky | 21053 | 1403 | 27 |
1083744 | 1083744 | 2021-03-03 | Crittenden | Kentucky | 21055 | 568 | 17 |
1083745 | 1083745 | 2021-03-03 | Cumberland | Kentucky | 21057 | 660 | 9 |
1083746 | 1083746 | 2021-03-03 | Daviess | Kentucky | 21059 | 9761 | 161 |
1083747 | 1083747 | 2021-03-03 | Edmonson | Kentucky | 21061 | 890 | 18 |
1083748 | 1083748 | 2021-03-03 | Elliott | Kentucky | 21063 | 932 | 2 |
1083749 | 1083749 | 2021-03-03 | Estill | Kentucky | 21065 | 976 | 2 |
1083750 | 1083750 | 2021-03-03 | Fayette | Kentucky | 21067 | 32789 | 234 |
1083751 | 1083751 | 2021-03-03 | Fleming | Kentucky | 21069 | 1086 | 14 |
1083752 | 1083752 | 2021-03-03 | Floyd | Kentucky | 21071 | 3045 | 43 |
1083753 | 1083753 | 2021-03-03 | Franklin | Kentucky | 21073 | 3668 | 29 |
1083754 | 1083754 | 2021-03-03 | Fulton | Kentucky | 21075 | 482 | 6 |
1083755 | 1083755 | 2021-03-03 | Gallatin | Kentucky | 21077 | 651 | 19 |
1083756 | 1083756 | 2021-03-03 | Garrard | Kentucky | 21079 | 1400 | 12 |
1083757 | 1083757 | 2021-03-03 | Grant | Kentucky | 21081 | 2229 | 14 |
1083758 | 1083758 | 2021-03-03 | Graves | Kentucky | 21083 | 3964 | 71 |
1083759 | 1083759 | 2021-03-03 | Grayson | Kentucky | 21085 | 1967 | 48 |
1083760 | 1083760 | 2021-03-03 | Green | Kentucky | 21087 | 1131 | 13 |
1083761 | 1083761 | 2021-03-03 | Greenup | Kentucky | 21089 | 3333 | 23 |
1083762 | 1083762 | 2021-03-03 | Hancock | Kentucky | 21091 | 805 | 15 |
1083763 | 1083763 | 2021-03-03 | Hardin | Kentucky | 21093 | 8892 | 96 |
1083764 | 1083764 | 2021-03-03 | Harlan | Kentucky | 21095 | 2398 | 69 |
1083765 | 1083765 | 2021-03-03 | Harrison | Kentucky | 21097 | 1514 | 9 |
1083766 | 1083766 | 2021-03-03 | Hart | Kentucky | 21099 | 1838 | 33 |
1083767 | 1083767 | 2021-03-03 | Henderson | Kentucky | 21101 | 4336 | 60 |
1083768 | 1083768 | 2021-03-03 | Henry | Kentucky | 21103 | 1234 | 8 |
1083769 | 1083769 | 2021-03-03 | Hickman | Kentucky | 21105 | 325 | 7 |
1083770 | 1083770 | 2021-03-03 | Hopkins | Kentucky | 21107 | 3956 | 128 |
1083771 | 1083771 | 2021-03-03 | Jackson | Kentucky | 21109 | 1212 | 29 |
1083772 | 1083772 | 2021-03-03 | Jefferson | Kentucky | 21111 | 74543 | 928 |
1083773 | 1083773 | 2021-03-03 | Jessamine | Kentucky | 21113 | 4206 | 53 |
1083774 | 1083774 | 2021-03-03 | Johnson | Kentucky | 21115 | 1808 | 18 |
1083775 | 1083775 | 2021-03-03 | Kenton | Kentucky | 21117 | 15523 | 130 |
1083776 | 1083776 | 2021-03-03 | Knott | Kentucky | 21119 | 1059 | 17 |
1083777 | 1083777 | 2021-03-03 | Knox | Kentucky | 21121 | 2951 | 11 |
1083778 | 1083778 | 2021-03-03 | Larue | Kentucky | 21123 | 1224 | 16 |
1083779 | 1083779 | 2021-03-03 | Laurel | Kentucky | 21125 | 5878 | 31 |
1083780 | 1083780 | 2021-03-03 | Lawrence | Kentucky | 21127 | 1269 | 20 |
1083781 | 1083781 | 2021-03-03 | Lee | Kentucky | 21129 | 1200 | 19 |
1083782 | 1083782 | 2021-03-03 | Leslie | Kentucky | 21131 | 801 | 2 |
1083783 | 1083783 | 2021-03-03 | Letcher | Kentucky | 21133 | 1705 | 30 |
1083784 | 1083784 | 2021-03-03 | Lewis | Kentucky | 21135 | 1099 | 31 |
1083785 | 1083785 | 2021-03-03 | Lincoln | Kentucky | 21137 | 2129 | 33 |
1083786 | 1083786 | 2021-03-03 | Livingston | Kentucky | 21139 | 766 | 17 |
1083787 | 1083787 | 2021-03-03 | Logan | Kentucky | 21141 | 2509 | 51 |
1083788 | 1083788 | 2021-03-03 | Lyon | Kentucky | 21143 | 702 | 13 |
1083789 | 1083789 | 2021-03-03 | Madison | Kentucky | 21151 | 8695 | 89 |
1083790 | 1083790 | 2021-03-03 | Magoffin | Kentucky | 21153 | 879 | 1 |
1083791 | 1083791 | 2021-03-03 | Marion | Kentucky | 21155 | 2160 | 24 |
1083792 | 1083792 | 2021-03-03 | Marshall | Kentucky | 21157 | 2548 | 48 |
1083793 | 1083793 | 2021-03-03 | Martin | Kentucky | 21159 | 938 | 11 |
1083794 | 1083794 | 2021-03-03 | Mason | Kentucky | 21161 | 1456 | 27 |
1083795 | 1083795 | 2021-03-03 | McCracken | Kentucky | 21145 | 5825 | 71 |
1083796 | 1083796 | 2021-03-03 | McCreary | Kentucky | 21147 | 1804 | 26 |
1083797 | 1083797 | 2021-03-03 | McLean | Kentucky | 21149 | 836 | 25 |
1083798 | 1083798 | 2021-03-03 | Meade | Kentucky | 21163 | 1870 | 16 |
1083799 | 1083799 | 2021-03-03 | Menifee | Kentucky | 21165 | 412 | 13 |
1083800 | 1083800 | 2021-03-03 | Mercer | Kentucky | 21167 | 2367 | 33 |
1083801 | 1083801 | 2021-03-03 | Metcalfe | Kentucky | 21169 | 973 | 20 |
1083802 | 1083802 | 2021-03-03 | Monroe | Kentucky | 21171 | 1248 | 38 |
1083803 | 1083803 | 2021-03-03 | Montgomery | Kentucky | 21173 | 2311 | 24 |
1083804 | 1083804 | 2021-03-03 | Morgan | Kentucky | 21175 | 2038 | 1 |
1083805 | 1083805 | 2021-03-03 | Muhlenberg | Kentucky | 21177 | 2764 | 55 |
1083806 | 1083806 | 2021-03-03 | Nelson | Kentucky | 21179 | 4612 | 41 |
1083807 | 1083807 | 2021-03-03 | Nicholas | Kentucky | 21181 | 461 | 6 |
1083808 | 1083808 | 2021-03-03 | Ohio | Kentucky | 21183 | 2363 | 48 |
1083809 | 1083809 | 2021-03-03 | Oldham | Kentucky | 21185 | 6964 | 69 |
1083810 | 1083810 | 2021-03-03 | Owen | Kentucky | 21187 | 626 | 8 |
1083811 | 1083811 | 2021-03-03 | Owsley | Kentucky | 21189 | 432 | 10 |
1083812 | 1083812 | 2021-03-03 | Pendleton | Kentucky | 21191 | 946 | 1 |
1083813 | 1083813 | 2021-03-03 | Perry | Kentucky | 21193 | 2348 | 38 |
1083814 | 1083814 | 2021-03-03 | Pike | Kentucky | 21195 | 5173 | 60 |
1083815 | 1083815 | 2021-03-03 | Powell | Kentucky | 21197 | 979 | 3 |
1083816 | 1083816 | 2021-03-03 | Pulaski | Kentucky | 21199 | 5794 | 87 |
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);