legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, start (date)
start 7 ✖
- 1961-01-03 452
- 1957-01-03 31
- 1959-01-07 2
- 1960-09-23 1
- 1960-12-27 1
- 1961-12-07 1
- 1962-07-09 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29533 | 29533 | Thomas Abernethy A000016 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29108 | 29108 | Edwin Adair A000024 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
33212 | 33212 | Joseph Addabbo A000052 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27067 | 27067 | Hugh Addonizio A000054 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
29116 | 29116 | George Aiken A000062 | sen | VT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
30810 | 30810 | Carl Albert A000073 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27072 | 27072 | Hugh Alexander A000094 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
27074 | 27074 | Thomas Alford A000105 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27606 | 27606 | Bruce Alger A000106 | rep | TX | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27086 | 27086 | Herman Andersen A000179 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
31920 | 31920 | John Anderson A000195 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
29553 | 29553 | George Andrews A000206 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30151 | 30151 | Leslie Arends A000216 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 17 | |||||||||||||
32446 | 32446 | John Ashbrook A000221 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 17 | |||||||||||||
31933 | 31933 | Thomas Ashley A000222 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28768 | 28768 | Robert Ashmore A000223 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29565 | 29565 | Wayne Aspinall A000225 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27617 | 27617 | James Auchincloss A000227 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27622 | 27622 | William Avery A000228 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29124 | 29124 | William Ayres A000229 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
27091 | 27091 | Victor Anfuso A000255 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27099 | 27099 | Cleveland Bailey B000035 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27629 | 27629 | Howard Baker B000062 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28313 | 28313 | John Baldwin B000092 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
29575 | 29575 | Walter Baring B000141 | rep | NV | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
30827 | 30827 | William Barrett B000178 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27633 | 27633 | Robert Barry B000190 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 27 | |||||||||||||
27103 | 27103 | Perkins Bass B000222 | rep | NH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28305 | 28305 | Ross Bass B000223 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29135 | 29135 | William Bates B000239 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
29140 | 29140 | James Battin B000241 | rep | MT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27639 | 27639 | Frank Becker B000292 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28326 | 28326 | Lindley Beckworth B000296 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27641 | 27641 | Ralph Beermann B000310 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
29589 | 29589 | Page Belcher B000323 | rep | OK | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30838 | 30838 | Alphonzo Bell B000330 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
34239 | 34239 | Charles Bennett B000371 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27651 | 27651 | John Bennett B000377 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
29146 | 29146 | Wallace Bennett B000384 | sen | UT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29154 | 29154 | Ellis Berry B000416 | rep | SD | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29600 | 29600 | Jackson Betts B000426 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
29160 | 29160 | Alan Bible B000436 | sen | NV | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
30172 | 30172 | John Blatnik B000550 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27109 | 27109 | Iris Blitch B000561 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29617 | 29617 | Thomas Boggs B000594 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
33498 | 33498 | Edward Boland B000600 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32495 | 32495 | Richard Bolling B000605 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28798 | 28798 | Frances Bolton B000607 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 22 | |||||||||||||
28340 | 28340 | Herbert Bonner B000621 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27599 | 27599 | Joseph Bottum B000656 | sen | SD | 1962-07-09 | 1963-01-03 | 3 | Republican | appointment | ||||||||||||
29628 | 29628 | Frank Bow B000676 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
27123 | 27123 | Frank Boykin B000725 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
31957 | 31957 | John Brademas B000736 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30188 | 30188 | William Bray B000778 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
27126 | 27126 | James Breeding B000791 | rep | KS | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27657 | 27657 | Daniel Brewster B000813 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27659 | 27659 | James Bromwell B000867 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
35139 | 35139 | Jack Brooks B000880 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27139 | 27139 | Overton Brooks B000884 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
34267 | 34267 | William Broomfield B000890 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 18 | |||||||||||||
28354 | 28354 | Clarence Brown B000909 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
30206 | 30206 | Joel Broyhill B000967 | rep | VA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27661 | 27661 | Donald Bruce B000969 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 11 | |||||||||||||
27676 | 27676 | Charles Buckley B001024 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 24 | |||||||||||||
27141 | 27141 | Frank Burke B001090 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31441 | 31441 | James Burke B001092 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
31460 | 31460 | Omar Burleson B001111 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 17 | |||||||||||||
26200 | 26200 | Prescott Bush B001167 | sen | CT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26202 | 26202 | John Butler B001180 | sen | MD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29644 | 29644 | James Byrne B001212 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29658 | 29658 | John Byrnes B001216 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
29170 | 29170 | William Cahill C000019 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27698 | 27698 | Clarence Cannon C000117 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
30216 | 30216 | Hugh Carey C000143 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
27708 | 27708 | Frank Carlson C000154 | sen | KS | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26213 | 26213 | John Carroll C000189 | sen | CO | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
26222 | 26222 | Francis Case C000221 | sen | SD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
30856 | 30856 | Robert Casey C000228 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 22 | |||||||||||||
31490 | 31490 | Elford Cederberg C000263 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
29690 | 29690 | Emanuel Celler C000264 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
30234 | 30234 | Charles Chamberlain C000275 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28369 | 28369 | Frank Chelf C000342 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27719 | 27719 | John Chenoweth C000346 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27153 | 27153 | Robert Chiperfield C000365 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 19 | |||||||||||||
30864 | 30864 | Frank Church C000388 | sen | ID | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27159 | 27159 | Marguerite Church C000389 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
30868 | 30868 | Donald Clancy C000409 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
30244 | 30244 | Frank Clark C000431 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 25 | |||||||||||||
27721 | 27721 | Joseph Clark C000444 | sen | PA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27162 | 27162 | Merwin Coad C000540 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29176 | 29176 | Jeffery Cohelan C000596 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
30254 | 30254 | Harold Collier C000629 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
29710 | 29710 | William Colmer C000645 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
34326 | 34326 | Silvio Conte C000709 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27164 | 27164 | Robert Cook C000725 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
28387 | 28387 | Harold Cooley C000736 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29726 | 29726 | Robert Corbett C000772 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 29 | |||||||||||||
32000 | 32000 | James Corman C000780 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 22 |
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);