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-02-01 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
987872 | 987872 | 2021-02-01 | Anderson | Tennessee | 47001 | 7248 | 129 |
987873 | 987873 | 2021-02-01 | Bedford | Tennessee | 47003 | 5556 | 101 |
987874 | 987874 | 2021-02-01 | Benton | Tennessee | 47005 | 1374 | 35 |
987875 | 987875 | 2021-02-01 | Bledsoe | Tennessee | 47007 | 1836 | 11 |
987876 | 987876 | 2021-02-01 | Blount | Tennessee | 47009 | 12668 | 144 |
987877 | 987877 | 2021-02-01 | Bradley | Tennessee | 47011 | 11602 | 115 |
987878 | 987878 | 2021-02-01 | Campbell | Tennessee | 47013 | 3477 | 44 |
987879 | 987879 | 2021-02-01 | Cannon | Tennessee | 47015 | 1658 | 24 |
987880 | 987880 | 2021-02-01 | Carroll | Tennessee | 47017 | 3286 | 72 |
987881 | 987881 | 2021-02-01 | Carter | Tennessee | 47019 | 5319 | 132 |
987882 | 987882 | 2021-02-01 | Cheatham | Tennessee | 47021 | 3615 | 34 |
987883 | 987883 | 2021-02-01 | Chester | Tennessee | 47023 | 1855 | 43 |
987884 | 987884 | 2021-02-01 | Claiborne | Tennessee | 47025 | 2419 | 45 |
987885 | 987885 | 2021-02-01 | Clay | Tennessee | 47027 | 979 | 27 |
987886 | 987886 | 2021-02-01 | Cocke | Tennessee | 47029 | 3698 | 73 |
987887 | 987887 | 2021-02-01 | Coffee | Tennessee | 47031 | 5912 | 99 |
987888 | 987888 | 2021-02-01 | Crockett | Tennessee | 47033 | 1862 | 39 |
987889 | 987889 | 2021-02-01 | Cumberland | Tennessee | 47035 | 5663 | 87 |
987890 | 987890 | 2021-02-01 | Davidson | Tennessee | 47037 | 84908 | 742 |
987891 | 987891 | 2021-02-01 | DeKalb | Tennessee | 47041 | 2532 | 46 |
987892 | 987892 | 2021-02-01 | Decatur | Tennessee | 47039 | 1513 | 29 |
987893 | 987893 | 2021-02-01 | Dickson | Tennessee | 47043 | 5773 | 87 |
987894 | 987894 | 2021-02-01 | Dyer | Tennessee | 47045 | 4981 | 87 |
987895 | 987895 | 2021-02-01 | Fayette | Tennessee | 47047 | 4267 | 60 |
987896 | 987896 | 2021-02-01 | Fentress | Tennessee | 47049 | 2209 | 39 |
987897 | 987897 | 2021-02-01 | Franklin | Tennessee | 47051 | 4370 | 70 |
987898 | 987898 | 2021-02-01 | Gibson | Tennessee | 47053 | 5897 | 123 |
987899 | 987899 | 2021-02-01 | Giles | Tennessee | 47055 | 3425 | 81 |
987900 | 987900 | 2021-02-01 | Grainger | Tennessee | 47057 | 2228 | 43 |
987901 | 987901 | 2021-02-01 | Greene | Tennessee | 47059 | 6893 | 127 |
987902 | 987902 | 2021-02-01 | Grundy | Tennessee | 47061 | 1480 | 24 |
987903 | 987903 | 2021-02-01 | Hamblen | Tennessee | 47063 | 7440 | 144 |
987904 | 987904 | 2021-02-01 | Hamilton | Tennessee | 47065 | 38100 | 369 |
987905 | 987905 | 2021-02-01 | Hancock | Tennessee | 47067 | 441 | 8 |
987906 | 987906 | 2021-02-01 | Hardeman | Tennessee | 47069 | 3220 | 58 |
987907 | 987907 | 2021-02-01 | Hardin | Tennessee | 47071 | 3112 | 56 |
987908 | 987908 | 2021-02-01 | Hawkins | Tennessee | 47073 | 4797 | 84 |
987909 | 987909 | 2021-02-01 | Haywood | Tennessee | 47075 | 2520 | 58 |
987910 | 987910 | 2021-02-01 | Henderson | Tennessee | 47077 | 3453 | 65 |
987911 | 987911 | 2021-02-01 | Henry | Tennessee | 47079 | 2757 | 63 |
987912 | 987912 | 2021-02-01 | Hickman | Tennessee | 47081 | 2349 | 38 |
987913 | 987913 | 2021-02-01 | Houston | Tennessee | 47083 | 963 | 26 |
987914 | 987914 | 2021-02-01 | Humphreys | Tennessee | 47085 | 1417 | 18 |
987915 | 987915 | 2021-02-01 | Jackson | Tennessee | 47087 | 1091 | 25 |
987916 | 987916 | 2021-02-01 | Jefferson | Tennessee | 47089 | 5141 | 86 |
987917 | 987917 | 2021-02-01 | Johnson | Tennessee | 47091 | 2099 | 36 |
987918 | 987918 | 2021-02-01 | Knox | Tennessee | 47093 | 43019 | 498 |
987919 | 987919 | 2021-02-01 | Lake | Tennessee | 47095 | 1651 | 22 |
987920 | 987920 | 2021-02-01 | Lauderdale | Tennessee | 47097 | 3043 | 37 |
987921 | 987921 | 2021-02-01 | Lawrence | Tennessee | 47099 | 5373 | 74 |
987922 | 987922 | 2021-02-01 | Lewis | Tennessee | 47101 | 1353 | 22 |
987923 | 987923 | 2021-02-01 | Lincoln | Tennessee | 47103 | 3975 | 54 |
987924 | 987924 | 2021-02-01 | Loudon | Tennessee | 47105 | 5278 | 58 |
987925 | 987925 | 2021-02-01 | Macon | Tennessee | 47111 | 3006 | 57 |
987926 | 987926 | 2021-02-01 | Madison | Tennessee | 47113 | 9612 | 197 |
987927 | 987927 | 2021-02-01 | Marion | Tennessee | 47115 | 2408 | 36 |
987928 | 987928 | 2021-02-01 | Marshall | Tennessee | 47117 | 3683 | 46 |
987929 | 987929 | 2021-02-01 | Maury | Tennessee | 47119 | 11653 | 142 |
987930 | 987930 | 2021-02-01 | McMinn | Tennessee | 47107 | 5399 | 79 |
987931 | 987931 | 2021-02-01 | McNairy | Tennessee | 47109 | 2556 | 45 |
987932 | 987932 | 2021-02-01 | Meigs | Tennessee | 47121 | 1224 | 18 |
987933 | 987933 | 2021-02-01 | Monroe | Tennessee | 47123 | 4872 | 68 |
987934 | 987934 | 2021-02-01 | Montgomery | Tennessee | 47125 | 15817 | 165 |
987935 | 987935 | 2021-02-01 | Moore | Tennessee | 47127 | 854 | 11 |
987936 | 987936 | 2021-02-01 | Morgan | Tennessee | 47129 | 2020 | 18 |
987937 | 987937 | 2021-02-01 | Obion | Tennessee | 47131 | 4139 | 87 |
987938 | 987938 | 2021-02-01 | Overton | Tennessee | 47133 | 2648 | 48 |
987939 | 987939 | 2021-02-01 | Perry | Tennessee | 47135 | 981 | 25 |
987940 | 987940 | 2021-02-01 | Pickett | Tennessee | 47137 | 706 | 21 |
987941 | 987941 | 2021-02-01 | Polk | Tennessee | 47139 | 1565 | 19 |
987942 | 987942 | 2021-02-01 | Putnam | Tennessee | 47141 | 10407 | 158 |
987943 | 987943 | 2021-02-01 | Rhea | Tennessee | 47143 | 4002 | 64 |
987944 | 987944 | 2021-02-01 | Roane | Tennessee | 47145 | 5478 | 93 |
987945 | 987945 | 2021-02-01 | Robertson | Tennessee | 47147 | 8143 | 94 |
987946 | 987946 | 2021-02-01 | Rutherford | Tennessee | 47149 | 35188 | 317 |
987947 | 987947 | 2021-02-01 | Scott | Tennessee | 47151 | 2365 | 35 |
987948 | 987948 | 2021-02-01 | Sequatchie | Tennessee | 47153 | 1462 | 22 |
987949 | 987949 | 2021-02-01 | Sevier | Tennessee | 47155 | 11137 | 134 |
987950 | 987950 | 2021-02-01 | Shelby | Tennessee | 47157 | 83235 | 1289 |
987951 | 987951 | 2021-02-01 | Smith | Tennessee | 47159 | 2394 | 30 |
987952 | 987952 | 2021-02-01 | Stewart | Tennessee | 47161 | 1152 | 23 |
987953 | 987953 | 2021-02-01 | Sullivan | Tennessee | 47163 | 13299 | 243 |
987954 | 987954 | 2021-02-01 | Sumner | Tennessee | 47165 | 19339 | 261 |
987955 | 987955 | 2021-02-01 | Tipton | Tennessee | 47167 | 6558 | 84 |
987956 | 987956 | 2021-02-01 | Trousdale | Tennessee | 47169 | 2331 | 17 |
987957 | 987957 | 2021-02-01 | Unicoi | Tennessee | 47171 | 1723 | 47 |
987958 | 987958 | 2021-02-01 | Union | Tennessee | 47173 | 1511 | 25 |
987959 | 987959 | 2021-02-01 | Unknown | Tennessee | 13302 | 153 | |
987960 | 987960 | 2021-02-01 | Van Buren | Tennessee | 47175 | 680 | 12 |
987961 | 987961 | 2021-02-01 | Warren | Tennessee | 47177 | 5209 | 63 |
987962 | 987962 | 2021-02-01 | Washington | Tennessee | 47179 | 12437 | 219 |
987963 | 987963 | 2021-02-01 | Wayne | Tennessee | 47181 | 2754 | 26 |
987964 | 987964 | 2021-02-01 | Weakley | Tennessee | 47183 | 3529 | 52 |
987965 | 987965 | 2021-02-01 | White | Tennessee | 47185 | 3230 | 52 |
987966 | 987966 | 2021-02-01 | Williamson | Tennessee | 47187 | 23070 | 172 |
987967 | 987967 | 2021-02-01 | Wilson | Tennessee | 47189 | 15266 | 182 |
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);