legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "end" is on date 1995-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, start (date)
Link | rowid | legislator_id ▼ | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38396 | 38396 | Neil Abercrombie A000014 | rep | HI | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39089 | 39089 | Gary Ackerman A000022 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
37225 | 37225 | Wayne Allard A000109 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
35096 | 35096 | Michael Andrews A000209 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 25 | |||||||||||||
39668 | 39668 | Robert Andrews A000210 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35098 | 35098 | Thomas Andrews A000211 | rep | ME | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35107 | 35107 | Douglas Applegate A000214 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
36483 | 36483 | Bill Archer A000215 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
36785 | 36785 | Richard Armey A000217 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 26 | |||||||||||||
35121 | 35121 | James Bacchus B000008 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
39738 | 39738 | Spencer Bachus B000013 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
36133 | 36133 | Henry Baesler B000028 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
37942 | 37942 | Richard Baker B000072 | rep | LA | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
35681 | 35681 | William Baker B000078 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
37234 | 37234 | Cass Ballenger B000104 | rep | NC | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
36794 | 36794 | James Barcia B000134 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35123 | 35123 | Thomas Barlow B000151 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36803 | 36803 | Thomas Barrett B000177 | rep | WI | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
36488 | 36488 | Bill Barrett B000179 | rep | NE | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
39118 | 39118 | Roscoe Bartlett B000208 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
40698 | 40698 | Joe Barton B000213 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
36497 | 36497 | Herbert Bateman B000229 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
40512 | 40512 | Xavier Becerra B000287 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 30 | |||||||||||||
35691 | 35691 | Anthony Beilenson B000318 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 24 | |||||||||||||
35128 | 35128 | Helen Bentley B000392 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
37248 | 37248 | Douglas Bereuter B000403 | rep | NE | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
39148 | 39148 | Howard Berman B000410 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 26 | |||||||||||||
35706 | 35706 | Tom Bevill B000431 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35132 | 35132 | James Bilbray B000462 | rep | NV | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
37525 | 37525 | Michael Bilirakis B000463 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 9 | |||||||||||||
39042 | 39042 | Jeff Bingaman B000468 | sen | NM | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
41943 | 41943 | Sanford Bishop B000490 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35134 | 35134 | Lucien Blackwell B000517 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36507 | 36507 | Tom Bliley B000556 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
35708 | 35708 | Peter Blute B000576 | rep | MA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37537 | 37537 | Sherwood Boehlert B000586 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 23 | |||||||||||||
40155 | 40155 | John Boehner B000589 | rep | OH | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
37548 | 37548 | Henry Bonilla B000617 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 23 | |||||||||||||
36823 | 36823 | David Bonior B000619 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 10 | |||||||||||||
34261 | 34261 | David Boren B000639 | sen | OK | 1991-01-03 | 1995-01-03 | 2 | Democrat | |||||||||||||
36833 | 36833 | Robert Borski B000644 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
38441 | 38441 | Frederick Boucher B000657 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
35711 | 35711 | William Brewster B000817 | rep | OK | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35155 | 35155 | Jack Brooks B000880 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
35715 | 35715 | John Browder B000897 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
40255 | 40255 | Corrine Brown B000911 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36536 | 36536 | George Brown B000918 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 42 | |||||||||||||
41730 | 41730 | Sherrod Brown B000944 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
35717 | 35717 | Richard Bryan B000993 | sen | NV | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35724 | 35724 | John Bryant B000997 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
37564 | 37564 | Jim Bunning B001066 | rep | KY | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
36842 | 36842 | Conrad Burns B001126 | sen | MT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
39198 | 39198 | Dan Burton B001149 | rep | IN | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
38467 | 38467 | Stephen Buyer B001203 | rep | IN | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
37959 | 37959 | Robert Byrd B001210 | sen | WV | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35160 | 35160 | Leslie Byrne B001213 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 11 | |||||||||||||
35122 | 35122 | Peter Barca B001226 | rep | WI | 1993-05-04 | 1995-01-03 | Democrat | 1 | |||||||||||||
36849 | 36849 | H. Callahan C000052 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
42060 | 42060 | Ken Calvert C000059 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 43 | |||||||||||||
39769 | 39769 | Dave Camp C000071 | rep | MI | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
36550 | 36550 | Charles Canady C000107 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 12 | |||||||||||||
41740 | 41740 | Maria Cantwell C000127 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
41748 | 41748 | Benjamin Cardin C000141 | rep | MD | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35169 | 35169 | Milton Carr C000178 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
38479 | 38479 | Michael Castle C000243 | rep | DE | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
35730 | 35730 | John Chafee C000269 | sen | RI | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35736 | 35736 | Jim Chapman C000312 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36569 | 36569 | William Clay C000488 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36858 | 36858 | Eva Clayton C000494 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36866 | 36866 | Robert Clement C000503 | rep | TN | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35746 | 35746 | William Clinger C000523 | rep | PA | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
42158 | 42158 | James Clyburn C000537 | rep | SC | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
40135 | 40135 | Howard Coble C000556 | rep | NC | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
35753 | 35753 | Ronald Coleman C000621 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 16 | |||||||||||||
35756 | 35756 | Barbara-Rose Collins C000633 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35768 | 35768 | Cardiss Collins C000634 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
37258 | 37258 | Michael Collins C000640 | rep | GA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37268 | 37268 | Larry Combest C000653 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 19 | |||||||||||||
36873 | 36873 | Gary Condit C000670 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
39047 | 39047 | Kent Conrad C000705 | sen | ND | 1992-12-14 | 1995-01-03 | 1 | Democrat | |||||||||||||
40569 | 40569 | John Conyers C000714 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
42203 | 42203 | Jim Cooper C000754 | rep | TN | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35170 | 35170 | Samuel Coppersmith C000767 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39222 | 39222 | Jerry Costello C000794 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
37573 | 37573 | C. Cox C000830 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 47 | |||||||||||||
36888 | 36888 | William Coyne C000846 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
37978 | 37978 | Robert Cramer C000868 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
37294 | 37294 | Philip Crane C000873 | rep | IL | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
42231 | 42231 | Michael Crapo C000880 | rep | ID | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
37581 | 37581 | Randall Cunningham C000994 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 51 | |||||||||||||
33876 | 33876 | John Danforth D000030 | sen | MO | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
36577 | 36577 | Pat Danner D000046 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
35179 | 35179 | George Darden D000051 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
38499 | 38499 | Nathan Deal D000168 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
33879 | 33879 | Dennis DeConcini D000185 | sen | AZ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
42269 | 42269 | Peter DeFazio D000191 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
36130 | 36130 | Eligio de la Garza D000203 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35678 | 35678 | Ron de Lugo D000209 | rep | VI | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
42298 | 42298 | Rosa DeLauro D000216 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 3 |
Advanced export
JSON shape: default, array, newline-delimited
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, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);