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-05 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 |
---|---|---|---|---|---|---|---|
898722 | 898722 | 2021-01-05 | Adair | Kentucky | 21001 | 1362 | 45 |
898723 | 898723 | 2021-01-05 | Allen | Kentucky | 21003 | 1247 | 18 |
898724 | 898724 | 2021-01-05 | Anderson | Kentucky | 21005 | 1062 | 3 |
898725 | 898725 | 2021-01-05 | Ballard | Kentucky | 21007 | 247 | 2 |
898726 | 898726 | 2021-01-05 | Barren | Kentucky | 21009 | 2651 | 35 |
898727 | 898727 | 2021-01-05 | Bath | Kentucky | 21011 | 515 | 8 |
898728 | 898728 | 2021-01-05 | Bell | Kentucky | 21013 | 1916 | 27 |
898729 | 898729 | 2021-01-05 | Boone | Kentucky | 21015 | 8397 | 45 |
898730 | 898730 | 2021-01-05 | Bourbon | Kentucky | 21017 | 1078 | 2 |
898731 | 898731 | 2021-01-05 | Boyd | Kentucky | 21019 | 3305 | 31 |
898732 | 898732 | 2021-01-05 | Boyle | Kentucky | 21021 | 2448 | 5 |
898733 | 898733 | 2021-01-05 | Bracken | Kentucky | 21023 | 293 | 3 |
898734 | 898734 | 2021-01-05 | Breathitt | Kentucky | 21025 | 657 | 3 |
898735 | 898735 | 2021-01-05 | Breckinridge | Kentucky | 21027 | 685 | 5 |
898736 | 898736 | 2021-01-05 | Bullitt | Kentucky | 21029 | 4376 | 31 |
898737 | 898737 | 2021-01-05 | Butler | Kentucky | 21031 | 860 | 16 |
898738 | 898738 | 2021-01-05 | Caldwell | Kentucky | 21033 | 915 | 16 |
898739 | 898739 | 2021-01-05 | Calloway | Kentucky | 21035 | 2465 | 25 |
898740 | 898740 | 2021-01-05 | Campbell | Kentucky | 21037 | 4991 | 35 |
898741 | 898741 | 2021-01-05 | Carlisle | Kentucky | 21039 | 344 | 1 |
898742 | 898742 | 2021-01-05 | Carroll | Kentucky | 21041 | 562 | 7 |
898743 | 898743 | 2021-01-05 | Carter | Kentucky | 21043 | 1457 | 6 |
898744 | 898744 | 2021-01-05 | Casey | Kentucky | 21045 | 907 | 28 |
898745 | 898745 | 2021-01-05 | Christian | Kentucky | 21047 | 4600 | 63 |
898746 | 898746 | 2021-01-05 | Clark | Kentucky | 21049 | 1505 | 15 |
898747 | 898747 | 2021-01-05 | Clay | Kentucky | 21051 | 1723 | 8 |
898748 | 898748 | 2021-01-05 | Clinton | Kentucky | 21053 | 998 | 20 |
898749 | 898749 | 2021-01-05 | Crittenden | Kentucky | 21055 | 409 | 3 |
898750 | 898750 | 2021-01-05 | Cumberland | Kentucky | 21057 | 463 | 6 |
898751 | 898751 | 2021-01-05 | Daviess | Kentucky | 21059 | 6171 | 99 |
898752 | 898752 | 2021-01-05 | Edmonson | Kentucky | 21061 | 593 | 13 |
898753 | 898753 | 2021-01-05 | Elliott | Kentucky | 21063 | 832 | 1 |
898754 | 898754 | 2021-01-05 | Estill | Kentucky | 21065 | 700 | 0 |
898755 | 898755 | 2021-01-05 | Fayette | Kentucky | 21067 | 24285 | 163 |
898756 | 898756 | 2021-01-05 | Fleming | Kentucky | 21069 | 778 | 2 |
898757 | 898757 | 2021-01-05 | Floyd | Kentucky | 21071 | 1966 | 16 |
898758 | 898758 | 2021-01-05 | Franklin | Kentucky | 21073 | 2226 | 21 |
898759 | 898759 | 2021-01-05 | Fulton | Kentucky | 21075 | 376 | 4 |
898760 | 898760 | 2021-01-05 | Gallatin | Kentucky | 21077 | 442 | 11 |
898761 | 898761 | 2021-01-05 | Garrard | Kentucky | 21079 | 992 | 4 |
898762 | 898762 | 2021-01-05 | Grant | Kentucky | 21081 | 1376 | 10 |
898763 | 898763 | 2021-01-05 | Graves | Kentucky | 21083 | 2845 | 51 |
898764 | 898764 | 2021-01-05 | Grayson | Kentucky | 21085 | 1351 | 32 |
898765 | 898765 | 2021-01-05 | Green | Kentucky | 21087 | 834 | 12 |
898766 | 898766 | 2021-01-05 | Greenup | Kentucky | 21089 | 2474 | 19 |
898767 | 898767 | 2021-01-05 | Hancock | Kentucky | 21091 | 501 | 12 |
898768 | 898768 | 2021-01-05 | Hardin | Kentucky | 21093 | 6249 | 42 |
898769 | 898769 | 2021-01-05 | Harlan | Kentucky | 21095 | 1692 | 25 |
898770 | 898770 | 2021-01-05 | Harrison | Kentucky | 21097 | 849 | 1 |
898771 | 898771 | 2021-01-05 | Hart | Kentucky | 21099 | 1264 | 9 |
898772 | 898772 | 2021-01-05 | Henderson | Kentucky | 21101 | 3096 | 50 |
898773 | 898773 | 2021-01-05 | Henry | Kentucky | 21103 | 854 | 4 |
898774 | 898774 | 2021-01-05 | Hickman | Kentucky | 21105 | 226 | 6 |
898775 | 898775 | 2021-01-05 | Hopkins | Kentucky | 21107 | 2906 | 106 |
898776 | 898776 | 2021-01-05 | Jackson | Kentucky | 21109 | 896 | 21 |
898777 | 898777 | 2021-01-05 | Jefferson | Kentucky | 21111 | 54541 | 679 |
898778 | 898778 | 2021-01-05 | Jessamine | Kentucky | 21113 | 2743 | 47 |
898779 | 898779 | 2021-01-05 | Johnson | Kentucky | 21115 | 1192 | 16 |
898780 | 898780 | 2021-01-05 | Kenton | Kentucky | 21117 | 9697 | 81 |
898781 | 898781 | 2021-01-05 | Knott | Kentucky | 21119 | 770 | 14 |
898782 | 898782 | 2021-01-05 | Knox | Kentucky | 21121 | 1900 | 10 |
898783 | 898783 | 2021-01-05 | Larue | Kentucky | 21123 | 848 | 4 |
898784 | 898784 | 2021-01-05 | Laurel | Kentucky | 21125 | 3835 | 17 |
898785 | 898785 | 2021-01-05 | Lawrence | Kentucky | 21127 | 876 | 5 |
898786 | 898786 | 2021-01-05 | Lee | Kentucky | 21129 | 1055 | 18 |
898787 | 898787 | 2021-01-05 | Leslie | Kentucky | 21131 | 513 | 1 |
898788 | 898788 | 2021-01-05 | Letcher | Kentucky | 21133 | 1148 | 4 |
898789 | 898789 | 2021-01-05 | Lewis | Kentucky | 21135 | 811 | 25 |
898790 | 898790 | 2021-01-05 | Lincoln | Kentucky | 21137 | 1513 | 25 |
898791 | 898791 | 2021-01-05 | Livingston | Kentucky | 21139 | 511 | 11 |
898792 | 898792 | 2021-01-05 | Logan | Kentucky | 21141 | 1810 | 40 |
898793 | 898793 | 2021-01-05 | Lyon | Kentucky | 21143 | 341 | 7 |
898794 | 898794 | 2021-01-05 | Madison | Kentucky | 21151 | 5927 | 39 |
898795 | 898795 | 2021-01-05 | Magoffin | Kentucky | 21153 | 714 | 1 |
898796 | 898796 | 2021-01-05 | Marion | Kentucky | 21155 | 1561 | 20 |
898797 | 898797 | 2021-01-05 | Marshall | Kentucky | 21157 | 1664 | 22 |
898798 | 898798 | 2021-01-05 | Martin | Kentucky | 21159 | 683 | 10 |
898799 | 898799 | 2021-01-05 | Mason | Kentucky | 21161 | 972 | 19 |
898800 | 898800 | 2021-01-05 | McCracken | Kentucky | 21145 | 4417 | 41 |
898801 | 898801 | 2021-01-05 | McCreary | Kentucky | 21147 | 1217 | 11 |
898802 | 898802 | 2021-01-05 | McLean | Kentucky | 21149 | 578 | 21 |
898803 | 898803 | 2021-01-05 | Meade | Kentucky | 21163 | 1192 | 4 |
898804 | 898804 | 2021-01-05 | Menifee | Kentucky | 21165 | 238 | 2 |
898805 | 898805 | 2021-01-05 | Mercer | Kentucky | 21167 | 1482 | 6 |
898806 | 898806 | 2021-01-05 | Metcalfe | Kentucky | 21169 | 627 | 10 |
898807 | 898807 | 2021-01-05 | Monroe | Kentucky | 21171 | 991 | 26 |
898808 | 898808 | 2021-01-05 | Montgomery | Kentucky | 21173 | 1472 | 12 |
898809 | 898809 | 2021-01-05 | Morgan | Kentucky | 21175 | 565 | 0 |
898810 | 898810 | 2021-01-05 | Muhlenberg | Kentucky | 21177 | 2132 | 40 |
898811 | 898811 | 2021-01-05 | Nelson | Kentucky | 21179 | 3015 | 17 |
898812 | 898812 | 2021-01-05 | Nicholas | Kentucky | 21181 | 304 | 3 |
898813 | 898813 | 2021-01-05 | Ohio | Kentucky | 21183 | 1594 | 30 |
898814 | 898814 | 2021-01-05 | Oldham | Kentucky | 21185 | 4139 | 48 |
898815 | 898815 | 2021-01-05 | Owen | Kentucky | 21187 | 436 | 6 |
898816 | 898816 | 2021-01-05 | Owsley | Kentucky | 21189 | 321 | 10 |
898817 | 898817 | 2021-01-05 | Pendleton | Kentucky | 21191 | 628 | 1 |
898818 | 898818 | 2021-01-05 | Perry | Kentucky | 21193 | 1641 | 17 |
898819 | 898819 | 2021-01-05 | Pike | Kentucky | 21195 | 3189 | 33 |
898820 | 898820 | 2021-01-05 | Powell | Kentucky | 21197 | 722 | 0 |
898821 | 898821 | 2021-01-05 | Pulaski | Kentucky | 21199 | 4037 | 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);