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 2020-09-20 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
553129 | 553129 | 2020-09-20 | Anderson | Tennessee | 47001 | 1123 | 11 |
553130 | 553130 | 2020-09-20 | Bedford | Tennessee | 47003 | 1305 | 16 |
553131 | 553131 | 2020-09-20 | Benton | Tennessee | 47005 | 332 | 9 |
553132 | 553132 | 2020-09-20 | Bledsoe | Tennessee | 47007 | 846 | 4 |
553133 | 553133 | 2020-09-20 | Blount | Tennessee | 47009 | 2433 | 23 |
553134 | 553134 | 2020-09-20 | Bradley | Tennessee | 47011 | 2850 | 16 |
553135 | 553135 | 2020-09-20 | Campbell | Tennessee | 47013 | 416 | 3 |
553136 | 553136 | 2020-09-20 | Cannon | Tennessee | 47015 | 275 | 0 |
553137 | 553137 | 2020-09-20 | Carroll | Tennessee | 47017 | 829 | 17 |
553138 | 553138 | 2020-09-20 | Carter | Tennessee | 47019 | 1124 | 27 |
553139 | 553139 | 2020-09-20 | Cheatham | Tennessee | 47021 | 788 | 10 |
553140 | 553140 | 2020-09-20 | Chester | Tennessee | 47023 | 585 | 9 |
553141 | 553141 | 2020-09-20 | Claiborne | Tennessee | 47025 | 425 | 4 |
553142 | 553142 | 2020-09-20 | Clay | Tennessee | 47027 | 187 | 5 |
553143 | 553143 | 2020-09-20 | Cocke | Tennessee | 47029 | 732 | 9 |
553144 | 553144 | 2020-09-20 | Coffee | Tennessee | 47031 | 1097 | 12 |
553145 | 553145 | 2020-09-20 | Crockett | Tennessee | 47033 | 509 | 19 |
553146 | 553146 | 2020-09-20 | Cumberland | Tennessee | 47035 | 1152 | 17 |
553147 | 553147 | 2020-09-20 | Davidson | Tennessee | 47037 | 28002 | 289 |
553148 | 553148 | 2020-09-20 | DeKalb | Tennessee | 47041 | 544 | 11 |
553149 | 553149 | 2020-09-20 | Decatur | Tennessee | 47039 | 470 | 6 |
553150 | 553150 | 2020-09-20 | Dickson | Tennessee | 47043 | 1193 | 12 |
553151 | 553151 | 2020-09-20 | Dyer | Tennessee | 47045 | 1266 | 12 |
553152 | 553152 | 2020-09-20 | Fayette | Tennessee | 47047 | 1139 | 18 |
553153 | 553153 | 2020-09-20 | Fentress | Tennessee | 47049 | 432 | 3 |
553154 | 553154 | 2020-09-20 | Franklin | Tennessee | 47051 | 906 | 7 |
553155 | 553155 | 2020-09-20 | Gibson | Tennessee | 47053 | 1523 | 19 |
553156 | 553156 | 2020-09-20 | Giles | Tennessee | 47055 | 560 | 17 |
553157 | 553157 | 2020-09-20 | Grainger | Tennessee | 47057 | 349 | 2 |
553158 | 553158 | 2020-09-20 | Greene | Tennessee | 47059 | 1106 | 37 |
553159 | 553159 | 2020-09-20 | Grundy | Tennessee | 47061 | 246 | 5 |
553160 | 553160 | 2020-09-20 | Hamblen | Tennessee | 47063 | 1836 | 25 |
553161 | 553161 | 2020-09-20 | Hamilton | Tennessee | 47065 | 9241 | 91 |
553162 | 553162 | 2020-09-20 | Hancock | Tennessee | 47067 | 107 | 3 |
553163 | 553163 | 2020-09-20 | Hardeman | Tennessee | 47069 | 1529 | 25 |
553164 | 553164 | 2020-09-20 | Hardin | Tennessee | 47071 | 967 | 14 |
553165 | 553165 | 2020-09-20 | Hawkins | Tennessee | 47073 | 766 | 16 |
553166 | 553166 | 2020-09-20 | Haywood | Tennessee | 47075 | 918 | 16 |
553167 | 553167 | 2020-09-20 | Henderson | Tennessee | 47077 | 1124 | 19 |
553168 | 553168 | 2020-09-20 | Henry | Tennessee | 47079 | 601 | 9 |
553169 | 553169 | 2020-09-20 | Hickman | Tennessee | 47081 | 530 | 4 |
553170 | 553170 | 2020-09-20 | Houston | Tennessee | 47083 | 185 | 0 |
553171 | 553171 | 2020-09-20 | Humphreys | Tennessee | 47085 | 227 | 3 |
553172 | 553172 | 2020-09-20 | Jackson | Tennessee | 47087 | 305 | 4 |
553173 | 553173 | 2020-09-20 | Jefferson | Tennessee | 47089 | 1066 | 14 |
553174 | 553174 | 2020-09-20 | Johnson | Tennessee | 47091 | 645 | 2 |
553175 | 553175 | 2020-09-20 | Knox | Tennessee | 47093 | 9497 | 73 |
553176 | 553176 | 2020-09-20 | Lake | Tennessee | 47095 | 873 | 2 |
553177 | 553177 | 2020-09-20 | Lauderdale | Tennessee | 47097 | 937 | 15 |
553178 | 553178 | 2020-09-20 | Lawrence | Tennessee | 47099 | 954 | 11 |
553179 | 553179 | 2020-09-20 | Lewis | Tennessee | 47101 | 177 | 1 |
553180 | 553180 | 2020-09-20 | Lincoln | Tennessee | 47103 | 578 | 1 |
553181 | 553181 | 2020-09-20 | Loudon | Tennessee | 47105 | 1112 | 6 |
553182 | 553182 | 2020-09-20 | Macon | Tennessee | 47111 | 1015 | 19 |
553183 | 553183 | 2020-09-20 | Madison | Tennessee | 47113 | 2641 | 56 |
553184 | 553184 | 2020-09-20 | Marion | Tennessee | 47115 | 499 | 7 |
553185 | 553185 | 2020-09-20 | Marshall | Tennessee | 47117 | 713 | 5 |
553186 | 553186 | 2020-09-20 | Maury | Tennessee | 47119 | 2238 | 23 |
553187 | 553187 | 2020-09-20 | McMinn | Tennessee | 47107 | 1063 | 24 |
553188 | 553188 | 2020-09-20 | McNairy | Tennessee | 47109 | 807 | 16 |
553189 | 553189 | 2020-09-20 | Meigs | Tennessee | 47121 | 220 | 3 |
553190 | 553190 | 2020-09-20 | Monroe | Tennessee | 47123 | 995 | 16 |
553191 | 553191 | 2020-09-20 | Montgomery | Tennessee | 47125 | 2952 | 43 |
553192 | 553192 | 2020-09-20 | Moore | Tennessee | 47127 | 153 | 1 |
553193 | 553193 | 2020-09-20 | Morgan | Tennessee | 47129 | 304 | 3 |
553194 | 553194 | 2020-09-20 | Obion | Tennessee | 47131 | 1088 | 9 |
553195 | 553195 | 2020-09-20 | Overton | Tennessee | 47133 | 678 | 4 |
553196 | 553196 | 2020-09-20 | Perry | Tennessee | 47135 | 143 | 0 |
553197 | 553197 | 2020-09-20 | Pickett | Tennessee | 47137 | 96 | 2 |
553198 | 553198 | 2020-09-20 | Polk | Tennessee | 47139 | 377 | 11 |
553199 | 553199 | 2020-09-20 | Putnam | Tennessee | 47141 | 3061 | 37 |
553200 | 553200 | 2020-09-20 | Rhea | Tennessee | 47143 | 772 | 11 |
553201 | 553201 | 2020-09-20 | Roane | Tennessee | 47145 | 835 | 4 |
553202 | 553202 | 2020-09-20 | Robertson | Tennessee | 47147 | 2162 | 33 |
553203 | 553203 | 2020-09-20 | Rutherford | Tennessee | 47149 | 8986 | 87 |
553204 | 553204 | 2020-09-20 | Scott | Tennessee | 47151 | 200 | 2 |
553205 | 553205 | 2020-09-20 | Sequatchie | Tennessee | 47153 | 222 | 3 |
553206 | 553206 | 2020-09-20 | Sevier | Tennessee | 47155 | 2515 | 13 |
553207 | 553207 | 2020-09-20 | Shelby | Tennessee | 47157 | 30255 | 447 |
553208 | 553208 | 2020-09-20 | Smith | Tennessee | 47159 | 673 | 10 |
553209 | 553209 | 2020-09-20 | Stewart | Tennessee | 47161 | 173 | 2 |
553210 | 553210 | 2020-09-20 | Sullivan | Tennessee | 47163 | 2051 | 31 |
553211 | 553211 | 2020-09-20 | Sumner | Tennessee | 47165 | 4686 | 93 |
553212 | 553212 | 2020-09-20 | Tipton | Tennessee | 47167 | 1733 | 17 |
553213 | 553213 | 2020-09-20 | Trousdale | Tennessee | 47169 | 1651 | 7 |
553214 | 553214 | 2020-09-20 | Unicoi | Tennessee | 47171 | 277 | 1 |
553215 | 553215 | 2020-09-20 | Union | Tennessee | 47173 | 334 | 1 |
553216 | 553216 | 2020-09-20 | Unknown | Tennessee | 0 | 2 | |
553217 | 553217 | 2020-09-20 | Van Buren | Tennessee | 47175 | 153 | 0 |
553218 | 553218 | 2020-09-20 | Warren | Tennessee | 47177 | 1007 | 7 |
553219 | 553219 | 2020-09-20 | Washington | Tennessee | 47179 | 2167 | 32 |
553220 | 553220 | 2020-09-20 | Wayne | Tennessee | 47181 | 1479 | 5 |
553221 | 553221 | 2020-09-20 | Weakley | Tennessee | 47183 | 1117 | 19 |
553222 | 553222 | 2020-09-20 | White | Tennessee | 47185 | 776 | 9 |
553223 | 553223 | 2020-09-20 | Williamson | Tennessee | 47187 | 5077 | 36 |
553224 | 553224 | 2020-09-20 | Wilson | Tennessee | 47189 | 3358 | 41 |
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);