ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where cases = 282 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
889074 | 889074 | 2021-01-02 | Nicholas | Kentucky | 21181 | 282 | 3 |
846892 | 846892 | 2020-12-20 | Owsley | Kentucky | 21189 | 282 | 8 |
811186 | 811186 | 2020-12-09 | Owen | Kentucky | 21187 | 282 | 3 |
778708 | 778708 | 2020-11-29 | Leslie | Kentucky | 21131 | 282 | 1 |
762454 | 762454 | 2020-11-24 | Fulton | Kentucky | 21075 | 282 | 3 |
635906 | 635906 | 2020-10-16 | Carter | Kentucky | 21043 | 282 | 4 |
632647 | 632647 | 2020-10-15 | Bourbon | Kentucky | 21017 | 282 | 1 |
596993 | 596993 | 2020-10-04 | Casey | Kentucky | 21045 | 282 | 16 |
597074 | 597074 | 2020-10-04 | Russell | Kentucky | 21207 | 282 | 6 |
584050 | 584050 | 2020-09-30 | Green | Kentucky | 21087 | 282 | 9 |
584126 | 584126 | 2020-09-30 | Woodford | Kentucky | 21239 | 282 | 0 |
574370 | 574370 | 2020-09-27 | Montgomery | Kentucky | 21173 | 282 | 3 |
571051 | 571051 | 2020-09-26 | Boyle | Kentucky | 21021 | 282 | 0 |
554963 | 554963 | 2020-09-21 | Whitley | Kentucky | 21235 | 282 | 2 |
522501 | 522501 | 2020-09-11 | Clark | Kentucky | 21049 | 282 | 8 |
509540 | 509540 | 2020-09-07 | Adair | Kentucky | 21001 | 282 | 19 |
506307 | 506307 | 2020-09-06 | Adair | Kentucky | 21001 | 282 | 19 |
503073 | 503073 | 2020-09-05 | Adair | Kentucky | 21001 | 282 | 19 |
499840 | 499840 | 2020-09-04 | Adair | Kentucky | 21001 | 282 | 19 |
477300 | 477300 | 2020-08-28 | Perry | Kentucky | 21193 | 282 | 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);