legislator_terms

Table actions Table actions

482 rows where "start" is on date 1981-01-05

✎ 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
32437 32437 A000009 sen SD 1981-01-05 1987-01-03 3 Republican                          
32447 32447 A000208 sen ND 1981-01-05 1987-01-03 3 Republican                          
32448 32448 A000220 rep OH 1981-01-05 1983-01-03   Republican 17                        
32459 32459 A000221 rep OH 1981-01-05 1983-01-03   Republican 17                        
32461 32461 A000329 rep PA 1981-01-05 1983-01-03   Republican 25                        
32466 32466 B000029 rep FL 1981-01-05 1983-01-03   Republican 10                        
32468 32468 B000037 rep PA 1981-01-05 1983-01-03   Democrat 21                        
32469 32469 B000047 rep MO 1981-01-05 1983-01-03   Republican 8                        
32474 32474 B000280 rep TN 1981-01-05 1983-01-03   Republican 6                        
32475 32475 B000358 rep WV 1981-01-05 1983-01-03   Republican 2                        
32478 32478 B000363 rep IN 1981-01-05 1983-01-03   Democrat 1                        
32487 32487 B000472 rep NY 1981-01-05 1983-01-03   Democrat 22                        
32491 32491 B000538 rep MI 1981-01-05 1983-01-03   Democrat 18                        
32508 32508 B000605 rep MO 1981-01-05 1983-01-03   Democrat 5                        
32513 32513 B000682 rep MS 1981-01-05 1983-01-03   Democrat 2                        
32521 32521 B000839 rep GA 1981-01-05 1983-01-03   Democrat 3                        
32525 32525 B000862 rep MI 1981-01-05 1983-01-03   Democrat 17                        
32534 32534 B000910 rep OH 1981-01-05 1983-01-03   Republican 7                        
32539 32539 B001080 rep CA 1981-01-05 1983-01-03   Republican 43                        
32544 32544 B001153 rep CA 1981-01-05 1983-01-03   Democrat 5                        
32550 32550 B001182 rep VA 1981-01-05 1983-01-03   Republican 6                        
32551 32551 C000158 rep NY 1981-01-05 1983-01-03   Republican 3                        
32558 32558 C000371 rep NY 1981-01-05 1983-01-03   Democrat 12                        
32568 32568 C000475 rep CA 1981-01-05 1983-01-03   Republican 2                        
32576 32576 C000638 rep TX 1981-01-05 1983-01-03   Republican 3                        
32582 32582 C000799 rep CT 1981-01-05 1983-01-03   Democrat 1                        
32583 32583 C000845 rep PA 1981-01-05 1983-01-03   Republican 8                        
32588 32588 D000037 rep VA 1981-01-05 1983-01-03   Republican 4                        
32594 32594 D000043 rep CA 1981-01-05 1983-01-03   Democrat 30                        
32595 32595 D000231 rep CT 1981-01-05 1983-01-03   Republican 3                        
32597 32597 D000183 rep IN 1981-01-05 1983-01-03   Republican 8                        
32598 32598 D000259 sen AL 1981-01-05 1987-01-03 3 Republican                          
32610 32610 D000269 rep IL 1981-01-05 1983-01-03   Republican 4                        
32612 32612 D000446 rep PA 1981-01-05 1983-01-03   Republican 4                        
32613 32613 D000548 rep MI 1981-01-05 1983-01-03   Republican 6                        
32617 32617 E000004 sen MO 1981-01-05 1987-01-03 3 Democrat                          
32618 32618 E000017 sen NC 1981-01-05 1986-06-29 3 Republican                          
32622 32622 E000175 rep ME 1981-01-05 1983-01-03   Republican 1                        
32624 32624 E000198 rep MN 1981-01-05 1983-01-03   Republican 1                        
32627 32627 E000208 rep PA 1981-01-05 1983-01-03   Democrat 17                        
32630 32630 E000233 rep GA 1981-01-05 1983-01-03   Democrat 8                        
32634 32634 E000239 rep IN 1981-01-05 1983-01-03   Democrat 6                        
32637 32637 E000258 rep DE 1981-01-05 1983-01-03   Republican 0                        
32641 32641 F000040 rep IL 1981-01-05 1983-01-03   Democrat 5                        
32645 32645 F000078 rep NJ 1981-01-05 1983-01-03   Republican 5                        
32656 32656 F000123 rep IL 1981-01-05 1983-01-03   Republican 20                        
32660 32660 F000161 rep IN 1981-01-05 1983-01-03   Democrat 2                        
32675 32675 F000319 rep NC 1981-01-05 1983-01-03   Democrat 2                        
32680 32680 G000226 rep GA 1981-01-05 1983-01-03   Democrat 1                        
32685 32685 G000267 sen AZ 1981-01-05 1987-01-03 3 Republican                          
32692 32692 G000268 rep CA 1981-01-05 1983-01-03   Republican 20                        
32694 32694 G000480 rep CA 1981-01-05 1983-01-03   Republican 33                        
32699 32699 G000537 rep OH 1981-01-05 1983-01-03   Republican 4                        
32703 32703 H000012 rep MN 1981-01-05 1983-01-03   Republican 2                        
32705 32705 H000287 sen CO 1981-01-05 1987-01-03 3 Democrat                          
32706 32706 H000374 sen FL 1981-01-05 1987-01-03 3 Republican                          
32714 32714 H000440 rep MA 1981-01-05 1983-01-03   Republican 10                        
32716 32716 H000641 rep MS 1981-01-05 1983-01-03   Republican 4                        
32720 32720 H000719 rep SC 1981-01-05 1983-01-03   Democrat 5                        
32723 32723 H000722 rep NJ 1981-01-05 1983-01-03   Republican 9                        
32725 32725 J000074 rep KS 1981-01-05 1983-01-03   Republican 2                        
32726 32726 J000200 rep NC 1981-01-05 1983-01-03   Republican 6                        
32729 32729 L000148 sen NV 1981-01-05 1987-01-03 3 Republican                          
32730 32730 L000547 rep NY 1981-01-05 1983-01-03   Republican 6                        
32733 32733 L000187 rep PA 1981-01-05 1983-01-03   Democrat 3                        
32735 32735 L000192 rep NY 1981-01-05 1983-01-03   Republican 33                        
32742 32742 L000428 sen LA 1981-01-05 1987-01-03 3 Democrat                          
32745 32745 M000136 rep PA 1981-01-05 1983-01-03   Republican 24                        
32752 32752 M000241 sen MD 1981-01-05 1987-01-03 3 Republican                          
32753 32753 M000257 sen GA 1981-01-05 1987-01-03 3 Republican                          
32756 32756 M000260 rep TX 1981-01-05 1983-01-03   Democrat 5                        
32766 32766 M000340 rep IL 1981-01-05 1983-01-03   Republican 13                        
32774 32774 M000343 rep CA 1981-01-05 1983-01-03   Republican 12                        
32779 32779 M000808 rep NY 1981-01-05 1983-01-03   Republican 31                        
32783 32783 M000839 rep CT 1981-01-05 1983-01-03   Democrat 6                        
32792 32792 M000845 rep WV 1981-01-05 1983-01-03   Democrat 1                        
32796 32796 M001044 rep OH 1981-01-05 1983-01-03   Democrat 23                        
32797 32797 N000005 rep SC 1981-01-05 1983-01-03   Republican 6                        
32798 32798 N000027 rep PA 1981-01-05 1983-01-03   Republican 11                        
32803 32803 P000280 rep NY 1981-01-05 1983-01-03   Democrat 23                        
32811 32811 R000012 rep IL 1981-01-05 1983-01-03   Republican 19                        
32825 32825 R000165 rep WI 1981-01-05 1983-01-03   Democrat 5                        
32840 32840 R000188 rep AZ 1981-01-05 1983-01-03   Republican 1                        
32844 32844 R000232 rep NY 1981-01-05 1983-01-03   Democrat 14                        
32845 32845 R000308 rep SD 1981-01-05 1983-01-03   Republican 2                        
32853 32853 R000469 rep CA 1981-01-05 1983-01-03   Republican 26                        
32857 32857 S000058 rep NV 1981-01-05 1983-01-03   Democrat 0                        
32858 32858 S000282 rep OH 1981-01-05 1983-01-03   Democrat 12                        
32859 32859 S000514 rep AL 1981-01-05 1983-01-03   Republican 6                        
32860 32860 S000579 rep PA 1981-01-05 1983-01-03   Democrat 3                        
32869 32869 S000804 rep OH 1981-01-05 1983-01-03   Republican 11                        
32870 32870 S000818 rep WV 1981-01-05 1983-01-03   Republican 3                        
32873 32873 S000935 rep MI 1981-01-05 1983-01-03   Republican 4                        
32882 32882 W000121 rep VA 1981-01-05 1983-01-03   Republican 9                        
32883 32883 W000235 rep OH 1981-01-05 1983-01-03   Republican 9                        
32892 32892 W000390 rep TX 1981-01-05 1983-01-03   Democrat 16                        
32896 32896 Z000002 rep NY 1981-01-05 1983-01-03   Democrat 15                        
32899 32899 A000076 rep MI 1981-01-05 1983-01-03   Democrat 10                        
32905 32905 A000207 rep NC 1981-01-05 1983-01-03   Democrat 4                        
32908 32908 B000422 rep AR 1981-01-05 1983-01-03   Republican 2                        

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