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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337904 | 2337904 | 2022-03-24 | Powell | Kentucky | 21197 | 4743 | 40 |
2338458 | 2338458 | 2022-03-24 | Powell | Montana | 30077 | 1865 | 28 |
2334650 | 2334650 | 2022-03-23 | Powell | Kentucky | 21197 | 4743 | 40 |
2335204 | 2335204 | 2022-03-23 | Powell | Montana | 30077 | 1864 | 28 |
2331396 | 2331396 | 2022-03-22 | Powell | Kentucky | 21197 | 4743 | 40 |
2331950 | 2331950 | 2022-03-22 | Powell | Montana | 30077 | 1864 | 28 |
2328144 | 2328144 | 2022-03-21 | Powell | Kentucky | 21197 | 4743 | 40 |
2328697 | 2328697 | 2022-03-21 | Powell | Montana | 30077 | 1864 | 28 |
2324891 | 2324891 | 2022-03-20 | Powell | Kentucky | 21197 | 4718 | 40 |
2325445 | 2325445 | 2022-03-20 | Powell | Montana | 30077 | 1864 | 28 |
2321637 | 2321637 | 2022-03-19 | Powell | Kentucky | 21197 | 4718 | 40 |
2322191 | 2322191 | 2022-03-19 | Powell | Montana | 30077 | 1864 | 28 |
2318383 | 2318383 | 2022-03-18 | Powell | Kentucky | 21197 | 4718 | 40 |
2318937 | 2318937 | 2022-03-18 | Powell | Montana | 30077 | 1864 | 28 |
2315130 | 2315130 | 2022-03-17 | Powell | Kentucky | 21197 | 4718 | 40 |
2315684 | 2315684 | 2022-03-17 | Powell | Montana | 30077 | 1864 | 28 |
2311877 | 2311877 | 2022-03-16 | Powell | Kentucky | 21197 | 4718 | 40 |
2312431 | 2312431 | 2022-03-16 | Powell | Montana | 30077 | 1864 | 28 |
2308624 | 2308624 | 2022-03-15 | Powell | Kentucky | 21197 | 4718 | 40 |
2309178 | 2309178 | 2022-03-15 | Powell | Montana | 30077 | 1863 | 28 |
2305373 | 2305373 | 2022-03-14 | Powell | Kentucky | 21197 | 4718 | 40 |
2305926 | 2305926 | 2022-03-14 | Powell | Montana | 30077 | 1863 | 28 |
2302121 | 2302121 | 2022-03-13 | Powell | Kentucky | 21197 | 4699 | 39 |
2302675 | 2302675 | 2022-03-13 | Powell | Montana | 30077 | 1863 | 28 |
2298869 | 2298869 | 2022-03-12 | Powell | Kentucky | 21197 | 4699 | 39 |
2299423 | 2299423 | 2022-03-12 | Powell | Montana | 30077 | 1863 | 28 |
2295617 | 2295617 | 2022-03-11 | Powell | Kentucky | 21197 | 4699 | 39 |
2296171 | 2296171 | 2022-03-11 | Powell | Montana | 30077 | 1863 | 28 |
2292365 | 2292365 | 2022-03-10 | Powell | Kentucky | 21197 | 4699 | 39 |
2292919 | 2292919 | 2022-03-10 | Powell | Montana | 30077 | 1864 | 28 |
2289113 | 2289113 | 2022-03-09 | Powell | Kentucky | 21197 | 4699 | 39 |
2289667 | 2289667 | 2022-03-09 | Powell | Montana | 30077 | 1864 | 28 |
2285862 | 2285862 | 2022-03-08 | Powell | Kentucky | 21197 | 4699 | 39 |
2286415 | 2286415 | 2022-03-08 | Powell | Montana | 30077 | 1864 | 28 |
2282610 | 2282610 | 2022-03-07 | Powell | Kentucky | 21197 | 4699 | 39 |
2283163 | 2283163 | 2022-03-07 | Powell | Montana | 30077 | 1861 | 28 |
2279357 | 2279357 | 2022-03-06 | Powell | Kentucky | 21197 | 4693 | 38 |
2279910 | 2279910 | 2022-03-06 | Powell | Montana | 30077 | 1860 | 28 |
2276104 | 2276104 | 2022-03-05 | Powell | Kentucky | 21197 | 4693 | 38 |
2276657 | 2276657 | 2022-03-05 | Powell | Montana | 30077 | 1860 | 28 |
2272851 | 2272851 | 2022-03-04 | Powell | Kentucky | 21197 | 4693 | 38 |
2273404 | 2273404 | 2022-03-04 | Powell | Montana | 30077 | 1860 | 28 |
2269599 | 2269599 | 2022-03-03 | Powell | Kentucky | 21197 | 4687 | 38 |
2270152 | 2270152 | 2022-03-03 | Powell | Montana | 30077 | 1858 | 28 |
2266346 | 2266346 | 2022-03-02 | Powell | Kentucky | 21197 | 4682 | 37 |
2266899 | 2266899 | 2022-03-02 | Powell | Montana | 30077 | 1857 | 28 |
2263095 | 2263095 | 2022-03-01 | Powell | Kentucky | 21197 | 4678 | 37 |
2263648 | 2263648 | 2022-03-01 | Powell | Montana | 30077 | 1855 | 28 |
2259844 | 2259844 | 2022-02-28 | Powell | Kentucky | 21197 | 4670 | 37 |
2260397 | 2260397 | 2022-02-28 | Powell | Montana | 30077 | 1854 | 28 |
2256593 | 2256593 | 2022-02-27 | Powell | Kentucky | 21197 | 4665 | 37 |
2257146 | 2257146 | 2022-02-27 | Powell | Montana | 30077 | 1854 | 28 |
2253342 | 2253342 | 2022-02-26 | Powell | Kentucky | 21197 | 4665 | 37 |
2253895 | 2253895 | 2022-02-26 | Powell | Montana | 30077 | 1854 | 28 |
2250091 | 2250091 | 2022-02-25 | Powell | Kentucky | 21197 | 4665 | 37 |
2250644 | 2250644 | 2022-02-25 | Powell | Montana | 30077 | 1854 | 28 |
2246840 | 2246840 | 2022-02-24 | Powell | Kentucky | 21197 | 4650 | 37 |
2247393 | 2247393 | 2022-02-24 | Powell | Montana | 30077 | 1854 | 28 |
2243589 | 2243589 | 2022-02-23 | Powell | Kentucky | 21197 | 4650 | 37 |
2244142 | 2244142 | 2022-02-23 | Powell | Montana | 30077 | 1853 | 28 |
2240338 | 2240338 | 2022-02-22 | Powell | Kentucky | 21197 | 4638 | 35 |
2240891 | 2240891 | 2022-02-22 | Powell | Montana | 30077 | 1849 | 28 |
2237087 | 2237087 | 2022-02-21 | Powell | Kentucky | 21197 | 4625 | 33 |
2237640 | 2237640 | 2022-02-21 | Powell | Montana | 30077 | 1844 | 27 |
2233836 | 2233836 | 2022-02-20 | Powell | Kentucky | 21197 | 4592 | 33 |
2234389 | 2234389 | 2022-02-20 | Powell | Montana | 30077 | 1844 | 27 |
2230585 | 2230585 | 2022-02-19 | Powell | Kentucky | 21197 | 4592 | 33 |
2231138 | 2231138 | 2022-02-19 | Powell | Montana | 30077 | 1844 | 27 |
2227334 | 2227334 | 2022-02-18 | Powell | Kentucky | 21197 | 4592 | 33 |
2227887 | 2227887 | 2022-02-18 | Powell | Montana | 30077 | 1844 | 27 |
2224083 | 2224083 | 2022-02-17 | Powell | Kentucky | 21197 | 4559 | 33 |
2224636 | 2224636 | 2022-02-17 | Powell | Montana | 30077 | 1846 | 27 |
2220832 | 2220832 | 2022-02-16 | Powell | Kentucky | 21197 | 4549 | 33 |
2221385 | 2221385 | 2022-02-16 | Powell | Montana | 30077 | 1838 | 27 |
2217581 | 2217581 | 2022-02-15 | Powell | Kentucky | 21197 | 4531 | 32 |
2218134 | 2218134 | 2022-02-15 | Powell | Montana | 30077 | 1838 | 27 |
2214330 | 2214330 | 2022-02-14 | Powell | Kentucky | 21197 | 4511 | 32 |
2214883 | 2214883 | 2022-02-14 | Powell | Montana | 30077 | 1837 | 27 |
2211078 | 2211078 | 2022-02-13 | Powell | Kentucky | 21197 | 4441 | 32 |
2211631 | 2211631 | 2022-02-13 | Powell | Montana | 30077 | 1834 | 27 |
2207825 | 2207825 | 2022-02-12 | Powell | Kentucky | 21197 | 4441 | 32 |
2208378 | 2208378 | 2022-02-12 | Powell | Montana | 30077 | 1834 | 27 |
2204572 | 2204572 | 2022-02-11 | Powell | Kentucky | 21197 | 4441 | 32 |
2205125 | 2205125 | 2022-02-11 | Powell | Montana | 30077 | 1834 | 27 |
2201319 | 2201319 | 2022-02-10 | Powell | Kentucky | 21197 | 4429 | 32 |
2201872 | 2201872 | 2022-02-10 | Powell | Montana | 30077 | 1830 | 27 |
2198065 | 2198065 | 2022-02-09 | Powell | Kentucky | 21197 | 4402 | 32 |
2198618 | 2198618 | 2022-02-09 | Powell | Montana | 30077 | 1814 | 27 |
2194811 | 2194811 | 2022-02-08 | Powell | Kentucky | 21197 | 4382 | 32 |
2195364 | 2195364 | 2022-02-08 | Powell | Montana | 30077 | 1792 | 27 |
2191557 | 2191557 | 2022-02-07 | Powell | Kentucky | 21197 | 4325 | 32 |
2192110 | 2192110 | 2022-02-07 | Powell | Montana | 30077 | 1787 | 27 |
2188304 | 2188304 | 2022-02-06 | Powell | Kentucky | 21197 | 4293 | 32 |
2188857 | 2188857 | 2022-02-06 | Powell | Montana | 30077 | 1771 | 27 |
2185051 | 2185051 | 2022-02-05 | Powell | Kentucky | 21197 | 4293 | 32 |
2185604 | 2185604 | 2022-02-05 | Powell | Montana | 30077 | 1771 | 27 |
2181799 | 2181799 | 2022-02-04 | Powell | Kentucky | 21197 | 4293 | 32 |
2182352 | 2182352 | 2022-02-04 | Powell | Montana | 30077 | 1771 | 27 |
2178548 | 2178548 | 2022-02-03 | Powell | Kentucky | 21197 | 4255 | 32 |
2179100 | 2179100 | 2022-02-03 | Powell | Montana | 30077 | 1756 | 27 |
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);