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-09-07 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 |
---|---|---|---|---|---|---|---|
509540 | 509540 | 2020-09-07 | Adair | Kentucky | 21001 | 282 | 19 |
509541 | 509541 | 2020-09-07 | Allen | Kentucky | 21003 | 263 | 9 |
509542 | 509542 | 2020-09-07 | Anderson | Kentucky | 21005 | 123 | 1 |
509543 | 509543 | 2020-09-07 | Ballard | Kentucky | 21007 | 45 | 1 |
509544 | 509544 | 2020-09-07 | Barren | Kentucky | 21009 | 531 | 10 |
509545 | 509545 | 2020-09-07 | Bath | Kentucky | 21011 | 68 | 1 |
509546 | 509546 | 2020-09-07 | Bell | Kentucky | 21013 | 430 | 9 |
509547 | 509547 | 2020-09-07 | Boone | Kentucky | 21015 | 1361 | 25 |
509548 | 509548 | 2020-09-07 | Bourbon | Kentucky | 21017 | 137 | 1 |
509549 | 509549 | 2020-09-07 | Boyd | Kentucky | 21019 | 290 | 4 |
509550 | 509550 | 2020-09-07 | Boyle | Kentucky | 21021 | 221 | 0 |
509551 | 509551 | 2020-09-07 | Bracken | Kentucky | 21023 | 37 | 0 |
509552 | 509552 | 2020-09-07 | Breathitt | Kentucky | 21025 | 57 | 0 |
509553 | 509553 | 2020-09-07 | Breckinridge | Kentucky | 21027 | 103 | 2 |
509554 | 509554 | 2020-09-07 | Bullitt | Kentucky | 21029 | 690 | 5 |
509555 | 509555 | 2020-09-07 | Butler | Kentucky | 21031 | 327 | 16 |
509556 | 509556 | 2020-09-07 | Caldwell | Kentucky | 21033 | 92 | 0 |
509557 | 509557 | 2020-09-07 | Calloway | Kentucky | 21035 | 453 | 7 |
509558 | 509558 | 2020-09-07 | Campbell | Kentucky | 21037 | 744 | 17 |
509559 | 509559 | 2020-09-07 | Carlisle | Kentucky | 21039 | 64 | 1 |
509560 | 509560 | 2020-09-07 | Carroll | Kentucky | 21041 | 195 | 5 |
509561 | 509561 | 2020-09-07 | Carter | Kentucky | 21043 | 129 | 3 |
509562 | 509562 | 2020-09-07 | Casey | Kentucky | 21045 | 261 | 16 |
509563 | 509563 | 2020-09-07 | Christian | Kentucky | 21047 | 951 | 14 |
509564 | 509564 | 2020-09-07 | Clark | Kentucky | 21049 | 272 | 8 |
509565 | 509565 | 2020-09-07 | Clay | Kentucky | 21051 | 226 | 6 |
509566 | 509566 | 2020-09-07 | Clinton | Kentucky | 21053 | 77 | 2 |
509567 | 509567 | 2020-09-07 | Crittenden | Kentucky | 21055 | 80 | 1 |
509568 | 509568 | 2020-09-07 | Cumberland | Kentucky | 21057 | 91 | 0 |
509569 | 509569 | 2020-09-07 | Daviess | Kentucky | 21059 | 1064 | 13 |
509570 | 509570 | 2020-09-07 | Edmonson | Kentucky | 21061 | 135 | 12 |
509571 | 509571 | 2020-09-07 | Elliott | Kentucky | 21063 | 31 | 0 |
509572 | 509572 | 2020-09-07 | Estill | Kentucky | 21065 | 61 | 0 |
509573 | 509573 | 2020-09-07 | Fayette | Kentucky | 21067 | 6450 | 61 |
509574 | 509574 | 2020-09-07 | Fleming | Kentucky | 21069 | 73 | 0 |
509575 | 509575 | 2020-09-07 | Floyd | Kentucky | 21071 | 156 | 2 |
509576 | 509576 | 2020-09-07 | Franklin | Kentucky | 21073 | 513 | 11 |
509577 | 509577 | 2020-09-07 | Fulton | Kentucky | 21075 | 126 | 2 |
509578 | 509578 | 2020-09-07 | Gallatin | Kentucky | 21077 | 92 | 8 |
509579 | 509579 | 2020-09-07 | Garrard | Kentucky | 21079 | 132 | 2 |
509580 | 509580 | 2020-09-07 | Grant | Kentucky | 21081 | 143 | 6 |
509581 | 509581 | 2020-09-07 | Graves | Kentucky | 21083 | 670 | 29 |
509582 | 509582 | 2020-09-07 | Grayson | Kentucky | 21085 | 302 | 12 |
509583 | 509583 | 2020-09-07 | Green | Kentucky | 21087 | 217 | 8 |
509584 | 509584 | 2020-09-07 | Greenup | Kentucky | 21089 | 276 | 2 |
509585 | 509585 | 2020-09-07 | Hancock | Kentucky | 21091 | 64 | 0 |
509586 | 509586 | 2020-09-07 | Hardin | Kentucky | 21093 | 993 | 10 |
509587 | 509587 | 2020-09-07 | Harlan | Kentucky | 21095 | 321 | 9 |
509588 | 509588 | 2020-09-07 | Harrison | Kentucky | 21097 | 158 | 0 |
509589 | 509589 | 2020-09-07 | Hart | Kentucky | 21099 | 156 | 1 |
509590 | 509590 | 2020-09-07 | Henderson | Kentucky | 21101 | 504 | 4 |
509591 | 509591 | 2020-09-07 | Henry | Kentucky | 21103 | 166 | 2 |
509592 | 509592 | 2020-09-07 | Hickman | Kentucky | 21105 | 71 | 0 |
509593 | 509593 | 2020-09-07 | Hopkins | Kentucky | 21107 | 536 | 37 |
509594 | 509594 | 2020-09-07 | Jackson | Kentucky | 21109 | 292 | 15 |
509595 | 509595 | 2020-09-07 | Jefferson | Kentucky | 21111 | 14330 | 302 |
509596 | 509596 | 2020-09-07 | Jessamine | Kentucky | 21113 | 492 | 0 |
509597 | 509597 | 2020-09-07 | Johnson | Kentucky | 21115 | 128 | 1 |
509598 | 509598 | 2020-09-07 | Kenton | Kentucky | 21117 | 1817 | 44 |
509599 | 509599 | 2020-09-07 | Knott | Kentucky | 21119 | 96 | 1 |
509600 | 509600 | 2020-09-07 | Knox | Kentucky | 21121 | 379 | 9 |
509601 | 509601 | 2020-09-07 | Larue | Kentucky | 21123 | 110 | 1 |
509602 | 509602 | 2020-09-07 | Laurel | Kentucky | 21125 | 626 | 5 |
509603 | 509603 | 2020-09-07 | Lawrence | Kentucky | 21127 | 47 | 0 |
509604 | 509604 | 2020-09-07 | Lee | Kentucky | 21129 | 13 | 0 |
509605 | 509605 | 2020-09-07 | Leslie | Kentucky | 21131 | 42 | 0 |
509606 | 509606 | 2020-09-07 | Letcher | Kentucky | 21133 | 79 | 2 |
509607 | 509607 | 2020-09-07 | Lewis | Kentucky | 21135 | 198 | 13 |
509608 | 509608 | 2020-09-07 | Lincoln | Kentucky | 21137 | 146 | 10 |
509609 | 509609 | 2020-09-07 | Livingston | Kentucky | 21139 | 60 | 1 |
509610 | 509610 | 2020-09-07 | Logan | Kentucky | 21141 | 465 | 26 |
509611 | 509611 | 2020-09-07 | Lyon | Kentucky | 21143 | 43 | 4 |
509612 | 509612 | 2020-09-07 | Madison | Kentucky | 21151 | 1234 | 4 |
509613 | 509613 | 2020-09-07 | Magoffin | Kentucky | 21153 | 69 | 0 |
509614 | 509614 | 2020-09-07 | Marion | Kentucky | 21155 | 190 | 5 |
509615 | 509615 | 2020-09-07 | Marshall | Kentucky | 21157 | 208 | 2 |
509616 | 509616 | 2020-09-07 | Martin | Kentucky | 21159 | 58 | 2 |
509617 | 509617 | 2020-09-07 | Mason | Kentucky | 21161 | 110 | 2 |
509618 | 509618 | 2020-09-07 | McCracken | Kentucky | 21145 | 562 | 6 |
509619 | 509619 | 2020-09-07 | McCreary | Kentucky | 21147 | 116 | 0 |
509620 | 509620 | 2020-09-07 | McLean | Kentucky | 21149 | 65 | 0 |
509621 | 509621 | 2020-09-07 | Meade | Kentucky | 21163 | 155 | 3 |
509622 | 509622 | 2020-09-07 | Menifee | Kentucky | 21165 | 35 | 0 |
509623 | 509623 | 2020-09-07 | Mercer | Kentucky | 21167 | 142 | 1 |
509624 | 509624 | 2020-09-07 | Metcalfe | Kentucky | 21169 | 92 | 2 |
509625 | 509625 | 2020-09-07 | Monroe | Kentucky | 21171 | 173 | 3 |
509626 | 509626 | 2020-09-07 | Montgomery | Kentucky | 21173 | 210 | 1 |
509627 | 509627 | 2020-09-07 | Morgan | Kentucky | 21175 | 50 | 0 |
509628 | 509628 | 2020-09-07 | Muhlenberg | Kentucky | 21177 | 696 | 11 |
509629 | 509629 | 2020-09-07 | Nelson | Kentucky | 21179 | 403 | 3 |
509630 | 509630 | 2020-09-07 | Nicholas | Kentucky | 21181 | 27 | 1 |
509631 | 509631 | 2020-09-07 | Ohio | Kentucky | 21183 | 425 | 9 |
509632 | 509632 | 2020-09-07 | Oldham | Kentucky | 21185 | 881 | 24 |
509633 | 509633 | 2020-09-07 | Owen | Kentucky | 21187 | 85 | 1 |
509634 | 509634 | 2020-09-07 | Owsley | Kentucky | 21189 | 37 | 1 |
509635 | 509635 | 2020-09-07 | Pendleton | Kentucky | 21191 | 69 | 0 |
509636 | 509636 | 2020-09-07 | Perry | Kentucky | 21193 | 294 | 8 |
509637 | 509637 | 2020-09-07 | Pike | Kentucky | 21195 | 346 | 3 |
509638 | 509638 | 2020-09-07 | Powell | Kentucky | 21197 | 85 | 0 |
509639 | 509639 | 2020-09-07 | Pulaski | Kentucky | 21199 | 639 | 7 |
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);