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-23 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1945875 | 1945875 | 2021-11-23 | Anderson | Tennessee | 47001 | 13418 | 234 |
1945876 | 1945876 | 2021-11-23 | Bedford | Tennessee | 47003 | 9469 | 159 |
1945877 | 1945877 | 2021-11-23 | Benton | Tennessee | 47005 | 2935 | 56 |
1945878 | 1945878 | 2021-11-23 | Bledsoe | Tennessee | 47007 | 3546 | 20 |
1945879 | 1945879 | 2021-11-23 | Blount | Tennessee | 47009 | 24318 | 272 |
1945880 | 1945880 | 2021-11-23 | Bradley | Tennessee | 47011 | 22536 | 215 |
1945881 | 1945881 | 2021-11-23 | Campbell | Tennessee | 47013 | 7495 | 88 |
1945882 | 1945882 | 2021-11-23 | Cannon | Tennessee | 47015 | 2839 | 44 |
1945883 | 1945883 | 2021-11-23 | Carroll | Tennessee | 47017 | 5864 | 110 |
1945884 | 1945884 | 2021-11-23 | Carter | Tennessee | 47019 | 10818 | 226 |
1945885 | 1945885 | 2021-11-23 | Cheatham | Tennessee | 47021 | 7131 | 76 |
1945886 | 1945886 | 2021-11-23 | Chester | Tennessee | 47023 | 3581 | 76 |
1945887 | 1945887 | 2021-11-23 | Claiborne | Tennessee | 47025 | 5828 | 115 |
1945888 | 1945888 | 2021-11-23 | Clay | Tennessee | 47027 | 1548 | 37 |
1945889 | 1945889 | 2021-11-23 | Cocke | Tennessee | 47029 | 7559 | 110 |
1945890 | 1945890 | 2021-11-23 | Coffee | Tennessee | 47031 | 10812 | 164 |
1945891 | 1945891 | 2021-11-23 | Crockett | Tennessee | 47033 | 3396 | 63 |
1945892 | 1945892 | 2021-11-23 | Cumberland | Tennessee | 47035 | 11430 | 227 |
1945893 | 1945893 | 2021-11-23 | Davidson | Tennessee | 47037 | 135017 | 1192 |
1945894 | 1945894 | 2021-11-23 | DeKalb | Tennessee | 47041 | 4278 | 76 |
1945895 | 1945895 | 2021-11-23 | Decatur | Tennessee | 47039 | 2472 | 44 |
1945896 | 1945896 | 2021-11-23 | Dickson | Tennessee | 47043 | 10700 | 169 |
1945897 | 1945897 | 2021-11-23 | Dyer | Tennessee | 47045 | 8159 | 150 |
1945898 | 1945898 | 2021-11-23 | Fayette | Tennessee | 47047 | 7432 | 108 |
1945899 | 1945899 | 2021-11-23 | Fentress | Tennessee | 47049 | 3759 | 68 |
1945900 | 1945900 | 2021-11-23 | Franklin | Tennessee | 47051 | 8146 | 104 |
1945901 | 1945901 | 2021-11-23 | Gibson | Tennessee | 47053 | 10790 | 191 |
1945902 | 1945902 | 2021-11-23 | Giles | Tennessee | 47055 | 6157 | 127 |
1945903 | 1945903 | 2021-11-23 | Grainger | Tennessee | 47057 | 4487 | 68 |
1945904 | 1945904 | 2021-11-23 | Greene | Tennessee | 47059 | 14151 | 247 |
1945905 | 1945905 | 2021-11-23 | Grundy | Tennessee | 47061 | 2927 | 42 |
1945906 | 1945906 | 2021-11-23 | Hamblen | Tennessee | 47063 | 13257 | 206 |
1945907 | 1945907 | 2021-11-23 | Hamilton | Tennessee | 47065 | 65169 | 675 |
1945908 | 1945908 | 2021-11-23 | Hancock | Tennessee | 47067 | 1246 | 20 |
1945909 | 1945909 | 2021-11-23 | Hardeman | Tennessee | 47069 | 5164 | 85 |
1945910 | 1945910 | 2021-11-23 | Hardin | Tennessee | 47071 | 5661 | 88 |
1945911 | 1945911 | 2021-11-23 | Hawkins | Tennessee | 47073 | 10660 | 180 |
1945912 | 1945912 | 2021-11-23 | Haywood | Tennessee | 47075 | 3904 | 77 |
1945913 | 1945913 | 2021-11-23 | Henderson | Tennessee | 47077 | 5875 | 105 |
1945914 | 1945914 | 2021-11-23 | Henry | Tennessee | 47079 | 5559 | 91 |
1945915 | 1945915 | 2021-11-23 | Hickman | Tennessee | 47081 | 4725 | 78 |
1945916 | 1945916 | 2021-11-23 | Houston | Tennessee | 47083 | 1878 | 45 |
1945917 | 1945917 | 2021-11-23 | Humphreys | Tennessee | 47085 | 3333 | 48 |
1945918 | 1945918 | 2021-11-23 | Jackson | Tennessee | 47087 | 2108 | 40 |
1945919 | 1945919 | 2021-11-23 | Jefferson | Tennessee | 47089 | 10113 | 150 |
1945920 | 1945920 | 2021-11-23 | Johnson | Tennessee | 47091 | 3890 | 52 |
1945921 | 1945921 | 2021-11-23 | Knox | Tennessee | 47093 | 80394 | 946 |
1945922 | 1945922 | 2021-11-23 | Lake | Tennessee | 47095 | 2023 | 31 |
1945923 | 1945923 | 2021-11-23 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1945924 | 1945924 | 2021-11-23 | Lawrence | Tennessee | 47099 | 9730 | 126 |
1945925 | 1945925 | 2021-11-23 | Lewis | Tennessee | 47101 | 2557 | 41 |
1945926 | 1945926 | 2021-11-23 | Lincoln | Tennessee | 47103 | 6822 | 90 |
1945927 | 1945927 | 2021-11-23 | Loudon | Tennessee | 47105 | 9396 | 101 |
1945928 | 1945928 | 2021-11-23 | Macon | Tennessee | 47111 | 5548 | 94 |
1945929 | 1945929 | 2021-11-23 | Madison | Tennessee | 47113 | 18030 | 324 |
1945930 | 1945930 | 2021-11-23 | Marion | Tennessee | 47115 | 5875 | 57 |
1945931 | 1945931 | 2021-11-23 | Marshall | Tennessee | 47117 | 6963 | 90 |
1945932 | 1945932 | 2021-11-23 | Maury | Tennessee | 47119 | 19753 | 238 |
1945933 | 1945933 | 2021-11-23 | McMinn | Tennessee | 47107 | 10702 | 137 |
1945934 | 1945934 | 2021-11-23 | McNairy | Tennessee | 47109 | 4777 | 72 |
1945935 | 1945935 | 2021-11-23 | Meigs | Tennessee | 47121 | 2223 | 31 |
1945936 | 1945936 | 2021-11-23 | Monroe | Tennessee | 47123 | 9911 | 128 |
1945937 | 1945937 | 2021-11-23 | Montgomery | Tennessee | 47125 | 33475 | 350 |
1945938 | 1945938 | 2021-11-23 | Moore | Tennessee | 47127 | 1456 | 24 |
1945939 | 1945939 | 2021-11-23 | Morgan | Tennessee | 47129 | 3909 | 50 |
1945940 | 1945940 | 2021-11-23 | Obion | Tennessee | 47131 | 6812 | 111 |
1945941 | 1945941 | 2021-11-23 | Overton | Tennessee | 47133 | 4890 | 83 |
1945942 | 1945942 | 2021-11-23 | Perry | Tennessee | 47135 | 1638 | 34 |
1945943 | 1945943 | 2021-11-23 | Pickett | Tennessee | 47137 | 1121 | 25 |
1945944 | 1945944 | 2021-11-23 | Polk | Tennessee | 47139 | 3238 | 33 |
1945945 | 1945945 | 2021-11-23 | Putnam | Tennessee | 47141 | 16991 | 224 |
1945946 | 1945946 | 2021-11-23 | Rhea | Tennessee | 47143 | 7080 | 98 |
1945947 | 1945947 | 2021-11-23 | Roane | Tennessee | 47145 | 10290 | 159 |
1945948 | 1945948 | 2021-11-23 | Robertson | Tennessee | 47147 | 14311 | 196 |
1945949 | 1945949 | 2021-11-23 | Rutherford | Tennessee | 47149 | 63384 | 576 |
1945950 | 1945950 | 2021-11-23 | Scott | Tennessee | 47151 | 5641 | 65 |
1945951 | 1945951 | 2021-11-23 | Sequatchie | Tennessee | 47153 | 3063 | 33 |
1945952 | 1945952 | 2021-11-23 | Sevier | Tennessee | 47155 | 20526 | 282 |
1945953 | 1945953 | 2021-11-23 | Shelby | Tennessee | 47157 | 148444 | 2321 |
1945954 | 1945954 | 2021-11-23 | Smith | Tennessee | 47159 | 4240 | 53 |
1945955 | 1945955 | 2021-11-23 | Stewart | Tennessee | 47161 | 2183 | 35 |
1945956 | 1945956 | 2021-11-23 | Sullivan | Tennessee | 47163 | 27933 | 443 |
1945957 | 1945957 | 2021-11-23 | Sumner | Tennessee | 47165 | 35009 | 430 |
1945958 | 1945958 | 2021-11-23 | Tipton | Tennessee | 47167 | 11634 | 141 |
1945959 | 1945959 | 2021-11-23 | Trousdale | Tennessee | 47169 | 3225 | 27 |
1945960 | 1945960 | 2021-11-23 | Unicoi | Tennessee | 47171 | 3224 | 65 |
1945961 | 1945961 | 2021-11-23 | Union | Tennessee | 47173 | 3383 | 50 |
1945962 | 1945962 | 2021-11-23 | Unknown | Tennessee | 8985 | 130 | |
1945963 | 1945963 | 2021-11-23 | Van Buren | Tennessee | 47175 | 1277 | 29 |
1945964 | 1945964 | 2021-11-23 | Warren | Tennessee | 47177 | 8785 | 128 |
1945965 | 1945965 | 2021-11-23 | Washington | Tennessee | 47179 | 22666 | 339 |
1945966 | 1945966 | 2021-11-23 | Wayne | Tennessee | 47181 | 4144 | 41 |
1945967 | 1945967 | 2021-11-23 | Weakley | Tennessee | 47183 | 6345 | 89 |
1945968 | 1945968 | 2021-11-23 | White | Tennessee | 47185 | 5728 | 98 |
1945969 | 1945969 | 2021-11-23 | Williamson | Tennessee | 47187 | 40671 | 276 |
1945970 | 1945970 | 2021-11-23 | Wilson | Tennessee | 47189 | 27638 | 344 |
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);