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 2022-02-11 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2206004 | 2206004 | 2022-02-11 | Anderson | Tennessee | 47001 | 20906 | 297 |
2206005 | 2206005 | 2022-02-11 | Bedford | Tennessee | 47003 | 14500 | 212 |
2206006 | 2206006 | 2022-02-11 | Benton | Tennessee | 47005 | 4243 | 84 |
2206007 | 2206007 | 2022-02-11 | Bledsoe | Tennessee | 47007 | 4500 | 43 |
2206008 | 2206008 | 2022-02-11 | Blount | Tennessee | 47009 | 37570 | 367 |
2206009 | 2206009 | 2022-02-11 | Bradley | Tennessee | 47011 | 32167 | 363 |
2206010 | 2206010 | 2022-02-11 | Campbell | Tennessee | 47013 | 11189 | 139 |
2206011 | 2206011 | 2022-02-11 | Cannon | Tennessee | 47015 | 4027 | 52 |
2206012 | 2206012 | 2022-02-11 | Carroll | Tennessee | 47017 | 8576 | 137 |
2206013 | 2206013 | 2022-02-11 | Carter | Tennessee | 47019 | 15272 | 295 |
2206014 | 2206014 | 2022-02-11 | Cheatham | Tennessee | 47021 | 10541 | 107 |
2206015 | 2206015 | 2022-02-11 | Chester | Tennessee | 47023 | 5499 | 88 |
2206016 | 2206016 | 2022-02-11 | Claiborne | Tennessee | 47025 | 8336 | 150 |
2206017 | 2206017 | 2022-02-11 | Clay | Tennessee | 47027 | 2149 | 45 |
2206018 | 2206018 | 2022-02-11 | Cocke | Tennessee | 47029 | 10657 | 191 |
2206019 | 2206019 | 2022-02-11 | Coffee | Tennessee | 47031 | 16281 | 233 |
2206020 | 2206020 | 2022-02-11 | Crockett | Tennessee | 47033 | 4853 | 76 |
2206021 | 2206021 | 2022-02-11 | Cumberland | Tennessee | 47035 | 15402 | 294 |
2206022 | 2206022 | 2022-02-11 | Davidson | Tennessee | 47037 | 202675 | 1516 |
2206023 | 2206023 | 2022-02-11 | DeKalb | Tennessee | 47041 | 6087 | 93 |
2206024 | 2206024 | 2022-02-11 | Decatur | Tennessee | 47039 | 3524 | 55 |
2206025 | 2206025 | 2022-02-11 | Dickson | Tennessee | 47043 | 15230 | 225 |
2206026 | 2206026 | 2022-02-11 | Dyer | Tennessee | 47045 | 12142 | 179 |
2206027 | 2206027 | 2022-02-11 | Fayette | Tennessee | 47047 | 11120 | 151 |
2206028 | 2206028 | 2022-02-11 | Fentress | Tennessee | 47049 | 5402 | 109 |
2206029 | 2206029 | 2022-02-11 | Franklin | Tennessee | 47051 | 12324 | 155 |
2206030 | 2206030 | 2022-02-11 | Gibson | Tennessee | 47053 | 16648 | 232 |
2206031 | 2206031 | 2022-02-11 | Giles | Tennessee | 47055 | 9117 | 161 |
2206032 | 2206032 | 2022-02-11 | Grainger | Tennessee | 47057 | 6447 | 98 |
2206033 | 2206033 | 2022-02-11 | Greene | Tennessee | 47059 | 20926 | 327 |
2206034 | 2206034 | 2022-02-11 | Grundy | Tennessee | 47061 | 3840 | 67 |
2206035 | 2206035 | 2022-02-11 | Hamblen | Tennessee | 47063 | 19021 | 321 |
2206036 | 2206036 | 2022-02-11 | Hamilton | Tennessee | 47065 | 95951 | 1024 |
2206037 | 2206037 | 2022-02-11 | Hancock | Tennessee | 47067 | 1872 | 29 |
2206038 | 2206038 | 2022-02-11 | Hardeman | Tennessee | 47069 | 7143 | 109 |
2206039 | 2206039 | 2022-02-11 | Hardin | Tennessee | 47071 | 8225 | 121 |
2206040 | 2206040 | 2022-02-11 | Hawkins | Tennessee | 47073 | 15580 | 266 |
2206041 | 2206041 | 2022-02-11 | Haywood | Tennessee | 47075 | 5973 | 88 |
2206042 | 2206042 | 2022-02-11 | Henderson | Tennessee | 47077 | 8505 | 129 |
2206043 | 2206043 | 2022-02-11 | Henry | Tennessee | 47079 | 7747 | 137 |
2206044 | 2206044 | 2022-02-11 | Hickman | Tennessee | 47081 | 6580 | 100 |
2206045 | 2206045 | 2022-02-11 | Houston | Tennessee | 47083 | 2528 | 56 |
2206046 | 2206046 | 2022-02-11 | Humphreys | Tennessee | 47085 | 4600 | 63 |
2206047 | 2206047 | 2022-02-11 | Jackson | Tennessee | 47087 | 3046 | 52 |
2206048 | 2206048 | 2022-02-11 | Jefferson | Tennessee | 47089 | 14975 | 238 |
2206049 | 2206049 | 2022-02-11 | Johnson | Tennessee | 47091 | 4878 | 75 |
2206050 | 2206050 | 2022-02-11 | Knox | Tennessee | 47093 | 121675 | 1194 |
2206051 | 2206051 | 2022-02-11 | Lake | Tennessee | 47095 | 2612 | 36 |
2206052 | 2206052 | 2022-02-11 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2206053 | 2206053 | 2022-02-11 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2206054 | 2206054 | 2022-02-11 | Lewis | Tennessee | 47101 | 3446 | 50 |
2206055 | 2206055 | 2022-02-11 | Lincoln | Tennessee | 47103 | 9661 | 139 |
2206056 | 2206056 | 2022-02-11 | Loudon | Tennessee | 47105 | 13836 | 170 |
2206057 | 2206057 | 2022-02-11 | Macon | Tennessee | 47111 | 8103 | 133 |
2206058 | 2206058 | 2022-02-11 | Madison | Tennessee | 47113 | 28278 | 387 |
2206059 | 2206059 | 2022-02-11 | Marion | Tennessee | 47115 | 8455 | 118 |
2206060 | 2206060 | 2022-02-11 | Marshall | Tennessee | 47117 | 10076 | 110 |
2206061 | 2206061 | 2022-02-11 | Maury | Tennessee | 47119 | 27986 | 295 |
2206062 | 2206062 | 2022-02-11 | McMinn | Tennessee | 47107 | 16114 | 218 |
2206063 | 2206063 | 2022-02-11 | McNairy | Tennessee | 47109 | 7060 | 96 |
2206064 | 2206064 | 2022-02-11 | Meigs | Tennessee | 47121 | 3244 | 52 |
2206065 | 2206065 | 2022-02-11 | Monroe | Tennessee | 47123 | 13949 | 206 |
2206066 | 2206066 | 2022-02-11 | Montgomery | Tennessee | 47125 | 47873 | 514 |
2206067 | 2206067 | 2022-02-11 | Moore | Tennessee | 47127 | 2157 | 36 |
2206068 | 2206068 | 2022-02-11 | Morgan | Tennessee | 47129 | 5735 | 72 |
2206069 | 2206069 | 2022-02-11 | Obion | Tennessee | 47131 | 10418 | 161 |
2206070 | 2206070 | 2022-02-11 | Overton | Tennessee | 47133 | 6893 | 118 |
2206071 | 2206071 | 2022-02-11 | Perry | Tennessee | 47135 | 2226 | 43 |
2206072 | 2206072 | 2022-02-11 | Pickett | Tennessee | 47137 | 1699 | 30 |
2206073 | 2206073 | 2022-02-11 | Polk | Tennessee | 47139 | 4481 | 53 |
2206074 | 2206074 | 2022-02-11 | Putnam | Tennessee | 47141 | 24020 | 275 |
2206075 | 2206075 | 2022-02-11 | Rhea | Tennessee | 47143 | 9654 | 139 |
2206076 | 2206076 | 2022-02-11 | Roane | Tennessee | 47145 | 15095 | 208 |
2206077 | 2206077 | 2022-02-11 | Robertson | Tennessee | 47147 | 20960 | 265 |
2206078 | 2206078 | 2022-02-11 | Rutherford | Tennessee | 47149 | 92717 | 818 |
2206079 | 2206079 | 2022-02-11 | Scott | Tennessee | 47151 | 8372 | 101 |
2206080 | 2206080 | 2022-02-11 | Sequatchie | Tennessee | 47153 | 4046 | 63 |
2206081 | 2206081 | 2022-02-11 | Sevier | Tennessee | 47155 | 29074 | 371 |
2206082 | 2206082 | 2022-02-11 | Shelby | Tennessee | 47157 | 233033 | 2992 |
2206083 | 2206083 | 2022-02-11 | Smith | Tennessee | 47159 | 5886 | 72 |
2206084 | 2206084 | 2022-02-11 | Stewart | Tennessee | 47161 | 3124 | 47 |
2206085 | 2206085 | 2022-02-11 | Sullivan | Tennessee | 47163 | 42750 | 609 |
2206086 | 2206086 | 2022-02-11 | Sumner | Tennessee | 47165 | 51397 | 652 |
2206087 | 2206087 | 2022-02-11 | Tipton | Tennessee | 47167 | 17164 | 195 |
2206088 | 2206088 | 2022-02-11 | Trousdale | Tennessee | 47169 | 4091 | 43 |
2206089 | 2206089 | 2022-02-11 | Unicoi | Tennessee | 47171 | 4743 | 87 |
2206090 | 2206090 | 2022-02-11 | Union | Tennessee | 47173 | 5083 | 69 |
2206091 | 2206091 | 2022-02-11 | Unknown | Tennessee | 33332 | 415 | |
2206092 | 2206092 | 2022-02-11 | Van Buren | Tennessee | 47175 | 1771 | 45 |
2206093 | 2206093 | 2022-02-11 | Warren | Tennessee | 47177 | 12513 | 159 |
2206094 | 2206094 | 2022-02-11 | Washington | Tennessee | 47179 | 34879 | 439 |
2206095 | 2206095 | 2022-02-11 | Wayne | Tennessee | 47181 | 5491 | 53 |
2206096 | 2206096 | 2022-02-11 | Weakley | Tennessee | 47183 | 9209 | 120 |
2206097 | 2206097 | 2022-02-11 | White | Tennessee | 47185 | 7927 | 121 |
2206098 | 2206098 | 2022-02-11 | Williamson | Tennessee | 47187 | 59879 | 368 |
2206099 | 2206099 | 2022-02-11 | Wilson | Tennessee | 47189 | 40306 | 449 |
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);