ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-08-16" 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 |
---|---|---|---|---|---|---|---|
1622693 | 1622693 | 2021-08-16 | Adair | Kentucky | 21001 | 2239 | 57 |
1622694 | 1622694 | 2021-08-16 | Allen | Kentucky | 21003 | 2416 | 47 |
1622695 | 1622695 | 2021-08-16 | Anderson | Kentucky | 21005 | 2065 | 25 |
1622696 | 1622696 | 2021-08-16 | Ballard | Kentucky | 21007 | 473 | 10 |
1622697 | 1622697 | 2021-08-16 | Barren | Kentucky | 21009 | 5211 | 108 |
1622698 | 1622698 | 2021-08-16 | Bath | Kentucky | 21011 | 1130 | 24 |
1622699 | 1622699 | 2021-08-16 | Bell | Kentucky | 21013 | 3591 | 58 |
1622700 | 1622700 | 2021-08-16 | Boone | Kentucky | 21015 | 15899 | 165 |
1622701 | 1622701 | 2021-08-16 | Bourbon | Kentucky | 21017 | 1989 | 20 |
1622702 | 1622702 | 2021-08-16 | Boyd | Kentucky | 21019 | 5736 | 77 |
1622703 | 1622703 | 2021-08-16 | Boyle | Kentucky | 21021 | 3849 | 80 |
1622704 | 1622704 | 2021-08-16 | Bracken | Kentucky | 21023 | 761 | 8 |
1622705 | 1622705 | 2021-08-16 | Breathitt | Kentucky | 21025 | 1171 | 11 |
1622706 | 1622706 | 2021-08-16 | Breckinridge | Kentucky | 21027 | 1583 | 18 |
1622707 | 1622707 | 2021-08-16 | Bullitt | Kentucky | 21029 | 8335 | 85 |
1622708 | 1622708 | 2021-08-16 | Butler | Kentucky | 21031 | 1604 | 28 |
1622709 | 1622709 | 2021-08-16 | Caldwell | Kentucky | 21033 | 1645 | 32 |
1622710 | 1622710 | 2021-08-16 | Calloway | Kentucky | 21035 | 4052 | 52 |
1622711 | 1622711 | 2021-08-16 | Campbell | Kentucky | 21037 | 9548 | 84 |
1622712 | 1622712 | 2021-08-16 | Carlisle | Kentucky | 21039 | 532 | 10 |
1622713 | 1622713 | 2021-08-16 | Carroll | Kentucky | 21041 | 1168 | 21 |
1622714 | 1622714 | 2021-08-16 | Carter | Kentucky | 21043 | 2883 | 38 |
1622715 | 1622715 | 2021-08-16 | Casey | Kentucky | 21045 | 1743 | 43 |
1622716 | 1622716 | 2021-08-16 | Christian | Kentucky | 21047 | 7629 | 108 |
1622717 | 1622717 | 2021-08-16 | Clark | Kentucky | 21049 | 3515 | 32 |
1622718 | 1622718 | 2021-08-16 | Clay | Kentucky | 21051 | 3500 | 46 |
1622719 | 1622719 | 2021-08-16 | Clinton | Kentucky | 21053 | 1533 | 32 |
1622720 | 1622720 | 2021-08-16 | Crittenden | Kentucky | 21055 | 784 | 26 |
1622721 | 1622721 | 2021-08-16 | Cumberland | Kentucky | 21057 | 741 | 14 |
1622722 | 1622722 | 2021-08-16 | Daviess | Kentucky | 21059 | 12560 | 202 |
1622723 | 1622723 | 2021-08-16 | Edmonson | Kentucky | 21061 | 1014 | 25 |
1622724 | 1622724 | 2021-08-16 | Elliott | Kentucky | 21063 | 1049 | 2 |
1622725 | 1622725 | 2021-08-16 | Estill | Kentucky | 21065 | 1319 | 12 |
1622726 | 1622726 | 2021-08-16 | Fayette | Kentucky | 21067 | 39684 | 323 |
1622727 | 1622727 | 2021-08-16 | Fleming | Kentucky | 21069 | 1424 | 26 |
1622728 | 1622728 | 2021-08-16 | Floyd | Kentucky | 21071 | 4347 | 75 |
1622729 | 1622729 | 2021-08-16 | Franklin | Kentucky | 21073 | 4770 | 61 |
1622730 | 1622730 | 2021-08-16 | Fulton | Kentucky | 21075 | 569 | 16 |
1622731 | 1622731 | 2021-08-16 | Gallatin | Kentucky | 21077 | 821 | 34 |
1622732 | 1622732 | 2021-08-16 | Garrard | Kentucky | 21079 | 1708 | 37 |
1622733 | 1622733 | 2021-08-16 | Grant | Kentucky | 21081 | 2892 | 25 |
1622734 | 1622734 | 2021-08-16 | Graves | Kentucky | 21083 | 5028 | 101 |
1622735 | 1622735 | 2021-08-16 | Grayson | Kentucky | 21085 | 2627 | 59 |
1622736 | 1622736 | 2021-08-16 | Green | Kentucky | 21087 | 1430 | 18 |
1622737 | 1622737 | 2021-08-16 | Greenup | Kentucky | 21089 | 4196 | 63 |
1622738 | 1622738 | 2021-08-16 | Hancock | Kentucky | 21091 | 1009 | 16 |
1622739 | 1622739 | 2021-08-16 | Hardin | Kentucky | 21093 | 11649 | 174 |
1622740 | 1622740 | 2021-08-16 | Harlan | Kentucky | 21095 | 3236 | 93 |
1622741 | 1622741 | 2021-08-16 | Harrison | Kentucky | 21097 | 2001 | 27 |
1622742 | 1622742 | 2021-08-16 | Hart | Kentucky | 21099 | 2428 | 54 |
1622743 | 1622743 | 2021-08-16 | Henderson | Kentucky | 21101 | 5788 | 82 |
1622744 | 1622744 | 2021-08-16 | Henry | Kentucky | 21103 | 1661 | 21 |
1622745 | 1622745 | 2021-08-16 | Hickman | Kentucky | 21105 | 417 | 16 |
1622746 | 1622746 | 2021-08-16 | Hopkins | Kentucky | 21107 | 5546 | 156 |
1622747 | 1622747 | 2021-08-16 | Jackson | Kentucky | 21109 | 1649 | 32 |
1622748 | 1622748 | 2021-08-16 | Jefferson | Kentucky | 21111 | 89907 | 1360 |
1622749 | 1622749 | 2021-08-16 | Jessamine | Kentucky | 21113 | 5327 | 75 |
1622750 | 1622750 | 2021-08-16 | Johnson | Kentucky | 21115 | 2432 | 38 |
1622751 | 1622751 | 2021-08-16 | Kenton | Kentucky | 21117 | 18447 | 220 |
1622752 | 1622752 | 2021-08-16 | Knott | Kentucky | 21119 | 1407 | 25 |
1622753 | 1622753 | 2021-08-16 | Knox | Kentucky | 21121 | 4389 | 47 |
1622754 | 1622754 | 2021-08-16 | Larue | Kentucky | 21123 | 1542 | 29 |
1622755 | 1622755 | 2021-08-16 | Laurel | Kentucky | 21125 | 9130 | 86 |
1622756 | 1622756 | 2021-08-16 | Lawrence | Kentucky | 21127 | 1660 | 29 |
1622757 | 1622757 | 2021-08-16 | Lee | Kentucky | 21129 | 1346 | 26 |
1622758 | 1622758 | 2021-08-16 | Leslie | Kentucky | 21131 | 1131 | 9 |
1622759 | 1622759 | 2021-08-16 | Letcher | Kentucky | 21133 | 2396 | 49 |
1622760 | 1622760 | 2021-08-16 | Lewis | Kentucky | 21135 | 1598 | 42 |
1622761 | 1622761 | 2021-08-16 | Lincoln | Kentucky | 21137 | 2786 | 62 |
1622762 | 1622762 | 2021-08-16 | Livingston | Kentucky | 21139 | 1001 | 26 |
1622763 | 1622763 | 2021-08-16 | Logan | Kentucky | 21141 | 3524 | 74 |
1622764 | 1622764 | 2021-08-16 | Lyon | Kentucky | 21143 | 1634 | 22 |
1622765 | 1622765 | 2021-08-16 | Madison | Kentucky | 21151 | 10595 | 113 |
1622766 | 1622766 | 2021-08-16 | Magoffin | Kentucky | 21153 | 1217 | 18 |
1622767 | 1622767 | 2021-08-16 | Marion | Kentucky | 21155 | 2650 | 39 |
1622768 | 1622768 | 2021-08-16 | Marshall | Kentucky | 21157 | 3478 | 65 |
1622769 | 1622769 | 2021-08-16 | Martin | Kentucky | 21159 | 1198 | 21 |
1622770 | 1622770 | 2021-08-16 | Mason | Kentucky | 21161 | 1907 | 41 |
1622771 | 1622771 | 2021-08-16 | McCracken | Kentucky | 21145 | 7670 | 138 |
1622772 | 1622772 | 2021-08-16 | McCreary | Kentucky | 21147 | 2237 | 34 |
1622773 | 1622773 | 2021-08-16 | McLean | Kentucky | 21149 | 1017 | 29 |
1622774 | 1622774 | 2021-08-16 | Meade | Kentucky | 21163 | 2357 | 27 |
1622775 | 1622775 | 2021-08-16 | Menifee | Kentucky | 21165 | 554 | 17 |
1622776 | 1622776 | 2021-08-16 | Mercer | Kentucky | 21167 | 2954 | 52 |
1622777 | 1622777 | 2021-08-16 | Metcalfe | Kentucky | 21169 | 1248 | 31 |
1622778 | 1622778 | 2021-08-16 | Monroe | Kentucky | 21171 | 1475 | 45 |
1622779 | 1622779 | 2021-08-16 | Montgomery | Kentucky | 21173 | 3296 | 32 |
1622780 | 1622780 | 2021-08-16 | Morgan | Kentucky | 21175 | 2430 | 5 |
1622781 | 1622781 | 2021-08-16 | Muhlenberg | Kentucky | 21177 | 3752 | 71 |
1622782 | 1622782 | 2021-08-16 | Nelson | Kentucky | 21179 | 5702 | 63 |
1622783 | 1622783 | 2021-08-16 | Nicholas | Kentucky | 21181 | 655 | 9 |
1622784 | 1622784 | 2021-08-16 | Ohio | Kentucky | 21183 | 2892 | 57 |
1622785 | 1622785 | 2021-08-16 | Oldham | Kentucky | 21185 | 8242 | 85 |
1622786 | 1622786 | 2021-08-16 | Owen | Kentucky | 21187 | 871 | 13 |
1622787 | 1622787 | 2021-08-16 | Owsley | Kentucky | 21189 | 552 | 16 |
1622788 | 1622788 | 2021-08-16 | Pendleton | Kentucky | 21191 | 1218 | 5 |
1622789 | 1622789 | 2021-08-16 | Perry | Kentucky | 21193 | 3276 | 68 |
1622790 | 1622790 | 2021-08-16 | Pike | Kentucky | 21195 | 6840 | 113 |
1622791 | 1622791 | 2021-08-16 | Powell | Kentucky | 21197 | 1478 | 13 |
1622792 | 1622792 | 2021-08-16 | Pulaski | Kentucky | 21199 | 7563 | 133 |
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);