ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where deaths = 95 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Monroe 46
- Unknown 38
- Obion 22
- McMinn 15
- Lawrence 13
- Roane 13
- Giles 12
- Johnson 10
- White 10
- Franklin 7
- Grainger 7
- Haywood 7
- Hickman 7
- Hamilton 4
- Henderson 4
- Carroll 3
- Henry 3
- Knox 3
- Marshall 3
- Weakley 3
- Campbell 2
- Davidson 2
- Gibson 2
- Jefferson 2
- Loudon 2
- Maury 2
- Warren 2
- Bedford 1
- Bradley 1
- Carter 1
- …
state 1
- Tennessee · 256 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502156 | 2502156 | 2022-05-13 | Johnson | Tennessee | 47091 | 5181 | 95 |
2498898 | 2498898 | 2022-05-12 | Johnson | Tennessee | 47091 | 5181 | 95 |
2495640 | 2495640 | 2022-05-11 | Johnson | Tennessee | 47091 | 5181 | 95 |
2492382 | 2492382 | 2022-05-10 | Johnson | Tennessee | 47091 | 5174 | 95 |
2489124 | 2489124 | 2022-05-09 | Johnson | Tennessee | 47091 | 5174 | 95 |
2485867 | 2485867 | 2022-05-08 | Johnson | Tennessee | 47091 | 5174 | 95 |
2482609 | 2482609 | 2022-05-07 | Johnson | Tennessee | 47091 | 5174 | 95 |
2479351 | 2479351 | 2022-05-06 | Johnson | Tennessee | 47091 | 5174 | 95 |
2476093 | 2476093 | 2022-05-05 | Johnson | Tennessee | 47091 | 5174 | 95 |
2472836 | 2472836 | 2022-05-04 | Johnson | Tennessee | 47091 | 5174 | 95 |
2264562 | 2264562 | 2022-03-01 | Haywood | Tennessee | 47075 | 6081 | 95 |
2261312 | 2261312 | 2022-02-28 | Haywood | Tennessee | 47075 | 6081 | 95 |
2258061 | 2258061 | 2022-02-27 | Haywood | Tennessee | 47075 | 6081 | 95 |
2254810 | 2254810 | 2022-02-26 | Haywood | Tennessee | 47075 | 6081 | 95 |
2251559 | 2251559 | 2022-02-25 | Haywood | Tennessee | 47075 | 6081 | 95 |
2248308 | 2248308 | 2022-02-24 | Haywood | Tennessee | 47075 | 6081 | 95 |
2245057 | 2245057 | 2022-02-23 | Haywood | Tennessee | 47075 | 6081 | 95 |
2173513 | 2173513 | 2022-02-01 | Hickman | Tennessee | 47081 | 5947 | 95 |
2170261 | 2170261 | 2022-01-31 | Hickman | Tennessee | 47081 | 5947 | 95 |
2167007 | 2167007 | 2022-01-30 | Hickman | Tennessee | 47081 | 5947 | 95 |
2163752 | 2163752 | 2022-01-29 | Hickman | Tennessee | 47081 | 5947 | 95 |
2160497 | 2160497 | 2022-01-28 | Hickman | Tennessee | 47081 | 5947 | 95 |
2157241 | 2157241 | 2022-01-27 | Hickman | Tennessee | 47081 | 5947 | 95 |
2153988 | 2153988 | 2022-01-26 | Hickman | Tennessee | 47081 | 5947 | 95 |
2150724 | 2150724 | 2022-01-25 | Grainger | Tennessee | 47057 | 5400 | 95 |
2147472 | 2147472 | 2022-01-24 | Grainger | Tennessee | 47057 | 5400 | 95 |
2144218 | 2144218 | 2022-01-23 | Grainger | Tennessee | 47057 | 5400 | 95 |
2140963 | 2140963 | 2022-01-22 | Grainger | Tennessee | 47057 | 5400 | 95 |
2137707 | 2137707 | 2022-01-21 | Grainger | Tennessee | 47057 | 5400 | 95 |
2134453 | 2134453 | 2022-01-20 | Grainger | Tennessee | 47057 | 5400 | 95 |
2131201 | 2131201 | 2022-01-19 | Grainger | Tennessee | 47057 | 5400 | 95 |
2020646 | 2020646 | 2021-12-16 | Campbell | Tennessee | 47013 | 7752 | 95 |
2017395 | 2017395 | 2021-12-15 | Campbell | Tennessee | 47013 | 7743 | 95 |
2007693 | 2007693 | 2021-12-12 | Marshall | Tennessee | 47117 | 7096 | 95 |
2004442 | 2004442 | 2021-12-11 | Marshall | Tennessee | 47117 | 7096 | 95 |
2001191 | 2001191 | 2021-12-10 | Marshall | Tennessee | 47117 | 7096 | 95 |
1997977 | 1997977 | 2021-12-09 | Weakley | Tennessee | 47183 | 6508 | 95 |
1994726 | 1994726 | 2021-12-08 | Weakley | Tennessee | 47183 | 6508 | 95 |
1991475 | 1991475 | 2021-12-07 | Weakley | Tennessee | 47183 | 6495 | 95 |
1984921 | 1984921 | 2021-12-05 | Henry | Tennessee | 47079 | 5602 | 95 |
1981671 | 1981671 | 2021-12-04 | Henry | Tennessee | 47079 | 5602 | 95 |
1978421 | 1978421 | 2021-12-03 | Henry | Tennessee | 47079 | 5602 | 95 |
1968686 | 1968686 | 2021-11-30 | Macon | Tennessee | 47111 | 5568 | 95 |
1838689 | 1838689 | 2021-10-21 | Loudon | Tennessee | 47105 | 9073 | 95 |
1838730 | 1838730 | 2021-10-21 | White | Tennessee | 47185 | 5597 | 95 |
1835440 | 1835440 | 2021-10-20 | Loudon | Tennessee | 47105 | 9059 | 95 |
1835481 | 1835481 | 2021-10-20 | White | Tennessee | 47185 | 5581 | 95 |
1832232 | 1832232 | 2021-10-19 | White | Tennessee | 47185 | 5571 | 95 |
1828983 | 1828983 | 2021-10-18 | White | Tennessee | 47185 | 5565 | 95 |
1825734 | 1825734 | 2021-10-17 | White | Tennessee | 47185 | 5551 | 95 |
1822485 | 1822485 | 2021-10-16 | White | Tennessee | 47185 | 5551 | 95 |
1819236 | 1819236 | 2021-10-15 | White | Tennessee | 47185 | 5551 | 95 |
1815987 | 1815987 | 2021-10-14 | White | Tennessee | 47185 | 5544 | 95 |
1812739 | 1812739 | 2021-10-13 | White | Tennessee | 47185 | 5528 | 95 |
1809409 | 1809409 | 2021-10-12 | Claiborne | Tennessee | 47025 | 5300 | 95 |
1809490 | 1809490 | 2021-10-12 | White | Tennessee | 47185 | 5525 | 95 |
1783442 | 1783442 | 2021-10-04 | Henderson | Tennessee | 47077 | 5531 | 95 |
1780193 | 1780193 | 2021-10-03 | Henderson | Tennessee | 47077 | 5499 | 95 |
1776943 | 1776943 | 2021-10-02 | Henderson | Tennessee | 47077 | 5499 | 95 |
1773693 | 1773693 | 2021-10-01 | Henderson | Tennessee | 47077 | 5499 | 95 |
1770413 | 1770413 | 2021-09-30 | Carroll | Tennessee | 47017 | 5447 | 95 |
1767164 | 1767164 | 2021-09-29 | Carroll | Tennessee | 47017 | 5437 | 95 |
1763915 | 1763915 | 2021-09-28 | Carroll | Tennessee | 47017 | 5418 | 95 |
1747688 | 1747688 | 2021-09-23 | Fayette | Tennessee | 47047 | 6938 | 95 |
1741191 | 1741191 | 2021-09-21 | Franklin | Tennessee | 47051 | 7413 | 95 |
1737942 | 1737942 | 2021-09-20 | Franklin | Tennessee | 47051 | 7413 | 95 |
1734692 | 1734692 | 2021-09-19 | Franklin | Tennessee | 47051 | 7347 | 95 |
1731442 | 1731442 | 2021-09-18 | Franklin | Tennessee | 47051 | 7347 | 95 |
1728192 | 1728192 | 2021-09-17 | Franklin | Tennessee | 47051 | 7347 | 95 |
1724943 | 1724943 | 2021-09-16 | Franklin | Tennessee | 47051 | 7299 | 95 |
1721694 | 1721694 | 2021-09-15 | Franklin | Tennessee | 47051 | 7248 | 95 |
1718510 | 1718510 | 2021-09-14 | Warren | Tennessee | 47177 | 7665 | 95 |
1715262 | 1715262 | 2021-09-13 | Warren | Tennessee | 47177 | 7625 | 95 |
1650296 | 1650296 | 2021-08-24 | Unknown | Tennessee | 9603 | 95 | |
1647047 | 1647047 | 2021-08-23 | Unknown | Tennessee | 9575 | 95 | |
1608067 | 1608067 | 2021-08-11 | Unknown | Tennessee | 8501 | 95 | |
1604818 | 1604818 | 2021-08-10 | Unknown | Tennessee | 8408 | 95 | |
1598321 | 1598321 | 2021-08-08 | Unknown | Tennessee | 7918 | 95 | |
1595072 | 1595072 | 2021-08-07 | Unknown | Tennessee | 7918 | 95 | |
1591823 | 1591823 | 2021-08-06 | Unknown | Tennessee | 8551 | 95 | |
1588574 | 1588574 | 2021-08-05 | Unknown | Tennessee | 8478 | 95 | |
1578825 | 1578825 | 2021-08-02 | Unknown | Tennessee | 9008 | 95 | |
1575577 | 1575577 | 2021-08-01 | Unknown | Tennessee | 7719 | 95 | |
1572329 | 1572329 | 2021-07-31 | Unknown | Tennessee | 7719 | 95 | |
1569081 | 1569081 | 2021-07-30 | Unknown | Tennessee | 8137 | 95 | |
1562585 | 1562585 | 2021-07-28 | Unknown | Tennessee | 8003 | 95 | |
1559337 | 1559337 | 2021-07-27 | Unknown | Tennessee | 7952 | 95 | |
1556090 | 1556090 | 2021-07-26 | Unknown | Tennessee | 8383 | 95 | |
1552805 | 1552805 | 2021-07-25 | Lawrence | Tennessee | 47099 | 6176 | 95 |
1552843 | 1552843 | 2021-07-25 | Unknown | Tennessee | 7639 | 95 | |
1549558 | 1549558 | 2021-07-24 | Lawrence | Tennessee | 47099 | 6176 | 95 |
1549596 | 1549596 | 2021-07-24 | Unknown | Tennessee | 7639 | 95 | |
1546311 | 1546311 | 2021-07-23 | Lawrence | Tennessee | 47099 | 6176 | 95 |
1546349 | 1546349 | 2021-07-23 | Unknown | Tennessee | 7922 | 95 | |
1543102 | 1543102 | 2021-07-22 | Unknown | Tennessee | 7818 | 95 | |
1539816 | 1539816 | 2021-07-21 | Lawrence | Tennessee | 47099 | 6155 | 95 |
1539854 | 1539854 | 2021-07-21 | Unknown | Tennessee | 7842 | 95 | |
1536569 | 1536569 | 2021-07-20 | Lawrence | Tennessee | 47099 | 6141 | 95 |
1536607 | 1536607 | 2021-07-20 | Unknown | Tennessee | 7739 | 95 | |
1533321 | 1533321 | 2021-07-19 | Lawrence | Tennessee | 47099 | 6136 | 95 |
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);