legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
26 rows where district = 6 and "end" is on date 2011-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38567 | 38567 | Barton Gordon G000309 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://gordon.house.gov | ||||||||||||
38929 | 38929 | Charles Wilson W000801 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
39126 | 39126 | Roscoe Bartlett B000208 | rep | MD | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
39216 | 39216 | Ben Chandler C001058 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39251 | 39251 | Norman Dicks D000327 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39464 | 39464 | Mike Pence P000587 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 6 | http://mikepence.house.gov | ||||||||||||
39543 | 39543 | Clifford Stearns S000822 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/stearns | ||||||||||||
39579 | 39579 | Lynn Woolsey W000738 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://woolsey.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 | ||||||||||||
39845 | 39845 | Jim Gerlach G000549 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://gerlach.house.gov | ||||||||||||
40024 | 40024 | Thomas Petri P000265 | rep | WI | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/petri | ||||||||||||
40076 | 40076 | John Tierney T000266 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/tierney | ||||||||||||
40143 | 40143 | Howard Coble C000556 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/coble | ||||||||||||
40531 | 40531 | Tom Price P000591 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/tomprice | ||||||||||||
40706 | 40706 | Joe Barton B000213 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 6 | http://joebarton.house.gov | ||||||||||||
40744 | 40744 | Mike Coffman C001077 | rep | CO | 2009-01-06 | 2011-01-03 | Republican | 6 | http://coffman.house.gov | ||||||||||||
40802 | 40802 | Jeff Flake F000444 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 6 | http://flake.house.gov | ||||||||||||
40825 | 40825 | Bob Goodlatte G000289 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/goodlatte | ||||||||||||
41014 | 41014 | Peter Roskam R000580 | rep | IL | 2009-01-06 | 2011-01-03 | Republican | 6 | http://roskam.house.gov | ||||||||||||
42102 | 42102 | Bill Cassidy C001075 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://cassidy.house.gov | ||||||||||||
42166 | 42166 | James Clyburn C000537 | rep | SC | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://clyburn.house.gov | ||||||||||||
42448 | 42448 | Sam Graves G000546 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42933 | 42933 | Gregory Meeks M001137 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/meeks | ||||||||||||
43050 | 43050 | Frank Pallone P000034 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/pallone | ||||||||||||
43523 | 43523 | Fred Upton U000031 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/upton |
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);