legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1915-12-06
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17036 | 17036 | William Williams W000548 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17038 | 17038 | Emmett Wilson W000575 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17041 | 17041 | Samuel Witherspoon W000662 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17053 | 17053 | William Adamson A000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17058 | 17058 | Richard Austin A000341 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17065 | 17065 | Henry Barnhart B000164 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17071 | 17071 | Samuel Beakes B000264 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17079 | 17079 | William Borland B000643 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17081 | 17081 | James Britt B000846 | rep | NC | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17086 | 17086 | Henry Bruckner B000974 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 22 | |||||||||||||
17094 | 17094 | John Capstick C000136 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17096 | 17096 | William Carter C000205 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
17102 | 17102 | William Cary C000218 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17110 | 17110 | John Connelly C000689 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17115 | 17115 | Michael Conry C000707 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
17117 | 17117 | Edward Cooper C000748 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17123 | 17123 | William Cox C000840 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17130 | 17130 | Harry Dale D000008 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17142 | 17142 | Perl Decker D000184 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
17148 | 17148 | Martin Dies D000337 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17151 | 17151 | Charles Dillon D000348 | rep | SD | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17158 | 17158 | Lincoln Dixon D000374 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17161 | 17161 | Dudley Doolittle D000427 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17164 | 17164 | Dow Drukker D000505 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
17171 | 17171 | George Fairchild F000005 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 34 | |||||||||||||
17181 | 17181 | David Finley F000131 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17191 | 17191 | John Fitzgerald F000165 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17193 | 17193 | Joseph Flynn F000228 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17204 | 17204 | George Foss F000295 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17210 | 17210 | Martin Foster F000309 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 23 | |||||||||||||
17222 | 17222 | Augustus Gardner G000050 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
17225 | 17225 | William Gordon G000317 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
17227 | 17227 | Edward Gray G000393 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17229 | 17229 | Oscar Gray G000401 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17237 | 17237 | Alexander Gregg G000441 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17240 | 17240 | Daniel Griffin G000460 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17243 | 17243 | Charles Hamilton H000104 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 43 | |||||||||||||
17250 | 17250 | Courtney Hamlin H000119 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17257 | 17257 | Everis Hayes H000389 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17259 | 17259 | Robert Heaton H000433 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
17264 | 17264 | Henry Helgesen H000459 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17267 | 17267 | Guy Helvering H000466 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17271 | 17271 | Walter Hensley H000522 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17282 | 17282 | Ebenezer Hill H000591 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17284 | 17284 | Benjamin Hilliard H000620 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17292 | 17292 | David Hollingsworth H000726 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
17294 | 17294 | George Hood H000755 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17301 | 17301 | William Houston H000829 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17305 | 17305 | William Howard H000849 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17307 | 17307 | George Hulbert H000934 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 21 | |||||||||||||
17321 | 17321 | William Jones J000259 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17324 | 17324 | Edward Keating K000035 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17329 | 17329 | John Key K000157 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17336 | 17336 | William La Follette L000006 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17339 | 17339 | Adam Littlepage L000358 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17343 | 17343 | Charles Lobeck L000385 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17351 | 17351 | Atkins McLemore M000554 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17353 | 17353 | Jacob Meeker M000629 | rep | MO | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17358 | 17358 | Clarence Miller M000717 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17364 | 17364 | Patrick Norton N000156 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17368 | 17368 | George O’Shaunessy O000117 | rep | RI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17371 | 17371 | Arthur Overmyer O000141 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17384 | 17384 | Caleb Powers P000487 | rep | KY | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
17386 | 17386 | Harry Pratt P000500 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 37 | |||||||||||||
17389 | 17389 | Jesse Price P000527 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17393 | 17393 | Edwin Roberts R000309 | rep | NV | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
17395 | 17395 | Charles Rowland R000480 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
17400 | 17400 | Joseph Russell R000533 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17405 | 17405 | John Scott S000180 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17415 | 17415 | Dorsey Shackleford S000274 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17423 | 17423 | Joseph Sherley S000343 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17425 | 17425 | Jouett Shouse S000384 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17436 | 17436 | James Slayden S000482 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17440 | 17440 | Charles Smith S000520 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 41 | |||||||||||||
17447 | 17447 | Dan Stephens S000856 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17455 | 17455 | John Sterling S000870 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
17466 | 17466 | Cyrus Sulloway S001063 | rep | NH | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17469 | 17469 | Howard Sutherland S001081 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17471 | 17471 | Oscar Swift S001118 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
17475 | 17475 | Robert Switzer S001124 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17487 | 17487 | Joshua Talbott T000021 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17498 | 17498 | John Walker W000060 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17518 | 17518 | Frank Woods W000721 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17536 | 17536 | Joshua Alexander A000098 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17568 | 17568 | Charles Booher B000626 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17573 | 17573 | William Browning B000961 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17577 | 17577 | Clement Brumbaugh B000975 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17588 | 17588 | John Burnett B001121 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17591 | 17591 | Charles Caldwell C000030 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17601 | 17601 | Ezekiel Candler C000110 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17608 | 17608 | Charles Carlin C000151 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17621 | 17621 | James Clark C000437 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
17625 | 17625 | Charles Coady C000541 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17630 | 17630 | Peter Costello C000796 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17638 | 17638 | Stanley Dent D000256 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17641 | 17641 | Arthur Dewalt D000288 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17648 | 17648 | Peter Dooling D000426 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17653 | 17653 | Frank Doremus D000431 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17658 | 17658 | Franklin Ellsworth E000145 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17661 | 17661 | Henry Emerson E000171 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 22 |
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);