legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
133 rows where party = "Whig" and state = "MA"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3938 | 3938 | Samuel Hoar H000656 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4214 | 4214 | George Grennell G000451 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
4215 | 4215 | George Grennell G000451 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
4216 | 4216 | George Grennell G000451 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 6 | |||||||||||||
4217 | 4217 | George Grennell G000451 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4218 | 4218 | George Grennell G000451 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4319 | 4319 | Stephen Phillips P000312 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4320 | 4320 | Stephen Phillips P000312 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
4321 | 4321 | Stephen Phillips P000312 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4532 | 4532 | Abbott Lawrence L000130 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4533 | 4533 | Abbott Lawrence L000130 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4587 | 4587 | John Reed R000121 | rep | MA | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
4590 | 4590 | John Reed R000121 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4591 | 4591 | John Reed R000121 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
4592 | 4592 | John Reed R000121 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 11 | |||||||||||||
4594 | 4594 | John Reed R000121 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4595 | 4595 | John Reed R000121 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4666 | 4666 | Nathan Appleton A000269 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
4688 | 4688 | Isaac Bates B000233 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 8 | |||||||||||||
4689 | 4689 | Isaac Bates B000233 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 8 | |||||||||||||
4690 | 4690 | Isaac Bates B000233 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 8 | |||||||||||||
4691 | 4691 | Isaac Bates B000233 | sen | MA | 1841-05-31 | 1845-12-31 | 2 | Whig | |||||||||||||
4703 | 4703 | Nathaniel Borden B000636 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
4707 | 4707 | George Briggs B000830 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 9 | |||||||||||||
4708 | 4708 | George Briggs B000830 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
4709 | 4709 | George Briggs B000830 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
4710 | 4710 | George Briggs B000830 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4711 | 4711 | George Briggs B000830 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4712 | 4712 | George Briggs B000830 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
4723 | 4723 | William Calhoun C000046 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4724 | 4724 | William Calhoun C000046 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4725 | 4725 | William Calhoun C000046 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4726 | 4726 | William Calhoun C000046 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
4741 | 4741 | Rufus Choate C000375 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 2 | |||||||||||||
4742 | 4742 | Rufus Choate C000375 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4743 | 4743 | Rufus Choate C000375 | sen | MA | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
4758 | 4758 | Caleb Cushing C001016 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
4759 | 4759 | Caleb Cushing C001016 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4760 | 4760 | Caleb Cushing C001016 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4761 | 4761 | Caleb Cushing C001016 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
4826 | 4826 | William Hastings H000332 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
4827 | 4827 | William Hastings H000332 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
4828 | 4828 | William Hastings H000332 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 9 | |||||||||||||
4859 | 4859 | Levi Lincoln L000315 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4860 | 4860 | Levi Lincoln L000315 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4861 | 4861 | Levi Lincoln L000315 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4862 | 4862 | Levi Lincoln L000315 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
4985 | 4985 | Leverett Saltonstall S000020 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4986 | 4986 | Leverett Saltonstall S000020 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4987 | 4987 | Leverett Saltonstall S000020 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5120 | 5120 | Osmyn Baker B000071 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5121 | 5121 | Osmyn Baker B000071 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5122 | 5122 | Osmyn Baker B000071 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5152 | 5152 | Barker Burnell B001114 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
5153 | 5153 | Barker Burnell B001114 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5569 | 5569 | Daniel Webster W000238 | sen | MA | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
5570 | 5570 | Daniel Webster W000238 | sen | MA | 1839-12-02 | 1841-02-22 | 1 | Whig | |||||||||||||
5571 | 5571 | Daniel Webster W000238 | sen | MA | 1845-12-01 | 1850-07-22 | 1 | Whig | |||||||||||||
5588 | 5588 | Amos Abbott A000004 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5589 | 5589 | Amos Abbott A000004 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5590 | 5590 | Amos Abbott A000004 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5592 | 5592 | John Adams A000041 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 11 | |||||||||||||
5595 | 5595 | John Adams A000041 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
5596 | 5596 | John Adams A000041 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5597 | 5597 | John Adams A000041 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5598 | 5598 | John Adams A000041 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5599 | 5599 | John Adams A000041 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5600 | 5600 | John Adams A000041 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5665 | 5665 | John Davis D000117 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 5 | |||||||||||||
5666 | 5666 | John Davis D000117 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 5 | |||||||||||||
5667 | 5667 | John Davis D000117 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 5 | |||||||||||||
5668 | 5668 | John Davis D000117 | sen | MA | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
5669 | 5669 | John Davis D000117 | sen | MA | 1845-12-01 | 1847-03-03 | 2 | Whig | |||||||||||||
5670 | 5670 | John Davis D000117 | sen | MA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5709 | 5709 | Artemas Hale H000028 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5710 | 5710 | Artemas Hale H000028 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5726 | 5726 | Charles Hudson H000907 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
5727 | 5727 | Charles Hudson H000907 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5728 | 5728 | Charles Hudson H000907 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
5729 | 5729 | Charles Hudson H000907 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5799 | 5799 | John Palfrey P000033 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5894 | 5894 | George Ashmun A000318 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5895 | 5895 | George Ashmun A000318 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5896 | 5896 | George Ashmun A000318 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5970 | 5970 | Samuel Eliot E000105 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5984 | 5984 | Joseph Grinnell G000477 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5985 | 5985 | Joseph Grinnell G000477 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
5986 | 5986 | Joseph Grinnell G000477 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5987 | 5987 | Joseph Grinnell G000477 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 10 | |||||||||||||
6026 | 6026 | Daniel King K000198 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
6027 | 6027 | Daniel King K000198 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6028 | 6028 | Daniel King K000198 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
6029 | 6029 | Daniel King K000198 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6198 | 6198 | Robert Winthrop W000646 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
6199 | 6199 | Robert Winthrop W000646 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
6200 | 6200 | Robert Winthrop W000646 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
6201 | 6201 | Robert Winthrop W000646 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6202 | 6202 | Robert Winthrop W000646 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6203 | 6203 | Robert Winthrop W000646 | sen | MA | 1850-01-01 | 1851-03-03 | 1 | Whig |
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);