ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74,719 rows where state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 47187 596
- 47037 593
- 47157 593
- 47163 591
- 47093 589
- 47065 588
- 47089 588
- 47149 588
- 47013 587
- 47155 585
- 47021 583
- 47147 583
- 47165 583
- 47035 582
- 47045 582
- 47125 582
- 47179 582
- 47189 582
- 47001 581
- 47009 581
- 47011 581
- 47043 581
- 47059 581
- 47063 581
- 47119 581
- 47167 581
- 47017 580
- 47029 580
- 47047 580
- 47123 580
- …
county >30
- Williamson 596
- Davidson 593
- Shelby 593
- Sullivan 591
- Knox 589
- Hamilton 588
- Jefferson 588
- Rutherford 588
- Campbell 587
- Sevier 585
- Cheatham 583
- Robertson 583
- Sumner 583
- Cumberland 582
- Dyer 582
- Montgomery 582
- Washington 582
- Wilson 582
- Anderson 581
- Blount 581
- Bradley 581
- Dickson 581
- Greene 581
- Hamblen 581
- Maury 581
- Tipton 581
- Carroll 580
- Cocke 580
- Fayette 580
- Monroe 580
- …
state 1
- Tennessee · 55,135 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1838637 | 1838637 | 2021-10-21 | Anderson | Tennessee | 47001 | 12853 | 215 |
1838638 | 1838638 | 2021-10-21 | Bedford | Tennessee | 47003 | 9103 | 154 |
1838639 | 1838639 | 2021-10-21 | Benton | Tennessee | 47005 | 2766 | 51 |
1838640 | 1838640 | 2021-10-21 | Bledsoe | Tennessee | 47007 | 3479 | 17 |
1838641 | 1838641 | 2021-10-21 | Blount | Tennessee | 47009 | 23571 | 265 |
1838642 | 1838642 | 2021-10-21 | Bradley | Tennessee | 47011 | 22008 | 191 |
1838643 | 1838643 | 2021-10-21 | Campbell | Tennessee | 47013 | 7172 | 79 |
1838644 | 1838644 | 2021-10-21 | Cannon | Tennessee | 47015 | 2786 | 40 |
1838645 | 1838645 | 2021-10-21 | Carroll | Tennessee | 47017 | 5704 | 102 |
1838646 | 1838646 | 2021-10-21 | Carter | Tennessee | 47019 | 10469 | 213 |
1838647 | 1838647 | 2021-10-21 | Cheatham | Tennessee | 47021 | 6972 | 70 |
1838648 | 1838648 | 2021-10-21 | Chester | Tennessee | 47023 | 3506 | 73 |
1838649 | 1838649 | 2021-10-21 | Claiborne | Tennessee | 47025 | 5379 | 111 |
1838650 | 1838650 | 2021-10-21 | Clay | Tennessee | 47027 | 1516 | 36 |
1838651 | 1838651 | 2021-10-21 | Cocke | Tennessee | 47029 | 7339 | 106 |
1838652 | 1838652 | 2021-10-21 | Coffee | Tennessee | 47031 | 10475 | 155 |
1838653 | 1838653 | 2021-10-21 | Crockett | Tennessee | 47033 | 3343 | 62 |
1838654 | 1838654 | 2021-10-21 | Cumberland | Tennessee | 47035 | 11000 | 216 |
1838655 | 1838655 | 2021-10-21 | Davidson | Tennessee | 47037 | 131623 | 1146 |
1838656 | 1838656 | 2021-10-21 | DeKalb | Tennessee | 47041 | 4173 | 70 |
1838657 | 1838657 | 2021-10-21 | Decatur | Tennessee | 47039 | 2415 | 44 |
1838658 | 1838658 | 2021-10-21 | Dickson | Tennessee | 47043 | 10334 | 163 |
1838659 | 1838659 | 2021-10-21 | Dyer | Tennessee | 47045 | 8063 | 145 |
1838660 | 1838660 | 2021-10-21 | Fayette | Tennessee | 47047 | 7263 | 105 |
1838661 | 1838661 | 2021-10-21 | Fentress | Tennessee | 47049 | 3613 | 65 |
1838662 | 1838662 | 2021-10-21 | Franklin | Tennessee | 47051 | 7891 | 102 |
1838663 | 1838663 | 2021-10-21 | Gibson | Tennessee | 47053 | 10607 | 189 |
1838664 | 1838664 | 2021-10-21 | Giles | Tennessee | 47055 | 6027 | 117 |
1838665 | 1838665 | 2021-10-21 | Grainger | Tennessee | 47057 | 4317 | 66 |
1838666 | 1838666 | 2021-10-21 | Greene | Tennessee | 47059 | 13531 | 240 |
1838667 | 1838667 | 2021-10-21 | Grundy | Tennessee | 47061 | 2813 | 37 |
1838668 | 1838668 | 2021-10-21 | Hamblen | Tennessee | 47063 | 12947 | 197 |
1838669 | 1838669 | 2021-10-21 | Hamilton | Tennessee | 47065 | 63632 | 647 |
1838670 | 1838670 | 2021-10-21 | Hancock | Tennessee | 47067 | 1201 | 20 |
1838671 | 1838671 | 2021-10-21 | Hardeman | Tennessee | 47069 | 5093 | 79 |
1838672 | 1838672 | 2021-10-21 | Hardin | Tennessee | 47071 | 5515 | 81 |
1838673 | 1838673 | 2021-10-21 | Hawkins | Tennessee | 47073 | 10136 | 167 |
1838674 | 1838674 | 2021-10-21 | Haywood | Tennessee | 47075 | 3793 | 75 |
1838675 | 1838675 | 2021-10-21 | Henderson | Tennessee | 47077 | 5715 | 99 |
1838676 | 1838676 | 2021-10-21 | Henry | Tennessee | 47079 | 5447 | 86 |
1838677 | 1838677 | 2021-10-21 | Hickman | Tennessee | 47081 | 4568 | 75 |
1838678 | 1838678 | 2021-10-21 | Houston | Tennessee | 47083 | 1831 | 43 |
1838679 | 1838679 | 2021-10-21 | Humphreys | Tennessee | 47085 | 3200 | 45 |
1838680 | 1838680 | 2021-10-21 | Jackson | Tennessee | 47087 | 2066 | 40 |
1838681 | 1838681 | 2021-10-21 | Jefferson | Tennessee | 47089 | 9870 | 144 |
1838682 | 1838682 | 2021-10-21 | Johnson | Tennessee | 47091 | 3515 | 48 |
1838683 | 1838683 | 2021-10-21 | Knox | Tennessee | 47093 | 78054 | 911 |
1838684 | 1838684 | 2021-10-21 | Lake | Tennessee | 47095 | 2015 | 31 |
1838685 | 1838685 | 2021-10-21 | Lauderdale | Tennessee | 47097 | 5196 | 64 |
1838686 | 1838686 | 2021-10-21 | Lawrence | Tennessee | 47099 | 9496 | 119 |
1838687 | 1838687 | 2021-10-21 | Lewis | Tennessee | 47101 | 2514 | 38 |
1838688 | 1838688 | 2021-10-21 | Lincoln | Tennessee | 47103 | 6628 | 83 |
1838689 | 1838689 | 2021-10-21 | Loudon | Tennessee | 47105 | 9073 | 95 |
1838690 | 1838690 | 2021-10-21 | Macon | Tennessee | 47111 | 5438 | 92 |
1838691 | 1838691 | 2021-10-21 | Madison | Tennessee | 47113 | 17525 | 309 |
1838692 | 1838692 | 2021-10-21 | Marion | Tennessee | 47115 | 5736 | 53 |
1838693 | 1838693 | 2021-10-21 | Marshall | Tennessee | 47117 | 6827 | 85 |
1838694 | 1838694 | 2021-10-21 | Maury | Tennessee | 47119 | 19281 | 227 |
1838695 | 1838695 | 2021-10-21 | McMinn | Tennessee | 47107 | 10460 | 130 |
1838696 | 1838696 | 2021-10-21 | McNairy | Tennessee | 47109 | 4583 | 68 |
1838697 | 1838697 | 2021-10-21 | Meigs | Tennessee | 47121 | 2163 | 28 |
1838698 | 1838698 | 2021-10-21 | Monroe | Tennessee | 47123 | 9653 | 122 |
1838699 | 1838699 | 2021-10-21 | Montgomery | Tennessee | 47125 | 32690 | 328 |
1838700 | 1838700 | 2021-10-21 | Moore | Tennessee | 47127 | 1429 | 22 |
1838701 | 1838701 | 2021-10-21 | Morgan | Tennessee | 47129 | 3770 | 47 |
1838702 | 1838702 | 2021-10-21 | Obion | Tennessee | 47131 | 6589 | 110 |
1838703 | 1838703 | 2021-10-21 | Overton | Tennessee | 47133 | 4768 | 80 |
1838704 | 1838704 | 2021-10-21 | Perry | Tennessee | 47135 | 1600 | 34 |
1838705 | 1838705 | 2021-10-21 | Pickett | Tennessee | 47137 | 1076 | 24 |
1838706 | 1838706 | 2021-10-21 | Polk | Tennessee | 47139 | 3171 | 29 |
1838707 | 1838707 | 2021-10-21 | Putnam | Tennessee | 47141 | 16613 | 218 |
1838708 | 1838708 | 2021-10-21 | Rhea | Tennessee | 47143 | 6935 | 92 |
1838709 | 1838709 | 2021-10-21 | Roane | Tennessee | 47145 | 9926 | 149 |
1838710 | 1838710 | 2021-10-21 | Robertson | Tennessee | 47147 | 14011 | 184 |
1838711 | 1838711 | 2021-10-21 | Rutherford | Tennessee | 47149 | 61447 | 540 |
1838712 | 1838712 | 2021-10-21 | Scott | Tennessee | 47151 | 5171 | 58 |
1838713 | 1838713 | 2021-10-21 | Sequatchie | Tennessee | 47153 | 2967 | 32 |
1838714 | 1838714 | 2021-10-21 | Sevier | Tennessee | 47155 | 19929 | 266 |
1838715 | 1838715 | 2021-10-21 | Shelby | Tennessee | 47157 | 145070 | 2229 |
1838716 | 1838716 | 2021-10-21 | Smith | Tennessee | 47159 | 4154 | 52 |
1838717 | 1838717 | 2021-10-21 | Stewart | Tennessee | 47161 | 2125 | 35 |
1838718 | 1838718 | 2021-10-21 | Sullivan | Tennessee | 47163 | 26515 | 414 |
1838719 | 1838719 | 2021-10-21 | Sumner | Tennessee | 47165 | 34051 | 406 |
1838720 | 1838720 | 2021-10-21 | Tipton | Tennessee | 47167 | 11283 | 128 |
1838721 | 1838721 | 2021-10-21 | Trousdale | Tennessee | 47169 | 3149 | 26 |
1838722 | 1838722 | 2021-10-21 | Unicoi | Tennessee | 47171 | 3125 | 65 |
1838723 | 1838723 | 2021-10-21 | Union | Tennessee | 47173 | 3092 | 46 |
1838724 | 1838724 | 2021-10-21 | Unknown | Tennessee | 8607 | 121 | |
1838725 | 1838725 | 2021-10-21 | Van Buren | Tennessee | 47175 | 1233 | 27 |
1838726 | 1838726 | 2021-10-21 | Warren | Tennessee | 47177 | 8556 | 117 |
1838727 | 1838727 | 2021-10-21 | Washington | Tennessee | 47179 | 21501 | 322 |
1838728 | 1838728 | 2021-10-21 | Wayne | Tennessee | 47181 | 4024 | 39 |
1838729 | 1838729 | 2021-10-21 | Weakley | Tennessee | 47183 | 6228 | 88 |
1838730 | 1838730 | 2021-10-21 | White | Tennessee | 47185 | 5597 | 95 |
1838731 | 1838731 | 2021-10-21 | Williamson | Tennessee | 47187 | 39443 | 268 |
1838732 | 1838732 | 2021-10-21 | Wilson | Tennessee | 47189 | 26940 | 334 |
1835388 | 1835388 | 2021-10-20 | Anderson | Tennessee | 47001 | 12819 | 215 |
1835389 | 1835389 | 2021-10-20 | Bedford | Tennessee | 47003 | 9084 | 154 |
1835390 | 1835390 | 2021-10-20 | Benton | Tennessee | 47005 | 2764 | 50 |
1835391 | 1835391 | 2021-10-20 | Bledsoe | Tennessee | 47007 | 3477 | 17 |
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);