legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
220 rows where "end" is on date 2009-01-03 and party = "Republican"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37228 | 37228 | Wayne Allard A000109 | sen | CO | 2003-01-07 | 2009-01-03 | 2 | Republican | http://allard.senate.gov | ||||||||||||
37257 | 37257 | Norm Coleman C001057 | sen | MN | 2003-01-07 | 2009-01-03 | 2 | Republican | http://coleman.senate.gov | ||||||||||||
37281 | 37281 | Larry Craig C000858 | sen | ID | 2003-01-07 | 2009-01-03 | 2 | Republican | http://craig.senate.gov | ||||||||||||
37306 | 37306 | Elizabeth Dole D000601 | sen | NC | 2003-01-07 | 2009-01-03 | 2 | Republican | http://dole.senate.gov/ | ||||||||||||
37312 | 37312 | Pete Domenici D000407 | sen | NM | 2003-01-07 | 2009-01-03 | 2 | Republican | http://domenici.senate.gov | ||||||||||||
37371 | 37371 | Charles Hagel H001028 | sen | NE | 2003-01-07 | 2009-01-03 | 2 | Republican | http://hagel.senate.gov/ | ||||||||||||
37460 | 37460 | Gordon Smith S001142 | sen | OR | 2003-01-07 | 2009-01-03 | 2 | Republican | http://gsmith.senate.gov/ | ||||||||||||
37486 | 37486 | Ted Stevens S000888 | sen | AK | 2003-01-07 | 2009-01-03 | 2 | Republican | http://stevens.senate.gov/ | ||||||||||||
37490 | 37490 | John Sununu S001078 | sen | NH | 2003-01-07 | 2009-01-03 | 2 | Republican | http://sununu.senate.gov/ | ||||||||||||
37512 | 37512 | John Warner W000154 | sen | VA | 2003-01-07 | 2009-01-03 | 2 | Republican | http://warner.senate.gov/ | ||||||||||||
37968 | 37968 | Christopher Cannon C000116 | rep | UT | 2007-01-04 | 2009-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
37992 | 37992 | Barbara Cubin C000962 | rep | WY | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
37993 | 37993 | David Davis D000606 | rep | TN | 2007-01-04 | 2009-01-03 | Republican | 1 | http://daviddavis.house.gov | ||||||||||||
38013 | 38013 | John Doolittle D000429 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://doolittle.house.gov | ||||||||||||
38015 | 38015 | Thelma Drake D000605 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 2 | http://drake.house.gov | ||||||||||||
38025 | 38025 | Philip English E000187 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/english | ||||||||||||
38037 | 38037 | Terry Everett E000268 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.everett.house.gov | ||||||||||||
38040 | 38040 | Tom Feeney F000447 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38044 | 38044 | Michael Ferguson F000443 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/ferguson | ||||||||||||
38046 | 38046 | Luis Fortuño F000452 | rep | PR | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/fortuno | ||||||||||||
38052 | 38052 | Vito Fossella F000440 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 13 | http://www.house.gov/fossella | ||||||||||||
38061 | 38061 | Wayne Gilchrest G000180 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/gilchrest | ||||||||||||
38077 | 38077 | Virgil Goode G000280 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/goode | ||||||||||||
38093 | 38093 | Robin Hayes H001029 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 8 | http://hayes.house.gov | ||||||||||||
38102 | 38102 | David Hobson H000666 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/hobson | ||||||||||||
38114 | 38114 | Kenny Hulshof H000948 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 9 | http://hulshof.house.gov | ||||||||||||
38128 | 38128 | Duncan Hunter H000981 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38148 | 38148 | Ric Keller K000361 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/keller/Frset.htm | ||||||||||||
38165 | 38165 | Joseph Knollenberg K000288 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/knollenberg | ||||||||||||
38167 | 38167 | John Kuhl K000364 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 29 | http://www.house.gov/kuhl | ||||||||||||
38174 | 38174 | Ray LaHood L000552 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 18 | http://www.house.gov/lahood | ||||||||||||
38201 | 38201 | Ron Lewis L000293 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/ronlewis | ||||||||||||
38225 | 38225 | James McCrery M000388 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://mccrery.house.gov | ||||||||||||
38253 | 38253 | Marilyn Musgrave M001152 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 4 | http://musgrave.house.gov | ||||||||||||
38266 | 38266 | John Peterson P000263 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/johnpeterson | ||||||||||||
38272 | 38272 | Charles Pickering P000323 | rep | MS | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/pickering | ||||||||||||
38275 | 38275 | Jon Porter P000589 | rep | NV | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/porter | ||||||||||||
38283 | 38283 | Deborah Pryce P000555 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 15 | http://www.house.gov/pryce | ||||||||||||
38292 | 38292 | James Ramstad R000033 | rep | MN | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/ramstad | ||||||||||||
38310 | 38310 | Ralph Regula R000141 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 16 | http://wwwc.house.gov/regula | ||||||||||||
38313 | 38313 | Rick Renzi R000574 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38318 | 38318 | Thomas Reynolds R000569 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 26 | http://reynolds.house.gov | ||||||||||||
38319 | 38319 | Bill Sali S001167 | rep | ID | 2007-01-04 | 2009-01-03 | Republican | 1 | http://sali.house.gov | ||||||||||||
38332 | 38332 | H. Saxton S000097 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/saxton | ||||||||||||
38343 | 38343 | Christopher Shays S001144 | rep | CT | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38348 | 38348 | Thomas Tancredo T000458 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 6 | http://tancredo.house.gov | ||||||||||||
38364 | 38364 | James Walsh W000099 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 25 | http://www.house.gov/walsh | ||||||||||||
38371 | 38371 | David Weldon W000267 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 15 | http://weldon.house.gov | ||||||||||||
38378 | 38378 | Gerald Weller W000273 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 11 | http://www.house.gov/weller | ||||||||||||
38384 | 38384 | Heather Wilson W000789 | rep | NM | 2007-01-04 | 2009-01-03 | Republican | 1 | http://wilson.house.gov | ||||||||||||
38416 | 38416 | James Barrett B001239 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38461 | 38461 | Henry Brown B001235 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
38465 | 38465 | Virginia Brown-Waite B001247 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38474 | 38474 | Stephen Buyer B001203 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
38486 | 38486 | Michael Castle C000243 | rep | DE | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38506 | 38506 | Nathan Deal D000168 | rep | GA | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/deal | ||||||||||||
38522 | 38522 | Lincoln Diaz-Balart D000299 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38542 | 38542 | Vernon Ehlers E000092 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38553 | 38553 | Mary Fallin F000453 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
38592 | 38592 | Peter Hoekstra H000676 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38598 | 38598 | Bob Inglis I000023 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 4 | http://inglis.house.gov | ||||||||||||
38642 | 38642 | John Linder L000321 | rep | GA | 2007-01-04 | 2009-01-03 | Republican | 7 | http://linder.house.gov | ||||||||||||
38657 | 38657 | John McHugh M000472 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 23 | http://mchugh.house.gov | ||||||||||||
38778 | 38778 | Adam Putnam P000586 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 12 | http://adamputnam.house.gov | ||||||||||||
38786 | 38786 | George Radanovich R000004 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 19 | http://radanovich.house.gov | ||||||||||||
38806 | 38806 | John Shadegg S000275 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
38843 | 38843 | Mark Souder S001143 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 3 | http://souder.house.gov | ||||||||||||
38906 | 38906 | Todd Tiahrt T000260 | rep | KS | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38914 | 38914 | Zach Wamp W000119 | rep | TN | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/wamp | ||||||||||||
38943 | 38943 | Geoff Davis D000603 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 4 | http://geoffdavis.house.gov | ||||||||||||
38970 | 38970 | Thaddeus McCotter M001147 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 11 | http://mccotter.house.gov | ||||||||||||
39103 | 39103 | W. Akin A000358 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39125 | 39125 | Roscoe Bartlett B000208 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
39162 | 39162 | Judy Biggert B001232 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 13 | http://www.house.gov/biggert | ||||||||||||
39169 | 39169 | Brian Bilbray B000461 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
39177 | 39177 | Mary Bono Mack B001228 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39205 | 39205 | Dan Burton B001149 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/burton | ||||||||||||
39266 | 39266 | David Dreier D000492 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39295 | 39295 | Elton Gallegly G000021 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39316 | 39316 | Walter Herger H000528 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39342 | 39342 | Timothy Johnson J000285 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 15 | http://www.house.gov/timjohnson | ||||||||||||
39379 | 39379 | Steven LaTourette L000553 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 14 | http://www.house.gov/latourette | ||||||||||||
39397 | 39397 | Jerry Lewis L000274 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39406 | 39406 | Daniel Lungren L000517 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.lungren.house.gov | ||||||||||||
39410 | 39410 | Connie Mack M001155 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 14 | http://www.house.gov/mack | ||||||||||||
39420 | 39420 | Donald Manzullo M001138 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 16 | http://manzullo.house.gov | ||||||||||||
39434 | 39434 | Sue Myrick M001134 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/myrick | ||||||||||||
39457 | 39457 | Ronald Paul P000583 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 14 | http://www.house.gov/paul | ||||||||||||
39463 | 39463 | Mike Pence P000587 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 6 | http://mikepence.house.gov | ||||||||||||
39469 | 39469 | Todd Platts P000585 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 19 | http://www.house.gov/platts | ||||||||||||
39476 | 39476 | Dennis Rehberg R000571 | rep | MT | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/rehberg | ||||||||||||
39507 | 39507 | Jean Schmidt S001164 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/schmidt | ||||||||||||
39542 | 39542 | Clifford Stearns S000822 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/stearns | ||||||||||||
39548 | 39548 | John Sullivan S001155 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/sullivan | ||||||||||||
39594 | 39594 | Jo Ann Emerson E000172 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39612 | 39612 | Jo Bonner B001244 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39618 | 39618 | Rodney Alexander A000361 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/alexander | ||||||||||||
39640 | 39640 | C. Young Y000031 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 10 | http://www.house.gov/young | ||||||||||||
39682 | 39682 | Eric Cantor C001046 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
39691 | 39691 | Saxby Chambliss C000286 | sen | GA | 2003-01-07 | 2009-01-03 | 2 | Republican | http://chambliss.senate.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);