ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
346 rows where deaths = 52 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500605 | 2500605 | 2022-05-13 | Clinton | Kentucky | 21053 | 3674 | 52 |
2500630 | 2500630 | 2022-05-13 | Henry | Kentucky | 21103 | 4836 | 52 |
2500643 | 2500643 | 2022-05-13 | Lee | Kentucky | 21129 | 2951 | 52 |
2497347 | 2497347 | 2022-05-12 | Clinton | Kentucky | 21053 | 3674 | 52 |
2497372 | 2497372 | 2022-05-12 | Henry | Kentucky | 21103 | 4836 | 52 |
2497385 | 2497385 | 2022-05-12 | Lee | Kentucky | 21129 | 2951 | 52 |
2494089 | 2494089 | 2022-05-11 | Clinton | Kentucky | 21053 | 3674 | 52 |
2494114 | 2494114 | 2022-05-11 | Henry | Kentucky | 21103 | 4836 | 52 |
2494127 | 2494127 | 2022-05-11 | Lee | Kentucky | 21129 | 2951 | 52 |
2490831 | 2490831 | 2022-05-10 | Clinton | Kentucky | 21053 | 3674 | 52 |
2490856 | 2490856 | 2022-05-10 | Henry | Kentucky | 21103 | 4836 | 52 |
2490869 | 2490869 | 2022-05-10 | Lee | Kentucky | 21129 | 2951 | 52 |
2487574 | 2487574 | 2022-05-09 | Clinton | Kentucky | 21053 | 3674 | 52 |
2487599 | 2487599 | 2022-05-09 | Henry | Kentucky | 21103 | 4836 | 52 |
2487612 | 2487612 | 2022-05-09 | Lee | Kentucky | 21129 | 2951 | 52 |
2484316 | 2484316 | 2022-05-08 | Clinton | Kentucky | 21053 | 3667 | 52 |
2484341 | 2484341 | 2022-05-08 | Henry | Kentucky | 21103 | 4807 | 52 |
2484354 | 2484354 | 2022-05-08 | Lee | Kentucky | 21129 | 2948 | 52 |
2481058 | 2481058 | 2022-05-07 | Clinton | Kentucky | 21053 | 3667 | 52 |
2481083 | 2481083 | 2022-05-07 | Henry | Kentucky | 21103 | 4807 | 52 |
2481096 | 2481096 | 2022-05-07 | Lee | Kentucky | 21129 | 2948 | 52 |
2477800 | 2477800 | 2022-05-06 | Clinton | Kentucky | 21053 | 3667 | 52 |
2477825 | 2477825 | 2022-05-06 | Henry | Kentucky | 21103 | 4807 | 52 |
2477838 | 2477838 | 2022-05-06 | Lee | Kentucky | 21129 | 2948 | 52 |
2474542 | 2474542 | 2022-05-05 | Clinton | Kentucky | 21053 | 3667 | 52 |
2474567 | 2474567 | 2022-05-05 | Henry | Kentucky | 21103 | 4807 | 52 |
2474580 | 2474580 | 2022-05-05 | Lee | Kentucky | 21129 | 2948 | 52 |
2471285 | 2471285 | 2022-05-04 | Clinton | Kentucky | 21053 | 3667 | 52 |
2471310 | 2471310 | 2022-05-04 | Henry | Kentucky | 21103 | 4807 | 52 |
2471323 | 2471323 | 2022-05-04 | Lee | Kentucky | 21129 | 2948 | 52 |
2468029 | 2468029 | 2022-05-03 | Clinton | Kentucky | 21053 | 3667 | 52 |
2468054 | 2468054 | 2022-05-03 | Henry | Kentucky | 21103 | 4807 | 52 |
2468067 | 2468067 | 2022-05-03 | Lee | Kentucky | 21129 | 2948 | 52 |
2464774 | 2464774 | 2022-05-02 | Clinton | Kentucky | 21053 | 3667 | 52 |
2464799 | 2464799 | 2022-05-02 | Henry | Kentucky | 21103 | 4807 | 52 |
2464812 | 2464812 | 2022-05-02 | Lee | Kentucky | 21129 | 2948 | 52 |
2324801 | 2324801 | 2022-03-20 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2321547 | 2321547 | 2022-03-19 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2318293 | 2318293 | 2022-03-18 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2315040 | 2315040 | 2022-03-17 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2311787 | 2311787 | 2022-03-16 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2308534 | 2308534 | 2022-03-15 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2305283 | 2305283 | 2022-03-14 | Bourbon | Kentucky | 21017 | 5933 | 52 |
2246844 | 2246844 | 2022-02-24 | Rowan | Kentucky | 21205 | 6288 | 52 |
2243593 | 2243593 | 2022-02-23 | Rowan | Kentucky | 21205 | 6288 | 52 |
2240342 | 2240342 | 2022-02-22 | Rowan | Kentucky | 21205 | 6265 | 52 |
2237091 | 2237091 | 2022-02-21 | Rowan | Kentucky | 21205 | 6245 | 52 |
2233840 | 2233840 | 2022-02-20 | Rowan | Kentucky | 21205 | 6194 | 52 |
2230589 | 2230589 | 2022-02-19 | Rowan | Kentucky | 21205 | 6194 | 52 |
2227338 | 2227338 | 2022-02-18 | Rowan | Kentucky | 21205 | 6194 | 52 |
2224087 | 2224087 | 2022-02-17 | Rowan | Kentucky | 21205 | 6162 | 52 |
2220836 | 2220836 | 2022-02-16 | Rowan | Kentucky | 21205 | 6141 | 52 |
2217585 | 2217585 | 2022-02-15 | Rowan | Kentucky | 21205 | 6112 | 52 |
2214334 | 2214334 | 2022-02-14 | Rowan | Kentucky | 21205 | 6090 | 52 |
2211082 | 2211082 | 2022-02-13 | Rowan | Kentucky | 21205 | 6013 | 52 |
2207829 | 2207829 | 2022-02-12 | Rowan | Kentucky | 21205 | 6013 | 52 |
2204576 | 2204576 | 2022-02-11 | Rowan | Kentucky | 21205 | 6013 | 52 |
2198036 | 2198036 | 2022-02-09 | Livingston | Kentucky | 21139 | 2159 | 52 |
2194782 | 2194782 | 2022-02-08 | Livingston | Kentucky | 21139 | 2144 | 52 |
2188265 | 2188265 | 2022-02-06 | Knott | Kentucky | 21119 | 3490 | 52 |
2188318 | 2188318 | 2022-02-06 | Union | Kentucky | 21225 | 4049 | 52 |
2185012 | 2185012 | 2022-02-05 | Knott | Kentucky | 21119 | 3490 | 52 |
2185065 | 2185065 | 2022-02-05 | Union | Kentucky | 21225 | 4049 | 52 |
2181760 | 2181760 | 2022-02-04 | Knott | Kentucky | 21119 | 3490 | 52 |
2181813 | 2181813 | 2022-02-04 | Union | Kentucky | 21225 | 4049 | 52 |
2178490 | 2178490 | 2022-02-03 | Grant | Kentucky | 21081 | 7127 | 52 |
2178509 | 2178509 | 2022-02-03 | Knott | Kentucky | 21119 | 3457 | 52 |
2178562 | 2178562 | 2022-02-03 | Union | Kentucky | 21225 | 4033 | 52 |
2175237 | 2175237 | 2022-02-02 | Grant | Kentucky | 21081 | 7102 | 52 |
2175256 | 2175256 | 2022-02-02 | Knott | Kentucky | 21119 | 3405 | 52 |
2175309 | 2175309 | 2022-02-02 | Union | Kentucky | 21225 | 4008 | 52 |
2171984 | 2171984 | 2022-02-01 | Grant | Kentucky | 21081 | 7008 | 52 |
2172003 | 2172003 | 2022-02-01 | Knott | Kentucky | 21119 | 3378 | 52 |
2172056 | 2172056 | 2022-02-01 | Union | Kentucky | 21225 | 3979 | 52 |
2168750 | 2168750 | 2022-01-31 | Knott | Kentucky | 21119 | 3326 | 52 |
2168803 | 2168803 | 2022-01-31 | Union | Kentucky | 21225 | 3951 | 52 |
2165495 | 2165495 | 2022-01-30 | Knott | Kentucky | 21119 | 3237 | 52 |
2165548 | 2165548 | 2022-01-30 | Union | Kentucky | 21225 | 3891 | 52 |
2162240 | 2162240 | 2022-01-29 | Knott | Kentucky | 21119 | 3237 | 52 |
2162293 | 2162293 | 2022-01-29 | Union | Kentucky | 21225 | 3891 | 52 |
2158985 | 2158985 | 2022-01-28 | Knott | Kentucky | 21119 | 3237 | 52 |
2159038 | 2159038 | 2022-01-28 | Union | Kentucky | 21225 | 3891 | 52 |
2155731 | 2155731 | 2022-01-27 | Knott | Kentucky | 21119 | 3179 | 52 |
2155735 | 2155735 | 2022-01-27 | Lawrence | Kentucky | 21127 | 3749 | 52 |
2155784 | 2155784 | 2022-01-27 | Union | Kentucky | 21225 | 3827 | 52 |
2152482 | 2152482 | 2022-01-26 | Lawrence | Kentucky | 21127 | 3716 | 52 |
2149230 | 2149230 | 2022-01-25 | Lawrence | Kentucky | 21127 | 3678 | 52 |
2145978 | 2145978 | 2022-01-24 | Lawrence | Kentucky | 21127 | 3623 | 52 |
2106961 | 2106961 | 2022-01-12 | Meade | Kentucky | 21163 | 4158 | 52 |
2097211 | 2097211 | 2022-01-09 | Metcalfe | Kentucky | 21169 | 2264 | 52 |
2097241 | 2097241 | 2022-01-09 | Washington | Kentucky | 21229 | 2845 | 52 |
2093959 | 2093959 | 2022-01-08 | Metcalfe | Kentucky | 21169 | 2264 | 52 |
2093989 | 2093989 | 2022-01-08 | Washington | Kentucky | 21229 | 2845 | 52 |
2090707 | 2090707 | 2022-01-07 | Metcalfe | Kentucky | 21169 | 2264 | 52 |
2090737 | 2090737 | 2022-01-07 | Washington | Kentucky | 21229 | 2845 | 52 |
2087486 | 2087486 | 2022-01-06 | Washington | Kentucky | 21229 | 2823 | 52 |
2084234 | 2084234 | 2022-01-05 | Washington | Kentucky | 21229 | 2805 | 52 |
2080982 | 2080982 | 2022-01-04 | Washington | Kentucky | 21229 | 2770 | 52 |
2077730 | 2077730 | 2022-01-03 | Washington | Kentucky | 21229 | 2745 | 52 |
2009407 | 2009407 | 2021-12-13 | Harrison | Kentucky | 21097 | 3816 | 52 |
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);