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-08-24 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
465795 | 465795 | 2020-08-24 | Anderson | Tennessee | 47001 | 839 | 8 |
465796 | 465796 | 2020-08-24 | Bedford | Tennessee | 47003 | 1057 | 14 |
465797 | 465797 | 2020-08-24 | Benton | Tennessee | 47005 | 223 | 3 |
465798 | 465798 | 2020-08-24 | Bledsoe | Tennessee | 47007 | 768 | 3 |
465799 | 465799 | 2020-08-24 | Blount | Tennessee | 47009 | 1744 | 15 |
465800 | 465800 | 2020-08-24 | Bradley | Tennessee | 47011 | 2359 | 16 |
465801 | 465801 | 2020-08-24 | Campbell | Tennessee | 47013 | 302 | 2 |
465802 | 465802 | 2020-08-24 | Cannon | Tennessee | 47015 | 186 | 0 |
465803 | 465803 | 2020-08-24 | Carroll | Tennessee | 47017 | 516 | 6 |
465804 | 465804 | 2020-08-24 | Carter | Tennessee | 47019 | 736 | 14 |
465805 | 465805 | 2020-08-24 | Cheatham | Tennessee | 47021 | 694 | 10 |
465806 | 465806 | 2020-08-24 | Chester | Tennessee | 47023 | 336 | 4 |
465807 | 465807 | 2020-08-24 | Claiborne | Tennessee | 47025 | 345 | 2 |
465808 | 465808 | 2020-08-24 | Clay | Tennessee | 47027 | 103 | 0 |
465809 | 465809 | 2020-08-24 | Cocke | Tennessee | 47029 | 606 | 6 |
465810 | 465810 | 2020-08-24 | Coffee | Tennessee | 47031 | 695 | 6 |
465811 | 465811 | 2020-08-24 | Crockett | Tennessee | 47033 | 359 | 12 |
465812 | 465812 | 2020-08-24 | Cumberland | Tennessee | 47035 | 709 | 8 |
465813 | 465813 | 2020-08-24 | Davidson | Tennessee | 47037 | 25326 | 246 |
465814 | 465814 | 2020-08-24 | DeKalb | Tennessee | 47041 | 417 | 5 |
465815 | 465815 | 2020-08-24 | Decatur | Tennessee | 47039 | 272 | 4 |
465816 | 465816 | 2020-08-24 | Dickson | Tennessee | 47043 | 851 | 8 |
465817 | 465817 | 2020-08-24 | Dyer | Tennessee | 47045 | 862 | 9 |
465818 | 465818 | 2020-08-24 | Fayette | Tennessee | 47047 | 820 | 10 |
465819 | 465819 | 2020-08-24 | Fentress | Tennessee | 47049 | 149 | 0 |
465820 | 465820 | 2020-08-24 | Franklin | Tennessee | 47051 | 426 | 4 |
465821 | 465821 | 2020-08-24 | Gibson | Tennessee | 47053 | 995 | 13 |
465822 | 465822 | 2020-08-24 | Giles | Tennessee | 47055 | 428 | 14 |
465823 | 465823 | 2020-08-24 | Grainger | Tennessee | 47057 | 249 | 1 |
465824 | 465824 | 2020-08-24 | Greene | Tennessee | 47059 | 730 | 10 |
465825 | 465825 | 2020-08-24 | Grundy | Tennessee | 47061 | 142 | 2 |
465826 | 465826 | 2020-08-24 | Hamblen | Tennessee | 47063 | 1580 | 18 |
465827 | 465827 | 2020-08-24 | Hamilton | Tennessee | 47065 | 7496 | 68 |
465828 | 465828 | 2020-08-24 | Hancock | Tennessee | 47067 | 88 | 2 |
465829 | 465829 | 2020-08-24 | Hardeman | Tennessee | 47069 | 1179 | 22 |
465830 | 465830 | 2020-08-24 | Hardin | Tennessee | 47071 | 620 | 8 |
465831 | 465831 | 2020-08-24 | Hawkins | Tennessee | 47073 | 637 | 12 |
465832 | 465832 | 2020-08-24 | Haywood | Tennessee | 47075 | 702 | 10 |
465833 | 465833 | 2020-08-24 | Henderson | Tennessee | 47077 | 793 | 6 |
465834 | 465834 | 2020-08-24 | Henry | Tennessee | 47079 | 410 | 4 |
465835 | 465835 | 2020-08-24 | Hickman | Tennessee | 47081 | 331 | 1 |
465836 | 465836 | 2020-08-24 | Houston | Tennessee | 47083 | 73 | 0 |
465837 | 465837 | 2020-08-24 | Humphreys | Tennessee | 47085 | 155 | 3 |
465838 | 465838 | 2020-08-24 | Jackson | Tennessee | 47087 | 189 | 1 |
465839 | 465839 | 2020-08-24 | Jefferson | Tennessee | 47089 | 721 | 6 |
465840 | 465840 | 2020-08-24 | Johnson | Tennessee | 47091 | 387 | 1 |
465841 | 465841 | 2020-08-24 | Knox | Tennessee | 47093 | 6189 | 53 |
465842 | 465842 | 2020-08-24 | Lake | Tennessee | 47095 | 820 | 1 |
465843 | 465843 | 2020-08-24 | Lauderdale | Tennessee | 47097 | 637 | 12 |
465844 | 465844 | 2020-08-24 | Lawrence | Tennessee | 47099 | 703 | 8 |
465845 | 465845 | 2020-08-24 | Lewis | Tennessee | 47101 | 117 | 1 |
465846 | 465846 | 2020-08-24 | Lincoln | Tennessee | 47103 | 386 | 1 |
465847 | 465847 | 2020-08-24 | Loudon | Tennessee | 47105 | 879 | 3 |
465848 | 465848 | 2020-08-24 | Macon | Tennessee | 47111 | 882 | 14 |
465849 | 465849 | 2020-08-24 | Madison | Tennessee | 47113 | 1571 | 31 |
465850 | 465850 | 2020-08-24 | Marion | Tennessee | 47115 | 300 | 5 |
465851 | 465851 | 2020-08-24 | Marshall | Tennessee | 47117 | 472 | 4 |
465852 | 465852 | 2020-08-24 | Maury | Tennessee | 47119 | 1593 | 11 |
465853 | 465853 | 2020-08-24 | McMinn | Tennessee | 47107 | 717 | 20 |
465854 | 465854 | 2020-08-24 | McNairy | Tennessee | 47109 | 490 | 8 |
465855 | 465855 | 2020-08-24 | Meigs | Tennessee | 47121 | 134 | 2 |
465856 | 465856 | 2020-08-24 | Monroe | Tennessee | 47123 | 608 | 10 |
465857 | 465857 | 2020-08-24 | Montgomery | Tennessee | 47125 | 2330 | 27 |
465858 | 465858 | 2020-08-24 | Moore | Tennessee | 47127 | 84 | 0 |
465859 | 465859 | 2020-08-24 | Morgan | Tennessee | 47129 | 184 | 1 |
465860 | 465860 | 2020-08-24 | Obion | Tennessee | 47131 | 757 | 5 |
465861 | 465861 | 2020-08-24 | Overton | Tennessee | 47133 | 360 | 1 |
465862 | 465862 | 2020-08-24 | Perry | Tennessee | 47135 | 98 | 0 |
465863 | 465863 | 2020-08-24 | Pickett | Tennessee | 47137 | 46 | 1 |
465864 | 465864 | 2020-08-24 | Polk | Tennessee | 47139 | 305 | 10 |
465865 | 465865 | 2020-08-24 | Putnam | Tennessee | 47141 | 2149 | 23 |
465866 | 465866 | 2020-08-24 | Rhea | Tennessee | 47143 | 616 | 2 |
465867 | 465867 | 2020-08-24 | Roane | Tennessee | 47145 | 587 | 2 |
465868 | 465868 | 2020-08-24 | Robertson | Tennessee | 47147 | 1751 | 25 |
465869 | 465869 | 2020-08-24 | Rutherford | Tennessee | 47149 | 7486 | 64 |
465870 | 465870 | 2020-08-24 | Scott | Tennessee | 47151 | 153 | 2 |
465871 | 465871 | 2020-08-24 | Sequatchie | Tennessee | 47153 | 138 | 1 |
465872 | 465872 | 2020-08-24 | Sevier | Tennessee | 47155 | 2154 | 11 |
465873 | 465873 | 2020-08-24 | Shelby | Tennessee | 47157 | 26406 | 380 |
465874 | 465874 | 2020-08-24 | Smith | Tennessee | 47159 | 497 | 8 |
465875 | 465875 | 2020-08-24 | Stewart | Tennessee | 47161 | 89 | 0 |
465876 | 465876 | 2020-08-24 | Sullivan | Tennessee | 47163 | 1474 | 22 |
465877 | 465877 | 2020-08-24 | Sumner | Tennessee | 47165 | 3889 | 82 |
465878 | 465878 | 2020-08-24 | Tipton | Tennessee | 47167 | 1337 | 13 |
465879 | 465879 | 2020-08-24 | Trousdale | Tennessee | 47169 | 1592 | 6 |
465880 | 465880 | 2020-08-24 | Unicoi | Tennessee | 47171 | 212 | 1 |
465881 | 465881 | 2020-08-24 | Union | Tennessee | 47173 | 208 | 1 |
465882 | 465882 | 2020-08-24 | Unknown | Tennessee | 19 | 0 | |
465883 | 465883 | 2020-08-24 | Van Buren | Tennessee | 47175 | 54 | 0 |
465884 | 465884 | 2020-08-24 | Warren | Tennessee | 47177 | 741 | 7 |
465885 | 465885 | 2020-08-24 | Washington | Tennessee | 47179 | 1597 | 7 |
465886 | 465886 | 2020-08-24 | Wayne | Tennessee | 47181 | 261 | 2 |
465887 | 465887 | 2020-08-24 | Weakley | Tennessee | 47183 | 742 | 9 |
465888 | 465888 | 2020-08-24 | White | Tennessee | 47185 | 435 | 7 |
465889 | 465889 | 2020-08-24 | Williamson | Tennessee | 47187 | 4157 | 27 |
465890 | 465890 | 2020-08-24 | Wilson | Tennessee | 47189 | 2664 | 30 |
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);