ny_times_us_counties

Table actions
⚠️ 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

96 rows where date = "2022-02-26" and state = "Tennessee" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Tennessee · 96 ✖
Link rowid date ▲ county state fips cases deaths
2254773 2254773 2022-02-26 Anderson Tennessee 47001 21724 303
2254774 2254774 2022-02-26 Bedford Tennessee 47003 14826 218
2254775 2254775 2022-02-26 Benton Tennessee 47005 4386 85
2254776 2254776 2022-02-26 Bledsoe Tennessee 47007 4618 48
2254777 2254777 2022-02-26 Blount Tennessee 47009 38653 387
2254778 2254778 2022-02-26 Bradley Tennessee 47011 32832 376
2254779 2254779 2022-02-26 Campbell Tennessee 47013 11694 145
2254780 2254780 2022-02-26 Cannon Tennessee 47015 4133 55
2254781 2254781 2022-02-26 Carroll Tennessee 47017 8811 145
2254782 2254782 2022-02-26 Carter Tennessee 47019 16164 305
2254783 2254783 2022-02-26 Cheatham Tennessee 47021 10818 113
2254784 2254784 2022-02-26 Chester Tennessee 47023 5685 90
2254785 2254785 2022-02-26 Claiborne Tennessee 47025 8780 159
2254786 2254786 2022-02-26 Clay Tennessee 47027 2207 46
2254787 2254787 2022-02-26 Cocke Tennessee 47029 11172 201
2254788 2254788 2022-02-26 Coffee Tennessee 47031 16777 237
2254789 2254789 2022-02-26 Crockett Tennessee 47033 5008 81
2254790 2254790 2022-02-26 Cumberland Tennessee 47035 15886 303
2254791 2254791 2022-02-26 Davidson Tennessee 47037 205375 1568
2254792 2254792 2022-02-26 DeKalb Tennessee 47041 6223 96
2254793 2254793 2022-02-26 Decatur Tennessee 47039 3618 61
2254794 2254794 2022-02-26 Dickson Tennessee 47043 15730 228
2254795 2254795 2022-02-26 Dyer Tennessee 47045 12544 185
2254796 2254796 2022-02-26 Fayette Tennessee 47047 11323 163
2254797 2254797 2022-02-26 Fentress Tennessee 47049 5640 114
2254798 2254798 2022-02-26 Franklin Tennessee 47051 12724 164
2254799 2254799 2022-02-26 Gibson Tennessee 47053 17074 247
2254800 2254800 2022-02-26 Giles Tennessee 47055 9342 166
2254801 2254801 2022-02-26 Grainger Tennessee 47057 6688 101
2254802 2254802 2022-02-26 Greene Tennessee 47059 21773 340
2254803 2254803 2022-02-26 Grundy Tennessee 47061 3947 68
2254804 2254804 2022-02-26 Hamblen Tennessee 47063 19502 336
2254805 2254805 2022-02-26 Hamilton Tennessee 47065 97442 1071
2254806 2254806 2022-02-26 Hancock Tennessee 47067 1966 30
2254807 2254807 2022-02-26 Hardeman Tennessee 47069 7373 113
2254808 2254808 2022-02-26 Hardin Tennessee 47071 8518 128
2254809 2254809 2022-02-26 Hawkins Tennessee 47073 16388 281
2254810 2254810 2022-02-26 Haywood Tennessee 47075 6081 95
2254811 2254811 2022-02-26 Henderson Tennessee 47077 8798 143
2254812 2254812 2022-02-26 Henry Tennessee 47079 8050 140
2254813 2254813 2022-02-26 Hickman Tennessee 47081 6769 103
2254814 2254814 2022-02-26 Houston Tennessee 47083 2644 59
2254815 2254815 2022-02-26 Humphreys Tennessee 47085 4786 68
2254816 2254816 2022-02-26 Jackson Tennessee 47087 3163 58
2254817 2254817 2022-02-26 Jefferson Tennessee 47089 15485 249
2254818 2254818 2022-02-26 Johnson Tennessee 47091 5047 77
2254819 2254819 2022-02-26 Knox Tennessee 47093 126007 1257
2254820 2254820 2022-02-26 Lake Tennessee 47095 2670 38
2254821 2254821 2022-02-26 Lauderdale Tennessee 47097 7648 92
2254822 2254822 2022-02-26 Lawrence Tennessee 47099 14166 175
2254823 2254823 2022-02-26 Lewis Tennessee 47101 3550 50
2254824 2254824 2022-02-26 Lincoln Tennessee 47103 9882 145
2254825 2254825 2022-02-26 Loudon Tennessee 47105 14250 180
2254826 2254826 2022-02-26 Macon Tennessee 47111 8340 138
2254827 2254827 2022-02-26 Madison Tennessee 47113 29127 397
2254828 2254828 2022-02-26 Marion Tennessee 47115 8745 121
2254829 2254829 2022-02-26 Marshall Tennessee 47117 10269 115
2254830 2254830 2022-02-26 Maury Tennessee 47119 28685 312
2254831 2254831 2022-02-26 McMinn Tennessee 47107 16540 232
2254832 2254832 2022-02-26 McNairy Tennessee 47109 7464 100
2254833 2254833 2022-02-26 Meigs Tennessee 47121 3323 51
2254834 2254834 2022-02-26 Monroe Tennessee 47123 14312 216
2254835 2254835 2022-02-26 Montgomery Tennessee 47125 49416 531
2254836 2254836 2022-02-26 Moore Tennessee 47127 2208 37
2254837 2254837 2022-02-26 Morgan Tennessee 47129 5965 75
2254838 2254838 2022-02-26 Obion Tennessee 47131 10659 168
2254839 2254839 2022-02-26 Overton Tennessee 47133 7092 118
2254840 2254840 2022-02-26 Perry Tennessee 47135 2292 46
2254841 2254841 2022-02-26 Pickett Tennessee 47137 1753 30
2254842 2254842 2022-02-26 Polk Tennessee 47139 4624 56
2254843 2254843 2022-02-26 Putnam Tennessee 47141 24841 291
2254844 2254844 2022-02-26 Rhea Tennessee 47143 9890 148
2254845 2254845 2022-02-26 Roane Tennessee 47145 15588 217
2254846 2254846 2022-02-26 Robertson Tennessee 47147 21356 284
2254847 2254847 2022-02-26 Rutherford Tennessee 47149 94737 851
2254848 2254848 2022-02-26 Scott Tennessee 47151 8816 105
2254849 2254849 2022-02-26 Sequatchie Tennessee 47153 4165 64
2254850 2254850 2022-02-26 Sevier Tennessee 47155 29882 383
2254851 2254851 2022-02-26 Shelby Tennessee 47157 236382 3131
2254852 2254852 2022-02-26 Smith Tennessee 47159 6102 73
2254853 2254853 2022-02-26 Stewart Tennessee 47161 3253 48
2254854 2254854 2022-02-26 Sullivan Tennessee 47163 44990 642
2254855 2254855 2022-02-26 Sumner Tennessee 47165 52623 682
2254856 2254856 2022-02-26 Tipton Tennessee 47167 17460 209
2254857 2254857 2022-02-26 Trousdale Tennessee 47169 4188 44
2254858 2254858 2022-02-26 Unicoi Tennessee 47171 5073 88
2254859 2254859 2022-02-26 Union Tennessee 47173 5332 69
2254860 2254860 2022-02-26 Unknown Tennessee   25294 648
2254861 2254861 2022-02-26 Van Buren Tennessee 47175 1831 45
2254862 2254862 2022-02-26 Warren Tennessee 47177 12892 163
2254863 2254863 2022-02-26 Washington Tennessee 47179 37964 461
2254864 2254864 2022-02-26 Wayne Tennessee 47181 5609 53
2254865 2254865 2022-02-26 Weakley Tennessee 47183 9387 131
2254866 2254866 2022-02-26 White Tennessee 47185 8143 126
2254867 2254867 2022-02-26 Williamson Tennessee 47187 61337 375
2254868 2254868 2022-02-26 Wilson Tennessee 47189 41211 459

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
);
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);