ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2021-05-15 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1322275 | 1322275 | 2021-05-15 | Anderson | Tennessee | 47001 | 8795 | 171 |
1322276 | 1322276 | 2021-05-15 | Bedford | Tennessee | 47003 | 6522 | 128 |
1322277 | 1322277 | 2021-05-15 | Benton | Tennessee | 47005 | 1673 | 40 |
1322278 | 1322278 | 2021-05-15 | Bledsoe | Tennessee | 47007 | 2158 | 11 |
1322279 | 1322279 | 2021-05-15 | Blount | Tennessee | 47009 | 15559 | 196 |
1322280 | 1322280 | 2021-05-15 | Bradley | Tennessee | 47011 | 15100 | 151 |
1322281 | 1322281 | 2021-05-15 | Campbell | Tennessee | 47013 | 4174 | 63 |
1322282 | 1322282 | 2021-05-15 | Cannon | Tennessee | 47015 | 1928 | 31 |
1322283 | 1322283 | 2021-05-15 | Carroll | Tennessee | 47017 | 3634 | 83 |
1322284 | 1322284 | 2021-05-15 | Carter | Tennessee | 47019 | 6662 | 158 |
1322285 | 1322285 | 2021-05-15 | Cheatham | Tennessee | 47021 | 4578 | 56 |
1322286 | 1322286 | 2021-05-15 | Chester | Tennessee | 47023 | 2154 | 51 |
1322287 | 1322287 | 2021-05-15 | Claiborne | Tennessee | 47025 | 3188 | 73 |
1322288 | 1322288 | 2021-05-15 | Clay | Tennessee | 47027 | 1103 | 30 |
1322289 | 1322289 | 2021-05-15 | Cocke | Tennessee | 47029 | 4524 | 99 |
1322290 | 1322290 | 2021-05-15 | Coffee | Tennessee | 47031 | 6922 | 123 |
1322291 | 1322291 | 2021-05-15 | Crockett | Tennessee | 47033 | 2035 | 49 |
1322292 | 1322292 | 2021-05-15 | Cumberland | Tennessee | 47035 | 6769 | 133 |
1322293 | 1322293 | 2021-05-15 | Davidson | Tennessee | 47037 | 98771 | 942 |
1322294 | 1322294 | 2021-05-15 | DeKalb | Tennessee | 47041 | 2807 | 54 |
1322295 | 1322295 | 2021-05-15 | Decatur | Tennessee | 47039 | 1593 | 39 |
1322296 | 1322296 | 2021-05-15 | Dickson | Tennessee | 47043 | 6854 | 113 |
1322297 | 1322297 | 2021-05-15 | Dyer | Tennessee | 47045 | 5440 | 106 |
1322298 | 1322298 | 2021-05-15 | Fayette | Tennessee | 47047 | 5118 | 78 |
1322299 | 1322299 | 2021-05-15 | Fentress | Tennessee | 47049 | 2430 | 47 |
1322300 | 1322300 | 2021-05-15 | Franklin | Tennessee | 47051 | 5164 | 90 |
1322301 | 1322301 | 2021-05-15 | Gibson | Tennessee | 47053 | 6542 | 146 |
1322302 | 1322302 | 2021-05-15 | Giles | Tennessee | 47055 | 4010 | 100 |
1322303 | 1322303 | 2021-05-15 | Grainger | Tennessee | 47057 | 2635 | 50 |
1322304 | 1322304 | 2021-05-15 | Greene | Tennessee | 47059 | 7928 | 156 |
1322305 | 1322305 | 2021-05-15 | Grundy | Tennessee | 47061 | 1795 | 34 |
1322306 | 1322306 | 2021-05-15 | Hamblen | Tennessee | 47063 | 8632 | 173 |
1322307 | 1322307 | 2021-05-15 | Hamilton | Tennessee | 47065 | 44774 | 496 |
1322308 | 1322308 | 2021-05-15 | Hancock | Tennessee | 47067 | 593 | 12 |
1322309 | 1322309 | 2021-05-15 | Hardeman | Tennessee | 47069 | 3537 | 64 |
1322310 | 1322310 | 2021-05-15 | Hardin | Tennessee | 47071 | 3589 | 68 |
1322311 | 1322311 | 2021-05-15 | Hawkins | Tennessee | 47073 | 6161 | 107 |
1322312 | 1322312 | 2021-05-15 | Haywood | Tennessee | 47075 | 2715 | 62 |
1322313 | 1322313 | 2021-05-15 | Henderson | Tennessee | 47077 | 3807 | 76 |
1322314 | 1322314 | 2021-05-15 | Henry | Tennessee | 47079 | 3206 | 76 |
1322315 | 1322315 | 2021-05-15 | Hickman | Tennessee | 47081 | 2847 | 46 |
1322316 | 1322316 | 2021-05-15 | Houston | Tennessee | 47083 | 1097 | 33 |
1322317 | 1322317 | 2021-05-15 | Humphreys | Tennessee | 47085 | 1815 | 28 |
1322318 | 1322318 | 2021-05-15 | Jackson | Tennessee | 47087 | 1323 | 36 |
1322319 | 1322319 | 2021-05-15 | Jefferson | Tennessee | 47089 | 6244 | 125 |
1322320 | 1322320 | 2021-05-15 | Johnson | Tennessee | 47091 | 2419 | 39 |
1322321 | 1322321 | 2021-05-15 | Knox | Tennessee | 47093 | 52047 | 636 |
1322322 | 1322322 | 2021-05-15 | Lake | Tennessee | 47095 | 1705 | 26 |
1322323 | 1322323 | 2021-05-15 | Lauderdale | Tennessee | 47097 | 3202 | 44 |
1322324 | 1322324 | 2021-05-15 | Lawrence | Tennessee | 47099 | 5984 | 91 |
1322325 | 1322325 | 2021-05-15 | Lewis | Tennessee | 47101 | 1584 | 26 |
1322326 | 1322326 | 2021-05-15 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1322327 | 1322327 | 2021-05-15 | Loudon | Tennessee | 47105 | 6164 | 69 |
1322328 | 1322328 | 2021-05-15 | Macon | Tennessee | 47111 | 3631 | 78 |
1322329 | 1322329 | 2021-05-15 | Madison | Tennessee | 47113 | 11281 | 241 |
1322330 | 1322330 | 2021-05-15 | Marion | Tennessee | 47115 | 3128 | 47 |
1322331 | 1322331 | 2021-05-15 | Marshall | Tennessee | 47117 | 4206 | 58 |
1322332 | 1322332 | 2021-05-15 | Maury | Tennessee | 47119 | 13545 | 172 |
1322333 | 1322333 | 2021-05-15 | McMinn | Tennessee | 47107 | 6541 | 98 |
1322334 | 1322334 | 2021-05-15 | McNairy | Tennessee | 47109 | 2842 | 54 |
1322335 | 1322335 | 2021-05-15 | Meigs | Tennessee | 47121 | 1391 | 25 |
1322336 | 1322336 | 2021-05-15 | Monroe | Tennessee | 47123 | 5875 | 96 |
1322337 | 1322337 | 2021-05-15 | Montgomery | Tennessee | 47125 | 20402 | 227 |
1322338 | 1322338 | 2021-05-15 | Moore | Tennessee | 47127 | 1017 | 17 |
1322339 | 1322339 | 2021-05-15 | Morgan | Tennessee | 47129 | 2513 | 39 |
1322340 | 1322340 | 2021-05-15 | Obion | Tennessee | 47131 | 4550 | 96 |
1322341 | 1322341 | 2021-05-15 | Overton | Tennessee | 47133 | 3025 | 61 |
1322342 | 1322342 | 2021-05-15 | Perry | Tennessee | 47135 | 1072 | 28 |
1322343 | 1322343 | 2021-05-15 | Pickett | Tennessee | 47137 | 759 | 24 |
1322344 | 1322344 | 2021-05-15 | Polk | Tennessee | 47139 | 2087 | 25 |
1322345 | 1322345 | 2021-05-15 | Putnam | Tennessee | 47141 | 11437 | 175 |
1322346 | 1322346 | 2021-05-15 | Rhea | Tennessee | 47143 | 4357 | 75 |
1322347 | 1322347 | 2021-05-15 | Roane | Tennessee | 47145 | 6318 | 105 |
1322348 | 1322348 | 2021-05-15 | Robertson | Tennessee | 47147 | 9793 | 132 |
1322349 | 1322349 | 2021-05-15 | Rutherford | Tennessee | 47149 | 43212 | 437 |
1322350 | 1322350 | 2021-05-15 | Scott | Tennessee | 47151 | 3152 | 45 |
1322351 | 1322351 | 2021-05-15 | Sequatchie | Tennessee | 47153 | 1718 | 29 |
1322352 | 1322352 | 2021-05-15 | Sevier | Tennessee | 47155 | 13451 | 175 |
1322353 | 1322353 | 2021-05-15 | Shelby | Tennessee | 47157 | 97393 | 1638 |
1322354 | 1322354 | 2021-05-15 | Smith | Tennessee | 47159 | 2785 | 39 |
1322355 | 1322355 | 2021-05-15 | Stewart | Tennessee | 47161 | 1330 | 28 |
1322356 | 1322356 | 2021-05-15 | Sullivan | Tennessee | 47163 | 16952 | 298 |
1322357 | 1322357 | 2021-05-15 | Sumner | Tennessee | 47165 | 24135 | 349 |
1322358 | 1322358 | 2021-05-15 | Tipton | Tennessee | 47167 | 7397 | 104 |
1322359 | 1322359 | 2021-05-15 | Trousdale | Tennessee | 47169 | 2506 | 22 |
1322360 | 1322360 | 2021-05-15 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1322361 | 1322361 | 2021-05-15 | Union | Tennessee | 47173 | 1922 | 34 |
1322362 | 1322362 | 2021-05-15 | Unknown | Tennessee | 9242 | 125 | |
1322363 | 1322363 | 2021-05-15 | Van Buren | Tennessee | 47175 | 855 | 23 |
1322364 | 1322364 | 2021-05-15 | Warren | Tennessee | 47177 | 5555 | 81 |
1322365 | 1322365 | 2021-05-15 | Washington | Tennessee | 47179 | 14691 | 245 |
1322366 | 1322366 | 2021-05-15 | Wayne | Tennessee | 47181 | 2970 | 34 |
1322367 | 1322367 | 2021-05-15 | Weakley | Tennessee | 47183 | 4163 | 65 |
1322368 | 1322368 | 2021-05-15 | White | Tennessee | 47185 | 3681 | 70 |
1322369 | 1322369 | 2021-05-15 | Williamson | Tennessee | 47187 | 28116 | 217 |
1322370 | 1322370 | 2021-05-15 | Wilson | Tennessee | 47189 | 18907 | 236 |
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);