legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
39 rows where party = "Ind. Democrat" sorted by how
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4734 | 4734 | Zadok Casey C000230 | rep | IL | 1841-05-31 | 1843-03-03 | Ind. Democrat | 2 | |||||||||||||
5802 | 5802 | George Petrie P000266 | rep | NY | 1847-12-06 | 1849-03-03 | Ind. Democrat | 17 | |||||||||||||
6078 | 6078 | Henry Nes N000047 | rep | PA | 1843-12-04 | 1845-03-03 | Ind. Democrat | 15 | |||||||||||||
6283 | 6283 | James Doty D000443 | rep | WI | 1851-12-01 | 1853-03-03 | Ind. Democrat | 3 | |||||||||||||
6347 | 6347 | John Johnson J000153 | rep | OH | 1851-12-01 | 1853-03-03 | Ind. Democrat | 16 | |||||||||||||
6388 | 6388 | William Polk P000412 | rep | TN | 1851-12-01 | 1853-03-03 | Ind. Democrat | 6 | |||||||||||||
6520 | 6520 | William Bissell B000492 | rep | IL | 1853-12-05 | 1855-03-03 | Ind. Democrat | 8 | |||||||||||||
7227 | 7227 | Robert Smith S000604 | rep | IL | 1847-12-06 | 1849-03-03 | Ind. Democrat | 1 | |||||||||||||
7277 | 7277 | Thomas Anderson A000234 | rep | MO | 1859-12-05 | 1861-03-03 | Ind. Democrat | 2 | |||||||||||||
7286 | 7286 | Thomas Barr B000172 | rep | NY | 1857-12-07 | 1859-03-03 | Ind. Democrat | 4 | |||||||||||||
7287 | 7287 | Thomas Barr B000172 | rep | NY | 1859-12-05 | 1861-03-03 | Ind. Democrat | 4 | |||||||||||||
7431 | 7431 | Andrew Hamilton H000103 | rep | TX | 1859-12-05 | 1861-03-03 | Ind. Democrat | 2 | |||||||||||||
7484 | 7484 | Shelton Leake L000176 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 6 | |||||||||||||
7494 | 7494 | Elbert Martin M000179 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 13 | |||||||||||||
7733 | 7733 | Daniel De Jarnette D000202 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 3 | |||||||||||||
7778 | 7778 | James Kerrigan K000147 | rep | NY | 1861-07-04 | 1863-03-03 | Ind. Democrat | 4 | |||||||||||||
8828 | 8828 | Francis Blair B000523 | rep | MO | 1857-12-07 | 1859-03-03 | Ind. Democrat | 1 | |||||||||||||
9149 | 9149 | John Davis D000119 | rep | WV | 1873-12-01 | 1875-03-03 | Ind. Democrat | 1 | |||||||||||||
10074 | 10074 | William Felton F000070 | rep | GA | 1875-12-06 | 1877-03-03 | Ind. Democrat | 7 | |||||||||||||
10075 | 10075 | William Felton F000070 | rep | GA | 1877-10-15 | 1879-03-03 | Ind. Democrat | 7 | |||||||||||||
10076 | 10076 | William Felton F000070 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 7 | |||||||||||||
10092 | 10092 | John Harris H000247 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 9 | |||||||||||||
10156 | 10156 | James O’Brien O000011 | rep | NY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 10 | |||||||||||||
10157 | 10157 | Daniel O’Reilly O000099 | rep | NY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 2 | |||||||||||||
10167 | 10167 | Henry Persons P000248 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 4 | |||||||||||||
10184 | 10184 | Samuel Sawyer S000092 | rep | MO | 1879-03-18 | 1881-03-03 | Ind. Democrat | 8 | |||||||||||||
10317 | 10317 | Jordan Cravens C000885 | rep | AR | 1877-10-15 | 1879-03-03 | Ind. Democrat | 3 | |||||||||||||
10547 | 10547 | Emory Speer S000711 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 9 | |||||||||||||
10548 | 10548 | Emory Speer S000711 | rep | GA | 1881-12-05 | 1883-03-03 | Ind. Democrat | 9 | |||||||||||||
10721 | 10721 | John Finerty F000127 | rep | IL | 1883-12-03 | 1885-03-03 | Ind. Democrat | 2 | |||||||||||||
10912 | 10912 | Oscar Turner T000425 | rep | KY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 1 | |||||||||||||
10914 | 10914 | Oscar Turner T000425 | rep | KY | 1883-12-03 | 1885-03-03 | Ind. Democrat | 1 | |||||||||||||
10944 | 10944 | Tyre York Y000022 | rep | NC | 1883-12-03 | 1885-03-03 | Ind. Democrat | 7 | |||||||||||||
11448 | 11448 | Truman Merriman M000658 | rep | NY | 1885-12-07 | 1887-03-03 | Ind. Democrat | 11 | |||||||||||||
12684 | 12684 | Michael McEttrick M000430 | rep | MA | 1893-08-07 | 1895-03-03 | Ind. Democrat | 10 | |||||||||||||
13733 | 13733 | William McAleer M000294 | rep | PA | 1893-08-07 | 1895-03-03 | Ind. Democrat | 3 | |||||||||||||
26085 | 26085 | James Priest P000536 | rep | TN | 1941-01-03 | 1943-01-03 | Ind. Democrat | 5 | |||||||||||||
27073 | 27073 | Thomas Alford A000105 | rep | AR | 1959-01-07 | 1961-01-03 | Ind. Democrat | 5 | |||||||||||||
37040 | 37040 | John Moakley M000834 | rep | MA | 1973-01-03 | 1975-01-03 | Ind. Democrat | 9 |
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);