legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1923-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18147 | 18147 | Jaime De Veyra D000276 | rep | PI | 1921-04-11 | 1923-03-03 | 0 | ||||||||||||||
19719 | 19719 | Isauro Gabaldon G000001 | rep | PI | 1921-04-11 | 1923-03-03 | 0 | ||||||||||||||
17128 | 17128 | Charles Culberson C000963 | sen | TX | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17290 | 17290 | Gilbert Hitchcock H000645 | sen | NE | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17361 | 17361 | Henry Myers M001129 | sen | MT | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17381 | 17381 | Atlee Pomerene P000420 | sen | OH | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17513 | 17513 | John Williams W000521 | sen | MS | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18048 | 18048 | Fred Blackmon B000514 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | -1 | |||||||||||||
18068 | 18068 | Samuel Brinson B000840 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18177 | 18177 | Henry Flood F000210 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18214 | 18214 | Rufus Hardy H000198 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18248 | 18248 | Henderson Jacoway J000041 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18250 | 18250 | Rorer James J000052 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18254 | 18254 | Paul Johnson J000166 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18389 | 18389 | James Overstreet O000143 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18400 | 18400 | Lemuel Padgett P000012 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18414 | 18414 | Lucian Parrish P000083 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
18426 | 18426 | Lilius Rainey R000017 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18467 | 18467 | William Rucker R000494 | rep | MO | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18482 | 18482 | Thomas Sisson S000456 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18509 | 18509 | Philip Stoll S000951 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18514 | 18514 | Chester Taylor T000069 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18520 | 18520 | Samuel Taylor T000100 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18522 | 18522 | Peter Ten Eyck T000126 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 28 | |||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
18557 | 18557 | James Woods W000723 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18558 | 18558 | Thomas Bayard B000252 | sen | DE | 1922-11-08 | 1923-03-03 | 1 | Democrat | |||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
18581 | 18581 | James Cantrill C000126 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18591 | 18591 | Frank Clark C000430 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18599 | 18599 | William Cockran C000575 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 16 | |||||||||||||
18624 | 18624 | Henry Dupré D000561 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18638 | 18638 | George Favrot F000048 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18646 | 18646 | William Fields F000113 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
18674 | 18674 | James Hooker H000759 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18690 | 18690 | Benjamin Humphreys H000960 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18693 | 18693 | Andrieus Jones J000210 | sen | NM | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18718 | 18718 | Claude Kitchin K000250 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18744 | 18744 | William Logan L000406 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18786 | 18786 | Charles O’Brien O000008 | rep | NJ | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
18803 | 18803 | Frank Park P000051 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18807 | 18807 | John Rainey R000015 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18811 | 18811 | James Reed R000118 | sen | MO | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18827 | 18827 | Daniel Riordan R000264 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
18865 | 18865 | Peter Tague T000014 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18874 | 18874 | John Tyson T000455 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18881 | 18881 | Hallett Ward W000132 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18898 | 18898 | James Wise W000650 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18923 | 18923 | Charles Carter C000196 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19002 | 19002 | Ben Johnson J000118 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19028 | 19028 | Gordon Lee L000194 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19068 | 19068 | John Raker R000019 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19093 | 19093 | Arthur Rouse R000466 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19110 | 19110 | John Smithwick S000643 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19128 | 19128 | Robert Thomas T000185 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19138 | 19138 | William Upshaw U000026 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
19179 | 19179 | Harry Hawes H000362 | rep | MO | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
19217 | 19217 | Eugene Black B000495 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19230 | 19230 | William Bowling B000702 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
19291 | 19291 | Joseph Deal D000169 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19312 | 19312 | James Gallivan G000024 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
19327 | 19327 | Finis Garrett G000082 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
19345 | 19345 | Thomas Harrison H000277 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19374 | 19374 | John Kindred K000191 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19389 | 19389 | Ladislas Lazaro L000153 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19393 | 19393 | Bill Lowrey L000484 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19397 | 19397 | Homer Lyon L000543 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19451 | 19451 | William Oldfield O000062 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19507 | 19507 | John Tillman T000276 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19582 | 19582 | Thomas Bell B000348 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
19589 | 19589 | John Box B000710 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19611 | 19611 | John Carew C000142 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 18 | |||||||||||||
19705 | 19705 | Hubert Fisher F000149 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
19757 | 19757 | William Hammer H000123 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19779 | 19779 | Claude Hudspeth H000910 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 16 | |||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19828 | 19828 | David Kincheloe K000187 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19860 | 19860 | Whitmell Martin M000201 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19887 | 19887 | Robert Moore M000915 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
19914 | 19914 | James O’Connor O000028 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19983 | 19983 | Charles Stedman S000827 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20054 | 20054 | Otis Wingo W000635 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
20102 | 20102 | James Aswell A000321 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
20161 | 20161 | Guy Campbell C000084 | rep | PA | 1921-04-11 | 1923-03-03 | Democrat | 32 | |||||||||||||
20216 | 20216 | James Collier C000630 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
20265 | 20265 | Charles Crisp C000909 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20286 | 20286 | Ewin Davis D000098 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
20302 | 20302 | Frederick Dominick D000408 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20313 | 20313 | Herbert Drane D000486 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
20410 | 20410 | Daniel Garrett G000081 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
20416 | 20416 | Ralph Gilbert G000177 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
20614 | 20614 | Stanley Kunz K000342 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
20630 | 20630 | William Lankford L000082 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
20638 | 20638 | William Larsen L000103 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
20658 | 20658 | John Linthicum L000340 | rep | MD | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
20792 | 20792 | Percy Quin Q000014 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
20884 | 20884 | William Stevenson S000895 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
20956 | 20956 | Henry Tucker T000399 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
21008 | 21008 | Guinn Williams W000501 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 |
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);