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-05-06 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
120625 | 120625 | 2020-05-06 | Anderson | Tennessee | 47001 | 29 | 1 |
120626 | 120626 | 2020-05-06 | Bedford | Tennessee | 47003 | 212 | 3 |
120627 | 120627 | 2020-05-06 | Benton | Tennessee | 47005 | 7 | 1 |
120628 | 120628 | 2020-05-06 | Bledsoe | Tennessee | 47007 | 601 | 0 |
120629 | 120629 | 2020-05-06 | Blount | Tennessee | 47009 | 69 | 3 |
120630 | 120630 | 2020-05-06 | Bradley | Tennessee | 47011 | 61 | 1 |
120631 | 120631 | 2020-05-06 | Campbell | Tennessee | 47013 | 16 | 1 |
120632 | 120632 | 2020-05-06 | Cannon | Tennessee | 47015 | 12 | 0 |
120633 | 120633 | 2020-05-06 | Carroll | Tennessee | 47017 | 18 | 1 |
120634 | 120634 | 2020-05-06 | Carter | Tennessee | 47019 | 16 | 1 |
120635 | 120635 | 2020-05-06 | Cheatham | Tennessee | 47021 | 58 | 0 |
120636 | 120636 | 2020-05-06 | Chester | Tennessee | 47023 | 10 | 0 |
120637 | 120637 | 2020-05-06 | Claiborne | Tennessee | 47025 | 6 | 0 |
120638 | 120638 | 2020-05-06 | Clay | Tennessee | 47027 | 6 | 0 |
120639 | 120639 | 2020-05-06 | Cocke | Tennessee | 47029 | 16 | 0 |
120640 | 120640 | 2020-05-06 | Coffee | Tennessee | 47031 | 45 | 0 |
120641 | 120641 | 2020-05-06 | Crockett | Tennessee | 47033 | 7 | 0 |
120642 | 120642 | 2020-05-06 | Cumberland | Tennessee | 47035 | 85 | 1 |
120643 | 120643 | 2020-05-06 | Davidson | Tennessee | 47037 | 3346 | 33 |
120644 | 120644 | 2020-05-06 | DeKalb | Tennessee | 47041 | 25 | 0 |
120645 | 120645 | 2020-05-06 | Decatur | Tennessee | 47039 | 4 | 0 |
120646 | 120646 | 2020-05-06 | Dickson | Tennessee | 47043 | 84 | 0 |
120647 | 120647 | 2020-05-06 | Dyer | Tennessee | 47045 | 38 | 0 |
120648 | 120648 | 2020-05-06 | Fayette | Tennessee | 47047 | 73 | 1 |
120649 | 120649 | 2020-05-06 | Fentress | Tennessee | 47049 | 5 | 0 |
120650 | 120650 | 2020-05-06 | Franklin | Tennessee | 47051 | 36 | 1 |
120651 | 120651 | 2020-05-06 | Gibson | Tennessee | 47053 | 50 | 1 |
120652 | 120652 | 2020-05-06 | Giles | Tennessee | 47055 | 9 | 0 |
120653 | 120653 | 2020-05-06 | Grainger | Tennessee | 47057 | 6 | 0 |
120654 | 120654 | 2020-05-06 | Greene | Tennessee | 47059 | 43 | 2 |
120655 | 120655 | 2020-05-06 | Grundy | Tennessee | 47061 | 28 | 1 |
120656 | 120656 | 2020-05-06 | Hamblen | Tennessee | 47063 | 19 | 2 |
120657 | 120657 | 2020-05-06 | Hamilton | Tennessee | 47065 | 196 | 14 |
120658 | 120658 | 2020-05-06 | Hardeman | Tennessee | 47069 | 22 | 0 |
120659 | 120659 | 2020-05-06 | Hardin | Tennessee | 47071 | 7 | 0 |
120660 | 120660 | 2020-05-06 | Hawkins | Tennessee | 47073 | 31 | 2 |
120661 | 120661 | 2020-05-06 | Haywood | Tennessee | 47075 | 26 | 1 |
120662 | 120662 | 2020-05-06 | Henderson | Tennessee | 47077 | 10 | 0 |
120663 | 120663 | 2020-05-06 | Henry | Tennessee | 47079 | 13 | 0 |
120664 | 120664 | 2020-05-06 | Hickman | Tennessee | 47081 | 47 | 0 |
120665 | 120665 | 2020-05-06 | Houston | Tennessee | 47083 | 6 | 0 |
120666 | 120666 | 2020-05-06 | Humphreys | Tennessee | 47085 | 11 | 1 |
120667 | 120667 | 2020-05-06 | Jackson | Tennessee | 47087 | 7 | 0 |
120668 | 120668 | 2020-05-06 | Jefferson | Tennessee | 47089 | 26 | 0 |
120669 | 120669 | 2020-05-06 | Johnson | Tennessee | 47091 | 7 | 0 |
120670 | 120670 | 2020-05-06 | Knox | Tennessee | 47093 | 252 | 5 |
120671 | 120671 | 2020-05-06 | Lake | Tennessee | 47095 | 59 | 0 |
120672 | 120672 | 2020-05-06 | Lauderdale | Tennessee | 47097 | 25 | 0 |
120673 | 120673 | 2020-05-06 | Lawrence | Tennessee | 47099 | 17 | 0 |
120674 | 120674 | 2020-05-06 | Lewis | Tennessee | 47101 | 2 | 0 |
120675 | 120675 | 2020-05-06 | Lincoln | Tennessee | 47103 | 16 | 0 |
120676 | 120676 | 2020-05-06 | Loudon | Tennessee | 47105 | 39 | 0 |
120677 | 120677 | 2020-05-06 | Macon | Tennessee | 47111 | 54 | 3 |
120678 | 120678 | 2020-05-06 | Madison | Tennessee | 47113 | 144 | 1 |
120679 | 120679 | 2020-05-06 | Marion | Tennessee | 47115 | 29 | 1 |
120680 | 120680 | 2020-05-06 | Marshall | Tennessee | 47117 | 23 | 1 |
120681 | 120681 | 2020-05-06 | Maury | Tennessee | 47119 | 51 | 1 |
120682 | 120682 | 2020-05-06 | McMinn | Tennessee | 47107 | 107 | 3 |
120683 | 120683 | 2020-05-06 | McNairy | Tennessee | 47109 | 11 | 0 |
120684 | 120684 | 2020-05-06 | Meigs | Tennessee | 47121 | 11 | 0 |
120685 | 120685 | 2020-05-06 | Monroe | Tennessee | 47123 | 26 | 1 |
120686 | 120686 | 2020-05-06 | Montgomery | Tennessee | 47125 | 153 | 2 |
120687 | 120687 | 2020-05-06 | Moore | Tennessee | 47127 | 3 | 0 |
120688 | 120688 | 2020-05-06 | Morgan | Tennessee | 47129 | 6 | 0 |
120689 | 120689 | 2020-05-06 | Obion | Tennessee | 47131 | 15 | 1 |
120690 | 120690 | 2020-05-06 | Overton | Tennessee | 47133 | 10 | 0 |
120691 | 120691 | 2020-05-06 | Perry | Tennessee | 47135 | 13 | 0 |
120692 | 120692 | 2020-05-06 | Polk | Tennessee | 47139 | 12 | 0 |
120693 | 120693 | 2020-05-06 | Putnam | Tennessee | 47141 | 162 | 5 |
120694 | 120694 | 2020-05-06 | Rhea | Tennessee | 47143 | 6 | 0 |
120695 | 120695 | 2020-05-06 | Roane | Tennessee | 47145 | 8 | 0 |
120696 | 120696 | 2020-05-06 | Robertson | Tennessee | 47147 | 186 | 0 |
120697 | 120697 | 2020-05-06 | Rutherford | Tennessee | 47149 | 655 | 14 |
120698 | 120698 | 2020-05-06 | Scott | Tennessee | 47151 | 11 | 0 |
120699 | 120699 | 2020-05-06 | Sequatchie | Tennessee | 47153 | 7 | 0 |
120700 | 120700 | 2020-05-06 | Sevier | Tennessee | 47155 | 60 | 2 |
120701 | 120701 | 2020-05-06 | Shelby | Tennessee | 47157 | 3010 | 64 |
120702 | 120702 | 2020-05-06 | Smith | Tennessee | 47159 | 23 | 1 |
120703 | 120703 | 2020-05-06 | Stewart | Tennessee | 47161 | 7 | 0 |
120704 | 120704 | 2020-05-06 | Sullivan | Tennessee | 47163 | 52 | 1 |
120705 | 120705 | 2020-05-06 | Sumner | Tennessee | 47165 | 671 | 38 |
120706 | 120706 | 2020-05-06 | Tipton | Tennessee | 47167 | 155 | 2 |
120707 | 120707 | 2020-05-06 | Trousdale | Tennessee | 47169 | 1355 | 2 |
120708 | 120708 | 2020-05-06 | Unicoi | Tennessee | 47171 | 2 | 0 |
120709 | 120709 | 2020-05-06 | Union | Tennessee | 47173 | 3 | 0 |
120710 | 120710 | 2020-05-06 | Van Buren | Tennessee | 47175 | 2 | 0 |
120711 | 120711 | 2020-05-06 | Warren | Tennessee | 47177 | 10 | 0 |
120712 | 120712 | 2020-05-06 | Washington | Tennessee | 47179 | 59 | 0 |
120713 | 120713 | 2020-05-06 | Wayne | Tennessee | 47181 | 4 | 0 |
120714 | 120714 | 2020-05-06 | Weakley | Tennessee | 47183 | 24 | 0 |
120715 | 120715 | 2020-05-06 | White | Tennessee | 47185 | 15 | 0 |
120716 | 120716 | 2020-05-06 | Williamson | Tennessee | 47187 | 436 | 10 |
120717 | 120717 | 2020-05-06 | Wilson | Tennessee | 47189 | 287 | 7 |
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);