legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where "end" is on date 1935-01-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19942 | 19942 | David Reed R000114 | sen | PA | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21111 | 21111 | James Beck B000290 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
21173 | 21173 | George Brumm B000978 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
21209 | 21209 | Thomas Cochran C000566 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 20 | |||||||||||||
21217 | 21217 | James Connolly C000698 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
21249 | 21249 | George Edmonds E000053 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 4 | |||||||||||||
21359 | 21359 | Melville Kelly K000076 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 31 | |||||||||||||
21370 | 21370 | Jacob Kurtz K000344 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 23 | |||||||||||||
21418 | 21418 | Louis McFadden M000434 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 15 | |||||||||||||
21445 | 21445 | Michael Muldowney M001067 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 32 | |||||||||||||
21560 | 21560 | Edward Stokes S000946 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
21569 | 21569 | Nathan Strong S001015 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 27 | |||||||||||||
21581 | 21581 | Jesse Swick S001114 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 26 | |||||||||||||
21586 | 21586 | Alfred Waldron W000040 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
21596 | 21596 | Henry Watson W000201 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
21641 | 21641 | William Berlin B000409 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 28 | |||||||||||||
21655 | 21655 | Joshua Brooks B000882 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 30 | |||||||||||||
21745 | 21745 | Isaac Doutrich D000460 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 19 | |||||||||||||
21939 | 21939 | Harry Ransley R000061 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
21941 | 21941 | William Richardson R000230 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
21985 | 21985 | Charles Turpin T000433 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 12 | |||||||||||||
22103 | 22103 | Charles Crosby C000928 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 29 | |||||||||||||
22131 | 22131 | Henry Ellenbogen E000111 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 33 | |||||||||||||
22150 | 22150 | Benjamin Focht F000230 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 18 | |||||||||||||
22153 | 22153 | Oliver Frey F000382 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22558 | 22558 | George Darrow D000063 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
22583 | 22583 | Matthew Dunn D000551 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 34 | |||||||||||||
22881 | 22881 | Patrick Boland B000601 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22985 | 22985 | Charles Faddis F000001 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 25 | |||||||||||||
23020 | 23020 | Harry Haines H000026 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
23425 | 23425 | John Ditter D000363 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 17 | |||||||||||||
23932 | 23932 | John Kinzer K000231 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
24098 | 24098 | John Snyder S000668 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
24210 | 24210 | James Wolfenden W000678 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
25003 | 25003 | Robert Rich R000209 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 16 | |||||||||||||
28232 | 28232 | Francis Walter W000108 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 21 |
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);