congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
338 rows where party = "Jackson" sorted by full_name
This data as json, CSV (advanced)
Suggested facets: district, first_served, last_served, ballotpedia_id, terms_count, served_until, trade_count, first_served (date), last_served (date), birthday (date), served_until (date)
| bioguide_id | first_name | last_name | full_name ▼ | nickname | party | state | chamber | district | first_served | last_served | is_current | opensecrets_id | fec_ids | govtrack_id | thomas_id | votesmart_id | lis_id | wikipedia_id | ballotpedia_id | birthday | gender | terms_count | served_until | trade_count | speech_count | bills_sponsored | vote_count | fec_total_received |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| H000994 | Abel | Huntington | Abel Huntington | Jackson | NY | House | 1 | 1833-12-02 | 1837-03-03 | 0 | [] | 405834 | Abel Huntington | 1777-02-21 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000099 | Abijah | Mann | Abijah Mann | Jackson | NY | House | 16 | 1833-12-02 | 1837-03-03 | 0 | [] | 407123 | Abijah Mann Jr. | 1793-09-24 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000581 | Abraham | Bockee | Abraham Bockee | Jackson | NY | House | 5 | 1829-12-07 | 1837-03-03 | 0 | [] | 401552 | Abraham Bockee | 1784-02-03 | M | 5 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000089 | Adam | Alexander | Adam Alexander | Jackson | TN | House | 9 | 1823-12-01 | 1827-03-03 | 0 | [] | 400748 | Adam Rankin Alexander | 1781-11-01 | M | 3 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H001000 | Adam | Huntsman | Adam Huntsman | Jackson | TN | House | 12 | 1835-12-07 | 1837-03-03 | 0 | [] | 405840 | Adam Huntsman | 1786-02-11 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000192 | Adam | King | Adam King | Jackson | PA | House | 10 | 1827-12-03 | 1833-03-03 | 0 | [] | 406353 | Adam King (congressman) | 1783-01-20 | M | 4 | 1833-03-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| H000360 | Albert | Hawes | Albert Hawes | Jackson | KY | House | 2 | 1831-12-05 | 1837-03-03 | 0 | [] | 405229 | Albert Gallatin Hawes | 1804-04-01 | M | 4 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000079 | Albion | Parris | Albion Parris | Jackson | ME | Senate | 1815-12-04 | 1829-03-03 | 0 | [] | 408489 | Albion Parris | 1788-01-19 | M | 3 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| M000141 | Alem | Marr | Alem Marr | Jackson | PA | House | 9 | 1829-12-07 | 1831-03-03 | 0 | [] | 407164 | Alem Marr | 1787-06-18 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B001030 | Alexander | Buckner | Alexander Buckner | Jackson | MO | Senate | 1831-12-05 | 1833-12-31 | 0 | [] | 401980 | Alexander Buckner | M | 1 | 1833-12-31 | 0 | 0 | 0 | 0 | 0 | ||||||||
| S000646 | Alexander | Smyth | Alexander Smyth | Jackson | VA | House | 22 | 1817-12-01 | 1831-03-03 | 0 | [] | 410120 | Alexander Smyth | M | 8 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| T000227 | Alexander | Thomson | Alexander Thomson | Jackson | PA | House | 13 | 1823-12-01 | 1827-03-03 | 0 | [] | 410806 | Alexander Thomson (congressman) | 1788-01-12 | M | 3 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000057 | Amos | Lane | Amos Lane | Jackson | IN | House | 4 | 1833-12-02 | 1837-03-03 | 0 | [] | 406566 | Amos Lane | 1778-03-01 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000286 | Andrew | Beaumont | Andrew Beaumont | Jackson | PA | House | 15 | 1833-12-02 | 1837-03-03 | 0 | [] | 401280 | Andrew Beaumont | 1790-01-24 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000346 | Andrew | Govan | Andrew Govan | Jackson | SC | House | 4 | 1821-12-03 | 1827-03-03 | 0 | [] | 404702 | Andrew R. Govan | 1794-01-13 | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000279 | Andrew | Judson | Andrew Judson | Jackson | CT | House | -1 | 1835-12-07 | 1837-03-03 | 0 | [] | 406171 | Andrew T. Judson | 1784-11-29 | M | 2 | 1837-03-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| S000891 | Andrew | Stevenson | Andrew Stevenson | Jackson | VA | House | 11 | 1821-12-03 | 1835-03-03 | 0 | [] | 410352 | Andrew Stevenson | 1784-01-21 | M | 8 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000586 | Archibald | McNeill | Archibald McNeill | Jackson | NC | House | 7 | 1821-12-03 | 1827-03-03 | 0 | [] | 412168 | Archibald McNeill | M | 4 | 1827-03-03 | 2 | 0 | 0 | 0 | 0 | |||||||
| C000491 | Augustin | Clayton | Augustin Clayton | Jackson | GA | House | -1 | 1831-12-05 | 1835-03-03 | 0 | [] | 402629 | Augustin S. Clayton | 1783-11-27 | M | 3 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000212 | Benjamin | Jones | Benjamin Jones | Jackson | OH | House | 18 | 1833-12-02 | 1837-03-03 | 0 | [] | 406107 | Benjamin Jones (congressman) | 1787-04-13 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000277 | Benning | Bean | Benning Bean | Jackson | NH | House | -1 | 1833-12-02 | 1837-03-03 | 0 | [] | 401271 | Benning M. Bean | 1782-01-09 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000224 | Burwell | Bassett | Burwell Bassett | Jackson | VA | House | 8 | 1805-12-02 | 1829-03-03 | 0 | [] | 401220 | Burwell Bassett | 1764-03-18 | M | 13 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000585 | Charles | Bodle | Charles Bodle | Jackson | NY | House | 7 | 1833-12-02 | 1835-03-03 | 0 | [] | 401555 | Charles Bodle | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000162 | Charles | Dayan | Charles Dayan | Jackson | NY | House | 20 | 1831-12-05 | 1833-03-03 | 0 | [] | 403294 | Charles Dayan | 1792-07-08 | M | 2 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000284 | Charles | De Witt | Charles De Witt | Jackson | NY | House | 7 | 1829-12-07 | 1831-03-03 | 0 | [] | 403326 | Charles G. DeWitt | 1789-11-07 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000511 | Charles | Dudley | Charles Dudley | Jackson | NY | Senate | 1829-12-07 | 1833-03-03 | 0 | [] | 403621 | Charles E. Dudley | 1780-05-23 | M | 1 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| J000185 | Charles | Johnston | Charles Johnston | Jackson | VA | House | 22 | 1831-12-05 | 1833-03-03 | 0 | [] | 406080 | Charles Clement Johnston | 1795-04-30 | M | 2 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000063 | Charles | Kellogg | Charles Kellogg | Jackson | NY | House | 24 | 1825-12-05 | 1827-03-03 | 0 | [] | 406233 | Charles Kellogg (congressman) | 1773-10-03 | M | 2 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000607 | Charles | McVean | Charles McVean | Jackson | NY | House | 15 | 1833-12-02 | 1835-03-03 | 0 | [] | 407596 | Charles McVean | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000474 | Charles | Slade | Charles Slade | Jackson | IL | House | 1 | 1833-12-02 | 1835-03-03 | 0 | [] | 412097 | Charles Slade | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| F000290 | Chauncey | Forward | Chauncey Forward | Jackson | PA | House | 13 | 1825-12-05 | 1831-03-03 | 0 | [] | 404240 | Chauncey Forward | 1793-02-04 | M | 4 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000541 | Chittenden | Lyon | Chittenden Lyon | Jackson | KY | House | 1 | 1827-12-03 | 1835-03-03 | 0 | [] | 407025 | Chittenden Lyon | 1787-02-22 | M | 5 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000054 | Christopher | Rankin | Christopher Rankin | Jackson | MS | House | 1 | 1819-12-06 | 1827-03-03 | 0 | [] | 409034 | Christopher Rankin | M | 5 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000715 | Cornelius | Holland | Cornelius Holland | Jackson | ME | House | 5 | 1829-12-07 | 1833-03-03 | 0 | [] | 405567 | Cornelius Holland (politician) | 1783-07-09 | M | 3 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000131 | Cornelius | Lawrence | Cornelius Lawrence | Jackson | NY | House | 3 | 1833-12-02 | 1835-03-03 | 0 | [] | 406636 | Cornelius Lawrence | 1791-02-28 | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000083 | Daniel | Garrison | Daniel Garrison | Jackson | NJ | House | -1 | 1823-12-01 | 1827-03-03 | 0 | [] | 404455 | Daniel Garrison | 1782-04-03 | M | 3 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000722 | Daniel | Miller | Daniel Miller | Jackson | PA | House | 3 | 1823-12-01 | 1831-03-03 | 0 | [] | 412077 | Daniel H. Miller | M | 5 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| N000071 | Daniel | Newnan | Daniel Newnan | Jackson | GA | House | -1 | 1831-12-05 | 1833-03-03 | 0 | [] | 412170 | Daniel Newnan | M | 2 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| T000418 | Daniel | Turner | Daniel Turner | Jackson | NC | House | 6 | 1827-12-03 | 1829-03-03 | 0 | [] | 410987 | Daniel Turner (North Carolina politician) | 1796-09-21 | M | 2 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000146 | Daniel | Wardwell | Daniel Wardwell | Jackson | NY | House | 18 | 1831-12-05 | 1837-03-03 | 0 | [] | 411320 | Daniel Wardwell | 1791-05-28 | M | 4 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000058 | David | Baker | David Baker | Jackson | IL | Senate | 1830-01-01 | 1831-03-03 | 0 | [] | 401063 | David J. Baker | 1792-09-07 | M | 1 | 1831-03-03 | 1 | 0 | 0 | 0 | 0 | |||||||
| F000022 | Dudley | Farlin | Dudley Farlin | Jackson | NY | House | 13 | 1835-12-07 | 1837-03-03 | 0 | [] | 403984 | Dudley Farlin | 1777-09-02 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000233 | Dudley | Selden | Dudley Selden | Jackson | NY | House | 3 | 1833-12-02 | 1835-03-03 | 0 | [] | 412095 | Dudley Selden | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| N000146 | Ebenezer | Norton | Ebenezer Norton | Jackson | NY | House | 30 | 1829-12-07 | 1831-03-03 | 0 | [] | 408229 | Ebenezer F. Norton | 1774-11-07 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000512 | Edward | Dudley | Edward Dudley | Jackson | NC | House | 5 | 1829-12-07 | 1831-03-03 | 0 | [] | 403622 | Edward Bishop Dudley | 1789-12-15 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000860 | Edward | Howell | Edward Howell | Jackson | NY | House | 27 | 1833-12-02 | 1835-03-03 | 0 | [] | 405707 | Edward Howell (politician) | 1792-10-16 | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000022 | Edward | Kavanagh | Edward Kavanagh | Jackson | ME | House | 3 | 1831-12-05 | 1835-03-03 | 0 | [] | 406193 | Edward Kavanagh | 1795-04-27 | M | 3 | 1835-03-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| L000366 | Edward | Livingston | Edward Livingston | Jackson | LA | Senate | 1795-12-07 | 1831-12-31 | 0 | [] | 406858 | Edward Livingston | 1764-05-28 | M | 7 | 1831-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000376 | Edward | Lloyd | Edward Lloyd | Jackson | MD | Senate | 1805-12-02 | 1827-03-03 | 0 | [] | 406868 | Edward Lloyd (Governor of Maryland) | 1779-07-22 | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000490 | Edward | Lucas | Edward Lucas | Jackson | VA | House | 15 | 1833-12-02 | 1837-03-03 | 0 | [] | 406978 | Edward Lucas (congressman) | 1780-10-20 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000115 | Edward | Reed | Edward Reed | Jackson | NY | House | 22 | 1831-12-05 | 1833-03-03 | 0 | [] | 409095 | Edward C. Reed | 1793-03-08 | M | 2 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000051 | Edward | Tattnall | Edward Tattnall | Jackson | GA | House | 1 | 1821-12-03 | 1829-03-03 | 0 | [] | 410639 | Edward F. Tattnall | M | 5 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| T000125 | Egbert | Ten Eyck | Egbert Ten Eyck | Jackson | NY | House | 20 | 1823-12-01 | 1827-03-03 | 0 | [] | 410704 | Egbert Ten Eyck | 1779-04-18 | M | 3 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000912 | Elias | Brown | Elias Brown | Jackson | MD | House | 5 | 1829-12-07 | 1831-03-03 | 0 | [] | 401868 | Elias Brown | 1793-05-09 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000006 | Elias | Kane | Elias Kane | Jackson | IL | Senate | 1825-12-05 | 1835-12-31 | 0 | [] | 406180 | Elias Kane | 1794-06-07 | M | 2 | 1835-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000576 | Ephraim | Wilson | Ephraim Wilson | Jackson | MD | House | 8 | 1827-12-03 | 1831-03-03 | 0 | [] | 411731 | Ephraim King Wilson | 1771-09-15 | M | 3 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000431 | Erastus | Root | Erastus Root | Jackson | NY | House | 11 | 1803-10-17 | 1833-03-03 | 0 | [] | 409396 | Erastus Root | 1773-03-16 | M | 16 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| V000044 | Espy | Van Horne | Espy Van Horne | Jackson | PA | House | 9 | 1825-12-05 | 1829-03-03 | 0 | [] | 411088 | Espy Van Horne | 1825-03-04 | M | 3 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000334 | Ether | Shepley | Ether Shepley | Jackson | ME | Senate | 1833-12-02 | 1837-03-03 | 0 | [] | 409831 | Ether Shepley | 1789-11-02 | M | 1 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| M000625 | Ezra | Meech | Ezra Meech | Jackson | VT | House | 4 | 1819-12-06 | 1827-03-03 | 0 | [] | 407614 | Ezra Meech | 1773-07-26 | M | 5 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000116 | Ferdinand | Schenck | Ferdinand Schenck | Jackson | NJ | House | -1 | 1833-12-02 | 1837-03-03 | 0 | [] | 409624 | Ferdinand Schureman Schenck | 1790-02-11 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000255 | Francis | Baylies | Francis Baylies | Jackson | MA | House | 12 | 1821-12-03 | 1827-03-03 | 0 | [] | 401249 | Francis Baylies | 1783-10-16 | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000397 | Franklin | Plummer | Franklin Plummer | Jackson | MS | House | -1 | 1831-12-05 | 1835-03-03 | 0 | [] | 412088 | Franklin E. Plummer | M | 3 | 1835-03-03 | 1 | 0 | 0 | 0 | 0 | |||||||
| J000104 | Freeborn | Jewett | Freeborn Jewett | Jackson | NY | House | 23 | 1831-12-05 | 1833-03-03 | 0 | [] | 406006 | Freeborn G. Jewett | 1791-08-04 | M | 2 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000898 | Gabriel | Moore | Gabriel Moore | Jackson | AL | Senate | 1821-12-03 | 1837-03-03 | 0 | [] | 407870 | Gabriel Moore | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| O000115 | Gayton | Osgood | Gayton Osgood | Jackson | MA | House | 3 | 1833-12-02 | 1835-03-03 | 0 | [] | 408371 | Gayton P. Osgood | 1797-07-04 | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000324 | George | Belden | George Belden | Jackson | NY | House | 7 | 1827-12-03 | 1829-03-03 | 0 | [] | 401316 | George O. Belden | 1797-03-28 | M | 2 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000433 | George | Bibb | George Bibb | Jackson | KY | Senate | 1811-11-04 | 1835-03-03 | 0 | [] | 401419 | George M. Bibb | 1776-10-30 | M | 5 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000212 | George | Cary | George Cary | Jackson | GA | House | -1 | 1823-12-01 | 1827-03-03 | 0 | [] | 402358 | George Cary (Georgia politician) | 1789-08-07 | M | 3 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000234 | George | Cassedy | George Cassedy | Jackson | NJ | House | -1 | 1821-12-03 | 1827-03-03 | 0 | [] | 402379 | George Cassedy | 1783-09-16 | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000956 | George | Crump | George Crump | Jackson | VA | House | 5 | 1825-12-05 | 1827-03-03 | 0 | [] | 403068 | George William Crump | 1786-09-26 | M | 2 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000011 | George | Dallas | George Dallas | Jackson | PA | Senate | 1831-12-05 | 1833-03-03 | 0 | [] | 403154 | George M. Dallas | 1792-07-10 | M | 1 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000216 | George | Gilmer | George Gilmer | Jackson | GA | House | -1 | 1821-12-03 | 1835-03-03 | 0 | [] | 404578 | George R. Gilmer | 1790-04-11 | M | 8 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000711 | George | Holcombe | George Holcombe | Jackson | NJ | House | -1 | 1821-12-03 | 1829-03-03 | 0 | [] | 405564 | George Holcombe | M | 5 | 1829-03-03 | 2 | 0 | 0 | 0 | 0 | |||||||
| K000224 | George | Kinnard | George Kinnard | Jackson | IN | House | 6 | 1833-12-02 | 1837-03-03 | 0 | [] | 406383 | George L. Kinnard | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000329 | George | Kremer | George Kremer | Jackson | PA | House | 9 | 1823-12-01 | 1829-03-03 | 0 | [] | 406483 | George Kremer | 1775-11-21 | M | 4 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000234 | George | Leiper | George Leiper | Jackson | PA | House | 4 | 1829-12-07 | 1831-03-03 | 0 | [] | 406737 | George Gray Leiper | 1786-02-03 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000488 | George | Loyall | George Loyall | Jackson | VA | House | 1 | 1829-12-07 | 1837-03-03 | 0 | [] | 406976 | George Loyall | 1789-05-29 | M | 5 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000810 | George | Mitchell | George Mitchell | Jackson | MD | House | 6 | 1823-12-01 | 1833-03-03 | 0 | [] | 407785 | George Edward Mitchell | 1781-03-03 | M | 6 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000150 | George | Owen | George Owen | Jackson | AL | House | 3 | 1823-12-01 | 1829-03-03 | 0 | [] | 408401 | George W. Owen | 1796-10-20 | M | 4 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000250 | George | Peter | George Peter | Jackson | MD | House | 3 | 1815-12-04 | 1827-03-03 | 0 | [] | 408653 | George Peter (politician, born 1779) | 1779-09-28 | M | 7 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000392 | George | Plumer | George Plumer | Jackson | PA | House | 17 | 1821-12-03 | 1827-03-03 | 0 | [] | 408786 | George Plumer | 1762-12-05 | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000402 | George | Poindexter | George Poindexter | Jackson | MS | Senate | 1807-10-26 | 1835-03-03 | 0 | [] | 408795 | George Poindexter | M | 5 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| T000382 | George | Troup | George Troup | Jackson | GA | Senate | 1807-10-26 | 1833-11-08 | 0 | [] | 410951 | George Troup | 1780-09-08 | M | 5 | 1833-11-08 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000673 | George | Wolf | George Wolf | Jackson | PA | House | 8 | 1823-12-01 | 1831-03-03 | 0 | [] | 411825 | George Wolf | 1777-08-12 | M | 5 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000086 | Gerrit | Lansing | Gerrit Lansing | Jackson | NY | House | 10 | 1831-12-05 | 1837-03-03 | 0 | [] | 406595 | Gerrit Y. Lansing | 1783-08-04 | M | 4 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000489 | Gershom | Powers | Gershom Powers | Jackson | NY | House | 24 | 1829-12-07 | 1831-03-03 | 0 | [] | 408874 | Gershom Powers | 1789-07-11 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000193 | Gideon | Lee | Gideon Lee | Jackson | NY | House | 3 | 1835-12-07 | 1837-03-03 | 0 | [] | 406696 | Gideon Lee | 1778-04-27 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000074 | Gorham | Parks | Gorham Parks | Jackson | ME | House | 8 | 1833-12-02 | 1837-03-03 | 0 | [] | 408484 | Gorham Parks | 1794-05-27 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000306 | Graham | Chapin | Graham Chapin | Jackson | NY | House | 25 | 1835-12-07 | 1837-03-03 | 0 | [] | 402448 | Graham H. Chapin | 1799-02-10 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| V000089 | Gulian | Verplanck | Gulian Verplanck | Jackson | NY | House | 3 | 1825-12-05 | 1833-03-03 | 0 | [] | 411144 | Gulian C. Verplanck | 1786-08-06 | M | 5 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000018 | Harry | Cage | Harry Cage | Jackson | MS | House | -1 | 1833-12-02 | 1835-03-03 | 0 | [] | 412022 | Harry Cage | M | 2 | 1835-03-03 | 2 | 0 | 0 | 0 | 0 | |||||||
| C000856 | Hector | Craig | Hector Craig | Jackson | NY | House | 6 | 1823-12-01 | 1831-03-03 | 0 | [] | 402972 | Hector Craig | M | 5 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| A000313 | Henry | Ashley | Henry Ashley | Jackson | NY | House | 11 | 1825-12-05 | 1827-03-03 | 0 | [] | 400957 | Henry Ashley (American politician) | 1778-02-19 | M | 2 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000284 | Henry | Chambers | Henry Chambers | Jackson | AL | Senate | 1825-12-05 | 1827-03-03 | 0 | [] | 402427 | Henry H. Chambers | 1790-10-01 | M | 1 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000033 | Henry | Daniel | Henry Daniel | Jackson | KY | House | 1 | 1827-12-03 | 1833-03-03 | 0 | [] | 403173 | Henry Daniel (politician) | 1786-03-15 | M | 4 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| E000070 | Henry | Edwards | Henry Edwards | Jackson | CT | Senate | 1819-12-06 | 1827-03-03 | 0 | [] | 403763 | Henry W. Edwards | M | 2 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| H000787 | Henry | Horn | Henry Horn | Jackson | PA | House | 2 | 1831-12-05 | 1833-03-03 | 0 | [] | 405637 | Henry Horn | M | 2 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000202 | Henry | King | Henry King | Jackson | PA | House | 8 | 1831-12-05 | 1835-03-03 | 0 | [] | 406363 | Henry King (congressman) | 1790-07-06 | M | 3 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000027 | Henry | Lamar | Henry Lamar | Jackson | GA | House | -1 | 1829-12-07 | 1833-03-03 | 0 | [] | 406537 | Henry G. Lamar | 1798-07-10 | M | 3 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE congress_members (
bioguide_id TEXT PRIMARY KEY,
first_name TEXT,
last_name TEXT,
full_name TEXT,
nickname TEXT,
party TEXT,
state TEXT,
chamber TEXT,
district INTEGER,
first_served TEXT,
last_served TEXT,
is_current INTEGER,
opensecrets_id TEXT,
fec_ids TEXT,
govtrack_id INTEGER,
thomas_id TEXT,
votesmart_id INTEGER,
lis_id TEXT,
wikipedia_id TEXT,
ballotpedia_id TEXT,
birthday TEXT,
gender TEXT,
terms_count INTEGER,
served_until TEXT
, trade_count INTEGER DEFAULT 0, speech_count INTEGER DEFAULT 0, bills_sponsored INTEGER DEFAULT 0, vote_count INTEGER DEFAULT 0, fec_total_received INTEGER DEFAULT 0);
CREATE INDEX idx_cm_name ON congress_members(last_name, first_name);
CREATE INDEX idx_cm_party ON congress_members(party);
CREATE INDEX idx_cm_state ON congress_members(state);
CREATE INDEX idx_cm_chamber ON congress_members(chamber);
CREATE INDEX idx_cm_current ON congress_members(is_current);
CREATE INDEX idx_cm_current_trades ON congress_members(is_current DESC, trade_count DESC);