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-17 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 |
---|---|---|---|---|---|---|---|
739693 | 739693 | 2020-11-17 | Adair | Kentucky | 21001 | 807 | 29 |
739694 | 739694 | 2020-11-17 | Allen | Kentucky | 21003 | 631 | 14 |
739695 | 739695 | 2020-11-17 | Anderson | Kentucky | 21005 | 391 | 1 |
739696 | 739696 | 2020-11-17 | Ballard | Kentucky | 21007 | 116 | 1 |
739697 | 739697 | 2020-11-17 | Barren | Kentucky | 21009 | 1743 | 23 |
739698 | 739698 | 2020-11-17 | Bath | Kentucky | 21011 | 205 | 1 |
739699 | 739699 | 2020-11-17 | Bell | Kentucky | 21013 | 1086 | 18 |
739700 | 739700 | 2020-11-17 | Boone | Kentucky | 21015 | 3395 | 26 |
739701 | 739701 | 2020-11-17 | Bourbon | Kentucky | 21017 | 464 | 1 |
739702 | 739702 | 2020-11-17 | Boyd | Kentucky | 21019 | 1052 | 23 |
739703 | 739703 | 2020-11-17 | Boyle | Kentucky | 21021 | 704 | 0 |
739704 | 739704 | 2020-11-17 | Bracken | Kentucky | 21023 | 112 | 3 |
739705 | 739705 | 2020-11-17 | Breathitt | Kentucky | 21025 | 257 | 3 |
739706 | 739706 | 2020-11-17 | Breckinridge | Kentucky | 21027 | 377 | 3 |
739707 | 739707 | 2020-11-17 | Bullitt | Kentucky | 21029 | 2272 | 21 |
739708 | 739708 | 2020-11-17 | Butler | Kentucky | 21031 | 498 | 16 |
739709 | 739709 | 2020-11-17 | Caldwell | Kentucky | 21033 | 440 | 0 |
739710 | 739710 | 2020-11-17 | Calloway | Kentucky | 21035 | 1396 | 11 |
739711 | 739711 | 2020-11-17 | Campbell | Kentucky | 21037 | 2144 | 20 |
739712 | 739712 | 2020-11-17 | Carlisle | Kentucky | 21039 | 156 | 1 |
739713 | 739713 | 2020-11-17 | Carroll | Kentucky | 21041 | 273 | 6 |
739714 | 739714 | 2020-11-17 | Carter | Kentucky | 21043 | 538 | 4 |
739715 | 739715 | 2020-11-17 | Casey | Kentucky | 21045 | 495 | 18 |
739716 | 739716 | 2020-11-17 | Christian | Kentucky | 21047 | 2534 | 38 |
739717 | 739717 | 2020-11-17 | Clark | Kentucky | 21049 | 705 | 12 |
739718 | 739718 | 2020-11-17 | Clay | Kentucky | 21051 | 811 | 7 |
739719 | 739719 | 2020-11-17 | Clinton | Kentucky | 21053 | 405 | 9 |
739720 | 739720 | 2020-11-17 | Crittenden | Kentucky | 21055 | 208 | 1 |
739721 | 739721 | 2020-11-17 | Cumberland | Kentucky | 21057 | 246 | 0 |
739722 | 739722 | 2020-11-17 | Daviess | Kentucky | 21059 | 2787 | 39 |
739723 | 739723 | 2020-11-17 | Edmonson | Kentucky | 21061 | 313 | 12 |
739724 | 739724 | 2020-11-17 | Elliott | Kentucky | 21063 | 518 | 0 |
739725 | 739725 | 2020-11-17 | Estill | Kentucky | 21065 | 382 | 0 |
739726 | 739726 | 2020-11-17 | Fayette | Kentucky | 21067 | 14300 | 104 |
739727 | 739727 | 2020-11-17 | Fleming | Kentucky | 21069 | 250 | 0 |
739728 | 739728 | 2020-11-17 | Floyd | Kentucky | 21071 | 916 | 5 |
739729 | 739729 | 2020-11-17 | Franklin | Kentucky | 21073 | 1135 | 14 |
739730 | 739730 | 2020-11-17 | Fulton | Kentucky | 21075 | 262 | 3 |
739731 | 739731 | 2020-11-17 | Gallatin | Kentucky | 21077 | 172 | 8 |
739732 | 739732 | 2020-11-17 | Garrard | Kentucky | 21079 | 451 | 4 |
739733 | 739733 | 2020-11-17 | Grant | Kentucky | 21081 | 473 | 6 |
739734 | 739734 | 2020-11-17 | Graves | Kentucky | 21083 | 1383 | 33 |
739735 | 739735 | 2020-11-17 | Grayson | Kentucky | 21085 | 768 | 19 |
739736 | 739736 | 2020-11-17 | Green | Kentucky | 21087 | 503 | 10 |
739737 | 739737 | 2020-11-17 | Greenup | Kentucky | 21089 | 967 | 12 |
739738 | 739738 | 2020-11-17 | Hancock | Kentucky | 21091 | 248 | 8 |
739739 | 739739 | 2020-11-17 | Hardin | Kentucky | 21093 | 3342 | 31 |
739740 | 739740 | 2020-11-17 | Harlan | Kentucky | 21095 | 750 | 15 |
739741 | 739741 | 2020-11-17 | Harrison | Kentucky | 21097 | 359 | 1 |
739742 | 739742 | 2020-11-17 | Hart | Kentucky | 21099 | 655 | 3 |
739743 | 739743 | 2020-11-17 | Henderson | Kentucky | 21101 | 1735 | 37 |
739744 | 739744 | 2020-11-17 | Henry | Kentucky | 21103 | 413 | 3 |
739745 | 739745 | 2020-11-17 | Hickman | Kentucky | 21105 | 132 | 1 |
739746 | 739746 | 2020-11-17 | Hopkins | Kentucky | 21107 | 1516 | 45 |
739747 | 739747 | 2020-11-17 | Jackson | Kentucky | 21109 | 581 | 17 |
739748 | 739748 | 2020-11-17 | Jefferson | Kentucky | 21111 | 31534 | 449 |
739749 | 739749 | 2020-11-17 | Jessamine | Kentucky | 21113 | 1405 | 27 |
739750 | 739750 | 2020-11-17 | Johnson | Kentucky | 21115 | 612 | 2 |
739751 | 739751 | 2020-11-17 | Kenton | Kentucky | 21117 | 4155 | 52 |
739752 | 739752 | 2020-11-17 | Knott | Kentucky | 21119 | 470 | 9 |
739753 | 739753 | 2020-11-17 | Knox | Kentucky | 21121 | 1046 | 10 |
739754 | 739754 | 2020-11-17 | Larue | Kentucky | 21123 | 491 | 2 |
739755 | 739755 | 2020-11-17 | Laurel | Kentucky | 21125 | 2077 | 11 |
739756 | 739756 | 2020-11-17 | Lawrence | Kentucky | 21127 | 286 | 1 |
739757 | 739757 | 2020-11-17 | Lee | Kentucky | 21129 | 570 | 11 |
739758 | 739758 | 2020-11-17 | Leslie | Kentucky | 21131 | 172 | 1 |
739759 | 739759 | 2020-11-17 | Letcher | Kentucky | 21133 | 418 | 2 |
739760 | 739760 | 2020-11-17 | Lewis | Kentucky | 21135 | 422 | 18 |
739761 | 739761 | 2020-11-17 | Lincoln | Kentucky | 21137 | 494 | 20 |
739762 | 739762 | 2020-11-17 | Livingston | Kentucky | 21139 | 218 | 2 |
739763 | 739763 | 2020-11-17 | Logan | Kentucky | 21141 | 1035 | 33 |
739764 | 739764 | 2020-11-17 | Lyon | Kentucky | 21143 | 161 | 5 |
739765 | 739765 | 2020-11-17 | Madison | Kentucky | 21151 | 3087 | 16 |
739766 | 739766 | 2020-11-17 | Magoffin | Kentucky | 21153 | 332 | 1 |
739767 | 739767 | 2020-11-17 | Marion | Kentucky | 21155 | 763 | 12 |
739768 | 739768 | 2020-11-17 | Marshall | Kentucky | 21157 | 755 | 9 |
739769 | 739769 | 2020-11-17 | Martin | Kentucky | 21159 | 337 | 5 |
739770 | 739770 | 2020-11-17 | Mason | Kentucky | 21161 | 288 | 2 |
739771 | 739771 | 2020-11-17 | McCracken | Kentucky | 21145 | 1954 | 12 |
739772 | 739772 | 2020-11-17 | McCreary | Kentucky | 21147 | 363 | 1 |
739773 | 739773 | 2020-11-17 | McLean | Kentucky | 21149 | 322 | 11 |
739774 | 739774 | 2020-11-17 | Meade | Kentucky | 21163 | 643 | 4 |
739775 | 739775 | 2020-11-17 | Menifee | Kentucky | 21165 | 108 | 1 |
739776 | 739776 | 2020-11-17 | Mercer | Kentucky | 21167 | 532 | 6 |
739777 | 739777 | 2020-11-17 | Metcalfe | Kentucky | 21169 | 327 | 2 |
739778 | 739778 | 2020-11-17 | Monroe | Kentucky | 21171 | 610 | 6 |
739779 | 739779 | 2020-11-17 | Montgomery | Kentucky | 21173 | 732 | 8 |
739780 | 739780 | 2020-11-17 | Morgan | Kentucky | 21175 | 230 | 0 |
739781 | 739781 | 2020-11-17 | Muhlenberg | Kentucky | 21177 | 1216 | 20 |
739782 | 739782 | 2020-11-17 | Nelson | Kentucky | 21179 | 1722 | 5 |
739783 | 739783 | 2020-11-17 | Nicholas | Kentucky | 21181 | 146 | 3 |
739784 | 739784 | 2020-11-17 | Ohio | Kentucky | 21183 | 801 | 14 |
739785 | 739785 | 2020-11-17 | Oldham | Kentucky | 21185 | 1811 | 30 |
739786 | 739786 | 2020-11-17 | Owen | Kentucky | 21187 | 161 | 3 |
739787 | 739787 | 2020-11-17 | Owsley | Kentucky | 21189 | 144 | 1 |
739788 | 739788 | 2020-11-17 | Pendleton | Kentucky | 21191 | 235 | 1 |
739789 | 739789 | 2020-11-17 | Perry | Kentucky | 21193 | 790 | 10 |
739790 | 739790 | 2020-11-17 | Pike | Kentucky | 21195 | 1480 | 11 |
739791 | 739791 | 2020-11-17 | Powell | Kentucky | 21197 | 324 | 0 |
739792 | 739792 | 2020-11-17 | Pulaski | Kentucky | 21199 | 1548 | 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);