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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29639 | 29639 | James Buckley B001026 | sen | NY | 1971-01-21 | 1977-01-03 | 1 | Conservative | |||||||||||||
29523 | 29523 | Watkins Abbitt A000002 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
29538 | 29538 | Thomas Abernethy A000016 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
29542 | 29542 | William Anderson A000203 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29543 | 29543 | Elizabeth Andrews A000205 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29558 | 29558 | George Andrews A000206 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29570 | 29570 | Wayne Aspinall A000225 | rep | CO | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
29580 | 29580 | Walter Baring B000141 | rep | NV | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
29583 | 29583 | Nicholas Begich B000315 | rep | AK | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
29608 | 29608 | Leonard Blanton B000548 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29622 | 29622 | Thomas Boggs B000594 | rep | LA | 1971-01-21 | 1972-10-16 | Democrat | 2 | |||||||||||||
29649 | 29649 | James Byrne B001212 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29667 | 29667 | Earle Cabell C000002 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29669 | 29669 | Patrick Caffery C000017 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29695 | 29695 | Emanuel Celler C000264 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
29715 | 29715 | William Colmer C000645 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29732 | 29732 | William Curlin C000997 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29737 | 29737 | John Dow D000462 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 27 | |||||||||||||
29748 | 29748 | John Dowdy D000467 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29766 | 29766 | Edmond Edmondson E000054 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29770 | 29770 | Edwin Edwards E000067 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29792 | 29792 | Nick Galifianakis G000015 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
29799 | 29799 | Cornelius Gallagher G000016 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
29813 | 29813 | Edward Garmatz G000071 | rep | MD | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29816 | 29816 | Charles Griffin G000458 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29822 | 29822 | George Hagan H000010 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
29838 | 29838 | Philip Hart H000291 | sen | MI | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29841 | 29841 | Rupert Hartke H000297 | sen | IN | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29842 | 29842 | Louise Hicks H000566 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
29856 | 29856 | William Hull H000947 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29870 | 29870 | James Kee K000038 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29892 | 29892 | Alton Lennon L000240 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29893 | 29893 | Arthur Link L000333 | rep | ND | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29901 | 29901 | Speedy Long L000429 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
29910 | 29910 | Michael Mansfield M000113 | sen | MT | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29929 | 29929 | Gale McGee M000445 | sen | WY | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29947 | 29947 | John McMillan M000568 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29961 | 29961 | George Miller M000727 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
29968 | 29968 | John Monagan M000847 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29975 | 29975 | Joseph Montoya M000876 | sen | NM | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29989 | 29989 | Frank Moss M001033 | sen | UT | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
30009 | 30009 | John Pastore P000100 | sen | RI | 1971-01-21 | 1976-12-28 | 1 | Democrat | |||||||||||||
30043 | 30043 | Roman Pucinski P000559 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
30049 | 30049 | Graham Purcell P000569 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
30060 | 30060 | William Ryan R000562 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
30104 | 30104 | William Symington S001136 | sen | MO | 1971-01-21 | 1976-12-27 | 1 | Democrat | |||||||||||||
30116 | 30116 | John Tunney T000410 | sen | CA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
30127 | 30127 | John Watts W000212 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30136 | 30136 | James Abourezk A000017 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30177 | 30177 | John Blatnik B000550 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
30181 | 30181 | Frank Brasco B000771 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
30221 | 30221 | Hugh Carey C000143 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
30249 | 30249 | Frank Clark C000431 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 25 | |||||||||||||
30262 | 30262 | George Collins C000637 | rep | IL | 1971-01-21 | 1972-12-08 | Democrat | 6 | |||||||||||||
30291 | 30291 | John Davis D000122 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
30297 | 30297 | Frank Denholm D000234 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30314 | 30314 | Harold Donohue D000419 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30327 | 30327 | William Dorn D000434 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30335 | 30335 | Thaddeus Dulski D000523 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 41 | |||||||||||||
30358 | 30358 | Ovie Fisher F000152 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
30376 | 30376 | Thomas Gettys G000144 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30384 | 30384 | Ella Grasso G000387 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30394 | 30394 | Edith Green G000407 | rep | OR | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30412 | 30412 | Martha Griffiths G000471 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
30449 | 30449 | Richard Hanna H000164 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 34 | |||||||||||||
30460 | 30460 | Julia Hansen H000174 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30476 | 30476 | William Hathaway H000346 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30495 | 30495 | Chester Holifield H000713 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
30529 | 30529 | Peter Kyros K000356 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30613 | 30613 | Bertram Podell P000399 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
30623 | 30623 | John Rarick R000065 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30629 | 30629 | Ogden Reid R000150 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 26 | [ { "start": "1971-01-21", "end": "1972-03-22", "party": "Republican" }, { "start": "1972-03-22", "end": "1973-01-03", "party": "Democrat" } ] |
||||||||||||
30655 | 30655 | John Rooney R000424 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30657 | 30657 | William Roy R000484 | rep | KS | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30714 | 30714 | Frank Stubblefield S001037 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30735 | 30735 | Robert Tiernan T000265 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30743 | 30743 | Jerome Waldie W000035 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30800 | 30800 | Bella Abzug A000018 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
30815 | 30815 | Carl Albert A000073 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30832 | 30832 | William Barrett B000178 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30861 | 30861 | Robert Casey C000228 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
30889 | 30889 | John Culver C000979 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30898 | 30898 | Dominick Daniels D000041 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30907 | 30907 | Thomas Downing D000474 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
30949 | 30949 | William Green G000420 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30966 | 30966 | James Haley H000041 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
30986 | 30986 | Wayne Hays H000408 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 18 | |||||||||||||
30995 | 30995 | Kenneth Hechler H000438 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31001 | 31001 | Henry Helstoski H000465 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31009 | 31009 | David Henderson H000479 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31015 | 31015 | Floyd Hicks H000563 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31025 | 31025 | William Hungate H000965 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31050 | 31050 | Felix Hébert H000437 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31063 | 31063 | John Jarman J000057 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31093 | 31093 | Robert Jones J000248 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
31102 | 31102 | Joseph Karth K000014 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31115 | 31115 | John Kluczynski K000273 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31127 | 31127 | Phillip Landrum L000054 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 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);