legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
318 rows where state = "NE" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: party, district, address, fax, office, rss_url, start (date), end (date)
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6595 | 6595 | Napoleon Giddings G000168 | rep | NE | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6785 | 6785 | Bird Chapman C000309 | rep | NE | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
7043 | 7043 | Fenner Ferguson F000080 | rep | NE | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7401 | 7401 | Experience Estabrook E000220 | rep | NE | 1859-12-05 | 1861-03-03 | -1 | ||||||||||||||
7937 | 7937 | Samuel Daily D000006 | rep | NE | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7938 | 7938 | Samuel Daily D000006 | rep | NE | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
7939 | 7939 | Samuel Daily D000006 | rep | NE | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8383 | 8383 | Turner Marquette M000140 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8384 | 8384 | Turner Marquette M000140 | rep | NE | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8932 | 8932 | Phineas Hitchcock H000648 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
9035 | 9035 | John Taffe T000006 | rep | NE | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
9036 | 9036 | John Taffe T000006 | rep | NE | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
9037 | 9037 | John Taffe T000006 | rep | NE | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9489 | 9489 | Lorenzo Crounse C000935 | rep | NE | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9490 | 9490 | Lorenzo Crounse C000935 | rep | NE | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9975 | 9975 | Frank Welch W000262 | rep | NE | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10137 | 10137 | Thomas Majors M000075 | rep | NE | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10138 | 10138 | Thomas Majors M000075 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10915 | 10915 | Edward Valentine V000005 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10916 | 10916 | Edward Valentine V000005 | rep | NE | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
10917 | 10917 | Edward Valentine V000005 | rep | NE | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
11259 | 11259 | Archibald Weaver W000223 | rep | NE | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
11260 | 11260 | Archibald Weaver W000223 | rep | NE | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11447 | 11447 | John McShane M000601 | rep | NE | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11685 | 11685 | William Connell C000688 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11737 | 11737 | George Dorsey D000439 | rep | NE | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11738 | 11738 | George Dorsey D000439 | rep | NE | 1887-12-05 | 1889-03-03 | Republican | 3 | |||||||||||||
11739 | 11739 | George Dorsey D000439 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
11813 | 11813 | James Laird L000023 | rep | NE | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
11814 | 11814 | James Laird L000023 | rep | NE | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11815 | 11815 | James Laird L000023 | rep | NE | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
11816 | 11816 | James Laird L000023 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11822 | 11822 | Gilbert Laws L000143 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12447 | 12447 | William Bryan B000995 | rep | NE | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12448 | 12448 | William Bryan B000995 | rep | NE | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12687 | 12687 | William McKeighan M000498 | rep | NE | 1891-12-07 | 1893-03-03 | Populist | 2 | |||||||||||||
12688 | 12688 | William McKeighan M000498 | rep | NE | 1893-08-07 | 1895-03-03 | Populist | 5 | |||||||||||||
13014 | 13014 | Eugene Hainer H000024 | rep | NE | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
13015 | 13015 | Eugene Hainer H000024 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13044 | 13044 | Omer Kem K000083 | rep | NE | 1891-12-07 | 1893-03-03 | Populist | 3 | |||||||||||||
13045 | 13045 | Omer Kem K000083 | rep | NE | 1893-08-07 | 1895-03-03 | Populist | 6 | |||||||||||||
13046 | 13046 | Omer Kem K000083 | rep | NE | 1895-12-02 | 1897-03-03 | Populist | 6 | |||||||||||||
13087 | 13087 | George Meiklejohn M000634 | rep | NE | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
13088 | 13088 | George Meiklejohn M000634 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13392 | 13392 | Samuel Maxwell M000270 | rep | NE | 1897-03-15 | 1899-03-03 | Populist | 3 | |||||||||||||
13499 | 13499 | Jesse Strode S001007 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13500 | 13500 | Jesse Strode S001007 | rep | NE | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13672 | 13672 | William Greene G000429 | rep | NE | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13673 | 13673 | William Greene G000429 | rep | NE | 1899-12-04 | 1901-03-03 | Populist | 6 | |||||||||||||
13806 | 13806 | Roderick Sutherland S001085 | rep | NE | 1897-03-15 | 1899-03-03 | Populist | 5 | |||||||||||||
13807 | 13807 | Roderick Sutherland S001085 | rep | NE | 1899-12-04 | 1901-03-03 | Populist | 5 | |||||||||||||
14074 | 14074 | David Mercer M000643 | rep | NE | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14075 | 14075 | David Mercer M000643 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14076 | 14076 | David Mercer M000643 | rep | NE | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14077 | 14077 | David Mercer M000643 | rep | NE | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14078 | 14078 | David Mercer M000643 | rep | NE | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14111 | 14111 | William Neville N000056 | rep | NE | 1899-12-04 | 1901-03-03 | Populist | 6 | |||||||||||||
14112 | 14112 | William Neville N000056 | rep | NE | 1901-12-02 | 1903-03-03 | Populist | 6 | |||||||||||||
14142 | 14142 | John Robinson R000345 | rep | NE | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14143 | 14143 | John Robinson R000345 | rep | NE | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14174 | 14174 | William Stark S000811 | rep | NE | 1897-03-15 | 1899-03-03 | Populist | 4 | |||||||||||||
14175 | 14175 | William Stark S000811 | rep | NE | 1899-12-04 | 1901-03-03 | Populist | 4 | |||||||||||||
14176 | 14176 | William Stark S000811 | rep | NE | 1901-12-02 | 1903-03-03 | Populist | 4 | |||||||||||||
14599 | 14599 | Elmer Burkett B001103 | rep | NE | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14600 | 14600 | Elmer Burkett B001103 | rep | NE | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14601 | 14601 | Elmer Burkett B001103 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14739 | 14739 | John Kennedy K000108 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14809 | 14809 | John McCarthy M000314 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14810 | 14810 | John McCarthy M000314 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14989 | 14989 | John Boyd B000717 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15249 | 15249 | Ernest Pollard P000413 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15250 | 15250 | Ernest Pollard P000413 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15518 | 15518 | Edmund Hinshaw H000639 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
15519 | 15519 | Edmund Hinshaw H000639 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
15520 | 15520 | Edmund Hinshaw H000639 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15521 | 15521 | Edmund Hinshaw H000639 | rep | NE | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
16034 | 16034 | James Latta L000117 | rep | NE | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16035 | 16035 | James Latta L000117 | rep | NE | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16283 | 16283 | Silas Barton B000216 | rep | NE | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
16458 | 16458 | John Maguire M000060 | rep | NE | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16459 | 16459 | John Maguire M000060 | rep | NE | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16460 | 16460 | John Maguire M000060 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17286 | 17286 | Gilbert Hitchcock H000645 | rep | NE | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
17287 | 17287 | Gilbert Hitchcock H000645 | rep | NE | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
17288 | 17288 | Gilbert Hitchcock H000645 | rep | NE | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
17341 | 17341 | Charles Lobeck L000385 | rep | NE | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
17342 | 17342 | Charles Lobeck L000385 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17343 | 17343 | Charles Lobeck L000385 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17344 | 17344 | Charles Lobeck L000385 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17445 | 17445 | Dan Stephens S000856 | rep | NE | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
17446 | 17446 | Dan Stephens S000856 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17447 | 17447 | Dan Stephens S000856 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17448 | 17448 | Dan Stephens S000856 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18033 | 18033 | William Andrews A000251 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
18034 | 18034 | William Andrews A000251 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18035 | 18035 | William Andrews A000251 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18165 | 18165 | Robert Evans E000256 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18166 | 18166 | Robert Evans E000256 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18231 | 18231 | Augustin Humphrey H000949 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18251 | 18251 | Albert Jefferis J000067 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 2 |
Advanced export
JSON shape: default, array, newline-delimited
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, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);