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-06-05 and state = "Tennessee" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
211554 | 211554 | 2020-06-05 | Anderson | Tennessee | 47001 | 42 | 2 |
211555 | 211555 | 2020-06-05 | Bedford | Tennessee | 47003 | 302 | 4 |
211556 | 211556 | 2020-06-05 | Benton | Tennessee | 47005 | 7 | 1 |
211557 | 211557 | 2020-06-05 | Bledsoe | Tennessee | 47007 | 613 | 1 |
211558 | 211558 | 2020-06-05 | Blount | Tennessee | 47009 | 93 | 3 |
211559 | 211559 | 2020-06-05 | Bradley | Tennessee | 47011 | 174 | 2 |
211560 | 211560 | 2020-06-05 | Campbell | Tennessee | 47013 | 18 | 1 |
211561 | 211561 | 2020-06-05 | Cannon | Tennessee | 47015 | 32 | 0 |
211562 | 211562 | 2020-06-05 | Carroll | Tennessee | 47017 | 28 | 1 |
211563 | 211563 | 2020-06-05 | Carter | Tennessee | 47019 | 19 | 1 |
211564 | 211564 | 2020-06-05 | Cheatham | Tennessee | 47021 | 140 | 0 |
211565 | 211565 | 2020-06-05 | Chester | Tennessee | 47023 | 12 | 0 |
211566 | 211566 | 2020-06-05 | Claiborne | Tennessee | 47025 | 12 | 0 |
211567 | 211567 | 2020-06-05 | Clay | Tennessee | 47027 | 8 | 0 |
211568 | 211568 | 2020-06-05 | Cocke | Tennessee | 47029 | 21 | 0 |
211569 | 211569 | 2020-06-05 | Coffee | Tennessee | 47031 | 81 | 0 |
211570 | 211570 | 2020-06-05 | Crockett | Tennessee | 47033 | 16 | 3 |
211571 | 211571 | 2020-06-05 | Cumberland | Tennessee | 47035 | 120 | 2 |
211572 | 211572 | 2020-06-05 | Davidson | Tennessee | 47037 | 5900 | 70 |
211573 | 211573 | 2020-06-05 | DeKalb | Tennessee | 47041 | 39 | 0 |
211574 | 211574 | 2020-06-05 | Decatur | Tennessee | 47039 | 5 | 0 |
211575 | 211575 | 2020-06-05 | Dickson | Tennessee | 47043 | 121 | 0 |
211576 | 211576 | 2020-06-05 | Dyer | Tennessee | 47045 | 59 | 0 |
211577 | 211577 | 2020-06-05 | Fayette | Tennessee | 47047 | 144 | 2 |
211578 | 211578 | 2020-06-05 | Fentress | Tennessee | 47049 | 12 | 0 |
211579 | 211579 | 2020-06-05 | Franklin | Tennessee | 47051 | 54 | 1 |
211580 | 211580 | 2020-06-05 | Gibson | Tennessee | 47053 | 63 | 1 |
211581 | 211581 | 2020-06-05 | Giles | Tennessee | 47055 | 14 | 0 |
211582 | 211582 | 2020-06-05 | Grainger | Tennessee | 47057 | 15 | 0 |
211583 | 211583 | 2020-06-05 | Greene | Tennessee | 47059 | 52 | 2 |
211584 | 211584 | 2020-06-05 | Grundy | Tennessee | 47061 | 32 | 1 |
211585 | 211585 | 2020-06-05 | Hamblen | Tennessee | 47063 | 44 | 2 |
211586 | 211586 | 2020-06-05 | Hamilton | Tennessee | 47065 | 1381 | 19 |
211587 | 211587 | 2020-06-05 | Hancock | Tennessee | 47067 | 1 | 0 |
211588 | 211588 | 2020-06-05 | Hardeman | Tennessee | 47069 | 204 | 0 |
211589 | 211589 | 2020-06-05 | Hardin | Tennessee | 47071 | 22 | 2 |
211590 | 211590 | 2020-06-05 | Hawkins | Tennessee | 47073 | 34 | 2 |
211591 | 211591 | 2020-06-05 | Haywood | Tennessee | 47075 | 34 | 2 |
211592 | 211592 | 2020-06-05 | Henderson | Tennessee | 47077 | 15 | 0 |
211593 | 211593 | 2020-06-05 | Henry | Tennessee | 47079 | 31 | 0 |
211594 | 211594 | 2020-06-05 | Hickman | Tennessee | 47081 | 59 | 0 |
211595 | 211595 | 2020-06-05 | Houston | Tennessee | 47083 | 7 | 0 |
211596 | 211596 | 2020-06-05 | Humphreys | Tennessee | 47085 | 16 | 1 |
211597 | 211597 | 2020-06-05 | Jackson | Tennessee | 47087 | 19 | 0 |
211598 | 211598 | 2020-06-05 | Jefferson | Tennessee | 47089 | 29 | 0 |
211599 | 211599 | 2020-06-05 | Johnson | Tennessee | 47091 | 18 | 0 |
211600 | 211600 | 2020-06-05 | Knox | Tennessee | 47093 | 471 | 5 |
211601 | 211601 | 2020-06-05 | Lake | Tennessee | 47095 | 725 | 0 |
211602 | 211602 | 2020-06-05 | Lauderdale | Tennessee | 47097 | 60 | 1 |
211603 | 211603 | 2020-06-05 | Lawrence | Tennessee | 47099 | 35 | 0 |
211604 | 211604 | 2020-06-05 | Lewis | Tennessee | 47101 | 3 | 0 |
211605 | 211605 | 2020-06-05 | Lincoln | Tennessee | 47103 | 30 | 0 |
211606 | 211606 | 2020-06-05 | Loudon | Tennessee | 47105 | 165 | 0 |
211607 | 211607 | 2020-06-05 | Macon | Tennessee | 47111 | 171 | 3 |
211608 | 211608 | 2020-06-05 | Madison | Tennessee | 47113 | 173 | 2 |
211609 | 211609 | 2020-06-05 | Marion | Tennessee | 47115 | 44 | 1 |
211610 | 211610 | 2020-06-05 | Marshall | Tennessee | 47117 | 34 | 1 |
211611 | 211611 | 2020-06-05 | Maury | Tennessee | 47119 | 108 | 1 |
211612 | 211612 | 2020-06-05 | McMinn | Tennessee | 47107 | 146 | 14 |
211613 | 211613 | 2020-06-05 | McNairy | Tennessee | 47109 | 15 | 0 |
211614 | 211614 | 2020-06-05 | Meigs | Tennessee | 47121 | 27 | 0 |
211615 | 211615 | 2020-06-05 | Monroe | Tennessee | 47123 | 74 | 3 |
211616 | 211616 | 2020-06-05 | Montgomery | Tennessee | 47125 | 287 | 3 |
211617 | 211617 | 2020-06-05 | Moore | Tennessee | 47127 | 5 | 0 |
211618 | 211618 | 2020-06-05 | Morgan | Tennessee | 47129 | 18 | 0 |
211619 | 211619 | 2020-06-05 | Obion | Tennessee | 47131 | 48 | 1 |
211620 | 211620 | 2020-06-05 | Overton | Tennessee | 47133 | 33 | 0 |
211621 | 211621 | 2020-06-05 | Perry | Tennessee | 47135 | 24 | 0 |
211622 | 211622 | 2020-06-05 | Pickett | Tennessee | 47137 | 3 | 0 |
211623 | 211623 | 2020-06-05 | Polk | Tennessee | 47139 | 19 | 0 |
211624 | 211624 | 2020-06-05 | Putnam | Tennessee | 47141 | 525 | 6 |
211625 | 211625 | 2020-06-05 | Rhea | Tennessee | 47143 | 216 | 0 |
211626 | 211626 | 2020-06-05 | Roane | Tennessee | 47145 | 17 | 0 |
211627 | 211627 | 2020-06-05 | Robertson | Tennessee | 47147 | 542 | 5 |
211628 | 211628 | 2020-06-05 | Rutherford | Tennessee | 47149 | 1398 | 29 |
211629 | 211629 | 2020-06-05 | Scott | Tennessee | 47151 | 13 | 0 |
211630 | 211630 | 2020-06-05 | Sequatchie | Tennessee | 47153 | 20 | 0 |
211631 | 211631 | 2020-06-05 | Sevier | Tennessee | 47155 | 100 | 2 |
211632 | 211632 | 2020-06-05 | Shelby | Tennessee | 47157 | 5669 | 127 |
211633 | 211633 | 2020-06-05 | Smith | Tennessee | 47159 | 36 | 1 |
211634 | 211634 | 2020-06-05 | Stewart | Tennessee | 47161 | 14 | 0 |
211635 | 211635 | 2020-06-05 | Sullivan | Tennessee | 47163 | 60 | 2 |
211636 | 211636 | 2020-06-05 | Sumner | Tennessee | 47165 | 951 | 46 |
211637 | 211637 | 2020-06-05 | Tipton | Tennessee | 47167 | 467 | 3 |
211638 | 211638 | 2020-06-05 | Trousdale | Tennessee | 47169 | 1394 | 4 |
211639 | 211639 | 2020-06-05 | Unicoi | Tennessee | 47171 | 49 | 0 |
211640 | 211640 | 2020-06-05 | Union | Tennessee | 47173 | 4 | 0 |
211641 | 211641 | 2020-06-05 | Unknown | Tennessee | 159 | 0 | |
211642 | 211642 | 2020-06-05 | Van Buren | Tennessee | 47175 | 4 | 0 |
211643 | 211643 | 2020-06-05 | Warren | Tennessee | 47177 | 27 | 0 |
211644 | 211644 | 2020-06-05 | Washington | Tennessee | 47179 | 76 | 0 |
211645 | 211645 | 2020-06-05 | Wayne | Tennessee | 47181 | 64 | 0 |
211646 | 211646 | 2020-06-05 | Weakley | Tennessee | 47183 | 26 | 0 |
211647 | 211647 | 2020-06-05 | White | Tennessee | 47185 | 34 | 0 |
211648 | 211648 | 2020-06-05 | Williamson | Tennessee | 47187 | 595 | 11 |
211649 | 211649 | 2020-06-05 | Wilson | Tennessee | 47189 | 459 | 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);