legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
488 rows where "end" is on date 1943-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
start (date) 11 ✖
- 1941-01-03 457
- 1937-01-05 21
- 1942-01-01 2
- 1937-04-15 1
- 1939-01-03 1
- 1939-10-10 1
- 1940-01-01 1
- 1940-01-27 1
- 1940-10-14 1
- 1941-01-13 1
- 1941-04-01 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25114 | 25114 | Asa Allen A000114 | rep | LA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
26696 | 26696 | Leo Allen A000138 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 13 | |||||||||||||
27076 | 27076 | Herman Andersen A000179 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
28757 | 28757 | Clinton Anderson A000186 | rep | NM | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
25121 | 25121 | John Anderson A000196 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
30141 | 30141 | Leslie Arends A000216 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
26169 | 26169 | August Andresen A000239 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
24257 | 24257 | Walter Andrews A000250 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 40 | |||||||||||||
25578 | 25578 | Homer Angell A000257 | rep | OR | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
22851 | 22851 | Laurence Arnold A000290 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 23 | |||||||||||||
23342 | 23342 | Josiah Bailey B000046 | sen | NC | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23767 | 23767 | Joseph Baldwin B000093 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23344 | 23344 | Joseph Ball B000099 | sen | MN | 1940-10-14 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23347 | 23347 | John Bankhead B000111 | sen | AL | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22855 | 22855 | Walter Bankhead B000112 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
26711 | 26711 | Graham Barden B000139 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
22860 | 22860 | James Barnes B000158 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23773 | 23773 | William Barry B000191 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
24734 | 24734 | George Bates B000232 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
25132 | 25132 | Joseph Bates B000237 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
26722 | 26722 | Albert Baumhart B000245 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 13 | |||||||||||||
22866 | 22866 | Harry Beam B000274 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
28318 | 28318 | Lindley Beckworth B000296 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
22870 | 22870 | Alfred Beiter B000320 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 41 | |||||||||||||
24268 | 24268 | Charles Bell B000332 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25848 | 25848 | George Bender B000356 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
22871 | 22871 | Philip Bennett B000380 | rep | MO | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
25594 | 25594 | Cecil Bishop B000486 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 25 | |||||||||||||
25140 | 25140 | William Blackney B000515 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
24754 | 24754 | Schuyler Bland B000545 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
24768 | 24768 | Sol Bloom B000565 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
22879 | 22879 | John Boehne B000588 | rep | IN | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
29609 | 29609 | Thomas Boggs B000594 | rep | LA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
22885 | 22885 | Patrick Boland B000601 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
22886 | 22886 | Veronica Boland B000602 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
22888 | 22888 | Stephen Bolles B000604 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
28788 | 28788 | Frances Bolton B000607 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 22 | |||||||||||||
28330 | 28330 | Herbert Bonner B000621 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23779 | 23779 | Lyle Boren B000640 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
27113 | 27113 | Frank Boykin B000725 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
24276 | 24276 | Frederick Bradley B000742 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
23784 | 23784 | Michael Bradley B000743 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
25880 | 25880 | Henry Bridges B000823 | sen | NH | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
23349 | 23349 | Charles Brooks B000874 | sen | IL | 1940-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
27129 | 27129 | Overton Brooks B000884 | rep | LA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
28344 | 28344 | Clarence Brown B000909 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
26752 | 26752 | Paul Brown B000940 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
22014 | 22014 | Prentiss Brown B000941 | sen | MI | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
25609 | 25609 | Joseph Bryson B000999 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
22893 | 22893 | Frank Buck B001017 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
22897 | 22897 | Richard Buckler B001023 | rep | MN | 1941-01-03 | 1943-01-03 | Farmer-Labor | 9 | |||||||||||||
27666 | 27666 | Charles Buckley B001024 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 23 | |||||||||||||
22076 | 22076 | William Bulow B001055 | sen | SD | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
24784 | 24784 | Alfred Bulwinkle B001056 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
24238 | 24238 | Thomas Burch B001069 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
26192 | 26192 | Usher Burdick B001079 | rep | ND | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
23794 | 23794 | William Burgin B001084 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
25166 | 25166 | John Butler B001179 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 42 | |||||||||||||
25173 | 25173 | William Byrne B001214 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 28 | |||||||||||||
25625 | 25625 | Albert Camp C000070 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
26782 | 26782 | Gordon Canfield C000113 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23799 | 23799 | Arthur Cannon C000115 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
27688 | 27688 | Clarence Cannon C000117 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
23354 | 23354 | Louis Capozzoli C000132 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
23359 | 23359 | Arthur Capper C000133 | sen | KS | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
27703 | 27703 | Frank Carlson C000154 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
23370 | 23370 | Albert Carter C000195 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
22909 | 22909 | Wilburn Cartwright C000207 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
26216 | 26216 | Francis Case C000221 | rep | SD | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
22913 | 22913 | Joseph Casey C000225 | rep | MA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
29680 | 29680 | Emanuel Celler C000264 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
23372 | 23372 | Albert Chandler C000290 | sen | KY | 1939-10-10 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
24798 | 24798 | Virgil Chapman C000317 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
27710 | 27710 | John Chenoweth C000346 | rep | CO | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
27143 | 27143 | Robert Chiperfield C000365 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
24300 | 24300 | Jerome Clark C000439 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
24306 | 24306 | Charles Clason C000473 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
22916 | 22916 | Harold Claypool C000489 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
26229 | 26229 | Cliff Clevenger C000515 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
22919 | 22919 | Ernest Cluett C000535 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 29 | |||||||||||||
23811 | 23811 | John Cochran C000565 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
22923 | 22923 | Harry Coffee C000582 | rep | NE | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23816 | 23816 | John Coffee C000584 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
22930 | 22930 | William Cole C000616 | rep | MD | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
26241 | 26241 | William Cole C000617 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 37 | |||||||||||||
22940 | 22940 | Ross Collins C000642 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
29700 | 29700 | William Colmer C000645 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
22943 | 22943 | Lawrence Connery C000693 | rep | MA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
28377 | 28377 | Harold Cooley C000736 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
26256 | 26256 | Jere Cooper C000755 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
22944 | 22944 | Oren Copeland C000768 | rep | NE | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23378 | 23378 | John Costello C000795 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
24324 | 24324 | William Courtney C000810 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
25197 | 25197 | Edward Cox C000831 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
24329 | 24329 | William Cravens C000887 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25206 | 25206 | Fred Crawford C000889 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23383 | 23383 | Edward Creal C000898 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25651 | 25651 | Robert Crosser C000932 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
22956 | 22956 | Frank Crowther C000948 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 30 | |||||||||||||
23392 | 23392 | Francis Culkin C000968 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 32 |
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);