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 2021-11-15 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1919874 | 1919874 | 2021-11-15 | Anderson | Tennessee | 47001 | 13259 | 227 |
1919875 | 1919875 | 2021-11-15 | Bedford | Tennessee | 47003 | 9360 | 158 |
1919876 | 1919876 | 2021-11-15 | Benton | Tennessee | 47005 | 2881 | 55 |
1919877 | 1919877 | 2021-11-15 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1919878 | 1919878 | 2021-11-15 | Blount | Tennessee | 47009 | 24095 | 271 |
1919879 | 1919879 | 2021-11-15 | Bradley | Tennessee | 47011 | 22413 | 203 |
1919880 | 1919880 | 2021-11-15 | Campbell | Tennessee | 47013 | 7416 | 88 |
1919881 | 1919881 | 2021-11-15 | Cannon | Tennessee | 47015 | 2818 | 43 |
1919882 | 1919882 | 2021-11-15 | Carroll | Tennessee | 47017 | 5832 | 106 |
1919883 | 1919883 | 2021-11-15 | Carter | Tennessee | 47019 | 10693 | 221 |
1919884 | 1919884 | 2021-11-15 | Cheatham | Tennessee | 47021 | 7083 | 75 |
1919885 | 1919885 | 2021-11-15 | Chester | Tennessee | 47023 | 3557 | 76 |
1919886 | 1919886 | 2021-11-15 | Claiborne | Tennessee | 47025 | 5781 | 114 |
1919887 | 1919887 | 2021-11-15 | Clay | Tennessee | 47027 | 1543 | 37 |
1919888 | 1919888 | 2021-11-15 | Cocke | Tennessee | 47029 | 7503 | 108 |
1919889 | 1919889 | 2021-11-15 | Coffee | Tennessee | 47031 | 10707 | 163 |
1919890 | 1919890 | 2021-11-15 | Crockett | Tennessee | 47033 | 3376 | 62 |
1919891 | 1919891 | 2021-11-15 | Cumberland | Tennessee | 47035 | 11300 | 226 |
1919892 | 1919892 | 2021-11-15 | Davidson | Tennessee | 47037 | 134237 | 1181 |
1919893 | 1919893 | 2021-11-15 | DeKalb | Tennessee | 47041 | 4250 | 75 |
1919894 | 1919894 | 2021-11-15 | Decatur | Tennessee | 47039 | 2461 | 44 |
1919895 | 1919895 | 2021-11-15 | Dickson | Tennessee | 47043 | 10594 | 167 |
1919896 | 1919896 | 2021-11-15 | Dyer | Tennessee | 47045 | 8150 | 148 |
1919897 | 1919897 | 2021-11-15 | Fayette | Tennessee | 47047 | 7376 | 108 |
1919898 | 1919898 | 2021-11-15 | Fentress | Tennessee | 47049 | 3735 | 68 |
1919899 | 1919899 | 2021-11-15 | Franklin | Tennessee | 47051 | 8078 | 102 |
1919900 | 1919900 | 2021-11-15 | Gibson | Tennessee | 47053 | 10750 | 191 |
1919901 | 1919901 | 2021-11-15 | Giles | Tennessee | 47055 | 6119 | 127 |
1919902 | 1919902 | 2021-11-15 | Grainger | Tennessee | 47057 | 4438 | 68 |
1919903 | 1919903 | 2021-11-15 | Greene | Tennessee | 47059 | 13990 | 246 |
1919904 | 1919904 | 2021-11-15 | Grundy | Tennessee | 47061 | 2906 | 39 |
1919905 | 1919905 | 2021-11-15 | Hamblen | Tennessee | 47063 | 13165 | 203 |
1919906 | 1919906 | 2021-11-15 | Hamilton | Tennessee | 47065 | 64741 | 663 |
1919907 | 1919907 | 2021-11-15 | Hancock | Tennessee | 47067 | 1236 | 20 |
1919908 | 1919908 | 2021-11-15 | Hardeman | Tennessee | 47069 | 5155 | 83 |
1919909 | 1919909 | 2021-11-15 | Hardin | Tennessee | 47071 | 5617 | 84 |
1919910 | 1919910 | 2021-11-15 | Hawkins | Tennessee | 47073 | 10476 | 176 |
1919911 | 1919911 | 2021-11-15 | Haywood | Tennessee | 47075 | 3864 | 77 |
1919912 | 1919912 | 2021-11-15 | Henderson | Tennessee | 47077 | 5823 | 103 |
1919913 | 1919913 | 2021-11-15 | Henry | Tennessee | 47079 | 5533 | 87 |
1919914 | 1919914 | 2021-11-15 | Hickman | Tennessee | 47081 | 4669 | 78 |
1919915 | 1919915 | 2021-11-15 | Houston | Tennessee | 47083 | 1862 | 44 |
1919916 | 1919916 | 2021-11-15 | Humphreys | Tennessee | 47085 | 3305 | 48 |
1919917 | 1919917 | 2021-11-15 | Jackson | Tennessee | 47087 | 2104 | 40 |
1919918 | 1919918 | 2021-11-15 | Jefferson | Tennessee | 47089 | 10034 | 149 |
1919919 | 1919919 | 2021-11-15 | Johnson | Tennessee | 47091 | 3791 | 52 |
1919920 | 1919920 | 2021-11-15 | Knox | Tennessee | 47093 | 79748 | 940 |
1919921 | 1919921 | 2021-11-15 | Lake | Tennessee | 47095 | 2021 | 31 |
1919922 | 1919922 | 2021-11-15 | Lauderdale | Tennessee | 47097 | 5241 | 69 |
1919923 | 1919923 | 2021-11-15 | Lawrence | Tennessee | 47099 | 9658 | 125 |
1919924 | 1919924 | 2021-11-15 | Lewis | Tennessee | 47101 | 2550 | 41 |
1919925 | 1919925 | 2021-11-15 | Lincoln | Tennessee | 47103 | 6779 | 88 |
1919926 | 1919926 | 2021-11-15 | Loudon | Tennessee | 47105 | 9314 | 99 |
1919927 | 1919927 | 2021-11-15 | Macon | Tennessee | 47111 | 5505 | 93 |
1919928 | 1919928 | 2021-11-15 | Madison | Tennessee | 47113 | 17844 | 321 |
1919929 | 1919929 | 2021-11-15 | Marion | Tennessee | 47115 | 5843 | 55 |
1919930 | 1919930 | 2021-11-15 | Marshall | Tennessee | 47117 | 6917 | 88 |
1919931 | 1919931 | 2021-11-15 | Maury | Tennessee | 47119 | 19599 | 237 |
1919932 | 1919932 | 2021-11-15 | McMinn | Tennessee | 47107 | 10637 | 136 |
1919933 | 1919933 | 2021-11-15 | McNairy | Tennessee | 47109 | 4714 | 71 |
1919934 | 1919934 | 2021-11-15 | Meigs | Tennessee | 47121 | 2211 | 29 |
1919935 | 1919935 | 2021-11-15 | Monroe | Tennessee | 47123 | 9844 | 126 |
1919936 | 1919936 | 2021-11-15 | Montgomery | Tennessee | 47125 | 33279 | 344 |
1919937 | 1919937 | 2021-11-15 | Moore | Tennessee | 47127 | 1445 | 22 |
1919938 | 1919938 | 2021-11-15 | Morgan | Tennessee | 47129 | 3867 | 49 |
1919939 | 1919939 | 2021-11-15 | Obion | Tennessee | 47131 | 6733 | 112 |
1919940 | 1919940 | 2021-11-15 | Overton | Tennessee | 47133 | 4858 | 83 |
1919941 | 1919941 | 2021-11-15 | Perry | Tennessee | 47135 | 1634 | 34 |
1919942 | 1919942 | 2021-11-15 | Pickett | Tennessee | 47137 | 1100 | 24 |
1919943 | 1919943 | 2021-11-15 | Polk | Tennessee | 47139 | 3217 | 31 |
1919944 | 1919944 | 2021-11-15 | Putnam | Tennessee | 47141 | 16881 | 220 |
1919945 | 1919945 | 2021-11-15 | Rhea | Tennessee | 47143 | 7040 | 94 |
1919946 | 1919946 | 2021-11-15 | Roane | Tennessee | 47145 | 10183 | 155 |
1919947 | 1919947 | 2021-11-15 | Robertson | Tennessee | 47147 | 14227 | 195 |
1919948 | 1919948 | 2021-11-15 | Rutherford | Tennessee | 47149 | 62788 | 567 |
1919949 | 1919949 | 2021-11-15 | Scott | Tennessee | 47151 | 5519 | 61 |
1919950 | 1919950 | 2021-11-15 | Sequatchie | Tennessee | 47153 | 3034 | 33 |
1919951 | 1919951 | 2021-11-15 | Sevier | Tennessee | 47155 | 20370 | 278 |
1919952 | 1919952 | 2021-11-15 | Shelby | Tennessee | 47157 | 147486 | 2298 |
1919953 | 1919953 | 2021-11-15 | Smith | Tennessee | 47159 | 4200 | 53 |
1919954 | 1919954 | 2021-11-15 | Stewart | Tennessee | 47161 | 2161 | 35 |
1919955 | 1919955 | 2021-11-15 | Sullivan | Tennessee | 47163 | 27450 | 438 |
1919956 | 1919956 | 2021-11-15 | Sumner | Tennessee | 47165 | 34747 | 417 |
1919957 | 1919957 | 2021-11-15 | Tipton | Tennessee | 47167 | 11500 | 138 |
1919958 | 1919958 | 2021-11-15 | Trousdale | Tennessee | 47169 | 3205 | 26 |
1919959 | 1919959 | 2021-11-15 | Unicoi | Tennessee | 47171 | 3200 | 65 |
1919960 | 1919960 | 2021-11-15 | Union | Tennessee | 47173 | 3336 | 49 |
1919961 | 1919961 | 2021-11-15 | Unknown | Tennessee | 8760 | 125 | |
1919962 | 1919962 | 2021-11-15 | Van Buren | Tennessee | 47175 | 1265 | 29 |
1919963 | 1919963 | 2021-11-15 | Warren | Tennessee | 47177 | 8717 | 125 |
1919964 | 1919964 | 2021-11-15 | Washington | Tennessee | 47179 | 22169 | 332 |
1919965 | 1919965 | 2021-11-15 | Wayne | Tennessee | 47181 | 4111 | 39 |
1919966 | 1919966 | 2021-11-15 | Weakley | Tennessee | 47183 | 6304 | 89 |
1919967 | 1919967 | 2021-11-15 | White | Tennessee | 47185 | 5692 | 98 |
1919968 | 1919968 | 2021-11-15 | Williamson | Tennessee | 47187 | 40262 | 275 |
1919969 | 1919969 | 2021-11-15 | Wilson | Tennessee | 47189 | 27431 | 340 |
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);