ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

96 rows where "date" is on date 2022-05-13 and state = "Tennessee" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Tennessee · 96 ✖
Link rowid date ▲ county state fips cases deaths
2502111 2502111 2022-05-13 Anderson Tennessee 47001 22228 334
2502112 2502112 2022-05-13 Bedford Tennessee 47003 15004 237
2502113 2502113 2022-05-13 Benton Tennessee 47005 4533 93
2502114 2502114 2022-05-13 Bledsoe Tennessee 47007 4669 57
2502115 2502115 2022-05-13 Blount Tennessee 47009 39310 440
2502116 2502116 2022-05-13 Bradley Tennessee 47011 33188 415
2502117 2502117 2022-05-13 Campbell Tennessee 47013 12310 169
2502118 2502118 2022-05-13 Cannon Tennessee 47015 4227 63
2502119 2502119 2022-05-13 Carroll Tennessee 47017 8978 156
2502120 2502120 2022-05-13 Carter Tennessee 47019 16546 336
2502121 2502121 2022-05-13 Cheatham Tennessee 47021 10967 119
2502122 2502122 2022-05-13 Chester Tennessee 47023 5870 99
2502123 2502123 2022-05-13 Claiborne Tennessee 47025 9141 178
2502124 2502124 2022-05-13 Clay Tennessee 47027 2300 50
2502125 2502125 2022-05-13 Cocke Tennessee 47029 11634 217
2502126 2502126 2022-05-13 Coffee Tennessee 47031 16994 267
2502127 2502127 2022-05-13 Crockett Tennessee 47033 5199 85
2502128 2502128 2022-05-13 Cumberland Tennessee 47035 16171 327
2502129 2502129 2022-05-13 Davidson Tennessee 47037 210855 1676
2502130 2502130 2022-05-13 DeKalb Tennessee 47041 6288 101
2502131 2502131 2022-05-13 Decatur Tennessee 47039 3738 70
2502132 2502132 2022-05-13 Dickson Tennessee 47043 15987 245
2502133 2502133 2022-05-13 Dyer Tennessee 47045 12826 203
2502134 2502134 2022-05-13 Fayette Tennessee 47047 11475 186
2502135 2502135 2022-05-13 Fentress Tennessee 47049 5722 128
2502136 2502136 2022-05-13 Franklin Tennessee 47051 12908 184
2502137 2502137 2022-05-13 Gibson Tennessee 47053 17453 260
2502138 2502138 2022-05-13 Giles Tennessee 47055 9448 190
2502139 2502139 2022-05-13 Grainger Tennessee 47057 6793 109
2502140 2502140 2022-05-13 Greene Tennessee 47059 22140 374
2502141 2502141 2022-05-13 Grundy Tennessee 47061 3998 73
2502142 2502142 2022-05-13 Hamblen Tennessee 47063 19740 353
2502143 2502143 2022-05-13 Hamilton Tennessee 47065 101119 1151
2502144 2502144 2022-05-13 Hancock Tennessee 47067 2023 37
2502145 2502145 2022-05-13 Hardeman Tennessee 47069 7606 116
2502146 2502146 2022-05-13 Hardin Tennessee 47071 8765 145
2502147 2502147 2022-05-13 Hawkins Tennessee 47073 16702 321
2502148 2502148 2022-05-13 Haywood Tennessee 47075 6191 102
2502149 2502149 2022-05-13 Henderson Tennessee 47077 9150 160
2502150 2502150 2022-05-13 Henry Tennessee 47079 8310 163
2502151 2502151 2022-05-13 Hickman Tennessee 47081 6850 110
2502152 2502152 2022-05-13 Houston Tennessee 47083 2689 62
2502153 2502153 2022-05-13 Humphreys Tennessee 47085 4855 74
2502154 2502154 2022-05-13 Jackson Tennessee 47087 3211 63
2502155 2502155 2022-05-13 Jefferson Tennessee 47089 15804 265
2502156 2502156 2022-05-13 Johnson Tennessee 47091 5181 95
2502157 2502157 2022-05-13 Knox Tennessee 47093 128707 1385
2502158 2502158 2022-05-13 Lake Tennessee 47095 2749 43
2502159 2502159 2022-05-13 Lauderdale Tennessee 47097 7764 106
2502160 2502160 2022-05-13 Lawrence Tennessee 47099 14329 203
2502161 2502161 2022-05-13 Lewis Tennessee 47101 3573 60
2502162 2502162 2022-05-13 Lincoln Tennessee 47103 10003 170
2502163 2502163 2022-05-13 Loudon Tennessee 47105 14571 192
2502164 2502164 2022-05-13 Macon Tennessee 47111 8478 145
2502165 2502165 2022-05-13 Madison Tennessee 47113 30250 427
2502166 2502166 2022-05-13 Marion Tennessee 47115 8870 132
2502167 2502167 2022-05-13 Marshall Tennessee 47117 10403 124
2502168 2502168 2022-05-13 Maury Tennessee 47119 29162 345
2502169 2502169 2022-05-13 McMinn Tennessee 47107 16701 260
2502170 2502170 2022-05-13 McNairy Tennessee 47109 7662 120
2502171 2502171 2022-05-13 Meigs Tennessee 47121 3394 58
2502172 2502172 2022-05-13 Monroe Tennessee 47123 14681 244
2502173 2502173 2022-05-13 Montgomery Tennessee 47125 50488 579
2502174 2502174 2022-05-13 Moore Tennessee 47127 2239 40
2502175 2502175 2022-05-13 Morgan Tennessee 47129 6209 87
2502176 2502176 2022-05-13 Obion Tennessee 47131 10786 195
2502177 2502177 2022-05-13 Overton Tennessee 47133 7157 123
2502178 2502178 2022-05-13 Perry Tennessee 47135 2332 56
2502179 2502179 2022-05-13 Pickett Tennessee 47137 1774 36
2502180 2502180 2022-05-13 Polk Tennessee 47139 4740 74
2502181 2502181 2022-05-13 Putnam Tennessee 47141 25178 304
2502182 2502182 2022-05-13 Rhea Tennessee 47143 9994 160
2502183 2502183 2022-05-13 Roane Tennessee 47145 15839 234
2502184 2502184 2022-05-13 Robertson Tennessee 47147 21626 305
2502185 2502185 2022-05-13 Rutherford Tennessee 47149 96372 904
2502186 2502186 2022-05-13 Scott Tennessee 47151 9097 117
2502187 2502187 2022-05-13 Sequatchie Tennessee 47153 4226 69
2502188 2502188 2022-05-13 Sevier Tennessee 47155 30457 415
2502189 2502189 2022-05-13 Shelby Tennessee 47157 240841 3307
2502190 2502190 2022-05-13 Smith Tennessee 47159 6171 85
2502191 2502191 2022-05-13 Stewart Tennessee 47161 3294 59
2502192 2502192 2022-05-13 Sullivan Tennessee 47163 46163 721
2502193 2502193 2022-05-13 Sumner Tennessee 47165 53504 729
2502194 2502194 2022-05-13 Tipton Tennessee 47167 17674 236
2502195 2502195 2022-05-13 Trousdale Tennessee 47169 4238 45
2502196 2502196 2022-05-13 Unicoi Tennessee 47171 5191 96
2502197 2502197 2022-05-13 Union Tennessee 47173 5409 75
2502198 2502198 2022-05-13 Unknown Tennessee   19465 306
2502199 2502199 2022-05-13 Van Buren Tennessee 47175 1852 48
2502200 2502200 2022-05-13 Warren Tennessee 47177 13028 177
2502201 2502201 2022-05-13 Washington Tennessee 47179 38862 496
2502202 2502202 2022-05-13 Wayne Tennessee 47181 5700 72
2502203 2502203 2022-05-13 Weakley Tennessee 47183 9586 152
2502204 2502204 2022-05-13 White Tennessee 47185 8249 129
2502205 2502205 2022-05-13 Williamson Tennessee 47187 62833 406
2502206 2502206 2022-05-13 Wilson Tennessee 47189 41970 484

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);