ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

10,712 rows where state = "Tennessee" sorted by date descending

View and edit SQL

fips

county

state

  • Tennessee · 10,712
Link rowid date ▲ county state fips cases deaths
336858 2020-07-15 Anderson Tennessee 47001 236 2
336859 2020-07-15 Bedford Tennessee 47003 646 10
336860 2020-07-15 Benton Tennessee 47005 24 1
336861 2020-07-15 Bledsoe Tennessee 47007 634 1
336862 2020-07-15 Blount Tennessee 47009 381 3
336863 2020-07-15 Bradley Tennessee 47011 1096 6
336864 2020-07-15 Campbell Tennessee 47013 77 1
336865 2020-07-15 Cannon Tennessee 47015 65 0
336866 2020-07-15 Carroll Tennessee 47017 63 1
336867 2020-07-15 Carter Tennessee 47019 128 2
336868 2020-07-15 Cheatham Tennessee 47021 311 3
336869 2020-07-15 Chester Tennessee 47023 91 0
336870 2020-07-15 Claiborne Tennessee 47025 86 0
336871 2020-07-15 Clay Tennessee 47027 28 0
336872 2020-07-15 Cocke Tennessee 47029 175 0
336873 2020-07-15 Coffee Tennessee 47031 162 0
336874 2020-07-15 Crockett Tennessee 47033 75 3
336875 2020-07-15 Cumberland Tennessee 47035 241 5
336876 2020-07-15 Davidson Tennessee 47037 15757 157
336877 2020-07-15 DeKalb Tennessee 47041 119 0
336878 2020-07-15 Decatur Tennessee 47039 44 0
336879 2020-07-15 Dickson Tennessee 47043 308 0
336880 2020-07-15 Dyer Tennessee 47045 326 3
336881 2020-07-15 Fayette Tennessee 47047 404 6
336882 2020-07-15 Fentress Tennessee 47049 35 0
336883 2020-07-15 Franklin Tennessee 47051 127 3
336884 2020-07-15 Gibson Tennessee 47053 237 1
336885 2020-07-15 Giles Tennessee 47055 143 1
336886 2020-07-15 Grainger Tennessee 47057 65 0
336887 2020-07-15 Greene Tennessee 47059 173 2
336888 2020-07-15 Grundy Tennessee 47061 68 2
336889 2020-07-15 Hamblen Tennessee 47063 551 5
336890 2020-07-15 Hamilton Tennessee 47065 3798 39
336891 2020-07-15 Hancock Tennessee 47067 15 0
336892 2020-07-15 Hardeman Tennessee 47069 480 4
336893 2020-07-15 Hardin Tennessee 47071 154 7
336894 2020-07-15 Hawkins Tennessee 47073 103 2
336895 2020-07-15 Haywood Tennessee 47075 155 3
336896 2020-07-15 Henderson Tennessee 47077 114 0
336897 2020-07-15 Henry Tennessee 47079 57 0
336898 2020-07-15 Hickman Tennessee 47081 118 0
336899 2020-07-15 Houston Tennessee 47083 25 0
336900 2020-07-15 Humphreys Tennessee 47085 53 2
336901 2020-07-15 Jackson Tennessee 47087 62 0
336902 2020-07-15 Jefferson Tennessee 47089 219 1
336903 2020-07-15 Johnson Tennessee 47091 48 0
336904 2020-07-15 Knox Tennessee 47093 1915 15
336905 2020-07-15 Lake Tennessee 47095 698 0
336906 2020-07-15 Lauderdale Tennessee 47097 218 4
336907 2020-07-15 Lawrence Tennessee 47099 262 6
336908 2020-07-15 Lewis Tennessee 47101 13 0
336909 2020-07-15 Lincoln Tennessee 47103 111 0
336910 2020-07-15 Loudon Tennessee 47105 353 2
336911 2020-07-15 Macon Tennessee 47111 670 7
336912 2020-07-15 Madison Tennessee 47113 409 2
336913 2020-07-15 Marion Tennessee 47115 104 4
336914 2020-07-15 Marshall Tennessee 47117 141 2
336915 2020-07-15 Maury Tennessee 47119 529 3
336916 2020-07-15 McMinn Tennessee 47107 313 19
336917 2020-07-15 McNairy Tennessee 47109 138 1
336918 2020-07-15 Meigs Tennessee 47121 40 0
336919 2020-07-15 Monroe Tennessee 47123 162 6
336920 2020-07-15 Montgomery Tennessee 47125 906 7
336921 2020-07-15 Moore Tennessee 47127 26 0
336922 2020-07-15 Morgan Tennessee 47129 37 1
336923 2020-07-15 Obion Tennessee 47131 144 3
336924 2020-07-15 Overton Tennessee 47133 86 1
336925 2020-07-15 Perry Tennessee 47135 45 0
336926 2020-07-15 Pickett Tennessee 47137 8 0
336927 2020-07-15 Polk Tennessee 47139 61 0
336928 2020-07-15 Putnam Tennessee 47141 1108 7
336929 2020-07-15 Rhea Tennessee 47143 362 0
336930 2020-07-15 Roane Tennessee 47145 100 0
336931 2020-07-15 Robertson Tennessee 47147 1010 13
336932 2020-07-15 Rutherford Tennessee 47149 3944 39
336933 2020-07-15 Scott Tennessee 47151 31 0
336934 2020-07-15 Sequatchie Tennessee 47153 54 0
336935 2020-07-15 Sevier Tennessee 47155 978 4
336936 2020-07-15 Shelby Tennessee 47157 14891 233
336937 2020-07-15 Smith Tennessee 47159 202 2
336938 2020-07-15 Stewart Tennessee 47161 34 0
336939 2020-07-15 Sullivan Tennessee 47163 290 5
336940 2020-07-15 Sumner Tennessee 47165 2189 57
336941 2020-07-15 Tipton Tennessee 47167 740 7
336942 2020-07-15 Trousdale Tennessee 47169 1516 5
336943 2020-07-15 Unicoi Tennessee 47171 61 0
336944 2020-07-15 Union Tennessee 47173 31 0
336945 2020-07-15 Unknown Tennessee   0 1
336946 2020-07-15 Van Buren Tennessee 47175 14 0
336947 2020-07-15 Warren Tennessee 47177 183 1
336948 2020-07-15 Washington Tennessee 47179 321 0
336949 2020-07-15 Wayne Tennessee 47181 130 0
336950 2020-07-15 Weakley Tennessee 47183 87 1
336951 2020-07-15 White Tennessee 47185 116 3
336952 2020-07-15 Williamson Tennessee 47187 2119 18
336953 2020-07-15 Wilson Tennessee 47189 1338 18
333666 2020-07-14 Anderson Tennessee 47001 219 2
333667 2020-07-14 Bedford Tennessee 47003 635 9
333668 2020-07-14 Benton Tennessee 47005 17 1
333669 2020-07-14 Bledsoe Tennessee 47007 634 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 2001.549ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette