ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 217 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Kentucky · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393123 | 2393123 | 2022-04-10 | Barren | Kentucky | 21009 | 12984 | 217 |
2389867 | 2389867 | 2022-04-09 | Barren | Kentucky | 21009 | 12984 | 217 |
2386611 | 2386611 | 2022-04-08 | Barren | Kentucky | 21009 | 12984 | 217 |
2383356 | 2383356 | 2022-04-07 | Barren | Kentucky | 21009 | 12984 | 217 |
2380101 | 2380101 | 2022-04-06 | Barren | Kentucky | 21009 | 12984 | 217 |
2376846 | 2376846 | 2022-04-05 | Barren | Kentucky | 21009 | 12984 | 217 |
2373594 | 2373594 | 2022-04-04 | Barren | Kentucky | 21009 | 12984 | 217 |
2009458 | 2009458 | 2021-12-13 | Pulaski | Kentucky | 21199 | 12242 | 217 |
2006207 | 2006207 | 2021-12-12 | Pulaski | Kentucky | 21199 | 12242 | 217 |
2002956 | 2002956 | 2021-12-11 | Pulaski | Kentucky | 21199 | 12242 | 217 |
1999706 | 1999706 | 2021-12-10 | Pulaski | Kentucky | 21199 | 12242 | 217 |
1993158 | 1993158 | 2021-12-08 | Hopkins | Kentucky | 21107 | 9117 | 217 |
1989861 | 1989861 | 2021-12-07 | Boone | Kentucky | 21015 | 23384 | 217 |
1989907 | 1989907 | 2021-12-07 | Hopkins | Kentucky | 21107 | 9097 | 217 |
1986611 | 1986611 | 2021-12-06 | Boone | Kentucky | 21015 | 23317 | 217 |
1986657 | 1986657 | 2021-12-06 | Hopkins | Kentucky | 21107 | 9067 | 217 |
1733253 | 1733253 | 2021-09-19 | Warren | Kentucky | 21227 | 23118 | 217 |
1730003 | 1730003 | 2021-09-18 | Warren | Kentucky | 21227 | 23118 | 217 |
1726753 | 1726753 | 2021-09-17 | Warren | Kentucky | 21227 | 23118 | 217 |
1690939 | 1690939 | 2021-09-06 | Daviess | Kentucky | 21059 | 14096 | 217 |
1687689 | 1687689 | 2021-09-05 | Daviess | Kentucky | 21059 | 14096 | 217 |
1684439 | 1684439 | 2021-09-04 | Daviess | Kentucky | 21059 | 14096 | 217 |
1681188 | 1681188 | 2021-09-03 | Daviess | Kentucky | 21059 | 14096 | 217 |
1677940 | 1677940 | 2021-09-02 | Daviess | Kentucky | 21059 | 13983 | 217 |
1674693 | 1674693 | 2021-09-01 | Daviess | Kentucky | 21059 | 13867 | 217 |
1671444 | 1671444 | 2021-08-31 | Daviess | Kentucky | 21059 | 13763 | 217 |
1031820 | 1031820 | 2021-02-15 | Fayette | Kentucky | 21067 | 31526 | 217 |
307067 | 307067 | 2020-07-06 | Jefferson | Kentucky | 21111 | 4173 | 217 |
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);