legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
171 rows where state = "ND"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, district, url, phone, fax, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11656 | 11656 | Lyman Casey C000227 | sen | ND | 1889-12-02 | 1893-03-03 | 1 | Republican | |||||||||||||
11903 | 11903 | Gilbert Pierce P000334 | sen | ND | 1889-12-02 | 1891-03-03 | 3 | Republican | |||||||||||||
12770 | 12770 | William Roach R000290 | sen | ND | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14341 | 14341 | Henry Hansbrough H000169 | rep | ND | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14342 | 14342 | Henry Hansbrough H000169 | sen | ND | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14343 | 14343 | Henry Hansbrough H000169 | sen | ND | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14344 | 14344 | Henry Hansbrough H000169 | sen | ND | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
15562 | 15562 | Martin Johnson J000162 | sen | ND | 1909-03-15 | 1909-12-31 | 3 | Republican | |||||||||||||
15790 | 15790 | Fountain Thompson T000199 | sen | ND | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15827 | 15827 | William Purcell P000570 | sen | ND | 1910-01-01 | 1911-12-31 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
16772 | 16772 | Asle Gronna G000491 | sen | ND | 1911-04-04 | 1915-03-03 | 3 | Republican | |||||||||||||
16773 | 16773 | Asle Gronna G000491 | sen | ND | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17348 | 17348 | Porter McCumber M000397 | sen | ND | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
17349 | 17349 | Porter McCumber M000397 | sen | ND | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17350 | 17350 | Porter McCumber M000397 | sen | ND | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
18302 | 18302 | Edwin Ladd L000012 | sen | ND | 1921-04-11 | 1925-12-31 | 3 | Republican | |||||||||||||
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 | |||||||||||||
21765 | 21765 | Lynn Frazier F000354 | sen | ND | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
21766 | 21766 | Lynn Frazier F000354 | sen | ND | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21767 | 21767 | Lynn Frazier F000354 | sen | ND | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22734 | 22734 | Gerald Nye N000176 | sen | ND | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
22735 | 22735 | Gerald Nye N000176 | sen | ND | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
22736 | 22736 | Gerald Nye N000176 | sen | ND | 1933-03-09 | 1939-01-03 | 3 | Republican | |||||||||||||
22737 | 22737 | Gerald Nye N000176 | sen | ND | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23992 | 23992 | John Moses M001029 | sen | ND | 1945-01-03 | 1945-12-31 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
25743 | 25743 | William Langer L000070 | sen | ND | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25744 | 25744 | William Langer L000070 | sen | ND | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25745 | 25745 | William Langer L000070 | sen | ND | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25746 | 25746 | William Langer L000070 | sen | ND | 1959-01-03 | 1959-11-08 | 1 | Republican | |||||||||||||
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 |
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);