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-01-20 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948927 | 948927 | 2021-01-20 | Anderson | Tennessee | 47001 | 6864 | 107 |
948928 | 948928 | 2021-01-20 | Bedford | Tennessee | 47003 | 5356 | 90 |
948929 | 948929 | 2021-01-20 | Benton | Tennessee | 47005 | 1325 | 35 |
948930 | 948930 | 2021-01-20 | Bledsoe | Tennessee | 47007 | 1754 | 11 |
948931 | 948931 | 2021-01-20 | Blount | Tennessee | 47009 | 12146 | 127 |
948932 | 948932 | 2021-01-20 | Bradley | Tennessee | 47011 | 10934 | 94 |
948933 | 948933 | 2021-01-20 | Campbell | Tennessee | 47013 | 3286 | 40 |
948934 | 948934 | 2021-01-20 | Cannon | Tennessee | 47015 | 1589 | 20 |
948935 | 948935 | 2021-01-20 | Carroll | Tennessee | 47017 | 3140 | 59 |
948936 | 948936 | 2021-01-20 | Carter | Tennessee | 47019 | 5145 | 115 |
948937 | 948937 | 2021-01-20 | Cheatham | Tennessee | 47021 | 3439 | 30 |
948938 | 948938 | 2021-01-20 | Chester | Tennessee | 47023 | 1758 | 38 |
948939 | 948939 | 2021-01-20 | Claiborne | Tennessee | 47025 | 2176 | 29 |
948940 | 948940 | 2021-01-20 | Clay | Tennessee | 47027 | 946 | 26 |
948941 | 948941 | 2021-01-20 | Cocke | Tennessee | 47029 | 3486 | 57 |
948942 | 948942 | 2021-01-20 | Coffee | Tennessee | 47031 | 5673 | 82 |
948943 | 948943 | 2021-01-20 | Crockett | Tennessee | 47033 | 1813 | 38 |
948944 | 948944 | 2021-01-20 | Cumberland | Tennessee | 47035 | 5441 | 73 |
948945 | 948945 | 2021-01-20 | Davidson | Tennessee | 47037 | 80663 | 678 |
948946 | 948946 | 2021-01-20 | DeKalb | Tennessee | 47041 | 2441 | 42 |
948947 | 948947 | 2021-01-20 | Decatur | Tennessee | 47039 | 1481 | 27 |
948948 | 948948 | 2021-01-20 | Dickson | Tennessee | 47043 | 5435 | 79 |
948949 | 948949 | 2021-01-20 | Dyer | Tennessee | 47045 | 4786 | 83 |
948950 | 948950 | 2021-01-20 | Fayette | Tennessee | 47047 | 4021 | 51 |
948951 | 948951 | 2021-01-20 | Fentress | Tennessee | 47049 | 2142 | 33 |
948952 | 948952 | 2021-01-20 | Franklin | Tennessee | 47051 | 4152 | 63 |
948953 | 948953 | 2021-01-20 | Gibson | Tennessee | 47053 | 5671 | 112 |
948954 | 948954 | 2021-01-20 | Giles | Tennessee | 47055 | 3253 | 73 |
948955 | 948955 | 2021-01-20 | Grainger | Tennessee | 47057 | 2112 | 37 |
948956 | 948956 | 2021-01-20 | Greene | Tennessee | 47059 | 6655 | 108 |
948957 | 948957 | 2021-01-20 | Grundy | Tennessee | 47061 | 1403 | 21 |
948958 | 948958 | 2021-01-20 | Hamblen | Tennessee | 47063 | 7088 | 112 |
948959 | 948959 | 2021-01-20 | Hamilton | Tennessee | 47065 | 36447 | 332 |
948960 | 948960 | 2021-01-20 | Hancock | Tennessee | 47067 | 407 | 6 |
948961 | 948961 | 2021-01-20 | Hardeman | Tennessee | 47069 | 3112 | 52 |
948962 | 948962 | 2021-01-20 | Hardin | Tennessee | 47071 | 3000 | 48 |
948963 | 948963 | 2021-01-20 | Hawkins | Tennessee | 47073 | 4499 | 70 |
948964 | 948964 | 2021-01-20 | Haywood | Tennessee | 47075 | 2410 | 45 |
948965 | 948965 | 2021-01-20 | Henderson | Tennessee | 47077 | 3346 | 58 |
948966 | 948966 | 2021-01-20 | Henry | Tennessee | 47079 | 2629 | 58 |
948967 | 948967 | 2021-01-20 | Hickman | Tennessee | 47081 | 2258 | 34 |
948968 | 948968 | 2021-01-20 | Houston | Tennessee | 47083 | 942 | 22 |
948969 | 948969 | 2021-01-20 | Humphreys | Tennessee | 47085 | 1344 | 17 |
948970 | 948970 | 2021-01-20 | Jackson | Tennessee | 47087 | 1054 | 23 |
948971 | 948971 | 2021-01-20 | Jefferson | Tennessee | 47089 | 4838 | 76 |
948972 | 948972 | 2021-01-20 | Johnson | Tennessee | 47091 | 2030 | 33 |
948973 | 948973 | 2021-01-20 | Knox | Tennessee | 47093 | 40487 | 423 |
948974 | 948974 | 2021-01-20 | Lake | Tennessee | 47095 | 1566 | 20 |
948975 | 948975 | 2021-01-20 | Lauderdale | Tennessee | 47097 | 2951 | 31 |
948976 | 948976 | 2021-01-20 | Lawrence | Tennessee | 47099 | 5142 | 69 |
948977 | 948977 | 2021-01-20 | Lewis | Tennessee | 47101 | 1286 | 20 |
948978 | 948978 | 2021-01-20 | Lincoln | Tennessee | 47103 | 3812 | 44 |
948979 | 948979 | 2021-01-20 | Loudon | Tennessee | 47105 | 5000 | 50 |
948980 | 948980 | 2021-01-20 | Macon | Tennessee | 47111 | 2914 | 50 |
948981 | 948981 | 2021-01-20 | Madison | Tennessee | 47113 | 9205 | 180 |
948982 | 948982 | 2021-01-20 | Marion | Tennessee | 47115 | 2308 | 31 |
948983 | 948983 | 2021-01-20 | Marshall | Tennessee | 47117 | 3492 | 38 |
948984 | 948984 | 2021-01-20 | Maury | Tennessee | 47119 | 11079 | 125 |
948985 | 948985 | 2021-01-20 | McMinn | Tennessee | 47107 | 5117 | 73 |
948986 | 948986 | 2021-01-20 | McNairy | Tennessee | 47109 | 2422 | 42 |
948987 | 948987 | 2021-01-20 | Meigs | Tennessee | 47121 | 1164 | 16 |
948988 | 948988 | 2021-01-20 | Monroe | Tennessee | 47123 | 4627 | 63 |
948989 | 948989 | 2021-01-20 | Montgomery | Tennessee | 47125 | 14719 | 149 |
948990 | 948990 | 2021-01-20 | Moore | Tennessee | 47127 | 817 | 9 |
948991 | 948991 | 2021-01-20 | Morgan | Tennessee | 47129 | 1912 | 15 |
948992 | 948992 | 2021-01-20 | Obion | Tennessee | 47131 | 4019 | 80 |
948993 | 948993 | 2021-01-20 | Overton | Tennessee | 47133 | 2561 | 45 |
948994 | 948994 | 2021-01-20 | Perry | Tennessee | 47135 | 953 | 25 |
948995 | 948995 | 2021-01-20 | Pickett | Tennessee | 47137 | 685 | 20 |
948996 | 948996 | 2021-01-20 | Polk | Tennessee | 47139 | 1445 | 17 |
948997 | 948997 | 2021-01-20 | Putnam | Tennessee | 47141 | 10001 | 148 |
948998 | 948998 | 2021-01-20 | Rhea | Tennessee | 47143 | 3847 | 56 |
948999 | 948999 | 2021-01-20 | Roane | Tennessee | 47145 | 5263 | 79 |
949000 | 949000 | 2021-01-20 | Robertson | Tennessee | 47147 | 7741 | 85 |
949001 | 949001 | 2021-01-20 | Rutherford | Tennessee | 47149 | 33516 | 288 |
949002 | 949002 | 2021-01-20 | Scott | Tennessee | 47151 | 2273 | 31 |
949003 | 949003 | 2021-01-20 | Sequatchie | Tennessee | 47153 | 1383 | 18 |
949004 | 949004 | 2021-01-20 | Sevier | Tennessee | 47155 | 10589 | 110 |
949005 | 949005 | 2021-01-20 | Shelby | Tennessee | 47157 | 79051 | 1154 |
949006 | 949006 | 2021-01-20 | Smith | Tennessee | 47159 | 2330 | 28 |
949007 | 949007 | 2021-01-20 | Stewart | Tennessee | 47161 | 1070 | 20 |
949008 | 949008 | 2021-01-20 | Sullivan | Tennessee | 47163 | 12736 | 212 |
949009 | 949009 | 2021-01-20 | Sumner | Tennessee | 47165 | 18454 | 232 |
949010 | 949010 | 2021-01-20 | Tipton | Tennessee | 47167 | 6268 | 65 |
949011 | 949011 | 2021-01-20 | Trousdale | Tennessee | 47169 | 2293 | 14 |
949012 | 949012 | 2021-01-20 | Unicoi | Tennessee | 47171 | 1683 | 44 |
949013 | 949013 | 2021-01-20 | Union | Tennessee | 47173 | 1407 | 23 |
949014 | 949014 | 2021-01-20 | Unknown | Tennessee | 12776 | 107 | |
949015 | 949015 | 2021-01-20 | Van Buren | Tennessee | 47175 | 666 | 7 |
949016 | 949016 | 2021-01-20 | Warren | Tennessee | 47177 | 5026 | 53 |
949017 | 949017 | 2021-01-20 | Washington | Tennessee | 47179 | 12010 | 193 |
949018 | 949018 | 2021-01-20 | Wayne | Tennessee | 47181 | 2650 | 20 |
949019 | 949019 | 2021-01-20 | Weakley | Tennessee | 47183 | 3418 | 48 |
949020 | 949020 | 2021-01-20 | White | Tennessee | 47185 | 3126 | 43 |
949021 | 949021 | 2021-01-20 | Williamson | Tennessee | 47187 | 21679 | 141 |
949022 | 949022 | 2021-01-20 | Wilson | Tennessee | 47189 | 14622 | 159 |
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);