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 2022-01-02 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2075893 | 2075893 | 2022-01-02 | Anderson | Tennessee | 47001 | 14409 | 265 |
2075894 | 2075894 | 2022-01-02 | Bedford | Tennessee | 47003 | 10042 | 204 |
2075895 | 2075895 | 2022-01-02 | Benton | Tennessee | 47005 | 3153 | 80 |
2075896 | 2075896 | 2022-01-02 | Bledsoe | Tennessee | 47007 | 3657 | 38 |
2075897 | 2075897 | 2022-01-02 | Blount | Tennessee | 47009 | 25852 | 325 |
2075898 | 2075898 | 2022-01-02 | Bradley | Tennessee | 47011 | 23701 | 320 |
2075899 | 2075899 | 2022-01-02 | Campbell | Tennessee | 47013 | 8026 | 128 |
2075900 | 2075900 | 2022-01-02 | Cannon | Tennessee | 47015 | 2991 | 50 |
2075901 | 2075901 | 2022-01-02 | Carroll | Tennessee | 47017 | 6129 | 127 |
2075902 | 2075902 | 2022-01-02 | Carter | Tennessee | 47019 | 11672 | 268 |
2075903 | 2075903 | 2022-01-02 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2075904 | 2075904 | 2022-01-02 | Chester | Tennessee | 47023 | 3806 | 81 |
2075905 | 2075905 | 2022-01-02 | Claiborne | Tennessee | 47025 | 6134 | 145 |
2075906 | 2075906 | 2022-01-02 | Clay | Tennessee | 47027 | 1649 | 40 |
2075907 | 2075907 | 2022-01-02 | Cocke | Tennessee | 47029 | 8241 | 168 |
2075908 | 2075908 | 2022-01-02 | Coffee | Tennessee | 47031 | 11365 | 213 |
2075909 | 2075909 | 2022-01-02 | Crockett | Tennessee | 47033 | 3503 | 75 |
2075910 | 2075910 | 2022-01-02 | Cumberland | Tennessee | 47035 | 12041 | 275 |
2075911 | 2075911 | 2022-01-02 | Davidson | Tennessee | 47037 | 149462 | 1384 |
2075912 | 2075912 | 2022-01-02 | DeKalb | Tennessee | 47041 | 4496 | 85 |
2075913 | 2075913 | 2022-01-02 | Decatur | Tennessee | 47039 | 2567 | 49 |
2075914 | 2075914 | 2022-01-02 | Dickson | Tennessee | 47043 | 11314 | 207 |
2075915 | 2075915 | 2022-01-02 | Dyer | Tennessee | 47045 | 8570 | 165 |
2075916 | 2075916 | 2022-01-02 | Fayette | Tennessee | 47047 | 8248 | 133 |
2075917 | 2075917 | 2022-01-02 | Fentress | Tennessee | 47049 | 4033 | 89 |
2075918 | 2075918 | 2022-01-02 | Franklin | Tennessee | 47051 | 8630 | 145 |
2075919 | 2075919 | 2022-01-02 | Gibson | Tennessee | 47053 | 11335 | 214 |
2075920 | 2075920 | 2022-01-02 | Giles | Tennessee | 47055 | 6463 | 150 |
2075921 | 2075921 | 2022-01-02 | Grainger | Tennessee | 47057 | 4797 | 91 |
2075922 | 2075922 | 2022-01-02 | Greene | Tennessee | 47059 | 15255 | 288 |
2075923 | 2075923 | 2022-01-02 | Grundy | Tennessee | 47061 | 3033 | 64 |
2075924 | 2075924 | 2022-01-02 | Hamblen | Tennessee | 47063 | 14070 | 288 |
2075925 | 2075925 | 2022-01-02 | Hamilton | Tennessee | 47065 | 71535 | 901 |
2075926 | 2075926 | 2022-01-02 | Hancock | Tennessee | 47067 | 1399 | 26 |
2075927 | 2075927 | 2022-01-02 | Hardeman | Tennessee | 47069 | 5462 | 96 |
2075928 | 2075928 | 2022-01-02 | Hardin | Tennessee | 47071 | 5949 | 110 |
2075929 | 2075929 | 2022-01-02 | Hawkins | Tennessee | 47073 | 11519 | 240 |
2075930 | 2075930 | 2022-01-02 | Haywood | Tennessee | 47075 | 4106 | 82 |
2075931 | 2075931 | 2022-01-02 | Henderson | Tennessee | 47077 | 6101 | 118 |
2075932 | 2075932 | 2022-01-02 | Henry | Tennessee | 47079 | 5847 | 117 |
2075933 | 2075933 | 2022-01-02 | Hickman | Tennessee | 47081 | 5030 | 92 |
2075934 | 2075934 | 2022-01-02 | Houston | Tennessee | 47083 | 2003 | 52 |
2075935 | 2075935 | 2022-01-02 | Humphreys | Tennessee | 47085 | 3527 | 59 |
2075936 | 2075936 | 2022-01-02 | Jackson | Tennessee | 47087 | 2230 | 49 |
2075937 | 2075937 | 2022-01-02 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2075938 | 2075938 | 2022-01-02 | Johnson | Tennessee | 47091 | 4207 | 63 |
2075939 | 2075939 | 2022-01-02 | Knox | Tennessee | 47093 | 85554 | 1065 |
2075940 | 2075940 | 2022-01-02 | Lake | Tennessee | 47095 | 2065 | 34 |
2075941 | 2075941 | 2022-01-02 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2075942 | 2075942 | 2022-01-02 | Lawrence | Tennessee | 47099 | 10163 | 158 |
2075943 | 2075943 | 2022-01-02 | Lewis | Tennessee | 47101 | 2628 | 48 |
2075944 | 2075944 | 2022-01-02 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2075945 | 2075945 | 2022-01-02 | Loudon | Tennessee | 47105 | 9928 | 146 |
2075946 | 2075946 | 2022-01-02 | Macon | Tennessee | 47111 | 5914 | 118 |
2075947 | 2075947 | 2022-01-02 | Madison | Tennessee | 47113 | 19389 | 362 |
2075948 | 2075948 | 2022-01-02 | Marion | Tennessee | 47115 | 6132 | 110 |
2075949 | 2075949 | 2022-01-02 | Marshall | Tennessee | 47117 | 7344 | 102 |
2075950 | 2075950 | 2022-01-02 | Maury | Tennessee | 47119 | 20925 | 272 |
2075951 | 2075951 | 2022-01-02 | McMinn | Tennessee | 47107 | 11183 | 196 |
2075952 | 2075952 | 2022-01-02 | McNairy | Tennessee | 47109 | 5010 | 86 |
2075953 | 2075953 | 2022-01-02 | Meigs | Tennessee | 47121 | 2365 | 46 |
2075954 | 2075954 | 2022-01-02 | Monroe | Tennessee | 47123 | 10353 | 196 |
2075955 | 2075955 | 2022-01-02 | Montgomery | Tennessee | 47125 | 36010 | 471 |
2075956 | 2075956 | 2022-01-02 | Moore | Tennessee | 47127 | 1524 | 31 |
2075957 | 2075957 | 2022-01-02 | Morgan | Tennessee | 47129 | 4109 | 57 |
2075958 | 2075958 | 2022-01-02 | Obion | Tennessee | 47131 | 7383 | 147 |
2075959 | 2075959 | 2022-01-02 | Overton | Tennessee | 47133 | 5213 | 106 |
2075960 | 2075960 | 2022-01-02 | Perry | Tennessee | 47135 | 1706 | 41 |
2075961 | 2075961 | 2022-01-02 | Pickett | Tennessee | 47137 | 1168 | 28 |
2075962 | 2075962 | 2022-01-02 | Polk | Tennessee | 47139 | 3386 | 50 |
2075963 | 2075963 | 2022-01-02 | Putnam | Tennessee | 47141 | 17874 | 262 |
2075964 | 2075964 | 2022-01-02 | Rhea | Tennessee | 47143 | 7410 | 130 |
2075965 | 2075965 | 2022-01-02 | Roane | Tennessee | 47145 | 10791 | 184 |
2075966 | 2075966 | 2022-01-02 | Robertson | Tennessee | 47147 | 15304 | 232 |
2075967 | 2075967 | 2022-01-02 | Rutherford | Tennessee | 47149 | 68185 | 731 |
2075968 | 2075968 | 2022-01-02 | Scott | Tennessee | 47151 | 6070 | 89 |
2075969 | 2075969 | 2022-01-02 | Sequatchie | Tennessee | 47153 | 3206 | 59 |
2075970 | 2075970 | 2022-01-02 | Sevier | Tennessee | 47155 | 22006 | 332 |
2075971 | 2075971 | 2022-01-02 | Shelby | Tennessee | 47157 | 172627 | 2708 |
2075972 | 2075972 | 2022-01-02 | Smith | Tennessee | 47159 | 4431 | 64 |
2075973 | 2075973 | 2022-01-02 | Stewart | Tennessee | 47161 | 2333 | 44 |
2075974 | 2075974 | 2022-01-02 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2075975 | 2075975 | 2022-01-02 | Sumner | Tennessee | 47165 | 38033 | 584 |
2075976 | 2075976 | 2022-01-02 | Tipton | Tennessee | 47167 | 12806 | 179 |
2075977 | 2075977 | 2022-01-02 | Trousdale | Tennessee | 47169 | 3337 | 36 |
2075978 | 2075978 | 2022-01-02 | Unicoi | Tennessee | 47171 | 3426 | 79 |
2075979 | 2075979 | 2022-01-02 | Union | Tennessee | 47173 | 3694 | 64 |
2075980 | 2075980 | 2022-01-02 | Unknown | Tennessee | 2031 | 180 | |
2075981 | 2075981 | 2022-01-02 | Van Buren | Tennessee | 47175 | 1362 | 43 |
2075982 | 2075982 | 2022-01-02 | Warren | Tennessee | 47177 | 9131 | 152 |
2075983 | 2075983 | 2022-01-02 | Washington | Tennessee | 47179 | 25290 | 401 |
2075984 | 2075984 | 2022-01-02 | Wayne | Tennessee | 47181 | 4283 | 47 |
2075985 | 2075985 | 2022-01-02 | Weakley | Tennessee | 47183 | 6769 | 107 |
2075986 | 2075986 | 2022-01-02 | White | Tennessee | 47185 | 5978 | 115 |
2075987 | 2075987 | 2022-01-02 | Williamson | Tennessee | 47187 | 44659 | 322 |
2075988 | 2075988 | 2022-01-02 | Wilson | Tennessee | 47189 | 29941 | 404 |
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);