legislator_terms

Table actions Table actions

479 rows where "end" is on date 1977-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, 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
29585 29585 B000272 sen MD 1971-01-21 1977-01-03 1 Republican                          
29641 29641 B000851 sen TN 1971-01-21 1977-01-03 1 Republican                          
29642 29642 B001026 sen NY 1971-01-21 1977-01-03 1 Conservative                          
29775 29775 F000013 sen AZ 1971-01-21 1977-01-03 1 Republican                          
29778 29778 F000245 sen HI 1971-01-21 1977-01-03 1 Republican                          
29841 29841 H000291 sen MI 1971-01-21 1977-01-03 1 Democrat                          
29844 29844 H000297 sen IN 1971-01-21 1977-01-03 1 Democrat                          
29913 29913 M000113 sen MT 1971-01-21 1977-01-03 1 Democrat                          
29932 29932 M000445 sen WY 1971-01-21 1977-01-03 1 Democrat                          
29978 29978 M000876 sen NM 1971-01-21 1977-01-03 1 Democrat                          
29992 29992 M001033 sen UT 1971-01-21 1977-01-03 1 Democrat                          
30084 30084 S000174 sen PA 1971-01-21 1977-01-03 1 Republican                          
30119 30119 T000410 sen CA 1971-01-21 1977-01-03 1 Democrat                          
30805 30805 A000018 rep NY 1975-01-14 1977-01-03   Democrat 20                        
30820 30820 A000073 rep OK 1975-01-14 1977-01-03   Democrat 3                        
30837 30837 B000178 rep PA 1975-01-14 1977-01-03   Democrat 1                        
30848 30848 B000330 rep CA 1975-01-14 1977-01-03   Republican 27                        
30852 30852 B000362 rep PR 1975-01-14 1977-01-03   Popular Democrat 0                        
30857 30857 B000451 rep PA 1975-01-14 1977-01-03   Republican 8                        
30878 30878 C000409 rep OH 1975-01-14 1977-01-03   Republican 2                        
30880 30880 C000682 rep AZ 1975-01-14 1977-01-03   Republican 4                        
30903 30903 D000041 rep NJ 1975-01-14 1977-01-03   Democrat 14                        
30912 30912 D000474 rep VA 1975-01-14 1977-01-03   Democrat 1                        
30918 30918 E000213 rep MI 1975-01-14 1977-01-03   Republican 2                        
30923 30923 E000214 rep PA 1975-01-14 1977-01-03   Republican 16                        
30938 30938 E000273 rep TN 1975-01-14 1977-01-03   Democrat 4                        
30945 30945 F000424 rep TN 1975-01-14 1977-01-03   Democrat 5                        
30954 30954 G000420 rep PA 1975-01-14 1977-01-03   Democrat 3                        
30959 30959 G000513 rep MD 1975-01-14 1977-01-03   Republican 8                        
30971 30971 H000041 rep FL 1975-01-14 1977-01-03   Democrat 8                        
30972 30972 H000073 rep IL 1975-01-14 1977-01-03   Democrat 15                        
30976 30976 H000327 rep NY 1975-01-14 1977-01-03   Republican 39                        
30977 30977 H000392 rep IN 1975-01-14 1977-01-03   Democrat 8                        
30991 30991 H000408 rep OH 1975-01-14 1977-01-03   Democrat 18                        
31000 31000 H000438 rep WV 1975-01-14 1977-01-03   Democrat 4                        
31006 31006 H000465 rep NJ 1975-01-14 1977-01-03   Democrat 9                        
31014 31014 H000479 rep NC 1975-01-14 1977-01-03   Democrat 3                        
31020 31020 H000563 rep WA 1975-01-14 1977-01-03   Democrat 6                        
31022 31022 H000638 rep CA 1975-01-14 1977-01-03   Republican 40                        
31023 31023 H000851 rep UT 1975-01-14 1977-01-03   Democrat 2                        
31030 31030 H000965 rep MO 1975-01-14 1977-01-03   Democrat 9                        
31037 31037 H001011 rep MI 1975-01-14 1977-01-03   Republican 4                        
31055 31055 H000437 rep LA 1975-01-14 1977-01-03   Democrat 1                        
31068 31068 J000057 rep OK 1975-01-14 1977-01-03   Republican 5   [{"start": "1975-01-14", "end": "1975-01-24", "party": "Democrat"}, {"start": "1975-01-24", "end": "1977-01-03", "party": "Republican"}]                    
31083 31083 J000115 rep PA 1975-01-14 1977-01-03   Republican 23                        
31098 31098 J000248 rep AL 1975-01-14 1977-01-03   Democrat 5                        
31107 31107 K000014 rep MN 1975-01-14 1977-01-03   Democrat 4                        
31120 31120 K000273 rep IL 1975-01-14 1977-01-03   Democrat 5                        
31132 31132 L000054 rep GA 1975-01-14 1977-01-03   Democrat 9                        
31134 31134 L000360 rep MO 1975-01-14 1977-01-03   Democrat 6                        
31145 31145 M000005 rep MA 1975-01-14 1977-01-03   Democrat 7                        
31162 31162 M000039 rep IN 1975-01-14 1977-01-03   Democrat 1                        
31176 31176 M000349 rep NE 1975-01-14 1977-01-03   Republican 2                        
31183 31183 M000686 rep IA 1975-01-14 1977-01-03   Democrat 1                        
31202 31202 M000778 rep AR 1975-01-14 1977-01-03   Democrat 2                        
31219 31219 M000958 rep PA 1975-01-14 1977-01-03   Democrat 22                        
31227 31227 M001031 rep OH 1975-01-14 1977-01-03   Republican 13                        
31239 31239 O000055 rep MI 1975-01-14 1977-01-03   Democrat 12                        
31254 31254 P000098 rep LA 1975-01-14 1977-01-03   Democrat 5                        
31278 31278 P000103 rep TX 1975-01-14 1977-01-03   Democrat 1                        
31292 31292 R000041 rep MO 1975-01-14 1977-01-03   Democrat 4                        
31298 31298 R000134 rep CA 1975-01-14 1977-01-03   Democrat 23                        
31311 31311 R000467 rep IN 1975-01-14 1977-01-03   Democrat 4                        
31320 31320 S000135 rep PA 1975-01-14 1977-01-03   Republican 17                        
31334 31334 S000388 rep KS 1975-01-14 1977-01-03   Republican 4                        
31337 31337 S000803 rep OH 1975-01-14 1977-01-03   Democrat 20                        
31339 31339 S000841 rep TX 1975-01-14 1977-01-03   Republican 5                        
31344 31344 S000846 rep AZ 1975-01-14 1977-01-03   Republican 3                        
31352 31352 S000860 rep GA 1975-01-14 1977-01-03   Democrat 10                        
31360 31360 S001039 rep GA 1975-01-14 1977-01-03   Democrat 8                        
31372 31372 S001057 rep MO 1975-01-14 1977-01-03   Democrat 3                        
31376 31376 S001134 rep MO 1975-01-14 1977-01-03   Democrat 2                        
31383 31383 T000022 rep CA 1975-01-14 1977-01-03   Republican 16                        
31396 31396 T000099 rep NC 1975-01-14 1977-01-03   Democrat 11                        
31398 31398 V000029 rep MI 1975-01-14 1977-01-03   Democrat 5                        
31404 31404 V000098 rep PA 1975-01-14 1977-01-03   Democrat 24                        
31413 31413 D000558 rep DE 1975-01-14 1977-01-03   Republican 0                        
31415 31415 A000118 rep TN 1975-01-14 1977-01-03   Democrat 5                        
31420 31420 B000025 rep NY 1975-01-14 1977-01-03   Democrat 21                        
31424 31424 B000408 rep MN 1975-01-14 1977-01-03   Democrat 7                        
31426 31426 B000567 rep IA 1975-01-14 1977-01-03   Democrat 2                        
31429 31429 B000788 rep KY 1975-01-14 1977-01-03   Democrat 6                        
31435 31435 B000917 rep MI 1975-01-14 1977-01-03   Republican 3                        
31441 31441 B001091 rep FL 1975-01-14 1977-01-03   Republican 12                        
31451 31451 B001092 rep MA 1975-01-14 1977-01-03   Democrat 11                        
31454 31454 B001102 rep CA 1975-01-14 1977-01-03   Democrat 28                        
31470 31470 B001111 rep TX 1975-01-14 1977-01-03   Democrat 17                        
31473 31473 B001209 sen VA 1971-01-21 1977-01-03 1 Independent       Democrat                  
31477 31477 B001221 rep MD 1975-01-14 1977-01-03   Democrat 6                        
31481 31481 C000120 sen NV 1971-01-21 1977-01-03 1 Democrat                          
31487 31487 C000164 rep OH 1975-01-14 1977-01-03   Democrat 19                        
31500 31500 C000263 rep MI 1975-01-14 1977-01-03   Republican 10                        
31508 31508 C000476 rep CA 1975-01-14 1977-01-03   Republican 33                        
31510 31510 C000782 rep WI 1975-01-14 1977-01-03   Democrat 8                        
31528 31528 D000211 rep NY 1975-01-14 1977-01-03   Democrat 9                        
31539 31539 D000255 rep PA 1975-01-14 1977-01-03   Democrat 21                        
31545 31545 E000096 rep PA 1975-01-14 1977-01-03   Democrat 4                        
31552 31552 E000240 rep CO 1975-01-14 1977-01-03   Democrat 3                        
31557 31557 F000218 rep AL 1975-01-14 1977-01-03   Democrat 7                        
31570 31570 F000229 rep GA 1975-01-14 1977-01-03   Democrat 6                        

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