ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1043047 | 1043047 | 2021-02-18 | Anderson | Tennessee | 47001 | 7794 | 149 |
1043048 | 1043048 | 2021-02-18 | Bedford | Tennessee | 47003 | 5717 | 117 |
1043049 | 1043049 | 2021-02-18 | Benton | Tennessee | 47005 | 1497 | 39 |
1043050 | 1043050 | 2021-02-18 | Bledsoe | Tennessee | 47007 | 1971 | 10 |
1043051 | 1043051 | 2021-02-18 | Blount | Tennessee | 47009 | 13800 | 174 |
1043052 | 1043052 | 2021-02-18 | Bradley | Tennessee | 47011 | 12530 | 135 |
1043053 | 1043053 | 2021-02-18 | Campbell | Tennessee | 47013 | 3724 | 55 |
1043054 | 1043054 | 2021-02-18 | Cannon | Tennessee | 47015 | 1723 | 28 |
1043055 | 1043055 | 2021-02-18 | Carroll | Tennessee | 47017 | 3452 | 80 |
1043056 | 1043056 | 2021-02-18 | Carter | Tennessee | 47019 | 5877 | 150 |
1043057 | 1043057 | 2021-02-18 | Cheatham | Tennessee | 47021 | 3812 | 43 |
1043058 | 1043058 | 2021-02-18 | Chester | Tennessee | 47023 | 1998 | 45 |
1043059 | 1043059 | 2021-02-18 | Claiborne | Tennessee | 47025 | 2640 | 64 |
1043060 | 1043060 | 2021-02-18 | Clay | Tennessee | 47027 | 1055 | 29 |
1043061 | 1043061 | 2021-02-18 | Cocke | Tennessee | 47029 | 3932 | 91 |
1043062 | 1043062 | 2021-02-18 | Coffee | Tennessee | 47031 | 6206 | 112 |
1043063 | 1043063 | 2021-02-18 | Crockett | Tennessee | 47033 | 1957 | 46 |
1043064 | 1043064 | 2021-02-18 | Cumberland | Tennessee | 47035 | 6025 | 113 |
1043065 | 1043065 | 2021-02-18 | Davidson | Tennessee | 47037 | 88382 | 823 |
1043066 | 1043066 | 2021-02-18 | DeKalb | Tennessee | 47041 | 2604 | 47 |
1043067 | 1043067 | 2021-02-18 | Decatur | Tennessee | 47039 | 1530 | 35 |
1043068 | 1043068 | 2021-02-18 | Dickson | Tennessee | 47043 | 6053 | 102 |
1043069 | 1043069 | 2021-02-18 | Dyer | Tennessee | 47045 | 5211 | 99 |
1043070 | 1043070 | 2021-02-18 | Fayette | Tennessee | 47047 | 4614 | 71 |
1043071 | 1043071 | 2021-02-18 | Fentress | Tennessee | 47049 | 2274 | 43 |
1043072 | 1043072 | 2021-02-18 | Franklin | Tennessee | 47051 | 4644 | 80 |
1043073 | 1043073 | 2021-02-18 | Gibson | Tennessee | 47053 | 6140 | 138 |
1043074 | 1043074 | 2021-02-18 | Giles | Tennessee | 47055 | 3679 | 95 |
1043075 | 1043075 | 2021-02-18 | Grainger | Tennessee | 47057 | 2380 | 46 |
1043076 | 1043076 | 2021-02-18 | Greene | Tennessee | 47059 | 7213 | 142 |
1043077 | 1043077 | 2021-02-18 | Grundy | Tennessee | 47061 | 1636 | 29 |
1043078 | 1043078 | 2021-02-18 | Hamblen | Tennessee | 47063 | 7859 | 161 |
1043079 | 1043079 | 2021-02-18 | Hamilton | Tennessee | 47065 | 39756 | 442 |
1043080 | 1043080 | 2021-02-18 | Hancock | Tennessee | 47067 | 488 | 11 |
1043081 | 1043081 | 2021-02-18 | Hardeman | Tennessee | 47069 | 3369 | 61 |
1043082 | 1043082 | 2021-02-18 | Hardin | Tennessee | 47071 | 3286 | 62 |
1043083 | 1043083 | 2021-02-18 | Hawkins | Tennessee | 47073 | 5093 | 91 |
1043084 | 1043084 | 2021-02-18 | Haywood | Tennessee | 47075 | 2635 | 59 |
1043085 | 1043085 | 2021-02-18 | Henderson | Tennessee | 47077 | 3587 | 71 |
1043086 | 1043086 | 2021-02-18 | Henry | Tennessee | 47079 | 2973 | 73 |
1043087 | 1043087 | 2021-02-18 | Hickman | Tennessee | 47081 | 2608 | 38 |
1043088 | 1043088 | 2021-02-18 | Houston | Tennessee | 47083 | 1015 | 30 |
1043089 | 1043089 | 2021-02-18 | Humphreys | Tennessee | 47085 | 1498 | 21 |
1043090 | 1043090 | 2021-02-18 | Jackson | Tennessee | 47087 | 1245 | 33 |
1043091 | 1043091 | 2021-02-18 | Jefferson | Tennessee | 47089 | 5508 | 115 |
1043092 | 1043092 | 2021-02-18 | Johnson | Tennessee | 47091 | 2136 | 37 |
1043093 | 1043093 | 2021-02-18 | Knox | Tennessee | 47093 | 45720 | 557 |
1043094 | 1043094 | 2021-02-18 | Lake | Tennessee | 47095 | 1669 | 25 |
1043095 | 1043095 | 2021-02-18 | Lauderdale | Tennessee | 47097 | 3082 | 40 |
1043096 | 1043096 | 2021-02-18 | Lawrence | Tennessee | 47099 | 5527 | 79 |
1043097 | 1043097 | 2021-02-18 | Lewis | Tennessee | 47101 | 1437 | 24 |
1043098 | 1043098 | 2021-02-18 | Lincoln | Tennessee | 47103 | 4082 | 61 |
1043099 | 1043099 | 2021-02-18 | Loudon | Tennessee | 47105 | 5539 | 64 |
1043100 | 1043100 | 2021-02-18 | Macon | Tennessee | 47111 | 3324 | 73 |
1043101 | 1043101 | 2021-02-18 | Madison | Tennessee | 47113 | 9979 | 225 |
1043102 | 1043102 | 2021-02-18 | Marion | Tennessee | 47115 | 2867 | 44 |
1043103 | 1043103 | 2021-02-18 | Marshall | Tennessee | 47117 | 3863 | 54 |
1043104 | 1043104 | 2021-02-18 | Maury | Tennessee | 47119 | 12064 | 155 |
1043105 | 1043105 | 2021-02-18 | McMinn | Tennessee | 47107 | 5801 | 88 |
1043106 | 1043106 | 2021-02-18 | McNairy | Tennessee | 47109 | 2627 | 49 |
1043107 | 1043107 | 2021-02-18 | Meigs | Tennessee | 47121 | 1245 | 20 |
1043108 | 1043108 | 2021-02-18 | Monroe | Tennessee | 47123 | 5190 | 88 |
1043109 | 1043109 | 2021-02-18 | Montgomery | Tennessee | 47125 | 17025 | 203 |
1043110 | 1043110 | 2021-02-18 | Moore | Tennessee | 47127 | 929 | 15 |
1043111 | 1043111 | 2021-02-18 | Morgan | Tennessee | 47129 | 2271 | 34 |
1043112 | 1043112 | 2021-02-18 | Obion | Tennessee | 47131 | 4343 | 92 |
1043113 | 1043113 | 2021-02-18 | Overton | Tennessee | 47133 | 2813 | 57 |
1043114 | 1043114 | 2021-02-18 | Perry | Tennessee | 47135 | 1022 | 27 |
1043115 | 1043115 | 2021-02-18 | Pickett | Tennessee | 47137 | 743 | 23 |
1043116 | 1043116 | 2021-02-18 | Polk | Tennessee | 47139 | 1703 | 21 |
1043117 | 1043117 | 2021-02-18 | Putnam | Tennessee | 47141 | 10475 | 166 |
1043118 | 1043118 | 2021-02-18 | Rhea | Tennessee | 47143 | 4082 | 70 |
1043119 | 1043119 | 2021-02-18 | Roane | Tennessee | 47145 | 5718 | 95 |
1043120 | 1043120 | 2021-02-18 | Robertson | Tennessee | 47147 | 8789 | 112 |
1043121 | 1043121 | 2021-02-18 | Rutherford | Tennessee | 47149 | 37417 | 366 |
1043122 | 1043122 | 2021-02-18 | Scott | Tennessee | 47151 | 2832 | 42 |
1043123 | 1043123 | 2021-02-18 | Sequatchie | Tennessee | 47153 | 1518 | 27 |
1043124 | 1043124 | 2021-02-18 | Sevier | Tennessee | 47155 | 11751 | 158 |
1043125 | 1043125 | 2021-02-18 | Shelby | Tennessee | 47157 | 86686 | 1452 |
1043126 | 1043126 | 2021-02-18 | Smith | Tennessee | 47159 | 2511 | 36 |
1043127 | 1043127 | 2021-02-18 | Stewart | Tennessee | 47161 | 1226 | 24 |
1043128 | 1043128 | 2021-02-18 | Sullivan | Tennessee | 47163 | 13983 | 268 |
1043129 | 1043129 | 2021-02-18 | Sumner | Tennessee | 47165 | 20964 | 308 |
1043130 | 1043130 | 2021-02-18 | Tipton | Tennessee | 47167 | 6841 | 97 |
1043131 | 1043131 | 2021-02-18 | Trousdale | Tennessee | 47169 | 2373 | 21 |
1043132 | 1043132 | 2021-02-18 | Unicoi | Tennessee | 47171 | 1769 | 47 |
1043133 | 1043133 | 2021-02-18 | Union | Tennessee | 47173 | 1656 | 30 |
1043134 | 1043134 | 2021-02-18 | Unknown | Tennessee | 8404 | 113 | |
1043135 | 1043135 | 2021-02-18 | Van Buren | Tennessee | 47175 | 786 | 20 |
1043136 | 1043136 | 2021-02-18 | Warren | Tennessee | 47177 | 5281 | 73 |
1043137 | 1043137 | 2021-02-18 | Washington | Tennessee | 47179 | 12586 | 227 |
1043138 | 1043138 | 2021-02-18 | Wayne | Tennessee | 47181 | 2852 | 30 |
1043139 | 1043139 | 2021-02-18 | Weakley | Tennessee | 47183 | 3765 | 59 |
1043140 | 1043140 | 2021-02-18 | White | Tennessee | 47185 | 3304 | 64 |
1043141 | 1043141 | 2021-02-18 | Williamson | Tennessee | 47187 | 24656 | 200 |
1043142 | 1043142 | 2021-02-18 | Wilson | Tennessee | 47189 | 15991 | 206 |
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);