legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "end" is on date 1987-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32434 | 32434 | James Abdnor A000009 | sen | SD | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
38394 | 38394 | Neil Abercrombie A000014 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
39085 | 39085 | Gary Ackerman A000022 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33224 | 33224 | Joseph Addabbo A000052 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
39034 | 39034 | Daniel Akaka A000069 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
34170 | 34170 | William Alexander A000103 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34182 | 34182 | Glenn Anderson A000189 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 32 | |||||||||||||
32444 | 32444 | Mark Andrews A000208 | sen | ND | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
35092 | 35092 | Michael Andrews A000209 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 25 | |||||||||||||
34196 | 34196 | Frank Annunzio A000212 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
34203 | 34203 | Beryl Anthony A000213 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
35103 | 35103 | Douglas Applegate A000214 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 18 | |||||||||||||
36479 | 36479 | Bill Archer A000215 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 7 | |||||||||||||
36781 | 36781 | Richard Armey A000217 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 26 | |||||||||||||
35115 | 35115 | Leslie Aspin A000224 | rep | WI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34207 | 34207 | Chester Atkins A000226 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
34216 | 34216 | Les AuCoin A000337 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33482 | 33482 | Robert Badham B000024 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 40 | |||||||||||||
37230 | 37230 | Cass Ballenger B000104 | rep | NC | 1986-11-04 | 1987-01-03 | Republican | 10 | |||||||||||||
34224 | 34224 | Druie Barnard B000153 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 10 | |||||||||||||
33233 | 33233 | Michael Barnes B000160 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
34229 | 34229 | Harry Bartlett B000204 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
40694 | 40694 | Joe Barton B000213 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
36493 | 36493 | Herbert Bateman B000229 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33811 | 33811 | Jim Bates B000236 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 44 | |||||||||||||
33239 | 33239 | Berkley Bedell B000298 | rep | IA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
35687 | 35687 | Anthony Beilenson B000318 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 23 | |||||||||||||
34251 | 34251 | Charles Bennett B000371 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
35124 | 35124 | Helen Bentley B000392 | rep | MD | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
37244 | 37244 | Douglas Bereuter B000403 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
39144 | 39144 | Howard Berman B000410 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 26 | |||||||||||||
35702 | 35702 | Tom Bevill B000431 | rep | AL | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33492 | 33492 | Mario Biaggi B000432 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
37521 | 37521 | Michael Bilirakis B000463 | rep | FL | 1985-01-03 | 1987-01-03 | Republican | 9 | |||||||||||||
34255 | 34255 | Ben Blaz B000551 | rep | GU | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
36503 | 36503 | Tom Bliley B000556 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
37533 | 37533 | Sherwood Boehlert B000586 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 25 | |||||||||||||
33828 | 33828 | Corinne Boggs B000592 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33510 | 33510 | Edward Boland B000600 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33515 | 33515 | William Boner B000615 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
36819 | 36819 | David Bonior B000619 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 12 | |||||||||||||
33522 | 33522 | Don Bonker B000620 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
36829 | 36829 | Robert Borski B000644 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33832 | 33832 | Douglas Bosco B000648 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
38437 | 38437 | Frederick Boucher B000657 | rep | VA | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
33524 | 33524 | Eldon Boulter B000666 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
40202 | 40202 | Barbara Boxer B000711 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
36518 | 36518 | John Breaux B000780 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
35151 | 35151 | Jack Brooks B000880 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
34279 | 34279 | William Broomfield B000890 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 18 | |||||||||||||
36532 | 36532 | George Brown B000918 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 36 | |||||||||||||
34285 | 34285 | George Brown B000919 | rep | CO | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
34289 | 34289 | Terry Bruce B000971 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
35720 | 35720 | John Bryant B000997 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
35157 | 35157 | Dale Bumpers B001057 | sen | AR | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
39194 | 39194 | Dan Burton B001149 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
33527 | 33527 | Sala Burton B001158 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
34293 | 34293 | Albert Bustamante B001172 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 23 | |||||||||||||
34300 | 34300 | Beverly Byron B001220 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
36845 | 36845 | H. Callahan C000052 | rep | AL | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33246 | 33246 | Carroll Campbell C000079 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33250 | 33250 | William Carney C000165 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
41759 | 41759 | Thomas Carper C000174 | rep | DE | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
35165 | 35165 | Milton Carr C000178 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
34305 | 34305 | Rodney Chandler C000293 | rep | WA | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
35732 | 35732 | Jim Chapman C000312 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33537 | 33537 | William Chappell C000321 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33253 | 33253 | Eugene Chappie C000322 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33849 | 33849 | Richard Cheney C000344 | rep | WY | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
36565 | 36565 | William Clay C000488 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35742 | 35742 | William Clinger C000523 | rep | PA | 1985-01-03 | 1987-01-03 | Republican | 23 | |||||||||||||
40212 | 40212 | Daniel Coats C000542 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33254 | 33254 | William Cobey C000555 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
40131 | 40131 | Howard Coble C000556 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
33858 | 33858 | Anthony Coelho C000581 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 15 | |||||||||||||
34320 | 34320 | Earl Coleman C000618 | rep | MO | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
35749 | 35749 | Ronald Coleman C000621 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 16 | |||||||||||||
35764 | 35764 | Cardiss Collins C000634 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
37264 | 37264 | Larry Combest C000653 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 19 | |||||||||||||
34338 | 34338 | Silvio Conte C000709 | rep | MA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
40565 | 40565 | John Conyers C000714 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
42199 | 42199 | Jim Cooper C000754 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
34350 | 34350 | Robert Coughlin C000807 | rep | PA | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
33864 | 33864 | James Courter C000809 | rep | NJ | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
36884 | 36884 | William Coyne C000846 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
37276 | 37276 | Larry Craig C000858 | rep | ID | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37290 | 37290 | Philip Crane C000873 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
33541 | 33541 | Alan Cranston C000877 | sen | CA | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33870 | 33870 | George Crockett C000919 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 13 | |||||||||||||
35171 | 35171 | Alfonse D’Amato D000018 | sen | NY | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33551 | 33551 | Wilbur Daniel D000038 | rep | VA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
34358 | 34358 | William Dannemeyer D000044 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 39 | |||||||||||||
35175 | 35175 | George Darden D000051 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
36584 | 36584 | Thomas Daschle D000064 | rep | SD | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
33555 | 33555 | Harold Daub D000065 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34365 | 34365 | Robert Davis D000131 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 11 | |||||||||||||
36126 | 36126 | Eligio de la Garza D000203 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 15 | |||||||||||||
35674 | 35674 | Ron de Lugo D000209 | rep | VI | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
37593 | 37593 | Thomas DeLay D000217 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 22 | |||||||||||||
36149 | 36149 | Ronald Dellums D000222 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 8 |
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);