ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
543 rows where deaths = 48 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Scott 63
- Crockett 58
- Chester 37
- Van Buren 31
- Lewis 27
- Humphreys 21
- Meigs 21
- Fentress 15
- Grainger 15
- Greene 15
- Hickman 15
- Lauderdale 15
- Perry 14
- Weakley 14
- Johnson 13
- Union 9
- Cumberland 8
- Franklin 8
- Bledsoe 7
- Jackson 7
- Marion 7
- Smith 7
- Stewart 7
- DeKalb 6
- Unicoi 6
- Fayette 5
- Hamblen 5
- Hamilton 5
- McMinn 5
- Roane 5
- …
state 1
- Tennessee · 543 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502199 | 2502199 | 2022-05-13 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2498941 | 2498941 | 2022-05-12 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2495683 | 2495683 | 2022-05-11 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2492425 | 2492425 | 2022-05-10 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2489167 | 2489167 | 2022-05-09 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2485910 | 2485910 | 2022-05-08 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2482652 | 2482652 | 2022-05-07 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2479394 | 2479394 | 2022-05-06 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2476136 | 2476136 | 2022-05-05 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2472879 | 2472879 | 2022-05-04 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2469623 | 2469623 | 2022-05-03 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2466367 | 2466367 | 2022-05-02 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2463112 | 2463112 | 2022-05-01 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2459856 | 2459856 | 2022-04-30 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2456600 | 2456600 | 2022-04-29 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2453344 | 2453344 | 2022-04-28 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2450088 | 2450088 | 2022-04-27 | Van Buren | Tennessee | 47175 | 1850 | 48 |
2446831 | 2446831 | 2022-04-26 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2443576 | 2443576 | 2022-04-25 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2440320 | 2440320 | 2022-04-24 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2437064 | 2437064 | 2022-04-23 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2433808 | 2433808 | 2022-04-22 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2430552 | 2430552 | 2022-04-21 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2427296 | 2427296 | 2022-04-20 | Van Buren | Tennessee | 47175 | 1848 | 48 |
2424040 | 2424040 | 2022-04-19 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2420784 | 2420784 | 2022-04-18 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2417528 | 2417528 | 2022-04-17 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2414272 | 2414272 | 2022-04-16 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2411016 | 2411016 | 2022-04-15 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2407760 | 2407760 | 2022-04-14 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2404504 | 2404504 | 2022-04-13 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2310124 | 2310124 | 2022-03-15 | Perry | Tennessee | 47135 | 2327 | 48 |
2306871 | 2306871 | 2022-03-14 | Perry | Tennessee | 47135 | 2327 | 48 |
2303620 | 2303620 | 2022-03-13 | Perry | Tennessee | 47135 | 2327 | 48 |
2300368 | 2300368 | 2022-03-12 | Perry | Tennessee | 47135 | 2327 | 48 |
2297116 | 2297116 | 2022-03-11 | Perry | Tennessee | 47135 | 2327 | 48 |
2293864 | 2293864 | 2022-03-10 | Perry | Tennessee | 47135 | 2327 | 48 |
2290612 | 2290612 | 2022-03-09 | Perry | Tennessee | 47135 | 2327 | 48 |
2287360 | 2287360 | 2022-03-08 | Perry | Tennessee | 47135 | 2315 | 48 |
2284108 | 2284108 | 2022-03-07 | Perry | Tennessee | 47135 | 2315 | 48 |
2280856 | 2280856 | 2022-03-06 | Perry | Tennessee | 47135 | 2315 | 48 |
2277603 | 2277603 | 2022-03-05 | Perry | Tennessee | 47135 | 2315 | 48 |
2274350 | 2274350 | 2022-03-04 | Perry | Tennessee | 47135 | 2315 | 48 |
2271097 | 2271097 | 2022-03-03 | Perry | Tennessee | 47135 | 2315 | 48 |
2267845 | 2267845 | 2022-03-02 | Perry | Tennessee | 47135 | 2315 | 48 |
2264528 | 2264528 | 2022-03-01 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2264605 | 2264605 | 2022-03-01 | Stewart | Tennessee | 47161 | 3253 | 48 |
2261278 | 2261278 | 2022-02-28 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2261355 | 2261355 | 2022-02-28 | Stewart | Tennessee | 47161 | 3253 | 48 |
2258027 | 2258027 | 2022-02-27 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2258104 | 2258104 | 2022-02-27 | Stewart | Tennessee | 47161 | 3253 | 48 |
2254776 | 2254776 | 2022-02-26 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2254853 | 2254853 | 2022-02-26 | Stewart | Tennessee | 47161 | 3253 | 48 |
2251525 | 2251525 | 2022-02-25 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2251602 | 2251602 | 2022-02-25 | Stewart | Tennessee | 47161 | 3253 | 48 |
2248274 | 2248274 | 2022-02-24 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2248351 | 2248351 | 2022-02-24 | Stewart | Tennessee | 47161 | 3253 | 48 |
2245023 | 2245023 | 2022-02-23 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2245100 | 2245100 | 2022-02-23 | Stewart | Tennessee | 47161 | 3253 | 48 |
2196303 | 2196303 | 2022-02-08 | Meigs | Tennessee | 47121 | 3117 | 48 |
2193049 | 2193049 | 2022-02-07 | Meigs | Tennessee | 47121 | 3117 | 48 |
2189795 | 2189795 | 2022-02-06 | Meigs | Tennessee | 47121 | 3117 | 48 |
2186542 | 2186542 | 2022-02-05 | Meigs | Tennessee | 47121 | 3117 | 48 |
2183290 | 2183290 | 2022-02-04 | Meigs | Tennessee | 47121 | 3117 | 48 |
2180038 | 2180038 | 2022-02-03 | Meigs | Tennessee | 47121 | 3117 | 48 |
2176787 | 2176787 | 2022-02-02 | Meigs | Tennessee | 47121 | 3117 | 48 |
2173533 | 2173533 | 2022-02-01 | Meigs | Tennessee | 47121 | 2905 | 48 |
2170281 | 2170281 | 2022-01-31 | Meigs | Tennessee | 47121 | 2905 | 48 |
2167027 | 2167027 | 2022-01-30 | Meigs | Tennessee | 47121 | 2905 | 48 |
2163772 | 2163772 | 2022-01-29 | Meigs | Tennessee | 47121 | 2905 | 48 |
2160517 | 2160517 | 2022-01-28 | Meigs | Tennessee | 47121 | 2905 | 48 |
2157261 | 2157261 | 2022-01-27 | Meigs | Tennessee | 47121 | 2905 | 48 |
2154008 | 2154008 | 2022-01-26 | Meigs | Tennessee | 47121 | 2905 | 48 |
2150756 | 2150756 | 2022-01-25 | Meigs | Tennessee | 47121 | 2668 | 48 |
2147504 | 2147504 | 2022-01-24 | Meigs | Tennessee | 47121 | 2668 | 48 |
2144250 | 2144250 | 2022-01-23 | Meigs | Tennessee | 47121 | 2668 | 48 |
2140995 | 2140995 | 2022-01-22 | Meigs | Tennessee | 47121 | 2668 | 48 |
2137739 | 2137739 | 2022-01-21 | Meigs | Tennessee | 47121 | 2668 | 48 |
2134485 | 2134485 | 2022-01-20 | Meigs | Tennessee | 47121 | 2668 | 48 |
2131233 | 2131233 | 2022-01-19 | Meigs | Tennessee | 47121 | 2668 | 48 |
2127969 | 2127969 | 2022-01-18 | Lewis | Tennessee | 47101 | 2710 | 48 |
2124717 | 2124717 | 2022-01-17 | Lewis | Tennessee | 47101 | 2710 | 48 |
2121465 | 2121465 | 2022-01-16 | Lewis | Tennessee | 47101 | 2710 | 48 |
2118213 | 2118213 | 2022-01-15 | Lewis | Tennessee | 47101 | 2710 | 48 |
2114962 | 2114962 | 2022-01-14 | Lewis | Tennessee | 47101 | 2710 | 48 |
2111710 | 2111710 | 2022-01-13 | Lewis | Tennessee | 47101 | 2710 | 48 |
2108458 | 2108458 | 2022-01-12 | Lewis | Tennessee | 47101 | 2710 | 48 |
2105207 | 2105207 | 2022-01-11 | Lewis | Tennessee | 47101 | 2656 | 48 |
2101956 | 2101956 | 2022-01-10 | Lewis | Tennessee | 47101 | 2656 | 48 |
2098705 | 2098705 | 2022-01-09 | Lewis | Tennessee | 47101 | 2656 | 48 |
2095453 | 2095453 | 2022-01-08 | Lewis | Tennessee | 47101 | 2656 | 48 |
2092201 | 2092201 | 2022-01-07 | Lewis | Tennessee | 47101 | 2656 | 48 |
2088949 | 2088949 | 2022-01-06 | Lewis | Tennessee | 47101 | 2656 | 48 |
2085698 | 2085698 | 2022-01-05 | Lewis | Tennessee | 47101 | 2656 | 48 |
2082446 | 2082446 | 2022-01-04 | Lewis | Tennessee | 47101 | 2656 | 48 |
2079194 | 2079194 | 2022-01-03 | Lewis | Tennessee | 47101 | 2654 | 48 |
2075943 | 2075943 | 2022-01-02 | Lewis | Tennessee | 47101 | 2628 | 48 |
2072692 | 2072692 | 2022-01-01 | Lewis | Tennessee | 47101 | 2628 | 48 |
2069441 | 2069441 | 2021-12-31 | Lewis | Tennessee | 47101 | 2628 | 48 |
2066190 | 2066190 | 2021-12-30 | Lewis | Tennessee | 47101 | 2628 | 48 |
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);