FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Short_Form_First_Name = "Guillermo"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13181 | 13181 | 1995-04-11 | 1991-05-09 | Guemez | Guillermo | Coordinadora de Organizaciones Empresariales de Comercio Ext 4498 | 1991-04-12 | Coordinadora de Organizaciones Empresariales de Comercio Ext | 1025 Thomas Jeff. Street, N.W. | East Lobby, 7th Floor | Washington | DC | 20007 |
23496 | 23496 | 1979-07-18 | 1977-11-11 | Lora | Guillermo | Movimiento de Integracion Democratica Antirreleccionists 2845 | 1977-11-11 | Movimiento de Integracion Democratica Antirreleccionists | 313 Broadway | Lawrence | MA | 01841 | |
25068 | 25068 | 2005-07-31 | 2004-06-01 | Jordan-Lynch | Guillermo | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
25428 | 25428 | 1946-08-01 | 1945-08-01 | Pasos-Montiel | Guillermo | MacVane, John 3121 | 1980-07-03 | MacVane, John | United Nations | Room 368 | New York | NY | 10017 |
30052 | 30052 | 1977-09-19 | 1971-07-22 | Belt | Guillermo | Columbus Lighthouse Committee of America 2163 | 1969-09-24 | Columbus Lighthouse Committee of America | 766 West Shore Road | Post Office Box 486 | Warwick | RI | 02889 |
42301 | 42301 | 2020-12-31 | 2021-01-15 | Blanco | Guillermo | PDV USA, Inc. 6903 | 2020-12-31 | PDV USA, Inc. | 65 East 55th Street | New York | NY | 10022 |
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]) );