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-08-21 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 |
---|---|---|---|---|---|---|---|
454595 | 454595 | 2020-08-21 | Adair | Kentucky | 21001 | 253 | 19 |
454596 | 454596 | 2020-08-21 | Allen | Kentucky | 21003 | 239 | 8 |
454597 | 454597 | 2020-08-21 | Anderson | Kentucky | 21005 | 101 | 1 |
454598 | 454598 | 2020-08-21 | Ballard | Kentucky | 21007 | 38 | 0 |
454599 | 454599 | 2020-08-21 | Barren | Kentucky | 21009 | 464 | 6 |
454600 | 454600 | 2020-08-21 | Bath | Kentucky | 21011 | 51 | 1 |
454601 | 454601 | 2020-08-21 | Bell | Kentucky | 21013 | 364 | 5 |
454602 | 454602 | 2020-08-21 | Boone | Kentucky | 21015 | 1206 | 25 |
454603 | 454603 | 2020-08-21 | Bourbon | Kentucky | 21017 | 110 | 1 |
454604 | 454604 | 2020-08-21 | Boyd | Kentucky | 21019 | 211 | 4 |
454605 | 454605 | 2020-08-21 | Boyle | Kentucky | 21021 | 183 | 0 |
454606 | 454606 | 2020-08-21 | Bracken | Kentucky | 21023 | 37 | 0 |
454607 | 454607 | 2020-08-21 | Breathitt | Kentucky | 21025 | 38 | 0 |
454608 | 454608 | 2020-08-21 | Breckinridge | Kentucky | 21027 | 91 | 2 |
454609 | 454609 | 2020-08-21 | Bullitt | Kentucky | 21029 | 526 | 5 |
454610 | 454610 | 2020-08-21 | Butler | Kentucky | 21031 | 314 | 16 |
454611 | 454611 | 2020-08-21 | Caldwell | Kentucky | 21033 | 62 | 0 |
454612 | 454612 | 2020-08-21 | Calloway | Kentucky | 21035 | 326 | 5 |
454613 | 454613 | 2020-08-21 | Campbell | Kentucky | 21037 | 646 | 13 |
454614 | 454614 | 2020-08-21 | Carlisle | Kentucky | 21039 | 55 | 1 |
454615 | 454615 | 2020-08-21 | Carroll | Kentucky | 21041 | 175 | 2 |
454616 | 454616 | 2020-08-21 | Carter | Kentucky | 21043 | 109 | 3 |
454617 | 454617 | 2020-08-21 | Casey | Kentucky | 21045 | 227 | 13 |
454618 | 454618 | 2020-08-21 | Christian | Kentucky | 21047 | 796 | 11 |
454619 | 454619 | 2020-08-21 | Clark | Kentucky | 21049 | 220 | 8 |
454620 | 454620 | 2020-08-21 | Clay | Kentucky | 21051 | 195 | 6 |
454621 | 454621 | 2020-08-21 | Clinton | Kentucky | 21053 | 61 | 1 |
454622 | 454622 | 2020-08-21 | Crittenden | Kentucky | 21055 | 38 | 1 |
454623 | 454623 | 2020-08-21 | Cumberland | Kentucky | 21057 | 76 | 0 |
454624 | 454624 | 2020-08-21 | Daviess | Kentucky | 21059 | 896 | 10 |
454625 | 454625 | 2020-08-21 | Edmonson | Kentucky | 21061 | 127 | 12 |
454626 | 454626 | 2020-08-21 | Elliott | Kentucky | 21063 | 19 | 0 |
454627 | 454627 | 2020-08-21 | Estill | Kentucky | 21065 | 28 | 0 |
454628 | 454628 | 2020-08-21 | Fayette | Kentucky | 21067 | 4849 | 53 |
454629 | 454629 | 2020-08-21 | Fleming | Kentucky | 21069 | 64 | 0 |
454630 | 454630 | 2020-08-21 | Floyd | Kentucky | 21071 | 129 | 2 |
454631 | 454631 | 2020-08-21 | Franklin | Kentucky | 21073 | 416 | 11 |
454632 | 454632 | 2020-08-21 | Fulton | Kentucky | 21075 | 109 | 2 |
454633 | 454633 | 2020-08-21 | Gallatin | Kentucky | 21077 | 85 | 8 |
454634 | 454634 | 2020-08-21 | Garrard | Kentucky | 21079 | 99 | 1 |
454635 | 454635 | 2020-08-21 | Grant | Kentucky | 21081 | 133 | 6 |
454636 | 454636 | 2020-08-21 | Graves | Kentucky | 21083 | 606 | 28 |
454637 | 454637 | 2020-08-21 | Grayson | Kentucky | 21085 | 233 | 11 |
454638 | 454638 | 2020-08-21 | Green | Kentucky | 21087 | 100 | 3 |
454639 | 454639 | 2020-08-21 | Greenup | Kentucky | 21089 | 160 | 1 |
454640 | 454640 | 2020-08-21 | Hancock | Kentucky | 21091 | 55 | 0 |
454641 | 454641 | 2020-08-21 | Hardin | Kentucky | 21093 | 819 | 8 |
454642 | 454642 | 2020-08-21 | Harlan | Kentucky | 21095 | 265 | 5 |
454643 | 454643 | 2020-08-21 | Harrison | Kentucky | 21097 | 138 | 0 |
454644 | 454644 | 2020-08-21 | Hart | Kentucky | 21099 | 129 | 1 |
454645 | 454645 | 2020-08-21 | Henderson | Kentucky | 21101 | 401 | 4 |
454646 | 454646 | 2020-08-21 | Henry | Kentucky | 21103 | 152 | 2 |
454647 | 454647 | 2020-08-21 | Hickman | Kentucky | 21105 | 63 | 0 |
454648 | 454648 | 2020-08-21 | Hopkins | Kentucky | 21107 | 469 | 37 |
454649 | 454649 | 2020-08-21 | Jackson | Kentucky | 21109 | 167 | 15 |
454650 | 454650 | 2020-08-21 | Jefferson | Kentucky | 21111 | 10775 | 272 |
454651 | 454651 | 2020-08-21 | Jessamine | Kentucky | 21113 | 404 | 0 |
454652 | 454652 | 2020-08-21 | Johnson | Kentucky | 21115 | 100 | 0 |
454653 | 454653 | 2020-08-21 | Kenton | Kentucky | 21117 | 1603 | 41 |
454654 | 454654 | 2020-08-21 | Knott | Kentucky | 21119 | 83 | 1 |
454655 | 454655 | 2020-08-21 | Knox | Kentucky | 21121 | 305 | 8 |
454656 | 454656 | 2020-08-21 | Larue | Kentucky | 21123 | 91 | 1 |
454657 | 454657 | 2020-08-21 | Laurel | Kentucky | 21125 | 508 | 5 |
454658 | 454658 | 2020-08-21 | Lawrence | Kentucky | 21127 | 39 | 0 |
454659 | 454659 | 2020-08-21 | Lee | Kentucky | 21129 | 8 | 0 |
454660 | 454660 | 2020-08-21 | Leslie | Kentucky | 21131 | 37 | 0 |
454661 | 454661 | 2020-08-21 | Letcher | Kentucky | 21133 | 66 | 2 |
454662 | 454662 | 2020-08-21 | Lewis | Kentucky | 21135 | 97 | 2 |
454663 | 454663 | 2020-08-21 | Lincoln | Kentucky | 21137 | 130 | 2 |
454664 | 454664 | 2020-08-21 | Livingston | Kentucky | 21139 | 38 | 1 |
454665 | 454665 | 2020-08-21 | Logan | Kentucky | 21141 | 385 | 26 |
454666 | 454666 | 2020-08-21 | Lyon | Kentucky | 21143 | 34 | 4 |
454667 | 454667 | 2020-08-21 | Madison | Kentucky | 21151 | 716 | 2 |
454668 | 454668 | 2020-08-21 | Magoffin | Kentucky | 21153 | 60 | 0 |
454669 | 454669 | 2020-08-21 | Marion | Kentucky | 21155 | 164 | 1 |
454670 | 454670 | 2020-08-21 | Marshall | Kentucky | 21157 | 173 | 2 |
454671 | 454671 | 2020-08-21 | Martin | Kentucky | 21159 | 46 | 0 |
454672 | 454672 | 2020-08-21 | Mason | Kentucky | 21161 | 69 | 2 |
454673 | 454673 | 2020-08-21 | McCracken | Kentucky | 21145 | 445 | 5 |
454674 | 454674 | 2020-08-21 | McCreary | Kentucky | 21147 | 57 | 0 |
454675 | 454675 | 2020-08-21 | McLean | Kentucky | 21149 | 52 | 0 |
454676 | 454676 | 2020-08-21 | Meade | Kentucky | 21163 | 136 | 3 |
454677 | 454677 | 2020-08-21 | Menifee | Kentucky | 21165 | 28 | 0 |
454678 | 454678 | 2020-08-21 | Mercer | Kentucky | 21167 | 105 | 1 |
454679 | 454679 | 2020-08-21 | Metcalfe | Kentucky | 21169 | 81 | 2 |
454680 | 454680 | 2020-08-21 | Monroe | Kentucky | 21171 | 110 | 2 |
454681 | 454681 | 2020-08-21 | Montgomery | Kentucky | 21173 | 170 | 1 |
454682 | 454682 | 2020-08-21 | Morgan | Kentucky | 21175 | 40 | 0 |
454683 | 454683 | 2020-08-21 | Muhlenberg | Kentucky | 21177 | 667 | 11 |
454684 | 454684 | 2020-08-21 | Nelson | Kentucky | 21179 | 307 | 2 |
454685 | 454685 | 2020-08-21 | Nicholas | Kentucky | 21181 | 21 | 1 |
454686 | 454686 | 2020-08-21 | Ohio | Kentucky | 21183 | 391 | 9 |
454687 | 454687 | 2020-08-21 | Oldham | Kentucky | 21185 | 733 | 20 |
454688 | 454688 | 2020-08-21 | Owen | Kentucky | 21187 | 71 | 0 |
454689 | 454689 | 2020-08-21 | Owsley | Kentucky | 21189 | 25 | 0 |
454690 | 454690 | 2020-08-21 | Pendleton | Kentucky | 21191 | 55 | 0 |
454691 | 454691 | 2020-08-21 | Perry | Kentucky | 21193 | 263 | 6 |
454692 | 454692 | 2020-08-21 | Pike | Kentucky | 21195 | 288 | 3 |
454693 | 454693 | 2020-08-21 | Powell | Kentucky | 21197 | 70 | 0 |
454694 | 454694 | 2020-08-21 | Pulaski | Kentucky | 21199 | 439 | 6 |
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);