ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-07-07" 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 |
---|---|---|---|---|---|---|---|
311657 | 311657 | 2020-07-07 | Anderson | Tennessee | 47001 | 143 | 2 |
311658 | 311658 | 2020-07-07 | Bedford | Tennessee | 47003 | 584 | 7 |
311659 | 311659 | 2020-07-07 | Benton | Tennessee | 47005 | 13 | 1 |
311660 | 311660 | 2020-07-07 | Bledsoe | Tennessee | 47007 | 623 | 1 |
311661 | 311661 | 2020-07-07 | Blount | Tennessee | 47009 | 262 | 3 |
311662 | 311662 | 2020-07-07 | Bradley | Tennessee | 47011 | 773 | 4 |
311663 | 311663 | 2020-07-07 | Campbell | Tennessee | 47013 | 54 | 1 |
311664 | 311664 | 2020-07-07 | Cannon | Tennessee | 47015 | 37 | 0 |
311665 | 311665 | 2020-07-07 | Carroll | Tennessee | 47017 | 49 | 1 |
311666 | 311666 | 2020-07-07 | Carter | Tennessee | 47019 | 70 | 1 |
311667 | 311667 | 2020-07-07 | Cheatham | Tennessee | 47021 | 236 | 1 |
311668 | 311668 | 2020-07-07 | Chester | Tennessee | 47023 | 37 | 0 |
311669 | 311669 | 2020-07-07 | Claiborne | Tennessee | 47025 | 53 | 0 |
311670 | 311670 | 2020-07-07 | Clay | Tennessee | 47027 | 19 | 0 |
311671 | 311671 | 2020-07-07 | Cocke | Tennessee | 47029 | 105 | 0 |
311672 | 311672 | 2020-07-07 | Coffee | Tennessee | 47031 | 125 | 0 |
311673 | 311673 | 2020-07-07 | Crockett | Tennessee | 47033 | 40 | 3 |
311674 | 311674 | 2020-07-07 | Cumberland | Tennessee | 47035 | 188 | 4 |
311675 | 311675 | 2020-07-07 | Davidson | Tennessee | 47037 | 12352 | 127 |
311676 | 311676 | 2020-07-07 | DeKalb | Tennessee | 47041 | 70 | 0 |
311677 | 311677 | 2020-07-07 | Decatur | Tennessee | 47039 | 22 | 0 |
311678 | 311678 | 2020-07-07 | Dickson | Tennessee | 47043 | 219 | 0 |
311679 | 311679 | 2020-07-07 | Dyer | Tennessee | 47045 | 261 | 3 |
311680 | 311680 | 2020-07-07 | Fayette | Tennessee | 47047 | 328 | 2 |
311681 | 311681 | 2020-07-07 | Fentress | Tennessee | 47049 | 24 | 0 |
311682 | 311682 | 2020-07-07 | Franklin | Tennessee | 47051 | 90 | 3 |
311683 | 311683 | 2020-07-07 | Gibson | Tennessee | 47053 | 133 | 1 |
311684 | 311684 | 2020-07-07 | Giles | Tennessee | 47055 | 70 | 1 |
311685 | 311685 | 2020-07-07 | Grainger | Tennessee | 47057 | 47 | 0 |
311686 | 311686 | 2020-07-07 | Greene | Tennessee | 47059 | 117 | 2 |
311687 | 311687 | 2020-07-07 | Grundy | Tennessee | 47061 | 63 | 1 |
311688 | 311688 | 2020-07-07 | Hamblen | Tennessee | 47063 | 374 | 4 |
311689 | 311689 | 2020-07-07 | Hamilton | Tennessee | 47065 | 2982 | 36 |
311690 | 311690 | 2020-07-07 | Hancock | Tennessee | 47067 | 8 | 0 |
311691 | 311691 | 2020-07-07 | Hardeman | Tennessee | 47069 | 357 | 4 |
311692 | 311692 | 2020-07-07 | Hardin | Tennessee | 47071 | 115 | 7 |
311693 | 311693 | 2020-07-07 | Hawkins | Tennessee | 47073 | 64 | 2 |
311694 | 311694 | 2020-07-07 | Haywood | Tennessee | 47075 | 96 | 2 |
311695 | 311695 | 2020-07-07 | Henderson | Tennessee | 47077 | 48 | 0 |
311696 | 311696 | 2020-07-07 | Henry | Tennessee | 47079 | 45 | 0 |
311697 | 311697 | 2020-07-07 | Hickman | Tennessee | 47081 | 88 | 0 |
311698 | 311698 | 2020-07-07 | Houston | Tennessee | 47083 | 15 | 0 |
311699 | 311699 | 2020-07-07 | Humphreys | Tennessee | 47085 | 35 | 2 |
311700 | 311700 | 2020-07-07 | Jackson | Tennessee | 47087 | 30 | 0 |
311701 | 311701 | 2020-07-07 | Jefferson | Tennessee | 47089 | 147 | 1 |
311702 | 311702 | 2020-07-07 | Johnson | Tennessee | 47091 | 45 | 0 |
311703 | 311703 | 2020-07-07 | Knox | Tennessee | 47093 | 1396 | 9 |
311704 | 311704 | 2020-07-07 | Lake | Tennessee | 47095 | 694 | 0 |
311705 | 311705 | 2020-07-07 | Lauderdale | Tennessee | 47097 | 154 | 3 |
311706 | 311706 | 2020-07-07 | Lawrence | Tennessee | 47099 | 172 | 6 |
311707 | 311707 | 2020-07-07 | Lewis | Tennessee | 47101 | 6 | 0 |
311708 | 311708 | 2020-07-07 | Lincoln | Tennessee | 47103 | 68 | 0 |
311709 | 311709 | 2020-07-07 | Loudon | Tennessee | 47105 | 293 | 1 |
311710 | 311710 | 2020-07-07 | Macon | Tennessee | 47111 | 500 | 4 |
311711 | 311711 | 2020-07-07 | Madison | Tennessee | 47113 | 318 | 2 |
311712 | 311712 | 2020-07-07 | Marion | Tennessee | 47115 | 79 | 4 |
311713 | 311713 | 2020-07-07 | Marshall | Tennessee | 47117 | 98 | 1 |
311714 | 311714 | 2020-07-07 | Maury | Tennessee | 47119 | 379 | 3 |
311715 | 311715 | 2020-07-07 | McMinn | Tennessee | 47107 | 243 | 18 |
311716 | 311716 | 2020-07-07 | McNairy | Tennessee | 47109 | 76 | 0 |
311717 | 311717 | 2020-07-07 | Meigs | Tennessee | 47121 | 32 | 0 |
311718 | 311718 | 2020-07-07 | Monroe | Tennessee | 47123 | 140 | 6 |
311719 | 311719 | 2020-07-07 | Montgomery | Tennessee | 47125 | 587 | 7 |
311720 | 311720 | 2020-07-07 | Moore | Tennessee | 47127 | 15 | 0 |
311721 | 311721 | 2020-07-07 | Morgan | Tennessee | 47129 | 28 | 1 |
311722 | 311722 | 2020-07-07 | Obion | Tennessee | 47131 | 117 | 2 |
311723 | 311723 | 2020-07-07 | Overton | Tennessee | 47133 | 65 | 1 |
311724 | 311724 | 2020-07-07 | Perry | Tennessee | 47135 | 35 | 0 |
311725 | 311725 | 2020-07-07 | Pickett | Tennessee | 47137 | 6 | 0 |
311726 | 311726 | 2020-07-07 | Polk | Tennessee | 47139 | 46 | 0 |
311727 | 311727 | 2020-07-07 | Putnam | Tennessee | 47141 | 919 | 7 |
311728 | 311728 | 2020-07-07 | Rhea | Tennessee | 47143 | 289 | 0 |
311729 | 311729 | 2020-07-07 | Roane | Tennessee | 47145 | 64 | 0 |
311730 | 311730 | 2020-07-07 | Robertson | Tennessee | 47147 | 855 | 11 |
311731 | 311731 | 2020-07-07 | Rutherford | Tennessee | 47149 | 3111 | 36 |
311732 | 311732 | 2020-07-07 | Scott | Tennessee | 47151 | 18 | 0 |
311733 | 311733 | 2020-07-07 | Sequatchie | Tennessee | 47153 | 42 | 0 |
311734 | 311734 | 2020-07-07 | Sevier | Tennessee | 47155 | 857 | 3 |
311735 | 311735 | 2020-07-07 | Shelby | Tennessee | 47157 | 12176 | 202 |
311736 | 311736 | 2020-07-07 | Smith | Tennessee | 47159 | 124 | 1 |
311737 | 311737 | 2020-07-07 | Stewart | Tennessee | 47161 | 24 | 0 |
311738 | 311738 | 2020-07-07 | Sullivan | Tennessee | 47163 | 141 | 2 |
311739 | 311739 | 2020-07-07 | Sumner | Tennessee | 47165 | 1670 | 53 |
311740 | 311740 | 2020-07-07 | Tipton | Tennessee | 47167 | 653 | 5 |
311741 | 311741 | 2020-07-07 | Trousdale | Tennessee | 47169 | 1503 | 5 |
311742 | 311742 | 2020-07-07 | Unicoi | Tennessee | 47171 | 55 | 0 |
311743 | 311743 | 2020-07-07 | Union | Tennessee | 47173 | 19 | 0 |
311744 | 311744 | 2020-07-07 | Unknown | Tennessee | 0 | 1 | |
311745 | 311745 | 2020-07-07 | Van Buren | Tennessee | 47175 | 7 | 0 |
311746 | 311746 | 2020-07-07 | Warren | Tennessee | 47177 | 81 | 0 |
311747 | 311747 | 2020-07-07 | Washington | Tennessee | 47179 | 182 | 0 |
311748 | 311748 | 2020-07-07 | Wayne | Tennessee | 47181 | 89 | 0 |
311749 | 311749 | 2020-07-07 | Weakley | Tennessee | 47183 | 66 | 1 |
311750 | 311750 | 2020-07-07 | White | Tennessee | 47185 | 76 | 3 |
311751 | 311751 | 2020-07-07 | Williamson | Tennessee | 47187 | 1420 | 15 |
311752 | 311752 | 2020-07-07 | Wilson | Tennessee | 47189 | 999 | 17 |
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);