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 2021-11-22 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1942624 | 1942624 | 2021-11-22 | Anderson | Tennessee | 47001 | 13389 | 233 |
1942625 | 1942625 | 2021-11-22 | Bedford | Tennessee | 47003 | 9460 | 158 |
1942626 | 1942626 | 2021-11-22 | Benton | Tennessee | 47005 | 2929 | 55 |
1942627 | 1942627 | 2021-11-22 | Bledsoe | Tennessee | 47007 | 3542 | 18 |
1942628 | 1942628 | 2021-11-22 | Blount | Tennessee | 47009 | 24280 | 272 |
1942629 | 1942629 | 2021-11-22 | Bradley | Tennessee | 47011 | 22520 | 212 |
1942630 | 1942630 | 2021-11-22 | Campbell | Tennessee | 47013 | 7483 | 88 |
1942631 | 1942631 | 2021-11-22 | Cannon | Tennessee | 47015 | 2839 | 44 |
1942632 | 1942632 | 2021-11-22 | Carroll | Tennessee | 47017 | 5856 | 107 |
1942633 | 1942633 | 2021-11-22 | Carter | Tennessee | 47019 | 10800 | 225 |
1942634 | 1942634 | 2021-11-22 | Cheatham | Tennessee | 47021 | 7120 | 76 |
1942635 | 1942635 | 2021-11-22 | Chester | Tennessee | 47023 | 3577 | 76 |
1942636 | 1942636 | 2021-11-22 | Claiborne | Tennessee | 47025 | 5821 | 115 |
1942637 | 1942637 | 2021-11-22 | Clay | Tennessee | 47027 | 1548 | 37 |
1942638 | 1942638 | 2021-11-22 | Cocke | Tennessee | 47029 | 7546 | 109 |
1942639 | 1942639 | 2021-11-22 | Coffee | Tennessee | 47031 | 10798 | 164 |
1942640 | 1942640 | 2021-11-22 | Crockett | Tennessee | 47033 | 3396 | 62 |
1942641 | 1942641 | 2021-11-22 | Cumberland | Tennessee | 47035 | 11418 | 227 |
1942642 | 1942642 | 2021-11-22 | Davidson | Tennessee | 47037 | 135017 | 1191 |
1942643 | 1942643 | 2021-11-22 | DeKalb | Tennessee | 47041 | 4275 | 75 |
1942644 | 1942644 | 2021-11-22 | Decatur | Tennessee | 47039 | 2471 | 44 |
1942645 | 1942645 | 2021-11-22 | Dickson | Tennessee | 47043 | 10683 | 169 |
1942646 | 1942646 | 2021-11-22 | Dyer | Tennessee | 47045 | 8158 | 150 |
1942647 | 1942647 | 2021-11-22 | Fayette | Tennessee | 47047 | 7428 | 108 |
1942648 | 1942648 | 2021-11-22 | Fentress | Tennessee | 47049 | 3754 | 68 |
1942649 | 1942649 | 2021-11-22 | Franklin | Tennessee | 47051 | 8136 | 103 |
1942650 | 1942650 | 2021-11-22 | Gibson | Tennessee | 47053 | 10786 | 191 |
1942651 | 1942651 | 2021-11-22 | Giles | Tennessee | 47055 | 6151 | 127 |
1942652 | 1942652 | 2021-11-22 | Grainger | Tennessee | 47057 | 4481 | 68 |
1942653 | 1942653 | 2021-11-22 | Greene | Tennessee | 47059 | 14130 | 247 |
1942654 | 1942654 | 2021-11-22 | Grundy | Tennessee | 47061 | 2923 | 41 |
1942655 | 1942655 | 2021-11-22 | Hamblen | Tennessee | 47063 | 13238 | 206 |
1942656 | 1942656 | 2021-11-22 | Hamilton | Tennessee | 47065 | 65104 | 671 |
1942657 | 1942657 | 2021-11-22 | Hancock | Tennessee | 47067 | 1246 | 20 |
1942658 | 1942658 | 2021-11-22 | Hardeman | Tennessee | 47069 | 5164 | 85 |
1942659 | 1942659 | 2021-11-22 | Hardin | Tennessee | 47071 | 5659 | 88 |
1942660 | 1942660 | 2021-11-22 | Hawkins | Tennessee | 47073 | 10635 | 180 |
1942661 | 1942661 | 2021-11-22 | Haywood | Tennessee | 47075 | 3902 | 77 |
1942662 | 1942662 | 2021-11-22 | Henderson | Tennessee | 47077 | 5873 | 105 |
1942663 | 1942663 | 2021-11-22 | Henry | Tennessee | 47079 | 5559 | 89 |
1942664 | 1942664 | 2021-11-22 | Hickman | Tennessee | 47081 | 4722 | 78 |
1942665 | 1942665 | 2021-11-22 | Houston | Tennessee | 47083 | 1876 | 45 |
1942666 | 1942666 | 2021-11-22 | Humphreys | Tennessee | 47085 | 3327 | 48 |
1942667 | 1942667 | 2021-11-22 | Jackson | Tennessee | 47087 | 2107 | 40 |
1942668 | 1942668 | 2021-11-22 | Jefferson | Tennessee | 47089 | 10108 | 149 |
1942669 | 1942669 | 2021-11-22 | Johnson | Tennessee | 47091 | 3876 | 52 |
1942670 | 1942670 | 2021-11-22 | Knox | Tennessee | 47093 | 80290 | 946 |
1942671 | 1942671 | 2021-11-22 | Lake | Tennessee | 47095 | 2023 | 31 |
1942672 | 1942672 | 2021-11-22 | Lauderdale | Tennessee | 47097 | 5253 | 69 |
1942673 | 1942673 | 2021-11-22 | Lawrence | Tennessee | 47099 | 9721 | 125 |
1942674 | 1942674 | 2021-11-22 | Lewis | Tennessee | 47101 | 2557 | 41 |
1942675 | 1942675 | 2021-11-22 | Lincoln | Tennessee | 47103 | 6816 | 88 |
1942676 | 1942676 | 2021-11-22 | Loudon | Tennessee | 47105 | 9385 | 101 |
1942677 | 1942677 | 2021-11-22 | Macon | Tennessee | 47111 | 5545 | 94 |
1942678 | 1942678 | 2021-11-22 | Madison | Tennessee | 47113 | 17992 | 324 |
1942679 | 1942679 | 2021-11-22 | Marion | Tennessee | 47115 | 5872 | 57 |
1942680 | 1942680 | 2021-11-22 | Marshall | Tennessee | 47117 | 6958 | 90 |
1942681 | 1942681 | 2021-11-22 | Maury | Tennessee | 47119 | 19737 | 238 |
1942682 | 1942682 | 2021-11-22 | McMinn | Tennessee | 47107 | 10694 | 137 |
1942683 | 1942683 | 2021-11-22 | McNairy | Tennessee | 47109 | 4763 | 71 |
1942684 | 1942684 | 2021-11-22 | Meigs | Tennessee | 47121 | 2222 | 30 |
1942685 | 1942685 | 2021-11-22 | Monroe | Tennessee | 47123 | 9900 | 127 |
1942686 | 1942686 | 2021-11-22 | Montgomery | Tennessee | 47125 | 33439 | 350 |
1942687 | 1942687 | 2021-11-22 | Moore | Tennessee | 47127 | 1455 | 24 |
1942688 | 1942688 | 2021-11-22 | Morgan | Tennessee | 47129 | 3894 | 50 |
1942689 | 1942689 | 2021-11-22 | Obion | Tennessee | 47131 | 6804 | 112 |
1942690 | 1942690 | 2021-11-22 | Overton | Tennessee | 47133 | 4888 | 83 |
1942691 | 1942691 | 2021-11-22 | Perry | Tennessee | 47135 | 1637 | 34 |
1942692 | 1942692 | 2021-11-22 | Pickett | Tennessee | 47137 | 1116 | 25 |
1942693 | 1942693 | 2021-11-22 | Polk | Tennessee | 47139 | 3238 | 32 |
1942694 | 1942694 | 2021-11-22 | Putnam | Tennessee | 47141 | 16984 | 223 |
1942695 | 1942695 | 2021-11-22 | Rhea | Tennessee | 47143 | 7070 | 97 |
1942696 | 1942696 | 2021-11-22 | Roane | Tennessee | 47145 | 10263 | 159 |
1942697 | 1942697 | 2021-11-22 | Robertson | Tennessee | 47147 | 14301 | 196 |
1942698 | 1942698 | 2021-11-22 | Rutherford | Tennessee | 47149 | 63321 | 575 |
1942699 | 1942699 | 2021-11-22 | Scott | Tennessee | 47151 | 5634 | 64 |
1942700 | 1942700 | 2021-11-22 | Sequatchie | Tennessee | 47153 | 3058 | 33 |
1942701 | 1942701 | 2021-11-22 | Sevier | Tennessee | 47155 | 20492 | 281 |
1942702 | 1942702 | 2021-11-22 | Shelby | Tennessee | 47157 | 148387 | 2312 |
1942703 | 1942703 | 2021-11-22 | Smith | Tennessee | 47159 | 4240 | 53 |
1942704 | 1942704 | 2021-11-22 | Stewart | Tennessee | 47161 | 2181 | 35 |
1942705 | 1942705 | 2021-11-22 | Sullivan | Tennessee | 47163 | 27828 | 443 |
1942706 | 1942706 | 2021-11-22 | Sumner | Tennessee | 47165 | 34988 | 428 |
1942707 | 1942707 | 2021-11-22 | Tipton | Tennessee | 47167 | 11625 | 140 |
1942708 | 1942708 | 2021-11-22 | Trousdale | Tennessee | 47169 | 3225 | 26 |
1942709 | 1942709 | 2021-11-22 | Unicoi | Tennessee | 47171 | 3218 | 65 |
1942710 | 1942710 | 2021-11-22 | Union | Tennessee | 47173 | 3378 | 50 |
1942711 | 1942711 | 2021-11-22 | Unknown | Tennessee | 8763 | 128 | |
1942712 | 1942712 | 2021-11-22 | Van Buren | Tennessee | 47175 | 1277 | 29 |
1942713 | 1942713 | 2021-11-22 | Warren | Tennessee | 47177 | 8781 | 128 |
1942714 | 1942714 | 2021-11-22 | Washington | Tennessee | 47179 | 22590 | 338 |
1942715 | 1942715 | 2021-11-22 | Wayne | Tennessee | 47181 | 4142 | 39 |
1942716 | 1942716 | 2021-11-22 | Weakley | Tennessee | 47183 | 6341 | 89 |
1942717 | 1942717 | 2021-11-22 | White | Tennessee | 47185 | 5721 | 98 |
1942718 | 1942718 | 2021-11-22 | Williamson | Tennessee | 47187 | 40615 | 276 |
1942719 | 1942719 | 2021-11-22 | Wilson | Tennessee | 47189 | 27622 | 343 |
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);