ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 162 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
743033 | 743033 | 2020-11-18 | Owen | Kentucky | 21187 | 162 | 3 |
710503 | 710503 | 2020-11-08 | Bath | Kentucky | 21011 | 162 | 1 |
707259 | 707259 | 2020-11-07 | Bath | Kentucky | 21011 | 162 | 1 |
704080 | 704080 | 2020-11-06 | Livingston | Kentucky | 21139 | 162 | 1 |
697537 | 697537 | 2020-11-04 | Breathitt | Kentucky | 21025 | 162 | 1 |
668364 | 668364 | 2020-10-26 | Crittenden | Kentucky | 21055 | 162 | 1 |
665120 | 665120 | 2020-10-25 | Crittenden | Kentucky | 21055 | 162 | 1 |
661875 | 661875 | 2020-10-24 | Crittenden | Kentucky | 21055 | 162 | 1 |
629408 | 629408 | 2020-10-14 | Breckinridge | Kentucky | 21027 | 162 | 2 |
590545 | 590545 | 2020-10-02 | Johnson | Kentucky | 21115 | 162 | 2 |
587304 | 587304 | 2020-10-01 | Johnson | Kentucky | 21115 | 162 | 2 |
587308 | 587308 | 2020-10-01 | Larue | Kentucky | 21123 | 162 | 1 |
567839 | 567839 | 2020-09-25 | Grant | Kentucky | 21081 | 162 | 6 |
554956 | 554956 | 2020-09-21 | Trigg | Kentucky | 21221 | 162 | 0 |
551717 | 551717 | 2020-09-20 | Trigg | Kentucky | 21221 | 162 | 0 |
532221 | 532221 | 2020-09-14 | Floyd | Kentucky | 21071 | 162 | 2 |
528984 | 528984 | 2020-09-13 | Floyd | Kentucky | 21071 | 162 | 2 |
525748 | 525748 | 2020-09-12 | Floyd | Kentucky | 21071 | 162 | 2 |
525796 | 525796 | 2020-09-12 | Mercer | Kentucky | 21167 | 162 | 1 |
522512 | 522512 | 2020-09-11 | Floyd | Kentucky | 21071 | 162 | 2 |
512881 | 512881 | 2020-09-08 | Todd | Kentucky | 21219 | 162 | 6 |
509649 | 509649 | 2020-09-07 | Todd | Kentucky | 21219 | 162 | 6 |
499925 | 499925 | 2020-09-04 | Monroe | Kentucky | 21171 | 162 | 3 |
496657 | 496657 | 2020-09-03 | Henry | Kentucky | 21103 | 162 | 2 |
490190 | 490190 | 2020-09-01 | Henry | Kentucky | 21103 | 162 | 2 |
486957 | 486957 | 2020-08-31 | Henry | Kentucky | 21103 | 162 | 2 |
483722 | 483722 | 2020-08-30 | Henry | Kentucky | 21103 | 162 | 2 |
483738 | 483738 | 2020-08-30 | Lewis | Kentucky | 21135 | 162 | 10 |
470846 | 470846 | 2020-08-26 | Spencer | Kentucky | 21215 | 162 | 0 |
406350 | 406350 | 2020-08-06 | Whitley | Kentucky | 21235 | 162 | 1 |
399822 | 399822 | 2020-08-04 | Clark | Kentucky | 21049 | 162 | 7 |
370901 | 370901 | 2020-07-26 | Harlan | Kentucky | 21095 | 162 | 3 |
370914 | 370914 | 2020-07-26 | Knox | Kentucky | 21121 | 162 | 8 |
361319 | 361319 | 2020-07-23 | Nelson | Kentucky | 21179 | 162 | 2 |
354864 | 354864 | 2020-07-21 | Grayson | Kentucky | 21085 | 162 | 11 |
272324 | 272324 | 2020-06-25 | Allen | Kentucky | 21003 | 162 | 5 |
188646 | 188646 | 2020-05-29 | Graves | Kentucky | 21083 | 162 | 19 |
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);