ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where date = "2020-10-26" 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 |
---|---|---|---|---|---|---|---|
669861 | 669861 | 2020-10-26 | Anderson | Tennessee | 47001 | 1697 | 13 |
669862 | 669862 | 2020-10-26 | Bedford | Tennessee | 47003 | 1745 | 20 |
669863 | 669863 | 2020-10-26 | Benton | Tennessee | 47005 | 421 | 9 |
669864 | 669864 | 2020-10-26 | Bledsoe | Tennessee | 47007 | 1026 | 4 |
669865 | 669865 | 2020-10-26 | Blount | Tennessee | 47009 | 3374 | 36 |
669866 | 669866 | 2020-10-26 | Bradley | Tennessee | 47011 | 3619 | 23 |
669867 | 669867 | 2020-10-26 | Campbell | Tennessee | 47013 | 1035 | 12 |
669868 | 669868 | 2020-10-26 | Cannon | Tennessee | 47015 | 421 | 2 |
669869 | 669869 | 2020-10-26 | Carroll | Tennessee | 47017 | 1153 | 26 |
669870 | 669870 | 2020-10-26 | Carter | Tennessee | 47019 | 1583 | 34 |
669871 | 669871 | 2020-10-26 | Cheatham | Tennessee | 47021 | 1069 | 11 |
669872 | 669872 | 2020-10-26 | Chester | Tennessee | 47023 | 733 | 14 |
669873 | 669873 | 2020-10-26 | Claiborne | Tennessee | 47025 | 528 | 6 |
669874 | 669874 | 2020-10-26 | Clay | Tennessee | 47027 | 406 | 15 |
669875 | 669875 | 2020-10-26 | Cocke | Tennessee | 47029 | 1080 | 14 |
669876 | 669876 | 2020-10-26 | Coffee | Tennessee | 47031 | 1923 | 25 |
669877 | 669877 | 2020-10-26 | Crockett | Tennessee | 47033 | 870 | 20 |
669878 | 669878 | 2020-10-26 | Cumberland | Tennessee | 47035 | 1613 | 27 |
669879 | 669879 | 2020-10-26 | Davidson | Tennessee | 47037 | 33699 | 343 |
669880 | 669880 | 2020-10-26 | DeKalb | Tennessee | 47041 | 737 | 17 |
669881 | 669881 | 2020-10-26 | Decatur | Tennessee | 47039 | 663 | 11 |
669882 | 669882 | 2020-10-26 | Dickson | Tennessee | 47043 | 1707 | 19 |
669883 | 669883 | 2020-10-26 | Dyer | Tennessee | 47045 | 2247 | 32 |
669884 | 669884 | 2020-10-26 | Fayette | Tennessee | 47047 | 1698 | 25 |
669885 | 669885 | 2020-10-26 | Fentress | Tennessee | 47049 | 918 | 11 |
669886 | 669886 | 2020-10-26 | Franklin | Tennessee | 47051 | 1302 | 20 |
669887 | 669887 | 2020-10-26 | Gibson | Tennessee | 47053 | 2172 | 44 |
669888 | 669888 | 2020-10-26 | Giles | Tennessee | 47055 | 983 | 36 |
669889 | 669889 | 2020-10-26 | Grainger | Tennessee | 47057 | 612 | 4 |
669890 | 669890 | 2020-10-26 | Greene | Tennessee | 47059 | 1812 | 52 |
669891 | 669891 | 2020-10-26 | Grundy | Tennessee | 47061 | 575 | 11 |
669892 | 669892 | 2020-10-26 | Hamblen | Tennessee | 47063 | 2475 | 48 |
669893 | 669893 | 2020-10-26 | Hamilton | Tennessee | 47065 | 12069 | 109 |
669894 | 669894 | 2020-10-26 | Hancock | Tennessee | 47067 | 121 | 3 |
669895 | 669895 | 2020-10-26 | Hardeman | Tennessee | 47069 | 1905 | 33 |
669896 | 669896 | 2020-10-26 | Hardin | Tennessee | 47071 | 1404 | 20 |
669897 | 669897 | 2020-10-26 | Hawkins | Tennessee | 47073 | 1226 | 25 |
669898 | 669898 | 2020-10-26 | Haywood | Tennessee | 47075 | 1297 | 28 |
669899 | 669899 | 2020-10-26 | Henderson | Tennessee | 47077 | 1421 | 26 |
669900 | 669900 | 2020-10-26 | Henry | Tennessee | 47079 | 802 | 11 |
669901 | 669901 | 2020-10-26 | Hickman | Tennessee | 47081 | 810 | 15 |
669902 | 669902 | 2020-10-26 | Houston | Tennessee | 47083 | 423 | 17 |
669903 | 669903 | 2020-10-26 | Humphreys | Tennessee | 47085 | 458 | 4 |
669904 | 669904 | 2020-10-26 | Jackson | Tennessee | 47087 | 453 | 5 |
669905 | 669905 | 2020-10-26 | Jefferson | Tennessee | 47089 | 1564 | 21 |
669906 | 669906 | 2020-10-26 | Johnson | Tennessee | 47091 | 1157 | 7 |
669907 | 669907 | 2020-10-26 | Knox | Tennessee | 47093 | 13228 | 101 |
669908 | 669908 | 2020-10-26 | Lake | Tennessee | 47095 | 987 | 3 |
669909 | 669909 | 2020-10-26 | Lauderdale | Tennessee | 47097 | 1441 | 17 |
669910 | 669910 | 2020-10-26 | Lawrence | Tennessee | 47099 | 1645 | 20 |
669911 | 669911 | 2020-10-26 | Lewis | Tennessee | 47101 | 418 | 5 |
669912 | 669912 | 2020-10-26 | Lincoln | Tennessee | 47103 | 917 | 3 |
669913 | 669913 | 2020-10-26 | Loudon | Tennessee | 47105 | 1643 | 11 |
669914 | 669914 | 2020-10-26 | Macon | Tennessee | 47111 | 1348 | 25 |
669915 | 669915 | 2020-10-26 | Madison | Tennessee | 47113 | 3814 | 79 |
669916 | 669916 | 2020-10-26 | Marion | Tennessee | 47115 | 783 | 9 |
669917 | 669917 | 2020-10-26 | Marshall | Tennessee | 47117 | 1157 | 10 |
669918 | 669918 | 2020-10-26 | Maury | Tennessee | 47119 | 3389 | 38 |
669919 | 669919 | 2020-10-26 | McMinn | Tennessee | 47107 | 1659 | 37 |
669920 | 669920 | 2020-10-26 | McNairy | Tennessee | 47109 | 1134 | 27 |
669921 | 669921 | 2020-10-26 | Meigs | Tennessee | 47121 | 329 | 6 |
669922 | 669922 | 2020-10-26 | Monroe | Tennessee | 47123 | 1472 | 28 |
669923 | 669923 | 2020-10-26 | Montgomery | Tennessee | 47125 | 4240 | 57 |
669924 | 669924 | 2020-10-26 | Moore | Tennessee | 47127 | 272 | 2 |
669925 | 669925 | 2020-10-26 | Morgan | Tennessee | 47129 | 443 | 7 |
669926 | 669926 | 2020-10-26 | Obion | Tennessee | 47131 | 1795 | 22 |
669927 | 669927 | 2020-10-26 | Overton | Tennessee | 47133 | 1229 | 17 |
669928 | 669928 | 2020-10-26 | Perry | Tennessee | 47135 | 308 | 2 |
669929 | 669929 | 2020-10-26 | Pickett | Tennessee | 47137 | 274 | 8 |
669930 | 669930 | 2020-10-26 | Polk | Tennessee | 47139 | 517 | 13 |
669931 | 669931 | 2020-10-26 | Putnam | Tennessee | 47141 | 4456 | 57 |
669932 | 669932 | 2020-10-26 | Rhea | Tennessee | 47143 | 1124 | 18 |
669933 | 669933 | 2020-10-26 | Roane | Tennessee | 47145 | 1321 | 7 |
669934 | 669934 | 2020-10-26 | Robertson | Tennessee | 47147 | 2628 | 42 |
669935 | 669935 | 2020-10-26 | Rutherford | Tennessee | 47149 | 12017 | 115 |
669936 | 669936 | 2020-10-26 | Scott | Tennessee | 47151 | 386 | 5 |
669937 | 669937 | 2020-10-26 | Sequatchie | Tennessee | 47153 | 347 | 2 |
669938 | 669938 | 2020-10-26 | Sevier | Tennessee | 47155 | 3364 | 23 |
669939 | 669939 | 2020-10-26 | Shelby | Tennessee | 47157 | 36685 | 565 |
669940 | 669940 | 2020-10-26 | Smith | Tennessee | 47159 | 994 | 13 |
669941 | 669941 | 2020-10-26 | Stewart | Tennessee | 47161 | 336 | 11 |
669942 | 669942 | 2020-10-26 | Sullivan | Tennessee | 47163 | 3819 | 46 |
669943 | 669943 | 2020-10-26 | Sumner | Tennessee | 47165 | 6184 | 112 |
669944 | 669944 | 2020-10-26 | Tipton | Tennessee | 47167 | 2381 | 23 |
669945 | 669945 | 2020-10-26 | Trousdale | Tennessee | 47169 | 1776 | 8 |
669946 | 669946 | 2020-10-26 | Unicoi | Tennessee | 47171 | 433 | 3 |
669947 | 669947 | 2020-10-26 | Union | Tennessee | 47173 | 546 | 3 |
669948 | 669948 | 2020-10-26 | Van Buren | Tennessee | 47175 | 208 | 1 |
669949 | 669949 | 2020-10-26 | Warren | Tennessee | 47177 | 1449 | 10 |
669950 | 669950 | 2020-10-26 | Washington | Tennessee | 47179 | 3569 | 51 |
669951 | 669951 | 2020-10-26 | Wayne | Tennessee | 47181 | 1604 | 7 |
669952 | 669952 | 2020-10-26 | Weakley | Tennessee | 47183 | 1573 | 26 |
669953 | 669953 | 2020-10-26 | White | Tennessee | 47185 | 1194 | 14 |
669954 | 669954 | 2020-10-26 | Williamson | Tennessee | 47187 | 7187 | 56 |
669955 | 669955 | 2020-10-26 | Wilson | Tennessee | 47189 | 4731 | 59 |
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);