legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
506 rows where "end" is on date 1919-03-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19160 | 19160 | Loren Wheeler W000339 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 21 | |||||||||||||
19379 | 19379 | Edward King K000200 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
19412 | 19412 | Martin Madden M000038 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19658 | 19658 | Edward Denison D000237 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
20043 | 20043 | Thomas Williams W000542 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
21152 | 21152 | Frederick Britten B000847 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
21518 | 21518 | Henry Rainey R000014 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
22276 | 22276 | James Lewis L000284 | sen | IL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
22700 | 22700 | James McAndrews M000296 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
25459 | 25459 | Adolph Sabath S000001 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17066 | 17066 | Henry Barnhart B000164 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
17108 | 17108 | Daniel Comstock C000663 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17124 | 17124 | William Cox C000840 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17144 | 17144 | George Denton D000258 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17159 | 17159 | Lincoln Dixon D000374 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18051 | 18051 | Oscar Bland B000542 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18294 | 18294 | Milton Kraus K000323 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18633 | 18633 | Louis Fairfield F000007 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
18767 | 18767 | Merrill Moores M000928 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
18834 | 18834 | Everett Sanders S000034 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
19677 | 19677 | Richard Elliott E000127 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20780 | 20780 | Fred Purnell P000573 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
20968 | 20968 | Albert Vestal V000092 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
21023 | 21023 | William Wood W000706 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
16613 | 16613 | William Thompson T000226 | sen | KS | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17111 | 17111 | John Connelly C000689 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17162 | 17162 | Dudley Doolittle D000427 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17268 | 17268 | Guy Helvering H000466 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17426 | 17426 | Jouett Shouse S000384 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18090 | 18090 | Philip Campbell C000097 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18731 | 18731 | Edward Little L000349 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19192 | 19192 | Daniel Anthony A000261 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
21097 | 21097 | William Ayres A000354 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
16415 | 16415 | Ollie James J000051 | sen | KY | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17385 | 17385 | Caleb Powers P000487 | rep | KY | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17424 | 17424 | Joseph Sherley S000343 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17526 | 17526 | George Martin M000181 | sen | KY | 1918-09-07 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17770 | 17770 | Harvey Helm H000461 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18579 | 18579 | James Cantrill C000126 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18644 | 18644 | William Fields F000113 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
19000 | 19000 | Ben Johnson J000118 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
19015 | 19015 | John Langley L000072 | rep | KY | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
19091 | 19091 | Arthur Rouse R000466 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19126 | 19126 | Robert Thomas T000185 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
19826 | 19826 | David Kincheloe K000187 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
25869 | 25869 | Alben Barkley B000145 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
16705 | 16705 | Robert Broussard B000896 | sen | LA | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
17680 | 17680 | Albert Estopinal E000224 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17908 | 17908 | Jared Sanders S000035 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17990 | 17990 | John Watkins W000193 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18622 | 18622 | Henry Dupré D000561 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19078 | 19078 | Joseph Ransdell R000059 | sen | LA | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
19387 | 19387 | Ladislas Lazaro L000153 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19858 | 19858 | Whitmell Martin M000201 | rep | LA | 1917-04-02 | 1919-03-03 | Progressive | 3 | |||||||||||||
20100 | 20100 | James Aswell A000321 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21998 | 21998 | Riley Wilson W000608 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
16636 | 16636 | John Weeks W000246 | sen | MA | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17097 | 17097 | William Carter C000205 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
17223 | 17223 | Augustus Gardner G000050 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17702 | 17702 | Alvan Fuller F000405 | rep | MA | 1917-04-02 | 1919-03-03 | Ind. Republican | 9 | |||||||||||||
17876 | 17876 | Richard Olney O000080 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17884 | 17884 | Michael Phelan P000291 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18316 | 18316 | Willfred Lufkin L000503 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18549 | 18549 | Joseph Walsh W000101 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 16 | |||||||||||||
18670 | 18670 | William Greene G000430 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
18795 | 18795 | Calvin Paige P000024 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18863 | 18863 | Peter Tague T000014 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18891 | 18891 | Samuel Winslow W000639 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18971 | 18971 | Frederick Gillett G000201 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19083 | 19083 | John Rogers R000400 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
19310 | 19310 | James Gallivan G000024 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
20273 | 20273 | Frederick Dallinger D000012 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
23297 | 23297 | George Tinkham T000283 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
23713 | 23713 | Allen Treadway T000358 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17390 | 17390 | Jesse Price P000527 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17488 | 17488 | Joshua Talbott T000021 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17560 | 17560 | Carville Benson B000387 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17626 | 17626 | Charles Coady C000541 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18780 | 18780 | Sydney Mudd M001060 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
20061 | 20061 | Frederick Zihlman Z000007 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20656 | 20656 | John Linthicum L000340 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17735 | 17735 | Louis Goodall G000276 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18418 | 18418 | John Peters P000253 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18939 | 18939 | Bert Fernald F000084 | sen | ME | 1916-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
19350 | 19350 | Ira Hersey H000544 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
23747 | 23747 | Wallace White W000396 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
16585 | 16585 | William Smith S000629 | sen | MI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17060 | 17060 | Mark Bacon B000018 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17072 | 17072 | Samuel Beakes B000264 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17633 | 17633 | Gilbert Currie C000998 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17654 | 17654 | Frank Doremus D000431 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17760 | 17760 | Edward Hamilton H000108 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17873 | 17873 | Charles Nichols N000090 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
18187 | 18187 | Joseph Fordney F000271 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
18269 | 18269 | Patrick Kelley K000061 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18852 | 18852 | John Smith S000573 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
19098 | 19098 | Frank Scott S000169 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
19630 | 19630 | Louis Cramton C000870 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
20702 | 20702 | James McLaughlin M000539 | rep | MI | 1917-04-02 | 1919-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);