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-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 |
---|---|---|---|---|---|---|---|
924683 | 924683 | 2021-01-13 | Adair | Kentucky | 21001 | 1411 | 47 |
924684 | 924684 | 2021-01-13 | Allen | Kentucky | 21003 | 1375 | 19 |
924685 | 924685 | 2021-01-13 | Anderson | Kentucky | 21005 | 1212 | 4 |
924686 | 924686 | 2021-01-13 | Ballard | Kentucky | 21007 | 271 | 3 |
924687 | 924687 | 2021-01-13 | Barren | Kentucky | 21009 | 2940 | 35 |
924688 | 924688 | 2021-01-13 | Bath | Kentucky | 21011 | 616 | 9 |
924689 | 924689 | 2021-01-13 | Bell | Kentucky | 21013 | 2135 | 30 |
924690 | 924690 | 2021-01-13 | Boone | Kentucky | 21015 | 9486 | 47 |
924691 | 924691 | 2021-01-13 | Bourbon | Kentucky | 21017 | 1175 | 4 |
924692 | 924692 | 2021-01-13 | Boyd | Kentucky | 21019 | 3743 | 31 |
924693 | 924693 | 2021-01-13 | Boyle | Kentucky | 21021 | 2772 | 14 |
924694 | 924694 | 2021-01-13 | Bracken | Kentucky | 21023 | 358 | 3 |
924695 | 924695 | 2021-01-13 | Breathitt | Kentucky | 21025 | 736 | 3 |
924696 | 924696 | 2021-01-13 | Breckinridge | Kentucky | 21027 | 818 | 5 |
924697 | 924697 | 2021-01-13 | Bullitt | Kentucky | 21029 | 4820 | 31 |
924698 | 924698 | 2021-01-13 | Butler | Kentucky | 21031 | 993 | 16 |
924699 | 924699 | 2021-01-13 | Caldwell | Kentucky | 21033 | 1014 | 17 |
924700 | 924700 | 2021-01-13 | Calloway | Kentucky | 21035 | 2723 | 29 |
924701 | 924701 | 2021-01-13 | Campbell | Kentucky | 21037 | 5646 | 38 |
924702 | 924702 | 2021-01-13 | Carlisle | Kentucky | 21039 | 372 | 1 |
924703 | 924703 | 2021-01-13 | Carroll | Kentucky | 21041 | 706 | 7 |
924704 | 924704 | 2021-01-13 | Carter | Kentucky | 21043 | 1575 | 16 |
924705 | 924705 | 2021-01-13 | Casey | Kentucky | 21045 | 984 | 29 |
924706 | 924706 | 2021-01-13 | Christian | Kentucky | 21047 | 5058 | 67 |
924707 | 924707 | 2021-01-13 | Clark | Kentucky | 21049 | 1785 | 16 |
924708 | 924708 | 2021-01-13 | Clay | Kentucky | 21051 | 1991 | 11 |
924709 | 924709 | 2021-01-13 | Clinton | Kentucky | 21053 | 1152 | 20 |
924710 | 924710 | 2021-01-13 | Crittenden | Kentucky | 21055 | 461 | 3 |
924711 | 924711 | 2021-01-13 | Cumberland | Kentucky | 21057 | 519 | 6 |
924712 | 924712 | 2021-01-13 | Daviess | Kentucky | 21059 | 7093 | 113 |
924713 | 924713 | 2021-01-13 | Edmonson | Kentucky | 21061 | 656 | 13 |
924714 | 924714 | 2021-01-13 | Elliott | Kentucky | 21063 | 859 | 1 |
924715 | 924715 | 2021-01-13 | Estill | Kentucky | 21065 | 759 | 0 |
924716 | 924716 | 2021-01-13 | Fayette | Kentucky | 21067 | 26282 | 168 |
924717 | 924717 | 2021-01-13 | Fleming | Kentucky | 21069 | 859 | 4 |
924718 | 924718 | 2021-01-13 | Floyd | Kentucky | 21071 | 2222 | 16 |
924719 | 924719 | 2021-01-13 | Franklin | Kentucky | 21073 | 2471 | 22 |
924720 | 924720 | 2021-01-13 | Fulton | Kentucky | 21075 | 387 | 4 |
924721 | 924721 | 2021-01-13 | Gallatin | Kentucky | 21077 | 494 | 11 |
924722 | 924722 | 2021-01-13 | Garrard | Kentucky | 21079 | 1105 | 4 |
924723 | 924723 | 2021-01-13 | Grant | Kentucky | 21081 | 1519 | 10 |
924724 | 924724 | 2021-01-13 | Graves | Kentucky | 21083 | 3201 | 53 |
924725 | 924725 | 2021-01-13 | Grayson | Kentucky | 21085 | 1500 | 37 |
924726 | 924726 | 2021-01-13 | Green | Kentucky | 21087 | 890 | 12 |
924727 | 924727 | 2021-01-13 | Greenup | Kentucky | 21089 | 2712 | 21 |
924728 | 924728 | 2021-01-13 | Hancock | Kentucky | 21091 | 591 | 13 |
924729 | 924729 | 2021-01-13 | Hardin | Kentucky | 21093 | 6954 | 47 |
924730 | 924730 | 2021-01-13 | Harlan | Kentucky | 21095 | 1891 | 26 |
924731 | 924731 | 2021-01-13 | Harrison | Kentucky | 21097 | 1094 | 2 |
924732 | 924732 | 2021-01-13 | Hart | Kentucky | 21099 | 1384 | 11 |
924733 | 924733 | 2021-01-13 | Henderson | Kentucky | 21101 | 3497 | 52 |
924734 | 924734 | 2021-01-13 | Henry | Kentucky | 21103 | 934 | 4 |
924735 | 924735 | 2021-01-13 | Hickman | Kentucky | 21105 | 244 | 7 |
924736 | 924736 | 2021-01-13 | Hopkins | Kentucky | 21107 | 3161 | 113 |
924737 | 924737 | 2021-01-13 | Jackson | Kentucky | 21109 | 1012 | 22 |
924738 | 924738 | 2021-01-13 | Jefferson | Kentucky | 21111 | 59234 | 729 |
924739 | 924739 | 2021-01-13 | Jessamine | Kentucky | 21113 | 3054 | 48 |
924740 | 924740 | 2021-01-13 | Johnson | Kentucky | 21115 | 1368 | 16 |
924741 | 924741 | 2021-01-13 | Kenton | Kentucky | 21117 | 11047 | 90 |
924742 | 924742 | 2021-01-13 | Knott | Kentucky | 21119 | 818 | 14 |
924743 | 924743 | 2021-01-13 | Knox | Kentucky | 21121 | 2174 | 10 |
924744 | 924744 | 2021-01-13 | Larue | Kentucky | 21123 | 928 | 6 |
924745 | 924745 | 2021-01-13 | Laurel | Kentucky | 21125 | 4379 | 17 |
924746 | 924746 | 2021-01-13 | Lawrence | Kentucky | 21127 | 964 | 5 |
924747 | 924747 | 2021-01-13 | Lee | Kentucky | 21129 | 1087 | 18 |
924748 | 924748 | 2021-01-13 | Leslie | Kentucky | 21131 | 602 | 2 |
924749 | 924749 | 2021-01-13 | Letcher | Kentucky | 21133 | 1299 | 5 |
924750 | 924750 | 2021-01-13 | Lewis | Kentucky | 21135 | 910 | 28 |
924751 | 924751 | 2021-01-13 | Lincoln | Kentucky | 21137 | 1679 | 27 |
924752 | 924752 | 2021-01-13 | Livingston | Kentucky | 21139 | 562 | 13 |
924753 | 924753 | 2021-01-13 | Logan | Kentucky | 21141 | 1933 | 40 |
924754 | 924754 | 2021-01-13 | Lyon | Kentucky | 21143 | 368 | 7 |
924755 | 924755 | 2021-01-13 | Madison | Kentucky | 21151 | 6594 | 43 |
924756 | 924756 | 2021-01-13 | Magoffin | Kentucky | 21153 | 755 | 1 |
924757 | 924757 | 2021-01-13 | Marion | Kentucky | 21155 | 1706 | 20 |
924758 | 924758 | 2021-01-13 | Marshall | Kentucky | 21157 | 1869 | 25 |
924759 | 924759 | 2021-01-13 | Martin | Kentucky | 21159 | 752 | 10 |
924760 | 924760 | 2021-01-13 | Mason | Kentucky | 21161 | 1055 | 22 |
924761 | 924761 | 2021-01-13 | McCracken | Kentucky | 21145 | 4746 | 47 |
924762 | 924762 | 2021-01-13 | McCreary | Kentucky | 21147 | 1322 | 15 |
924763 | 924763 | 2021-01-13 | McLean | Kentucky | 21149 | 654 | 22 |
924764 | 924764 | 2021-01-13 | Meade | Kentucky | 21163 | 1355 | 5 |
924765 | 924765 | 2021-01-13 | Menifee | Kentucky | 21165 | 267 | 2 |
924766 | 924766 | 2021-01-13 | Mercer | Kentucky | 21167 | 1795 | 8 |
924767 | 924767 | 2021-01-13 | Metcalfe | Kentucky | 21169 | 689 | 10 |
924768 | 924768 | 2021-01-13 | Monroe | Kentucky | 21171 | 1067 | 28 |
924769 | 924769 | 2021-01-13 | Montgomery | Kentucky | 21173 | 1691 | 12 |
924770 | 924770 | 2021-01-13 | Morgan | Kentucky | 21175 | 1487 | 0 |
924771 | 924771 | 2021-01-13 | Muhlenberg | Kentucky | 21177 | 2314 | 41 |
924772 | 924772 | 2021-01-13 | Nelson | Kentucky | 21179 | 3453 | 22 |
924773 | 924773 | 2021-01-13 | Nicholas | Kentucky | 21181 | 367 | 4 |
924774 | 924774 | 2021-01-13 | Ohio | Kentucky | 21183 | 1824 | 34 |
924775 | 924775 | 2021-01-13 | Oldham | Kentucky | 21185 | 4996 | 47 |
924776 | 924776 | 2021-01-13 | Owen | Kentucky | 21187 | 482 | 6 |
924777 | 924777 | 2021-01-13 | Owsley | Kentucky | 21189 | 348 | 10 |
924778 | 924778 | 2021-01-13 | Pendleton | Kentucky | 21191 | 705 | 1 |
924779 | 924779 | 2021-01-13 | Perry | Kentucky | 21193 | 1798 | 17 |
924780 | 924780 | 2021-01-13 | Pike | Kentucky | 21195 | 3660 | 38 |
924781 | 924781 | 2021-01-13 | Powell | Kentucky | 21197 | 774 | 0 |
924782 | 924782 | 2021-01-13 | Pulaski | Kentucky | 21199 | 4557 | 65 |
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);