legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
830 rows where party = "Democrat" and state = "GA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, address, phone, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3974 | 3974 | John King K000207 | sen | GA | 1835-12-07 | 1837-12-31 | 2 | Democrat | |||||||||||||
4177 | 4177 | Jesse Cleveland C000513 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4190 | 4190 | Alfred Cuthbert C001023 | sen | GA | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
4208 | 4208 | Thomas Glascock G000230 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4212 | 4212 | Seaton Grantland G000385 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4231 | 4231 | Charles Haynes H000399 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4235 | 4235 | Hopkins Holsey H000744 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4248 | 4248 | Jabez Jackson J000015 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4267 | 4267 | Wilson Lumpkin L000512 | sen | GA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4307 | 4307 | George Owens O000157 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
5135 | 5135 | Edward Black B000494 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5136 | 5136 | Edward Black B000494 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5175 | 5175 | Walter Colquitt C000648 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5176 | 5176 | Walter Colquitt C000648 | sen | GA | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5178 | 5178 | Mark Cooper C000759 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5179 | 5179 | Mark Cooper C000759 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5243 | 5243 | John Lamar L000029 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5253 | 5253 | John Millen M000713 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5306 | 5306 | William Stiles S000925 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5463 | 5463 | Seaborn Jones J000252 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5547 | 5547 | George Towns T000327 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
5548 | 5548 | George Towns T000327 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5869 | 5869 | Herschel Johnson J000139 | sen | GA | 1848-01-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5988 | 5988 | Thomas Hackett H000005 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5992 | 5992 | Hugh Haralson H000178 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5993 | 5993 | Hugh Haralson H000178 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5994 | 5994 | Hugh Haralson H000178 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5995 | 5995 | Hugh Haralson H000178 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6169 | 6169 | Marshall Wellborn W000271 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6340 | 6340 | Joseph Jackson J000023 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6472 | 6472 | Robert Charlton C000324 | sen | GA | 1852-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6500 | 6500 | David Bailey B000036 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6542 | 6542 | Elijah Chastain C000335 | rep | GA | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6543 | 6543 | Elijah Chastain C000335 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6564 | 6564 | William Dent D000257 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6613 | 6613 | Junius Hillyer H000625 | rep | GA | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6614 | 6614 | Junius Hillyer H000625 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6788 | 6788 | Howell Cobb C000548 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6789 | 6789 | Howell Cobb C000548 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
6790 | 6790 | Howell Cobb C000548 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6791 | 6791 | Howell Cobb C000548 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6792 | 6792 | Howell Cobb C000548 | rep | GA | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
6843 | 6843 | Alfred Iverson I000049 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6844 | 6844 | Alfred Iverson I000049 | sen | GA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6861 | 6861 | John Lumpkin L000511 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6862 | 6862 | John Lumpkin L000511 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
6863 | 6863 | John Lumpkin L000511 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6864 | 6864 | John Lumpkin L000511 | rep | GA | 1855-12-03 | 1857-03-03 | Democrat | 5 | |||||||||||||
6942 | 6942 | Hiram Warner W000152 | rep | GA | 1855-12-03 | 1857-03-03 | Democrat | 4 | |||||||||||||
7215 | 7215 | James Seward S000260 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
7216 | 7216 | James Seward S000260 | rep | GA | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
7217 | 7217 | James Seward S000260 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7254 | 7254 | Augustus Wright W000755 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
7366 | 7366 | Martin Crawford C000892 | rep | GA | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
7367 | 7367 | Martin Crawford C000892 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7368 | 7368 | Martin Crawford C000892 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7416 | 7416 | Lucius Gartrell G000088 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7417 | 7417 | Lucius Gartrell G000088 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7459 | 7459 | James Jackson J000016 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7460 | 7460 | James Jackson J000016 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7463 | 7463 | John Jones J000235 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7487 | 7487 | Peter Love L000457 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
7615 | 7615 | John Underwood U000010 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
8561 | 8561 | Stephen Corker C000776 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8688 | 8688 | William Paine P000031 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8749 | 8749 | Nelson Tift T000269 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8750 | 8750 | Nelson Tift T000269 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8810 | 8810 | Erasmus Beck B000288 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
8882 | 8882 | Dudley Du Bose D000510 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8949 | 8949 | Archibald MacIntyre M000017 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8970 | 8970 | Homer Miller M000728 | sen | GA | 1871-03-04 | 1871-12-31 | 2 | Democrat | |||||||||||||
8995 | 8995 | William Price P000533 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8996 | 8996 | William Price P000533 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9321 | 9321 | Morgan Rawls R000074 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9428 | 9428 | Pierce Young Y000048 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
9429 | 9429 | Pierce Young Y000048 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 7 | |||||||||||||
9430 | 9430 | Pierce Young Y000048 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9431 | 9431 | Pierce Young Y000048 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9741 | 9741 | Hiram Bell B000336 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9742 | 9742 | Hiram Bell B000336 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
9767 | 9767 | Milton Candler C000112 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9768 | 9768 | Milton Candler C000112 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9807 | 9807 | William Fleming F000197 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9836 | 9836 | Julian Hartridge H000303 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9837 | 9837 | Julian Hartridge H000303 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9850 | 9850 | Benjamin Hill H000587 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 9 | |||||||||||||
9851 | 9851 | Benjamin Hill H000587 | sen | GA | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
10197 | 10197 | William Smith S000631 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
10198 | 10198 | William Smith S000631 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10199 | 10199 | William Smith S000631 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10269 | 10269 | George Black B000497 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10306 | 10306 | Philip Cook C000724 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10307 | 10307 | Philip Cook C000724 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
10308 | 10308 | Philip Cook C000724 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10309 | 10309 | Philip Cook C000724 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10310 | 10310 | Philip Cook C000724 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10555 | 10555 | Alexander Stephens S000854 | rep | GA | 1855-12-03 | 1857-03-03 | Democrat | 8 | |||||||||||||
10556 | 10556 | Alexander Stephens S000854 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 8 |
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);