legislator_terms

Table actions Table actions

2,285 rows where state = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, 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
5979 5979 G000172 rep CA 1849-12-03 1851-03-03   Democrat -1                        
6178 6178 W000760 rep CA 1849-12-03 1851-03-03   Independent -1                        
6188 6188 F000374 sen CA 1850-01-01 1851-03-03 1 Democrat                          
6357 6357 M000151 rep CA 1851-12-01 1853-03-03   Democrat -1                        
6359 6359 M000362 rep CA 1851-12-01 1853-03-03   Democrat -1                        
6482 6482 W000274 sen CA 1852-01-01 1857-03-03 1 Democrat                          
6802 6802 D000261 rep CA 1855-12-03 1857-03-03   Democrat -1                        
6837 6837 H000526 rep CA 1855-12-03 1857-03-03   Democrat -1                        
6994 6994 B000857 sen CA 1857-12-07 1859-12-31 1 Democrat                          
7074 7074 G000540 sen CA 1850-09-10 1855-03-03 3 Democrat                          
7075 7075 G000540 sen CA 1857-12-07 1861-03-03 3 Democrat                          
7156 7156 M000514 rep CA 1857-12-07 1859-03-03   Democrat -1                        
7328 7328 B001068 rep CA 1859-12-05 1861-03-03   Democrat -1                        
7438 7438 H000353 sen CA 1859-12-05 1861-03-03 1 Democrat                          
7562 7562 S000167 rep CA 1857-12-07 1859-03-03   Democrat -1                        
7563 7563 S000167 rep CA 1859-12-05 1861-03-03   Democrat -1                        
7645 7645 L000110 rep CA 1853-12-05 1855-03-03   Democrat -1                        
7646 7646 L000110 sen CA 1860-01-01 1863-03-03 1 Democrat                          
7786 7786 L000469 rep CA 1861-07-04 1863-03-03   Republican -1                        
7795 7795 M000416 rep CA 1853-12-05 1855-03-03   Democrat -1                        
7796 7796 M000416 sen CA 1861-07-04 1867-03-03 3 Democrat                          
7836 7836 P000300 rep CA 1861-07-04 1863-03-03   Republican -1                        
7931 7931 C000695 sen CA 1863-12-07 1869-03-03 1 Republican                          
8034 8034 S000290 rep CA 1863-12-07 1865-03-03   Republican -1                        
8086 8086 B000447 rep CA 1865-12-04 1867-03-03   Republican 3                        
8176 8176 M000600 rep CA 1865-12-04 1867-03-03   Republican 1                        
8288 8288 C000607 rep CA 1863-12-07 1865-03-03   Republican -1                        
8289 8289 C000607 sen CA 1867-03-04 1873-03-03 3 Republican                          
8350 8350 H000576 rep CA 1863-12-07 1865-03-03   Republican -1                        
8351 8351 H000576 rep CA 1865-12-04 1867-03-03   Republican 2                        
8352 8352 H000576 rep CA 1867-03-04 1869-03-03   Republican 2                        
8509 8509 A000349 rep CA 1867-03-04 1869-03-03   Democrat 1                        
8510 8510 A000349 rep CA 1869-03-04 1871-03-03   Democrat 1                        
8542 8542 C000236 sen CA 1869-03-04 1873-12-31 1 Democrat                          
8602 8602 G000171 rep CA 1849-12-03 1851-03-03   Democrat -1                        
8641 8641 J000145 rep CA 1867-03-04 1869-03-03   Democrat 3                        
8642 8642 J000145 rep CA 1869-03-04 1871-03-03   Democrat 3                        
8859 8859 C000594 rep CA 1871-03-04 1873-03-03   Republican 3                        
9121 9121 C000493 rep CA 1873-12-01 1875-03-03   Republican 1                        
9185 9185 H000016 sen CA 1873-12-01 1875-03-03 1 Democrat                          
9209 9209 H000815 rep CA 1871-03-04 1873-03-03   Republican 1                        
9210 9210 H000815 rep CA 1873-12-01 1875-03-03   Republican 4                        
9337 9337 S000065 rep CA 1861-07-04 1863-03-03   Republican -1                        
9338 9338 S000065 rep CA 1869-03-04 1871-03-03   Republican 2                        
9339 9339 S000065 rep CA 1871-03-04 1873-03-03   Republican 2                        
9340 9340 S000065 sen CA 1873-12-01 1879-03-03 3 Republican                          
9452 9452 B000630 sen CA 1875-12-06 1881-03-03 1 Republican                          
9608 9608 P000364 rep CA 1875-12-06 1877-03-03   Democrat 1                        
9878 9878 L000522 rep CA 1873-12-01 1875-03-03   Democrat 3                        
9879 9879 L000522 rep CA 1875-12-06 1877-03-03   Democrat 3                        
9880 9880 L000522 rep CA 1877-10-15 1879-03-03   Democrat 3                        
9977 9977 W000449 rep CA 1875-12-06 1877-03-03   Democrat 4                        
9978 9978 W000449 rep CA 1877-10-15 1879-03-03   Democrat 4                        
10057 10057 D000105 rep CA 1877-10-15 1879-03-03   Republican 1                        
10058 10058 D000105 rep CA 1879-03-18 1881-03-03   Republican 1                        
10072 10072 F000020 sen CA 1879-03-18 1885-03-03 3 Democrat                          
10267 10267 B000415 rep CA 1879-03-18 1881-03-03   Democrat 3                        
10268 10268 B000415 rep CA 1881-12-05 1883-03-03   Democrat 3                        
10464 10464 M000740 sen CA 1881-12-05 1887-03-03 1 Republican                          
10492 10492 P000003 rep CA 1877-10-15 1879-03-03   Republican 4                        
10493 10493 P000003 rep CA 1879-03-18 1881-03-03   Republican 4                        
10494 10494 P000003 rep CA 1881-12-05 1883-03-03   Republican 4                        
10495 10495 P000017 rep CA 1873-12-01 1875-03-03   Republican 2                        
10496 10496 P000017 rep CA 1875-12-06 1877-03-03   Republican 2                        
10497 10497 P000017 rep CA 1877-10-15 1879-03-03   Republican 2                        
10498 10498 P000017 rep CA 1879-03-18 1881-03-03   Republican 2                        
10499 10499 P000017 rep CA 1881-12-05 1883-03-03   Republican 2                        
10661 10661 B001034 rep CA 1883-12-03 1885-03-03   Democrat 2                        
10729 10729 G000229 rep CA 1883-12-03 1885-03-03   Democrat -1                        
10868 10868 R000440 rep CA 1881-12-05 1883-03-03   Democrat 1                        
10869 10869 R000440 rep CA 1883-12-03 1885-03-03   Democrat 1                        
10905 10905 S001069 rep CA 1883-12-03 1885-03-03   Democrat -1                        
10911 10911 T000407 rep CA 1883-12-03 1885-03-03   Democrat 4                        
11076 11076 H000498 rep CA 1883-12-03 1885-03-03   Democrat 3                        
11077 11077 H000498 rep CA 1885-12-07 1887-03-03   Democrat 1                        
11119 11119 L000453 rep CA 1885-12-07 1887-03-03   Republican 2                        
11124 11124 M000134 rep CA 1885-12-07 1887-03-03   Republican 6                        
11282 11282 W000486 sen CA 1886-01-01 1887-03-03 1 Republican                          
11390 11390 H000428 sen CA 1886-01-01 1887-03-03 1 Democrat                          
11391 11391 H000428 sen CA 1887-12-05 1891-12-31 1 Democrat                          
11528 11528 T000219 rep CA 1887-12-05 1889-03-03   Democrat 1                        
11607 11607 B000458 rep CA 1887-12-05 1889-03-03   Democrat 2                        
11608 11608 B000458 rep CA 1889-12-02 1891-03-03   Democrat 2                        
11673 11673 C000536 rep CA 1889-12-02 1891-03-03   Democrat 5                        
11725 11725 D000200 rep CA 1889-12-02 1891-03-03   Republican 1                        
11871 11871 M001006 rep CA 1885-12-07 1887-03-03   Republican 4                        
11872 11872 M001006 rep CA 1887-12-05 1889-03-03   Republican 4                        
11873 11873 M001006 rep CA 1889-12-02 1891-03-03   Republican 4                        
12001 12001 V000031 rep CA 1887-12-05 1889-03-03   Republican 6                        
12002 12002 V000031 rep CA 1889-12-02 1891-03-03   Republican 6                        
12146 12146 C001030 rep CA 1891-12-07 1893-03-03   Republican 4                        
12154 12154 F000068 rep CA 1885-12-07 1887-03-03   Republican 5                        
12155 12155 F000068 rep CA 1887-12-05 1889-03-03   Republican 5                        
12156 12156 F000068 sen CA 1891-12-07 1893-03-03 1 Republican                          
12238 12238 M000500 rep CA 1885-12-07 1887-03-03   Republican 3                        
12239 12239 M000500 rep CA 1887-12-05 1889-03-03   Republican 3                        
12240 12240 M000500 rep CA 1889-12-02 1891-03-03   Republican 3                        
12241 12241 M000500 rep CA 1891-12-07 1893-03-03   Republican 3                        
12302 12302 S000793 sen CA 1885-12-07 1891-03-03 3 Republican                          
12303 12303 S000793 sen CA 1891-12-07 1893-12-31 3 Republican                          

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