ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-11-23" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
760697 | 760697 | 2020-11-23 | Anderson | Tennessee | 47001 | 2737 | 25 |
760698 | 760698 | 2020-11-23 | Bedford | Tennessee | 47003 | 2544 | 28 |
760699 | 760699 | 2020-11-23 | Benton | Tennessee | 47005 | 761 | 14 |
760700 | 760700 | 2020-11-23 | Bledsoe | Tennessee | 47007 | 1142 | 5 |
760701 | 760701 | 2020-11-23 | Blount | Tennessee | 47009 | 5123 | 56 |
760702 | 760702 | 2020-11-23 | Bradley | Tennessee | 47011 | 4832 | 33 |
760703 | 760703 | 2020-11-23 | Campbell | Tennessee | 47013 | 1476 | 21 |
760704 | 760704 | 2020-11-23 | Cannon | Tennessee | 47015 | 707 | 2 |
760705 | 760705 | 2020-11-23 | Carroll | Tennessee | 47017 | 1647 | 32 |
760706 | 760706 | 2020-11-23 | Carter | Tennessee | 47019 | 2534 | 53 |
760707 | 760707 | 2020-11-23 | Cheatham | Tennessee | 47021 | 1494 | 16 |
760708 | 760708 | 2020-11-23 | Chester | Tennessee | 47023 | 988 | 19 |
760709 | 760709 | 2020-11-23 | Claiborne | Tennessee | 47025 | 755 | 9 |
760710 | 760710 | 2020-11-23 | Clay | Tennessee | 47027 | 525 | 18 |
760711 | 760711 | 2020-11-23 | Cocke | Tennessee | 47029 | 1549 | 28 |
760712 | 760712 | 2020-11-23 | Coffee | Tennessee | 47031 | 2630 | 41 |
760713 | 760713 | 2020-11-23 | Crockett | Tennessee | 47033 | 1110 | 25 |
760714 | 760714 | 2020-11-23 | Cumberland | Tennessee | 47035 | 2423 | 35 |
760715 | 760715 | 2020-11-23 | Davidson | Tennessee | 47037 | 43395 | 407 |
760716 | 760716 | 2020-11-23 | DeKalb | Tennessee | 47041 | 1089 | 20 |
760717 | 760717 | 2020-11-23 | Decatur | Tennessee | 47039 | 915 | 12 |
760718 | 760718 | 2020-11-23 | Dickson | Tennessee | 47043 | 2728 | 27 |
760719 | 760719 | 2020-11-23 | Dyer | Tennessee | 47045 | 3086 | 49 |
760720 | 760720 | 2020-11-23 | Fayette | Tennessee | 47047 | 2144 | 37 |
760721 | 760721 | 2020-11-23 | Fentress | Tennessee | 47049 | 1171 | 19 |
760722 | 760722 | 2020-11-23 | Franklin | Tennessee | 47051 | 1936 | 32 |
760723 | 760723 | 2020-11-23 | Gibson | Tennessee | 47053 | 3011 | 61 |
760724 | 760724 | 2020-11-23 | Giles | Tennessee | 47055 | 1356 | 43 |
760725 | 760725 | 2020-11-23 | Grainger | Tennessee | 47057 | 923 | 15 |
760726 | 760726 | 2020-11-23 | Greene | Tennessee | 47059 | 2859 | 71 |
760727 | 760727 | 2020-11-23 | Grundy | Tennessee | 47061 | 742 | 14 |
760728 | 760728 | 2020-11-23 | Hamblen | Tennessee | 47063 | 3315 | 57 |
760729 | 760729 | 2020-11-23 | Hamilton | Tennessee | 47065 | 16681 | 136 |
760730 | 760730 | 2020-11-23 | Hancock | Tennessee | 47067 | 147 | 3 |
760731 | 760731 | 2020-11-23 | Hardeman | Tennessee | 47069 | 2210 | 37 |
760732 | 760732 | 2020-11-23 | Hardin | Tennessee | 47071 | 1718 | 25 |
760733 | 760733 | 2020-11-23 | Hawkins | Tennessee | 47073 | 1814 | 34 |
760734 | 760734 | 2020-11-23 | Haywood | Tennessee | 47075 | 1596 | 29 |
760735 | 760735 | 2020-11-23 | Henderson | Tennessee | 47077 | 1787 | 30 |
760736 | 760736 | 2020-11-23 | Henry | Tennessee | 47079 | 1446 | 17 |
760737 | 760737 | 2020-11-23 | Hickman | Tennessee | 47081 | 1115 | 17 |
760738 | 760738 | 2020-11-23 | Houston | Tennessee | 47083 | 573 | 19 |
760739 | 760739 | 2020-11-23 | Humphreys | Tennessee | 47085 | 653 | 7 |
760740 | 760740 | 2020-11-23 | Jackson | Tennessee | 47087 | 660 | 10 |
760741 | 760741 | 2020-11-23 | Jefferson | Tennessee | 47089 | 2153 | 31 |
760742 | 760742 | 2020-11-23 | Johnson | Tennessee | 47091 | 1376 | 21 |
760743 | 760743 | 2020-11-23 | Knox | Tennessee | 47093 | 18017 | 152 |
760744 | 760744 | 2020-11-23 | Lake | Tennessee | 47095 | 1151 | 5 |
760745 | 760745 | 2020-11-23 | Lauderdale | Tennessee | 47097 | 2003 | 21 |
760746 | 760746 | 2020-11-23 | Lawrence | Tennessee | 47099 | 2507 | 32 |
760747 | 760747 | 2020-11-23 | Lewis | Tennessee | 47101 | 715 | 14 |
760748 | 760748 | 2020-11-23 | Lincoln | Tennessee | 47103 | 1463 | 13 |
760749 | 760749 | 2020-11-23 | Loudon | Tennessee | 47105 | 2184 | 18 |
760750 | 760750 | 2020-11-23 | Macon | Tennessee | 47111 | 1764 | 27 |
760751 | 760751 | 2020-11-23 | Madison | Tennessee | 47113 | 5108 | 105 |
760752 | 760752 | 2020-11-23 | Marion | Tennessee | 47115 | 1039 | 17 |
760753 | 760753 | 2020-11-23 | Marshall | Tennessee | 47117 | 1653 | 17 |
760754 | 760754 | 2020-11-23 | Maury | Tennessee | 47119 | 5549 | 58 |
760755 | 760755 | 2020-11-23 | McMinn | Tennessee | 47107 | 2343 | 55 |
760756 | 760756 | 2020-11-23 | McNairy | Tennessee | 47109 | 1376 | 32 |
760757 | 760757 | 2020-11-23 | Meigs | Tennessee | 47121 | 461 | 12 |
760758 | 760758 | 2020-11-23 | Monroe | Tennessee | 47123 | 1990 | 42 |
760759 | 760759 | 2020-11-23 | Montgomery | Tennessee | 47125 | 6223 | 81 |
760760 | 760760 | 2020-11-23 | Moore | Tennessee | 47127 | 369 | 2 |
760761 | 760761 | 2020-11-23 | Morgan | Tennessee | 47129 | 672 | 6 |
760762 | 760762 | 2020-11-23 | Obion | Tennessee | 47131 | 2522 | 47 |
760763 | 760763 | 2020-11-23 | Overton | Tennessee | 47133 | 1505 | 34 |
760764 | 760764 | 2020-11-23 | Perry | Tennessee | 47135 | 460 | 20 |
760765 | 760765 | 2020-11-23 | Pickett | Tennessee | 47137 | 366 | 12 |
760766 | 760766 | 2020-11-23 | Polk | Tennessee | 47139 | 632 | 14 |
760767 | 760767 | 2020-11-23 | Putnam | Tennessee | 47141 | 5743 | 79 |
760768 | 760768 | 2020-11-23 | Rhea | Tennessee | 47143 | 1571 | 30 |
760769 | 760769 | 2020-11-23 | Roane | Tennessee | 47145 | 2204 | 24 |
760770 | 760770 | 2020-11-23 | Robertson | Tennessee | 47147 | 3573 | 51 |
760771 | 760771 | 2020-11-23 | Rutherford | Tennessee | 47149 | 16907 | 150 |
760772 | 760772 | 2020-11-23 | Scott | Tennessee | 47151 | 958 | 7 |
760773 | 760773 | 2020-11-23 | Sequatchie | Tennessee | 47153 | 496 | 5 |
760774 | 760774 | 2020-11-23 | Sevier | Tennessee | 47155 | 4681 | 31 |
760775 | 760775 | 2020-11-23 | Shelby | Tennessee | 47157 | 45952 | 637 |
760776 | 760776 | 2020-11-23 | Smith | Tennessee | 47159 | 1383 | 19 |
760777 | 760777 | 2020-11-23 | Stewart | Tennessee | 47161 | 554 | 14 |
760778 | 760778 | 2020-11-23 | Sullivan | Tennessee | 47163 | 6093 | 89 |
760779 | 760779 | 2020-11-23 | Sumner | Tennessee | 47165 | 9141 | 134 |
760780 | 760780 | 2020-11-23 | Tipton | Tennessee | 47167 | 3487 | 36 |
760781 | 760781 | 2020-11-23 | Trousdale | Tennessee | 47169 | 1894 | 12 |
760782 | 760782 | 2020-11-23 | Unicoi | Tennessee | 47171 | 785 | 25 |
760783 | 760783 | 2020-11-23 | Union | Tennessee | 47173 | 691 | 5 |
760784 | 760784 | 2020-11-23 | Unknown | Tennessee | 389 | 2 | |
760785 | 760785 | 2020-11-23 | Van Buren | Tennessee | 47175 | 342 | 2 |
760786 | 760786 | 2020-11-23 | Warren | Tennessee | 47177 | 2270 | 18 |
760787 | 760787 | 2020-11-23 | Washington | Tennessee | 47179 | 5596 | 100 |
760788 | 760788 | 2020-11-23 | Wayne | Tennessee | 47181 | 1808 | 10 |
760789 | 760789 | 2020-11-23 | Weakley | Tennessee | 47183 | 2077 | 34 |
760790 | 760790 | 2020-11-23 | White | Tennessee | 47185 | 1675 | 17 |
760791 | 760791 | 2020-11-23 | Williamson | Tennessee | 47187 | 10664 | 73 |
760792 | 760792 | 2020-11-23 | Wilson | Tennessee | 47189 | 7055 | 74 |
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);