ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
387 rows where deaths = 18 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bledsoe 32
- Clay 14
- Sequatchie 14
- Cheatham 11
- DeKalb 11
- Jackson 11
- Lauderdale 11
- Claiborne 9
- McNairy 9
- Stewart 9
- Wayne 9
- Hancock 8
- Houston 8
- McMinn 8
- Anderson 7
- Cumberland 7
- Hardeman 7
- Maury 7
- Meigs 7
- Moore 7
- White 7
- Williamson 7
- Carter 6
- Chester 6
- Dickson 6
- Dyer 6
- Fayette 6
- Humphreys 6
- Pickett 6
- Jefferson 5
- …
state 1
- Tennessee · 387 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1942627 | 1942627 | 2021-11-22 | Bledsoe | Tennessee | 47007 | 3542 | 18 |
1939377 | 1939377 | 2021-11-21 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1936127 | 1936127 | 2021-11-20 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1932877 | 1932877 | 2021-11-19 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1929626 | 1929626 | 2021-11-18 | Bledsoe | Tennessee | 47007 | 3526 | 18 |
1926376 | 1926376 | 2021-11-17 | Bledsoe | Tennessee | 47007 | 3524 | 18 |
1923126 | 1923126 | 2021-11-16 | Bledsoe | Tennessee | 47007 | 3520 | 18 |
1919877 | 1919877 | 2021-11-15 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1916627 | 1916627 | 2021-11-14 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1913377 | 1913377 | 2021-11-13 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1910127 | 1910127 | 2021-11-12 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1906878 | 1906878 | 2021-11-11 | Bledsoe | Tennessee | 47007 | 3515 | 18 |
1903629 | 1903629 | 2021-11-10 | Bledsoe | Tennessee | 47007 | 3515 | 18 |
1900379 | 1900379 | 2021-11-09 | Bledsoe | Tennessee | 47007 | 3514 | 18 |
1897129 | 1897129 | 2021-11-08 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1893879 | 1893879 | 2021-11-07 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1890629 | 1890629 | 2021-11-06 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1887379 | 1887379 | 2021-11-05 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1884129 | 1884129 | 2021-11-04 | Bledsoe | Tennessee | 47007 | 3506 | 18 |
1880880 | 1880880 | 2021-11-03 | Bledsoe | Tennessee | 47007 | 3502 | 18 |
1877631 | 1877631 | 2021-11-02 | Bledsoe | Tennessee | 47007 | 3503 | 18 |
1874382 | 1874382 | 2021-11-01 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1871133 | 1871133 | 2021-10-31 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1867884 | 1867884 | 2021-10-30 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1864635 | 1864635 | 2021-10-29 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1861386 | 1861386 | 2021-10-28 | Bledsoe | Tennessee | 47007 | 3491 | 18 |
1858137 | 1858137 | 2021-10-27 | Bledsoe | Tennessee | 47007 | 3486 | 18 |
1854888 | 1854888 | 2021-10-26 | Bledsoe | Tennessee | 47007 | 3485 | 18 |
1851639 | 1851639 | 2021-10-25 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1848389 | 1848389 | 2021-10-24 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1845139 | 1845139 | 2021-10-23 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1841889 | 1841889 | 2021-10-22 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1809430 | 1809430 | 2021-10-12 | Hancock | Tennessee | 47067 | 1175 | 18 |
1806180 | 1806180 | 2021-10-11 | Hancock | Tennessee | 47067 | 1167 | 18 |
1802930 | 1802930 | 2021-10-10 | Hancock | Tennessee | 47067 | 1158 | 18 |
1799681 | 1799681 | 2021-10-09 | Hancock | Tennessee | 47067 | 1158 | 18 |
1796432 | 1796432 | 2021-10-08 | Hancock | Tennessee | 47067 | 1158 | 18 |
1793183 | 1793183 | 2021-10-07 | Hancock | Tennessee | 47067 | 1154 | 18 |
1789934 | 1789934 | 2021-10-06 | Hancock | Tennessee | 47067 | 1152 | 18 |
1786686 | 1786686 | 2021-10-05 | Hancock | Tennessee | 47067 | 1146 | 18 |
1621036 | 1621036 | 2021-08-15 | Moore | Tennessee | 47127 | 1112 | 18 |
1617788 | 1617788 | 2021-08-14 | Moore | Tennessee | 47127 | 1112 | 18 |
1614540 | 1614540 | 2021-08-13 | Moore | Tennessee | 47127 | 1112 | 18 |
1611291 | 1611291 | 2021-08-12 | Moore | Tennessee | 47127 | 1103 | 18 |
1608043 | 1608043 | 2021-08-11 | Moore | Tennessee | 47127 | 1099 | 18 |
1604794 | 1604794 | 2021-08-10 | Moore | Tennessee | 47127 | 1096 | 18 |
1601545 | 1601545 | 2021-08-09 | Moore | Tennessee | 47127 | 1095 | 18 |
1017172 | 1017172 | 2021-02-10 | Van Buren | Tennessee | 47175 | 750 | 18 |
1000916 | 1000916 | 2021-02-05 | Meigs | Tennessee | 47121 | 1239 | 18 |
997670 | 997670 | 2021-02-04 | Meigs | Tennessee | 47121 | 1235 | 18 |
997694 | 997694 | 2021-02-04 | Trousdale | Tennessee | 47169 | 2337 | 18 |
994424 | 994424 | 2021-02-03 | Meigs | Tennessee | 47121 | 1230 | 18 |
991178 | 991178 | 2021-02-02 | Meigs | Tennessee | 47121 | 1226 | 18 |
987914 | 987914 | 2021-02-01 | Humphreys | Tennessee | 47085 | 1417 | 18 |
987932 | 987932 | 2021-02-01 | Meigs | Tennessee | 47121 | 1224 | 18 |
987936 | 987936 | 2021-02-01 | Morgan | Tennessee | 47129 | 2020 | 18 |
984667 | 984667 | 2021-01-31 | Humphreys | Tennessee | 47085 | 1415 | 18 |
984685 | 984685 | 2021-01-31 | Meigs | Tennessee | 47121 | 1224 | 18 |
984689 | 984689 | 2021-01-31 | Morgan | Tennessee | 47129 | 2019 | 18 |
981420 | 981420 | 2021-01-30 | Humphreys | Tennessee | 47085 | 1408 | 18 |
981438 | 981438 | 2021-01-30 | Meigs | Tennessee | 47121 | 1216 | 18 |
981447 | 981447 | 2021-01-30 | Polk | Tennessee | 47139 | 1558 | 18 |
978174 | 978174 | 2021-01-29 | Humphreys | Tennessee | 47085 | 1405 | 18 |
978201 | 978201 | 2021-01-29 | Polk | Tennessee | 47139 | 1543 | 18 |
974929 | 974929 | 2021-01-28 | Humphreys | Tennessee | 47085 | 1389 | 18 |
971684 | 971684 | 2021-01-27 | Humphreys | Tennessee | 47085 | 1385 | 18 |
952248 | 952248 | 2021-01-21 | Sequatchie | Tennessee | 47153 | 1385 | 18 |
949003 | 949003 | 2021-01-20 | Sequatchie | Tennessee | 47153 | 1383 | 18 |
945757 | 945757 | 2021-01-19 | Sequatchie | Tennessee | 47153 | 1376 | 18 |
942510 | 942510 | 2021-01-18 | Sequatchie | Tennessee | 47153 | 1371 | 18 |
939265 | 939265 | 2021-01-17 | Sequatchie | Tennessee | 47153 | 1365 | 18 |
936020 | 936020 | 2021-01-16 | Sequatchie | Tennessee | 47153 | 1356 | 18 |
932775 | 932775 | 2021-01-15 | Sequatchie | Tennessee | 47153 | 1333 | 18 |
929530 | 929530 | 2021-01-14 | Sequatchie | Tennessee | 47153 | 1325 | 18 |
926216 | 926216 | 2021-01-13 | Cannon | Tennessee | 47015 | 1525 | 18 |
926285 | 926285 | 2021-01-13 | Sequatchie | Tennessee | 47153 | 1319 | 18 |
926300 | 926300 | 2021-01-13 | Wayne | Tennessee | 47181 | 2580 | 18 |
923031 | 923031 | 2021-01-12 | Pickett | Tennessee | 47137 | 640 | 18 |
923039 | 923039 | 2021-01-12 | Sequatchie | Tennessee | 47153 | 1315 | 18 |
923054 | 923054 | 2021-01-12 | Wayne | Tennessee | 47181 | 2566 | 18 |
919786 | 919786 | 2021-01-11 | Pickett | Tennessee | 47137 | 634 | 18 |
919794 | 919794 | 2021-01-11 | Sequatchie | Tennessee | 47153 | 1311 | 18 |
919809 | 919809 | 2021-01-11 | Wayne | Tennessee | 47181 | 2562 | 18 |
916541 | 916541 | 2021-01-10 | Pickett | Tennessee | 47137 | 633 | 18 |
916549 | 916549 | 2021-01-10 | Sequatchie | Tennessee | 47153 | 1308 | 18 |
916564 | 916564 | 2021-01-10 | Wayne | Tennessee | 47181 | 2561 | 18 |
913275 | 913275 | 2021-01-09 | Lake | Tennessee | 47095 | 1503 | 18 |
913296 | 913296 | 2021-01-09 | Pickett | Tennessee | 47137 | 629 | 18 |
913304 | 913304 | 2021-01-09 | Sequatchie | Tennessee | 47153 | 1289 | 18 |
913319 | 913319 | 2021-01-09 | Wayne | Tennessee | 47181 | 2549 | 18 |
910051 | 910051 | 2021-01-08 | Pickett | Tennessee | 47137 | 624 | 18 |
910059 | 910059 | 2021-01-08 | Sequatchie | Tennessee | 47153 | 1277 | 18 |
910074 | 910074 | 2021-01-08 | Wayne | Tennessee | 47181 | 2539 | 18 |
906806 | 906806 | 2021-01-07 | Pickett | Tennessee | 47137 | 613 | 18 |
906829 | 906829 | 2021-01-07 | Wayne | Tennessee | 47181 | 2528 | 18 |
903583 | 903583 | 2021-01-06 | Wayne | Tennessee | 47181 | 2503 | 18 |
900333 | 900333 | 2021-01-05 | Union | Tennessee | 47173 | 1279 | 18 |
900338 | 900338 | 2021-01-05 | Wayne | Tennessee | 47181 | 2496 | 18 |
887275 | 887275 | 2021-01-01 | Claiborne | Tennessee | 47025 | 1682 | 18 |
884030 | 884030 | 2020-12-31 | Claiborne | Tennessee | 47025 | 1682 | 18 |
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);