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-09-23 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1747665 | 1747665 | 2021-09-23 | Anderson | Tennessee | 47001 | 11992 | 192 |
1747666 | 1747666 | 2021-09-23 | Bedford | Tennessee | 47003 | 8568 | 142 |
1747667 | 1747667 | 2021-09-23 | Benton | Tennessee | 47005 | 2546 | 44 |
1747668 | 1747668 | 2021-09-23 | Bledsoe | Tennessee | 47007 | 3275 | 13 |
1747669 | 1747669 | 2021-09-23 | Blount | Tennessee | 47009 | 22104 | 235 |
1747670 | 1747670 | 2021-09-23 | Bradley | Tennessee | 47011 | 21057 | 169 |
1747671 | 1747671 | 2021-09-23 | Campbell | Tennessee | 47013 | 6072 | 70 |
1747672 | 1747672 | 2021-09-23 | Cannon | Tennessee | 47015 | 2666 | 38 |
1747673 | 1747673 | 2021-09-23 | Carroll | Tennessee | 47017 | 5311 | 94 |
1747674 | 1747674 | 2021-09-23 | Carter | Tennessee | 47019 | 9800 | 202 |
1747675 | 1747675 | 2021-09-23 | Cheatham | Tennessee | 47021 | 6581 | 61 |
1747676 | 1747676 | 2021-09-23 | Chester | Tennessee | 47023 | 3318 | 65 |
1747677 | 1747677 | 2021-09-23 | Claiborne | Tennessee | 47025 | 4896 | 85 |
1747678 | 1747678 | 2021-09-23 | Clay | Tennessee | 47027 | 1400 | 35 |
1747679 | 1747679 | 2021-09-23 | Cocke | Tennessee | 47029 | 6712 | 104 |
1747680 | 1747680 | 2021-09-23 | Coffee | Tennessee | 47031 | 9898 | 141 |
1747681 | 1747681 | 2021-09-23 | Crockett | Tennessee | 47033 | 3207 | 58 |
1747682 | 1747682 | 2021-09-23 | Cumberland | Tennessee | 47035 | 10292 | 190 |
1747683 | 1747683 | 2021-09-23 | Davidson | Tennessee | 47037 | 125537 | 1078 |
1747684 | 1747684 | 2021-09-23 | DeKalb | Tennessee | 47041 | 3970 | 60 |
1747685 | 1747685 | 2021-09-23 | Decatur | Tennessee | 47039 | 2286 | 42 |
1747686 | 1747686 | 2021-09-23 | Dickson | Tennessee | 47043 | 9737 | 154 |
1747687 | 1747687 | 2021-09-23 | Dyer | Tennessee | 47045 | 7764 | 130 |
1747688 | 1747688 | 2021-09-23 | Fayette | Tennessee | 47047 | 6938 | 95 |
1747689 | 1747689 | 2021-09-23 | Fentress | Tennessee | 47049 | 3324 | 58 |
1747690 | 1747690 | 2021-09-23 | Franklin | Tennessee | 47051 | 7503 | 96 |
1747691 | 1747691 | 2021-09-23 | Gibson | Tennessee | 47053 | 10108 | 177 |
1747692 | 1747692 | 2021-09-23 | Giles | Tennessee | 47055 | 5519 | 107 |
1747693 | 1747693 | 2021-09-23 | Grainger | Tennessee | 47057 | 3988 | 57 |
1747694 | 1747694 | 2021-09-23 | Greene | Tennessee | 47059 | 12228 | 209 |
1747695 | 1747695 | 2021-09-23 | Grundy | Tennessee | 47061 | 2589 | 36 |
1747696 | 1747696 | 2021-09-23 | Hamblen | Tennessee | 47063 | 12364 | 186 |
1747697 | 1747697 | 2021-09-23 | Hamilton | Tennessee | 47065 | 60750 | 612 |
1747698 | 1747698 | 2021-09-23 | Hancock | Tennessee | 47067 | 1063 | 15 |
1747699 | 1747699 | 2021-09-23 | Hardeman | Tennessee | 47069 | 4884 | 75 |
1747700 | 1747700 | 2021-09-23 | Hardin | Tennessee | 47071 | 5221 | 78 |
1747701 | 1747701 | 2021-09-23 | Hawkins | Tennessee | 47073 | 9420 | 144 |
1747702 | 1747702 | 2021-09-23 | Haywood | Tennessee | 47075 | 3669 | 69 |
1747703 | 1747703 | 2021-09-23 | Henderson | Tennessee | 47077 | 5326 | 88 |
1747704 | 1747704 | 2021-09-23 | Henry | Tennessee | 47079 | 5201 | 79 |
1747705 | 1747705 | 2021-09-23 | Hickman | Tennessee | 47081 | 4367 | 65 |
1747706 | 1747706 | 2021-09-23 | Houston | Tennessee | 47083 | 1735 | 40 |
1747707 | 1747707 | 2021-09-23 | Humphreys | Tennessee | 47085 | 2907 | 43 |
1747708 | 1747708 | 2021-09-23 | Jackson | Tennessee | 47087 | 1921 | 38 |
1747709 | 1747709 | 2021-09-23 | Jefferson | Tennessee | 47089 | 9269 | 134 |
1747710 | 1747710 | 2021-09-23 | Johnson | Tennessee | 47091 | 3252 | 45 |
1747711 | 1747711 | 2021-09-23 | Knox | Tennessee | 47093 | 73018 | 808 |
1747712 | 1747712 | 2021-09-23 | Lake | Tennessee | 47095 | 1936 | 31 |
1747713 | 1747713 | 2021-09-23 | Lauderdale | Tennessee | 47097 | 4975 | 59 |
1747714 | 1747714 | 2021-09-23 | Lawrence | Tennessee | 47099 | 8937 | 109 |
1747715 | 1747715 | 2021-09-23 | Lewis | Tennessee | 47101 | 2437 | 33 |
1747716 | 1747716 | 2021-09-23 | Lincoln | Tennessee | 47103 | 6269 | 78 |
1747717 | 1747717 | 2021-09-23 | Loudon | Tennessee | 47105 | 8608 | 85 |
1747718 | 1747718 | 2021-09-23 | Macon | Tennessee | 47111 | 5183 | 85 |
1747719 | 1747719 | 2021-09-23 | Madison | Tennessee | 47113 | 16849 | 284 |
1747720 | 1747720 | 2021-09-23 | Marion | Tennessee | 47115 | 5441 | 52 |
1747721 | 1747721 | 2021-09-23 | Marshall | Tennessee | 47117 | 6473 | 73 |
1747722 | 1747722 | 2021-09-23 | Maury | Tennessee | 47119 | 18391 | 205 |
1747723 | 1747723 | 2021-09-23 | McMinn | Tennessee | 47107 | 9930 | 115 |
1747724 | 1747724 | 2021-09-23 | McNairy | Tennessee | 47109 | 4331 | 62 |
1747725 | 1747725 | 2021-09-23 | Meigs | Tennessee | 47121 | 2059 | 25 |
1747726 | 1747726 | 2021-09-23 | Monroe | Tennessee | 47123 | 9117 | 112 |
1747727 | 1747727 | 2021-09-23 | Montgomery | Tennessee | 47125 | 30722 | 299 |
1747728 | 1747728 | 2021-09-23 | Moore | Tennessee | 47127 | 1359 | 19 |
1747729 | 1747729 | 2021-09-23 | Morgan | Tennessee | 47129 | 3487 | 43 |
1747730 | 1747730 | 2021-09-23 | Obion | Tennessee | 47131 | 6247 | 105 |
1747731 | 1747731 | 2021-09-23 | Overton | Tennessee | 47133 | 4430 | 75 |
1747732 | 1747732 | 2021-09-23 | Perry | Tennessee | 47135 | 1510 | 31 |
1747733 | 1747733 | 2021-09-23 | Pickett | Tennessee | 47137 | 982 | 24 |
1747734 | 1747734 | 2021-09-23 | Polk | Tennessee | 47139 | 2974 | 25 |
1747735 | 1747735 | 2021-09-23 | Putnam | Tennessee | 47141 | 15892 | 206 |
1747736 | 1747736 | 2021-09-23 | Rhea | Tennessee | 47143 | 6550 | 89 |
1747737 | 1747737 | 2021-09-23 | Roane | Tennessee | 47145 | 9230 | 136 |
1747738 | 1747738 | 2021-09-23 | Robertson | Tennessee | 47147 | 13394 | 170 |
1747739 | 1747739 | 2021-09-23 | Rutherford | Tennessee | 47149 | 58882 | 500 |
1747740 | 1747740 | 2021-09-23 | Scott | Tennessee | 47151 | 4600 | 54 |
1747741 | 1747741 | 2021-09-23 | Sequatchie | Tennessee | 47153 | 2800 | 30 |
1747742 | 1747742 | 2021-09-23 | Sevier | Tennessee | 47155 | 18630 | 235 |
1747743 | 1747743 | 2021-09-23 | Shelby | Tennessee | 47157 | 139496 | 2030 |
1747744 | 1747744 | 2021-09-23 | Smith | Tennessee | 47159 | 3968 | 44 |
1747745 | 1747745 | 2021-09-23 | Stewart | Tennessee | 47161 | 1968 | 30 |
1747746 | 1747746 | 2021-09-23 | Sullivan | Tennessee | 47163 | 24733 | 383 |
1747747 | 1747747 | 2021-09-23 | Sumner | Tennessee | 47165 | 32636 | 393 |
1747748 | 1747748 | 2021-09-23 | Tipton | Tennessee | 47167 | 10752 | 123 |
1747749 | 1747749 | 2021-09-23 | Trousdale | Tennessee | 47169 | 3001 | 24 |
1747750 | 1747750 | 2021-09-23 | Unicoi | Tennessee | 47171 | 2956 | 56 |
1747751 | 1747751 | 2021-09-23 | Union | Tennessee | 47173 | 2747 | 38 |
1747752 | 1747752 | 2021-09-23 | Unknown | Tennessee | 8122 | 111 | |
1747753 | 1747753 | 2021-09-23 | Van Buren | Tennessee | 47175 | 1149 | 25 |
1747754 | 1747754 | 2021-09-23 | Warren | Tennessee | 47177 | 8020 | 101 |
1747755 | 1747755 | 2021-09-23 | Washington | Tennessee | 47179 | 20307 | 298 |
1747756 | 1747756 | 2021-09-23 | Wayne | Tennessee | 47181 | 3851 | 38 |
1747757 | 1747757 | 2021-09-23 | Weakley | Tennessee | 47183 | 5880 | 77 |
1747758 | 1747758 | 2021-09-23 | White | Tennessee | 47185 | 5234 | 85 |
1747759 | 1747759 | 2021-09-23 | Williamson | Tennessee | 47187 | 37656 | 253 |
1747760 | 1747760 | 2021-09-23 | Wilson | Tennessee | 47189 | 25746 | 309 |
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);