ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
612 rows where deaths = 45 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 |
---|---|---|---|---|---|---|---|
2500599 | 2500599 | 2022-05-13 | Carroll | Kentucky | 21041 | 3504 | 45 |
2500622 | 2500622 | 2022-05-13 | Green | Kentucky | 21087 | 3761 | 45 |
2497341 | 2497341 | 2022-05-12 | Carroll | Kentucky | 21041 | 3504 | 45 |
2497364 | 2497364 | 2022-05-12 | Green | Kentucky | 21087 | 3761 | 45 |
2494083 | 2494083 | 2022-05-11 | Carroll | Kentucky | 21041 | 3504 | 45 |
2494106 | 2494106 | 2022-05-11 | Green | Kentucky | 21087 | 3761 | 45 |
2490825 | 2490825 | 2022-05-10 | Carroll | Kentucky | 21041 | 3504 | 45 |
2490848 | 2490848 | 2022-05-10 | Green | Kentucky | 21087 | 3761 | 45 |
2487568 | 2487568 | 2022-05-09 | Carroll | Kentucky | 21041 | 3504 | 45 |
2487591 | 2487591 | 2022-05-09 | Green | Kentucky | 21087 | 3761 | 45 |
2484295 | 2484295 | 2022-05-08 | Bath | Kentucky | 21011 | 3199 | 45 |
2484310 | 2484310 | 2022-05-08 | Carroll | Kentucky | 21041 | 3500 | 45 |
2484333 | 2484333 | 2022-05-08 | Green | Kentucky | 21087 | 3752 | 45 |
2481037 | 2481037 | 2022-05-07 | Bath | Kentucky | 21011 | 3199 | 45 |
2481052 | 2481052 | 2022-05-07 | Carroll | Kentucky | 21041 | 3500 | 45 |
2481075 | 2481075 | 2022-05-07 | Green | Kentucky | 21087 | 3752 | 45 |
2477779 | 2477779 | 2022-05-06 | Bath | Kentucky | 21011 | 3199 | 45 |
2477794 | 2477794 | 2022-05-06 | Carroll | Kentucky | 21041 | 3500 | 45 |
2477817 | 2477817 | 2022-05-06 | Green | Kentucky | 21087 | 3752 | 45 |
2474521 | 2474521 | 2022-05-05 | Bath | Kentucky | 21011 | 3199 | 45 |
2474536 | 2474536 | 2022-05-05 | Carroll | Kentucky | 21041 | 3500 | 45 |
2474559 | 2474559 | 2022-05-05 | Green | Kentucky | 21087 | 3752 | 45 |
2471264 | 2471264 | 2022-05-04 | Bath | Kentucky | 21011 | 3199 | 45 |
2471279 | 2471279 | 2022-05-04 | Carroll | Kentucky | 21041 | 3500 | 45 |
2471302 | 2471302 | 2022-05-04 | Green | Kentucky | 21087 | 3752 | 45 |
2468008 | 2468008 | 2022-05-03 | Bath | Kentucky | 21011 | 3199 | 45 |
2468023 | 2468023 | 2022-05-03 | Carroll | Kentucky | 21041 | 3500 | 45 |
2468046 | 2468046 | 2022-05-03 | Green | Kentucky | 21087 | 3752 | 45 |
2464753 | 2464753 | 2022-05-02 | Bath | Kentucky | 21011 | 3199 | 45 |
2464768 | 2464768 | 2022-05-02 | Carroll | Kentucky | 21041 | 3500 | 45 |
2464791 | 2464791 | 2022-05-02 | Green | Kentucky | 21087 | 3752 | 45 |
2461512 | 2461512 | 2022-05-01 | Carroll | Kentucky | 21041 | 3500 | 45 |
2461535 | 2461535 | 2022-05-01 | Green | Kentucky | 21087 | 3751 | 45 |
2458256 | 2458256 | 2022-04-30 | Carroll | Kentucky | 21041 | 3500 | 45 |
2458279 | 2458279 | 2022-04-30 | Green | Kentucky | 21087 | 3751 | 45 |
2455000 | 2455000 | 2022-04-29 | Carroll | Kentucky | 21041 | 3500 | 45 |
2455023 | 2455023 | 2022-04-29 | Green | Kentucky | 21087 | 3751 | 45 |
2451744 | 2451744 | 2022-04-28 | Carroll | Kentucky | 21041 | 3500 | 45 |
2451767 | 2451767 | 2022-04-28 | Green | Kentucky | 21087 | 3751 | 45 |
2448488 | 2448488 | 2022-04-27 | Carroll | Kentucky | 21041 | 3500 | 45 |
2448511 | 2448511 | 2022-04-27 | Green | Kentucky | 21087 | 3751 | 45 |
2445232 | 2445232 | 2022-04-26 | Carroll | Kentucky | 21041 | 3500 | 45 |
2445255 | 2445255 | 2022-04-26 | Green | Kentucky | 21087 | 3751 | 45 |
2441976 | 2441976 | 2022-04-25 | Carroll | Kentucky | 21041 | 3500 | 45 |
2441999 | 2441999 | 2022-04-25 | Green | Kentucky | 21087 | 3751 | 45 |
2438732 | 2438732 | 2022-04-24 | Estill | Kentucky | 21065 | 4110 | 45 |
2438743 | 2438743 | 2022-04-24 | Green | Kentucky | 21087 | 3742 | 45 |
2435476 | 2435476 | 2022-04-23 | Estill | Kentucky | 21065 | 4110 | 45 |
2435487 | 2435487 | 2022-04-23 | Green | Kentucky | 21087 | 3742 | 45 |
2432220 | 2432220 | 2022-04-22 | Estill | Kentucky | 21065 | 4110 | 45 |
2432231 | 2432231 | 2022-04-22 | Green | Kentucky | 21087 | 3742 | 45 |
2428964 | 2428964 | 2022-04-21 | Estill | Kentucky | 21065 | 4110 | 45 |
2428975 | 2428975 | 2022-04-21 | Green | Kentucky | 21087 | 3742 | 45 |
2425708 | 2425708 | 2022-04-20 | Estill | Kentucky | 21065 | 4110 | 45 |
2425719 | 2425719 | 2022-04-20 | Green | Kentucky | 21087 | 3742 | 45 |
2422452 | 2422452 | 2022-04-19 | Estill | Kentucky | 21065 | 4110 | 45 |
2422463 | 2422463 | 2022-04-19 | Green | Kentucky | 21087 | 3742 | 45 |
2419196 | 2419196 | 2022-04-18 | Estill | Kentucky | 21065 | 4110 | 45 |
2419207 | 2419207 | 2022-04-18 | Green | Kentucky | 21087 | 3742 | 45 |
2415940 | 2415940 | 2022-04-17 | Estill | Kentucky | 21065 | 4109 | 45 |
2412684 | 2412684 | 2022-04-16 | Estill | Kentucky | 21065 | 4109 | 45 |
2409428 | 2409428 | 2022-04-15 | Estill | Kentucky | 21065 | 4109 | 45 |
2406172 | 2406172 | 2022-04-14 | Estill | Kentucky | 21065 | 4109 | 45 |
2402916 | 2402916 | 2022-04-13 | Estill | Kentucky | 21065 | 4109 | 45 |
2399662 | 2399662 | 2022-04-12 | Estill | Kentucky | 21065 | 4109 | 45 |
2396406 | 2396406 | 2022-04-11 | Estill | Kentucky | 21065 | 4109 | 45 |
2393151 | 2393151 | 2022-04-10 | Estill | Kentucky | 21065 | 4109 | 45 |
2389895 | 2389895 | 2022-04-09 | Estill | Kentucky | 21065 | 4109 | 45 |
2386639 | 2386639 | 2022-04-08 | Estill | Kentucky | 21065 | 4109 | 45 |
2383384 | 2383384 | 2022-04-07 | Estill | Kentucky | 21065 | 4109 | 45 |
2380129 | 2380129 | 2022-04-06 | Estill | Kentucky | 21065 | 4109 | 45 |
2376874 | 2376874 | 2022-04-05 | Estill | Kentucky | 21065 | 4109 | 45 |
2373622 | 2373622 | 2022-04-04 | Estill | Kentucky | 21065 | 4109 | 45 |
2370369 | 2370369 | 2022-04-03 | Estill | Kentucky | 21065 | 4108 | 45 |
2367116 | 2367116 | 2022-04-02 | Estill | Kentucky | 21065 | 4108 | 45 |
2363863 | 2363863 | 2022-04-01 | Estill | Kentucky | 21065 | 4108 | 45 |
2360609 | 2360609 | 2022-03-31 | Estill | Kentucky | 21065 | 4108 | 45 |
2357355 | 2357355 | 2022-03-30 | Estill | Kentucky | 21065 | 4108 | 45 |
2354102 | 2354102 | 2022-03-29 | Estill | Kentucky | 21065 | 4108 | 45 |
2350850 | 2350850 | 2022-03-28 | Estill | Kentucky | 21065 | 4108 | 45 |
2302061 | 2302061 | 2022-03-13 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2302099 | 2302099 | 2022-03-13 | Martin | Kentucky | 21159 | 3239 | 45 |
2302103 | 2302103 | 2022-03-13 | McLean | Kentucky | 21149 | 2596 | 45 |
2298809 | 2298809 | 2022-03-12 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2298847 | 2298847 | 2022-03-12 | Martin | Kentucky | 21159 | 3239 | 45 |
2298851 | 2298851 | 2022-03-12 | McLean | Kentucky | 21149 | 2596 | 45 |
2295557 | 2295557 | 2022-03-11 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2295595 | 2295595 | 2022-03-11 | Martin | Kentucky | 21159 | 3239 | 45 |
2295599 | 2295599 | 2022-03-11 | McLean | Kentucky | 21149 | 2596 | 45 |
2292305 | 2292305 | 2022-03-10 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2292343 | 2292343 | 2022-03-10 | Martin | Kentucky | 21159 | 3239 | 45 |
2292347 | 2292347 | 2022-03-10 | McLean | Kentucky | 21149 | 2596 | 45 |
2289053 | 2289053 | 2022-03-09 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2289091 | 2289091 | 2022-03-09 | Martin | Kentucky | 21159 | 3239 | 45 |
2285802 | 2285802 | 2022-03-08 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2285840 | 2285840 | 2022-03-08 | Martin | Kentucky | 21159 | 3239 | 45 |
2282550 | 2282550 | 2022-03-07 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2282588 | 2282588 | 2022-03-07 | Martin | Kentucky | 21159 | 3239 | 45 |
2279286 | 2279286 | 2022-03-06 | Crittenden | Kentucky | 21055 | 2145 | 45 |
2279297 | 2279297 | 2022-03-06 | Gallatin | Kentucky | 21077 | 2162 | 45 |
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);