ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where "date" is on date 2020-05-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 |
---|---|---|---|---|---|---|---|
110527 | 110527 | 2020-05-03 | Adair | Kentucky | 21001 | 81 | 13 |
110528 | 110528 | 2020-05-03 | Allen | Kentucky | 21003 | 14 | 0 |
110529 | 110529 | 2020-05-03 | Anderson | Kentucky | 21005 | 9 | 1 |
110530 | 110530 | 2020-05-03 | Ballard | Kentucky | 21007 | 10 | 0 |
110531 | 110531 | 2020-05-03 | Barren | Kentucky | 21009 | 18 | 0 |
110532 | 110532 | 2020-05-03 | Bath | Kentucky | 21011 | 4 | 1 |
110533 | 110533 | 2020-05-03 | Boone | Kentucky | 21015 | 170 | 2 |
110534 | 110534 | 2020-05-03 | Bourbon | Kentucky | 21017 | 8 | 1 |
110535 | 110535 | 2020-05-03 | Boyd | Kentucky | 21019 | 33 | 3 |
110536 | 110536 | 2020-05-03 | Boyle | Kentucky | 21021 | 18 | 0 |
110537 | 110537 | 2020-05-03 | Bracken | Kentucky | 21023 | 9 | 0 |
110538 | 110538 | 2020-05-03 | Breathitt | Kentucky | 21025 | 3 | 0 |
110539 | 110539 | 2020-05-03 | Breckinridge | Kentucky | 21027 | 9 | 0 |
110540 | 110540 | 2020-05-03 | Bullitt | Kentucky | 21029 | 57 | 2 |
110541 | 110541 | 2020-05-03 | Butler | Kentucky | 21031 | 143 | 5 |
110542 | 110542 | 2020-05-03 | Caldwell | Kentucky | 21033 | 13 | 0 |
110543 | 110543 | 2020-05-03 | Calloway | Kentucky | 21035 | 35 | 1 |
110544 | 110544 | 2020-05-03 | Campbell | Kentucky | 21037 | 95 | 9 |
110545 | 110545 | 2020-05-03 | Carlisle | Kentucky | 21039 | 2 | 1 |
110546 | 110546 | 2020-05-03 | Carroll | Kentucky | 21041 | 2 | 0 |
110547 | 110547 | 2020-05-03 | Carter | Kentucky | 21043 | 6 | 0 |
110548 | 110548 | 2020-05-03 | Casey | Kentucky | 21045 | 1 | 0 |
110549 | 110549 | 2020-05-03 | Christian | Kentucky | 21047 | 90 | 3 |
110550 | 110550 | 2020-05-03 | Clark | Kentucky | 21049 | 21 | 0 |
110551 | 110551 | 2020-05-03 | Clay | Kentucky | 21051 | 1 | 0 |
110552 | 110552 | 2020-05-03 | Clinton | Kentucky | 21053 | 3 | 0 |
110553 | 110553 | 2020-05-03 | Crittenden | Kentucky | 21055 | 4 | 1 |
110554 | 110554 | 2020-05-03 | Cumberland | Kentucky | 21057 | 5 | 0 |
110555 | 110555 | 2020-05-03 | Daviess | Kentucky | 21059 | 228 | 4 |
110556 | 110556 | 2020-05-03 | Edmonson | Kentucky | 21061 | 32 | 0 |
110557 | 110557 | 2020-05-03 | Fayette | Kentucky | 21067 | 292 | 9 |
110558 | 110558 | 2020-05-03 | Fleming | Kentucky | 21069 | 2 | 0 |
110559 | 110559 | 2020-05-03 | Floyd | Kentucky | 21071 | 14 | 0 |
110560 | 110560 | 2020-05-03 | Franklin | Kentucky | 21073 | 17 | 0 |
110561 | 110561 | 2020-05-03 | Fulton | Kentucky | 21075 | 2 | 0 |
110562 | 110562 | 2020-05-03 | Gallatin | Kentucky | 21077 | 1 | 0 |
110563 | 110563 | 2020-05-03 | Garrard | Kentucky | 21079 | 2 | 0 |
110564 | 110564 | 2020-05-03 | Grant | Kentucky | 21081 | 25 | 3 |
110565 | 110565 | 2020-05-03 | Graves | Kentucky | 21083 | 138 | 14 |
110566 | 110566 | 2020-05-03 | Grayson | Kentucky | 21085 | 79 | 5 |
110567 | 110567 | 2020-05-03 | Green | Kentucky | 21087 | 1 | 0 |
110568 | 110568 | 2020-05-03 | Greenup | Kentucky | 21089 | 12 | 0 |
110569 | 110569 | 2020-05-03 | Hancock | Kentucky | 21091 | 6 | 0 |
110570 | 110570 | 2020-05-03 | Hardin | Kentucky | 21093 | 48 | 0 |
110571 | 110571 | 2020-05-03 | Harrison | Kentucky | 21097 | 17 | 0 |
110572 | 110572 | 2020-05-03 | Hart | Kentucky | 21099 | 8 | 0 |
110573 | 110573 | 2020-05-03 | Henderson | Kentucky | 21101 | 65 | 1 |
110574 | 110574 | 2020-05-03 | Henry | Kentucky | 21103 | 8 | 0 |
110575 | 110575 | 2020-05-03 | Hickman | Kentucky | 21105 | 1 | 0 |
110576 | 110576 | 2020-05-03 | Hopkins | Kentucky | 21107 | 207 | 23 |
110577 | 110577 | 2020-05-03 | Jackson | Kentucky | 21109 | 59 | 8 |
110578 | 110578 | 2020-05-03 | Jefferson | Kentucky | 21111 | 1403 | 96 |
110579 | 110579 | 2020-05-03 | Jessamine | Kentucky | 21113 | 41 | 0 |
110580 | 110580 | 2020-05-03 | Johnson | Kentucky | 21115 | 3 | 0 |
110581 | 110581 | 2020-05-03 | Kenton | Kentucky | 21117 | 308 | 20 |
110582 | 110582 | 2020-05-03 | Knott | Kentucky | 21119 | 4 | 0 |
110583 | 110583 | 2020-05-03 | Knox | Kentucky | 21121 | 6 | 0 |
110584 | 110584 | 2020-05-03 | Larue | Kentucky | 21123 | 5 | 0 |
110585 | 110585 | 2020-05-03 | Laurel | Kentucky | 21125 | 17 | 2 |
110586 | 110586 | 2020-05-03 | Lawrence | Kentucky | 21127 | 1 | 0 |
110587 | 110587 | 2020-05-03 | Leslie | Kentucky | 21131 | 4 | 0 |
110588 | 110588 | 2020-05-03 | Letcher | Kentucky | 21133 | 3 | 0 |
110589 | 110589 | 2020-05-03 | Lewis | Kentucky | 21135 | 3 | 0 |
110590 | 110590 | 2020-05-03 | Lincoln | Kentucky | 21137 | 5 | 1 |
110591 | 110591 | 2020-05-03 | Livingston | Kentucky | 21139 | 6 | 0 |
110592 | 110592 | 2020-05-03 | Logan | Kentucky | 21141 | 13 | 1 |
110593 | 110593 | 2020-05-03 | Lyon | Kentucky | 21143 | 13 | 3 |
110594 | 110594 | 2020-05-03 | Madison | Kentucky | 21151 | 29 | 1 |
110595 | 110595 | 2020-05-03 | Marion | Kentucky | 21155 | 17 | 0 |
110596 | 110596 | 2020-05-03 | Marshall | Kentucky | 21157 | 34 | 1 |
110597 | 110597 | 2020-05-03 | Martin | Kentucky | 21159 | 3 | 0 |
110598 | 110598 | 2020-05-03 | Mason | Kentucky | 21161 | 6 | 0 |
110599 | 110599 | 2020-05-03 | McCracken | Kentucky | 21145 | 59 | 2 |
110600 | 110600 | 2020-05-03 | McCreary | Kentucky | 21147 | 11 | 0 |
110601 | 110601 | 2020-05-03 | McLean | Kentucky | 21149 | 15 | 0 |
110602 | 110602 | 2020-05-03 | Meade | Kentucky | 21163 | 14 | 1 |
110603 | 110603 | 2020-05-03 | Menifee | Kentucky | 21165 | 3 | 0 |
110604 | 110604 | 2020-05-03 | Mercer | Kentucky | 21167 | 11 | 0 |
110605 | 110605 | 2020-05-03 | Metcalfe | Kentucky | 21169 | 1 | 0 |
110606 | 110606 | 2020-05-03 | Monroe | Kentucky | 21171 | 6 | 0 |
110607 | 110607 | 2020-05-03 | Montgomery | Kentucky | 21173 | 12 | 0 |
110608 | 110608 | 2020-05-03 | Morgan | Kentucky | 21175 | 1 | 0 |
110609 | 110609 | 2020-05-03 | Muhlenberg | Kentucky | 21177 | 241 | 4 |
110610 | 110610 | 2020-05-03 | Nelson | Kentucky | 21179 | 24 | 0 |
110611 | 110611 | 2020-05-03 | Nicholas | Kentucky | 21181 | 1 | 0 |
110612 | 110612 | 2020-05-03 | Ohio | Kentucky | 21183 | 51 | 0 |
110613 | 110613 | 2020-05-03 | Oldham | Kentucky | 21185 | 33 | 0 |
110614 | 110614 | 2020-05-03 | Owen | Kentucky | 21187 | 1 | 0 |
110615 | 110615 | 2020-05-03 | Owsley | Kentucky | 21189 | 2 | 0 |
110616 | 110616 | 2020-05-03 | Pendleton | Kentucky | 21191 | 6 | 0 |
110617 | 110617 | 2020-05-03 | Perry | Kentucky | 21193 | 14 | 0 |
110618 | 110618 | 2020-05-03 | Pike | Kentucky | 21195 | 13 | 2 |
110619 | 110619 | 2020-05-03 | Powell | Kentucky | 21197 | 1 | 0 |
110620 | 110620 | 2020-05-03 | Pulaski | Kentucky | 21199 | 43 | 2 |
110621 | 110621 | 2020-05-03 | Rockcastle | Kentucky | 21203 | 11 | 0 |
110622 | 110622 | 2020-05-03 | Rowan | Kentucky | 21205 | 2 | 0 |
110623 | 110623 | 2020-05-03 | Russell | Kentucky | 21207 | 16 | 3 |
110624 | 110624 | 2020-05-03 | Scott | Kentucky | 21209 | 29 | 0 |
110625 | 110625 | 2020-05-03 | Shelby | Kentucky | 21211 | 32 | 3 |
110626 | 110626 | 2020-05-03 | Simpson | Kentucky | 21213 | 29 | 2 |
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);