ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,428 rows where county = "Powell" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500677 | 2500677 | 2022-05-13 | Powell | Kentucky | 21197 | 4782 | 44 |
2501231 | 2501231 | 2022-05-13 | Powell | Montana | 30077 | 1869 | 29 |
2497419 | 2497419 | 2022-05-12 | Powell | Kentucky | 21197 | 4782 | 44 |
2497973 | 2497973 | 2022-05-12 | Powell | Montana | 30077 | 1868 | 29 |
2494161 | 2494161 | 2022-05-11 | Powell | Kentucky | 21197 | 4782 | 44 |
2494715 | 2494715 | 2022-05-11 | Powell | Montana | 30077 | 1868 | 29 |
2490903 | 2490903 | 2022-05-10 | Powell | Kentucky | 21197 | 4782 | 44 |
2491457 | 2491457 | 2022-05-10 | Powell | Montana | 30077 | 1868 | 29 |
2487646 | 2487646 | 2022-05-09 | Powell | Kentucky | 21197 | 4782 | 44 |
2488199 | 2488199 | 2022-05-09 | Powell | Montana | 30077 | 1868 | 29 |
2484388 | 2484388 | 2022-05-08 | Powell | Kentucky | 21197 | 4775 | 43 |
2484942 | 2484942 | 2022-05-08 | Powell | Montana | 30077 | 1868 | 29 |
2481130 | 2481130 | 2022-05-07 | Powell | Kentucky | 21197 | 4775 | 43 |
2481684 | 2481684 | 2022-05-07 | Powell | Montana | 30077 | 1868 | 29 |
2477872 | 2477872 | 2022-05-06 | Powell | Kentucky | 21197 | 4775 | 43 |
2478426 | 2478426 | 2022-05-06 | Powell | Montana | 30077 | 1868 | 29 |
2474614 | 2474614 | 2022-05-05 | Powell | Kentucky | 21197 | 4775 | 43 |
2475168 | 2475168 | 2022-05-05 | Powell | Montana | 30077 | 1872 | 29 |
2471357 | 2471357 | 2022-05-04 | Powell | Kentucky | 21197 | 4775 | 43 |
2471911 | 2471911 | 2022-05-04 | Powell | Montana | 30077 | 1871 | 29 |
2468101 | 2468101 | 2022-05-03 | Powell | Kentucky | 21197 | 4775 | 43 |
2468655 | 2468655 | 2022-05-03 | Powell | Montana | 30077 | 1871 | 29 |
2464846 | 2464846 | 2022-05-02 | Powell | Kentucky | 21197 | 4775 | 43 |
2465399 | 2465399 | 2022-05-02 | Powell | Montana | 30077 | 1871 | 29 |
2461590 | 2461590 | 2022-05-01 | Powell | Kentucky | 21197 | 4767 | 42 |
2462144 | 2462144 | 2022-05-01 | Powell | Montana | 30077 | 1871 | 29 |
2458334 | 2458334 | 2022-04-30 | Powell | Kentucky | 21197 | 4767 | 42 |
2458888 | 2458888 | 2022-04-30 | Powell | Montana | 30077 | 1871 | 29 |
2455078 | 2455078 | 2022-04-29 | Powell | Kentucky | 21197 | 4767 | 42 |
2455632 | 2455632 | 2022-04-29 | Powell | Montana | 30077 | 1871 | 29 |
2451822 | 2451822 | 2022-04-28 | Powell | Kentucky | 21197 | 4767 | 42 |
2452376 | 2452376 | 2022-04-28 | Powell | Montana | 30077 | 1871 | 29 |
2448566 | 2448566 | 2022-04-27 | Powell | Kentucky | 21197 | 4767 | 42 |
2449120 | 2449120 | 2022-04-27 | Powell | Montana | 30077 | 1871 | 29 |
2445310 | 2445310 | 2022-04-26 | Powell | Kentucky | 21197 | 4767 | 42 |
2445863 | 2445863 | 2022-04-26 | Powell | Montana | 30077 | 1871 | 29 |
2442054 | 2442054 | 2022-04-25 | Powell | Kentucky | 21197 | 4767 | 42 |
2442608 | 2442608 | 2022-04-25 | Powell | Montana | 30077 | 1871 | 29 |
2438798 | 2438798 | 2022-04-24 | Powell | Kentucky | 21197 | 4764 | 42 |
2439352 | 2439352 | 2022-04-24 | Powell | Montana | 30077 | 1871 | 28 |
2435542 | 2435542 | 2022-04-23 | Powell | Kentucky | 21197 | 4764 | 42 |
2436096 | 2436096 | 2022-04-23 | Powell | Montana | 30077 | 1871 | 28 |
2432286 | 2432286 | 2022-04-22 | Powell | Kentucky | 21197 | 4764 | 42 |
2432840 | 2432840 | 2022-04-22 | Powell | Montana | 30077 | 1871 | 28 |
2429030 | 2429030 | 2022-04-21 | Powell | Kentucky | 21197 | 4764 | 42 |
2429584 | 2429584 | 2022-04-21 | Powell | Montana | 30077 | 1871 | 28 |
2425774 | 2425774 | 2022-04-20 | Powell | Kentucky | 21197 | 4764 | 42 |
2426328 | 2426328 | 2022-04-20 | Powell | Montana | 30077 | 1870 | 28 |
2422518 | 2422518 | 2022-04-19 | Powell | Kentucky | 21197 | 4764 | 42 |
2423072 | 2423072 | 2022-04-19 | Powell | Montana | 30077 | 1868 | 28 |
2419262 | 2419262 | 2022-04-18 | Powell | Kentucky | 21197 | 4764 | 42 |
2419815 | 2419815 | 2022-04-18 | Powell | Montana | 30077 | 1867 | 28 |
2416006 | 2416006 | 2022-04-17 | Powell | Kentucky | 21197 | 4757 | 42 |
2416560 | 2416560 | 2022-04-17 | Powell | Montana | 30077 | 1867 | 28 |
2412750 | 2412750 | 2022-04-16 | Powell | Kentucky | 21197 | 4757 | 42 |
2413304 | 2413304 | 2022-04-16 | Powell | Montana | 30077 | 1867 | 28 |
2409494 | 2409494 | 2022-04-15 | Powell | Kentucky | 21197 | 4757 | 42 |
2410048 | 2410048 | 2022-04-15 | Powell | Montana | 30077 | 1867 | 28 |
2406238 | 2406238 | 2022-04-14 | Powell | Kentucky | 21197 | 4757 | 42 |
2406792 | 2406792 | 2022-04-14 | Powell | Montana | 30077 | 1867 | 28 |
2402982 | 2402982 | 2022-04-13 | Powell | Kentucky | 21197 | 4757 | 42 |
2403536 | 2403536 | 2022-04-13 | Powell | Montana | 30077 | 1866 | 28 |
2399728 | 2399728 | 2022-04-12 | Powell | Kentucky | 21197 | 4757 | 42 |
2400281 | 2400281 | 2022-04-12 | Powell | Montana | 30077 | 1865 | 28 |
2396472 | 2396472 | 2022-04-11 | Powell | Kentucky | 21197 | 4757 | 42 |
2397026 | 2397026 | 2022-04-11 | Powell | Montana | 30077 | 1865 | 28 |
2393217 | 2393217 | 2022-04-10 | Powell | Kentucky | 21197 | 4752 | 42 |
2393771 | 2393771 | 2022-04-10 | Powell | Montana | 30077 | 1865 | 28 |
2389961 | 2389961 | 2022-04-09 | Powell | Kentucky | 21197 | 4752 | 42 |
2390515 | 2390515 | 2022-04-09 | Powell | Montana | 30077 | 1865 | 28 |
2386705 | 2386705 | 2022-04-08 | Powell | Kentucky | 21197 | 4752 | 42 |
2387259 | 2387259 | 2022-04-08 | Powell | Montana | 30077 | 1865 | 28 |
2383450 | 2383450 | 2022-04-07 | Powell | Kentucky | 21197 | 4752 | 42 |
2384004 | 2384004 | 2022-04-07 | Powell | Montana | 30077 | 1865 | 28 |
2380195 | 2380195 | 2022-04-06 | Powell | Kentucky | 21197 | 4752 | 42 |
2380749 | 2380749 | 2022-04-06 | Powell | Montana | 30077 | 1865 | 28 |
2376940 | 2376940 | 2022-04-05 | Powell | Kentucky | 21197 | 4752 | 42 |
2377494 | 2377494 | 2022-04-05 | Powell | Montana | 30077 | 1865 | 28 |
2373688 | 2373688 | 2022-04-04 | Powell | Kentucky | 21197 | 4752 | 42 |
2374241 | 2374241 | 2022-04-04 | Powell | Montana | 30077 | 1865 | 28 |
2370435 | 2370435 | 2022-04-03 | Powell | Kentucky | 21197 | 4749 | 41 |
2370989 | 2370989 | 2022-04-03 | Powell | Montana | 30077 | 1865 | 28 |
2367182 | 2367182 | 2022-04-02 | Powell | Kentucky | 21197 | 4749 | 41 |
2367736 | 2367736 | 2022-04-02 | Powell | Montana | 30077 | 1865 | 28 |
2363929 | 2363929 | 2022-04-01 | Powell | Kentucky | 21197 | 4749 | 41 |
2364483 | 2364483 | 2022-04-01 | Powell | Montana | 30077 | 1865 | 28 |
2360675 | 2360675 | 2022-03-31 | Powell | Kentucky | 21197 | 4749 | 41 |
2361229 | 2361229 | 2022-03-31 | Powell | Montana | 30077 | 1865 | 28 |
2357421 | 2357421 | 2022-03-30 | Powell | Kentucky | 21197 | 4749 | 41 |
2357975 | 2357975 | 2022-03-30 | Powell | Montana | 30077 | 1865 | 28 |
2354168 | 2354168 | 2022-03-29 | Powell | Kentucky | 21197 | 4749 | 41 |
2354722 | 2354722 | 2022-03-29 | Powell | Montana | 30077 | 1865 | 28 |
2350916 | 2350916 | 2022-03-28 | Powell | Kentucky | 21197 | 4749 | 41 |
2351469 | 2351469 | 2022-03-28 | Powell | Montana | 30077 | 1865 | 28 |
2347663 | 2347663 | 2022-03-27 | Powell | Kentucky | 21197 | 4743 | 40 |
2348217 | 2348217 | 2022-03-27 | Powell | Montana | 30077 | 1865 | 28 |
2344410 | 2344410 | 2022-03-26 | Powell | Kentucky | 21197 | 4743 | 40 |
2344964 | 2344964 | 2022-03-26 | Powell | Montana | 30077 | 1865 | 28 |
2341157 | 2341157 | 2022-03-25 | Powell | Kentucky | 21197 | 4743 | 40 |
2341711 | 2341711 | 2022-03-25 | Powell | Montana | 30077 | 1865 | 28 |
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);