ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where deaths = 116 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Hardeman 59
- Marion 14
- Marshall 14
- Dickson 12
- Unknown 8
- Scott 7
- Weakley 7
- Claiborne 4
- Henderson 4
- Jefferson 3
- Monroe 3
- Montgomery 3
- Rutherford 3
- Anderson 2
- Cumberland 2
- Fayette 2
- Gibson 2
- Giles 2
- Henry 2
- Carroll 1
- Carter 1
- Coffee 1
- Dyer 1
- Greene 1
- Knox 1
- Madison 1
- Maury 1
- Sevier 1
- Sullivan 1
- Warren 1
- …
state 1
- Tennessee · 165 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502145 | 2502145 | 2022-05-13 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2498887 | 2498887 | 2022-05-12 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2495629 | 2495629 | 2022-05-11 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2492371 | 2492371 | 2022-05-10 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2489113 | 2489113 | 2022-05-09 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2485856 | 2485856 | 2022-05-08 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2482598 | 2482598 | 2022-05-07 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2479340 | 2479340 | 2022-05-06 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2476082 | 2476082 | 2022-05-05 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2472825 | 2472825 | 2022-05-04 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2469569 | 2469569 | 2022-05-03 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2466313 | 2466313 | 2022-05-02 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2463058 | 2463058 | 2022-05-01 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2459802 | 2459802 | 2022-04-30 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2456546 | 2456546 | 2022-04-29 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2453290 | 2453290 | 2022-04-28 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2450034 | 2450034 | 2022-04-27 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2446777 | 2446777 | 2022-04-26 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2443522 | 2443522 | 2022-04-25 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2440266 | 2440266 | 2022-04-24 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2437010 | 2437010 | 2022-04-23 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2433754 | 2433754 | 2022-04-22 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2430498 | 2430498 | 2022-04-21 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2427242 | 2427242 | 2022-04-20 | Hardeman | Tennessee | 47069 | 7595 | 116 |
2423986 | 2423986 | 2022-04-19 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2420730 | 2420730 | 2022-04-18 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2417474 | 2417474 | 2022-04-17 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2414218 | 2414218 | 2022-04-16 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2410962 | 2410962 | 2022-04-15 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2407706 | 2407706 | 2022-04-14 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2404450 | 2404450 | 2022-04-13 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2401195 | 2401195 | 2022-04-12 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2401236 | 2401236 | 2022-04-12 | Scott | Tennessee | 47151 | 9034 | 116 |
2397940 | 2397940 | 2022-04-11 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2397981 | 2397981 | 2022-04-11 | Scott | Tennessee | 47151 | 9034 | 116 |
2394685 | 2394685 | 2022-04-10 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2394726 | 2394726 | 2022-04-10 | Scott | Tennessee | 47151 | 9034 | 116 |
2391429 | 2391429 | 2022-04-09 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2391470 | 2391470 | 2022-04-09 | Scott | Tennessee | 47151 | 9034 | 116 |
2388173 | 2388173 | 2022-04-08 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2388214 | 2388214 | 2022-04-08 | Scott | Tennessee | 47151 | 9034 | 116 |
2384918 | 2384918 | 2022-04-07 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2384959 | 2384959 | 2022-04-07 | Scott | Tennessee | 47151 | 9034 | 116 |
2381663 | 2381663 | 2022-04-06 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2381704 | 2381704 | 2022-04-06 | Scott | Tennessee | 47151 | 9034 | 116 |
2378408 | 2378408 | 2022-04-05 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2375154 | 2375154 | 2022-04-04 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2371902 | 2371902 | 2022-04-03 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2368649 | 2368649 | 2022-04-02 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2365396 | 2365396 | 2022-04-01 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2362143 | 2362143 | 2022-03-31 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2358889 | 2358889 | 2022-03-30 | Hardeman | Tennessee | 47069 | 7587 | 116 |
2355635 | 2355635 | 2022-03-29 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2352382 | 2352382 | 2022-03-28 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2349130 | 2349130 | 2022-03-27 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2345877 | 2345877 | 2022-03-26 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2342624 | 2342624 | 2022-03-25 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2339371 | 2339371 | 2022-03-24 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2336117 | 2336117 | 2022-03-23 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2332863 | 2332863 | 2022-03-22 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2329610 | 2329610 | 2022-03-21 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2326358 | 2326358 | 2022-03-20 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2323105 | 2323105 | 2022-03-19 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2319851 | 2319851 | 2022-03-18 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2316597 | 2316597 | 2022-03-17 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2313344 | 2313344 | 2022-03-16 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2310113 | 2310113 | 2022-03-15 | Marshall | Tennessee | 47117 | 10334 | 116 |
2306860 | 2306860 | 2022-03-14 | Marshall | Tennessee | 47117 | 10334 | 116 |
2303609 | 2303609 | 2022-03-13 | Marshall | Tennessee | 47117 | 10334 | 116 |
2300357 | 2300357 | 2022-03-12 | Marshall | Tennessee | 47117 | 10334 | 116 |
2297105 | 2297105 | 2022-03-11 | Marshall | Tennessee | 47117 | 10334 | 116 |
2293853 | 2293853 | 2022-03-10 | Marshall | Tennessee | 47117 | 10334 | 116 |
2290601 | 2290601 | 2022-03-09 | Marshall | Tennessee | 47117 | 10334 | 116 |
2287349 | 2287349 | 2022-03-08 | Marshall | Tennessee | 47117 | 10312 | 116 |
2284097 | 2284097 | 2022-03-07 | Marshall | Tennessee | 47117 | 10312 | 116 |
2280845 | 2280845 | 2022-03-06 | Marshall | Tennessee | 47117 | 10312 | 116 |
2277592 | 2277592 | 2022-03-05 | Marshall | Tennessee | 47117 | 10312 | 116 |
2274339 | 2274339 | 2022-03-04 | Marshall | Tennessee | 47117 | 10312 | 116 |
2271086 | 2271086 | 2022-03-03 | Marshall | Tennessee | 47117 | 10312 | 116 |
2267834 | 2267834 | 2022-03-02 | Marshall | Tennessee | 47117 | 10312 | 116 |
2196298 | 2196298 | 2022-02-08 | Marion | Tennessee | 47115 | 7950 | 116 |
2196335 | 2196335 | 2022-02-08 | Weakley | Tennessee | 47183 | 8825 | 116 |
2193044 | 2193044 | 2022-02-07 | Marion | Tennessee | 47115 | 7950 | 116 |
2193081 | 2193081 | 2022-02-07 | Weakley | Tennessee | 47183 | 8825 | 116 |
2189790 | 2189790 | 2022-02-06 | Marion | Tennessee | 47115 | 7950 | 116 |
2189827 | 2189827 | 2022-02-06 | Weakley | Tennessee | 47183 | 8825 | 116 |
2186537 | 2186537 | 2022-02-05 | Marion | Tennessee | 47115 | 7950 | 116 |
2186574 | 2186574 | 2022-02-05 | Weakley | Tennessee | 47183 | 8825 | 116 |
2183285 | 2183285 | 2022-02-04 | Marion | Tennessee | 47115 | 7950 | 116 |
2183322 | 2183322 | 2022-02-04 | Weakley | Tennessee | 47183 | 8825 | 116 |
2180033 | 2180033 | 2022-02-03 | Marion | Tennessee | 47115 | 7950 | 116 |
2180070 | 2180070 | 2022-02-03 | Weakley | Tennessee | 47183 | 8825 | 116 |
2176782 | 2176782 | 2022-02-02 | Marion | Tennessee | 47115 | 7950 | 116 |
2176819 | 2176819 | 2022-02-02 | Weakley | Tennessee | 47183 | 8825 | 116 |
2173528 | 2173528 | 2022-02-01 | Marion | Tennessee | 47115 | 7388 | 116 |
2170276 | 2170276 | 2022-01-31 | Marion | Tennessee | 47115 | 7388 | 116 |
2167022 | 2167022 | 2022-01-30 | Marion | Tennessee | 47115 | 7388 | 116 |
2163767 | 2163767 | 2022-01-29 | Marion | Tennessee | 47115 | 7388 | 116 |
2160512 | 2160512 | 2022-01-28 | Marion | Tennessee | 47115 | 7388 | 116 |
2157256 | 2157256 | 2022-01-27 | Marion | Tennessee | 47115 | 7388 | 116 |
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);