FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Cabrera"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 7
Registrant_Name 7
City 5
- New York 3
- Chicago 1
- Los Angeles 1
- Montebello 1
- New Orleans 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6274 | 6274 | 1960-02-07 | 1946-10-15 | Cabrera | Joaquin F. | Union Nacional Sinarquista, Inc. 367 | 1946-08-16 | Union Nacional Sinarquista, Inc. | 120 North 10th Street | Montebello | CA | ||
9084 | 9084 | 1968-03-04 | 1944-01-31 | Cabrera | Martin | Comite Regional Sinarquista en Los Angeles 139 | 1942-10-08 | Comite Regional Sinarquista en Los Angeles | 727 Camulos Street | Los Angeles | CA | ||
9212 | 9212 | 1961-03-06 | 1961-03-06 | Cabrera | Juan F. | Jules A. Des Angles Company, Inc. 1432 | 1961-03-06 | Jules A. Des Angles Company, Inc. | 408 East 11th Street | New York | NY | ||
17481 | 17481 | 1997-05-30 | 1995-02-10 | Cabrera | Myrna | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
26813 | 26813 | 1960-08-16 | 1960-07-14 | Cabrera | Henry | Comite de Ayuda Pro Liberacion de Nicaragua 1377 | 1960-07-14 | Comite de Ayuda Pro Liberacion de Nicaragua | Post Office Box 2432 | New Orleans | LA | ||
27426 | 27426 | 1992-08-25 | 1990-11-05 | Cabrera | Carroll | Ruder Finn, Inc. 4430 | 1990-11-05 | Ruder Finn, Inc. | 444 North Michigan Avenue | Suite 1600 | Chicago | IL | 60611 |
41383 | 41383 | 2005-12-31 | 2005-01-31 | Cabrera | Melissa | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | 825 Seventh Avenue | New York | NY | 10019 |
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]) );