ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2271030 | 2271030 | 2022-03-03 | Anderson | Tennessee | 47001 | 21877 | 309 |
2271031 | 2271031 | 2022-03-03 | Bedford | Tennessee | 47003 | 14871 | 220 |
2271032 | 2271032 | 2022-03-03 | Benton | Tennessee | 47005 | 4439 | 90 |
2271033 | 2271033 | 2022-03-03 | Bledsoe | Tennessee | 47007 | 4636 | 53 |
2271034 | 2271034 | 2022-03-03 | Blount | Tennessee | 47009 | 38827 | 396 |
2271035 | 2271035 | 2022-03-03 | Bradley | Tennessee | 47011 | 32944 | 383 |
2271036 | 2271036 | 2022-03-03 | Campbell | Tennessee | 47013 | 11917 | 150 |
2271037 | 2271037 | 2022-03-03 | Cannon | Tennessee | 47015 | 4152 | 56 |
2271038 | 2271038 | 2022-03-03 | Carroll | Tennessee | 47017 | 8871 | 147 |
2271039 | 2271039 | 2022-03-03 | Carter | Tennessee | 47019 | 16302 | 311 |
2271040 | 2271040 | 2022-03-03 | Cheatham | Tennessee | 47021 | 10856 | 115 |
2271041 | 2271041 | 2022-03-03 | Chester | Tennessee | 47023 | 5723 | 92 |
2271042 | 2271042 | 2022-03-03 | Claiborne | Tennessee | 47025 | 8958 | 168 |
2271043 | 2271043 | 2022-03-03 | Clay | Tennessee | 47027 | 2216 | 46 |
2271044 | 2271044 | 2022-03-03 | Cocke | Tennessee | 47029 | 11288 | 201 |
2271045 | 2271045 | 2022-03-03 | Coffee | Tennessee | 47031 | 16852 | 239 |
2271046 | 2271046 | 2022-03-03 | Crockett | Tennessee | 47033 | 5098 | 82 |
2271047 | 2271047 | 2022-03-03 | Cumberland | Tennessee | 47035 | 16001 | 309 |
2271048 | 2271048 | 2022-03-03 | Davidson | Tennessee | 47037 | 205772 | 1584 |
2271049 | 2271049 | 2022-03-03 | DeKalb | Tennessee | 47041 | 6246 | 96 |
2271050 | 2271050 | 2022-03-03 | Decatur | Tennessee | 47039 | 3671 | 63 |
2271051 | 2271051 | 2022-03-03 | Dickson | Tennessee | 47043 | 15798 | 234 |
2271052 | 2271052 | 2022-03-03 | Dyer | Tennessee | 47045 | 12642 | 191 |
2271053 | 2271053 | 2022-03-03 | Fayette | Tennessee | 47047 | 11361 | 168 |
2271054 | 2271054 | 2022-03-03 | Fentress | Tennessee | 47049 | 5668 | 115 |
2271055 | 2271055 | 2022-03-03 | Franklin | Tennessee | 47051 | 12770 | 165 |
2271056 | 2271056 | 2022-03-03 | Gibson | Tennessee | 47053 | 17187 | 250 |
2271057 | 2271057 | 2022-03-03 | Giles | Tennessee | 47055 | 9374 | 172 |
2271058 | 2271058 | 2022-03-03 | Grainger | Tennessee | 47057 | 6735 | 103 |
2271059 | 2271059 | 2022-03-03 | Greene | Tennessee | 47059 | 21883 | 350 |
2271060 | 2271060 | 2022-03-03 | Grundy | Tennessee | 47061 | 3960 | 69 |
2271061 | 2271061 | 2022-03-03 | Hamblen | Tennessee | 47063 | 19588 | 345 |
2271062 | 2271062 | 2022-03-03 | Hamilton | Tennessee | 47065 | 98468 | 1078 |
2271063 | 2271063 | 2022-03-03 | Hancock | Tennessee | 47067 | 1985 | 31 |
2271064 | 2271064 | 2022-03-03 | Hardeman | Tennessee | 47069 | 7463 | 115 |
2271065 | 2271065 | 2022-03-03 | Hardin | Tennessee | 47071 | 8629 | 135 |
2271066 | 2271066 | 2022-03-03 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2271067 | 2271067 | 2022-03-03 | Haywood | Tennessee | 47075 | 6107 | 97 |
2271068 | 2271068 | 2022-03-03 | Henderson | Tennessee | 47077 | 8944 | 145 |
2271069 | 2271069 | 2022-03-03 | Henry | Tennessee | 47079 | 8160 | 147 |
2271070 | 2271070 | 2022-03-03 | Hickman | Tennessee | 47081 | 6789 | 103 |
2271071 | 2271071 | 2022-03-03 | Houston | Tennessee | 47083 | 2663 | 59 |
2271072 | 2271072 | 2022-03-03 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2271073 | 2271073 | 2022-03-03 | Jackson | Tennessee | 47087 | 3189 | 59 |
2271074 | 2271074 | 2022-03-03 | Jefferson | Tennessee | 47089 | 15585 | 254 |
2271075 | 2271075 | 2022-03-03 | Johnson | Tennessee | 47091 | 5096 | 85 |
2271076 | 2271076 | 2022-03-03 | Knox | Tennessee | 47093 | 126763 | 1277 |
2271077 | 2271077 | 2022-03-03 | Lake | Tennessee | 47095 | 2705 | 40 |
2271078 | 2271078 | 2022-03-03 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2271079 | 2271079 | 2022-03-03 | Lawrence | Tennessee | 47099 | 14209 | 185 |
2271080 | 2271080 | 2022-03-03 | Lewis | Tennessee | 47101 | 3565 | 50 |
2271081 | 2271081 | 2022-03-03 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2271082 | 2271082 | 2022-03-03 | Loudon | Tennessee | 47105 | 14319 | 185 |
2271083 | 2271083 | 2022-03-03 | Macon | Tennessee | 47111 | 8380 | 139 |
2271084 | 2271084 | 2022-03-03 | Madison | Tennessee | 47113 | 29429 | 403 |
2271085 | 2271085 | 2022-03-03 | Marion | Tennessee | 47115 | 8786 | 123 |
2271086 | 2271086 | 2022-03-03 | Marshall | Tennessee | 47117 | 10312 | 116 |
2271087 | 2271087 | 2022-03-03 | Maury | Tennessee | 47119 | 28772 | 315 |
2271088 | 2271088 | 2022-03-03 | McMinn | Tennessee | 47107 | 16604 | 236 |
2271089 | 2271089 | 2022-03-03 | McNairy | Tennessee | 47109 | 7559 | 113 |
2271090 | 2271090 | 2022-03-03 | Meigs | Tennessee | 47121 | 3345 | 54 |
2271091 | 2271091 | 2022-03-03 | Monroe | Tennessee | 47123 | 14400 | 217 |
2271092 | 2271092 | 2022-03-03 | Montgomery | Tennessee | 47125 | 49805 | 546 |
2271093 | 2271093 | 2022-03-03 | Moore | Tennessee | 47127 | 2225 | 37 |
2271094 | 2271094 | 2022-03-03 | Morgan | Tennessee | 47129 | 6102 | 77 |
2271095 | 2271095 | 2022-03-03 | Obion | Tennessee | 47131 | 10724 | 179 |
2271096 | 2271096 | 2022-03-03 | Overton | Tennessee | 47133 | 7124 | 118 |
2271097 | 2271097 | 2022-03-03 | Perry | Tennessee | 47135 | 2315 | 48 |
2271098 | 2271098 | 2022-03-03 | Pickett | Tennessee | 47137 | 1761 | 30 |
2271099 | 2271099 | 2022-03-03 | Polk | Tennessee | 47139 | 4670 | 65 |
2271100 | 2271100 | 2022-03-03 | Putnam | Tennessee | 47141 | 24976 | 291 |
2271101 | 2271101 | 2022-03-03 | Rhea | Tennessee | 47143 | 9920 | 148 |
2271102 | 2271102 | 2022-03-03 | Roane | Tennessee | 47145 | 15681 | 221 |
2271103 | 2271103 | 2022-03-03 | Robertson | Tennessee | 47147 | 21427 | 288 |
2271104 | 2271104 | 2022-03-03 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2271105 | 2271105 | 2022-03-03 | Scott | Tennessee | 47151 | 8917 | 108 |
2271106 | 2271106 | 2022-03-03 | Sequatchie | Tennessee | 47153 | 4183 | 66 |
2271107 | 2271107 | 2022-03-03 | Sevier | Tennessee | 47155 | 30075 | 389 |
2271108 | 2271108 | 2022-03-03 | Shelby | Tennessee | 47157 | 236781 | 3154 |
2271109 | 2271109 | 2022-03-03 | Smith | Tennessee | 47159 | 6149 | 74 |
2271110 | 2271110 | 2022-03-03 | Stewart | Tennessee | 47161 | 3268 | 52 |
2271111 | 2271111 | 2022-03-03 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2271112 | 2271112 | 2022-03-03 | Sumner | Tennessee | 47165 | 52831 | 688 |
2271113 | 2271113 | 2022-03-03 | Tipton | Tennessee | 47167 | 17535 | 219 |
2271114 | 2271114 | 2022-03-03 | Trousdale | Tennessee | 47169 | 4200 | 45 |
2271115 | 2271115 | 2022-03-03 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2271116 | 2271116 | 2022-03-03 | Union | Tennessee | 47173 | 5373 | 69 |
2271117 | 2271117 | 2022-03-03 | Unknown | Tennessee | 21053 | 381 | |
2271118 | 2271118 | 2022-03-03 | Van Buren | Tennessee | 47175 | 1840 | 46 |
2271119 | 2271119 | 2022-03-03 | Warren | Tennessee | 47177 | 12936 | 167 |
2271120 | 2271120 | 2022-03-03 | Washington | Tennessee | 47179 | 38226 | 467 |
2271121 | 2271121 | 2022-03-03 | Wayne | Tennessee | 47181 | 5644 | 56 |
2271122 | 2271122 | 2022-03-03 | Weakley | Tennessee | 47183 | 9440 | 134 |
2271123 | 2271123 | 2022-03-03 | White | Tennessee | 47185 | 8182 | 126 |
2271124 | 2271124 | 2022-03-03 | Williamson | Tennessee | 47187 | 61546 | 382 |
2271125 | 2271125 | 2022-03-03 | Wilson | Tennessee | 47189 | 41368 | 464 |
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);