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 2021-10-19 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1830612 | 1830612 | 2021-10-19 | Adair | Kentucky | 21001 | 3366 | 76 |
1830613 | 1830613 | 2021-10-19 | Allen | Kentucky | 21003 | 3759 | 66 |
1830614 | 1830614 | 2021-10-19 | Anderson | Kentucky | 21005 | 3347 | 40 |
1830615 | 1830615 | 2021-10-19 | Ballard | Kentucky | 21007 | 668 | 19 |
1830616 | 1830616 | 2021-10-19 | Barren | Kentucky | 21009 | 7850 | 139 |
1830617 | 1830617 | 2021-10-19 | Bath | Kentucky | 21011 | 1563 | 30 |
1830618 | 1830618 | 2021-10-19 | Bell | Kentucky | 21013 | 5760 | 91 |
1830619 | 1830619 | 2021-10-19 | Boone | Kentucky | 21015 | 20688 | 202 |
1830620 | 1830620 | 2021-10-19 | Bourbon | Kentucky | 21017 | 3119 | 32 |
1830621 | 1830621 | 2021-10-19 | Boyd | Kentucky | 21019 | 8270 | 101 |
1830622 | 1830622 | 2021-10-19 | Boyle | Kentucky | 21021 | 5298 | 79 |
1830623 | 1830623 | 2021-10-19 | Bracken | Kentucky | 21023 | 1084 | 8 |
1830624 | 1830624 | 2021-10-19 | Breathitt | Kentucky | 21025 | 1976 | 26 |
1830625 | 1830625 | 2021-10-19 | Breckinridge | Kentucky | 21027 | 2656 | 34 |
1830626 | 1830626 | 2021-10-19 | Bullitt | Kentucky | 21029 | 11865 | 123 |
1830627 | 1830627 | 2021-10-19 | Butler | Kentucky | 21031 | 2305 | 35 |
1830628 | 1830628 | 2021-10-19 | Caldwell | Kentucky | 21033 | 2317 | 47 |
1830629 | 1830629 | 2021-10-19 | Calloway | Kentucky | 21035 | 5123 | 60 |
1830630 | 1830630 | 2021-10-19 | Campbell | Kentucky | 21037 | 12899 | 99 |
1830631 | 1830631 | 2021-10-19 | Carlisle | Kentucky | 21039 | 621 | 11 |
1830632 | 1830632 | 2021-10-19 | Carroll | Kentucky | 21041 | 1841 | 26 |
1830633 | 1830633 | 2021-10-19 | Carter | Kentucky | 21043 | 4503 | 58 |
1830634 | 1830634 | 2021-10-19 | Casey | Kentucky | 21045 | 2797 | 54 |
1830635 | 1830635 | 2021-10-19 | Christian | Kentucky | 21047 | 10120 | 125 |
1830636 | 1830636 | 2021-10-19 | Clark | Kentucky | 21049 | 5133 | 37 |
1830637 | 1830637 | 2021-10-19 | Clay | Kentucky | 21051 | 5086 | 56 |
1830638 | 1830638 | 2021-10-19 | Clinton | Kentucky | 21053 | 2178 | 34 |
1830639 | 1830639 | 2021-10-19 | Crittenden | Kentucky | 21055 | 1180 | 35 |
1830640 | 1830640 | 2021-10-19 | Cumberland | Kentucky | 21057 | 1210 | 19 |
1830641 | 1830641 | 2021-10-19 | Daviess | Kentucky | 21059 | 16703 | 259 |
1830642 | 1830642 | 2021-10-19 | Edmonson | Kentucky | 21061 | 1522 | 29 |
1830643 | 1830643 | 2021-10-19 | Elliott | Kentucky | 21063 | 1307 | 7 |
1830644 | 1830644 | 2021-10-19 | Estill | Kentucky | 21065 | 2185 | 12 |
1830645 | 1830645 | 2021-10-19 | Fayette | Kentucky | 21067 | 51155 | 383 |
1830646 | 1830646 | 2021-10-19 | Fleming | Kentucky | 21069 | 2097 | 34 |
1830647 | 1830647 | 2021-10-19 | Floyd | Kentucky | 21071 | 6976 | 111 |
1830648 | 1830648 | 2021-10-19 | Franklin | Kentucky | 21073 | 6852 | 76 |
1830649 | 1830649 | 2021-10-19 | Fulton | Kentucky | 21075 | 735 | 16 |
1830650 | 1830650 | 2021-10-19 | Gallatin | Kentucky | 21077 | 1219 | 39 |
1830651 | 1830651 | 2021-10-19 | Garrard | Kentucky | 21079 | 2765 | 46 |
1830652 | 1830652 | 2021-10-19 | Grant | Kentucky | 21081 | 4239 | 38 |
1830653 | 1830653 | 2021-10-19 | Graves | Kentucky | 21083 | 7138 | 123 |
1830654 | 1830654 | 2021-10-19 | Grayson | Kentucky | 21085 | 4636 | 86 |
1830655 | 1830655 | 2021-10-19 | Green | Kentucky | 21087 | 2429 | 33 |
1830656 | 1830656 | 2021-10-19 | Greenup | Kentucky | 21089 | 6252 | 79 |
1830657 | 1830657 | 2021-10-19 | Hancock | Kentucky | 21091 | 1381 | 17 |
1830658 | 1830658 | 2021-10-19 | Hardin | Kentucky | 21093 | 17743 | 264 |
1830659 | 1830659 | 2021-10-19 | Harlan | Kentucky | 21095 | 5298 | 125 |
1830660 | 1830660 | 2021-10-19 | Harrison | Kentucky | 21097 | 3241 | 36 |
1830661 | 1830661 | 2021-10-19 | Hart | Kentucky | 21099 | 3470 | 63 |
1830662 | 1830662 | 2021-10-19 | Henderson | Kentucky | 21101 | 7887 | 98 |
1830663 | 1830663 | 2021-10-19 | Henry | Kentucky | 21103 | 2536 | 25 |
1830664 | 1830664 | 2021-10-19 | Hickman | Kentucky | 21105 | 548 | 19 |
1830665 | 1830665 | 2021-10-19 | Hopkins | Kentucky | 21107 | 7956 | 194 |
1830666 | 1830666 | 2021-10-19 | Jackson | Kentucky | 21109 | 2567 | 49 |
1830667 | 1830667 | 2021-10-19 | Jefferson | Kentucky | 21111 | 118162 | 1557 |
1830668 | 1830668 | 2021-10-19 | Jessamine | Kentucky | 21113 | 7979 | 94 |
1830669 | 1830669 | 2021-10-19 | Johnson | Kentucky | 21115 | 3661 | 46 |
1830670 | 1830670 | 2021-10-19 | Kenton | Kentucky | 21117 | 24390 | 265 |
1830671 | 1830671 | 2021-10-19 | Knott | Kentucky | 21119 | 2375 | 36 |
1830672 | 1830672 | 2021-10-19 | Knox | Kentucky | 21121 | 7126 | 52 |
1830673 | 1830673 | 2021-10-19 | Larue | Kentucky | 21123 | 2364 | 45 |
1830674 | 1830674 | 2021-10-19 | Laurel | Kentucky | 21125 | 12673 | 112 |
1830675 | 1830675 | 2021-10-19 | Lawrence | Kentucky | 21127 | 2581 | 38 |
1830676 | 1830676 | 2021-10-19 | Lee | Kentucky | 21129 | 1715 | 31 |
1830677 | 1830677 | 2021-10-19 | Leslie | Kentucky | 21131 | 2138 | 18 |
1830678 | 1830678 | 2021-10-19 | Letcher | Kentucky | 21133 | 3788 | 65 |
1830679 | 1830679 | 2021-10-19 | Lewis | Kentucky | 21135 | 2486 | 55 |
1830680 | 1830680 | 2021-10-19 | Lincoln | Kentucky | 21137 | 4264 | 80 |
1830681 | 1830681 | 2021-10-19 | Livingston | Kentucky | 21139 | 1380 | 42 |
1830682 | 1830682 | 2021-10-19 | Logan | Kentucky | 21141 | 5021 | 81 |
1830683 | 1830683 | 2021-10-19 | Lyon | Kentucky | 21143 | 1942 | 26 |
1830684 | 1830684 | 2021-10-19 | Madison | Kentucky | 21151 | 15621 | 145 |
1830685 | 1830685 | 2021-10-19 | Magoffin | Kentucky | 21153 | 2163 | 20 |
1830686 | 1830686 | 2021-10-19 | Marion | Kentucky | 21155 | 3845 | 43 |
1830687 | 1830687 | 2021-10-19 | Marshall | Kentucky | 21157 | 4984 | 77 |
1830688 | 1830688 | 2021-10-19 | Martin | Kentucky | 21159 | 1858 | 35 |
1830689 | 1830689 | 2021-10-19 | Mason | Kentucky | 21161 | 2512 | 65 |
1830690 | 1830690 | 2021-10-19 | McCracken | Kentucky | 21145 | 9969 | 170 |
1830691 | 1830691 | 2021-10-19 | McCreary | Kentucky | 21147 | 3675 | 52 |
1830692 | 1830692 | 2021-10-19 | McLean | Kentucky | 21149 | 1453 | 37 |
1830693 | 1830693 | 2021-10-19 | Meade | Kentucky | 21163 | 3427 | 35 |
1830694 | 1830694 | 2021-10-19 | Menifee | Kentucky | 21165 | 822 | 23 |
1830695 | 1830695 | 2021-10-19 | Mercer | Kentucky | 21167 | 4413 | 72 |
1830696 | 1830696 | 2021-10-19 | Metcalfe | Kentucky | 21169 | 1878 | 42 |
1830697 | 1830697 | 2021-10-19 | Monroe | Kentucky | 21171 | 2244 | 59 |
1830698 | 1830698 | 2021-10-19 | Montgomery | Kentucky | 21173 | 4410 | 54 |
1830699 | 1830699 | 2021-10-19 | Morgan | Kentucky | 21175 | 2840 | 9 |
1830700 | 1830700 | 2021-10-19 | Muhlenberg | Kentucky | 21177 | 5551 | 87 |
1830701 | 1830701 | 2021-10-19 | Nelson | Kentucky | 21179 | 8191 | 82 |
1830702 | 1830702 | 2021-10-19 | Nicholas | Kentucky | 21181 | 1149 | 17 |
1830703 | 1830703 | 2021-10-19 | Ohio | Kentucky | 21183 | 4306 | 79 |
1830704 | 1830704 | 2021-10-19 | Oldham | Kentucky | 21185 | 9985 | 93 |
1830705 | 1830705 | 2021-10-19 | Owen | Kentucky | 21187 | 1348 | 22 |
1830706 | 1830706 | 2021-10-19 | Owsley | Kentucky | 21189 | 984 | 15 |
1830707 | 1830707 | 2021-10-19 | Pendleton | Kentucky | 21191 | 2010 | 17 |
1830708 | 1830708 | 2021-10-19 | Perry | Kentucky | 21193 | 6009 | 87 |
1830709 | 1830709 | 2021-10-19 | Pike | Kentucky | 21195 | 10494 | 168 |
1830710 | 1830710 | 2021-10-19 | Powell | Kentucky | 21197 | 2469 | 21 |
1830711 | 1830711 | 2021-10-19 | Pulaski | Kentucky | 21199 | 11193 | 181 |
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);