legislator_terms

Table actions Table actions

478 rows where "start" is on date 1977-01-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, party, 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
31416 31416 A000118 rep TN 1977-01-04 1979-01-03   Democrat 5                        
31417 31417 A000177 rep PA 1977-01-04 1979-01-03   Democrat 23                        
31421 31421 B000025 rep NY 1977-01-04 1979-01-03   Democrat 21                        
31425 31425 B000408 rep MN 1977-01-04 1979-01-03   Democrat 7                        
31427 31427 B000567 rep IA 1977-01-04 1979-01-03   Democrat 2                        
31430 31430 B000788 rep KY 1977-01-04 1979-01-03   Democrat 6                        
31436 31436 B000917 rep MI 1977-01-04 1979-01-03   Republican 3                        
31442 31442 B001091 rep FL 1977-01-04 1979-01-03   Republican 12                        
31452 31452 B001092 rep MA 1977-01-04 1979-01-03   Democrat 11                        
31455 31455 B001102 rep CA 1977-01-04 1979-01-03   Democrat 28                        
31471 31471 B001111 rep TX 1977-01-04 1979-01-03   Democrat 17                        
31474 31474 B001209 sen VA 1977-01-04 1983-01-03 1 Independent       Democrat                  
31478 31478 B001221 rep MD 1977-01-04 1979-01-03   Democrat 6                        
31482 31482 C000120 sen NV 1977-01-04 1983-01-03 1 Democrat                          
31483 31483 C000137 rep NY 1977-01-04 1979-01-03   Republican 23                        
31488 31488 C000164 rep OH 1977-01-04 1979-01-03   Democrat 19                        
31501 31501 C000263 rep MI 1977-01-04 1979-01-03   Republican 10                        
31509 31509 C000476 rep CA 1977-01-04 1979-01-03   Republican 33                        
31511 31511 C000782 rep WI 1977-01-04 1979-01-03   Democrat 8                        
31512 31512 C000787 rep IN 1977-01-04 1979-01-03   Democrat 8                        
31513 31513 C000992 rep WA 1977-01-04 1979-01-03   Republican 7                        
31529 31529 D000211 rep NY 1977-01-04 1979-01-03   Democrat 9                        
31540 31540 D000255 rep PA 1977-01-04 1979-01-03   Democrat 21                        
31546 31546 E000096 rep PA 1977-01-04 1979-01-03   Democrat 4                        
31553 31553 E000240 rep CO 1977-01-04 1979-01-03   Democrat 3                        
31558 31558 F000218 rep AL 1977-01-04 1979-01-03   Democrat 7                        
31571 31571 F000229 rep GA 1977-01-04 1979-01-03   Democrat 6                        
31579 31579 F000350 rep MN 1977-01-04 1979-01-03   Democrat 5                        
31584 31584 F000381 rep FL 1977-01-04 1979-01-03   Republican 9                        
31585 31585 G000036 rep TX 1977-01-04 1979-01-03   Democrat 22                        
31587 31587 H000166 rep CA 1977-01-04 1979-01-03   Democrat 34                        
31592 31592 H000230 rep MA 1977-01-04 1979-01-03   Democrat 6                        
31593 31593 H000384 sen CA 1977-01-04 1983-01-03 1 Republican                          
31599 31599 H000953 sen MN 1977-01-04 1978-01-13 1 Democrat                          
31602 31602 J000266 rep TX 1977-01-04 1979-01-03   Democrat 18                        
31605 31605 K000153 rep CA 1977-01-04 1979-01-03   Republican 18                        
31607 31607 K000162 rep KS 1977-01-04 1979-01-03   Democrat 2                        
31612 31612 K000302 rep NY 1977-01-04 1979-01-03   Democrat 18                        
31614 31614 K000325 rep CA 1977-01-04 1979-01-03   Democrat 17                        
31615 31615 L000561 rep NJ 1977-01-04 1979-01-03   Democrat 14                        
31623 31623 L000221 rep CA 1977-01-04 1979-01-03   Democrat 4                        
31645 31645 M000065 rep TX 1977-01-04 1979-01-03   Democrat 19                        
31650 31650 M000105 rep SC 1977-01-04 1979-01-03   Democrat 4                        
31661 31661 M000436 rep CA 1977-01-04 1979-01-03   Democrat 14                        
31668 31668 M000626 rep WA 1977-01-04 1979-01-03   Democrat 2                        
31672 31672 M000675 rep IL 1977-01-04 1979-01-03   Democrat 1                        
31674 31674 M000685 rep NJ 1977-01-04 1979-01-03   Democrat 13                        
31677 31677 M000708 rep TX 1977-01-04 1979-01-03   Democrat 24                        
31690 31690 M001035 rep CA 1977-01-04 1979-01-03   Democrat 3                        
31694 31694 M001121 sen ME 1977-01-04 1981-01-03 1 Democrat                          
31696 31696 M001128 rep PA 1977-01-04 1979-01-03   Republican 25                        
31707 31707 N000113 rep PA 1977-01-04 1979-01-03   Democrat 2                        
31709 31709 P000134 rep NY 1977-01-04 1979-01-03   Democrat 29                        
31711 31711 P000273 rep CA 1977-01-04 1979-01-03   Republican 37                        
31720 31720 P000348 rep NY 1977-01-04 1979-01-03   Democrat 1                        
31741 31741 P000398 rep TX 1977-01-04 1979-01-03   Democrat 11                        
31752 31752 Q000010 rep MN 1977-01-04 1979-01-03   Republican 1                        
31754 31754 R000268 rep OK 1977-01-04 1979-01-03   Democrat 2                        
31766 31766 R000401 rep FL 1977-01-04 1979-01-03   Democrat 11                        
31771 31771 R000421 rep WY 1977-01-04 1979-01-03   Democrat 0                        
31779 31779 R000423 rep PA 1977-01-04 1979-01-03   Democrat 15                        
31785 31785 R000512 rep MI 1977-01-04 1979-01-03   Republican 11                        
31788 31788 R000558 rep CA 1977-01-04 1979-01-03   Democrat 11                        
31791 31791 S000062 rep CT 1977-01-04 1979-01-03   Republican 5                        
31792 31792 S000132 sen NM 1977-01-04 1983-01-03 1 Republican                          
31802 31802 S000367 rep IL 1977-01-04 1979-01-03   Democrat 22                        
31821 31821 S000406 rep FL 1977-01-04 1979-01-03   Democrat 1                        
31833 31833 S000454 rep CA 1977-01-04 1979-01-03   Democrat 15                        
31841 31841 S000472 rep KS 1977-01-04 1979-01-03   Republican 5                        
31842 31842 S000844 rep MD 1977-01-04 1979-01-03   Republican 8                        
31848 31848 S000847 rep WI 1977-01-04 1979-01-03   Republican 6                        
31865 31865 T000110 rep TX 1977-01-04 1979-01-03   Democrat 6                        
31869 31869 T000234 rep NE 1977-01-04 1979-01-03   Republican 1                        
31870 31870 T000310 rep LA 1977-01-04 1979-01-03   Democrat 1                        
31871 31871 T000400 rep AR 1977-01-04 1979-01-03   Democrat 2                        
31880 31880 W000018 rep LA 1977-01-04 1979-01-03   Democrat 4                        
31883 31883 W000107 rep NY 1977-01-04 1979-01-03   Republican 33                        
31889 31889 W000317 rep OH 1977-01-04 1979-01-03   Republican 3                        
31895 31895 W000448 rep CA 1977-01-04 1979-01-03   Republican 39                        
31901 31901 W000502 sen NJ 1977-01-04 1982-03-11 1 Democrat                          
31904 31904 Y000028 rep GA 1977-01-04 1979-01-03   Democrat 5                        
31915 31915 Y000043 rep TX 1977-01-04 1979-01-03   Democrat 14                        
31921 31921 A000170 rep NY 1977-01-04 1979-01-03   Democrat 3                        
31931 31931 A000195 rep IL 1977-01-04 1979-01-03   Republican 16                        
31944 31944 A000222 rep OH 1977-01-04 1979-01-03   Democrat 9                        
31950 31950 B000083 rep WI 1977-01-04 1979-01-03   Democrat 3                        
31954 31954 B000244 rep MD 1977-01-04 1979-01-03   Republican 1                        
31957 31957 B000279 rep RI 1977-01-04 1979-01-03   Democrat 2                        
31968 31968 B000736 rep IN 1977-01-04 1979-01-03   Democrat 3                        
31976 31976 B001008 rep AL 1977-01-04 1979-01-03   Republican 6                        
31982 31982 B001113 rep MO 1977-01-04 1979-01-03   Democrat 10                        
31990 31990 C000201 rep KY 1977-01-04 1979-01-03   Republican 5                        
31992 31992 C000261 rep NE 1977-01-04 1979-01-03   Democrat 2                        
32001 32001 C000512 rep NH 1977-01-04 1979-01-03   Republican 2                        
32011 32011 C000780 rep CA 1977-01-04 1979-01-03   Democrat 21                        
32016 32016 D000125 rep SC 1977-01-04 1979-01-03   Democrat 1                        
32027 32027 D000279 rep OH 1977-01-04 1979-01-03   Republican 12                        
32040 32040 D000344 rep MI 1977-01-04 1979-01-03   Democrat 13                        
32045 32045 D000499 rep MA 1977-01-04 1979-01-03   Democrat 4                        
32050 32050 D000537 rep OR 1977-01-04 1979-01-03   Democrat 3                        

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);