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

776 rows where county = "Henry" and fips = 47079 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 47079 · 776 ✖

county 1

  • Henry · 776 ✖
Link rowid date ▲ county state fips cases deaths
2502150 2502150 2022-05-13 Henry Tennessee 47079 8310 163
2498892 2498892 2022-05-12 Henry Tennessee 47079 8310 163
2495634 2495634 2022-05-11 Henry Tennessee 47079 8310 163
2492376 2492376 2022-05-10 Henry Tennessee 47079 8285 161
2489118 2489118 2022-05-09 Henry Tennessee 47079 8285 161
2485861 2485861 2022-05-08 Henry Tennessee 47079 8285 161
2482603 2482603 2022-05-07 Henry Tennessee 47079 8285 161
2479345 2479345 2022-05-06 Henry Tennessee 47079 8285 161
2476087 2476087 2022-05-05 Henry Tennessee 47079 8285 161
2472830 2472830 2022-05-04 Henry Tennessee 47079 8285 161
2469574 2469574 2022-05-03 Henry Tennessee 47079 8274 161
2466318 2466318 2022-05-02 Henry Tennessee 47079 8274 161
2463063 2463063 2022-05-01 Henry Tennessee 47079 8274 161
2459807 2459807 2022-04-30 Henry Tennessee 47079 8274 161
2456551 2456551 2022-04-29 Henry Tennessee 47079 8274 161
2453295 2453295 2022-04-28 Henry Tennessee 47079 8274 161
2450039 2450039 2022-04-27 Henry Tennessee 47079 8274 161
2446782 2446782 2022-04-26 Henry Tennessee 47079 8268 161
2443527 2443527 2022-04-25 Henry Tennessee 47079 8268 161
2440271 2440271 2022-04-24 Henry Tennessee 47079 8268 161
2437015 2437015 2022-04-23 Henry Tennessee 47079 8268 161
2433759 2433759 2022-04-22 Henry Tennessee 47079 8268 161
2430503 2430503 2022-04-21 Henry Tennessee 47079 8268 161
2427247 2427247 2022-04-20 Henry Tennessee 47079 8268 161
2423991 2423991 2022-04-19 Henry Tennessee 47079 8268 160
2420735 2420735 2022-04-18 Henry Tennessee 47079 8268 160
2417479 2417479 2022-04-17 Henry Tennessee 47079 8268 160
2414223 2414223 2022-04-16 Henry Tennessee 47079 8268 160
2410967 2410967 2022-04-15 Henry Tennessee 47079 8268 160
2407711 2407711 2022-04-14 Henry Tennessee 47079 8268 160
2404455 2404455 2022-04-13 Henry Tennessee 47079 8268 160
2401200 2401200 2022-04-12 Henry Tennessee 47079 8263 157
2397945 2397945 2022-04-11 Henry Tennessee 47079 8263 157
2394690 2394690 2022-04-10 Henry Tennessee 47079 8263 157
2391434 2391434 2022-04-09 Henry Tennessee 47079 8263 157
2388178 2388178 2022-04-08 Henry Tennessee 47079 8263 157
2384923 2384923 2022-04-07 Henry Tennessee 47079 8263 157
2381668 2381668 2022-04-06 Henry Tennessee 47079 8263 157
2378413 2378413 2022-04-05 Henry Tennessee 47079 8252 154
2375159 2375159 2022-04-04 Henry Tennessee 47079 8252 154
2371907 2371907 2022-04-03 Henry Tennessee 47079 8252 154
2368654 2368654 2022-04-02 Henry Tennessee 47079 8252 154
2365401 2365401 2022-04-01 Henry Tennessee 47079 8252 154
2362148 2362148 2022-03-31 Henry Tennessee 47079 8252 154
2358894 2358894 2022-03-30 Henry Tennessee 47079 8252 154
2355640 2355640 2022-03-29 Henry Tennessee 47079 8244 154
2352387 2352387 2022-03-28 Henry Tennessee 47079 8244 154
2349135 2349135 2022-03-27 Henry Tennessee 47079 8244 154
2345882 2345882 2022-03-26 Henry Tennessee 47079 8244 154
2342629 2342629 2022-03-25 Henry Tennessee 47079 8244 154
2339376 2339376 2022-03-24 Henry Tennessee 47079 8244 154
2336122 2336122 2022-03-23 Henry Tennessee 47079 8244 154
2332868 2332868 2022-03-22 Henry Tennessee 47079 8237 154
2329615 2329615 2022-03-21 Henry Tennessee 47079 8237 154
2326363 2326363 2022-03-20 Henry Tennessee 47079 8237 154
2323110 2323110 2022-03-19 Henry Tennessee 47079 8237 154
2319856 2319856 2022-03-18 Henry Tennessee 47079 8237 154
2316602 2316602 2022-03-17 Henry Tennessee 47079 8237 154
2313349 2313349 2022-03-16 Henry Tennessee 47079 8237 154
2310096 2310096 2022-03-15 Henry Tennessee 47079 8221 148
2306843 2306843 2022-03-14 Henry Tennessee 47079 8221 148
2303592 2303592 2022-03-13 Henry Tennessee 47079 8221 148
2300340 2300340 2022-03-12 Henry Tennessee 47079 8221 148
2297088 2297088 2022-03-11 Henry Tennessee 47079 8221 148
2293836 2293836 2022-03-10 Henry Tennessee 47079 8221 148
2290584 2290584 2022-03-09 Henry Tennessee 47079 8221 148
2287332 2287332 2022-03-08 Henry Tennessee 47079 8160 147
2284080 2284080 2022-03-07 Henry Tennessee 47079 8160 147
2280828 2280828 2022-03-06 Henry Tennessee 47079 8160 147
2277575 2277575 2022-03-05 Henry Tennessee 47079 8160 147
2274322 2274322 2022-03-04 Henry Tennessee 47079 8160 147
2271069 2271069 2022-03-03 Henry Tennessee 47079 8160 147
2267817 2267817 2022-03-02 Henry Tennessee 47079 8160 147
2264564 2264564 2022-03-01 Henry Tennessee 47079 8050 140
2261314 2261314 2022-02-28 Henry Tennessee 47079 8050 140
2258063 2258063 2022-02-27 Henry Tennessee 47079 8050 140
2254812 2254812 2022-02-26 Henry Tennessee 47079 8050 140
2251561 2251561 2022-02-25 Henry Tennessee 47079 8050 140
2248310 2248310 2022-02-24 Henry Tennessee 47079 8050 140
2245059 2245059 2022-02-23 Henry Tennessee 47079 8050 140
2241808 2241808 2022-02-22 Henry Tennessee 47079 7914 138
2238557 2238557 2022-02-21 Henry Tennessee 47079 7914 138
2235306 2235306 2022-02-20 Henry Tennessee 47079 7914 138
2232055 2232055 2022-02-19 Henry Tennessee 47079 7914 138
2228804 2228804 2022-02-18 Henry Tennessee 47079 7914 138
2225553 2225553 2022-02-17 Henry Tennessee 47079 7914 138
2222302 2222302 2022-02-16 Henry Tennessee 47079 7914 138
2219051 2219051 2022-02-15 Henry Tennessee 47079 7747 137
2215800 2215800 2022-02-14 Henry Tennessee 47079 7747 137
2212549 2212549 2022-02-13 Henry Tennessee 47079 7747 137
2209296 2209296 2022-02-12 Henry Tennessee 47079 7747 137
2206043 2206043 2022-02-11 Henry Tennessee 47079 7747 137
2202790 2202790 2022-02-10 Henry Tennessee 47079 7747 137
2199536 2199536 2022-02-09 Henry Tennessee 47079 7747 137
2196282 2196282 2022-02-08 Henry Tennessee 47079 7376 132
2193028 2193028 2022-02-07 Henry Tennessee 47079 7376 132
2189774 2189774 2022-02-06 Henry Tennessee 47079 7376 132
2186521 2186521 2022-02-05 Henry Tennessee 47079 7376 132
2183269 2183269 2022-02-04 Henry Tennessee 47079 7376 132
2180017 2180017 2022-02-03 Henry Tennessee 47079 7376 132

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