legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
62 rows where party = "Federalist" and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145 | 145 | William Bingham B000474 | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
251 | 251 | John Chapman C000313 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 4 | |||||||||||||
259 | 259 | George Ege E000089 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 5 | |||||||||||||
260 | 260 | George Ege E000089 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 5 | |||||||||||||
285 | 285 | James Ross R000448 | sen | PA | 1794-01-01 | 1797-03-03 | 1 | Federalist | |||||||||||||
286 | 286 | James Ross R000448 | sen | PA | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
293 | 293 | Samuel Sitgreaves S000460 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 4 | |||||||||||||
294 | 294 | Samuel Sitgreaves S000460 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 4 | |||||||||||||
376 | 376 | Thomas Hartley H000299 | rep | PA | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
377 | 377 | Thomas Hartley H000299 | rep | PA | 1791-10-24 | 1793-03-03 | Federalist | 7 | |||||||||||||
378 | 378 | Thomas Hartley H000299 | rep | PA | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
379 | 379 | Thomas Hartley H000299 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 8 | |||||||||||||
380 | 380 | Thomas Hartley H000299 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 8 | |||||||||||||
381 | 381 | Thomas Hartley H000299 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
388 | 388 | John Kittera K000253 | rep | PA | 1791-10-24 | 1793-03-03 | Federalist | 5 | |||||||||||||
389 | 389 | John Kittera K000253 | rep | PA | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
390 | 390 | John Kittera K000253 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 7 | |||||||||||||
391 | 391 | John Kittera K000253 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 7 | |||||||||||||
392 | 392 | John Kittera K000253 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
440 | 440 | Richard Thomas T000183 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 3 | |||||||||||||
441 | 441 | Richard Thomas T000183 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 3 | |||||||||||||
442 | 442 | Richard Thomas T000183 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
443 | 443 | Robert Waln W000094 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 1 | |||||||||||||
444 | 444 | Robert Waln W000094 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
458 | 458 | Thomas Boude B000660 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 7 | |||||||||||||
546 | 546 | Henry Woods W000722 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
547 | 547 | Henry Woods W000722 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
862 | 862 | James Kelly K000073 | rep | PA | 1805-12-02 | 1807-03-03 | Federalist | 6 | |||||||||||||
863 | 863 | James Kelly K000073 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 6 | |||||||||||||
999 | 999 | Robert Jenkins J000087 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 3 | |||||||||||||
1000 | 1000 | Robert Jenkins J000087 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1193 | 1193 | James Milnor M000785 | rep | PA | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1344 | 1344 | John Gloninger G000241 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1351 | 1351 | Samuel Henderson H000487 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1404 | 1404 | Amos Slaymaker S000483 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1709 | 1709 | Thomas Smith S000617 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1773 | 1773 | John Woods W000725 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
1821 | 1821 | Isaac Darlington D000057 | rep | PA | 1817-12-01 | 1819-03-03 | Federalist | 2 | |||||||||||||
1861 | 1861 | Joseph Hopkinson H000784 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1862 | 1862 | Joseph Hopkinson H000784 | rep | PA | 1817-12-01 | 1819-03-03 | Federalist | 1 | |||||||||||||
1892 | 1892 | Levi Pawling P000147 | rep | PA | 1817-12-01 | 1819-03-03 | Federalist | 2 | |||||||||||||
2073 | 2073 | Thomas McCullough M000396 | rep | PA | 1819-12-06 | 1821-03-03 | Federalist | 5 | |||||||||||||
2238 | 2238 | Thomas Forrest F000281 | rep | PA | 1819-12-06 | 1821-03-03 | Federalist | 1 | |||||||||||||
2239 | 2239 | Thomas Forrest F000281 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2266 | 2266 | James McSherry M000602 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2267 | 2267 | William Milnor M000786 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 2 | |||||||||||||
2268 | 2268 | William Milnor M000786 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
2269 | 2269 | William Milnor M000786 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
2270 | 2270 | William Milnor M000786 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2299 | 2299 | John Phillips P000310 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
2352 | 2352 | Ludwig Worman W000745 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2586 | 2586 | Samuel Edwards E000080 | rep | PA | 1819-12-06 | 1821-03-03 | Federalist | 1 | |||||||||||||
2587 | 2587 | Samuel Edwards E000080 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3121 | 3121 | Joseph Hemphill H000470 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
3122 | 3122 | Joseph Hemphill H000470 | rep | PA | 1819-12-06 | 1821-03-03 | Federalist | 1 | |||||||||||||
3123 | 3123 | Joseph Hemphill H000470 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3124 | 3124 | Joseph Hemphill H000470 | rep | PA | 1823-12-01 | 1825-03-03 | Federalist | 2 | |||||||||||||
4989 | 4989 | John Sergeant S000246 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
4990 | 4990 | John Sergeant S000246 | rep | PA | 1817-12-01 | 1819-03-03 | Federalist | 1 | |||||||||||||
4991 | 4991 | John Sergeant S000246 | rep | PA | 1819-12-06 | 1821-03-03 | Federalist | 1 | |||||||||||||
4992 | 4992 | John Sergeant S000246 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
6963 | 6963 | James Buchanan B001005 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 3 |
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);