legislator_terms

Table actions Table actions

56 rows where party = "Anti Jacksonian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, start, end, district, 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
3347 3347 C000672 rep NJ 1831-12-05 1833-03-03   Anti Jacksonian -1                        
3349 3349 C000732 rep OH 1831-12-05 1833-03-03   Anti Jacksonian 14                        
3364 3364 D000179 rep MA 1831-12-05 1833-03-03   Anti Jacksonian 10                        
3466 3466 M000269 rep VA 1829-12-07 1831-03-03   Anti Jacksonian 21                        
3467 3467 M000269 rep VA 1831-12-05 1833-03-03   Anti Jacksonian 21                        
3502 3502 N000036 rep MA 1831-12-05 1833-03-03   Anti Jacksonian 3                        
3523 3523 P000201 rep NY 1831-12-05 1833-03-03   Anti Jacksonian 5                        
3546 3546 S000686 rep NJ 1831-12-05 1833-03-03   Anti Jacksonian -1                        
3549 3549 S000788 rep OH 1831-12-05 1833-03-03   Anti Jacksonian 8                        
3584 3584 W000473 rep NY 1831-12-05 1833-03-03   Anti Jacksonian 6                        
3594 3594 A000132 rep VA 1833-12-02 1835-03-03   Anti Jacksonian 20                        
3611 3611 B000256 rep MA 1833-12-02 1835-03-03   Anti Jacksonian 10                        
3613 3613 B000338 rep OH 1833-12-02 1835-03-03   Anti Jacksonian 11                        
3614 3614 B000475 rep PA 1833-12-02 1835-03-03   Anti Jacksonian 2                        
3634 3634 B001082 rep RI 1829-12-07 1831-03-03   Anti Jacksonian -1                        
3635 3635 B001082 rep RI 1831-12-05 1833-03-03   Anti Jacksonian -1                        
3636 3636 B001082 rep RI 1833-12-02 1835-03-03   Anti Jacksonian -1                        
3641 3641 C000359 rep KY 1833-12-02 1835-03-03   Anti Jacksonian 6                        
3651 3651 C000918 rep TN 1829-12-07 1831-03-03   Anti Jacksonian 9                        
3652 3652 C000918 rep TN 1833-12-02 1835-03-03   Anti Jacksonian 12                        
3658 3658 D000092 rep KY 1833-12-02 1835-03-03   Anti Jacksonian 11                        
3662 3662 D000245 rep MD 1833-12-02 1835-03-03   Anti Jacksonian 1                        
3679 3679 G000148 rep VA 1833-12-02 1835-03-03   Anti Jacksonian 4                        
3689 3689 G000324 rep MA 1829-12-07 1831-03-03   Anti Jacksonian 1                        
3690 3690 G000324 rep MA 1833-12-02 1835-03-03   Anti Jacksonian 1                        
3729 3729 L000455 rep KY 1833-12-02 1835-03-03   Anti Jacksonian 9                        
3739 3739 M000161 rep KY 1831-12-05 1833-03-03   Anti Jacksonian 2                        
3740 3740 M000161 rep KY 1833-12-02 1835-03-03   Anti Jacksonian 12                        
3758 3758 M000917 rep VA 1833-12-02 1835-03-03   Anti Jacksonian 17                        
3810 3810 T000304 rep KY 1831-12-05 1833-03-03   Anti Jacksonian 10                        
3811 3811 T000304 rep KY 1833-12-02 1835-03-03   Anti Jacksonian 3                        
3812 3812 T000442 rep CT 1833-12-02 1835-03-03   Anti Jacksonian -1                        
3814 3814 W000195 rep PA 1831-12-05 1833-03-03   Anti Jacksonian 3                        
3815 3815 W000195 rep PA 1833-12-02 1835-03-03   Anti Jacksonian 3                        
3825 3825 W000574 rep VA 1833-12-02 1835-03-03   Anti Jacksonian 21                        
3873 3873 C000405 rep VA 1835-12-07 1837-03-03   Anti Jacksonian 7                        
4014 4014 M000320 rep IN 1835-12-07 1837-03-03   Anti Jacksonian 5                        
4069 4069 S000834 rep MD 1833-12-02 1835-03-03   Anti Jacksonian 1                        
4070 4070 S000834 rep MD 1835-12-07 1837-03-03   Anti Jacksonian 1                        
4092 4092 W000179 rep MD 1829-12-07 1831-03-03   Anti Jacksonian 3                        
4093 4093 W000179 rep MD 1831-12-05 1833-03-03   Anti Jacksonian 3                        
4094 4094 W000179 rep MD 1835-12-07 1837-03-03   Anti Jacksonian 5                        
4521 4521 J000078 rep MD 1831-12-05 1833-03-03   Anti Jacksonian 1                        
4626 4626 T000221 rep SC 1835-12-07 1837-03-03   Anti Jacksonian 6                        
4665 4665 A000269 rep MA 1831-12-05 1833-03-03   Anti Jacksonian 1                        
4676 4676 A000297 rep TN 1831-12-05 1833-03-03   Anti Jacksonian 2                        
4815 4815 H000052 rep VT 1831-12-05 1833-03-03   Anti Jacksonian 1                        
4843 4843 J000180 rep MD 1833-12-02 1835-03-03   Anti Jacksonian 6                        
4858 4858 L000315 rep MA 1833-12-02 1835-03-03   Anti Jacksonian 5                        
5556 5556 V000017 rep OH 1823-12-01 1825-03-03   Anti Jacksonian 4                        
5559 5559 V000017 rep OH 1829-12-07 1831-03-03   Anti Jacksonian 4                        
5560 5560 V000017 rep OH 1831-12-05 1833-03-03   Anti Jacksonian 4                        
5561 5561 V000017 rep OH 1833-12-02 1835-03-03   Anti Jacksonian 10                        
5917 5917 B001049 rep LA 1831-12-05 1833-03-03   Anti Jacksonian 3                        
5918 5918 B001049 rep LA 1833-12-02 1835-03-03   Anti Jacksonian 3                        
5957 5957 D000181 rep NC 1829-12-07 1831-03-03   Anti Jacksonian 7                        

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