ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-11-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 |
---|---|---|---|---|---|---|---|
1921596 | 1921596 | 2021-11-16 | Adair | Kentucky | 21001 | 3521 | 83 |
1921597 | 1921597 | 2021-11-16 | Allen | Kentucky | 21003 | 3873 | 70 |
1921598 | 1921598 | 2021-11-16 | Anderson | Kentucky | 21005 | 3653 | 49 |
1921599 | 1921599 | 2021-11-16 | Ballard | Kentucky | 21007 | 716 | 20 |
1921600 | 1921600 | 2021-11-16 | Barren | Kentucky | 21009 | 8219 | 152 |
1921601 | 1921601 | 2021-11-16 | Bath | Kentucky | 21011 | 1675 | 31 |
1921602 | 1921602 | 2021-11-16 | Bell | Kentucky | 21013 | 5904 | 98 |
1921603 | 1921603 | 2021-11-16 | Boone | Kentucky | 21015 | 21973 | 216 |
1921604 | 1921604 | 2021-11-16 | Bourbon | Kentucky | 21017 | 3334 | 35 |
1921605 | 1921605 | 2021-11-16 | Boyd | Kentucky | 21019 | 8724 | 109 |
1921606 | 1921606 | 2021-11-16 | Boyle | Kentucky | 21021 | 5527 | 84 |
1921607 | 1921607 | 2021-11-16 | Bracken | Kentucky | 21023 | 1199 | 12 |
1921608 | 1921608 | 2021-11-16 | Breathitt | Kentucky | 21025 | 2071 | 38 |
1921609 | 1921609 | 2021-11-16 | Breckinridge | Kentucky | 21027 | 2968 | 36 |
1921610 | 1921610 | 2021-11-16 | Bullitt | Kentucky | 21029 | 12476 | 134 |
1921611 | 1921611 | 2021-11-16 | Butler | Kentucky | 21031 | 2408 | 40 |
1921612 | 1921612 | 2021-11-16 | Caldwell | Kentucky | 21033 | 2479 | 50 |
1921613 | 1921613 | 2021-11-16 | Calloway | Kentucky | 21035 | 5241 | 62 |
1921614 | 1921614 | 2021-11-16 | Campbell | Kentucky | 21037 | 13566 | 114 |
1921615 | 1921615 | 2021-11-16 | Carlisle | Kentucky | 21039 | 661 | 12 |
1921616 | 1921616 | 2021-11-16 | Carroll | Kentucky | 21041 | 1983 | 29 |
1921617 | 1921617 | 2021-11-16 | Carter | Kentucky | 21043 | 4685 | 64 |
1921618 | 1921618 | 2021-11-16 | Casey | Kentucky | 21045 | 2872 | 58 |
1921619 | 1921619 | 2021-11-16 | Christian | Kentucky | 21047 | 10410 | 133 |
1921620 | 1921620 | 2021-11-16 | Clark | Kentucky | 21049 | 5456 | 43 |
1921621 | 1921621 | 2021-11-16 | Clay | Kentucky | 21051 | 5164 | 61 |
1921622 | 1921622 | 2021-11-16 | Clinton | Kentucky | 21053 | 2329 | 35 |
1921623 | 1921623 | 2021-11-16 | Crittenden | Kentucky | 21055 | 1291 | 35 |
1921624 | 1921624 | 2021-11-16 | Cumberland | Kentucky | 21057 | 1318 | 21 |
1921625 | 1921625 | 2021-11-16 | Daviess | Kentucky | 21059 | 17627 | 272 |
1921626 | 1921626 | 2021-11-16 | Edmonson | Kentucky | 21061 | 1591 | 32 |
1921627 | 1921627 | 2021-11-16 | Elliott | Kentucky | 21063 | 1363 | 8 |
1921628 | 1921628 | 2021-11-16 | Estill | Kentucky | 21065 | 2308 | 14 |
1921629 | 1921629 | 2021-11-16 | Fayette | Kentucky | 21067 | 52870 | 422 |
1921630 | 1921630 | 2021-11-16 | Fleming | Kentucky | 21069 | 2227 | 36 |
1921631 | 1921631 | 2021-11-16 | Floyd | Kentucky | 21071 | 7308 | 115 |
1921632 | 1921632 | 2021-11-16 | Franklin | Kentucky | 21073 | 7358 | 84 |
1921633 | 1921633 | 2021-11-16 | Fulton | Kentucky | 21075 | 791 | 17 |
1921634 | 1921634 | 2021-11-16 | Gallatin | Kentucky | 21077 | 1300 | 41 |
1921635 | 1921635 | 2021-11-16 | Garrard | Kentucky | 21079 | 2871 | 51 |
1921636 | 1921636 | 2021-11-16 | Grant | Kentucky | 21081 | 4638 | 41 |
1921637 | 1921637 | 2021-11-16 | Graves | Kentucky | 21083 | 7354 | 127 |
1921638 | 1921638 | 2021-11-16 | Grayson | Kentucky | 21085 | 4904 | 96 |
1921639 | 1921639 | 2021-11-16 | Green | Kentucky | 21087 | 2531 | 36 |
1921640 | 1921640 | 2021-11-16 | Greenup | Kentucky | 21089 | 6645 | 84 |
1921641 | 1921641 | 2021-11-16 | Hancock | Kentucky | 21091 | 1437 | 18 |
1921642 | 1921642 | 2021-11-16 | Hardin | Kentucky | 21093 | 18549 | 297 |
1921643 | 1921643 | 2021-11-16 | Harlan | Kentucky | 21095 | 5567 | 133 |
1921644 | 1921644 | 2021-11-16 | Harrison | Kentucky | 21097 | 3486 | 40 |
1921645 | 1921645 | 2021-11-16 | Hart | Kentucky | 21099 | 3631 | 67 |
1921646 | 1921646 | 2021-11-16 | Henderson | Kentucky | 21101 | 8132 | 108 |
1921647 | 1921647 | 2021-11-16 | Henry | Kentucky | 21103 | 2702 | 32 |
1921648 | 1921648 | 2021-11-16 | Hickman | Kentucky | 21105 | 574 | 20 |
1921649 | 1921649 | 2021-11-16 | Hopkins | Kentucky | 21107 | 8613 | 206 |
1921650 | 1921650 | 2021-11-16 | Jackson | Kentucky | 21109 | 2756 | 51 |
1921651 | 1921651 | 2021-11-16 | Jefferson | Kentucky | 21111 | 123314 | 1653 |
1921652 | 1921652 | 2021-11-16 | Jessamine | Kentucky | 21113 | 8340 | 100 |
1921653 | 1921653 | 2021-11-16 | Johnson | Kentucky | 21115 | 3831 | 50 |
1921654 | 1921654 | 2021-11-16 | Kenton | Kentucky | 21117 | 25738 | 285 |
1921655 | 1921655 | 2021-11-16 | Knott | Kentucky | 21119 | 2474 | 41 |
1921656 | 1921656 | 2021-11-16 | Knox | Kentucky | 21121 | 7300 | 60 |
1921657 | 1921657 | 2021-11-16 | Larue | Kentucky | 21123 | 2406 | 53 |
1921658 | 1921658 | 2021-11-16 | Laurel | Kentucky | 21125 | 13060 | 133 |
1921659 | 1921659 | 2021-11-16 | Lawrence | Kentucky | 21127 | 2738 | 42 |
1921660 | 1921660 | 2021-11-16 | Lee | Kentucky | 21129 | 1787 | 34 |
1921661 | 1921661 | 2021-11-16 | Leslie | Kentucky | 21131 | 2247 | 28 |
1921662 | 1921662 | 2021-11-16 | Letcher | Kentucky | 21133 | 4043 | 71 |
1921663 | 1921663 | 2021-11-16 | Lewis | Kentucky | 21135 | 2650 | 58 |
1921664 | 1921664 | 2021-11-16 | Lincoln | Kentucky | 21137 | 4424 | 99 |
1921665 | 1921665 | 2021-11-16 | Livingston | Kentucky | 21139 | 1452 | 44 |
1921666 | 1921666 | 2021-11-16 | Logan | Kentucky | 21141 | 5161 | 88 |
1921667 | 1921667 | 2021-11-16 | Lyon | Kentucky | 21143 | 1987 | 26 |
1921668 | 1921668 | 2021-11-16 | Madison | Kentucky | 21151 | 16303 | 187 |
1921669 | 1921669 | 2021-11-16 | Magoffin | Kentucky | 21153 | 2319 | 23 |
1921670 | 1921670 | 2021-11-16 | Marion | Kentucky | 21155 | 4016 | 49 |
1921671 | 1921671 | 2021-11-16 | Marshall | Kentucky | 21157 | 5097 | 80 |
1921672 | 1921672 | 2021-11-16 | Martin | Kentucky | 21159 | 1988 | 36 |
1921673 | 1921673 | 2021-11-16 | Mason | Kentucky | 21161 | 2648 | 71 |
1921674 | 1921674 | 2021-11-16 | McCracken | Kentucky | 21145 | 10393 | 181 |
1921675 | 1921675 | 2021-11-16 | McCreary | Kentucky | 21147 | 3837 | 59 |
1921676 | 1921676 | 2021-11-16 | McLean | Kentucky | 21149 | 1522 | 39 |
1921677 | 1921677 | 2021-11-16 | Meade | Kentucky | 21163 | 3533 | 40 |
1921678 | 1921678 | 2021-11-16 | Menifee | Kentucky | 21165 | 876 | 23 |
1921679 | 1921679 | 2021-11-16 | Mercer | Kentucky | 21167 | 4605 | 76 |
1921680 | 1921680 | 2021-11-16 | Metcalfe | Kentucky | 21169 | 1955 | 43 |
1921681 | 1921681 | 2021-11-16 | Monroe | Kentucky | 21171 | 2361 | 61 |
1921682 | 1921682 | 2021-11-16 | Montgomery | Kentucky | 21173 | 4643 | 60 |
1921683 | 1921683 | 2021-11-16 | Morgan | Kentucky | 21175 | 2944 | 10 |
1921684 | 1921684 | 2021-11-16 | Muhlenberg | Kentucky | 21177 | 5784 | 94 |
1921685 | 1921685 | 2021-11-16 | Nelson | Kentucky | 21179 | 8572 | 97 |
1921686 | 1921686 | 2021-11-16 | Nicholas | Kentucky | 21181 | 1223 | 19 |
1921687 | 1921687 | 2021-11-16 | Ohio | Kentucky | 21183 | 4467 | 84 |
1921688 | 1921688 | 2021-11-16 | Oldham | Kentucky | 21185 | 10384 | 95 |
1921689 | 1921689 | 2021-11-16 | Owen | Kentucky | 21187 | 1435 | 26 |
1921690 | 1921690 | 2021-11-16 | Owsley | Kentucky | 21189 | 1024 | 18 |
1921691 | 1921691 | 2021-11-16 | Pendleton | Kentucky | 21191 | 2105 | 21 |
1921692 | 1921692 | 2021-11-16 | Perry | Kentucky | 21193 | 6331 | 111 |
1921693 | 1921693 | 2021-11-16 | Pike | Kentucky | 21195 | 10996 | 198 |
1921694 | 1921694 | 2021-11-16 | Powell | Kentucky | 21197 | 2684 | 23 |
1921695 | 1921695 | 2021-11-16 | Pulaski | Kentucky | 21199 | 11679 | 194 |
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);