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

778 rows where county = "Smith" 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 · 778 ✖

fips 1

county 1

  • Smith · 778 ✖
Link rowid date ▲ county state fips cases deaths
2502190 2502190 2022-05-13 Smith Tennessee 47159 6171 85
2498932 2498932 2022-05-12 Smith Tennessee 47159 6171 85
2495674 2495674 2022-05-11 Smith Tennessee 47159 6171 85
2492416 2492416 2022-05-10 Smith Tennessee 47159 6168 85
2489158 2489158 2022-05-09 Smith Tennessee 47159 6168 85
2485901 2485901 2022-05-08 Smith Tennessee 47159 6168 85
2482643 2482643 2022-05-07 Smith Tennessee 47159 6168 85
2479385 2479385 2022-05-06 Smith Tennessee 47159 6168 85
2476127 2476127 2022-05-05 Smith Tennessee 47159 6168 85
2472870 2472870 2022-05-04 Smith Tennessee 47159 6168 85
2469614 2469614 2022-05-03 Smith Tennessee 47159 6163 84
2466358 2466358 2022-05-02 Smith Tennessee 47159 6163 84
2463103 2463103 2022-05-01 Smith Tennessee 47159 6163 84
2459847 2459847 2022-04-30 Smith Tennessee 47159 6163 84
2456591 2456591 2022-04-29 Smith Tennessee 47159 6163 84
2453335 2453335 2022-04-28 Smith Tennessee 47159 6163 84
2450079 2450079 2022-04-27 Smith Tennessee 47159 6163 84
2446822 2446822 2022-04-26 Smith Tennessee 47159 6163 84
2443567 2443567 2022-04-25 Smith Tennessee 47159 6163 84
2440311 2440311 2022-04-24 Smith Tennessee 47159 6163 84
2437055 2437055 2022-04-23 Smith Tennessee 47159 6163 84
2433799 2433799 2022-04-22 Smith Tennessee 47159 6163 84
2430543 2430543 2022-04-21 Smith Tennessee 47159 6163 84
2427287 2427287 2022-04-20 Smith Tennessee 47159 6163 84
2424031 2424031 2022-04-19 Smith Tennessee 47159 6161 84
2420775 2420775 2022-04-18 Smith Tennessee 47159 6161 84
2417519 2417519 2022-04-17 Smith Tennessee 47159 6161 84
2414263 2414263 2022-04-16 Smith Tennessee 47159 6161 84
2411007 2411007 2022-04-15 Smith Tennessee 47159 6161 84
2407751 2407751 2022-04-14 Smith Tennessee 47159 6161 84
2404495 2404495 2022-04-13 Smith Tennessee 47159 6161 84
2401240 2401240 2022-04-12 Smith Tennessee 47159 6160 83
2397985 2397985 2022-04-11 Smith Tennessee 47159 6160 83
2394730 2394730 2022-04-10 Smith Tennessee 47159 6160 83
2391474 2391474 2022-04-09 Smith Tennessee 47159 6160 83
2388218 2388218 2022-04-08 Smith Tennessee 47159 6160 83
2384963 2384963 2022-04-07 Smith Tennessee 47159 6160 83
2381708 2381708 2022-04-06 Smith Tennessee 47159 6160 83
2378453 2378453 2022-04-05 Smith Tennessee 47159 6158 83
2375199 2375199 2022-04-04 Smith Tennessee 47159 6158 83
2371947 2371947 2022-04-03 Smith Tennessee 47159 6158 83
2368694 2368694 2022-04-02 Smith Tennessee 47159 6158 83
2365441 2365441 2022-04-01 Smith Tennessee 47159 6158 83
2362188 2362188 2022-03-31 Smith Tennessee 47159 6158 83
2358934 2358934 2022-03-30 Smith Tennessee 47159 6158 83
2355680 2355680 2022-03-29 Smith Tennessee 47159 6157 83
2352427 2352427 2022-03-28 Smith Tennessee 47159 6157 83
2349175 2349175 2022-03-27 Smith Tennessee 47159 6157 83
2345922 2345922 2022-03-26 Smith Tennessee 47159 6157 83
2342669 2342669 2022-03-25 Smith Tennessee 47159 6157 83
2339416 2339416 2022-03-24 Smith Tennessee 47159 6157 83
2336162 2336162 2022-03-23 Smith Tennessee 47159 6157 83
2332908 2332908 2022-03-22 Smith Tennessee 47159 6159 80
2329655 2329655 2022-03-21 Smith Tennessee 47159 6159 80
2326403 2326403 2022-03-20 Smith Tennessee 47159 6159 80
2323150 2323150 2022-03-19 Smith Tennessee 47159 6159 80
2319896 2319896 2022-03-18 Smith Tennessee 47159 6159 80
2316642 2316642 2022-03-17 Smith Tennessee 47159 6159 80
2313389 2313389 2022-03-16 Smith Tennessee 47159 6159 80
2310136 2310136 2022-03-15 Smith Tennessee 47159 6154 76
2306883 2306883 2022-03-14 Smith Tennessee 47159 6154 76
2303632 2303632 2022-03-13 Smith Tennessee 47159 6154 76
2300380 2300380 2022-03-12 Smith Tennessee 47159 6154 76
2297128 2297128 2022-03-11 Smith Tennessee 47159 6154 76
2293876 2293876 2022-03-10 Smith Tennessee 47159 6154 76
2290624 2290624 2022-03-09 Smith Tennessee 47159 6154 76
2287372 2287372 2022-03-08 Smith Tennessee 47159 6149 74
2284120 2284120 2022-03-07 Smith Tennessee 47159 6149 74
2280868 2280868 2022-03-06 Smith Tennessee 47159 6149 74
2277615 2277615 2022-03-05 Smith Tennessee 47159 6149 74
2274362 2274362 2022-03-04 Smith Tennessee 47159 6149 74
2271109 2271109 2022-03-03 Smith Tennessee 47159 6149 74
2267857 2267857 2022-03-02 Smith Tennessee 47159 6149 74
2264604 2264604 2022-03-01 Smith Tennessee 47159 6102 73
2261354 2261354 2022-02-28 Smith Tennessee 47159 6102 73
2258103 2258103 2022-02-27 Smith Tennessee 47159 6102 73
2254852 2254852 2022-02-26 Smith Tennessee 47159 6102 73
2251601 2251601 2022-02-25 Smith Tennessee 47159 6102 73
2248350 2248350 2022-02-24 Smith Tennessee 47159 6102 73
2245099 2245099 2022-02-23 Smith Tennessee 47159 6102 73
2241848 2241848 2022-02-22 Smith Tennessee 47159 6010 73
2238597 2238597 2022-02-21 Smith Tennessee 47159 6010 73
2235346 2235346 2022-02-20 Smith Tennessee 47159 6010 73
2232095 2232095 2022-02-19 Smith Tennessee 47159 6010 73
2228844 2228844 2022-02-18 Smith Tennessee 47159 6010 73
2225593 2225593 2022-02-17 Smith Tennessee 47159 6010 73
2222342 2222342 2022-02-16 Smith Tennessee 47159 6010 73
2219091 2219091 2022-02-15 Smith Tennessee 47159 5886 72
2215840 2215840 2022-02-14 Smith Tennessee 47159 5886 72
2212589 2212589 2022-02-13 Smith Tennessee 47159 5886 72
2209336 2209336 2022-02-12 Smith Tennessee 47159 5886 72
2206083 2206083 2022-02-11 Smith Tennessee 47159 5886 72
2202830 2202830 2022-02-10 Smith Tennessee 47159 5886 72
2199576 2199576 2022-02-09 Smith Tennessee 47159 5886 72
2196322 2196322 2022-02-08 Smith Tennessee 47159 5523 71
2193068 2193068 2022-02-07 Smith Tennessee 47159 5523 71
2189814 2189814 2022-02-06 Smith Tennessee 47159 5523 71
2186561 2186561 2022-02-05 Smith Tennessee 47159 5523 71
2183309 2183309 2022-02-04 Smith Tennessee 47159 5523 71
2180057 2180057 2022-02-03 Smith Tennessee 47159 5523 71

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