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

780 rows where county = "Gaines" and state = "Texas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Texas · 780 ✖

fips 1

county 1

  • Gaines · 780 ✖
Link rowid date ▲ county state fips cases deaths
2502289 2502289 2022-05-13 Gaines Texas 48165 2215 83
2499031 2499031 2022-05-12 Gaines Texas 48165 2215 83
2495773 2495773 2022-05-11 Gaines Texas 48165 2215 83
2492515 2492515 2022-05-10 Gaines Texas 48165 2214 83
2489257 2489257 2022-05-09 Gaines Texas 48165 2210 83
2486000 2486000 2022-05-08 Gaines Texas 48165 2210 83
2482742 2482742 2022-05-07 Gaines Texas 48165 2210 83
2479484 2479484 2022-05-06 Gaines Texas 48165 2210 83
2476226 2476226 2022-05-05 Gaines Texas 48165 2208 83
2472969 2472969 2022-05-04 Gaines Texas 48165 2207 83
2469713 2469713 2022-05-03 Gaines Texas 48165 2207 83
2466457 2466457 2022-05-02 Gaines Texas 48165 2207 83
2463202 2463202 2022-05-01 Gaines Texas 48165 2207 83
2459946 2459946 2022-04-30 Gaines Texas 48165 2207 83
2456690 2456690 2022-04-29 Gaines Texas 48165 2207 83
2453434 2453434 2022-04-28 Gaines Texas 48165 2207 83
2450178 2450178 2022-04-27 Gaines Texas 48165 2207 83
2446921 2446921 2022-04-26 Gaines Texas 48165 2207 83
2443666 2443666 2022-04-25 Gaines Texas 48165 2207 83
2440410 2440410 2022-04-24 Gaines Texas 48165 2207 83
2437154 2437154 2022-04-23 Gaines Texas 48165 2207 83
2433898 2433898 2022-04-22 Gaines Texas 48165 2207 83
2430642 2430642 2022-04-21 Gaines Texas 48165 2206 83
2427386 2427386 2022-04-20 Gaines Texas 48165 2206 83
2424130 2424130 2022-04-19 Gaines Texas 48165 2206 83
2420874 2420874 2022-04-18 Gaines Texas 48165 2206 83
2417618 2417618 2022-04-17 Gaines Texas 48165 2206 83
2414362 2414362 2022-04-16 Gaines Texas 48165 2206 83
2411106 2411106 2022-04-15 Gaines Texas 48165 2206 83
2407850 2407850 2022-04-14 Gaines Texas 48165 2206 83
2404594 2404594 2022-04-13 Gaines Texas 48165 2206 83
2401339 2401339 2022-04-12 Gaines Texas 48165 2206 83
2398084 2398084 2022-04-11 Gaines Texas 48165 2193 83
2394829 2394829 2022-04-10 Gaines Texas 48165 2193 83
2391573 2391573 2022-04-09 Gaines Texas 48165 2193 83
2388317 2388317 2022-04-08 Gaines Texas 48165 2179 83
2385062 2385062 2022-04-07 Gaines Texas 48165 2159 83
2381807 2381807 2022-04-06 Gaines Texas 48165 2159 83
2378552 2378552 2022-04-05 Gaines Texas 48165 2158 83
2375298 2375298 2022-04-04 Gaines Texas 48165 2140 83
2372046 2372046 2022-04-03 Gaines Texas 48165 2140 83
2368793 2368793 2022-04-02 Gaines Texas 48165 2140 83
2365540 2365540 2022-04-01 Gaines Texas 48165 2140 83
2362287 2362287 2022-03-31 Gaines Texas 48165 2139 83
2359033 2359033 2022-03-30 Gaines Texas 48165 2139 83
2355779 2355779 2022-03-29 Gaines Texas 48165 2105 83
2352526 2352526 2022-03-28 Gaines Texas 48165 2089 83
2349274 2349274 2022-03-27 Gaines Texas 48165 2089 83
2346021 2346021 2022-03-26 Gaines Texas 48165 2089 83
2342768 2342768 2022-03-25 Gaines Texas 48165 2052 83
2339515 2339515 2022-03-24 Gaines Texas 48165 2052 83
2336261 2336261 2022-03-23 Gaines Texas 48165 2024 83
2333007 2333007 2022-03-22 Gaines Texas 48165 2006 83
2329754 2329754 2022-03-21 Gaines Texas 48165 1988 83
2326502 2326502 2022-03-20 Gaines Texas 48165 1988 83
2323249 2323249 2022-03-19 Gaines Texas 48165 1988 83
2319995 2319995 2022-03-18 Gaines Texas 48165 1958 83
2316741 2316741 2022-03-17 Gaines Texas 48165 1958 83
2313488 2313488 2022-03-16 Gaines Texas 48165 1958 83
2310235 2310235 2022-03-15 Gaines Texas 48165 1958 83
2306982 2306982 2022-03-14 Gaines Texas 48165 1958 83
2303731 2303731 2022-03-13 Gaines Texas 48165 1958 83
2300479 2300479 2022-03-12 Gaines Texas 48165 1958 83
2297227 2297227 2022-03-11 Gaines Texas 48165 1936 83
2293975 2293975 2022-03-10 Gaines Texas 48165 1914 83
2290723 2290723 2022-03-09 Gaines Texas 48165 1886 83
2287471 2287471 2022-03-08 Gaines Texas 48165 1886 83
2284219 2284219 2022-03-07 Gaines Texas 48165 1886 83
2280967 2280967 2022-03-06 Gaines Texas 48165 1885 83
2277714 2277714 2022-03-05 Gaines Texas 48165 1885 83
2274461 2274461 2022-03-04 Gaines Texas 48165 1880 83
2271208 2271208 2022-03-03 Gaines Texas 48165 1880 83
2267956 2267956 2022-03-02 Gaines Texas 48165 1869 82
2264703 2264703 2022-03-01 Gaines Texas 48165 1869 82
2261453 2261453 2022-02-28 Gaines Texas 48165 1869 82
2258202 2258202 2022-02-27 Gaines Texas 48165 1869 82
2254951 2254951 2022-02-26 Gaines Texas 48165 1869 82
2251700 2251700 2022-02-25 Gaines Texas 48165 1869 82
2248449 2248449 2022-02-24 Gaines Texas 48165 1859 82
2245198 2245198 2022-02-23 Gaines Texas 48165 1859 82
2241947 2241947 2022-02-22 Gaines Texas 48165 1853 82
2238696 2238696 2022-02-21 Gaines Texas 48165 1852 81
2235445 2235445 2022-02-20 Gaines Texas 48165 1851 81
2232194 2232194 2022-02-19 Gaines Texas 48165 1851 80
2228943 2228943 2022-02-18 Gaines Texas 48165 1827 79
2225692 2225692 2022-02-17 Gaines Texas 48165 1806 79
2222441 2222441 2022-02-16 Gaines Texas 48165 1801 79
2219190 2219190 2022-02-15 Gaines Texas 48165 1801 78
2215939 2215939 2022-02-14 Gaines Texas 48165 1800 78
2212688 2212688 2022-02-13 Gaines Texas 48165 1799 78
2209435 2209435 2022-02-12 Gaines Texas 48165 1799 78
2206182 2206182 2022-02-11 Gaines Texas 48165 1796 78
2202929 2202929 2022-02-10 Gaines Texas 48165 1776 78
2199675 2199675 2022-02-09 Gaines Texas 48165 1742 78
2196421 2196421 2022-02-08 Gaines Texas 48165 1740 78
2193167 2193167 2022-02-07 Gaines Texas 48165 1738 78
2189913 2189913 2022-02-06 Gaines Texas 48165 1736 78
2186660 2186660 2022-02-05 Gaines Texas 48165 1734 78
2183408 2183408 2022-02-04 Gaines Texas 48165 1734 77
2180156 2180156 2022-02-03 Gaines Texas 48165 1733 76

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