ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2021-02-14" 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 |
---|---|---|---|---|---|---|---|
1028540 | 1028540 | 2021-02-14 | Adair | Kentucky | 21001 | 1608 | 49 |
1028541 | 1028541 | 2021-02-14 | Allen | Kentucky | 21003 | 1766 | 22 |
1028542 | 1028542 | 2021-02-14 | Anderson | Kentucky | 21005 | 1575 | 15 |
1028543 | 1028543 | 2021-02-14 | Ballard | Kentucky | 21007 | 330 | 5 |
1028544 | 1028544 | 2021-02-14 | Barren | Kentucky | 21009 | 3844 | 64 |
1028545 | 1028545 | 2021-02-14 | Bath | Kentucky | 21011 | 728 | 15 |
1028546 | 1028546 | 2021-02-14 | Bell | Kentucky | 21013 | 2587 | 33 |
1028547 | 1028547 | 2021-02-14 | Boone | Kentucky | 21015 | 12405 | 70 |
1028548 | 1028548 | 2021-02-14 | Bourbon | Kentucky | 21017 | 1499 | 12 |
1028549 | 1028549 | 2021-02-14 | Boyd | Kentucky | 21019 | 4520 | 41 |
1028550 | 1028550 | 2021-02-14 | Boyle | Kentucky | 21021 | 3089 | 31 |
1028551 | 1028551 | 2021-02-14 | Bracken | Kentucky | 21023 | 485 | 4 |
1028552 | 1028552 | 2021-02-14 | Breathitt | Kentucky | 21025 | 895 | 6 |
1028553 | 1028553 | 2021-02-14 | Breckinridge | Kentucky | 21027 | 1065 | 7 |
1028554 | 1028554 | 2021-02-14 | Bullitt | Kentucky | 21029 | 6125 | 44 |
1028555 | 1028555 | 2021-02-14 | Butler | Kentucky | 21031 | 1287 | 23 |
1028556 | 1028556 | 2021-02-14 | Caldwell | Kentucky | 21033 | 1269 | 21 |
1028557 | 1028557 | 2021-02-14 | Calloway | Kentucky | 21035 | 3328 | 38 |
1028558 | 1028558 | 2021-02-14 | Campbell | Kentucky | 21037 | 7743 | 45 |
1028559 | 1028559 | 2021-02-14 | Carlisle | Kentucky | 21039 | 420 | 1 |
1028560 | 1028560 | 2021-02-14 | Carroll | Kentucky | 21041 | 857 | 10 |
1028561 | 1028561 | 2021-02-14 | Carter | Kentucky | 21043 | 1908 | 21 |
1028562 | 1028562 | 2021-02-14 | Casey | Kentucky | 21045 | 1243 | 34 |
1028563 | 1028563 | 2021-02-14 | Christian | Kentucky | 21047 | 6041 | 78 |
1028564 | 1028564 | 2021-02-14 | Clark | Kentucky | 21049 | 2309 | 18 |
1028565 | 1028565 | 2021-02-14 | Clay | Kentucky | 21051 | 2322 | 26 |
1028566 | 1028566 | 2021-02-14 | Clinton | Kentucky | 21053 | 1359 | 26 |
1028567 | 1028567 | 2021-02-14 | Crittenden | Kentucky | 21055 | 547 | 17 |
1028568 | 1028568 | 2021-02-14 | Cumberland | Kentucky | 21057 | 635 | 8 |
1028569 | 1028569 | 2021-02-14 | Daviess | Kentucky | 21059 | 9347 | 151 |
1028570 | 1028570 | 2021-02-14 | Edmonson | Kentucky | 21061 | 849 | 17 |
1028571 | 1028571 | 2021-02-14 | Elliott | Kentucky | 21063 | 926 | 1 |
1028572 | 1028572 | 2021-02-14 | Estill | Kentucky | 21065 | 930 | 0 |
1028573 | 1028573 | 2021-02-14 | Fayette | Kentucky | 21067 | 31465 | 212 |
1028574 | 1028574 | 2021-02-14 | Fleming | Kentucky | 21069 | 1062 | 14 |
1028575 | 1028575 | 2021-02-14 | Floyd | Kentucky | 21071 | 2927 | 27 |
1028576 | 1028576 | 2021-02-14 | Franklin | Kentucky | 21073 | 3489 | 28 |
1028577 | 1028577 | 2021-02-14 | Fulton | Kentucky | 21075 | 462 | 6 |
1028578 | 1028578 | 2021-02-14 | Gallatin | Kentucky | 21077 | 629 | 19 |
1028579 | 1028579 | 2021-02-14 | Garrard | Kentucky | 21079 | 1350 | 8 |
1028580 | 1028580 | 2021-02-14 | Grant | Kentucky | 21081 | 2080 | 12 |
1028581 | 1028581 | 2021-02-14 | Graves | Kentucky | 21083 | 3890 | 69 |
1028582 | 1028582 | 2021-02-14 | Grayson | Kentucky | 21085 | 1882 | 45 |
1028583 | 1028583 | 2021-02-14 | Green | Kentucky | 21087 | 1070 | 13 |
1028584 | 1028584 | 2021-02-14 | Greenup | Kentucky | 21089 | 3238 | 23 |
1028585 | 1028585 | 2021-02-14 | Hancock | Kentucky | 21091 | 787 | 15 |
1028586 | 1028586 | 2021-02-14 | Hardin | Kentucky | 21093 | 8493 | 85 |
1028587 | 1028587 | 2021-02-14 | Harlan | Kentucky | 21095 | 2326 | 64 |
1028588 | 1028588 | 2021-02-14 | Harrison | Kentucky | 21097 | 1448 | 9 |
1028589 | 1028589 | 2021-02-14 | Hart | Kentucky | 21099 | 1765 | 33 |
1028590 | 1028590 | 2021-02-14 | Henderson | Kentucky | 21101 | 4240 | 57 |
1028591 | 1028591 | 2021-02-14 | Henry | Kentucky | 21103 | 1157 | 6 |
1028592 | 1028592 | 2021-02-14 | Hickman | Kentucky | 21105 | 311 | 7 |
1028593 | 1028593 | 2021-02-14 | Hopkins | Kentucky | 21107 | 3819 | 128 |
1028594 | 1028594 | 2021-02-14 | Jackson | Kentucky | 21109 | 1173 | 29 |
1028595 | 1028595 | 2021-02-14 | Jefferson | Kentucky | 21111 | 71860 | 867 |
1028596 | 1028596 | 2021-02-14 | Jessamine | Kentucky | 21113 | 3949 | 49 |
1028597 | 1028597 | 2021-02-14 | Johnson | Kentucky | 21115 | 1673 | 18 |
1028598 | 1028598 | 2021-02-14 | Kenton | Kentucky | 21117 | 14757 | 118 |
1028599 | 1028599 | 2021-02-14 | Knott | Kentucky | 21119 | 971 | 15 |
1028600 | 1028600 | 2021-02-14 | Knox | Kentucky | 21121 | 2763 | 11 |
1028601 | 1028601 | 2021-02-14 | Larue | Kentucky | 21123 | 1143 | 11 |
1028602 | 1028602 | 2021-02-14 | Laurel | Kentucky | 21125 | 5554 | 23 |
1028603 | 1028603 | 2021-02-14 | Lawrence | Kentucky | 21127 | 1184 | 17 |
1028604 | 1028604 | 2021-02-14 | Lee | Kentucky | 21129 | 1171 | 18 |
1028605 | 1028605 | 2021-02-14 | Leslie | Kentucky | 21131 | 744 | 2 |
1028606 | 1028606 | 2021-02-14 | Letcher | Kentucky | 21133 | 1611 | 18 |
1028607 | 1028607 | 2021-02-14 | Lewis | Kentucky | 21135 | 1066 | 30 |
1028608 | 1028608 | 2021-02-14 | Lincoln | Kentucky | 21137 | 2033 | 31 |
1028609 | 1028609 | 2021-02-14 | Livingston | Kentucky | 21139 | 728 | 16 |
1028610 | 1028610 | 2021-02-14 | Logan | Kentucky | 21141 | 2380 | 50 |
1028611 | 1028611 | 2021-02-14 | Lyon | Kentucky | 21143 | 455 | 13 |
1028612 | 1028612 | 2021-02-14 | Madison | Kentucky | 21151 | 8306 | 77 |
1028613 | 1028613 | 2021-02-14 | Magoffin | Kentucky | 21153 | 844 | 1 |
1028614 | 1028614 | 2021-02-14 | Marion | Kentucky | 21155 | 2076 | 23 |
1028615 | 1028615 | 2021-02-14 | Marshall | Kentucky | 21157 | 2440 | 43 |
1028616 | 1028616 | 2021-02-14 | Martin | Kentucky | 21159 | 901 | 11 |
1028617 | 1028617 | 2021-02-14 | Mason | Kentucky | 21161 | 1360 | 26 |
1028618 | 1028618 | 2021-02-14 | McCracken | Kentucky | 21145 | 5550 | 63 |
1028619 | 1028619 | 2021-02-14 | McCreary | Kentucky | 21147 | 1711 | 21 |
1028620 | 1028620 | 2021-02-14 | McLean | Kentucky | 21149 | 818 | 25 |
1028621 | 1028621 | 2021-02-14 | Meade | Kentucky | 21163 | 1781 | 13 |
1028622 | 1028622 | 2021-02-14 | Menifee | Kentucky | 21165 | 387 | 11 |
1028623 | 1028623 | 2021-02-14 | Mercer | Kentucky | 21167 | 2283 | 18 |
1028624 | 1028624 | 2021-02-14 | Metcalfe | Kentucky | 21169 | 911 | 19 |
1028625 | 1028625 | 2021-02-14 | Monroe | Kentucky | 21171 | 1234 | 36 |
1028626 | 1028626 | 2021-02-14 | Montgomery | Kentucky | 21173 | 2177 | 23 |
1028627 | 1028627 | 2021-02-14 | Morgan | Kentucky | 21175 | 1964 | 1 |
1028628 | 1028628 | 2021-02-14 | Muhlenberg | Kentucky | 21177 | 2676 | 51 |
1028629 | 1028629 | 2021-02-14 | Nelson | Kentucky | 21179 | 4436 | 31 |
1028630 | 1028630 | 2021-02-14 | Nicholas | Kentucky | 21181 | 433 | 6 |
1028631 | 1028631 | 2021-02-14 | Ohio | Kentucky | 21183 | 2274 | 46 |
1028632 | 1028632 | 2021-02-14 | Oldham | Kentucky | 21185 | 6720 | 69 |
1028633 | 1028633 | 2021-02-14 | Owen | Kentucky | 21187 | 605 | 7 |
1028634 | 1028634 | 2021-02-14 | Owsley | Kentucky | 21189 | 399 | 10 |
1028635 | 1028635 | 2021-02-14 | Pendleton | Kentucky | 21191 | 899 | 1 |
1028636 | 1028636 | 2021-02-14 | Perry | Kentucky | 21193 | 2166 | 32 |
1028637 | 1028637 | 2021-02-14 | Pike | Kentucky | 21195 | 4874 | 51 |
1028638 | 1028638 | 2021-02-14 | Powell | Kentucky | 21197 | 944 | 0 |
1028639 | 1028639 | 2021-02-14 | Pulaski | Kentucky | 21199 | 5578 | 81 |
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);