FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "Santurce"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date)
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9200 | 9200 | 1946-03-06 | 1944-09-11 | Arzeno | Rafael Ortiz | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico 279 | 1944-09-11 | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico | 21 De Diego Avenue | Santurce | |||
9201 | 9201 | 1946-03-06 | 1944-09-11 | Joubert | Jose Tio | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico 279 | 1944-09-11 | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico | 21 De Diego Avenue | Santurce | |||
9202 | 9202 | 1946-03-06 | 1944-09-11 | Martinez | Gilberto | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico 279 | 1944-09-11 | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico | 21 De Diego Avenue | Santurce | |||
9203 | 9203 | 1946-03-06 | 1944-09-11 | Pardo | Miguel A. | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico 279 | 1944-09-11 | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico | 21 De Diego Avenue | Santurce | |||
9204 | 9204 | 1946-03-06 | 1944-09-11 | Zeno | Arturo Rafael | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico 279 | 1944-09-11 | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico | 21 De Diego Avenue | Santurce | |||
19547 | 19547 | 1987-06-15 | 1985-12-02 | Torres | Saul Perez | Partido de la Liberacion Dominicana, Santurce 3664 | 1985-03-27 | Partido de la Liberacion Dominicana, Santurce | Lippit 405 Altos | Santurce | PR | 00915 | |
19731 | 19731 | 1963-06-17 | 1965-05-14 | Echevarria | Agustin | Publicidad Antillas, Inc. 1893 | 1965-05-14 | Publicidad Antillas, Inc. | 1556 Ponce de Leon Avenue | Santurce | |||
19732 | 19732 | 1963-06-17 | 1965-05-14 | Echevarria | Conchita | Publicidad Antillas, Inc. 1893 | 1965-05-14 | Publicidad Antillas, Inc. | 1556 Ponce de Leon Avenue | Santurce | |||
22412 | 22412 | 1946-07-02 | 1944-09-30 | Ellis-Cambiaso | Frederick | Comite Central de la Union Patriotica Dominicana 286 | 1945-01-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce | ||
22413 | 22413 | 1946-07-02 | 1944-09-30 | Hernandez | Federico Velazquez | Comite Central de la Union Patriotica Dominicana 286 | 1945-01-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce | ||
22414 | 22414 | 1946-07-02 | 1944-09-30 | Hernandez | Guaroa Velazquez | Comite Central de la Union Patriotica Dominicana 286 | 1945-01-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce | ||
22415 | 22415 | 1946-07-02 | 1944-09-30 | Morales | Angel Francisco | Comite Central de la Union Patriotica Dominicana 286 | 1945-01-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce | ||
22416 | 22416 | 1946-07-02 | 1944-09-30 | Pou | Oscar Michelena | Comite Central de la Union Patriotica Dominicana 286 | 1945-01-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce | ||
22417 | 22417 | 1946-07-02 | 1944-09-30 | Vilomar | Virgillio Osvaldo | Comite Central de la Union Patriotica Dominicana 286 | 1945-01-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );