ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-11-20" 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 |
---|---|---|---|---|---|---|---|
750959 | 750959 | 2020-11-20 | Anderson | Tennessee | 47001 | 2589 | 25 |
750960 | 750960 | 2020-11-20 | Bedford | Tennessee | 47003 | 2412 | 27 |
750961 | 750961 | 2020-11-20 | Benton | Tennessee | 47005 | 718 | 14 |
750962 | 750962 | 2020-11-20 | Bledsoe | Tennessee | 47007 | 1133 | 5 |
750963 | 750963 | 2020-11-20 | Blount | Tennessee | 47009 | 4900 | 55 |
750964 | 750964 | 2020-11-20 | Bradley | Tennessee | 47011 | 4649 | 33 |
750965 | 750965 | 2020-11-20 | Campbell | Tennessee | 47013 | 1389 | 21 |
750966 | 750966 | 2020-11-20 | Cannon | Tennessee | 47015 | 666 | 2 |
750967 | 750967 | 2020-11-20 | Carroll | Tennessee | 47017 | 1565 | 31 |
750968 | 750968 | 2020-11-20 | Carter | Tennessee | 47019 | 2453 | 50 |
750969 | 750969 | 2020-11-20 | Cheatham | Tennessee | 47021 | 1432 | 16 |
750970 | 750970 | 2020-11-20 | Chester | Tennessee | 47023 | 949 | 19 |
750971 | 750971 | 2020-11-20 | Claiborne | Tennessee | 47025 | 718 | 9 |
750972 | 750972 | 2020-11-20 | Clay | Tennessee | 47027 | 519 | 18 |
750973 | 750973 | 2020-11-20 | Cocke | Tennessee | 47029 | 1497 | 26 |
750974 | 750974 | 2020-11-20 | Coffee | Tennessee | 47031 | 2547 | 39 |
750975 | 750975 | 2020-11-20 | Crockett | Tennessee | 47033 | 1096 | 25 |
750976 | 750976 | 2020-11-20 | Cumberland | Tennessee | 47035 | 2328 | 34 |
750977 | 750977 | 2020-11-20 | Davidson | Tennessee | 47037 | 42262 | 399 |
750978 | 750978 | 2020-11-20 | DeKalb | Tennessee | 47041 | 1056 | 20 |
750979 | 750979 | 2020-11-20 | Decatur | Tennessee | 47039 | 885 | 12 |
750980 | 750980 | 2020-11-20 | Dickson | Tennessee | 47043 | 2597 | 26 |
750981 | 750981 | 2020-11-20 | Dyer | Tennessee | 47045 | 3004 | 49 |
750982 | 750982 | 2020-11-20 | Fayette | Tennessee | 47047 | 2088 | 37 |
750983 | 750983 | 2020-11-20 | Fentress | Tennessee | 47049 | 1133 | 19 |
750984 | 750984 | 2020-11-20 | Franklin | Tennessee | 47051 | 1844 | 29 |
750985 | 750985 | 2020-11-20 | Gibson | Tennessee | 47053 | 2893 | 61 |
750986 | 750986 | 2020-11-20 | Giles | Tennessee | 47055 | 1311 | 40 |
750987 | 750987 | 2020-11-20 | Grainger | Tennessee | 47057 | 860 | 13 |
750988 | 750988 | 2020-11-20 | Greene | Tennessee | 47059 | 2715 | 67 |
750989 | 750989 | 2020-11-20 | Grundy | Tennessee | 47061 | 720 | 14 |
750990 | 750990 | 2020-11-20 | Hamblen | Tennessee | 47063 | 3163 | 57 |
750991 | 750991 | 2020-11-20 | Hamilton | Tennessee | 47065 | 16169 | 134 |
750992 | 750992 | 2020-11-20 | Hancock | Tennessee | 47067 | 138 | 3 |
750993 | 750993 | 2020-11-20 | Hardeman | Tennessee | 47069 | 2175 | 36 |
750994 | 750994 | 2020-11-20 | Hardin | Tennessee | 47071 | 1680 | 25 |
750995 | 750995 | 2020-11-20 | Hawkins | Tennessee | 47073 | 1727 | 34 |
750996 | 750996 | 2020-11-20 | Haywood | Tennessee | 47075 | 1553 | 29 |
750997 | 750997 | 2020-11-20 | Henderson | Tennessee | 47077 | 1736 | 30 |
750998 | 750998 | 2020-11-20 | Henry | Tennessee | 47079 | 1352 | 17 |
750999 | 750999 | 2020-11-20 | Hickman | Tennessee | 47081 | 1077 | 17 |
751000 | 751000 | 2020-11-20 | Houston | Tennessee | 47083 | 563 | 19 |
751001 | 751001 | 2020-11-20 | Humphreys | Tennessee | 47085 | 629 | 7 |
751002 | 751002 | 2020-11-20 | Jackson | Tennessee | 47087 | 650 | 9 |
751003 | 751003 | 2020-11-20 | Jefferson | Tennessee | 47089 | 2057 | 30 |
751004 | 751004 | 2020-11-20 | Johnson | Tennessee | 47091 | 1351 | 20 |
751005 | 751005 | 2020-11-20 | Knox | Tennessee | 47093 | 17392 | 146 |
751006 | 751006 | 2020-11-20 | Lake | Tennessee | 47095 | 1132 | 5 |
751007 | 751007 | 2020-11-20 | Lauderdale | Tennessee | 47097 | 1959 | 20 |
751008 | 751008 | 2020-11-20 | Lawrence | Tennessee | 47099 | 2430 | 32 |
751009 | 751009 | 2020-11-20 | Lewis | Tennessee | 47101 | 690 | 11 |
751010 | 751010 | 2020-11-20 | Lincoln | Tennessee | 47103 | 1358 | 11 |
751011 | 751011 | 2020-11-20 | Loudon | Tennessee | 47105 | 2084 | 17 |
751012 | 751012 | 2020-11-20 | Macon | Tennessee | 47111 | 1726 | 27 |
751013 | 751013 | 2020-11-20 | Madison | Tennessee | 47113 | 4964 | 102 |
751014 | 751014 | 2020-11-20 | Marion | Tennessee | 47115 | 1014 | 16 |
751015 | 751015 | 2020-11-20 | Marshall | Tennessee | 47117 | 1577 | 17 |
751016 | 751016 | 2020-11-20 | Maury | Tennessee | 47119 | 5266 | 57 |
751017 | 751017 | 2020-11-20 | McMinn | Tennessee | 47107 | 2271 | 54 |
751018 | 751018 | 2020-11-20 | McNairy | Tennessee | 47109 | 1357 | 32 |
751019 | 751019 | 2020-11-20 | Meigs | Tennessee | 47121 | 443 | 12 |
751020 | 751020 | 2020-11-20 | Monroe | Tennessee | 47123 | 1916 | 42 |
751021 | 751021 | 2020-11-20 | Montgomery | Tennessee | 47125 | 5956 | 80 |
751022 | 751022 | 2020-11-20 | Moore | Tennessee | 47127 | 355 | 2 |
751023 | 751023 | 2020-11-20 | Morgan | Tennessee | 47129 | 609 | 6 |
751024 | 751024 | 2020-11-20 | Obion | Tennessee | 47131 | 2440 | 43 |
751025 | 751025 | 2020-11-20 | Overton | Tennessee | 47133 | 1473 | 33 |
751026 | 751026 | 2020-11-20 | Perry | Tennessee | 47135 | 452 | 21 |
751027 | 751027 | 2020-11-20 | Pickett | Tennessee | 47137 | 359 | 12 |
751028 | 751028 | 2020-11-20 | Polk | Tennessee | 47139 | 614 | 14 |
751029 | 751029 | 2020-11-20 | Putnam | Tennessee | 47141 | 5567 | 75 |
751030 | 751030 | 2020-11-20 | Rhea | Tennessee | 47143 | 1498 | 29 |
751031 | 751031 | 2020-11-20 | Roane | Tennessee | 47145 | 2116 | 22 |
751032 | 751032 | 2020-11-20 | Robertson | Tennessee | 47147 | 3415 | 50 |
751033 | 751033 | 2020-11-20 | Rutherford | Tennessee | 47149 | 16264 | 148 |
751034 | 751034 | 2020-11-20 | Scott | Tennessee | 47151 | 875 | 7 |
751035 | 751035 | 2020-11-20 | Sequatchie | Tennessee | 47153 | 484 | 5 |
751036 | 751036 | 2020-11-20 | Sevier | Tennessee | 47155 | 4419 | 29 |
751037 | 751037 | 2020-11-20 | Shelby | Tennessee | 47157 | 44659 | 630 |
751038 | 751038 | 2020-11-20 | Smith | Tennessee | 47159 | 1338 | 18 |
751039 | 751039 | 2020-11-20 | Stewart | Tennessee | 47161 | 535 | 14 |
751040 | 751040 | 2020-11-20 | Sullivan | Tennessee | 47163 | 5755 | 89 |
751041 | 751041 | 2020-11-20 | Sumner | Tennessee | 47165 | 8696 | 131 |
751042 | 751042 | 2020-11-20 | Tipton | Tennessee | 47167 | 3294 | 35 |
751043 | 751043 | 2020-11-20 | Trousdale | Tennessee | 47169 | 1885 | 12 |
751044 | 751044 | 2020-11-20 | Unicoi | Tennessee | 47171 | 728 | 22 |
751045 | 751045 | 2020-11-20 | Union | Tennessee | 47173 | 669 | 5 |
751046 | 751046 | 2020-11-20 | Unknown | Tennessee | 147 | 1 | |
751047 | 751047 | 2020-11-20 | Van Buren | Tennessee | 47175 | 317 | 2 |
751048 | 751048 | 2020-11-20 | Warren | Tennessee | 47177 | 2166 | 16 |
751049 | 751049 | 2020-11-20 | Washington | Tennessee | 47179 | 5338 | 95 |
751050 | 751050 | 2020-11-20 | Wayne | Tennessee | 47181 | 1764 | 10 |
751051 | 751051 | 2020-11-20 | Weakley | Tennessee | 47183 | 2024 | 34 |
751052 | 751052 | 2020-11-20 | White | Tennessee | 47185 | 1632 | 17 |
751053 | 751053 | 2020-11-20 | Williamson | Tennessee | 47187 | 10231 | 73 |
751054 | 751054 | 2020-11-20 | Wilson | Tennessee | 47189 | 6681 | 73 |
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);