ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2022-03-10" 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 |
---|---|---|---|---|---|---|---|
2293797 | 2293797 | 2022-03-10 | Anderson | Tennessee | 47001 | 21942 | 312 |
2293798 | 2293798 | 2022-03-10 | Bedford | Tennessee | 47003 | 14906 | 221 |
2293799 | 2293799 | 2022-03-10 | Benton | Tennessee | 47005 | 4453 | 90 |
2293800 | 2293800 | 2022-03-10 | Bledsoe | Tennessee | 47007 | 4645 | 53 |
2293801 | 2293801 | 2022-03-10 | Blount | Tennessee | 47009 | 38940 | 399 |
2293802 | 2293802 | 2022-03-10 | Bradley | Tennessee | 47011 | 33031 | 387 |
2293803 | 2293803 | 2022-03-10 | Campbell | Tennessee | 47013 | 12010 | 153 |
2293804 | 2293804 | 2022-03-10 | Cannon | Tennessee | 47015 | 4170 | 56 |
2293805 | 2293805 | 2022-03-10 | Carroll | Tennessee | 47017 | 8914 | 150 |
2293806 | 2293806 | 2022-03-10 | Carter | Tennessee | 47019 | 16377 | 316 |
2293807 | 2293807 | 2022-03-10 | Cheatham | Tennessee | 47021 | 10876 | 117 |
2293808 | 2293808 | 2022-03-10 | Chester | Tennessee | 47023 | 5768 | 94 |
2293809 | 2293809 | 2022-03-10 | Claiborne | Tennessee | 47025 | 9027 | 167 |
2293810 | 2293810 | 2022-03-10 | Clay | Tennessee | 47027 | 2219 | 47 |
2293811 | 2293811 | 2022-03-10 | Cocke | Tennessee | 47029 | 11508 | 201 |
2293812 | 2293812 | 2022-03-10 | Coffee | Tennessee | 47031 | 16894 | 250 |
2293813 | 2293813 | 2022-03-10 | Crockett | Tennessee | 47033 | 5150 | 82 |
2293814 | 2293814 | 2022-03-10 | Cumberland | Tennessee | 47035 | 16042 | 310 |
2293815 | 2293815 | 2022-03-10 | Davidson | Tennessee | 47037 | 206190 | 1601 |
2293816 | 2293816 | 2022-03-10 | DeKalb | Tennessee | 47041 | 6268 | 97 |
2293817 | 2293817 | 2022-03-10 | Decatur | Tennessee | 47039 | 3715 | 64 |
2293818 | 2293818 | 2022-03-10 | Dickson | Tennessee | 47043 | 15826 | 235 |
2293819 | 2293819 | 2022-03-10 | Dyer | Tennessee | 47045 | 12720 | 192 |
2293820 | 2293820 | 2022-03-10 | Fayette | Tennessee | 47047 | 11387 | 171 |
2293821 | 2293821 | 2022-03-10 | Fentress | Tennessee | 47049 | 5681 | 117 |
2293822 | 2293822 | 2022-03-10 | Franklin | Tennessee | 47051 | 12802 | 165 |
2293823 | 2293823 | 2022-03-10 | Gibson | Tennessee | 47053 | 17286 | 252 |
2293824 | 2293824 | 2022-03-10 | Giles | Tennessee | 47055 | 9382 | 172 |
2293825 | 2293825 | 2022-03-10 | Grainger | Tennessee | 47057 | 6747 | 103 |
2293826 | 2293826 | 2022-03-10 | Greene | Tennessee | 47059 | 21952 | 353 |
2293827 | 2293827 | 2022-03-10 | Grundy | Tennessee | 47061 | 3974 | 69 |
2293828 | 2293828 | 2022-03-10 | Hamblen | Tennessee | 47063 | 19651 | 345 |
2293829 | 2293829 | 2022-03-10 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2293830 | 2293830 | 2022-03-10 | Hancock | Tennessee | 47067 | 1998 | 32 |
2293831 | 2293831 | 2022-03-10 | Hardeman | Tennessee | 47069 | 7550 | 113 |
2293832 | 2293832 | 2022-03-10 | Hardin | Tennessee | 47071 | 8695 | 137 |
2293833 | 2293833 | 2022-03-10 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2293834 | 2293834 | 2022-03-10 | Haywood | Tennessee | 47075 | 6131 | 97 |
2293835 | 2293835 | 2022-03-10 | Henderson | Tennessee | 47077 | 9035 | 147 |
2293836 | 2293836 | 2022-03-10 | Henry | Tennessee | 47079 | 8221 | 148 |
2293837 | 2293837 | 2022-03-10 | Hickman | Tennessee | 47081 | 6808 | 104 |
2293838 | 2293838 | 2022-03-10 | Houston | Tennessee | 47083 | 2667 | 59 |
2293839 | 2293839 | 2022-03-10 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2293840 | 2293840 | 2022-03-10 | Jackson | Tennessee | 47087 | 3199 | 60 |
2293841 | 2293841 | 2022-03-10 | Jefferson | Tennessee | 47089 | 15650 | 255 |
2293842 | 2293842 | 2022-03-10 | Johnson | Tennessee | 47091 | 5131 | 87 |
2293843 | 2293843 | 2022-03-10 | Knox | Tennessee | 47093 | 127157 | 1298 |
2293844 | 2293844 | 2022-03-10 | Lake | Tennessee | 47095 | 2733 | 40 |
2293845 | 2293845 | 2022-03-10 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2293846 | 2293846 | 2022-03-10 | Lawrence | Tennessee | 47099 | 14241 | 187 |
2293847 | 2293847 | 2022-03-10 | Lewis | Tennessee | 47101 | 3567 | 50 |
2293848 | 2293848 | 2022-03-10 | Lincoln | Tennessee | 47103 | 9949 | 157 |
2293849 | 2293849 | 2022-03-10 | Loudon | Tennessee | 47105 | 14363 | 186 |
2293850 | 2293850 | 2022-03-10 | Macon | Tennessee | 47111 | 8405 | 138 |
2293851 | 2293851 | 2022-03-10 | Madison | Tennessee | 47113 | 29657 | 411 |
2293852 | 2293852 | 2022-03-10 | Marion | Tennessee | 47115 | 8810 | 124 |
2293853 | 2293853 | 2022-03-10 | Marshall | Tennessee | 47117 | 10334 | 116 |
2293854 | 2293854 | 2022-03-10 | Maury | Tennessee | 47119 | 28815 | 320 |
2293855 | 2293855 | 2022-03-10 | McMinn | Tennessee | 47107 | 16630 | 240 |
2293856 | 2293856 | 2022-03-10 | McNairy | Tennessee | 47109 | 7608 | 113 |
2293857 | 2293857 | 2022-03-10 | Meigs | Tennessee | 47121 | 3347 | 54 |
2293858 | 2293858 | 2022-03-10 | Monroe | Tennessee | 47123 | 14442 | 217 |
2293859 | 2293859 | 2022-03-10 | Montgomery | Tennessee | 47125 | 49919 | 550 |
2293860 | 2293860 | 2022-03-10 | Moore | Tennessee | 47127 | 2235 | 39 |
2293861 | 2293861 | 2022-03-10 | Morgan | Tennessee | 47129 | 6145 | 78 |
2293862 | 2293862 | 2022-03-10 | Obion | Tennessee | 47131 | 10742 | 179 |
2293863 | 2293863 | 2022-03-10 | Overton | Tennessee | 47133 | 7139 | 120 |
2293864 | 2293864 | 2022-03-10 | Perry | Tennessee | 47135 | 2327 | 48 |
2293865 | 2293865 | 2022-03-10 | Pickett | Tennessee | 47137 | 1763 | 31 |
2293866 | 2293866 | 2022-03-10 | Polk | Tennessee | 47139 | 4711 | 65 |
2293867 | 2293867 | 2022-03-10 | Putnam | Tennessee | 47141 | 25037 | 295 |
2293868 | 2293868 | 2022-03-10 | Rhea | Tennessee | 47143 | 9936 | 148 |
2293869 | 2293869 | 2022-03-10 | Roane | Tennessee | 47145 | 15712 | 225 |
2293870 | 2293870 | 2022-03-10 | Robertson | Tennessee | 47147 | 21471 | 290 |
2293871 | 2293871 | 2022-03-10 | Rutherford | Tennessee | 47149 | 95362 | 865 |
2293872 | 2293872 | 2022-03-10 | Scott | Tennessee | 47151 | 8987 | 111 |
2293873 | 2293873 | 2022-03-10 | Sequatchie | Tennessee | 47153 | 4194 | 66 |
2293874 | 2293874 | 2022-03-10 | Sevier | Tennessee | 47155 | 30156 | 393 |
2293875 | 2293875 | 2022-03-10 | Shelby | Tennessee | 47157 | 237162 | 3178 |
2293876 | 2293876 | 2022-03-10 | Smith | Tennessee | 47159 | 6154 | 76 |
2293877 | 2293877 | 2022-03-10 | Stewart | Tennessee | 47161 | 3280 | 52 |
2293878 | 2293878 | 2022-03-10 | Sullivan | Tennessee | 47163 | 45533 | 670 |
2293879 | 2293879 | 2022-03-10 | Sumner | Tennessee | 47165 | 52955 | 688 |
2293880 | 2293880 | 2022-03-10 | Tipton | Tennessee | 47167 | 17564 | 221 |
2293881 | 2293881 | 2022-03-10 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2293882 | 2293882 | 2022-03-10 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2293883 | 2293883 | 2022-03-10 | Union | Tennessee | 47173 | 5382 | 70 |
2293884 | 2293884 | 2022-03-10 | Unknown | Tennessee | 19362 | 325 | |
2293885 | 2293885 | 2022-03-10 | Van Buren | Tennessee | 47175 | 1845 | 46 |
2293886 | 2293886 | 2022-03-10 | Warren | Tennessee | 47177 | 12970 | 167 |
2293887 | 2293887 | 2022-03-10 | Washington | Tennessee | 47179 | 38342 | 471 |
2293888 | 2293888 | 2022-03-10 | Wayne | Tennessee | 47181 | 5672 | 60 |
2293889 | 2293889 | 2022-03-10 | Weakley | Tennessee | 47183 | 9474 | 138 |
2293890 | 2293890 | 2022-03-10 | White | Tennessee | 47185 | 8216 | 126 |
2293891 | 2293891 | 2022-03-10 | Williamson | Tennessee | 47187 | 61684 | 386 |
2293892 | 2293892 | 2022-03-10 | Wilson | Tennessee | 47189 | 41449 | 465 |
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);