legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1971-01-21 sorted by state descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29929 | 29929 | Gale McGee M000445 | sen | WY | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31765 | 31765 | Teno Roncalio R000421 | rep | WY | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
29870 | 29870 | James Kee K000038 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30995 | 30995 | Kenneth Hechler H000438 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32289 | 32289 | John Slack S000473 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32309 | 32309 | Harley Staggers S000778 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32784 | 32784 | Robert Mollohan M000845 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
37956 | 37956 | Robert Byrd B001210 | sen | WV | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29663 | 29663 | John Byrnes B001216 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30004 | 30004 | Alvin O’Konski O000058 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30284 | 30284 | Glenn Davis D000102 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30731 | 30731 | Vernon Thomson T000233 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
31842 | 31842 | William Steiger S000847 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
32817 | 32817 | Henry Reuss R000165 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
33114 | 33114 | William Proxmire P000553 | sen | WI | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
33202 | 33202 | Clement Zablocki Z000001 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
33964 | 33964 | Robert Kastenmeier K000020 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
35108 | 35108 | Leslie Aspin A000224 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
38731 | 38731 | David Obey O000007 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
30019 | 30019 | Thomas Pelly P000196 | rep | WA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30460 | 30460 | Julia Hansen H000174 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31015 | 31015 | Floyd Hicks H000563 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31662 | 31662 | Lloyd Meeds M000626 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32161 | 32161 | Mike McCormack M000365 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
33008 | 33008 | Henry Jackson J000013 | sen | WA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
33473 | 33473 | Brockman Adams A000031 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
35248 | 35248 | Thomas Foley F000239 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30545 | 30545 | Richard Mallary M000078 | rep | VT | 1971-01-21 | 1973-01-03 | Republican | 0 | |||||||||||||
33151 | 33151 | Robert Stafford S000776 | rep | VT | 1971-01-21 | 1971-09-16 | Republican | 0 | |||||||||||||
29523 | 29523 | Watkins Abbitt A000002 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30036 | 30036 | Richard Poff P000401 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30211 | 30211 | Joel Broyhill B000967 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30685 | 30685 | William Scott S000189 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30907 | 30907 | Thomas Downing D000474 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31470 | 31470 | Harry Byrd B001209 | sen | VA | 1971-01-21 | 1977-01-03 | 1 | Independent | |||||||||||||
32272 | 32272 | David Satterfield S000070 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32542 | 32542 | Manley Butler B001182 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
32874 | 32874 | William Wampler W000121 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
33120 | 33120 | James Robinson R000337 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
33435 | 33435 | George Whitehurst W000406 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
33544 | 33544 | Wilbur Daniel D000038 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29897 | 29897 | Sherman Lloyd L000382 | rep | UT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
29989 | 29989 | Frank Moss M001033 | sen | UT | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
32174 | 32174 | Koln McKay M000490 | rep | UT | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
29667 | 29667 | Earle Cabell C000002 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29748 | 29748 | John Dowdy D000467 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30049 | 30049 | Graham Purcell P000569 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
30358 | 30358 | Ovie Fisher F000152 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
30619 | 30619 | Robert Price P000528 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
30861 | 30861 | Robert Casey C000228 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
31273 | 31273 | John Patman P000103 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31465 | 31465 | Omar Burleson B001111 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
31639 | 31639 | George Mahon M000065 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
31735 | 31735 | William Poage P000398 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
31859 | 31859 | Olin Teague T000110 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31909 | 31909 | John Young Y000043 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
32051 | 32051 | Robert Eckhardt E000035 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
32258 | 32258 | Herbert Roberts R000312 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32568 | 32568 | James Collins C000638 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
32884 | 32884 | Richard White W000390 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
33013 | 33013 | Abraham Kazen K000025 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 23 | |||||||||||||
33818 | 33818 | Lloyd Bentsen B000401 | sen | TX | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
34150 | 34150 | James Wright W000763 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
35144 | 35144 | Jack Brooks B000880 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
35512 | 35512 | James Pickle P000328 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
36119 | 36119 | Eligio de la Garza D000203 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
36208 | 36208 | Henry González G000272 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
36472 | 36472 | Bill Archer A000215 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
29542 | 29542 | William Anderson A000203 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29608 | 29608 | Leonard Blanton B000548 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29638 | 29638 | William Brock B000851 | sen | TN | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
30158 | 30158 | LaMar Baker B000069 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30525 | 30525 | Dan Kuykendall K000348 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30933 | 30933 | Joseph Evins E000273 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30940 | 30940 | Richard Fulton F000424 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
33569 | 33569 | John Duncan D000534 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
33613 | 33613 | Ed Jones J000216 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
35979 | 35979 | James Quillen Q000013 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30136 | 30136 | James Abourezk A000017 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30297 | 30297 | Frank Denholm D000234 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
29947 | 29947 | John McMillan M000568 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30327 | 30327 | William Dorn D000434 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30376 | 30376 | Thomas Gettys G000144 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31644 | 31644 | James Mann M000105 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32010 | 32010 | Mendel Davis D000125 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
37154 | 37154 | Floyd Spence S000718 | rep | SC | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30009 | 30009 | John Pastore P000100 | sen | RI | 1971-01-21 | 1976-12-28 | 1 | Democrat | |||||||||||||
30735 | 30735 | Robert Tiernan T000265 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
33753 | 33753 | Fernand St. Germain S000762 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
29734 | 29734 | Jorge Córdova Díaz C000775 | rep | PR | 1971-01-21 | 1973-01-03 | New Progressive | 0 | |||||||||||||
29649 | 29649 | James Byrne B001212 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29716 | 29716 | William Conover C000702 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 27 | |||||||||||||
29731 | 29731 | Robert Corbett C000772 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
29789 | 29789 | James Fulton F000422 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 27 | |||||||||||||
30081 | 30081 | Hugh Scott S000174 | sen | PA | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
30134 | 30134 | John Whalley W000320 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
30249 | 30249 | Frank Clark C000431 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 25 | |||||||||||||
30382 | 30382 | George Goodling G000290 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 19 | |||||||||||||
30677 | 30677 | John Saylor S000102 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 22 | |||||||||||||
30746 | 30746 | John Ware W000147 | rep | PA | 1971-01-21 | 1973-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);