ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 79 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Gallatin 7
- Edmonson 6
- Carlisle 5
- Magoffin 5
- Bath 4
- Letcher 4
- Calloway 3
- Adair 2
- Caldwell 2
- Carter 2
- Crittenden 2
- Grant 2
- Hancock 2
- Harrison 2
- Henderson 2
- Jessamine 2
- Livingston 2
- Marion 2
- McLean 2
- Robertson 2
- Union 2
- Webster 2
- Ballard 1
- Bracken 1
- Breckinridge 1
- Bullitt 1
- Campbell 1
- Clark 1
- Clay 1
- Clinton 1
- …
state 1
- Kentucky · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
775498 | 775498 | 2020-11-28 | Robertson | Kentucky | 21201 | 79 | 2 |
772253 | 772253 | 2020-11-27 | Robertson | Kentucky | 21201 | 79 | 2 |
700780 | 700780 | 2020-11-05 | Bracken | Kentucky | 21023 | 79 | 1 |
684554 | 684554 | 2020-10-31 | Ballard | Kentucky | 21007 | 79 | 1 |
632750 | 632750 | 2020-10-15 | Trimble | Kentucky | 21223 | 79 | 0 |
580786 | 580786 | 2020-09-29 | Carlisle | Kentucky | 21039 | 79 | 1 |
580832 | 580832 | 2020-09-29 | Leslie | Kentucky | 21131 | 79 | 0 |
577545 | 577545 | 2020-09-28 | Carlisle | Kentucky | 21039 | 79 | 1 |
574303 | 574303 | 2020-09-27 | Carlisle | Kentucky | 21039 | 79 | 1 |
574364 | 574364 | 2020-09-27 | McLean | Kentucky | 21149 | 79 | 0 |
571060 | 571060 | 2020-09-26 | Carlisle | Kentucky | 21039 | 79 | 1 |
571121 | 571121 | 2020-09-26 | McLean | Kentucky | 21149 | 79 | 0 |
567818 | 567818 | 2020-09-25 | Carlisle | Kentucky | 21039 | 79 | 1 |
564604 | 564604 | 2020-09-24 | Hancock | Kentucky | 21091 | 79 | 0 |
561364 | 561364 | 2020-09-23 | Hancock | Kentucky | 21091 | 79 | 0 |
554851 | 554851 | 2020-09-21 | Bath | Kentucky | 21011 | 79 | 1 |
551612 | 551612 | 2020-09-20 | Bath | Kentucky | 21011 | 79 | 1 |
548373 | 548373 | 2020-09-19 | Bath | Kentucky | 21011 | 79 | 1 |
548441 | 548441 | 2020-09-19 | Magoffin | Kentucky | 21153 | 79 | 0 |
545135 | 545135 | 2020-09-18 | Bath | Kentucky | 21011 | 79 | 1 |
545199 | 545199 | 2020-09-18 | Livingston | Kentucky | 21139 | 79 | 1 |
545203 | 545203 | 2020-09-18 | Magoffin | Kentucky | 21153 | 79 | 0 |
541963 | 541963 | 2020-09-17 | Livingston | Kentucky | 21139 | 79 | 1 |
541967 | 541967 | 2020-09-17 | Magoffin | Kentucky | 21153 | 79 | 0 |
538731 | 538731 | 2020-09-16 | Magoffin | Kentucky | 21153 | 79 | 0 |
535494 | 535494 | 2020-09-15 | Magoffin | Kentucky | 21153 | 79 | 0 |
512798 | 512798 | 2020-09-08 | Clinton | Kentucky | 21053 | 79 | 2 |
512838 | 512838 | 2020-09-08 | Letcher | Kentucky | 21133 | 79 | 2 |
509606 | 509606 | 2020-09-07 | Letcher | Kentucky | 21133 | 79 | 2 |
506334 | 506334 | 2020-09-06 | Crittenden | Kentucky | 21055 | 79 | 1 |
506373 | 506373 | 2020-09-06 | Letcher | Kentucky | 21133 | 79 | 2 |
503100 | 503100 | 2020-09-05 | Crittenden | Kentucky | 21055 | 79 | 1 |
503139 | 503139 | 2020-09-05 | Letcher | Kentucky | 21133 | 79 | 2 |
486922 | 486922 | 2020-08-31 | Caldwell | Kentucky | 21033 | 79 | 0 |
483687 | 483687 | 2020-08-30 | Caldwell | Kentucky | 21033 | 79 | 0 |
474064 | 474064 | 2020-08-27 | Owen | Kentucky | 21187 | 79 | 0 |
470818 | 470818 | 2020-08-26 | McCreary | Kentucky | 21147 | 79 | 0 |
467587 | 467587 | 2020-08-25 | Mason | Kentucky | 21161 | 79 | 2 |
461162 | 461162 | 2020-08-23 | Union | Kentucky | 21225 | 79 | 0 |
457935 | 457935 | 2020-08-22 | Union | Kentucky | 21225 | 79 | 0 |
441745 | 441745 | 2020-08-17 | Knott | Kentucky | 21119 | 79 | 1 |
428794 | 428794 | 2020-08-13 | Breckinridge | Kentucky | 21027 | 79 | 2 |
419153 | 419153 | 2020-08-10 | Garrard | Kentucky | 21079 | 79 | 0 |
412710 | 412710 | 2020-08-08 | Fulton | Kentucky | 21075 | 79 | 2 |
412711 | 412711 | 2020-08-08 | Gallatin | Kentucky | 21077 | 79 | 7 |
409491 | 409491 | 2020-08-07 | Gallatin | Kentucky | 21077 | 79 | 7 |
403053 | 403053 | 2020-08-05 | Gallatin | Kentucky | 21077 | 79 | 8 |
399836 | 399836 | 2020-08-04 | Gallatin | Kentucky | 21077 | 79 | 8 |
396621 | 396621 | 2020-08-03 | Gallatin | Kentucky | 21077 | 79 | 8 |
393405 | 393405 | 2020-08-02 | Gallatin | Kentucky | 21077 | 79 | 8 |
390188 | 390188 | 2020-08-01 | Gallatin | Kentucky | 21077 | 79 | 8 |
390266 | 390266 | 2020-08-01 | Webster | Kentucky | 21233 | 79 | 1 |
387049 | 387049 | 2020-07-31 | Webster | Kentucky | 21233 | 79 | 1 |
370939 | 370939 | 2020-07-26 | Monroe | Kentucky | 21171 | 79 | 2 |
367665 | 367665 | 2020-07-25 | Carter | Kentucky | 21043 | 79 | 1 |
364458 | 364458 | 2020-07-24 | Carter | Kentucky | 21043 | 79 | 1 |
354862 | 354862 | 2020-07-21 | Grant | Kentucky | 21081 | 79 | 5 |
351660 | 351660 | 2020-07-20 | Grant | Kentucky | 21081 | 79 | 5 |
351728 | 351728 | 2020-07-20 | Taylor | Kentucky | 21217 | 79 | 1 |
348494 | 348494 | 2020-07-19 | Marion | Kentucky | 21155 | 79 | 0 |
345293 | 345293 | 2020-07-18 | Marion | Kentucky | 21155 | 79 | 0 |
313375 | 313375 | 2020-07-08 | Clay | Kentucky | 21051 | 79 | 3 |
310228 | 310228 | 2020-07-07 | Harrison | Kentucky | 21097 | 79 | 0 |
307060 | 307060 | 2020-07-06 | Harrison | Kentucky | 21097 | 79 | 0 |
284925 | 284925 | 2020-06-29 | Calloway | Kentucky | 21035 | 79 | 1 |
281779 | 281779 | 2020-06-28 | Calloway | Kentucky | 21035 | 79 | 1 |
281792 | 281792 | 2020-06-28 | Edmonson | Kentucky | 21061 | 79 | 11 |
278631 | 278631 | 2020-06-27 | Calloway | Kentucky | 21035 | 79 | 1 |
278644 | 278644 | 2020-06-27 | Edmonson | Kentucky | 21061 | 79 | 11 |
275496 | 275496 | 2020-06-26 | Edmonson | Kentucky | 21061 | 79 | 11 |
275528 | 275528 | 2020-06-26 | Laurel | Kentucky | 21125 | 79 | 3 |
272353 | 272353 | 2020-06-25 | Edmonson | Kentucky | 21061 | 79 | 11 |
272426 | 272426 | 2020-06-25 | Scott | Kentucky | 21209 | 79 | 0 |
269217 | 269217 | 2020-06-24 | Edmonson | Kentucky | 21061 | 79 | 11 |
266084 | 266084 | 2020-06-23 | Edmonson | Kentucky | 21061 | 79 | 11 |
250461 | 250461 | 2020-06-18 | Clark | Kentucky | 21049 | 79 | 0 |
231836 | 231836 | 2020-06-12 | Jessamine | Kentucky | 21113 | 79 | 0 |
228732 | 228732 | 2020-06-11 | Jessamine | Kentucky | 21113 | 79 | 0 |
125212 | 125212 | 2020-05-08 | Bullitt | Kentucky | 21029 | 79 | 3 |
125246 | 125246 | 2020-05-08 | Henderson | Kentucky | 21101 | 79 | 2 |
122264 | 122264 | 2020-05-07 | Henderson | Kentucky | 21101 | 79 | 2 |
110566 | 110566 | 2020-05-03 | Grayson | Kentucky | 21085 | 79 | 5 |
99078 | 99078 | 2020-04-29 | Adair | Kentucky | 21001 | 79 | 10 |
96232 | 96232 | 2020-04-28 | Adair | Kentucky | 21001 | 79 | 10 |
90595 | 90595 | 2020-04-26 | Campbell | Kentucky | 21037 | 79 | 7 |
46685 | 46685 | 2020-04-10 | Daviess | Kentucky | 21059 | 79 | 2 |
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);