ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-11-19" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1932874 | 1932874 | 2021-11-19 | Anderson | Tennessee | 47001 | 13358 | 232 |
1932875 | 1932875 | 2021-11-19 | Bedford | Tennessee | 47003 | 9419 | 158 |
1932876 | 1932876 | 2021-11-19 | Benton | Tennessee | 47005 | 2907 | 55 |
1932877 | 1932877 | 2021-11-19 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1932878 | 1932878 | 2021-11-19 | Blount | Tennessee | 47009 | 24208 | 272 |
1932879 | 1932879 | 2021-11-19 | Bradley | Tennessee | 47011 | 22475 | 212 |
1932880 | 1932880 | 2021-11-19 | Campbell | Tennessee | 47013 | 7468 | 88 |
1932881 | 1932881 | 2021-11-19 | Cannon | Tennessee | 47015 | 2832 | 43 |
1932882 | 1932882 | 2021-11-19 | Carroll | Tennessee | 47017 | 5849 | 107 |
1932883 | 1932883 | 2021-11-19 | Carter | Tennessee | 47019 | 10760 | 223 |
1932884 | 1932884 | 2021-11-19 | Cheatham | Tennessee | 47021 | 7096 | 76 |
1932885 | 1932885 | 2021-11-19 | Chester | Tennessee | 47023 | 3574 | 76 |
1932886 | 1932886 | 2021-11-19 | Claiborne | Tennessee | 47025 | 5811 | 115 |
1932887 | 1932887 | 2021-11-19 | Clay | Tennessee | 47027 | 1547 | 37 |
1932888 | 1932888 | 2021-11-19 | Cocke | Tennessee | 47029 | 7541 | 109 |
1932889 | 1932889 | 2021-11-19 | Coffee | Tennessee | 47031 | 10769 | 163 |
1932890 | 1932890 | 2021-11-19 | Crockett | Tennessee | 47033 | 3392 | 62 |
1932891 | 1932891 | 2021-11-19 | Cumberland | Tennessee | 47035 | 11372 | 227 |
1932892 | 1932892 | 2021-11-19 | Davidson | Tennessee | 47037 | 134682 | 1192 |
1932893 | 1932893 | 2021-11-19 | DeKalb | Tennessee | 47041 | 4264 | 76 |
1932894 | 1932894 | 2021-11-19 | Decatur | Tennessee | 47039 | 2468 | 44 |
1932895 | 1932895 | 2021-11-19 | Dickson | Tennessee | 47043 | 10659 | 169 |
1932896 | 1932896 | 2021-11-19 | Dyer | Tennessee | 47045 | 8156 | 150 |
1932897 | 1932897 | 2021-11-19 | Fayette | Tennessee | 47047 | 7414 | 108 |
1932898 | 1932898 | 2021-11-19 | Fentress | Tennessee | 47049 | 3747 | 68 |
1932899 | 1932899 | 2021-11-19 | Franklin | Tennessee | 47051 | 8123 | 103 |
1932900 | 1932900 | 2021-11-19 | Gibson | Tennessee | 47053 | 10778 | 191 |
1932901 | 1932901 | 2021-11-19 | Giles | Tennessee | 47055 | 6140 | 127 |
1932902 | 1932902 | 2021-11-19 | Grainger | Tennessee | 47057 | 4467 | 68 |
1932903 | 1932903 | 2021-11-19 | Greene | Tennessee | 47059 | 14092 | 247 |
1932904 | 1932904 | 2021-11-19 | Grundy | Tennessee | 47061 | 2920 | 40 |
1932905 | 1932905 | 2021-11-19 | Hamblen | Tennessee | 47063 | 13211 | 206 |
1932906 | 1932906 | 2021-11-19 | Hamilton | Tennessee | 47065 | 64982 | 669 |
1932907 | 1932907 | 2021-11-19 | Hancock | Tennessee | 47067 | 1243 | 20 |
1932908 | 1932908 | 2021-11-19 | Hardeman | Tennessee | 47069 | 5160 | 84 |
1932909 | 1932909 | 2021-11-19 | Hardin | Tennessee | 47071 | 5646 | 88 |
1932910 | 1932910 | 2021-11-19 | Hawkins | Tennessee | 47073 | 10583 | 179 |
1932911 | 1932911 | 2021-11-19 | Haywood | Tennessee | 47075 | 3895 | 77 |
1932912 | 1932912 | 2021-11-19 | Henderson | Tennessee | 47077 | 5857 | 105 |
1932913 | 1932913 | 2021-11-19 | Henry | Tennessee | 47079 | 5553 | 88 |
1932914 | 1932914 | 2021-11-19 | Hickman | Tennessee | 47081 | 4707 | 78 |
1932915 | 1932915 | 2021-11-19 | Houston | Tennessee | 47083 | 1874 | 45 |
1932916 | 1932916 | 2021-11-19 | Humphreys | Tennessee | 47085 | 3320 | 48 |
1932917 | 1932917 | 2021-11-19 | Jackson | Tennessee | 47087 | 2106 | 40 |
1932918 | 1932918 | 2021-11-19 | Jefferson | Tennessee | 47089 | 10088 | 149 |
1932919 | 1932919 | 2021-11-19 | Johnson | Tennessee | 47091 | 3853 | 52 |
1932920 | 1932920 | 2021-11-19 | Knox | Tennessee | 47093 | 80093 | 946 |
1932921 | 1932921 | 2021-11-19 | Lake | Tennessee | 47095 | 2022 | 31 |
1932922 | 1932922 | 2021-11-19 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1932923 | 1932923 | 2021-11-19 | Lawrence | Tennessee | 47099 | 9701 | 125 |
1932924 | 1932924 | 2021-11-19 | Lewis | Tennessee | 47101 | 2555 | 41 |
1932925 | 1932925 | 2021-11-19 | Lincoln | Tennessee | 47103 | 6800 | 88 |
1932926 | 1932926 | 2021-11-19 | Loudon | Tennessee | 47105 | 9365 | 101 |
1932927 | 1932927 | 2021-11-19 | Macon | Tennessee | 47111 | 5529 | 94 |
1932928 | 1932928 | 2021-11-19 | Madison | Tennessee | 47113 | 17979 | 323 |
1932929 | 1932929 | 2021-11-19 | Marion | Tennessee | 47115 | 5867 | 57 |
1932930 | 1932930 | 2021-11-19 | Marshall | Tennessee | 47117 | 6942 | 90 |
1932931 | 1932931 | 2021-11-19 | Maury | Tennessee | 47119 | 19688 | 238 |
1932932 | 1932932 | 2021-11-19 | McMinn | Tennessee | 47107 | 10669 | 137 |
1932933 | 1932933 | 2021-11-19 | McNairy | Tennessee | 47109 | 4744 | 71 |
1932934 | 1932934 | 2021-11-19 | Meigs | Tennessee | 47121 | 2215 | 30 |
1932935 | 1932935 | 2021-11-19 | Monroe | Tennessee | 47123 | 9875 | 126 |
1932936 | 1932936 | 2021-11-19 | Montgomery | Tennessee | 47125 | 33395 | 347 |
1932937 | 1932937 | 2021-11-19 | Moore | Tennessee | 47127 | 1450 | 24 |
1932938 | 1932938 | 2021-11-19 | Morgan | Tennessee | 47129 | 3880 | 50 |
1932939 | 1932939 | 2021-11-19 | Obion | Tennessee | 47131 | 6776 | 112 |
1932940 | 1932940 | 2021-11-19 | Overton | Tennessee | 47133 | 4880 | 83 |
1932941 | 1932941 | 2021-11-19 | Perry | Tennessee | 47135 | 1634 | 34 |
1932942 | 1932942 | 2021-11-19 | Pickett | Tennessee | 47137 | 1111 | 25 |
1932943 | 1932943 | 2021-11-19 | Polk | Tennessee | 47139 | 3231 | 31 |
1932944 | 1932944 | 2021-11-19 | Putnam | Tennessee | 47141 | 16957 | 223 |
1932945 | 1932945 | 2021-11-19 | Rhea | Tennessee | 47143 | 7067 | 97 |
1932946 | 1932946 | 2021-11-19 | Roane | Tennessee | 47145 | 10248 | 159 |
1932947 | 1932947 | 2021-11-19 | Robertson | Tennessee | 47147 | 14282 | 196 |
1932948 | 1932948 | 2021-11-19 | Rutherford | Tennessee | 47149 | 63136 | 574 |
1932949 | 1932949 | 2021-11-19 | Scott | Tennessee | 47151 | 5608 | 63 |
1932950 | 1932950 | 2021-11-19 | Sequatchie | Tennessee | 47153 | 3045 | 33 |
1932951 | 1932951 | 2021-11-19 | Sevier | Tennessee | 47155 | 20463 | 280 |
1932952 | 1932952 | 2021-11-19 | Shelby | Tennessee | 47157 | 148028 | 2307 |
1932953 | 1932953 | 2021-11-19 | Smith | Tennessee | 47159 | 4230 | 53 |
1932954 | 1932954 | 2021-11-19 | Stewart | Tennessee | 47161 | 2175 | 35 |
1932955 | 1932955 | 2021-11-19 | Sullivan | Tennessee | 47163 | 27710 | 439 |
1932956 | 1932956 | 2021-11-19 | Sumner | Tennessee | 47165 | 34924 | 426 |
1932957 | 1932957 | 2021-11-19 | Tipton | Tennessee | 47167 | 11593 | 140 |
1932958 | 1932958 | 2021-11-19 | Trousdale | Tennessee | 47169 | 3219 | 26 |
1932959 | 1932959 | 2021-11-19 | Unicoi | Tennessee | 47171 | 3211 | 65 |
1932960 | 1932960 | 2021-11-19 | Union | Tennessee | 47173 | 3372 | 50 |
1932961 | 1932961 | 2021-11-19 | Unknown | Tennessee | 8969 | 128 | |
1932962 | 1932962 | 2021-11-19 | Van Buren | Tennessee | 47175 | 1269 | 29 |
1932963 | 1932963 | 2021-11-19 | Warren | Tennessee | 47177 | 8764 | 128 |
1932964 | 1932964 | 2021-11-19 | Washington | Tennessee | 47179 | 22460 | 336 |
1932965 | 1932965 | 2021-11-19 | Wayne | Tennessee | 47181 | 4133 | 39 |
1932966 | 1932966 | 2021-11-19 | Weakley | Tennessee | 47183 | 6326 | 89 |
1932967 | 1932967 | 2021-11-19 | White | Tennessee | 47185 | 5709 | 98 |
1932968 | 1932968 | 2021-11-19 | Williamson | Tennessee | 47187 | 40479 | 276 |
1932969 | 1932969 | 2021-11-19 | Wilson | Tennessee | 47189 | 27558 | 343 |
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);