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 1925-03-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26952 | 26952 | Daniel Reed R000113 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 43 | |||||||||||||
23130 | 23130 | James Mead M000615 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 42 | |||||||||||||
19403 | 19403 | Clarence MacGregor M000009 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 41 | |||||||||||||
19653 | 19653 | Stephen Dempsey D000229 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 40 | |||||||||||||
20828 | 20828 | Archie Sanders S000032 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 39 | |||||||||||||
19359 | 19359 | Meyer Jacobstein J000040 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 38 | |||||||||||||
21551 | 21551 | Gale Stalker S000783 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 37 | |||||||||||||
20162 | 20162 | Guy Campbell C000084 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 36 | |||||||||||||
27549 | 27549 | John Taber T000001 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 36 | |||||||||||||
19035 | 19035 | James Magee M000046 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 35 | |||||||||||||
19422 | 19422 | Walter Magee M000049 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 35 | |||||||||||||
19433 | 19433 | John Morin M000961 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 34 | |||||||||||||
21200 | 21200 | John Clarke C000465 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 34 | |||||||||||||
18860 | 18860 | Homer Snyder S000666 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 33 | |||||||||||||
21354 | 21354 | Melville Kelly K000076 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 33 | |||||||||||||
18778 | 18778 | Luther Mott M001041 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
19500 | 19500 | Thaddeus Sweet S001109 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
19930 | 19930 | Stephen Porter P000447 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
21046 | 21046 | Adam Wyant W000776 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 31 | |||||||||||||
22420 | 22420 | Bertrand Snell S000652 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 31 | |||||||||||||
19371 | 19371 | Everett Kent K000124 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 30 | |||||||||||||
22947 | 22947 | Frank Crowther C000948 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 30 | |||||||||||||
20848 | 20848 | Milton Shreve S000387 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 29 | |||||||||||||
21469 | 21469 | James Parker P000062 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 29 | |||||||||||||
18912 | 18912 | Harris Bixler B000493 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 28 | |||||||||||||
21724 | 21724 | Parker Corning C000785 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 28 | |||||||||||||
18880 | 18880 | Charles Ward W000129 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
21564 | 21564 | Nathan Strong S001015 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
19058 | 19058 | Thomas Phillips P000314 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 26 | |||||||||||||
23455 | 23455 | Hamilton Fish F000142 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 26 | |||||||||||||
19661 | 19661 | Edward Denison D000237 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
20025 | 20025 | Jonathan Wainwright W000023 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
20921 | 20921 | Henry Temple T000119 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
18653 | 18653 | James Ganly G000038 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 24 | |||||||||||||
18937 | 18937 | Benjamin Fairchild F000004 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
20046 | 20046 | Thomas Williams W000542 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
20594 | 20594 | Samuel Kendall K000097 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
19115 | 19115 | William Swoope S001126 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 23 | |||||||||||||
21453 | 21453 | Frank Oliver O000072 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
21615 | 21615 | William Arnold A000300 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
18655 | 18655 | Samuel Glatfelter G000234 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 22 | |||||||||||||
18760 | 18760 | Edward Miller M000723 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 22 | |||||||||||||
19565 | 19565 | Theodore Burton B001159 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 22 | |||||||||||||
21783 | 21783 | Anthony Griffin G000457 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 22 | |||||||||||||
20035 | 20035 | Royal Weller W000277 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
21365 | 21365 | Jacob Kurtz K000344 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 21 | |||||||||||||
21390 | 21390 | James Major M000073 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
25642 | 25642 | Robert Crosser C000932 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
18887 | 18887 | George Wertz W000300 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 20 | |||||||||||||
20622 | 20622 | Fiorello La Guardia L000007 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 20 | |||||||||||||
20715 | 20715 | Charles Mooney M000887 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
21520 | 21520 | Henry Rainey R000014 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
18764 | 18764 | Allen Moore M000890 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 19 | |||||||||||||
18848 | 18848 | Frank Sites S000457 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 19 | |||||||||||||
21714 | 21714 | John Cooper C000757 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 19 | |||||||||||||
24759 | 24759 | Sol Bloom B000565 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 19 | |||||||||||||
19612 | 19612 | John Carew C000142 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
20121 | 20121 | Edward Beers B000312 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
20523 | 20523 | William Holaday H000708 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
20735 | 20735 | Benjamin Murphy M001089 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
22640 | 22640 | John Jones J000236 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
18606 | 18606 | Herbert Cummings C000987 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
18957 | 18957 | Frank Funk F000428 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
19043 | 19043 | Ogden Mills M000776 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
19893 | 19893 | William Morgan M000959 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
21646 | 21646 | Thomas Blanton B000549 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
19475 | 19475 | Thomas Rubey R000491 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
19780 | 19780 | Claude Hudspeth H000910 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
19821 | 19821 | Edgar Kiess K000168 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
20556 | 20556 | William Hull H000946 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
22344 | 22344 | John O’Connor O000030 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
24414 | 24414 | Charles Gifford G000169 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
24926 | 24926 | John McSweeney M000606 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
18673 | 18673 | William Greene G000430 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
18729 | 18729 | Robert Leach L000171 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
19382 | 19382 | Edward King K000200 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
20690 | 20690 | Joe Manlove M000098 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
20722 | 20722 | Charles Moore M000894 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
21291 | 21291 | John Garner G000074 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
21413 | 21413 | Louis McFadden M000434 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
22054 | 22054 | John Boylan B000726 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
18605 | 18605 | William Croll C000923 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
18659 | 18659 | William Graham G000364 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
19056 | 19056 | Nathan Perlman P000239 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
19288 | 19288 | Martin Davey D000080 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
19303 | 19303 | Louis Frothingham F000395 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
20400 | 20400 | James Fulbright F000400 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
21040 | 21040 | Harry Wurzbach W000775 | rep | TX | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
18755 | 18755 | John McKenzie M000506 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
18900 | 18900 | Joseph Wolff W000679 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
19204 | 19204 | James Begg B000314 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
19766 | 19766 | Andrew Hickey H000560 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
21009 | 21009 | Guinn Williams W000501 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
21169 | 21169 | George Brumm B000978 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
22666 | 22666 | Robert Luce L000498 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
22706 | 22706 | Clarence McLeod M000557 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
22795 | 22795 | Christopher Sullivan S001051 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
18636 | 18636 | Louis Fairfield F000007 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
18787 | 18787 | Charles O’Brien O000008 | rep | NJ | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
18954 | 18954 | Charles Fuller F000407 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 12 |
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);