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-01 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264525 | 2264525 | 2022-03-01 | Anderson | Tennessee | 47001 | 21724 | 303 |
2264526 | 2264526 | 2022-03-01 | Bedford | Tennessee | 47003 | 14826 | 218 |
2264527 | 2264527 | 2022-03-01 | Benton | Tennessee | 47005 | 4386 | 85 |
2264528 | 2264528 | 2022-03-01 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2264529 | 2264529 | 2022-03-01 | Blount | Tennessee | 47009 | 38653 | 387 |
2264530 | 2264530 | 2022-03-01 | Bradley | Tennessee | 47011 | 32832 | 376 |
2264531 | 2264531 | 2022-03-01 | Campbell | Tennessee | 47013 | 11694 | 145 |
2264532 | 2264532 | 2022-03-01 | Cannon | Tennessee | 47015 | 4133 | 55 |
2264533 | 2264533 | 2022-03-01 | Carroll | Tennessee | 47017 | 8811 | 145 |
2264534 | 2264534 | 2022-03-01 | Carter | Tennessee | 47019 | 16164 | 305 |
2264535 | 2264535 | 2022-03-01 | Cheatham | Tennessee | 47021 | 10818 | 113 |
2264536 | 2264536 | 2022-03-01 | Chester | Tennessee | 47023 | 5685 | 90 |
2264537 | 2264537 | 2022-03-01 | Claiborne | Tennessee | 47025 | 8780 | 159 |
2264538 | 2264538 | 2022-03-01 | Clay | Tennessee | 47027 | 2207 | 46 |
2264539 | 2264539 | 2022-03-01 | Cocke | Tennessee | 47029 | 11172 | 201 |
2264540 | 2264540 | 2022-03-01 | Coffee | Tennessee | 47031 | 16777 | 237 |
2264541 | 2264541 | 2022-03-01 | Crockett | Tennessee | 47033 | 5008 | 81 |
2264542 | 2264542 | 2022-03-01 | Cumberland | Tennessee | 47035 | 15886 | 303 |
2264543 | 2264543 | 2022-03-01 | Davidson | Tennessee | 47037 | 205570 | 1568 |
2264544 | 2264544 | 2022-03-01 | DeKalb | Tennessee | 47041 | 6223 | 96 |
2264545 | 2264545 | 2022-03-01 | Decatur | Tennessee | 47039 | 3618 | 61 |
2264546 | 2264546 | 2022-03-01 | Dickson | Tennessee | 47043 | 15730 | 228 |
2264547 | 2264547 | 2022-03-01 | Dyer | Tennessee | 47045 | 12544 | 185 |
2264548 | 2264548 | 2022-03-01 | Fayette | Tennessee | 47047 | 11323 | 163 |
2264549 | 2264549 | 2022-03-01 | Fentress | Tennessee | 47049 | 5640 | 114 |
2264550 | 2264550 | 2022-03-01 | Franklin | Tennessee | 47051 | 12724 | 164 |
2264551 | 2264551 | 2022-03-01 | Gibson | Tennessee | 47053 | 17074 | 247 |
2264552 | 2264552 | 2022-03-01 | Giles | Tennessee | 47055 | 9342 | 166 |
2264553 | 2264553 | 2022-03-01 | Grainger | Tennessee | 47057 | 6688 | 101 |
2264554 | 2264554 | 2022-03-01 | Greene | Tennessee | 47059 | 21773 | 340 |
2264555 | 2264555 | 2022-03-01 | Grundy | Tennessee | 47061 | 3947 | 68 |
2264556 | 2264556 | 2022-03-01 | Hamblen | Tennessee | 47063 | 19502 | 336 |
2264557 | 2264557 | 2022-03-01 | Hamilton | Tennessee | 47065 | 97442 | 1074 |
2264558 | 2264558 | 2022-03-01 | Hancock | Tennessee | 47067 | 1966 | 30 |
2264559 | 2264559 | 2022-03-01 | Hardeman | Tennessee | 47069 | 7373 | 113 |
2264560 | 2264560 | 2022-03-01 | Hardin | Tennessee | 47071 | 8518 | 128 |
2264561 | 2264561 | 2022-03-01 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2264562 | 2264562 | 2022-03-01 | Haywood | Tennessee | 47075 | 6081 | 95 |
2264563 | 2264563 | 2022-03-01 | Henderson | Tennessee | 47077 | 8798 | 143 |
2264564 | 2264564 | 2022-03-01 | Henry | Tennessee | 47079 | 8050 | 140 |
2264565 | 2264565 | 2022-03-01 | Hickman | Tennessee | 47081 | 6769 | 103 |
2264566 | 2264566 | 2022-03-01 | Houston | Tennessee | 47083 | 2644 | 59 |
2264567 | 2264567 | 2022-03-01 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2264568 | 2264568 | 2022-03-01 | Jackson | Tennessee | 47087 | 3163 | 58 |
2264569 | 2264569 | 2022-03-01 | Jefferson | Tennessee | 47089 | 15485 | 249 |
2264570 | 2264570 | 2022-03-01 | Johnson | Tennessee | 47091 | 5047 | 77 |
2264571 | 2264571 | 2022-03-01 | Knox | Tennessee | 47093 | 126007 | 1257 |
2264572 | 2264572 | 2022-03-01 | Lake | Tennessee | 47095 | 2670 | 38 |
2264573 | 2264573 | 2022-03-01 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2264574 | 2264574 | 2022-03-01 | Lawrence | Tennessee | 47099 | 14166 | 175 |
2264575 | 2264575 | 2022-03-01 | Lewis | Tennessee | 47101 | 3550 | 50 |
2264576 | 2264576 | 2022-03-01 | Lincoln | Tennessee | 47103 | 9882 | 145 |
2264577 | 2264577 | 2022-03-01 | Loudon | Tennessee | 47105 | 14250 | 180 |
2264578 | 2264578 | 2022-03-01 | Macon | Tennessee | 47111 | 8340 | 138 |
2264579 | 2264579 | 2022-03-01 | Madison | Tennessee | 47113 | 29127 | 397 |
2264580 | 2264580 | 2022-03-01 | Marion | Tennessee | 47115 | 8745 | 121 |
2264581 | 2264581 | 2022-03-01 | Marshall | Tennessee | 47117 | 10269 | 115 |
2264582 | 2264582 | 2022-03-01 | Maury | Tennessee | 47119 | 28685 | 312 |
2264583 | 2264583 | 2022-03-01 | McMinn | Tennessee | 47107 | 16540 | 232 |
2264584 | 2264584 | 2022-03-01 | McNairy | Tennessee | 47109 | 7464 | 100 |
2264585 | 2264585 | 2022-03-01 | Meigs | Tennessee | 47121 | 3323 | 51 |
2264586 | 2264586 | 2022-03-01 | Monroe | Tennessee | 47123 | 14312 | 216 |
2264587 | 2264587 | 2022-03-01 | Montgomery | Tennessee | 47125 | 49416 | 531 |
2264588 | 2264588 | 2022-03-01 | Moore | Tennessee | 47127 | 2208 | 37 |
2264589 | 2264589 | 2022-03-01 | Morgan | Tennessee | 47129 | 5965 | 75 |
2264590 | 2264590 | 2022-03-01 | Obion | Tennessee | 47131 | 10659 | 168 |
2264591 | 2264591 | 2022-03-01 | Overton | Tennessee | 47133 | 7092 | 118 |
2264592 | 2264592 | 2022-03-01 | Perry | Tennessee | 47135 | 2292 | 46 |
2264593 | 2264593 | 2022-03-01 | Pickett | Tennessee | 47137 | 1753 | 30 |
2264594 | 2264594 | 2022-03-01 | Polk | Tennessee | 47139 | 4624 | 56 |
2264595 | 2264595 | 2022-03-01 | Putnam | Tennessee | 47141 | 24841 | 291 |
2264596 | 2264596 | 2022-03-01 | Rhea | Tennessee | 47143 | 9890 | 148 |
2264597 | 2264597 | 2022-03-01 | Roane | Tennessee | 47145 | 15588 | 217 |
2264598 | 2264598 | 2022-03-01 | Robertson | Tennessee | 47147 | 21356 | 284 |
2264599 | 2264599 | 2022-03-01 | Rutherford | Tennessee | 47149 | 94737 | 851 |
2264600 | 2264600 | 2022-03-01 | Scott | Tennessee | 47151 | 8816 | 105 |
2264601 | 2264601 | 2022-03-01 | Sequatchie | Tennessee | 47153 | 4165 | 64 |
2264602 | 2264602 | 2022-03-01 | Sevier | Tennessee | 47155 | 29882 | 383 |
2264603 | 2264603 | 2022-03-01 | Shelby | Tennessee | 47157 | 236607 | 3136 |
2264604 | 2264604 | 2022-03-01 | Smith | Tennessee | 47159 | 6102 | 73 |
2264605 | 2264605 | 2022-03-01 | Stewart | Tennessee | 47161 | 3253 | 48 |
2264606 | 2264606 | 2022-03-01 | Sullivan | Tennessee | 47163 | 44990 | 642 |
2264607 | 2264607 | 2022-03-01 | Sumner | Tennessee | 47165 | 52623 | 682 |
2264608 | 2264608 | 2022-03-01 | Tipton | Tennessee | 47167 | 17460 | 209 |
2264609 | 2264609 | 2022-03-01 | Trousdale | Tennessee | 47169 | 4188 | 44 |
2264610 | 2264610 | 2022-03-01 | Unicoi | Tennessee | 47171 | 5073 | 88 |
2264611 | 2264611 | 2022-03-01 | Union | Tennessee | 47173 | 5332 | 69 |
2264612 | 2264612 | 2022-03-01 | Unknown | Tennessee | 27283 | 666 | |
2264613 | 2264613 | 2022-03-01 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2264614 | 2264614 | 2022-03-01 | Warren | Tennessee | 47177 | 12892 | 163 |
2264615 | 2264615 | 2022-03-01 | Washington | Tennessee | 47179 | 37964 | 461 |
2264616 | 2264616 | 2022-03-01 | Wayne | Tennessee | 47181 | 5609 | 53 |
2264617 | 2264617 | 2022-03-01 | Weakley | Tennessee | 47183 | 9387 | 131 |
2264618 | 2264618 | 2022-03-01 | White | Tennessee | 47185 | 8143 | 126 |
2264619 | 2264619 | 2022-03-01 | Williamson | Tennessee | 47187 | 61337 | 375 |
2264620 | 2264620 | 2022-03-01 | Wilson | Tennessee | 47189 | 41211 | 459 |
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);