ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-10-31" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1871130 | 1871130 | 2021-10-31 | Anderson | Tennessee | 47001 | 13000 | 218 |
1871131 | 1871131 | 2021-10-31 | Bedford | Tennessee | 47003 | 9195 | 155 |
1871132 | 1871132 | 2021-10-31 | Benton | Tennessee | 47005 | 2800 | 53 |
1871133 | 1871133 | 2021-10-31 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1871134 | 1871134 | 2021-10-31 | Blount | Tennessee | 47009 | 23759 | 269 |
1871135 | 1871135 | 2021-10-31 | Bradley | Tennessee | 47011 | 22157 | 197 |
1871136 | 1871136 | 2021-10-31 | Campbell | Tennessee | 47013 | 7268 | 80 |
1871137 | 1871137 | 2021-10-31 | Cannon | Tennessee | 47015 | 2800 | 43 |
1871138 | 1871138 | 2021-10-31 | Carroll | Tennessee | 47017 | 5761 | 103 |
1871139 | 1871139 | 2021-10-31 | Carter | Tennessee | 47019 | 10541 | 215 |
1871140 | 1871140 | 2021-10-31 | Cheatham | Tennessee | 47021 | 7015 | 70 |
1871141 | 1871141 | 2021-10-31 | Chester | Tennessee | 47023 | 3523 | 75 |
1871142 | 1871142 | 2021-10-31 | Claiborne | Tennessee | 47025 | 5452 | 112 |
1871143 | 1871143 | 2021-10-31 | Clay | Tennessee | 47027 | 1530 | 37 |
1871144 | 1871144 | 2021-10-31 | Cocke | Tennessee | 47029 | 7415 | 107 |
1871145 | 1871145 | 2021-10-31 | Coffee | Tennessee | 47031 | 10551 | 159 |
1871146 | 1871146 | 2021-10-31 | Crockett | Tennessee | 47033 | 3357 | 62 |
1871147 | 1871147 | 2021-10-31 | Cumberland | Tennessee | 47035 | 11095 | 224 |
1871148 | 1871148 | 2021-10-31 | Davidson | Tennessee | 47037 | 132647 | 1164 |
1871149 | 1871149 | 2021-10-31 | DeKalb | Tennessee | 47041 | 4211 | 72 |
1871150 | 1871150 | 2021-10-31 | Decatur | Tennessee | 47039 | 2433 | 44 |
1871151 | 1871151 | 2021-10-31 | Dickson | Tennessee | 47043 | 10435 | 165 |
1871152 | 1871152 | 2021-10-31 | Dyer | Tennessee | 47045 | 8083 | 145 |
1871153 | 1871153 | 2021-10-31 | Fayette | Tennessee | 47047 | 7308 | 106 |
1871154 | 1871154 | 2021-10-31 | Fentress | Tennessee | 47049 | 3667 | 67 |
1871155 | 1871155 | 2021-10-31 | Franklin | Tennessee | 47051 | 7963 | 102 |
1871156 | 1871156 | 2021-10-31 | Gibson | Tennessee | 47053 | 10658 | 189 |
1871157 | 1871157 | 2021-10-31 | Giles | Tennessee | 47055 | 6080 | 123 |
1871158 | 1871158 | 2021-10-31 | Grainger | Tennessee | 47057 | 4356 | 67 |
1871159 | 1871159 | 2021-10-31 | Greene | Tennessee | 47059 | 13685 | 242 |
1871160 | 1871160 | 2021-10-31 | Grundy | Tennessee | 47061 | 2847 | 38 |
1871161 | 1871161 | 2021-10-31 | Hamblen | Tennessee | 47063 | 13023 | 202 |
1871162 | 1871162 | 2021-10-31 | Hamilton | Tennessee | 47065 | 64029 | 651 |
1871163 | 1871163 | 2021-10-31 | Hancock | Tennessee | 47067 | 1214 | 20 |
1871164 | 1871164 | 2021-10-31 | Hardeman | Tennessee | 47069 | 5112 | 81 |
1871165 | 1871165 | 2021-10-31 | Hardin | Tennessee | 47071 | 5542 | 81 |
1871166 | 1871166 | 2021-10-31 | Hawkins | Tennessee | 47073 | 10247 | 167 |
1871167 | 1871167 | 2021-10-31 | Haywood | Tennessee | 47075 | 3810 | 76 |
1871168 | 1871168 | 2021-10-31 | Henderson | Tennessee | 47077 | 5756 | 102 |
1871169 | 1871169 | 2021-10-31 | Henry | Tennessee | 47079 | 5472 | 86 |
1871170 | 1871170 | 2021-10-31 | Hickman | Tennessee | 47081 | 4612 | 75 |
1871171 | 1871171 | 2021-10-31 | Houston | Tennessee | 47083 | 1839 | 44 |
1871172 | 1871172 | 2021-10-31 | Humphreys | Tennessee | 47085 | 3240 | 47 |
1871173 | 1871173 | 2021-10-31 | Jackson | Tennessee | 47087 | 2081 | 40 |
1871174 | 1871174 | 2021-10-31 | Jefferson | Tennessee | 47089 | 9952 | 145 |
1871175 | 1871175 | 2021-10-31 | Johnson | Tennessee | 47091 | 3577 | 48 |
1871176 | 1871176 | 2021-10-31 | Knox | Tennessee | 47093 | 78694 | 926 |
1871177 | 1871177 | 2021-10-31 | Lake | Tennessee | 47095 | 2020 | 31 |
1871178 | 1871178 | 2021-10-31 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1871179 | 1871179 | 2021-10-31 | Lawrence | Tennessee | 47099 | 9557 | 124 |
1871180 | 1871180 | 2021-10-31 | Lewis | Tennessee | 47101 | 2525 | 38 |
1871181 | 1871181 | 2021-10-31 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1871182 | 1871182 | 2021-10-31 | Loudon | Tennessee | 47105 | 9154 | 97 |
1871183 | 1871183 | 2021-10-31 | Macon | Tennessee | 47111 | 5466 | 93 |
1871184 | 1871184 | 2021-10-31 | Madison | Tennessee | 47113 | 17643 | 314 |
1871185 | 1871185 | 2021-10-31 | Marion | Tennessee | 47115 | 5783 | 54 |
1871186 | 1871186 | 2021-10-31 | Marshall | Tennessee | 47117 | 6868 | 88 |
1871187 | 1871187 | 2021-10-31 | Maury | Tennessee | 47119 | 19386 | 230 |
1871188 | 1871188 | 2021-10-31 | McMinn | Tennessee | 47107 | 10529 | 132 |
1871189 | 1871189 | 2021-10-31 | McNairy | Tennessee | 47109 | 4631 | 70 |
1871190 | 1871190 | 2021-10-31 | Meigs | Tennessee | 47121 | 2181 | 28 |
1871191 | 1871191 | 2021-10-31 | Monroe | Tennessee | 47123 | 9715 | 124 |
1871192 | 1871192 | 2021-10-31 | Montgomery | Tennessee | 47125 | 32904 | 338 |
1871193 | 1871193 | 2021-10-31 | Moore | Tennessee | 47127 | 1435 | 22 |
1871194 | 1871194 | 2021-10-31 | Morgan | Tennessee | 47129 | 3815 | 49 |
1871195 | 1871195 | 2021-10-31 | Obion | Tennessee | 47131 | 6625 | 110 |
1871196 | 1871196 | 2021-10-31 | Overton | Tennessee | 47133 | 4791 | 82 |
1871197 | 1871197 | 2021-10-31 | Perry | Tennessee | 47135 | 1616 | 34 |
1871198 | 1871198 | 2021-10-31 | Pickett | Tennessee | 47137 | 1087 | 24 |
1871199 | 1871199 | 2021-10-31 | Polk | Tennessee | 47139 | 3187 | 31 |
1871200 | 1871200 | 2021-10-31 | Putnam | Tennessee | 47141 | 16738 | 218 |
1871201 | 1871201 | 2021-10-31 | Rhea | Tennessee | 47143 | 6988 | 93 |
1871202 | 1871202 | 2021-10-31 | Roane | Tennessee | 47145 | 10026 | 153 |
1871203 | 1871203 | 2021-10-31 | Robertson | Tennessee | 47147 | 14084 | 189 |
1871204 | 1871204 | 2021-10-31 | Rutherford | Tennessee | 47149 | 61914 | 551 |
1871205 | 1871205 | 2021-10-31 | Scott | Tennessee | 47151 | 5293 | 60 |
1871206 | 1871206 | 2021-10-31 | Sequatchie | Tennessee | 47153 | 2997 | 33 |
1871207 | 1871207 | 2021-10-31 | Sevier | Tennessee | 47155 | 20106 | 271 |
1871208 | 1871208 | 2021-10-31 | Shelby | Tennessee | 47157 | 146005 | 2256 |
1871209 | 1871209 | 2021-10-31 | Smith | Tennessee | 47159 | 4175 | 52 |
1871210 | 1871210 | 2021-10-31 | Stewart | Tennessee | 47161 | 2147 | 35 |
1871211 | 1871211 | 2021-10-31 | Sullivan | Tennessee | 47163 | 26816 | 427 |
1871212 | 1871212 | 2021-10-31 | Sumner | Tennessee | 47165 | 34283 | 409 |
1871213 | 1871213 | 2021-10-31 | Tipton | Tennessee | 47167 | 11350 | 130 |
1871214 | 1871214 | 2021-10-31 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1871215 | 1871215 | 2021-10-31 | Unicoi | Tennessee | 47171 | 3147 | 65 |
1871216 | 1871216 | 2021-10-31 | Union | Tennessee | 47173 | 3146 | 46 |
1871217 | 1871217 | 2021-10-31 | Unknown | Tennessee | 8339 | 121 | |
1871218 | 1871218 | 2021-10-31 | Van Buren | Tennessee | 47175 | 1247 | 27 |
1871219 | 1871219 | 2021-10-31 | Warren | Tennessee | 47177 | 8618 | 121 |
1871220 | 1871220 | 2021-10-31 | Washington | Tennessee | 47179 | 21666 | 327 |
1871221 | 1871221 | 2021-10-31 | Wayne | Tennessee | 47181 | 4052 | 39 |
1871222 | 1871222 | 2021-10-31 | Weakley | Tennessee | 47183 | 6247 | 89 |
1871223 | 1871223 | 2021-10-31 | White | Tennessee | 47185 | 5633 | 97 |
1871224 | 1871224 | 2021-10-31 | Williamson | Tennessee | 47187 | 39707 | 269 |
1871225 | 1871225 | 2021-10-31 | Wilson | Tennessee | 47189 | 27123 | 337 |
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);