legislator_terms

Table actions Table actions

40 rows where party = "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
2816 2816 C000197 rep SC 1823-12-01 1825-03-03   Jacksonian 8                        
2897 2897 M000535 rep DE 1823-12-01 1825-03-03   Jacksonian 0                        
3069 3069 C000856 rep NY 1823-12-01 1825-03-03   Jacksonian 6                        
3165 3165 L000366 rep LA 1823-12-01 1825-03-03   Jacksonian 1                        
3179 3179 M000722 rep PA 1823-12-01 1825-03-03   Jacksonian 3                        
3260 3260 T000402 rep SC 1823-12-01 1825-03-03   Jacksonian 9                        
3288 3288 A000099 rep VA 1823-12-01 1825-03-03   Jacksonian 4                        
3309 3309 B000128 rep VA 1823-12-01 1825-03-03   Jacksonian 15                        
3475 3475 M000377 rep VA 1823-12-01 1825-03-03   Jacksonian 19                        
3483 3483 M000810 rep MD 1823-12-01 1825-03-03   Jacksonian 6                        
3528 3528 P000467 rep NC 1831-12-05 1833-03-03   Jacksonian -1                        
3531 3531 R000029 rep PA 1831-12-05 1833-03-03   Jacksonian -1                        
3563 3563 T000222 rep GA 1823-12-01 1825-03-03   Jacksonian -1                        
3619 3619 B000528 rep TN 1823-12-01 1825-03-03   Jacksonian 1                        
3659 3659 D000159 rep NY 1823-12-01 1825-03-03   Jacksonian 24                        
3750 3750 M000492 rep PA 1823-12-01 1825-03-03   Jacksonian 9                        
3760 3760 M000953 rep NY 1823-12-01 1825-03-03   Jacksonian 3                        
3797 3797 S000891 rep VA 1823-12-01 1825-03-03   Jacksonian 9                        
3837 3837 A000315 rep MO 1831-12-05 1833-03-03   Jacksonian 1                        
3838 3838 A000315 rep MO 1833-12-02 1835-03-03   Jacksonian -1                        
3839 3839 A000315 rep MO 1835-12-07 1837-03-03   Jacksonian -1                        
3858 3858 B001058 rep TN 1835-12-07 1837-03-03   Jacksonian 2                        
3991 3991 L000164 rep TN 1835-12-07 1837-03-03   Jacksonian 3                        
4039 4039 P000282 rep TN 1835-12-07 1837-03-03   Jacksonian 6                        
4056 4056 S000130 rep GA 1835-12-07 1837-03-03   Jacksonian -1                        
4098 4098 W000218 rep GA 1835-12-07 1837-03-03   Jacksonian -1                        
4102 4102 W000358 rep NY 1835-12-07 1837-03-03   Jacksonian -1                        
4278 4278 M000516 rep MD 1823-12-01 1825-03-03   Jacksonian 5                        
4356 4356 S000789 rep TN 1823-12-01 1825-03-03   Jacksonian 3                        
4969 4969 R000285 rep VA 1823-12-01 1825-03-03   Jacksonian 10                        
4972 4972 R000285 rep VA 1829-12-07 1831-03-03   Jacksonian -1                        
5289 5289 S000256 rep AR 1828-02-23 1829-03-03   Jacksonian -1                        
5290 5290 S000256 rep AR 1829-12-07 1831-03-03   Jacksonian -1                        
5291 5291 S000256 rep AR 1831-12-05 1833-03-03   Jacksonian -1                        
5292 5292 S000256 rep AR 1833-12-02 1835-03-03   Jacksonian -1                        
5293 5293 S000256 rep AR 1835-12-07 1836-06-15   Jacksonian -1                        
5333 5333 W000770 rep NY 1831-12-05 1833-03-03   Jacksonian -1                        
5455 5455 J000155 rep VA 1823-12-01 1825-03-03   Jacksonian 18                        
5768 5768 M000096 rep NC 1823-12-01 1825-03-03   Jacksonian 8                        
7882 7882 W000442 rep KY 1823-12-01 1825-03-03   Jacksonian 9                        

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