legislator_terms

Table actions Table actions

1,256 rows where state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, start (date), end (date)

Link rowid ▼ legislator_id type state start end class party district how party_affiliations caucus url address phone fax contact_form office state_rank rss_url end-type
9 9 F000100 sen GA 1789-03-04 1793-03-03 2 Anti-Administration                          
21 21 M000234 rep GA 1789-03-04 1791-03-03     3                        
64 64 W000216 rep GA 1791-10-24 1793-03-03     1                        
69 69 W000560 rep GA 1791-10-24 1793-03-03     3                        
82 82 C000163 rep GA 1793-12-02 1795-03-03     0                        
140 140 W000114 sen GA 1795-11-16 1796-02-20 2 Federalist                          
167 167 G000526 sen GA 1789-03-04 1795-03-03 3 Federalist                          
168 168 G000526 sen GA 1795-12-07 1801-03-03 3 Federalist                          
238 238 T000052 sen GA 1796-01-01 1799-03-03 2 Republican                          
387 387 J000227 rep GA 1799-12-02 1801-03-03   Federalist -1                        
493 493 J000017 rep GA 1789-03-04 1791-03-03   Republican 1                        
494 494 J000017 sen GA 1793-12-02 1795-12-31 2 Republican                          
495 495 J000017 sen GA 1801-12-07 1807-03-03 3 Republican                          
532 532 T000025 rep GA 1799-12-02 1801-03-03   Federalist -1                        
533 533 T000025 rep GA 1801-12-07 1803-03-03   Republican -1                        
581 581 H000133 rep GA 1803-10-17 1805-03-03   Republican -1                        
656 656 B000084 rep GA 1789-03-04 1791-03-03   Democratic Republican 2                        
657 657 B000084 rep GA 1791-10-24 1793-03-03   Democratic Republican 2                        
658 658 B000084 rep GA 1793-12-02 1795-03-03   Democratic Republican 0                        
659 659 B000084 rep GA 1795-12-07 1797-03-03   Republican 0                        
660 660 B000084 rep GA 1797-05-15 1799-03-03   Republican -1                        
661 661 B000084 sen GA 1799-12-02 1805-03-03 2 Republican                          
662 662 B000084 sen GA 1805-12-02 1807-03-04 2 Republican                          
671 671 B000989 rep GA 1803-10-17 1805-03-03   Republican -1                        
672 672 B000989 rep GA 1805-12-02 1807-03-03   Republican -1                        
684 684 E000014 rep GA 1801-12-07 1803-03-03   Republican -1                        
685 685 E000014 rep GA 1803-10-17 1805-03-03   Republican -1                        
686 686 E000014 rep GA 1805-12-02 1807-03-03   Republican -1                        
730 730 M000614 rep GA 1805-12-02 1807-03-03   Republican -1                        
731 731 M000649 rep GA 1801-12-07 1803-03-03   Republican -1                        
732 732 M000649 rep GA 1803-10-17 1805-03-03   Republican -1                        
733 733 M000649 rep GA 1805-12-02 1807-03-03   Republican -1                        
753 753 S000698 rep GA 1805-12-02 1807-03-03   Republican -1                        
792 792 M000712 rep GA 1792-11-22 1793-03-03     1                        
793 793 M000712 rep GA 1795-12-07 1797-03-03   Republican 0                        
794 794 M000712 rep GA 1797-05-15 1799-03-03   Republican 0                        
795 795 M000712 rep GA 1801-12-07 1803-03-03   Republican 0                        
796 796 M000712 sen GA 1806-06-19 1807-03-03 3 Republican                          
797 797 M000712 sen GA 1807-10-26 1809-11-14 3 Republican                          
861 861 J000220 sen GA 1807-10-26 1807-12-31 2 Republican                          
1060 1060 S000507 rep GA 1806-09-01 1807-03-03   Republican 0                        
1061 1061 S000507 rep GA 1807-10-26 1809-03-03   Republican 0                        
1062 1062 S000507 rep GA 1809-05-22 1811-03-03   Republican 0                        
1134 1134 C000547 rep GA 1807-10-26 1809-03-03   Republican -1                        
1135 1135 C000547 rep GA 1809-05-22 1811-03-03   Republican -1                        
1136 1136 C000547 rep GA 1811-11-04 1813-03-03   Republican -1                        
1140 1140 C000895 sen GA 1807-10-26 1811-03-03 2 Republican                          
1141 1141 C000895 sen GA 1811-11-04 1813-12-31 2 Republican                          
1272 1272 B000161 rep GA 1811-11-04 1813-03-03   Republican -1                        
1273 1273 B000161 rep GA 1813-05-24 1815-03-03   Republican -1                        
1279 1279 B000434 rep GA 1807-01-26 1807-03-03   Republican -1                        
1280 1280 B000434 rep GA 1807-10-26 1809-03-03   Republican -1                        
1281 1281 B000434 rep GA 1809-05-22 1811-03-03   Republican -1                        
1282 1282 B000434 rep GA 1811-11-04 1813-03-03   Republican -1                        
1283 1283 B000434 rep GA 1813-05-24 1813-11-06   Republican -1                        
1284 1284 B000434 sen GA 1813-11-06 1816-11-09 2 Republican                          
1304 1304 B001051 sen GA 1813-05-24 1813-12-31 2 Republican                          
1419 1419 T000015 sen GA 1809-05-22 1813-03-03 3 Republican                          
1420 1420 T000015 sen GA 1813-05-24 1819-03-03 3 Republican                          
1597 1597 H000045 rep GA 1811-11-04 1813-03-03   Republican -1                        
1598 1598 H000045 rep GA 1813-05-24 1815-03-03   Republican -1                        
1599 1599 H000045 rep GA 1815-12-04 1817-03-03   Republican -1                        
1749 1749 T000115 rep GA 1813-05-24 1815-03-03   Republican -1                        
1750 1750 T000115 rep GA 1815-12-04 1817-03-03   Republican -1                        
1817 1817 C000728 rep GA 1815-12-04 1817-03-03   Republican -1                        
1818 1818 C000728 rep GA 1817-12-01 1819-03-03   Republican -1                        
2002 2002 C000891 rep GA 1817-12-01 1819-03-03   Republican -1                        
2003 2003 C000891 rep GA 1819-12-06 1821-03-03   Republican -1                        
2008 2008 C001024 rep GA 1819-12-06 1821-03-03   Republican -1                        
2018 2018 E000124 sen GA 1819-12-06 1825-03-03 3 Republican                          
2159 2159 T000132 rep GA 1817-12-01 1819-03-03   Republican -1                        
2160 2160 T000132 rep GA 1819-12-06 1821-03-03   Republican -1                        
2166 2166 W000052 sen GA 1819-12-06 1821-12-31 2 Republican                          
2309 2309 R000151 rep GA 1817-12-01 1819-03-03   Republican -1                        
2310 2310 R000151 rep GA 1819-12-06 1821-03-03   Republican -1                        
2311 2311 R000151 rep GA 1821-12-03 1823-03-03   Republican -1                        
2373 2373 A000003 rep GA 1817-12-01 1819-03-03   Republican -1                        
2374 2374 A000003 rep GA 1819-12-06 1821-03-03   Republican -1                        
2375 2375 A000003 rep GA 1821-12-03 1823-03-03   Republican -1                        
2376 2376 A000003 rep GA 1823-12-01 1825-03-03   Republican -1                        
2523 2523 W000148 sen GA 1821-12-03 1823-03-03 2 Republican                          
2524 2524 W000148 sen GA 1823-12-01 1825-03-03 2                            
2542 2542 C000553 rep GA 1817-12-01 1819-03-03   Republican -1                        
2543 2543 C000553 rep GA 1819-12-06 1821-03-03   Republican -1                        
2544 2544 C000553 sen GA 1824-01-01 1829-03-03 2 Jackson                          
2570 2570 C000212 rep GA 1823-12-01 1825-03-03     -1                        
2571 2571 C000212 rep GA 1825-12-05 1827-03-03   Jackson -1                        
2689 2689 M000651 rep GA 1825-12-05 1827-03-03   Jackson -1                        
2836 2836 F000220 rep GA 1827-12-03 1829-03-03   Jackson 7                        
2843 2843 F000289 rep GA 1827-12-03 1829-03-03   Jackson 6                        
2973 2973 T000051 rep GA 1821-12-03 1823-03-03   Republican -1                        
2974 2974 T000051 rep GA 1823-12-01 1825-03-03   Crawford Republican -1                        
2975 2975 T000051 rep GA 1825-12-05 1827-03-03   Jackson -1                        
2976 2976 T000051 rep GA 1827-12-03 1829-03-03   Jackson 1                        
3019 3019 P000539 sen GA 1828-01-01 1829-03-03 2 Jackson                          
3250 3250 T000382 rep GA 1807-10-26 1809-03-03   Republican -1                        
3251 3251 T000382 rep GA 1809-05-22 1811-03-03   Republican -1                        
3252 3252 T000382 rep GA 1811-11-04 1813-03-03   Republican -1                        
3253 3253 T000382 rep GA 1813-05-24 1815-03-03   Republican -1                        
3254 3254 T000382 sen GA 1816-11-13 1817-03-03 2 Republican                          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, [caucus] TEXT, [url] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);