ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-07-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 |
---|---|---|---|---|---|---|---|
353118 | 353118 | 2020-07-20 | Anderson | Tennessee | 47001 | 300 | 3 |
353119 | 353119 | 2020-07-20 | Bedford | Tennessee | 47003 | 688 | 10 |
353120 | 353120 | 2020-07-20 | Benton | Tennessee | 47005 | 30 | 1 |
353121 | 353121 | 2020-07-20 | Bledsoe | Tennessee | 47007 | 641 | 1 |
353122 | 353122 | 2020-07-20 | Blount | Tennessee | 47009 | 538 | 7 |
353123 | 353123 | 2020-07-20 | Bradley | Tennessee | 47011 | 1239 | 7 |
353124 | 353124 | 2020-07-20 | Campbell | Tennessee | 47013 | 100 | 1 |
353125 | 353125 | 2020-07-20 | Cannon | Tennessee | 47015 | 71 | 0 |
353126 | 353126 | 2020-07-20 | Carroll | Tennessee | 47017 | 80 | 2 |
353127 | 353127 | 2020-07-20 | Carter | Tennessee | 47019 | 205 | 2 |
353128 | 353128 | 2020-07-20 | Cheatham | Tennessee | 47021 | 371 | 4 |
353129 | 353129 | 2020-07-20 | Chester | Tennessee | 47023 | 120 | 0 |
353130 | 353130 | 2020-07-20 | Claiborne | Tennessee | 47025 | 118 | 0 |
353131 | 353131 | 2020-07-20 | Clay | Tennessee | 47027 | 34 | 0 |
353132 | 353132 | 2020-07-20 | Cocke | Tennessee | 47029 | 217 | 1 |
353133 | 353133 | 2020-07-20 | Coffee | Tennessee | 47031 | 205 | 0 |
353134 | 353134 | 2020-07-20 | Crockett | Tennessee | 47033 | 105 | 3 |
353135 | 353135 | 2020-07-20 | Cumberland | Tennessee | 47035 | 255 | 6 |
353136 | 353136 | 2020-07-20 | Davidson | Tennessee | 47037 | 17836 | 166 |
353137 | 353137 | 2020-07-20 | DeKalb | Tennessee | 47041 | 145 | 1 |
353138 | 353138 | 2020-07-20 | Decatur | Tennessee | 47039 | 59 | 0 |
353139 | 353139 | 2020-07-20 | Dickson | Tennessee | 47043 | 390 | 0 |
353140 | 353140 | 2020-07-20 | Dyer | Tennessee | 47045 | 373 | 4 |
353141 | 353141 | 2020-07-20 | Fayette | Tennessee | 47047 | 473 | 7 |
353142 | 353142 | 2020-07-20 | Fentress | Tennessee | 47049 | 41 | 0 |
353143 | 353143 | 2020-07-20 | Franklin | Tennessee | 47051 | 164 | 3 |
353144 | 353144 | 2020-07-20 | Gibson | Tennessee | 47053 | 312 | 1 |
353145 | 353145 | 2020-07-20 | Giles | Tennessee | 47055 | 207 | 2 |
353146 | 353146 | 2020-07-20 | Grainger | Tennessee | 47057 | 74 | 0 |
353147 | 353147 | 2020-07-20 | Greene | Tennessee | 47059 | 223 | 3 |
353148 | 353148 | 2020-07-20 | Grundy | Tennessee | 47061 | 72 | 2 |
353149 | 353149 | 2020-07-20 | Hamblen | Tennessee | 47063 | 660 | 6 |
353150 | 353150 | 2020-07-20 | Hamilton | Tennessee | 47065 | 4360 | 40 |
353151 | 353151 | 2020-07-20 | Hancock | Tennessee | 47067 | 30 | 0 |
353152 | 353152 | 2020-07-20 | Hardeman | Tennessee | 47069 | 556 | 7 |
353153 | 353153 | 2020-07-20 | Hardin | Tennessee | 47071 | 203 | 7 |
353154 | 353154 | 2020-07-20 | Hawkins | Tennessee | 47073 | 145 | 2 |
353155 | 353155 | 2020-07-20 | Haywood | Tennessee | 47075 | 192 | 4 |
353156 | 353156 | 2020-07-20 | Henderson | Tennessee | 47077 | 175 | 0 |
353157 | 353157 | 2020-07-20 | Henry | Tennessee | 47079 | 63 | 0 |
353158 | 353158 | 2020-07-20 | Hickman | Tennessee | 47081 | 143 | 0 |
353159 | 353159 | 2020-07-20 | Houston | Tennessee | 47083 | 30 | 0 |
353160 | 353160 | 2020-07-20 | Humphreys | Tennessee | 47085 | 62 | 2 |
353161 | 353161 | 2020-07-20 | Jackson | Tennessee | 47087 | 72 | 0 |
353162 | 353162 | 2020-07-20 | Jefferson | Tennessee | 47089 | 264 | 1 |
353163 | 353163 | 2020-07-20 | Johnson | Tennessee | 47091 | 52 | 0 |
353164 | 353164 | 2020-07-20 | Knox | Tennessee | 47093 | 2427 | 19 |
353165 | 353165 | 2020-07-20 | Lake | Tennessee | 47095 | 702 | 0 |
353166 | 353166 | 2020-07-20 | Lauderdale | Tennessee | 47097 | 254 | 5 |
353167 | 353167 | 2020-07-20 | Lawrence | Tennessee | 47099 | 302 | 6 |
353168 | 353168 | 2020-07-20 | Lewis | Tennessee | 47101 | 19 | 0 |
353169 | 353169 | 2020-07-20 | Lincoln | Tennessee | 47103 | 143 | 0 |
353170 | 353170 | 2020-07-20 | Loudon | Tennessee | 47105 | 408 | 3 |
353171 | 353171 | 2020-07-20 | Macon | Tennessee | 47111 | 703 | 8 |
353172 | 353172 | 2020-07-20 | Madison | Tennessee | 47113 | 500 | 2 |
353173 | 353173 | 2020-07-20 | Marion | Tennessee | 47115 | 132 | 4 |
353174 | 353174 | 2020-07-20 | Marshall | Tennessee | 47117 | 166 | 2 |
353175 | 353175 | 2020-07-20 | Maury | Tennessee | 47119 | 665 | 4 |
353176 | 353176 | 2020-07-20 | McMinn | Tennessee | 47107 | 371 | 19 |
353177 | 353177 | 2020-07-20 | McNairy | Tennessee | 47109 | 162 | 1 |
353178 | 353178 | 2020-07-20 | Meigs | Tennessee | 47121 | 53 | 0 |
353179 | 353179 | 2020-07-20 | Monroe | Tennessee | 47123 | 185 | 7 |
353180 | 353180 | 2020-07-20 | Montgomery | Tennessee | 47125 | 1173 | 8 |
353181 | 353181 | 2020-07-20 | Moore | Tennessee | 47127 | 32 | 0 |
353182 | 353182 | 2020-07-20 | Morgan | Tennessee | 47129 | 42 | 1 |
353183 | 353183 | 2020-07-20 | Obion | Tennessee | 47131 | 175 | 3 |
353184 | 353184 | 2020-07-20 | Overton | Tennessee | 47133 | 91 | 1 |
353185 | 353185 | 2020-07-20 | Perry | Tennessee | 47135 | 49 | 0 |
353186 | 353186 | 2020-07-20 | Pickett | Tennessee | 47137 | 10 | 1 |
353187 | 353187 | 2020-07-20 | Polk | Tennessee | 47139 | 70 | 0 |
353188 | 353188 | 2020-07-20 | Putnam | Tennessee | 47141 | 1214 | 7 |
353189 | 353189 | 2020-07-20 | Rhea | Tennessee | 47143 | 401 | 0 |
353190 | 353190 | 2020-07-20 | Roane | Tennessee | 47145 | 125 | 0 |
353191 | 353191 | 2020-07-20 | Robertson | Tennessee | 47147 | 1143 | 14 |
353192 | 353192 | 2020-07-20 | Rutherford | Tennessee | 47149 | 4618 | 41 |
353193 | 353193 | 2020-07-20 | Scott | Tennessee | 47151 | 36 | 0 |
353194 | 353194 | 2020-07-20 | Sequatchie | Tennessee | 47153 | 61 | 0 |
353195 | 353195 | 2020-07-20 | Sevier | Tennessee | 47155 | 1112 | 4 |
353196 | 353196 | 2020-07-20 | Shelby | Tennessee | 47157 | 16767 | 245 |
353197 | 353197 | 2020-07-20 | Smith | Tennessee | 47159 | 219 | 2 |
353198 | 353198 | 2020-07-20 | Stewart | Tennessee | 47161 | 47 | 0 |
353199 | 353199 | 2020-07-20 | Sullivan | Tennessee | 47163 | 427 | 6 |
353200 | 353200 | 2020-07-20 | Sumner | Tennessee | 47165 | 2505 | 61 |
353201 | 353201 | 2020-07-20 | Tipton | Tennessee | 47167 | 809 | 8 |
353202 | 353202 | 2020-07-20 | Trousdale | Tennessee | 47169 | 1543 | 6 |
353203 | 353203 | 2020-07-20 | Unicoi | Tennessee | 47171 | 69 | 0 |
353204 | 353204 | 2020-07-20 | Union | Tennessee | 47173 | 50 | 0 |
353205 | 353205 | 2020-07-20 | Van Buren | Tennessee | 47175 | 14 | 0 |
353206 | 353206 | 2020-07-20 | Warren | Tennessee | 47177 | 222 | 3 |
353207 | 353207 | 2020-07-20 | Washington | Tennessee | 47179 | 470 | 0 |
353208 | 353208 | 2020-07-20 | Wayne | Tennessee | 47181 | 150 | 0 |
353209 | 353209 | 2020-07-20 | Weakley | Tennessee | 47183 | 101 | 1 |
353210 | 353210 | 2020-07-20 | White | Tennessee | 47185 | 124 | 3 |
353211 | 353211 | 2020-07-20 | Williamson | Tennessee | 47187 | 2562 | 18 |
353212 | 353212 | 2020-07-20 | Wilson | Tennessee | 47189 | 1628 | 19 |
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);