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-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329576 | 2329576 | 2022-03-21 | Anderson | Tennessee | 47001 | 22027 | 317 |
2329577 | 2329577 | 2022-03-21 | Bedford | Tennessee | 47003 | 14917 | 228 |
2329578 | 2329578 | 2022-03-21 | Benton | Tennessee | 47005 | 4466 | 90 |
2329579 | 2329579 | 2022-03-21 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2329580 | 2329580 | 2022-03-21 | Blount | Tennessee | 47009 | 38990 | 413 |
2329581 | 2329581 | 2022-03-21 | Bradley | Tennessee | 47011 | 33047 | 399 |
2329582 | 2329582 | 2022-03-21 | Campbell | Tennessee | 47013 | 12127 | 157 |
2329583 | 2329583 | 2022-03-21 | Cannon | Tennessee | 47015 | 4181 | 57 |
2329584 | 2329584 | 2022-03-21 | Carroll | Tennessee | 47017 | 8926 | 155 |
2329585 | 2329585 | 2022-03-21 | Carter | Tennessee | 47019 | 16416 | 323 |
2329586 | 2329586 | 2022-03-21 | Cheatham | Tennessee | 47021 | 10883 | 118 |
2329587 | 2329587 | 2022-03-21 | Chester | Tennessee | 47023 | 5798 | 96 |
2329588 | 2329588 | 2022-03-21 | Claiborne | Tennessee | 47025 | 9070 | 175 |
2329589 | 2329589 | 2022-03-21 | Clay | Tennessee | 47027 | 2223 | 49 |
2329590 | 2329590 | 2022-03-21 | Cocke | Tennessee | 47029 | 11534 | 207 |
2329591 | 2329591 | 2022-03-21 | Coffee | Tennessee | 47031 | 16916 | 255 |
2329592 | 2329592 | 2022-03-21 | Crockett | Tennessee | 47033 | 5169 | 82 |
2329593 | 2329593 | 2022-03-21 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2329594 | 2329594 | 2022-03-21 | Davidson | Tennessee | 47037 | 206711 | 1623 |
2329595 | 2329595 | 2022-03-21 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2329596 | 2329596 | 2022-03-21 | Decatur | Tennessee | 47039 | 3725 | 67 |
2329597 | 2329597 | 2022-03-21 | Dickson | Tennessee | 47043 | 15842 | 239 |
2329598 | 2329598 | 2022-03-21 | Dyer | Tennessee | 47045 | 12737 | 198 |
2329599 | 2329599 | 2022-03-21 | Fayette | Tennessee | 47047 | 11393 | 177 |
2329600 | 2329600 | 2022-03-21 | Fentress | Tennessee | 47049 | 5686 | 123 |
2329601 | 2329601 | 2022-03-21 | Franklin | Tennessee | 47051 | 12815 | 173 |
2329602 | 2329602 | 2022-03-21 | Gibson | Tennessee | 47053 | 17339 | 254 |
2329603 | 2329603 | 2022-03-21 | Giles | Tennessee | 47055 | 9390 | 185 |
2329604 | 2329604 | 2022-03-21 | Grainger | Tennessee | 47057 | 6754 | 106 |
2329605 | 2329605 | 2022-03-21 | Greene | Tennessee | 47059 | 21992 | 360 |
2329606 | 2329606 | 2022-03-21 | Grundy | Tennessee | 47061 | 3979 | 70 |
2329607 | 2329607 | 2022-03-21 | Hamblen | Tennessee | 47063 | 19671 | 346 |
2329608 | 2329608 | 2022-03-21 | Hamilton | Tennessee | 47065 | 99400 | 1113 |
2329609 | 2329609 | 2022-03-21 | Hancock | Tennessee | 47067 | 2001 | 34 |
2329610 | 2329610 | 2022-03-21 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2329611 | 2329611 | 2022-03-21 | Hardin | Tennessee | 47071 | 8717 | 140 |
2329612 | 2329612 | 2022-03-21 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2329613 | 2329613 | 2022-03-21 | Haywood | Tennessee | 47075 | 6147 | 99 |
2329614 | 2329614 | 2022-03-21 | Henderson | Tennessee | 47077 | 9087 | 153 |
2329615 | 2329615 | 2022-03-21 | Henry | Tennessee | 47079 | 8237 | 154 |
2329616 | 2329616 | 2022-03-21 | Hickman | Tennessee | 47081 | 6811 | 108 |
2329617 | 2329617 | 2022-03-21 | Houston | Tennessee | 47083 | 2672 | 60 |
2329618 | 2329618 | 2022-03-21 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2329619 | 2329619 | 2022-03-21 | Jackson | Tennessee | 47087 | 3200 | 62 |
2329620 | 2329620 | 2022-03-21 | Jefferson | Tennessee | 47089 | 15674 | 257 |
2329621 | 2329621 | 2022-03-21 | Johnson | Tennessee | 47091 | 5132 | 88 |
2329622 | 2329622 | 2022-03-21 | Knox | Tennessee | 47093 | 127369 | 1318 |
2329623 | 2329623 | 2022-03-21 | Lake | Tennessee | 47095 | 2736 | 40 |
2329624 | 2329624 | 2022-03-21 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2329625 | 2329625 | 2022-03-21 | Lawrence | Tennessee | 47099 | 14249 | 190 |
2329626 | 2329626 | 2022-03-21 | Lewis | Tennessee | 47101 | 3568 | 56 |
2329627 | 2329627 | 2022-03-21 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2329628 | 2329628 | 2022-03-21 | Loudon | Tennessee | 47105 | 14399 | 187 |
2329629 | 2329629 | 2022-03-21 | Macon | Tennessee | 47111 | 8417 | 142 |
2329630 | 2329630 | 2022-03-21 | Madison | Tennessee | 47113 | 29729 | 415 |
2329631 | 2329631 | 2022-03-21 | Marion | Tennessee | 47115 | 8821 | 127 |
2329632 | 2329632 | 2022-03-21 | Marshall | Tennessee | 47117 | 10343 | 117 |
2329633 | 2329633 | 2022-03-21 | Maury | Tennessee | 47119 | 28852 | 327 |
2329634 | 2329634 | 2022-03-21 | McMinn | Tennessee | 47107 | 16646 | 250 |
2329635 | 2329635 | 2022-03-21 | McNairy | Tennessee | 47109 | 7627 | 117 |
2329636 | 2329636 | 2022-03-21 | Meigs | Tennessee | 47121 | 3349 | 55 |
2329637 | 2329637 | 2022-03-21 | Monroe | Tennessee | 47123 | 14460 | 233 |
2329638 | 2329638 | 2022-03-21 | Montgomery | Tennessee | 47125 | 50043 | 556 |
2329639 | 2329639 | 2022-03-21 | Moore | Tennessee | 47127 | 2236 | 40 |
2329640 | 2329640 | 2022-03-21 | Morgan | Tennessee | 47129 | 6151 | 80 |
2329641 | 2329641 | 2022-03-21 | Obion | Tennessee | 47131 | 10750 | 185 |
2329642 | 2329642 | 2022-03-21 | Overton | Tennessee | 47133 | 7145 | 120 |
2329643 | 2329643 | 2022-03-21 | Perry | Tennessee | 47135 | 2327 | 54 |
2329644 | 2329644 | 2022-03-21 | Pickett | Tennessee | 47137 | 1764 | 36 |
2329645 | 2329645 | 2022-03-21 | Polk | Tennessee | 47139 | 4715 | 68 |
2329646 | 2329646 | 2022-03-21 | Putnam | Tennessee | 47141 | 25056 | 301 |
2329647 | 2329647 | 2022-03-21 | Rhea | Tennessee | 47143 | 9941 | 153 |
2329648 | 2329648 | 2022-03-21 | Roane | Tennessee | 47145 | 15740 | 228 |
2329649 | 2329649 | 2022-03-21 | Robertson | Tennessee | 47147 | 21488 | 295 |
2329650 | 2329650 | 2022-03-21 | Rutherford | Tennessee | 47149 | 95446 | 875 |
2329651 | 2329651 | 2022-03-21 | Scott | Tennessee | 47151 | 9018 | 112 |
2329652 | 2329652 | 2022-03-21 | Sequatchie | Tennessee | 47153 | 4200 | 66 |
2329653 | 2329653 | 2022-03-21 | Sevier | Tennessee | 47155 | 30214 | 398 |
2329654 | 2329654 | 2022-03-21 | Shelby | Tennessee | 47157 | 237420 | 3219 |
2329655 | 2329655 | 2022-03-21 | Smith | Tennessee | 47159 | 6159 | 80 |
2329656 | 2329656 | 2022-03-21 | Stewart | Tennessee | 47161 | 3281 | 55 |
2329657 | 2329657 | 2022-03-21 | Sullivan | Tennessee | 47163 | 45622 | 688 |
2329658 | 2329658 | 2022-03-21 | Sumner | Tennessee | 47165 | 53026 | 707 |
2329659 | 2329659 | 2022-03-21 | Tipton | Tennessee | 47167 | 17578 | 230 |
2329660 | 2329660 | 2022-03-21 | Trousdale | Tennessee | 47169 | 4208 | 45 |
2329661 | 2329661 | 2022-03-21 | Unicoi | Tennessee | 47171 | 5147 | 93 |
2329662 | 2329662 | 2022-03-21 | Union | Tennessee | 47173 | 5392 | 72 |
2329663 | 2329663 | 2022-03-21 | Unknown | Tennessee | 19255 | 423 | |
2329664 | 2329664 | 2022-03-21 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2329665 | 2329665 | 2022-03-21 | Warren | Tennessee | 47177 | 12975 | 174 |
2329666 | 2329666 | 2022-03-21 | Washington | Tennessee | 47179 | 38408 | 482 |
2329667 | 2329667 | 2022-03-21 | Wayne | Tennessee | 47181 | 5682 | 62 |
2329668 | 2329668 | 2022-03-21 | Weakley | Tennessee | 47183 | 9489 | 140 |
2329669 | 2329669 | 2022-03-21 | White | Tennessee | 47185 | 8221 | 126 |
2329670 | 2329670 | 2022-03-21 | Williamson | Tennessee | 47187 | 61783 | 393 |
2329671 | 2329671 | 2022-03-21 | Wilson | Tennessee | 47189 | 41503 | 471 |
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);