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 2022-04-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 |
---|---|---|---|---|---|---|---|
2394651 | 2394651 | 2022-04-10 | Anderson | Tennessee | 47001 | 22072 | 328 |
2394652 | 2394652 | 2022-04-10 | Bedford | Tennessee | 47003 | 14948 | 231 |
2394653 | 2394653 | 2022-04-10 | Benton | Tennessee | 47005 | 4493 | 91 |
2394654 | 2394654 | 2022-04-10 | Bledsoe | Tennessee | 47007 | 4658 | 56 |
2394655 | 2394655 | 2022-04-10 | Blount | Tennessee | 47009 | 39079 | 420 |
2394656 | 2394656 | 2022-04-10 | Bradley | Tennessee | 47011 | 33104 | 406 |
2394657 | 2394657 | 2022-04-10 | Campbell | Tennessee | 47013 | 12224 | 162 |
2394658 | 2394658 | 2022-04-10 | Cannon | Tennessee | 47015 | 4195 | 60 |
2394659 | 2394659 | 2022-04-10 | Carroll | Tennessee | 47017 | 8948 | 156 |
2394660 | 2394660 | 2022-04-10 | Carter | Tennessee | 47019 | 16458 | 331 |
2394661 | 2394661 | 2022-04-10 | Cheatham | Tennessee | 47021 | 10902 | 118 |
2394662 | 2394662 | 2022-04-10 | Chester | Tennessee | 47023 | 5840 | 96 |
2394663 | 2394663 | 2022-04-10 | Claiborne | Tennessee | 47025 | 9094 | 176 |
2394664 | 2394664 | 2022-04-10 | Clay | Tennessee | 47027 | 2287 | 49 |
2394665 | 2394665 | 2022-04-10 | Cocke | Tennessee | 47029 | 11565 | 209 |
2394666 | 2394666 | 2022-04-10 | Coffee | Tennessee | 47031 | 16943 | 262 |
2394667 | 2394667 | 2022-04-10 | Crockett | Tennessee | 47033 | 5177 | 84 |
2394668 | 2394668 | 2022-04-10 | Cumberland | Tennessee | 47035 | 16097 | 322 |
2394669 | 2394669 | 2022-04-10 | Davidson | Tennessee | 47037 | 207404 | 1641 |
2394670 | 2394670 | 2022-04-10 | DeKalb | Tennessee | 47041 | 6278 | 100 |
2394671 | 2394671 | 2022-04-10 | Decatur | Tennessee | 47039 | 3731 | 67 |
2394672 | 2394672 | 2022-04-10 | Dickson | Tennessee | 47043 | 15870 | 241 |
2394673 | 2394673 | 2022-04-10 | Dyer | Tennessee | 47045 | 12786 | 199 |
2394674 | 2394674 | 2022-04-10 | Fayette | Tennessee | 47047 | 11409 | 181 |
2394675 | 2394675 | 2022-04-10 | Fentress | Tennessee | 47049 | 5696 | 127 |
2394676 | 2394676 | 2022-04-10 | Franklin | Tennessee | 47051 | 12849 | 178 |
2394677 | 2394677 | 2022-04-10 | Gibson | Tennessee | 47053 | 17380 | 256 |
2394678 | 2394678 | 2022-04-10 | Giles | Tennessee | 47055 | 9401 | 189 |
2394679 | 2394679 | 2022-04-10 | Grainger | Tennessee | 47057 | 6777 | 108 |
2394680 | 2394680 | 2022-04-10 | Greene | Tennessee | 47059 | 22053 | 366 |
2394681 | 2394681 | 2022-04-10 | Grundy | Tennessee | 47061 | 3985 | 71 |
2394682 | 2394682 | 2022-04-10 | Hamblen | Tennessee | 47063 | 19697 | 349 |
2394683 | 2394683 | 2022-04-10 | Hamilton | Tennessee | 47065 | 99820 | 1130 |
2394684 | 2394684 | 2022-04-10 | Hancock | Tennessee | 47067 | 2007 | 35 |
2394685 | 2394685 | 2022-04-10 | Hardeman | Tennessee | 47069 | 7589 | 116 |
2394686 | 2394686 | 2022-04-10 | Hardin | Tennessee | 47071 | 8750 | 143 |
2394687 | 2394687 | 2022-04-10 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2394688 | 2394688 | 2022-04-10 | Haywood | Tennessee | 47075 | 6161 | 99 |
2394689 | 2394689 | 2022-04-10 | Henderson | Tennessee | 47077 | 9115 | 155 |
2394690 | 2394690 | 2022-04-10 | Henry | Tennessee | 47079 | 8263 | 157 |
2394691 | 2394691 | 2022-04-10 | Hickman | Tennessee | 47081 | 6823 | 109 |
2394692 | 2394692 | 2022-04-10 | Houston | Tennessee | 47083 | 2675 | 60 |
2394693 | 2394693 | 2022-04-10 | Humphreys | Tennessee | 47085 | 4839 | 72 |
2394694 | 2394694 | 2022-04-10 | Jackson | Tennessee | 47087 | 3204 | 63 |
2394695 | 2394695 | 2022-04-10 | Jefferson | Tennessee | 47089 | 15713 | 260 |
2394696 | 2394696 | 2022-04-10 | Johnson | Tennessee | 47091 | 5164 | 89 |
2394697 | 2394697 | 2022-04-10 | Knox | Tennessee | 47093 | 127773 | 1353 |
2394698 | 2394698 | 2022-04-10 | Lake | Tennessee | 47095 | 2740 | 41 |
2394699 | 2394699 | 2022-04-10 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2394700 | 2394700 | 2022-04-10 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2394701 | 2394701 | 2022-04-10 | Lewis | Tennessee | 47101 | 3570 | 58 |
2394702 | 2394702 | 2022-04-10 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2394703 | 2394703 | 2022-04-10 | Loudon | Tennessee | 47105 | 14472 | 192 |
2394704 | 2394704 | 2022-04-10 | Macon | Tennessee | 47111 | 8439 | 145 |
2394705 | 2394705 | 2022-04-10 | Madison | Tennessee | 47113 | 29908 | 421 |
2394706 | 2394706 | 2022-04-10 | Marion | Tennessee | 47115 | 8850 | 128 |
2394707 | 2394707 | 2022-04-10 | Marshall | Tennessee | 47117 | 10359 | 120 |
2394708 | 2394708 | 2022-04-10 | Maury | Tennessee | 47119 | 28980 | 334 |
2394709 | 2394709 | 2022-04-10 | McMinn | Tennessee | 47107 | 16673 | 252 |
2394710 | 2394710 | 2022-04-10 | McNairy | Tennessee | 47109 | 7641 | 119 |
2394711 | 2394711 | 2022-04-10 | Meigs | Tennessee | 47121 | 3384 | 55 |
2394712 | 2394712 | 2022-04-10 | Monroe | Tennessee | 47123 | 14509 | 236 |
2394713 | 2394713 | 2022-04-10 | Montgomery | Tennessee | 47125 | 50167 | 566 |
2394714 | 2394714 | 2022-04-10 | Moore | Tennessee | 47127 | 2238 | 39 |
2394715 | 2394715 | 2022-04-10 | Morgan | Tennessee | 47129 | 6178 | 82 |
2394716 | 2394716 | 2022-04-10 | Obion | Tennessee | 47131 | 10764 | 189 |
2394717 | 2394717 | 2022-04-10 | Overton | Tennessee | 47133 | 7136 | 122 |
2394718 | 2394718 | 2022-04-10 | Perry | Tennessee | 47135 | 2328 | 55 |
2394719 | 2394719 | 2022-04-10 | Pickett | Tennessee | 47137 | 1768 | 36 |
2394720 | 2394720 | 2022-04-10 | Polk | Tennessee | 47139 | 4729 | 71 |
2394721 | 2394721 | 2022-04-10 | Putnam | Tennessee | 47141 | 25082 | 302 |
2394722 | 2394722 | 2022-04-10 | Rhea | Tennessee | 47143 | 9970 | 154 |
2394723 | 2394723 | 2022-04-10 | Roane | Tennessee | 47145 | 15780 | 231 |
2394724 | 2394724 | 2022-04-10 | Robertson | Tennessee | 47147 | 21521 | 296 |
2394725 | 2394725 | 2022-04-10 | Rutherford | Tennessee | 47149 | 95639 | 886 |
2394726 | 2394726 | 2022-04-10 | Scott | Tennessee | 47151 | 9034 | 116 |
2394727 | 2394727 | 2022-04-10 | Sequatchie | Tennessee | 47153 | 4211 | 66 |
2394728 | 2394728 | 2022-04-10 | Sevier | Tennessee | 47155 | 30275 | 407 |
2394729 | 2394729 | 2022-04-10 | Shelby | Tennessee | 47157 | 237958 | 3269 |
2394730 | 2394730 | 2022-04-10 | Smith | Tennessee | 47159 | 6160 | 83 |
2394731 | 2394731 | 2022-04-10 | Stewart | Tennessee | 47161 | 3284 | 57 |
2394732 | 2394732 | 2022-04-10 | Sullivan | Tennessee | 47163 | 45769 | 710 |
2394733 | 2394733 | 2022-04-10 | Sumner | Tennessee | 47165 | 53118 | 719 |
2394734 | 2394734 | 2022-04-10 | Tipton | Tennessee | 47167 | 17601 | 231 |
2394735 | 2394735 | 2022-04-10 | Trousdale | Tennessee | 47169 | 4217 | 45 |
2394736 | 2394736 | 2022-04-10 | Unicoi | Tennessee | 47171 | 5164 | 94 |
2394737 | 2394737 | 2022-04-10 | Union | Tennessee | 47173 | 5394 | 73 |
2394738 | 2394738 | 2022-04-10 | Unknown | Tennessee | 19008 | 588 | |
2394739 | 2394739 | 2022-04-10 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2394740 | 2394740 | 2022-04-10 | Warren | Tennessee | 47177 | 12990 | 175 |
2394741 | 2394741 | 2022-04-10 | Washington | Tennessee | 47179 | 38534 | 489 |
2394742 | 2394742 | 2022-04-10 | Wayne | Tennessee | 47181 | 5696 | 63 |
2394743 | 2394743 | 2022-04-10 | Weakley | Tennessee | 47183 | 9501 | 144 |
2394744 | 2394744 | 2022-04-10 | White | Tennessee | 47185 | 8223 | 128 |
2394745 | 2394745 | 2022-04-10 | Williamson | Tennessee | 47187 | 61958 | 399 |
2394746 | 2394746 | 2022-04-10 | Wilson | Tennessee | 47189 | 41623 | 478 |
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);