ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,559 rows where county = "Humphreys" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338246 | 2338246 | 2022-03-24 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2339379 | 2339379 | 2022-03-24 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2334992 | 2334992 | 2022-03-23 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2336125 | 2336125 | 2022-03-23 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2331738 | 2331738 | 2022-03-22 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2332871 | 2332871 | 2022-03-22 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2328486 | 2328486 | 2022-03-21 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2329618 | 2329618 | 2022-03-21 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2325233 | 2325233 | 2022-03-20 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2326366 | 2326366 | 2022-03-20 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2321979 | 2321979 | 2022-03-19 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2323113 | 2323113 | 2022-03-19 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2318725 | 2318725 | 2022-03-18 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2319859 | 2319859 | 2022-03-18 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2315472 | 2315472 | 2022-03-17 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2316605 | 2316605 | 2022-03-17 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2312219 | 2312219 | 2022-03-16 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2313352 | 2313352 | 2022-03-16 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2308966 | 2308966 | 2022-03-15 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2310099 | 2310099 | 2022-03-15 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2305715 | 2305715 | 2022-03-14 | Humphreys | Mississippi | 28053 | 2014 | 44 |
2306846 | 2306846 | 2022-03-14 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2302463 | 2302463 | 2022-03-13 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2303595 | 2303595 | 2022-03-13 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2299211 | 2299211 | 2022-03-12 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2300343 | 2300343 | 2022-03-12 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2295959 | 2295959 | 2022-03-11 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2297091 | 2297091 | 2022-03-11 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2292707 | 2292707 | 2022-03-10 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2293839 | 2293839 | 2022-03-10 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2289455 | 2289455 | 2022-03-09 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2290587 | 2290587 | 2022-03-09 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2286204 | 2286204 | 2022-03-08 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2287335 | 2287335 | 2022-03-08 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2282952 | 2282952 | 2022-03-07 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2284083 | 2284083 | 2022-03-07 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2279699 | 2279699 | 2022-03-06 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2280831 | 2280831 | 2022-03-06 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2276446 | 2276446 | 2022-03-05 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2277578 | 2277578 | 2022-03-05 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2273193 | 2273193 | 2022-03-04 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2274325 | 2274325 | 2022-03-04 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2269941 | 2269941 | 2022-03-03 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2271072 | 2271072 | 2022-03-03 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2266688 | 2266688 | 2022-03-02 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2267820 | 2267820 | 2022-03-02 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2263437 | 2263437 | 2022-03-01 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2264567 | 2264567 | 2022-03-01 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2260186 | 2260186 | 2022-02-28 | Humphreys | Mississippi | 28053 | 2006 | 44 |
2261317 | 2261317 | 2022-02-28 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2256935 | 2256935 | 2022-02-27 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2258066 | 2258066 | 2022-02-27 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2253684 | 2253684 | 2022-02-26 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2254815 | 2254815 | 2022-02-26 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2250433 | 2250433 | 2022-02-25 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2251564 | 2251564 | 2022-02-25 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2247182 | 2247182 | 2022-02-24 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2248313 | 2248313 | 2022-02-24 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2243931 | 2243931 | 2022-02-23 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2245062 | 2245062 | 2022-02-23 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2240680 | 2240680 | 2022-02-22 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2241811 | 2241811 | 2022-02-22 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2237429 | 2237429 | 2022-02-21 | Humphreys | Mississippi | 28053 | 2002 | 44 |
2238560 | 2238560 | 2022-02-21 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2234178 | 2234178 | 2022-02-20 | Humphreys | Mississippi | 28053 | 2002 | 44 |
2235309 | 2235309 | 2022-02-20 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2230927 | 2230927 | 2022-02-19 | Humphreys | Mississippi | 28053 | 2002 | 44 |
2232058 | 2232058 | 2022-02-19 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2227676 | 2227676 | 2022-02-18 | Humphreys | Mississippi | 28053 | 2002 | 44 |
2228807 | 2228807 | 2022-02-18 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2224425 | 2224425 | 2022-02-17 | Humphreys | Mississippi | 28053 | 2003 | 44 |
2225556 | 2225556 | 2022-02-17 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2221174 | 2221174 | 2022-02-16 | Humphreys | Mississippi | 28053 | 2003 | 44 |
2222305 | 2222305 | 2022-02-16 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2217923 | 2217923 | 2022-02-15 | Humphreys | Mississippi | 28053 | 2001 | 43 |
2219054 | 2219054 | 2022-02-15 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2214672 | 2214672 | 2022-02-14 | Humphreys | Mississippi | 28053 | 1999 | 42 |
2215803 | 2215803 | 2022-02-14 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2211420 | 2211420 | 2022-02-13 | Humphreys | Mississippi | 28053 | 1991 | 41 |
2212552 | 2212552 | 2022-02-13 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2208167 | 2208167 | 2022-02-12 | Humphreys | Mississippi | 28053 | 1991 | 41 |
2209299 | 2209299 | 2022-02-12 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2204914 | 2204914 | 2022-02-11 | Humphreys | Mississippi | 28053 | 1991 | 41 |
2206046 | 2206046 | 2022-02-11 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2201661 | 2201661 | 2022-02-10 | Humphreys | Mississippi | 28053 | 1985 | 41 |
2202793 | 2202793 | 2022-02-10 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2198407 | 2198407 | 2022-02-09 | Humphreys | Mississippi | 28053 | 1983 | 41 |
2199539 | 2199539 | 2022-02-09 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2195153 | 2195153 | 2022-02-08 | Humphreys | Mississippi | 28053 | 1979 | 40 |
2196285 | 2196285 | 2022-02-08 | Humphreys | Tennessee | 47085 | 4272 | 61 |
2191899 | 2191899 | 2022-02-07 | Humphreys | Mississippi | 28053 | 1974 | 40 |
2193031 | 2193031 | 2022-02-07 | Humphreys | Tennessee | 47085 | 4272 | 61 |
2188646 | 2188646 | 2022-02-06 | Humphreys | Mississippi | 28053 | 1947 | 40 |
2189777 | 2189777 | 2022-02-06 | Humphreys | Tennessee | 47085 | 4272 | 61 |
2185393 | 2185393 | 2022-02-05 | Humphreys | Mississippi | 28053 | 1947 | 40 |
2186524 | 2186524 | 2022-02-05 | Humphreys | Tennessee | 47085 | 4272 | 61 |
2182141 | 2182141 | 2022-02-04 | Humphreys | Mississippi | 28053 | 1947 | 40 |
2183272 | 2183272 | 2022-02-04 | Humphreys | Tennessee | 47085 | 4272 | 61 |
2178889 | 2178889 | 2022-02-03 | Humphreys | Mississippi | 28053 | 1903 | 40 |
2180020 | 2180020 | 2022-02-03 | Humphreys | Tennessee | 47085 | 4272 | 61 |
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);