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 2020-11-13 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 |
---|---|---|---|---|---|---|---|
726715 | 726715 | 2020-11-13 | Adair | Kentucky | 21001 | 764 | 29 |
726716 | 726716 | 2020-11-13 | Allen | Kentucky | 21003 | 619 | 14 |
726717 | 726717 | 2020-11-13 | Anderson | Kentucky | 21005 | 361 | 1 |
726718 | 726718 | 2020-11-13 | Ballard | Kentucky | 21007 | 109 | 1 |
726719 | 726719 | 2020-11-13 | Barren | Kentucky | 21009 | 1626 | 22 |
726720 | 726720 | 2020-11-13 | Bath | Kentucky | 21011 | 190 | 1 |
726721 | 726721 | 2020-11-13 | Bell | Kentucky | 21013 | 1039 | 18 |
726722 | 726722 | 2020-11-13 | Boone | Kentucky | 21015 | 3136 | 26 |
726723 | 726723 | 2020-11-13 | Bourbon | Kentucky | 21017 | 430 | 1 |
726724 | 726724 | 2020-11-13 | Boyd | Kentucky | 21019 | 968 | 23 |
726725 | 726725 | 2020-11-13 | Boyle | Kentucky | 21021 | 630 | 0 |
726726 | 726726 | 2020-11-13 | Bracken | Kentucky | 21023 | 99 | 3 |
726727 | 726727 | 2020-11-13 | Breathitt | Kentucky | 21025 | 215 | 2 |
726728 | 726728 | 2020-11-13 | Breckinridge | Kentucky | 21027 | 326 | 3 |
726729 | 726729 | 2020-11-13 | Bullitt | Kentucky | 21029 | 2105 | 22 |
726730 | 726730 | 2020-11-13 | Butler | Kentucky | 21031 | 491 | 16 |
726731 | 726731 | 2020-11-13 | Caldwell | Kentucky | 21033 | 407 | 0 |
726732 | 726732 | 2020-11-13 | Calloway | Kentucky | 21035 | 1302 | 10 |
726733 | 726733 | 2020-11-13 | Campbell | Kentucky | 21037 | 1977 | 20 |
726734 | 726734 | 2020-11-13 | Carlisle | Kentucky | 21039 | 141 | 1 |
726735 | 726735 | 2020-11-13 | Carroll | Kentucky | 21041 | 261 | 6 |
726736 | 726736 | 2020-11-13 | Carter | Kentucky | 21043 | 502 | 4 |
726737 | 726737 | 2020-11-13 | Casey | Kentucky | 21045 | 469 | 17 |
726738 | 726738 | 2020-11-13 | Christian | Kentucky | 21047 | 2393 | 35 |
726739 | 726739 | 2020-11-13 | Clark | Kentucky | 21049 | 668 | 12 |
726740 | 726740 | 2020-11-13 | Clay | Kentucky | 21051 | 780 | 7 |
726741 | 726741 | 2020-11-13 | Clinton | Kentucky | 21053 | 365 | 7 |
726742 | 726742 | 2020-11-13 | Crittenden | Kentucky | 21055 | 193 | 1 |
726743 | 726743 | 2020-11-13 | Cumberland | Kentucky | 21057 | 227 | 0 |
726744 | 726744 | 2020-11-13 | Daviess | Kentucky | 21059 | 2593 | 35 |
726745 | 726745 | 2020-11-13 | Edmonson | Kentucky | 21061 | 262 | 12 |
726746 | 726746 | 2020-11-13 | Elliott | Kentucky | 21063 | 449 | 0 |
726747 | 726747 | 2020-11-13 | Estill | Kentucky | 21065 | 361 | 0 |
726748 | 726748 | 2020-11-13 | Fayette | Kentucky | 21067 | 13448 | 103 |
726749 | 726749 | 2020-11-13 | Fleming | Kentucky | 21069 | 237 | 0 |
726750 | 726750 | 2020-11-13 | Floyd | Kentucky | 21071 | 788 | 4 |
726751 | 726751 | 2020-11-13 | Franklin | Kentucky | 21073 | 1083 | 14 |
726752 | 726752 | 2020-11-13 | Fulton | Kentucky | 21075 | 259 | 3 |
726753 | 726753 | 2020-11-13 | Gallatin | Kentucky | 21077 | 157 | 8 |
726754 | 726754 | 2020-11-13 | Garrard | Kentucky | 21079 | 415 | 4 |
726755 | 726755 | 2020-11-13 | Grant | Kentucky | 21081 | 429 | 6 |
726756 | 726756 | 2020-11-13 | Graves | Kentucky | 21083 | 1243 | 32 |
726757 | 726757 | 2020-11-13 | Grayson | Kentucky | 21085 | 722 | 18 |
726758 | 726758 | 2020-11-13 | Green | Kentucky | 21087 | 452 | 10 |
726759 | 726759 | 2020-11-13 | Greenup | Kentucky | 21089 | 889 | 12 |
726760 | 726760 | 2020-11-13 | Hancock | Kentucky | 21091 | 222 | 6 |
726761 | 726761 | 2020-11-13 | Hardin | Kentucky | 21093 | 3009 | 29 |
726762 | 726762 | 2020-11-13 | Harlan | Kentucky | 21095 | 733 | 15 |
726763 | 726763 | 2020-11-13 | Harrison | Kentucky | 21097 | 330 | 1 |
726764 | 726764 | 2020-11-13 | Hart | Kentucky | 21099 | 626 | 3 |
726765 | 726765 | 2020-11-13 | Henderson | Kentucky | 21101 | 1678 | 36 |
726766 | 726766 | 2020-11-13 | Henry | Kentucky | 21103 | 383 | 3 |
726767 | 726767 | 2020-11-13 | Hickman | Kentucky | 21105 | 128 | 1 |
726768 | 726768 | 2020-11-13 | Hopkins | Kentucky | 21107 | 1441 | 45 |
726769 | 726769 | 2020-11-13 | Jackson | Kentucky | 21109 | 567 | 17 |
726770 | 726770 | 2020-11-13 | Jefferson | Kentucky | 21111 | 29971 | 439 |
726771 | 726771 | 2020-11-13 | Jessamine | Kentucky | 21113 | 1291 | 23 |
726772 | 726772 | 2020-11-13 | Johnson | Kentucky | 21115 | 552 | 2 |
726773 | 726773 | 2020-11-13 | Kenton | Kentucky | 21117 | 3892 | 51 |
726774 | 726774 | 2020-11-13 | Knott | Kentucky | 21119 | 447 | 8 |
726775 | 726775 | 2020-11-13 | Knox | Kentucky | 21121 | 1013 | 10 |
726776 | 726776 | 2020-11-13 | Larue | Kentucky | 21123 | 467 | 2 |
726777 | 726777 | 2020-11-13 | Laurel | Kentucky | 21125 | 1955 | 11 |
726778 | 726778 | 2020-11-13 | Lawrence | Kentucky | 21127 | 248 | 1 |
726779 | 726779 | 2020-11-13 | Lee | Kentucky | 21129 | 341 | 10 |
726780 | 726780 | 2020-11-13 | Leslie | Kentucky | 21131 | 165 | 1 |
726781 | 726781 | 2020-11-13 | Letcher | Kentucky | 21133 | 392 | 2 |
726782 | 726782 | 2020-11-13 | Lewis | Kentucky | 21135 | 411 | 17 |
726783 | 726783 | 2020-11-13 | Lincoln | Kentucky | 21137 | 452 | 20 |
726784 | 726784 | 2020-11-13 | Livingston | Kentucky | 21139 | 192 | 2 |
726785 | 726785 | 2020-11-13 | Logan | Kentucky | 21141 | 984 | 33 |
726786 | 726786 | 2020-11-13 | Lyon | Kentucky | 21143 | 146 | 5 |
726787 | 726787 | 2020-11-13 | Madison | Kentucky | 21151 | 2821 | 14 |
726788 | 726788 | 2020-11-13 | Magoffin | Kentucky | 21153 | 299 | 1 |
726789 | 726789 | 2020-11-13 | Marion | Kentucky | 21155 | 706 | 12 |
726790 | 726790 | 2020-11-13 | Marshall | Kentucky | 21157 | 672 | 9 |
726791 | 726791 | 2020-11-13 | Martin | Kentucky | 21159 | 309 | 5 |
726792 | 726792 | 2020-11-13 | Mason | Kentucky | 21161 | 264 | 3 |
726793 | 726793 | 2020-11-13 | McCracken | Kentucky | 21145 | 1784 | 12 |
726794 | 726794 | 2020-11-13 | McCreary | Kentucky | 21147 | 342 | 1 |
726795 | 726795 | 2020-11-13 | McLean | Kentucky | 21149 | 301 | 8 |
726796 | 726796 | 2020-11-13 | Meade | Kentucky | 21163 | 615 | 4 |
726797 | 726797 | 2020-11-13 | Menifee | Kentucky | 21165 | 105 | 1 |
726798 | 726798 | 2020-11-13 | Mercer | Kentucky | 21167 | 486 | 6 |
726799 | 726799 | 2020-11-13 | Metcalfe | Kentucky | 21169 | 307 | 2 |
726800 | 726800 | 2020-11-13 | Monroe | Kentucky | 21171 | 568 | 5 |
726801 | 726801 | 2020-11-13 | Montgomery | Kentucky | 21173 | 706 | 8 |
726802 | 726802 | 2020-11-13 | Morgan | Kentucky | 21175 | 204 | 0 |
726803 | 726803 | 2020-11-13 | Muhlenberg | Kentucky | 21177 | 1140 | 20 |
726804 | 726804 | 2020-11-13 | Nelson | Kentucky | 21179 | 1596 | 4 |
726805 | 726805 | 2020-11-13 | Nicholas | Kentucky | 21181 | 137 | 3 |
726806 | 726806 | 2020-11-13 | Ohio | Kentucky | 21183 | 764 | 12 |
726807 | 726807 | 2020-11-13 | Oldham | Kentucky | 21185 | 1725 | 27 |
726808 | 726808 | 2020-11-13 | Owen | Kentucky | 21187 | 149 | 3 |
726809 | 726809 | 2020-11-13 | Owsley | Kentucky | 21189 | 115 | 1 |
726810 | 726810 | 2020-11-13 | Pendleton | Kentucky | 21191 | 215 | 1 |
726811 | 726811 | 2020-11-13 | Perry | Kentucky | 21193 | 738 | 9 |
726812 | 726812 | 2020-11-13 | Pike | Kentucky | 21195 | 1390 | 11 |
726813 | 726813 | 2020-11-13 | Powell | Kentucky | 21197 | 241 | 0 |
726814 | 726814 | 2020-11-13 | Pulaski | Kentucky | 21199 | 1418 | 13 |
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);