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-10-13 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
627675 | 627675 | 2020-10-13 | Anderson | Tennessee | 47001 | 1428 | 13 |
627676 | 627676 | 2020-10-13 | Bedford | Tennessee | 47003 | 1523 | 19 |
627677 | 627677 | 2020-10-13 | Benton | Tennessee | 47005 | 366 | 9 |
627678 | 627678 | 2020-10-13 | Bledsoe | Tennessee | 47007 | 898 | 4 |
627679 | 627679 | 2020-10-13 | Blount | Tennessee | 47009 | 2911 | 31 |
627680 | 627680 | 2020-10-13 | Bradley | Tennessee | 47011 | 3266 | 20 |
627681 | 627681 | 2020-10-13 | Campbell | Tennessee | 47013 | 721 | 5 |
627682 | 627682 | 2020-10-13 | Cannon | Tennessee | 47015 | 361 | 2 |
627683 | 627683 | 2020-10-13 | Carroll | Tennessee | 47017 | 1058 | 24 |
627684 | 627684 | 2020-10-13 | Carter | Tennessee | 47019 | 1332 | 32 |
627685 | 627685 | 2020-10-13 | Cheatham | Tennessee | 47021 | 908 | 10 |
627686 | 627686 | 2020-10-13 | Chester | Tennessee | 47023 | 690 | 13 |
627687 | 627687 | 2020-10-13 | Claiborne | Tennessee | 47025 | 479 | 5 |
627688 | 627688 | 2020-10-13 | Clay | Tennessee | 47027 | 325 | 6 |
627689 | 627689 | 2020-10-13 | Cocke | Tennessee | 47029 | 865 | 11 |
627690 | 627690 | 2020-10-13 | Coffee | Tennessee | 47031 | 1612 | 18 |
627691 | 627691 | 2020-10-13 | Crockett | Tennessee | 47033 | 681 | 19 |
627692 | 627692 | 2020-10-13 | Cumberland | Tennessee | 47035 | 1408 | 24 |
627693 | 627693 | 2020-10-13 | Davidson | Tennessee | 47037 | 30829 | 322 |
627694 | 627694 | 2020-10-13 | DeKalb | Tennessee | 47041 | 637 | 16 |
627695 | 627695 | 2020-10-13 | Decatur | Tennessee | 47039 | 592 | 11 |
627696 | 627696 | 2020-10-13 | Dickson | Tennessee | 47043 | 1462 | 17 |
627697 | 627697 | 2020-10-13 | Dyer | Tennessee | 47045 | 1801 | 21 |
627698 | 627698 | 2020-10-13 | Fayette | Tennessee | 47047 | 1414 | 23 |
627699 | 627699 | 2020-10-13 | Fentress | Tennessee | 47049 | 785 | 6 |
627700 | 627700 | 2020-10-13 | Franklin | Tennessee | 47051 | 1144 | 13 |
627701 | 627701 | 2020-10-13 | Gibson | Tennessee | 47053 | 1960 | 29 |
627702 | 627702 | 2020-10-13 | Giles | Tennessee | 47055 | 815 | 29 |
627703 | 627703 | 2020-10-13 | Grainger | Tennessee | 47057 | 486 | 4 |
627704 | 627704 | 2020-10-13 | Greene | Tennessee | 47059 | 1374 | 48 |
627705 | 627705 | 2020-10-13 | Grundy | Tennessee | 47061 | 462 | 8 |
627706 | 627706 | 2020-10-13 | Hamblen | Tennessee | 47063 | 2229 | 41 |
627707 | 627707 | 2020-10-13 | Hamilton | Tennessee | 47065 | 10813 | 102 |
627708 | 627708 | 2020-10-13 | Hancock | Tennessee | 47067 | 111 | 3 |
627709 | 627709 | 2020-10-13 | Hardeman | Tennessee | 47069 | 1708 | 30 |
627710 | 627710 | 2020-10-13 | Hardin | Tennessee | 47071 | 1219 | 19 |
627711 | 627711 | 2020-10-13 | Hawkins | Tennessee | 47073 | 995 | 22 |
627712 | 627712 | 2020-10-13 | Haywood | Tennessee | 47075 | 1150 | 25 |
627713 | 627713 | 2020-10-13 | Henderson | Tennessee | 47077 | 1316 | 24 |
627714 | 627714 | 2020-10-13 | Henry | Tennessee | 47079 | 696 | 10 |
627715 | 627715 | 2020-10-13 | Hickman | Tennessee | 47081 | 702 | 13 |
627716 | 627716 | 2020-10-13 | Houston | Tennessee | 47083 | 361 | 14 |
627717 | 627717 | 2020-10-13 | Humphreys | Tennessee | 47085 | 358 | 4 |
627718 | 627718 | 2020-10-13 | Jackson | Tennessee | 47087 | 395 | 5 |
627719 | 627719 | 2020-10-13 | Jefferson | Tennessee | 47089 | 1368 | 17 |
627720 | 627720 | 2020-10-13 | Johnson | Tennessee | 47091 | 1049 | 5 |
627721 | 627721 | 2020-10-13 | Knox | Tennessee | 47093 | 11683 | 89 |
627722 | 627722 | 2020-10-13 | Lake | Tennessee | 47095 | 951 | 3 |
627723 | 627723 | 2020-10-13 | Lauderdale | Tennessee | 47097 | 1195 | 16 |
627724 | 627724 | 2020-10-13 | Lawrence | Tennessee | 47099 | 1307 | 17 |
627725 | 627725 | 2020-10-13 | Lewis | Tennessee | 47101 | 291 | 1 |
627726 | 627726 | 2020-10-13 | Lincoln | Tennessee | 47103 | 735 | 2 |
627727 | 627727 | 2020-10-13 | Loudon | Tennessee | 47105 | 1459 | 9 |
627728 | 627728 | 2020-10-13 | Macon | Tennessee | 47111 | 1199 | 22 |
627729 | 627729 | 2020-10-13 | Madison | Tennessee | 47113 | 3415 | 76 |
627730 | 627730 | 2020-10-13 | Marion | Tennessee | 47115 | 633 | 9 |
627731 | 627731 | 2020-10-13 | Marshall | Tennessee | 47117 | 956 | 5 |
627732 | 627732 | 2020-10-13 | Maury | Tennessee | 47119 | 2805 | 34 |
627733 | 627733 | 2020-10-13 | McMinn | Tennessee | 47107 | 1357 | 31 |
627734 | 627734 | 2020-10-13 | McNairy | Tennessee | 47109 | 1042 | 23 |
627735 | 627735 | 2020-10-13 | Meigs | Tennessee | 47121 | 262 | 4 |
627736 | 627736 | 2020-10-13 | Monroe | Tennessee | 47123 | 1209 | 21 |
627737 | 627737 | 2020-10-13 | Montgomery | Tennessee | 47125 | 3592 | 50 |
627738 | 627738 | 2020-10-13 | Moore | Tennessee | 47127 | 222 | 1 |
627739 | 627739 | 2020-10-13 | Morgan | Tennessee | 47129 | 376 | 6 |
627740 | 627740 | 2020-10-13 | Obion | Tennessee | 47131 | 1520 | 15 |
627741 | 627741 | 2020-10-13 | Overton | Tennessee | 47133 | 1014 | 8 |
627742 | 627742 | 2020-10-13 | Perry | Tennessee | 47135 | 170 | 1 |
627743 | 627743 | 2020-10-13 | Pickett | Tennessee | 47137 | 212 | 3 |
627744 | 627744 | 2020-10-13 | Polk | Tennessee | 47139 | 449 | 13 |
627745 | 627745 | 2020-10-13 | Putnam | Tennessee | 47141 | 3833 | 51 |
627746 | 627746 | 2020-10-13 | Rhea | Tennessee | 47143 | 981 | 16 |
627747 | 627747 | 2020-10-13 | Roane | Tennessee | 47145 | 1084 | 6 |
627748 | 627748 | 2020-10-13 | Robertson | Tennessee | 47147 | 2396 | 39 |
627749 | 627749 | 2020-10-13 | Rutherford | Tennessee | 47149 | 10510 | 103 |
627750 | 627750 | 2020-10-13 | Scott | Tennessee | 47151 | 283 | 3 |
627751 | 627751 | 2020-10-13 | Sequatchie | Tennessee | 47153 | 284 | 1 |
627752 | 627752 | 2020-10-13 | Sevier | Tennessee | 47155 | 2973 | 19 |
627753 | 627753 | 2020-10-13 | Shelby | Tennessee | 47157 | 33481 | 540 |
627754 | 627754 | 2020-10-13 | Smith | Tennessee | 47159 | 885 | 12 |
627755 | 627755 | 2020-10-13 | Stewart | Tennessee | 47161 | 290 | 6 |
627756 | 627756 | 2020-10-13 | Sullivan | Tennessee | 47163 | 2782 | 39 |
627757 | 627757 | 2020-10-13 | Sumner | Tennessee | 47165 | 5338 | 105 |
627758 | 627758 | 2020-10-13 | Tipton | Tennessee | 47167 | 2084 | 22 |
627759 | 627759 | 2020-10-13 | Trousdale | Tennessee | 47169 | 1714 | 7 |
627760 | 627760 | 2020-10-13 | Unicoi | Tennessee | 47171 | 307 | 1 |
627761 | 627761 | 2020-10-13 | Union | Tennessee | 47173 | 461 | 2 |
627762 | 627762 | 2020-10-13 | Unknown | Tennessee | 222 | 0 | |
627763 | 627763 | 2020-10-13 | Van Buren | Tennessee | 47175 | 181 | 1 |
627764 | 627764 | 2020-10-13 | Warren | Tennessee | 47177 | 1230 | 9 |
627765 | 627765 | 2020-10-13 | Washington | Tennessee | 47179 | 2783 | 42 |
627766 | 627766 | 2020-10-13 | Wayne | Tennessee | 47181 | 1543 | 6 |
627767 | 627767 | 2020-10-13 | Weakley | Tennessee | 47183 | 1380 | 23 |
627768 | 627768 | 2020-10-13 | White | Tennessee | 47185 | 1000 | 11 |
627769 | 627769 | 2020-10-13 | Williamson | Tennessee | 47187 | 6163 | 47 |
627770 | 627770 | 2020-10-13 | Wilson | Tennessee | 47189 | 4118 | 52 |
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);