legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 1997-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38397 | 38397 | Neil Abercrombie A000014 | rep | HI | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
39090 | 39090 | Gary Ackerman A000022 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
37226 | 37226 | Wayne Allard A000109 | rep | CO | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
39669 | 39669 | Robert Andrews A000210 | rep | NJ | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36484 | 36484 | Bill Archer A000215 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
36786 | 36786 | Richard Armey A000217 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 26 | |||||||||||||
39739 | 39739 | Spencer Bachus B000013 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
36134 | 36134 | Henry Baesler B000028 | rep | KY | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
37943 | 37943 | Richard Baker B000072 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
35682 | 35682 | William Baker B000078 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
36790 | 36790 | John Baldacci B000081 | rep | ME | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
37235 | 37235 | Cass Ballenger B000104 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
36795 | 36795 | James Barcia B000134 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
36799 | 36799 | Bob Barr B000169 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
36804 | 36804 | Thomas Barrett B000177 | rep | WI | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
36489 | 36489 | Bill Barrett B000179 | rep | NE | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
39119 | 39119 | Roscoe Bartlett B000208 | rep | MD | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
40699 | 40699 | Joe Barton B000213 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
39128 | 39128 | Charles Bass B000220 | rep | NH | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
36498 | 36498 | Herbert Bateman B000229 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
39662 | 39662 | Max Baucus B000243 | sen | MT | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
40513 | 40513 | Xavier Becerra B000287 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 30 | |||||||||||||
35692 | 35692 | Anthony Beilenson B000318 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 24 | |||||||||||||
36808 | 36808 | Ken Bentsen B000400 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 25 | |||||||||||||
37249 | 37249 | Douglas Bereuter B000403 | rep | NE | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
39149 | 39149 | Howard Berman B000410 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 26 | |||||||||||||
35707 | 35707 | Tom Bevill B000431 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
38431 | 38431 | Joseph Biden B000444 | sen | DE | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39165 | 39165 | Brian Bilbray B000461 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 49 | |||||||||||||
37526 | 37526 | Michael Bilirakis B000463 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 9 | |||||||||||||
41944 | 41944 | Sanford Bishop B000490 | rep | GA | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36508 | 36508 | Tom Bliley B000556 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
41967 | 41967 | Earl Blumenauer B000574 | rep | OR | 1996-05-21 | 1997-01-03 | Democrat | 3 | |||||||||||||
35709 | 35709 | Peter Blute B000576 | rep | MA | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
37538 | 37538 | Sherwood Boehlert B000586 | rep | NY | 1995-01-04 | 1997-01-03 | Republican | 23 | |||||||||||||
40156 | 40156 | John Boehner B000589 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
37549 | 37549 | Henry Bonilla B000617 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 23 | |||||||||||||
36824 | 36824 | David Bonior B000619 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
36136 | 36136 | Sonny Bono B000622 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 44 | |||||||||||||
36834 | 36834 | Robert Borski B000644 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
38442 | 38442 | Frederick Boucher B000657 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
35712 | 35712 | William Brewster B000817 | rep | OK | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35716 | 35716 | John Browder B000897 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
40256 | 40256 | Corrine Brown B000911 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36537 | 36537 | George Brown B000918 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 42 | |||||||||||||
34288 | 34288 | George Brown B000919 | sen | CO | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
41731 | 41731 | Sherrod Brown B000944 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 13 | |||||||||||||
36838 | 36838 | Ed Bryant B000996 | rep | TN | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
35725 | 35725 | John Bryant B000997 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
35726 | 35726 | Jim Bunn B001063 | rep | OR | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
37565 | 37565 | Jim Bunning B001066 | rep | KY | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
42042 | 42042 | Richard Burr B001135 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
39199 | 39199 | Dan Burton B001149 | rep | IN | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
38468 | 38468 | Stephen Buyer B001203 | rep | IN | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
34264 | 34264 | William Bradley B001225 | sen | NJ | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
36850 | 36850 | H. Callahan C000052 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
42061 | 42061 | Ken Calvert C000059 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 43 | |||||||||||||
39770 | 39770 | Dave Camp C000071 | rep | MI | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
36547 | 36547 | Tom Campbell C000100 | rep | CA | 1995-12-12 | 1997-01-03 | Republican | 15 | |||||||||||||
36551 | 36551 | Charles Canady C000107 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 12 | |||||||||||||
41749 | 41749 | Benjamin Cardin C000141 | rep | MD | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
38480 | 38480 | Michael Castle C000243 | rep | DE | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
42115 | 42115 | Steve Chabot C000266 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
39687 | 39687 | Saxby Chambliss C000286 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
35737 | 35737 | Jim Chapman C000312 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36554 | 36554 | Helen Chenoweth-Hage C000345 | rep | ID | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36139 | 36139 | Jon Christensen C000377 | rep | NE | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
35738 | 35738 | Dick Chrysler C000385 | rep | MI | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
36570 | 36570 | William Clay C000488 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36859 | 36859 | Eva Clayton C000494 | rep | NC | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36867 | 36867 | Robert Clement C000503 | rep | TN | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
35747 | 35747 | William Clinger C000523 | rep | PA | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
42159 | 42159 | James Clyburn C000537 | rep | SC | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
40136 | 40136 | Howard Coble C000556 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
39794 | 39794 | Thomas Coburn C000560 | rep | OK | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
40623 | 40623 | Thad Cochran C000567 | sen | MS | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34314 | 34314 | William Cohen C000598 | sen | ME | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
35754 | 35754 | Ronald Coleman C000621 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 16 | |||||||||||||
35757 | 35757 | Barbara-Rose Collins C000633 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
35769 | 35769 | Cardiss Collins C000634 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
37259 | 37259 | Michael Collins C000640 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
37269 | 37269 | Larry Combest C000653 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 19 | |||||||||||||
36874 | 36874 | Gary Condit C000670 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
40570 | 40570 | John Conyers C000714 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
35770 | 35770 | Wes Cooley C000737 | rep | OR | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
39223 | 39223 | Jerry Costello C000794 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
37574 | 37574 | C. Cox C000830 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 47 | |||||||||||||
36889 | 36889 | William Coyne C000846 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
37279 | 37279 | Larry Craig C000858 | sen | ID | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37979 | 37979 | Robert Cramer C000868 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
37295 | 37295 | Philip Crane C000873 | rep | IL | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
42232 | 42232 | Michael Crapo C000880 | rep | ID | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
35771 | 35771 | Frank Cremeans C000903 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
37986 | 37986 | Barbara Cubin C000962 | rep | WY | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
41196 | 41196 | Elijah Cummings C000984 | rep | MD | 1996-04-16 | 1997-01-03 | Democrat | 7 | |||||||||||||
37582 | 37582 | Randall Cunningham C000994 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 51 | |||||||||||||
36578 | 36578 | Pat Danner D000046 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
37998 | 37998 | Thomas Davis D000136 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 11 | |||||||||||||
38500 | 38500 | Nathan Deal D000168 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 9 | [ { "start": "1995-01-04", "end": "1995-04-10", "party": "Democrat" }, { "start": "1995-04-10", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
42270 | 42270 | Peter DeFazio D000191 | rep | OR | 1995-01-04 | 1997-01-03 | Democrat | 4 |
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);