ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
493 rows where deaths = 22 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Trousdale 149
- Moore 29
- Houston 25
- Tipton 21
- Hardeman 16
- Perry 15
- Hawkins 13
- Polk 13
- Hamblen 12
- Macon 12
- Marshall 11
- Humphreys 10
- Bledsoe 9
- Lake 8
- Marion 8
- Williamson 8
- DeKalb 7
- Fayette 7
- Rutherford 7
- Grundy 6
- Pickett 6
- Sequatchie 6
- Sullivan 6
- Davidson 5
- Grainger 5
- Cheatham 3
- Cocke 3
- Crockett 3
- Decatur 3
- Hardin 3
- …
state 1
- Tennessee · 493 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1975135 | 1975135 | 2021-12-02 | Bledsoe | Tennessee | 47007 | 3568 | 22 |
1971886 | 1971886 | 2021-12-01 | Bledsoe | Tennessee | 47007 | 3566 | 22 |
1968636 | 1968636 | 2021-11-30 | Bledsoe | Tennessee | 47007 | 3561 | 22 |
1965385 | 1965385 | 2021-11-29 | Bledsoe | Tennessee | 47007 | 3556 | 22 |
1962133 | 1962133 | 2021-11-28 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1958882 | 1958882 | 2021-11-27 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1955631 | 1955631 | 2021-11-26 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1952380 | 1952380 | 2021-11-25 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1949129 | 1949129 | 2021-11-24 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1923186 | 1923186 | 2021-11-16 | Moore | Tennessee | 47127 | 1445 | 22 |
1919937 | 1919937 | 2021-11-15 | Moore | Tennessee | 47127 | 1445 | 22 |
1916687 | 1916687 | 2021-11-14 | Moore | Tennessee | 47127 | 1441 | 22 |
1913437 | 1913437 | 2021-11-13 | Moore | Tennessee | 47127 | 1441 | 22 |
1910187 | 1910187 | 2021-11-12 | Moore | Tennessee | 47127 | 1441 | 22 |
1906938 | 1906938 | 2021-11-11 | Moore | Tennessee | 47127 | 1439 | 22 |
1903689 | 1903689 | 2021-11-10 | Moore | Tennessee | 47127 | 1439 | 22 |
1900439 | 1900439 | 2021-11-09 | Moore | Tennessee | 47127 | 1438 | 22 |
1897189 | 1897189 | 2021-11-08 | Moore | Tennessee | 47127 | 1438 | 22 |
1893939 | 1893939 | 2021-11-07 | Moore | Tennessee | 47127 | 1438 | 22 |
1890689 | 1890689 | 2021-11-06 | Moore | Tennessee | 47127 | 1438 | 22 |
1887439 | 1887439 | 2021-11-05 | Moore | Tennessee | 47127 | 1438 | 22 |
1884189 | 1884189 | 2021-11-04 | Moore | Tennessee | 47127 | 1438 | 22 |
1880940 | 1880940 | 2021-11-03 | Moore | Tennessee | 47127 | 1436 | 22 |
1877691 | 1877691 | 2021-11-02 | Moore | Tennessee | 47127 | 1436 | 22 |
1874442 | 1874442 | 2021-11-01 | Moore | Tennessee | 47127 | 1435 | 22 |
1871193 | 1871193 | 2021-10-31 | Moore | Tennessee | 47127 | 1435 | 22 |
1867944 | 1867944 | 2021-10-30 | Moore | Tennessee | 47127 | 1435 | 22 |
1864695 | 1864695 | 2021-10-29 | Moore | Tennessee | 47127 | 1435 | 22 |
1861446 | 1861446 | 2021-10-28 | Moore | Tennessee | 47127 | 1435 | 22 |
1858197 | 1858197 | 2021-10-27 | Moore | Tennessee | 47127 | 1432 | 22 |
1854948 | 1854948 | 2021-10-26 | Moore | Tennessee | 47127 | 1431 | 22 |
1851699 | 1851699 | 2021-10-25 | Moore | Tennessee | 47127 | 1429 | 22 |
1848449 | 1848449 | 2021-10-24 | Moore | Tennessee | 47127 | 1429 | 22 |
1845199 | 1845199 | 2021-10-23 | Moore | Tennessee | 47127 | 1429 | 22 |
1841949 | 1841949 | 2021-10-22 | Moore | Tennessee | 47127 | 1429 | 22 |
1838700 | 1838700 | 2021-10-21 | Moore | Tennessee | 47127 | 1429 | 22 |
1835451 | 1835451 | 2021-10-20 | Moore | Tennessee | 47127 | 1427 | 22 |
1832202 | 1832202 | 2021-10-19 | Moore | Tennessee | 47127 | 1427 | 22 |
1699018 | 1699018 | 2021-09-08 | Trousdale | Tennessee | 47169 | 2866 | 22 |
1695770 | 1695770 | 2021-09-07 | Trousdale | Tennessee | 47169 | 2861 | 22 |
1692522 | 1692522 | 2021-09-06 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1689273 | 1689273 | 2021-09-05 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1686023 | 1686023 | 2021-09-04 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1682772 | 1682772 | 2021-09-03 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1679522 | 1679522 | 2021-09-02 | Trousdale | Tennessee | 47169 | 2805 | 22 |
1676274 | 1676274 | 2021-09-01 | Trousdale | Tennessee | 47169 | 2805 | 22 |
1673027 | 1673027 | 2021-08-31 | Trousdale | Tennessee | 47169 | 2793 | 22 |
1669779 | 1669779 | 2021-08-30 | Trousdale | Tennessee | 47169 | 2777 | 22 |
1666532 | 1666532 | 2021-08-29 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1663284 | 1663284 | 2021-08-28 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1660036 | 1660036 | 2021-08-27 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1656787 | 1656787 | 2021-08-26 | Trousdale | Tennessee | 47169 | 2742 | 22 |
1653540 | 1653540 | 2021-08-25 | Trousdale | Tennessee | 47169 | 2729 | 22 |
1650293 | 1650293 | 2021-08-24 | Trousdale | Tennessee | 47169 | 2729 | 22 |
1647044 | 1647044 | 2021-08-23 | Trousdale | Tennessee | 47169 | 2722 | 22 |
1643795 | 1643795 | 2021-08-22 | Trousdale | Tennessee | 47169 | 2692 | 22 |
1640545 | 1640545 | 2021-08-21 | Trousdale | Tennessee | 47169 | 2692 | 22 |
1637295 | 1637295 | 2021-08-20 | Trousdale | Tennessee | 47169 | 2692 | 22 |
1634045 | 1634045 | 2021-08-19 | Trousdale | Tennessee | 47169 | 2680 | 22 |
1630798 | 1630798 | 2021-08-18 | Trousdale | Tennessee | 47169 | 2665 | 22 |
1627551 | 1627551 | 2021-08-17 | Trousdale | Tennessee | 47169 | 2663 | 22 |
1624304 | 1624304 | 2021-08-16 | Trousdale | Tennessee | 47169 | 2662 | 22 |
1621057 | 1621057 | 2021-08-15 | Trousdale | Tennessee | 47169 | 2652 | 22 |
1617809 | 1617809 | 2021-08-14 | Trousdale | Tennessee | 47169 | 2652 | 22 |
1614561 | 1614561 | 2021-08-13 | Trousdale | Tennessee | 47169 | 2652 | 22 |
1611312 | 1611312 | 2021-08-12 | Trousdale | Tennessee | 47169 | 2635 | 22 |
1608064 | 1608064 | 2021-08-11 | Trousdale | Tennessee | 47169 | 2627 | 22 |
1604815 | 1604815 | 2021-08-10 | Trousdale | Tennessee | 47169 | 2620 | 22 |
1601566 | 1601566 | 2021-08-09 | Trousdale | Tennessee | 47169 | 2612 | 22 |
1598318 | 1598318 | 2021-08-08 | Trousdale | Tennessee | 47169 | 2586 | 22 |
1595069 | 1595069 | 2021-08-07 | Trousdale | Tennessee | 47169 | 2586 | 22 |
1591820 | 1591820 | 2021-08-06 | Trousdale | Tennessee | 47169 | 2586 | 22 |
1588571 | 1588571 | 2021-08-05 | Trousdale | Tennessee | 47169 | 2580 | 22 |
1585321 | 1585321 | 2021-08-04 | Trousdale | Tennessee | 47169 | 2576 | 22 |
1582071 | 1582071 | 2021-08-03 | Trousdale | Tennessee | 47169 | 2571 | 22 |
1419739 | 1419739 | 2021-06-14 | Trousdale | Tennessee | 47169 | 2537 | 22 |
1416494 | 1416494 | 2021-06-13 | Trousdale | Tennessee | 47169 | 2537 | 22 |
1413248 | 1413248 | 2021-06-12 | Trousdale | Tennessee | 47169 | 2537 | 22 |
1410003 | 1410003 | 2021-06-11 | Trousdale | Tennessee | 47169 | 2537 | 22 |
1406758 | 1406758 | 2021-06-10 | Trousdale | Tennessee | 47169 | 2515 | 22 |
1403512 | 1403512 | 2021-06-09 | Trousdale | Tennessee | 47169 | 2513 | 22 |
1400267 | 1400267 | 2021-06-08 | Trousdale | Tennessee | 47169 | 2512 | 22 |
1397022 | 1397022 | 2021-06-07 | Trousdale | Tennessee | 47169 | 2512 | 22 |
1393775 | 1393775 | 2021-06-06 | Trousdale | Tennessee | 47169 | 2513 | 22 |
1390530 | 1390530 | 2021-06-05 | Trousdale | Tennessee | 47169 | 2513 | 22 |
1387285 | 1387285 | 2021-06-04 | Trousdale | Tennessee | 47169 | 2513 | 22 |
1384040 | 1384040 | 2021-06-03 | Trousdale | Tennessee | 47169 | 2511 | 22 |
1380794 | 1380794 | 2021-06-02 | Trousdale | Tennessee | 47169 | 2511 | 22 |
1377549 | 1377549 | 2021-06-01 | Trousdale | Tennessee | 47169 | 2511 | 22 |
1374303 | 1374303 | 2021-05-31 | Trousdale | Tennessee | 47169 | 2510 | 22 |
1371058 | 1371058 | 2021-05-30 | Trousdale | Tennessee | 47169 | 2510 | 22 |
1367812 | 1367812 | 2021-05-29 | Trousdale | Tennessee | 47169 | 2510 | 22 |
1364566 | 1364566 | 2021-05-28 | Trousdale | Tennessee | 47169 | 2510 | 22 |
1361320 | 1361320 | 2021-05-27 | Trousdale | Tennessee | 47169 | 2510 | 22 |
1358074 | 1358074 | 2021-05-26 | Trousdale | Tennessee | 47169 | 2509 | 22 |
1354828 | 1354828 | 2021-05-25 | Trousdale | Tennessee | 47169 | 2509 | 22 |
1351582 | 1351582 | 2021-05-24 | Trousdale | Tennessee | 47169 | 2509 | 22 |
1348336 | 1348336 | 2021-05-23 | Trousdale | Tennessee | 47169 | 2508 | 22 |
1345088 | 1345088 | 2021-05-22 | Trousdale | Tennessee | 47169 | 2508 | 22 |
1341840 | 1341840 | 2021-05-21 | Trousdale | Tennessee | 47169 | 2508 | 22 |
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);