legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
124 rows where party = "Jackson" and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2237 | 2237 | William Findlay F000122 | sen | PA | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
2589 | 2589 | Samuel Edwards E000080 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
2599 | 2599 | Patrick Farrelly F000032 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 18 | |||||||||||||
2602 | 2602 | John Findlay F000120 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 11 | |||||||||||||
2623 | 2623 | Robert Harris H000250 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
2650 | 2650 | Jacob Krebs K000324 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2693 | 2693 | James Mitchell M000816 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 10 | |||||||||||||
2699 | 2699 | George Plumer P000392 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 17 | |||||||||||||
2728 | 2728 | Alexander Thomson T000227 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 13 | |||||||||||||
2738 | 2738 | Henry Wilson W000584 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2743 | 2743 | John Wurts W000774 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
2762 | 2762 | William Addams A000053 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2763 | 2763 | William Addams A000053 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
2774 | 2774 | Stephen Barlow B000150 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 18 | |||||||||||||
2775 | 2775 | Isaac Barnard B000154 | sen | PA | 1827-12-03 | 1831-12-31 | 1 | Jackson | |||||||||||||
2867 | 2867 | George Kremer K000329 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
2868 | 2868 | George Kremer K000329 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
2909 | 2909 | John Mitchell M000817 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 12 | |||||||||||||
2910 | 2910 | John Mitchell M000817 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 12 | |||||||||||||
2923 | 2923 | Robert Orr O000105 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 16 | |||||||||||||
2924 | 2924 | Robert Orr O000105 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 16 | |||||||||||||
2969 | 2969 | James Stevenson S000892 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 16 | |||||||||||||
2970 | 2970 | James Stevenson S000892 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 16 | |||||||||||||
2981 | 2981 | Espy Van Horne V000044 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
2982 | 2982 | Espy Van Horne V000044 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
3101 | 3101 | Chauncey Forward F000290 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 13 | |||||||||||||
3102 | 3102 | Chauncey Forward F000290 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 13 | |||||||||||||
3103 | 3103 | Chauncey Forward F000290 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 13 | |||||||||||||
3105 | 3105 | Joseph Fry F000397 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
3106 | 3106 | Joseph Fry F000397 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3108 | 3108 | Innis Green G000412 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
3109 | 3109 | Innis Green G000412 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3125 | 3125 | Joseph Hemphill H000470 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3126 | 3126 | Joseph Hemphill H000470 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3142 | 3142 | Samuel Ingham I000022 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
3143 | 3143 | Samuel Ingham I000022 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
3144 | 3144 | Samuel Ingham I000022 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3145 | 3145 | Thomas Irwin I000043 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 14 | |||||||||||||
3161 | 3161 | George Leiper L000234 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3171 | 3171 | Alem Marr M000141 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3175 | 3175 | William McCreery M000386 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3180 | 3180 | Daniel Miller M000722 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
3181 | 3181 | Daniel Miller M000722 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
3182 | 3182 | Daniel Miller M000722 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3202 | 3202 | John Scott S000175 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3223 | 3223 | John Sterigere S000867 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3224 | 3224 | John Sterigere S000867 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3272 | 3272 | George Wolf W000673 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
3273 | 3273 | George Wolf W000673 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
3274 | 3274 | George Wolf W000673 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3323 | 3323 | John Bucher B001010 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
3352 | 3352 | Thomas Crawford C000893 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3353 | 3353 | Thomas Crawford C000893 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
3359 | 3359 | George Dallas D000011 | sen | PA | 1831-12-05 | 1833-03-03 | 1 | Jackson | |||||||||||||
3365 | 3365 | Lewis Dewart D000289 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3374 | 3374 | Joshua Evans E000248 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3375 | 3375 | Joshua Evans E000248 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
3381 | 3381 | James Ford F000263 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3382 | 3382 | James Ford F000263 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3393 | 3393 | John Gilmore G000222 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 16 | |||||||||||||
3394 | 3394 | John Gilmore G000222 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 16 | |||||||||||||
3416 | 3416 | Henry Horn H000787 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3422 | 3422 | Peter Ihrie I000006 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3423 | 3423 | Peter Ihrie I000006 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3445 | 3445 | Adam King K000192 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 10 | |||||||||||||
3446 | 3446 | Adam King K000192 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3447 | 3447 | Adam King K000192 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
3468 | 3468 | Robert McCoy M000375 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
3529 | 3529 | William Ramsey R000029 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
3530 | 3530 | William Ramsey R000029 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3543 | 3543 | Samuel Smith S000611 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3544 | 3544 | Samuel Smith S000611 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3550 | 3550 | Philander Stephens S000859 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3551 | 3551 | Philander Stephens S000859 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3646 | 3646 | Richard Coulter C000808 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 17 | |||||||||||||
3647 | 3647 | Richard Coulter C000808 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3648 | 3648 | Richard Coulter C000808 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 17 | |||||||||||||
3649 | 3649 | Richard Coulter C000808 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 19 | |||||||||||||
3717 | 3717 | Henry King K000202 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
3718 | 3718 | Henry King K000202 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3735 | 3735 | Joel Mann M000107 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
3736 | 3736 | Joel Mann M000107 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3751 | 3751 | Samuel McKean M000492 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
3752 | 3752 | Samuel McKean M000492 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
3834 | 3834 | Joseph Anthony A000263 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
3835 | 3835 | Joseph Anthony A000263 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 16 | |||||||||||||
3836 | 3836 | Michael Ash A000305 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
3847 | 3847 | Andrew Beaumont B000286 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 15 | |||||||||||||
3848 | 3848 | Andrew Beaumont B000286 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 15 | |||||||||||||
3926 | 3926 | Samuel Harrison H000276 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 23 | |||||||||||||
3927 | 3927 | Samuel Harrison H000276 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 23 | |||||||||||||
3933 | 3933 | Joseph Henderson H000486 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 14 | |||||||||||||
3934 | 3934 | Joseph Henderson H000486 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 14 | |||||||||||||
3986 | 3986 | John Laporte L000094 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 17 | |||||||||||||
3987 | 3987 | John Laporte L000094 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 17 | |||||||||||||
4019 | 4019 | Jesse Miller M000734 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 13 | |||||||||||||
4020 | 4020 | Jesse Miller M000734 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 13 | |||||||||||||
4072 | 4072 | Joel Sutherland S001083 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
4073 | 4073 | Joel Sutherland S001083 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4074 | 4074 | Joel Sutherland S001083 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 1 |
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);