ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 27 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 |
---|---|---|---|---|---|---|---|
629459 | 629459 | 2020-10-14 | Lee | Kentucky | 21129 | 27 | 0 |
516095 | 516095 | 2020-09-09 | Nicholas | Kentucky | 21181 | 27 | 1 |
512862 | 512862 | 2020-09-08 | Nicholas | Kentucky | 21181 | 27 | 1 |
509630 | 509630 | 2020-09-07 | Nicholas | Kentucky | 21181 | 27 | 1 |
506397 | 506397 | 2020-09-06 | Nicholas | Kentucky | 21181 | 27 | 1 |
503163 | 503163 | 2020-09-05 | Nicholas | Kentucky | 21181 | 27 | 1 |
499930 | 499930 | 2020-09-04 | Nicholas | Kentucky | 21181 | 27 | 1 |
493491 | 493491 | 2020-09-02 | Wolfe | Kentucky | 21237 | 27 | 0 |
490257 | 490257 | 2020-09-01 | Wolfe | Kentucky | 21237 | 27 | 0 |
487024 | 487024 | 2020-08-31 | Wolfe | Kentucky | 21237 | 27 | 0 |
483789 | 483789 | 2020-08-30 | Wolfe | Kentucky | 21237 | 27 | 0 |
474089 | 474089 | 2020-08-27 | Wolfe | Kentucky | 21237 | 27 | 0 |
470857 | 470857 | 2020-08-26 | Wolfe | Kentucky | 21237 | 27 | 0 |
464399 | 464399 | 2020-08-24 | Wolfe | Kentucky | 21237 | 27 | 0 |
448171 | 448171 | 2020-08-19 | Estill | Kentucky | 21065 | 27 | 0 |
444944 | 444944 | 2020-08-18 | Estill | Kentucky | 21065 | 27 | 0 |
441718 | 441718 | 2020-08-17 | Estill | Kentucky | 21065 | 27 | 0 |
438491 | 438491 | 2020-08-16 | Estill | Kentucky | 21065 | 27 | 0 |
435266 | 435266 | 2020-08-15 | Estill | Kentucky | 21065 | 27 | 0 |
432041 | 432041 | 2020-08-14 | Estill | Kentucky | 21065 | 27 | 0 |
428813 | 428813 | 2020-08-13 | Estill | Kentucky | 21065 | 27 | 0 |
425589 | 425589 | 2020-08-12 | Estill | Kentucky | 21065 | 27 | 0 |
422368 | 422368 | 2020-08-11 | Estill | Kentucky | 21065 | 27 | 0 |
399863 | 399863 | 2020-08-04 | Leslie | Kentucky | 21131 | 27 | 0 |
377392 | 377392 | 2020-07-28 | Trimble | Kentucky | 21223 | 27 | 0 |
374077 | 374077 | 2020-07-27 | Bracken | Kentucky | 21023 | 27 | 0 |
374129 | 374129 | 2020-07-27 | Lawrence | Kentucky | 21127 | 27 | 0 |
374145 | 374145 | 2020-07-27 | McCreary | Kentucky | 21147 | 27 | 0 |
374177 | 374177 | 2020-07-27 | Trimble | Kentucky | 21223 | 27 | 0 |
370865 | 370865 | 2020-07-26 | Bracken | Kentucky | 21023 | 27 | 0 |
370917 | 370917 | 2020-07-26 | Lawrence | Kentucky | 21127 | 27 | 0 |
370925 | 370925 | 2020-07-26 | Lyon | Kentucky | 21143 | 27 | 3 |
370933 | 370933 | 2020-07-26 | McCreary | Kentucky | 21147 | 27 | 0 |
370965 | 370965 | 2020-07-26 | Trimble | Kentucky | 21223 | 27 | 0 |
367649 | 367649 | 2020-07-25 | Bath | Kentucky | 21011 | 27 | 1 |
367655 | 367655 | 2020-07-25 | Bracken | Kentucky | 21023 | 27 | 0 |
367731 | 367731 | 2020-07-25 | Morgan | Kentucky | 21175 | 27 | 0 |
367755 | 367755 | 2020-07-25 | Trimble | Kentucky | 21223 | 27 | 0 |
364504 | 364504 | 2020-07-24 | Lewis | Kentucky | 21135 | 27 | 0 |
364548 | 364548 | 2020-07-24 | Trimble | Kentucky | 21223 | 27 | 0 |
361297 | 361297 | 2020-07-23 | Lewis | Kentucky | 21135 | 27 | 0 |
358068 | 358068 | 2020-07-22 | Green | Kentucky | 21087 | 27 | 1 |
358084 | 358084 | 2020-07-22 | Knott | Kentucky | 21119 | 27 | 0 |
358094 | 358094 | 2020-07-22 | Livingston | Kentucky | 21139 | 27 | 0 |
354891 | 354891 | 2020-07-21 | Livingston | Kentucky | 21139 | 27 | 0 |
345328 | 345328 | 2020-07-18 | Todd | Kentucky | 21219 | 27 | 0 |
342128 | 342128 | 2020-07-17 | Todd | Kentucky | 21219 | 27 | 0 |
338932 | 338932 | 2020-07-16 | Todd | Kentucky | 21219 | 27 | 0 |
335736 | 335736 | 2020-07-15 | Todd | Kentucky | 21219 | 27 | 0 |
332543 | 332543 | 2020-07-14 | Todd | Kentucky | 21219 | 27 | 0 |
329356 | 329356 | 2020-07-13 | Todd | Kentucky | 21219 | 27 | 0 |
326106 | 326106 | 2020-07-12 | Hancock | Kentucky | 21091 | 27 | 0 |
322912 | 322912 | 2020-07-11 | Fleming | Kentucky | 21069 | 27 | 0 |
322915 | 322915 | 2020-07-11 | Fulton | Kentucky | 21075 | 27 | 1 |
319779 | 319779 | 2020-07-10 | McLean | Kentucky | 21149 | 27 | 0 |
319814 | 319814 | 2020-07-10 | Wayne | Kentucky | 21231 | 27 | 0 |
316604 | 316604 | 2020-07-09 | McLean | Kentucky | 21149 | 27 | 0 |
313430 | 313430 | 2020-07-08 | McLean | Kentucky | 21149 | 27 | 0 |
310260 | 310260 | 2020-07-07 | McLean | Kentucky | 21149 | 27 | 0 |
310281 | 310281 | 2020-07-07 | Rockcastle | Kentucky | 21203 | 27 | 0 |
310294 | 310294 | 2020-07-07 | Washington | Kentucky | 21229 | 27 | 0 |
307092 | 307092 | 2020-07-06 | McLean | Kentucky | 21149 | 27 | 0 |
307113 | 307113 | 2020-07-06 | Rockcastle | Kentucky | 21203 | 27 | 0 |
307126 | 307126 | 2020-07-06 | Washington | Kentucky | 21229 | 27 | 0 |
303892 | 303892 | 2020-07-05 | Harlan | Kentucky | 21095 | 27 | 2 |
303925 | 303925 | 2020-07-05 | McLean | Kentucky | 21149 | 27 | 0 |
300728 | 300728 | 2020-07-04 | Harlan | Kentucky | 21095 | 27 | 2 |
300761 | 300761 | 2020-07-04 | McLean | Kentucky | 21149 | 27 | 0 |
297566 | 297566 | 2020-07-03 | Harlan | Kentucky | 21095 | 27 | 2 |
297599 | 297599 | 2020-07-03 | McLean | Kentucky | 21149 | 27 | 0 |
294363 | 294363 | 2020-07-02 | Anderson | Kentucky | 21005 | 27 | 1 |
284943 | 284943 | 2020-06-29 | Floyd | Kentucky | 21071 | 27 | 0 |
285024 | 285024 | 2020-06-29 | Whitley | Kentucky | 21235 | 27 | 0 |
281797 | 281797 | 2020-06-28 | Floyd | Kentucky | 21071 | 27 | 0 |
278649 | 278649 | 2020-06-27 | Floyd | Kentucky | 21071 | 27 | 0 |
269195 | 269195 | 2020-06-24 | Bourbon | Kentucky | 21017 | 27 | 1 |
266062 | 266062 | 2020-06-23 | Bourbon | Kentucky | 21017 | 27 | 1 |
262929 | 262929 | 2020-06-22 | Anderson | Kentucky | 21005 | 27 | 1 |
262935 | 262935 | 2020-06-22 | Bourbon | Kentucky | 21017 | 27 | 1 |
259800 | 259800 | 2020-06-21 | Anderson | Kentucky | 21005 | 27 | 1 |
259806 | 259806 | 2020-06-21 | Bourbon | Kentucky | 21017 | 27 | 1 |
256674 | 256674 | 2020-06-20 | Anderson | Kentucky | 21005 | 27 | 1 |
256680 | 256680 | 2020-06-20 | Bourbon | Kentucky | 21017 | 27 | 1 |
253554 | 253554 | 2020-06-19 | Anderson | Kentucky | 21005 | 27 | 1 |
250439 | 250439 | 2020-06-18 | Anderson | Kentucky | 21005 | 27 | 1 |
250462 | 250462 | 2020-06-18 | Clay | Kentucky | 21051 | 27 | 3 |
247327 | 247327 | 2020-06-17 | Anderson | Kentucky | 21005 | 27 | 1 |
247376 | 247376 | 2020-06-17 | Henry | Kentucky | 21103 | 27 | 2 |
231865 | 231865 | 2020-06-12 | Monroe | Kentucky | 21171 | 27 | 0 |
228761 | 228761 | 2020-06-11 | Monroe | Kentucky | 21171 | 27 | 0 |
225659 | 225659 | 2020-06-10 | Monroe | Kentucky | 21171 | 27 | 0 |
222563 | 222563 | 2020-06-09 | Monroe | Kentucky | 21171 | 27 | 0 |
219468 | 219468 | 2020-06-08 | Monroe | Kentucky | 21171 | 27 | 0 |
207086 | 207086 | 2020-06-04 | Harrison | Kentucky | 21097 | 27 | 0 |
207112 | 207112 | 2020-06-04 | Marion | Kentucky | 21155 | 27 | 0 |
197926 | 197926 | 2020-06-01 | Woodford | Kentucky | 21239 | 27 | 0 |
194855 | 194855 | 2020-05-31 | Woodford | Kentucky | 21239 | 27 | 0 |
191787 | 191787 | 2020-05-30 | Woodford | Kentucky | 21239 | 27 | 0 |
188723 | 188723 | 2020-05-29 | Woodford | Kentucky | 21239 | 27 | 0 |
122254 | 122254 | 2020-05-07 | Grant | Kentucky | 21081 | 27 | 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);