ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-08-06 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
407743 | 407743 | 2020-08-06 | Anderson | Tennessee | 47001 | 651 | 6 |
407744 | 407744 | 2020-08-06 | Bedford | Tennessee | 47003 | 901 | 11 |
407745 | 407745 | 2020-08-06 | Benton | Tennessee | 47005 | 126 | 1 |
407746 | 407746 | 2020-08-06 | Bledsoe | Tennessee | 47007 | 686 | 1 |
407747 | 407747 | 2020-08-06 | Blount | Tennessee | 47009 | 1222 | 9 |
407748 | 407748 | 2020-08-06 | Bradley | Tennessee | 47011 | 1817 | 12 |
407749 | 407749 | 2020-08-06 | Campbell | Tennessee | 47013 | 229 | 1 |
407750 | 407750 | 2020-08-06 | Cannon | Tennessee | 47015 | 136 | 0 |
407751 | 407751 | 2020-08-06 | Carroll | Tennessee | 47017 | 272 | 3 |
407752 | 407752 | 2020-08-06 | Carter | Tennessee | 47019 | 473 | 5 |
407753 | 407753 | 2020-08-06 | Cheatham | Tennessee | 47021 | 569 | 7 |
407754 | 407754 | 2020-08-06 | Chester | Tennessee | 47023 | 206 | 2 |
407755 | 407755 | 2020-08-06 | Claiborne | Tennessee | 47025 | 242 | 0 |
407756 | 407756 | 2020-08-06 | Clay | Tennessee | 47027 | 71 | 0 |
407757 | 407757 | 2020-08-06 | Cocke | Tennessee | 47029 | 439 | 2 |
407758 | 407758 | 2020-08-06 | Coffee | Tennessee | 47031 | 482 | 3 |
407759 | 407759 | 2020-08-06 | Crockett | Tennessee | 47033 | 253 | 4 |
407760 | 407760 | 2020-08-06 | Cumberland | Tennessee | 47035 | 398 | 6 |
407761 | 407761 | 2020-08-06 | Davidson | Tennessee | 47037 | 22247 | 211 |
407762 | 407762 | 2020-08-06 | DeKalb | Tennessee | 47041 | 331 | 2 |
407763 | 407763 | 2020-08-06 | Decatur | Tennessee | 47039 | 188 | 3 |
407764 | 407764 | 2020-08-06 | Dickson | Tennessee | 47043 | 652 | 1 |
407765 | 407765 | 2020-08-06 | Dyer | Tennessee | 47045 | 593 | 7 |
407766 | 407766 | 2020-08-06 | Fayette | Tennessee | 47047 | 652 | 8 |
407767 | 407767 | 2020-08-06 | Fentress | Tennessee | 47049 | 79 | 0 |
407768 | 407768 | 2020-08-06 | Franklin | Tennessee | 47051 | 302 | 4 |
407769 | 407769 | 2020-08-06 | Gibson | Tennessee | 47053 | 644 | 4 |
407770 | 407770 | 2020-08-06 | Giles | Tennessee | 47055 | 369 | 13 |
407771 | 407771 | 2020-08-06 | Grainger | Tennessee | 47057 | 189 | 0 |
407772 | 407772 | 2020-08-06 | Greene | Tennessee | 47059 | 418 | 7 |
407773 | 407773 | 2020-08-06 | Grundy | Tennessee | 47061 | 108 | 2 |
407774 | 407774 | 2020-08-06 | Hamblen | Tennessee | 47063 | 1346 | 14 |
407775 | 407775 | 2020-08-06 | Hamilton | Tennessee | 47065 | 5884 | 50 |
407776 | 407776 | 2020-08-06 | Hancock | Tennessee | 47067 | 77 | 1 |
407777 | 407777 | 2020-08-06 | Hardeman | Tennessee | 47069 | 858 | 15 |
407778 | 407778 | 2020-08-06 | Hardin | Tennessee | 47071 | 444 | 7 |
407779 | 407779 | 2020-08-06 | Hawkins | Tennessee | 47073 | 416 | 7 |
407780 | 407780 | 2020-08-06 | Haywood | Tennessee | 47075 | 435 | 6 |
407781 | 407781 | 2020-08-06 | Henderson | Tennessee | 47077 | 517 | 2 |
407782 | 407782 | 2020-08-06 | Henry | Tennessee | 47079 | 248 | 0 |
407783 | 407783 | 2020-08-06 | Hickman | Tennessee | 47081 | 248 | 0 |
407784 | 407784 | 2020-08-06 | Houston | Tennessee | 47083 | 56 | 0 |
407785 | 407785 | 2020-08-06 | Humphreys | Tennessee | 47085 | 118 | 3 |
407786 | 407786 | 2020-08-06 | Jackson | Tennessee | 47087 | 112 | 1 |
407787 | 407787 | 2020-08-06 | Jefferson | Tennessee | 47089 | 525 | 3 |
407788 | 407788 | 2020-08-06 | Johnson | Tennessee | 47091 | 225 | 0 |
407789 | 407789 | 2020-08-06 | Knox | Tennessee | 47093 | 4515 | 42 |
407790 | 407790 | 2020-08-06 | Lake | Tennessee | 47095 | 765 | 0 |
407791 | 407791 | 2020-08-06 | Lauderdale | Tennessee | 47097 | 455 | 8 |
407792 | 407792 | 2020-08-06 | Lawrence | Tennessee | 47099 | 527 | 6 |
407793 | 407793 | 2020-08-06 | Lewis | Tennessee | 47101 | 67 | 1 |
407794 | 407794 | 2020-08-06 | Lincoln | Tennessee | 47103 | 268 | 1 |
407795 | 407795 | 2020-08-06 | Loudon | Tennessee | 47105 | 705 | 3 |
407796 | 407796 | 2020-08-06 | Macon | Tennessee | 47111 | 855 | 13 |
407797 | 407797 | 2020-08-06 | Madison | Tennessee | 47113 | 984 | 15 |
407798 | 407798 | 2020-08-06 | Marion | Tennessee | 47115 | 213 | 4 |
407799 | 407799 | 2020-08-06 | Marshall | Tennessee | 47117 | 275 | 3 |
407800 | 407800 | 2020-08-06 | Maury | Tennessee | 47119 | 1159 | 7 |
407801 | 407801 | 2020-08-06 | McMinn | Tennessee | 47107 | 509 | 20 |
407802 | 407802 | 2020-08-06 | McNairy | Tennessee | 47109 | 351 | 5 |
407803 | 407803 | 2020-08-06 | Meigs | Tennessee | 47121 | 99 | 0 |
407804 | 407804 | 2020-08-06 | Monroe | Tennessee | 47123 | 397 | 9 |
407805 | 407805 | 2020-08-06 | Montgomery | Tennessee | 47125 | 1815 | 13 |
407806 | 407806 | 2020-08-06 | Moore | Tennessee | 47127 | 55 | 0 |
407807 | 407807 | 2020-08-06 | Morgan | Tennessee | 47129 | 98 | 1 |
407808 | 407808 | 2020-08-06 | Obion | Tennessee | 47131 | 490 | 4 |
407809 | 407809 | 2020-08-06 | Overton | Tennessee | 47133 | 155 | 1 |
407810 | 407810 | 2020-08-06 | Perry | Tennessee | 47135 | 77 | 0 |
407811 | 407811 | 2020-08-06 | Pickett | Tennessee | 47137 | 30 | 1 |
407812 | 407812 | 2020-08-06 | Polk | Tennessee | 47139 | 185 | 3 |
407813 | 407813 | 2020-08-06 | Putnam | Tennessee | 47141 | 1677 | 16 |
407814 | 407814 | 2020-08-06 | Rhea | Tennessee | 47143 | 517 | 1 |
407815 | 407815 | 2020-08-06 | Roane | Tennessee | 47145 | 423 | 2 |
407816 | 407816 | 2020-08-06 | Robertson | Tennessee | 47147 | 1506 | 19 |
407817 | 407817 | 2020-08-06 | Rutherford | Tennessee | 47149 | 6298 | 53 |
407818 | 407818 | 2020-08-06 | Scott | Tennessee | 47151 | 110 | 0 |
407819 | 407819 | 2020-08-06 | Sequatchie | Tennessee | 47153 | 100 | 0 |
407820 | 407820 | 2020-08-06 | Sevier | Tennessee | 47155 | 1791 | 6 |
407821 | 407821 | 2020-08-06 | Shelby | Tennessee | 47157 | 22552 | 300 |
407822 | 407822 | 2020-08-06 | Smith | Tennessee | 47159 | 429 | 4 |
407823 | 407823 | 2020-08-06 | Stewart | Tennessee | 47161 | 74 | 0 |
407824 | 407824 | 2020-08-06 | Sullivan | Tennessee | 47163 | 895 | 12 |
407825 | 407825 | 2020-08-06 | Sumner | Tennessee | 47165 | 3316 | 72 |
407826 | 407826 | 2020-08-06 | Tipton | Tennessee | 47167 | 1155 | 9 |
407827 | 407827 | 2020-08-06 | Trousdale | Tennessee | 47169 | 1578 | 6 |
407828 | 407828 | 2020-08-06 | Unicoi | Tennessee | 47171 | 148 | 0 |
407829 | 407829 | 2020-08-06 | Union | Tennessee | 47173 | 141 | 0 |
407830 | 407830 | 2020-08-06 | Unknown | Tennessee | 233 | 2 | |
407831 | 407831 | 2020-08-06 | Van Buren | Tennessee | 47175 | 35 | 0 |
407832 | 407832 | 2020-08-06 | Warren | Tennessee | 47177 | 479 | 4 |
407833 | 407833 | 2020-08-06 | Washington | Tennessee | 47179 | 1131 | 2 |
407834 | 407834 | 2020-08-06 | Wayne | Tennessee | 47181 | 224 | 2 |
407835 | 407835 | 2020-08-06 | Weakley | Tennessee | 47183 | 363 | 3 |
407836 | 407836 | 2020-08-06 | White | Tennessee | 47185 | 246 | 5 |
407837 | 407837 | 2020-08-06 | Williamson | Tennessee | 47187 | 3405 | 25 |
407838 | 407838 | 2020-08-06 | Wilson | Tennessee | 47189 | 2190 | 23 |
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);