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-11-04 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
699049 | 699049 | 2020-11-04 | Anderson | Tennessee | 47001 | 1938 | 18 |
699050 | 699050 | 2020-11-04 | Bedford | Tennessee | 47003 | 1914 | 23 |
699051 | 699051 | 2020-11-04 | Benton | Tennessee | 47005 | 474 | 10 |
699052 | 699052 | 2020-11-04 | Bledsoe | Tennessee | 47007 | 1057 | 4 |
699053 | 699053 | 2020-11-04 | Blount | Tennessee | 47009 | 3726 | 43 |
699054 | 699054 | 2020-11-04 | Bradley | Tennessee | 47011 | 3850 | 24 |
699055 | 699055 | 2020-11-04 | Campbell | Tennessee | 47013 | 1159 | 14 |
699056 | 699056 | 2020-11-04 | Cannon | Tennessee | 47015 | 464 | 2 |
699057 | 699057 | 2020-11-04 | Carroll | Tennessee | 47017 | 1233 | 28 |
699058 | 699058 | 2020-11-04 | Carter | Tennessee | 47019 | 1833 | 37 |
699059 | 699059 | 2020-11-04 | Cheatham | Tennessee | 47021 | 1157 | 12 |
699060 | 699060 | 2020-11-04 | Chester | Tennessee | 47023 | 771 | 17 |
699061 | 699061 | 2020-11-04 | Claiborne | Tennessee | 47025 | 558 | 8 |
699062 | 699062 | 2020-11-04 | Clay | Tennessee | 47027 | 432 | 16 |
699063 | 699063 | 2020-11-04 | Cocke | Tennessee | 47029 | 1232 | 20 |
699064 | 699064 | 2020-11-04 | Coffee | Tennessee | 47031 | 2131 | 31 |
699065 | 699065 | 2020-11-04 | Crockett | Tennessee | 47033 | 971 | 24 |
699066 | 699066 | 2020-11-04 | Cumberland | Tennessee | 47035 | 1764 | 29 |
699067 | 699067 | 2020-11-04 | Davidson | Tennessee | 47037 | 35699 | 357 |
699068 | 699068 | 2020-11-04 | DeKalb | Tennessee | 47041 | 816 | 18 |
699069 | 699069 | 2020-11-04 | Decatur | Tennessee | 47039 | 703 | 11 |
699070 | 699070 | 2020-11-04 | Dickson | Tennessee | 47043 | 1904 | 21 |
699071 | 699071 | 2020-11-04 | Dyer | Tennessee | 47045 | 2480 | 38 |
699072 | 699072 | 2020-11-04 | Fayette | Tennessee | 47047 | 1814 | 29 |
699073 | 699073 | 2020-11-04 | Fentress | Tennessee | 47049 | 982 | 13 |
699074 | 699074 | 2020-11-04 | Franklin | Tennessee | 47051 | 1417 | 26 |
699075 | 699075 | 2020-11-04 | Gibson | Tennessee | 47053 | 2316 | 50 |
699076 | 699076 | 2020-11-04 | Giles | Tennessee | 47055 | 1076 | 38 |
699077 | 699077 | 2020-11-04 | Grainger | Tennessee | 47057 | 722 | 4 |
699078 | 699078 | 2020-11-04 | Greene | Tennessee | 47059 | 2112 | 57 |
699079 | 699079 | 2020-11-04 | Grundy | Tennessee | 47061 | 628 | 14 |
699080 | 699080 | 2020-11-04 | Hamblen | Tennessee | 47063 | 2635 | 51 |
699081 | 699081 | 2020-11-04 | Hamilton | Tennessee | 47065 | 13048 | 113 |
699082 | 699082 | 2020-11-04 | Hancock | Tennessee | 47067 | 126 | 3 |
699083 | 699083 | 2020-11-04 | Hardeman | Tennessee | 47069 | 2004 | 34 |
699084 | 699084 | 2020-11-04 | Hardin | Tennessee | 47071 | 1478 | 23 |
699085 | 699085 | 2020-11-04 | Hawkins | Tennessee | 47073 | 1354 | 30 |
699086 | 699086 | 2020-11-04 | Haywood | Tennessee | 47075 | 1371 | 28 |
699087 | 699087 | 2020-11-04 | Henderson | Tennessee | 47077 | 1477 | 28 |
699088 | 699088 | 2020-11-04 | Henry | Tennessee | 47079 | 926 | 13 |
699089 | 699089 | 2020-11-04 | Hickman | Tennessee | 47081 | 865 | 16 |
699090 | 699090 | 2020-11-04 | Houston | Tennessee | 47083 | 462 | 18 |
699091 | 699091 | 2020-11-04 | Humphreys | Tennessee | 47085 | 494 | 6 |
699092 | 699092 | 2020-11-04 | Jackson | Tennessee | 47087 | 501 | 7 |
699093 | 699093 | 2020-11-04 | Jefferson | Tennessee | 47089 | 1669 | 25 |
699094 | 699094 | 2020-11-04 | Johnson | Tennessee | 47091 | 1245 | 10 |
699095 | 699095 | 2020-11-04 | Knox | Tennessee | 47093 | 14246 | 109 |
699096 | 699096 | 2020-11-04 | Lake | Tennessee | 47095 | 1010 | 4 |
699097 | 699097 | 2020-11-04 | Lauderdale | Tennessee | 47097 | 1553 | 18 |
699098 | 699098 | 2020-11-04 | Lawrence | Tennessee | 47099 | 1854 | 24 |
699099 | 699099 | 2020-11-04 | Lewis | Tennessee | 47101 | 535 | 7 |
699100 | 699100 | 2020-11-04 | Lincoln | Tennessee | 47103 | 1043 | 6 |
699101 | 699101 | 2020-11-04 | Loudon | Tennessee | 47105 | 1755 | 13 |
699102 | 699102 | 2020-11-04 | Macon | Tennessee | 47111 | 1428 | 26 |
699103 | 699103 | 2020-11-04 | Madison | Tennessee | 47113 | 4072 | 85 |
699104 | 699104 | 2020-11-04 | Marion | Tennessee | 47115 | 867 | 14 |
699105 | 699105 | 2020-11-04 | Marshall | Tennessee | 47117 | 1271 | 12 |
699106 | 699106 | 2020-11-04 | Maury | Tennessee | 47119 | 3886 | 39 |
699107 | 699107 | 2020-11-04 | McMinn | Tennessee | 47107 | 1802 | 41 |
699108 | 699108 | 2020-11-04 | McNairy | Tennessee | 47109 | 1190 | 30 |
699109 | 699109 | 2020-11-04 | Meigs | Tennessee | 47121 | 354 | 8 |
699110 | 699110 | 2020-11-04 | Monroe | Tennessee | 47123 | 1590 | 32 |
699111 | 699111 | 2020-11-04 | Montgomery | Tennessee | 47125 | 4569 | 63 |
699112 | 699112 | 2020-11-04 | Moore | Tennessee | 47127 | 297 | 2 |
699113 | 699113 | 2020-11-04 | Morgan | Tennessee | 47129 | 470 | 6 |
699114 | 699114 | 2020-11-04 | Obion | Tennessee | 47131 | 1936 | 28 |
699115 | 699115 | 2020-11-04 | Overton | Tennessee | 47133 | 1305 | 26 |
699116 | 699116 | 2020-11-04 | Perry | Tennessee | 47135 | 372 | 11 |
699117 | 699117 | 2020-11-04 | Pickett | Tennessee | 47137 | 299 | 10 |
699118 | 699118 | 2020-11-04 | Polk | Tennessee | 47139 | 553 | 13 |
699119 | 699119 | 2020-11-04 | Putnam | Tennessee | 47141 | 4729 | 64 |
699120 | 699120 | 2020-11-04 | Rhea | Tennessee | 47143 | 1212 | 23 |
699121 | 699121 | 2020-11-04 | Roane | Tennessee | 47145 | 1552 | 9 |
699122 | 699122 | 2020-11-04 | Robertson | Tennessee | 47147 | 2758 | 43 |
699123 | 699123 | 2020-11-04 | Rutherford | Tennessee | 47149 | 13014 | 121 |
699124 | 699124 | 2020-11-04 | Scott | Tennessee | 47151 | 465 | 5 |
699125 | 699125 | 2020-11-04 | Sequatchie | Tennessee | 47153 | 391 | 5 |
699126 | 699126 | 2020-11-04 | Sevier | Tennessee | 47155 | 3637 | 24 |
699127 | 699127 | 2020-11-04 | Shelby | Tennessee | 47157 | 38623 | 580 |
699128 | 699128 | 2020-11-04 | Smith | Tennessee | 47159 | 1062 | 14 |
699129 | 699129 | 2020-11-04 | Stewart | Tennessee | 47161 | 375 | 13 |
699130 | 699130 | 2020-11-04 | Sullivan | Tennessee | 47163 | 4330 | 58 |
699131 | 699131 | 2020-11-04 | Sumner | Tennessee | 47165 | 6723 | 120 |
699132 | 699132 | 2020-11-04 | Tipton | Tennessee | 47167 | 2596 | 24 |
699133 | 699133 | 2020-11-04 | Trousdale | Tennessee | 47169 | 1809 | 10 |
699134 | 699134 | 2020-11-04 | Unicoi | Tennessee | 47171 | 535 | 7 |
699135 | 699135 | 2020-11-04 | Union | Tennessee | 47173 | 571 | 4 |
699136 | 699136 | 2020-11-04 | Unknown | Tennessee | 132 | 0 | |
699137 | 699137 | 2020-11-04 | Van Buren | Tennessee | 47175 | 223 | 2 |
699138 | 699138 | 2020-11-04 | Warren | Tennessee | 47177 | 1599 | 11 |
699139 | 699139 | 2020-11-04 | Washington | Tennessee | 47179 | 4205 | 67 |
699140 | 699140 | 2020-11-04 | Wayne | Tennessee | 47181 | 1638 | 7 |
699141 | 699141 | 2020-11-04 | Weakley | Tennessee | 47183 | 1669 | 27 |
699142 | 699142 | 2020-11-04 | White | Tennessee | 47185 | 1328 | 15 |
699143 | 699143 | 2020-11-04 | Williamson | Tennessee | 47187 | 7820 | 60 |
699144 | 699144 | 2020-11-04 | Wilson | Tennessee | 47189 | 5166 | 65 |
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);