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-12-10 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
815863 | 815863 | 2020-12-10 | Anderson | Tennessee | 47001 | 3741 | 38 |
815864 | 815864 | 2020-12-10 | Bedford | Tennessee | 47003 | 3375 | 45 |
815865 | 815865 | 2020-12-10 | Benton | Tennessee | 47005 | 967 | 19 |
815866 | 815866 | 2020-12-10 | Bledsoe | Tennessee | 47007 | 1305 | 5 |
815867 | 815867 | 2020-12-10 | Blount | Tennessee | 47009 | 6924 | 68 |
815868 | 815868 | 2020-12-10 | Bradley | Tennessee | 47011 | 6473 | 43 |
815869 | 815869 | 2020-12-10 | Campbell | Tennessee | 47013 | 1858 | 26 |
815870 | 815870 | 2020-12-10 | Cannon | Tennessee | 47015 | 950 | 4 |
815871 | 815871 | 2020-12-10 | Carroll | Tennessee | 47017 | 2105 | 37 |
815872 | 815872 | 2020-12-10 | Carter | Tennessee | 47019 | 3304 | 72 |
815873 | 815873 | 2020-12-10 | Cheatham | Tennessee | 47021 | 1937 | 18 |
815874 | 815874 | 2020-12-10 | Chester | Tennessee | 47023 | 1157 | 25 |
815875 | 815875 | 2020-12-10 | Claiborne | Tennessee | 47025 | 1132 | 11 |
815876 | 815876 | 2020-12-10 | Clay | Tennessee | 47027 | 629 | 19 |
815877 | 815877 | 2020-12-10 | Cocke | Tennessee | 47029 | 1924 | 30 |
815878 | 815878 | 2020-12-10 | Coffee | Tennessee | 47031 | 3460 | 46 |
815879 | 815879 | 2020-12-10 | Crockett | Tennessee | 47033 | 1274 | 29 |
815880 | 815880 | 2020-12-10 | Cumberland | Tennessee | 47035 | 3041 | 42 |
815881 | 815881 | 2020-12-10 | Davidson | Tennessee | 47037 | 52479 | 456 |
815882 | 815882 | 2020-12-10 | DeKalb | Tennessee | 47041 | 1470 | 25 |
815883 | 815883 | 2020-12-10 | Decatur | Tennessee | 47039 | 1026 | 14 |
815884 | 815884 | 2020-12-10 | Dickson | Tennessee | 47043 | 3382 | 41 |
815885 | 815885 | 2020-12-10 | Dyer | Tennessee | 47045 | 3531 | 59 |
815886 | 815886 | 2020-12-10 | Fayette | Tennessee | 47047 | 2551 | 40 |
815887 | 815887 | 2020-12-10 | Fentress | Tennessee | 47049 | 1384 | 27 |
815888 | 815888 | 2020-12-10 | Franklin | Tennessee | 47051 | 2536 | 41 |
815889 | 815889 | 2020-12-10 | Gibson | Tennessee | 47053 | 3798 | 75 |
815890 | 815890 | 2020-12-10 | Giles | Tennessee | 47055 | 1752 | 51 |
815891 | 815891 | 2020-12-10 | Grainger | Tennessee | 47057 | 1242 | 21 |
815892 | 815892 | 2020-12-10 | Greene | Tennessee | 47059 | 3815 | 77 |
815893 | 815893 | 2020-12-10 | Grundy | Tennessee | 47061 | 898 | 14 |
815894 | 815894 | 2020-12-10 | Hamblen | Tennessee | 47063 | 4168 | 64 |
815895 | 815895 | 2020-12-10 | Hamilton | Tennessee | 47065 | 21753 | 204 |
815896 | 815896 | 2020-12-10 | Hancock | Tennessee | 47067 | 239 | 4 |
815897 | 815897 | 2020-12-10 | Hardeman | Tennessee | 47069 | 2420 | 40 |
815898 | 815898 | 2020-12-10 | Hardin | Tennessee | 47071 | 2025 | 30 |
815899 | 815899 | 2020-12-10 | Hawkins | Tennessee | 47073 | 2451 | 39 |
815900 | 815900 | 2020-12-10 | Haywood | Tennessee | 47075 | 1797 | 30 |
815901 | 815901 | 2020-12-10 | Henderson | Tennessee | 47077 | 2194 | 36 |
815902 | 815902 | 2020-12-10 | Henry | Tennessee | 47079 | 1818 | 24 |
815903 | 815903 | 2020-12-10 | Hickman | Tennessee | 47081 | 1400 | 19 |
815904 | 815904 | 2020-12-10 | Houston | Tennessee | 47083 | 637 | 21 |
815905 | 815905 | 2020-12-10 | Humphreys | Tennessee | 47085 | 858 | 8 |
815906 | 815906 | 2020-12-10 | Jackson | Tennessee | 47087 | 789 | 17 |
815907 | 815907 | 2020-12-10 | Jefferson | Tennessee | 47089 | 2757 | 38 |
815908 | 815908 | 2020-12-10 | Johnson | Tennessee | 47091 | 1564 | 25 |
815909 | 815909 | 2020-12-10 | Knox | Tennessee | 47093 | 23225 | 203 |
815910 | 815910 | 2020-12-10 | Lake | Tennessee | 47095 | 1268 | 8 |
815911 | 815911 | 2020-12-10 | Lauderdale | Tennessee | 47097 | 2225 | 25 |
815912 | 815912 | 2020-12-10 | Lawrence | Tennessee | 47099 | 3227 | 39 |
815913 | 815913 | 2020-12-10 | Lewis | Tennessee | 47101 | 903 | 16 |
815914 | 815914 | 2020-12-10 | Lincoln | Tennessee | 47103 | 2148 | 24 |
815915 | 815915 | 2020-12-10 | Loudon | Tennessee | 47105 | 2731 | 21 |
815916 | 815916 | 2020-12-10 | Macon | Tennessee | 47111 | 2028 | 32 |
815917 | 815917 | 2020-12-10 | Madison | Tennessee | 47113 | 6129 | 125 |
815918 | 815918 | 2020-12-10 | Marion | Tennessee | 47115 | 1369 | 22 |
815919 | 815919 | 2020-12-10 | Marshall | Tennessee | 47117 | 2049 | 22 |
815920 | 815920 | 2020-12-10 | Maury | Tennessee | 47119 | 7000 | 82 |
815921 | 815921 | 2020-12-10 | McMinn | Tennessee | 47107 | 3179 | 59 |
815922 | 815922 | 2020-12-10 | McNairy | Tennessee | 47109 | 1534 | 34 |
815923 | 815923 | 2020-12-10 | Meigs | Tennessee | 47121 | 635 | 13 |
815924 | 815924 | 2020-12-10 | Monroe | Tennessee | 47123 | 2648 | 47 |
815925 | 815925 | 2020-12-10 | Montgomery | Tennessee | 47125 | 7929 | 97 |
815926 | 815926 | 2020-12-10 | Moore | Tennessee | 47127 | 459 | 4 |
815927 | 815927 | 2020-12-10 | Morgan | Tennessee | 47129 | 938 | 8 |
815928 | 815928 | 2020-12-10 | Obion | Tennessee | 47131 | 2991 | 60 |
815929 | 815929 | 2020-12-10 | Overton | Tennessee | 47133 | 1661 | 37 |
815930 | 815930 | 2020-12-10 | Perry | Tennessee | 47135 | 577 | 22 |
815931 | 815931 | 2020-12-10 | Pickett | Tennessee | 47137 | 435 | 16 |
815932 | 815932 | 2020-12-10 | Polk | Tennessee | 47139 | 821 | 15 |
815933 | 815933 | 2020-12-10 | Putnam | Tennessee | 47141 | 6634 | 86 |
815934 | 815934 | 2020-12-10 | Rhea | Tennessee | 47143 | 2103 | 37 |
815935 | 815935 | 2020-12-10 | Roane | Tennessee | 47145 | 2898 | 36 |
815936 | 815936 | 2020-12-10 | Robertson | Tennessee | 47147 | 4557 | 57 |
815937 | 815937 | 2020-12-10 | Rutherford | Tennessee | 47149 | 21014 | 189 |
815938 | 815938 | 2020-12-10 | Scott | Tennessee | 47151 | 1376 | 9 |
815939 | 815939 | 2020-12-10 | Sequatchie | Tennessee | 47153 | 678 | 5 |
815940 | 815940 | 2020-12-10 | Sevier | Tennessee | 47155 | 5964 | 42 |
815941 | 815941 | 2020-12-10 | Shelby | Tennessee | 47157 | 53304 | 726 |
815942 | 815942 | 2020-12-10 | Smith | Tennessee | 47159 | 1585 | 19 |
815943 | 815943 | 2020-12-10 | Stewart | Tennessee | 47161 | 677 | 18 |
815944 | 815944 | 2020-12-10 | Sullivan | Tennessee | 47163 | 7888 | 126 |
815945 | 815945 | 2020-12-10 | Sumner | Tennessee | 47165 | 11785 | 152 |
815946 | 815946 | 2020-12-10 | Tipton | Tennessee | 47167 | 4181 | 42 |
815947 | 815947 | 2020-12-10 | Trousdale | Tennessee | 47169 | 1960 | 12 |
815948 | 815948 | 2020-12-10 | Unicoi | Tennessee | 47171 | 1068 | 30 |
815949 | 815949 | 2020-12-10 | Union | Tennessee | 47173 | 862 | 6 |
815950 | 815950 | 2020-12-10 | Unknown | Tennessee | 511 | 25 | |
815951 | 815951 | 2020-12-10 | Van Buren | Tennessee | 47175 | 423 | 4 |
815952 | 815952 | 2020-12-10 | Warren | Tennessee | 47177 | 2874 | 21 |
815953 | 815953 | 2020-12-10 | Washington | Tennessee | 47179 | 7457 | 128 |
815954 | 815954 | 2020-12-10 | Wayne | Tennessee | 47181 | 2068 | 13 |
815955 | 815955 | 2020-12-10 | Weakley | Tennessee | 47183 | 2414 | 38 |
815956 | 815956 | 2020-12-10 | White | Tennessee | 47185 | 2087 | 24 |
815957 | 815957 | 2020-12-10 | Williamson | Tennessee | 47187 | 13169 | 91 |
815958 | 815958 | 2020-12-10 | Wilson | Tennessee | 47189 | 8966 | 99 |
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);