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

786 rows where fips = 47179 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 · 786 ✖

fips 1

  • 47179 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502201 2502201 2022-05-13 Washington Tennessee 47179 38862 496
2498943 2498943 2022-05-12 Washington Tennessee 47179 38862 496
2495685 2495685 2022-05-11 Washington Tennessee 47179 38862 496
2492427 2492427 2022-05-10 Washington Tennessee 47179 38741 493
2489169 2489169 2022-05-09 Washington Tennessee 47179 38741 493
2485912 2485912 2022-05-08 Washington Tennessee 47179 38741 493
2482654 2482654 2022-05-07 Washington Tennessee 47179 38741 493
2479396 2479396 2022-05-06 Washington Tennessee 47179 38741 493
2476138 2476138 2022-05-05 Washington Tennessee 47179 38741 493
2472881 2472881 2022-05-04 Washington Tennessee 47179 38741 493
2469625 2469625 2022-05-03 Washington Tennessee 47179 38679 493
2466369 2466369 2022-05-02 Washington Tennessee 47179 38679 493
2463114 2463114 2022-05-01 Washington Tennessee 47179 38679 493
2459858 2459858 2022-04-30 Washington Tennessee 47179 38679 493
2456602 2456602 2022-04-29 Washington Tennessee 47179 38679 493
2453346 2453346 2022-04-28 Washington Tennessee 47179 38679 493
2450090 2450090 2022-04-27 Washington Tennessee 47179 38679 493
2446833 2446833 2022-04-26 Washington Tennessee 47179 38629 493
2443578 2443578 2022-04-25 Washington Tennessee 47179 38629 493
2440322 2440322 2022-04-24 Washington Tennessee 47179 38629 493
2437066 2437066 2022-04-23 Washington Tennessee 47179 38629 493
2433810 2433810 2022-04-22 Washington Tennessee 47179 38629 493
2430554 2430554 2022-04-21 Washington Tennessee 47179 38629 493
2427298 2427298 2022-04-20 Washington Tennessee 47179 38629 493
2424042 2424042 2022-04-19 Washington Tennessee 47179 38557 493
2420786 2420786 2022-04-18 Washington Tennessee 47179 38557 493
2417530 2417530 2022-04-17 Washington Tennessee 47179 38557 493
2414274 2414274 2022-04-16 Washington Tennessee 47179 38557 493
2411018 2411018 2022-04-15 Washington Tennessee 47179 38557 493
2407762 2407762 2022-04-14 Washington Tennessee 47179 38557 493
2404506 2404506 2022-04-13 Washington Tennessee 47179 38557 493
2401251 2401251 2022-04-12 Washington Tennessee 47179 38534 489
2397996 2397996 2022-04-11 Washington Tennessee 47179 38534 489
2394741 2394741 2022-04-10 Washington Tennessee 47179 38534 489
2391485 2391485 2022-04-09 Washington Tennessee 47179 38534 489
2388229 2388229 2022-04-08 Washington Tennessee 47179 38534 489
2384974 2384974 2022-04-07 Washington Tennessee 47179 38534 489
2381719 2381719 2022-04-06 Washington Tennessee 47179 38534 489
2378464 2378464 2022-04-05 Washington Tennessee 47179 38495 488
2375210 2375210 2022-04-04 Washington Tennessee 47179 38495 488
2371958 2371958 2022-04-03 Washington Tennessee 47179 38495 488
2368705 2368705 2022-04-02 Washington Tennessee 47179 38495 488
2365452 2365452 2022-04-01 Washington Tennessee 47179 38495 488
2362199 2362199 2022-03-31 Washington Tennessee 47179 38495 488
2358945 2358945 2022-03-30 Washington Tennessee 47179 38495 488
2355691 2355691 2022-03-29 Washington Tennessee 47179 38465 486
2352438 2352438 2022-03-28 Washington Tennessee 47179 38465 486
2349186 2349186 2022-03-27 Washington Tennessee 47179 38465 486
2345933 2345933 2022-03-26 Washington Tennessee 47179 38465 486
2342680 2342680 2022-03-25 Washington Tennessee 47179 38465 486
2339427 2339427 2022-03-24 Washington Tennessee 47179 38465 486
2336173 2336173 2022-03-23 Washington Tennessee 47179 38465 486
2332919 2332919 2022-03-22 Washington Tennessee 47179 38408 482
2329666 2329666 2022-03-21 Washington Tennessee 47179 38408 482
2326414 2326414 2022-03-20 Washington Tennessee 47179 38408 482
2323161 2323161 2022-03-19 Washington Tennessee 47179 38408 482
2319907 2319907 2022-03-18 Washington Tennessee 47179 38408 482
2316653 2316653 2022-03-17 Washington Tennessee 47179 38408 482
2313400 2313400 2022-03-16 Washington Tennessee 47179 38408 482
2310147 2310147 2022-03-15 Washington Tennessee 47179 38342 471
2306894 2306894 2022-03-14 Washington Tennessee 47179 38342 471
2303643 2303643 2022-03-13 Washington Tennessee 47179 38342 471
2300391 2300391 2022-03-12 Washington Tennessee 47179 38342 471
2297139 2297139 2022-03-11 Washington Tennessee 47179 38342 471
2293887 2293887 2022-03-10 Washington Tennessee 47179 38342 471
2290635 2290635 2022-03-09 Washington Tennessee 47179 38342 471
2287383 2287383 2022-03-08 Washington Tennessee 47179 38226 467
2284131 2284131 2022-03-07 Washington Tennessee 47179 38226 467
2280879 2280879 2022-03-06 Washington Tennessee 47179 38226 467
2277626 2277626 2022-03-05 Washington Tennessee 47179 38226 467
2274373 2274373 2022-03-04 Washington Tennessee 47179 38226 467
2271120 2271120 2022-03-03 Washington Tennessee 47179 38226 467
2267868 2267868 2022-03-02 Washington Tennessee 47179 38226 467
2264615 2264615 2022-03-01 Washington Tennessee 47179 37964 461
2261365 2261365 2022-02-28 Washington Tennessee 47179 37964 461
2258114 2258114 2022-02-27 Washington Tennessee 47179 37964 461
2254863 2254863 2022-02-26 Washington Tennessee 47179 37964 461
2251612 2251612 2022-02-25 Washington Tennessee 47179 37964 461
2248361 2248361 2022-02-24 Washington Tennessee 47179 37964 461
2245110 2245110 2022-02-23 Washington Tennessee 47179 37964 461
2241859 2241859 2022-02-22 Washington Tennessee 47179 36643 448
2238608 2238608 2022-02-21 Washington Tennessee 47179 36643 448
2235357 2235357 2022-02-20 Washington Tennessee 47179 36643 448
2232106 2232106 2022-02-19 Washington Tennessee 47179 36643 448
2228855 2228855 2022-02-18 Washington Tennessee 47179 36643 448
2225604 2225604 2022-02-17 Washington Tennessee 47179 36643 448
2222353 2222353 2022-02-16 Washington Tennessee 47179 36643 448
2219102 2219102 2022-02-15 Washington Tennessee 47179 34879 439
2215851 2215851 2022-02-14 Washington Tennessee 47179 34879 439
2212600 2212600 2022-02-13 Washington Tennessee 47179 34879 439
2209347 2209347 2022-02-12 Washington Tennessee 47179 34879 439
2206094 2206094 2022-02-11 Washington Tennessee 47179 34879 439
2202841 2202841 2022-02-10 Washington Tennessee 47179 34879 439
2199587 2199587 2022-02-09 Washington Tennessee 47179 34879 439
2196333 2196333 2022-02-08 Washington Tennessee 47179 33148 432
2193079 2193079 2022-02-07 Washington Tennessee 47179 33148 432
2189825 2189825 2022-02-06 Washington Tennessee 47179 33148 432
2186572 2186572 2022-02-05 Washington Tennessee 47179 33148 432
2183320 2183320 2022-02-04 Washington Tennessee 47179 33148 432
2180068 2180068 2022-02-03 Washington Tennessee 47179 33148 432

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