ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
289 rows where deaths = 70 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500581 | 2500581 | 2022-05-13 | Anderson | Kentucky | 21005 | 6620 | 70 |
2497323 | 2497323 | 2022-05-12 | Anderson | Kentucky | 21005 | 6620 | 70 |
2494065 | 2494065 | 2022-05-11 | Anderson | Kentucky | 21005 | 6620 | 70 |
2490807 | 2490807 | 2022-05-10 | Anderson | Kentucky | 21005 | 6620 | 70 |
2487550 | 2487550 | 2022-05-09 | Anderson | Kentucky | 21005 | 6620 | 70 |
2461540 | 2461540 | 2022-05-01 | Harrison | Kentucky | 21097 | 6396 | 70 |
2458284 | 2458284 | 2022-04-30 | Harrison | Kentucky | 21097 | 6396 | 70 |
2455028 | 2455028 | 2022-04-29 | Harrison | Kentucky | 21097 | 6396 | 70 |
2451772 | 2451772 | 2022-04-28 | Harrison | Kentucky | 21097 | 6396 | 70 |
2448516 | 2448516 | 2022-04-27 | Harrison | Kentucky | 21097 | 6396 | 70 |
2445260 | 2445260 | 2022-04-26 | Harrison | Kentucky | 21097 | 6396 | 70 |
2442004 | 2442004 | 2022-04-25 | Harrison | Kentucky | 21097 | 6396 | 70 |
2393180 | 2393180 | 2022-04-10 | Larue | Kentucky | 21123 | 3720 | 70 |
2389924 | 2389924 | 2022-04-09 | Larue | Kentucky | 21123 | 3720 | 70 |
2386668 | 2386668 | 2022-04-08 | Larue | Kentucky | 21123 | 3720 | 70 |
2383413 | 2383413 | 2022-04-07 | Larue | Kentucky | 21123 | 3720 | 70 |
2380158 | 2380158 | 2022-04-06 | Larue | Kentucky | 21123 | 3720 | 70 |
2376903 | 2376903 | 2022-04-05 | Larue | Kentucky | 21123 | 3720 | 70 |
2373651 | 2373651 | 2022-04-04 | Larue | Kentucky | 21123 | 3720 | 70 |
2256534 | 2256534 | 2022-02-27 | Garrard | Kentucky | 21079 | 4695 | 70 |
2253283 | 2253283 | 2022-02-26 | Garrard | Kentucky | 21079 | 4695 | 70 |
2250032 | 2250032 | 2022-02-25 | Garrard | Kentucky | 21079 | 4695 | 70 |
2233823 | 2233823 | 2022-02-20 | Monroe | Kentucky | 21171 | 3554 | 70 |
2230572 | 2230572 | 2022-02-19 | Monroe | Kentucky | 21171 | 3554 | 70 |
2227321 | 2227321 | 2022-02-18 | Monroe | Kentucky | 21171 | 3554 | 70 |
2224070 | 2224070 | 2022-02-17 | Monroe | Kentucky | 21171 | 3549 | 70 |
2220819 | 2220819 | 2022-02-16 | Monroe | Kentucky | 21171 | 3540 | 70 |
2217568 | 2217568 | 2022-02-15 | Monroe | Kentucky | 21171 | 3526 | 70 |
2214317 | 2214317 | 2022-02-14 | Monroe | Kentucky | 21171 | 3521 | 70 |
2211065 | 2211065 | 2022-02-13 | Monroe | Kentucky | 21171 | 3490 | 70 |
2207812 | 2207812 | 2022-02-12 | Monroe | Kentucky | 21171 | 3490 | 70 |
2204559 | 2204559 | 2022-02-11 | Monroe | Kentucky | 21171 | 3490 | 70 |
2201306 | 2201306 | 2022-02-10 | Monroe | Kentucky | 21171 | 3485 | 70 |
2198052 | 2198052 | 2022-02-09 | Monroe | Kentucky | 21171 | 3477 | 70 |
2194798 | 2194798 | 2022-02-08 | Monroe | Kentucky | 21171 | 3471 | 70 |
2191538 | 2191538 | 2022-02-07 | McCreary | Kentucky | 21147 | 4640 | 70 |
2191544 | 2191544 | 2022-02-07 | Monroe | Kentucky | 21171 | 3464 | 70 |
2165461 | 2165461 | 2022-01-30 | Clay | Kentucky | 21051 | 6530 | 70 |
2162206 | 2162206 | 2022-01-29 | Clay | Kentucky | 21051 | 6530 | 70 |
2158951 | 2158951 | 2022-01-28 | Clay | Kentucky | 21051 | 6530 | 70 |
2155697 | 2155697 | 2022-01-27 | Clay | Kentucky | 21051 | 6390 | 70 |
2152444 | 2152444 | 2022-01-26 | Clay | Kentucky | 21051 | 6254 | 70 |
2149192 | 2149192 | 2022-01-25 | Clay | Kentucky | 21051 | 6185 | 70 |
2145940 | 2145940 | 2022-01-24 | Clay | Kentucky | 21051 | 6125 | 70 |
2106897 | 2106897 | 2022-01-12 | Calloway | Kentucky | 21035 | 6147 | 70 |
2103646 | 2103646 | 2022-01-11 | Calloway | Kentucky | 21035 | 6038 | 70 |
2100395 | 2100395 | 2022-01-10 | Calloway | Kentucky | 21035 | 5983 | 70 |
2097144 | 2097144 | 2022-01-09 | Calloway | Kentucky | 21035 | 5888 | 70 |
2097194 | 2097194 | 2022-01-09 | Lewis | Kentucky | 21135 | 3247 | 70 |
2093892 | 2093892 | 2022-01-08 | Calloway | Kentucky | 21035 | 5888 | 70 |
2093942 | 2093942 | 2022-01-08 | Lewis | Kentucky | 21135 | 3247 | 70 |
2090640 | 2090640 | 2022-01-07 | Calloway | Kentucky | 21035 | 5888 | 70 |
2090690 | 2090690 | 2022-01-07 | Lewis | Kentucky | 21135 | 3247 | 70 |
2087389 | 2087389 | 2022-01-06 | Calloway | Kentucky | 21035 | 5839 | 70 |
2087439 | 2087439 | 2022-01-06 | Lewis | Kentucky | 21135 | 3223 | 70 |
2084137 | 2084137 | 2022-01-05 | Calloway | Kentucky | 21035 | 5807 | 70 |
2080885 | 2080885 | 2022-01-04 | Calloway | Kentucky | 21035 | 5768 | 70 |
2077633 | 2077633 | 2022-01-03 | Calloway | Kentucky | 21035 | 5720 | 70 |
2074382 | 2074382 | 2022-01-02 | Calloway | Kentucky | 21035 | 5625 | 70 |
2071131 | 2071131 | 2022-01-01 | Calloway | Kentucky | 21035 | 5625 | 70 |
2067880 | 2067880 | 2021-12-31 | Calloway | Kentucky | 21035 | 5625 | 70 |
2064629 | 2064629 | 2021-12-30 | Calloway | Kentucky | 21035 | 5625 | 70 |
2061379 | 2061379 | 2021-12-29 | Calloway | Kentucky | 21035 | 5625 | 70 |
2058130 | 2058130 | 2021-12-28 | Calloway | Kentucky | 21035 | 5603 | 70 |
2054881 | 2054881 | 2021-12-27 | Calloway | Kentucky | 21035 | 5572 | 70 |
2035471 | 2035471 | 2021-12-21 | Simpson | Kentucky | 21213 | 3663 | 70 |
2032201 | 2032201 | 2021-12-20 | Montgomery | Kentucky | 21173 | 4949 | 70 |
2032219 | 2032219 | 2021-12-20 | Scott | Kentucky | 21209 | 9689 | 70 |
1983375 | 1983375 | 2021-12-05 | Carter | Kentucky | 21043 | 4946 | 70 |
1980125 | 1980125 | 2021-12-04 | Carter | Kentucky | 21043 | 4946 | 70 |
1976875 | 1976875 | 2021-12-03 | Carter | Kentucky | 21043 | 4946 | 70 |
1973626 | 1973626 | 2021-12-02 | Carter | Kentucky | 21043 | 4920 | 70 |
1973720 | 1973720 | 2021-12-02 | Wayne | Kentucky | 21231 | 3715 | 70 |
1970376 | 1970376 | 2021-12-01 | Carter | Kentucky | 21043 | 4893 | 70 |
1928096 | 1928096 | 2021-11-18 | Allen | Kentucky | 21003 | 3881 | 70 |
1924846 | 1924846 | 2021-11-17 | Allen | Kentucky | 21003 | 3876 | 70 |
1921597 | 1921597 | 2021-11-16 | Allen | Kentucky | 21003 | 3873 | 70 |
1918347 | 1918347 | 2021-11-15 | Allen | Kentucky | 21003 | 3865 | 70 |
1915097 | 1915097 | 2021-11-14 | Allen | Kentucky | 21003 | 3858 | 70 |
1915173 | 1915173 | 2021-11-14 | Mason | Kentucky | 21161 | 2629 | 70 |
1911847 | 1911847 | 2021-11-13 | Allen | Kentucky | 21003 | 3858 | 70 |
1911923 | 1911923 | 2021-11-13 | Mason | Kentucky | 21161 | 2629 | 70 |
1908598 | 1908598 | 2021-11-12 | Allen | Kentucky | 21003 | 3858 | 70 |
1908674 | 1908674 | 2021-11-12 | Mason | Kentucky | 21161 | 2629 | 70 |
1905349 | 1905349 | 2021-11-11 | Allen | Kentucky | 21003 | 3851 | 70 |
1905425 | 1905425 | 2021-11-11 | Mason | Kentucky | 21161 | 2618 | 70 |
1902099 | 1902099 | 2021-11-10 | Allen | Kentucky | 21003 | 3851 | 70 |
1902175 | 1902175 | 2021-11-10 | Mason | Kentucky | 21161 | 2618 | 70 |
1898849 | 1898849 | 2021-11-09 | Allen | Kentucky | 21003 | 3844 | 70 |
1898914 | 1898914 | 2021-11-09 | Letcher | Kentucky | 21133 | 3988 | 70 |
1895599 | 1895599 | 2021-11-08 | Allen | Kentucky | 21003 | 3837 | 70 |
1895664 | 1895664 | 2021-11-08 | Letcher | Kentucky | 21133 | 3975 | 70 |
1892349 | 1892349 | 2021-11-07 | Allen | Kentucky | 21003 | 3836 | 70 |
1892414 | 1892414 | 2021-11-07 | Letcher | Kentucky | 21133 | 3965 | 70 |
1889099 | 1889099 | 2021-11-06 | Allen | Kentucky | 21003 | 3836 | 70 |
1889164 | 1889164 | 2021-11-06 | Letcher | Kentucky | 21133 | 3965 | 70 |
1885849 | 1885849 | 2021-11-05 | Allen | Kentucky | 21003 | 3836 | 70 |
1885914 | 1885914 | 2021-11-05 | Letcher | Kentucky | 21133 | 3965 | 70 |
1882600 | 1882600 | 2021-11-04 | Allen | Kentucky | 21003 | 3831 | 70 |
1879351 | 1879351 | 2021-11-03 | Allen | Kentucky | 21003 | 3825 | 70 |
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);