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-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1052786 | 1052786 | 2021-02-21 | Anderson | Tennessee | 47001 | 7853 | 152 |
1052787 | 1052787 | 2021-02-21 | Bedford | Tennessee | 47003 | 5736 | 117 |
1052788 | 1052788 | 2021-02-21 | Benton | Tennessee | 47005 | 1499 | 39 |
1052789 | 1052789 | 2021-02-21 | Bledsoe | Tennessee | 47007 | 1980 | 10 |
1052790 | 1052790 | 2021-02-21 | Blount | Tennessee | 47009 | 13868 | 175 |
1052791 | 1052791 | 2021-02-21 | Bradley | Tennessee | 47011 | 12633 | 137 |
1052792 | 1052792 | 2021-02-21 | Campbell | Tennessee | 47013 | 3758 | 58 |
1052793 | 1052793 | 2021-02-21 | Cannon | Tennessee | 47015 | 1732 | 28 |
1052794 | 1052794 | 2021-02-21 | Carroll | Tennessee | 47017 | 3456 | 80 |
1052795 | 1052795 | 2021-02-21 | Carter | Tennessee | 47019 | 5904 | 150 |
1052796 | 1052796 | 2021-02-21 | Cheatham | Tennessee | 47021 | 3834 | 43 |
1052797 | 1052797 | 2021-02-21 | Chester | Tennessee | 47023 | 2003 | 46 |
1052798 | 1052798 | 2021-02-21 | Claiborne | Tennessee | 47025 | 2699 | 64 |
1052799 | 1052799 | 2021-02-21 | Clay | Tennessee | 47027 | 1056 | 30 |
1052800 | 1052800 | 2021-02-21 | Cocke | Tennessee | 47029 | 3948 | 91 |
1052801 | 1052801 | 2021-02-21 | Coffee | Tennessee | 47031 | 6227 | 114 |
1052802 | 1052802 | 2021-02-21 | Crockett | Tennessee | 47033 | 1965 | 46 |
1052803 | 1052803 | 2021-02-21 | Cumberland | Tennessee | 47035 | 6054 | 116 |
1052804 | 1052804 | 2021-02-21 | Davidson | Tennessee | 47037 | 88493 | 830 |
1052805 | 1052805 | 2021-02-21 | DeKalb | Tennessee | 47041 | 2609 | 47 |
1052806 | 1052806 | 2021-02-21 | Decatur | Tennessee | 47039 | 1531 | 35 |
1052807 | 1052807 | 2021-02-21 | Dickson | Tennessee | 47043 | 6096 | 102 |
1052808 | 1052808 | 2021-02-21 | Dyer | Tennessee | 47045 | 5216 | 99 |
1052809 | 1052809 | 2021-02-21 | Fayette | Tennessee | 47047 | 4630 | 71 |
1052810 | 1052810 | 2021-02-21 | Fentress | Tennessee | 47049 | 2280 | 43 |
1052811 | 1052811 | 2021-02-21 | Franklin | Tennessee | 47051 | 4679 | 80 |
1052812 | 1052812 | 2021-02-21 | Gibson | Tennessee | 47053 | 6151 | 139 |
1052813 | 1052813 | 2021-02-21 | Giles | Tennessee | 47055 | 3692 | 95 |
1052814 | 1052814 | 2021-02-21 | Grainger | Tennessee | 47057 | 2399 | 46 |
1052815 | 1052815 | 2021-02-21 | Greene | Tennessee | 47059 | 7244 | 143 |
1052816 | 1052816 | 2021-02-21 | Grundy | Tennessee | 47061 | 1651 | 29 |
1052817 | 1052817 | 2021-02-21 | Hamblen | Tennessee | 47063 | 7918 | 161 |
1052818 | 1052818 | 2021-02-21 | Hamilton | Tennessee | 47065 | 40036 | 445 |
1052819 | 1052819 | 2021-02-21 | Hancock | Tennessee | 47067 | 490 | 11 |
1052820 | 1052820 | 2021-02-21 | Hardeman | Tennessee | 47069 | 3371 | 63 |
1052821 | 1052821 | 2021-02-21 | Hardin | Tennessee | 47071 | 3289 | 62 |
1052822 | 1052822 | 2021-02-21 | Hawkins | Tennessee | 47073 | 5147 | 92 |
1052823 | 1052823 | 2021-02-21 | Haywood | Tennessee | 47075 | 2639 | 59 |
1052824 | 1052824 | 2021-02-21 | Henderson | Tennessee | 47077 | 3599 | 71 |
1052825 | 1052825 | 2021-02-21 | Henry | Tennessee | 47079 | 2978 | 73 |
1052826 | 1052826 | 2021-02-21 | Hickman | Tennessee | 47081 | 2618 | 39 |
1052827 | 1052827 | 2021-02-21 | Houston | Tennessee | 47083 | 1019 | 30 |
1052828 | 1052828 | 2021-02-21 | Humphreys | Tennessee | 47085 | 1507 | 21 |
1052829 | 1052829 | 2021-02-21 | Jackson | Tennessee | 47087 | 1245 | 33 |
1052830 | 1052830 | 2021-02-21 | Jefferson | Tennessee | 47089 | 5546 | 115 |
1052831 | 1052831 | 2021-02-21 | Johnson | Tennessee | 47091 | 2138 | 37 |
1052832 | 1052832 | 2021-02-21 | Knox | Tennessee | 47093 | 46126 | 561 |
1052833 | 1052833 | 2021-02-21 | Lake | Tennessee | 47095 | 1671 | 26 |
1052834 | 1052834 | 2021-02-21 | Lauderdale | Tennessee | 47097 | 3085 | 42 |
1052835 | 1052835 | 2021-02-21 | Lawrence | Tennessee | 47099 | 5531 | 80 |
1052836 | 1052836 | 2021-02-21 | Lewis | Tennessee | 47101 | 1443 | 24 |
1052837 | 1052837 | 2021-02-21 | Lincoln | Tennessee | 47103 | 4092 | 61 |
1052838 | 1052838 | 2021-02-21 | Loudon | Tennessee | 47105 | 5591 | 64 |
1052839 | 1052839 | 2021-02-21 | Macon | Tennessee | 47111 | 3326 | 73 |
1052840 | 1052840 | 2021-02-21 | Madison | Tennessee | 47113 | 9998 | 225 |
1052841 | 1052841 | 2021-02-21 | Marion | Tennessee | 47115 | 2876 | 44 |
1052842 | 1052842 | 2021-02-21 | Marshall | Tennessee | 47117 | 3871 | 54 |
1052843 | 1052843 | 2021-02-21 | Maury | Tennessee | 47119 | 12087 | 157 |
1052844 | 1052844 | 2021-02-21 | McMinn | Tennessee | 47107 | 5832 | 89 |
1052845 | 1052845 | 2021-02-21 | McNairy | Tennessee | 47109 | 2632 | 49 |
1052846 | 1052846 | 2021-02-21 | Meigs | Tennessee | 47121 | 1251 | 20 |
1052847 | 1052847 | 2021-02-21 | Monroe | Tennessee | 47123 | 5215 | 88 |
1052848 | 1052848 | 2021-02-21 | Montgomery | Tennessee | 47125 | 17132 | 205 |
1052849 | 1052849 | 2021-02-21 | Moore | Tennessee | 47127 | 934 | 15 |
1052850 | 1052850 | 2021-02-21 | Morgan | Tennessee | 47129 | 2280 | 36 |
1052851 | 1052851 | 2021-02-21 | Obion | Tennessee | 47131 | 4353 | 92 |
1052852 | 1052852 | 2021-02-21 | Overton | Tennessee | 47133 | 2828 | 57 |
1052853 | 1052853 | 2021-02-21 | Perry | Tennessee | 47135 | 1022 | 27 |
1052854 | 1052854 | 2021-02-21 | Pickett | Tennessee | 47137 | 743 | 23 |
1052855 | 1052855 | 2021-02-21 | Polk | Tennessee | 47139 | 1723 | 21 |
1052856 | 1052856 | 2021-02-21 | Putnam | Tennessee | 47141 | 10496 | 167 |
1052857 | 1052857 | 2021-02-21 | Rhea | Tennessee | 47143 | 4102 | 72 |
1052858 | 1052858 | 2021-02-21 | Roane | Tennessee | 47145 | 5774 | 95 |
1052859 | 1052859 | 2021-02-21 | Robertson | Tennessee | 47147 | 8837 | 114 |
1052860 | 1052860 | 2021-02-21 | Rutherford | Tennessee | 47149 | 37626 | 368 |
1052861 | 1052861 | 2021-02-21 | Scott | Tennessee | 47151 | 2846 | 40 |
1052862 | 1052862 | 2021-02-21 | Sequatchie | Tennessee | 47153 | 1531 | 27 |
1052863 | 1052863 | 2021-02-21 | Sevier | Tennessee | 47155 | 11829 | 159 |
1052864 | 1052864 | 2021-02-21 | Shelby | Tennessee | 47157 | 86978 | 1460 |
1052865 | 1052865 | 2021-02-21 | Smith | Tennessee | 47159 | 2516 | 36 |
1052866 | 1052866 | 2021-02-21 | Stewart | Tennessee | 47161 | 1228 | 24 |
1052867 | 1052867 | 2021-02-21 | Sullivan | Tennessee | 47163 | 14107 | 270 |
1052868 | 1052868 | 2021-02-21 | Sumner | Tennessee | 47165 | 21064 | 312 |
1052869 | 1052869 | 2021-02-21 | Tipton | Tennessee | 47167 | 6870 | 99 |
1052870 | 1052870 | 2021-02-21 | Trousdale | Tennessee | 47169 | 2376 | 21 |
1052871 | 1052871 | 2021-02-21 | Unicoi | Tennessee | 47171 | 1784 | 47 |
1052872 | 1052872 | 2021-02-21 | Union | Tennessee | 47173 | 1669 | 30 |
1052873 | 1052873 | 2021-02-21 | Unknown | Tennessee | 8407 | 114 | |
1052874 | 1052874 | 2021-02-21 | Van Buren | Tennessee | 47175 | 788 | 20 |
1052875 | 1052875 | 2021-02-21 | Warren | Tennessee | 47177 | 5284 | 73 |
1052876 | 1052876 | 2021-02-21 | Washington | Tennessee | 47179 | 12637 | 230 |
1052877 | 1052877 | 2021-02-21 | Wayne | Tennessee | 47181 | 2861 | 30 |
1052878 | 1052878 | 2021-02-21 | Weakley | Tennessee | 47183 | 3768 | 59 |
1052879 | 1052879 | 2021-02-21 | White | Tennessee | 47185 | 3315 | 65 |
1052880 | 1052880 | 2021-02-21 | Williamson | Tennessee | 47187 | 24822 | 202 |
1052881 | 1052881 | 2021-02-21 | Wilson | Tennessee | 47189 | 16090 | 206 |
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);