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-07-15 and state = "Kentucky" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
335627 | 335627 | 2020-07-15 | Adair | Kentucky | 21001 | 163 | 19 |
335628 | 335628 | 2020-07-15 | Allen | Kentucky | 21003 | 195 | 7 |
335629 | 335629 | 2020-07-15 | Anderson | Kentucky | 21005 | 34 | 1 |
335630 | 335630 | 2020-07-15 | Ballard | Kentucky | 21007 | 22 | 0 |
335631 | 335631 | 2020-07-15 | Barren | Kentucky | 21009 | 142 | 2 |
335632 | 335632 | 2020-07-15 | Bath | Kentucky | 21011 | 22 | 1 |
335633 | 335633 | 2020-07-15 | Bell | Kentucky | 21013 | 121 | 0 |
335634 | 335634 | 2020-07-15 | Boone | Kentucky | 21015 | 763 | 23 |
335635 | 335635 | 2020-07-15 | Bourbon | Kentucky | 21017 | 49 | 1 |
335636 | 335636 | 2020-07-15 | Boyd | Kentucky | 21019 | 105 | 3 |
335637 | 335637 | 2020-07-15 | Boyle | Kentucky | 21021 | 50 | 0 |
335638 | 335638 | 2020-07-15 | Bracken | Kentucky | 21023 | 20 | 0 |
335639 | 335639 | 2020-07-15 | Breathitt | Kentucky | 21025 | 15 | 0 |
335640 | 335640 | 2020-07-15 | Breckinridge | Kentucky | 21027 | 31 | 2 |
335641 | 335641 | 2020-07-15 | Bullitt | Kentucky | 21029 | 184 | 4 |
335642 | 335642 | 2020-07-15 | Butler | Kentucky | 21031 | 268 | 14 |
335643 | 335643 | 2020-07-15 | Caldwell | Kentucky | 21033 | 36 | 0 |
335644 | 335644 | 2020-07-15 | Calloway | Kentucky | 21035 | 119 | 1 |
335645 | 335645 | 2020-07-15 | Campbell | Kentucky | 21037 | 343 | 13 |
335646 | 335646 | 2020-07-15 | Carlisle | Kentucky | 21039 | 13 | 1 |
335647 | 335647 | 2020-07-15 | Carroll | Kentucky | 21041 | 96 | 1 |
335648 | 335648 | 2020-07-15 | Carter | Kentucky | 21043 | 54 | 1 |
335649 | 335649 | 2020-07-15 | Casey | Kentucky | 21045 | 113 | 4 |
335650 | 335650 | 2020-07-15 | Christian | Kentucky | 21047 | 364 | 4 |
335651 | 335651 | 2020-07-15 | Clark | Kentucky | 21049 | 117 | 6 |
335652 | 335652 | 2020-07-15 | Clay | Kentucky | 21051 | 97 | 4 |
335653 | 335653 | 2020-07-15 | Clinton | Kentucky | 21053 | 9 | 0 |
335654 | 335654 | 2020-07-15 | Crittenden | Kentucky | 21055 | 13 | 1 |
335655 | 335655 | 2020-07-15 | Cumberland | Kentucky | 21057 | 16 | 0 |
335656 | 335656 | 2020-07-15 | Daviess | Kentucky | 21059 | 534 | 8 |
335657 | 335657 | 2020-07-15 | Edmonson | Kentucky | 21061 | 84 | 12 |
335658 | 335658 | 2020-07-15 | Elliott | Kentucky | 21063 | 5 | 0 |
335659 | 335659 | 2020-07-15 | Estill | Kentucky | 21065 | 7 | 0 |
335660 | 335660 | 2020-07-15 | Fayette | Kentucky | 21067 | 2179 | 39 |
335661 | 335661 | 2020-07-15 | Fleming | Kentucky | 21069 | 31 | 0 |
335662 | 335662 | 2020-07-15 | Floyd | Kentucky | 21071 | 43 | 1 |
335663 | 335663 | 2020-07-15 | Franklin | Kentucky | 21073 | 169 | 4 |
335664 | 335664 | 2020-07-15 | Fulton | Kentucky | 21075 | 29 | 1 |
335665 | 335665 | 2020-07-15 | Gallatin | Kentucky | 21077 | 69 | 8 |
335666 | 335666 | 2020-07-15 | Garrard | Kentucky | 21079 | 42 | 0 |
335667 | 335667 | 2020-07-15 | Grant | Kentucky | 21081 | 71 | 5 |
335668 | 335668 | 2020-07-15 | Graves | Kentucky | 21083 | 334 | 21 |
335669 | 335669 | 2020-07-15 | Grayson | Kentucky | 21085 | 152 | 11 |
335670 | 335670 | 2020-07-15 | Green | Kentucky | 21087 | 21 | 1 |
335671 | 335671 | 2020-07-15 | Greenup | Kentucky | 21089 | 45 | 0 |
335672 | 335672 | 2020-07-15 | Hancock | Kentucky | 21091 | 33 | 0 |
335673 | 335673 | 2020-07-15 | Hardin | Kentucky | 21093 | 307 | 7 |
335674 | 335674 | 2020-07-15 | Harlan | Kentucky | 21095 | 58 | 2 |
335675 | 335675 | 2020-07-15 | Harrison | Kentucky | 21097 | 86 | 0 |
335676 | 335676 | 2020-07-15 | Hart | Kentucky | 21099 | 52 | 0 |
335677 | 335677 | 2020-07-15 | Henderson | Kentucky | 21101 | 221 | 4 |
335678 | 335678 | 2020-07-15 | Henry | Kentucky | 21103 | 49 | 2 |
335679 | 335679 | 2020-07-15 | Hickman | Kentucky | 21105 | 8 | 0 |
335680 | 335680 | 2020-07-15 | Hopkins | Kentucky | 21107 | 322 | 35 |
335681 | 335681 | 2020-07-15 | Jackson | Kentucky | 21109 | 118 | 14 |
335682 | 335682 | 2020-07-15 | Jefferson | Kentucky | 21111 | 4709 | 227 |
335683 | 335683 | 2020-07-15 | Jessamine | Kentucky | 21113 | 159 | 0 |
335684 | 335684 | 2020-07-15 | Johnson | Kentucky | 21115 | 12 | 0 |
335685 | 335685 | 2020-07-15 | Kenton | Kentucky | 21117 | 927 | 38 |
335686 | 335686 | 2020-07-15 | Knott | Kentucky | 21119 | 23 | 0 |
335687 | 335687 | 2020-07-15 | Knox | Kentucky | 21121 | 113 | 5 |
335688 | 335688 | 2020-07-15 | Larue | Kentucky | 21123 | 26 | 1 |
335689 | 335689 | 2020-07-15 | Laurel | Kentucky | 21125 | 210 | 4 |
335690 | 335690 | 2020-07-15 | Lawrence | Kentucky | 21127 | 14 | 0 |
335691 | 335691 | 2020-07-15 | Lee | Kentucky | 21129 | 1 | 0 |
335692 | 335692 | 2020-07-15 | Leslie | Kentucky | 21131 | 12 | 0 |
335693 | 335693 | 2020-07-15 | Letcher | Kentucky | 21133 | 21 | 0 |
335694 | 335694 | 2020-07-15 | Lewis | Kentucky | 21135 | 24 | 0 |
335695 | 335695 | 2020-07-15 | Lincoln | Kentucky | 21137 | 61 | 1 |
335696 | 335696 | 2020-07-15 | Livingston | Kentucky | 21139 | 23 | 0 |
335697 | 335697 | 2020-07-15 | Logan | Kentucky | 21141 | 267 | 16 |
335698 | 335698 | 2020-07-15 | Lyon | Kentucky | 21143 | 24 | 3 |
335699 | 335699 | 2020-07-15 | Madison | Kentucky | 21151 | 221 | 1 |
335700 | 335700 | 2020-07-15 | Magoffin | Kentucky | 21153 | 7 | 0 |
335701 | 335701 | 2020-07-15 | Marion | Kentucky | 21155 | 72 | 0 |
335702 | 335702 | 2020-07-15 | Marshall | Kentucky | 21157 | 81 | 2 |
335703 | 335703 | 2020-07-15 | Martin | Kentucky | 21159 | 12 | 0 |
335704 | 335704 | 2020-07-15 | Mason | Kentucky | 21161 | 40 | 1 |
335705 | 335705 | 2020-07-15 | McCracken | Kentucky | 21145 | 215 | 3 |
335706 | 335706 | 2020-07-15 | McCreary | Kentucky | 21147 | 20 | 0 |
335707 | 335707 | 2020-07-15 | McLean | Kentucky | 21149 | 32 | 0 |
335708 | 335708 | 2020-07-15 | Meade | Kentucky | 21163 | 43 | 2 |
335709 | 335709 | 2020-07-15 | Menifee | Kentucky | 21165 | 14 | 0 |
335710 | 335710 | 2020-07-15 | Mercer | Kentucky | 21167 | 31 | 0 |
335711 | 335711 | 2020-07-15 | Metcalfe | Kentucky | 21169 | 17 | 2 |
335712 | 335712 | 2020-07-15 | Monroe | Kentucky | 21171 | 53 | 2 |
335713 | 335713 | 2020-07-15 | Montgomery | Kentucky | 21173 | 76 | 0 |
335714 | 335714 | 2020-07-15 | Morgan | Kentucky | 21175 | 20 | 0 |
335715 | 335715 | 2020-07-15 | Muhlenberg | Kentucky | 21177 | 584 | 8 |
335716 | 335716 | 2020-07-15 | Nelson | Kentucky | 21179 | 126 | 2 |
335717 | 335717 | 2020-07-15 | Nicholas | Kentucky | 21181 | 13 | 0 |
335718 | 335718 | 2020-07-15 | Ohio | Kentucky | 21183 | 275 | 1 |
335719 | 335719 | 2020-07-15 | Oldham | Kentucky | 21185 | 181 | 7 |
335720 | 335720 | 2020-07-15 | Owen | Kentucky | 21187 | 13 | 0 |
335721 | 335721 | 2020-07-15 | Owsley | Kentucky | 21189 | 3 | 0 |
335722 | 335722 | 2020-07-15 | Pendleton | Kentucky | 21191 | 23 | 0 |
335723 | 335723 | 2020-07-15 | Perry | Kentucky | 21193 | 106 | 2 |
335724 | 335724 | 2020-07-15 | Pike | Kentucky | 21195 | 129 | 3 |
335725 | 335725 | 2020-07-15 | Powell | Kentucky | 21197 | 15 | 0 |
335726 | 335726 | 2020-07-15 | Pulaski | Kentucky | 21199 | 150 | 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);