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-12-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
845078 | 845078 | 2020-12-19 | Anderson | Tennessee | 47001 | 4809 | 46 |
845079 | 845079 | 2020-12-19 | Bedford | Tennessee | 47003 | 4038 | 54 |
845080 | 845080 | 2020-12-19 | Benton | Tennessee | 47005 | 1088 | 26 |
845081 | 845081 | 2020-12-19 | Bledsoe | Tennessee | 47007 | 1442 | 6 |
845082 | 845082 | 2020-12-19 | Blount | Tennessee | 47009 | 8387 | 84 |
845083 | 845083 | 2020-12-19 | Bradley | Tennessee | 47011 | 7891 | 60 |
845084 | 845084 | 2020-12-19 | Campbell | Tennessee | 47013 | 2274 | 30 |
845085 | 845085 | 2020-12-19 | Cannon | Tennessee | 47015 | 1207 | 7 |
845086 | 845086 | 2020-12-19 | Carroll | Tennessee | 47017 | 2399 | 46 |
845087 | 845087 | 2020-12-19 | Carter | Tennessee | 47019 | 3883 | 76 |
845088 | 845088 | 2020-12-19 | Cheatham | Tennessee | 47021 | 2404 | 19 |
845089 | 845089 | 2020-12-19 | Chester | Tennessee | 47023 | 1300 | 26 |
845090 | 845090 | 2020-12-19 | Claiborne | Tennessee | 47025 | 1404 | 12 |
845091 | 845091 | 2020-12-19 | Clay | Tennessee | 47027 | 768 | 21 |
845092 | 845092 | 2020-12-19 | Cocke | Tennessee | 47029 | 2386 | 35 |
845093 | 845093 | 2020-12-19 | Coffee | Tennessee | 47031 | 4279 | 54 |
845094 | 845094 | 2020-12-19 | Crockett | Tennessee | 47033 | 1468 | 29 |
845095 | 845095 | 2020-12-19 | Cumberland | Tennessee | 47035 | 3723 | 48 |
845096 | 845096 | 2020-12-19 | Davidson | Tennessee | 47037 | 60791 | 498 |
845097 | 845097 | 2020-12-19 | DeKalb | Tennessee | 47041 | 1817 | 27 |
845098 | 845098 | 2020-12-19 | Decatur | Tennessee | 47039 | 1203 | 17 |
845099 | 845099 | 2020-12-19 | Dickson | Tennessee | 47043 | 4061 | 51 |
845100 | 845100 | 2020-12-19 | Dyer | Tennessee | 47045 | 3894 | 65 |
845101 | 845101 | 2020-12-19 | Fayette | Tennessee | 47047 | 2941 | 44 |
845102 | 845102 | 2020-12-19 | Fentress | Tennessee | 47049 | 1672 | 27 |
845103 | 845103 | 2020-12-19 | Franklin | Tennessee | 47051 | 3041 | 44 |
845104 | 845104 | 2020-12-19 | Gibson | Tennessee | 47053 | 4404 | 81 |
845105 | 845105 | 2020-12-19 | Giles | Tennessee | 47055 | 2162 | 56 |
845106 | 845106 | 2020-12-19 | Grainger | Tennessee | 47057 | 1549 | 22 |
845107 | 845107 | 2020-12-19 | Greene | Tennessee | 47059 | 4739 | 82 |
845108 | 845108 | 2020-12-19 | Grundy | Tennessee | 47061 | 1056 | 14 |
845109 | 845109 | 2020-12-19 | Hamblen | Tennessee | 47063 | 5063 | 71 |
845110 | 845110 | 2020-12-19 | Hamilton | Tennessee | 47065 | 25108 | 234 |
845111 | 845111 | 2020-12-19 | Hancock | Tennessee | 47067 | 283 | 4 |
845112 | 845112 | 2020-12-19 | Hardeman | Tennessee | 47069 | 2643 | 40 |
845113 | 845113 | 2020-12-19 | Hardin | Tennessee | 47071 | 2332 | 33 |
845114 | 845114 | 2020-12-19 | Hawkins | Tennessee | 47073 | 3078 | 48 |
845115 | 845115 | 2020-12-19 | Haywood | Tennessee | 47075 | 2008 | 34 |
845116 | 845116 | 2020-12-19 | Henderson | Tennessee | 47077 | 2552 | 40 |
845117 | 845117 | 2020-12-19 | Henry | Tennessee | 47079 | 2101 | 31 |
845118 | 845118 | 2020-12-19 | Hickman | Tennessee | 47081 | 1665 | 24 |
845119 | 845119 | 2020-12-19 | Houston | Tennessee | 47083 | 725 | 21 |
845120 | 845120 | 2020-12-19 | Humphreys | Tennessee | 47085 | 1028 | 10 |
845121 | 845121 | 2020-12-19 | Jackson | Tennessee | 47087 | 873 | 18 |
845122 | 845122 | 2020-12-19 | Jefferson | Tennessee | 47089 | 3273 | 54 |
845123 | 845123 | 2020-12-19 | Johnson | Tennessee | 47091 | 1684 | 27 |
845124 | 845124 | 2020-12-19 | Knox | Tennessee | 47093 | 28461 | 258 |
845125 | 845125 | 2020-12-19 | Lake | Tennessee | 47095 | 1340 | 11 |
845126 | 845126 | 2020-12-19 | Lauderdale | Tennessee | 47097 | 2451 | 27 |
845127 | 845127 | 2020-12-19 | Lawrence | Tennessee | 47099 | 3859 | 52 |
845128 | 845128 | 2020-12-19 | Lewis | Tennessee | 47101 | 1055 | 19 |
845129 | 845129 | 2020-12-19 | Lincoln | Tennessee | 47103 | 2828 | 27 |
845130 | 845130 | 2020-12-19 | Loudon | Tennessee | 47105 | 3484 | 28 |
845131 | 845131 | 2020-12-19 | Macon | Tennessee | 47111 | 2351 | 34 |
845132 | 845132 | 2020-12-19 | Madison | Tennessee | 47113 | 7107 | 141 |
845133 | 845133 | 2020-12-19 | Marion | Tennessee | 47115 | 1648 | 22 |
845134 | 845134 | 2020-12-19 | Marshall | Tennessee | 47117 | 2460 | 27 |
845135 | 845135 | 2020-12-19 | Maury | Tennessee | 47119 | 8109 | 95 |
845136 | 845136 | 2020-12-19 | McMinn | Tennessee | 47107 | 3831 | 60 |
845137 | 845137 | 2020-12-19 | McNairy | Tennessee | 47109 | 1767 | 35 |
845138 | 845138 | 2020-12-19 | Meigs | Tennessee | 47121 | 817 | 14 |
845139 | 845139 | 2020-12-19 | Monroe | Tennessee | 47123 | 3241 | 50 |
845140 | 845140 | 2020-12-19 | Montgomery | Tennessee | 47125 | 9869 | 106 |
845141 | 845141 | 2020-12-19 | Moore | Tennessee | 47127 | 590 | 4 |
845142 | 845142 | 2020-12-19 | Morgan | Tennessee | 47129 | 1284 | 11 |
845143 | 845143 | 2020-12-19 | Obion | Tennessee | 47131 | 3335 | 66 |
845144 | 845144 | 2020-12-19 | Overton | Tennessee | 47133 | 1916 | 39 |
845145 | 845145 | 2020-12-19 | Perry | Tennessee | 47135 | 750 | 23 |
845146 | 845146 | 2020-12-19 | Pickett | Tennessee | 47137 | 493 | 17 |
845147 | 845147 | 2020-12-19 | Polk | Tennessee | 47139 | 1002 | 15 |
845148 | 845148 | 2020-12-19 | Putnam | Tennessee | 47141 | 7717 | 106 |
845149 | 845149 | 2020-12-19 | Rhea | Tennessee | 47143 | 2688 | 44 |
845150 | 845150 | 2020-12-19 | Roane | Tennessee | 47145 | 3670 | 44 |
845151 | 845151 | 2020-12-19 | Robertson | Tennessee | 47147 | 5595 | 69 |
845152 | 845152 | 2020-12-19 | Rutherford | Tennessee | 47149 | 25081 | 213 |
845153 | 845153 | 2020-12-19 | Scott | Tennessee | 47151 | 1737 | 15 |
845154 | 845154 | 2020-12-19 | Sequatchie | Tennessee | 47153 | 974 | 7 |
845155 | 845155 | 2020-12-19 | Sevier | Tennessee | 47155 | 7527 | 57 |
845156 | 845156 | 2020-12-19 | Shelby | Tennessee | 47157 | 60651 | 810 |
845157 | 845157 | 2020-12-19 | Smith | Tennessee | 47159 | 1863 | 23 |
845158 | 845158 | 2020-12-19 | Stewart | Tennessee | 47161 | 776 | 19 |
845159 | 845159 | 2020-12-19 | Sullivan | Tennessee | 47163 | 9435 | 161 |
845160 | 845160 | 2020-12-19 | Sumner | Tennessee | 47165 | 13866 | 181 |
845161 | 845161 | 2020-12-19 | Tipton | Tennessee | 47167 | 4795 | 49 |
845162 | 845162 | 2020-12-19 | Trousdale | Tennessee | 47169 | 2074 | 12 |
845163 | 845163 | 2020-12-19 | Unicoi | Tennessee | 47171 | 1253 | 36 |
845164 | 845164 | 2020-12-19 | Union | Tennessee | 47173 | 1086 | 7 |
845165 | 845165 | 2020-12-19 | Unknown | Tennessee | 0 | 37 | |
845166 | 845166 | 2020-12-19 | Van Buren | Tennessee | 47175 | 510 | 5 |
845167 | 845167 | 2020-12-19 | Warren | Tennessee | 47177 | 3783 | 28 |
845168 | 845168 | 2020-12-19 | Washington | Tennessee | 47179 | 8958 | 144 |
845169 | 845169 | 2020-12-19 | Wayne | Tennessee | 47181 | 2241 | 16 |
845170 | 845170 | 2020-12-19 | Weakley | Tennessee | 47183 | 2758 | 40 |
845171 | 845171 | 2020-12-19 | White | Tennessee | 47185 | 2461 | 36 |
845172 | 845172 | 2020-12-19 | Williamson | Tennessee | 47187 | 15284 | 108 |
845173 | 845173 | 2020-12-19 | Wilson | Tennessee | 47189 | 10770 | 109 |
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);