ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2020-04-05 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
35065 | 35065 | 2020-04-05 | Anderson | Tennessee | 47001 | 10 | 0 |
35066 | 35066 | 2020-04-05 | Bedford | Tennessee | 47003 | 8 | 0 |
35067 | 35067 | 2020-04-05 | Benton | Tennessee | 47005 | 4 | 0 |
35068 | 35068 | 2020-04-05 | Bledsoe | Tennessee | 47007 | 3 | 0 |
35069 | 35069 | 2020-04-05 | Blount | Tennessee | 47009 | 36 | 1 |
35070 | 35070 | 2020-04-05 | Bradley | Tennessee | 47011 | 21 | 0 |
35071 | 35071 | 2020-04-05 | Campbell | Tennessee | 47013 | 5 | 0 |
35072 | 35072 | 2020-04-05 | Cannon | Tennessee | 47015 | 6 | 0 |
35073 | 35073 | 2020-04-05 | Carroll | Tennessee | 47017 | 7 | 0 |
35074 | 35074 | 2020-04-05 | Carter | Tennessee | 47019 | 3 | 0 |
35075 | 35075 | 2020-04-05 | Cheatham | Tennessee | 47021 | 13 | 0 |
35076 | 35076 | 2020-04-05 | Chester | Tennessee | 47023 | 6 | 0 |
35077 | 35077 | 2020-04-05 | Claiborne | Tennessee | 47025 | 2 | 0 |
35078 | 35078 | 2020-04-05 | Clay | Tennessee | 47027 | 1 | 0 |
35079 | 35079 | 2020-04-05 | Cocke | Tennessee | 47029 | 1 | 0 |
35080 | 35080 | 2020-04-05 | Coffee | Tennessee | 47031 | 5 | 0 |
35081 | 35081 | 2020-04-05 | Cumberland | Tennessee | 47035 | 26 | 0 |
35082 | 35082 | 2020-04-05 | Davidson | Tennessee | 47037 | 924 | 6 |
35083 | 35083 | 2020-04-05 | DeKalb | Tennessee | 47041 | 7 | 0 |
35084 | 35084 | 2020-04-05 | Dickson | Tennessee | 47043 | 23 | 0 |
35085 | 35085 | 2020-04-05 | Dyer | Tennessee | 47045 | 9 | 0 |
35086 | 35086 | 2020-04-05 | Fayette | Tennessee | 47047 | 20 | 0 |
35087 | 35087 | 2020-04-05 | Fentress | Tennessee | 47049 | 2 | 0 |
35088 | 35088 | 2020-04-05 | Franklin | Tennessee | 47051 | 12 | 1 |
35089 | 35089 | 2020-04-05 | Gibson | Tennessee | 47053 | 11 | 0 |
35090 | 35090 | 2020-04-05 | Giles | Tennessee | 47055 | 3 | 0 |
35091 | 35091 | 2020-04-05 | Grainger | Tennessee | 47057 | 3 | 0 |
35092 | 35092 | 2020-04-05 | Greene | Tennessee | 47059 | 17 | 1 |
35093 | 35093 | 2020-04-05 | Grundy | Tennessee | 47061 | 12 | 0 |
35094 | 35094 | 2020-04-05 | Hamblen | Tennessee | 47063 | 4 | 0 |
35095 | 35095 | 2020-04-05 | Hamilton | Tennessee | 47065 | 79 | 8 |
35096 | 35096 | 2020-04-05 | Hardeman | Tennessee | 47069 | 6 | 0 |
35097 | 35097 | 2020-04-05 | Hardin | Tennessee | 47071 | 2 | 0 |
35098 | 35098 | 2020-04-05 | Hawkins | Tennessee | 47073 | 10 | 1 |
35099 | 35099 | 2020-04-05 | Haywood | Tennessee | 47075 | 3 | 0 |
35100 | 35100 | 2020-04-05 | Henderson | Tennessee | 47077 | 1 | 0 |
35101 | 35101 | 2020-04-05 | Henry | Tennessee | 47079 | 4 | 0 |
35102 | 35102 | 2020-04-05 | Hickman | Tennessee | 47081 | 2 | 0 |
35103 | 35103 | 2020-04-05 | Houston | Tennessee | 47083 | 2 | 0 |
35104 | 35104 | 2020-04-05 | Humphreys | Tennessee | 47085 | 3 | 0 |
35105 | 35105 | 2020-04-05 | Jackson | Tennessee | 47087 | 3 | 0 |
35106 | 35106 | 2020-04-05 | Jefferson | Tennessee | 47089 | 6 | 0 |
35107 | 35107 | 2020-04-05 | Johnson | Tennessee | 47091 | 2 | 0 |
35108 | 35108 | 2020-04-05 | Knox | Tennessee | 47093 | 115 | 1 |
35109 | 35109 | 2020-04-05 | Lauderdale | Tennessee | 47097 | 2 | 0 |
35110 | 35110 | 2020-04-05 | Lawrence | Tennessee | 47099 | 3 | 0 |
35111 | 35111 | 2020-04-05 | Lewis | Tennessee | 47101 | 2 | 0 |
35112 | 35112 | 2020-04-05 | Lincoln | Tennessee | 47103 | 5 | 0 |
35113 | 35113 | 2020-04-05 | Loudon | Tennessee | 47105 | 13 | 0 |
35114 | 35114 | 2020-04-05 | Macon | Tennessee | 47111 | 9 | 0 |
35115 | 35115 | 2020-04-05 | Madison | Tennessee | 47113 | 19 | 0 |
35116 | 35116 | 2020-04-05 | Marion | Tennessee | 47115 | 16 | 1 |
35117 | 35117 | 2020-04-05 | Marshall | Tennessee | 47117 | 6 | 0 |
35118 | 35118 | 2020-04-05 | Maury | Tennessee | 47119 | 21 | 0 |
35119 | 35119 | 2020-04-05 | McMinn | Tennessee | 47107 | 3 | 0 |
35120 | 35120 | 2020-04-05 | McNairy | Tennessee | 47109 | 3 | 0 |
35121 | 35121 | 2020-04-05 | Meigs | Tennessee | 47121 | 2 | 0 |
35122 | 35122 | 2020-04-05 | Monroe | Tennessee | 47123 | 6 | 0 |
35123 | 35123 | 2020-04-05 | Montgomery | Tennessee | 47125 | 51 | 1 |
35124 | 35124 | 2020-04-05 | Morgan | Tennessee | 47129 | 4 | 0 |
35125 | 35125 | 2020-04-05 | Obion | Tennessee | 47131 | 2 | 1 |
35126 | 35126 | 2020-04-05 | Overton | Tennessee | 47133 | 3 | 0 |
35127 | 35127 | 2020-04-05 | Perry | Tennessee | 47135 | 3 | 0 |
35128 | 35128 | 2020-04-05 | Polk | Tennessee | 47139 | 3 | 0 |
35129 | 35129 | 2020-04-05 | Putnam | Tennessee | 47141 | 81 | 0 |
35130 | 35130 | 2020-04-05 | Roane | Tennessee | 47145 | 5 | 0 |
35131 | 35131 | 2020-04-05 | Robertson | Tennessee | 47147 | 59 | 0 |
35132 | 35132 | 2020-04-05 | Rutherford | Tennessee | 47149 | 147 | 3 |
35133 | 35133 | 2020-04-05 | Scott | Tennessee | 47151 | 3 | 0 |
35134 | 35134 | 2020-04-05 | Sequatchie | Tennessee | 47153 | 2 | 0 |
35135 | 35135 | 2020-04-05 | Sevier | Tennessee | 47155 | 14 | 0 |
35136 | 35136 | 2020-04-05 | Shelby | Tennessee | 47157 | 754 | 11 |
35137 | 35137 | 2020-04-05 | Smith | Tennessee | 47159 | 3 | 0 |
35138 | 35138 | 2020-04-05 | Stewart | Tennessee | 47161 | 2 | 0 |
35139 | 35139 | 2020-04-05 | Sullivan | Tennessee | 47163 | 21 | 1 |
35140 | 35140 | 2020-04-05 | Sumner | Tennessee | 47165 | 321 | 10 |
35141 | 35141 | 2020-04-05 | Tipton | Tennessee | 47167 | 33 | 0 |
35142 | 35142 | 2020-04-05 | Trousdale | Tennessee | 47169 | 8 | 1 |
35143 | 35143 | 2020-04-05 | Unicoi | Tennessee | 47171 | 1 | 0 |
35144 | 35144 | 2020-04-05 | Union | Tennessee | 47173 | 1 | 0 |
35145 | 35145 | 2020-04-05 | Unknown | Tennessee | 81 | 0 | |
35146 | 35146 | 2020-04-05 | Warren | Tennessee | 47177 | 1 | 0 |
35147 | 35147 | 2020-04-05 | Washington | Tennessee | 47179 | 23 | 0 |
35148 | 35148 | 2020-04-05 | Wayne | Tennessee | 47181 | 2 | 0 |
35149 | 35149 | 2020-04-05 | Weakley | Tennessee | 47183 | 5 | 0 |
35150 | 35150 | 2020-04-05 | White | Tennessee | 47185 | 2 | 0 |
35151 | 35151 | 2020-04-05 | Williamson | Tennessee | 47187 | 258 | 2 |
35152 | 35152 | 2020-04-05 | Wilson | Tennessee | 47189 | 93 | 0 |
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);