ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 47049 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502135 | 2502135 | 2022-05-13 | Fentress | Tennessee | 47049 | 5722 | 128 |
2498877 | 2498877 | 2022-05-12 | Fentress | Tennessee | 47049 | 5722 | 128 |
2495619 | 2495619 | 2022-05-11 | Fentress | Tennessee | 47049 | 5722 | 128 |
2492361 | 2492361 | 2022-05-10 | Fentress | Tennessee | 47049 | 5709 | 128 |
2489103 | 2489103 | 2022-05-09 | Fentress | Tennessee | 47049 | 5709 | 128 |
2485846 | 2485846 | 2022-05-08 | Fentress | Tennessee | 47049 | 5709 | 128 |
2482588 | 2482588 | 2022-05-07 | Fentress | Tennessee | 47049 | 5709 | 128 |
2479330 | 2479330 | 2022-05-06 | Fentress | Tennessee | 47049 | 5709 | 128 |
2476072 | 2476072 | 2022-05-05 | Fentress | Tennessee | 47049 | 5709 | 128 |
2472815 | 2472815 | 2022-05-04 | Fentress | Tennessee | 47049 | 5709 | 128 |
2469559 | 2469559 | 2022-05-03 | Fentress | Tennessee | 47049 | 5700 | 128 |
2466303 | 2466303 | 2022-05-02 | Fentress | Tennessee | 47049 | 5700 | 128 |
2463048 | 2463048 | 2022-05-01 | Fentress | Tennessee | 47049 | 5700 | 128 |
2459792 | 2459792 | 2022-04-30 | Fentress | Tennessee | 47049 | 5700 | 128 |
2456536 | 2456536 | 2022-04-29 | Fentress | Tennessee | 47049 | 5700 | 128 |
2453280 | 2453280 | 2022-04-28 | Fentress | Tennessee | 47049 | 5700 | 128 |
2450024 | 2450024 | 2022-04-27 | Fentress | Tennessee | 47049 | 5700 | 128 |
2446767 | 2446767 | 2022-04-26 | Fentress | Tennessee | 47049 | 5699 | 128 |
2443512 | 2443512 | 2022-04-25 | Fentress | Tennessee | 47049 | 5699 | 128 |
2440256 | 2440256 | 2022-04-24 | Fentress | Tennessee | 47049 | 5699 | 128 |
2437000 | 2437000 | 2022-04-23 | Fentress | Tennessee | 47049 | 5699 | 128 |
2433744 | 2433744 | 2022-04-22 | Fentress | Tennessee | 47049 | 5699 | 128 |
2430488 | 2430488 | 2022-04-21 | Fentress | Tennessee | 47049 | 5699 | 128 |
2427232 | 2427232 | 2022-04-20 | Fentress | Tennessee | 47049 | 5699 | 128 |
2423976 | 2423976 | 2022-04-19 | Fentress | Tennessee | 47049 | 5697 | 127 |
2420720 | 2420720 | 2022-04-18 | Fentress | Tennessee | 47049 | 5697 | 127 |
2417464 | 2417464 | 2022-04-17 | Fentress | Tennessee | 47049 | 5697 | 127 |
2414208 | 2414208 | 2022-04-16 | Fentress | Tennessee | 47049 | 5697 | 127 |
2410952 | 2410952 | 2022-04-15 | Fentress | Tennessee | 47049 | 5697 | 127 |
2407696 | 2407696 | 2022-04-14 | Fentress | Tennessee | 47049 | 5697 | 127 |
2404440 | 2404440 | 2022-04-13 | Fentress | Tennessee | 47049 | 5697 | 127 |
2401185 | 2401185 | 2022-04-12 | Fentress | Tennessee | 47049 | 5696 | 127 |
2397930 | 2397930 | 2022-04-11 | Fentress | Tennessee | 47049 | 5696 | 127 |
2394675 | 2394675 | 2022-04-10 | Fentress | Tennessee | 47049 | 5696 | 127 |
2391419 | 2391419 | 2022-04-09 | Fentress | Tennessee | 47049 | 5696 | 127 |
2388163 | 2388163 | 2022-04-08 | Fentress | Tennessee | 47049 | 5696 | 127 |
2384908 | 2384908 | 2022-04-07 | Fentress | Tennessee | 47049 | 5696 | 127 |
2381653 | 2381653 | 2022-04-06 | Fentress | Tennessee | 47049 | 5696 | 127 |
2378398 | 2378398 | 2022-04-05 | Fentress | Tennessee | 47049 | 5694 | 125 |
2375144 | 2375144 | 2022-04-04 | Fentress | Tennessee | 47049 | 5694 | 125 |
2371892 | 2371892 | 2022-04-03 | Fentress | Tennessee | 47049 | 5694 | 125 |
2368639 | 2368639 | 2022-04-02 | Fentress | Tennessee | 47049 | 5694 | 125 |
2365386 | 2365386 | 2022-04-01 | Fentress | Tennessee | 47049 | 5694 | 125 |
2362133 | 2362133 | 2022-03-31 | Fentress | Tennessee | 47049 | 5694 | 125 |
2358879 | 2358879 | 2022-03-30 | Fentress | Tennessee | 47049 | 5694 | 125 |
2355625 | 2355625 | 2022-03-29 | Fentress | Tennessee | 47049 | 5691 | 125 |
2352372 | 2352372 | 2022-03-28 | Fentress | Tennessee | 47049 | 5691 | 125 |
2349120 | 2349120 | 2022-03-27 | Fentress | Tennessee | 47049 | 5691 | 125 |
2345867 | 2345867 | 2022-03-26 | Fentress | Tennessee | 47049 | 5691 | 125 |
2342614 | 2342614 | 2022-03-25 | Fentress | Tennessee | 47049 | 5691 | 125 |
2339361 | 2339361 | 2022-03-24 | Fentress | Tennessee | 47049 | 5691 | 125 |
2336107 | 2336107 | 2022-03-23 | Fentress | Tennessee | 47049 | 5691 | 125 |
2332853 | 2332853 | 2022-03-22 | Fentress | Tennessee | 47049 | 5686 | 123 |
2329600 | 2329600 | 2022-03-21 | Fentress | Tennessee | 47049 | 5686 | 123 |
2326348 | 2326348 | 2022-03-20 | Fentress | Tennessee | 47049 | 5686 | 123 |
2323095 | 2323095 | 2022-03-19 | Fentress | Tennessee | 47049 | 5686 | 123 |
2319841 | 2319841 | 2022-03-18 | Fentress | Tennessee | 47049 | 5686 | 123 |
2316587 | 2316587 | 2022-03-17 | Fentress | Tennessee | 47049 | 5686 | 123 |
2313334 | 2313334 | 2022-03-16 | Fentress | Tennessee | 47049 | 5686 | 123 |
2310081 | 2310081 | 2022-03-15 | Fentress | Tennessee | 47049 | 5681 | 117 |
2306828 | 2306828 | 2022-03-14 | Fentress | Tennessee | 47049 | 5681 | 117 |
2303577 | 2303577 | 2022-03-13 | Fentress | Tennessee | 47049 | 5681 | 117 |
2300325 | 2300325 | 2022-03-12 | Fentress | Tennessee | 47049 | 5681 | 117 |
2297073 | 2297073 | 2022-03-11 | Fentress | Tennessee | 47049 | 5681 | 117 |
2293821 | 2293821 | 2022-03-10 | Fentress | Tennessee | 47049 | 5681 | 117 |
2290569 | 2290569 | 2022-03-09 | Fentress | Tennessee | 47049 | 5681 | 117 |
2287317 | 2287317 | 2022-03-08 | Fentress | Tennessee | 47049 | 5668 | 115 |
2284065 | 2284065 | 2022-03-07 | Fentress | Tennessee | 47049 | 5668 | 115 |
2280813 | 2280813 | 2022-03-06 | Fentress | Tennessee | 47049 | 5668 | 115 |
2277560 | 2277560 | 2022-03-05 | Fentress | Tennessee | 47049 | 5668 | 115 |
2274307 | 2274307 | 2022-03-04 | Fentress | Tennessee | 47049 | 5668 | 115 |
2271054 | 2271054 | 2022-03-03 | Fentress | Tennessee | 47049 | 5668 | 115 |
2267802 | 2267802 | 2022-03-02 | Fentress | Tennessee | 47049 | 5668 | 115 |
2264549 | 2264549 | 2022-03-01 | Fentress | Tennessee | 47049 | 5640 | 114 |
2261299 | 2261299 | 2022-02-28 | Fentress | Tennessee | 47049 | 5640 | 114 |
2258048 | 2258048 | 2022-02-27 | Fentress | Tennessee | 47049 | 5640 | 114 |
2254797 | 2254797 | 2022-02-26 | Fentress | Tennessee | 47049 | 5640 | 114 |
2251546 | 2251546 | 2022-02-25 | Fentress | Tennessee | 47049 | 5640 | 114 |
2248295 | 2248295 | 2022-02-24 | Fentress | Tennessee | 47049 | 5640 | 114 |
2245044 | 2245044 | 2022-02-23 | Fentress | Tennessee | 47049 | 5640 | 114 |
2241793 | 2241793 | 2022-02-22 | Fentress | Tennessee | 47049 | 5563 | 111 |
2238542 | 2238542 | 2022-02-21 | Fentress | Tennessee | 47049 | 5563 | 111 |
2235291 | 2235291 | 2022-02-20 | Fentress | Tennessee | 47049 | 5563 | 111 |
2232040 | 2232040 | 2022-02-19 | Fentress | Tennessee | 47049 | 5563 | 111 |
2228789 | 2228789 | 2022-02-18 | Fentress | Tennessee | 47049 | 5563 | 111 |
2225538 | 2225538 | 2022-02-17 | Fentress | Tennessee | 47049 | 5563 | 111 |
2222287 | 2222287 | 2022-02-16 | Fentress | Tennessee | 47049 | 5563 | 111 |
2219036 | 2219036 | 2022-02-15 | Fentress | Tennessee | 47049 | 5402 | 109 |
2215785 | 2215785 | 2022-02-14 | Fentress | Tennessee | 47049 | 5402 | 109 |
2212534 | 2212534 | 2022-02-13 | Fentress | Tennessee | 47049 | 5402 | 109 |
2209281 | 2209281 | 2022-02-12 | Fentress | Tennessee | 47049 | 5402 | 109 |
2206028 | 2206028 | 2022-02-11 | Fentress | Tennessee | 47049 | 5402 | 109 |
2202775 | 2202775 | 2022-02-10 | Fentress | Tennessee | 47049 | 5402 | 109 |
2199521 | 2199521 | 2022-02-09 | Fentress | Tennessee | 47049 | 5402 | 109 |
2196267 | 2196267 | 2022-02-08 | Fentress | Tennessee | 47049 | 5041 | 109 |
2193013 | 2193013 | 2022-02-07 | Fentress | Tennessee | 47049 | 5041 | 109 |
2189759 | 2189759 | 2022-02-06 | Fentress | Tennessee | 47049 | 5041 | 109 |
2186506 | 2186506 | 2022-02-05 | Fentress | Tennessee | 47049 | 5041 | 109 |
2183254 | 2183254 | 2022-02-04 | Fentress | Tennessee | 47049 | 5041 | 109 |
2180002 | 2180002 | 2022-02-03 | Fentress | Tennessee | 47049 | 5041 | 109 |
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);