ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-06-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 |
---|---|---|---|---|---|---|---|
255006 | 255006 | 2020-06-19 | Anderson | Tennessee | 47001 | 74 | 2 |
255007 | 255007 | 2020-06-19 | Bedford | Tennessee | 47003 | 416 | 4 |
255008 | 255008 | 2020-06-19 | Benton | Tennessee | 47005 | 8 | 1 |
255009 | 255009 | 2020-06-19 | Bledsoe | Tennessee | 47007 | 614 | 1 |
255010 | 255010 | 2020-06-19 | Blount | Tennessee | 47009 | 119 | 3 |
255011 | 255011 | 2020-06-19 | Bradley | Tennessee | 47011 | 314 | 2 |
255012 | 255012 | 2020-06-19 | Campbell | Tennessee | 47013 | 26 | 1 |
255013 | 255013 | 2020-06-19 | Cannon | Tennessee | 47015 | 34 | 0 |
255014 | 255014 | 2020-06-19 | Carroll | Tennessee | 47017 | 36 | 1 |
255015 | 255015 | 2020-06-19 | Carter | Tennessee | 47019 | 27 | 1 |
255016 | 255016 | 2020-06-19 | Cheatham | Tennessee | 47021 | 164 | 0 |
255017 | 255017 | 2020-06-19 | Chester | Tennessee | 47023 | 14 | 0 |
255018 | 255018 | 2020-06-19 | Claiborne | Tennessee | 47025 | 16 | 0 |
255019 | 255019 | 2020-06-19 | Clay | Tennessee | 47027 | 13 | 0 |
255020 | 255020 | 2020-06-19 | Cocke | Tennessee | 47029 | 27 | 0 |
255021 | 255021 | 2020-06-19 | Coffee | Tennessee | 47031 | 99 | 0 |
255022 | 255022 | 2020-06-19 | Crockett | Tennessee | 47033 | 25 | 3 |
255023 | 255023 | 2020-06-19 | Cumberland | Tennessee | 47035 | 137 | 3 |
255024 | 255024 | 2020-06-19 | Davidson | Tennessee | 47037 | 7707 | 93 |
255025 | 255025 | 2020-06-19 | DeKalb | Tennessee | 47041 | 41 | 0 |
255026 | 255026 | 2020-06-19 | Decatur | Tennessee | 47039 | 15 | 0 |
255027 | 255027 | 2020-06-19 | Dickson | Tennessee | 47043 | 145 | 0 |
255028 | 255028 | 2020-06-19 | Dyer | Tennessee | 47045 | 141 | 0 |
255029 | 255029 | 2020-06-19 | Fayette | Tennessee | 47047 | 193 | 2 |
255030 | 255030 | 2020-06-19 | Fentress | Tennessee | 47049 | 15 | 0 |
255031 | 255031 | 2020-06-19 | Franklin | Tennessee | 47051 | 65 | 2 |
255032 | 255032 | 2020-06-19 | Gibson | Tennessee | 47053 | 74 | 1 |
255033 | 255033 | 2020-06-19 | Giles | Tennessee | 47055 | 24 | 0 |
255034 | 255034 | 2020-06-19 | Grainger | Tennessee | 47057 | 25 | 0 |
255035 | 255035 | 2020-06-19 | Greene | Tennessee | 47059 | 55 | 2 |
255036 | 255036 | 2020-06-19 | Grundy | Tennessee | 47061 | 39 | 1 |
255037 | 255037 | 2020-06-19 | Hamblen | Tennessee | 47063 | 96 | 4 |
255038 | 255038 | 2020-06-19 | Hamilton | Tennessee | 47065 | 2102 | 25 |
255039 | 255039 | 2020-06-19 | Hancock | Tennessee | 47067 | 2 | 0 |
255040 | 255040 | 2020-06-19 | Hardeman | Tennessee | 47069 | 252 | 1 |
255041 | 255041 | 2020-06-19 | Hardin | Tennessee | 47071 | 51 | 5 |
255042 | 255042 | 2020-06-19 | Hawkins | Tennessee | 47073 | 38 | 2 |
255043 | 255043 | 2020-06-19 | Haywood | Tennessee | 47075 | 40 | 2 |
255044 | 255044 | 2020-06-19 | Henderson | Tennessee | 47077 | 19 | 0 |
255045 | 255045 | 2020-06-19 | Henry | Tennessee | 47079 | 36 | 0 |
255046 | 255046 | 2020-06-19 | Hickman | Tennessee | 47081 | 63 | 0 |
255047 | 255047 | 2020-06-19 | Houston | Tennessee | 47083 | 10 | 0 |
255048 | 255048 | 2020-06-19 | Humphreys | Tennessee | 47085 | 18 | 1 |
255049 | 255049 | 2020-06-19 | Jackson | Tennessee | 47087 | 21 | 0 |
255050 | 255050 | 2020-06-19 | Jefferson | Tennessee | 47089 | 59 | 0 |
255051 | 255051 | 2020-06-19 | Johnson | Tennessee | 47091 | 26 | 0 |
255052 | 255052 | 2020-06-19 | Knox | Tennessee | 47093 | 658 | 5 |
255053 | 255053 | 2020-06-19 | Lake | Tennessee | 47095 | 689 | 0 |
255054 | 255054 | 2020-06-19 | Lauderdale | Tennessee | 47097 | 71 | 1 |
255055 | 255055 | 2020-06-19 | Lawrence | Tennessee | 47099 | 78 | 2 |
255056 | 255056 | 2020-06-19 | Lewis | Tennessee | 47101 | 5 | 0 |
255057 | 255057 | 2020-06-19 | Lincoln | Tennessee | 47103 | 48 | 0 |
255058 | 255058 | 2020-06-19 | Loudon | Tennessee | 47105 | 226 | 1 |
255059 | 255059 | 2020-06-19 | Macon | Tennessee | 47111 | 217 | 3 |
255060 | 255060 | 2020-06-19 | Madison | Tennessee | 47113 | 190 | 2 |
255061 | 255061 | 2020-06-19 | Marion | Tennessee | 47115 | 48 | 2 |
255062 | 255062 | 2020-06-19 | Marshall | Tennessee | 47117 | 44 | 1 |
255063 | 255063 | 2020-06-19 | Maury | Tennessee | 47119 | 205 | 2 |
255064 | 255064 | 2020-06-19 | McMinn | Tennessee | 47107 | 172 | 15 |
255065 | 255065 | 2020-06-19 | McNairy | Tennessee | 47109 | 38 | 0 |
255066 | 255066 | 2020-06-19 | Meigs | Tennessee | 47121 | 30 | 0 |
255067 | 255067 | 2020-06-19 | Monroe | Tennessee | 47123 | 108 | 4 |
255068 | 255068 | 2020-06-19 | Montgomery | Tennessee | 47125 | 363 | 5 |
255069 | 255069 | 2020-06-19 | Moore | Tennessee | 47127 | 5 | 0 |
255070 | 255070 | 2020-06-19 | Morgan | Tennessee | 47129 | 22 | 1 |
255071 | 255071 | 2020-06-19 | Obion | Tennessee | 47131 | 71 | 1 |
255072 | 255072 | 2020-06-19 | Overton | Tennessee | 47133 | 40 | 0 |
255073 | 255073 | 2020-06-19 | Perry | Tennessee | 47135 | 28 | 0 |
255074 | 255074 | 2020-06-19 | Pickett | Tennessee | 47137 | 4 | 0 |
255075 | 255075 | 2020-06-19 | Polk | Tennessee | 47139 | 32 | 0 |
255076 | 255076 | 2020-06-19 | Putnam | Tennessee | 47141 | 643 | 7 |
255077 | 255077 | 2020-06-19 | Rhea | Tennessee | 47143 | 247 | 0 |
255078 | 255078 | 2020-06-19 | Roane | Tennessee | 47145 | 34 | 0 |
255079 | 255079 | 2020-06-19 | Robertson | Tennessee | 47147 | 703 | 9 |
255080 | 255080 | 2020-06-19 | Rutherford | Tennessee | 47149 | 1990 | 32 |
255081 | 255081 | 2020-06-19 | Scott | Tennessee | 47151 | 15 | 0 |
255082 | 255082 | 2020-06-19 | Sequatchie | Tennessee | 47153 | 22 | 0 |
255083 | 255083 | 2020-06-19 | Sevier | Tennessee | 47155 | 387 | 3 |
255084 | 255084 | 2020-06-19 | Shelby | Tennessee | 47157 | 7623 | 160 |
255085 | 255085 | 2020-06-19 | Smith | Tennessee | 47159 | 48 | 1 |
255086 | 255086 | 2020-06-19 | Stewart | Tennessee | 47161 | 17 | 0 |
255087 | 255087 | 2020-06-19 | Sullivan | Tennessee | 47163 | 72 | 2 |
255088 | 255088 | 2020-06-19 | Sumner | Tennessee | 47165 | 1155 | 49 |
255089 | 255089 | 2020-06-19 | Tipton | Tennessee | 47167 | 551 | 4 |
255090 | 255090 | 2020-06-19 | Trousdale | Tennessee | 47169 | 1464 | 5 |
255091 | 255091 | 2020-06-19 | Unicoi | Tennessee | 47171 | 52 | 0 |
255092 | 255092 | 2020-06-19 | Union | Tennessee | 47173 | 9 | 0 |
255093 | 255093 | 2020-06-19 | Van Buren | Tennessee | 47175 | 5 | 0 |
255094 | 255094 | 2020-06-19 | Warren | Tennessee | 47177 | 36 | 0 |
255095 | 255095 | 2020-06-19 | Washington | Tennessee | 47179 | 101 | 0 |
255096 | 255096 | 2020-06-19 | Wayne | Tennessee | 47181 | 64 | 0 |
255097 | 255097 | 2020-06-19 | Weakley | Tennessee | 47183 | 39 | 0 |
255098 | 255098 | 2020-06-19 | White | Tennessee | 47185 | 52 | 2 |
255099 | 255099 | 2020-06-19 | Williamson | Tennessee | 47187 | 767 | 12 |
255100 | 255100 | 2020-06-19 | Wilson | Tennessee | 47189 | 580 | 14 |
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);