legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
33 rows where district = 4 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38475 | 38475 | Stephen Buyer B001203 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 4 | http://stevebuyer.house.gov | ||||||||||||
38498 | 38498 | Lincoln Davis D000599 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38599 | 38599 | Bob Inglis I000023 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 4 | http://inglis.house.gov | ||||||||||||
38644 | 38644 | Betsy Markey M001172 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://betsymarkey.house.gov | ||||||||||||
38824 | 38824 | Ike Skelton S000465 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38898 | 38898 | Gene Taylor T000074 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38907 | 38907 | Todd Tiahrt T000260 | rep | KS | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38944 | 38944 | Geoff Davis D000603 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 4 | http://geoffdavis.house.gov | ||||||||||||
39107 | 39107 | Jason Altmire A000362 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39283 | 39283 | Barney Frank F000339 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39495 | 39495 | Mike Ross R000573 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39777 | 39777 | Dave Camp C000071 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 4 | http://camp.house.gov | ||||||||||||
39870 | 39870 | Ralph Hall H000067 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/ralphhall | ||||||||||||
39880 | 39880 | Doc Hastings H000329 | rep | WA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://hastings.house.gov | ||||||||||||
39909 | 39909 | Tom Latham L000111 | rep | IA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39925 | 39925 | Carolyn McCarthy M000309 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/carolynmccarthy | ||||||||||||
40006 | 40006 | Ed Pastor P000099 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/pastor | ||||||||||||
40284 | 40284 | Ander Crenshaw C001045 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
40289 | 40289 | Donna Edwards E000290 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://donnaedwards.house.gov/ | ||||||||||||
40315 | 40315 | John Fleming F000456 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://fleming.house.gov | ||||||||||||
40323 | 40323 | J. Forbes F000445 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/forbes | ||||||||||||
40855 | 40855 | Luis Gutiérrez G000535 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/gutierrez | ||||||||||||
41910 | 41910 | Robert Aderholt A000055 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
42184 | 42184 | Tom Cole C001053 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
42277 | 42277 | Peter DeFazio D000191 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://defazio.house.gov | ||||||||||||
42518 | 42518 | James Himes H001047 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://himes.house.gov | ||||||||||||
42595 | 42595 | Henry Johnson J000288 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://hankjohnson.house.gov | ||||||||||||
42605 | 42605 | Jim Jordan J000289 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 4 | http://jordan.house.gov | ||||||||||||
42864 | 42864 | Tom McClintock M001177 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://mcclintock.house.gov | ||||||||||||
42875 | 42875 | Betty McCollum M001143 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/mccollum | ||||||||||||
42942 | 42942 | Gwen Moore M001160 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/gwenmoore | ||||||||||||
43136 | 43136 | David Price P000523 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://price.house.gov | ||||||||||||
43425 | 43425 | Christopher Smith S000522 | rep | NJ | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/chrissmith |
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);