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 2022-03-06 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2280789 | 2280789 | 2022-03-06 | Anderson | Tennessee | 47001 | 21877 | 309 |
2280790 | 2280790 | 2022-03-06 | Bedford | Tennessee | 47003 | 14871 | 220 |
2280791 | 2280791 | 2022-03-06 | Benton | Tennessee | 47005 | 4439 | 90 |
2280792 | 2280792 | 2022-03-06 | Bledsoe | Tennessee | 47007 | 4636 | 53 |
2280793 | 2280793 | 2022-03-06 | Blount | Tennessee | 47009 | 38827 | 396 |
2280794 | 2280794 | 2022-03-06 | Bradley | Tennessee | 47011 | 32944 | 383 |
2280795 | 2280795 | 2022-03-06 | Campbell | Tennessee | 47013 | 11917 | 150 |
2280796 | 2280796 | 2022-03-06 | Cannon | Tennessee | 47015 | 4152 | 56 |
2280797 | 2280797 | 2022-03-06 | Carroll | Tennessee | 47017 | 8871 | 147 |
2280798 | 2280798 | 2022-03-06 | Carter | Tennessee | 47019 | 16302 | 311 |
2280799 | 2280799 | 2022-03-06 | Cheatham | Tennessee | 47021 | 10856 | 115 |
2280800 | 2280800 | 2022-03-06 | Chester | Tennessee | 47023 | 5723 | 92 |
2280801 | 2280801 | 2022-03-06 | Claiborne | Tennessee | 47025 | 8958 | 168 |
2280802 | 2280802 | 2022-03-06 | Clay | Tennessee | 47027 | 2216 | 46 |
2280803 | 2280803 | 2022-03-06 | Cocke | Tennessee | 47029 | 11288 | 201 |
2280804 | 2280804 | 2022-03-06 | Coffee | Tennessee | 47031 | 16852 | 239 |
2280805 | 2280805 | 2022-03-06 | Crockett | Tennessee | 47033 | 5098 | 82 |
2280806 | 2280806 | 2022-03-06 | Cumberland | Tennessee | 47035 | 16001 | 309 |
2280807 | 2280807 | 2022-03-06 | Davidson | Tennessee | 47037 | 205987 | 1584 |
2280808 | 2280808 | 2022-03-06 | DeKalb | Tennessee | 47041 | 6246 | 96 |
2280809 | 2280809 | 2022-03-06 | Decatur | Tennessee | 47039 | 3671 | 63 |
2280810 | 2280810 | 2022-03-06 | Dickson | Tennessee | 47043 | 15798 | 234 |
2280811 | 2280811 | 2022-03-06 | Dyer | Tennessee | 47045 | 12642 | 191 |
2280812 | 2280812 | 2022-03-06 | Fayette | Tennessee | 47047 | 11361 | 168 |
2280813 | 2280813 | 2022-03-06 | Fentress | Tennessee | 47049 | 5668 | 115 |
2280814 | 2280814 | 2022-03-06 | Franklin | Tennessee | 47051 | 12770 | 165 |
2280815 | 2280815 | 2022-03-06 | Gibson | Tennessee | 47053 | 17187 | 250 |
2280816 | 2280816 | 2022-03-06 | Giles | Tennessee | 47055 | 9374 | 172 |
2280817 | 2280817 | 2022-03-06 | Grainger | Tennessee | 47057 | 6735 | 103 |
2280818 | 2280818 | 2022-03-06 | Greene | Tennessee | 47059 | 21883 | 350 |
2280819 | 2280819 | 2022-03-06 | Grundy | Tennessee | 47061 | 3960 | 69 |
2280820 | 2280820 | 2022-03-06 | Hamblen | Tennessee | 47063 | 19588 | 345 |
2280821 | 2280821 | 2022-03-06 | Hamilton | Tennessee | 47065 | 98468 | 1078 |
2280822 | 2280822 | 2022-03-06 | Hancock | Tennessee | 47067 | 1985 | 31 |
2280823 | 2280823 | 2022-03-06 | Hardeman | Tennessee | 47069 | 7463 | 115 |
2280824 | 2280824 | 2022-03-06 | Hardin | Tennessee | 47071 | 8629 | 135 |
2280825 | 2280825 | 2022-03-06 | Hawkins | Tennessee | 47073 | 16480 | 286 |
2280826 | 2280826 | 2022-03-06 | Haywood | Tennessee | 47075 | 6107 | 97 |
2280827 | 2280827 | 2022-03-06 | Henderson | Tennessee | 47077 | 8944 | 145 |
2280828 | 2280828 | 2022-03-06 | Henry | Tennessee | 47079 | 8160 | 147 |
2280829 | 2280829 | 2022-03-06 | Hickman | Tennessee | 47081 | 6789 | 103 |
2280830 | 2280830 | 2022-03-06 | Houston | Tennessee | 47083 | 2663 | 59 |
2280831 | 2280831 | 2022-03-06 | Humphreys | Tennessee | 47085 | 4817 | 68 |
2280832 | 2280832 | 2022-03-06 | Jackson | Tennessee | 47087 | 3189 | 59 |
2280833 | 2280833 | 2022-03-06 | Jefferson | Tennessee | 47089 | 15585 | 254 |
2280834 | 2280834 | 2022-03-06 | Johnson | Tennessee | 47091 | 5096 | 85 |
2280835 | 2280835 | 2022-03-06 | Knox | Tennessee | 47093 | 126763 | 1277 |
2280836 | 2280836 | 2022-03-06 | Lake | Tennessee | 47095 | 2705 | 40 |
2280837 | 2280837 | 2022-03-06 | Lauderdale | Tennessee | 47097 | 7692 | 99 |
2280838 | 2280838 | 2022-03-06 | Lawrence | Tennessee | 47099 | 14209 | 185 |
2280839 | 2280839 | 2022-03-06 | Lewis | Tennessee | 47101 | 3565 | 50 |
2280840 | 2280840 | 2022-03-06 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2280841 | 2280841 | 2022-03-06 | Loudon | Tennessee | 47105 | 14319 | 185 |
2280842 | 2280842 | 2022-03-06 | Macon | Tennessee | 47111 | 8380 | 139 |
2280843 | 2280843 | 2022-03-06 | Madison | Tennessee | 47113 | 29429 | 403 |
2280844 | 2280844 | 2022-03-06 | Marion | Tennessee | 47115 | 8786 | 123 |
2280845 | 2280845 | 2022-03-06 | Marshall | Tennessee | 47117 | 10312 | 116 |
2280846 | 2280846 | 2022-03-06 | Maury | Tennessee | 47119 | 28772 | 315 |
2280847 | 2280847 | 2022-03-06 | McMinn | Tennessee | 47107 | 16604 | 236 |
2280848 | 2280848 | 2022-03-06 | McNairy | Tennessee | 47109 | 7559 | 113 |
2280849 | 2280849 | 2022-03-06 | Meigs | Tennessee | 47121 | 3345 | 54 |
2280850 | 2280850 | 2022-03-06 | Monroe | Tennessee | 47123 | 14400 | 217 |
2280851 | 2280851 | 2022-03-06 | Montgomery | Tennessee | 47125 | 49805 | 546 |
2280852 | 2280852 | 2022-03-06 | Moore | Tennessee | 47127 | 2225 | 37 |
2280853 | 2280853 | 2022-03-06 | Morgan | Tennessee | 47129 | 6102 | 77 |
2280854 | 2280854 | 2022-03-06 | Obion | Tennessee | 47131 | 10724 | 179 |
2280855 | 2280855 | 2022-03-06 | Overton | Tennessee | 47133 | 7124 | 118 |
2280856 | 2280856 | 2022-03-06 | Perry | Tennessee | 47135 | 2315 | 48 |
2280857 | 2280857 | 2022-03-06 | Pickett | Tennessee | 47137 | 1761 | 30 |
2280858 | 2280858 | 2022-03-06 | Polk | Tennessee | 47139 | 4670 | 65 |
2280859 | 2280859 | 2022-03-06 | Putnam | Tennessee | 47141 | 24976 | 291 |
2280860 | 2280860 | 2022-03-06 | Rhea | Tennessee | 47143 | 9920 | 148 |
2280861 | 2280861 | 2022-03-06 | Roane | Tennessee | 47145 | 15681 | 221 |
2280862 | 2280862 | 2022-03-06 | Robertson | Tennessee | 47147 | 21427 | 288 |
2280863 | 2280863 | 2022-03-06 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2280864 | 2280864 | 2022-03-06 | Scott | Tennessee | 47151 | 8917 | 108 |
2280865 | 2280865 | 2022-03-06 | Sequatchie | Tennessee | 47153 | 4183 | 66 |
2280866 | 2280866 | 2022-03-06 | Sevier | Tennessee | 47155 | 30075 | 389 |
2280867 | 2280867 | 2022-03-06 | Shelby | Tennessee | 47157 | 236989 | 3159 |
2280868 | 2280868 | 2022-03-06 | Smith | Tennessee | 47159 | 6149 | 74 |
2280869 | 2280869 | 2022-03-06 | Stewart | Tennessee | 47161 | 3268 | 52 |
2280870 | 2280870 | 2022-03-06 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2280871 | 2280871 | 2022-03-06 | Sumner | Tennessee | 47165 | 52831 | 688 |
2280872 | 2280872 | 2022-03-06 | Tipton | Tennessee | 47167 | 17535 | 219 |
2280873 | 2280873 | 2022-03-06 | Trousdale | Tennessee | 47169 | 4200 | 45 |
2280874 | 2280874 | 2022-03-06 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2280875 | 2280875 | 2022-03-06 | Union | Tennessee | 47173 | 5373 | 69 |
2280876 | 2280876 | 2022-03-06 | Unknown | Tennessee | 22634 | 422 | |
2280877 | 2280877 | 2022-03-06 | Van Buren | Tennessee | 47175 | 1840 | 46 |
2280878 | 2280878 | 2022-03-06 | Warren | Tennessee | 47177 | 12936 | 167 |
2280879 | 2280879 | 2022-03-06 | Washington | Tennessee | 47179 | 38226 | 467 |
2280880 | 2280880 | 2022-03-06 | Wayne | Tennessee | 47181 | 5644 | 56 |
2280881 | 2280881 | 2022-03-06 | Weakley | Tennessee | 47183 | 9440 | 134 |
2280882 | 2280882 | 2022-03-06 | White | Tennessee | 47185 | 8182 | 126 |
2280883 | 2280883 | 2022-03-06 | Williamson | Tennessee | 47187 | 61546 | 382 |
2280884 | 2280884 | 2022-03-06 | Wilson | Tennessee | 47189 | 41368 | 464 |
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);