ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74,719 rows where state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 47187 799
- 47037 796
- 47157 796
- 47163 794
- 47093 792
- 47065 791
- 47089 791
- 47149 791
- 47013 790
- 47155 788
- 47021 786
- 47147 786
- 47165 786
- 47035 785
- 47045 785
- 47125 785
- 47179 785
- 47189 785
- 47009 784
- 47011 784
- 47043 784
- 47059 784
- 47063 784
- 47119 784
- 47167 784
- 47001 783
- 47017 783
- 47029 783
- 47047 783
- 47123 783
- …
county >30
- Williamson 799
- Davidson 796
- Shelby 796
- Sullivan 794
- Knox 792
- Hamilton 791
- Jefferson 791
- Rutherford 791
- Campbell 790
- Sevier 788
- Cheatham 786
- Robertson 786
- Sumner 786
- Cumberland 785
- Dyer 785
- Montgomery 785
- Washington 785
- Wilson 785
- Blount 784
- Bradley 784
- Dickson 784
- Greene 784
- Hamblen 784
- Maury 784
- Tipton 784
- Anderson 783
- Carroll 783
- Cocke 783
- Fayette 783
- Monroe 783
- …
state 1
- Tennessee · 74,619 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498857 | 2498857 | 2022-05-12 | Blount | Tennessee | 47009 | 39310 | 440 |
2498858 | 2498858 | 2022-05-12 | Bradley | Tennessee | 47011 | 33188 | 415 |
2498859 | 2498859 | 2022-05-12 | Campbell | Tennessee | 47013 | 12310 | 169 |
2498860 | 2498860 | 2022-05-12 | Cannon | Tennessee | 47015 | 4227 | 63 |
2498861 | 2498861 | 2022-05-12 | Carroll | Tennessee | 47017 | 8978 | 156 |
2498862 | 2498862 | 2022-05-12 | Carter | Tennessee | 47019 | 16546 | 336 |
2498863 | 2498863 | 2022-05-12 | Cheatham | Tennessee | 47021 | 10967 | 119 |
2498864 | 2498864 | 2022-05-12 | Chester | Tennessee | 47023 | 5870 | 99 |
2498865 | 2498865 | 2022-05-12 | Claiborne | Tennessee | 47025 | 9141 | 178 |
2498866 | 2498866 | 2022-05-12 | Clay | Tennessee | 47027 | 2300 | 50 |
2498867 | 2498867 | 2022-05-12 | Cocke | Tennessee | 47029 | 11634 | 217 |
2498868 | 2498868 | 2022-05-12 | Coffee | Tennessee | 47031 | 16994 | 267 |
2498869 | 2498869 | 2022-05-12 | Crockett | Tennessee | 47033 | 5199 | 85 |
2498870 | 2498870 | 2022-05-12 | Cumberland | Tennessee | 47035 | 16171 | 327 |
2498871 | 2498871 | 2022-05-12 | Davidson | Tennessee | 47037 | 210463 | 1676 |
2498872 | 2498872 | 2022-05-12 | DeKalb | Tennessee | 47041 | 6288 | 101 |
2498873 | 2498873 | 2022-05-12 | Decatur | Tennessee | 47039 | 3738 | 70 |
2498874 | 2498874 | 2022-05-12 | Dickson | Tennessee | 47043 | 15987 | 245 |
2498875 | 2498875 | 2022-05-12 | Dyer | Tennessee | 47045 | 12826 | 203 |
2498876 | 2498876 | 2022-05-12 | Fayette | Tennessee | 47047 | 11475 | 186 |
2498877 | 2498877 | 2022-05-12 | Fentress | Tennessee | 47049 | 5722 | 128 |
2498878 | 2498878 | 2022-05-12 | Franklin | Tennessee | 47051 | 12908 | 184 |
2498879 | 2498879 | 2022-05-12 | Gibson | Tennessee | 47053 | 17453 | 260 |
2498880 | 2498880 | 2022-05-12 | Giles | Tennessee | 47055 | 9448 | 190 |
2498881 | 2498881 | 2022-05-12 | Grainger | Tennessee | 47057 | 6793 | 109 |
2498882 | 2498882 | 2022-05-12 | Greene | Tennessee | 47059 | 22140 | 374 |
2498883 | 2498883 | 2022-05-12 | Grundy | Tennessee | 47061 | 3998 | 73 |
2498884 | 2498884 | 2022-05-12 | Hamblen | Tennessee | 47063 | 19740 | 353 |
2498885 | 2498885 | 2022-05-12 | Hamilton | Tennessee | 47065 | 101038 | 1151 |
2498886 | 2498886 | 2022-05-12 | Hancock | Tennessee | 47067 | 2023 | 37 |
2498887 | 2498887 | 2022-05-12 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2498888 | 2498888 | 2022-05-12 | Hardin | Tennessee | 47071 | 8765 | 145 |
2498889 | 2498889 | 2022-05-12 | Hawkins | Tennessee | 47073 | 16702 | 321 |
2498890 | 2498890 | 2022-05-12 | Haywood | Tennessee | 47075 | 6191 | 102 |
2498891 | 2498891 | 2022-05-12 | Henderson | Tennessee | 47077 | 9150 | 160 |
2498892 | 2498892 | 2022-05-12 | Henry | Tennessee | 47079 | 8310 | 163 |
2498893 | 2498893 | 2022-05-12 | Hickman | Tennessee | 47081 | 6850 | 110 |
2498894 | 2498894 | 2022-05-12 | Houston | Tennessee | 47083 | 2689 | 62 |
2498895 | 2498895 | 2022-05-12 | Humphreys | Tennessee | 47085 | 4855 | 74 |
2498896 | 2498896 | 2022-05-12 | Jackson | Tennessee | 47087 | 3211 | 63 |
2498897 | 2498897 | 2022-05-12 | Jefferson | Tennessee | 47089 | 15804 | 265 |
2498898 | 2498898 | 2022-05-12 | Johnson | Tennessee | 47091 | 5181 | 95 |
2498899 | 2498899 | 2022-05-12 | Knox | Tennessee | 47093 | 128707 | 1385 |
2498900 | 2498900 | 2022-05-12 | Lake | Tennessee | 47095 | 2749 | 43 |
2498901 | 2498901 | 2022-05-12 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2498902 | 2498902 | 2022-05-12 | Lawrence | Tennessee | 47099 | 14329 | 203 |
2498903 | 2498903 | 2022-05-12 | Lewis | Tennessee | 47101 | 3573 | 60 |
2498904 | 2498904 | 2022-05-12 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2498905 | 2498905 | 2022-05-12 | Loudon | Tennessee | 47105 | 14571 | 192 |
2498906 | 2498906 | 2022-05-12 | Macon | Tennessee | 47111 | 8478 | 145 |
2498907 | 2498907 | 2022-05-12 | Madison | Tennessee | 47113 | 30250 | 427 |
2498908 | 2498908 | 2022-05-12 | Marion | Tennessee | 47115 | 8870 | 132 |
2498909 | 2498909 | 2022-05-12 | Marshall | Tennessee | 47117 | 10403 | 124 |
2498910 | 2498910 | 2022-05-12 | Maury | Tennessee | 47119 | 29162 | 345 |
2498911 | 2498911 | 2022-05-12 | McMinn | Tennessee | 47107 | 16701 | 260 |
2498912 | 2498912 | 2022-05-12 | McNairy | Tennessee | 47109 | 7662 | 120 |
2498913 | 2498913 | 2022-05-12 | Meigs | Tennessee | 47121 | 3394 | 58 |
2498914 | 2498914 | 2022-05-12 | Monroe | Tennessee | 47123 | 14681 | 244 |
2498915 | 2498915 | 2022-05-12 | Montgomery | Tennessee | 47125 | 50488 | 579 |
2498916 | 2498916 | 2022-05-12 | Moore | Tennessee | 47127 | 2239 | 40 |
2498917 | 2498917 | 2022-05-12 | Morgan | Tennessee | 47129 | 6209 | 87 |
2498918 | 2498918 | 2022-05-12 | Obion | Tennessee | 47131 | 10786 | 195 |
2498919 | 2498919 | 2022-05-12 | Overton | Tennessee | 47133 | 7157 | 123 |
2498920 | 2498920 | 2022-05-12 | Perry | Tennessee | 47135 | 2332 | 56 |
2498921 | 2498921 | 2022-05-12 | Pickett | Tennessee | 47137 | 1774 | 36 |
2498922 | 2498922 | 2022-05-12 | Polk | Tennessee | 47139 | 4740 | 74 |
2498923 | 2498923 | 2022-05-12 | Putnam | Tennessee | 47141 | 25178 | 304 |
2498924 | 2498924 | 2022-05-12 | Rhea | Tennessee | 47143 | 9994 | 160 |
2498925 | 2498925 | 2022-05-12 | Roane | Tennessee | 47145 | 15839 | 234 |
2498926 | 2498926 | 2022-05-12 | Robertson | Tennessee | 47147 | 21626 | 305 |
2498927 | 2498927 | 2022-05-12 | Rutherford | Tennessee | 47149 | 96372 | 904 |
2498928 | 2498928 | 2022-05-12 | Scott | Tennessee | 47151 | 9097 | 117 |
2498929 | 2498929 | 2022-05-12 | Sequatchie | Tennessee | 47153 | 4226 | 69 |
2498930 | 2498930 | 2022-05-12 | Sevier | Tennessee | 47155 | 30457 | 415 |
2498931 | 2498931 | 2022-05-12 | Shelby | Tennessee | 47157 | 240480 | 3307 |
2498932 | 2498932 | 2022-05-12 | Smith | Tennessee | 47159 | 6171 | 85 |
2498933 | 2498933 | 2022-05-12 | Stewart | Tennessee | 47161 | 3294 | 59 |
2498934 | 2498934 | 2022-05-12 | Sullivan | Tennessee | 47163 | 46163 | 721 |
2498935 | 2498935 | 2022-05-12 | Sumner | Tennessee | 47165 | 53504 | 729 |
2498936 | 2498936 | 2022-05-12 | Tipton | Tennessee | 47167 | 17674 | 236 |
2498937 | 2498937 | 2022-05-12 | Trousdale | Tennessee | 47169 | 4238 | 45 |
2498938 | 2498938 | 2022-05-12 | Unicoi | Tennessee | 47171 | 5191 | 96 |
2498939 | 2498939 | 2022-05-12 | Union | Tennessee | 47173 | 5409 | 75 |
2498940 | 2498940 | 2022-05-12 | Unknown | Tennessee | 19183 | 301 | |
2498941 | 2498941 | 2022-05-12 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2498942 | 2498942 | 2022-05-12 | Warren | Tennessee | 47177 | 13028 | 177 |
2498943 | 2498943 | 2022-05-12 | Washington | Tennessee | 47179 | 38862 | 496 |
2498944 | 2498944 | 2022-05-12 | Wayne | Tennessee | 47181 | 5700 | 72 |
2498945 | 2498945 | 2022-05-12 | Weakley | Tennessee | 47183 | 9586 | 152 |
2498946 | 2498946 | 2022-05-12 | White | Tennessee | 47185 | 8249 | 129 |
2498947 | 2498947 | 2022-05-12 | Williamson | Tennessee | 47187 | 62833 | 406 |
2498948 | 2498948 | 2022-05-12 | Wilson | Tennessee | 47189 | 41970 | 484 |
2495595 | 2495595 | 2022-05-11 | Anderson | Tennessee | 47001 | 22228 | 334 |
2495596 | 2495596 | 2022-05-11 | Bedford | Tennessee | 47003 | 15004 | 237 |
2495597 | 2495597 | 2022-05-11 | Benton | Tennessee | 47005 | 4533 | 93 |
2495598 | 2495598 | 2022-05-11 | Bledsoe | Tennessee | 47007 | 4669 | 57 |
2495599 | 2495599 | 2022-05-11 | Blount | Tennessee | 47009 | 39310 | 440 |
2495600 | 2495600 | 2022-05-11 | Bradley | Tennessee | 47011 | 33188 | 415 |
2495601 | 2495601 | 2022-05-11 | Campbell | Tennessee | 47013 | 12310 | 169 |
2495602 | 2495602 | 2022-05-11 | Cannon | Tennessee | 47015 | 4227 | 63 |
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);