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 588
- 47037 585
- 47157 585
- 47163 583
- 47093 581
- 47065 580
- 47089 580
- 47149 580
- 47013 579
- 47155 577
- 47021 575
- 47147 575
- 47165 575
- 47035 574
- 47045 574
- 47125 574
- 47179 574
- 47189 574
- 47001 573
- 47009 573
- 47011 573
- 47043 573
- 47059 573
- 47063 573
- 47119 573
- 47167 573
- 47017 572
- 47029 572
- 47047 572
- 47123 572
- …
county >30
- Williamson 588
- Davidson 585
- Shelby 585
- Sullivan 583
- Knox 581
- Hamilton 580
- Jefferson 580
- Rutherford 580
- Campbell 579
- Sevier 577
- Cheatham 575
- Robertson 575
- Sumner 575
- Cumberland 574
- Dyer 574
- Montgomery 574
- Washington 574
- Wilson 574
- Anderson 573
- Blount 573
- Bradley 573
- Dickson 573
- Greene 573
- Hamblen 573
- Maury 573
- Tipton 573
- Carroll 572
- Cocke 572
- Fayette 572
- Monroe 572
- …
state 1
- Tennessee · 54,367 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812646 | 1812646 | 2021-10-13 | Anderson | Tennessee | 47001 | 12684 | 211 |
1812647 | 1812647 | 2021-10-13 | Bedford | Tennessee | 47003 | 8969 | 153 |
1812648 | 1812648 | 2021-10-13 | Benton | Tennessee | 47005 | 2731 | 50 |
1812649 | 1812649 | 2021-10-13 | Bledsoe | Tennessee | 47007 | 3438 | 17 |
1812650 | 1812650 | 2021-10-13 | Blount | Tennessee | 47009 | 23338 | 254 |
1812651 | 1812651 | 2021-10-13 | Bradley | Tennessee | 47011 | 21790 | 187 |
1812652 | 1812652 | 2021-10-13 | Campbell | Tennessee | 47013 | 6923 | 79 |
1812653 | 1812653 | 2021-10-13 | Cannon | Tennessee | 47015 | 2757 | 39 |
1812654 | 1812654 | 2021-10-13 | Carroll | Tennessee | 47017 | 5644 | 100 |
1812655 | 1812655 | 2021-10-13 | Carter | Tennessee | 47019 | 10330 | 207 |
1812656 | 1812656 | 2021-10-13 | Cheatham | Tennessee | 47021 | 6912 | 66 |
1812657 | 1812657 | 2021-10-13 | Chester | Tennessee | 47023 | 3484 | 72 |
1812658 | 1812658 | 2021-10-13 | Claiborne | Tennessee | 47025 | 5320 | 94 |
1812659 | 1812659 | 2021-10-13 | Clay | Tennessee | 47027 | 1493 | 36 |
1812660 | 1812660 | 2021-10-13 | Cocke | Tennessee | 47029 | 7223 | 103 |
1812661 | 1812661 | 2021-10-13 | Coffee | Tennessee | 47031 | 10368 | 149 |
1812662 | 1812662 | 2021-10-13 | Crockett | Tennessee | 47033 | 3321 | 62 |
1812663 | 1812663 | 2021-10-13 | Cumberland | Tennessee | 47035 | 10887 | 212 |
1812664 | 1812664 | 2021-10-13 | Davidson | Tennessee | 47037 | 130692 | 1128 |
1812665 | 1812665 | 2021-10-13 | DeKalb | Tennessee | 47041 | 4154 | 67 |
1812666 | 1812666 | 2021-10-13 | Decatur | Tennessee | 47039 | 2394 | 44 |
1812667 | 1812667 | 2021-10-13 | Dickson | Tennessee | 47043 | 10201 | 160 |
1812668 | 1812668 | 2021-10-13 | Dyer | Tennessee | 47045 | 8035 | 142 |
1812669 | 1812669 | 2021-10-13 | Fayette | Tennessee | 47047 | 7208 | 100 |
1812670 | 1812670 | 2021-10-13 | Fentress | Tennessee | 47049 | 3563 | 62 |
1812671 | 1812671 | 2021-10-13 | Franklin | Tennessee | 47051 | 7813 | 100 |
1812672 | 1812672 | 2021-10-13 | Gibson | Tennessee | 47053 | 10532 | 186 |
1812673 | 1812673 | 2021-10-13 | Giles | Tennessee | 47055 | 5943 | 114 |
1812674 | 1812674 | 2021-10-13 | Grainger | Tennessee | 47057 | 4262 | 63 |
1812675 | 1812675 | 2021-10-13 | Greene | Tennessee | 47059 | 13270 | 234 |
1812676 | 1812676 | 2021-10-13 | Grundy | Tennessee | 47061 | 2768 | 37 |
1812677 | 1812677 | 2021-10-13 | Hamblen | Tennessee | 47063 | 12839 | 191 |
1812678 | 1812678 | 2021-10-13 | Hamilton | Tennessee | 47065 | 62975 | 638 |
1812679 | 1812679 | 2021-10-13 | Hancock | Tennessee | 47067 | 1183 | 19 |
1812680 | 1812680 | 2021-10-13 | Hardeman | Tennessee | 47069 | 5057 | 79 |
1812681 | 1812681 | 2021-10-13 | Hardin | Tennessee | 47071 | 5469 | 81 |
1812682 | 1812682 | 2021-10-13 | Hawkins | Tennessee | 47073 | 10040 | 163 |
1812683 | 1812683 | 2021-10-13 | Haywood | Tennessee | 47075 | 3784 | 72 |
1812684 | 1812684 | 2021-10-13 | Henderson | Tennessee | 47077 | 5649 | 99 |
1812685 | 1812685 | 2021-10-13 | Henry | Tennessee | 47079 | 5417 | 84 |
1812686 | 1812686 | 2021-10-13 | Hickman | Tennessee | 47081 | 4525 | 72 |
1812687 | 1812687 | 2021-10-13 | Houston | Tennessee | 47083 | 1808 | 43 |
1812688 | 1812688 | 2021-10-13 | Humphreys | Tennessee | 47085 | 3141 | 44 |
1812689 | 1812689 | 2021-10-13 | Jackson | Tennessee | 47087 | 2047 | 39 |
1812690 | 1812690 | 2021-10-13 | Jefferson | Tennessee | 47089 | 9746 | 140 |
1812691 | 1812691 | 2021-10-13 | Johnson | Tennessee | 47091 | 3473 | 46 |
1812692 | 1812692 | 2021-10-13 | Knox | Tennessee | 47093 | 77105 | 878 |
1812693 | 1812693 | 2021-10-13 | Lake | Tennessee | 47095 | 2004 | 31 |
1812694 | 1812694 | 2021-10-13 | Lauderdale | Tennessee | 47097 | 5178 | 62 |
1812695 | 1812695 | 2021-10-13 | Lawrence | Tennessee | 47099 | 9410 | 115 |
1812696 | 1812696 | 2021-10-13 | Lewis | Tennessee | 47101 | 2496 | 37 |
1812697 | 1812697 | 2021-10-13 | Lincoln | Tennessee | 47103 | 6572 | 81 |
1812698 | 1812698 | 2021-10-13 | Loudon | Tennessee | 47105 | 8971 | 93 |
1812699 | 1812699 | 2021-10-13 | Macon | Tennessee | 47111 | 5399 | 88 |
1812700 | 1812700 | 2021-10-13 | Madison | Tennessee | 47113 | 17382 | 297 |
1812701 | 1812701 | 2021-10-13 | Marion | Tennessee | 47115 | 5675 | 52 |
1812702 | 1812702 | 2021-10-13 | Marshall | Tennessee | 47117 | 6764 | 83 |
1812703 | 1812703 | 2021-10-13 | Maury | Tennessee | 47119 | 19112 | 223 |
1812704 | 1812704 | 2021-10-13 | McMinn | Tennessee | 47107 | 10309 | 123 |
1812705 | 1812705 | 2021-10-13 | McNairy | Tennessee | 47109 | 4535 | 65 |
1812706 | 1812706 | 2021-10-13 | Meigs | Tennessee | 47121 | 2138 | 28 |
1812707 | 1812707 | 2021-10-13 | Monroe | Tennessee | 47123 | 9559 | 118 |
1812708 | 1812708 | 2021-10-13 | Montgomery | Tennessee | 47125 | 32350 | 322 |
1812709 | 1812709 | 2021-10-13 | Moore | Tennessee | 47127 | 1420 | 20 |
1812710 | 1812710 | 2021-10-13 | Morgan | Tennessee | 47129 | 3732 | 46 |
1812711 | 1812711 | 2021-10-13 | Obion | Tennessee | 47131 | 6526 | 110 |
1812712 | 1812712 | 2021-10-13 | Overton | Tennessee | 47133 | 4715 | 78 |
1812713 | 1812713 | 2021-10-13 | Perry | Tennessee | 47135 | 1584 | 34 |
1812714 | 1812714 | 2021-10-13 | Pickett | Tennessee | 47137 | 1065 | 24 |
1812715 | 1812715 | 2021-10-13 | Polk | Tennessee | 47139 | 3141 | 29 |
1812716 | 1812716 | 2021-10-13 | Putnam | Tennessee | 47141 | 16478 | 213 |
1812717 | 1812717 | 2021-10-13 | Rhea | Tennessee | 47143 | 6890 | 91 |
1812718 | 1812718 | 2021-10-13 | Roane | Tennessee | 47145 | 9786 | 147 |
1812719 | 1812719 | 2021-10-13 | Robertson | Tennessee | 47147 | 13900 | 175 |
1812720 | 1812720 | 2021-10-13 | Rutherford | Tennessee | 47149 | 60909 | 525 |
1812721 | 1812721 | 2021-10-13 | Scott | Tennessee | 47151 | 5030 | 57 |
1812722 | 1812722 | 2021-10-13 | Sequatchie | Tennessee | 47153 | 2935 | 32 |
1812723 | 1812723 | 2021-10-13 | Sevier | Tennessee | 47155 | 19653 | 254 |
1812724 | 1812724 | 2021-10-13 | Shelby | Tennessee | 47157 | 144149 | 2187 |
1812725 | 1812725 | 2021-10-13 | Smith | Tennessee | 47159 | 4131 | 50 |
1812726 | 1812726 | 2021-10-13 | Stewart | Tennessee | 47161 | 2101 | 34 |
1812727 | 1812727 | 2021-10-13 | Sullivan | Tennessee | 47163 | 26162 | 412 |
1812728 | 1812728 | 2021-10-13 | Sumner | Tennessee | 47165 | 33735 | 405 |
1812729 | 1812729 | 2021-10-13 | Tipton | Tennessee | 47167 | 11207 | 126 |
1812730 | 1812730 | 2021-10-13 | Trousdale | Tennessee | 47169 | 3128 | 25 |
1812731 | 1812731 | 2021-10-13 | Unicoi | Tennessee | 47171 | 3088 | 63 |
1812732 | 1812732 | 2021-10-13 | Union | Tennessee | 47173 | 3010 | 42 |
1812733 | 1812733 | 2021-10-13 | Unknown | Tennessee | 8432 | 117 | |
1812734 | 1812734 | 2021-10-13 | Van Buren | Tennessee | 47175 | 1208 | 27 |
1812735 | 1812735 | 2021-10-13 | Warren | Tennessee | 47177 | 8460 | 113 |
1812736 | 1812736 | 2021-10-13 | Washington | Tennessee | 47179 | 21270 | 321 |
1812737 | 1812737 | 2021-10-13 | Wayne | Tennessee | 47181 | 3996 | 39 |
1812738 | 1812738 | 2021-10-13 | Weakley | Tennessee | 47183 | 6184 | 87 |
1812739 | 1812739 | 2021-10-13 | White | Tennessee | 47185 | 5528 | 95 |
1812740 | 1812740 | 2021-10-13 | Williamson | Tennessee | 47187 | 39106 | 264 |
1812741 | 1812741 | 2021-10-13 | Wilson | Tennessee | 47189 | 26715 | 325 |
1809397 | 1809397 | 2021-10-12 | Anderson | Tennessee | 47001 | 12648 | 209 |
1809398 | 1809398 | 2021-10-12 | Bedford | Tennessee | 47003 | 8949 | 153 |
1809399 | 1809399 | 2021-10-12 | Benton | Tennessee | 47005 | 2723 | 50 |
1809400 | 1809400 | 2021-10-12 | Bledsoe | Tennessee | 47007 | 3431 | 16 |
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);