legislator_terms

Table actions Table actions

484 rows where "start" is on date 1925-12-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, 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
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                        
18914 18914 B000553 sen SC 1925-12-07 1931-03-03 2 Democrat                          
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                        
18931 18931 D000233 sen IL 1925-12-07 1931-03-03 2 Republican                          
18933 18933 E000044 sen NJ 1925-12-07 1929-11-21 2 Republican                          
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                        
18975 18975 G000201 sen MA 1925-12-07 1931-03-03 2 Republican                          
18976 18976 G000254 sen WV 1925-12-07 1931-03-03 2 Republican                          
18978 18978 G000329 rep IL 1925-12-07 1927-03-04   Republican 6                        
18989 18989 H000446 sen AL 1925-12-07 1931-03-03 2 Democrat                          
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                        
19041 19041 M000563 sen SD 1925-12-07 1931-03-03 2 Republican                          
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                        
19061 19061 P000317 sen CO 1925-12-07 1931-03-03 2 Republican                          
19062 19062 P000360 sen OK 1925-12-07 1931-03-03 2 Republican                          
19070 19070 R000019 rep CA 1925-12-07 1927-03-04   Democrat 2                        
19080 19080 R000059 sen LA 1925-12-07 1931-03-03 2 Democrat                          
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                        
19096 19096 S000006 sen KY 1925-12-07 1931-03-03 2 Republican                          
19102 19102 S000169 rep MI 1925-12-07 1927-03-04   Republican 11                        
19108 19108 S000415 sen NC 1925-12-07 1931-03-03 2 Democrat                          
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                        
19136 19136 T000456 sen TN 1925-12-07 1929-08-24 2 Democrat                          
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                        
19156 19156 W000164 sen WY 1925-12-07 1929-11-24 2 Republican                          
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                        
19177 19177 D000560 sen DE 1925-12-07 1929-03-03 2 Republican                          
19181 19181 H000362 rep MO 1925-12-07 1926-10-15   Democrat 11                        
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                        
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                          
19254 19254 B001192 rep PA 1925-12-07 1927-03-04   Republican 8                        
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                        
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                        
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                        
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                        
19391 19391 L000153 rep LA 1925-12-07 1927-03-04   Democrat 7                        
19395 19395 L000484 rep MS 1925-12-07 1927-03-04   Democrat 2                        
19399 19399 L000543 rep NC 1925-12-07 1927-03-04   Democrat 6                        
19404 19404 M000009 rep NY 1925-12-07 1927-03-04   Republican 41                        

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