legislator_terms

Table actions Table actions

502 rows where "end" is on date 1919-03-03

✎ 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
16376 16376 G000255 sen WV 1913-04-07 1919-03-03 2 Republican                          
16402 16402 H000727 sen NH 1913-04-07 1919-03-03 2 Democrat                          
16408 16408 H000929 sen NJ 1913-04-07 1919-03-03 2 Democrat                          
16414 16414 J000051 sen KY 1913-04-07 1919-03-03 2 Democrat                          
16473 16473 M000200 sen VA 1913-04-07 1919-03-03 2 Democrat                          
16556 16556 S000073 sen DE 1913-04-07 1919-03-03 2 Democrat                          
16563 16563 S000279 sen CO 1913-04-07 1919-03-03 2 Democrat                          
16584 16584 S000629 sen MI 1913-04-07 1919-03-03 2 Republican                          
16612 16612 T000226 sen KS 1913-04-07 1919-03-03 2 Democrat                          
16617 16617 T000274 sen SC 1913-04-07 1919-03-03 2 Democrat                          
16624 16624 V000070 sen MS 1913-04-07 1919-03-03 2 Democrat                          
16635 16635 W000246 sen MA 1913-04-07 1919-03-03 2 Republican                          
16657 16657 H000193 sen GA 1914-11-04 1919-03-03 2 Democrat                          
16694 16694 B000753 sen ID 1915-12-06 1919-03-03 3 Republican                          
16704 16704 B000896 sen LA 1915-12-06 1919-03-03 3 Democrat                          
16761 16761 G000023 sen NH 1915-12-06 1919-03-03 3 Republican                          
17019 17019 S000968 sen MO 1915-12-06 1919-03-03 3 Democrat                          
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                        
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                        
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                        
17212 17212 F000335 rep NY 1917-04-02 1919-03-03   Republican 18                        
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                        
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                        
17329 17329 K000157 rep OH 1917-04-02 1919-03-03   Democrat 8                        
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                        
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                        
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                        
17378 17378 P000407 rep DE 1917-04-02 1919-03-03   Democrat 0                        
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                        

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