legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
60 rows where state = "PR"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, end (date)
party 8 ✖
- Popular Democrat 16
- Unionist 14
- Democrat 9
- Coalitionist 7
- New Progressive 6
- Republican 6
- AL 1
- Nonpartisan 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14287 | 14287 | Federico Degetau D000196 | rep | PR | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
14288 | 14288 | Federico Degetau D000196 | rep | PR | 1903-11-09 | 1905-03-03 | Republican | 0 | |||||||||||||
15589 | 15589 | Tulio Larrinaga L000102 | rep | PR | 1905-12-04 | 1907-03-03 | Unionist | 0 | |||||||||||||
15590 | 15590 | Tulio Larrinaga L000102 | rep | PR | 1907-12-02 | 1909-03-03 | Unionist | 0 | |||||||||||||
15591 | 15591 | Tulio Larrinaga L000102 | rep | PR | 1909-03-15 | 1911-03-03 | Unionist | 0 | |||||||||||||
16940 | 16940 | Luis Rivera R000279 | rep | PR | 1911-04-04 | 1913-03-03 | Unionist | 0 | |||||||||||||
16941 | 16941 | Luis Rivera R000279 | rep | PR | 1913-04-07 | 1915-03-03 | Unionist | 0 | |||||||||||||
16942 | 16942 | Luis Rivera R000279 | rep | PR | 1915-12-06 | 1917-03-03 | Unionist | 0 | |||||||||||||
20330 | 20330 | Félix Dávila D000090 | rep | PR | 1917-04-02 | 1919-03-03 | Unionist | 0 | |||||||||||||
20331 | 20331 | Félix Dávila D000090 | rep | PR | 1919-05-19 | 1921-03-03 | Unionist | 0 | |||||||||||||
20332 | 20332 | Félix Dávila D000090 | rep | PR | 1921-04-11 | 1923-03-03 | Unionist | 0 | |||||||||||||
20333 | 20333 | Félix Dávila D000090 | rep | PR | 1923-12-03 | 1925-03-03 | Unionist | 0 | |||||||||||||
20334 | 20334 | Félix Dávila D000090 | rep | PR | 1925-12-07 | 1927-03-04 | Unionist | 0 | |||||||||||||
20335 | 20335 | Félix Dávila D000090 | rep | PR | 1927-12-05 | 1929-03-03 | Unionist | 0 | |||||||||||||
20336 | 20336 | Félix Dávila D000090 | rep | PR | 1929-04-15 | 1931-03-03 | Unionist | 0 | |||||||||||||
20337 | 20337 | Félix Dávila D000090 | rep | PR | 1931-12-07 | 1933-03-03 | Unionist | 0 | |||||||||||||
20773 | 20773 | José Pesquera P000249 | rep | PR | 1931-12-07 | 1933-03-03 | Nonpartisan | 0 | |||||||||||||
22632 | 22632 | Santiago Iglesias I000002 | rep | PR | 1933-03-09 | 1935-01-03 | Coalitionist | 0 | |||||||||||||
22633 | 22633 | Santiago Iglesias I000002 | rep | PR | 1935-01-03 | 1937-01-03 | Coalitionist | 0 | |||||||||||||
22634 | 22634 | Santiago Iglesias I000002 | rep | PR | 1937-01-05 | 1939-01-03 | Coalitionist | 0 | |||||||||||||
22635 | 22635 | Santiago Iglesias I000002 | rep | PR | 1939-01-03 | 1941-01-03 | Coalitionist | 0 | |||||||||||||
23643 | 23643 | Bolívar Pagán P000013 | rep | PR | 1939-01-03 | 1941-01-03 | Coalitionist | 0 | |||||||||||||
23644 | 23644 | Bolívar Pagán P000013 | rep | PR | 1941-01-03 | 1943-01-03 | Coalitionist | 0 | |||||||||||||
23645 | 23645 | Bolívar Pagán P000013 | rep | PR | 1943-01-06 | 1945-01-03 | Coalitionist | 0 | |||||||||||||
24041 | 24041 | Jesús Piñero P000361 | rep | PR | 1945-01-03 | 1947-01-03 | Popular Democrat | 0 | |||||||||||||
27771 | 27771 | Antonio Fernós-Isern F000087 | rep | PR | 1945-01-03 | 1947-01-03 | Popular Democrat | 0 | |||||||||||||
27772 | 27772 | Antonio Fernós-Isern F000087 | rep | PR | 1947-01-03 | 1949-01-03 | Popular Democrat | 0 | |||||||||||||
27773 | 27773 | Antonio Fernós-Isern F000087 | rep | PR | 1949-01-03 | 1951-01-03 | Popular Democrat | 0 | |||||||||||||
27774 | 27774 | Antonio Fernós-Isern F000087 | rep | PR | 1951-01-03 | 1953-01-03 | Popular Democrat | 0 | |||||||||||||
27775 | 27775 | Antonio Fernós-Isern F000087 | rep | PR | 1953-01-03 | 1955-01-03 | Popular Democrat | 0 | |||||||||||||
27776 | 27776 | Antonio Fernós-Isern F000087 | rep | PR | 1955-01-05 | 1957-01-03 | Popular Democrat | 0 | |||||||||||||
27777 | 27777 | Antonio Fernós-Isern F000087 | rep | PR | 1957-01-03 | 1959-01-03 | Popular Democrat | 0 | |||||||||||||
27778 | 27778 | Antonio Fernós-Isern F000087 | rep | PR | 1959-01-07 | 1961-01-03 | Popular Democrat | 0 | |||||||||||||
27779 | 27779 | Antonio Fernós-Isern F000087 | rep | PR | 1961-01-03 | 1963-01-03 | Popular Democrat | 0 | |||||||||||||
27780 | 27780 | Antonio Fernós-Isern F000087 | rep | PR | 1963-01-09 | 1965-01-03 | Popular Democrat | 0 | |||||||||||||
29007 | 29007 | Santiago Polanco-Abreu P000405 | rep | PR | 1965-01-04 | 1967-01-03 | Popular Democrat | 0 | |||||||||||||
29008 | 29008 | Santiago Polanco-Abreu P000405 | rep | PR | 1967-01-10 | 1969-01-03 | Popular Democrat | 0 | |||||||||||||
29733 | 29733 | Jorge Córdova Díaz C000775 | rep | PR | 1969-01-03 | 1971-01-03 | New Progressive | 0 | |||||||||||||
29734 | 29734 | Jorge Córdova Díaz C000775 | rep | PR | 1971-01-21 | 1973-01-03 | New Progressive | 0 | |||||||||||||
30848 | 30848 | Jaime Benítez B000362 | rep | PR | 1973-01-03 | 1975-01-03 | Popular Democrat | 0 | |||||||||||||
30849 | 30849 | Jaime Benítez B000362 | rep | PR | 1975-01-14 | 1977-01-03 | Popular Democrat | 0 | |||||||||||||
32936 | 32936 | Baltasar Corrada-del Río C000788 | rep | PR | 1977-01-04 | 1979-01-03 | New Progressive | 0 | |||||||||||||
32937 | 32937 | Baltasar Corrada-del Río C000788 | rep | PR | 1979-01-15 | 1981-01-03 | New Progressive | 0 | |||||||||||||
32938 | 32938 | Baltasar Corrada-del Río C000788 | rep | PR | 1981-01-05 | 1983-01-03 | New Progressive | 0 | |||||||||||||
32939 | 32939 | Baltasar Corrada-del Río C000788 | rep | PR | 1983-01-03 | 1985-01-03 | New Progressive | 0 | |||||||||||||
34324 | 34324 | Antonio Colorado C000646 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34466 | 34466 | Jaime Fuster F000435 | rep | PR | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
34467 | 34467 | Jaime Fuster F000435 | rep | PR | 1987-01-06 | 1989-01-03 | Democrat | 0 | |||||||||||||
34468 | 34468 | Jaime Fuster F000435 | rep | PR | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
34469 | 34469 | Jaime Fuster F000435 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
36351 | 36351 | Carlos Romero-Barceló R000417 | rep | PR | 1993-01-05 | 1997-01-03 | Democrat | 0 | |||||||||||||
36352 | 36352 | Carlos Romero-Barceló R000417 | rep | PR | 1997-01-07 | 2001-01-03 | Democrat | 0 | |||||||||||||
37222 | 37222 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2001-01-03 | 2003-01-03 | AL | 0 | |||||||||||||
37223 | 37223 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2003-01-07 | 2005-01-03 | Popular Democrat | 0 | http://www.house.gov/acevedo-vila | ||||||||||||
38045 | 38045 | Luis Fortuño F000452 | rep | PR | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/fortuno | ||||||||||||
38046 | 38046 | Luis Fortuño F000452 | rep | PR | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/fortuno | ||||||||||||
40426 | 40426 | Pedro Pierluisi P000596 | rep | PR | 2009-01-06 | 2013-01-03 | Democrat | 0 | http://pierluisi.house.gov | 1213 Longworth HOB; Washington DC 20515-5401 | 202-225-2615 | 202-225-2154 | https://forms.house.gov/pierluisi/contact-form.shtml | 1213 Longworth House Office Building | |||||||
40427 | 40427 | Pedro Pierluisi P000596 | rep | PR | 2013-01-03 | 2017-01-03 | Democrat | 0 | http://pierluisi.house.gov | 2410 Rayburn HOB; Washington DC 20515-5401 | 202-225-2615 | 202-225-2154 | https://pierluisi.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://pierluisi.house.gov/rss.xml | ||||||
44210 | 44210 | Jenniffer González-Colón G000582 | rep | PR | 2017-01-03 | 2021-01-03 | Republican | 0 | https://gonzalez-colon.house.gov | 1609 Longworth House Office Building Washington DC 20515-5401 | 202-225-2615 | 1609 Longworth House Office Building | |||||||||
44211 | 44211 | Jenniffer González-Colón G000582 | rep | PR | 2021-01-03 | 2023-01-03 | Republican | 0 | https://gonzalez-colon.house.gov | 2338 Rayburn House Office Building Washington DC 20515-5401 | 202-225-2615 | 2338 Rayburn House Office Building |
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);