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-03-25 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342590 | 2342590 | 2022-03-25 | Anderson | Tennessee | 47001 | 22047 | 321 |
2342591 | 2342591 | 2022-03-25 | Bedford | Tennessee | 47003 | 14933 | 230 |
2342592 | 2342592 | 2022-03-25 | Benton | Tennessee | 47005 | 4471 | 90 |
2342593 | 2342593 | 2022-03-25 | Bledsoe | Tennessee | 47007 | 4652 | 56 |
2342594 | 2342594 | 2022-03-25 | Blount | Tennessee | 47009 | 39027 | 418 |
2342595 | 2342595 | 2022-03-25 | Bradley | Tennessee | 47011 | 33065 | 402 |
2342596 | 2342596 | 2022-03-25 | Campbell | Tennessee | 47013 | 12204 | 160 |
2342597 | 2342597 | 2022-03-25 | Cannon | Tennessee | 47015 | 4187 | 58 |
2342598 | 2342598 | 2022-03-25 | Carroll | Tennessee | 47017 | 8940 | 155 |
2342599 | 2342599 | 2022-03-25 | Carter | Tennessee | 47019 | 16432 | 328 |
2342600 | 2342600 | 2022-03-25 | Cheatham | Tennessee | 47021 | 10896 | 119 |
2342601 | 2342601 | 2022-03-25 | Chester | Tennessee | 47023 | 5823 | 96 |
2342602 | 2342602 | 2022-03-25 | Claiborne | Tennessee | 47025 | 9084 | 176 |
2342603 | 2342603 | 2022-03-25 | Clay | Tennessee | 47027 | 2224 | 49 |
2342604 | 2342604 | 2022-03-25 | Cocke | Tennessee | 47029 | 11553 | 209 |
2342605 | 2342605 | 2022-03-25 | Coffee | Tennessee | 47031 | 16925 | 261 |
2342606 | 2342606 | 2022-03-25 | Crockett | Tennessee | 47033 | 5171 | 84 |
2342607 | 2342607 | 2022-03-25 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2342608 | 2342608 | 2022-03-25 | Davidson | Tennessee | 47037 | 206889 | 1631 |
2342609 | 2342609 | 2022-03-25 | DeKalb | Tennessee | 47041 | 6276 | 100 |
2342610 | 2342610 | 2022-03-25 | Decatur | Tennessee | 47039 | 3726 | 67 |
2342611 | 2342611 | 2022-03-25 | Dickson | Tennessee | 47043 | 15853 | 240 |
2342612 | 2342612 | 2022-03-25 | Dyer | Tennessee | 47045 | 12764 | 199 |
2342613 | 2342613 | 2022-03-25 | Fayette | Tennessee | 47047 | 11395 | 180 |
2342614 | 2342614 | 2022-03-25 | Fentress | Tennessee | 47049 | 5691 | 125 |
2342615 | 2342615 | 2022-03-25 | Franklin | Tennessee | 47051 | 12829 | 176 |
2342616 | 2342616 | 2022-03-25 | Gibson | Tennessee | 47053 | 17366 | 254 |
2342617 | 2342617 | 2022-03-25 | Giles | Tennessee | 47055 | 9397 | 186 |
2342618 | 2342618 | 2022-03-25 | Grainger | Tennessee | 47057 | 6765 | 107 |
2342619 | 2342619 | 2022-03-25 | Greene | Tennessee | 47059 | 22029 | 363 |
2342620 | 2342620 | 2022-03-25 | Grundy | Tennessee | 47061 | 3980 | 71 |
2342621 | 2342621 | 2022-03-25 | Hamblen | Tennessee | 47063 | 19679 | 347 |
2342622 | 2342622 | 2022-03-25 | Hamilton | Tennessee | 47065 | 99558 | 1116 |
2342623 | 2342623 | 2022-03-25 | Hancock | Tennessee | 47067 | 2002 | 34 |
2342624 | 2342624 | 2022-03-25 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2342625 | 2342625 | 2022-03-25 | Hardin | Tennessee | 47071 | 8732 | 141 |
2342626 | 2342626 | 2022-03-25 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2342627 | 2342627 | 2022-03-25 | Haywood | Tennessee | 47075 | 6150 | 99 |
2342628 | 2342628 | 2022-03-25 | Henderson | Tennessee | 47077 | 9094 | 154 |
2342629 | 2342629 | 2022-03-25 | Henry | Tennessee | 47079 | 8244 | 154 |
2342630 | 2342630 | 2022-03-25 | Hickman | Tennessee | 47081 | 6815 | 108 |
2342631 | 2342631 | 2022-03-25 | Houston | Tennessee | 47083 | 2673 | 60 |
2342632 | 2342632 | 2022-03-25 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2342633 | 2342633 | 2022-03-25 | Jackson | Tennessee | 47087 | 3202 | 62 |
2342634 | 2342634 | 2022-03-25 | Jefferson | Tennessee | 47089 | 15692 | 259 |
2342635 | 2342635 | 2022-03-25 | Johnson | Tennessee | 47091 | 5139 | 88 |
2342636 | 2342636 | 2022-03-25 | Knox | Tennessee | 47093 | 127542 | 1335 |
2342637 | 2342637 | 2022-03-25 | Lake | Tennessee | 47095 | 2737 | 40 |
2342638 | 2342638 | 2022-03-25 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2342639 | 2342639 | 2022-03-25 | Lawrence | Tennessee | 47099 | 14258 | 191 |
2342640 | 2342640 | 2022-03-25 | Lewis | Tennessee | 47101 | 3568 | 57 |
2342641 | 2342641 | 2022-03-25 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2342642 | 2342642 | 2022-03-25 | Loudon | Tennessee | 47105 | 14424 | 188 |
2342643 | 2342643 | 2022-03-25 | Macon | Tennessee | 47111 | 8422 | 145 |
2342644 | 2342644 | 2022-03-25 | Madison | Tennessee | 47113 | 29784 | 418 |
2342645 | 2342645 | 2022-03-25 | Marion | Tennessee | 47115 | 8833 | 127 |
2342646 | 2342646 | 2022-03-25 | Marshall | Tennessee | 47117 | 10351 | 119 |
2342647 | 2342647 | 2022-03-25 | Maury | Tennessee | 47119 | 28867 | 330 |
2342648 | 2342648 | 2022-03-25 | McMinn | Tennessee | 47107 | 16652 | 251 |
2342649 | 2342649 | 2022-03-25 | McNairy | Tennessee | 47109 | 7629 | 118 |
2342650 | 2342650 | 2022-03-25 | Meigs | Tennessee | 47121 | 3351 | 55 |
2342651 | 2342651 | 2022-03-25 | Monroe | Tennessee | 47123 | 14482 | 235 |
2342652 | 2342652 | 2022-03-25 | Montgomery | Tennessee | 47125 | 50080 | 561 |
2342653 | 2342653 | 2022-03-25 | Moore | Tennessee | 47127 | 2237 | 40 |
2342654 | 2342654 | 2022-03-25 | Morgan | Tennessee | 47129 | 6158 | 80 |
2342655 | 2342655 | 2022-03-25 | Obion | Tennessee | 47131 | 10753 | 187 |
2342656 | 2342656 | 2022-03-25 | Overton | Tennessee | 47133 | 7147 | 121 |
2342657 | 2342657 | 2022-03-25 | Perry | Tennessee | 47135 | 2328 | 55 |
2342658 | 2342658 | 2022-03-25 | Pickett | Tennessee | 47137 | 1764 | 36 |
2342659 | 2342659 | 2022-03-25 | Polk | Tennessee | 47139 | 4722 | 70 |
2342660 | 2342660 | 2022-03-25 | Putnam | Tennessee | 47141 | 25068 | 302 |
2342661 | 2342661 | 2022-03-25 | Rhea | Tennessee | 47143 | 9959 | 154 |
2342662 | 2342662 | 2022-03-25 | Roane | Tennessee | 47145 | 15764 | 231 |
2342663 | 2342663 | 2022-03-25 | Robertson | Tennessee | 47147 | 21503 | 295 |
2342664 | 2342664 | 2022-03-25 | Rutherford | Tennessee | 47149 | 95505 | 879 |
2342665 | 2342665 | 2022-03-25 | Scott | Tennessee | 47151 | 9029 | 115 |
2342666 | 2342666 | 2022-03-25 | Sequatchie | Tennessee | 47153 | 4204 | 66 |
2342667 | 2342667 | 2022-03-25 | Sevier | Tennessee | 47155 | 30246 | 401 |
2342668 | 2342668 | 2022-03-25 | Shelby | Tennessee | 47157 | 237514 | 3232 |
2342669 | 2342669 | 2022-03-25 | Smith | Tennessee | 47159 | 6157 | 83 |
2342670 | 2342670 | 2022-03-25 | Stewart | Tennessee | 47161 | 3283 | 56 |
2342671 | 2342671 | 2022-03-25 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2342672 | 2342672 | 2022-03-25 | Sumner | Tennessee | 47165 | 53057 | 713 |
2342673 | 2342673 | 2022-03-25 | Tipton | Tennessee | 47167 | 17588 | 230 |
2342674 | 2342674 | 2022-03-25 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2342675 | 2342675 | 2022-03-25 | Unicoi | Tennessee | 47171 | 5156 | 94 |
2342676 | 2342676 | 2022-03-25 | Union | Tennessee | 47173 | 5393 | 72 |
2342677 | 2342677 | 2022-03-25 | Unknown | Tennessee | 18929 | 306 | |
2342678 | 2342678 | 2022-03-25 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2342679 | 2342679 | 2022-03-25 | Warren | Tennessee | 47177 | 12982 | 175 |
2342680 | 2342680 | 2022-03-25 | Washington | Tennessee | 47179 | 38465 | 486 |
2342681 | 2342681 | 2022-03-25 | Wayne | Tennessee | 47181 | 5687 | 63 |
2342682 | 2342682 | 2022-03-25 | Weakley | Tennessee | 47183 | 9491 | 140 |
2342683 | 2342683 | 2022-03-25 | White | Tennessee | 47185 | 8224 | 127 |
2342684 | 2342684 | 2022-03-25 | Williamson | Tennessee | 47187 | 61839 | 395 |
2342685 | 2342685 | 2022-03-25 | Wilson | Tennessee | 47189 | 41556 | 475 |
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);