ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 173 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
973462 | 973462 | 2021-01-28 | Robertson | Kentucky | 21201 | 173 | 10 |
775488 | 775488 | 2020-11-28 | Nicholas | Kentucky | 21181 | 173 | 3 |
759265 | 759265 | 2020-11-23 | Owen | Kentucky | 21187 | 173 | 3 |
752772 | 752772 | 2020-11-21 | Owen | Kentucky | 21187 | 173 | 3 |
746225 | 746225 | 2020-11-19 | Gallatin | Kentucky | 21077 | 173 | 9 |
742978 | 742978 | 2020-11-18 | Gallatin | Kentucky | 21077 | 173 | 8 |
713829 | 713829 | 2020-11-09 | Morgan | Kentucky | 21175 | 173 | 0 |
713837 | 713837 | 2020-11-09 | Pendleton | Kentucky | 21191 | 173 | 1 |
710585 | 710585 | 2020-11-08 | Morgan | Kentucky | 21175 | 173 | 0 |
707341 | 707341 | 2020-11-07 | Morgan | Kentucky | 21175 | 173 | 0 |
691067 | 691067 | 2020-11-02 | Crittenden | Kentucky | 21055 | 173 | 1 |
687822 | 687822 | 2020-11-01 | Crittenden | Kentucky | 21055 | 173 | 1 |
684578 | 684578 | 2020-10-31 | Crittenden | Kentucky | 21055 | 173 | 1 |
661924 | 661924 | 2020-10-24 | Martin | Kentucky | 21159 | 173 | 3 |
661928 | 661928 | 2020-10-24 | McLean | Kentucky | 21149 | 173 | 2 |
658684 | 658684 | 2020-10-23 | McLean | Kentucky | 21149 | 173 | 2 |
639144 | 639144 | 2020-10-17 | Breckinridge | Kentucky | 21027 | 173 | 2 |
600250 | 600250 | 2020-10-05 | Fulton | Kentucky | 21075 | 173 | 3 |
587279 | 587279 | 2020-10-01 | Estill | Kentucky | 21065 | 173 | 0 |
587313 | 587313 | 2020-10-01 | Letcher | Kentucky | 21133 | 173 | 2 |
584047 | 584047 | 2020-09-30 | Grant | Kentucky | 21081 | 173 | 6 |
574394 | 574394 | 2020-09-27 | Trigg | Kentucky | 21221 | 173 | 0 |
571151 | 571151 | 2020-09-26 | Trigg | Kentucky | 21221 | 173 | 0 |
567820 | 567820 | 2020-09-25 | Carter | Kentucky | 21043 | 173 | 3 |
554881 | 554881 | 2020-09-21 | Floyd | Kentucky | 21071 | 173 | 2 |
551615 | 551615 | 2020-09-20 | Bourbon | Kentucky | 21017 | 173 | 1 |
548376 | 548376 | 2020-09-19 | Bourbon | Kentucky | 21017 | 173 | 1 |
545138 | 545138 | 2020-09-18 | Bourbon | Kentucky | 21017 | 173 | 1 |
522528 | 522528 | 2020-09-11 | Henry | Kentucky | 21103 | 173 | 2 |
519291 | 519291 | 2020-09-10 | Henry | Kentucky | 21103 | 173 | 2 |
512857 | 512857 | 2020-09-08 | Monroe | Kentucky | 21171 | 173 | 3 |
509625 | 509625 | 2020-09-07 | Monroe | Kentucky | 21171 | 173 | 3 |
506392 | 506392 | 2020-09-06 | Monroe | Kentucky | 21171 | 173 | 3 |
503180 | 503180 | 2020-09-05 | Spencer | Kentucky | 21215 | 173 | 0 |
499947 | 499947 | 2020-09-04 | Spencer | Kentucky | 21215 | 173 | 0 |
474045 | 474045 | 2020-08-27 | Marion | Kentucky | 21155 | 173 | 2 |
461167 | 461167 | 2020-08-23 | Whitley | Kentucky | 21235 | 173 | 1 |
457940 | 457940 | 2020-08-22 | Whitley | Kentucky | 21235 | 173 | 1 |
454670 | 454670 | 2020-08-21 | Marshall | Kentucky | 21157 | 173 | 2 |
454712 | 454712 | 2020-08-21 | Whitley | Kentucky | 21235 | 173 | 1 |
448256 | 448256 | 2020-08-19 | Whitley | Kentucky | 21235 | 173 | 1 |
445029 | 445029 | 2020-08-18 | Whitley | Kentucky | 21235 | 173 | 1 |
367733 | 367733 | 2020-07-25 | Nelson | Kentucky | 21179 | 173 | 2 |
361327 | 361327 | 2020-07-23 | Pike | Kentucky | 21195 | 173 | 3 |
342019 | 342019 | 2020-07-17 | Adair | Kentucky | 21001 | 173 | 19 |
326075 | 326075 | 2020-07-12 | Bullitt | Kentucky | 21029 | 173 | 4 |
326153 | 326153 | 2020-07-12 | Oldham | Kentucky | 21185 | 173 | 7 |
322892 | 322892 | 2020-07-11 | Bullitt | Kentucky | 21029 | 173 | 4 |
238033 | 238033 | 2020-06-14 | Graves | Kentucky | 21083 | 173 | 20 |
234926 | 234926 | 2020-06-13 | Graves | Kentucky | 21083 | 173 | 20 |
194756 | 194756 | 2020-05-31 | Campbell | Kentucky | 21037 | 173 | 11 |
191688 | 191688 | 2020-05-30 | Campbell | Kentucky | 21037 | 173 | 11 |
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);