legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
33 rows where district = 5 and "start" is on date 1923-12-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18675 | 18675 | James Hooker H000759 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18695 | 18695 | Henry Jost J000273 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18730 | 18730 | Thomas Lilly L000311 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18783 | 18783 | Sydney Mudd M001060 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18785 | 18785 | Mae Nolan N000125 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18788 | 18788 | Patrick O’Sullivan O000123 | rep | CT | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18837 | 18837 | Everett Sanders S000034 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18886 | 18886 | John Webster W000240 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19086 | 19086 | John Rogers R000400 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19139 | 19139 | William Upshaw U000026 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19209 | 19209 | Victor Berger B000407 | rep | WI | 1923-12-03 | 1925-03-03 | Socialist | 5 | |||||||||||||
19231 | 19231 | William Bowling B000702 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19900 | 19900 | Walter Newton N000079 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19984 | 19984 | Charles Stedman S000827 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20021 | 20021 | Charles Thompson T000194 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20075 | 20075 | Ernest Ackerman A000021 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20205 | 20205 | Cyrenus Cole C000608 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20287 | 20287 | Ewin Davis D000098 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20885 | 20885 | William Stevenson S000895 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20893 | 20893 | James Strong S001011 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20926 | 20926 | Maurice Thatcher T000142 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
21121 | 21121 | Loring Black B000505 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21212 | 21212 | James Connolly C000698 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
21505 | 21505 | Heartsill Ragon R000009 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21536 | 21536 | Ashton Shallenberger S000280 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21573 | 21573 | Fletcher Swank S001089 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21805 | 21805 | Samuel Hill H000607 | rep | WA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22001 | 22001 | Riley Wilson W000608 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22161 | 22161 | Stephen Gambrill G000035 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22679 | 22679 | Carl Mapes M000119 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
22932 | 22932 | Ross Collins C000642 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
24118 | 24118 | Hatton Sumners S001072 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
25462 | 25462 | Adolph Sabath S000001 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 5 |
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);