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-05-16 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1325521 | 1325521 | 2021-05-16 | Anderson | Tennessee | 47001 | 8795 | 171 |
1325522 | 1325522 | 2021-05-16 | Bedford | Tennessee | 47003 | 6522 | 128 |
1325523 | 1325523 | 2021-05-16 | Benton | Tennessee | 47005 | 1673 | 40 |
1325524 | 1325524 | 2021-05-16 | Bledsoe | Tennessee | 47007 | 2158 | 11 |
1325525 | 1325525 | 2021-05-16 | Blount | Tennessee | 47009 | 15559 | 196 |
1325526 | 1325526 | 2021-05-16 | Bradley | Tennessee | 47011 | 15100 | 151 |
1325527 | 1325527 | 2021-05-16 | Campbell | Tennessee | 47013 | 4174 | 63 |
1325528 | 1325528 | 2021-05-16 | Cannon | Tennessee | 47015 | 1928 | 31 |
1325529 | 1325529 | 2021-05-16 | Carroll | Tennessee | 47017 | 3634 | 83 |
1325530 | 1325530 | 2021-05-16 | Carter | Tennessee | 47019 | 6662 | 158 |
1325531 | 1325531 | 2021-05-16 | Cheatham | Tennessee | 47021 | 4578 | 56 |
1325532 | 1325532 | 2021-05-16 | Chester | Tennessee | 47023 | 2154 | 51 |
1325533 | 1325533 | 2021-05-16 | Claiborne | Tennessee | 47025 | 3188 | 73 |
1325534 | 1325534 | 2021-05-16 | Clay | Tennessee | 47027 | 1103 | 30 |
1325535 | 1325535 | 2021-05-16 | Cocke | Tennessee | 47029 | 4524 | 99 |
1325536 | 1325536 | 2021-05-16 | Coffee | Tennessee | 47031 | 6922 | 123 |
1325537 | 1325537 | 2021-05-16 | Crockett | Tennessee | 47033 | 2035 | 49 |
1325538 | 1325538 | 2021-05-16 | Cumberland | Tennessee | 47035 | 6769 | 133 |
1325539 | 1325539 | 2021-05-16 | Davidson | Tennessee | 47037 | 98771 | 942 |
1325540 | 1325540 | 2021-05-16 | DeKalb | Tennessee | 47041 | 2807 | 54 |
1325541 | 1325541 | 2021-05-16 | Decatur | Tennessee | 47039 | 1593 | 39 |
1325542 | 1325542 | 2021-05-16 | Dickson | Tennessee | 47043 | 6854 | 113 |
1325543 | 1325543 | 2021-05-16 | Dyer | Tennessee | 47045 | 5440 | 106 |
1325544 | 1325544 | 2021-05-16 | Fayette | Tennessee | 47047 | 5118 | 78 |
1325545 | 1325545 | 2021-05-16 | Fentress | Tennessee | 47049 | 2430 | 47 |
1325546 | 1325546 | 2021-05-16 | Franklin | Tennessee | 47051 | 5164 | 90 |
1325547 | 1325547 | 2021-05-16 | Gibson | Tennessee | 47053 | 6542 | 146 |
1325548 | 1325548 | 2021-05-16 | Giles | Tennessee | 47055 | 4010 | 100 |
1325549 | 1325549 | 2021-05-16 | Grainger | Tennessee | 47057 | 2635 | 50 |
1325550 | 1325550 | 2021-05-16 | Greene | Tennessee | 47059 | 7928 | 156 |
1325551 | 1325551 | 2021-05-16 | Grundy | Tennessee | 47061 | 1795 | 34 |
1325552 | 1325552 | 2021-05-16 | Hamblen | Tennessee | 47063 | 8632 | 173 |
1325553 | 1325553 | 2021-05-16 | Hamilton | Tennessee | 47065 | 44787 | 496 |
1325554 | 1325554 | 2021-05-16 | Hancock | Tennessee | 47067 | 593 | 12 |
1325555 | 1325555 | 2021-05-16 | Hardeman | Tennessee | 47069 | 3537 | 64 |
1325556 | 1325556 | 2021-05-16 | Hardin | Tennessee | 47071 | 3589 | 68 |
1325557 | 1325557 | 2021-05-16 | Hawkins | Tennessee | 47073 | 6161 | 107 |
1325558 | 1325558 | 2021-05-16 | Haywood | Tennessee | 47075 | 2715 | 62 |
1325559 | 1325559 | 2021-05-16 | Henderson | Tennessee | 47077 | 3807 | 76 |
1325560 | 1325560 | 2021-05-16 | Henry | Tennessee | 47079 | 3206 | 76 |
1325561 | 1325561 | 2021-05-16 | Hickman | Tennessee | 47081 | 2847 | 46 |
1325562 | 1325562 | 2021-05-16 | Houston | Tennessee | 47083 | 1097 | 33 |
1325563 | 1325563 | 2021-05-16 | Humphreys | Tennessee | 47085 | 1815 | 28 |
1325564 | 1325564 | 2021-05-16 | Jackson | Tennessee | 47087 | 1323 | 36 |
1325565 | 1325565 | 2021-05-16 | Jefferson | Tennessee | 47089 | 6244 | 125 |
1325566 | 1325566 | 2021-05-16 | Johnson | Tennessee | 47091 | 2419 | 39 |
1325567 | 1325567 | 2021-05-16 | Knox | Tennessee | 47093 | 52047 | 636 |
1325568 | 1325568 | 2021-05-16 | Lake | Tennessee | 47095 | 1705 | 26 |
1325569 | 1325569 | 2021-05-16 | Lauderdale | Tennessee | 47097 | 3202 | 44 |
1325570 | 1325570 | 2021-05-16 | Lawrence | Tennessee | 47099 | 5984 | 91 |
1325571 | 1325571 | 2021-05-16 | Lewis | Tennessee | 47101 | 1584 | 26 |
1325572 | 1325572 | 2021-05-16 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1325573 | 1325573 | 2021-05-16 | Loudon | Tennessee | 47105 | 6164 | 69 |
1325574 | 1325574 | 2021-05-16 | Macon | Tennessee | 47111 | 3631 | 78 |
1325575 | 1325575 | 2021-05-16 | Madison | Tennessee | 47113 | 11281 | 241 |
1325576 | 1325576 | 2021-05-16 | Marion | Tennessee | 47115 | 3128 | 47 |
1325577 | 1325577 | 2021-05-16 | Marshall | Tennessee | 47117 | 4206 | 58 |
1325578 | 1325578 | 2021-05-16 | Maury | Tennessee | 47119 | 13545 | 172 |
1325579 | 1325579 | 2021-05-16 | McMinn | Tennessee | 47107 | 6541 | 98 |
1325580 | 1325580 | 2021-05-16 | McNairy | Tennessee | 47109 | 2842 | 54 |
1325581 | 1325581 | 2021-05-16 | Meigs | Tennessee | 47121 | 1391 | 25 |
1325582 | 1325582 | 2021-05-16 | Monroe | Tennessee | 47123 | 5875 | 96 |
1325583 | 1325583 | 2021-05-16 | Montgomery | Tennessee | 47125 | 20402 | 227 |
1325584 | 1325584 | 2021-05-16 | Moore | Tennessee | 47127 | 1017 | 17 |
1325585 | 1325585 | 2021-05-16 | Morgan | Tennessee | 47129 | 2513 | 39 |
1325586 | 1325586 | 2021-05-16 | Obion | Tennessee | 47131 | 4550 | 96 |
1325587 | 1325587 | 2021-05-16 | Overton | Tennessee | 47133 | 3025 | 61 |
1325588 | 1325588 | 2021-05-16 | Perry | Tennessee | 47135 | 1072 | 28 |
1325589 | 1325589 | 2021-05-16 | Pickett | Tennessee | 47137 | 759 | 24 |
1325590 | 1325590 | 2021-05-16 | Polk | Tennessee | 47139 | 2087 | 25 |
1325591 | 1325591 | 2021-05-16 | Putnam | Tennessee | 47141 | 11437 | 175 |
1325592 | 1325592 | 2021-05-16 | Rhea | Tennessee | 47143 | 4357 | 75 |
1325593 | 1325593 | 2021-05-16 | Roane | Tennessee | 47145 | 6318 | 105 |
1325594 | 1325594 | 2021-05-16 | Robertson | Tennessee | 47147 | 9793 | 132 |
1325595 | 1325595 | 2021-05-16 | Rutherford | Tennessee | 47149 | 43212 | 437 |
1325596 | 1325596 | 2021-05-16 | Scott | Tennessee | 47151 | 3152 | 45 |
1325597 | 1325597 | 2021-05-16 | Sequatchie | Tennessee | 47153 | 1718 | 29 |
1325598 | 1325598 | 2021-05-16 | Sevier | Tennessee | 47155 | 13451 | 175 |
1325599 | 1325599 | 2021-05-16 | Shelby | Tennessee | 47157 | 97530 | 1646 |
1325600 | 1325600 | 2021-05-16 | Smith | Tennessee | 47159 | 2785 | 39 |
1325601 | 1325601 | 2021-05-16 | Stewart | Tennessee | 47161 | 1330 | 28 |
1325602 | 1325602 | 2021-05-16 | Sullivan | Tennessee | 47163 | 16952 | 298 |
1325603 | 1325603 | 2021-05-16 | Sumner | Tennessee | 47165 | 24135 | 349 |
1325604 | 1325604 | 2021-05-16 | Tipton | Tennessee | 47167 | 7397 | 104 |
1325605 | 1325605 | 2021-05-16 | Trousdale | Tennessee | 47169 | 2506 | 22 |
1325606 | 1325606 | 2021-05-16 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1325607 | 1325607 | 2021-05-16 | Union | Tennessee | 47173 | 1922 | 34 |
1325608 | 1325608 | 2021-05-16 | Unknown | Tennessee | 9129 | 117 | |
1325609 | 1325609 | 2021-05-16 | Van Buren | Tennessee | 47175 | 855 | 23 |
1325610 | 1325610 | 2021-05-16 | Warren | Tennessee | 47177 | 5555 | 81 |
1325611 | 1325611 | 2021-05-16 | Washington | Tennessee | 47179 | 14691 | 245 |
1325612 | 1325612 | 2021-05-16 | Wayne | Tennessee | 47181 | 2970 | 34 |
1325613 | 1325613 | 2021-05-16 | Weakley | Tennessee | 47183 | 4163 | 65 |
1325614 | 1325614 | 2021-05-16 | White | Tennessee | 47185 | 3681 | 70 |
1325615 | 1325615 | 2021-05-16 | Williamson | Tennessee | 47187 | 28116 | 217 |
1325616 | 1325616 | 2021-05-16 | Wilson | Tennessee | 47189 | 18907 | 236 |
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);