ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
481 rows where deaths = 9 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Benton 40
- Marion 25
- Claiborne 22
- Cocke 16
- Monroe 16
- Cheatham 15
- Dyer 15
- Bledsoe 14
- Dickson 14
- Henry 13
- Warren 13
- Moore 12
- Lawrence 11
- Tipton 11
- Greene 10
- White 10
- Hancock 9
- Obion 9
- Lauderdale 8
- Montgomery 8
- Pickett 8
- Robertson 8
- Humphreys 7
- Williamson 7
- Bedford 6
- Cumberland 6
- DeKalb 6
- Sevier 6
- Trousdale 6
- Chester 5
- …
state 1
- Tennessee · 481 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1020362 | 1020362 | 2021-02-11 | Hancock | Tennessee | 47067 | 480 | 9 |
1017117 | 1017117 | 2021-02-10 | Hancock | Tennessee | 47067 | 481 | 9 |
1013872 | 1013872 | 2021-02-09 | Hancock | Tennessee | 47067 | 464 | 9 |
1010627 | 1010627 | 2021-02-08 | Hancock | Tennessee | 47067 | 452 | 9 |
1007381 | 1007381 | 2021-02-07 | Hancock | Tennessee | 47067 | 452 | 9 |
1004135 | 1004135 | 2021-02-06 | Hancock | Tennessee | 47067 | 452 | 9 |
1000889 | 1000889 | 2021-02-05 | Hancock | Tennessee | 47067 | 445 | 9 |
997643 | 997643 | 2021-02-04 | Hancock | Tennessee | 47067 | 445 | 9 |
994397 | 994397 | 2021-02-03 | Hancock | Tennessee | 47067 | 445 | 9 |
978220 | 978220 | 2021-01-29 | Van Buren | Tennessee | 47175 | 680 | 9 |
974975 | 974975 | 2021-01-28 | Van Buren | Tennessee | 47175 | 675 | 9 |
971705 | 971705 | 2021-01-27 | Moore | Tennessee | 47127 | 838 | 9 |
971730 | 971730 | 2021-01-27 | Van Buren | Tennessee | 47175 | 674 | 9 |
968460 | 968460 | 2021-01-26 | Moore | Tennessee | 47127 | 835 | 9 |
968485 | 968485 | 2021-01-26 | Van Buren | Tennessee | 47175 | 676 | 9 |
965216 | 965216 | 2021-01-25 | Moore | Tennessee | 47127 | 831 | 9 |
961971 | 961971 | 2021-01-24 | Moore | Tennessee | 47127 | 829 | 9 |
958726 | 958726 | 2021-01-23 | Moore | Tennessee | 47127 | 834 | 9 |
955480 | 955480 | 2021-01-22 | Moore | Tennessee | 47127 | 829 | 9 |
952235 | 952235 | 2021-01-21 | Moore | Tennessee | 47127 | 829 | 9 |
948990 | 948990 | 2021-01-20 | Moore | Tennessee | 47127 | 817 | 9 |
945744 | 945744 | 2021-01-19 | Moore | Tennessee | 47127 | 808 | 9 |
942497 | 942497 | 2021-01-18 | Moore | Tennessee | 47127 | 800 | 9 |
939252 | 939252 | 2021-01-17 | Moore | Tennessee | 47127 | 795 | 9 |
936007 | 936007 | 2021-01-16 | Moore | Tennessee | 47127 | 794 | 9 |
900250 | 900250 | 2021-01-05 | Bledsoe | Tennessee | 47007 | 1637 | 9 |
897005 | 897005 | 2021-01-04 | Bledsoe | Tennessee | 47007 | 1634 | 9 |
893759 | 893759 | 2021-01-03 | Bledsoe | Tennessee | 47007 | 1631 | 9 |
890513 | 890513 | 2021-01-02 | Bledsoe | Tennessee | 47007 | 1622 | 9 |
887266 | 887266 | 2021-01-01 | Bledsoe | Tennessee | 47007 | 1565 | 9 |
884021 | 884021 | 2020-12-31 | Bledsoe | Tennessee | 47007 | 1565 | 9 |
880776 | 880776 | 2020-12-30 | Bledsoe | Tennessee | 47007 | 1559 | 9 |
877531 | 877531 | 2020-12-29 | Bledsoe | Tennessee | 47007 | 1542 | 9 |
874286 | 874286 | 2020-12-28 | Bledsoe | Tennessee | 47007 | 1538 | 9 |
871041 | 871041 | 2020-12-27 | Bledsoe | Tennessee | 47007 | 1535 | 9 |
867796 | 867796 | 2020-12-26 | Bledsoe | Tennessee | 47007 | 1530 | 9 |
864551 | 864551 | 2020-12-25 | Bledsoe | Tennessee | 47007 | 1520 | 9 |
861306 | 861306 | 2020-12-24 | Bledsoe | Tennessee | 47007 | 1493 | 9 |
858061 | 858061 | 2020-12-23 | Bledsoe | Tennessee | 47007 | 1488 | 9 |
854820 | 854820 | 2020-12-22 | Cannon | Tennessee | 47015 | 1266 | 9 |
854899 | 854899 | 2020-12-22 | Union | Tennessee | 47173 | 1130 | 9 |
851575 | 851575 | 2020-12-21 | Cannon | Tennessee | 47015 | 1250 | 9 |
841874 | 841874 | 2020-12-18 | Humphreys | Tennessee | 47085 | 1018 | 9 |
828912 | 828912 | 2020-12-14 | Morgan | Tennessee | 47129 | 1091 | 9 |
822402 | 822402 | 2020-12-12 | Lake | Tennessee | 47095 | 1282 | 9 |
819156 | 819156 | 2020-12-11 | Lake | Tennessee | 47095 | 1274 | 9 |
815938 | 815938 | 2020-12-10 | Scott | Tennessee | 47151 | 1376 | 9 |
812692 | 812692 | 2020-12-09 | Scott | Tennessee | 47151 | 1342 | 9 |
809415 | 809415 | 2020-12-08 | Humphreys | Tennessee | 47085 | 834 | 9 |
809448 | 809448 | 2020-12-08 | Scott | Tennessee | 47151 | 1290 | 9 |
806170 | 806170 | 2020-12-07 | Humphreys | Tennessee | 47085 | 833 | 9 |
806203 | 806203 | 2020-12-07 | Scott | Tennessee | 47151 | 1271 | 9 |
802925 | 802925 | 2020-12-06 | Humphreys | Tennessee | 47085 | 793 | 9 |
799680 | 799680 | 2020-12-05 | Humphreys | Tennessee | 47085 | 786 | 9 |
796435 | 796435 | 2020-12-04 | Humphreys | Tennessee | 47085 | 770 | 9 |
789915 | 789915 | 2020-12-02 | Claiborne | Tennessee | 47025 | 963 | 9 |
786670 | 786670 | 2020-12-01 | Claiborne | Tennessee | 47025 | 933 | 9 |
783426 | 783426 | 2020-11-30 | Claiborne | Tennessee | 47025 | 897 | 9 |
780181 | 780181 | 2020-11-29 | Claiborne | Tennessee | 47025 | 849 | 9 |
776935 | 776935 | 2020-11-28 | Claiborne | Tennessee | 47025 | 836 | 9 |
773690 | 773690 | 2020-11-27 | Claiborne | Tennessee | 47025 | 802 | 9 |
770445 | 770445 | 2020-11-26 | Claiborne | Tennessee | 47025 | 788 | 9 |
770475 | 770475 | 2020-11-26 | Humphreys | Tennessee | 47085 | 681 | 9 |
767199 | 767199 | 2020-11-25 | Claiborne | Tennessee | 47025 | 777 | 9 |
763954 | 763954 | 2020-11-24 | Claiborne | Tennessee | 47025 | 753 | 9 |
760709 | 760709 | 2020-11-23 | Claiborne | Tennessee | 47025 | 755 | 9 |
757464 | 757464 | 2020-11-22 | Claiborne | Tennessee | 47025 | 750 | 9 |
757495 | 757495 | 2020-11-22 | Jackson | Tennessee | 47087 | 657 | 9 |
754217 | 754217 | 2020-11-21 | Claiborne | Tennessee | 47025 | 734 | 9 |
754248 | 754248 | 2020-11-21 | Jackson | Tennessee | 47087 | 652 | 9 |
750971 | 750971 | 2020-11-20 | Claiborne | Tennessee | 47025 | 718 | 9 |
751002 | 751002 | 2020-11-20 | Jackson | Tennessee | 47087 | 650 | 9 |
747725 | 747725 | 2020-11-19 | Claiborne | Tennessee | 47025 | 698 | 9 |
747756 | 747756 | 2020-11-19 | Jackson | Tennessee | 47087 | 639 | 9 |
747804 | 747804 | 2020-11-19 | Wayne | Tennessee | 47181 | 1749 | 9 |
744479 | 744479 | 2020-11-18 | Claiborne | Tennessee | 47025 | 690 | 9 |
744510 | 744510 | 2020-11-18 | Jackson | Tennessee | 47087 | 634 | 9 |
744558 | 744558 | 2020-11-18 | Wayne | Tennessee | 47181 | 1738 | 9 |
741232 | 741232 | 2020-11-17 | Claiborne | Tennessee | 47025 | 673 | 9 |
741270 | 741270 | 2020-11-17 | Lewis | Tennessee | 47101 | 671 | 9 |
737986 | 737986 | 2020-11-16 | Claiborne | Tennessee | 47025 | 667 | 9 |
738002 | 738002 | 2020-11-16 | Grainger | Tennessee | 47057 | 824 | 9 |
738024 | 738024 | 2020-11-16 | Lewis | Tennessee | 47101 | 666 | 9 |
734742 | 734742 | 2020-11-15 | Claiborne | Tennessee | 47025 | 645 | 9 |
734758 | 734758 | 2020-11-15 | Grainger | Tennessee | 47057 | 806 | 9 |
734780 | 734780 | 2020-11-15 | Lewis | Tennessee | 47101 | 647 | 9 |
731496 | 731496 | 2020-11-14 | Claiborne | Tennessee | 47025 | 634 | 9 |
731512 | 731512 | 2020-11-14 | Grainger | Tennessee | 47057 | 790 | 9 |
731534 | 731534 | 2020-11-14 | Lewis | Tennessee | 47101 | 640 | 9 |
728252 | 728252 | 2020-11-13 | Claiborne | Tennessee | 47025 | 623 | 9 |
728268 | 728268 | 2020-11-13 | Grainger | Tennessee | 47057 | 785 | 9 |
728290 | 728290 | 2020-11-13 | Lewis | Tennessee | 47101 | 627 | 9 |
725008 | 725008 | 2020-11-12 | Claiborne | Tennessee | 47025 | 618 | 9 |
721765 | 721765 | 2020-11-11 | Claiborne | Tennessee | 47025 | 605 | 9 |
699121 | 699121 | 2020-11-04 | Roane | Tennessee | 47145 | 1552 | 9 |
695874 | 695874 | 2020-11-03 | Pickett | Tennessee | 47137 | 293 | 9 |
695878 | 695878 | 2020-11-03 | Roane | Tennessee | 47145 | 1535 | 9 |
692609 | 692609 | 2020-11-02 | Johnson | Tennessee | 47091 | 1232 | 9 |
692631 | 692631 | 2020-11-02 | Perry | Tennessee | 47135 | 364 | 9 |
692632 | 692632 | 2020-11-02 | Pickett | Tennessee | 47137 | 290 | 9 |
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);