legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
31 rows where district = 3 and "start" is on date 1891-12-07
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12068 | 12068 | John Andrew A000242 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12113 | 12113 | Allen Bushnell B001170 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12136 | 12136 | Benjamin Clover C000533 | rep | KS | 1891-12-07 | 1893-03-03 | Populist | 3 | |||||||||||||
12217 | 12217 | George Johnstone J000202 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12241 | 12241 | Joseph McKenna M000500 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
12254 | 12254 | James O’Donnell O000039 | rep | MI | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
12396 | 12396 | John Alderson A000080 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12445 | 12445 | Jason Brown B000924 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12499 | 12499 | William Coombs C000742 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12521 | 12521 | Allan Durborow D000564 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12570 | 12570 | Jacob Geissenhainer G000119 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12577 | 12577 | Isaac Goodnight G000292 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12581 | 12581 | Benjamin Grady G000350 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12590 | 12590 | Osee Hall H000065 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12638 | 12638 | George Houk H000816 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12655 | 12655 | Constantine Kilgore K000173 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12739 | 12739 | William Oates O000005 | rep | AL | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12791 | 12791 | Henry Snodgrass S000655 | rep | TN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12869 | 12869 | George Wise W000648 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12975 | 12975 | Charles Crisp C000908 | rep | GA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13044 | 13044 | Omer Kem K000083 | rep | NE | 1891-12-07 | 1893-03-03 | Populist | 3 | |||||||||||||
13133 | 13133 | Andrew Price P000521 | rep | LA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13145 | 13145 | Harry Rusk R000516 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13294 | 13294 | Alexander Dockery D000384 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13328 | 13328 | Samuel Hilborn H000583 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
13418 | 13418 | Seth Milliken M000769 | rep | ME | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
13601 | 13601 | Thomas Catchings C000247 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13732 | 13732 | William McAleer M000294 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13994 | 13994 | David Henderson H000478 | rep | IA | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
14068 | 14068 | Thomas McRae M000597 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
14147 | 14147 | Charles Russell R000521 | rep | CT | 1891-12-07 | 1893-03-03 | Republican | 3 |
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);