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-20 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
162623 | 162623 | 2020-05-20 | Anderson | Tennessee | 47001 | 37 | 1 |
162624 | 162624 | 2020-05-20 | Bedford | Tennessee | 47003 | 257 | 4 |
162625 | 162625 | 2020-05-20 | Benton | Tennessee | 47005 | 7 | 1 |
162626 | 162626 | 2020-05-20 | Bledsoe | Tennessee | 47007 | 607 | 1 |
162627 | 162627 | 2020-05-20 | Blount | Tennessee | 47009 | 76 | 3 |
162628 | 162628 | 2020-05-20 | Bradley | Tennessee | 47011 | 84 | 1 |
162629 | 162629 | 2020-05-20 | Campbell | Tennessee | 47013 | 17 | 1 |
162630 | 162630 | 2020-05-20 | Cannon | Tennessee | 47015 | 13 | 0 |
162631 | 162631 | 2020-05-20 | Carroll | Tennessee | 47017 | 25 | 1 |
162632 | 162632 | 2020-05-20 | Carter | Tennessee | 47019 | 19 | 1 |
162633 | 162633 | 2020-05-20 | Cheatham | Tennessee | 47021 | 93 | 0 |
162634 | 162634 | 2020-05-20 | Chester | Tennessee | 47023 | 12 | 0 |
162635 | 162635 | 2020-05-20 | Claiborne | Tennessee | 47025 | 8 | 0 |
162636 | 162636 | 2020-05-20 | Clay | Tennessee | 47027 | 6 | 0 |
162637 | 162637 | 2020-05-20 | Cocke | Tennessee | 47029 | 20 | 0 |
162638 | 162638 | 2020-05-20 | Coffee | Tennessee | 47031 | 63 | 0 |
162639 | 162639 | 2020-05-20 | Crockett | Tennessee | 47033 | 14 | 1 |
162640 | 162640 | 2020-05-20 | Cumberland | Tennessee | 47035 | 94 | 1 |
162641 | 162641 | 2020-05-20 | Davidson | Tennessee | 47037 | 4504 | 50 |
162642 | 162642 | 2020-05-20 | DeKalb | Tennessee | 47041 | 32 | 0 |
162643 | 162643 | 2020-05-20 | Decatur | Tennessee | 47039 | 5 | 0 |
162644 | 162644 | 2020-05-20 | Dickson | Tennessee | 47043 | 93 | 0 |
162645 | 162645 | 2020-05-20 | Dyer | Tennessee | 47045 | 45 | 0 |
162646 | 162646 | 2020-05-20 | Fayette | Tennessee | 47047 | 95 | 2 |
162647 | 162647 | 2020-05-20 | Fentress | Tennessee | 47049 | 9 | 0 |
162648 | 162648 | 2020-05-20 | Franklin | Tennessee | 47051 | 43 | 1 |
162649 | 162649 | 2020-05-20 | Gibson | Tennessee | 47053 | 59 | 1 |
162650 | 162650 | 2020-05-20 | Giles | Tennessee | 47055 | 12 | 0 |
162651 | 162651 | 2020-05-20 | Grainger | Tennessee | 47057 | 6 | 0 |
162652 | 162652 | 2020-05-20 | Greene | Tennessee | 47059 | 46 | 2 |
162653 | 162653 | 2020-05-20 | Grundy | Tennessee | 47061 | 31 | 1 |
162654 | 162654 | 2020-05-20 | Hamblen | Tennessee | 47063 | 24 | 2 |
162655 | 162655 | 2020-05-20 | Hamilton | Tennessee | 47065 | 447 | 13 |
162656 | 162656 | 2020-05-20 | Hancock | Tennessee | 47067 | 1 | 0 |
162657 | 162657 | 2020-05-20 | Hardeman | Tennessee | 47069 | 183 | 0 |
162658 | 162658 | 2020-05-20 | Hardin | Tennessee | 47071 | 10 | 1 |
162659 | 162659 | 2020-05-20 | Hawkins | Tennessee | 47073 | 31 | 2 |
162660 | 162660 | 2020-05-20 | Haywood | Tennessee | 47075 | 29 | 1 |
162661 | 162661 | 2020-05-20 | Henderson | Tennessee | 47077 | 12 | 0 |
162662 | 162662 | 2020-05-20 | Henry | Tennessee | 47079 | 20 | 0 |
162663 | 162663 | 2020-05-20 | Hickman | Tennessee | 47081 | 52 | 0 |
162664 | 162664 | 2020-05-20 | Houston | Tennessee | 47083 | 7 | 0 |
162665 | 162665 | 2020-05-20 | Humphreys | Tennessee | 47085 | 12 | 1 |
162666 | 162666 | 2020-05-20 | Jackson | Tennessee | 47087 | 13 | 0 |
162667 | 162667 | 2020-05-20 | Jefferson | Tennessee | 47089 | 26 | 0 |
162668 | 162668 | 2020-05-20 | Johnson | Tennessee | 47091 | 15 | 0 |
162669 | 162669 | 2020-05-20 | Knox | Tennessee | 47093 | 327 | 5 |
162670 | 162670 | 2020-05-20 | Lake | Tennessee | 47095 | 403 | 0 |
162671 | 162671 | 2020-05-20 | Lauderdale | Tennessee | 47097 | 48 | 1 |
162672 | 162672 | 2020-05-20 | Lawrence | Tennessee | 47099 | 21 | 0 |
162673 | 162673 | 2020-05-20 | Lewis | Tennessee | 47101 | 2 | 0 |
162674 | 162674 | 2020-05-20 | Lincoln | Tennessee | 47103 | 17 | 0 |
162675 | 162675 | 2020-05-20 | Loudon | Tennessee | 47105 | 97 | 0 |
162676 | 162676 | 2020-05-20 | Macon | Tennessee | 47111 | 93 | 3 |
162677 | 162677 | 2020-05-20 | Madison | Tennessee | 47113 | 162 | 2 |
162678 | 162678 | 2020-05-20 | Marion | Tennessee | 47115 | 34 | 1 |
162679 | 162679 | 2020-05-20 | Marshall | Tennessee | 47117 | 26 | 1 |
162680 | 162680 | 2020-05-20 | Maury | Tennessee | 47119 | 71 | 0 |
162681 | 162681 | 2020-05-20 | McMinn | Tennessee | 47107 | 125 | 12 |
162682 | 162682 | 2020-05-20 | McNairy | Tennessee | 47109 | 12 | 0 |
162683 | 162683 | 2020-05-20 | Meigs | Tennessee | 47121 | 22 | 0 |
162684 | 162684 | 2020-05-20 | Monroe | Tennessee | 47123 | 51 | 2 |
162685 | 162685 | 2020-05-20 | Montgomery | Tennessee | 47125 | 216 | 2 |
162686 | 162686 | 2020-05-20 | Moore | Tennessee | 47127 | 3 | 0 |
162687 | 162687 | 2020-05-20 | Morgan | Tennessee | 47129 | 17 | 0 |
162688 | 162688 | 2020-05-20 | Obion | Tennessee | 47131 | 19 | 1 |
162689 | 162689 | 2020-05-20 | Overton | Tennessee | 47133 | 18 | 0 |
162690 | 162690 | 2020-05-20 | Perry | Tennessee | 47135 | 13 | 0 |
162691 | 162691 | 2020-05-20 | Pickett | Tennessee | 47137 | 2 | 0 |
162692 | 162692 | 2020-05-20 | Polk | Tennessee | 47139 | 14 | 0 |
162693 | 162693 | 2020-05-20 | Putnam | Tennessee | 47141 | 286 | 5 |
162694 | 162694 | 2020-05-20 | Rhea | Tennessee | 47143 | 15 | 0 |
162695 | 162695 | 2020-05-20 | Roane | Tennessee | 47145 | 9 | 0 |
162696 | 162696 | 2020-05-20 | Robertson | Tennessee | 47147 | 298 | 0 |
162697 | 162697 | 2020-05-20 | Rutherford | Tennessee | 47149 | 906 | 19 |
162698 | 162698 | 2020-05-20 | Scott | Tennessee | 47151 | 11 | 0 |
162699 | 162699 | 2020-05-20 | Sequatchie | Tennessee | 47153 | 9 | 0 |
162700 | 162700 | 2020-05-20 | Sevier | Tennessee | 47155 | 68 | 2 |
162701 | 162701 | 2020-05-20 | Shelby | Tennessee | 47157 | 4005 | 88 |
162702 | 162702 | 2020-05-20 | Smith | Tennessee | 47159 | 29 | 1 |
162703 | 162703 | 2020-05-20 | Stewart | Tennessee | 47161 | 8 | 0 |
162704 | 162704 | 2020-05-20 | Sullivan | Tennessee | 47163 | 57 | 2 |
162705 | 162705 | 2020-05-20 | Sumner | Tennessee | 47165 | 768 | 41 |
162706 | 162706 | 2020-05-20 | Tipton | Tennessee | 47167 | 407 | 2 |
162707 | 162707 | 2020-05-20 | Trousdale | Tennessee | 47169 | 1384 | 4 |
162708 | 162708 | 2020-05-20 | Unicoi | Tennessee | 47171 | 3 | 0 |
162709 | 162709 | 2020-05-20 | Union | Tennessee | 47173 | 4 | 0 |
162710 | 162710 | 2020-05-20 | Unknown | Tennessee | 109 | 4 | |
162711 | 162711 | 2020-05-20 | Van Buren | Tennessee | 47175 | 4 | 0 |
162712 | 162712 | 2020-05-20 | Warren | Tennessee | 47177 | 16 | 0 |
162713 | 162713 | 2020-05-20 | Washington | Tennessee | 47179 | 70 | 0 |
162714 | 162714 | 2020-05-20 | Wayne | Tennessee | 47181 | 63 | 0 |
162715 | 162715 | 2020-05-20 | Weakley | Tennessee | 47183 | 27 | 0 |
162716 | 162716 | 2020-05-20 | White | Tennessee | 47185 | 21 | 0 |
162717 | 162717 | 2020-05-20 | Williamson | Tennessee | 47187 | 492 | 10 |
162718 | 162718 | 2020-05-20 | 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);