FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Foreign_Principal_Termination_Date" is on date 1986-04-01 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 7
Country/Location_Represented 7
- ARGENTINA 1
- AUSTRIA 1
- FRANCE 1
- JAPAN 1
- NETHERLANDS 1
- NETHERLANDS ANTILLES 1
- POLAND 1
Registrant_Name 6
Address_1 4 ✖
- - 4
- Buenos Aires 1
- Paris 1
- Scarsdale 1
City 1
- - 7
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal ▼ | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4896 | 4896 | 1986-04-01 | Aerolineas Argentinas | 1978-08-06 | ARGENTINA | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | Buenos Aires | ||||
4897 | 4897 | 1986-04-01 | Austrian Federal Chancellery-Federal Press & Information Service | 1984-02-04 | AUSTRIA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
4898 | 4898 | 1986-04-01 | French Government Tourist Office | 1980-11-28 | FRANCE | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | Paris | ||||
4899 | 4899 | 1986-04-01 | Fujinon, Inc. | 1985-05-21 | JAPAN | Daniel J. Piliero, II, P.C. 3680 | 1985-05-21 | Daniel J. Piliero, II, P.C. | Scarsdale | NY | |||
4900 | 4900 | 1986-04-01 | Noro Realty Advisors, Inc. | 1986-04-10 | NETHERLANDS | King & Spalding 3812 | 1986-04-10 | King & Spalding | |||||
4901 | 4901 | 1986-04-01 | ORBIS | 1968-04-04 | POLAND | Polish National Tourist Office, New York 2086 | 1968-04-04 | Polish National Tourist Office, New York | |||||
4902 | 4902 | 1986-04-01 | Transcontinental Services Group, N.V. | 1986-04-23 | NETHERLANDS ANTILLES | Royer & Babyak 3818 | 1986-04-23 | Royer & Babyak |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );