ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74,719 rows where state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 47187 355
- 47037 352
- 47157 352
- 47163 350
- 47093 348
- 47065 347
- 47089 347
- 47149 347
- 47013 346
- 47155 344
- 47021 342
- 47147 342
- 47165 342
- 47035 341
- 47045 341
- 47125 341
- 47179 341
- 47189 341
- 47001 340
- 47009 340
- 47011 340
- 47043 340
- 47059 340
- 47063 340
- 47119 340
- 47167 340
- 47017 339
- 47029 339
- 47047 339
- 47123 339
- …
county >30
- Williamson 355
- Davidson 352
- Shelby 352
- Sullivan 350
- Knox 348
- Hamilton 347
- Jefferson 347
- Rutherford 347
- Campbell 346
- Sevier 344
- Cheatham 342
- Robertson 342
- Sumner 342
- Cumberland 341
- Dyer 341
- Montgomery 341
- Washington 341
- Wilson 341
- Anderson 340
- Blount 340
- Bradley 340
- Dickson 340
- Greene 340
- Hamblen 340
- Maury 340
- Tipton 340
- Carroll 339
- Cocke 339
- Fayette 339
- Monroe 339
- …
state 1
- Tennessee · 31,999 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056032 | 1056032 | 2021-02-22 | Anderson | Tennessee | 47001 | 7863 | 153 |
1056033 | 1056033 | 2021-02-22 | Bedford | Tennessee | 47003 | 5738 | 117 |
1056034 | 1056034 | 2021-02-22 | Benton | Tennessee | 47005 | 1499 | 39 |
1056035 | 1056035 | 2021-02-22 | Bledsoe | Tennessee | 47007 | 1977 | 10 |
1056036 | 1056036 | 2021-02-22 | Blount | Tennessee | 47009 | 13880 | 175 |
1056037 | 1056037 | 2021-02-22 | Bradley | Tennessee | 47011 | 12654 | 137 |
1056038 | 1056038 | 2021-02-22 | Campbell | Tennessee | 47013 | 3760 | 58 |
1056039 | 1056039 | 2021-02-22 | Cannon | Tennessee | 47015 | 1733 | 28 |
1056040 | 1056040 | 2021-02-22 | Carroll | Tennessee | 47017 | 3459 | 80 |
1056041 | 1056041 | 2021-02-22 | Carter | Tennessee | 47019 | 5910 | 151 |
1056042 | 1056042 | 2021-02-22 | Cheatham | Tennessee | 47021 | 3840 | 43 |
1056043 | 1056043 | 2021-02-22 | Chester | Tennessee | 47023 | 2004 | 46 |
1056044 | 1056044 | 2021-02-22 | Claiborne | Tennessee | 47025 | 2709 | 64 |
1056045 | 1056045 | 2021-02-22 | Clay | Tennessee | 47027 | 1056 | 30 |
1056046 | 1056046 | 2021-02-22 | Cocke | Tennessee | 47029 | 3951 | 91 |
1056047 | 1056047 | 2021-02-22 | Coffee | Tennessee | 47031 | 6235 | 114 |
1056048 | 1056048 | 2021-02-22 | Crockett | Tennessee | 47033 | 1967 | 46 |
1056049 | 1056049 | 2021-02-22 | Cumberland | Tennessee | 47035 | 6058 | 116 |
1056050 | 1056050 | 2021-02-22 | Davidson | Tennessee | 47037 | 88849 | 833 |
1056051 | 1056051 | 2021-02-22 | DeKalb | Tennessee | 47041 | 2610 | 47 |
1056052 | 1056052 | 2021-02-22 | Decatur | Tennessee | 47039 | 1531 | 35 |
1056053 | 1056053 | 2021-02-22 | Dickson | Tennessee | 47043 | 6103 | 102 |
1056054 | 1056054 | 2021-02-22 | Dyer | Tennessee | 47045 | 5220 | 99 |
1056055 | 1056055 | 2021-02-22 | Fayette | Tennessee | 47047 | 4631 | 71 |
1056056 | 1056056 | 2021-02-22 | Fentress | Tennessee | 47049 | 2281 | 43 |
1056057 | 1056057 | 2021-02-22 | Franklin | Tennessee | 47051 | 4684 | 80 |
1056058 | 1056058 | 2021-02-22 | Gibson | Tennessee | 47053 | 6153 | 139 |
1056059 | 1056059 | 2021-02-22 | Giles | Tennessee | 47055 | 3695 | 95 |
1056060 | 1056060 | 2021-02-22 | Grainger | Tennessee | 47057 | 2399 | 46 |
1056061 | 1056061 | 2021-02-22 | Greene | Tennessee | 47059 | 7249 | 143 |
1056062 | 1056062 | 2021-02-22 | Grundy | Tennessee | 47061 | 1654 | 29 |
1056063 | 1056063 | 2021-02-22 | Hamblen | Tennessee | 47063 | 7919 | 160 |
1056064 | 1056064 | 2021-02-22 | Hamilton | Tennessee | 47065 | 40118 | 449 |
1056065 | 1056065 | 2021-02-22 | Hancock | Tennessee | 47067 | 490 | 11 |
1056066 | 1056066 | 2021-02-22 | Hardeman | Tennessee | 47069 | 3372 | 63 |
1056067 | 1056067 | 2021-02-22 | Hardin | Tennessee | 47071 | 3291 | 62 |
1056068 | 1056068 | 2021-02-22 | Hawkins | Tennessee | 47073 | 5150 | 92 |
1056069 | 1056069 | 2021-02-22 | Haywood | Tennessee | 47075 | 2639 | 59 |
1056070 | 1056070 | 2021-02-22 | Henderson | Tennessee | 47077 | 3603 | 71 |
1056071 | 1056071 | 2021-02-22 | Henry | Tennessee | 47079 | 2981 | 73 |
1056072 | 1056072 | 2021-02-22 | Hickman | Tennessee | 47081 | 2619 | 39 |
1056073 | 1056073 | 2021-02-22 | Houston | Tennessee | 47083 | 1020 | 30 |
1056074 | 1056074 | 2021-02-22 | Humphreys | Tennessee | 47085 | 1507 | 21 |
1056075 | 1056075 | 2021-02-22 | Jackson | Tennessee | 47087 | 1245 | 33 |
1056076 | 1056076 | 2021-02-22 | Jefferson | Tennessee | 47089 | 5557 | 116 |
1056077 | 1056077 | 2021-02-22 | Johnson | Tennessee | 47091 | 2139 | 37 |
1056078 | 1056078 | 2021-02-22 | Knox | Tennessee | 47093 | 46227 | 564 |
1056079 | 1056079 | 2021-02-22 | Lake | Tennessee | 47095 | 1671 | 26 |
1056080 | 1056080 | 2021-02-22 | Lauderdale | Tennessee | 47097 | 3086 | 42 |
1056081 | 1056081 | 2021-02-22 | Lawrence | Tennessee | 47099 | 5536 | 80 |
1056082 | 1056082 | 2021-02-22 | Lewis | Tennessee | 47101 | 1448 | 24 |
1056083 | 1056083 | 2021-02-22 | Lincoln | Tennessee | 47103 | 4097 | 61 |
1056084 | 1056084 | 2021-02-22 | Loudon | Tennessee | 47105 | 5597 | 64 |
1056085 | 1056085 | 2021-02-22 | Macon | Tennessee | 47111 | 3327 | 73 |
1056086 | 1056086 | 2021-02-22 | Madison | Tennessee | 47113 | 10015 | 225 |
1056087 | 1056087 | 2021-02-22 | Marion | Tennessee | 47115 | 2882 | 44 |
1056088 | 1056088 | 2021-02-22 | Marshall | Tennessee | 47117 | 3875 | 54 |
1056089 | 1056089 | 2021-02-22 | Maury | Tennessee | 47119 | 12099 | 158 |
1056090 | 1056090 | 2021-02-22 | McMinn | Tennessee | 47107 | 5839 | 89 |
1056091 | 1056091 | 2021-02-22 | McNairy | Tennessee | 47109 | 2635 | 50 |
1056092 | 1056092 | 2021-02-22 | Meigs | Tennessee | 47121 | 1251 | 20 |
1056093 | 1056093 | 2021-02-22 | Monroe | Tennessee | 47123 | 5228 | 88 |
1056094 | 1056094 | 2021-02-22 | Montgomery | Tennessee | 47125 | 17150 | 205 |
1056095 | 1056095 | 2021-02-22 | Moore | Tennessee | 47127 | 934 | 16 |
1056096 | 1056096 | 2021-02-22 | Morgan | Tennessee | 47129 | 2282 | 36 |
1056097 | 1056097 | 2021-02-22 | Obion | Tennessee | 47131 | 4353 | 92 |
1056098 | 1056098 | 2021-02-22 | Overton | Tennessee | 47133 | 2830 | 57 |
1056099 | 1056099 | 2021-02-22 | Perry | Tennessee | 47135 | 1023 | 27 |
1056100 | 1056100 | 2021-02-22 | Pickett | Tennessee | 47137 | 744 | 23 |
1056101 | 1056101 | 2021-02-22 | Polk | Tennessee | 47139 | 1725 | 21 |
1056102 | 1056102 | 2021-02-22 | Putnam | Tennessee | 47141 | 10500 | 167 |
1056103 | 1056103 | 2021-02-22 | Rhea | Tennessee | 47143 | 4111 | 72 |
1056104 | 1056104 | 2021-02-22 | Roane | Tennessee | 47145 | 5788 | 95 |
1056105 | 1056105 | 2021-02-22 | Robertson | Tennessee | 47147 | 8848 | 115 |
1056106 | 1056106 | 2021-02-22 | Rutherford | Tennessee | 47149 | 37705 | 370 |
1056107 | 1056107 | 2021-02-22 | Scott | Tennessee | 47151 | 2845 | 40 |
1056108 | 1056108 | 2021-02-22 | Sequatchie | Tennessee | 47153 | 1533 | 27 |
1056109 | 1056109 | 2021-02-22 | Sevier | Tennessee | 47155 | 11837 | 159 |
1056110 | 1056110 | 2021-02-22 | Shelby | Tennessee | 47157 | 87088 | 1460 |
1056111 | 1056111 | 2021-02-22 | Smith | Tennessee | 47159 | 2519 | 36 |
1056112 | 1056112 | 2021-02-22 | Stewart | Tennessee | 47161 | 1229 | 24 |
1056113 | 1056113 | 2021-02-22 | Sullivan | Tennessee | 47163 | 14122 | 271 |
1056114 | 1056114 | 2021-02-22 | Sumner | Tennessee | 47165 | 21081 | 312 |
1056115 | 1056115 | 2021-02-22 | Tipton | Tennessee | 47167 | 6871 | 99 |
1056116 | 1056116 | 2021-02-22 | Trousdale | Tennessee | 47169 | 2376 | 21 |
1056117 | 1056117 | 2021-02-22 | Unicoi | Tennessee | 47171 | 1787 | 47 |
1056118 | 1056118 | 2021-02-22 | Union | Tennessee | 47173 | 1675 | 30 |
1056119 | 1056119 | 2021-02-22 | Unknown | Tennessee | 8381 | 110 | |
1056120 | 1056120 | 2021-02-22 | Van Buren | Tennessee | 47175 | 788 | 20 |
1056121 | 1056121 | 2021-02-22 | Warren | Tennessee | 47177 | 5289 | 75 |
1056122 | 1056122 | 2021-02-22 | Washington | Tennessee | 47179 | 12641 | 230 |
1056123 | 1056123 | 2021-02-22 | Wayne | Tennessee | 47181 | 2862 | 30 |
1056124 | 1056124 | 2021-02-22 | Weakley | Tennessee | 47183 | 3769 | 59 |
1056125 | 1056125 | 2021-02-22 | White | Tennessee | 47185 | 3321 | 65 |
1056126 | 1056126 | 2021-02-22 | Williamson | Tennessee | 47187 | 24880 | 202 |
1056127 | 1056127 | 2021-02-22 | Wilson | Tennessee | 47189 | 16114 | 208 |
1052786 | 1052786 | 2021-02-21 | Anderson | Tennessee | 47001 | 7853 | 152 |
1052787 | 1052787 | 2021-02-21 | Bedford | Tennessee | 47003 | 5736 | 117 |
1052788 | 1052788 | 2021-02-21 | Benton | Tennessee | 47005 | 1499 | 39 |
1052789 | 1052789 | 2021-02-21 | Bledsoe | Tennessee | 47007 | 1980 | 10 |
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);