Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, CSV (advanced)
Suggested facets: date (date)
fips
county
state
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 292742 | 292742 | 2020-07-03 | Adair | Kentucky | 21001 | 127 | 19 |
| 292743 | 292743 | 2020-07-03 | Allen | Kentucky | 21003 | 174 | 7 |
| 292744 | 292744 | 2020-07-03 | Anderson | Kentucky | 21005 | 29 | 1 |
| 292745 | 292745 | 2020-07-03 | Ballard | Kentucky | 21007 | 15 | 0 |
| 292746 | 292746 | 2020-07-03 | Barren | Kentucky | 21009 | 92 | 2 |
| 292747 | 292747 | 2020-07-03 | Bath | Kentucky | 21011 | 18 | 1 |
| 292748 | 292748 | 2020-07-03 | Bell | Kentucky | 21013 | 13 | 0 |
| 292749 | 292749 | 2020-07-03 | Boone | Kentucky | 21015 | 615 | 23 |
| 292750 | 292750 | 2020-07-03 | Bourbon | Kentucky | 21017 | 34 | 1 |
| 292751 | 292751 | 2020-07-03 | Boyd | Kentucky | 21019 | 67 | 3 |
| 292752 | 292752 | 2020-07-03 | Boyle | Kentucky | 21021 | 40 | 0 |
| 292753 | 292753 | 2020-07-03 | Bracken | Kentucky | 21023 | 17 | 0 |
| 292754 | 292754 | 2020-07-03 | Breathitt | Kentucky | 21025 | 9 | 0 |
| 292755 | 292755 | 2020-07-03 | Breckinridge | Kentucky | 21027 | 25 | 2 |
| 292756 | 292756 | 2020-07-03 | Bullitt | Kentucky | 21029 | 154 | 4 |
| 292757 | 292757 | 2020-07-03 | Butler | Kentucky | 21031 | 257 | 14 |
| 292758 | 292758 | 2020-07-03 | Caldwell | Kentucky | 21033 | 15 | 0 |
| 292759 | 292759 | 2020-07-03 | Calloway | Kentucky | 21035 | 86 | 1 |
| 292760 | 292760 | 2020-07-03 | Campbell | Kentucky | 21037 | 270 | 13 |
| 292761 | 292761 | 2020-07-03 | Carlisle | Kentucky | 21039 | 5 | 1 |
| 292762 | 292762 | 2020-07-03 | Carroll | Kentucky | 21041 | 42 | 1 |
| 292763 | 292763 | 2020-07-03 | Carter | Kentucky | 21043 | 29 | 0 |
| 292764 | 292764 | 2020-07-03 | Casey | Kentucky | 21045 | 21 | 0 |
| 292765 | 292765 | 2020-07-03 | Christian | Kentucky | 21047 | 262 | 4 |
| 292766 | 292766 | 2020-07-03 | Clark | Kentucky | 21049 | 99 | 5 |
| 292767 | 292767 | 2020-07-03 | Clay | Kentucky | 21051 | 68 | 3 |
| 292768 | 292768 | 2020-07-03 | Clinton | Kentucky | 21053 | 5 | 0 |
| 292769 | 292769 | 2020-07-03 | Crittenden | Kentucky | 21055 | 9 | 1 |
| 292770 | 292770 | 2020-07-03 | Cumberland | Kentucky | 21057 | 6 | 0 |
| 292771 | 292771 | 2020-07-03 | Daviess | Kentucky | 21059 | 452 | 8 |
| 292772 | 292772 | 2020-07-03 | Edmonson | Kentucky | 21061 | 84 | 11 |
| 292773 | 292773 | 2020-07-03 | Elliott | Kentucky | 21063 | 3 | 0 |
| 292774 | 292774 | 2020-07-03 | Estill | Kentucky | 21065 | 4 | 0 |
| 292775 | 292775 | 2020-07-03 | Fayette | Kentucky | 21067 | 1637 | 30 |
| 292776 | 292776 | 2020-07-03 | Fleming | Kentucky | 21069 | 21 | 0 |
| 292777 | 292777 | 2020-07-03 | Floyd | Kentucky | 21071 | 32 | 0 |
| 292778 | 292778 | 2020-07-03 | Franklin | Kentucky | 21073 | 144 | 4 |
| 292779 | 292779 | 2020-07-03 | Fulton | Kentucky | 21075 | 24 | 0 |
| 292780 | 292780 | 2020-07-03 | Gallatin | Kentucky | 21077 | 65 | 8 |
| 292781 | 292781 | 2020-07-03 | Garrard | Kentucky | 21079 | 26 | 0 |
| 292782 | 292782 | 2020-07-03 | Grant | Kentucky | 21081 | 60 | 4 |
| 292783 | 292783 | 2020-07-03 | Graves | Kentucky | 21083 | 219 | 21 |
| 292784 | 292784 | 2020-07-03 | Grayson | Kentucky | 21085 | 140 | 11 |
| 292785 | 292785 | 2020-07-03 | Green | Kentucky | 21087 | 5 | 1 |
| 292786 | 292786 | 2020-07-03 | Greenup | Kentucky | 21089 | 33 | 0 |
| 292787 | 292787 | 2020-07-03 | Hancock | Kentucky | 21091 | 19 | 0 |
| 292788 | 292788 | 2020-07-03 | Hardin | Kentucky | 21093 | 177 | 6 |
| 292789 | 292789 | 2020-07-03 | Harlan | Kentucky | 21095 | 27 | 2 |
| 292790 | 292790 | 2020-07-03 | Harrison | Kentucky | 21097 | 74 | 0 |
| 292791 | 292791 | 2020-07-03 | Hart | Kentucky | 21099 | 49 | 0 |
| 292792 | 292792 | 2020-07-03 | Henderson | Kentucky | 21101 | 170 | 4 |
| 292793 | 292793 | 2020-07-03 | Henry | Kentucky | 21103 | 36 | 2 |
| 292794 | 292794 | 2020-07-03 | Hickman | Kentucky | 21105 | 5 | 0 |
| 292795 | 292795 | 2020-07-03 | Hopkins | Kentucky | 21107 | 266 | 34 |
| 292796 | 292796 | 2020-07-03 | Jackson | Kentucky | 21109 | 114 | 14 |
| 292797 | 292797 | 2020-07-03 | Jefferson | Kentucky | 21111 | 4034 | 211 |
| 292798 | 292798 | 2020-07-03 | Jessamine | Kentucky | 21113 | 111 | 0 |
| 292799 | 292799 | 2020-07-03 | Johnson | Kentucky | 21115 | 10 | 0 |
| 292800 | 292800 | 2020-07-03 | Kenton | Kentucky | 21117 | 814 | 37 |
| 292801 | 292801 | 2020-07-03 | Knott | Kentucky | 21119 | 11 | 0 |
| 292802 | 292802 | 2020-07-03 | Knox | Kentucky | 21121 | 73 | 0 |
| 292803 | 292803 | 2020-07-03 | Larue | Kentucky | 21123 | 17 | 1 |
| 292804 | 292804 | 2020-07-03 | Laurel | Kentucky | 21125 | 124 | 3 |
| 292805 | 292805 | 2020-07-03 | Lawrence | Kentucky | 21127 | 9 | 0 |
| 292806 | 292806 | 2020-07-03 | Lee | Kentucky | 21129 | 1 | 0 |
| 292807 | 292807 | 2020-07-03 | Leslie | Kentucky | 21131 | 10 | 0 |
| 292808 | 292808 | 2020-07-03 | Letcher | Kentucky | 21133 | 14 | 0 |
| 292809 | 292809 | 2020-07-03 | Lewis | Kentucky | 21135 | 22 | 0 |
| 292810 | 292810 | 2020-07-03 | Lincoln | Kentucky | 21137 | 30 | 1 |
| 292811 | 292811 | 2020-07-03 | Livingston | Kentucky | 21139 | 10 | 0 |
| 292812 | 292812 | 2020-07-03 | Logan | Kentucky | 21141 | 227 | 15 |
| 292813 | 292813 | 2020-07-03 | Lyon | Kentucky | 21143 | 20 | 3 |
| 292814 | 292814 | 2020-07-03 | Madison | Kentucky | 21151 | 130 | 1 |
| 292815 | 292815 | 2020-07-03 | Magoffin | Kentucky | 21153 | 6 | 0 |
| 292816 | 292816 | 2020-07-03 | Marion | Kentucky | 21155 | 52 | 0 |
| 292817 | 292817 | 2020-07-03 | Marshall | Kentucky | 21157 | 60 | 2 |
| 292818 | 292818 | 2020-07-03 | Martin | Kentucky | 21159 | 8 | 0 |
| 292819 | 292819 | 2020-07-03 | Mason | Kentucky | 21161 | 33 | 0 |
| 292820 | 292820 | 2020-07-03 | McCracken | Kentucky | 21145 | 172 | 3 |
| 292821 | 292821 | 2020-07-03 | McCreary | Kentucky | 21147 | 18 | 0 |
| 292822 | 292822 | 2020-07-03 | McLean | Kentucky | 21149 | 27 | 0 |
| 292823 | 292823 | 2020-07-03 | Meade | Kentucky | 21163 | 28 | 2 |
| 292824 | 292824 | 2020-07-03 | Menifee | Kentucky | 21165 | 13 | 0 |
| 292825 | 292825 | 2020-07-03 | Mercer | Kentucky | 21167 | 24 | 0 |
| 292826 | 292826 | 2020-07-03 | Metcalfe | Kentucky | 21169 | 11 | 2 |
| 292827 | 292827 | 2020-07-03 | Monroe | Kentucky | 21171 | 40 | 1 |
| 292828 | 292828 | 2020-07-03 | Montgomery | Kentucky | 21173 | 58 | 0 |
| 292829 | 292829 | 2020-07-03 | Morgan | Kentucky | 21175 | 9 | 0 |
| 292830 | 292830 | 2020-07-03 | Muhlenberg | Kentucky | 21177 | 527 | 8 |
| 292831 | 292831 | 2020-07-03 | Nelson | Kentucky | 21179 | 81 | 1 |
| 292832 | 292832 | 2020-07-03 | Nicholas | Kentucky | 21181 | 8 | 0 |
| 292833 | 292833 | 2020-07-03 | Ohio | Kentucky | 21183 | 208 | 0 |
| 292834 | 292834 | 2020-07-03 | Oldham | Kentucky | 21185 | 139 | 7 |
| 292835 | 292835 | 2020-07-03 | Owen | Kentucky | 21187 | 7 | 0 |
| 292836 | 292836 | 2020-07-03 | Owsley | Kentucky | 21189 | 3 | 0 |
| 292837 | 292837 | 2020-07-03 | Pendleton | Kentucky | 21191 | 19 | 0 |
| 292838 | 292838 | 2020-07-03 | Perry | Kentucky | 21193 | 62 | 1 |
| 292839 | 292839 | 2020-07-03 | Pike | Kentucky | 21195 | 99 | 2 |
| 292840 | 292840 | 2020-07-03 | Powell | Kentucky | 21197 | 8 | 0 |
| 292841 | 292841 | 2020-07-03 | Pulaski | Kentucky | 21199 | 100 | 2 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );