ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,708 rows where deaths = 1 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Campbell 124
- Benton 114
- Gibson 100
- Bledsoe 91
- Marshall 90
- Carroll 89
- Carter 88
- Grundy 85
- Smith 84
- Lewis 81
- Obion 81
- Lincoln 78
- Morgan 75
- Humphreys 72
- Marion 72
- Franklin 68
- Pickett 60
- Unicoi 60
- Anderson 57
- Overton 57
- Bradley 52
- Moore 44
- Haywood 43
- Maury 43
- Sullivan 40
- Lauderdale 38
- Cumberland 37
- Grainger 34
- Trousdale 34
- Union 34
- …
state 1
- Tennessee · 2,708 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
799725 | 799725 | 2020-12-05 | Unknown | Tennessee | 315 | 1 | |
793235 | 793235 | 2020-12-03 | Unknown | Tennessee | 285 | 1 | |
754292 | 754292 | 2020-11-21 | Unknown | Tennessee | 438 | 1 | |
751046 | 751046 | 2020-11-20 | Unknown | Tennessee | 147 | 1 | |
747800 | 747800 | 2020-11-19 | Unknown | Tennessee | 227 | 1 | |
669948 | 669948 | 2020-10-26 | Van Buren | Tennessee | 47175 | 208 | 1 |
666705 | 666705 | 2020-10-25 | Van Buren | Tennessee | 47175 | 207 | 1 |
663460 | 663460 | 2020-10-24 | Van Buren | Tennessee | 47175 | 205 | 1 |
660216 | 660216 | 2020-10-23 | Van Buren | Tennessee | 47175 | 201 | 1 |
656951 | 656951 | 2020-10-22 | Perry | Tennessee | 47135 | 261 | 1 |
656972 | 656972 | 2020-10-22 | Van Buren | Tennessee | 47175 | 197 | 1 |
653706 | 653706 | 2020-10-21 | Perry | Tennessee | 47135 | 253 | 1 |
653727 | 653727 | 2020-10-21 | Van Buren | Tennessee | 47175 | 195 | 1 |
650461 | 650461 | 2020-10-20 | Perry | Tennessee | 47135 | 208 | 1 |
650482 | 650482 | 2020-10-20 | Van Buren | Tennessee | 47175 | 191 | 1 |
647217 | 647217 | 2020-10-19 | Perry | Tennessee | 47135 | 204 | 1 |
647235 | 647235 | 2020-10-19 | Unicoi | Tennessee | 47171 | 364 | 1 |
647238 | 647238 | 2020-10-19 | Van Buren | Tennessee | 47175 | 191 | 1 |
643971 | 643971 | 2020-10-18 | Perry | Tennessee | 47135 | 196 | 1 |
643989 | 643989 | 2020-10-18 | Unicoi | Tennessee | 47171 | 346 | 1 |
643992 | 643992 | 2020-10-18 | Van Buren | Tennessee | 47175 | 191 | 1 |
640723 | 640723 | 2020-10-17 | Perry | Tennessee | 47135 | 190 | 1 |
640741 | 640741 | 2020-10-17 | Unicoi | Tennessee | 47171 | 340 | 1 |
640744 | 640744 | 2020-10-17 | Van Buren | Tennessee | 47175 | 190 | 1 |
637477 | 637477 | 2020-10-16 | Perry | Tennessee | 47135 | 176 | 1 |
637495 | 637495 | 2020-10-16 | Unicoi | Tennessee | 47171 | 330 | 1 |
637497 | 637497 | 2020-10-16 | Van Buren | Tennessee | 47175 | 186 | 1 |
634227 | 634227 | 2020-10-15 | Moore | Tennessee | 47127 | 228 | 1 |
634231 | 634231 | 2020-10-15 | Perry | Tennessee | 47135 | 176 | 1 |
634249 | 634249 | 2020-10-15 | Unicoi | Tennessee | 47171 | 330 | 1 |
634252 | 634252 | 2020-10-15 | Van Buren | Tennessee | 47175 | 186 | 1 |
630982 | 630982 | 2020-10-14 | Moore | Tennessee | 47127 | 227 | 1 |
630986 | 630986 | 2020-10-14 | Perry | Tennessee | 47135 | 175 | 1 |
631004 | 631004 | 2020-10-14 | Unicoi | Tennessee | 47171 | 309 | 1 |
631007 | 631007 | 2020-10-14 | Van Buren | Tennessee | 47175 | 185 | 1 |
627725 | 627725 | 2020-10-13 | Lewis | Tennessee | 47101 | 291 | 1 |
627738 | 627738 | 2020-10-13 | Moore | Tennessee | 47127 | 222 | 1 |
627742 | 627742 | 2020-10-13 | Perry | Tennessee | 47135 | 170 | 1 |
627751 | 627751 | 2020-10-13 | Sequatchie | Tennessee | 47153 | 284 | 1 |
627760 | 627760 | 2020-10-13 | Unicoi | Tennessee | 47171 | 307 | 1 |
627763 | 627763 | 2020-10-13 | Van Buren | Tennessee | 47175 | 181 | 1 |
624483 | 624483 | 2020-10-12 | Lewis | Tennessee | 47101 | 290 | 1 |
624496 | 624496 | 2020-10-12 | Moore | Tennessee | 47127 | 223 | 1 |
624500 | 624500 | 2020-10-12 | Perry | Tennessee | 47135 | 169 | 1 |
624509 | 624509 | 2020-10-12 | Sequatchie | Tennessee | 47153 | 280 | 1 |
624518 | 624518 | 2020-10-12 | Unicoi | Tennessee | 47171 | 305 | 1 |
624521 | 624521 | 2020-10-12 | Van Buren | Tennessee | 47175 | 181 | 1 |
621240 | 621240 | 2020-10-11 | Lewis | Tennessee | 47101 | 282 | 1 |
621253 | 621253 | 2020-10-11 | Moore | Tennessee | 47127 | 217 | 1 |
621257 | 621257 | 2020-10-11 | Perry | Tennessee | 47135 | 166 | 1 |
621266 | 621266 | 2020-10-11 | Sequatchie | Tennessee | 47153 | 267 | 1 |
621275 | 621275 | 2020-10-11 | Unicoi | Tennessee | 47171 | 303 | 1 |
621278 | 621278 | 2020-10-11 | Van Buren | Tennessee | 47175 | 180 | 1 |
617997 | 617997 | 2020-10-10 | Lewis | Tennessee | 47101 | 274 | 1 |
618010 | 618010 | 2020-10-10 | Moore | Tennessee | 47127 | 216 | 1 |
618014 | 618014 | 2020-10-10 | Perry | Tennessee | 47135 | 166 | 1 |
618023 | 618023 | 2020-10-10 | Sequatchie | Tennessee | 47153 | 265 | 1 |
618032 | 618032 | 2020-10-10 | Unicoi | Tennessee | 47171 | 302 | 1 |
618034 | 618034 | 2020-10-10 | Unknown | Tennessee | 153 | 1 | |
618035 | 618035 | 2020-10-10 | Van Buren | Tennessee | 47175 | 178 | 1 |
614755 | 614755 | 2020-10-09 | Lewis | Tennessee | 47101 | 260 | 1 |
614768 | 614768 | 2020-10-09 | Moore | Tennessee | 47127 | 213 | 1 |
614772 | 614772 | 2020-10-09 | Perry | Tennessee | 47135 | 166 | 1 |
614790 | 614790 | 2020-10-09 | Unicoi | Tennessee | 47171 | 300 | 1 |
614793 | 614793 | 2020-10-09 | Van Buren | Tennessee | 47175 | 176 | 1 |
611514 | 611514 | 2020-10-08 | Lewis | Tennessee | 47101 | 258 | 1 |
611515 | 611515 | 2020-10-08 | Lincoln | Tennessee | 47103 | 699 | 1 |
611527 | 611527 | 2020-10-08 | Moore | Tennessee | 47127 | 207 | 1 |
611531 | 611531 | 2020-10-08 | Perry | Tennessee | 47135 | 166 | 1 |
611540 | 611540 | 2020-10-08 | Sequatchie | Tennessee | 47153 | 262 | 1 |
611549 | 611549 | 2020-10-08 | Unicoi | Tennessee | 47171 | 300 | 1 |
611552 | 611552 | 2020-10-08 | Van Buren | Tennessee | 47175 | 174 | 1 |
608272 | 608272 | 2020-10-07 | Lewis | Tennessee | 47101 | 252 | 1 |
608273 | 608273 | 2020-10-07 | Lincoln | Tennessee | 47103 | 688 | 1 |
608285 | 608285 | 2020-10-07 | Moore | Tennessee | 47127 | 206 | 1 |
608289 | 608289 | 2020-10-07 | Perry | Tennessee | 47135 | 159 | 1 |
608298 | 608298 | 2020-10-07 | Sequatchie | Tennessee | 47153 | 261 | 1 |
608307 | 608307 | 2020-10-07 | Unicoi | Tennessee | 47171 | 300 | 1 |
608310 | 608310 | 2020-10-07 | Van Buren | Tennessee | 47175 | 173 | 1 |
605029 | 605029 | 2020-10-06 | Lewis | Tennessee | 47101 | 242 | 1 |
605030 | 605030 | 2020-10-06 | Lincoln | Tennessee | 47103 | 680 | 1 |
605042 | 605042 | 2020-10-06 | Moore | Tennessee | 47127 | 202 | 1 |
605055 | 605055 | 2020-10-06 | Sequatchie | Tennessee | 47153 | 260 | 1 |
605064 | 605064 | 2020-10-06 | Unicoi | Tennessee | 47171 | 297 | 1 |
605067 | 605067 | 2020-10-06 | Van Buren | Tennessee | 47175 | 171 | 1 |
601744 | 601744 | 2020-10-05 | Cannon | Tennessee | 47015 | 324 | 1 |
601787 | 601787 | 2020-10-05 | Lewis | Tennessee | 47101 | 240 | 1 |
601788 | 601788 | 2020-10-05 | Lincoln | Tennessee | 47103 | 670 | 1 |
601800 | 601800 | 2020-10-05 | Moore | Tennessee | 47127 | 201 | 1 |
601822 | 601822 | 2020-10-05 | Unicoi | Tennessee | 47171 | 297 | 1 |
601825 | 601825 | 2020-10-05 | Van Buren | Tennessee | 47175 | 170 | 1 |
598501 | 598501 | 2020-10-04 | Cannon | Tennessee | 47015 | 317 | 1 |
598544 | 598544 | 2020-10-04 | Lewis | Tennessee | 47101 | 227 | 1 |
598545 | 598545 | 2020-10-04 | Lincoln | Tennessee | 47103 | 659 | 1 |
598557 | 598557 | 2020-10-04 | Moore | Tennessee | 47127 | 193 | 1 |
598579 | 598579 | 2020-10-04 | Unicoi | Tennessee | 47171 | 295 | 1 |
595258 | 595258 | 2020-10-03 | Cannon | Tennessee | 47015 | 312 | 1 |
595301 | 595301 | 2020-10-03 | Lewis | Tennessee | 47101 | 221 | 1 |
595302 | 595302 | 2020-10-03 | Lincoln | Tennessee | 47103 | 657 | 1 |
595314 | 595314 | 2020-10-03 | Moore | Tennessee | 47127 | 189 | 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);