legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2011-01-03 sorted by url
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40222 | 40222 | Mark Kirk K000360 | sen | IL | 2010-11-29 | 2011-01-03 | 3 | Republican | |||||||||||||
41703 | 41703 | Tom Reed R000585 | rep | NY | 2010-11-18 | 2011-01-03 | Republican | 29 | |||||||||||||
39097 | 39097 | Gary Ackerman A000022 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ackerman.house.gov/ | ||||||||||||
38779 | 38779 | Adam Putnam P000586 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 12 | http://adamputnam.house.gov | ||||||||||||
41910 | 41910 | Robert Aderholt A000055 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
38405 | 38405 | John Adler A000364 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://adler.house.gov | ||||||||||||
43404 | 43404 | Adrian Smith S001172 | rep | NE | 2009-01-06 | 2011-01-03 | Republican | 3 | http://adriansmith.house.gov | ||||||||||||
39104 | 39104 | W. Akin A000358 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
41639 | 41639 | Alcee Hastings H000324 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 23 | http://alceehastings.house.gov | ||||||||||||
39619 | 39619 | Rodney Alexander A000361 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://alexander.house.gov/ | ||||||||||||
39107 | 39107 | Jason Altmire A000362 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
38407 | 38407 | Michael Arcuri A000363 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
39109 | 39109 | Steve Austria A000365 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 7 | http://austria.house.gov | ||||||||||||
39735 | 39735 | Michele Bachmann B001256 | rep | MN | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bachmann.house.gov | ||||||||||||
39746 | 39746 | Spencer Bachus B000013 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bachus.house.gov | ||||||||||||
38582 | 38582 | Baron Hill H001030 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
39751 | 39751 | John Barrow B001252 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://barrow.house.gov | ||||||||||||
39126 | 39126 | Roscoe Bartlett B000208 | rep | MD | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
37514 | 37514 | Evan Bayh B001233 | sen | IN | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://bayh.senate.gov | ||||||||||||
40520 | 40520 | Xavier Becerra B000287 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
41932 | 41932 | Michael Bennet B001267 | sen | CO | 2009-01-22 | 2011-01-03 | 3 | Democrat | appointment | http://bennet.senate.gov/ | |||||||||||
37519 | 37519 | Robert Bennett B000382 | sen | UT | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bennett.senate.gov | ||||||||||||
43458 | 43458 | Bennie Thompson T000193 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
39141 | 39141 | Shelley Berkley B001231 | rep | NV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://berkley.house.gov | ||||||||||||
38644 | 38644 | Betsy Markey M001172 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://betsymarkey.house.gov | ||||||||||||
41936 | 41936 | Gus Bilirakis B001257 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 9 | http://bilirakis.house.gov | ||||||||||||
41951 | 41951 | Sanford Bishop B000490 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://bishop.house.gov | ||||||||||||
41974 | 41974 | Earl Blumenauer B000574 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://blumenauer.house.gov | ||||||||||||
41989 | 41989 | Roy Blunt B000575 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 7 | http://blunt.house.gov/ | ||||||||||||
38435 | 38435 | John Boccieri B001263 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://boccieri.house.gov | ||||||||||||
37547 | 37547 | Christopher Bond B000611 | sen | MO | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bond.senate.gov | ||||||||||||
39613 | 39613 | Jo Bonner B001244 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39178 | 39178 | Mary Bono Mack B001228 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39190 | 39190 | Leonard Boswell B000652 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
40208 | 40208 | Barbara Boxer B000711 | sen | CA | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://boxer.senate.gov | ||||||||||||
38456 | 38456 | Allen Boyd B000716 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://boyd.house.gov | ||||||||||||
43362 | 43362 | Brad Sherman S000344 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 27 | http://bradsherman.house.gov | ||||||||||||
39761 | 39761 | Bruce Braley B001259 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
39765 | 39765 | Paul Broun B001262 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 10 | http://broun.house.gov/ | ||||||||||||
38462 | 38462 | Henry Brown B001235 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
37560 | 37560 | Samuel Brownback B000953 | sen | KS | 2005-01-04 | 2011-01-03 | 3 | Republican | http://brownback.senate.gov | ||||||||||||
42019 | 42019 | Vern Buchanan B001260 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 13 | http://buchanan.house.gov | ||||||||||||
37568 | 37568 | Jim Bunning B001066 | sen | KY | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bunning.senate.gov | ||||||||||||
42035 | 42035 | Michael Burgess B001248 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 26 | http://burgess.house.gov | ||||||||||||
42047 | 42047 | Richard Burr B001135 | sen | NC | 2005-01-04 | 2011-01-03 | 3 | Republican | http://burr.senate.gov | ||||||||||||
39206 | 39206 | Dan Burton B001149 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 5 | http://burton.house.gov | ||||||||||||
42068 | 42068 | Ken Calvert C000059 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
39777 | 39777 | Dave Camp C000071 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 4 | http://camp.house.gov | ||||||||||||
40196 | 40196 | Candice Miller M001150 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 10 | http://candicemiller.house.gov | ||||||||||||
39683 | 39683 | Eric Cantor C001046 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
42079 | 42079 | Shelley Capito C001047 | rep | WV | 2009-01-06 | 2011-01-03 | Republican | 2 | http://capito.house.gov | ||||||||||||
38478 | 38478 | Christopher Carney C001065 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
42085 | 42085 | André Carson C001072 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://carson.house.gov/ | ||||||||||||
42095 | 42095 | John Carter C001051 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 31 | http://carter.house.gov | ||||||||||||
42102 | 42102 | Bill Cassidy C001075 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://cassidy.house.gov | ||||||||||||
42108 | 42108 | Kathy Castor C001066 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://castor.house.gov | ||||||||||||
40542 | 40542 | Jason Chaffetz C001076 | rep | UT | 2009-01-06 | 2011-01-03 | Republican | 3 | http://chaffetz.house.gov | ||||||||||||
39216 | 39216 | Ben Chandler C001058 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
38929 | 38929 | Charles Wilson W000801 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
38966 | 38966 | Christopher Lee L000568 | rep | NY | 2009-01-06 | 2011-01-03 | Republican | 26 | http://chrislee.house.gov | ||||||||||||
42963 | 42963 | Christopher Murphy M001169 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
42128 | 42128 | Judy Chu C001080 | rep | CA | 2009-07-16 | 2011-01-03 | Democrat | 32 | http://chu.house.gov/ | ||||||||||||
42142 | 42142 | Yvette Clarke C001067 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://clarke.house.gov | ||||||||||||
42166 | 42166 | James Clyburn C000537 | rep | SC | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://clyburn.house.gov | ||||||||||||
39797 | 39797 | Thomas Coburn C000560 | sen | OK | 2005-01-04 | 2011-01-03 | 3 | Republican | http://coburn.senate.gov | ||||||||||||
40744 | 40744 | Mike Coffman C001077 | rep | CO | 2009-01-06 | 2011-01-03 | Republican | 6 | http://coffman.house.gov | ||||||||||||
42174 | 42174 | Steve Cohen C001068 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://cohen.house.gov | ||||||||||||
41428 | 41428 | Collin Peterson P000258 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://collinpeterson.house.gov | ||||||||||||
42191 | 42191 | Gerald Connolly C001078 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://connolly.house.gov | ||||||||||||
42207 | 42207 | Jim Cooper C000754 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://cooper.house.gov | ||||||||||||
42224 | 42224 | Joe Courtney C001069 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42235 | 42235 | Michael Crapo C000880 | sen | ID | 2005-01-04 | 2011-01-03 | 3 | Republican | http://crapo.senate.gov | ||||||||||||
40284 | 40284 | Ander Crenshaw C001045 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
39233 | 39233 | Mark Critz C001081 | rep | PA | 2010-05-20 | 2011-01-03 | Democrat | 12 | http://critz.house.gov/ | ||||||||||||
40763 | 40763 | John Culberson C001048 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 7 | http://culberson.house.gov | ||||||||||||
38490 | 38490 | Kathleen Dahlkemper D000608 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://dahlkemper.house.gov | ||||||||||||
43314 | 43314 | David Scott S001157 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://davidscott.house.gov | ||||||||||||
42277 | 42277 | Peter DeFazio D000191 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://defazio.house.gov | ||||||||||||
39587 | 39587 | Jim DeMint D000595 | sen | SC | 2005-01-04 | 2011-01-03 | 3 | Republican | http://demint.senate.gov | ||||||||||||
40641 | 40641 | Charles Dent D000604 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 15 | http://dent.house.gov | ||||||||||||
41720 | 41720 | Theodore Deutch D000610 | rep | FL | 2010-04-15 | 2011-01-03 | Democrat | 19 | http://deutch.house.gov/ | ||||||||||||
38935 | 38935 | Charles Djou D000611 | rep | HI | 2010-05-22 | 2011-01-03 | Republican | 1 | http://djou.house.gov/ | ||||||||||||
37611 | 37611 | Christopher Dodd D000388 | sen | CT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dodd.senate.gov | ||||||||||||
40289 | 40289 | Donna Edwards E000290 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://donnaedwards.house.gov/ | ||||||||||||
40773 | 40773 | Joe Donnelly D000607 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://donnelly.house.gov | ||||||||||||
41682 | 41682 | Don Young Y000033 | rep | AK | 2009-01-06 | 2011-01-03 | Republican | 0 | http://donyoung.house.gov | ||||||||||||
37621 | 37621 | Byron Dorgan D000432 | sen | ND | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dorgan.senate.gov | ||||||||||||
39267 | 39267 | David Dreier D000492 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
38524 | 38524 | Steve Driehaus D000609 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://driehaus.house.gov | ||||||||||||
40793 | 40793 | Keith Ellison E000288 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ellison.house.gov | ||||||||||||
38545 | 38545 | Brad Ellsworth E000289 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://ellsworth.house.gov | ||||||||||||
42371 | 42371 | Anna Eshoo E000215 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://eshoo.house.gov | ||||||||||||
38554 | 38554 | Mary Fallin F000453 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
37636 | 37636 | Russell Feingold F000061 | sen | WI | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://feingold.senate.gov | ||||||||||||
40802 | 40802 | Jeff Flake F000444 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 6 | http://flake.house.gov | ||||||||||||
40315 | 40315 | John Fleming F000456 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://fleming.house.gov | ||||||||||||
41691 | 41691 | Jeff Fortenberry F000449 | rep | NE | 2009-01-06 | 2011-01-03 | Republican | 1 | http://fortenberry.house.gov | ||||||||||||
43689 | 43689 | Bill Foster F000454 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://foster.house.gov | ||||||||||||
42386 | 42386 | Virginia Foxx F000450 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
40812 | 40812 | Rodney Frelinghuysen F000372 | rep | NJ | 2009-01-06 | 2011-01-03 | Republican | 11 | http://frelinghuysen.house.gov |
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);