legislator_terms

Table actions Table actions

480 rows where "start" is on date 1989-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
33816 33816 B000236 rep CA 1989-01-03 1991-01-03   Democrat 44                        
33824 33824 B000401 sen TX 1989-01-03 1993-01-20 1 Democrat                          
33833 33833 B000592 rep LA 1989-01-03 1991-01-03   Democrat 2                        
33837 33837 B000648 rep CA 1989-01-03 1991-01-03   Democrat 1                        
33839 33839 B000798 rep ME 1989-01-03 1991-01-03   Democrat 1                        
33841 33841 B001036 rep MO 1989-01-03 1991-01-03   Republican 2                        
33848 33848 B001077 sen ND 1989-01-03 1992-09-08 1 Democrat                          
33854 33854 C000344 rep WY 1989-01-03 1990-03-17   Republican 0                        
33857 33857 C000462 rep NC 1989-01-03 1991-01-03   Democrat 11                        
33863 33863 C000581 rep CA 1989-01-03 1989-06-15   Democrat 15                        
33869 33869 C000809 rep NJ 1989-01-03 1991-01-03   Republican 12                        
33875 33875 C000919 rep MI 1989-01-03 1991-01-03   Democrat 13                        
33879 33879 D000030 sen MO 1989-01-03 1995-01-03 1 Republican                          
33882 33882 D000185 sen AZ 1989-01-03 1995-01-03 1 Democrat                          
33883 33883 D000451 rep NH 1989-01-03 1991-01-03   Republican 2                        
33886 33886 D000566 sen MN 1989-01-03 1995-01-03 1 Republican                          
33891 33891 D000593 rep MD 1989-01-03 1991-01-03   Democrat 1                        
33901 33901 F000046 rep DC 1989-01-03 1991-01-03   Democrat 0                        
33908 33908 F000208 rep AL 1989-01-03 1991-01-03   Democrat 5                        
33916 33916 F000215 rep NJ 1989-01-03 1990-01-16   Democrat 1                        
33926 33926 F000380 rep MN 1989-01-03 1991-01-03   Republican 3                        
33933 33933 G000047 rep NY 1989-01-03 1990-01-07   Democrat 18                        
33935 33935 G000382 rep FL 1989-01-03 1991-01-03   Republican 2   [{"start": "1989-01-03", "end": "1989-02-21", "party": "Democrat"}, {"start": "1989-02-21", "end": "1991-01-03", "party": "Republican"}]                    
33949 33949 H000367 rep CA 1989-01-03 1991-01-03   Democrat 29                        
33955 33955 H000456 sen PA 1989-01-03 1991-12-31 1 Republican                          
33960 33960 H000586 rep IN 1989-01-03 1991-01-03   Republican 3                        
33976 33976 K000020 rep WI 1989-01-03 1991-01-03   Democrat 2                        
33982 33982 L000180 rep TX 1989-01-03 1991-01-03   Democrat 11                        
33988 33988 L000237 rep TX 1989-01-03 1989-08-07   Democrat 18                        
33996 33996 L000508 rep OH 1989-01-03 1991-01-03   Democrat 1                        
34000 34000 L000509 rep OH 1989-01-03 1991-01-03   Republican 8                        
34005 34005 M000195 rep IL 1989-01-03 1991-01-03   Republican 16                        
34015 34015 M000250 sen HI 1989-01-03 1991-01-03 1 Democrat                          
34020 34020 M000678 sen OH 1989-01-03 1995-01-03 1 Democrat                          
34023 34023 M000811 sen ME 1989-01-03 1995-01-03 1 Democrat                          
34028 34028 M000842 rep NY 1989-01-03 1989-12-31   Republican 14                        
34032 34032 M000992 rep CT 1989-01-03 1991-01-03   Democrat 3                        
34036 34036 N000106 rep UT 1989-01-03 1991-01-03   Republican 3                        
34042 34042 P000080 rep VA 1989-01-03 1991-01-03   Republican 8                        
34048 34048 P000097 rep CA 1989-01-03 1991-01-03   Republican 17                        
34065 34065 P000218 rep FL 1989-01-03 1989-05-30   Democrat 18                        
34073 34073 R000249 sen MI 1989-01-03 1995-01-03 1 Democrat                          
34076 34076 R000354 rep AR 1989-01-03 1991-01-03   Republican 2   [{"start": "1989-01-03", "end": "1989-07-28", "party": "Democrat"}, {"start": "1989-07-28", "end": "1991-01-03", "party": "Republican"}]                    
34079 34079 R000482 rep CT 1989-01-03 1991-01-03   Republican 5                        
34081 34081 S000014 rep HI 1989-01-03 1991-01-03   Republican 1                        
34084 34084 S000068 sen TN 1989-01-03 1995-01-03 1 Democrat                          
34089 34089 S000136 rep RI 1989-01-03 1991-01-03   Republican 2                        
34092 34092 S000143 rep MI 1989-01-03 1991-01-03   Republican 10                        
34098 34098 S000393 rep CA 1989-01-03 1991-01-03   Republican 14                        
34103 34103 S000527 rep OR 1989-01-03 1991-01-03   Republican 5                        
34104 34104 S000584 rep MS 1989-01-03 1989-08-13   Republican 5                        
34105 34105 S000601 rep VT 1989-01-03 1991-01-03   Republican 0                        
34113 34113 S000622 rep NE 1989-01-03 1991-01-03   Republican 3                        
34120 34120 S000795 rep MN 1989-01-03 1991-01-03   Republican 7                        
34126 34126 T000053 rep IA 1989-01-03 1991-01-03   Republican 2                        
34133 34133 W000044 rep PA 1989-01-03 1991-01-03   Democrat 18                        
34136 34136 W000092 sen WY 1989-01-03 1995-01-03 1 Republican                          
34142 34142 W000426 rep KS 1989-01-03 1991-01-03   Republican 5                        
34144 34144 W000607 sen CA 1989-01-03 1991-12-31 1 Republican                          
34162 34162 W000763 rep TX 1989-01-03 1989-06-30   Democrat 12                        
34175 34175 A000103 rep AR 1989-01-03 1991-01-03   Democrat 1                        
34187 34187 A000189 rep CA 1989-01-03 1991-01-03   Democrat 32                        
34201 34201 A000212 rep IL 1989-01-03 1991-01-03   Democrat 11                        
34208 34208 A000213 rep AR 1989-01-03 1991-01-03   Democrat 4                        
34212 34212 A000226 rep MA 1989-01-03 1991-01-03   Democrat 5                        
34221 34221 A000337 rep OR 1989-01-03 1991-01-03   Democrat 1                        
34229 34229 B000153 rep GA 1989-01-03 1991-01-03   Democrat 10                        
34234 34234 B000204 rep TX 1989-01-03 1991-01-03   Republican 3                        
34256 34256 B000371 rep FL 1989-01-03 1991-01-03   Democrat 3                        
34260 34260 B000551 rep GU 1989-01-03 1991-01-03   Republican 0                        
34284 34284 B000890 rep MI 1989-01-03 1991-01-03   Republican 18                        
34290 34290 B000919 rep CO 1989-01-03 1991-01-03   Republican 4                        
34294 34294 B000971 rep IL 1989-01-03 1991-01-03   Democrat 19                        
34298 34298 B001172 rep TX 1989-01-03 1991-01-03   Democrat 23                        
34305 34305 B001220 rep MD 1989-01-03 1991-01-03   Democrat 6                        
34310 34310 C000293 rep WA 1989-01-03 1991-01-03   Republican 8                        
34325 34325 C000618 rep MO 1989-01-03 1991-01-03   Republican 6                        
34343 34343 C000709 rep MA 1989-01-03 1991-01-03   Republican 1                        
34355 34355 C000807 rep PA 1989-01-03 1991-01-03   Republican 13                        
34363 34363 D000044 rep CA 1989-01-03 1991-01-03   Republican 39                        
34370 34370 D000131 rep MI 1989-01-03 1991-01-03   Republican 11                        
34384 34384 D000326 rep AL 1989-01-03 1991-01-03   Republican 2                        
34391 34391 D000416 rep MA 1989-01-03 1991-01-03   Democrat 11                        
34400 34400 D000471 rep NY 1989-01-03 1991-01-03   Democrat 2                        
34406 34406 D000586 rep NJ 1989-01-03 1991-01-03   Democrat 6                        
34412 34412 D000592 rep CA 1989-01-03 1991-01-03   Democrat 31                        
34421 34421 E000013 rep MA 1989-01-03 1991-01-03   Democrat 3                        
34427 34427 E000031 rep OH 1989-01-03 1991-01-03   Democrat 11                        
34435 34435 E000077 rep OK 1989-01-03 1991-01-03   Republican 5                        
34440 34440 E000201 rep AL 1989-01-03 1991-01-03   Democrat 6                        
34462 34462 F000041 rep FL 1989-01-03 1991-01-03   Democrat 19                        
34467 34467 F000059 rep OH 1989-01-03 1991-01-03   Democrat 19                        
34471 34471 F000435 rep PR 1989-01-03 1991-01-03   Democrat 0                        
34484 34484 G000105 rep PA 1989-01-03 1991-01-03   Democrat 20                        
34497 34497 G000402 rep PA 1989-01-03 1991-01-03   Democrat 2                        
34505 34505 G000417 rep NY 1989-01-03 1991-01-03   Republican 15                        
34512 34512 G000511 rep NJ 1989-01-03 1991-01-03   Democrat 14                        
34525 34525 H000124 rep AR 1989-01-03 1991-01-03   Republican 3                        
34528 34528 H000236 rep AL 1989-01-03 1991-01-03   Democrat 7                        
34534 34534 H000340 rep GA 1989-01-03 1991-01-03   Democrat 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);