legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
442 rows where state = "OK"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, class, district, url, phone, fax, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12191 | 12191 | David Harvey H000305 | rep | OK | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
12192 | 12192 | David Harvey H000305 | rep | OK | 1891-12-07 | 1893-03-03 | Republican | -1 | |||||||||||||
13270 | 13270 | James Callahan C000053 | rep | OK | 1897-03-15 | 1899-03-03 | Free Silver | -1 | |||||||||||||
13959 | 13959 | Dennis Flynn F000226 | rep | OK | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
13960 | 13960 | Dennis Flynn F000226 | rep | OK | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13961 | 13961 | Dennis Flynn F000226 | rep | OK | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13962 | 13962 | Dennis Flynn F000226 | rep | OK | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
15113 | 15113 | Elmer Fulton F000421 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15408 | 15408 | Charles Creager C000897 | rep | OK | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
16479 | 16479 | Bird McGuire M000464 | rep | OK | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16480 | 16480 | Bird McGuire M000464 | rep | OK | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16481 | 16481 | Bird McGuire M000464 | rep | OK | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
16482 | 16482 | Bird McGuire M000464 | rep | OK | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
16483 | 16483 | Bird McGuire M000464 | rep | OK | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16484 | 16484 | Bird McGuire M000464 | rep | OK | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
16630 | 16630 | Claude Weaver W000224 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16744 | 16744 | James Davenport D000074 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
16745 | 16745 | James Davenport D000074 | rep | OK | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16746 | 16746 | James Davenport D000074 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16747 | 16747 | James Davenport D000074 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16902 | 16902 | William Murray M001118 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16903 | 16903 | William Murray M001118 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17691 | 17691 | Scott Ferris F000091 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
17692 | 17692 | Scott Ferris F000091 | rep | OK | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
17693 | 17693 | Scott Ferris F000091 | rep | OK | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
17694 | 17694 | Scott Ferris F000091 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17695 | 17695 | Scott Ferris F000091 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17696 | 17696 | Scott Ferris F000091 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17697 | 17697 | Scott Ferris F000091 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17854 | 17854 | Dick Morgan M000947 | rep | OK | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
17855 | 17855 | Dick Morgan M000947 | rep | OK | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
17856 | 17856 | Dick Morgan M000947 | rep | OK | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17857 | 17857 | Dick Morgan M000947 | rep | OK | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17858 | 17858 | Dick Morgan M000947 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17859 | 17859 | Dick Morgan M000947 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17878 | 17878 | Robert Owen O000153 | sen | OK | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
17879 | 17879 | Robert Owen O000153 | sen | OK | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17880 | 17880 | Robert Owen O000153 | sen | OK | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17972 | 17972 | Charles Swindall S001121 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17974 | 17974 | Joseph Thompson T000210 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17975 | 17975 | Joseph Thompson T000210 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17976 | 17976 | Joseph Thompson T000210 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17977 | 17977 | Joseph Thompson T000210 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18116 | 18116 | Thomas Chandler C000295 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18117 | 18117 | Thomas Chandler C000295 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18192 | 18192 | Lorraine Gensman G000123 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18215 | 18215 | John Harreld H000227 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18216 | 18216 | John Harreld H000227 | sen | OK | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18220 | 18220 | Manuel Herrick H000540 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18422 | 18422 | Joseph Pringey P000542 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18441 | 18441 | Alice Robertson R000318 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18916 | 18916 | Charles Carter C000196 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
18917 | 18917 | Charles Carter C000196 | rep | OK | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
18918 | 18918 | Charles Carter C000196 | rep | OK | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
18919 | 18919 | Charles Carter C000196 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18920 | 18920 | Charles Carter C000196 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18921 | 18921 | Charles Carter C000196 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18922 | 18922 | Charles Carter C000196 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18923 | 18923 | Charles Carter C000196 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18924 | 18924 | Charles Carter C000196 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
18925 | 18925 | Charles Carter C000196 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19045 | 19045 | Samuel Montgomery M000870 | rep | OK | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19062 | 19062 | William Pine P000360 | sen | OK | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
19356 | 19356 | Everette Howard H000837 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19357 | 19357 | Everette Howard H000837 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19358 | 19358 | Everette Howard H000837 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19912 | 19912 | Charles O’Connor O000027 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20000 | 20000 | Ulysses Stone S000964 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20403 | 20403 | Milton Garber G000046 | rep | OK | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20404 | 20404 | Milton Garber G000046 | rep | OK | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
20405 | 20405 | Milton Garber G000046 | rep | OK | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
20406 | 20406 | Milton Garber G000046 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20407 | 20407 | Milton Garber G000046 | rep | OK | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
20430 | 20430 | Thomas Gore G000323 | sen | OK | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
20431 | 20431 | Thomas Gore G000323 | sen | OK | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20433 | 20433 | Thomas Gore G000323 | sen | OK | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
21306 | 21306 | William Hastings H000333 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
21307 | 21307 | William Hastings H000333 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
21308 | 21308 | William Hastings H000333 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
21309 | 21309 | William Hastings H000333 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21310 | 21310 | William Hastings H000333 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
21311 | 21311 | William Hastings H000333 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
21312 | 21312 | William Hastings H000333 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21313 | 21313 | William Hastings H000333 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21314 | 21314 | William Hastings H000333 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21394 | 21394 | Ernest Marland M000138 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21399 | 21399 | James McClintic M000338 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
21400 | 21400 | James McClintic M000338 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
21401 | 21401 | James McClintic M000338 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
21402 | 21402 | James McClintic M000338 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
21403 | 21403 | James McClintic M000338 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21404 | 21404 | James McClintic M000338 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
21405 | 21405 | James McClintic M000338 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21406 | 21406 | James McClintic M000338 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21407 | 21407 | James McClintic M000338 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21408 | 21408 | James McClintic M000338 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21423 | 21423 | Thomas McKeown M000511 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21424 | 21424 | Thomas McKeown M000511 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21425 | 21425 | Thomas McKeown M000511 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 4 |
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);