ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-10-05" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1786653 | 1786653 | 2021-10-05 | Anderson | Tennessee | 47001 | 12430 | 205 |
1786654 | 1786654 | 2021-10-05 | Bedford | Tennessee | 47003 | 8812 | 151 |
1786655 | 1786655 | 2021-10-05 | Benton | Tennessee | 47005 | 2662 | 49 |
1786656 | 1786656 | 2021-10-05 | Bledsoe | Tennessee | 47007 | 3386 | 14 |
1786657 | 1786657 | 2021-10-05 | Blount | Tennessee | 47009 | 22995 | 247 |
1786658 | 1786658 | 2021-10-05 | Bradley | Tennessee | 47011 | 21558 | 172 |
1786659 | 1786659 | 2021-10-05 | Campbell | Tennessee | 47013 | 6670 | 72 |
1786660 | 1786660 | 2021-10-05 | Cannon | Tennessee | 47015 | 2725 | 39 |
1786661 | 1786661 | 2021-10-05 | Carroll | Tennessee | 47017 | 5526 | 98 |
1786662 | 1786662 | 2021-10-05 | Carter | Tennessee | 47019 | 10138 | 204 |
1786663 | 1786663 | 2021-10-05 | Cheatham | Tennessee | 47021 | 6797 | 65 |
1786664 | 1786664 | 2021-10-05 | Chester | Tennessee | 47023 | 3418 | 68 |
1786665 | 1786665 | 2021-10-05 | Claiborne | Tennessee | 47025 | 5202 | 90 |
1786666 | 1786666 | 2021-10-05 | Clay | Tennessee | 47027 | 1460 | 36 |
1786667 | 1786667 | 2021-10-05 | Cocke | Tennessee | 47029 | 7039 | 104 |
1786668 | 1786668 | 2021-10-05 | Coffee | Tennessee | 47031 | 10220 | 145 |
1786669 | 1786669 | 2021-10-05 | Crockett | Tennessee | 47033 | 3284 | 59 |
1786670 | 1786670 | 2021-10-05 | Cumberland | Tennessee | 47035 | 10653 | 203 |
1786671 | 1786671 | 2021-10-05 | Davidson | Tennessee | 47037 | 129061 | 1115 |
1786672 | 1786672 | 2021-10-05 | DeKalb | Tennessee | 47041 | 4094 | 64 |
1786673 | 1786673 | 2021-10-05 | Decatur | Tennessee | 47039 | 2359 | 42 |
1786674 | 1786674 | 2021-10-05 | Dickson | Tennessee | 47043 | 10040 | 159 |
1786675 | 1786675 | 2021-10-05 | Dyer | Tennessee | 47045 | 7976 | 134 |
1786676 | 1786676 | 2021-10-05 | Fayette | Tennessee | 47047 | 7116 | 97 |
1786677 | 1786677 | 2021-10-05 | Fentress | Tennessee | 47049 | 3477 | 60 |
1786678 | 1786678 | 2021-10-05 | Franklin | Tennessee | 47051 | 7695 | 99 |
1786679 | 1786679 | 2021-10-05 | Gibson | Tennessee | 47053 | 10394 | 181 |
1786680 | 1786680 | 2021-10-05 | Giles | Tennessee | 47055 | 5777 | 114 |
1786681 | 1786681 | 2021-10-05 | Grainger | Tennessee | 47057 | 4146 | 60 |
1786682 | 1786682 | 2021-10-05 | Greene | Tennessee | 47059 | 12820 | 221 |
1786683 | 1786683 | 2021-10-05 | Grundy | Tennessee | 47061 | 2709 | 37 |
1786684 | 1786684 | 2021-10-05 | Hamblen | Tennessee | 47063 | 12669 | 189 |
1786685 | 1786685 | 2021-10-05 | Hamilton | Tennessee | 47065 | 62152 | 631 |
1786686 | 1786686 | 2021-10-05 | Hancock | Tennessee | 47067 | 1146 | 18 |
1786687 | 1786687 | 2021-10-05 | Hardeman | Tennessee | 47069 | 5011 | 77 |
1786688 | 1786688 | 2021-10-05 | Hardin | Tennessee | 47071 | 5388 | 81 |
1786689 | 1786689 | 2021-10-05 | Hawkins | Tennessee | 47073 | 9827 | 158 |
1786690 | 1786690 | 2021-10-05 | Haywood | Tennessee | 47075 | 3748 | 71 |
1786691 | 1786691 | 2021-10-05 | Henderson | Tennessee | 47077 | 5534 | 96 |
1786692 | 1786692 | 2021-10-05 | Henry | Tennessee | 47079 | 5327 | 80 |
1786693 | 1786693 | 2021-10-05 | Hickman | Tennessee | 47081 | 4473 | 72 |
1786694 | 1786694 | 2021-10-05 | Houston | Tennessee | 47083 | 1794 | 42 |
1786695 | 1786695 | 2021-10-05 | Humphreys | Tennessee | 47085 | 3067 | 44 |
1786696 | 1786696 | 2021-10-05 | Jackson | Tennessee | 47087 | 2012 | 39 |
1786697 | 1786697 | 2021-10-05 | Jefferson | Tennessee | 47089 | 9582 | 135 |
1786698 | 1786698 | 2021-10-05 | Johnson | Tennessee | 47091 | 3398 | 45 |
1786699 | 1786699 | 2021-10-05 | Knox | Tennessee | 47093 | 75613 | 862 |
1786700 | 1786700 | 2021-10-05 | Lake | Tennessee | 47095 | 1980 | 31 |
1786701 | 1786701 | 2021-10-05 | Lauderdale | Tennessee | 47097 | 5104 | 61 |
1786702 | 1786702 | 2021-10-05 | Lawrence | Tennessee | 47099 | 9253 | 114 |
1786703 | 1786703 | 2021-10-05 | Lewis | Tennessee | 47101 | 2478 | 37 |
1786704 | 1786704 | 2021-10-05 | Lincoln | Tennessee | 47103 | 6477 | 81 |
1786705 | 1786705 | 2021-10-05 | Loudon | Tennessee | 47105 | 8866 | 90 |
1786706 | 1786706 | 2021-10-05 | Macon | Tennessee | 47111 | 5315 | 87 |
1786707 | 1786707 | 2021-10-05 | Madison | Tennessee | 47113 | 17177 | 297 |
1786708 | 1786708 | 2021-10-05 | Marion | Tennessee | 47115 | 5588 | 52 |
1786709 | 1786709 | 2021-10-05 | Marshall | Tennessee | 47117 | 6657 | 83 |
1786710 | 1786710 | 2021-10-05 | Maury | Tennessee | 47119 | 18856 | 216 |
1786711 | 1786711 | 2021-10-05 | McMinn | Tennessee | 47107 | 10168 | 120 |
1786712 | 1786712 | 2021-10-05 | McNairy | Tennessee | 47109 | 4471 | 65 |
1786713 | 1786713 | 2021-10-05 | Meigs | Tennessee | 47121 | 2111 | 27 |
1786714 | 1786714 | 2021-10-05 | Monroe | Tennessee | 47123 | 9390 | 116 |
1786715 | 1786715 | 2021-10-05 | Montgomery | Tennessee | 47125 | 31745 | 318 |
1786716 | 1786716 | 2021-10-05 | Moore | Tennessee | 47127 | 1403 | 19 |
1786717 | 1786717 | 2021-10-05 | Morgan | Tennessee | 47129 | 3638 | 46 |
1786718 | 1786718 | 2021-10-05 | Obion | Tennessee | 47131 | 6429 | 110 |
1786719 | 1786719 | 2021-10-05 | Overton | Tennessee | 47133 | 4639 | 78 |
1786720 | 1786720 | 2021-10-05 | Perry | Tennessee | 47135 | 1548 | 33 |
1786721 | 1786721 | 2021-10-05 | Pickett | Tennessee | 47137 | 1045 | 24 |
1786722 | 1786722 | 2021-10-05 | Polk | Tennessee | 47139 | 3075 | 27 |
1786723 | 1786723 | 2021-10-05 | Putnam | Tennessee | 47141 | 16287 | 208 |
1786724 | 1786724 | 2021-10-05 | Rhea | Tennessee | 47143 | 6767 | 89 |
1786725 | 1786725 | 2021-10-05 | Roane | Tennessee | 47145 | 9583 | 145 |
1786726 | 1786726 | 2021-10-05 | Robertson | Tennessee | 47147 | 13739 | 175 |
1786727 | 1786727 | 2021-10-05 | Rutherford | Tennessee | 47149 | 60203 | 521 |
1786728 | 1786728 | 2021-10-05 | Scott | Tennessee | 47151 | 4878 | 54 |
1786729 | 1786729 | 2021-10-05 | Sequatchie | Tennessee | 47153 | 2875 | 30 |
1786730 | 1786730 | 2021-10-05 | Sevier | Tennessee | 47155 | 19270 | 249 |
1786731 | 1786731 | 2021-10-05 | Shelby | Tennessee | 47157 | 142717 | 2142 |
1786732 | 1786732 | 2021-10-05 | Smith | Tennessee | 47159 | 4074 | 48 |
1786733 | 1786733 | 2021-10-05 | Stewart | Tennessee | 47161 | 2077 | 33 |
1786734 | 1786734 | 2021-10-05 | Sullivan | Tennessee | 47163 | 25626 | 398 |
1786735 | 1786735 | 2021-10-05 | Sumner | Tennessee | 47165 | 33342 | 403 |
1786736 | 1786736 | 2021-10-05 | Tipton | Tennessee | 47167 | 11037 | 126 |
1786737 | 1786737 | 2021-10-05 | Trousdale | Tennessee | 47169 | 3079 | 24 |
1786738 | 1786738 | 2021-10-05 | Unicoi | Tennessee | 47171 | 3053 | 59 |
1786739 | 1786739 | 2021-10-05 | Union | Tennessee | 47173 | 2916 | 42 |
1786740 | 1786740 | 2021-10-05 | Unknown | Tennessee | 9569 | 120 | |
1786741 | 1786741 | 2021-10-05 | Van Buren | Tennessee | 47175 | 1186 | 26 |
1786742 | 1786742 | 2021-10-05 | Warren | Tennessee | 47177 | 8317 | 106 |
1786743 | 1786743 | 2021-10-05 | Washington | Tennessee | 47179 | 20935 | 311 |
1786744 | 1786744 | 2021-10-05 | Wayne | Tennessee | 47181 | 3949 | 39 |
1786745 | 1786745 | 2021-10-05 | Weakley | Tennessee | 47183 | 6035 | 81 |
1786746 | 1786746 | 2021-10-05 | White | Tennessee | 47185 | 5411 | 91 |
1786747 | 1786747 | 2021-10-05 | Williamson | Tennessee | 47187 | 38606 | 261 |
1786748 | 1786748 | 2021-10-05 | Wilson | Tennessee | 47189 | 26405 | 320 |
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);