ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2269501 | 2269501 | 2022-03-03 | Adair | Kentucky | 21001 | 5522 | 99 |
2269502 | 2269502 | 2022-03-03 | Allen | Kentucky | 21003 | 6525 | 94 |
2269503 | 2269503 | 2022-03-03 | Anderson | Kentucky | 21005 | 6191 | 65 |
2269504 | 2269504 | 2022-03-03 | Ballard | Kentucky | 21007 | 1256 | 27 |
2269505 | 2269505 | 2022-03-03 | Barren | Kentucky | 21009 | 12720 | 204 |
2269506 | 2269506 | 2022-03-03 | Bath | Kentucky | 21011 | 2885 | 38 |
2269507 | 2269507 | 2022-03-03 | Bell | Kentucky | 21013 | 8771 | 131 |
2269508 | 2269508 | 2022-03-03 | Boone | Kentucky | 21015 | 38840 | 268 |
2269509 | 2269509 | 2022-03-03 | Bourbon | Kentucky | 21017 | 5900 | 51 |
2269510 | 2269510 | 2022-03-03 | Boyd | Kentucky | 21019 | 16022 | 165 |
2269511 | 2269511 | 2022-03-03 | Boyle | Kentucky | 21021 | 8316 | 122 |
2269512 | 2269512 | 2022-03-03 | Bracken | Kentucky | 21023 | 2095 | 24 |
2269513 | 2269513 | 2022-03-03 | Breathitt | Kentucky | 21025 | 3544 | 50 |
2269514 | 2269514 | 2022-03-03 | Breckinridge | Kentucky | 21027 | 4981 | 72 |
2269515 | 2269515 | 2022-03-03 | Bullitt | Kentucky | 21029 | 20913 | 194 |
2269516 | 2269516 | 2022-03-03 | Butler | Kentucky | 21031 | 3835 | 49 |
2269517 | 2269517 | 2022-03-03 | Caldwell | Kentucky | 21033 | 4007 | 58 |
2269518 | 2269518 | 2022-03-03 | Calloway | Kentucky | 21035 | 7906 | 85 |
2269519 | 2269519 | 2022-03-03 | Campbell | Kentucky | 21037 | 24215 | 153 |
2269520 | 2269520 | 2022-03-03 | Carlisle | Kentucky | 21039 | 967 | 19 |
2269521 | 2269521 | 2022-03-03 | Carroll | Kentucky | 21041 | 3435 | 42 |
2269522 | 2269522 | 2022-03-03 | Carter | Kentucky | 21043 | 8442 | 97 |
2269523 | 2269523 | 2022-03-03 | Casey | Kentucky | 21045 | 3934 | 66 |
2269524 | 2269524 | 2022-03-03 | Christian | Kentucky | 21047 | 15987 | 196 |
2269525 | 2269525 | 2022-03-03 | Clark | Kentucky | 21049 | 9899 | 53 |
2269526 | 2269526 | 2022-03-03 | Clay | Kentucky | 21051 | 7734 | 82 |
2269527 | 2269527 | 2022-03-03 | Clinton | Kentucky | 21053 | 3366 | 43 |
2269528 | 2269528 | 2022-03-03 | Crittenden | Kentucky | 21055 | 2127 | 45 |
2269529 | 2269529 | 2022-03-03 | Cumberland | Kentucky | 21057 | 2145 | 28 |
2269530 | 2269530 | 2022-03-03 | Daviess | Kentucky | 21059 | 30811 | 358 |
2269531 | 2269531 | 2022-03-03 | Edmonson | Kentucky | 21061 | 2526 | 38 |
2269532 | 2269532 | 2022-03-03 | Elliott | Kentucky | 21063 | 2240 | 16 |
2269533 | 2269533 | 2022-03-03 | Estill | Kentucky | 21065 | 4054 | 42 |
2269534 | 2269534 | 2022-03-03 | Fayette | Kentucky | 21067 | 93215 | 554 |
2269535 | 2269535 | 2022-03-03 | Fleming | Kentucky | 21069 | 3640 | 48 |
2269536 | 2269536 | 2022-03-03 | Floyd | Kentucky | 21071 | 12269 | 159 |
2269537 | 2269537 | 2022-03-03 | Franklin | Kentucky | 21073 | 13174 | 135 |
2269538 | 2269538 | 2022-03-03 | Fulton | Kentucky | 21075 | 1151 | 24 |
2269539 | 2269539 | 2022-03-03 | Gallatin | Kentucky | 21077 | 2161 | 45 |
2269540 | 2269540 | 2022-03-03 | Garrard | Kentucky | 21079 | 4727 | 71 |
2269541 | 2269541 | 2022-03-03 | Grant | Kentucky | 21081 | 7555 | 57 |
2269542 | 2269542 | 2022-03-03 | Graves | Kentucky | 21083 | 11320 | 160 |
2269543 | 2269543 | 2022-03-03 | Grayson | Kentucky | 21085 | 8027 | 122 |
2269544 | 2269544 | 2022-03-03 | Green | Kentucky | 21087 | 3509 | 40 |
2269545 | 2269545 | 2022-03-03 | Greenup | Kentucky | 21089 | 11858 | 126 |
2269546 | 2269546 | 2022-03-03 | Hancock | Kentucky | 21091 | 2444 | 21 |
2269547 | 2269547 | 2022-03-03 | Hardin | Kentucky | 21093 | 32227 | 403 |
2269548 | 2269548 | 2022-03-03 | Harlan | Kentucky | 21095 | 9069 | 183 |
2269549 | 2269549 | 2022-03-03 | Harrison | Kentucky | 21097 | 6099 | 62 |
2269550 | 2269550 | 2022-03-03 | Hart | Kentucky | 21099 | 5332 | 92 |
2269551 | 2269551 | 2022-03-03 | Henderson | Kentucky | 21101 | 13678 | 147 |
2269552 | 2269552 | 2022-03-03 | Henry | Kentucky | 21103 | 4733 | 46 |
2269553 | 2269553 | 2022-03-03 | Hickman | Kentucky | 21105 | 817 | 23 |
2269554 | 2269554 | 2022-03-03 | Hopkins | Kentucky | 21107 | 14671 | 244 |
2269555 | 2269555 | 2022-03-03 | Jackson | Kentucky | 21109 | 4200 | 71 |
2269556 | 2269556 | 2022-03-03 | Jefferson | Kentucky | 21111 | 224325 | 2113 |
2269557 | 2269557 | 2022-03-03 | Jessamine | Kentucky | 21113 | 14965 | 129 |
2269558 | 2269558 | 2022-03-03 | Johnson | Kentucky | 21115 | 5905 | 96 |
2269559 | 2269559 | 2022-03-03 | Kenton | Kentucky | 21117 | 44827 | 370 |
2269560 | 2269560 | 2022-03-03 | Knott | Kentucky | 21119 | 4041 | 57 |
2269561 | 2269561 | 2022-03-03 | Knox | Kentucky | 21121 | 11357 | 125 |
2269562 | 2269562 | 2022-03-03 | Larue | Kentucky | 21123 | 3705 | 67 |
2269563 | 2269563 | 2022-03-03 | Laurel | Kentucky | 21125 | 18343 | 202 |
2269564 | 2269564 | 2022-03-03 | Lawrence | Kentucky | 21127 | 4473 | 59 |
2269565 | 2269565 | 2022-03-03 | Lee | Kentucky | 21129 | 2885 | 46 |
2269566 | 2269566 | 2022-03-03 | Leslie | Kentucky | 21131 | 3622 | 39 |
2269567 | 2269567 | 2022-03-03 | Letcher | Kentucky | 21133 | 6746 | 93 |
2269568 | 2269568 | 2022-03-03 | Lewis | Kentucky | 21135 | 4438 | 79 |
2269569 | 2269569 | 2022-03-03 | Lincoln | Kentucky | 21137 | 6206 | 121 |
2269570 | 2269570 | 2022-03-03 | Livingston | Kentucky | 21139 | 2320 | 58 |
2269571 | 2269571 | 2022-03-03 | Logan | Kentucky | 21141 | 8276 | 112 |
2269572 | 2269572 | 2022-03-03 | Lyon | Kentucky | 21143 | 2813 | 33 |
2269573 | 2269573 | 2022-03-03 | Madison | Kentucky | 21151 | 27426 | 250 |
2269574 | 2269574 | 2022-03-03 | Magoffin | Kentucky | 21153 | 3799 | 41 |
2269575 | 2269575 | 2022-03-03 | Marion | Kentucky | 21155 | 6339 | 75 |
2269576 | 2269576 | 2022-03-03 | Marshall | Kentucky | 21157 | 8342 | 97 |
2269577 | 2269577 | 2022-03-03 | Martin | Kentucky | 21159 | 3222 | 45 |
2269578 | 2269578 | 2022-03-03 | Mason | Kentucky | 21161 | 4551 | 97 |
2269579 | 2269579 | 2022-03-03 | McCracken | Kentucky | 21145 | 17797 | 229 |
2269580 | 2269580 | 2022-03-03 | McCreary | Kentucky | 21147 | 5109 | 74 |
2269581 | 2269581 | 2022-03-03 | McLean | Kentucky | 21149 | 2599 | 46 |
2269582 | 2269582 | 2022-03-03 | Meade | Kentucky | 21163 | 5743 | 64 |
2269583 | 2269583 | 2022-03-03 | Menifee | Kentucky | 21165 | 1501 | 30 |
2269584 | 2269584 | 2022-03-03 | Mercer | Kentucky | 21167 | 7266 | 99 |
2269585 | 2269585 | 2022-03-03 | Metcalfe | Kentucky | 21169 | 2824 | 58 |
2269586 | 2269586 | 2022-03-03 | Monroe | Kentucky | 21171 | 3601 | 74 |
2269587 | 2269587 | 2022-03-03 | Montgomery | Kentucky | 21173 | 6656 | 87 |
2269588 | 2269588 | 2022-03-03 | Morgan | Kentucky | 21175 | 4630 | 17 |
2269589 | 2269589 | 2022-03-03 | Muhlenberg | Kentucky | 21177 | 10066 | 117 |
2269590 | 2269590 | 2022-03-03 | Nelson | Kentucky | 21179 | 14286 | 139 |
2269591 | 2269591 | 2022-03-03 | Nicholas | Kentucky | 21181 | 1874 | 30 |
2269592 | 2269592 | 2022-03-03 | Ohio | Kentucky | 21183 | 7252 | 95 |
2269593 | 2269593 | 2022-03-03 | Oldham | Kentucky | 21185 | 18031 | 126 |
2269594 | 2269594 | 2022-03-03 | Owen | Kentucky | 21187 | 2351 | 32 |
2269595 | 2269595 | 2022-03-03 | Owsley | Kentucky | 21189 | 1548 | 23 |
2269596 | 2269596 | 2022-03-03 | Pendleton | Kentucky | 21191 | 3412 | 34 |
2269597 | 2269597 | 2022-03-03 | Perry | Kentucky | 21193 | 10515 | 148 |
2269598 | 2269598 | 2022-03-03 | Pike | Kentucky | 21195 | 18267 | 257 |
2269599 | 2269599 | 2022-03-03 | Powell | Kentucky | 21197 | 4687 | 38 |
2269600 | 2269600 | 2022-03-03 | Pulaski | Kentucky | 21199 | 15903 | 253 |
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);