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 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
21226 | 21226 | Clement Dickinson D000316 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17148 | 17148 | Martin Dies D000337 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19665 | 19665 | Clarence Dill D000345 | rep | WA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18151 | 18151 | William Dillingham D000347 | sen | VT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
17648 | 17648 | Peter Dooling D000426 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17161 | 17161 | Dudley Doolittle D000427 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17653 | 17653 | Frank Doremus D000431 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
25215 | 25215 | Robert Doughton D000448 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
22571 | 22571 | Cassius Dowell D000468 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
16752 | 16752 | Daniel Driscoll D000500 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 42 | |||||||||||||
17164 | 17164 | Dow Drukker D000505 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
18154 | 18154 | Thomas Dunn D000553 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 38 | |||||||||||||
18621 | 18621 | Henry Dupré D000561 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
20321 | 20321 | Leonidas Dyer D000591 | rep | MO | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
18627 | 18627 | John Eagan E000001 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
21753 | 21753 | Joe Eagle E000003 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16754 | 16754 | Manuel Earnshaw E000015 | rep | PI | 1915-12-06 | 1917-03-03 | 0 | ||||||||||||||
21244 | 21244 | George Edmonds E000053 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
20344 | 20344 | Charles Edwards E000062 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17658 | 17658 | Franklin Ellsworth E000145 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18160 | 18160 | John Elston E000161 | rep | CA | 1915-12-06 | 1917-03-03 | Progressive | 6 | |||||||||||||
17661 | 17661 | Henry Emerson E000171 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
17672 | 17672 | John Esch E000212 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
17679 | 17679 | Albert Estopinal E000224 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
20360 | 20360 | John Evans E000247 | rep | MT | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17171 | 17171 | George Fairchild F000005 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 34 | |||||||||||||
16755 | 16755 | Michael Farley F000021 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17688 | 17688 | John Farr F000029 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17695 | 17695 | Scott Ferris F000091 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19697 | 19697 | Simeon Fess F000096 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
18643 | 18643 | William Fields F000113 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18174 | 18174 | Henry Flood F000210 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
17193 | 17193 | Joseph Flynn F000228 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
22146 | 22146 | Benjamin Focht F000230 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
18186 | 18186 | Joseph Fordney F000271 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
21271 | 21271 | James Frear F000355 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
20378 | 20378 | Richard Freeman F000366 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18950 | 18950 | Charles Fuller F000407 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
17707 | 17707 | Thomas Gallagher G000018 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16762 | 16762 | Jacob Gallinger G000023 | sen | NH | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
19309 | 19309 | James Gallivan G000024 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17710 | 17710 | Harry Gandy G000037 | rep | SD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17714 | 17714 | Warren Gard G000048 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17222 | 17222 | Augustus Gardner G000050 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
17717 | 17717 | Mahlon Garland G000068 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
21287 | 21287 | John Garner G000074 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
19324 | 19324 | Finis Garrett G000082 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18970 | 18970 | Frederick Gillett G000201 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
23519 | 23519 | Carter Glass G000232 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19725 | 19725 | James Glynn G000246 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17724 | 17724 | Hannibal Godwin G000250 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18197 | 18197 | James Good G000275 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17739 | 17739 | William Goodwin G000304 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17225 | 17225 | William Gordon G000317 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18203 | 18203 | Norman Gould G000342 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 36 | |||||||||||||
16768 | 16768 | Joseph Goulden G000344 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 23 | |||||||||||||
20435 | 20435 | George Graham G000354 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17227 | 17227 | Edward Gray G000393 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
22188 | 22188 | Finly Gray G000395 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17229 | 17229 | Oscar Gray G000401 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19335 | 19335 | William Green G000422 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
19735 | 19735 | Frank Greene G000425 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18669 | 18669 | William Greene G000430 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
17237 | 17237 | Alexander Gregg G000441 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19744 | 19744 | William Griest G000456 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
17240 | 17240 | Daniel Griffin G000460 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16773 | 16773 | Asle Gronna G000491 | sen | ND | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16778 | 16778 | Frank Guernsey G000517 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
20445 | 20445 | Lindley Hadley H000008 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17747 | 17747 | James Hamill H000099 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17243 | 17243 | Charles Hamilton H000104 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 43 | |||||||||||||
17759 | 17759 | Edward Hamilton H000108 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17250 | 17250 | Courtney Hamlin H000119 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18032 | 18032 | Warren Harding H000192 | sen | OH | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18211 | 18211 | Rufus Hardy H000198 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22220 | 22220 | Byron Harrison H000265 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19342 | 19342 | Thomas Harrison H000277 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
16780 | 16780 | Archibald Hart H000283 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17762 | 17762 | Reuben Haskell H000319 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
21306 | 21306 | William Hastings H000333 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
20488 | 20488 | Gilbert Haugen H000350 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
20501 | 20501 | Willis Hawley H000379 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16790 | 16790 | James Hay H000382 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
27845 | 27845 | Carl Hayden H000385 | rep | AZ | 1915-12-06 | 1917-03-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
18985 | 18985 | James Heflin H000446 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17264 | 17264 | Henry Helgesen H000459 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17769 | 17769 | Harvey Helm H000461 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17267 | 17267 | Guy Helvering H000466 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 5 |
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);