legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
887 rows where state = "FL" sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2245 | 2245 | Joseph Hernández H000533 | rep | FL | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2389 | 2389 | Richard Call C000050 | rep | FL | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
4106 | 4106 | Joseph White W000383 | rep | FL | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
4107 | 4107 | Joseph White W000383 | rep | FL | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
4108 | 4108 | Joseph White W000383 | rep | FL | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
4109 | 4109 | Joseph White W000383 | rep | FL | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
4110 | 4110 | Joseph White W000383 | rep | FL | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
4111 | 4111 | Joseph White W000383 | rep | FL | 1835-12-07 | 1837-03-03 | -1 | ||||||||||||||
4463 | 4463 | Charles Downing D000472 | rep | FL | 1837-09-04 | 1839-03-03 | -1 | ||||||||||||||
4464 | 4464 | Charles Downing D000472 | rep | FL | 1839-12-02 | 1841-03-03 | -1 | ||||||||||||||
5366 | 5366 | William Brockenbrough B000852 | rep | FL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5572 | 5572 | James Westcott W000308 | sen | FL | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
6869 | 6869 | Augustus Maxwell M000266 | rep | FL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6870 | 6870 | Augustus Maxwell M000266 | rep | FL | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
6957 | 6957 | David Yulee Y000061 | rep | FL | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6958 | 6958 | David Yulee Y000061 | rep | FL | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6959 | 6959 | David Yulee Y000061 | sen | FL | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6960 | 6960 | David Yulee Y000061 | sen | FL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7139 | 7139 | Stephen Mallory M000084 | sen | FL | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
7140 | 7140 | Stephen Mallory M000084 | sen | FL | 1857-12-07 | 1861-01-21 | 1 | Democrat | |||||||||||||
7439 | 7439 | George Hawkins H000369 | rep | FL | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7440 | 7440 | George Hawkins H000369 | rep | FL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
8982 | 8982 | Silas Niblack N000082 | rep | FL | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
10117 | 10117 | Noble Hull H000945 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10345 | 10345 | Jesse Finley F000134 | rep | FL | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
10346 | 10346 | Jesse Finley F000134 | rep | FL | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10347 | 10347 | Jesse Finley F000134 | rep | FL | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10404 | 10404 | Charles Jones J000214 | sen | FL | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10405 | 10405 | Charles Jones J000214 | sen | FL | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
11348 | 11348 | Charles Dougherty D000445 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11349 | 11349 | Charles Dougherty D000445 | rep | FL | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
11718 | 11718 | Robert Davidson D000085 | rep | FL | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11719 | 11719 | Robert Davidson D000085 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11720 | 11720 | Robert Davidson D000085 | rep | FL | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11721 | 11721 | Robert Davidson D000085 | rep | FL | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
11722 | 11722 | Robert Davidson D000085 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11723 | 11723 | Robert Davidson D000085 | rep | FL | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11724 | 11724 | Robert Davidson D000085 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12109 | 12109 | Robert Bullock B001052 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12110 | 12110 | Robert Bullock B001052 | rep | FL | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12123 | 12123 | Wilkinson Call C000051 | sen | FL | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
12124 | 12124 | Wilkinson Call C000051 | sen | FL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12125 | 12125 | Wilkinson Call C000051 | sen | FL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12750 | 12750 | Samuel Pasco P000095 | sen | FL | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12751 | 12751 | Samuel Pasco P000095 | sen | FL | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12962 | 12962 | Charles Cooper C000746 | rep | FL | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12963 | 12963 | Charles Cooper C000746 | rep | FL | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
14282 | 14282 | Robert Davis D000132 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
14283 | 14283 | Robert Davis D000132 | rep | FL | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
14284 | 14284 | Robert Davis D000132 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14285 | 14285 | Robert Davis D000132 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14397 | 14397 | Stephen Mallory M000085 | rep | FL | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
14398 | 14398 | Stephen Mallory M000085 | rep | FL | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
14399 | 14399 | Stephen Mallory M000085 | sen | FL | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
14400 | 14400 | Stephen Mallory M000085 | sen | FL | 1903-11-09 | 1907-12-23 | 3 | Democrat | |||||||||||||
14916 | 14916 | James Taliaferro T000026 | sen | FL | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14917 | 14917 | James Taliaferro T000026 | sen | FL | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
15012 | 15012 | William Bryan B000994 | sen | FL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
15183 | 15183 | William Lamar L000031 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
15184 | 15184 | William Lamar L000031 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15185 | 15185 | William Lamar L000031 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15314 | 15314 | William Milton M000788 | sen | FL | 1908-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
15887 | 15887 | Nathan Bryan B000992 | sen | FL | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16079 | 16079 | Dannite Mays M000289 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16080 | 16080 | Dannite Mays M000289 | rep | FL | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16436 | 16436 | Claude L’Engle L000548 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16987 | 16987 | Stephen Sparkman S000702 | rep | FL | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
16988 | 16988 | Stephen Sparkman S000702 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16989 | 16989 | Stephen Sparkman S000702 | rep | FL | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16990 | 16990 | Stephen Sparkman S000702 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
16991 | 16991 | Stephen Sparkman S000702 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16992 | 16992 | Stephen Sparkman S000702 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16993 | 16993 | Stephen Sparkman S000702 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
16994 | 16994 | Stephen Sparkman S000702 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16995 | 16995 | Stephen Sparkman S000702 | rep | FL | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16996 | 16996 | Stephen Sparkman S000702 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16997 | 16997 | Stephen Sparkman S000702 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17037 | 17037 | Emmett Wilson W000575 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17038 | 17038 | Emmett Wilson W000575 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17326 | 17326 | James Kehoe K000046 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18583 | 18583 | Frank Clark C000430 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
18584 | 18584 | Frank Clark C000430 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
18585 | 18585 | Frank Clark C000430 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
18586 | 18586 | Frank Clark C000430 | rep | FL | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
18587 | 18587 | Frank Clark C000430 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18588 | 18588 | Frank Clark C000430 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18589 | 18589 | Frank Clark C000430 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18590 | 18590 | Frank Clark C000430 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18591 | 18591 | Frank Clark C000430 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18592 | 18592 | Frank Clark C000430 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19109 | 19109 | John Smithwick S000643 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19110 | 19110 | John Smithwick S000643 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19111 | 19111 | John Smithwick S000643 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19112 | 19112 | John Smithwick S000643 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20311 | 20311 | Herbert Drane D000486 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20312 | 20312 | Herbert Drane D000486 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20313 | 20313 | Herbert Drane D000486 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
20314 | 20314 | Herbert Drane D000486 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20315 | 20315 | Herbert Drane D000486 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
20316 | 20316 | Herbert Drane D000486 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 1 |
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);