legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1933-03-09
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22011 | 22011 | Prentiss Brown B000941 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22032 | 22032 | Robert Bacon B000019 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
22037 | 22037 | Frederick Biermann B000449 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22044 | 22044 | Gerald Boileau B000598 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
22059 | 22059 | John Boylan B000726 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
22072 | 22072 | James Buchanan B001006 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22086 | 22086 | Raymond Cannon C000124 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22092 | 22092 | Charles Colden C000605 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22100 | 22100 | William Connery C000694 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22103 | 22103 | Charles Crosby C000928 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 29 | |||||||||||||
22107 | 22107 | Braswell Deen D000187 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22111 | 22111 | John Dockweiler D000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
22123 | 22123 | William Driver D000503 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22128 | 22128 | Edward Eicher E000094 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22131 | 22131 | Henry Ellenbogen E000111 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 33 | |||||||||||||
22134 | 22134 | James Farley F000019 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22140 | 22140 | Thomas Fletcher F000205 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22150 | 22150 | Benjamin Focht F000230 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 18 | |||||||||||||
22153 | 22153 | Oliver Frey F000382 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22158 | 22158 | Claude Fuller F000408 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22166 | 22166 | Stephen Gambrill G000035 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22174 | 22174 | Allard Gasque G000092 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22182 | 22182 | Philip Goodwin G000302 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 27 | |||||||||||||
22189 | 22189 | Finly Gray G000395 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22199 | 22199 | Arthur Greenwood G000437 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22205 | 22205 | Glenn Griswold G000483 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22211 | 22211 | Franklin Hancock H000147 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22215 | 22215 | Byron Harlan H000209 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22229 | 22229 | Fred Hildebrandt H000584 | rep | SD | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22236 | 22236 | Virginia Jenckes J000077 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22241 | 22241 | Edward Kenney K000120 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22244 | 22244 | Frank Kloeb K000271 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22248 | 22248 | Frank Kniffin K000283 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22253 | 22253 | Paul Kvale K000350 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
22257 | 22257 | John Lambeth L000038 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22261 | 22261 | Arthur Lamneck L000040 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
22264 | 22264 | James Lanzetta L000091 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
22272 | 22272 | David Lewis L000277 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22286 | 22286 | Ernest Lundeen L000514 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
22293 | 22293 | William McFarlane M000440 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
22296 | 22296 | John McGrath M000457 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22301 | 22301 | James Meeks M000631 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
22305 | 22305 | Charles Millard M000709 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 25 | |||||||||||||
22309 | 22309 | John Miller M000738 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22313 | 22313 | John Mitchell M000823 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22326 | 22326 | Andrew Montague M000861 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22341 | 22341 | John O’Connell O000025 | rep | RI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22349 | 22349 | John O’Connor O000030 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
22352 | 22352 | Thomas O’Malley O000087 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22359 | 22359 | Vincent Palmisano P000046 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22367 | 22367 | Samuel Pettengill P000268 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22370 | 22370 | Theodore Peyser P000281 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22380 | 22380 | Michael Reilly R000155 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22391 | 22391 | Morgan Sanders S000037 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22425 | 22425 | Bertrand Snell S000652 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 31 | |||||||||||||
22430 | 22430 | Henry Stubbs S001038 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22434 | 22434 | John Taylor T000087 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22438 | 22438 | Chester Thompson T000197 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22445 | 22445 | Lloyd Thurston T000257 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
22454 | 22454 | Frederick Vinson V000106 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22457 | 22457 | Otha Wearin W000221 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22460 | 22460 | James Wilcox W000455 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22469 | 22469 | Alva Adams A000028 | sen | CO | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22496 | 22496 | William Bankhead B000113 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22504 | 22504 | Chester Bolton B000606 | rep | OH | 1933-03-09 | 1935-01-03 | Republican | 22 | |||||||||||||
22507 | 22507 | Homer Bone B000614 | sen | WA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22511 | 22511 | Millard Caldwell C000038 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22516 | 22516 | Hattie Caraway C000138 | sen | AR | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22524 | 22524 | Joel Clark C000440 | sen | MO | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22529 | 22529 | William Cravens C000886 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22534 | 22534 | Eugene Crowe C000940 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22538 | 22538 | Fred Cummings C000985 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22558 | 22558 | George Darrow D000063 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
22562 | 22562 | James Davis D000111 | sen | PA | 1933-03-09 | 1939-01-03 | 3 | Republican | |||||||||||||
22567 | 22567 | René De Rouen D000265 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22580 | 22580 | Cassius Dowell D000468 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
22583 | 22583 | Matthew Dunn D000551 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 34 | |||||||||||||
22595 | 22595 | Joachim Fernández F000086 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22619 | 22619 | Thomas Goldsborough G000265 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22632 | 22632 | Santiago Iglesias I000002 | rep | PR | 1933-03-09 | 1935-01-03 | Coalitionist | 0 | |||||||||||||
22645 | 22645 | John Jones J000236 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
22650 | 22650 | Kent Keller K000056 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 25 | |||||||||||||
22655 | 22655 | Ambrose Kennedy K000101 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22671 | 22671 | Robert Luce L000498 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
22684 | 22684 | Carl Mapes M000119 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
22691 | 22691 | John Martin M000186 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22711 | 22711 | Clarence McLeod M000557 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
22719 | 22719 | Thomas McMillan M000572 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22728 | 22728 | Samuel McReynolds M000598 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22736 | 22736 | Gerald Nye N000176 | sen | ND | 1933-03-09 | 1939-01-03 | 3 | Republican | |||||||||||||
22738 | 22738 | Emmett Owen O000149 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22744 | 22744 | Claude Parsons P000086 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
22771 | 22771 | George Seger S000228 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
22778 | 22778 | William Sirovich S000452 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22789 | 22789 | Ellison Smith S000530 | sen | SC | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22800 | 22800 | Christopher Sullivan S001051 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
22812 | 22812 | James Taylor T000083 | rep | TN | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
22818 | 22818 | Clarence Turner T000417 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22822 | 22822 | Frederick Van Nuys V000050 | sen | IN | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22828 | 22828 | Lindsay Warren W000166 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 1 |
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);