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 2021-02-09 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1013839 | 1013839 | 2021-02-09 | Anderson | Tennessee | 47001 | 7432 | 147 |
1013840 | 1013840 | 2021-02-09 | Bedford | Tennessee | 47003 | 5647 | 112 |
1013841 | 1013841 | 2021-02-09 | Benton | Tennessee | 47005 | 1395 | 37 |
1013842 | 1013842 | 2021-02-09 | Bledsoe | Tennessee | 47007 | 1901 | 11 |
1013843 | 1013843 | 2021-02-09 | Blount | Tennessee | 47009 | 13074 | 158 |
1013844 | 1013844 | 2021-02-09 | Bradley | Tennessee | 47011 | 12035 | 129 |
1013845 | 1013845 | 2021-02-09 | Campbell | Tennessee | 47013 | 3574 | 52 |
1013846 | 1013846 | 2021-02-09 | Cannon | Tennessee | 47015 | 1700 | 26 |
1013847 | 1013847 | 2021-02-09 | Carroll | Tennessee | 47017 | 3344 | 79 |
1013848 | 1013848 | 2021-02-09 | Carter | Tennessee | 47019 | 5518 | 140 |
1013849 | 1013849 | 2021-02-09 | Cheatham | Tennessee | 47021 | 3712 | 39 |
1013850 | 1013850 | 2021-02-09 | Chester | Tennessee | 47023 | 1915 | 44 |
1013851 | 1013851 | 2021-02-09 | Claiborne | Tennessee | 47025 | 2498 | 56 |
1013852 | 1013852 | 2021-02-09 | Clay | Tennessee | 47027 | 1010 | 30 |
1013853 | 1013853 | 2021-02-09 | Cocke | Tennessee | 47029 | 3778 | 85 |
1013854 | 1013854 | 2021-02-09 | Coffee | Tennessee | 47031 | 6036 | 108 |
1013855 | 1013855 | 2021-02-09 | Crockett | Tennessee | 47033 | 1895 | 43 |
1013856 | 1013856 | 2021-02-09 | Cumberland | Tennessee | 47035 | 5781 | 106 |
1013857 | 1013857 | 2021-02-09 | Davidson | Tennessee | 47037 | 86781 | 800 |
1013858 | 1013858 | 2021-02-09 | DeKalb | Tennessee | 47041 | 2576 | 48 |
1013859 | 1013859 | 2021-02-09 | Decatur | Tennessee | 47039 | 1523 | 33 |
1013860 | 1013860 | 2021-02-09 | Dickson | Tennessee | 47043 | 5900 | 98 |
1013861 | 1013861 | 2021-02-09 | Dyer | Tennessee | 47045 | 5070 | 92 |
1013862 | 1013862 | 2021-02-09 | Fayette | Tennessee | 47047 | 4386 | 67 |
1013863 | 1013863 | 2021-02-09 | Fentress | Tennessee | 47049 | 2230 | 41 |
1013864 | 1013864 | 2021-02-09 | Franklin | Tennessee | 47051 | 4499 | 76 |
1013865 | 1013865 | 2021-02-09 | Gibson | Tennessee | 47053 | 5987 | 129 |
1013866 | 1013866 | 2021-02-09 | Giles | Tennessee | 47055 | 3495 | 89 |
1013867 | 1013867 | 2021-02-09 | Grainger | Tennessee | 47057 | 2281 | 45 |
1013868 | 1013868 | 2021-02-09 | Greene | Tennessee | 47059 | 7046 | 136 |
1013869 | 1013869 | 2021-02-09 | Grundy | Tennessee | 47061 | 1533 | 28 |
1013870 | 1013870 | 2021-02-09 | Hamblen | Tennessee | 47063 | 7623 | 151 |
1013871 | 1013871 | 2021-02-09 | Hamilton | Tennessee | 47065 | 38994 | 418 |
1013872 | 1013872 | 2021-02-09 | Hancock | Tennessee | 47067 | 464 | 9 |
1013873 | 1013873 | 2021-02-09 | Hardeman | Tennessee | 47069 | 3272 | 62 |
1013874 | 1013874 | 2021-02-09 | Hardin | Tennessee | 47071 | 3150 | 60 |
1013875 | 1013875 | 2021-02-09 | Hawkins | Tennessee | 47073 | 4949 | 87 |
1013876 | 1013876 | 2021-02-09 | Haywood | Tennessee | 47075 | 2547 | 58 |
1013877 | 1013877 | 2021-02-09 | Henderson | Tennessee | 47077 | 3509 | 70 |
1013878 | 1013878 | 2021-02-09 | Henry | Tennessee | 47079 | 2821 | 72 |
1013879 | 1013879 | 2021-02-09 | Hickman | Tennessee | 47081 | 2395 | 38 |
1013880 | 1013880 | 2021-02-09 | Houston | Tennessee | 47083 | 978 | 28 |
1013881 | 1013881 | 2021-02-09 | Humphreys | Tennessee | 47085 | 1461 | 20 |
1013882 | 1013882 | 2021-02-09 | Jackson | Tennessee | 47087 | 1131 | 30 |
1013883 | 1013883 | 2021-02-09 | Jefferson | Tennessee | 47089 | 5274 | 97 |
1013884 | 1013884 | 2021-02-09 | Johnson | Tennessee | 47091 | 2133 | 38 |
1013885 | 1013885 | 2021-02-09 | Knox | Tennessee | 47093 | 44404 | 527 |
1013886 | 1013886 | 2021-02-09 | Lake | Tennessee | 47095 | 1655 | 24 |
1013887 | 1013887 | 2021-02-09 | Lauderdale | Tennessee | 47097 | 3078 | 41 |
1013888 | 1013888 | 2021-02-09 | Lawrence | Tennessee | 47099 | 5465 | 78 |
1013889 | 1013889 | 2021-02-09 | Lewis | Tennessee | 47101 | 1402 | 23 |
1013890 | 1013890 | 2021-02-09 | Lincoln | Tennessee | 47103 | 4026 | 55 |
1013891 | 1013891 | 2021-02-09 | Loudon | Tennessee | 47105 | 5450 | 64 |
1013892 | 1013892 | 2021-02-09 | Macon | Tennessee | 47111 | 3085 | 67 |
1013893 | 1013893 | 2021-02-09 | Madison | Tennessee | 47113 | 9787 | 212 |
1013894 | 1013894 | 2021-02-09 | Marion | Tennessee | 47115 | 2521 | 38 |
1013895 | 1013895 | 2021-02-09 | Marshall | Tennessee | 47117 | 3788 | 53 |
1013896 | 1013896 | 2021-02-09 | Maury | Tennessee | 47119 | 11946 | 151 |
1013897 | 1013897 | 2021-02-09 | McMinn | Tennessee | 47107 | 5557 | 87 |
1013898 | 1013898 | 2021-02-09 | McNairy | Tennessee | 47109 | 2604 | 46 |
1013899 | 1013899 | 2021-02-09 | Meigs | Tennessee | 47121 | 1244 | 19 |
1013900 | 1013900 | 2021-02-09 | Monroe | Tennessee | 47123 | 5023 | 82 |
1013901 | 1013901 | 2021-02-09 | Montgomery | Tennessee | 47125 | 16374 | 188 |
1013902 | 1013902 | 2021-02-09 | Moore | Tennessee | 47127 | 874 | 15 |
1013903 | 1013903 | 2021-02-09 | Morgan | Tennessee | 47129 | 2090 | 26 |
1013904 | 1013904 | 2021-02-09 | Obion | Tennessee | 47131 | 4185 | 91 |
1013905 | 1013905 | 2021-02-09 | Overton | Tennessee | 47133 | 2700 | 56 |
1013906 | 1013906 | 2021-02-09 | Perry | Tennessee | 47135 | 995 | 25 |
1013907 | 1013907 | 2021-02-09 | Pickett | Tennessee | 47137 | 722 | 21 |
1013908 | 1013908 | 2021-02-09 | Polk | Tennessee | 47139 | 1621 | 21 |
1013909 | 1013909 | 2021-02-09 | Putnam | Tennessee | 47141 | 10572 | 164 |
1013910 | 1013910 | 2021-02-09 | Rhea | Tennessee | 47143 | 4064 | 65 |
1013911 | 1013911 | 2021-02-09 | Roane | Tennessee | 47145 | 5603 | 95 |
1013912 | 1013912 | 2021-02-09 | Robertson | Tennessee | 47147 | 8361 | 106 |
1013913 | 1013913 | 2021-02-09 | Rutherford | Tennessee | 47149 | 36115 | 347 |
1013914 | 1013914 | 2021-02-09 | Scott | Tennessee | 47151 | 2434 | 39 |
1013915 | 1013915 | 2021-02-09 | Sequatchie | Tennessee | 47153 | 1511 | 24 |
1013916 | 1013916 | 2021-02-09 | Sevier | Tennessee | 47155 | 11430 | 149 |
1013917 | 1013917 | 2021-02-09 | Shelby | Tennessee | 47157 | 85234 | 1387 |
1013918 | 1013918 | 2021-02-09 | Smith | Tennessee | 47159 | 2445 | 35 |
1013919 | 1013919 | 2021-02-09 | Stewart | Tennessee | 47161 | 1181 | 25 |
1013920 | 1013920 | 2021-02-09 | Sullivan | Tennessee | 47163 | 13577 | 257 |
1013921 | 1013921 | 2021-02-09 | Sumner | Tennessee | 47165 | 19892 | 289 |
1013922 | 1013922 | 2021-02-09 | Tipton | Tennessee | 47167 | 6672 | 92 |
1013923 | 1013923 | 2021-02-09 | Trousdale | Tennessee | 47169 | 2351 | 19 |
1013924 | 1013924 | 2021-02-09 | Unicoi | Tennessee | 47171 | 1735 | 48 |
1013925 | 1013925 | 2021-02-09 | Union | Tennessee | 47173 | 1566 | 28 |
1013926 | 1013926 | 2021-02-09 | Unknown | Tennessee | 13702 | 191 | |
1013927 | 1013927 | 2021-02-09 | Van Buren | Tennessee | 47175 | 713 | 17 |
1013928 | 1013928 | 2021-02-09 | Warren | Tennessee | 47177 | 5249 | 70 |
1013929 | 1013929 | 2021-02-09 | Washington | Tennessee | 47179 | 12565 | 224 |
1013930 | 1013930 | 2021-02-09 | Wayne | Tennessee | 47181 | 2790 | 27 |
1013931 | 1013931 | 2021-02-09 | Weakley | Tennessee | 47183 | 3599 | 54 |
1013932 | 1013932 | 2021-02-09 | White | Tennessee | 47185 | 3269 | 59 |
1013933 | 1013933 | 2021-02-09 | Williamson | Tennessee | 47187 | 23860 | 191 |
1013934 | 1013934 | 2021-02-09 | Wilson | Tennessee | 47189 | 15640 | 194 |
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);