legislator_terms

Table actions Table actions

987 rows where state = "MD"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, phone, fax, contact_form, state_rank, rss_url, start (date), end (date)

Link rowid ▼ legislator_id type state start end class party district how party_affiliations caucus url address phone fax contact_form office state_rank rss_url end-type
4 4 C000187 rep MD 1789-03-04 1791-03-03     6                        
6 6 C000710 rep MD 1789-03-04 1791-03-03     3                        
11 11 G000012 rep MD 1789-03-04 1791-03-03     5                        
25 25 S000624 rep MD 1789-03-04 1791-03-03     4                        
26 26 S000961 rep MD 1789-03-04 1791-03-03     1                        
36 36 C000185 sen MD 1789-03-04 1791-03-03 1 Pro-Administration                          
37 37 C000185 sen MD 1791-10-24 1793-03-03 1                            
45 45 K000158 rep MD 1791-10-24 1793-03-03     1                        
50 50 S000242 rep MD 1789-03-04 1791-03-03     2                        
51 51 S000242 rep MD 1791-10-24 1793-03-03     2                        
52 52 S000340 rep MD 1791-10-24 1793-03-03     6                        
59 59 S000866 rep MD 1791-10-24 1793-03-03     4                        
71 71 P000473 sen MD 1793-01-10 1796-10-14 1 Federalist                          
88 88 E000060 rep MD 1793-12-02 1795-03-03     3                        
92 92 F000282 rep MD 1793-12-02 1795-03-03     3                        
110 110 M000645 rep MD 1791-10-24 1793-03-03     3                        
111 111 M000645 rep MD 1793-12-02 1795-03-03     2                        
156 156 C000848 rep MD 1795-12-07 1797-03-03   Federalist 3                        
159 159 D000578 rep MD 1793-12-02 1795-03-03   Republican 2                        
160 160 D000578 rep MD 1795-12-07 1797-03-03   Republican 2                        
176 176 H000508 sen MD 1789-03-04 1795-03-03 3 Pro-Administration                          
177 177 H000508 sen MD 1795-12-07 1797-12-31 3 Federalist                          
190 190 M001119 rep MD 1791-10-24 1793-03-03   Federalist 5                        
191 191 M001119 rep MD 1793-12-02 1795-03-03   Federalist 8                        
192 192 M001119 rep MD 1795-12-07 1797-03-03   Federalist 8                        
212 212 S000753 rep MD 1793-12-02 1795-03-03   Republican 4                        
213 213 S000753 rep MD 1795-12-07 1797-03-03   Republican 4                        
231 231 H000841 sen MD 1796-12-05 1797-03-04 1 Federalist                          
232 232 H000841 sen MD 1797-03-04 1803-03-03 1 Federalist                          
273 273 L000377 sen MD 1797-05-15 1801-03-03 3 Federalist                          
280 280 M000256 rep MD 1797-05-15 1799-03-03   Federalist 6                        
331 331 C000382 rep MD 1793-12-02 1795-03-03   Republican 6                        
332 332 C000382 rep MD 1795-12-07 1797-03-03   Republican 6                        
333 333 C000382 rep MD 1799-12-02 1801-03-03   Republican 6                        
338 338 C000863 rep MD 1795-12-07 1797-03-03   Federalist 3                        
339 339 C000863 rep MD 1797-05-15 1799-03-03   Federalist 3                        
340 340 C000863 rep MD 1799-12-02 1801-03-03   Federalist 3                        
348 348 D000254 rep MD 1793-12-02 1795-03-03   Federalist 1                        
349 349 D000254 rep MD 1795-12-07 1797-03-03   Federalist 1                        
350 350 D000254 rep MD 1797-05-15 1799-03-03   Federalist 1                        
351 351 D000254 rep MD 1799-12-02 1801-03-03   Federalist 1                        
439 439 T000173 rep MD 1799-12-02 1801-03-03   Federalist 2                        
449 449 H000629 rep MD 1791-10-24 1793-03-03   Federalist 2                        
450 450 H000629 rep MD 1793-12-02 1795-03-03   Federalist 7                        
451 451 H000629 rep MD 1795-12-07 1797-03-03   Federalist 7                        
452 452 H000629 rep MD 1797-05-15 1799-03-03   Federalist 7                        
453 453 H000629 sen MD 1800-01-01 1801-03-03 3 Federalist                          
528 528 S000752 rep MD 1795-12-07 1797-03-03   Republican 2                        
529 529 S000752 rep MD 1797-05-15 1799-03-03   Republican 2                        
530 530 S000752 rep MD 1801-12-07 1803-03-03   Republican 2                        
559 559 B000697 rep MD 1801-12-07 1803-03-03   Republican 2                        
560 560 B000697 rep MD 1803-10-17 1805-03-03   Republican 2                        
569 569 D000243 rep MD 1797-05-15 1799-03-03   Federalist 8                        
570 570 D000243 rep MD 1799-12-02 1801-03-03   Federalist 8                        
571 571 D000243 rep MD 1801-12-07 1803-03-03   Federalist 8                        
572 572 D000243 rep MD 1803-10-17 1805-03-03   Federalist 8                        
588 588 H000570 rep MD 1801-12-07 1803-03-03   Republican 4                        
589 589 H000570 rep MD 1803-10-17 1805-03-03   Republican 4                        
606 606 P000378 rep MD 1801-12-07 1803-03-03   Federalist 3                        
607 607 P000378 rep MD 1803-10-17 1805-03-03   Federalist 3                        
653 653 A000272 rep MD 1801-12-07 1803-03-03   Republican 6                        
654 654 A000272 rep MD 1803-10-17 1805-03-03   Republican 6                        
655 655 A000272 rep MD 1805-12-02 1807-03-03   Republican 6                        
679 679 C000817 rep MD 1805-12-02 1807-03-03   Republican 2                        
728 728 M000057 rep MD 1805-12-02 1807-03-03   Republican 3                        
734 734 N000100 rep MD 1799-12-02 1801-03-03   Republican 7                        
735 735 N000100 rep MD 1801-12-07 1803-03-03   Republican 7                        
736 736 N000100 rep MD 1803-10-17 1805-03-03   Republican 7                        
737 737 N000100 rep MD 1805-12-02 1807-03-03   Republican 7                        
871 871 M000387 rep MD 1803-10-17 1805-03-03   Republican 5                        
872 872 M000387 rep MD 1805-12-02 1807-03-03   Republican 5                        
873 873 M000387 rep MD 1807-10-26 1809-03-03   Republican 5                        
949 949 B000928 rep MD 1809-05-22 1811-03-03   Republican 7                        
953 953 C000091 rep MD 1801-12-07 1803-03-03   Federalist 1                        
954 954 C000091 rep MD 1803-10-17 1805-03-03   Federalist 1                        
955 955 C000091 rep MD 1805-12-02 1807-03-03   Federalist 1                        
956 956 C000091 rep MD 1807-10-26 1809-03-03   Federalist 1                        
957 957 C000091 rep MD 1809-05-22 1811-03-03   Federalist 1                        
1040 1040 N000041 rep MD 1803-10-17 1805-03-03   Republican 4                        
1041 1041 N000041 rep MD 1805-12-02 1807-03-03   Republican 4                        
1042 1042 N000041 rep MD 1807-10-26 1809-03-03   Republican 4                        
1043 1043 N000041 rep MD 1809-05-22 1811-03-03   Republican 4                        
1078 1078 V000043 rep MD 1807-10-26 1809-03-03   Republican 2                        
1079 1079 V000043 rep MD 1809-05-22 1811-03-03   Republican 2                        
1183 1183 K000159 rep MD 1807-10-26 1809-03-03   Federalist 3                        
1184 1184 K000159 rep MD 1809-05-22 1811-03-03   Federalist 3                        
1185 1185 K000159 rep MD 1811-11-04 1813-03-03   Federalist 3                        
1199 1199 M000867 rep MD 1807-10-26 1809-03-03   Republican 6                        
1200 1200 M000867 rep MD 1809-05-22 1811-03-03   Republican 6                        
1201 1201 M000867 rep MD 1811-11-04 1813-03-03   Republican -1                        
1375 1375 M000515 rep MD 1809-05-22 1811-03-03   Republican 5                        
1376 1376 M000515 rep MD 1811-11-04 1813-03-03   Republican 5                        
1377 1377 M000515 rep MD 1813-05-24 1815-03-03   Republican 5                        
1454 1454 B000026 rep MD 1797-05-15 1799-03-03   Federalist 4                        
1455 1455 B000026 rep MD 1799-12-02 1801-03-03   Federalist 4                        
1456 1456 B000026 rep MD 1815-12-04 1817-03-03   Federalist 4                        
1580 1580 G000261 rep MD 1805-12-02 1807-03-03   Federalist 8                        
1581 1581 G000261 rep MD 1807-10-26 1809-03-03   Federalist 8                        
1582 1582 G000261 rep MD 1809-05-22 1811-03-03   Federalist 8                        
1583 1583 G000261 rep MD 1811-11-04 1813-03-03   Federalist 8                        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, [caucus] TEXT, [url] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);