legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
115 rows where state = "ND" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, party, address, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14341 | 14341 | Henry Hansbrough H000169 | rep | ND | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14481 | 14481 | Burleigh Spalding S000695 | rep | ND | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14482 | 14482 | Burleigh Spalding S000695 | rep | ND | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15209 | 15209 | Thomas Marshall M000163 | rep | ND | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15210 | 15210 | Thomas Marshall M000163 | rep | ND | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15211 | 15211 | Thomas Marshall M000163 | rep | ND | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15212 | 15212 | Thomas Marshall M000163 | rep | ND | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15558 | 15558 | Martin Johnson J000162 | rep | ND | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
15559 | 15559 | Martin Johnson J000162 | rep | ND | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15560 | 15560 | Martin Johnson J000162 | rep | ND | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15561 | 15561 | Martin Johnson J000162 | rep | ND | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15991 | 15991 | Louis Hanna H000162 | rep | ND | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
15992 | 15992 | Louis Hanna H000162 | rep | ND | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
16769 | 16769 | Asle Gronna G000491 | rep | ND | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16770 | 16770 | Asle Gronna G000491 | rep | ND | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
16771 | 16771 | Asle Gronna G000491 | rep | ND | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
17262 | 17262 | Henry Helgesen H000459 | rep | ND | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
17263 | 17263 | Henry Helgesen H000459 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17264 | 17264 | Henry Helgesen H000459 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17265 | 17265 | Henry Helgesen H000459 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17363 | 17363 | Patrick Norton N000156 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17364 | 17364 | Patrick Norton N000156 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17365 | 17365 | Patrick Norton N000156 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17541 | 17541 | John Baer B000027 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17542 | 17542 | John Baer B000027 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18901 | 18901 | George Young Y000036 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18902 | 18902 | George Young Y000036 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18903 | 18903 | George Young Y000036 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18904 | 18904 | George Young Y000036 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18905 | 18905 | George Young Y000036 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18906 | 18906 | George Young Y000036 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20144 | 20144 | Olger Burtness B001146 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20145 | 20145 | Olger Burtness B001146 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20146 | 20146 | Olger Burtness B001146 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20147 | 20147 | Olger Burtness B001146 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20148 | 20148 | Olger Burtness B001146 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20149 | 20149 | Olger Burtness B001146 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20463 | 20463 | Thomas Hall H000071 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20464 | 20464 | Thomas Hall H000071 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20465 | 20465 | Thomas Hall H000071 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20466 | 20466 | Thomas Hall H000071 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20467 | 20467 | Thomas Hall H000071 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21543 | 21543 | James Sinclair S000442 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21544 | 21544 | James Sinclair S000442 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21545 | 21545 | James Sinclair S000442 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21546 | 21546 | James Sinclair S000442 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21547 | 21547 | James Sinclair S000442 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21548 | 21548 | James Sinclair S000442 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21549 | 21549 | James Sinclair S000442 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21550 | 21550 | James Sinclair S000442 | rep | ND | 1933-03-09 | 1935-01-03 | Republican | -1 | |||||||||||||
24647 | 24647 | Charles Robertson R000319 | rep | ND | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
24648 | 24648 | Charles Robertson R000319 | rep | ND | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
24649 | 24649 | Charles Robertson R000319 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24881 | 24881 | William Lemke L000238 | rep | ND | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
24882 | 24882 | William Lemke L000238 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
24883 | 24883 | William Lemke L000238 | rep | ND | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
24884 | 24884 | William Lemke L000238 | rep | ND | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
24885 | 24885 | William Lemke L000238 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24886 | 24886 | William Lemke L000238 | rep | ND | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
24887 | 24887 | William Lemke L000238 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24888 | 24888 | William Lemke L000238 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25111 | 25111 | Fred Aandahl A000001 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
26189 | 26189 | Usher Burdick B001079 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
26190 | 26190 | Usher Burdick B001079 | rep | ND | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
26191 | 26191 | Usher Burdick B001079 | rep | ND | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
26192 | 26192 | Usher Burdick B001079 | rep | ND | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
26193 | 26193 | Usher Burdick B001079 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
26194 | 26194 | Usher Burdick B001079 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
26195 | 26195 | Usher Burdick B001079 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
26196 | 26196 | Usher Burdick B001079 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26197 | 26197 | Usher Burdick B001079 | rep | ND | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26198 | 26198 | Usher Burdick B001079 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26466 | 26466 | Otto Krueger K000332 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26467 | 26467 | Otto Krueger K000332 | rep | ND | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26468 | 26468 | Otto Krueger K000332 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
28051 | 28051 | Hjalmar Nygaard N000178 | rep | ND | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28052 | 28052 | Hjalmar Nygaard N000178 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28153 | 28153 | Don Short S000378 | rep | ND | 1959-01-07 | 1961-01-03 | Republican | 0 | |||||||||||||
28154 | 28154 | Don Short S000378 | rep | ND | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28155 | 28155 | Don Short S000378 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28616 | 28616 | Rolland Redlin R000107 | rep | ND | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29319 | 29319 | Thomas Kleppe K000264 | rep | ND | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29320 | 29320 | Thomas Kleppe K000264 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29893 | 29893 | Arthur Link L000333 | rep | ND | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32435 | 32435 | Mark Andrews A000208 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32436 | 32436 | Mark Andrews A000208 | rep | ND | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32437 | 32437 | Mark Andrews A000208 | rep | ND | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
32438 | 32438 | Mark Andrews A000208 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32439 | 32439 | Mark Andrews A000208 | rep | ND | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
32440 | 32440 | Mark Andrews A000208 | rep | ND | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
32441 | 32441 | Mark Andrews A000208 | rep | ND | 1975-01-14 | 1977-01-03 | Republican | 0 | |||||||||||||
32442 | 32442 | Mark Andrews A000208 | rep | ND | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
32443 | 32443 | Mark Andrews A000208 | rep | ND | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
33839 | 33839 | Quentin Burdick B001077 | rep | ND | 1959-01-07 | 1960-08-08 | Democrat | 0 | |||||||||||||
37612 | 37612 | Byron Dorgan D000432 | rep | ND | 1981-01-05 | 1983-01-03 | Democrat | 0 | |||||||||||||
37613 | 37613 | Byron Dorgan D000432 | rep | ND | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
37614 | 37614 | Byron Dorgan D000432 | rep | ND | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
37615 | 37615 | Byron Dorgan D000432 | rep | ND | 1987-01-06 | 1989-01-03 | Democrat | 0 | |||||||||||||
37616 | 37616 | Byron Dorgan D000432 | rep | ND | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
37617 | 37617 | Byron Dorgan D000432 | rep | ND | 1991-01-03 | 1992-12-14 | Democrat | 0 |
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);