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-06-03 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1383956 | 1383956 | 2021-06-03 | Anderson | Tennessee | 47001 | 8830 | 172 |
1383957 | 1383957 | 2021-06-03 | Bedford | Tennessee | 47003 | 6550 | 130 |
1383958 | 1383958 | 2021-06-03 | Benton | Tennessee | 47005 | 1682 | 42 |
1383959 | 1383959 | 2021-06-03 | Bledsoe | Tennessee | 47007 | 2190 | 11 |
1383960 | 1383960 | 2021-06-03 | Blount | Tennessee | 47009 | 15628 | 196 |
1383961 | 1383961 | 2021-06-03 | Bradley | Tennessee | 47011 | 15211 | 153 |
1383962 | 1383962 | 2021-06-03 | Campbell | Tennessee | 47013 | 4203 | 63 |
1383963 | 1383963 | 2021-06-03 | Cannon | Tennessee | 47015 | 1937 | 32 |
1383964 | 1383964 | 2021-06-03 | Carroll | Tennessee | 47017 | 3660 | 83 |
1383965 | 1383965 | 2021-06-03 | Carter | Tennessee | 47019 | 6706 | 159 |
1383966 | 1383966 | 2021-06-03 | Cheatham | Tennessee | 47021 | 4607 | 56 |
1383967 | 1383967 | 2021-06-03 | Chester | Tennessee | 47023 | 2173 | 51 |
1383968 | 1383968 | 2021-06-03 | Claiborne | Tennessee | 47025 | 3200 | 74 |
1383969 | 1383969 | 2021-06-03 | Clay | Tennessee | 47027 | 1102 | 30 |
1383970 | 1383970 | 2021-06-03 | Cocke | Tennessee | 47029 | 4540 | 100 |
1383971 | 1383971 | 2021-06-03 | Coffee | Tennessee | 47031 | 6955 | 125 |
1383972 | 1383972 | 2021-06-03 | Crockett | Tennessee | 47033 | 2042 | 49 |
1383973 | 1383973 | 2021-06-03 | Cumberland | Tennessee | 47035 | 6828 | 138 |
1383974 | 1383974 | 2021-06-03 | Davidson | Tennessee | 47037 | 99392 | 952 |
1383975 | 1383975 | 2021-06-03 | DeKalb | Tennessee | 47041 | 2826 | 54 |
1383976 | 1383976 | 2021-06-03 | Decatur | Tennessee | 47039 | 1602 | 39 |
1383977 | 1383977 | 2021-06-03 | Dickson | Tennessee | 47043 | 6908 | 114 |
1383978 | 1383978 | 2021-06-03 | Dyer | Tennessee | 47045 | 5459 | 107 |
1383979 | 1383979 | 2021-06-03 | Fayette | Tennessee | 47047 | 5159 | 83 |
1383980 | 1383980 | 2021-06-03 | Fentress | Tennessee | 47049 | 2442 | 48 |
1383981 | 1383981 | 2021-06-03 | Franklin | Tennessee | 47051 | 5178 | 91 |
1383982 | 1383982 | 2021-06-03 | Gibson | Tennessee | 47053 | 6617 | 147 |
1383983 | 1383983 | 2021-06-03 | Giles | Tennessee | 47055 | 4028 | 101 |
1383984 | 1383984 | 2021-06-03 | Grainger | Tennessee | 47057 | 2654 | 49 |
1383985 | 1383985 | 2021-06-03 | Greene | Tennessee | 47059 | 7982 | 159 |
1383986 | 1383986 | 2021-06-03 | Grundy | Tennessee | 47061 | 1797 | 35 |
1383987 | 1383987 | 2021-06-03 | Hamblen | Tennessee | 47063 | 8632 | 174 |
1383988 | 1383988 | 2021-06-03 | Hamilton | Tennessee | 47065 | 45206 | 502 |
1383989 | 1383989 | 2021-06-03 | Hancock | Tennessee | 47067 | 603 | 12 |
1383990 | 1383990 | 2021-06-03 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1383991 | 1383991 | 2021-06-03 | Hardin | Tennessee | 47071 | 3601 | 68 |
1383992 | 1383992 | 2021-06-03 | Hawkins | Tennessee | 47073 | 6294 | 112 |
1383993 | 1383993 | 2021-06-03 | Haywood | Tennessee | 47075 | 2711 | 62 |
1383994 | 1383994 | 2021-06-03 | Henderson | Tennessee | 47077 | 3840 | 77 |
1383995 | 1383995 | 2021-06-03 | Henry | Tennessee | 47079 | 3250 | 76 |
1383996 | 1383996 | 2021-06-03 | Hickman | Tennessee | 47081 | 2865 | 46 |
1383997 | 1383997 | 2021-06-03 | Houston | Tennessee | 47083 | 1109 | 33 |
1383998 | 1383998 | 2021-06-03 | Humphreys | Tennessee | 47085 | 1871 | 28 |
1383999 | 1383999 | 2021-06-03 | Jackson | Tennessee | 47087 | 1331 | 36 |
1384000 | 1384000 | 2021-06-03 | Jefferson | Tennessee | 47089 | 6283 | 125 |
1384001 | 1384001 | 2021-06-03 | Johnson | Tennessee | 47091 | 2439 | 39 |
1384002 | 1384002 | 2021-06-03 | Knox | Tennessee | 47093 | 52066 | 639 |
1384003 | 1384003 | 2021-06-03 | Lake | Tennessee | 47095 | 1716 | 26 |
1384004 | 1384004 | 2021-06-03 | Lauderdale | Tennessee | 47097 | 3238 | 48 |
1384005 | 1384005 | 2021-06-03 | Lawrence | Tennessee | 47099 | 6039 | 92 |
1384006 | 1384006 | 2021-06-03 | Lewis | Tennessee | 47101 | 1590 | 26 |
1384007 | 1384007 | 2021-06-03 | Lincoln | Tennessee | 47103 | 4369 | 67 |
1384008 | 1384008 | 2021-06-03 | Loudon | Tennessee | 47105 | 6220 | 70 |
1384009 | 1384009 | 2021-06-03 | Macon | Tennessee | 47111 | 3646 | 78 |
1384010 | 1384010 | 2021-06-03 | Madison | Tennessee | 47113 | 11407 | 241 |
1384011 | 1384011 | 2021-06-03 | Marion | Tennessee | 47115 | 3153 | 47 |
1384012 | 1384012 | 2021-06-03 | Marshall | Tennessee | 47117 | 4223 | 59 |
1384013 | 1384013 | 2021-06-03 | Maury | Tennessee | 47119 | 13606 | 174 |
1384014 | 1384014 | 2021-06-03 | McMinn | Tennessee | 47107 | 6597 | 101 |
1384015 | 1384015 | 2021-06-03 | McNairy | Tennessee | 47109 | 2855 | 54 |
1384016 | 1384016 | 2021-06-03 | Meigs | Tennessee | 47121 | 1408 | 25 |
1384017 | 1384017 | 2021-06-03 | Monroe | Tennessee | 47123 | 5930 | 97 |
1384018 | 1384018 | 2021-06-03 | Montgomery | Tennessee | 47125 | 20744 | 229 |
1384019 | 1384019 | 2021-06-03 | Moore | Tennessee | 47127 | 1019 | 17 |
1384020 | 1384020 | 2021-06-03 | Morgan | Tennessee | 47129 | 2525 | 39 |
1384021 | 1384021 | 2021-06-03 | Obion | Tennessee | 47131 | 4590 | 97 |
1384022 | 1384022 | 2021-06-03 | Overton | Tennessee | 47133 | 3034 | 61 |
1384023 | 1384023 | 2021-06-03 | Perry | Tennessee | 47135 | 1069 | 28 |
1384024 | 1384024 | 2021-06-03 | Pickett | Tennessee | 47137 | 763 | 24 |
1384025 | 1384025 | 2021-06-03 | Polk | Tennessee | 47139 | 2109 | 25 |
1384026 | 1384026 | 2021-06-03 | Putnam | Tennessee | 47141 | 11484 | 178 |
1384027 | 1384027 | 2021-06-03 | Rhea | Tennessee | 47143 | 4383 | 75 |
1384028 | 1384028 | 2021-06-03 | Roane | Tennessee | 47145 | 6347 | 105 |
1384029 | 1384029 | 2021-06-03 | Robertson | Tennessee | 47147 | 9844 | 132 |
1384030 | 1384030 | 2021-06-03 | Rutherford | Tennessee | 47149 | 43507 | 443 |
1384031 | 1384031 | 2021-06-03 | Scott | Tennessee | 47151 | 3191 | 45 |
1384032 | 1384032 | 2021-06-03 | Sequatchie | Tennessee | 47153 | 1742 | 29 |
1384033 | 1384033 | 2021-06-03 | Sevier | Tennessee | 47155 | 13503 | 176 |
1384034 | 1384034 | 2021-06-03 | Shelby | Tennessee | 47157 | 98829 | 1677 |
1384035 | 1384035 | 2021-06-03 | Smith | Tennessee | 47159 | 2796 | 40 |
1384036 | 1384036 | 2021-06-03 | Stewart | Tennessee | 47161 | 1358 | 28 |
1384037 | 1384037 | 2021-06-03 | Sullivan | Tennessee | 47163 | 17208 | 304 |
1384038 | 1384038 | 2021-06-03 | Sumner | Tennessee | 47165 | 24318 | 352 |
1384039 | 1384039 | 2021-06-03 | Tipton | Tennessee | 47167 | 7442 | 105 |
1384040 | 1384040 | 2021-06-03 | Trousdale | Tennessee | 47169 | 2511 | 22 |
1384041 | 1384041 | 2021-06-03 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1384042 | 1384042 | 2021-06-03 | Union | Tennessee | 47173 | 1948 | 34 |
1384043 | 1384043 | 2021-06-03 | Unknown | Tennessee | 9655 | 126 | |
1384044 | 1384044 | 2021-06-03 | Van Buren | Tennessee | 47175 | 860 | 23 |
1384045 | 1384045 | 2021-06-03 | Warren | Tennessee | 47177 | 5556 | 83 |
1384046 | 1384046 | 2021-06-03 | Washington | Tennessee | 47179 | 14816 | 251 |
1384047 | 1384047 | 2021-06-03 | Wayne | Tennessee | 47181 | 2975 | 34 |
1384048 | 1384048 | 2021-06-03 | Weakley | Tennessee | 47183 | 4195 | 67 |
1384049 | 1384049 | 2021-06-03 | White | Tennessee | 47185 | 3707 | 74 |
1384050 | 1384050 | 2021-06-03 | Williamson | Tennessee | 47187 | 28299 | 218 |
1384051 | 1384051 | 2021-06-03 | Wilson | Tennessee | 47189 | 19051 | 240 |
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);