legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
493 rows where "end" is on date 1945-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29524 | 29524 | Thomas Abernethy A000016 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
29113 | 29113 | George Aiken A000062 | sen | VT | 1941-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
25115 | 25115 | Asa Allen A000114 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
26697 | 26697 | Leo Allen A000138 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
27077 | 27077 | Herman Andersen A000179 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
28758 | 28758 | Clinton Anderson A000186 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25122 | 25122 | John Anderson A000196 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
29544 | 29544 | George Andrews A000206 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
30142 | 30142 | Leslie Arends A000216 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
27608 | 27608 | James Auchincloss A000227 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26170 | 26170 | August Andresen A000239 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24258 | 24258 | Walter Andrews A000250 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 40 | |||||||||||||
25579 | 25579 | Homer Angell A000257 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24261 | 24261 | Samuel Arnold A000296 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
26712 | 26712 | Graham Barden B000139 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25876 | 25876 | Alben Barkley B000145 | sen | KY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25585 | 25585 | Frank Barrett B000176 | rep | WY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23774 | 23774 | William Barry B000191 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24735 | 24735 | George Bates B000232 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25133 | 25133 | Joseph Bates B000237 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
26726 | 26726 | James Beall B000271 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
28319 | 28319 | Lindley Beckworth B000296 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24269 | 24269 | Charles Bell B000332 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25849 | 25849 | George Bender B000356 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
27643 | 27643 | John Bennett B000377 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
24272 | 24272 | Marion Bennett B000379 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25595 | 25595 | Cecil Bishop B000486 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 25 | |||||||||||||
25141 | 25141 | William Blackney B000515 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24755 | 24755 | Schuyler Bland B000545 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24769 | 24769 | Sol Bloom B000565 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
28789 | 28789 | Frances Bolton B000607 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
28331 | 28331 | Herbert Bonner B000621 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23780 | 23780 | Lyle Boren B000640 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
27114 | 27114 | Frank Boykin B000725 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24277 | 24277 | Frederick Bradley B000742 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
23785 | 23785 | Michael Bradley B000743 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25150 | 25150 | Walter Brehm B000794 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
27130 | 27130 | Overton Brooks B000884 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28345 | 28345 | Clarence Brown B000909 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
26753 | 26753 | Paul Brown B000940 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
23788 | 23788 | David Brumbaugh B000976 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
25610 | 25610 | Joseph Bryson B000999 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24287 | 24287 | Ellsworth Buck B001016 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
27667 | 27667 | Charles Buckley B001024 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
25159 | 25159 | Howard Buffett B001039 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24785 | 24785 | Alfred Bulwinkle B001056 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24239 | 24239 | Thomas Burch B001069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23352 | 23352 | Thomas Burchill B001072 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
26193 | 26193 | Usher Burdick B001079 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23795 | 23795 | William Burgin B001084 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25617 | 25617 | Fred Busbey B001161 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25167 | 25167 | John Butler B001179 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 42 | |||||||||||||
25174 | 25174 | William Byrne B001214 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
25626 | 25626 | Albert Camp C000070 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26783 | 26783 | Gordon Canfield C000113 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23800 | 23800 | Arthur Cannon C000115 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
27689 | 27689 | Clarence Cannon C000117 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23355 | 23355 | Louis Capozzoli C000132 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
22517 | 22517 | Hattie Caraway C000138 | sen | AR | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
27704 | 27704 | Frank Carlson C000154 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23361 | 23361 | Chester Carrier C000181 | rep | KY | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24291 | 24291 | Henderson Carson C000192 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
23371 | 23371 | Albert Carter C000195 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
26217 | 26217 | Francis Case C000221 | rep | SD | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
29681 | 29681 | Emanuel Celler C000264 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24799 | 24799 | Virgil Chapman C000317 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
27711 | 27711 | John Chenoweth C000346 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
27144 | 27144 | Robert Chiperfield C000365 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
24807 | 24807 | Ralph Church C000390 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
22523 | 22523 | David Clark C000428 | sen | ID | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24301 | 24301 | Jerome Clark C000439 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
22525 | 22525 | Joel Clark C000440 | sen | MO | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24307 | 24307 | Charles Clason C000473 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26230 | 26230 | Cliff Clevenger C000515 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
23812 | 23812 | John Cochran C000565 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
23817 | 23817 | John Coffee C000584 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25634 | 25634 | William Cole C000614 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26242 | 26242 | William Cole C000617 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 37 | |||||||||||||
29701 | 29701 | William Colmer C000645 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23374 | 23374 | C. Compton C000661 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
28378 | 28378 | Harold Cooley C000736 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26257 | 26257 | Jere Cooper C000755 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23379 | 23379 | John Costello C000795 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
24325 | 24325 | William Courtney C000810 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
25198 | 25198 | Edward Cox C000831 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25207 | 25207 | Fred Crawford C000889 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23384 | 23384 | Edward Creal C000898 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25652 | 25652 | Robert Crosser C000932 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
23393 | 23393 | Francis Culkin C000968 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
23406 | 23406 | Thomas Cullen C000970 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26275 | 26275 | Paul Cunningham C000993 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
23821 | 23821 | James Curley C000996 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
30266 | 30266 | Carl Curtis C001006 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
22548 | 22548 | John Danaher D000025 | sen | CT | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23823 | 23823 | Ralph Daughton D000067 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
27725 | 27725 | Clifford Davis D000094 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 10 |
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);