legislator_terms

Table actions Table actions

28 rows where party = "National Greenbacker"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: legislator_id, 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
10005 10005 B000148 rep VT 1879-03-18 1881-03-03   National Greenbacker 3                        
10062 10062 D000204 rep IN 1879-03-18 1881-03-03   National Greenbacker 7                        
10082 10082 F000285 rep IL 1879-03-18 1881-03-03   National Greenbacker 15                        
10087 10087 G000203 rep IA 1879-03-18 1881-03-03   National Greenbacker 7                        
10179 10179 R000523 rep NC 1879-03-18 1881-03-03   National Greenbacker 3                        
10225 10225 W000761 rep PA 1879-03-18 1881-03-03   National Greenbacker 12                        
10229 10229 Y000019 rep PA 1879-03-18 1881-03-03   National Greenbacker 20                        
10275 10275 B001141 rep MO 1881-12-05 1883-03-03   National Greenbacker 10                        
10350 10350 F000266 rep MO 1879-03-18 1881-03-03   National Greenbacker 9                        
10351 10351 F000266 rep MO 1881-12-05 1883-03-03   National Greenbacker 9                        
10377 10377 H000417 rep MO 1881-12-05 1883-03-03   National Greenbacker 6                        
10406 10406 J000223 rep TX 1879-03-18 1881-03-03   National Greenbacker 5                        
10407 10407 J000223 rep TX 1881-12-05 1883-03-03   National Greenbacker 5                        
10424 10424 L000013 rep ME 1879-03-18 1881-03-03   National Greenbacker 4                        
10425 10425 L000013 rep ME 1881-12-05 1883-03-03   National Greenbacker 4                        
10436 10436 L000474 rep AL 1879-03-18 1881-03-03   National Greenbacker 8                        
10437 10437 L000474 rep AL 1881-12-05 1883-03-03   National Greenbacker 8                        
10473 10473 M001030 rep PA 1881-12-05 1883-03-03   National Greenbacker 25                        
10474 10474 M001080 rep ME 1879-03-18 1881-03-03   National Greenbacker 5                        
10475 10475 M001080 rep ME 1881-12-05 1883-03-03   National Greenbacker 5                        
10513 10513 R000203 rep MO 1881-12-05 1883-03-03   National Greenbacker 7                        
10928 10928 W000275 rep IA 1883-12-03 1885-03-03   National Greenbacker 4                        
11534 11534 W000225 rep IA 1879-03-18 1881-03-03   National Greenbacker 6                        
11535 11535 W000225 rep IA 1885-12-07 1887-03-03   National Greenbacker 6                        
11536 11536 W000225 rep IA 1887-12-05 1889-03-03   National Greenbacker 6                        
14997 14997 B000977 rep PA 1881-12-05 1883-03-03   National Greenbacker 13                        
14998 14998 B000977 rep PA 1883-12-03 1885-03-03   National Greenbacker 13                        
16955 16955 S000371 rep IN 1883-12-03 1885-03-03   National Greenbacker 13                        

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