ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where "date" is on date 2020-06-27 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 |
---|---|---|---|---|---|---|---|
278614 | 278614 | 2020-06-27 | Adair | Kentucky | 21001 | 115 | 19 |
278615 | 278615 | 2020-06-27 | Allen | Kentucky | 21003 | 165 | 6 |
278616 | 278616 | 2020-06-27 | Anderson | Kentucky | 21005 | 26 | 1 |
278617 | 278617 | 2020-06-27 | Ballard | Kentucky | 21007 | 15 | 0 |
278618 | 278618 | 2020-06-27 | Barren | Kentucky | 21009 | 84 | 2 |
278619 | 278619 | 2020-06-27 | Bath | Kentucky | 21011 | 13 | 1 |
278620 | 278620 | 2020-06-27 | Bell | Kentucky | 21013 | 8 | 0 |
278621 | 278621 | 2020-06-27 | Boone | Kentucky | 21015 | 594 | 23 |
278622 | 278622 | 2020-06-27 | Bourbon | Kentucky | 21017 | 30 | 1 |
278623 | 278623 | 2020-06-27 | Boyd | Kentucky | 21019 | 60 | 3 |
278624 | 278624 | 2020-06-27 | Boyle | Kentucky | 21021 | 38 | 0 |
278625 | 278625 | 2020-06-27 | Bracken | Kentucky | 21023 | 17 | 0 |
278626 | 278626 | 2020-06-27 | Breathitt | Kentucky | 21025 | 8 | 0 |
278627 | 278627 | 2020-06-27 | Breckinridge | Kentucky | 21027 | 24 | 2 |
278628 | 278628 | 2020-06-27 | Bullitt | Kentucky | 21029 | 148 | 4 |
278629 | 278629 | 2020-06-27 | Butler | Kentucky | 21031 | 252 | 14 |
278630 | 278630 | 2020-06-27 | Caldwell | Kentucky | 21033 | 13 | 0 |
278631 | 278631 | 2020-06-27 | Calloway | Kentucky | 21035 | 79 | 1 |
278632 | 278632 | 2020-06-27 | Campbell | Kentucky | 21037 | 246 | 12 |
278633 | 278633 | 2020-06-27 | Carlisle | Kentucky | 21039 | 5 | 1 |
278634 | 278634 | 2020-06-27 | Carroll | Kentucky | 21041 | 37 | 0 |
278635 | 278635 | 2020-06-27 | Carter | Kentucky | 21043 | 22 | 0 |
278636 | 278636 | 2020-06-27 | Casey | Kentucky | 21045 | 15 | 0 |
278637 | 278637 | 2020-06-27 | Christian | Kentucky | 21047 | 226 | 4 |
278638 | 278638 | 2020-06-27 | Clark | Kentucky | 21049 | 98 | 5 |
278639 | 278639 | 2020-06-27 | Clay | Kentucky | 21051 | 53 | 3 |
278640 | 278640 | 2020-06-27 | Clinton | Kentucky | 21053 | 5 | 0 |
278641 | 278641 | 2020-06-27 | Crittenden | Kentucky | 21055 | 8 | 1 |
278642 | 278642 | 2020-06-27 | Cumberland | Kentucky | 21057 | 6 | 0 |
278643 | 278643 | 2020-06-27 | Daviess | Kentucky | 21059 | 428 | 8 |
278644 | 278644 | 2020-06-27 | Edmonson | Kentucky | 21061 | 79 | 11 |
278645 | 278645 | 2020-06-27 | Elliott | Kentucky | 21063 | 3 | 0 |
278646 | 278646 | 2020-06-27 | Estill | Kentucky | 21065 | 4 | 0 |
278647 | 278647 | 2020-06-27 | Fayette | Kentucky | 21067 | 1439 | 24 |
278648 | 278648 | 2020-06-27 | Fleming | Kentucky | 21069 | 17 | 0 |
278649 | 278649 | 2020-06-27 | Floyd | Kentucky | 21071 | 27 | 0 |
278650 | 278650 | 2020-06-27 | Franklin | Kentucky | 21073 | 128 | 3 |
278651 | 278651 | 2020-06-27 | Fulton | Kentucky | 21075 | 21 | 0 |
278652 | 278652 | 2020-06-27 | Gallatin | Kentucky | 21077 | 61 | 7 |
278653 | 278653 | 2020-06-27 | Garrard | Kentucky | 21079 | 19 | 0 |
278654 | 278654 | 2020-06-27 | Grant | Kentucky | 21081 | 57 | 4 |
278655 | 278655 | 2020-06-27 | Graves | Kentucky | 21083 | 196 | 21 |
278656 | 278656 | 2020-06-27 | Grayson | Kentucky | 21085 | 137 | 10 |
278657 | 278657 | 2020-06-27 | Green | Kentucky | 21087 | 4 | 1 |
278658 | 278658 | 2020-06-27 | Greenup | Kentucky | 21089 | 28 | 0 |
278659 | 278659 | 2020-06-27 | Hancock | Kentucky | 21091 | 18 | 0 |
278660 | 278660 | 2020-06-27 | Hardin | Kentucky | 21093 | 145 | 5 |
278661 | 278661 | 2020-06-27 | Harlan | Kentucky | 21095 | 21 | 2 |
278662 | 278662 | 2020-06-27 | Harrison | Kentucky | 21097 | 68 | 0 |
278663 | 278663 | 2020-06-27 | Hart | Kentucky | 21099 | 46 | 0 |
278664 | 278664 | 2020-06-27 | Henderson | Kentucky | 21101 | 161 | 4 |
278665 | 278665 | 2020-06-27 | Henry | Kentucky | 21103 | 33 | 2 |
278666 | 278666 | 2020-06-27 | Hickman | Kentucky | 21105 | 5 | 0 |
278667 | 278667 | 2020-06-27 | Hopkins | Kentucky | 21107 | 251 | 34 |
278668 | 278668 | 2020-06-27 | Jackson | Kentucky | 21109 | 104 | 13 |
278669 | 278669 | 2020-06-27 | Jefferson | Kentucky | 21111 | 3820 | 201 |
278670 | 278670 | 2020-06-27 | Jessamine | Kentucky | 21113 | 105 | 0 |
278671 | 278671 | 2020-06-27 | Johnson | Kentucky | 21115 | 10 | 0 |
278672 | 278672 | 2020-06-27 | Kenton | Kentucky | 21117 | 785 | 37 |
278673 | 278673 | 2020-06-27 | Knott | Kentucky | 21119 | 7 | 0 |
278674 | 278674 | 2020-06-27 | Knox | Kentucky | 21121 | 63 | 0 |
278675 | 278675 | 2020-06-27 | Larue | Kentucky | 21123 | 15 | 1 |
278676 | 278676 | 2020-06-27 | Laurel | Kentucky | 21125 | 84 | 3 |
278677 | 278677 | 2020-06-27 | Lawrence | Kentucky | 21127 | 6 | 0 |
278678 | 278678 | 2020-06-27 | Lee | Kentucky | 21129 | 1 | 0 |
278679 | 278679 | 2020-06-27 | Leslie | Kentucky | 21131 | 8 | 0 |
278680 | 278680 | 2020-06-27 | Letcher | Kentucky | 21133 | 15 | 0 |
278681 | 278681 | 2020-06-27 | Lewis | Kentucky | 21135 | 21 | 0 |
278682 | 278682 | 2020-06-27 | Lincoln | Kentucky | 21137 | 25 | 1 |
278683 | 278683 | 2020-06-27 | Livingston | Kentucky | 21139 | 9 | 0 |
278684 | 278684 | 2020-06-27 | Logan | Kentucky | 21141 | 215 | 14 |
278685 | 278685 | 2020-06-27 | Lyon | Kentucky | 21143 | 19 | 3 |
278686 | 278686 | 2020-06-27 | Madison | Kentucky | 21151 | 112 | 1 |
278687 | 278687 | 2020-06-27 | Magoffin | Kentucky | 21153 | 5 | 0 |
278688 | 278688 | 2020-06-27 | Marion | Kentucky | 21155 | 49 | 0 |
278689 | 278689 | 2020-06-27 | Marshall | Kentucky | 21157 | 54 | 2 |
278690 | 278690 | 2020-06-27 | Martin | Kentucky | 21159 | 5 | 0 |
278691 | 278691 | 2020-06-27 | Mason | Kentucky | 21161 | 29 | 0 |
278692 | 278692 | 2020-06-27 | McCracken | Kentucky | 21145 | 155 | 3 |
278693 | 278693 | 2020-06-27 | McCreary | Kentucky | 21147 | 17 | 0 |
278694 | 278694 | 2020-06-27 | McLean | Kentucky | 21149 | 25 | 0 |
278695 | 278695 | 2020-06-27 | Meade | Kentucky | 21163 | 25 | 2 |
278696 | 278696 | 2020-06-27 | Menifee | Kentucky | 21165 | 12 | 0 |
278697 | 278697 | 2020-06-27 | Mercer | Kentucky | 21167 | 23 | 0 |
278698 | 278698 | 2020-06-27 | Metcalfe | Kentucky | 21169 | 9 | 2 |
278699 | 278699 | 2020-06-27 | Monroe | Kentucky | 21171 | 34 | 1 |
278700 | 278700 | 2020-06-27 | Montgomery | Kentucky | 21173 | 47 | 0 |
278701 | 278701 | 2020-06-27 | Morgan | Kentucky | 21175 | 8 | 0 |
278702 | 278702 | 2020-06-27 | Muhlenberg | Kentucky | 21177 | 512 | 8 |
278703 | 278703 | 2020-06-27 | Nelson | Kentucky | 21179 | 69 | 1 |
278704 | 278704 | 2020-06-27 | Nicholas | Kentucky | 21181 | 5 | 0 |
278705 | 278705 | 2020-06-27 | Ohio | Kentucky | 21183 | 197 | 0 |
278706 | 278706 | 2020-06-27 | Oldham | Kentucky | 21185 | 129 | 6 |
278707 | 278707 | 2020-06-27 | Owen | Kentucky | 21187 | 6 | 0 |
278708 | 278708 | 2020-06-27 | Owsley | Kentucky | 21189 | 2 | 0 |
278709 | 278709 | 2020-06-27 | Pendleton | Kentucky | 21191 | 15 | 0 |
278710 | 278710 | 2020-06-27 | Perry | Kentucky | 21193 | 57 | 1 |
278711 | 278711 | 2020-06-27 | Pike | Kentucky | 21195 | 71 | 2 |
278712 | 278712 | 2020-06-27 | Powell | Kentucky | 21197 | 6 | 0 |
278713 | 278713 | 2020-06-27 | Pulaski | Kentucky | 21199 | 89 | 2 |
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);