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-07-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 |
---|---|---|---|---|---|---|---|
1513788 | 1513788 | 2021-07-13 | Anderson | Tennessee | 47001 | 8833 | 176 |
1513789 | 1513789 | 2021-07-13 | Bedford | Tennessee | 47003 | 6733 | 132 |
1513790 | 1513790 | 2021-07-13 | Benton | Tennessee | 47005 | 1691 | 41 |
1513791 | 1513791 | 2021-07-13 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1513792 | 1513792 | 2021-07-13 | Blount | Tennessee | 47009 | 16002 | 200 |
1513793 | 1513793 | 2021-07-13 | Bradley | Tennessee | 47011 | 15358 | 155 |
1513794 | 1513794 | 2021-07-13 | Campbell | Tennessee | 47013 | 4218 | 62 |
1513795 | 1513795 | 2021-07-13 | Cannon | Tennessee | 47015 | 1952 | 32 |
1513796 | 1513796 | 2021-07-13 | Carroll | Tennessee | 47017 | 3724 | 83 |
1513797 | 1513797 | 2021-07-13 | Carter | Tennessee | 47019 | 6794 | 161 |
1513798 | 1513798 | 2021-07-13 | Cheatham | Tennessee | 47021 | 4685 | 56 |
1513799 | 1513799 | 2021-07-13 | Chester | Tennessee | 47023 | 2212 | 51 |
1513800 | 1513800 | 2021-07-13 | Claiborne | Tennessee | 47025 | 3250 | 74 |
1513801 | 1513801 | 2021-07-13 | Clay | Tennessee | 47027 | 1122 | 30 |
1513802 | 1513802 | 2021-07-13 | Cocke | Tennessee | 47029 | 4558 | 101 |
1513803 | 1513803 | 2021-07-13 | Coffee | Tennessee | 47031 | 7000 | 123 |
1513804 | 1513804 | 2021-07-13 | Crockett | Tennessee | 47033 | 2066 | 50 |
1513805 | 1513805 | 2021-07-13 | Cumberland | Tennessee | 47035 | 6908 | 141 |
1513806 | 1513806 | 2021-07-13 | Davidson | Tennessee | 47037 | 99657 | 953 |
1513807 | 1513807 | 2021-07-13 | DeKalb | Tennessee | 47041 | 2875 | 56 |
1513808 | 1513808 | 2021-07-13 | Decatur | Tennessee | 47039 | 1630 | 39 |
1513809 | 1513809 | 2021-07-13 | Dickson | Tennessee | 47043 | 7125 | 115 |
1513810 | 1513810 | 2021-07-13 | Dyer | Tennessee | 47045 | 5540 | 108 |
1513811 | 1513811 | 2021-07-13 | Fayette | Tennessee | 47047 | 5259 | 83 |
1513812 | 1513812 | 2021-07-13 | Fentress | Tennessee | 47049 | 2526 | 49 |
1513813 | 1513813 | 2021-07-13 | Franklin | Tennessee | 47051 | 5273 | 92 |
1513814 | 1513814 | 2021-07-13 | Gibson | Tennessee | 47053 | 6716 | 150 |
1513815 | 1513815 | 2021-07-13 | Giles | Tennessee | 47055 | 4061 | 100 |
1513816 | 1513816 | 2021-07-13 | Grainger | Tennessee | 47057 | 2687 | 50 |
1513817 | 1513817 | 2021-07-13 | Greene | Tennessee | 47059 | 8063 | 159 |
1513818 | 1513818 | 2021-07-13 | Grundy | Tennessee | 47061 | 1809 | 35 |
1513819 | 1513819 | 2021-07-13 | Hamblen | Tennessee | 47063 | 8717 | 175 |
1513820 | 1513820 | 2021-07-13 | Hamilton | Tennessee | 47065 | 45840 | 510 |
1513821 | 1513821 | 2021-07-13 | Hancock | Tennessee | 47067 | 621 | 13 |
1513822 | 1513822 | 2021-07-13 | Hardeman | Tennessee | 47069 | 3551 | 64 |
1513823 | 1513823 | 2021-07-13 | Hardin | Tennessee | 47071 | 3621 | 69 |
1513824 | 1513824 | 2021-07-13 | Hawkins | Tennessee | 47073 | 6368 | 114 |
1513825 | 1513825 | 2021-07-13 | Haywood | Tennessee | 47075 | 2723 | 62 |
1513826 | 1513826 | 2021-07-13 | Henderson | Tennessee | 47077 | 3871 | 79 |
1513827 | 1513827 | 2021-07-13 | Henry | Tennessee | 47079 | 3441 | 76 |
1513828 | 1513828 | 2021-07-13 | Hickman | Tennessee | 47081 | 2899 | 47 |
1513829 | 1513829 | 2021-07-13 | Houston | Tennessee | 47083 | 1122 | 34 |
1513830 | 1513830 | 2021-07-13 | Humphreys | Tennessee | 47085 | 1957 | 32 |
1513831 | 1513831 | 2021-07-13 | Jackson | Tennessee | 47087 | 1369 | 37 |
1513832 | 1513832 | 2021-07-13 | Jefferson | Tennessee | 47089 | 6359 | 126 |
1513833 | 1513833 | 2021-07-13 | Johnson | Tennessee | 47091 | 2455 | 39 |
1513834 | 1513834 | 2021-07-13 | Knox | Tennessee | 47093 | 52308 | 648 |
1513835 | 1513835 | 2021-07-13 | Lake | Tennessee | 47095 | 1728 | 30 |
1513836 | 1513836 | 2021-07-13 | Lauderdale | Tennessee | 47097 | 3271 | 50 |
1513837 | 1513837 | 2021-07-13 | Lawrence | Tennessee | 47099 | 6113 | 95 |
1513838 | 1513838 | 2021-07-13 | Lewis | Tennessee | 47101 | 1630 | 26 |
1513839 | 1513839 | 2021-07-13 | Lincoln | Tennessee | 47103 | 4419 | 67 |
1513840 | 1513840 | 2021-07-13 | Loudon | Tennessee | 47105 | 6253 | 71 |
1513841 | 1513841 | 2021-07-13 | Macon | Tennessee | 47111 | 3674 | 78 |
1513842 | 1513842 | 2021-07-13 | Madison | Tennessee | 47113 | 11634 | 245 |
1513843 | 1513843 | 2021-07-13 | Marion | Tennessee | 47115 | 3281 | 49 |
1513844 | 1513844 | 2021-07-13 | Marshall | Tennessee | 47117 | 4373 | 63 |
1513845 | 1513845 | 2021-07-13 | Maury | Tennessee | 47119 | 13800 | 178 |
1513846 | 1513846 | 2021-07-13 | McMinn | Tennessee | 47107 | 6684 | 104 |
1513847 | 1513847 | 2021-07-13 | McNairy | Tennessee | 47109 | 2889 | 56 |
1513848 | 1513848 | 2021-07-13 | Meigs | Tennessee | 47121 | 1432 | 24 |
1513849 | 1513849 | 2021-07-13 | Monroe | Tennessee | 47123 | 6001 | 97 |
1513850 | 1513850 | 2021-07-13 | Montgomery | Tennessee | 47125 | 21168 | 235 |
1513851 | 1513851 | 2021-07-13 | Moore | Tennessee | 47127 | 1033 | 17 |
1513852 | 1513852 | 2021-07-13 | Morgan | Tennessee | 47129 | 2565 | 37 |
1513853 | 1513853 | 2021-07-13 | Obion | Tennessee | 47131 | 4630 | 97 |
1513854 | 1513854 | 2021-07-13 | Overton | Tennessee | 47133 | 3093 | 62 |
1513855 | 1513855 | 2021-07-13 | Perry | Tennessee | 47135 | 1076 | 29 |
1513856 | 1513856 | 2021-07-13 | Pickett | Tennessee | 47137 | 775 | 24 |
1513857 | 1513857 | 2021-07-13 | Polk | Tennessee | 47139 | 2117 | 24 |
1513858 | 1513858 | 2021-07-13 | Putnam | Tennessee | 47141 | 11847 | 180 |
1513859 | 1513859 | 2021-07-13 | Rhea | Tennessee | 47143 | 4395 | 82 |
1513860 | 1513860 | 2021-07-13 | Roane | Tennessee | 47145 | 6388 | 109 |
1513861 | 1513861 | 2021-07-13 | Robertson | Tennessee | 47147 | 10025 | 141 |
1513862 | 1513862 | 2021-07-13 | Rutherford | Tennessee | 47149 | 43867 | 451 |
1513863 | 1513863 | 2021-07-13 | Scott | Tennessee | 47151 | 3228 | 48 |
1513864 | 1513864 | 2021-07-13 | Sequatchie | Tennessee | 47153 | 1769 | 29 |
1513865 | 1513865 | 2021-07-13 | Sevier | Tennessee | 47155 | 13670 | 179 |
1513866 | 1513866 | 2021-07-13 | Shelby | Tennessee | 47157 | 101101 | 1704 |
1513867 | 1513867 | 2021-07-13 | Smith | Tennessee | 47159 | 2813 | 40 |
1513868 | 1513868 | 2021-07-13 | Stewart | Tennessee | 47161 | 1385 | 28 |
1513869 | 1513869 | 2021-07-13 | Sullivan | Tennessee | 47163 | 17415 | 313 |
1513870 | 1513870 | 2021-07-13 | Sumner | Tennessee | 47165 | 24771 | 358 |
1513871 | 1513871 | 2021-07-13 | Tipton | Tennessee | 47167 | 7527 | 104 |
1513872 | 1513872 | 2021-07-13 | Trousdale | Tennessee | 47169 | 2538 | 21 |
1513873 | 1513873 | 2021-07-13 | Unicoi | Tennessee | 47171 | 2076 | 50 |
1513874 | 1513874 | 2021-07-13 | Union | Tennessee | 47173 | 1963 | 34 |
1513875 | 1513875 | 2021-07-13 | Unknown | Tennessee | 7596 | 94 | |
1513876 | 1513876 | 2021-07-13 | Van Buren | Tennessee | 47175 | 872 | 23 |
1513877 | 1513877 | 2021-07-13 | Warren | Tennessee | 47177 | 5610 | 84 |
1513878 | 1513878 | 2021-07-13 | Washington | Tennessee | 47179 | 14903 | 254 |
1513879 | 1513879 | 2021-07-13 | Wayne | Tennessee | 47181 | 3014 | 36 |
1513880 | 1513880 | 2021-07-13 | Weakley | Tennessee | 47183 | 4251 | 69 |
1513881 | 1513881 | 2021-07-13 | White | Tennessee | 47185 | 3793 | 74 |
1513882 | 1513882 | 2021-07-13 | Williamson | Tennessee | 47187 | 28781 | 219 |
1513883 | 1513883 | 2021-07-13 | Wilson | Tennessee | 47189 | 19477 | 251 |
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);