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 2021-02-26 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1069013 | 1069013 | 2021-02-26 | Anderson | Tennessee | 47001 | 7941 | 156 |
1069014 | 1069014 | 2021-02-26 | Bedford | Tennessee | 47003 | 5776 | 118 |
1069015 | 1069015 | 2021-02-26 | Benton | Tennessee | 47005 | 1505 | 39 |
1069016 | 1069016 | 2021-02-26 | Bledsoe | Tennessee | 47007 | 1997 | 10 |
1069017 | 1069017 | 2021-02-26 | Blount | Tennessee | 47009 | 13990 | 179 |
1069018 | 1069018 | 2021-02-26 | Bradley | Tennessee | 47011 | 12824 | 138 |
1069019 | 1069019 | 2021-02-26 | Campbell | Tennessee | 47013 | 3796 | 59 |
1069020 | 1069020 | 2021-02-26 | Cannon | Tennessee | 47015 | 1742 | 29 |
1069021 | 1069021 | 2021-02-26 | Carroll | Tennessee | 47017 | 3473 | 81 |
1069022 | 1069022 | 2021-02-26 | Carter | Tennessee | 47019 | 5949 | 152 |
1069023 | 1069023 | 2021-02-26 | Cheatham | Tennessee | 47021 | 3894 | 44 |
1069024 | 1069024 | 2021-02-26 | Chester | Tennessee | 47023 | 2007 | 47 |
1069025 | 1069025 | 2021-02-26 | Claiborne | Tennessee | 47025 | 2769 | 67 |
1069026 | 1069026 | 2021-02-26 | Clay | Tennessee | 47027 | 1065 | 30 |
1069027 | 1069027 | 2021-02-26 | Cocke | Tennessee | 47029 | 3972 | 92 |
1069028 | 1069028 | 2021-02-26 | Coffee | Tennessee | 47031 | 6294 | 114 |
1069029 | 1069029 | 2021-02-26 | Crockett | Tennessee | 47033 | 1971 | 47 |
1069030 | 1069030 | 2021-02-26 | Cumberland | Tennessee | 47035 | 6093 | 120 |
1069031 | 1069031 | 2021-02-26 | Davidson | Tennessee | 47037 | 89598 | 854 |
1069032 | 1069032 | 2021-02-26 | DeKalb | Tennessee | 47041 | 2620 | 49 |
1069033 | 1069033 | 2021-02-26 | Decatur | Tennessee | 47039 | 1532 | 37 |
1069034 | 1069034 | 2021-02-26 | Dickson | Tennessee | 47043 | 6183 | 106 |
1069035 | 1069035 | 2021-02-26 | Dyer | Tennessee | 47045 | 5228 | 101 |
1069036 | 1069036 | 2021-02-26 | Fayette | Tennessee | 47047 | 4655 | 71 |
1069037 | 1069037 | 2021-02-26 | Fentress | Tennessee | 47049 | 2285 | 44 |
1069038 | 1069038 | 2021-02-26 | Franklin | Tennessee | 47051 | 4714 | 85 |
1069039 | 1069039 | 2021-02-26 | Gibson | Tennessee | 47053 | 6178 | 140 |
1069040 | 1069040 | 2021-02-26 | Giles | Tennessee | 47055 | 3721 | 96 |
1069041 | 1069041 | 2021-02-26 | Grainger | Tennessee | 47057 | 2422 | 46 |
1069042 | 1069042 | 2021-02-26 | Greene | Tennessee | 47059 | 7271 | 145 |
1069043 | 1069043 | 2021-02-26 | Grundy | Tennessee | 47061 | 1677 | 30 |
1069044 | 1069044 | 2021-02-26 | Hamblen | Tennessee | 47063 | 7987 | 162 |
1069045 | 1069045 | 2021-02-26 | Hamilton | Tennessee | 47065 | 40492 | 462 |
1069046 | 1069046 | 2021-02-26 | Hancock | Tennessee | 47067 | 496 | 12 |
1069047 | 1069047 | 2021-02-26 | Hardeman | Tennessee | 47069 | 3380 | 64 |
1069048 | 1069048 | 2021-02-26 | Hardin | Tennessee | 47071 | 3307 | 63 |
1069049 | 1069049 | 2021-02-26 | Hawkins | Tennessee | 47073 | 5216 | 94 |
1069050 | 1069050 | 2021-02-26 | Haywood | Tennessee | 47075 | 2646 | 60 |
1069051 | 1069051 | 2021-02-26 | Henderson | Tennessee | 47077 | 3614 | 73 |
1069052 | 1069052 | 2021-02-26 | Henry | Tennessee | 47079 | 2994 | 75 |
1069053 | 1069053 | 2021-02-26 | Hickman | Tennessee | 47081 | 2639 | 41 |
1069054 | 1069054 | 2021-02-26 | Houston | Tennessee | 47083 | 1024 | 31 |
1069055 | 1069055 | 2021-02-26 | Humphreys | Tennessee | 47085 | 1522 | 21 |
1069056 | 1069056 | 2021-02-26 | Jackson | Tennessee | 47087 | 1251 | 34 |
1069057 | 1069057 | 2021-02-26 | Jefferson | Tennessee | 47089 | 5620 | 117 |
1069058 | 1069058 | 2021-02-26 | Johnson | Tennessee | 47091 | 2159 | 38 |
1069059 | 1069059 | 2021-02-26 | Knox | Tennessee | 47093 | 46572 | 578 |
1069060 | 1069060 | 2021-02-26 | Lake | Tennessee | 47095 | 1675 | 26 |
1069061 | 1069061 | 2021-02-26 | Lauderdale | Tennessee | 47097 | 3094 | 42 |
1069062 | 1069062 | 2021-02-26 | Lawrence | Tennessee | 47099 | 5556 | 82 |
1069063 | 1069063 | 2021-02-26 | Lewis | Tennessee | 47101 | 1468 | 25 |
1069064 | 1069064 | 2021-02-26 | Lincoln | Tennessee | 47103 | 4120 | 62 |
1069065 | 1069065 | 2021-02-26 | Loudon | Tennessee | 47105 | 5658 | 65 |
1069066 | 1069066 | 2021-02-26 | Macon | Tennessee | 47111 | 3355 | 73 |
1069067 | 1069067 | 2021-02-26 | Madison | Tennessee | 47113 | 10078 | 228 |
1069068 | 1069068 | 2021-02-26 | Marion | Tennessee | 47115 | 2916 | 42 |
1069069 | 1069069 | 2021-02-26 | Marshall | Tennessee | 47117 | 3899 | 55 |
1069070 | 1069070 | 2021-02-26 | Maury | Tennessee | 47119 | 12176 | 162 |
1069071 | 1069071 | 2021-02-26 | McMinn | Tennessee | 47107 | 5902 | 90 |
1069072 | 1069072 | 2021-02-26 | McNairy | Tennessee | 47109 | 2662 | 52 |
1069073 | 1069073 | 2021-02-26 | Meigs | Tennessee | 47121 | 1257 | 21 |
1069074 | 1069074 | 2021-02-26 | Monroe | Tennessee | 47123 | 5298 | 90 |
1069075 | 1069075 | 2021-02-26 | Montgomery | Tennessee | 47125 | 17310 | 212 |
1069076 | 1069076 | 2021-02-26 | Moore | Tennessee | 47127 | 941 | 16 |
1069077 | 1069077 | 2021-02-26 | Morgan | Tennessee | 47129 | 2290 | 37 |
1069078 | 1069078 | 2021-02-26 | Obion | Tennessee | 47131 | 4364 | 94 |
1069079 | 1069079 | 2021-02-26 | Overton | Tennessee | 47133 | 2842 | 57 |
1069080 | 1069080 | 2021-02-26 | Perry | Tennessee | 47135 | 1028 | 27 |
1069081 | 1069081 | 2021-02-26 | Pickett | Tennessee | 47137 | 746 | 23 |
1069082 | 1069082 | 2021-02-26 | Polk | Tennessee | 47139 | 1749 | 22 |
1069083 | 1069083 | 2021-02-26 | Putnam | Tennessee | 47141 | 10579 | 168 |
1069084 | 1069084 | 2021-02-26 | Rhea | Tennessee | 47143 | 4134 | 73 |
1069085 | 1069085 | 2021-02-26 | Roane | Tennessee | 47145 | 5858 | 96 |
1069086 | 1069086 | 2021-02-26 | Robertson | Tennessee | 47147 | 8909 | 119 |
1069087 | 1069087 | 2021-02-26 | Rutherford | Tennessee | 47149 | 38104 | 382 |
1069088 | 1069088 | 2021-02-26 | Scott | Tennessee | 47151 | 2858 | 42 |
1069089 | 1069089 | 2021-02-26 | Sequatchie | Tennessee | 47153 | 1549 | 25 |
1069090 | 1069090 | 2021-02-26 | Sevier | Tennessee | 47155 | 11967 | 163 |
1069091 | 1069091 | 2021-02-26 | Shelby | Tennessee | 47157 | 87840 | 1496 |
1069092 | 1069092 | 2021-02-26 | Smith | Tennessee | 47159 | 2546 | 36 |
1069093 | 1069093 | 2021-02-26 | Stewart | Tennessee | 47161 | 1233 | 24 |
1069094 | 1069094 | 2021-02-26 | Sullivan | Tennessee | 47163 | 14265 | 273 |
1069095 | 1069095 | 2021-02-26 | Sumner | Tennessee | 47165 | 21260 | 315 |
1069096 | 1069096 | 2021-02-26 | Tipton | Tennessee | 47167 | 6919 | 101 |
1069097 | 1069097 | 2021-02-26 | Trousdale | Tennessee | 47169 | 2385 | 22 |
1069098 | 1069098 | 2021-02-26 | Unicoi | Tennessee | 47171 | 1800 | 47 |
1069099 | 1069099 | 2021-02-26 | Union | Tennessee | 47173 | 1711 | 31 |
1069100 | 1069100 | 2021-02-26 | Unknown | Tennessee | 8498 | 119 | |
1069101 | 1069101 | 2021-02-26 | Van Buren | Tennessee | 47175 | 793 | 20 |
1069102 | 1069102 | 2021-02-26 | Warren | Tennessee | 47177 | 5304 | 75 |
1069103 | 1069103 | 2021-02-26 | Washington | Tennessee | 47179 | 12723 | 234 |
1069104 | 1069104 | 2021-02-26 | Wayne | Tennessee | 47181 | 2867 | 30 |
1069105 | 1069105 | 2021-02-26 | Weakley | Tennessee | 47183 | 3783 | 59 |
1069106 | 1069106 | 2021-02-26 | White | Tennessee | 47185 | 3356 | 66 |
1069107 | 1069107 | 2021-02-26 | Williamson | Tennessee | 47187 | 25145 | 202 |
1069108 | 1069108 | 2021-02-26 | Wilson | Tennessee | 47189 | 16293 | 212 |
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);