legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
887 rows where state = "FL"
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 | |||||||||||||
6074 | 6074 | Jackson Morton M001015 | sen | FL | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6242 | 6242 | Edward Cabell C000003 | rep | FL | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6243 | 6243 | Edward Cabell C000003 | rep | FL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6244 | 6244 | Edward Cabell C000003 | rep | FL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6245 | 6245 | Edward Cabell C000003 | rep | FL | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
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 | |||||||||||||
8496 | 8496 | Thomas Osborn O000109 | sen | FL | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
8502 | 8502 | Adonijah Welch W000261 | sen | FL | 1868-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
8603 | 8603 | Abijah Gilbert G000171 | sen | FL | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
8614 | 8614 | Charles Hamilton H000105 | rep | FL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8615 | 8615 | Charles Hamilton H000105 | rep | FL | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8982 | 8982 | Silas Niblack N000082 | rep | FL | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9133 | 9133 | Simon Conover C000701 | sen | FL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9615 | 9615 | William Purman P000572 | rep | FL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9616 | 9616 | William Purman P000572 | rep | FL | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9680 | 9680 | Josiah Walls W000093 | rep | FL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9681 | 9681 | Josiah Walls W000093 | rep | FL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9682 | 9682 | Josiah Walls W000093 | rep | FL | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
10638 | 10638 | Horatio Bisbee B000485 | rep | FL | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10639 | 10639 | Horatio Bisbee B000485 | rep | FL | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10640 | 10640 | Horatio Bisbee B000485 | rep | FL | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
10641 | 10641 | Horatio Bisbee B000485 | rep | FL | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
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 |
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);