ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 80 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
704022 | 704022 | 2020-11-06 | Bracken | Kentucky | 21023 | 80 | 1 |
661930 | 661930 | 2020-10-24 | Menifee | Kentucky | 21165 | 80 | 1 |
648980 | 648980 | 2020-10-20 | Trimble | Kentucky | 21223 | 80 | 0 |
639242 | 639242 | 2020-10-17 | Trimble | Kentucky | 21223 | 80 | 0 |
629485 | 629485 | 2020-10-14 | Nicholas | Kentucky | 21181 | 80 | 1 |
616486 | 616486 | 2020-10-10 | Lawrence | Kentucky | 21127 | 80 | 0 |
597042 | 597042 | 2020-10-04 | Lyon | Kentucky | 21143 | 80 | 4 |
593800 | 593800 | 2020-10-03 | Lyon | Kentucky | 21143 | 80 | 4 |
590540 | 590540 | 2020-10-02 | Hickman | Kentucky | 21105 | 80 | 1 |
590559 | 590559 | 2020-10-02 | Lyon | Kentucky | 21143 | 80 | 4 |
584026 | 584026 | 2020-09-30 | Carlisle | Kentucky | 21039 | 80 | 1 |
580843 | 580843 | 2020-09-29 | Martin | Kentucky | 21159 | 80 | 3 |
580847 | 580847 | 2020-09-29 | McLean | Kentucky | 21149 | 80 | 0 |
577606 | 577606 | 2020-09-28 | McLean | Kentucky | 21149 | 80 | 0 |
567844 | 567844 | 2020-09-25 | Hancock | Kentucky | 21091 | 80 | 0 |
561392 | 561392 | 2020-09-23 | Magoffin | Kentucky | 21153 | 80 | 0 |
558156 | 558156 | 2020-09-22 | Magoffin | Kentucky | 21153 | 80 | 0 |
554919 | 554919 | 2020-09-21 | Magoffin | Kentucky | 21153 | 80 | 0 |
551680 | 551680 | 2020-09-20 | Magoffin | Kentucky | 21153 | 80 | 0 |
516071 | 516071 | 2020-09-09 | Letcher | Kentucky | 21133 | 80 | 2 |
509567 | 509567 | 2020-09-07 | Crittenden | Kentucky | 21055 | 80 | 1 |
496704 | 496704 | 2020-09-03 | Powell | Kentucky | 21197 | 80 | 0 |
490232 | 490232 | 2020-09-01 | Owen | Kentucky | 21187 | 80 | 1 |
483764 | 483764 | 2020-08-30 | Owen | Kentucky | 21187 | 80 | 0 |
480530 | 480530 | 2020-08-29 | Owen | Kentucky | 21187 | 80 | 0 |
477297 | 477297 | 2020-08-28 | Owen | Kentucky | 21187 | 80 | 0 |
470816 | 470816 | 2020-08-26 | Mason | Kentucky | 21161 | 80 | 2 |
464309 | 464309 | 2020-08-24 | Cumberland | Kentucky | 21057 | 80 | 0 |
461078 | 461078 | 2020-08-23 | Cumberland | Kentucky | 21057 | 80 | 0 |
448223 | 448223 | 2020-08-19 | Metcalfe | Kentucky | 21169 | 80 | 2 |
445027 | 445027 | 2020-08-18 | Wayne | Kentucky | 21231 | 80 | 0 |
441801 | 441801 | 2020-08-17 | Wayne | Kentucky | 21231 | 80 | 0 |
438574 | 438574 | 2020-08-16 | Wayne | Kentucky | 21231 | 80 | 0 |
432022 | 432022 | 2020-08-14 | Breckinridge | Kentucky | 21027 | 80 | 2 |
432066 | 432066 | 2020-08-14 | Johnson | Kentucky | 21115 | 80 | 0 |
422375 | 422375 | 2020-08-11 | Garrard | Kentucky | 21079 | 80 | 0 |
419152 | 419152 | 2020-08-10 | Gallatin | Kentucky | 21077 | 80 | 7 |
415931 | 415931 | 2020-08-09 | Gallatin | Kentucky | 21077 | 80 | 7 |
412787 | 412787 | 2020-08-08 | Washington | Kentucky | 21229 | 80 | 0 |
409461 | 409461 | 2020-08-07 | Bourbon | Kentucky | 21017 | 80 | 1 |
406241 | 406241 | 2020-08-06 | Bourbon | Kentucky | 21017 | 80 | 1 |
406271 | 406271 | 2020-08-06 | Gallatin | Kentucky | 21077 | 80 | 8 |
406316 | 406316 | 2020-08-06 | Mercer | Kentucky | 21167 | 80 | 0 |
403017 | 403017 | 2020-08-05 | Anderson | Kentucky | 21005 | 80 | 1 |
403098 | 403098 | 2020-08-05 | Mercer | Kentucky | 21167 | 80 | 0 |
386968 | 386968 | 2020-07-31 | Floyd | Kentucky | 21071 | 80 | 1 |
383759 | 383759 | 2020-07-30 | Greenup | Kentucky | 21089 | 80 | 1 |
377332 | 377332 | 2020-07-28 | Henry | Kentucky | 21103 | 80 | 2 |
374087 | 374087 | 2020-07-27 | Carter | Kentucky | 21043 | 80 | 1 |
370875 | 370875 | 2020-07-26 | Carter | Kentucky | 21043 | 80 | 1 |
358065 | 358065 | 2020-07-22 | Grant | Kentucky | 21081 | 80 | 5 |
342105 | 342105 | 2020-07-17 | Montgomery | Kentucky | 21173 | 80 | 0 |
335730 | 335730 | 2020-07-15 | Russell | Kentucky | 21207 | 80 | 5 |
319818 | 319818 | 2020-07-10 | Woodford | Kentucky | 21239 | 80 | 0 |
316549 | 316549 | 2020-07-09 | Clay | Kentucky | 21051 | 80 | 3 |
307072 | 307072 | 2020-07-06 | Knox | Kentucky | 21121 | 80 | 0 |
300787 | 300787 | 2020-07-04 | Simpson | Kentucky | 21213 | 80 | 3 |
297625 | 297625 | 2020-07-03 | Simpson | Kentucky | 21213 | 80 | 3 |
253576 | 253576 | 2020-06-19 | Clark | Kentucky | 21049 | 80 | 0 |
225630 | 225630 | 2020-06-10 | Jessamine | Kentucky | 21113 | 80 | 0 |
146220 | 146220 | 2020-05-15 | McCracken | Kentucky | 21145 | 80 | 2 |
84953 | 84953 | 2020-04-24 | Adair | Kentucky | 21001 | 80 | 6 |
46706 | 46706 | 2020-04-10 | Kenton | Kentucky | 21117 | 80 | 8 |
44098 | 44098 | 2020-04-09 | Kenton | Kentucky | 21117 | 80 | 8 |
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);