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

764 rows where county = "Stephens", fips = 48429 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 · 764 ✖

fips 1

  • 48429 · 764 ✖

county 1

  • Stephens · 764 ✖
Link rowid date ▲ county state fips cases deaths
2502422 2502422 2022-05-13 Stephens Texas 48429 1846 46
2499164 2499164 2022-05-12 Stephens Texas 48429 1845 46
2495906 2495906 2022-05-11 Stephens Texas 48429 1845 46
2492648 2492648 2022-05-10 Stephens Texas 48429 1845 45
2489390 2489390 2022-05-09 Stephens Texas 48429 1844 45
2486132 2486132 2022-05-08 Stephens Texas 48429 1844 45
2482874 2482874 2022-05-07 Stephens Texas 48429 1844 45
2479616 2479616 2022-05-06 Stephens Texas 48429 1844 45
2476358 2476358 2022-05-05 Stephens Texas 48429 1843 45
2473101 2473101 2022-05-04 Stephens Texas 48429 1843 45
2469845 2469845 2022-05-03 Stephens Texas 48429 1843 45
2466589 2466589 2022-05-02 Stephens Texas 48429 1843 45
2463334 2463334 2022-05-01 Stephens Texas 48429 1843 45
2460078 2460078 2022-04-30 Stephens Texas 48429 1843 45
2456822 2456822 2022-04-29 Stephens Texas 48429 1842 45
2453566 2453566 2022-04-28 Stephens Texas 48429 1842 45
2450310 2450310 2022-04-27 Stephens Texas 48429 1842 45
2447053 2447053 2022-04-26 Stephens Texas 48429 1842 45
2443798 2443798 2022-04-25 Stephens Texas 48429 1842 45
2440542 2440542 2022-04-24 Stephens Texas 48429 1842 45
2437286 2437286 2022-04-23 Stephens Texas 48429 1842 45
2434030 2434030 2022-04-22 Stephens Texas 48429 1842 45
2430774 2430774 2022-04-21 Stephens Texas 48429 1842 45
2427518 2427518 2022-04-20 Stephens Texas 48429 1842 45
2424262 2424262 2022-04-19 Stephens Texas 48429 1841 45
2421006 2421006 2022-04-18 Stephens Texas 48429 1841 45
2417750 2417750 2022-04-17 Stephens Texas 48429 1837 45
2414494 2414494 2022-04-16 Stephens Texas 48429 1837 45
2411238 2411238 2022-04-15 Stephens Texas 48429 1837 45
2407982 2407982 2022-04-14 Stephens Texas 48429 1837 45
2404726 2404726 2022-04-13 Stephens Texas 48429 1836 45
2401471 2401471 2022-04-12 Stephens Texas 48429 1836 45
2398216 2398216 2022-04-11 Stephens Texas 48429 1836 45
2394961 2394961 2022-04-10 Stephens Texas 48429 1836 45
2391705 2391705 2022-04-09 Stephens Texas 48429 1836 45
2388449 2388449 2022-04-08 Stephens Texas 48429 1833 45
2385194 2385194 2022-04-07 Stephens Texas 48429 1833 45
2381939 2381939 2022-04-06 Stephens Texas 48429 1833 45
2378684 2378684 2022-04-05 Stephens Texas 48429 1833 45
2375430 2375430 2022-04-04 Stephens Texas 48429 1832 45
2372178 2372178 2022-04-03 Stephens Texas 48429 1832 45
2368925 2368925 2022-04-02 Stephens Texas 48429 1832 45
2365672 2365672 2022-04-01 Stephens Texas 48429 1832 45
2362419 2362419 2022-03-31 Stephens Texas 48429 1832 45
2359165 2359165 2022-03-30 Stephens Texas 48429 1832 45
2355911 2355911 2022-03-29 Stephens Texas 48429 1832 45
2352658 2352658 2022-03-28 Stephens Texas 48429 1831 45
2349406 2349406 2022-03-27 Stephens Texas 48429 1831 45
2346153 2346153 2022-03-26 Stephens Texas 48429 1831 45
2342900 2342900 2022-03-25 Stephens Texas 48429 1829 45
2339647 2339647 2022-03-24 Stephens Texas 48429 1829 45
2336393 2336393 2022-03-23 Stephens Texas 48429 1828 45
2333139 2333139 2022-03-22 Stephens Texas 48429 1827 45
2329886 2329886 2022-03-21 Stephens Texas 48429 1827 45
2326634 2326634 2022-03-20 Stephens Texas 48429 1826 45
2323381 2323381 2022-03-19 Stephens Texas 48429 1826 45
2320127 2320127 2022-03-18 Stephens Texas 48429 1826 45
2316873 2316873 2022-03-17 Stephens Texas 48429 1822 45
2313620 2313620 2022-03-16 Stephens Texas 48429 1818 46
2310367 2310367 2022-03-15 Stephens Texas 48429 1818 46
2307114 2307114 2022-03-14 Stephens Texas 48429 1818 46
2303863 2303863 2022-03-13 Stephens Texas 48429 1818 46
2300611 2300611 2022-03-12 Stephens Texas 48429 1818 46
2297359 2297359 2022-03-11 Stephens Texas 48429 1817 46
2294107 2294107 2022-03-10 Stephens Texas 48429 1816 45
2290855 2290855 2022-03-09 Stephens Texas 48429 1807 45
2287603 2287603 2022-03-08 Stephens Texas 48429 1806 45
2284351 2284351 2022-03-07 Stephens Texas 48429 1806 45
2281099 2281099 2022-03-06 Stephens Texas 48429 1805 45
2277846 2277846 2022-03-05 Stephens Texas 48429 1805 45
2274593 2274593 2022-03-04 Stephens Texas 48429 1802 45
2271340 2271340 2022-03-03 Stephens Texas 48429 1802 45
2268088 2268088 2022-03-02 Stephens Texas 48429 1802 44
2264835 2264835 2022-03-01 Stephens Texas 48429 1800 44
2261585 2261585 2022-02-28 Stephens Texas 48429 1797 44
2258334 2258334 2022-02-27 Stephens Texas 48429 1797 44
2255083 2255083 2022-02-26 Stephens Texas 48429 1797 44
2251832 2251832 2022-02-25 Stephens Texas 48429 1795 44
2248581 2248581 2022-02-24 Stephens Texas 48429 1793 42
2245330 2245330 2022-02-23 Stephens Texas 48429 1793 42
2242079 2242079 2022-02-22 Stephens Texas 48429 1793 41
2238828 2238828 2022-02-21 Stephens Texas 48429 1793 40
2235577 2235577 2022-02-20 Stephens Texas 48429 1793 40
2232326 2232326 2022-02-19 Stephens Texas 48429 1793 40
2229075 2229075 2022-02-18 Stephens Texas 48429 1785 40
2225824 2225824 2022-02-17 Stephens Texas 48429 1783 40
2222573 2222573 2022-02-16 Stephens Texas 48429 1782 39
2219322 2219322 2022-02-15 Stephens Texas 48429 1778 39
2216071 2216071 2022-02-14 Stephens Texas 48429 1774 39
2212820 2212820 2022-02-13 Stephens Texas 48429 1773 39
2209567 2209567 2022-02-12 Stephens Texas 48429 1767 39
2206314 2206314 2022-02-11 Stephens Texas 48429 1767 39
2203061 2203061 2022-02-10 Stephens Texas 48429 1766 39
2199807 2199807 2022-02-09 Stephens Texas 48429 1761 39
2196553 2196553 2022-02-08 Stephens Texas 48429 1753 39
2193299 2193299 2022-02-07 Stephens Texas 48429 1751 39
2190045 2190045 2022-02-06 Stephens Texas 48429 1749 39
2186792 2186792 2022-02-05 Stephens Texas 48429 1748 39
2183540 2183540 2022-02-04 Stephens Texas 48429 1747 39
2180288 2180288 2022-02-03 Stephens Texas 48429 1737 39

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