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 = "Cabral"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_2, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13572 | 13572 | 1992-04-16 | 1980-07-14 | Cabral | Victor | Dominican Tourist Information Center, Inc. 3114 | 1980-06-24 | Dominican Tourist Information Center, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
14463 | 14463 | 1968-04-30 | 1964-05-11 | Cabral | Martim Lencastre | Downs & Roosevelt, Inc. 1726 | 1964-05-11 | Downs & Roosevelt, Inc. | 1629 K Street, N.W. | Washington | DC | 20006 | |
26305 | 26305 | 1973-08-09 | 1959-07-06 | Cabral | Jose | Portuguese National Tourist Office 172 | 1943-01-23 | Portuguese National Tourist Office | 570 Fifth Avenue | New York | NY | 10036 | |
28898 | 28898 | 1993-09-01 | 1993-01-29 | Cabral | Debra | Capitol Group, Inc. 4682 | 1992-06-08 | Capitol Group, Inc. | 1001 Pennsylvania Avenue, N.W. | Suite 1385 | Washington | DC | 20004 |
30404 | 30404 | 1964-09-25 | 1963-01-02 | Cabral | Martim Lencastre | Selvage & Lee, Inc. 1454 | 1961-05-29 | Selvage & Lee, Inc. | 500 Fifth Avenue | New York | NY | ||
32639 | 32639 | 2016-10-11 | 2016-10-04 | Cabral | Ramon R. | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35107 | 35107 | 1992-11-02 | 1992-03-18 | Cabral | Debra M. | Nutter & Harris, Inc. 4635 | 1992-03-18 | Nutter & Harris, Inc. | 927 15th Street, N.W. | 3rd Floor | Washington | DC | 20005 |
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]) );