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-10-22 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
656884 | 656884 | 2020-10-22 | Anderson | Tennessee | 47001 | 1611 | 14 |
656885 | 656885 | 2020-10-22 | Bedford | Tennessee | 47003 | 1617 | 20 |
656886 | 656886 | 2020-10-22 | Benton | Tennessee | 47005 | 397 | 9 |
656887 | 656887 | 2020-10-22 | Bledsoe | Tennessee | 47007 | 999 | 4 |
656888 | 656888 | 2020-10-22 | Blount | Tennessee | 47009 | 3191 | 32 |
656889 | 656889 | 2020-10-22 | Bradley | Tennessee | 47011 | 3479 | 23 |
656890 | 656890 | 2020-10-22 | Campbell | Tennessee | 47013 | 911 | 8 |
656891 | 656891 | 2020-10-22 | Cannon | Tennessee | 47015 | 396 | 2 |
656892 | 656892 | 2020-10-22 | Carroll | Tennessee | 47017 | 1105 | 25 |
656893 | 656893 | 2020-10-22 | Carter | Tennessee | 47019 | 1465 | 32 |
656894 | 656894 | 2020-10-22 | Cheatham | Tennessee | 47021 | 1000 | 11 |
656895 | 656895 | 2020-10-22 | Chester | Tennessee | 47023 | 715 | 14 |
656896 | 656896 | 2020-10-22 | Claiborne | Tennessee | 47025 | 508 | 6 |
656897 | 656897 | 2020-10-22 | Clay | Tennessee | 47027 | 383 | 14 |
656898 | 656898 | 2020-10-22 | Cocke | Tennessee | 47029 | 966 | 12 |
656899 | 656899 | 2020-10-22 | Coffee | Tennessee | 47031 | 1799 | 20 |
656900 | 656900 | 2020-10-22 | Crockett | Tennessee | 47033 | 803 | 20 |
656901 | 656901 | 2020-10-22 | Cumberland | Tennessee | 47035 | 1561 | 24 |
656902 | 656902 | 2020-10-22 | Davidson | Tennessee | 47037 | 32559 | 330 |
656903 | 656903 | 2020-10-22 | DeKalb | Tennessee | 47041 | 690 | 17 |
656904 | 656904 | 2020-10-22 | Decatur | Tennessee | 47039 | 648 | 11 |
656905 | 656905 | 2020-10-22 | Dickson | Tennessee | 47043 | 1604 | 19 |
656906 | 656906 | 2020-10-22 | Dyer | Tennessee | 47045 | 2096 | 27 |
656907 | 656907 | 2020-10-22 | Fayette | Tennessee | 47047 | 1605 | 22 |
656908 | 656908 | 2020-10-22 | Fentress | Tennessee | 47049 | 877 | 8 |
656909 | 656909 | 2020-10-22 | Franklin | Tennessee | 47051 | 1244 | 16 |
656910 | 656910 | 2020-10-22 | Gibson | Tennessee | 47053 | 2082 | 38 |
656911 | 656911 | 2020-10-22 | Giles | Tennessee | 47055 | 921 | 34 |
656912 | 656912 | 2020-10-22 | Grainger | Tennessee | 47057 | 551 | 4 |
656913 | 656913 | 2020-10-22 | Greene | Tennessee | 47059 | 1618 | 51 |
656914 | 656914 | 2020-10-22 | Grundy | Tennessee | 47061 | 535 | 11 |
656915 | 656915 | 2020-10-22 | Hamblen | Tennessee | 47063 | 2379 | 43 |
656916 | 656916 | 2020-10-22 | Hamilton | Tennessee | 47065 | 11628 | 106 |
656917 | 656917 | 2020-10-22 | Hancock | Tennessee | 47067 | 113 | 3 |
656918 | 656918 | 2020-10-22 | Hardeman | Tennessee | 47069 | 1821 | 32 |
656919 | 656919 | 2020-10-22 | Hardin | Tennessee | 47071 | 1352 | 19 |
656920 | 656920 | 2020-10-22 | Hawkins | Tennessee | 47073 | 1142 | 24 |
656921 | 656921 | 2020-10-22 | Haywood | Tennessee | 47075 | 1210 | 27 |
656922 | 656922 | 2020-10-22 | Henderson | Tennessee | 47077 | 1379 | 25 |
656923 | 656923 | 2020-10-22 | Henry | Tennessee | 47079 | 756 | 10 |
656924 | 656924 | 2020-10-22 | Hickman | Tennessee | 47081 | 751 | 13 |
656925 | 656925 | 2020-10-22 | Houston | Tennessee | 47083 | 399 | 15 |
656926 | 656926 | 2020-10-22 | Humphreys | Tennessee | 47085 | 424 | 4 |
656927 | 656927 | 2020-10-22 | Jackson | Tennessee | 47087 | 434 | 5 |
656928 | 656928 | 2020-10-22 | Jefferson | Tennessee | 47089 | 1492 | 20 |
656929 | 656929 | 2020-10-22 | Johnson | Tennessee | 47091 | 1117 | 7 |
656930 | 656930 | 2020-10-22 | Knox | Tennessee | 47093 | 12632 | 99 |
656931 | 656931 | 2020-10-22 | Lake | Tennessee | 47095 | 975 | 3 |
656932 | 656932 | 2020-10-22 | Lauderdale | Tennessee | 47097 | 1367 | 17 |
656933 | 656933 | 2020-10-22 | Lawrence | Tennessee | 47099 | 1526 | 18 |
656934 | 656934 | 2020-10-22 | Lewis | Tennessee | 47101 | 360 | 2 |
656935 | 656935 | 2020-10-22 | Lincoln | Tennessee | 47103 | 836 | 3 |
656936 | 656936 | 2020-10-22 | Loudon | Tennessee | 47105 | 1566 | 10 |
656937 | 656937 | 2020-10-22 | Macon | Tennessee | 47111 | 1286 | 25 |
656938 | 656938 | 2020-10-22 | Madison | Tennessee | 47113 | 3696 | 79 |
656939 | 656939 | 2020-10-22 | Marion | Tennessee | 47115 | 724 | 9 |
656940 | 656940 | 2020-10-22 | Marshall | Tennessee | 47117 | 1085 | 9 |
656941 | 656941 | 2020-10-22 | Maury | Tennessee | 47119 | 3139 | 37 |
656942 | 656942 | 2020-10-22 | McMinn | Tennessee | 47107 | 1564 | 33 |
656943 | 656943 | 2020-10-22 | McNairy | Tennessee | 47109 | 1099 | 26 |
656944 | 656944 | 2020-10-22 | Meigs | Tennessee | 47121 | 300 | 5 |
656945 | 656945 | 2020-10-22 | Monroe | Tennessee | 47123 | 1395 | 28 |
656946 | 656946 | 2020-10-22 | Montgomery | Tennessee | 47125 | 3988 | 51 |
656947 | 656947 | 2020-10-22 | Moore | Tennessee | 47127 | 254 | 2 |
656948 | 656948 | 2020-10-22 | Morgan | Tennessee | 47129 | 422 | 7 |
656949 | 656949 | 2020-10-22 | Obion | Tennessee | 47131 | 1678 | 20 |
656950 | 656950 | 2020-10-22 | Overton | Tennessee | 47133 | 1165 | 12 |
656951 | 656951 | 2020-10-22 | Perry | Tennessee | 47135 | 261 | 1 |
656952 | 656952 | 2020-10-22 | Pickett | Tennessee | 47137 | 252 | 7 |
656953 | 656953 | 2020-10-22 | Polk | Tennessee | 47139 | 483 | 13 |
656954 | 656954 | 2020-10-22 | Putnam | Tennessee | 47141 | 4257 | 54 |
656955 | 656955 | 2020-10-22 | Rhea | Tennessee | 47143 | 1063 | 16 |
656956 | 656956 | 2020-10-22 | Roane | Tennessee | 47145 | 1223 | 7 |
656957 | 656957 | 2020-10-22 | Robertson | Tennessee | 47147 | 2537 | 41 |
656958 | 656958 | 2020-10-22 | Rutherford | Tennessee | 47149 | 11274 | 110 |
656959 | 656959 | 2020-10-22 | Scott | Tennessee | 47151 | 351 | 4 |
656960 | 656960 | 2020-10-22 | Sequatchie | Tennessee | 47153 | 329 | 4 |
656961 | 656961 | 2020-10-22 | Sevier | Tennessee | 47155 | 3241 | 21 |
656962 | 656962 | 2020-10-22 | Shelby | Tennessee | 47157 | 35279 | 558 |
656963 | 656963 | 2020-10-22 | Smith | Tennessee | 47159 | 962 | 12 |
656964 | 656964 | 2020-10-22 | Stewart | Tennessee | 47161 | 312 | 8 |
656965 | 656965 | 2020-10-22 | Sullivan | Tennessee | 47163 | 3395 | 46 |
656966 | 656966 | 2020-10-22 | Sumner | Tennessee | 47165 | 5788 | 108 |
656967 | 656967 | 2020-10-22 | Tipton | Tennessee | 47167 | 2260 | 22 |
656968 | 656968 | 2020-10-22 | Trousdale | Tennessee | 47169 | 1751 | 7 |
656969 | 656969 | 2020-10-22 | Unicoi | Tennessee | 47171 | 384 | 2 |
656970 | 656970 | 2020-10-22 | Union | Tennessee | 47173 | 517 | 3 |
656971 | 656971 | 2020-10-22 | Unknown | Tennessee | 460 | 0 | |
656972 | 656972 | 2020-10-22 | Van Buren | Tennessee | 47175 | 197 | 1 |
656973 | 656973 | 2020-10-22 | Warren | Tennessee | 47177 | 1387 | 10 |
656974 | 656974 | 2020-10-22 | Washington | Tennessee | 47179 | 3241 | 46 |
656975 | 656975 | 2020-10-22 | Wayne | Tennessee | 47181 | 1569 | 7 |
656976 | 656976 | 2020-10-22 | Weakley | Tennessee | 47183 | 1467 | 25 |
656977 | 656977 | 2020-10-22 | White | Tennessee | 47185 | 1133 | 14 |
656978 | 656978 | 2020-10-22 | Williamson | Tennessee | 47187 | 6802 | 55 |
656979 | 656979 | 2020-10-22 | Wilson | Tennessee | 47189 | 4514 | 55 |
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);