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-04-14 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1221622 | 1221622 | 2021-04-14 | Anderson | Tennessee | 47001 | 8580 | 171 |
1221623 | 1221623 | 2021-04-14 | Bedford | Tennessee | 47003 | 6388 | 126 |
1221624 | 1221624 | 2021-04-14 | Benton | Tennessee | 47005 | 1623 | 40 |
1221625 | 1221625 | 2021-04-14 | Bledsoe | Tennessee | 47007 | 2088 | 11 |
1221626 | 1221626 | 2021-04-14 | Blount | Tennessee | 47009 | 14917 | 194 |
1221627 | 1221627 | 2021-04-14 | Bradley | Tennessee | 47011 | 14443 | 147 |
1221628 | 1221628 | 2021-04-14 | Campbell | Tennessee | 47013 | 4075 | 62 |
1221629 | 1221629 | 2021-04-14 | Cannon | Tennessee | 47015 | 1884 | 31 |
1221630 | 1221630 | 2021-04-14 | Carroll | Tennessee | 47017 | 3566 | 82 |
1221631 | 1221631 | 2021-04-14 | Carter | Tennessee | 47019 | 6419 | 156 |
1221632 | 1221632 | 2021-04-14 | Cheatham | Tennessee | 47021 | 4399 | 53 |
1221633 | 1221633 | 2021-04-14 | Chester | Tennessee | 47023 | 2091 | 51 |
1221634 | 1221634 | 2021-04-14 | Claiborne | Tennessee | 47025 | 3039 | 73 |
1221635 | 1221635 | 2021-04-14 | Clay | Tennessee | 47027 | 1088 | 31 |
1221636 | 1221636 | 2021-04-14 | Cocke | Tennessee | 47029 | 4421 | 98 |
1221637 | 1221637 | 2021-04-14 | Coffee | Tennessee | 47031 | 6813 | 121 |
1221638 | 1221638 | 2021-04-14 | Crockett | Tennessee | 47033 | 2007 | 48 |
1221639 | 1221639 | 2021-04-14 | Cumberland | Tennessee | 47035 | 6514 | 127 |
1221640 | 1221640 | 2021-04-14 | Davidson | Tennessee | 47037 | 96014 | 922 |
1221641 | 1221641 | 2021-04-14 | DeKalb | Tennessee | 47041 | 2746 | 53 |
1221642 | 1221642 | 2021-04-14 | Decatur | Tennessee | 47039 | 1570 | 38 |
1221643 | 1221643 | 2021-04-14 | Dickson | Tennessee | 47043 | 6693 | 108 |
1221644 | 1221644 | 2021-04-14 | Dyer | Tennessee | 47045 | 5348 | 104 |
1221645 | 1221645 | 2021-04-14 | Fayette | Tennessee | 47047 | 4876 | 76 |
1221646 | 1221646 | 2021-04-14 | Fentress | Tennessee | 47049 | 2375 | 46 |
1221647 | 1221647 | 2021-04-14 | Franklin | Tennessee | 47051 | 5069 | 88 |
1221648 | 1221648 | 2021-04-14 | Gibson | Tennessee | 47053 | 6370 | 144 |
1221649 | 1221649 | 2021-04-14 | Giles | Tennessee | 47055 | 3931 | 98 |
1221650 | 1221650 | 2021-04-14 | Grainger | Tennessee | 47057 | 2569 | 49 |
1221651 | 1221651 | 2021-04-14 | Greene | Tennessee | 47059 | 7694 | 152 |
1221652 | 1221652 | 2021-04-14 | Grundy | Tennessee | 47061 | 1770 | 31 |
1221653 | 1221653 | 2021-04-14 | Hamblen | Tennessee | 47063 | 8460 | 170 |
1221654 | 1221654 | 2021-04-14 | Hamilton | Tennessee | 47065 | 43317 | 480 |
1221655 | 1221655 | 2021-04-14 | Hancock | Tennessee | 47067 | 541 | 12 |
1221656 | 1221656 | 2021-04-14 | Hardeman | Tennessee | 47069 | 3456 | 63 |
1221657 | 1221657 | 2021-04-14 | Hardin | Tennessee | 47071 | 3485 | 66 |
1221658 | 1221658 | 2021-04-14 | Hawkins | Tennessee | 47073 | 5741 | 106 |
1221659 | 1221659 | 2021-04-14 | Haywood | Tennessee | 47075 | 2678 | 60 |
1221660 | 1221660 | 2021-04-14 | Henderson | Tennessee | 47077 | 3710 | 75 |
1221661 | 1221661 | 2021-04-14 | Henry | Tennessee | 47079 | 3112 | 75 |
1221662 | 1221662 | 2021-04-14 | Hickman | Tennessee | 47081 | 2790 | 45 |
1221663 | 1221663 | 2021-04-14 | Houston | Tennessee | 47083 | 1080 | 33 |
1221664 | 1221664 | 2021-04-14 | Humphreys | Tennessee | 47085 | 1709 | 21 |
1221665 | 1221665 | 2021-04-14 | Jackson | Tennessee | 47087 | 1293 | 35 |
1221666 | 1221666 | 2021-04-14 | Jefferson | Tennessee | 47089 | 6038 | 121 |
1221667 | 1221667 | 2021-04-14 | Johnson | Tennessee | 47091 | 2282 | 38 |
1221668 | 1221668 | 2021-04-14 | Knox | Tennessee | 47093 | 50379 | 623 |
1221669 | 1221669 | 2021-04-14 | Lake | Tennessee | 47095 | 1695 | 26 |
1221670 | 1221670 | 2021-04-14 | Lauderdale | Tennessee | 47097 | 3135 | 44 |
1221671 | 1221671 | 2021-04-14 | Lawrence | Tennessee | 47099 | 5768 | 86 |
1221672 | 1221672 | 2021-04-14 | Lewis | Tennessee | 47101 | 1553 | 26 |
1221673 | 1221673 | 2021-04-14 | Lincoln | Tennessee | 47103 | 4292 | 63 |
1221674 | 1221674 | 2021-04-14 | Loudon | Tennessee | 47105 | 5993 | 69 |
1221675 | 1221675 | 2021-04-14 | Macon | Tennessee | 47111 | 3563 | 76 |
1221676 | 1221676 | 2021-04-14 | Madison | Tennessee | 47113 | 10693 | 240 |
1221677 | 1221677 | 2021-04-14 | Marion | Tennessee | 47115 | 3079 | 46 |
1221678 | 1221678 | 2021-04-14 | Marshall | Tennessee | 47117 | 4092 | 58 |
1221679 | 1221679 | 2021-04-14 | Maury | Tennessee | 47119 | 12991 | 168 |
1221680 | 1221680 | 2021-04-14 | McMinn | Tennessee | 47107 | 6318 | 95 |
1221681 | 1221681 | 2021-04-14 | McNairy | Tennessee | 47109 | 2762 | 54 |
1221682 | 1221682 | 2021-04-14 | Meigs | Tennessee | 47121 | 1335 | 23 |
1221683 | 1221683 | 2021-04-14 | Monroe | Tennessee | 47123 | 5672 | 95 |
1221684 | 1221684 | 2021-04-14 | Montgomery | Tennessee | 47125 | 18976 | 224 |
1221685 | 1221685 | 2021-04-14 | Moore | Tennessee | 47127 | 993 | 17 |
1221686 | 1221686 | 2021-04-14 | Morgan | Tennessee | 47129 | 2448 | 39 |
1221687 | 1221687 | 2021-04-14 | Obion | Tennessee | 47131 | 4488 | 96 |
1221688 | 1221688 | 2021-04-14 | Overton | Tennessee | 47133 | 2953 | 60 |
1221689 | 1221689 | 2021-04-14 | Perry | Tennessee | 47135 | 1058 | 28 |
1221690 | 1221690 | 2021-04-14 | Pickett | Tennessee | 47137 | 755 | 24 |
1221691 | 1221691 | 2021-04-14 | Polk | Tennessee | 47139 | 1981 | 24 |
1221692 | 1221692 | 2021-04-14 | Putnam | Tennessee | 47141 | 11124 | 173 |
1221693 | 1221693 | 2021-04-14 | Rhea | Tennessee | 47143 | 4296 | 75 |
1221694 | 1221694 | 2021-04-14 | Roane | Tennessee | 47145 | 6163 | 102 |
1221695 | 1221695 | 2021-04-14 | Robertson | Tennessee | 47147 | 9538 | 127 |
1221696 | 1221696 | 2021-04-14 | Rutherford | Tennessee | 47149 | 41703 | 420 |
1221697 | 1221697 | 2021-04-14 | Scott | Tennessee | 47151 | 3040 | 45 |
1221698 | 1221698 | 2021-04-14 | Sequatchie | Tennessee | 47153 | 1660 | 28 |
1221699 | 1221699 | 2021-04-14 | Sevier | Tennessee | 47155 | 13064 | 174 |
1221700 | 1221700 | 2021-04-14 | Shelby | Tennessee | 47157 | 92984 | 1586 |
1221701 | 1221701 | 2021-04-14 | Smith | Tennessee | 47159 | 2735 | 38 |
1221702 | 1221702 | 2021-04-14 | Stewart | Tennessee | 47161 | 1298 | 28 |
1221703 | 1221703 | 2021-04-14 | Sullivan | Tennessee | 47163 | 15971 | 287 |
1221704 | 1221704 | 2021-04-14 | Sumner | Tennessee | 47165 | 23064 | 338 |
1221705 | 1221705 | 2021-04-14 | Tipton | Tennessee | 47167 | 7193 | 100 |
1221706 | 1221706 | 2021-04-14 | Trousdale | Tennessee | 47169 | 2483 | 22 |
1221707 | 1221707 | 2021-04-14 | Unicoi | Tennessee | 47171 | 1932 | 49 |
1221708 | 1221708 | 2021-04-14 | Union | Tennessee | 47173 | 1852 | 34 |
1221709 | 1221709 | 2021-04-14 | Unknown | Tennessee | 9131 | 129 | |
1221710 | 1221710 | 2021-04-14 | Van Buren | Tennessee | 47175 | 833 | 21 |
1221711 | 1221711 | 2021-04-14 | Warren | Tennessee | 47177 | 5503 | 81 |
1221712 | 1221712 | 2021-04-14 | Washington | Tennessee | 47179 | 14029 | 242 |
1221713 | 1221713 | 2021-04-14 | Wayne | Tennessee | 47181 | 2941 | 34 |
1221714 | 1221714 | 2021-04-14 | Weakley | Tennessee | 47183 | 4005 | 62 |
1221715 | 1221715 | 2021-04-14 | White | Tennessee | 47185 | 3529 | 68 |
1221716 | 1221716 | 2021-04-14 | Williamson | Tennessee | 47187 | 27127 | 213 |
1221717 | 1221717 | 2021-04-14 | Wilson | Tennessee | 47189 | 17885 | 223 |
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);