ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-12-13" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
825602 | 825602 | 2020-12-13 | Anderson | Tennessee | 47001 | 4073 | 40 |
825603 | 825603 | 2020-12-13 | Bedford | Tennessee | 47003 | 3579 | 46 |
825604 | 825604 | 2020-12-13 | Benton | Tennessee | 47005 | 1003 | 22 |
825605 | 825605 | 2020-12-13 | Bledsoe | Tennessee | 47007 | 1347 | 6 |
825606 | 825606 | 2020-12-13 | Blount | Tennessee | 47009 | 7342 | 68 |
825607 | 825607 | 2020-12-13 | Bradley | Tennessee | 47011 | 6854 | 48 |
825608 | 825608 | 2020-12-13 | Campbell | Tennessee | 47013 | 1988 | 27 |
825609 | 825609 | 2020-12-13 | Cannon | Tennessee | 47015 | 1036 | 5 |
825610 | 825610 | 2020-12-13 | Carroll | Tennessee | 47017 | 2216 | 39 |
825611 | 825611 | 2020-12-13 | Carter | Tennessee | 47019 | 3498 | 75 |
825612 | 825612 | 2020-12-13 | Cheatham | Tennessee | 47021 | 2066 | 18 |
825613 | 825613 | 2020-12-13 | Chester | Tennessee | 47023 | 1201 | 25 |
825614 | 825614 | 2020-12-13 | Claiborne | Tennessee | 47025 | 1225 | 11 |
825615 | 825615 | 2020-12-13 | Clay | Tennessee | 47027 | 663 | 19 |
825616 | 825616 | 2020-12-13 | Cocke | Tennessee | 47029 | 2052 | 32 |
825617 | 825617 | 2020-12-13 | Coffee | Tennessee | 47031 | 3691 | 48 |
825618 | 825618 | 2020-12-13 | Crockett | Tennessee | 47033 | 1329 | 29 |
825619 | 825619 | 2020-12-13 | Cumberland | Tennessee | 47035 | 3235 | 44 |
825620 | 825620 | 2020-12-13 | Davidson | Tennessee | 47037 | 54412 | 475 |
825621 | 825621 | 2020-12-13 | DeKalb | Tennessee | 47041 | 1606 | 25 |
825622 | 825622 | 2020-12-13 | Decatur | Tennessee | 47039 | 1055 | 16 |
825623 | 825623 | 2020-12-13 | Dickson | Tennessee | 47043 | 3590 | 47 |
825624 | 825624 | 2020-12-13 | Dyer | Tennessee | 47045 | 3648 | 60 |
825625 | 825625 | 2020-12-13 | Fayette | Tennessee | 47047 | 2669 | 42 |
825626 | 825626 | 2020-12-13 | Fentress | Tennessee | 47049 | 1457 | 27 |
825627 | 825627 | 2020-12-13 | Franklin | Tennessee | 47051 | 2702 | 41 |
825628 | 825628 | 2020-12-13 | Gibson | Tennessee | 47053 | 3967 | 77 |
825629 | 825629 | 2020-12-13 | Giles | Tennessee | 47055 | 1842 | 53 |
825630 | 825630 | 2020-12-13 | Grainger | Tennessee | 47057 | 1344 | 21 |
825631 | 825631 | 2020-12-13 | Greene | Tennessee | 47059 | 4063 | 79 |
825632 | 825632 | 2020-12-13 | Grundy | Tennessee | 47061 | 943 | 14 |
825633 | 825633 | 2020-12-13 | Hamblen | Tennessee | 47063 | 4457 | 67 |
825634 | 825634 | 2020-12-13 | Hamilton | Tennessee | 47065 | 22633 | 212 |
825635 | 825635 | 2020-12-13 | Hancock | Tennessee | 47067 | 252 | 4 |
825636 | 825636 | 2020-12-13 | Hardeman | Tennessee | 47069 | 2501 | 40 |
825637 | 825637 | 2020-12-13 | Hardin | Tennessee | 47071 | 2123 | 31 |
825638 | 825638 | 2020-12-13 | Hawkins | Tennessee | 47073 | 2677 | 43 |
825639 | 825639 | 2020-12-13 | Haywood | Tennessee | 47075 | 1867 | 31 |
825640 | 825640 | 2020-12-13 | Henderson | Tennessee | 47077 | 2295 | 38 |
825641 | 825641 | 2020-12-13 | Henry | Tennessee | 47079 | 1907 | 26 |
825642 | 825642 | 2020-12-13 | Hickman | Tennessee | 47081 | 1444 | 21 |
825643 | 825643 | 2020-12-13 | Houston | Tennessee | 47083 | 675 | 21 |
825644 | 825644 | 2020-12-13 | Humphreys | Tennessee | 47085 | 901 | 8 |
825645 | 825645 | 2020-12-13 | Jackson | Tennessee | 47087 | 815 | 17 |
825646 | 825646 | 2020-12-13 | Jefferson | Tennessee | 47089 | 2907 | 40 |
825647 | 825647 | 2020-12-13 | Johnson | Tennessee | 47091 | 1596 | 25 |
825648 | 825648 | 2020-12-13 | Knox | Tennessee | 47093 | 24706 | 213 |
825649 | 825649 | 2020-12-13 | Lake | Tennessee | 47095 | 1288 | 10 |
825650 | 825650 | 2020-12-13 | Lauderdale | Tennessee | 47097 | 2313 | 25 |
825651 | 825651 | 2020-12-13 | Lawrence | Tennessee | 47099 | 3455 | 44 |
825652 | 825652 | 2020-12-13 | Lewis | Tennessee | 47101 | 935 | 16 |
825653 | 825653 | 2020-12-13 | Lincoln | Tennessee | 47103 | 2356 | 26 |
825654 | 825654 | 2020-12-13 | Loudon | Tennessee | 47105 | 2934 | 23 |
825655 | 825655 | 2020-12-13 | Macon | Tennessee | 47111 | 2122 | 32 |
825656 | 825656 | 2020-12-13 | Madison | Tennessee | 47113 | 6434 | 128 |
825657 | 825657 | 2020-12-13 | Marion | Tennessee | 47115 | 1469 | 21 |
825658 | 825658 | 2020-12-13 | Marshall | Tennessee | 47117 | 2153 | 23 |
825659 | 825659 | 2020-12-13 | Maury | Tennessee | 47119 | 7311 | 92 |
825660 | 825660 | 2020-12-13 | McMinn | Tennessee | 47107 | 3382 | 60 |
825661 | 825661 | 2020-12-13 | McNairy | Tennessee | 47109 | 1592 | 34 |
825662 | 825662 | 2020-12-13 | Meigs | Tennessee | 47121 | 690 | 13 |
825663 | 825663 | 2020-12-13 | Monroe | Tennessee | 47123 | 2821 | 48 |
825664 | 825664 | 2020-12-13 | Montgomery | Tennessee | 47125 | 8490 | 102 |
825665 | 825665 | 2020-12-13 | Moore | Tennessee | 47127 | 498 | 4 |
825666 | 825666 | 2020-12-13 | Morgan | Tennessee | 47129 | 1046 | 8 |
825667 | 825667 | 2020-12-13 | Obion | Tennessee | 47131 | 3101 | 63 |
825668 | 825668 | 2020-12-13 | Overton | Tennessee | 47133 | 1737 | 38 |
825669 | 825669 | 2020-12-13 | Perry | Tennessee | 47135 | 612 | 22 |
825670 | 825670 | 2020-12-13 | Pickett | Tennessee | 47137 | 452 | 16 |
825671 | 825671 | 2020-12-13 | Polk | Tennessee | 47139 | 865 | 15 |
825672 | 825672 | 2020-12-13 | Putnam | Tennessee | 47141 | 6953 | 90 |
825673 | 825673 | 2020-12-13 | Rhea | Tennessee | 47143 | 2291 | 39 |
825674 | 825674 | 2020-12-13 | Roane | Tennessee | 47145 | 3142 | 39 |
825675 | 825675 | 2020-12-13 | Robertson | Tennessee | 47147 | 4879 | 64 |
825676 | 825676 | 2020-12-13 | Rutherford | Tennessee | 47149 | 22336 | 193 |
825677 | 825677 | 2020-12-13 | Scott | Tennessee | 47151 | 1491 | 11 |
825678 | 825678 | 2020-12-13 | Sequatchie | Tennessee | 47153 | 794 | 5 |
825679 | 825679 | 2020-12-13 | Sevier | Tennessee | 47155 | 6453 | 47 |
825680 | 825680 | 2020-12-13 | Shelby | Tennessee | 47157 | 55456 | 744 |
825681 | 825681 | 2020-12-13 | Smith | Tennessee | 47159 | 1671 | 20 |
825682 | 825682 | 2020-12-13 | Stewart | Tennessee | 47161 | 707 | 19 |
825683 | 825683 | 2020-12-13 | Sullivan | Tennessee | 47163 | 8358 | 135 |
825684 | 825684 | 2020-12-13 | Sumner | Tennessee | 47165 | 12456 | 160 |
825685 | 825685 | 2020-12-13 | Tipton | Tennessee | 47167 | 4376 | 43 |
825686 | 825686 | 2020-12-13 | Trousdale | Tennessee | 47169 | 2002 | 12 |
825687 | 825687 | 2020-12-13 | Unicoi | Tennessee | 47171 | 1137 | 30 |
825688 | 825688 | 2020-12-13 | Union | Tennessee | 47173 | 952 | 6 |
825689 | 825689 | 2020-12-13 | Unknown | Tennessee | 2087 | 33 | |
825690 | 825690 | 2020-12-13 | Van Buren | Tennessee | 47175 | 448 | 4 |
825691 | 825691 | 2020-12-13 | Warren | Tennessee | 47177 | 3159 | 23 |
825692 | 825692 | 2020-12-13 | Washington | Tennessee | 47179 | 7921 | 129 |
825693 | 825693 | 2020-12-13 | Wayne | Tennessee | 47181 | 2116 | 15 |
825694 | 825694 | 2020-12-13 | Weakley | Tennessee | 47183 | 2500 | 38 |
825695 | 825695 | 2020-12-13 | White | Tennessee | 47185 | 2216 | 28 |
825696 | 825696 | 2020-12-13 | Williamson | Tennessee | 47187 | 13786 | 100 |
825697 | 825697 | 2020-12-13 | Wilson | Tennessee | 47189 | 9512 | 100 |
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);