legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
26 rows where "start" is on date 2011-01-05 and state = "FL"
This data as json, copyable, CSV (advanced)
Suggested facets: end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39099 | 39099 | Sandy Adams A000366 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 24 | http://adams.house.gov/ | 216 Cannon HOB; Washington DC 20515-0924 | 202-225-2706 | 202-226-6299 | 216 Cannon House Office Building | ||||||||
39412 | 39412 | Connie Mack M001155 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 14 | http://www.house.gov/mack | 115 Cannon HOB; Washington DC 20515-0914 | 202-225-2536 | 202-226-0439 | http://mack.house.gov/index.cfm?FuseAction=ContactConnie.ContactForm | 115 Cannon House Office Building | |||||||
39490 | 39490 | David Rivera R000590 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 25 | http://rivera.house.gov/ | 417 Cannon HOB; Washington DC 20515-0925 | 202-225-2778 | 202-226-0346 | 417 Cannon House Office Building | ||||||||
39544 | 39544 | Clifford Stearns S000822 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 6 | http://www.house.gov/stearns | 2306 Rayburn HOB; Washington DC 20515-0906 | 202-225-5744 | 202-225-3973 | http://www.house.gov/writerep | 2306 Rayburn House Office Building | |||||||
39570 | 39570 | Allen West W000807 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 22 | http://west.house.gov/ | 1708 Longworth HOB; Washington DC 20515-0922 | 202-225-3026 | 202-225-8398 | 1708 Longworth House Office Building | ||||||||
39642 | 39642 | C. Young Y000031 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/young | 2407 Rayburn HOB; Washington DC 20515-0910 | 202-225-5961 | 202-225-9764 | http://www.house.gov/writerep | 2407 Rayburn House Office Building | |||||||
40060 | 40060 | Steve Southerland S001186 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 2 | http://southerland.house.gov/ | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1229 Longworth House Office Building | ||||||||
40264 | 40264 | Corrine Brown B000911 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | 2336 Rayburn HOB; Washington DC 20515-0903 | 202-225-0123 | 202-225-2256 | http://www.house.gov/corrinebrown/IMA/issue.shtml | 2336 Rayburn House Office Building | |||||||
40285 | 40285 | Ander Crenshaw C001045 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 4 | http://crenshaw.house.gov | 440 Cannon HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/wyr/welcome.shtml | 440 Cannon House Office Building | |||||||
40405 | 40405 | John Mica M000689 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 7 | http://www.house.gov/mica | 2187 Rayburn HOB; Washington DC 20515-0907 | 202-225-4035 | 202-226-0821 | http://www.house.gov/mica/messageform.shtml | 2187 Rayburn House Office Building | |||||||
40413 | 40413 | Jeff Miller M001144 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/jeffmiller | 2416 Rayburn HOB; Washington DC 20515-0901 | 202-225-4136 | 202-225-3414 | http://jeffmiller.house.gov/index.cfm?FuseAction=Contact.Home | 2416 Rayburn House Office Building | |||||||
40423 | 40423 | Richard Nugent N000185 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 5 | http://nugent.house.gov/ | 1517 Longworth HOB; Washington DC 20515-0905 | 202-225-1002 | 202- 226-6559 | 1517 Longworth House Office Building | ||||||||
40994 | 40994 | Thomas Rooney R000583 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 16 | http://rooney.house.gov | 1529 Longworth HOB; Washington DC 20515-0916 | 202-225-5792 | 202-225-3132 | https://forms.house.gov/rooney/contact-form.shtml | 1529 Longworth House Office Building | |||||||
41009 | 41009 | Ileana Ros-Lehtinen R000435 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 18 | http://www.house.gov/ros-lehtinen | 2206 Rayburn HOB; Washington DC 20515-0918 | 202-225-3931 | 202-225-5620 | http://www.house.gov/writerep | 2206 Rayburn House Office Building | |||||||
41019 | 41019 | Dennis Ross R000593 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 12 | http://dennisross.house.gov/ | 404 Cannon HOB; Washington DC 20515-0912 | 202-225-1252 | 202-226-0585 | 404 Cannon House Office Building | ||||||||
41640 | 41640 | Alcee Hastings H000324 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0923 | 202-225-1313 | 202-225-1171 | http://www.alceehastings.house.gov/index.php?option=com_content&task=view&id=104&Itemid= | 2353 Rayburn House Office Building | |||||||
41721 | 41721 | Theodore Deutch D000610 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 19 | http://deutch.house.gov/ | 1024 Longworth HOB; Washington DC 20515-0919 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/Forms/WriteYourRep/default.aspx | 1024 Longworth House Office Building | |||||||
41937 | 41937 | Gus Bilirakis B001257 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 9 | http://bilirakis.house.gov | 407 Cannon HOB; Washington DC 20515-0909 | 202-225-5755 | 202-225-4085 | http://bilirakis.house.gov/index.php?option=com_content&task=view&id=212&Itemid=44 | 407 Cannon House Office Building | |||||||
42020 | 42020 | Vern Buchanan B001260 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 13 | http://buchanan.house.gov | 221 Cannon HOB; Washington DC 20515-0913 | 202-225-5015 | 202-226-0828 | http://buchanan.house.gov/contact.shtml | 221 Cannon House Office Building | |||||||
42109 | 42109 | Kathy Castor C001066 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://castor.house.gov | 137 Cannon HOB; Washington DC 20515-0911 | 202-225-3376 | 202-225-5652 | https://forms.house.gov/wyr/welcome.shtml | 137 Cannon House Office Building | |||||||
42323 | 42323 | Mario Diaz-Balart D000600 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 21 | http://www.house.gov/mariodiaz-balart | 436 Cannon HOB; Washington DC 20515-0921 | 202-225-4211 | 202-225-8576 | Http://mariodiaz-balart.house.gov//index.cfm?sectionid=11 | 436 Cannon House Office Building | |||||||
43120 | 43120 | Bill Posey P000599 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 15 | http://posey.house.gov | 120 Cannon HOB; Washington DC 20515-0915 | 202-225-3671 | 202-225-3516 | http://posey.house.gov/Contact/ | 120 Cannon House Office Building | |||||||
43196 | 43196 | Marco Rubio R000595 | sen | FL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.rubio.senate.gov | 284 Russell Senate Office Building Washington DC 20510 | 202-224-3041 | 202-228-0285 | http://www.rubio.senate.gov/public/index.cfm/contact | 284 Russell Senate Office Building | junior | http://www.rubio.senate.gov/public/?a=rss.feed | |||||
43563 | 43563 | Debbie Wasserman Schultz W000797 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://www.house.gov/schultz | 118 Cannon HOB; Washington DC 20515-0920 | 202-225-7931 | 202-225-2052 | http://wassermanschultz.house.gov/zipauth.htm | 118 Cannon House Office Building | |||||||
43585 | 43585 | Daniel Webster W000806 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 8 | http://webster.house.gov/ | 1039 Longworth HOB; Washington DC 20515-0908 | 202-225-2176 | 202-225-0999 | 1039 Longworth House Office Building | ||||||||
43610 | 43610 | Frederica Wilson W000808 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://wilson.house.gov/ | 208 Cannon HOB; Washington DC 20515-0917 | 202-225-4506 | 202-226-0777 | 208 Cannon House Office Building |
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);