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 2020-12-26 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
867793 | 867793 | 2020-12-26 | Anderson | Tennessee | 47001 | 5373 | 55 |
867794 | 867794 | 2020-12-26 | Bedford | Tennessee | 47003 | 4407 | 57 |
867795 | 867795 | 2020-12-26 | Benton | Tennessee | 47005 | 1146 | 28 |
867796 | 867796 | 2020-12-26 | Bledsoe | Tennessee | 47007 | 1530 | 9 |
867797 | 867797 | 2020-12-26 | Blount | Tennessee | 47009 | 9266 | 93 |
867798 | 867798 | 2020-12-26 | Bradley | Tennessee | 47011 | 8647 | 64 |
867799 | 867799 | 2020-12-26 | Campbell | Tennessee | 47013 | 2579 | 34 |
867800 | 867800 | 2020-12-26 | Cannon | Tennessee | 47015 | 1318 | 10 |
867801 | 867801 | 2020-12-26 | Carroll | Tennessee | 47017 | 2587 | 48 |
867802 | 867802 | 2020-12-26 | Carter | Tennessee | 47019 | 4253 | 79 |
867803 | 867803 | 2020-12-26 | Cheatham | Tennessee | 47021 | 2721 | 22 |
867804 | 867804 | 2020-12-26 | Chester | Tennessee | 47023 | 1431 | 28 |
867805 | 867805 | 2020-12-26 | Claiborne | Tennessee | 47025 | 1555 | 18 |
867806 | 867806 | 2020-12-26 | Clay | Tennessee | 47027 | 823 | 23 |
867807 | 867807 | 2020-12-26 | Cocke | Tennessee | 47029 | 2674 | 39 |
867808 | 867808 | 2020-12-26 | Coffee | Tennessee | 47031 | 4717 | 64 |
867809 | 867809 | 2020-12-26 | Crockett | Tennessee | 47033 | 1568 | 30 |
867810 | 867810 | 2020-12-26 | Cumberland | Tennessee | 47035 | 4196 | 48 |
867811 | 867811 | 2020-12-26 | Davidson | Tennessee | 47037 | 66217 | 538 |
867812 | 867812 | 2020-12-26 | DeKalb | Tennessee | 47041 | 2009 | 30 |
867813 | 867813 | 2020-12-26 | Decatur | Tennessee | 47039 | 1308 | 17 |
867814 | 867814 | 2020-12-26 | Dickson | Tennessee | 47043 | 4464 | 57 |
867815 | 867815 | 2020-12-26 | Dyer | Tennessee | 47045 | 4089 | 67 |
867816 | 867816 | 2020-12-26 | Fayette | Tennessee | 47047 | 3203 | 45 |
867817 | 867817 | 2020-12-26 | Fentress | Tennessee | 47049 | 1836 | 27 |
867818 | 867818 | 2020-12-26 | Franklin | Tennessee | 47051 | 3362 | 46 |
867819 | 867819 | 2020-12-26 | Gibson | Tennessee | 47053 | 4801 | 87 |
867820 | 867820 | 2020-12-26 | Giles | Tennessee | 47055 | 2517 | 60 |
867821 | 867821 | 2020-12-26 | Grainger | Tennessee | 47057 | 1721 | 23 |
867822 | 867822 | 2020-12-26 | Greene | Tennessee | 47059 | 5259 | 88 |
867823 | 867823 | 2020-12-26 | Grundy | Tennessee | 47061 | 1153 | 15 |
867824 | 867824 | 2020-12-26 | Hamblen | Tennessee | 47063 | 5586 | 78 |
867825 | 867825 | 2020-12-26 | Hamilton | Tennessee | 47065 | 27159 | 253 |
867826 | 867826 | 2020-12-26 | Hancock | Tennessee | 47067 | 316 | 4 |
867827 | 867827 | 2020-12-26 | Hardeman | Tennessee | 47069 | 2784 | 41 |
867828 | 867828 | 2020-12-26 | Hardin | Tennessee | 47071 | 2502 | 34 |
867829 | 867829 | 2020-12-26 | Hawkins | Tennessee | 47073 | 3461 | 52 |
867830 | 867830 | 2020-12-26 | Haywood | Tennessee | 47075 | 2122 | 35 |
867831 | 867831 | 2020-12-26 | Henderson | Tennessee | 47077 | 2815 | 41 |
867832 | 867832 | 2020-12-26 | Henry | Tennessee | 47079 | 2255 | 34 |
867833 | 867833 | 2020-12-26 | Hickman | Tennessee | 47081 | 1821 | 26 |
867834 | 867834 | 2020-12-26 | Houston | Tennessee | 47083 | 782 | 21 |
867835 | 867835 | 2020-12-26 | Humphreys | Tennessee | 47085 | 1131 | 12 |
867836 | 867836 | 2020-12-26 | Jackson | Tennessee | 47087 | 924 | 18 |
867837 | 867837 | 2020-12-26 | Jefferson | Tennessee | 47089 | 3688 | 56 |
867838 | 867838 | 2020-12-26 | Johnson | Tennessee | 47091 | 1752 | 28 |
867839 | 867839 | 2020-12-26 | Knox | Tennessee | 47093 | 31897 | 293 |
867840 | 867840 | 2020-12-26 | Lake | Tennessee | 47095 | 1379 | 12 |
867841 | 867841 | 2020-12-26 | Lauderdale | Tennessee | 47097 | 2560 | 28 |
867842 | 867842 | 2020-12-26 | Lawrence | Tennessee | 47099 | 4243 | 55 |
867843 | 867843 | 2020-12-26 | Lewis | Tennessee | 47101 | 1114 | 19 |
867844 | 867844 | 2020-12-26 | Lincoln | Tennessee | 47103 | 3130 | 31 |
867845 | 867845 | 2020-12-26 | Loudon | Tennessee | 47105 | 3973 | 30 |
867846 | 867846 | 2020-12-26 | Macon | Tennessee | 47111 | 2491 | 41 |
867847 | 867847 | 2020-12-26 | Madison | Tennessee | 47113 | 7667 | 150 |
867848 | 867848 | 2020-12-26 | Marion | Tennessee | 47115 | 1775 | 25 |
867849 | 867849 | 2020-12-26 | Marshall | Tennessee | 47117 | 2723 | 28 |
867850 | 867850 | 2020-12-26 | Maury | Tennessee | 47119 | 8900 | 100 |
867851 | 867851 | 2020-12-26 | McMinn | Tennessee | 47107 | 4188 | 61 |
867852 | 867852 | 2020-12-26 | McNairy | Tennessee | 47109 | 1951 | 37 |
867853 | 867853 | 2020-12-26 | Meigs | Tennessee | 47121 | 922 | 14 |
867854 | 867854 | 2020-12-26 | Monroe | Tennessee | 47123 | 3678 | 52 |
867855 | 867855 | 2020-12-26 | Montgomery | Tennessee | 47125 | 10951 | 116 |
867856 | 867856 | 2020-12-26 | Moore | Tennessee | 47127 | 655 | 6 |
867857 | 867857 | 2020-12-26 | Morgan | Tennessee | 47129 | 1451 | 11 |
867858 | 867858 | 2020-12-26 | Obion | Tennessee | 47131 | 3524 | 67 |
867859 | 867859 | 2020-12-26 | Overton | Tennessee | 47133 | 2095 | 41 |
867860 | 867860 | 2020-12-26 | Perry | Tennessee | 47135 | 829 | 23 |
867861 | 867861 | 2020-12-26 | Pickett | Tennessee | 47137 | 539 | 17 |
867862 | 867862 | 2020-12-26 | Polk | Tennessee | 47139 | 1104 | 16 |
867863 | 867863 | 2020-12-26 | Putnam | Tennessee | 47141 | 8419 | 114 |
867864 | 867864 | 2020-12-26 | Rhea | Tennessee | 47143 | 3027 | 46 |
867865 | 867865 | 2020-12-26 | Roane | Tennessee | 47145 | 4095 | 48 |
867866 | 867866 | 2020-12-26 | Robertson | Tennessee | 47147 | 6249 | 71 |
867867 | 867867 | 2020-12-26 | Rutherford | Tennessee | 47149 | 27407 | 232 |
867868 | 867868 | 2020-12-26 | Scott | Tennessee | 47151 | 1898 | 20 |
867869 | 867869 | 2020-12-26 | Sequatchie | Tennessee | 47153 | 1110 | 10 |
867870 | 867870 | 2020-12-26 | Sevier | Tennessee | 47155 | 8505 | 63 |
867871 | 867871 | 2020-12-26 | Shelby | Tennessee | 47157 | 64356 | 839 |
867872 | 867872 | 2020-12-26 | Smith | Tennessee | 47159 | 2006 | 23 |
867873 | 867873 | 2020-12-26 | Stewart | Tennessee | 47161 | 845 | 19 |
867874 | 867874 | 2020-12-26 | Sullivan | Tennessee | 47163 | 10374 | 167 |
867875 | 867875 | 2020-12-26 | Sumner | Tennessee | 47165 | 15076 | 196 |
867876 | 867876 | 2020-12-26 | Tipton | Tennessee | 47167 | 5225 | 51 |
867877 | 867877 | 2020-12-26 | Trousdale | Tennessee | 47169 | 2131 | 12 |
867878 | 867878 | 2020-12-26 | Unicoi | Tennessee | 47171 | 1377 | 38 |
867879 | 867879 | 2020-12-26 | Union | Tennessee | 47173 | 1174 | 12 |
867880 | 867880 | 2020-12-26 | Unknown | Tennessee | 5917 | 44 | |
867881 | 867881 | 2020-12-26 | Van Buren | Tennessee | 47175 | 534 | 6 |
867882 | 867882 | 2020-12-26 | Warren | Tennessee | 47177 | 4274 | 33 |
867883 | 867883 | 2020-12-26 | Washington | Tennessee | 47179 | 9769 | 153 |
867884 | 867884 | 2020-12-26 | Wayne | Tennessee | 47181 | 2352 | 16 |
867885 | 867885 | 2020-12-26 | Weakley | Tennessee | 47183 | 2966 | 41 |
867886 | 867886 | 2020-12-26 | White | Tennessee | 47185 | 2664 | 37 |
867887 | 867887 | 2020-12-26 | Williamson | Tennessee | 47187 | 17006 | 118 |
867888 | 867888 | 2020-12-26 | Wilson | Tennessee | 47189 | 11922 | 118 |
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);