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

777 rows where county = "Union" and fips = 47173 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

  • 47173 · 777 ✖

county 1

  • Union · 777 ✖
Link rowid date ▲ county state fips cases deaths
2502197 2502197 2022-05-13 Union Tennessee 47173 5409 75
2498939 2498939 2022-05-12 Union Tennessee 47173 5409 75
2495681 2495681 2022-05-11 Union Tennessee 47173 5409 75
2492423 2492423 2022-05-10 Union Tennessee 47173 5405 75
2489165 2489165 2022-05-09 Union Tennessee 47173 5405 75
2485908 2485908 2022-05-08 Union Tennessee 47173 5405 75
2482650 2482650 2022-05-07 Union Tennessee 47173 5405 75
2479392 2479392 2022-05-06 Union Tennessee 47173 5405 75
2476134 2476134 2022-05-05 Union Tennessee 47173 5405 75
2472877 2472877 2022-05-04 Union Tennessee 47173 5405 75
2469621 2469621 2022-05-03 Union Tennessee 47173 5400 75
2466365 2466365 2022-05-02 Union Tennessee 47173 5400 75
2463110 2463110 2022-05-01 Union Tennessee 47173 5400 75
2459854 2459854 2022-04-30 Union Tennessee 47173 5400 75
2456598 2456598 2022-04-29 Union Tennessee 47173 5400 75
2453342 2453342 2022-04-28 Union Tennessee 47173 5400 75
2450086 2450086 2022-04-27 Union Tennessee 47173 5400 75
2446829 2446829 2022-04-26 Union Tennessee 47173 5399 75
2443574 2443574 2022-04-25 Union Tennessee 47173 5399 75
2440318 2440318 2022-04-24 Union Tennessee 47173 5399 75
2437062 2437062 2022-04-23 Union Tennessee 47173 5399 75
2433806 2433806 2022-04-22 Union Tennessee 47173 5399 75
2430550 2430550 2022-04-21 Union Tennessee 47173 5399 75
2427294 2427294 2022-04-20 Union Tennessee 47173 5399 75
2424038 2424038 2022-04-19 Union Tennessee 47173 5398 75
2420782 2420782 2022-04-18 Union Tennessee 47173 5398 75
2417526 2417526 2022-04-17 Union Tennessee 47173 5398 75
2414270 2414270 2022-04-16 Union Tennessee 47173 5398 75
2411014 2411014 2022-04-15 Union Tennessee 47173 5398 75
2407758 2407758 2022-04-14 Union Tennessee 47173 5398 75
2404502 2404502 2022-04-13 Union Tennessee 47173 5398 75
2401247 2401247 2022-04-12 Union Tennessee 47173 5394 73
2397992 2397992 2022-04-11 Union Tennessee 47173 5394 73
2394737 2394737 2022-04-10 Union Tennessee 47173 5394 73
2391481 2391481 2022-04-09 Union Tennessee 47173 5394 73
2388225 2388225 2022-04-08 Union Tennessee 47173 5394 73
2384970 2384970 2022-04-07 Union Tennessee 47173 5394 73
2381715 2381715 2022-04-06 Union Tennessee 47173 5394 73
2378460 2378460 2022-04-05 Union Tennessee 47173 5394 72
2375206 2375206 2022-04-04 Union Tennessee 47173 5394 72
2371954 2371954 2022-04-03 Union Tennessee 47173 5394 72
2368701 2368701 2022-04-02 Union Tennessee 47173 5394 72
2365448 2365448 2022-04-01 Union Tennessee 47173 5394 72
2362195 2362195 2022-03-31 Union Tennessee 47173 5394 72
2358941 2358941 2022-03-30 Union Tennessee 47173 5394 72
2355687 2355687 2022-03-29 Union Tennessee 47173 5393 72
2352434 2352434 2022-03-28 Union Tennessee 47173 5393 72
2349182 2349182 2022-03-27 Union Tennessee 47173 5393 72
2345929 2345929 2022-03-26 Union Tennessee 47173 5393 72
2342676 2342676 2022-03-25 Union Tennessee 47173 5393 72
2339423 2339423 2022-03-24 Union Tennessee 47173 5393 72
2336169 2336169 2022-03-23 Union Tennessee 47173 5393 72
2332915 2332915 2022-03-22 Union Tennessee 47173 5392 72
2329662 2329662 2022-03-21 Union Tennessee 47173 5392 72
2326410 2326410 2022-03-20 Union Tennessee 47173 5392 72
2323157 2323157 2022-03-19 Union Tennessee 47173 5392 72
2319903 2319903 2022-03-18 Union Tennessee 47173 5392 72
2316649 2316649 2022-03-17 Union Tennessee 47173 5392 72
2313396 2313396 2022-03-16 Union Tennessee 47173 5392 72
2310143 2310143 2022-03-15 Union Tennessee 47173 5382 70
2306890 2306890 2022-03-14 Union Tennessee 47173 5382 70
2303639 2303639 2022-03-13 Union Tennessee 47173 5382 70
2300387 2300387 2022-03-12 Union Tennessee 47173 5382 70
2297135 2297135 2022-03-11 Union Tennessee 47173 5382 70
2293883 2293883 2022-03-10 Union Tennessee 47173 5382 70
2290631 2290631 2022-03-09 Union Tennessee 47173 5382 70
2287379 2287379 2022-03-08 Union Tennessee 47173 5373 69
2284127 2284127 2022-03-07 Union Tennessee 47173 5373 69
2280875 2280875 2022-03-06 Union Tennessee 47173 5373 69
2277622 2277622 2022-03-05 Union Tennessee 47173 5373 69
2274369 2274369 2022-03-04 Union Tennessee 47173 5373 69
2271116 2271116 2022-03-03 Union Tennessee 47173 5373 69
2267864 2267864 2022-03-02 Union Tennessee 47173 5373 69
2264611 2264611 2022-03-01 Union Tennessee 47173 5332 69
2261361 2261361 2022-02-28 Union Tennessee 47173 5332 69
2258110 2258110 2022-02-27 Union Tennessee 47173 5332 69
2254859 2254859 2022-02-26 Union Tennessee 47173 5332 69
2251608 2251608 2022-02-25 Union Tennessee 47173 5332 69
2248357 2248357 2022-02-24 Union Tennessee 47173 5332 69
2245106 2245106 2022-02-23 Union Tennessee 47173 5332 69
2241855 2241855 2022-02-22 Union Tennessee 47173 5254 70
2238604 2238604 2022-02-21 Union Tennessee 47173 5254 70
2235353 2235353 2022-02-20 Union Tennessee 47173 5254 70
2232102 2232102 2022-02-19 Union Tennessee 47173 5254 70
2228851 2228851 2022-02-18 Union Tennessee 47173 5254 70
2225600 2225600 2022-02-17 Union Tennessee 47173 5254 70
2222349 2222349 2022-02-16 Union Tennessee 47173 5254 70
2219098 2219098 2022-02-15 Union Tennessee 47173 5083 69
2215847 2215847 2022-02-14 Union Tennessee 47173 5083 69
2212596 2212596 2022-02-13 Union Tennessee 47173 5083 69
2209343 2209343 2022-02-12 Union Tennessee 47173 5083 69
2206090 2206090 2022-02-11 Union Tennessee 47173 5083 69
2202837 2202837 2022-02-10 Union Tennessee 47173 5083 69
2199583 2199583 2022-02-09 Union Tennessee 47173 5083 69
2196329 2196329 2022-02-08 Union Tennessee 47173 4778 68
2193075 2193075 2022-02-07 Union Tennessee 47173 4778 68
2189821 2189821 2022-02-06 Union Tennessee 47173 4778 68
2186568 2186568 2022-02-05 Union Tennessee 47173 4778 68
2183316 2183316 2022-02-04 Union Tennessee 47173 4778 68
2180064 2180064 2022-02-03 Union Tennessee 47173 4778 68

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