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 2020-10-14 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630919 | 630919 | 2020-10-14 | Anderson | Tennessee | 47001 | 1463 | 13 |
630920 | 630920 | 2020-10-14 | Bedford | Tennessee | 47003 | 1536 | 19 |
630921 | 630921 | 2020-10-14 | Benton | Tennessee | 47005 | 368 | 9 |
630922 | 630922 | 2020-10-14 | Bledsoe | Tennessee | 47007 | 901 | 4 |
630923 | 630923 | 2020-10-14 | Blount | Tennessee | 47009 | 2947 | 31 |
630924 | 630924 | 2020-10-14 | Bradley | Tennessee | 47011 | 3279 | 20 |
630925 | 630925 | 2020-10-14 | Campbell | Tennessee | 47013 | 747 | 5 |
630926 | 630926 | 2020-10-14 | Cannon | Tennessee | 47015 | 361 | 2 |
630927 | 630927 | 2020-10-14 | Carroll | Tennessee | 47017 | 1063 | 24 |
630928 | 630928 | 2020-10-14 | Carter | Tennessee | 47019 | 1339 | 32 |
630929 | 630929 | 2020-10-14 | Cheatham | Tennessee | 47021 | 912 | 10 |
630930 | 630930 | 2020-10-14 | Chester | Tennessee | 47023 | 699 | 13 |
630931 | 630931 | 2020-10-14 | Claiborne | Tennessee | 47025 | 484 | 5 |
630932 | 630932 | 2020-10-14 | Clay | Tennessee | 47027 | 344 | 6 |
630933 | 630933 | 2020-10-14 | Cocke | Tennessee | 47029 | 870 | 11 |
630934 | 630934 | 2020-10-14 | Coffee | Tennessee | 47031 | 1630 | 18 |
630935 | 630935 | 2020-10-14 | Crockett | Tennessee | 47033 | 699 | 19 |
630936 | 630936 | 2020-10-14 | Cumberland | Tennessee | 47035 | 1427 | 24 |
630937 | 630937 | 2020-10-14 | Davidson | Tennessee | 47037 | 30957 | 323 |
630938 | 630938 | 2020-10-14 | DeKalb | Tennessee | 47041 | 645 | 16 |
630939 | 630939 | 2020-10-14 | Decatur | Tennessee | 47039 | 600 | 11 |
630940 | 630940 | 2020-10-14 | Dickson | Tennessee | 47043 | 1472 | 17 |
630941 | 630941 | 2020-10-14 | Dyer | Tennessee | 47045 | 1840 | 24 |
630942 | 630942 | 2020-10-14 | Fayette | Tennessee | 47047 | 1432 | 21 |
630943 | 630943 | 2020-10-14 | Fentress | Tennessee | 47049 | 802 | 5 |
630944 | 630944 | 2020-10-14 | Franklin | Tennessee | 47051 | 1154 | 14 |
630945 | 630945 | 2020-10-14 | Gibson | Tennessee | 47053 | 1982 | 33 |
630946 | 630946 | 2020-10-14 | Giles | Tennessee | 47055 | 824 | 31 |
630947 | 630947 | 2020-10-14 | Grainger | Tennessee | 47057 | 491 | 4 |
630948 | 630948 | 2020-10-14 | Greene | Tennessee | 47059 | 1383 | 48 |
630949 | 630949 | 2020-10-14 | Grundy | Tennessee | 47061 | 467 | 8 |
630950 | 630950 | 2020-10-14 | Hamblen | Tennessee | 47063 | 2254 | 41 |
630951 | 630951 | 2020-10-14 | Hamilton | Tennessee | 47065 | 10907 | 103 |
630952 | 630952 | 2020-10-14 | Hancock | Tennessee | 47067 | 112 | 3 |
630953 | 630953 | 2020-10-14 | Hardeman | Tennessee | 47069 | 1727 | 32 |
630954 | 630954 | 2020-10-14 | Hardin | Tennessee | 47071 | 1240 | 19 |
630955 | 630955 | 2020-10-14 | Hawkins | Tennessee | 47073 | 1016 | 23 |
630956 | 630956 | 2020-10-14 | Haywood | Tennessee | 47075 | 1159 | 25 |
630957 | 630957 | 2020-10-14 | Henderson | Tennessee | 47077 | 1327 | 24 |
630958 | 630958 | 2020-10-14 | Henry | Tennessee | 47079 | 697 | 10 |
630959 | 630959 | 2020-10-14 | Hickman | Tennessee | 47081 | 710 | 13 |
630960 | 630960 | 2020-10-14 | Houston | Tennessee | 47083 | 370 | 14 |
630961 | 630961 | 2020-10-14 | Humphreys | Tennessee | 47085 | 367 | 4 |
630962 | 630962 | 2020-10-14 | Jackson | Tennessee | 47087 | 399 | 5 |
630963 | 630963 | 2020-10-14 | Jefferson | Tennessee | 47089 | 1380 | 17 |
630964 | 630964 | 2020-10-14 | Johnson | Tennessee | 47091 | 1050 | 6 |
630965 | 630965 | 2020-10-14 | Knox | Tennessee | 47093 | 11761 | 90 |
630966 | 630966 | 2020-10-14 | Lake | Tennessee | 47095 | 952 | 3 |
630967 | 630967 | 2020-10-14 | Lauderdale | Tennessee | 47097 | 1206 | 16 |
630968 | 630968 | 2020-10-14 | Lawrence | Tennessee | 47099 | 1332 | 17 |
630969 | 630969 | 2020-10-14 | Lewis | Tennessee | 47101 | 294 | 2 |
630970 | 630970 | 2020-10-14 | Lincoln | Tennessee | 47103 | 745 | 2 |
630971 | 630971 | 2020-10-14 | Loudon | Tennessee | 47105 | 1483 | 9 |
630972 | 630972 | 2020-10-14 | Macon | Tennessee | 47111 | 1214 | 23 |
630973 | 630973 | 2020-10-14 | Madison | Tennessee | 47113 | 3432 | 76 |
630974 | 630974 | 2020-10-14 | Marion | Tennessee | 47115 | 640 | 9 |
630975 | 630975 | 2020-10-14 | Marshall | Tennessee | 47117 | 968 | 6 |
630976 | 630976 | 2020-10-14 | Maury | Tennessee | 47119 | 2858 | 34 |
630977 | 630977 | 2020-10-14 | McMinn | Tennessee | 47107 | 1370 | 31 |
630978 | 630978 | 2020-10-14 | McNairy | Tennessee | 47109 | 1048 | 24 |
630979 | 630979 | 2020-10-14 | Meigs | Tennessee | 47121 | 265 | 4 |
630980 | 630980 | 2020-10-14 | Monroe | Tennessee | 47123 | 1239 | 21 |
630981 | 630981 | 2020-10-14 | Montgomery | Tennessee | 47125 | 3623 | 50 |
630982 | 630982 | 2020-10-14 | Moore | Tennessee | 47127 | 227 | 1 |
630983 | 630983 | 2020-10-14 | Morgan | Tennessee | 47129 | 380 | 6 |
630984 | 630984 | 2020-10-14 | Obion | Tennessee | 47131 | 1555 | 18 |
630985 | 630985 | 2020-10-14 | Overton | Tennessee | 47133 | 1032 | 8 |
630986 | 630986 | 2020-10-14 | Perry | Tennessee | 47135 | 175 | 1 |
630987 | 630987 | 2020-10-14 | Pickett | Tennessee | 47137 | 218 | 3 |
630988 | 630988 | 2020-10-14 | Polk | Tennessee | 47139 | 448 | 13 |
630989 | 630989 | 2020-10-14 | Putnam | Tennessee | 47141 | 3899 | 51 |
630990 | 630990 | 2020-10-14 | Rhea | Tennessee | 47143 | 988 | 16 |
630991 | 630991 | 2020-10-14 | Roane | Tennessee | 47145 | 1111 | 6 |
630992 | 630992 | 2020-10-14 | Robertson | Tennessee | 47147 | 2401 | 39 |
630993 | 630993 | 2020-10-14 | Rutherford | Tennessee | 47149 | 10570 | 104 |
630994 | 630994 | 2020-10-14 | Scott | Tennessee | 47151 | 294 | 3 |
630995 | 630995 | 2020-10-14 | Sequatchie | Tennessee | 47153 | 289 | 3 |
630996 | 630996 | 2020-10-14 | Sevier | Tennessee | 47155 | 3006 | 19 |
630997 | 630997 | 2020-10-14 | Shelby | Tennessee | 47157 | 33625 | 545 |
630998 | 630998 | 2020-10-14 | Smith | Tennessee | 47159 | 896 | 12 |
630999 | 630999 | 2020-10-14 | Stewart | Tennessee | 47161 | 294 | 6 |
631000 | 631000 | 2020-10-14 | Sullivan | Tennessee | 47163 | 2830 | 40 |
631001 | 631001 | 2020-10-14 | Sumner | Tennessee | 47165 | 5360 | 105 |
631002 | 631002 | 2020-10-14 | Tipton | Tennessee | 47167 | 2113 | 22 |
631003 | 631003 | 2020-10-14 | Trousdale | Tennessee | 47169 | 1717 | 7 |
631004 | 631004 | 2020-10-14 | Unicoi | Tennessee | 47171 | 309 | 1 |
631005 | 631005 | 2020-10-14 | Union | Tennessee | 47173 | 470 | 2 |
631006 | 631006 | 2020-10-14 | Unknown | Tennessee | 129 | 0 | |
631007 | 631007 | 2020-10-14 | Van Buren | Tennessee | 47175 | 185 | 1 |
631008 | 631008 | 2020-10-14 | Warren | Tennessee | 47177 | 1252 | 9 |
631009 | 631009 | 2020-10-14 | Washington | Tennessee | 47179 | 2801 | 42 |
631010 | 631010 | 2020-10-14 | Wayne | Tennessee | 47181 | 1546 | 7 |
631011 | 631011 | 2020-10-14 | Weakley | Tennessee | 47183 | 1394 | 23 |
631012 | 631012 | 2020-10-14 | White | Tennessee | 47185 | 1014 | 13 |
631013 | 631013 | 2020-10-14 | Williamson | Tennessee | 47187 | 6194 | 47 |
631014 | 631014 | 2020-10-14 | Wilson | Tennessee | 47189 | 4155 | 52 |
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);