ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2020-04-22 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
80612 | 80612 | 2020-04-22 | Anderson | Tennessee | 47001 | 22 | 1 |
80613 | 80613 | 2020-04-22 | Bedford | Tennessee | 47003 | 117 | 2 |
80614 | 80614 | 2020-04-22 | Benton | Tennessee | 47005 | 4 | 0 |
80615 | 80615 | 2020-04-22 | Bledsoe | Tennessee | 47007 | 162 | 0 |
80616 | 80616 | 2020-04-22 | Blount | Tennessee | 47009 | 47 | 3 |
80617 | 80617 | 2020-04-22 | Bradley | Tennessee | 47011 | 38 | 1 |
80618 | 80618 | 2020-04-22 | Campbell | Tennessee | 47013 | 14 | 1 |
80619 | 80619 | 2020-04-22 | Cannon | Tennessee | 47015 | 11 | 0 |
80620 | 80620 | 2020-04-22 | Carroll | Tennessee | 47017 | 14 | 1 |
80621 | 80621 | 2020-04-22 | Carter | Tennessee | 47019 | 5 | 1 |
80622 | 80622 | 2020-04-22 | Cheatham | Tennessee | 47021 | 26 | 0 |
80623 | 80623 | 2020-04-22 | Chester | Tennessee | 47023 | 9 | 0 |
80624 | 80624 | 2020-04-22 | Claiborne | Tennessee | 47025 | 5 | 0 |
80625 | 80625 | 2020-04-22 | Clay | Tennessee | 47027 | 5 | 0 |
80626 | 80626 | 2020-04-22 | Cocke | Tennessee | 47029 | 13 | 0 |
80627 | 80627 | 2020-04-22 | Coffee | Tennessee | 47031 | 23 | 0 |
80628 | 80628 | 2020-04-22 | Crockett | Tennessee | 47033 | 6 | 0 |
80629 | 80629 | 2020-04-22 | Cumberland | Tennessee | 47035 | 60 | 0 |
80630 | 80630 | 2020-04-22 | Davidson | Tennessee | 47037 | 1962 | 22 |
80631 | 80631 | 2020-04-22 | DeKalb | Tennessee | 47041 | 10 | 0 |
80632 | 80632 | 2020-04-22 | Decatur | Tennessee | 47039 | 5 | 0 |
80633 | 80633 | 2020-04-22 | Dickson | Tennessee | 47043 | 50 | 0 |
80634 | 80634 | 2020-04-22 | Dyer | Tennessee | 47045 | 29 | 0 |
80635 | 80635 | 2020-04-22 | Fayette | Tennessee | 47047 | 48 | 1 |
80636 | 80636 | 2020-04-22 | Fentress | Tennessee | 47049 | 4 | 0 |
80637 | 80637 | 2020-04-22 | Franklin | Tennessee | 47051 | 28 | 1 |
80638 | 80638 | 2020-04-22 | Gibson | Tennessee | 47053 | 33 | 1 |
80639 | 80639 | 2020-04-22 | Giles | Tennessee | 47055 | 6 | 0 |
80640 | 80640 | 2020-04-22 | Grainger | Tennessee | 47057 | 4 | 0 |
80641 | 80641 | 2020-04-22 | Greene | Tennessee | 47059 | 37 | 2 |
80642 | 80642 | 2020-04-22 | Grundy | Tennessee | 47061 | 26 | 1 |
80643 | 80643 | 2020-04-22 | Hamblen | Tennessee | 47063 | 13 | 2 |
80644 | 80644 | 2020-04-22 | Hamilton | Tennessee | 47065 | 127 | 14 |
80645 | 80645 | 2020-04-22 | Hardeman | Tennessee | 47069 | 8 | 0 |
80646 | 80646 | 2020-04-22 | Hardin | Tennessee | 47071 | 4 | 0 |
80647 | 80647 | 2020-04-22 | Hawkins | Tennessee | 47073 | 28 | 2 |
80648 | 80648 | 2020-04-22 | Haywood | Tennessee | 47075 | 14 | 1 |
80649 | 80649 | 2020-04-22 | Henderson | Tennessee | 47077 | 5 | 0 |
80650 | 80650 | 2020-04-22 | Henry | Tennessee | 47079 | 11 | 0 |
80651 | 80651 | 2020-04-22 | Hickman | Tennessee | 47081 | 10 | 0 |
80652 | 80652 | 2020-04-22 | Houston | Tennessee | 47083 | 4 | 0 |
80653 | 80653 | 2020-04-22 | Humphreys | Tennessee | 47085 | 7 | 0 |
80654 | 80654 | 2020-04-22 | Jackson | Tennessee | 47087 | 6 | 0 |
80655 | 80655 | 2020-04-22 | Jefferson | Tennessee | 47089 | 17 | 0 |
80656 | 80656 | 2020-04-22 | Johnson | Tennessee | 47091 | 2 | 0 |
80657 | 80657 | 2020-04-22 | Knox | Tennessee | 47093 | 199 | 4 |
80658 | 80658 | 2020-04-22 | Lake | Tennessee | 47095 | 9 | 0 |
80659 | 80659 | 2020-04-22 | Lauderdale | Tennessee | 47097 | 16 | 0 |
80660 | 80660 | 2020-04-22 | Lawrence | Tennessee | 47099 | 16 | 0 |
80661 | 80661 | 2020-04-22 | Lewis | Tennessee | 47101 | 2 | 0 |
80662 | 80662 | 2020-04-22 | Lincoln | Tennessee | 47103 | 11 | 0 |
80663 | 80663 | 2020-04-22 | Loudon | Tennessee | 47105 | 23 | 0 |
80664 | 80664 | 2020-04-22 | Macon | Tennessee | 47111 | 35 | 3 |
80665 | 80665 | 2020-04-22 | Madison | Tennessee | 47113 | 95 | 1 |
80666 | 80666 | 2020-04-22 | Marion | Tennessee | 47115 | 28 | 1 |
80667 | 80667 | 2020-04-22 | Marshall | Tennessee | 47117 | 24 | 1 |
80668 | 80668 | 2020-04-22 | Maury | Tennessee | 47119 | 34 | 1 |
80669 | 80669 | 2020-04-22 | McMinn | Tennessee | 47107 | 6 | 0 |
80670 | 80670 | 2020-04-22 | McNairy | Tennessee | 47109 | 10 | 0 |
80671 | 80671 | 2020-04-22 | Meigs | Tennessee | 47121 | 5 | 0 |
80672 | 80672 | 2020-04-22 | Monroe | Tennessee | 47123 | 11 | 1 |
80673 | 80673 | 2020-04-22 | Montgomery | Tennessee | 47125 | 128 | 2 |
80674 | 80674 | 2020-04-22 | Moore | Tennessee | 47127 | 3 | 0 |
80675 | 80675 | 2020-04-22 | Morgan | Tennessee | 47129 | 5 | 0 |
80676 | 80676 | 2020-04-22 | Obion | Tennessee | 47131 | 10 | 1 |
80677 | 80677 | 2020-04-22 | Overton | Tennessee | 47133 | 7 | 0 |
80678 | 80678 | 2020-04-22 | Perry | Tennessee | 47135 | 8 | 0 |
80679 | 80679 | 2020-04-22 | Polk | Tennessee | 47139 | 6 | 0 |
80680 | 80680 | 2020-04-22 | Putnam | Tennessee | 47141 | 100 | 4 |
80681 | 80681 | 2020-04-22 | Rhea | Tennessee | 47143 | 4 | 0 |
80682 | 80682 | 2020-04-22 | Roane | Tennessee | 47145 | 8 | 0 |
80683 | 80683 | 2020-04-22 | Robertson | Tennessee | 47147 | 123 | 0 |
80684 | 80684 | 2020-04-22 | Rutherford | Tennessee | 47149 | 345 | 7 |
80685 | 80685 | 2020-04-22 | Scott | Tennessee | 47151 | 11 | 0 |
80686 | 80686 | 2020-04-22 | Sequatchie | Tennessee | 47153 | 3 | 0 |
80687 | 80687 | 2020-04-22 | Sevier | Tennessee | 47155 | 33 | 1 |
80688 | 80688 | 2020-04-22 | Shelby | Tennessee | 47157 | 1924 | 43 |
80689 | 80689 | 2020-04-22 | Smith | Tennessee | 47159 | 18 | 1 |
80690 | 80690 | 2020-04-22 | Stewart | Tennessee | 47161 | 6 | 0 |
80691 | 80691 | 2020-04-22 | Sullivan | Tennessee | 47163 | 47 | 1 |
80692 | 80692 | 2020-04-22 | Sumner | Tennessee | 47165 | 550 | 32 |
80693 | 80693 | 2020-04-22 | Tipton | Tennessee | 47167 | 83 | 0 |
80694 | 80694 | 2020-04-22 | Trousdale | Tennessee | 47169 | 27 | 1 |
80695 | 80695 | 2020-04-22 | Unicoi | Tennessee | 47171 | 1 | 0 |
80696 | 80696 | 2020-04-22 | Union | Tennessee | 47173 | 3 | 0 |
80697 | 80697 | 2020-04-22 | Van Buren | Tennessee | 47175 | 1 | 0 |
80698 | 80698 | 2020-04-22 | Warren | Tennessee | 47177 | 4 | 0 |
80699 | 80699 | 2020-04-22 | Washington | Tennessee | 47179 | 46 | 0 |
80700 | 80700 | 2020-04-22 | Wayne | Tennessee | 47181 | 2 | 0 |
80701 | 80701 | 2020-04-22 | Weakley | Tennessee | 47183 | 9 | 0 |
80702 | 80702 | 2020-04-22 | White | Tennessee | 47185 | 4 | 0 |
80703 | 80703 | 2020-04-22 | Williamson | Tennessee | 47187 | 365 | 6 |
80704 | 80704 | 2020-04-22 | Wilson | Tennessee | 47189 | 194 | 1 |
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);