ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
646 rows where deaths = 7 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Trousdale 51
- Warren 37
- Hardin 36
- Putnam 32
- Wayne 31
- Marion 26
- Montgomery 22
- White 20
- Morgan 18
- Cocke 16
- Jackson 15
- Blount 14
- Scott 14
- Franklin 13
- Van Buren 13
- Monroe 12
- Cumberland 11
- Hancock 11
- Johnson 10
- Decatur 9
- Humphreys 9
- Roane 9
- Dyer 8
- Maury 8
- Haywood 7
- Lawrence 7
- Lewis 7
- Macon 7
- Union 7
- Henry 6
- …
state 1
- Tennessee · 646 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
984658 | 984658 | 2021-01-31 | Hancock | Tennessee | 47067 | 440 | 7 |
981411 | 981411 | 2021-01-30 | Hancock | Tennessee | 47067 | 438 | 7 |
978165 | 978165 | 2021-01-29 | Hancock | Tennessee | 47067 | 435 | 7 |
974920 | 974920 | 2021-01-28 | Hancock | Tennessee | 47067 | 431 | 7 |
971675 | 971675 | 2021-01-27 | Hancock | Tennessee | 47067 | 427 | 7 |
968430 | 968430 | 2021-01-26 | Hancock | Tennessee | 47067 | 426 | 7 |
965186 | 965186 | 2021-01-25 | Hancock | Tennessee | 47067 | 422 | 7 |
961941 | 961941 | 2021-01-24 | Hancock | Tennessee | 47067 | 419 | 7 |
958696 | 958696 | 2021-01-23 | Hancock | Tennessee | 47067 | 418 | 7 |
955450 | 955450 | 2021-01-22 | Hancock | Tennessee | 47067 | 417 | 7 |
955505 | 955505 | 2021-01-22 | Van Buren | Tennessee | 47175 | 673 | 7 |
952205 | 952205 | 2021-01-21 | Hancock | Tennessee | 47067 | 412 | 7 |
952260 | 952260 | 2021-01-21 | Van Buren | Tennessee | 47175 | 672 | 7 |
949015 | 949015 | 2021-01-20 | Van Buren | Tennessee | 47175 | 666 | 7 |
945769 | 945769 | 2021-01-19 | Van Buren | Tennessee | 47175 | 663 | 7 |
942522 | 942522 | 2021-01-18 | Van Buren | Tennessee | 47175 | 660 | 7 |
939277 | 939277 | 2021-01-17 | Van Buren | Tennessee | 47175 | 658 | 7 |
936032 | 936032 | 2021-01-16 | Van Buren | Tennessee | 47175 | 656 | 7 |
932787 | 932787 | 2021-01-15 | Van Buren | Tennessee | 47175 | 648 | 7 |
929542 | 929542 | 2021-01-14 | Van Buren | Tennessee | 47175 | 639 | 7 |
926297 | 926297 | 2021-01-13 | Van Buren | Tennessee | 47175 | 625 | 7 |
923051 | 923051 | 2021-01-12 | Van Buren | Tennessee | 47175 | 623 | 7 |
919806 | 919806 | 2021-01-11 | Van Buren | Tennessee | 47175 | 621 | 7 |
916561 | 916561 | 2021-01-10 | Van Buren | Tennessee | 47175 | 617 | 7 |
854816 | 854816 | 2020-12-22 | Bledsoe | Tennessee | 47007 | 1478 | 7 |
851571 | 851571 | 2020-12-21 | Bledsoe | Tennessee | 47007 | 1473 | 7 |
851644 | 851644 | 2020-12-21 | Sequatchie | Tennessee | 47153 | 1027 | 7 |
851654 | 851654 | 2020-12-21 | Union | Tennessee | 47173 | 1123 | 7 |
848326 | 848326 | 2020-12-20 | Bledsoe | Tennessee | 47007 | 1454 | 7 |
848399 | 848399 | 2020-12-20 | Sequatchie | Tennessee | 47153 | 1004 | 7 |
848409 | 848409 | 2020-12-20 | Union | Tennessee | 47173 | 1102 | 7 |
845085 | 845085 | 2020-12-19 | Cannon | Tennessee | 47015 | 1207 | 7 |
845154 | 845154 | 2020-12-19 | Sequatchie | Tennessee | 47153 | 974 | 7 |
845164 | 845164 | 2020-12-19 | Union | Tennessee | 47173 | 1086 | 7 |
841839 | 841839 | 2020-12-18 | Cannon | Tennessee | 47015 | 1194 | 7 |
841908 | 841908 | 2020-12-18 | Sequatchie | Tennessee | 47153 | 956 | 7 |
841918 | 841918 | 2020-12-18 | Union | Tennessee | 47173 | 1069 | 7 |
838594 | 838594 | 2020-12-17 | Cannon | Tennessee | 47015 | 1168 | 7 |
838673 | 838673 | 2020-12-17 | Union | Tennessee | 47173 | 1045 | 7 |
835427 | 835427 | 2020-12-16 | Union | Tennessee | 47173 | 1045 | 7 |
832181 | 832181 | 2020-12-15 | Union | Tennessee | 47173 | 1025 | 7 |
806192 | 806192 | 2020-12-07 | Morgan | Tennessee | 47129 | 859 | 7 |
802930 | 802930 | 2020-12-06 | Lake | Tennessee | 47095 | 1220 | 7 |
802947 | 802947 | 2020-12-06 | Morgan | Tennessee | 47129 | 834 | 7 |
799685 | 799685 | 2020-12-05 | Lake | Tennessee | 47095 | 1209 | 7 |
799702 | 799702 | 2020-12-05 | Morgan | Tennessee | 47129 | 829 | 7 |
796440 | 796440 | 2020-12-04 | Lake | Tennessee | 47095 | 1207 | 7 |
796457 | 796457 | 2020-12-04 | Morgan | Tennessee | 47129 | 809 | 7 |
793223 | 793223 | 2020-12-03 | Scott | Tennessee | 47151 | 1173 | 7 |
789978 | 789978 | 2020-12-02 | Scott | Tennessee | 47151 | 1171 | 7 |
786733 | 786733 | 2020-12-01 | Scott | Tennessee | 47151 | 1144 | 7 |
783489 | 783489 | 2020-11-30 | Scott | Tennessee | 47151 | 1119 | 7 |
780244 | 780244 | 2020-11-29 | Scott | Tennessee | 47151 | 1085 | 7 |
780256 | 780256 | 2020-11-29 | Unknown | Tennessee | 2278 | 7 | |
776998 | 776998 | 2020-11-28 | Scott | Tennessee | 47151 | 1072 | 7 |
773753 | 773753 | 2020-11-27 | Scott | Tennessee | 47151 | 1050 | 7 |
770508 | 770508 | 2020-11-26 | Scott | Tennessee | 47151 | 1022 | 7 |
767229 | 767229 | 2020-11-25 | Humphreys | Tennessee | 47085 | 668 | 7 |
767262 | 767262 | 2020-11-25 | Scott | Tennessee | 47151 | 996 | 7 |
763984 | 763984 | 2020-11-24 | Humphreys | Tennessee | 47085 | 661 | 7 |
764017 | 764017 | 2020-11-24 | Scott | Tennessee | 47151 | 966 | 7 |
760739 | 760739 | 2020-11-23 | Humphreys | Tennessee | 47085 | 653 | 7 |
760772 | 760772 | 2020-11-23 | Scott | Tennessee | 47151 | 958 | 7 |
757494 | 757494 | 2020-11-22 | Humphreys | Tennessee | 47085 | 640 | 7 |
757527 | 757527 | 2020-11-22 | Scott | Tennessee | 47151 | 940 | 7 |
754247 | 754247 | 2020-11-21 | Humphreys | Tennessee | 47085 | 631 | 7 |
754280 | 754280 | 2020-11-21 | Scott | Tennessee | 47151 | 911 | 7 |
751001 | 751001 | 2020-11-20 | Humphreys | Tennessee | 47085 | 629 | 7 |
751034 | 751034 | 2020-11-20 | Scott | Tennessee | 47151 | 875 | 7 |
747755 | 747755 | 2020-11-19 | Humphreys | Tennessee | 47085 | 621 | 7 |
744509 | 744509 | 2020-11-18 | Humphreys | Tennessee | 47085 | 619 | 7 |
741262 | 741262 | 2020-11-17 | Humphreys | Tennessee | 47085 | 610 | 7 |
741263 | 741263 | 2020-11-17 | Jackson | Tennessee | 47087 | 629 | 7 |
738017 | 738017 | 2020-11-16 | Jackson | Tennessee | 47087 | 627 | 7 |
734773 | 734773 | 2020-11-15 | Jackson | Tennessee | 47087 | 611 | 7 |
731527 | 731527 | 2020-11-14 | Jackson | Tennessee | 47087 | 598 | 7 |
728283 | 728283 | 2020-11-13 | Jackson | Tennessee | 47087 | 596 | 7 |
728330 | 728330 | 2020-11-13 | Wayne | Tennessee | 47181 | 1684 | 7 |
725039 | 725039 | 2020-11-12 | Jackson | Tennessee | 47087 | 588 | 7 |
725087 | 725087 | 2020-11-12 | Wayne | Tennessee | 47181 | 1673 | 7 |
721796 | 721796 | 2020-11-11 | Jackson | Tennessee | 47087 | 555 | 7 |
721844 | 721844 | 2020-11-11 | Wayne | Tennessee | 47181 | 1664 | 7 |
718553 | 718553 | 2020-11-10 | Jackson | Tennessee | 47087 | 542 | 7 |
718560 | 718560 | 2020-11-10 | Lewis | Tennessee | 47101 | 600 | 7 |
718601 | 718601 | 2020-11-10 | Wayne | Tennessee | 47181 | 1659 | 7 |
715310 | 715310 | 2020-11-09 | Jackson | Tennessee | 47087 | 533 | 7 |
715317 | 715317 | 2020-11-09 | Lewis | Tennessee | 47101 | 593 | 7 |
715358 | 715358 | 2020-11-09 | Wayne | Tennessee | 47181 | 1657 | 7 |
712066 | 712066 | 2020-11-08 | Jackson | Tennessee | 47087 | 529 | 7 |
712073 | 712073 | 2020-11-08 | Lewis | Tennessee | 47101 | 572 | 7 |
712114 | 712114 | 2020-11-08 | Wayne | Tennessee | 47181 | 1648 | 7 |
708822 | 708822 | 2020-11-07 | Jackson | Tennessee | 47087 | 517 | 7 |
708829 | 708829 | 2020-11-07 | Lewis | Tennessee | 47101 | 574 | 7 |
708870 | 708870 | 2020-11-07 | Wayne | Tennessee | 47181 | 1644 | 7 |
705579 | 705579 | 2020-11-06 | Jackson | Tennessee | 47087 | 511 | 7 |
705586 | 705586 | 2020-11-06 | Lewis | Tennessee | 47101 | 551 | 7 |
705626 | 705626 | 2020-11-06 | Wayne | Tennessee | 47181 | 1640 | 7 |
702336 | 702336 | 2020-11-05 | Jackson | Tennessee | 47087 | 501 | 7 |
702343 | 702343 | 2020-11-05 | Lewis | Tennessee | 47101 | 550 | 7 |
702344 | 702344 | 2020-11-05 | Lincoln | Tennessee | 47103 | 1052 | 7 |
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);