ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 304 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2051643 | 2051643 | 2021-12-26 | Daviess | Kentucky | 21059 | 19679 | 304 |
2048393 | 2048393 | 2021-12-25 | Daviess | Kentucky | 21059 | 19679 | 304 |
2045143 | 2045143 | 2021-12-24 | Daviess | Kentucky | 21059 | 19679 | 304 |
2041894 | 2041894 | 2021-12-23 | Daviess | Kentucky | 21059 | 19679 | 304 |
2038644 | 2038644 | 2021-12-22 | Daviess | Kentucky | 21059 | 19679 | 304 |
2035394 | 2035394 | 2021-12-21 | Daviess | Kentucky | 21059 | 19595 | 304 |
2032144 | 2032144 | 2021-12-20 | Daviess | Kentucky | 21059 | 19553 | 304 |
1268836 | 1268836 | 2021-04-29 | Fayette | Kentucky | 21067 | 35268 | 304 |
1265589 | 1265589 | 2021-04-28 | Fayette | Kentucky | 21067 | 35226 | 304 |
1262342 | 1262342 | 2021-04-27 | Fayette | Kentucky | 21067 | 35170 | 304 |
1259095 | 1259095 | 2021-04-26 | Fayette | Kentucky | 21067 | 35117 | 304 |
1255848 | 1255848 | 2021-04-25 | Fayette | Kentucky | 21067 | 35103 | 304 |
1252601 | 1252601 | 2021-04-24 | Fayette | Kentucky | 21067 | 35076 | 304 |
1249354 | 1249354 | 2021-04-23 | Fayette | Kentucky | 21067 | 35035 | 304 |
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);