ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Mercer" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2458319 | 2458319 | 2022-04-30 | Mercer | Kentucky | 21167 | 7360 | 105 |
2455063 | 2455063 | 2022-04-29 | Mercer | Kentucky | 21167 | 7360 | 105 |
2451807 | 2451807 | 2022-04-28 | Mercer | Kentucky | 21167 | 7360 | 105 |
2448551 | 2448551 | 2022-04-27 | Mercer | Kentucky | 21167 | 7360 | 105 |
2445295 | 2445295 | 2022-04-26 | Mercer | Kentucky | 21167 | 7360 | 105 |
2442039 | 2442039 | 2022-04-25 | Mercer | Kentucky | 21167 | 7360 | 105 |
2438783 | 2438783 | 2022-04-24 | Mercer | Kentucky | 21167 | 7350 | 104 |
2435527 | 2435527 | 2022-04-23 | Mercer | Kentucky | 21167 | 7350 | 104 |
2432271 | 2432271 | 2022-04-22 | Mercer | Kentucky | 21167 | 7350 | 104 |
2429015 | 2429015 | 2022-04-21 | Mercer | Kentucky | 21167 | 7350 | 104 |
2425759 | 2425759 | 2022-04-20 | Mercer | Kentucky | 21167 | 7350 | 104 |
2422503 | 2422503 | 2022-04-19 | Mercer | Kentucky | 21167 | 7350 | 104 |
2419247 | 2419247 | 2022-04-18 | Mercer | Kentucky | 21167 | 7350 | 104 |
2415991 | 2415991 | 2022-04-17 | Mercer | Kentucky | 21167 | 7347 | 103 |
2412735 | 2412735 | 2022-04-16 | Mercer | Kentucky | 21167 | 7347 | 103 |
2409479 | 2409479 | 2022-04-15 | Mercer | Kentucky | 21167 | 7347 | 103 |
2406223 | 2406223 | 2022-04-14 | Mercer | Kentucky | 21167 | 7347 | 103 |
2402967 | 2402967 | 2022-04-13 | Mercer | Kentucky | 21167 | 7347 | 103 |
2399713 | 2399713 | 2022-04-12 | Mercer | Kentucky | 21167 | 7347 | 103 |
2396457 | 2396457 | 2022-04-11 | Mercer | Kentucky | 21167 | 7347 | 103 |
2393202 | 2393202 | 2022-04-10 | Mercer | Kentucky | 21167 | 7336 | 103 |
2389946 | 2389946 | 2022-04-09 | Mercer | Kentucky | 21167 | 7336 | 103 |
2386690 | 2386690 | 2022-04-08 | Mercer | Kentucky | 21167 | 7336 | 103 |
2383435 | 2383435 | 2022-04-07 | Mercer | Kentucky | 21167 | 7336 | 103 |
2380180 | 2380180 | 2022-04-06 | Mercer | Kentucky | 21167 | 7336 | 103 |
2376925 | 2376925 | 2022-04-05 | Mercer | Kentucky | 21167 | 7336 | 103 |
2373673 | 2373673 | 2022-04-04 | Mercer | Kentucky | 21167 | 7336 | 103 |
2370420 | 2370420 | 2022-04-03 | Mercer | Kentucky | 21167 | 7329 | 102 |
2367167 | 2367167 | 2022-04-02 | Mercer | Kentucky | 21167 | 7329 | 102 |
2363914 | 2363914 | 2022-04-01 | Mercer | Kentucky | 21167 | 7329 | 102 |
2360660 | 2360660 | 2022-03-31 | Mercer | Kentucky | 21167 | 7329 | 102 |
2357406 | 2357406 | 2022-03-30 | Mercer | Kentucky | 21167 | 7329 | 102 |
2354153 | 2354153 | 2022-03-29 | Mercer | Kentucky | 21167 | 7329 | 102 |
2350901 | 2350901 | 2022-03-28 | Mercer | Kentucky | 21167 | 7329 | 102 |
2347648 | 2347648 | 2022-03-27 | Mercer | Kentucky | 21167 | 7322 | 101 |
2344395 | 2344395 | 2022-03-26 | Mercer | Kentucky | 21167 | 7322 | 101 |
2341142 | 2341142 | 2022-03-25 | Mercer | Kentucky | 21167 | 7322 | 101 |
2337889 | 2337889 | 2022-03-24 | Mercer | Kentucky | 21167 | 7322 | 101 |
2334635 | 2334635 | 2022-03-23 | Mercer | Kentucky | 21167 | 7322 | 101 |
2331381 | 2331381 | 2022-03-22 | Mercer | Kentucky | 21167 | 7322 | 101 |
2328129 | 2328129 | 2022-03-21 | Mercer | Kentucky | 21167 | 7322 | 101 |
2324876 | 2324876 | 2022-03-20 | Mercer | Kentucky | 21167 | 7310 | 100 |
2321622 | 2321622 | 2022-03-19 | Mercer | Kentucky | 21167 | 7310 | 100 |
2318368 | 2318368 | 2022-03-18 | Mercer | Kentucky | 21167 | 7310 | 100 |
2315115 | 2315115 | 2022-03-17 | Mercer | Kentucky | 21167 | 7310 | 100 |
2311862 | 2311862 | 2022-03-16 | Mercer | Kentucky | 21167 | 7310 | 100 |
2308609 | 2308609 | 2022-03-15 | Mercer | Kentucky | 21167 | 7310 | 100 |
2305358 | 2305358 | 2022-03-14 | Mercer | Kentucky | 21167 | 7310 | 100 |
2302106 | 2302106 | 2022-03-13 | Mercer | Kentucky | 21167 | 7278 | 99 |
2298854 | 2298854 | 2022-03-12 | Mercer | Kentucky | 21167 | 7278 | 99 |
2295602 | 2295602 | 2022-03-11 | Mercer | Kentucky | 21167 | 7278 | 99 |
2292350 | 2292350 | 2022-03-10 | Mercer | Kentucky | 21167 | 7278 | 99 |
2289098 | 2289098 | 2022-03-09 | Mercer | Kentucky | 21167 | 7278 | 99 |
2285847 | 2285847 | 2022-03-08 | Mercer | Kentucky | 21167 | 7278 | 99 |
2282595 | 2282595 | 2022-03-07 | Mercer | Kentucky | 21167 | 7278 | 99 |
2279342 | 2279342 | 2022-03-06 | Mercer | Kentucky | 21167 | 7271 | 99 |
2276089 | 2276089 | 2022-03-05 | Mercer | Kentucky | 21167 | 7271 | 99 |
2272836 | 2272836 | 2022-03-04 | Mercer | Kentucky | 21167 | 7271 | 99 |
2269584 | 2269584 | 2022-03-03 | Mercer | Kentucky | 21167 | 7266 | 99 |
2266331 | 2266331 | 2022-03-02 | Mercer | Kentucky | 21167 | 7260 | 99 |
2263080 | 2263080 | 2022-03-01 | Mercer | Kentucky | 21167 | 7253 | 99 |
2259829 | 2259829 | 2022-02-28 | Mercer | Kentucky | 21167 | 7243 | 99 |
2256578 | 2256578 | 2022-02-27 | Mercer | Kentucky | 21167 | 7233 | 99 |
2253327 | 2253327 | 2022-02-26 | Mercer | Kentucky | 21167 | 7233 | 99 |
2250076 | 2250076 | 2022-02-25 | Mercer | Kentucky | 21167 | 7233 | 99 |
2246825 | 2246825 | 2022-02-24 | Mercer | Kentucky | 21167 | 7218 | 99 |
2243574 | 2243574 | 2022-02-23 | Mercer | Kentucky | 21167 | 7218 | 99 |
2240323 | 2240323 | 2022-02-22 | Mercer | Kentucky | 21167 | 7211 | 99 |
2237072 | 2237072 | 2022-02-21 | Mercer | Kentucky | 21167 | 7199 | 99 |
2233821 | 2233821 | 2022-02-20 | Mercer | Kentucky | 21167 | 7162 | 99 |
2230570 | 2230570 | 2022-02-19 | Mercer | Kentucky | 21167 | 7162 | 99 |
2227319 | 2227319 | 2022-02-18 | Mercer | Kentucky | 21167 | 7162 | 99 |
2224068 | 2224068 | 2022-02-17 | Mercer | Kentucky | 21167 | 7144 | 99 |
2220817 | 2220817 | 2022-02-16 | Mercer | Kentucky | 21167 | 7126 | 99 |
2217566 | 2217566 | 2022-02-15 | Mercer | Kentucky | 21167 | 7103 | 98 |
2214315 | 2214315 | 2022-02-14 | Mercer | Kentucky | 21167 | 7091 | 98 |
2211063 | 2211063 | 2022-02-13 | Mercer | Kentucky | 21167 | 7003 | 98 |
2207810 | 2207810 | 2022-02-12 | Mercer | Kentucky | 21167 | 7003 | 98 |
2204557 | 2204557 | 2022-02-11 | Mercer | Kentucky | 21167 | 7003 | 98 |
2201304 | 2201304 | 2022-02-10 | Mercer | Kentucky | 21167 | 6969 | 98 |
2198050 | 2198050 | 2022-02-09 | Mercer | Kentucky | 21167 | 6941 | 98 |
2194796 | 2194796 | 2022-02-08 | Mercer | Kentucky | 21167 | 6894 | 98 |
2191542 | 2191542 | 2022-02-07 | Mercer | Kentucky | 21167 | 6828 | 98 |
2188289 | 2188289 | 2022-02-06 | Mercer | Kentucky | 21167 | 6812 | 98 |
2185036 | 2185036 | 2022-02-05 | Mercer | Kentucky | 21167 | 6812 | 98 |
2181784 | 2181784 | 2022-02-04 | Mercer | Kentucky | 21167 | 6812 | 98 |
2178533 | 2178533 | 2022-02-03 | Mercer | Kentucky | 21167 | 6777 | 98 |
2175280 | 2175280 | 2022-02-02 | Mercer | Kentucky | 21167 | 6726 | 98 |
2172027 | 2172027 | 2022-02-01 | Mercer | Kentucky | 21167 | 6681 | 96 |
2168774 | 2168774 | 2022-01-31 | Mercer | Kentucky | 21167 | 6637 | 95 |
2165519 | 2165519 | 2022-01-30 | Mercer | Kentucky | 21167 | 6464 | 95 |
2162264 | 2162264 | 2022-01-29 | Mercer | Kentucky | 21167 | 6464 | 95 |
2159009 | 2159009 | 2022-01-28 | Mercer | Kentucky | 21167 | 6464 | 95 |
2155755 | 2155755 | 2022-01-27 | Mercer | Kentucky | 21167 | 6265 | 95 |
2152502 | 2152502 | 2022-01-26 | Mercer | Kentucky | 21167 | 6152 | 95 |
2149250 | 2149250 | 2022-01-25 | Mercer | Kentucky | 21167 | 6054 | 95 |
2145998 | 2145998 | 2022-01-24 | Mercer | Kentucky | 21167 | 5955 | 95 |
2142743 | 2142743 | 2022-01-23 | Mercer | Kentucky | 21167 | 5807 | 95 |
2139488 | 2139488 | 2022-01-22 | Mercer | Kentucky | 21167 | 5807 | 95 |
2136232 | 2136232 | 2022-01-21 | Mercer | Kentucky | 21167 | 5807 | 95 |
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);