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-05 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1289810 | 1289810 | 2021-05-05 | Anderson | Tennessee | 47001 | 8751 | 172 |
1289811 | 1289811 | 2021-05-05 | Bedford | Tennessee | 47003 | 6503 | 128 |
1289812 | 1289812 | 2021-05-05 | Benton | Tennessee | 47005 | 1657 | 40 |
1289813 | 1289813 | 2021-05-05 | Bledsoe | Tennessee | 47007 | 2132 | 11 |
1289814 | 1289814 | 2021-05-05 | Blount | Tennessee | 47009 | 15468 | 193 |
1289815 | 1289815 | 2021-05-05 | Bradley | Tennessee | 47011 | 14995 | 149 |
1289816 | 1289816 | 2021-05-05 | Campbell | Tennessee | 47013 | 4152 | 63 |
1289817 | 1289817 | 2021-05-05 | Cannon | Tennessee | 47015 | 1918 | 31 |
1289818 | 1289818 | 2021-05-05 | Carroll | Tennessee | 47017 | 3615 | 83 |
1289819 | 1289819 | 2021-05-05 | Carter | Tennessee | 47019 | 6603 | 156 |
1289820 | 1289820 | 2021-05-05 | Cheatham | Tennessee | 47021 | 4546 | 55 |
1289821 | 1289821 | 2021-05-05 | Chester | Tennessee | 47023 | 2140 | 51 |
1289822 | 1289822 | 2021-05-05 | Claiborne | Tennessee | 47025 | 3178 | 73 |
1289823 | 1289823 | 2021-05-05 | Clay | Tennessee | 47027 | 1101 | 31 |
1289824 | 1289824 | 2021-05-05 | Cocke | Tennessee | 47029 | 4491 | 99 |
1289825 | 1289825 | 2021-05-05 | Coffee | Tennessee | 47031 | 6894 | 121 |
1289826 | 1289826 | 2021-05-05 | Crockett | Tennessee | 47033 | 2032 | 48 |
1289827 | 1289827 | 2021-05-05 | Cumberland | Tennessee | 47035 | 6711 | 129 |
1289828 | 1289828 | 2021-05-05 | Davidson | Tennessee | 47037 | 98420 | 932 |
1289829 | 1289829 | 2021-05-05 | DeKalb | Tennessee | 47041 | 2794 | 54 |
1289830 | 1289830 | 2021-05-05 | Decatur | Tennessee | 47039 | 1585 | 39 |
1289831 | 1289831 | 2021-05-05 | Dickson | Tennessee | 47043 | 6831 | 110 |
1289832 | 1289832 | 2021-05-05 | Dyer | Tennessee | 47045 | 5417 | 106 |
1289833 | 1289833 | 2021-05-05 | Fayette | Tennessee | 47047 | 5040 | 75 |
1289834 | 1289834 | 2021-05-05 | Fentress | Tennessee | 47049 | 2410 | 47 |
1289835 | 1289835 | 2021-05-05 | Franklin | Tennessee | 47051 | 5140 | 90 |
1289836 | 1289836 | 2021-05-05 | Gibson | Tennessee | 47053 | 6520 | 145 |
1289837 | 1289837 | 2021-05-05 | Giles | Tennessee | 47055 | 3995 | 100 |
1289838 | 1289838 | 2021-05-05 | Grainger | Tennessee | 47057 | 2621 | 50 |
1289839 | 1289839 | 2021-05-05 | Greene | Tennessee | 47059 | 7844 | 155 |
1289840 | 1289840 | 2021-05-05 | Grundy | Tennessee | 47061 | 1790 | 34 |
1289841 | 1289841 | 2021-05-05 | Hamblen | Tennessee | 47063 | 8596 | 173 |
1289842 | 1289842 | 2021-05-05 | Hamilton | Tennessee | 47065 | 44383 | 493 |
1289843 | 1289843 | 2021-05-05 | Hancock | Tennessee | 47067 | 588 | 12 |
1289844 | 1289844 | 2021-05-05 | Hardeman | Tennessee | 47069 | 3513 | 64 |
1289845 | 1289845 | 2021-05-05 | Hardin | Tennessee | 47071 | 3568 | 67 |
1289846 | 1289846 | 2021-05-05 | Hawkins | Tennessee | 47073 | 6011 | 107 |
1289847 | 1289847 | 2021-05-05 | Haywood | Tennessee | 47075 | 2706 | 62 |
1289848 | 1289848 | 2021-05-05 | Henderson | Tennessee | 47077 | 3784 | 76 |
1289849 | 1289849 | 2021-05-05 | Henry | Tennessee | 47079 | 3176 | 76 |
1289850 | 1289850 | 2021-05-05 | Hickman | Tennessee | 47081 | 2835 | 46 |
1289851 | 1289851 | 2021-05-05 | Houston | Tennessee | 47083 | 1093 | 33 |
1289852 | 1289852 | 2021-05-05 | Humphreys | Tennessee | 47085 | 1789 | 26 |
1289853 | 1289853 | 2021-05-05 | Jackson | Tennessee | 47087 | 1319 | 35 |
1289854 | 1289854 | 2021-05-05 | Jefferson | Tennessee | 47089 | 6186 | 124 |
1289855 | 1289855 | 2021-05-05 | Johnson | Tennessee | 47091 | 2391 | 39 |
1289856 | 1289856 | 2021-05-05 | Knox | Tennessee | 47093 | 51764 | 634 |
1289857 | 1289857 | 2021-05-05 | Lake | Tennessee | 47095 | 1702 | 26 |
1289858 | 1289858 | 2021-05-05 | Lauderdale | Tennessee | 47097 | 3177 | 44 |
1289859 | 1289859 | 2021-05-05 | Lawrence | Tennessee | 47099 | 5908 | 86 |
1289860 | 1289860 | 2021-05-05 | Lewis | Tennessee | 47101 | 1581 | 26 |
1289861 | 1289861 | 2021-05-05 | Lincoln | Tennessee | 47103 | 4346 | 63 |
1289862 | 1289862 | 2021-05-05 | Loudon | Tennessee | 47105 | 6114 | 69 |
1289863 | 1289863 | 2021-05-05 | Macon | Tennessee | 47111 | 3617 | 78 |
1289864 | 1289864 | 2021-05-05 | Madison | Tennessee | 47113 | 11151 | 241 |
1289865 | 1289865 | 2021-05-05 | Marion | Tennessee | 47115 | 3125 | 47 |
1289866 | 1289866 | 2021-05-05 | Marshall | Tennessee | 47117 | 4182 | 58 |
1289867 | 1289867 | 2021-05-05 | Maury | Tennessee | 47119 | 13471 | 171 |
1289868 | 1289868 | 2021-05-05 | McMinn | Tennessee | 47107 | 6499 | 98 |
1289869 | 1289869 | 2021-05-05 | McNairy | Tennessee | 47109 | 2811 | 54 |
1289870 | 1289870 | 2021-05-05 | Meigs | Tennessee | 47121 | 1388 | 25 |
1289871 | 1289871 | 2021-05-05 | Monroe | Tennessee | 47123 | 5823 | 95 |
1289872 | 1289872 | 2021-05-05 | Montgomery | Tennessee | 47125 | 20166 | 225 |
1289873 | 1289873 | 2021-05-05 | Moore | Tennessee | 47127 | 1010 | 17 |
1289874 | 1289874 | 2021-05-05 | Morgan | Tennessee | 47129 | 2493 | 39 |
1289875 | 1289875 | 2021-05-05 | Obion | Tennessee | 47131 | 4536 | 96 |
1289876 | 1289876 | 2021-05-05 | Overton | Tennessee | 47133 | 3006 | 61 |
1289877 | 1289877 | 2021-05-05 | Perry | Tennessee | 47135 | 1063 | 28 |
1289878 | 1289878 | 2021-05-05 | Pickett | Tennessee | 47137 | 759 | 24 |
1289879 | 1289879 | 2021-05-05 | Polk | Tennessee | 47139 | 2066 | 24 |
1289880 | 1289880 | 2021-05-05 | Putnam | Tennessee | 47141 | 11357 | 174 |
1289881 | 1289881 | 2021-05-05 | Rhea | Tennessee | 47143 | 4341 | 75 |
1289882 | 1289882 | 2021-05-05 | Roane | Tennessee | 47145 | 6272 | 105 |
1289883 | 1289883 | 2021-05-05 | Robertson | Tennessee | 47147 | 9745 | 131 |
1289884 | 1289884 | 2021-05-05 | Rutherford | Tennessee | 47149 | 42989 | 434 |
1289885 | 1289885 | 2021-05-05 | Scott | Tennessee | 47151 | 3117 | 45 |
1289886 | 1289886 | 2021-05-05 | Sequatchie | Tennessee | 47153 | 1695 | 29 |
1289887 | 1289887 | 2021-05-05 | Sevier | Tennessee | 47155 | 13360 | 175 |
1289888 | 1289888 | 2021-05-05 | Shelby | Tennessee | 47157 | 96050 | 1623 |
1289889 | 1289889 | 2021-05-05 | Smith | Tennessee | 47159 | 2773 | 39 |
1289890 | 1289890 | 2021-05-05 | Stewart | Tennessee | 47161 | 1323 | 28 |
1289891 | 1289891 | 2021-05-05 | Sullivan | Tennessee | 47163 | 16720 | 294 |
1289892 | 1289892 | 2021-05-05 | Sumner | Tennessee | 47165 | 23951 | 348 |
1289893 | 1289893 | 2021-05-05 | Tipton | Tennessee | 47167 | 7328 | 100 |
1289894 | 1289894 | 2021-05-05 | Trousdale | Tennessee | 47169 | 2499 | 22 |
1289895 | 1289895 | 2021-05-05 | Unicoi | Tennessee | 47171 | 2025 | 49 |
1289896 | 1289896 | 2021-05-05 | Union | Tennessee | 47173 | 1906 | 34 |
1289897 | 1289897 | 2021-05-05 | Unknown | Tennessee | 9294 | 128 | |
1289898 | 1289898 | 2021-05-05 | Van Buren | Tennessee | 47175 | 846 | 23 |
1289899 | 1289899 | 2021-05-05 | Warren | Tennessee | 47177 | 5544 | 81 |
1289900 | 1289900 | 2021-05-05 | Washington | Tennessee | 47179 | 14554 | 245 |
1289901 | 1289901 | 2021-05-05 | Wayne | Tennessee | 47181 | 2958 | 34 |
1289902 | 1289902 | 2021-05-05 | Weakley | Tennessee | 47183 | 4108 | 64 |
1289903 | 1289903 | 2021-05-05 | White | Tennessee | 47185 | 3626 | 69 |
1289904 | 1289904 | 2021-05-05 | Williamson | Tennessee | 47187 | 27959 | 217 |
1289905 | 1289905 | 2021-05-05 | Wilson | Tennessee | 47189 | 18764 | 233 |
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);