ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

767 rows where county = "Hamilton" and fips = 48193 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 48193 · 767 ✖

county 1

  • Hamilton · 767 ✖
Link rowid date ▲ county state fips cases deaths
2502303 2502303 2022-05-13 Hamilton Texas 48193 1972 33
2499045 2499045 2022-05-12 Hamilton Texas 48193 1971 33
2495787 2495787 2022-05-11 Hamilton Texas 48193 1971 33
2492529 2492529 2022-05-10 Hamilton Texas 48193 1971 33
2489271 2489271 2022-05-09 Hamilton Texas 48193 1971 33
2486014 2486014 2022-05-08 Hamilton Texas 48193 1971 33
2482756 2482756 2022-05-07 Hamilton Texas 48193 1971 33
2479498 2479498 2022-05-06 Hamilton Texas 48193 1971 33
2476240 2476240 2022-05-05 Hamilton Texas 48193 1971 33
2472983 2472983 2022-05-04 Hamilton Texas 48193 1971 33
2469727 2469727 2022-05-03 Hamilton Texas 48193 1971 33
2466471 2466471 2022-05-02 Hamilton Texas 48193 1971 33
2463216 2463216 2022-05-01 Hamilton Texas 48193 1970 33
2459960 2459960 2022-04-30 Hamilton Texas 48193 1970 33
2456704 2456704 2022-04-29 Hamilton Texas 48193 1970 33
2453448 2453448 2022-04-28 Hamilton Texas 48193 1970 33
2450192 2450192 2022-04-27 Hamilton Texas 48193 1970 33
2446935 2446935 2022-04-26 Hamilton Texas 48193 1970 33
2443680 2443680 2022-04-25 Hamilton Texas 48193 1970 33
2440424 2440424 2022-04-24 Hamilton Texas 48193 1970 33
2437168 2437168 2022-04-23 Hamilton Texas 48193 1970 33
2433912 2433912 2022-04-22 Hamilton Texas 48193 1969 33
2430656 2430656 2022-04-21 Hamilton Texas 48193 1963 33
2427400 2427400 2022-04-20 Hamilton Texas 48193 1963 33
2424144 2424144 2022-04-19 Hamilton Texas 48193 1961 33
2420888 2420888 2022-04-18 Hamilton Texas 48193 1960 33
2417632 2417632 2022-04-17 Hamilton Texas 48193 1960 33
2414376 2414376 2022-04-16 Hamilton Texas 48193 1960 33
2411120 2411120 2022-04-15 Hamilton Texas 48193 1960 33
2407864 2407864 2022-04-14 Hamilton Texas 48193 1960 33
2404608 2404608 2022-04-13 Hamilton Texas 48193 1960 33
2401353 2401353 2022-04-12 Hamilton Texas 48193 1960 33
2398098 2398098 2022-04-11 Hamilton Texas 48193 1960 32
2394843 2394843 2022-04-10 Hamilton Texas 48193 1960 32
2391587 2391587 2022-04-09 Hamilton Texas 48193 1960 32
2388331 2388331 2022-04-08 Hamilton Texas 48193 1960 32
2385076 2385076 2022-04-07 Hamilton Texas 48193 1960 32
2381821 2381821 2022-04-06 Hamilton Texas 48193 1960 32
2378566 2378566 2022-04-05 Hamilton Texas 48193 1959 32
2375312 2375312 2022-04-04 Hamilton Texas 48193 1959 32
2372060 2372060 2022-04-03 Hamilton Texas 48193 1959 32
2368807 2368807 2022-04-02 Hamilton Texas 48193 1959 32
2365554 2365554 2022-04-01 Hamilton Texas 48193 1959 32
2362301 2362301 2022-03-31 Hamilton Texas 48193 1959 32
2359047 2359047 2022-03-30 Hamilton Texas 48193 1959 32
2355793 2355793 2022-03-29 Hamilton Texas 48193 1959 32
2352540 2352540 2022-03-28 Hamilton Texas 48193 1959 32
2349288 2349288 2022-03-27 Hamilton Texas 48193 1959 32
2346035 2346035 2022-03-26 Hamilton Texas 48193 1959 32
2342782 2342782 2022-03-25 Hamilton Texas 48193 1959 32
2339529 2339529 2022-03-24 Hamilton Texas 48193 1959 32
2336275 2336275 2022-03-23 Hamilton Texas 48193 1959 32
2333021 2333021 2022-03-22 Hamilton Texas 48193 1958 32
2329768 2329768 2022-03-21 Hamilton Texas 48193 1958 32
2326516 2326516 2022-03-20 Hamilton Texas 48193 1958 32
2323263 2323263 2022-03-19 Hamilton Texas 48193 1958 32
2320009 2320009 2022-03-18 Hamilton Texas 48193 1958 32
2316755 2316755 2022-03-17 Hamilton Texas 48193 1958 32
2313502 2313502 2022-03-16 Hamilton Texas 48193 1958 32
2310249 2310249 2022-03-15 Hamilton Texas 48193 1958 32
2306996 2306996 2022-03-14 Hamilton Texas 48193 1958 32
2303745 2303745 2022-03-13 Hamilton Texas 48193 1958 32
2300493 2300493 2022-03-12 Hamilton Texas 48193 1958 32
2297241 2297241 2022-03-11 Hamilton Texas 48193 1958 32
2293989 2293989 2022-03-10 Hamilton Texas 48193 1958 32
2290737 2290737 2022-03-09 Hamilton Texas 48193 1958 32
2287485 2287485 2022-03-08 Hamilton Texas 48193 1958 32
2284233 2284233 2022-03-07 Hamilton Texas 48193 1958 32
2280981 2280981 2022-03-06 Hamilton Texas 48193 1958 32
2277728 2277728 2022-03-05 Hamilton Texas 48193 1958 32
2274475 2274475 2022-03-04 Hamilton Texas 48193 1957 32
2271222 2271222 2022-03-03 Hamilton Texas 48193 1957 32
2267970 2267970 2022-03-02 Hamilton Texas 48193 1957 32
2264717 2264717 2022-03-01 Hamilton Texas 48193 1955 31
2261467 2261467 2022-02-28 Hamilton Texas 48193 1954 31
2258216 2258216 2022-02-27 Hamilton Texas 48193 1954 31
2254965 2254965 2022-02-26 Hamilton Texas 48193 1954 31
2251714 2251714 2022-02-25 Hamilton Texas 48193 1954 31
2248463 2248463 2022-02-24 Hamilton Texas 48193 1953 31
2245212 2245212 2022-02-23 Hamilton Texas 48193 1953 30
2241961 2241961 2022-02-22 Hamilton Texas 48193 1953 30
2238710 2238710 2022-02-21 Hamilton Texas 48193 1953 30
2235459 2235459 2022-02-20 Hamilton Texas 48193 1953 30
2232208 2232208 2022-02-19 Hamilton Texas 48193 1953 30
2228957 2228957 2022-02-18 Hamilton Texas 48193 1952 30
2225706 2225706 2022-02-17 Hamilton Texas 48193 1952 30
2222455 2222455 2022-02-16 Hamilton Texas 48193 1951 30
2219204 2219204 2022-02-15 Hamilton Texas 48193 1949 30
2215953 2215953 2022-02-14 Hamilton Texas 48193 1949 30
2212702 2212702 2022-02-13 Hamilton Texas 48193 1949 30
2209449 2209449 2022-02-12 Hamilton Texas 48193 1941 30
2206196 2206196 2022-02-11 Hamilton Texas 48193 1939 30
2202943 2202943 2022-02-10 Hamilton Texas 48193 1937 30
2199689 2199689 2022-02-09 Hamilton Texas 48193 1937 29
2196435 2196435 2022-02-08 Hamilton Texas 48193 1934 29
2193181 2193181 2022-02-07 Hamilton Texas 48193 1933 29
2189927 2189927 2022-02-06 Hamilton Texas 48193 1931 29
2186674 2186674 2022-02-05 Hamilton Texas 48193 1927 29
2183422 2183422 2022-02-04 Hamilton Texas 48193 1925 29
2180170 2180170 2022-02-03 Hamilton Texas 48193 1916 29

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);