legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
515 rows where party = "Democrat" and state = "MA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, fax, contact_form, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4201 | 4201 | Richard Fletcher F000203 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4702 | 4702 | Nathaniel Borden B000636 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 10 | |||||||||||||
5258 | 5258 | William Parmenter P000076 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5259 | 5259 | William Parmenter P000076 | rep | MA | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5260 | 5260 | William Parmenter P000076 | rep | MA | 1841-05-31 | 1843-03-03 | Democrat | 4 | |||||||||||||
5261 | 5261 | William Parmenter P000076 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5324 | 5324 | Henry Williams W000503 | rep | MA | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
5325 | 5325 | Henry Williams W000503 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
6353 | 6353 | Edward Little L000350 | rep | MA | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
6390 | 6390 | Robert Rantoul R000063 | sen | MA | 1851-02-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6391 | 6391 | Robert Rantoul R000063 | rep | MA | 1851-03-04 | 1852-08-07 | Democrat | 2 | |||||||||||||
9440 | 9440 | Josiah Abbott A000007 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9485 | 9485 | Chester Chapin C000305 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 11 | |||||||||||||
9649 | 9649 | John Tarbox T000041 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9655 | 9655 | Charles Thompson T000195 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9687 | 9687 | William Warren W000168 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9784 | 9784 | Benjamin Dean D000170 | rep | MA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
11120 | 11120 | Henry Lovering L000464 | rep | MA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11121 | 11121 | Henry Lovering L000464 | rep | MA | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11311 | 11311 | Edward Burnett B001119 | rep | MA | 1887-12-05 | 1889-03-03 | Democrat | 9 | |||||||||||||
11325 | 11325 | Patrick Collins C000641 | rep | MA | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11326 | 11326 | Patrick Collins C000641 | rep | MA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11327 | 11327 | Patrick Collins C000641 | rep | MA | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11452 | 11452 | Leopold Morse M001012 | rep | MA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
11453 | 11453 | Leopold Morse M001012 | rep | MA | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
11454 | 11454 | Leopold Morse M001012 | rep | MA | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
11455 | 11455 | Leopold Morse M001012 | rep | MA | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11456 | 11456 | Leopold Morse M001012 | rep | MA | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
11497 | 11497 | John Russell R000530 | rep | MA | 1887-12-05 | 1889-03-03 | Democrat | 10 | |||||||||||||
11575 | 11575 | Nathaniel Banks B000116 | rep | MA | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
12067 | 12067 | John Andrew A000242 | rep | MA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12068 | 12068 | John Andrew A000242 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12138 | 12138 | Frederick Coolidge C000739 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12145 | 12145 | John Crosby C000929 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 12 | |||||||||||||
12208 | 12208 | Sherman Hoar H000657 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12364 | 12364 | George Williams W000497 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12540 | 12540 | William Everett E000269 | rep | MA | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12711 | 12711 | Joseph O’Neil O000092 | rep | MA | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12712 | 12712 | Joseph O’Neil O000092 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12713 | 12713 | Joseph O’Neil O000092 | rep | MA | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12806 | 12806 | Moses Stevens S000884 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12807 | 12807 | Moses Stevens S000884 | rep | MA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
13907 | 13907 | Joseph Conry C000706 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14109 | 14109 | Henry Naphen N000004 | rep | MA | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
14110 | 14110 | Henry Naphen N000004 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14498 | 14498 | John Thayer T000149 | rep | MA | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14499 | 14499 | John Thayer T000149 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14500 | 14500 | John Thayer T000149 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14822 | 14822 | William McNary M000584 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14823 | 14823 | William McNary M000584 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14914 | 14914 | John Sullivan S001055 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
14915 | 14915 | John Sullivan S001055 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
15456 | 15456 | Eugene Foss F000293 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 14 | |||||||||||||
15573 | 15573 | John Keliher K000055 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
15574 | 15574 | John Keliher K000055 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
15575 | 15575 | John Keliher K000055 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
15576 | 15576 | John Keliher K000055 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
15673 | 15673 | Joseph O’Connell O000026 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15674 | 15674 | Joseph O’Connell O000026 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
16212 | 16212 | John Thayer T000147 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16343 | 16343 | Frederick Deitrick D000201 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16370 | 16370 | Edward Gilmore G000221 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16488 | 16488 | John Mitchell M000820 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
16489 | 16489 | John Mitchell M000820 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16497 | 16497 | William Murray M001117 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
16498 | 16498 | William Murray M001117 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16526 | 16526 | Andrew Peters P000251 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
16527 | 16527 | Andrew Peters P000251 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
16528 | 16528 | Andrew Peters P000251 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 11 | |||||||||||||
16529 | 16529 | Andrew Peters P000251 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
16612 | 16612 | Thomas Thacher T000140 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17698 | 17698 | John Fitzgerald F000164 | rep | MA | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
17699 | 17699 | John Fitzgerald F000164 | rep | MA | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
17700 | 17700 | John Fitzgerald F000164 | rep | MA | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
17701 | 17701 | John Fitzgerald F000164 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17875 | 17875 | Richard Olney O000080 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17876 | 17876 | Richard Olney O000080 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17877 | 17877 | Richard Olney O000080 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17882 | 17882 | Michael Phelan P000291 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17883 | 17883 | Michael Phelan P000291 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17884 | 17884 | Michael Phelan P000291 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17885 | 17885 | Michael Phelan P000291 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18862 | 18862 | Peter Tague T000014 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18863 | 18863 | Peter Tague T000014 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18864 | 18864 | Peter Tague T000014 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18865 | 18865 | Peter Tague T000014 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18866 | 18866 | Peter Tague T000014 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
19308 | 19308 | James Gallivan G000024 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
19309 | 19309 | James Gallivan G000024 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
19310 | 19310 | James Gallivan G000024 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
19311 | 19311 | James Gallivan G000024 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
19312 | 19312 | James Gallivan G000024 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
19313 | 19313 | James Gallivan G000024 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
19314 | 19314 | James Gallivan G000024 | rep | MA | 1925-12-07 | 1927-03-04 | Democrat | 12 | |||||||||||||
19315 | 19315 | James Gallivan G000024 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
20230 | 20230 | Marcus Coolidge C000740 | sen | MA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
21236 | 21236 | John Douglass D000459 | rep | MA | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
21237 | 21237 | John Douglass D000459 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
21238 | 21238 | John Douglass D000459 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
21239 | 21239 | John Douglass D000459 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 10 |
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);