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 state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19159 | 19159 | Loren Wheeler W000339 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
19378 | 19378 | Edward King K000200 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
19411 | 19411 | Martin Madden M000038 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19657 | 19657 | Edward Denison D000237 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 25 | |||||||||||||
20042 | 20042 | Thomas Williams W000542 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
20182 | 20182 | Burnett Chiperfield C000364 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
21151 | 21151 | Frederick Britten B000847 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
21517 | 21517 | Henry Rainey R000014 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
22699 | 22699 | James McAndrews M000296 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
25458 | 25458 | Adolph Sabath S000001 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
16668 | 16668 | John Adair A000027 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16735 | 16735 | Cyrus Cline C000521 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16740 | 16740 | William Cullop C000975 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16848 | 16848 | Charles Lieb L000302 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16895 | 16895 | Martin Morrison M000998 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16901 | 16901 | Ralph Moss M001037 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
16939 | 16939 | George Rauch R000070 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
16961 | 16961 | Benjamin Shively S000371 | sen | IN | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
17065 | 17065 | Henry Barnhart B000164 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17123 | 17123 | William Cox C000840 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17158 | 17158 | Lincoln Dixon D000374 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18766 | 18766 | Merrill Moores M000928 | rep | IN | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
21022 | 21022 | William Wood W000706 | rep | IN | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
22188 | 22188 | Finly Gray G000395 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17025 | 17025 | Joseph Taggart T000011 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17110 | 17110 | John Connelly C000689 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17161 | 17161 | Dudley Doolittle D000427 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17267 | 17267 | Guy Helvering H000466 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17425 | 17425 | Jouett Shouse S000384 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18089 | 18089 | Philip Campbell C000097 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
19191 | 19191 | Daniel Anthony A000261 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19277 | 19277 | Charles Curtis C001008 | sen | KS | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
21096 | 21096 | William Ayres A000354 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16688 | 16688 | John Beckham B000293 | sen | KY | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17384 | 17384 | Caleb Powers P000487 | rep | KY | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
17423 | 17423 | Joseph Sherley S000343 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17769 | 17769 | Harvey Helm H000461 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
18578 | 18578 | James Cantrill C000126 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18643 | 18643 | William Fields F000113 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18999 | 18999 | Ben Johnson J000118 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
19014 | 19014 | John Langley L000072 | rep | KY | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
19090 | 19090 | Arthur Rouse R000466 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19125 | 19125 | Robert Thomas T000185 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19825 | 19825 | David Kincheloe K000187 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
25868 | 25868 | Alben Barkley B000145 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16705 | 16705 | Robert Broussard B000896 | sen | LA | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
16891 | 16891 | Lewis Morgan M000955 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17679 | 17679 | Albert Estopinal E000224 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17989 | 17989 | John Watkins W000193 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18621 | 18621 | Henry Dupré D000561 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19386 | 19386 | Ladislas Lazaro L000153 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19857 | 19857 | Whitmell Martin M000201 | rep | LA | 1915-12-06 | 1917-03-03 | Progressive | 3 | |||||||||||||
20099 | 20099 | James Aswell A000321 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
21997 | 21997 | Riley Wilson W000608 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
16951 | 16951 | Ernest Roberts R000311 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
17096 | 17096 | William Carter C000205 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
17222 | 17222 | Augustus Gardner G000050 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
17875 | 17875 | Richard Olney O000080 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17883 | 17883 | Michael Phelan P000291 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18548 | 18548 | Joseph Walsh W000101 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 16 | |||||||||||||
18669 | 18669 | William Greene G000430 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
18794 | 18794 | Calvin Paige P000024 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18862 | 18862 | Peter Tague T000014 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18890 | 18890 | Samuel Winslow W000639 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18970 | 18970 | Frederick Gillett G000201 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19082 | 19082 | John Rogers R000400 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
19309 | 19309 | James Gallivan G000024 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
20272 | 20272 | Frederick Dallinger D000012 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
23296 | 23296 | George Tinkham T000283 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
23712 | 23712 | Allen Treadway T000358 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16969 | 16969 | John Smith S000577 | sen | MD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17389 | 17389 | Jesse Price P000527 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17487 | 17487 | Joshua Talbott T000021 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17625 | 17625 | Charles Coady C000541 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18779 | 18779 | Sydney Mudd M001060 | rep | MD | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
20655 | 20655 | John Linthicum L000340 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
22270 | 22270 | David Lewis L000277 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
16778 | 16778 | Frank Guernsey G000517 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
16803 | 16803 | Asher Hinds H000630 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16883 | 16883 | Daniel McGillicuddy M000448 | rep | ME | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18417 | 18417 | John Peters P000253 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
16872 | 16872 | George Loud L000449 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17071 | 17071 | Samuel Beakes B000264 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17653 | 17653 | Frank Doremus D000431 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17759 | 17759 | Edward Hamilton H000108 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17872 | 17872 | Charles Nichols N000090 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
18186 | 18186 | Joseph Fordney F000271 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
18268 | 18268 | Patrick Kelley K000061 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
18851 | 18851 | John Smith S000573 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
19097 | 19097 | Frank Scott S000169 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
19629 | 19629 | Louis Cramton C000870 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
20701 | 20701 | James McLaughlin M000539 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
21331 | 21331 | William James J000053 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
22675 | 22675 | Carl Mapes M000119 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
16854 | 16854 | Charles Lindbergh L000320 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
16963 | 16963 | George Smith S000540 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17358 | 17358 | Clarence Miller M000717 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17658 | 17658 | Franklin Ellsworth E000145 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17978 | 17978 | Carl Van Dyke V000034 | rep | MN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18500 | 18500 | Halvor Steenerson S000842 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 9 |
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);