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 96
- 47187 467
- 47037 464
- 47157 464
- 47163 462
- 47093 460
- 47065 459
- 47089 459
- 47149 459
- 47013 458
- 47155 456
- 47021 454
- 47147 454
- 47165 454
- 47035 453
- 47045 453
- 47125 453
- 47179 453
- 47189 453
- 47001 452
- 47009 452
- 47011 452
- 47043 452
- 47059 452
- 47063 452
- 47119 452
- 47167 452
- 47017 451
- 47029 451
- 47047 451
- 47123 451
- 47141 451
- 47145 451
- 47151 451
- 47023 450
- 47051 450
- 47053 450
- 47083 450
- 47105 450
- 47107 450
- 47115 450
- 47135 450
- 47025 448
- 47041 448
- 47061 448
- 47071 448
- 47103 448
- 47113 448
- 47133 448
- 47003 447
- 47073 447
- 47101 447
- 47185 447
- 47005 446
- 47015 446
- 47111 446
- 47121 446
- 47171 446
- 47159 445
- 47007 444
- 47019 444
- 47069 444
- 47091 444
- 47129 444
- 47169 444
- 47173 444
- 47183 444
- 47031 443
- 47075 443
- 47079 443
- 47109 443
- 47131 443
- 47049 442
- 47055 442
- 47099 442
- 47117 442
- 47177 442
- 47181 442
- 47085 441
- 47027 440
- 47057 440
- 47081 440
- 47097 440
- 47153 440
- 47087 439
- 47139 439
- 47161 437
- 47077 436
- 47039 433
- 47095 428
- 47175 428
- 47127 426
- 47143 424
- 47033 423
- 47137 401
- 47067 392
- - 378
county 96
- Williamson 467
- Davidson 464
- Shelby 464
- Sullivan 462
- Knox 460
- Hamilton 459
- Jefferson 459
- Rutherford 459
- Campbell 458
- Sevier 456
- Cheatham 454
- Robertson 454
- Sumner 454
- Cumberland 453
- Dyer 453
- Montgomery 453
- Washington 453
- Wilson 453
- Anderson 452
- Blount 452
- Bradley 452
- Dickson 452
- Greene 452
- Hamblen 452
- Maury 452
- Tipton 452
- Carroll 451
- Cocke 451
- Fayette 451
- Monroe 451
- Putnam 451
- Roane 451
- Scott 451
- Chester 450
- Franklin 450
- Gibson 450
- Houston 450
- Loudon 450
- Marion 450
- McMinn 450
- Perry 450
- Claiborne 448
- DeKalb 448
- Grundy 448
- Hardin 448
- Lincoln 448
- Madison 448
- Overton 448
- Bedford 447
- Hawkins 447
- Lewis 447
- White 447
- Benton 446
- Cannon 446
- Macon 446
- Meigs 446
- Unicoi 446
- Smith 445
- Bledsoe 444
- Carter 444
- Hardeman 444
- Johnson 444
- Morgan 444
- Trousdale 444
- Union 444
- Weakley 444
- Coffee 443
- Haywood 443
- Henry 443
- McNairy 443
- Obion 443
- Fentress 442
- Giles 442
- Lawrence 442
- Marshall 442
- Warren 442
- Wayne 442
- Humphreys 441
- Clay 440
- Grainger 440
- Hickman 440
- Lauderdale 440
- Sequatchie 440
- Jackson 439
- Polk 439
- Stewart 437
- Henderson 436
- Decatur 433
- Lake 428
- Van Buren 428
- Moore 426
- Rhea 424
- Crockett 423
- Pickett 401
- Hancock 392
- Unknown 378
state 1
- Tennessee · 42,751 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419655 | 1419655 | 2021-06-14 | Anderson | Tennessee | 47001 | 8847 | 172 |
1419656 | 1419656 | 2021-06-14 | Bedford | Tennessee | 47003 | 6694 | 131 |
1419657 | 1419657 | 2021-06-14 | Benton | Tennessee | 47005 | 1687 | 42 |
1419658 | 1419658 | 2021-06-14 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
1419659 | 1419659 | 2021-06-14 | Blount | Tennessee | 47009 | 15813 | 196 |
1419660 | 1419660 | 2021-06-14 | Bradley | Tennessee | 47011 | 15298 | 153 |
1419661 | 1419661 | 2021-06-14 | Campbell | Tennessee | 47013 | 4205 | 63 |
1419662 | 1419662 | 2021-06-14 | Cannon | Tennessee | 47015 | 1942 | 32 |
1419663 | 1419663 | 2021-06-14 | Carroll | Tennessee | 47017 | 3715 | 83 |
1419664 | 1419664 | 2021-06-14 | Carter | Tennessee | 47019 | 6717 | 159 |
1419665 | 1419665 | 2021-06-14 | Cheatham | Tennessee | 47021 | 4662 | 56 |
1419666 | 1419666 | 2021-06-14 | Chester | Tennessee | 47023 | 2183 | 51 |
1419667 | 1419667 | 2021-06-14 | Claiborne | Tennessee | 47025 | 3226 | 74 |
1419668 | 1419668 | 2021-06-14 | Clay | Tennessee | 47027 | 1107 | 31 |
1419669 | 1419669 | 2021-06-14 | Cocke | Tennessee | 47029 | 4548 | 100 |
1419670 | 1419670 | 2021-06-14 | Coffee | Tennessee | 47031 | 6987 | 125 |
1419671 | 1419671 | 2021-06-14 | Crockett | Tennessee | 47033 | 2063 | 50 |
1419672 | 1419672 | 2021-06-14 | Cumberland | Tennessee | 47035 | 6868 | 140 |
1419673 | 1419673 | 2021-06-14 | Davidson | Tennessee | 47037 | 99497 | 960 |
1419674 | 1419674 | 2021-06-14 | DeKalb | Tennessee | 47041 | 2859 | 55 |
1419675 | 1419675 | 2021-06-14 | Decatur | Tennessee | 47039 | 1620 | 39 |
1419676 | 1419676 | 2021-06-14 | Dickson | Tennessee | 47043 | 7073 | 116 |
1419677 | 1419677 | 2021-06-14 | Dyer | Tennessee | 47045 | 5510 | 108 |
1419678 | 1419678 | 2021-06-14 | Fayette | Tennessee | 47047 | 5176 | 84 |
1419679 | 1419679 | 2021-06-14 | Fentress | Tennessee | 47049 | 2516 | 49 |
1419680 | 1419680 | 2021-06-14 | Franklin | Tennessee | 47051 | 5230 | 91 |
1419681 | 1419681 | 2021-06-14 | Gibson | Tennessee | 47053 | 6677 | 148 |
1419682 | 1419682 | 2021-06-14 | Giles | Tennessee | 47055 | 4040 | 100 |
1419683 | 1419683 | 2021-06-14 | Grainger | Tennessee | 47057 | 2663 | 49 |
1419684 | 1419684 | 2021-06-14 | Greene | Tennessee | 47059 | 8002 | 159 |
1419685 | 1419685 | 2021-06-14 | Grundy | Tennessee | 47061 | 1802 | 35 |
1419686 | 1419686 | 2021-06-14 | Hamblen | Tennessee | 47063 | 8690 | 174 |
1419687 | 1419687 | 2021-06-14 | Hamilton | Tennessee | 47065 | 45306 | 505 |
1419688 | 1419688 | 2021-06-14 | Hancock | Tennessee | 47067 | 607 | 13 |
1419689 | 1419689 | 2021-06-14 | Hardeman | Tennessee | 47069 | 3562 | 65 |
1419690 | 1419690 | 2021-06-14 | Hardin | Tennessee | 47071 | 3607 | 69 |
1419691 | 1419691 | 2021-06-14 | Hawkins | Tennessee | 47073 | 6325 | 113 |
1419692 | 1419692 | 2021-06-14 | Haywood | Tennessee | 47075 | 2717 | 62 |
1419693 | 1419693 | 2021-06-14 | Henderson | Tennessee | 47077 | 3868 | 78 |
1419694 | 1419694 | 2021-06-14 | Henry | Tennessee | 47079 | 3381 | 76 |
1419695 | 1419695 | 2021-06-14 | Hickman | Tennessee | 47081 | 2885 | 47 |
1419696 | 1419696 | 2021-06-14 | Houston | Tennessee | 47083 | 1119 | 33 |
1419697 | 1419697 | 2021-06-14 | Humphreys | Tennessee | 47085 | 1927 | 28 |
1419698 | 1419698 | 2021-06-14 | Jackson | Tennessee | 47087 | 1354 | 36 |
1419699 | 1419699 | 2021-06-14 | Jefferson | Tennessee | 47089 | 6326 | 127 |
1419700 | 1419700 | 2021-06-14 | Johnson | Tennessee | 47091 | 2439 | 39 |
1419701 | 1419701 | 2021-06-14 | Knox | Tennessee | 47093 | 52113 | 642 |
1419702 | 1419702 | 2021-06-14 | Lake | Tennessee | 47095 | 1728 | 27 |
1419703 | 1419703 | 2021-06-14 | Lauderdale | Tennessee | 47097 | 3272 | 48 |
1419704 | 1419704 | 2021-06-14 | Lawrence | Tennessee | 47099 | 6105 | 94 |
1419705 | 1419705 | 2021-06-14 | Lewis | Tennessee | 47101 | 1618 | 26 |
1419706 | 1419706 | 2021-06-14 | Lincoln | Tennessee | 47103 | 4394 | 67 |
1419707 | 1419707 | 2021-06-14 | Loudon | Tennessee | 47105 | 6260 | 70 |
1419708 | 1419708 | 2021-06-14 | Macon | Tennessee | 47111 | 3671 | 78 |
1419709 | 1419709 | 2021-06-14 | Madison | Tennessee | 47113 | 11545 | 244 |
1419710 | 1419710 | 2021-06-14 | Marion | Tennessee | 47115 | 3217 | 47 |
1419711 | 1419711 | 2021-06-14 | Marshall | Tennessee | 47117 | 4306 | 60 |
1419712 | 1419712 | 2021-06-14 | Maury | Tennessee | 47119 | 13721 | 178 |
1419713 | 1419713 | 2021-06-14 | McMinn | Tennessee | 47107 | 6612 | 101 |
1419714 | 1419714 | 2021-06-14 | McNairy | Tennessee | 47109 | 2871 | 55 |
1419715 | 1419715 | 2021-06-14 | Meigs | Tennessee | 47121 | 1420 | 25 |
1419716 | 1419716 | 2021-06-14 | Monroe | Tennessee | 47123 | 6015 | 97 |
1419717 | 1419717 | 2021-06-14 | Montgomery | Tennessee | 47125 | 20907 | 231 |
1419718 | 1419718 | 2021-06-14 | Moore | Tennessee | 47127 | 1024 | 17 |
1419719 | 1419719 | 2021-06-14 | Morgan | Tennessee | 47129 | 2533 | 38 |
1419720 | 1419720 | 2021-06-14 | Obion | Tennessee | 47131 | 4623 | 97 |
1419721 | 1419721 | 2021-06-14 | Overton | Tennessee | 47133 | 3059 | 61 |
1419722 | 1419722 | 2021-06-14 | Perry | Tennessee | 47135 | 1076 | 28 |
1419723 | 1419723 | 2021-06-14 | Pickett | Tennessee | 47137 | 764 | 24 |
1419724 | 1419724 | 2021-06-14 | Polk | Tennessee | 47139 | 2112 | 25 |
1419725 | 1419725 | 2021-06-14 | Putnam | Tennessee | 47141 | 11904 | 180 |
1419726 | 1419726 | 2021-06-14 | Rhea | Tennessee | 47143 | 4402 | 75 |
1419727 | 1419727 | 2021-06-14 | Roane | Tennessee | 47145 | 6362 | 105 |
1419728 | 1419728 | 2021-06-14 | Robertson | Tennessee | 47147 | 9929 | 132 |
1419729 | 1419729 | 2021-06-14 | Rutherford | Tennessee | 47149 | 43601 | 444 |
1419730 | 1419730 | 2021-06-14 | Scott | Tennessee | 47151 | 3219 | 45 |
1419731 | 1419731 | 2021-06-14 | Sequatchie | Tennessee | 47153 | 1745 | 29 |
1419732 | 1419732 | 2021-06-14 | Sevier | Tennessee | 47155 | 13549 | 176 |
1419733 | 1419733 | 2021-06-14 | Shelby | Tennessee | 47157 | 99323 | 1681 |
1419734 | 1419734 | 2021-06-14 | Smith | Tennessee | 47159 | 2812 | 40 |
1419735 | 1419735 | 2021-06-14 | Stewart | Tennessee | 47161 | 1367 | 28 |
1419736 | 1419736 | 2021-06-14 | Sullivan | Tennessee | 47163 | 17280 | 304 |
1419737 | 1419737 | 2021-06-14 | Sumner | Tennessee | 47165 | 24449 | 352 |
1419738 | 1419738 | 2021-06-14 | Tipton | Tennessee | 47167 | 7465 | 105 |
1419739 | 1419739 | 2021-06-14 | Trousdale | Tennessee | 47169 | 2537 | 22 |
1419740 | 1419740 | 2021-06-14 | Unicoi | Tennessee | 47171 | 2057 | 49 |
1419741 | 1419741 | 2021-06-14 | Union | Tennessee | 47173 | 1959 | 34 |
1419742 | 1419742 | 2021-06-14 | Unknown | Tennessee | 7525 | 90 | |
1419743 | 1419743 | 2021-06-14 | Van Buren | Tennessee | 47175 | 866 | 23 |
1419744 | 1419744 | 2021-06-14 | Warren | Tennessee | 47177 | 5610 | 86 |
1419745 | 1419745 | 2021-06-14 | Washington | Tennessee | 47179 | 14842 | 251 |
1419746 | 1419746 | 2021-06-14 | Wayne | Tennessee | 47181 | 2996 | 35 |
1419747 | 1419747 | 2021-06-14 | Weakley | Tennessee | 47183 | 4220 | 67 |
1419748 | 1419748 | 2021-06-14 | White | Tennessee | 47185 | 3811 | 74 |
1419749 | 1419749 | 2021-06-14 | Williamson | Tennessee | 47187 | 28595 | 221 |
1419750 | 1419750 | 2021-06-14 | Wilson | Tennessee | 47189 | 19308 | 243 |
1416410 | 1416410 | 2021-06-13 | Anderson | Tennessee | 47001 | 8847 | 172 |
1416411 | 1416411 | 2021-06-13 | Bedford | Tennessee | 47003 | 6694 | 131 |
1416412 | 1416412 | 2021-06-13 | Benton | Tennessee | 47005 | 1687 | 42 |
1416413 | 1416413 | 2021-06-13 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
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);