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-10-02 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
592010 | 592010 | 2020-10-02 | Anderson | Tennessee | 47001 | 1248 | 13 |
592011 | 592011 | 2020-10-02 | Bedford | Tennessee | 47003 | 1392 | 17 |
592012 | 592012 | 2020-10-02 | Benton | Tennessee | 47005 | 343 | 8 |
592013 | 592013 | 2020-10-02 | Bledsoe | Tennessee | 47007 | 867 | 4 |
592014 | 592014 | 2020-10-02 | Blount | Tennessee | 47009 | 2629 | 27 |
592015 | 592015 | 2020-10-02 | Bradley | Tennessee | 47011 | 3009 | 17 |
592016 | 592016 | 2020-10-02 | Campbell | Tennessee | 47013 | 483 | 4 |
592017 | 592017 | 2020-10-02 | Cannon | Tennessee | 47015 | 310 | 1 |
592018 | 592018 | 2020-10-02 | Carroll | Tennessee | 47017 | 941 | 20 |
592019 | 592019 | 2020-10-02 | Carter | Tennessee | 47019 | 1206 | 28 |
592020 | 592020 | 2020-10-02 | Cheatham | Tennessee | 47021 | 836 | 9 |
592021 | 592021 | 2020-10-02 | Chester | Tennessee | 47023 | 659 | 12 |
592022 | 592022 | 2020-10-02 | Claiborne | Tennessee | 47025 | 452 | 5 |
592023 | 592023 | 2020-10-02 | Clay | Tennessee | 47027 | 246 | 6 |
592024 | 592024 | 2020-10-02 | Cocke | Tennessee | 47029 | 774 | 10 |
592025 | 592025 | 2020-10-02 | Coffee | Tennessee | 47031 | 1330 | 14 |
592026 | 592026 | 2020-10-02 | Crockett | Tennessee | 47033 | 566 | 19 |
592027 | 592027 | 2020-10-02 | Cumberland | Tennessee | 47035 | 1246 | 19 |
592028 | 592028 | 2020-10-02 | Davidson | Tennessee | 47037 | 29136 | 313 |
592029 | 592029 | 2020-10-02 | DeKalb | Tennessee | 47041 | 579 | 14 |
592030 | 592030 | 2020-10-02 | Decatur | Tennessee | 47039 | 548 | 7 |
592031 | 592031 | 2020-10-02 | Dickson | Tennessee | 47043 | 1314 | 17 |
592032 | 592032 | 2020-10-02 | Dyer | Tennessee | 47045 | 1476 | 18 |
592033 | 592033 | 2020-10-02 | Fayette | Tennessee | 47047 | 1241 | 21 |
592034 | 592034 | 2020-10-02 | Fentress | Tennessee | 47049 | 605 | 4 |
592035 | 592035 | 2020-10-02 | Franklin | Tennessee | 47051 | 1022 | 10 |
592036 | 592036 | 2020-10-02 | Gibson | Tennessee | 47053 | 1785 | 25 |
592037 | 592037 | 2020-10-02 | Giles | Tennessee | 47055 | 672 | 19 |
592038 | 592038 | 2020-10-02 | Grainger | Tennessee | 47057 | 411 | 3 |
592039 | 592039 | 2020-10-02 | Greene | Tennessee | 47059 | 1198 | 46 |
592040 | 592040 | 2020-10-02 | Grundy | Tennessee | 47061 | 352 | 6 |
592041 | 592041 | 2020-10-02 | Hamblen | Tennessee | 47063 | 1999 | 31 |
592042 | 592042 | 2020-10-02 | Hamilton | Tennessee | 47065 | 9936 | 98 |
592043 | 592043 | 2020-10-02 | Hancock | Tennessee | 47067 | 110 | 3 |
592044 | 592044 | 2020-10-02 | Hardeman | Tennessee | 47069 | 1602 | 27 |
592045 | 592045 | 2020-10-02 | Hardin | Tennessee | 47071 | 1096 | 16 |
592046 | 592046 | 2020-10-02 | Hawkins | Tennessee | 47073 | 860 | 22 |
592047 | 592047 | 2020-10-02 | Haywood | Tennessee | 47075 | 1028 | 23 |
592048 | 592048 | 2020-10-02 | Henderson | Tennessee | 47077 | 1209 | 24 |
592049 | 592049 | 2020-10-02 | Henry | Tennessee | 47079 | 645 | 10 |
592050 | 592050 | 2020-10-02 | Hickman | Tennessee | 47081 | 630 | 8 |
592051 | 592051 | 2020-10-02 | Houston | Tennessee | 47083 | 284 | 4 |
592052 | 592052 | 2020-10-02 | Humphreys | Tennessee | 47085 | 288 | 3 |
592053 | 592053 | 2020-10-02 | Jackson | Tennessee | 47087 | 347 | 5 |
592054 | 592054 | 2020-10-02 | Jefferson | Tennessee | 47089 | 1189 | 14 |
592055 | 592055 | 2020-10-02 | Johnson | Tennessee | 47091 | 764 | 3 |
592056 | 592056 | 2020-10-02 | Knox | Tennessee | 47093 | 10461 | 84 |
592057 | 592057 | 2020-10-02 | Lake | Tennessee | 47095 | 928 | 2 |
592058 | 592058 | 2020-10-02 | Lauderdale | Tennessee | 47097 | 1031 | 16 |
592059 | 592059 | 2020-10-02 | Lawrence | Tennessee | 47099 | 1130 | 14 |
592060 | 592060 | 2020-10-02 | Lewis | Tennessee | 47101 | 220 | 1 |
592061 | 592061 | 2020-10-02 | Lincoln | Tennessee | 47103 | 655 | 1 |
592062 | 592062 | 2020-10-02 | Loudon | Tennessee | 47105 | 1249 | 7 |
592063 | 592063 | 2020-10-02 | Macon | Tennessee | 47111 | 1082 | 21 |
592064 | 592064 | 2020-10-02 | Madison | Tennessee | 47113 | 3109 | 69 |
592065 | 592065 | 2020-10-02 | Marion | Tennessee | 47115 | 563 | 9 |
592066 | 592066 | 2020-10-02 | Marshall | Tennessee | 47117 | 807 | 5 |
592067 | 592067 | 2020-10-02 | Maury | Tennessee | 47119 | 2486 | 28 |
592068 | 592068 | 2020-10-02 | McMinn | Tennessee | 47107 | 1186 | 26 |
592069 | 592069 | 2020-10-02 | McNairy | Tennessee | 47109 | 946 | 19 |
592070 | 592070 | 2020-10-02 | Meigs | Tennessee | 47121 | 234 | 3 |
592071 | 592071 | 2020-10-02 | Monroe | Tennessee | 47123 | 1101 | 20 |
592072 | 592072 | 2020-10-02 | Montgomery | Tennessee | 47125 | 3205 | 46 |
592073 | 592073 | 2020-10-02 | Moore | Tennessee | 47127 | 189 | 1 |
592074 | 592074 | 2020-10-02 | Morgan | Tennessee | 47129 | 330 | 4 |
592075 | 592075 | 2020-10-02 | Obion | Tennessee | 47131 | 1262 | 14 |
592076 | 592076 | 2020-10-02 | Overton | Tennessee | 47133 | 801 | 7 |
592077 | 592077 | 2020-10-02 | Perry | Tennessee | 47135 | 154 | 0 |
592078 | 592078 | 2020-10-02 | Pickett | Tennessee | 47137 | 132 | 2 |
592079 | 592079 | 2020-10-02 | Polk | Tennessee | 47139 | 414 | 11 |
592080 | 592080 | 2020-10-02 | Putnam | Tennessee | 47141 | 3443 | 48 |
592081 | 592081 | 2020-10-02 | Rhea | Tennessee | 47143 | 878 | 15 |
592082 | 592082 | 2020-10-02 | Roane | Tennessee | 47145 | 936 | 6 |
592083 | 592083 | 2020-10-02 | Robertson | Tennessee | 47147 | 2272 | 39 |
592084 | 592084 | 2020-10-02 | Rutherford | Tennessee | 47149 | 9624 | 96 |
592085 | 592085 | 2020-10-02 | Scott | Tennessee | 47151 | 236 | 2 |
592086 | 592086 | 2020-10-02 | Sequatchie | Tennessee | 47153 | 249 | 3 |
592087 | 592087 | 2020-10-02 | Sevier | Tennessee | 47155 | 2715 | 16 |
592088 | 592088 | 2020-10-02 | Shelby | Tennessee | 47157 | 31771 | 480 |
592089 | 592089 | 2020-10-02 | Smith | Tennessee | 47159 | 763 | 11 |
592090 | 592090 | 2020-10-02 | Stewart | Tennessee | 47161 | 226 | 3 |
592091 | 592091 | 2020-10-02 | Sullivan | Tennessee | 47163 | 2324 | 33 |
592092 | 592092 | 2020-10-02 | Sumner | Tennessee | 47165 | 4989 | 102 |
592093 | 592093 | 2020-10-02 | Tipton | Tennessee | 47167 | 1878 | 20 |
592094 | 592094 | 2020-10-02 | Trousdale | Tennessee | 47169 | 1682 | 7 |
592095 | 592095 | 2020-10-02 | Unicoi | Tennessee | 47171 | 293 | 1 |
592096 | 592096 | 2020-10-02 | Union | Tennessee | 47173 | 395 | 2 |
592097 | 592097 | 2020-10-02 | Van Buren | Tennessee | 47175 | 168 | 0 |
592098 | 592098 | 2020-10-02 | Warren | Tennessee | 47177 | 1093 | 7 |
592099 | 592099 | 2020-10-02 | Washington | Tennessee | 47179 | 2435 | 38 |
592100 | 592100 | 2020-10-02 | Wayne | Tennessee | 47181 | 1513 | 5 |
592101 | 592101 | 2020-10-02 | Weakley | Tennessee | 47183 | 1252 | 21 |
592102 | 592102 | 2020-10-02 | White | Tennessee | 47185 | 876 | 10 |
592103 | 592103 | 2020-10-02 | Williamson | Tennessee | 47187 | 5478 | 38 |
592104 | 592104 | 2020-10-02 | Wilson | Tennessee | 47189 | 3653 | 49 |
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);