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

725 rows where fips = 47067 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

  • 47067 · 725 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502144 2502144 2022-05-13 Hancock Tennessee 47067 2023 37
2498886 2498886 2022-05-12 Hancock Tennessee 47067 2023 37
2495628 2495628 2022-05-11 Hancock Tennessee 47067 2023 37
2492370 2492370 2022-05-10 Hancock Tennessee 47067 2013 37
2489112 2489112 2022-05-09 Hancock Tennessee 47067 2013 37
2485855 2485855 2022-05-08 Hancock Tennessee 47067 2013 37
2482597 2482597 2022-05-07 Hancock Tennessee 47067 2013 37
2479339 2479339 2022-05-06 Hancock Tennessee 47067 2013 37
2476081 2476081 2022-05-05 Hancock Tennessee 47067 2013 37
2472824 2472824 2022-05-04 Hancock Tennessee 47067 2013 37
2469568 2469568 2022-05-03 Hancock Tennessee 47067 2012 37
2466312 2466312 2022-05-02 Hancock Tennessee 47067 2012 37
2463057 2463057 2022-05-01 Hancock Tennessee 47067 2012 37
2459801 2459801 2022-04-30 Hancock Tennessee 47067 2012 37
2456545 2456545 2022-04-29 Hancock Tennessee 47067 2012 37
2453289 2453289 2022-04-28 Hancock Tennessee 47067 2012 37
2450033 2450033 2022-04-27 Hancock Tennessee 47067 2012 37
2446776 2446776 2022-04-26 Hancock Tennessee 47067 2011 36
2443521 2443521 2022-04-25 Hancock Tennessee 47067 2011 36
2440265 2440265 2022-04-24 Hancock Tennessee 47067 2011 36
2437009 2437009 2022-04-23 Hancock Tennessee 47067 2011 36
2433753 2433753 2022-04-22 Hancock Tennessee 47067 2011 36
2430497 2430497 2022-04-21 Hancock Tennessee 47067 2011 36
2427241 2427241 2022-04-20 Hancock Tennessee 47067 2011 36
2423985 2423985 2022-04-19 Hancock Tennessee 47067 2010 35
2420729 2420729 2022-04-18 Hancock Tennessee 47067 2010 35
2417473 2417473 2022-04-17 Hancock Tennessee 47067 2010 35
2414217 2414217 2022-04-16 Hancock Tennessee 47067 2010 35
2410961 2410961 2022-04-15 Hancock Tennessee 47067 2010 35
2407705 2407705 2022-04-14 Hancock Tennessee 47067 2010 35
2404449 2404449 2022-04-13 Hancock Tennessee 47067 2010 35
2401194 2401194 2022-04-12 Hancock Tennessee 47067 2007 35
2397939 2397939 2022-04-11 Hancock Tennessee 47067 2007 35
2394684 2394684 2022-04-10 Hancock Tennessee 47067 2007 35
2391428 2391428 2022-04-09 Hancock Tennessee 47067 2007 35
2388172 2388172 2022-04-08 Hancock Tennessee 47067 2007 35
2384917 2384917 2022-04-07 Hancock Tennessee 47067 2007 35
2381662 2381662 2022-04-06 Hancock Tennessee 47067 2007 35
2378407 2378407 2022-04-05 Hancock Tennessee 47067 2002 34
2375153 2375153 2022-04-04 Hancock Tennessee 47067 2002 34
2371901 2371901 2022-04-03 Hancock Tennessee 47067 2002 34
2368648 2368648 2022-04-02 Hancock Tennessee 47067 2002 34
2365395 2365395 2022-04-01 Hancock Tennessee 47067 2002 34
2362142 2362142 2022-03-31 Hancock Tennessee 47067 2002 34
2358888 2358888 2022-03-30 Hancock Tennessee 47067 2002 34
2355634 2355634 2022-03-29 Hancock Tennessee 47067 2002 34
2352381 2352381 2022-03-28 Hancock Tennessee 47067 2002 34
2349129 2349129 2022-03-27 Hancock Tennessee 47067 2002 34
2345876 2345876 2022-03-26 Hancock Tennessee 47067 2002 34
2342623 2342623 2022-03-25 Hancock Tennessee 47067 2002 34
2339370 2339370 2022-03-24 Hancock Tennessee 47067 2002 34
2336116 2336116 2022-03-23 Hancock Tennessee 47067 2002 34
2332862 2332862 2022-03-22 Hancock Tennessee 47067 2001 34
2329609 2329609 2022-03-21 Hancock Tennessee 47067 2001 34
2326357 2326357 2022-03-20 Hancock Tennessee 47067 2001 34
2323104 2323104 2022-03-19 Hancock Tennessee 47067 2001 34
2319850 2319850 2022-03-18 Hancock Tennessee 47067 2001 34
2316596 2316596 2022-03-17 Hancock Tennessee 47067 2001 34
2313343 2313343 2022-03-16 Hancock Tennessee 47067 2001 34
2310090 2310090 2022-03-15 Hancock Tennessee 47067 1998 32
2306837 2306837 2022-03-14 Hancock Tennessee 47067 1998 32
2303586 2303586 2022-03-13 Hancock Tennessee 47067 1998 32
2300334 2300334 2022-03-12 Hancock Tennessee 47067 1998 32
2297082 2297082 2022-03-11 Hancock Tennessee 47067 1998 32
2293830 2293830 2022-03-10 Hancock Tennessee 47067 1998 32
2290578 2290578 2022-03-09 Hancock Tennessee 47067 1998 32
2287326 2287326 2022-03-08 Hancock Tennessee 47067 1985 31
2284074 2284074 2022-03-07 Hancock Tennessee 47067 1985 31
2280822 2280822 2022-03-06 Hancock Tennessee 47067 1985 31
2277569 2277569 2022-03-05 Hancock Tennessee 47067 1985 31
2274316 2274316 2022-03-04 Hancock Tennessee 47067 1985 31
2271063 2271063 2022-03-03 Hancock Tennessee 47067 1985 31
2267811 2267811 2022-03-02 Hancock Tennessee 47067 1985 31
2264558 2264558 2022-03-01 Hancock Tennessee 47067 1966 30
2261308 2261308 2022-02-28 Hancock Tennessee 47067 1966 30
2258057 2258057 2022-02-27 Hancock Tennessee 47067 1966 30
2254806 2254806 2022-02-26 Hancock Tennessee 47067 1966 30
2251555 2251555 2022-02-25 Hancock Tennessee 47067 1966 30
2248304 2248304 2022-02-24 Hancock Tennessee 47067 1966 30
2245053 2245053 2022-02-23 Hancock Tennessee 47067 1966 30
2241802 2241802 2022-02-22 Hancock Tennessee 47067 1935 30
2238551 2238551 2022-02-21 Hancock Tennessee 47067 1935 30
2235300 2235300 2022-02-20 Hancock Tennessee 47067 1935 30
2232049 2232049 2022-02-19 Hancock Tennessee 47067 1935 30
2228798 2228798 2022-02-18 Hancock Tennessee 47067 1935 30
2225547 2225547 2022-02-17 Hancock Tennessee 47067 1935 30
2222296 2222296 2022-02-16 Hancock Tennessee 47067 1935 30
2219045 2219045 2022-02-15 Hancock Tennessee 47067 1872 29
2215794 2215794 2022-02-14 Hancock Tennessee 47067 1872 29
2212543 2212543 2022-02-13 Hancock Tennessee 47067 1872 29
2209290 2209290 2022-02-12 Hancock Tennessee 47067 1872 29
2206037 2206037 2022-02-11 Hancock Tennessee 47067 1872 29
2202784 2202784 2022-02-10 Hancock Tennessee 47067 1872 29
2199530 2199530 2022-02-09 Hancock Tennessee 47067 1872 29
2196276 2196276 2022-02-08 Hancock Tennessee 47067 1789 29
2193022 2193022 2022-02-07 Hancock Tennessee 47067 1789 29
2189768 2189768 2022-02-06 Hancock Tennessee 47067 1789 29
2186515 2186515 2022-02-05 Hancock Tennessee 47067 1789 29
2183263 2183263 2022-02-04 Hancock Tennessee 47067 1789 29
2180011 2180011 2022-02-03 Hancock Tennessee 47067 1789 29

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