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 149
- 47037 146
- 47157 146
- 47163 144
- 47093 142
- 47065 141
- 47089 141
- 47149 141
- 47013 140
- 47155 138
- 47021 136
- 47147 136
- 47165 136
- 47035 135
- 47045 135
- 47125 135
- 47179 135
- 47189 135
- 47001 134
- 47009 134
- 47011 134
- 47043 134
- 47059 134
- 47063 134
- 47119 134
- 47167 134
- 47017 133
- 47029 133
- 47047 133
- 47123 133
- …
county >30
- Williamson 149
- Davidson 146
- Shelby 146
- Sullivan 144
- Knox 142
- Hamilton 141
- Jefferson 141
- Rutherford 141
- Campbell 140
- Sevier 138
- Cheatham 136
- Robertson 136
- Sumner 136
- Cumberland 135
- Dyer 135
- Montgomery 135
- Washington 135
- Wilson 135
- Anderson 134
- Blount 134
- Bradley 134
- Dickson 134
- Greene 134
- Hamblen 134
- Maury 134
- Tipton 134
- Carroll 133
- Cocke 133
- Fayette 133
- Monroe 133
- …
state 1
- Tennessee · 12,245 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388440 | 388440 | 2020-07-31 | Anderson | Tennessee | 47001 | 571 | 5 |
388441 | 388441 | 2020-07-31 | Bedford | Tennessee | 47003 | 823 | 10 |
388442 | 388442 | 2020-07-31 | Benton | Tennessee | 47005 | 80 | 1 |
388443 | 388443 | 2020-07-31 | Bledsoe | Tennessee | 47007 | 659 | 1 |
388444 | 388444 | 2020-07-31 | Blount | Tennessee | 47009 | 1043 | 7 |
388445 | 388445 | 2020-07-31 | Bradley | Tennessee | 47011 | 1651 | 10 |
388446 | 388446 | 2020-07-31 | Campbell | Tennessee | 47013 | 190 | 1 |
388447 | 388447 | 2020-07-31 | Cannon | Tennessee | 47015 | 110 | 0 |
388448 | 388448 | 2020-07-31 | Carroll | Tennessee | 47017 | 191 | 3 |
388449 | 388449 | 2020-07-31 | Carter | Tennessee | 47019 | 390 | 5 |
388450 | 388450 | 2020-07-31 | Cheatham | Tennessee | 47021 | 516 | 5 |
388451 | 388451 | 2020-07-31 | Chester | Tennessee | 47023 | 181 | 1 |
388452 | 388452 | 2020-07-31 | Claiborne | Tennessee | 47025 | 206 | 0 |
388453 | 388453 | 2020-07-31 | Clay | Tennessee | 47027 | 58 | 0 |
388454 | 388454 | 2020-07-31 | Cocke | Tennessee | 47029 | 369 | 1 |
388455 | 388455 | 2020-07-31 | Coffee | Tennessee | 47031 | 370 | 2 |
388456 | 388456 | 2020-07-31 | Crockett | Tennessee | 47033 | 216 | 3 |
388457 | 388457 | 2020-07-31 | Cumberland | Tennessee | 47035 | 365 | 6 |
388458 | 388458 | 2020-07-31 | Davidson | Tennessee | 47037 | 21060 | 198 |
388459 | 388459 | 2020-07-31 | DeKalb | Tennessee | 47041 | 295 | 1 |
388460 | 388460 | 2020-07-31 | Decatur | Tennessee | 47039 | 150 | 1 |
388461 | 388461 | 2020-07-31 | Dickson | Tennessee | 47043 | 575 | 1 |
388462 | 388462 | 2020-07-31 | Dyer | Tennessee | 47045 | 515 | 6 |
388463 | 388463 | 2020-07-31 | Fayette | Tennessee | 47047 | 596 | 8 |
388464 | 388464 | 2020-07-31 | Fentress | Tennessee | 47049 | 71 | 0 |
388465 | 388465 | 2020-07-31 | Franklin | Tennessee | 47051 | 258 | 4 |
388466 | 388466 | 2020-07-31 | Gibson | Tennessee | 47053 | 537 | 2 |
388467 | 388467 | 2020-07-31 | Giles | Tennessee | 47055 | 321 | 8 |
388468 | 388468 | 2020-07-31 | Grainger | Tennessee | 47057 | 162 | 0 |
388469 | 388469 | 2020-07-31 | Greene | Tennessee | 47059 | 344 | 5 |
388470 | 388470 | 2020-07-31 | Grundy | Tennessee | 47061 | 97 | 2 |
388471 | 388471 | 2020-07-31 | Hamblen | Tennessee | 47063 | 1183 | 13 |
388472 | 388472 | 2020-07-31 | Hamilton | Tennessee | 47065 | 5483 | 48 |
388473 | 388473 | 2020-07-31 | Hancock | Tennessee | 47067 | 71 | 1 |
388474 | 388474 | 2020-07-31 | Hardeman | Tennessee | 47069 | 760 | 11 |
388475 | 388475 | 2020-07-31 | Hardin | Tennessee | 47071 | 386 | 7 |
388476 | 388476 | 2020-07-31 | Hawkins | Tennessee | 47073 | 291 | 4 |
388477 | 388477 | 2020-07-31 | Haywood | Tennessee | 47075 | 363 | 5 |
388478 | 388478 | 2020-07-31 | Henderson | Tennessee | 47077 | 420 | 0 |
388479 | 388479 | 2020-07-31 | Henry | Tennessee | 47079 | 177 | 0 |
388480 | 388480 | 2020-07-31 | Hickman | Tennessee | 47081 | 208 | 0 |
388481 | 388481 | 2020-07-31 | Houston | Tennessee | 47083 | 54 | 0 |
388482 | 388482 | 2020-07-31 | Humphreys | Tennessee | 47085 | 99 | 3 |
388483 | 388483 | 2020-07-31 | Jackson | Tennessee | 47087 | 105 | 1 |
388484 | 388484 | 2020-07-31 | Jefferson | Tennessee | 47089 | 474 | 2 |
388485 | 388485 | 2020-07-31 | Johnson | Tennessee | 47091 | 116 | 0 |
388486 | 388486 | 2020-07-31 | Knox | Tennessee | 47093 | 3884 | 33 |
388487 | 388487 | 2020-07-31 | Lake | Tennessee | 47095 | 736 | 0 |
388488 | 388488 | 2020-07-31 | Lauderdale | Tennessee | 47097 | 411 | 6 |
388489 | 388489 | 2020-07-31 | Lawrence | Tennessee | 47099 | 444 | 6 |
388490 | 388490 | 2020-07-31 | Lewis | Tennessee | 47101 | 47 | 1 |
388491 | 388491 | 2020-07-31 | Lincoln | Tennessee | 47103 | 234 | 1 |
388492 | 388492 | 2020-07-31 | Loudon | Tennessee | 47105 | 606 | 3 |
388493 | 388493 | 2020-07-31 | Macon | Tennessee | 47111 | 820 | 13 |
388494 | 388494 | 2020-07-31 | Madison | Tennessee | 47113 | 769 | 12 |
388495 | 388495 | 2020-07-31 | Marion | Tennessee | 47115 | 195 | 4 |
388496 | 388496 | 2020-07-31 | Marshall | Tennessee | 47117 | 258 | 2 |
388497 | 388497 | 2020-07-31 | Maury | Tennessee | 47119 | 1010 | 5 |
388498 | 388498 | 2020-07-31 | McMinn | Tennessee | 47107 | 462 | 20 |
388499 | 388499 | 2020-07-31 | McNairy | Tennessee | 47109 | 300 | 5 |
388500 | 388500 | 2020-07-31 | Meigs | Tennessee | 47121 | 92 | 0 |
388501 | 388501 | 2020-07-31 | Monroe | Tennessee | 47123 | 333 | 9 |
388502 | 388502 | 2020-07-31 | Montgomery | Tennessee | 47125 | 1646 | 11 |
388503 | 388503 | 2020-07-31 | Moore | Tennessee | 47127 | 42 | 0 |
388504 | 388504 | 2020-07-31 | Morgan | Tennessee | 47129 | 70 | 1 |
388505 | 388505 | 2020-07-31 | Obion | Tennessee | 47131 | 377 | 4 |
388506 | 388506 | 2020-07-31 | Overton | Tennessee | 47133 | 125 | 1 |
388507 | 388507 | 2020-07-31 | Perry | Tennessee | 47135 | 69 | 0 |
388508 | 388508 | 2020-07-31 | Pickett | Tennessee | 47137 | 21 | 1 |
388509 | 388509 | 2020-07-31 | Polk | Tennessee | 47139 | 140 | 1 |
388510 | 388510 | 2020-07-31 | Putnam | Tennessee | 47141 | 1518 | 13 |
388511 | 388511 | 2020-07-31 | Rhea | Tennessee | 47143 | 481 | 1 |
388512 | 388512 | 2020-07-31 | Roane | Tennessee | 47145 | 330 | 1 |
388513 | 388513 | 2020-07-31 | Robertson | Tennessee | 47147 | 1409 | 16 |
388514 | 388514 | 2020-07-31 | Rutherford | Tennessee | 47149 | 5899 | 51 |
388515 | 388515 | 2020-07-31 | Scott | Tennessee | 47151 | 91 | 0 |
388516 | 388516 | 2020-07-31 | Sequatchie | Tennessee | 47153 | 93 | 0 |
388517 | 388517 | 2020-07-31 | Sevier | Tennessee | 47155 | 1644 | 5 |
388518 | 388518 | 2020-07-31 | Shelby | Tennessee | 47157 | 20797 | 279 |
388519 | 388519 | 2020-07-31 | Smith | Tennessee | 47159 | 340 | 3 |
388520 | 388520 | 2020-07-31 | Stewart | Tennessee | 47161 | 65 | 0 |
388521 | 388521 | 2020-07-31 | Sullivan | Tennessee | 47163 | 729 | 8 |
388522 | 388522 | 2020-07-31 | Sumner | Tennessee | 47165 | 3106 | 69 |
388523 | 388523 | 2020-07-31 | Tipton | Tennessee | 47167 | 1065 | 9 |
388524 | 388524 | 2020-07-31 | Trousdale | Tennessee | 47169 | 1570 | 6 |
388525 | 388525 | 2020-07-31 | Unicoi | Tennessee | 47171 | 129 | 0 |
388526 | 388526 | 2020-07-31 | Union | Tennessee | 47173 | 110 | 0 |
388527 | 388527 | 2020-07-31 | Unknown | Tennessee | 415 | 0 | |
388528 | 388528 | 2020-07-31 | Van Buren | Tennessee | 47175 | 30 | 0 |
388529 | 388529 | 2020-07-31 | Warren | Tennessee | 47177 | 375 | 4 |
388530 | 388530 | 2020-07-31 | Washington | Tennessee | 47179 | 943 | 2 |
388531 | 388531 | 2020-07-31 | Wayne | Tennessee | 47181 | 206 | 1 |
388532 | 388532 | 2020-07-31 | Weakley | Tennessee | 47183 | 229 | 3 |
388533 | 388533 | 2020-07-31 | White | Tennessee | 47185 | 186 | 3 |
388534 | 388534 | 2020-07-31 | Williamson | Tennessee | 47187 | 3132 | 22 |
388535 | 388535 | 2020-07-31 | Wilson | Tennessee | 47189 | 2001 | 20 |
385223 | 385223 | 2020-07-30 | Anderson | Tennessee | 47001 | 550 | 5 |
385224 | 385224 | 2020-07-30 | Bedford | Tennessee | 47003 | 808 | 10 |
385225 | 385225 | 2020-07-30 | Benton | Tennessee | 47005 | 70 | 1 |
385226 | 385226 | 2020-07-30 | Bledsoe | Tennessee | 47007 | 656 | 1 |
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);