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-12-01 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
786658 | 786658 | 2020-12-01 | Anderson | Tennessee | 47001 | 3167 | 30 |
786659 | 786659 | 2020-12-01 | Bedford | Tennessee | 47003 | 2922 | 32 |
786660 | 786660 | 2020-12-01 | Benton | Tennessee | 47005 | 864 | 14 |
786661 | 786661 | 2020-12-01 | Bledsoe | Tennessee | 47007 | 1194 | 5 |
786662 | 786662 | 2020-12-01 | Blount | Tennessee | 47009 | 5863 | 62 |
786663 | 786663 | 2020-12-01 | Bradley | Tennessee | 47011 | 5583 | 37 |
786664 | 786664 | 2020-12-01 | Campbell | Tennessee | 47013 | 1631 | 23 |
786665 | 786665 | 2020-12-01 | Cannon | Tennessee | 47015 | 795 | 4 |
786666 | 786666 | 2020-12-01 | Carroll | Tennessee | 47017 | 1812 | 35 |
786667 | 786667 | 2020-12-01 | Carter | Tennessee | 47019 | 2905 | 58 |
786668 | 786668 | 2020-12-01 | Cheatham | Tennessee | 47021 | 1685 | 17 |
786669 | 786669 | 2020-12-01 | Chester | Tennessee | 47023 | 1044 | 21 |
786670 | 786670 | 2020-12-01 | Claiborne | Tennessee | 47025 | 933 | 9 |
786671 | 786671 | 2020-12-01 | Clay | Tennessee | 47027 | 562 | 18 |
786672 | 786672 | 2020-12-01 | Cocke | Tennessee | 47029 | 1683 | 30 |
786673 | 786673 | 2020-12-01 | Coffee | Tennessee | 47031 | 2990 | 42 |
786674 | 786674 | 2020-12-01 | Crockett | Tennessee | 47033 | 1177 | 27 |
786675 | 786675 | 2020-12-01 | Cumberland | Tennessee | 47035 | 2699 | 37 |
786676 | 786676 | 2020-12-01 | Davidson | Tennessee | 47037 | 47160 | 423 |
786677 | 786677 | 2020-12-01 | DeKalb | Tennessee | 47041 | 1235 | 22 |
786678 | 786678 | 2020-12-01 | Decatur | Tennessee | 47039 | 964 | 13 |
786679 | 786679 | 2020-12-01 | Dickson | Tennessee | 47043 | 3025 | 35 |
786680 | 786680 | 2020-12-01 | Dyer | Tennessee | 47045 | 3283 | 52 |
786681 | 786681 | 2020-12-01 | Fayette | Tennessee | 47047 | 2329 | 39 |
786682 | 786682 | 2020-12-01 | Fentress | Tennessee | 47049 | 1253 | 20 |
786683 | 786683 | 2020-12-01 | Franklin | Tennessee | 47051 | 2210 | 36 |
786684 | 786684 | 2020-12-01 | Gibson | Tennessee | 47053 | 3340 | 68 |
786685 | 786685 | 2020-12-01 | Giles | Tennessee | 47055 | 1533 | 49 |
786686 | 786686 | 2020-12-01 | Grainger | Tennessee | 47057 | 1082 | 17 |
786687 | 786687 | 2020-12-01 | Greene | Tennessee | 47059 | 3304 | 73 |
786688 | 786688 | 2020-12-01 | Grundy | Tennessee | 47061 | 800 | 14 |
786689 | 786689 | 2020-12-01 | Hamblen | Tennessee | 47063 | 3679 | 61 |
786690 | 786690 | 2020-12-01 | Hamilton | Tennessee | 47065 | 18602 | 158 |
786691 | 786691 | 2020-12-01 | Hancock | Tennessee | 47067 | 185 | 4 |
786692 | 786692 | 2020-12-01 | Hardeman | Tennessee | 47069 | 2288 | 38 |
786693 | 786693 | 2020-12-01 | Hardin | Tennessee | 47071 | 1821 | 25 |
786694 | 786694 | 2020-12-01 | Hawkins | Tennessee | 47073 | 2071 | 35 |
786695 | 786695 | 2020-12-01 | Haywood | Tennessee | 47075 | 1665 | 30 |
786696 | 786696 | 2020-12-01 | Henderson | Tennessee | 47077 | 1918 | 34 |
786697 | 786697 | 2020-12-01 | Henry | Tennessee | 47079 | 1608 | 18 |
786698 | 786698 | 2020-12-01 | Hickman | Tennessee | 47081 | 1226 | 19 |
786699 | 786699 | 2020-12-01 | Houston | Tennessee | 47083 | 599 | 20 |
786700 | 786700 | 2020-12-01 | Humphreys | Tennessee | 47085 | 750 | 8 |
786701 | 786701 | 2020-12-01 | Jackson | Tennessee | 47087 | 712 | 10 |
786702 | 786702 | 2020-12-01 | Jefferson | Tennessee | 47089 | 2412 | 33 |
786703 | 786703 | 2020-12-01 | Johnson | Tennessee | 47091 | 1447 | 23 |
786704 | 786704 | 2020-12-01 | Knox | Tennessee | 47093 | 20026 | 172 |
786705 | 786705 | 2020-12-01 | Lake | Tennessee | 47095 | 1182 | 6 |
786706 | 786706 | 2020-12-01 | Lauderdale | Tennessee | 47097 | 2101 | 24 |
786707 | 786707 | 2020-12-01 | Lawrence | Tennessee | 47099 | 2841 | 34 |
786708 | 786708 | 2020-12-01 | Lewis | Tennessee | 47101 | 787 | 14 |
786709 | 786709 | 2020-12-01 | Lincoln | Tennessee | 47103 | 1711 | 18 |
786710 | 786710 | 2020-12-01 | Loudon | Tennessee | 47105 | 2395 | 20 |
786711 | 786711 | 2020-12-01 | Macon | Tennessee | 47111 | 1874 | 29 |
786712 | 786712 | 2020-12-01 | Madison | Tennessee | 47113 | 5519 | 111 |
786713 | 786713 | 2020-12-01 | Marion | Tennessee | 47115 | 1153 | 19 |
786714 | 786714 | 2020-12-01 | Marshall | Tennessee | 47117 | 1827 | 22 |
786715 | 786715 | 2020-12-01 | Maury | Tennessee | 47119 | 6261 | 69 |
786716 | 786716 | 2020-12-01 | McMinn | Tennessee | 47107 | 2738 | 55 |
786717 | 786717 | 2020-12-01 | McNairy | Tennessee | 47109 | 1431 | 33 |
786718 | 786718 | 2020-12-01 | Meigs | Tennessee | 47121 | 516 | 13 |
786719 | 786719 | 2020-12-01 | Monroe | Tennessee | 47123 | 2295 | 44 |
786720 | 786720 | 2020-12-01 | Montgomery | Tennessee | 47125 | 7001 | 85 |
786721 | 786721 | 2020-12-01 | Moore | Tennessee | 47127 | 408 | 2 |
786722 | 786722 | 2020-12-01 | Morgan | Tennessee | 47129 | 780 | 6 |
786723 | 786723 | 2020-12-01 | Obion | Tennessee | 47131 | 2748 | 50 |
786724 | 786724 | 2020-12-01 | Overton | Tennessee | 47133 | 1566 | 35 |
786725 | 786725 | 2020-12-01 | Perry | Tennessee | 47135 | 498 | 21 |
786726 | 786726 | 2020-12-01 | Pickett | Tennessee | 47137 | 400 | 14 |
786727 | 786727 | 2020-12-01 | Polk | Tennessee | 47139 | 704 | 15 |
786728 | 786728 | 2020-12-01 | Putnam | Tennessee | 47141 | 6074 | 83 |
786729 | 786729 | 2020-12-01 | Rhea | Tennessee | 47143 | 1843 | 34 |
786730 | 786730 | 2020-12-01 | Roane | Tennessee | 47145 | 2519 | 29 |
786731 | 786731 | 2020-12-01 | Robertson | Tennessee | 47147 | 3954 | 53 |
786732 | 786732 | 2020-12-01 | Rutherford | Tennessee | 47149 | 18613 | 164 |
786733 | 786733 | 2020-12-01 | Scott | Tennessee | 47151 | 1144 | 7 |
786734 | 786734 | 2020-12-01 | Sequatchie | Tennessee | 47153 | 555 | 5 |
786735 | 786735 | 2020-12-01 | Sevier | Tennessee | 47155 | 5219 | 33 |
786736 | 786736 | 2020-12-01 | Shelby | Tennessee | 47157 | 49077 | 672 |
786737 | 786737 | 2020-12-01 | Smith | Tennessee | 47159 | 1488 | 20 |
786738 | 786738 | 2020-12-01 | Stewart | Tennessee | 47161 | 619 | 15 |
786739 | 786739 | 2020-12-01 | Sullivan | Tennessee | 47163 | 6787 | 102 |
786740 | 786740 | 2020-12-01 | Sumner | Tennessee | 47165 | 10255 | 137 |
786741 | 786741 | 2020-12-01 | Tipton | Tennessee | 47167 | 3794 | 39 |
786742 | 786742 | 2020-12-01 | Trousdale | Tennessee | 47169 | 1918 | 12 |
786743 | 786743 | 2020-12-01 | Unicoi | Tennessee | 47171 | 918 | 26 |
786744 | 786744 | 2020-12-01 | Union | Tennessee | 47173 | 753 | 5 |
786745 | 786745 | 2020-12-01 | Unknown | Tennessee | 676 | 0 | |
786746 | 786746 | 2020-12-01 | Van Buren | Tennessee | 47175 | 383 | 2 |
786747 | 786747 | 2020-12-01 | Warren | Tennessee | 47177 | 2484 | 20 |
786748 | 786748 | 2020-12-01 | Washington | Tennessee | 47179 | 6360 | 109 |
786749 | 786749 | 2020-12-01 | Wayne | Tennessee | 47181 | 1962 | 10 |
786750 | 786750 | 2020-12-01 | Weakley | Tennessee | 47183 | 2231 | 36 |
786751 | 786751 | 2020-12-01 | White | Tennessee | 47185 | 1862 | 19 |
786752 | 786752 | 2020-12-01 | Williamson | Tennessee | 47187 | 11837 | 81 |
786753 | 786753 | 2020-12-01 | Wilson | Tennessee | 47189 | 7883 | 82 |
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);