legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
43 rows where district = 1 and "end" is on date 2011-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38427 | 38427 | Robert Berry B000420 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/berry/ | ||||||||||||
38462 | 38462 | Henry Brown B001235 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
38489 | 38489 | Travis Childers C001074 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.childers.house.gov/ | ||||||||||||
38524 | 38524 | Steve Driehaus D000609 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://driehaus.house.gov | ||||||||||||
38622 | 38622 | Patrick Kennedy K000113 | rep | RI | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://patrickkennedy.house.gov | ||||||||||||
38634 | 38634 | Frank Kratovil K000371 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://kratovil.house.gov | ||||||||||||
38667 | 38667 | Walter Minnick M001175 | rep | ID | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://minnick.house.gov | ||||||||||||
38683 | 38683 | Alan Mollohan M000844 | rep | WV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38869 | 38869 | Bart Stupak S001045 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38935 | 38935 | Charles Djou D000611 | rep | HI | 2010-05-22 | 2011-01-03 | Republican | 1 | http://djou.house.gov/ | ||||||||||||
38964 | 38964 | Jay Inslee I000026 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38997 | 38997 | David Wu W000793 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39141 | 39141 | Shelley Berkley B001231 | rep | NV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://berkley.house.gov | ||||||||||||
39446 | 39446 | John Olver O000085 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/olver | ||||||||||||
39549 | 39549 | John Sullivan S001155 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/sullivan | ||||||||||||
39613 | 39613 | Jo Bonner B001244 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39676 | 39676 | Robert Andrews A000210 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
39757 | 39757 | Timothy Bishop B001242 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://wwwc.house.gov/timbishop | ||||||||||||
39761 | 39761 | Bruce Braley B001259 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
39899 | 39899 | Jack Kingston K000220 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://kingston.house.gov | ||||||||||||
40185 | 40185 | Ed Whitfield W000413 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/whitfield | ||||||||||||
40412 | 40412 | Jeff Miller M001144 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/jeffmiller | ||||||||||||
40729 | 40729 | Robert Brady B001227 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.brady.house.gov | ||||||||||||
41041 | 41041 | Paul Ryan R000570 | rep | WI | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/ryan | ||||||||||||
41078 | 41078 | Timothy Walz W000799 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://walz.house.gov | ||||||||||||
41159 | 41159 | Carol Shea-Porter S001170 | rep | NH | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://shea-porter.house.gov | ||||||||||||
41293 | 41293 | Rob Bishop B001250 | rep | UT | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/robbishop | ||||||||||||
41303 | 41303 | Wm. Clay C001049 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
41439 | 41439 | David Roe R000582 | rep | TN | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.roe.house.gov | ||||||||||||
41524 | 41524 | Peter Visclosky V000108 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/visclosky | ||||||||||||
41691 | 41691 | Jeff Fortenberry F000449 | rep | NE | 2009-01-06 | 2011-01-03 | Republican | 1 | http://fortenberry.house.gov | ||||||||||||
42053 | 42053 | George Butterfield B001251 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/butterfield | ||||||||||||
42290 | 42290 | Diana DeGette D000197 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42408 | 42408 | Louie Gohmert G000552 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 1 | http://gohmert.house.gov | ||||||||||||
42499 | 42499 | Martin Heinrich H001046 | rep | NM | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://heinrich.house.gov | ||||||||||||
42702 | 42702 | John Larson L000557 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42955 | 42955 | Jerry Moran M000934 | rep | KS | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.jerrymoran.house.gov | ||||||||||||
43103 | 43103 | Chellie Pingree P000597 | rep | ME | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://pingree.house.gov | ||||||||||||
43216 | 43216 | Bobby Rush R000515 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/rush | ||||||||||||
43249 | 43249 | Steve Scalise S001176 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://scalise.house.gov/ | ||||||||||||
43470 | 43470 | Mike Thompson T000460 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://mikethompson.house.gov | ||||||||||||
43617 | 43617 | Robert Wittman W000804 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.wittman.house.gov/ | ||||||||||||
44279 | 44279 | Ann Kirkpatrick K000368 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://kirkpatrick.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);