legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
26 rows where district = 7 and "start" is on date 1911-04-04
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15936 | 15936 | William Dickson D000334 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16073 | 16073 | Edmond Madison M000042 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
16107 | 16107 | Henry McMorran M000576 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
16163 | 16163 | Arsène Pujo P000567 | rep | LA | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16434 | 16434 | Charles Korbly K000316 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16499 | 16499 | George Neeley N000022 | rep | KS | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16534 | 16534 | James Post P000454 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16536 | 16536 | Solomon Prouty P000551 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
16619 | 16619 | Edward Townsend T000332 | rep | NJ | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16709 | 16709 | Frank Buchanan B001001 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16788 | 16788 | James Hay H000382 | rep | VA | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16920 | 16920 | Robert Page P000022 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16949 | 16949 | Ernest Roberts R000311 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
17009 | 17009 | William Stephens S000861 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
17189 | 17189 | John Fitzgerald F000165 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
17235 | 17235 | Alexander Gregg G000441 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
17248 | 17248 | Courtney Hamlin H000119 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
17586 | 17586 | John Burnett B001121 | rep | AL | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
17670 | 17670 | John Esch E000212 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
17737 | 17737 | William Goodwin G000304 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
17813 | 17813 | Asbury Lever L000259 | rep | SC | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
18395 | 18395 | Lemuel Padgett P000012 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
18542 | 18542 | Andrew Volstead V000114 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
18576 | 18576 | James Cantrill C000126 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
19023 | 19023 | Gordon Lee L000194 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
19247 | 19247 | Thomas Butler B001192 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 7 |
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);