ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where cases = 28 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 |
---|---|---|---|---|---|---|---|
671679 | 671679 | 2020-10-27 | Robertson | Kentucky | 21201 | 28 | 1 |
506425 | 506425 | 2020-09-06 | Wolfe | Kentucky | 21237 | 28 | 0 |
499958 | 499958 | 2020-09-04 | Wolfe | Kentucky | 21237 | 28 | 0 |
496724 | 496724 | 2020-09-03 | Wolfe | Kentucky | 21237 | 28 | 0 |
493404 | 493404 | 2020-09-02 | Elliott | Kentucky | 21063 | 28 | 0 |
467542 | 467542 | 2020-08-25 | Estill | Kentucky | 21065 | 28 | 0 |
461082 | 461082 | 2020-08-23 | Estill | Kentucky | 21065 | 28 | 0 |
461132 | 461132 | 2020-08-23 | Menifee | Kentucky | 21165 | 28 | 0 |
457855 | 457855 | 2020-08-22 | Estill | Kentucky | 21065 | 28 | 0 |
457905 | 457905 | 2020-08-22 | Menifee | Kentucky | 21165 | 28 | 0 |
454627 | 454627 | 2020-08-21 | Estill | Kentucky | 21065 | 28 | 0 |
454677 | 454677 | 2020-08-21 | Menifee | Kentucky | 21165 | 28 | 0 |
451399 | 451399 | 2020-08-20 | Estill | Kentucky | 21065 | 28 | 0 |
451449 | 451449 | 2020-08-20 | Menifee | Kentucky | 21165 | 28 | 0 |
448221 | 448221 | 2020-08-19 | Menifee | Kentucky | 21165 | 28 | 0 |
444994 | 444994 | 2020-08-18 | Menifee | Kentucky | 21165 | 28 | 0 |
441768 | 441768 | 2020-08-17 | Menifee | Kentucky | 21165 | 28 | 0 |
438541 | 438541 | 2020-08-16 | Menifee | Kentucky | 21165 | 28 | 0 |
435316 | 435316 | 2020-08-15 | Menifee | Kentucky | 21165 | 28 | 0 |
432091 | 432091 | 2020-08-14 | Menifee | Kentucky | 21165 | 28 | 0 |
428863 | 428863 | 2020-08-13 | Menifee | Kentucky | 21165 | 28 | 0 |
425639 | 425639 | 2020-08-12 | Menifee | Kentucky | 21165 | 28 | 0 |
422418 | 422418 | 2020-08-11 | Menifee | Kentucky | 21165 | 28 | 0 |
419196 | 419196 | 2020-08-10 | Menifee | Kentucky | 21165 | 28 | 0 |
415975 | 415975 | 2020-08-09 | Menifee | Kentucky | 21165 | 28 | 0 |
412685 | 412685 | 2020-08-08 | Breathitt | Kentucky | 21025 | 28 | 0 |
412755 | 412755 | 2020-08-08 | Menifee | Kentucky | 21165 | 28 | 0 |
409465 | 409465 | 2020-08-07 | Breathitt | Kentucky | 21025 | 28 | 0 |
409518 | 409518 | 2020-08-07 | Leslie | Kentucky | 21131 | 28 | 0 |
409535 | 409535 | 2020-08-07 | Menifee | Kentucky | 21165 | 28 | 0 |
406245 | 406245 | 2020-08-06 | Breathitt | Kentucky | 21025 | 28 | 0 |
406260 | 406260 | 2020-08-06 | Crittenden | Kentucky | 21055 | 28 | 1 |
406298 | 406298 | 2020-08-06 | Leslie | Kentucky | 21131 | 28 | 0 |
403027 | 403027 | 2020-08-05 | Breathitt | Kentucky | 21025 | 28 | 0 |
403080 | 403080 | 2020-08-05 | Leslie | Kentucky | 21131 | 28 | 0 |
390237 | 390237 | 2020-08-01 | Morgan | Kentucky | 21175 | 28 | 0 |
387020 | 387020 | 2020-07-31 | Morgan | Kentucky | 21175 | 28 | 0 |
383726 | 383726 | 2020-07-30 | Bracken | Kentucky | 21023 | 28 | 0 |
383797 | 383797 | 2020-07-30 | Menifee | Kentucky | 21165 | 28 | 0 |
383802 | 383802 | 2020-07-30 | Morgan | Kentucky | 21175 | 28 | 0 |
380509 | 380509 | 2020-07-29 | Bracken | Kentucky | 21023 | 28 | 0 |
380569 | 380569 | 2020-07-29 | Lyon | Kentucky | 21143 | 28 | 4 |
380577 | 380577 | 2020-07-29 | McCreary | Kentucky | 21147 | 28 | 0 |
380585 | 380585 | 2020-07-29 | Morgan | Kentucky | 21175 | 28 | 0 |
380609 | 380609 | 2020-07-29 | Trimble | Kentucky | 21223 | 28 | 0 |
377284 | 377284 | 2020-07-28 | Ballard | Kentucky | 21007 | 28 | 0 |
377292 | 377292 | 2020-07-28 | Bracken | Kentucky | 21023 | 28 | 0 |
377352 | 377352 | 2020-07-28 | Lyon | Kentucky | 21143 | 28 | 4 |
377357 | 377357 | 2020-07-28 | Martin | Kentucky | 21159 | 28 | 0 |
377360 | 377360 | 2020-07-28 | McCreary | Kentucky | 21147 | 28 | 0 |
377368 | 377368 | 2020-07-28 | Morgan | Kentucky | 21175 | 28 | 0 |
374069 | 374069 | 2020-07-27 | Ballard | Kentucky | 21007 | 28 | 0 |
374137 | 374137 | 2020-07-27 | Lyon | Kentucky | 21143 | 28 | 3 |
374150 | 374150 | 2020-07-27 | Metcalfe | Kentucky | 21169 | 28 | 2 |
374153 | 374153 | 2020-07-27 | Morgan | Kentucky | 21175 | 28 | 0 |
370857 | 370857 | 2020-07-26 | Ballard | Kentucky | 21007 | 28 | 0 |
370859 | 370859 | 2020-07-26 | Bath | Kentucky | 21011 | 28 | 1 |
370941 | 370941 | 2020-07-26 | Morgan | Kentucky | 21175 | 28 | 0 |
370947 | 370947 | 2020-07-26 | Owen | Kentucky | 21187 | 28 | 0 |
367647 | 367647 | 2020-07-25 | Ballard | Kentucky | 21007 | 28 | 0 |
367737 | 367737 | 2020-07-25 | Owen | Kentucky | 21187 | 28 | 0 |
364440 | 364440 | 2020-07-24 | Ballard | Kentucky | 21007 | 28 | 0 |
364530 | 364530 | 2020-07-24 | Owen | Kentucky | 21187 | 28 | 0 |
361296 | 361296 | 2020-07-23 | Letcher | Kentucky | 21133 | 28 | 0 |
361299 | 361299 | 2020-07-23 | Livingston | Kentucky | 21139 | 28 | 0 |
361325 | 361325 | 2020-07-23 | Pendleton | Kentucky | 21191 | 28 | 0 |
358120 | 358120 | 2020-07-22 | Pendleton | Kentucky | 21191 | 28 | 0 |
354881 | 354881 | 2020-07-21 | Knott | Kentucky | 21119 | 28 | 0 |
354917 | 354917 | 2020-07-21 | Pendleton | Kentucky | 21191 | 28 | 0 |
351715 | 351715 | 2020-07-20 | Pendleton | Kentucky | 21191 | 28 | 0 |
351729 | 351729 | 2020-07-20 | Todd | Kentucky | 21219 | 28 | 0 |
348515 | 348515 | 2020-07-19 | Pendleton | Kentucky | 21191 | 28 | 0 |
348529 | 348529 | 2020-07-19 | Todd | Kentucky | 21219 | 28 | 0 |
329284 | 329284 | 2020-07-13 | Fulton | Kentucky | 21075 | 28 | 1 |
326098 | 326098 | 2020-07-12 | Fulton | Kentucky | 21075 | 28 | 1 |
326141 | 326141 | 2020-07-12 | McLean | Kentucky | 21149 | 28 | 0 |
326170 | 326170 | 2020-07-12 | Todd | Kentucky | 21219 | 28 | 0 |
322958 | 322958 | 2020-07-11 | McLean | Kentucky | 21149 | 28 | 0 |
322987 | 322987 | 2020-07-11 | Todd | Kentucky | 21219 | 28 | 0 |
322988 | 322988 | 2020-07-11 | Trigg | Kentucky | 21221 | 28 | 0 |
316537 | 316537 | 2020-07-09 | Breckinridge | Kentucky | 21027 | 28 | 2 |
316638 | 316638 | 2020-07-09 | Washington | Kentucky | 21229 | 28 | 0 |
313363 | 313363 | 2020-07-08 | Breckinridge | Kentucky | 21027 | 28 | 2 |
313464 | 313464 | 2020-07-08 | Washington | Kentucky | 21229 | 28 | 0 |
310193 | 310193 | 2020-07-07 | Breckinridge | Kentucky | 21027 | 28 | 2 |
307025 | 307025 | 2020-07-06 | Breckinridge | Kentucky | 21027 | 28 | 2 |
307051 | 307051 | 2020-07-06 | Garrard | Kentucky | 21079 | 28 | 0 |
303926 | 303926 | 2020-07-05 | Meade | Kentucky | 21163 | 28 | 2 |
300762 | 300762 | 2020-07-04 | Meade | Kentucky | 21163 | 28 | 2 |
297600 | 297600 | 2020-07-03 | Meade | Kentucky | 21163 | 28 | 2 |
294442 | 294442 | 2020-07-02 | Meade | Kentucky | 21163 | 28 | 2 |
291251 | 291251 | 2020-07-01 | Greenup | Kentucky | 21089 | 28 | 0 |
291275 | 291275 | 2020-07-01 | Lincoln | Kentucky | 21137 | 28 | 1 |
291324 | 291324 | 2020-07-01 | Whitley | Kentucky | 21235 | 28 | 0 |
288101 | 288101 | 2020-06-30 | Greenup | Kentucky | 21089 | 28 | 0 |
288125 | 288125 | 2020-06-30 | Lincoln | Kentucky | 21137 | 28 | 1 |
288173 | 288173 | 2020-06-30 | Whitley | Kentucky | 21235 | 28 | 0 |
284952 | 284952 | 2020-06-29 | Greenup | Kentucky | 21089 | 28 | 0 |
281806 | 281806 | 2020-06-28 | Greenup | Kentucky | 21089 | 28 | 0 |
278658 | 278658 | 2020-06-27 | Greenup | Kentucky | 21089 | 28 | 0 |
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);