legislator_terms

Table actions Table actions

480 rows where "start" is on date 1957-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, class, 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
26164 26164 A000133 rep CA 1957-01-03 1959-01-03   Republican 7                        
26180 26180 A000239 rep MN 1957-01-03 1959-01-03   Republican 1                        
26184 26184 B000276 rep IN 1957-01-03 1959-01-03   Republican 5                        
26187 26187 B000698 rep IL 1957-01-03 1959-01-03   Democrat 7                        
26191 26191 B000964 rep IN 1957-01-03 1959-01-03   Republican 11                        
26201 26201 B001079 rep ND 1957-01-03 1959-01-03   Republican 0                        
26203 26203 B001167 sen CT 1957-01-03 1963-01-03 3 Republican                          
26205 26205 B001180 sen MD 1957-01-03 1963-01-03 3 Republican                          
26206 26206 B001211 rep IL 1957-01-03 1959-01-03   Republican 3                        
26209 26209 C000128 sen IN 1957-01-03 1963-01-03 3 Republican                          
26213 26213 C000182 rep PA 1957-01-03 1959-01-03   Republican 10                        
26216 26216 C000189 sen CO 1957-01-03 1963-01-03 3 Democrat                          
26225 26225 C000221 sen SD 1957-01-03 1963-01-03 3 Republican                          
26230 26230 C000386 rep PA 1957-01-03 1959-01-03   Democrat 4                        
26240 26240 C000515 rep OH 1957-01-03 1959-01-03   Republican 5                        
26252 26252 C000617 rep NY 1957-01-03 1959-01-03   Republican 37                        
26267 26267 C000755 rep TN 1957-01-03 1959-01-03   Democrat 8                        
26273 26273 C000804 rep NY 1957-01-03 1959-01-03   Republican 17                        
26276 26276 C000905 rep CT 1957-01-03 1959-01-03   Republican 3                        
26285 26285 C000993 rep IA 1957-01-03 1959-01-03   Republican 5                        
26289 26289 D000155 rep UT 1957-01-03 1959-01-03   Republican 2                        
26290 26290 D000219 rep NJ 1957-01-03 1959-01-03   Democrat 14                        
26297 26297 D000228 rep NM 1957-01-03 1959-01-03   Democrat 0                        
26298 26298 D000246 rep OH 1957-01-03 1959-01-03   Republican 11                        
26302 26302 D000278 rep MD 1957-01-03 1959-01-03   Republican 2                        
26312 26312 D000338 rep TX 1957-01-03 1959-01-03   Democrat 0                        
26323 26323 E000029 rep PA 1957-01-03 1959-01-03   Democrat 28                        
26328 26328 G000129 rep KS 1957-01-03 1959-01-03   Republican 3                        
26336 26336 G000316 rep IL 1957-01-03 1959-01-03   Democrat 8                        
26347 26347 G000447 rep KY 1957-01-03 1959-01-03   Democrat 1                        
26354 26354 G000541 rep NY 1957-01-03 1959-01-03   Republican 27                        
26362 26362 H000036 rep ME 1957-01-03 1959-01-03   Republican 1                        
26367 26367 H000182 rep IN 1957-01-03 1959-01-03   Republican 6                        
26371 26371 H000275 rep NE 1957-01-03 1959-01-03   Republican 3                        
26372 26372 H000318 rep DE 1957-01-03 1959-01-03   Republican 0                        
26380 26380 H000405 rep AR 1957-01-03 1959-01-03   Democrat 5                        
26385 26385 H000502 sen MO 1957-01-03 1960-09-13 3 Democrat                          
26392 26392 H000549 rep MA 1957-01-03 1959-01-03   Republican 1                        
26401 26401 H000613 rep CO 1957-01-03 1959-01-03   Republican 2                        
26405 26405 H000623 rep CA 1957-01-03 1959-01-03   Republican 25                        
26413 26413 H000740 rep WA 1957-01-03 1959-01-03   Republican 4                        
26416 26416 H001021 rep MD 1957-01-03 1959-01-03   Republican 6                        
26421 26421 J000045 rep PA 1957-01-03 1959-01-03   Republican 7                        
26438 26438 J000088 rep OH 1957-01-03 1959-01-03   Republican 10                        
26448 26448 K000029 rep NJ 1957-01-03 1959-01-03   Republican 12                        
26456 26456 K000030 rep NY 1957-01-03 1959-01-03   Republican 32                        
26457 26457 K000042 rep IL 1957-01-03 1959-01-03   Republican 14                        
26466 26466 K000058 rep PA 1957-01-03 1959-01-03   Democrat 21                        
26468 26468 K000300 rep MN 1957-01-03 1959-01-03   Democrat 9                        
26471 26471 K000332 rep ND 1957-01-03 1959-01-03   Republican 0                        
26477 26477 L000077 rep GA 1957-01-03 1959-01-03   Democrat 7                        
26484 26484 L000108 rep NY 1957-01-03 1959-01-03   Republican 4                        
26494 26494 L000157 rep IA 1957-01-03 1959-01-03   Republican 4                        
26497 26497 L000416 rep LA 1957-01-03 1959-01-03   Democrat 8                        
26498 26498 M000274 rep CT 1957-01-03 1959-01-03   Republican 1                        
26506 26506 M000354 rep PA 1957-01-03 1959-01-03   Republican 13                        
26516 26516 M000460 rep OH 1957-01-03 1959-01-03   Republican 17                        
26517 26517 M000483 rep MI 1957-01-03 1959-01-03   Republican 7                        
26521 26521 M000609 rep IL 1957-01-03 1959-01-03   Republican 4                        
26529 26529 M000715 rep NE 1957-01-03 1959-01-03   Republican 4                        
26535 26535 M000724 rep MD 1957-01-03 1959-01-03   Republican 1                        
26539 26539 M000935 rep CT 1957-01-03 1959-01-03   Republican 4                        
26541 26541 N000017 rep WV 1957-01-03 1959-01-03   Republican 4                        
26547 26547 N000097 rep MA 1957-01-03 1959-01-03   Republican 9                        
26548 26548 N000110 rep IN 1957-01-03 1959-01-03   Republican 3                        
26557 26557 O000056 rep MN 1957-01-03 1959-01-03   Republican 2                        
26563 26563 P000119 rep CT 1957-01-03 1959-01-03   Republican 5                        
26567 26567 R000008 rep NY 1957-01-03 1959-01-03   Republican 41                        
26572 26572 R000329 rep VA 1957-01-03 1959-01-03   Democrat 1                        
26575 26575 R000359 rep KY 1957-01-03 1959-01-03   Republican 3                        
26581 26581 S000009 rep CT 1957-01-03 1959-01-03   Republican 0                        
26589 26589 S000194 rep KS 1957-01-03 1959-01-03   Republican 2                        
26594 26594 S000198 rep CA 1957-01-03 1959-01-03   Republican 1                        
26598 26598 S000315 rep IL 1957-01-03 1959-01-03   Republican 11                        
26601 26601 S000390 rep NC 1957-01-03 1959-01-03   Democrat 12                        
26605 26605 S000405 rep NJ 1957-01-03 1959-01-03   Democrat 13                        
26613 26613 S000437 rep IL 1957-01-03 1959-01-03   Republican 20                        
26622 26622 S000585 rep WI 1957-01-03 1959-01-03   Republican 1                        
26624 26624 S000819 rep PA 1957-01-03 1959-01-03   Republican 19                        
26634 26634 T000028 rep IA 1957-01-03 1959-01-03   Republican 2                        
26635 26635 T000139 rep WI 1957-01-03 1959-01-03   Republican 2                        
26645 26645 V000119 rep OH 1957-01-03 1959-01-03   Republican 12                        
26653 26653 V000125 rep IL 1957-01-03 1959-01-03   Republican 23                        
26669 26669 W000450 rep MA 1957-01-03 1959-01-03   Republican 13                        
26673 26673 W000465 sen WI 1957-01-03 1963-01-03 3 Republican                          
26677 26677 W000549 rep NY 1957-01-03 1959-01-03   Republican 34                        
26693 26693 W000683 rep NJ 1957-01-03 1959-01-03   Republican 1                        
26707 26707 A000138 rep IL 1957-01-03 1959-01-03   Republican 16                        
26709 26709 A000200 rep MT 1957-01-03 1959-01-03   Democrat 2                        
26722 26722 B000139 rep NC 1957-01-03 1959-01-03   Democrat 3                        
26727 26727 B000245 rep OH 1957-01-03 1959-01-03   Republican 13                        
26738 26738 B000391 rep MI 1957-01-03 1959-01-03   Republican 8                        
26742 26742 B000646 rep NY 1957-01-03 1959-01-03   Republican 5                        
26746 26746 B000727 rep IL 1957-01-03 1959-01-03   Democrat 12                        
26749 26749 B000908 rep MO 1957-01-03 1959-01-03   Democrat 7                        
26763 26763 B000940 rep GA 1957-01-03 1959-01-03   Democrat 10                        
26769 26769 B001035 rep ID 1957-01-03 1959-01-03   Republican 2                        
26771 26771 B001127 rep HI 1957-01-03 1959-01-03   Democrat 0                        
26776 26776 B001165 rep PA 1957-01-03 1959-01-03   Republican 17                        
26793 26793 C000113 rep NJ 1957-01-03 1959-01-03   Republican 8                        

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