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

775 rows where county = "Wayne" and state = "Tennessee" sorted by date descending

✎ View and edit SQL

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

state 1

  • Tennessee · 775 ✖

fips 1

county 1

  • Wayne · 775 ✖
Link rowid date ▲ county state fips cases deaths
2502202 2502202 2022-05-13 Wayne Tennessee 47181 5700 72
2498944 2498944 2022-05-12 Wayne Tennessee 47181 5700 72
2495686 2495686 2022-05-11 Wayne Tennessee 47181 5700 72
2492428 2492428 2022-05-10 Wayne Tennessee 47181 5697 72
2489170 2489170 2022-05-09 Wayne Tennessee 47181 5697 72
2485913 2485913 2022-05-08 Wayne Tennessee 47181 5697 72
2482655 2482655 2022-05-07 Wayne Tennessee 47181 5697 72
2479397 2479397 2022-05-06 Wayne Tennessee 47181 5697 72
2476139 2476139 2022-05-05 Wayne Tennessee 47181 5697 72
2472882 2472882 2022-05-04 Wayne Tennessee 47181 5697 72
2469626 2469626 2022-05-03 Wayne Tennessee 47181 5696 72
2466370 2466370 2022-05-02 Wayne Tennessee 47181 5696 72
2463115 2463115 2022-05-01 Wayne Tennessee 47181 5696 72
2459859 2459859 2022-04-30 Wayne Tennessee 47181 5696 72
2456603 2456603 2022-04-29 Wayne Tennessee 47181 5696 72
2453347 2453347 2022-04-28 Wayne Tennessee 47181 5696 72
2450091 2450091 2022-04-27 Wayne Tennessee 47181 5696 72
2446834 2446834 2022-04-26 Wayne Tennessee 47181 5695 70
2443579 2443579 2022-04-25 Wayne Tennessee 47181 5695 70
2440323 2440323 2022-04-24 Wayne Tennessee 47181 5695 70
2437067 2437067 2022-04-23 Wayne Tennessee 47181 5695 70
2433811 2433811 2022-04-22 Wayne Tennessee 47181 5695 70
2430555 2430555 2022-04-21 Wayne Tennessee 47181 5695 70
2427299 2427299 2022-04-20 Wayne Tennessee 47181 5695 70
2424043 2424043 2022-04-19 Wayne Tennessee 47181 5695 70
2420787 2420787 2022-04-18 Wayne Tennessee 47181 5695 70
2417531 2417531 2022-04-17 Wayne Tennessee 47181 5695 70
2414275 2414275 2022-04-16 Wayne Tennessee 47181 5695 70
2411019 2411019 2022-04-15 Wayne Tennessee 47181 5695 70
2407763 2407763 2022-04-14 Wayne Tennessee 47181 5695 70
2404507 2404507 2022-04-13 Wayne Tennessee 47181 5695 70
2401252 2401252 2022-04-12 Wayne Tennessee 47181 5696 63
2397997 2397997 2022-04-11 Wayne Tennessee 47181 5696 63
2394742 2394742 2022-04-10 Wayne Tennessee 47181 5696 63
2391486 2391486 2022-04-09 Wayne Tennessee 47181 5696 63
2388230 2388230 2022-04-08 Wayne Tennessee 47181 5696 63
2384975 2384975 2022-04-07 Wayne Tennessee 47181 5696 63
2381720 2381720 2022-04-06 Wayne Tennessee 47181 5696 63
2378465 2378465 2022-04-05 Wayne Tennessee 47181 5694 63
2375211 2375211 2022-04-04 Wayne Tennessee 47181 5694 63
2371959 2371959 2022-04-03 Wayne Tennessee 47181 5694 63
2368706 2368706 2022-04-02 Wayne Tennessee 47181 5694 63
2365453 2365453 2022-04-01 Wayne Tennessee 47181 5694 63
2362200 2362200 2022-03-31 Wayne Tennessee 47181 5694 63
2358946 2358946 2022-03-30 Wayne Tennessee 47181 5694 63
2355692 2355692 2022-03-29 Wayne Tennessee 47181 5687 63
2352439 2352439 2022-03-28 Wayne Tennessee 47181 5687 63
2349187 2349187 2022-03-27 Wayne Tennessee 47181 5687 63
2345934 2345934 2022-03-26 Wayne Tennessee 47181 5687 63
2342681 2342681 2022-03-25 Wayne Tennessee 47181 5687 63
2339428 2339428 2022-03-24 Wayne Tennessee 47181 5687 63
2336174 2336174 2022-03-23 Wayne Tennessee 47181 5687 63
2332920 2332920 2022-03-22 Wayne Tennessee 47181 5682 62
2329667 2329667 2022-03-21 Wayne Tennessee 47181 5682 62
2326415 2326415 2022-03-20 Wayne Tennessee 47181 5682 62
2323162 2323162 2022-03-19 Wayne Tennessee 47181 5682 62
2319908 2319908 2022-03-18 Wayne Tennessee 47181 5682 62
2316654 2316654 2022-03-17 Wayne Tennessee 47181 5682 62
2313401 2313401 2022-03-16 Wayne Tennessee 47181 5682 62
2310148 2310148 2022-03-15 Wayne Tennessee 47181 5672 60
2306895 2306895 2022-03-14 Wayne Tennessee 47181 5672 60
2303644 2303644 2022-03-13 Wayne Tennessee 47181 5672 60
2300392 2300392 2022-03-12 Wayne Tennessee 47181 5672 60
2297140 2297140 2022-03-11 Wayne Tennessee 47181 5672 60
2293888 2293888 2022-03-10 Wayne Tennessee 47181 5672 60
2290636 2290636 2022-03-09 Wayne Tennessee 47181 5672 60
2287384 2287384 2022-03-08 Wayne Tennessee 47181 5644 56
2284132 2284132 2022-03-07 Wayne Tennessee 47181 5644 56
2280880 2280880 2022-03-06 Wayne Tennessee 47181 5644 56
2277627 2277627 2022-03-05 Wayne Tennessee 47181 5644 56
2274374 2274374 2022-03-04 Wayne Tennessee 47181 5644 56
2271121 2271121 2022-03-03 Wayne Tennessee 47181 5644 56
2267869 2267869 2022-03-02 Wayne Tennessee 47181 5644 56
2264616 2264616 2022-03-01 Wayne Tennessee 47181 5609 53
2261366 2261366 2022-02-28 Wayne Tennessee 47181 5609 53
2258115 2258115 2022-02-27 Wayne Tennessee 47181 5609 53
2254864 2254864 2022-02-26 Wayne Tennessee 47181 5609 53
2251613 2251613 2022-02-25 Wayne Tennessee 47181 5609 53
2248362 2248362 2022-02-24 Wayne Tennessee 47181 5609 53
2245111 2245111 2022-02-23 Wayne Tennessee 47181 5609 53
2241860 2241860 2022-02-22 Wayne Tennessee 47181 5568 53
2238609 2238609 2022-02-21 Wayne Tennessee 47181 5568 53
2235358 2235358 2022-02-20 Wayne Tennessee 47181 5568 53
2232107 2232107 2022-02-19 Wayne Tennessee 47181 5568 53
2228856 2228856 2022-02-18 Wayne Tennessee 47181 5568 53
2225605 2225605 2022-02-17 Wayne Tennessee 47181 5568 53
2222354 2222354 2022-02-16 Wayne Tennessee 47181 5568 53
2219103 2219103 2022-02-15 Wayne Tennessee 47181 5491 53
2215852 2215852 2022-02-14 Wayne Tennessee 47181 5491 53
2212601 2212601 2022-02-13 Wayne Tennessee 47181 5491 53
2209348 2209348 2022-02-12 Wayne Tennessee 47181 5491 53
2206095 2206095 2022-02-11 Wayne Tennessee 47181 5491 53
2202842 2202842 2022-02-10 Wayne Tennessee 47181 5491 53
2199588 2199588 2022-02-09 Wayne Tennessee 47181 5491 53
2196334 2196334 2022-02-08 Wayne Tennessee 47181 5314 52
2193080 2193080 2022-02-07 Wayne Tennessee 47181 5314 52
2189826 2189826 2022-02-06 Wayne Tennessee 47181 5314 52
2186573 2186573 2022-02-05 Wayne Tennessee 47181 5314 52
2183321 2183321 2022-02-04 Wayne Tennessee 47181 5314 52
2180069 2180069 2022-02-03 Wayne Tennessee 47181 5314 52

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