legislator_terms

Table actions Table actions

497 rows where "start" is on date 1917-04-02

✎ 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
17053 17053 A000051 rep GA 1917-04-02 1919-03-03   Democrat 4                        
17058 17058 A000341 rep TN 1917-04-02 1919-03-03   Republican 2                        
17059 17059 B000018 rep MI 1917-04-02 1919-03-03   Republican 2                        
17065 17065 B000164 rep IN 1917-04-02 1919-03-03   Democrat 13                        
17068 17068 B000240 rep OH 1917-04-02 1919-03-03   Democrat 14                        
17071 17071 B000264 rep MI 1917-04-02 1919-03-03   Democrat 2                        
17072 17072 B000421 rep PA 1917-04-02 1919-03-03   Democrat 28                        
17073 17073 B000476 rep NJ 1917-04-02 1919-03-03   Republican 5                        
17074 17074 B000552 rep PA 1917-04-02 1919-03-03   Republican 28                        
17079 17079 B000643 rep MO 1917-04-02 1919-03-03   Democrat 5                        
17081 17081 B000846 rep NC 1917-04-02 1919-03-03   Republican 10                        
17083 17083 B000855 rep PA 1917-04-02 1919-03-03   Democrat 20                        
17086 17086 B000974 rep NY 1917-04-02 1919-03-03   Democrat 22                        
17092 17092 C000025 sen NY 1917-04-02 1923-03-03 1 Republican                          
17094 17094 C000136 rep NJ 1917-04-02 1919-03-03   Republican 5                        
17096 17096 C000205 rep MA 1917-04-02 1919-03-03   Republican 13                        
17102 17102 C000218 rep WI 1917-04-02 1919-03-03   Republican 4                        
17103 17103 C000433 rep PA 1917-04-02 1919-03-03   Republican 25                        
17106 17106 C000490 rep OH 1917-04-02 1919-03-03   Democrat 11                        
17107 17107 C000663 rep IN 1917-04-02 1919-03-03   Republican 6                        
17110 17110 C000689 rep KS 1917-04-02 1919-03-03   Democrat 6                        
17115 17115 C000707 rep NY 1917-04-02 1919-03-03   Democrat -1                        
17117 17117 C000748 rep WV 1917-04-02 1919-03-03   Republican 5                        
17123 17123 C000840 rep IN 1917-04-02 1919-03-03   Democrat 3                        
17127 17127 C000963 sen TX 1917-04-02 1923-03-03 1 Democrat                          
17130 17130 D000008 rep NY 1917-04-02 1919-03-03   Democrat 4                        
17139 17139 D000084 rep WI 1917-04-02 1919-03-03   Republican 6                        
17142 17142 D000184 rep MO 1917-04-02 1919-03-03   Democrat 15                        
17143 17143 D000258 rep IN 1917-04-02 1919-03-03   Democrat 1                        
17148 17148 D000337 rep TX 1917-04-02 1919-03-03   Democrat 2                        
17151 17151 D000348 rep SD 1917-04-02 1919-03-03   Republican 1                        
17158 17158 D000374 rep IN 1917-04-02 1919-03-03   Democrat 4                        
17161 17161 D000427 rep KS 1917-04-02 1919-03-03   Democrat 4                        
17164 17164 D000505 rep NJ 1917-04-02 1919-03-03   Republican 7                        
17165 17165 E000219 rep MO 1917-04-02 1919-03-03   Republican 10                        
17171 17171 F000005 rep NY 1917-04-02 1919-03-03   Republican 34                        
17181 17181 F000131 rep SC 1917-04-02 1919-03-03   Democrat -1                        
17191 17191 F000165 rep NY 1917-04-02 1919-03-03   Democrat 7                        
17193 17193 F000228 rep NY 1917-04-02 1919-03-03   Democrat 3                        
17204 17204 F000295 rep IL 1917-04-02 1919-03-03   Republican 10                        
17210 17210 F000309 rep IL 1917-04-02 1919-03-03   Democrat 23                        
17211 17211 F000333 sen MD 1917-04-02 1923-03-03 1 Republican                          
17212 17212 F000335 rep NY 1917-04-02 1919-03-03   Republican 18                        
17213 17213 F000370 sen NJ 1917-04-02 1923-03-03 1 Republican                          
17222 17222 G000050 rep MA 1917-04-02 1919-03-03   Republican 6                        
17225 17225 G000317 rep OH 1917-04-02 1919-03-03   Democrat 20                        
17227 17227 G000393 rep NJ 1917-04-02 1919-03-03   Republican 8                        
17229 17229 G000401 rep AL 1917-04-02 1919-03-03   Democrat 1                        
17237 17237 G000441 rep TX 1917-04-02 1919-03-03   Democrat 7                        
17240 17240 G000460 rep NY 1917-04-02 1919-03-03   Democrat 8                        
17243 17243 H000104 rep NY 1917-04-02 1919-03-03   Republican 43                        
17250 17250 H000119 rep MO 1917-04-02 1919-03-03   Democrat 7                        
17257 17257 H000389 rep CA 1917-04-02 1919-03-03   Republican 8                        
17259 17259 H000433 rep PA 1917-04-02 1919-03-03   Republican 12                        
17260 17260 H000455 rep OH 1917-04-02 1919-03-03   Republican 2                        
17264 17264 H000459 rep ND 1917-04-02 1919-03-03   Republican 1                        
17267 17267 H000466 rep KS 1917-04-02 1919-03-03   Democrat 5                        
17271 17271 H000522 rep MO 1917-04-02 1919-03-03   Democrat 13                        
17282 17282 H000591 rep CT 1917-04-02 1919-03-03   Republican 4                        
17284 17284 H000620 rep CO 1917-04-02 1919-03-03   Democrat 1                        
17289 17289 H000645 sen NE 1917-04-02 1923-03-03 1 Democrat                          
17292 17292 H000726 rep OH 1917-04-02 1919-03-03   Republican 18                        
17294 17294 H000755 rep NC 1917-04-02 1919-03-03   Democrat 3                        
17301 17301 H000829 rep TN 1917-04-02 1919-03-03   Democrat 5                        
17305 17305 H000849 rep GA 1917-04-02 1919-03-03   Democrat 5                        
17307 17307 H000934 rep NY 1917-04-02 1919-03-03   Democrat 21                        
17321 17321 J000259 rep VA 1917-04-02 1919-03-03   Democrat 1                        
17324 17324 K000035 rep CO 1917-04-02 1919-03-03   Democrat 3                        
17325 17325 K000046 rep FL 1917-04-02 1919-03-03   Democrat 3                        
17326 17326 K000065 sen MN 1917-04-02 1923-03-03 1 Republican                          
17329 17329 K000157 rep OH 1917-04-02 1919-03-03   Democrat 8                        
17332 17332 K000296 sen PA 1917-04-02 1921-10-12 1 Republican                          
17336 17336 L000006 rep WA 1917-04-02 1919-03-03   Republican 4                        
17339 17339 L000358 rep WV 1917-04-02 1919-03-03   Democrat 6                        
17343 17343 L000385 rep NE 1917-04-02 1919-03-03   Democrat 2                        
17344 17344 L000518 rep NY 1917-04-02 1919-03-03   Democrat 30                        
17345 17345 M000170 rep IL 1917-04-02 1919-03-03   Democrat 4                        
17349 17349 M000397 sen ND 1917-04-02 1923-03-03 1 Republican                          
17351 17351 M000554 rep TX 1917-04-02 1919-03-03   Democrat -1                        
17353 17353 M000629 rep MO 1917-04-02 1919-03-03   Republican 10                        
17358 17358 M000717 rep MN 1917-04-02 1919-03-03   Republican 8                        
17360 17360 M001129 sen MT 1917-04-02 1923-03-03 1 Democrat                          
17361 17361 N000059 sen IN 1917-04-02 1923-03-03 1 Republican                          
17364 17364 N000156 rep ND 1917-04-02 1919-03-03   Republican 3                        
17368 17368 O000117 rep RI 1917-04-02 1919-03-03   Democrat 1                        
17369 17369 O000071 rep NY 1917-04-02 1919-03-03   Democrat 23                        
17371 17371 O000141 rep OH 1917-04-02 1919-03-03   Democrat 13                        
17374 17374 P000014 sen VT 1917-04-02 1923-03-03 1 Republican                          
17377 17377 P000403 sen WA 1917-04-02 1923-03-03 1 Republican                          
17378 17378 P000407 rep DE 1917-04-02 1919-03-03   Democrat 0                        
17380 17380 P000420 sen OH 1917-04-02 1923-03-03 1 Democrat                          
17384 17384 P000487 rep KY 1917-04-02 1919-03-03   Republican 11                        
17386 17386 P000500 rep NY 1917-04-02 1919-03-03   Republican 37                        
17389 17389 P000527 rep MD 1917-04-02 1919-03-03   Democrat 1                        
17393 17393 R000309 rep NV 1917-04-02 1919-03-03   Republican 0                        
17395 17395 R000480 rep PA 1917-04-02 1919-03-03   Republican 21                        
17400 17400 R000533 rep MO 1917-04-02 1919-03-03   Democrat 14                        
17403 17403 S000170 rep IA 1917-04-02 1919-03-03   Republican 11                        
17405 17405 S000180 rep PA 1917-04-02 1919-03-03   Republican -1                        
17415 17415 S000274 rep MO 1917-04-02 1919-03-03   Democrat 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);