legislator_terms

Table actions Table actions

478 rows where "start" is on date 1971-01-21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, party, 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
29526 29526 A000002 rep VA 1971-01-21 1973-01-03   Democrat 4                        
29541 29541 A000016 rep MS 1971-01-21 1973-01-03   Democrat 1                        
29545 29545 A000203 rep TN 1971-01-21 1973-01-03   Democrat 6                        
29546 29546 A000205 rep AL 1971-01-21 1973-01-03   Democrat 3                        
29561 29561 A000206 rep AL 1971-01-21 1973-01-03   Democrat 3                        
29573 29573 A000225 rep CO 1971-01-21 1973-01-03   Democrat 4                        
29583 29583 B000141 rep NV 1971-01-21 1973-01-03   Democrat 0                        
29585 29585 B000272 sen MD 1971-01-21 1977-01-03 1 Republican                          
29586 29586 B000315 rep AK 1971-01-21 1973-01-03   Democrat 0                        
29597 29597 B000323 rep OK 1971-01-21 1973-01-03   Republican 1                        
29608 29608 B000426 rep OH 1971-01-21 1973-01-03   Republican 8                        
29611 29611 B000548 rep TN 1971-01-21 1973-01-03   Democrat 7                        
29625 29625 B000594 rep LA 1971-01-21 1972-10-16   Democrat 2                        
29636 29636 B000676 rep OH 1971-01-21 1973-01-03   Republican 16                        
29641 29641 B000851 sen TN 1971-01-21 1977-01-03 1 Republican                          
29642 29642 B001026 sen NY 1971-01-21 1977-01-03 1 Conservative                          
29652 29652 B001212 rep PA 1971-01-21 1973-01-03   Democrat 3                        
29666 29666 B001216 rep WI 1971-01-21 1973-01-03   Republican 8                        
29670 29670 C000002 rep TX 1971-01-21 1973-01-03   Democrat 5                        
29672 29672 C000017 rep LA 1971-01-21 1973-01-03   Democrat 3                        
29673 29673 C000153 rep IL 1971-01-21 1973-01-03   Republican 15                        
29698 29698 C000264 rep NY 1971-01-21 1973-01-03   Democrat 10                        
29718 29718 C000645 rep MS 1971-01-21 1973-01-03   Democrat 5                        
29719 29719 C000702 rep PA 1971-01-21 1973-01-03   Republican 27                        
29734 29734 C000772 rep PA 1971-01-21 1973-01-03   Republican 18                        
29735 29735 C000997 rep KY 1971-01-21 1973-01-03   Democrat 6                        
29737 29737 C000775 rep PR 1971-01-21 1973-01-03   New Progressive 0                        
29740 29740 D000462 rep NY 1971-01-21 1973-01-03   Democrat 27                        
29751 29751 D000467 rep TX 1971-01-21 1973-01-03   Democrat 2                        
29759 29759 D000587 rep NJ 1971-01-21 1973-01-03   Republican 12                        
29769 29769 E000054 rep OK 1971-01-21 1973-01-03   Democrat 2                        
29773 29773 E000067 rep LA 1971-01-21 1973-01-03   Democrat 7                        
29775 29775 F000013 sen AZ 1971-01-21 1977-01-03 1 Republican                          
29778 29778 F000245 sen HI 1971-01-21 1977-01-03 1 Republican                          
29792 29792 F000422 rep PA 1971-01-21 1973-01-03   Republican 27                        
29795 29795 G000015 rep NC 1971-01-21 1973-01-03   Democrat 4                        
29802 29802 G000016 rep NJ 1971-01-21 1973-01-03   Democrat 13                        
29816 29816 G000071 rep MD 1971-01-21 1973-01-03   Democrat 3                        
29819 29819 G000458 rep MS 1971-01-21 1973-01-03   Democrat 3                        
29825 29825 H000010 rep GA 1971-01-21 1973-01-03   Democrat 1                        
29831 29831 H000049 rep MO 1971-01-21 1973-01-03   Republican 7                        
29838 29838 H000085 rep NY 1971-01-21 1973-01-03   Republican 6                        
29841 29841 H000291 sen MI 1971-01-21 1977-01-03 1 Democrat                          
29844 29844 H000297 sen IN 1971-01-21 1977-01-03 1 Democrat                          
29845 29845 H000566 rep MA 1971-01-21 1973-01-03   Democrat 9                        
29850 29850 H000875 sen NE 1971-01-21 1976-12-27 1 Republican                          
29859 29859 H000947 rep MO 1971-01-21 1973-01-03   Democrat 6                        
29869 29869 J000206 rep NC 1971-01-21 1973-01-03   Republican 9                        
29873 29873 K000038 rep WV 1971-01-21 1973-01-03   Democrat 5                        
29880 29880 K000053 rep MA 1971-01-21 1973-01-03   Republican 12                        
29886 29886 K000351 rep IA 1971-01-21 1973-01-03   Republican 4                        
29895 29895 L000240 rep NC 1971-01-21 1973-01-03   Democrat 7                        
29896 29896 L000333 rep ND 1971-01-21 1973-01-03   Democrat 2                        
29900 29900 L000382 rep UT 1971-01-21 1973-01-03   Republican 2                        
29904 29904 L000429 rep LA 1971-01-21 1973-01-03   Democrat 8                        
29913 29913 M000113 sen MT 1971-01-21 1977-01-03 1 Democrat                          
29926 29926 M000393 rep OH 1971-01-21 1973-01-03   Republican 4                        
29929 29929 M000410 rep MI 1971-01-21 1973-01-03   Republican 19                        
29932 29932 M000445 sen WY 1971-01-21 1977-01-03 1 Democrat                          
29933 29933 M000513 rep CO 1971-01-21 1973-01-03   Republican 1                        
29950 29950 M000568 rep SC 1971-01-21 1973-01-03   Democrat 6                        
29964 29964 M000727 rep CA 1971-01-21 1973-01-03   Democrat 8                        
29971 29971 M000847 rep CT 1971-01-21 1973-01-03   Democrat 5                        
29978 29978 M000876 sen NM 1971-01-21 1977-01-03 1 Democrat                          
29984 29984 M001009 rep MA 1971-01-21 1973-01-03   Republican 5                        
29989 29989 M001021 rep MD 1971-01-21 1973-01-03   Republican 1                        
29992 29992 M001033 sen UT 1971-01-21 1977-01-03 1 Democrat                          
30007 30007 O000058 rep WI 1971-01-21 1973-01-03   Republican 10                        
30012 30012 P000100 sen RI 1971-01-21 1976-12-28 1 Democrat                          
30022 30022 P000196 rep WA 1971-01-21 1973-01-03   Republican 1                        
30029 30029 P000366 rep NY 1971-01-21 1973-01-03   Republican 32                        
30039 30039 P000401 rep VA 1971-01-21 1973-01-03   Republican 6                        
30046 30046 P000559 rep IL 1971-01-21 1973-01-03   Democrat 11                        
30052 30052 P000569 rep TX 1971-01-21 1973-01-03   Democrat 13                        
30057 30057 R000143 rep IL 1971-01-21 1973-01-03   Republican 15                        
30063 30063 R000562 rep NY 1971-01-21 1973-01-03   Democrat 20                        
30065 30065 S000133 rep CA 1971-01-21 1973-01-03   Republican 35                        
30073 30073 S000161 rep IA 1971-01-21 1973-01-03   Republican 1                        
30084 30084 S000174 sen PA 1971-01-21 1977-01-03 1 Republican                          
30092 30092 S000545 rep CA 1971-01-21 1973-01-03   Republican 20                        
30103 30103 S000756 rep IL 1971-01-21 1973-01-03   Republican 22                        
30107 30107 S001136 sen MO 1971-01-21 1976-12-27 1 Democrat                          
30111 30111 T000010 sen OH 1971-01-21 1976-12-28 1 Republican                          
30112 30112 T000134 rep NY 1971-01-21 1973-01-03   Republican 34                        
30115 30115 T000217 rep GA 1971-01-21 1973-01-03   Republican 5                        
30119 30119 T000410 sen CA 1971-01-21 1977-01-03 1 Democrat                          
30130 30130 W000212 rep KY 1971-01-21 1973-01-03   Democrat 6                        
30137 30137 W000320 rep PA 1971-01-21 1973-01-03   Republican 12                        
30139 30139 A000017 rep SD 1971-01-21 1973-01-03   Democrat 2                        
30159 30159 A000216 rep IL 1971-01-21 1973-01-03   Republican 17                        
30161 30161 B000069 rep TN 1971-01-21 1973-01-03   Republican 3                        
30166 30166 B000506 rep GA 1971-01-21 1973-01-03   Republican 4                        
30180 30180 B000550 rep MN 1971-01-21 1973-01-03   Democrat 8                        
30184 30184 B000771 rep NY 1971-01-21 1973-01-03   Democrat 11                        
30196 30196 B000778 rep IN 1971-01-21 1973-01-03   Republican 6                        
30203 30203 B000893 rep CO 1971-01-21 1973-01-03   Republican 2                        
30214 30214 B000967 rep VA 1971-01-21 1973-01-03   Republican 10                        
30217 30217 C000073 rep OK 1971-01-21 1973-01-03   Republican 6                        
30224 30224 C000143 rep NY 1971-01-21 1973-01-03   Democrat 15                        
30242 30242 C000275 rep MI 1971-01-21 1973-01-03   Republican 6                        

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);