legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where district = 8 and "start" is on date 1923-12-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18603 | 18603 | Raymond Cole C000613 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18632 | 18632 | Hiram Evans E000243 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18728 | 18728 | Oscar Larson L000104 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18759 | 18759 | Frank McNulty M000588 | rep | NJ | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
18830 | 18830 | Sidney Roach R000289 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18873 | 18873 | Horace Towner T000325 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18929 | 18929 | William Cleary C000500 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
19253 | 19253 | Thomas Butler B001192 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19603 | 19603 | Edward Browne B000955 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19888 | 19888 | Robert Moore M000915 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20103 | 20103 | James Aswell A000321 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20217 | 20217 | James Collier C000630 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20276 | 20276 | Frederick Dallinger D000012 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20373 | 20373 | Arthur Free F000359 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20403 | 20403 | Milton Garber G000046 | rep | OK | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20411 | 20411 | Daniel Garrett G000081 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20417 | 20417 | Ralph Gilbert G000177 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20615 | 20615 | Stanley Kunz K000342 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20971 | 20971 | Albert Vestal V000092 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20976 | 20976 | Bird Vincent V000101 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
21084 | 21084 | Edward Almon A000162 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21099 | 21099 | William Ayres A000354 | rep | KS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21136 | 21136 | Charles Brand B000767 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21163 | 21163 | Gordon Browning B000959 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
25219 | 25219 | Robert Doughton D000448 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 8 |
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);