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-03-02 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081996 | 1081996 | 2021-03-02 | Anderson | Tennessee | 47001 | 7991 | 157 |
1081997 | 1081997 | 2021-03-02 | Bedford | Tennessee | 47003 | 5797 | 120 |
1081998 | 1081998 | 2021-03-02 | Benton | Tennessee | 47005 | 1510 | 39 |
1081999 | 1081999 | 2021-03-02 | Bledsoe | Tennessee | 47007 | 2002 | 10 |
1082000 | 1082000 | 2021-03-02 | Blount | Tennessee | 47009 | 14066 | 181 |
1082001 | 1082001 | 2021-03-02 | Bradley | Tennessee | 47011 | 12918 | 139 |
1082002 | 1082002 | 2021-03-02 | Campbell | Tennessee | 47013 | 3804 | 59 |
1082003 | 1082003 | 2021-03-02 | Cannon | Tennessee | 47015 | 1750 | 29 |
1082004 | 1082004 | 2021-03-02 | Carroll | Tennessee | 47017 | 3489 | 81 |
1082005 | 1082005 | 2021-03-02 | Carter | Tennessee | 47019 | 5974 | 152 |
1082006 | 1082006 | 2021-03-02 | Cheatham | Tennessee | 47021 | 3912 | 44 |
1082007 | 1082007 | 2021-03-02 | Chester | Tennessee | 47023 | 2017 | 48 |
1082008 | 1082008 | 2021-03-02 | Claiborne | Tennessee | 47025 | 2797 | 68 |
1082009 | 1082009 | 2021-03-02 | Clay | Tennessee | 47027 | 1071 | 30 |
1082010 | 1082010 | 2021-03-02 | Cocke | Tennessee | 47029 | 3990 | 93 |
1082011 | 1082011 | 2021-03-02 | Coffee | Tennessee | 47031 | 6320 | 115 |
1082012 | 1082012 | 2021-03-02 | Crockett | Tennessee | 47033 | 1972 | 47 |
1082013 | 1082013 | 2021-03-02 | Cumberland | Tennessee | 47035 | 6106 | 121 |
1082014 | 1082014 | 2021-03-02 | Davidson | Tennessee | 47037 | 90089 | 869 |
1082015 | 1082015 | 2021-03-02 | DeKalb | Tennessee | 47041 | 2655 | 49 |
1082016 | 1082016 | 2021-03-02 | Decatur | Tennessee | 47039 | 1539 | 37 |
1082017 | 1082017 | 2021-03-02 | Dickson | Tennessee | 47043 | 6228 | 106 |
1082018 | 1082018 | 2021-03-02 | Dyer | Tennessee | 47045 | 5237 | 101 |
1082019 | 1082019 | 2021-03-02 | Fayette | Tennessee | 47047 | 4669 | 71 |
1082020 | 1082020 | 2021-03-02 | Fentress | Tennessee | 47049 | 2293 | 44 |
1082021 | 1082021 | 2021-03-02 | Franklin | Tennessee | 47051 | 4736 | 85 |
1082022 | 1082022 | 2021-03-02 | Gibson | Tennessee | 47053 | 6188 | 141 |
1082023 | 1082023 | 2021-03-02 | Giles | Tennessee | 47055 | 3738 | 96 |
1082024 | 1082024 | 2021-03-02 | Grainger | Tennessee | 47057 | 2431 | 46 |
1082025 | 1082025 | 2021-03-02 | Greene | Tennessee | 47059 | 7294 | 145 |
1082026 | 1082026 | 2021-03-02 | Grundy | Tennessee | 47061 | 1686 | 30 |
1082027 | 1082027 | 2021-03-02 | Hamblen | Tennessee | 47063 | 8023 | 164 |
1082028 | 1082028 | 2021-03-02 | Hamilton | Tennessee | 47065 | 40707 | 465 |
1082029 | 1082029 | 2021-03-02 | Hancock | Tennessee | 47067 | 495 | 12 |
1082030 | 1082030 | 2021-03-02 | Hardeman | Tennessee | 47069 | 3385 | 64 |
1082031 | 1082031 | 2021-03-02 | Hardin | Tennessee | 47071 | 3310 | 63 |
1082032 | 1082032 | 2021-03-02 | Hawkins | Tennessee | 47073 | 5251 | 94 |
1082033 | 1082033 | 2021-03-02 | Haywood | Tennessee | 47075 | 2648 | 60 |
1082034 | 1082034 | 2021-03-02 | Henderson | Tennessee | 47077 | 3619 | 73 |
1082035 | 1082035 | 2021-03-02 | Henry | Tennessee | 47079 | 3009 | 75 |
1082036 | 1082036 | 2021-03-02 | Hickman | Tennessee | 47081 | 2651 | 41 |
1082037 | 1082037 | 2021-03-02 | Houston | Tennessee | 47083 | 1029 | 32 |
1082038 | 1082038 | 2021-03-02 | Humphreys | Tennessee | 47085 | 1537 | 21 |
1082039 | 1082039 | 2021-03-02 | Jackson | Tennessee | 47087 | 1252 | 34 |
1082040 | 1082040 | 2021-03-02 | Jefferson | Tennessee | 47089 | 5659 | 119 |
1082041 | 1082041 | 2021-03-02 | Johnson | Tennessee | 47091 | 2163 | 38 |
1082042 | 1082042 | 2021-03-02 | Knox | Tennessee | 47093 | 47035 | 581 |
1082043 | 1082043 | 2021-03-02 | Lake | Tennessee | 47095 | 1678 | 26 |
1082044 | 1082044 | 2021-03-02 | Lauderdale | Tennessee | 47097 | 3092 | 42 |
1082045 | 1082045 | 2021-03-02 | Lawrence | Tennessee | 47099 | 5568 | 83 |
1082046 | 1082046 | 2021-03-02 | Lewis | Tennessee | 47101 | 1470 | 25 |
1082047 | 1082047 | 2021-03-02 | Lincoln | Tennessee | 47103 | 4140 | 62 |
1082048 | 1082048 | 2021-03-02 | Loudon | Tennessee | 47105 | 5696 | 65 |
1082049 | 1082049 | 2021-03-02 | Macon | Tennessee | 47111 | 3365 | 73 |
1082050 | 1082050 | 2021-03-02 | Madison | Tennessee | 47113 | 10102 | 228 |
1082051 | 1082051 | 2021-03-02 | Marion | Tennessee | 47115 | 2941 | 44 |
1082052 | 1082052 | 2021-03-02 | Marshall | Tennessee | 47117 | 3911 | 56 |
1082053 | 1082053 | 2021-03-02 | Maury | Tennessee | 47119 | 12220 | 163 |
1082054 | 1082054 | 2021-03-02 | McMinn | Tennessee | 47107 | 5931 | 91 |
1082055 | 1082055 | 2021-03-02 | McNairy | Tennessee | 47109 | 2678 | 53 |
1082056 | 1082056 | 2021-03-02 | Meigs | Tennessee | 47121 | 1266 | 21 |
1082057 | 1082057 | 2021-03-02 | Monroe | Tennessee | 47123 | 5331 | 90 |
1082058 | 1082058 | 2021-03-02 | Montgomery | Tennessee | 47125 | 17414 | 213 |
1082059 | 1082059 | 2021-03-02 | Moore | Tennessee | 47127 | 944 | 16 |
1082060 | 1082060 | 2021-03-02 | Morgan | Tennessee | 47129 | 2297 | 38 |
1082061 | 1082061 | 2021-03-02 | Obion | Tennessee | 47131 | 4365 | 95 |
1082062 | 1082062 | 2021-03-02 | Overton | Tennessee | 47133 | 2848 | 57 |
1082063 | 1082063 | 2021-03-02 | Perry | Tennessee | 47135 | 1033 | 27 |
1082064 | 1082064 | 2021-03-02 | Pickett | Tennessee | 47137 | 746 | 23 |
1082065 | 1082065 | 2021-03-02 | Polk | Tennessee | 47139 | 1765 | 22 |
1082066 | 1082066 | 2021-03-02 | Putnam | Tennessee | 47141 | 10603 | 169 |
1082067 | 1082067 | 2021-03-02 | Rhea | Tennessee | 47143 | 4151 | 73 |
1082068 | 1082068 | 2021-03-02 | Roane | Tennessee | 47145 | 5907 | 96 |
1082069 | 1082069 | 2021-03-02 | Robertson | Tennessee | 47147 | 8962 | 121 |
1082070 | 1082070 | 2021-03-02 | Rutherford | Tennessee | 47149 | 38385 | 382 |
1082071 | 1082071 | 2021-03-02 | Scott | Tennessee | 47151 | 2876 | 44 |
1082072 | 1082072 | 2021-03-02 | Sequatchie | Tennessee | 47153 | 1560 | 27 |
1082073 | 1082073 | 2021-03-02 | Sevier | Tennessee | 47155 | 12038 | 163 |
1082074 | 1082074 | 2021-03-02 | Shelby | Tennessee | 47157 | 88214 | 1500 |
1082075 | 1082075 | 2021-03-02 | Smith | Tennessee | 47159 | 2560 | 36 |
1082076 | 1082076 | 2021-03-02 | Stewart | Tennessee | 47161 | 1236 | 24 |
1082077 | 1082077 | 2021-03-02 | Sullivan | Tennessee | 47163 | 14346 | 274 |
1082078 | 1082078 | 2021-03-02 | Sumner | Tennessee | 47165 | 21383 | 315 |
1082079 | 1082079 | 2021-03-02 | Tipton | Tennessee | 47167 | 6948 | 103 |
1082080 | 1082080 | 2021-03-02 | Trousdale | Tennessee | 47169 | 2390 | 22 |
1082081 | 1082081 | 2021-03-02 | Unicoi | Tennessee | 47171 | 1805 | 47 |
1082082 | 1082082 | 2021-03-02 | Union | Tennessee | 47173 | 1722 | 33 |
1082083 | 1082083 | 2021-03-02 | Unknown | Tennessee | 8405 | 114 | |
1082084 | 1082084 | 2021-03-02 | Van Buren | Tennessee | 47175 | 795 | 20 |
1082085 | 1082085 | 2021-03-02 | Warren | Tennessee | 47177 | 5314 | 75 |
1082086 | 1082086 | 2021-03-02 | Washington | Tennessee | 47179 | 12774 | 234 |
1082087 | 1082087 | 2021-03-02 | Wayne | Tennessee | 47181 | 2871 | 30 |
1082088 | 1082088 | 2021-03-02 | Weakley | Tennessee | 47183 | 3789 | 59 |
1082089 | 1082089 | 2021-03-02 | White | Tennessee | 47185 | 3382 | 66 |
1082090 | 1082090 | 2021-03-02 | Williamson | Tennessee | 47187 | 25282 | 203 |
1082091 | 1082091 | 2021-03-02 | Wilson | Tennessee | 47189 | 16423 | 210 |
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);