ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
494891 | 494891 | 2020-09-02 | Anderson | Tennessee | 47001 | 888 | 8 |
494892 | 494892 | 2020-09-02 | Bedford | Tennessee | 47003 | 1137 | 14 |
494893 | 494893 | 2020-09-02 | Benton | Tennessee | 47005 | 261 | 6 |
494894 | 494894 | 2020-09-02 | Bledsoe | Tennessee | 47007 | 782 | 4 |
494895 | 494895 | 2020-09-02 | Blount | Tennessee | 47009 | 2032 | 17 |
494896 | 494896 | 2020-09-02 | Bradley | Tennessee | 47011 | 2524 | 16 |
494897 | 494897 | 2020-09-02 | Campbell | Tennessee | 47013 | 333 | 3 |
494898 | 494898 | 2020-09-02 | Cannon | Tennessee | 47015 | 206 | 0 |
494899 | 494899 | 2020-09-02 | Carroll | Tennessee | 47017 | 666 | 9 |
494900 | 494900 | 2020-09-02 | Carter | Tennessee | 47019 | 866 | 19 |
494901 | 494901 | 2020-09-02 | Cheatham | Tennessee | 47021 | 724 | 10 |
494902 | 494902 | 2020-09-02 | Chester | Tennessee | 47023 | 394 | 6 |
494903 | 494903 | 2020-09-02 | Claiborne | Tennessee | 47025 | 372 | 3 |
494904 | 494904 | 2020-09-02 | Clay | Tennessee | 47027 | 118 | 2 |
494905 | 494905 | 2020-09-02 | Cocke | Tennessee | 47029 | 652 | 7 |
494906 | 494906 | 2020-09-02 | Coffee | Tennessee | 47031 | 785 | 6 |
494907 | 494907 | 2020-09-02 | Crockett | Tennessee | 47033 | 416 | 14 |
494908 | 494908 | 2020-09-02 | Cumberland | Tennessee | 47035 | 856 | 8 |
494909 | 494909 | 2020-09-02 | Davidson | Tennessee | 47037 | 26162 | 260 |
494910 | 494910 | 2020-09-02 | DeKalb | Tennessee | 47041 | 482 | 6 |
494911 | 494911 | 2020-09-02 | Decatur | Tennessee | 47039 | 317 | 4 |
494912 | 494912 | 2020-09-02 | Dickson | Tennessee | 47043 | 932 | 9 |
494913 | 494913 | 2020-09-02 | Dyer | Tennessee | 47045 | 988 | 10 |
494914 | 494914 | 2020-09-02 | Fayette | Tennessee | 47047 | 909 | 10 |
494915 | 494915 | 2020-09-02 | Fentress | Tennessee | 47049 | 247 | 0 |
494916 | 494916 | 2020-09-02 | Franklin | Tennessee | 47051 | 534 | 4 |
494917 | 494917 | 2020-09-02 | Gibson | Tennessee | 47053 | 1160 | 16 |
494918 | 494918 | 2020-09-02 | Giles | Tennessee | 47055 | 448 | 15 |
494919 | 494919 | 2020-09-02 | Grainger | Tennessee | 47057 | 282 | 1 |
494920 | 494920 | 2020-09-02 | Greene | Tennessee | 47059 | 857 | 17 |
494921 | 494921 | 2020-09-02 | Grundy | Tennessee | 47061 | 152 | 3 |
494922 | 494922 | 2020-09-02 | Hamblen | Tennessee | 47063 | 1668 | 22 |
494923 | 494923 | 2020-09-02 | Hamilton | Tennessee | 47065 | 8217 | 78 |
494924 | 494924 | 2020-09-02 | Hancock | Tennessee | 47067 | 92 | 2 |
494925 | 494925 | 2020-09-02 | Hardeman | Tennessee | 47069 | 1256 | 22 |
494926 | 494926 | 2020-09-02 | Hardin | Tennessee | 47071 | 731 | 10 |
494927 | 494927 | 2020-09-02 | Hawkins | Tennessee | 47073 | 679 | 13 |
494928 | 494928 | 2020-09-02 | Haywood | Tennessee | 47075 | 752 | 11 |
494929 | 494929 | 2020-09-02 | Henderson | Tennessee | 47077 | 901 | 8 |
494930 | 494930 | 2020-09-02 | Henry | Tennessee | 47079 | 474 | 7 |
494931 | 494931 | 2020-09-02 | Hickman | Tennessee | 47081 | 394 | 4 |
494932 | 494932 | 2020-09-02 | Houston | Tennessee | 47083 | 103 | 0 |
494933 | 494933 | 2020-09-02 | Humphreys | Tennessee | 47085 | 171 | 3 |
494934 | 494934 | 2020-09-02 | Jackson | Tennessee | 47087 | 221 | 2 |
494935 | 494935 | 2020-09-02 | Jefferson | Tennessee | 47089 | 830 | 7 |
494936 | 494936 | 2020-09-02 | Johnson | Tennessee | 47091 | 427 | 1 |
494937 | 494937 | 2020-09-02 | Knox | Tennessee | 47093 | 6987 | 61 |
494938 | 494938 | 2020-09-02 | Lake | Tennessee | 47095 | 848 | 2 |
494939 | 494939 | 2020-09-02 | Lauderdale | Tennessee | 47097 | 728 | 12 |
494940 | 494940 | 2020-09-02 | Lawrence | Tennessee | 47099 | 776 | 9 |
494941 | 494941 | 2020-09-02 | Lewis | Tennessee | 47101 | 134 | 1 |
494942 | 494942 | 2020-09-02 | Lincoln | Tennessee | 47103 | 424 | 1 |
494943 | 494943 | 2020-09-02 | Loudon | Tennessee | 47105 | 973 | 3 |
494944 | 494944 | 2020-09-02 | Macon | Tennessee | 47111 | 915 | 15 |
494945 | 494945 | 2020-09-02 | Madison | Tennessee | 47113 | 1882 | 44 |
494946 | 494946 | 2020-09-02 | Marion | Tennessee | 47115 | 342 | 7 |
494947 | 494947 | 2020-09-02 | Marshall | Tennessee | 47117 | 568 | 4 |
494948 | 494948 | 2020-09-02 | Maury | Tennessee | 47119 | 1807 | 15 |
494949 | 494949 | 2020-09-02 | McMinn | Tennessee | 47107 | 817 | 23 |
494950 | 494950 | 2020-09-02 | McNairy | Tennessee | 47109 | 583 | 12 |
494951 | 494951 | 2020-09-02 | Meigs | Tennessee | 47121 | 167 | 2 |
494952 | 494952 | 2020-09-02 | Monroe | Tennessee | 47123 | 784 | 15 |
494953 | 494953 | 2020-09-02 | Montgomery | Tennessee | 47125 | 2504 | 30 |
494954 | 494954 | 2020-09-02 | Moore | Tennessee | 47127 | 97 | 1 |
494955 | 494955 | 2020-09-02 | Morgan | Tennessee | 47129 | 220 | 2 |
494956 | 494956 | 2020-09-02 | Obion | Tennessee | 47131 | 837 | 8 |
494957 | 494957 | 2020-09-02 | Overton | Tennessee | 47133 | 450 | 2 |
494958 | 494958 | 2020-09-02 | Perry | Tennessee | 47135 | 113 | 0 |
494959 | 494959 | 2020-09-02 | Pickett | Tennessee | 47137 | 68 | 1 |
494960 | 494960 | 2020-09-02 | Polk | Tennessee | 47139 | 335 | 10 |
494961 | 494961 | 2020-09-02 | Putnam | Tennessee | 47141 | 2429 | 30 |
494962 | 494962 | 2020-09-02 | Rhea | Tennessee | 47143 | 672 | 5 |
494963 | 494963 | 2020-09-02 | Roane | Tennessee | 47145 | 671 | 2 |
494964 | 494964 | 2020-09-02 | Robertson | Tennessee | 47147 | 1908 | 26 |
494965 | 494965 | 2020-09-02 | Rutherford | Tennessee | 47149 | 7930 | 70 |
494966 | 494966 | 2020-09-02 | Scott | Tennessee | 47151 | 160 | 2 |
494967 | 494967 | 2020-09-02 | Sequatchie | Tennessee | 47153 | 149 | 1 |
494968 | 494968 | 2020-09-02 | Sevier | Tennessee | 47155 | 2278 | 12 |
494969 | 494969 | 2020-09-02 | Shelby | Tennessee | 47157 | 27779 | 389 |
494970 | 494970 | 2020-09-02 | Smith | Tennessee | 47159 | 525 | 8 |
494971 | 494971 | 2020-09-02 | Stewart | Tennessee | 47161 | 98 | 0 |
494972 | 494972 | 2020-09-02 | Sullivan | Tennessee | 47163 | 1730 | 26 |
494973 | 494973 | 2020-09-02 | Sumner | Tennessee | 47165 | 4136 | 87 |
494974 | 494974 | 2020-09-02 | Tipton | Tennessee | 47167 | 1481 | 15 |
494975 | 494975 | 2020-09-02 | Trousdale | Tennessee | 47169 | 1619 | 6 |
494976 | 494976 | 2020-09-02 | Unicoi | Tennessee | 47171 | 232 | 1 |
494977 | 494977 | 2020-09-02 | Union | Tennessee | 47173 | 229 | 1 |
494978 | 494978 | 2020-09-02 | Unknown | Tennessee | 0 | 6 | |
494979 | 494979 | 2020-09-02 | Van Buren | Tennessee | 47175 | 90 | 0 |
494980 | 494980 | 2020-09-02 | Warren | Tennessee | 47177 | 879 | 7 |
494981 | 494981 | 2020-09-02 | Washington | Tennessee | 47179 | 1812 | 13 |
494982 | 494982 | 2020-09-02 | Wayne | Tennessee | 47181 | 1450 | 3 |
494983 | 494983 | 2020-09-02 | Weakley | Tennessee | 47183 | 868 | 13 |
494984 | 494984 | 2020-09-02 | White | Tennessee | 47185 | 586 | 7 |
494985 | 494985 | 2020-09-02 | Williamson | Tennessee | 47187 | 4465 | 30 |
494986 | 494986 | 2020-09-02 | Wilson | Tennessee | 47189 | 2900 | 31 |
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);