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-09-10 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
520761 | 520761 | 2020-09-10 | Anderson | Tennessee | 47001 | 992 | 10 |
520762 | 520762 | 2020-09-10 | Bedford | Tennessee | 47003 | 1196 | 14 |
520763 | 520763 | 2020-09-10 | Benton | Tennessee | 47005 | 293 | 8 |
520764 | 520764 | 2020-09-10 | Bledsoe | Tennessee | 47007 | 814 | 4 |
520765 | 520765 | 2020-09-10 | Blount | Tennessee | 47009 | 2264 | 19 |
520766 | 520766 | 2020-09-10 | Bradley | Tennessee | 47011 | 2648 | 16 |
520767 | 520767 | 2020-09-10 | Campbell | Tennessee | 47013 | 381 | 3 |
520768 | 520768 | 2020-09-10 | Cannon | Tennessee | 47015 | 237 | 0 |
520769 | 520769 | 2020-09-10 | Carroll | Tennessee | 47017 | 713 | 13 |
520770 | 520770 | 2020-09-10 | Carter | Tennessee | 47019 | 1032 | 24 |
520771 | 520771 | 2020-09-10 | Cheatham | Tennessee | 47021 | 739 | 10 |
520772 | 520772 | 2020-09-10 | Chester | Tennessee | 47023 | 479 | 8 |
520773 | 520773 | 2020-09-10 | Claiborne | Tennessee | 47025 | 390 | 3 |
520774 | 520774 | 2020-09-10 | Clay | Tennessee | 47027 | 132 | 3 |
520775 | 520775 | 2020-09-10 | Cocke | Tennessee | 47029 | 697 | 7 |
520776 | 520776 | 2020-09-10 | Coffee | Tennessee | 47031 | 875 | 8 |
520777 | 520777 | 2020-09-10 | Crockett | Tennessee | 47033 | 453 | 17 |
520778 | 520778 | 2020-09-10 | Cumberland | Tennessee | 47035 | 1017 | 10 |
520779 | 520779 | 2020-09-10 | Davidson | Tennessee | 47037 | 26988 | 274 |
520780 | 520780 | 2020-09-10 | DeKalb | Tennessee | 47041 | 518 | 8 |
520781 | 520781 | 2020-09-10 | Decatur | Tennessee | 47039 | 383 | 5 |
520782 | 520782 | 2020-09-10 | Dickson | Tennessee | 47043 | 1094 | 11 |
520783 | 520783 | 2020-09-10 | Dyer | Tennessee | 47045 | 1082 | 10 |
520784 | 520784 | 2020-09-10 | Fayette | Tennessee | 47047 | 1021 | 13 |
520785 | 520785 | 2020-09-10 | Fentress | Tennessee | 47049 | 314 | 2 |
520786 | 520786 | 2020-09-10 | Franklin | Tennessee | 47051 | 685 | 7 |
520787 | 520787 | 2020-09-10 | Gibson | Tennessee | 47053 | 1277 | 19 |
520788 | 520788 | 2020-09-10 | Giles | Tennessee | 47055 | 502 | 15 |
520789 | 520789 | 2020-09-10 | Grainger | Tennessee | 47057 | 304 | 1 |
520790 | 520790 | 2020-09-10 | Greene | Tennessee | 47059 | 962 | 23 |
520791 | 520791 | 2020-09-10 | Grundy | Tennessee | 47061 | 164 | 4 |
520792 | 520792 | 2020-09-10 | Hamblen | Tennessee | 47063 | 1735 | 22 |
520793 | 520793 | 2020-09-10 | Hamilton | Tennessee | 47065 | 8672 | 83 |
520794 | 520794 | 2020-09-10 | Hancock | Tennessee | 47067 | 103 | 2 |
520795 | 520795 | 2020-09-10 | Hardeman | Tennessee | 47069 | 1427 | 24 |
520796 | 520796 | 2020-09-10 | Hardin | Tennessee | 47071 | 845 | 13 |
520797 | 520797 | 2020-09-10 | Hawkins | Tennessee | 47073 | 708 | 13 |
520798 | 520798 | 2020-09-10 | Haywood | Tennessee | 47075 | 834 | 13 |
520799 | 520799 | 2020-09-10 | Henderson | Tennessee | 47077 | 1013 | 16 |
520800 | 520800 | 2020-09-10 | Henry | Tennessee | 47079 | 536 | 8 |
520801 | 520801 | 2020-09-10 | Hickman | Tennessee | 47081 | 442 | 4 |
520802 | 520802 | 2020-09-10 | Houston | Tennessee | 47083 | 126 | 0 |
520803 | 520803 | 2020-09-10 | Humphreys | Tennessee | 47085 | 192 | 3 |
520804 | 520804 | 2020-09-10 | Jackson | Tennessee | 47087 | 272 | 2 |
520805 | 520805 | 2020-09-10 | Jefferson | Tennessee | 47089 | 956 | 13 |
520806 | 520806 | 2020-09-10 | Johnson | Tennessee | 47091 | 523 | 2 |
520807 | 520807 | 2020-09-10 | Knox | Tennessee | 47093 | 8160 | 66 |
520808 | 520808 | 2020-09-10 | Lake | Tennessee | 47095 | 853 | 2 |
520809 | 520809 | 2020-09-10 | Lauderdale | Tennessee | 47097 | 852 | 14 |
520810 | 520810 | 2020-09-10 | Lawrence | Tennessee | 47099 | 831 | 11 |
520811 | 520811 | 2020-09-10 | Lewis | Tennessee | 47101 | 152 | 1 |
520812 | 520812 | 2020-09-10 | Lincoln | Tennessee | 47103 | 491 | 1 |
520813 | 520813 | 2020-09-10 | Loudon | Tennessee | 47105 | 1003 | 4 |
520814 | 520814 | 2020-09-10 | Macon | Tennessee | 47111 | 964 | 19 |
520815 | 520815 | 2020-09-10 | Madison | Tennessee | 47113 | 2193 | 50 |
520816 | 520816 | 2020-09-10 | Marion | Tennessee | 47115 | 413 | 7 |
520817 | 520817 | 2020-09-10 | Marshall | Tennessee | 47117 | 609 | 4 |
520818 | 520818 | 2020-09-10 | Maury | Tennessee | 47119 | 1965 | 18 |
520819 | 520819 | 2020-09-10 | McMinn | Tennessee | 47107 | 914 | 24 |
520820 | 520820 | 2020-09-10 | McNairy | Tennessee | 47109 | 668 | 14 |
520821 | 520821 | 2020-09-10 | Meigs | Tennessee | 47121 | 191 | 3 |
520822 | 520822 | 2020-09-10 | Monroe | Tennessee | 47123 | 903 | 17 |
520823 | 520823 | 2020-09-10 | Montgomery | Tennessee | 47125 | 2703 | 35 |
520824 | 520824 | 2020-09-10 | Moore | Tennessee | 47127 | 121 | 1 |
520825 | 520825 | 2020-09-10 | Morgan | Tennessee | 47129 | 274 | 2 |
520826 | 520826 | 2020-09-10 | Obion | Tennessee | 47131 | 956 | 8 |
520827 | 520827 | 2020-09-10 | Overton | Tennessee | 47133 | 561 | 2 |
520828 | 520828 | 2020-09-10 | Perry | Tennessee | 47135 | 123 | 0 |
520829 | 520829 | 2020-09-10 | Pickett | Tennessee | 47137 | 87 | 1 |
520830 | 520830 | 2020-09-10 | Polk | Tennessee | 47139 | 359 | 11 |
520831 | 520831 | 2020-09-10 | Putnam | Tennessee | 47141 | 2596 | 34 |
520832 | 520832 | 2020-09-10 | Rhea | Tennessee | 47143 | 703 | 7 |
520833 | 520833 | 2020-09-10 | Roane | Tennessee | 47145 | 717 | 3 |
520834 | 520834 | 2020-09-10 | Robertson | Tennessee | 47147 | 2041 | 31 |
520835 | 520835 | 2020-09-10 | Rutherford | Tennessee | 47149 | 8387 | 82 |
520836 | 520836 | 2020-09-10 | Scott | Tennessee | 47151 | 173 | 2 |
520837 | 520837 | 2020-09-10 | Sequatchie | Tennessee | 47153 | 183 | 2 |
520838 | 520838 | 2020-09-10 | Sevier | Tennessee | 47155 | 2374 | 13 |
520839 | 520839 | 2020-09-10 | Shelby | Tennessee | 47157 | 28754 | 412 |
520840 | 520840 | 2020-09-10 | Smith | Tennessee | 47159 | 599 | 9 |
520841 | 520841 | 2020-09-10 | Stewart | Tennessee | 47161 | 115 | 2 |
520842 | 520842 | 2020-09-10 | Sullivan | Tennessee | 47163 | 1914 | 29 |
520843 | 520843 | 2020-09-10 | Sumner | Tennessee | 47165 | 4384 | 89 |
520844 | 520844 | 2020-09-10 | Tipton | Tennessee | 47167 | 1590 | 15 |
520845 | 520845 | 2020-09-10 | Trousdale | Tennessee | 47169 | 1633 | 7 |
520846 | 520846 | 2020-09-10 | Unicoi | Tennessee | 47171 | 248 | 1 |
520847 | 520847 | 2020-09-10 | Union | Tennessee | 47173 | 256 | 1 |
520848 | 520848 | 2020-09-10 | Unknown | Tennessee | 0 | 4 | |
520849 | 520849 | 2020-09-10 | Van Buren | Tennessee | 47175 | 119 | 0 |
520850 | 520850 | 2020-09-10 | Warren | Tennessee | 47177 | 930 | 7 |
520851 | 520851 | 2020-09-10 | Washington | Tennessee | 47179 | 1913 | 16 |
520852 | 520852 | 2020-09-10 | Wayne | Tennessee | 47181 | 1467 | 4 |
520853 | 520853 | 2020-09-10 | Weakley | Tennessee | 47183 | 997 | 14 |
520854 | 520854 | 2020-09-10 | White | Tennessee | 47185 | 650 | 8 |
520855 | 520855 | 2020-09-10 | Williamson | Tennessee | 47187 | 4685 | 34 |
520856 | 520856 | 2020-09-10 | Wilson | Tennessee | 47189 | 3107 | 35 |
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);