ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 85 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
785234 | 785234 | 2020-12-01 | Robertson | Kentucky | 21201 | 85 | 3 |
658668 | 658668 | 2020-10-23 | Lee | Kentucky | 21129 | 85 | 2 |
632729 | 632729 | 2020-10-15 | Nicholas | Kentucky | 21181 | 85 | 1 |
613253 | 613253 | 2020-10-09 | Lyon | Kentucky | 21143 | 85 | 4 |
610027 | 610027 | 2020-10-08 | Morgan | Kentucky | 21175 | 85 | 0 |
600232 | 600232 | 2020-10-05 | Carlisle | Kentucky | 21039 | 85 | 1 |
590553 | 590553 | 2020-10-02 | Leslie | Kentucky | 21131 | 85 | 0 |
587281 | 587281 | 2020-10-01 | Fleming | Kentucky | 21069 | 85 | 0 |
587327 | 587327 | 2020-10-01 | McLean | Kentucky | 21149 | 85 | 0 |
584041 | 584041 | 2020-09-30 | Fleming | Kentucky | 21069 | 85 | 0 |
558152 | 558152 | 2020-09-22 | Livingston | Kentucky | 21139 | 85 | 1 |
525811 | 525811 | 2020-09-12 | Powell | Kentucky | 21197 | 85 | 0 |
522575 | 522575 | 2020-09-11 | Powell | Kentucky | 21197 | 85 | 0 |
519266 | 519266 | 2020-09-10 | Clinton | Kentucky | 21053 | 85 | 2 |
519338 | 519338 | 2020-09-10 | Powell | Kentucky | 21197 | 85 | 0 |
512865 | 512865 | 2020-09-08 | Owen | Kentucky | 21187 | 85 | 1 |
509633 | 509633 | 2020-09-07 | Owen | Kentucky | 21187 | 85 | 1 |
509638 | 509638 | 2020-09-07 | Powell | Kentucky | 21197 | 85 | 0 |
506400 | 506400 | 2020-09-06 | Owen | Kentucky | 21187 | 85 | 1 |
506405 | 506405 | 2020-09-06 | Powell | Kentucky | 21197 | 85 | 0 |
503166 | 503166 | 2020-09-05 | Owen | Kentucky | 21187 | 85 | 1 |
503171 | 503171 | 2020-09-05 | Powell | Kentucky | 21197 | 85 | 0 |
499933 | 499933 | 2020-09-04 | Owen | Kentucky | 21187 | 85 | 1 |
496622 | 496622 | 2020-09-03 | Caldwell | Kentucky | 21033 | 85 | 0 |
486990 | 486990 | 2020-08-31 | Metcalfe | Kentucky | 21169 | 85 | 2 |
483781 | 483781 | 2020-08-30 | Trigg | Kentucky | 21221 | 85 | 0 |
470767 | 470767 | 2020-08-26 | Cumberland | Kentucky | 21057 | 85 | 0 |
470823 | 470823 | 2020-08-26 | Metcalfe | Kentucky | 21169 | 85 | 2 |
461165 | 461165 | 2020-08-23 | Wayne | Kentucky | 21231 | 85 | 0 |
454633 | 454633 | 2020-08-21 | Gallatin | Kentucky | 21077 | 85 | 8 |
451405 | 451405 | 2020-08-20 | Gallatin | Kentucky | 21077 | 85 | 8 |
448177 | 448177 | 2020-08-19 | Gallatin | Kentucky | 21077 | 85 | 7 |
444950 | 444950 | 2020-08-18 | Gallatin | Kentucky | 21077 | 85 | 7 |
422373 | 422373 | 2020-08-11 | Fulton | Kentucky | 21075 | 85 | 2 |
415901 | 415901 | 2020-08-09 | Bourbon | Kentucky | 21017 | 85 | 1 |
416007 | 416007 | 2020-08-09 | Washington | Kentucky | 21229 | 85 | 0 |
403131 | 403131 | 2020-08-05 | Webster | Kentucky | 21233 | 85 | 1 |
377302 | 377302 | 2020-07-28 | Carter | Kentucky | 21043 | 85 | 1 |
358099 | 358099 | 2020-07-22 | Marion | Kentucky | 21155 | 85 | 0 |
354852 | 354852 | 2020-07-21 | Edmonson | Kentucky | 21061 | 85 | 12 |
351650 | 351650 | 2020-07-20 | Edmonson | Kentucky | 21061 | 85 | 12 |
329267 | 329267 | 2020-07-13 | Carroll | Kentucky | 21041 | 85 | 1 |
329272 | 329272 | 2020-07-13 | Clay | Kentucky | 21051 | 85 | 4 |
326081 | 326081 | 2020-07-12 | Carroll | Kentucky | 21041 | 85 | 1 |
294378 | 294378 | 2020-07-02 | Calloway | Kentucky | 21035 | 85 | 1 |
284912 | 284912 | 2020-06-29 | Barren | Kentucky | 21009 | 85 | 2 |
281824 | 281824 | 2020-06-28 | Laurel | Kentucky | 21125 | 85 | 3 |
253606 | 253606 | 2020-06-19 | Jackson | Kentucky | 21109 | 85 | 13 |
244268 | 244268 | 2020-06-16 | Jessamine | Kentucky | 21113 | 85 | 0 |
167358 | 167358 | 2020-05-22 | McCracken | Kentucky | 21145 | 85 | 2 |
164322 | 164322 | 2020-05-21 | McCracken | Kentucky | 21145 | 85 | 2 |
161293 | 161293 | 2020-05-20 | McCracken | Kentucky | 21145 | 85 | 2 |
158236 | 158236 | 2020-05-19 | Hardin | Kentucky | 21093 | 85 | 2 |
158267 | 158267 | 2020-05-19 | McCracken | Kentucky | 21145 | 85 | 2 |
155250 | 155250 | 2020-05-18 | McCracken | Kentucky | 21145 | 85 | 2 |
125285 | 125285 | 2020-05-08 | Ohio | Kentucky | 21183 | 85 | 0 |
96249 | 96249 | 2020-04-28 | Campbell | Kentucky | 21037 | 85 | 9 |
90600 | 90600 | 2020-04-26 | Christian | Kentucky | 21047 | 85 | 3 |
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);