ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,179 rows where deaths = 3 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Blount 97
- Macon 81
- Humphreys 79
- Hancock 73
- Crockett 60
- Loudon 49
- White 47
- Franklin 37
- Meigs 32
- Sevier 26
- Tipton 24
- Campbell 23
- Lake 21
- Maury 19
- Fentress 18
- Montgomery 18
- Claiborne 17
- Sequatchie 16
- Bradley 15
- Cumberland 15
- Decatur 15
- Grainger 15
- Morgan 15
- Unknown 15
- Dyer 14
- Obion 14
- Carroll 13
- Warren 13
- Scott 12
- Bedford 11
- …
state 1
- Tennessee · 1,179 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
806216 | 806216 | 2020-12-07 | Van Buren | Tennessee | 47175 | 407 | 3 |
802946 | 802946 | 2020-12-06 | Moore | Tennessee | 47127 | 426 | 3 |
802971 | 802971 | 2020-12-06 | Van Buren | Tennessee | 47175 | 403 | 3 |
799726 | 799726 | 2020-12-05 | Van Buren | Tennessee | 47175 | 397 | 3 |
796481 | 796481 | 2020-12-04 | Van Buren | Tennessee | 47175 | 389 | 3 |
783447 | 783447 | 2020-11-30 | Hancock | Tennessee | 47067 | 183 | 3 |
783477 | 783477 | 2020-11-30 | Moore | Tennessee | 47127 | 404 | 3 |
783501 | 783501 | 2020-11-30 | Unknown | Tennessee | 1108 | 3 | |
780176 | 780176 | 2020-11-29 | Cannon | Tennessee | 47015 | 769 | 3 |
780202 | 780202 | 2020-11-29 | Hancock | Tennessee | 47067 | 172 | 3 |
780232 | 780232 | 2020-11-29 | Moore | Tennessee | 47127 | 394 | 3 |
776930 | 776930 | 2020-11-28 | Cannon | Tennessee | 47015 | 766 | 3 |
776956 | 776956 | 2020-11-28 | Hancock | Tennessee | 47067 | 167 | 3 |
776986 | 776986 | 2020-11-28 | Moore | Tennessee | 47127 | 396 | 3 |
773685 | 773685 | 2020-11-27 | Cannon | Tennessee | 47015 | 729 | 3 |
773711 | 773711 | 2020-11-27 | Hancock | Tennessee | 47067 | 156 | 3 |
773741 | 773741 | 2020-11-27 | Moore | Tennessee | 47127 | 389 | 3 |
770440 | 770440 | 2020-11-26 | Cannon | Tennessee | 47015 | 725 | 3 |
770466 | 770466 | 2020-11-26 | Hancock | Tennessee | 47067 | 155 | 3 |
770496 | 770496 | 2020-11-26 | Moore | Tennessee | 47127 | 383 | 3 |
767194 | 767194 | 2020-11-25 | Cannon | Tennessee | 47015 | 718 | 3 |
767220 | 767220 | 2020-11-25 | Hancock | Tennessee | 47067 | 150 | 3 |
767250 | 767250 | 2020-11-25 | Moore | Tennessee | 47127 | 377 | 3 |
763949 | 763949 | 2020-11-24 | Cannon | Tennessee | 47015 | 713 | 3 |
763975 | 763975 | 2020-11-24 | Hancock | Tennessee | 47067 | 147 | 3 |
760730 | 760730 | 2020-11-23 | Hancock | Tennessee | 47067 | 147 | 3 |
757485 | 757485 | 2020-11-22 | Hancock | Tennessee | 47067 | 145 | 3 |
754238 | 754238 | 2020-11-21 | Hancock | Tennessee | 47067 | 140 | 3 |
750992 | 750992 | 2020-11-20 | Hancock | Tennessee | 47067 | 138 | 3 |
747746 | 747746 | 2020-11-19 | Hancock | Tennessee | 47067 | 138 | 3 |
744500 | 744500 | 2020-11-18 | Hancock | Tennessee | 47067 | 135 | 3 |
741253 | 741253 | 2020-11-17 | Hancock | Tennessee | 47067 | 134 | 3 |
738007 | 738007 | 2020-11-16 | Hancock | Tennessee | 47067 | 133 | 3 |
734763 | 734763 | 2020-11-15 | Hancock | Tennessee | 47067 | 131 | 3 |
731517 | 731517 | 2020-11-14 | Hancock | Tennessee | 47067 | 129 | 3 |
728273 | 728273 | 2020-11-13 | Hancock | Tennessee | 47067 | 127 | 3 |
725029 | 725029 | 2020-11-12 | Hancock | Tennessee | 47067 | 127 | 3 |
721786 | 721786 | 2020-11-11 | Hancock | Tennessee | 47067 | 127 | 3 |
721816 | 721816 | 2020-11-11 | Moore | Tennessee | 47127 | 317 | 3 |
718543 | 718543 | 2020-11-10 | Hancock | Tennessee | 47067 | 127 | 3 |
718573 | 718573 | 2020-11-10 | Moore | Tennessee | 47127 | 313 | 3 |
715300 | 715300 | 2020-11-09 | Hancock | Tennessee | 47067 | 128 | 3 |
712056 | 712056 | 2020-11-08 | Hancock | Tennessee | 47067 | 128 | 3 |
708812 | 708812 | 2020-11-07 | Hancock | Tennessee | 47067 | 128 | 3 |
705569 | 705569 | 2020-11-06 | Hancock | Tennessee | 47067 | 128 | 3 |
702326 | 702326 | 2020-11-05 | Hancock | Tennessee | 47067 | 126 | 3 |
699082 | 699082 | 2020-11-04 | Hancock | Tennessee | 47067 | 126 | 3 |
695839 | 695839 | 2020-11-03 | Hancock | Tennessee | 47067 | 129 | 3 |
695882 | 695882 | 2020-11-03 | Sequatchie | Tennessee | 47153 | 382 | 3 |
692597 | 692597 | 2020-11-02 | Hancock | Tennessee | 47067 | 129 | 3 |
689353 | 689353 | 2020-11-01 | Hancock | Tennessee | 47067 | 128 | 3 |
686108 | 686108 | 2020-10-31 | Hancock | Tennessee | 47067 | 128 | 3 |
682865 | 682865 | 2020-10-30 | Hancock | Tennessee | 47067 | 127 | 3 |
679622 | 679622 | 2020-10-29 | Hancock | Tennessee | 47067 | 125 | 3 |
679640 | 679640 | 2020-10-29 | Lincoln | Tennessee | 47103 | 945 | 3 |
676379 | 676379 | 2020-10-28 | Hancock | Tennessee | 47067 | 123 | 3 |
676397 | 676397 | 2020-10-28 | Lincoln | Tennessee | 47103 | 931 | 3 |
676431 | 676431 | 2020-10-28 | Unicoi | Tennessee | 47171 | 457 | 3 |
676432 | 676432 | 2020-10-28 | Union | Tennessee | 47173 | 552 | 3 |
673136 | 673136 | 2020-10-27 | Hancock | Tennessee | 47067 | 121 | 3 |
673150 | 673150 | 2020-10-27 | Lake | Tennessee | 47095 | 988 | 3 |
673154 | 673154 | 2020-10-27 | Lincoln | Tennessee | 47103 | 925 | 3 |
673188 | 673188 | 2020-10-27 | Unicoi | Tennessee | 47171 | 445 | 3 |
673189 | 673189 | 2020-10-27 | Union | Tennessee | 47173 | 549 | 3 |
669894 | 669894 | 2020-10-26 | Hancock | Tennessee | 47067 | 121 | 3 |
669908 | 669908 | 2020-10-26 | Lake | Tennessee | 47095 | 987 | 3 |
669912 | 669912 | 2020-10-26 | Lincoln | Tennessee | 47103 | 917 | 3 |
669946 | 669946 | 2020-10-26 | Unicoi | Tennessee | 47171 | 433 | 3 |
669947 | 669947 | 2020-10-26 | Union | Tennessee | 47173 | 546 | 3 |
666650 | 666650 | 2020-10-25 | Hancock | Tennessee | 47067 | 119 | 3 |
666664 | 666664 | 2020-10-25 | Lake | Tennessee | 47095 | 985 | 3 |
666667 | 666667 | 2020-10-25 | Lewis | Tennessee | 47101 | 403 | 3 |
666668 | 666668 | 2020-10-25 | Lincoln | Tennessee | 47103 | 897 | 3 |
666702 | 666702 | 2020-10-25 | Unicoi | Tennessee | 47171 | 418 | 3 |
666703 | 666703 | 2020-10-25 | Union | Tennessee | 47173 | 543 | 3 |
663405 | 663405 | 2020-10-24 | Hancock | Tennessee | 47067 | 117 | 3 |
663419 | 663419 | 2020-10-24 | Lake | Tennessee | 47095 | 983 | 3 |
663423 | 663423 | 2020-10-24 | Lincoln | Tennessee | 47103 | 880 | 3 |
663457 | 663457 | 2020-10-24 | Unicoi | Tennessee | 47171 | 404 | 3 |
663458 | 663458 | 2020-10-24 | Union | Tennessee | 47173 | 538 | 3 |
660161 | 660161 | 2020-10-23 | Hancock | Tennessee | 47067 | 115 | 3 |
660175 | 660175 | 2020-10-23 | Lake | Tennessee | 47095 | 980 | 3 |
660179 | 660179 | 2020-10-23 | Lincoln | Tennessee | 47103 | 852 | 3 |
660213 | 660213 | 2020-10-23 | Unicoi | Tennessee | 47171 | 395 | 3 |
660214 | 660214 | 2020-10-23 | Union | Tennessee | 47173 | 523 | 3 |
656917 | 656917 | 2020-10-22 | Hancock | Tennessee | 47067 | 113 | 3 |
656931 | 656931 | 2020-10-22 | Lake | Tennessee | 47095 | 975 | 3 |
656935 | 656935 | 2020-10-22 | Lincoln | Tennessee | 47103 | 836 | 3 |
656970 | 656970 | 2020-10-22 | Union | Tennessee | 47173 | 517 | 3 |
653672 | 653672 | 2020-10-21 | Hancock | Tennessee | 47067 | 112 | 3 |
653686 | 653686 | 2020-10-21 | Lake | Tennessee | 47095 | 976 | 3 |
650427 | 650427 | 2020-10-20 | Hancock | Tennessee | 47067 | 112 | 3 |
650441 | 650441 | 2020-10-20 | Lake | Tennessee | 47095 | 970 | 3 |
647183 | 647183 | 2020-10-19 | Hancock | Tennessee | 47067 | 112 | 3 |
647197 | 647197 | 2020-10-19 | Lake | Tennessee | 47095 | 968 | 3 |
643937 | 643937 | 2020-10-18 | Hancock | Tennessee | 47067 | 112 | 3 |
643951 | 643951 | 2020-10-18 | Lake | Tennessee | 47095 | 962 | 3 |
640689 | 640689 | 2020-10-17 | Hancock | Tennessee | 47067 | 113 | 3 |
640703 | 640703 | 2020-10-17 | Lake | Tennessee | 47095 | 957 | 3 |
637443 | 637443 | 2020-10-16 | Hancock | Tennessee | 47067 | 112 | 3 |
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);