ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-05-26" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1357990 | 1357990 | 2021-05-26 | Anderson | Tennessee | 47001 | 8823 | 172 |
1357991 | 1357991 | 2021-05-26 | Bedford | Tennessee | 47003 | 6547 | 130 |
1357992 | 1357992 | 2021-05-26 | Benton | Tennessee | 47005 | 1683 | 40 |
1357993 | 1357993 | 2021-05-26 | Bledsoe | Tennessee | 47007 | 2178 | 11 |
1357994 | 1357994 | 2021-05-26 | Blount | Tennessee | 47009 | 15617 | 196 |
1357995 | 1357995 | 2021-05-26 | Bradley | Tennessee | 47011 | 15187 | 152 |
1357996 | 1357996 | 2021-05-26 | Campbell | Tennessee | 47013 | 4200 | 63 |
1357997 | 1357997 | 2021-05-26 | Cannon | Tennessee | 47015 | 1935 | 31 |
1357998 | 1357998 | 2021-05-26 | Carroll | Tennessee | 47017 | 3654 | 84 |
1357999 | 1357999 | 2021-05-26 | Carter | Tennessee | 47019 | 6695 | 158 |
1358000 | 1358000 | 2021-05-26 | Cheatham | Tennessee | 47021 | 4604 | 56 |
1358001 | 1358001 | 2021-05-26 | Chester | Tennessee | 47023 | 2170 | 51 |
1358002 | 1358002 | 2021-05-26 | Claiborne | Tennessee | 47025 | 3196 | 74 |
1358003 | 1358003 | 2021-05-26 | Clay | Tennessee | 47027 | 1104 | 30 |
1358004 | 1358004 | 2021-05-26 | Cocke | Tennessee | 47029 | 4539 | 100 |
1358005 | 1358005 | 2021-05-26 | Coffee | Tennessee | 47031 | 6944 | 125 |
1358006 | 1358006 | 2021-05-26 | Crockett | Tennessee | 47033 | 2039 | 49 |
1358007 | 1358007 | 2021-05-26 | Cumberland | Tennessee | 47035 | 6812 | 133 |
1358008 | 1358008 | 2021-05-26 | Davidson | Tennessee | 47037 | 99209 | 948 |
1358009 | 1358009 | 2021-05-26 | DeKalb | Tennessee | 47041 | 2817 | 54 |
1358010 | 1358010 | 2021-05-26 | Decatur | Tennessee | 47039 | 1601 | 39 |
1358011 | 1358011 | 2021-05-26 | Dickson | Tennessee | 47043 | 6895 | 114 |
1358012 | 1358012 | 2021-05-26 | Dyer | Tennessee | 47045 | 5458 | 106 |
1358013 | 1358013 | 2021-05-26 | Fayette | Tennessee | 47047 | 5153 | 80 |
1358014 | 1358014 | 2021-05-26 | Fentress | Tennessee | 47049 | 2440 | 47 |
1358015 | 1358015 | 2021-05-26 | Franklin | Tennessee | 47051 | 5172 | 90 |
1358016 | 1358016 | 2021-05-26 | Gibson | Tennessee | 47053 | 6609 | 147 |
1358017 | 1358017 | 2021-05-26 | Giles | Tennessee | 47055 | 4026 | 101 |
1358018 | 1358018 | 2021-05-26 | Grainger | Tennessee | 47057 | 2653 | 50 |
1358019 | 1358019 | 2021-05-26 | Greene | Tennessee | 47059 | 7961 | 157 |
1358020 | 1358020 | 2021-05-26 | Grundy | Tennessee | 47061 | 1793 | 35 |
1358021 | 1358021 | 2021-05-26 | Hamblen | Tennessee | 47063 | 8642 | 174 |
1358022 | 1358022 | 2021-05-26 | Hamilton | Tennessee | 47065 | 45071 | 499 |
1358023 | 1358023 | 2021-05-26 | Hancock | Tennessee | 47067 | 602 | 12 |
1358024 | 1358024 | 2021-05-26 | Hardeman | Tennessee | 47069 | 3550 | 64 |
1358025 | 1358025 | 2021-05-26 | Hardin | Tennessee | 47071 | 3588 | 68 |
1358026 | 1358026 | 2021-05-26 | Hawkins | Tennessee | 47073 | 6265 | 110 |
1358027 | 1358027 | 2021-05-26 | Haywood | Tennessee | 47075 | 2715 | 62 |
1358028 | 1358028 | 2021-05-26 | Henderson | Tennessee | 47077 | 3823 | 76 |
1358029 | 1358029 | 2021-05-26 | Henry | Tennessee | 47079 | 3232 | 76 |
1358030 | 1358030 | 2021-05-26 | Hickman | Tennessee | 47081 | 2863 | 46 |
1358031 | 1358031 | 2021-05-26 | Houston | Tennessee | 47083 | 1103 | 33 |
1358032 | 1358032 | 2021-05-26 | Humphreys | Tennessee | 47085 | 1851 | 28 |
1358033 | 1358033 | 2021-05-26 | Jackson | Tennessee | 47087 | 1326 | 36 |
1358034 | 1358034 | 2021-05-26 | Jefferson | Tennessee | 47089 | 6281 | 125 |
1358035 | 1358035 | 2021-05-26 | Johnson | Tennessee | 47091 | 2434 | 39 |
1358036 | 1358036 | 2021-05-26 | Knox | Tennessee | 47093 | 52004 | 639 |
1358037 | 1358037 | 2021-05-26 | Lake | Tennessee | 47095 | 1711 | 26 |
1358038 | 1358038 | 2021-05-26 | Lauderdale | Tennessee | 47097 | 3231 | 47 |
1358039 | 1358039 | 2021-05-26 | Lawrence | Tennessee | 47099 | 6022 | 92 |
1358040 | 1358040 | 2021-05-26 | Lewis | Tennessee | 47101 | 1589 | 26 |
1358041 | 1358041 | 2021-05-26 | Lincoln | Tennessee | 47103 | 4373 | 64 |
1358042 | 1358042 | 2021-05-26 | Loudon | Tennessee | 47105 | 6217 | 70 |
1358043 | 1358043 | 2021-05-26 | Macon | Tennessee | 47111 | 3639 | 78 |
1358044 | 1358044 | 2021-05-26 | Madison | Tennessee | 47113 | 11337 | 241 |
1358045 | 1358045 | 2021-05-26 | Marion | Tennessee | 47115 | 3148 | 47 |
1358046 | 1358046 | 2021-05-26 | Marshall | Tennessee | 47117 | 4211 | 58 |
1358047 | 1358047 | 2021-05-26 | Maury | Tennessee | 47119 | 13593 | 173 |
1358048 | 1358048 | 2021-05-26 | McMinn | Tennessee | 47107 | 6579 | 99 |
1358049 | 1358049 | 2021-05-26 | McNairy | Tennessee | 47109 | 2857 | 54 |
1358050 | 1358050 | 2021-05-26 | Meigs | Tennessee | 47121 | 1400 | 25 |
1358051 | 1358051 | 2021-05-26 | Monroe | Tennessee | 47123 | 5914 | 96 |
1358052 | 1358052 | 2021-05-26 | Montgomery | Tennessee | 47125 | 20666 | 228 |
1358053 | 1358053 | 2021-05-26 | Moore | Tennessee | 47127 | 1020 | 17 |
1358054 | 1358054 | 2021-05-26 | Morgan | Tennessee | 47129 | 2524 | 39 |
1358055 | 1358055 | 2021-05-26 | Obion | Tennessee | 47131 | 4580 | 96 |
1358056 | 1358056 | 2021-05-26 | Overton | Tennessee | 47133 | 3032 | 61 |
1358057 | 1358057 | 2021-05-26 | Perry | Tennessee | 47135 | 1073 | 28 |
1358058 | 1358058 | 2021-05-26 | Pickett | Tennessee | 47137 | 763 | 24 |
1358059 | 1358059 | 2021-05-26 | Polk | Tennessee | 47139 | 2104 | 25 |
1358060 | 1358060 | 2021-05-26 | Putnam | Tennessee | 47141 | 11472 | 175 |
1358061 | 1358061 | 2021-05-26 | Rhea | Tennessee | 47143 | 4374 | 75 |
1358062 | 1358062 | 2021-05-26 | Roane | Tennessee | 47145 | 6346 | 105 |
1358063 | 1358063 | 2021-05-26 | Robertson | Tennessee | 47147 | 9834 | 132 |
1358064 | 1358064 | 2021-05-26 | Rutherford | Tennessee | 47149 | 43422 | 442 |
1358065 | 1358065 | 2021-05-26 | Scott | Tennessee | 47151 | 3185 | 45 |
1358066 | 1358066 | 2021-05-26 | Sequatchie | Tennessee | 47153 | 1736 | 29 |
1358067 | 1358067 | 2021-05-26 | Sevier | Tennessee | 47155 | 13486 | 176 |
1358068 | 1358068 | 2021-05-26 | Shelby | Tennessee | 47157 | 98465 | 1671 |
1358069 | 1358069 | 2021-05-26 | Smith | Tennessee | 47159 | 2790 | 39 |
1358070 | 1358070 | 2021-05-26 | Stewart | Tennessee | 47161 | 1358 | 28 |
1358071 | 1358071 | 2021-05-26 | Sullivan | Tennessee | 47163 | 17139 | 302 |
1358072 | 1358072 | 2021-05-26 | Sumner | Tennessee | 47165 | 24290 | 349 |
1358073 | 1358073 | 2021-05-26 | Tipton | Tennessee | 47167 | 7443 | 104 |
1358074 | 1358074 | 2021-05-26 | Trousdale | Tennessee | 47169 | 2509 | 22 |
1358075 | 1358075 | 2021-05-26 | Unicoi | Tennessee | 47171 | 2051 | 49 |
1358076 | 1358076 | 2021-05-26 | Union | Tennessee | 47173 | 1940 | 34 |
1358077 | 1358077 | 2021-05-26 | Unknown | Tennessee | 9563 | 124 | |
1358078 | 1358078 | 2021-05-26 | Van Buren | Tennessee | 47175 | 858 | 23 |
1358079 | 1358079 | 2021-05-26 | Warren | Tennessee | 47177 | 5553 | 82 |
1358080 | 1358080 | 2021-05-26 | Washington | Tennessee | 47179 | 14774 | 248 |
1358081 | 1358081 | 2021-05-26 | Wayne | Tennessee | 47181 | 2976 | 34 |
1358082 | 1358082 | 2021-05-26 | Weakley | Tennessee | 47183 | 4190 | 67 |
1358083 | 1358083 | 2021-05-26 | White | Tennessee | 47185 | 3708 | 71 |
1358084 | 1358084 | 2021-05-26 | Williamson | Tennessee | 47187 | 28240 | 217 |
1358085 | 1358085 | 2021-05-26 | Wilson | Tennessee | 47189 | 18999 | 239 |
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);