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

772 rows where county = "Polk" 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 · 772 ✖

fips 1

county 1

  • Polk · 772 ✖
Link rowid date ▲ county state fips cases deaths
2502180 2502180 2022-05-13 Polk Tennessee 47139 4740 74
2498922 2498922 2022-05-12 Polk Tennessee 47139 4740 74
2495664 2495664 2022-05-11 Polk Tennessee 47139 4740 74
2492406 2492406 2022-05-10 Polk Tennessee 47139 4738 74
2489148 2489148 2022-05-09 Polk Tennessee 47139 4738 74
2485891 2485891 2022-05-08 Polk Tennessee 47139 4738 74
2482633 2482633 2022-05-07 Polk Tennessee 47139 4738 74
2479375 2479375 2022-05-06 Polk Tennessee 47139 4738 74
2476117 2476117 2022-05-05 Polk Tennessee 47139 4738 74
2472860 2472860 2022-05-04 Polk Tennessee 47139 4738 74
2469604 2469604 2022-05-03 Polk Tennessee 47139 4738 74
2466348 2466348 2022-05-02 Polk Tennessee 47139 4738 74
2463093 2463093 2022-05-01 Polk Tennessee 47139 4738 74
2459837 2459837 2022-04-30 Polk Tennessee 47139 4738 74
2456581 2456581 2022-04-29 Polk Tennessee 47139 4738 74
2453325 2453325 2022-04-28 Polk Tennessee 47139 4738 74
2450069 2450069 2022-04-27 Polk Tennessee 47139 4738 74
2446812 2446812 2022-04-26 Polk Tennessee 47139 4735 74
2443557 2443557 2022-04-25 Polk Tennessee 47139 4735 74
2440301 2440301 2022-04-24 Polk Tennessee 47139 4735 74
2437045 2437045 2022-04-23 Polk Tennessee 47139 4735 74
2433789 2433789 2022-04-22 Polk Tennessee 47139 4735 74
2430533 2430533 2022-04-21 Polk Tennessee 47139 4735 74
2427277 2427277 2022-04-20 Polk Tennessee 47139 4735 74
2424021 2424021 2022-04-19 Polk Tennessee 47139 4732 72
2420765 2420765 2022-04-18 Polk Tennessee 47139 4732 72
2417509 2417509 2022-04-17 Polk Tennessee 47139 4732 72
2414253 2414253 2022-04-16 Polk Tennessee 47139 4732 72
2410997 2410997 2022-04-15 Polk Tennessee 47139 4732 72
2407741 2407741 2022-04-14 Polk Tennessee 47139 4732 72
2404485 2404485 2022-04-13 Polk Tennessee 47139 4732 72
2401230 2401230 2022-04-12 Polk Tennessee 47139 4729 71
2397975 2397975 2022-04-11 Polk Tennessee 47139 4729 71
2394720 2394720 2022-04-10 Polk Tennessee 47139 4729 71
2391464 2391464 2022-04-09 Polk Tennessee 47139 4729 71
2388208 2388208 2022-04-08 Polk Tennessee 47139 4729 71
2384953 2384953 2022-04-07 Polk Tennessee 47139 4729 71
2381698 2381698 2022-04-06 Polk Tennessee 47139 4729 71
2378443 2378443 2022-04-05 Polk Tennessee 47139 4728 70
2375189 2375189 2022-04-04 Polk Tennessee 47139 4728 70
2371937 2371937 2022-04-03 Polk Tennessee 47139 4728 70
2368684 2368684 2022-04-02 Polk Tennessee 47139 4728 70
2365431 2365431 2022-04-01 Polk Tennessee 47139 4728 70
2362178 2362178 2022-03-31 Polk Tennessee 47139 4728 70
2358924 2358924 2022-03-30 Polk Tennessee 47139 4728 70
2355670 2355670 2022-03-29 Polk Tennessee 47139 4722 70
2352417 2352417 2022-03-28 Polk Tennessee 47139 4722 70
2349165 2349165 2022-03-27 Polk Tennessee 47139 4722 70
2345912 2345912 2022-03-26 Polk Tennessee 47139 4722 70
2342659 2342659 2022-03-25 Polk Tennessee 47139 4722 70
2339406 2339406 2022-03-24 Polk Tennessee 47139 4722 70
2336152 2336152 2022-03-23 Polk Tennessee 47139 4722 70
2332898 2332898 2022-03-22 Polk Tennessee 47139 4715 68
2329645 2329645 2022-03-21 Polk Tennessee 47139 4715 68
2326393 2326393 2022-03-20 Polk Tennessee 47139 4715 68
2323140 2323140 2022-03-19 Polk Tennessee 47139 4715 68
2319886 2319886 2022-03-18 Polk Tennessee 47139 4715 68
2316632 2316632 2022-03-17 Polk Tennessee 47139 4715 68
2313379 2313379 2022-03-16 Polk Tennessee 47139 4715 68
2310126 2310126 2022-03-15 Polk Tennessee 47139 4711 65
2306873 2306873 2022-03-14 Polk Tennessee 47139 4711 65
2303622 2303622 2022-03-13 Polk Tennessee 47139 4711 65
2300370 2300370 2022-03-12 Polk Tennessee 47139 4711 65
2297118 2297118 2022-03-11 Polk Tennessee 47139 4711 65
2293866 2293866 2022-03-10 Polk Tennessee 47139 4711 65
2290614 2290614 2022-03-09 Polk Tennessee 47139 4711 65
2287362 2287362 2022-03-08 Polk Tennessee 47139 4670 65
2284110 2284110 2022-03-07 Polk Tennessee 47139 4670 65
2280858 2280858 2022-03-06 Polk Tennessee 47139 4670 65
2277605 2277605 2022-03-05 Polk Tennessee 47139 4670 65
2274352 2274352 2022-03-04 Polk Tennessee 47139 4670 65
2271099 2271099 2022-03-03 Polk Tennessee 47139 4670 65
2267847 2267847 2022-03-02 Polk Tennessee 47139 4670 65
2264594 2264594 2022-03-01 Polk Tennessee 47139 4624 56
2261344 2261344 2022-02-28 Polk Tennessee 47139 4624 56
2258093 2258093 2022-02-27 Polk Tennessee 47139 4624 56
2254842 2254842 2022-02-26 Polk Tennessee 47139 4624 56
2251591 2251591 2022-02-25 Polk Tennessee 47139 4624 56
2248340 2248340 2022-02-24 Polk Tennessee 47139 4624 56
2245089 2245089 2022-02-23 Polk Tennessee 47139 4624 56
2241838 2241838 2022-02-22 Polk Tennessee 47139 4568 54
2238587 2238587 2022-02-21 Polk Tennessee 47139 4568 54
2235336 2235336 2022-02-20 Polk Tennessee 47139 4568 54
2232085 2232085 2022-02-19 Polk Tennessee 47139 4568 54
2228834 2228834 2022-02-18 Polk Tennessee 47139 4568 54
2225583 2225583 2022-02-17 Polk Tennessee 47139 4568 54
2222332 2222332 2022-02-16 Polk Tennessee 47139 4568 54
2219081 2219081 2022-02-15 Polk Tennessee 47139 4481 53
2215830 2215830 2022-02-14 Polk Tennessee 47139 4481 53
2212579 2212579 2022-02-13 Polk Tennessee 47139 4481 53
2209326 2209326 2022-02-12 Polk Tennessee 47139 4481 53
2206073 2206073 2022-02-11 Polk Tennessee 47139 4481 53
2202820 2202820 2022-02-10 Polk Tennessee 47139 4481 53
2199566 2199566 2022-02-09 Polk Tennessee 47139 4481 53
2196312 2196312 2022-02-08 Polk Tennessee 47139 4326 52
2193058 2193058 2022-02-07 Polk Tennessee 47139 4326 52
2189804 2189804 2022-02-06 Polk Tennessee 47139 4326 52
2186551 2186551 2022-02-05 Polk Tennessee 47139 4326 52
2183299 2183299 2022-02-04 Polk Tennessee 47139 4326 52
2180047 2180047 2022-02-03 Polk Tennessee 47139 4326 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);