legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2001-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37141 | 37141 | Norman Sisisky S000453 | rep | VA | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
37152 | 37152 | Joseph Skeen S000463 | rep | NM | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37168 | 37168 | Floyd Spence S000718 | rep | SC | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37181 | 37181 | Robert Stump S001044 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37186 | 37186 | Karen Thurman T000253 | rep | FL | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37195 | 37195 | James Traficant T000350 | rep | OH | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
37200 | 37200 | Robert Underwood U000014 | rep | GU | 1999-01-06 | 2001-01-03 | Democrat | 0 | |||||||||||||
37210 | 37210 | Wes Watkins W000194 | rep | OK | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37214 | 37214 | J.C. Watts W000210 | rep | OK | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
37220 | 37220 | James Talent T000024 | rep | MO | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37237 | 37237 | Cass Ballenger B000104 | rep | NC | 1999-01-06 | 2001-01-03 | Republican | 10 | |||||||||||||
37251 | 37251 | Douglas Bereuter B000403 | rep | NE | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37261 | 37261 | Michael Collins C000640 | rep | GA | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37271 | 37271 | Larry Combest C000653 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 19 | |||||||||||||
37297 | 37297 | Philip Crane C000873 | rep | IL | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37303 | 37303 | Peter Deutsch D000275 | rep | FL | 1999-01-06 | 2001-01-03 | Democrat | 20 | |||||||||||||
37317 | 37317 | Calvin Dooley D000424 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 20 | |||||||||||||
37323 | 37323 | Jennifer Dunn D000549 | rep | WA | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37326 | 37326 | Ernest Fletcher F000441 | rep | KY | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37339 | 37339 | Jonas Frost F000392 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 24 | |||||||||||||
37353 | 37353 | Richard Gephardt G000132 | rep | MO | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
37361 | 37361 | Porter Goss G000336 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 14 | |||||||||||||
37367 | 37367 | James Greenwood G000439 | rep | PA | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37372 | 37372 | Joseph Hoeffel H001031 | rep | PA | 1999-01-06 | 2001-01-03 | Democrat | 13 | |||||||||||||
37381 | 37381 | Amory Houghton H000814 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 31 | |||||||||||||
37386 | 37386 | Christopher John J000110 | rep | LA | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
37397 | 37397 | Gerald Kleczka K000259 | rep | WI | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
37408 | 37408 | William Lipinski L000342 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
37411 | 37411 | Kenneth Lucas L000558 | rep | KY | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
37425 | 37425 | Robert Matsui M000249 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37430 | 37430 | Karen McCarthy M000316 | rep | MO | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37436 | 37436 | Scott McInnis M000477 | rep | CO | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37441 | 37441 | George Nethercutt N000051 | rep | WA | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
37444 | 37444 | Doug Ose O000164 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37450 | 37450 | Jack Quinn Q000016 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 30 | |||||||||||||
37454 | 37454 | Max Sandlin S000044 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
37464 | 37464 | Nick Smith S000597 | rep | MI | 1999-01-06 | 2001-01-03 | Republican | 7 | |||||||||||||
37477 | 37477 | Charles Stenholm S000851 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
37488 | 37488 | John Sununu S001078 | rep | NH | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37501 | 37501 | William Tauzin T000058 | rep | LA | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37505 | 37505 | James Turner T000424 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
37528 | 37528 | Michael Bilirakis B000463 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 9 | |||||||||||||
37540 | 37540 | Sherwood Boehlert B000586 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 23 | |||||||||||||
37551 | 37551 | Henry Bonilla B000617 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 23 | |||||||||||||
37576 | 37576 | C. Cox C000830 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 47 | |||||||||||||
37584 | 37584 | Randall Cunningham C000994 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 51 | |||||||||||||
37589 | 37589 | James Davis D000114 | rep | FL | 1999-01-06 | 2001-01-03 | Democrat | 11 | |||||||||||||
37600 | 37600 | Thomas DeLay D000217 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 22 | |||||||||||||
37630 | 37630 | Lane Evans E000250 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
37639 | 37639 | Mark Foley F000238 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 16 | |||||||||||||
37644 | 37644 | Harold Ford F000262 | rep | TN | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
37649 | 37649 | James Gibbons G000152 | rep | NV | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37653 | 37653 | Mark Green G000545 | rep | WI | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37666 | 37666 | Gilbert Gutknecht G000536 | rep | MN | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37677 | 37677 | John Hayworth H000413 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37687 | 37687 | Joel Hefley H000444 | rep | CO | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
37693 | 37693 | John Hostettler H000807 | rep | IN | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37709 | 37709 | Henry Hyde H001022 | rep | IL | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37716 | 37716 | Ernest Istook I000047 | rep | OK | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
37721 | 37721 | William Jenkins J000082 | rep | TN | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37733 | 37733 | Nancy Johnson J000163 | rep | CT | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37739 | 37739 | Sue Kelly K000078 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 19 | |||||||||||||
37753 | 37753 | James Kolbe K000306 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
37768 | 37768 | James Leach L000169 | rep | IA | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37780 | 37780 | Cynthia McKinney M000523 | rep | GA | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
37785 | 37785 | Robert Ney N000081 | rep | OH | 1999-01-06 | 2001-01-03 | Republican | 18 | |||||||||||||
37790 | 37790 | Anne Northup N000143 | rep | KY | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37798 | 37798 | James Nussle N000172 | rep | IA | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37816 | 37816 | Major Owens O000159 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 11 | |||||||||||||
37829 | 37829 | Michael Oxley O000163 | rep | OH | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
37836 | 37836 | Richard Pombo P000419 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 11 | |||||||||||||
37842 | 37842 | Jim Ryun R000566 | rep | KS | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37856 | 37856 | Martin Sabo S000005 | rep | MN | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37871 | 37871 | E. Shaw S000303 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 22 | |||||||||||||
37875 | 37875 | Donald Sherwood S001146 | rep | PA | 1999-01-06 | 2001-01-03 | Republican | 10 | |||||||||||||
37890 | 37890 | Ted Strickland S001004 | rep | OH | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
37894 | 37894 | John Sweeney S001149 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 22 | |||||||||||||
37902 | 37902 | Charles Taylor T000067 | rep | NC | 1999-01-06 | 2001-01-03 | Republican | 11 | |||||||||||||
37916 | 37916 | William Thomas T000188 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 21 | |||||||||||||
37928 | 37928 | W. Weldon W000268 | rep | PA | 1999-01-06 | 2001-01-03 | Republican | 7 | |||||||||||||
37934 | 37934 | Thomas Allen A000357 | rep | ME | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
37945 | 37945 | Richard Baker B000072 | rep | LA | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37960 | 37960 | Robert Byrd B001210 | sen | WV | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
37964 | 37964 | Christopher Cannon C000116 | rep | UT | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37970 | 37970 | Julia Carson C000191 | rep | IN | 1999-01-06 | 2001-01-03 | Democrat | 10 | |||||||||||||
37981 | 37981 | Robert Cramer C000868 | rep | AL | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37988 | 37988 | Barbara Cubin C000962 | rep | WY | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
38000 | 38000 | Thomas Davis D000136 | rep | VA | 1999-01-06 | 2001-01-03 | Republican | 11 | |||||||||||||
38009 | 38009 | John Doolittle D000429 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
38021 | 38021 | Philip English E000187 | rep | PA | 1999-01-06 | 2001-01-03 | Republican | 21 | |||||||||||||
38033 | 38033 | Terry Everett E000268 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
38048 | 38048 | Vito Fossella F000440 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 13 | |||||||||||||
38057 | 38057 | Wayne Gilchrest G000180 | rep | MD | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
38067 | 38067 | Paul Gillmor G000210 | rep | OH | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
38073 | 38073 | Virgil Goode G000280 | rep | VA | 1999-01-06 | 2001-01-03 | Independent | 5 | [ { "start": "1999-01-06", "end": "2000-01-27", "party": "Democrat" }, { "start": "2000-01-27", "end": "2001-01-03", "party": "Independent" } ] |
||||||||||||
38084 | 38084 | J. Hastert H000323 | rep | IL | 1999-01-06 | 2001-01-03 | Republican | 14 | |||||||||||||
38089 | 38089 | Robin Hayes H001029 | rep | NC | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
38098 | 38098 | David Hobson H000666 | rep | OH | 1999-01-06 | 2001-01-03 | Republican | 7 | |||||||||||||
38104 | 38104 | Darlene Hooley H000762 | rep | OR | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
38110 | 38110 | Kenny Hulshof H000948 | rep | MO | 1999-01-06 | 2001-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);