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-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
776923 | 776923 | 2020-11-28 | Anderson | Tennessee | 47001 | 2946 | 29 |
776924 | 776924 | 2020-11-28 | Bedford | Tennessee | 47003 | 2756 | 30 |
776925 | 776925 | 2020-11-28 | Benton | Tennessee | 47005 | 813 | 14 |
776926 | 776926 | 2020-11-28 | Bledsoe | Tennessee | 47007 | 1174 | 5 |
776927 | 776927 | 2020-11-28 | Blount | Tennessee | 47009 | 5491 | 60 |
776928 | 776928 | 2020-11-28 | Bradley | Tennessee | 47011 | 5197 | 35 |
776929 | 776929 | 2020-11-28 | Campbell | Tennessee | 47013 | 1542 | 23 |
776930 | 776930 | 2020-11-28 | Cannon | Tennessee | 47015 | 766 | 3 |
776931 | 776931 | 2020-11-28 | Carroll | Tennessee | 47017 | 1747 | 34 |
776932 | 776932 | 2020-11-28 | Carter | Tennessee | 47019 | 2724 | 55 |
776933 | 776933 | 2020-11-28 | Cheatham | Tennessee | 47021 | 1586 | 17 |
776934 | 776934 | 2020-11-28 | Chester | Tennessee | 47023 | 1025 | 20 |
776935 | 776935 | 2020-11-28 | Claiborne | Tennessee | 47025 | 836 | 9 |
776936 | 776936 | 2020-11-28 | Clay | Tennessee | 47027 | 553 | 18 |
776937 | 776937 | 2020-11-28 | Cocke | Tennessee | 47029 | 1606 | 30 |
776938 | 776938 | 2020-11-28 | Coffee | Tennessee | 47031 | 2818 | 41 |
776939 | 776939 | 2020-11-28 | Crockett | Tennessee | 47033 | 1155 | 26 |
776940 | 776940 | 2020-11-28 | Cumberland | Tennessee | 47035 | 2572 | 36 |
776941 | 776941 | 2020-11-28 | Davidson | Tennessee | 47037 | 44042 | 420 |
776942 | 776942 | 2020-11-28 | DeKalb | Tennessee | 47041 | 1158 | 22 |
776943 | 776943 | 2020-11-28 | Decatur | Tennessee | 47039 | 955 | 13 |
776944 | 776944 | 2020-11-28 | Dickson | Tennessee | 47043 | 2891 | 33 |
776945 | 776945 | 2020-11-28 | Dyer | Tennessee | 47045 | 3207 | 51 |
776946 | 776946 | 2020-11-28 | Fayette | Tennessee | 47047 | 2253 | 38 |
776947 | 776947 | 2020-11-28 | Fentress | Tennessee | 47049 | 1219 | 20 |
776948 | 776948 | 2020-11-28 | Franklin | Tennessee | 47051 | 2086 | 34 |
776949 | 776949 | 2020-11-28 | Gibson | Tennessee | 47053 | 3233 | 65 |
776950 | 776950 | 2020-11-28 | Giles | Tennessee | 47055 | 1469 | 49 |
776951 | 776951 | 2020-11-28 | Grainger | Tennessee | 47057 | 1012 | 17 |
776952 | 776952 | 2020-11-28 | Greene | Tennessee | 47059 | 3082 | 72 |
776953 | 776953 | 2020-11-28 | Grundy | Tennessee | 47061 | 777 | 14 |
776954 | 776954 | 2020-11-28 | Hamblen | Tennessee | 47063 | 3455 | 60 |
776955 | 776955 | 2020-11-28 | Hamilton | Tennessee | 47065 | 17506 | 152 |
776956 | 776956 | 2020-11-28 | Hancock | Tennessee | 47067 | 167 | 3 |
776957 | 776957 | 2020-11-28 | Hardeman | Tennessee | 47069 | 2247 | 37 |
776958 | 776958 | 2020-11-28 | Hardin | Tennessee | 47071 | 1781 | 25 |
776959 | 776959 | 2020-11-28 | Hawkins | Tennessee | 47073 | 1949 | 34 |
776960 | 776960 | 2020-11-28 | Haywood | Tennessee | 47075 | 1629 | 30 |
776961 | 776961 | 2020-11-28 | Henderson | Tennessee | 47077 | 1851 | 33 |
776962 | 776962 | 2020-11-28 | Henry | Tennessee | 47079 | 1536 | 19 |
776963 | 776963 | 2020-11-28 | Hickman | Tennessee | 47081 | 1182 | 19 |
776964 | 776964 | 2020-11-28 | Houston | Tennessee | 47083 | 587 | 20 |
776965 | 776965 | 2020-11-28 | Humphreys | Tennessee | 47085 | 709 | 8 |
776966 | 776966 | 2020-11-28 | Jackson | Tennessee | 47087 | 684 | 10 |
776967 | 776967 | 2020-11-28 | Jefferson | Tennessee | 47089 | 2269 | 32 |
776968 | 776968 | 2020-11-28 | Johnson | Tennessee | 47091 | 1416 | 21 |
776969 | 776969 | 2020-11-28 | Knox | Tennessee | 47093 | 19104 | 162 |
776970 | 776970 | 2020-11-28 | Lake | Tennessee | 47095 | 1176 | 6 |
776971 | 776971 | 2020-11-28 | Lauderdale | Tennessee | 47097 | 2050 | 23 |
776972 | 776972 | 2020-11-28 | Lawrence | Tennessee | 47099 | 2700 | 34 |
776973 | 776973 | 2020-11-28 | Lewis | Tennessee | 47101 | 763 | 14 |
776974 | 776974 | 2020-11-28 | Lincoln | Tennessee | 47103 | 1612 | 15 |
776975 | 776975 | 2020-11-28 | Loudon | Tennessee | 47105 | 2280 | 19 |
776976 | 776976 | 2020-11-28 | Macon | Tennessee | 47111 | 1840 | 28 |
776977 | 776977 | 2020-11-28 | Madison | Tennessee | 47113 | 5349 | 110 |
776978 | 776978 | 2020-11-28 | Marion | Tennessee | 47115 | 1098 | 19 |
776979 | 776979 | 2020-11-28 | Marshall | Tennessee | 47117 | 1744 | 20 |
776980 | 776980 | 2020-11-28 | Maury | Tennessee | 47119 | 5842 | 67 |
776981 | 776981 | 2020-11-28 | McMinn | Tennessee | 47107 | 2523 | 55 |
776982 | 776982 | 2020-11-28 | McNairy | Tennessee | 47109 | 1402 | 33 |
776983 | 776983 | 2020-11-28 | Meigs | Tennessee | 47121 | 489 | 13 |
776984 | 776984 | 2020-11-28 | Monroe | Tennessee | 47123 | 2127 | 44 |
776985 | 776985 | 2020-11-28 | Montgomery | Tennessee | 47125 | 6586 | 83 |
776986 | 776986 | 2020-11-28 | Moore | Tennessee | 47127 | 396 | 3 |
776987 | 776987 | 2020-11-28 | Morgan | Tennessee | 47129 | 730 | 6 |
776988 | 776988 | 2020-11-28 | Obion | Tennessee | 47131 | 2659 | 50 |
776989 | 776989 | 2020-11-28 | Overton | Tennessee | 47133 | 1543 | 35 |
776990 | 776990 | 2020-11-28 | Perry | Tennessee | 47135 | 483 | 21 |
776991 | 776991 | 2020-11-28 | Pickett | Tennessee | 47137 | 390 | 13 |
776992 | 776992 | 2020-11-28 | Polk | Tennessee | 47139 | 665 | 15 |
776993 | 776993 | 2020-11-28 | Putnam | Tennessee | 47141 | 5913 | 82 |
776994 | 776994 | 2020-11-28 | Rhea | Tennessee | 47143 | 1697 | 31 |
776995 | 776995 | 2020-11-28 | Roane | Tennessee | 47145 | 2352 | 29 |
776996 | 776996 | 2020-11-28 | Robertson | Tennessee | 47147 | 3774 | 53 |
776997 | 776997 | 2020-11-28 | Rutherford | Tennessee | 47149 | 17749 | 161 |
776998 | 776998 | 2020-11-28 | Scott | Tennessee | 47151 | 1072 | 7 |
776999 | 776999 | 2020-11-28 | Sequatchie | Tennessee | 47153 | 528 | 5 |
777000 | 777000 | 2020-11-28 | Sevier | Tennessee | 47155 | 4848 | 31 |
777001 | 777001 | 2020-11-28 | Shelby | Tennessee | 47157 | 47682 | 659 |
777002 | 777002 | 2020-11-28 | Smith | Tennessee | 47159 | 1438 | 19 |
777003 | 777003 | 2020-11-28 | Stewart | Tennessee | 47161 | 594 | 15 |
777004 | 777004 | 2020-11-28 | Sullivan | Tennessee | 47163 | 6439 | 96 |
777005 | 777005 | 2020-11-28 | Sumner | Tennessee | 47165 | 9744 | 137 |
777006 | 777006 | 2020-11-28 | Tipton | Tennessee | 47167 | 3659 | 38 |
777007 | 777007 | 2020-11-28 | Trousdale | Tennessee | 47169 | 1905 | 12 |
777008 | 777008 | 2020-11-28 | Unicoi | Tennessee | 47171 | 858 | 26 |
777009 | 777009 | 2020-11-28 | Union | Tennessee | 47173 | 719 | 5 |
777010 | 777010 | 2020-11-28 | Unknown | Tennessee | 2198 | 8 | |
777011 | 777011 | 2020-11-28 | Van Buren | Tennessee | 47175 | 367 | 2 |
777012 | 777012 | 2020-11-28 | Warren | Tennessee | 47177 | 2400 | 20 |
777013 | 777013 | 2020-11-28 | Washington | Tennessee | 47179 | 6000 | 106 |
777014 | 777014 | 2020-11-28 | Wayne | Tennessee | 47181 | 1920 | 10 |
777015 | 777015 | 2020-11-28 | Weakley | Tennessee | 47183 | 2169 | 37 |
777016 | 777016 | 2020-11-28 | White | Tennessee | 47185 | 1769 | 18 |
777017 | 777017 | 2020-11-28 | Williamson | Tennessee | 47187 | 11400 | 80 |
777018 | 777018 | 2020-11-28 | Wilson | Tennessee | 47189 | 7481 | 78 |
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);