legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
114 rows where state = "GA" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, how, address, fax, office, state_rank, rss_url, end (date)
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | William Few F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
140 | 140 | George Walton W000114 | sen | GA | 1795-11-16 | 1796-02-20 | 2 | Federalist | |||||||||||||
167 | 167 | James Gunn G000526 | sen | GA | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
168 | 168 | James Gunn G000526 | sen | GA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
238 | 238 | Josiah Tattnall T000052 | sen | GA | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
494 | 494 | James Jackson J000017 | sen | GA | 1793-12-02 | 1795-12-31 | 2 | Republican | |||||||||||||
495 | 495 | James Jackson J000017 | sen | GA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
661 | 661 | Abraham Baldwin B000084 | sen | GA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
662 | 662 | Abraham Baldwin B000084 | sen | GA | 1805-12-02 | 1807-03-04 | 2 | Republican | |||||||||||||
796 | 796 | John Milledge M000712 | sen | GA | 1806-06-19 | 1807-03-03 | 3 | Republican | |||||||||||||
797 | 797 | John Milledge M000712 | sen | GA | 1807-10-26 | 1809-11-14 | 3 | Republican | |||||||||||||
861 | 861 | George Jones J000220 | sen | GA | 1807-10-26 | 1807-12-31 | 2 | Republican | |||||||||||||
1140 | 1140 | William Crawford C000895 | sen | GA | 1807-10-26 | 1811-03-03 | 2 | Republican | |||||||||||||
1141 | 1141 | William Crawford C000895 | sen | GA | 1811-11-04 | 1813-12-31 | 2 | Republican | |||||||||||||
1284 | 1284 | William Bibb B000434 | sen | GA | 1813-11-06 | 1816-11-09 | 2 | Republican | |||||||||||||
1304 | 1304 | William Bulloch B001051 | sen | GA | 1813-05-24 | 1813-12-31 | 2 | Republican | |||||||||||||
1419 | 1419 | Charles Tait T000015 | sen | GA | 1809-05-22 | 1813-03-03 | 3 | Republican | |||||||||||||
1420 | 1420 | Charles Tait T000015 | sen | GA | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
2018 | 2018 | John Elliott E000124 | sen | GA | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2166 | 2166 | Freeman Walker W000052 | sen | GA | 1819-12-06 | 1821-12-31 | 2 | Republican | |||||||||||||
2523 | 2523 | Nicholas Ware W000148 | sen | GA | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
2524 | 2524 | Nicholas Ware W000148 | sen | GA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2544 | 2544 | Thomas Cobb C000553 | sen | GA | 1824-01-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3019 | 3019 | Oliver Prince P000539 | sen | GA | 1828-01-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3254 | 3254 | George Troup T000382 | sen | GA | 1816-11-13 | 1817-03-03 | 2 | Republican | |||||||||||||
3255 | 3255 | George Troup T000382 | sen | GA | 1817-03-04 | 1818-09-23 | 2 | Republican | |||||||||||||
3256 | 3256 | George Troup T000382 | sen | GA | 1829-12-07 | 1833-11-08 | 2 | Jackson | |||||||||||||
3386 | 3386 | John Forsyth F000284 | sen | GA | 1818-11-23 | 1819-02-17 | 2 | Republican | |||||||||||||
3389 | 3389 | John Forsyth F000284 | sen | GA | 1829-12-07 | 1831-03-03 | 3 | Jackson | |||||||||||||
3390 | 3390 | John Forsyth F000284 | sen | GA | 1831-12-05 | 1834-06-27 | 3 | Jackson | |||||||||||||
3973 | 3973 | John King K000207 | sen | GA | 1833-12-02 | 1835-03-03 | 2 | Jackson | |||||||||||||
3974 | 3974 | John King K000207 | sen | GA | 1835-12-07 | 1837-12-31 | 2 | Democrat | |||||||||||||
4189 | 4189 | Alfred Cuthbert C001023 | sen | GA | 1835-12-07 | 1837-03-03 | 3 | Jackson | |||||||||||||
4190 | 4190 | Alfred Cuthbert C001023 | sen | GA | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
4267 | 4267 | Wilson Lumpkin L000512 | sen | GA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
5176 | 5176 | Walter Colquitt C000648 | sen | GA | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5614 | 5614 | John Berrien B000413 | sen | GA | 1825-12-05 | 1829-12-31 | 3 | Jackson | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5869 | 5869 | Herschel Johnson J000139 | sen | GA | 1848-01-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5956 | 5956 | William Dawson D000156 | sen | GA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6472 | 6472 | Robert Charlton C000324 | sen | GA | 1852-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6844 | 6844 | Alfred Iverson I000049 | sen | GA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7613 | 7613 | Robert Toombs T000313 | sen | GA | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7614 | 7614 | Robert Toombs T000313 | sen | GA | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
8931 | 8931 | Joshua Hill H000599 | sen | GA | 1871-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8970 | 8970 | Homer Miller M000728 | sen | GA | 1871-03-04 | 1871-12-31 | 2 | Democrat | |||||||||||||
9851 | 9851 | Benjamin Hill H000587 | sen | GA | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
10620 | 10620 | Middleton Barrow B000184 | sen | GA | 1882-01-01 | 1883-03-03 | 2 | Democrat | |||||||||||||
10978 | 10978 | Joseph Brown B000936 | sen | GA | 1880-01-01 | 1885-03-03 | 3 | Democrat | |||||||||||||
10979 | 10979 | Joseph Brown B000936 | sen | GA | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11461 | 11461 | Thomas Norwood N000160 | sen | GA | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11679 | 11679 | Alfred Colquitt C000647 | sen | GA | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11680 | 11680 | Alfred Colquitt C000647 | sen | GA | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
12182 | 12182 | John Gordon G000313 | sen | GA | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
12183 | 12183 | John Gordon G000313 | sen | GA | 1879-03-18 | 1881-03-03 | 3 | Democrat | |||||||||||||
12184 | 12184 | John Gordon G000313 | sen | GA | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12885 | 12885 | Patrick Walsh W000103 | sen | GA | 1894-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
15386 | 15386 | Alexander Clay C000478 | sen | GA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
15387 | 15387 | Alexander Clay C000478 | sen | GA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15388 | 15388 | Alexander Clay C000478 | sen | GA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15828 | 15828 | Joseph Terrell T000131 | sen | GA | 1910-01-01 | 1911-12-31 | 3 | Democrat | |||||||||||||
16256 | 16256 | Augustus Bacon B000014 | sen | GA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16258 | 16258 | Augustus Bacon B000014 | sen | GA | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
16259 | 16259 | Augustus Bacon B000014 | sen | GA | 1913-04-07 | 1915-03-03 | 2 | Democrat | |||||||||||||
16658 | 16658 | Thomas Hardwick H000193 | sen | GA | 1914-01-01 | 1919-03-03 | 2 | Democrat | |||||||||||||
16660 | 16660 | William West W000305 | sen | GA | 1914-03-02 | 1915-03-03 | 2 | Democrat | appointment | ||||||||||||
16964 | 16964 | Hoke Smith S000551 | sen | GA | 1911-04-04 | 1915-03-03 | 3 | Democrat | |||||||||||||
16965 | 16965 | Hoke Smith S000551 | sen | GA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
20475 | 20475 | William Harris H000259 | sen | GA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20476 | 20476 | William Harris H000259 | sen | GA | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20477 | 20477 | William Harris H000259 | sen | GA | 1931-12-07 | 1933-03-03 | 2 | Democrat | |||||||||||||
21061 | 21061 | John Cohen C000597 | sen | GA | 1932-04-25 | 1933-12-31 | 2 | Democrat | appointment | ||||||||||||
25266 | 25266 | Walter George G000131 | sen | GA | 1922-01-01 | 1927-03-04 | 3 | Democrat | |||||||||||||
25267 | 25267 | Walter George G000131 | sen | GA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
25268 | 25268 | Walter George G000131 | sen | GA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25269 | 25269 | Walter George G000131 | sen | GA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25271 | 25271 | Walter George G000131 | sen | GA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
29024 | 29024 | Richard Russell R000536 | sen | GA | 1933-03-09 | 1937-01-03 | 2 | Democrat | |||||||||||||
29025 | 29025 | Richard Russell R000536 | sen | GA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
29028 | 29028 | Richard Russell R000536 | sen | GA | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
29029 | 29029 | Richard Russell R000536 | sen | GA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29030 | 29030 | Richard Russell R000536 | sen | GA | 1967-01-10 | 1971-01-21 | 2 | Democrat | |||||||||||||
29800 | 29800 | David Gambrell G000034 | sen | GA | 1971-02-01 | 1973-01-03 | 2 | Democrat | appointment | ||||||||||||
31381 | 31381 | Herman Talmadge T000035 | sen | GA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
31382 | 31382 | Herman Talmadge T000035 | sen | GA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31383 | 31383 | Herman Talmadge T000035 | sen | GA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31384 | 31384 | Herman Talmadge T000035 | sen | GA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32750 | 32750 | Mack Mattingly M000257 | sen | GA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33583 | 33583 | Wyche Fowler F000329 | sen | GA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
34797 | 34797 | Samuel Nunn N000171 | sen | GA | 1972-11-08 | 1973-01-03 | 2 | Democrat | |||||||||||||
34798 | 34798 | Samuel Nunn N000171 | sen | GA | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
34799 | 34799 | Samuel Nunn N000171 | sen | GA | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34800 | 34800 | Samuel Nunn N000171 | sen | GA | 1985-01-03 | 1991-01-03 | 2 | Democrat |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);