legislator_terms

Table actions Table actions

479 rows where "end" is on date 1975-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, 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
29121 29121 A000062 sen VT 1969-01-03 1975-01-03 3 Republican                          
29225 29225 D000409 sen CO 1969-01-03 1975-01-03 3 Republican                          
29230 29230 E000211 sen NC 1969-01-03 1975-01-03 3 Democrat                          
29288 29288 F000401 sen AR 1969-01-03 1975-01-03 3 Democrat                          
29298 29298 G000531 sen FL 1969-01-03 1975-01-03 3 Republican                          
29299 29299 H000922 sen IA 1969-01-03 1975-01-03 3 Democrat                          
30160 30160 A000216 rep IL 1973-01-03 1975-01-03   Republican 15                        
30162 30162 B000069 rep TN 1973-01-03 1975-01-03   Republican 3                        
30167 30167 B000506 rep GA 1973-01-03 1975-01-03   Republican 4                        
30181 30181 B000550 rep MN 1973-01-03 1975-01-03   Democrat 8                        
30185 30185 B000771 rep NY 1973-01-03 1975-01-03   Democrat 11                        
30197 30197 B000778 rep IN 1973-01-03 1975-01-03   Republican 6                        
30204 30204 B000893 rep CO 1973-01-03 1975-01-03   Republican 2                        
30215 30215 B000967 rep VA 1973-01-03 1975-01-03   Republican 10                        
30218 30218 C000073 rep OK 1973-01-03 1975-01-03   Republican 6                        
30225 30225 C000143 rep NY 1973-01-03 1975-01-03   Democrat 15                        
30243 30243 C000275 rep MI 1973-01-03 1975-01-03   Republican 6                        
30253 30253 C000431 rep PA 1973-01-03 1975-01-03   Democrat 25                        
30263 30263 C000629 rep IL 1973-01-03 1975-01-03   Republican 6                        
30266 30266 C000925 rep MA 1973-01-03 1975-01-03   Republican 5                        
30288 30288 D000102 rep WI 1973-01-03 1975-01-03   Republican 9                        
30295 30295 D000122 rep GA 1973-01-03 1975-01-03   Democrat 7                        
30299 30299 D000220 rep OR 1973-01-03 1975-01-03   Republican 4                        
30301 30301 D000234 rep SD 1973-01-03 1975-01-03   Democrat 1                        
30304 30304 D000241 rep IN 1973-01-03 1975-01-03   Republican 10                        
30318 30318 D000419 rep MA 1973-01-03 1975-01-03   Democrat 3                        
30331 30331 D000434 rep SC 1973-01-03 1975-01-03   Democrat 3                        
30339 30339 D000523 rep NY 1973-01-03 1975-01-03   Democrat 37                        
30362 30362 F000152 rep TX 1973-01-03 1975-01-03   Democrat 21                        
30373 30373 F000371 rep NJ 1973-01-03 1975-01-03   Republican 5                        
30374 30374 F000388 rep WI 1973-01-03 1975-01-03   Republican 8                        
30380 30380 G000144 rep SC 1973-01-03 1975-01-03   Democrat 5                        
30386 30386 G000290 rep PA 1973-01-03 1975-01-03   Republican 19                        
30388 30388 G000387 rep CT 1973-01-03 1975-01-03   Democrat 6                        
30398 30398 G000407 rep OR 1973-01-03 1975-01-03   Democrat 3                        
30416 30416 G000471 rep MI 1973-01-03 1975-01-03   Democrat 17                        
30429 30429 G000495 rep IA 1973-01-03 1975-01-03   Republican 3                        
30435 30435 G000504 rep NY 1973-01-03 1975-01-03   Republican 2                        
30446 30446 G000512 rep CA 1973-01-03 1975-01-03   Republican 10                        
30447 30447 G000528 rep FL 1973-01-03 1975-01-03   Democrat 5                        
30453 30453 H000164 rep CA 1973-01-03 1975-01-03   Democrat 34                        
30454 30454 H000168 rep IL 1973-01-03 1975-01-03   Republican 3                        
30464 30464 H000174 rep WA 1973-01-03 1975-01-03   Democrat 3                        
30467 30467 H000175 rep ID 1973-01-03 1975-01-03   Republican 2                        
30474 30474 H000306 rep MI 1973-01-03 1975-01-03   Republican 8                        
30483 30483 H000692 rep MD 1973-01-03 1975-01-03   Republican 5                        
30499 30499 H000713 rep CA 1973-01-03 1975-01-03   Democrat 19                        
30510 30510 H000802 rep CA 1973-01-03 1975-01-03   Republican 32                        
30511 30511 H000897 rep MI 1973-01-03 1975-01-03   Republican 18                        
30512 30512 H000906 rep IN 1973-01-03 1975-01-03   Republican 11                        
30516 30516 H000972 rep NJ 1973-01-03 1975-01-03   Republican 1                        
30518 30518 K000037 rep OH 1973-01-03 1975-01-03   Republican 1                        
30525 30525 K000195 rep NY 1973-01-03 1975-01-03   Republican 29                        
30529 30529 K000348 rep TN 1973-01-03 1975-01-03   Republican 8                        
30533 30533 K000356 rep ME 1973-01-03 1975-01-03   Democrat 1                        
30536 30536 L000049 rep IN 1973-01-03 1975-01-03   Republican 2                        
30547 30547 M000070 rep CA 1973-01-03 1975-01-03   Republican 6                        
30549 30549 M000078 rep VT 1973-01-03 1975-01-03   Republican 0                        
30550 30550 M000121 rep NJ 1973-01-03 1975-01-03   Republican 13                        
30557 30557 M000175 rep NE 1973-01-03 1975-01-03   Republican 3                        
30561 30561 M000242 rep CA 1973-01-03 1975-01-03   Republican 18                        
30565 30565 M000286 rep IA 1973-01-03 1975-01-03   Republican 6                        
30577 30577 M000603 rep OK 1973-01-03 1975-01-03   Democrat 2                        
30586 30586 M000779 rep MD 1973-01-03 1975-01-03   Republican 1                        
30596 30596 M000799 rep OH 1973-01-03 1975-01-03   Republican 23                        
30599 30599 M000833 rep NC 1973-01-03 1975-01-03   Republican 5                        
30610 30610 N000028 rep MN 1973-01-03 1975-01-03   Republican 2                        
30617 30617 P000399 rep NY 1973-01-03 1975-01-03   Democrat 13                        
30619 30619 P000485 rep OH 1973-01-03 1975-01-03   Republican 8                        
30623 30623 P000528 rep TX 1973-01-03 1975-01-03   Republican 13                        
30627 30627 R000065 rep LA 1973-01-03 1975-01-03   Democrat 6                        
30633 30633 R000150 rep NY 1973-01-03 1975-01-03   Democrat 24                        
30642 30642 R000357 rep NY 1973-01-03 1975-01-03   Republican 27                        
30643 30643 R000422 rep NY 1973-01-03 1975-01-03   Republican 3                        
30659 30659 R000424 rep NY 1973-01-03 1975-01-03   Democrat 14                        
30661 30661 R000484 rep KS 1973-01-03 1975-01-03   Democrat 2                        
30664 30664 R000545 rep NC 1973-01-03 1975-01-03   Republican 8                        
30668 30668 S000045 rep NJ 1973-01-03 1975-01-03   Republican 2                        
30681 30681 S000102 rep PA 1973-01-03 1975-01-03   Republican 12                        
30685 30685 S000121 rep IA 1973-01-03 1975-01-03   Republican 5                        
30691 30691 S000383 rep MT 1973-01-03 1975-01-03   Republican 1                        
30696 30696 S000548 rep NY 1973-01-03 1975-01-03   Republican 36                        
30710 30710 S000836 rep CT 1973-01-03 1975-01-03   Republican 2                        
30718 30718 S001037 rep KY 1973-01-03 1975-01-03   Democrat 1                        
30728 30728 T000109 rep CA 1973-01-03 1975-01-03   Republican 13                        
30735 30735 T000233 rep WI 1973-01-03 1975-01-03   Republican 3                        
30739 30739 T000265 rep RI 1973-01-03 1975-01-03   Democrat 2                        
30740 30740 T000321 rep NV 1973-01-03 1975-01-03   Republican 0                        
30742 30742 V000093 rep CA 1973-01-03 1975-01-03   Republican 43                        
30747 30747 W000035 rep CA 1973-01-03 1975-01-03   Democrat 14                        
30750 30750 W000147 rep PA 1973-01-03 1975-01-03   Republican 5                        
30763 30763 W000445 rep NJ 1973-01-03 1975-01-03   Republican 7                        
30767 30767 W000525 rep PA 1973-01-03 1975-01-03   Republican 7                        
30773 30773 W000778 rep OR 1973-01-03 1975-01-03   Republican 1                        
30774 30774 Y000035 rep SC 1973-01-03 1975-01-03   Republican 6                        
30775 30775 Y000052 rep IL 1973-01-03 1975-01-03   Republican 10                        
30779 30779 Z000010 rep IN 1973-01-03 1975-01-03   Republican 8                        
30783 30783 Z000016 rep MN 1973-01-03 1975-01-03   Republican 6                        
30789 30789 W000782 sen NH 1974-12-31 1975-01-03 3 Republican   appointment                      
30802 30802 F000260 rep MI 1973-01-03 1975-01-03   Republican 5                        

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