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-03-27 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2349096 | 2349096 | 2022-03-27 | Anderson | Tennessee | 47001 | 22047 | 321 |
2349097 | 2349097 | 2022-03-27 | Bedford | Tennessee | 47003 | 14933 | 230 |
2349098 | 2349098 | 2022-03-27 | Benton | Tennessee | 47005 | 4471 | 90 |
2349099 | 2349099 | 2022-03-27 | Bledsoe | Tennessee | 47007 | 4652 | 56 |
2349100 | 2349100 | 2022-03-27 | Blount | Tennessee | 47009 | 39027 | 418 |
2349101 | 2349101 | 2022-03-27 | Bradley | Tennessee | 47011 | 33065 | 402 |
2349102 | 2349102 | 2022-03-27 | Campbell | Tennessee | 47013 | 12204 | 160 |
2349103 | 2349103 | 2022-03-27 | Cannon | Tennessee | 47015 | 4187 | 58 |
2349104 | 2349104 | 2022-03-27 | Carroll | Tennessee | 47017 | 8940 | 155 |
2349105 | 2349105 | 2022-03-27 | Carter | Tennessee | 47019 | 16432 | 328 |
2349106 | 2349106 | 2022-03-27 | Cheatham | Tennessee | 47021 | 10896 | 119 |
2349107 | 2349107 | 2022-03-27 | Chester | Tennessee | 47023 | 5823 | 96 |
2349108 | 2349108 | 2022-03-27 | Claiborne | Tennessee | 47025 | 9084 | 176 |
2349109 | 2349109 | 2022-03-27 | Clay | Tennessee | 47027 | 2224 | 49 |
2349110 | 2349110 | 2022-03-27 | Cocke | Tennessee | 47029 | 11553 | 209 |
2349111 | 2349111 | 2022-03-27 | Coffee | Tennessee | 47031 | 16925 | 261 |
2349112 | 2349112 | 2022-03-27 | Crockett | Tennessee | 47033 | 5171 | 84 |
2349113 | 2349113 | 2022-03-27 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2349114 | 2349114 | 2022-03-27 | Davidson | Tennessee | 47037 | 206889 | 1631 |
2349115 | 2349115 | 2022-03-27 | DeKalb | Tennessee | 47041 | 6276 | 100 |
2349116 | 2349116 | 2022-03-27 | Decatur | Tennessee | 47039 | 3726 | 67 |
2349117 | 2349117 | 2022-03-27 | Dickson | Tennessee | 47043 | 15853 | 240 |
2349118 | 2349118 | 2022-03-27 | Dyer | Tennessee | 47045 | 12764 | 199 |
2349119 | 2349119 | 2022-03-27 | Fayette | Tennessee | 47047 | 11395 | 180 |
2349120 | 2349120 | 2022-03-27 | Fentress | Tennessee | 47049 | 5691 | 125 |
2349121 | 2349121 | 2022-03-27 | Franklin | Tennessee | 47051 | 12829 | 176 |
2349122 | 2349122 | 2022-03-27 | Gibson | Tennessee | 47053 | 17366 | 254 |
2349123 | 2349123 | 2022-03-27 | Giles | Tennessee | 47055 | 9397 | 186 |
2349124 | 2349124 | 2022-03-27 | Grainger | Tennessee | 47057 | 6765 | 107 |
2349125 | 2349125 | 2022-03-27 | Greene | Tennessee | 47059 | 22029 | 363 |
2349126 | 2349126 | 2022-03-27 | Grundy | Tennessee | 47061 | 3980 | 71 |
2349127 | 2349127 | 2022-03-27 | Hamblen | Tennessee | 47063 | 19679 | 347 |
2349128 | 2349128 | 2022-03-27 | Hamilton | Tennessee | 47065 | 99558 | 1116 |
2349129 | 2349129 | 2022-03-27 | Hancock | Tennessee | 47067 | 2002 | 34 |
2349130 | 2349130 | 2022-03-27 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2349131 | 2349131 | 2022-03-27 | Hardin | Tennessee | 47071 | 8732 | 141 |
2349132 | 2349132 | 2022-03-27 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2349133 | 2349133 | 2022-03-27 | Haywood | Tennessee | 47075 | 6150 | 99 |
2349134 | 2349134 | 2022-03-27 | Henderson | Tennessee | 47077 | 9094 | 154 |
2349135 | 2349135 | 2022-03-27 | Henry | Tennessee | 47079 | 8244 | 154 |
2349136 | 2349136 | 2022-03-27 | Hickman | Tennessee | 47081 | 6815 | 108 |
2349137 | 2349137 | 2022-03-27 | Houston | Tennessee | 47083 | 2673 | 60 |
2349138 | 2349138 | 2022-03-27 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2349139 | 2349139 | 2022-03-27 | Jackson | Tennessee | 47087 | 3202 | 62 |
2349140 | 2349140 | 2022-03-27 | Jefferson | Tennessee | 47089 | 15692 | 259 |
2349141 | 2349141 | 2022-03-27 | Johnson | Tennessee | 47091 | 5139 | 88 |
2349142 | 2349142 | 2022-03-27 | Knox | Tennessee | 47093 | 127542 | 1335 |
2349143 | 2349143 | 2022-03-27 | Lake | Tennessee | 47095 | 2737 | 40 |
2349144 | 2349144 | 2022-03-27 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2349145 | 2349145 | 2022-03-27 | Lawrence | Tennessee | 47099 | 14258 | 191 |
2349146 | 2349146 | 2022-03-27 | Lewis | Tennessee | 47101 | 3568 | 57 |
2349147 | 2349147 | 2022-03-27 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2349148 | 2349148 | 2022-03-27 | Loudon | Tennessee | 47105 | 14424 | 188 |
2349149 | 2349149 | 2022-03-27 | Macon | Tennessee | 47111 | 8422 | 145 |
2349150 | 2349150 | 2022-03-27 | Madison | Tennessee | 47113 | 29784 | 418 |
2349151 | 2349151 | 2022-03-27 | Marion | Tennessee | 47115 | 8833 | 127 |
2349152 | 2349152 | 2022-03-27 | Marshall | Tennessee | 47117 | 10351 | 119 |
2349153 | 2349153 | 2022-03-27 | Maury | Tennessee | 47119 | 28867 | 330 |
2349154 | 2349154 | 2022-03-27 | McMinn | Tennessee | 47107 | 16652 | 251 |
2349155 | 2349155 | 2022-03-27 | McNairy | Tennessee | 47109 | 7629 | 118 |
2349156 | 2349156 | 2022-03-27 | Meigs | Tennessee | 47121 | 3351 | 55 |
2349157 | 2349157 | 2022-03-27 | Monroe | Tennessee | 47123 | 14482 | 235 |
2349158 | 2349158 | 2022-03-27 | Montgomery | Tennessee | 47125 | 50080 | 561 |
2349159 | 2349159 | 2022-03-27 | Moore | Tennessee | 47127 | 2237 | 40 |
2349160 | 2349160 | 2022-03-27 | Morgan | Tennessee | 47129 | 6158 | 80 |
2349161 | 2349161 | 2022-03-27 | Obion | Tennessee | 47131 | 10753 | 187 |
2349162 | 2349162 | 2022-03-27 | Overton | Tennessee | 47133 | 7147 | 121 |
2349163 | 2349163 | 2022-03-27 | Perry | Tennessee | 47135 | 2328 | 55 |
2349164 | 2349164 | 2022-03-27 | Pickett | Tennessee | 47137 | 1764 | 36 |
2349165 | 2349165 | 2022-03-27 | Polk | Tennessee | 47139 | 4722 | 70 |
2349166 | 2349166 | 2022-03-27 | Putnam | Tennessee | 47141 | 25068 | 302 |
2349167 | 2349167 | 2022-03-27 | Rhea | Tennessee | 47143 | 9959 | 154 |
2349168 | 2349168 | 2022-03-27 | Roane | Tennessee | 47145 | 15764 | 231 |
2349169 | 2349169 | 2022-03-27 | Robertson | Tennessee | 47147 | 21503 | 295 |
2349170 | 2349170 | 2022-03-27 | Rutherford | Tennessee | 47149 | 95505 | 879 |
2349171 | 2349171 | 2022-03-27 | Scott | Tennessee | 47151 | 9029 | 115 |
2349172 | 2349172 | 2022-03-27 | Sequatchie | Tennessee | 47153 | 4204 | 66 |
2349173 | 2349173 | 2022-03-27 | Sevier | Tennessee | 47155 | 30246 | 401 |
2349174 | 2349174 | 2022-03-27 | Shelby | Tennessee | 47157 | 237526 | 3232 |
2349175 | 2349175 | 2022-03-27 | Smith | Tennessee | 47159 | 6157 | 83 |
2349176 | 2349176 | 2022-03-27 | Stewart | Tennessee | 47161 | 3283 | 56 |
2349177 | 2349177 | 2022-03-27 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2349178 | 2349178 | 2022-03-27 | Sumner | Tennessee | 47165 | 53057 | 713 |
2349179 | 2349179 | 2022-03-27 | Tipton | Tennessee | 47167 | 17588 | 230 |
2349180 | 2349180 | 2022-03-27 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2349181 | 2349181 | 2022-03-27 | Unicoi | Tennessee | 47171 | 5156 | 94 |
2349182 | 2349182 | 2022-03-27 | Union | Tennessee | 47173 | 5393 | 72 |
2349183 | 2349183 | 2022-03-27 | Unknown | Tennessee | 19141 | 312 | |
2349184 | 2349184 | 2022-03-27 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2349185 | 2349185 | 2022-03-27 | Warren | Tennessee | 47177 | 12982 | 175 |
2349186 | 2349186 | 2022-03-27 | Washington | Tennessee | 47179 | 38465 | 486 |
2349187 | 2349187 | 2022-03-27 | Wayne | Tennessee | 47181 | 5687 | 63 |
2349188 | 2349188 | 2022-03-27 | Weakley | Tennessee | 47183 | 9491 | 140 |
2349189 | 2349189 | 2022-03-27 | White | Tennessee | 47185 | 8224 | 127 |
2349190 | 2349190 | 2022-03-27 | Williamson | Tennessee | 47187 | 61839 | 395 |
2349191 | 2349191 | 2022-03-27 | Wilson | Tennessee | 47189 | 41556 | 475 |
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);