legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "start" is on date 2001-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38400 | 38400 | Neil Abercrombie A000014 | rep | HI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
39093 | 39093 | Gary Ackerman A000022 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
41906 | 41906 | Robert Aderholt A000055 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
39039 | 39039 | Daniel Akaka A000069 | sen | HI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://akaka.senate.gov | ||||||||||||
36780 | 36780 | George Allen A000121 | sen | VA | 2001-01-03 | 2007-01-03 | 1 | Republican | http://allen.senate.gov | ||||||||||||
39672 | 39672 | Robert Andrews A000210 | rep | NJ | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
36789 | 36789 | Richard Armey A000217 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 26 | |||||||||||||
37935 | 37935 | Thomas Allen A000357 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
39100 | 39100 | W. Akin A000358 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37222 | 37222 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2001-01-03 | 2003-01-03 | AL | 0 | |||||||||||||
39742 | 39742 | Spencer Bachus B000013 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37946 | 37946 | Richard Baker B000072 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
36793 | 36793 | John Baldacci B000081 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
37238 | 37238 | Cass Ballenger B000104 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 10 | |||||||||||||
36798 | 36798 | James Barcia B000134 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
36802 | 36802 | Bob Barr B000169 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
36807 | 36807 | Thomas Barrett B000177 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
39122 | 39122 | Roscoe Bartlett B000208 | rep | MD | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
40702 | 40702 | Joe Barton B000213 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
39131 | 39131 | Charles Bass B000220 | rep | NH | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
40516 | 40516 | Xavier Becerra B000287 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 30 | |||||||||||||
36811 | 36811 | Ken Bentsen B000400 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 25 | |||||||||||||
37252 | 37252 | Douglas Bereuter B000403 | rep | NE | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
39152 | 39152 | Howard Berman B000410 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 26 | |||||||||||||
38423 | 38423 | Robert Berry B000420 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37529 | 37529 | Michael Bilirakis B000463 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 9 | |||||||||||||
39044 | 39044 | Jeff Bingaman B000468 | sen | NM | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://bingaman.senate.gov | ||||||||||||
41947 | 41947 | Sanford Bishop B000490 | rep | GA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
36814 | 36814 | Rod Blagojevich B000518 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
41970 | 41970 | Earl Blumenauer B000574 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
41985 | 41985 | Roy Blunt B000575 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
37541 | 37541 | Sherwood Boehlert B000586 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 23 | |||||||||||||
40159 | 40159 | John Boehner B000589 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37552 | 37552 | Henry Bonilla B000617 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 23 | |||||||||||||
36827 | 36827 | David Bonior B000619 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
36837 | 36837 | Robert Borski B000644 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
39186 | 39186 | Leonard Boswell B000652 | rep | IA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
38445 | 38445 | Frederick Boucher B000657 | rep | VA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38452 | 38452 | Allen Boyd B000716 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
42001 | 42001 | Kevin Brady B000755 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
40259 | 40259 | Corrine Brown B000911 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
41734 | 41734 | Sherrod Brown B000944 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
36841 | 36841 | Ed Bryant B000996 | rep | TN | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
36844 | 36844 | Conrad Burns B001126 | sen | MT | 2001-01-03 | 2007-01-03 | 1 | Republican | http://burns.senate.gov | ||||||||||||
42045 | 42045 | Richard Burr B001135 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
39202 | 39202 | Dan Burton B001149 | rep | IN | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
38471 | 38471 | Stephen Buyer B001203 | rep | IN | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37961 | 37961 | Robert Byrd B001210 | sen | WV | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://byrd.senate.gov | ||||||||||||
40725 | 40725 | Robert Brady B001227 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
39174 | 39174 | Mary Bono Mack B001228 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 44 | |||||||||||||
38409 | 38409 | Brian Baird B001229 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
41918 | 41918 | Tammy Baldwin B001230 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
39137 | 39137 | Shelley Berkley B001231 | rep | NV | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
39159 | 39159 | Judy Biggert B001232 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 13 | |||||||||||||
39112 | 39112 | Joe Baca B001234 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 42 | |||||||||||||
38458 | 38458 | Henry Brown B001235 | rep | SC | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
36853 | 36853 | H. Callahan C000052 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
42064 | 42064 | Ken Calvert C000059 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 43 | |||||||||||||
39773 | 39773 | Dave Camp C000071 | rep | MI | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
37965 | 37965 | Christopher Cannon C000116 | rep | UT | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
41741 | 41741 | Maria Cantwell C000127 | sen | WA | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://cantwell.senate.gov | ||||||||||||
41752 | 41752 | Benjamin Cardin C000141 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
41763 | 41763 | Thomas Carper C000174 | sen | DE | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://carper.senate.gov | ||||||||||||
37971 | 37971 | Julia Carson C000191 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
38483 | 38483 | Michael Castle C000243 | rep | DE | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
42118 | 42118 | Steve Chabot C000266 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
39690 | 39690 | Saxby Chambliss C000286 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
39787 | 39787 | Donna Christensen C000380 | rep | VI | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
36862 | 36862 | Eva Clayton C000494 | rep | NC | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
36870 | 36870 | Robert Clement C000503 | rep | TN | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
42162 | 42162 | James Clyburn C000537 | rep | SC | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
40139 | 40139 | Howard Coble C000556 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37262 | 37262 | Michael Collins C000640 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37272 | 37272 | Larry Combest C000653 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 19 | |||||||||||||
36877 | 36877 | Gary Condit C000670 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
39049 | 39049 | Kent Conrad C000705 | sen | ND | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://conrad.senate.gov | ||||||||||||
40573 | 40573 | John Conyers C000714 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
36880 | 36880 | John Cooksey C000735 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
39226 | 39226 | Jerry Costello C000794 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
37577 | 37577 | C. Cox C000830 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 47 | |||||||||||||
36892 | 36892 | William Coyne C000846 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
37982 | 37982 | Robert Cramer C000868 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37298 | 37298 | Philip Crane C000873 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37989 | 37989 | Barbara Cubin C000962 | rep | WY | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
41199 | 41199 | Elijah Cummings C000984 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
37585 | 37585 | Randall Cunningham C000994 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 51 | |||||||||||||
40269 | 40269 | Lois Capps C001036 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 22 | |||||||||||||
40735 | 40735 | Michael Capuano C001037 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
40750 | 40750 | Joseph Crowley C001038 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
36856 | 36856 | Lincoln Chafee C001040 | sen | RI | 2001-01-03 | 2007-01-03 | 1 | Republican | http://chafee.senate.gov | ||||||||||||
37975 | 37975 | Hillary Clinton C001041 | sen | NY | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://clinton.senate.gov | ||||||||||||
36881 | 36881 | Jon Corzine C001042 | sen | NJ | 2001-01-03 | 2006-01-17 | 1 | Democrat | http://corzine.senate.gov | ||||||||||||
36854 | 36854 | Jean Carnahan C001043 | sen | MO | 2001-01-03 | 2003-01-03 | 1 | Democrat | appointment | ||||||||||||
37255 | 37255 | Brad Carson C001044 | rep | OK | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
40280 | 40280 | Ander Crenshaw C001045 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
39679 | 39679 | Eric Cantor C001046 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
42075 | 42075 | Shelley Capito C001047 | rep | WV | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
40759 | 40759 | John Culberson C001048 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
41299 | 41299 | Wm. Clay C001049 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
42255 | 42255 | Danny Davis D000096 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 7 |
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);