ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
476 rows where deaths = 14 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Grundy 45
- Bedford 24
- McMinn 22
- Hamilton 20
- Jefferson 17
- Giles 16
- White 15
- Crockett 13
- Benton 12
- Hardin 11
- Marion 11
- Williamson 11
- Chester 10
- Lauderdale 10
- Stewart 10
- Lewis 9
- Meigs 9
- Polk 9
- Smith 9
- Trousdale 9
- DeKalb 8
- Anderson 7
- Bledsoe 7
- Fentress 7
- Houston 7
- Lawrence 7
- McNairy 7
- Weakley 7
- Cocke 6
- Hancock 6
- …
state 1
- Tennessee · 476 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793153 | 1793153 | 2021-10-07 | Bledsoe | Tennessee | 47007 | 3394 | 14 |
1789904 | 1789904 | 2021-10-06 | Bledsoe | Tennessee | 47007 | 3390 | 14 |
1786656 | 1786656 | 2021-10-05 | Bledsoe | Tennessee | 47007 | 3386 | 14 |
1783407 | 1783407 | 2021-10-04 | Bledsoe | Tennessee | 47007 | 3383 | 14 |
1780158 | 1780158 | 2021-10-03 | Bledsoe | Tennessee | 47007 | 3355 | 14 |
1776908 | 1776908 | 2021-10-02 | Bledsoe | Tennessee | 47007 | 3355 | 14 |
1773658 | 1773658 | 2021-10-01 | Bledsoe | Tennessee | 47007 | 3355 | 14 |
1692471 | 1692471 | 2021-09-06 | Hancock | Tennessee | 47067 | 873 | 14 |
1689222 | 1689222 | 2021-09-05 | Hancock | Tennessee | 47067 | 873 | 14 |
1685972 | 1685972 | 2021-09-04 | Hancock | Tennessee | 47067 | 873 | 14 |
1682721 | 1682721 | 2021-09-03 | Hancock | Tennessee | 47067 | 873 | 14 |
1679471 | 1679471 | 2021-09-02 | Hancock | Tennessee | 47067 | 854 | 14 |
1676223 | 1676223 | 2021-09-01 | Hancock | Tennessee | 47067 | 846 | 14 |
1010657 | 1010657 | 2021-02-08 | Moore | Tennessee | 47127 | 864 | 14 |
952256 | 952256 | 2021-01-21 | Trousdale | Tennessee | 47169 | 2294 | 14 |
949011 | 949011 | 2021-01-20 | Trousdale | Tennessee | 47169 | 2293 | 14 |
945765 | 945765 | 2021-01-19 | Trousdale | Tennessee | 47169 | 2289 | 14 |
942518 | 942518 | 2021-01-18 | Trousdale | Tennessee | 47169 | 2288 | 14 |
939253 | 939253 | 2021-01-17 | Morgan | Tennessee | 47129 | 1886 | 14 |
939273 | 939273 | 2021-01-17 | Trousdale | Tennessee | 47169 | 2287 | 14 |
936008 | 936008 | 2021-01-16 | Morgan | Tennessee | 47129 | 1871 | 14 |
936028 | 936028 | 2021-01-16 | Trousdale | Tennessee | 47169 | 2286 | 14 |
932783 | 932783 | 2021-01-15 | Trousdale | Tennessee | 47169 | 2283 | 14 |
929538 | 929538 | 2021-01-14 | Trousdale | Tennessee | 47169 | 2278 | 14 |
926293 | 926293 | 2021-01-13 | Trousdale | Tennessee | 47169 | 2274 | 14 |
903539 | 903539 | 2021-01-06 | Lake | Tennessee | 47095 | 1474 | 14 |
897049 | 897049 | 2021-01-04 | Lake | Tennessee | 47095 | 1466 | 14 |
880859 | 880859 | 2020-12-30 | Union | Tennessee | 47173 | 1208 | 14 |
877614 | 877614 | 2020-12-29 | Union | Tennessee | 47173 | 1197 | 14 |
874369 | 874369 | 2020-12-28 | Union | Tennessee | 47173 | 1189 | 14 |
871098 | 871098 | 2020-12-27 | Meigs | Tennessee | 47121 | 927 | 14 |
867853 | 867853 | 2020-12-26 | Meigs | Tennessee | 47121 | 922 | 14 |
864608 | 864608 | 2020-12-25 | Meigs | Tennessee | 47121 | 919 | 14 |
861363 | 861363 | 2020-12-24 | Meigs | Tennessee | 47121 | 889 | 14 |
858118 | 858118 | 2020-12-23 | Meigs | Tennessee | 47121 | 877 | 14 |
854873 | 854873 | 2020-12-22 | Meigs | Tennessee | 47121 | 862 | 14 |
851628 | 851628 | 2020-12-21 | Meigs | Tennessee | 47121 | 858 | 14 |
848383 | 848383 | 2020-12-20 | Meigs | Tennessee | 47121 | 840 | 14 |
845108 | 845108 | 2020-12-19 | Grundy | Tennessee | 47061 | 1056 | 14 |
845138 | 845138 | 2020-12-19 | Meigs | Tennessee | 47121 | 817 | 14 |
841862 | 841862 | 2020-12-18 | Grundy | Tennessee | 47061 | 1045 | 14 |
841907 | 841907 | 2020-12-18 | Scott | Tennessee | 47151 | 1685 | 14 |
838617 | 838617 | 2020-12-17 | Grundy | Tennessee | 47061 | 1030 | 14 |
835371 | 835371 | 2020-12-16 | Grundy | Tennessee | 47061 | 1002 | 14 |
832125 | 832125 | 2020-12-15 | Grundy | Tennessee | 47061 | 978 | 14 |
828878 | 828878 | 2020-12-14 | Grundy | Tennessee | 47061 | 962 | 14 |
825632 | 825632 | 2020-12-13 | Grundy | Tennessee | 47061 | 943 | 14 |
822385 | 822385 | 2020-12-12 | Grundy | Tennessee | 47061 | 913 | 14 |
822446 | 822446 | 2020-12-12 | Wayne | Tennessee | 47181 | 2102 | 14 |
819139 | 819139 | 2020-12-11 | Grundy | Tennessee | 47061 | 906 | 14 |
819200 | 819200 | 2020-12-11 | Wayne | Tennessee | 47181 | 2086 | 14 |
815883 | 815883 | 2020-12-10 | Decatur | Tennessee | 47039 | 1026 | 14 |
815893 | 815893 | 2020-12-10 | Grundy | Tennessee | 47061 | 898 | 14 |
812637 | 812637 | 2020-12-09 | Decatur | Tennessee | 47039 | 1013 | 14 |
812647 | 812647 | 2020-12-09 | Grundy | Tennessee | 47061 | 881 | 14 |
809393 | 809393 | 2020-12-08 | Decatur | Tennessee | 47039 | 1000 | 14 |
809403 | 809403 | 2020-12-08 | Grundy | Tennessee | 47061 | 865 | 14 |
806158 | 806158 | 2020-12-07 | Grundy | Tennessee | 47061 | 854 | 14 |
802913 | 802913 | 2020-12-06 | Grundy | Tennessee | 47061 | 840 | 14 |
802970 | 802970 | 2020-12-06 | Unknown | Tennessee | 0 | 14 | |
799668 | 799668 | 2020-12-05 | Grundy | Tennessee | 47061 | 824 | 14 |
796423 | 796423 | 2020-12-04 | Grundy | Tennessee | 47061 | 815 | 14 |
796461 | 796461 | 2020-12-04 | Pickett | Tennessee | 47137 | 407 | 14 |
793178 | 793178 | 2020-12-03 | Grundy | Tennessee | 47061 | 806 | 14 |
793216 | 793216 | 2020-12-03 | Pickett | Tennessee | 47137 | 398 | 14 |
789905 | 789905 | 2020-12-02 | Benton | Tennessee | 47005 | 871 | 14 |
789933 | 789933 | 2020-12-02 | Grundy | Tennessee | 47061 | 803 | 14 |
789971 | 789971 | 2020-12-02 | Pickett | Tennessee | 47137 | 398 | 14 |
786660 | 786660 | 2020-12-01 | Benton | Tennessee | 47005 | 864 | 14 |
786688 | 786688 | 2020-12-01 | Grundy | Tennessee | 47061 | 800 | 14 |
786708 | 786708 | 2020-12-01 | Lewis | Tennessee | 47101 | 787 | 14 |
786726 | 786726 | 2020-12-01 | Pickett | Tennessee | 47137 | 400 | 14 |
783416 | 783416 | 2020-11-30 | Benton | Tennessee | 47005 | 842 | 14 |
783444 | 783444 | 2020-11-30 | Grundy | Tennessee | 47061 | 792 | 14 |
783464 | 783464 | 2020-11-30 | Lewis | Tennessee | 47101 | 777 | 14 |
780171 | 780171 | 2020-11-29 | Benton | Tennessee | 47005 | 816 | 14 |
780199 | 780199 | 2020-11-29 | Grundy | Tennessee | 47061 | 779 | 14 |
780219 | 780219 | 2020-11-29 | Lewis | Tennessee | 47101 | 765 | 14 |
776925 | 776925 | 2020-11-28 | Benton | Tennessee | 47005 | 813 | 14 |
776953 | 776953 | 2020-11-28 | Grundy | Tennessee | 47061 | 777 | 14 |
776973 | 776973 | 2020-11-28 | Lewis | Tennessee | 47101 | 763 | 14 |
773680 | 773680 | 2020-11-27 | Benton | Tennessee | 47005 | 787 | 14 |
773708 | 773708 | 2020-11-27 | Grundy | Tennessee | 47061 | 769 | 14 |
773728 | 773728 | 2020-11-27 | Lewis | Tennessee | 47101 | 747 | 14 |
773729 | 773729 | 2020-11-27 | Lincoln | Tennessee | 47103 | 1579 | 14 |
770435 | 770435 | 2020-11-26 | Benton | Tennessee | 47005 | 777 | 14 |
770463 | 770463 | 2020-11-26 | Grundy | Tennessee | 47061 | 756 | 14 |
770483 | 770483 | 2020-11-26 | Lewis | Tennessee | 47101 | 736 | 14 |
770484 | 770484 | 2020-11-26 | Lincoln | Tennessee | 47103 | 1549 | 14 |
767217 | 767217 | 2020-11-25 | Grundy | Tennessee | 47061 | 749 | 14 |
767237 | 767237 | 2020-11-25 | Lewis | Tennessee | 47101 | 727 | 14 |
767238 | 767238 | 2020-11-25 | Lincoln | Tennessee | 47103 | 1494 | 14 |
767267 | 767267 | 2020-11-25 | Stewart | Tennessee | 47161 | 572 | 14 |
763972 | 763972 | 2020-11-24 | Grundy | Tennessee | 47061 | 742 | 14 |
763992 | 763992 | 2020-11-24 | Lewis | Tennessee | 47101 | 719 | 14 |
764011 | 764011 | 2020-11-24 | Polk | Tennessee | 47139 | 637 | 14 |
764022 | 764022 | 2020-11-24 | Stewart | Tennessee | 47161 | 569 | 14 |
760699 | 760699 | 2020-11-23 | Benton | Tennessee | 47005 | 761 | 14 |
760727 | 760727 | 2020-11-23 | Grundy | Tennessee | 47061 | 742 | 14 |
760747 | 760747 | 2020-11-23 | Lewis | Tennessee | 47101 | 715 | 14 |
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);