ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,246 rows where deaths = 0 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 47135 199
- 47015 188
- 47083 184
- 47175 175
- 47049 164
- 47161 157
- 47027 153
- 47173 149
- 47171 148
- 47025 145
- 47121 144
- 47151 143
- 47091 142
- 47127 140
- 47057 135
- 47081 134
- 47153 132
- 47179 131
- 47023 130
- 47079 130
- 47043 129
- 47145 126
- 47031 124
- 47095 124
- 47077 123
- 47101 122
- 47103 121
- 47087 120
- 47139 119
- 47029 117
- …
county >30
- Perry 199
- Cannon 188
- Houston 184
- Van Buren 175
- Fentress 164
- Stewart 157
- Clay 153
- Union 149
- Unicoi 148
- Claiborne 145
- Meigs 144
- Scott 143
- Johnson 142
- Moore 140
- Grainger 135
- Hickman 134
- Sequatchie 132
- Washington 131
- Chester 130
- Henry 130
- Dickson 129
- Roane 126
- Coffee 124
- Lake 124
- Henderson 123
- Lewis 122
- Lincoln 121
- Jackson 120
- Polk 119
- Cocke 117
- …
state 1
- Tennessee · 7,246 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
789990 | 789990 | 2020-12-02 | Unknown | Tennessee | 641 | 0 | |
786745 | 786745 | 2020-12-01 | Unknown | Tennessee | 676 | 0 | |
744554 | 744554 | 2020-11-18 | Unknown | Tennessee | 994 | 0 | |
741307 | 741307 | 2020-11-17 | Unknown | Tennessee | 526 | 0 | |
738061 | 738061 | 2020-11-16 | Unknown | Tennessee | 1678 | 0 | |
734817 | 734817 | 2020-11-15 | Unknown | Tennessee | 839 | 0 | |
731571 | 731571 | 2020-11-14 | Unknown | Tennessee | 272 | 0 | |
725083 | 725083 | 2020-11-12 | Unknown | Tennessee | 37 | 0 | |
721840 | 721840 | 2020-11-11 | Unknown | Tennessee | 262 | 0 | |
718597 | 718597 | 2020-11-10 | Unknown | Tennessee | 34 | 0 | |
715354 | 715354 | 2020-11-09 | Unknown | Tennessee | 867 | 0 | |
712110 | 712110 | 2020-11-08 | Unknown | Tennessee | 201 | 0 | |
708866 | 708866 | 2020-11-07 | Unknown | Tennessee | 423 | 0 | |
699136 | 699136 | 2020-11-04 | Unknown | Tennessee | 132 | 0 | |
666704 | 666704 | 2020-10-25 | Unknown | Tennessee | 159 | 0 | |
663459 | 663459 | 2020-10-24 | Unknown | Tennessee | 382 | 0 | |
660215 | 660215 | 2020-10-23 | Unknown | Tennessee | 535 | 0 | |
656971 | 656971 | 2020-10-22 | Unknown | Tennessee | 460 | 0 | |
653726 | 653726 | 2020-10-21 | Unknown | Tennessee | 643 | 0 | |
650481 | 650481 | 2020-10-20 | Unknown | Tennessee | 442 | 0 | |
647237 | 647237 | 2020-10-19 | Unknown | Tennessee | 1041 | 0 | |
643991 | 643991 | 2020-10-18 | Unknown | Tennessee | 604 | 0 | |
640743 | 640743 | 2020-10-17 | Unknown | Tennessee | 503 | 0 | |
634251 | 634251 | 2020-10-15 | Unknown | Tennessee | 403 | 0 | |
631006 | 631006 | 2020-10-14 | Unknown | Tennessee | 129 | 0 | |
627762 | 627762 | 2020-10-13 | Unknown | Tennessee | 222 | 0 | |
614792 | 614792 | 2020-10-09 | Unknown | Tennessee | 118 | 0 | |
605046 | 605046 | 2020-10-06 | Perry | Tennessee | 47135 | 157 | 0 |
601804 | 601804 | 2020-10-05 | Perry | Tennessee | 47135 | 157 | 0 |
598561 | 598561 | 2020-10-04 | Perry | Tennessee | 47135 | 157 | 0 |
598582 | 598582 | 2020-10-04 | Van Buren | Tennessee | 47175 | 170 | 0 |
595318 | 595318 | 2020-10-03 | Perry | Tennessee | 47135 | 155 | 0 |
595339 | 595339 | 2020-10-03 | Van Buren | Tennessee | 47175 | 170 | 0 |
592077 | 592077 | 2020-10-02 | Perry | Tennessee | 47135 | 154 | 0 |
592097 | 592097 | 2020-10-02 | Van Buren | Tennessee | 47175 | 168 | 0 |
588836 | 588836 | 2020-10-01 | Perry | Tennessee | 47135 | 154 | 0 |
588857 | 588857 | 2020-10-01 | Van Buren | Tennessee | 47175 | 168 | 0 |
585596 | 585596 | 2020-09-30 | Perry | Tennessee | 47135 | 153 | 0 |
585616 | 585616 | 2020-09-30 | Van Buren | Tennessee | 47175 | 167 | 0 |
582296 | 582296 | 2020-09-29 | Cannon | Tennessee | 47015 | 295 | 0 |
582356 | 582356 | 2020-09-29 | Perry | Tennessee | 47135 | 153 | 0 |
582376 | 582376 | 2020-09-29 | Van Buren | Tennessee | 47175 | 166 | 0 |
579056 | 579056 | 2020-09-28 | Cannon | Tennessee | 47015 | 295 | 0 |
579116 | 579116 | 2020-09-28 | Perry | Tennessee | 47135 | 153 | 0 |
579137 | 579137 | 2020-09-28 | Van Buren | Tennessee | 47175 | 166 | 0 |
575815 | 575815 | 2020-09-27 | Cannon | Tennessee | 47015 | 292 | 0 |
575875 | 575875 | 2020-09-27 | Perry | Tennessee | 47135 | 153 | 0 |
575896 | 575896 | 2020-09-27 | Van Buren | Tennessee | 47175 | 166 | 0 |
572571 | 572571 | 2020-09-26 | Cannon | Tennessee | 47015 | 286 | 0 |
572631 | 572631 | 2020-09-26 | Perry | Tennessee | 47135 | 150 | 0 |
572652 | 572652 | 2020-09-26 | Van Buren | Tennessee | 47175 | 166 | 0 |
569329 | 569329 | 2020-09-25 | Cannon | Tennessee | 47015 | 283 | 0 |
569389 | 569389 | 2020-09-25 | Perry | Tennessee | 47135 | 150 | 0 |
569410 | 569410 | 2020-09-25 | Van Buren | Tennessee | 47175 | 164 | 0 |
566088 | 566088 | 2020-09-24 | Cannon | Tennessee | 47015 | 280 | 0 |
566148 | 566148 | 2020-09-24 | Perry | Tennessee | 47135 | 149 | 0 |
566169 | 566169 | 2020-09-24 | Van Buren | Tennessee | 47175 | 160 | 0 |
562847 | 562847 | 2020-09-23 | Cannon | Tennessee | 47015 | 281 | 0 |
562907 | 562907 | 2020-09-23 | Perry | Tennessee | 47135 | 149 | 0 |
562928 | 562928 | 2020-09-23 | Van Buren | Tennessee | 47175 | 159 | 0 |
559610 | 559610 | 2020-09-22 | Cannon | Tennessee | 47015 | 279 | 0 |
559670 | 559670 | 2020-09-22 | Perry | Tennessee | 47135 | 150 | 0 |
559690 | 559690 | 2020-09-22 | Van Buren | Tennessee | 47175 | 154 | 0 |
556373 | 556373 | 2020-09-21 | Cannon | Tennessee | 47015 | 276 | 0 |
556407 | 556407 | 2020-09-21 | Houston | Tennessee | 47083 | 186 | 0 |
556433 | 556433 | 2020-09-21 | Perry | Tennessee | 47135 | 146 | 0 |
556454 | 556454 | 2020-09-21 | Van Buren | Tennessee | 47175 | 153 | 0 |
553136 | 553136 | 2020-09-20 | Cannon | Tennessee | 47015 | 275 | 0 |
553170 | 553170 | 2020-09-20 | Houston | Tennessee | 47083 | 185 | 0 |
553196 | 553196 | 2020-09-20 | Perry | Tennessee | 47135 | 143 | 0 |
553217 | 553217 | 2020-09-20 | Van Buren | Tennessee | 47175 | 153 | 0 |
549897 | 549897 | 2020-09-19 | Cannon | Tennessee | 47015 | 269 | 0 |
549931 | 549931 | 2020-09-19 | Houston | Tennessee | 47083 | 178 | 0 |
549957 | 549957 | 2020-09-19 | Perry | Tennessee | 47135 | 140 | 0 |
549978 | 549978 | 2020-09-19 | Van Buren | Tennessee | 47175 | 149 | 0 |
546658 | 546658 | 2020-09-18 | Cannon | Tennessee | 47015 | 263 | 0 |
546692 | 546692 | 2020-09-18 | Houston | Tennessee | 47083 | 171 | 0 |
546718 | 546718 | 2020-09-18 | Perry | Tennessee | 47135 | 138 | 0 |
546739 | 546739 | 2020-09-18 | Van Buren | Tennessee | 47175 | 146 | 0 |
543421 | 543421 | 2020-09-17 | Cannon | Tennessee | 47015 | 257 | 0 |
543455 | 543455 | 2020-09-17 | Houston | Tennessee | 47083 | 163 | 0 |
543481 | 543481 | 2020-09-17 | Perry | Tennessee | 47135 | 134 | 0 |
543502 | 543502 | 2020-09-17 | Van Buren | Tennessee | 47175 | 145 | 0 |
540185 | 540185 | 2020-09-16 | Cannon | Tennessee | 47015 | 254 | 0 |
540219 | 540219 | 2020-09-16 | Houston | Tennessee | 47083 | 160 | 0 |
540245 | 540245 | 2020-09-16 | Perry | Tennessee | 47135 | 134 | 0 |
540266 | 540266 | 2020-09-16 | Van Buren | Tennessee | 47175 | 136 | 0 |
536948 | 536948 | 2020-09-15 | Cannon | Tennessee | 47015 | 249 | 0 |
536982 | 536982 | 2020-09-15 | Houston | Tennessee | 47083 | 157 | 0 |
537008 | 537008 | 2020-09-15 | Perry | Tennessee | 47135 | 133 | 0 |
537029 | 537029 | 2020-09-15 | Van Buren | Tennessee | 47175 | 132 | 0 |
533712 | 533712 | 2020-09-14 | Cannon | Tennessee | 47015 | 249 | 0 |
533746 | 533746 | 2020-09-14 | Houston | Tennessee | 47083 | 144 | 0 |
533772 | 533772 | 2020-09-14 | Perry | Tennessee | 47135 | 133 | 0 |
533793 | 533793 | 2020-09-14 | Van Buren | Tennessee | 47175 | 131 | 0 |
530477 | 530477 | 2020-09-13 | Cannon | Tennessee | 47015 | 241 | 0 |
530511 | 530511 | 2020-09-13 | Houston | Tennessee | 47083 | 132 | 0 |
530537 | 530537 | 2020-09-13 | Perry | Tennessee | 47135 | 132 | 0 |
530558 | 530558 | 2020-09-13 | Van Buren | Tennessee | 47175 | 129 | 0 |
527240 | 527240 | 2020-09-12 | Cannon | Tennessee | 47015 | 240 | 0 |
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);