legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
34 rows where "start" is on date 1999-01-06 and type = "sen"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36521 | 36521 | John Breaux B000780 | sen | LA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://breaux.senate.gov/ | ||||||||||||
36544 | 36544 | Ben Campbell C000077 | sen | CO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://campbell.senate.gov/ | ||||||||||||
36576 | 36576 | Paul Coverdell C000813 | sen | GA | 1999-01-06 | 2001-01-03 | 3 | Republican | |||||||||||||
36587 | 36587 | Thomas Daschle D000064 | sen | SD | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://daschle.senate.gov/ | ||||||||||||
36603 | 36603 | John Edwards E000286 | sen | NC | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://edwards.senate.gov/ | ||||||||||||
36609 | 36609 | Peter Fitzgerald F000442 | sen | IL | 1999-01-06 | 2005-01-03 | 3 | Republican | http://fitzgerald.senate.gov/ | ||||||||||||
36646 | 36646 | Bob Graham G000352 | sen | FL | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://graham.senate.gov/ | ||||||||||||
36655 | 36655 | Ernest Hollings H000725 | sen | SC | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://hollings.senate.gov/ | ||||||||||||
36719 | 36719 | Frank Murkowski M001085 | sen | AK | 1999-01-06 | 2002-12-19 | 3 | Republican | |||||||||||||
36723 | 36723 | Don Nickles N000102 | sen | OK | 1999-01-06 | 2005-01-03 | 3 | Republican | http://nickles.senate.gov/ | ||||||||||||
37513 | 37513 | Evan Bayh B001233 | sen | IN | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://bayh.senate.gov/ | ||||||||||||
37518 | 37518 | Robert Bennett B000382 | sen | UT | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bennett.senate.gov/ | ||||||||||||
37546 | 37546 | Christopher Bond B000611 | sen | MO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bond.senate.gov/ | ||||||||||||
37559 | 37559 | Samuel Brownback B000953 | sen | KS | 1999-01-06 | 2005-01-03 | 3 | Republican | http://brownback.senate.gov/ | ||||||||||||
37567 | 37567 | Jim Bunning B001066 | sen | KY | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bunning.senate.gov/ | ||||||||||||
37610 | 37610 | Christopher Dodd D000388 | sen | CT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dodd.senate.gov/ | ||||||||||||
37620 | 37620 | Byron Dorgan D000432 | sen | ND | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dorgan.senate.gov/ | ||||||||||||
37635 | 37635 | Russell Feingold F000061 | sen | WI | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://feingold.senate.gov/ | ||||||||||||
37662 | 37662 | Judd Gregg G000445 | sen | NH | 1999-01-06 | 2005-01-03 | 3 | Republican | http://gregg.senate.gov/ | ||||||||||||
37774 | 37774 | Blanche Lincoln L000035 | sen | AR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
37886 | 37886 | Arlen Specter S000709 | sen | PA | 1999-01-06 | 2005-01-03 | 3 | Republican | http://specter.senate.gov/ | ||||||||||||
37920 | 37920 | George Voinovich V000126 | sen | OH | 1999-01-06 | 2005-01-03 | 3 | Republican | http://voinovich.senate.gov/ | ||||||||||||
39027 | 39027 | Daniel Inouye I000025 | sen | HI | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://inouye.senate.gov/ | ||||||||||||
40207 | 40207 | Barbara Boxer B000711 | sen | CA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://boxer.senate.gov/ | ||||||||||||
40231 | 40231 | Barbara Mikulski M000702 | sen | MD | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://mikulski.senate.gov/ | ||||||||||||
40238 | 40238 | Harry Reid R000146 | sen | NV | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://reid.senate.gov/ | ||||||||||||
40650 | 40650 | John McCain M000303 | sen | AZ | 1999-01-06 | 2005-01-03 | 3 | Republican | http://mccain.senate.gov/ | ||||||||||||
42234 | 42234 | Michael Crapo C000880 | sen | ID | 1999-01-06 | 2005-01-03 | 3 | Republican | http://crapo.senate.gov/ | ||||||||||||
42440 | 42440 | Charles Grassley G000386 | sen | IA | 1999-01-06 | 2005-01-03 | 3 | Republican | http://grassley.senate.gov/ | ||||||||||||
42721 | 42721 | Patrick Leahy L000174 | sen | VT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://leahy.senate.gov/ | ||||||||||||
42968 | 42968 | Patty Murray M001111 | sen | WA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://murray.senate.gov/ | ||||||||||||
43295 | 43295 | Charles Schumer S000148 | sen | NY | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://schumer.senate.gov/ | ||||||||||||
43352 | 43352 | Richard Shelby S000320 | sen | AL | 1999-01-06 | 2005-01-03 | 3 | Republican | http://shelby.senate.gov/ | ||||||||||||
43639 | 43639 | Ron Wyden W000779 | sen | OR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://wyden.senate.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);