ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
428 rows where deaths = 8 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fayette 27
- Wilson 25
- Hardin 18
- Obion 18
- Smith 18
- Anderson 17
- Humphreys 16
- Grundy 15
- Claiborne 12
- Tipton 12
- Lincoln 11
- Benton 10
- Cumberland 10
- Henry 9
- Meigs 9
- Overton 9
- Warren 9
- White 9
- Chester 8
- Hickman 8
- Lawrence 7
- Loudon 7
- Marion 7
- Marshall 7
- Morgan 6
- Roane 6
- Carroll 5
- Lauderdale 5
- Dyer 4
- Jackson 4
- …
state 1
- Tennessee · 428 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
991151 | 991151 | 2021-02-02 | Hancock | Tennessee | 47067 | 443 | 8 |
987905 | 987905 | 2021-02-01 | Hancock | Tennessee | 47067 | 441 | 8 |
965241 | 965241 | 2021-01-25 | Van Buren | Tennessee | 47175 | 675 | 8 |
961996 | 961996 | 2021-01-24 | Van Buren | Tennessee | 47175 | 674 | 8 |
958751 | 958751 | 2021-01-23 | Van Buren | Tennessee | 47175 | 673 | 8 |
932762 | 932762 | 2021-01-15 | Moore | Tennessee | 47127 | 788 | 8 |
929517 | 929517 | 2021-01-14 | Moore | Tennessee | 47127 | 785 | 8 |
926272 | 926272 | 2021-01-13 | Moore | Tennessee | 47127 | 782 | 8 |
848330 | 848330 | 2020-12-20 | Cannon | Tennessee | 47015 | 1227 | 8 |
838629 | 838629 | 2020-12-17 | Humphreys | Tennessee | 47085 | 991 | 8 |
835383 | 835383 | 2020-12-16 | Humphreys | Tennessee | 47085 | 979 | 8 |
832137 | 832137 | 2020-12-15 | Humphreys | Tennessee | 47085 | 936 | 8 |
828890 | 828890 | 2020-12-14 | Humphreys | Tennessee | 47085 | 925 | 8 |
825644 | 825644 | 2020-12-13 | Humphreys | Tennessee | 47085 | 901 | 8 |
825666 | 825666 | 2020-12-13 | Morgan | Tennessee | 47129 | 1046 | 8 |
822397 | 822397 | 2020-12-12 | Humphreys | Tennessee | 47085 | 883 | 8 |
822419 | 822419 | 2020-12-12 | Morgan | Tennessee | 47129 | 994 | 8 |
819151 | 819151 | 2020-12-11 | Humphreys | Tennessee | 47085 | 867 | 8 |
819173 | 819173 | 2020-12-11 | Morgan | Tennessee | 47129 | 972 | 8 |
815905 | 815905 | 2020-12-10 | Humphreys | Tennessee | 47085 | 858 | 8 |
815910 | 815910 | 2020-12-10 | Lake | Tennessee | 47095 | 1268 | 8 |
815927 | 815927 | 2020-12-10 | Morgan | Tennessee | 47129 | 938 | 8 |
812659 | 812659 | 2020-12-09 | Humphreys | Tennessee | 47085 | 844 | 8 |
812664 | 812664 | 2020-12-09 | Lake | Tennessee | 47095 | 1260 | 8 |
812681 | 812681 | 2020-12-09 | Morgan | Tennessee | 47129 | 920 | 8 |
809420 | 809420 | 2020-12-08 | Lake | Tennessee | 47095 | 1244 | 8 |
809437 | 809437 | 2020-12-08 | Morgan | Tennessee | 47129 | 881 | 8 |
806175 | 806175 | 2020-12-07 | Lake | Tennessee | 47095 | 1235 | 8 |
802958 | 802958 | 2020-12-06 | Scott | Tennessee | 47151 | 1228 | 8 |
799713 | 799713 | 2020-12-05 | Scott | Tennessee | 47151 | 1198 | 8 |
796468 | 796468 | 2020-12-04 | Scott | Tennessee | 47151 | 1177 | 8 |
793190 | 793190 | 2020-12-03 | Humphreys | Tennessee | 47085 | 764 | 8 |
789945 | 789945 | 2020-12-02 | Humphreys | Tennessee | 47085 | 760 | 8 |
786700 | 786700 | 2020-12-01 | Humphreys | Tennessee | 47085 | 750 | 8 |
783456 | 783456 | 2020-11-30 | Humphreys | Tennessee | 47085 | 741 | 8 |
780211 | 780211 | 2020-11-29 | Humphreys | Tennessee | 47085 | 719 | 8 |
776965 | 776965 | 2020-11-28 | Humphreys | Tennessee | 47085 | 709 | 8 |
777010 | 777010 | 2020-11-28 | Unknown | Tennessee | 2198 | 8 | |
773720 | 773720 | 2020-11-27 | Humphreys | Tennessee | 47085 | 694 | 8 |
741311 | 741311 | 2020-11-17 | Wayne | Tennessee | 47181 | 1726 | 8 |
738025 | 738025 | 2020-11-16 | Lincoln | Tennessee | 47103 | 1308 | 8 |
738065 | 738065 | 2020-11-16 | Wayne | Tennessee | 47181 | 1712 | 8 |
734781 | 734781 | 2020-11-15 | Lincoln | Tennessee | 47103 | 1271 | 8 |
734821 | 734821 | 2020-11-15 | Wayne | Tennessee | 47181 | 1695 | 8 |
731535 | 731535 | 2020-11-14 | Lincoln | Tennessee | 47103 | 1257 | 8 |
731575 | 731575 | 2020-11-14 | Wayne | Tennessee | 47181 | 1687 | 8 |
728291 | 728291 | 2020-11-13 | Lincoln | Tennessee | 47103 | 1215 | 8 |
725024 | 725024 | 2020-11-12 | Grainger | Tennessee | 47057 | 768 | 8 |
725046 | 725046 | 2020-11-12 | Lewis | Tennessee | 47101 | 615 | 8 |
725047 | 725047 | 2020-11-12 | Lincoln | Tennessee | 47103 | 1202 | 8 |
721803 | 721803 | 2020-11-11 | Lewis | Tennessee | 47101 | 607 | 8 |
721804 | 721804 | 2020-11-11 | Lincoln | Tennessee | 47103 | 1172 | 8 |
721813 | 721813 | 2020-11-11 | Meigs | Tennessee | 47121 | 395 | 8 |
718522 | 718522 | 2020-11-10 | Claiborne | Tennessee | 47025 | 596 | 8 |
718561 | 718561 | 2020-11-10 | Lincoln | Tennessee | 47103 | 1142 | 8 |
718570 | 718570 | 2020-11-10 | Meigs | Tennessee | 47121 | 388 | 8 |
715279 | 715279 | 2020-11-09 | Claiborne | Tennessee | 47025 | 587 | 8 |
715318 | 715318 | 2020-11-09 | Lincoln | Tennessee | 47103 | 1130 | 8 |
715327 | 715327 | 2020-11-09 | Meigs | Tennessee | 47121 | 383 | 8 |
712035 | 712035 | 2020-11-08 | Claiborne | Tennessee | 47025 | 578 | 8 |
712074 | 712074 | 2020-11-08 | Lincoln | Tennessee | 47103 | 1096 | 8 |
712083 | 712083 | 2020-11-08 | Meigs | Tennessee | 47121 | 379 | 8 |
708791 | 708791 | 2020-11-07 | Claiborne | Tennessee | 47025 | 571 | 8 |
708830 | 708830 | 2020-11-07 | Lincoln | Tennessee | 47103 | 1079 | 8 |
708839 | 708839 | 2020-11-07 | Meigs | Tennessee | 47121 | 372 | 8 |
705548 | 705548 | 2020-11-06 | Claiborne | Tennessee | 47025 | 565 | 8 |
705587 | 705587 | 2020-11-06 | Lincoln | Tennessee | 47103 | 1057 | 8 |
705596 | 705596 | 2020-11-06 | Meigs | Tennessee | 47121 | 363 | 8 |
702305 | 702305 | 2020-11-05 | Claiborne | Tennessee | 47025 | 565 | 8 |
702353 | 702353 | 2020-11-05 | Meigs | Tennessee | 47121 | 359 | 8 |
699061 | 699061 | 2020-11-04 | Claiborne | Tennessee | 47025 | 558 | 8 |
699109 | 699109 | 2020-11-04 | Meigs | Tennessee | 47121 | 354 | 8 |
695818 | 695818 | 2020-11-03 | Claiborne | Tennessee | 47025 | 557 | 8 |
695866 | 695866 | 2020-11-03 | Meigs | Tennessee | 47121 | 353 | 8 |
692576 | 692576 | 2020-11-02 | Claiborne | Tennessee | 47025 | 556 | 8 |
692607 | 692607 | 2020-11-02 | Jackson | Tennessee | 47087 | 488 | 8 |
692636 | 692636 | 2020-11-02 | Roane | Tennessee | 47145 | 1528 | 8 |
689332 | 689332 | 2020-11-01 | Claiborne | Tennessee | 47025 | 556 | 8 |
689363 | 689363 | 2020-11-01 | Jackson | Tennessee | 47087 | 484 | 8 |
689365 | 689365 | 2020-11-01 | Johnson | Tennessee | 47091 | 1222 | 8 |
689392 | 689392 | 2020-11-01 | Roane | Tennessee | 47145 | 1461 | 8 |
686087 | 686087 | 2020-10-31 | Claiborne | Tennessee | 47025 | 555 | 8 |
686118 | 686118 | 2020-10-31 | Jackson | Tennessee | 47087 | 483 | 8 |
686120 | 686120 | 2020-10-31 | Johnson | Tennessee | 47091 | 1220 | 8 |
686147 | 686147 | 2020-10-31 | Roane | Tennessee | 47145 | 1460 | 8 |
682844 | 682844 | 2020-10-30 | Claiborne | Tennessee | 47025 | 549 | 8 |
682875 | 682875 | 2020-10-30 | Jackson | Tennessee | 47087 | 477 | 8 |
682877 | 682877 | 2020-10-30 | Johnson | Tennessee | 47091 | 1211 | 8 |
682899 | 682899 | 2020-10-30 | Perry | Tennessee | 47135 | 350 | 8 |
682904 | 682904 | 2020-10-30 | Roane | Tennessee | 47145 | 1447 | 8 |
679661 | 679661 | 2020-10-29 | Roane | Tennessee | 47145 | 1420 | 8 |
676418 | 676418 | 2020-10-28 | Roane | Tennessee | 47145 | 1387 | 8 |
673187 | 673187 | 2020-10-27 | Trousdale | Tennessee | 47169 | 1777 | 8 |
669929 | 669929 | 2020-10-26 | Pickett | Tennessee | 47137 | 274 | 8 |
669945 | 669945 | 2020-10-26 | Trousdale | Tennessee | 47169 | 1776 | 8 |
666701 | 666701 | 2020-10-25 | Trousdale | Tennessee | 47169 | 1775 | 8 |
656890 | 656890 | 2020-10-22 | Campbell | Tennessee | 47013 | 911 | 8 |
656908 | 656908 | 2020-10-22 | Fentress | Tennessee | 47049 | 877 | 8 |
656964 | 656964 | 2020-10-22 | Stewart | Tennessee | 47161 | 312 | 8 |
653663 | 653663 | 2020-10-21 | Fentress | Tennessee | 47049 | 869 | 8 |
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);