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 2020-09-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
579049 | 579049 | 2020-09-28 | Anderson | Tennessee | 47001 | 1202 | 13 |
579050 | 579050 | 2020-09-28 | Bedford | Tennessee | 47003 | 1370 | 17 |
579051 | 579051 | 2020-09-28 | Benton | Tennessee | 47005 | 339 | 9 |
579052 | 579052 | 2020-09-28 | Bledsoe | Tennessee | 47007 | 862 | 4 |
579053 | 579053 | 2020-09-28 | Blount | Tennessee | 47009 | 2548 | 24 |
579054 | 579054 | 2020-09-28 | Bradley | Tennessee | 47011 | 2967 | 17 |
579055 | 579055 | 2020-09-28 | Campbell | Tennessee | 47013 | 456 | 4 |
579056 | 579056 | 2020-09-28 | Cannon | Tennessee | 47015 | 295 | 0 |
579057 | 579057 | 2020-09-28 | Carroll | Tennessee | 47017 | 905 | 20 |
579058 | 579058 | 2020-09-28 | Carter | Tennessee | 47019 | 1179 | 28 |
579059 | 579059 | 2020-09-28 | Cheatham | Tennessee | 47021 | 819 | 10 |
579060 | 579060 | 2020-09-28 | Chester | Tennessee | 47023 | 646 | 10 |
579061 | 579061 | 2020-09-28 | Claiborne | Tennessee | 47025 | 442 | 5 |
579062 | 579062 | 2020-09-28 | Clay | Tennessee | 47027 | 234 | 5 |
579063 | 579063 | 2020-09-28 | Cocke | Tennessee | 47029 | 753 | 10 |
579064 | 579064 | 2020-09-28 | Coffee | Tennessee | 47031 | 1255 | 13 |
579065 | 579065 | 2020-09-28 | Crockett | Tennessee | 47033 | 544 | 19 |
579066 | 579066 | 2020-09-28 | Cumberland | Tennessee | 47035 | 1217 | 18 |
579067 | 579067 | 2020-09-28 | Davidson | Tennessee | 47037 | 28846 | 307 |
579068 | 579068 | 2020-09-28 | DeKalb | Tennessee | 47041 | 572 | 14 |
579069 | 579069 | 2020-09-28 | Decatur | Tennessee | 47039 | 531 | 7 |
579070 | 579070 | 2020-09-28 | Dickson | Tennessee | 47043 | 1277 | 15 |
579071 | 579071 | 2020-09-28 | Dyer | Tennessee | 47045 | 1403 | 14 |
579072 | 579072 | 2020-09-28 | Fayette | Tennessee | 47047 | 1206 | 19 |
579073 | 579073 | 2020-09-28 | Fentress | Tennessee | 47049 | 527 | 3 |
579074 | 579074 | 2020-09-28 | Franklin | Tennessee | 47051 | 989 | 10 |
579075 | 579075 | 2020-09-28 | Gibson | Tennessee | 47053 | 1713 | 23 |
579076 | 579076 | 2020-09-28 | Giles | Tennessee | 47055 | 637 | 17 |
579077 | 579077 | 2020-09-28 | Grainger | Tennessee | 47057 | 386 | 3 |
579078 | 579078 | 2020-09-28 | Greene | Tennessee | 47059 | 1166 | 44 |
579079 | 579079 | 2020-09-28 | Grundy | Tennessee | 47061 | 312 | 6 |
579080 | 579080 | 2020-09-28 | Hamblen | Tennessee | 47063 | 1943 | 26 |
579081 | 579081 | 2020-09-28 | Hamilton | Tennessee | 47065 | 9702 | 95 |
579082 | 579082 | 2020-09-28 | Hancock | Tennessee | 47067 | 107 | 3 |
579083 | 579083 | 2020-09-28 | Hardeman | Tennessee | 47069 | 1583 | 26 |
579084 | 579084 | 2020-09-28 | Hardin | Tennessee | 47071 | 1052 | 16 |
579085 | 579085 | 2020-09-28 | Hawkins | Tennessee | 47073 | 823 | 18 |
579086 | 579086 | 2020-09-28 | Haywood | Tennessee | 47075 | 992 | 21 |
579087 | 579087 | 2020-09-28 | Henderson | Tennessee | 47077 | 1191 | 24 |
579088 | 579088 | 2020-09-28 | Henry | Tennessee | 47079 | 628 | 9 |
579089 | 579089 | 2020-09-28 | Hickman | Tennessee | 47081 | 599 | 8 |
579090 | 579090 | 2020-09-28 | Houston | Tennessee | 47083 | 228 | 3 |
579091 | 579091 | 2020-09-28 | Humphreys | Tennessee | 47085 | 263 | 3 |
579092 | 579092 | 2020-09-28 | Jackson | Tennessee | 47087 | 332 | 5 |
579093 | 579093 | 2020-09-28 | Jefferson | Tennessee | 47089 | 1134 | 14 |
579094 | 579094 | 2020-09-28 | Johnson | Tennessee | 47091 | 729 | 2 |
579095 | 579095 | 2020-09-28 | Knox | Tennessee | 47093 | 10197 | 83 |
579096 | 579096 | 2020-09-28 | Lake | Tennessee | 47095 | 925 | 2 |
579097 | 579097 | 2020-09-28 | Lauderdale | Tennessee | 47097 | 995 | 16 |
579098 | 579098 | 2020-09-28 | Lawrence | Tennessee | 47099 | 1077 | 13 |
579099 | 579099 | 2020-09-28 | Lewis | Tennessee | 47101 | 207 | 1 |
579100 | 579100 | 2020-09-28 | Lincoln | Tennessee | 47103 | 628 | 1 |
579101 | 579101 | 2020-09-28 | Loudon | Tennessee | 47105 | 1190 | 6 |
579102 | 579102 | 2020-09-28 | Macon | Tennessee | 47111 | 1068 | 21 |
579103 | 579103 | 2020-09-28 | Madison | Tennessee | 47113 | 2943 | 64 |
579104 | 579104 | 2020-09-28 | Marion | Tennessee | 47115 | 538 | 8 |
579105 | 579105 | 2020-09-28 | Marshall | Tennessee | 47117 | 780 | 5 |
579106 | 579106 | 2020-09-28 | Maury | Tennessee | 47119 | 2420 | 24 |
579107 | 579107 | 2020-09-28 | McMinn | Tennessee | 47107 | 1150 | 25 |
579108 | 579108 | 2020-09-28 | McNairy | Tennessee | 47109 | 918 | 18 |
579109 | 579109 | 2020-09-28 | Meigs | Tennessee | 47121 | 228 | 3 |
579110 | 579110 | 2020-09-28 | Monroe | Tennessee | 47123 | 1058 | 18 |
579111 | 579111 | 2020-09-28 | Montgomery | Tennessee | 47125 | 3123 | 44 |
579112 | 579112 | 2020-09-28 | Moore | Tennessee | 47127 | 180 | 1 |
579113 | 579113 | 2020-09-28 | Morgan | Tennessee | 47129 | 321 | 3 |
579114 | 579114 | 2020-09-28 | Obion | Tennessee | 47131 | 1200 | 11 |
579115 | 579115 | 2020-09-28 | Overton | Tennessee | 47133 | 766 | 6 |
579116 | 579116 | 2020-09-28 | Perry | Tennessee | 47135 | 153 | 0 |
579117 | 579117 | 2020-09-28 | Pickett | Tennessee | 47137 | 123 | 2 |
579118 | 579118 | 2020-09-28 | Polk | Tennessee | 47139 | 406 | 10 |
579119 | 579119 | 2020-09-28 | Putnam | Tennessee | 47141 | 3355 | 41 |
579120 | 579120 | 2020-09-28 | Rhea | Tennessee | 47143 | 850 | 13 |
579121 | 579121 | 2020-09-28 | Roane | Tennessee | 47145 | 909 | 6 |
579122 | 579122 | 2020-09-28 | Robertson | Tennessee | 47147 | 2231 | 35 |
579123 | 579123 | 2020-09-28 | Rutherford | Tennessee | 47149 | 9408 | 90 |
579124 | 579124 | 2020-09-28 | Scott | Tennessee | 47151 | 218 | 2 |
579125 | 579125 | 2020-09-28 | Sequatchie | Tennessee | 47153 | 242 | 1 |
579126 | 579126 | 2020-09-28 | Sevier | Tennessee | 47155 | 2647 | 15 |
579127 | 579127 | 2020-09-28 | Shelby | Tennessee | 47157 | 31391 | 460 |
579128 | 579128 | 2020-09-28 | Smith | Tennessee | 47159 | 734 | 11 |
579129 | 579129 | 2020-09-28 | Stewart | Tennessee | 47161 | 219 | 2 |
579130 | 579130 | 2020-09-28 | Sullivan | Tennessee | 47163 | 2220 | 33 |
579131 | 579131 | 2020-09-28 | Sumner | Tennessee | 47165 | 4883 | 98 |
579132 | 579132 | 2020-09-28 | Tipton | Tennessee | 47167 | 1836 | 19 |
579133 | 579133 | 2020-09-28 | Trousdale | Tennessee | 47169 | 1668 | 7 |
579134 | 579134 | 2020-09-28 | Unicoi | Tennessee | 47171 | 288 | 1 |
579135 | 579135 | 2020-09-28 | Union | Tennessee | 47173 | 371 | 2 |
579136 | 579136 | 2020-09-28 | Unknown | Tennessee | 0 | 3 | |
579137 | 579137 | 2020-09-28 | Van Buren | Tennessee | 47175 | 166 | 0 |
579138 | 579138 | 2020-09-28 | Warren | Tennessee | 47177 | 1078 | 7 |
579139 | 579139 | 2020-09-28 | Washington | Tennessee | 47179 | 2337 | 36 |
579140 | 579140 | 2020-09-28 | Wayne | Tennessee | 47181 | 1502 | 5 |
579141 | 579141 | 2020-09-28 | Weakley | Tennessee | 47183 | 1212 | 19 |
579142 | 579142 | 2020-09-28 | White | Tennessee | 47185 | 849 | 9 |
579143 | 579143 | 2020-09-28 | Williamson | Tennessee | 47187 | 5341 | 36 |
579144 | 579144 | 2020-09-28 | Wilson | Tennessee | 47189 | 3538 | 45 |
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);