legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where "start" is on date 1947-01-03 and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24290 | 24290 | Raymond Burke B001096 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24292 | 24292 | Henderson Carson C000192 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
24440 | 24440 | Percy Griffiths G000472 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
24507 | 24507 | Robert Jones J000249 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24554 | 24554 | Earl Lewis L000279 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
24597 | 24597 | Edward McCowen M000374 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24639 | 24639 | Homer Ramey R000022 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24855 | 24855 | Walter Huber H000898 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
25025 | 25025 | Frederick Smith S000536 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25152 | 25152 | Walter Brehm B000794 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25253 | 25253 | Charles Elston E000160 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25606 | 25606 | John Bricker B000820 | sen | OH | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25654 | 25654 | Robert Crosser C000932 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
25829 | 25829 | Alvin Weichel W000252 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25851 | 25851 | George Bender B000356 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
26232 | 26232 | Cliff Clevenger C000515 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26430 | 26430 | Thomas Jenkins J000088 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
26508 | 26508 | J. McGregor M000460 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
26637 | 26637 | John Vorys V000119 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
26875 | 26875 | William Hess H000550 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
28347 | 28347 | Clarence Brown B000909 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
28791 | 28791 | Frances Bolton B000607 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
29257 | 29257 | Michael Feighan F000060 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
29307 | 29307 | Michael Kirwan K000244 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
29911 | 29911 | William McCulloch M000393 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 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);