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

773 rows where county = "Clay" and state = "Tennessee" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Tennessee · 773 ✖

fips 1

county 1

  • Clay · 773 ✖
Link rowid date ▲ county state fips cases deaths
2502124 2502124 2022-05-13 Clay Tennessee 47027 2300 50
2498866 2498866 2022-05-12 Clay Tennessee 47027 2300 50
2495608 2495608 2022-05-11 Clay Tennessee 47027 2300 50
2492350 2492350 2022-05-10 Clay Tennessee 47027 2297 50
2489092 2489092 2022-05-09 Clay Tennessee 47027 2297 50
2485835 2485835 2022-05-08 Clay Tennessee 47027 2297 50
2482577 2482577 2022-05-07 Clay Tennessee 47027 2297 50
2479319 2479319 2022-05-06 Clay Tennessee 47027 2297 50
2476061 2476061 2022-05-05 Clay Tennessee 47027 2297 50
2472804 2472804 2022-05-04 Clay Tennessee 47027 2297 50
2469548 2469548 2022-05-03 Clay Tennessee 47027 2296 50
2466292 2466292 2022-05-02 Clay Tennessee 47027 2296 50
2463037 2463037 2022-05-01 Clay Tennessee 47027 2296 50
2459781 2459781 2022-04-30 Clay Tennessee 47027 2296 50
2456525 2456525 2022-04-29 Clay Tennessee 47027 2296 50
2453269 2453269 2022-04-28 Clay Tennessee 47027 2296 50
2450013 2450013 2022-04-27 Clay Tennessee 47027 2296 50
2446756 2446756 2022-04-26 Clay Tennessee 47027 2293 50
2443501 2443501 2022-04-25 Clay Tennessee 47027 2293 50
2440245 2440245 2022-04-24 Clay Tennessee 47027 2293 50
2436989 2436989 2022-04-23 Clay Tennessee 47027 2293 50
2433733 2433733 2022-04-22 Clay Tennessee 47027 2293 50
2430477 2430477 2022-04-21 Clay Tennessee 47027 2293 50
2427221 2427221 2022-04-20 Clay Tennessee 47027 2293 50
2423965 2423965 2022-04-19 Clay Tennessee 47027 2288 50
2420709 2420709 2022-04-18 Clay Tennessee 47027 2288 50
2417453 2417453 2022-04-17 Clay Tennessee 47027 2288 50
2414197 2414197 2022-04-16 Clay Tennessee 47027 2288 50
2410941 2410941 2022-04-15 Clay Tennessee 47027 2288 50
2407685 2407685 2022-04-14 Clay Tennessee 47027 2288 50
2404429 2404429 2022-04-13 Clay Tennessee 47027 2288 50
2401174 2401174 2022-04-12 Clay Tennessee 47027 2287 49
2397919 2397919 2022-04-11 Clay Tennessee 47027 2287 49
2394664 2394664 2022-04-10 Clay Tennessee 47027 2287 49
2391408 2391408 2022-04-09 Clay Tennessee 47027 2287 49
2388152 2388152 2022-04-08 Clay Tennessee 47027 2287 49
2384897 2384897 2022-04-07 Clay Tennessee 47027 2287 49
2381642 2381642 2022-04-06 Clay Tennessee 47027 2287 49
2378387 2378387 2022-04-05 Clay Tennessee 47027 2225 49
2375133 2375133 2022-04-04 Clay Tennessee 47027 2225 49
2371881 2371881 2022-04-03 Clay Tennessee 47027 2225 49
2368628 2368628 2022-04-02 Clay Tennessee 47027 2225 49
2365375 2365375 2022-04-01 Clay Tennessee 47027 2225 49
2362122 2362122 2022-03-31 Clay Tennessee 47027 2225 49
2358868 2358868 2022-03-30 Clay Tennessee 47027 2225 49
2355614 2355614 2022-03-29 Clay Tennessee 47027 2224 49
2352361 2352361 2022-03-28 Clay Tennessee 47027 2224 49
2349109 2349109 2022-03-27 Clay Tennessee 47027 2224 49
2345856 2345856 2022-03-26 Clay Tennessee 47027 2224 49
2342603 2342603 2022-03-25 Clay Tennessee 47027 2224 49
2339350 2339350 2022-03-24 Clay Tennessee 47027 2224 49
2336096 2336096 2022-03-23 Clay Tennessee 47027 2224 49
2332842 2332842 2022-03-22 Clay Tennessee 47027 2223 49
2329589 2329589 2022-03-21 Clay Tennessee 47027 2223 49
2326337 2326337 2022-03-20 Clay Tennessee 47027 2223 49
2323084 2323084 2022-03-19 Clay Tennessee 47027 2223 49
2319830 2319830 2022-03-18 Clay Tennessee 47027 2223 49
2316576 2316576 2022-03-17 Clay Tennessee 47027 2223 49
2313323 2313323 2022-03-16 Clay Tennessee 47027 2223 49
2310070 2310070 2022-03-15 Clay Tennessee 47027 2219 47
2306817 2306817 2022-03-14 Clay Tennessee 47027 2219 47
2303566 2303566 2022-03-13 Clay Tennessee 47027 2219 47
2300314 2300314 2022-03-12 Clay Tennessee 47027 2219 47
2297062 2297062 2022-03-11 Clay Tennessee 47027 2219 47
2293810 2293810 2022-03-10 Clay Tennessee 47027 2219 47
2290558 2290558 2022-03-09 Clay Tennessee 47027 2219 47
2287306 2287306 2022-03-08 Clay Tennessee 47027 2216 46
2284054 2284054 2022-03-07 Clay Tennessee 47027 2216 46
2280802 2280802 2022-03-06 Clay Tennessee 47027 2216 46
2277549 2277549 2022-03-05 Clay Tennessee 47027 2216 46
2274296 2274296 2022-03-04 Clay Tennessee 47027 2216 46
2271043 2271043 2022-03-03 Clay Tennessee 47027 2216 46
2267791 2267791 2022-03-02 Clay Tennessee 47027 2216 46
2264538 2264538 2022-03-01 Clay Tennessee 47027 2207 46
2261288 2261288 2022-02-28 Clay Tennessee 47027 2207 46
2258037 2258037 2022-02-27 Clay Tennessee 47027 2207 46
2254786 2254786 2022-02-26 Clay Tennessee 47027 2207 46
2251535 2251535 2022-02-25 Clay Tennessee 47027 2207 46
2248284 2248284 2022-02-24 Clay Tennessee 47027 2207 46
2245033 2245033 2022-02-23 Clay Tennessee 47027 2207 46
2241782 2241782 2022-02-22 Clay Tennessee 47027 2186 45
2238531 2238531 2022-02-21 Clay Tennessee 47027 2186 45
2235280 2235280 2022-02-20 Clay Tennessee 47027 2186 45
2232029 2232029 2022-02-19 Clay Tennessee 47027 2186 45
2228778 2228778 2022-02-18 Clay Tennessee 47027 2186 45
2225527 2225527 2022-02-17 Clay Tennessee 47027 2186 45
2222276 2222276 2022-02-16 Clay Tennessee 47027 2186 45
2219025 2219025 2022-02-15 Clay Tennessee 47027 2149 45
2215774 2215774 2022-02-14 Clay Tennessee 47027 2149 45
2212523 2212523 2022-02-13 Clay Tennessee 47027 2149 45
2209270 2209270 2022-02-12 Clay Tennessee 47027 2149 45
2206017 2206017 2022-02-11 Clay Tennessee 47027 2149 45
2202764 2202764 2022-02-10 Clay Tennessee 47027 2149 45
2199510 2199510 2022-02-09 Clay Tennessee 47027 2149 45
2196256 2196256 2022-02-08 Clay Tennessee 47027 2021 44
2193002 2193002 2022-02-07 Clay Tennessee 47027 2021 44
2189748 2189748 2022-02-06 Clay Tennessee 47027 2021 44
2186495 2186495 2022-02-05 Clay Tennessee 47027 2021 44
2183243 2183243 2022-02-04 Clay Tennessee 47027 2021 44
2179991 2179991 2022-02-03 Clay Tennessee 47027 2021 44

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