legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
878 rows where party = "Jackson"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2926 | 2926 | George Owen O000150 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2927 | 2927 | George Owen O000150 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
2930 | 2930 | Albion Parris P000079 | sen | ME | 1827-12-03 | 1829-03-03 | 1 | Jackson | |||||||||||||
2937 | 2937 | Henry Ridgely R000245 | sen | DE | 1827-12-03 | 1829-03-03 | 2 | Jackson | |||||||||||||
2947 | 2947 | Lemuel Sawyer S000089 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
2948 | 2948 | Lemuel Sawyer S000089 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
2967 | 2967 | Samuel Smith S000609 | sen | MD | 1822-01-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
2968 | 2968 | Samuel Smith S000609 | sen | MD | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
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 | |||||||||||||
2971 | 2971 | John Stower S000986 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 22 | |||||||||||||
2972 | 2972 | Thomas Taber T000003 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
2975 | 2975 | Edward Tattnall T000051 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
2976 | 2976 | Edward Tattnall T000051 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
2980 | 2980 | Daniel Turner T000418 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
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 | |||||||||||||
2989 | 2989 | John Weems W000250 | rep | MD | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
2990 | 2990 | John Weems W000250 | rep | MD | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3001 | 3001 | John Wood W000697 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3018 | 3018 | James Iredell I000028 | sen | NC | 1828-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
3019 | 3019 | Oliver Prince P000539 | sen | GA | 1828-01-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3031 | 3031 | Willis Alston A000167 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3032 | 3032 | Willis Alston A000167 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3045 | 3045 | Philip Barbour B000131 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3058 | 3058 | Peter Borst B000645 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3059 | 3059 | Elias Brown B000912 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3067 | 3067 | Nicholas Coleman C000620 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3070 | 3070 | Hector Craig C000856 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3071 | 3071 | Jacob Crocheron C000915 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3076 | 3076 | Charles De Witt D000284 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3077 | 3077 | Robert Desha D000272 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3078 | 3078 | Robert Desha D000272 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3080 | 3080 | Mahlon Dickerson D000308 | sen | NJ | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3081 | 3081 | Mahlon Dickerson D000308 | sen | NJ | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3089 | 3089 | Charles Dudley D000511 | sen | NY | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3090 | 3090 | Edward Dudley D000512 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3097 | 3097 | Jonas Earll E000011 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 23 | |||||||||||||
3098 | 3098 | Jonas Earll E000011 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 23 | |||||||||||||
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 | |||||||||||||
3107 | 3107 | John Goodenow G000283 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
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 | |||||||||||||
3114 | 3114 | Jehiel Halsey H000088 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 26 | |||||||||||||
3115 | 3115 | Jonathan Harvey H000308 | rep | NH | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
3116 | 3116 | Jonathan Harvey H000308 | rep | NH | 1827-12-03 | 1829-03-03 | Jackson | -1 | |||||||||||||
3117 | 3117 | Jonathan Harvey H000308 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3119 | 3119 | Robert Hayne H000398 | sen | SC | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
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 | |||||||||||||
3127 | 3127 | Thomas Hinds H000632 | rep | MS | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3128 | 3128 | Thomas Hinds H000632 | rep | MS | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3129 | 3129 | Gabriel Holmes H000737 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
3130 | 3130 | Gabriel Holmes H000737 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
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 | |||||||||||||
3157 | 3157 | John Kincaid K000186 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3158 | 3158 | Perkins King K000209 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3159 | 3159 | Pryor Lea L000166 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3160 | 3160 | Pryor Lea L000166 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3161 | 3161 | George Leiper L000234 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3166 | 3166 | Edward Livingston L000366 | rep | LA | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
3167 | 3167 | Edward Livingston L000366 | rep | LA | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3168 | 3168 | Edward Livingston L000366 | sen | LA | 1829-12-07 | 1831-12-31 | 2 | Jackson | |||||||||||||
3169 | 3169 | John Magee M000047 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 28 | |||||||||||||
3170 | 3170 | John Magee M000047 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 28 | |||||||||||||
3171 | 3171 | Alem Marr M000141 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3172 | 3172 | William Martin M000202 | rep | SC | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
3173 | 3173 | William Martin M000202 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3174 | 3174 | Thomas Maxwell M000271 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 25 | |||||||||||||
3175 | 3175 | William McCreery M000386 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3178 | 3178 | John McLean M000550 | sen | IL | 1829-12-07 | 1831-03-03 | 2 | Jackson | |||||||||||||
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 | |||||||||||||
3184 | 3184 | Robert Monell M000853 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 21 | |||||||||||||
3185 | 3185 | Ebenezer Norton N000146 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 30 | |||||||||||||
3186 | 3186 | Walter Overton O000147 | rep | LA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3187 | 3187 | Spencer Pettis P000275 | rep | MO | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3190 | 3190 | Gershom Powers P000489 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 24 | |||||||||||||
3191 | 3191 | Thomas Reed R000129 | sen | MS | 1826-01-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
3195 | 3195 | James Ripley R000266 | rep | ME | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
3196 | 3196 | James Ripley R000266 | rep | ME | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3197 | 3197 | James Ripley R000266 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3201 | 3201 | Jonah Sanford S000050 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
3202 | 3202 | John Scott S000175 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3203 | 3203 | James Shields S000361 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3214 | 3214 | Alexander Smyth S000646 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 22 | |||||||||||||
3215 | 3215 | Alexander Smyth S000646 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3217 | 3217 | Richard Spencer S000729 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 7 |
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);