legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where district = 7 and "start" is on date 1901-12-02
This data as json, copyable, CSV (advanced)
Suggested facets: state, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13911 | 13911 | James Cooney C000744 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
13943 | 13943 | Frank Eddy E000038 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14018 | 14018 | Charles Hooker H000758 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14049 | 14049 | Montague Lessler L000253 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14106 | 14106 | Nicholas Muller M001071 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14194 | 14194 | James Stokes S000947 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14211 | 14211 | Edgar Weeks W000243 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14368 | 14368 | Theodore Kluttz K000275 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14370 | 14370 | Thomas Kyle K000355 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14386 | 14386 | Chester Long L000412 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14393 | 14393 | John Maddox M000040 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14819 | 14819 | Allan McDermott M000403 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14921 | 14921 | South Trimble T000376 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
15240 | 15240 | Jesse Overstreet O000144 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
15551 | 15551 | John Hull H000942 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
15806 | 15806 | Irving Wanger W000122 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
16122 | 16122 | James Needham N000021 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
16783 | 16783 | James Hay H000382 | rep | VA | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
16793 | 16793 | Robert Henry H000516 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
16944 | 16944 | Ernest Roberts R000311 | rep | MA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
17198 | 17198 | George Foss F000295 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
17581 | 17581 | John Burnett B001121 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
17665 | 17665 | John Esch E000212 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
17808 | 17808 | Asbury Lever L000259 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
18390 | 18390 | Lemuel Padgett P000012 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 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);