ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2020-04-27 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
94676 | 94676 | 2020-04-27 | Anderson | Tennessee | 47001 | 24 | 1 |
94677 | 94677 | 2020-04-27 | Bedford | Tennessee | 47003 | 165 | 2 |
94678 | 94678 | 2020-04-27 | Benton | Tennessee | 47005 | 6 | 1 |
94679 | 94679 | 2020-04-27 | Bledsoe | Tennessee | 47007 | 588 | 0 |
94680 | 94680 | 2020-04-27 | Blount | Tennessee | 47009 | 54 | 3 |
94681 | 94681 | 2020-04-27 | Bradley | Tennessee | 47011 | 45 | 1 |
94682 | 94682 | 2020-04-27 | Campbell | Tennessee | 47013 | 14 | 1 |
94683 | 94683 | 2020-04-27 | Cannon | Tennessee | 47015 | 11 | 0 |
94684 | 94684 | 2020-04-27 | Carroll | Tennessee | 47017 | 16 | 1 |
94685 | 94685 | 2020-04-27 | Carter | Tennessee | 47019 | 12 | 1 |
94686 | 94686 | 2020-04-27 | Cheatham | Tennessee | 47021 | 39 | 0 |
94687 | 94687 | 2020-04-27 | Chester | Tennessee | 47023 | 10 | 0 |
94688 | 94688 | 2020-04-27 | Claiborne | Tennessee | 47025 | 5 | 0 |
94689 | 94689 | 2020-04-27 | Clay | Tennessee | 47027 | 5 | 0 |
94690 | 94690 | 2020-04-27 | Cocke | Tennessee | 47029 | 14 | 0 |
94691 | 94691 | 2020-04-27 | Coffee | Tennessee | 47031 | 33 | 0 |
94692 | 94692 | 2020-04-27 | Crockett | Tennessee | 47033 | 6 | 0 |
94693 | 94693 | 2020-04-27 | Cumberland | Tennessee | 47035 | 68 | 0 |
94694 | 94694 | 2020-04-27 | Davidson | Tennessee | 47037 | 2488 | 25 |
94695 | 94695 | 2020-04-27 | DeKalb | Tennessee | 47041 | 14 | 0 |
94696 | 94696 | 2020-04-27 | Decatur | Tennessee | 47039 | 4 | 0 |
94697 | 94697 | 2020-04-27 | Dickson | Tennessee | 47043 | 70 | 0 |
94698 | 94698 | 2020-04-27 | Dyer | Tennessee | 47045 | 32 | 0 |
94699 | 94699 | 2020-04-27 | Fayette | Tennessee | 47047 | 52 | 1 |
94700 | 94700 | 2020-04-27 | Fentress | Tennessee | 47049 | 4 | 0 |
94701 | 94701 | 2020-04-27 | Franklin | Tennessee | 47051 | 29 | 1 |
94702 | 94702 | 2020-04-27 | Gibson | Tennessee | 47053 | 41 | 1 |
94703 | 94703 | 2020-04-27 | Giles | Tennessee | 47055 | 6 | 0 |
94704 | 94704 | 2020-04-27 | Grainger | Tennessee | 47057 | 6 | 0 |
94705 | 94705 | 2020-04-27 | Greene | Tennessee | 47059 | 41 | 2 |
94706 | 94706 | 2020-04-27 | Grundy | Tennessee | 47061 | 28 | 1 |
94707 | 94707 | 2020-04-27 | Hamblen | Tennessee | 47063 | 16 | 2 |
94708 | 94708 | 2020-04-27 | Hamilton | Tennessee | 47065 | 146 | 14 |
94709 | 94709 | 2020-04-27 | Hardeman | Tennessee | 47069 | 11 | 0 |
94710 | 94710 | 2020-04-27 | Hardin | Tennessee | 47071 | 5 | 0 |
94711 | 94711 | 2020-04-27 | Hawkins | Tennessee | 47073 | 29 | 2 |
94712 | 94712 | 2020-04-27 | Haywood | Tennessee | 47075 | 19 | 1 |
94713 | 94713 | 2020-04-27 | Henderson | Tennessee | 47077 | 6 | 0 |
94714 | 94714 | 2020-04-27 | Henry | Tennessee | 47079 | 11 | 0 |
94715 | 94715 | 2020-04-27 | Hickman | Tennessee | 47081 | 42 | 0 |
94716 | 94716 | 2020-04-27 | Houston | Tennessee | 47083 | 4 | 0 |
94717 | 94717 | 2020-04-27 | Humphreys | Tennessee | 47085 | 10 | 1 |
94718 | 94718 | 2020-04-27 | Jackson | Tennessee | 47087 | 7 | 0 |
94719 | 94719 | 2020-04-27 | Jefferson | Tennessee | 47089 | 18 | 0 |
94720 | 94720 | 2020-04-27 | Johnson | Tennessee | 47091 | 3 | 0 |
94721 | 94721 | 2020-04-27 | Knox | Tennessee | 47093 | 214 | 4 |
94722 | 94722 | 2020-04-27 | Lake | Tennessee | 47095 | 49 | 0 |
94723 | 94723 | 2020-04-27 | Lauderdale | Tennessee | 47097 | 17 | 0 |
94724 | 94724 | 2020-04-27 | Lawrence | Tennessee | 47099 | 17 | 0 |
94725 | 94725 | 2020-04-27 | Lewis | Tennessee | 47101 | 2 | 0 |
94726 | 94726 | 2020-04-27 | Lincoln | Tennessee | 47103 | 12 | 0 |
94727 | 94727 | 2020-04-27 | Loudon | Tennessee | 47105 | 27 | 0 |
94728 | 94728 | 2020-04-27 | Macon | Tennessee | 47111 | 39 | 3 |
94729 | 94729 | 2020-04-27 | Madison | Tennessee | 47113 | 104 | 1 |
94730 | 94730 | 2020-04-27 | Marion | Tennessee | 47115 | 28 | 1 |
94731 | 94731 | 2020-04-27 | Marshall | Tennessee | 47117 | 22 | 1 |
94732 | 94732 | 2020-04-27 | Maury | Tennessee | 47119 | 41 | 1 |
94733 | 94733 | 2020-04-27 | McMinn | Tennessee | 47107 | 65 | 0 |
94734 | 94734 | 2020-04-27 | McNairy | Tennessee | 47109 | 11 | 0 |
94735 | 94735 | 2020-04-27 | Meigs | Tennessee | 47121 | 6 | 0 |
94736 | 94736 | 2020-04-27 | Monroe | Tennessee | 47123 | 15 | 1 |
94737 | 94737 | 2020-04-27 | Montgomery | Tennessee | 47125 | 138 | 2 |
94738 | 94738 | 2020-04-27 | Moore | Tennessee | 47127 | 3 | 0 |
94739 | 94739 | 2020-04-27 | Morgan | Tennessee | 47129 | 6 | 0 |
94740 | 94740 | 2020-04-27 | Obion | Tennessee | 47131 | 12 | 1 |
94741 | 94741 | 2020-04-27 | Overton | Tennessee | 47133 | 8 | 0 |
94742 | 94742 | 2020-04-27 | Perry | Tennessee | 47135 | 8 | 0 |
94743 | 94743 | 2020-04-27 | Polk | Tennessee | 47139 | 7 | 0 |
94744 | 94744 | 2020-04-27 | Putnam | Tennessee | 47141 | 114 | 5 |
94745 | 94745 | 2020-04-27 | Rhea | Tennessee | 47143 | 4 | 0 |
94746 | 94746 | 2020-04-27 | Roane | Tennessee | 47145 | 8 | 0 |
94747 | 94747 | 2020-04-27 | Robertson | Tennessee | 47147 | 138 | 0 |
94748 | 94748 | 2020-04-27 | Rutherford | Tennessee | 47149 | 423 | 9 |
94749 | 94749 | 2020-04-27 | Scott | Tennessee | 47151 | 11 | 0 |
94750 | 94750 | 2020-04-27 | Sequatchie | Tennessee | 47153 | 5 | 0 |
94751 | 94751 | 2020-04-27 | Sevier | Tennessee | 47155 | 46 | 1 |
94752 | 94752 | 2020-04-27 | Shelby | Tennessee | 47157 | 2327 | 45 |
94753 | 94753 | 2020-04-27 | Smith | Tennessee | 47159 | 19 | 1 |
94754 | 94754 | 2020-04-27 | Stewart | Tennessee | 47161 | 7 | 0 |
94755 | 94755 | 2020-04-27 | Sullivan | Tennessee | 47163 | 47 | 1 |
94756 | 94756 | 2020-04-27 | Sumner | Tennessee | 47165 | 603 | 34 |
94757 | 94757 | 2020-04-27 | Tipton | Tennessee | 47167 | 95 | 0 |
94758 | 94758 | 2020-04-27 | Trousdale | Tennessee | 47169 | 48 | 1 |
94759 | 94759 | 2020-04-27 | Unicoi | Tennessee | 47171 | 1 | 0 |
94760 | 94760 | 2020-04-27 | Union | Tennessee | 47173 | 3 | 0 |
94761 | 94761 | 2020-04-27 | Van Buren | Tennessee | 47175 | 2 | 0 |
94762 | 94762 | 2020-04-27 | Warren | Tennessee | 47177 | 7 | 0 |
94763 | 94763 | 2020-04-27 | Washington | Tennessee | 47179 | 54 | 0 |
94764 | 94764 | 2020-04-27 | Wayne | Tennessee | 47181 | 2 | 0 |
94765 | 94765 | 2020-04-27 | Weakley | Tennessee | 47183 | 18 | 0 |
94766 | 94766 | 2020-04-27 | White | Tennessee | 47185 | 4 | 0 |
94767 | 94767 | 2020-04-27 | Williamson | Tennessee | 47187 | 399 | 7 |
94768 | 94768 | 2020-04-27 | Wilson | Tennessee | 47189 | 246 | 3 |
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);