legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where "start" is on date 2003-01-07 and state = "FL"
This data as json, copyable, CSV (advanced)
Suggested facets: end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37305 | 37305 | Peter Deutsch D000275 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 20 | http://www.house.gov/deutsch | ||||||||||||
37363 | 37363 | Porter Goss G000336 | rep | FL | 2003-01-07 | 2004-09-23 | Republican | 14 | http://www.house.gov/goss | ||||||||||||
37530 | 37530 | Michael Bilirakis B000463 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
37591 | 37591 | James Davis D000114 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37641 | 37641 | Mark Foley F000238 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 16 | http://www.house.gov/foley | ||||||||||||
37670 | 37670 | Katherine Harris H001035 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 13 | http://www.house.gov/harris | ||||||||||||
37873 | 37873 | E. Shaw S000303 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 22 | http://www.house.gov/shaw | ||||||||||||
38038 | 38038 | Tom Feeney F000447 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38146 | 38146 | Ric Keller K000361 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/keller/ | ||||||||||||
38369 | 38369 | David Weldon W000267 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 15 | http://www.house.gov/curtweldon | ||||||||||||
38453 | 38453 | Allen Boyd B000716 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38463 | 38463 | Virginia Brown-Waite B001247 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38520 | 38520 | Lincoln Diaz-Balart D000299 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38660 | 38660 | Kendrick Meek M001148 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/kenmeek | ||||||||||||
38776 | 38776 | Adam Putnam P000586 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 12 | http://www.house.gov/putnam | ||||||||||||
38924 | 38924 | Robert Wexler W000314 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 19 | http://www.wexler.house.gov | ||||||||||||
39540 | 39540 | Clifford Stearns S000822 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/stearns | ||||||||||||
39638 | 39638 | C. Young Y000031 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/young | ||||||||||||
40260 | 40260 | Corrine Brown B000911 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | ||||||||||||
40281 | 40281 | Ander Crenshaw C001045 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
40401 | 40401 | John Mica M000689 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/mica | ||||||||||||
40409 | 40409 | Jeff Miller M001144 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/jeffmiller | ||||||||||||
41005 | 41005 | Ileana Ros-Lehtinen R000435 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 18 | http://www.house.gov/ros-lehtinen | ||||||||||||
41636 | 41636 | Alcee Hastings H000324 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 23 | http://www.house.gov/alceehastings | ||||||||||||
42319 | 42319 | Mario Diaz-Balart D000600 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart |
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);