legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
30 rows where district = 5 and "end" is on date 2011-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38466 | 38466 | Virginia Brown-Waite B001247 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38554 | 38554 | Mary Fallin F000453 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
38568 | 38568 | Parker Griffith G000557 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 5 | [ { "start": "2009-01-06", "end": "2009-12-22", "party": "Democrat" }, { "start": "2009-12-22", "end": "2011-01-03", "party": "Republican" } ] |
http://griffith.house.gov | |||||||||||
38669 | 38669 | Harry Mitchell M001167 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38765 | 38765 | Thomas Perriello P000600 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://perriello.house.gov | ||||||||||||
38860 | 38860 | John Spratt S000749 | rep | SC | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
39097 | 39097 | Gary Ackerman A000022 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ackerman.house.gov/ | ||||||||||||
39206 | 39206 | Dan Burton B001149 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 5 | http://burton.house.gov | ||||||||||||
39361 | 39361 | Dale Kildee K000172 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39619 | 39619 | Rodney Alexander A000361 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://alexander.house.gov/ | ||||||||||||
40330 | 40330 | Scott Garrett G000548 | rep | NJ | 2009-01-06 | 2011-01-03 | Republican | 5 | http://garrett.house.gov | ||||||||||||
40793 | 40793 | Keith Ellison E000288 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ellison.house.gov | ||||||||||||
40868 | 40868 | Jeb Hensarling H001036 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/hensarling | ||||||||||||
41072 | 41072 | Niki Tsongas T000465 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://tsongas.house.gov/ | ||||||||||||
41240 | 41240 | John Lewis L000287 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/johnlewis | ||||||||||||
41368 | 41368 | Steve King K000362 | rep | IA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/steveking | ||||||||||||
41460 | 41460 | F. Sensenbrenner S000244 | rep | WI | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/sensenbrenner | ||||||||||||
42151 | 42151 | Emanuel Cleaver C001061 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/cleaver | ||||||||||||
42207 | 42207 | Jim Cooper C000754 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://cooper.house.gov | ||||||||||||
42386 | 42386 | Virginia Foxx F000450 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
42546 | 42546 | Steny Hoyer H000874 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://hoyer.house.gov | ||||||||||||
42664 | 42664 | Doug Lamborn L000564 | rep | CO | 2009-01-06 | 2011-01-03 | Republican | 5 | http://lamborn.house.gov | ||||||||||||
42710 | 42710 | Robert Latta L000566 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 5 | http://latta.house.gov/ | ||||||||||||
42840 | 42840 | Doris Matsui M001163 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
42912 | 42912 | Cathy McMorris Rodgers M001159 | rep | WA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://mcmorris.house.gov | ||||||||||||
42963 | 42963 | Christopher Murphy M001169 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
43143 | 43143 | Mike Quigley Q000023 | rep | IL | 2009-04-07 | 2011-01-03 | Democrat | 5 | http://quigley.house.gov/ | ||||||||||||
43164 | 43164 | Harold Rogers R000395 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 5 | http://halrogers.house.gov | ||||||||||||
43279 | 43279 | Kurt Schrader S001180 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://schrader.house.gov | ||||||||||||
43477 | 43477 | Glenn Thompson T000467 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://thompson.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);