ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2021-07-10 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1504049 | 1504049 | 2021-07-10 | Anderson | Tennessee | 47001 | 8822 | 176 |
1504050 | 1504050 | 2021-07-10 | Bedford | Tennessee | 47003 | 6730 | 132 |
1504051 | 1504051 | 2021-07-10 | Benton | Tennessee | 47005 | 1689 | 41 |
1504052 | 1504052 | 2021-07-10 | Bledsoe | Tennessee | 47007 | 2231 | 11 |
1504053 | 1504053 | 2021-07-10 | Blount | Tennessee | 47009 | 15976 | 200 |
1504054 | 1504054 | 2021-07-10 | Bradley | Tennessee | 47011 | 15343 | 155 |
1504055 | 1504055 | 2021-07-10 | Campbell | Tennessee | 47013 | 4212 | 62 |
1504056 | 1504056 | 2021-07-10 | Cannon | Tennessee | 47015 | 1946 | 32 |
1504057 | 1504057 | 2021-07-10 | Carroll | Tennessee | 47017 | 3723 | 83 |
1504058 | 1504058 | 2021-07-10 | Carter | Tennessee | 47019 | 6786 | 161 |
1504059 | 1504059 | 2021-07-10 | Cheatham | Tennessee | 47021 | 4680 | 56 |
1504060 | 1504060 | 2021-07-10 | Chester | Tennessee | 47023 | 2210 | 51 |
1504061 | 1504061 | 2021-07-10 | Claiborne | Tennessee | 47025 | 3243 | 74 |
1504062 | 1504062 | 2021-07-10 | Clay | Tennessee | 47027 | 1121 | 30 |
1504063 | 1504063 | 2021-07-10 | Cocke | Tennessee | 47029 | 4551 | 100 |
1504064 | 1504064 | 2021-07-10 | Coffee | Tennessee | 47031 | 6997 | 123 |
1504065 | 1504065 | 2021-07-10 | Crockett | Tennessee | 47033 | 2067 | 50 |
1504066 | 1504066 | 2021-07-10 | Cumberland | Tennessee | 47035 | 6897 | 141 |
1504067 | 1504067 | 2021-07-10 | Davidson | Tennessee | 47037 | 99657 | 953 |
1504068 | 1504068 | 2021-07-10 | DeKalb | Tennessee | 47041 | 2874 | 56 |
1504069 | 1504069 | 2021-07-10 | Decatur | Tennessee | 47039 | 1628 | 39 |
1504070 | 1504070 | 2021-07-10 | Dickson | Tennessee | 47043 | 7118 | 115 |
1504071 | 1504071 | 2021-07-10 | Dyer | Tennessee | 47045 | 5533 | 108 |
1504072 | 1504072 | 2021-07-10 | Fayette | Tennessee | 47047 | 5242 | 83 |
1504073 | 1504073 | 2021-07-10 | Fentress | Tennessee | 47049 | 2523 | 49 |
1504074 | 1504074 | 2021-07-10 | Franklin | Tennessee | 47051 | 5248 | 92 |
1504075 | 1504075 | 2021-07-10 | Gibson | Tennessee | 47053 | 6697 | 150 |
1504076 | 1504076 | 2021-07-10 | Giles | Tennessee | 47055 | 4056 | 100 |
1504077 | 1504077 | 2021-07-10 | Grainger | Tennessee | 47057 | 2684 | 50 |
1504078 | 1504078 | 2021-07-10 | Greene | Tennessee | 47059 | 8057 | 159 |
1504079 | 1504079 | 2021-07-10 | Grundy | Tennessee | 47061 | 1805 | 35 |
1504080 | 1504080 | 2021-07-10 | Hamblen | Tennessee | 47063 | 8703 | 174 |
1504081 | 1504081 | 2021-07-10 | Hamilton | Tennessee | 47065 | 45645 | 509 |
1504082 | 1504082 | 2021-07-10 | Hancock | Tennessee | 47067 | 621 | 13 |
1504083 | 1504083 | 2021-07-10 | Hardeman | Tennessee | 47069 | 3550 | 64 |
1504084 | 1504084 | 2021-07-10 | Hardin | Tennessee | 47071 | 3618 | 69 |
1504085 | 1504085 | 2021-07-10 | Hawkins | Tennessee | 47073 | 6353 | 114 |
1504086 | 1504086 | 2021-07-10 | Haywood | Tennessee | 47075 | 2721 | 62 |
1504087 | 1504087 | 2021-07-10 | Henderson | Tennessee | 47077 | 3869 | 79 |
1504088 | 1504088 | 2021-07-10 | Henry | Tennessee | 47079 | 3415 | 76 |
1504089 | 1504089 | 2021-07-10 | Hickman | Tennessee | 47081 | 2896 | 47 |
1504090 | 1504090 | 2021-07-10 | Houston | Tennessee | 47083 | 1122 | 34 |
1504091 | 1504091 | 2021-07-10 | Humphreys | Tennessee | 47085 | 1952 | 32 |
1504092 | 1504092 | 2021-07-10 | Jackson | Tennessee | 47087 | 1369 | 37 |
1504093 | 1504093 | 2021-07-10 | Jefferson | Tennessee | 47089 | 6349 | 126 |
1504094 | 1504094 | 2021-07-10 | Johnson | Tennessee | 47091 | 2450 | 39 |
1504095 | 1504095 | 2021-07-10 | Knox | Tennessee | 47093 | 52225 | 648 |
1504096 | 1504096 | 2021-07-10 | Lake | Tennessee | 47095 | 1728 | 30 |
1504097 | 1504097 | 2021-07-10 | Lauderdale | Tennessee | 47097 | 3270 | 50 |
1504098 | 1504098 | 2021-07-10 | Lawrence | Tennessee | 47099 | 6111 | 94 |
1504099 | 1504099 | 2021-07-10 | Lewis | Tennessee | 47101 | 1629 | 26 |
1504100 | 1504100 | 2021-07-10 | Lincoln | Tennessee | 47103 | 4418 | 67 |
1504101 | 1504101 | 2021-07-10 | Loudon | Tennessee | 47105 | 6246 | 71 |
1504102 | 1504102 | 2021-07-10 | Macon | Tennessee | 47111 | 3673 | 78 |
1504103 | 1504103 | 2021-07-10 | Madison | Tennessee | 47113 | 11608 | 245 |
1504104 | 1504104 | 2021-07-10 | Marion | Tennessee | 47115 | 3274 | 49 |
1504105 | 1504105 | 2021-07-10 | Marshall | Tennessee | 47117 | 4354 | 62 |
1504106 | 1504106 | 2021-07-10 | Maury | Tennessee | 47119 | 13768 | 177 |
1504107 | 1504107 | 2021-07-10 | McMinn | Tennessee | 47107 | 6675 | 104 |
1504108 | 1504108 | 2021-07-10 | McNairy | Tennessee | 47109 | 2884 | 56 |
1504109 | 1504109 | 2021-07-10 | Meigs | Tennessee | 47121 | 1432 | 24 |
1504110 | 1504110 | 2021-07-10 | Monroe | Tennessee | 47123 | 5994 | 97 |
1504111 | 1504111 | 2021-07-10 | Montgomery | Tennessee | 47125 | 21129 | 234 |
1504112 | 1504112 | 2021-07-10 | Moore | Tennessee | 47127 | 1033 | 17 |
1504113 | 1504113 | 2021-07-10 | Morgan | Tennessee | 47129 | 2561 | 37 |
1504114 | 1504114 | 2021-07-10 | Obion | Tennessee | 47131 | 4625 | 97 |
1504115 | 1504115 | 2021-07-10 | Overton | Tennessee | 47133 | 3093 | 62 |
1504116 | 1504116 | 2021-07-10 | Perry | Tennessee | 47135 | 1075 | 29 |
1504117 | 1504117 | 2021-07-10 | Pickett | Tennessee | 47137 | 773 | 24 |
1504118 | 1504118 | 2021-07-10 | Polk | Tennessee | 47139 | 2115 | 24 |
1504119 | 1504119 | 2021-07-10 | Putnam | Tennessee | 47141 | 11845 | 180 |
1504120 | 1504120 | 2021-07-10 | Rhea | Tennessee | 47143 | 4393 | 82 |
1504121 | 1504121 | 2021-07-10 | Roane | Tennessee | 47145 | 6381 | 109 |
1504122 | 1504122 | 2021-07-10 | Robertson | Tennessee | 47147 | 10003 | 141 |
1504123 | 1504123 | 2021-07-10 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1504124 | 1504124 | 2021-07-10 | Scott | Tennessee | 47151 | 3228 | 48 |
1504125 | 1504125 | 2021-07-10 | Sequatchie | Tennessee | 47153 | 1764 | 29 |
1504126 | 1504126 | 2021-07-10 | Sevier | Tennessee | 47155 | 13647 | 179 |
1504127 | 1504127 | 2021-07-10 | Shelby | Tennessee | 47157 | 100627 | 1699 |
1504128 | 1504128 | 2021-07-10 | Smith | Tennessee | 47159 | 2812 | 40 |
1504129 | 1504129 | 2021-07-10 | Stewart | Tennessee | 47161 | 1384 | 28 |
1504130 | 1504130 | 2021-07-10 | Sullivan | Tennessee | 47163 | 17388 | 312 |
1504131 | 1504131 | 2021-07-10 | Sumner | Tennessee | 47165 | 24687 | 355 |
1504132 | 1504132 | 2021-07-10 | Tipton | Tennessee | 47167 | 7502 | 104 |
1504133 | 1504133 | 2021-07-10 | Trousdale | Tennessee | 47169 | 2536 | 21 |
1504134 | 1504134 | 2021-07-10 | Unicoi | Tennessee | 47171 | 2074 | 50 |
1504135 | 1504135 | 2021-07-10 | Union | Tennessee | 47173 | 1958 | 34 |
1504136 | 1504136 | 2021-07-10 | Unknown | Tennessee | 7575 | 95 | |
1504137 | 1504137 | 2021-07-10 | Van Buren | Tennessee | 47175 | 872 | 23 |
1504138 | 1504138 | 2021-07-10 | Warren | Tennessee | 47177 | 5607 | 84 |
1504139 | 1504139 | 2021-07-10 | Washington | Tennessee | 47179 | 14884 | 254 |
1504140 | 1504140 | 2021-07-10 | Wayne | Tennessee | 47181 | 3012 | 36 |
1504141 | 1504141 | 2021-07-10 | Weakley | Tennessee | 47183 | 4245 | 69 |
1504142 | 1504142 | 2021-07-10 | White | Tennessee | 47185 | 3793 | 74 |
1504143 | 1504143 | 2021-07-10 | Williamson | Tennessee | 47187 | 28732 | 218 |
1504144 | 1504144 | 2021-07-10 | Wilson | Tennessee | 47189 | 19435 | 250 |
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);