legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "end" is on date 2003-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37577 | 37577 | C. Cox C000830 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 47 | |||||||||||||
37585 | 37585 | Randall Cunningham C000994 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 51 | |||||||||||||
37590 | 37590 | James Davis D000114 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
37601 | 37601 | Thomas DeLay D000217 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 22 | |||||||||||||
37631 | 37631 | Lane Evans E000250 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
37640 | 37640 | Mark Foley F000238 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 16 | |||||||||||||
37645 | 37645 | Harold Ford F000262 | rep | TN | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
37650 | 37650 | James Gibbons G000152 | rep | NV | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37654 | 37654 | Mark Green G000545 | rep | WI | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37667 | 37667 | Gilbert Gutknecht G000536 | rep | MN | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37672 | 37672 | Melissa Hart H001033 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
37678 | 37678 | John Hayworth H000413 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37688 | 37688 | Joel Hefley H000444 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37694 | 37694 | John Hostettler H000807 | rep | IN | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37710 | 37710 | Henry Hyde H001022 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37717 | 37717 | Ernest Istook I000047 | rep | OK | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37722 | 37722 | William Jenkins J000082 | rep | TN | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37734 | 37734 | Nancy Johnson J000163 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37740 | 37740 | Sue Kelly K000078 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 19 | |||||||||||||
37743 | 37743 | Mark Kennedy K000358 | rep | MN | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37754 | 37754 | James Kolbe K000306 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37769 | 37769 | James Leach L000169 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37781 | 37781 | Cynthia McKinney M000523 | rep | GA | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
37786 | 37786 | Robert Ney N000081 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 18 | |||||||||||||
37791 | 37791 | Anne Northup N000143 | rep | KY | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37799 | 37799 | James Nussle N000172 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37802 | 37802 | Thomas Osborne O000165 | rep | NE | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37805 | 37805 | C.L. Otter O000166 | rep | ID | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37817 | 37817 | Major Owens O000159 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
37830 | 37830 | Michael Oxley O000163 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
37837 | 37837 | Richard Pombo P000419 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
37843 | 37843 | Jim Ryun R000566 | rep | KS | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37857 | 37857 | Martin Sabo S000005 | rep | MN | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37872 | 37872 | E. Shaw S000303 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 22 | |||||||||||||
37876 | 37876 | Donald Sherwood S001146 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 10 | |||||||||||||
37879 | 37879 | Robert Simmons S001152 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37891 | 37891 | Ted Strickland S001004 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
37895 | 37895 | John Sweeney S001149 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 22 | |||||||||||||
37903 | 37903 | Charles Taylor T000067 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
37917 | 37917 | William Thomas T000188 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 21 | |||||||||||||
37929 | 37929 | W. Weldon W000268 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
37935 | 37935 | Thomas Allen A000357 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37946 | 37946 | Richard Baker B000072 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37965 | 37965 | Christopher Cannon C000116 | rep | UT | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37971 | 37971 | Julia Carson C000191 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
37982 | 37982 | Robert Cramer C000868 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37989 | 37989 | Barbara Cubin C000962 | rep | WY | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
37994 | 37994 | Jo Ann Davis D000597 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
38001 | 38001 | Thomas Davis D000136 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
38010 | 38010 | John Doolittle D000429 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38022 | 38022 | Philip English E000187 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 21 | |||||||||||||
38034 | 38034 | Terry Everett E000268 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
38041 | 38041 | Michael Ferguson F000443 | rep | NJ | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
38049 | 38049 | Vito Fossella F000440 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 13 | |||||||||||||
38058 | 38058 | Wayne Gilchrest G000180 | rep | MD | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
38068 | 38068 | Paul Gillmor G000210 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
38074 | 38074 | Virgil Goode G000280 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 5 | [ { "start": "2001-01-03", "end": "2002-08-01", "party": "Independent" }, { "start": "2002-08-01", "end": "2003-01-03", "party": "Republican" } ] |
||||||||||||
38085 | 38085 | J. Hastert H000323 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 14 | |||||||||||||
38090 | 38090 | Robin Hayes H001029 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
38099 | 38099 | David Hobson H000666 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
38105 | 38105 | Darlene Hooley H000762 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38111 | 38111 | Kenny Hulshof H000948 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 9 | |||||||||||||
38125 | 38125 | Duncan Hunter H000981 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 52 | |||||||||||||
38134 | 38134 | William Jefferson J000070 | rep | LA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
38141 | 38141 | Stephanie Jones J000284 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
38145 | 38145 | Ric Keller K000361 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
38162 | 38162 | Joseph Knollenberg K000288 | rep | MI | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
38171 | 38171 | Ray LaHood L000552 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 18 | |||||||||||||
38177 | 38177 | Nicholas Lampson L000043 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38190 | 38190 | Tom Lantos L000090 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
38198 | 38198 | Ron Lewis L000293 | rep | KY | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
38222 | 38222 | James McCrery M000388 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38232 | 38232 | Michael McNulty M000590 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 21 | |||||||||||||
38240 | 38240 | Martin Meehan M000627 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38247 | 38247 | Juanita Millender-McDonald M000714 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 37 | |||||||||||||
38257 | 38257 | Charles Norwood N000159 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 10 | |||||||||||||
38263 | 38263 | John Peterson P000263 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
38269 | 38269 | Charles Pickering P000323 | rep | MS | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
38280 | 38280 | Deborah Pryce P000555 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 15 | |||||||||||||
38289 | 38289 | James Ramstad R000033 | rep | MN | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
38307 | 38307 | Ralph Regula R000141 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 16 | |||||||||||||
38315 | 38315 | Thomas Reynolds R000569 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 27 | |||||||||||||
38329 | 38329 | H. Saxton S000097 | rep | NJ | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
38340 | 38340 | Christopher Shays S001144 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38345 | 38345 | Thomas Tancredo T000458 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
38361 | 38361 | James Walsh W000099 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 25 | |||||||||||||
38368 | 38368 | David Weldon W000267 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 15 | |||||||||||||
38375 | 38375 | Gerald Weller W000273 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
38381 | 38381 | Heather Wilson W000789 | rep | NM | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
38389 | 38389 | Albert Wynn W000784 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
38400 | 38400 | Neil Abercrombie A000014 | rep | HI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38409 | 38409 | Brian Baird B001229 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
38423 | 38423 | Robert Berry B000420 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38432 | 38432 | Joseph Biden B000444 | sen | DE | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
38445 | 38445 | Frederick Boucher B000657 | rep | VA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38452 | 38452 | Allen Boyd B000716 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
38458 | 38458 | Henry Brown B001235 | rep | SC | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
38471 | 38471 | Stephen Buyer B001203 | rep | IN | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
38483 | 38483 | Michael Castle C000243 | rep | DE | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
38503 | 38503 | Nathan Deal D000168 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 9 |
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);