ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where "date" is on date 2020-05-09 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
129575 | 129575 | 2020-05-09 | Anderson | Tennessee | 47001 | 31 | 1 |
129576 | 129576 | 2020-05-09 | Bedford | Tennessee | 47003 | 231 | 3 |
129577 | 129577 | 2020-05-09 | Benton | Tennessee | 47005 | 7 | 1 |
129578 | 129578 | 2020-05-09 | Bledsoe | Tennessee | 47007 | 604 | 0 |
129579 | 129579 | 2020-05-09 | Blount | Tennessee | 47009 | 71 | 3 |
129580 | 129580 | 2020-05-09 | Bradley | Tennessee | 47011 | 69 | 1 |
129581 | 129581 | 2020-05-09 | Campbell | Tennessee | 47013 | 16 | 1 |
129582 | 129582 | 2020-05-09 | Cannon | Tennessee | 47015 | 13 | 0 |
129583 | 129583 | 2020-05-09 | Carroll | Tennessee | 47017 | 19 | 1 |
129584 | 129584 | 2020-05-09 | Carter | Tennessee | 47019 | 18 | 1 |
129585 | 129585 | 2020-05-09 | Cheatham | Tennessee | 47021 | 61 | 0 |
129586 | 129586 | 2020-05-09 | Chester | Tennessee | 47023 | 12 | 0 |
129587 | 129587 | 2020-05-09 | Claiborne | Tennessee | 47025 | 7 | 0 |
129588 | 129588 | 2020-05-09 | Clay | Tennessee | 47027 | 6 | 0 |
129589 | 129589 | 2020-05-09 | Cocke | Tennessee | 47029 | 17 | 0 |
129590 | 129590 | 2020-05-09 | Coffee | Tennessee | 47031 | 52 | 0 |
129591 | 129591 | 2020-05-09 | Crockett | Tennessee | 47033 | 9 | 0 |
129592 | 129592 | 2020-05-09 | Cumberland | Tennessee | 47035 | 85 | 1 |
129593 | 129593 | 2020-05-09 | Davidson | Tennessee | 47037 | 3586 | 35 |
129594 | 129594 | 2020-05-09 | DeKalb | Tennessee | 47041 | 27 | 0 |
129595 | 129595 | 2020-05-09 | Decatur | Tennessee | 47039 | 4 | 0 |
129596 | 129596 | 2020-05-09 | Dickson | Tennessee | 47043 | 85 | 0 |
129597 | 129597 | 2020-05-09 | Dyer | Tennessee | 47045 | 41 | 0 |
129598 | 129598 | 2020-05-09 | Fayette | Tennessee | 47047 | 77 | 1 |
129599 | 129599 | 2020-05-09 | Fentress | Tennessee | 47049 | 6 | 0 |
129600 | 129600 | 2020-05-09 | Franklin | Tennessee | 47051 | 40 | 1 |
129601 | 129601 | 2020-05-09 | Gibson | Tennessee | 47053 | 53 | 1 |
129602 | 129602 | 2020-05-09 | Giles | Tennessee | 47055 | 9 | 0 |
129603 | 129603 | 2020-05-09 | Grainger | Tennessee | 47057 | 6 | 0 |
129604 | 129604 | 2020-05-09 | Greene | Tennessee | 47059 | 44 | 2 |
129605 | 129605 | 2020-05-09 | Grundy | Tennessee | 47061 | 30 | 1 |
129606 | 129606 | 2020-05-09 | Hamblen | Tennessee | 47063 | 21 | 2 |
129607 | 129607 | 2020-05-09 | Hamilton | Tennessee | 47065 | 232 | 13 |
129608 | 129608 | 2020-05-09 | Hardeman | Tennessee | 47069 | 116 | 0 |
129609 | 129609 | 2020-05-09 | Hardin | Tennessee | 47071 | 7 | 0 |
129610 | 129610 | 2020-05-09 | Hawkins | Tennessee | 47073 | 31 | 2 |
129611 | 129611 | 2020-05-09 | Haywood | Tennessee | 47075 | 26 | 1 |
129612 | 129612 | 2020-05-09 | Henderson | Tennessee | 47077 | 10 | 0 |
129613 | 129613 | 2020-05-09 | Henry | Tennessee | 47079 | 15 | 0 |
129614 | 129614 | 2020-05-09 | Hickman | Tennessee | 47081 | 49 | 0 |
129615 | 129615 | 2020-05-09 | Houston | Tennessee | 47083 | 6 | 0 |
129616 | 129616 | 2020-05-09 | Humphreys | Tennessee | 47085 | 11 | 1 |
129617 | 129617 | 2020-05-09 | Jackson | Tennessee | 47087 | 8 | 0 |
129618 | 129618 | 2020-05-09 | Jefferson | Tennessee | 47089 | 26 | 0 |
129619 | 129619 | 2020-05-09 | Johnson | Tennessee | 47091 | 5 | 0 |
129620 | 129620 | 2020-05-09 | Knox | Tennessee | 47093 | 262 | 5 |
129621 | 129621 | 2020-05-09 | Lake | Tennessee | 47095 | 59 | 0 |
129622 | 129622 | 2020-05-09 | Lauderdale | Tennessee | 47097 | 26 | 0 |
129623 | 129623 | 2020-05-09 | Lawrence | Tennessee | 47099 | 20 | 0 |
129624 | 129624 | 2020-05-09 | Lewis | Tennessee | 47101 | 2 | 0 |
129625 | 129625 | 2020-05-09 | Lincoln | Tennessee | 47103 | 16 | 0 |
129626 | 129626 | 2020-05-09 | Loudon | Tennessee | 47105 | 39 | 0 |
129627 | 129627 | 2020-05-09 | Macon | Tennessee | 47111 | 58 | 3 |
129628 | 129628 | 2020-05-09 | Madison | Tennessee | 47113 | 150 | 1 |
129629 | 129629 | 2020-05-09 | Marion | Tennessee | 47115 | 29 | 1 |
129630 | 129630 | 2020-05-09 | Marshall | Tennessee | 47117 | 24 | 1 |
129631 | 129631 | 2020-05-09 | Maury | Tennessee | 47119 | 55 | 0 |
129632 | 129632 | 2020-05-09 | McMinn | Tennessee | 47107 | 116 | 4 |
129633 | 129633 | 2020-05-09 | McNairy | Tennessee | 47109 | 11 | 0 |
129634 | 129634 | 2020-05-09 | Meigs | Tennessee | 47121 | 22 | 0 |
129635 | 129635 | 2020-05-09 | Monroe | Tennessee | 47123 | 30 | 1 |
129636 | 129636 | 2020-05-09 | Montgomery | Tennessee | 47125 | 172 | 2 |
129637 | 129637 | 2020-05-09 | Moore | Tennessee | 47127 | 3 | 0 |
129638 | 129638 | 2020-05-09 | Morgan | Tennessee | 47129 | 10 | 0 |
129639 | 129639 | 2020-05-09 | Obion | Tennessee | 47131 | 16 | 1 |
129640 | 129640 | 2020-05-09 | Overton | Tennessee | 47133 | 11 | 0 |
129641 | 129641 | 2020-05-09 | Perry | Tennessee | 47135 | 13 | 0 |
129642 | 129642 | 2020-05-09 | Polk | Tennessee | 47139 | 12 | 0 |
129643 | 129643 | 2020-05-09 | Putnam | Tennessee | 47141 | 166 | 5 |
129644 | 129644 | 2020-05-09 | Rhea | Tennessee | 47143 | 6 | 0 |
129645 | 129645 | 2020-05-09 | Roane | Tennessee | 47145 | 8 | 0 |
129646 | 129646 | 2020-05-09 | Robertson | Tennessee | 47147 | 219 | 0 |
129647 | 129647 | 2020-05-09 | Rutherford | Tennessee | 47149 | 720 | 14 |
129648 | 129648 | 2020-05-09 | Scott | Tennessee | 47151 | 11 | 0 |
129649 | 129649 | 2020-05-09 | Sequatchie | Tennessee | 47153 | 6 | 0 |
129650 | 129650 | 2020-05-09 | Sevier | Tennessee | 47155 | 65 | 2 |
129651 | 129651 | 2020-05-09 | Shelby | Tennessee | 47157 | 3189 | 68 |
129652 | 129652 | 2020-05-09 | Smith | Tennessee | 47159 | 24 | 1 |
129653 | 129653 | 2020-05-09 | Stewart | Tennessee | 47161 | 7 | 0 |
129654 | 129654 | 2020-05-09 | Sullivan | Tennessee | 47163 | 54 | 1 |
129655 | 129655 | 2020-05-09 | Sumner | Tennessee | 47165 | 693 | 38 |
129656 | 129656 | 2020-05-09 | Tipton | Tennessee | 47167 | 158 | 2 |
129657 | 129657 | 2020-05-09 | Trousdale | Tennessee | 47169 | 1357 | 2 |
129658 | 129658 | 2020-05-09 | Unicoi | Tennessee | 47171 | 2 | 0 |
129659 | 129659 | 2020-05-09 | Union | Tennessee | 47173 | 3 | 0 |
129660 | 129660 | 2020-05-09 | Unknown | Tennessee | 75 | 0 | |
129661 | 129661 | 2020-05-09 | Van Buren | Tennessee | 47175 | 2 | 0 |
129662 | 129662 | 2020-05-09 | Warren | Tennessee | 47177 | 12 | 0 |
129663 | 129663 | 2020-05-09 | Washington | Tennessee | 47179 | 61 | 0 |
129664 | 129664 | 2020-05-09 | Wayne | Tennessee | 47181 | 4 | 0 |
129665 | 129665 | 2020-05-09 | Weakley | Tennessee | 47183 | 24 | 0 |
129666 | 129666 | 2020-05-09 | White | Tennessee | 47185 | 16 | 0 |
129667 | 129667 | 2020-05-09 | Williamson | Tennessee | 47187 | 441 | 10 |
129668 | 129668 | 2020-05-09 | Wilson | Tennessee | 47189 | 297 | 6 |
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);