legislator_terms

Table actions Table actions

484 rows where "end" is on date 1927-03-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, class, 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
18081 18081 C000066 sen AZ 1921-04-11 1927-03-04 3 Republican                          
18163 18163 E000206 sen KY 1921-04-11 1927-03-04 3 Republican                          
18215 18215 H000227 sen OK 1921-04-11 1927-03-04 3 Republican                          
18312 18312 L000241 sen WI 1921-04-11 1927-03-04 3 Republican                          
18353 18353 M000521 sen IL 1921-04-11 1927-03-04 3 Republican                          
18493 18493 S000791 sen OR 1921-04-11 1927-03-04 3 Republican                          
18535 18535 U000013 sen AL 1921-04-11 1927-03-04 3 Democrat                          
18554 18554 W000276 sen MD 1921-04-11 1927-03-04 3 Republican                          
18561 18561 P000219 sen PA 1922-01-09 1927-03-04 3 Republican   appointment                      
18907 18907 B001196 sen MA 1924-11-13 1927-03-04 1 Republican   appointment                      
18908 18908 M000621 sen CO 1924-12-01 1927-03-04 3 Republican                          
18909 18909 A000266 rep NJ 1925-12-07 1927-03-04   Republican 3                        
18910 18910 B000048 rep MO 1925-12-07 1927-03-04   Republican 14                        
18913 18913 B000493 rep PA 1925-12-07 1927-03-04   Republican 28                        
18915 18915 C000168 rep PA 1925-12-07 1927-03-04   Republican 12                        
18925 18925 C000196 rep OK 1925-12-07 1927-03-04   Democrat 3                        
18926 18926 C000391 rep MA 1925-12-07 1927-03-04   Republican 2                        
18930 18930 C000500 rep NY 1925-12-07 1927-03-04   Democrat 8                        
18938 18938 F000004 rep NY 1925-12-07 1927-03-04   Republican 24                        
18941 18941 F000084 sen ME 1925-12-07 1927-03-04 2 Republican                          
18942 18942 F000182 rep CA 1925-12-07 1927-03-04   Republican 5                        
18944 18944 F000358 rep CA 1925-12-07 1927-03-04   Republican 10                        
18955 18955 F000407 rep IL 1925-12-07 1927-03-04   Republican 12                        
18958 18958 F000428 rep IL 1925-12-07 1927-03-04   Republican 17                        
18978 18978 G000329 rep IL 1925-12-07 1927-03-04   Republican 6                        
18992 18992 H000597 rep MD 1925-12-07 1927-03-04   Republican 3                        
18994 18994 J000061 rep HI 1925-12-07 1927-03-04   Democrat -1                        
19004 19004 J000118 rep KY 1925-12-07 1927-03-04   Democrat 4                        
19008 19008 K000057 rep MN 1925-12-07 1927-03-04   Republican 4                        
19009 19009 K000234 rep KY 1925-12-07 1927-03-04   Republican 10                        
19019 19019 L000072 rep KY 1925-12-07 1927-03-04   Republican -1                        
19030 19030 L000194 rep GA 1925-12-07 1927-03-04   Democrat 7                        
19033 19033 L000331 rep CA 1925-12-07 1927-03-04   Republican 9                        
19034 19034 L000348 rep KS 1925-12-07 1927-03-04   Democrat 2                        
19036 19036 M000046 rep PA 1925-12-07 1927-03-04   Republican 35                        
19040 19040 M000541 rep NE 1925-12-07 1927-03-04   Republican 4                        
19044 19044 M000776 rep NY 1925-12-07 1927-03-04   Republican 17                        
19045 19045 M000870 rep OK 1925-12-07 1927-03-04   Republican 1                        
19049 19049 N000075 rep MO 1925-12-07 1927-03-04   Republican 10                        
19053 19053 P000114 rep NJ 1925-12-07 1927-03-04   Republican 1                        
19057 19057 P000239 rep NY 1925-12-07 1927-03-04   Republican 14                        
19059 19059 P000314 rep PA 1925-12-07 1927-03-04   Republican 26                        
19070 19070 R000019 rep CA 1925-12-07 1927-03-04   Democrat 2                        
19087 19087 R000400 rep MA 1925-12-07 1927-03-04   Republican 5                        
19095 19095 R000466 rep KY 1925-12-07 1927-03-04   Democrat 6                        
19102 19102 S000169 rep MI 1925-12-07 1927-03-04   Republican 11                        
19112 19112 S000643 rep FL 1925-12-07 1927-03-04   Democrat 3                        
19113 19113 S000680 rep MI 1925-12-07 1927-03-04   Republican 1                        
19114 19114 S001097 rep PA 1925-12-07 1927-03-04   Republican 19                        
19116 19116 S001126 rep PA 1925-12-07 1927-03-04   Republican 23                        
19118 19118 T000080 rep NJ 1925-12-07 1927-03-04   Republican 8                        
19120 19120 T000082 rep WV 1925-12-07 1927-03-04   Democrat 6                        
19121 19121 T000146 rep MA 1925-12-07 1927-03-04   Republican 8                        
19130 19130 T000185 rep KY 1925-12-07 1927-03-04   Democrat 3                        
19134 19134 T000282 rep KS 1925-12-07 1927-03-04   Republican 7                        
19135 19135 T000299 rep NY 1925-12-07 1927-03-04   Republican 34                        
19140 19140 U000026 rep GA 1925-12-07 1927-03-04   Democrat 5                        
19145 19145 V000110 rep WI 1925-12-07 1927-03-04   Republican 2                        
19149 19149 W000109 rep PA 1925-12-07 1927-03-04   Republican 20                        
19158 19158 W000251 rep MN 1925-12-07 1927-03-04   Farmer-Labor 9                        
19163 19163 W000339 rep IL 1925-12-07 1927-03-04   Republican 21                        
19165 19165 W000490 rep MI 1925-12-07 1927-03-04   Republican 3                        
19166 19166 W000499 sen MO 1925-12-07 1927-03-04 3 Republican   appointment                      
19175 19175 W000737 rep WV 1925-12-07 1927-03-04   Republican 4                        
19182 19182 H000362 sen MO 1926-12-06 1927-03-04 3 Democrat                          
19186 19186 S000906 sen IA 1926-08-07 1927-03-04 3 Republican   appointment                      
19196 19196 A000261 rep KS 1925-12-07 1927-03-04   Republican 1                        
19200 19200 B000291 rep WI 1925-12-07 1927-03-04   Republican 7                        
19205 19205 B000314 rep OH 1925-12-07 1927-03-04   Republican 13                        
19210 19210 B000407 rep WI 1925-12-07 1927-03-04   Socialist 5                        
19212 19212 B000470 sen CT 1925-01-08 1927-03-04 3 Republican                          
19219 19219 B000495 rep TX 1925-12-07 1927-03-04   Democrat 1                        
19225 19225 B000597 rep IA 1925-12-07 1927-03-04   Republican 11                        
19227 19227 B000700 rep MA 1925-12-07 1927-03-04   Republican 2                        
19232 19232 B000702 rep AL 1925-12-07 1927-03-04   Democrat 5                        
19235 19235 B000873 sen IA 1925-12-07 1927-03-04 2 Republican                          
19237 19237 B000895 sen LA 1921-04-11 1927-03-04 3 Democrat                          
19254 19254 B001192 rep PA 1925-12-07 1927-03-04   Republican 8                        
19260 19260 C000139 sen AR 1921-04-11 1927-03-04 3 Democrat                          
19263 19263 C000194 rep MN 1925-12-07 1927-03-04   Farmer-Labor 8                        
19267 19267 C000959 rep OR 1925-12-07 1927-03-04   Republican 3                        
19278 19278 C001008 sen KS 1921-04-11 1927-03-04 3 Republican                          
19284 19284 D000009 sen VT 1923-12-03 1927-03-04 3 Republican                          
19289 19289 D000080 rep OH 1925-12-07 1927-03-04   Democrat 14                        
19293 19293 D000169 rep VA 1925-12-07 1927-03-04   Democrat 2                        
19298 19298 F000047 rep MO 1925-12-07 1927-03-04   Republican 4                        
19300 19300 F000170 rep OH 1925-12-07 1927-03-04   Republican 4                        
19304 19304 F000395 rep MA 1925-12-07 1927-03-04   Republican 14                        
19306 19306 F000433 rep MN 1925-12-07 1927-03-04   Republican 1                        
19314 19314 G000024 rep MA 1925-12-07 1927-03-04   Democrat 12                        
19317 19317 G000053 rep IN 1925-12-07 1927-03-04   Democrat 3                        
19329 19329 G000082 rep TN 1925-12-07 1927-03-04   Democrat 9                        
19331 19331 G000288 sen ID 1921-04-11 1927-03-04 3 Republican                          
19340 19340 G000422 rep IA 1925-12-07 1927-03-04   Republican 9                        
19347 19347 H000277 rep VA 1925-12-07 1927-03-04   Democrat 7                        
19354 19354 H000544 rep ME 1925-12-07 1927-03-04   Republican 4                        
19360 19360 J000040 rep NY 1925-12-07 1927-03-04   Democrat 38                        
19369 19369 J000257 sen WA 1921-04-11 1927-03-04 3 Republican                          
19376 19376 K000191 rep NY 1925-12-07 1927-03-04   Democrat 2                        
19383 19383 K000200 rep IL 1925-12-07 1927-03-04   Republican 15                        

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