legislator_terms

Table actions Table actions

486 rows where "end" is on date 1953-01-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
24246 24246 C000021 sen WA 1947-01-03 1953-01-03 1 Republican                          
24288 24288 B000816 sen ME 1947-01-03 1953-01-03 1 Republican                          
24325 24325 C000684 sen TX 1947-01-03 1953-01-03 1 Democrat                          
24372 24372 E000037 sen MT 1947-01-03 1953-01-03 1 Republican                          
24516 24516 K000082 sen MO 1947-01-03 1953-01-03 1 Republican                          
24561 24561 L000394 sen MA 1947-01-03 1953-01-03 1 Republican                          
24604 24604 M000438 sen AZ 1947-01-03 1953-01-03 1 Democrat                          
24615 24615 M000499 sen TN 1947-01-03 1953-01-03 1 Democrat                          
24627 24627 O000032 sen MD 1947-01-03 1953-01-03 1 Democrat                          
24742 24742 B000399 sen CT 1949-12-17 1953-01-03 1 Democrat   appointment                      
25114 25114 A000001 rep ND 1951-01-03 1953-01-03   Republican 0                        
25122 25122 A000114 rep LA 1951-01-03 1953-01-03   Democrat 8                        
25129 25129 A000196 rep CA 1951-01-03 1953-01-03   Republican 8                        
25130 25130 A000218 rep MO 1951-01-03 1953-01-03   Republican 6                        
25132 25132 B000080 rep MO 1951-01-03 1953-01-03   Republican 11                        
25140 25140 B000237 rep KY 1951-01-03 1953-01-03   Democrat 8                        
25148 25148 B000515 rep MI 1951-01-03 1953-01-03   Republican 6                        
25150 25150 B000649 rep UT 1951-01-03 1953-01-03   Democrat 2                        
25152 25152 B000792 rep OH 1951-01-03 1953-01-03   Democrat 3                        
25157 25157 B000794 rep OH 1951-01-03 1953-01-03   Republican 11                        
25161 25161 B001002 rep PA 1951-01-03 1953-01-03   Democrat 33                        
25165 25165 B001039 rep NE 1951-01-03 1953-01-03   Republican 2                        
25168 25168 B001148 rep VA 1951-01-03 1953-01-03   Democrat 6                        
25173 25173 B001179 rep NY 1951-01-03 1953-01-03   Republican 44                        
25181 25181 B001214 rep NY 1951-01-03 1953-01-03   Democrat 32                        
25183 25183 C000504 rep NY 1951-01-03 1953-01-03   Democrat 4                        
25187 25187 C000606 rep KS 1951-01-03 1953-01-03   Republican 1                        
25191 25191 C000655 rep TX 1951-01-03 1953-01-03   Democrat 2                        
25205 25205 C000831 rep GA 1951-01-03 1953-01-03   Democrat 2                        
25214 25214 C000889 rep MI 1951-01-03 1953-01-03   Republican 8                        
25215 25215 D000249 rep PA 1951-01-03 1953-01-03   Republican 29                        
25236 25236 D000448 rep NC 1951-01-03 1953-01-03   Democrat 9                        
25251 25251 E000023 rep NJ 1951-01-03 1953-01-03   Republican 5                        
25258 25258 E000160 rep OH 1951-01-03 1953-01-03   Republican 1                        
25264 25264 F000066 rep ME 1951-01-03 1953-01-03   Republican 3                        
25266 25266 F000399 rep VA 1951-01-03 1953-01-03   Democrat 9                        
25268 25268 F000431 rep MA 1951-01-03 1953-01-03   Democrat 2                        
25280 25280 G000206 rep PA 1951-01-03 1953-01-03   Republican 14                        
25287 25287 G000338 rep TX 1951-01-03 1953-01-03   Democrat 13                        
25293 25293 G000379 rep UT 1951-01-03 1953-01-03   Democrat 1                        
25294 25294 G000438 rep NY 1951-01-03 1953-01-03   Democrat 1                        
25301 25301 H000050 rep NY 1951-01-03 1953-01-03   Republican 37                        
25308 25308 H000060 rep NY 1951-01-03 1953-01-03   Republican 2                        
25314 25314 H000356 rep CA 1951-01-03 1953-01-03   Democrat 4                        
25318 25318 H000442 rep WV 1951-01-03 1953-01-03   Democrat 6                        
25324 25324 H000443 rep NY 1951-01-03 1953-01-03   Democrat 11                        
25329 25329 H000548 rep MA 1951-01-03 1953-01-03   Republican 10                        
25334 25334 I000037 rep MO 1951-01-03 1953-01-03   Democrat 4                        
25337 25337 J000080 rep IL 1951-01-03 1953-01-03   Republican 23                        
25340 25340 J000224 rep NC 1951-01-03 1953-01-03   Democrat 10                        
25350 25350 K000039 rep WV 1951-01-03 1953-01-03   Democrat 5                        
25365 25365 K000138 rep NC 1951-01-03 1953-01-03   Democrat 2                        
25370 25370 L000095 rep LA 1951-01-03 1953-01-03   Democrat 7                        
25374 25374 L000318 rep PA 1951-01-03 1953-01-03   Democrat 21                        
25376 25376 M000045 rep MO 1951-01-03 1953-01-03   Democrat 1                        
25382 25382 M000455 rep NY 1951-01-03 1953-01-03   Democrat 26                        
25384 25384 M000465 rep CT 1951-01-03 1953-01-03   Democrat 3                        
25386 25386 M000528 rep CA 1951-01-03 1953-01-03   Democrat 23                        
25388 25388 M000559 sen CT 1951-01-03 1953-01-03 3 Democrat                          
25389 25389 M000577 rep FL 1951-01-03 1953-01-03   Democrat 1                        
25395 25395 M000814 rep WA 1951-01-03 1953-01-03   Democrat 1                        
25396 25396 M000878 sen MI 1951-04-23 1953-01-03 1 Democrat   appointment                      
25404 25404 M001081 rep AZ 1951-01-03 1953-01-03   Democrat 1                        
25406 25406 M001094 rep NY 1951-01-03 1953-01-03   Democrat 16                        
25413 25413 M001112 rep WI 1951-01-03 1953-01-03   Republican 7                        
25415 25415 O000095 rep PA 1951-01-03 1953-01-03   Democrat 10                        
25423 25423 O000133 rep NY 1951-01-03 1953-01-03   Democrat 13                        
25427 25427 P000327 rep TX 1951-01-03 1953-01-03   Democrat 7                        
25429 25429 Q000021 rep NY 1951-01-03 1953-01-03   Democrat 5                        
25435 25435 R000025 rep WV 1951-01-03 1953-01-03   Democrat 1                        
25451 25451 R000056 rep MS 1951-01-03 1953-01-03   Democrat 1                        
25454 25454 R000104 rep NC 1951-01-03 1953-01-03   Democrat 12                        
25456 25456 R000453 rep NY 1951-01-03 1953-01-03   Republican 5                        
25479 25479 S000001 rep IL 1951-01-03 1953-01-03   Democrat 7                        
25486 25486 S000067 rep MD 1951-01-03 1953-01-03   Democrat 5                        
25489 25489 S000155 rep OK 1951-01-03 1953-01-03   Republican 1                        
25492 25492 S000172 rep PA 1951-01-03 1953-01-03   Republican 3                        
25493 25493 S000214 sen NE 1951-12-10 1953-01-03 2 Republican   appointment                      
25494 25494 S000461 rep PA 1951-01-03 1953-01-03   Republican 23                        
25503 25503 S000845 rep NE 1951-01-03 1953-01-03   Republican 3                        
25508 25508 S000923 rep OK 1951-01-03 1953-01-03   Democrat 2                        
25513 25513 S000936 rep OR 1951-01-03 1953-01-03   Republican 2                        
25517 25517 S001056 rep MO 1951-01-03 1953-01-03   Democrat 11                        
25519 25519 T000005 rep AR 1951-01-03 1953-01-03   Democrat 4                        
25533 25533 T000320 rep NJ 1951-01-03 1953-01-03   Republican 9                        
25538 25538 V000003 rep IL 1951-01-03 1953-01-03   Republican 2                        
25539 25539 V000077 rep PA 1951-01-03 1953-01-03   Republican 8                        
25541 25541 W000264 rep MO 1951-01-03 1953-01-03   Democrat 3                        
25544 25544 W000298 rep CA 1951-01-03 1953-01-03   Republican 10                        
25553 25553 W000699 rep GA 1951-01-03 1953-01-03   Democrat 9                        
25554 25554 W000700 rep ID 1951-01-03 1953-01-03   Republican 1                        
25571 25571 W000718 rep MI 1951-01-03 1953-01-03   Republican 10                        
25573 25573 D000198 rep AL 1951-01-03 1953-01-03   Democrat 6                        
25578 25578 P000460 sen MI 1952-11-05 1953-01-03 1 Republican                          
25586 25586 A000257 rep OR 1951-01-03 1953-01-03   Republican 3                        
25595 25595 B000242 rep AL 1951-01-03 1953-01-03   Democrat 9                        
25602 25602 B000486 rep IL 1951-01-03 1953-01-03   Republican 26                        
25607 25607 B000762 rep CA 1951-01-03 1953-01-03   Republican 11                        
25609 25609 B000820 sen OH 1947-01-03 1953-01-03 1 Republican                          
25617 25617 B000999 rep SC 1951-01-03 1953-01-03   Democrat 4                        

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