ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9 rows where cases = 4531 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Kentucky · 9 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217581 | 2217581 | 2022-02-15 | Powell | Kentucky | 21197 | 4531 | 32 |
2087373 | 2087373 | 2022-01-06 | Allen | Kentucky | 21003 | 4531 | 83 |
1989922 | 1989922 | 2021-12-07 | Lincoln | Kentucky | 21137 | 4531 | 105 |
1697432 | 1697432 | 2021-09-08 | Clay | Kentucky | 21051 | 4531 | 50 |
1343530 | 1343530 | 2021-05-22 | Hopkins | Kentucky | 21107 | 4531 | 147 |
1223448 | 1223448 | 2021-04-15 | Shelby | Kentucky | 21211 | 4531 | 69 |
1220200 | 1220200 | 2021-04-14 | Shelby | Kentucky | 21211 | 4531 | 69 |
1168247 | 1168247 | 2021-03-29 | Whitley | Kentucky | 21235 | 4531 | 46 |
1051349 | 1051349 | 2021-02-21 | Nelson | Kentucky | 21179 | 4531 | 33 |
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);