ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 106 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
730040 | 730040 | 2020-11-14 | Menifee | Kentucky | 21165 | 106 | 1 |
720232 | 720232 | 2020-11-11 | Ballard | Kentucky | 21007 | 106 | 1 |
710501 | 710501 | 2020-11-08 | Ballard | Kentucky | 21007 | 106 | 1 |
710616 | 710616 | 2020-11-08 | Wolfe | Kentucky | 21237 | 106 | 0 |
700863 | 700863 | 2020-11-05 | Owsley | Kentucky | 21189 | 106 | 1 |
681327 | 681327 | 2020-10-30 | Carlisle | Kentucky | 21039 | 106 | 1 |
671650 | 671650 | 2020-10-27 | Lyon | Kentucky | 21143 | 106 | 4 |
668408 | 668408 | 2020-10-26 | Lyon | Kentucky | 21143 | 106 | 4 |
665164 | 665164 | 2020-10-25 | Lyon | Kentucky | 21143 | 106 | 4 |
661919 | 661919 | 2020-10-24 | Lyon | Kentucky | 21143 | 106 | 4 |
652119 | 652119 | 2020-10-21 | Bath | Kentucky | 21011 | 106 | 1 |
632651 | 632651 | 2020-10-15 | Breathitt | Kentucky | 21025 | 106 | 0 |
626216 | 626216 | 2020-10-13 | Leslie | Kentucky | 21131 | 106 | 0 |
626244 | 626244 | 2020-10-13 | Owen | Kentucky | 21187 | 106 | 2 |
626246 | 626246 | 2020-10-13 | Pendleton | Kentucky | 21191 | 106 | 0 |
622989 | 622989 | 2020-10-12 | McLean | Kentucky | 21149 | 106 | 0 |
623002 | 623002 | 2020-10-12 | Owen | Kentucky | 21187 | 106 | 2 |
623004 | 623004 | 2020-10-12 | Pendleton | Kentucky | 21191 | 106 | 0 |
619730 | 619730 | 2020-10-11 | Leslie | Kentucky | 21131 | 106 | 0 |
616461 | 616461 | 2020-10-10 | Gallatin | Kentucky | 21077 | 106 | 8 |
610013 | 610013 | 2020-10-08 | Magoffin | Kentucky | 21153 | 106 | 0 |
580795 | 580795 | 2020-09-29 | Cumberland | Kentucky | 21057 | 106 | 0 |
551633 | 551633 | 2020-09-20 | Clinton | Kentucky | 21053 | 106 | 2 |
551691 | 551691 | 2020-09-20 | Metcalfe | Kentucky | 21169 | 106 | 2 |
548452 | 548452 | 2020-09-19 | Metcalfe | Kentucky | 21169 | 106 | 2 |
541960 | 541960 | 2020-09-17 | Letcher | Kentucky | 21133 | 106 | 2 |
516018 | 516018 | 2020-09-09 | Breckinridge | Kentucky | 21027 | 106 | 2 |
516120 | 516120 | 2020-09-09 | Wayne | Kentucky | 21231 | 106 | 0 |
493452 | 493452 | 2020-09-02 | McCreary | Kentucky | 21147 | 106 | 0 |
467593 | 467593 | 2020-08-25 | Mercer | Kentucky | 21167 | 106 | 1 |
461093 | 461093 | 2020-08-23 | Green | Kentucky | 21087 | 106 | 5 |
425592 | 425592 | 2020-08-12 | Floyd | Kentucky | 21071 | 106 | 2 |
419182 | 419182 | 2020-08-10 | Lincoln | Kentucky | 21137 | 106 | 2 |
409497 | 409497 | 2020-08-07 | Greenup | Kentucky | 21089 | 106 | 1 |
406263 | 406263 | 2020-08-06 | Edmonson | Kentucky | 21061 | 106 | 12 |
403045 | 403045 | 2020-08-05 | Edmonson | Kentucky | 21061 | 106 | 12 |
399838 | 399838 | 2020-08-04 | Grant | Kentucky | 21081 | 106 | 5 |
387036 | 387036 | 2020-07-31 | Russell | Kentucky | 21207 | 106 | 5 |
380615 | 380615 | 2020-07-29 | Whitley | Kentucky | 21235 | 106 | 1 |
364556 | 364556 | 2020-07-24 | Woodford | Kentucky | 21239 | 106 | 0 |
345239 | 345239 | 2020-07-18 | Carroll | Kentucky | 21041 | 106 | 2 |
338832 | 338832 | 2020-07-16 | Boyd | Kentucky | 21019 | 106 | 3 |
335723 | 335723 | 2020-07-15 | Perry | Kentucky | 21193 | 106 | 2 |
332494 | 332494 | 2020-07-14 | Knox | Kentucky | 21121 | 106 | 5 |
288113 | 288113 | 2020-06-30 | Jessamine | Kentucky | 21113 | 106 | 0 |
284964 | 284964 | 2020-06-29 | Jessamine | Kentucky | 21113 | 106 | 0 |
272395 | 272395 | 2020-06-25 | Madison | Kentucky | 21151 | 106 | 1 |
250437 | 250437 | 2020-06-18 | Adair | Kentucky | 21001 | 106 | 19 |
200926 | 200926 | 2020-06-02 | Hardin | Kentucky | 21093 | 106 | 2 |
62794 | 62794 | 2020-04-16 | Daviess | Kentucky | 21059 | 106 | 3 |
57389 | 57389 | 2020-04-14 | Kenton | Kentucky | 21117 | 106 | 10 |
22459 | 22459 | 2020-03-31 | Fayette | Kentucky | 21067 | 106 | 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);