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-05-13 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1315781 | 1315781 | 2021-05-13 | Anderson | Tennessee | 47001 | 8792 | 171 |
1315782 | 1315782 | 2021-05-13 | Bedford | Tennessee | 47003 | 6521 | 128 |
1315783 | 1315783 | 2021-05-13 | Benton | Tennessee | 47005 | 1670 | 40 |
1315784 | 1315784 | 2021-05-13 | Bledsoe | Tennessee | 47007 | 2156 | 11 |
1315785 | 1315785 | 2021-05-13 | Blount | Tennessee | 47009 | 15551 | 196 |
1315786 | 1315786 | 2021-05-13 | Bradley | Tennessee | 47011 | 15096 | 151 |
1315787 | 1315787 | 2021-05-13 | Campbell | Tennessee | 47013 | 4175 | 63 |
1315788 | 1315788 | 2021-05-13 | Cannon | Tennessee | 47015 | 1926 | 31 |
1315789 | 1315789 | 2021-05-13 | Carroll | Tennessee | 47017 | 3632 | 83 |
1315790 | 1315790 | 2021-05-13 | Carter | Tennessee | 47019 | 6660 | 158 |
1315791 | 1315791 | 2021-05-13 | Cheatham | Tennessee | 47021 | 4573 | 56 |
1315792 | 1315792 | 2021-05-13 | Chester | Tennessee | 47023 | 2154 | 51 |
1315793 | 1315793 | 2021-05-13 | Claiborne | Tennessee | 47025 | 3189 | 73 |
1315794 | 1315794 | 2021-05-13 | Clay | Tennessee | 47027 | 1103 | 30 |
1315795 | 1315795 | 2021-05-13 | Cocke | Tennessee | 47029 | 4522 | 99 |
1315796 | 1315796 | 2021-05-13 | Coffee | Tennessee | 47031 | 6922 | 122 |
1315797 | 1315797 | 2021-05-13 | Crockett | Tennessee | 47033 | 2035 | 49 |
1315798 | 1315798 | 2021-05-13 | Cumberland | Tennessee | 47035 | 6762 | 133 |
1315799 | 1315799 | 2021-05-13 | Davidson | Tennessee | 47037 | 98732 | 941 |
1315800 | 1315800 | 2021-05-13 | DeKalb | Tennessee | 47041 | 2806 | 54 |
1315801 | 1315801 | 2021-05-13 | Decatur | Tennessee | 47039 | 1592 | 39 |
1315802 | 1315802 | 2021-05-13 | Dickson | Tennessee | 47043 | 6850 | 113 |
1315803 | 1315803 | 2021-05-13 | Dyer | Tennessee | 47045 | 5440 | 106 |
1315804 | 1315804 | 2021-05-13 | Fayette | Tennessee | 47047 | 5116 | 77 |
1315805 | 1315805 | 2021-05-13 | Fentress | Tennessee | 47049 | 2426 | 47 |
1315806 | 1315806 | 2021-05-13 | Franklin | Tennessee | 47051 | 5163 | 90 |
1315807 | 1315807 | 2021-05-13 | Gibson | Tennessee | 47053 | 6535 | 146 |
1315808 | 1315808 | 2021-05-13 | Giles | Tennessee | 47055 | 4009 | 100 |
1315809 | 1315809 | 2021-05-13 | Grainger | Tennessee | 47057 | 2635 | 50 |
1315810 | 1315810 | 2021-05-13 | Greene | Tennessee | 47059 | 7924 | 156 |
1315811 | 1315811 | 2021-05-13 | Grundy | Tennessee | 47061 | 1795 | 34 |
1315812 | 1315812 | 2021-05-13 | Hamblen | Tennessee | 47063 | 8631 | 173 |
1315813 | 1315813 | 2021-05-13 | Hamilton | Tennessee | 47065 | 44708 | 496 |
1315814 | 1315814 | 2021-05-13 | Hancock | Tennessee | 47067 | 593 | 12 |
1315815 | 1315815 | 2021-05-13 | Hardeman | Tennessee | 47069 | 3528 | 64 |
1315816 | 1315816 | 2021-05-13 | Hardin | Tennessee | 47071 | 3588 | 68 |
1315817 | 1315817 | 2021-05-13 | Hawkins | Tennessee | 47073 | 6155 | 107 |
1315818 | 1315818 | 2021-05-13 | Haywood | Tennessee | 47075 | 2715 | 62 |
1315819 | 1315819 | 2021-05-13 | Henderson | Tennessee | 47077 | 3802 | 76 |
1315820 | 1315820 | 2021-05-13 | Henry | Tennessee | 47079 | 3202 | 76 |
1315821 | 1315821 | 2021-05-13 | Hickman | Tennessee | 47081 | 2847 | 46 |
1315822 | 1315822 | 2021-05-13 | Houston | Tennessee | 47083 | 1097 | 33 |
1315823 | 1315823 | 2021-05-13 | Humphreys | Tennessee | 47085 | 1811 | 28 |
1315824 | 1315824 | 2021-05-13 | Jackson | Tennessee | 47087 | 1323 | 36 |
1315825 | 1315825 | 2021-05-13 | Jefferson | Tennessee | 47089 | 6242 | 125 |
1315826 | 1315826 | 2021-05-13 | Johnson | Tennessee | 47091 | 2417 | 39 |
1315827 | 1315827 | 2021-05-13 | Knox | Tennessee | 47093 | 52019 | 636 |
1315828 | 1315828 | 2021-05-13 | Lake | Tennessee | 47095 | 1706 | 26 |
1315829 | 1315829 | 2021-05-13 | Lauderdale | Tennessee | 47097 | 3202 | 44 |
1315830 | 1315830 | 2021-05-13 | Lawrence | Tennessee | 47099 | 5981 | 89 |
1315831 | 1315831 | 2021-05-13 | Lewis | Tennessee | 47101 | 1583 | 26 |
1315832 | 1315832 | 2021-05-13 | Lincoln | Tennessee | 47103 | 4367 | 63 |
1315833 | 1315833 | 2021-05-13 | Loudon | Tennessee | 47105 | 6158 | 69 |
1315834 | 1315834 | 2021-05-13 | Macon | Tennessee | 47111 | 3630 | 78 |
1315835 | 1315835 | 2021-05-13 | Madison | Tennessee | 47113 | 11245 | 241 |
1315836 | 1315836 | 2021-05-13 | Marion | Tennessee | 47115 | 3128 | 47 |
1315837 | 1315837 | 2021-05-13 | Marshall | Tennessee | 47117 | 4202 | 58 |
1315838 | 1315838 | 2021-05-13 | Maury | Tennessee | 47119 | 13535 | 172 |
1315839 | 1315839 | 2021-05-13 | McMinn | Tennessee | 47107 | 6534 | 98 |
1315840 | 1315840 | 2021-05-13 | McNairy | Tennessee | 47109 | 2840 | 54 |
1315841 | 1315841 | 2021-05-13 | Meigs | Tennessee | 47121 | 1390 | 25 |
1315842 | 1315842 | 2021-05-13 | Monroe | Tennessee | 47123 | 5870 | 96 |
1315843 | 1315843 | 2021-05-13 | Montgomery | Tennessee | 47125 | 20392 | 227 |
1315844 | 1315844 | 2021-05-13 | Moore | Tennessee | 47127 | 1014 | 17 |
1315845 | 1315845 | 2021-05-13 | Morgan | Tennessee | 47129 | 2512 | 39 |
1315846 | 1315846 | 2021-05-13 | Obion | Tennessee | 47131 | 4548 | 96 |
1315847 | 1315847 | 2021-05-13 | Overton | Tennessee | 47133 | 3024 | 61 |
1315848 | 1315848 | 2021-05-13 | Perry | Tennessee | 47135 | 1071 | 28 |
1315849 | 1315849 | 2021-05-13 | Pickett | Tennessee | 47137 | 759 | 24 |
1315850 | 1315850 | 2021-05-13 | Polk | Tennessee | 47139 | 2085 | 24 |
1315851 | 1315851 | 2021-05-13 | Putnam | Tennessee | 47141 | 11435 | 175 |
1315852 | 1315852 | 2021-05-13 | Rhea | Tennessee | 47143 | 4357 | 75 |
1315853 | 1315853 | 2021-05-13 | Roane | Tennessee | 47145 | 6317 | 105 |
1315854 | 1315854 | 2021-05-13 | Robertson | Tennessee | 47147 | 9785 | 132 |
1315855 | 1315855 | 2021-05-13 | Rutherford | Tennessee | 47149 | 43174 | 437 |
1315856 | 1315856 | 2021-05-13 | Scott | Tennessee | 47151 | 3149 | 45 |
1315857 | 1315857 | 2021-05-13 | Sequatchie | Tennessee | 47153 | 1716 | 29 |
1315858 | 1315858 | 2021-05-13 | Sevier | Tennessee | 47155 | 13441 | 175 |
1315859 | 1315859 | 2021-05-13 | Shelby | Tennessee | 47157 | 97095 | 1635 |
1315860 | 1315860 | 2021-05-13 | Smith | Tennessee | 47159 | 2787 | 39 |
1315861 | 1315861 | 2021-05-13 | Stewart | Tennessee | 47161 | 1328 | 28 |
1315862 | 1315862 | 2021-05-13 | Sullivan | Tennessee | 47163 | 16916 | 298 |
1315863 | 1315863 | 2021-05-13 | Sumner | Tennessee | 47165 | 24122 | 349 |
1315864 | 1315864 | 2021-05-13 | Tipton | Tennessee | 47167 | 7388 | 104 |
1315865 | 1315865 | 2021-05-13 | Trousdale | Tennessee | 47169 | 2505 | 22 |
1315866 | 1315866 | 2021-05-13 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1315867 | 1315867 | 2021-05-13 | Union | Tennessee | 47173 | 1916 | 34 |
1315868 | 1315868 | 2021-05-13 | Unknown | Tennessee | 9412 | 127 | |
1315869 | 1315869 | 2021-05-13 | Van Buren | Tennessee | 47175 | 853 | 23 |
1315870 | 1315870 | 2021-05-13 | Warren | Tennessee | 47177 | 5550 | 81 |
1315871 | 1315871 | 2021-05-13 | Washington | Tennessee | 47179 | 14681 | 245 |
1315872 | 1315872 | 2021-05-13 | Wayne | Tennessee | 47181 | 2968 | 34 |
1315873 | 1315873 | 2021-05-13 | Weakley | Tennessee | 47183 | 4156 | 65 |
1315874 | 1315874 | 2021-05-13 | White | Tennessee | 47185 | 3677 | 70 |
1315875 | 1315875 | 2021-05-13 | Williamson | Tennessee | 47187 | 28104 | 217 |
1315876 | 1315876 | 2021-05-13 | Wilson | Tennessee | 47189 | 18902 | 236 |
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);