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 = "Mitchell" 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 · 767 ✖

fips 1

county 1

  • Mitchell · 767 ✖
Link rowid date ▲ county state fips cases deaths
2502374 2502374 2022-05-13 Mitchell Texas 48335 1864 49
2499116 2499116 2022-05-12 Mitchell Texas 48335 1864 49
2495858 2495858 2022-05-11 Mitchell Texas 48335 1864 48
2492600 2492600 2022-05-10 Mitchell Texas 48335 1864 48
2489342 2489342 2022-05-09 Mitchell Texas 48335 1864 48
2486085 2486085 2022-05-08 Mitchell Texas 48335 1864 48
2482827 2482827 2022-05-07 Mitchell Texas 48335 1864 48
2479569 2479569 2022-05-06 Mitchell Texas 48335 1864 48
2476311 2476311 2022-05-05 Mitchell Texas 48335 1864 48
2473054 2473054 2022-05-04 Mitchell Texas 48335 1864 48
2469798 2469798 2022-05-03 Mitchell Texas 48335 1864 48
2466542 2466542 2022-05-02 Mitchell Texas 48335 1864 48
2463287 2463287 2022-05-01 Mitchell Texas 48335 1864 48
2460031 2460031 2022-04-30 Mitchell Texas 48335 1864 48
2456775 2456775 2022-04-29 Mitchell Texas 48335 1864 48
2453519 2453519 2022-04-28 Mitchell Texas 48335 1864 48
2450263 2450263 2022-04-27 Mitchell Texas 48335 1864 48
2447006 2447006 2022-04-26 Mitchell Texas 48335 1864 48
2443751 2443751 2022-04-25 Mitchell Texas 48335 1864 48
2440495 2440495 2022-04-24 Mitchell Texas 48335 1864 48
2437239 2437239 2022-04-23 Mitchell Texas 48335 1864 48
2433983 2433983 2022-04-22 Mitchell Texas 48335 1864 48
2430727 2430727 2022-04-21 Mitchell Texas 48335 1863 48
2427471 2427471 2022-04-20 Mitchell Texas 48335 1863 48
2424215 2424215 2022-04-19 Mitchell Texas 48335 1863 48
2420959 2420959 2022-04-18 Mitchell Texas 48335 1863 48
2417703 2417703 2022-04-17 Mitchell Texas 48335 1863 48
2414447 2414447 2022-04-16 Mitchell Texas 48335 1863 48
2411191 2411191 2022-04-15 Mitchell Texas 48335 1863 48
2407935 2407935 2022-04-14 Mitchell Texas 48335 1863 48
2404679 2404679 2022-04-13 Mitchell Texas 48335 1863 48
2401424 2401424 2022-04-12 Mitchell Texas 48335 1863 48
2398169 2398169 2022-04-11 Mitchell Texas 48335 1863 48
2394914 2394914 2022-04-10 Mitchell Texas 48335 1863 48
2391658 2391658 2022-04-09 Mitchell Texas 48335 1862 48
2388402 2388402 2022-04-08 Mitchell Texas 48335 1862 48
2385147 2385147 2022-04-07 Mitchell Texas 48335 1862 48
2381892 2381892 2022-04-06 Mitchell Texas 48335 1862 48
2378637 2378637 2022-04-05 Mitchell Texas 48335 1862 48
2375383 2375383 2022-04-04 Mitchell Texas 48335 1862 48
2372131 2372131 2022-04-03 Mitchell Texas 48335 1862 48
2368878 2368878 2022-04-02 Mitchell Texas 48335 1862 48
2365625 2365625 2022-04-01 Mitchell Texas 48335 1862 48
2362372 2362372 2022-03-31 Mitchell Texas 48335 1861 48
2359118 2359118 2022-03-30 Mitchell Texas 48335 1861 48
2355864 2355864 2022-03-29 Mitchell Texas 48335 1861 48
2352611 2352611 2022-03-28 Mitchell Texas 48335 1861 48
2349359 2349359 2022-03-27 Mitchell Texas 48335 1861 47
2346106 2346106 2022-03-26 Mitchell Texas 48335 1861 47
2342853 2342853 2022-03-25 Mitchell Texas 48335 1861 47
2339600 2339600 2022-03-24 Mitchell Texas 48335 1861 47
2336346 2336346 2022-03-23 Mitchell Texas 48335 1861 47
2333092 2333092 2022-03-22 Mitchell Texas 48335 1861 47
2329839 2329839 2022-03-21 Mitchell Texas 48335 1861 47
2326587 2326587 2022-03-20 Mitchell Texas 48335 1861 47
2323334 2323334 2022-03-19 Mitchell Texas 48335 1861 47
2320080 2320080 2022-03-18 Mitchell Texas 48335 1861 47
2316826 2316826 2022-03-17 Mitchell Texas 48335 1861 47
2313573 2313573 2022-03-16 Mitchell Texas 48335 1861 47
2310320 2310320 2022-03-15 Mitchell Texas 48335 1861 47
2307067 2307067 2022-03-14 Mitchell Texas 48335 1861 47
2303816 2303816 2022-03-13 Mitchell Texas 48335 1861 47
2300564 2300564 2022-03-12 Mitchell Texas 48335 1861 47
2297312 2297312 2022-03-11 Mitchell Texas 48335 1861 47
2294060 2294060 2022-03-10 Mitchell Texas 48335 1861 47
2290808 2290808 2022-03-09 Mitchell Texas 48335 1861 47
2287556 2287556 2022-03-08 Mitchell Texas 48335 1861 47
2284304 2284304 2022-03-07 Mitchell Texas 48335 1861 47
2281052 2281052 2022-03-06 Mitchell Texas 48335 1861 47
2277799 2277799 2022-03-05 Mitchell Texas 48335 1861 47
2274546 2274546 2022-03-04 Mitchell Texas 48335 1860 47
2271293 2271293 2022-03-03 Mitchell Texas 48335 1860 47
2268041 2268041 2022-03-02 Mitchell Texas 48335 1859 47
2264788 2264788 2022-03-01 Mitchell Texas 48335 1859 47
2261538 2261538 2022-02-28 Mitchell Texas 48335 1859 47
2258287 2258287 2022-02-27 Mitchell Texas 48335 1859 47
2255036 2255036 2022-02-26 Mitchell Texas 48335 1859 47
2251785 2251785 2022-02-25 Mitchell Texas 48335 1859 46
2248534 2248534 2022-02-24 Mitchell Texas 48335 1859 46
2245283 2245283 2022-02-23 Mitchell Texas 48335 1859 46
2242032 2242032 2022-02-22 Mitchell Texas 48335 1857 46
2238781 2238781 2022-02-21 Mitchell Texas 48335 1857 46
2235530 2235530 2022-02-20 Mitchell Texas 48335 1857 46
2232279 2232279 2022-02-19 Mitchell Texas 48335 1856 46
2229028 2229028 2022-02-18 Mitchell Texas 48335 1851 46
2225777 2225777 2022-02-17 Mitchell Texas 48335 1841 46
2222526 2222526 2022-02-16 Mitchell Texas 48335 1838 46
2219275 2219275 2022-02-15 Mitchell Texas 48335 1837 46
2216024 2216024 2022-02-14 Mitchell Texas 48335 1835 46
2212773 2212773 2022-02-13 Mitchell Texas 48335 1835 46
2209520 2209520 2022-02-12 Mitchell Texas 48335 1835 46
2206267 2206267 2022-02-11 Mitchell Texas 48335 1834 46
2203014 2203014 2022-02-10 Mitchell Texas 48335 1832 46
2199760 2199760 2022-02-09 Mitchell Texas 48335 1830 46
2196506 2196506 2022-02-08 Mitchell Texas 48335 1820 46
2193252 2193252 2022-02-07 Mitchell Texas 48335 1810 46
2189998 2189998 2022-02-06 Mitchell Texas 48335 1810 46
2186745 2186745 2022-02-05 Mitchell Texas 48335 1809 46
2183493 2183493 2022-02-04 Mitchell Texas 48335 1809 46
2180241 2180241 2022-02-03 Mitchell Texas 48335 1809 46

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