ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
277 rows where deaths = 59 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Campbell 32
- Stewart 31
- Houston 21
- Humphreys 16
- DeKalb 15
- Weakley 15
- Crockett 13
- Carroll 8
- Haywood 8
- Lauderdale 8
- Marshall 8
- Cannon 7
- Jackson 7
- Unicoi 7
- Sequatchie 6
- Fentress 5
- Henderson 5
- Dickson 4
- McNairy 4
- Putnam 4
- Scott 4
- White 4
- Cheatham 3
- Gibson 3
- Hickman 3
- McMinn 3
- Rutherford 3
- Williamson 3
- Bedford 2
- Fayette 2
- …
state 1
- Tennessee · 277 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502191 | 2502191 | 2022-05-13 | Stewart | Tennessee | 47161 | 3294 | 59 |
2498933 | 2498933 | 2022-05-12 | Stewart | Tennessee | 47161 | 3294 | 59 |
2495675 | 2495675 | 2022-05-11 | Stewart | Tennessee | 47161 | 3294 | 59 |
2492417 | 2492417 | 2022-05-10 | Stewart | Tennessee | 47161 | 3289 | 59 |
2489159 | 2489159 | 2022-05-09 | Stewart | Tennessee | 47161 | 3289 | 59 |
2485902 | 2485902 | 2022-05-08 | Stewart | Tennessee | 47161 | 3289 | 59 |
2482644 | 2482644 | 2022-05-07 | Stewart | Tennessee | 47161 | 3289 | 59 |
2479386 | 2479386 | 2022-05-06 | Stewart | Tennessee | 47161 | 3289 | 59 |
2476128 | 2476128 | 2022-05-05 | Stewart | Tennessee | 47161 | 3289 | 59 |
2472871 | 2472871 | 2022-05-04 | Stewart | Tennessee | 47161 | 3289 | 59 |
2469615 | 2469615 | 2022-05-03 | Stewart | Tennessee | 47161 | 3289 | 59 |
2466359 | 2466359 | 2022-05-02 | Stewart | Tennessee | 47161 | 3289 | 59 |
2463104 | 2463104 | 2022-05-01 | Stewart | Tennessee | 47161 | 3289 | 59 |
2459848 | 2459848 | 2022-04-30 | Stewart | Tennessee | 47161 | 3289 | 59 |
2456592 | 2456592 | 2022-04-29 | Stewart | Tennessee | 47161 | 3289 | 59 |
2453336 | 2453336 | 2022-04-28 | Stewart | Tennessee | 47161 | 3289 | 59 |
2450080 | 2450080 | 2022-04-27 | Stewart | Tennessee | 47161 | 3289 | 59 |
2446823 | 2446823 | 2022-04-26 | Stewart | Tennessee | 47161 | 3288 | 59 |
2443568 | 2443568 | 2022-04-25 | Stewart | Tennessee | 47161 | 3288 | 59 |
2440312 | 2440312 | 2022-04-24 | Stewart | Tennessee | 47161 | 3288 | 59 |
2437056 | 2437056 | 2022-04-23 | Stewart | Tennessee | 47161 | 3288 | 59 |
2433800 | 2433800 | 2022-04-22 | Stewart | Tennessee | 47161 | 3288 | 59 |
2430544 | 2430544 | 2022-04-21 | Stewart | Tennessee | 47161 | 3288 | 59 |
2427288 | 2427288 | 2022-04-20 | Stewart | Tennessee | 47161 | 3288 | 59 |
2424032 | 2424032 | 2022-04-19 | Stewart | Tennessee | 47161 | 3287 | 59 |
2420776 | 2420776 | 2022-04-18 | Stewart | Tennessee | 47161 | 3287 | 59 |
2417520 | 2417520 | 2022-04-17 | Stewart | Tennessee | 47161 | 3287 | 59 |
2414264 | 2414264 | 2022-04-16 | Stewart | Tennessee | 47161 | 3287 | 59 |
2411008 | 2411008 | 2022-04-15 | Stewart | Tennessee | 47161 | 3287 | 59 |
2407752 | 2407752 | 2022-04-14 | Stewart | Tennessee | 47161 | 3287 | 59 |
2404496 | 2404496 | 2022-04-13 | Stewart | Tennessee | 47161 | 3287 | 59 |
2378381 | 2378381 | 2022-04-05 | Cannon | Tennessee | 47015 | 4189 | 59 |
2375127 | 2375127 | 2022-04-04 | Cannon | Tennessee | 47015 | 4189 | 59 |
2371875 | 2371875 | 2022-04-03 | Cannon | Tennessee | 47015 | 4189 | 59 |
2368622 | 2368622 | 2022-04-02 | Cannon | Tennessee | 47015 | 4189 | 59 |
2365369 | 2365369 | 2022-04-01 | Cannon | Tennessee | 47015 | 4189 | 59 |
2362116 | 2362116 | 2022-03-31 | Cannon | Tennessee | 47015 | 4189 | 59 |
2358862 | 2358862 | 2022-03-30 | Cannon | Tennessee | 47015 | 4189 | 59 |
2310098 | 2310098 | 2022-03-15 | Houston | Tennessee | 47083 | 2667 | 59 |
2306845 | 2306845 | 2022-03-14 | Houston | Tennessee | 47083 | 2667 | 59 |
2303594 | 2303594 | 2022-03-13 | Houston | Tennessee | 47083 | 2667 | 59 |
2300342 | 2300342 | 2022-03-12 | Houston | Tennessee | 47083 | 2667 | 59 |
2297090 | 2297090 | 2022-03-11 | Houston | Tennessee | 47083 | 2667 | 59 |
2293838 | 2293838 | 2022-03-10 | Houston | Tennessee | 47083 | 2667 | 59 |
2290586 | 2290586 | 2022-03-09 | Houston | Tennessee | 47083 | 2667 | 59 |
2287334 | 2287334 | 2022-03-08 | Houston | Tennessee | 47083 | 2663 | 59 |
2287336 | 2287336 | 2022-03-08 | Jackson | Tennessee | 47087 | 3189 | 59 |
2284082 | 2284082 | 2022-03-07 | Houston | Tennessee | 47083 | 2663 | 59 |
2284084 | 2284084 | 2022-03-07 | Jackson | Tennessee | 47087 | 3189 | 59 |
2280830 | 2280830 | 2022-03-06 | Houston | Tennessee | 47083 | 2663 | 59 |
2280832 | 2280832 | 2022-03-06 | Jackson | Tennessee | 47087 | 3189 | 59 |
2277577 | 2277577 | 2022-03-05 | Houston | Tennessee | 47083 | 2663 | 59 |
2277579 | 2277579 | 2022-03-05 | Jackson | Tennessee | 47087 | 3189 | 59 |
2274324 | 2274324 | 2022-03-04 | Houston | Tennessee | 47083 | 2663 | 59 |
2274326 | 2274326 | 2022-03-04 | Jackson | Tennessee | 47087 | 3189 | 59 |
2271071 | 2271071 | 2022-03-03 | Houston | Tennessee | 47083 | 2663 | 59 |
2271073 | 2271073 | 2022-03-03 | Jackson | Tennessee | 47087 | 3189 | 59 |
2267819 | 2267819 | 2022-03-02 | Houston | Tennessee | 47083 | 2663 | 59 |
2267821 | 2267821 | 2022-03-02 | Jackson | Tennessee | 47087 | 3189 | 59 |
2264566 | 2264566 | 2022-03-01 | Houston | Tennessee | 47083 | 2644 | 59 |
2261316 | 2261316 | 2022-02-28 | Houston | Tennessee | 47083 | 2644 | 59 |
2258065 | 2258065 | 2022-02-27 | Houston | Tennessee | 47083 | 2644 | 59 |
2254814 | 2254814 | 2022-02-26 | Houston | Tennessee | 47083 | 2644 | 59 |
2251563 | 2251563 | 2022-02-25 | Houston | Tennessee | 47083 | 2644 | 59 |
2248312 | 2248312 | 2022-02-24 | Houston | Tennessee | 47083 | 2644 | 59 |
2245061 | 2245061 | 2022-02-23 | Houston | Tennessee | 47083 | 2644 | 59 |
2105199 | 2105199 | 2022-01-11 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2101948 | 2101948 | 2022-01-10 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2098697 | 2098697 | 2022-01-09 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2095445 | 2095445 | 2022-01-08 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2092193 | 2092193 | 2022-01-07 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2088941 | 2088941 | 2022-01-06 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2085690 | 2085690 | 2022-01-05 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2082438 | 2082438 | 2022-01-04 | Humphreys | Tennessee | 47085 | 3591 | 59 |
2079186 | 2079186 | 2022-01-03 | Humphreys | Tennessee | 47085 | 3566 | 59 |
2075935 | 2075935 | 2022-01-02 | Humphreys | Tennessee | 47085 | 3527 | 59 |
2075969 | 2075969 | 2022-01-02 | Sequatchie | Tennessee | 47153 | 3206 | 59 |
2072684 | 2072684 | 2022-01-01 | Humphreys | Tennessee | 47085 | 3527 | 59 |
2072718 | 2072718 | 2022-01-01 | Sequatchie | Tennessee | 47153 | 3206 | 59 |
2069433 | 2069433 | 2021-12-31 | Humphreys | Tennessee | 47085 | 3527 | 59 |
2069467 | 2069467 | 2021-12-31 | Sequatchie | Tennessee | 47153 | 3206 | 59 |
2066182 | 2066182 | 2021-12-30 | Humphreys | Tennessee | 47085 | 3527 | 59 |
2066216 | 2066216 | 2021-12-30 | Sequatchie | Tennessee | 47153 | 3206 | 59 |
2062932 | 2062932 | 2021-12-29 | Humphreys | Tennessee | 47085 | 3501 | 59 |
2062966 | 2062966 | 2021-12-29 | Sequatchie | Tennessee | 47153 | 3188 | 59 |
2059682 | 2059682 | 2021-12-28 | Humphreys | Tennessee | 47085 | 3477 | 59 |
2059716 | 2059716 | 2021-12-28 | Sequatchie | Tennessee | 47153 | 3183 | 59 |
2056433 | 2056433 | 2021-12-27 | Humphreys | Tennessee | 47085 | 3467 | 59 |
1971885 | 1971885 | 2021-12-01 | Benton | Tennessee | 47005 | 2971 | 59 |
1851711 | 1851711 | 2021-10-25 | Scott | Tennessee | 47151 | 5194 | 59 |
1848461 | 1848461 | 2021-10-24 | Scott | Tennessee | 47151 | 5194 | 59 |
1845211 | 1845211 | 2021-10-23 | Scott | Tennessee | 47151 | 5194 | 59 |
1841961 | 1841961 | 2021-10-22 | Scott | Tennessee | 47151 | 5194 | 59 |
1789917 | 1789917 | 2021-10-06 | Crockett | Tennessee | 47033 | 3285 | 59 |
1786669 | 1786669 | 2021-10-05 | Crockett | Tennessee | 47033 | 3284 | 59 |
1786738 | 1786738 | 2021-10-05 | Unicoi | Tennessee | 47171 | 3053 | 59 |
1783420 | 1783420 | 2021-10-04 | Crockett | Tennessee | 47033 | 3283 | 59 |
1783489 | 1783489 | 2021-10-04 | Unicoi | Tennessee | 47171 | 3045 | 59 |
1780171 | 1780171 | 2021-10-03 | Crockett | Tennessee | 47033 | 3268 | 59 |
1780240 | 1780240 | 2021-10-03 | Unicoi | Tennessee | 47171 | 3034 | 59 |
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);