FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Pereira"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_1, Address_2, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
616 | 616 | 2023-03-21 | Pereira | Atricia | British Virgin Islands Tourist Board 3354 | 1982-04-08 | British Virgin Islands Tourist Board | 1 West 34th Street | Suite 302 | New York | NY | 10001-3011 | |
7875 | 7875 | 1975-02-28 | 1972-12-27 | Pereira | E. | Government of India Tourist Office, Chicago 2398 | 1972-12-27 | Government of India Tourist Office, Chicago | 5701 North Sheridan Road | Chicago | IL | 60660 | |
23149 | 23149 | 1946-07-15 | 1946-07-25 | Pereira | Jose' Giral | Asensio, Jose' 41 | 1942-07-13 | Asensio, Jose' | Post Office Box 41 | Station North | New York | NY | |
24226 | 24226 | 2007-07-27 | 2007-06-29 | Pereira | Camilo | Sitrick and Company, Inc. 5777 | 2006-11-20 | Sitrick and Company, Inc. | 1840 Century Park East | Suite 800 | Los Angeles | CA | 90067-2109 |
33520 | 33520 | 2020-10-23 | 2019-01-02 | Pereira | Roman Francis | India Tourism, New York 2329 | 1972-04-05 | India Tourism, New York | 1270 Avenue of the Americas | Suite 303 | New York | NY | 10020-1700 |
33525 | 33525 | 2020-10-23 | 2020-12-15 | Pereira | Roman Francis | India Tourism, New York 2329 | 1972-04-05 | India Tourism, New York | 1270 Avenue of the Americas | Suite 303 | New York | NY | 10020-1700 |
35455 | 35455 | 2012-11-08 | 2009-03-24 | Pereira | Shana | Tourism Queensland 4146 | 1988-05-31 | Tourism Queensland | 6100 Center Drive | Suite 1150 | Los Angeles | CA | 90045 |
42308 | 42308 | 2020-12-31 | 2021-01-15 | Pereira | Jose | 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]) );