ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where date = "2020-06-25" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
273788 | 273788 | 2020-06-25 | Anderson | Tennessee | 47001 | 81 | 2 |
273789 | 273789 | 2020-06-25 | Bedford | Tennessee | 47003 | 451 | 4 |
273790 | 273790 | 2020-06-25 | Benton | Tennessee | 47005 | 12 | 1 |
273791 | 273791 | 2020-06-25 | Bledsoe | Tennessee | 47007 | 616 | 1 |
273792 | 273792 | 2020-06-25 | Blount | Tennessee | 47009 | 150 | 3 |
273793 | 273793 | 2020-06-25 | Bradley | Tennessee | 47011 | 421 | 3 |
273794 | 273794 | 2020-06-25 | Campbell | Tennessee | 47013 | 28 | 1 |
273795 | 273795 | 2020-06-25 | Cannon | Tennessee | 47015 | 23 | 0 |
273796 | 273796 | 2020-06-25 | Carroll | Tennessee | 47017 | 36 | 1 |
273797 | 273797 | 2020-06-25 | Carter | Tennessee | 47019 | 42 | 1 |
273798 | 273798 | 2020-06-25 | Cheatham | Tennessee | 47021 | 187 | 0 |
273799 | 273799 | 2020-06-25 | Chester | Tennessee | 47023 | 16 | 0 |
273800 | 273800 | 2020-06-25 | Claiborne | Tennessee | 47025 | 19 | 0 |
273801 | 273801 | 2020-06-25 | Clay | Tennessee | 47027 | 12 | 0 |
273802 | 273802 | 2020-06-25 | Cocke | Tennessee | 47029 | 36 | 0 |
273803 | 273803 | 2020-06-25 | Coffee | Tennessee | 47031 | 102 | 0 |
273804 | 273804 | 2020-06-25 | Crockett | Tennessee | 47033 | 28 | 3 |
273805 | 273805 | 2020-06-25 | Cumberland | Tennessee | 47035 | 155 | 3 |
273806 | 273806 | 2020-06-25 | Davidson | Tennessee | 47037 | 8644 | 103 |
273807 | 273807 | 2020-06-25 | DeKalb | Tennessee | 47041 | 44 | 0 |
273808 | 273808 | 2020-06-25 | Decatur | Tennessee | 47039 | 17 | 0 |
273809 | 273809 | 2020-06-25 | Dickson | Tennessee | 47043 | 151 | 0 |
273810 | 273810 | 2020-06-25 | Dyer | Tennessee | 47045 | 181 | 0 |
273811 | 273811 | 2020-06-25 | Fayette | Tennessee | 47047 | 229 | 2 |
273812 | 273812 | 2020-06-25 | Fentress | Tennessee | 47049 | 15 | 0 |
273813 | 273813 | 2020-06-25 | Franklin | Tennessee | 47051 | 69 | 3 |
273814 | 273814 | 2020-06-25 | Gibson | Tennessee | 47053 | 83 | 1 |
273815 | 273815 | 2020-06-25 | Giles | Tennessee | 47055 | 43 | 0 |
273816 | 273816 | 2020-06-25 | Grainger | Tennessee | 47057 | 25 | 0 |
273817 | 273817 | 2020-06-25 | Greene | Tennessee | 47059 | 66 | 2 |
273818 | 273818 | 2020-06-25 | Grundy | Tennessee | 47061 | 58 | 1 |
273819 | 273819 | 2020-06-25 | Hamblen | Tennessee | 47063 | 162 | 4 |
273820 | 273820 | 2020-06-25 | Hamilton | Tennessee | 47065 | 2322 | 29 |
273821 | 273821 | 2020-06-25 | Hancock | Tennessee | 47067 | 3 | 0 |
273822 | 273822 | 2020-06-25 | Hardeman | Tennessee | 47069 | 269 | 1 |
273823 | 273823 | 2020-06-25 | Hardin | Tennessee | 47071 | 80 | 5 |
273824 | 273824 | 2020-06-25 | Hawkins | Tennessee | 47073 | 43 | 2 |
273825 | 273825 | 2020-06-25 | Haywood | Tennessee | 47075 | 59 | 2 |
273826 | 273826 | 2020-06-25 | Henderson | Tennessee | 47077 | 27 | 0 |
273827 | 273827 | 2020-06-25 | Henry | Tennessee | 47079 | 37 | 0 |
273828 | 273828 | 2020-06-25 | Hickman | Tennessee | 47081 | 67 | 0 |
273829 | 273829 | 2020-06-25 | Houston | Tennessee | 47083 | 10 | 0 |
273830 | 273830 | 2020-06-25 | Humphreys | Tennessee | 47085 | 18 | 1 |
273831 | 273831 | 2020-06-25 | Jackson | Tennessee | 47087 | 22 | 0 |
273832 | 273832 | 2020-06-25 | Jefferson | Tennessee | 47089 | 80 | 0 |
273833 | 273833 | 2020-06-25 | Johnson | Tennessee | 47091 | 28 | 0 |
273834 | 273834 | 2020-06-25 | Knox | Tennessee | 47093 | 798 | 5 |
273835 | 273835 | 2020-06-25 | Lake | Tennessee | 47095 | 690 | 0 |
273836 | 273836 | 2020-06-25 | Lauderdale | Tennessee | 47097 | 86 | 2 |
273837 | 273837 | 2020-06-25 | Lawrence | Tennessee | 47099 | 101 | 3 |
273838 | 273838 | 2020-06-25 | Lewis | Tennessee | 47101 | 5 | 0 |
273839 | 273839 | 2020-06-25 | Lincoln | Tennessee | 47103 | 51 | 0 |
273840 | 273840 | 2020-06-25 | Loudon | Tennessee | 47105 | 244 | 1 |
273841 | 273841 | 2020-06-25 | Macon | Tennessee | 47111 | 241 | 3 |
273842 | 273842 | 2020-06-25 | Madison | Tennessee | 47113 | 206 | 2 |
273843 | 273843 | 2020-06-25 | Marion | Tennessee | 47115 | 56 | 4 |
273844 | 273844 | 2020-06-25 | Marshall | Tennessee | 47117 | 49 | 1 |
273845 | 273845 | 2020-06-25 | Maury | Tennessee | 47119 | 259 | 2 |
273846 | 273846 | 2020-06-25 | McMinn | Tennessee | 47107 | 194 | 17 |
273847 | 273847 | 2020-06-25 | McNairy | Tennessee | 47109 | 48 | 0 |
273848 | 273848 | 2020-06-25 | Meigs | Tennessee | 47121 | 31 | 0 |
273849 | 273849 | 2020-06-25 | Monroe | Tennessee | 47123 | 116 | 4 |
273850 | 273850 | 2020-06-25 | Montgomery | Tennessee | 47125 | 413 | 7 |
273851 | 273851 | 2020-06-25 | Moore | Tennessee | 47127 | 5 | 0 |
273852 | 273852 | 2020-06-25 | Morgan | Tennessee | 47129 | 22 | 1 |
273853 | 273853 | 2020-06-25 | Obion | Tennessee | 47131 | 75 | 2 |
273854 | 273854 | 2020-06-25 | Overton | Tennessee | 47133 | 46 | 0 |
273855 | 273855 | 2020-06-25 | Perry | Tennessee | 47135 | 28 | 0 |
273856 | 273856 | 2020-06-25 | Pickett | Tennessee | 47137 | 6 | 0 |
273857 | 273857 | 2020-06-25 | Polk | Tennessee | 47139 | 36 | 0 |
273858 | 273858 | 2020-06-25 | Putnam | Tennessee | 47141 | 706 | 7 |
273859 | 273859 | 2020-06-25 | Rhea | Tennessee | 47143 | 258 | 0 |
273860 | 273860 | 2020-06-25 | Roane | Tennessee | 47145 | 42 | 0 |
273861 | 273861 | 2020-06-25 | Robertson | Tennessee | 47147 | 729 | 10 |
273862 | 273862 | 2020-06-25 | Rutherford | Tennessee | 47149 | 2266 | 34 |
273863 | 273863 | 2020-06-25 | Scott | Tennessee | 47151 | 14 | 0 |
273864 | 273864 | 2020-06-25 | Sequatchie | Tennessee | 47153 | 24 | 0 |
273865 | 273865 | 2020-06-25 | Sevier | Tennessee | 47155 | 516 | 3 |
273866 | 273866 | 2020-06-25 | Shelby | Tennessee | 47157 | 8643 | 175 |
273867 | 273867 | 2020-06-25 | Smith | Tennessee | 47159 | 58 | 1 |
273868 | 273868 | 2020-06-25 | Stewart | Tennessee | 47161 | 19 | 0 |
273869 | 273869 | 2020-06-25 | Sullivan | Tennessee | 47163 | 77 | 2 |
273870 | 273870 | 2020-06-25 | Sumner | Tennessee | 47165 | 1260 | 51 |
273871 | 273871 | 2020-06-25 | Tipton | Tennessee | 47167 | 580 | 4 |
273872 | 273872 | 2020-06-25 | Trousdale | Tennessee | 47169 | 1471 | 5 |
273873 | 273873 | 2020-06-25 | Unicoi | Tennessee | 47171 | 53 | 0 |
273874 | 273874 | 2020-06-25 | Union | Tennessee | 47173 | 10 | 0 |
273875 | 273875 | 2020-06-25 | Van Buren | Tennessee | 47175 | 6 | 0 |
273876 | 273876 | 2020-06-25 | Warren | Tennessee | 47177 | 47 | 0 |
273877 | 273877 | 2020-06-25 | Washington | Tennessee | 47179 | 112 | 0 |
273878 | 273878 | 2020-06-25 | Wayne | Tennessee | 47181 | 71 | 0 |
273879 | 273879 | 2020-06-25 | Weakley | Tennessee | 47183 | 45 | 1 |
273880 | 273880 | 2020-06-25 | White | Tennessee | 47185 | 58 | 3 |
273881 | 273881 | 2020-06-25 | Williamson | Tennessee | 47187 | 874 | 14 |
273882 | 273882 | 2020-06-25 | Wilson | Tennessee | 47189 | 683 | 15 |
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);