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-01-29 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
978132 | 978132 | 2021-01-29 | Anderson | Tennessee | 47001 | 7181 | 125 |
978133 | 978133 | 2021-01-29 | Bedford | Tennessee | 47003 | 5514 | 98 |
978134 | 978134 | 2021-01-29 | Benton | Tennessee | 47005 | 1358 | 35 |
978135 | 978135 | 2021-01-29 | Bledsoe | Tennessee | 47007 | 1813 | 11 |
978136 | 978136 | 2021-01-29 | Blount | Tennessee | 47009 | 12596 | 141 |
978137 | 978137 | 2021-01-29 | Bradley | Tennessee | 47011 | 11497 | 107 |
978138 | 978138 | 2021-01-29 | Campbell | Tennessee | 47013 | 3445 | 44 |
978139 | 978139 | 2021-01-29 | Cannon | Tennessee | 47015 | 1644 | 23 |
978140 | 978140 | 2021-01-29 | Carroll | Tennessee | 47017 | 3259 | 64 |
978141 | 978141 | 2021-01-29 | Carter | Tennessee | 47019 | 5293 | 127 |
978142 | 978142 | 2021-01-29 | Cheatham | Tennessee | 47021 | 3582 | 33 |
978143 | 978143 | 2021-01-29 | Chester | Tennessee | 47023 | 1831 | 39 |
978144 | 978144 | 2021-01-29 | Claiborne | Tennessee | 47025 | 2372 | 38 |
978145 | 978145 | 2021-01-29 | Clay | Tennessee | 47027 | 978 | 26 |
978146 | 978146 | 2021-01-29 | Cocke | Tennessee | 47029 | 3660 | 70 |
978147 | 978147 | 2021-01-29 | Coffee | Tennessee | 47031 | 5871 | 98 |
978148 | 978148 | 2021-01-29 | Crockett | Tennessee | 47033 | 1857 | 39 |
978149 | 978149 | 2021-01-29 | Cumberland | Tennessee | 47035 | 5639 | 80 |
978150 | 978150 | 2021-01-29 | Davidson | Tennessee | 47037 | 83943 | 726 |
978151 | 978151 | 2021-01-29 | DeKalb | Tennessee | 47041 | 2515 | 45 |
978152 | 978152 | 2021-01-29 | Decatur | Tennessee | 47039 | 1505 | 28 |
978153 | 978153 | 2021-01-29 | Dickson | Tennessee | 47043 | 5724 | 85 |
978154 | 978154 | 2021-01-29 | Dyer | Tennessee | 47045 | 4942 | 87 |
978155 | 978155 | 2021-01-29 | Fayette | Tennessee | 47047 | 4222 | 55 |
978156 | 978156 | 2021-01-29 | Fentress | Tennessee | 47049 | 2198 | 38 |
978157 | 978157 | 2021-01-29 | Franklin | Tennessee | 47051 | 4340 | 69 |
978158 | 978158 | 2021-01-29 | Gibson | Tennessee | 47053 | 5855 | 122 |
978159 | 978159 | 2021-01-29 | Giles | Tennessee | 47055 | 3402 | 76 |
978160 | 978160 | 2021-01-29 | Grainger | Tennessee | 47057 | 2212 | 41 |
978161 | 978161 | 2021-01-29 | Greene | Tennessee | 47059 | 6848 | 121 |
978162 | 978162 | 2021-01-29 | Grundy | Tennessee | 47061 | 1467 | 24 |
978163 | 978163 | 2021-01-29 | Hamblen | Tennessee | 47063 | 7384 | 142 |
978164 | 978164 | 2021-01-29 | Hamilton | Tennessee | 47065 | 37816 | 358 |
978165 | 978165 | 2021-01-29 | Hancock | Tennessee | 47067 | 435 | 7 |
978166 | 978166 | 2021-01-29 | Hardeman | Tennessee | 47069 | 3199 | 57 |
978167 | 978167 | 2021-01-29 | Hardin | Tennessee | 47071 | 3100 | 54 |
978168 | 978168 | 2021-01-29 | Hawkins | Tennessee | 47073 | 4731 | 82 |
978169 | 978169 | 2021-01-29 | Haywood | Tennessee | 47075 | 2502 | 55 |
978170 | 978170 | 2021-01-29 | Henderson | Tennessee | 47077 | 3426 | 63 |
978171 | 978171 | 2021-01-29 | Henry | Tennessee | 47079 | 2737 | 63 |
978172 | 978172 | 2021-01-29 | Hickman | Tennessee | 47081 | 2333 | 38 |
978173 | 978173 | 2021-01-29 | Houston | Tennessee | 47083 | 957 | 26 |
978174 | 978174 | 2021-01-29 | Humphreys | Tennessee | 47085 | 1405 | 18 |
978175 | 978175 | 2021-01-29 | Jackson | Tennessee | 47087 | 1081 | 24 |
978176 | 978176 | 2021-01-29 | Jefferson | Tennessee | 47089 | 5081 | 83 |
978177 | 978177 | 2021-01-29 | Johnson | Tennessee | 47091 | 2087 | 36 |
978178 | 978178 | 2021-01-29 | Knox | Tennessee | 47093 | 42470 | 480 |
978179 | 978179 | 2021-01-29 | Lake | Tennessee | 47095 | 1603 | 22 |
978180 | 978180 | 2021-01-29 | Lauderdale | Tennessee | 47097 | 3023 | 35 |
978181 | 978181 | 2021-01-29 | Lawrence | Tennessee | 47099 | 5326 | 73 |
978182 | 978182 | 2021-01-29 | Lewis | Tennessee | 47101 | 1339 | 21 |
978183 | 978183 | 2021-01-29 | Lincoln | Tennessee | 47103 | 3940 | 53 |
978184 | 978184 | 2021-01-29 | Loudon | Tennessee | 47105 | 5225 | 57 |
978185 | 978185 | 2021-01-29 | Macon | Tennessee | 47111 | 2986 | 56 |
978186 | 978186 | 2021-01-29 | Madison | Tennessee | 47113 | 9526 | 193 |
978187 | 978187 | 2021-01-29 | Marion | Tennessee | 47115 | 2394 | 34 |
978188 | 978188 | 2021-01-29 | Marshall | Tennessee | 47117 | 3641 | 42 |
978189 | 978189 | 2021-01-29 | Maury | Tennessee | 47119 | 11531 | 140 |
978190 | 978190 | 2021-01-29 | McMinn | Tennessee | 47107 | 5349 | 77 |
978191 | 978191 | 2021-01-29 | McNairy | Tennessee | 47109 | 2535 | 44 |
978192 | 978192 | 2021-01-29 | Meigs | Tennessee | 47121 | 1215 | 17 |
978193 | 978193 | 2021-01-29 | Monroe | Tennessee | 47123 | 4830 | 67 |
978194 | 978194 | 2021-01-29 | Montgomery | Tennessee | 47125 | 15591 | 162 |
978195 | 978195 | 2021-01-29 | Moore | Tennessee | 47127 | 848 | 10 |
978196 | 978196 | 2021-01-29 | Morgan | Tennessee | 47129 | 2006 | 17 |
978197 | 978197 | 2021-01-29 | Obion | Tennessee | 47131 | 4120 | 86 |
978198 | 978198 | 2021-01-29 | Overton | Tennessee | 47133 | 2635 | 46 |
978199 | 978199 | 2021-01-29 | Perry | Tennessee | 47135 | 974 | 25 |
978200 | 978200 | 2021-01-29 | Pickett | Tennessee | 47137 | 702 | 21 |
978201 | 978201 | 2021-01-29 | Polk | Tennessee | 47139 | 1543 | 18 |
978202 | 978202 | 2021-01-29 | Putnam | Tennessee | 47141 | 10337 | 155 |
978203 | 978203 | 2021-01-29 | Rhea | Tennessee | 47143 | 3975 | 62 |
978204 | 978204 | 2021-01-29 | Roane | Tennessee | 47145 | 5425 | 91 |
978205 | 978205 | 2021-01-29 | Robertson | Tennessee | 47147 | 8066 | 91 |
978206 | 978206 | 2021-01-29 | Rutherford | Tennessee | 47149 | 34818 | 312 |
978207 | 978207 | 2021-01-29 | Scott | Tennessee | 47151 | 2343 | 34 |
978208 | 978208 | 2021-01-29 | Sequatchie | Tennessee | 47153 | 1451 | 20 |
978209 | 978209 | 2021-01-29 | Sevier | Tennessee | 47155 | 11019 | 133 |
978210 | 978210 | 2021-01-29 | Shelby | Tennessee | 47157 | 82428 | 1254 |
978211 | 978211 | 2021-01-29 | Smith | Tennessee | 47159 | 2380 | 30 |
978212 | 978212 | 2021-01-29 | Stewart | Tennessee | 47161 | 1144 | 22 |
978213 | 978213 | 2021-01-29 | Sullivan | Tennessee | 47163 | 13203 | 231 |
978214 | 978214 | 2021-01-29 | Sumner | Tennessee | 47165 | 19144 | 251 |
978215 | 978215 | 2021-01-29 | Tipton | Tennessee | 47167 | 6506 | 79 |
978216 | 978216 | 2021-01-29 | Trousdale | Tennessee | 47169 | 2316 | 17 |
978217 | 978217 | 2021-01-29 | Unicoi | Tennessee | 47171 | 1716 | 47 |
978218 | 978218 | 2021-01-29 | Union | Tennessee | 47173 | 1487 | 25 |
978219 | 978219 | 2021-01-29 | Unknown | Tennessee | 13195 | 142 | |
978220 | 978220 | 2021-01-29 | Van Buren | Tennessee | 47175 | 680 | 9 |
978221 | 978221 | 2021-01-29 | Warren | Tennessee | 47177 | 5169 | 61 |
978222 | 978222 | 2021-01-29 | Washington | Tennessee | 47179 | 12366 | 213 |
978223 | 978223 | 2021-01-29 | Wayne | Tennessee | 47181 | 2742 | 26 |
978224 | 978224 | 2021-01-29 | Weakley | Tennessee | 47183 | 3512 | 52 |
978225 | 978225 | 2021-01-29 | White | Tennessee | 47185 | 3211 | 51 |
978226 | 978226 | 2021-01-29 | Williamson | Tennessee | 47187 | 22776 | 171 |
978227 | 978227 | 2021-01-29 | Wilson | Tennessee | 47189 | 15123 | 178 |
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);