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-03-31 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1176151 | 1176151 | 2021-03-31 | Anderson | Tennessee | 47001 | 8454 | 165 |
1176152 | 1176152 | 2021-03-31 | Bedford | Tennessee | 47003 | 6226 | 125 |
1176153 | 1176153 | 2021-03-31 | Benton | Tennessee | 47005 | 1571 | 40 |
1176154 | 1176154 | 2021-03-31 | Bledsoe | Tennessee | 47007 | 2068 | 11 |
1176155 | 1176155 | 2021-03-31 | Blount | Tennessee | 47009 | 14698 | 194 |
1176156 | 1176156 | 2021-03-31 | Bradley | Tennessee | 47011 | 14035 | 145 |
1176157 | 1176157 | 2021-03-31 | Campbell | Tennessee | 47013 | 4008 | 61 |
1176158 | 1176158 | 2021-03-31 | Cannon | Tennessee | 47015 | 1847 | 31 |
1176159 | 1176159 | 2021-03-31 | Carroll | Tennessee | 47017 | 3541 | 82 |
1176160 | 1176160 | 2021-03-31 | Carter | Tennessee | 47019 | 6214 | 156 |
1176161 | 1176161 | 2021-03-31 | Cheatham | Tennessee | 47021 | 4261 | 50 |
1176162 | 1176162 | 2021-03-31 | Chester | Tennessee | 47023 | 2073 | 48 |
1176163 | 1176163 | 2021-03-31 | Claiborne | Tennessee | 47025 | 2977 | 74 |
1176164 | 1176164 | 2021-03-31 | Clay | Tennessee | 47027 | 1076 | 31 |
1176165 | 1176165 | 2021-03-31 | Cocke | Tennessee | 47029 | 4348 | 98 |
1176166 | 1176166 | 2021-03-31 | Coffee | Tennessee | 47031 | 6696 | 120 |
1176167 | 1176167 | 2021-03-31 | Crockett | Tennessee | 47033 | 1980 | 48 |
1176168 | 1176168 | 2021-03-31 | Cumberland | Tennessee | 47035 | 6340 | 125 |
1176169 | 1176169 | 2021-03-31 | Davidson | Tennessee | 47037 | 94369 | 896 |
1176170 | 1176170 | 2021-03-31 | DeKalb | Tennessee | 47041 | 2726 | 53 |
1176171 | 1176171 | 2021-03-31 | Decatur | Tennessee | 47039 | 1562 | 38 |
1176172 | 1176172 | 2021-03-31 | Dickson | Tennessee | 47043 | 6506 | 107 |
1176173 | 1176173 | 2021-03-31 | Dyer | Tennessee | 47045 | 5313 | 103 |
1176174 | 1176174 | 2021-03-31 | Fayette | Tennessee | 47047 | 4794 | 78 |
1176175 | 1176175 | 2021-03-31 | Fentress | Tennessee | 47049 | 2346 | 45 |
1176176 | 1176176 | 2021-03-31 | Franklin | Tennessee | 47051 | 4991 | 87 |
1176177 | 1176177 | 2021-03-31 | Gibson | Tennessee | 47053 | 6289 | 143 |
1176178 | 1176178 | 2021-03-31 | Giles | Tennessee | 47055 | 3858 | 98 |
1176179 | 1176179 | 2021-03-31 | Grainger | Tennessee | 47057 | 2519 | 49 |
1176180 | 1176180 | 2021-03-31 | Greene | Tennessee | 47059 | 7510 | 151 |
1176181 | 1176181 | 2021-03-31 | Grundy | Tennessee | 47061 | 1743 | 30 |
1176182 | 1176182 | 2021-03-31 | Hamblen | Tennessee | 47063 | 8355 | 170 |
1176183 | 1176183 | 2021-03-31 | Hamilton | Tennessee | 47065 | 42572 | 477 |
1176184 | 1176184 | 2021-03-31 | Hancock | Tennessee | 47067 | 523 | 12 |
1176185 | 1176185 | 2021-03-31 | Hardeman | Tennessee | 47069 | 3426 | 63 |
1176186 | 1176186 | 2021-03-31 | Hardin | Tennessee | 47071 | 3416 | 66 |
1176187 | 1176187 | 2021-03-31 | Hawkins | Tennessee | 47073 | 5556 | 104 |
1176188 | 1176188 | 2021-03-31 | Haywood | Tennessee | 47075 | 2670 | 60 |
1176189 | 1176189 | 2021-03-31 | Henderson | Tennessee | 47077 | 3658 | 74 |
1176190 | 1176190 | 2021-03-31 | Henry | Tennessee | 47079 | 3076 | 75 |
1176191 | 1176191 | 2021-03-31 | Hickman | Tennessee | 47081 | 2748 | 43 |
1176192 | 1176192 | 2021-03-31 | Houston | Tennessee | 47083 | 1061 | 33 |
1176193 | 1176193 | 2021-03-31 | Humphreys | Tennessee | 47085 | 1628 | 21 |
1176194 | 1176194 | 2021-03-31 | Jackson | Tennessee | 47087 | 1284 | 35 |
1176195 | 1176195 | 2021-03-31 | Jefferson | Tennessee | 47089 | 5937 | 121 |
1176196 | 1176196 | 2021-03-31 | Johnson | Tennessee | 47091 | 2223 | 38 |
1176197 | 1176197 | 2021-03-31 | Knox | Tennessee | 47093 | 49454 | 614 |
1176198 | 1176198 | 2021-03-31 | Lake | Tennessee | 47095 | 1688 | 26 |
1176199 | 1176199 | 2021-03-31 | Lauderdale | Tennessee | 47097 | 3114 | 44 |
1176200 | 1176200 | 2021-03-31 | Lawrence | Tennessee | 47099 | 5695 | 86 |
1176201 | 1176201 | 2021-03-31 | Lewis | Tennessee | 47101 | 1521 | 25 |
1176202 | 1176202 | 2021-03-31 | Lincoln | Tennessee | 47103 | 4243 | 63 |
1176203 | 1176203 | 2021-03-31 | Loudon | Tennessee | 47105 | 5897 | 68 |
1176204 | 1176204 | 2021-03-31 | Macon | Tennessee | 47111 | 3485 | 74 |
1176205 | 1176205 | 2021-03-31 | Madison | Tennessee | 47113 | 10482 | 238 |
1176206 | 1176206 | 2021-03-31 | Marion | Tennessee | 47115 | 3051 | 46 |
1176207 | 1176207 | 2021-03-31 | Marshall | Tennessee | 47117 | 4035 | 57 |
1176208 | 1176208 | 2021-03-31 | Maury | Tennessee | 47119 | 12705 | 162 |
1176209 | 1176209 | 2021-03-31 | McMinn | Tennessee | 47107 | 6186 | 95 |
1176210 | 1176210 | 2021-03-31 | McNairy | Tennessee | 47109 | 2740 | 54 |
1176211 | 1176211 | 2021-03-31 | Meigs | Tennessee | 47121 | 1311 | 23 |
1176212 | 1176212 | 2021-03-31 | Monroe | Tennessee | 47123 | 5559 | 95 |
1176213 | 1176213 | 2021-03-31 | Montgomery | Tennessee | 47125 | 18392 | 221 |
1176214 | 1176214 | 2021-03-31 | Moore | Tennessee | 47127 | 985 | 17 |
1176215 | 1176215 | 2021-03-31 | Morgan | Tennessee | 47129 | 2393 | 39 |
1176216 | 1176216 | 2021-03-31 | Obion | Tennessee | 47131 | 4438 | 96 |
1176217 | 1176217 | 2021-03-31 | Overton | Tennessee | 47133 | 2926 | 60 |
1176218 | 1176218 | 2021-03-31 | Perry | Tennessee | 47135 | 1054 | 28 |
1176219 | 1176219 | 2021-03-31 | Pickett | Tennessee | 47137 | 753 | 24 |
1176220 | 1176220 | 2021-03-31 | Polk | Tennessee | 47139 | 1922 | 24 |
1176221 | 1176221 | 2021-03-31 | Putnam | Tennessee | 47141 | 10977 | 173 |
1176222 | 1176222 | 2021-03-31 | Rhea | Tennessee | 47143 | 4252 | 75 |
1176223 | 1176223 | 2021-03-31 | Roane | Tennessee | 47145 | 6069 | 100 |
1176224 | 1176224 | 2021-03-31 | Robertson | Tennessee | 47147 | 9361 | 127 |
1176225 | 1176225 | 2021-03-31 | Rutherford | Tennessee | 47149 | 40844 | 409 |
1176226 | 1176226 | 2021-03-31 | Scott | Tennessee | 47151 | 2988 | 45 |
1176227 | 1176227 | 2021-03-31 | Sequatchie | Tennessee | 47153 | 1626 | 29 |
1176228 | 1176228 | 2021-03-31 | Sevier | Tennessee | 47155 | 12840 | 173 |
1176229 | 1176229 | 2021-03-31 | Shelby | Tennessee | 47157 | 91220 | 1569 |
1176230 | 1176230 | 2021-03-31 | Smith | Tennessee | 47159 | 2687 | 37 |
1176231 | 1176231 | 2021-03-31 | Stewart | Tennessee | 47161 | 1279 | 27 |
1176232 | 1176232 | 2021-03-31 | Sullivan | Tennessee | 47163 | 15417 | 281 |
1176233 | 1176233 | 2021-03-31 | Sumner | Tennessee | 47165 | 22555 | 337 |
1176234 | 1176234 | 2021-03-31 | Tipton | Tennessee | 47167 | 7120 | 104 |
1176235 | 1176235 | 2021-03-31 | Trousdale | Tennessee | 47169 | 2458 | 22 |
1176236 | 1176236 | 2021-03-31 | Unicoi | Tennessee | 47171 | 1874 | 49 |
1176237 | 1176237 | 2021-03-31 | Union | Tennessee | 47173 | 1823 | 34 |
1176238 | 1176238 | 2021-03-31 | Unknown | Tennessee | 8839 | 121 | |
1176239 | 1176239 | 2021-03-31 | Van Buren | Tennessee | 47175 | 814 | 21 |
1176240 | 1176240 | 2021-03-31 | Warren | Tennessee | 47177 | 5433 | 80 |
1176241 | 1176241 | 2021-03-31 | Washington | Tennessee | 47179 | 13482 | 239 |
1176242 | 1176242 | 2021-03-31 | Wayne | Tennessee | 47181 | 2935 | 33 |
1176243 | 1176243 | 2021-03-31 | Weakley | Tennessee | 47183 | 3921 | 60 |
1176244 | 1176244 | 2021-03-31 | White | Tennessee | 47185 | 3484 | 68 |
1176245 | 1176245 | 2021-03-31 | Williamson | Tennessee | 47187 | 26612 | 213 |
1176246 | 1176246 | 2021-03-31 | Wilson | Tennessee | 47189 | 17520 | 219 |
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);