ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 189 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Kentucky · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324840 | 2324840 | 2022-03-20 | Harlan | Kentucky | 21095 | 9159 | 189 |
2321586 | 2321586 | 2022-03-19 | Harlan | Kentucky | 21095 | 9159 | 189 |
2318332 | 2318332 | 2022-03-18 | Harlan | Kentucky | 21095 | 9159 | 189 |
2315079 | 2315079 | 2022-03-17 | Harlan | Kentucky | 21095 | 9159 | 189 |
2311826 | 2311826 | 2022-03-16 | Harlan | Kentucky | 21095 | 9159 | 189 |
2308573 | 2308573 | 2022-03-15 | Harlan | Kentucky | 21095 | 9159 | 189 |
2305322 | 2305322 | 2022-03-14 | Harlan | Kentucky | 21095 | 9159 | 189 |
2168753 | 2168753 | 2022-01-31 | Laurel | Kentucky | 21125 | 16271 | 189 |
2165498 | 2165498 | 2022-01-30 | Laurel | Kentucky | 21125 | 15984 | 189 |
2162243 | 2162243 | 2022-01-29 | Laurel | Kentucky | 21125 | 15984 | 189 |
2158988 | 2158988 | 2022-01-28 | Laurel | Kentucky | 21125 | 15984 | 189 |
2129648 | 2129648 | 2022-01-19 | Barren | Kentucky | 21009 | 10393 | 189 |
2126394 | 2126394 | 2022-01-18 | Barren | Kentucky | 21009 | 10251 | 189 |
1928167 | 1928167 | 2021-11-18 | Madison | Kentucky | 21151 | 16421 | 189 |
1905445 | 1905445 | 2021-11-11 | Pike | Kentucky | 21195 | 10910 | 189 |
1902195 | 1902195 | 2021-11-10 | Pike | Kentucky | 21195 | 10910 | 189 |
1898945 | 1898945 | 2021-11-09 | Pike | Kentucky | 21195 | 10880 | 189 |
1895695 | 1895695 | 2021-11-08 | Pike | Kentucky | 21195 | 10860 | 189 |
1677957 | 1677957 | 2021-09-02 | Hardin | Kentucky | 21093 | 13822 | 189 |
1674710 | 1674710 | 2021-09-01 | Hardin | Kentucky | 21093 | 13634 | 189 |
1671461 | 1671461 | 2021-08-31 | Hardin | Kentucky | 21093 | 13437 | 189 |
1551342 | 1551342 | 2021-07-25 | Warren | Kentucky | 21227 | 16675 | 189 |
1548095 | 1548095 | 2021-07-24 | Warren | Kentucky | 21227 | 16675 | 189 |
1544848 | 1544848 | 2021-07-23 | Warren | Kentucky | 21227 | 16675 | 189 |
1541600 | 1541600 | 2021-07-22 | Warren | Kentucky | 21227 | 16644 | 189 |
1538353 | 1538353 | 2021-07-21 | Warren | Kentucky | 21227 | 16607 | 189 |
1535105 | 1535105 | 2021-07-20 | Warren | Kentucky | 21227 | 16569 | 189 |
1372723 | 1372723 | 2021-05-31 | Daviess | Kentucky | 21059 | 10911 | 189 |
1369478 | 1369478 | 2021-05-30 | Daviess | Kentucky | 21059 | 10911 | 189 |
1366232 | 1366232 | 2021-05-29 | Daviess | Kentucky | 21059 | 10911 | 189 |
966906 | 966906 | 2021-01-26 | Fayette | Kentucky | 21067 | 28845 | 189 |
228731 | 228731 | 2020-06-11 | Jefferson | Kentucky | 21111 | 3229 | 189 |
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);