ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-12-07" 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 |
---|---|---|---|---|---|---|---|
806128 | 806128 | 2020-12-07 | Anderson | Tennessee | 47001 | 3499 | 34 |
806129 | 806129 | 2020-12-07 | Bedford | Tennessee | 47003 | 3171 | 41 |
806130 | 806130 | 2020-12-07 | Benton | Tennessee | 47005 | 920 | 16 |
806131 | 806131 | 2020-12-07 | Bledsoe | Tennessee | 47007 | 1255 | 5 |
806132 | 806132 | 2020-12-07 | Blount | Tennessee | 47009 | 6559 | 66 |
806133 | 806133 | 2020-12-07 | Bradley | Tennessee | 47011 | 5999 | 39 |
806134 | 806134 | 2020-12-07 | Campbell | Tennessee | 47013 | 1781 | 26 |
806135 | 806135 | 2020-12-07 | Cannon | Tennessee | 47015 | 866 | 4 |
806136 | 806136 | 2020-12-07 | Carroll | Tennessee | 47017 | 1968 | 36 |
806137 | 806137 | 2020-12-07 | Carter | Tennessee | 47019 | 3147 | 65 |
806138 | 806138 | 2020-12-07 | Cheatham | Tennessee | 47021 | 1802 | 17 |
806139 | 806139 | 2020-12-07 | Chester | Tennessee | 47023 | 1104 | 24 |
806140 | 806140 | 2020-12-07 | Claiborne | Tennessee | 47025 | 1053 | 10 |
806141 | 806141 | 2020-12-07 | Clay | Tennessee | 47027 | 605 | 19 |
806142 | 806142 | 2020-12-07 | Cocke | Tennessee | 47029 | 1815 | 30 |
806143 | 806143 | 2020-12-07 | Coffee | Tennessee | 47031 | 3229 | 44 |
806144 | 806144 | 2020-12-07 | Crockett | Tennessee | 47033 | 1221 | 29 |
806145 | 806145 | 2020-12-07 | Cumberland | Tennessee | 47035 | 2897 | 41 |
806146 | 806146 | 2020-12-07 | Davidson | Tennessee | 47037 | 50275 | 440 |
806147 | 806147 | 2020-12-07 | DeKalb | Tennessee | 47041 | 1356 | 25 |
806148 | 806148 | 2020-12-07 | Decatur | Tennessee | 47039 | 998 | 13 |
806149 | 806149 | 2020-12-07 | Dickson | Tennessee | 47043 | 3174 | 40 |
806150 | 806150 | 2020-12-07 | Dyer | Tennessee | 47045 | 3431 | 53 |
806151 | 806151 | 2020-12-07 | Fayette | Tennessee | 47047 | 2461 | 40 |
806152 | 806152 | 2020-12-07 | Fentress | Tennessee | 47049 | 1336 | 25 |
806153 | 806153 | 2020-12-07 | Franklin | Tennessee | 47051 | 2412 | 40 |
806154 | 806154 | 2020-12-07 | Gibson | Tennessee | 47053 | 3601 | 72 |
806155 | 806155 | 2020-12-07 | Giles | Tennessee | 47055 | 1626 | 50 |
806156 | 806156 | 2020-12-07 | Grainger | Tennessee | 47057 | 1161 | 21 |
806157 | 806157 | 2020-12-07 | Greene | Tennessee | 47059 | 3574 | 76 |
806158 | 806158 | 2020-12-07 | Grundy | Tennessee | 47061 | 854 | 14 |
806159 | 806159 | 2020-12-07 | Hamblen | Tennessee | 47063 | 3961 | 63 |
806160 | 806160 | 2020-12-07 | Hamilton | Tennessee | 47065 | 20602 | 182 |
806161 | 806161 | 2020-12-07 | Hancock | Tennessee | 47067 | 218 | 4 |
806162 | 806162 | 2020-12-07 | Hardeman | Tennessee | 47069 | 2350 | 39 |
806163 | 806163 | 2020-12-07 | Hardin | Tennessee | 47071 | 1945 | 30 |
806164 | 806164 | 2020-12-07 | Hawkins | Tennessee | 47073 | 2283 | 36 |
806165 | 806165 | 2020-12-07 | Haywood | Tennessee | 47075 | 1737 | 30 |
806166 | 806166 | 2020-12-07 | Henderson | Tennessee | 47077 | 2068 | 34 |
806167 | 806167 | 2020-12-07 | Henry | Tennessee | 47079 | 1715 | 23 |
806168 | 806168 | 2020-12-07 | Hickman | Tennessee | 47081 | 1315 | 19 |
806169 | 806169 | 2020-12-07 | Houston | Tennessee | 47083 | 616 | 21 |
806170 | 806170 | 2020-12-07 | Humphreys | Tennessee | 47085 | 833 | 9 |
806171 | 806171 | 2020-12-07 | Jackson | Tennessee | 47087 | 755 | 11 |
806172 | 806172 | 2020-12-07 | Jefferson | Tennessee | 47089 | 2618 | 36 |
806173 | 806173 | 2020-12-07 | Johnson | Tennessee | 47091 | 1525 | 24 |
806174 | 806174 | 2020-12-07 | Knox | Tennessee | 47093 | 21917 | 189 |
806175 | 806175 | 2020-12-07 | Lake | Tennessee | 47095 | 1235 | 8 |
806176 | 806176 | 2020-12-07 | Lauderdale | Tennessee | 47097 | 2174 | 23 |
806177 | 806177 | 2020-12-07 | Lawrence | Tennessee | 47099 | 3055 | 38 |
806178 | 806178 | 2020-12-07 | Lewis | Tennessee | 47101 | 854 | 16 |
806179 | 806179 | 2020-12-07 | Lincoln | Tennessee | 47103 | 1939 | 24 |
806180 | 806180 | 2020-12-07 | Loudon | Tennessee | 47105 | 2584 | 21 |
806181 | 806181 | 2020-12-07 | Macon | Tennessee | 47111 | 1974 | 31 |
806182 | 806182 | 2020-12-07 | Madison | Tennessee | 47113 | 5894 | 120 |
806183 | 806183 | 2020-12-07 | Marion | Tennessee | 47115 | 1262 | 21 |
806184 | 806184 | 2020-12-07 | Marshall | Tennessee | 47117 | 1946 | 22 |
806185 | 806185 | 2020-12-07 | Maury | Tennessee | 47119 | 6627 | 77 |
806186 | 806186 | 2020-12-07 | McMinn | Tennessee | 47107 | 2972 | 57 |
806187 | 806187 | 2020-12-07 | McNairy | Tennessee | 47109 | 1485 | 33 |
806188 | 806188 | 2020-12-07 | Meigs | Tennessee | 47121 | 565 | 13 |
806189 | 806189 | 2020-12-07 | Monroe | Tennessee | 47123 | 2484 | 46 |
806190 | 806190 | 2020-12-07 | Montgomery | Tennessee | 47125 | 7524 | 95 |
806191 | 806191 | 2020-12-07 | Moore | Tennessee | 47127 | 438 | 4 |
806192 | 806192 | 2020-12-07 | Morgan | Tennessee | 47129 | 859 | 7 |
806193 | 806193 | 2020-12-07 | Obion | Tennessee | 47131 | 2899 | 56 |
806194 | 806194 | 2020-12-07 | Overton | Tennessee | 47133 | 1620 | 37 |
806195 | 806195 | 2020-12-07 | Perry | Tennessee | 47135 | 541 | 22 |
806196 | 806196 | 2020-12-07 | Pickett | Tennessee | 47137 | 420 | 15 |
806197 | 806197 | 2020-12-07 | Polk | Tennessee | 47139 | 744 | 15 |
806198 | 806198 | 2020-12-07 | Putnam | Tennessee | 47141 | 6389 | 85 |
806199 | 806199 | 2020-12-07 | Rhea | Tennessee | 47143 | 1966 | 35 |
806200 | 806200 | 2020-12-07 | Roane | Tennessee | 47145 | 2758 | 35 |
806201 | 806201 | 2020-12-07 | Robertson | Tennessee | 47147 | 4258 | 57 |
806202 | 806202 | 2020-12-07 | Rutherford | Tennessee | 47149 | 20061 | 177 |
806203 | 806203 | 2020-12-07 | Scott | Tennessee | 47151 | 1271 | 9 |
806204 | 806204 | 2020-12-07 | Sequatchie | Tennessee | 47153 | 630 | 5 |
806205 | 806205 | 2020-12-07 | Sevier | Tennessee | 47155 | 5579 | 40 |
806206 | 806206 | 2020-12-07 | Shelby | Tennessee | 47157 | 51775 | 709 |
806207 | 806207 | 2020-12-07 | Smith | Tennessee | 47159 | 1555 | 20 |
806208 | 806208 | 2020-12-07 | Stewart | Tennessee | 47161 | 651 | 18 |
806209 | 806209 | 2020-12-07 | Sullivan | Tennessee | 47163 | 7459 | 120 |
806210 | 806210 | 2020-12-07 | Sumner | Tennessee | 47165 | 11148 | 145 |
806211 | 806211 | 2020-12-07 | Tipton | Tennessee | 47167 | 4007 | 41 |
806212 | 806212 | 2020-12-07 | Trousdale | Tennessee | 47169 | 1940 | 12 |
806213 | 806213 | 2020-12-07 | Unicoi | Tennessee | 47171 | 1015 | 28 |
806214 | 806214 | 2020-12-07 | Union | Tennessee | 47173 | 804 | 5 |
806215 | 806215 | 2020-12-07 | Unknown | Tennessee | 669 | 15 | |
806216 | 806216 | 2020-12-07 | Van Buren | Tennessee | 47175 | 407 | 3 |
806217 | 806217 | 2020-12-07 | Warren | Tennessee | 47177 | 2702 | 20 |
806218 | 806218 | 2020-12-07 | Washington | Tennessee | 47179 | 7012 | 120 |
806219 | 806219 | 2020-12-07 | Wayne | Tennessee | 47181 | 2024 | 12 |
806220 | 806220 | 2020-12-07 | Weakley | Tennessee | 47183 | 2343 | 37 |
806221 | 806221 | 2020-12-07 | White | Tennessee | 47185 | 2008 | 20 |
806222 | 806222 | 2020-12-07 | Williamson | Tennessee | 47187 | 12638 | 88 |
806223 | 806223 | 2020-12-07 | Wilson | Tennessee | 47189 | 8551 | 91 |
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);