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-04 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1286564 | 1286564 | 2021-05-04 | Anderson | Tennessee | 47001 | 8750 | 172 |
1286565 | 1286565 | 2021-05-04 | Bedford | Tennessee | 47003 | 6500 | 128 |
1286566 | 1286566 | 2021-05-04 | Benton | Tennessee | 47005 | 1657 | 40 |
1286567 | 1286567 | 2021-05-04 | Bledsoe | Tennessee | 47007 | 2130 | 11 |
1286568 | 1286568 | 2021-05-04 | Blount | Tennessee | 47009 | 15441 | 193 |
1286569 | 1286569 | 2021-05-04 | Bradley | Tennessee | 47011 | 14983 | 149 |
1286570 | 1286570 | 2021-05-04 | Campbell | Tennessee | 47013 | 4151 | 63 |
1286571 | 1286571 | 2021-05-04 | Cannon | Tennessee | 47015 | 1917 | 31 |
1286572 | 1286572 | 2021-05-04 | Carroll | Tennessee | 47017 | 3612 | 83 |
1286573 | 1286573 | 2021-05-04 | Carter | Tennessee | 47019 | 6595 | 156 |
1286574 | 1286574 | 2021-05-04 | Cheatham | Tennessee | 47021 | 4541 | 55 |
1286575 | 1286575 | 2021-05-04 | Chester | Tennessee | 47023 | 2138 | 51 |
1286576 | 1286576 | 2021-05-04 | Claiborne | Tennessee | 47025 | 3172 | 73 |
1286577 | 1286577 | 2021-05-04 | Clay | Tennessee | 47027 | 1101 | 31 |
1286578 | 1286578 | 2021-05-04 | Cocke | Tennessee | 47029 | 4486 | 99 |
1286579 | 1286579 | 2021-05-04 | Coffee | Tennessee | 47031 | 6894 | 121 |
1286580 | 1286580 | 2021-05-04 | Crockett | Tennessee | 47033 | 2028 | 48 |
1286581 | 1286581 | 2021-05-04 | Cumberland | Tennessee | 47035 | 6704 | 128 |
1286582 | 1286582 | 2021-05-04 | Davidson | Tennessee | 47037 | 98409 | 932 |
1286583 | 1286583 | 2021-05-04 | DeKalb | Tennessee | 47041 | 2792 | 54 |
1286584 | 1286584 | 2021-05-04 | Decatur | Tennessee | 47039 | 1584 | 39 |
1286585 | 1286585 | 2021-05-04 | Dickson | Tennessee | 47043 | 6827 | 110 |
1286586 | 1286586 | 2021-05-04 | Dyer | Tennessee | 47045 | 5416 | 105 |
1286587 | 1286587 | 2021-05-04 | Fayette | Tennessee | 47047 | 5035 | 76 |
1286588 | 1286588 | 2021-05-04 | Fentress | Tennessee | 47049 | 2409 | 47 |
1286589 | 1286589 | 2021-05-04 | Franklin | Tennessee | 47051 | 5138 | 90 |
1286590 | 1286590 | 2021-05-04 | Gibson | Tennessee | 47053 | 6514 | 145 |
1286591 | 1286591 | 2021-05-04 | Giles | Tennessee | 47055 | 3992 | 100 |
1286592 | 1286592 | 2021-05-04 | Grainger | Tennessee | 47057 | 2619 | 50 |
1286593 | 1286593 | 2021-05-04 | Greene | Tennessee | 47059 | 7840 | 155 |
1286594 | 1286594 | 2021-05-04 | Grundy | Tennessee | 47061 | 1789 | 34 |
1286595 | 1286595 | 2021-05-04 | Hamblen | Tennessee | 47063 | 8597 | 173 |
1286596 | 1286596 | 2021-05-04 | Hamilton | Tennessee | 47065 | 44306 | 491 |
1286597 | 1286597 | 2021-05-04 | Hancock | Tennessee | 47067 | 588 | 12 |
1286598 | 1286598 | 2021-05-04 | Hardeman | Tennessee | 47069 | 3510 | 64 |
1286599 | 1286599 | 2021-05-04 | Hardin | Tennessee | 47071 | 3569 | 67 |
1286600 | 1286600 | 2021-05-04 | Hawkins | Tennessee | 47073 | 6005 | 107 |
1286601 | 1286601 | 2021-05-04 | Haywood | Tennessee | 47075 | 2705 | 62 |
1286602 | 1286602 | 2021-05-04 | Henderson | Tennessee | 47077 | 3784 | 76 |
1286603 | 1286603 | 2021-05-04 | Henry | Tennessee | 47079 | 3174 | 76 |
1286604 | 1286604 | 2021-05-04 | Hickman | Tennessee | 47081 | 2835 | 46 |
1286605 | 1286605 | 2021-05-04 | Houston | Tennessee | 47083 | 1091 | 33 |
1286606 | 1286606 | 2021-05-04 | Humphreys | Tennessee | 47085 | 1787 | 26 |
1286607 | 1286607 | 2021-05-04 | Jackson | Tennessee | 47087 | 1319 | 35 |
1286608 | 1286608 | 2021-05-04 | Jefferson | Tennessee | 47089 | 6177 | 124 |
1286609 | 1286609 | 2021-05-04 | Johnson | Tennessee | 47091 | 2388 | 39 |
1286610 | 1286610 | 2021-05-04 | Knox | Tennessee | 47093 | 51741 | 634 |
1286611 | 1286611 | 2021-05-04 | Lake | Tennessee | 47095 | 1702 | 26 |
1286612 | 1286612 | 2021-05-04 | Lauderdale | Tennessee | 47097 | 3174 | 44 |
1286613 | 1286613 | 2021-05-04 | Lawrence | Tennessee | 47099 | 5901 | 86 |
1286614 | 1286614 | 2021-05-04 | Lewis | Tennessee | 47101 | 1581 | 26 |
1286615 | 1286615 | 2021-05-04 | Lincoln | Tennessee | 47103 | 4345 | 63 |
1286616 | 1286616 | 2021-05-04 | Loudon | Tennessee | 47105 | 6103 | 69 |
1286617 | 1286617 | 2021-05-04 | Macon | Tennessee | 47111 | 3615 | 78 |
1286618 | 1286618 | 2021-05-04 | Madison | Tennessee | 47113 | 11132 | 241 |
1286619 | 1286619 | 2021-05-04 | Marion | Tennessee | 47115 | 3122 | 47 |
1286620 | 1286620 | 2021-05-04 | Marshall | Tennessee | 47117 | 4178 | 58 |
1286621 | 1286621 | 2021-05-04 | Maury | Tennessee | 47119 | 13450 | 171 |
1286622 | 1286622 | 2021-05-04 | McMinn | Tennessee | 47107 | 6489 | 98 |
1286623 | 1286623 | 2021-05-04 | McNairy | Tennessee | 47109 | 2810 | 54 |
1286624 | 1286624 | 2021-05-04 | Meigs | Tennessee | 47121 | 1383 | 25 |
1286625 | 1286625 | 2021-05-04 | Monroe | Tennessee | 47123 | 5820 | 95 |
1286626 | 1286626 | 2021-05-04 | Montgomery | Tennessee | 47125 | 20138 | 225 |
1286627 | 1286627 | 2021-05-04 | Moore | Tennessee | 47127 | 1010 | 17 |
1286628 | 1286628 | 2021-05-04 | Morgan | Tennessee | 47129 | 2491 | 39 |
1286629 | 1286629 | 2021-05-04 | Obion | Tennessee | 47131 | 4533 | 96 |
1286630 | 1286630 | 2021-05-04 | Overton | Tennessee | 47133 | 3006 | 61 |
1286631 | 1286631 | 2021-05-04 | Perry | Tennessee | 47135 | 1062 | 28 |
1286632 | 1286632 | 2021-05-04 | Pickett | Tennessee | 47137 | 759 | 24 |
1286633 | 1286633 | 2021-05-04 | Polk | Tennessee | 47139 | 2062 | 24 |
1286634 | 1286634 | 2021-05-04 | Putnam | Tennessee | 47141 | 11342 | 174 |
1286635 | 1286635 | 2021-05-04 | Rhea | Tennessee | 47143 | 4340 | 75 |
1286636 | 1286636 | 2021-05-04 | Roane | Tennessee | 47145 | 6267 | 105 |
1286637 | 1286637 | 2021-05-04 | Robertson | Tennessee | 47147 | 9737 | 131 |
1286638 | 1286638 | 2021-05-04 | Rutherford | Tennessee | 47149 | 42950 | 433 |
1286639 | 1286639 | 2021-05-04 | Scott | Tennessee | 47151 | 3114 | 45 |
1286640 | 1286640 | 2021-05-04 | Sequatchie | Tennessee | 47153 | 1694 | 29 |
1286641 | 1286641 | 2021-05-04 | Sevier | Tennessee | 47155 | 13341 | 175 |
1286642 | 1286642 | 2021-05-04 | Shelby | Tennessee | 47157 | 95944 | 1620 |
1286643 | 1286643 | 2021-05-04 | Smith | Tennessee | 47159 | 2771 | 39 |
1286644 | 1286644 | 2021-05-04 | Stewart | Tennessee | 47161 | 1322 | 28 |
1286645 | 1286645 | 2021-05-04 | Sullivan | Tennessee | 47163 | 16691 | 290 |
1286646 | 1286646 | 2021-05-04 | Sumner | Tennessee | 47165 | 23921 | 348 |
1286647 | 1286647 | 2021-05-04 | Tipton | Tennessee | 47167 | 7317 | 101 |
1286648 | 1286648 | 2021-05-04 | Trousdale | Tennessee | 47169 | 2499 | 22 |
1286649 | 1286649 | 2021-05-04 | Unicoi | Tennessee | 47171 | 2022 | 49 |
1286650 | 1286650 | 2021-05-04 | Union | Tennessee | 47173 | 1904 | 34 |
1286651 | 1286651 | 2021-05-04 | Unknown | Tennessee | 9216 | 127 | |
1286652 | 1286652 | 2021-05-04 | Van Buren | Tennessee | 47175 | 846 | 23 |
1286653 | 1286653 | 2021-05-04 | Warren | Tennessee | 47177 | 5541 | 81 |
1286654 | 1286654 | 2021-05-04 | Washington | Tennessee | 47179 | 14535 | 244 |
1286655 | 1286655 | 2021-05-04 | Wayne | Tennessee | 47181 | 2959 | 35 |
1286656 | 1286656 | 2021-05-04 | Weakley | Tennessee | 47183 | 4101 | 64 |
1286657 | 1286657 | 2021-05-04 | White | Tennessee | 47185 | 3624 | 69 |
1286658 | 1286658 | 2021-05-04 | Williamson | Tennessee | 47187 | 27935 | 217 |
1286659 | 1286659 | 2021-05-04 | Wilson | Tennessee | 47189 | 18742 | 233 |
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);