ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 66 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
749533 | 749533 | 2020-11-20 | Robertson | Kentucky | 21201 | 66 | 2 |
658615 | 658615 | 2020-10-23 | Bracken | Kentucky | 21023 | 66 | 1 |
642381 | 642381 | 2020-10-18 | Ballard | Kentucky | 21007 | 66 | 1 |
639134 | 639134 | 2020-10-17 | Ballard | Kentucky | 21007 | 66 | 1 |
606780 | 606780 | 2020-10-07 | Menifee | Kentucky | 21165 | 66 | 1 |
593816 | 593816 | 2020-10-03 | Morgan | Kentucky | 21175 | 66 | 0 |
574395 | 574395 | 2020-09-27 | Trimble | Kentucky | 21223 | 66 | 0 |
564624 | 564624 | 2020-09-24 | Leslie | Kentucky | 21131 | 66 | 0 |
561384 | 561384 | 2020-09-23 | Leslie | Kentucky | 21131 | 66 | 0 |
558154 | 558154 | 2020-09-22 | Lyon | Kentucky | 21143 | 66 | 4 |
554917 | 554917 | 2020-09-21 | Lyon | Kentucky | 21143 | 66 | 4 |
551678 | 551678 | 2020-09-20 | Lyon | Kentucky | 21143 | 66 | 4 |
548439 | 548439 | 2020-09-19 | Lyon | Kentucky | 21143 | 66 | 4 |
532266 | 532266 | 2020-09-14 | McLean | Kentucky | 21149 | 66 | 0 |
528968 | 528968 | 2020-09-13 | Carlisle | Kentucky | 21039 | 66 | 1 |
529029 | 529029 | 2020-09-13 | McLean | Kentucky | 21149 | 66 | 0 |
525732 | 525732 | 2020-09-12 | Carlisle | Kentucky | 21039 | 66 | 1 |
525793 | 525793 | 2020-09-12 | McLean | Kentucky | 21149 | 66 | 0 |
522489 | 522489 | 2020-09-11 | Breathitt | Kentucky | 21025 | 66 | 0 |
522496 | 522496 | 2020-09-11 | Carlisle | Kentucky | 21039 | 66 | 1 |
522522 | 522522 | 2020-09-11 | Hancock | Kentucky | 21091 | 66 | 0 |
522557 | 522557 | 2020-09-11 | McLean | Kentucky | 21149 | 66 | 0 |
519252 | 519252 | 2020-09-10 | Breathitt | Kentucky | 21025 | 66 | 0 |
519272 | 519272 | 2020-09-10 | Estill | Kentucky | 21065 | 66 | 0 |
519285 | 519285 | 2020-09-10 | Hancock | Kentucky | 21091 | 66 | 0 |
519309 | 519309 | 2020-09-10 | Livingston | Kentucky | 21139 | 66 | 1 |
519320 | 519320 | 2020-09-10 | McLean | Kentucky | 21149 | 66 | 0 |
496701 | 496701 | 2020-09-03 | Pendleton | Kentucky | 21191 | 66 | 0 |
490144 | 490144 | 2020-09-01 | Bath | Kentucky | 21011 | 66 | 1 |
486958 | 486958 | 2020-08-31 | Hickman | Kentucky | 21105 | 66 | 0 |
483723 | 483723 | 2020-08-30 | Hickman | Kentucky | 21105 | 66 | 0 |
480489 | 480489 | 2020-08-29 | Hickman | Kentucky | 21105 | 66 | 0 |
477256 | 477256 | 2020-08-28 | Hickman | Kentucky | 21105 | 66 | 0 |
477277 | 477277 | 2020-08-28 | Magoffin | Kentucky | 21153 | 66 | 0 |
474023 | 474023 | 2020-08-27 | Hickman | Kentucky | 21105 | 66 | 0 |
470791 | 470791 | 2020-08-26 | Hickman | Kentucky | 21105 | 66 | 0 |
467562 | 467562 | 2020-08-25 | Hickman | Kentucky | 21105 | 66 | 0 |
461116 | 461116 | 2020-08-23 | Letcher | Kentucky | 21133 | 66 | 2 |
457889 | 457889 | 2020-08-22 | Letcher | Kentucky | 21133 | 66 | 2 |
454661 | 454661 | 2020-08-21 | Letcher | Kentucky | 21133 | 66 | 2 |
451433 | 451433 | 2020-08-20 | Letcher | Kentucky | 21133 | 66 | 2 |
448205 | 448205 | 2020-08-19 | Letcher | Kentucky | 21133 | 66 | 2 |
444978 | 444978 | 2020-08-18 | Letcher | Kentucky | 21133 | 66 | 1 |
432037 | 432037 | 2020-08-14 | Cumberland | Kentucky | 21057 | 66 | 0 |
425614 | 425614 | 2020-08-12 | Johnson | Kentucky | 21115 | 66 | 0 |
425616 | 425616 | 2020-08-12 | Knott | Kentucky | 21119 | 66 | 1 |
425641 | 425641 | 2020-08-12 | Metcalfe | Kentucky | 21169 | 66 | 2 |
409568 | 409568 | 2020-08-07 | Wayne | Kentucky | 21231 | 66 | 0 |
403129 | 403129 | 2020-08-05 | Washington | Kentucky | 21229 | 66 | 0 |
380506 | 380506 | 2020-07-29 | Bourbon | Kentucky | 21017 | 66 | 1 |
361265 | 361265 | 2020-07-23 | Floyd | Kentucky | 21071 | 66 | 1 |
322918 | 322918 | 2020-07-11 | Grant | Kentucky | 21081 | 66 | 5 |
316599 | 316599 | 2020-07-09 | Marshall | Kentucky | 21157 | 66 | 2 |
313388 | 313388 | 2020-07-08 | Gallatin | Kentucky | 21077 | 66 | 8 |
313425 | 313425 | 2020-07-08 | Marshall | Kentucky | 21157 | 66 | 2 |
288117 | 288117 | 2020-06-30 | Knox | Kentucky | 21121 | 66 | 0 |
275514 | 275514 | 2020-06-26 | Harrison | Kentucky | 21097 | 66 | 0 |
272371 | 272371 | 2020-06-25 | Harrison | Kentucky | 21097 | 66 | 0 |
259815 | 259815 | 2020-06-21 | Calloway | Kentucky | 21035 | 66 | 1 |
256775 | 256775 | 2020-06-20 | Scott | Kentucky | 21209 | 66 | 0 |
244216 | 244216 | 2020-06-16 | Barren | Kentucky | 21009 | 66 | 2 |
241105 | 241105 | 2020-06-15 | Barren | Kentucky | 21009 | 66 | 2 |
140258 | 140258 | 2020-05-13 | Unknown | Kentucky | 66 | 0 | |
82167 | 82167 | 2020-04-23 | Campbell | Kentucky | 21037 | 66 | 7 |
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);