legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
20 rows where "start" is on date 2003-01-07 and state = "IL"
This data as json, copyable, CSV (advanced)
Suggested facets: type, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37299 | 37299 | Philip Crane C000873 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/crane | ||||||||||||
37410 | 37410 | William Lipinski L000342 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/lipinski | ||||||||||||
37632 | 37632 | Lane Evans E000250 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/evans | ||||||||||||
37711 | 37711 | Henry Hyde H001022 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/hyde | ||||||||||||
38016 | 38016 | Rahm Emanuel E000287 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38086 | 38086 | J. Hastert H000323 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 14 | http://www.house.gov/hastert | ||||||||||||
38172 | 38172 | Ray LaHood L000552 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 18 | http://www.house.gov/lahood | ||||||||||||
38376 | 38376 | Gerald Weller W000273 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 11 | http://www.house.gov/weller | ||||||||||||
39003 | 39003 | Jesse Jackson J000283 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.jessejacksonjr.org/ | ||||||||||||
39160 | 39160 | Judy Biggert B001232 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 13 | http://www.house.gov/biggert | ||||||||||||
39227 | 39227 | Jerry Costello C000794 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39340 | 39340 | Timothy Johnson J000285 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 15 | http://www.house.gov/timjohnson | ||||||||||||
39418 | 39418 | Donald Manzullo M001138 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 16 | http://www.house.gov/manzullo | ||||||||||||
40218 | 40218 | Mark Kirk K000360 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/kirk | ||||||||||||
40852 | 40852 | Luis Gutiérrez G000535 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/gutierrez | ||||||||||||
41485 | 41485 | John Shimkus S000364 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 19 | http://www.house.gov/shimkus | ||||||||||||
41844 | 41844 | Richard Durbin D000563 | sen | IL | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://durbin.senate.gov | ||||||||||||
42256 | 42256 | Danny Davis D000096 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
43213 | 43213 | Bobby Rush R000515 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/rush | ||||||||||||
43258 | 43258 | Janice Schakowsky S001145 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/schakowsky |
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);