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 2020-05-19 and state = "Tennessee" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
159596 | 159596 | 2020-05-19 | Anderson | Tennessee | 47001 | 37 | 1 |
159597 | 159597 | 2020-05-19 | Bedford | Tennessee | 47003 | 257 | 4 |
159598 | 159598 | 2020-05-19 | Benton | Tennessee | 47005 | 7 | 1 |
159599 | 159599 | 2020-05-19 | Bledsoe | Tennessee | 47007 | 607 | 1 |
159600 | 159600 | 2020-05-19 | Blount | Tennessee | 47009 | 76 | 3 |
159601 | 159601 | 2020-05-19 | Bradley | Tennessee | 47011 | 84 | 1 |
159602 | 159602 | 2020-05-19 | Campbell | Tennessee | 47013 | 17 | 1 |
159603 | 159603 | 2020-05-19 | Cannon | Tennessee | 47015 | 13 | 0 |
159604 | 159604 | 2020-05-19 | Carroll | Tennessee | 47017 | 25 | 1 |
159605 | 159605 | 2020-05-19 | Carter | Tennessee | 47019 | 19 | 1 |
159606 | 159606 | 2020-05-19 | Cheatham | Tennessee | 47021 | 93 | 0 |
159607 | 159607 | 2020-05-19 | Chester | Tennessee | 47023 | 12 | 0 |
159608 | 159608 | 2020-05-19 | Claiborne | Tennessee | 47025 | 8 | 0 |
159609 | 159609 | 2020-05-19 | Clay | Tennessee | 47027 | 6 | 0 |
159610 | 159610 | 2020-05-19 | Cocke | Tennessee | 47029 | 20 | 0 |
159611 | 159611 | 2020-05-19 | Coffee | Tennessee | 47031 | 63 | 0 |
159612 | 159612 | 2020-05-19 | Crockett | Tennessee | 47033 | 14 | 1 |
159613 | 159613 | 2020-05-19 | Cumberland | Tennessee | 47035 | 94 | 1 |
159614 | 159614 | 2020-05-19 | Davidson | Tennessee | 47037 | 4390 | 46 |
159615 | 159615 | 2020-05-19 | DeKalb | Tennessee | 47041 | 32 | 0 |
159616 | 159616 | 2020-05-19 | Decatur | Tennessee | 47039 | 5 | 0 |
159617 | 159617 | 2020-05-19 | Dickson | Tennessee | 47043 | 93 | 0 |
159618 | 159618 | 2020-05-19 | Dyer | Tennessee | 47045 | 45 | 0 |
159619 | 159619 | 2020-05-19 | Fayette | Tennessee | 47047 | 95 | 2 |
159620 | 159620 | 2020-05-19 | Fentress | Tennessee | 47049 | 9 | 0 |
159621 | 159621 | 2020-05-19 | Franklin | Tennessee | 47051 | 43 | 1 |
159622 | 159622 | 2020-05-19 | Gibson | Tennessee | 47053 | 59 | 1 |
159623 | 159623 | 2020-05-19 | Giles | Tennessee | 47055 | 12 | 0 |
159624 | 159624 | 2020-05-19 | Grainger | Tennessee | 47057 | 6 | 0 |
159625 | 159625 | 2020-05-19 | Greene | Tennessee | 47059 | 46 | 2 |
159626 | 159626 | 2020-05-19 | Grundy | Tennessee | 47061 | 31 | 1 |
159627 | 159627 | 2020-05-19 | Hamblen | Tennessee | 47063 | 24 | 2 |
159628 | 159628 | 2020-05-19 | Hamilton | Tennessee | 47065 | 404 | 13 |
159629 | 159629 | 2020-05-19 | Hancock | Tennessee | 47067 | 1 | 0 |
159630 | 159630 | 2020-05-19 | Hardeman | Tennessee | 47069 | 183 | 0 |
159631 | 159631 | 2020-05-19 | Hardin | Tennessee | 47071 | 10 | 1 |
159632 | 159632 | 2020-05-19 | Hawkins | Tennessee | 47073 | 31 | 2 |
159633 | 159633 | 2020-05-19 | Haywood | Tennessee | 47075 | 29 | 1 |
159634 | 159634 | 2020-05-19 | Henderson | Tennessee | 47077 | 12 | 0 |
159635 | 159635 | 2020-05-19 | Henry | Tennessee | 47079 | 20 | 0 |
159636 | 159636 | 2020-05-19 | Hickman | Tennessee | 47081 | 52 | 0 |
159637 | 159637 | 2020-05-19 | Houston | Tennessee | 47083 | 7 | 0 |
159638 | 159638 | 2020-05-19 | Humphreys | Tennessee | 47085 | 12 | 1 |
159639 | 159639 | 2020-05-19 | Jackson | Tennessee | 47087 | 13 | 0 |
159640 | 159640 | 2020-05-19 | Jefferson | Tennessee | 47089 | 26 | 0 |
159641 | 159641 | 2020-05-19 | Johnson | Tennessee | 47091 | 15 | 0 |
159642 | 159642 | 2020-05-19 | Knox | Tennessee | 47093 | 320 | 5 |
159643 | 159643 | 2020-05-19 | Lake | Tennessee | 47095 | 403 | 0 |
159644 | 159644 | 2020-05-19 | Lauderdale | Tennessee | 47097 | 48 | 1 |
159645 | 159645 | 2020-05-19 | Lawrence | Tennessee | 47099 | 21 | 0 |
159646 | 159646 | 2020-05-19 | Lewis | Tennessee | 47101 | 2 | 0 |
159647 | 159647 | 2020-05-19 | Lincoln | Tennessee | 47103 | 17 | 0 |
159648 | 159648 | 2020-05-19 | Loudon | Tennessee | 47105 | 97 | 0 |
159649 | 159649 | 2020-05-19 | Macon | Tennessee | 47111 | 93 | 3 |
159650 | 159650 | 2020-05-19 | Madison | Tennessee | 47113 | 162 | 2 |
159651 | 159651 | 2020-05-19 | Marion | Tennessee | 47115 | 34 | 1 |
159652 | 159652 | 2020-05-19 | Marshall | Tennessee | 47117 | 26 | 1 |
159653 | 159653 | 2020-05-19 | Maury | Tennessee | 47119 | 71 | 0 |
159654 | 159654 | 2020-05-19 | McMinn | Tennessee | 47107 | 125 | 12 |
159655 | 159655 | 2020-05-19 | McNairy | Tennessee | 47109 | 12 | 0 |
159656 | 159656 | 2020-05-19 | Meigs | Tennessee | 47121 | 22 | 0 |
159657 | 159657 | 2020-05-19 | Monroe | Tennessee | 47123 | 51 | 2 |
159658 | 159658 | 2020-05-19 | Montgomery | Tennessee | 47125 | 216 | 2 |
159659 | 159659 | 2020-05-19 | Moore | Tennessee | 47127 | 3 | 0 |
159660 | 159660 | 2020-05-19 | Morgan | Tennessee | 47129 | 17 | 0 |
159661 | 159661 | 2020-05-19 | Obion | Tennessee | 47131 | 19 | 1 |
159662 | 159662 | 2020-05-19 | Overton | Tennessee | 47133 | 18 | 0 |
159663 | 159663 | 2020-05-19 | Perry | Tennessee | 47135 | 13 | 0 |
159664 | 159664 | 2020-05-19 | Pickett | Tennessee | 47137 | 2 | 0 |
159665 | 159665 | 2020-05-19 | Polk | Tennessee | 47139 | 14 | 0 |
159666 | 159666 | 2020-05-19 | Putnam | Tennessee | 47141 | 286 | 5 |
159667 | 159667 | 2020-05-19 | Rhea | Tennessee | 47143 | 15 | 0 |
159668 | 159668 | 2020-05-19 | Roane | Tennessee | 47145 | 9 | 0 |
159669 | 159669 | 2020-05-19 | Robertson | Tennessee | 47147 | 298 | 0 |
159670 | 159670 | 2020-05-19 | Rutherford | Tennessee | 47149 | 906 | 19 |
159671 | 159671 | 2020-05-19 | Scott | Tennessee | 47151 | 11 | 0 |
159672 | 159672 | 2020-05-19 | Sequatchie | Tennessee | 47153 | 9 | 0 |
159673 | 159673 | 2020-05-19 | Sevier | Tennessee | 47155 | 68 | 2 |
159674 | 159674 | 2020-05-19 | Shelby | Tennessee | 47157 | 3936 | 88 |
159675 | 159675 | 2020-05-19 | Smith | Tennessee | 47159 | 29 | 1 |
159676 | 159676 | 2020-05-19 | Stewart | Tennessee | 47161 | 8 | 0 |
159677 | 159677 | 2020-05-19 | Sullivan | Tennessee | 47163 | 57 | 2 |
159678 | 159678 | 2020-05-19 | Sumner | Tennessee | 47165 | 768 | 41 |
159679 | 159679 | 2020-05-19 | Tipton | Tennessee | 47167 | 407 | 2 |
159680 | 159680 | 2020-05-19 | Trousdale | Tennessee | 47169 | 1384 | 4 |
159681 | 159681 | 2020-05-19 | Unicoi | Tennessee | 47171 | 3 | 0 |
159682 | 159682 | 2020-05-19 | Union | Tennessee | 47173 | 4 | 0 |
159683 | 159683 | 2020-05-19 | Unknown | Tennessee | 109 | 0 | |
159684 | 159684 | 2020-05-19 | Van Buren | Tennessee | 47175 | 4 | 0 |
159685 | 159685 | 2020-05-19 | Warren | Tennessee | 47177 | 16 | 0 |
159686 | 159686 | 2020-05-19 | Washington | Tennessee | 47179 | 70 | 0 |
159687 | 159687 | 2020-05-19 | Wayne | Tennessee | 47181 | 63 | 0 |
159688 | 159688 | 2020-05-19 | Weakley | Tennessee | 47183 | 27 | 0 |
159689 | 159689 | 2020-05-19 | White | Tennessee | 47185 | 21 | 0 |
159690 | 159690 | 2020-05-19 | Williamson | Tennessee | 47187 | 492 | 10 |
159691 | 159691 | 2020-05-19 | Wilson | Tennessee | 47189 | 338 | 8 |
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);