ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Powell" and fips = 21197 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500677 | 2500677 | 2022-05-13 | Powell | Kentucky | 21197 | 4782 | 44 |
2497419 | 2497419 | 2022-05-12 | Powell | Kentucky | 21197 | 4782 | 44 |
2494161 | 2494161 | 2022-05-11 | Powell | Kentucky | 21197 | 4782 | 44 |
2490903 | 2490903 | 2022-05-10 | Powell | Kentucky | 21197 | 4782 | 44 |
2487646 | 2487646 | 2022-05-09 | Powell | Kentucky | 21197 | 4782 | 44 |
2484388 | 2484388 | 2022-05-08 | Powell | Kentucky | 21197 | 4775 | 43 |
2481130 | 2481130 | 2022-05-07 | Powell | Kentucky | 21197 | 4775 | 43 |
2477872 | 2477872 | 2022-05-06 | Powell | Kentucky | 21197 | 4775 | 43 |
2474614 | 2474614 | 2022-05-05 | Powell | Kentucky | 21197 | 4775 | 43 |
2471357 | 2471357 | 2022-05-04 | Powell | Kentucky | 21197 | 4775 | 43 |
2468101 | 2468101 | 2022-05-03 | Powell | Kentucky | 21197 | 4775 | 43 |
2464846 | 2464846 | 2022-05-02 | Powell | Kentucky | 21197 | 4775 | 43 |
2461590 | 2461590 | 2022-05-01 | Powell | Kentucky | 21197 | 4767 | 42 |
2458334 | 2458334 | 2022-04-30 | Powell | Kentucky | 21197 | 4767 | 42 |
2455078 | 2455078 | 2022-04-29 | Powell | Kentucky | 21197 | 4767 | 42 |
2451822 | 2451822 | 2022-04-28 | Powell | Kentucky | 21197 | 4767 | 42 |
2448566 | 2448566 | 2022-04-27 | Powell | Kentucky | 21197 | 4767 | 42 |
2445310 | 2445310 | 2022-04-26 | Powell | Kentucky | 21197 | 4767 | 42 |
2442054 | 2442054 | 2022-04-25 | Powell | Kentucky | 21197 | 4767 | 42 |
2438798 | 2438798 | 2022-04-24 | Powell | Kentucky | 21197 | 4764 | 42 |
2435542 | 2435542 | 2022-04-23 | Powell | Kentucky | 21197 | 4764 | 42 |
2432286 | 2432286 | 2022-04-22 | Powell | Kentucky | 21197 | 4764 | 42 |
2429030 | 2429030 | 2022-04-21 | Powell | Kentucky | 21197 | 4764 | 42 |
2425774 | 2425774 | 2022-04-20 | Powell | Kentucky | 21197 | 4764 | 42 |
2422518 | 2422518 | 2022-04-19 | Powell | Kentucky | 21197 | 4764 | 42 |
2419262 | 2419262 | 2022-04-18 | Powell | Kentucky | 21197 | 4764 | 42 |
2416006 | 2416006 | 2022-04-17 | Powell | Kentucky | 21197 | 4757 | 42 |
2412750 | 2412750 | 2022-04-16 | Powell | Kentucky | 21197 | 4757 | 42 |
2409494 | 2409494 | 2022-04-15 | Powell | Kentucky | 21197 | 4757 | 42 |
2406238 | 2406238 | 2022-04-14 | Powell | Kentucky | 21197 | 4757 | 42 |
2402982 | 2402982 | 2022-04-13 | Powell | Kentucky | 21197 | 4757 | 42 |
2399728 | 2399728 | 2022-04-12 | Powell | Kentucky | 21197 | 4757 | 42 |
2396472 | 2396472 | 2022-04-11 | Powell | Kentucky | 21197 | 4757 | 42 |
2393217 | 2393217 | 2022-04-10 | Powell | Kentucky | 21197 | 4752 | 42 |
2389961 | 2389961 | 2022-04-09 | Powell | Kentucky | 21197 | 4752 | 42 |
2386705 | 2386705 | 2022-04-08 | Powell | Kentucky | 21197 | 4752 | 42 |
2383450 | 2383450 | 2022-04-07 | Powell | Kentucky | 21197 | 4752 | 42 |
2380195 | 2380195 | 2022-04-06 | Powell | Kentucky | 21197 | 4752 | 42 |
2376940 | 2376940 | 2022-04-05 | Powell | Kentucky | 21197 | 4752 | 42 |
2373688 | 2373688 | 2022-04-04 | Powell | Kentucky | 21197 | 4752 | 42 |
2370435 | 2370435 | 2022-04-03 | Powell | Kentucky | 21197 | 4749 | 41 |
2367182 | 2367182 | 2022-04-02 | Powell | Kentucky | 21197 | 4749 | 41 |
2363929 | 2363929 | 2022-04-01 | Powell | Kentucky | 21197 | 4749 | 41 |
2360675 | 2360675 | 2022-03-31 | Powell | Kentucky | 21197 | 4749 | 41 |
2357421 | 2357421 | 2022-03-30 | Powell | Kentucky | 21197 | 4749 | 41 |
2354168 | 2354168 | 2022-03-29 | Powell | Kentucky | 21197 | 4749 | 41 |
2350916 | 2350916 | 2022-03-28 | Powell | Kentucky | 21197 | 4749 | 41 |
2347663 | 2347663 | 2022-03-27 | Powell | Kentucky | 21197 | 4743 | 40 |
2344410 | 2344410 | 2022-03-26 | Powell | Kentucky | 21197 | 4743 | 40 |
2341157 | 2341157 | 2022-03-25 | Powell | Kentucky | 21197 | 4743 | 40 |
2337904 | 2337904 | 2022-03-24 | Powell | Kentucky | 21197 | 4743 | 40 |
2334650 | 2334650 | 2022-03-23 | Powell | Kentucky | 21197 | 4743 | 40 |
2331396 | 2331396 | 2022-03-22 | Powell | Kentucky | 21197 | 4743 | 40 |
2328144 | 2328144 | 2022-03-21 | Powell | Kentucky | 21197 | 4743 | 40 |
2324891 | 2324891 | 2022-03-20 | Powell | Kentucky | 21197 | 4718 | 40 |
2321637 | 2321637 | 2022-03-19 | Powell | Kentucky | 21197 | 4718 | 40 |
2318383 | 2318383 | 2022-03-18 | Powell | Kentucky | 21197 | 4718 | 40 |
2315130 | 2315130 | 2022-03-17 | Powell | Kentucky | 21197 | 4718 | 40 |
2311877 | 2311877 | 2022-03-16 | Powell | Kentucky | 21197 | 4718 | 40 |
2308624 | 2308624 | 2022-03-15 | Powell | Kentucky | 21197 | 4718 | 40 |
2305373 | 2305373 | 2022-03-14 | Powell | Kentucky | 21197 | 4718 | 40 |
2302121 | 2302121 | 2022-03-13 | Powell | Kentucky | 21197 | 4699 | 39 |
2298869 | 2298869 | 2022-03-12 | Powell | Kentucky | 21197 | 4699 | 39 |
2295617 | 2295617 | 2022-03-11 | Powell | Kentucky | 21197 | 4699 | 39 |
2292365 | 2292365 | 2022-03-10 | Powell | Kentucky | 21197 | 4699 | 39 |
2289113 | 2289113 | 2022-03-09 | Powell | Kentucky | 21197 | 4699 | 39 |
2285862 | 2285862 | 2022-03-08 | Powell | Kentucky | 21197 | 4699 | 39 |
2282610 | 2282610 | 2022-03-07 | Powell | Kentucky | 21197 | 4699 | 39 |
2279357 | 2279357 | 2022-03-06 | Powell | Kentucky | 21197 | 4693 | 38 |
2276104 | 2276104 | 2022-03-05 | Powell | Kentucky | 21197 | 4693 | 38 |
2272851 | 2272851 | 2022-03-04 | Powell | Kentucky | 21197 | 4693 | 38 |
2269599 | 2269599 | 2022-03-03 | Powell | Kentucky | 21197 | 4687 | 38 |
2266346 | 2266346 | 2022-03-02 | Powell | Kentucky | 21197 | 4682 | 37 |
2263095 | 2263095 | 2022-03-01 | Powell | Kentucky | 21197 | 4678 | 37 |
2259844 | 2259844 | 2022-02-28 | Powell | Kentucky | 21197 | 4670 | 37 |
2256593 | 2256593 | 2022-02-27 | Powell | Kentucky | 21197 | 4665 | 37 |
2253342 | 2253342 | 2022-02-26 | Powell | Kentucky | 21197 | 4665 | 37 |
2250091 | 2250091 | 2022-02-25 | Powell | Kentucky | 21197 | 4665 | 37 |
2246840 | 2246840 | 2022-02-24 | Powell | Kentucky | 21197 | 4650 | 37 |
2243589 | 2243589 | 2022-02-23 | Powell | Kentucky | 21197 | 4650 | 37 |
2240338 | 2240338 | 2022-02-22 | Powell | Kentucky | 21197 | 4638 | 35 |
2237087 | 2237087 | 2022-02-21 | Powell | Kentucky | 21197 | 4625 | 33 |
2233836 | 2233836 | 2022-02-20 | Powell | Kentucky | 21197 | 4592 | 33 |
2230585 | 2230585 | 2022-02-19 | Powell | Kentucky | 21197 | 4592 | 33 |
2227334 | 2227334 | 2022-02-18 | Powell | Kentucky | 21197 | 4592 | 33 |
2224083 | 2224083 | 2022-02-17 | Powell | Kentucky | 21197 | 4559 | 33 |
2220832 | 2220832 | 2022-02-16 | Powell | Kentucky | 21197 | 4549 | 33 |
2217581 | 2217581 | 2022-02-15 | Powell | Kentucky | 21197 | 4531 | 32 |
2214330 | 2214330 | 2022-02-14 | Powell | Kentucky | 21197 | 4511 | 32 |
2211078 | 2211078 | 2022-02-13 | Powell | Kentucky | 21197 | 4441 | 32 |
2207825 | 2207825 | 2022-02-12 | Powell | Kentucky | 21197 | 4441 | 32 |
2204572 | 2204572 | 2022-02-11 | Powell | Kentucky | 21197 | 4441 | 32 |
2201319 | 2201319 | 2022-02-10 | Powell | Kentucky | 21197 | 4429 | 32 |
2198065 | 2198065 | 2022-02-09 | Powell | Kentucky | 21197 | 4402 | 32 |
2194811 | 2194811 | 2022-02-08 | Powell | Kentucky | 21197 | 4382 | 32 |
2191557 | 2191557 | 2022-02-07 | Powell | Kentucky | 21197 | 4325 | 32 |
2188304 | 2188304 | 2022-02-06 | Powell | Kentucky | 21197 | 4293 | 32 |
2185051 | 2185051 | 2022-02-05 | Powell | Kentucky | 21197 | 4293 | 32 |
2181799 | 2181799 | 2022-02-04 | Powell | Kentucky | 21197 | 4293 | 32 |
2178548 | 2178548 | 2022-02-03 | Powell | Kentucky | 21197 | 4255 | 32 |
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);