ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 47073 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502147 | 2502147 | 2022-05-13 | Hawkins | Tennessee | 47073 | 16702 | 321 |
2498889 | 2498889 | 2022-05-12 | Hawkins | Tennessee | 47073 | 16702 | 321 |
2495631 | 2495631 | 2022-05-11 | Hawkins | Tennessee | 47073 | 16702 | 321 |
2492373 | 2492373 | 2022-05-10 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2489115 | 2489115 | 2022-05-09 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2485858 | 2485858 | 2022-05-08 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2482600 | 2482600 | 2022-05-07 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2479342 | 2479342 | 2022-05-06 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2476084 | 2476084 | 2022-05-05 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2472827 | 2472827 | 2022-05-04 | Hawkins | Tennessee | 47073 | 16685 | 321 |
2469571 | 2469571 | 2022-05-03 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2466315 | 2466315 | 2022-05-02 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2463060 | 2463060 | 2022-05-01 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2459804 | 2459804 | 2022-04-30 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2456548 | 2456548 | 2022-04-29 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2453292 | 2453292 | 2022-04-28 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2450036 | 2450036 | 2022-04-27 | Hawkins | Tennessee | 47073 | 16673 | 321 |
2446779 | 2446779 | 2022-04-26 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2443524 | 2443524 | 2022-04-25 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2440268 | 2440268 | 2022-04-24 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2437012 | 2437012 | 2022-04-23 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2433756 | 2433756 | 2022-04-22 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2430500 | 2430500 | 2022-04-21 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2427244 | 2427244 | 2022-04-20 | Hawkins | Tennessee | 47073 | 16663 | 321 |
2423988 | 2423988 | 2022-04-19 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2420732 | 2420732 | 2022-04-18 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2417476 | 2417476 | 2022-04-17 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2414220 | 2414220 | 2022-04-16 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2410964 | 2410964 | 2022-04-15 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2407708 | 2407708 | 2022-04-14 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2404452 | 2404452 | 2022-04-13 | Hawkins | Tennessee | 47073 | 16651 | 316 |
2401197 | 2401197 | 2022-04-12 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2397942 | 2397942 | 2022-04-11 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2394687 | 2394687 | 2022-04-10 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2391431 | 2391431 | 2022-04-09 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2388175 | 2388175 | 2022-04-08 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2384920 | 2384920 | 2022-04-07 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2381665 | 2381665 | 2022-04-06 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2378410 | 2378410 | 2022-04-05 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2375156 | 2375156 | 2022-04-04 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2371904 | 2371904 | 2022-04-03 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2368651 | 2368651 | 2022-04-02 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2365398 | 2365398 | 2022-04-01 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2362145 | 2362145 | 2022-03-31 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2358891 | 2358891 | 2022-03-30 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2355637 | 2355637 | 2022-03-29 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2352384 | 2352384 | 2022-03-28 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2349132 | 2349132 | 2022-03-27 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2345879 | 2345879 | 2022-03-26 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2342626 | 2342626 | 2022-03-25 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2339373 | 2339373 | 2022-03-24 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2336119 | 2336119 | 2022-03-23 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2332865 | 2332865 | 2022-03-22 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2329612 | 2329612 | 2022-03-21 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2326360 | 2326360 | 2022-03-20 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2323107 | 2323107 | 2022-03-19 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2319853 | 2319853 | 2022-03-18 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2316599 | 2316599 | 2022-03-17 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2313346 | 2313346 | 2022-03-16 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2310093 | 2310093 | 2022-03-15 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2306840 | 2306840 | 2022-03-14 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2303589 | 2303589 | 2022-03-13 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2300337 | 2300337 | 2022-03-12 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2297085 | 2297085 | 2022-03-11 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2293833 | 2293833 | 2022-03-10 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2290581 | 2290581 | 2022-03-09 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2287329 | 2287329 | 2022-03-08 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2284077 | 2284077 | 2022-03-07 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2280825 | 2280825 | 2022-03-06 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2277572 | 2277572 | 2022-03-05 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2274319 | 2274319 | 2022-03-04 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2271066 | 2271066 | 2022-03-03 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2267814 | 2267814 | 2022-03-02 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2264561 | 2264561 | 2022-03-01 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2261311 | 2261311 | 2022-02-28 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2258060 | 2258060 | 2022-02-27 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2254809 | 2254809 | 2022-02-26 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2251558 | 2251558 | 2022-02-25 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2248307 | 2248307 | 2022-02-24 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2245056 | 2245056 | 2022-02-23 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2241805 | 2241805 | 2022-02-22 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2238554 | 2238554 | 2022-02-21 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2235303 | 2235303 | 2022-02-20 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2232052 | 2232052 | 2022-02-19 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2228801 | 2228801 | 2022-02-18 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2225550 | 2225550 | 2022-02-17 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2222299 | 2222299 | 2022-02-16 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2219048 | 2219048 | 2022-02-15 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2215797 | 2215797 | 2022-02-14 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2212546 | 2212546 | 2022-02-13 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2209293 | 2209293 | 2022-02-12 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2206040 | 2206040 | 2022-02-11 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2202787 | 2202787 | 2022-02-10 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2199533 | 2199533 | 2022-02-09 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2196279 | 2196279 | 2022-02-08 | Hawkins | Tennessee | 47073 | 14743 | 260 |
2193025 | 2193025 | 2022-02-07 | Hawkins | Tennessee | 47073 | 14743 | 260 |
2189771 | 2189771 | 2022-02-06 | Hawkins | Tennessee | 47073 | 14743 | 260 |
2186518 | 2186518 | 2022-02-05 | Hawkins | Tennessee | 47073 | 14743 | 260 |
2183266 | 2183266 | 2022-02-04 | Hawkins | Tennessee | 47073 | 14743 | 260 |
2180014 | 2180014 | 2022-02-03 | Hawkins | Tennessee | 47073 | 14743 | 260 |
Advanced export
JSON shape: default, array, newline-delimited
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);