legislator_terms

Table actions Table actions

481 rows where "start" is on date 1915-12-06

✎ 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
16662 16662 A000013 rep AL 1915-12-06 1917-03-03   Democrat -1                        
16667 16667 A000027 rep IN 1915-12-06 1917-03-03   Democrat 8                        
16674 16674 A000064 rep SC 1915-12-06 1917-03-03   Democrat 3                        
16677 16677 A000111 rep OH 1915-12-06 1917-03-03   Democrat 2                        
16679 16679 B000050 rep PA 1915-12-06 1917-03-03   Democrat 19                        
16685 16685 B000133 rep PA 1915-12-06 1917-03-03   Republican 32                        
16686 16686 B000269 rep PA 1915-12-06 1917-03-03   Republican 20                        
16687 16687 B000293 sen KY 1915-12-06 1921-03-03 3 Democrat                          
16688 16688 B000359 rep CA 1915-12-06 1917-03-03   Republican 10                        
16692 16692 B000370 rep NY 1915-12-06 1917-03-03   Republican 23                        
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                          
16707 16707 B000949 rep WV 1915-12-06 1917-03-03   Democrat 2                        
16710 16710 B001001 rep IL 1915-12-06 1917-03-03   Democrat 7                        
16718 16718 B001083 rep TX 1915-12-06 1917-03-03   Democrat 9                        
16721 16721 B001095 rep WI 1915-12-06 1917-03-03   Democrat 2                        
16724 16724 C000056 rep TX 1915-12-06 1917-03-03   Democrat 12                        
16726 16726 C000277 sen OR 1915-12-06 1921-03-03 3 Democrat                          
16727 16727 C000323 rep NY 1915-12-06 1917-03-03   Republican 30                        
16730 16730 C000463 sen AR 1915-12-06 1917-03-03 3 Democrat                          
16734 16734 C000521 rep IN 1915-12-06 1917-03-03   Democrat 12                        
16735 16735 C000622 rep PA 1915-12-06 1917-03-03   Republican 30                        
16739 16739 C000975 rep IN 1915-12-06 1917-03-03   Democrat 2                        
16742 16742 D000029 rep NY 1915-12-06 1917-03-03   Republican 39                        
16746 16746 D000074 rep OK 1915-12-06 1917-03-03   Democrat 1                        
16747 16747 D000110 rep TX 1915-12-06 1917-03-03   Democrat -1                        
16751 16751 D000500 rep NY 1915-12-06 1917-03-03   Democrat 42                        
16753 16753 E000015 rep PI 1915-12-06 1917-03-03     0                        
16754 16754 F000021 rep NY 1915-12-06 1917-03-03   Democrat 14                        
16761 16761 G000023 sen NH 1915-12-06 1919-03-03 3 Republican                          
16767 16767 G000344 rep NY 1915-12-06 1917-03-03   Democrat 23                        
16772 16772 G000491 sen ND 1915-12-06 1921-03-03 3 Republican                          
16777 16777 G000517 rep ME 1915-12-06 1917-03-03   Republican 4                        
16779 16779 H000283 rep NJ 1915-12-06 1917-03-03   Democrat 6                        
16789 16789 H000382 rep VA 1915-12-06 1917-03-03   Democrat 7                        
16799 16799 H000516 rep TX 1915-12-06 1917-03-03   Democrat 11                        
16802 16802 H000630 rep ME 1915-12-06 1917-03-03   Republican 1                        
16803 16803 H000785 rep PA 1915-12-06 1917-03-03   Republican 23                        
16810 16810 H000866 rep UT 1915-12-06 1917-03-03   Republican 1                        
16814 16814 H000920 rep GA 1915-12-06 1917-03-03   Democrat 12                        
16821 16821 H000958 rep WA 1915-12-06 1917-03-03   Republican 1                        
16822 16822 H001006 sen WI 1915-12-06 1917-10-21 3 Democrat                          
16823 16823 J000128 sen SD 1915-12-06 1921-03-03 3 Democrat                          
16831 16831 J000156 rep SC 1915-12-06 1917-03-03   Democrat 4                        
16833 16833 K000052 rep PA 1915-12-06 1917-03-03   Republican 22                        
16836 16836 K000127 rep CA 1915-12-06 1917-03-03   Independent 1                        
16839 16839 K000310 rep WI 1915-12-06 1917-03-03   Democrat 9                        
16845 16845 L000014 rep PA 1915-12-06 1917-03-03   Republican -1                        
16847 16847 L000302 rep IN 1915-12-06 1917-03-03   Democrat 1                        
16848 16848 L000303 rep PA 1915-12-06 1917-03-03   Democrat 25                        
16853 16853 L000320 rep MN 1915-12-06 1917-03-03   Republican 6                        
16863 16863 L000380 rep MO 1915-12-06 1917-03-03   Democrat 1                        
16865 16865 L000399 rep NY 1915-12-06 1917-03-03   Democrat 13                        
16871 16871 L000449 rep MI 1915-12-06 1917-03-03   Republican 10                        
16872 16872 M000254 rep OH 1915-12-06 1917-03-03   Republican 5                        
16873 16873 M000363 rep SC 1915-12-06 1917-03-03   Democrat 5                        
16874 16874 M000378 rep ID 1915-12-06 1917-03-03   Republican -1                        
16879 16879 M000405 rep IL 1915-12-06 1917-03-03   Democrat 4                        
16882 16882 M000448 rep ME 1915-12-06 1917-03-03   Democrat 2                        
16885 16885 M000753 rep PA 1915-12-06 1917-03-03   Republican 28                        
16886 16886 M000758 rep DE 1915-12-06 1917-03-03   Republican 0                        
16887 16887 M000888 rep OH 1915-12-06 1917-03-03   Republican 15                        
16890 16890 M000955 rep LA 1915-12-06 1917-03-03   Democrat 6                        
16894 16894 M000998 rep IN 1915-12-06 1917-03-03   Democrat 9                        
16896 16896 M001034 rep WV 1915-12-06 1917-03-03   Republican 4                        
16900 16900 M001037 rep IN 1915-12-06 1917-03-03   Democrat 5                        
16902 16902 M001118 rep OK 1915-12-06 1917-03-03   Democrat 4                        
16910 16910 N000069 sen NV 1915-12-06 1917-12-24 3 Democrat                          
16911 16911 N000141 rep PA 1915-12-06 1917-03-03   Republican 27                        
16912 16912 O000002 rep CT 1915-12-06 1917-03-03   Republican 1                        
16914 16914 O000049 rep NY 1915-12-06 1917-03-03   Democrat 24                        
16921 16921 P000022 rep NC 1915-12-06 1917-03-03   Democrat 7                        
16924 16924 P000109 rep NY 1915-12-06 1917-03-03   Democrat 18                        
16928 16928 P000217 sen PA 1915-12-06 1921-03-03 3 Republican                          
16929 16929 P000290 sen CA 1915-12-06 1921-03-03 3 Democrat                          
16933 16933 Q000009 rep PI 1915-12-06 1917-03-03     0                        
16938 16938 R000070 rep IN 1915-12-06 1917-03-03   Democrat 11                        
16941 16941 R000279 rep PR 1915-12-06 1917-03-03   Unionist 0                        
16950 16950 R000311 rep MA 1915-12-06 1917-03-03   Republican 9                        
16951 16951 R000493 rep GA 1915-12-06 1917-03-03   Democrat 8                        
16952 16952 R000534 rep OH 1915-12-06 1917-03-03   Republican 4                        
16954 16954 S000348 sen IL 1915-12-06 1921-03-03 3 Republican                          
16960 16960 S000371 sen IN 1915-12-06 1917-03-03 3 Democrat                          
16962 16962 S000540 rep MN 1915-12-06 1917-03-03   Republican 5                        
16964 16964 S000551 sen GA 1915-12-06 1921-03-03 3 Democrat                          
16968 16968 S000577 sen MD 1915-12-06 1921-03-03 3 Democrat                          
16978 16978 S000589 sen AZ 1915-12-06 1921-03-03 3 Democrat                          
16985 16985 S000636 rep TX 1915-12-06 1917-03-03   Democrat 16                        
16996 16996 S000702 rep FL 1915-12-06 1917-03-03   Democrat 1                        
16997 16997 S000837 rep IA 1915-12-06 1917-03-03   Democrat 11                        
17007 17007 S000858 rep TX 1915-12-06 1917-03-03   Democrat 13                        
17010 17010 S000861 rep CA 1915-12-06 1917-03-03   Progressive 10                        
17013 17013 S000954 rep IL 1915-12-06 1917-03-03   Democrat 16                        
17019 17019 S000968 sen MO 1915-12-06 1919-03-03 3 Democrat                          
17021 17021 S000982 rep MT 1915-12-06 1917-03-03   Democrat -1                        
17024 17024 T000011 rep KS 1915-12-06 1917-03-03   Democrat 2                        
17026 17026 T000059 rep IL 1915-12-06 1917-03-03   Democrat 14                        
17028 17028 T000160 sen CO 1915-12-06 1921-03-03 3 Democrat                          
17031 17031 T000366 rep GA 1915-12-06 1917-03-03   Democrat 8                        
17032 17032 W000535 rep OH 1915-12-06 1917-03-03   Republican 14                        

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